37 public $element =
'cashcontrol';
42 public $table_element =
'pos_cash_fence';
47 public $picto =
'cash-register';
75 'rowid' => array(
'type' =>
'integer',
'label' =>
'TechnicalID',
'enabled' => 1,
'visible' => -2,
'notnull' => 1,
'position' => 10),
76 'entity' => array(
'type' =>
'integer',
'label' =>
'Entity',
'enabled' => 1,
'visible' => 0,
'notnull' => 1,
'position' => 15),
77 'ref' => array(
'type' =>
'varchar(64)',
'label' =>
'Ref',
'enabled' => 1,
'visible' => 1,
'notnull' => 1,
'position' => 18),
78 'posmodule' => array(
'type' =>
'varchar(30)',
'label' =>
'Module',
'enabled' => 1,
'visible' => 1,
'notnull' => 1,
'position' => 19),
79 'posnumber' => array(
'type' =>
'varchar(30)',
'label' =>
'Terminal',
'enabled' => 1,
'visible' => 1,
'notnull' => 1,
'position' => 20,
'css' =>
'center'),
80 'label' => array(
'type' =>
'varchar(255)',
'label' =>
'Label',
'enabled' => 1,
'visible' => 0,
'position' => 24),
81 'opening' => array(
'type' =>
'price',
'label' =>
'Opening',
'enabled' => 1,
'visible' => 1,
'position' => 25,
'csslist' =>
'amount'),
82 'cash' => array(
'type' =>
'price',
'label' =>
'Cash',
'enabled' => 1,
'visible' => 1,
'position' => 30,
'csslist' =>
'amount'),
83 'cheque' => array(
'type' =>
'price',
'label' =>
'Cheque',
'enabled' => 1,
'visible' => 1,
'position' => 33,
'csslist' =>
'amount'),
84 'card' => array(
'type' =>
'price',
'label' =>
'CreditCard',
'enabled' => 1,
'visible' => 1,
'position' => 36,
'csslist' =>
'amount'),
85 'year_close' => array(
'type' =>
'integer',
'label' =>
'Year close',
'enabled' => 1,
'visible' => 1,
'notnull' => 1,
'position' => 50,
'css' =>
'center'),
86 'month_close' => array(
'type' =>
'integer',
'label' =>
'Month close',
'enabled' => 1,
'visible' => 1,
'position' => 55,
'css' =>
'center'),
87 'day_close' => array(
'type' =>
'integer',
'label' =>
'Day close',
'enabled' => 1,
'visible' => 1,
'position' => 60,
'css' =>
'center'),
88 'date_creation' => array(
'type' =>
'datetime',
'label' =>
'DateCreation',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 500),
89 'date_valid' => array(
'type' =>
'datetime',
'label' =>
'DateValidation',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 502),
90 'tms' => array(
'type' =>
'timestamp',
'label' =>
'Tms',
'enabled' => 1,
'visible' => 0,
'notnull' => 1,
'position' => 505),
91 'fk_user_creat' => array(
'type' =>
'integer:User',
'label' =>
'UserCreation',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 600),
92 'fk_user_valid' => array(
'type' =>
'integer:User',
'label' =>
'UserValidation',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 602),
93 'import_key' => array(
'type' =>
'varchar(14)',
'label' =>
'Import key',
'enabled' => 1,
'visible' => 0,
'position' => 700),
94 'status' => array(
'type' =>
'integer',
'label' =>
'Status',
'enabled' => 1,
'visible' => 1,
'position' => 1000,
'notnull' => 1,
'index' => 1,
'arrayofkeyval' => array(
'0' =>
'Draft',
'1' =>
'Validated')),
116 public $date_creation;
117 public $fk_user_creat;
122 public $date_modification;
128 public $fk_user_valid;
131 const STATUS_DRAFT = 0;
132 const STATUS_VALIDATED = 1;
133 const STATUS_CLOSED = 1;
145 $this->ismultientitymanaged = 1;
146 $this->isextrafieldmanaged = 0;
164 if (empty($this->cash)) {
167 if (empty($this->cheque)) {
170 if (empty($this->card)) {
175 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"pos_cash_fence (";
180 $sql .=
", date_creation";
181 $sql .=
", posmodule";
182 $sql .=
", posnumber";
183 $sql .=
", day_close";
184 $sql .=
", month_close";
185 $sql .=
", year_close";
189 $sql .=
", fk_user_creat";
190 $sql .=
") VALUES (";
192 $sql .= ((int) $conf->entity);
193 $sql .=
", ".(is_numeric($this->opening) ?
price2num($this->opening,
'MT') : 0);
195 $sql .=
", '".$this->db->idate(
dol_now()).
"'";
196 $sql .=
", '".$this->db->escape($this->posmodule).
"'";
197 $sql .=
", '".$this->db->escape($this->posnumber).
"'";
198 $sql .=
", ".($this->day_close > 0 ? $this->day_close :
"null");
199 $sql .=
", ".($this->month_close > 0 ? $this->month_close :
"null");
200 $sql .=
", ".((int) $this->year_close);
201 $sql .=
", ".price2num($this->cash,
'MT');
202 $sql .=
", ".price2num($this->cheque,
'MT');
203 $sql .=
", ".price2num($this->card,
'MT');
204 $sql .=
", ".((int) $user->id);
209 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
210 $resql = $this->db->query($sql);
213 $this->errors[] =
"Error ".$this->db->lasterror();
217 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
"pos_cash_fence");
219 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'pos_cash_fence SET ref = rowid where rowid = '.((int) $this->
id);
220 $this->db->query($sql);
225 foreach ($this->errors as $errmsg) {
226 dol_syslog(get_class($this).
"::create ".$errmsg, LOG_ERR);
227 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
229 $this->db->rollback();
246 global $conf, $langs;
247 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
252 if ($this->
status == self::STATUS_VALIDATED) {
253 dol_syslog(get_class($this).
"::valid action abandoned: already validated", LOG_WARNING);
260 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"pos_cash_fence";
261 $sql .=
" SET status = ".self::STATUS_VALIDATED.
",";
262 $sql .=
" date_valid='".$this->db->idate($now).
"',";
263 $sql .=
" fk_user_valid = ".$user->id;
264 $sql .=
" WHERE rowid=".((int) $this->
id);
268 dol_syslog(get_class($this).
"::close", LOG_DEBUG);
269 $resql = $this->db->query($sql);
272 $this->errors[] =
"Error ".$this->db->lasterror();
276 $this->
status = self::STATUS_VALIDATED;
277 $this->date_valid = $now;
278 $this->fk_user_valid = $user->id;
281 if (!$error && !$notrigger) {
283 $result = $this->
call_trigger(
'CASHCONTROL_VALIDATE', $user);
292 foreach ($this->errors as $errmsg) {
293 dol_syslog(get_class($this).
"::create ".$errmsg, LOG_ERR);
294 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
296 $this->db->rollback();
312 public function fetch($id, $ref =
null)
338 public function delete(
User $user, $notrigger = 0)
366 if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
369 $this->labelStatus[0] = $langs->transnoentitiesnoconv(
'Draft');
370 $this->labelStatus[1] = $langs->transnoentitiesnoconv(
'Closed');
371 $this->labelStatusShort[0] = $langs->transnoentitiesnoconv(
'Draft');
372 $this->labelStatusShort[1] = $langs->transnoentitiesnoconv(
'Closed');
375 $statusType =
'status0';
376 if ($status == self::STATUS_VALIDATED) {
377 $statusType =
'status6';
380 return dolGetStatus($this->labelStatus[$status], $this->labelStatusShort[$status],
'', $statusType, $mode);
393 public function getNomUrl($withpicto = 0, $option =
'', $notooltip = 0, $morecss =
'', $save_lastsearch_value = -1)
395 global $conf, $langs, $hookmanager;
397 if (!empty($conf->dol_no_mouse_hover)) {
403 $newref = ($this->
ref ? $this->
ref : $this->id);
405 $label =
'<u>'.$langs->trans(
"CashControl").
'</u>';
407 $label .=
'<b>'.$langs->trans(
'Ref').
':</b> '.($this->
ref ? $this->
ref : $this->id);
409 $url = DOL_URL_ROOT.
'/compta/cashcontrol/cashcontrol_card.php?id='.$this->id;
411 if ($option !=
'nolink') {
413 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
414 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
415 $add_save_lastsearch_values = 1;
417 if ($add_save_lastsearch_values) {
418 $url .=
'&save_lastsearch_values=1';
423 if (empty($notooltip)) {
425 $label = $langs->trans(
"ShowMyObject");
426 $linkclose .=
' alt="'.dol_escape_htmltag($label, 1).
'"';
428 $linkclose .=
' title="'.dol_escape_htmltag($label, 1).
'"';
429 $linkclose .=
' class="classfortooltip'.($morecss ?
' '.$morecss :
'').
'"';
431 $linkclose = ($morecss ?
' class="'.$morecss.
'"' :
'');
434 $linkstart =
'<a href="'.$url.
'"';
435 $linkstart .= $linkclose.
'>';
438 $result .= $linkstart;
440 $result .=
img_object(($notooltip ?
'' : $label), ($this->picto ? $this->picto :
'generic'), ($notooltip ? (($withpicto != 2) ?
'class="paddingright"' :
'') :
'class="'.(($withpicto != 2) ?
'paddingright ' :
'').
'classfortooltip"'), 0, 0, $notooltip ? 0 : 1);
442 if ($withpicto != 2) {
443 $result .= $this->ref;
449 $hookmanager->initHooks(array(
'cashfencedao'));
450 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
451 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
453 $result = $hookmanager->resPrint;
455 $result .= $hookmanager->resPrint;
472 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
474 $return =
'<div class="box-flex-item box-flex-grow-zero">';
475 $return .=
'<div class="info-box info-box-sm">';
476 $return .=
'<span class="info-box-icon bg-infobox-action">';
479 $return .=
'</span>';
480 $return .=
'<div class="info-box-content">';
481 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this,
'getNomUrl') ? $this->
getNomUrl(1, 1) : $this->ref).
'</span>';
482 if ($selected >= 0) {
483 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
485 if (property_exists($this,
'posmodule')) {
486 $return .=
'<br><span class="opacitymedium">'.substr($langs->trans(
"Module/Application"), 0, 12).
'</span> : <span class="info-box-label">'.$this->posmodule.
'</span>';
488 if (property_exists($this,
'year_close')) {
489 $return .=
'<br><span class="info-box-label opacitymedium" >'.$langs->trans(
"Year").
'</span> : <span>'.$this->year_close.
'</span>';
491 if (method_exists($this,
'getLibStatut')) {
492 $return .=
'<br><div class="info-box-status">'.$this->getLibStatut(3).
'</div>';
print $langs trans("AuditedSecurityEvents").'</strong >< span class="opacitymedium"></span >< br > status
Or an array listing all the potential status of the object: array: int of the status => translated la...
Class to manage cash fence.
getKanbanView($option='', $arraydata=null)
Return clicable link of object (with eventually picto)
LibStatut($status, $mode=0)
Return the status.
valid(User $user, $notrigger=0)
Validate cash fence.
update(User $user, $notrigger=0)
Update object into database.
getNomUrl($withpicto=0, $option='', $notooltip=0, $morecss='', $save_lastsearch_value=-1)
Return clicable link of object (with eventually picto)
$fields
'type' field format ('integer', 'integer:ObjectClass:PathToClass[:AddCreateButtonOrNot[:Filter]]',...
create(User $user, $notrigger=0)
Create in database.
getLibStatut($mode=0)
Return label of the status.
__construct(DoliDB $db)
Constructor.
fetch($id, $ref=null)
Load object in memory from the database.
Parent class of all other business classes (invoices, contracts, proposals, orders,...
updateCommon(User $user, $notrigger=0)
Update object into database.
fetchCommon($id, $ref=null, $morewhere='', $noextrafields=0)
Load object in memory from the database.
deleteCommon(User $user, $notrigger=0, $forcechilddeletion=0)
Delete object in database.
call_trigger($triggerName, $user)
Call trigger based on this instance.
Class to manage Dolibarr database access.
Class to manage Dolibarr users.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0)
Show a picto called object_picto (generic function)
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
dol_now($mode='auto')
Return date for now.
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.