public function getMemberPayout($user_mob_name)
{
require_once 'LegClass.php';
$obj_leg = new LegClass();
if ($this->table_prefix == "") {
$this->table_prefix = $_SESSION['table_prefix'];
}
$user_id = $this->obj_val->userNameToID($user_mob_name);
$leg_amount = $this->table_prefix . "leg_amount";
$select = "SELECT SUM(total_leg) AS total_leg,\n SUM(total_amount) AS total_amount,\n SUM(amount_payable) AS amount_payable,\n SUM(tds) AS tds,\n SUM(service_charge) AS service_charge,\n user_id\n FROM {$leg_amount}\n WHERE user_id='{$user_id}'\n GROUP BY user_id\n ";
// echo $select;
$result = $this->selectData($select, "Error on selecting leg amount ..");
$row = mysql_fetch_array($result);
$this->member_payout_details["user_id"] = $row['user_id'];
$this->member_payout_details["user_name"] = $this->obj_val->IdToUserName($row['user_id']);
$this->member_payout_details["full_name"] = $this->obj_val->getFullName($row['user_id']);
$this->member_payout_details["left_leg"] = $obj_leg->getLeftLegCount($row['user_id']);
$this->member_payout_details["right_leg"] = $obj_leg->getRightLegCount($row['user_id']);
$this->member_payout_details["total_leg"] = $row['total_leg'];
$this->member_payout_details["total_amount"] = $row['total_amount'];
$this->member_payout_details["amount_payable"] = round($row['amount_payable'], 2);
$this->member_payout_details["tds"] = round($row['tds'], 2);
$this->member_payout_details["service_charge"] = round($row['service_charge'], 2);
return $this->member_payout_details;
}
public function getMemberPayout($user_mob_name)
{
$member_payout_details = array();
require_once 'LegClass.php';
$obj_leg = new LegClass();
$user_id = $this->obj_val->userNameToID($user_mob_name);
$this->db->select_sum('total_leg', 'total_leg');
$this->db->select_sum('total_amount', 'total_amount');
$this->db->select_sum('amount_payable', 'amount_payable');
$this->db->select_sum('tds', 'tds');
$this->db->select_sum('service_charge', 'service_charge');
$this->db->select('user_id');
$this->db->from('leg_amount');
$this->db->where('user_id', $user_id);
$this->db->group_by('user_id');
$this->db->select('user.user_detail_acnumber,user.user_detail_nbank,user.user_detail_nbranch,user.user_detail_pan,user.user_detail_address');
$this->db->join('user_details as user', 'user.user_detail_refid=leg_amount.user_id', 'INNER');
$query = $this->db->get();
foreach ($query->result_array() as $row) {
$member_payout_details["user_id"] = $row['user_id'];
$member_payout_details["user_name"] = $this->obj_val->IdToUserName($row['user_id']);
$member_payout_details["user_id"] = $row['user_id'];
$member_payout_details["full_name"] = $this->obj_val->getFullName($row['user_id']);
$member_payout_details["left_leg"] = $obj_leg->getLeftLegCount($row['user_id']);
$member_payout_details["right_leg"] = $obj_leg->getRightLegCount($row['user_id']);
$member_payout_details["total_leg"] = $row['total_leg'];
$member_payout_details["total_amount"] = $row['total_amount'];
$member_payout_details["amount_payable"] = round($row['amount_payable'], 2);
$member_payout_details["tds"] = round($row['tds'], 2);
$member_payout_details["service_charge"] = round($row['service_charge'], 2);
$member_payout_details["user_pan"] = $row['user_detail_pan'];
if ($row['user_detail_acnumber']) {
$member_payout_details["acc_number"] = $row['user_detail_acnumber'];
} else {
$member_payout_details["acc_number"] = 'NA';
}
if ($row['user_detail_nbank']) {
$member_payout_details["user_bank"] = $row['user_detail_nbank'];
} else {
$member_payout_details["user_bank"] = 'NA';
}
if ($row['user_detail_address']) {
$member_payout_details["user_address"] = $row['user_detail_address'];
} else {
$member_payout_details["user_address"] = 'NA';
}
}
return $member_payout_details;
}
public function getMemberPayout($user_mob_name)
{
require_once 'LegClass.php';
$obj_leg = new LegClass();
if ($this->table_prefix == "") {
$this->table_prefix = $this->session->userdata('table_prefix');
}
$user_id = $this->obj_val->userNameToID($user_mob_name);
$leg_amount = $this->table_prefix . "leg_amount";
$this->db->select_sum('total_leg', 'total_leg');
$this->db->select_sum('total_amount', 'total_amount');
$this->db->select_sum('amount_payable', 'amount_payable');
$this->db->select_sum('tds', 'tds');
$this->db->select_sum('service_charge', 'service_charge');
$this->db->select('user_id');
$this->db->from($leg_amount);
$where = "date_of_submission BETWEEN '{$from_date}' AND '{$to_date}'";
$this->db->where($where);
$this->db->group_by(user_id);
$query = $this->db->get();
$row = $query->result_array();
$member_payout_details["user_id"] = $row['user_id'];
$member_payout_details["user_name"] = $this->obj_val->IdToUserName($row['user_id']);
$member_payout_details["user_id"] = $row['user_id'];
$member_payout_details["full_name"] = $this->obj_val->getFullName($row['user_id']);
$member_payout_details["left_leg"] = $obj_leg->getLeftLegCount($row['user_id']);
$member_payout_details["right_leg"] = $obj_leg->getRightLegCount($row['user_id']);
$member_payout_details["total_leg"] = $row['total_leg'];
$member_payout_details["total_amount"] = $row['total_amount'];
$member_payout_details["amount_payable"] = round($row['amount_payable'], 2);
$member_payout_details["tds"] = round($row['tds'], 2);
$member_payout_details["service_charge"] = round($row['service_charge'], 2);
/* $select = "SELECT SUM(total_leg) AS total_leg,
SUM(total_amount) AS total_amount,
SUM(amount_payable) AS amount_payable,
SUM(tds) AS tds,
SUM(service_charge) AS service_charge,
user_id
FROM $leg_amount
WHERE user_id='$user_id'
GROUP BY user_id
";
// echo $select;
$result = $this->selectData($select, "Error on selecting leg amount ..");
$row = mysql_fetch_array($result);
$this->member_payout_details["user_id"] = $row['user_id'];
$this->member_payout_details["user_name"] = $this->obj_val->IdToUserName($row['user_id']);
$this->me$this->member_payout_details["user_id"] = $row['user_id'];
$this->mmber_payout_details["full_name"] = $this->obj_val->getFullName($row['user_id']);
$this->member_payout_details["left_leg"] = $obj_leg->getLeftLegCount($row['user_id']);
$this->member_payout_details["right_leg"] = $obj_leg->getRightLegCount($row['user_id']);
$this->member_payout_details["total_leg"] = $row['total_leg'];
$this->member_payout_details["total_amount"] = $row['total_amount'];
$this->member_payout_details["amount_payable"] = round($row['amount_payable'], 2);
$this->member_payout_details["tds"] = round($row['tds'], 2);
$this->member_payout_details["service_charge"] = round($row['service_charge'], 2); */
return $member_payout_details;
}
