private function dcms_save() { $user = User_helper::get_user(); $data = array(); if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $data['suggestion'] = $this->input->post('suggestion'); $data['date'] = date('Y-m-d'); $data['uisc_id'] = $user->uisc_id; $data['created'] = $user->id; $data['user_id'] = $user->id; $this->db->trans_start(); //DB Transaction Handle START Query_helper::add($this->config->item('table_suggestion'), $data); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $this->dcms_add(); } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } }
public function login() { $user = User_helper::get_user(); if ($user) { $this->dashboard_page(); } else { if ($this->input->post()) { if (User_helper::login($this->input->post("username"), $this->input->post("password"))) { $user = User_helper::get_user(); $user_info['user_id'] = $user->id; $user_info['login_time'] = time(); $user_info['ip_address'] = $this->input->ip_address(); $user_info['request_headers'] = json_encode($this->input->request_headers()); Query_helper::add($this->config->item('table_user_login_history'), $user_info); $this->dashboard_page($this->lang->line("MSG_LOGIN_SUCCESS")); } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_USERNAME_PASSWORD_INVALID"); $this->jsonReturn($ajax); } } else { $this->login_page(); //login page view } } }
public function index($service_id) { $user = User_helper::get_user(); $time = time(); $service_info = Query_helper::get_info($this->config->item('table_api_services'), '*', array('status =1', 'id =' . $service_id), 1); if ($service_info) { $data['auth_token'] = random_string('unique') . $time; $data['user_id'] = $user->id; $data['service_id'] = $service_id; $data['time'] = $time; $data['status'] = 1; $id = Query_helper::add($this->config->item('table_api_auth_token'), $data); if ($id) { redirect($service_info['service_url'] . $data['auth_token'], 'refresh'); } else { echo "Unable to save data"; } } else { echo "invalid service"; } }
private function system_save() { $user = User_helper::get_user(); $id = $this->input->post("id"); if ($id > 0) { if (!$this->permissions['edit']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } else { if (!$this->permissions['add']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $user_id = $this->input->post('user_id'); //$row_id=$this->input->post('row_id'); $ticket_issue_id = $this->input->post('ticket_issue_id'); $ticket_priority = $this->input->post('ticket_priority'); $count = count($this->input->post('row_id')); if ($id > 0) { // unset($ticket_detail['id']); // // $ticket_detail['update_by']=$user->id; // $ticket_detail['update_date']=time(); // // $this->db->trans_start(); //DB Transaction Handle START // // Query_helper::update($this->config->item('table_ticket_assign'),$ticket_detail,array("id = ".$id)); // // $this->db->trans_complete(); //DB Transaction Handle END // // if ($this->db->trans_status() === TRUE) // { // $this->message=$this->lang->line("MSG_UPDATE_SUCCESS"); // $save_and_new=$this->input->post('system_save_new_status'); // if($save_and_new==1) // { // $this->system_add(); // } // else // { // $this->system_list(); // } // } // else // { // $ajax['status']=false; // $ajax['system_message']=$this->lang->line("MSG_UPDATE_FAIL"); // $this->jsonReturn($ajax); // } } else { $ticket_detail['status'] = $this->config->item('STATUS_ASSIGN'); $ticket_detail['create_by'] = $user->id; $ticket_detail['create_date'] = time(); $ticket_issue_detail['status'] = $this->config->item('STATUS_ASSIGN'); $ticket_issue_detail['update_by'] = $user->id; $ticket_issue_detail['update_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START for ($i = 0; $i < $count; $i++) { if (isset($ticket_issue_id[$i])) { $ticket_detail['user_id'] = $user_id; $ticket_detail['ticket_issue_id'] = $ticket_issue_id[$i]; $ticket_detail['priority'] = $ticket_priority[$i]; Query_helper::add($this->config->item('table_ticket_assign'), $ticket_detail); Query_helper::update($this->config->item('table_ticket_issue'), $ticket_issue_detail, array("id = " . $ticket_issue_id[$i])); } } $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } } }
private function system_save() { $user = User_helper::get_user(); if (!$this->permissions['add']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $data = $this->input->post('product_assign'); $data['create_by'] = $user->id; $data['create_date'] = time(); $data['status'] = 1; $data['assign_date'] = strtotime($data['assign_date']); $data['return_date'] = strtotime($data['return_date']); $this->db->trans_start(); //DB Transaction Handle START $inserted_product = array(); foreach ($data['product_id'] as $product) { $data['product_id'] = $product; if (!in_array($product, $inserted_product)) { Query_helper::add($this->config->item('table_product_assign'), $data); } $inserted_product[] = $product; } $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } }
private function system_save() { $user = User_helper::get_user(); $id = $this->input->post("id"); if ($id > 0) { if (!$this->permissions['edit']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } else { if (!$this->permissions['add']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $supplier_detail = $this->input->post('supplier'); if ($id > 0) { unset($supplier_detail['id']); $supplier_detail['update_by'] = $user->id; $supplier_detail['update_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START Query_helper::update($this->config->item('table_supplier'), $supplier_detail, array("id = " . $id)); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_UPDATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL"); $this->jsonReturn($ajax); } } else { $supplier_detail['status'] = $this->config->item('STATUS_ACTIVE'); $supplier_detail['create_by'] = $user->id; $supplier_detail['create_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START Query_helper::add($this->config->item('table_supplier'), $supplier_detail); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } } }
private function system_save() { $user = User_helper::get_user(); $id = $this->input->post("id"); if (!$this->permissions['edit']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $tasks = $this->input->post('tasks'); $user_group_id = $this->input->post('id'); $time = time(); $this->db->trans_start(); //DB Transaction Handle START foreach ($tasks as $task) { $data = array(); if (isset($task['list']) && $task['list'] == 1) { $data['list'] = 1; } else { $data['list'] = 0; } if (isset($task['view']) && $task['view'] == 1) { $data['view'] = 1; } else { $data['view'] = 0; } if (isset($task['add']) && $task['add'] == 1) { $data['add'] = 1; } else { $data['add'] = 0; } if (isset($task['edit']) && $task['edit'] == 1) { $data['edit'] = 1; } else { $data['edit'] = 0; } if (isset($task['delete']) && $task['delete'] == 1) { $data['delete'] = 1; } else { $data['delete'] = 0; } if (isset($task['report']) && $task['report'] == 1) { $data['report'] = 1; } else { $data['report'] = 0; } if (isset($task['print']) && $task['print'] == 1) { $data['print'] = 1; } else { $data['print'] = 0; } if ($data['view'] || $data['add'] || $data['edit'] || $data['delete'] || $data['report'] || $data['print']) { $data['list'] = 1; } if ($task['ugr_id'] > 0) { $data['update_by'] = $user->id; $data['update_date'] = $time; Query_helper::update($this->config->item('table_user_group_role'), $data, array("id = " . $task['ugr_id'])); } else { $data['user_group_id'] = $user_group_id; $data['component_id'] = $task['component_id']; $data['module_id'] = $task['module_id']; $data['task_id'] = $task['task_id']; $data['create_by'] = $user->id; $data['create_date'] = $time; Query_helper::add($this->config->item('table_user_group_role'), $data); } } $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_ROLE_ASSIGN_SUCCESS"); $this->system_list(); } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_ROLE_ASSIGN_FAIL"); $this->jsonReturn($ajax); } } }
private function system_save() { $user = User_helper::get_user(); $id = $this->input->post("id"); if ($id > 0) { if (!$this->permissions['edit']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } else { if (!$this->permissions['add']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $data = array('name_en' => $this->input->post('name_en'), 'name_bn' => $this->input->post('name_bn'), 'component_id' => $this->input->post('component_id'), 'icon' => $this->input->post('icon'), 'description' => $this->input->post('description'), 'ordering' => $this->input->post('ordering'), 'status' => $this->input->post('status')); if ($id > 0) { $data['update_by'] = $user->id; $data['update_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START Query_helper::update($this->config->item('table_module'), $data, array("id = " . $id)); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_UPDATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL"); $this->jsonReturn($ajax); } } else { $data['create_by'] = $user->id; $data['create_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START Query_helper::add($this->config->item('table_module'), $data); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } } }
private function system_save() { $user = User_helper::get_user(); $id = $this->input->post("id"); if ($id > 0) { if (!$this->permissions['edit']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } else { if (!$this->permissions['add']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $data = $this->input->post('product'); $dir = $this->config->item("file_upload"); $uploaded = System_helper::upload_file($dir['users'], 1024, 'gif|jpg|png|doc|pdf|xls|xlsx'); $attachment = ''; if (array_key_exists('attachment', $uploaded)) { if ($uploaded['attachment']['status']) { $attachment = $uploaded['attachment']['info']['file_name']; } else { $ajax['status'] = false; $ajax['system_message'] = $this->message .= $uploaded['attachment']['message'] . '<br>'; $this->jsonReturn($ajax); } } if ($id > 0) { unset($data['id']); $data['update_by'] = $user->id; $data['attachment'] = $attachment; $data['status'] = 1; $data['warranty_start_date'] = strtotime($data['warranty_start_date']); $data['warranty_end_date'] = strtotime($data['warranty_end_date']); $data['purchase_date'] = strtotime($data['purchase_date']); $data['update_date'] = time(); $data['product_code'] = $data['product_code'][0]; $data['serial_number'] = $data['serial_number'][0]; $this->db->trans_start(); //DB Transaction Handle START Query_helper::update($this->config->item('table_product'), $data, array("id = " . $id)); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_UPDATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL"); $this->jsonReturn($ajax); } } else { $data['create_by'] = $user->id; $data['create_date'] = time(); $data['status'] = 1; $data['attachment'] = $attachment; $data['warranty_start_date'] = strtotime($data['warranty_start_date']); $data['warranty_end_date'] = strtotime($data['warranty_end_date']); $data['purchase_date'] = strtotime($data['purchase_date']); $data['quantity'] = 1; $product_code = $data['product_code']; $serial_number = $data['serial_number']; unset($data['product_code']); unset($data['serial_number']); $this->db->trans_start(); //DB Transaction Handle START foreach ($product_code as $key => $code) { $data['product_code'] = $code; $data['serial_number'] = $serial_number[$key]; Query_helper::add($this->config->item('table_product'), $data); } $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } } }
private function system_save() { $user = User_helper::get_user(); $id = $this->input->post("id"); if ($id > 0) { if (!$this->permissions['edit']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } else { if (!$this->permissions['add']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $media_info = $this->input->post('media'); $dir = $this->config->item("dcms_upload"); if ($media_info['media_type'] == 1) { $directory = $dir['media_photo']; unset($media_info['video_link']); unset($media_info['print_year']); unset($media_info['external_link']); } elseif ($media_info['media_type'] == 2) { $directory = $dir['media_photo']; unset($media_info['print_year']); unset($media_info['external_link']); } elseif ($media_info['media_type'] == 3) { $directory = $dir['media_print']; unset($media_info['video_link']); } elseif ($media_info['media_type'] == 4) { $directory = $dir['media_publication']; unset($media_info['video_link']); unset($media_info['print_year']); } $uploaded = System_helper::upload_file($directory, 5120, 'gif|jpg|png|pdf|doc|docx'); if (array_key_exists('file_name', $uploaded)) { if ($uploaded['file_name']['status']) { $media_info['file_name'] = $uploaded['file_name']['info']['file_name']; } else { $ajax['status'] = false; $ajax['system_message'] = $this->message .= $uploaded['file_name']['message'] . '<br>'; $this->jsonReturn($ajax); } } if ($id > 0) { unset($media_info['id']); $media_info['update_by'] = $user->id; $media_info['update_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START Query_helper::update($this->config->item('table_media'), $media_info, array("id = " . $id)); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_UPDATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL"); $this->jsonReturn($ajax); } } else { $media_info['create_by'] = $user->id; $media_info['create_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START Query_helper::add($this->config->item('table_media'), $media_info); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } } }
private function system_save() { //print_r($this->input->post());exit; $user = User_helper::get_user(); $id = $this->input->post("id"); if ($id > 0) { if (!$this->permissions['edit']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } else { if (!$this->permissions['add']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $notice_detail = $this->input->post('notice_detail'); $notice_detail_general = array(); $notice_detail_specific = array(); $dir = $this->config->item("dcms_upload"); $uploaded = System_helper::upload_file($dir['notice'], 5120, 'gif|jpg|png|pdf'); if (array_key_exists('upload_file', $uploaded)) { if ($uploaded['upload_file']['status']) { $notice_detail['upload_file'] = $uploaded['upload_file']['info']['file_name']; } else { $ajax['status'] = false; $ajax['desk_message'] = $this->message .= $uploaded['upload_file']['message'] . '<br>'; $this->jsonReturn($ajax); } } if ($id > 0) { unset($notice_detail['id']); $this->db->trans_start(); //DB Transaction Handle START $notice_detail['update_by'] = $user->id; $notice_detail['update_date'] = time(); Query_helper::update($this->config->item('table_notice'), $notice_detail, array("id = " . $id)); if ($notice_detail['notice_type'] == 1) { $general_user_groups = $this->input->post('general_user_group'); // Initial Update $this->notice_create_model->initial_notice_update($id); $existing_general_viewers = $this->notice_create_model->existing_viewer_groups($id); foreach ($general_user_groups as $general_user_group) { if (in_array($general_user_group, $existing_general_viewers)) { $notice_detail_general['status'] = $this->config->item('STATUS_ACTIVE'); Query_helper::update($this->config->item('table_notice_view'), $notice_detail_general, array("notice_id = " . $id, "viewer_user_group =" . $general_user_group)); } else { $notice_detail_general['viewer_user_group'] = $general_user_group; $notice_detail_general['sender_user_group'] = $user->user_group_id; $notice_detail_general['notice_id'] = $id; $notice_detail_general['status'] = $notice_detail['status']; Query_helper::add($this->config->item('table_notice_view'), $notice_detail_general); } } } elseif ($notice_detail['notice_type'] == 2) { $sup_group_post = $this->input->post('sub_group'); if (sizeof($sup_group_post) > 0) { // Initial Update $this->notice_create_model->initial_notice_update($id); $existing_specific_viewers = $this->notice_create_model->existing_viewer_groups($id); foreach ($sup_group_post as $sup_group) { if (in_array($sup_group, $existing_specific_viewers)) { $notice_detail_specific['status'] = $this->config->item('STATUS_ACTIVE'); Query_helper::update($this->config->item('table_notice_view'), $notice_detail_specific, array("notice_id = " . $id, "viewer_user_group=" . $sup_group)); } else { $notice_detail_specific['viewer_user_group'] = $sup_group; $notice_detail_specific['sender_user_group'] = $user->user_group_id; $notice_detail_specific['notice_id'] = $id; $notice_detail_specific['division'] = $this->input->post('division'); $notice_detail_specific['zilla'] = $this->input->post('zilla'); $notice_detail_specific['upazila'] = $this->input->post('upazila'); $notice_detail_specific['unioun'] = $this->input->post('union'); $notice_detail_specific['citycorporation'] = $this->input->post('city_corporation'); $notice_detail_specific['citycorporationward'] = $this->input->post('city_corporation_ward'); $notice_detail_specific['municipal'] = $this->input->post('municipal'); $notice_detail_specific['municipalward'] = $this->input->post('municipal_ward'); $notice_detail_specific['uisc_id'] = $this->input->post('digital_center'); $notice_detail_specific['status'] = $notice_detail['status']; Query_helper::add($this->config->item('table_notice_view'), $notice_detail_specific); } } } else { $notice_detail_specific['viewer_user_group'] = $this->input->post('specific_user_level'); $notice_detail_specific['sender_user_group'] = $user->user_group_id; $notice_detail_specific['notice_id'] = $id; $notice_detail_specific['division'] = $this->input->post('division'); $notice_detail_specific['zilla'] = $this->input->post('zilla'); $notice_detail_specific['upazila'] = $this->input->post('upazila'); $notice_detail_specific['unioun'] = $this->input->post('union'); $notice_detail_specific['citycorporation'] = $this->input->post('city_corporation'); $notice_detail_specific['citycorporationward'] = $this->input->post('city_corporation_ward'); $notice_detail_specific['municipal'] = $this->input->post('municipal'); $notice_detail_specific['municipalward'] = $this->input->post('municipal_ward'); $notice_detail_specific['uisc_id'] = $this->input->post('digital_center'); $notice_detail_specific['status'] = $notice_detail['status']; Query_helper::update($this->config->item('table_notice_view'), $notice_detail_specific, array("notice_id = " . $id)); } } $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_UPDATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL"); $this->jsonReturn($ajax); } } else { $notice_detail['create_by'] = $user->id; $notice_detail['create_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START $notice_id = Query_helper::add($this->config->item('table_notice'), $notice_detail); if ($notice_detail['notice_type'] == 1) { $general_user_groups = $this->input->post('general_user_group'); foreach ($general_user_groups as $general_user_group) { $notice_detail_general['viewer_user_group'] = $general_user_group; $notice_detail_general['sender_user_group'] = $user->user_group_id; $notice_detail_general['notice_id'] = $notice_id; $notice_detail_general['status'] = $notice_detail['status']; Query_helper::add($this->config->item('table_notice_view'), $notice_detail_general); } } elseif ($notice_detail['notice_type'] == 2) { $sup_group_post = $this->input->post('sub_group'); if (sizeof($sup_group_post) > 0) { foreach ($sup_group_post as $sup_group) { $notice_detail_specific['viewer_user_group'] = $sup_group; $notice_detail_specific['sender_user_group'] = $user->user_group_id; $notice_detail_specific['notice_id'] = $notice_id; $notice_detail_specific['division'] = $this->input->post('division'); $notice_detail_specific['zilla'] = $this->input->post('zilla'); $notice_detail_specific['upazila'] = $this->input->post('upazila'); $notice_detail_specific['unioun'] = $this->input->post('union'); $notice_detail_specific['citycorporation'] = $this->input->post('city_corporation'); $notice_detail_specific['citycorporationward'] = $this->input->post('city_corporation_ward'); $notice_detail_specific['municipal'] = $this->input->post('municipal'); $notice_detail_specific['municipalward'] = $this->input->post('municipal_ward'); $notice_detail_specific['uisc_id'] = $this->input->post('digital_center'); $notice_detail_specific['status'] = $notice_detail['status']; Query_helper::add($this->config->item('table_notice_view'), $notice_detail_specific); } } else { $notice_detail_specific['viewer_user_group'] = $this->input->post('specific_user_level'); $notice_detail_specific['sender_user_group'] = $user->user_group_id; $notice_detail_specific['notice_id'] = $notice_id; $notice_detail_specific['division'] = $this->input->post('division'); $notice_detail_specific['zilla'] = $this->input->post('zilla'); $notice_detail_specific['upazila'] = $this->input->post('upazila'); $notice_detail_specific['unioun'] = $this->input->post('union'); $notice_detail_specific['citycorporation'] = $this->input->post('city_corporation'); $notice_detail_specific['citycorporationward'] = $this->input->post('city_corporation_ward'); $notice_detail_specific['municipal'] = $this->input->post('municipal'); $notice_detail_specific['municipalward'] = $this->input->post('municipal_ward'); $notice_detail_specific['uisc_id'] = $this->input->post('digital_center'); $notice_detail_specific['status'] = $notice_detail['status']; Query_helper::add($this->config->item('table_notice_view'), $notice_detail_specific); } } $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } } }
private function system_save() { $user = User_helper::get_user(); $id = $this->input->post("id"); if ($id > 0) { if (!$this->permissions['edit']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } else { if (!$this->permissions['add']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $zilla_detail = $this->input->post('zilla_detail'); if ($id > 0) { //$zilla_detail['update_by']=$user->id; //$zilla_detail['update_date']=time(); $this->db->trans_start(); //DB Transaction Handle START Query_helper::update($this->config->item('table_zillas'), $zilla_detail, array("id = " . $id)); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_UPDATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL"); $this->jsonReturn($ajax); } } else { //$zilla_detail['create_by']=$user->id; //$zilla_detail['create_date']=time(); $divid = $zilla_detail['divid']; $zillas = Query_helper::get_info($this->config->item('table_zillas'), array('MAX(zillaid) as max_zilla_id'), array("divid = " . $divid)); if (strlen($zillas[0]['max_zilla_id'] + 1) == 1) { $zillaid = "0" . ($zillas[0]['max_zilla_id'] + 1); } else { $zillaid = $zillas[0]['max_zilla_id'] + 1; } $zilla_detail['zillaid'] = $zillaid; $this->db->trans_start(); //DB Transaction Handle START Query_helper::add($this->config->item('table_zillas'), $zilla_detail); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } } }
private function system_save() { $user = User_helper::get_user(); $id = $this->input->post("id"); if ($id > 0) { if (!$this->permissions['edit']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } else { if (!$this->permissions['add']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $comment_detail = $this->input->post('comment'); if ($id > 0) { $this->db->trans_start(); //DB Transaction Handle START if ($user->user_group_level == $this->config->item('SUPPORT_GROUP_ID')) { $comment_detail['type'] = $this->config->item('ticket_comment_support_user'); $comment_detail['ticket_assign_id'] = $id; $comment_detail['create_by'] = $user->id; $comment_detail['create_date'] = time(); Query_helper::add($this->config->item('table_ticket_resolve_comment'), $comment_detail); } elseif ($user->user_group_level == $this->config->item('OFFICER_GROUP_ID')) { $comment_detail['type'] = $this->config->item('ticket_comment_manager'); $comment_detail['ticket_assign_id'] = $id; $comment_detail['create_by'] = $user->id; $comment_detail['create_date'] = time(); Query_helper::add($this->config->item('table_ticket_resolve_comment'), $comment_detail); $ticket_issue_detail['update_by'] = $user->id; $ticket_issue_detail['create_date'] = time(); if (!empty($comment_detail['ticket_status_id'])) { $ticket_issue_detail['status'] = $comment_detail['ticket_status_id']; } else { unset($ticket_issue_detail['status']); } Query_helper::update($this->config->item('table_ticket_issue'), $ticket_issue_detail, array("id = " . $comment_detail['ticket_issue_id'])); $ticket_assign_detail['update_by'] = $user->id; $ticket_assign_detail['create_date'] = time(); if (!empty($comment_detail['ticket_status_id'])) { $ticket_assign_detail['status'] = $comment_detail['ticket_status_id']; } else { unset($ticket_assign_detail['status']); } Query_helper::update($this->config->item('table_ticket_assign'), $ticket_assign_detail, array("id = " . $id)); } elseif ($user->user_group_level == $this->config->item('END_GROUP_ID')) { $comment_detail['type'] = $this->config->item('ticket_comment_end_user'); $comment_detail['ticket_assign_id'] = $id; $comment_detail['create_by'] = $user->id; $comment_detail['create_date'] = time(); Query_helper::add($this->config->item('table_ticket_resolve_comment'), $comment_detail); } else { } $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_UPDATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL"); $this->jsonReturn($ajax); } } else { // $comment_detail['status']=$this->config->item('STATUS_PENDING'); // $comment_detail['create_by']=$user->id; // $comment_detail['create_date']=time(); // // $ticket_issue_detail['status']=$this->config->item('STATUS_ASSIGN'); // $ticket_issue_detail['create_by']=$user->id; // $ticket_issue_detail['create_date']=time(); // // $this->db->trans_start(); //DB Transaction Handle START // for($i=0;$i<$count;$i++) // { // if(isset($ticket_issue_id[$i])) // { // //echo $ticket_issue_id[$i]."<br />"; // $comment_detail['user_id']=$user_id; // $comment_detail['ticket_issue_id']=$ticket_issue_id[$i]; // Query_helper::add($this->config->item('table_ticket_resolve'),$comment_detail); // Query_helper::update($this->config->item('table_ticket_issue'),$ticket_issue_detail,array("id = ".$ticket_issue_id[$i])); // } // } // // $this->db->trans_complete(); //DB Transaction Handle END // // if ($this->db->trans_status() === TRUE) // { // $this->message=$this->lang->line("MSG_CREATE_SUCCESS"); // $save_and_new=$this->input->post('system_save_new_status'); // if($save_and_new==1) // { // $this->system_add(); // } // else // { // $this->system_list(); // } // } // else // { // $ajax['status']=false; // $ajax['system_message']=$this->lang->line("MSG_CREATE_FAIL"); // $this->jsonReturn($ajax); // } } } }
private function system_save() { $user = User_helper::get_user(); $id = $this->input->post("id"); if ($id > 0) { if (!$this->permissions['edit']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } else { if (!$this->permissions['add']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $userDetail = $this->input->post('user_detail'); if ($id > 0) { if ($userDetail['password'] != "") { $encryptPass = md5(md5($userDetail['password'])); unset($userDetail['password']); unset($userDetail['confirm_password']); $userDetail['password'] = $encryptPass; } else { unset($userDetail['password']); unset($userDetail['confirm_password']); } } else { $encryptPass = md5(md5($userDetail['password'])); unset($userDetail['password']); unset($userDetail['confirm_password']); $userDetail['password'] = $encryptPass; } $user_group_id_level = explode('-', $this->input->post("user_detail[user_group_id]")); $user_group_id = $user_group_id_level[0]; $user_group_level = $user_group_id_level[1]; $userDetail['user_group_id'] = $user_group_id; if ($user_group_level == $this->config->item('SUPER_ADMIN_GROUP_ID') || $user_group_level == $this->config->item('A_TO_I_GROUP_ID') || $user_group_level == $this->config->item('DONOR_GROUP_ID') || $user_group_level == $this->config->item('MINISTRY_GROUP_ID')) { $userDetail['division'] = ''; $userDetail['zilla'] = ''; $userDetail['upazila'] = ''; $userDetail['unioun'] = ''; $userDetail['citycorporation'] = ''; $userDetail['citycorporationward'] = ''; $userDetail['municipal'] = ''; $userDetail['municipalward'] = ''; $userDetail['uisc_id'] = 0; } else { if ($user_group_level == $this->config->item('DIVISION_GROUP_ID')) { $userDetail['zilla'] = ''; $userDetail['upazila'] = ''; $userDetail['unioun'] = ''; $userDetail['citycorporation'] = ''; $userDetail['citycorporationward'] = ''; $userDetail['municipal'] = ''; $userDetail['municipalward'] = ''; $userDetail['uisc_id'] = 0; } else { if ($user_group_level == $this->config->item('DISTRICT_GROUP_ID')) { $userDetail['upazila'] = ''; $userDetail['unioun'] = ''; $userDetail['citycorporation'] = ''; $userDetail['citycorporationward'] = ''; $userDetail['municipal'] = ''; $userDetail['municipalward'] = ''; $userDetail['uisc_id'] = 0; } else { if ($user_group_level == $this->config->item('UPAZILLA_GROUP_ID')) { $userDetail['unioun'] = ''; $userDetail['citycorporation'] = ''; $userDetail['citycorporationward'] = ''; $userDetail['municipal'] = ''; $userDetail['municipalward'] = ''; $userDetail['uisc_id'] = 0; } else { if ($user_group_level == $this->config->item('UNION_GROUP_ID')) { $userDetail['citycorporation'] = ''; $userDetail['citycorporationward'] = ''; $userDetail['municipal'] = ''; $userDetail['municipalward'] = ''; $userDetail['uisc_id'] = 0; } else { if ($user_group_level == $this->config->item('CITY_CORPORATION_GROUP_ID')) { $userDetail['citycorporationward'] = ''; $userDetail['municipal'] = ''; $userDetail['municipalward'] = ''; $userDetail['uisc_id'] = 0; } else { if ($user_group_level == $this->config->item('CITY_CORPORATION_WORD_GROUP_ID')) { $userDetail['municipal'] = ''; $userDetail['municipalward'] = ''; $userDetail['uisc_id'] = 0; } else { if ($user_group_level == $this->config->item('MUNICIPAL_GROUP_ID')) { $userDetail['municipalward'] = ''; $userDetail['uisc_id'] = 0; } else { if ($user_group_level == $this->config->item('MUNICIPAL_WORD_GROUP_ID')) { $userDetail['uisc_id'] = 0; } } } } } } } } } // $dir=$this->config->item("system_upload"); // $uploaded_img = System_helper::upload_file($dir['user'],10240,'jpg|jpeg|png'); // // if(is_array($uploaded_img) && sizeof($uploaded_img)>0) // { // foreach($uploaded_img as $img) // { // $userDetail['picture_name'] = $img['info']['file_name']; // } // } // else // { // $userDetail['picture_name'] = 'no_image.jpg'; // } if ($id > 0) { $userDetail['update_by'] = $user->id; $userDetail['update_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START Query_helper::update($this->config->item('table_users'), $userDetail, array("id = " . $id)); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_UPDATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL"); $this->jsonReturn($ajax); } } else { $userDetail['create_by'] = $user->id; $userDetail['create_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START Query_helper::add($this->config->item('table_users'), $userDetail); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } } }
private function system_save() { $user = User_helper::get_user(); $id = $this->input->post("id"); if ($id > 0) { if (!$this->permissions['edit']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } else { if (!$this->permissions['add']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $time = time(); $user_id = $id; $uisc_id = $this->input->post('uisc_id'); if ($id > 0) { $this->db->trans_start(); //DB Transaction Handle START $dir = $this->config->item("dcms_upload"); $uploaded = System_helper::upload_file($dir['entrepreneur'], 10240, 'gif|jpg|png'); if (array_key_exists('profile_image', $uploaded)) { if ($uploaded['profile_image']['status']) { $user_data['picture_name'] = $uploaded['profile_image']['info']['file_name']; Query_helper::update($this->config->item('table_users'), $user_data, array("id = " . $user_id)); } else { $ajax['status'] = false; $ajax['system_message'] = $this->message .= $uploaded['profile_image']['message'] . '<br>'; $this->jsonReturn($ajax); } } // User Table update $user_update_data = array(); $user_update_data['name_bn'] = $this->input->post('entrepreneur_name'); $user_update_data['name_en'] = $this->input->post('entrepreneur_name'); Query_helper::update($this->config->item('table_users'), $user_update_data, array("id = " . $id)); //////// START CHAIRMEN INFO //////// $chairmen_info['update_by'] = $user->id; $chairmen_info['update_date'] = $time; //$chairmen_info['user_id']=$user_id; $chairmen_info['uisc_id'] = $uisc_id; $chairmen_info['chairmen_name'] = $this->input->post('chairmen_name'); $chairmen_info['chairmen_mobile'] = $this->input->post('chairmen_mobile'); $chairmen_info['chairmen_email'] = $this->input->post('chairmen_email'); $chairmen_info['chairmen_address'] = $this->input->post('chairmen_address'); if ($this->input->post('chairmen_id') > 0) { Query_helper::update($this->config->item('table_entrepreneur_chairmen_info'), $chairmen_info, array("id = " . $this->input->post('chairmen_id'))); } else { Query_helper::add($this->config->item('table_entrepreneur_chairmen_info'), $chairmen_info); } //////// END CHAIRMEN INFO //////// //////// START SECRETARY_RELATED_INFO //////// $secretary_info['update_by'] = $user->id; $secretary_info['update_date'] = $time; $secretary_info['user_id'] = $user_id; $secretary_info['uisc_id'] = $uisc_id; $secretary_info['secretary_name'] = $this->input->post('secretary_name'); $secretary_info['secretary_mobile'] = $this->input->post('secretary_mobile'); $secretary_info['secretary_email'] = $this->input->post('secretary_email'); $secretary_info['secretary_address'] = $this->input->post('secretary_address'); if ($this->input->post('secretary_id') > 0) { Query_helper::update($this->config->item('table_secretary_infos'), $secretary_info, array("id = " . $this->input->post('secretary_id'))); } else { Query_helper::add($this->config->item('table_secretary_infos'), $secretary_info); } //////// END SECRETARY_RELATED_INFO //////// //////// START ENTREPRENEUR_RELATED_INFO //////// $entrepreneur_info['update_by'] = $user->id; $entrepreneur_info['update_date'] = $time; $entrepreneur_info['user_id'] = $user_id; $entrepreneur_info['uisc_id'] = $uisc_id; $entrepreneur_info['entrepreneur_type'] = $this->input->post('entrepreneur_exp_type'); $entrepreneur_info['entrepreneur_name'] = $this->input->post('entrepreneur_name'); $entrepreneur_info['entrepreneur_mother_name'] = $this->input->post('entrepreneur_mother_name'); $entrepreneur_info['entrepreneur_father_name'] = $this->input->post('entrepreneur_father_name'); $entrepreneur_info['entrepreneur_mobile'] = $this->input->post('entrepreneur_mobile'); $entrepreneur_info['entrepreneur_email'] = $this->input->post('entrepreneur_email'); $entrepreneur_info['entrepreneur_sex'] = $this->input->post('entrepreneur_sex'); $entrepreneur_info['entrepreneur_address'] = $this->input->post('entrepreneur_address'); $entrepreneur_info['entrepreneur_nid'] = $this->input->post('entrepreneur_nid'); $entrepreneur_info['entrepreneur_bank_name'] = $this->input->post('entrepreneur_bank_name'); $entrepreneur_info['entrepreneur_bank_account_no'] = $this->input->post('entrepreneur_bank_account_no'); $entrepreneur_info['entrepreneur_bank_holder_name'] = $this->input->post('entrepreneur_bank_holder_name'); $entrepreneur_info['entrepreneur_blog_member'] = $this->input->post('entrepreneur_blog_member'); $entrepreneur_info['entrepreneur_fb_group_member'] = $this->input->post('entrepreneur_fb_group_member'); //$entrepreneur_info['ques_id']=$this->input->post('ques_id'); //$entrepreneur_info['ques_ans']=$this->input->post('ques_ans'); if ($this->input->post('entrepreneur_id') > 0) { Query_helper::update($this->config->item('table_entrepreneur_infos'), $entrepreneur_info, array("id = " . $this->input->post('entrepreneur_id'))); } else { Query_helper::add($this->config->item('table_entrepreneur_infos'), $entrepreneur_info); } //////// END ENTREPRENEUR_RELATED_INFO //////// //////// START EDUCATION_RELATED_INFO //////// $education_info['update_by'] = $user->id; $education_info['update_date'] = $time; $education_info['user_id'] = $user_id; $education_info['uisc_id'] = $uisc_id; $education_info['latest_education'] = $this->input->post('latest_education'); $education_info['passing_year'] = $this->input->post('passing_year'); if ($this->input->post('education_id') > 0) { Query_helper::update($this->config->item('table_entrepreneur_education'), $education_info, array("id = " . $this->input->post('education_id'))); } else { Query_helper::add($this->config->item('table_entrepreneur_education'), $education_info); } //////// END EDUCATION_RELATED_INFO //////// //////// START ENTREPRENEUR_TRAINING_RELATED_INFO //////// $training_info['update_by'] = $user->id; $training_info['update_date'] = $time; $training_info['user_id'] = $user_id; $training_info['uisc_id'] = $uisc_id; $training_id = $this->input->post('training_id'); $course_name = $this->input->post('training_course'); $institute_name = $this->input->post('training_institute'); $timespan = $this->input->post('training_time'); for ($noc = 0; $noc < sizeof($training_id); $noc++) { $training_info['course_name'] = $course_name[$noc]; $training_info['institute_name'] = $institute_name[$noc]; $training_info['timespan'] = $timespan[$noc]; if (empty($training_id[$noc])) { Query_helper::add($this->config->item('table_training'), $training_info); } else { Query_helper::update($this->config->item('table_training'), $training_info, array("id = " . $training_id[$noc])); } } //////// END ENTREPRENEUR_TRAINING_RELATED_INFO //////// //////// START INVESTMENT_RELATED_INFO //////// $investment_info['update_by'] = $user->id; $investment_info['update_date'] = $time; $investment_info['user_id'] = $user_id; $investment_info['uisc_id'] = $uisc_id; $investment_info['self_investment'] = System_helper::Get_Bng_to_Eng(trim($this->input->post('self_investment'))); $investment_info['invest_debt'] = System_helper::Get_Bng_to_Eng(trim($this->input->post('invest_debt'))); $investment_info['invested_money'] = System_helper::Get_Bng_to_Eng(trim($this->input->post('self_investment'))) + System_helper::Get_Bng_to_Eng(trim($this->input->post('invest_debt'))); //System_helper::Get_Bng_to_Eng(trim($this->input->post('invested_money'))); $investment_info['invest_sector'] = $this->input->post('invest_sector'); if ($this->input->post('investment_id') > 0) { Query_helper::update($this->config->item('table_investment'), $investment_info, array("id = " . $this->input->post('investment_id'))); } else { Query_helper::add($this->config->item('table_investment'), $investment_info); } //////// END INVESTMENT_RELATED_INFO //////// //////// START CENTER_LOCATION_RELATED_INFO //////// $location_info['update_by'] = $user->id; $location_info['update_date'] = $time; $location_info['user_id'] = $user_id; $location_info['uisc_id'] = $uisc_id; $location_info['center_type'] = $this->input->post('center_location'); if ($this->input->post('location_id') > 0) { Query_helper::update($this->config->item('table_center_location'), $location_info, array("id = " . $this->input->post('location_id'))); } else { Query_helper::add($this->config->item('table_center_location'), $location_info); } //////// END CENTER_LOCATION_RELATED_INFO //////// //////// START EQUIPMENT //////// $resources_info['update_by'] = $user->id; $resources_info['update_date'] = $time; $resources_info['user_id'] = $user_id; $resources_info['uisc_id'] = $uisc_id; $resources_id = $this->input->post('resources_id'); $res_id = $this->input->post('res_id'); $res_detail = $this->input->post('res_detail'); $quantity = $this->input->post('quantity'); $status = $this->input->post('status'); for ($nor = 0; $nor < sizeof($resources_id); $nor++) { $resources_info['res_id'] = $res_id[$nor]; $resources_info['res_detail'] = $res_detail[$nor]; $resources_info['quantity'] = $quantity[$nor]; $resources_info['status'] = $status[$nor]; if (empty($resources_id[$nor])) { Query_helper::add($this->config->item('table_uisc_resources'), $resources_info); } else { Query_helper::update($this->config->item('table_uisc_resources'), $resources_info, array("id = " . $resources_id[$nor])); } } //////// END EQUIPMENT //////// //////// START DEVICE_RELATED_INFO //////// $device_info['update_by'] = $user->id; $device_info['update_date'] = $time; $device_info['user_id'] = $user_id; $device_info['uisc_id'] = $uisc_id; $device_info['connection_type'] = $this->input->post('connection_type'); $device_info['modem'] = $this->input->post('modem'); $device_info['ip_address'] = $this->input->post('ip_address'); if ($this->input->post('device_id') > 0) { Query_helper::update($this->config->item('table_device_infos'), $device_info, array("id = " . $this->input->post('device_id'))); } else { Query_helper::add($this->config->item('table_device_infos'), $device_info); } //////// END DEVICE_RELATED_INFO //////// //////// START ELECTRICITY_RELATED_INFO //////// $electricity_info['update_by'] = $user->id; $electricity_info['update_date'] = $time; $electricity_info['user_id'] = $user_id; $electricity_info['uisc_id'] = $uisc_id; $electricity_info['electricity'] = $this->input->post('electricity'); $electricity_info['solar'] = $this->input->post('solar'); $electricity_info['ips'] = $this->input->post('ips'); if ($this->input->post('electricity_id') > 0) { Query_helper::update($this->config->item('table_electricity'), $electricity_info, array("id = " . $this->input->post('electricity_id'))); } else { Query_helper::add($this->config->item('table_electricity'), $electricity_info); } //////// END ELECTRICITY_RELATED_INFO //////// $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_UPDATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL"); $this->jsonReturn($ajax); } } else { $userDetail['create_by'] = $user->id; $userDetail['create_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START Query_helper::add($this->config->item('table_users'), $userDetail); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } } }
private function system_save() { $user = User_helper::get_user(); if (!$this->permissions['add']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $data = $this->input->post('requisition'); $data['create_by'] = $user->id; $data['create_date'] = time(); $data['user_id'] = $user->id; $this->load->helper('string'); $data['requisition_id'] = time() . random_string('alpha', 3); $this->db->trans_start(); //DB Transaction Handle START Query_helper::add($this->config->item('table_requisition'), $data); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } }
private function system_save() { $user = User_helper::get_user(); $id = $this->input->post("id"); if ($id > 0) { if (!$this->permissions['edit']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } else { if (!$this->permissions['add']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $userDetail = $this->input->post('user_detail'); if ($id > 0) { if ($userDetail['password'] != "") { $encryptPass = md5(md5($userDetail['password'])); unset($userDetail['password']); unset($userDetail['confirm_password']); $userDetail['password'] = $encryptPass; } else { unset($userDetail['password']); unset($userDetail['confirm_password']); } } else { $encryptPass = md5(md5($userDetail['password'])); unset($userDetail['password']); unset($userDetail['confirm_password']); $userDetail['password'] = $encryptPass; } $user_group_id_level = explode('-', $this->input->post("user_detail[user_group_id]")); $user_group_id = $user_group_id_level[0]; //$user_group_level=$user_group_id_level[1]; $userDetail['user_group_id'] = $user_group_id; $date_of_birth = strtotime($userDetail['dob']); $userDetail['dob'] = $date_of_birth; $dir = $this->config->item("file_upload"); $uploaded = System_helper::upload_file($dir['users'], 1024, 'gif|jpg|png'); if (array_key_exists('picture_name', $uploaded)) { if ($uploaded['picture_name']['status']) { $userDetail['picture_name'] = $uploaded['picture_name']['info']['file_name']; } else { $ajax['status'] = false; $ajax['system_message'] = $this->message .= $uploaded['picture_name']['message'] . '<br>'; $this->jsonReturn($ajax); } } if ($id > 0) { unset($userDetail['id']); $userDetail['update_by'] = $user->id; $userDetail['update_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START Query_helper::update($this->config->item('table_users'), $userDetail, array("id = " . $id)); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_UPDATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL"); $this->jsonReturn($ajax); } } else { $userDetail['status'] = $this->config->item('STATUS_ACTIVE'); $userDetail['create_by'] = $user->id; $userDetail['create_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START Query_helper::add($this->config->item('table_users'), $userDetail); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } } }
private function system_save() { $user = User_helper::get_user(); $id = $this->input->post("id"); if ($id > 0) { if (!$this->permissions['edit']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } else { if (!$this->permissions['add']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $notice_detail = $this->input->post('notice_detail'); $dir = $this->config->item("dcms_upload"); $uploaded = System_helper::upload_file($dir['notice'], 1024, 'gif|jpg|png|pdf'); if (array_key_exists('upload_file', $uploaded)) { if ($uploaded['upload_file']['status']) { $notice_detail['upload_file'] = $uploaded['upload_file']['info']['file_name']; } else { $ajax['status'] = false; $ajax['desk_message'] = $this->message .= $uploaded['upload_file']['message'] . '<br>'; $this->jsonReturn($ajax); } } if ($this->input->post('public_notice') && $this->input->post('public_notice') == 1) { $notice_detail['public_status'] = 1; } else { $notice_detail['public_status'] = 0; } if ($id > 0) { unset($notice_detail['id']); $notice_detail['update_by'] = $user->id; $notice_detail['update_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START Query_helper::update($this->config->item('table_notice'), $notice_detail, array("id = " . $id)); $notice_inactive['status'] = $this->config->item('STATUS_INACTIVE'); Query_helper::update($this->config->item('table_notice_view'), $notice_inactive, array("notice_id = " . $id)); $user_group_id = $this->input->post('user_group_id'); $count = sizeof($user_group_id); for ($i = 0; $i < $count; $i++) { $check_box_elm = "viewer_group_id_" . $user_group_id[$i]; if ($this->input->post($check_box_elm)) { $check_box_id = $this->input->post($check_box_elm); $notice_view_detail['viewer_group_id'] = $check_box_id; $notice_view_detail['create_group_id'] = $user->user_group_id; $notice_view_detail['notice_id'] = $id; $notice_view_detail['status'] = $notice_detail['status']; Query_helper::add($this->config->item('table_notice_view'), $notice_view_detail); } } $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_UPDATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL"); $this->jsonReturn($ajax); } } else { $notice_detail['create_by'] = $user->id; $notice_detail['create_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START $notice_id = Query_helper::add($this->config->item('table_notice'), $notice_detail); $user_group_id = $this->input->post('user_group_id'); $count = sizeof($user_group_id); for ($i = 0; $i < $count; $i++) { $check_box_elm = "viewer_group_id_" . $user_group_id[$i]; if ($this->input->post($check_box_elm)) { $check_box_id = $this->input->post($check_box_elm); $notice_view_detail['viewer_group_id'] = $check_box_id; $notice_view_detail['create_group_id'] = $user->user_group_id; $notice_view_detail['notice_id'] = $notice_id; $notice_view_detail['status'] = $notice_detail['status']; Query_helper::add($this->config->item('table_notice_view'), $notice_view_detail); } } $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } } }
private function system_save() { $user = User_helper::get_user(); $id = $this->input->post("id"); if ($id > 0) { if (!$this->permissions['edit']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } else { if (!$this->permissions['add']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { if ($id > 0) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL"); $this->jsonReturn($ajax); } else { $data = array(); $user_id = $user->id; $uisc_id = $user->uisc_id; $data['uisc_id'] = $uisc_id; $data['user_id'] = $user_id; $data['question'] = $this->input->post('question'); $data['user_type'] = $this->input->post('user_group'); $data['create_by'] = $user_id; $data['create_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START Query_helper::add($this->config->item('table_faqs'), $data); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } } }
private function system_save() { $user = User_helper::get_user(); $id = $this->input->post("id"); if ($id > 0) { if (!$this->permissions['edit']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } else { if (!$this->permissions['add']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $ticket_detail = $this->input->post('ticket'); $dir = $this->config->item("file_upload"); $uploaded = System_helper::upload_file($dir['ticket_issue'], 1024, 'gif|jpg|png|xls|xlsx|pdf|doc|docx'); if (array_key_exists('issue_attachment', $uploaded)) { if ($uploaded['issue_attachment']['status']) { $ticket_detail['issue_attachment'] = $uploaded['issue_attachment']['info']['file_name']; } else { $ajax['status'] = false; $ajax['system_message'] = $this->message .= $uploaded['issue_attachment']['message'] . '<br>'; $this->jsonReturn($ajax); } } $comment_detail = $this->input->post('comment'); if ($id > 0) { unset($ticket_detail['id']); $ticket_detail['update_by'] = $user->id; $ticket_detail['update_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START //Query_helper::update($this->config->item('table_ticket_issue'),$ticket_detail,array("id = ".$id)); $comment_detail['type'] = $this->config->item('ticket_comment_end_user'); $comment_detail['ticket_issue_id'] = $id; $comment_detail['create_by'] = $user->id; $comment_detail['create_date'] = time(); Query_helper::add($this->config->item('table_ticket_resolve_comment'), $comment_detail); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_UPDATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL"); $this->jsonReturn($ajax); } } else { $ticket_detail['status'] = $this->config->item('STATUS_INACTIVE'); $ticket_detail['create_by'] = $user->id; $ticket_detail['create_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START Query_helper::add($this->config->item('table_ticket_issue'), $ticket_detail); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } } }
public function upload_excel_file() { $user = User_helper::get_user(); if ($_FILES["file"]['name'] != "") { $arr = explode(".", $_FILES["file"]['name']); $ext = $arr[sizeof($arr) - 1]; } $size = $_FILES["file"]['size']; $this->load->library('upload'); $fileName = 'template_' . $user->id . '_' . date('Ymdhis'); if ($ext == 'xls' || $ext == 'xlsx') { System_helper::upload_excel_file($fileName, $save_dir = "uploads/excel", $max_size = 60000, $types = 'xls|xlsx'); if ($ext == 'xls') { $path = "uploads/excel/" . $fileName . '.xls'; } else { $path = "uploads/excel/" . $fileName . '.xlsx'; } if ($size < 60000) { $i = 0; $totalcount = 0; $objPHPExcel = PHPExcel_IOFactory::load($path); foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) { $worksheetTitle = $worksheet->getTitle(); $highestRow = $worksheet->getHighestRow(); $highestColumn = $worksheet->getHighestColumn(); $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn); $nrColumns = ord($highestColumn) - 64; for ($row = 1; $row <= $highestRow; ++$row) { for ($col = 0; $col < $highestColumnIndex; ++$col) { $cell = $worksheet->getCellByColumnAndRow($col, $row); $val = $cell->getValue(); $dataType = PHPExcel_Cell_DataType::dataTypeForValue($val); } } } $total_men = 0; $total_women = 0; $total_tribe = 0; $total_disability = 0; $total_services = 0; $total_income = 0; $check_income = false; for ($row = 3; $row <= $highestRow; ++$row) { $val = array(); for ($col = 0; $col < $highestColumnIndex; ++$col) { $cell = $worksheet->getCellByColumnAndRow($col, $row); $val[] = $cell->getValue(); } if ($val[3] != "" && $val[3] != null) { $serial[$i] = System_helper::Get_Bng_to_Eng($val[0]); $customer_name[$i] = $val[1]; $gender[$i] = $val[2]; $service_name[$i] = $val[3]; $amount[$i] = System_helper::Get_Bng_to_Eng(abs($val[4])); if (strlen($amount[$i]) > 6) { $check_income = true; } if ($this->Service_template_model->check_uisc_service_existence($service_name[$i])) { $totalcount = $totalcount + $i; $total_services++; $total_income = $total_income + System_helper::Get_Bng_to_Eng($amount[$i]); if ($gender[$i] == $this->lang->line('MALE_VAL')) { $total_men++; } elseif ($gender[$i] == $this->lang->line('FEMALE_VAL')) { $total_women++; } elseif ($gender[$i] == $this->lang->line('TRIBE_VAL')) { $total_tribe++; } elseif ($gender[$i] == $this->lang->line('DISABILITY_VAL')) { $total_disability++; } } ++$i; } } $DateCell = $worksheet->getCellByColumnAndRow('1', '1'); $invDateRaw = $DateCell->getValue(); if (is_float($invDateRaw)) { $newDate = System_helper::ExcelToPHPDate($invDateRaw); $invDate = date('Y-m-d', $newDate); } else { $invDate = $invDateRaw; } if ($this->Service_template_model->chk_existing_uploded_excel_file($invDate) < 2) { $invoice_data = array(); $zilla_invoice_data = array(); $invoice_details_data = array(); $zilla_invoice_details_data = array(); $user_zilla = $user->zilla; $zilla_table_invoice = str_pad($user_zilla, 2, "0", STR_PAD_LEFT) . '_invoices'; $zilla_table_invoice_details = str_pad($user_zilla, 2, "0", STR_PAD_LEFT) . '_invoice_details'; $uisc_id = $user->uisc_id; $user_group_id = $user->user_group_id; $division = $user->division; $zilla = $user->zilla; $upazila = $user->upazila; $unioun = $user->unioun; $citycorporation = $user->citycorporation; //$citycorporationward = $user->citycorporationward; $municipal = $user->municipal; //$municipalward = $user->municipalward; $invoice_date = $invDate; $customerPost = $customer_name; $servicePost = $service_name; $genderPost = $gender; $earningPost = $amount; $count = sizeof($customerPost); $invoice_data['uisc_id'] = $uisc_id; $invoice_data['unionid'] = $unioun; $invoice_data['municipalid'] = $municipal; $invoice_data['citycorporationid'] = $citycorporation; $invoice_data['upazilaid'] = $upazila; $invoice_data['zillaid'] = $zilla; $invoice_data['divid'] = $division; $invoice_data['type'] = $user_group_id; $invoice_data['invoice_date'] = $invoice_date; $invoice_data['total_income'] = $total_income; $invoice_data['total_service'] = $total_services; $invoice_data['total_men'] = $total_men; $invoice_data['total_women'] = $total_women; $invoice_data['total_tribe'] = $total_tribe; $invoice_data['total_disability'] = $total_disability; $zilla_invoice_data['uisc_id'] = $uisc_id; $zilla_invoice_data['unionid'] = $unioun; $zilla_invoice_data['municipalid'] = $municipal; $zilla_invoice_data['citycorporationid'] = $citycorporation; $zilla_invoice_data['upazilaid'] = $upazila; $zilla_invoice_data['zillaid'] = $zilla; $zilla_invoice_data['divid'] = $division; $zilla_invoice_data['type'] = $user_group_id; $zilla_invoice_data['invoice_date'] = $invoice_date; $zilla_invoice_data['total_income'] = $total_income; $zilla_invoice_data['total_service'] = $total_services; $zilla_invoice_data['total_men'] = $total_men; $zilla_invoice_data['total_women'] = $total_women; // echo $zilla_table_invoice; // print_r($zilla_invoice_data);exit; if (!$check_income) { if ($total_services > 0) { $this->db->trans_start(); //DB Transaction Handle START //$delete_invoice_data['invoice_date'] = $invoice_date; //Query_helper::delete('invoices', $delete_invoice_data); if ($this->Service_template_model->delete_invoice_data($invoice_date)) { $invoice_id = Query_helper::add('invoices', $invoice_data); $zilla_invoice_id = Query_helper::add($zilla_table_invoice, $zilla_invoice_data); for ($i = 0; $i < $count; $i++) { if ($this->Service_template_model->check_uisc_service_existence($servicePost[$i])) { list($service_id, $service_name) = $this->Service_template_model->check_uisc_service_existence($servicePost[$i]); $invoice_details_data['invoice_id'] = $invoice_id; $invoice_details_data['receiver_name'] = $customerPost[$i]; $invoice_details_data['receiver_sex'] = $genderPost[$i]; $invoice_details_data['service_id'] = $service_id; //$this->Service_template_model->get_service_id($servicePost[$i]); $invoice_details_data['income'] = System_helper::Get_Bng_to_Eng($earningPost[$i]); $invoice_details_data['service_name'] = $service_name; //$this->Service_template_model->get_service_name($servicePost[$i]); $zilla_invoice_details_data['invoice_id'] = $zilla_invoice_id; $zilla_invoice_details_data['receiver_name'] = $customerPost[$i]; $zilla_invoice_details_data['receiver_sex'] = $genderPost[$i]; $zilla_invoice_details_data['service_id'] = $service_id; //$this->Service_template_model->get_service_id($servicePost[$i]); $zilla_invoice_details_data['income'] = System_helper::Get_Bng_to_Eng($earningPost[$i]); $zilla_invoice_details_data['service_name'] = $service_name; //$this->Service_template_model->get_service_name($servicePost[$i]); Query_helper::add('invoice_details', $invoice_details_data); Query_helper::add($zilla_table_invoice_details, $zilla_invoice_details_data); } } $fileInfo = array('user_id' => $user->id, 'uisc_id' => $uisc_id, 'file_name' => $fileName, 'upload_date' => strtotime($invDate), 'create_date' => time()); Query_helper::add($this->config->item('table_excel_history'), $fileInfo); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $this->dcms_add(); } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("NO_SERVICES_IN_UISC"); $this->jsonReturn($ajax); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_INCOME_AMOUNT_INVALID"); $this->jsonReturn($ajax); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_MAXIMUM_NUMBER_OF_FILES"); $this->jsonReturn($ajax); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_MAX_SIZE"); $this->jsonReturn($ajax); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_EXCEL_ONLY"); $this->jsonReturn($ajax); } }
private function dcms_save() { $time = time(); $user = User_helper::get_user(); $id = $this->input->post("id"); if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { if ($id > 0) { $data = $this->input->post('service'); $data['update_by'] = $user->id; $data['update_date'] = time(); $directory = 'images/service_logo'; $uploaded = System_helper::upload_file($directory, 5120, 'jpg|png'); if ($uploaded) { $data['service_logo'] = $uploaded['service_logo']['info']['file_name']; } $id = Query_helper::update($this->config->item('table_api_services'), $data, ['id =' . $id]); if ($id) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->dcms_add(); } else { $this->dcms_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } else { $data = $this->input->post('service'); $data['create_by'] = $user->id; $data['create_date'] = time(); $directory = 'images/service_logo'; $uploaded = System_helper::upload_file($directory, 5120, 'jpg|png'); if ($uploaded) { $data['service_logo'] = $uploaded['service_logo']['info']['file_name']; } $id = Query_helper::add($this->config->item('table_api_services'), $data); if ($id) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->dcms_add(); } else { $this->dcms_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } } }
public function system_save() { $id = $this->input->post("id"); $data = $this->input->post('task'); $user = User_helper::get_user(); if ($id > 0) { $this->db->trans_start(); //DB Transaction Handle START $data['modified_by'] = $user->user_id; $data['modification_date'] = time(); Query_helper::update($this->config->item('table_task'), $data, array("id = " . $id)); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_UPDATE_SUCCESS"); $this->system_list(); } else { $this->message = $this->lang->line("MSG_NOT_UPDATED_SUCCESS"); } } else { $this->db->trans_start(); //DB Transaction Handle START $data['created_by'] = $user->user_id; $data['creation_date'] = time(); Query_helper::add($this->config->item('table_task'), $data); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $this->system_list(); } else { $this->message = $this->lang->line("MSG_NOT_SAVED_SUCCESS"); } } }
private function dcms_save() { $time = time(); $center_data = array(); $secretary_data = array(); $entrepreneur_data = array(); $device_data = array(); $resource_data = array(); $investment_data = array(); $training_data = array(); $electricity_data = array(); $location_data = array(); $academic_data = array(); if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $center_data['uisc_type'] = $this->input->post('entrepreneur_type'); $center_data['user_group_id'] = $this->config->item('UISC_GROUP_ID'); $center_data['division'] = $this->input->post('division'); $center_data['zilla'] = $this->input->post('zilla'); if ($this->input->post('entrepreneur_type') == $this->config->item('ONLINE_UNION_GROUP_ID')) { $center_data['upazilla'] = $this->input->post('upazilla'); $center_data['union'] = $this->input->post('union'); $union_name = $this->Entrepreneur_registration_model->get_union_name($this->input->post('zilla'), $this->input->post('upazilla'), $this->input->post('union')); $serial = $this->Entrepreneur_registration_model->CountUnionServiceCenter($this->input->post('division'), $this->input->post('zilla'), $this->input->post('upazilla'), $this->input->post('union')); $center_data['uisc_name'] = $union_name . ' ' . $this->lang->line('UNION_DIGITAL_CENTER') . ' -' . $serial; } elseif ($this->input->post('entrepreneur_type') == $this->config->item('ONLINE_CITY_CORPORATION_WORD_GROUP_ID')) { $center_data['citycorporation'] = $this->input->post('citycorporation'); $center_data['citycorporationward'] = $this->input->post('citycorporationward'); $cityCorporation = $this->Entrepreneur_registration_model->get_city_name($this->input->post('zilla'), $this->input->post('citycorporation')); $cityCorporationWard = $this->Entrepreneur_registration_model->get_city_ward_name($this->input->post('zilla'), $this->input->post('citycorporation'), $this->input->post('citycorporationward')); $serial = $this->Entrepreneur_registration_model->countCityServiceCenter($this->input->post('division'), $this->input->post('zilla'), $this->input->post('citycorporation'), $this->input->post('citycorporationward')); $center_data['uisc_name'] = $cityCorporation . ' ' . $cityCorporationWard . ' ' . $this->lang->line('DIGITAL_CENTER') . ' -' . $serial; } elseif ($this->input->post('entrepreneur_type') == $this->config->item('ONLINE_MUNICIPAL_WORD_GROUP_ID')) { $center_data['municipal'] = $this->input->post('municipal'); $center_data['municipalward'] = $this->input->post('municipalward'); $municipal = $this->Entrepreneur_registration_model->get_municipal_name($this->input->post('zilla'), $this->input->post('municipal')); $municipalWard = $this->Entrepreneur_registration_model->get_municipal_ward_name($this->input->post('zilla'), $this->input->post('municipal'), $this->input->post('municipalward')); $serial = $this->Entrepreneur_registration_model->countMunicipalServiceCenter($this->input->post('division'), $this->input->post('zilla'), $this->input->post('municipal'), $this->input->post('municipalward')); if ($municipalWard == 'সকল ওয়ার্ড') { $newMunicipalWard = ''; } else { $newMunicipalWard = $municipalWard . ' '; } $center_data['uisc_name'] = $municipal . ' ' . $newMunicipalWard . $this->lang->line('DIGITAL_CENTER') . ' -' . $serial; } $center_data['uisc_email'] = $this->input->post('uisc_email'); $center_data['uisc_mobile'] = $this->input->post('uisc_mobile_no'); $center_data['uisc_address'] = $this->input->post('uisc_address'); $center_data['ques_id'] = $this->input->post('ques_id'); $center_data['ques_ans'] = $this->input->post('ques_ans'); $dir = $this->config->item("dcms_upload"); $uploaded = System_helper::upload_file($dir['entrepreneur'], 1024, 'gif|jpg|png'); if (array_key_exists('profile_image', $uploaded)) { if ($uploaded['profile_image']['status']) { $center_data['image'] = $uploaded['profile_image']['info']['file_name']; } else { $ajax['status'] = false; $ajax['desk_message'] = $this->message .= $uploaded['profile_image']['message'] . '<br>'; $this->jsonReturn($ajax); } } $center_data['create_by'] = ''; $center_data['create_date'] = $time; $secretary_data['secretary_name'] = $this->input->post('secretary_name'); $secretary_data['secretary_email'] = $this->input->post('secretary_email'); $secretary_data['secretary_mobile'] = $this->input->post('secretary_mobile'); $secretary_data['secretary_address'] = $this->input->post('secretary_address'); $entrepreneur_data['entrepreneur_type'] = $this->input->post('entrepreneur_exp_type'); $entrepreneur_data['entrepreneur_name'] = $this->input->post('entrepreneur_name'); $entrepreneur_data['entrepreneur_father_name'] = $this->input->post('entrepreneur_father_name'); $entrepreneur_data['entrepreneur_mother_name'] = $this->input->post('entrepreneur_mother_name'); $entrepreneur_data['entrepreneur_mobile'] = $this->input->post('entrepreneur_mobile'); $entrepreneur_data['entrepreneur_email'] = $this->input->post('entrepreneur_email'); $entrepreneur_data['entrepreneur_sex'] = $this->input->post('entrepreneur_sex'); $entrepreneur_data['entrepreneur_address'] = $this->input->post('entrepreneur_address'); $device_data['connection_type'] = $this->input->post('connection_type'); $device_data['ip_address'] = $this->input->post('ip_address'); $device_data['modem'] = $this->input->post('modem'); $investment_data['invested_money'] = $this->input->post('invested_money'); $investment_data['self_investment'] = $this->input->post('self_investment'); $investment_data['invest_debt'] = $this->input->post('invest_debt'); $investment_data['invest_sector'] = $this->input->post('invest_sector'); $electricity_data['electricity'] = $this->input->post('electricity'); $electricity_data['solar'] = $this->input->post('solar'); $electricity_data['ips'] = $this->input->post('ips'); $location_data['center_type'] = $this->input->post('center_location'); $academic_data['latest_education'] = $this->input->post('latest_education'); $academic_data['passing_year'] = $this->input->post('passing_year'); $resPost = $this->input->post('res_id'); $res_detailPost = $this->input->post('res_detail'); $quantityPost = $this->input->post('quantity'); $statusPost = $this->input->post('status'); $coursePost = $this->input->post('training_course'); $institutePost = $this->input->post('training_institute'); $timePost = $this->input->post('training_time'); $this->db->trans_start(); //DB Transaction Handle START $uisc_id = Query_helper::add($this->config->item('table_uisc_infos'), $center_data); $secretary_data['uisc_id'] = $uisc_id; $secretary_data['create_by'] = ''; $secretary_data['create_date'] = $time; Query_helper::add($this->config->item('table_secretary_infos'), $secretary_data); $entrepreneur_data['uisc_id'] = $uisc_id; $entrepreneur_data['create_by'] = ''; $entrepreneur_data['create_date'] = $time; Query_helper::add($this->config->item('table_entrepreneur_infos'), $entrepreneur_data); $device_data['uisc_id'] = $uisc_id; $device_data['create_by'] = ''; $device_data['create_date'] = $time; Query_helper::add($this->config->item('table_device_infos'), $device_data); $investment_data['uisc_id'] = $uisc_id; $investment_data['create_by'] = ''; $investment_data['create_date'] = $time; Query_helper::add($this->config->item('table_investment'), $investment_data); $electricity_data['uisc_id'] = $uisc_id; $electricity_data['create_by'] = ''; $electricity_data['create_date'] = $time; Query_helper::add($this->config->item('table_electricity'), $electricity_data); $location_data['uisc_id'] = $uisc_id; $location_data['create_by'] = ''; $location_data['create_date'] = $time; Query_helper::add($this->config->item('table_center_location'), $location_data); $academic_data['uisc_id'] = $uisc_id; $academic_data['create_by'] = ''; $academic_data['create_date'] = $time; Query_helper::add($this->config->item('table_entrepreneur_education'), $academic_data); if (sizeof($resPost) > 0 && is_array($resPost)) { for ($i = 0; $i < sizeof($resPost); $i++) { $resource_data['uisc_id'] = $uisc_id; $resource_data['res_id'] = $resPost[$i]; $resource_data['res_detail'] = $res_detailPost[$i]; $resource_data['quantity'] = $quantityPost[$i]; $resource_data['status'] = $statusPost[$i]; $resource_data['create_by'] = ''; $resource_data['create_date'] = $time; Query_helper::add($this->config->item('table_uisc_resources'), $resource_data); } } if (sizeof($coursePost) > 0 && is_array($coursePost)) { for ($i = 0; $i < sizeof($coursePost); $i++) { $training_data['uisc_id'] = $uisc_id; $training_data['course_name'] = $coursePost[$i]; $training_data['institute_name'] = $institutePost[$i]; $training_data['timespan'] = $timePost[$i]; $training_data['create_by'] = ''; $training_data['create_date'] = $time; Query_helper::add($this->config->item('table_training'), $training_data); } } $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $this->dcms_add(); } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } }
private function system_save() { $user = User_helper::get_user(); $uisc = User_helper::get_uisc_info(); $id = $this->input->post("id"); if ($id > 0) { if (!$this->permissions['edit']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } else { if (!$this->permissions['add']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); die; } } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { //$service_detail['createdby']=$user->id; $service_detail['created_time'] = time(); $service_detail['uisc_id'] = $uisc->id; $service_detail['user_id'] = $user->id; //$service_detail['status']=$this->config->item('SERVICES_STATUS_PROPOSED'); $this->db->trans_start(); //DB Transaction Handle START $all_update['status'] = $this->config->item('STATUS_INACTIVE'); Query_helper::update($this->config->item('table_services_uisc'), $all_update, array("user_id = " . $user->id)); $number_of_service = sizeof($this->input->post("service_id")); $service_id = $this->input->post('service_id'); $uisc_service_id = $this->input->post('uisc_service_id'); for ($i = 0; $i < $number_of_service; $i++) { $check_post = $service_id[$i]; if ($this->input->post($check_post)) { $uisc_service_post_id = $uisc_service_id[$i]; // $single_data['remaining']="'remaining'+1"; // Query_helper::update($this->config->item('table_services_uisc'),$single_data,array("user_id = ".$user->id, "service_id = ".$uisc_service_post_id)); $update_sql = "update " . $this->config->item('table_services_uisc') . " set remaining=remaining+1 where user_id='" . $user->id . "' AND service_id='{$uisc_service_post_id}'"; $this->db->query($update_sql); $service_detail['service_id'] = $check_post; $service_detail['remaining'] = 1; Query_helper::add($this->config->item('table_services_uisc'), $service_detail); } } /* $number_of_own_service=sizeof($this->input->post("own_service_id")); $service_id=$this->input->post('service_id'); $uisc_service_id=$this->input->post('uisc_service_id'); for($i=0; $i<$number_of_service; $i++) { $check_post=$service_id[$i]; if($this->input->post($check_post)) { $uisc_service_post_id=$uisc_service_id[$i]; // $single_data['remaining']="'remaining'+1"; // Query_helper::update($this->config->item('table_services_uisc'),$single_data,array("user_id = ".$user->id, "service_id = ".$uisc_service_post_id)); $update_sql="update ".$this->config->item('table_services_uisc')." set remaining=remaining+1 where user_id='".$user->id."' AND service_id='$uisc_service_post_id'"; $this->db->query($update_sql); $service_detail['service_id']=$check_post; $service_detail['remaining']=1; Query_helper::add($this->config->item('table_services_uisc'),$service_detail); } } */ // $service_detail_uisc['uisc_id']=$user->id; // $service_detail_uisc['service_id']=$service_last_id; // $service_detail_uisc['user_id']=$user->id; // $service_detail_uisc['created_time']=time(); // Query_helper::add($this->config->item('table_services_uisc'),$service_detail_uisc); $this->db->trans_complete(); //DB Transaction Handle END //die(); if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $this->system_add(); } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } }
private function dcms_save() { $time = time(); $user_data = array(); $secretary_data = array(); $entrepreneur_data = array(); $device_data = array(); $resource_data = array(); $investment_data = array(); $training_data = array(); $electricity_data = array(); $location_data = array(); $academic_data = array(); if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $user_data['uisc_type'] = $this->input->post('entrepreneur_type'); $user_data['user_group_id'] = $this->config->item('UISC_GROUP_ID'); $user_data['uisc_id'] = $this->input->post('uisc_name'); $user_data['division'] = $this->input->post('division'); $user_data['zilla'] = $this->input->post('zilla'); $user_data['status'] = 0; $user_data['name_bn'] = $this->input->post('entrepreneur_name'); if ($this->input->post('entrepreneur_type') == $this->config->item('ONLINE_UNION_GROUP_ID')) { $user_data['upazila'] = $this->input->post('upazilla'); $user_data['unioun'] = $this->input->post('union'); $uisc_serial = $this->User_registration_model->get_uisc_serial($this->input->post('uisc_name')); $user_serial = $this->User_registration_model->get_user_serial($this->input->post('uisc_name')); $user_data['username'] = $user_data['zilla'] . '-' . $user_data['upazila'] . '-' . $user_data['unioun'] . '-' . str_pad($uisc_serial, 2, "0", STR_PAD_LEFT) . '-' . str_pad($user_serial, 2, "0", STR_PAD_LEFT); $user_data['password'] = md5(md5($user_data['username'])); } elseif ($this->input->post('entrepreneur_type') == $this->config->item('ONLINE_CITY_CORPORATION_WORD_GROUP_ID')) { $user_data['citycorporation'] = $this->input->post('citycorporation'); $user_data['citycorporationward'] = $this->input->post('citycorporationward'); $uisc_serial = $this->User_registration_model->get_uisc_serial($this->input->post('uisc_name')); $user_serial = $this->User_registration_model->get_user_serial($this->input->post('uisc_name')); $user_data['username'] = $user_data['zilla'] . '-' . $user_data['citycorporation'] . '-' . $user_data['citycorporationward'] . '-' . str_pad($uisc_serial, 2, "0", STR_PAD_LEFT) . '-' . str_pad($user_serial, 2, "0", STR_PAD_LEFT); $user_data['password'] = md5(md5($user_data['username'])); } elseif ($this->input->post('entrepreneur_type') == $this->config->item('ONLINE_MUNICIPAL_WORD_GROUP_ID')) { $user_data['municipal'] = $this->input->post('municipal'); $user_data['municipalward'] = $this->input->post('municipalward'); $uisc_serial = $this->User_registration_model->get_uisc_serial($this->input->post('uisc_name')); $user_serial = $this->User_registration_model->get_user_serial($this->input->post('uisc_name')); $user_data['username'] = $user_data['zilla'] . '-' . $user_data['municipal'] . '-' . $user_data['municipalward'] . '-' . str_pad($uisc_serial, 2, "0", STR_PAD_LEFT) . '-' . str_pad($user_serial, 2, "0", STR_PAD_LEFT); $user_data['password'] = md5(md5($user_data['username'])); } $user_data['email'] = $this->input->post('uisc_email'); $user_data['mobile'] = $this->input->post('uisc_mobile_no'); $user_data['ques_id'] = $this->input->post('ques_id'); $user_data['ques_ans'] = $this->input->post('ques_ans'); $dir = $this->config->item("dcms_upload"); $uploaded = System_helper::upload_file($dir['entrepreneur'], 10240, 'gif|jpg|png'); if (array_key_exists('profile_image', $uploaded)) { if ($uploaded['profile_image']['status']) { $user_data['picture_name'] = $uploaded['profile_image']['info']['file_name']; } else { $ajax['status'] = false; $ajax['system_message'] = $this->message .= $uploaded['profile_image']['message'] . '<br>'; $this->jsonReturn($ajax); } } $user_data['create_by'] = '000000'; $user_data['create_date'] = $time; $entrepreneur_data['user_id'] = $user_data['username']; $entrepreneur_data['entrepreneur_type'] = $this->input->post('entrepreneur_exp_type'); $entrepreneur_data['entrepreneur_name'] = $this->input->post('entrepreneur_name'); $entrepreneur_data['entrepreneur_father_name'] = $this->input->post('entrepreneur_father_name'); $entrepreneur_data['entrepreneur_mother_name'] = $this->input->post('entrepreneur_mother_name'); $entrepreneur_data['entrepreneur_qualification'] = $this->input->post('entrepreneur_qualification'); $entrepreneur_data['entrepreneur_mobile'] = $this->input->post('entrepreneur_mobile'); $entrepreneur_data['entrepreneur_email'] = $this->input->post('entrepreneur_email'); $entrepreneur_data['entrepreneur_sex'] = $this->input->post('entrepreneur_sex'); $entrepreneur_data['entrepreneur_address'] = $this->input->post('entrepreneur_address'); $entrepreneur_data['entrepreneur_nid'] = $this->input->post('entrepreneur_nid'); $entrepreneur_data['entrepreneur_bank_name'] = $this->input->post('entrepreneur_bank_name'); $entrepreneur_data['entrepreneur_bank_account_no'] = $this->input->post('entrepreneur_bank_account_no'); $entrepreneur_data['entrepreneur_bank_holder_name'] = $this->input->post('entrepreneur_bank_holder_name'); $entrepreneur_data['entrepreneur_blog_member'] = $this->input->post('entrepreneur_blog_member'); $entrepreneur_data['entrepreneur_fb_group_member'] = $this->input->post('entrepreneur_fb_group_member'); $device_data['connection_type'] = $this->input->post('connection_type'); $device_data['ip_address'] = $this->input->post('ip_address'); $device_data['modem'] = $this->input->post('modem'); $investment_data['self_investment'] = System_helper::Get_Bng_to_Eng(trim($this->input->post('self_investment'))); $investment_data['invest_debt'] = System_helper::Get_Bng_to_Eng(trim($this->input->post('invest_debt'))); $investment_data['invested_money'] = System_helper::Get_Bng_to_Eng(trim($this->input->post('self_investment'))) + trim(System_helper::Get_Bng_to_Eng($this->input->post('invest_debt'))); //System_helper::Get_Bng_to_Eng($this->input->post('invested_money')); $investment_data['invest_sector'] = $this->input->post('invest_sector'); $electricity_data['electricity'] = $this->input->post('electricity'); $electricity_data['solar'] = $this->input->post('solar'); $electricity_data['ips'] = $this->input->post('ips'); $location_data['center_type'] = $this->input->post('center_location'); $academic_data['latest_education'] = $this->input->post('latest_education'); $academic_data['passing_year'] = $this->input->post('passing_year'); $coursePost = $this->input->post('training_course'); $institutePost = $this->input->post('training_institute'); $timePost = $this->input->post('training_time'); $resPost = $this->input->post('res_id'); $res_detailPost = $this->input->post('res_detail'); $quantityPost = $this->input->post('quantity'); $statusPost = $this->input->post('status'); $this->db->trans_start(); //DB Transaction Handle START $user_id = Query_helper::add($this->config->item('table_users'), $user_data); $entrepreneur_data['uisc_id'] = $this->input->post('uisc_name'); $entrepreneur_data['user_id'] = $user_id; $entrepreneur_data['create_by'] = '000000'; $entrepreneur_data['create_date'] = $time; Query_helper::add($this->config->item('table_entrepreneur_infos'), $entrepreneur_data); $device_data['uisc_id'] = $this->input->post('uisc_name'); $device_data['user_id'] = $user_id; $device_data['create_by'] = '000000'; $device_data['create_date'] = $time; Query_helper::add($this->config->item('table_device_infos'), $device_data); $investment_data['uisc_id'] = $this->input->post('uisc_name'); $investment_data['user_id'] = $user_id; $investment_data['create_by'] = '000000'; $investment_data['create_date'] = $time; Query_helper::add($this->config->item('table_investment'), $investment_data); $electricity_data['uisc_id'] = $this->input->post('uisc_name'); $electricity_data['user_id'] = $user_id; $electricity_data['create_by'] = '000000'; $electricity_data['create_date'] = $time; Query_helper::add($this->config->item('table_electricity'), $electricity_data); $location_data['uisc_id'] = $this->input->post('uisc_name'); $location_data['user_id'] = $user_id; $location_data['create_by'] = '000000'; $location_data['create_date'] = $time; Query_helper::add($this->config->item('table_center_location'), $location_data); $academic_data['uisc_id'] = $this->input->post('uisc_name'); $academic_data['user_id'] = $user_id; $academic_data['create_by'] = '000000'; $academic_data['create_date'] = $time; Query_helper::add($this->config->item('table_entrepreneur_education'), $academic_data); if (sizeof($resPost) > 0 && is_array($resPost)) { for ($i = 0; $i < sizeof($resPost); $i++) { $resource_data['uisc_id'] = $this->input->post('uisc_name'); $resource_data['user_id'] = $user_id; $resource_data['res_id'] = $resPost[$i]; $resource_data['res_detail'] = $res_detailPost[$i]; $resource_data['quantity'] = $quantityPost[$i]; $resource_data['status'] = $statusPost[$i]; $resource_data['create_by'] = '000000'; $resource_data['create_date'] = $time; Query_helper::add($this->config->item('table_uisc_resources'), $resource_data); } } if (sizeof($coursePost) > 0 && is_array($coursePost)) { for ($i = 0; $i < sizeof($coursePost); $i++) { $training_data['uisc_id'] = $this->input->post('uisc_name'); $training_data['user_id'] = $user_id; $training_data['course_name'] = $coursePost[$i]; $training_data['institute_name'] = $institutePost[$i]; $training_data['timespan'] = $timePost[$i]; $training_data['create_by'] = '000000'; $training_data['create_date'] = $time; Query_helper::add($this->config->item('table_training'), $training_data); } } $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $this->dcms_add(); } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } }
private function system_save() { $user = User_helper::get_user(); $id = $this->input->post("id"); $data = $this->input->post('key'); $keyConfig = $this->config->item('KEY_TYPE'); if ($id > 0) { if (!$this->permissions['edit']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); } } else { if (!$this->permissions['add']) { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS"); $this->jsonReturn($ajax); } } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { if ($data['parent'] == $keyConfig['CAMPUS'] || $data['parent'] == $keyConfig['SESSION']) { $data['description'] = json_encode($this->input->post('description')); } if ($id > 0) { $data['update_by'] = $user->id; $data['update_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START Query_helper::update($this->config->item('table_system_keyword'), $data, array("id = " . $id)); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_UPDATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL"); $this->jsonReturn($ajax); } } else { $data['create_by'] = $user->id; $data['create_date'] = time(); $this->db->trans_start(); //DB Transaction Handle START Query_helper::add($this->config->item('table_system_keyword'), $data); $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $this->message = $this->lang->line("MSG_CREATE_SUCCESS"); $save_and_new = $this->input->post('system_save_new_status'); if ($save_and_new == 1) { $this->system_add(); } else { $this->system_list(); } } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } } }
private function dcms_save() { $time = time(); $user = User_helper::get_user(); $id = $this->input->post("uisc_id"); $status = $this->input->post("approval_status"); $uisc_type = $this->input->post("uisc_type"); $division = $this->input->post("division"); $zilla = $this->input->post("zilla"); $image = $this->input->post("user_image"); $upazilla = 0; $union = 0; $citycorporation = 0; $citycorporationward = 0; $municipal = 0; $municipalward = 0; $union_name = $this->input->post("union_name"); $city_corporation_name = $this->input->post("city_corporation_name"); $city_corporation_ward_name = $this->input->post("city_corporation_ward_name"); $municipal_name = $this->input->post("municipal_name"); $municipal_ward_name = $this->input->post("municipal_ward_name"); $entrepreneur_gender = $this->input->post("gender"); $uisc_center_name = ''; $ques_id = $this->input->post("ques_id"); $ques_ans = $this->input->post("ques_ans"); if ($uisc_type == $this->config->item('ONLINE_UNION_GROUP_ID')) { $upazilla = $this->input->post("upazilla"); $union = $this->input->post("union"); $serial = $this->Entrepreneur_approval_model->CountUnionServiceCenter($division, $zilla, $upazilla, $union); $number_of_user = $this->Entrepreneur_approval_model->Number_of_uisc_user($id); $user_id = $zilla . '-' . $upazilla . '-' . $union . '-' . str_pad($serial, 2, "0", STR_PAD_LEFT) . '-' . str_pad($number_of_user, 2, "0", STR_PAD_LEFT); //$uisc_center_name=$union_name." ".$this->lang->line('UNION_PARISHAD')." ".$this->lang->line('DIGITAL_CENTER')." - ".$serial; } elseif ($uisc_type == $this->config->item('ONLINE_CITY_CORPORATION_WORD_GROUP_ID')) { $citycorporation = $this->input->post("citycorporation"); $citycorporationward = $this->input->post("citycorporationward"); $serial = $this->Entrepreneur_approval_model->countCityServiceCenter($division, $zilla, $citycorporation, $citycorporationward); $number_of_user = $this->Entrepreneur_approval_model->Number_of_uisc_user($id); $user_id = $zilla . '-' . $citycorporation . '-' . $citycorporationward . '-' . str_pad($serial, 2, "0", STR_PAD_LEFT) . '-' . str_pad($number_of_user, 2, "0", STR_PAD_LEFT); //$uisc_center_name=$city_corporation_name." ".$city_corporation_ward_name." ".$this->lang->line('CITY_CORPORATION')." ".$this->lang->line('DIGITAL_CENTER')." - ".$serial; } elseif ($uisc_type == $this->config->item('ONLINE_MUNICIPAL_WORD_GROUP_ID')) { $municipal = $this->input->post("municipal"); $municipalward = $this->input->post("municipalward"); $serial = $this->Entrepreneur_approval_model->countMunicipalServiceCenter($division, $zilla, $municipal, $municipalward); $number_of_user = $this->Entrepreneur_approval_model->Number_of_uisc_user($id); $user_id = $zilla . '-' . $municipal . '-' . $municipalward . '-' . str_pad($serial, 2, "0", STR_PAD_LEFT) . '-' . str_pad($number_of_user, 2, "0", STR_PAD_LEFT); //$uisc_center_name=$municipal_name." ".$municipal_ward_name." ".$this->lang->line('MUNICIPALITY')." ".$this->lang->line('DIGITAL_CENTER')." - ".$serial; } if (!$this->check_validation()) { $ajax['status'] = false; $ajax['system_message'] = $this->message; $this->jsonReturn($ajax); } else { $uisc_info_update_data = array('status' => $status); //$entrepreneur_info_update_data = Array('user_id'=>$user_id); //$secretary_info_update_data = Array('user_id'=>$user_id); $user_data = array('username' => $user_id, 'password' => md5(md5($user_id)), 'user_group_id' => $this->config->item('UISC_GROUP_ID'), 'uisc_type' => $uisc_type, 'uisc_id' => $id, 'ques_id' => $ques_id, 'ques_ans' => $ques_ans, 'division' => $division, 'zilla' => $zilla, 'upazila' => $upazilla, 'unioun' => $union, 'citycorporation' => $citycorporation, 'citycorporationward' => $citycorporationward, 'municipal' => $municipal, 'municipalward' => $municipalward, 'gender' => $entrepreneur_gender, 'picture_name' => $image, 'create_by' => $user->id, 'create_date' => $time); if ($id > 0) { $uisc_info_update_data['update_by'] = $user->id; $uisc_info_update_data['update_date'] = $time; $this->db->trans_start(); //DB Transaction Handle START if ($status == 1) { $uisc_user_id = Query_helper::add($this->config->item('table_users'), $user_data); //$uisc_info_update_data['uisc_name']=$uisc_center_name; $entrepreneur_info_update_data['user_id'] = $uisc_user_id; $entrepreneur_info_update_data['update_by'] = $user->id; $entrepreneur_info_update_data['update_date'] = $time; $secretary_info_update_data['user_id'] = $uisc_user_id; $secretary_info_update_data['update_by'] = $user->id; $secretary_info_update_data['update_date'] = $time; $resources_info_update_data['user_id'] = $uisc_user_id; $resources_info_update_data['update_by'] = $user->id; $resources_info_update_data['update_date'] = $time; $device_info_update_data['user_id'] = $uisc_user_id; $device_info_update_data['update_by'] = $user->id; $device_info_update_data['update_date'] = $time; $center_location_info_update_data['user_id'] = $uisc_user_id; $center_location_info_update_data['update_by'] = $user->id; $center_location_info_update_data['update_date'] = $time; $education_info_update_data['user_id'] = $uisc_user_id; $education_info_update_data['update_by'] = $user->id; $education_info_update_data['update_date'] = $time; $electricity_info_update_data['user_id'] = $uisc_user_id; $electricity_info_update_data['update_by'] = $user->id; $electricity_info_update_data['update_date'] = $time; $investment_info_update_data['user_id'] = $uisc_user_id; $investment_info_update_data['update_by'] = $user->id; $investment_info_update_data['update_date'] = $time; $training_info_update_data['user_id'] = $uisc_user_id; $training_info_update_data['update_by'] = $user->id; $training_info_update_data['update_date'] = $time; Query_helper::update($this->config->item('table_uisc_infos'), $uisc_info_update_data, array("id = " . $id)); Query_helper::update($this->config->item('table_entrepreneur_infos'), $entrepreneur_info_update_data, array("uisc_id = " . $id)); Query_helper::update($this->config->item('table_secretary_infos'), $secretary_info_update_data, array("uisc_id = " . $id)); Query_helper::update($this->config->item('table_uisc_resources'), $resources_info_update_data, array("uisc_id = " . $id)); Query_helper::update($this->config->item('table_device_infos'), $device_info_update_data, array("uisc_id = " . $id)); Query_helper::update($this->config->item('table_center_location'), $center_location_info_update_data, array("uisc_id = " . $id)); Query_helper::update($this->config->item('table_entrepreneur_education'), $education_info_update_data, array("uisc_id = " . $id)); Query_helper::update($this->config->item('table_electricity'), $electricity_info_update_data, array("uisc_id = " . $id)); Query_helper::update($this->config->item('table_investment'), $investment_info_update_data, array("uisc_id = " . $id)); Query_helper::update($this->config->item('table_training'), $training_info_update_data, array("uisc_id = " . $id)); $user_detail_info = $this->Entrepreneur_approval_model->get_user_detail_info_from_entrepreneur($uisc_user_id, $id); $user_update_data['name_bn'] = $user_detail_info['entrepreneur_name']; $user_update_data['mobile'] = $user_detail_info['entrepreneur_mobile']; $user_update_data['email'] = $user_detail_info['entrepreneur_email']; $user_update_data['present_address'] = $user_detail_info['entrepreneur_address']; Query_helper::update($this->config->item('table_users'), $user_update_data, array("id = " . $uisc_user_id)); } elseif ($status == 2) { Query_helper::update($this->config->item('table_uisc_infos'), $uisc_info_update_data, array("id = " . $id)); } $this->db->trans_complete(); //DB Transaction Handle END if ($this->db->trans_status() === TRUE) { $ajax['status'] = true; if ($status == 1) { $subject = $this->lang->line('ADMIN_ENTREPRENEUR_APPROVED_SUBJECT_TITLE'); $msg = " প্রিয় উদ্যোক্তা আপনার রেজিষ্ট্রেশন অনুমোদন করা হয়েছে।\r\n আপনার ব্যবহারকারী নামঃ " . $user_id . " এবং পাসওয়ার্ডঃ " . $user_id; $from_email = $this->config->item('from_mail_address'); $to_email = $user_detail_info['entrepreneur_email']; $cc_email = $this->config->item('cc_mail_address_maraj'); User_helper::mail_send($from_email, $to_email, $cc_email, '', $subject, $msg); $ajax['system_message'] = $this->lang->line("MSG_SUCCESSFULLY_APPROVED"); } else { $ajax['system_message'] = $this->lang->line("MSG_SUCCESSFULLY_DENIED"); } $this->jsonReturn($ajax); } else { $ajax['status'] = false; $ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL"); $this->jsonReturn($ajax); } } } }