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