$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: $bascule = $gangSize[0]->IDProduitOptionValeur; break; case 2: $bascule = "WorkAndTurn"; //WorkAndTurn break; case 3: $bascule = "WorkAndTumble";