PHP System_helper类代码示例

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

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

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

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

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

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

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

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

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

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