private function system_edit()
{
if ($this->permissions['edit']) {
$user = User_helper::get_user();
$id = $user->id;
$uisc_id = $user->uisc_id;
$this->current_action = 'edit';
$ajax['status'] = true;
$data = array();
$data['title'] = $this->lang->line("EDIT_PROFILE");
$data['uisc_detail'] = $this->Profile_view_model->get_uisc_info($id, $uisc_id);
$data['secretary'] = $this->Profile_view_model->get_secretary_info($id, $uisc_id);
$data['chairmen_info'] = Query_helper::get_info($this->config->item('table_entrepreneur_chairmen_info'), '*', array('uisc_id =' . $uisc_id), 1);
$data['entrepreneur_info'] = Query_helper::get_info($this->config->item('table_entrepreneur_infos'), '*', array('user_id =' . $id, 'uisc_id =' . $uisc_id), 1);
$data['education_info'] = Query_helper::get_info($this->config->item('table_entrepreneur_education'), '*', array('user_id =' . $id, 'uisc_id =' . $uisc_id), 1);
$data['training_info'] = Query_helper::get_info($this->config->item('table_training'), '*', array('user_id =' . $id, 'uisc_id =' . $uisc_id), 0);
$data['investment_info'] = Query_helper::get_info($this->config->item('table_investment'), '*', array('user_id =' . $id, 'uisc_id =' . $uisc_id), 1);
$data['location_info'] = Query_helper::get_info($this->config->item('table_center_location'), '*', array('user_id =' . $id, 'uisc_id =' . $uisc_id), 1);
$data['resources_info'] = Query_helper::get_info($this->config->item('table_uisc_resources'), '*', array('user_id =' . $id, 'uisc_id =' . $uisc_id), 0);
$data['device_info'] = Query_helper::get_info($this->config->item('table_device_infos'), '*', array('user_id =' . $id, 'uisc_id =' . $uisc_id), 1);
$data['electricity_info'] = Query_helper::get_info($this->config->item('table_electricity'), '*', array('user_id =' . $id, 'uisc_id =' . $uisc_id), 1);
$data['resources'] = $this->Profile_view_model->get_resource_info($id, $uisc_id);
$ajax['system_content'][] = array("id" => "#system_wrapper_top_menu", "html" => $this->load_view("top_menu", "", true));
$ajax['system_content'][] = array("id" => "#system_wrapper", "html" => $this->load_view("profile/profile_view/system_add_edit", $data, true));
if ($this->message) {
$ajax['system_message'] = $this->message;
}
$ajax['system_page_url'] = $this->get_encoded_url('profile/profile_view/index/edit/' . $id);
$this->jsonReturn($ajax);
} else {
$ajax['status'] = true;
$ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS");
$this->jsonReturn($ajax);
}
}
public function login()
{
$user = User_helper::get_user();
if ($user) {
$this->dashboard_page();
} else {
if ($this->input->post()) {
if (User_helper::login($this->input->post("username"), $this->input->post("password"))) {
$user = User_helper::get_user();
$user_info['user_id'] = $user->id;
$user_info['login_time'] = time();
$user_info['ip_address'] = $this->input->ip_address();
$user_info['request_headers'] = json_encode($this->input->request_headers());
Query_helper::add($this->config->item('table_user_login_history'), $user_info);
$this->dashboard_page($this->lang->line("MSG_LOGIN_SUCCESS"));
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_USERNAME_PASSWORD_INVALID");
$this->jsonReturn($ajax);
}
} else {
$this->login_page();
//login page view
}
}
}
public function user_info()
{
$id = $_POST['id'];
$data['users'] = Query_helper::get_info($this->config->item('table_users'), '*', array('status = ' . $this->config->item('STATUS_ACTIVE'), "id = " . $id), 1);
$ajax['system_content'][] = array("id" => "#user_model_body", "html" => $this->load_view("common/user_info", $data, true));
$this->jsonReturn($ajax);
}
private function dcms_save()
{
$user = User_helper::get_user();
$data = array();
if (!$this->check_validation()) {
$ajax['status'] = false;
$ajax['system_message'] = $this->message;
$this->jsonReturn($ajax);
} else {
$data['suggestion'] = $this->input->post('suggestion');
$data['date'] = date('Y-m-d');
$data['uisc_id'] = $user->uisc_id;
$data['created'] = $user->id;
$data['user_id'] = $user->id;
$this->db->trans_start();
//DB Transaction Handle START
Query_helper::add($this->config->item('table_suggestion'), $data);
$this->db->trans_complete();
//DB Transaction Handle END
if ($this->db->trans_status() === TRUE) {
$this->message = $this->lang->line("MSG_CREATE_SUCCESS");
$this->dcms_add();
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL");
$this->jsonReturn($ajax);
}
}
}
public function get_product_list_by_category()
{
$category_id = $this->input->post('category_id');
$products = Query_helper::get_info($this->config->item('table_product'), array('product_name value', 'product_name text'), array('category_id=' . $category_id), 0, 0, 'product_name');
$ajax['status'] = true;
$ajax['system_content'][] = array("id" => "#product_name", "html" => $this->load_view("dropdown", array('drop_down_options' => $products), true));
$this->jsonReturn($ajax);
}
public function get_municipal_ward()
{
$zilla_id = $this->input->post('zilla_id');
$municipal_id = $this->input->post('municipal_id');
$municipal_wards = Query_helper::get_info($this->config->item('table_municipal_wards'), array('wardid value', 'wardname text'), array('visible = 1', 'zillaid = ' . $zilla_id, 'municipalid = ' . $municipal_id));
$ajax['status'] = true;
$ajax['system_content'][] = array("id" => "#user_municipal_ward_id", "html" => $this->load_view("dropdown", array('drop_down_options' => $municipal_wards), true));
$this->jsonReturn($ajax);
}
private function system_save()
{
$user = User_helper::get_user();
$id = $this->input->post("id");
if ($id > 0) {
if (!$this->permissions['edit']) {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS");
$this->jsonReturn($ajax);
die;
}
} else {
if (!$this->permissions['add']) {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS");
$this->jsonReturn($ajax);
die;
}
}
if (!$this->check_validation()) {
$ajax['status'] = false;
$ajax['system_message'] = $this->message;
$this->jsonReturn($ajax);
} else {
$userDetail = array();
$userDetail['ques_id'] = $this->input->post('ques_id');
$userDetail['ques_ans'] = $this->input->post('ques_ans');
if ($id > 0) {
$userDetail['update_by'] = $user->id;
$userDetail['update_date'] = time();
$this->db->trans_start();
//DB Transaction Handle START
Query_helper::update($this->config->item('table_users'), $userDetail, array("id = " . $id));
$this->db->trans_complete();
//DB Transaction Handle END
if ($this->db->trans_status() === TRUE) {
$this->message = $this->lang->line("MSG_UPDATE_SUCCESS");
$save_and_new = $this->input->post('system_save_new_status');
if ($save_and_new == 1) {
$this->system_edit();
} else {
$this->system_edit();
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL");
$this->jsonReturn($ajax);
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL");
$this->jsonReturn($ajax);
}
}
}
public function index()
{
$user = User_helper::get_user();
$data['divisions'] = array();
$data['display_divisions'] = false;
$data['default_divisions'] = true;
$data['zillas'] = array();
$data['display_zillas'] = false;
$data['default_zillas'] = true;
$data['upazilas'] = array();
$data['display_upazilas'] = false;
$data['default_upazilas'] = true;
$data['unions'] = array();
$data['display_unions'] = false;
$data['default_unions'] = true;
if ($user->user_group_id == $this->config->item('SUPER_ADMIN_GROUP_ID') || $user->user_group_id == $this->config->item('A_TO_I_GROUP_ID') || $user->user_group_id == $this->config->item('DONOR_GROUP_ID') || $user->user_group_id == $this->config->item('MINISTRY_GROUP_ID')) {
$data['divisions'] = Query_helper::get_info($this->config->item('table_divisions'), array('divid value', 'divname text'), array());
$data['display_divisions'] = true;
$data['default_divisions'] = true;
} else {
$data['divisions'] = Query_helper::get_info($this->config->item('table_divisions'), array('divid value', 'divname text'), array('divid =' . $user->division));
$data['display_divisions'] = true;
$data['default_divisions'] = false;
$data['display_zillas'] = true;
if ($user->user_group_id == $this->config->item('DIVISION_GROUP_ID')) {
$data['zillas'] = Query_helper::get_info($this->config->item('table_zillas'), array('zillaid value', 'zillaname text'), array('visible = 1', 'divid = ' . $user->division));
$data['default_zillas'] = true;
$data['display_upazilas'] = false;
} else {
$data['zillas'] = Query_helper::get_info($this->config->item('table_zillas'), array('zillaid value', 'zillaname text'), array('visible = 1', 'divid = ' . $user->division, 'zillaid =' . $user->zilla));
$data['default_zillas'] = false;
$data['display_upazilas'] = true;
if ($user->user_group_id == $this->config->item('DISTRICT_GROUP_ID')) {
$data['upazilas'] = Query_helper::get_info($this->config->item('table_upazilas'), array('upazilaid value', 'upazilaname text'), array('visible = 1', 'zillaid = ' . $user->zilla));
$data['default_upazilas'] = true;
//$data['display_unions']=true;
} else {
$data['upazilas'] = Query_helper::get_info($this->config->item('table_upazilas'), array('upazilaid value', 'upazilaname text'), array('visible = 1', 'zillaid = ' . $user->zilla, 'upazilaid = ' . $user->upazila));
$data['default_upazilas'] = false;
$data['display_unions'] = true;
$data['unions'] = Query_helper::get_info($this->config->item('table_unions'), array('unionid value', 'unionname text'), array('visible = 1', 'zillaid = ' . $user->zilla, 'upazilaid=' . $user->upazila));
$data['default_unions'] = true;
//TODO
//increase report menu for union users
}
}
}
$ajax['status'] = true;
$data['title'] = $this->lang->line("REPORT_UISC_REGISTRATION_TITLE");
$ajax['system_content'][] = array("id" => "#system_wrapper_top_menu", "html" => $this->load_view("top_menu", "", true));
$ajax['system_content'][] = array("id" => "#system_wrapper", "html" => $this->load_view("report/registered_union_list", $data, true));
$ajax['system_page_url'] = $this->get_encoded_url('report/registered_union_list');
$this->jsonReturn($ajax);
}
public function index()
{
$user = User_helper::get_user();
$data['divisions'] = array();
$data['display_divisions'] = false;
$data['default_divisions'] = true;
$data['zillas'] = array();
$data['display_zillas'] = false;
$data['default_zillas'] = true;
$data['municipal'] = array();
$data['display_city_corporation'] = false;
$data['default_city_corporation'] = true;
$data['city_corporation_ward'] = array();
$data['display_city_corporation_ward'] = false;
$data['default_city_corporation_ward'] = true;
if ($user->user_group_level == $this->config->item('SUPER_ADMIN_GROUP_ID') || $user->user_group_level == $this->config->item('A_TO_I_GROUP_ID') || $user->user_group_level == $this->config->item('DONOR_GROUP_ID') || $user->user_group_level == $this->config->item('MINISTRY_GROUP_ID')) {
$data['divisions'] = Query_helper::get_info($this->config->item('table_divisions'), array('divid value', 'divname text'), array());
$data['display_divisions'] = true;
$data['default_divisions'] = true;
} else {
$data['divisions'] = Query_helper::get_info($this->config->item('table_divisions'), array('divid value', 'divname text'), array('divid =' . $user->division));
$data['display_divisions'] = true;
$data['default_divisions'] = false;
$data['display_zillas'] = true;
if ($user->user_group_level == $this->config->item('DIVISION_GROUP_ID')) {
$data['zillas'] = Query_helper::get_info($this->config->item('table_zillas'), array('zillaid value', 'zillaname text'), array('visible = 1', 'divid = ' . $user->division));
$data['default_zillas'] = true;
$data['display_city_corporation'] = false;
} else {
$data['zillas'] = Query_helper::get_info($this->config->item('table_zillas'), array('zillaid value', 'zillaname text'), array('visible = 1', 'divid = ' . $user->division, 'zillaid =' . $user->zilla));
$data['default_zillas'] = false;
$data['display_city_corporation'] = true;
if ($user->user_group_level == $this->config->item('DISTRICT_GROUP_ID')) {
$data['city_corporations'] = Query_helper::get_info($this->config->item('table_city_corporations'), array('citycorporationid value', 'citycorporationname text'), array('visible = 1', 'zillaid = ' . $user->zilla, 'divid=' . $user->division));
$data['default_city_corporation'] = true;
//$data['display_unions']=true;
} else {
$data['city_corporations'] = Query_helper::get_info($this->config->item('table_city_corporations'), array('citycorporationid value', 'citycorporationname text'), array('visible = 1', 'zillaid = ' . $user->zilla, 'divid=' . $user->division, 'citycorporationid=' . $user->citycorporation));
$data['default_city_corporation'] = false;
$data['display_city_corporation_ward'] = true;
$data['city_corporation_words'] = Query_helper::get_info($this->config->item('table_city_corporation_wards'), array('citycorporationwardid value', 'wardname text'), array('visible = 1', 'zillaid = ' . $user->zilla, 'divid=' . $user->division, 'citycorporationid = ' . $user->citycorporation));
$data['default_city_corporation_ward'] = true;
//TODO
//increase report menu for union users
}
}
}
$ajax['status'] = true;
$data['title'] = $this->lang->line("REPORT_COUNTRY_WISE_CITY_CORPORATION_MONTHLY_INCOME_TITLE");
$ajax['system_content'][] = array("id" => "#system_wrapper_top_menu", "html" => $this->load_view("top_menu", "", true));
$ajax['system_content'][] = array("id" => "#system_wrapper", "html" => $this->load_view("report/country_wise_city_corporation_monthly_income_list", $data, true));
$ajax['system_page_url'] = $this->get_encoded_url('report/country_wise_city_corporation_monthly_income_list');
$this->jsonReturn($ajax);
}
public function index()
{
$user = User_helper::get_user();
$data['divisions'] = array();
$data['display_divisions'] = false;
$data['default_divisions'] = true;
$data['zillas'] = array();
$data['display_zillas'] = false;
$data['default_zillas'] = true;
$data['municipal'] = array();
$data['display_municipal'] = false;
$data['default_municipal'] = true;
$data['municipal_ward'] = array();
$data['display_municipal_ward'] = false;
$data['default_municipal_ward'] = true;
if ($user->user_group_level == $this->config->item('SUPER_ADMIN_GROUP_ID') || $user->user_group_level == $this->config->item('A_TO_I_GROUP_ID') || $user->user_group_level == $this->config->item('DONOR_GROUP_ID') || $user->user_group_level == $this->config->item('MINISTRY_GROUP_ID')) {
$data['divisions'] = Query_helper::get_info($this->config->item('table_divisions'), array('divid value', 'divname text'), array());
$data['display_divisions'] = true;
$data['default_divisions'] = true;
} else {
$data['divisions'] = Query_helper::get_info($this->config->item('table_divisions'), array('divid value', 'divname text'), array('divid =' . $user->division));
$data['display_divisions'] = true;
$data['default_divisions'] = false;
$data['display_zillas'] = true;
if ($user->user_group_level == $this->config->item('DIVISION_GROUP_ID')) {
$data['zillas'] = Query_helper::get_info($this->config->item('table_zillas'), array('zillaid value', 'zillaname text'), array('visible = 1', 'divid = ' . $user->division));
$data['default_zillas'] = true;
$data['display_municipal'] = false;
} else {
$data['zillas'] = Query_helper::get_info($this->config->item('table_zillas'), array('zillaid value', 'zillaname text'), array('visible = 1', 'divid = ' . $user->division, 'zillaid =' . $user->zilla));
$data['default_zillas'] = false;
$data['display_municipal'] = true;
if ($user->user_group_level == $this->config->item('DISTRICT_GROUP_ID')) {
$data['municipals'] = Query_helper::get_info($this->config->item('table_municipals'), array('municipalid value', 'municipalname text'), array('visible = 1', 'zillaid = ' . $user->zilla));
$data['default_municipal'] = true;
//$data['display_unions']=true;
} else {
$data['municipals'] = Query_helper::get_info($this->config->item('table_municipals'), array('municipalid value', 'municipalname text'), array('visible = 1', 'zillaid = ' . $user->zilla, 'municipalid = ' . $user->municipal));
$data['default_municipal'] = false;
$data['display_municipal_ward'] = true;
$data['municipal_wards'] = Query_helper::get_info($this->config->item('table_municipal_wards'), array('wardid value', 'wardname text'), array('visible = 1', 'zillaid = ' . $user->zilla, 'municipalid = ' . $user->municipal));
$data['default_municipal_ward'] = true;
//TODO
//increase report menu for union users
}
}
}
$ajax['status'] = true;
//$data['title']=$this->lang->line("REPORT_CABINET_MUNICIPAL_SERVICE_HOLDER_INCOME_TITLE");
//$ajax['system_content'][]=array("id"=>"#system_wrapper_top_menu","html"=>$this->load_view("top_menu","",true));
$ajax['system_content'][] = array("id" => "#go_location", "html" => $this->load_view("report/cabinet/cabinet_municipal_service_holder_income_list", $data, true));
//$ajax['system_page_url']=$this->get_encoded_url('report/cabinet/cabinet_municipal_service_holder_income_list');
$this->jsonReturn($ajax);
}
private function dcms_list()
{
if ($this->permissions['list']) {
$this->current_action = 'list';
$ajax['status'] = true;
//$ajax['system_content'][] = array("id" => "#system_wrapper_top_menu", "html" => $this->load_view("top_menu", "", true));
$data['services'] = Query_helper::get_info($this->config->item('table_api_services'), '*', array('status =1'));
$ajax['system_content'][] = array("id" => "#system_wrapper", "html" => $this->load_view("esheba_management/external_service/list", $data, true));
//approval/entrepreneur_approval/dcms_list
if ($this->message) {
$ajax['system_message'] = $this->message;
}
$ajax['system_page_url'] = $this->get_encoded_url('esheba_management/services/index/list');
//approval/Entrepreneur_approval
$ajax['system_page_title'] = $this->lang->line("SERVICES");
$this->jsonReturn($ajax);
} else {
$ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS");
$this->jsonReturn($ajax);
}
}
public function index($service_id)
{
$user = User_helper::get_user();
$time = time();
$service_info = Query_helper::get_info($this->config->item('table_api_services'), '*', array('status =1', 'id =' . $service_id), 1);
if ($service_info) {
$data['auth_token'] = random_string('unique') . $time;
$data['user_id'] = $user->id;
$data['service_id'] = $service_id;
$data['time'] = $time;
$data['status'] = 1;
$id = Query_helper::add($this->config->item('table_api_auth_token'), $data);
if ($id) {
redirect($service_info['service_url'] . $data['auth_token'], 'refresh');
} else {
echo "Unable to save data";
}
} else {
echo "invalid service";
}
}
public function upload_excel_file()
{
$user = User_helper::get_user();
if ($_FILES["file"]['name'] != "") {
$arr = explode(".", $_FILES["file"]['name']);
$ext = $arr[sizeof($arr) - 1];
}
$size = $_FILES["file"]['size'];
$this->load->library('upload');
$fileName = 'template_' . $user->id . '_' . date('Ymdhis');
if ($ext == 'xls' || $ext == 'xlsx') {
System_helper::upload_excel_file($fileName, $save_dir = "uploads/excel", $max_size = 60000, $types = 'xls|xlsx');
if ($ext == 'xls') {
$path = "uploads/excel/" . $fileName . '.xls';
} else {
$path = "uploads/excel/" . $fileName . '.xlsx';
}
if ($size < 60000) {
$i = 0;
$totalcount = 0;
$objPHPExcel = PHPExcel_IOFactory::load($path);
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
$worksheetTitle = $worksheet->getTitle();
$highestRow = $worksheet->getHighestRow();
$highestColumn = $worksheet->getHighestColumn();
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
$nrColumns = ord($highestColumn) - 64;
for ($row = 1; $row <= $highestRow; ++$row) {
for ($col = 0; $col < $highestColumnIndex; ++$col) {
$cell = $worksheet->getCellByColumnAndRow($col, $row);
$val = $cell->getValue();
$dataType = PHPExcel_Cell_DataType::dataTypeForValue($val);
}
}
}
$total_men = 0;
$total_women = 0;
$total_tribe = 0;
$total_disability = 0;
$total_services = 0;
$total_income = 0;
$check_income = false;
for ($row = 3; $row <= $highestRow; ++$row) {
$val = array();
for ($col = 0; $col < $highestColumnIndex; ++$col) {
$cell = $worksheet->getCellByColumnAndRow($col, $row);
$val[] = $cell->getValue();
}
if ($val[3] != "" && $val[3] != null) {
$serial[$i] = System_helper::Get_Bng_to_Eng($val[0]);
$customer_name[$i] = $val[1];
$gender[$i] = $val[2];
$service_name[$i] = $val[3];
$amount[$i] = System_helper::Get_Bng_to_Eng(abs($val[4]));
if (strlen($amount[$i]) > 6) {
$check_income = true;
}
if ($this->Service_template_model->check_uisc_service_existence($service_name[$i])) {
$totalcount = $totalcount + $i;
$total_services++;
$total_income = $total_income + System_helper::Get_Bng_to_Eng($amount[$i]);
if ($gender[$i] == $this->lang->line('MALE_VAL')) {
$total_men++;
} elseif ($gender[$i] == $this->lang->line('FEMALE_VAL')) {
$total_women++;
} elseif ($gender[$i] == $this->lang->line('TRIBE_VAL')) {
$total_tribe++;
} elseif ($gender[$i] == $this->lang->line('DISABILITY_VAL')) {
$total_disability++;
}
}
++$i;
}
}
$DateCell = $worksheet->getCellByColumnAndRow('1', '1');
$invDateRaw = $DateCell->getValue();
if (is_float($invDateRaw)) {
$newDate = System_helper::ExcelToPHPDate($invDateRaw);
$invDate = date('Y-m-d', $newDate);
} else {
$invDate = $invDateRaw;
}
if ($this->Service_template_model->chk_existing_uploded_excel_file($invDate) < 2) {
$invoice_data = array();
$zilla_invoice_data = array();
$invoice_details_data = array();
$zilla_invoice_details_data = array();
$user_zilla = $user->zilla;
$zilla_table_invoice = str_pad($user_zilla, 2, "0", STR_PAD_LEFT) . '_invoices';
$zilla_table_invoice_details = str_pad($user_zilla, 2, "0", STR_PAD_LEFT) . '_invoice_details';
$uisc_id = $user->uisc_id;
$user_group_id = $user->user_group_id;
$division = $user->division;
$zilla = $user->zilla;
$upazila = $user->upazila;
$unioun = $user->unioun;
$citycorporation = $user->citycorporation;
//$citycorporationward = $user->citycorporationward;
$municipal = $user->municipal;
//$municipalward = $user->municipalward;
$invoice_date = $invDate;
$customerPost = $customer_name;
$servicePost = $service_name;
$genderPost = $gender;
$earningPost = $amount;
$count = sizeof($customerPost);
$invoice_data['uisc_id'] = $uisc_id;
$invoice_data['unionid'] = $unioun;
$invoice_data['municipalid'] = $municipal;
$invoice_data['citycorporationid'] = $citycorporation;
$invoice_data['upazilaid'] = $upazila;
$invoice_data['zillaid'] = $zilla;
$invoice_data['divid'] = $division;
$invoice_data['type'] = $user_group_id;
$invoice_data['invoice_date'] = $invoice_date;
$invoice_data['total_income'] = $total_income;
$invoice_data['total_service'] = $total_services;
$invoice_data['total_men'] = $total_men;
$invoice_data['total_women'] = $total_women;
$invoice_data['total_tribe'] = $total_tribe;
$invoice_data['total_disability'] = $total_disability;
$zilla_invoice_data['uisc_id'] = $uisc_id;
$zilla_invoice_data['unionid'] = $unioun;
$zilla_invoice_data['municipalid'] = $municipal;
$zilla_invoice_data['citycorporationid'] = $citycorporation;
$zilla_invoice_data['upazilaid'] = $upazila;
$zilla_invoice_data['zillaid'] = $zilla;
$zilla_invoice_data['divid'] = $division;
$zilla_invoice_data['type'] = $user_group_id;
$zilla_invoice_data['invoice_date'] = $invoice_date;
$zilla_invoice_data['total_income'] = $total_income;
$zilla_invoice_data['total_service'] = $total_services;
$zilla_invoice_data['total_men'] = $total_men;
$zilla_invoice_data['total_women'] = $total_women;
// echo $zilla_table_invoice;
// print_r($zilla_invoice_data);exit;
if (!$check_income) {
if ($total_services > 0) {
$this->db->trans_start();
//DB Transaction Handle START
//$delete_invoice_data['invoice_date'] = $invoice_date;
//Query_helper::delete('invoices', $delete_invoice_data);
if ($this->Service_template_model->delete_invoice_data($invoice_date)) {
$invoice_id = Query_helper::add('invoices', $invoice_data);
$zilla_invoice_id = Query_helper::add($zilla_table_invoice, $zilla_invoice_data);
for ($i = 0; $i < $count; $i++) {
if ($this->Service_template_model->check_uisc_service_existence($servicePost[$i])) {
list($service_id, $service_name) = $this->Service_template_model->check_uisc_service_existence($servicePost[$i]);
$invoice_details_data['invoice_id'] = $invoice_id;
$invoice_details_data['receiver_name'] = $customerPost[$i];
$invoice_details_data['receiver_sex'] = $genderPost[$i];
$invoice_details_data['service_id'] = $service_id;
//$this->Service_template_model->get_service_id($servicePost[$i]);
$invoice_details_data['income'] = System_helper::Get_Bng_to_Eng($earningPost[$i]);
$invoice_details_data['service_name'] = $service_name;
//$this->Service_template_model->get_service_name($servicePost[$i]);
$zilla_invoice_details_data['invoice_id'] = $zilla_invoice_id;
$zilla_invoice_details_data['receiver_name'] = $customerPost[$i];
$zilla_invoice_details_data['receiver_sex'] = $genderPost[$i];
$zilla_invoice_details_data['service_id'] = $service_id;
//$this->Service_template_model->get_service_id($servicePost[$i]);
$zilla_invoice_details_data['income'] = System_helper::Get_Bng_to_Eng($earningPost[$i]);
$zilla_invoice_details_data['service_name'] = $service_name;
//$this->Service_template_model->get_service_name($servicePost[$i]);
Query_helper::add('invoice_details', $invoice_details_data);
Query_helper::add($zilla_table_invoice_details, $zilla_invoice_details_data);
}
}
$fileInfo = array('user_id' => $user->id, 'uisc_id' => $uisc_id, 'file_name' => $fileName, 'upload_date' => strtotime($invDate), 'create_date' => time());
Query_helper::add($this->config->item('table_excel_history'), $fileInfo);
$this->db->trans_complete();
//DB Transaction Handle END
if ($this->db->trans_status() === TRUE) {
$this->message = $this->lang->line("MSG_CREATE_SUCCESS");
$this->dcms_add();
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL");
$this->jsonReturn($ajax);
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL");
$this->jsonReturn($ajax);
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("NO_SERVICES_IN_UISC");
$this->jsonReturn($ajax);
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_INCOME_AMOUNT_INVALID");
$this->jsonReturn($ajax);
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_MAXIMUM_NUMBER_OF_FILES");
$this->jsonReturn($ajax);
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_MAX_SIZE");
$this->jsonReturn($ajax);
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_EXCEL_ONLY");
$this->jsonReturn($ajax);
}
}
private function system_save()
{
$user = User_helper::get_user();
$id = $this->input->post("id");
if (!$this->permissions['edit']) {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS");
$this->jsonReturn($ajax);
die;
}
if (!$this->check_validation()) {
$ajax['status'] = false;
$ajax['system_message'] = $this->message;
$this->jsonReturn($ajax);
} else {
$tasks = $this->input->post('tasks');
$user_group_id = $this->input->post('id');
$time = time();
$this->db->trans_start();
//DB Transaction Handle START
foreach ($tasks as $task) {
$data = array();
if (isset($task['list']) && $task['list'] == 1) {
$data['list'] = 1;
} else {
$data['list'] = 0;
}
if (isset($task['view']) && $task['view'] == 1) {
$data['view'] = 1;
} else {
$data['view'] = 0;
}
if (isset($task['add']) && $task['add'] == 1) {
$data['add'] = 1;
} else {
$data['add'] = 0;
}
if (isset($task['edit']) && $task['edit'] == 1) {
$data['edit'] = 1;
} else {
$data['edit'] = 0;
}
if (isset($task['delete']) && $task['delete'] == 1) {
$data['delete'] = 1;
} else {
$data['delete'] = 0;
}
if (isset($task['report']) && $task['report'] == 1) {
$data['report'] = 1;
} else {
$data['report'] = 0;
}
if (isset($task['print']) && $task['print'] == 1) {
$data['print'] = 1;
} else {
$data['print'] = 0;
}
if ($data['view'] || $data['add'] || $data['edit'] || $data['delete'] || $data['report'] || $data['print']) {
$data['list'] = 1;
}
if ($task['ugr_id'] > 0) {
$data['update_by'] = $user->id;
$data['update_date'] = $time;
Query_helper::update($this->config->item('table_user_group_role'), $data, array("id = " . $task['ugr_id']));
} else {
$data['user_group_id'] = $user_group_id;
$data['component_id'] = $task['component_id'];
$data['module_id'] = $task['module_id'];
$data['task_id'] = $task['task_id'];
$data['create_by'] = $user->id;
$data['create_date'] = $time;
Query_helper::add($this->config->item('table_user_group_role'), $data);
}
}
$this->db->trans_complete();
//DB Transaction Handle END
if ($this->db->trans_status() === TRUE) {
$this->message = $this->lang->line("MSG_ROLE_ASSIGN_SUCCESS");
$this->system_list();
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_ROLE_ASSIGN_FAIL");
$this->jsonReturn($ajax);
}
}
}
private function system_save()
{
$user = User_helper::get_user();
$id = $this->input->post("id");
if ($id > 0) {
if (!$this->permissions['edit']) {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS");
$this->jsonReturn($ajax);
die;
}
} else {
if (!$this->permissions['add']) {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS");
$this->jsonReturn($ajax);
die;
}
}
if (!$this->check_validation()) {
$ajax['status'] = false;
$ajax['system_message'] = $this->message;
$this->jsonReturn($ajax);
} else {
if ($id > 0) {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL");
$this->jsonReturn($ajax);
} else {
$data = array();
$user_id = $user->id;
$uisc_id = $user->uisc_id;
$data['uisc_id'] = $uisc_id;
$data['user_id'] = $user_id;
$data['question'] = $this->input->post('question');
$data['user_type'] = $this->input->post('user_group');
$data['create_by'] = $user_id;
$data['create_date'] = time();
$this->db->trans_start();
//DB Transaction Handle START
Query_helper::add($this->config->item('table_faqs'), $data);
$this->db->trans_complete();
//DB Transaction Handle END
if ($this->db->trans_status() === TRUE) {
$this->message = $this->lang->line("MSG_CREATE_SUCCESS");
$save_and_new = $this->input->post('system_save_new_status');
if ($save_and_new == 1) {
$this->system_add();
} else {
$this->system_list();
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL");
$this->jsonReturn($ajax);
}
}
}
}
>
<?php
if (isset($uisc_id) && $uisc_id > 0) {
if ($upazila > 0) {
$center_type_udc = $this->config->item('ONLINE_UNION_GROUP_ID');
$udcs = Query_helper::get_info($this->config->item('table_uisc_infos'), array('id value', 'uisc_name text'), array('uisc_type = ' . $center_type_udc, 'zilla = ' . $zilla, 'upazilla = ' . $upazila, 'union = ' . $union));
$CI->load_view("dropdown", array('drop_down_options' => $udcs, 'drop_down_selected' => $uisc_id));
}
if ($citycorporation > 0) {
$center_type_cdc = $this->config->item('ONLINE_CITY_CORPORATION_WORD_GROUP_ID');
$cdcs = Query_helper::get_info($this->config->item('table_uisc_infos'), array('id value', 'uisc_name text'), array('uisc_type = ' . $center_type_cdc, 'zilla = ' . $zilla, 'citycorporation = ' . $citycorporation, 'citycorporationward = ' . $citycorporationward));
$CI->load_view("dropdown", array('drop_down_options' => $cdcs, 'drop_down_selected' => $uisc_id));
}
if ($municipal > 0) {
$center_type_pdc = $this->config->item('ONLINE_MUNICIPAL_WORD_GROUP_ID');
$pdcs = Query_helper::get_info($this->config->item('table_uisc_infos'), array('id value', 'uisc_name text'), array('uisc_type = ' . $center_type_pdc, 'zilla = ' . $zilla, 'municipal = ' . $municipal, 'municipalward = ' . $municipalward));
$CI->load_view("dropdown", array('drop_down_options' => $pdcs, 'drop_down_selected' => $uisc_id));
}
?>
<input type="hidden" name="digital_center" value="<?php
echo $uisc_id;
?>
" />
<?php
}
?>
</select>
</div>
</div>
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);
}
}
}
}
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);
}
}
}
}
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 = array();
$userDetail['password'] = $this->input->post('password');
$userDetail['confirm_password'] = $this->input->post('confirm_password');
if ($id > 0) {
if ($userDetail['password'] != "") {
$actual_password = $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;
}
if ($id > 0) {
$userDetail['update_by'] = $user->id;
$userDetail['update_date'] = time();
$this->db->trans_start();
//DB Transaction Handle START
Query_helper::update($this->config->item('table_users'), $userDetail, array("id = " . $id));
$this->db->trans_complete();
//DB Transaction Handle END
if ($this->db->trans_status() === TRUE) {
// $this->load->library('email');
// $this->email->set_mailtype("html");
// $this->email->from('*****@*****.**');
// $this->email->to('*****@*****.**');
// $mail_body = $this->load->view('mail_all_applicant', $data, true);
// $subject = "ইউজার আইডি ও পাসওয়ার্ড ";
// $this->email->subject($subject);
// $this->email->message($mail_body);
// $email = $this->email->send();
// if ($email) {
// $user_info = $this->test_model->email_sent('send', $user_infos['username'], $applicant_email);
// } else {
// $user_info = $this->test_model->email_sent('not send', $user_infos['username'], $applicant_email);
// }
// $this->email->print_debugger();
$this->message = $this->lang->line("MSG_UPDATE_SUCCESS");
$save_and_new = $this->input->post('system_save_new_status');
if ($save_and_new == 1) {
$subject = $this->lang->line('ADMIN_PASSWORD_CHANGE_SUBJECT_TITLE');
$msg = "আপনার পাসওয়ার্ড পরিবর্তন করা হয়েছে। আপনার নতুন পাসওয়ার্ডঃ " . $actual_password;
$from_email = $this->config->item('from_mail_address');
$to_email = $userDetail['email'];
$cc_email = $from_email;
User_helper::mail_send($from_email, $to_email, $cc_email, '', $subject, $msg);
$this->system_edit();
} else {
$this->system_edit();
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL");
$this->jsonReturn($ajax);
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL");
$this->jsonReturn($ajax);
}
}
}
foreach ($zilla['upazilla'] as $upazilla) {
?>
<tr>
<th colspan="<?php
echo $numDays + 4;
?>
" class="text-center">
<?php
echo $upazilla['upazilla_name'] . $this->lang->line('UPAZILLA_NAME');
?>
<br>
<?php
echo !isset($upazilas) ? $this->config->item('month')[$month] . '-' . System_helper::Get_Eng_to_Bng($year) . "<br/>" : "";
?>
<?php
echo $this->lang->line('TOTAL_UNION') . ' ' . System_helper::Get_Eng_to_Bng(count(Query_helper::get_info($this->config->item('table_unions'), 'rowid', array('zillaid =' . $zilla['zilla_id'], 'upazilaid =' . $upazilla['upazilla_id']))));
?>
</th>
</tr>
<tr>
<th><?php
echo $this->lang->line('UNION');
?>
</th>
<th><?php
echo $this->lang->line('CENTER');
?>
</th>
<?php
for ($d = 1; $d <= $numDays; $d++) {
?>
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);
}
}
}
}
public function get_modules_by_component_id()
{
$component_id = $this->input->post('component_id');
$modules = Query_helper::get_info($this->config->item('table_module'), array('id value', 'name_' . $this->get_language_code() . ' text'), array('component_id = ' . $component_id, 'status !=99'));
$ajax['status'] = true;
$ajax['system_content'][] = array("id" => "#module_options", "html" => $this->load_view("dropdown", array('drop_down_options' => $modules), true));
$this->jsonReturn($ajax);
}
public function system_save()
{
$id = $this->input->post("id");
$data = $this->input->post('task');
$user = User_helper::get_user();
if ($id > 0) {
$this->db->trans_start();
//DB Transaction Handle START
$data['modified_by'] = $user->user_id;
$data['modification_date'] = time();
Query_helper::update($this->config->item('table_task'), $data, array("id = " . $id));
$this->db->trans_complete();
//DB Transaction Handle END
if ($this->db->trans_status() === TRUE) {
$this->message = $this->lang->line("MSG_UPDATE_SUCCESS");
$this->system_list();
} else {
$this->message = $this->lang->line("MSG_NOT_UPDATED_SUCCESS");
}
} else {
$this->db->trans_start();
//DB Transaction Handle START
$data['created_by'] = $user->user_id;
$data['creation_date'] = time();
Query_helper::add($this->config->item('table_task'), $data);
$this->db->trans_complete();
//DB Transaction Handle END
if ($this->db->trans_status() === TRUE) {
$this->message = $this->lang->line("MSG_CREATE_SUCCESS");
$this->system_list();
} else {
$this->message = $this->lang->line("MSG_NOT_SAVED_SUCCESS");
}
}
}
public function education_classescollege()
{
$classes = $this->input->post('classes');
$educationlevel = Query_helper::get_info($this->config->item('table_classes'), array('id value', 'name text'), array('education_level_id = ' . $classes));
$ajax['status'] = true;
$ajax['system_content'][] = array("id" => "#classes", "html" => $this->load_view("dropdown", array('drop_down_options' => $educationlevel), true));
$this->jsonReturn($ajax);
}
private function system_batch_delete()
{
if ($this->permissions['delete']) {
$user = User_helper::get_user();
$selected_ids = $this->input->post('selected_ids');
$this->db->trans_start();
//DB Transaction Handle START
foreach ($selected_ids as $id) {
Query_helper::update($this->config->item('table_services'), array('status' => 99, 'update_by' => $user->id, 'update_date' => time()), array("id = " . $id));
}
$this->db->trans_complete();
//DB Transaction Handle END
if ($this->db->trans_status() === TRUE) {
$this->message = $this->lang->line("MSG_DELETE_SUCCESS");
$this->system_list();
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_DELETE_FAIL");
$this->jsonReturn($ajax);
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS");
$this->jsonReturn($ajax);
}
}
private function system_save()
{
$user = User_helper::get_user();
$id = $this->input->post("id");
if ($id > 0) {
if (!$this->permissions['edit']) {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS");
$this->jsonReturn($ajax);
die;
}
} else {
if (!$this->permissions['add']) {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS");
$this->jsonReturn($ajax);
die;
}
}
if (!$this->check_validation()) {
$ajax['status'] = false;
$ajax['system_message'] = $this->message;
$this->jsonReturn($ajax);
} else {
$userDetail = $this->input->post('user_detail');
if ($id > 0) {
if ($userDetail['password'] != "") {
$encryptPass = md5(md5($userDetail['password']));
unset($userDetail['password']);
unset($userDetail['confirm_password']);
$userDetail['password'] = $encryptPass;
} else {
unset($userDetail['password']);
unset($userDetail['confirm_password']);
}
} else {
$encryptPass = md5(md5($userDetail['password']));
unset($userDetail['password']);
unset($userDetail['confirm_password']);
$userDetail['password'] = $encryptPass;
}
$user_group_id_level = explode('-', $this->input->post("user_detail[user_group_id]"));
$user_group_id = $user_group_id_level[0];
//$user_group_level=$user_group_id_level[1];
$userDetail['user_group_id'] = $user_group_id;
$date_of_birth = strtotime($userDetail['dob']);
$userDetail['dob'] = $date_of_birth;
$dir = $this->config->item("file_upload");
$uploaded = System_helper::upload_file($dir['users'], 1024, 'gif|jpg|png');
if (array_key_exists('picture_name', $uploaded)) {
if ($uploaded['picture_name']['status']) {
$userDetail['picture_name'] = $uploaded['picture_name']['info']['file_name'];
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->message .= $uploaded['picture_name']['message'] . '<br>';
$this->jsonReturn($ajax);
}
}
if ($id > 0) {
unset($userDetail['id']);
$userDetail['update_by'] = $user->id;
$userDetail['update_date'] = time();
$this->db->trans_start();
//DB Transaction Handle START
Query_helper::update($this->config->item('table_users'), $userDetail, array("id = " . $id));
$this->db->trans_complete();
//DB Transaction Handle END
if ($this->db->trans_status() === TRUE) {
$this->message = $this->lang->line("MSG_UPDATE_SUCCESS");
$save_and_new = $this->input->post('system_save_new_status');
if ($save_and_new == 1) {
$this->system_add();
} else {
$this->system_list();
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL");
$this->jsonReturn($ajax);
}
} else {
$userDetail['status'] = $this->config->item('STATUS_ACTIVE');
$userDetail['create_by'] = $user->id;
$userDetail['create_date'] = time();
$this->db->trans_start();
//DB Transaction Handle START
Query_helper::add($this->config->item('table_users'), $userDetail);
$this->db->trans_complete();
//DB Transaction Handle END
if ($this->db->trans_status() === TRUE) {
$this->message = $this->lang->line("MSG_CREATE_SUCCESS");
$save_and_new = $this->input->post('system_save_new_status');
if ($save_and_new == 1) {
$this->system_add();
} else {
$this->system_list();
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL");
$this->jsonReturn($ajax);
}
}
}
}
private function system_save()
{
$user = User_helper::get_user();
$id = $this->input->post("id");
if ($id > 0) {
if (!$this->permissions['edit']) {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS");
$this->jsonReturn($ajax);
die;
}
} else {
if (!$this->permissions['add']) {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS");
$this->jsonReturn($ajax);
die;
}
}
if (!$this->check_validation()) {
$ajax['status'] = false;
$ajax['system_message'] = $this->message;
$this->jsonReturn($ajax);
} else {
$user_id = $this->input->post('user_id');
//$row_id=$this->input->post('row_id');
$ticket_issue_id = $this->input->post('ticket_issue_id');
$ticket_priority = $this->input->post('ticket_priority');
$count = count($this->input->post('row_id'));
if ($id > 0) {
// unset($ticket_detail['id']);
//
// $ticket_detail['update_by']=$user->id;
// $ticket_detail['update_date']=time();
//
// $this->db->trans_start(); //DB Transaction Handle START
//
// Query_helper::update($this->config->item('table_ticket_assign'),$ticket_detail,array("id = ".$id));
//
// $this->db->trans_complete(); //DB Transaction Handle END
//
// if ($this->db->trans_status() === TRUE)
// {
// $this->message=$this->lang->line("MSG_UPDATE_SUCCESS");
// $save_and_new=$this->input->post('system_save_new_status');
// if($save_and_new==1)
// {
// $this->system_add();
// }
// else
// {
// $this->system_list();
// }
// }
// else
// {
// $ajax['status']=false;
// $ajax['system_message']=$this->lang->line("MSG_UPDATE_FAIL");
// $this->jsonReturn($ajax);
// }
} else {
$ticket_detail['status'] = $this->config->item('STATUS_ASSIGN');
$ticket_detail['create_by'] = $user->id;
$ticket_detail['create_date'] = time();
$ticket_issue_detail['status'] = $this->config->item('STATUS_ASSIGN');
$ticket_issue_detail['update_by'] = $user->id;
$ticket_issue_detail['update_date'] = time();
$this->db->trans_start();
//DB Transaction Handle START
for ($i = 0; $i < $count; $i++) {
if (isset($ticket_issue_id[$i])) {
$ticket_detail['user_id'] = $user_id;
$ticket_detail['ticket_issue_id'] = $ticket_issue_id[$i];
$ticket_detail['priority'] = $ticket_priority[$i];
Query_helper::add($this->config->item('table_ticket_assign'), $ticket_detail);
Query_helper::update($this->config->item('table_ticket_issue'), $ticket_issue_detail, array("id = " . $ticket_issue_id[$i]));
}
}
$this->db->trans_complete();
//DB Transaction Handle END
if ($this->db->trans_status() === TRUE) {
$this->message = $this->lang->line("MSG_CREATE_SUCCESS");
$save_and_new = $this->input->post('system_save_new_status');
if ($save_and_new == 1) {
$this->system_add();
} else {
$this->system_list();
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL");
$this->jsonReturn($ajax);
}
}
}
}
private function system_save()
{
$user = User_helper::get_user();
$id = $this->input->post("id");
if ($id > 0) {
if (!$this->permissions['edit']) {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS");
$this->jsonReturn($ajax);
die;
}
} else {
if (!$this->permissions['add']) {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS");
$this->jsonReturn($ajax);
die;
}
}
if (!$this->check_validation()) {
$ajax['status'] = false;
$ajax['system_message'] = $this->message;
$this->jsonReturn($ajax);
} else {
$media_info = $this->input->post('media');
$dir = $this->config->item("dcms_upload");
if ($media_info['media_type'] == 1) {
$directory = $dir['media_photo'];
unset($media_info['video_link']);
unset($media_info['print_year']);
unset($media_info['external_link']);
} elseif ($media_info['media_type'] == 2) {
$directory = $dir['media_photo'];
unset($media_info['print_year']);
unset($media_info['external_link']);
} elseif ($media_info['media_type'] == 3) {
$directory = $dir['media_print'];
unset($media_info['video_link']);
} elseif ($media_info['media_type'] == 4) {
$directory = $dir['media_publication'];
unset($media_info['video_link']);
unset($media_info['print_year']);
}
$uploaded = System_helper::upload_file($directory, 5120, 'gif|jpg|png|pdf|doc|docx');
if (array_key_exists('file_name', $uploaded)) {
if ($uploaded['file_name']['status']) {
$media_info['file_name'] = $uploaded['file_name']['info']['file_name'];
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->message .= $uploaded['file_name']['message'] . '<br>';
$this->jsonReturn($ajax);
}
}
if ($id > 0) {
unset($media_info['id']);
$media_info['update_by'] = $user->id;
$media_info['update_date'] = time();
$this->db->trans_start();
//DB Transaction Handle START
Query_helper::update($this->config->item('table_media'), $media_info, array("id = " . $id));
$this->db->trans_complete();
//DB Transaction Handle END
if ($this->db->trans_status() === TRUE) {
$this->message = $this->lang->line("MSG_UPDATE_SUCCESS");
$save_and_new = $this->input->post('system_save_new_status');
if ($save_and_new == 1) {
$this->system_add();
} else {
$this->system_list();
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL");
$this->jsonReturn($ajax);
}
} else {
$media_info['create_by'] = $user->id;
$media_info['create_date'] = time();
$this->db->trans_start();
//DB Transaction Handle START
Query_helper::add($this->config->item('table_media'), $media_info);
$this->db->trans_complete();
//DB Transaction Handle END
if ($this->db->trans_status() === TRUE) {
$this->message = $this->lang->line("MSG_CREATE_SUCCESS");
$save_and_new = $this->input->post('system_save_new_status');
if ($save_and_new == 1) {
$this->system_add();
} else {
$this->system_list();
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL");
$this->jsonReturn($ajax);
}
}
}
}
private function system_save()
{
$user = User_helper::get_user();
$id = $this->input->post("id");
$data = $this->input->post('key');
$keyConfig = $this->config->item('KEY_TYPE');
if ($id > 0) {
if (!$this->permissions['edit']) {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS");
$this->jsonReturn($ajax);
}
} else {
if (!$this->permissions['add']) {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS");
$this->jsonReturn($ajax);
}
}
if (!$this->check_validation()) {
$ajax['status'] = false;
$ajax['system_message'] = $this->message;
$this->jsonReturn($ajax);
} else {
if ($data['parent'] == $keyConfig['CAMPUS'] || $data['parent'] == $keyConfig['SESSION']) {
$data['description'] = json_encode($this->input->post('description'));
}
if ($id > 0) {
$data['update_by'] = $user->id;
$data['update_date'] = time();
$this->db->trans_start();
//DB Transaction Handle START
Query_helper::update($this->config->item('table_system_keyword'), $data, array("id = " . $id));
$this->db->trans_complete();
//DB Transaction Handle END
if ($this->db->trans_status() === TRUE) {
$this->message = $this->lang->line("MSG_UPDATE_SUCCESS");
$save_and_new = $this->input->post('system_save_new_status');
if ($save_and_new == 1) {
$this->system_add();
} else {
$this->system_list();
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_UPDATE_FAIL");
$this->jsonReturn($ajax);
}
} else {
$data['create_by'] = $user->id;
$data['create_date'] = time();
$this->db->trans_start();
//DB Transaction Handle START
Query_helper::add($this->config->item('table_system_keyword'), $data);
$this->db->trans_complete();
//DB Transaction Handle END
if ($this->db->trans_status() === TRUE) {
$this->message = $this->lang->line("MSG_CREATE_SUCCESS");
$save_and_new = $this->input->post('system_save_new_status');
if ($save_and_new == 1) {
$this->system_add();
} else {
$this->system_list();
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL");
$this->jsonReturn($ajax);
}
}
}
}
private function system_save()
{
$user = User_helper::get_user();
if (!$this->permissions['add']) {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("YOU_DONT_HAVE_ACCESS");
$this->jsonReturn($ajax);
die;
}
if (!$this->check_validation()) {
$ajax['status'] = false;
$ajax['system_message'] = $this->message;
$this->jsonReturn($ajax);
} else {
$data = $this->input->post('requisition');
$data['create_by'] = $user->id;
$data['create_date'] = time();
$data['user_id'] = $user->id;
$this->load->helper('string');
$data['requisition_id'] = time() . random_string('alpha', 3);
$this->db->trans_start();
//DB Transaction Handle START
Query_helper::add($this->config->item('table_requisition'), $data);
$this->db->trans_complete();
//DB Transaction Handle END
if ($this->db->trans_status() === TRUE) {
$this->message = $this->lang->line("MSG_CREATE_SUCCESS");
$save_and_new = $this->input->post('system_save_new_status');
if ($save_and_new == 1) {
$this->system_add();
} else {
$this->system_list();
}
} else {
$ajax['status'] = false;
$ajax['system_message'] = $this->lang->line("MSG_CREATE_FAIL");
$this->jsonReturn($ajax);
}
}
}
