Beispiel #1
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 {
         $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 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);
         }
     }
 }
Beispiel #3
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);
         }
     }
 }
Beispiel #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 {
         $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);
             }
         }
     }
 }
Beispiel #5
0
 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);
             }
         }
     }
 }
Beispiel #6
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 {
         $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);
             }
         }
     }
 }
Beispiel #7
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 {
         $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);
             }
         }
     }
 }
Beispiel #8
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 {
         $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);
             }
         }
     }
 }
Beispiel #9
0
 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);
             }
         }
     }
 }
Beispiel #10
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);
             }
         }
     }
 }