/** * @param $pnIdUtilisateur * @param $chk */ function getSuppPlanche($pnIdUtilisateur, $chk) { $objSmartgang = new smartgang(); $objSmartgang->getConDbo(); //-- conn to dbo $objSmartgang->logFile(basename(__FILE__), __FUNCTION__, "RUN", "arg=>{$chk}"); $data_planche = $objSmartgang->getDataPlanchToSupp($pnIdUtilisateur, $chk); if (is_array($data_planche) && count($data_planche) > 0) { foreach ($data_planche as $key => $arg) { $pnIdPlanche = intval($arg->IDPlanche); if (is_numeric($pnIdPlanche) && $pnIdPlanche > 0) { $qSql = "EXEC dbo.P_CommandeCommentaireInternePersoAjoute {$pnIdUtilisateur},{$pnIdPlanche},null,'planche detruite en attente amalgame'"; $objSmartgang->execMsSql($qSql); $path = "http://" . $_SERVER['SERVER_ADDR'] . "/appli/smartgang/rollback.php?numero={$pnIdPlanche}"; $url = "{$path}"; $options = $objSmartgang->curlopt($url); //-- options cURL $ch = curl_init(); curl_setopt_array($ch, $options); $content = curl_exec($ch); //-- exec cURL to url $objSmartgang->logFile(basename(__FILE__), __FUNCTION__, "EXE", "{$url}"); if (curl_error($ch)) { $objSmartgang->logFile(basename(__FILE__), __FUNCTION__, "ERR", "{$pnIdPlanche} | method cURLexec() : " . curl_error($ch) . $content); } //-- LOG $objSmartgang->logFile(basename(__FILE__), __FUNCTION__, "OK ", "{$pnIdPlanche}"); curl_close($ch); } } } $objSmartgang->logFile(basename(__FILE__), __FUNCTION__, "END", "arg=>{$chk}"); }
/** * @param $pnIdUtilisateur * @param $chk */ function getFtp($pnIdUtilisateur, $chk) { /*$headers = 'From: MonteurAuto<*****@*****.**>' . "\r\n" . 'Reply-To: automation@exaprint.fr' . "\r\n" . 'Content-Type: text/html; charset="iso-8859-1"' . "\r\n" . 'X-Mailer: PHP/' . phpversion();*/ $objSmartgang = new smartgang(); $objSmartgang->logFile(basename(__FILE__), __FUNCTION__, "RUN", ""); $objSmartgang->getConDbo(); $data_planche = $objSmartgang->getDataPlancheReadyToSent($pnIdUtilisateur, $chk); if (is_array($data_planche) && count($data_planche) > 0) { foreach ($data_planche as $value) { $verif = null; $pnIdPlanche = $value->IDPlanche; $objSmartgang->logFile(basename(__FILE__), __FUNCTION__, "EXE", " : START EntreeFTP -> {$pnIdPlanche}"); if (is_numeric($pnIdPlanche) && $pnIdPlanche > 0) { $verif = $objSmartgang->getVerifElement($data_planche); $objSmartgang->logFile(basename(__FILE__), __FUNCTION__, "EXE", " : {$pnIdPlanche} => Verif = {$verif}"); /*if (preg_match('/2/',$verif)) { mail('*****@*****.**', "$pnIdPlanche => Verif = $verif", "planche $pnIdPlanche => Verif = $verif", $headers); mail('*****@*****.**', "$pnIdPlanche => Verif = $verif", "$pnIdPlanche => Verif = $verif", $headers); }*/ if (preg_match('/111/', $verif) && !preg_match('/2/', $verif)) { $objSmartgang->getEstValide($pnIdPlanche); $objSmartgang->getEntreeFtpXml($pnIdPlanche); $objSmartgang->logFile(basename(__FILE__), __FUNCTION__, "END", ""); } else { $objSmartgang->logFile(basename(__FILE__), __FUNCTION__, "ERR", " : {$pnIdPlanche} => Verif = {$verif}"); } } } } else { $objSmartgang->logFile(basename(__FILE__), __FUNCTION__, "ERR", " : {$data_planche}"); } }
* Proj: appli * */ //-- verify status $file_status = fopen("/var/www/appli/smartgang/status/negoce.txt", "r+"); $status = fgets($file_status); fclose($file_status); if ($status == "Running") { $pnIdPlanche = '0'; $pnIdCommande = '0'; $pdDateExpe = "''"; $pnIdUtilisateur = 687; include '/var/www/appli/lib/srv.php'; require_once '/var/www/appli/class/class.gang.php'; $objSmartgang = new smartgang(); $objSmartgang->logFile(basename(__FILE__), "script", "RUN", "negoce/start.php"); $start = $objSmartgang->getmicrotime(); if (isset($_GET['idcommande']) && $_GET['idcommande'] > 0 && (isset($_GET['idatelier']) && $_GET['idatelier'] > 0)) { $pnIdCommande = $_GET['idcommande']; $pnIDAtelier = $_GET['idatelier']; if (isset($_GET['dateExp']) && $_GET['dateExp'] != "null") { $date = \DateTime::createFromFormat('d/m/Y', $_GET['dateExp']); 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
<?php if (isset($_GET['idplanche']) && $_GET['idplanche'] > '0') { $pnIdPlanche = $psPath = $tpsEcoule = $fileIntoImport = $bascule = $exportAsked = null; $arrayProduct = $arrayLayout = array(); $pnIdPlanche = intval($_GET['idplanche']); if (isset($_GET['exportPdf']) && $_GET['exportPdf'] != "") { $exportAsked = $_GET['exportPdf']; } include '/var/www/appli/lib/srv.php'; require_once "/var/www/appli/class/class.gang.php"; $exaprint = new smartgang(); $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'];
<?php /** Created by blond. * File: find.php * Date: 29/02/16 - 11:37 * Proj: appli * */ //-- verify status $file_status = fopen("/var/www/appli/smartgang/status/find.txt", "r+"); $status = fgets($file_status); fclose($file_status); if ($status == "Running") { include '/var/www/appli/lib/srv.php'; require_once '/var/www/appli/class/class.gang.php'; $exaprint = new smartgang(); $run = $exaprint->getmicrotime(); $exaprint->logFile(basename(__FILE__), "script", "RUN", " <> //- FIND PDF FROM METRIX AUTOMATION - <>"); $exaprint->getFindAndCopy(); // $exaprint->getFindAndCopy_v2(); $end = $exaprint->getmicrotime(); $exaprint->logFile(basename(__FILE__), "script", "EXE", " <> - END FIND PDF FROM METRIX AUTOMATION - // <>"); $exaprint->logFile(basename(__FILE__), "script", "END", ": Find executed in " . round($end - $run, 5) . "sec\n"); }
* Date: 17/11/15 - 23:37 * Proj: appli * */ //-- verify status $file_status = fopen("/var/www/appli/smartgang/status/solo.txt", "r+"); $status = fgets($file_status); fclose($file_status); if ($status == "Running") { $data = 'rien'; $pnIdUtilisateur = 687; include '/var/www/appli/lib/srv.php'; $ip = $_SERVER['SERVER_ADDR']; require_once '/var/www/appli/class/class.gang.php'; $objSmartgang = new smartgang(); $objSmartgang->logFile(basename(__FILE__), "SOLO", "RUN", "/solo/start.php"); $start = $objSmartgang->getmicrotime(); if (isset($_GET['idcommande']) && $_GET['idcommande'] > 0) { $pnIdCommande = $_GET['idcommande']; $pnIdUtilisateur = 687; $objSmartgang->logFile(basename(__FILE__), "SOLO", "EXE", "Commande : {$pnIdCommande}"); $conDbo = $objSmartgang->getConDbo(); //-- conn to dbo if (!$conDbo) { //-- success connect $row = $objSmartgang->getInfoCommande($pnIdCommande); //-- recup des infos de commande if (is_array($row)) { //-- si pas d'erreur à la lecture if ($row[0]->TypeProduit == '1') { //-- si il s'agit d'un produit d'amalgame
*/ echo "<form>"; echo "<input type='number' name='idplanche' placeholder='planche'>"; echo "<input type='submit' name='submit'><br/><br/>"; echo "</form>"; include '/var/www/appli/lib/srv.php'; //-- load ip server require_once "/var/www/appli/class/class.gang.php"; //-- load class to work $pnIdPlanche = $psPath = $tpsEcoule = $fileIntoImport = $bascule = $exportAsked = null; $deviceId = "Speedmaster 102"; $bascule = "Sheetwise"; $bleed = "2"; $exaprint = new smartgang(); $start = $exaprint->getmicrotime(); $exaprint->logFile(basename(__FILE__), "script", "RUN", "{$start} metrix/generateMxml.php"); $params = $exaprint->getParams(); $pathMontage = $params['montage']['url']; $pathInputMxml = $params['metrix']['path']; if (isset($_GET['exportPdf']) && $_GET['exportPdf'] != "") { $exportAsked = $_GET['exportPdf']; } if (isset($_GET['idplanche']) && $_GET['idplanche'] > '0') { //-- Check if param exist to start $pnIdPlanche = intval($_GET['idplanche']); $exaprint->logFile(basename(__FILE__), "script", "EXE", "exportPdf {$pnIdPlanche} = {$exportAsked}"); /** * Collect data to fill mxml * **/ $conDbo = $exaprint->getConDbo(); //-- Connect to db if ($exportAsked != "non") { $exec = "exec dbo.P_FluxEvenementCreation null,{$pnIdPlanche},3,687,'MetrixAutomation',0";
* Proj: appli * */ /*-- listeCommande=$pListeCommandes&idUser=$pnIdUser&idAtelier=$pnIdAtelier&idActiviteProd=$pnIdActiviteProd&quantite=$pnQuantite&hauteur=$pnHauteur&largeur=$pnLargeur&dateExp=$pdDateExp&idFtFeuille=$pnIdFtFeuille --*/ //-- verify status $file_status = fopen("/var/www/appli/smartgang/status/plancheauto.txt", "r+"); $status = fgets($file_status); fclose($file_status); if ($status == "Running") { include '/var/www/appli/lib/srv.php'; require_once '/var/www/appli/class/class.gang.php'; $data = 'rien'; $pnIdUtilisateur = 687; $ip = $_SERVER['SERVER_ADDR']; $objSmartgang = new smartgang(); $objSmartgang->logFile(basename(__FILE__), "GangOffset", "RUN", "/metrix/genPlanche.php"); $start = $objSmartgang->getmicrotime(); if (isset($_GET['exportPdf']) && $_GET['exportPdf'] != "") { $pbExportPdf = $_GET['exportPdf']; } else { $pbExportPdf = null; } if (isset($_GET['listeCommande']) && $_GET['listeCommande'] != "") { $pnIdMonteur = $_GET['idUser']; $pListeCommandes = $_GET['listeCommande']; $pnIDAtelier = $_GET['idAtelier']; $feuilleLargeur = $_GET['largeur']; $feuilleHauteur = $_GET['hauteur']; $pnIdActiviteProd = $_GET['idActiviteProd']; $pnQuantite = $_GET['quantite']; $pnIDPlancheFormat = $_GET['idFtFeuille'];
<?php /** Created by blond. * File: express/start.php * Date: 17/11/15 * */ $file_status = fopen("/var/www/appli/smartgang/status/expressFr.txt", "r+"); $status = fgets($file_status); fclose($file_status); if ($status == "Running") { include '/var/www/appli/lib/srv.php'; require_once '/var/www/appli/class/class.gang.php'; //-- Load class exa $exaprint = new smartgang(); $exaprint->logFile(basename(__FILE__), "script", "RUN", "express/start.php"); $start = $exaprint->getmicrotime(); $numberNew = null; $numberOld = 500; if (isset($_SERVER['QUERY_STRING'])) { $qp = explode('&', $_SERVER['QUERY_STRING']); } else { $qp = $_SERVER['argv']; //-- pour récup des params via le terminal array_shift($qp); //-- via le terminal, le premier élément est le nom du script => on dépile le 1er élément } if (is_array($qp)) { $nbCommandes = $qp[0]; $conDbo = $exaprint->getConDbo(); if (!$conDbo && isset($nbCommandes) && $nbCommandes > '0') {
* Proj: appli * */ //-- verify status $file_status = fopen("/var/www/appli/smartgang/status/rush.txt", "r+"); $status = fgets($file_status); fclose($file_status); if ($status == "Running") { include '/var/www/appli/lib/srv.php'; //-- load param environement $ip = $_SERVER['SERVER_ADDR']; require_once '/var/www/appli/class/class.gang.php'; //-- load class gang $objSmartgang = new smartgang(); //-- create object $objSmartgang->logFile(basename(__FILE__), "script", "RUN", "start /rush/start.php"); //-- log if (isset($_SERVER['QUERY_STRING'])) { $qp = explode('&', $_SERVER['QUERY_STRING']); } else { if (isset($_SERVER['argv'])) { $qp = $_SERVER['argv']; //-- pour récup des params via le terminal array_shift($qp); //-- via le terminal, le premier élément est le nom du script => on dépile le 1er élément } else { $qp[0] = null; } } $pnIdPlanche = "null"; $RequeteSQL = $pnIdCommande = $pdDate = $pnIDAtelier = $resu = null;
/** Created by blond. * File: mono/start.php * Date: 02/04/15 - 17:37 * Proj: appli * */ $file_status = fopen("/var/www/appli/smartgang/status/mononum.txt", "r+"); $status = fgets($file_status); fclose($file_status); if ($status == "Running") { include '/var/www/appli/lib/srv.php'; require_once '/var/www/appli/class/class.gang.php'; //-- Load class exa $exaprint = new smartgang(); $exaprint->logFile(basename(__FILE__), "script", "RUN", " <> - MONO - <>"); $start = $exaprint->getmicrotime(); $numberNew = $numberNew25 = null; $numberOld = $numberOld25 = 500; if (isset($_SERVER['QUERY_STRING'])) { $qp = explode('&', $_SERVER['QUERY_STRING']); } else { $qp = $_SERVER['argv']; //-- pour récup des params via le terminal array_shift($qp); //-- via le terminal, le premier élément est le nom du script => on dépile le 1er élément } if (is_array($qp)) { $nbCommandes = $qp[0]; $conDbo = $exaprint->getConDbo(); if (!$conDbo && isset($nbCommandes) && $nbCommandes > '0') {
* Created by PhpStorm. * User: blond * Date: 16/11/15 * Time: 20:03 */ if (isset($_GET['numero']) && $_GET['numero'] > 0) { //-- si un numero de planche est sup à 0 include '/var/www/appli/lib/srv.php'; //-- load param environement $ip = $_SERVER['SERVER_ADDR']; $pnIdPlanche = $_GET['numero']; include '/var/www/appli/lib/srv.php'; //-- load ip server require_once "/var/www/appli/class/class.gang.php"; //-- load class to work $obj = new smartgang(); $obj->logFile(basename(__FILE__), __FUNCTION__, "RUN", ": {$pnIdPlanche}"); // $obj->getConDbo(); // // $resu_info = $obj->getInfoPlanche($pnIdPlanche); // // $resu = $obj->getCopyXML($resu_info); $obj->logFile(basename(__FILE__), "script", "EXE ", $pnIdPlanche); $url = "http://{$ip}/appli/smartgang/metrix/generateMxml2.php?idplanche={$pnIdPlanche}"; $content = $obj->cURLexec($url); $obj->logFile(basename(__FILE__), "script", "OK ", $content); echo "1"; $obj->logFile(basename(__FILE__), __FUNCTION__, "END", ": {$pnIdPlanche}\n"); } else { echo "0"; }
/** * * Created by blond. * File: back.rush2.php * Date: 17/04/15 - 17:37 * Proj: appli * */ //-- define var $pnIdUtilisateur = 687; include '/var/www/appli/lib/srv.php'; //-- Load class exa require_once '/var/www/appli/class/class.gang.php'; $objSmartgang = new smartgang(); $objSmartgang->logFile(basename(__FILE__), "script", "RUN", "entreeftp/send.php"); //-- define start time $start = $objSmartgang->getmicrotime(); //-- conn to dbo $conDbo = $objSmartgang->getConDbo(); if (isset($_SERVER['QUERY_STRING'])) { $qp = explode('&', $_SERVER['QUERY_STRING']); } else { //pour récup des params via le terminal $qp = $_SERVER['argv']; //via le terminal, le premier élément est le nom du script => on dépile le 1er élément array_shift($qp); } if (isset($qp[0]) && $qp[0] > '0') { $pnIdPlanche = $qp[0]; if (!$conDbo) {
$id = $_POST['id']; } if (isset($_POST['exportPdf']) && $_POST['exportPdf'] != "") { $exportAsked = $_POST['exportPdf']; } if (isset($_POST['device']) && $_POST['device'] != "") { $deviceId = $_POST['device']; } if (isset($_POST['largeurFeuille']) && $_POST['largeurFeuille'] != "") { $largeurFeuille = $_POST['largeurFeuille']; } if (isset($_POST['hauteurFeuille']) && $_POST['hauteurFeuille'] != "") { $hauteurFeuille = $_POST['hauteurFeuille']; } // if(isset($_POST['bascule']) && $_POST['bascule'] != "") { $bascule = $_POST['bascule']; } $exaprint->logFile(basename(__FILE__), "script", "RUN", "Commande: " . $_POST['listIdCommande'] . " - ExportPDF: {$exportAsked} - {$hauteurFeuille} x {$largeurFeuille}"); foreach ($array_IdCommande as $clee => $pnIdCommande) { $q = "SELECT TOP 1\n TC.LargeurFluxPao AS LargeurFluxPao,\n TC.HauteurFluxPao AS HauteurFluxPao,\n TCL.Quantite AS Quantite,\n TFE.Commentaire AS CommFlux,\n TPFPT.LibelleTraduit AS FamilleDeProduction, \n TPOV.CodificationLongue AS CodificationLongue,\n TPOV.Codification AS Codification,\n CASE WHEN TPOV.Codification = '' THEN TPOV.CodificationLongue ELSE TPOV.Codification END AS codif\nFROM\n dbo.TBL_COMMANDE AS TC\n LEFT OUTER JOIN dbo.TBL_COMMANDE_LIGNE AS TCL ON TC.IDCommande = TCL.IDCommande\n LEFT OUTER JOIN dbo.TBL_PRODUIT_FAMILLE_PRODUCTION_TRAD AS TPFPT ON TPFPT.IDProduitFamilleProduction = TCL.IDProduitFamilleProduction AND TPFPT.IDLangue = 1\n LEFT OUTER JOIN dbo.TBL_FLUX_EVENEMENT AS TFE ON TFE.IDCommande = TC.IDCommande AND TFE.IDFluxEvenementType = 30\n \n LEFT OUTER JOIN dbo.TBL_PRODUIT ON TCL.IDProduit = dbo.TBL_PRODUIT.IDProduit\n\n LEFT OUTER JOIN TBL_PRODUIT_TL_OPTION_PRODUIT AS TPTOP ON TPTOP.IDProduit = TBL_PRODUIT.IDProduit\n LEFT OUTER JOIN TBL_COMMANDE_LIGNE_TL_OPTION_PRODUIT AS TCLTOP ON (TCL.IDCommandeLigne = TCLTOP.IDCommandeLigne)\n LEFT OUTER JOIN TBL_PRODUIT_TL_PRODUIT_OPTION_VALEUR_PRODUIT_OPTION_FAMILLE_PRODUIT AS TPTPOVPOFP\n LEFT OUTER JOIN TBL_PRODUIT_OPTION_VALEUR_TRAD AS TPOVT ON (TPOVT.IDProduitOptionValeur = TPTPOVPOFP.IDProduitOptionValeur AND TPOVT.IDLangue = 1)\n LEFT OUTER JOIN TBL_PRODUIT_OPTION_VALEUR AS TPOV\n LEFT OUTER JOIN TBL_PRODUIT_OPTION AS TPO\n LEFT OUTER JOIN TBL_PRODUIT_OPTION_TRAD AS TPOT ON (TPOT.IDProduitOption = TPO.IDProduitOption AND TPOT.IDLangue = 1)\n ON (TPO.IDProduitOption = TPOV.IDProduitOption)\n ON (TPOV.IDProduitOptionValeur = TPTPOVPOFP.IDProduitOptionValeur)\n ON (TPTPOVPOFP.IDProduitTLProduitOptionValeurProduitOptionFamilleProduit = TPTOP.IDProduitTLProduitOptionValeurProduitOptionFamilleProduit AND TPTPOVPOFP.Actif = 1)\n\nWHERE\n TC.EstAnnule = '0'\n AND TC.EstSuspendu = 0\n AND TPO.IDProduitOption = 75\n AND TC.IDCommande = {$pnIdCommande}"; $exaprint->getConDbo(); $info_commande = $exaprint->execMsSql($q); $id = $suff . "-" . $info_commande[0]->codif; $commFlux = $info_commande[0]->CommFlux; $array_filename = explode('|', $commFlux); $fileName = $array_filename[2]; $arrayProduct[] = array("Name" => $fileName, "ContentFile" => "/Volumes/Chef_de_fab_v2/z_A-MONTER/" . $info_commande[0]->FamilleDeProduction . "/" . $fileName, "FinishedTrimHeight" => $info_commande[0]->HauteurFluxPao, "FinishedTrimWidth" => $info_commande[0]->LargeurFluxPao, "ID" => "{$pnIdCommande}", "Type" => "Flat", "RequiredQuantity" => $info_commande[0]->Quantite, "DisplayColor" => array("RGBColorRef" => array("rRef" => "Ref_200")), "ComponentPool" => array(array("Component" => array("Active" => "True", "FinishedGrain" => "Same", "ID" => "{$fileName}", "Priority" => "5", "RequestedNumberOut" => "1", "StockRef" => array("rRef" => "Ref_stock_paper")))), "PagePool" => array("PageDefaults" => array("BleedBottom" => $bleed, "BleedLeft" => $bleed, "BleedRight" => $bleed, "BleedTop" => $bleed), "Page" => array(array("Folio" => "Recto", "Number" => "1"), array("Folio" => "Verso", "Number" => "2")))); $arrayLayout[] = array("rRef" => "{$fileName}"); } $arrayBascule = array(array("Side" => "1", "PressRef" => array("rRef" => "Ref_23"))); if ($bascule == 'Sheetwise') { $arrayBascule = array(array("Side" => "1", "PressRef" => array("rRef" => "Ref_23")), array("Side" => "2", "PressRef" => array("rRef" => "Ref_23"))); }