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");
}
}
}
