<?php

require_once('helpers/querys.php');

$db = new Conexion;

$range = $_REQUEST['range'];
$agency_courier = intval($_REQUEST['agency_courier']);
$pay_mode = intval($_REQUEST['pay_mode']);
$customer_id = intval($_REQUEST['customer_id']);

$sWhere = "";


if ($agency_courier > 0) {

    $sWhere .= " and agency = '" . $agency_courier . "'";
}


if ($customer_id > 0) {

    $sWhere .= " and sender_id = '" . $customer_id . "'";
}

if ($pay_mode > 0) {

    $sWhere .= " and order_payment_method = '" . $pay_mode . "'";
}


if (!empty($range)) {

    $fecha =  explode(" - ", $range);
    $fecha = str_replace('/', '-', $fecha);

    $fecha_inicio = date('Y-m-d', strtotime($fecha[0]));
    $fecha_fin = date('Y-m-d', strtotime($fecha[1]));


    $sWhere .= " and  order_date between '" . $fecha_inicio . "'  and '" . $fecha_fin . "'";
}


$db->cdp_query("UPDATE cdb_add_order SET  status_invoice =3  WHERE due_date<now() and status_invoice !=1 and order_payment_method >1");


$db->cdp_execute();


$sql = "SELECT * FROM cdb_add_order where order_payment_method >1  
           
            $sWhere
            
             order by order_id desc 
             ";


$query_count = $db->cdp_query($sql);
$db->cdp_execute();
$numrows = $db->cdp_rowCount();


$db->cdp_query($sql);
$data = $db->cdp_registros();

$fecha = str_replace('-', '/', $fecha);

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
    <meta http-equiv='Content-Type' content='text/html; charset=UTF-8' />
    <meta name="msapplication-TileColor" content="#ffffff">
    <meta name="theme-color" content="#ffffff">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <!-- Tell the browser to be responsive to screen width -->
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="">
    <meta name="author" content="">
    <!-- Favicon icon -->
    <link rel="icon" type="image/png" sizes="16x16" href="assets/<?php echo $core->favicon ?>">

    <title>Accounts receivable summary</title>

    <link href="assets/custom_dependencies/print_report.css" rel="stylesheet">

</head>

<body>
    <div id="page-wrap">

        <h2 style="border: 0;  text-align: center">
            <?php echo ($core->logo) ? '<img src="assets/uploads/galeyr.png"/>' : $core->site_name; ?>
            <br/>
            <?php echo $core->site_name; ?><br>
            Accounts receivable summary <br>
        
            [<?php echo $fecha[0] . ' - ' . $fecha[1]; ?>] <br>


        </h2>


        <table style="border: 0;  text-align: center">
            <tr>

                <th class="text-center"></th>
                <th><b><?php echo $lang['ltracking'] ?></b></th>
                <th class="text-center"><b>Sender</b></th>
                <th class="text-center"><b><?php echo $lang['ddate'] ?></b></th>
                <th class="text-center"><b>Due date</b></th>
                <th class="text-center"><b><?php echo $lang['lstatusinvoice'] ?></b></th>
                <th class="text-center"><b>Total amount</b></th>
                <th class="text-center"><b>Total paid</b></th>
                <th class="text-center"><b>balance</b></th>


            </tr>

            <?php

            if ($numrows > 0) {

                $count = 1;
                $sumador_pendiente = 0;
                $sumador_total = 0;
                $sumador_pagado = 0;

                foreach ($data as $row) {

                    $db->cdp_query("SELECT * FROM cdb_users where id= '" . $row->sender_id . "'");
                    $sender_data = $db->cdp_registro();

                    $db->cdp_query("SELECT * FROM cdb_users where id= '" . $row->receiver_id . "'");
                    $receiver_data = $db->cdp_registro();

                    $db->cdp_query("SELECT * FROM cdb_users where id= '" . $row->driver_id . "'");
                    $driver_data = $db->cdp_registro();

                    $db->cdp_query("SELECT currency FROM cdb_add_order WHERE order_id='" . $row->order_id . "'");
                    $curr = $db->cdp_registro();

                    $db->cdp_query('SELECT  IFNULL(sum(total), 0)  as total  FROM cdb_charges_order WHERE order_id=:order_id');

                    $db->bind(':order_id', $row->order_id);

                    $db->cdp_execute();

                    $sum_payment = $db->cdp_registro();

                    $pendiente = $row->total_order - $sum_payment->total;

                    if ($row->status_invoice == 1) {
                        $text_status = $lang['invoice_paid'];
                        $label_class = "label-success";
                    } else if ($row->status_invoice == 2) {
                        $text_status = $lang['invoice_pending'];
                        $label_class = "label-warning";
                    } else if ($row->status_invoice == 3) {
                        $text_status = $lang['invoice_due'];
                        $label_class = "label-danger";
                    }

                    $sumador_pendiente += $pendiente;
                    $sumador_total += $row->total_order;
                    $sumador_pagado += $sum_payment->total;


            ?>
                    <tr class="card-hovera">
                        <td><?php echo $count; ?></td>

                        <td><b><a data-toggle="modal" data-target="#charges_list" data-id="<?php echo $row->order_id; ?>"><?php echo $row->order_prefix . $row->order_no; ?></a></b></td>

                        <td class="text-center">
                            <?php echo $sender_data->fname; ?> <?php echo $sender_data->lname; ?>
                        </td>

                        <td class="text-center">
                            <?php echo $row->order_date; ?>
                        </td>


                        <td class="text-center">
                            <?php echo $row->due_date; ?>
                        </td>

                        <td class="text-center">
                            <span class="label label-large <?php echo $label_class; ?>"><?php echo $text_status; ?></span>

                        </td>

                        <td class="text-center">
                            <b></b> <?php echo $curr->currency; ?><?php echo number_format($row->total_order); ?>
                        </td>

                        <td class="text-center">
                            <b></b> <?php echo $curr->currency; ?><?php echo number_format($sum_payment->total); ?>
                        </td>

                        <td class="text-center">
                            <b></b> <?php echo $curr->currency; ?><?php echo number_format($pendiente); ?>
                        </td>



                    </tr>
                <?php

                    $count++;
                }
                ?>

                <tr>
                    <td class="text-left"><b>TOTAL</b></td>

                    <td colspan="5"></td>
                    <td class="text-center  ">
                        <b><?php echo number_format($sumador_total); ?> </b>
                    </td>

                    <td class="text-center  ">
                        <b><?php echo number_format($sumador_pagado); ?> </b>
                    </td>

                    <td class="text-center  ">
                        <b><?php echo number_format($sumador_pendiente); ?> </b>
                    </td>
                </tr>
            <?php
            }
            ?>


        </table>

        <button class='button -dark center no-print' onClick="window.print();" style="font-size:16px; margin-top: 20px;">Print &nbsp;&nbsp; <i class="fa fa-print"></i></button>
    </div>

</body>

</html>