120 lines
2.8 KiB
PHP
Executable File
120 lines
2.8 KiB
PHP
Executable File
<?php
|
|
$catable = "catype" . $idCaPers;
|
|
// switch ($idCaPers) {
|
|
// case 1:
|
|
// $catable="catype1";
|
|
// break;
|
|
|
|
// case 2:
|
|
// $catable="catype2";
|
|
// break;
|
|
|
|
// case 3:
|
|
// $catable="catype3";
|
|
// break;
|
|
|
|
// case 4:
|
|
// $catable="catype4";
|
|
// break;
|
|
|
|
// case 5:
|
|
// $catable="catype5";
|
|
// break;
|
|
|
|
// case 6:
|
|
// $catable="catype6";
|
|
// break;
|
|
|
|
// case 7:
|
|
// $catable="catype7";
|
|
// break;
|
|
|
|
// case 8:
|
|
// $catable="catype8";
|
|
// break;
|
|
|
|
// case 9:
|
|
// $catable="catype9";
|
|
// break;
|
|
|
|
// case 10:
|
|
// $catable="catype10";
|
|
// break;
|
|
|
|
// case 11:
|
|
// $catable="catype11";
|
|
// break;
|
|
|
|
// case 12:
|
|
// $catable="catype12";
|
|
// break;
|
|
|
|
// case 13:
|
|
// $catable="catype13";
|
|
// break;
|
|
|
|
// case 14:
|
|
// $catable="catype14";
|
|
// break;
|
|
|
|
// case 15:
|
|
// $catable="catype15";
|
|
// break;
|
|
|
|
// case 16:
|
|
// $catable="catype16";
|
|
// break;
|
|
|
|
// case 17:
|
|
// $catable="catype17";
|
|
// break;
|
|
|
|
// case 18:
|
|
// $catable="catype18";
|
|
// break;
|
|
|
|
// case 19:
|
|
// $catable="catype19";
|
|
// break;
|
|
|
|
// case 20:
|
|
// $catable="catype20";
|
|
// break;
|
|
|
|
// case 21:
|
|
// $catable="catype21";
|
|
// break;
|
|
|
|
// case 22:
|
|
// $catable="catype22";
|
|
// break;
|
|
|
|
// case 23:
|
|
// $catable="catype23";
|
|
// break;
|
|
// }
|
|
|
|
if (!empty($tagLib)) $tagLib=addslashes($tagLib);
|
|
if (!empty($code1)) $code1=addslashes($code1);
|
|
if (!empty($code2)) $code2=addslashes($code2);
|
|
require_once ("../_include/_fonctions/fonctions.gene.php");
|
|
$prixHT=(float)$prixHT;
|
|
$prixHT=formatNB($prixHT,'ENG');
|
|
$prixTTC=(float)$prixTTC;
|
|
$prixTTC=formatNB($prixTTC,'ENG');
|
|
$reqInsert = "INSERT into `" .$catable. "` (numCA" .$idCaPers. ", id, idLg, nom, code1, code2, code3, prixHT, prixTTC, imageCA, tvaTaux) ";
|
|
$reqInsert .= "VALUES (0, " .$idLib. ",'" .$_SESSION['lgCouranteCode']. "','" .$tagLib. "','" .$code1. "','" .$code2. "' ,'" .$code3. "' , " .$prixHT. ", " .$prixTTC. ", '" .$imageCA. "'," .$idTva. ");";
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug (2, ['reqInsert' => $reqInsert], 'reqInsertCaPers.php');}
|
|
$resConn='';
|
|
try {
|
|
$resConn=$idPdo->query($reqInsert);
|
|
if ($resConn) {$admMsg .= "<br>Création de la caractéristique effectuée avec succès ! "; $admMsgClass='ok';}
|
|
else {$admMsg .= "Echec de la création caractéristique."; $admMsgClass='ko'; $erreurSQL=1;}
|
|
} catch (PDOException $e) {
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Erreur PDO :' => $e->getMessage()], '');}
|
|
$admMsgClass = 'ko';
|
|
$erreurSQL = 1;
|
|
}
|
|
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug (2, ['changerLaLangue' => $changerLaLangue], '');}
|
|
?>
|