26require_once DOL_DOCUMENT_ROOT.
'/partnership/core/modules/partnership/modules_partnership.php';
38 public $version =
'dolibarr';
40 public $prefix =
'PSHIP';
50 public $name =
'standard';
59 public function info($langs)
61 return $langs->trans(
"SimpleNumRefModelDesc", $this->prefix);
72 return $this->prefix.
"0501-0001";
85 global $conf, $langs, $db;
90 $posindice = strlen($this->prefix) + 6;
91 $sql =
"SELECT MAX(CAST(SUBSTRING(ref FROM ".$posindice.
") AS SIGNED)) as max";
92 $sql .=
" FROM ".MAIN_DB_PREFIX.
"partnership";
93 $sql .=
" WHERE ref LIKE '".$db->escape($this->prefix).
"____-%'";
94 if (
$object->ismultientitymanaged == 1) {
95 $sql .=
" AND entity = ".$conf->entity;
96 } elseif (
$object->ismultientitymanaged == 2) {
100 $resql = $db->query($sql);
102 $row = $db->fetch_row($resql);
104 $coyymm = substr($row[0], 0, 6);
108 if ($coyymm && !preg_match(
'/'.$this->prefix.
'[0-9][0-9][0-9][0-9]/i', $coyymm)) {
109 $langs->load(
"errors");
110 $this->error = $langs->trans(
'ErrorNumRefModel', $max);
128 $posindice = strlen($this->prefix) + 6;
129 $sql =
"SELECT MAX(CAST(SUBSTRING(ref FROM ".$posindice.
") AS SIGNED)) as max";
130 $sql .=
" FROM ".MAIN_DB_PREFIX.
"partnership";
131 $sql .=
" WHERE ref LIKE '".$db->escape($this->prefix).
"____-%'";
132 if (
$object->ismultientitymanaged == 1) {
133 $sql .=
" AND entity = ".$conf->entity;
134 } elseif (
$object->ismultientitymanaged == 2) {
138 $resql = $db->query($sql);
140 $obj = $db->fetch_object($resql);
142 $max = intval($obj->max);
147 dol_syslog(
"mod_partnership_standard::getNextValue", LOG_DEBUG);
152 $date =
$object->date_creation;
155 if ($max >= (pow(10, 4) - 1)) {
158 $num = sprintf(
"%04d", $max + 1);
161 dol_syslog(
"mod_partnership_standard::getNextValue return ".$this->prefix.$yymm.
"-".$num);
162 return $this->prefix.$yymm.
"-".$num;
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
Parent class to manage numbering of Partnership.
Class to manage the Standard numbering rule for Partnership.
info($langs)
Return description of numbering module.
getNextValue($object)
Return next free value.
getExample()
Return an example of numbering.
canBeActivated($object)
Checks if the numbers already in the database do not cause conflicts that would prevent this numberin...
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.