Guest User

Untitled

a guest
Oct 9th, 2018
148
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.77 KB | None | 0 0
  1. <?php
  2.  
  3. //$conn = new mysqli( '172.20.60.11', 'thdbuser', 'thdbuser', 'db2' );
  4. //if ( $conn->connect_errno ) {
  5. // die( "Failed to connect to MySQL: (" . $conn->connect_errno . ") " . $conn->connect_error );
  6. //}
  7.  
  8. //db2 express c (v10.5)
  9. $database = "172.20.60.11";
  10. $user = "thdbuser";
  11. $password = "thdbuser";
  12.  
  13. //$conn = db2_connect($database, $user, $password);
  14. $connDB2 = odbc_connect('th03dta','THDBUSER','THDBUSER');
  15.  
  16. if($connDB2) {
  17. echo "DB2 Connection succeeded.<br/>rn";
  18. } else {
  19. exit("failed".db2_conn_errormsg());
  20. }
  21.  
  22. /**************************************/
  23. /***** BEGIN // Declare VARIABLES *****/
  24. /**************************************/
  25. //$gendate = "VARCHAR_FORMAT(CURRENT TIMESTAMP + 5 DAYS, 'YYYYMMDD')";
  26. $gendate = "VARCHAR_FORMAT(CURRENT TIMESTAMP, 'YYYYMMDD')";
  27. //$gendate = '20180718';
  28. $gentime = "04:00:00";
  29. /***** *END* // Declare VARIABLES *****/
  30.  
  31. $fp = fopen('D:DocumentsSMS Blastresult.ahk', 'w');
  32.  
  33. /**********************************************************/
  34. /***** BEGIN // Initial Statement for AutoHotKey File *****/
  35. /**********************************************************/
  36. $initStmt = <<< InitialStatement
  37. #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases.
  38. ; #Warn ; Enable warnings to assist with detecting common errors.
  39. SendMode Input ; Recommended for new scripts due to its superior speed and reliability.
  40. SetWorkingDir %A_ScriptDir% ; Ensures a consistent starting directory.
  41. ; ^L:: run www.bing.com Sleep, 3000 run www.google.com Sleep, 3000 run www.yahoo.com
  42.  
  43.  
  44. InitialStatement;
  45. /***** *END* // Initial Statement for AutoHotKey File *****/
  46.  
  47. // Write Inital Statement in file
  48. fwrite($fp, $initStmt);
  49.  
  50. /**********************************************************/
  51. /***** BEGIN // SQL for Get Total KT and put in Array *****/
  52. /**********************************************************/
  53. // Declare SQL Statement
  54. $bilKT = <<< SQLBilKT
  55. SELECT DISTINCT(LEFT(A.S7KECF,4)) NOKT
  56. --SELECT *
  57. FROM TH03DTA.HJS7REP A
  58. LEFT JOIN TH03DTA.HJKGCPP B ON A.S7KECF = B.KGXHCD
  59. WHERE B.KGAEST = '2'
  60. AND rtrim(CHAR(year(B.KGISDZ-2 days)))||substr(DIGITS(month(B.KGISDZ-2 days)),9)||substr(DIGITS(day(B.KGISDZ-2 days)),9) = $gendate
  61. AND B.KGAUTZ > '$gentime'
  62. SQLBilKT;
  63.  
  64. // debug:
  65. echo $bilKT;
  66.  
  67. //run query
  68. $querybilKT = odbc_exec($connDB2,$bilKT);
  69.  
  70. //set array
  71. $arrayKT = array();
  72.  
  73. // look through query
  74. while($myrow = odbc_fetch_array($querybilKT)){ // <--lots of rows
  75.  
  76. // add each row returned into an array
  77. $arrayKT[] = $myrow;
  78.  
  79. }
  80.  
  81. echo count($arrayKT) ."rn";
  82. // debug:
  83. foreach($arrayKT as $row) {
  84. foreach($row as $key => $arrKTNo) {
  85. // echo $key . ': '. $value . "rn";
  86. echo "". $arrKTNo . "rn";
  87.  
  88.  
  89. /********************************************************/
  90. /***** BEGIN // SQL for Get All the KTs for the day *****/
  91. /********************************************************/
  92. // Declare SQL Statement
  93. $sql = <<< SQLSMSBlast
  94. SELECT THSMS_NoTel, THFlightNo, THSMS_TptLapor, THSMS_LaporDT, THSMS_LaporTime, THSMS_WaktuLapor, THFlightDate
  95. FROM (SELECT trim(A.NOKT) as THFlightNo, trim(A.NO_ACCT) as THSMS_NoAcc, trim(A.NAMA) as THSMS_Nama,
  96. trim(A.TEL_BIMBIT) as THSMS_NoTel, trim(B.KGBPCE) as THSMS_FltNo, trim(B.KGATCD) as THSMS_DepOrigin, trim(B.KGPUCF) as THSMS_DepDest,
  97. -- trim(CHAR(B.KGISDZ, USA)) as THSMS_LaporDT,
  98. trim(REPLACE(CHAR(B.KGISDZ,EUR),'.','/')) as THSMS_LaporDT,
  99. (SELECT CASE TRIM(AND4TW)
  100.  
  101. -- 20180702 KT2363 WHEN 'TH HOTEL KELANA JAYA (KOMPLEKS TABUNG HAJI KELANA JAYA)' THEN 'TH HOTEL KELANA JAYA'
  102. WHEN 'MOVENPICK HOTEL & CONVENTION CENTRE KLIA, KOMPLEKS TH SEPANG' THEN 'MHCC KLIA'
  103. WHEN 'TH HOTEL KOTA KINABALU (KOMPLEKS TABUNG HAJI KOTA KINABALU)' THEN 'TH HOTEL KOTA KINABALU'
  104. WHEN 'TH HOTEL PENANG (KOMPLEKS TABUNG HAJI BAYAN LEPAS)' THEN 'TH HOTEL PENANG'
  105. WHEN 'LAPANGAN TERBANG ANTARABANGSA SENAI' THEN 'LAPANGAN TERBANG SENAI'
  106. WHEN 'TH HOTEL & CONVENTION CENTRE ALOR SETAR' THEN 'TH HOTEL ALOR SETAR'
  107. WHEN 'LAPANGAN TERBANG ANTARABANGSA KUCHING' THEN 'LAPANGAN TERBANG KUCHING'
  108. WHEN 'TH HOTEL & CONVENTION CENTRE, KUALA TERENGGANU' THEN 'TH HOTEL KUALA TERENGGANU'
  109. WHEN 'KOMPLEKS ISLAM JUBLI PERAK SULTAN ISMAIL PETRA, PANJI KOTA BHARU' THEN 'KOMPLEKS ISLAM, PANJI KOTA BHARU'
  110. WHEN 'KLIA, KAUNTER THTS, ARAS 5, BERDEKATAN OLDTOWN WHITE COFFEE,' THEN 'KLIA, KAUNTER THTS, ARAS 5'
  111. ELSE AND4TW END
  112. --SELECT *
  113. FROM TH03DTA.HJANCPP WHERE ANATCD = KGATCD) AS THSMS_TptLapor,
  114. SUBSTR(trim(CHAR(B.KGAUTZ, USA)),1,5) as THSMS_LaporTime,
  115. CASE WHEN (CHAR(B.KGAUTZ) <='11:59:59') THEN 'PAGI'
  116. WHEN(CHAR(B.KGAUTZ) <='12:59:59') THEN 'TENGAHARI'
  117. WHEN(CHAR(B.KGAUTZ) <='18:59:59') THEN 'PETANG' ELSE 'MALAM'
  118. END THSMS_WaktuLapor,
  119. -- trim(CHAR(B.KGITDZ, USA)) as THSMS_DepDate,
  120. trim(REPLACE(CHAR(B.KGITDZ,EUR),'.','/')) as THSMS_DepDate,
  121. SUBSTR(trim(CHAR(B.KGAVTZ, USA)),1,5) as THSMS_DepTime,
  122. CASE WHEN(CHAR(B.KGAVTZ) <='11:59:59') THEN 'PAGI'
  123. WHEN(CHAR(B.KGAVTZ) <='12:59:59') THEN 'TENGAHARI'
  124. WHEN(CHAR(B.KGAVTZ) <='18:59:59') THEN 'PETANG'
  125. ELSE 'MALAM' END as THSMS_WaktuDep,
  126. rtrim(CHAR(year(KGISDZ-2 days)))||substr(DIGITS(month(KGISDZ-2 days)),9)||substr(DIGITS(day(KGISDZ-2 days)),9) as THFlightDate
  127. FROM (SELECT A.S7KECF NOKT, A.S7EECH NO_ACCT, A.S7EFCH NO_DAFTAR, A.S7KFCF NO_PASSPORT, A.S7D2TY NAMA, A.S7MBST JANTINA, A.S7KICF WARGANEGARA, A.S7AWCD JNS_JEMAAH,
  128. A.S7KJCF NO_SIRI,B.JSLWCD ALAMAT1, B.JSLXCD ALAMAT2, B.JSLYCD ALAMAT3, B.JSL2CD ALAMAT4, B.JSJLCD TEL_RUMAH,'6'||B.JSGKCD TEL_BIMBIT
  129. FROM TH03DTA.HJS7REP A -- Manifest
  130. left outer join TH03DTA.HJJSCPP B ON A.S7EECH = B.JSBFCD
  131. AND A.S7EFCH = B.JSWRCD
  132. AND JSIHCE = '01'
  133. WHERE B.JSGKCD != ''
  134. AND S7Q5ST IN ('','0','2') -- Jemaah Confirm
  135. ) A
  136. LEFT JOIN TH03DTA.HJKGCPP B ON A.NOKT = B.KGXHCD
  137. WHERE KGAEST = '2' -- Jenis Penerbangan = DOMESTIK
  138. AND A.NOKT LIKE '$arrKTNo%'
  139. --AND trim(char(year(KGISDZ-2 days)))||substr(digits(month(KGISDZ-2 days)),9)||substr(digits(day(KGISDZ-2 days)),9) = VARCHAR_FORMAT(CURRENT TIMESTAMP, 'YYYYMMDD') --Flight Date
  140. --AND trim(char(year(KGISDZ-2 days)))||substr(digits(month(KGISDZ-2 days)),9)||substr(digits(day(KGISDZ-2 days)),9) = 'gendate' --Flight Date
  141. ) A
  142. ORDER BY THFLIGHTNO, THSMS_NAMA
  143. SQLSMSBlast;
  144.  
  145. // <-- debug:
  146. //echo $sql;
  147.  
  148. $query = odbc_exec($connDB2,$sql);
  149. //echo $query;
  150. //$result = $connDB2->query($query); //dont mind these
  151.  
  152. $sep = "',";
  153. $irow = 0;
  154. $ktno = "";
  155.  
  156.  
  157. // Declare all the Admin Phone Numbers
  158. $ADMIN_TEL = array("6084086", "601922203", "601147090", "601920060", "601964549", "601329092", "60277100", "6318451", "633184250", "643235649", "6017630", "6013386", "6012996");
  159.  
  160. // Get
  161. $arrlength = count($ADMIN_TEL);
  162. /***** *END* Admin Name and Phone Number *****/
  163.  
  164. /**/
  165.  
  166. while(odbc_fetch_row($query)){
  167.  
  168. $THSMS_NOTEL = odbc_result($query,'THSMS_NOTEL');
  169. $THFLIGHTNO = odbc_result($query,'THFLIGHTNO');
  170. $THSMS_TPTLAPOR = odbc_result($query,'THSMS_TPTLAPOR');
  171. $THSMS_LAPORDT = odbc_result($query,'THSMS_LAPORDT');
  172. $THSMS_LAPORTIME = odbc_result($query,'THSMS_LAPORTIME');
  173. $THSMS_WAKTULAPOR = odbc_result($query,'THSMS_WAKTULAPOR');
  174. $THSMS_START = "UrlDownloadToFile, https://www.etracker.cc/bulksms/mesapi.aspx?user=lthbulk&pass=lthbulk9001&type=0&to=$THSMS_NOTEL&from=LTH&text=";
  175. $THSMS_END = "&servid=MES01, createtemp";
  176.  
  177. // FOR ADMIN
  178. if ( $irow == 0 || $ktno <> $THFLIGHTNO ) {
  179. $ktno = $THFLIGHTNO;
  180. for($x = 0; $x < $arrlength; $x++) {
  181. $TXTADMIN_START = "UrlDownloadToFile, https://www.etracker.cc/bulksms/mesapi.aspx?user=lthbulk&pass=lthbulk9001&type=0&to=".$ADMIN_TEL[$x]."&from=LTH&text=";
  182. $adminteks = "INFO HAJI(ADMIN):Tn/Pn dikehendaki lapor diri ". $THFLIGHTNO . " di " . $THSMS_TPTLAPOR . " pada " . $THSMS_LAPORDT . " jam " . $THSMS_LAPORTIME . $THSMS_WAKTULAPOR . ".Jika ada sebarang pertanyaan,sila hubungi 03-62071919.";
  183. $adminteks = str_replace(",","`,",$adminteks);
  184. $adminresult = "Sleep, 2000rn".$TXTADMIN_START.$adminteks.$THSMS_END."rn";
  185. fwrite($fp, $adminresult);
  186. }
  187. }
  188.  
  189. // $result = $THSMS_NOTEL . "$||$" . $THFLIGHTNO . "$||$" . $THSMS_TPTLAPOR . "$||$" . $THSMS_LAPORDT . "$||$" . $THSMS_LAPORTIME . "$||$" . $THSMS_WAKTULAPOR . "rn";
  190. // Sleep, 3000
  191. // run https://www.etracker.cc/bulksms/mesapi.aspx?user=lthbulk&pass=lthbulk9001&type=0&to=.$THSMS_NOTEL.&from=LTH&text=Test.&servid=MES01
  192.  
  193. $teks = "INFO HAJI:Tn/Pn dikehendaki lapor diri ". $THFLIGHTNO . " di " . $THSMS_TPTLAPOR . " pada " . $THSMS_LAPORDT . " jam " . $THSMS_LAPORTIME . $THSMS_WAKTULAPOR . ".Jika ada sebarang pertanyaan,sila hubungi 03-62071919.";
  194. $teks = str_replace(",","`,",$teks);
  195. $result = "Sleep, 2000rn".$THSMS_START.$teks.$THSMS_END."rn";
  196.  
  197. $irow++;
  198.  
  199. fwrite($fp, $result);
  200.  
  201. // $result = mysqli_query($connMYS,$insSql) ;
  202.  
  203. }
  204.  
  205. }
  206. }
  207. /***** *END* // SQL for Get Total KT and put in Array *****/
  208.  
  209. fwrite($fp, "Sleep, 60000rnFileDelete, createtemp");
  210.  
  211. fclose($fp);
  212.  
  213. //$connDB2->close();
  214. odbc_close($connDB2);
  215.  
  216. echo "rnAll result DONE!";
  217.  
  218. //sleep(5);
  219.  
  220. // THSMS_NOTEL
  221. // INFO HAJI:Tn/Pn dikehendaki lapor diri
  222. // --> THFLIGHTNO = KT01B1
  223. // di
  224. // --> THSMS_TPTLAPOR = TH HOTEL & CONVENTION CENTRE ALOR SETAR
  225. // pada
  226. // --> THSMS_LAPORDT = 24/07/2017
  227. // jam
  228. // --> THSMS_LAPORTIME = 01:50
  229. // --> THSMS_WAKTULAPOR = pagi
  230. // . Jika ada sebarang pertanyaan, sila hubungi 03-XXXXXXX.
  231.  
  232. ?>
  233.  
  234. Fatal error: Uncaught Error: Call to undefined function odbc_connect() in C:xampphtdocsconnection.php:14 Stack trace: #0 C:xampphtdocsmainsms.php(2): include() #1 {main} thrown in C:xampphtdocsconnection.php on line 14
Add Comment
Please, Sign In to add comment