PageRenderTime 59ms CodeModel.GetById 20ms RepoModel.GetById 0ms app.codeStats 0ms

/class.xthesaurusdef.inc

https://github.com/jcplat/console-seolan
PHP | 548 lines | 509 code | 20 blank | 19 comment | 127 complexity | fb377be301cb1d553995c53ec2cab67d MD5 | raw file
Possible License(s): LGPL-2.0, LGPL-2.1, GPL-3.0, Apache-2.0, BSD-3-Clause 
    

  1. <?php
    2. 

  2. class XThesaurusDef extends XLinkDef{
    3. 

  3.   public $query_formats=array('classic');
    4. 

  4.   public $quickadd=true;
    5. 

  5.   public $flabel=NULL;
    6. 

  6.   public $fparent=NULL;
    7. 

  7.   public $indexable=NULL;
    8. 

  8. 

  9.   function __construct($ar=NULL){
    10. 

  10.     parent::__construct($ar);
    11. 

  11.   }
    12. 

  12. 

  13.   function initOptions() {
    14. 

  14.     XFieldDef::initOptions();
    15. 

  15.     $this->_options->delOpt('aliasmodule');
    16. 

  16.     $this->_options->setOpt(XLabels::getSysLabel('xfielddef','sourcemodule'),'sourcemodule','module',array('emptyok'=>true));
    17. 

  17.     $this->_options->setOpt(XLabels::getSysLabel('xfielddef','xthesaurus_label'),"flabel","field",
    18. 

  18. 			    array('table'=>$this->target,'compulsory'=>false,'type'=>'XShortTextDef'));
    19. 

  19.     $this->_options->setOpt(XLabels::getSysLabel('xfielddef','xthesaurus_parent'),"fparent","field",
    20. 

  20. 			    array('table'=>$this->target,'compulsory'=>true,'type'=>XFieldDef::getObjectLinkTypes()));
    21. 

  21.     $this->_options->setOpt('Optimiser en fonction du champ',"optimizewith","field",
    22. 

  22. 			    array('table'=>$this->table,'compulsory'=>false,'type'=>array('XLinkDef', 'XThesaurusDef', 'XShortTextDef')));
    23. 

  23.     $this->_options->setOpt(XLabels::getSysLabel('xfielddef','xthesaurus_quickadd'),"quickadd","boolean");
    24. 

  24.     $querygroup=XLabels::getSysLabel('general','query','text');
    25. 

  25.     $this->_options->setOpt(XLabels::getSysLabel('xfielddef.indexable'), 'indexable', 'boolean', NULL, true, $querygroup);
    26. 

  26.   }
    27. 

  27. 

  28.   /// Recupere la liste des ascendants d'un oid
    29. 

  29.   function &getParents($value,$options,$gethtml=true){
    30. 

  30.     $lang_data=XShell::getLangData();
    31. 

  31.     $parents=array();
    32. 

  32.     if($gethtml) list($myliste,$my_flist,$first)=$this->getFieldList($options);
    33. 

  33.     if(empty($value)) return array();
    34. 

  34.     elseif(!is_array($value)) $v=array($value);
    35. 

  35.     else $v=$value;
    36. 

  36.     do{
    37. 

  37.       $rs=selectQuery('SELECT * FROM '.$this->target.' WHERE KOID IN ("'.implode('","',$v).'") AND LANG="'.$lang_data.'"');
    38. 

  38.       $v=array();
    39. 

  39.       while($rs && $ors=$rs->fetch()){
    40. 

  40. 	$parents[$ors['KOID']]=($gethtml?$this->format_display($myliste,$ors,$p1):true);
    41. 

  41. 	$v[]=$ors[$this->fparent];
    42. 

  42.       }
    43. 

  43.     }while(!empty($v));
    44. 

  44.     $parents=array_reverse($parents);
    45. 

  45.     return $parents;
    46. 

  46.   }
    47. 

  47.   
    48. 

  48.   /// Recupere la liste des descendants d'un ou pls oid
    49. 

  49.   function &getSons($value,$options,$gethtml=true){
    50. 

  50.     $lang_data=XShell::getLangData();
    51. 

  51.     $sons=array();
    52. 

  52.     if($gethtml) list($myliste,$my_flist,$first)=$this->getFieldList($options);
    53. 

  53.     if(empty($value)) return array();
    54. 

  54.     elseif(!is_array($value)) $v=array($value);
    55. 

  55.     else $v=$value;
    56. 

  56.     do{
    57. 

  57.       $rs=selectQuery('SELECT * FROM '.$this->target.' WHERE '.$this->fparent.' IN ("'.implode('","',$v).'") AND LANG="'.$lang_data.'"');
    58. 

  58.       $v=array();
    59. 

  59.       while($rs && $ors=$rs->fetch()){
    60. 

  60. 	$sons[$ors['KOID']]=($gethtml?$this->format_display($myliste,$ors,$p1):true);
    61. 

  61. 	$v[]=$ors['KOID'];
    62. 

  62.       }
    63. 

  63.     }while(!empty($v));
    64. 

  64.     return $sons;
    65. 

  65.   }
    66. 

  66. 

  67.   function my_display($value,&$options){
    68. 

  68.     static $cache=array();
    69. 

  69.     $this->modsUsingTable=0;
    70. 

  70.     if($this->target==TZR_DEFAULT_TARGET || !XDataSource::sourceExists($this->target) || empty($this->fparent)) {
    71. 

  71.       $r=$this->_newXFieldVal($options);
    72. 

  72.       $r->html='';
    73. 

  73.       return $r;
    74. 

  74.     }
    75. 

  75.     $r=parent::my_display($value,$options);
    76. 

  76.     if(!empty($r->raw)){
    77. 

  77.       $r->html=@$cache[$r->raw];
    78. 

  78.       if($r->html===null){
    79. 

  79. 	$parents=$this->getParents($value,$options);
    80. 

  80. 	$parents[$r->raw]=$r->title;
    81. 

  81. 	$cache[$r->raw]=$r->html=implode(' > ',$parents);
    82. 

  82.       }
    83. 

  83.     }
    84. 

  84.     return $r;
    85. 

  85.   }
    86. 

  86. 

  87.   function my_import($value,&$options){
    88. 

  88.     if(empty($options['srcField'])){
    89. 

  89.       $options['srcField']=$this->flabel;
    90. 

  90.     }
    91. 

  91.     return parent::my_import($value,$options);
    92. 

  92.   }
    93. 

  93. 

  94.   function my_edit($value,&$options,$fields_complement){
    95. 

  95.     $lang_data=XShell::getLangData();
    96. 

  96.     $r=$this->_newXFieldVal($options);
    97. 

  97.     $r->raw=$value;
    98. 

  98.     if($this->target==TZR_DEFAULT_TARGET || !XDataSource::sourceExists($this->target) || empty($this->fparent)) {
    99. 

  99.       $r->html='';
    100. 

  100.       return $r;
    101. 

  101.     }
    102. 

  102.     if($this->sourcemodule){
    103. 

  103.       $mod=&XModule::objectFactory(array('moid'=>$this->sourcemodule,'tplentry'=>TZR_RETURN_DATA));
    104. 

  104.       if($mod->object_sec && !$mod->secure('',':list') || !$mod->object_sec && !$mod->secure('',':ro')) return $r;
    105. 

  105.     }
    106. 

  106.     if(isset($options['intable'])) {
    107. 

  107.       $o=$options['intable'];
    108. 

  108.       $fname=$this->field.'['.$o.']';
    109. 

  109.       $hiddenname=$this->field.'_HID['.$o.']';
    110. 

  110.     } elseif(!empty($options['fieldname'])) {
    111. 

  111.       $fname=$options['fieldname'];
    112. 

  112.       $hiddenname=$options['fieldname'].'_HID';
    113. 

  113.     } else {
    114. 

  114.       $fname=$this->field;
    115. 

  115.       $hiddenname=$this->field.'_HID';
    116. 

  116.     }
    117. 

  117. 

  118.     // Liste des champs de la cible
    119. 

  119.     list($myliste,$my_flist,$first)=$this->getFieldList($options);
    120. 

  120. 

  121.     // Ligne de base
    122. 

  122.     $varid=uniqid('v');
    123. 

  123.     $delico=XLabels::getSysLabel('general','delete');
    124. 

  124.     $edit='<div id="div'.$varid.'">';
    125. 

  125.     if($this->get_multivalued() && $options['query_format']){
    126. 

  126.       $edit.='<input class="radio" type="radio" name="'.$fname.'_op" value="AND" id="'.$varid.'-AND"'.((empty($options['op']) || $options['op']=='AND')?' checked':'').'>'.
    127. 

  127.         '<label for="'.$varid.'-AND">'.XLabels::getSysLabel('xfielddef.xlinkdef_allterms').'</label><br>'.
    128. 

  128.         '<input class="radio" type="radio" name="'.$fname.'_op" value="OR" id="'.$varid.'-OR"'.($options['op']=='OR'?' checked':'').'>'.
    129. 

  129.         '<label for="'.$varid.'-OR">'.XLabels::getSysLabel('xfielddef.xlinkdef_leastaterm').'</label><br>'.
    130. 

  130.         '<input class="radio" type="radio" name="'.$fname.'_op" value="NONE" id="'.$varid.'-NONE"'.($options['op']=='NONE'?' checked':'').'>'.
    131. 

  131.         '<label for="'.$varid.'-NONE">'.XLabels::getSysLabel('xfielddef.xlinkdef_noterm').'</label><br>';
    132. 

  132.     }
    133. 

  133.     $edit.='<table id="table'.$varid.'"><tr style="display:none;"><td><a href="#" onclick="TZR.removeThesaurusValue(\''.$varid.'\',this);return false;">'.$delico.'</a><input type="hidden" name="'.$fname.'[]" value=""></td><td></td></tr>';
    134. 

  134. 

  135.     // Affiche les valeurs en cours
    136. 

  136.     if(!empty($value)){
    137. 

  137.       if(!is_array($value)) $value=array($value=>'1');
    138. 

  138.       $rs=selectQuery('SELECT DISTINCT '.$my_flist.' FROM '.$this->target.' WHERE KOID IN ("'.implode('","',array_keys($value)).'") '.
    139. 

  139. 		      'AND LANG="'.$lang_data.'"'.($first?' ORDER BY '.$first:''));
    140. 

  140.       while($ors=$rs->fetch()){
    141. 

  141. 	if($mod && $mod->object_sec && !$mod->secure($ors['KOID'],':ro')) continue;
    142. 

  142. 	$parents=$this->getParents($ors['KOID'],$options);
    143. 

  143. 	$parents[$ors['KOID']]=$this->format_display($myliste,$ors,$p1);
    144. 

  144. 	$display=implode(' > ',$parents);
    145. 

  145. 	$edit.='<tr><td><a href="#" onclick="TZR.removeThesaurusValue(\''.$varid.'\',\''.$ors['KOID'].'\');return false;">'.$delico.'</a><input type="hidden" name="'.$fname.'[]" value="'.$ors['KOID'].'"></td><td>'.$display.'</td></tr>';
    146. 

  146.       }
    147. 

  147.     }
    148. 

  148.     $edit.='</table>';
    149. 

  149.     // Ajout d'un input d'autompletion pour une saisie directe
    150. 

  150.     $edit.='<input autocomplete="off" id="_INPUT'.$varid.'" size="30" type="text" value="" class="tzr-link">';
    151. 

  151.     $url=TZR_AJAX8.'?class=xthesaurusdef&function=xthesaurusdef_autocomplete&_silent=1&query_format='.$options['query_format'];
    152. 

  152.     $edit.='<script type="text/javascript" language="javascript">TZR.addAutoComplete("'.$url.'","'.$varid.'","'.$options['fmoid'].'",'.
    153. 

  153.       '"'.$this->table.'","'.$this->field.'","",TZR.autocompleteThesaurus);</script>';
    154. 

  154.       
    155. 

  155.     // calcul de l'arbo
    156. 

  156.     if ($options['query_format'] == XFieldDef::QUICKQUERY_FORMAT) {
    157. 

  157.       $rw = 0;
    158. 

  158.       $quickquery = 1;
    159. 

  159.       $tree = array('htmlFiltered' => '', 'html' => '
    160. 

  160.         <ul class="simpleTree quickquery treefiltered">
    161. 

  161.           <li class="root close" onclick="TZR.thesaurusClick(\''.$varid.'\', event)">
    162. 

  162.             <span><span>'.$this->label.'</span></span>
    163. 

  163.             <ul style="display:none" id="top'.$varid.'"></ul>
    164. 

  164.           </li>
    165. 

  165.           <li class="fin_float"></li>
    166. 

  166.         </ul>
    167. 

  167.       ');
    168. 

  168.     } else {
    169. 

  169.       $rw = $this->isAutorizedToAdd($options);
    170. 

  170.       $quickquery = 0;
    171. 

  171.       $tree = $this->getTree($value, $options, $varid, $mod, $rw, $fields_complement);
    172. 

  172.     }
    173. 

  173.     $edit.='<div id="treecontainer'.$varid.'" class="thesaurustree">'.$tree['htmlFiltered'].$tree['html'].'</div>';
    174. 

  174.     $edit.='<script type="text/javascript">
    175. 

  175.       jQuery("#treecontainer'.$varid.'").data({varid:"'.$varid.'", moid:"'.$options['fmoid'].'", xtable:"'.$this->table.'", field:"'.$this->field.'", rw:'.(int)$rw.',optimizewith:"'.$this->optimizewith.'",optimizevalues:"'.implode(' ',$fields_complement[$this->optimizewith]).'",quickquery:'.$quickquery.', reloadUrl:"'.TZR_AJAX8.'?class=xthesaurusdef&function=xthesaurusdef_loadtree&moid='.$options['fmoid'].'&table='.$this->table.'&field='.$this->field.'&varid='.$varid.'"});';
    176. 

  176.     if ($this->optimizewith)
    177. 

  177.       $edit.='TZR.activeThesaurus("'.$varid.'","'.$this->optimizewith.'");';
    178. 

  178.     if($this->compulsory){
    179. 

  179.       $color=XIni::get('error_color');
    180. 

  180.       $edit.='TZR.addValidator(["'.$varid.'","","'.addslashes($this->label).'","'.$color.'","XThesaurusDef"]);';
    181. 

  181.     }
    182. 

  182.     $edit.='</script></div>';
    183. 

  183.     $r->varid=$varid;
    184. 

  184.     $r->html=$edit;
    185. 

  185.     return $r;
    186. 

  186.   }
    187. 

  187. 

  188.   /// Calcule le menu
    189. 

  189.   function getTree($value, $options, $varid, $mod=null, $rw, $fields_complement=array()) {
    190. 

  190.     $lang_data = XShell::getLangData();
    191. 

  191.     $stmt = selectQuery('select distinct '.$this->fparent.', KOID, '.$this->flabel.' from '.$this->target.' where LANG="'.$lang_data.'" order by '.$this->flabel);
    192. 

  192.     if (!$stmt)
    193. 

  193.       return;
    194. 

  194.     $items = $stmt->fetchAll(PDO::FETCH_GROUP);
    195. 

  195.     $nbItems = $stmt->rowCount();
    196. 

  196.     $used_values=null;
    197. 

  197.     // dans le cas d'une contrainte
    198. 

  198.     if ($this->optimizewith) {
    199. 

  199.       if (is_array($fields_complement[$this->optimizewith])) // champ multivalué déjà my_edité
    200. 

  200.         $filteringValues = array_keys($fields_complement[$this->optimizewith]);
    201. 

  201.       else
    202. 

  202.         $filteringValues = preg_split('/\|\|/', $fields_complement[$this->optimizewith], 0, PREG_SPLIT_NO_EMPTY);
    203. 

  203. 

  204.       if (!empty($filteringValues)) {
    205. 

  205.         foreach ($filteringValues as $filteringValue)
    206. 

  206.           $_filter[] = 'instr('.$this->optimizewith.', "'.$filteringValue.'")';
    207. 

  207.         $filter = '(' . implode(' or ', $_filter)  . ')';
    208. 

  208.         $used_values = $this->_getUsedValues($filter, null, $options);
    209. 

  209.       }
    210. 

  210.     }
    211. 

  211.     // calcul des droits du module source
    212. 

  212.     if ($mod && $mod->object_sec) {
    213. 

  213.       $modLevels = $GLOBALS['XUSER']->getObjectAccess($mod, XShell::getLangData());
    214. 

  214.       $_secObjects = $GLOBALS['XUSER']::getObjectsWithSec($mod, XUser::get_current_user_uid());
    215. 

  215.       $rights = $GLOBALS['XUSER']->getObjectsAccess($mod, XShell::getLangData(), $_secObjects);
    216. 

  216.       foreach ($_secObjects as $i => $oid)
    217. 

  217.         $secObjects[$oid] = $rights[$i];
    218. 

  218.       $secObjects['default'] = $modLevels[0];
    219. 

  219.     } else
    220. 

  220.       $secObjects = null;
    221. 

  221.     $options['withSiblings'] = XShell::admini_mode() && !@$options['quickquery'];
    222. 

  222.     $tree = $this->_getTree(@$options['top'], $items, $secObjects, $value, $used_values, $options, $varid);
    223. 

  223. 

  224.     // html de l'arbo
    225. 

  225.     if (@$options['top'])
    226. 

  226.       return array('html' => $this->_makeHtml($tree, $varid, 20));
    227. 

  227.     if (!$options['justFiltered'])
    228. 

  228.       $htmlFull = $this->_makeHtml($tree, $varid, ($nbItems > 500) ? 1 : 10);
    229. 

  229.     if ($this->optimizewith)
    230. 

  230.       $_htmlFiltered = $this->_makeHtmlFiltered($tree, $varid, 10);//$options['justFiltered'] ? 10 : 0);
    231. 

  231.     if ($this->optimizewith) {
    232. 

  232.       $htmlFiltered = '
    233. 

  233.         <ul class="simpleTree treefiltered" '.($_htmlFiltered ? '' : ' style="display:none"').'>
    234. 

  234.           <li class="root close" onclick="TZR.thesaurusClick(\''.$varid.'\', event)">
    235. 

  235.             <span><span>'.$this->label.' - '.XLabels::getSysLabel('xfielddef','filtered').'</span></span>
    236. 

  236.             <ul style="display:none" id="topfiltered'.$varid.'">'.
    237. 

  237.               $_htmlFiltered . '
    238. 

  238.             </ul>
    239. 

  239.           </li>
    240. 

  240.           <li class="fin_float"></li>
    241. 

  241.         </ul>';
    242. 

  242.     }
    243. 

  243.     if (@$options['quickquery']) {
    244. 

  244.       $html = $htmlFull;
    245. 

  245.     } elseif (!$options['justFiltered']) {
    246. 

  246.       $html = '
    247. 

  247.         <ul class="simpleTree full">
    248. 

  248.           <li class="root close" onclick="TZR.thesaurusClick(\''.$varid.'\', event)">
    249. 

  249.             <span><span>'.$this->label.'</span></span>
    250. 

  250.             <ul style="display:none" id="top'.$varid.'">'.
    251. 

  251.               $htmlFull . '
    252. 

  252.             </ul>
    253. 

  253.           </li>
    254. 

  254.           <li class="fin_float"></li>
    255. 

  255.         </ul>';
    256. 

  256.     }
    257. 

  257.     return array('html' => $html, 'htmlFiltered' => $htmlFiltered);
    258. 

  258.   }
    259. 

  259. 

  260.   /// Construit l'arborescence
    261. 

  261.   private function _getTree($oid, &$items, $secObjects, $value, $used_values, $options) {
    262. 

  262.     foreach ($items[$oid] as $i => $item) {
    263. 

  263.       $item_oid = $item['KOID'];
    264. 

  264.       // Filtre sur les droits du module source
    265. 

  265.       if ($secObjects && isset($secObjects[$item_oid]) && !isset($secObjects[$item_oid]['ro']))
    266. 

  266.         continue;
    267. 

  267.       // les items dans le nom commencent par un . sont cachés
    268. 

  268.       if (substr($item[$this->flabel],0,1)=='.') 
    269. 

  269.         continue;
    270. 

  270. 

  271.       $item['selected'] = isset($value[$item_oid]);
    272. 

  272.       $item['active'] = $item['selected'] || isset($used_values[$item_oid]);
    273. 

  273.       if (isset($items[$item_oid])){
    274. 

  274.         $item['subtree'] = $this->_getTree($item_oid, $items, $secObjects, $value, $used_values, $options);
    275. 

  275.         $item['active'] |= $item['subtree']['active'];
    276. 

  276.       }
    277. 

  277.       // prendre les fils des noeuds selectionnés
    278. 

  278.       if ($item['selected'] && $item['subtree'] && !$item['subtree']['active']) { 
    279. 

  279.         $item['subtree']['getAll'] = true;
    280. 

  280.       }
    281. 

  281.       $tree['items'][] = $item;
    282. 

  282.       if ($item['active'])
    283. 

  283.         $tree['activeItems'][] = $item;
    284. 

  284.       // prendre les freres des feuilles actives
    285. 

  285.       if ($options['withSiblings'] && $item['active'] && !isset($item['subtree'])) { 
    286. 

  286.         $tree['getAll'] = true;
    287. 

  287.       }
    288. 

  288.       $tree['active'] |= $item['active'];
    289. 

  289.     }
    290. 

  290.     $tree['oid'] = $oid;
    291. 

  291.     return $tree;
    292. 

  292.   }
    293. 

  293.   /// Génère le html
    294. 

  294.   private function _makeHtml(&$tree, $varid, $depth=0) {
    295. 

  295.     if (empty($tree) || !$depth)
    296. 

  296.       return '';
    297. 

  297.     $html = '';
    298. 

  298.     $last = count($tree['items']) -1;
    299. 

  299.     foreach ($tree['items'] as $i => &$item) {
    300. 

  300.       $html .= ' <li class="line">&nbsp;</li><li tzroid="'.$item['KOID'].'" class="'.(isset($item['subtree']) ? 'folder close' : 'doc').($i == $last?' last':'').'"><div style="position:absolute;"><div class="ico"></div></div><img class="trigger" src="/tzr/templates/ico/jtree/spacer.gif" border="0" style="float:left;_float:none"><span class="text"><span'.($item['selected'] ? ' class="selected"' : '').'>'.$item[$this->flabel].'</span></span>';
    301. 

  301.       if (isset($item['subtree'])) {
    302. 

  302.         $html .= '<ul style="display:none">'.$this->_makeHtml($item['subtree'], $varid, $depth-1).'</ul>';
    303. 

  303.       }
    304. 

  304.       $html .= '</li>';
    305. 

  305.     }
    306. 

  306.     unset($item);
    307. 

  307.     $html .= '<li class="line-last">&nbsp;</li>';
    308. 

  308.     return $html;
    309. 

  309.   }
    310. 

  310.   /// Génère le html des entrées filtrées
    311. 

  311.   private function _makeHtmlFiltered($tree, $varid, $depth=0) {
    312. 

  312.     if (empty($tree))
    313. 

  313.       return '';
    314. 

  314.     $last = count($tree['activeItems']) -1;
    315. 

  315.     foreach ($tree['activeItems'] as $i => $item) {
    316. 

  316.       if ($item['subtree']) {
    317. 

  317.         if ($item['subtree']['getAll'])
    318. 

  318.           $subHtml = $this->_makeHtml($item['subtree'], $varid, $depth-1);
    319. 

  319.         else
    320. 

  320.           $subHtml = $this->_makeHtmlFiltered($item['subtree'], $varid, $depth-1);
    321. 

  321.       } else
    322. 

  322.         $subHtml = '';
    323. 

  323.       $html .= ' <li class="line">&nbsp;</li><li tzroid="'.$item['KOID'].'" class="'.($item['subtree']['activeItems'] ? 'folder close' : 'doc').($i == $last?' last':'').'"><div style="position:absolute;"><div class="ico"></div></div><img class="trigger" src="/tzr/templates/ico/jtree/spacer.gif" border="0" style="float:left;_float:none"><span class="text"><span'.($item['selected'] ? ' class="selected"' : '').'>'.$item[$this->flabel].'</span></span>';
    324. 

  324.       if ($item['subtree']) {
    325. 

  325.         $html .= '<ul style="display:none">'.($depth>0 ? $subHtml :'').'</ul>';
    326. 

  326.       }
    327. 

  327.       $html .= '</li>';
    328. 

  328.     }
    329. 

  329.     if ($html)
    330. 

  330.       return $html . '<li class="line-last">&nbsp;</li>';
    331. 

  331.     else 
    332. 

  332.       return '';
    333. 

  333.   }
    334. 

  334. 

  335.   /// Retourn vrai si l'utilisateur peut créer de nouveau mots clé à la volée
    336. 

  336.   function isAutorizedToAdd(&$options){
    337. 

  337.     if(!empty($options['query_format']) || empty($this->flabel) || !$this->quickadd) return false;
    338. 

  338.     return parent::isAutorizedToAdd($options);
    339. 

  339.   }
    340. 

  340. 

  341.   function my_quickquery($value,$options=NULL) {
    342. 

  342.     $r=$this->my_query($value,$options);
    343. 

  343.     $r->html.='<input type="hidden" value="'.$this->field.'" name="_FIELDS['.$this->field.']">';
    344. 

  344.     return $r;
    345. 

  345.   }
    346. 

  346. 

  347.   function my_query($value,&$options){
    348. 

  348.     $fname=(isset($options['fieldname'])?$options['fieldname']:$this->field);
    349. 

  349.     $hiddenname=$fname.'_HID';
    350. 

  350.     $options['fieldname']=$fname;
    351. 

  351.     if(is_array($value)){
    352. 

  352.       $keys=array_keys($value);
    353. 

  353.       if(!Kernel::isAKoid($keys[0])) $value=array_flip($value);
    354. 

  354.     }
    355. 

  355.     if ($this->optimizewith) {
    356. 

  356.       foreach ($options['fields_complement']['_FIELDS'] as $id => $fieldname)
    357. 

  357.         if ($fieldname == $this->optimizewith) {
    358. 

  358.           $idx = $id;
    359. 

  359.           break;
    360. 

  360.         }
    361. 

  361.       if ($idx)
    362. 

  362.         $optimizeValues = @array_filter($options['fields_complement'][$idx]);
    363. 

  363.     }
    364. 

  364.     return $this->my_edit($value,$options, array($this->optimizewith => $optimizeValues));
    365. 

  365.   }
    366. 

  366. 

  367.   function post_query(&$o,$options){
    368. 

  368.     if(is_array($o->value)){
    369. 

  369.       $v1op=$o->op;
    370. 

  370.       if($v1op!='OR' && $v1op!='NONE') $v1op='AND';
    371. 

  371.       $rq=array();
    372. 

  372.       foreach($o->value as $v){
    373. 

  373. 	if(empty($v)) continue;
    374. 

  374. 	$oids=$this->getSons($v,$options,false);
    375. 

  375. 	$oids[$v]='';
    376. 

  376. 	$rq2=array();
    377. 

  377. 	foreach($oids as $oid=>$foo){
    378. 

  378. 	  $tmp=(object)array('op'=>'OR','value'=>$oid);
    379. 

  379. 	  parent::post_query($tmp,$options);
    380. 

  380. 	  $rq2[]=$tmp->rq;
    381. 

  381. 	}
    382. 

  382. 	$rq[]='('.implode('OR',$rq2).')';
    383. 

  383.       }
    384. 

  384.       if (empty($rq))
    385. 

  385.         $o->rq='';
    386. 

  386.       elseif ($v1op == 'NONE')
    387. 

  387.         $o->rq='(!'.implode(' AND !',$rq).')';
    388. 

  388.       else
    389. 

  389.         $o->rq='('.implode($v1op,$rq).')';
    390. 

  390.       return $o;
    391. 

  391.     }
    392. 

  392.     return parent::post_query($o,$options);
    393. 

  393.   }
    394. 

  394. }
    395. 

  395. function xthesaurusdef_loadtree() {
    396. 

  396.   activeSec();
    397. 

  397.   $moid=$_REQUEST['moid'];
    398. 

  398.   $table=$_REQUEST['table'];
    399. 

  399.   $field=$_REQUEST['field'];
    400. 

  400.   if(empty($moid) || empty($table) || empty($field)) die();
    401. 

  401.   $xds=XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS='.$table);
    402. 

  402.   $ofield=$xds->getField($field);
    403. 

  403.   if($ofield->sourcemodule){
    404. 

  404.     $smod=&XModule::objectFactory(array('moid'=>$ofield->sourcemodule,'tplentry'=>TZR_RETURN_DATA));
    405. 

  405.     $ok=$smod->secure('',':ro');
    406. 

  406.   }else{
    407. 

  407.     $mod=&XModule::objectFactory(array('moid'=>$moid,'tplentry'=>TZR_RETURN_DATA));
    408. 

  408.     $ok=$mod->secure('',':list');
    409. 

  409.   }
    410. 

  410.   if(!$ok) die('');
    411. 

  411.   $value = array_flip($_REQUEST['value']);
    412. 

  412.   $fields_complement = array($ofield->optimizewith => array_flip($_REQUEST['filter']));
    413. 

  413.   $options=array('fmoid'=>$moid, 'justFiltered' => (@$_REQUEST['justfiltered'] && @$_REQUEST['filter']));
    414. 

  414.   $rw = $ofield->isAutorizedToAdd($options);
    415. 

  415.   $options['top'] = $_REQUEST['top'];
    416. 

  416.   $options['quickquery'] = @$_REQUEST['quickquery'];
    417. 

  417.   $tree=$ofield->getTree($value,$options,$_REQUEST['varid'],$smod,$rw,$fields_complement);
    418. 

  418.   if ($options['justFiltered'])
    419. 

  419.     die($tree['htmlFiltered']);
    420. 

  420.   else
    421. 

  421.     die($tree['html']);
    422. 

  422. }
    423. 

  423. function xthesaurusdef_delvalue(){
    424. 

  424.   activeSec();
    425. 

  425.   $moid=$_REQUEST['moid'];
    426. 

  426.   $table=$_REQUEST['table'];
    427. 

  427.   $field=$_REQUEST['field'];
    428. 

  428.   $oid=$_REQUEST['oid'];
    429. 

  429.   if(empty($moid) || empty($table) || empty($field) || empty($oid)) die();
    430. 

  430.   $xds=XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS='.$table);
    431. 

  431.   $ofield=$xds->getField($field);
    432. 

  432.   if($ofield->sourcemodule){
    433. 

  433.     $mod=&XModule::objectFactory(array('moid'=>$ofield->sourcemodule,'tplentry'=>TZR_RETURN_DATA));
    434. 

  434.     $ok=$mod->secure($oid,':rw');
    435. 

  435.   }else{
    436. 

  436.     $mod=&XModule::objectFactory(array('moid'=>$moid,'tplentry'=>TZR_RETURN_DATA));
    437. 

  437.     $ok=$mod->secure('',':rwv');
    438. 

  438.   }
    439. 

  439.   if(!$ok) die(json_encode(''));
    440. 

  440.   $xds=XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS='.$ofield->target);
    441. 

  441.   $rs=selectQuery('select KOID from '.$ofield->target.' where KOID="'.$oid.'" or '.$ofield->fparent.'="'.$oid.'"');
    442. 

  442.   while($rs && $ors=$rs->fetch()) $xds->del(array('oid'=>$ors['KOID'],'tplentry'=>TZR_RETURN_DATA));
    443. 

  443.   die('ok');
    444. 

  444. }
    445. 

  445. function xthesaurusdef_editvalue(){
    446. 

  446.   activeSec();
    447. 

  447.   $moid=$_REQUEST['moid'];
    448. 

  448.   $table=$_REQUEST['table'];
    449. 

  449.   $field=$_REQUEST['field'];
    450. 

  450.   $oid=$_REQUEST['oid'];
    451. 

  451.   $value=$_REQUEST['value'];
    452. 

  452.   if(empty($moid) || empty($table) || empty($field) || empty($oid)) die();
    453. 

  453.   $xds=XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS='.$table);
    454. 

  454.   $ofield=$xds->getField($field);
    455. 

  455.   if($ofield->sourcemodule){
    456. 

  456.     $mod=&XModule::objectFactory(array('moid'=>$ofield->sourcemodule,'tplentry'=>TZR_RETURN_DATA));
    457. 

  457.     $ok=$mod->secure($oid,':rw');
    458. 

  458.   }else{
    459. 

  459.     $mod=&XModule::objectFactory(array('moid'=>$moid,'tplentry'=>TZR_RETURN_DATA));
    460. 

  460.     $ok=$mod->secure('',':rwv');
    461. 

  461.   }
    462. 

  462.   if(!$ok) die();
    463. 

  463.   $xds=XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS='.$ofield->target);
    464. 

  464.   $xds->procEdit(array('oid'=>$oid,$ofield->flabel=>$value,'tplentry'=>TZR_RETURN_DATA));
    465. 

  465.   die('ok');
    466. 

  466. }
    467. 

  467. function xthesaurusdef_addvalue(){
    468. 

  468.   activeSec();
    469. 

  469.   $moid=$_REQUEST['moid'];
    470. 

  470.   $table=$_REQUEST['table'];
    471. 

  471.   $field=$_REQUEST['field'];
    472. 

  472.   $parentoid=$_REQUEST['parentoid'];
    473. 

  473.   $value=$_REQUEST['value'];
    474. 

  474.   if(empty($moid) || empty($table) || empty($field) || empty($value)) die();
    475. 

  475.   $xds=XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS='.$table);
    476. 

  476.   $ofield=$xds->getField($field);
    477. 

  477.   if($ofield->sourcemodule){
    478. 

  478.     $mod=&XModule::objectFactory(array('moid'=>$ofield->sourcemodule,'tplentry'=>TZR_RETURN_DATA));
    479. 

  479.     $ok=$mod->secure('',':rw');
    480. 

  480.   }else{
    481. 

  481.     $mod=&XModule::objectFactory(array('moid'=>$moid,'tplentry'=>TZR_RETURN_DATA));
    482. 

  482.     $ok=$mod->secure('',':rwv');
    483. 

  483.   }
    484. 

  484.   if(!$ok) die();
    485. 

  485.   $xds=XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS='.$ofield->target);
    486. 

  486.   $ret=$xds->procInput(array($ofield->fparent=>$parentoid,$ofield->flabel=>$value,'tplentry'=>TZR_RETURN_DATA));
    487. 

  487.   die($ret['oid']);
    488. 

  488. }
    489. 

  489. function xthesaurusdef_copyvalue(){
    490. 

  490.   activeSec();
    491. 

  491.   $moid=$_REQUEST['moid'];
    492. 

  492.   $table=$_REQUEST['table'];
    493. 

  493.   $field=$_REQUEST['field'];
    494. 

  494.   $parentoid=$_REQUEST['parentoid'];
    495. 

  495.   $value=$_REQUEST['value'];
    496. 

  496.   if(empty($moid) || empty($table) || empty($field) || empty($value)) die();
    497. 

  497.   $xds=XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS='.$table);
    498. 

  498.   $ofield=$xds->getField($field);
    499. 

  499.   if($ofield->sourcemodule){
    500. 

  500.     $mod=&XModule::objectFactory(array('moid'=>$ofield->sourcemodule,'tplentry'=>TZR_RETURN_DATA));
    501. 

  501.     $ok=$mod->secure($value,':rw');
    502. 

  502.   }else{
    503. 

  503.     $mod=&XModule::objectFactory(array('moid'=>$moid,'tplentry'=>TZR_RETURN_DATA));
    504. 

  504.     $ok=$mod->secure('',':rwv');
    505. 

  505.   }
    506. 

  506.   if(!$ok) die();
    507. 

  507.   $xds=XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS='.$ofield->target);
    508. 

  508.   $ret=$xds->duplicate(array('oid'=>$value));
    509. 

  509.   updateQuery('update '.$ofield->target.' set '.$ofield->fparent.'="'.$parentoid.'" where KOID="'.$ret.'"');
    510. 

  510.   die($ret);
    511. 

  511. }
    512. 

  512. function xthesaurusdef_cutvalue(){
    513. 

  513.   activeSec();
    514. 

  514.   $moid=$_REQUEST['moid'];
    515. 

  515.   $table=$_REQUEST['table'];
    516. 

  516.   $field=$_REQUEST['field'];
    517. 

  517.   $parentoid=$_REQUEST['parentoid'];
    518. 

  518.   $value=$_REQUEST['value'];
    519. 

  519.   if(empty($moid) || empty($table) || empty($field) || empty($value)) die();
    520. 

  520.   $xds=XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS='.$table);
    521. 

  521.   $ofield=$xds->getField($field);
    522. 

  522.   if($ofield->sourcemodule){
    523. 

  523.     $mod=&XModule::objectFactory(array('moid'=>$ofield->sourcemodule,'tplentry'=>TZR_RETURN_DATA));
    524. 

  524.     $ok=$mod->secure($value,':rw');
    525. 

  525.   }else{
    526. 

  526.     $mod=&XModule::objectFactory(array('moid'=>$moid,'tplentry'=>TZR_RETURN_DATA));
    527. 

  527.     $ok=$mod->secure('',':rwv');
    528. 

  528.   }
    529. 

  529.   if(!$ok) die();
    530. 

  530.   $xds=XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS='.$ofield->target);
    531. 

  531.   updateQuery('update '.$ofield->target.' set '.$ofield->fparent.'="'.$parentoid.'" where KOID="'.$value.'"');
    532. 

  532.   die($value);
    533. 

  533. }
    534. 

  534. function xthesaurusdef_autocomplete() {
    535. 

  535.   require_once('class.xlinkdef.inc');
    536. 

  536.   $r=&xlinkdef_autocomplete(true);
    537. 

  537.   $ofield=$r['field'];
    538. 

  538.   $suggestions=$r['suggestions'];
    539. 

  539.   foreach($suggestions as $koid=>$value){
    540. 

  540.     $parents=$ofield->getParents($koid);
    541. 

  541.     $parents[$koid]=$value;
    542. 

  542.     echo implode(' > ',$parents)."|$koid\n";
    543. 

  543.   }
    544. 

  544.   if(count($suggestions)==0) echo XLabels::getSysLabel('xfielddef','no_result')."\n";
    545. 

  545.   elseif($ret['state']=='toomuch') echo (XLabels::getSysLabel('xfielddef','too_many_results'))."\n";
    546. 

  546.   return null;
    547. 

  547. }
    548. 

  548. ?>
    549. 

  549.