/class.xmodinfotree.inc

https://github.com/jcplat/console-seolan · PHP · 3241 lines · 2746 code · 202 blank · 293 comment · 486 complexity · b4262d8cd9d943f98eb8bdfea8d16a4f MD5 · raw file

Large files are truncated click here to view the full file

    

  1. <?php
    2. 

  2. /****c* XModule/XModInfoTree
    3. 

  3.  * NAME
    4. 

  4.  *   XModInfoTree -- gestion d'un ensemble de rubriques structurees
    5. 

  5.  * DESCRIPTION
    6. 

  6.  *   Module central de gestion d'un site internet, integrant la
    7. 

  7.  *   gestion de rubriques structurees, le rattachement d'informations
    8. 

  8.  *   a ces rubriques, ainsi que la creation de requetes.
    9. 

  9.  * SYNOPSIS
    10. 

  10.  ****/
    11. 

  11. /// Module de gestion d'un ensemble de rbriques et de pages web
    12. 

  12. class XModInfoTree extends XModule {
    13. 

  13.   public $table = 'T001';
    14. 

  14.   public $_rbrowse=NULL;
    15. 

  15.   public $cattemplate=NULL;
    16. 

  16.   public $preview='/index.php?_cachepolicy=forcecache';
    17. 

  17.   public $linkin='';
    18. 

  18.   public $urlext='';
    19. 

  19. 

  20.   /// construction de la classe gestion de rubriques
    21. 

  21.   function __construct($ar=NULL) {
    22. 

  22.     parent::__construct($ar);
    23. 

  23.     XLabels::loadLabels('xmodinfotree');
    24. 

  24.     $this->_categories=XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS='.$this->table);
    25. 

  25.     $this->tname='IT'.$this->table;
    26. 

  26.     if(empty($this->_templates))
    27. 

  27.       $this->_templates=XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS=TEMPLATES');
    28. 

  28.     XAlias::register($this);
    29. 

  29.   }
    30. 

  30. 

  31.   /// initialisation des options
    32. 

  32.   public function initOptions() {
    33. 

  33.     parent::initOptions();
    34. 

  34.     $this->_options->setOpt(XLabels::getSysLabel('general','table'), 'table', 'table',array('validate'=>true));
    35. 

  35.     $this->_options->setOpt(XLabels::getSysLabel('xmodinfotree','cattemplate'), 'cattemplate', 'template',
    36. 

  36. 			    array('moid'=>$this->_moid,
    37. 

  37. 				  'cond'=>"(gtype like 'categorie')"));
    38. 

  38.     $this->_options->setOpt(XLabels::getSysLabel('general','preview','text'), 'preview', 'text',NULL,'index.php?');
    39. 

  39.     $this->_options->setOpt(XLabels::getSysLabel('xmodinfotree','linkinfield','text'), 'linkin', 'field',
    40. 

  40. 			    array('compulsory'=>false),'linkin');
    41. 

  41.     $this->_options->setOpt(XLabels::getSysLabel('xmodinfotree','urlextfield','text'), 'urlext', 'field',
    42. 

  42. 			    array('compulsory'=>false),'urlext');
    43. 

  43. 

  44.     $this->_options->setOpt(XLabels::getSysLabel('xmodinfotree','odt_texttpl','text'), 'odttpltxt', 'template',
    45. 

  45. 			    array('compulsory'=>false),NULL,'ODT');
    46. 

  46.     $this->_options->setOpt(XLabels::getSysLabel('xmodinfotree','odt_texttitlefield','text'), 'odttxttitlefield', 'text', NULL, 'title','ODT');
    47. 

  47.     $this->_options->setOpt(XLabels::getSysLabel('xmodinfotree','odt_textfield','text'), 'odttxtfield', 'text', NULL, 'txt1','ODT');
    48. 

  48.     $this->_options->setOpt(XLabels::getSysLabel('xmodinfotree','odt_imagetpl','text'), 'odttplimg', 'template',
    49. 

  49. 			    array('compulsory'=>false),NULL,'ODT');
    50. 

  50.     $this->_options->setOpt(XLabels::getSysLabel('xmodinfotree','odt_imagefield','text'), 'odtimgfield', 'text', NULL,'img1','ODT');
    51. 

  51.     $this->_options->setOpt(XLabels::getSysLabel('xmodinfotree','pdf_enabled','text'), 'pdf_enabled', 'boolean', NULL,false,'PDF');
    52. 

  52.     $this->_options->setOpt(XLabels::getSysLabel('xmodinfotree','pdf_css','text'), 'pdf_css', 'text', NULL,'css/pdf.css','PDF');
    53. 

  53.     $this->_options->setOpt(XLabels::getSysLabel('xmodinfotree','pdf_css_content','text'), 'pdf_css_content', 'text', NULL,'css/page-content.css','PDF');
    54. 

  54.     $tlabel=XLabels::getSysLabel('xmodule.tracking');
    55. 

  55.     $this->_options->setOpt(XLabels::getSysLabel('xfielddef','trackchanges'),'trackchanges','boolean',NULL,NULL,$tlabel);
    56. 

  56.   }
    57. 

  57. 

  58.   /// securite des fonctions accessibles par le web
    59. 

  59.   function secGroups($function, $group=NULL) {
    60. 

  60.     $g=array('home'=>array('list','ro','rw','rwv','admin'),
    61. 

  61. 	     'procHome'=>array('rw','rwv','admin'),
    62. 

  62. 	     'rss'=>array('ro','rw','rwv','admin'),
    63. 

  63. 	     'viewpage'=>array('ro','rw','rwv','admin'),
    64. 

  64. 	     'viewsection'=>array('ro','rw','rwv','admin'),
    65. 

  65. 	     'procQuery'=>array('ro','rw','rwv','admin'),
    66. 

  66. 	     'query'=>array('ro','rw','rwv','admin'),
    67. 

  67. 	     'browse'=>array('ro','rw','rwv','admin'),
    68. 

  68. 	     'input'=>array('rw','rwv','admin'),
    69. 

  69. 	     'procInput'=>array('rw','rwv','admin'),
    70. 

  70. 	     'addSection'=>array('rw','rwv','admin'),
    71. 

  71. 	     'newsection'=>array('rw','rwv','admin'),
    72. 

  72. 	     'insertsection'=>array('rw','rwv','admin'),
    73. 

  73. 	     'editsection'=>array('rw','rwv','admin'),
    74. 

  74. 	     'savesection'=>array('rw','rwv','admin'),
    75. 

  75. 	     'newfunction'=>array('rw','rwv','admin'),
    76. 

  76. 	     'insertfunction'=>array('rw','rwv','admin'),
    77. 

  77. 	     'editfunction'=>array('rw','rwv','admin'),
    78. 

  78. 	     'savefunction'=>array('rw','rwv','admin'),
    79. 

  79. 	     'insertquery'=>array('rw','rwv','admin'),
    80. 

  80. 	     'editquery'=>array('rw','rwv','admin'),
    81. 

  81. 	     'savequery'=>array('rw','rwv','admin'),
    82. 

  82. 	     'delSection'=>array('rw','rwv','admin'),
    83. 

  83. 	     'editpage'=>array('rw','rwv','admin'),
    84. 

  84. 	     'delCat'=>array('rw','rwv','admin'),
    85. 

  85. 	     'dupCat'=>array('rw','rwv','admin'),
    86. 

  86. 	     'procEdit'=>array('rw','rwv','admin'),
    87. 

  87. 	     'procEditAllLang'=>array('rw','rwv','admin'),
    88. 

  88. 	     'editCat'=>array('rw','rwv','admin'),
    89. 

  89. 	     'moveCat'=>array('rw','rwv','admin'),
    90. 

  90. 	     'moveSection'=>array('rw','rwv','admin'),
    91. 

  91. 	     'moveSelectedCat'=>array('rw','rwv','admin'),
    92. 

  92. 	     'moveToTrash'=>array('rw','rwv','admin'),
    93. 

  93. 	     'displayImage'=>array('rw','rwv','admin'),
    94. 

  94. 	     'displaysection'=>array('ro','rw','rwv','admin'),
    95. 

  95. 	     'dupsection'=>array('rw','rwv','admin'),
    96. 

  96. 	     'publishCat'=>array('rwv','admin'),
    97. 

  97. 	     'subscribe'=>array('ro','rw','rwv','admin'),
    98. 

  98. 	     'preSubscribe'=>array('ro','rw','rwv','admin'),
    99. 

  99. 	     'export'=>array('ro','rw','rwv','admin'),
    100. 

  100. 	     'exportPdf'=>array('ro','rw','rwv','admin'),
    101. 

  101. 	     'publish'=>array('rwv','admin'),
    102. 

  102. 	     'preImportFromODT'=>array('rw','rwv','admin'),
    103. 

  103. 	     'importFromODT'=>array('rw','rwv','admin'),
    104. 

  104. 	     'adminNewSection'=>array('rw','rwv','admin'),
    105. 

  105. 	     'adminProcNewSection'=>array('rw','rwv','admin'));
    106. 

  106.     if(isset($g[$function])) {
    107. 

  107.       if(!empty($group)) return in_array($group, $g[$function]);
    108. 

  108.       else return $g[$function];
    109. 

  109.     }
    110. 

  110.     return parent::secGroups($function,$group);
    111. 

  111.   }
    112. 

  112. 

  113.   /// Action principale du menu
    114. 

  114.   public function getMainAction(){
    115. 

  115.     return $GLOBALS['TZR_SESSION_MANAGER']::complete_self().'moid='.$this->_moid.'&function=home&tplentry=mit&template=xmodinfotree/index.html';
    116. 

  116.   }
    117. 

  117. 

  118. 

  119.   /// list des tables dont on souhaite tracer les modifications
    120. 

  120.   function tablesToTrack() {
    121. 

  121.     $ret=array();
    122. 

  122.     if($this->trackchanges) {
    123. 

  123.       $tabs=selectQueryGetAll('SELECT DISTINCT tab FROM TEMPLATES WHERE modid=\''.$this->_moid.'\'');
    124. 

  124.       $ret=array($this->table);
    125. 

  125.       foreach($tabs as $tab) {
    126. 

  126. 	$ret[]=$tab['tab'];
    127. 

  127.       }
    128. 

  128.     }
    129. 

  129.     return $ret;
    130. 

  130.   }
    131. 

  131. 

  132.   /// Prepare l'ajout d'une nouvelle section function
    133. 

  133.   public function newfunction($ar=NULL){
    134. 

  134.     $p=new XParam($ar,NULL);
    135. 

  135.     $tplentry=$p->get('tplentry');
    136. 

  136.     $oidit=$p->get('oidit');
    137. 

  137.     $oidtpl=$p->get('oidtpl');
    138. 

  138.     $lang=XShell::getLangData();
    139. 

  139.     $tabletpl=Kernel::getTable($oidtpl);
    140. 

  140.     $rs=selectQuery('select * from '.$tabletpl.' where KOID="'.$oidtpl.'" AND LANG="'.$lang.'"');
    141. 

  141.     if($rs && $o1=$rs->fetch()) {
    142. 

  142.       $tabledst=$o1['tab'];
    143. 

  143.       // Infos d'affichage du template
    144. 

  144.       $template = $this->_disp2Template($oidtpl);
    145. 

  145.       $s['_tp'] = $template;
    146. 

  146. 

  147.       $s['section']=$p->get('section');
    148. 

  148.       $s['position']=$p->get('position');
    149. 

  149.       $s['oidit']=$p->get('oidit');
    150. 

  150.       $s['oidtpl']=$p->get('oidtpl');
    151. 

  151.       $moid=$s['section']['moid'];
    152. 

  152.       $f=$s['section']['function'];
    153. 

  153.       $pf='UIParam_'.$f;
    154. 

  154.       $ef='UIEdit_'.$f;
    155. 

  155.       $m=XModule::objectFactory($moid);
    156. 

  156.       if(method_exists($m,$ef)) $ret=$m->$ef();
    157. 

  157.       else{
    158. 

  158. 	$desc=$m->$pf();
    159. 

  159. 	$ret=array('fields_object'=>array());
    160. 

  160. 	foreach($desc as $fn=>&$f){
    161. 

  161. 	  $o=$desc[$fn]->edit();
    162. 

  162. 	  $ret['o'.$fn]=$ret['fields_object'][]=$o;
    163. 

  163. 	}
    164. 

  164.       }
    165. 

  165.       $this->editTemplateOptions($ret, $oidtpl, $s['oidit']);
    166. 

  166.       $groups=array();
    167. 

  167.       foreach($ret as $n=>&$v) {
    168. 

  168. 	if(!is_object($v) || !is_object($v->fielddef)) continue;
    169. 

  169. 	if(empty($v->fielddef->fgroup)) $v->fielddef->fgroup='General';
    170. 

  170. 	$groups[$v->fielddef->fgroup][]=&$v;
    171. 

  171.       }
    172. 

  172.       ksort($groups);
    173. 

  173.       if(count($groups)>1) $ret['_groups']=$groups;
    174. 

  174.       $s['olines'][]=$ret;
    175. 

  175.       XShell::toScreen1($tplentry,$s);
    176. 

  176.     }
    177. 

  177.   }
    178. 

  178. 

  179.   /// Duplication d'un module, méthode interne
    180. 

  180.   /// Retour : duplicatetables => liste des tables dupliquées par le module (cle : ancienne table, valeur : nouvelle table))
    181. 

  181.   /// Retour : duplicatemods => liste des modules dupliqués par le module (cle : ancien moid, valeur : nouveau moid))
    182. 

  182.   function _duplicateModule($newmoid,&$params,$prefix) {
    183. 

  183.     if(!is_array($params['tables'])) $params['tables']=array();
    184. 

  184.     if(!$params['noduplicatetable']){
    185. 

  185.       // duplication de la table des rubriques
    186. 

  186.       if(empty($params['tables'][$this->table])){
    187. 

  187. 	$ar['newtable']=XDSTable::newTableNumber();
    188. 

  188. 	$xset = XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS='.$this->table);
    189. 

  189. 	if(($pos=strpos($xset->getLabel(),':'))!==false) $ar['mtxt']=$prefix.substr($xset->getLabel(),$pos);
    190. 

  190. 	else $ar['mtxt']=$prefix.':'.$xset->getLabel();
    191. 

  191. 	$ar['data']=false;
    192. 

  192. 	$ar['_options']=array('local'=>1);
    193. 

  193. 	$xset2=$xset->procDuplicateDataSource($ar);
    194. 

  194. 	// correction du lien vers la rubrique mere
    195. 

  195. 	$xset21=XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS='.$ar['newtable']);
    196. 

  196. 	$xset21->procEditField(array('field'=>'linkup','table'=>$newtable,'_todo'=>'save','target'=>$ar['newtable'],
    197. 

  197. 			    'published'=>'off','queryable'=>'on','browsable'=>'on','compulsory'=>'off','translatable'=>'off',
    198. 

  198. 			    'options'=>array('comment'=>array('FR'=>'Rubrique mere'))));
    199. 

  199. 	$params['table']=$ar['newtable'];
    200. 

  200.       }else{
    201. 

  201. 	$params['table']=$params['tables'][$this->table];
    202. 

  202.       }
    203. 

  203.       // creation de la table des liens
    204. 

  204.       XModInfoTreeWd::createLinkStructure($params['table']);
    205. 

  205. 

  206.       // duplication des mises en page/gabarits
    207. 

  207.       $rs=selectQuery('SELECT KOID FROM TEMPLATES WHERE modid =\''.$this->_moid.'\'');
    208. 

  208.       $xset = XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS=TEMPLATES');
    209. 

  209.       while($rs && $ors=$rs->fetch()) {
    210. 

  210. 	$ardup=array('_options'=>array('local'=>1));
    211. 

  211. 	$ardup['oid']=$ors['KOID'];
    212. 

  212. 	$nkoid=$xset->duplicate($ardup);
    213. 

  213. 	preparedUpdateQuery('UPDATE TEMPLATES set modid=? where KOID=?',array($newmoid,$nkoid));
    214. 

  214.       }
    215. 

  215.     }
    216. 

  216.     unset($params['noduplicatetable']);
    217. 

  217.     return array('duplicatetables'=>array($this->table=>$params['table']),'duplicatemods'=>array());
    218. 

  218.   }
    219. 

  219. 

  220.   /// Enregistre une section de type fonction
    221. 

  221.   public function insertfunction($ar=NULL){
    222. 

  222.     $p=new XParam($ar,NULL);
    223. 

  223.     $oidit=$p->get('oidit');
    224. 

  224.     $oidtpl=$p->get('oidtpl');
    225. 

  225.     $position=$p->get('position')+1;
    226. 

  226.     $section=$p->get('section');
    227. 

  227.     $moid=$section['moid'];
    228. 

  228.     $f=$section['function'];
    229. 

  229.     $pf='UIParam_'.$f;
    230. 

  230.     $ef='UIProcEdit_'.$f;
    231. 

  231.     $m=XModule::objectFactory($moid);
    232. 

  232.     if(method_exists($m,$ef)){
    233. 

  233.       $ret=$m->$ef($ar);
    234. 

  234.       if($ret) $section=array_merge($section,$ret);
    235. 

  235.     }else{
    236. 

  236.       $desc=$m->$pf();
    237. 

  237.       $options=array('_track'=>false);
    238. 

  238.       foreach($desc as $fn=>&$f){
    239. 

  239. 	$value=$p->get($fn);
    240. 

  240. 	$value_hid=$p->get($fn.'_HID');
    241. 

  241. 	$options[$fn.'_HID']=$value_hid;
    242. 

  242. 	$o=$desc[$fn]->post_edit($value,$options);
    243. 

  243. 	if($f->multivalued && $f->get_fgender()=='Oid' && is_array($o->raw)){
    244. 

  244. 	  $o->raw=implode('||',$o->raw);
    245. 

  245. 	}
    246. 

  246. 	$section[$fn]=$o->raw;
    247. 

  247.       }
    248. 

  248.     }
    249. 

  249.     $val=addslashes(serialize($section));
    250. 

  250.     $nitoid=self::newItOid();
    251. 

  251.     updateQuery("UPDATE ".$this->tname." SET ORDER1=ORDER1+1 where KOIDSRC='$oidit' ".
    252. 

  252.                 " AND ORDER1 >= $position");
    253. 

  253.     updateQuery('INSERT INTO '.$this->tname.' SET KOIDSRC="'.$oidit.'",KOIDDST="",KOIDTPL="'.$oidtpl.'",ORDER1="'.$position.'",'.
    254. 

  254. 		'QUERY="'.$val.'",ITOID="'.$nitoid.'"');
    255. 

  255.     return $nitoid;
    256. 

  256.   }
    257. 

  257. 

  258.   /// Prépare l'edition d'une section fonction
    259. 

  259.   function editfunction($ar=NULL){
    260. 

  260.     $p=new XParam($ar,NULL);
    261. 

  261.     $tplentry=$p->get('tplentry');
    262. 

  262.     $oidit=$p->get('oidit');
    263. 

  263.     $oidsection=$p->get('oidsection');
    264. 

  264.     list($oidit,$oiddest,$oidtemplate)=$this->_getOids($oidsection);
    265. 

  265.     $rs=selectQuery('select * from '.$this->tname.' where ITOID="'.$oidsection.'"');
    266. 

  266.     if(!$ors=$rs->fetch()) return array();
    267. 

  267.     $params=unserialize($ors['QUERY']);
    268. 

  268.     $s=array();
    269. 

  269.     $template = $this->_disp2Template($oidtemplate);
    270. 

  270.     $s['_tp'] = $template;
    271. 

  271.     $s['oidit']=$oidit;
    272. 

  272.     $s['oidsection']=$oidsection;
    273. 

  273.     $s['section']=$params;
    274. 

  274.     $moid=$params['moid'];
    275. 

  275.     $f=$params['function'];
    276. 

  276.     $pf='UIParam_'.$f;
    277. 

  277.     $ef='UIEdit_'.$f;
    278. 

  278.     $m=XModule::objectFactory($moid);
    279. 

  279.     if(method_exists($m,$ef)) $ret=$m->$ef($params);
    280. 

  280.     else{
    281. 

  281.       $desc=$m->$pf();
    282. 

  282.       $ret=array('fields_object'=>array());
    283. 

  283.       foreach($desc as $fn=>&$f){
    284. 

  284. 	$o=$f->edit($params[$fn]);
    285. 

  285. 	$ret['o'.$fn]=$ret['fields_object'][]=$o;
    286. 

  286.       }
    287. 

  287.     }
    288. 

  288.     $this->editTemplateOptions($ret, $oidtemplate, $s['oidsection'], $params);
    289. 

  289.     $groups=array();
    290. 

  290.     foreach($ret as $n=>&$v) {
    291. 

  291.       if(!is_object($v) || !is_object($v->fielddef)) continue;
    292. 

  292.       if(empty($v->fielddef->fgroup)) $v->fielddef->fgroup='General';
    293. 

  293.       $groups[$v->fielddef->fgroup][]=&$v;
    294. 

  294.     }
    295. 

  295.     ksort($groups);
    296. 

  296.     if(count($groups)>1) $ret['_groups']=$groups;
    297. 

  297.     $s['olines'][]=$ret;
    298. 

  298.     return XShell::toScreen1($tplentry,$s);
    299. 

  299.   }
    300. 

  300. 

  301.   /**
    302. 

  302.    * Ajoute les options du template à l'interface d'édition de la section fonction
    303. 

  303.    * @param &$ret array Tableau de valeurs disponible dans le template
    304. 

  304.    * @param $oid_template string KOID du template
    305. 

  305.    * @param $id_section string Identifiant unique de la section
    306. 

  306.    * @param $params array Tableau de valeurs des options du template
    307. 

  307.    */
    308. 

  308.   public function editTemplateOptions(&$ret, $oid_template, $id_section, $params = null) {
    309. 

  309.     // Récupère les options liées au TEMPLATE de mise en page
    310. 

  310.     $options_values = (object) null;
    311. 

  311.     $xoptions = $this->getTemplateOptions($oid_template, $id_section, $options_values);
    312. 

  312.     if (!is_null($xoptions)) {
    313. 

  313.       $template_options = $xoptions->getValues($options_values);
    314. 

  314.       foreach ($template_options as $option_id => $option) {
    315. 

  315. 	$xoptions->set($options_values, $option_id, $params['_tploptions'][$option_id]);
    316. 

  316.       }
    317. 

  317.       $user_module_access_levels = current(XUser::getObjectAccess($this->_moid));
    318. 

  318.       $level = in_array('admin', $user_module_access_levels) ? 'admin' : 'none';
    319. 

  319.       $ret['_tploptions'] = $xoptions->getDialog($options_values, $params['_tploptions'], '_tploptions', $level);
    320. 

  320.     }
    321. 

  321.   }
    322. 

  322. 

  323.   /** 
    324. 

  324.    * Envoi un tableau des options disponibles pour le template
    325. 

  325.    * @param $oid_template string KOID du template
    326. 

  326.    * @param $id_section string Identifiant unique de la section
    327. 

  327.    * @param $options_values array Tableau de valeurs des options du template
    328. 

  328.    * @return XOptions Objet contenant les options du template / null si inexistant
    329. 

  329.    */
    330. 

  330.   public function getTemplateOptions($oid_template, $id_section, &$options_values) {
    331. 

  331.     $template = $this->_templates->rDisplay($oid_template);
    332. 

  332.     if (empty($template['oopts']->raw)) {
    333. 

  333.       return null;
    334. 

  334.     }
    335. 

  335.     $xopts = new XOptions($id_section);
    336. 

  336.     $xopts->setOptsFromXML($options_values, $template['oopts']->raw);
    337. 

  337.     return $xopts;
    338. 

  338.   }
    339. 

  339. 

  340.   /// Enregistre une section de type fonction
    341. 

  341.   public function savefunction($ar=NULL){
    342. 

  342.     $p=new XParam($ar,NULL);
    343. 

  343.     $oidit=$p->get('oidit');
    344. 

  344.     $oidtpl=$p->get('oidtpl');
    345. 

  345.     $oidsection=$p->get('oidsection');
    346. 

  346.     $section=$p->get('section');
    347. 

  347.     $moid=$section['moid'];
    348. 

  348.     $f=$section['function'];
    349. 

  349.     $pf='UIParam_'.$f;
    350. 

  350.     $ef='UIProcEdit_'.$f;
    351. 

  351.     $m=XModule::objectFactory($moid);
    352. 

  352.     if(method_exists($m,$ef)){
    353. 

  353.       $ret=$m->$ef($ar);
    354. 

  354.       if($ret) $section=array_merge($section,$ret);
    355. 

  355.     }else{
    356. 

  356.       $desc=$m->$pf();
    357. 

  357.       $options=array('_track'=>false);
    358. 

  358.       foreach($desc as $fn=>&$f){
    359. 

  359. 	$value=$p->get($fn);
    360. 

  360. 	$value_hid=$p->get($fn.'_HID');
    361. 

  361. 	$options[$fn.'_HID']=$value_hid;
    362. 

  362. 	$o=$desc[$fn]->post_edit($value,$options);
    363. 

  363. 	if($f->multivalued && $f->get_fgender()=='Oid' && is_array($o->raw)){
    364. 

  364. 	  $o->raw=implode('||',$o->raw);
    365. 

  365. 	}
    366. 

  366. 	$section[$fn]=$o->raw;
    367. 

  367.       }
    368. 

  368.     }
    369. 

  369.     $section['_tploptions'] = $p->get('_tploptions');
    370. 

  370.     $val=addslashes(serialize($section));
    371. 

  371.     updateQuery('UPDATE '.$this->tname.' SET KOIDSRC="'.$oidit.'",KOIDDST="",QUERY="'.$val.'" where ITOID="'.$oidsection.'"');
    372. 

  372.     return $oidsection;
    373. 

  373.   }
    374. 

  374. 

  375.   /// Prepare l'ajout d'une section dans l'administration a partir d'une page donnee
    376. 

  376.   function adminNewSection($ar=NULL){
    377. 

  377.     $p=new XParam($ar,NULL);
    378. 

  378.     $tplentry=$p->get('tplentry');
    379. 

  379.     $newrub=$p->get('newrub');
    380. 

  380.     $fct=$p->get('fct');
    381. 

  381.     $r=array();
    382. 

  382.     if($newrub) $this->_categories->input(array('tplentry'=>$tplentry.'rub'));
    383. 

  383.     $xds=XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS=CS8SEC');
    384. 

  384.     $xds->input(array('tplentry'=>$tplentry.'sec'));
    385. 

  385.     $this->home(array('tplentry'=>$tplentry.'tree','maxlevel'=>1,'norubric'=>true));
    386. 

  386.     $fct=XModUser2::_normalizeBookmark($fct);
    387. 

  387.     $r['fct']=$fct;
    388. 

  388.     parse_str($fct,$infos);
    389. 

  389.     $f=$infos['_function']?$infos['_function']:$infos['function'];
    390. 

  390.     if($infos['moid'] && ($f=='procQuery' || $f=='browse')){
    391. 

  391.       $mod=XModule::objectFactory($infos['moid']);
    392. 

  392.       if($mod->persistentquery){
    393. 

  393. 	$r['persistent']=1;
    394. 

  394.       }
    395. 

  395.     }
    396. 

  396.     return XShell::toScreen1($tplentry,$r);
    397. 

  397.   }
    398. 

  398. 

  399.   /// Ajoute une section dans l'administration
    400. 

  400.   function adminProcNewSection($ar=NULL){
    401. 

  401.     $p=new XParam($ar,NULL);
    402. 

  402.     $linkup=$p->get('linkup');
    403. 

  403.     $createrub=$p->get('createrub');
    404. 

  404.     if($createrub){
    405. 

  405.       $rub=$this->procInput($ar);
    406. 

  406.       $linkup=$rub['oid'];
    407. 

  407.     }
    408. 

  408.     $ar2=$p->get('sec');
    409. 

  409.     $ar2['fct']=XModUser2::_normalizeBookmark($ar2['fct']);
    410. 

  410.     $ar2['oidit']=$linkup;
    411. 

  411.     $ar2['oidtpl']='TEMPLATES:ADMIN-'.$this->_moid;
    412. 

  412.     if(!empty($ar2['persistent'])) $ar2['fct'].='&_persistent=1';
    413. 

  413.     $this->insertsection($ar2);
    414. 

  414.   }
    415. 

  415. 

  416.   /// Liste des actions générale du module
    417. 

  417.   protected function _actionlist(&$my) {
    418. 

  418.     parent::_actionlist($my);
    419. 

  419.     $myoid=@$_REQUEST['oidit'];
    420. 

  420.     $moid=$this->_moid;
    421. 

  421.     // Arbo
    422. 

  422.     $o1=new XModuleAction($this,'home',XLabels::getSysLabel('xmodinfotree','see_categories'),
    423. 

  423. 			  '&moid='.$moid.'&_function=home&template=xmodinfotree/index.html&tplentry=mit','display');
    424. 

  424.     $o1->setToolbar('general','browse');
    425. 

  425.     $my['home']=$o1;
    426. 

  426.     // Poubelle
    427. 

  427.     $o1=new XModuleAction($this,'trash',XLabels::getSysLabel('xmodinfotree','see_trash'),
    428. 

  428. 			  '&moid='.$moid.'&_function=home&template=xmodinfotree/index.html&tplentry=mit&aliastop=trash','display');
    429. 

  429.     $o1->setToolbar('general','trash');
    430. 

  430.     $my['trash']=$o1;
    431. 

  431.     // Recherche
    432. 

  432.     $o1=new XModuleAction($this,'home',XLabels::getSysLabel('general','query','text'),
    433. 

  433. 			  '&moid='.$moid.'&_function=query&template=xmodinfotree/query.html&tplentry=br','display');
    434. 

  434.     $o1->setToolbar('general','query');
    435. 

  435.     $my['query']=$o1;
    436. 

  436.     // Pile
    437. 

  437.     if($this->interactive)  {
    438. 

  438.       $o1=new XModuleAction($this,'in',$this->modulename,
    439. 

  439. 			    '&moid='.$this->_moid.'&_function=home&template=xmodinfotree/index.html&tplentry=mit');
    440. 

  440.       $my['stack'][]=$o1;
    441. 

  441.       if (!empty($myoid)) {
    442. 

  442.         $nav=$this->getPath($myoid);
    443. 

  443.         foreach($nav['oiddown'] as $i=>$oid) {
    444. 

  444.           $o1=new XModuleAction($this,'i'.$i,$nav['labeldown'][$i],
    445. 

  445.                                 '&moid='.$this->_moid.'&_function=editpage&template=xmodinfotree/viewpage.html&tplentry=it&oidit='.$oid);
    446. 

  446.           $my['stack'][]=$o1;
    447. 

  447.         }
    448. 

  448.       }
    449. 

  449.       if(XShell::_function()=='editCat'){
    450. 

  450. 	$br=&XShell::from_screen('editcat');
    451. 

  451. 	$br=&$this->_categories->rDisplayText($br['oid'],array());
    452. 

  452. 	$o1=new XModuleAction($this,'view',$br['link'],'&moid='.$this->_moid.'&_function=editpage&template=xmodinfotree/viewpage.html&tplentry=it&oidit='.$br['oid']);
    453. 

  453. 	$my['stack'][]=$o1;
    454. 

  454.       }
    455. 

  455.       $modsubmoid=XModule::getMoid(XMODSUB_TOID);
    456. 

  456.       if(!empty($modsubmoid)){
    457. 

  457. 	$o1=new XModuleAction($this,'subscribe',XLabels::getSysLabel('xmodsub','subadd','text'),
    458. 

  458. 			      '&moid='.$this->_moid.'&oid='.$myoid.'&_function=preSubscribe&tplentry=br&template=xmodinfotree/sub.html',
    459. 

  459. 			      'more');
    460. 

  460. 	$o1->menuable=true;
    461. 

  461. 	$my['subscribe']=$o1;
    462. 

  462.       }
    463. 

  463.       if($this->odttpltxt && $this->odttplimg && $this->secure(NULL,'importFromODT')){
    464. 

  464. 	$o1=new XModuleAction($this,'odtimport',XLabels::getSysLabel('xmodinfotree','odt_import','text'),
    465. 

  465. 			      '&moid='.$this->_moid.'&function=preImportFromODT&template=xmodinfotree/preImportFromODT.html&oidit='.$oid,'edit');
    466. 

  466. 	$o1->menuable=true;
    467. 

  467. 	$my['odtimport']=$o1;
    468. 

  468.       }
    469. 

  469.     }
    470. 

  470.   }
    471. 

  471. 

  472.   /// Actions spécifique à "home"
    473. 

  473.   function al_home(&$my){
    474. 

  474.     $uniqid='v'.XShell::uniqid();
    475. 

  475.     $o1=new XModuleAction($this,'foldall',XLabels::getSysLabel('xmodinfotree','fold_all','text'),
    476. 

  476. 			  '&function=home&template=xmodinfotree/index.html&moid='.$this->_moid.'&do=foldall&tplentry=mit','display');
    477. 

  477.     $o1->menuable=true;
    478. 

  478.     $my['foldall']=$o1;
    479. 

  479.     $o1=new XModuleAction($this,'unfoldall',XLabels::getSysLabel('xmodinfotree','unfold_all','text'),
    480. 

  480. 			  '&function=home&template=xmodinfotree/index.html&moid='.$this->_moid.'&do=unfoldall&tplentry=mit','display');
    481. 

  481.     $o1->menuable=true;
    482. 

  482.     $my['unfoldall']=$o1;
    483. 

  483.     if($this->secure(NULL,'input')){
    484. 

  484.       $o1=new XModuleAction($this,'input',XLabels::getSysLabel('xmodinfotree','add_subtree','text'),
    485. 

  485. 			    '&moid='.$this->_moid.'&function=input&template=xmodinfotree/new.html&linkup=','edit');
    486. 

  486.       $o1->setToolbar('general','new');
    487. 

  487.       $my['input']=$o1;
    488. 

  488.     }
    489. 

  489.     // Publier/dépulier
    490. 

  490.     if($this->_categories->fieldExists('PUBLISH') && $this->secure(NULL,':rwv')){
    491. 

  491.       $o1=new XModuleAction($this,'publish',XLabels::getSysLabel('general','approve','text'),
    492. 

  492. 			    'javascript:'.$uniqid.'.publishSelected(true);','edit');
    493. 

  493.       $o1->menuable=true;
    494. 

  494.       $my['publish']=$o1;
    495. 

  495.       $o1=new XModuleAction($this,'publish',XLabels::getSysLabel('general','unapprove','text'),
    496. 

  496. 			    'javascript:'.$uniqid.'.publishSelected(false);','edit');
    497. 

  497.       $o1->menuable=true;
    498. 

  498.       $my['unpublish']=$o1;
    499. 

  499.     }
    500. 

  500.     // Supprimer
    501. 

  501.     if($this->secure(NULL,'moveToTrash')){
    502. 

  502.       $o1=new XModuleAction($this,'del',XLabels::getSysLabel('general','delete','text'),
    503. 

  503. 			    'javascript:'.$uniqid.'.deleteselected();','edit');
    504. 

  504.       $o1->setToolbar('general','delete');
    505. 

  505.       $my['del']=$o1;
    506. 

  506.     }
    507. 

  507.     // Deplacer
    508. 

  508.     if($this->secure(NULL,'moveCat')){
    509. 

  509.       $o1=new XModuleAction($this,'move',XLabels::getSysLabel('general','move','text'),
    510. 

  510. 			    'javascript:'.$uniqid.'.moveselected();','edit');
    511. 

  511.       $o1->menuable=true;
    512. 

  512.       $my['move']=$o1;
    513. 

  513.     }
    514. 

  514.     // Dupliquer
    515. 

  515.     if($this->secure(NULL,'dupCat')){
    516. 

  516.       $o1=new XModuleAction($this,'dup',XLabels::getSysLabel('general','clone','text'),
    517. 

  517. 			    'javascript:'.$uniqid.'.duplicateselected();','edit');
    518. 

  518.       $o1->menuable=true;
    519. 

  519.       $my['dup']=$o1;
    520. 

  520.     }
    521. 

  521.     // Exporter
    522. 

  522.     if($this->secure(NULL,'export')){
    523. 

  523.       $o1=new XModuleAction($this,'export',XLabels::getSysLabel('general','export','text'),
    524. 

  524. 			    'javascript:'.$uniqid.'.exportselected();','edit');
    525. 

  525.       $o1->menuable=true;
    526. 

  526.       $my['exp']=$o1;
    527. 

  527.     }
    528. 

  528.   }
    529. 

  529.   /// Actions spécifique à "viewpage"
    530. 

  530.   function al_viewpage(&$my){
    531. 

  531.     $uniqid='v'.XShell::uniqid();
    532. 

  532.     $oid=$_REQUEST['oidit'];
    533. 

  533.     // Navigation
    534. 

  534.     $o1=new XModuleAction($this,'nav',XLabels::getSysLabel('general','navigation','text'),'#');
    535. 

  535.     $o1->menuable=true;
    536. 

  536.     $o1->newgroup='nav';
    537. 

  537.     $my['nav']=$o1;
    538. 

  538.     $o1=new XModuleAction($this,'navall',XLabels::getSysLabel('xmodinfotree','treebrowser','text'),
    539. 

  539. 			  'javascript:TZR.openPopup("'.$GLOBALS['TZR_SESSION_MANAGER']::complete_self().'function=home&template=xmodinfotree/popaction.html'.
    540. 

  540. 			  '&_skip=1&moid='.$this->_moid.'&_raw=1&maxlevel=1&oid='.$oid.'&tplentry=mit&do=add&'.
    541. 

  541. 			  '&norubric=1&action=go&moduleid='.XShell::uniqid().'");','nav');
    542. 

  542.     $o1->menuable=true;
    543. 

  543.     $my['navall']=$o1;
    544. 

  544.     $it=&XShell::from_screen('it');
    545. 

  545.     $nav=&$it['nav'];
    546. 

  546.     if($nav['up']){
    547. 

  547.       $o1=new XModuleAction($this,'navup',$nav['up']['otitle']->html,'javascript:'.$uniqid.'.gopage("'.$nav['up']['oid'].'");','nav');
    548. 

  548.       $o1->menuable=true;
    549. 

  549.       $my['navup']=$o1;
    550. 

  550.     }
    551. 

  551.     if(!empty($nav['prev'])){
    552. 

  552.       $o1=new XModuleAction($this,'navprev',$nav['prev']['otitle']->html,'javascript:'.$uniqid.'.gopage("'.$nav['prev']['oid'].'");',
    553. 

  553. 			    'nav');
    554. 

  554.       $o1->menuable=true;
    555. 

  555.       $my['navprev']=$o1;
    556. 

  556.     }
    557. 

  557.     if(!empty($nav['next'])){
    558. 

  558.       $o1=new XModuleAction($this,'navnext',$nav['next']['otitle']->html,'javascript:'.$uniqid.'.gopage("'.$nav['next']['oid'].'");',
    559. 

  559. 			    'nav');
    560. 

  560.       $o1->menuable=true;
    561. 

  561.       $my['navnext']=$o1;
    562. 

  562.     }
    563. 

  563.     $rubs=&XShell::from_screen('ssrubs');
    564. 

  564.     foreach($rubs['lines_oid'] as $i=>$roid){
    565. 

  565.       $o1=new XModuleAction($this,'navssrub'.$i,$rubs['lines_otitle'][$i]->html,'javascript:'.$uniqid.'.gopage("'.$roid.'");','nav');
    566. 

  566.       $o1->menuable=true;
    567. 

  567.       $my['navssrub'.$i]=$o1;
    568. 

  568.     }
    569. 

  569. 

  570.     // Prévisualisation
    571. 

  571.     if($this->preview){
    572. 

  572.       $o1=new XModuleAction($this,'view',XLabels::getSysLabel('general','view','text'),
    573. 

  573. 			    $this->preview.'&_lang='.XShell::getLangData().'&oidit='.$oid.'&nocache=1','edit');
    574. 

  574.       $o1->target='_blank';
    575. 

  575.       $o1->setToolbar('general','view');
    576. 

  576.       $my['view']=$o1;
    577. 

  577.     }
    578. 

  578.     // Publier/dépulier
    579. 

  579.     if($this->secure($oid,':rwv')){
    580. 

  580.       $it=XShell::from_screen('it');
    581. 

  581.       $publish=false;
    582. 

  582.       foreach($it['olines'] as $i=>$s){
    583. 

  583. 	if(isset($s['oPUBLISH'])){
    584. 

  584. 	  $publish=true;
    585. 

  585. 	  break;
    586. 

  586. 	}
    587. 

  587.       }
    588. 

  588.       if($publish){
    589. 

  589. 	$o1=new XModuleAction($this,'publish',XLabels::getSysLabel('general','approve','text'),
    590. 

  590. 			      'javascript:'.$uniqid.'.publishSelected(true);','edit');
    591. 

  591. 	$o1->menuable=true;
    592. 

  592. 	$my['publish']=$o1;
    593. 

  593. 	$o1=new XModuleAction($this,'publish',XLabels::getSysLabel('general','unapprove','text'),
    594. 

  594. 			      'javascript:'.$uniqid.'.publishSelected(false);','edit');
    595. 

  595. 	$o1->menuable=true;
    596. 

  596. 	$my['unpublish']=$o1;
    597. 

  597.       }
    598. 

  598.     }
    599. 

  599.     // Supprimer
    600. 

  600.     if($this->secure($oid,'delSection')){
    601. 

  601.       $o1=new XModuleAction($this,'del',XLabels::getSysLabel('general','delete','text'),
    602. 

  602. 			    'javascript:'.$uniqid.'.deleteselected();','edit');
    603. 

  603.       $o1->menuable=true;
    604. 

  604.       $my['del']=$o1;
    605. 

  605.     }
    606. 

  606.     // Deplacer
    607. 

  607.     if($this->secure($oid,'moveSection')){
    608. 

  608.       $o1=new XModuleAction($this,'move',XLabels::getSysLabel('general','move','text'),
    609. 

  609. 			    'javascript:'.$uniqid.'.moveselected(\'to\');','edit');
    610. 

  610.       $o1->menuable=true;
    611. 

  611.       $my['move']=$o1;
    612. 

  612.       $o1=new XModuleAction($this,'moveup',XLabels::getSysLabel('general','up','text'),
    613. 

  613. 			    'javascript:'.$uniqid.'.moveselected(\'up\');','edit');
    614. 

  614.       $o1->menuable=true;
    615. 

  615.       $my['moveup']=$o1;
    616. 

  616.       $o1=new XModuleAction($this,'movedown',XLabels::getSysLabel('general','down','text'),
    617. 

  617. 			    'javascript:'.$uniqid.'.moveselected(\'down\');','edit');
    618. 

  618.       $o1->menuable=true;
    619. 

  619.       $my['movedown']=$o1;
    620. 

  620.     }
    621. 

  621.     // Export PDF
    622. 

  622.     if($this->pdf_enabled && $this->secure($oid,'exportPdf')) {
    623. 

  623.       $o1=new XModuleAction($this,'exportPdf',XLabels::getSysLabel('xmodinfotree','export_pdf','text'),'&moid='.$this->_moid.'&_function=exportPdf&oidit='.$oid,'edit');
    624. 

  624.       $o1->target='_blank';
    625. 

  625.       $o1->ico='<img src="/tzr/templates/ico/mime/pdf.gif">';
    626. 

  626.       $o1->setToolbar();
    627. 

  627.       $my['exportPdf']=$o1;
    628. 

  628.     }
    629. 

  629.   }
    630. 

  630.   /// Actions spécifique à "editpage"
    631. 

  631.   function al_editpage(&$my){
    632. 

  632.     $this->al_viewpage($my);
    633. 

  633.   }
    634. 

  634. 

  635.   /// Refait la numérotation de l'ordre des sections d'une catégorie
    636. 

  636.   protected function _reorderSections($oid) {
    637. 

  637.     $rs=selectQuery('select ITOID,ORDER1 from '.$this->tname.' where KOIDSRC="'.$oid.'" order by ORDER1,ITOID');
    638. 

  638.     $i=0;
    639. 

  639.     while($ors=$rs->fetch()) {
    640. 

  640.       $i++;
    641. 

  641.       if($i==$ors['ORDER1']) continue;
    642. 

  642.       updateQuery('UPDATE '.$this->tname.' set ORDER1='.$i.' where ITOID="'.$ors['ITOID'].'"');
    643. 

  643.     }
    644. 

  644.     $rs->closeCursor();
    645. 

  645.   }
    646. 

  646. 

  647.   /// Refait la numérotation de l'ordre des catégories d'un noeud
    648. 

  648.   protected function _reorderCat($oid) {
    649. 

  649.     $lang=TZR_DEFAULT_LANG;
    650. 

  650.     if(!$oid) $oid='';
    651. 

  651.     $i=0;
    652. 

  652.     $rs=selectQuery('select distinct KOID,corder from '.$this->table.' where linkup="'.$oid.'" and LANG="'.$lang.'" order by corder');
    653. 

  653.     while($ors=$rs->fetch()) {
    654. 

  654.       $i++;
    655. 

  655.       if($i==$ors['corder']) continue;
    656. 

  656.       updateQuery('UPDATE '.$this->table.' set corder='.$i.',UPD=UPD where KOID="'.$ors['KOID'].'"');
    657. 

  657.     }
    658. 

  658.     $rs->closeCursor();
    659. 

  659.   }
    660. 

  660. 

  661.   /// Change le parent d'une ou plusieurs catégories
    662. 

  662.   public function moveSelectedCat($ar) {
    663. 

  663.     $p=new XParam($ar, array());
    664. 

  664.     $dest=$p->get('_dest');
    665. 

  665.     if(!empty($dest) && !Kernel::isAKoid($dest)) {
    666. 

  666.       $dest=$this->getOidFromAlias($dest);
    667. 

  667.     }
    668. 

  668.     $sel=$p->get('_selected');
    669. 

  669. 

  670.     $i=-count($sel);
    671. 

  671.     foreach($sel as $oid => $bid) {
    672. 

  672.       if($oid!=$dest) {
    673. 

  673. 	updateQuery('UPDATE '.$this->table.' set linkup="'.$dest.'",corder='.$i.' where KOID="'.$oid.'"');
    674. 

  674.       }
    675. 

  675.       $i++;
    676. 

  676.     }
    677. 

  677.     $this->_reorderCat($dest);
    678. 

  678.   }
    679. 

  679. 

  680.   /// teste si une rubrique est dans la poubelle
    681. 

  681.   protected function oidInTrash($oid) {
    682. 

  682.     $oidtrash = $this->getTrashOid();
    683. 

  683.     if(empty($oidtrash)) return false;
    684. 

  684.     $pathoids=$this->_getPathOids($oid);
    685. 

  685.     return in_array($oidtrash, $pathoids);
    686. 

  686.   }
    687. 

  687. 

  688.   /// deplacement de la selection vers la poubelle, rubrique d'alias trash
    689. 

  689.   public function moveToTrash($ar) {
    690. 

  690.     $p=new XParam($ar, array());
    691. 

  691.     $oidtrash = $this->getTrashOid(true);
    692. 

  692.     $sel=$p->get('_selected');
    693. 

  693. 

  694.     // si les elements sont deja dans la poubelle on les supprime
    695. 

  695.     $delnb=0;
    696. 

  696. 

  697.     foreach($sel as $oid => $bid) {
    698. 

  698.       if($this->oidInTrash($oid)) {
    699. 

  699. 	$ar1=array();
    700. 

  700. 	$ar1['oid']=$oid;
    701. 

  701. 	$ar1['_selected']=array();
    702. 

  702. 	$ar1['_selectedok']='nok';
    703. 

  703. 	$this->delCat($ar1);
    704. 

  704. 	$delnb++;
    705. 

  705.       }
    706. 

  706.     }
    707. 

  707.     // si on a supprime tous les elements selectionnes pas la peine de
    708. 

  708.     // rentrer dans un traitement de la poubelle
    709. 

  709.     if($delnb==count($sel)) return;
    710. 

  710. 

  711.     // creation d'une rubrique liee a la date de suppression
    712. 

  712.     $ar1=array('title'=>'-- '.date('c'),
    713. 

  713. 	       'linkup'=>$oidtrash,
    714. 

  714. 	       'corder'=>'0');
    715. 

  715.     $r1=&$this->procInput($ar1);
    716. 

  716.     $dest = $r1['oid'];
    717. 

  717. 

  718.     foreach($sel as $oid => $bid) {
    719. 

  719.       if($oid!=$dest) {
    720. 

  720. 	updateQuery('UPDATE '.$this->table." set linkup='$dest' where KOID='$oid'");
    721. 

  721.       }
    722. 

  722.     }
    723. 

  723. 

  724.     // on parcourt la poubelle et on supprime dans la poubelle toutes les rubriques validees
    725. 

  725.     // ainsi que tous les alias
    726. 

  726.     $oids=$this->getSubObjects($oidtrash);
    727. 

  727.     foreach($oids as $oids1) {
    728. 

  728.       if($this->_categories->fieldExists('PUBLISH')) {
    729. 

  729. 	updateQuery('UPDATE '.$this->table." set PUBLISH='2' WHERE KOID='$oids1'");
    730. 

  730.       }
    731. 

  731.       updateQuery('UPDATE '.$this->table." set alias='' WHERE KOID='$oids1'");
    732. 

  732.     }
    733. 

  733. 

  734.     // on traite les liens internes. Ceux qui sont dans la poubelle sont supprimes
    735. 

  735.     // ceux qui vont vers la poubelle sont supprimes
    736. 

  736.     $rs=selectQuery('SELECT KOID,LANG,'.$this->linkin.' FROM '.$this->table.' WHERE '.$this->linkin.'!=\'\'');
    737. 

  737.     while($rs && ($ors=$rs->fetch())) {
    738. 

  738.       if($this->oidInTrash($ors['KOID'])) {
    739. 

  739. 	updateQuery('UPDATE '.$this->table.' SET '.$this->linkin."='',UPD=UPD WHERE KOID='".$ors['KOID']."'");
    740. 

  740.       } elseif($this->oidInTrash($ors[$this->linkin])) {
    741. 

  741. 	updateQuery('UPDATE '.$this->table.' SET '.$this->linkin."='',UPD=UPD WHERE KOID='".$ors['KOID']."' AND ".$this->linkin."='".$ors[$this->linkin]."'");
    742. 

  742.       }
    743. 

  743.     }
    744. 

  744.   }
    745. 

  745. 

  746.   /// Change l'ordre et/ou le parent d'une catégorie
    747. 

  747.   public function moveCat($ar) {
    748. 

  748.     $p=new XParam($ar, array());
    749. 

  749.     $oid=$p->get('oid');
    750. 

  750.     $dir=$p->get('dir');
    751. 

  751.     $to=$p->get('to');
    752. 

  752. 

  753.     // recherche de la rubrique mere
    754. 

  754.     $poid=$new_p=countSelectQuery('select distinct linkup from '.$this->table.' where KOID="'.$oid.'"');
    755. 

  755. 

  756.     // on verifie et corrige l'ordre
    757. 

  757.     $this->_reorderCat($poid);
    758. 

  758.     if($to){
    759. 

  759.       $new_p=($to!='root'?$to:'');
    760. 

  760.       $this->_reorderCat($new_p);
    761. 

  761.     }
    762. 

  762. 

  763.     // recherche de son ordre
    764. 

  764.     $o=countSelectQuery('select distinct corder from '.$this->table.' where KOID="'.$oid.'"');
    765. 

  765.     if($dir=='up'){
    766. 

  766.       $new_o=$o-1;
    767. 

  767.       updateQuery('UPDATE '.$this->table.' set corder='.$o.',UPD=UPD where corder='.$new_o.' and linkup="'.$poid.'"');
    768. 

  768.     }elseif($dir=='down'){
    769. 

  769.       $new_o=$o+1;
    770. 

  770.       updateQuery('UPDATE '.$this->table.' set corder='.$o.',UPD=UPD where corder='.$new_o.' and linkup="'.$poid.'"');
    771. 

  771.     }elseif(Kernel::isAKoid($dir)){
    772. 

  772.       $new_o=countSelectQuery('select distinct corder from '.$this->table.' where KOID="'.$dir.'"')+1;
    773. 

  773.       updateQuery('UPDATE '.$this->table.' set corder=corder+1,UPD=UPD where corder>='.$new_o.' and linkup="'.$new_p.'"');
    774. 

  774.     }else{
    775. 

  775.       $new_o=0;
    776. 

  776.     }
    777. 

  777.     updateQuery('UPDATE '.$this->table.' set corder='.$new_o.',linkup="'.$new_p.'" where KOID="'.$oid.'"');
    778. 

  778. 

  779.     $this->_reorderCat($poid);
    780. 

  780.     if($new_p!=$poid) $this->_reorderCat($new_p);
    781. 

  781.   }
    782. 

  782. 

  783.   /// suppression d'une rubrique et de toutes les sections associees
    784. 

  784.   function delCat($ar=NULL) {
    785. 

  785.     $p=new XParam($ar,array('_selectedok'=>'nok'));
    786. 

  786.     $lang_data=XShell::getLangData();
    787. 

  787.     if($lang_data==TZR_DEFAULT_LANG) $lang='';
    788. 

  788.     elseif(!$this->_categories->isTranslatable()) $lang='';
    789. 

  789.     else $lang="AND LANG='$lang_data'";
    790. 

  790. 

  791.     $selected =   $p->get('_selected');
    792. 

  792.     $selectedok = $p->get('_selectedok');
    793. 

  793.     if($selectedok=='ok') {
    794. 

  794.       foreach($selected as $oid => $bidon) {
    795. 

  795. 	$ar['oid']=$oid;
    796. 

  796. 	$ar['_selected']=array();
    797. 

  797. 	$ar['_selectedok']='nok';
    798. 

  798. 	$this->delCat($ar);
    799. 

  799.       }
    800. 

  800.       return;
    801. 

  801.     }
    802. 

  802.     $oid=$p->get('oid');
    803. 

  803.     $oids[$oid]=1;
    804. 

  804.     $kernel = new Kernel;
    805. 

  805. 

  806.     while(count($oids)>0) {
    807. 

  807.       unset($oids2);
    808. 

  808.       foreach($oids as $k => $v) {
    809. 

  809. 	$kernel->data_forcedDel(array('oid'=>$k,'action'=>'OK','_selectedok'=>'nok'));
    810. 

  810. 	// suppression des sections
    811. 

  811. 	$rs=selectQuery('select * from '.$this->tname." where KOIDSRC='$k'");
    812. 

  812. 	while($ors=$rs->fetch()) {
    813. 

  813. 	  $itoid = $ors['ITOID'];
    814. 

  814. 	  $koiddst = $ors['KOIDDST'];
    815. 

  815. 	  if(!empty($koiddst)) {
    816. 

  816. 	    $tabledst = Kernel::getTable($koiddst);
    817. 

  817. 	    if(!empty($tabledst)) {
    818. 

  818. 	      if($lang_data == TZR_DEFAULT_LANG) {
    819. 

  819. 		updateQuery('DELETE FROM '.$this->tname." where ITOID = '$itoid'");
    820. 

  820. 	      }
    821. 

  821. 	      $kernel->data_forcedDel(array('oid'=>$koiddst,'action'=>'OK','_selectedok'=>'nok'));
    822. 

  822. 	    }
    823. 

  823. 	  }
    824. 

  824. 	}
    825. 

  825. 	$rs->closeCursor();
    826. 

  826. 	$rs=selectQuery('select distinct KOID from '.$this->table." where linkup='$k'");
    827. 

  827. 	while($ors=$rs->fetch()) {
    828. 

  828. 	  $oids2[$ors['KOID']]=1;
    829. 

  829. 	}
    830. 

  830. 	$rs->closeCursor();
    831. 

  831.       }
    832. 

  832.       $oids=$oids2;
    833. 

  833.     }
    834. 

  834.   }
    835. 

  835. 

  836.   /// suppression d'une categorie et de toutes les sections associees
    837. 

  837.   function dupCat($ar=NULL) {
    838. 

  838.     $p=new XParam($ar,array('_selectedok'=>'nok'));
    839. 

  839.     $lang_data=XShell::getLangData();
    840. 

  840.     if($lang_data==TZR_DEFAULT_LANG) $lang='';
    841. 

  841.     elseif(!$this->_categories->isTranslatable()) $lang='';
    842. 

  842.     else $lang="AND LANG='$lang_data'";
    843. 

  843. 

  844.     $selected =   $p->get('_selected');
    845. 

  845.     $selectedok = $p->get('_selectedok');
    846. 

  846. 

  847.     if($selectedok=='ok') {
    848. 

  848.       foreach($selected as $oid => $bidon) {
    849. 

  849. 	$ar['oid']=$oid;
    850. 

  850. 	$ar['_selected']=array();
    851. 

  851. 	$ar['_selectedok']='nok';
    852. 

  852. 	$this->dupCat($ar);
    853. 

  853.       }
    854. 

  854.       return;
    855. 

  855.     }
    856. 

  856. 

  857.     // duplication de la rubrique
    858. 

  858.     $oid=$p->get('oid');
    859. 

  859.     $nkoid=$this->_categories->duplicate(array('oid'=>$oid));
    860. 

  860.     $copy_of=XLabels::getSysLabel('general.copy_of');
    861. 

  861.     updateQuery('UPDATE '.$this->_categories->getTable()." set title=CONCAT('$copy_of ', title) where KOID='$nkoid'");
    862. 

  862.     updateQuery('UPDATE '.$this->_categories->getTable()." set alias=CONCAT(alias,'1') where KOID='$nkoid' and alias !=''");
    863. 

  863.     if($this->_categories->fieldExists('PUBLISH')) {
    864. 

  864.       updateQuery('UPDATE '.$this->_categories->getTable()." set PUBLISH='2' where KOID='$nkoid'");
    865. 

  865.     }
    866. 

  866. 

  867.     // duplication des sections
    868. 

  868.     $rs=selectQuery('select * from '.$this->tname." where KOIDSRC='$oid'");
    869. 

  869.     if($rs->rowCount()>0) {
    870. 

  870.       $oids=array();
    871. 

  871.       $ors=array();
    872. 

  872.       while($ors=$rs->fetch()) {
    873. 

  873. 	$oids[]=$ors['KOIDDST'];
    874. 

  874. 	$itoids[]=$ors['ITOID'];
    875. 

  875.       }
    876. 

  876. 

  877.       // duplication de chacune des sections
    878. 

  878.       $noids=array();
    879. 

  879.       foreach($oids as $i=>$oid1) {
    880. 

  880. 	if(!empty($oid1)) {
    881. 

  881. 	  $xset = XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS='.$oid1);
    882. 

  882. 	  $noids[$i]=$xset->duplicate(array('oid'=>$oid1));
    883. 

  883. 	}
    884. 

  884.       }
    885. 

  885. 

  886.       // duplication des liens
    887. 

  887.       updateQuery('CREATE TEMPORARY TABLE tmpo SELECT * FROM '.$this->tname." where KOIDSRC='$oid'");
    888. 

  888.       updateQuery("UPDATE tmpo set KOIDSRC='$nkoid'");
    889. 

  889.       foreach($oids as $i=>$oid1) {
    890. 

  890. 	if(!empty($oid1)) {
    891. 

  891. 	  updateQuery("UPDATE tmpo set KOIDDST='".$noids[$i]."' where KOIDDST='$oid1' and KOIDSRC='$nkoid'");
    892. 

  892. 	}
    893. 

  893.       }
    894. 

  894.       $rs=selectQuery('select * from tmpo');
    895. 

  895.       $ors=array();
    896. 

  896.       while($rs && ($ors=$rs->fetch())) {
    897. 

  897. 	$olditoid=$ors['ITOID'];
    898. 

  898. 	$n=self::newItOid();
    899. 

  899. 	updateQuery("UPDATE tmpo set ITOID='$n' where ITOID='$olditoid'");
    900. 

  900.       }
    901. 

  901. 

  902.       updateQuery('INSERT INTO '.$this->tname.' select * from tmpo');
    903. 

  903.       updateQuery('DROP TABLE tmpo');
    904. 

  904.     }
    905. 

  905.     $rs=selectQuery('SELECT DISTINCT KOID FROM '.$this->table." WHERE linkup='$oid'/* 1 */");
    906. 

  906.     while($ors=$rs->fetch()) {
    907. 

  907.       $ar1=array();
    908. 

  908.       $ar1['_selected']=array();
    909. 

  909.       $ar1['_selectedok']='nok';
    910. 

  910.       $ar1['oid']=$ors['KOID'];
    911. 

  911.       $nkoid2=$this->dupCat($ar1);
    912. 

  912.       XLogs::debug("recursive duplicate {$ors['KOID']} to $nkoid2");
    913. 

  913.       updateQuery("UPDATE {$this->table} set linkup='$nkoid' where KOID='$nkoid2'");
    914. 

  914.     }
    915. 

  915.     $rs->closeCursor();
    916. 

  916.     return $nkoid;
    917. 

  917.   }
    918. 

  918. 

  919.   /// validation de sections ou de rubriques
    920. 

  920.   public function publish($ar) {
    921. 

  921.     $p = new XParam($ar,array('_pub'=>false));
    922. 

  922.     $selected = $p->get('_itoidselected');
    923. 

  923.     $pub = $p->get('_pub');
    924. 

  924. 

  925.     $selectedoid = array();
    926. 

  926.     $oidsection=$p->get("oidsection");
    927. 

  927.     if(!empty($oidsection)) {
    928. 

  928.       $selected[$oidsection]=1;
    929. 

  929.     }
    930. 

  930.     if(is_array($selected)) {
    931. 

  931.       foreach($selected as $itoid => $foo) {
    932. 

  932. 	$rs=selectQuery('select distinct KOIDDST from '.$this->tname." where ITOID='$itoid'");
    933. 

  933. 	if($o=$rs->fetch()) {
    934. 

  934. 	  if(!empty($o['KOIDDST']))
    935. 

  935. 	    $selectedoid[]=$o['KOIDDST'];
    936. 

  936. 	}
    937. 

  937.       }
    938. 

  938.     }
    939. 

  939.     $_selected=$p->get('_selected');
    940. 

  940.     if(!empty($_selected)) {
    941. 

  941.       $copy_of_selectedoid=$selectedoid;
    942. 

  942.       $selectedoid=array_merge(array_keys($_selected), $copy_of_selectedoid);
    943. 

  943.     }
    944. 

  944.     if(!empty($selectedoid)) {
    945. 

  945.       $ar['_selected']=$selectedoid;
    946. 

  946.       $ar['key']=false;
    947. 

  947.       $ar['value']=$pub;
    948. 

  948.       foreach($selectedoid as $oid) {
    949. 

  949. 	$xset = XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS='.$oid);
    950. 

  950. 	$ar1=array('oid'=>$oid, 'value'=>$pub, '_selected'=>array());
    951. 

  951. 	$xset->publish($ar1);
    952. 

  952.       }
    953. 

  953.     }
    954. 

  954.   }
    955. 

  955. 

  956.   //// validation des oid ou des rubriques
    957. 

  957.   public function publishCat($ar) {
    958. 

  958.     $p=new XParam($ar,array('_pub'=>false));
    959. 

  959.     $xset = XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS='.$this->table);
    960. 

  960.     $xset->publish($ar);
    961. 

  961.   }
    962. 

  962. 

  963. 

  964.   // Affichage de l'arboresnce
    965. 

  965.   //
    966. 

  966.   function homeedit($ar=NULL) {
    967. 

  967.     $p = new XParam($ar, array('level'=>'1','deroule'=>'1','sections'=>'1','tplentry'=>'mit','maxlevel'=>99));
    968. 

  968.     $this->home($ar);
    969. 

  969.   }
    970. 

  970. 

  971. 

  972.   // rend la liste des objets qui se trouvent en dessous de cet objet,
    973. 

  973.   // independamment des niveaux
    974. 

  974.   //
    975. 

  975.   public function &subObjects($oid) {
    976. 

  976.     return $this->getSubCats($oid, TZR_DEFAULT_LANG, 1, 20);
    977. 

  977.   }
    978. 

  978. 

  979.   // rend vrai si le noeud oidit as des fils
    980. 

  980.   //
    981. 

  981.   protected function hasChildren($oidit) {
    982. 

  982.     $cnt=countSelectQuery('select * from '.$this->table." where linkup='$oidit'");
    983. 

  983.     return $cntt;
    984. 

  984.   }
    985. 

  985. 

  986.   // rend l'url conseillee pour un noeud donné
    987. 

  987.   //
    988. 

  988.   protected function _selfUrl($oid, $alias=NULL) {
    989. 

  989.     if(!empty($alias)) {
    990. 

  990.       $html="alias=$alias";;
    991. 

  991.     } else {
    992. 

  992.       $html="oidit=$oid";
    993. 

  993.     }
    994. 

  994.     return $html;
    995. 

  995.   }
    996. 

  996. 

  997.   function &procHome($ar=NULL) {
    998. 

  998.     $p = new XParam($ar, array());
    999. 

  999.     $aliases=$p->get('alias');
    1000. 

  1000.     $allmessages = array();
    1001. 

  1001.     if(is_array($aliases)) {
    1002. 

  1002.       foreach($aliases as $oid => $alias) {
    1003. 

  1003. 	$message = '';
    1004. 

  1004. 	$this->_checkAlias($alias, '', $oid, $message, NULL);
    1005. 

  1005. 	if ($message == '')
    1006. 

  1006. 	  $this->_categories->procEdit(array('alias'=>$alias,'oid'=>$oid));
    1007. 

  1007. 	else 
    1008. 

  1008. 	  $allmessages[] = $message;
    1009. 

  1009.       }
    1010. 

  1010.     }
    1011. 

  1011.     XShell::setNextData('message', implode(', ',$allmessages));
    1012. 

  1012.   }
    1013. 

  1013.   /****m* XModInfoTree/home
    1014. 

  1014.    * NAME
    1015. 

  1015.    *   XModInfoTree::home - creation de l'arborescence
    1016. 

  1016.    * DESCRIPTION
    1017. 

  1017.    *   Preparation d'une structure de donnees pour affichage de la
    1018. 

  1018.    *   hierarchie de rubriques
    1019. 

  1019.    * INPUTS
    1020. 

  1020.    *   Passage de parametre indirect via $ar
    1021. 

  1021.    *   level - numero du premier niveau, les niveaux sont numerotes a
    1022. 

  1022.    *   partir de level, la valeur par defaut est 1 ;
    1023. 

  1023.    *   maxlevel - nombre maximum de niveaux a explorer, valeur par defaut 99 ;
    1024. 

  1024.    *   do - action a effectuer. showtree: exploration de toutes les branches ;
    1025. 

  1025.    *   oidtop - oid de l'item pere de l'arboresence ;
    1026. 

  1026.    *   aliastop - alias de l'item pere de l'arboresence ;
    1027. 

  1027.    ****/
    1028. 

  1028.   function &home($ar=NULL) {
    1029. 

  1029.     XLogs::debug('XModInfoTree::home: start');
    1030. 

  1030.     $p = new XParam($ar, array('level'=>'1','deroule'=>'1','sections'=>'1','myself'=>false,'tplentry'=>'mit','maxlevel'=>99,
    1031. 

  1031. 			       'lastupd'=>false,'optimized'=>false,'cond_categ'=>array(),'where_categ'=>false));
    1032. 

  1032.     $do = $p->get('do');
    1033. 

  1033.     $myself=$p->get('myself');
    1034. 

  1034.     $niv = $p->get('level');
    1035. 

  1035.     $linkinfollow=$p->get('linkinfollow');
    1036. 

  1036.     $optimized = $p->get('optimized');
    1037. 

  1037.     $aliastop = $p->get('aliastop');
    1038. 

  1038.     $published = $p->get('_published');
    1039. 

  1039.     if(!empty($aliastop)) {
    1040. 

  1040.       if(Kernel::isAKoid($aliastop)) $oidtop=$aliastop;
    1041. 

  1041.       else $oidtop=$this->getOidFromAlias($aliastop);
    1042. 

  1042.     }
    1043. 

  1043.     if(empty($oidtop))
    1044. 

  1044.       $oidtop = $p->get('oidtop');
    1045. 

  1045. 

  1046.     $deroule = $p->get('deroule');
    1047. 

  1047.     if(!isset($deroule)) $deroule = $p->get('unfoldall');
    1048. 

  1048.     $computesections=$p->get('sections');
    1049. 

  1049.     $norubric=$p->get('norubric');
    1050. 

  1050.     $oidselected = $p->get('oid');
    1051. 

  1051.     $tplentry=$p->get('tplentry');
    1052. 

  1052.     $LANG_DATA = XShell::getLangData($p->get('LANG_DATA'));
    1053. 

  1053.     $LANG_TRAD = XShell::getLangData($p->get('LANG_TRAD'));
    1054. 

  1054.     if(!empty($LANG_TRAD)) {
    1055. 

  1055.       $lang_tree=$LANG_TRAD;
    1056. 

  1056.       $lang_other=$LANG_DATA;
    1057. 

  1057.     }
    1058. 

  1058. 

  1059.     $maxlevel = $p->get('maxlevel');
    1060. 

  1060.     $selectedfields=$p->get('selectedfields');
    1061. 

  1061.     if(XShell::admini_mode()) setSessionVar('module_name',$this->modulename);
    1062. 

  1062. 

  1063.     if($norubric) $rubric=array();
    1064. 

  1064.     else $rubric = getSessionVar('rubric');
    1065. 

  1065.     if($do=='add') {
    1066. 

  1066.       $st1=$this->getPath($oidselected);
    1067. 

  1067.       foreach($st1['oiddown'] as $i=>$oid1) $rubric[$oid1]='1';
    1068. 

  1068.     } elseif($do=='del') {
    1069. 

  1069.       unset($rubric[$oidselected]);
    1070. 

  1070.     } elseif($do=='foldall') {
    1071. 

  1071.       clearSessionVar('rubric');
    1072. 

  1072.       $rubric=array();
    1073. 

  1073.     } elseif($do=='unfoldall') {
    1074. 

  1074.       $deroul=true;
    1075. 

  1075.     } elseif($do=='showtree') {
    1076. 

  1076.       $deroul=true;
    1077. 

  1077.       $deroule=1;
    1078. 

  1078.     }
    1079. 

  1079. 

  1080.     if(empty($this->_rbrowse)) {
    1081. 

  1081.       $options=array();
    1082. 

  1082.       if(XShell::admini_mode() || $optimized) {
    1083. 

  1083. 	$options['linkup']=array('nofollowlinks'=>1);
    1084. 

  1084.       }
    1085. 

  1085.       if(empty($selectedfields)){
    1086. 

  1086. 	if(XShell::admini_mode()) $selectedfields = array('UPD','PUBLISH','title','corder','linkup','alias','picto','descr',$this->linkin);
    1087. 

  1087. 	else $selectedfields='all';
    1088. 

  1088.       }elseif(is_array($selectedfields)){
    1089. 

  1089. 	$selectedfields=array_merge($selectedfields,array('UPD','PUBLISH','title','corder','linkup','alias','picto','descr',$this->linkin));
    1090. 

  1090.       }
    1091. 

  1091.       
    1092. 

  1092.       $cond_categ = $p->get('cond_categ');
    1093. 

  1093.       $where_categ = $p->get('where_categ');
    1094. 

  1094.       
    1095. 

  1095.       $query = $this->_categories->select_query(array('cond'=>$cond_categ,
    1096. 

  1096. 						      'where'=>$where_categ,
    1097. 

  1097. 						      'selectedfields'=>$selectedfields,
    1098. 

  1098. 						      'LANG_DATA'=>$lang_tree));
    1099. 

  1099.       $this->_rbrowse=&$this->_categories->browse(array('select'=>$query,
    1100. 

  1100. 							'pagesize'=>9999,
    1101. 

  1101. 							'selectedfields'=>$selectedfields,
    1102. 

  1102. 							'_charset'=>@$_REQUEST['_charset'],
    1103. 

  1103. 							'order'=>'corder',
    1104. 

  1104. 							'options'=>$options,
    1105. 

  1105. 							'tplentry'=>TZR_RETURN_DATA,
    1106. 

  1106. 							'last'=>'9999','nocount'=>'1',
    1107. 

  1107. 							'_options'=>array('local'=>1)));
    1108. 

  1108.       $this->_rbrowse['objects_sec']=$GLOBALS['XUSER']->getObjectsAccess($this,
    1109. 

  1109. 									 XShell::getLangData(),
    1110. 

  1110. 									 $this->_rbrowse['lines_oid']);
    1111. 

  1111.       // appliquer les droits sur les objets
    1112. 

  1112.       if ($this->object_sec) {
    1113. 

  1113.         $levelMax = $GLOBALS['XUSER']->secure8maxlevel($this, null, null, XShell::getLangData());
    1114. 

  1114.         // construction de l'arbre descendant pour l'héritage des droits
    1115. 

  1115.         foreach ($this->_rbrowse['lines_oid'] as $i => $oid) {
    1116. 

  1116.           $up = $this->_rbrowse['lines_olinkup'][$i]->raw;
    1117. 

  1117.           if (empty($this->_rbrowse['treedown'][$up]))
    1118. 

  1118.             $this->_rbrowse['treedown'][$up] = array();
    1119. 

  1119.           $this->_rbrowse['treedown'][$up][] = $oid;
    1120. 

  1120.         }
    1121. 

  1121.         $this->_rbrowse['oid_index'] = array_flip($this->_rbrowse['lines_oid']);
    1122. 

  1122.         // calcul des droits cumulés héritables et des enfants
    1123. 

  1123.         foreach ($this->_rbrowse['lines_oid'] as $i => $oid) {
    1124. 

  1124.           $this->_rbrowse['upobjects_sec'][$i] = $this->_upRights($i);
    1125. 

  1125.           $this->_rbrowse['downobjects_sec'][$i] = $this->_downRights($i, $oid);
    1126. 

  1126.         }
    1127. 

  1127.         foreach ($this->_rbrowse['lines_oid'] as $i => $oid) {
    1128. 

  1128.           // si pas de droits spécifiques sur ce noeud, hériter
    1129. 

  1129.           if (array_pop(array_keys($this->_rbrowse['objects_sec'][$i])) == $levelMax  && !empty($this->_rbrowse['upobjects_sec'][$i])) {
    1130. 

  1130.             $this->_rbrowse['objects_sec'][$i] = $this->_rbrowse['upobjects_sec'][$i];
    1131. 

  1131.           }
    1132. 

  1132.         }
    1133. 

  1133.         // suppression des noeuds non lisibles et sans enfants lisibles
    1134. 

  1134.         foreach ($this->_rbrowse['lines_oid'] as $i => $oid) {
    1135. 

  1135.           if (!isset($this->_rbrowse['objects_sec'][$i]['ro']) && !isset($this->_rbrowse['downobjects_sec'][$i]['ro'])) {
    1136. 

  1136.              unset($this->_rbrowse['lines_oid'][$i]);
    1137. 

  1137.            }
    1138. 

  1138.          }
    1139. 

  1139.        }
    1140. 

  1140.        XLogs::debug('XModInfoTree: after security sort');
    1141. 

  1141.     }
    1142. 

  1142.     $rbrowse=&$this->_rbrowse;
    1143. 

  1143.     if(!empty($published)) {
    1144. 

  1144.       foreach($this->_rbrowse['lines_oid'] as $i => $oid) {
    1145. 

  1145. 	$pub1=$this->_rbrowse['lines_published'][$i];
    1146. 

  1146. 	if(empty($pub1)||($pub1==2)) {
    1147. 

  1147. 	  unset($this->_rbrowse['lines_oid'][$i]);
    1148. 

  1148. 	}
    1149. 

  1149.       }
    1150. 

  1150.     }
    1151. 

  1151. 

  1152.     // on affiche la poubelle que si c'est l'alias qui est explicitement demandé
    1153. 

  1153.     if($aliastop!='trash') {
    1154. 

  1154.       $trashoid=$this->getTrashOid();
    1155. 

  1155.       if(!empty($trashoid)) {
    1156. 

  1156. 	foreach($this->_rbrowse['lines_oid'] as $i => $oid) {
    1157. 

  1157. 	  if($oid==$trashoid) {
    1158. 

  1158. 	    unset($this->_rbrowse['lines_oid'][$i]);
    1159. 

  1159. 	    break;
    1160. 

  1160. 	  }
    1161. 

  1161. 	}
    1162. 

  1162.       }
    1163. 

  1163.     }
    1164. 

  1164. 

  1165.     // on recherche les sommets a parcourir
    1166. 

  1166.     $stack=array();
    1167. 

  1167.     $koids=array_flip($rbrowse['lines_oid']);
    1168. 

  1168.     $koidtoprocess=array_reverse($rbrowse['lines_oid'],TRUE);
    1169. 

  1169.     $todel=array();
    1170. 

  1170.     foreach($koidtoprocess as $i => $oid) {
    1171. 

  1171.       $curi=$koids[$oid];
    1172. 

  1172.       $linkup = $rbrowse['lines_olinkup'][$curi]->raw;
    1173. 

  1173.       if($myself){
    1174. 

  1174. 	if($oid==$oidtop){
    1175. 

  1175. 	  array_push($stack, array($oid,$niv,$curi,1,$linkup));
    1176. 

  1176. 	  array_push($todel, $i);
    1177. 

  1177. 	  break;
    1178. 

  1178. 	}
    1179. 

  1179.       }else{
    1180. 

  1180. 	if((empty($oidtop) && empty($linkup)) || ($oidtop==$linkup)) {
    1181. 

  1181. 	  array_push($stack, array($oid,$niv,$curi,1,$linkup));
    1182. 

  1182. 	  array_push($todel, $i);
    1183. 

  1183. 	}
    1184. 

  1184.       }
    1185. 

  1185.     }
    1186. 

  1186.     while(count($todel)>0) unset($koidtoprocess[array_pop($todel)]);
    1187. 

  1187. 

  1188.     // recherche du nombre de sous-noeuds
    1189. 

  1189.     $section_nb = selectQuery('SELECT KOIDSRC,count(KOIDSRC) from '.$this->tname.' group by KOIDSRC')
    1190. 

  1190.                   ->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP|PDO::FETCH_UNIQUE);
    1191. 

  1191. 

  1192.     // construction de l'arbre descendant
    1193. 

  1193.     $treedown = array();
    1194. 

  1194.     foreach($rbrowse['lines_oid'] as $i => $oid) {
    1195. 

  1195.       $up=$rbrowse['lines_olinkup'][$i]->raw;
    1196. 

  1196.       if(empty($treedown[$up])) $treedown[$up]=array();
    1197. 

  1197.       $treedown[$up][]=$oid;
    1198. 

  1198.     }
    1199. 

  1199. 

  1200.     // on parcourt ce qui nous interesse
    1201. 

  1201.     $r=array();
    1202. 

  1202.     $r['aliastop']=$aliastop;
    1203. 

  1203.     $r['self']=$this->_categories->display(array('tplentry'=>TZR_RETURN_DATA,'oid'=>$oidtop,'_options'=>array('local'=>true)));
    1204. 

  1204.     $r['lines_oid']=array();
    1205. 

  1205.     $lines_oid_cnt=0;
    1206. 

  1206.     $r['lines_level']=array();
    1207. 

  1207.     $r['lines_deroule']=array();
    1208. 

  1208.     $r['lines_ssrub']=array();
    1209. 

  1209.     $r['lines_sections']=array();
    1210. 

  1210.     $r['lines_lvl1pagenum']=array();
    1211. 

  1211.     $lvl1pagenum=0;
    1212. 

  1212.     $newkoids=array();
    1213. 

  1213.     while(!empty($stack)) {
    1214. 

  1214.       // on depile l'element a traiter
    1215. 

  1215.       list($curoid,$curlevel,$curi,$curderoul,$linkup)=array_pop($stack);
    1216. 

  1216.       if($curderoul && ($curlevel<=$maxlevel || isset($rubric[$curoid]) || isset($rubric[$linkup]))) {
    1217. 

  1217. 	$r['lines_oid'][]=$curoid;
    1218. 

  1218. 	$newkoids[$curoid]=$lines_oid_cnt;
    1219. 

  1219. 	$lines_oid_cnt++;
    1220. 

  1220. 	$r['lines_level'][]=$curlevel;
    1221. 

  1221. 	$r['lines_ssrub'][]=0;
    1222. 

  1222. 	if($computesections=='1') {
    1223. 

  1223. 	  if(!empty($section_nb[$curoid])) $r['lines_sections'][]=$section_nb[$curoid];
    1224. 

  1224. 	  else $r['lines_sections'][]=0;
    1225. 

  1225. 	}
    1226. 

  1226. 	if($do=='unfoldall') {
    1227. 

  1227. 	  $rubric[$curoid]='1';
    1228. 

  1228. 	}
    1229. 

  1229. 	$deroul=($do=='showtree'?'1':'0');
    1230. 

  1230. 	$deroul=$deroul || (empty($rubric[$curoid])?'0':'1');
    1231. 

  1231. 	$r['lines_deroule'][]=$deroul;
    1232. 

  1232. 	if($curlevel>1)	$lvl1pagenum++;
    1233. 

  1233. 	else $lvl1pagenum=0;
    1234. 

  1234. 	$r['lines_lvl1pagenum'][]=$lvl1pagenum;
    1235. 

  1235.       }
    1236. 

  1236.       $tmp1=@$newkoids[$rbrowse['lines_olinkup'][$curi]->raw];
    1237. 

  1237.       if(empty($r['lines_ssrub'][$tmp1])) $r['lines_ssrub'][$tmp1]=1;
    1238. 

  1238.       else $r['lines_ssrub'][$tmp1]++;
    1239. 

  1239.       if($this->linkin && $linkinfollow && $linkin && $linkin!=$rbrowse['lines_olinkup'][$curi]->raw){
    1240. 

  1240. 	$tmp1=@$newkoids[$linkin];
    1241. 

  1241. 	if(empty($r['lines_ssrub'][$tmp1])) $r['lines_ssrub'][$tmp1]=1;
    1242. 

  1242. 	else $r['lines_ssrub'][$tmp1]++;
    1243. 

  1243.       }
    1244. 

  1244.       $ocuroid=$curoid;
    1245. 

  1245.       if($this->linkin && $linkinfollow && $rbrowse['lines_o'.$this->linkin][$curi]->raw)
    1246. 

  1246. 	$curoid=$rbrowse['lines_o'.$this->linkin][$curi]->raw;
    1247. 

  1247.       if(!empty($treedown[$curoid]) && is_array($treedown[$curoid])) {
    1248. 

  1248. 	$todel=array();
    1249. 

  1249. 	foreach(array_reverse($treedown[$curoid]) as $i => $oid) {
    1250. 

  1250. 	  $oldi=$koids[$oid];
    1251. 

  1251. 	  $stack[]=array($oid,$curlevel+1,$oldi,$deroul,$ocuroid);
    1252. 

  1252. 	  $todel[]=$i;
    1253. 

  1253. 	}
    1254. 

  1254. 	foreach($todel as $t1=>$toid) unset($koidtoprocess[$toid]);
    1255. 

  1255.       }
    1256. 

  1256.       $curoid=$ocuroid;
    1257. 

  1257.     }
    1258. 

  1258.     if(!issetSessionVar('rubric')) {
    1259. 

  1259.       if(!empty($rubric)) {
    1260. 

  1260. 	setSessionVar('rubric',$rubric);
    1261. 

  1261.       }
    1262. 

  1262.     } else {
    1263. 

  1263.       if(!empty($rubric)) {
    1264. 

  1264. 	setSessionVar('rubric',$rubric);
    1265. 

  1265.       } else {
    1266. 

  1266. 	clearSessionVar('rubric');
    1267. 

  1267.       }
    1268. 

  1268.     }
    1269. 

  1269. 

  1270.     // recopie des donnees du browse
    1271. 

  1271.     $norw=array('lines_all_labels','lines_all_codes');
    1272. 

  1272.     $rwall=array('objects_sec'=>true,'upobjects_sec'=>true);
    1273. 

  1273.     foreach($r['lines_oid'] as $i => $oid) {
    1274. 

  1274.       $oldi = $koids[$oid];
    1275. 

  1275.       foreach($rbrowse as $k => $v) {
    1276. 

  1276. 	if(((substr($k, 0,6)=='lines_')||!empty($rwall[$k])) && !in_array($k,$norw)) {
    1277. 

  1277. 	  $r[$k][$i]=(empty($v[$oldi])?NULL:$v[$oldi]);
    1278. 

  1278. 	}
    1279. 

  1279. 	if(!empty($r['lines_o'.$this->linkin][$i]->raw)){
    1280. 

  1280. 	  $r['lines_sections'][$i]=@$section_nb[$r['lines_o'.$this->linkin][$i]->raw];
    1281. 

  1281. 	}
    1282. 

  1282.       }
    1283. 

  1283.       if(!empty($r['lines_o'.$this->linkin][$i]->raw)){
    1284. 

  1284. 	$r['lines_sections'][$i]=@$section_nb[$r['lines_o'.$this->linkin][$i]->raw];
    1285. 

  1285.       }
    1286. 

  1286.     }
    1287. 

  1287.     foreach($r['lines_oid'] as $i => $oid) {
    1288. 

  1288.       $r['lines_selfurl'][$i]=$this->_selfUrl($oid,$r['lines_oalias'][$i]->toText());
    1289. 

  1289.     }
    1290. 

  1290. 

  1291.     if(!empty($this->linkin) && $this->_categories->fieldExists($this->linkin)) {
    1292. 

  1292.       $r['lines_olinkin']=&$r['lines_o'.$this->linkin];
    1293. 

  1293.     }
    1294. 

  1294.     $r['moid']=$this->_moid;
    1295. 

  1295.     if (XShell::admini_mode()) {
    1296. 

  1296.       $r['_editLevel'] = array…
    1297.