.-.-.-.-.-

<?php
session_start();
include "../../connection.php";
include '../../function_lib.php';
$data = array();
$uid = $_SESSION['userid'];

$query_select = " u.uid AS uid, u.login_id AS login_id, u.refer_id AS refer_id, u.name AS name, u.mobile AS mobile, u.position AS position, u.reg_date AS reg_date, u.plan_type AS plan_type, date(u.topup_datetime) as topup_date, u.is_paid AS is_paid, "
        . " CONCAT(u2.name ,'(', u2.login_id ,')') AS placement_id , p.package_name AS package_name";
$query = " FROM `user` AS u LEFT JOIN user u2 ON u2.uid = u.placement_id LEFT JOIN pin_package AS p ON u.plan_type = p.id   WHERE u.`refer_id`='$uid' ";
$query .=!empty($_REQUEST['login_id']) ? " AND u.login_id='" . $_REQUEST['login_id'] . "'" : '';
$query .=!empty($_REQUEST['name']) ? " AND u.name='" . $_REQUEST['name'] . "'" : '';

$query .= " ORDER BY u.name";

$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;
    $uid = $row['uid'];
    $row['reg_date'] = date("d/m/Y h:i A", strtotime($row['reg_date']));
//    $row['topup_date'] = !empty($row['topup_date']) ? date("d/m/Y h:i A", strtotime($row['topup_date'])) : '' ;
    $total_commit_income = mysqli_fetch_object(mysqli_query($connection,"SELECT sum(amount) as total_amount FROM commit_income WHERE uid = $uid "))->total_amount;
    $row['total_commit_income'] = $total_commit_income;
    $data[] = $row;
    $sno++;
}

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

/home2/wtmwscom/public_html/admin/../member/report/direct_referral_json.php