setelah sebelumnya saya menuliskan tentang bagaimana cara membuat bot di telegram kemudian membuat program auto reply secara sederhana, Hari ini saya akan mengajarkan tentang bagaimana cara membuat sebuah proyek yang digunakan untuk mengetahui info tagihan listrik menggunakan bot telegram.
Berikut link sebelumnya tentang bot telegram
Membuat bot di telegram
Membuat Autoreply Telegram dengan PHP
Saya asumsikan di sini anda sudah mengikuti tutorial bagian pertama dan bagian kedua tentang Bot telegram. untuk tutorial kali ini saya akan menggunakan script PHP dari artikel sebelumnya. Baiklah kita mulai saja.
1. Siapkan database di hosting anda dengan nama sesuai keinginan anda
2. Jalankan perintah SQL berikut untuk membuat tabel tagihan listrik di database anda
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE `tagihanlistrik` ( | |
| `Id` int(11) NOT NULL, | |
| `idpel` varchar(20) NOT NULL, | |
| `bln` varchar(30) NOT NULL, | |
| `thn` int(5) NOT NULL, | |
| `tagihan` int(11) NOT NULL | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | |
| INSERT INTO `tagihanlistrik` (`Id`, `idpel`, `bln`, `thn`, `tagihan`) VALUES | |
| (1, '100', '10', 2021, 100000); |
3. Silahkan copy paste saja script dibawah ini untuk menggantikan file bot.php yang sebelumnya sudah kita buat
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| define('BOT_TOKEN', 'TOKEN BOT TELEGRAM ANDA'); | |
| define('API_URL', 'https://api.telegram.org/bot'.BOT_TOKEN.'/'); | |
| function apiRequestWebhook($method, $parameters) { | |
| if (!is_string($method)) { | |
| error_log("Method name must be a string\n"); | |
| return false; | |
| } | |
| if (!$parameters) { | |
| $parameters = array(); | |
| } else if (!is_array($parameters)) { | |
| error_log("Parameters must be an array\n"); | |
| return false; | |
| } | |
| $parameters["method"] = $method; | |
| $payload = json_encode($parameters); | |
| header('Content-Type: application/json'); | |
| header('Content-Length: '.strlen($payload)); | |
| echo $payload; | |
| return true; | |
| } | |
| function exec_curl_request($handle) { | |
| $response = curl_exec($handle); | |
| if ($response === false) { | |
| $errno = curl_errno($handle); | |
| $error = curl_error($handle); | |
| error_log("Curl returned error $errno: $error\n"); | |
| curl_close($handle); | |
| return false; | |
| } | |
| $http_code = intval(curl_getinfo($handle, CURLINFO_HTTP_CODE)); | |
| curl_close($handle); | |
| if ($http_code >= 500) { | |
| // do not wat to DDOS server if something goes wrong | |
| sleep(10); | |
| return false; | |
| } else if ($http_code != 200) { | |
| $response = json_decode($response, true); | |
| error_log("Request has failed with error {$response['error_code']}: {$response['description']}\n"); | |
| if ($http_code == 401) { | |
| throw new Exception('Invalid access token provided'); | |
| } | |
| return false; | |
| } else { | |
| $response = json_decode($response, true); | |
| if (isset($response['description'])) { | |
| error_log("Request was successful: {$response['description']}\n"); | |
| } | |
| $response = $response['result']; | |
| } | |
| return $response; | |
| } | |
| function apiRequest($method, $parameters) { | |
| if (!is_string($method)) { | |
| error_log("Method name must be a string\n"); | |
| return false; | |
| } | |
| if (!$parameters) { | |
| $parameters = array(); | |
| } else if (!is_array($parameters)) { | |
| error_log("Parameters must be an array\n"); | |
| return false; | |
| } | |
| foreach ($parameters as $key => &$val) { | |
| // encoding to JSON array parameters, for example reply_markup | |
| if (!is_numeric($val) && !is_string($val)) { | |
| $val = json_encode($val); | |
| } | |
| } | |
| $url = API_URL.$method.'?'.http_build_query($parameters); | |
| $handle = curl_init($url); | |
| curl_setopt($handle, CURLOPT_RETURNTRANSFER, true); | |
| curl_setopt($handle, CURLOPT_CONNECTTIMEOUT, 5); | |
| curl_setopt($handle, CURLOPT_TIMEOUT, 60); | |
| return exec_curl_request($handle); | |
| } | |
| function apiRequestJson($method, $parameters) { | |
| if (!is_string($method)) { | |
| error_log("Method name must be a string\n"); | |
| return false; | |
| } | |
| if (!$parameters) { | |
| $parameters = array(); | |
| } else if (!is_array($parameters)) { | |
| error_log("Parameters must be an array\n"); | |
| return false; | |
| } | |
| $parameters["method"] = $method; | |
| $handle = curl_init(API_URL); | |
| curl_setopt($handle, CURLOPT_RETURNTRANSFER, true); | |
| curl_setopt($handle, CURLOPT_CONNECTTIMEOUT, 5); | |
| curl_setopt($handle, CURLOPT_TIMEOUT, 60); | |
| curl_setopt($handle, CURLOPT_POST, true); | |
| curl_setopt($handle, CURLOPT_POSTFIELDS, json_encode($parameters)); | |
| curl_setopt($handle, CURLOPT_HTTPHEADER, array("Content-Type: application/json")); | |
| return exec_curl_request($handle); | |
| } | |
| function processMessage($message) { | |
| // process incoming message | |
| $message_id = $message['message_id']; | |
| $chat_id = $message['chat']['id']; | |
| if (isset($message['text'])) { | |
| // incoming text message | |
| $text = $message['text']; | |
| $txt=explode(" ",$text); | |
| $user="USER_DATABASE"; | |
| $password="PASS_DATABASE"; | |
| $db="NAMA_DATABASE"; | |
| //sambungkan ke database | |
| $koneksi = mysqli_connect("localhost","$user","$password","$db"); | |
| if (strpos($text, "/start") === 0) { | |
| apiRequest("sendMessage", array('chat_id' => $chat_id, "text" => 'silahkan request tagihan listrik dengan format tagihan IDPEL BULAN TAHUN')); | |
| } | |
| else if ($txt[0] == "tagihan") { | |
| if ($txt[1] == "" or $txt[2] == "" or $txt[3] == "" ) { | |
| apiRequest("sendMessage", array('chat_id' => $chat_id, "text" => 'format request adalah tagihan IDPEL BULAN TAHUN ')); | |
| } | |
| if ($txt[1] <> "" and $txt[2] <> "" and $txt[3] <> "") { | |
| $tag=mysqli_query($koneksi,"select tagihan from tagihanlistrik where idpel='$txt[1]' and bln='$txt[2]' and thn='$txt[3]'"); | |
| $jtag=mysqli_num_rows($tag); | |
| $ttag=mysqli_fetch_array($tag); | |
| function rupiah($angka){ | |
| $hasil_rupiah = "Rp. " . number_format($angka,2,',','.'); | |
| return $hasil_rupiah; | |
| } | |
| $tagih=rupiah("$ttag[tagihan]"); | |
| if($jtag==0) | |
| { | |
| apiRequest("sendMessage", array('chat_id' => $chat_id, "text" => "Tagihan pelanggan dengan Id Pelanggan $txt[1] tidak ada di database kami, pastikan anda memasukkan id pelanggan dengan benar.")); | |
| } | |
| if($jtag<>0) | |
| { | |
| apiRequest("sendMessage", array('chat_id' => $chat_id, "text" => "Tagihan pelanggan dengan Id Pelanggan $txt[1] bulan $txt[2]-$txt[3] adalah $tagih")); | |
| } | |
| } | |
| } | |
| else { | |
| apiRequestWebhook("sendMessage", array('chat_id' => $chat_id, "reply_to_message_id" => $message_id, "text" => 'format request adalah tagihan IDPEL BULAN TAHUN ')); | |
| } | |
| } | |
| } | |
| define('WEBHOOK_URL', 'ALAMAT SCRIPT BOT PHP ANDA'); | |
| if (php_sapi_name() == 'cli') { | |
| // if run from console, set or delete webhook | |
| apiRequest('setWebhook', array('url' => isset($argv[1]) && $argv[1] == 'delete' ? '' : WEBHOOK_URL)); | |
| exit; | |
| } | |
| $content = file_get_contents("php://input"); | |
| $update = json_decode($content, true); | |
| if (!$update) { | |
| // receive wrong update, must not happen | |
| exit; | |
| } | |
| if (isset($update["message"])) { | |
| processMessage($update["message"]); | |
| } |
Silahkan sesuaikan script koneksi ke database sesuai dengan database yang anda miliki pada baris 130 - 132.
Setelah disesuaikan kemudian silahkan mencoba bot telegram dengan mengetikkan teks tagihan IDPEL BULAN TAHUN. tulisan tagihan harus kecil karena sifatya case sensitive. contoh tagihan 100 10 2021 . Jika berhasil maka akan menghasilkan seperti ini :
Komentar