.-.-.-.-.-

<?php

session_start();
include "../../connection.php";
include '../../function_lib.php';
$data = array();
$query_select = " a.`id` AS id, a.`uid` AS uid, a.`amount` AS amount, a.`payment_type` AS payment_type, a.`file_name` AS file_name, a.`file_path` AS file_path, a.`remark` AS remark, a.`datetime` AS datetime, a.`status` AS status, "
. " a.`payment_mode` AS payment_mode,a.`bank_name` AS bank_name, a.`bank_branch` AS bank_branch, a.`ifsc` AS ifsc,a.`mobile` AS mobile, a.`payment_datetime` AS payment_datetime, a.`transaction_number` AS transaction_number, "
. " b.name as name, b.login_id as login_id, "
. " CONCAT(b.name,'&nbsp;(',b.login_id,')') AS user_name, CONCAT(b1.quantity,'&nbsp;(',p.package_name,')') AS pin_package";
$query = "  FROM `bank_receipt` a INNER JOIN user b ON a.uid = b.uid INNER JOIN bank_receipt_package  b1 ON a.id = b1.id INNER JOIN pin_package p ON b1.pin_package_id = p.id  WHERE a.uid !=0 ";
//$query .=!empty($_REQUEST['income_type']) ? " AND i.income_type='" . $_REQUEST['income_type'] . "'" : '';
$query .=!empty($_REQUEST['from_date']) && !empty($_REQUEST['to_date']) ? " AND (a.datetime BETWEEN '" . $_REQUEST['from_date'] . "' AND '" . $_REQUEST['to_date'] . "') " : '';

$query .=!empty($_REQUEST['login_id']) ? " AND b.login_id='" . $_REQUEST['login_id'] . "'" : '';

$query .= " ORDER BY a.`datetime`DESC";
//$sql1 = "SELECT COUNT(b1.id) as count " . $query;
//echo $sql1;
$totalRecordCount = mysqli_fetch_object(mysqli_query($connection, "SELECT COUNT(a.id) as count " . $query))->count;
$query_limit = $_REQUEST['length'] == -1 ? '' : " LIMIT " . $_REQUEST['start'] . ", " . $_REQUEST['length'];
$query_final = "SELECT " . $query_select . $query . $query_limit;
//echo $query_final;
$result = mysqli_query($connection, $query_final);
$sno = $_REQUEST['start'] + 1;
while ($row = mysqli_fetch_assoc($result)) {
    $row['sno'] = $sno;
//    $row['income_type'] = $master_income_type_array[$row['income_type']];
    $row['datetime'] = date("d/m/Y", strtotime($row['datetime']));
    $row['payment_type'] = $row['payment_type'] == 1 ? "New Joining payment" : "Upgrade Id";
    $row['payment_datetime'] = !empty($row['payment_datetime']) ? date("d/m/Y h:i A", strtotime($row['payment_datetime'])) : '';
    $row['status'] = $row['status'] == 1 ? "Closed" : "Unclosed";
    $row['closing_date'] = !empty($row['closing_date']) ? date("d/m/Y h:i A", strtotime($row['closing_date'])) : '';

$data[] = $row;
    $sno++;
}

$json_array = array('data' => $data, 'recordsFiltered' => $totalRecordCount, 'recordsTotal' => $totalRecordCount);
echo json_encode($json_array);
?>

/home2/wtmwscom/www/admin/report/bank_receipt_report_json.php