Exemplo n.º 1
0
 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);
     }
 }
Exemplo n.º 2
0
 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);
         }
     }
 }
Exemplo n.º 3
0
 private function details($user_id)
 {
     if ($this->permissions['view']) {
         if (is_array($user_id)) {
             $user_id = System_helper::Get_Bng_to_Eng($user_id[0]);
         }
         $this->current_action = 'batch_details';
         $ajax['status'] = true;
         $data = array();
         $data['title'] = $this->lang->line("VIEW_DETAILS_TICKET_ASSIGN");
         $data['ticket'] = Query_helper::get_info($this->config->item('table_ticket_assign'), '*', array('user_id =' . $user_id), 1);
         //, 'status ='.$this->config->item('STATUS_INACTIVE')
         $data['users'] = Query_helper::get_info($this->config->item('table_users'), array('id value', 'name_bn text'), array('status = ' . $this->config->item('STATUS_ACTIVE'), "id = " . $user_id));
         $data['ticket_issues'] = $this->ticket_assign_model->get_ticket_assign($user_id);
         $ajax['system_content'][] = array("id" => "#system_wrapper", "html" => $this->load_view("ticket_management/ticket_assign/details", $data, true));
         if ($this->message) {
             $ajax['system_message'] = $this->message;
         }
         $ajax['system_page_url'] = $this->get_encoded_url('ticket_management/ticket_assign/index/batch_details/' . $user_id);
         $this->jsonReturn($ajax);
     } else {
         $ajax['status'] = true;
         $ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS");
         $this->jsonReturn($ajax);
     }
 }
Exemplo n.º 4
0
 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);
             }
         }
     }
 }