public function submit($pj_id = NULL, $type) { parent::submit($pj_id, $type); $this->load->model('common/tb_owner'); $this->load->database(); // /*========================================*/ // /*======= TRANSACTION START ==============*/ // /*========================================*/ $this->db->trans_start(); $a_id_ref = $this->input->post('a_id'); // /*============================*/ // /*======= ADD SUBMITED =======*/ // /*============================*/ $msg_err = "Add"; if ($type == "added") { $this->tb_owner->record(array('a_id_ref' => $a_id_ref, 'pj_id_ref' => $pj_id)); } else { if ($type == "edited") { } } /*==================================*/ /*======= TRANSACTION COMMIT =======*/ /*==================================*/ $this->db->trans_complete(); if ($this->db->trans_status() === FALSE) { $this->message_error_type = "fail"; $this->message_error = $msg_err . " user failure"; $this->assign($pj_id); } else { $this->message_error_type = "success"; $this->message_error = $msg_err . " user succesfully"; $this->assign($pj_id); } }
public function submit($pm_id = NULL, $type) { parent::submit($pm_id, $type); $this->load->model('common/tb_permission'); $this->load->database(); // /*========================================*/ // /*======= TRANSACTION START ==============*/ // /*========================================*/ $this->db->trans_start(); $pm_name = $this->input->post('pm_name'); $question_mgnt = $this->input->post('question_mgnt'); $survey_mgnt = $this->input->post('survey_mgnt'); $survey_result_mgnt = $this->input->post('survey_result_mgnt'); $admin_mgnt = $this->input->post('admin_mgnt'); $project_mgnt = $this->input->post('project_mgnt'); // /*============================*/ // /*======= ADD SUBMITED =======*/ // /*============================*/ $msg_err = "Add"; if ($type == "added") { if ($pm_name == "" || $pm_name == NULL) { $this->message_error_type = "fail"; $this->message_error = "Your permission name not empty."; $this->add(); return; } $pm_id = $this->tb_permission->record(array('pm_name' => $pm_name, 'question_mgnt' => $question_mgnt, 'survey_mgnt' => $survey_mgnt, 'survey_result_mgnt' => $survey_result_mgnt, 'admin_mgnt' => $admin_mgnt, 'project_mgnt' => $project_mgnt)); } else { if ($type == "edited") { $msg_err = "Update"; if ($pm_name == "" || $pm_name == NULL) { $this->message_error_type = "fail"; $this->message_error = "Your permission name not empty."; $this->edit($pm_id); return; } $this->tb_permission->update(array('pm_name' => $pm_name, 'question_mgnt' => $question_mgnt, 'survey_mgnt' => $survey_mgnt, 'survey_result_mgnt' => $survey_result_mgnt, 'admin_mgnt' => $admin_mgnt, 'project_mgnt' => $project_mgnt), $pm_id); } } /*==================================*/ /*======= TRANSACTION COMMIT =======*/ /*==================================*/ $this->db->trans_complete(); if ($this->db->trans_status() === FALSE) { $this->message_error_type = "fail"; $this->message_error = $msg_err . " permission failure"; $this->edit($pm_id); } else { $this->message_error_type = "success"; $this->message_error = $msg_err . " permission succesfully"; $this->edit($pm_id); } }
public function submit($a_id = NULL, $type) { parent::submit($a_id, $type); $this->load->model('common/tb_permission'); $this->load->model('common/tb_admin'); $this->load->database(); // /*========================================*/ // /*======= TRANSACTION START ==============*/ // /*========================================*/ $this->db->trans_start(); $a_user = $this->input->post('a_user'); $a_pass = $this->input->post('a_pass'); $a_name = $this->input->post('a_name'); $a_permission = $this->input->post('a_permission'); // /*============================*/ // /*======= ADD SUBMITED =======*/ // /*============================*/ $msg_err = "Add"; if ($type == "added") { if ($a_user == "" || $a_user == NULL || $a_pass == "" || $a_pass == NULL || $a_name == "" || $a_name == NULL) { $this->message_error_type = "fail"; $this->message_error = "Your Username/Password/Name not empty."; $this->add(); return; } $a_id = $this->tb_admin->record(array('a_user' => $a_user, 'a_pass' => md5($a_pass), 'a_name' => $a_name, 'a_permission' => $a_permission)); } else { if ($type == "edited") { $msg_err = "Update"; if ($a_user == "" || $a_user == NULL || $a_name == "" || $a_name == NULL) { $this->message_error_type = "fail"; $this->message_error = "Your Username/Password/Name not empty."; $this->edit($a_id); return; } $this->tb_admin->update(array('a_user' => $a_user, 'a_name' => $a_name, 'a_permission' => $a_permission), $a_id); } } /*==================================*/ /*======= TRANSACTION COMMIT =======*/ /*==================================*/ $this->db->trans_complete(); if ($this->db->trans_status() === FALSE) { $this->message_error_type = "fail"; $this->message_error = $msg_err . " admin failure"; $this->edit($a_id); } else { $this->message_error_type = "success"; $this->message_error = $msg_err . " admin succesfully"; $this->edit($a_id); } }
public function submit($as_id = NULL, $type) { parent::submit($as_id, $type); $this->load->model('tb_answer_style'); $this->load->database(); /*========================================*/ /*======= TRANSACTION START ==============*/ /*========================================*/ $this->db->trans_start(); $as_name = $this->input->post('as_name'); $as_description = $this->input->post('as_description'); $as_text_color = $this->input->post('as_text_color'); $as_identifier = $this->input->post('as_identifier'); /*============================*/ /*======= ADD SUBMITED =======*/ /*============================*/ $msg_err = "Add"; if ($type == "added") { $as_id = $this->tb_answer_style->record(array('as_name' => $as_name, 'as_description' => $as_description, 'as_text_color' => $as_text_color, 'as_identifier' => $as_identifier)); } else { if ($type == "edited") { $msg_err = "Update"; $this->tb_answer_style->update(array('as_name' => $as_name, 'as_description' => $as_description, 'as_text_color' => $as_text_color, 'as_identifier' => $as_identifier), $as_id); } } /*==================================*/ /*======= TRANSACTION COMMIT =======*/ /*==================================*/ $this->db->trans_complete(); if ($this->db->trans_status() === FALSE) { $this->message_error_type = "fail"; $this->message_error = $msg_err . " answer style failure"; $this->edit($as_id); } else { $this->message_error_type = "success"; $this->message_error = $msg_err . " answer style succesfully"; $this->edit($as_id); } }
public function submit($sm_id, $type) { parent::submit($sm_id, $type); $this->load->database(); $this->load->model('tb_survey_mapping'); /*========================================*/ /*=============== DATA ===================*/ /*========================================*/ $sm_name = $this->input->post('sm_name'); $sm_description = $this->input->post('sm_description'); $ff = $this->input->post('question_group'); $question_group = @array_filter(@array_unique($this->input->post('question_group'))); /*========================================*/ /*======= TRANSACTION START ==============*/ /*========================================*/ $survey_empty = $sm_name == NULL || $sm_name == "" ? TRUE : FALSE; $question_group_empty = count($question_group) <= 0 || $question_group == NULL ? TRUE : FALSE; if ($survey_empty == TRUE || $question_group_empty == TRUE) { $this->message_error_type = "fail"; $this->message_error = "Survey name not empty / select question at least 1."; if ($type == 'added') { $this->add(); } else { $this->edit($sm_id); } return; } $sm_image = "default.png"; $this->load->library('upload', $this->upload_survey_config(time("his"))); if ($this->upload->do_upload('sm_image')) { $data = array('upload_data' => $this->upload->data()); $sm_image = $data['upload_data']['file_name']; } $this->db->trans_start(); $msg_err = "Add"; if ($type == 'added') { $sm_id = $this->tb_survey_mapping->record(array('sm_name' => $sm_name, 'sm_description' => $sm_description, 'sm_order_column' => implode(",", $question_group), 'sm_update_at' => date("Y-m-d H:i:s"), 'sm_image' => $sm_image)); $this->tb_survey_mapping->update(array('sm_table_code' => "SV" . $sm_id), $sm_id); $this->tb_survey_mapping->create_table_survey($this->prefix_table_name . $sm_id, $question_group); } else { if ($type == 'edited') { $upload_data = $this->upload->data(); $isUpload = $upload_data['file_size'] > 0 ? TRUE : FALSE; $msg_err = "Update"; if (!$isUpload) { $this->tb_survey_mapping->update(array('sm_name' => $sm_name, 'sm_description' => $sm_description, 'sm_order_column' => implode(",", $question_group), 'sm_update_at' => date("Y-m-d H:i:s")), $sm_id); } else { $this->tb_survey_mapping->update(array('sm_name' => $sm_name, 'sm_description' => $sm_description, 'sm_order_column' => implode(",", $question_group), 'sm_update_at' => date("Y-m-d H:i:s"), 'sm_image' => $sm_image), $sm_id); } $this->tb_survey_mapping->update_table_survey($this->prefix_table_name . $sm_id, $question_group); } } /*==================================*/ /*======= TRANSACTION COMMIT =======*/ /*==================================*/ $this->db->trans_complete(); if ($this->db->trans_status() === FALSE) { $this->message_error_type = "fail"; $this->message_error = $msg_err . " survey failure."; $this->edit($sm_id); } else { $this->message_error_type = "success"; $this->message_error = $msg_err . " survey succesfully."; $this->edit($sm_id); } }
public function submit($pj_id = NULL, $type) { parent::submit($pj_id, $type); $this->load->model('common/tb_project'); $this->load->database(); // /*========================================*/ // /*======= TRANSACTION START ==============*/ // /*========================================*/ $this->db->trans_start(); $pj_name = $this->input->post('pj_name'); $pj_description = $this->input->post('pj_description'); $pj_db_ref = $this->input->post('pj_db_ref'); $pj_image = "default.png"; $this->load->library('upload', $this->upload_config($pj_db_ref . time("his"))); if ($this->upload->do_upload('pj_image')) { $data = array('upload_data' => $this->upload->data()); $pj_image = $data['upload_data']['file_name']; } // /*============================*/ // /*======= ADD SUBMITED =======*/ // /*============================*/ $msg_err = "Add"; if ($type == "added") { if ($pj_name == "" || $pj_name == NULL || $pj_db_ref == "" || $pj_db_ref == NULL) { $this->message_error_type = "fail"; $this->message_error = "Your project name / Database name is not empty."; $this->add(); return; } $this->load->model('common/database'); $result = $this->database->create($pj_db_ref); if ($result == FALSE) { $this->message_error_type = "fail"; $this->message_error = "Create Database Error. ensure your database name is not exist."; $this->add(); return; } else { $pj_id = $this->tb_project->record(array('pj_name' => $pj_name, 'pj_description' => $pj_description, 'pj_db_ref' => $pj_db_ref, 'pj_image' => $pj_image)); } } else { if ($type == "edited") { $msg_err = "Update"; if ($pj_name == "" || $pj_name == NULL) { $this->message_error_type = "fail"; $this->message_error = "Your project name is not empty."; $this->edit($pj_id); return; } $upload_data = $this->upload->data(); $isUpload = $upload_data['file_size'] > 0 ? TRUE : FALSE; if (!$isUpload) { $this->tb_project->update(array('pj_name' => $pj_name, 'pj_description' => $pj_description), $pj_id); } else { $this->tb_project->update(array('pj_name' => $pj_name, 'pj_description' => $pj_description, 'pj_image' => $pj_image), $pj_id); } } } /*==================================*/ /*======= TRANSACTION COMMIT =======*/ /*==================================*/ $this->db->trans_complete(); if ($this->db->trans_status() === FALSE) { $this->message_error_type = "fail"; $this->message_error = $msg_err . " project failure"; $this->edit($pj_id); } else { $this->message_error_type = "success"; $this->message_error = $msg_err . " project succesfully"; $this->edit($pj_id); } }
public function submit($aq_id = NULL, $type) { parent::submit($aq_id, $type); $this->load->model('tb_all_question'); $this->load->model('tb_all_answer'); $this->load->database(); /*========================================*/ /*======= TRANSACTION START ==============*/ /*========================================*/ $this->db->trans_start(); $MAX_ANSWER = 20; $aq_description = $this->input->post('aq_description'); $aa_descriptions = $this->input->post('aa_description'); //array_filter($this->input->post('aa_description')); $aa_actives = $this->input->post('aa_active'); $colors = "#000000"; $types = $this->input->post('type'); $aq_auto_display_result = $this->input->post('aq_auto_display'); if ($aq_auto_display_result == NULL) { $aq_auto_display_result = 0; } else { $aq_auto_display_result = 1; } /*============================*/ /*======= ADD SUBMITED =======*/ /*============================*/ $msg_err = "Add"; if ($type == "added") { if ($aq_description == "" || $aq_description == NULL) { $this->message_error_type = "fail"; $this->message_error = "Your question message not empty."; $this->add(); return; } if (count($aa_descriptions) > $MAX_ANSWER || count($aa_descriptions) == 0) { $this->message_error_type = "fail"; $this->message_error = "The answer mustn't over " . $MAX_ANSWER . " choice or not empty."; $this->add(); return; } $aq_id = $this->tb_all_question->record(array('aq_description' => $aq_description, 'active' => 'Y', 'aq_auto_display' => $aq_auto_display_result)); $i = 0; foreach ($aa_descriptions as $aa_description) { $this->tb_all_answer->record(array('aa_description' => $aa_description, 'active' => $aa_actives[$i] == 'Active' ? 'Y' : 'N', 'type' => $types[$i], 'aq_id_ref' => $aq_id)); $i++; } } else { if ($type == "edited") { $msg_err = "Update"; if ($aq_description == "" || $aq_description == NULL) { $this->message_error_type = "fail"; $this->message_error = "Your question message not empty."; $this->edit($aq_id); return; } if (count($aa_descriptions) > $MAX_ANSWER || count($aa_descriptions) == 0) { $this->message_error_type = "fail"; $this->message_error = "The answer mustn't over " . $MAX_ANSWER . " choice or not empty."; $this->edit($aq_id); return; } $this->tb_all_question->update(array('aq_description' => $aq_description, 'active' => 'Y', 'aq_auto_display' => $aq_auto_display_result), $aq_id); //UPDATE EXIST ANSWERS $aa_ids = $this->input->post('aa_id'); $count_answers = $this->input->post('count_answers'); for ($i = 0; $i < $count_answers; $i++) { $this->tb_all_answer->update(array('aa_description' => $aa_descriptions[$i], 'active' => $aa_actives[$i] == 'Active' ? 'Y' : 'N', 'type' => $types[$i]), $aa_ids[$i]); } //INSERT NEW ANSWERS for ($i = $count_answers; $i < count($aa_descriptions); $i++) { $this->tb_all_answer->record(array('aa_description' => $aa_descriptions[$i], 'active' => $aa_actives[$i] == 'Active' ? 'Y' : 'N', 'type' => $types[$i], 'aq_id_ref' => $aq_id)); } } } /*==================================*/ /*======= TRANSACTION COMMIT =======*/ /*==================================*/ $this->db->trans_complete(); if ($this->db->trans_status() === FALSE) { $this->message_error_type = "fail"; $this->message_error = $msg_err . " question failure"; $this->edit($aq_id); } else { $this->message_error_type = "success"; $this->message_error = $msg_err . " question succesfully"; $this->edit($aq_id); } }