$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";
