.-.-.-.-.-

<?php
session_start();
include "../../connection.php";
include '../../function_lib.php';
$data = array();
$uid = $_SESSION['userid'];
$child_ids_left_array = get_child_levels(get_child_ids_2($uid, 'L'));
$child_ids_left_csv = !empty($child_ids_left_array) ? implode(", ", $child_ids_left_array) : 0;
$query_select = " p.pv_amount AS amount, p.date AS date, p.status AS status, u.name AS name, u.login_id AS login_id,"
. " CONCAT(u.name,'(',u.login_id,')') AS user_name";
$query = " FROM product_sale AS p INNER JOIN user AS u ON p.uid = u.uid WHERE p.uid IN ( $child_ids_left_csv ) ";
$query .=!empty($_REQUEST['from_date']) && !empty($_REQUEST['to_date']) ? " AND (m.date BETWEEN '".$_REQUEST['from_date']."' AND '".$_REQUEST['to_date']."') " : '';
//$query .=!empty($_REQUEST['name']) ? " AND u.name='" . $_REQUEST['name'] . "'" : '';

$query .= " ORDER BY p.date ASC";

$totalRecordCount = mysqli_fetch_object(mysqli_query($connection, "SELECT COUNT(p.uid) 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['date'] = !empty($row['date']) ? date("d/m/Y ", strtotime($row['date'])) : '' ;
    $row['status'] = $row['status'] == 1 ? "Closed" : "Not Closed";
    //$row['payment_date'] = !empty($row['payment_date']) ? date("d/m/Y h:i A", strtotime($row['payment_date'])) : '' ;
    $data[] = $row;
    $sno++;
}

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

/home2/wtmwscom/public_html/static/../member/report/report_product_sale_left_json.php