Kedatangan & Penempatan JHI di Madinah 5 - Gel 2 - by Hotel

update code srk arrival cekin jhi petugas tot qty majmuah hotel catering cekout menu
bus bus_no d # in p1 p2 p3 tim sek no name contract pax s5 man pr lan code name d out bus no tim code
07-22 18:24 SUB57 BTG BARAKAH 1-10 1 3 26-06-07 16:00 376 1 1 2 380 378 SADU 1 5 512 DIYAR AL HABIB 66362 380 1 378 203 130 SAT Safwat Abrar Taybah 1 26-06-15 21 BARAKAH 1 SAT cd ed chld
07-22 18:24 KJT22 RKN RAWAF 1-11 2 5 26-06-08 16:00 441 1 1 2 445 444 ABRAJ HUSSAM 2 5 515 DIWAN AL HIJRA 81185 445 1 444 243 182 MZM MEIZ MARY KITCHEN 2 26-06-16 18 RAWAF 2 MZM cd ed chld
07-22 18:24 SOC47 RKN ABU SARHAD 1 2 10 26-06-08 17:00 356 1 1 2 360 358 ABRAJ SAADAH 3 5 505 HUDA TAIBAH 71891 50 1 50 28 3 AND Al Andalus Company 2 26-06-16 22 ABU SARHAD 3 AND cd ed chld
07-22 18:24 SOC47 RKN ABU SARHAD 2-9 2 10 26-06-08 17:00 356 1 1 2 360 358 RUA TAIBAH 4 5 506 MANAR ALEIMAN 81205 305 1 308 167 76 SAS Safwat Al Salam 2 26-06-16 22 ABU SARHAD 4 SAS cd ed chld
07-22 18:24 SOC47 RKN ABU SARHAD 2 10 26-06-08 17:00 356 1 1 2 360 358 RUA TAIBAH 0 4 407 JAWHARAT ALRASHEED 114335 5 0 0 0 0 TWB Twabel 2 26-06-16 22 ABU SARHAD 0 TWB cd ed chld
07-22 18:24 JKG19 BTG SAPTCO 1-11 2 16 26-06-08 21:00 441 1 1 2 445 441 SADU 5 5 504 BARA TAIBA 64256 445 1 441 233 230 HDR Al Haideri Catering 3 26-06-17 00 SAPTCO 5 HDR cd ed chld
07-22 18:24 SOC48 RKN ABU SARHAD 1-9 2 18 26-06-08 21:00 356 1 1 2 360 359 ABRAJ SAADAH 1 5 505 HUDA TAIBAH 71739 360 1 359 200 157 NOH Nooha Catering 3 26-06-17 07 ABU SARHAD 1 NOH cd ed chld
07-22 18:24 BTJ3 RKN MAWAKEB 7-10 2 19 26-06-08 23:00 389 1 1 2 393 392 ABRAJ SAADAH 2 5 505 HUDA TAIBAH 71735 141 1 139 82 58 NOH Nooha Catering 3 26-06-17 06 MAWAKEB 2 NOH cd ed chld
07-22 18:24 BTJ3 RKN MAWAKEB 1-6 2 19 26-06-08 23:00 389 1 1 2 393 392 SADU 0 4 422 DIYAR AL MADINA 79297 252 0 253 153 130 URC United Regional 3 26-06-17 06 MAWAKEB 0 URC cd ed chld
07-22 18:24 YIA13 BTG RABITAT 1-9 3 8 26-06-09 17:00 356 1 1 2 360 359 ARJUWAN 3 5 514 MIRAGE TAIBA 64258 360 1 357 167 196 RMK Ramak Al Dyafa 4 26-06-18 02 RABITAT 3 RMK cd ed chld
07-22 18:24 JKG20 BTG SAPTCO 6-10 3 9 26-06-09 19:00 389 1 1 2 393 393 RUA TAIBAH 0 5 523 MANAZIL ALASWAF 65616 199 1 199 112 27 ASG Anwar Alsafwa Golden 4 26-06-18 03 SAPTCO 0 ASG cd ed chld
07-22 18:24 JKG20 BTG SAPTCO 1-5 3 9 26-06-09 19:00 389 1 1 2 393 393 SEDRA 0 2 208 ALHAYATT INTERNATIONAL 78165 194 0 194 109 51 MNF Almunief Catering 4 26-06-18 03 SAPTCO 0 MNF cd ed chld
07-22 18:24 SOC52 RKN ABU SARHAD 1-9 3 11 26-06-09 20:00 356 1 1 2 360 357 ARJUWAN 4 5 514 MIRAGE TAIBA 64255 360 1 357 201 122 RMK Ramak Al Dyafa 4 26-06-18 10 ABU SARHAD 4 RMK cd ed chld
07-22 18:24 JKG21 BTG SAPTCO 4-11 3 12 26-06-09 21:00 441 1 1 2 445 443 RUA TAIBAH 5 5 506 MANAR ALEIMAN 66312 319 1 315 182 130 ASG Anwar Alsafwa Golden 4 26-06-18 02 SAPTCO 5 ASG cd ed chld
07-22 18:24 JKG21 BTG SAPTCO 1-3 3 12 26-06-09 21:00 441 1 1 2 445 443 SADU 1 5 504 BARA TAIBA 64270 126 1 126 65 68 HDR Al Haideri Catering 4 26-06-18 02 SAPTCO 1 HDR cd ed chld
07-22 18:24 SUB68 BTG AL QAID 3-10 3 14 26-06-09 21:00 376 1 1 2 380 379 ARJUWAN 2 5 514 MIRAGE TAIBA 60264 275 1 273 137 94 SPT Smart Pots 4 26-06-18 09 AL QAID 2 SPT cd ed chld
07-22 18:24 SUB68 BTG AL QAID 1-2 3 14 26-06-09 21:00 376 1 1 2 380 379 SADU 3 5 512 DIYAR AL HABIB 85567 105 1 105 56 23 SAT Safwat Abrar Taybah 4 26-06-18 09 AL QAID 3 SAT cd ed chld
07-22 18:24 SUB74 BTG AL QAID 1-10 5 10 26-06-11 16:00 376 1 1 2 380 380 RUA TAIBAH 4 5 501 RUA TAIBA 65617 380 1 378 203 100 RUA Rua Taiba Catering 5 26-06-19 17 AL QAID 4 RUA cd ed chld
07-22 18:24 SOC57 RKN ABU SARHAD 1-6 5 11 26-06-11 17:00 356 1 1 2 360 356 ABRAJ SAADAH 0 3 308 ARJWAN ALSAADA 79413 225 0 223 123 114 SPT Smart Pots 6 26-06-20 04 ABU SARHAD 0 SPT cd ed chld
07-22 18:24 SOC57 RKN ABU SARHAD 7-9 5 11 26-06-11 17:00 356 1 1 2 360 356 RUA TAIBAH 5 5 523 MANAZIL ALASWAF 66272 135 1 131 70 67 ASG Anwar Alsafwa Golden 6 26-06-20 04 ABU SARHAD 5 ASG cd ed chld
07-22 18:24 LOP15 BTG MAZAYA 1-9 5 18 26-06-11 21:00 365 1 1 2 369 367 RUA TAIBAH 1 5 523 MANAZIL ALASWAF 65622;112630 367 1 366 185 142 ASG Anwar Alsafwa Golden 6 26-06-20 07 MAZAYA 1 ASG cd ed chld
07-22 18:24 SUB77 BTG BARAKAH 1 6 4 26-06-12 14:00 376 1 1 2 380 377 RUA TAIBAH 2 5 501 RUA TAIBA 65628 40 1 40 20 12 RUA Rua Taiba Catering 6 26-06-20 19 BARAKAH 2 RUA cd ed chld
07-22 18:24 SUB77 BTG BARAKAH 2-10 6 4 26-06-12 14:00 376 1 1 2 380 377 SEDRA 3 5 507 JIWAR AL-MADINA 75080 340 1 337 173 100 RMK Ramak Al Dyafa 6 26-06-20 19 BARAKAH 3 RMK cd ed chld
07-22 18:24 YIA15 BTG RABITAT 1-4 6 14 26-06-12 22:00 356 1 1 2 360 358 ABRAJ SAADAH 0 4 425 TAIBA ROSE 79418 167 0 164 88 88 MNF Almunief Catering 7 26-06-21 02 RABITAT 0 MNF cd ed chld
07-22 18:24 YIA15 BTG RABITAT 5-9 6 14 26-06-12 22:00 356 1 1 2 360 358 SEDRA 4 5 507 JIWAR AL-MADINA 81685 194 1 194 99 116 SDR Sedra Internarional 7 26-06-21 02 RABITAT 4 SDR cd ed chld
07-22 18:24 BDJ13 BTG MARAKEB 1-10 7 2 26-06-13 14:00 356 1 1 2 360 360 ANDALUS 5 5 521 3 POINTA AL-KAWTHAR 69099 357 1 360 202 103 AND Al Andalus Company 7 26-06-21 16 MARAKEB 5 AND cd ed chld
07-22 18:24 BDJ13 BTG MARAKEB 7 2 26-06-13 14:00 356 1 1 2 360 360 ANDALUS 1 5 519 3 POINTS AL-AMEIN 84250 3 1 0 0 0 NOH Nooha Catering 7 26-06-21 16 MARAKEB 1 NOH cd ed chld
07-22 18:24 JKG26 BTG SAPTCO 7 5 26-06-13 14:00 441 1 1 2 445 444 ANDALUS 2 5 519 3 POINTS AL-AMEIN 84250 20 1 18 10 10 NOH Nooha Catering 6 26-06-20 22 SAPTCO 2 NOH cd ed chld
07-22 18:24 JKG26 BTG SAPTCO 1-10 7 5 26-06-13 14:00 441 1 1 2 445 444 SUHDI 0 3 301 MANAZEL ALHASAN 71822 425 0 425 234 86 ASG Anwar Alsafwa Golden 6 26-06-20 22 SAPTCO 0 ASG cd ed chld
07-22 18:24 KJT28 RKN RAWAF 1-11 7 7 26-06-13 16:00 441 1 1 2 445 442 ANDALUS 4 5 520 NIQAT THALATHA AL-RIDA 68396 445 1 442 234 125 BUR Burhan Al Huda Taiba 7 26-06-21 17 RAWAF 4 BUR cd ed chld
07-22 18:24 SOC61 RKN ABU SARHAD 1-9 7 8 26-06-13 14:00 356 1 1 2 360 360 ANDALUS 3 5 519 3 POINTS AL-AMEIN 68400 360 1 360 195 171 NOH Nooha Catering 7 26-06-21 13 ABU SARHAD 3 NOH cd ed chld
07-22 18:24 JKB14 RKN RAWAHEL 1-10 7 10 26-06-13 16:00 389 1 1 2 393 388 ANDALUS 5 5 521 3 POINTA AL-KAWTHAR 70161 393 1 388 209 129 AND Al Andalus Company 7 26-06-21 18 RAWAHEL 5 AND cd ed chld
07-22 18:24 YIA16 BTG RABITAT 1-9 7 16 26-06-13 20:00 356 1 1 2 360 360 ANDALUS 1 5 519 3 POINTS AL-AMEIN 70248 360 1 359 204 184 NOH Nooha Catering 8 26-06-22 04 RABITAT 1 NOH cd ed chld
07-22 18:24 SUB85 BTG BARAKAH 1-10 8 8 26-06-14 14:00 376 1 1 2 380 380 ZUHDI 2 5 510 GULNAR THAIBAH 80212 380 1 380 188 122 NOH Nooha Catering 8 26-06-22 12 BARAKAH 2 NOH cd ed chld
07-22 18:24 YIA17 BTG RABITAT 3-9 8 10 26-06-14 14:00 356 1 1 2 360 355 ANDALUS 3 5 520 NIQAT THALATHA AL-RIDA 71768 265 1 265 141 124 SAT Safwat Abrar Taybah 8 26-06-22 13 RABITAT 3 SAT cd ed chld
07-22 18:24 YIA17 BTG RABITAT 1-2 8 10 26-06-14 14:00 356 1 1 2 360 355 ZUHDI 0 3 301 MANAZEL ALHASAN 71867 95 0 90 49 40 ASG Anwar Alsafwa Golden 8 26-06-22 13 RABITAT 0 ASG cd ed chld
07-22 18:24 SOC64 RKN ABU SARHAD 9 8 16 26-06-14 16:00 356 1 1 2 360 357 ANDALUS 4 5 519 3 POINTS AL-AMEIN 81206 49 1 44 27 17 NOH Nooha Catering 8 26-06-22 22 ABU SARHAD 4 NOH cd ed chld
07-22 18:24 SOC64 RKN ABU SARHAD 1-8 8 16 26-06-14 16:00 356 1 1 2 360 357 ANDALUS 0 3 312 RAWABI AL ZAHRA 72384 313 0 313 164 126 MNF Almunief Catering 8 26-06-22 22 ABU SARHAD 0 MNF cd ed chld
07-22 18:24 SUB90 BTG AL QOID 1-10 9 11 26-06-15 16:00 376 1 1 2 380 379 RUA TAIBAH 5 5 508 NUSUK ALHIJRA 71820 380 1 378 188 105 NOH Nooha Catering 9 26-06-23 19 AL QOID 5 NOH cd ed chld
07-22 18:24 YIA19 BTG RABITAT 1-5 9 15 26-06-15 20:00 356 1 1 2 360 358 SADU 0 2 215 DIYAR AL EIMAN 81691 203 0 202 107 81 SFT Safwat Taibah Catering 10 26-06-24 07 RABITAT 0 SFT cd ed chld
07-22 18:24 YIA19 BTG RABITAT 6-9 9 15 26-06-15 20:00 356 1 1 2 360 358 SADU 1 5 515 DIWAN AL HIJRA 85466 156 1 156 81 67 ASG Anwar Alsafwa Golden 10 26-06-24 07 RABITAT 1 ASG cd ed chld
07-22 18:24 SOC67 RKN ABU SARHAD 1-9 9 16 26-06-15 23:00 356 1 1 2 360 357 RUA TAIBAH 2 5 508 NUSUK ALHIJRA 73138 360 1 357 195 161 NOH Nooha Catering 9 26-06-23 23 ABU SARHAD 2 NOH cd ed chld
07-22 18:24 SUB92 BTG AL QAID 1-10 10 5 26-06-16 14:00 376 1 1 2 380 379 SADU 3 5 512 DIYAR AL HABIB 66364 380 1 378 193 122 RUA Rua Taiba Catering 10 26-06-24 13 AL QAID 3 RUA cd ed chld
07-22 18:24 SUB96 BTG AL QAID 1-10 10 14 26-06-16 20:00 377 1 1 2 381 378 ABRAJ HUSSAM 4 5 515 DIWAN AL HIJRA 112566 380 1 221 112 91 SAT Safwat Abrar Taybah 11 26-06-25 04 AL QAID 4 SAT cd ed chld
07-22 18:24 SOC72 RKN ABU SARHAD 1-9 10 20 26-06-16 23:00 356 1 1 2 360 358 RUA TAIBAH 5 5 513 AL-ANDALUS ALMASI 71887 360 1 358 184 152 SAS Safwat Al Salam 11 26-06-25 08 ABU SARHAD 5 SAS cd ed chld
07-22 18:24 BTJ11 RKN MAWAKEB 7-10 11 1 26-06-17 14:00 389 1 1 2 393 393 ABRAJ SAADAH 1 5 505 HUDA TAIBAH 73167 141 1 141 88 60 NOH Nooha Catering 11 26-06-25 18 MAWAKEB 1 NOH cd ed chld
07-22 18:24 BTJ11 RKN MAWAKEB 1-6 11 1 26-06-17 14:00 389 1 1 2 393 393 SADU 0 4 422 DIYAR AL MADINA 83829 252 0 252 139 87 URC United Regional 11 26-06-25 18 MAWAKEB 0 URC cd ed chld
07-22 18:24 SOC73 RKN ABU SARHAD 1 11 2 26-06-17 14:00 356 1 1 2 360 360 ABRAJ SAADAH 2 5 505 HUDA TAIBAH 71899 50 1 50 22 19 NOH Nooha Catering 11 26-06-25 14 ABU SARHAD 2 NOH cd ed chld
07-22 18:24 SOC73 RKN ABU SARHAD 2-9 11 2 26-06-17 14:00 356 1 1 2 360 360 RUA TAIBAH 3 5 506 MANAR ALEIMAN 67517 310 1 310 174 149 SDR Sedra Internarional 11 26-06-25 14 ABU SARHAD 3 SDR cd ed chld
07-22 18:24 SOC74 RKN ABU SARHAD 1-9 11 13 26-06-17 21:00 356 1 1 2 360 360 ABRAJ SAADAH 4 5 505 HUDA TAIBAH 71733 360 1 360 195 143 NOH Nooha Catering 12 26-06-26 02 ABU SARHAD 4 NOH cd ed chld
07-22 18:24 KJT35 RKN RAWAF 1-11 12 4 26-06-18 14:00 441 1 1 2 445 436 SADU 5 5 504 BARA TAIBA 72498 445 1 436 246 123 HDR Al Haideri Catering 11 26-06-25 21 RAWAF 5 HDR cd ed chld
07-22 18:24 YIA22 BTG RABITAT 1-9 12 10 26-06-18 14:00 356 1 1 2 360 359 ARJUWAN 1 5 514 MIRAGE TAIBA 66347 360 1 357 178 180 RMK Ramak Al Dyafa 12 26-06-26 15 RABITAT 1 RMK cd ed chld
07-22 18:24 SOC78 RKN ABU SARHAD 1-9 12 14 26-06-18 17:00 356 1 1 2 360 360 ARJUWAN 2 5 514 MIRAGE TAIBA 64260 360 1 360 197 173 RMK Ramak Al Dyafa 13 26-06-27 02 ABU SARHAD 2 RMK cd ed chld
07-22 18:24 BTJ12 RKN MAWAKEB 6-10 12 15 26-06-18 17:00 389 1 1 2 393 391 RUA TAIBAH 3 5 523 MANAZIL ALASWAF 67569 199 1 197 118 70 ASG Anwar Alsafwa Golden 13 26-06-27 00 MAWAKEB 3 ASG cd ed chld
07-22 18:24 BTJ12 RKN MAWAKEB 1-5 12 15 26-06-18 17:00 389 1 1 2 393 391 SEDRA 0 2 208 ALHAYATT INTERNATIONAL 76598 194 0 194 118 80 MNF Almunief Catering 13 26-06-27 00 MAWAKEB 0 MNF cd ed chld
07-22 18:24 KJT37 RKN RAWAF 4-11 13 5 26-06-19 14:00 441 1 1 2 445 443 RUA TAIBAH 4 5 506 MANAR ALEIMAN 76624 320 1 317 190 90 SAS Safwat Al Salam 13 26-06-27 01 RAWAF 4 SAS cd ed chld
07-22 18:24 KJT37 RKN RAWAF 1-3 13 5 26-06-19 14:00 441 1 1 2 445 443 SADU 5 5 504 BARA TAIBA 81192 126 1 126 70 35 HDR Al Haideri Catering 13 26-06-27 01 RAWAF 5 HDR cd ed chld
07-22 18:24 SUB104 BTG AL QAID 3-10 13 9 26-06-19 14:00 376 1 1 2 380 375 ARJUWAN 1 5 514 MIRAGE TAIBA 60261 275 1 269 149 120 SPT Smart Pots 13 26-06-27 14 AL QAID 1 SPT cd ed chld
07-22 18:24 SUB104 BTG AL QAID 1-2 13 9 26-06-19 14:00 376 1 1 2 380 375 SADU 2 5 512 DIYAR AL HABIB 66365 105 1 105 50 48 SAT Safwat Abrar Taybah 13 26-06-27 14 AL QAID 2 SAT cd ed chld
07-22 18:24 SUB109 BTG BARAKAH 1-10 14 12 26-06-20 17:00 376 1 1 2 380 380 RUA TAIBAH 3 5 501 RUA TAIBA 65627 380 1 376 196 165 RUA Rua Taiba Catering 14 26-06-28 22 BARAKAH 3 RUA cd ed chld
07-22 18:24 SUB113 BTG BARAKAH 10 15 8 26-06-21 17:00 376 1 1 2 380 379 RUA TAIBAH 4 5 501 RUA TAIBA 65478 40 1 39 17 16 RUA Rua Taiba Catering 16 26-06-30 04 BARAKAH 4 RUA cd ed chld
07-22 18:24 SUB113 BTG BARAKAH 1-9 15 8 26-06-21 17:00 376 1 1 2 380 379 SEDRA 0 4 426 AL AMAN AL ARABIA 76573 340 0 340 185 140 SAS Safwat Al Salam 16 26-06-30 04 BARAKAH 0 SAS cd ed chld
07-22 18:24 BDJ19 BTG MAWAKEB 1-9 16 1 26-06-22 14:00 356 1 1 2 360 347 RUA TAIBAH 5 5 523 MANAZIL ALASWAF 65630 342 1 347 201 86 ASG Anwar Alsafwa Golden 16 26-06-30 13 MAWAKEB 5 ASG cd ed chld
07-22 18:24 BDJ19 BTG MAWAKEB 16 1 26-06-22 14:00 356 1 1 2 360 347 RUA TAIBAH 0 3 302 TABA ALSALAM 69130 11 0 0 0 0 UHT Uhud Taiba for Catering 16 26-06-30 13 MAWAKEB 0 UHT cd ed chld
16,463 51 16,201 8,749 6,216

select * from med_hotel where id>0 and `gel`='2'