if (is_object($date)) { $pdDateExpe = "'" . $date->format('Ymd') . "'"; } } $objSmartgang->logFile(basename(__FILE__), "script", "EXE", "Commande -> {$pnIdCommande}"); $conDbo = $objSmartgang->getConDbo(); //-- conn to dbo if (!$conDbo) { //-- success connect $pnIdPlanche = $objSmartgang->getCreationPlancheNegoce($pnIdCommande, $pnIDAtelier, $pnIdUtilisateur, $pdDateExpe); //-- creationsql planche negoce if (is_numeric($pnIdPlanche)) { //-- recuperation des infos de planches $objSmartgang->getPapierBrochure($pnIdCommande, $pnIdPlanche); //-- add format "BROCHURE" if needed $resu_info = $objSmartgang->getInfoPlanche($pnIdPlanche); //-- recup info planche $objSmartgang->getFicheFabV2($resu_info); //-- create Fiche de fab negoce PDF $objSmartgang->getXmlFile($pnIdPlanche); //-- genere le xml de la fiche de fab sleep(120); //-- wait 120sec to be sur that all the files are copied $objSmartgang->getImport($resu_info); //-- appel au script de déplacement des fichiers dans IMPORTS $objSmartgang->getRenameImport($pnIdPlanche, $pnIdCommande); //-- rename IMPORTS if ($pnIdPlanche > 0) { $resu_negoce = $objSmartgang->execMsSql("SELECT\n CONVERT(CHAR(11),TP.DateExpeditionUrgente, 13) AS DateExp\n , TP.IDAtelier AS IDAtelier\n , TA.Code AS CodeAtelier\n FROM\n dbo.TBL_PLANCHE AS TP\n JOIN TBL_ATELIER AS TA ON TP.IDAtelier = TA.IDAtelier\n WHERE\n TP.IDPlanche = '{$pnIdPlanche}'"); $pdDateExpe = $resu_negoce[0]->DateExp; $idatelier = $resu_negoce[0]->IDAtelier;
$start = $exaprint->getmicrotime(); $exaprint->logFile(basename(__FILE__), "script", "RUN", "IDPlanche: {$pnIdPlanche} - ExportPDF: {$exportAsked}"); $deviceId = "Speedmaster 102"; $bascule = "Sheetwise"; $bleed = "2"; $params = $exaprint->getParams(); $pathMontage = $params['montage']['url']; $pathInputMxml = $params['metrix']['path']; $conDbo = $exaprint->getConDbo(); if ($exportAsked != "non") { $exec = "exec dbo.P_FluxEvenementCreation null,{$pnIdPlanche},3,687,'MetrixAutomation',0"; } else { $exec = "exec dbo.P_FluxEvenementCreation null,{$pnIdPlanche},2,687,'MetrixAutomation',0"; } $exaprint->execMsSql($exec); $info_planche = $exaprint->getInfoPlanche($pnIdPlanche); $pListeCommandes = $info_planche['pListeCommandes']; $psCodeTete = $info_planche['psCodeTete']; $psActiviteProd = $info_planche['psActiviteProd']; $pdDateCreationPlanche = $info_planche['pdDateCreationPlanche']; $psCodeatelier = $info_planche['psCodeAtelier']; $pathImport = "Volumes/mnt/raid1/datas/Production/Chef_de_fab_v2/MONTAGE/{$psCodeTete}/{$pdDateCreationPlanche}/{$pnIdPlanche}/IMPORTS"; $pathPlanche = "Volumes/Chef_de_fab_v2/MONTAGE/{$psCodeTete}/{$pdDateCreationPlanche}/{$pnIdPlanche}/{$psCodeatelier}_{$psActiviteProd}_{$pnIdPlanche}"; $import_content = $exaprint->getReadDir("/" . $pathImport); $qGangSize = "SELECT TOP 1\n TP.Largeur AS Largeur\n , TP.Longueur AS Longueur\n , TP.Bascule AS Bascule\n , CASE WHEN TPTPOV.IDProduitOptionValeur = 181 THEN 'Sheetwise' WHEN TPTPOV.IDProduitOptionValeur = 238 THEN 'Sheetwise' ELSE 'OneSided' END AS IDProduitOptionValeur\nFROM\n dbo.TBL_PLANCHE AS TP \n LEFT OUTER JOIN dbo.TBL_PLANCHE_TL_PRODUIT_OPTION_VALEUR AS TPTPOV ON TP.IDPlanche = TPTPOV.IDPlanche\nWHERE\n TP.EstSupp = '0'\n AND TPTPOV.IDProduitOptionValeur IN (376,238,181,180)\n AND TP.IDPlanche = {$pnIdPlanche}\nORDER BY\n TPTPOV.IDProduitOptionValeur DESC"; $gangSize = $exaprint->execMsSql($qGangSize); if (isset($gangSize[0]->IDProduitOptionValeur) && $gangSize[0]->IDProduitOptionValeur != '') { $bascule = $gangSize[0]->IDProduitOptionValeur; } switch ($gangSize[0]->Bascule) { case 1: