Ejemplo n.º 1
0
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>
		';
}
Ejemplo n.º 2
0
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>
		';
}