24 require_once DOL_DOCUMENT_ROOT .
'/core/modules/expedition/modules_expedition.php';
65 return $langs->trans(
"SimpleNumRefModelDesc",$this->prefix);
76 return $this->prefix.
"0501-0001";
87 global $conf,$langs,$db;
92 $sql =
"SELECT MAX(CAST(SUBSTRING(ref FROM ".$posindice.
") AS SIGNED)) as max";
93 $sql.=
" FROM ".MAIN_DB_PREFIX.
"expedition";
94 $sql.=
" WHERE ref LIKE '".$db->escape($this->prefix).
"____-%'";
95 $sql.=
" AND entity = ".$conf->entity;
100 $row = $db->fetch_row(
$resql);
101 if ($row) { $coyymm = substr($row[0],0,6); $max=$row[0]; }
103 if ($coyymm && ! preg_match(
'/'.$this->prefix.
'[0-9][0-9][0-9][0-9]/i',$coyymm))
105 $langs->load(
"errors");
106 $this->error=$langs->trans(
'ErrorNumRefModel', $max);
125 $sql =
"SELECT MAX(CAST(SUBSTRING(ref FROM ".$posindice.
") AS SIGNED)) as max";
126 $sql.=
" FROM ".MAIN_DB_PREFIX.
"expedition";
127 $sql.=
" WHERE ref LIKE '".$db->escape($this->prefix).
"____-%'";
128 $sql.=
" AND entity = ".$conf->entity;
133 $obj = $db->fetch_object(
$resql);
134 if ($obj) $max = intval($obj->max);
139 dol_syslog(
"mod_expedition_safor::getNextValue", LOG_DEBUG);
144 $yymm = strftime(
"%y%m",$date);
146 if ($max >= (pow(10, 4) - 1)) $num=$max+1;
147 else $num = sprintf(
"%04s",$max+1);
149 dol_syslog(
"mod_expedition_safor::getNextValue return ".$this->prefix.$yymm.
"-".$num);
150 return $this->prefix.$yymm.
"-".$num;
if(! empty($conf->facture->enabled) && $user->rights->facture->lire) if(! empty($conf->fournisseur->enabled) && $user->rights->fournisseur->facture->lire) if(! empty($conf->don->enabled) && $user->rights->societe->lire) if(! empty($conf->tax->enabled) && $user->rights->tax->charges->lire) if(! empty($conf->facture->enabled) &&! empty($conf->commande->enabled) && $user->rights->commande->lire &&empty($conf->global->WORKFLOW_DISABLE_CREATE_INVOICE_FROM_ORDER)) if(! empty($conf->facture->enabled) && $user->rights->facture->lire) if(! empty($conf->fournisseur->enabled) && $user->rights->fournisseur->facture->lire) $resql
Social contributions to pay.
info()
Return default description of numbering model.
Class to manage expedition numbering rules Safor.
getNextValue($objsoc, $shipment)
Return next value.
getExample()
Return numbering example.
Parent Class of numbering models of sending receipts references.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='')
Write log message into outputs.
expedition_get_num($objsoc, $objforref)
Return next free value.
canBeActivated()
Test if existing numbers make problems with numbering.
$version
Dolibarr version of the loaded document string.