public function register($submode = '') { /** * proses register data people * - get latest id * - get posted data */ //$this->load->library('image_lib'); $MYFILE = new MyFile(); $now = date('U'); if ($submode == 'add') { $data['id'] = sprintf('%09d', $this->db_model->select_max('id', 'mybf_people') + 1); $data['date_added'] = $now; } else { if ($submode == 'update') { $updated_id = $this->input->post('people_id'); $data['id'] = $updated_id; } } $data['date_updated'] = $now; $data['nama'] = $this->input->post('nama'); //validasi $data['alias'] = $this->input->post('alias'); //validasi $data['jenis_kelamin'] = $this->input->post('jenis_kelamin'); //validasi $data['tempat_lahir'] = $this->input->post('tempat_lahir'); $data['tanggal_lahir'] = $this->input->post('tanggal_lahir'); //validasi $data['tempat_tinggal'] = $this->input->post('tempat_tinggal'); $data['phone'] = $this->input->post('phone'); //validasi $data['kontak_lain'] = $this->input->post('kontak_lain'); $data['id_pernikahan'] = $this->input->post('id_pernikahan'); $data['note'] = $this->input->post('note'); $data['tanggal_lahir'] = $data['tanggal_lahir'] == '' ? '0000-00-00' : $data['tanggal_lahir']; $data['id_pernikahan'] = $data['tanggal_lahir'] == '' ? '0' : $data['id_pernikahan']; $id_pasangan = $this->input->post('id_pasangan'); // jika ada file gambar dilampirkan, upload gambar if (is_array($_FILES)) { if (is_uploaded_file($_FILES['people_image']['tmp_name'])) { print_r($_FILES); $path_parts = pathinfo($_FILES['people_image']['name']); $newFileName = $data['id'] . "." . $path_parts['extension']; $newThumbsFileName = $data['id'] . "_thumbs." . $path_parts['extension']; $newThumbsFileName_mini = $data['id'] . "_thumbs_mini." . $path_parts['extension']; $sourcePath = $_FILES['people_image']['tmp_name']; $targetPath = "assets/images/foto/individual/"; if (move_uploaded_file($sourcePath, $targetPath . $newFileName)) { $data['photo'] = $_FILES['people_image']['name']; //success $MYFILE->makeImageThumbs($targetPath . $newFileName, $targetPath . $newThumbsFileName, 165, 200, "fill", "center", array(), 80); $MYFILE->makeImageThumbs($targetPath . $newThumbsFileName, $targetPath . $newThumbsFileName_mini, 50, 50, "fit-h", "center", array(), 80); } } } if ($submode == 'add') { //validasi exitensi data person $query_people_add = $this->db->insert('mybf_people', $data); if ($query_people_add) { $content['message'] = "adding individual data success"; } else { $content['message'] = "adding individual data failed" . ERROR_TAG; } } else { if ($submode == 'update') { //validasi exitensi data person //print_r($data); /**/ $this->db->where('id', $updated_id); //$this->db->update('mybf_people', $data); $query_people_update = $this->db->update('mybf_people', $data); if ($query_people_update) { $content['message'] = "updating individual data success"; } else { $content['message'] = "updating individual data failed" . ERROR_TAG; } } } /**/ if (is_numeric($id_pasangan) && $id_pasangan > 0) { //registrasikan pasangan jika belum ada di db /* $query = $this->db->query("SELECT * FROM mybf_people WHERE nama='{$data['nama']}' OR tempat_lahir='{$data['tempat_lahir']}' ORDER BY id DESC LIMIT 0,1"); $data_people = $query->result_array();*/ $people_id = $data['id']; //validasi urutan if ($data['jenis_kelamin'] == 'L') { $data_pasangan = array('id_suami' => $people_id, 'id_istri' => $id_pasangan); } else { $data_pasangan = array('id_istri' => $people_id, 'id_suami' => $id_pasangan); } $data_pasangan['date_added'] = $data_pasangan['date_updated'] = $now; $query_couple = $this->db->select('id')->get_where('mybf_marriage', $data_pasangan); $c_data = $query_couple->result_array(); if (empty($c_data['id'])) { // jika tidak ada di tabel, tambahkan $this->db->insert('mybf_marriage', $data_pasangan); } } //output $data['peoples'] = $this->individual_model->get_people($data['id']); $data['mode'] = 'list_content'; $content['row'] = $this->load->view('individual_view', $data, TRUE); //print rows function print DATA_SPLITER . print_json($content, false) . DATA_SPLITER; }
date_default_timezone_set($timezone); } //must set timezone on the top set_time_limit(300); global $db; $action = array(); $output = new stdClass(); if (!($action = optional_param("action", 0))) { $msg = 'No action'; echo tojson($_SESSION); //print_error($msg); } switch ($action) { case 'add_transfer_from_po': //check use can use this function if (!check_office_staff($_SESSION['staff_no'])) { print_error('You have no permission'); } $pono_raw = optional_param("pono", 0); $dnno_raw = optional_param("dnno", 0); if (!$pono_raw) { print_error('No PO No.'); } $pono_temp = get_numofpo($pono_raw); $pono = $pono_temp[1]; if (!add_transfer_from_po($pono, $dnno_raw)) { print_error('Fail to add transfer'); } print_json(array("success" => "1")); break; }
function submitNewQuestion($db, $argumentId, $solutionId) { $stmt = $db->query("INSERT INTO " . $_GET['type'] . " (testo,db_connesso,soluzione,argomento)\n VALUES ('" . $_GET['text'] . "','" . $_GET['db'] . "'," . $solutionId . "," . $argumentId . ");"); $json = '{ "Success": "Domanda aggiunta!" }'; print_json($json); }
function jsond($data) { print_json($data); die; }
echo '[{ "query": "' . $soluzione . '" }, { "results" : ' . getJson($result) . '}]'; return; } //Blacklist word if (isset($_GET['sql']) && $_GET['sql'] != "" && isset($_GET['soluz']) && $_GET['soluz'] != "") { $sql = strtolower($_GET['sql']); if (strpos($sql, "select") == -1) { $json = '{ "Error": "Non è stata eseguita una query SELECT!" }'; } else { if (strpos($sql, "delete") > -1 || strpos($sql, "insert") > -1 || strpos($sql, "create") > -1 || strpos($sql, "drop") > -1 || strpos($sql, "replication") > -1 || strpos($sql, "replace") > -1 || strpos($sql, "grant") > -1 || strpos($sql, "show") > -1 || strpos($sql, "trigger") > -1 || strpos($sql, "from utenti") > -1 || strpos($sql, "from argomenti") > -1 || strpos($sql, "from domandeALG") > -1 || strpos($sql, "from domandeSQL") > -1 || strpos($sql, "from soluzioni") > -1) { $json = '{ "Error": "Non è stata eseguita una query SELECT!" }'; } else { /* User Query */ $stmt = $db->query($_GET['sql']); if (!$stmt) { print_json('{ "Error": "Errore durante l\' esecuzione della query: ' . $db->errorInfo()[2] . '" }'); return; } $data = $stmt->fetchAll(PDO::FETCH_ASSOC); $json = '[{"results" : ' . getJson($data) . "}, "; /* Solution Query */ $stmt = $db->query("SELECT soluzione FROM soluzioni WHERE id = " . $_GET['soluz']); $solution = $stmt->fetchAll(PDO::FETCH_ASSOC)[0]['soluzione']; $stmt = $db->query($solution); $data2 = $stmt->fetchAll(PDO::FETCH_ASSOC); if (count($data) != count($data2)) { $json .= '{ "Error": "Query sbagliata! Non è stato selezionato lo stesso numero di righe!" }'; } else { if (count($data[0]) != count($data2[0])) { $json .= '{ "Error": "Query sbagliata! Non sono stati selezionati gli stessi campi e/o numero di colonne!" }'; } else {
public function register($submode = 'update') { /** * proses register data people * - get latest id * - get posted data */ //$this->load->library('image_lib'); $MYFILE = new MyFile(); $now = date('U'); if ($submode == 'add') { $data['id'] = sprintf('%09d', $this->db_model->select_max('id', 'mybf_marriage') + 1); $data['date_added'] = $now; } else { if ($submode == 'update') { $updated_id = $this->input->post('couple_id'); $data['id'] = $updated_id; } } $data['date_updated'] = $now; $data['id_suami'] = $this->input->post('id_suami'); //validasi $data['id_istri'] = $this->input->post('id_istri'); //validasi $data['tanggal_pernikahan'] = $this->input->post('tanggal_pernikahan'); //validasi $data['status_pernikahan'] = $this->input->post('status_pernikahan'); $data['note'] = $this->input->post('note'); if ($submode == 'add') { //validasi exitensi data person // cek existensi data $id = $this->db_model->get_value('id', 'mybf_marriage', "id_suami = {$data['id_suami']} AND id_istri = {$data['id_istri']}"); if ($id > 0) { $content['message'] = "adding marriage data failed!<br>same data already exists" . ERROR_TAG; } else { $query_marriage_add = $this->db->insert('mybf_marriage', $data); if ($query_marriage_add) { $content['message'] = "adding marriage data success"; } else { $content['message'] = "adding marriage data failed" . ERROR_TAG; } } } else { if ($submode == 'update') { //validasi exitensi data person print_r($data); /**/ $this->db->where('id', $updated_id); //$this->db->update('mybf_marriage', $data); $query_marriage_update = $this->db->update('mybf_marriage', $data); if ($query_marriage_update) { $content['message'] = "updating marriage data success"; } else { $content['message'] = "updating marriage data failed" . ERROR_TAG; } } } //output $data['couples'] = $this->marriage_model->get_couple($data['id']); $data['mode'] = 'list_content'; $content['row'] = $this->load->view('marriage_view', $data, TRUE); //print rows function print DATA_SPLITER . print_json($content, false) . DATA_SPLITER; }