.-.-.-.-.-

<?php
$title = "Withdrawal Report";
include 'header_plain.php';
include_once('lib/ps_pagination.php');

if (isset($_GET['login_id'])) {
    $uid = mysqli_fetch_object(mysqli_query($connection, "SELECT uid FROM user WHERE login_id = '" . $_GET['login_id'] . "'"))->uid;
}

$param .= isset($_GET['login_id']) && $_GET['login_id'] != '' ? "&amp;login_id=" . $_GET['login_id'] : '';
$param .= isset($_GET['from_date']) && $_GET['from_date'] != '' ? "&amp;from_date=" . $_GET['from_date'] : '';
$param .= isset($_GET['to_date']) && $_GET['to_date'] != '' ? "&amp;to_date=" . $_GET['to_date'] : '';
$query = "SELECT recid, uid, amount, tds, service_tax, service, net_amount, datetime, status FROM `withdraw` WHERE uid != 0";
$query .= isset($_GET['login_id']) && $_GET['login_id'] != '' ? " AND uid='" . $uid . "'" : '';
$query .= isset($_GET['from_date']) && $_GET['from_date'] != '' && isset($_GET['to_date']) && $_GET['to_date'] != '' ? " AND ( date(datetime) BETWEEN '" . $_GET['from_date'] . "' AND '" . $_GET['to_date'] . "')" : '';
$query .= " ORDER BY `datetime` DESC";

//echo $query;
?>
<h1>Payout/Withdrawal Report</h1>
<section id="comments">
    <form action="" method="get">
        <p>
            <input style="float: left;" type="text" name="login_id" value="<?php if (isset($_GET['login_id'])) {
    echo $_GET['login_id'];
} ?>" placeholder="Search by User Id" />
            <input style="float: left;" type="text" name="from_date" value="<?php if (isset($_GET['from_date'])) {
    echo $_GET['from_date'];
} ?>" class="datepicker" placeholder="From Date" />
            <input style="float: left;" type="text" name="to_date" value="<?php if (isset($_GET['to_date'])) {
    echo $_GET['to_date'];
} ?>" class="datepicker" placeholder="To Date" />
            <input type="submit" id="submit" value="Search">
            <input type="button" onclick="window.print()" value="print"/>
        </p>
    </form>
</section>
<section>
    <table style="width: 100%;">
        <thead>
            <tr>
                <th>No.</th>
                <th>A/c Holder Name</th>
                <th>Net Amount</th>
                <th>Bank</th>
                <th>Branch</th>
                <th>A/c No.</th>
                <th>IFSC</th>
                <th>Date</th>
            </tr>
        </thead>
        <tbody>
            <?php
            if (!isset($_GET['page'])) {
                $i = 1;
            } else {
                $i = (($_GET['page'] - 1) * 500) + 1;
            }
            $pager = new PS_Pagination($connection, $query, 500, 5, $param);
            $pager->setDebug(true);
            $result = $pager->paginate();
            if ($result) {
                while ($row = mysqli_fetch_object($result)) {
                    $row1 = mysqli_fetch_object(mysqli_query($connection, "SELECT * FROM user WHERE uid='$row->uid'"));
                    $user = get_user_detail($row->uid);
                    ?>

<tr <?php if ($i % 2) {
                        echo "class='light'";
                    } else {
                        echo "class='dark'";
                    } ?>>
                    <td><?php echo $i; ?></td>
                     <td><?php echo $row1->account_holder_name; ?></td>
                    
                    <td><?php echo $row->net_amount; ?></td>
                    <td><?php echo $row1->bank_name; ?></td>
                    <td><?php echo $row1->branch_name; ?></td>
                    
                    <td><?php echo $row1->account_number; ?></td>
                    <td><?php echo $row1->ifsc; ?></td>
                    <td><?php echo date("d/m/y", strtotime($row->datetime)); ?></td>

</tr>
        <?php $i++;
    }
} ?>
        </tbody>
    </table>
<?php echo $pager->renderFullNav(); ?>  
</section>

<?php include 'footer.php'; ?>

/home2/wtmwscom/www/admin/cgi-bin/../report_withdraw_print.php