include_once '../cores/definition.php';
include_once '../cores/db.php';
include_once 'gammu-cores.php';
require_once 'gammu-hex.php';
$pengirim = stripslashes(post_var('nopengirim'));
$pno = '+62';
if (substr($pengirim, 0, 3) != '+62' && substr($pengirim, 0, 2) != '08') {
die('ERNomor tidak valid.<br>Nomor harus diawali dengan +628xx... atau 08xx...');
}
if (substr($pengirim, 0, 2) == '08') {
$pengirim = $pno . substr($pengirim, 1);
}
$pesan = addslashes(stripslashes(post_var('pesan')));
$multipart = strlen($pesan) > 160;
$data = 'ERSMS gagal diterima.';
$res = fetch_query('select * from modem_gateway order by id desc limit 0,1');
$modem = $res[0];
$nama_modem = $modem['nama_modem'];
$smsc = $modem['smsc'];
$udh_prefix = '050003' . str_pad(dechex(rand(1, 255)), 2, '0', STR_PAD_LEFT);
unset($modem);
unset($res);
/*
echo 'OK';
echo $udh_prefix.str_pad(dechex(3), 2, '0', STR_PAD_LEFT).str_pad(dechex(1), 2, '0', STR_PAD_LEFT).'<br>';
echo $udh_prefix.str_pad(dechex(3), 2, '0', STR_PAD_LEFT).str_pad(dechex(2), 2, '0', STR_PAD_LEFT).'<br>';
echo $udh_prefix.str_pad(dechex(3), 2, '0', STR_PAD_LEFT).str_pad(dechex(3), 2, '0', STR_PAD_LEFT).'<br>';
*/
if (!$multipart) {
$sms_part = $pesan;
$hex_part = gammu_hex_16bit_safe($sms_part);
<li class="left clearfix">
<span class="chat-img pull-left">
<img class="img-circle" src="img/front-end/sms-data-sent.jpg" width="50" height="50" />
</span>
<div class="chat-body clearfix">
<div class="header">
<i class="fa fa-lightbulb-o fa-2x"></i> <strong class="primary-font">Sementara tidak ada data untuk ditampilkan.</strong>
</div>
<p class="text-muted small">
<span class="label label-info"><i class="fa fa-refresh fa-spin"></i> Menunggu data...</span>
</p>
</div>
</li>
<?php
} else {
$smses = fetch_query($sql);
$i = 0;
foreach ($smses as $sms) {
$i++;
?>
<li class="left clearfix" id="sms-<?php
echo $sms['id'];
?>
">
<span class="chat-img pull-left">
<!--
<i class="fa fa-envelope-o fa-fw fa-2x"></i>
-->
<!--
<?php
} else {
?>
<thead>
<tr>
<th>Tanggal Pengembalian</th>
<th>Kode Pinjam</th>
<th>Bayi</th>
<th>Kondisi Bayi</th>
<th>Jenis Inkubator</th>
<th>Detail</th>
</tr>
</thead>
<tbody>
<?php
$p_data = fetch_query($sql);
$i = 0;
// pre($p_data);
foreach ($p_data as $data) {
$i++;
// if (($i % 2) == 0) {$rclas='info';}else{$rclas='';}
$rclas = $data['status_kembali'] == 'Ditunda' ? 'warning' : ($data['status_kembali'] == 'Ditolak' ? 'danger' : 'success');
?>
<tr class="text-<?php
echo $rclas;
?>
" style="font-weight: bold;">
<td><?php
echo date('d/m/Y', strtotime($data['tgl_kembali']));
?>
/**
* Define your hook for specific SMS keyword.
* Return true to mark SMS as processed and
* will be passed on next processing.
* Return false will cause the SMS to be
* reprocessed infinitely until you return true.
*/
function my_hook_pinjam_function($keyword, $params)
{
global $app_name, $app_version, $nama_modem;
global $my_pinjam_sms_format, $my_pinjam_sms_sample;
// Sometime, you don't need to reply SMS from non-user number,
// such as SMS from Service Center, message center,
// or promotional SMS:
$valid_param_count = 16;
// pre( $params);
// return true;
if (strlen($params['sender']) <= 6) {
return true;
} else {
if (count($params['params']) != $valid_param_count) {
sms_send($params['sender'], '1/2. SMS tidak valid. Jumlah parameter data harus ' . $valid_param_count . '.', $nama_modem);
sms_send($params['sender'], '2/2. Format SMS: ' . $my_pinjam_sms_format, $nama_modem);
sms_send($params['sender'], '3/2. Contoh SMS: ' . $my_pinjam_sms_sample, $nama_modem);
} else {
// dapatkan ID dan KODE peminjaman:
$sql_pinjam = "select (@idx:=UUID_SHORT()) id, /*hex(@idx) kode, */ concat(left(hex(@idx),6),'-',substr(hex(@idx),7,6),'-',right(hex(@idx),2)) kode limit 0,1";
// pre( $params);
fetch_query($sql_pinjam);
$meta_pinjam = fetch_query($sql_pinjam);
$id_pinjam = $meta_pinjam[0]['id'];
$kode_pinjam = $meta_pinjam[0]['kode'];
// proses SMS dan insert ke table `inkubator_pinjam`:
// Format: PINJAM*NAMA_BAYI*TGL_LAHIR*TGL_PULANG_RS*CM_PJGLAHIR*KG_BERATLAHIR*<SEHAT/SAKIT>*NAMA_RS*NM_DOKTER/BIDAN*NO_KK*ALAMAT*NAMA_IBU*NAMA_AYAH
// Sample: PINJAM*DIAN KHAMSAWARNI*21/09/2015*23/09/2015*28*3,2*SEHAT*RSU Wahidin*Dr. Marhamah, Sp.OG*9288299288*BTN Hamzy E8/A*RINA MAWARNI*ARIFIN ADINEGORO
$p_nama_bayi = trim($params['params'][1]);
$p_kelamin = strtolower(trim($params['params'][2]));
$p_tgl_lahir = trim($params['params'][3]);
$p_tgl_pulang = trim($params['params'][4]);
$p_pjg_lahir = trim($params['params'][5]);
$p_berat_lahir = trim($params['params'][6]);
$p_kondisi = strtoupper(trim($params['params'][7]));
$p_rumah_sakit = trim($params['params'][8]);
$p_dokter = trim($params['params'][9]);
$p_no_kk = trim($params['params'][10]);
$p_alamat = trim($params['params'][11]);
$p_nama_ibu = trim($params['params'][12]);
$p_ktp_ibu = trim($params['params'][13]);
$p_nama_ayah = trim($params['params'][14]);
$p_ktp_ayah = trim($params['params'][15]);
// cek tangal, panjang dan berat apakah formatnya sesuai atau tidak.
$p_validate_tgl = '/^[0-9]{2}\\/[0-9]{2}\\/[0-9]{4}$/';
// dd/mm/yyyy
$p_validate_pjg = '/^[0-9]{1,2}+([\\,\\.][0-9]{1,2})?$/';
// max2digits[.,]max2digits
if ($p_kelamin != 'laki-laki' && $p_kelamin != 'perempuan') {
sms_send($params['sender'], 'Maaf. Jenis Kelamin harus LAKI-LAKI atau PEREMPUAN.', $nama_modem);
} else {
if (!preg_match($p_validate_tgl, $p_tgl_lahir)) {
sms_send($params['sender'], 'Maaf. Tgl lahir salah format. Harus berformat dd/mm/yyyy.', $nama_modem);
} else {
if (!preg_match($p_validate_tgl, $p_tgl_pulang)) {
sms_send($params['sender'], 'Maaf. Tgl pulang dari RS salah format. Harus berformat dd/mm/yyyy.', $nama_modem);
} else {
if (!preg_match($p_validate_pjg, $p_pjg_lahir)) {
sms_send($params['sender'], 'Maaf. Panjang bayi saat lahir salah. Contoh panjang bayi: 29', $nama_modem);
} else {
if (!preg_match($p_validate_pjg, $p_berat_lahir)) {
sms_send($params['sender'], 'Maaf. Berat bayi saat lahir salah. Contoh berat bayi: 2,69', $nama_modem);
} else {
if ($p_kondisi != 'SEHAT' && $p_kondisi != 'SAKIT') {
sms_send($params['sender'], 'Maaf. Kondisi bayi salah. Harus SEHAT atau SAKIT.', $nama_modem);
} else {
if (strlen($p_ktp_ibu) != 16) {
sms_send($params['sender'], 'Maaf. Nomor KTP ibu harus 16 angka.', $nama_modem);
} else {
if (strlen($p_ktp_ayah) != 16) {
sms_send($params['sender'], 'Maaf. Nomor KTP ayah harus 16 angka.', $nama_modem);
} else {
// process tgl, berat & panjang:
// xx/yy/xxxx
// $x = fopen('d:/testjk.txt','w'); fwrite($x, $p_kelamin); fclose($x);
if ($p_kelamin == 'laki-laki') {
$p_kelamin = 'Laki-Laki';
} else {
$p_kelamin = 'Perempuan';
}
$p_skor = $p_kondisi == 'SEHAT' ? 1 : 0;
$p_tgl_lahir = substr($p_tgl_lahir, 6, 4) . '-' . substr($p_tgl_lahir, 3, 2) . '-' . substr($p_tgl_lahir, 0, 2);
$p_tgl_pulang = substr($p_tgl_pulang, 6, 4) . '-' . substr($p_tgl_pulang, 3, 2) . '-' . substr($p_tgl_pulang, 0, 2);
$p_berat_lahir = str_replace(',', '.', $p_berat_lahir);
$p_pjg_lahir = str_replace(',', '.', $p_pjg_lahir);
// all set! save it to database.
$save_sql = "insert into inkubator_pinjam (\n id, kode_pinjam, id_inkubator, tgl_pinjam, nama_bayi, kembar, tgl_lahir, berat_lahir, panjang_lahir, \n kondisi, rumah_sakit, nama_dokter, tgl_pulang, no_kk, alamat, \n nama_ibu, hp_ibu, email_ibu,\n nama_ayah, hp_ayah, email_ayah,\n jumlah_pinjam, keterangan_status_pinjam, konfirmasi, ktp_ibu, ktp_ayah, jenis_kelamin \n ) values (\n {$id_pinjam}, '{$kode_pinjam}', 0, CURRENT_TIMESTAMP(), '{$p_nama_bayi}', 'N', '{$p_tgl_lahir}', {$p_berat_lahir}, {$p_pjg_lahir}, \n '{$p_kondisi}', '{$p_rumah_sakit}','{$p_dokter}', '{$p_tgl_pulang}', '{$p_no_kk}', '{$p_alamat}', \n '{$p_nama_ibu}', '" . $params['sender'] . "', '',\n '{$p_nama_ayah}', '" . $params['sender'] . "', '',\n 1, 'Ditunda untuk review.', 'Y', '" . $p_ktp_ibu . "', '" . $p_ktp_ayah . "','{$p_kelamin}'\n )";
$sub_mon_sql = "insert into inkubator_monitoring \n (id, kode_pinjam, tgl_input, panjang_bayi, berat_bayi, kondisi, skor, keterangan)\n \t values\n ( UUID_SHORT(), '{$kode_pinjam}', CURRENT_TIMESTAMP(), {$p_pjg_lahir}, {$p_berat_lahir}, '{$p_kondisi}', {$p_skor}, 'Status awal {$p_nama_bayi}')";
// $f = fopen('d:/test-.txt','w');
/* Debug:
fputs($f, $save_sql);
fputs($f, $sub_mon_sql);
fclose($f);
*/
if (exec_query($save_sql)) {
// reply SMS:
if (exec_query($sub_mon_sql)) {
sms_send($params['sender'], 'Peminjaman sedang diproses. Kode Pinjam: ' . $kode_pinjam, $nama_modem);
} else {
exec_query("delete from inkubator_pinjam where id = {$id_pinjam}");
sms_send($params['sender'], 'Maaf, server sedang sibuk. Cobalah beberapa saat lagi.', $nama_modem);
}
} else {
sms_send($params['sender'], 'Maaf, server sedang sibuk. Cobalah beberapa saat lagi.', $nama_modem);
}
}
}
}
}
}
}
}
}
}
return true;
}
}
$prefix = isset($_POST['prefix']) ? $_POST['prefix'] : '';
if ($sql == null) {
echo 'ERROR';
} else {
$un = $_SESSION['user_name'];
$query = decrypt($sql, $un);
// echo $query;
if (!(substr($query, 0, strlen($prefix)) == $prefix)) {
echo 'ERROR. Wrong encryption key.';
} else {
$query = substr($query, strlen($prefix));
switch (substr(strtolower($query), 0, 4)) {
case 'sele':
case 'show':
case 'desc':
$r = fetch_query($query, true);
$ra = json_decode($r);
if (count($ra) == 0) {
echo 'ERROR';
} else {
header('Content-Type: application/json');
echo $r;
}
unset($ra);
unset($r);
break;
default:
if (exec_query($query)) {
echo 'OK';
} else {
echo 'ERROR';
$keyword_file = str_replace("\\", "/", dirname(dirname(__FILE__))) . '/sms-daemon-hooks/' . basename($keyword['file_name']);
// fputs($f, $keyword_file ."\n");
if (file_exists($keyword_file)) {
include_once $keyword_file;
// fputs($f, $keyword_file ."\n");
}
}
// fclose($f);
$data_count_to_process = get_system_config('sms_to_process_per_minute', 10);
// execute 10 data every minute - as this task run
$nama_modem = fetch_one_value("select coalesce((select nama_modem from modem_gateway order by id desc limit 0,1),'')");
$last_id = fetch_one_value("select coalesce((select config_value from configs where config_name = '" . LAST_ID_CONFIG_NAME . "'),0)");
// create keyword state cache:
$keyword_states = keyword_fetch_states_from_db();
$sms_query = "select sv.id from sms_valid sv where sv.id > {$last_id} and sv.diproses = 'Ditunda' \n order by sv.waktu_terima asc, sv.id asc limit 0, {$data_count_to_process}";
$smses = fetch_query($sms_query);
$last_processed_id = $last_id;
$all_ok = true;
$cnt = 0;
if (count($smses) == 0) {
// No new message to process
exit('No new message to process');
} else {
echo 'Processing ' . count($smses) . ' SMS(es) : ';
foreach ($smses as $sms) {
$last_processed_id = $sms['id'];
$sms_item = sms_fetch_item($last_processed_id);
$sms_keyword = strtoupper($sms_item['params'][0]);
foreach ($_SMS_PROCESSOR_DAEMON_HOOKS as $keyword) {
if ($sms_keyword == strtoupper($keyword['keyword'])) {
/*
</tr>
<tr>
<th>Tanggal</th>
<th>Keterangan</th>
<th>Berat Bayi</th>
<th>Panjang Bayi</th>
<th>Kondisi</th>
<th>Tindakan</th>
</tr>
</thead>
<tbody>
<!-- Data Monitoring di sini -->
<?php
$kd_pinjam = $pinjam['kode_pinjam'];
$sql_mon = "select * from inkubator_monitoring where kode_pinjam = '{$kd_pinjam}' \n order by tgl_input asc, id asc";
$data_mon = fetch_query($sql_mon);
foreach ($data_mon as $mon) {
$kon = $mon['kondisi'];
$kon_data = '<span class="label label-' . (strtolower($kon) == 'sehat' ? 'success' : 'warning') . '">' . $kon . '</span>';
$st = substr(strtolower($mon['keterangan']), 0, 12);
$awal_dan_akhir = $st == 'status awal ' || $st == 'status akhir';
?>
<tr id="mon-id-<?php
echo $mon['id'];
?>
" data-tanggal="<?php
echo date('d/m/Y', strtotime($mon['tgl_input']));
?>
">
<td><?php
echo date('d/m/Y', strtotime($mon['tgl_input']));
/* Required files */
include_once 'definition.php';
include_once 'db.php';
$uid = isset($_POST['username']) ? $_POST['username'] : '';
$pwd = isset($_POST['password']) ? $_POST['password'] : '';
$str = '';
if (empty($uid)) {
$str .= 'Username kosong. ';
}
if (empty($pwd)) {
$str .= 'Password kosong. ';
}
if (!empty($str)) {
echo $str;
} else {
$users = fetch_query("select * from vw_user_login where user_name = '{$uid}' and user_password = md5('{$pwd}')");
if (count($users) > 0) {
//set session vars:
$_SESSION['user_sess'] = 1;
$_SESSION['user_id'] = $users[0]['id'];
$_SESSION['user_name'] = $users[0]['user_name'];
$_SESSION['user_email'] = $users[0]['email'];
$_SESSION['user_first_name'] = $users[0]['first_name'];
$_SESSION['user_last_name'] = $users[0]['last_name'];
$_SESSION['user_group_id'] = $users[0]['group_id'];
$_SESSION['user_group_name'] = $users[0]['group_name'];
$_SESSION['user_image_path'] = 'img/user-avatar/' . $users[0]['image_path'];
echo 'OK';
} else {
echo 'Kombinasi Username dan/atau Password tidak cocok.';
}
<div id="page-wrapper">
<div class="row">
<div class="col-lg-12">
<h1 class="page-header"><?php
echo $page_name;
?>
</h1>
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
<!-- Fetch Data count: -->
<?php
$qry = fetch_query("select \n \t(select sum(stok_inkubator) from vw_inkubator_tersedia) as inkubator_count, \t\n (select count(*) from vw_inkubator_pinjam) as bayi_count,\n \t(select count(*) from vw_inkubator_pinjam where coalesce(status_kembali,'Ditunda') = 'Ditunda' and status_pinjam = 'Disetujui') as pinjam_count, \t\n \t(select count(*) from vw_inkubator_perkembangan where perkembangan = 'Positif') as bayi_sehat_count", false);
$badge_data = $qry[0];
?>
<div class="row">
<div class="col-lg-3 col-md-6">
<div class="panel panel-primary">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class="fa fa-home fa-5x"></i>
</div>
<div class="col-xs-9 text-right">
<div class="huge"><?php
echo $badge_data['inkubator_count'];
?>
</div>
echo $post['excerpt'];
?>
<a class="pull-right" href="posts.php?id=<?php
echo $post['id'];
?>
" title="<?php
echo $post['title'];
?>
"><i class="fa fa-chevron-right"></i></a>
</div>
</div>
</div>
<div class="row">
<div class="col-md-10">
<?php
$p = fetch_query("select id, title, excerpt from frontend_posts where flag = 'tos'");
$post = $p[0];
unset($p);
?>
<div class="alert alert-warning">
<h3 class="panel-title"><strong><?php
echo $post['title'];
?>
</strong></h3>
<?php
echo $post['excerpt'];
?>
<a class="pull-right" href="posts.php?id=<?php
echo $post['id'];
?>
" title="<?php
echo '<option value="' . $modes[$i]['mode'] . '" ' . ($modes[$i]['mode'] == $m ? 'selected=""' : '') . '>' . $modes[$i]['mode'] . '</option>';
}
}
unset($modes);
?>
</select>
<br>
</div>
</div>
<div class="row">
<div class="col-md-12">
<label>Baudrate (Speed) Modem:</label>
<select class="form-control" id="baudrate" name="baudrate">
<?php
$modes = fetch_query('select * from modem_baudrates order by baudrate asc');
$m = modem_value('baudrate');
foreach ($modes as $i => $mode) {
if ($m == '') {
echo '<option value="' . $modes[$i]['baudrate'] . '" ' . ($modes[$i]['default'] == 'Y' ? 'selected=""' : '') . '>' . $modes[$i]['baudrate'] . '</option>';
} else {
echo '<option value="' . $modes[$i]['baudrate'] . '" ' . ($modes[$i]['baudrate'] == $m ? 'selected=""' : '') . '>' . $modes[$i]['baudrate'] . '</option>';
}
}
unset($modes);
?>
</select>
<br>
</div>
</div>
<tbody>
<?php
$prm_grup = "";
switch ($grup) {
case 'telah kembali':
$prm_grup = " and (coalesce(k.status_kembali,'') = 'Diterima') ";
break;
case 'belum kembali':
$prm_grup = " and (coalesce(k.status_kembali,'') <> 'Diterima') ";
break;
default:
$prm_grup = "";
}
$prm_grup = "select p.*, k.tgl_kembali, k.status_kembali,\n (select avg(skor) from inkubator_monitoring where kode_pinjam = p.kode_pinjam) as kond\n from inkubator_pinjam p\n left join inkubator_kembali k on p.kode_pinjam = k.kode_pinjam " . " where (p.status_pinjam = 'Disetujui') " . ($id_inkubator == 0 ? "" : " and p.id_inkubator = '" . $id_inkubator . "'") . $prm_grup . " order by p.tgl_pinjam asc, p.id asc";
// pre($prm_grup);
$pinjams = fetch_query($prm_grup);
$c = count($pinjams);
if ($c == 0) {
?>
<tr>
<td colspan="6" class="warning">Belum ada data peminjaman.</th>
</tr>
<?php
} else {
foreach ($pinjams as $pinjam) {
$pclass = $pinjam['status_pinjam'] == 'Ditunda' ? 'warning' : ($pinjam['status_pinjam'] == 'Ditolak' ? 'danger' : 'success');
$kclass = $pinjam['status_kembali'] == 'Ditunda' ? 'warning' : ($pinjam['status_kembali'] == 'Ditolak' ? 'danger' : 'success');
?>
<tr id="kp-<?php
echo $pinjam['kode_pinjam'];
<?php
#####################################################################################################
/*
exec:~filth|30|7200|0|1|||||php scripts/filth.php %%trailing%% %%dest%% %%nick%%
*/
#####################################################################################################
#return;
require_once "lib.php";
require_once "lib_mysql.php";
$trailing = trim($argv[1]);
$dest = $argv[2];
$nick = $argv[3];
if ($trailing == "") {
$records = fetch_query("SELECT * FROM exec_irc_bot.irc_log WHERE ((destination='#') AND (nick!='irc.sylnt.us') AND (server='irc.sylnt.us') AND (nick!='exec') AND (cmd='PRIVMSG') AND (`trailing` not like '%--%') AND (`trailing` not like '%++%') AND (`trailing` not like '%karma%') AND (`trailing` not like '^%') AND (`trailing` not like '=%') AND (`trailing` not like '!%') AND (`trailing` not like '\$%') AND (`trailing` not like '~%') AND (`trailing` not like 'ACTION%')) ORDER BY id");
$i = count($records);
if ($i == 0) {
return;
}
do {
$i--;
$last = trim($records[$i]["trailing"]);
$last_parts = explode(" ", $last);
} while (count($last_parts) < 4);
$k = mt_rand(1, count($last_parts) - 1);
$i = 0;
$replacements = array();
while ($i <= $k) {
$n = mt_rand(0, count($records) - 2);
$msg = trim(filter($records[$n]["trailing"], VALID_UPPERCASE . VALID_LOWERCASE . VALID_NUMERIC . " "));
$msg_parts = explode(" ", $msg);
</div>
</div>
</div>
<!-- /form-add-inkubator -->
<div class="panel panel-green">
<div class="panel-body">
<div class="row">
<div class="col col-md-12">
Klik salah satu inkubator untuk melihat data peminjam.
</div>
</div>
</div>
</div>
<div class="list-group">
<?php
$inkubators = fetch_query("select it.*,\n i.img_path,\n count(p.id) jumlah_dipinjam,\n (select count(*) from inkubator_pinjam where id_inkubator = i.id) as jumlah_pernah_pinjam\n from vw_inkubator_tersedia it \n inner join inkubator_master i on i.id = it.id\n left join vw_inkubator_pinjam p on p.id_inkubator = it.id and coalesce(p.status_kembali,'Ditunda') = 'Ditunda'\n \n group by (it.id)\n order by it.id asc");
foreach ($inkubators as $inkubator) {
$spec = $inkubator['panjang'] . 'cm x ' . $inkubator['lebar'] . 'cm x ' . $inkubator['tinggi'] . 'cm x ' . $inkubator['berat'] . 'kg.';
?>
<div class="list-group-item" id="inkubator-<?php
echo $inkubator['id'];
?>
" style="height: 120px;">
<div class="row">
<div class="col-lg-2">
<a href="inkubator-data-peminjam.php?id=<?php
echo $inkubator['id'];
?>
">
<img src="<?php
</div>
</div>
</div>
<div class="panel-footer">
<div class="row">
<div class="col-md-12">
<h5><?php
echo $post['comment_count'];
?>
komentar sejauh ini.</h5>
<hr />
</div>
</div>
<?php
$comments = fetch_query("select id, pub_date, nama, email, url, content \n from frontend_comments where comment_to_table = 'frontend_posts'\n and comment_to_id = '{$post_id}' order by pub_date asc, id asc");
foreach ($comments as $no => $comment) {
?>
<div class="row">
<div class="col-md-12">
<label>
<i class="fa fa-user"></i>
<?php
if (!empty($comment['url'])) {
echo '<a href="' . $comment['url'] . '" title="' . $comment['nama'] . '" target="_blank">';
echo $comment['nama'];
echo '</a>';
} else {
echo $comment['nama'];
}
?>
break;
case 'changestate':
$req_id = post_var('reqid');
$req_state = post_var('reqstate');
try {
exec_query("update sms_keywords set active = (case when active='Y' then 'N' else 'Y' end) where id = '{$req_id}';");
$state = fetch_one_value("select upper(active) from sms_keywords where id = '{$req_id}'");
echo 'OK' . ($state == 'Y' ? 'active' : 'disabled');
} catch (Exception $e) {
echo 'ER' . $req_state;
}
break;
case 'dropkeyword':
$req_id = post_var('reqid');
try {
$kw_data = fetch_query("select keyword, function_name, file_name from sms_keywords where id = '{$req_id}'");
/*
$kw_file = fetch_one_value("select file_name from sms_keywords where id = '$req_id'");
$kw_keyword = fetch_one_value("select keyword from sms_keywords where id = '$req_id'");
*/
$kw_keyword = $kw_data[0]['keyword'];
$kw_function = $kw_data[0]['function_name'];
$kw_file = $kw_data[0]['file_name'];
$kw_file = str_replace("\\", "/", realpath('../sms-daemon-hooks')) . '/' . basename($kw_file);
unset($kw_data);
if (file_exists($kw_file)) {
unlink($kw_file);
}
// panassa'i / ensure / pastikan:
$res = keyword_hook_unregister($kw_keyword, $kw_function);
if ($res == ERROR_KEYWORD_NOT_REGISTERED || $res == ERROR_KEYWORD_SUCCESS) {
/**
* Define your hook for specific SMS keyword.
* Return true to mark SMS as processed and
* will be passed on next processing.
* Return false will cause the SMS to be
* reprocessed infinitely until you return true.
*/
function my_hook_info_function($keyword, $params)
{
global $app_name, $app_version, $nama_modem;
global $my_info_kategori, $my_info_keyword;
// Sometime, you don't need to reply SMS from non-user number,
// such as SMS from Service Center, message center,
// or promotional SMS:
$param = $params['params'];
if (strlen($params['sender']) <= 6) {
return true;
} else {
// If the SMS requires reply, do it as follows:
/*
* return sms_send($params['sender'],
* 'Thank your for texting us.',
* $nama_modem);
*/
// or simply return true without replying it:
/*
* return true;
*/
$c = count($param);
$sql_kunci = "select k.keyword from sms_keywords k where (not (upper(k.keyword) in ('UNKNOWN',upper('{$my_info_keyword}')) ))\n and (k.kategori in (select s.kategori from sms_keywords s where s.keyword = '{$my_info_keyword}')) order by k.keyword asc";
if ($c != 2) {
$pesan1 = 'Terimakasih. Ketik ' . strtoupper($my_info_keyword) . DELIMITER . 'KATAKUNCI untuk bantuan.';
$kunci = fetch_query($sql_kunci);
$pesan2 = '';
foreach ($kunci as $i => $item) {
$pesan2 .= ',' . $item['keyword'];
}
$pesan2 = 'Format Kata Kunci yang Tersedia: ' . substr($pesan2, 1);
unset($kunci);
} else {
$info_kw = strtoupper($param[1]);
$kirim = keyword_fetch_by_keyword($info_kw);
// $kirim = fetch_query("select format_sms, contoh_sms from sms_keywords where upper(keyword) = upper('$info_kw')" );
if (count($kirim) == 0) {
$pesan1 = 'Kata kunci ' . strtoupper($info_kw) . ' tidak ditemukan. Ketik ' . strtoupper($my_info_keyword) . ' untuk bantuan.';
$kunci = fetch_query($sql_kunci);
$pesan2 = '';
foreach ($kunci as $i => $item) {
$pesan2 .= ',' . $item['keyword'];
}
$pesan2 = 'Format Kata Kunci yang Tersedia: ' . substr($pesan2, 1);
unset($kunci);
} else {
$pesan1 = 'Format SMS: ' . $kirim['sms_format'];
$pesan2 = 'Contoh SMS: ' . $kirim['sms_sample'];
}
unset($kirim);
}
$ok1 = sms_send($params['sender'], $pesan1, $nama_modem);
$ok2 = true;
if (!empty($pesan2)) {
$ok2 = sms_send($params['sender'], $pesan2, $nama_modem);
}
return $ok1 && $ok2;
}
}
function drop_user_tables($exceptions = array())
{
$tables = fetch_query('show tables');
$tabs = array_values($tables);
$ok = true;
foreach ($tabs as $table) {
$v = array_values($table);
$table = $v[0];
if (substr($table, 0, strlen(USER_TABLE_PREFIX)) == USER_TABLE_PREFIX) {
// $av[] = $table;
$ok &= exec_query("drop table if exists `" . $v[0] . "`;");
}
}
// var_dump($av);
return $ok;
}
?>
</span>
</div>
</div>
<div class="row"><div class="col-md-12"><label>Detail Peminjaman</label></div></div>
<div class="row">
<div class="col-md-3 text-muted">Jenis Inkubator</div><div class="col-md-9">
<?php
if ($data['id_inkubator'] == 0) {
?>
<div class="form-group">
<select class="form-control small" id="ajax-pinjam-detail-inkubator">
<option value="" selected="">Belum Ditentukan</option>
<?php
$i_sql = "select \n \tit.id,\n \tit.nama,\n \tconcat(\n it.panjang,'cm x ',\n \t\tit.lebar,'cm x ',\n \t\tit.tinggi,'cm x ',\n \t\tit.berat,'kg',\n ', Stok: ', (it.jumlah - coalesce(p.jumlah_pinjam,0)),\n \t\tcoalesce(concat(', ',it.tipe),'') \t\n ) as spec\n from inkubator_master it \n left join inkubator_pinjam p on p.id_inkubator = it.id \n \t left join inkubator_kembali k on k.kode_pinjam = p.kode_pinjam and coalesce(k.status_kembali,'Ditunda') = 'Ditunda'\n group by (it.id)\n order by it.id asc";
$inks = fetch_query($i_sql);
foreach ($inks as $i => $ink) {
echo '<option value="' . $ink['id'] . '">' . $ink['nama'] . ' - ' . $ink['spec'] . '</option>';
}
unset($inks);
?>
</select>
</div>
<?php
} else {
$i_sql = "select concat(it.nama,' - ', \n concat(it.panjang,'cm P x ',\n \t\tit.lebar,'cm L x ',\n \t\tit.tinggi,'cm T x ',\n \t\tit.berat,'kg',\n \t\tcoalesce(concat(', ',it.tipe),'')\n \t)) as spec \t\n from inkubator_master it \n left join inkubator_pinjam p on p.id_inkubator = it.id \n \t left join inkubator_kembali k on k.kode_pinjam = p.kode_pinjam and coalesce(k.status_kembali,'Ditunda') = 'Ditunda'\n \twhere it.id = " . $data['id_inkubator'] . "";
$ink = fetch_one_value($i_sql);
echo "<small>{$ink}</small>";
}
?>
$action = strtolower($parts[0]);
array_shift($parts);
$trailing = trim(implode(" ", $parts));
switch ($action) {
case "count":
$records = fetch_query("SELECT COUNT(*) FROM " . BOT_SCHEMA . "." . LOG_TABLE);
privmsg($records[0]["COUNT(*)"]);
break;
case "last":
$params = array("destination" => $dest);
$records = fetch_prepare("SELECT * FROM " . BOT_SCHEMA . "." . LOG_TABLE . " WHERE ((cmd='PRIVMSG') and (destination=:destination)) ORDER BY id DESC LIMIT 1", $params);
privmsg($records[0]["data"]);
break;
case "query":
# ~sql query select comment_body from exec_irc_bot.sn_comments where (comment_body like '%fart%') order by rand() limit 1
$records = fetch_query($trailing);
$error = get_last_error();
if ($error != "") {
privmsg($error);
return;
}
for ($i = 0; $i < min(3, count($records)); $i++) {
if (is_array($records[$i]) == True) {
privmsg(implode("|", $records[$i]));
} else {
privmsg($records[$i]);
}
}
break;
}
#####################################################################################################
