@@ -33,110 +33,110 @@ discard block |
||
33 | 33 | class FormAccounting extends Form |
34 | 34 | { |
35 | 35 | |
36 | - private $options_cache = array(); |
|
36 | + private $options_cache = array(); |
|
37 | 37 | |
38 | - /** |
|
38 | + /** |
|
39 | 39 | * @var DoliDB Database handler. |
40 | 40 | */ |
41 | 41 | public $db; |
42 | 42 | |
43 | - /** |
|
44 | - * @var string Error code (or message) |
|
45 | - */ |
|
46 | - public $error=''; |
|
47 | - |
|
48 | - /** |
|
49 | - * Constructor |
|
50 | - * |
|
51 | - * @param DoliDB $db Database handler |
|
52 | - */ |
|
53 | - public function __construct($db) |
|
54 | - { |
|
55 | - $this->db = $db; |
|
56 | - } |
|
43 | + /** |
|
44 | + * @var string Error code (or message) |
|
45 | + */ |
|
46 | + public $error=''; |
|
47 | + |
|
48 | + /** |
|
49 | + * Constructor |
|
50 | + * |
|
51 | + * @param DoliDB $db Database handler |
|
52 | + */ |
|
53 | + public function __construct($db) |
|
54 | + { |
|
55 | + $this->db = $db; |
|
56 | + } |
|
57 | 57 | |
58 | 58 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
59 | - /** |
|
60 | - * Return list of journals with label by nature |
|
61 | - * |
|
62 | - * @param string $selectid Preselected pcg_type |
|
63 | - * @param string $htmlname Name of field in html form |
|
64 | - * @param int $nature Limit the list to a particular type of journals (1:various operations / 2:sale / 3:purchase / 4:bank / 9: has-new) |
|
65 | - * @param int $showempty Add an empty field |
|
66 | - * @param int $select_in 0=selectid value is the journal rowid (default) or 1=selectid is journal code |
|
67 | - * @param int $select_out Set value returned by select. 0=rowid (default), 1=code |
|
68 | - * @param string $morecss More css non HTML object |
|
69 | - * @param string $usecache Key to use to store result into a cache. Next call with same key will reuse the cache. |
|
70 | - * @param int $disabledajaxcombo Disable ajax combo box. |
|
71 | - * @return string String with HTML select |
|
72 | - */ |
|
73 | - function select_journal($selectid, $htmlname = 'journal', $nature=0, $showempty = 0, $select_in = 0, $select_out = 0, $morecss='maxwidth300 maxwidthonsmartphone', $usecache='', $disabledajaxcombo=0) |
|
74 | - { |
|
59 | + /** |
|
60 | + * Return list of journals with label by nature |
|
61 | + * |
|
62 | + * @param string $selectid Preselected pcg_type |
|
63 | + * @param string $htmlname Name of field in html form |
|
64 | + * @param int $nature Limit the list to a particular type of journals (1:various operations / 2:sale / 3:purchase / 4:bank / 9: has-new) |
|
65 | + * @param int $showempty Add an empty field |
|
66 | + * @param int $select_in 0=selectid value is the journal rowid (default) or 1=selectid is journal code |
|
67 | + * @param int $select_out Set value returned by select. 0=rowid (default), 1=code |
|
68 | + * @param string $morecss More css non HTML object |
|
69 | + * @param string $usecache Key to use to store result into a cache. Next call with same key will reuse the cache. |
|
70 | + * @param int $disabledajaxcombo Disable ajax combo box. |
|
71 | + * @return string String with HTML select |
|
72 | + */ |
|
73 | + function select_journal($selectid, $htmlname = 'journal', $nature=0, $showempty = 0, $select_in = 0, $select_out = 0, $morecss='maxwidth300 maxwidthonsmartphone', $usecache='', $disabledajaxcombo=0) |
|
74 | + { |
|
75 | 75 | // phpcs:enable |
76 | - global $conf,$langs; |
|
77 | - |
|
78 | - $out = ''; |
|
79 | - |
|
80 | - $options = array(); |
|
81 | - if ($usecache && ! empty($this->options_cache[$usecache])) |
|
82 | - { |
|
83 | - $options = $this->options_cache[$usecache]; |
|
84 | - $selected=$selectid; |
|
85 | - } |
|
86 | - else |
|
87 | - { |
|
88 | - $sql = "SELECT rowid, code, label, nature, entity, active"; |
|
89 | - $sql.= " FROM " . MAIN_DB_PREFIX . "accounting_journal"; |
|
90 | - $sql.= " WHERE active = 1"; |
|
91 | - $sql.= " AND entity = ".$conf->entity; |
|
92 | - //if ($nature && is_numeric($nature)) $sql .= " AND nature = ".$nature; |
|
93 | - $sql.= " ORDER BY code"; |
|
94 | - |
|
95 | - dol_syslog(get_class($this) . "::select_journal", LOG_DEBUG); |
|
96 | - $resql = $this->db->query($sql); |
|
97 | - |
|
98 | - if (!$resql) { |
|
99 | - $this->error = "Error ".$this->db->lasterror(); |
|
100 | - dol_syslog(get_class($this)."::select_journal ".$this->error, LOG_ERR); |
|
101 | - return -1; |
|
102 | - } |
|
103 | - |
|
104 | - $selected = 0; |
|
105 | - $langs->load('accountancy'); |
|
106 | - while ($obj = $this->db->fetch_object($resql)) |
|
107 | - { |
|
108 | - $label = $obj->code . ' - ' . $langs->trans($obj->label); |
|
109 | - |
|
110 | - $select_value_in = $obj->rowid; |
|
111 | - $select_value_out = $obj->rowid; |
|
112 | - |
|
113 | - // Try to guess if we have found default value |
|
114 | - if ($select_in == 1) { |
|
115 | - $select_value_in = $obj->code; |
|
116 | - } |
|
117 | - if ($select_out == 1) { |
|
118 | - $select_value_out = $obj->code; |
|
119 | - } |
|
120 | - // Remember guy's we store in database llx_accounting_bookkeeping the code of accounting_journal and not the rowid |
|
121 | - if ($selectid != '' && $selectid == $select_value_in) { |
|
122 | - //var_dump("Found ".$selectid." ".$select_value_in); |
|
123 | - $selected = $select_value_out; |
|
124 | - } |
|
125 | - |
|
126 | - $options[$select_value_out] = $label; |
|
127 | - } |
|
128 | - $this->db->free($resql); |
|
129 | - |
|
130 | - if ($usecache) |
|
131 | - { |
|
132 | - $this->options_cache[$usecache] = $options; |
|
133 | - } |
|
134 | - } |
|
135 | - |
|
136 | - $out .= Form::selectarray($htmlname, $options, $selected, $showempty, 0, 0, '', 0, 0, 0, '', $morecss, ($disabledajaxcombo?0:1)); |
|
137 | - |
|
138 | - return $out; |
|
139 | - } |
|
76 | + global $conf,$langs; |
|
77 | + |
|
78 | + $out = ''; |
|
79 | + |
|
80 | + $options = array(); |
|
81 | + if ($usecache && ! empty($this->options_cache[$usecache])) |
|
82 | + { |
|
83 | + $options = $this->options_cache[$usecache]; |
|
84 | + $selected=$selectid; |
|
85 | + } |
|
86 | + else |
|
87 | + { |
|
88 | + $sql = "SELECT rowid, code, label, nature, entity, active"; |
|
89 | + $sql.= " FROM " . MAIN_DB_PREFIX . "accounting_journal"; |
|
90 | + $sql.= " WHERE active = 1"; |
|
91 | + $sql.= " AND entity = ".$conf->entity; |
|
92 | + //if ($nature && is_numeric($nature)) $sql .= " AND nature = ".$nature; |
|
93 | + $sql.= " ORDER BY code"; |
|
94 | + |
|
95 | + dol_syslog(get_class($this) . "::select_journal", LOG_DEBUG); |
|
96 | + $resql = $this->db->query($sql); |
|
97 | + |
|
98 | + if (!$resql) { |
|
99 | + $this->error = "Error ".$this->db->lasterror(); |
|
100 | + dol_syslog(get_class($this)."::select_journal ".$this->error, LOG_ERR); |
|
101 | + return -1; |
|
102 | + } |
|
103 | + |
|
104 | + $selected = 0; |
|
105 | + $langs->load('accountancy'); |
|
106 | + while ($obj = $this->db->fetch_object($resql)) |
|
107 | + { |
|
108 | + $label = $obj->code . ' - ' . $langs->trans($obj->label); |
|
109 | + |
|
110 | + $select_value_in = $obj->rowid; |
|
111 | + $select_value_out = $obj->rowid; |
|
112 | + |
|
113 | + // Try to guess if we have found default value |
|
114 | + if ($select_in == 1) { |
|
115 | + $select_value_in = $obj->code; |
|
116 | + } |
|
117 | + if ($select_out == 1) { |
|
118 | + $select_value_out = $obj->code; |
|
119 | + } |
|
120 | + // Remember guy's we store in database llx_accounting_bookkeeping the code of accounting_journal and not the rowid |
|
121 | + if ($selectid != '' && $selectid == $select_value_in) { |
|
122 | + //var_dump("Found ".$selectid." ".$select_value_in); |
|
123 | + $selected = $select_value_out; |
|
124 | + } |
|
125 | + |
|
126 | + $options[$select_value_out] = $label; |
|
127 | + } |
|
128 | + $this->db->free($resql); |
|
129 | + |
|
130 | + if ($usecache) |
|
131 | + { |
|
132 | + $this->options_cache[$usecache] = $options; |
|
133 | + } |
|
134 | + } |
|
135 | + |
|
136 | + $out .= Form::selectarray($htmlname, $options, $selected, $showempty, 0, 0, '', 0, 0, 0, '', $morecss, ($disabledajaxcombo?0:1)); |
|
137 | + |
|
138 | + return $out; |
|
139 | + } |
|
140 | 140 | |
141 | 141 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
142 | 142 | /** |
@@ -167,7 +167,7 @@ discard block |
||
167 | 167 | $sql = "SELECT c.rowid, c.label as type, c.range_account"; |
168 | 168 | $sql.= " FROM ".MAIN_DB_PREFIX."c_accounting_category as c"; |
169 | 169 | $sql.= " WHERE c.active = 1"; |
170 | - $sql.= " AND c.category_type = 0"; |
|
170 | + $sql.= " AND c.category_type = 0"; |
|
171 | 171 | if (empty($allcountries)) $sql.= " AND c.fk_country = ".$mysoc->country_id; |
172 | 172 | $sql.= " ORDER BY c.label ASC"; |
173 | 173 | } |
@@ -176,8 +176,8 @@ discard block |
||
176 | 176 | $sql = "SELECT c.rowid, c.label as type, c.range_account"; |
177 | 177 | $sql.= " FROM ".MAIN_DB_PREFIX."c_accounting_category as c, ".MAIN_DB_PREFIX."c_country as co"; |
178 | 178 | $sql.= " WHERE c.active = 1"; |
179 | - $sql.= " AND c.category_type = 0"; |
|
180 | - $sql.= " AND c.fk_country = co.rowid"; |
|
179 | + $sql.= " AND c.category_type = 0"; |
|
180 | + $sql.= " AND c.fk_country = co.rowid"; |
|
181 | 181 | if (empty($allcountries)) $sql.= " AND co.code = '".$mysoc->country_code."'"; |
182 | 182 | $sql.= " ORDER BY c.label ASC"; |
183 | 183 | } |
@@ -199,7 +199,7 @@ discard block |
||
199 | 199 | $out .= '<option value="'.$obj->rowid.'"'; |
200 | 200 | if ($obj->rowid == $selected) $out .= ' selected'; |
201 | 201 | $out .= '>'.($maxlen ? dol_trunc($obj->type,$maxlen) : $obj->type); |
202 | - $out .= ' ('.$obj->range_account.')'; |
|
202 | + $out .= ' ('.$obj->range_account.')'; |
|
203 | 203 | $i++; |
204 | 204 | } |
205 | 205 | $out .= '</select>'; |
@@ -221,231 +221,231 @@ discard block |
||
221 | 221 | } |
222 | 222 | |
223 | 223 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
224 | - /** |
|
225 | - * Return select filter with date of transaction |
|
226 | - * |
|
227 | - * @param string $htmlname Name of select field |
|
228 | - * @param string $selectedkey Value |
|
229 | - * @return string HTML edit field |
|
230 | - */ |
|
224 | + /** |
|
225 | + * Return select filter with date of transaction |
|
226 | + * |
|
227 | + * @param string $htmlname Name of select field |
|
228 | + * @param string $selectedkey Value |
|
229 | + * @return string HTML edit field |
|
230 | + */ |
|
231 | 231 | function select_bookkeeping_importkey($htmlname = 'importkey', $selectedkey = '') |
232 | 232 | { |
233 | 233 | // phpcs:enable |
234 | - $options = array(); |
|
234 | + $options = array(); |
|
235 | 235 | |
236 | - $sql = 'SELECT DISTINCT import_key from ' . MAIN_DB_PREFIX . 'accounting_bookkeeping'; |
|
237 | - $sql .= " WHERE entity IN (".getEntity('accountancy').")"; |
|
238 | - $sql .= ' ORDER BY import_key DESC'; |
|
236 | + $sql = 'SELECT DISTINCT import_key from ' . MAIN_DB_PREFIX . 'accounting_bookkeeping'; |
|
237 | + $sql .= " WHERE entity IN (".getEntity('accountancy').")"; |
|
238 | + $sql .= ' ORDER BY import_key DESC'; |
|
239 | 239 | |
240 | - dol_syslog(get_class($this) . "::select_bookkeeping_importkey", LOG_DEBUG); |
|
241 | - $resql = $this->db->query($sql); |
|
240 | + dol_syslog(get_class($this) . "::select_bookkeeping_importkey", LOG_DEBUG); |
|
241 | + $resql = $this->db->query($sql); |
|
242 | 242 | |
243 | - if (!$resql) { |
|
244 | - $this->error = "Error " . $this->db->lasterror(); |
|
245 | - dol_syslog(get_class($this) . "::select_bookkeeping_importkey " . $this->error, LOG_ERR); |
|
246 | - return - 1; |
|
247 | - } |
|
243 | + if (!$resql) { |
|
244 | + $this->error = "Error " . $this->db->lasterror(); |
|
245 | + dol_syslog(get_class($this) . "::select_bookkeeping_importkey " . $this->error, LOG_ERR); |
|
246 | + return - 1; |
|
247 | + } |
|
248 | 248 | |
249 | - while ($obj = $this->db->fetch_object($resql)) { |
|
250 | - $options[$obj->import_key] = dol_print_date($obj->import_key, 'dayhourtext'); |
|
251 | - } |
|
249 | + while ($obj = $this->db->fetch_object($resql)) { |
|
250 | + $options[$obj->import_key] = dol_print_date($obj->import_key, 'dayhourtext'); |
|
251 | + } |
|
252 | 252 | |
253 | - return Form::selectarray($htmlname, $options, $selectedkey); |
|
254 | - } |
|
253 | + return Form::selectarray($htmlname, $options, $selectedkey); |
|
254 | + } |
|
255 | 255 | |
256 | 256 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
257 | - /** |
|
258 | - * Return list of accounts with label by chart of accounts |
|
259 | - * |
|
260 | - * @param string $selectid Preselected id or code of accounting accounts (depends on $select_in) |
|
261 | - * @param string $htmlname Name of HTML field id. If name start with '.', it is name of HTML css class, so several component with same name in different forms can be used. |
|
262 | - * @param int $showempty 1=Add an empty field, 2=Add an empty field+'None' field |
|
263 | - * @param array $event Event options |
|
264 | - * @param int $select_in 0=selectid value is a aa.rowid (default) or 1=selectid is aa.account_number |
|
265 | - * @param int $select_out Set value returned by select. 0=rowid (default), 1=account_number |
|
266 | - * @param string $morecss More css non HTML object |
|
267 | - * @param string $usecache Key to use to store result into a cache. Next call with same key will reuse the cache. |
|
268 | - * @return string String with HTML select |
|
269 | - */ |
|
270 | - function select_account($selectid, $htmlname = 'account', $showempty = 0, $event = array(), $select_in = 0, $select_out = 0, $morecss='maxwidth300 maxwidthonsmartphone', $usecache='') |
|
271 | - { |
|
257 | + /** |
|
258 | + * Return list of accounts with label by chart of accounts |
|
259 | + * |
|
260 | + * @param string $selectid Preselected id or code of accounting accounts (depends on $select_in) |
|
261 | + * @param string $htmlname Name of HTML field id. If name start with '.', it is name of HTML css class, so several component with same name in different forms can be used. |
|
262 | + * @param int $showempty 1=Add an empty field, 2=Add an empty field+'None' field |
|
263 | + * @param array $event Event options |
|
264 | + * @param int $select_in 0=selectid value is a aa.rowid (default) or 1=selectid is aa.account_number |
|
265 | + * @param int $select_out Set value returned by select. 0=rowid (default), 1=account_number |
|
266 | + * @param string $morecss More css non HTML object |
|
267 | + * @param string $usecache Key to use to store result into a cache. Next call with same key will reuse the cache. |
|
268 | + * @return string String with HTML select |
|
269 | + */ |
|
270 | + function select_account($selectid, $htmlname = 'account', $showempty = 0, $event = array(), $select_in = 0, $select_out = 0, $morecss='maxwidth300 maxwidthonsmartphone', $usecache='') |
|
271 | + { |
|
272 | 272 | // phpcs:enable |
273 | - global $conf, $langs; |
|
274 | - |
|
275 | - require_once DOL_DOCUMENT_ROOT . '/core/lib/accounting.lib.php'; |
|
276 | - |
|
277 | - $out = ''; |
|
278 | - |
|
279 | - $options = array(); |
|
280 | - if ($usecache && ! empty($this->options_cache[$usecache])) |
|
281 | - { |
|
282 | - $options = $this->options_cache[$usecache]; |
|
283 | - $selected=$selectid; |
|
284 | - } |
|
285 | - else |
|
286 | - { |
|
287 | - $trunclength = empty($conf->global->ACCOUNTING_LENGTH_DESCRIPTION_ACCOUNT) ? 50 : $conf->global->ACCOUNTING_LENGTH_DESCRIPTION_ACCOUNT; |
|
288 | - |
|
289 | - $sql = "SELECT DISTINCT aa.account_number, aa.label, aa.rowid, aa.fk_pcg_version"; |
|
290 | - $sql .= " FROM " . MAIN_DB_PREFIX . "accounting_account as aa"; |
|
291 | - $sql .= " INNER JOIN " . MAIN_DB_PREFIX . "accounting_system as asy ON aa.fk_pcg_version = asy.pcg_version"; |
|
292 | - $sql .= " AND asy.rowid = " . $conf->global->CHARTOFACCOUNTS; |
|
293 | - $sql .= " AND aa.active = 1"; |
|
294 | - $sql .= " AND aa.entity=".$conf->entity; |
|
295 | - $sql .= " ORDER BY aa.account_number"; |
|
296 | - |
|
297 | - dol_syslog(get_class($this) . "::select_account", LOG_DEBUG); |
|
298 | - $resql = $this->db->query($sql); |
|
299 | - |
|
300 | - if (!$resql) { |
|
301 | - $this->error = "Error " . $this->db->lasterror(); |
|
302 | - dol_syslog(get_class($this) . "::select_account " . $this->error, LOG_ERR); |
|
303 | - return -1; |
|
304 | - } |
|
305 | - |
|
306 | - $selected = 0; |
|
307 | - while ($obj = $this->db->fetch_object($resql)) |
|
308 | - { |
|
309 | - $label = length_accountg($obj->account_number) . ' - ' . $obj->label; |
|
310 | - $label = dol_trunc($label, $trunclength); |
|
311 | - |
|
312 | - $select_value_in = $obj->rowid; |
|
313 | - $select_value_out = $obj->rowid; |
|
314 | - |
|
315 | - // Try to guess if we have found default value |
|
316 | - if ($select_in == 1) { |
|
317 | - $select_value_in = $obj->account_number; |
|
318 | - } |
|
319 | - if ($select_out == 1) { |
|
320 | - $select_value_out = $obj->account_number; |
|
321 | - } |
|
322 | - // Remember guy's we store in database llx_facturedet the rowid of accounting_account and not the account_number |
|
323 | - // Because same account_number can be share between different accounting_system and do have the same meaning |
|
324 | - if ($selectid != '' && $selectid == $select_value_in) { |
|
325 | - //var_dump("Found ".$selectid." ".$select_value_in); |
|
326 | - $selected = $select_value_out; |
|
327 | - } |
|
328 | - |
|
329 | - $options[$select_value_out] = $label; |
|
330 | - } |
|
331 | - $this->db->free($resql); |
|
332 | - |
|
333 | - if ($usecache) |
|
334 | - { |
|
273 | + global $conf, $langs; |
|
274 | + |
|
275 | + require_once DOL_DOCUMENT_ROOT . '/core/lib/accounting.lib.php'; |
|
276 | + |
|
277 | + $out = ''; |
|
278 | + |
|
279 | + $options = array(); |
|
280 | + if ($usecache && ! empty($this->options_cache[$usecache])) |
|
281 | + { |
|
282 | + $options = $this->options_cache[$usecache]; |
|
283 | + $selected=$selectid; |
|
284 | + } |
|
285 | + else |
|
286 | + { |
|
287 | + $trunclength = empty($conf->global->ACCOUNTING_LENGTH_DESCRIPTION_ACCOUNT) ? 50 : $conf->global->ACCOUNTING_LENGTH_DESCRIPTION_ACCOUNT; |
|
288 | + |
|
289 | + $sql = "SELECT DISTINCT aa.account_number, aa.label, aa.rowid, aa.fk_pcg_version"; |
|
290 | + $sql .= " FROM " . MAIN_DB_PREFIX . "accounting_account as aa"; |
|
291 | + $sql .= " INNER JOIN " . MAIN_DB_PREFIX . "accounting_system as asy ON aa.fk_pcg_version = asy.pcg_version"; |
|
292 | + $sql .= " AND asy.rowid = " . $conf->global->CHARTOFACCOUNTS; |
|
293 | + $sql .= " AND aa.active = 1"; |
|
294 | + $sql .= " AND aa.entity=".$conf->entity; |
|
295 | + $sql .= " ORDER BY aa.account_number"; |
|
296 | + |
|
297 | + dol_syslog(get_class($this) . "::select_account", LOG_DEBUG); |
|
298 | + $resql = $this->db->query($sql); |
|
299 | + |
|
300 | + if (!$resql) { |
|
301 | + $this->error = "Error " . $this->db->lasterror(); |
|
302 | + dol_syslog(get_class($this) . "::select_account " . $this->error, LOG_ERR); |
|
303 | + return -1; |
|
304 | + } |
|
305 | + |
|
306 | + $selected = 0; |
|
307 | + while ($obj = $this->db->fetch_object($resql)) |
|
308 | + { |
|
309 | + $label = length_accountg($obj->account_number) . ' - ' . $obj->label; |
|
310 | + $label = dol_trunc($label, $trunclength); |
|
311 | + |
|
312 | + $select_value_in = $obj->rowid; |
|
313 | + $select_value_out = $obj->rowid; |
|
314 | + |
|
315 | + // Try to guess if we have found default value |
|
316 | + if ($select_in == 1) { |
|
317 | + $select_value_in = $obj->account_number; |
|
318 | + } |
|
319 | + if ($select_out == 1) { |
|
320 | + $select_value_out = $obj->account_number; |
|
321 | + } |
|
322 | + // Remember guy's we store in database llx_facturedet the rowid of accounting_account and not the account_number |
|
323 | + // Because same account_number can be share between different accounting_system and do have the same meaning |
|
324 | + if ($selectid != '' && $selectid == $select_value_in) { |
|
325 | + //var_dump("Found ".$selectid." ".$select_value_in); |
|
326 | + $selected = $select_value_out; |
|
327 | + } |
|
328 | + |
|
329 | + $options[$select_value_out] = $label; |
|
330 | + } |
|
331 | + $this->db->free($resql); |
|
332 | + |
|
333 | + if ($usecache) |
|
334 | + { |
|
335 | 335 | $this->options_cache[$usecache] = $options; |
336 | - } |
|
337 | - } |
|
336 | + } |
|
337 | + } |
|
338 | 338 | |
339 | - if ($showempty == 2) |
|
340 | - { |
|
341 | - $options['0'] = $langs->trans("None"); |
|
342 | - } |
|
339 | + if ($showempty == 2) |
|
340 | + { |
|
341 | + $options['0'] = $langs->trans("None"); |
|
342 | + } |
|
343 | 343 | |
344 | - $out .= Form::selectarray($htmlname, $options, $selected, ($showempty > 0 ? 1 : 0), 0, 0, '', 0, 0, 0, '', $morecss, 1); |
|
344 | + $out .= Form::selectarray($htmlname, $options, $selected, ($showempty > 0 ? 1 : 0), 0, 0, '', 0, 0, 0, '', $morecss, 1); |
|
345 | 345 | |
346 | - return $out; |
|
347 | - } |
|
346 | + return $out; |
|
347 | + } |
|
348 | 348 | |
349 | 349 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
350 | - /** |
|
351 | - * Return list of auxilary thirdparty accounts |
|
352 | - * |
|
353 | - * @param string $selectid Preselected pcg_type |
|
354 | - * @param string $htmlname Name of field in html form |
|
355 | - * @param int $showempty Add an empty field |
|
356 | - * @param string $morecss More css |
|
357 | - * @return string String with HTML select |
|
358 | - */ |
|
350 | + /** |
|
351 | + * Return list of auxilary thirdparty accounts |
|
352 | + * |
|
353 | + * @param string $selectid Preselected pcg_type |
|
354 | + * @param string $htmlname Name of field in html form |
|
355 | + * @param int $showempty Add an empty field |
|
356 | + * @param string $morecss More css |
|
357 | + * @return string String with HTML select |
|
358 | + */ |
|
359 | 359 | function select_auxaccount($selectid, $htmlname='account_num_aux', $showempty=0, $morecss='maxwidth200') |
360 | 360 | { |
361 | 361 | // phpcs:enable |
362 | 362 | |
363 | - $aux_account = array(); |
|
364 | - |
|
365 | - // Auxiliary customer account |
|
366 | - $sql = "SELECT DISTINCT code_compta, nom "; |
|
367 | - $sql .= " FROM ".MAIN_DB_PREFIX."societe"; |
|
368 | - $sql .= " WHERE entity IN (" . getEntity('societe') . ")"; |
|
369 | - $sql .= " ORDER BY code_compta"; |
|
370 | - dol_syslog(get_class($this)."::select_auxaccount", LOG_DEBUG); |
|
371 | - $resql = $this->db->query($sql); |
|
372 | - if ($resql) { |
|
373 | - while ($obj = $this->db->fetch_object($resql)) { |
|
374 | - if (!empty($obj->code_compta)) { |
|
375 | - $aux_account[$obj->code_compta] = $obj->code_compta.' ('.$obj->nom.')'; |
|
376 | - } |
|
377 | - } |
|
378 | - } else { |
|
379 | - $this->error = "Error ".$this->db->lasterror(); |
|
380 | - dol_syslog(get_class($this)."::select_pcgsubtype ".$this->error, LOG_ERR); |
|
381 | - return -1; |
|
382 | - } |
|
383 | - $this->db->free($resql); |
|
384 | - |
|
385 | - // Auxiliary supplier account |
|
386 | - $sql = "SELECT DISTINCT code_compta_fournisseur, nom "; |
|
387 | - $sql .= " FROM ".MAIN_DB_PREFIX."societe"; |
|
388 | - $sql .= " WHERE entity IN (" . getEntity('societe') . ")"; |
|
389 | - $sql .= " ORDER BY code_compta_fournisseur"; |
|
390 | - dol_syslog(get_class($this)."::select_auxaccount", LOG_DEBUG); |
|
391 | - $resql = $this->db->query($sql); |
|
392 | - if ($resql) { |
|
393 | - while ($obj = $this->db->fetch_object($resql)) { |
|
394 | - if (!empty($obj->code_compta_fournisseur)) { |
|
395 | - $aux_account[$obj->code_compta_fournisseur] = $obj->code_compta_fournisseur.' ('.$obj->nom.')'; |
|
396 | - } |
|
397 | - } |
|
398 | - } else { |
|
399 | - $this->error = "Error ".$this->db->lasterror(); |
|
400 | - dol_syslog(get_class($this)."::select_pcgsubtype ".$this->error, LOG_ERR); |
|
401 | - return -1; |
|
402 | - } |
|
403 | - $this->db->free($resql); |
|
404 | - |
|
405 | - // Build select |
|
406 | - $out .= Form::selectarray($htmlname, $aux_account, $selectid, $showempty, 0, 0, '', 0, 0, 0, '', $morecss, 1); |
|
407 | - |
|
408 | - return $out; |
|
409 | - } |
|
363 | + $aux_account = array(); |
|
364 | + |
|
365 | + // Auxiliary customer account |
|
366 | + $sql = "SELECT DISTINCT code_compta, nom "; |
|
367 | + $sql .= " FROM ".MAIN_DB_PREFIX."societe"; |
|
368 | + $sql .= " WHERE entity IN (" . getEntity('societe') . ")"; |
|
369 | + $sql .= " ORDER BY code_compta"; |
|
370 | + dol_syslog(get_class($this)."::select_auxaccount", LOG_DEBUG); |
|
371 | + $resql = $this->db->query($sql); |
|
372 | + if ($resql) { |
|
373 | + while ($obj = $this->db->fetch_object($resql)) { |
|
374 | + if (!empty($obj->code_compta)) { |
|
375 | + $aux_account[$obj->code_compta] = $obj->code_compta.' ('.$obj->nom.')'; |
|
376 | + } |
|
377 | + } |
|
378 | + } else { |
|
379 | + $this->error = "Error ".$this->db->lasterror(); |
|
380 | + dol_syslog(get_class($this)."::select_pcgsubtype ".$this->error, LOG_ERR); |
|
381 | + return -1; |
|
382 | + } |
|
383 | + $this->db->free($resql); |
|
384 | + |
|
385 | + // Auxiliary supplier account |
|
386 | + $sql = "SELECT DISTINCT code_compta_fournisseur, nom "; |
|
387 | + $sql .= " FROM ".MAIN_DB_PREFIX."societe"; |
|
388 | + $sql .= " WHERE entity IN (" . getEntity('societe') . ")"; |
|
389 | + $sql .= " ORDER BY code_compta_fournisseur"; |
|
390 | + dol_syslog(get_class($this)."::select_auxaccount", LOG_DEBUG); |
|
391 | + $resql = $this->db->query($sql); |
|
392 | + if ($resql) { |
|
393 | + while ($obj = $this->db->fetch_object($resql)) { |
|
394 | + if (!empty($obj->code_compta_fournisseur)) { |
|
395 | + $aux_account[$obj->code_compta_fournisseur] = $obj->code_compta_fournisseur.' ('.$obj->nom.')'; |
|
396 | + } |
|
397 | + } |
|
398 | + } else { |
|
399 | + $this->error = "Error ".$this->db->lasterror(); |
|
400 | + dol_syslog(get_class($this)."::select_pcgsubtype ".$this->error, LOG_ERR); |
|
401 | + return -1; |
|
402 | + } |
|
403 | + $this->db->free($resql); |
|
404 | + |
|
405 | + // Build select |
|
406 | + $out .= Form::selectarray($htmlname, $aux_account, $selectid, $showempty, 0, 0, '', 0, 0, 0, '', $morecss, 1); |
|
407 | + |
|
408 | + return $out; |
|
409 | + } |
|
410 | 410 | |
411 | 411 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
412 | - /** |
|
413 | - * Return HTML combo list of years existing into book keepping |
|
414 | - * |
|
415 | - * @param string $selected Preselected value |
|
416 | - * @param string $htmlname Name of HTML select object |
|
417 | - * @param int $useempty Affiche valeur vide dans liste |
|
418 | - * @param string $output_format (html/opton (for option html only)/array (to return options arrays |
|
419 | - * @return string/array |
|
420 | - */ |
|
421 | - function selectyear_accountancy_bookkepping($selected = '', $htmlname = 'yearid', $useempty = 0, $output_format = 'html') |
|
422 | - { |
|
412 | + /** |
|
413 | + * Return HTML combo list of years existing into book keepping |
|
414 | + * |
|
415 | + * @param string $selected Preselected value |
|
416 | + * @param string $htmlname Name of HTML select object |
|
417 | + * @param int $useempty Affiche valeur vide dans liste |
|
418 | + * @param string $output_format (html/opton (for option html only)/array (to return options arrays |
|
419 | + * @return string/array |
|
420 | + */ |
|
421 | + function selectyear_accountancy_bookkepping($selected = '', $htmlname = 'yearid', $useempty = 0, $output_format = 'html') |
|
422 | + { |
|
423 | 423 | // phpcs:enable |
424 | - global $conf; |
|
425 | - |
|
426 | - $out_array = array(); |
|
427 | - |
|
428 | - $sql = "SELECT DISTINCT date_format(doc_date,'%Y') as dtyear"; |
|
429 | - $sql .= " FROM ".MAIN_DB_PREFIX."accounting_bookkeeping"; |
|
430 | - $sql .= " WHERE entity IN (" . getEntity('accountancy') . ")"; |
|
431 | - $sql .= " ORDER BY date_format(doc_date,'%Y')"; |
|
432 | - dol_syslog(get_class($this)."::".__METHOD__, LOG_DEBUG); |
|
433 | - $resql = $this->db->query($sql); |
|
434 | - |
|
435 | - if (!$resql) { |
|
436 | - $this->error = "Error ".$this->db->lasterror(); |
|
437 | - dol_syslog(get_class($this)."::".__METHOD__.$this->error, LOG_ERR); |
|
438 | - return -1; |
|
439 | - } |
|
440 | - while ($obj = $this->db->fetch_object($resql)) { |
|
441 | - $out_array[$obj->dtyear] = $obj->dtyear; |
|
442 | - } |
|
443 | - $this->db->free($resql); |
|
444 | - |
|
445 | - if ($output_format == 'html') { |
|
446 | - return Form::selectarray($htmlname, $out_array, $selected, $useempty, 0, 0, 'placeholder="aa"'); |
|
447 | - } else { |
|
448 | - return $out_array; |
|
449 | - } |
|
450 | - } |
|
424 | + global $conf; |
|
425 | + |
|
426 | + $out_array = array(); |
|
427 | + |
|
428 | + $sql = "SELECT DISTINCT date_format(doc_date,'%Y') as dtyear"; |
|
429 | + $sql .= " FROM ".MAIN_DB_PREFIX."accounting_bookkeeping"; |
|
430 | + $sql .= " WHERE entity IN (" . getEntity('accountancy') . ")"; |
|
431 | + $sql .= " ORDER BY date_format(doc_date,'%Y')"; |
|
432 | + dol_syslog(get_class($this)."::".__METHOD__, LOG_DEBUG); |
|
433 | + $resql = $this->db->query($sql); |
|
434 | + |
|
435 | + if (!$resql) { |
|
436 | + $this->error = "Error ".$this->db->lasterror(); |
|
437 | + dol_syslog(get_class($this)."::".__METHOD__.$this->error, LOG_ERR); |
|
438 | + return -1; |
|
439 | + } |
|
440 | + while ($obj = $this->db->fetch_object($resql)) { |
|
441 | + $out_array[$obj->dtyear] = $obj->dtyear; |
|
442 | + } |
|
443 | + $this->db->free($resql); |
|
444 | + |
|
445 | + if ($output_format == 'html') { |
|
446 | + return Form::selectarray($htmlname, $out_array, $selected, $useempty, 0, 0, 'placeholder="aa"'); |
|
447 | + } else { |
|
448 | + return $out_array; |
|
449 | + } |
|
450 | + } |
|
451 | 451 | } |
@@ -61,226 +61,226 @@ |
||
61 | 61 | */ |
62 | 62 | abstract class CommonStickerGenerator |
63 | 63 | { |
64 | - public $code; // Code of format |
|
64 | + public $code; // Code of format |
|
65 | 65 | |
66 | - /** |
|
66 | + /** |
|
67 | 67 | * @var array format Array with informations |
68 | 68 | */ |
69 | 69 | public $format; |
70 | 70 | |
71 | - // protected |
|
72 | - var $_Avery_Name = ''; // Nom du format de l'etiquette |
|
73 | - var $_Margin_Left = 0; // Marge de gauche de l'etiquette |
|
74 | - var $_Margin_Top = 0; // marge en haut de la page avant la premiere etiquette |
|
75 | - var $_X_Space = 0; // Espace horizontal entre 2 bandes d'etiquettes |
|
76 | - var $_Y_Space = 0; // Espace vertical entre 2 bandes d'etiquettes |
|
77 | - var $_X_Number = 0; // NX Nombre d'etiquettes sur la largeur de la page |
|
78 | - var $_Y_Number = 0; // NY Nombre d'etiquettes sur la hauteur de la page |
|
79 | - var $_Width = 0; // Largeur de chaque etiquette |
|
80 | - var $_Height = 0; // Hauteur de chaque etiquette |
|
81 | - var $_Char_Size = 10; // Hauteur des caracteres |
|
82 | - var $_Line_Height = 10; // Hauteur par defaut d'une ligne |
|
83 | - var $_Metric = 'mm'; // Type of metric.. Will help to calculate good values |
|
84 | - var $_Metric_Doc = 'mm'; // Type of metric for the doc.. |
|
85 | - var $_COUNTX = 1; |
|
86 | - var $_COUNTY = 1; |
|
87 | - var $_First = 1; |
|
88 | - var $Tformat; |
|
71 | + // protected |
|
72 | + var $_Avery_Name = ''; // Nom du format de l'etiquette |
|
73 | + var $_Margin_Left = 0; // Marge de gauche de l'etiquette |
|
74 | + var $_Margin_Top = 0; // marge en haut de la page avant la premiere etiquette |
|
75 | + var $_X_Space = 0; // Espace horizontal entre 2 bandes d'etiquettes |
|
76 | + var $_Y_Space = 0; // Espace vertical entre 2 bandes d'etiquettes |
|
77 | + var $_X_Number = 0; // NX Nombre d'etiquettes sur la largeur de la page |
|
78 | + var $_Y_Number = 0; // NY Nombre d'etiquettes sur la hauteur de la page |
|
79 | + var $_Width = 0; // Largeur de chaque etiquette |
|
80 | + var $_Height = 0; // Hauteur de chaque etiquette |
|
81 | + var $_Char_Size = 10; // Hauteur des caracteres |
|
82 | + var $_Line_Height = 10; // Hauteur par defaut d'une ligne |
|
83 | + var $_Metric = 'mm'; // Type of metric.. Will help to calculate good values |
|
84 | + var $_Metric_Doc = 'mm'; // Type of metric for the doc.. |
|
85 | + var $_COUNTX = 1; |
|
86 | + var $_COUNTY = 1; |
|
87 | + var $_First = 1; |
|
88 | + var $Tformat; |
|
89 | 89 | |
90 | - /** |
|
91 | - * Constructor |
|
92 | - * |
|
93 | - * @param DoliDB $db Database handler |
|
94 | - */ |
|
95 | - function __construct($db) |
|
96 | - { |
|
97 | - $this->db = $db; |
|
98 | - } |
|
90 | + /** |
|
91 | + * Constructor |
|
92 | + * |
|
93 | + * @param DoliDB $db Database handler |
|
94 | + */ |
|
95 | + function __construct($db) |
|
96 | + { |
|
97 | + $this->db = $db; |
|
98 | + } |
|
99 | 99 | |
100 | 100 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
101 | - /** |
|
102 | - * Function to build PDF on disk, then output on HTTP strem. |
|
103 | - * |
|
104 | - * @param array $arrayofrecords Array of record informations (array('textleft'=>,'textheader'=>, ..., 'id'=>,'photo'=>) |
|
105 | - * @param Translate $outputlangs Lang object for output language |
|
106 | - * @param string $srctemplatepath Full path of source filename for generator using a template file |
|
107 | - * @param string $outputdir Output directory for pdf file |
|
108 | - * @return int 1=OK, 0=KO |
|
109 | - */ |
|
110 | - abstract function write_file($arrayofrecords,$outputlangs,$srctemplatepath,$outputdir=''); |
|
101 | + /** |
|
102 | + * Function to build PDF on disk, then output on HTTP strem. |
|
103 | + * |
|
104 | + * @param array $arrayofrecords Array of record informations (array('textleft'=>,'textheader'=>, ..., 'id'=>,'photo'=>) |
|
105 | + * @param Translate $outputlangs Lang object for output language |
|
106 | + * @param string $srctemplatepath Full path of source filename for generator using a template file |
|
107 | + * @param string $outputdir Output directory for pdf file |
|
108 | + * @return int 1=OK, 0=KO |
|
109 | + */ |
|
110 | + abstract function write_file($arrayofrecords,$outputlangs,$srctemplatepath,$outputdir=''); |
|
111 | 111 | // phpcs:enable |
112 | 112 | |
113 | - /** |
|
114 | - * Output a sticker on page at position _COUNTX, _COUNTY (_COUNTX and _COUNTY start from 0) |
|
115 | - * |
|
116 | - * @param PDF $pdf PDF reference |
|
117 | - * @param Translate $outputlangs Output langs |
|
118 | - * @param array $param Associative array containing label content and optional parameters |
|
119 | - * @return void |
|
120 | - */ |
|
121 | - abstract function addSticker(&$pdf,$outputlangs,$param); |
|
113 | + /** |
|
114 | + * Output a sticker on page at position _COUNTX, _COUNTY (_COUNTX and _COUNTY start from 0) |
|
115 | + * |
|
116 | + * @param PDF $pdf PDF reference |
|
117 | + * @param Translate $outputlangs Output langs |
|
118 | + * @param array $param Associative array containing label content and optional parameters |
|
119 | + * @return void |
|
120 | + */ |
|
121 | + abstract function addSticker(&$pdf,$outputlangs,$param); |
|
122 | 122 | |
123 | 123 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
124 | - /** |
|
125 | - * Methode qui permet de modifier la taille des caracteres |
|
126 | - * Cela modiera aussi l'espace entre chaque ligne |
|
127 | - * |
|
128 | - * @param PDF $pdf PDF reference |
|
129 | - * @param int $pt point |
|
130 | - * @return void |
|
131 | - */ |
|
132 | - function Set_Char_Size(&$pdf,$pt) |
|
133 | - { |
|
124 | + /** |
|
125 | + * Methode qui permet de modifier la taille des caracteres |
|
126 | + * Cela modiera aussi l'espace entre chaque ligne |
|
127 | + * |
|
128 | + * @param PDF $pdf PDF reference |
|
129 | + * @param int $pt point |
|
130 | + * @return void |
|
131 | + */ |
|
132 | + function Set_Char_Size(&$pdf,$pt) |
|
133 | + { |
|
134 | 134 | // phpcs:enable |
135 | - if ($pt > 3) { |
|
136 | - $this->_Char_Size = $pt; |
|
137 | - $this->_Line_Height = $this->_Get_Height_Chars($pt); |
|
138 | - $pdf->SetFont('','',$pt); |
|
139 | - } |
|
140 | - } |
|
135 | + if ($pt > 3) { |
|
136 | + $this->_Char_Size = $pt; |
|
137 | + $this->_Line_Height = $this->_Get_Height_Chars($pt); |
|
138 | + $pdf->SetFont('','',$pt); |
|
139 | + } |
|
140 | + } |
|
141 | 141 | |
142 | 142 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
143 | - /** |
|
144 | - * protected Print dot line |
|
145 | - * |
|
146 | - * @param PDF $pdf PDF reference |
|
147 | - * @param int $x1 X1 |
|
148 | - * @param int $y1 Y1 |
|
149 | - * @param int $x2 X2 |
|
150 | - * @param int $y2 Y2 |
|
151 | - * @param int $epaisseur Epaisseur |
|
152 | - * @param int $nbPointilles Nb pointilles |
|
153 | - * @return void |
|
154 | - */ |
|
143 | + /** |
|
144 | + * protected Print dot line |
|
145 | + * |
|
146 | + * @param PDF $pdf PDF reference |
|
147 | + * @param int $x1 X1 |
|
148 | + * @param int $y1 Y1 |
|
149 | + * @param int $x2 X2 |
|
150 | + * @param int $y2 Y2 |
|
151 | + * @param int $epaisseur Epaisseur |
|
152 | + * @param int $nbPointilles Nb pointilles |
|
153 | + * @return void |
|
154 | + */ |
|
155 | 155 | function _Pointille(&$pdf,$x1=0,$y1=0,$x2=210,$y2=297,$epaisseur=1,$nbPointilles=15) |
156 | - { |
|
156 | + { |
|
157 | 157 | // phpcs:enable |
158 | - $pdf->SetLineWidth($epaisseur); |
|
159 | - $length=abs($x1-$x2); |
|
160 | - $hauteur=abs($y1-$y2); |
|
161 | - if($length>$hauteur) { |
|
162 | - $Pointilles=($length/$nbPointilles)/2; // taille des pointilles |
|
163 | - } |
|
164 | - else { |
|
165 | - $Pointilles=($hauteur/$nbPointilles)/2; |
|
166 | - } |
|
167 | - for($i=$x1;$i<=$x2;$i+=$Pointilles+$Pointilles) { |
|
168 | - for($j=$i;$j<=($i+$Pointilles);$j++) { |
|
169 | - if($j<=($x2-1)) { |
|
170 | - $pdf->Line($j,$y1,$j+1,$y1); // on trace le pointill? du haut, point par point |
|
171 | - $pdf->Line($j,$y2,$j+1,$y2); // on trace le pointill? du bas, point par point |
|
172 | - } |
|
173 | - } |
|
174 | - } |
|
175 | - for($i=$y1;$i<=$y2;$i+=$Pointilles+$Pointilles) { |
|
176 | - for($j=$i;$j<=($i+$Pointilles);$j++) { |
|
177 | - if($j<=($y2-1)) { |
|
178 | - $pdf->Line($x1,$j,$x1,$j+1); // on trace le pointill? du haut, point par point |
|
179 | - $pdf->Line($x2,$j,$x2,$j+1); // on trace le pointill? du bas, point par point |
|
180 | - } |
|
181 | - } |
|
182 | - } |
|
183 | - } |
|
158 | + $pdf->SetLineWidth($epaisseur); |
|
159 | + $length=abs($x1-$x2); |
|
160 | + $hauteur=abs($y1-$y2); |
|
161 | + if($length>$hauteur) { |
|
162 | + $Pointilles=($length/$nbPointilles)/2; // taille des pointilles |
|
163 | + } |
|
164 | + else { |
|
165 | + $Pointilles=($hauteur/$nbPointilles)/2; |
|
166 | + } |
|
167 | + for($i=$x1;$i<=$x2;$i+=$Pointilles+$Pointilles) { |
|
168 | + for($j=$i;$j<=($i+$Pointilles);$j++) { |
|
169 | + if($j<=($x2-1)) { |
|
170 | + $pdf->Line($j,$y1,$j+1,$y1); // on trace le pointill? du haut, point par point |
|
171 | + $pdf->Line($j,$y2,$j+1,$y2); // on trace le pointill? du bas, point par point |
|
172 | + } |
|
173 | + } |
|
174 | + } |
|
175 | + for($i=$y1;$i<=$y2;$i+=$Pointilles+$Pointilles) { |
|
176 | + for($j=$i;$j<=($i+$Pointilles);$j++) { |
|
177 | + if($j<=($y2-1)) { |
|
178 | + $pdf->Line($x1,$j,$x1,$j+1); // on trace le pointill? du haut, point par point |
|
179 | + $pdf->Line($x2,$j,$x2,$j+1); // on trace le pointill? du bas, point par point |
|
180 | + } |
|
181 | + } |
|
182 | + } |
|
183 | + } |
|
184 | 184 | |
185 | 185 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
186 | - /** |
|
187 | - * protected Function realisant une croix aux 4 coins des cartes |
|
188 | - * |
|
189 | - * @param PDF $pdf PDF reference |
|
190 | - * @param int $x1 X1 |
|
191 | - * @param int $y1 Y1 |
|
192 | - * @param int $x2 X2 |
|
193 | - * @param int $y2 Y2 |
|
194 | - * @param int $epaisseur Epaisseur |
|
195 | - * @param int $taille Size |
|
196 | - * @return void |
|
197 | - */ |
|
198 | - function _Croix(&$pdf,$x1=0,$y1=0,$x2=210,$y2=297,$epaisseur=1,$taille=4) |
|
199 | - { |
|
186 | + /** |
|
187 | + * protected Function realisant une croix aux 4 coins des cartes |
|
188 | + * |
|
189 | + * @param PDF $pdf PDF reference |
|
190 | + * @param int $x1 X1 |
|
191 | + * @param int $y1 Y1 |
|
192 | + * @param int $x2 X2 |
|
193 | + * @param int $y2 Y2 |
|
194 | + * @param int $epaisseur Epaisseur |
|
195 | + * @param int $taille Size |
|
196 | + * @return void |
|
197 | + */ |
|
198 | + function _Croix(&$pdf,$x1=0,$y1=0,$x2=210,$y2=297,$epaisseur=1,$taille=4) |
|
199 | + { |
|
200 | 200 | // phpcs:enable |
201 | - $pdf->SetDrawColor(192,192,192); |
|
201 | + $pdf->SetDrawColor(192,192,192); |
|
202 | 202 | |
203 | - $pdf->SetLineWidth($epaisseur); |
|
204 | - $lg=$taille/2; |
|
205 | - // croix haut gauche |
|
206 | - $pdf->Line($x1,$y1-$lg,$x1,$y1+$lg); |
|
207 | - $pdf->Line($x1-$lg,$y1,$x1+$lg,$y1); |
|
208 | - // croix bas gauche |
|
209 | - $pdf->Line($x1,$y2-$lg,$x1,$y2+$lg); |
|
210 | - $pdf->Line($x1-$lg,$y2,$x1+$lg,$y2); |
|
211 | - // croix haut droit |
|
212 | - $pdf->Line($x2,$y1-$lg,$x2,$y1+$lg); |
|
213 | - $pdf->Line($x2-$lg,$y1,$x2+$lg,$y1); |
|
214 | - // croix bas droit |
|
215 | - $pdf->Line($x2,$y2-$lg,$x2,$y2+$lg); |
|
216 | - $pdf->Line($x2-$lg,$y2,$x2+$lg,$y2); |
|
203 | + $pdf->SetLineWidth($epaisseur); |
|
204 | + $lg=$taille/2; |
|
205 | + // croix haut gauche |
|
206 | + $pdf->Line($x1,$y1-$lg,$x1,$y1+$lg); |
|
207 | + $pdf->Line($x1-$lg,$y1,$x1+$lg,$y1); |
|
208 | + // croix bas gauche |
|
209 | + $pdf->Line($x1,$y2-$lg,$x1,$y2+$lg); |
|
210 | + $pdf->Line($x1-$lg,$y2,$x1+$lg,$y2); |
|
211 | + // croix haut droit |
|
212 | + $pdf->Line($x2,$y1-$lg,$x2,$y1+$lg); |
|
213 | + $pdf->Line($x2-$lg,$y1,$x2+$lg,$y1); |
|
214 | + // croix bas droit |
|
215 | + $pdf->Line($x2,$y2-$lg,$x2,$y2+$lg); |
|
216 | + $pdf->Line($x2-$lg,$y2,$x2+$lg,$y2); |
|
217 | 217 | |
218 | - $pdf->SetDrawColor(0,0,0); |
|
219 | - } |
|
218 | + $pdf->SetDrawColor(0,0,0); |
|
219 | + } |
|
220 | 220 | |
221 | - /** |
|
222 | - * Convert units (in to mm, mm to in) |
|
223 | - * $src and $dest must be 'in' or 'mm' |
|
224 | - * |
|
225 | - * @param int $value value |
|
226 | - * @param string $src from ('in' or 'mm') |
|
227 | - * @param string $dest to ('in' or 'mm') |
|
228 | - * @return float value value after conversion |
|
229 | - */ |
|
230 | - private function convertMetric($value, $src, $dest) |
|
231 | - { |
|
232 | - if ($src != $dest) { |
|
233 | - $tab = array( |
|
234 | - 'in'=>39.37008, |
|
235 | - 'mm'=>1000 |
|
236 | - ); |
|
237 | - return $value * $tab[$dest] / $tab[$src]; |
|
238 | - } |
|
221 | + /** |
|
222 | + * Convert units (in to mm, mm to in) |
|
223 | + * $src and $dest must be 'in' or 'mm' |
|
224 | + * |
|
225 | + * @param int $value value |
|
226 | + * @param string $src from ('in' or 'mm') |
|
227 | + * @param string $dest to ('in' or 'mm') |
|
228 | + * @return float value value after conversion |
|
229 | + */ |
|
230 | + private function convertMetric($value, $src, $dest) |
|
231 | + { |
|
232 | + if ($src != $dest) { |
|
233 | + $tab = array( |
|
234 | + 'in'=>39.37008, |
|
235 | + 'mm'=>1000 |
|
236 | + ); |
|
237 | + return $value * $tab[$dest] / $tab[$src]; |
|
238 | + } |
|
239 | 239 | |
240 | - return $value; |
|
241 | - } |
|
240 | + return $value; |
|
241 | + } |
|
242 | 242 | |
243 | 243 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
244 | - /** |
|
245 | - * protected Give the height for a char size given. |
|
246 | - * |
|
247 | - * @param int $pt Point |
|
248 | - * @return int Height chars |
|
249 | - */ |
|
250 | - function _Get_Height_Chars($pt) |
|
251 | - { |
|
244 | + /** |
|
245 | + * protected Give the height for a char size given. |
|
246 | + * |
|
247 | + * @param int $pt Point |
|
248 | + * @return int Height chars |
|
249 | + */ |
|
250 | + function _Get_Height_Chars($pt) |
|
251 | + { |
|
252 | 252 | // phpcs:enable |
253 | - // Tableau de concordance entre la hauteur des caracteres et de l'espacement entre les lignes |
|
254 | - $_Table_Hauteur_Chars = array(6=>2, 7=>2.5, 8=>3, 9=>3.5, 10=>4, 11=>6, 12=>7, 13=>8, 14=>9, 15=>10); |
|
255 | - if (in_array($pt, array_keys($_Table_Hauteur_Chars))) { |
|
256 | - return $_Table_Hauteur_Chars[$pt]; |
|
257 | - } else { |
|
258 | - return 100; // There is a prob.. |
|
259 | - } |
|
260 | - } |
|
253 | + // Tableau de concordance entre la hauteur des caracteres et de l'espacement entre les lignes |
|
254 | + $_Table_Hauteur_Chars = array(6=>2, 7=>2.5, 8=>3, 9=>3.5, 10=>4, 11=>6, 12=>7, 13=>8, 14=>9, 15=>10); |
|
255 | + if (in_array($pt, array_keys($_Table_Hauteur_Chars))) { |
|
256 | + return $_Table_Hauteur_Chars[$pt]; |
|
257 | + } else { |
|
258 | + return 100; // There is a prob.. |
|
259 | + } |
|
260 | + } |
|
261 | 261 | |
262 | 262 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
263 | - /** |
|
264 | - * protected Set format |
|
265 | - * |
|
266 | - * @param PDF $pdf PDF reference |
|
267 | - * @param string $format Format |
|
268 | - * @return void |
|
269 | - */ |
|
270 | - function _Set_Format(&$pdf, $format) |
|
271 | - { |
|
263 | + /** |
|
264 | + * protected Set format |
|
265 | + * |
|
266 | + * @param PDF $pdf PDF reference |
|
267 | + * @param string $format Format |
|
268 | + * @return void |
|
269 | + */ |
|
270 | + function _Set_Format(&$pdf, $format) |
|
271 | + { |
|
272 | 272 | // phpcs:enable |
273 | - $this->_Metric = $format['metric']; |
|
274 | - $this->_Avery_Name = $format['name']; |
|
275 | - $this->_Avery_Code = $format['code']; |
|
276 | - $this->_Margin_Left = $this->convertMetric($format['marginLeft'], $this->_Metric, $this->_Metric_Doc); |
|
277 | - $this->_Margin_Top = $this->convertMetric($format['marginTop'], $this->_Metric, $this->_Metric_Doc); |
|
278 | - $this->_X_Space = $this->convertMetric($format['SpaceX'], $this->_Metric, $this->_Metric_Doc); |
|
279 | - $this->_Y_Space = $this->convertMetric($format['SpaceY'], $this->_Metric, $this->_Metric_Doc); |
|
280 | - $this->_X_Number = $format['NX']; |
|
281 | - $this->_Y_Number = $format['NY']; |
|
282 | - $this->_Width = $this->convertMetric($format['width'], $this->_Metric, $this->_Metric_Doc); |
|
283 | - $this->_Height = $this->convertMetric($format['height'], $this->_Metric, $this->_Metric_Doc); |
|
284 | - $this->Set_Char_Size($pdf, $format['font-size']); |
|
285 | - } |
|
273 | + $this->_Metric = $format['metric']; |
|
274 | + $this->_Avery_Name = $format['name']; |
|
275 | + $this->_Avery_Code = $format['code']; |
|
276 | + $this->_Margin_Left = $this->convertMetric($format['marginLeft'], $this->_Metric, $this->_Metric_Doc); |
|
277 | + $this->_Margin_Top = $this->convertMetric($format['marginTop'], $this->_Metric, $this->_Metric_Doc); |
|
278 | + $this->_X_Space = $this->convertMetric($format['SpaceX'], $this->_Metric, $this->_Metric_Doc); |
|
279 | + $this->_Y_Space = $this->convertMetric($format['SpaceY'], $this->_Metric, $this->_Metric_Doc); |
|
280 | + $this->_X_Number = $format['NX']; |
|
281 | + $this->_Y_Number = $format['NY']; |
|
282 | + $this->_Width = $this->convertMetric($format['width'], $this->_Metric, $this->_Metric_Doc); |
|
283 | + $this->_Height = $this->convertMetric($format['height'], $this->_Metric, $this->_Metric_Doc); |
|
284 | + $this->Set_Char_Size($pdf, $format['font-size']); |
|
285 | + } |
|
286 | 286 | } |
@@ -27,26 +27,26 @@ discard block |
||
27 | 27 | */ |
28 | 28 | class FormSocialContrib |
29 | 29 | { |
30 | - /** |
|
30 | + /** |
|
31 | 31 | * @var DoliDB Database handler. |
32 | 32 | */ |
33 | 33 | public $db; |
34 | 34 | |
35 | - /** |
|
36 | - * @var string Error code (or message) |
|
37 | - */ |
|
38 | - public $error=''; |
|
35 | + /** |
|
36 | + * @var string Error code (or message) |
|
37 | + */ |
|
38 | + public $error=''; |
|
39 | 39 | |
40 | 40 | |
41 | - /** |
|
42 | - * Constructor |
|
43 | - * |
|
44 | - * @param DoliDB $db Database handler |
|
45 | - */ |
|
46 | - public function __construct($db) |
|
47 | - { |
|
48 | - $this->db = $db; |
|
49 | - } |
|
41 | + /** |
|
42 | + * Constructor |
|
43 | + * |
|
44 | + * @param DoliDB $db Database handler |
|
45 | + */ |
|
46 | + public function __construct($db) |
|
47 | + { |
|
48 | + $this->db = $db; |
|
49 | + } |
|
50 | 50 | |
51 | 51 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
52 | 52 | /** |
@@ -96,7 +96,7 @@ discard block |
||
96 | 96 | $num = $db->num_rows($resql); |
97 | 97 | if ($num) |
98 | 98 | { |
99 | - print '<select class="'.($morecss?$morecss:'').'" id="'.$htmlname.'" name="'.$htmlname.'">'; |
|
99 | + print '<select class="'.($morecss?$morecss:'').'" id="'.$htmlname.'" name="'.$htmlname.'">'; |
|
100 | 100 | $i = 0; |
101 | 101 | |
102 | 102 | if ($useempty) print '<option value="0"> </option>'; |
@@ -32,38 +32,38 @@ discard block |
||
32 | 32 | */ |
33 | 33 | class Ccountry // extends CommonObject |
34 | 34 | { |
35 | - /** |
|
35 | + /** |
|
36 | 36 | * @var DoliDB Database handler. |
37 | 37 | */ |
38 | 38 | public $db; |
39 | 39 | |
40 | - /** |
|
41 | - * @var string Error code (or message) |
|
42 | - */ |
|
43 | - public $error=''; |
|
40 | + /** |
|
41 | + * @var string Error code (or message) |
|
42 | + */ |
|
43 | + public $error=''; |
|
44 | 44 | |
45 | - /** |
|
46 | - * @var string[] Error codes (or messages) |
|
47 | - */ |
|
48 | - public $errors = array(); |
|
45 | + /** |
|
46 | + * @var string[] Error codes (or messages) |
|
47 | + */ |
|
48 | + public $errors = array(); |
|
49 | 49 | |
50 | - //var $element='ccountry'; //!< Id that identify managed objects |
|
51 | - //var $table_element='ccountry'; //!< Name of table without prefix where object is stored |
|
50 | + //var $element='ccountry'; //!< Id that identify managed objects |
|
51 | + //var $table_element='ccountry'; //!< Name of table without prefix where object is stored |
|
52 | 52 | |
53 | 53 | /** |
54 | - * @var int ID |
|
55 | - */ |
|
56 | - public $id; |
|
54 | + * @var int ID |
|
55 | + */ |
|
56 | + public $id; |
|
57 | 57 | |
58 | - public $code; |
|
59 | - public $code_iso; |
|
58 | + public $code; |
|
59 | + public $code_iso; |
|
60 | 60 | |
61 | - /** |
|
61 | + /** |
|
62 | 62 | * @var string Countries label |
63 | 63 | */ |
64 | 64 | public $label; |
65 | 65 | |
66 | - public $active; |
|
66 | + public $active; |
|
67 | 67 | |
68 | 68 | |
69 | 69 | |
@@ -88,73 +88,73 @@ discard block |
||
88 | 88 | */ |
89 | 89 | function create($user, $notrigger=0) |
90 | 90 | { |
91 | - global $conf, $langs; |
|
92 | - $error=0; |
|
91 | + global $conf, $langs; |
|
92 | + $error=0; |
|
93 | 93 | |
94 | - // Clean parameters |
|
95 | - if (isset($this->code)) $this->code=trim($this->code); |
|
96 | - if (isset($this->code_iso)) $this->code_iso=trim($this->code_iso); |
|
97 | - if (isset($this->label)) $this->label=trim($this->label); |
|
98 | - if (isset($this->active)) $this->active=trim($this->active); |
|
94 | + // Clean parameters |
|
95 | + if (isset($this->code)) $this->code=trim($this->code); |
|
96 | + if (isset($this->code_iso)) $this->code_iso=trim($this->code_iso); |
|
97 | + if (isset($this->label)) $this->label=trim($this->label); |
|
98 | + if (isset($this->active)) $this->active=trim($this->active); |
|
99 | 99 | |
100 | - // Check parameters |
|
101 | - // Put here code to add control on parameters values |
|
100 | + // Check parameters |
|
101 | + // Put here code to add control on parameters values |
|
102 | 102 | |
103 | 103 | // Insert request |
104 | - $sql = "INSERT INTO ".MAIN_DB_PREFIX."c_country("; |
|
105 | - $sql.= "rowid,"; |
|
106 | - $sql.= "code,"; |
|
107 | - $sql.= "code_iso,"; |
|
108 | - $sql.= "label,"; |
|
109 | - $sql.= "active"; |
|
104 | + $sql = "INSERT INTO ".MAIN_DB_PREFIX."c_country("; |
|
105 | + $sql.= "rowid,"; |
|
106 | + $sql.= "code,"; |
|
107 | + $sql.= "code_iso,"; |
|
108 | + $sql.= "label,"; |
|
109 | + $sql.= "active"; |
|
110 | 110 | $sql.= ") VALUES ("; |
111 | - $sql.= " ".(! isset($this->rowid)?'NULL':"'".$this->db->escape($this->rowid)."'").","; |
|
112 | - $sql.= " ".(! isset($this->code)?'NULL':"'".$this->db->escape($this->code)."'").","; |
|
113 | - $sql.= " ".(! isset($this->code_iso)?'NULL':"'".$this->db->escape($this->code_iso)."'").","; |
|
114 | - $sql.= " ".(! isset($this->label)?'NULL':"'".$this->db->escape($this->label)."'").","; |
|
115 | - $sql.= " ".(! isset($this->active)?'NULL':"'".$this->db->escape($this->active)."'").""; |
|
116 | - $sql.= ")"; |
|
111 | + $sql.= " ".(! isset($this->rowid)?'NULL':"'".$this->db->escape($this->rowid)."'").","; |
|
112 | + $sql.= " ".(! isset($this->code)?'NULL':"'".$this->db->escape($this->code)."'").","; |
|
113 | + $sql.= " ".(! isset($this->code_iso)?'NULL':"'".$this->db->escape($this->code_iso)."'").","; |
|
114 | + $sql.= " ".(! isset($this->label)?'NULL':"'".$this->db->escape($this->label)."'").","; |
|
115 | + $sql.= " ".(! isset($this->active)?'NULL':"'".$this->db->escape($this->active)."'").""; |
|
116 | + $sql.= ")"; |
|
117 | 117 | |
118 | - $this->db->begin(); |
|
118 | + $this->db->begin(); |
|
119 | 119 | |
120 | - dol_syslog(get_class($this)."::create", LOG_DEBUG); |
|
120 | + dol_syslog(get_class($this)."::create", LOG_DEBUG); |
|
121 | 121 | $resql=$this->db->query($sql); |
122 | - if (! $resql) { $error++; $this->errors[]="Error ".$this->db->lasterror(); } |
|
122 | + if (! $resql) { $error++; $this->errors[]="Error ".$this->db->lasterror(); } |
|
123 | 123 | |
124 | - if (! $error) |
|
124 | + if (! $error) |
|
125 | 125 | { |
126 | 126 | $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX."c_country"); |
127 | 127 | |
128 | - if (! $notrigger) |
|
129 | - { |
|
130 | - // Uncomment this and change MYOBJECT to your own tag if you |
|
131 | - // want this action call a trigger. |
|
132 | - |
|
133 | - //// Call triggers |
|
134 | - //include_once DOL_DOCUMENT_ROOT . '/core/class/interfaces.class.php'; |
|
135 | - //$interface=new Interfaces($this->db); |
|
136 | - //$result=$interface->run_triggers('MYOBJECT_CREATE',$this,$user,$langs,$conf); |
|
137 | - //if ($result < 0) { $error++; $this->errors=$interface->errors; } |
|
138 | - //// End call triggers |
|
139 | - } |
|
128 | + if (! $notrigger) |
|
129 | + { |
|
130 | + // Uncomment this and change MYOBJECT to your own tag if you |
|
131 | + // want this action call a trigger. |
|
132 | + |
|
133 | + //// Call triggers |
|
134 | + //include_once DOL_DOCUMENT_ROOT . '/core/class/interfaces.class.php'; |
|
135 | + //$interface=new Interfaces($this->db); |
|
136 | + //$result=$interface->run_triggers('MYOBJECT_CREATE',$this,$user,$langs,$conf); |
|
137 | + //if ($result < 0) { $error++; $this->errors=$interface->errors; } |
|
138 | + //// End call triggers |
|
139 | + } |
|
140 | 140 | } |
141 | 141 | |
142 | 142 | // Commit or rollback |
143 | 143 | if ($error) |
144 | - { |
|
145 | - foreach($this->errors as $errmsg) |
|
146 | - { |
|
147 | - dol_syslog(get_class($this)."::create ".$errmsg, LOG_ERR); |
|
148 | - $this->error.=($this->error?', '.$errmsg:$errmsg); |
|
149 | - } |
|
150 | - $this->db->rollback(); |
|
151 | - return -1*$error; |
|
152 | - } |
|
153 | - else |
|
154 | - { |
|
155 | - $this->db->commit(); |
|
144 | + { |
|
145 | + foreach($this->errors as $errmsg) |
|
146 | + { |
|
147 | + dol_syslog(get_class($this)."::create ".$errmsg, LOG_ERR); |
|
148 | + $this->error.=($this->error?', '.$errmsg:$errmsg); |
|
149 | + } |
|
150 | + $this->db->rollback(); |
|
151 | + return -1*$error; |
|
152 | + } |
|
153 | + else |
|
154 | + { |
|
155 | + $this->db->commit(); |
|
156 | 156 | return $this->id; |
157 | - } |
|
157 | + } |
|
158 | 158 | } |
159 | 159 | |
160 | 160 | |
@@ -167,18 +167,18 @@ discard block |
||
167 | 167 | */ |
168 | 168 | function fetch($id,$code='') |
169 | 169 | { |
170 | - global $langs; |
|
170 | + global $langs; |
|
171 | 171 | $sql = "SELECT"; |
172 | - $sql.= " t.rowid,"; |
|
173 | - $sql.= " t.code,"; |
|
174 | - $sql.= " t.code_iso,"; |
|
175 | - $sql.= " t.label,"; |
|
176 | - $sql.= " t.active"; |
|
172 | + $sql.= " t.rowid,"; |
|
173 | + $sql.= " t.code,"; |
|
174 | + $sql.= " t.code_iso,"; |
|
175 | + $sql.= " t.label,"; |
|
176 | + $sql.= " t.active"; |
|
177 | 177 | $sql.= " FROM ".MAIN_DB_PREFIX."c_country as t"; |
178 | 178 | if ($id) $sql.= " WHERE t.rowid = ".$id; |
179 | 179 | elseif ($code) $sql.= " WHERE t.code = '".$this->db->escape($code)."'"; |
180 | 180 | |
181 | - dol_syslog(get_class($this)."::fetch", LOG_DEBUG); |
|
181 | + dol_syslog(get_class($this)."::fetch", LOG_DEBUG); |
|
182 | 182 | $resql=$this->db->query($sql); |
183 | 183 | if ($resql) |
184 | 184 | { |
@@ -187,10 +187,10 @@ discard block |
||
187 | 187 | $obj = $this->db->fetch_object($resql); |
188 | 188 | |
189 | 189 | $this->id = $obj->rowid; |
190 | - $this->code = $obj->code; |
|
191 | - $this->code_iso = $obj->code_iso; |
|
192 | - $this->label = $obj->label; |
|
193 | - $this->active = $obj->active; |
|
190 | + $this->code = $obj->code; |
|
191 | + $this->code_iso = $obj->code_iso; |
|
192 | + $this->label = $obj->label; |
|
193 | + $this->active = $obj->active; |
|
194 | 194 | |
195 | 195 | $this->db->free($resql); |
196 | 196 | return 1; |
@@ -201,7 +201,7 @@ discard block |
||
201 | 201 | } |
202 | 202 | else |
203 | 203 | { |
204 | - $this->error="Error ".$this->db->lasterror(); |
|
204 | + $this->error="Error ".$this->db->lasterror(); |
|
205 | 205 | return -1; |
206 | 206 | } |
207 | 207 | } |
@@ -216,120 +216,120 @@ discard block |
||
216 | 216 | */ |
217 | 217 | function update($user=null, $notrigger=0) |
218 | 218 | { |
219 | - global $conf, $langs; |
|
220 | - $error=0; |
|
219 | + global $conf, $langs; |
|
220 | + $error=0; |
|
221 | 221 | |
222 | - // Clean parameters |
|
223 | - if (isset($this->code)) $this->code=trim($this->code); |
|
224 | - if (isset($this->code_iso)) $this->code_iso=trim($this->code_iso); |
|
225 | - if (isset($this->label)) $this->label=trim($this->label); |
|
226 | - if (isset($this->active)) $this->active=trim($this->active); |
|
222 | + // Clean parameters |
|
223 | + if (isset($this->code)) $this->code=trim($this->code); |
|
224 | + if (isset($this->code_iso)) $this->code_iso=trim($this->code_iso); |
|
225 | + if (isset($this->label)) $this->label=trim($this->label); |
|
226 | + if (isset($this->active)) $this->active=trim($this->active); |
|
227 | 227 | |
228 | 228 | |
229 | - // Check parameters |
|
230 | - // Put here code to add control on parameters values |
|
229 | + // Check parameters |
|
230 | + // Put here code to add control on parameters values |
|
231 | 231 | |
232 | 232 | // Update request |
233 | 233 | $sql = "UPDATE ".MAIN_DB_PREFIX."c_country SET"; |
234 | - $sql.= " code=".(isset($this->code)?"'".$this->db->escape($this->code)."'":"null").","; |
|
235 | - $sql.= " code_iso=".(isset($this->code_iso)?"'".$this->db->escape($this->code_iso)."'":"null").","; |
|
236 | - $sql.= " label=".(isset($this->label)?"'".$this->db->escape($this->label)."'":"null").","; |
|
237 | - $sql.= " active=".(isset($this->active)?$this->active:"null").""; |
|
234 | + $sql.= " code=".(isset($this->code)?"'".$this->db->escape($this->code)."'":"null").","; |
|
235 | + $sql.= " code_iso=".(isset($this->code_iso)?"'".$this->db->escape($this->code_iso)."'":"null").","; |
|
236 | + $sql.= " label=".(isset($this->label)?"'".$this->db->escape($this->label)."'":"null").","; |
|
237 | + $sql.= " active=".(isset($this->active)?$this->active:"null").""; |
|
238 | 238 | $sql.= " WHERE rowid=".$this->id; |
239 | 239 | |
240 | - $this->db->begin(); |
|
240 | + $this->db->begin(); |
|
241 | 241 | |
242 | - dol_syslog(get_class($this)."::update", LOG_DEBUG); |
|
242 | + dol_syslog(get_class($this)."::update", LOG_DEBUG); |
|
243 | 243 | $resql = $this->db->query($sql); |
244 | - if (! $resql) { $error++; $this->errors[]="Error ".$this->db->lasterror(); } |
|
245 | - |
|
246 | - if (! $error) |
|
247 | - { |
|
248 | - if (! $notrigger) |
|
249 | - { |
|
250 | - // Uncomment this and change MYOBJECT to your own tag if you |
|
251 | - // want this action call a trigger. |
|
252 | - |
|
253 | - //// Call triggers |
|
254 | - //include_once DOL_DOCUMENT_ROOT . '/core/class/interfaces.class.php'; |
|
255 | - //$interface=new Interfaces($this->db); |
|
256 | - //$result=$interface->run_triggers('MYOBJECT_MODIFY',$this,$user,$langs,$conf); |
|
257 | - //if ($result < 0) { $error++; $this->errors=$interface->errors; } |
|
258 | - //// End call triggers |
|
259 | - } |
|
260 | - } |
|
244 | + if (! $resql) { $error++; $this->errors[]="Error ".$this->db->lasterror(); } |
|
245 | + |
|
246 | + if (! $error) |
|
247 | + { |
|
248 | + if (! $notrigger) |
|
249 | + { |
|
250 | + // Uncomment this and change MYOBJECT to your own tag if you |
|
251 | + // want this action call a trigger. |
|
252 | + |
|
253 | + //// Call triggers |
|
254 | + //include_once DOL_DOCUMENT_ROOT . '/core/class/interfaces.class.php'; |
|
255 | + //$interface=new Interfaces($this->db); |
|
256 | + //$result=$interface->run_triggers('MYOBJECT_MODIFY',$this,$user,$langs,$conf); |
|
257 | + //if ($result < 0) { $error++; $this->errors=$interface->errors; } |
|
258 | + //// End call triggers |
|
259 | + } |
|
260 | + } |
|
261 | 261 | |
262 | 262 | // Commit or rollback |
263 | - if ($error) |
|
264 | - { |
|
265 | - foreach($this->errors as $errmsg) |
|
266 | - { |
|
267 | - dol_syslog(get_class($this)."::update ".$errmsg, LOG_ERR); |
|
268 | - $this->error.=($this->error?', '.$errmsg:$errmsg); |
|
269 | - } |
|
270 | - $this->db->rollback(); |
|
271 | - return -1*$error; |
|
272 | - } |
|
273 | - else |
|
274 | - { |
|
275 | - $this->db->commit(); |
|
276 | - return 1; |
|
277 | - } |
|
263 | + if ($error) |
|
264 | + { |
|
265 | + foreach($this->errors as $errmsg) |
|
266 | + { |
|
267 | + dol_syslog(get_class($this)."::update ".$errmsg, LOG_ERR); |
|
268 | + $this->error.=($this->error?', '.$errmsg:$errmsg); |
|
269 | + } |
|
270 | + $this->db->rollback(); |
|
271 | + return -1*$error; |
|
272 | + } |
|
273 | + else |
|
274 | + { |
|
275 | + $this->db->commit(); |
|
276 | + return 1; |
|
277 | + } |
|
278 | 278 | } |
279 | 279 | |
280 | 280 | |
281 | - /** |
|
282 | - * Delete object in database |
|
283 | - * |
|
284 | - * @param User $user User that delete |
|
285 | - * @param int $notrigger 0=launch triggers after, 1=disable triggers |
|
286 | - * @return int <0 if KO, >0 if OK |
|
287 | - */ |
|
288 | - function delete($user, $notrigger=0) |
|
289 | - { |
|
290 | - global $conf, $langs; |
|
291 | - $error=0; |
|
292 | - |
|
293 | - $sql = "DELETE FROM ".MAIN_DB_PREFIX."c_country"; |
|
294 | - $sql.= " WHERE rowid=".$this->id; |
|
295 | - |
|
296 | - $this->db->begin(); |
|
297 | - |
|
298 | - dol_syslog(get_class($this)."::delete", LOG_DEBUG); |
|
299 | - $resql = $this->db->query($sql); |
|
300 | - if (! $resql) { $error++; $this->errors[]="Error ".$this->db->lasterror(); } |
|
301 | - |
|
302 | - if (! $error) |
|
303 | - { |
|
304 | - if (! $notrigger) |
|
305 | - { |
|
306 | - // Uncomment this and change MYOBJECT to your own tag if you |
|
307 | - // want this action call a trigger. |
|
308 | - |
|
309 | - //// Call triggers |
|
310 | - //include_once DOL_DOCUMENT_ROOT . '/core/class/interfaces.class.php'; |
|
311 | - //$interface=new Interfaces($this->db); |
|
312 | - //$result=$interface->run_triggers('MYOBJECT_DELETE',$this,$user,$langs,$conf); |
|
313 | - //if ($result < 0) { $error++; $this->errors=$interface->errors; } |
|
314 | - //// End call triggers |
|
315 | - } |
|
316 | - } |
|
281 | + /** |
|
282 | + * Delete object in database |
|
283 | + * |
|
284 | + * @param User $user User that delete |
|
285 | + * @param int $notrigger 0=launch triggers after, 1=disable triggers |
|
286 | + * @return int <0 if KO, >0 if OK |
|
287 | + */ |
|
288 | + function delete($user, $notrigger=0) |
|
289 | + { |
|
290 | + global $conf, $langs; |
|
291 | + $error=0; |
|
292 | + |
|
293 | + $sql = "DELETE FROM ".MAIN_DB_PREFIX."c_country"; |
|
294 | + $sql.= " WHERE rowid=".$this->id; |
|
295 | + |
|
296 | + $this->db->begin(); |
|
297 | + |
|
298 | + dol_syslog(get_class($this)."::delete", LOG_DEBUG); |
|
299 | + $resql = $this->db->query($sql); |
|
300 | + if (! $resql) { $error++; $this->errors[]="Error ".$this->db->lasterror(); } |
|
301 | + |
|
302 | + if (! $error) |
|
303 | + { |
|
304 | + if (! $notrigger) |
|
305 | + { |
|
306 | + // Uncomment this and change MYOBJECT to your own tag if you |
|
307 | + // want this action call a trigger. |
|
308 | + |
|
309 | + //// Call triggers |
|
310 | + //include_once DOL_DOCUMENT_ROOT . '/core/class/interfaces.class.php'; |
|
311 | + //$interface=new Interfaces($this->db); |
|
312 | + //$result=$interface->run_triggers('MYOBJECT_DELETE',$this,$user,$langs,$conf); |
|
313 | + //if ($result < 0) { $error++; $this->errors=$interface->errors; } |
|
314 | + //// End call triggers |
|
315 | + } |
|
316 | + } |
|
317 | 317 | |
318 | 318 | // Commit or rollback |
319 | - if ($error) |
|
320 | - { |
|
321 | - foreach($this->errors as $errmsg) |
|
322 | - { |
|
323 | - dol_syslog(get_class($this)."::delete ".$errmsg, LOG_ERR); |
|
324 | - $this->error.=($this->error?', '.$errmsg:$errmsg); |
|
325 | - } |
|
326 | - $this->db->rollback(); |
|
327 | - return -1*$error; |
|
328 | - } |
|
329 | - else |
|
330 | - { |
|
331 | - $this->db->commit(); |
|
332 | - return 1; |
|
333 | - } |
|
334 | - } |
|
319 | + if ($error) |
|
320 | + { |
|
321 | + foreach($this->errors as $errmsg) |
|
322 | + { |
|
323 | + dol_syslog(get_class($this)."::delete ".$errmsg, LOG_ERR); |
|
324 | + $this->error.=($this->error?', '.$errmsg:$errmsg); |
|
325 | + } |
|
326 | + $this->db->rollback(); |
|
327 | + return -1*$error; |
|
328 | + } |
|
329 | + else |
|
330 | + { |
|
331 | + $this->db->commit(); |
|
332 | + return 1; |
|
333 | + } |
|
334 | + } |
|
335 | 335 | } |
@@ -34,27 +34,27 @@ discard block |
||
34 | 34 | */ |
35 | 35 | abstract class CommonDocGenerator |
36 | 36 | { |
37 | - /** |
|
38 | - * @var string Error code (or message) |
|
39 | - */ |
|
40 | - public $error=''; |
|
37 | + /** |
|
38 | + * @var string Error code (or message) |
|
39 | + */ |
|
40 | + public $error=''; |
|
41 | 41 | |
42 | 42 | /** |
43 | 43 | * @var string[] Array of error strings |
44 | 44 | */ |
45 | 45 | public $errors = array(); |
46 | 46 | |
47 | - /** |
|
47 | + /** |
|
48 | 48 | * @var DoliDB Database handler. |
49 | 49 | */ |
50 | - protected $db; |
|
50 | + protected $db; |
|
51 | 51 | |
52 | 52 | |
53 | - /** |
|
54 | - * Constructor |
|
55 | - * |
|
56 | - * @param DoliDB $db Database handler |
|
57 | - */ |
|
53 | + /** |
|
54 | + * Constructor |
|
55 | + * |
|
56 | + * @param DoliDB $db Database handler |
|
57 | + */ |
|
58 | 58 | public function __construct($db) |
59 | 59 | { |
60 | 60 | $this->db = $db; |
@@ -82,18 +82,18 @@ discard block |
||
82 | 82 | 'myuser_fullname'=>$user->getFullName($outputlangs,1), |
83 | 83 | 'myuser_login'=>$user->login, |
84 | 84 | 'myuser_phone'=>$user->office_phone, |
85 | - 'myuser_address'=>$user->address, |
|
86 | - 'myuser_zip'=>$user->zip, |
|
87 | - 'myuser_town'=>$user->town, |
|
88 | - 'myuser_country'=>$user->country, |
|
89 | - 'myuser_country_code'=>$user->country_code, |
|
90 | - 'myuser_state'=>$user->state, |
|
91 | - 'myuser_state_code'=>$user->state_code, |
|
92 | - 'myuser_fax'=>$user->office_fax, |
|
85 | + 'myuser_address'=>$user->address, |
|
86 | + 'myuser_zip'=>$user->zip, |
|
87 | + 'myuser_town'=>$user->town, |
|
88 | + 'myuser_country'=>$user->country, |
|
89 | + 'myuser_country_code'=>$user->country_code, |
|
90 | + 'myuser_state'=>$user->state, |
|
91 | + 'myuser_state_code'=>$user->state_code, |
|
92 | + 'myuser_fax'=>$user->office_fax, |
|
93 | 93 | 'myuser_mobile'=>$user->user_mobile, |
94 | 94 | 'myuser_email'=>$user->email, |
95 | - 'myuser_logo'=>$logotouse, |
|
96 | - 'myuser_job'=>$user->job, |
|
95 | + 'myuser_logo'=>$logotouse, |
|
96 | + 'myuser_job'=>$user->job, |
|
97 | 97 | 'myuser_web'=>'' // url not exist in $user object |
98 | 98 | ); |
99 | 99 | } |
@@ -118,11 +118,11 @@ discard block |
||
118 | 118 | } |
119 | 119 | if (empty($mysoc->country) && ! empty($mysoc->country_code)) |
120 | 120 | { |
121 | - $mysoc->country=$outputlangs->transnoentitiesnoconv("Country".$mysoc->country_code); |
|
121 | + $mysoc->country=$outputlangs->transnoentitiesnoconv("Country".$mysoc->country_code); |
|
122 | 122 | } |
123 | 123 | if (empty($mysoc->state) && ! empty($mysoc->state_code)) |
124 | 124 | { |
125 | - $mysoc->state=getState($mysoc->state_code,0); |
|
125 | + $mysoc->state=getState($mysoc->state_code,0); |
|
126 | 126 | } |
127 | 127 | |
128 | 128 | $logotouse=$conf->mycompany->dir_output.'/logos/thumbs/'.$mysoc->logo_small; |
@@ -140,7 +140,7 @@ discard block |
||
140 | 140 | 'mycompany_country_code'=>$mysoc->country_code, |
141 | 141 | 'mycompany_state'=>$mysoc->state, |
142 | 142 | 'mycompany_state_code'=>$mysoc->state_code, |
143 | - 'mycompany_web'=>$mysoc->url, |
|
143 | + 'mycompany_web'=>$mysoc->url, |
|
144 | 144 | 'mycompany_juridicalstatus'=>$mysoc->forme_juridique, |
145 | 145 | 'mycompany_managers'=>$mysoc->managers, |
146 | 146 | 'mycompany_capital'=>$mysoc->capital, |
@@ -151,8 +151,8 @@ discard block |
||
151 | 151 | 'mycompany_idprof4'=>$mysoc->idprof4, |
152 | 152 | 'mycompany_idprof5'=>$mysoc->idprof5, |
153 | 153 | 'mycompany_idprof6'=>$mysoc->idprof6, |
154 | - 'mycompany_vatnumber'=>$mysoc->tva_intra, |
|
155 | - 'mycompany_object'=>$mysoc->object, |
|
154 | + 'mycompany_vatnumber'=>$mysoc->tva_intra, |
|
155 | + 'mycompany_object'=>$mysoc->object, |
|
156 | 156 | 'mycompany_note_private'=>$mysoc->note_private, |
157 | 157 | //'mycompany_note_public'=>$mysoc->note_public, // Only private not exists for "mysoc" but both for thirdparties |
158 | 158 | ); |
@@ -174,16 +174,16 @@ discard block |
||
174 | 174 | |
175 | 175 | if (empty($object->country) && ! empty($object->country_code)) |
176 | 176 | { |
177 | - $object->country=$outputlangs->transnoentitiesnoconv("Country".$object->country_code); |
|
177 | + $object->country=$outputlangs->transnoentitiesnoconv("Country".$object->country_code); |
|
178 | 178 | } |
179 | 179 | if (empty($object->state) && ! empty($object->state_code)) |
180 | 180 | { |
181 | - $object->state=getState($object->state_code,0); |
|
181 | + $object->state=getState($object->state_code,0); |
|
182 | 182 | } |
183 | 183 | |
184 | 184 | $array_thirdparty = array( |
185 | 185 | 'company_name'=>$object->name, |
186 | - 'company_name_alias' => $object->name_alias, |
|
186 | + 'company_name_alias' => $object->name_alias, |
|
187 | 187 | 'company_email'=>$object->email, |
188 | 188 | 'company_phone'=>$object->phone, |
189 | 189 | 'company_fax'=>$object->fax, |
@@ -191,10 +191,10 @@ discard block |
||
191 | 191 | 'company_zip'=>$object->zip, |
192 | 192 | 'company_town'=>$object->town, |
193 | 193 | 'company_country'=>$object->country, |
194 | - 'company_country_code'=>$object->country_code, |
|
194 | + 'company_country_code'=>$object->country_code, |
|
195 | 195 | 'company_state'=>$object->state, |
196 | - 'company_state_code'=>$object->state_code, |
|
197 | - 'company_web'=>$object->url, |
|
196 | + 'company_state_code'=>$object->state_code, |
|
197 | + 'company_web'=>$object->url, |
|
198 | 198 | 'company_barcode'=>$object->barcode, |
199 | 199 | 'company_vatnumber'=>$object->tva_intra, |
200 | 200 | 'company_customercode'=>$object->code_client, |
@@ -219,52 +219,52 @@ discard block |
||
219 | 219 | // Retrieve extrafields |
220 | 220 | if(is_array($object->array_options) && count($object->array_options)) |
221 | 221 | { |
222 | - require_once DOL_DOCUMENT_ROOT.'/core/class/extrafields.class.php'; |
|
223 | - $extrafields = new ExtraFields($this->db); |
|
224 | - $extralabels = $extrafields->fetch_name_optionals_label('societe',true); |
|
225 | - $object->fetch_optionals(); |
|
226 | - |
|
227 | - foreach($extrafields->attribute_label as $key=>$label) |
|
228 | - { |
|
229 | - if($extrafields->attribute_type[$key] == 'price') |
|
230 | - { |
|
231 | - $object->array_options['options_'.$key] = price($object->array_options['options_'.$key],0,$outputlangs,0,0,-1,$conf->currency); |
|
232 | - } |
|
233 | - else if($extrafields->attribute_type[$key] == 'select' || $extrafields->attribute_type[$key] == 'checkbox') |
|
234 | - { |
|
235 | - $object->array_options['options_'.$key] = $extrafields->attribute_param[$key]['options'][$object->array_options['options_'.$key]]; |
|
236 | - } |
|
237 | - $array_thirdparty = array_merge($array_thirdparty, array ('company_options_'.$key => $object->array_options ['options_' . $key])); |
|
238 | - } |
|
239 | - } |
|
240 | - return $array_thirdparty; |
|
241 | - } |
|
222 | + require_once DOL_DOCUMENT_ROOT.'/core/class/extrafields.class.php'; |
|
223 | + $extrafields = new ExtraFields($this->db); |
|
224 | + $extralabels = $extrafields->fetch_name_optionals_label('societe',true); |
|
225 | + $object->fetch_optionals(); |
|
226 | + |
|
227 | + foreach($extrafields->attribute_label as $key=>$label) |
|
228 | + { |
|
229 | + if($extrafields->attribute_type[$key] == 'price') |
|
230 | + { |
|
231 | + $object->array_options['options_'.$key] = price($object->array_options['options_'.$key],0,$outputlangs,0,0,-1,$conf->currency); |
|
232 | + } |
|
233 | + else if($extrafields->attribute_type[$key] == 'select' || $extrafields->attribute_type[$key] == 'checkbox') |
|
234 | + { |
|
235 | + $object->array_options['options_'.$key] = $extrafields->attribute_param[$key]['options'][$object->array_options['options_'.$key]]; |
|
236 | + } |
|
237 | + $array_thirdparty = array_merge($array_thirdparty, array ('company_options_'.$key => $object->array_options ['options_' . $key])); |
|
238 | + } |
|
239 | + } |
|
240 | + return $array_thirdparty; |
|
241 | + } |
|
242 | 242 | |
243 | 243 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
244 | - /** |
|
245 | - * Define array with couple subtitution key => subtitution value |
|
246 | - * |
|
247 | - * @param Contact $object contact |
|
248 | - * @param Translate $outputlangs object for output |
|
249 | - * @param array $array_key Name of the key for return array |
|
250 | - * @return array Array of substitution key->code |
|
251 | - */ |
|
244 | + /** |
|
245 | + * Define array with couple subtitution key => subtitution value |
|
246 | + * |
|
247 | + * @param Contact $object contact |
|
248 | + * @param Translate $outputlangs object for output |
|
249 | + * @param array $array_key Name of the key for return array |
|
250 | + * @return array Array of substitution key->code |
|
251 | + */ |
|
252 | 252 | function get_substitutionarray_contact($object, $outputlangs, $array_key = 'object') |
253 | 253 | { |
254 | 254 | // phpcs:enable |
255 | - global $conf; |
|
256 | - |
|
257 | - if(empty($object->country) && ! empty($object->country_code)) |
|
258 | - { |
|
259 | - $object->country = $outputlangs->transnoentitiesnoconv("Country" . $object->country_code); |
|
260 | - } |
|
261 | - if(empty($object->state) && ! empty($object->state_code)) |
|
262 | - { |
|
263 | - $object->state = getState($object->state_code, 0); |
|
264 | - } |
|
265 | - |
|
266 | - $array_contact = array ( |
|
267 | - $array_key . '_fullname' => $object->getFullName($outputlangs, 1), |
|
255 | + global $conf; |
|
256 | + |
|
257 | + if(empty($object->country) && ! empty($object->country_code)) |
|
258 | + { |
|
259 | + $object->country = $outputlangs->transnoentitiesnoconv("Country" . $object->country_code); |
|
260 | + } |
|
261 | + if(empty($object->state) && ! empty($object->state_code)) |
|
262 | + { |
|
263 | + $object->state = getState($object->state_code, 0); |
|
264 | + } |
|
265 | + |
|
266 | + $array_contact = array ( |
|
267 | + $array_key . '_fullname' => $object->getFullName($outputlangs, 1), |
|
268 | 268 | $array_key . '_lastname' => $object->lastname, |
269 | 269 | $array_key . '_firstname' => $object->firstname, |
270 | 270 | $array_key . '_address' => $object->address, |
@@ -290,28 +290,28 @@ discard block |
||
290 | 290 | $array_key . '_default_lang' => $object->default_lang, |
291 | 291 | $array_key . '_note_public' => $object->note_public, |
292 | 292 | $array_key . '_note_private' => $object->note_private |
293 | - ); |
|
294 | - |
|
295 | - // Retrieve extrafields |
|
296 | - require_once DOL_DOCUMENT_ROOT . '/core/class/extrafields.class.php'; |
|
297 | - $extrafields = new ExtraFields($this->db); |
|
298 | - $extralabels = $extrafields->fetch_name_optionals_label('socpeople', true); |
|
299 | - $object->fetch_optionals(); |
|
300 | - |
|
301 | - foreach($extrafields->attribute_label as $key => $label) |
|
302 | - { |
|
303 | - if ($extrafields->attribute_type[$key] == 'price') |
|
304 | - { |
|
305 | - $object->array_options['options_' . $key] = price($object->array_options ['options_' . $key], 0, $outputlangs, 0, 0, - 1, $conf->currency); |
|
306 | - } |
|
307 | - elseif($extrafields->attribute_type[$key] == 'select' || $extrafields->attribute_type[$key] == 'checkbox') |
|
308 | - { |
|
309 | - $object->array_options['options_' . $key] = $extrafields->attribute_param[$key]['options'][$object->array_options['options_' . $key]]; |
|
310 | - } |
|
311 | - $array_contact = array_merge($array_contact, array($array_key.'_options_' . $key => $object->array_options['options_'. $key])); |
|
312 | - } |
|
313 | - return $array_contact; |
|
314 | - } |
|
293 | + ); |
|
294 | + |
|
295 | + // Retrieve extrafields |
|
296 | + require_once DOL_DOCUMENT_ROOT . '/core/class/extrafields.class.php'; |
|
297 | + $extrafields = new ExtraFields($this->db); |
|
298 | + $extralabels = $extrafields->fetch_name_optionals_label('socpeople', true); |
|
299 | + $object->fetch_optionals(); |
|
300 | + |
|
301 | + foreach($extrafields->attribute_label as $key => $label) |
|
302 | + { |
|
303 | + if ($extrafields->attribute_type[$key] == 'price') |
|
304 | + { |
|
305 | + $object->array_options['options_' . $key] = price($object->array_options ['options_' . $key], 0, $outputlangs, 0, 0, - 1, $conf->currency); |
|
306 | + } |
|
307 | + elseif($extrafields->attribute_type[$key] == 'select' || $extrafields->attribute_type[$key] == 'checkbox') |
|
308 | + { |
|
309 | + $object->array_options['options_' . $key] = $extrafields->attribute_param[$key]['options'][$object->array_options['options_' . $key]]; |
|
310 | + } |
|
311 | + $array_contact = array_merge($array_contact, array($array_key.'_options_' . $key => $object->array_options['options_'. $key])); |
|
312 | + } |
|
313 | + return $array_contact; |
|
314 | + } |
|
315 | 315 | |
316 | 316 | |
317 | 317 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
@@ -324,260 +324,260 @@ discard block |
||
324 | 324 | function get_substitutionarray_other($outputlangs) |
325 | 325 | { |
326 | 326 | // phpcs:enable |
327 | - global $conf; |
|
328 | - |
|
329 | - $now=dol_now('gmt'); // gmt |
|
330 | - $array_other = array( |
|
331 | - // Date in default language |
|
332 | - 'current_date'=>dol_print_date($now,'day','tzuser'), |
|
333 | - 'current_datehour'=>dol_print_date($now,'dayhour','tzuser'), |
|
334 | - 'current_server_date'=>dol_print_date($now,'day','tzserver'), |
|
335 | - 'current_server_datehour'=>dol_print_date($now,'dayhour','tzserver'), |
|
336 | - // Date in requested output language |
|
337 | - 'current_date_locale'=>dol_print_date($now,'day','tzuser',$outputlangs), |
|
338 | - 'current_datehour_locale'=>dol_print_date($now,'dayhour','tzuser',$outputlangs), |
|
339 | - 'current_server_date_locale'=>dol_print_date($now,'day','tzserver',$outputlangs), |
|
340 | - 'current_server_datehour_locale'=>dol_print_date($now,'dayhour','tzserver',$outputlangs), |
|
341 | - ); |
|
342 | - |
|
343 | - |
|
344 | - foreach($conf->global as $key => $val) |
|
345 | - { |
|
346 | - if (preg_match('/(_pass|password|secret|_key|key$)/i', $key)) $newval = '*****forbidden*****'; |
|
347 | - else $newval = $val; |
|
348 | - $array_other['__['.$key.']__'] = $newval; |
|
349 | - } |
|
350 | - |
|
351 | - return $array_other; |
|
327 | + global $conf; |
|
328 | + |
|
329 | + $now=dol_now('gmt'); // gmt |
|
330 | + $array_other = array( |
|
331 | + // Date in default language |
|
332 | + 'current_date'=>dol_print_date($now,'day','tzuser'), |
|
333 | + 'current_datehour'=>dol_print_date($now,'dayhour','tzuser'), |
|
334 | + 'current_server_date'=>dol_print_date($now,'day','tzserver'), |
|
335 | + 'current_server_datehour'=>dol_print_date($now,'dayhour','tzserver'), |
|
336 | + // Date in requested output language |
|
337 | + 'current_date_locale'=>dol_print_date($now,'day','tzuser',$outputlangs), |
|
338 | + 'current_datehour_locale'=>dol_print_date($now,'dayhour','tzuser',$outputlangs), |
|
339 | + 'current_server_date_locale'=>dol_print_date($now,'day','tzserver',$outputlangs), |
|
340 | + 'current_server_datehour_locale'=>dol_print_date($now,'dayhour','tzserver',$outputlangs), |
|
341 | + ); |
|
342 | + |
|
343 | + |
|
344 | + foreach($conf->global as $key => $val) |
|
345 | + { |
|
346 | + if (preg_match('/(_pass|password|secret|_key|key$)/i', $key)) $newval = '*****forbidden*****'; |
|
347 | + else $newval = $val; |
|
348 | + $array_other['__['.$key.']__'] = $newval; |
|
349 | + } |
|
350 | + |
|
351 | + return $array_other; |
|
352 | 352 | } |
353 | 353 | |
354 | 354 | |
355 | 355 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
356 | - /** |
|
357 | - * Define array with couple substitution key => substitution value |
|
358 | - * |
|
359 | - * @param Object $object Main object to use as data source |
|
360 | - * @param Translate $outputlangs Lang object to use for output |
|
356 | + /** |
|
357 | + * Define array with couple substitution key => substitution value |
|
358 | + * |
|
359 | + * @param Object $object Main object to use as data source |
|
360 | + * @param Translate $outputlangs Lang object to use for output |
|
361 | 361 | * @param string $array_key Name of the key for return array |
362 | - * @return array Array of substitution |
|
363 | - */ |
|
364 | - function get_substitutionarray_object($object,$outputlangs,$array_key='object') |
|
365 | - { |
|
362 | + * @return array Array of substitution |
|
363 | + */ |
|
364 | + function get_substitutionarray_object($object,$outputlangs,$array_key='object') |
|
365 | + { |
|
366 | 366 | // phpcs:enable |
367 | - global $conf; |
|
368 | - |
|
369 | - $sumpayed=$sumdeposit=$sumcreditnote=''; |
|
370 | - if ($object->element == 'facture') |
|
371 | - { |
|
372 | - $invoice_source=new Facture($this->db); |
|
373 | - if ($object->fk_facture_source > 0) |
|
374 | - { |
|
375 | - $invoice_source->fetch($object->fk_facture_source); |
|
376 | - } |
|
377 | - $sumpayed = $object->getSommePaiement(); |
|
378 | - $sumdeposit = $object->getSumDepositsUsed(); |
|
379 | - $sumcreditnote = $object->getSumCreditNotesUsed(); |
|
380 | - } |
|
381 | - |
|
382 | - $date = ($object->element == 'contrat' ? $object->date_contrat : $object->date); |
|
383 | - |
|
384 | - $resarray=array( |
|
385 | - $array_key.'_id'=>$object->id, |
|
386 | - $array_key.'_ref'=>$object->ref, |
|
387 | - $array_key.'_ref_ext'=>$object->ref_ext, |
|
388 | - $array_key.'_ref_customer'=>(! empty($object->ref_client) ? $object->ref_client : (empty($object->ref_customer) ? '' : $object->ref_customer)), |
|
389 | - $array_key.'_ref_supplier'=>(! empty($object->ref_fournisseur) ? $object->ref_fournisseur : (empty($object->ref_supplier) ? '' : $object->ref_supplier)), |
|
390 | - $array_key.'_source_invoice_ref'=>$invoice_source->ref, |
|
391 | - // Dates |
|
367 | + global $conf; |
|
368 | + |
|
369 | + $sumpayed=$sumdeposit=$sumcreditnote=''; |
|
370 | + if ($object->element == 'facture') |
|
371 | + { |
|
372 | + $invoice_source=new Facture($this->db); |
|
373 | + if ($object->fk_facture_source > 0) |
|
374 | + { |
|
375 | + $invoice_source->fetch($object->fk_facture_source); |
|
376 | + } |
|
377 | + $sumpayed = $object->getSommePaiement(); |
|
378 | + $sumdeposit = $object->getSumDepositsUsed(); |
|
379 | + $sumcreditnote = $object->getSumCreditNotesUsed(); |
|
380 | + } |
|
381 | + |
|
382 | + $date = ($object->element == 'contrat' ? $object->date_contrat : $object->date); |
|
383 | + |
|
384 | + $resarray=array( |
|
385 | + $array_key.'_id'=>$object->id, |
|
386 | + $array_key.'_ref'=>$object->ref, |
|
387 | + $array_key.'_ref_ext'=>$object->ref_ext, |
|
388 | + $array_key.'_ref_customer'=>(! empty($object->ref_client) ? $object->ref_client : (empty($object->ref_customer) ? '' : $object->ref_customer)), |
|
389 | + $array_key.'_ref_supplier'=>(! empty($object->ref_fournisseur) ? $object->ref_fournisseur : (empty($object->ref_supplier) ? '' : $object->ref_supplier)), |
|
390 | + $array_key.'_source_invoice_ref'=>$invoice_source->ref, |
|
391 | + // Dates |
|
392 | 392 | $array_key.'_hour'=>dol_print_date($date,'hour'), |
393 | - $array_key.'_date'=>dol_print_date($date,'day'), |
|
394 | - $array_key.'_date_rfc'=>dol_print_date($date,'dayrfc'), |
|
395 | - $array_key.'_date_limit'=>(! empty($object->date_lim_reglement)?dol_print_date($object->date_lim_reglement,'day'):''), |
|
396 | - $array_key.'_date_end'=>(! empty($object->fin_validite)?dol_print_date($object->fin_validite,'day'):''), |
|
397 | - $array_key.'_date_creation'=>dol_print_date($object->date_creation,'day'), |
|
398 | - $array_key.'_date_modification'=>(! empty($object->date_modification)?dol_print_date($object->date_modification,'day'):''), |
|
399 | - $array_key.'_date_validation'=>(! empty($object->date_validation)?dol_print_date($object->date_validation,'dayhour'):''), |
|
400 | - $array_key.'_date_delivery_planed'=>(! empty($object->date_livraison)?dol_print_date($object->date_livraison,'day'):''), |
|
401 | - $array_key.'_date_close'=>(! empty($object->date_cloture)?dol_print_date($object->date_cloture,'dayhour'):''), |
|
402 | - |
|
403 | - $array_key.'_payment_mode_code'=>$object->mode_reglement_code, |
|
404 | - $array_key.'_payment_mode'=>($outputlangs->transnoentitiesnoconv('PaymentType'.$object->mode_reglement_code)!='PaymentType'.$object->mode_reglement_code?$outputlangs->transnoentitiesnoconv('PaymentType'.$object->mode_reglement_code):$object->mode_reglement), |
|
405 | - $array_key.'_payment_term_code'=>$object->cond_reglement_code, |
|
406 | - $array_key.'_payment_term'=>($outputlangs->transnoentitiesnoconv('PaymentCondition'.$object->cond_reglement_code)!='PaymentCondition'.$object->cond_reglement_code?$outputlangs->transnoentitiesnoconv('PaymentCondition'.$object->cond_reglement_code):($object->cond_reglement_doc?$object->cond_reglement_doc:$object->cond_reglement)), |
|
407 | - |
|
408 | - $array_key.'_total_ht_locale'=>price($object->total_ht, 0, $outputlangs), |
|
409 | - $array_key.'_total_vat_locale'=>(! empty($object->total_vat)?price($object->total_vat, 0, $outputlangs):price($object->total_tva, 0, $outputlangs)), |
|
410 | - $array_key.'_total_localtax1_locale'=>price($object->total_localtax1, 0, $outputlangs), |
|
411 | - $array_key.'_total_localtax2_locale'=>price($object->total_localtax2, 0, $outputlangs), |
|
412 | - $array_key.'_total_ttc_locale'=>price($object->total_ttc, 0, $outputlangs), |
|
413 | - |
|
414 | - $array_key.'_total_ht'=>price2num($object->total_ht), |
|
415 | - $array_key.'_total_vat'=>(! empty($object->total_vat)?price2num($object->total_vat):price2num($object->total_tva)), |
|
416 | - $array_key.'_total_localtax1'=>price2num($object->total_localtax1), |
|
417 | - $array_key.'_total_localtax2'=>price2num($object->total_localtax2), |
|
418 | - $array_key.'_total_ttc'=>price2num($object->total_ttc), |
|
419 | - |
|
420 | - $array_key.'_multicurrency_code' => price2num($object->multicurrency_code), |
|
421 | - $array_key.'_multicurrency_tx' => price2num($object->multicurrency_tx), |
|
422 | - $array_key.'_multicurrency_total_ht' => price2num($object->multicurrency_total_ht), |
|
423 | - $array_key.'_multicurrency_total_tva' => price2num($object->multicurrency_total_tva), |
|
424 | - $array_key.'_multicurrency_total_ttc' => price2num($object->multicurrency_total_ttc), |
|
425 | - $array_key.'_multicurrency_total_ht_locale' => price($object->multicurrency_total_ht, 0, $outputlangs), |
|
426 | - $array_key.'_multicurrency_total_tva_locale' => price($object->multicurrency_total_tva, 0, $outputlangs), |
|
427 | - $array_key.'_multicurrency_total_ttc_locale' => price($object->multicurrency_total_ttc, 0, $outputlangs), |
|
428 | - |
|
429 | - $array_key.'_note_private'=>$object->note, |
|
430 | - $array_key.'_note_public'=>$object->note_public, |
|
431 | - $array_key.'_note'=>$object->note_public, // For backward compatibility |
|
432 | - |
|
433 | - // Payments |
|
434 | - $array_key.'_already_payed_locale'=>price($sumpayed, 0, $outputlangs), |
|
435 | - $array_key.'_already_payed'=>price2num($sumpayed), |
|
436 | - $array_key.'_already_deposit_locale'=>price($sumdeposit, 0, $outputlangs), |
|
437 | - $array_key.'_already_deposit'=>price2num($sumdeposit), |
|
438 | - $array_key.'_already_creditnote_locale'=>price($sumcreditnote, 0, $outputlangs), |
|
439 | - $array_key.'_already_creditnote'=>price2num($sumcreditnote), |
|
440 | - |
|
441 | - $array_key.'_already_payed_all_locale'=>price(price2num($sumpayed + $sumdeposit + $sumcreditnote, 'MT'), 0, $outputlangs), |
|
442 | - $array_key.'_already_payed_all'=> price2num(($sumpayed + $sumdeposit + $sumcreditnote), 'MT'), |
|
443 | - |
|
444 | - // Remain to pay with all know infrmation (except open direct debit requests) |
|
445 | - $array_key.'_remain_to_pay_locale'=>price(price2num($object->total_ttc - $sumpayed - $sumdeposit - $sumcreditnote, 'MT'), 0, $outputlangs), |
|
446 | - $array_key.'_remain_to_pay'=>price2num($object->total_ttc - $sumpayed - $sumdeposit - $sumcreditnote, 'MT') |
|
447 | - ); |
|
448 | - |
|
449 | - if (method_exists($object, 'getTotalDiscount')) { |
|
450 | - $resarray[$array_key.'_total_discount_ht_locale'] = price($object->getTotalDiscount(), 0, $outputlangs); |
|
451 | - $resarray[$array_key.'_total_discount_ht'] = price2num($object->getTotalDiscount()); |
|
452 | - } else { |
|
453 | - $resarray[$array_key.'_total_discount_ht_locale'] = ''; |
|
454 | - $resarray[$array_key.'_total_discount_ht'] = ''; |
|
455 | - } |
|
456 | - |
|
457 | - // Fetch project information if there is a project assigned to this object |
|
458 | - if ($object->element != "project" && ! empty($object->fk_project) && $object->fk_project > 0) |
|
459 | - { |
|
460 | - if (! is_object($object->project)) |
|
461 | - { |
|
462 | - $object->fetch_projet(); |
|
463 | - } |
|
464 | - |
|
465 | - $resarray[$array_key.'_project_ref'] = $object->project->ref; |
|
466 | - $resarray[$array_key.'_project_title'] = $object->project->title; |
|
467 | - $resarray[$array_key.'_project_description'] = $object->project->description; |
|
468 | - $resarray[$array_key.'_project_date_start'] = dol_print_date($object->project->date_start, 'day'); |
|
469 | - $resarray[$array_key.'_project_date_end'] = dol_print_date($object->project->date_end, 'day'); |
|
470 | - } |
|
471 | - |
|
472 | - // Add vat by rates |
|
473 | - if (is_array($object->lines) && count($object->lines)>0) |
|
474 | - { |
|
475 | - foreach ($object->lines as $line) |
|
476 | - { |
|
477 | - // $line->tva_tx format depends on database field accuraty, no reliable. This is kept for backward comaptibility |
|
478 | - if (empty($resarray[$array_key.'_total_vat_'.$line->tva_tx])) $resarray[$array_key.'_total_vat_'.$line->tva_tx]=0; |
|
479 | - $resarray[$array_key.'_total_vat_'.$line->tva_tx]+=$line->total_tva; |
|
480 | - $resarray[$array_key.'_total_vat_locale_'.$line->tva_tx]=price($resarray[$array_key.'_total_vat_'.$line->tva_tx]); |
|
481 | - // $vatformated is vat without not expected chars (so 20, or 8.5 or 5.99 for example) |
|
482 | - $vatformated=vatrate($line->tva_tx); |
|
483 | - if (empty($resarray[$array_key.'_total_vat_'.$vatformated])) $resarray[$array_key.'_total_vat_'.$vatformated]=0; |
|
484 | - $resarray[$array_key.'_total_vat_'.$vatformated]+=$line->total_tva; |
|
485 | - $resarray[$array_key.'_total_vat_locale_'.$vatformated]=price($resarray[$array_key.'_total_vat_'.$vatformated]); |
|
486 | - } |
|
487 | - } |
|
488 | - // Retrieve extrafields |
|
489 | - if (is_array($object->array_options) && count($object->array_options)) |
|
490 | - { |
|
491 | - $extrafieldkey=$object->element; |
|
492 | - |
|
493 | - require_once DOL_DOCUMENT_ROOT.'/core/class/extrafields.class.php'; |
|
494 | - $extrafields = new ExtraFields($this->db); |
|
495 | - $extralabels = $extrafields->fetch_name_optionals_label($extrafieldkey,true); |
|
496 | - $object->fetch_optionals(); |
|
497 | - |
|
498 | - $resarray = $this->fill_substitutionarray_with_extrafields($object,$resarray,$extrafields,$array_key,$outputlangs); |
|
499 | - } |
|
500 | - return $resarray; |
|
501 | - } |
|
393 | + $array_key.'_date'=>dol_print_date($date,'day'), |
|
394 | + $array_key.'_date_rfc'=>dol_print_date($date,'dayrfc'), |
|
395 | + $array_key.'_date_limit'=>(! empty($object->date_lim_reglement)?dol_print_date($object->date_lim_reglement,'day'):''), |
|
396 | + $array_key.'_date_end'=>(! empty($object->fin_validite)?dol_print_date($object->fin_validite,'day'):''), |
|
397 | + $array_key.'_date_creation'=>dol_print_date($object->date_creation,'day'), |
|
398 | + $array_key.'_date_modification'=>(! empty($object->date_modification)?dol_print_date($object->date_modification,'day'):''), |
|
399 | + $array_key.'_date_validation'=>(! empty($object->date_validation)?dol_print_date($object->date_validation,'dayhour'):''), |
|
400 | + $array_key.'_date_delivery_planed'=>(! empty($object->date_livraison)?dol_print_date($object->date_livraison,'day'):''), |
|
401 | + $array_key.'_date_close'=>(! empty($object->date_cloture)?dol_print_date($object->date_cloture,'dayhour'):''), |
|
402 | + |
|
403 | + $array_key.'_payment_mode_code'=>$object->mode_reglement_code, |
|
404 | + $array_key.'_payment_mode'=>($outputlangs->transnoentitiesnoconv('PaymentType'.$object->mode_reglement_code)!='PaymentType'.$object->mode_reglement_code?$outputlangs->transnoentitiesnoconv('PaymentType'.$object->mode_reglement_code):$object->mode_reglement), |
|
405 | + $array_key.'_payment_term_code'=>$object->cond_reglement_code, |
|
406 | + $array_key.'_payment_term'=>($outputlangs->transnoentitiesnoconv('PaymentCondition'.$object->cond_reglement_code)!='PaymentCondition'.$object->cond_reglement_code?$outputlangs->transnoentitiesnoconv('PaymentCondition'.$object->cond_reglement_code):($object->cond_reglement_doc?$object->cond_reglement_doc:$object->cond_reglement)), |
|
407 | + |
|
408 | + $array_key.'_total_ht_locale'=>price($object->total_ht, 0, $outputlangs), |
|
409 | + $array_key.'_total_vat_locale'=>(! empty($object->total_vat)?price($object->total_vat, 0, $outputlangs):price($object->total_tva, 0, $outputlangs)), |
|
410 | + $array_key.'_total_localtax1_locale'=>price($object->total_localtax1, 0, $outputlangs), |
|
411 | + $array_key.'_total_localtax2_locale'=>price($object->total_localtax2, 0, $outputlangs), |
|
412 | + $array_key.'_total_ttc_locale'=>price($object->total_ttc, 0, $outputlangs), |
|
413 | + |
|
414 | + $array_key.'_total_ht'=>price2num($object->total_ht), |
|
415 | + $array_key.'_total_vat'=>(! empty($object->total_vat)?price2num($object->total_vat):price2num($object->total_tva)), |
|
416 | + $array_key.'_total_localtax1'=>price2num($object->total_localtax1), |
|
417 | + $array_key.'_total_localtax2'=>price2num($object->total_localtax2), |
|
418 | + $array_key.'_total_ttc'=>price2num($object->total_ttc), |
|
419 | + |
|
420 | + $array_key.'_multicurrency_code' => price2num($object->multicurrency_code), |
|
421 | + $array_key.'_multicurrency_tx' => price2num($object->multicurrency_tx), |
|
422 | + $array_key.'_multicurrency_total_ht' => price2num($object->multicurrency_total_ht), |
|
423 | + $array_key.'_multicurrency_total_tva' => price2num($object->multicurrency_total_tva), |
|
424 | + $array_key.'_multicurrency_total_ttc' => price2num($object->multicurrency_total_ttc), |
|
425 | + $array_key.'_multicurrency_total_ht_locale' => price($object->multicurrency_total_ht, 0, $outputlangs), |
|
426 | + $array_key.'_multicurrency_total_tva_locale' => price($object->multicurrency_total_tva, 0, $outputlangs), |
|
427 | + $array_key.'_multicurrency_total_ttc_locale' => price($object->multicurrency_total_ttc, 0, $outputlangs), |
|
428 | + |
|
429 | + $array_key.'_note_private'=>$object->note, |
|
430 | + $array_key.'_note_public'=>$object->note_public, |
|
431 | + $array_key.'_note'=>$object->note_public, // For backward compatibility |
|
432 | + |
|
433 | + // Payments |
|
434 | + $array_key.'_already_payed_locale'=>price($sumpayed, 0, $outputlangs), |
|
435 | + $array_key.'_already_payed'=>price2num($sumpayed), |
|
436 | + $array_key.'_already_deposit_locale'=>price($sumdeposit, 0, $outputlangs), |
|
437 | + $array_key.'_already_deposit'=>price2num($sumdeposit), |
|
438 | + $array_key.'_already_creditnote_locale'=>price($sumcreditnote, 0, $outputlangs), |
|
439 | + $array_key.'_already_creditnote'=>price2num($sumcreditnote), |
|
440 | + |
|
441 | + $array_key.'_already_payed_all_locale'=>price(price2num($sumpayed + $sumdeposit + $sumcreditnote, 'MT'), 0, $outputlangs), |
|
442 | + $array_key.'_already_payed_all'=> price2num(($sumpayed + $sumdeposit + $sumcreditnote), 'MT'), |
|
443 | + |
|
444 | + // Remain to pay with all know infrmation (except open direct debit requests) |
|
445 | + $array_key.'_remain_to_pay_locale'=>price(price2num($object->total_ttc - $sumpayed - $sumdeposit - $sumcreditnote, 'MT'), 0, $outputlangs), |
|
446 | + $array_key.'_remain_to_pay'=>price2num($object->total_ttc - $sumpayed - $sumdeposit - $sumcreditnote, 'MT') |
|
447 | + ); |
|
448 | + |
|
449 | + if (method_exists($object, 'getTotalDiscount')) { |
|
450 | + $resarray[$array_key.'_total_discount_ht_locale'] = price($object->getTotalDiscount(), 0, $outputlangs); |
|
451 | + $resarray[$array_key.'_total_discount_ht'] = price2num($object->getTotalDiscount()); |
|
452 | + } else { |
|
453 | + $resarray[$array_key.'_total_discount_ht_locale'] = ''; |
|
454 | + $resarray[$array_key.'_total_discount_ht'] = ''; |
|
455 | + } |
|
456 | + |
|
457 | + // Fetch project information if there is a project assigned to this object |
|
458 | + if ($object->element != "project" && ! empty($object->fk_project) && $object->fk_project > 0) |
|
459 | + { |
|
460 | + if (! is_object($object->project)) |
|
461 | + { |
|
462 | + $object->fetch_projet(); |
|
463 | + } |
|
464 | + |
|
465 | + $resarray[$array_key.'_project_ref'] = $object->project->ref; |
|
466 | + $resarray[$array_key.'_project_title'] = $object->project->title; |
|
467 | + $resarray[$array_key.'_project_description'] = $object->project->description; |
|
468 | + $resarray[$array_key.'_project_date_start'] = dol_print_date($object->project->date_start, 'day'); |
|
469 | + $resarray[$array_key.'_project_date_end'] = dol_print_date($object->project->date_end, 'day'); |
|
470 | + } |
|
471 | + |
|
472 | + // Add vat by rates |
|
473 | + if (is_array($object->lines) && count($object->lines)>0) |
|
474 | + { |
|
475 | + foreach ($object->lines as $line) |
|
476 | + { |
|
477 | + // $line->tva_tx format depends on database field accuraty, no reliable. This is kept for backward comaptibility |
|
478 | + if (empty($resarray[$array_key.'_total_vat_'.$line->tva_tx])) $resarray[$array_key.'_total_vat_'.$line->tva_tx]=0; |
|
479 | + $resarray[$array_key.'_total_vat_'.$line->tva_tx]+=$line->total_tva; |
|
480 | + $resarray[$array_key.'_total_vat_locale_'.$line->tva_tx]=price($resarray[$array_key.'_total_vat_'.$line->tva_tx]); |
|
481 | + // $vatformated is vat without not expected chars (so 20, or 8.5 or 5.99 for example) |
|
482 | + $vatformated=vatrate($line->tva_tx); |
|
483 | + if (empty($resarray[$array_key.'_total_vat_'.$vatformated])) $resarray[$array_key.'_total_vat_'.$vatformated]=0; |
|
484 | + $resarray[$array_key.'_total_vat_'.$vatformated]+=$line->total_tva; |
|
485 | + $resarray[$array_key.'_total_vat_locale_'.$vatformated]=price($resarray[$array_key.'_total_vat_'.$vatformated]); |
|
486 | + } |
|
487 | + } |
|
488 | + // Retrieve extrafields |
|
489 | + if (is_array($object->array_options) && count($object->array_options)) |
|
490 | + { |
|
491 | + $extrafieldkey=$object->element; |
|
492 | + |
|
493 | + require_once DOL_DOCUMENT_ROOT.'/core/class/extrafields.class.php'; |
|
494 | + $extrafields = new ExtraFields($this->db); |
|
495 | + $extralabels = $extrafields->fetch_name_optionals_label($extrafieldkey,true); |
|
496 | + $object->fetch_optionals(); |
|
497 | + |
|
498 | + $resarray = $this->fill_substitutionarray_with_extrafields($object,$resarray,$extrafields,$array_key,$outputlangs); |
|
499 | + } |
|
500 | + return $resarray; |
|
501 | + } |
|
502 | 502 | |
503 | 503 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
504 | - /** |
|
505 | - * Define array with couple substitution key => substitution value |
|
506 | - * |
|
507 | - * @param Object $line Object line |
|
508 | - * @param Translate $outputlangs Lang object to use for output |
|
509 | - * @return array Return a substitution array |
|
510 | - */ |
|
511 | - function get_substitutionarray_lines($line, $outputlangs) |
|
512 | - { |
|
504 | + /** |
|
505 | + * Define array with couple substitution key => substitution value |
|
506 | + * |
|
507 | + * @param Object $line Object line |
|
508 | + * @param Translate $outputlangs Lang object to use for output |
|
509 | + * @return array Return a substitution array |
|
510 | + */ |
|
511 | + function get_substitutionarray_lines($line, $outputlangs) |
|
512 | + { |
|
513 | 513 | // phpcs:enable |
514 | - global $conf; |
|
515 | - |
|
516 | - $resarray= array( |
|
517 | - 'line_fulldesc'=>doc_getlinedesc($line,$outputlangs), |
|
518 | - 'line_product_ref'=>$line->product_ref, |
|
519 | - 'line_product_ref_fourn'=>$line->ref_fourn, // for supplier doc lines |
|
520 | - 'line_product_label'=>$line->product_label, |
|
521 | - 'line_product_type'=>$line->product_type, |
|
522 | - 'line_desc'=>$line->desc, |
|
523 | - 'line_vatrate'=>vatrate($line->tva_tx,true,$line->info_bits), |
|
524 | - 'line_up'=>price2num($line->subprice), |
|
525 | - 'line_up_locale'=>price($line->subprice, 0, $outputlangs), |
|
526 | - 'line_qty'=>$line->qty, |
|
527 | - 'line_discount_percent'=>($line->remise_percent?$line->remise_percent.'%':''), |
|
528 | - 'line_price_ht'=>price2num($line->total_ht), |
|
529 | - 'line_price_ttc'=>price2num($line->total_ttc), |
|
530 | - 'line_price_vat'=>price2num($line->total_tva), |
|
531 | - 'line_price_ht_locale'=>price($line->total_ht, 0, $outputlangs), |
|
532 | - 'line_price_ttc_locale'=>price($line->total_ttc, 0, $outputlangs), |
|
533 | - 'line_price_vat_locale'=>price($line->total_tva, 0, $outputlangs), |
|
534 | - // Dates |
|
535 | - 'line_date_start'=>dol_print_date($line->date_start, 'day', 'tzuser'), |
|
536 | - 'line_date_start_locale'=>dol_print_date($line->date_start, 'day', 'tzuser', $outputlangs), |
|
537 | - 'line_date_start_rfc'=>dol_print_date($line->date_start, 'dayrfc', 'tzuser'), |
|
538 | - 'line_date_end'=>dol_print_date($line->date_end, 'day', 'tzuser'), |
|
539 | - 'line_date_end_locale'=>dol_print_date($line->date_end, 'day', 'tzuser', $outputlangs), |
|
540 | - 'line_date_end_rfc'=>dol_print_date($line->date_end, 'dayrfc', 'tzuser'), |
|
541 | - |
|
542 | - 'line_multicurrency_code' => price2num($line->multicurrency_code), |
|
543 | - 'line_multicurrency_subprice' => price2num($line->multicurrency_subprice), |
|
544 | - 'line_multicurrency_total_ht' => price2num($line->multicurrency_total_ht), |
|
545 | - 'line_multicurrency_total_tva' => price2num($line->multicurrency_total_tva), |
|
546 | - 'line_multicurrency_total_ttc' => price2num($line->multicurrency_total_ttc), |
|
547 | - 'line_multicurrency_subprice_locale' => price($line->multicurrency_subprice, 0, $outputlangs), |
|
548 | - 'line_multicurrency_total_ht_locale' => price($line->multicurrency_total_ht, 0, $outputlangs), |
|
549 | - 'line_multicurrency_total_tva_locale' => price($line->multicurrency_total_tva, 0, $outputlangs), |
|
550 | - 'line_multicurrency_total_ttc_locale' => price($line->multicurrency_total_ttc, 0, $outputlangs), |
|
551 | - ); |
|
552 | - |
|
553 | - // Units |
|
554 | - if ($conf->global->PRODUCT_USE_UNITS) |
|
555 | - { |
|
556 | - $resarray['line_unit']=$outputlangs->trans($line->getLabelOfUnit('long')); |
|
557 | - $resarray['line_unit_short']=$outputlangs->trans($line->getLabelOfUnit('short')); |
|
558 | - } |
|
559 | - |
|
560 | - // Retrieve extrafields |
|
561 | - $extrafieldkey=$line->element; |
|
562 | - $array_key="line"; |
|
563 | - require_once DOL_DOCUMENT_ROOT.'/core/class/extrafields.class.php'; |
|
564 | - $extrafields = new ExtraFields($this->db); |
|
565 | - $extralabels = $extrafields->fetch_name_optionals_label($extrafieldkey,true); |
|
566 | - $line->fetch_optionals(); |
|
567 | - |
|
568 | - $resarray = $this->fill_substitutionarray_with_extrafields($line,$resarray,$extrafields,$array_key=$array_key,$outputlangs); |
|
569 | - |
|
570 | - // Load product data optional fields to the line -> enables to use "line_options_{extrafield}" |
|
571 | - if (isset($line->fk_product) && $line->fk_product > 0) |
|
572 | - { |
|
573 | - $tmpproduct = new Product($this->db); |
|
574 | - $result = $tmpproduct->fetch($line->fk_product); |
|
575 | - foreach($tmpproduct->array_options as $key=>$label) |
|
576 | - $resarray["line_product_".$key] = $label; |
|
577 | - } |
|
578 | - |
|
579 | - return $resarray; |
|
580 | - } |
|
514 | + global $conf; |
|
515 | + |
|
516 | + $resarray= array( |
|
517 | + 'line_fulldesc'=>doc_getlinedesc($line,$outputlangs), |
|
518 | + 'line_product_ref'=>$line->product_ref, |
|
519 | + 'line_product_ref_fourn'=>$line->ref_fourn, // for supplier doc lines |
|
520 | + 'line_product_label'=>$line->product_label, |
|
521 | + 'line_product_type'=>$line->product_type, |
|
522 | + 'line_desc'=>$line->desc, |
|
523 | + 'line_vatrate'=>vatrate($line->tva_tx,true,$line->info_bits), |
|
524 | + 'line_up'=>price2num($line->subprice), |
|
525 | + 'line_up_locale'=>price($line->subprice, 0, $outputlangs), |
|
526 | + 'line_qty'=>$line->qty, |
|
527 | + 'line_discount_percent'=>($line->remise_percent?$line->remise_percent.'%':''), |
|
528 | + 'line_price_ht'=>price2num($line->total_ht), |
|
529 | + 'line_price_ttc'=>price2num($line->total_ttc), |
|
530 | + 'line_price_vat'=>price2num($line->total_tva), |
|
531 | + 'line_price_ht_locale'=>price($line->total_ht, 0, $outputlangs), |
|
532 | + 'line_price_ttc_locale'=>price($line->total_ttc, 0, $outputlangs), |
|
533 | + 'line_price_vat_locale'=>price($line->total_tva, 0, $outputlangs), |
|
534 | + // Dates |
|
535 | + 'line_date_start'=>dol_print_date($line->date_start, 'day', 'tzuser'), |
|
536 | + 'line_date_start_locale'=>dol_print_date($line->date_start, 'day', 'tzuser', $outputlangs), |
|
537 | + 'line_date_start_rfc'=>dol_print_date($line->date_start, 'dayrfc', 'tzuser'), |
|
538 | + 'line_date_end'=>dol_print_date($line->date_end, 'day', 'tzuser'), |
|
539 | + 'line_date_end_locale'=>dol_print_date($line->date_end, 'day', 'tzuser', $outputlangs), |
|
540 | + 'line_date_end_rfc'=>dol_print_date($line->date_end, 'dayrfc', 'tzuser'), |
|
541 | + |
|
542 | + 'line_multicurrency_code' => price2num($line->multicurrency_code), |
|
543 | + 'line_multicurrency_subprice' => price2num($line->multicurrency_subprice), |
|
544 | + 'line_multicurrency_total_ht' => price2num($line->multicurrency_total_ht), |
|
545 | + 'line_multicurrency_total_tva' => price2num($line->multicurrency_total_tva), |
|
546 | + 'line_multicurrency_total_ttc' => price2num($line->multicurrency_total_ttc), |
|
547 | + 'line_multicurrency_subprice_locale' => price($line->multicurrency_subprice, 0, $outputlangs), |
|
548 | + 'line_multicurrency_total_ht_locale' => price($line->multicurrency_total_ht, 0, $outputlangs), |
|
549 | + 'line_multicurrency_total_tva_locale' => price($line->multicurrency_total_tva, 0, $outputlangs), |
|
550 | + 'line_multicurrency_total_ttc_locale' => price($line->multicurrency_total_ttc, 0, $outputlangs), |
|
551 | + ); |
|
552 | + |
|
553 | + // Units |
|
554 | + if ($conf->global->PRODUCT_USE_UNITS) |
|
555 | + { |
|
556 | + $resarray['line_unit']=$outputlangs->trans($line->getLabelOfUnit('long')); |
|
557 | + $resarray['line_unit_short']=$outputlangs->trans($line->getLabelOfUnit('short')); |
|
558 | + } |
|
559 | + |
|
560 | + // Retrieve extrafields |
|
561 | + $extrafieldkey=$line->element; |
|
562 | + $array_key="line"; |
|
563 | + require_once DOL_DOCUMENT_ROOT.'/core/class/extrafields.class.php'; |
|
564 | + $extrafields = new ExtraFields($this->db); |
|
565 | + $extralabels = $extrafields->fetch_name_optionals_label($extrafieldkey,true); |
|
566 | + $line->fetch_optionals(); |
|
567 | + |
|
568 | + $resarray = $this->fill_substitutionarray_with_extrafields($line,$resarray,$extrafields,$array_key=$array_key,$outputlangs); |
|
569 | + |
|
570 | + // Load product data optional fields to the line -> enables to use "line_options_{extrafield}" |
|
571 | + if (isset($line->fk_product) && $line->fk_product > 0) |
|
572 | + { |
|
573 | + $tmpproduct = new Product($this->db); |
|
574 | + $result = $tmpproduct->fetch($line->fk_product); |
|
575 | + foreach($tmpproduct->array_options as $key=>$label) |
|
576 | + $resarray["line_product_".$key] = $label; |
|
577 | + } |
|
578 | + |
|
579 | + return $resarray; |
|
580 | + } |
|
581 | 581 | |
582 | 582 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
583 | 583 | /** |
@@ -591,54 +591,54 @@ discard block |
||
591 | 591 | function get_substitutionarray_shipment($object,$outputlangs,$array_key='object') |
592 | 592 | { |
593 | 593 | // phpcs:enable |
594 | - global $conf; |
|
595 | - dol_include_once('/core/lib/product.lib.php'); |
|
596 | - $object->list_delivery_methods($object->shipping_method_id); |
|
597 | - $calculatedVolume=($object->trueWidth * $object->trueHeight * $object->trueDepth); |
|
598 | - |
|
599 | - $array_shipment=array( |
|
600 | - $array_key.'_id'=>$object->id, |
|
601 | - $array_key.'_ref'=>$object->ref, |
|
602 | - $array_key.'_ref_ext'=>$object->ref_ext, |
|
603 | - $array_key.'_ref_customer'=>$object->ref_customer, |
|
604 | - $array_key.'_date_delivery'=>dol_print_date($object->date_delivery,'day'), |
|
605 | - $array_key.'_hour_delivery'=>dol_print_date($object->date_delivery,'hour'), |
|
606 | - $array_key.'_date_creation'=>dol_print_date($object->date_creation,'day'), |
|
607 | - $array_key.'_total_ht'=>price($object->total_ht), |
|
608 | - $array_key.'_total_vat'=>price($object->total_tva), |
|
609 | - $array_key.'_total_ttc'=>price($object->total_ttc), |
|
610 | - $array_key.'_total_discount_ht' => price($object->getTotalDiscount()), |
|
611 | - $array_key.'_note_private'=>$object->note_private, |
|
612 | - $array_key.'_note'=>$object->note_public, |
|
613 | - $array_key.'_tracking_number'=>$object->tracking_number, |
|
614 | - $array_key.'_tracking_url'=>$object->tracking_url, |
|
615 | - $array_key.'_shipping_method'=>$object->listmeths[0]['libelle'], |
|
616 | - $array_key.'_weight'=>$object->trueWeight.' '.measuring_units_string($object->weight_units, 'weight'), |
|
617 | - $array_key.'_width'=>$object->trueWidth.' '.measuring_units_string($object->width_units, 'size'), |
|
618 | - $array_key.'_height'=>$object->trueHeight.' '.measuring_units_string($object->height_units, 'size'), |
|
619 | - $array_key.'_depth'=>$object->trueDepth.' '.measuring_units_string($object->depth_units, 'size'), |
|
620 | - $array_key.'_size'=>$calculatedVolume.' '.measuring_units_string(0, 'volume'), |
|
621 | - ); |
|
622 | - |
|
623 | - // Add vat by rates |
|
624 | - foreach ($object->lines as $line) |
|
625 | - { |
|
626 | - if (empty($array_shipment[$array_key.'_total_vat_'.$line->tva_tx])) $array_shipment[$array_key.'_total_vat_'.$line->tva_tx]=0; |
|
627 | - $array_shipment[$array_key.'_total_vat_'.$line->tva_tx]+=$line->total_tva; |
|
628 | - } |
|
629 | - |
|
630 | - // Retrieve extrafields |
|
631 | - if (is_array($object->array_options) && count($object->array_options)) |
|
632 | - { |
|
633 | - require_once DOL_DOCUMENT_ROOT.'/core/class/extrafields.class.php'; |
|
634 | - $extrafields = new ExtraFields($this->db); |
|
635 | - $extralabels = $extrafields->fetch_name_optionals_label('expedition',true); |
|
636 | - $object->fetch_optionals(); |
|
637 | - |
|
638 | - $array_shipment = $this->fill_substitutionarray_with_extrafields($object,$array_shipment,$extrafields,$array_key,$outputlangs); |
|
639 | - } |
|
640 | - |
|
641 | - return $array_shipment; |
|
594 | + global $conf; |
|
595 | + dol_include_once('/core/lib/product.lib.php'); |
|
596 | + $object->list_delivery_methods($object->shipping_method_id); |
|
597 | + $calculatedVolume=($object->trueWidth * $object->trueHeight * $object->trueDepth); |
|
598 | + |
|
599 | + $array_shipment=array( |
|
600 | + $array_key.'_id'=>$object->id, |
|
601 | + $array_key.'_ref'=>$object->ref, |
|
602 | + $array_key.'_ref_ext'=>$object->ref_ext, |
|
603 | + $array_key.'_ref_customer'=>$object->ref_customer, |
|
604 | + $array_key.'_date_delivery'=>dol_print_date($object->date_delivery,'day'), |
|
605 | + $array_key.'_hour_delivery'=>dol_print_date($object->date_delivery,'hour'), |
|
606 | + $array_key.'_date_creation'=>dol_print_date($object->date_creation,'day'), |
|
607 | + $array_key.'_total_ht'=>price($object->total_ht), |
|
608 | + $array_key.'_total_vat'=>price($object->total_tva), |
|
609 | + $array_key.'_total_ttc'=>price($object->total_ttc), |
|
610 | + $array_key.'_total_discount_ht' => price($object->getTotalDiscount()), |
|
611 | + $array_key.'_note_private'=>$object->note_private, |
|
612 | + $array_key.'_note'=>$object->note_public, |
|
613 | + $array_key.'_tracking_number'=>$object->tracking_number, |
|
614 | + $array_key.'_tracking_url'=>$object->tracking_url, |
|
615 | + $array_key.'_shipping_method'=>$object->listmeths[0]['libelle'], |
|
616 | + $array_key.'_weight'=>$object->trueWeight.' '.measuring_units_string($object->weight_units, 'weight'), |
|
617 | + $array_key.'_width'=>$object->trueWidth.' '.measuring_units_string($object->width_units, 'size'), |
|
618 | + $array_key.'_height'=>$object->trueHeight.' '.measuring_units_string($object->height_units, 'size'), |
|
619 | + $array_key.'_depth'=>$object->trueDepth.' '.measuring_units_string($object->depth_units, 'size'), |
|
620 | + $array_key.'_size'=>$calculatedVolume.' '.measuring_units_string(0, 'volume'), |
|
621 | + ); |
|
622 | + |
|
623 | + // Add vat by rates |
|
624 | + foreach ($object->lines as $line) |
|
625 | + { |
|
626 | + if (empty($array_shipment[$array_key.'_total_vat_'.$line->tva_tx])) $array_shipment[$array_key.'_total_vat_'.$line->tva_tx]=0; |
|
627 | + $array_shipment[$array_key.'_total_vat_'.$line->tva_tx]+=$line->total_tva; |
|
628 | + } |
|
629 | + |
|
630 | + // Retrieve extrafields |
|
631 | + if (is_array($object->array_options) && count($object->array_options)) |
|
632 | + { |
|
633 | + require_once DOL_DOCUMENT_ROOT.'/core/class/extrafields.class.php'; |
|
634 | + $extrafields = new ExtraFields($this->db); |
|
635 | + $extralabels = $extrafields->fetch_name_optionals_label('expedition',true); |
|
636 | + $object->fetch_optionals(); |
|
637 | + |
|
638 | + $array_shipment = $this->fill_substitutionarray_with_extrafields($object,$array_shipment,$extrafields,$array_key,$outputlangs); |
|
639 | + } |
|
640 | + |
|
641 | + return $array_shipment; |
|
642 | 642 | } |
643 | 643 | |
644 | 644 | |
@@ -657,24 +657,24 @@ discard block |
||
657 | 657 | dol_include_once('/core/lib/product.lib.php'); |
658 | 658 | |
659 | 659 | $resarray = array( |
660 | - 'line_fulldesc'=>doc_getlinedesc($line,$outputlangs), |
|
661 | - 'line_product_ref'=>$line->product_ref, |
|
662 | - 'line_product_label'=>$line->product_label, |
|
663 | - 'line_desc'=>$line->desc, |
|
664 | - 'line_vatrate'=>vatrate($line->tva_tx,true,$line->info_bits), |
|
665 | - 'line_up'=>price($line->subprice), |
|
666 | - 'line_qty'=>$line->qty, |
|
667 | - 'line_qty_shipped'=>$line->qty_shipped, |
|
668 | - 'line_qty_asked'=>$line->qty_asked, |
|
669 | - 'line_discount_percent'=>($line->remise_percent?$line->remise_percent.'%':''), |
|
670 | - 'line_price_ht'=>price($line->total_ht), |
|
671 | - 'line_price_ttc'=>price($line->total_ttc), |
|
672 | - 'line_price_vat'=>price($line->total_tva), |
|
673 | - 'line_weight'=>empty($line->weight) ? '' : $line->weight*$line->qty_shipped.' '.measuring_units_string($line->weight_units, 'weight'), |
|
674 | - 'line_length'=>empty($line->length) ? '' : $line->length*$line->qty_shipped.' '.measuring_units_string($line->length_units, 'size'), |
|
675 | - 'line_surface'=>empty($line->surface) ? '' : $line->surface*$line->qty_shipped.' '.measuring_units_string($line->surface_units, 'surface'), |
|
676 | - 'line_volume'=>empty($line->volume) ? '' : $line->volume*$line->qty_shipped.' '.measuring_units_string($line->volume_units, 'volume'), |
|
677 | - ); |
|
660 | + 'line_fulldesc'=>doc_getlinedesc($line,$outputlangs), |
|
661 | + 'line_product_ref'=>$line->product_ref, |
|
662 | + 'line_product_label'=>$line->product_label, |
|
663 | + 'line_desc'=>$line->desc, |
|
664 | + 'line_vatrate'=>vatrate($line->tva_tx,true,$line->info_bits), |
|
665 | + 'line_up'=>price($line->subprice), |
|
666 | + 'line_qty'=>$line->qty, |
|
667 | + 'line_qty_shipped'=>$line->qty_shipped, |
|
668 | + 'line_qty_asked'=>$line->qty_asked, |
|
669 | + 'line_discount_percent'=>($line->remise_percent?$line->remise_percent.'%':''), |
|
670 | + 'line_price_ht'=>price($line->total_ht), |
|
671 | + 'line_price_ttc'=>price($line->total_ttc), |
|
672 | + 'line_price_vat'=>price($line->total_tva), |
|
673 | + 'line_weight'=>empty($line->weight) ? '' : $line->weight*$line->qty_shipped.' '.measuring_units_string($line->weight_units, 'weight'), |
|
674 | + 'line_length'=>empty($line->length) ? '' : $line->length*$line->qty_shipped.' '.measuring_units_string($line->length_units, 'size'), |
|
675 | + 'line_surface'=>empty($line->surface) ? '' : $line->surface*$line->qty_shipped.' '.measuring_units_string($line->surface_units, 'surface'), |
|
676 | + 'line_volume'=>empty($line->volume) ? '' : $line->volume*$line->qty_shipped.' '.measuring_units_string($line->volume_units, 'volume'), |
|
677 | + ); |
|
678 | 678 | |
679 | 679 | // Retrieve extrafields |
680 | 680 | $extrafieldkey = $line->element; |
@@ -731,92 +731,92 @@ discard block |
||
731 | 731 | * @return array Substitution array |
732 | 732 | */ |
733 | 733 | function fill_substitutionarray_with_extrafields($object,$array_to_fill,$extrafields,$array_key,$outputlangs) |
734 | - { |
|
734 | + { |
|
735 | 735 | // phpcs:enable |
736 | - global $conf; |
|
737 | - foreach($extrafields->attribute_label as $key=>$label) |
|
738 | - { |
|
739 | - if($extrafields->attribute_type[$key] == 'price') |
|
740 | - { |
|
741 | - $object->array_options['options_'.$key] = price2num($object->array_options['options_'.$key]); |
|
742 | - $object->array_options['options_'.$key.'_currency'] = price($object->array_options['options_'.$key],0,$outputlangs,0,0,-1,$conf->currency); |
|
743 | - //Add value to store price with currency |
|
744 | - $array_to_fill=array_merge($array_to_fill,array($array_key.'_options_'.$key.'_currency' => $object->array_options['options_'.$key.'_currency'])); |
|
745 | - } |
|
746 | - else if($extrafields->attribute_type[$key] == 'select' || $extrafields->attribute_type[$key] == 'checkbox') |
|
747 | - { |
|
748 | - $object->array_options['options_'.$key] = $extrafields->attribute_param[$key]['options'][$object->array_options['options_'.$key]]; |
|
749 | - } |
|
750 | - else if($extrafields->attribute_type[$key] == 'date') |
|
751 | - { |
|
752 | - if (strlen($object->array_options['options_'.$key])>0) |
|
753 | - { |
|
754 | - $date = $object->array_options['options_'.$key]; |
|
755 | - $object->array_options['options_'.$key] = dol_print_date($date,'day'); // using company output language |
|
756 | - $object->array_options['options_'.$key.'_locale'] = dol_print_date($date,'day','tzserver',$outputlangs); // using output language format |
|
757 | - $object->array_options['options_'.$key.'_rfc'] = dol_print_date($date,'dayrfc'); // international format |
|
758 | - } |
|
759 | - else |
|
760 | - { |
|
761 | - $object->array_options['options_'.$key] = ''; |
|
762 | - $object->array_options['options_'.$key.'_locale'] = ''; |
|
763 | - $object->array_options['options_'.$key.'_rfc'] = ''; |
|
764 | - } |
|
765 | - $array_to_fill=array_merge($array_to_fill,array($array_key.'_options_'.$key.'_locale' => $object->array_options['options_'.$key.'_locale'])); |
|
766 | - $array_to_fill=array_merge($array_to_fill,array($array_key.'_options_'.$key.'_rfc' => $object->array_options['options_'.$key.'_rfc'])); |
|
767 | - } |
|
768 | - else if($extrafields->attribute_type[$key] == 'datetime') |
|
769 | - { |
|
770 | - $datetime = $object->array_options['options_'.$key]; |
|
771 | - $object->array_options['options_'.$key] = ($datetime!="0000-00-00 00:00:00"?dol_print_date($object->array_options['options_'.$key],'dayhour'):''); // using company output language |
|
772 | - $object->array_options['options_'.$key.'_locale'] = ($datetime!="0000-00-00 00:00:00"?dol_print_date($object->array_options['options_'.$key],'dayhour','tzserver',$outputlangs):''); // using output language format |
|
773 | - $object->array_options['options_'.$key.'_rfc'] = ($datetime!="0000-00-00 00:00:00"?dol_print_date($object->array_options['options_'.$key],'dayhourrfc'):''); // international format |
|
774 | - $array_to_fill=array_merge($array_to_fill,array($array_key.'_options_'.$key.'_locale' => $object->array_options['options_'.$key.'_locale'])); |
|
775 | - $array_to_fill=array_merge($array_to_fill,array($array_key.'_options_'.$key.'_rfc' => $object->array_options['options_'.$key.'_rfc'])); |
|
776 | - } |
|
777 | - else if($extrafields->attribute_type[$key] == 'link') |
|
778 | - { |
|
779 | - $id = $object->array_options['options_'.$key]; |
|
780 | - if ($id != "") |
|
781 | - { |
|
782 | - $param = $extrafields->attribute_param[$key]; |
|
783 | - $param_list=array_keys($param['options']); // $param_list='ObjectName:classPath' |
|
784 | - $InfoFieldList = explode(":", $param_list[0]); |
|
785 | - $classname=$InfoFieldList[0]; |
|
786 | - $classpath=$InfoFieldList[1]; |
|
787 | - if (! empty($classpath)) |
|
788 | - { |
|
789 | - dol_include_once($InfoFieldList[1]); |
|
790 | - if ($classname && class_exists($classname)) |
|
791 | - { |
|
792 | - $tmpobject = new $classname($this->db); |
|
793 | - $tmpobject->fetch($id); |
|
794 | - // completely replace the id with the linked object name |
|
795 | - $object->array_options['options_'.$key] = $tmpobject->name; |
|
796 | - } |
|
797 | - } |
|
798 | - } |
|
799 | - } |
|
800 | - |
|
801 | - $array_to_fill=array_merge($array_to_fill,array($array_key.'_options_'.$key => $object->array_options['options_'.$key])); |
|
802 | - } |
|
803 | - |
|
804 | - return $array_to_fill; |
|
805 | - } |
|
806 | - |
|
807 | - |
|
808 | - /** |
|
809 | - * Rect pdf |
|
810 | - * |
|
811 | - * @param TCPDF $pdf Object PDF |
|
812 | - * @param float $x Abscissa of first point |
|
813 | - * @param float $y Ordinate of first point |
|
814 | - * @param float $l ?? |
|
815 | - * @param float $h ?? |
|
816 | - * @param int $hidetop 1=Hide top bar of array and title, 0=Hide nothing, -1=Hide only title |
|
817 | - * @param int $hidebottom Hide bottom |
|
818 | - * @return void |
|
819 | - */ |
|
736 | + global $conf; |
|
737 | + foreach($extrafields->attribute_label as $key=>$label) |
|
738 | + { |
|
739 | + if($extrafields->attribute_type[$key] == 'price') |
|
740 | + { |
|
741 | + $object->array_options['options_'.$key] = price2num($object->array_options['options_'.$key]); |
|
742 | + $object->array_options['options_'.$key.'_currency'] = price($object->array_options['options_'.$key],0,$outputlangs,0,0,-1,$conf->currency); |
|
743 | + //Add value to store price with currency |
|
744 | + $array_to_fill=array_merge($array_to_fill,array($array_key.'_options_'.$key.'_currency' => $object->array_options['options_'.$key.'_currency'])); |
|
745 | + } |
|
746 | + else if($extrafields->attribute_type[$key] == 'select' || $extrafields->attribute_type[$key] == 'checkbox') |
|
747 | + { |
|
748 | + $object->array_options['options_'.$key] = $extrafields->attribute_param[$key]['options'][$object->array_options['options_'.$key]]; |
|
749 | + } |
|
750 | + else if($extrafields->attribute_type[$key] == 'date') |
|
751 | + { |
|
752 | + if (strlen($object->array_options['options_'.$key])>0) |
|
753 | + { |
|
754 | + $date = $object->array_options['options_'.$key]; |
|
755 | + $object->array_options['options_'.$key] = dol_print_date($date,'day'); // using company output language |
|
756 | + $object->array_options['options_'.$key.'_locale'] = dol_print_date($date,'day','tzserver',$outputlangs); // using output language format |
|
757 | + $object->array_options['options_'.$key.'_rfc'] = dol_print_date($date,'dayrfc'); // international format |
|
758 | + } |
|
759 | + else |
|
760 | + { |
|
761 | + $object->array_options['options_'.$key] = ''; |
|
762 | + $object->array_options['options_'.$key.'_locale'] = ''; |
|
763 | + $object->array_options['options_'.$key.'_rfc'] = ''; |
|
764 | + } |
|
765 | + $array_to_fill=array_merge($array_to_fill,array($array_key.'_options_'.$key.'_locale' => $object->array_options['options_'.$key.'_locale'])); |
|
766 | + $array_to_fill=array_merge($array_to_fill,array($array_key.'_options_'.$key.'_rfc' => $object->array_options['options_'.$key.'_rfc'])); |
|
767 | + } |
|
768 | + else if($extrafields->attribute_type[$key] == 'datetime') |
|
769 | + { |
|
770 | + $datetime = $object->array_options['options_'.$key]; |
|
771 | + $object->array_options['options_'.$key] = ($datetime!="0000-00-00 00:00:00"?dol_print_date($object->array_options['options_'.$key],'dayhour'):''); // using company output language |
|
772 | + $object->array_options['options_'.$key.'_locale'] = ($datetime!="0000-00-00 00:00:00"?dol_print_date($object->array_options['options_'.$key],'dayhour','tzserver',$outputlangs):''); // using output language format |
|
773 | + $object->array_options['options_'.$key.'_rfc'] = ($datetime!="0000-00-00 00:00:00"?dol_print_date($object->array_options['options_'.$key],'dayhourrfc'):''); // international format |
|
774 | + $array_to_fill=array_merge($array_to_fill,array($array_key.'_options_'.$key.'_locale' => $object->array_options['options_'.$key.'_locale'])); |
|
775 | + $array_to_fill=array_merge($array_to_fill,array($array_key.'_options_'.$key.'_rfc' => $object->array_options['options_'.$key.'_rfc'])); |
|
776 | + } |
|
777 | + else if($extrafields->attribute_type[$key] == 'link') |
|
778 | + { |
|
779 | + $id = $object->array_options['options_'.$key]; |
|
780 | + if ($id != "") |
|
781 | + { |
|
782 | + $param = $extrafields->attribute_param[$key]; |
|
783 | + $param_list=array_keys($param['options']); // $param_list='ObjectName:classPath' |
|
784 | + $InfoFieldList = explode(":", $param_list[0]); |
|
785 | + $classname=$InfoFieldList[0]; |
|
786 | + $classpath=$InfoFieldList[1]; |
|
787 | + if (! empty($classpath)) |
|
788 | + { |
|
789 | + dol_include_once($InfoFieldList[1]); |
|
790 | + if ($classname && class_exists($classname)) |
|
791 | + { |
|
792 | + $tmpobject = new $classname($this->db); |
|
793 | + $tmpobject->fetch($id); |
|
794 | + // completely replace the id with the linked object name |
|
795 | + $object->array_options['options_'.$key] = $tmpobject->name; |
|
796 | + } |
|
797 | + } |
|
798 | + } |
|
799 | + } |
|
800 | + |
|
801 | + $array_to_fill=array_merge($array_to_fill,array($array_key.'_options_'.$key => $object->array_options['options_'.$key])); |
|
802 | + } |
|
803 | + |
|
804 | + return $array_to_fill; |
|
805 | + } |
|
806 | + |
|
807 | + |
|
808 | + /** |
|
809 | + * Rect pdf |
|
810 | + * |
|
811 | + * @param TCPDF $pdf Object PDF |
|
812 | + * @param float $x Abscissa of first point |
|
813 | + * @param float $y Ordinate of first point |
|
814 | + * @param float $l ?? |
|
815 | + * @param float $h ?? |
|
816 | + * @param int $hidetop 1=Hide top bar of array and title, 0=Hide nothing, -1=Hide only title |
|
817 | + * @param int $hidebottom Hide bottom |
|
818 | + * @return void |
|
819 | + */ |
|
820 | 820 | function printRect($pdf, $x, $y, $l, $h, $hidetop=0, $hidebottom=0) |
821 | 821 | { |
822 | 822 | if (empty($hidetop) || $hidetop==-1) $pdf->line($x, $y, $x+$l, $y); |
@@ -28,22 +28,22 @@ discard block |
||
28 | 28 | */ |
29 | 29 | class Canvas |
30 | 30 | { |
31 | - /** |
|
31 | + /** |
|
32 | 32 | * @var DoliDB Database handler. |
33 | 33 | */ |
34 | 34 | public $db; |
35 | 35 | |
36 | - /** |
|
37 | - * @var string Error code (or message) |
|
38 | - */ |
|
39 | - public $error=''; |
|
36 | + /** |
|
37 | + * @var string Error code (or message) |
|
38 | + */ |
|
39 | + public $error=''; |
|
40 | 40 | |
41 | - /** |
|
42 | - * @var string[] Error codes (or messages) |
|
43 | - */ |
|
44 | - public $errors = array(); |
|
41 | + /** |
|
42 | + * @var string[] Error codes (or messages) |
|
43 | + */ |
|
44 | + public $errors = array(); |
|
45 | 45 | |
46 | - public $actiontype; |
|
46 | + public $actiontype; |
|
47 | 47 | |
48 | 48 | public $dirmodule; // Module directory |
49 | 49 | public $targetmodule; // Module concerned by canvas (ex: thirdparty, contact, ...) |
@@ -54,65 +54,65 @@ discard block |
||
54 | 54 | public $control; // Initialized by getCanvas with controller instance |
55 | 55 | |
56 | 56 | |
57 | - /** |
|
58 | - * Constructor |
|
59 | - * |
|
60 | - * @param DoliDB $db Database handler |
|
61 | - * @param string $actiontype Action type ('create', 'view', 'edit', 'list') |
|
62 | - */ |
|
63 | - function __construct($db, $actiontype='view') |
|
64 | - { |
|
65 | - $this->db = $db; |
|
66 | - |
|
67 | - $this->actiontype = $this->_cleanaction($actiontype); |
|
68 | - } |
|
69 | - |
|
70 | - /** |
|
71 | - * Return action code cleaned |
|
72 | - * |
|
73 | - * @param string $action Action type ('create', 'view', 'edit', 'list', 'add', 'update') |
|
74 | - * @return string Cleaned action type ('create', 'view', 'edit', 'list') |
|
75 | - */ |
|
76 | - private function _cleanaction($action) |
|
77 | - { |
|
78 | - $newaction = $action; |
|
79 | - if ($newaction == 'add') $newaction='create'; |
|
80 | - if ($newaction == 'update') $newaction='edit'; |
|
81 | - if (empty($newaction) || $newaction == 'delete' || $newaction == 'create_user' || $newaction == 'presend' || $newaction == 'send') $newaction='view'; |
|
82 | - return $newaction; |
|
83 | - } |
|
84 | - |
|
85 | - |
|
86 | - /** |
|
87 | - * Initialize properties: ->targetmodule, ->canvas, ->card, ->dirmodule, ->template_dir |
|
88 | - * |
|
89 | - * @param string $module Name of target module (thirdparty, contact, ...) |
|
90 | - * @param string $card Tab name of card (ex: 'card', 'info', 'contactcard', ...) or '' for a list page |
|
91 | - * @param string $canvas Name of canvas (ex: mycanvas, default, or mycanvas@myexternalmodule) |
|
92 | - * @return void |
|
93 | - */ |
|
94 | - function getCanvas($module, $card, $canvas) |
|
95 | - { |
|
96 | - global $conf, $langs; |
|
97 | - |
|
98 | - // Set properties with value specific to dolibarr core: this->targetmodule, this->card, this->canvas |
|
57 | + /** |
|
58 | + * Constructor |
|
59 | + * |
|
60 | + * @param DoliDB $db Database handler |
|
61 | + * @param string $actiontype Action type ('create', 'view', 'edit', 'list') |
|
62 | + */ |
|
63 | + function __construct($db, $actiontype='view') |
|
64 | + { |
|
65 | + $this->db = $db; |
|
66 | + |
|
67 | + $this->actiontype = $this->_cleanaction($actiontype); |
|
68 | + } |
|
69 | + |
|
70 | + /** |
|
71 | + * Return action code cleaned |
|
72 | + * |
|
73 | + * @param string $action Action type ('create', 'view', 'edit', 'list', 'add', 'update') |
|
74 | + * @return string Cleaned action type ('create', 'view', 'edit', 'list') |
|
75 | + */ |
|
76 | + private function _cleanaction($action) |
|
77 | + { |
|
78 | + $newaction = $action; |
|
79 | + if ($newaction == 'add') $newaction='create'; |
|
80 | + if ($newaction == 'update') $newaction='edit'; |
|
81 | + if (empty($newaction) || $newaction == 'delete' || $newaction == 'create_user' || $newaction == 'presend' || $newaction == 'send') $newaction='view'; |
|
82 | + return $newaction; |
|
83 | + } |
|
84 | + |
|
85 | + |
|
86 | + /** |
|
87 | + * Initialize properties: ->targetmodule, ->canvas, ->card, ->dirmodule, ->template_dir |
|
88 | + * |
|
89 | + * @param string $module Name of target module (thirdparty, contact, ...) |
|
90 | + * @param string $card Tab name of card (ex: 'card', 'info', 'contactcard', ...) or '' for a list page |
|
91 | + * @param string $canvas Name of canvas (ex: mycanvas, default, or mycanvas@myexternalmodule) |
|
92 | + * @return void |
|
93 | + */ |
|
94 | + function getCanvas($module, $card, $canvas) |
|
95 | + { |
|
96 | + global $conf, $langs; |
|
97 | + |
|
98 | + // Set properties with value specific to dolibarr core: this->targetmodule, this->card, this->canvas |
|
99 | 99 | $this->targetmodule = $module; |
100 | 100 | $this->canvas = $canvas; |
101 | 101 | $this->card = $card; |
102 | 102 | $this->dirmodule = $module; |
103 | 103 | // Correct values if canvas is into an external module |
104 | - if (preg_match('/^([^@]+)@([^@]+)$/i',$canvas,$regs)) |
|
105 | - { |
|
104 | + if (preg_match('/^([^@]+)@([^@]+)$/i',$canvas,$regs)) |
|
105 | + { |
|
106 | 106 | $this->canvas = $regs[1]; |
107 | - $this->dirmodule = $regs[2]; |
|
108 | - } |
|
109 | - // For compatibility |
|
107 | + $this->dirmodule = $regs[2]; |
|
108 | + } |
|
109 | + // For compatibility |
|
110 | 110 | if ($this->dirmodule == 'thirdparty') { $this->dirmodule = 'societe'; } |
111 | 111 | |
112 | 112 | // Control file |
113 | - $controlclassfile = dol_buildpath('/'.$this->dirmodule.'/canvas/'.$this->canvas.'/actions_'.$this->card.'_'.$this->canvas.'.class.php'); |
|
114 | - if (file_exists($controlclassfile)) |
|
115 | - { |
|
113 | + $controlclassfile = dol_buildpath('/'.$this->dirmodule.'/canvas/'.$this->canvas.'/actions_'.$this->card.'_'.$this->canvas.'.class.php'); |
|
114 | + if (file_exists($controlclassfile)) |
|
115 | + { |
|
116 | 116 | // Include actions class (controller) |
117 | 117 | $this->control_file=$controlclassfile; |
118 | 118 | require_once $controlclassfile; |
@@ -120,10 +120,10 @@ discard block |
||
120 | 120 | // Instantiate actions class (controller) |
121 | 121 | $controlclassname = 'Actions'.ucfirst($this->card).ucfirst($this->canvas); |
122 | 122 | $this->control = new $controlclassname($this->db, $this->dirmodule, $this->targetmodule, $this->canvas, $this->card); |
123 | - } |
|
123 | + } |
|
124 | 124 | |
125 | - // Template dir |
|
126 | - $this->template_dir = dol_buildpath('/'.$this->dirmodule.'/canvas/'.$this->canvas.'/tpl/'); |
|
125 | + // Template dir |
|
126 | + $this->template_dir = dol_buildpath('/'.$this->dirmodule.'/canvas/'.$this->canvas.'/tpl/'); |
|
127 | 127 | if (! is_dir($this->template_dir)) |
128 | 128 | { |
129 | 129 | $this->template_dir=''; |
@@ -131,27 +131,27 @@ discard block |
||
131 | 131 | |
132 | 132 | //print 'dimodule='.$dirmodule.' canvas='.$this->canvas.'<br>'; |
133 | 133 | //print ' => template_dir='.$this->template_dir.'<br>'; |
134 | - } |
|
134 | + } |
|
135 | 135 | |
136 | 136 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
137 | 137 | /** |
138 | - * Shared method for canvas to assign values for templates |
|
139 | - * |
|
140 | - * @param string $action Action string |
|
141 | - * @param int $id Object id (if ref not provided) |
|
142 | - * @param string $ref Object ref (if id not provided) |
|
143 | - * @return void |
|
144 | - */ |
|
145 | - function assign_values(&$action='view', $id=0, $ref='') |
|
146 | - { |
|
138 | + * Shared method for canvas to assign values for templates |
|
139 | + * |
|
140 | + * @param string $action Action string |
|
141 | + * @param int $id Object id (if ref not provided) |
|
142 | + * @param string $ref Object ref (if id not provided) |
|
143 | + * @return void |
|
144 | + */ |
|
145 | + function assign_values(&$action='view', $id=0, $ref='') |
|
146 | + { |
|
147 | 147 | // phpcs:enable |
148 | - if (method_exists($this->control,'assign_values')) $this->control->assign_values($action, $id, $ref); |
|
149 | - } |
|
148 | + if (method_exists($this->control,'assign_values')) $this->control->assign_values($action, $id, $ref); |
|
149 | + } |
|
150 | 150 | |
151 | 151 | /** |
152 | 152 | * Return the template to display canvas (if it exists) |
153 | - * |
|
154 | - * @param string $action Action code |
|
153 | + * |
|
154 | + * @param string $action Action code |
|
155 | 155 | * @return int 0=Canvas template file does not exist, 1=Canvas template file exists |
156 | 156 | */ |
157 | 157 | function displayCanvasExists($action) |
@@ -163,53 +163,53 @@ discard block |
||
163 | 163 | } |
164 | 164 | |
165 | 165 | // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps |
166 | - /** |
|
167 | - * Display a canvas page. This will include the template for output. |
|
168 | - * Variables used by templates may have been defined or loaded before into the assign_values function. |
|
169 | - * |
|
170 | - * @param string $action Action code |
|
171 | - * @return void |
|
172 | - */ |
|
173 | - function display_canvas($action) |
|
174 | - { |
|
166 | + /** |
|
167 | + * Display a canvas page. This will include the template for output. |
|
168 | + * Variables used by templates may have been defined or loaded before into the assign_values function. |
|
169 | + * |
|
170 | + * @param string $action Action code |
|
171 | + * @return void |
|
172 | + */ |
|
173 | + function display_canvas($action) |
|
174 | + { |
|
175 | 175 | // phpcs:enable |
176 | - global $db, $conf, $langs, $user, $canvas; |
|
177 | - global $form, $formfile; |
|
176 | + global $db, $conf, $langs, $user, $canvas; |
|
177 | + global $form, $formfile; |
|
178 | 178 | |
179 | - include $this->template_dir.(!empty($this->card)?$this->card.'_':'').$this->_cleanaction($action).'.tpl.php'; // Include native PHP template |
|
180 | - } |
|
179 | + include $this->template_dir.(!empty($this->card)?$this->card.'_':'').$this->_cleanaction($action).'.tpl.php'; // Include native PHP template |
|
180 | + } |
|
181 | 181 | |
182 | 182 | |
183 | - // This functions should not be used anymore because canvas should contains only templates. |
|
184 | - // http://wiki.dolibarr.org/index.php/Canvas_development |
|
183 | + // This functions should not be used anymore because canvas should contains only templates. |
|
184 | + // http://wiki.dolibarr.org/index.php/Canvas_development |
|
185 | 185 | |
186 | - /** |
|
187 | - * Return if a canvas contains an action controller |
|
188 | - * |
|
189 | - * @return boolean Return if canvas contains actions (old feature. now actions should be inside hooks) |
|
190 | - */ |
|
191 | - function hasActions() |
|
192 | - { |
|
186 | + /** |
|
187 | + * Return if a canvas contains an action controller |
|
188 | + * |
|
189 | + * @return boolean Return if canvas contains actions (old feature. now actions should be inside hooks) |
|
190 | + */ |
|
191 | + function hasActions() |
|
192 | + { |
|
193 | 193 | return (is_object($this->control)); |
194 | - } |
|
194 | + } |
|
195 | 195 | |
196 | - /** |
|
197 | - * Shared method for canvas to execute actions. |
|
196 | + /** |
|
197 | + * Shared method for canvas to execute actions. |
|
198 | 198 | * @deprecated Use the doActions of hooks instead of this. |
199 | - * This function is called if you add a doActions class inside your canvas. Try to not |
|
200 | - * do that and add action code into a hook instead. |
|
201 | - * |
|
202 | - * @param string $action Action string |
|
203 | - * @param int $id Object id |
|
204 | - * @return mixed Return return code of doActions of canvas |
|
205 | - * @see http://wiki.dolibarr.org/index.php/Canvas_development |
|
206 | - */ |
|
207 | - function doActions(&$action='view', $id=0) |
|
208 | - { |
|
209 | - if (method_exists($this->control,'doActions')) |
|
210 | - { |
|
211 | - $ret = $this->control->doActions($action, $id); |
|
212 | - return $ret; |
|
213 | - } |
|
214 | - } |
|
199 | + * This function is called if you add a doActions class inside your canvas. Try to not |
|
200 | + * do that and add action code into a hook instead. |
|
201 | + * |
|
202 | + * @param string $action Action string |
|
203 | + * @param int $id Object id |
|
204 | + * @return mixed Return return code of doActions of canvas |
|
205 | + * @see http://wiki.dolibarr.org/index.php/Canvas_development |
|
206 | + */ |
|
207 | + function doActions(&$action='view', $id=0) |
|
208 | + { |
|
209 | + if (method_exists($this->control,'doActions')) |
|
210 | + { |
|
211 | + $ret = $this->control->doActions($action, $id); |
|
212 | + return $ret; |
|
213 | + } |
|
214 | + } |
|
215 | 215 | } |
@@ -27,55 +27,55 @@ discard block |
||
27 | 27 | |
28 | 28 | class CoreObject extends CommonObject |
29 | 29 | { |
30 | - public $withChild = true; |
|
30 | + public $withChild = true; |
|
31 | 31 | |
32 | - /** |
|
33 | - * @var Array $_fields Fields to synchronize with Database |
|
34 | - */ |
|
35 | - protected $fields=array(); |
|
32 | + /** |
|
33 | + * @var Array $_fields Fields to synchronize with Database |
|
34 | + */ |
|
35 | + protected $fields=array(); |
|
36 | 36 | |
37 | 37 | /** |
38 | - * Constructor |
|
39 | - * |
|
40 | - * @param DoliDB $db Database handler |
|
41 | - */ |
|
42 | - function __construct(DoliDB &$db) |
|
38 | + * Constructor |
|
39 | + * |
|
40 | + * @param DoliDB $db Database handler |
|
41 | + */ |
|
42 | + function __construct(DoliDB &$db) |
|
43 | 43 | { |
44 | 44 | $this->db = $db; |
45 | - } |
|
45 | + } |
|
46 | 46 | |
47 | 47 | /** |
48 | 48 | * Function to init fields |
49 | 49 | * |
50 | 50 | * @return bool |
51 | 51 | */ |
52 | - protected function init() |
|
52 | + protected function init() |
|
53 | 53 | { |
54 | - $this->id = 0; |
|
55 | - $this->datec = 0; |
|
56 | - $this->tms = 0; |
|
57 | - |
|
58 | - if (!empty($this->fields)) |
|
59 | - { |
|
60 | - foreach ($this->fields as $field=>$info) |
|
61 | - { |
|
62 | - if ($this->isDate($info)) $this->{$field} = time(); |
|
63 | - elseif ($this->isArray($info)) $this->{$field} = array(); |
|
64 | - elseif ($this->isInt($info)) $this->{$field} = (int) 0; |
|
65 | - elseif ($this->isFloat($info)) $this->{$field} = (double) 0; |
|
66 | - else $this->{$field} = ''; |
|
67 | - } |
|
54 | + $this->id = 0; |
|
55 | + $this->datec = 0; |
|
56 | + $this->tms = 0; |
|
57 | + |
|
58 | + if (!empty($this->fields)) |
|
59 | + { |
|
60 | + foreach ($this->fields as $field=>$info) |
|
61 | + { |
|
62 | + if ($this->isDate($info)) $this->{$field} = time(); |
|
63 | + elseif ($this->isArray($info)) $this->{$field} = array(); |
|
64 | + elseif ($this->isInt($info)) $this->{$field} = (int) 0; |
|
65 | + elseif ($this->isFloat($info)) $this->{$field} = (double) 0; |
|
66 | + else $this->{$field} = ''; |
|
67 | + } |
|
68 | 68 | |
69 | 69 | $this->to_delete=false; |
70 | 70 | $this->is_clone=false; |
71 | 71 | |
72 | - return true; |
|
73 | - } |
|
74 | - else |
|
72 | + return true; |
|
73 | + } |
|
74 | + else |
|
75 | 75 | { |
76 | - return false; |
|
77 | - } |
|
78 | - } |
|
76 | + return false; |
|
77 | + } |
|
78 | + } |
|
79 | 79 | |
80 | 80 | /** |
81 | 81 | * Test type of field |
@@ -86,15 +86,15 @@ discard block |
||
86 | 86 | */ |
87 | 87 | private function checkFieldType($field, $type) |
88 | 88 | { |
89 | - if (isset($this->fields[$field]) && method_exists($this, 'is_'.$type)) |
|
90 | - { |
|
91 | - return $this->{'is_'.$type}($this->fields[$field]); |
|
92 | - } |
|
93 | - else |
|
89 | + if (isset($this->fields[$field]) && method_exists($this, 'is_'.$type)) |
|
90 | + { |
|
91 | + return $this->{'is_'.$type}($this->fields[$field]); |
|
92 | + } |
|
93 | + else |
|
94 | 94 | { |
95 | 95 | return false; |
96 | 96 | } |
97 | - } |
|
97 | + } |
|
98 | 98 | |
99 | 99 | /** |
100 | 100 | * Get object and children from database |
@@ -103,15 +103,15 @@ discard block |
||
103 | 103 | * @param bool $loadChild used to load children from database |
104 | 104 | * @return int >0 if OK, <0 if KO, 0 if not found |
105 | 105 | */ |
106 | - public function fetch($id, $loadChild = true) |
|
106 | + public function fetch($id, $loadChild = true) |
|
107 | 107 | { |
108 | - $res = $this->fetchCommon($id); |
|
109 | - if($res>0) { |
|
110 | - if ($loadChild) $this->fetchChild(); |
|
111 | - } |
|
108 | + $res = $this->fetchCommon($id); |
|
109 | + if($res>0) { |
|
110 | + if ($loadChild) $this->fetchChild(); |
|
111 | + } |
|
112 | 112 | |
113 | - return $res; |
|
114 | - } |
|
113 | + return $res; |
|
114 | + } |
|
115 | 115 | |
116 | 116 | |
117 | 117 | /** |
@@ -125,25 +125,25 @@ discard block |
||
125 | 125 | */ |
126 | 126 | public function addChild($tabName, $id=0, $key='id', $try_to_load = false) |
127 | 127 | { |
128 | - if(!empty($id)) |
|
129 | - { |
|
130 | - foreach($this->{$tabName} as $k=>&$object) |
|
131 | - { |
|
132 | - if($object->{$key} === $id) return $k; |
|
133 | - } |
|
134 | - } |
|
128 | + if(!empty($id)) |
|
129 | + { |
|
130 | + foreach($this->{$tabName} as $k=>&$object) |
|
131 | + { |
|
132 | + if($object->{$key} === $id) return $k; |
|
133 | + } |
|
134 | + } |
|
135 | 135 | |
136 | - $k = count($this->{$tabName}); |
|
136 | + $k = count($this->{$tabName}); |
|
137 | 137 | |
138 | - $className = ucfirst($tabName); |
|
139 | - $this->{$tabName}[$k] = new $className($this->db); |
|
140 | - if($id>0 && $key==='id' && $try_to_load) |
|
141 | - { |
|
142 | - $this->{$tabName}[$k]->fetch($id); |
|
143 | - } |
|
138 | + $className = ucfirst($tabName); |
|
139 | + $this->{$tabName}[$k] = new $className($this->db); |
|
140 | + if($id>0 && $key==='id' && $try_to_load) |
|
141 | + { |
|
142 | + $this->{$tabName}[$k]->fetch($id); |
|
143 | + } |
|
144 | 144 | |
145 | - return $k; |
|
146 | - } |
|
145 | + return $k; |
|
146 | + } |
|
147 | 147 | |
148 | 148 | |
149 | 149 | /** |
@@ -156,16 +156,16 @@ discard block |
||
156 | 156 | */ |
157 | 157 | public function removeChild($tabName, $id, $key='id') |
158 | 158 | { |
159 | - foreach ($this->{$tabName} as &$object) |
|
160 | - { |
|
161 | - if ($object->{$key} == $id) |
|
162 | - { |
|
163 | - $object->to_delete = true; |
|
164 | - return true; |
|
165 | - } |
|
166 | - } |
|
167 | - return false; |
|
168 | - } |
|
159 | + foreach ($this->{$tabName} as &$object) |
|
160 | + { |
|
161 | + if ($object->{$key} == $id) |
|
162 | + { |
|
163 | + $object->to_delete = true; |
|
164 | + return true; |
|
165 | + } |
|
166 | + } |
|
167 | + return false; |
|
168 | + } |
|
169 | 169 | |
170 | 170 | |
171 | 171 | /** |
@@ -175,10 +175,10 @@ discard block |
||
175 | 175 | */ |
176 | 176 | public function fetchChild() |
177 | 177 | { |
178 | - if($this->withChild && !empty($this->childtables) && !empty($this->fk_element)) |
|
179 | - { |
|
180 | - foreach($this->childtables as &$childTable) |
|
181 | - { |
|
178 | + if($this->withChild && !empty($this->childtables) && !empty($this->fk_element)) |
|
179 | + { |
|
180 | + foreach($this->childtables as &$childTable) |
|
181 | + { |
|
182 | 182 | $className = ucfirst($childTable); |
183 | 183 | |
184 | 184 | $this->{$className}=array(); |
@@ -200,9 +200,9 @@ discard block |
||
200 | 200 | { |
201 | 201 | $this->errors[] = $this->db->lasterror(); |
202 | 202 | } |
203 | - } |
|
204 | - } |
|
205 | - } |
|
203 | + } |
|
204 | + } |
|
205 | + } |
|
206 | 206 | |
207 | 207 | /** |
208 | 208 | * Function to update children data |
@@ -210,26 +210,26 @@ discard block |
||
210 | 210 | * @param User $user user object |
211 | 211 | * @return void |
212 | 212 | */ |
213 | - public function saveChild(User &$user) |
|
213 | + public function saveChild(User &$user) |
|
214 | 214 | { |
215 | - if($this->withChild && !empty($this->childtables) && !empty($this->fk_element)) |
|
216 | - { |
|
217 | - foreach($this->childtables as &$childTable) |
|
218 | - { |
|
219 | - $className = ucfirst($childTable); |
|
220 | - if(!empty($this->{$className})) |
|
221 | - { |
|
222 | - foreach($this->{$className} as $i => &$object) |
|
223 | - { |
|
224 | - $object->{$this->fk_element} = $this->id; |
|
225 | - |
|
226 | - $object->update($user); |
|
227 | - if($this->unsetChildDeleted && isset($object->to_delete) && $object->to_delete==true) unset($this->{$className}[$i]); |
|
228 | - } |
|
229 | - } |
|
230 | - } |
|
231 | - } |
|
232 | - } |
|
215 | + if($this->withChild && !empty($this->childtables) && !empty($this->fk_element)) |
|
216 | + { |
|
217 | + foreach($this->childtables as &$childTable) |
|
218 | + { |
|
219 | + $className = ucfirst($childTable); |
|
220 | + if(!empty($this->{$className})) |
|
221 | + { |
|
222 | + foreach($this->{$className} as $i => &$object) |
|
223 | + { |
|
224 | + $object->{$this->fk_element} = $this->id; |
|
225 | + |
|
226 | + $object->update($user); |
|
227 | + if($this->unsetChildDeleted && isset($object->to_delete) && $object->to_delete==true) unset($this->{$className}[$i]); |
|
228 | + } |
|
229 | + } |
|
230 | + } |
|
231 | + } |
|
232 | + } |
|
233 | 233 | |
234 | 234 | |
235 | 235 | /** |
@@ -240,7 +240,7 @@ discard block |
||
240 | 240 | */ |
241 | 241 | public function update(User &$user) |
242 | 242 | { |
243 | - if (empty($this->id)) return $this->create($user); // To test, with that, no need to test on high level object, the core decide it, update just needed |
|
243 | + if (empty($this->id)) return $this->create($user); // To test, with that, no need to test on high level object, the core decide it, update just needed |
|
244 | 244 | elseif (isset($this->to_delete) && $this->to_delete==true) return $this->delete($user); |
245 | 245 | |
246 | 246 | $error = 0; |
@@ -270,7 +270,7 @@ discard block |
||
270 | 270 | $this->db->rollback(); |
271 | 271 | return -1; |
272 | 272 | } |
273 | - } |
|
273 | + } |
|
274 | 274 | |
275 | 275 | /** |
276 | 276 | * Function to create object in database |
@@ -280,26 +280,26 @@ discard block |
||
280 | 280 | */ |
281 | 281 | public function create(User &$user) |
282 | 282 | { |
283 | - if($this->id > 0) return $this->update($user); |
|
283 | + if($this->id > 0) return $this->update($user); |
|
284 | 284 | |
285 | 285 | $error = 0; |
286 | 286 | $this->db->begin(); |
287 | 287 | |
288 | 288 | $res = $this->createCommon($user); |
289 | - if($res) |
|
290 | - { |
|
291 | - $this->id = $this->db->last_insert_id($this->table_element); |
|
289 | + if($res) |
|
290 | + { |
|
291 | + $this->id = $this->db->last_insert_id($this->table_element); |
|
292 | 292 | |
293 | - $result = $this->call_trigger(strtoupper($this->element). '_CREATE', $user); |
|
293 | + $result = $this->call_trigger(strtoupper($this->element). '_CREATE', $user); |
|
294 | 294 | if ($result < 0) $error++; |
295 | 295 | else $this->saveChild($user); |
296 | - } |
|
297 | - else |
|
296 | + } |
|
297 | + else |
|
298 | 298 | { |
299 | 299 | $error++; |
300 | 300 | $this->error = $this->db->lasterror(); |
301 | 301 | $this->errors[] = $this->error; |
302 | - } |
|
302 | + } |
|
303 | 303 | |
304 | 304 | if (empty($error)) |
305 | 305 | { |
@@ -311,7 +311,7 @@ discard block |
||
311 | 311 | $this->db->rollback(); |
312 | 312 | return -1; |
313 | 313 | } |
314 | - } |
|
314 | + } |
|
315 | 315 | |
316 | 316 | /** |
317 | 317 | * Function to delete object in database |
@@ -319,9 +319,9 @@ discard block |
||
319 | 319 | * @param User $user user object |
320 | 320 | * @return < 0 if ko, > 0 if ok |
321 | 321 | */ |
322 | - public function delete(User &$user) |
|
322 | + public function delete(User &$user) |
|
323 | 323 | { |
324 | - if ($this->id <= 0) return 0; |
|
324 | + if ($this->id <= 0) return 0; |
|
325 | 325 | |
326 | 326 | $error = 0; |
327 | 327 | $this->db->begin(); |
@@ -360,7 +360,7 @@ discard block |
||
360 | 360 | $this->db->rollback(); |
361 | 361 | return -1; |
362 | 362 | } |
363 | - } |
|
363 | + } |
|
364 | 364 | |
365 | 365 | |
366 | 366 | /** |
@@ -372,12 +372,12 @@ discard block |
||
372 | 372 | */ |
373 | 373 | public function getDate($field, $format='') |
374 | 374 | { |
375 | - if(empty($this->{$field})) return ''; |
|
376 | - else |
|
375 | + if(empty($this->{$field})) return ''; |
|
376 | + else |
|
377 | 377 | { |
378 | - return dol_print_date($this->{$field}, $format); |
|
379 | - } |
|
380 | - } |
|
378 | + return dol_print_date($this->{$field}, $format); |
|
379 | + } |
|
380 | + } |
|
381 | 381 | |
382 | 382 | /** |
383 | 383 | * Function to set date in field |
@@ -388,18 +388,18 @@ discard block |
||
388 | 388 | */ |
389 | 389 | public function setDate($field, $date) |
390 | 390 | { |
391 | - if (empty($date)) |
|
392 | - { |
|
393 | - $this->{$field} = 0; |
|
394 | - } |
|
395 | - else |
|
391 | + if (empty($date)) |
|
392 | + { |
|
393 | + $this->{$field} = 0; |
|
394 | + } |
|
395 | + else |
|
396 | 396 | { |
397 | - require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php'; |
|
398 | - $this->{$field} = dol_stringtotime($date); |
|
399 | - } |
|
397 | + require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php'; |
|
398 | + $this->{$field} = dol_stringtotime($date); |
|
399 | + } |
|
400 | 400 | |
401 | - return $this->{$field}; |
|
402 | - } |
|
401 | + return $this->{$field}; |
|
402 | + } |
|
403 | 403 | |
404 | 404 | |
405 | 405 | /** |
@@ -410,29 +410,29 @@ discard block |
||
410 | 410 | */ |
411 | 411 | public function setValues(&$Tab) |
412 | 412 | { |
413 | - foreach ($Tab as $key => $value) |
|
414 | - { |
|
415 | - if($this->checkFieldType($key, 'date')) |
|
416 | - { |
|
417 | - $this->setDate($key, $value); |
|
418 | - } |
|
419 | - else if( $this->checkFieldType($key, 'array')) |
|
420 | - { |
|
421 | - $this->{$key} = $value; |
|
422 | - } |
|
423 | - else if( $this->checkFieldType($key, 'float') ) |
|
424 | - { |
|
425 | - $this->{$key} = (double) price2num($value); |
|
426 | - } |
|
427 | - else if( $this->checkFieldType($key, 'int') ) { |
|
428 | - $this->{$key} = (int) price2num($value); |
|
429 | - } |
|
430 | - else |
|
413 | + foreach ($Tab as $key => $value) |
|
414 | + { |
|
415 | + if($this->checkFieldType($key, 'date')) |
|
416 | + { |
|
417 | + $this->setDate($key, $value); |
|
418 | + } |
|
419 | + else if( $this->checkFieldType($key, 'array')) |
|
431 | 420 | { |
432 | - $this->{$key} = $value; |
|
433 | - } |
|
434 | - } |
|
421 | + $this->{$key} = $value; |
|
422 | + } |
|
423 | + else if( $this->checkFieldType($key, 'float') ) |
|
424 | + { |
|
425 | + $this->{$key} = (double) price2num($value); |
|
426 | + } |
|
427 | + else if( $this->checkFieldType($key, 'int') ) { |
|
428 | + $this->{$key} = (int) price2num($value); |
|
429 | + } |
|
430 | + else |
|
431 | + { |
|
432 | + $this->{$key} = $value; |
|
433 | + } |
|
434 | + } |
|
435 | 435 | |
436 | - return 1; |
|
437 | - } |
|
436 | + return 1; |
|
437 | + } |
|
438 | 438 | } |
@@ -32,44 +32,44 @@ discard block |
||
32 | 32 | */ |
33 | 33 | class Cstate // extends CommonObject |
34 | 34 | { |
35 | - /** |
|
35 | + /** |
|
36 | 36 | * @var DoliDB Database handler. |
37 | 37 | */ |
38 | 38 | public $db; |
39 | 39 | |
40 | - /** |
|
41 | - * @var string Error code (or message) |
|
42 | - */ |
|
43 | - public $error=''; |
|
40 | + /** |
|
41 | + * @var string Error code (or message) |
|
42 | + */ |
|
43 | + public $error=''; |
|
44 | 44 | |
45 | - /** |
|
46 | - * @var string[] Error codes (or messages) |
|
47 | - */ |
|
48 | - public $errors = array(); |
|
45 | + /** |
|
46 | + * @var string[] Error codes (or messages) |
|
47 | + */ |
|
48 | + public $errors = array(); |
|
49 | 49 | |
50 | - //var $element='cstate'; //!< Id that identify managed objects |
|
51 | - //var $table_element='cstate'; //!< Name of table without prefix where object is stored |
|
50 | + //var $element='cstate'; //!< Id that identify managed objects |
|
51 | + //var $table_element='cstate'; //!< Name of table without prefix where object is stored |
|
52 | 52 | |
53 | 53 | /** |
54 | - * @var int ID |
|
55 | - */ |
|
56 | - public $id; |
|
54 | + * @var int ID |
|
55 | + */ |
|
56 | + public $id; |
|
57 | 57 | |
58 | - public $code_departement; |
|
58 | + public $code_departement; |
|
59 | 59 | |
60 | - /** |
|
61 | - * @var string |
|
62 | - * @deprecated |
|
63 | - * @see name |
|
64 | - */ |
|
65 | - public $nom=''; |
|
60 | + /** |
|
61 | + * @var string |
|
62 | + * @deprecated |
|
63 | + * @see name |
|
64 | + */ |
|
65 | + public $nom=''; |
|
66 | 66 | |
67 | - /** |
|
68 | - * @var string name |
|
69 | - */ |
|
70 | - public $name=''; |
|
67 | + /** |
|
68 | + * @var string name |
|
69 | + */ |
|
70 | + public $name=''; |
|
71 | 71 | |
72 | - public $active; |
|
72 | + public $active; |
|
73 | 73 | |
74 | 74 | |
75 | 75 | |
@@ -94,70 +94,70 @@ discard block |
||
94 | 94 | */ |
95 | 95 | function create($user, $notrigger=0) |
96 | 96 | { |
97 | - global $conf, $langs; |
|
98 | - $error=0; |
|
97 | + global $conf, $langs; |
|
98 | + $error=0; |
|
99 | 99 | |
100 | - // Clean parameters |
|
101 | - if (isset($this->code_departement)) $this->code_departement=trim($this->code_departement); |
|
102 | - if (isset($this->nom)) $this->nom=trim($this->nom); |
|
103 | - if (isset($this->active)) $this->active=trim($this->active); |
|
100 | + // Clean parameters |
|
101 | + if (isset($this->code_departement)) $this->code_departement=trim($this->code_departement); |
|
102 | + if (isset($this->nom)) $this->nom=trim($this->nom); |
|
103 | + if (isset($this->active)) $this->active=trim($this->active); |
|
104 | 104 | |
105 | - // Check parameters |
|
106 | - // Put here code to add control on parameters values |
|
105 | + // Check parameters |
|
106 | + // Put here code to add control on parameters values |
|
107 | 107 | |
108 | 108 | // Insert request |
109 | - $sql = "INSERT INTO ".MAIN_DB_PREFIX."c_departements("; |
|
110 | - $sql.= "rowid,"; |
|
111 | - $sql.= "code_departement,"; |
|
112 | - $sql.= "nom,"; |
|
113 | - $sql.= "active"; |
|
109 | + $sql = "INSERT INTO ".MAIN_DB_PREFIX."c_departements("; |
|
110 | + $sql.= "rowid,"; |
|
111 | + $sql.= "code_departement,"; |
|
112 | + $sql.= "nom,"; |
|
113 | + $sql.= "active"; |
|
114 | 114 | $sql.= ") VALUES ("; |
115 | - $sql.= " ".(! isset($this->rowid)?'NULL':"'".$this->db->escape($this->rowid)."'").","; |
|
116 | - $sql.= " ".(! isset($this->code_departement)?'NULL':"'".$this->db->escape($this->code_departement)."'").","; |
|
117 | - $sql.= " ".(! isset($this->nom)?'NULL':"'".$this->db->escape($this->nom)."'").","; |
|
118 | - $sql.= " ".(! isset($this->active)?'NULL':"'".$this->db->escape($this->active)."'").""; |
|
119 | - $sql.= ")"; |
|
115 | + $sql.= " ".(! isset($this->rowid)?'NULL':"'".$this->db->escape($this->rowid)."'").","; |
|
116 | + $sql.= " ".(! isset($this->code_departement)?'NULL':"'".$this->db->escape($this->code_departement)."'").","; |
|
117 | + $sql.= " ".(! isset($this->nom)?'NULL':"'".$this->db->escape($this->nom)."'").","; |
|
118 | + $sql.= " ".(! isset($this->active)?'NULL':"'".$this->db->escape($this->active)."'").""; |
|
119 | + $sql.= ")"; |
|
120 | 120 | |
121 | - $this->db->begin(); |
|
121 | + $this->db->begin(); |
|
122 | 122 | |
123 | - dol_syslog(get_class($this)."::create", LOG_DEBUG); |
|
123 | + dol_syslog(get_class($this)."::create", LOG_DEBUG); |
|
124 | 124 | $resql=$this->db->query($sql); |
125 | - if (! $resql) { $error++; $this->errors[]="Error ".$this->db->lasterror(); } |
|
125 | + if (! $resql) { $error++; $this->errors[]="Error ".$this->db->lasterror(); } |
|
126 | 126 | |
127 | - if (! $error) |
|
127 | + if (! $error) |
|
128 | 128 | { |
129 | 129 | $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX."c_departements"); |
130 | 130 | |
131 | - if (! $notrigger) |
|
132 | - { |
|
133 | - // Uncomment this and change MYOBJECT to your own tag if you |
|
134 | - // want this action call a trigger. |
|
135 | - |
|
136 | - //// Call triggers |
|
137 | - //include_once DOL_DOCUMENT_ROOT . '/core/class/interfaces.class.php'; |
|
138 | - //$interface=new Interfaces($this->db); |
|
139 | - //$result=$interface->run_triggers('MYOBJECT_CREATE',$this,$user,$langs,$conf); |
|
140 | - //if ($result < 0) { $error++; $this->errors=$interface->errors; } |
|
141 | - //// End call triggers |
|
142 | - } |
|
131 | + if (! $notrigger) |
|
132 | + { |
|
133 | + // Uncomment this and change MYOBJECT to your own tag if you |
|
134 | + // want this action call a trigger. |
|
135 | + |
|
136 | + //// Call triggers |
|
137 | + //include_once DOL_DOCUMENT_ROOT . '/core/class/interfaces.class.php'; |
|
138 | + //$interface=new Interfaces($this->db); |
|
139 | + //$result=$interface->run_triggers('MYOBJECT_CREATE',$this,$user,$langs,$conf); |
|
140 | + //if ($result < 0) { $error++; $this->errors=$interface->errors; } |
|
141 | + //// End call triggers |
|
142 | + } |
|
143 | 143 | } |
144 | 144 | |
145 | 145 | // Commit or rollback |
146 | 146 | if ($error) |
147 | - { |
|
148 | - foreach($this->errors as $errmsg) |
|
149 | - { |
|
150 | - dol_syslog(get_class($this)."::create ".$errmsg, LOG_ERR); |
|
151 | - $this->error.=($this->error?', '.$errmsg:$errmsg); |
|
152 | - } |
|
153 | - $this->db->rollback(); |
|
154 | - return -1*$error; |
|
155 | - } |
|
156 | - else |
|
157 | - { |
|
158 | - $this->db->commit(); |
|
147 | + { |
|
148 | + foreach($this->errors as $errmsg) |
|
149 | + { |
|
150 | + dol_syslog(get_class($this)."::create ".$errmsg, LOG_ERR); |
|
151 | + $this->error.=($this->error?', '.$errmsg:$errmsg); |
|
152 | + } |
|
153 | + $this->db->rollback(); |
|
154 | + return -1*$error; |
|
155 | + } |
|
156 | + else |
|
157 | + { |
|
158 | + $this->db->commit(); |
|
159 | 159 | return $this->id; |
160 | - } |
|
160 | + } |
|
161 | 161 | } |
162 | 162 | |
163 | 163 | |
@@ -170,17 +170,17 @@ discard block |
||
170 | 170 | */ |
171 | 171 | function fetch($id,$code='') |
172 | 172 | { |
173 | - global $langs; |
|
173 | + global $langs; |
|
174 | 174 | $sql = "SELECT"; |
175 | - $sql.= " t.rowid,"; |
|
176 | - $sql.= " t.code_departement,"; |
|
177 | - $sql.= " t.nom,"; |
|
178 | - $sql.= " t.active"; |
|
175 | + $sql.= " t.rowid,"; |
|
176 | + $sql.= " t.code_departement,"; |
|
177 | + $sql.= " t.nom,"; |
|
178 | + $sql.= " t.active"; |
|
179 | 179 | $sql.= " FROM ".MAIN_DB_PREFIX."c_departements as t"; |
180 | 180 | if ($id) $sql.= " WHERE t.rowid = ".$id; |
181 | 181 | elseif ($code) $sql.= " WHERE t.code_departement = '".$this->db->escape($code)."'"; |
182 | 182 | |
183 | - dol_syslog(get_class($this)."::fetch", LOG_DEBUG); |
|
183 | + dol_syslog(get_class($this)."::fetch", LOG_DEBUG); |
|
184 | 184 | $resql=$this->db->query($sql); |
185 | 185 | if ($resql) |
186 | 186 | { |
@@ -189,9 +189,9 @@ discard block |
||
189 | 189 | $obj = $this->db->fetch_object($resql); |
190 | 190 | |
191 | 191 | $this->id = $obj->rowid; |
192 | - $this->code_departement = $obj->code_departement; |
|
193 | - $this->nom = $obj->nom; |
|
194 | - $this->active = $obj->active; |
|
192 | + $this->code_departement = $obj->code_departement; |
|
193 | + $this->nom = $obj->nom; |
|
194 | + $this->active = $obj->active; |
|
195 | 195 | } |
196 | 196 | $this->db->free($resql); |
197 | 197 | |
@@ -199,7 +199,7 @@ discard block |
||
199 | 199 | } |
200 | 200 | else |
201 | 201 | { |
202 | - $this->error="Error ".$this->db->lasterror(); |
|
202 | + $this->error="Error ".$this->db->lasterror(); |
|
203 | 203 | return -1; |
204 | 204 | } |
205 | 205 | } |
@@ -214,118 +214,118 @@ discard block |
||
214 | 214 | */ |
215 | 215 | function update($user=null, $notrigger=0) |
216 | 216 | { |
217 | - global $conf, $langs; |
|
218 | - $error=0; |
|
217 | + global $conf, $langs; |
|
218 | + $error=0; |
|
219 | 219 | |
220 | - // Clean parameters |
|
221 | - if (isset($this->code_departement)) $this->code_departement=trim($this->code_departement); |
|
222 | - if (isset($this->nom)) $this->nom=trim($this->nom); |
|
223 | - if (isset($this->active)) $this->active=trim($this->active); |
|
220 | + // Clean parameters |
|
221 | + if (isset($this->code_departement)) $this->code_departement=trim($this->code_departement); |
|
222 | + if (isset($this->nom)) $this->nom=trim($this->nom); |
|
223 | + if (isset($this->active)) $this->active=trim($this->active); |
|
224 | 224 | |
225 | 225 | |
226 | - // Check parameters |
|
227 | - // Put here code to add control on parameters values |
|
226 | + // Check parameters |
|
227 | + // Put here code to add control on parameters values |
|
228 | 228 | |
229 | 229 | // Update request |
230 | 230 | $sql = "UPDATE ".MAIN_DB_PREFIX."c_departements SET"; |
231 | - $sql.= " code_departement=".(isset($this->code_departement)?"'".$this->db->escape($this->code_departement)."'":"null").","; |
|
232 | - $sql.= " nom=".(isset($this->nom)?"'".$this->db->escape($this->nom)."'":"null").","; |
|
233 | - $sql.= " active=".(isset($this->active)?$this->active:"null").""; |
|
231 | + $sql.= " code_departement=".(isset($this->code_departement)?"'".$this->db->escape($this->code_departement)."'":"null").","; |
|
232 | + $sql.= " nom=".(isset($this->nom)?"'".$this->db->escape($this->nom)."'":"null").","; |
|
233 | + $sql.= " active=".(isset($this->active)?$this->active:"null").""; |
|
234 | 234 | $sql.= " WHERE rowid=".$this->id; |
235 | 235 | |
236 | - $this->db->begin(); |
|
236 | + $this->db->begin(); |
|
237 | 237 | |
238 | - dol_syslog(get_class($this)."::update", LOG_DEBUG); |
|
238 | + dol_syslog(get_class($this)."::update", LOG_DEBUG); |
|
239 | 239 | $resql = $this->db->query($sql); |
240 | - if (! $resql) { $error++; $this->errors[]="Error ".$this->db->lasterror(); } |
|
241 | - |
|
242 | - if (! $error) |
|
243 | - { |
|
244 | - if (! $notrigger) |
|
245 | - { |
|
246 | - // Uncomment this and change MYOBJECT to your own tag if you |
|
247 | - // want this action call a trigger. |
|
248 | - |
|
249 | - //// Call triggers |
|
250 | - //include_once DOL_DOCUMENT_ROOT . '/core/class/interfaces.class.php'; |
|
251 | - //$interface=new Interfaces($this->db); |
|
252 | - //$result=$interface->run_triggers('MYOBJECT_MODIFY',$this,$user,$langs,$conf); |
|
253 | - //if ($result < 0) { $error++; $this->errors=$interface->errors; } |
|
254 | - //// End call triggers |
|
255 | - } |
|
256 | - } |
|
240 | + if (! $resql) { $error++; $this->errors[]="Error ".$this->db->lasterror(); } |
|
241 | + |
|
242 | + if (! $error) |
|
243 | + { |
|
244 | + if (! $notrigger) |
|
245 | + { |
|
246 | + // Uncomment this and change MYOBJECT to your own tag if you |
|
247 | + // want this action call a trigger. |
|
248 | + |
|
249 | + //// Call triggers |
|
250 | + //include_once DOL_DOCUMENT_ROOT . '/core/class/interfaces.class.php'; |
|
251 | + //$interface=new Interfaces($this->db); |
|
252 | + //$result=$interface->run_triggers('MYOBJECT_MODIFY',$this,$user,$langs,$conf); |
|
253 | + //if ($result < 0) { $error++; $this->errors=$interface->errors; } |
|
254 | + //// End call triggers |
|
255 | + } |
|
256 | + } |
|
257 | 257 | |
258 | 258 | // Commit or rollback |
259 | - if ($error) |
|
260 | - { |
|
261 | - foreach($this->errors as $errmsg) |
|
262 | - { |
|
263 | - dol_syslog(get_class($this)."::update ".$errmsg, LOG_ERR); |
|
264 | - $this->error.=($this->error?', '.$errmsg:$errmsg); |
|
265 | - } |
|
266 | - $this->db->rollback(); |
|
267 | - return -1*$error; |
|
268 | - } |
|
269 | - else |
|
270 | - { |
|
271 | - $this->db->commit(); |
|
272 | - return 1; |
|
273 | - } |
|
259 | + if ($error) |
|
260 | + { |
|
261 | + foreach($this->errors as $errmsg) |
|
262 | + { |
|
263 | + dol_syslog(get_class($this)."::update ".$errmsg, LOG_ERR); |
|
264 | + $this->error.=($this->error?', '.$errmsg:$errmsg); |
|
265 | + } |
|
266 | + $this->db->rollback(); |
|
267 | + return -1*$error; |
|
268 | + } |
|
269 | + else |
|
270 | + { |
|
271 | + $this->db->commit(); |
|
272 | + return 1; |
|
273 | + } |
|
274 | 274 | } |
275 | 275 | |
276 | 276 | |
277 | - /** |
|
278 | - * Delete object in database |
|
279 | - * |
|
280 | - * @param User $user User that delete |
|
281 | - * @param int $notrigger 0=launch triggers after, 1=disable triggers |
|
282 | - * @return int <0 if KO, >0 if OK |
|
283 | - */ |
|
284 | - function delete($user, $notrigger=0) |
|
285 | - { |
|
286 | - global $conf, $langs; |
|
287 | - $error=0; |
|
288 | - |
|
289 | - $sql = "DELETE FROM ".MAIN_DB_PREFIX."c_departements"; |
|
290 | - $sql.= " WHERE rowid=".$this->id; |
|
291 | - |
|
292 | - $this->db->begin(); |
|
293 | - |
|
294 | - dol_syslog(get_class($this)."::delete", LOG_DEBUG); |
|
295 | - $resql = $this->db->query($sql); |
|
296 | - if (! $resql) { $error++; $this->errors[]="Error ".$this->db->lasterror(); } |
|
297 | - |
|
298 | - if (! $error) |
|
299 | - { |
|
300 | - if (! $notrigger) |
|
301 | - { |
|
302 | - // Uncomment this and change MYOBJECT to your own tag if you |
|
303 | - // want this action call a trigger. |
|
304 | - |
|
305 | - //// Call triggers |
|
306 | - //include_once DOL_DOCUMENT_ROOT . '/core/class/interfaces.class.php'; |
|
307 | - //$interface=new Interfaces($this->db); |
|
308 | - //$result=$interface->run_triggers('MYOBJECT_DELETE',$this,$user,$langs,$conf); |
|
309 | - //if ($result < 0) { $error++; $this->errors=$interface->errors; } |
|
310 | - //// End call triggers |
|
311 | - } |
|
312 | - } |
|
277 | + /** |
|
278 | + * Delete object in database |
|
279 | + * |
|
280 | + * @param User $user User that delete |
|
281 | + * @param int $notrigger 0=launch triggers after, 1=disable triggers |
|
282 | + * @return int <0 if KO, >0 if OK |
|
283 | + */ |
|
284 | + function delete($user, $notrigger=0) |
|
285 | + { |
|
286 | + global $conf, $langs; |
|
287 | + $error=0; |
|
288 | + |
|
289 | + $sql = "DELETE FROM ".MAIN_DB_PREFIX."c_departements"; |
|
290 | + $sql.= " WHERE rowid=".$this->id; |
|
291 | + |
|
292 | + $this->db->begin(); |
|
293 | + |
|
294 | + dol_syslog(get_class($this)."::delete", LOG_DEBUG); |
|
295 | + $resql = $this->db->query($sql); |
|
296 | + if (! $resql) { $error++; $this->errors[]="Error ".$this->db->lasterror(); } |
|
297 | + |
|
298 | + if (! $error) |
|
299 | + { |
|
300 | + if (! $notrigger) |
|
301 | + { |
|
302 | + // Uncomment this and change MYOBJECT to your own tag if you |
|
303 | + // want this action call a trigger. |
|
304 | + |
|
305 | + //// Call triggers |
|
306 | + //include_once DOL_DOCUMENT_ROOT . '/core/class/interfaces.class.php'; |
|
307 | + //$interface=new Interfaces($this->db); |
|
308 | + //$result=$interface->run_triggers('MYOBJECT_DELETE',$this,$user,$langs,$conf); |
|
309 | + //if ($result < 0) { $error++; $this->errors=$interface->errors; } |
|
310 | + //// End call triggers |
|
311 | + } |
|
312 | + } |
|
313 | 313 | |
314 | 314 | // Commit or rollback |
315 | - if ($error) |
|
316 | - { |
|
317 | - foreach($this->errors as $errmsg) |
|
318 | - { |
|
319 | - dol_syslog(get_class($this)."::delete ".$errmsg, LOG_ERR); |
|
320 | - $this->error.=($this->error?', '.$errmsg:$errmsg); |
|
321 | - } |
|
322 | - $this->db->rollback(); |
|
323 | - return -1*$error; |
|
324 | - } |
|
325 | - else |
|
326 | - { |
|
327 | - $this->db->commit(); |
|
328 | - return 1; |
|
329 | - } |
|
330 | - } |
|
315 | + if ($error) |
|
316 | + { |
|
317 | + foreach($this->errors as $errmsg) |
|
318 | + { |
|
319 | + dol_syslog(get_class($this)."::delete ".$errmsg, LOG_ERR); |
|
320 | + $this->error.=($this->error?', '.$errmsg:$errmsg); |
|
321 | + } |
|
322 | + $this->db->rollback(); |
|
323 | + return -1*$error; |
|
324 | + } |
|
325 | + else |
|
326 | + { |
|
327 | + $this->db->commit(); |
|
328 | + return 1; |
|
329 | + } |
|
330 | + } |
|
331 | 331 | } |
@@ -32,7 +32,6 @@ discard block |
||
32 | 32 | * Classe permettant la generation du formulaire d'un nouveau ticket. |
33 | 33 | * |
34 | 34 | * @package Ticket |
35 | - |
|
36 | 35 | * \remarks Utilisation: $formticket = new FormTicket($db) |
37 | 36 | * \remarks $formticket->proprietes=1 ou chaine ou tableau de valeurs |
38 | 37 | * \remarks $formticket->show_form() affiche le formulaire |
@@ -88,9 +87,9 @@ discard block |
||
88 | 87 | public $param = array(); |
89 | 88 | |
90 | 89 | /** |
91 | - * @var string Error code (or message) |
|
92 | - */ |
|
93 | - public $error; |
|
90 | + * @var string Error code (or message) |
|
91 | + */ |
|
92 | + public $error; |
|
94 | 93 | |
95 | 94 | |
96 | 95 | /** |
@@ -153,7 +152,7 @@ discard block |
||
153 | 152 | print '<input type="hidden" name="token" value="' . $_SESSION['newtoken'] . '">'; |
154 | 153 | print '<input type="hidden" name="action" value="' . $this->action . '">'; |
155 | 154 | foreach ($this->param as $key => $value) { |
156 | - print '<input type="hidden" name="' . $key . '" value="' . $value . '">'; |
|
155 | + print '<input type="hidden" name="' . $key . '" value="' . $value . '">'; |
|
157 | 156 | } |
158 | 157 | print '<input type="hidden" name="fk_user_create" value="' . $this->fk_user_create . '">'; |
159 | 158 | |
@@ -306,9 +305,9 @@ discard block |
||
306 | 305 | // Notify thirdparty at creation |
307 | 306 | if (empty($this->ispublic)) |
308 | 307 | { |
309 | - print '<tr><td><label for="notify_tiers_at_create">' . $langs->trans("TicketNotifyTiersAtCreation") . '</label></td><td>'; |
|
310 | - print '<input type="checkbox" id="notify_tiers_at_create" name="notify_tiers_at_create"'.($this->withnotifytiersatcreate?' checked="checked"':'').'>'; |
|
311 | - print '</td></tr>'; |
|
308 | + print '<tr><td><label for="notify_tiers_at_create">' . $langs->trans("TicketNotifyTiersAtCreation") . '</label></td><td>'; |
|
309 | + print '<input type="checkbox" id="notify_tiers_at_create" name="notify_tiers_at_create"'.($this->withnotifytiersatcreate?' checked="checked"':'').'>'; |
|
310 | + print '</td></tr>'; |
|
312 | 311 | } |
313 | 312 | |
314 | 313 | // TITLE |