54 lines
2.5 KiB
PHP
Executable File
54 lines
2.5 KiB
PHP
Executable File
<?php
|
|
// -----------------------------------------------------
|
|
// Requete libelle dynamique
|
|
// -----------------------------------------------------
|
|
// $reqUpdate="UPDATE `calibdyn` SET ";
|
|
// $reqUpdate .= "libelleCaDyn='" .$nomLibelle. "', ";
|
|
// $reqUpdate .= "description='" .$desc. "' ";
|
|
// $reqUpdate .= " WHERE idLibCa=" .$idCaPers. " and idlg='" .$_SESSION['lgCouranteCode']. "' ;";
|
|
// $resConn=$idPdo->query($reqUpdate);
|
|
|
|
include_once ($includePathAdmin. "/_fonctions/gTranslate.php");
|
|
|
|
for ($i=0; $i<($_SESSION['nbLgActives']); $i++) {
|
|
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['$tableLangueCode[' => $i, ']' => $tableLangueCode[$i], '$_SESSION[lgCouranteCode]' => $_SESSION['lgCouranteCode'] ], 'reqUpdateLibDyn_propager.php');}
|
|
|
|
if ($tableLangueCode[$i] != $_SESSION['lgCouranteCode'] && $nomLibelle!='-') {
|
|
$nomLibelle= gTranslate($nomLibelle, strtolower( substr ($tableLangueCode[$i], 0, -1) ) );
|
|
if (isset($debug[2]) && $debug[2] == '1' ) { $debugMsg .= monDebug (1,['nomLibelle translated' => $nomLibelle],''); }
|
|
|
|
$desc= gTranslate($desc, strtolower( substr ($tableLangueCode[$i], 0, -1) ) );
|
|
if (isset($debug[2]) && $debug[2] == '1' ) { $debugMsg .= monDebug (1,['desc translated' => $desc],''); }
|
|
}
|
|
|
|
|
|
$reqUpdate="UPDATE `calibdyn` SET libelleCaDyn=:nomLibelle, description=:desc WHERE idLibCa=:idCaPers AND idlg=:idlg;";
|
|
|
|
if (isset($debug[2]) && $debug[2] == '1' ) {
|
|
$reqUpdateDebug=$reqUpdate;
|
|
$reqUpdateDebug=str_replace(':nomLibelle', '\''.$nomLibelle.'\'', $reqUpdateDebug);
|
|
$reqUpdateDebug=str_replace(':desc', '\''.$desc.'\'', $reqUpdateDebug);
|
|
$reqUpdateDebug=str_replace(':idCaPers', $idCaPers, $reqUpdateDebug);
|
|
$reqUpdateDebug=str_replace(':idlg', '\''.$_SESSION['lgCouranteCode'].'\'', $reqUpdateDebug);
|
|
$debugMsg .= monDebug (5, ['reqUpdate' => $reqUpdateDebug], 'reqUpdateLibDyn.php');
|
|
}
|
|
|
|
$stmt = $idPdo->prepare($reqUpdate);
|
|
$stmt->execute([
|
|
':nomLibelle' => $nomLibelle,
|
|
':desc' => $desc,
|
|
':idCaPers' => $idCaPers,
|
|
':idlg' =>$tableLangueCode[$i]
|
|
]);
|
|
|
|
|
|
if ($stmt->execute()) {
|
|
$admMsg .= "Mise à jour du libellé personalisé ( ".$nomLibelle." ) pour " .$tableLangueCode[$i]. " effectuée avec succès !<br>"; $admMsgClass='ok';
|
|
}
|
|
else
|
|
{$admMsg .= "Echec de la mise à jour du libellé personnalisé ( ".$nomLibelle." ) pour " .$tableLangueCode[$i]. "."; $admMsgClass='ko';
|
|
$erreurSQL=1;
|
|
}
|
|
}
|
|
?>
|