/**
* @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}");
}
* Date: 17/11/15 - 17:37
* 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) {
<?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");
}
<?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'];
* Proj: appli
*
*/
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
* File: solo/start.php
* 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') {
<?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') {
/**
* @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}");
}
}
* Date: 17/09/16 - 16:44
* 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'];
<?php
include '/var/www/appli/lib/srv.php';
require_once "/var/www/appli/class/class.gang.php";
$exaprint = new smartgang();
$linkToFile = null;
$_GET['linkToFile'] = "/Volumes/mnt/raid1/datas/Production/Chef_de_fab_v2/MetrixExport/Listes/mxml/2016-10-01/ebx161001162251-135 DM.mxml";
if (isset($_GET['linkToFile']) && count($_GET['linkToFile']) > '0') {
$linkToFile = $_GET['linkToFile'];
$mxml = simplexml_load_file($linkToFile);
// $exaprint->printr($mxml);
// $exaprint->printr($mxml->ResourcePool->RGBColor['Blue']);
foreach ($mxml->Project->LayoutPool->Layout as $key => $Layout) {
$SheetsRequired = $Layout['SheetsRequired'];
$PrintingMethod = $Layout['PrintingMethod'];
//Stock sheet
$StockSheetRef = $Layout->StockSheetRef['rRef'];
foreach ($mxml->ResourcePool->Stock->StockSheet as $val => $donnee) {
if (strval($StockSheetRef) == strval($donnee['ID'])) {
$Height = $donnee['Height'];
$Width = $donnee['Width'];
}
}
//Component
$ComponentRef = array();
$ComponentRef[] = $Layout->ComponentRefPool->ComponentRef['rRef'];
$exaprint->printr($ComponentRef);
}
}
* File: rush/start.php
* Date: 02/04/15 - 17:37
* 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;
}
}
<?php
/** 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();
* 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";
}
<?php
/**
*
* 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];
<?php
if (isset($_POST['listIdCommande']) && count($_POST['listIdCommande']) > '0') {
include '/var/www/appli/lib/srv.php';
require_once "/var/www/appli/class/class.gang.php";
$exaprint = new smartgang();
$start = $exaprint->getmicrotime();
$suff = "ebx" . date('ymdHis');
$folder = date('Y-m-d');
$exportAsked = "non";
$deviceId = "Speedmaster 102";
$bleed = "2";
$largeurFeuille = "102";
$hauteurFeuille = "72";
$bascule = "Sheetwise";
$arrayProduct = $arrayLayout = array();
$array_IdCommande = explode(',', $_POST['listIdCommande']);
if (isset($_POST['id']) && $_POST['id'] != "") {
$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'];
