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; }