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;
}
