67 lines
2.8 KiB
PHP
Executable File
67 lines
2.8 KiB
PHP
Executable File
<?php
|
|
$nomFicAppelant = basename(__FILE__);
|
|
$fraisPortCdeTab=array();
|
|
$tabResult=array();
|
|
$idCdeTab=array();
|
|
$idMailTab=array();
|
|
$tabEtatCde=array();
|
|
$WHERE='';
|
|
$WHERE2='';
|
|
|
|
// -----------------------------------------------------
|
|
// Liste de toutes les commandes
|
|
// -----------------------------------------------------
|
|
if (empty($today)) {
|
|
date_default_timezone_set( 'Europe/Paris' );
|
|
$dateTimeObj = new DateTime('now', new DateTimeZone('Europe/Paris'));
|
|
$today = IntlDateFormatter::formatObject( $dateTimeObj, "y-MM-dd_HH-mm", 'fr' );
|
|
}
|
|
|
|
if ($cdeJour==1) $WHERE="AND substr(dateCdeModif,1,10) ='".substr($today,0,10). "' ";
|
|
|
|
if ($cdeLiv==1) $WHERE2="AND etatCde!='At' AND etatCde!='En' AND etatCde!='Re' AND etatCde!='An' AND etatCde!='Rb' AND etatCde!='Pn' AND etatCde!='Pe' AND etatCde!='Rb' ";
|
|
|
|
$reqSelect="SELECT * from `commande` WHERE idMail like '%@%' " .$WHERE. " " .$WHERE2. " ORDER by idCde;";
|
|
|
|
if (isset($debug[2]) && $debug[2] == '1' ) { $debugMsg .= monDebug (2, ['reqSelect' => $reqSelect], 'reqAllCde');}
|
|
$resConn='';
|
|
$resConn=$idPdo->query($reqSelect);
|
|
if ($resConn) {
|
|
$w=0;
|
|
require_once ("../_include/_fonctions/fonctions.gene.php");
|
|
while ($tabResult=$resConn->fetch(PDO::FETCH_ASSOC)) {
|
|
$idCdeTab[$w]=$tabResult['idCde'];
|
|
$idMailTab[$w]=$tabResult['idMail'];
|
|
$tabEtatCde[$w]=$tabResult['etatCde'];
|
|
if (isset($tabResult['fpCdeHt'])) {
|
|
$fraisPortCdeTab[$w]=$tabResult['fpCdeHt'];
|
|
$fraisPortCdeTab[$w]=$fraisPortCdeTab[$w]+$tabResult['fpCdeTVA'];
|
|
}
|
|
else {$fraisPortCdeTab[$w]=0;}
|
|
$tvaCdeTab[$w]=$tabResult['tvaCde'];
|
|
$remiseCdeTab[$w]=$tabResult['reductionCde'];
|
|
if (isset($debug[2]) && $debug[2] == '1' ) { $debugMsg .= monDebug (2, ['etatCdedb' .$w => $w, 'remiseCde' .$w => $remiseCdeTab[$w], 'tabEtatCde' .$w => $tabEtatCde[$w] ], '');}
|
|
|
|
$totalCdeTab[$w]=$tabResult['totalCde'];
|
|
$totalCdeTab[$w]=formatNB($totalCdeTab[$w],$lg);
|
|
$remiseCdeTab[$w]=formatNB($remiseCdeTab[$w],$lg);
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug (2, ['idMailTab' => $idMailTab[$w] ], '');}
|
|
$tabMPCde[$w]=$tabResult['idModePaie'];
|
|
if (isset($debug[2]) && $debug[2] == '1' ) { $debugMsg .= monDebug (2, ['tabMPCde' .$w => $tabMPCde[$w]], '');}
|
|
|
|
$tabMLCde[$w]=$tabResult['idModeLiv'];
|
|
if (isset($debug[2]) && $debug[2] == '1' ) { $debugMsg .= monDebug (2, ['tabMLCde' .$w => $tabMLCde[$w]], '');}
|
|
|
|
$tabDateCde[$w]=$tabResult['dateCdeCrea'];
|
|
$tabDateCdeModif[$w]=$tabResult['dateCdeModif'];
|
|
$tabCommentCde[$w]=$tabResult['commentaire'];
|
|
$tabidPR[$w]=$tabResult['idPointRelais'];
|
|
|
|
$w++;
|
|
}
|
|
$nbCdes=$w;
|
|
if (isset($debug[2]) && $debug[2] == '1' ) { $debugMsg .= monDebug (2, ['nbCdes' => $nbCdes], '');}
|
|
}
|
|
else {
|
|
$admMsg .= "Echec de la requete toutes les commandes"; $admMsgClass='ko';}
|
|
?>
|