.-.-.-.-.-

<?php
session_start();
include "../../connection.php";
include '../../function_lib.php';
$data = array();
//$uid = $_SESSION['userid'];
//$child_ids = get_child_ids($uid);
//$uids = '';
//foreach($child_ids as $key => $level){
//    foreach($level as $key => $value){
//        if($uids==''){
//            $uids = $value;
//        } else{
//            $uids .= ', '.$value;
//        }
//    }
//}

$query_select = " r.commit_id AS commit_id, r.uid AS uid, r.amount AS amount, r.datetime AS datetime, r.from_uid AS from_uid, "
        . " CONCAT(u.name,'&nbsp;(',u.login_id,')') AS user_name, CONCAT(u1.name,'&nbsp;(',u1.login_id,')') AS user_name1 ";
$query = " FROM referral_income AS r LEFT JOIN user AS u ON r.uid = u.uid LEFT JOIN user AS u1 ON r.from_uid = u1.uid WHERE u.uid != 0  ";
//$query .=!empty($_REQUEST['income_type']) ? " AND i.income_type='" . $_REQUEST['income_type'] . "'" : '';
$query .=!empty($_REQUEST['from_date']) && !empty($_REQUEST['to_date']) ? " AND (r.datetime BETWEEN '" . $_REQUEST['from_date'] . "' AND '" . $_REQUEST['to_date'] . "') " : '';

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

$query .= " ORDER BY r.`datetime` ";

$totalRecordCount = mysqli_fetch_object(mysqli_query($connection, "SELECT COUNT(u.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['datetime'] = date("d/m/Y h:i A", strtotime($row['datetime']));
//    $row['assign_datetime'] = !empty($row['assign_datetime']) ? date("d/m/Y h:i A", strtotime($row['assign_datetime'])) : '';
//    $row['confirm_status'] = $row['confirm_status'] == 1 ? "Confirm" : "Unconfirm";
//    $row['payment_date'] = !empty($row['payment_date']) ? date("d/m/Y h:i A", strtotime($row['payment_date'])) : '';
//    $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/public_html/static/../admin/report/report_referral_json.php