SMS FORMAT:
INFORMASI KRS
format: NIM#KRS
contoh: 200922436#KRS
INFORMASI KRU
format: NIM#KRU
contoh: 200922436#KRU
INFORMASI AKADEMIK
format: NIM#AKADEMIK
contoh: 200922436#AKADEMIK
query( "INSERT INTO outbox " ."(InsertIntoDB,SendingDateTime,DestinationNumber,TextDecoded,SendingTimeOut,DeliveryReport,CreatorID)" ." VALUES (sysdate(),sysdate(),'".$no."','".$pesan."',sysdate(),'yes','system')" ); return $masuk; } //cek sms masuk $result = $db->query("SELECT ID,TextDecoded,SenderNumber FROM inbox WHERE Processed='false'"); while ($data = $result->fetch_object()) { $keyword = strtoupper($data->TextDecoded); $explode = explode("#",trim($keyword)); $nim = $explode[0]; $code= $explode[1]; $queryhp="SELECT IF(SUBSTR(TRIM(hp),1,1)='0',CONCAT('+62',SUBSTR(TRIM(hp),2)),TRIM(hp)) AS nohp " ."FROM mahasiswa " ."WHERE nim='".$nim."' " ."HAVING nohp='".$data->SenderNumber."'"; if ($cek_hp = $db->query($queryhp)){ if($cek_hp->num_rows>0){ // INFO KRS if($code=='KRS') { $qry="SELECT pesan " ."FROM KRS " ."ORDER BY SendingDateTime DESC LIMIT 1"; if($record_krs = $db->query($qry)) { $hasil = $record_krs->fetch_object(); $pesan =$hasil->pesan."\n"; $masuk = send_sms($db,$data->SenderNumber,$pesan); $record_krs->close(); } else { $pesan = "Info KRS yang Anda minta belum ada"; $masuk = send_sms($db,$data->SenderNumber,$pesan); } } // INFO KRU elseif($code=='KRU') { $qry="SELECT pesan " ."FROM KRU " ."ORDER BY SendingDateTime DESC LIMIT 1"; if ($record_kru = $db->query($qry)) { $hasil = $record_kru->fetch_object(); $pesan =$hasil->pesan."\n"; $masuk = send_sms($db,$data->SenderNumber,$pesan); $record_kru->close(); } else { $pesan = "Info KRU yang Anda minta belum ada"; $masuk = send_sms($db,$data->SenderNumber,$pesan); } } // INFO AKADEMIK elseif($code=='AKADEMIK') { $qry="SELECT pesan " ."FROM AKADEMIK " ."ORDER BY SendingDateTime DESC LIMIT 1"; if ($record_akademik = $db->query($qry)) { $hasil = $record_akademik->fetch_object(); $pesan = $hasil->pesan."\n"; $masuk = send_sms($db,$data->SenderNumber,$pesan); $record_akademik->close(); } else { $pesan = "Info AKADEMIK yang Anda minta belum ada"; $masuk = send_sms($db,$data->SenderNumber,$pesan); } } // INFO BANTUAN elseif($code=="INFO") { $pesan = "format sms, KRS : NIM#KRS , KRU : NIM#KRU , AKADEMIK : NIM#AKADEMIK, Bantuan : NIM#INFO "; $masuk = send_sms($db,$data->SenderNumber,$pesan); } else { $pesan = "Keyword Anda salah/ perintah tidak tersedia"; $masuk = send_sms($db,$data->SenderNumber,$pesan); } }else{ $pesan = "No Anda tidak terdaftar, daftarkan nomor handphone Anda ke bagian Administrator Sistem " ."untuk mendapatkan informasi nilai melalui SMS."; $masuk = send_sms($db,$data->SenderNumber,$pesan); } } if ($masuk) { //pilih mau diubah atau dihapus dari tabel, bila data sudah diproses //$ubah = $db->query("UPDATE inbox SET Processed='true' WHERE ID='".$data->ID."'"); $db->query("DELETE FROM inbox WHERE ID='".$data->ID."'"); } } $db->close(); ?>