public function getDataTableSuiviPlanning($args) { $where = null; $pnIdLangue = $_SESSION['IDLANGUE']; $pnIdSociete = $_SESSION['FBX_USER_SOCIETE_ID']; // if ($_SESSION['FBX_USER_SU'] == '1' ) { if(isset($args['IDSociete']) && $args['IDSociete'] > '0' ) $where .= "AND T7.IDSociete = '{$args['IDSociete']}'"; } // else { $where .= "AND T7.IDSociete = '{$_SESSION['FBX_USER_SOCIETE_ID']}'"; } $this->_template = "table/tableSuiviPlanning.twig"; if ($args['IDSecteur'] > "0") { $where .= "AND T7.IDSecteur = '{$args['IDSecteur']}'"; } if ($args['IDMachine'] > "0") { $where .= "AND T1.IDMachine = '{$args['IDMachine']}'"; } if ($args['Dossier'] != "") { $where .= "AND T3.Dossier = '{$args['Dossier']}'"; } if ($args['Ref'] != "") { $where .= "AND T3.Ref LIKE '%{$args['Ref']}%'"; } $q = "SELECT\n T1.IDDossierDeFab_tl_element_tl_machine\n , T1.IDMachine\n , T3.Dossier\n , T4.Nom AS NomElement\n , T5.Nom AS NomMachine\n , T3.IDDossierDeFab\n , T3.DateExpedition\n , IFNULL(T6.Ordre,999) AS Ordre\n , T2.Quantite\n , T8.Nom AS NomImpression\n , T11.Nom AS NomSecteur\n , T7.IDSecteur\n , T13.NbTour\n , T13.NbCalage\n , T7.CadenceTourMin\n , T7.CalageMin\n , T7.CalageFeuilles\n , T7.GachePour1000Feuilles\n# , ( T13.NbCalage * T7.CalageFeuilles ) AS NbFeuillesCalage\n# , ( ( T2.Quantite / 1000 ) * T7.GachePour1000Feuilles ) AS NbFeuilleGache\n , ( T2.Quantite + ( ( T2.Quantite / 1000 ) * T7.GachePour1000Feuilles ) + ( T13.NbCalage * T7.CalageFeuilles ) ) AS NbTotalFeuillesAreserver\n , ( ( T2.Quantite + ( ( T2.Quantite / 1000 ) * T7.GachePour1000Feuilles ) + ( T13.NbCalage * T7.CalageFeuilles ) ) * T13.NbTour ) AS NbTotalTours\n# , ( T7.CalageMin * T13.NbCalage ) AS TmpCalageEnMinutes\n# , ( ( ( T2.Quantite * T13.NbTour ) / T7.CadenceTourMin ) * 60 ) AS TmpRouleEnMinutes\n , ( ( ( ( T2.Quantite * T13.NbTour ) / T7.CadenceTourMin ) * 60 ) + ( T7.CalageMin * T13.NbCalage ) ) AS tmpTotalEnMin\nFROM\n TBL_DOSSIER_DE_FAB_TL_ELEMENT_TL_MACHINE AS T1\n LEFT OUTER JOIN TBL_DOSSIER_DE_FAB_TL_ELEMENT AS T2 ON T1.IDDossierDeFab_tl_element = T2.IDDossierDeFab_tl_element AND T2.EstSupp = '0'\n LEFT OUTER JOIN TBL_DOSSIER_DE_FAB AS T3 ON T3.IDDossierDeFab = T2.IDDossierDeFab #AND T3.EstSupp = '0'\n LEFT OUTER JOIN TBL_ELEMENT_TRAD AS T4 ON T4.IDElement = T2.IDElement AND T4.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_MACHINE_TRAD AS T5 ON T5.IDMachine = T1.IDMachine AND T5.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_PLANNING_TL_ELEMENT_TL_MACHINE AS T6 ON T6.IDDossierDeFab_tl_element_tl_machine = T1.IDDossierDeFab_tl_element_tl_machine AND T6.EstSupp = '0'\n LEFT OUTER JOIN TBL_MACHINE AS T7 ON T7.IDMachine = T1.IDMachine AND T7.EstSupp = '0' AND T7.IDSociete = '{$pnIdSociete}'\n LEFT OUTER JOIN TBL_IMPRESSION_TRAD AS T8 ON T8.IDImpression = T1.IDImpression AND T8.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_SECTEUR_TRAD AS T11 ON T11.IDSecteur = T7.IDSecteur AND T11.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_SECTEUR AS T12 ON T12.IDSecteur = T7.IDSecteur AND T12.EstSupp = '0' AND T12.IDSociete = '{$pnIdSociete}'\n LEFT OUTER JOIN TBL_IMPRESSION AS T13 ON T13.IDImpression = T8.IDImpression AND T13.EstSupp = '0' AND T13.IDSociete = '{$pnIdSociete}'\n LEFT OUTER JOIN TBL_ELEMENT AS T14 ON T14.IDElement = T2.IDElement AND T14.EstSupp = '0' AND T14.IDSociete = '{$pnIdSociete}'\nWHERE\n T1.EstSupp = '0' AND T3.EstSupp = '0'\n AND (SELECT TT1.IDFicheDeProd FROM TBL_FICHE_DE_PROD AS TT1 WHERE TT1.IDElement = T2.IDElement AND TT1.IDMachine = T1.IDMachine AND TT1.IDDossierDeFab = T3.IDDossierDeFab AND TT1.EstSupp = '0' LIMIT 0,1) IS NULL\n {$where}\nORDER BY\n T12.Ordre\n , T7.Ordre\n , IFNULL(T6.Ordre,999)\n , T3.DateExpedition\n , T3.IDDossierDeFab\n , T14.Ordre"; $data_planning = \fbx\DBmysql::getInstance()->getSelectData($q); $this->getWrLog($q, "suivi Planning", __FUNCTION__, __FILE__); $this->_data = array("data_planning" => $data_planning, "OUT" => $args, "Q" => $q); }
public function imp($args) { $pnIdDossierDeFab_tl_element = null; $data_dossier = $q_dossier = $pnIdDossierDeFab = null; $data_dossierTlOption = $q_dossierTlOption = null; $data_dossierTlElement = $q_dossierTlElement = null; $data_dossierTlElementTlOption = $q_dossierTlElementTlOption = null; $data_fiche = $q_fiche = null; $data_ficheTlCode = $q_ficheTlCode = null; $q_dossierTlElementTlMachine = $data_dossierTlElementTlMachine = null; echo '<script type="text/javascript">$(function(){$("#mainNavBar").prop("hidden",true);})</script>'; //mainNavBar echo '<script type="text/javascript">$(function(){$("#chrono").prop("hidden",true);})</script>'; if (isset($args['Dossier']) && $args['Dossier'] > '0') { $data_dossier = \fbx\DBmysql::getInstance()->getSelectData("SELECT IDDossierDeFab FROM TBL_DOSSIER_DE_FAB WHERE EstSupp = 0 AND IDMembreAdd != 1 AND Dossier = '{$args['Dossier']}'"); $pnIdDossierDeFab = $data_dossier[0]->IDDossierDeFab; } if (isset($args['IDDossierDeFab']) && $args['IDDossierDeFab'] > '0') { $pnIdDossierDeFab = $args['IDDossierDeFab']; } if ($pnIdDossierDeFab > '0') { $pnIdLangue = $_SESSION['IDLANGUE']; //_ SQL DOSSIER DE FAB $q_dossier = "SELECT\n T1.IDDossierDeFab,\n T1.Dossier,\n T1.Ref,\n T1.Commentaire,\n T1.DateExpedition,\n T1.Quantite,\n T1.EstPliable,\n T1.EstAmalgame,\n T1.NbOption,\n T1.NbElement,\n T1.LargeurOuvert,\n T1.LargeurFerme,\n T1.HauteurOuvert,\n T1.HauteurFerme,\n (SELECT CONCAT(TT1.Prenom,' ',TT1.Nom) FROM TBL_MEMBRE AS TT1 WHERE TT1.IDMembre = T1.IDMembreAdd) AS MembreAdd,\n T1.DateAdd,\n (SELECT CONCAT(TT2.Prenom,' ',TT2.Nom) FROM TBL_MEMBRE AS TT2 WHERE TT2.IDMembre = T1.IDMembreMaj) AS MembreMaj,\n T1.DateMaj\nFROM\n TBL_DOSSIER_DE_FAB AS T1\nWHERE\n T1.EstSupp = '0' AND T1.IDMembreAdd != 1\n AND T1.IDDossierDeFab = '{$pnIdDossierDeFab}'"; $data_dossier = \fbx\DBmysql::getInstance()->getSelectData($q_dossier); //_ SQL DOSSIER TL OPTION $q_dossierTlOption = "SELECT\n T1.IDOption AS ID,\n T2.Nom\nFROM\n TBL_DOSSIER_DE_FAB_TL_OPTION AS T1\n LEFT OUTER JOIN TBL_OPTION_TRAD AS T2 ON T1.IDOption = T2.IDOption AND T2.IDLangue = '{$pnIdLangue}'\nWHERE\n T1.EstSupp = '0' AND T1.IDMembreAdd != 1\n AND T1.IDDossierDeFab = '{$pnIdDossierDeFab}'"; $data_dossierTlOption = \fbx\DBmysql::getInstance()->getSelectData($q_dossierTlOption); //_ SQL DOSSIER TL ELEMENT $q_dossierTlElement = "SELECT\n T1.IDDossierDeFab_tl_element\n , T2.Nom AS NomElement\n , T1.Quantite AS QuantiteElement\n , T1.Commentaire AS CommentaireElement\n , T3.Nom AS NomImpression\n , T4.Nom AS NomSupport\n , T5.Nom AS NomFormat\nFROM\n TBL_DOSSIER_DE_FAB_TL_ELEMENT AS T1\n LEFT OUTER JOIN TBL_ELEMENT_TRAD AS T2 ON T1.IDElement = T2.IDElement AND T2.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_IMPRESSION_TRAD AS T3 ON T1.IDImpression = T3.IDImpression AND T3.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_SUPPORT_TRAD AS T4 ON T1.IDSupport = T4.IDSupport AND T4.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_FORMAT_TRAD AS T5 ON T1.IDFormat = T5.IDFormat AND T5.IDLangue = '{$pnIdLangue}'\nWHERE\n T1.EstSupp = '0' AND T1.IDMembreAdd != 1\n AND T1.IDDossierDeFab = '{$pnIdDossierDeFab}'\nORDER BY\n T2.IDElement"; $data_dossierTlElement = \fbx\DBmysql::getInstance()->getSelectData($q_dossierTlElement); //_ SQL DOSSIER TL ELEMENT TL OTHER foreach ($data_dossierTlElement as $key => $value) { $pnIdDossierDeFab_tl_element = $value->IDDossierDeFab_tl_element; //_ SQL DOSSIER TL ELEMENT TL OPTION $q_dossierTlElementTlOption = "SELECT\n T1.IDOption\n , T2.Nom\nFROM\n TBL_DOSSIER_DE_FAB_TL_ELEMENT_TL_OPTION AS T1\n LEFT OUTER JOIN TBL_OPTION_TRAD AS T2 ON T1.IDOption = T2.IDOption AND T2.IDLangue = '{$pnIdLangue}'\nWHERE\n T1.EstSupp = '0' AND T1.IDMembreAdd != 1\n AND T1.IDDossierDeFab_tl_element = '{$pnIdDossierDeFab_tl_element}'"; $data_dossierTlElementTlOption[] = \fbx\DBmysql::getInstance()->getSelectData($q_dossierTlElementTlOption); //_ SQL DOSSIER TL ELEMENT TL MACHINE $q_dossierTlElementTlMachine = "SELECT DISTINCT\n T1.IDMachine\n, T3.Nom AS NomMachine\n, T1.IDImpression\n, T6.Nom AS NomImpression\nFROM\n TBL_DOSSIER_DE_FAB_TL_ELEMENT_TL_MACHINE AS T1\n LEFT OUTER JOIN TBL_MACHINE AS T2 ON T1.IDMachine = T2.IDMachine AND T2.EstSupp = '0'\n LEFT OUTER JOIN TBL_MACHINE_TRAD AS T3 ON T3.IDMachine = T2.IDMachine AND T3.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_SECTEUR AS T5 ON T5.IDSecteur = T2.IDSecteur AND T5.EstSupp = '0'\n LEFT OUTER JOIN TBL_IMPRESSION_TRAD AS T6 ON T6.IDImpression = T1.IDImpression AND T6.IDLangue = '{$pnIdLangue}'\nWHERE\n T1.EstSupp = '0' AND T1.IDMembreAdd != 1\n AND T1.IDDossierDeFab_tl_element = '{$pnIdDossierDeFab_tl_element}'\nORDER BY\n T5.Ordre"; $data_dossierTlElementTlMachine[] = \fbx\DBmysql::getInstance()->getSelectData($q_dossierTlElementTlMachine); } //_ SQL FICHE DE PROD $q_fiche = "SELECT\n T1.IDFicheDeProd AS ID\n , T1.Quantite AS Quantite\n , (SELECT CONCAT(TT1.Prenom,' ',TT1.Nom) FROM TBL_MEMBRE AS TT1 WHERE TT1.IDMembre = T1.IDMembreAdd) AS MembreAdd\n , T1.DateAdd\n , T1.Commentaire\n , T2.Nom AS NomElement\n , T3.Nom AS NomImpression\n , T4.Nom AS NomSupport\n , T5.Nom AS NomFormat\n , T6.Nom AS NomSecteur\n , T7.Nom AS NomMachine\nFROM\n TBL_FICHE_DE_PROD AS T1\n LEFT OUTER JOIN TBL_ELEMENT_TRAD AS T2 ON T1.IDElement = T2.IDElement AND T2.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_IMPRESSION_TRAD AS T3 ON T1.IDImpression = T3.IDImpression AND T3.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_SUPPORT_TRAD AS T4 ON T1.IDSupport = T4.IDSupport AND T4.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_FORMAT_TRAD AS T5 ON T1.IDFormat = T5.IDFormat AND T5.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_SECTEUR_TRAD AS T6 ON T1.IDSecteur = T6.IDSecteur AND T6.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_MACHINE_TRAD AS T7 ON T1.IDMachine= T7.IDMachine AND T7.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_SECTEUR AS T8 ON T1.IDSecteur = T8.IDSecteur\n LEFT OUTER JOIN TBL_ELEMENT AS T9 ON T1.IDElement = T9.IDElement\nWHERE\n T1.EstSupp = '0' AND T1.IDMembreAdd != 1\n AND T1.IDDossierDeFab = '{$pnIdDossierDeFab}'\nORDER BY\n T8.Ordre\n , T9.Ordre"; $data_fiche = \fbx\DBmysql::getInstance()->getSelectData($q_fiche); //_ SQL FICHE TL CODE ERREUR foreach ($data_fiche as $clee => $valeur) { $pnIdFicheDeProd = $valeur->ID; $q_ficheTlCode = "SELECT\n T1.IDCodeErreur\n , T2.Nom\nFROM\n TBL_FICHE_DE_PROD_TL_CODE_ERREUR AS T1\n LEFT OUTER JOIN TBL_CODE_ERREUR_TRAD AS T2 ON T1.IDCodeErreur = T2.IDCodeErreur AND T2.IDLangue = '{$pnIdLangue}'\nWHERE\n T1.EstSupp = '0' AND T1.IDMembreAdd != 1\n AND T1.IDFicheDeProd = '{$pnIdFicheDeProd}'"; $data_ficheTlCode[] = \fbx\DBmysql::getInstance()->getSelectData($q_ficheTlCode); } if (is_array($data_dossier) && count($data_dossier) > 0) { $dossier = $data_dossier[0]->Dossier; echo '<script type="text/javascript">$(function(){document.title = "' . $dossier . '"})</script>'; } } $this->_data = array("OUT" => $args, "DATA_DOSSIER" => $data_dossier, "DATA_DOSSIER_TL_OPTION" => $data_dossierTlOption, "DATA_DOSSIER_TL_ELEMENT" => $data_dossierTlElement, "DATA_DOSSIER_TL_ELEMENT_TL_OPTION" => $data_dossierTlElementTlOption, "DATA_DOSSIER_TL_ELEMENT_TL_MACHINE" => $data_dossierTlElementTlMachine, "DATA_FICHE" => $data_fiche, "DATA_FICHE_TL_CODE_ERREUR" => $data_ficheTlCode); }
public function login($username, $password) { $q = "SELECT\n M.IDMembre AS IDMembre\nFROM\n TBL_MEMBRE AS M\nWHERE\n M.EstSupp = '0'\n AND M.EstActif = '1'\n AND M.Login LIKE '%{$username}%'\n AND M.Pwd = '{$password}'"; $data = \fbx\DBmysql::getInstance()->getSelectData($q); if (isset($data[0]->IDMembre) && $data[0]->IDMembre > 0) { $_SESSION['FBX_USER'] = $username; $out = 'True'; } else { $out = "False"; #echo '<script type="text/javascript">$(function(){getModalAlert("Identifiant ou mot de passe erroné");})</script>'; } return $out; }
public function getUpdatePwd($args) { $setClause = null; if (isset($args['Prenom']) && $args['Prenom'] != "") { $psPrenom = $args['Prenom']; $setClause .= "MEMBRE.Prenom = '{$psPrenom}',"; } if (isset($args['Nom']) && $args['Nom'] != "") { $psNom = $args['Nom']; $setClause .= "MEMBRE.Nom = '{$psNom}',"; } if (isset($args['Telephone']) && $args['Telephone'] != "") { $psTelephone = $args['Telephone']; $setClause .= "MEMBRE.Telephone = '{$psTelephone}',"; } if (isset($args['Email']) && $args['Email'] != "") { $psEmail = $args['Email']; $setClause .= "MEMBRE.Mail = '{$psEmail}',"; } if (isset($args['Login']) && $args['Login'] != "") { $psLogin = $args['Login']; $setClause .= "MEMBRE.Login = '******',"; } if (isset($args['Pwd']) && $args['Pwd'] != "") { $psPwd = $args['Pwd']; $setClause .= "MEMBRE.Pwd = '{$psPwd}',"; } if ($setClause != "") { $q = "UPDATE\n TBL_MEMBRE AS MEMBRE\nSET\n MEMBRE.DateMaj = NOW(),\n {$setClause}\n MEMBRE.IDMembreMaj = '{$_SESSION['FBX_USER_ID']}'\nWHERE\n MEMBRE.IDMembre = '{$_SESSION['FBX_USER_ID']}'"; $data = \fbx\DBmysql::getInstance()->getUpdateData($q); $this->getWrLog("{$q}", "", __FUNCTION__, __FILE__); if ($data > '0') { $this->_data = array("save" => "ok"); } } if (isset($args['IDLangue']) && $args['IDLangue'] > 0) { $pnIdLangue = intval($args['IDLangue']); $q = "SELECT L.CodeBCP AS CodeBCP , L.IDLangue FROM TBL_LANGUE AS L WHERE L.EstSupp = '0' AND L.IDLangue = '{$pnIdLangue}'"; $data = \fbx\DBmysql::getInstance()->getSelectData($q); $this->getWrLog("{$q}", "", __FUNCTION__, __FILE__); if (isset($data[0])) { unset($_SESSION['IDLANGUE']); $_SESSION['IDLANGUE'] = $data[0]->IDLangue; unset($_SESSION['languages']); $_SESSION['languages'] = $data[0]->CodeBCP; $this->_data = array("IdLangue" => $data[0]->IDLangue); // $this->printr($_SESSION); } } }
public function getDataTableStat($args) { $this->_template = "table/tableSuiviStat.twig"; $where = $nbJour = null; $pnIdLangue = $_SESSION['IDLANGUE']; if ($_SESSION['FBX_USER_SU'] != '1') { $pnIdSociete = $_SESSION['FBX_USER_SOCIETE_ID']; $where .= " AND T1.IDSociete = '{$pnIdSociete}'"; } else { if (isset($args['IDSociete']) && $args['IDSociete'] != '') { $pnIdSociete = $args['IDSociete']; $where .= " AND T1.IDSociete = '{$pnIdSociete}' AND T3.IDSociete = '{$pnIdSociete}'"; } } $q_secteur = "SELECT\n T1.IDSecteur AS ID\n ,T2.Nom\n ,T3.IDMachine\n ,T4.Nom AS NomMachine\nFROM\n TBL_SECTEUR AS T1\n LEFT OUTER JOIN TBL_SECTEUR_TRAD AS T2 ON T1.IDSecteur = T2.IDSecteur AND T2.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_MACHINE AS T3 ON T2.IDSecteur = T3.IDSecteur AND T3.EstSupp = '0'\n LEFT OUTER JOIN TBL_MACHINE_TRAD AS T4 ON T3.IDMachine = T4.IDMachine AND T4.IDLangue = '{$pnIdLangue}'\nWHERE\n T1.EstSupp = '0'\n {$where}\nORDER BY\n T1.IDSecteur"; $data_secteur = \fbx\DBmysql::getInstance()->getSelectData($q_secteur); // $this->getWrLog($q_secteur, "", __FUNCTION__, __FILE__); if (isset($args['DateBegin'])) { $date = \DateTime::createFromFormat('d/m/Y', $args['DateBegin']); if (is_object($date)) { $pdDateBegin = $date->format('Ymd'); } else { $pdDateBegin = ''; } $where .= " AND T1.DateAdd > {$pdDateBegin}"; } if (isset($args['DateEnd'])) { $date = \DateTime::createFromFormat('d/m/Y', $args['DateEnd']); if (is_object($date)) { $pdDateEnd = $date->format('Ymd'); } else { $pdDateEnd = ''; } $where .= " AND T1.DateAdd < {$pdDateEnd}"; } $q = "SELECT\n T1.IDSecteur,\n T1.IDMachine,\n T1.IDMembreAdd,\n SUM(T1.Quantite) AS QuantiteFeuilles,\n SUM(T2.NbCalage) AS NbCalage,\n SUM(T2.NbTour*T1.Quantite) AS NbTour,\n COUNT(T1.IDFicheDeProd) AS nbFicheDeProd,\n (SELECT TT1.Nom FROM TBL_MEMBRE AS TT1 WHERE TT1.IDMembre = T1.IDMembreAdd) AS NomMembre,\n (SELECT TT2.Prenom FROM TBL_MEMBRE AS TT2 WHERE TT2.IDMembre = T1.IDMembreAdd) AS PrenomMembre,\n (SELECT TT3.Nom FROM TBL_SECTEUR_TRAD AS TT3 WHERE TT3.IDSecteur = T1.IDSecteur AND TT3.IDLangue = '{$pnIdLangue}') AS NomSecteur,\n (SELECT TT4.Nom FROM TBL_MACHINE_TRAD AS TT4 WHERE TT4.IDMachine = T1.IDMachine AND TT4.IDLangue = '1') AS NomMachine\nFROM\n TBL_FICHE_DE_PROD AS T1\n LEFT JOIN TBL_IMPRESSION AS T2 ON T1.IDImpression = T2.IDImpression AND T2.EstSupp = '0'\nWHERE\n T1.EstSupp = 0 AND T1.IDMembreAdd != 1\n {$where}\nGROUP BY\n T1.IDSecteur,\n T1.IDMachine,\n T1.IDMembreAdd"; $data_stat = \fbx\DBmysql::getInstance()->getSelectData($q); // $this->getWrLog($q, "SQL STAT", __FUNCTION__, __FILE__); foreach ($data_stat as $key => $value) { $pnIdMembreAdd = $value->IDMembreAdd; $q_nbJour = "SELECT\n COUNT(T1.IDFicheDeProd) AS total\nFROM\n TBL_FICHE_DE_PROD AS T1\nWHERE\n T1.IDMembreAdd = '{$pnIdMembreAdd}'\n /*AND fichesprod.datecrea_fichesprod BETWEEN '' AND ''*/\nGROUP BY\n TO_DAYS(T1.DateAdd)"; $data_nbJour = \fbx\DBmysql::getInstance()->getSelectData($q_nbJour); $nbJour[$pnIdMembreAdd] = count($data_nbJour); } $this->_data = array("OUT" => $args, "DATA_SECTEUR" => $data_secteur, "DATA_STAT" => $data_stat, "DATA_NBJOUR" => $nbJour, "Q" => $q); }
public function getExportPlanning($args) { $where = null; $_SESSION["dataArray"] = array(); $pnIdLangue = $_SESSION['IDLANGUE']; $pnIdSociete = $_SESSION['FBX_USER_SOCIETE_ID']; // if ($_SESSION['FBX_USER_SU'] == '1' ) { if(isset($args['IDSociete']) && $args['IDSociete'] > '0' ) $where .= "AND T7.IDSociete = '{$args['IDSociete']}'"; } // else { $where .= "AND T7.IDSociete = '{$_SESSION['FBX_USER_SOCIETE_ID']}'"; } if ($args['IDSecteur'] > "0") { $where .= "AND T7.IDSecteur = '{$args['IDSecteur']}'"; } if ($args['IDMachine'] > "0") { $where .= "AND T1.IDMachine = '{$args['IDMachine']}'"; } $q = "SELECT\n T1.IDDossierDeFab_tl_element_tl_machine\n , T1.IDMachine\n , T3.Dossier\n , T4.Nom AS NomElement\n , T5.Nom AS NomMachine\n , T3.IDDossierDeFab\n , T3.DateExpedition\n , IFNULL(T6.Ordre,999) AS Ordre\n , T2.Quantite\n , T8.Nom AS NomImpression\n , T11.Nom AS NomSecteur\n , T7.IDSecteur\n , T13.NbTour\n , T13.NbCalage\n , T7.CadenceTourMin\n , T7.CalageMin\n , T7.CalageFeuilles\n , T7.GachePour1000Feuilles\nFROM\n TBL_DOSSIER_DE_FAB_TL_ELEMENT_TL_MACHINE AS T1\n LEFT OUTER JOIN TBL_DOSSIER_DE_FAB_TL_ELEMENT AS T2 ON T1.IDDossierDeFab_tl_element = T2.IDDossierDeFab_tl_element AND T2.EstSupp = '0'\n LEFT OUTER JOIN TBL_DOSSIER_DE_FAB AS T3 ON T3.IDDossierDeFab = T2.IDDossierDeFab AND T3.EstSupp = '0'\n LEFT OUTER JOIN TBL_ELEMENT_TRAD AS T4 ON T4.IDElement = T2.IDElement AND T4.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_MACHINE_TRAD AS T5 ON T5.IDMachine = T1.IDMachine AND T5.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_PLANNING_TL_ELEMENT_TL_MACHINE AS T6 ON T6.IDDossierDeFab_tl_element_tl_machine = T1.IDDossierDeFab_tl_element_tl_machine AND T6.EstSupp = '0'\n LEFT OUTER JOIN TBL_MACHINE AS T7 ON T7.IDMachine = T1.IDMachine AND T7.EstSupp = '0' AND T7.IDSociete = '{$pnIdSociete}'\n LEFT OUTER JOIN TBL_IMPRESSION_TRAD AS T8 ON T8.IDImpression = T1.IDImpression AND T8.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_SECTEUR_TRAD AS T11 ON T11.IDSecteur = T7.IDSecteur AND T11.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_SECTEUR AS T12 ON T12.IDSecteur = T7.IDSecteur AND T12.EstSupp = '0' AND T12.IDSociete = '{$pnIdSociete}'\n LEFT OUTER JOIN TBL_IMPRESSION AS T13 ON T13.IDImpression = T8.IDImpression AND T13.EstSupp = '0' AND T13.IDSociete = '{$pnIdSociete}'\nWHERE\n T1.EstSupp = '0'\n AND (SELECT TT1.IDFicheDeProd FROM TBL_FICHE_DE_PROD AS TT1 WHERE TT1.IDElement = T2.IDElement AND TT1.IDMachine = T1.IDMachine AND TT1.IDDossierDeFab = T3.IDDossierDeFab AND TT1.EstSupp = '0' LIMIT 0,1) IS NULL\n {$where}\nORDER BY\n T12.Ordre\n , T7.Ordre\n , IFNULL(T6.Ordre,999)\n , T3.DateExpedition\n , T3.IDDossierDeFab"; $data_planning = \fbx\DBmysql::getInstance()->getSelectData($q); // $this->_data = $data_planning; foreach ($data_planning as $key => $value) { $_SESSION["dataArray"][$key] = array("Machine" => $value->NomMachine, "Dossier" => $value->Dossier, "Element" => $value->NomElement, "Type" => $value->NomImpression, "Quantite" => $value->Quantite, "Ordre" => $value->Ordre); } }
public function getDossierWithIDDossierDeFab($args) { $pnIdDossierDeFab = $args['IDDossierDeFab']; $data = \fbx\DBmysql::getInstance()->getSelectData("SELECT Dossier FROM TBL_DOSSIER_DE_FAB WHERE IDDossierDeFab = '{$pnIdDossierDeFab}' AND EstSupp = 0"); $this->_data = $data[0]->Dossier; }
public function getInsertReclame($args) { // $this->printr($args); $pnIdUser = $_SESSION['FBX_USER_ID']; $pnIdSociete = $_SESSION['FBX_USER_SOCIETE_ID']; if (isset($args['DossierModal']) && $args['DossierModal'] != '') { $psDossier = $args['DossierModal']; if (isset($args['RefModal']) && $args['RefModal'] != '') { $psRef = $args['RefModal']; } else { $psRef = ''; } if (isset($args['QuantiteModal']) && $args['QuantiteModal'] > '0') { $pnQuantite = intval($args['QuantiteModal']); } else { $pnQuantite = 'null'; } if (isset($args['DemandeModal']) && $args['DemandeModal'] > '0') { $psDemande = $args['DemandeModal']; } else { $psDemande = ''; } if (isset($args['DateExpeditionModal'])) { $date = \DateTime::createFromFormat('d/m/Y', $args['DateExpeditionModal']); if (is_object($date)) { $pdDateExpedition = "'" . $date->format('Ymd') . "'"; } else { $pdDateExpedition = 'null'; } } else { $pdDateExpedition = 'null'; } $q_insertReclame = "\nINSERT INTO TBL_RECLAME\n (IDMembreAdd, DateAdd, Dossier, Ref, Quantite, DateExpedition, Demande, IDSociete)\nVALUES\n ('{$pnIdUser}',NOW(),'{$psDossier}','{$psRef}',{$pnQuantite},{$pdDateExpedition},'{$psDemande}','{$pnIdSociete}')"; $data_Reclame = \fbx\DBmysql::getInstance()->getInsertData($q_insertReclame); $this->getWrLog($q_insertReclame, "{$data_Reclame}", __FUNCTION__, __FILE__); } $this->getDataTableSuiviReclame($args); }
public function getUpdateOption($args) { if ($_SESSION['FBX_USER_SU'] != '1') { $pnIDSociete = $_SESSION['FBX_USER_SOCIETE_ID']; } else { if (isset($args['IDSociete']) && ($args['IDSociete'] != '0' && $args['IDSociete'] != '')) { $pnIDSociete = $args['IDSociete']; } else { $pnIDSociete = ''; } } if (isset($args['NomOption']) && $args['NomOption'] != '') { $psNom = $args['NomOption']; } else { $psNom = 'null'; } if (isset($args['Ordre']) && $args['Ordre'] != '') { $pnOrdre = $args['Ordre']; } else { $pnOrdre = '99'; } if (isset($args['EstActif']) && $args['EstActif'] != '') { $pbEstActif = $args['EstActif']; } else { $pbEstActif = '0'; } if (isset($args['IDOption']) && $args['IDOption'] != '') { $pnIDOption = $args['IDOption']; } else { $pnIDOption = 'null'; } $pnIdUser = $_SESSION['FBX_USER_ID']; $q = "UPDATE\n TBL_OPTION AS TBL\nSET\n TBL.DateMaj = NOW(),\n TBL.IDMembreMaj = '{$pnIdUser}',\n TBL.EstActif = '{$pbEstActif}',\n TBL.Ordre = '{$pnOrdre}',\n TBL.IDSociete = '{$pnIDSociete}'\nWHERE\n TBL.IDOption = '{$pnIDOption}'"; \fbx\DBmysql::getInstance()->getUpdateData($q); $this->getWrLog($q, "", __FUNCTION__, __FILE__); $q = "UPDATE\n TBL_OPTION_TRAD AS TBL\nSET\n TBL.Nom = '{$psNom}'\nWHERE\n TBL.IDOption = '{$pnIDOption}'"; $data = \fbx\DBmysql::getInstance()->getUpdateData($q); $this->getWrLog($q, "", __FUNCTION__, __FILE__); $this->_data = $data; }
public function getUpdateMembre($args) { if (isset($args['Nom']) && $args['Nom'] != '') { $psNom = $args['Nom']; } else { $psNom = 'null'; } if (isset($args['Prenom']) && $args['Prenom'] != '') { $psPrenom = $args['Prenom']; } else { $psPrenom = 'null'; } if (isset($args['IDFonction']) && $args['IDFonction'] != '') { $pnIDFonction = $args['IDFonction']; } else { $pnIDFonction = '0'; } if (isset($args['Login']) && $args['Login'] != '') { $psLogin = $args['Login']; } else { $psLogin = '******'; } if (isset($args['Pwd']) && $args['Pwd'] != '') { $psPwd = $args['Pwd']; } else { $psPwd = 'null'; } if (isset($args['IDLangue']) && $args['IDLangue'] != '') { $pnIDLangue = $args['IDLangue']; } else { $pnIDLangue = '0'; } if (isset($args['Telephone']) && $args['Telephone'] != '') { $psTelephone = $args['Telephone']; } else { $psTelephone = 'null'; } if (isset($args['Mail']) && $args['Mail'] != '') { $psMail = $args['Mail']; } else { $psMail = 'null'; } if (isset($args['EstActif']) && $args['EstActif'] != '') { $pbActif = $args['EstActif']; } else { $pbActif = '0'; } if (isset($args['IDMembre']) && $args['IDMembre'] != '') { $pnIDMembre = $args['IDMembre']; } else { $pnIDMembre = '0'; } if (isset($args['IDSociete']) && $args['IDSociete'] != '') { $pnIDSociete = $args['IDSociete']; } else { $pnIDSociete = 'null'; } $pnIdUser = $_SESSION['FBX_USER_ID']; if ($pnIDMembre > '0') { $q = "UPDATE\n TBL_MEMBRE AS MEMBRE\nSET\n MEMBRE.DateMaj = NOW(),\n MEMBRE.IDMembreMaj = '{$pnIdUser}',\n MEMBRE.Nom = '{$psNom}',\n MEMBRE.Prenom = '{$psPrenom}',\n MEMBRE.IDFonction = '{$pnIDFonction}',\n MEMBRE.Login = '******',\n MEMBRE.Pwd = '{$psPwd}',\n MEMBRE.IDLangue = '{$pnIDLangue}',\n MEMBRE.Telephone = '{$psTelephone}',\n MEMBRE.Mail = '{$psMail}',\n MEMBRE.EstActif = '{$pbActif}',\n MEMBRE.IDSociete = '{$pnIDSociete}'\nWHERE\n MEMBRE.IDMembre = '{$pnIDMembre}'"; $data = \fbx\DBmysql::getInstance()->getUpdateData($q); $this->getWrLog($q, "", __FUNCTION__, __FILE__); //__CREATE QRcode if (isset($pnIDMembre) && $pnIDMembre > 0) { $filename = "membre-{$pnIDMembre}"; $path = $_SESSION['QR']['PATH']; $link = $_SESSION['QR']['IMG'] . "/membre"; $ref = $_SESSION['QR']['MEMBRE'] . "?login={$psLogin}&password={$psPwd}&languages=fr_FR"; $url = "{$path}?{$filename}&{$link}&{$ref}"; $this->cURLexec($url); // $this->getWrLog($url, "UP QRcode membre", __FUNCTION__, __FILE__); } //__CREATE CODE BARRE $path = $_SESSION['BARCODE']['PATH']; $link = $_SESSION['BARCODE']['IMG'] . "/membre"; $filename = "barcodeMembre-{$pnIDMembre}"; // $contenu_barcode = "'$psLogin'$psPwd"; $contenu_barcode = "(){$pnIDMembre}()"; $url = "{$path}?{$contenu_barcode}&{$filename}&{$link}"; $this->cURLexec($url); // $this->getWrLog("UP CodeBarre membre", "$url", __FUNCTION__, __FILE__); $this->_data = $data; } }
private function getPrefsAffichage() { $where = null; if ($_SESSION['FBX_USER_SU'] != '1') { $where .= "AND T1.IDSociete = '{$_SESSION['FBX_USER_SOCIETE_ID']}'"; } //-- Préférences de pagination $sql = "SELECT\n MRP.IDpage AS IDpage ,\n MRP.NbRow AS NbRow\nFROM\n TBL_MEMBRE_ROW_PAGE AS MRP\nWHERE\n MRP.IDmembre = '{$this->_nIdUtilisateur}'"; $data = \fbx\DBmysql::getInstance()->getSelectData($sql); foreach ($data as $key => $value) { $_SESSION['PrefsNbPages'][$value->IDpage] = $value->NbRow; } //-- droit des pages $qPage = "SELECT\n T1.IDPage AS IDpage\n , CASE WHEN ISNULL(T3.IDFonction) THEN '0' ELSE '1' END AS permitPage\n ,T1.Classe\nFROM\n TBL_PAGE AS T1\n LEFT OUTER JOIN TBL_PAGE_TRAD AS T2 ON T1.IDPage = T2.IDPage AND T2.IDLangue = 1\n LEFT OUTER JOIN TBL_FONCTION_TL_PAGE AS T3 ON T1.IDPage = T3.IDPage AND T3.EstSupp = '0' AND T3.IDFonction = '{$_SESSION['FBX_USER_FONCTION_ID']}'\nWHERE\n T1.EstSupp = '0'\n #{$where}\n AND T1.IDSociete = '{$_SESSION['FBX_USER_SOCIETE_ID']}'\nORDER BY\n T1.Ordre"; $data_permitPage = \fbx\DBmysql::getInstance()->getSelectData($qPage); foreach ($data_permitPage as $key => $value) { $_SESSION['PrefsPagesPermit'][$value->IDpage] = $value->permitPage; $_SESSION['Classe'][$value->Classe] = $value->permitPage; } //-- droit des menus $qMenu = "SELECT\n T1.IDMenu AS IDmenu\n , CASE WHEN ISNULL(T3.IDGroupe) THEN '0' ELSE '1' END AS permitMenu\nFROM\n TBL_MENU AS T1\n LEFT OUTER JOIN TBL_MENU_TRAD AS T2 ON T1.IDMenu = T2.IDMenu AND T2.IDLangue = 1\n LEFT OUTER JOIN TBL_GROUPE_TL_MENU AS T3 ON T1.IDMenu = T3.IDMenu AND T3.EstSupp = '0' AND T3.IDGroupe = '{$_SESSION['FBX_USER_GROUPE_ID']}'\nWHERE\n T1.EstSupp = '0'\n #{$where}\n AND T1.IDSociete = '{$_SESSION['FBX_USER_SOCIETE_ID']}'\nORDER BY\n T1.Ordre"; $data_permitMenu = \fbx\DBmysql::getInstance()->getSelectData($qMenu); foreach ($data_permitMenu as $key => $value) { $_SESSION['PrefsMenusPermit'][$value->IDmenu] = $value->permitMenu; } // if (isset($data[0]->IDSociete)) $pnIDSociete = $data[0]->IDSociete; else $pnIDSociete = '0'; $pnIDSociete = $_SESSION['FBX_USER_SOCIETE_ID']; $q = "SELECT * FROM TBL_SLOGAN WHERE EstSupp = '0' AND IDSociete = '{$pnIDSociete}'"; $data_slogan = \fbx\DBmysql::getInstance()->getSelectData($q); if (isset($data_slogan[0]->Slogan)) { $_SESSION['Slogan'] = $data_slogan[0]->Slogan; } else { $_SESSION['Slogan'] = "FBX"; } }
public function getLiaisonSecteurTlImpression($args) { $pnIdUser = $_SESSION['FBX_USER_ID']; $data_Secteur_tl_impression = $data = $q = null; if (isset($args['IDImpression']) && $args['IDImpression'] != '') { $pnIdImpression = $args['IDImpression']; } else { $pnIdImpression = '0'; } if (isset($args['IDSecteur']) && $args['IDSecteur'] != '') { $pnIdSecteur = $args['IDSecteur']; } else { $pnIdSecteur = '0'; } if ($args['Actif'] == '0') { $q = "SELECT TBL.IDSecteur_tl_impression AS ID FROM TBL_SECTEUR_TL_IMPRESSION AS TBL WHERE TBL.EstSupp = '0' AND TBL.IDSecteur = {$pnIdSecteur} AND TBL.IDImpression = {$pnIdImpression}"; $data_Secteur_tl_impression = \fbx\DBmysql::getInstance()->getSelectData($q); $pnIdSecteur_tl_impression = $data_Secteur_tl_impression[0]->ID; $q = "UPDATE\n TBL_SECTEUR_TL_IMPRESSION AS TBL\nSET\n TBL.IDMembreSupp='{$pnIdUser}',\n TBL.DateSupp=NOW(),\n TBL.EstSupp = '1'\nWHERE\n TBL.IDSecteur_tl_impression = {$pnIdSecteur_tl_impression}"; $data = \fbx\DBmysql::getInstance()->getUpdateData($q); $this->getWrLog($q, $data, __FUNCTION__, __FILE__); } else { if ($args['Actif'] == '1') { $q = "INSERT INTO TBL_SECTEUR_TL_IMPRESSION ( DateAdd, IDMembreAdd, IDImpression, IDSecteur ) VALUES ( NOW(),'{$pnIdUser}','{$pnIdImpression}','{$pnIdSecteur}' )"; $data = \fbx\DBmysql::getInstance()->getInsertData($q); $this->getWrLog($q, "", __FUNCTION__, __FILE__); } } $this->_data = array("data_Secteur_tl_impression" => $data, "Q" => $q); }
public function getUpdateFicheDeProd($args) { $pnIdUser = $_SESSION['FBX_USER_ID']; if (isset($args['IDFicheDeProd']) && $args['IDFicheDeProd'] > 0) { $pnIdFicheDeProd = $args['IDFicheDeProd']; } else { $pnIdFicheDeProd = ''; } if (isset($args['Quantite']) && $args['Quantite'] > 0) { $pnQuantite = $args['Quantite']; } else { $pnQuantite = ''; } if (isset($args['IDImpression']) && $args['IDImpression'] > 0) { $pnIdImpression = $args['IDImpression']; } else { $pnIdImpression = ''; } if (isset($args['IDCode1']) && $args['IDCode1'] > 0) { $pnIdCode1 = $args['IDCode1']; } else { $pnIdCode1 = ''; } if (isset($args['OldCode1']) && $args['OldCode1'] > 0) { $pnOldCode1 = $args['OldCode1']; } else { $pnOldCode1 = ''; } if (isset($args['IDCode2']) && $args['IDCode2'] > 0) { $pnIdCode2 = $args['IDCode2']; } else { $pnIdCode2 = ''; } if (isset($args['OldCode2']) && $args['OldCode2'] > 0) { $pnOldCode2 = $args['OldCode2']; } else { $pnOldCode2 = ''; } if (isset($args['Commentaire']) && $args['Commentaire'] != '') { $psCommentaire = $args['Commentaire']; } else { $psCommentaire = ''; } $this->getWrLog("IDFicheDeProd", "{$pnIdFicheDeProd}", __FUNCTION__, __FILE__); if ($pnIdFicheDeProd != '' && $pnIdFicheDeProd > '0') { $q = "UPDATE TBL_FICHE_DE_PROD AS T1\nSET\n T1.Quantite = '{$pnQuantite}',\n T1.IDImpression = '{$pnIdImpression}',\n T1.Commentaire = '{$psCommentaire}',\n T1.DateMaj = NOW(),\n T1.IDMembreMaj = '{$pnIdUser}'\nWHERE\n T1.EstSupp = '0'\n AND T1.IDFicheDeProd = '{$pnIdFicheDeProd}'"; $data = \fbx\DBmysql::getInstance()->getUpdateData($q); $this->getWrLog($q, "{$data}", __FUNCTION__, __FILE__); for ($k = 1; $k <= 2; $k++) { if ($args['IDCode' . $k] != '') { $pnIdCode = $args['IDCode' . $k]; $pnOldIdCode = $args['OldCode' . $k]; $q_IdCode = "SELECT\n T1.IDFicheDeProd_tl_code_erreur AS id\nFROM\n TBL_FICHE_DE_PROD_TL_CODE_ERREUR AS T1\nWHERE\n T1.EstSupp = '0'\n AND T1.IDFicheDeProd = '{$pnIdFicheDeProd}'\n AND T1.IDCodeErreur = '{$pnOldIdCode}'"; $data_Idcode = \fbx\DBmysql::getInstance()->getSelectData($q_IdCode); if (is_array($data_Idcode) && count($data_Idcode) > '0') { $resuCode = $data_Idcode[0]->id; // $this->getWrLog($q_IdCode, "$resuCode", __FUNCTION__, __FILE__); if ($args['IDCode' . $k] > '0') { $q_update = "UPDATE TBL_FICHE_DE_PROD_TL_CODE_ERREUR AS T1\nSET\n T1.DateMaj = NOW(),\n T1.IDMembreMaj = '{$pnIdUser}',\n T1.IDCodeErreur = '{$pnIdCode}'\nWHERE\n T1.EstSupp = '0'\n AND T1.IDFicheDeProd = '{$pnIdFicheDeProd}'\n AND T1.IDCodeErreur = '{$pnOldIdCode}'"; $data_update = \fbx\DBmysql::getInstance()->getUpdateData($q_update); $this->getWrLog($q_update, "{$data_update}", __FUNCTION__, __FILE__); } else { $q_delete = "UPDATE TBL_FICHE_DE_PROD_TL_CODE_ERREUR AS T1 #EstSupp = '1'\nSET\n T1.DateSupp = NOW(),\n T1.IDMembreSupp = '{$pnIdUser}',\n T1.EstSupp = '1'\nWHERE\n T1.IDFicheDeProd = '{$pnIdFicheDeProd}'\n AND T1.IDCodeErreur = '{$pnOldIdCode}'"; $data_delete = \fbx\DBmysql::getInstance()->getUpdateData($q_delete); $this->getWrLog($q_delete, "{$data_delete}", __FUNCTION__, __FILE__); } } else { $q_insert = "INSERT INTO TBL_FICHE_DE_PROD_TL_CODE_ERREUR\n (IDMembreAdd, DateAdd, IDFicheDeProd, IDCodeErreur)\nVALUES\n ('{$pnIdUser}',NOW(),'{$pnIdFicheDeProd}','{$pnIdCode}')"; $data_insert = \fbx\DBmysql::getInstance()->getInsertData($q_insert); $this->getWrLog($q_insert, "{$data_insert}", __FUNCTION__, __FILE__); } } } } }
public function getListeOptionTlOption($args) { $plIDoption = '0'; $data_ID = null; $pnIdLangue = $_SESSION['IDLANGUE']; $this->_template = "elements/elementsSelect.twig"; if (isset($args['listeIdOption']) && $args['listeIdOption'] != '') { $plIDoption = $args['listeIdOption']; } if (isset($args['idoption']) && $args['idoption'] != '0') { $data_ID = explode('.:.', $args['idoption']); } if ($plIDoption != '0') { $q = "SELECT\n T2.Nom,\n T1.IDOption AS ID\nFROM\n TBL_OPTION AS T1\n LEFT OUTER JOIN TBL_OPTION_TRAD AS T2\n ON T1.IDOption = T2.IDOption AND T2.IDLangue = '{$pnIdLangue}'\nWHERE\n T1.EstSupp = '0'\n AND T1.EstActif = '1'\n AND T1.IDOption IN ({$plIDoption})\nORDER BY\n T1.Ordre"; // $this->getWrLog($q, "---ICI---", __FUNCTION__, __FILE__); $data_Liste = \fbx\DBmysql::getInstance()->getSelectData($q); } else { $data_Liste = $this->getListeOptionTrad(); } $this->_data = array("data_Liste" => $data_Liste, "data_ID" => $data_ID, "OUT" => $args); }
public function getDataPlanning($args) { $pnIdLangue = $_SESSION['IDLANGUE']; if (isset($args['IDMachine']) && $args['IDMachine'] > "0") { $pnIdMachine = intval($args['IDMachine']); } else { $pnIdMachine = null; } if (is_numeric($pnIdMachine) && $pnIdMachine != '') { $this->_template = "elements/modalPlanning.twig"; $q_planning = "SELECT\n T3.Dossier\n , T4.Nom AS NomElement\n , T5.Nom AS NomMachine\n , T2.IDElement\n , T3.IDDossierDeFab\n , T1.IDDossierDeFab_tl_element\nFROM\n TBL_DOSSIER_DE_FAB_TL_ELEMENT_TL_MACHINE AS T1\n LEFT OUTER JOIN TBL_DOSSIER_DE_FAB_TL_ELEMENT AS T2 ON T1.IDDossierDeFab_tl_element = T2.IDDossierDeFab_tl_element AND T2.EstSupp = '0'\n LEFT OUTER JOIN TBL_DOSSIER_DE_FAB AS T3 ON T3.IDDossierDeFab = T2.IDDossierDeFab #AND T3.EstSupp = '0'\n LEFT OUTER JOIN TBL_ELEMENT_TRAD AS T4 ON T4.IDElement = T2.IDElement AND T4.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_MACHINE_TRAD AS T5 ON T5.IDMachine = T1.IDMachine AND T5.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_PLANNING_TL_ELEMENT_TL_MACHINE AS T6 ON T6.IDDossierDeFab_tl_element_tl_machine = T1.IDDossierDeFab_tl_element_tl_machine AND T6.EstSupp = '0'\n LEFT OUTER JOIN TBL_ELEMENT AS T14 ON T14.IDElement = T2.IDElement AND T14.EstSupp = '0'\nWHERE\n T1.EstSupp = '0' AND T3.EstSupp = '0'\n AND (SELECT TT1.IDFicheDeProd FROM TBL_FICHE_DE_PROD AS TT1 WHERE TT1.IDElement = T2.IDElement AND TT1.IDMachine = T1.IDMachine AND TT1.IDDossierDeFab = T3.IDDossierDeFab AND TT1.EstSupp = '0' LIMIT 0,1) IS NULL\n AND T1.IDMachine = '{$pnIdMachine}'\nORDER BY\n IFNULL(T6.Ordre,999)\n , T3.DateExpedition\n , T3.IDDossierDeFab\n , T14.Ordre"; $data_planning = \fbx\DBmysql::getInstance()->getSelectData($q_planning); $this->_data = array("OUT" => $args, "DATA_PLANNING" => $data_planning); } }
public function getInsertDataDossierDeFab($args) { if (isset($args['Dossier']) && $args['Dossier'] != '') { $psDossier = $args['Dossier']; } else { $psDossier = ''; } $q_select = "SELECT IDDossierDeFab FROM TBL_DOSSIER_DE_FAB WHERE Dossier = '{$psDossier}' AND EstSupp = '0'"; $data_select = \fbx\DBmysql::getInstance()->getSelectData($q_select); // $this->printr($q_select); // $this->printr($data_select); if (count($data_select) == '0') { $pnIdDossierDeFab = $pnIdDossierDeFabTlElement = $pnIdElementTlOption = null; $insert_option = $jnsert_element = $jnsert_element_TL_option = $jnsert_element_TL_machine = null; $pnIdUser = $_SESSION['FBX_USER_ID']; if (isset($args['Ref']) && $args['Ref'] != '') { $psRef = $args['Ref']; } else { $psRef = ''; } if (isset($args['Quantite']) && $args['Quantite'] > '0') { $pnQuantite = intval($args['Quantite']); } else { $pnQuantite = '0'; } if (isset($args['Commentaire']) && $args['Commentaire'] != '') { $psCommentaire = $args['Commentaire']; } else { $psCommentaire = ''; } if (isset($args['NbElement']) && $args['NbElement'] > '0') { $pnNbElement = intval($args['NbElement']); } else { $pnNbElement = '0'; } if (isset($args['NbOption']) && $args['NbOption'] > '0') { $pnNbOption = intval($args['NbOption']); } else { $pnNbOption = '0'; } if (isset($args['NbMachine']) && $args['NbMachine'] > '0') { $pnNbMachine = intval($args['NbMachine']); } else { $pnNbMachine = '0'; } if (isset($args['Pliage']) && $args['Pliage'] != '') { $pbPliage = '1'; } else { $pbPliage = '0'; } if (isset($args['Amalgame']) && $args['Amalgame'] != '') { $pbAmalgame = '1'; } else { $pbAmalgame = '0'; } if (isset($args['LargeurOuvert']) && $args['LargeurOuvert'] > '0') { $pnLargeurOuvert = intval($args['LargeurOuvert']); } else { $pnLargeurOuvert = '0'; } if (isset($args['HauteurOuvert']) && $args['HauteurOuvert'] > '0') { $pnHauteurOuvert = intval($args['HauteurOuvert']); } else { $pnHauteurOuvert = '0'; } if (isset($args['LargeurFerme']) && $args['LargeurFerme'] > '0') { $pnLargeurFerme = intval($args['LargeurFerme']); } else { $pnLargeurFerme = '0'; } if (isset($args['HauteurFerme']) && $args['HauteurFerme'] > '0') { $pnHauteurFerme = intval($args['HauteurFerme']); } else { $pnHauteurFerme = '0'; } if (isset($args['NbPose']) && $args['NbPose'] > '0') { $pnNbPose = intval($args['NbPose']); } else { $pnNbPose = '1'; } if (isset($args['DateExpedition'])) { $date = \DateTime::createFromFormat('d/m/Y', $args['DateExpedition']); if (is_object($date)) { $pdDateExpedition = $date->format('Ymd'); } else { $pdDateExpedition = ''; } } else { $pdDateExpedition = ''; } //__ INSERT INTO TBL_DOSSIER_DE_FAB $q_ins_dossier = "INSERT INTO TBL_DOSSIER_DE_FAB\n (IDMembreAdd,DateAdd,Dossier,Ref,Quantite,Commentaire,DateExpedition,NbOption,NbElement,EstAmalgame,EstPliable,LargeurOuvert,HauteurOuvert,LargeurFerme,HauteurFerme,NbPose,NbMachine)\nVALUES\n ('{$pnIdUser}',NOW(),'{$psDossier}','{$psRef}','{$pnQuantite}','{$psCommentaire}','{$pdDateExpedition}','{$pnNbOption}','{$pnNbElement}','{$pbAmalgame}','{$pbPliage}','{$pnLargeurOuvert}','{$pnHauteurOuvert}','{$pnLargeurFerme}','{$pnHauteurFerme}','{$pnNbPose}','{$pnNbMachine}')"; $pnIdDossierDeFab = \fbx\DBmysql::getInstance()->getInsertData($q_ins_dossier); $this->getWrLog($q_ins_dossier, "pnIdDossierDeFab => {$pnIdDossierDeFab}", __FUNCTION__, __FILE__); //__CREATE QRcode $path = $_SESSION['QR']['PATH']; $link = $_SESSION['QR']['IMG'] . "/dossier"; $ref = $_SESSION['QR']['DOSSIER'] . "?action=getDataDossierDeFabForFiche&IDDossierDeFab={$pnIdDossierDeFab}"; $url = "{$path}?dossier-{$pnIdDossierDeFab}&{$link}&{$ref}"; $this->cURLexec($url); $this->getWrLog("QRcode Dossier", "{$url}", __FUNCTION__, __FILE__); //__CREATE CODE BARRE $path = $_SESSION['BARCODE']['PATH']; $link = $_SESSION['BARCODE']['IMG'] . "/dossier"; $contenu_barcode = "%%" . $psDossier; $url = "{$path}?{$contenu_barcode}&dossier-{$pnIdDossierDeFab}&{$link}"; $this->cURLexec($url); $this->getWrLog("CodeBarre Dossier", "{$url}", __FUNCTION__, __FILE__); //__ INSERT INTO TBL_DOSSIER_DE_FAB_TL_OPTION for ($i = 1; $i <= $pnNbOption; $i++) { if (isset($args['Option' . $i]) && $args['Option' . $i] > '0') { $insert_option[] = "('{$pnIdDossierDeFab}','" . intval($args['Option' . $i]) . "','{$pnIdUser}',NOW())"; } } if (count($insert_option) >= 1) { $q_ins_dossier_option = "INSERT INTO TBL_DOSSIER_DE_FAB_TL_OPTION\n (IDDossierDeFab, IDOption, IDMembreAdd, DateAdd)\nVALUES\n " . implode(',', $insert_option) . ""; $pnIdDossierDeFabTlOption = \fbx\DBmysql::getInstance()->getInsertData($q_ins_dossier_option); $this->getWrLog($q_ins_dossier_option, "pnIdDossierDeFabTlOption=>{$pnIdDossierDeFabTlOption}", __FUNCTION__, __FILE__); } //__ INSERT INTO TBL_DOSSIER_DE_FAB_TL_ELEMENT for ($j = 1; $j <= $pnNbElement; $j++) { if (isset($args['Element' . $j]) && $args['Element' . $j] > '0') { $q_ins_dossier_element = "INSERT INTO TBL_DOSSIER_DE_FAB_TL_ELEMENT\n (IDMembreAdd, DateAdd,IDDossierDeFab, IDElement, Quantite, IDSupport, IDFormat, Commentaire)\nVALUES\n ('{$pnIdUser}',NOW(),'{$pnIdDossierDeFab}','" . $args['Element' . $j] . "','" . intval($args['Quantite' . $j]) . "','" . intval($args['Support' . $j]) . "','" . intval($args['Format' . $j]) . "','" . $args['Commentaire' . $j] . "')"; $pnIdDossierDeFabTlElement = \fbx\DBmysql::getInstance()->getInsertData($q_ins_dossier_element); $this->getWrLog($q_ins_dossier_element, "pnIdDossierDeFabTlElement=>{$pnIdDossierDeFabTlElement}", __FUNCTION__, __FILE__); //__ QUERY ELEMENT_TL_OPTION for ($i = 1; $i <= $pnNbOption; $i++) { if (isset($pnIdDossierDeFabTlElement) && $pnIdDossierDeFabTlElement > '0') { if (isset($args['Option' . $j . 'Element' . $i]) && $args['Option' . $j . 'Element' . $i] > '0') { $jnsert_element_TL_option[] = "('{$pnIdUser}',NOW(),'{$pnIdDossierDeFabTlElement}','" . $args['Option' . $j . 'Element' . $i] . "')"; } } } //__ QUERY ELEMENT_TL_MACHINE for ($x = 1; $x <= $pnNbMachine; $x++) { if (isset($pnIdDossierDeFabTlElement) && $pnIdDossierDeFabTlElement > '0') { if (isset($args['Element' . $j . 'Machine' . $x]) && $args['Element' . $j . 'Machine' . $x] > '0') { if (isset($args['Element' . $j . 'MachineImpression' . $x]) && $args['Element' . $j . 'MachineImpression' . $x] > '0') { $pnElementTlMachineImpression = $args['Element' . $j . 'MachineImpression' . $x]; } else { $pnElementTlMachineImpression = '0'; } $pnElementTlMachine = $args['Element' . $j . 'Machine' . $x]; $jnsert_element_TL_machine[] = "('{$pnIdUser}',NOW(),'{$pnIdDossierDeFabTlElement}','{$pnElementTlMachine}','{$pnElementTlMachineImpression}')"; } } } //__CREATE CODE BARRE $path = $_SESSION['BARCODE']['PATH']; $link = $_SESSION['BARCODE']['IMG'] . "/dossier"; $contenu_barcode = "((" . $pnIdDossierDeFab . "((" . $args['Element' . $j] . ""; $url = "{$path}?{$contenu_barcode}&dossiertlement-{$pnIdDossierDeFabTlElement}&{$link}"; $this->cURLexec($url); } } //__ INSERT INTO TBL_DOSSIER_DE_FAB_TL_ELEMENT_TL_OPTION if (count($jnsert_element_TL_option) >= 1) { $q_ins_dossier_element_tl_option = "INSERT INTO TBL_DOSSIER_DE_FAB_TL_ELEMENT_TL_OPTION\n (IDMembreAdd, DateAdd, IDDossierDeFab_tl_element, IDOption)\nVALUES\n " . implode(',', $jnsert_element_TL_option) . ""; $pnIdElementTlOption = \fbx\DBmysql::getInstance()->getInsertData($q_ins_dossier_element_tl_option); $this->getWrLog($q_ins_dossier_element_tl_option, "pnIdElementTlOption=>{$pnIdElementTlOption}", __FUNCTION__, __FILE__); } //__ INSERT INTO TBL_DOSSIER_DE_FAB_TL_ELEMENT_TL_MACHINE if (count($jnsert_element_TL_machine) >= 1) { $q_ins_dossier_element_tl_machine = "INSERT INTO\nTBL_DOSSIER_DE_FAB_TL_ELEMENT_TL_MACHINE\n (IDMembreAdd, DateAdd, IDDossierDeFab_tl_element, IDMachine, IDImpression)\nVALUES\n " . implode(',', $jnsert_element_TL_machine) . ""; $pnIdElementTlMachine = \fbx\DBmysql::getInstance()->getInsertData($q_ins_dossier_element_tl_machine); $this->getWrLog($q_ins_dossier_element_tl_machine, "pnIdElementTlMachine=>{$pnIdElementTlMachine}", __FUNCTION__, __FILE__); } } else { $this->_data = array("OUT" => $args); echo '<script type="text/javascript">$(function(){verifDescriptionDossier();getElement();getModalAlert("Ce dossier existe déjà");})</script>'; } }
$_SESSION['IP'] = "{$config->dev->ip}"; $_SESSION['PUBLIC_PATH'] = "{$config->path->public}"; //-- définition de la langue if (isset($_POST["languages"]) && !isset($_GET["languages"])) { $language = $_SESSION["languages"] = $_POST["languages"]; } elseif (isset($_GET["languages"]) && !isset($_POST["languages"])) { $language = $_SESSION["languages"] = $_GET["languages"]; } elseif (isset($_SESSION["languages"])) { $language = $_SESSION["languages"]; } else { $language = $_SESSION["languages"] = "fr_FR"; } //--Load Config \fbx\Config::init(); //--Load DBmysql \fbx\DBmysql::init(); //-- définition du user if (isset($_POST["login"]) && !isset($_GET["login"])) { $_SESSION["loginUsr"] = $_POST["login"]; } elseif (isset($_GET["login"]) && !isset($_POST["login"])) { $_SESSION["loginUsr"] = $_GET["login"]; } \fbx\Fab\Utilisateur::init(); putenv("LC_MESSAGES=" . $language); setlocale(LC_MESSAGES, $language . ".utf8"); if (function_exists('bindtextdomain') && function_exists('textdomain')) { bindtextdomain("messages", APPLICATION_ROOT . "/locale"); textdomain("messages"); bind_textdomain_codeset("messages", "UTF-8"); } $app = new \Slim\Slim(array('view' => new \Slim\Views\Twig(), 'templates.path' => '../templates'));
public function getDataReclameToFillModalEdit($args) { if (isset($args['IDReclame']) && $args['IDReclame'] > 0) { $pnIdReclame = $args['IDReclame']; $q = "\nSELECT\n IDReclame\n , Dossier\n , Ref\n , Demande\n , Quantite\n , DATE_FORMAT(DateExpedition,'%d/%m/%Y') AS DateExpedition\nFROM\n TBL_RECLAME\nWHERE\n EstSupp = '0'\n AND IDReclame = '{$pnIdReclame}'"; $data_reclame = \fbx\DBmysql::getInstance()->getSelectData($q); $this->_data = array("DATA_RECLAME" => $data_reclame); } }
public function getDataDossierDeFabForFiche($args) { $pnIdDossierDeFab_tl_element = null; $data_dossier = $q_dossier = $pnIdDossierDeFab = null; $data_dossierTlOption = $q_dossierTlOption = null; $data_dossierTlElement = $q_dossierTlElement = null; $data_dossierTlElementTlOption = $q_dossierTlElementTlOption = null; $data_fiche = $q_fiche = null; $data_ficheTlCode = $q_ficheTlCode = null; echo '<script type="text/javascript">$(function(){$("#mainNavBar").prop("hidden",true);})</script>'; //mainNavBar echo '<script type="text/javascript">$(function(){$("#chrono").prop("hidden",true);})</script>'; //chrono // $where = $whereSociete = $whereSociete2 = $whereSecteur = $pdDateExpBegin = $pdDateCreaBegin = $pdDateExpEnd = $pdDateCreaEnd = null; // $pnIdLangue = $_SESSION['IDLANGUE']; // // echo '<script type="text/javascript"> // $(function(){ // $(".collapse").collapse("toggle"); // $("#divJumbotron").prop("hidden",true); // }) //</script>'; // // if (isset($args['searchDateDossierExpBegin']) && $args['searchDateDossierExpBegin']) $pdDateExpBegin = $this->getConvertDate($args['searchDateDossierExpBegin']); // if (isset($args['searchDateDossierExpEnd']) && $args['searchDateDossierExpEnd']) $pdDateExpEnd = $this->getConvertDate($args['searchDateDossierExpEnd']); // if ($pdDateExpBegin != '' && $pdDateExpEnd != '') $where .= " AND T1.DateExpedition BETWEEN '$pdDateExpBegin' AND '$pdDateExpEnd'"; // elseif ($pdDateExpBegin != '' && $pdDateExpEnd == '') $where .= " AND T1.DateExpedition >= '$pdDateExpBegin'"; // elseif ($pdDateExpBegin == '' && $pdDateExpEnd != '') $where .= " AND T1.DateExpedition <= '$pdDateExpEnd'"; // // if (isset($args['searchDateDossierCreaBegin']) && $args['searchDateDossierCreaBegin']) $pdDateCreaBegin = $this->getConvertDate($args['searchDateDossierCreaBegin']); // if (isset($args['searchDateDossierCreaEnd']) && $args['searchDateDossierCreaEnd']) $pdDateCreaEnd = $this->getConvertDate($args['searchDateDossierCreaEnd']); // if ($pdDateCreaBegin != '' && $pdDateCreaEnd != '') $where .= " AND T1.DateAdd BETWEEN '$pdDateCreaBegin' AND '$pdDateCreaEnd 23:59:59'"; // elseif ($pdDateCreaBegin != '' && $pdDateCreaEnd == '') $where .= " AND T1.DateAdd >= '$pdDateCreaBegin'"; // elseif ($pdDateCreaBegin == '' && $pdDateCreaEnd != '') $where .= " AND T1.DateAdd <= '$pdDateCreaEnd 23:59:59'"; // // if ( isset($args['Dossier']) && $args['Dossier'] != '' ) $where .= " AND T1.Dossier = '{$args['Dossier']}'"; // if ( isset($args['Ref']) && $args['Ref'] != '' ) $where .= " AND T1.Ref LIKE '%{$args['Ref']}%'"; // if ($_SESSION['FBX_USER_SU'] != '1' ) { $whereSociete = " AND TT1.IDSociete = '{$_SESSION['FBX_USER_SOCIETE_ID']}'"; } // if ($_SESSION['FBX_USER_SU'] != '1' ) { $whereSociete2 = " AND TT2.IDSociete = '{$_SESSION['FBX_USER_SOCIETE_ID']}'"; } // if ( isset($args['SelectSecteur']) && $args['SelectSecteur'] >0 ) $where .= " AND (SELECT TT3.IDSecteur FROM TBL_FICHE_DE_PROD AS TT3 WHERE TT3.IDDossierDeFab = T1.IDDossierDeFab AND TT3.EstSupp = '0' ORDER BY TT3.DateAdd DESC LIMIT 0,1 ) = '{$args['SelectSecteur']}'"; // // if ( isset($args['typeDossier']) && $args['typeDossier'] >0 ){ // $pnTypeDossier = $args['typeDossier']; // switch ($pnTypeDossier){ // case 1: // $where .= " AND T1.EstPliable = '0' AND T1.EstAmalgame = '0'"; // break; // case 2: // $where .= " AND T1.EstPliable = '1'"; // break; // case 3: // $where .= " AND T1.EstAmalgame = '1'"; // break; // default: // break; // } // } // // $q_dossier = "SELECT // T1.IDDossierDeFab AS ID, // T1.Dossier AS Nom, // T1.Ref AS Ref, // T1.Quantite AS Quantite, // T1.Commentaire AS Commentaire, // T1.DateExpedition AS DateExpedition, // T1.NbOption AS NbOption, // T1.NbElement AS NbElement, // T1.IDMembreAdd, // T1.DateAdd, // T1.DateMaj, // (SELECT CONCAT(TT1.Prenom,' ', TT1.Nom) FROM TBL_MEMBRE AS TT1 WHERE TT1.IDMembre = T1.IDMembreAdd $whereSociete) AS NomMembre, // (SELECT CONCAT(TT2.Prenom,' ', TT2.Nom) FROM TBL_MEMBRE AS TT2 WHERE TT2.IDMembre = T1.IDMembreMaj $whereSociete2) AS NomMembreMaj, // (SELECT TT3.IDSecteur FROM TBL_FICHE_DE_PROD AS TT3 WHERE TT3.IDDossierDeFab = T1.IDDossierDeFab AND TT3.EstSupp = '0' ORDER BY DateAdd DESC LIMIT 0,1 ) AS IDSecteur, // T1.EstAmalgame, // T1.EstPliable, // T1.LargeurFerme, // T1.HauteurFerme, // T1.LargeurOuvert, // T1.HauteurOuvert //FROM // TBL_DOSSIER_DE_FAB AS T1 //WHERE // T1.EstSupp = '0' // $where //ORDER BY // T1.IDDossierDeFab DESC"; // $data_dossier = \fbx\DBmysql::getInstance()->getSelectData($q_dossier); // // $q_option = "SELECT // T1.IDDossierDeFab_tl_option AS ID, // T1.IDDossierDeFab AS IDDossierDeFab, // T1.IDOption AS IDOption, // T2.Nom AS NomOption //FROM // TBL_DOSSIER_DE_FAB_TL_OPTION AS T1 // LEFT OUTER JOIN TBL_OPTION_TRAD AS T2 ON T1.IDOption = T2.IDOption AND T2.IDLangue = '$pnIdLangue' //WHERE // T1.EstSupp = '0'"; // $data_option = \fbx\DBmysql::getInstance()->getSelectData($q_option); // // $this->_data = array( // "data_dossier"=>$data_dossier, // "data_option"=>$data_option, // "OUT"=>$args, // "Q"=>$q_dossier // ); if (isset($args['IDDossierDeFab']) && $args['IDDossierDeFab'] > '0') { $pnIdDossierDeFab = $args['IDDossierDeFab']; } if (isset($args['DossierDeFab']) && $args['DossierDeFab'] > '0') { $pnIdDossierDeFab = $this->getIdDossierDeFab($args['DossierDeFab']); } //$this->printr($pnIdDossierDeFab); if ($pnIdDossierDeFab > '0') { // $pnIdDossierDeFab = $args['IDDossierDeFab']; $pnIdLangue = $_SESSION['IDLANGUE']; $q_dossier = "SELECT\n T1.IDDossierDeFab,\n T1.Dossier,\n T1.Ref,\n T1.Commentaire,\n T1.DateExpedition,\n T1.Quantite,\n T1.EstPliable,\n T1.EstAmalgame,\n T1.NbOption,\n T1.NbElement,\n T1.LargeurOuvert,\n T1.LargeurFerme,\n T1.HauteurOuvert,\n T1.HauteurFerme,\n (SELECT CONCAT(TT1.Prenom,' ',TT1.Nom) FROM TBL_MEMBRE AS TT1 WHERE TT1.IDMembre = T1.IDMembreAdd) AS MembreAdd,\n T1.DateAdd,\n (SELECT CONCAT(TT2.Prenom,' ',TT2.Nom) FROM TBL_MEMBRE AS TT2 WHERE TT2.IDMembre = T1.IDMembreMaj) AS MembreMaj,\n T1.DateMaj\nFROM\n TBL_DOSSIER_DE_FAB AS T1\nWHERE\n T1.EstSupp = '0' AND T1.IDMembreAdd != 1\n AND T1.IDDossierDeFab = '{$pnIdDossierDeFab}'"; $data_dossier = \fbx\DBmysql::getInstance()->getSelectData($q_dossier); $q_dossierTlOption = "SELECT\n T1.IDOption AS ID,\n T2.Nom\nFROM\n TBL_DOSSIER_DE_FAB_TL_OPTION AS T1\n LEFT OUTER JOIN TBL_OPTION_TRAD AS T2 ON T1.IDOption = T2.IDOption AND T2.IDLangue = '{$pnIdLangue}'\nWHERE\n T1.EstSupp = '0' AND T1.IDMembreAdd != 1\n AND T1.IDDossierDeFab = '{$pnIdDossierDeFab}'"; $data_dossierTlOption = \fbx\DBmysql::getInstance()->getSelectData($q_dossierTlOption); $q_dossierTlElement = "SELECT\n T1.IDDossierDeFab_tl_element\n , T2.Nom AS NomElement\n , T1.Quantite AS QuantiteElement\n , T1.Commentaire AS CommentaireElement\n , T3.Nom AS NomImpression\n , T4.Nom AS NomSupport\n , T5.Nom AS NomFormat\nFROM\n TBL_DOSSIER_DE_FAB_TL_ELEMENT AS T1\n LEFT OUTER JOIN TBL_ELEMENT_TRAD AS T2 ON T1.IDElement = T2.IDElement AND T2.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_IMPRESSION_TRAD AS T3 ON T1.IDImpression = T3.IDImpression AND T3.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_SUPPORT_TRAD AS T4 ON T1.IDSupport = T4.IDSupport AND T4.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_FORMAT_TRAD AS T5 ON T1.IDFormat = T5.IDFormat AND T5.IDLangue = '{$pnIdLangue}'\nWHERE\n T1.EstSupp = '0' AND T1.IDMembreAdd != 1\n AND T1.IDDossierDeFab = '{$pnIdDossierDeFab}'\nORDER BY\n T2.IDElement"; $data_dossierTlElement = \fbx\DBmysql::getInstance()->getSelectData($q_dossierTlElement); foreach ($data_dossierTlElement as $key => $value) { $pnIdDossierDeFab_tl_element = $value->IDDossierDeFab_tl_element; $q_dossierTlElementTlOption = "SELECT\n T1.IDOption\n , T2.Nom\nFROM\n TBL_DOSSIER_DE_FAB_TL_ELEMENT_TL_OPTION AS T1\n LEFT OUTER JOIN TBL_OPTION_TRAD AS T2 ON T1.IDOption = T2.IDOption AND T2.IDLangue = '{$pnIdLangue}'\nWHERE\n T1.EstSupp = '0' AND T1.IDMembreAdd != 1\n AND T1.IDDossierDeFab_tl_element = '{$pnIdDossierDeFab_tl_element}'"; $data_dossierTlElementTlOption[] = \fbx\DBmysql::getInstance()->getSelectData($q_dossierTlElementTlOption); } $q_fiche = "SELECT\n T1.IDFicheDeProd AS ID\n , T1.Quantite AS Quantite\n , (SELECT CONCAT(TT1.Prenom,' ',TT1.Nom) FROM TBL_MEMBRE AS TT1 WHERE TT1.IDMembre = T1.IDMembreAdd) AS MembreAdd\n , T1.DateAdd\n , T1.Commentaire\n , T2.Nom AS NomElement\n , T3.Nom AS NomImpression\n , T4.Nom AS NomSupport\n , T5.Nom AS NomFormat\n , T6.Nom AS NomSecteur\n , T7.Nom AS NomMachine\nFROM\n TBL_FICHE_DE_PROD AS T1\n LEFT OUTER JOIN TBL_ELEMENT_TRAD AS T2 ON T1.IDElement = T2.IDElement AND T2.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_IMPRESSION_TRAD AS T3 ON T1.IDImpression = T3.IDImpression AND T3.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_SUPPORT_TRAD AS T4 ON T1.IDSupport = T4.IDSupport AND T4.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_FORMAT_TRAD AS T5 ON T1.IDFormat = T5.IDFormat AND T5.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_SECTEUR_TRAD AS T6 ON T1.IDSecteur = T6.IDSecteur AND T6.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_MACHINE_TRAD AS T7 ON T1.IDMachine= T7.IDMachine AND T7.IDLangue = '{$pnIdLangue}'\n LEFT OUTER JOIN TBL_SECTEUR AS T8 ON T1.IDSecteur = T8.IDSecteur\n LEFT OUTER JOIN TBL_ELEMENT AS T9 ON T1.IDElement = T9.IDElement\nWHERE\n T1.EstSupp = '0' AND T1.IDMembreAdd != 1\n AND T1.IDDossierDeFab = '{$pnIdDossierDeFab}'\nORDER BY\n T8.Ordre\n , T9.Ordre"; $data_fiche = \fbx\DBmysql::getInstance()->getSelectData($q_fiche); foreach ($data_fiche as $clee => $valeur) { $pnIdFicheDeProd = $valeur->ID; $q_ficheTlCode = "SELECT\n T1.IDCodeErreur\n , T2.Nom\nFROM\n TBL_FICHE_DE_PROD_TL_CODE_ERREUR AS T1\n LEFT OUTER JOIN TBL_CODE_ERREUR_TRAD AS T2 ON T1.IDCodeErreur = T2.IDCodeErreur AND T2.IDLangue = '{$pnIdLangue}'\nWHERE\n T1.EstSupp = '0' AND T1.IDMembreAdd != 1\n AND T1.IDFicheDeProd = '{$pnIdFicheDeProd}'"; $data_ficheTlCode[] = \fbx\DBmysql::getInstance()->getSelectData($q_ficheTlCode); } if (is_array($data_dossier) && count($data_dossier) > 0) { $dossier = $data_dossier[0]->Dossier; echo '<script type="text/javascript">$(function(){document.title = "' . $dossier . '"})</script>'; } } $this->_data = array("OUT" => $args, "DATA_DOSSIER" => $data_dossier, "DATA_DOSSIER_TL_OPTION" => $data_dossierTlOption, "DATA_DOSSIER_TL_ELEMENT" => $data_dossierTlElement, "DATA_DOSSIER_TL_ELEMENT_TL_OPTION" => $data_dossierTlElementTlOption, "DATA_FICHE" => $data_fiche, "DATA_FICHE_TL_CODE_ERREUR" => $data_ficheTlCode, "Q_DOSSIER" => $q_dossier, "Q_DOSSIER_TL_OPTION" => $q_dossierTlOption, "Q_DOSSIER_TL_ELEMENT" => $q_dossierTlElement, "Q_FICHE" => $q_fiche); }
public function getDeleteFournisseur($args) { if (isset($args['IDFournisseurDelete']) && $args['IDFournisseurDelete'] != '') { $pnIdUser = $_SESSION['FBX_USER_ID']; $pnIDFournisseurDelete = $args['IDFournisseurDelete']; $up = "\nUPDATE TBL_FOURNISSEUR\nSET EstSupp = '1' , DateSupp = NOW() , IDMembreSupp = '{$pnIdUser}'\nWHERE IDFournisseur = {$pnIDFournisseurDelete}"; \fbx\DBmysql::getInstance()->getUpdateData($up); $this->getWrLog($up, "delete fournisseur {$pnIDFournisseurDelete}", __FUNCTION__, __FILE__); $this->getDataFournisseur($args); } else { echo "<script type='text/javascript'>\$(function(){getModalAlert('Pas de fournisseur trouvé');})</script>"; } }
public function Save_getUpdateDataDossierDeFab($args) { // $this->printr($args); $array_up_dossierTlOption = $array_up_dossierTlElement = $array_up_dossierTlElementTlOption = $array_ins_dossierTlElementTlOption = $array_up_dossierTlElementTlMachine = null; $up_dossierTlOption = $up_dossierTlElement = $up_dossierTlElementTlOption = $up_dossierTlElementTlMachine = null; $pnIdUser = $_SESSION['FBX_USER_ID']; if (isset($args['IDDossierDeFab']) && $args['IDDossierDeFab'] != '') { $pnIdDossierDeFab = $args['IDDossierDeFab']; } else { $pnIdDossierDeFab = '0'; } if (isset($args['DossierModal']) && $args['DossierModal'] != '') { $psDossier = $args['DossierModal']; } else { $psDossier = ''; } if (isset($args['RefModal']) && $args['RefModal'] != '') { $psRef = $args['RefModal']; } else { $psRef = ''; } if (isset($args['CommentaireModal']) && $args['CommentaireModal'] != '') { $psCommentaire = $args['CommentaireModal']; } else { $psCommentaire = ''; } if (isset($args['Pliage'])) { $pbPliage = '1'; } else { $pbPliage = '0'; } if (isset($args['Amalgame'])) { $pbAmalgame = '1'; } else { $pbAmalgame = '0'; } if (isset($args['LargeurOuvert']) && $args['LargeurOuvert'] != '') { $pnLargeurOuvert = $args['LargeurOuvert']; } else { $pnLargeurOuvert = '0'; } if (isset($args['HauteurOuvert']) && $args['HauteurOuvert'] != '') { $pnHauteurOuvert = $args['HauteurOuvert']; } else { $pnHauteurOuvert = '0'; } if (isset($args['LargeurFerme']) && $args['LargeurFerme'] != '') { $pnLargeurFerme = $args['LargeurFerme']; } else { $pnLargeurFerme = '0'; } if (isset($args['HauteurFerme']) && $args['HauteurFerme'] != '') { $pnHauteurFerme = $args['HauteurFerme']; } else { $pnHauteurFerme = '0'; } if (isset($args['QuantiteModal']) && $args['QuantiteModal'] != '') { $pnQuantite = $args['QuantiteModal']; } else { $pnQuantite = '0'; } if (isset($args['NbOption']) && $args['NbOption'] != '') { $pnNbOption = $args['NbOption']; } else { $pnNbOption = '0'; } if (isset($args['NbElement']) && $args['NbElement'] != '') { $pnNbElement = $args['NbElement']; } else { $pnNbElement = '0'; } if (isset($args['NbPose']) && $args['NbPose'] != '') { $pnNbPose = $args['NbPose']; } else { $pnNbPose = '1'; } if (isset($args['DateExpeditionModal'])) { $date = \DateTime::createFromFormat('d/m/Y', $args['DateExpeditionModal']); if (is_object($date)) { $pdDateExpedition = $date->format('Ymd'); } else { $pdDateExpedition = ''; } } else { $pdDateExpedition = ''; } if ($pnIdDossierDeFab > '0') { //__CREATE CODE BARRE $path = $_SESSION['BARCODE']['PATH']; $link = $_SESSION['BARCODE']['IMG'] . "/dossier"; $contenu_barcode = "%%" . $psDossier; $url = "{$path}?{$contenu_barcode}&dossier-{$pnIdDossierDeFab}&{$link}"; $this->cURLexec($url); // $this->getWrLog("CodeBarre Dossier", "$url", __FUNCTION__, __FILE__); //__CREATE QRcode $path = $_SESSION['QR']['PATH']; $link = $_SESSION['QR']['IMG'] . "/dossier"; $ref = $_SESSION['QR']['DOSSIER'] . "?action=getDataDossierDeFabForFiche&IDDossierDeFab={$pnIdDossierDeFab}"; $url = "{$path}?dossier-{$pnIdDossierDeFab}&{$link}&{$ref}"; $this->cURLexec($url); // $this->getWrLog("QRcode Dossier", "$url", __FUNCTION__, __FILE__); //__ up tbl_dossier_defab $up_dossier = "UPDATE\n TBL_DOSSIER_DE_FAB AS T1\nSET\n T1.Dossier = '{$psDossier}',\n T1.Ref = '{$psRef}',\n T1.Commentaire = '{$psCommentaire}',\n T1.EstPliable = '{$pbPliage}',\n T1.EstAmalgame = '{$pbAmalgame}',\n T1.LargeurOuvert = '{$pnLargeurOuvert}',\n T1.HauteurOuvert = '{$pnHauteurOuvert}',\n T1.LargeurFerme = '{$pnLargeurFerme}',\n T1.HauteurFerme = '{$pnHauteurFerme}',\n T1.Quantite = '{$pnQuantite}',\n T1.DateExpedition = '{$pdDateExpedition}',\n T1.IDMembreMaj = '{$pnIdUser}',\n T1.NbPose = '{$pnNbPose}',\n T1.DateMaj = NOW()\nWHERE\n T1.IDDossierDeFab = '{$pnIdDossierDeFab}' "; //__ up tbl_dossier_de_fab_tl_element if ($pnNbElement > 0) { for ($i = 0; $i < $pnNbElement; $i++) { if (isset($args["Element_" . $i]) && $args["Element_" . $i] != '') { $pn_elementElement = $args["Element_" . $i]; } else { $pn_elementElement = '0'; } if (isset($args["Quantite_" . $i]) && $args["Quantite_" . $i] != '') { $pn_elementQuantite = $args["Quantite_" . $i]; } else { $pn_elementQuantite = '0'; } if (isset($args["Support_" . $i]) && $args["Support_" . $i] != '') { $pn_elementSupport = $args["Support_" . $i]; } else { $pn_elementSupport = '0'; } if (isset($args["Format_" . $i]) && $args["Format_" . $i] != '') { $pn_elementFormat = $args["Format_" . $i]; } else { $pn_elementFormat = '0'; } if (isset($args["Impression_" . $i]) && $args["Impression_" . $i] != '') { $pn_elementImpression = $args["Impression_" . $i]; } else { $pn_elementImpression = '0'; } if (isset($args["Commentaire_" . $i]) && $args["Commentaire_" . $i] != '') { $ps_elementCommentaire = $args["Commentaire_" . $i]; } else { $ps_elementCommentaire = ''; } $pnIdDossierDeFab_tl_element = $args['IDDossierDeFab_tl_element_' . $i]; $array_up_dossierTlElement[] = "UPDATE\n TBL_DOSSIER_DE_FAB_TL_ELEMENT AS T1\nSET\n T1.DateMaj = NOW(),\n T1.IDElement = '{$pn_elementElement}',\n T1.Quantite = '{$pn_elementQuantite}',\n T1.IDSupport = '{$pn_elementSupport}',\n T1.IDFormat = '{$pn_elementFormat}',\n T1.IDImpression = '{$pn_elementImpression}',\n T1.Commentaire = '{$ps_elementCommentaire}',\n T1.IDMembreMaj = '{$pnIdUser}'\nWHERE\n T1.EstProtected = '0'\n AND T1.IDDossierDeFab_tl_element = '{$pnIdDossierDeFab_tl_element}'"; //__CREATE CODE BARRE $path = $_SESSION['BARCODE']['PATH']; $link = $_SESSION['BARCODE']['IMG'] . "/dossier"; // $contenu_barcode = "()".$pn_elementElement."()"; $contenu_barcode = "(({$pnIdDossierDeFab}(({$pn_elementElement}"; $url = "{$path}?{$contenu_barcode}&dossiertlement-{$pnIdDossierDeFab_tl_element}&{$link}"; $this->cURLexec($url); //__ up tbl_dossier_de_fab_tl_machine if (isset($args["Element" . ($i + 1) . "NbMachine"]) && $args["Element" . ($i + 1) . "NbMachine"] != '') { $pn_NbMachine = $args["Element" . ($i + 1) . "NbMachine"]; } else { $pn_NbMachine = ''; } if ($pn_NbMachine > 0) { for ($k = 0; $k < $pn_NbMachine; $k++) { if (isset($args["Element" . ($i + 1) . "Machine" . ($k + 1)]) && $args["Element" . ($i + 1) . "Machine" . ($k + 1)] > 0) { $pnElementTlMachine = $args["Element" . ($i + 1) . "Machine" . ($k + 1)]; } else { $pnElementTlMachine = '0'; } if (isset($args["Element" . ($i + 1) . "MachineImpression" . ($k + 1)]) && $args["Element" . ($i + 1) . "MachineImpression" . ($k + 1)] > 0) { $pnElementTlMachineImpression = $args["Element" . ($i + 1) . "MachineImpression" . ($k + 1)]; } else { $pnElementTlMachineImpression = '0'; } $pn_IDDossierDeFab_tl_element_tl_machine = $args["IDElement" . ($i + 1) . "Machine" . ($k + 1)]; $array_up_dossierTlElementTlMachine[] = "UPDATE\n TBL_DOSSIER_DE_FAB_TL_ELEMENT_TL_MACHINE AS T1\nSET\n T1.IDMachine = '{$pnElementTlMachine}'\n , T1.IDImpression = '{$pnElementTlMachineImpression}'\nWHERE\n T1.IDDossierDeFab_tl_element_tl_machine = '{$pn_IDDossierDeFab_tl_element_tl_machine}'"; } $up_dossierTlElementTlMachine = implode(';', $array_up_dossierTlElementTlMachine); } } //__ convert array on chaine $up_dossierTlElement = implode(';', $array_up_dossierTlElement); } //__ up tbl_dossier_de_fab_tl_option if ($pnNbOption > 0) { for ($i = 0; $i < $pnNbOption; $i++) { if (isset($args["selectOptionModal_" . $i]) && $args["selectOptionModal_" . $i] != '') { $pnIdOption = $args["selectOptionModal_" . $i]; } else { $pnIdOption = '0'; } $pnIdDossierDeFab_tl_option = $args['IDDossierDeFab_tl_option_' . $i]; $array_up_dossierTlOption[] = "UPDATE\n TBL_DOSSIER_DE_FAB_TL_OPTION AS T1\nSET\n T1.DateMaj = NOW(),\n T1.IDOption = '{$pnIdOption}',\n T1.IDMembreMaj = '{$pnIdUser}'\nWHERE\n T1.EstProtected = '0'\n AND T1.IDDossierDeFab_tl_option = '{$pnIdDossierDeFab_tl_option}'"; //__ up tbl_dossier_de_fab_tl_element_tl_option for ($j = 0; $j < $pnNbElement; $j++) { $pnIdDossierDeFab_tl_element = $args['IDDossierDeFab_tl_element_' . $j]; if (isset($args['Option' . ($j + 1) . 'Element' . ($i + 1)]) && $args['Option' . ($j + 1) . 'Element' . ($i + 1)] != '') { $pnIdOption = $args['Option' . ($j + 1) . 'Element' . ($i + 1)]; } else { $pnIdOption = '0'; } if (isset($args['IDDossierDeFab_tl_element_' . $j . '_tl_option_' . $i]) && $args['IDDossierDeFab_tl_element_' . $j . '_tl_option_' . $i] != '') { $pnIdDossierDeFab_tl_element_tl_option = $args['IDDossierDeFab_tl_element_' . $j . '_tl_option_' . $i]; $array_up_dossierTlElementTlOption[] = "UPDATE\n TBL_DOSSIER_DE_FAB_TL_ELEMENT_TL_OPTION AS T1\nSET\n T1.DateMaj = NOW(),\n T1.IDMembreMaj = '{$pnIdUser}',\n T1.IDOption = '{$pnIdOption}'\nWHERE\n T1.IDDossierDeFab_tl_element_tl_option = '{$pnIdDossierDeFab_tl_element_tl_option}'"; } else { if ($pnIdOption > 0 && $pnIdDossierDeFab_tl_element > 0) { $array_up_dossierTlElementTlOption[] = "INSERT INTO\nTBL_DOSSIER_DE_FAB_TL_ELEMENT_TL_OPTION\n(IDDossierDeFab_tl_element, IDOption, IDMembreAdd, DateAdd)\nVALUES\n({$pnIdDossierDeFab_tl_element},'{$pnIdOption}','{$pnIdUser}',NOW())"; } } } $up_dossierTlElementTlOption = implode(';', $array_up_dossierTlElementTlOption); } //__ convert array on chaine $up_dossierTlOption = implode(';', $array_up_dossierTlOption); } $q = $up_dossier . ";" . $up_dossierTlElement . ";" . $up_dossierTlOption . ";" . $up_dossierTlElementTlOption . ";" . $up_dossierTlElementTlMachine; $data = \fbx\DBmysql::getInstance()->getUpdateData($q); $this->getWrLog($q, "up dossier de fab", __FUNCTION__, __FILE__); // $this->printr($data); } // $this->printr($args); $this->_data = array("OUT" => $args); $this->getDataDossierDeFab($args); }
public function __construct($class_controller, $args_array = null) { $this->_class = $class_controller; $this->_template = "welcome.twig"; \fbx\Config::init(); $auth = new Auth(); $usr = $pwd = $lng = $loginText = $loginPwd = $loginLng = null; if (isset($_POST["login"])) { $loginTxt = $_POST["login"]; } else { if (isset($_GET["login"])) { $loginTxt = $_GET["login"]; } } if (isset($_POST["password"])) { $loginPwd = $_POST["password"]; } else { if (isset($_GET["password"])) { $loginPwd = $_GET["password"]; } } if (isset($_POST["languages"])) { $loginLng = $_POST["languages"]; } else { if (isset($_GET["languages"])) { $loginLng = $_GET["languages"]; } } //--- si cookie existe alors on recup value cookie et on le dehash sinon on recup value post if (isset($_COOKIE['FBX_SESSID'])) { $FBX_SESSID = explode("-+-+-", $_COOKIE['FBX_SESSID']); $usr = $FBX_SESSID[0]; $pwd = $FBX_SESSID[1]; $pwd = $this->dehashPassword($pwd); $lng = $_SESSION['languages'] = $loginLng = $FBX_SESSID[2]; $_SESSION['IDLANGUE'] = $FBX_SESSID[3]; } elseif (isset($loginTxt)) { $usr = $loginTxt; $pwd = $loginPwd; $lng = $loginLng; } if (isset($usr) && $usr != "") { $auth->login($usr, $pwd); } if ($auth->isUserLoggedIn()) { \fbx\DBmysql::init(); //-- identification de l'utilisateur if (!Utilisateur::isIdentified()) { Utilisateur::init(); } //-- si la coche est "on" alors on instruit cookie valable 5j = 5*24*3600 et on hash le mdp $pwd = $this->hashPassword($pwd); if (isset($_POST['remember'])) { setcookie("FBX_SESSID", "{$usr}-+-+-{$pwd}-+-+-{$lng}-+-+-{$_SESSION['IDLANGUE']}", time() + 5 * 24 * 60 * 60 * 1); } //-- recuperation du text pour le welcome message $chemin_destination = $this->path($_SESSION['FBX_USER_ID']); for ($i = 1; $i <= 4; $i++) { $fichier = "{$chemin_destination}text{$i}.txt"; if (file_exists($fichier) == 1) { $txtfile = fopen($fichier, 'r'); $_SESSION["TXT"][$i] = fgets($txtfile); fclose($txtfile); } $image = "{$chemin_destination}image{$i}.png"; if (file_exists($image) == 1) { $_SESSION["IMG"][$i] = $image; } else { $_SESSION["IMG"][$i] = "img/carousel/0/image{$i}.png"; } } $this->_data = array("session" => $_SESSION, "OUT" => $_SESSION); $class_controller = __NAMESPACE__ . "\\" . $class_controller; if (class_exists($class_controller)) { $this->_controller = new $class_controller(); $this->setAction(); $methodVariable = array($this->_controller, $this->_action); if (is_callable($methodVariable, false, $callback_name)) { $this->_controller->{$this->_action}(array_merge($args_array, $_SESSION)); $this->_template = $this->_controller->getTemplate(); $methodVariable = array($this->_controller, "getData"); if (is_callable($methodVariable, false, $callback_name)) { $this->_data = $this->_controller->getData(); } } } if ($auth->isUserLoggedIn()) { $this->_navbar = "navbar.twig"; } } else { $this->_template = "login.twig"; //-- Envoi du mot de passe si le mot de passe n'a pas déjà été envoyé dans les 5mn précédentes if (!isset($_SESSION["MdpEnvoye"])) { $send_pwd = 1; } else { if ($_SESSION["MdpEnvoye"] < time() - 300) { $send_pwd = 1; } else { $send_pwd = 0; } } if (isset($_POST['login'])) { if ($send_pwd == 1) { $this->_data = array("MdpOublie" => $auth->SendForgottenPassword($args_array)); if ($this->_data["MdpOublie"] == "1") { $_SESSION["MdpEnvoye"] = time(); } } else { $this->_data = array("MdpOublie" => "1"); } } elseif ($send_pwd == 0) { $this->_data = array("MdpOublie" => "1"); } } }