function loadLines(&$PDOdb, $id_expeditionLine)
{
$sql = "SELECT rowid FROM " . $this->get_table() . " WHERE fk_expeditiondet = " . $id_expeditionLine . " ORDER BY rang";
$TIdExpedet = TRequeteCore::_get_id_by_sql($PDOdb, $sql);
foreach ($TIdExpedet as $idexpedet) {
$dispatchdetail_temp = new TDispatchDetail();
$dispatchdetail_temp->load($PDOdb, $idexpedet);
$this->lines[] = $dispatchdetail_temp;
$this->nbLines = $this->nbLines + 1;
}
}
function _addExpeditiondetLine(&$PDOdb, &$TImport, &$expedition, $numserie)
{
global $db;
//Charge l'asset lié au numéro de série dans le fichier
$asset = new TAsset();
if ($asset->loadBy($PDOdb, $numserie, 'serial_number')) {
//Charge le produit associé à l'équipement
$prodAsset = new Product($db);
$prodAsset->fetch($asset->fk_product);
$fk_line_expe = (int) GETPOST('lineexpeditionid');
if (empty($fk_line_expe)) {
//Récupération de l'indentifiant de la ligne d'expédition concerné par le produit
foreach ($expedition->lines as $expeline) {
if ($expeline->fk_product == $prodAsset->id) {
$fk_line_expe = $expeline->line_id;
}
}
}
//Sauvegarde (ajout/MAJ) des lignes de détail d'expédition
$dispatchdetail = new TDispatchDetail();
//Si déjà existant => MAj
$PDOdb->Execute("SELECT rowid FROM " . MAIN_DB_PREFIX . "expeditiondet_asset WHERE fk_asset = " . $asset->rowid . " AND fk_expeditiondet = " . $fk_line_expe . " ");
if ($PDOdb->Get_line()) {
$dispatchdetail->load($PDOdb, $PDOdb->Get_field('rowid'));
}
$keys = array_keys($TImport);
$rang = $keys[count($keys) - 1];
$dispatchdetail->fk_expeditiondet = $fk_line_expe;
$dispatchdetail->fk_asset = $asset->rowid;
$dispatchdetail->rang = $rang;
$dispatchdetail->lot_number = $asset->lot_number;
$dispatchdetail->weight = GETPOST('quantity') ? GETPOST('quantity') : $asset->contenancereel_value;
$dispatchdetail->weight_reel = GETPOST('quantity') ? GETPOST('quantity') : $asset->contenancereel_value;
$dispatchdetail->weight_unit = $asset->contenancereel_units;
$dispatchdetail->weight_reel_unit = $asset->contenancereel_units;
$dispatchdetail->save($PDOdb);
//Rempli le tableau utilisé pour l'affichage des lignes
$TImport[] = array('ref' => $prodAsset->ref, 'numserie' => $numserie, 'fk_product' => $prodAsset->id, 'fk_expeditiondet' => $expedition->id, 'lot_number' => $asset->lot_number, 'quantity' => GETPOST('quantity') ? GETPOST('quantity') : $asset->contenancereel_value, 'quantity_unit' => GETPOST('quantity') ? GETPOST('quantity') : $asset->contenancereel_units);
}
//pre($TImport,true);
return $TImport;
}
/** Overloading the doActions function : replacing the parent's function with the one below
* @param parameters meta datas of the hook (context, etc...)
* @param object the object you want to process (an invoice if you are in invoice module, a propale in propale's module, etc...)
* @param action current action (if set). Generally create or edit or null
* @return void
*/
function beforePDFCreation($parameters, &$object, &$action, $hookmanager)
{
// pour implementation dans Dolibarr 3.7
if (in_array('pdfgeneration', explode(':', $parameters['context']))) {
define('INC_FROM_DOLIBARR', true);
dol_include_once('/dispatch/config.php');
dol_include_once('/asset/class/asset.class.php');
dol_include_once('/dispatch/class/dispatchdetail.class.php');
global $conf;
if (isset($parameters['object']) && get_class($object) == 'Expedition') {
$PDOdb = new TPDOdb();
foreach ($object->lines as &$line) {
$sql = 'SELECT DISTINCT(lot_number),rowid FROM ' . MAIN_DB_PREFIX . 'expeditiondet_asset WHERE fk_expeditiondet = ' . $line->line_id;
$PDOdb->Execute($sql);
$TRes = $PDOdb->Get_All();
if (count($TRes) > 0) {
$line->desc .= "<br>Lot(s) expédié(s) : ";
foreach ($TRes as $res) {
$dispatchDetail = new TDispatchDetail();
$dispatchDetail->load($PDOdb, $res->rowid);
$asset = new TAsset();
$asset->load($PDOdb, $dispatchDetail->fk_asset);
$asset->load_asset_type($PDOdb);
$unite = $asset->assetType->measuring_units == 'unit' ? 'unité(s)' : measuring_units_string($dispatchDetail->weight_reel_unit, $asset->assetType->measuring_units);
$desc = "<br>- " . $res->lot_number . " x " . $dispatchDetail->weight_reel . " " . $unite;
if (empty($conf->global->DISPATCH_HIDE_DLUO_PDF)) {
$desc .= ' (DLUO : ' . $asset->get_date('dluo') . ')';
}
$line->desc .= $desc;
}
}
}
}
//pre($object,true);exit;
}
}
