PageRenderTime 61ms CodeModel.GetById 21ms RepoModel.GetById 1ms app.codeStats 0ms

/class.xfielddef.inc

https://github.com/jcplat/console-seolan
PHP | 1133 lines | 1028 code | 47 blank | 58 comment | 243 complexity | 1f8db97a9ff47e1eefb20d4e1db56e8a 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. // nom de la classe, type de la donnee, fcount personnalisable, utilise le target, absent de toutes listes, absent en mode simplifié
    3. 

  3. $_FTYPE['XChronoDef'] =         array('XChronoDef', 	'Data',	false,false,false,true);
    4. 

  4. $_FTYPE['XBoolDef'] =           array('XBoolDef', 	'Oid',	false,false,false,false);
    5. 

  5. $_FTYPE['XColorDef'] =          array('XColorDef', 	'Data',	false,false,false,false);
    6. 

  6. $_FTYPE['XDateDef']  =          array('XDateDef', 	'Data',	false,false,false,false);
    7. 

  7. $_FTYPE['XTimeDef'] =           array('XTimeDef', 	'Data',	false,false,false,true);
    8. 

  8. $_FTYPE['XUrlDef'] =            array('XUrlDef', 	'Data',	false,false,false,false);
    9. 

  9. $_FTYPE['XLinkDef'] =           array('XLinkDef', 	'Oid',	false,true,false,true);
    10. 

  10. $_FTYPE['XThesaurusDef'] =      array('XThesaurusDef', 	'Oid',	false,true,false,true);
    11. 

  11. $_FTYPE['XPasswdDef'] =         array('XPasswdDef', 	'Data',	true,false,false,true);
    12. 

  12. $_FTYPE['XStringSetDef']=       array('XStringSetDef',	'Oid',	false,false,false,false);
    13. 

  13. $_FTYPE['XFileDef'] =           array('XFileDef', 	'Data',	false,false,false,false);
    14. 

  14. $_FTYPE['XFolderDef'] =         array('XFolderDef', 	'Data',	false,false,false,true);
    15. 

  15. $_FTYPE['XDocumentDef'] = 	array('XDocumentDef', 	'Oid',	false,false,false,true);
    16. 

  16. $_FTYPE['XExtImageDef'] =       array('XExtImageDef', 	'Data',	false,false,false,true);
    17. 

  17. $_FTYPE['XImageDef'] =          array('XImageDef', 	'Data',	false,false,false,false);
    18. 

  18. $_FTYPE['XDateTimeDef'] =       array('XDateTimeDef', 	'Data',	false,false,false,true);
    19. 

  19. $_FTYPE['XTimestampDef'] =      array('XTimestampDef', 	'Data',	false,false,false,true);
    20. 

  20. $_FTYPE['XOrderDef'] = 		array('XOrderDef', 	'Data',	false,false,false,false);
    21. 

  21. $_FTYPE['XRealDef'] = 		array('XRealDef', 	'Data',	true,true,false,false);
    22. 

  22. $_FTYPE['XTextDef'] = 		array('XTextDef', 	'Data',	true,false,false,false);
    23. 

  23. $_FTYPE['XExprDef'] = 		array('XExprDef', 	'Data',	true,false,false,false);
    24. 

  24. $_FTYPE['XShortTextDef'] = 	array('XShortTextDef', 	'Data',	true,false,false,false);
    25. 

  25. $_FTYPE['XRichTextDef'] = 	array('XRichTextDef', 	'Data',	true,false,false,false);
    26. 

  26. $_FTYPE['XBaseDef'] = 		array('XBaseDef', 	'Data',	true,false,false,true);
    27. 

  27. $_FTYPE['XTableDef'] = 		array('XTableDef', 	'Data',	true,false,false,true);
    28. 

  28. $_FTYPE['XQueryDef'] = 		array('XQueryDef', 	'Data',	false,false,false,true);
    29. 

  29. $_FTYPE['XModuleDef'] = 	array('XModuleDef', 	'Oid',	false,false,false,true);
    30. 

  30. $_FTYPE['XGeodesicCoordinatesDef'] =    array('XGeodesicCoordinatesDef', 	'Data',	false,false,false,false);
    31. 

  31. $_FTYPE['XTableFieldDef'] = 	array('XTableFieldDef', 'Oid',	false,true,false,true);
    32. 

  32. $_FTYPE['XEvalDef'] =           array('XEvalDef',       'Data', false, false, false, true);
    33. 

  33. $_FTYPE['XOptionsDef'] =        array('XOptionsDef',    'Data', false, false, false, true);
    34. 

  34. $_FTYPE['XLink2Def'] =           array('XLink2Def', 	'Oid',	false,true,false,true);
    35. 

  35. $_FTYPE['XGmapPointDef'] =      array('XGmapPointDef',  'Data', false, false, false, false);
    36. 

  36. 

  37. class XFieldVal {
    38. 

  38.   public $raw=NULL;
    39. 

  39.   public $field=NULL;
    40. 

  40.   public $table=NULL;
    41. 

  41.   public $html='';
    42. 

  42.   public $filename=NULL;
    43. 

  43.   public $fielddef=NULL;
    44. 

  44.   public $trace=NULL;
    45. 

  45.   public $title=NULL;
    46. 

  46.   public $html_default=NULL;
    47. 

  47.   public $_cache=array();
    48. 

  48.   function __construct() {
    49. 

  49.     $this->raw='';
    50. 

  50.   }
    51. 

  51.   /// Appel une fonction du xfielddef
    52. 

  52.   public function __call($f,$param){
    53. 

  53.     array_unshift($param, $this);
    54. 

  54.     return call_user_func_array(array($this->fielddef,$f),$param);
    55. 

  55.   }
    56. 

  56.   /// Retourne une propriété encore non definie
    57. 

  57.   public function __get($name){
    58. 

  58.     if($name=='text') return $this->fielddef->toText($this);
    59. 

  59.     return false;
    60. 

  60.   }
    61. 

  61. }
    62. 

  62. 

  63. class XFieldQuery {
    64. 

  64.   public $op=NULL;
    65. 

  65.   public $value=NULL;
    66. 

  66.   public $fmt=NULL;
    67. 

  67.   public $hid=NULL;
    68. 

  68.   public $par=NULL;
    69. 

  69.   public $quote="'";
    70. 

  70.   function __construct() {
    71. 

  71.   }
    72. 

  72.   /// Appel une fonction du xfielddef
    73. 

  73.   public function __call($f,$param){
    74. 

  74.     array_unshift($param, $this);
    75. 

  75.     return call_user_func_array(array($this->fielddef,$f),$param);
    76. 

  76.   }
    77. 

  77. }
    78. 

  78. 

  79. $_MIMES=array('application/pdf'=>array('application/pdf','xpdf', 'pdftotext <src> <dst>'));
    80. 

  80. 

  81. /// Classe mere de toutes les classes gerant des champs
    82. 

  82. /**
    83. 

  83.  Cette classe decrit l'interface de toutes les classes de
    84. 

  84.  manipulation des donnees atomiques. Elle inclut l'affichage,
    85. 

  85.  l'edition, la mise a jour d'un champ. Chaque type de donnees est
    86. 

  86.  manipule par une classe specifiques.
    87. 

    88. 

  88. */
    89. 

  89. abstract class XFieldDef  {
    90. 

  90.   const QUERY_FORMAT='query';
    91. 

  91.   const QUICKQUERY_FORMAT='quick';
    92. 

  92. 

  93.   public $exif_source='';
    94. 

  94.   public $_options=NULL;
    95. 

  95.   public $readonly=false;
    96. 

  96.   public $aliasmodule=NULL;
    97. 

  97.   public $query_format='classic';
    98. 

  98.   public $default='';
    99. 

  99.   public $indexable = false;
    100. 

  100.   public $onlyqueryable=false;
    101. 

  101.   public $advanceeditbatch=false;
    102. 

  102.   public $edit_format=NULL;
    103. 

  103.   public $label=NULL;
    104. 

  104.   public $align = 'left';
    105. 

  105. 

  106.   public static function objectFactory($obj) {
    107. 

  107.     if(!isset($obj->DPARAM)) $obj->DPARAM=NULL;
    108. 

  108.     $ftype = $obj->FTYPE;
    109. 

  109.     $classname = XFieldDef::_getClass($ftype);
    110. 

  110.     if(class_exists($classname)) $c1=new $classname($obj);
    111. 

  111.     else XLogs::critical("XFielddef::objectFactory ",$classname." unknown");
    112. 

  112.     return $c1;
    113. 

  113.   }
    114. 

  114.   public static function objectFactory2($table, $field) {
    115. 

  115.     $rs=selectQuery("select * from DICT,MSGS where DTAB = '".$table."' and MTAB=DTAB ".
    116. 

  116. 		    " and (MLANG='$lang' or MLANG='".TZR_DEFAULT_LANG.
    117. 

  117. 		    "') and DICT.FIELD=MSGS.FIELD and DICT.FIELD='$field' order by FORDER");
    118. 

  118.     if ($o = $rs->fetch(PDO::FETCH_OBJ)) {
    119. 

  119.       $field = XFieldDef::objectFactory($o);
    120. 

  120.     }
    121. 

  121.     return $field;
    122. 

  122.   }
    123. 

  123.   /// creation d'un champ en memoire a partir de son type, son nom et sa taille
    124. 

  124.   public static function objectFactory3($type, $name, $count) {
    125. 

  125.     $t['FTYPE']=$type;
    126. 

  126.     $t['FCOUNT']=$count;
    127. 

  127.     $r['FIELD']=$name;
    128. 

  128.     return XFieldDef::objectFactory($obj);
    129. 

  129.   }
    130. 

  130.   public function trace($old, $r, $msg='') {
    131. 

  131.     if(!empty($msg)) {
    132. 

  132.       $r->trace[$this->field]=$msg;
    133. 

  133.     } elseif(is_object($r) && is_object($old)){
    134. 

  134.       $newv=$r->raw;
    135. 

  135.       if($newv!=$old->raw) $r->trace[$this->field]='['.$old->raw.'] -> ['.$newv.']';
    136. 

  136.     }
    137. 

  137.   }
    138. 

  138.   public function chk($message) {
    139. 

  139.   }
    140. 

  140.   public static function typeExists($t) {
    141. 

  141.     return is_subclass_of($t,'XFieldDef');
    142. 

  142.   }
    143. 

  143.   public static function getGender($t) {
    144. 

  144.     if(!class_exists($t)) return false;
    145. 

  145.     return $GLOBALS['_FTYPE'][$t][1];
    146. 

  146.   }
    147. 

  147.   public static function getUseTarget($t) {
    148. 

  148.     if(!class_exists($t)) return false;
    149. 

  149.     return $GLOBALS['_FTYPE'][$t][3];
    150. 

  150.   }
    151. 

  151.   public static function getFCount($t) {
    152. 

  152.     if(!class_exists($t)) return false;
    153. 

  153.     return $GLOBALS['_FTYPE'][$t][2];
    154. 

  154.   }
    155. 

  155.   public static function _getClass($t) {
    156. 

  156.     if(!class_exists($t)) return false;
    157. 

  157.     return $GLOBALS['_FTYPE'][$t][0];
    158. 

  158.   }
    159. 

  159.   public static function getTypes() {
    160. 

  160.     global $_FTYPE;
    161. 

  161.     $ty=array();
    162. 

  162.     $la=array();
    163. 

  163.     foreach($_FTYPE as $t => $label) {
    164. 

  164.       if(empty($label[4])) {
    165. 

  165. 	$ty[]=$t;
    166. 

  166. 	$la[]=XLabels::getSysLabel('xfielddef',$t);
    167. 

  167.       }
    168. 

  168.     }
    169. 

  169.     array_multisort($la, $ty);
    170. 

  170.     return array($ty, $la);
    171. 

  171.   }
    172. 

  172.   
    173. 

  173.   /**
    174. 

  174.    * Renvoie les types de champs "lien vers un objet"
    175. 

  175.    * @return Array Liste des types de champs "lien vers un objet"
    176. 

  176.    */
    177. 

  177.   public static function getObjectLinkTypes() {
    178. 

  178.     global $_FTYPE;
    179. 

  179.     $link_types = array();
    180. 

  180.     foreach($_FTYPE as $type => $params) {
    181. 

  181.       if (self::isObjectLink($type)) {
    182. 

  182.         $link_types[] = $type;
    183. 

  183.       }
    184. 

  184.     }
    185. 

  185.     return $link_types;
    186. 

  186.   }
    187. 

  187. 

  188.   /**
    189. 

  189.    * Teste si le type du champ correspond à un "lien vers un objet"
    190. 

  190.    * @param string $type Type de champ à renseigner dans un contexte static
    191. 

  191.    * @return boolean Vrai si le type correspond à un "lien vers un objet"
    192. 

  192.    */
    193. 

  193.   function isObjectLink($type = null) {
    194. 

  194.     if (empty($type) && isset($this)) $type = $this->ftype;
    195. 

  195.     return self::getGender($type) == 'Oid' && self::getUseTarget($type);
    196. 

  196.   }
    197. 

  197. 

  198.   function __construct($obj=NULL) {
    199. 

  199.     if(empty($obj)) {
    200. 

  200.       $obj=(object)array('FIELD'=>'anonymous','FTYPE'=>get_class($this),
    201. 

  201. 			 'COMPULSORY'=>0,'TRANSLATABLE'=>0, 'FCOUNT'=>20, 'FORDER'=>0, 'QUERYABLE'=>1, 'MULTIVALUED'=>0,
    202. 

  202. 			 'BROWSABLE'=>1, 'DTAB'=>'%', 'PUBLISHED'=>1, 'TARGET'=>'%', 'DPARAM'=>NULL);
    203. 

  203.     }
    204. 

  204.     bugWarning('XFieldDef::__construct: bad parameter', !empty($obj), true);
    205. 

  205.     $field = @$obj->FIELD;
    206. 

  206.     $ftype = @$obj->FTYPE;
    207. 

  207.     $table = @$obj->DTAB;
    208. 

  208. 

  209.     $this->_options = new XOptions();
    210. 

  210.     $this->ftype = $ftype;
    211. 

  211.     $this->field = $field;
    212. 

  212.     $this->table = $table;
    213. 

  213.     $this->sys = $this->_sysField();
    214. 

  214.     $this->fcount = @$obj->FCOUNT;
    215. 

  215.     $this->forder = @$obj->FORDER;
    216. 

  216.     $this->compulsory = @$obj->COMPULSORY;
    217. 

  217.     $this->queryable = @$obj->QUERYABLE;
    218. 

  218.     $this->browsable = @$obj->BROWSABLE;
    219. 

  219.     $this->translatable = @$obj->TRANSLATABLE;
    220. 

  220.     $this->multivalued = @$obj->MULTIVALUED;
    221. 

  221.     $this->published = @$obj->PUBLISHED;
    222. 

  222.     $this->target = @$obj->TARGET;
    223. 

  223.     $this->initOptions();
    224. 

  224.     $this->setOptions(@$obj->DPARAM);
    225. 

  225.     $this->readonly = $this->readonly||$this->_sysRO();
    226. 

  226.     if(!empty($obj->MTXT)) $this->label = $obj->MTXT;
    227. 

  227.     elseif(!empty($obj->LABEL)) $this->label = $obj->LABEL;
    228. 

  228.     else $this->label=$field;
    229. 

  229.     if(!empty($this->aliasmodule)) {
    230. 

  230.       if(!XAlias::registered($this->aliasmodule)) {
    231. 

  231. 	XAlias::register($this->aliasmodule);
    232. 

  232.       }
    233. 

  233.     }
    234. 

  234.   }
    235. 

  235. 

  236. 

  237.   /// creation d'une valeur prete a etre retournee
    238. 

  238.   function _newXFieldVal(&$option, $genid=false) {
    239. 

  239.     $r= new XFieldVal();
    240. 

  240.     $r->field=$this->field;
    241. 

  241.     $r->table=$this->table;
    242. 

  242.     $r->sys=$this->sys;
    243. 

  243.     $r->readonly=$this->readonly;
    244. 

  244.     $r->fielddef=$this;
    245. 

  245.     $r->filename=NULL;
    246. 

  246.     $r->catalog=NULL;
    247. 

  247.     if($genid) $r->varid=getUniqID('v'.$r->field);
    248. 

  248.     return $r;
    249. 

  249.   }
    250. 

  250.   /// creation d'une valeur prete a etre retournee pour la recherche
    251. 

  251.   function _newXFieldQuery($option=NULL, $genid=false) {
    252. 

  252.     $r=new XFieldQuery();
    253. 

  253.     $r->field=$this->field;
    254. 

  254.     $r->table=$this->table;
    255. 

  255.     $r->sys=$this->sys;
    256. 

  256.     $r->readonly=$this->readonly;
    257. 

  257.     $r->fielddef=$this;
    258. 

  258.     if($genid) $r->varid=getUniqID('q'.$r->field);
    259. 

  259.     return $r;
    260. 

  260.   }
    261. 

  261.   protected function initOptions() {
    262. 

  262.     $helpgroup=XLabels::getSysLabel('general','help','text');
    263. 

  263.     $querygroup=XLabels::getSysLabel('general','query','text');
    264. 

  264.     $this->_options->setId($this->table.':'.$this->field);
    265. 

  265.     $this->_options->setOpt(XLabels::getSysLabel('xfielddef.readonly'), 'readonly', 'boolean');
    266. 

  266.     $this->_options->setOpt(XLabels::getSysLabel('general','comment','text'), 'comment', 'ttext', array('rows'=>2, 'cols'=>60),NULL, $helpgroup);
    267. 

  267.     $this->_options->setOpt(XLabels::getSysLabel('general','comment','text').' Backoffice', 'acomment', 'ttext', array('rows'=>2, 'cols'=>60), NULL,
    268. 

  268. 			    $helpgroup);	
    269. 

  269.     $this->_options->setOpt(XLabels::getSysLabel('general','group'), 'fgroup', 'ttext');
    270. 

  270.     $this->_options->setOpt(XLabels::getSysLabel('xfielddef','default'),'default','text');
    271. 

  271.     $this->_options->setOpt(XLabels::getSysLabel('xdatasource','aliasmodule'),'aliasmodule','module',array('toid'=>4,'emptyok'=>true));
    272. 

  272.     $this->_options->setOpt(XLabels::getSysLabel('xfielddef.meta_source'),'exif_source','text',array('rows'=>3,'cols'=>40));
    273. 

  273.     if(!empty($this->query_formats)){
    274. 

  274.       $class=strtolower(get_class($this));
    275. 

  275.       $labels=array();
    276. 

  276.       foreach($this->query_formats as $qf){
    277. 

  277. 	$tt='qf-'.$class.'-'.$qf;
    278. 

  278. 	$label=XLabels::getSysLabel('xfielddef',$tt);
    279. 

  279. 	if($tt==$label) $label=XLabels::getSysLabel('xfielddef','qf-'.$qf);
    280. 

  280. 	$labels[]=$label;
    281. 

  281.       }
    282. 

  282.       $this->_options->setOpt(XLabels::getSysLabel('xfielddef','query_formats'), 'query_format', 'list',
    283. 

  283. 			      array('values'=>$this->query_formats,'labels'=>$labels),NULL,$querygroup);
    284. 

  284.     }
    285. 

  285.     $this->_options->setOpt('Dependance', 'dependency', 'dependency');
    286. 

  286.     $this->_options->setOpt(XLabels::getSysLabel('xfielddef.indexable'), 'indexable', 'boolean', NULL, false,$querygroup);
    287. 

  287.   }
    288. 

  288.   function get_sqlValue($value) {
    289. 

  289.     // Fabrique une valeur de colonne pour SQL a partir d'une valeur issue de PHP
    290. 

  290.     return $value; // Dans la majorite des cas.
    291. 

  291.   }
    292. 

  292. 

  293.   public function hasExternals() { return false; }
    294. 

  294.   public function externals() { return NULL; }
    295. 

  295.   public function set_target($t) { $this->target=$t;}
    296. 

  296.   public function get_target() { return $this->target;}
    297. 

  297.   public function set_readonly($t) { $this->readonly=$t;}
    298. 

  298.   public function use_fcount() { return $GLOBALS['_FTYPE'][$this->ftype][2];}
    299. 

  299.   public function get_readonly() { return $this->readonly;}
    300. 

  300.   public function get_fcount() { return $this->fcount;}
    301. 

  301.   public function set_fcount($p) { $this->fcount=$p;}
    302. 

  302.   public function get_ftype() { return $this->ftype; }
    303. 

  303.   public function set_ftype($p) { $this->ftype=$p; }
    304. 

  304.   public function set_forder($p) { $this->forder=$p;}
    305. 

  305.   public function get_forder() { return $this->forder;}
    306. 

  306.   public function get_use_target() { return $GLOBALS['_FTYPE'][$this->ftype][3];}
    307. 

  307.   public function get_fgender() { return $GLOBALS['_FTYPE'][$this->ftype][1]; }
    308. 

  308.   public function get_field() { return $this->field; }
    309. 

  309.   public function set_field($p) { $this->field=$p; }
    310. 

  310.   public function get_compulsory() { return $this->compulsory; }
    311. 

  311.   public function set_compulsory($p) { $this->compulsory=$p; }
    312. 

  312.   public function get_queryable() { return $this->queryable; }
    313. 

  313.   public function set_queryable($p) { $this->queryable=$p; }
    314. 

  314.   public function get_browsable() { return $this->browsable; }
    315. 

  315.   public function set_browsable($p) { $this->browsable=$p; }
    316. 

  316.   public function get_translatable() { return $this->translatable; }
    317. 

  317.   public function set_translatable($p) { $this->translatable=$p; }
    318. 

  318.   public function get_multivalued() { return $this->multivalued; }
    319. 

  319.   public function set_multivalued($p) { $this->multivalued=$p; }
    320. 

  320.   public function get_published() { return $this->published; }
    321. 

  321.   public function set_published($p) { $this->published=$p; }
    322. 

  322.   private function _sysField() { return in_array($this->field, array('UPD','PUBLISH','PRIV','OWN','PRP','CREAD')); }
    323. 

  323.   private function _sysRO() { return in_array($this->field, array('UPD','OWN','CREAD')); }
    324. 

  324.   public function sysField() { return $this->sys; }
    325. 

  325.   public function get_options() { return $this->_options->getView();}
    326. 

  326.   public function is_summable() { return false; }
    327. 

  327. 

  328.   function getOptions($block='opt') {
    329. 

  329.     return $this->_options->getDialog($this, array(),$block);
    330. 

  330.   }
    331. 

  331.   function serializeOptions() {
    332. 

  332.     return $this->_options->serialize($this);
    333. 

  333.   }
    334. 

  334.   function setOptions($dparam) {
    335. 

  335.     if(empty($dparam)) $dparam=array();
    336. 

  336.     if(is_array($dparam)) $this->_options->setValues($this, $dparam);
    337. 

  337.     elseif(substr($dparam, 0, 2)=='a:') $this->_options->setValues($this, unserialize($dparam));
    338. 

  338.     elseif(substr($dparam, 0, 5)=='<?xml') $this->_options->fromXML($this,$dparam);
    339. 

  339.     else $this->_options->setValues($this);
    340. 

  340.   }
    341. 

  341. 

  342.   public function cacheable() { return true; }
    343. 

  343.   function get_label() {
    344. 

  344.     return $this->label;
    345. 

  345.   }
    346. 

  346. 

  347.   /// rend les libelles d'un champ dans toutes les langies
    348. 

  348.   function get_labels() {
    349. 

  349.     if(isset($this->labels)) return $this->labels;
    350. 

  350.     $rs=selectQuery("select MSGS.* from MSGS where MTAB='".$this->table."' and FIELD='".$this->field."'");
    351. 

  351.     $r=array();
    352. 

  352.     $ors=array();
    353. 

  353.     while($ors=$rs->fetch()) {
    354. 

  354.       $r[$ors['MLANG']]=$ors['MTXT'];
    355. 

  355.     }
    356. 

  356.     $rs->closeCursor();
    357. 

  357.     $this->labels = $r;
    358. 

  358.     return $r;
    359. 

  359.   }
    360. 

  360. 

  361.   /// rend la valeur d'une option, avec toutes les lkangues s'il s'agit d'un libelle
    362. 

  362.   function get_option($o) {
    363. 

  363.     $txts=XLabels::getAMsg($this->_options->id.':'.$o,NULL,false);
    364. 

  364.     return $txts;
    365. 

  365.   }
    366. 

  366.   function set_label($v) { die('XFieldDef::get_labels'); }
    367. 

  367.   function set_labels($vs) {
    368. 

  368.     unset($this->labels);
    369. 

  369.     while ( list($codeLang,$v) = each($vs) ) {
    370. 

  370.       if ( $v != '' ) $this->labels[$codeLang] = $v;
    371. 

  371.     }
    372. 

  372.     $lg = XShell::getLangUser();
    373. 

  373.     $this->label=$this->labels[$lg];
    374. 

  374.   }
    375. 

  375.   // renvoie un label html - usage formulaire FO
    376. 

  376.   // ajoute la classe "tzr-label-compulsory"
    377. 

  377.   // et le marqueur $compulsory_mark aux champs obligatoires
    378. 

  378.   function get_htmllabel($compulsory_mark = '*') {
    379. 

  379.     if ($this->compulsory)
    380. 

  380.       $label = '<label for="'.$this->field.'" class="tzr-label-compulsory">'.$this->label.' '.$compulsory_mark.'</label>';
    381. 

  381.     else
    382. 

  382.       $label = '<label for="'.$this->field.'">'.$this->label.'</label>';
    383. 

  383.     if ($this->comment)
    384. 

  384.       $label .= '<div class="cv8d-comment" >'.$this->comment.'</div>';
    385. 

  385.     return $label;
    386. 

  386.   }
    387. 

  387.   function get_browse_query($value) {
    388. 

  388.     if($this->multivalued) {
    389. 

  389.       $globdisp='';
    390. 

  390.       $machaine = $value;
    391. 

  391.       $val = explode('||',trim($machaine));
    392. 

  392.       $count = count($val);
    393. 

  393.       $cond = '';
    394. 

  394.       for($i=0;$i<$count; $i++) {
    395. 

  395. 	if($val[$i]!='') {
    396. 

  396. 	  if($cond!='') $cond=$cond.' or ';
    397. 

  397. 	  $cond = $cond." KOID='$val[$i]' ";
    398. 

  398. 	}
    399. 

  399.       }
    400. 

  400.       $xst = XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS='.$this->target);
    401. 

  401.       $query=$xst->select_query(array()).' and ('.$cond.')';
    402. 

  402.       return $query;
    403. 

  403.     }
    404. 

  404.   }
    405. 

  405.   function raw_oids($value,$options=NULL) {
    406. 

  406.     $r=array();
    407. 

  407.     if($this->multivalued) {
    408. 

  408.       $globdisp='';
    409. 

  409.       $machaine = $value;
    410. 

  410.       $val = explode('||',trim($machaine));
    411. 

  411.       $count = count($val);
    412. 

  412.       for($i=0;$i<$count; $i++) {
    413. 

  413. 	if($val[$i]!='') {
    414. 

  414. 	  $r[] = $val[$i];
    415. 

  415. 	}
    416. 

  416.       }
    417. 

  417.     } else {
    418. 

  418.       $pos = strstr($value[0],'||');
    419. 

  419.       if($pos!='') {
    420. 

  420. 	$val = explode('||',trim($value[0]));
    421. 

  421. 	$count = count($val);
    422. 

  422. 	for($i=0;$i<$count; $i++) {
    423. 

  423. 	  if($val[$i]!='') {
    424. 

  424. 	    $r[] = $val[$i];
    425. 

  425. 	  }
    426. 

  426. 	}
    427. 

  427.       } else {
    428. 

  428. 	$r[]=$value;
    429. 

  429.       }
    430. 

  430.     }
    431. 

  431.     return $r;
    432. 

  432.   }
    433. 

  433.   function export($value,$options=NULL) {
    434. 

  434.     $format=$options['format'];
    435. 

  435.     if(!isset($format)) $format='xml';
    436. 

  436.     $func='export_'.$format;
    437. 

  437.     return $this->$func($value,$options);
    438. 

  438.   }
    439. 

  439.   function export_xml($value,$options) {
    440. 

  440.     $labels=$options['labels'];
    441. 

  441.     $txt='';
    442. 

  442.     $lang = $GLOBALS['LANG_DATA'];
    443. 

  443.     foreach($value as $k => $v) {
    444. 

  444.       if(($v!='')) {
    445. 

  445. 	$val = $this->my_export(array($v),$options);
    446. 

  446. 	$l=htmlspecialchars($this->label);
    447. 

  447. 	$l=str_replace(' ','_',$l);
    448. 

  448. 	$txt.="<$l>$val</$l>\n";
    449. 

  449.       }
    450. 

  450.     }
    451. 

  451.     return $txt;
    452. 

  452.   }
    453. 

  453. 

  454.   function &multi_oid_display($value, $options=NULL) {
    455. 

  455.     $r = $this->_newXFieldVal($options);
    456. 

  456.     $r->raw=$value;
    457. 

  457.     $machaine = $value;
    458. 

  458.     $val = explode('||',trim($machaine));
    459. 

  459.     $count = count($val);
    460. 

  460.     if($count>0)     {
    461. 

  461.       $r->collection = array();
    462. 

  462.       $r->oidcollection=array();
    463. 

  463.     }
    464. 

  464.     for($i=0;$i<$count; $i++) {
    465. 

  465.       if(($val[$i]!='') && ($val[$i]!='Foo')) {
    466. 

  466. 	$value = $val[$i];
    467. 

  467. 	$o=$this->my_display($value, $options);
    468. 

  468. 	if(is_object($o) && !empty($o->raw)) {
    469. 

  469. 	  $r->collection[] = $o;
    470. 

  470. 	  $r->oidcollection[] = $val[$i];
    471. 

  471. 	  if(($r->html!='') && (strlen($o->html)>0)) $r->html.='<br/>'.$o->html;
    472. 

  472. 	  else $r->html.=$o->html;
    473. 

  473. 	}
    474. 

  474.       }
    475. 

  475.     }
    476. 

  476.     $r->text=strip_tags(str_replace(array('<br>','<br/>'),', ',$r->html));
    477. 

  477.     $o1=$r;
    478. 

  478.     return $o1;
    479. 

  479.   }
    480. 

  480.   function &multi_data_display(&$value,&$options) {
    481. 

  481.     $r = $this->_newXFieldVal($options);
    482. 

  482.     $separator=$this->separator;
    483. 

  483.     $r->raw=$value;
    484. 

  484.     $val = preg_split('@['.$separator.']@',trim($r->raw));
    485. 

  485.     for($i=0; $i<count($val); $i++) {
    486. 

  486.       if($val[$i]!='') {
    487. 

  487.         $value = trim($val[$i]);
    488. 

  488.         $o=&$this->my_display($value, $options);
    489. 

  489.         if(is_object($o) && isset($o->raw)) {
    490. 

  490.           $r->collection[] = $o;
    491. 

  491.           if(($r->html!='')&&(strlen($o->html)>0)) $r->html .= $this->separator[0].' '.$o->html;
    492. 

  492.           else $r->html .= $o->html;
    493. 

  493.         }
    494. 

  494.       }
    495. 

  495.     }
    496. 

  496.     return $r;
    497. 

  497.   }
    498. 

  498.   function display(&$value,&$options) {
    499. 

  499.     if(!empty($options['value'])) $value=$options['value'];
    500. 

  500.     if($this->multivalued && ($this->get_fgender()=='Oid')) {
    501. 

  501.       $o = & $this->multi_oid_display($value,$options);
    502. 

  502.     } elseif($this->multivalued) {
    503. 

  503.       $o = & $this->multi_data_display($value,$options);
    504. 

  504.     } else {
    505. 

  505.       $o= & $this->my_display($value, $options);
    506. 

  506.     }
    507. 

  507. 

  508.     if(@$options['_format']=='xhtml') {
    509. 

  509.       $o->xhtml = '<'.$this->field.'>'.$o->html.'</'.$this->field.'>';
    510. 

  510.     }
    511. 

  511.     return $o;
    512. 

  512.   }
    513. 

  513.   function browse(&$value,&$options) {
    514. 

  514.     $r = $this->_newXFieldVal($options);
    515. 

  515.     if($this->multivalued && ($this->get_fgender()=='Oid')) {
    516. 

  516.       $r->raw=$value;
    517. 

  517.       $machaine = $value;
    518. 

  518.       $val = explode('||',trim($machaine));
    519. 

  519.       $count = count($val);
    520. 

  520.       if($count>0)     {
    521. 

  521. 	$r->collection = array();
    522. 

  522. 	$r->oidcollection=array();
    523. 

  523.       }
    524. 

  524.       for($i=0;$i<$count; $i++) {
    525. 

  525. 	if($val[$i]!='') {
    526. 

  526. 	  $value1 = $val[$i];
    527. 

  527. 	  $o=$this->my_browse($value1, $options);
    528. 

  528. 	  if(is_object($o) && isset($o->raw)) {
    529. 

  529. 	    $r->collection[] = $o;
    530. 

  530. 	    $r->oidcollection[] = $value1;
    531. 

  531. 	    if(!empty($r->html)&&!empty($o->html)) $r->html .= '<br/>'.$o->html;
    532. 

  532. 	    else $r->html .= $o->html;
    533. 

  533. 	  }
    534. 

  534. 	}
    535. 

  535.       }
    536. 

  536.       $r->text=strip_tags(str_replace('<br/>',', ',$r->html));
    537. 

  537.       $o=$r;
    538. 

  538.     } elseif($this->multivalued) {
    539. 

  539.       $separator=$this->separator;
    540. 

  540.       $r->raw=$value;
    541. 

  541.       $val = preg_split('@['.$separator.']@',trim($r->raw));
    542. 

  542.       $count = count($val);
    543. 

  543.       if($count>0)     {
    544. 

  544. 	for($i=0;$i<$count; $i++) {
    545. 

  545. 	  if($val[$i]!='') {
    546. 

  546. 	    $value1 = trim($val[$i]);
    547. 

  547. 	    $o=&$this->my_browse($value1, $options);
    548. 

  548. 	    if(is_object($o) && isset($o->raw)) {
    549. 

  549. 	      $r->collection[] = $o;
    550. 

  550. 	      if(($r->html!='')&&(strlen($o->html)>0)) $r->html .= $separator[0].' '.$o->html;
    551. 

  551. 	      else $r->html .= $o->html;
    552. 

  552. 	    }
    553. 

  553. 	  }
    554. 

  554. 	}
    555. 

  555.       }
    556. 

  556.       $o=& $r;
    557. 

  557.     } else {
    558. 

  558.       $o= & $this->my_browse($value, $options);
    559. 

  559.     }
    560. 

  560.     return $o;
    561. 

  561.   }
    562. 

  562.   function &edit(&$value,&$options=array(),$fields_complement=null) {
    563. 

  563.     $lang_user = XShell::getLangUser();
    564. 

  564.     if(!empty($options['value'])) $value=$options['value'];
    565. 

  565.     if((!XShell::isRoot() && ($this->readonly || @$options['readonly'])) || @$options['readonly']==2) {
    566. 

  566.       $r=$this->display($value,$options);
    567. 

  567.       return $r;
    568. 

  568.     }
    569. 

  569.     if($this->multivalued && ($this->get_fgender()=='Oid')) {
    570. 

  570.       $val = explode('||',trim($value));
    571. 

  571.       $count = count($val);
    572. 

  572.       $value=array();
    573. 

  573.       for($i=0;$i<$count;$i++) {
    574. 

  574. 	if($val[$i]!='') {
    575. 

  575. 	  $value[$val[$i]]=1;
    576. 

  576. 	}
    577. 

  577.       }
    578. 

  578.     } elseif (strpos($value,'||')!==false && ($this->get_fgender()=='Oid') ) {
    579. 

  579.       $val = explode('||',trim($value));
    580. 

  580.       $count = count($val);
    581. 

  581.       unset($value);
    582. 

  582.       $stop=0;
    583. 

  583.       for($i=0;($i<$count) && ($stop!=1); $i++) {
    584. 

  584. 	if(trim($val[$i])!='') {
    585. 

  585. 	  $value=$val[$i];
    586. 

  586. 	  $stop=1;
    587. 

  587. 	}
    588. 

  588.       }
    589. 

  589.     }
    590. 

  590.     $r=$this->my_edit($value,$options,$fields_complement);
    591. 

  591.     if(empty($r->varid)) $r->varid=getUniqID('v'.$r->field);
    592. 

  592. 

  593.     if($this->multivalued && $this->advanceeditbatch && !empty($options['editbatch'])){
    594. 

  594.       $id=getUniqID('v'.$r->field);
    595. 

  595.       $r->html=	'<input id="'.$id.'-1" class="radio" type="radio" name="'.$this->field.'_op" value="+" checked>'.
    596. 

  596. 	'<label class="tzr-st-label" for="'.$id.'-1">'.XLabels::getSysLabel('xfielddef','editbatch_add').'</label> '.
    597. 

  597. 	'<input id="'.$id.'-2" class="radio" type="radio" name="'.$this->field.'_op" value="=">'.
    598. 

  598. 	'<label class="tzr-st-label" for="'.$id.'-2">'.XLabels::getSysLabel('xfielddef','editbatch_replace').'</label> '.
    599. 

  599. 	'<input id="'.$id.'-3" class="radio" type="radio" name="'.$this->field.'_op" value="-">'.
    600. 

  600. 	'<label class="tzr-st-label" for="'.$id.'-3">'.XLabels::getSysLabel('xfielddef','editbatch_remove').'</label><br>'.
    601. 

  601. 	$r->html;
    602. 

  602.     }
    603. 

  603.     if(!empty($this->dependency['f'])){
    604. 

  604.       $r->html.='<script type="text/javascript">';
    605. 

  605.       foreach($this->dependency['dval'] as $i=>$foo){
    606. 

  606. 	$r->html.='TZR.addDependency("'.$this->ftype.'","'.$this->dependency['f'].'","'.$this->field.'","'.$this->dependency['dval'][$i].
    607. 

  607. 	  '","'.$this->dependency['val'][$i].'","'.$this->dependency['op'][$i].'","'.$this->dependency['style'][$i].'",'.
    608. 

  608. 	  '"'.$this->dependency['nochange'][$i].'");'."\n";
    609. 

  609.       }
    610. 

  610.       $r->html.='</script>';
    611. 

  611.     }
    612. 

  612.     $r->edit=true;
    613. 

  613.     if($this->compulsory) $this->indicator=' *';
    614. 

  614.     else $this->indicator='';
    615. 

  615.     return $r;
    616. 

  616.   }
    617. 

  617. 

  618.   /// Recupere la liste des valeurs presente dans une table pour un filtre donné
    619. 

  619.   public function _getUsedValues($filter=NULL,$select=NULL,$options=array(),$cache=true) {
    620. 

  620.     $this->_getUsedValuesParams($filter,$select,$options,$cachename);
    621. 

  621.     if($cache) $values=&XDbIni::get($cachename,'val');
    622. 

  622.     else $values=NULL;
    623. 

  623.     if(!$values || $values['f']!=$filter || $values['s']!=$select){
    624. 

  624.       $rs=&cacheSelectQuery($select);
    625. 

  625.       $values=array();
    626. 

  626.       $separator=!empty($this->separator)?$this->separator:'||';
    627. 

  627.       while($rs && $ors=$rs->fetch()) {
    628. 

  628. 	if($this->multivalued){
    629. 

  629. 	  $tmpvalues=explode($separator,$ors[$this->field]);
    630. 

  630. 	  foreach($tmpvalues as $i=>$value) {
    631. 

  631. 	    if(!empty($value) && empty($values[$value])) $values[$value]=true;
    632. 

  632. 	  }
    633. 

  633. 	}else{
    634. 

  634. 	  if(!empty($ors[$this->field]) && empty($values[$ors[$this->field]])) $values[$ors[$this->field]]=true;
    635. 

  635. 	}
    636. 

  636.       }
    637. 

  637.       if ($rs) $rs->closeCursor();
    638. 

  638.       $values=array('f'=>$filter,'s'=>$select,'v'=>$values);
    639. 

  639.       if($cache) XDbIni::set($cachename,$values);
    640. 

  640.     }
    641. 

  641.     return $values['v'];
    642. 

  642.   }
    643. 

  643.   /// Met on forme les parametres utilisés pour récupérer les valeurs utilisées
    644. 

  644.   public function _getUsedValuesParams(&$filter,&$select,&$options,&$cachename) {
    645. 

  645.     $lang_data = TZR_DEFAULT_LANG;
    646. 

  646.     if (!empty($this->table)) {
    647. 

  647.       $xst = XDataSource::objectFactoryHelper8('BCLASS=XDSTable&SPECS='.$this->table);
    648. 

  648.       if (is_object($xst) && $xst->isTranslatable()) {
    649. 

  649.         $lang_data = XShell::getLangData();
    650. 

  650.       }
    651. 

  651.     }
    652. 

  652. 

  653.     // on ne prend pas les valeurs vides d'autant plus quelles sont supprimees ensuite
    654. 

  654.     $filter = (empty($filter) ? '' : "($filter) AND ") . '('.$this->field.' != \'\')'; 
    655. 

  655.     if(!empty($this->table) && !$select){
    656. 

  656.       $where=$filter;
    657. 

  657.       if(!empty($options['fmoid'])){
    658. 

  658.         $mod=XModule::objectFactory($options['fmoid']);
    659. 

  659. 	$modfilter=$mod->getUsedValuesFilter();
    660. 

  660. 	if($modfilter) $where.=' AND '.$mod->getUsedValuesFilter();
    661. 

  661.       }
    662. 

  662.       $where.=' AND LANG="'.$lang_data.'"';
    663. 

  663.       $select='SELECT DISTINCT '.$this->field.' FROM '.$this->table.' WHERE '.$where;
    664. 

  664.       if(!empty($options['order'])) $select.=' ORDER BY '.$options['order'];
    665. 

  665.       if(!empty($options['limit'])) $select.=' LIMIT '.$options['limit'];
    666. 

  666.     }
    667. 

  667.     $code=md5($filter.'-'.$select);
    668. 

  668. 

  669.     if($this->target==TZR_DEFAULT_TARGET)
    670. 

  670.       $cachename=$this->table.':usedValues:'.$this->field.':'.$lang.':'.$code;
    671. 

  671.     else
    672. 

  672.       $cachename=$this->table.'|'.$this->target.':usedValues:'.$this->field.':'.$lang.':'.$code;
    673. 

  673.     
    674. 

  674.   }
    675. 

  675. 

  676. 

  677.   function quickquery($value,$ar=NULL) {
    678. 

  678.     if(empty($ar['query_format'])) $ar['query_format']=XFieldDef::QUICKQUERY_FORMAT;
    679. 

  679.     return $this->my_quickquery($value,$ar);
    680. 

  680.   }
    681. 

  681. 

  682.   function my_quickquery($value,$ar=NULL) {
    683. 

  683.     return $this->_newXFieldVal($ar);
    684. 

  684.   }
    685. 

  685. 

  686.   function query($value,$ar=NULL) {
    687. 

  687.     if(is_array($value) && !in_array('Foo',$value) && $this->get_fgender()=='Oid') {
    688. 

  688.       foreach($value as $i => $val1) {
    689. 

  689. 	if(!empty($val1)) {
    690. 

  690. 	  $va[$val1]=1;
    691. 

  691. 	}
    692. 

  692.       }
    693. 

  693.       $value=$va;
    694. 

  694.     } elseif(!is_array($value)) {
    695. 

  695.       if($this->multivalued || @$ar['query_format']) {
    696. 

  696. 	if($value!='Foo') {
    697. 

  697. 	  $val = explode('||',trim($value));
    698. 

  698. 	  unset($value);
    699. 

  699. 	  $value=array();
    700. 

  700. 	  foreach($val as $i => $val1) {
    701. 

  701. 	    if(!empty($val1)) {
    702. 

  702. 	      $value[$val1]=1;
    703. 

  703. 	    }
    704. 

  704. 	  }
    705. 

  705. 	}
    706. 

  706.       } elseif (strstr($value,'||')!='') {
    707. 

  707. 	$val = explode('||',trim($value));
    708. 

  708. 	$count = count($val);
    709. 

  709. 	unset($value);
    710. 

  710. 	$stop=0;
    711. 

  711. 	for($i=0;($i<$count) && ($stop!=1); $i++) {
    712. 

  712. 	  if(trim($val[$i])!='') {
    713. 

  713. 	    $value=$val[$i];
    714. 

  714. 	    $stop=1;
    715. 

  715. 	  }
    716. 

  716. 	}
    717. 

  717.       }
    718. 

  718.     }
    719. 

  719.     if(empty($ar['query_format'])) $ar['query_format']=XFieldDef::QUERY_FORMAT;
    720. 

  720. 

  721.     $r=$this->my_query($value,$ar);
    722. 

  722.     return $r;
    723. 

  723.   }
    724. 

  724. 

  725.   /// Equivalent de query, mais prepare en plus les options sur le format de champs de recherche
    726. 

  726.   function pquery($value,$ar=NULL) {
    727. 

  727.     $qfmt=$ar['qfmt'];
    728. 

  728.     if($ar['notapplyqfmt']) unset($ar['qfmt']);
    729. 

  729.     $r=$this->query($value,$ar);
    730. 

  730.     if(empty($this->query_formats)) return $r;
    731. 

  731.     $fname=(isset($ar['fieldname'])?$ar['fieldname']:$this->field);
    732. 

  732.     $formats='<select name="options['.$fname.'][qfmt]">';
    733. 

  733.     $class=strtolower(get_class($this));
    734. 

  734.     foreach($this->query_formats as $qf){
    735. 

  735.       $label=XLabels::getSysLabel('xfielddef','qf-'.$class.'-'.$qf);
    736. 

  736.       if(empty($label)) $label=XLabels::getSysLabel('xfielddef','qf-'.$qf);
    737. 

  737.       $formats.='<option value="'.$qf.'"'.($qf==$qfmt?'selected':'').'>'.$label.'</option>';
    738. 

  738.     }
    739. 

  739.     $formats.='</select>';
    740. 

  740.     $r->query_formats=$formats;
    741. 

  741.     return $r;
    742. 

  742.   }
    743. 

  743. 

  744.   // action a effectuer apres edition et avant stockage des donnees
    745. 

  745.   // on rend un tableau de valeur traitees
    746. 

  746.   function post_edit($value,$options=NULL,&$fields_complement=NULL) {
    747. 

  747.     $r=$this->_newXFieldVal($options);
    748. 

  748.     $langdata=XShell::getLangData();
    749. 

  749.     $hidden=$options[$this->field.'_HID'];
    750. 

  750.     $r->raw=$value;
    751. 

  751.     $this->trace(@$options['old'],$r);
    752. 

  752.     return $r;
    753. 

  753.   }
    754. 

  754. 

  755.   // action effectuée apres une soumission de recherche
    756. 

  756.   // on rend un tableau de valeur traitees
    757. 

  757.   function post_query(&$o,$ar) {
    758. 

  758.     $v1=$o->value;
    759. 

  759.     $v1op=$o->op;
    760. 

  760.     $k=$this->field;
    761. 

  761.     $k1=$this->table.'.'.$this->field;
    762. 

  762.     $quotes=$o->quote;
    763. 

  763.     $o->rq='';
    764. 

  764. 

  765.     // cas d'une formule
    766. 

  766.     if(!empty($v1) && is_string($v1) && ($v1[0]=='=')) {
    767. 

  767.       $quotes='';
    768. 

  768.       $v1=substr($v1,1);
    769. 

  769.     }
    770. 

  770. 

  771.     // cas d'un oid sans le prefixe table
    772. 

  772.     if (!is_array($v1) && !empty($v1) && !Kernel::isAKoid($v1) && $this->isObjectLink()) {
    773. 

  773.       $v1=$this->target.':'.$v1;
    774. 

  774.     }
    775. 

  775. 

  776.     // cas ou la valeur est un tableau et que le champ est multivalue
    777. 

  777.     if($this->get_multivalued() && is_array($v1) && !empty($v1)) {
    778. 

  778.       if($v1op!='OR') $v1op='AND';
    779. 

  779.       $rq=array();
    780. 

  780.       foreach($v1 as $i=>$v){
    781. 

  781. 	$o1=clone($o);
    782. 

  782. 	$o1->rq='';
    783. 

  783. 	$o1->value=$v;
    784. 

  784. 	$this->post_query($o1,$ar);
    785. 

  785. 	if(!empty($o1->rq)) $rq[]=$o1->rq;
    786. 

  786.       }
    787. 

  787.       if(empty($rq)) $o->rq=NULL;
    788. 

  788.       else $o->rq='('.implode($v1op,$rq).')';
    789. 

  789.     }
    790. 

  790.     // cas ou la valeur multiple est un tableau et le champ n'est pas multivalue
    791. 

  791.     elseif(!$this->get_multivalued() && is_array($v1) && !empty($v1)) {
    792. 

  792.       $count=count($v1);
    793. 

  793.       $rq='(';
    794. 

  794.       for($i=0;$i<$count;$i++) {
    795. 

  795. 	$o1=clone($o);
    796. 

  796. 	$o1->rq='';
    797. 

  797. 	$o1->value=$v1[$i];
    798. 

  798. 	$this->post_query($o1,$ar);
    799. 

  799. 	//dans l cas d'un recherche ne contenant pas les valeur le separateur est un AND
    800. 

  800. 	$sep = 'OR';
    801. 

  801. 	if($o1->op == "!=") $sep = 'AND';
    802. 

  802. 	if(!empty($o1->rq)) {
    803. 

  803. 	  if($rq=='(') $rq.=$o1->rq;
    804. 

  804. 	  else $rq.=' '.$sep.' '.$o1->rq;
    805. 

  805. 	}
    806. 

  806.       }
    807. 

  807.       $rq.=')';
    808. 

  808.       if($rq=='()')
    809. 

  809. 	$o->rq=NULL;
    810. 

  810.       else
    811. 

  811. 	$o->rq=$rq;
    812. 

  812.     }
    813. 

  813.     // traitement de tous les cas possible
    814. 

  814.     elseif(is_string($v1) && $v1op=='$') {
    815. 

  815.       $v1=$GLOBALS['TZR_DB']->quote(".*$v1\$");
    816. 

  816.       $o->rq="($k1 rlike $v1)";
    817. 

  817.     }
    818. 

  818.     elseif(is_string($v1) && $v1op=='^') {
    819. 

  819.       $v1=$GLOBALS['TZR_DB']->quote("^$v1.*");
    820. 

  820.       $o->rq =" ($k1 rlike $v1)";
    821. 

  821.     }
    822. 

  822.     elseif($v1op=='is empty') {
    823. 

  823.       $o->rq = " (($k1 is NULL) or ($k1 ='')) ";
    824. 

  824.     }
    825. 

  825.     elseif(is_array($v1) && !empty($v1) && $this->get_multivalued() && ($this->get_fgender()=='Oid')) {
    826. 

  826.       // traitement du multivalue avec separateur ||
    827. 

  827.       $count = count($v1);
    828. 

  828.       for($j=0;$j<$count; $j++) {
    829. 

  829. 	if(!empty($v1[$j])) {
    830. 

  830. 	  $o->rq=" (($k1 = '".$v1[$j]."') OR INSTR(".$k1.", '||".$v1[$j]."||') or (".
    831. 

  831. 	    $k1."='".$v1[$j]."'))";
    832. 

  832. 	  if(($j!=0) && ($j!=($count-1))) $o->rq.='AND';
    833. 

  833. 	}
    834. 

  834.       }
    835. 

  835.       if(!empty($o->rq)) $o->rq='('.$o->rq.')';
    836. 

  836.     }
    837. 

  837.     elseif(!empty($v1) && ($this->get_fgender()=='Oid') && (strstr($v1,'||')!=false)) {
    838. 

  838.       // traitement du multivalue avec separateur ||
    839. 

  839.       $v1=explode('||',$v1);
    840. 

  840.       $count = count($v1);
    841. 

  841.       for($j=0;$j<$count; $j++) {
    842. 

  842. 	if(!empty($v1[$j])) {
    843. 

  843. 	  $o->rq=" (($k1 = '".$v1[$j]."') OR INSTR(".$k1.",'||".$v1[$j]."||'))";
    844. 

  844. 	  if(($j!=0) && ($j!=($count-1))) $o->rq.='AND';
    845. 

  845. 	}
    846. 

  846.       }
    847. 

  847.       if(!empty($o->rq)) $o->rq='('.$o->rq.')';
    848. 

  848.     }
    849. 

  849.     elseif(is_array($v1) && ($this->get_fgender()=='Oid')) {
    850. 

  850.       // traitement du multivalue avec separateur ||
    851. 

  851.       $count = count($v1);
    852. 

  852.       for($j=0;$j<$count; $j++) {
    853. 

  853. 	if(!empty($v1[$j])) {
    854. 

  854. 	  $o->rq.=' ('.$k1." like '".$v1[$j]."') ";
    855. 

  855. 	  if(($j!=0) && ($j!=($count-1))) $o->rq.='AND';
    856. 

  856. 	}
    857. 

  857.       }
    858. 

  858.       if(!empty($o->rq)) $o->rq='('.$o->rq.')';
    859. 

  859.     }
    860. 

  860.     elseif(!empty($v1) && ($this->get_fgender()=='Oid')) {
    861. 

  861.       if($this->get_multivalued()) {
    862. 

  862. 	$o->rq="( ($k1='$v1') OR instr(".$k1.", '||".$v1."||'))";
    863. 

  863.       } else
    864. 

  864. 	$o->rq=' ('.$k1." = '".$v1."')";
    865. 

  865.     } elseif (!empty($v1) && !empty($v1op) && (is_string($v1) || is_numeric($v1))) {
    866. 

  866.       if(!empty($quotes)) $v1=$GLOBALS['TZR_DB']->quote($v1);
    867. 

  867.       $o->rq=' ('.$k1." $v1op $v1)";
    868. 

  868.     } elseif (!empty($v1) && !is_array($v1)) {
    869. 

  869.       if(empty($quotes)) {
    870. 

  870. 	$o->rq=" (".$k1." like $v1)";
    871. 

  871.       } else {
    872. 

  872. 	$v1=$GLOBALS['TZR_DB']->quote("%$v1%");
    873. 

  873. 	$o->rq=' ('.$k1." like $v1) ";
    874. 

  874.       }
    875. 

  875.     }
    876. 

  876.   }
    877. 

  877. 

  878.   // rend une expression pour requêtage
    879. 

  879.   //
    880. 

  880.   // action a effectuer apres edition et duplication d'une donnee
    881. 

  881.   function post_edit_dup($value,$options) {
    882. 

  882.     $p = new XParam($options,array());
    883. 

  883.     $oidsrc=$p->get('oidsrc');
    884. 

  884.     $options['oid']=$oidsrc;
    885. 

  885.     $r1= $this->post_edit($value,$options);
    886. 

  886.     return $r1->raw;
    887. 

  887.   }
    888. 

  888.   function sqltype() {
    889. 

  889.     return NULL;
    890. 

  890.   }
    891. 

  891.   function sqlfields() {
    892. 

  892.     return $this->field;
    893. 

  893.   }
    894. 

  894.   function sqlsumfunction() { 
    895. 

  895.     return 'SUM('.$this->field.')'; 
    896. 

  896.   }
    897. 

  897.   function delfield() {
    898. 

  898.     return true;
    899. 

  899.   }
    900. 

  900. 

  901.   function delete($value,$oid) {
    902. 

  902.     return 1;
    903. 

  903.   }
    904. 

  904. 

  905.   function my_display(&$value,&$options) {
    906. 

  906.     return $this->_newXFieldVal($options);
    907. 

  907.   }
    908. 

  908. 

  909.   /// Ecriture dans un fichier excel
    910. 

  910.   function writeXLS(&$xl,$i,$j,&$value,$format=0,&$ss) {
    911. 

  911.     if (is_object($value)){
    912. 

  912.       $v=$value->toText();
    913. 

  913.       if(empty($v)) $v=$value->raw;
    914. 

  914.     } else {
    915. 

  915.       $v = '';
    916. 

  916.     }
    917. 

  917.     convert_charset($v,TZR_INTERNAL_CHARSET,'UTF-8');
    918. 

  918.     $xl->setCellValueExplicit(PHPExcel_Cell::stringFromColumnIndex($j) . $i, $v);
    919. 

  919.     if(is_array($format)) $xl->getStyleByColumnAndRow($j,$i)->applyFromArray($format);
    920. 

  920.   }
    921. 

  921. 

  922.   // Ecriture dans un csv
    923. 

  923.   function writeCSV(&$o,$textsep){
    924. 

  924.     if (is_object($o)){
    925. 

  925.       $value=str_replace(array($textsep,"\x0d"),array($textsep.$textsep,""),$o->toText());
    926. 

  926.     } else {
    927. 

  927.       $value = '';
    928. 

  928.     }
    929. 

  929.     $ret=$textsep.$value.$textsep;
    930. 

  930.     return $ret;
    931. 

  931.   }
    932. 

  932. 

  933.   /// Import de données vers une table
    934. 

  934.   function import($value,$options=NULL) {
    935. 

  935.     $value=trim($value);
    936. 

  936.     $defaultvalue=(string)$options->default[0];
    937. 

  937.     // conversion eventuelle de format
    938. 

  938.     if(!empty($options->format) && !empty($value)) {
    939. 

  939.       $value=$this->convert($value,(string)$options->format['source'],(string)$options->format['destination']);
    940. 

  940.     }
    941. 

  941.     if(empty($value) && !empty($defaultvalue)) $value=$defaultvalue;
    942. 

  942.     $ret=$this->my_import($value,$options);
    943. 

  943.     return array('message'=>$ret['message'],'value'=>$ret['value']);
    944. 

  944.   }
    945. 

  945. 

  946.   /// Sous fonction redefinie pour chaque type de champ pour l'import de données vers une table
    947. 

  947.   function my_import($value,&$options){
    948. 

  948.     $typefield=(string)$options['type'];
    949. 

  949.     return array('message'=>'','value'=>$value);
    950. 

  950.   }
    951. 

  951. 

  952.   function my_browse(&$value, &$options) {
    953. 

  953.     return $this->my_display($value, $options);
    954. 

  954.   }
    955. 

  955.   function my_export($value) {
    956. 

  956.     return '';
    957. 

  957.   }
    958. 

  958.   function my_edit($value, $options=NULL){
    959. 

  959.     $r = $this->_newXFieldVal($options,true);
    960. 

  960.     $r->value = $value;
    961. 

  961.     return $r;
    962. 

  962.   }
    963. 

  963.   function my_query($value,$options=NULL){
    964. 

  964.     return $this->_newXFieldVal($options);
    965. 

  965.   }
    966. 

  966.   function filename($value) {
    967. 

  967.     return NULL;
    968. 

  968.   }
    969. 

  969.   function default_value() {
    970. 

  970.     return $this->default;
    971. 

  971.   }
    972. 

  972.   function search($value,$options=NULL) {
    973. 

  973.     $rq='';
    974. 

  974.     if(is_array($value)) {
    975. 

  975.       foreach($value as $i => $v) {
    976. 

  976. 	if($rq!='') $rq .=' OR ';
    977. 

  977. 	$rq .= $this->my_search($v,$options);
    978. 

  978.       }
    979. 

  979.     } else {
    980. 

  980.       $rq .= $this->my_search($value,$options);
    981. 

  981.     }
    982. 

  982.     return $rq;
    983. 

  983.   }
    984. 

  984.   function my_search($value,$options) {
    985. 

  985.     return $this->field.' like "%'.$value.'%" ';
    986. 

  986.   }
    987. 

  987.   function convert($value, $src, $dst) {
    988. 

  988.     return $value;
    989. 

  989.   }
    990. 

  990. 

  991.   // generation d'une url complete et partielle pour la consultation d'un fichier
    992. 

  992.   //
    993. 

  993.   protected function getDownloader($short_filename, $mime='application/x-octet-stream',
    994. 

  994. 				   $originalname=NULL, $title=NULL, $moid=NULL) {
    995. 

  995.     if(empty($title)) $title=$originalname;
    996. 

  996.     $mimelabel=XLabels::getSysLabel('mime',$mime, 'both', 'mime', 'unknown/unknown');
    997. 

  997.     if(empty($mimelabel)) $mimelabel=XLabels::getSysLabel('mime','unknown/unknown');
    998. 

  998.     if(!empty($mimelabel)) $mimelabel.=' ';
    999. 

  999.     $originalname=removeaccents($originalname);
    1000. 

  1000.     $url=TZR_DOWNLOADER.'?filename='.$short_filename.'&amp;mime='.$mime.
    1001. 

  1001.       '&amp;originalname='.rawurlencode(preg_replace('/([^A-Za-z0-9\._-]+)/','_',$originalname)).(empty($moid)?'':'&amp;moid='.$moid).($this->gzipped==1?'&amp;gzip=1':'');
    1002. 

  1002.     $fullurl='<a bt-xpath="'.TZR_AJAX8.'?class=xfiledef&amp;function=xfiledef_getfilesize&amp;file='.$short_filename.'&amp;_='.XShell::uniqid().'" class="tzr-hottip-c tzr-file" href="'.$url.'">'.$mimelabel.$title.'</a>';
    1003. 

  1003.     return array($url, $fullurl);
    1004. 

  1004.   }
    1005. 

  1005. 

  1006.   /// Convertit le contenu de la base de données suite à un changement de format du champ
    1007. 

  1007.   public function convertValues($oldftype){
    1008. 

  1008.     return;
    1009. 

  1009.   }
    1010. 

  1010. 

  1011.   /// Assigne les metas à partir de la valeur du champ
    1012. 

  1012.   function setMetaFromValue($metaanalyser,&$r,$filter=array('IPTC','XMP'),$prop='text'){
    1013. 

  1013.     $isok=array();
    1014. 

  1014.     $metas=explode("\n",$this->exif_source);
    1015. 

  1015.     foreach($metas as &$meta){
    1016. 

  1016.       $list=explode('.',$meta);
    1017. 

  1017.       if(count($list)<2) continue;
    1018. 

  1018.       if(count($list)<3) array_unshift($list,'IPTC');
    1019. 

  1019.       if($list[0]=='XMP' && in_array('XMP',$filter) && !in_array('XMP',$isok)){
    1020. 

  1020. 	if($this->multivalued){
    1021. 

  1021. 	  $v=array();
    1022. 

  1022. 	  foreach($r->collection as $i=>&$c) $v[]=$c->$prop;
    1023. 

  1023. 	  $metaanalyser->setXMPProperty($list[2],$v,@$list[3]);
    1024. 

  1024. 	}else{
    1025. 

  1025. 	  $metaanalyser->setXMPProperty($list[2],$r->$prop,@$list[3]);
    1026. 

  1026. 	}
    1027. 

  1027. 	$isok[]='XMP';
    1028. 

  1028.       }
    1029. 

  1029.       if($list[0]=='IPTC' && in_array('IPTC',$filter) && !in_array('IPTC',$isok)){
    1030. 

  1030. 	$metaanalyser->setIPTCProperty($list[2],$r->$prop);
    1031. 

  1031. 	$isok[]='IPTC';
    1032. 

  1032.       }
    1033. 

  1033.     }
    1034. 

  1034.   }
    1035. 

  1035. 

  1036.   /// Recupere la valeur d'un champ depuis les meta d'un champ fichier
    1037. 

  1037.   function getMetaValue(&$computed_fields,$filter=array('IPTC','EXIF','XMP'),$getall=false){
    1038. 

  1038.     $value='';
    1039. 

  1039.     $metas=explode("\n",$this->exif_source);
    1040. 

  1040.     foreach($metas as &$meta){
    1041. 

  1041.       $list=explode('.',$meta);
    1042. 

  1042.       if(count($list)<2) continue;
    1043. 

  1043.       if(count($list)<3) array_unshift($list,'IPTC');
    1044. 

  1044.       if(!is_object(@$computed_fields[$list[1]])) return;
    1045. 

  1045.       if(in_array('IPTC',$filter) && $list[0]=='IPTC'){
    1046. 

  1046. 	$value=$computed_fields[$list[1]]->getIPTC($list[2]);
    1047. 

  1047. 	if(!empty($value)) break;
    1048. 

  1048.       }elseif(in_array('EXIF',$filter) && $list[0]=='EXIF'){
    1049. 

  1049. 	$value=$computed_fields[$list[1]]->getEXIF($list[2]);
    1050. 

  1050. 	if(!empty($value)) break;
    1051. 

  1051.       }elseif(in_array('XMP',$filter) && $list[0]=='XMP'){
    1052. 

  1052. 	$value=$computed_fields[$list[1]]->getXMP($list[2]);
    1053. 

  1053. 	if(!$getall) $value=(is_object($value)?$value->text:NULL);
    1054. 

  1054. 	if(!empty($value)) break;
    1055. 

  1055.       }
    1056. 

  1056.     }
    1057. 

  1057.     return $value;
    1058. 

  1058.   }
    1059. 

  1059. 

  1060.   /// Recupere le type du champ dans un webservice (name : type xml, descr : description du type pour l'ajour d'une type complexe)
    1061. 

  1061.   function getSoapType(){
    1062. 

  1062.     return array('name'=>'xsd:string');
    1063. 

  1063.   }
    1064. 

  1064.   /// Recupere la valeur formattée pour le service SOAP
    1065. 

  1065.   function getSoapValue($r){
    1066. 

  1066.     return $r->raw;
    1067. 

  1067.   }
    1068. 

  1068. 

  1069.   /// Retourne une chaine de caractere decrivant la recherche en cours sur le champ
    1070. 

  1070.   function getQueryText($o){
    1071. 

  1071.     if(is_array($o->value)){
    1072. 

  1072.       $vals=array();
    1073. 

  1073.       foreach($o->value as $v){
    1074. 

  1074. 	$d=$this->my_display($v);
    1075. 

  1075. 	$vals[]=$d->text;
    1076. 

  1076.       }
    1077. 

  1077.       if($o->op=='OR') $sep=' '.strtolower(XLabels::getSysLabel('general','or','text')).' ';
    1078. 

  1078.       else $sep=' '.strtolower(XLabels::getSysLabel('general','and','text')).' ';
    1079. 

  1079.       $ret.=implode($sep,$vals);
    1080. 

  1080.     }else{
    1081. 

  1081.       $d=$this->my_display($o->value);
    1082. 

  1082.       $ret=$this->getQueryTextOp($o->op,true);
    1083. 

  1083.       $ret.=$d->text;
    1084. 

  1084.     }
    1085. 

  1085.     return $ret;
    1086. 

  1086.   }
    1087. 

  1087.   function getQueryTextOp($op,$addscape=false){
    1088. 

  1088.     $ret='';
    1089. 

  1089.     if(!empty($op)){
    1090. 

  1090.       switch($op){
    1091. 

  1091.       case '>':
    1092. 

  1092. 	$ret=XLabels::getSysLabel('xfielddef','more_than','text').' ';
    1093. 

  1093. 	break;
    1094. 

  1094.       case '>=':
    1095. 

  1095. 	$ret=XLabels::getSysLabel('xfielddef','upper_than','text').' ';
    1096. 

  1096. 	break;
    1097. 

  1097.       case '<=':
    1098. 

  1098. 	$ret=XLabels::getSysLabel('xfielddef','lower_than','text').' ';
    1099. 

  1099. 	break;
    1100. 

  1100.       case '$':
    1101. 

  1101. 	$ret=XLabels::getSysLabel('xfielddef','query_ending_with','text').' ';
    1102. 

  1102. 	break;
    1103. 

  1103.       case '^':
    1104. 

  1104. 	$ret=XLabels::getSysLabel('xfielddef','query_beginning_with','text').' ';
    1105. 

  1105. 	break;
    1106. 

  1106.       case '!=':
    1107. 

  1107. 	$ret=XLabels::getSysLabel('xfielddef','query_different','text').' ';
    1108. 

  1108. 	break;
    1109. 

  1109.       case 'is empty':
    1110. 

  1110. 	$ret=XLabels::getSysLabel('xfielddef','is_empty','text').' ';
    1111. 

  1111. 	break;
    1112. 

  1112.       }
    1113. 

  1113.     }
    1114. 

  1114.     if($addscape && $ret) $ret.=' ';
    1115. 

  1115.     return $ret;
    1116. 

  1116.   }
    1117. 

  1117. 

  1118.   /// Recupere le texte d'une valeur
    1119. 

  1119.   public function &toText($r) {
    1120. 

  1120.     if(!property_exists($r, 'text') || $r->text===NULL) $r->text=getTextFromHTML($r->html);
    1121. 

  1121.     return $r->text;
    1122. 

  1122.   }
    1123. 

  1123.   
    1124. 

  1124.   /**
    1125. 

  1125.    * Function isEmpty
    1126. 

  1126.    * @return true si le champ n'est pas remplit
    1127. 

  1127.    */
    1128. 

  1128.   public function isEmpty($r){
    1129. 

  1129.     if(property_exists($r, 'raw')) return empty($r->raw);
    1130. 

  1130.     else return true;
    1131. 

  1131.   }
    1132. 

  1132. }
    1133. 

  1133. ?>
    1134. 

  1134.