function Check($date1, $date2, $operation) { global $URL; $SQL_DC = "SELECT * FROM `payment` WHERE `PaymentKind`='CHEQUE' AND `TransferDate` BETWEEN '{$date1}' AND '{$date2}'"; $SQL_D = "SELECT * FROM `payment` WHERE `PaymentKind`='CHEQUE' AND `TransferDate` BETWEEN '{$date1}' AND 'date2' AND `Amount`>0;"; $SQL_C = "SELECT * FROM `payment` WHERE `PaymentKind`='CHEQUE' AND `TransferDate` BETWEEN '{$date1}' AND '{$date2}' AND `Amount`<0;"; if ($operation == 'DC') { $query = $SQL_DC; } elseif ($operation == 'D') { $query = $SQL_C; } elseif ($operation == 'C') { $query = $SQL_D; } $result = QueryExcuteWhile($query); echo '<div class="row-fluid"> <table class="table table-striped table-hover"> <thead> <tr> <th>#Paiement</th> <th>#Chéque</th> <th class="hidden-480">Date</th> <th class="hidden-480">Echéance</th> <th class="hidden-480">Opérateur</th> <th class="hidden-480">Type</th> <th class="hidden-480">Montant</th> </tr> </thead>'; while ($o = mysqli_fetch_object($result)) { $PaymentInfo = PaymentInfo($o->idPayment); echo ' <tbody> <tr> <td>' . $o->idPayment . '</td> <td>' . $o->PaymentCode . '</td> <td class="hidden-480">'; echo FormatEnDateToFr($o->EncashmentDate); echo '</td> <td class="hidden-480">'; echo FormatEnDateToFr($o->TransferDate); echo '</td> <td class="hidden-480">' . $o->RecevedBy . '</td> <td class="hidden-480">'; if ($o->Amount > 0) { echo 'CREDITS'; } elseif ($o->Amount < 0) { echo 'DEBITS'; } echo '</td> <td>'; printf('%0.3f', $o->Amount); echo ' TND</td> </tr> '; } echo ' </tbody> </table> </div> <div class="space20"></div> <div class="row-fluid"> <div class="span4 invoice-block pull-right"> <ul class="unstyled amounts"> <li><strong>Total Crédit('; CheckGetTotalOperationIn($date1, $date2); echo ') : </strong> '; CheckGetTotalAmmountIn($date1, $date2); echo ' TND</li> <li><strong>Total Débit('; CheckGetTotalOperationOut($date1, $date2); echo ') : </strong> '; CheckGetTotalAmmountOut($date1, $date2); echo ' TND</li> <li><strong>Somme('; CheckGetTotalOperation($date1, $date2, $operation); echo ') : </strong> '; CheckGetTotalAmmount($date1, $date2, $operation); echo ' TND</li> </ul> </div> </div> '; }
function Checkout($date1, $date2, $idUser) { global $URL; $sql1 = "SELECT * FROM `payment` WHERE `EncashmentDate` BETWEEN '{$date1}' AND '{$date2}' AND `RecevedBy`='{$idUser}';"; $sql2 = "SELECT * FROM `payment` WHERE `EncashmentDate` BETWEEN '{$date1}' AND '{$date2}';"; if ($idUser) { $query = $sql1; } else { $query = $sql2; } $nobre_de_resultat = QueryExcute("mysqli_fetch_row", $query); $result = QueryExcuteWhile($query); echo ' <div class="row-fluid"> <table class="table table-striped table-hover"> <thead> <tr> <th>#</th> <th>Contrat</th> <th class="hidden-480">Designation</th> <th class="hidden-480">Type</th> <th class="hidden-480">Date</th> <th class="hidden-480">Operateur</th> <th>Total</th> </tr> </thead> '; while ($o = mysqli_fetch_object($result)) { $PaymentInfo = PaymentInfo($o->idPayment); $USER2 = UserGetInfo($o->RecevedBy); echo ' <tbody> <tr> <td>' . $o->idPayment . '</td> <td>'; if ($PaymentInfo) { echo $PaymentInfo->idContract; } else { echo '#'; } echo '</td> <td class="hidden-480">'; if ($o->Description) { echo $o->Description; } else { echo '<center>##</center>'; } echo '</td> <td class="hidden-480">' . $o->PaymentKind . '</td> <td class="hidden-480">'; echo FormatEnDateToFr($o->EncashmentDate); echo '</td> <td class="hidden-480">'; echo $USER2->FamilyName . ' ' . $USER2->FirstName; echo '</td> <td>'; printf('%0.3f', $o->Amount); echo ' TND</td> </tr> '; } echo ' </tbody> </table> </div> <div class="space20"></div> <div class="row-fluid"> <div class="span4 invoice-block pull-right"> <ul class="unstyled amounts"> <li><strong>Total Chéque('; CheckoutGetTotalOperationCash($date1, $date2, $idUser); echo ') : </strong> '; CheckoutGetAmmountTotalCash($date1, $date2, $idUser); echo ' TND</li> <li><strong>Total Espéce('; CheckoutGetTotalOperationCheck($date1, $date2, $idUser); echo ') : </strong> '; CheckoutGetAmmountTotalCheck($date1, $date2, $idUser); echo ' TND</li> <li><strong>Somme('; CheckoutGetTotalOperation($date1, $date2, $idUser); echo ') : </strong> '; CheckoutGetAmmountTotal($date1, $date2, $idUser); echo ' TND</li> </ul> </div> </div> '; }