28require_once DOL_DOCUMENT_ROOT.
'/core/class/commonobjectline.class.php';
40 public $element =
'stocktransferline';
45 public $table_element =
'stocktransfer_stocktransferline';
50 public $picto =
'stocktransferline@stocktransfer';
52 const STATUS_DRAFT = 0;
53 const STATUS_VALIDATED = 1;
54 const STATUS_CANCELED = 9;
86 public $fields = array(
87 'rowid' => array(
'type' =>
'integer',
'label' =>
'TechnicalID',
'enabled' => 1,
'position' => 1,
'notnull' => 1,
'visible' => 0,
'noteditable' => 1,
'index' => 1,
'comment' =>
"Id"),
88 'amount' => array(
'type' =>
'price',
'label' =>
'Amount',
'enabled' => 1,
'position' => 40,
'notnull' => 0,
'visible' => 1,
'default' =>
'null',
'isameasure' => 1,
'help' =>
"Help text for amount",),
89 'qty' => array(
'type' =>
'real',
'label' =>
'Qty',
'enabled' => 1,
'position' => 45,
'notnull' => 0,
'visible' => 1,
'default' =>
'0',
'isameasure' => 1,
'css' =>
'maxwidth75imp',
'help' =>
"Help text for quantity",),
90 'fk_warehouse_destination' => array(
'type' =>
'integer:Entrepot:product/stock/class/entrepot.class.php',
'label' =>
'Entrepôt de destination',
'enabled' => 1,
'position' => 50,
'notnull' => 1,
'visible' => 1,),
91 'fk_warehouse_source' => array(
'type' =>
'integer:Entrepot:product/stock/class/entrepot.class.php',
'label' =>
'Entrepôt source',
'enabled' => 1,
'position' => 50,
'notnull' => 1,
'visible' => 1,),
92 'fk_stocktransfer' => array(
'type' =>
'integer:StockTransfer:stocktransfer/stock/class/stocktransfer.class.php',
'label' =>
'StockTransfer',
'enabled' => 1,
'position' => 50,
'notnull' => 1,
'visible' => 0,),
93 'fk_product' => array(
'type' =>
'integer:Product:product/class/product.class.php',
'label' =>
'Product',
'enabled' => 1,
'position' => 50,
'notnull' => 1,
'visible' => 1,),
94 'batch' => array(
'type' =>
'varchar(128)',
'label' =>
'Batch',
'enabled' => 1,
'position' => 1000,
'notnull' => -1,
'visible' => 1,),
95 'pmp' => array(
'type' =>
'double',
'label' =>
'PMP',
'enabled' => 1,
'position' => 50,
'notnull' => 0,
'visible' => 1,),
96 'rang' => array(
'type' =>
'integer',
'label' =>
'Qty',
'enabled' => 1,
'position' => 45,
'notnull' => 0,
'visible' => 0,
'default' =>
'0',
'isameasure' => 1,
'css' =>
'maxwidth75imp',
'help' =>
"Help text for quantity",),
114 public $fk_warehouse_destination;
118 public $fk_warehouse_source;
122 public $fk_stocktransfer;
147 global
$conf, $langs;
151 $this->ismultientitymanaged = 0;
152 $this->isextrafieldmanaged = 1;
155 $this->fields[
'rowid'][
'visible'] = 0;
157 if (!
isModEnabled(
'multicompany') && isset($this->fields[
'entity'])) {
158 $this->fields[
'entity'][
'enabled'] = 0;
168 foreach ($this->fields as $key => $val) {
169 if (isset($val[
'enabled']) && empty($val[
'enabled'])) {
170 unset($this->fields[$key]);
175 if (is_object($langs)) {
176 foreach ($this->fields as $key => $val) {
177 if (isset($val[
'arrayofkeyval']) && is_array($val[
'arrayofkeyval'])) {
178 foreach ($val[
'arrayofkeyval'] as $key2 => $val2) {
179 $this->fields[$key][
'arrayofkeyval'][$key2] = $langs->trans($val2);
217 $result =
$object->fetchCommon($fromid);
218 if ($result > 0 && !empty(
$object->table_element_line)) {
232 $object->ref = empty($this->fields[
'ref'][
'default']) ?
"copy_of_".$object->ref : $this->fields[
'ref'][
'default'];
233 $object->status = self::STATUS_DRAFT;
236 if (is_array(
$object->array_options) && count(
$object->array_options) > 0) {
237 $extrafields->fetch_name_optionals_label($this->table_element);
238 foreach (
$object->array_options as $key => $option) {
239 $shortkey = preg_replace(
'/options_/',
'', $key);
240 if (!empty($extrafields->attributes[$this->table_element][
'unique'][$shortkey])) {
241 unset(
$object->array_options[$key]);
247 $object->context[
'createfromclone'] =
'createfromclone';
248 $result =
$object->createCommon($user);
261 unset(
$object->context[
'createfromclone']);
268 $this->db->rollback();
280 public function fetch($id, $ref =
null)
283 if ($result > 0 && !empty($this->table_element_line)) {
296 $this->lines = array();
315 public function fetchAll($sortorder =
'', $sortfield =
'', $limit = 0, $offset = 0, $filter =
'', $filtermode =
'AND')
323 $sql .=
' FROM '.MAIN_DB_PREFIX.$this->table_element.
' as t';
324 if (isset($this->ismultientitymanaged) && $this->ismultientitymanaged == 1) {
325 $sql .=
' WHERE t.entity IN ('.getEntity($this->element).
')';
327 $sql .=
' WHERE 1 = 1';
334 $this->errors[] = $errormessage;
335 dol_syslog(__METHOD__.
' '.implode(
',', $this->errors), LOG_ERR);
339 if (!empty($sortfield)) {
340 $sql .= $this->db->order($sortfield, $sortorder);
342 if (!empty($limit)) {
343 $sql .=
' '.$this->db->plimit($limit, $offset);
346 $resql = $this->db->query($sql);
348 $num = $this->db->num_rows($resql);
350 while ($i < ($limit ? min($limit, $num) : $num)) {
351 $obj = $this->db->fetch_object($resql);
353 $record =
new self($this->db);
354 $record->setVarsFromFetchObj($obj);
356 $records[$record->id] = $record;
360 $this->db->free($resql);
364 $this->errors[] =
'Error '.$this->db->lasterror();
365 dol_syslog(__METHOD__.
' '.implode(
',', $this->errors), LOG_ERR);
390 public function delete(
User $user, $notrigger = 0)
407 $this->error =
'ErrorDeleteLineNotAllowedByObjectStatus';
425 global $user, $langs;
427 require_once DOL_DOCUMENT_ROOT .
'/product/class/product.class.php';
428 include_once DOL_DOCUMENT_ROOT .
'/product/stock/class/mouvementstock.class.php';
429 include_once DOL_DOCUMENT_ROOT .
'/product/stock/stocktransfer/class/stocktransfer.class.php';
432 $p->fetch($this->fk_product);
435 $op[0] =
"+".trim((
string) $this->qty);
436 $op[1] =
"-".trim((
string) $this->qty);
439 $movementstock->origin_type = $st->origin_type;
440 $movementstock->origin_id = $this->fk_stocktransfer;
442 if (empty($this->batch)) {
443 $result = $movementstock->_create(
447 (
float) $op[$direction],
449 empty($direction) ? $this->pmp : 0,
459 if ($p->hasbatch()) {
460 $arraybatchinfo = $p->loadBatchInfo($this->batch);
461 if (count($arraybatchinfo) > 0) {
462 $firstrecord = array_shift($arraybatchinfo);
463 $dlc = $firstrecord[
'eatby'];
464 $dluo = $firstrecord[
'sellby'];
470 $result = $movementstock->_create(
474 (
float) $op[$direction],
476 empty($direction) ? $this->pmp : 0,
490 $this->error = $langs->trans(
'StockTransferNoBatchForProduct', $p->getNomUrl());
491 $this->errors[] = $this->error;
508 global
$conf, $langs;
510 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
515 if ($this->
status == self::STATUS_VALIDATED) {
516 dol_syslog(get_class($this).
"::validate action abandoned: already validated", LOG_WARNING);
533 if (!$error && (preg_match(
'/^[\(]?PROV/i', $this->
ref) || empty($this->
ref))) {
536 $num = (string) $this->
ref;
538 $this->newref = $num;
542 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
543 $sql .=
" SET ref = '".$this->db->escape($num).
"',";
544 $sql .=
" status = ".self::STATUS_VALIDATED;
545 if (!empty($this->fields[
'date_validation'])) {
546 $sql .=
", date_validation = '".$this->db->idate($now).
"',";
548 if (!empty($this->fields[
'fk_user_valid'])) {
549 $sql .=
", fk_user_valid = ".((int) $user->id);
551 $sql .=
" WHERE rowid = ".((int) $this->
id);
553 dol_syslog(get_class($this).
"::validate()", LOG_DEBUG);
554 $resql = $this->db->query($sql);
556 dol_print_error($this->db);
557 $this->error = $this->db->lasterror();
561 if (!$error && !$notrigger) {
563 $result = $this->call_trigger(
'STOCKTRANSFERLINE_VALIDATE', $user);
572 $this->oldref = $this->ref;
575 if (preg_match(
'/^[\(]?PROV/i', $this->
ref)) {
577 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filename = CONCAT('".$this->db->escape($this->newref).
"', SUBSTR(filename, ".(strlen($this->
ref) + 1).
")), filepath = 'stocktransferline/".$this->db->escape($this->newref).
"'";
578 $sql .=
" WHERE filename LIKE '".$this->db->escape($this->
ref).
"%' AND filepath = 'stocktransferline/".$this->db->escape($this->
ref).
"' and entity = ".((int)
$conf->entity);
579 $resql = $this->db->query($sql);
582 $this->error = $this->db->lasterror();
584 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filepath = 'stocktransferline/".$this->db->escape($this->newref).
"'";
585 $sql .=
" WHERE filepath = 'stocktransferline/".$this->db->escape($this->
ref).
"' and entity = ".((int)
$conf->entity);
586 $resql = $this->db->query($sql);
589 $this->error = $this->db->lasterror();
595 $dirsource =
$conf->stocktransfer->dir_output.
'/stocktransferline/'.$oldref;
596 $dirdest =
$conf->stocktransfer->dir_output.
'/stocktransferline/'.$newref;
597 if (!$error && file_exists($dirsource)) {
598 dol_syslog(get_class($this).
"::validate() rename dir ".$dirsource.
" into ".$dirdest);
600 if (@rename($dirsource, $dirdest)) {
603 $listoffiles =
dol_dir_list(
$conf->stocktransfer->dir_output.
'/stocktransferline/'.$newref,
'files', 1,
'^'.preg_quote($oldref,
'/'));
604 foreach ($listoffiles as $fileentry) {
605 $dirsource = $fileentry[
'name'];
606 $dirdest = preg_replace(
'/^'.preg_quote($oldref,
'/').
'/', $newref, $dirsource);
607 $dirsource = $fileentry[
'path'].
'/'.$dirsource;
608 $dirdest = $fileentry[
'path'].
'/'.$dirdest;
609 @rename($dirsource, $dirdest);
619 $this->
status = self::STATUS_VALIDATED;
626 $this->db->rollback();
642 if ($this->
status <= self::STATUS_DRAFT) {
653 return $this->
setStatusCommon($user, self::STATUS_DRAFT, $notrigger,
'STOCKTRANSFERLINE_UNVALIDATE');
663 public function cancel($user, $notrigger = 0)
666 if ($this->
status != self::STATUS_VALIDATED) {
677 return $this->
setStatusCommon($user, self::STATUS_CANCELED, $notrigger,
'STOCKTRANSFERLINE_CLOSE');
687 public function reopen($user, $notrigger = 0)
690 if ($this->
status != self::STATUS_CANCELED) {
701 return $this->
setStatusCommon($user, self::STATUS_VALIDATED, $notrigger,
'STOCKTRANSFERLINE_REOPEN');
714 public function getNomUrl($withpicto = 0, $option =
'', $notooltip = 0, $morecss =
'', $save_lastsearch_value = -1)
716 global
$conf, $langs, $hookmanager;
718 if (!empty(
$conf->dol_no_mouse_hover)) {
724 $label =
'<u>'.$langs->trans(
"StockTransferLine").
'</u>';
726 $label .=
'<b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
727 if (isset($this->
status)) {
728 $label .=
'<br><b>'.$langs->trans(
"Status").
":</b> ".$this->
getLibStatut(5);
731 $url =
dol_buildpath(
'/stocktransfer/stocktransferline_card.php', 1).
'?id='.$this->id;
733 if ($option !=
'nolink') {
735 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
736 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
737 $add_save_lastsearch_values = 1;
739 if ($add_save_lastsearch_values) {
740 $url .=
'&save_lastsearch_values=1';
745 if (empty($notooltip)) {
747 $label = $langs->trans(
"ShowStockTransferLine");
748 $linkclose .=
' alt="'.dolPrintHTMLForAttribute($label).
'"';
750 $linkclose .=
' title="'.dolPrintHTMLForAttribute($label).
'"';
751 $linkclose .=
' class="classfortooltip'.($morecss ?
' '.$morecss :
'').
'"';
753 $linkclose = ($morecss ?
' class="'.$morecss.
'"' :
'');
756 $linkstart =
'<a href="'.$url.
'"';
757 $linkstart .= $linkclose.
'>';
760 $result .= $linkstart;
762 if (empty($this->showphoto_on_popup)) {
764 $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);
768 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
770 list($class, $module) = explode(
'@', $this->picto);
773 $filename = $filearray[0][
'name'];
774 if (!empty($filename)) {
775 $pospoint = strpos($filearray[0][
'name'],
'.');
777 $pathtophoto = $class.
'/'.$this->
ref.
'/thumbs/'.
dol_substr($filename, 0, $pospoint).
'_mini'.
dol_substr($filename, $pospoint);
779 $result .=
'<div class="floatleft inline-block valignmiddle divphotoref"><div class="photoref"><img class="photo'.$module.
'" alt="No photo" border="0" src="'.DOL_URL_ROOT.
'/viewimage.php?modulepart='.$module.
'&entity='.
$conf->entity.
'&file='.urlencode($pathtophoto).
'"></div></div>';
781 $result .=
'<div class="floatleft inline-block valignmiddle divphotoref"><img class="photouserphoto userphoto" alt="No photo" border="0" src="'.DOL_URL_ROOT.
'/viewimage.php?modulepart='.$module.
'&entity='.
$conf->entity.
'&file='.urlencode($pathtophoto).
'"></div>';
786 $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);
791 if ($withpicto != 2) {
792 $result .= $this->ref;
798 global $action, $hookmanager;
799 $hookmanager->initHooks(array(
'stocktransferlinedao'));
800 $parameters = array(
'id' => $this->
id,
'getnomurl' => $result);
801 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
803 $result = $hookmanager->resPrint;
805 $result .= $hookmanager->resPrint;
833 if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
836 $this->labelStatus[self::STATUS_DRAFT] = $langs->trans(
'Draft');
837 $this->labelStatus[self::STATUS_VALIDATED] = $langs->trans(
'Enabled');
838 $this->labelStatus[self::STATUS_CANCELED] = $langs->trans(
'Disabled');
839 $this->labelStatusShort[self::STATUS_DRAFT] = $langs->trans(
'Draft');
840 $this->labelStatusShort[self::STATUS_VALIDATED] = $langs->trans(
'Enabled');
841 $this->labelStatusShort[self::STATUS_CANCELED] = $langs->trans(
'Disabled');
844 $statusType =
'status'.$status;
846 if ($status == self::STATUS_CANCELED) {
847 $statusType =
'status6';
850 return dolGetStatus($this->labelStatus[$status], $this->labelStatusShort[$status],
'', $statusType, $mode);
861 $sql =
'SELECT rowid, date_creation as datec, tms as datem,';
862 $sql .=
' fk_user_creat, fk_user_modif';
863 $sql .=
' FROM '.MAIN_DB_PREFIX.$this->table_element.
' as t';
864 $sql .=
' WHERE t.rowid = '.((int) $id);
865 $result = $this->db->query($sql);
867 if ($this->db->num_rows($result)) {
868 $obj = $this->db->fetch_object($result);
869 $this->
id = $obj->rowid;
871 $this->user_creation_id = $obj->fk_user_creat;
872 $this->user_modification_id = $obj->fk_user_modif;
873 $this->date_creation = $this->db->jdate($obj->datec);
874 $this->date_modification = empty($obj->datem) ?
'' : $this->db->jdate($obj->datem);
877 $this->db->free($result);
879 dol_print_error($this->db);
901 global $langs,
$conf;
902 $langs->load(
"stocks");
905 $conf->global->STOCKTRANSFER_STOCKTRANSFERLINE_ADDON =
'mod_stocktransferline_standard';
915 $dirmodels = array_merge(array(
'/'), (array)
$conf->modules_parts[
'models']);
916 foreach ($dirmodels as $reldir) {
920 $mybool = ((bool) @include_once $dir.$file) || $mybool;
924 dol_print_error(
null,
"Failed to include file ".$file);
928 if (class_exists($classname)) {
929 $obj =
new $classname();
930 '@phan-var-force ModeleNumRefStockTransfer $obj';
931 $numref = $obj->getNextValue($this);
933 if ($numref !=
'' && $numref !=
'-1') {
936 $this->error = $obj->error;
941 print $langs->trans(
"Error").
" ".$langs->trans(
"ClassNotFound").
' '.$classname;
945 print $langs->trans(
"ErrorNumberingModuleNotSetup", $this->element);
961 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams =
null)
963 global
$conf, $langs;
966 $includedocgeneration = 0;
968 $langs->load(
"stocks");
971 $modele =
'standard_stocktransferline';
973 if (!empty($this->model_pdf)) {
974 $modele = $this->model_pdf;
980 $modelpath =
"core/modules/stocktransfer/doc/";
982 if ($includedocgeneration) {
983 $result = $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
1012 $this->db->commit();
if(! $sortfield) if(! $sortorder) $object
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
deleteLineCommon(User $user, $idline, $notrigger=0)
Delete a line of object in database.
commonGenerateDocument($modelspath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams=null)
Common function for all objects extending CommonObject for generating documents.
setErrorsFromObject($object)
setErrorsFromObject
createCommon(User $user, $notrigger=0)
Create object in the database.
getFieldList($alias='', $excludefields=array())
Function to concat keys of fields.
updateCommon(User $user, $notrigger=0)
Update object into database.
setStatusCommon($user, $status, $notrigger=0, $triggercode='')
Set to a status.
initAsSpecimenCommon()
Initialise object with example values Id must be 0 if object instance is a specimen.
copy_linked_contact($objFrom, $source='internal')
Copy contact from one element to current.
fetchLinesCommon($morewhere='', $noextrafields=0)
Load object in memory from the 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.
Parent class for class inheritance lines of business objects This class is useless for the moment so ...
Class to manage Dolibarr database access.
Class to manage stock movements.
Class to manage products or services.
Class for StockTransferLine.
reopen($user, $notrigger=0)
Set back to validated status.
generateDocument($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0, $moreparams=null)
Create a document onto disk according to template module.
getLibStatut($mode=0)
Return label of the status.
setDraft($user, $notrigger=0)
Set draft status.
fetch($id, $ref=null)
Load object in memory from the database.
fetchAll($sortorder='', $sortfield='', $limit=0, $offset=0, $filter='', $filtermode='AND')
Load list of objects in memory from the database.
initAsSpecimen()
Initialise object with example values Id must be 0 if object instance is a specimen.
__construct(DoliDB $db)
Constructor.
fetchLines()
Load object lines in memory from the database.
validate($user, $notrigger=0)
Validate object.
cancel($user, $notrigger=0)
Set cancel status.
doStockMovement($label, $code_inv, $fk_entrepot, $direction=1)
Makes all stock movements (add quantity, remove quantity or cancel all actions)
doScheduledJob()
Action executed by scheduler CAN BE A CRON TASK.
createFromClone(User $user, $fromid)
Clone an object into another one.
LibStatut($status, $mode=0)
Return the status.
info($id)
Load the info information in the object.
update(User $user, $notrigger=0)
Update object into database.
getNextNumRef()
Returns the reference to the following non used object depending on the active numbering module.
getNomUrl($withpicto=0, $option='', $notooltip=0, $morecss='', $save_lastsearch_value=-1)
Return a link to the object card (with optionally the picto)
create(User $user, $notrigger=0)
Create object into database.
deleteLine(User $user, $idline, $notrigger=0)
Delete a line of object in database.
Class to manage Dolibarr users.
print $langs trans("Ref").' m titre as m m statut as status
Or an array listing all the potential status of the object: array: int of the status => translated la...
dol_dir_list($utf8_path, $types="all", $recursive=0, $filter="", $excludefilter=null, $sortcriteria="name", $sortorder=SORT_ASC, $mode=0, $nohook=0, $relativename="", $donotfollowsymlinks=0, $nbsecondsold=0)
Scan a directory and return a list of files/directories.
dol_now($mode='gmt')
Return date for now.
dol_strlen($string, $stringencoding='UTF-8', $binarycount=0)
Make a strlen call.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0, $allowdash=0)
Clean a string to use it as a file name.
forgeSQLFromUniversalSearchCriteria($filter, &$errorstr='', $noand=0, $nopar=0, $noerror=0, $forbiddenfields=array())
forgeSQLFromUniversalSearchCriteria
dol_substr($string, $start, $length=null, $stringencoding='', $trunconbytes=0)
Make a substring.
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.