function get_premium_general_for_business_aggregate()
{
if (isset($_GET['for_premium_general'])) {
$for_premium_general = $_GET['for_premium_general'];
$explode_for_premium_general = explode(',', $for_premium_general);
$dates = explode('_', $explode_for_premium_general[1]);
$premium_register_general_report = array();
$WStartDtObj = new DateTime($this->input->post('from_date'));
$premium_register_general_report['from_date'] = $WStartDtObj->format('Y-m-d');
$WEndDtObj = new DateTime($this->input->post('to_date'));
$premium_register_general_report['to_date'] = $WEndDtObj->format('Y-m-d');
$premium_register_general_report['type'] = $this->input->post('type');
$condition_array = array();
$conditions = '';
if ($explode_for_premium_general[0] != '') {
if (trim($explode_for_premium_general[0]) != trim('ALL BRANCHES')) {
array_push($condition_array, " pod.branch_id =" . $explode_for_premium_general[0]);
} else {
$conditions = '';
}
}
if ($explode_for_premium_general[3] != '') {
if ($explode_for_premium_general[3] != 'All') {
array_push($condition_array, " mt.product_category_id =" . $explode_for_premium_general[3]);
} else {
$conditions = '';
}
}
$date_string = '';
if ($dates[0] != '' && $dates[1] != '') {
if ($explode_for_premium_general[2] == 'AD') {
$date_type = "(Approval Date)";
array_push($condition_array, " pod.approved_date BETWEEN '" . $dates[0] . "' AND '" . $dates[1] . "'");
} else {
$date_type = "(Policy Date)";
array_push($condition_array, " pod.from_date_details BETWEEN '" . $dates[0] . "' AND '" . $dates[1] . "'");
}
$from_date = $dates[0];
$to_date = $dates[1];
$date_string = ' for ' . $from_date . ' - ' . $to_date . $date_type;
}
$result = $this->report_model->get_premium_register_general_report_info($condition_array, $conditions);
$folder = 'timesheet/reports/production/premium_register_general';
if (sizeof($result) > 0) {
if ($this->input->post('branch') != 'All') {
$branch = $result[0]['branch'];
} else {
$branch = 'ALL BRANCHES';
}
$report_heading = 'Premium Register (General) - ' . $branch . $date_string;
$name = 'Premium_Register_(General)';
$show_data['premium_register_general_report'] = $result;
$this->load->helper('amountinwords');
$this->load->helper(array('timesheet', 'file'));
$timesheet_result = create_timesheet_premium_register($result, $folder, $name, $report_heading);
if ($timesheet_result != '') {
redirect(base_url() . 'timesheet/reports/production/premium_register_general/' . $timesheet_result . '.xlsx');
exit;
}
} else {
$show_data['error'] = 'No Data Found';
}
}
}
function index()
{
$show_data = array();
$show_data['error'] = '';
$show_data['success'] = $this->session->userdata('success');
$this->clearmessage();
/* Intermediary Commission Report */
if (isset($_POST['intermediary_commision_report'])) {
$this->load->library('form_validation');
$config = array(array('field' => 'branch', 'label' => 'Branch Name', 'rules' => 'required'));
$this->form_validation->set_rules($config);
if ($this->form_validation->run() != false) {
$intermediary_commision_report = array();
$intermediary_commision_report['branch'] = $this->input->post('branch');
$intermediary_commision_report['intermediary'] = $this->input->post('intermediary');
$intermediary_commision_report['intermediary_users'] = $this->input->post('intermediary_users');
$WStartDtObj = new DateTime($this->input->post('from_date'));
$intermediary_commision_report['from_date'] = $WStartDtObj->format('Y-m-d');
$WEndDtObj = new DateTime($this->input->post('to_date'));
$intermediary_commision_report['to_date'] = $WEndDtObj->format('Y-m-d');
$intermediary_commision_report['paid_status'] = $this->input->post('paid_status');
$condition_array = array();
if ($this->input->post('branch') != '') {
array_push($condition_array, " mt.branch_id =" . $this->input->post('branch'));
}
if ($this->input->post('intermediary') != '') {
array_push($condition_array, " pod.source_of_business =" . $this->input->post('intermediary'));
}
if ($this->input->post('intermediary_users') != '') {
if ($this->input->post('intermediary') == 1 || $this->input->post('intermediary') == 2 || $this->input->post('intermediary') == 3) {
array_push($condition_array, " inter.user_type_id =" . $this->input->post('intermediary_users'));
} else {
if ($this->input->post('intermediary') == 4) {
array_push($condition_array, " tia_ud.user_details_id =" . $this->input->post('intermediary_users'));
}
}
}
if ($this->input->post('from_date') != '' && $this->input->post('to_date') != '') {
array_push($condition_array, " pod.created_date BETWEEN '" . $intermediary_commision_report['from_date'] . "' AND '" . $intermediary_commision_report['to_date'] . "'");
}
$result = $this->report_model->get_intermediary_commision_report_info($condition_array);
$folder = 'timesheet/reports/production/intermediary_commission';
if (sizeof($result) > 0) {
$report_heading = 'Agency / Broker Commission Payable';
$name_1 = $result[0]['created_date'];
$row = explode(" ", $name_1);
$name = $row[0];
$show_data['freedate_report'] = $result;
$this->load->helper('amountinwords');
$this->load->helper(array('timesheet', 'file'));
$timesheet_result = create_timesheet_intermediary_commission($result, $folder, $name, $report_heading);
if ($timesheet_result != '') {
redirect(base_url() . 'timesheet/reports/production/intermediary_commission/' . $timesheet_result . '.xlsx');
exit;
}
} else {
$show_data['error'] = 'No Data Found';
}
}
}
/* Premium Register General Report */
if (isset($_POST['premium_register_general_report'])) {
$this->load->library('form_validation');
$config = array(array('field' => 'branch', 'label' => 'Branch Name', 'rules' => 'required'), array('field' => 'businesslines', 'label' => 'Business line', 'rules' => 'required'), array('field' => 'product_category', 'label' => 'Product Category', 'rules' => 'required'), array('field' => 'from_date', 'label' => 'From Date', 'rules' => 'required'), array('field' => 'to_date', 'label' => 'To Date', 'rules' => 'required'), array('field' => 'type', 'label' => 'Type', 'rules' => 'required'));
$this->form_validation->set_rules($config);
if ($this->form_validation->run() != false) {
$premium_register_general_report = array();
$premium_register_general_report['branch'] = $this->input->post('branch');
$premium_register_general_report['businesslines'] = $this->input->post('businesslines');
$premium_register_general_report['product_category'] = $this->input->post('product_category');
$WStartDtObj = new DateTime($this->input->post('from_date'));
$premium_register_general_report['from_date'] = $WStartDtObj->format('Y-m-d');
$WEndDtObj = new DateTime($this->input->post('to_date'));
$premium_register_general_report['to_date'] = $WEndDtObj->format('Y-m-d');
$premium_register_general_report['type'] = $this->input->post('type');
$condition_array = array();
if ($this->input->post('branch') != '') {
array_push($condition_array, " mt.branch_id =" . $this->input->post('branch'));
}
if ($this->input->post('businesslines') != '') {
array_push($condition_array, " c.business_line_id =" . $this->input->post('businesslines'));
}
if ($this->input->post('product_category') != '') {
array_push($condition_array, " mt.product_category_id =" . $this->input->post('product_category'));
}
if ($this->input->post('from_date') != '' && $this->input->post('to_date') != '') {
array_push($condition_array, " pod.created_date BETWEEN '" . $premium_register_general_report['from_date'] . "' AND '" . $premium_register_general_report['to_date'] . "'");
}
if ($this->input->post('type') != '') {
array_push($condition_array, " pod.invoice_type =" . $this->input->post('type'));
}
$result = $this->report_model->get_premium_register_general_report_info($condition_array);
$folder = 'timesheet/reports/production/premium_register_general';
if (sizeof($result) > 0) {
$report_heading = 'Premium Register (General)';
// $name_1 = $result[0]['created_date'];
// $row = explode(" ",$name_1);
// $name = $row[0];
$name = 'Premium_Register_(General)';
$show_data['premium_register_general_report'] = $result;
$this->load->helper('amountinwords');
$this->load->helper(array('timesheet', 'file'));
$timesheet_result = create_timesheet_premium_register($result, $folder, $name, $report_heading);
if ($timesheet_result != '') {
redirect(base_url() . 'timesheet/reports/production/premium_register_general/' . $timesheet_result . '.xlsx');
exit;
}
} else {
$show_data['error'] = 'No Data Found';
}
}
}
$this->load->view('underwriter/reports_view', $show_data);
}
