private function report_list($format = "")
 {
     if ($format != "pdf") {
         $data['title'] = $this->lang->line("REPORT_UPLOAD_INCOME_REPORT_CITY_CORPORATION_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $city_corporation = $this->input->get('city_corporation');
         $city_corporation_ward = $this->input->get('city_corporation_ward');
         $from_date = $this->input->get('from_date');
         $to_date = $this->input->get('to_date');
         $data['from_date'] = $from_date;
         $data['to_date'] = $to_date;
         $data['report'] = $this->upload_report_model->get_city_corporation_report_upload_income($division, $zilla, $city_corporation, $city_corporation_ward, $from_date, $to_date);
         $this->load->view('default/report/upload_income/upload_income_report_city_corporation_report', $data);
     } else {
         $data['title'] = $this->lang->line("REPORT_UPLOAD_INCOME_REPORT_CITY_CORPORATION_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $city_corporation = $this->input->get('city_corporation');
         $city_corporation_ward = $this->input->get('city_corporation_ward');
         $from_date = $this->input->get('from_date');
         $to_date = $this->input->get('to_date');
         $data['from_date'] = $from_date;
         $data['to_date'] = $to_date;
         $data['report'] = $this->upload_report_model->get_city_corporation_report_upload_income($division, $zilla, $city_corporation, $city_corporation_ward, $from_date, $to_date);
         $html = $this->load->view('default/report/upload_income/upload_income_report_city_corporation_report', $data, true);
         //echo $html;
         System_helper::get_pdf($html);
     }
 }
 private function report_list($format = "")
 {
     if ($format != "pdf") {
         $data['title'] = $this->lang->line("REPORT_UPLOAD_REPORT_MUNICIPAL_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $municipal = $this->input->get('municipal');
         $municipal_ward = $this->input->get('municipal_ward');
         $from_date = $this->input->get('from_date');
         $to_date = $this->input->get('to_date');
         $data['from_date'] = $from_date;
         $data['to_date'] = $to_date;
         $data['report'] = $this->upload_report_model->get_municipal_report_upload_status($division, $zilla, $municipal, $municipal_ward, $from_date, $to_date);
         $this->load->view('default/report/upload/upload_report_municipal_report', $data);
     } else {
         $data['title'] = $this->lang->line("REPORT_UPLOAD_REPORT_MUNICIPAL_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $municipal = $this->input->get('municipal');
         $municipal_ward = $this->input->get('municipal_ward');
         $from_date = $this->input->get('from_date');
         $to_date = $this->input->get('to_date');
         $data['from_date'] = $from_date;
         $data['to_date'] = $to_date;
         $data['report'] = $this->upload_report_model->get_municipal_report_upload_status($division, $zilla, $municipal, $municipal_ward, $from_date, $to_date);
         $html = $this->load->view('default/report/upload/upload_report_municipal_report', $data, true);
         //echo $html;
         System_helper::get_pdf($html);
     }
 }
 private function report_list($format = "")
 {
     if ($format != "pdf") {
         $data['title'] = $this->lang->line("REPORT_CABINET_UNION_INCOME_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $upazila = $this->input->get('upazila');
         $union = $this->input->get('union');
         $from_date = $this->input->get('from_date');
         $to_date = $this->input->get('to_date');
         $data['from_date'] = $from_date;
         $data['to_date'] = $to_date;
         $data['report'] = $this->cabinet_report_model->get_cabinet_union_income($division, $zilla, $upazila, $union, $from_date, $to_date);
         $this->load->view('default/report/cabinet/cabinet_union_income_report', $data);
     } else {
         $data['title'] = $this->lang->line("REPORT_CABINET_UNION_INCOME_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $upazila = $this->input->get('upazila');
         $union = $this->input->get('union');
         $from_date = $this->input->get('from_date');
         $to_date = $this->input->get('to_date');
         $data['from_date'] = $from_date;
         $data['to_date'] = $to_date;
         $data['report'] = $this->cabinet_report_model->get_cabinet_union_income($division, $zilla, $upazila, $union, $from_date, $to_date);
         $html = $this->load->view('default/report/cabinet/cabinet_union_income_report', $data, true);
         //echo $html;
         System_helper::get_pdf($html);
     }
 }
Exemplo n.º 4
0
 public function get_product_name($str)
 {
     $CI =& get_instance();
     //$this->db->select('*');
     $CI->db->from($CI->config->item('table_product'));
     $this->db->like('product_name', $str, 'after');
     //        $CI->db->where();
     $CI->db->select("CONCAT(product_name, '.',product_code) as label", FALSE);
     $CI->db->select('product_name as product_name,product_code as product_code,serial_number as serial_numb,unit_price as unit_price,model_no as model_no,warranty_start_date as warranty_start_date,warranty_end_date as warranty_end_date,condition as status');
     $results = $this->db->get()->result_array();
     foreach ($results as &$val) {
         if ($val['status'] == 0) {
             $val['status'] = "সক্রিয়";
         } else {
             $val['status'] = "ত্রুটিপূর্ণ";
         }
         if ($val['warranty_start_date'] > 0) {
             $val['warranty_start_date'] = System_helper::display_date($val['warranty_start_date']);
         }
         if ($val['warranty_end_date'] > 0) {
             $val['warranty_end_date'] = System_helper::display_date($val['warranty_end_date']);
         }
     }
     return $results;
 }
 private function report_list($format = "")
 {
     if ($format != "pdf") {
         $data['title'] = $this->lang->line("REPORT_CABINET_MUNICIPAL_SERVICE_HOLDER_INCOME_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $municipal = $this->input->get('municipal');
         $municipal_ward = $this->input->get('municipal_ward');
         $from_date = $this->input->get('from_date');
         $to_date = $this->input->get('to_date');
         $data['from_date'] = $from_date;
         $data['to_date'] = $to_date;
         $data['report'] = $this->cabinet_report_model->get_cabinet_municipal_service_holder_income($division, $zilla, $municipal, $municipal_ward, $from_date, $to_date);
         $this->load->view('default/report/cabinet/cabinet_municipal_service_holder_income_report', $data);
     } else {
         $data['title'] = $this->lang->line("REPORT_CABINET_MUNICIPAL_SERVICE_HOLDER_INCOME_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $municipal = $this->input->get('municipal');
         $municipal_ward = $this->input->get('municipal_ward');
         $from_date = $this->input->get('from_date');
         $to_date = $this->input->get('to_date');
         $data['from_date'] = $from_date;
         $data['to_date'] = $to_date;
         $data['report'] = $this->cabinet_report_model->get_cabinet_municipal_service_holder_income($division, $zilla, $municipal, $municipal_ward, $from_date, $to_date);
         $html = $this->load->view('default/report/cabinet/cabinet_municipal_service_holder_income_report', $data, true);
         //echo $html;
         System_helper::get_pdf($html);
     }
 }
 private function report_list($format = "")
 {
     if ($format != "pdf") {
         $data['title'] = $this->lang->line("REPORT_CITY_CORPORATION_ACTIVITIES_LOGIN_STATUS_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $city_corporation = $this->input->get('city_corporation');
         $city_corporation_ward = $this->input->get('city_corporation_ward');
         $month = $this->input->get('month');
         $year = $this->input->get('year');
         $data['month'] = $month;
         $data['year'] = $year;
         $data['report'] = $this->uno_activities_login_status_model->get_uisc_registration_city_corporation_info($division, $zilla, $city_corporation, $city_corporation_ward, $month, $year);
         $this->load->view('default/report/activities_city_corporation_login_status_report', $data);
     } else {
         $data['title'] = $this->lang->line("REPORT_CITY_CORPORATION_ACTIVITIES_LOGIN_STATUS_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $city_corporation = $this->input->get('city_corporation');
         $city_corporation_ward = $this->input->get('city_corporation_ward');
         $month = $this->input->get('month');
         $year = $this->input->get('year');
         $data['month'] = $month;
         $data['year'] = $year;
         $data['report'] = $this->uno_activities_login_status_model->get_uisc_registration_city_corporation_info($division, $zilla, $city_corporation, $city_corporation_ward, $month, $year);
         $html = $this->load->view('default/report/uno_activities_login_status_report', $data, true);
         //echo $html;
         System_helper::get_pdf($html);
     }
 }
Exemplo n.º 7
0
 public function get_record_list()
 {
     $CI =& get_instance();
     $CI->db->from($CI->config->item('table_product_assign') . ' pa');
     $CI->db->select('pa.id,pa.received_by,pa.status,pa.assign_date,pa.return_date,pa.remarks,user.name_en user_name,product.product_name,received_by.name_en receiver_name');
     $CI->db->join($CI->config->item('table_users') . ' user', 'user.id = pa.user_id', 'LEFT');
     $CI->db->join($CI->config->item('table_users') . ' received_by', 'received_by.id = pa.received_by', 'LEFT');
     $CI->db->join($CI->config->item('table_product') . ' product', 'product.id = pa.product_id', 'LEFT');
     $CI->db->where('pa.status = 1');
     $results = $this->db->get()->result_array();
     foreach ($results as &$result) {
         $result['edit_link'] = $CI->get_encoded_url('asset_management/product_assign/index/edit/' . $result['id']);
         $result['assign_date'] = System_helper::display_date($result['assign_date']);
         $result['return_date'] = System_helper::display_date($result['return_date']);
         if ($result['status'] == $this->config->item('STATUS_ACTIVE')) {
             $result['status_text'] = $CI->lang->line('ACTIVE');
         } else {
             if ($result['status'] == $this->config->item('STATUS_INACTIVE')) {
                 $result['status_text'] = $CI->lang->line('INACTIVE');
             } else {
                 $result['status_text'] = $result['status'];
             }
         }
     }
     return $results;
 }
 private function report_list($format = "")
 {
     if ($format != "pdf") {
         $data['title'] = $this->lang->line("REPORT_MUNICIPAL_ACTIVITIES_LOGIN_STATUS_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $municipal = $this->input->get('municipal');
         $municipal_ward = $this->input->get('municipal_ward');
         $month = $this->input->get('month');
         $year = $this->input->get('year');
         $data['month'] = $month;
         $data['year'] = $year;
         $data['report'] = $this->uno_activities_login_status_model->get_municipal_user_activities_login_status($division, $zilla, $municipal, $municipal_ward, $month, $year);
         $this->load->view('default/report/activities_municipal_login_status_report', $data);
     } else {
         $data['title'] = $this->lang->line("REPORT_MUNICIPAL_ACTIVITIES_LOGIN_STATUS_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $municipal = $this->input->get('municipal');
         $municipal_ward = $this->input->get('municipal_ward');
         $month = $this->input->get('month');
         $year = $this->input->get('year');
         $data['month'] = $month;
         $data['year'] = $year;
         $data['report'] = $this->uno_activities_login_status_model->get_municipal_user_activities_login_status($division, $zilla, $municipal, $municipal_ward, $month, $year);
         $html = $this->load->view('default/report/activities_municipal_login_status_report', $data, true);
         //echo $html;
         System_helper::get_pdf($html);
     }
 }
Exemplo n.º 9
0
 private function report_list($format = "")
 {
     if ($format != "pdf") {
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $data['report_type'] = $this->input->get('report_type');
         $status = $this->input->get('status');
         $from_date = $this->input->get('from_date');
         $to_date = $this->input->get('to_date');
         $data['from_date'] = $from_date;
         $data['to_date'] = $to_date;
         $data['report_status'] = $status;
         if (!empty($status) && $this->input->get('report_type') == $this->config->item('ONLINE_UNION_GROUP_ID')) {
             $data['title'] = $this->lang->line("REPORT_UPLOAD_INCOME_REPORT_UNION_TITLE");
             $upazila = $this->input->get('upazila');
             $union = $this->input->get('union');
             $data['report'] = $this->upload_report_model->get_union_report_upload_income($division, $zilla, $upazila, $union, $from_date, $to_date, $status);
             $this->load->view('default/report/upload_income/upload_income_report_union_report', $data);
         } else {
             if (!empty($status) && $this->input->get('report_type') == $this->config->item('ONLINE_CITY_CORPORATION_WORD_GROUP_ID')) {
                 $data['title'] = $this->lang->line("REPORT_UPLOAD_INCOME_REPORT_CITY_CORPORATION_TITLE");
                 $city_corporation = $this->input->get('city_corporation');
                 $city_corporation_ward = $this->input->get('city_corporation_ward');
                 $data['report'] = $this->upload_report_model->get_city_corporation_report_upload_income($division, $zilla, $city_corporation, $city_corporation_ward, $from_date, $to_date, $status);
                 $this->load->view('default/report/upload_income/upload_income_report_city_corporation_report', $data);
             } else {
                 if (!empty($status) && $this->input->get('report_type') == $this->config->item('ONLINE_MUNICIPAL_WORD_GROUP_ID')) {
                     $data['title'] = $this->lang->line("REPORT_UPLOAD_INCOME_REPORT_MUNICIPAL_TITLE");
                     $municipal = $this->input->get('municipal');
                     $municipal_ward = $this->input->get('municipal_ward');
                     $data['report'] = $this->upload_report_model->get_municipal_report_upload_income($division, $zilla, $municipal, $municipal_ward, $from_date, $to_date, $status);
                     $this->load->view('default/report/upload_income/upload_income_report_municipal_report', $data);
                 } else {
                     $data['title'] = $this->lang->line("REPORT_UPLOAD_REPORT_TITLE");
                     $data['report'] = '';
                     $this->load->view('default/report/upload_income/upload_income_report_view', $data);
                 }
             }
         }
     } else {
         $this->load->model("report/upload_report_model");
         $data['title'] = $this->lang->line("REPORT_UPLOAD_REPORT_UNION_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $upazila = $this->input->get('upazila');
         $union = $this->input->get('union');
         $from_date = $this->input->get('from_date');
         $to_date = $this->input->get('to_date');
         $data['from_date'] = $from_date;
         $data['to_date'] = $to_date;
         $data['report'] = $this->upload_report_model->get_union_report_upload_status($division, $zilla, $upazila, $union, $from_date, $to_date);
         $html = $this->load->view('default/report/upload_income/upload_report_view', $data, true);
         //echo $html;
         System_helper::get_pdf($html);
     }
 }
Exemplo n.º 10
0
 public function __construct()
 {
     parent::__construct();
     $this->message = "";
     $this->permissions = User_helper::get_permission('Sys_module_task');
     if (isset($this->permissions['task_id']) && $this->permissions['task_id'] > 0) {
         $this->parent_module_id = System_helper::get_parent_id_of_task($this->permissions['task_id']);
     }
     $this->controller_url = 'sys_module_task';
     $this->load->model("sys_module_task_model");
 }
Exemplo n.º 11
0
 private function report_list($format = "")
 {
     if ($format != "pdf") {
         $data['title'] = $this->lang->line("PRODUCT_ASSIGN_RELATED_REPORT");
         $inputs = $this->input->get();
         $data['products'] = $this->Product_assign_report_model->get_product_list($inputs);
         $this->load->view('default/reports/product_assign_report/report_format', $data);
     } else {
         $data['title'] = $this->lang->line("REPORT_TITLE");
         $inputs = $this->input->get();
         $data['products'] = $this->Product_assign_report_model->get_product_list($inputs);
         $html = $this->load->view('default/reports/product_assign_report/report_format', $data, true);
         System_helper::get_pdf($html);
     }
 }
Exemplo n.º 12
0
 private function report_list($format = "")
 {
     if ($format != "pdf") {
         $data['title'] = $this->lang->line("PRODUCT_CURRENT_STATUS_REPORTS");
         $inputs = $this->input->get();
         $data['data'] = $this->Current_stock_model->get_product_list($inputs);
         $this->load->view('default/reports/current_stock/report_format', $data);
     } else {
         $data['title'] = $this->lang->line("TITLE");
         $inputs = $this->input->post();
         $data['data'] = $this->Current_stock_model->get_product_list($inputs);
         $html = $this->load->view('default/reports/current_stock/report_format', $data);
         System_helper::get_pdf($html);
     }
 }
Exemplo n.º 13
0
 private function report_list($format = "")
 {
     if ($format != "pdf") {
         $data['title'] = $this->lang->line("TICKET_RELATED_REPORT");
         $inputs = $this->input->get();
         $data['tickets'] = $this->ticket_reports_model->get_ticket_list($inputs);
         $this->load->view('default/reports/ticket_reports/report_format', $data);
     } else {
         $data['title'] = $this->lang->line("Title");
         $inputs = $this->input->get();
         $data['tickets'] = $this->ticket_reports_model->get_ticket_list($inputs);
         $html = $this->load->view('default/reports/ticket_reports/report_format', $data);
         System_helper::get_pdf($html);
     }
 }
Exemplo n.º 14
0
 private function report_list($format = "")
 {
     if ($format != "pdf") {
         $data['title'] = $this->lang->line("PRODUCT_RETURN_REPORTS");
         $inputs = $this->input->get();
         $data['products'] = $this->Product_return_model->get_product_list($inputs);
         $this->load->view('default/reports/product_return_reports/report_format', $data);
     } else {
         $data['title'] = $this->lang->line("REPORT_ENTREPRENEUR_INFO_TITLE");
         $inputs = $this->input->get();
         $data['products'] = $this->Product_reports_model->get_product_list($inputs);
         $html = $this->load->view('default/reports/product_reports/report_format', $data, true);
         System_helper::get_pdf($html);
     }
 }
Exemplo n.º 15
0
 public function get_product_list($inputs)
 {
     $CI =& get_instance();
     $CI->db->select('product.*');
     $CI->db->select('manufacture.manufacture_name');
     $CI->db->select('category.category_name');
     $CI->db->select('supplier.company_name');
     $CI->db->select('warehouse.warehouse_name');
     //        $CI->db->select('COUNT(product.product_name) no_of_product');
     $CI->db->from($CI->config->item('table_product') . ' product');
     if ($inputs['category']) {
         $CI->db->where('product.category_id', $inputs['category']);
     }
     if ($inputs['product_name']) {
         $CI->db->where('product.product_name', $inputs['product_name']);
     }
     if ($inputs['manufacture']) {
         $CI->db->where('product.manufacture_id', $inputs['manufacture']);
     }
     if ($inputs['supplier']) {
         $CI->db->where('product.supplier_id', $inputs['supplier']);
     }
     if ($inputs['warehouse']) {
         $CI->db->where('product.warehouse_id', $inputs['warehouse']);
     }
     //   $CI->db->order_by('product.id','ASC');
     //check product type
     if ($inputs['product_type'] == 'unassigned') {
         $CI->db->where('product_assign.product_id IS NULL', NULL, true);
         $CI->db->join($CI->config->item('table_product_assign') . ' product_assign', 'product_assign.product_id = product.id', 'LEFT');
     } elseif ($inputs['product_type'] == 'assigned') {
         $CI->db->where('product_assign.product_id IS NOT NULL', NULL, true);
         $CI->db->where('product_assign.status', 1);
         $CI->db->join($CI->config->item('table_product_assign') . ' product_assign', 'product_assign.product_id = product.id', 'LEFT');
     }
     $CI->db->join($CI->config->item('table_manufacture') . ' manufacture', 'manufacture.id = product.manufacture_id', 'LEFT');
     $CI->db->join($CI->config->item('table_product_category') . ' category', 'category.id = product.category_id', 'LEFT');
     $CI->db->join($CI->config->item('table_supplier') . ' supplier', 'supplier.id = product.supplier_id', 'LEFT');
     $CI->db->join($CI->config->item('table_warehouse') . ' warehouse', 'warehouse.id = product.warehouse_id', 'LEFT');
     //        $CI->db->order_by("product.id", "desc");
     // $CI->db->group_by('product.product_name');
     $results = $CI->db->get()->result_array();
     //echo $CI->db->last_query();
     foreach ($results as &$result) {
         $result['unit_price'] = System_helper::Get_Eng_to_Bng($result['unit_price']);
     }
     return $results;
 }
Exemplo n.º 16
0
 public function get_record_list()
 {
     $CI =& get_instance();
     $this->db->select("ticket_assign.user_id id, count(ticket_assign.ticket_issue_id) ticket_issue_id, users.name_bn, users.email,\r\n        users.mobile,users.pbx");
     $this->db->from($CI->config->item('table_ticket_assign'));
     $this->db->join($CI->config->item('table_users') . ' users', 'users.id = ticket_assign.user_id', 'LEFT');
     $this->db->where('ticket_assign.status =' . $this->config->item('STATUS_ASSIGN'));
     $this->db->group_by('ticket_assign.user_id');
     $users = $this->db->get()->result_array();
     //echo $this->db->last_query();
     foreach ($users as &$user) {
         $user['edit_link'] = $CI->get_encoded_url('ticket_management/ticket_assign/index/batch_details/' . $user['id']);
         $user['ticket_issue_id'] = System_helper::Get_Eng_to_Bng($user['ticket_issue_id']);
     }
     return $users;
 }
Exemplo n.º 17
0
 public function get_user_list()
 {
     $CI =& get_instance();
     $CI->db->from($CI->config->item('table_product_assign') . ' pa');
     $CI->db->select('pa.status,user.name_en user_name, user.email,user.phone');
     $CI->db->select('user.id id');
     $CI->db->select('count(pa.id) nub_of_product');
     $CI->db->join($CI->config->item('table_users') . ' user', 'user.id = pa.user_id', 'LEFT');
     //$CI->db->join($CI->config->item('table_product'). ' product','product.id = pa.product_id','LEFT');
     $CI->db->where('pa.status = 1');
     $CI->db->group_by('user.id');
     $results = $this->db->get()->result_array();
     foreach ($results as &$result) {
         $result['edit_link'] = $CI->get_encoded_url('asset_management/product_return/index/edit/' . $result['id']);
         $result['nub_of_product'] = System_helper::Get_Eng_to_Bng($result['nub_of_product']);
     }
     return $results;
 }
Exemplo n.º 18
0
 public function get_record_list()
 {
     $user = User_helper::get_user();
     if ($user->user_group_level == $this->config->item('END_GROUP_ID') || $user->user_group_level == $this->config->item('TOP_MANAGEMENT_GROUP_ID') || $user->user_group_level == $this->config->item('SUPPORT_GROUP_ID') || $user->user_group_level == $this->config->item('OPERATOR_GROUP_ID')) {
         $this->db->where('ticket_issue.user_id', $user->id);
     } else {
     }
     $CI =& get_instance();
     $this->db->select("core_01_users.name_bn,\r\n                            ticket_issue.id,\r\n                            ticket_issue.token,\r\n                            product.product_name,product.product_code,\r\n                            ticket_issue.`subject`,\r\n                            ticket_issue.`create_date`,\r\n                            ticket_issue.`status`");
     $this->db->from($CI->config->item('table_ticket_issue'));
     $this->db->join($CI->config->item('table_users') . ' core_01_users', 'core_01_users.id = ticket_issue.user_id', 'LEFT');
     $this->db->join($CI->config->item('table_product') . ' product', 'product.id = ticket_issue.product_id', 'LEFT');
     $this->db->order_by('ticket_issue.id', 'DESC');
     $users = $this->db->get()->result_array();
     //echo $this->db->last_query();
     foreach ($users as &$user) {
         $user['edit_link'] = $CI->get_encoded_url('ticket_management/ticket_issue/index/batch_details/' . $user['id']);
         if ($user['status'] == $this->config->item('STATUS_INACTIVE')) {
             $user['status_text'] = $CI->lang->line('PENDING');
         } else {
             if ($user['status'] == $this->config->item('STATUS_ACTIVE')) {
                 $user['status_text'] = $CI->lang->line('RESOLVE');
             } else {
                 if ($user['status'] == $this->config->item('STATUS_ASSIGN')) {
                     $user['status_text'] = $CI->lang->line('ASSIGN');
                 } else {
                     if ($user['status'] == $this->config->item('STATUS_RESOLVE')) {
                         $user['status_text'] = $CI->lang->line('RESOLVE');
                     } else {
                         if ($user['status'] == $this->config->item('STATUS_REJECT')) {
                             $user['status_text'] = $CI->lang->line('REJECT');
                         } else {
                             $user['status_text'] = $user['status'];
                         }
                     }
                 }
             }
         }
         $user['create_date_time'] = date('h:i A - d M,y', $user['create_date']);
         $user['id'] = System_helper::Get_Eng_to_Bng($user['id']);
     }
     return $users;
 }
Exemplo n.º 19
0
 public function get_record_list()
 {
     $user = User_helper::get_user();
     if ($user->user_group_level == $this->config->item('SUPPORT_GROUP_ID')) {
         $this->db->where('ticket_assign.user_id', $user->id);
     }
     $CI =& get_instance();
     $this->db->select("ticket_assign.id,\r\n                            ticket_assign.ticket_issue_id,\r\n                            ticket_assign.create_date,\r\n                            ticket_assign.priority,\r\n                            ticket_assign.`status`,\r\n                            `ticket_issue`.`subject`,\r\n                            product.product_name,product.product_code,\r\n                            users.name_bn,\r\n                            users_assign.name_bn support_name,\r\n                            ticket_assign.resolved_date");
     $this->db->from($CI->config->item('table_ticket_assign') . ' ticket_assign');
     $this->db->join($CI->config->item('table_ticket_issue') . ' ticket_issue', 'ticket_issue.id = ticket_assign.ticket_issue_id', 'INNER');
     $this->db->join($CI->config->item('table_users') . ' users', 'users.id = ticket_issue.user_id', 'INNER');
     $this->db->join($CI->config->item('table_users') . ' users_assign', 'users_assign.id = ticket_assign.user_id', 'INNER');
     $this->db->join($CI->config->item('table_product') . ' product', 'product.id = ticket_issue.product_id', 'LEFT');
     $this->db->where('ticket_assign.status =' . $this->config->item('STATUS_ASSIGN'));
     $this->db->order_by('ticket_assign.ticket_issue_id', 'DESC');
     $users = $this->db->get()->result_array();
     //echo $this->db->last_query();
     $all_priority = $CI->config->item('ticket_priority');
     foreach ($users as &$user) {
         $user['edit_link'] = $CI->get_encoded_url('ticket_management/ticket_resolve/index/edit/' . $user['id']);
         $user['ticket_issue_id'] = System_helper::Get_Eng_to_Bng($user['ticket_issue_id']);
         //            if($user['status']==$this->config->item('STATUS_ASSIGN'))
         //            {
         //                $user['status_text']=$CI->lang->line('ASSIGN');
         //            }
         //            else if($user['status']==$this->config->item('STATUS_RESOLVE'))
         //            {
         //                $user['status_text']=$CI->lang->line('RESOLVE');
         //            }
         //            else if($user['status']==$this->config->item('STATUS_REJECT'))
         //            {
         //                $user['status_text']=$CI->lang->line('REJECT');
         //            }
         //            else
         //            {
         //                $user['status_text']=$user['status'];
         //            }
         $user['create_date_time'] = date('h:i A - d M,y', $user['create_date']);
         $user['priority'] = isset($all_priority[$user['priority']]) ? $all_priority[$user['priority']] : '';
     }
     return $users;
 }
Exemplo n.º 20
0
 private function report_list($format = "")
 {
     if ($format != "pdf") {
         $data['title'] = $this->lang->line("REPORT_INVESTED_MONEY_UNION_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $upazila = $this->input->get('upazila');
         $union = $this->input->get('union');
         $data['getUiscInfos'] = $this->invested_money_model->get_invested_money_union_info($division, $zilla, $upazila, $union);
         $this->load->view('default/report/invested_money_union_report', $data);
     } else {
         $data['title'] = $this->lang->line("REPORT_UISC_REGISTRATION_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $upazila = $this->input->get('upazila');
         $union = $this->input->get('union');
         $data['getUiscInfos'] = $this->invested_money_model->get_invested_money_union_info($division, $zilla, $upazila, $union);
         $html = $this->load->view('default/report/invested_money_union_report', $data, true);
         System_helper::get_pdf($html);
     }
 }
 private function report_list($format = "")
 {
     if ($format != "pdf") {
         $data['title'] = $this->lang->line("REPORT_INVESTED_MONEY_MUNICIPAL_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $municipal = $this->input->get('municipal');
         $municipal_ward = $this->input->get('municipal_ward');
         $data['getUiscInfos'] = $this->invested_money_model->get_invested_money_municipal_info($division, $zilla, $municipal, $municipal_ward);
         $this->load->view('default/report/invested_money_municipal_report', $data);
     } else {
         $data['title'] = $this->lang->line("REPORT_INVESTED_MONEY_MUNICIPAL_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $municipal = $this->input->get('municipal');
         $municipal_ward = $this->input->get('municipal_ward');
         $data['getUiscInfos'] = $this->invested_money_model->get_invested_money_municipal_info($division, $zilla, $municipal, $municipal_ward);
         $html = $this->load->view('default/report/invested_money_municipal_report', $data, true);
         System_helper::get_pdf($html);
     }
 }
 private function report_list($format = "")
 {
     if ($format != "pdf") {
         $data['title'] = $this->lang->line("REPORT_INVESTED_MONEY_CITY_CORPORATION_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $city_corporation = $this->input->get('city_corporation');
         $city_corporation_ward = $this->input->get('city_corporation_ward');
         $data['getUiscInfos'] = $this->invested_money_model->get_invested_money_city_corporation_info($division, $zilla, $city_corporation, $city_corporation_ward);
         $this->load->view('default/report/invested_money_city_corporation_report', $data);
     } else {
         $data['title'] = $this->lang->line("REPORT_INVESTED_MONEY_CITY_CORPORATION_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $city_corporation = $this->input->get('city_corporation');
         $city_corporation_ward = $this->input->get('city_corporation_ward');
         $data['getUiscInfos'] = $this->invested_money_model->get_invested_money_city_corporation_info($division, $zilla, $city_corporation, $city_corporation_ward);
         $html = $this->load->view('default/report/invested_money_city_corporation_report', $data, true);
         System_helper::get_pdf($html);
     }
 }
 private function report_list($format = "")
 {
     if ($format != "pdf") {
         $data['title'] = $this->lang->line("REPORT_UISC_REGISTRATION_CITY_CORPORATION_USER_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $city_corporation = $this->input->get('city_corporation');
         $city_corporation_ward = $this->input->get('city_corporation_ward');
         $data['getUiscInfos'] = $this->uisc_registration_model->get_uisc_registration_city_corporation_user_info($division, $zilla, $city_corporation, $city_corporation_ward);
         $this->load->view('default/report/registered_city_corporation_user_report', $data);
     } else {
         $data['title'] = $this->lang->line("REPORT_UISC_REGISTRATION_CITY_CORPORATION_USER_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $city_corporation = $this->input->get('city_corporation');
         $city_corporation_ward = $this->input->get('city_corporation_ward');
         $data['getUiscInfos'] = $this->uisc_registration_model->get_uisc_registration_city_corporation_user_info($division, $zilla, $city_corporation, $city_corporation_ward);
         $html = $this->load->view('default/report/registered_city_corporation_user_report', $data, true);
         System_helper::get_pdf($html);
     }
 }
Exemplo n.º 24
0
 private function report_list($format = "")
 {
     if ($format != "pdf") {
         $data['title'] = $this->lang->line("REPORT_UISC_REGISTRATION_MUNICIPAL_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $municipal = $this->input->get('municipal');
         $municipal_ward = $this->input->get('municipal_ward');
         $uisc_status = $this->input->get('status');
         $data['getUiscInfos'] = $this->uisc_registration_model->get_uisc_registration_municipal_info($division, $zilla, $municipal, $municipal_ward, $uisc_status);
         $this->load->view('default/report/registered_municipal_report', $data);
     } else {
         $data['title'] = $this->lang->line("REPORT_UISC_REGISTRATION_MUNICIPAL_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $municipal = $this->input->get('municipal');
         $municipal_ward = $this->input->get('municipal_ward');
         $uisc_status = $this->input->get('status');
         $data['getUiscInfos'] = $this->uisc_registration_model->get_uisc_registration_municipal_info($division, $zilla, $municipal, $municipal_ward, $uisc_status);
         $html = $this->load->view('default/report/registered_municipal_report', $data, true);
         System_helper::get_pdf($html);
     }
 }
 private function report_list($format = "")
 {
     if ($format != "pdf") {
         $data['title'] = $this->lang->line("REPORT_UNO_ACTIVITIES_LOGIN_STATUS_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $upazila = $this->input->get('upazila');
         $union = $this->input->get('union');
         $data['getUiscInfos'] = $this->uno_activities_login_status_model->get_uno_user_activities_login_status($division, $zilla, $upazila, $union);
         $this->load->view('default/report/uno_activities_login_status_report', $data);
     } else {
         $data['title'] = $this->lang->line("REPORT_UNO_ACTIVITIES_LOGIN_STATUS_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $upazila = $this->input->get('upazila');
         $union = $this->input->get('union');
         $uisc_status = $this->input->get('status');
         $data['getUiscInfos'] = $this->uno_activities_login_status_model->get_uno_user_activities_login_status($division, $zilla, $upazila, $union, $uisc_status);
         $html = $this->load->view('default/report/uno_activities_login_status_report', $data, true);
         //echo $html;
         System_helper::get_pdf($html);
     }
 }
 private function report_list($format = "")
 {
     if ($format != "pdf") {
         $data['title'] = $this->lang->line("REPORT_UISC_REGISTRATION_UNION_USER_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $upazila = $this->input->get('upazila');
         $union = $this->input->get('union');
         $data['getUiscInfos'] = $this->uisc_registration_model->get_uisc_registration_union_user_info($division, $zilla, $upazila, $union);
         $this->load->view('default/report/registered_union_user_report', $data);
     } else {
         $data['title'] = $this->lang->line("REPORT_UISC_REGISTRATION_TITLE");
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $upazila = $this->input->get('upazila');
         $union = $this->input->get('union');
         $uisc_status = $this->input->get('status');
         $data['getUiscInfos'] = $this->uisc_registration_model->get_uisc_registration_union_user_info($division, $zilla, $upazila, $union, $uisc_status);
         $html = $this->load->view('default/report/registered_union_user_report', $data, true);
         //echo $html;
         System_helper::get_pdf($html);
     }
 }
 private function report_list($format = "")
 {
     if ($format != "pdf") {
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $data['report_type'] = $this->input->get('report_type');
         //$status=$this->input->get('status');
         $from_date = $this->input->get('from_date');
         $to_date = $this->input->get('to_date');
         $data['from_date'] = $from_date;
         $data['to_date'] = $to_date;
         //$data['report_status']=$status;
         if ($this->input->get('report_type') == $this->config->item('ONLINE_UNION_GROUP_ID')) {
             $data['title'] = $this->lang->line("REPORT_ENTREPRENEUR_TRAINING_INFO_UNION_TITLE");
             $upazila = $this->input->get('upazila');
             $union = $this->input->get('union');
             $data['report'] = $this->entrepreneur_training_info_report_model->get_entrepreneur_training_info_union($division, $zilla, $upazila, $union);
             $this->load->view('default/report/training/entrepreneur_training_info_union_report', $data);
         } else {
             if ($this->input->get('report_type') == $this->config->item('ONLINE_CITY_CORPORATION_WORD_GROUP_ID')) {
                 $data['title'] = $this->lang->line("REPORT_ENTREPRENEUR_TRAINING_INFO_CITY_CORPORATION_TITLE");
                 $city_corporation = $this->input->get('city_corporation');
                 $city_corporation_ward = $this->input->get('city_corporation_ward');
                 $data['report'] = $this->entrepreneur_training_info_report_model->get_entrepreneur_training_info_city_corporation($division, $zilla, $city_corporation, $city_corporation_ward, $from_date, $to_date);
                 $this->load->view('default/report/training/entrepreneur_training_info_city_corporation_report', $data);
             } else {
                 if ($this->input->get('report_type') == $this->config->item('ONLINE_MUNICIPAL_WORD_GROUP_ID')) {
                     $data['title'] = $this->lang->line("REPORT_ENTREPRENEUR_TRAINING_INFO_MUNICIPAL_TITLE");
                     $municipal = $this->input->get('municipal');
                     $municipal_ward = $this->input->get('municipal_ward');
                     $data['report'] = $this->entrepreneur_training_info_report_model->get_entrepreneur_training_info_municipal($division, $zilla, $municipal, $municipal_ward, $from_date, $to_date);
                     $this->load->view('default/report/training/entrepreneur_training_info_municipal_report', $data);
                 } else {
                     $data['title'] = $this->lang->line("REPORT_ENTREPRENEUR_TRAINING_INFO_TITLE");
                     $data['report'] = '';
                     $this->load->view('default/report/training/entrepreneur_training_info_report_view', $data);
                 }
             }
         }
     } else {
         $division = $this->input->get('division');
         $zilla = $this->input->get('zilla');
         $data['report_type'] = $this->input->get('report_type');
         //$status=$this->input->get('status');
         $from_date = $this->input->get('from_date');
         $to_date = $this->input->get('to_date');
         $data['from_date'] = $from_date;
         $data['to_date'] = $to_date;
         //$data['report_status']=$status;
         if ($this->input->get('report_type') == $this->config->item('ONLINE_UNION_GROUP_ID')) {
             $data['title'] = $this->lang->line("REPORT_ENTREPRENEUR_TRAINING_INFO_UNION_TITLE");
             $upazila = $this->input->get('upazila');
             $union = $this->input->get('union');
             $data['report'] = $this->entrepreneur_training_info_report_model->get_entrepreneur_training_info_union($division, $zilla, $upazila, $union);
             $html = $this->load->view('default/report/training/entrepreneur_training_info_union_report', $data, true);
         } else {
             if ($this->input->get('report_type') == $this->config->item('ONLINE_CITY_CORPORATION_WORD_GROUP_ID')) {
                 $data['title'] = $this->lang->line("REPORT_ENTREPRENEUR_TRAINING_INFO_CITY_CORPORATION_TITLE");
                 $city_corporation = $this->input->get('city_corporation');
                 $city_corporation_ward = $this->input->get('city_corporation_ward');
                 $data['report'] = $this->entrepreneur_training_info_report_model->get_entrepreneur_training_info_city_corporation($division, $zilla, $city_corporation, $city_corporation_ward, $from_date, $to_date);
                 $html = $this->load->view('default/report/training/entrepreneur_training_info_city_corporation_report', $data, true);
             } else {
                 if ($this->input->get('report_type') == $this->config->item('ONLINE_MUNICIPAL_WORD_GROUP_ID')) {
                     $data['title'] = $this->lang->line("REPORT_ENTREPRENEUR_TRAINING_INFO_MUNICIPAL_TITLE");
                     $municipal = $this->input->get('municipal');
                     $municipal_ward = $this->input->get('municipal_ward');
                     $data['report'] = $this->entrepreneur_training_info_report_model->get_entrepreneur_training_info_municipal($division, $zilla, $municipal, $municipal_ward, $from_date, $to_date);
                     $html = $this->load->view('default/report/training/entrepreneur_training_info_municipal_report', $data, true);
                 } else {
                     $data['title'] = $this->lang->line("REPORT_ENTREPRENEUR_TRAINING_INFO_TITLE");
                     $data['report'] = '';
                     $html = $this->load->view('default/report/training/entrepreneur_training_info_report_view', $data, true);
                 }
             }
         }
         System_helper::get_pdf($html);
     }
 }
Exemplo n.º 28
0
                        <th><?php 
    echo System_helper::Get_Eng_to_Bng(number_format($grand_total_income, 0));
    ?>
</th>
                        <th><?php 
    echo System_helper::Get_Eng_to_Bng(number_format($grand_total_service_holder, 0));
    ?>
</th>
                        <th><?php 
    echo System_helper::Get_Eng_to_Bng(number_format($grand_total_report_upload_percentage, 0));
    ?>
</th>
                        <th><?php 
    echo System_helper::Get_Eng_to_Bng(number_format($grand_total_income_percentage, 0));
    ?>
</th>
                        <th><?php 
    echo System_helper::Get_Eng_to_Bng(number_format($grand_total_service_holder_percentage, 0));
    ?>
</th>
                    </tr>
                    <?php 
}
?>
                </tbody>
            </table>
        </div>
    </div>
</div>
</body>
</html>
</td>
                        <?php 
            } else {
                if ($report_status == 3) {
                    ?>
                        <td><?php 
                    echo System_helper::Get_Eng_to_Bng($grand_total_local_service);
                    ?>
</td>
                        <?php 
                }
            }
        }
    }
    ?>
                    <td><?php 
    echo System_helper::Get_Eng_to_Bng($grand_total_all_service);
    ?>
</td>
                </tr>
            <?php 
}
?>

            </tbody>
        </table>
        </div>
    </div>
</div>
</body>
</html>
                            <!--                                <td>&nbsp;</td>-->
                            <!--                                <td align="right">--><?php 
    //echo $this->lang->line('TOTAL');
    ?>
<!--:</td>-->
                            <!--                                <td style="text-align: center;">--><?php 
    //echo System_helper::Get_Eng_to_Bng($total_division);
    ?>
<!--</td>-->
                            <!--                            </tr>-->
                            <tr>
                                <td>&nbsp;</td>
                                <td colspan="5" align="right"><?php 
    echo $this->lang->line('IN_TOTAL');
    ?>
: </td>
                                <td style="text-align: center;"><?php 
    echo System_helper::Get_Eng_to_Bng($total);
    ?>
</td>
                            </tr>
                            <?php 
}
?>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </body>
</html>