function sms()
{
foreach ($_POST as $key => $value) {
if ($key == 'sms') {
foreach ($value as $kekunci => $papar) {
$data[$kekunci] = bersih($papar);
}
}
}
$kawan = $data['kawan'];
$papar = sms_kawan($data);
//'Successful!!! You have 47 SMS Credit left';
$url = URL . 'kawalan/smskes/' . $kawan . '/SMS BERJAYA DIHANTAR' . "\r" . $papar;
//echo '<pre>$_POST->' . print_r($_POST , 1) . '</pre>';
//echo '<pre>$data->' . print_r($data , 1) . '</pre>';
//echo '$url->' . $url;
// hantar lokasi asal
header('Location:' . $url);
}
public function m_ujian()
{
$this->cek_aktif();
//var def session
$a['sess_level'] = $this->session->userdata('admin_level');
$a['sess_user'] = $this->session->userdata('admin_user');
$a['sess_konid'] = $this->session->userdata('admin_konid');
//var def uri segment
$uri2 = mysql_real_escape_string($this->uri->segment(2));
$uri3 = mysql_real_escape_string($this->uri->segment(3));
$uri4 = mysql_real_escape_string($this->uri->segment(4));
//var post from json
$p = json_decode(file_get_contents('php://input'));
//return as json
$jeson = array();
$a['data'] = $this->db->query("SELECT tr_guru_tes.*, m_mapel.nama AS mapel FROM tr_guru_tes INNER JOIN m_mapel ON tr_guru_tes.id_mapel = m_mapel.id WHERE tr_guru_tes.id_guru = '" . $a['sess_konid'] . "'")->result();
$a['p_mapel'] = obj_to_array($this->db->query("SELECT * FROM m_mapel WHERE id IN (SELECT id_mapel FROM tr_guru_mapel WHERE id_guru = '" . $a['sess_konid'] . "')")->result(), "id,nama");
if ($uri3 == "det") {
$a = $this->db->query("SELECT * FROM tr_guru_tes WHERE id = '{$uri4}'")->row();
$this->j($a);
exit;
} else {
if ($uri3 == "simpan") {
$ket = "";
if ($p->id != 0) {
$this->db->query("UPDATE tr_guru_tes SET id_mapel = '" . bersih($p, "mapel") . "', \n\t\t\t\t\t\t\t\tnama_ujian = '" . bersih($p, "nama_ujian") . "', jumlah_soal = '" . bersih($p, "jumlah_soal") . "', \n\t\t\t\t\t\t\t\twaktu = '" . bersih($p, "waktu") . "'\n\t\t\t\t\t\t\t\tWHERE id = '" . bersih($p, "id") . "'");
$ket = "edit";
} else {
$ket = "tambah";
$this->db->query("INSERT INTO tr_guru_tes VALUES (null, '" . $a['sess_konid'] . "', '" . bersih($p, "mapel") . "',\n\t\t\t\t\t\t\t\t'" . bersih($p, "nama_ujian") . "', '" . bersih($p, "jumlah_soal") . "', '" . bersih($p, "waktu") . "', \n\t\t\t\t\t\t\t\t'acak', '')");
}
$ret_arr['status'] = "ok";
$ret_arr['caption'] = $ket . " sukses";
$this->j($ret_arr);
exit;
} else {
if ($uri3 == "hapus") {
$this->db->query("DELETE FROM tr_guru_tes WHERE id = '" . $uri4 . "'");
$ret_arr['status'] = "ok";
$ret_arr['caption'] = "hapus sukses";
$this->j($ret_arr);
exit;
} else {
if ($uri3 == "jumlah_soal") {
$ambil_data = $this->db->query("SELECT id FROM m_soal WHERE id_mapel = '{$uri4}' AND id_guru = '" . $a['sess_konid'] . "'")->num_rows();
$ret_arr['jumlah'] = $ambil_data;
$this->j($ret_arr);
exit;
} else {
$a['p'] = "m_guru_tes";
}
}
}
}
$this->load->view('aaa', $a);
}
public static function table_update_all($table, $data, $condition, $dbg = 'N')
{
global $url;
$sts = '';
$darimana = $_SERVER['HTTP_REFERER'];
$url = str_replace('http://', '', $url);
$pos = strpos($darimana, $url);
if ($pos !== false) {
list($sqlfield, $stssql) = Db::query("SELECT * FROM {$table}");
$arrfield = array();
$i = Db::num_fields($sqlfield);
for ($j = 0; $j < $i; $j++) {
$fieldname = Db::field_name($sqlfield, $j);
$fieldtype[$fieldname] = Db::field_type($sqlfield, $j);
$fieldtype = array_change_key_case($fieldtype, CASE_LOWER);
array_push($arrfield, strtolower($fieldname));
}
$data = array_change_key_case($data, CASE_LOWER);
$fields = '';
foreach ($data as $field => $value) {
$value = bersih($value);
if (is_int(array_search($field, $arrfield))) {
if ($fieldtype[$field] == 'timestamp') {
if ($value != '') {
$value = chgdate('Y-m-d H:i:s', $value);
$fields = $fields . $field . "='{$value}',";
}
} elseif ($fieldtype[$field] == 'int2' or $fieldtype[$field] == 'int4' or $fieldtype[$field] == 'int8') {
if ($value != '') {
$fields = $fields . $field . "='{$value}',";
}
} else {
if ($value == '') {
$fields = $fields . $field . "=NULL,";
} else {
$fields = $fields . $field . "='{$value}',";
}
}
}
}
$fields = substr($fields, 0, -1);
$sql = "UPDATE {$table} SET {$fields} WHERE {$condition}";
if ($dbg == 'Y') {
echo "<br>DEBUG : " . $sql . "<br>";
}
$sts = Db::query($sql);
if ($sts[1] == 1) {
Db::audit_trail($sql);
}
} else {
$sts = 'Form bukan dari server ini.';
}
return $sts[1];
}
