[08/07/2020 05:52:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='FronentEndBookingVoucher',status_date='2020-08-07 05:52:32',current_status='vouchered',voucher_hashcode='67d3a4b78c6f2cc4db8e72c825b4b3b7638892800',vouchered_by ='tfg' where id='2800';
[08/07/2020 05:52:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2800',config_key='VOUCHER_DATE', config_value='2020-08-07 05:52:32',create_date='2020-08-07 05:52:32';
[08/07/2020 05:52:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2800','vouchered','2020-08-07 05:52:32','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[08/07/2020 05:52:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202800/   Booking Vouchered ',from_email_id= '',body= '[encoded data, 20208 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-08-07 05:52:34';
[08/07/2020 05:52:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG202800/   Booking Vouchered ',from_email_id= '',body= '[encoded data, 20208 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-08-07 05:52:36';
[08/07/2020 05:52:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='FronentEndBookingVoucher',status_date='2020-08-07 05:52:37',current_status='vouchered',voucher_hashcode='616e517c2fb9061164535aa97a09934d266082801',vouchered_by ='tfg' where id='2801';
[08/07/2020 05:52:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='2801',config_key='VOUCHER_DATE', config_value='2020-08-07 05:52:37',create_date='2020-08-07 05:52:37';
[08/07/2020 05:52:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','2801','vouchered','2020-08-07 05:52:37','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[08/07/2020 05:52:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG402801 / Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 24336 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-08-07 05:52:37';
[08/07/2020 05:54:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/print_invoice.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDIwMDBdOiBTeW50YXggZXJyb3Igb3IgYWNjZXNzIHZpb2xhdGlvbjogMTA2NCBZb3UgaGF2ZSBhbiBlcnJvciBpbiB5b3VyIFNRTCBzeW50YXg7IGNoZWNrIHRoZSBtYW51YWwgdGhhdCBjb3JyZXNwb25kcyB0byB5b3VyIE15U1FMIHNlcnZlciB2ZXJzaW9uIGZvciB0aGUgcmlnaHQgc3ludGF4IHRvIHVzZSBuZWFyICdBTkQgcGFyZW50X2Jvb2tpbmc9MCcgYXQgbGluZSA0IGZyb20gT3RyYW1zREIucGhwIG9uIDA3LTA4LTIwMjAgMDU6NTQ6MDcKIFF1ZXJ5OlNFTEVDVCBiLmlkLCBJRignJz0nc3lzdGVtX2N1cnJlbmN5JyxicmkuYWdlbnRfcHJpY2UgKiBicmkuYWNjb3VudGluZ19tdWx0aXBsaWVyLGJyaS5hZ2VudF9wcmljZSkgQVMgcmF0ZSwKICAgICAgICAgICAgICAgICAgICBiLnNlcnZpY2VfdHlwZSBGUk9NIGJvb2tpbmdzIEFTIGIKICAgICAgICAgICAgICAgICAgICBJTk5FUiBKT0lOIGJvb2tpbmdfcmF0ZV9pbmZvIEFTIGJyaSBPTiBiLmlkID0gYnJpLmJvb2tpbmdfaWQgQU5EIGFjY190eXBlID0nc2FsZScKICAgICAgICAgICAgICAgICAgICBXSEVSRSBiLmludm9pY2VfbnVtYmVyID0gPyBBTkQgYi5wYXJlbnRfYWdlbnRfaWQgPSAgQU5EIHBhcmVudF9ib29raW5nPScyMDIwLzM2NScgCgovcHJpbnRfaW52b2ljZS5waHA/aWQ9Mjc4OSZ0eXBlPWhvdGVsCgo8cHJlPgpIb3N0bmFtZTogcXRlY2gub3RyYW1zLmNvbQogPGJyPgoKQ29ubmVjdGlvbjogb3RyYW1zX3RoZWZhYkAyMDkuMjM2LjExNC4xNzQKCkJhY2t0cmFjZToKYXJyYXkgKAogIDAgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvT3RyYW1zREIucGhwJywKICAgICdsaW5lJyA9PiA4NiwKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL0Jvb2tpbmcucGhwJywKICAgICdsaW5lJyA9PiAzNDE5LAogICAgJ2Z1bmN0aW9uJyA9PiAnZ2V0Um93cycsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDIgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvSW50ZXJCcmFuY2gucGhwJywKICAgICdsaW5lJyA9PiAzMjY2LAogICAgJ2Z1bmN0aW9uJyA9PiAnZGlzcGxheVRheCcsCiAgICAnY2xhc3MnID0+ICdCb29raW5nJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMyA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9Cb29raW5nLnBocCcsCiAgICAnbGluZScgPT4gMTMxNCwKICAgICdmdW5jdGlvbicgPT4gJ3ByaW50X2ludm9pY2UnLAogICAgJ2NsYXNzJyA9PiAnSW50ZXJCcmFuY2gnLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICA0ID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3ByaW50X2ludm9pY2UucGhwJywKICAgICdsaW5lJyA9PiA2LAogICAgJ2Z1bmN0aW9uJyA9PiAncHJpbnRfaW52b2ljZScsCiAgICAnY2xhc3MnID0+ICdCb29raW5nJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCikKCi9wcmludF9pbnZvaWNlLnBocD9pZD0yNzg5JnR5cGU9aG90ZWwKdWF0LnRmZy5vdHJhbXMubmV0LCBDbGllbnQgSVA6IDEwMy4xMDQuMjI2LjEzMDwvcHJlPjxicj4KYXJyYXkgKAogIDAgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvT3RyYW1zREIucGhwJywKICAgICdsaW5lJyA9PiA4NiwKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL0Jvb2tpbmcucGhwJywKICAgICdsaW5lJyA9PiAzNDE5LAogICAgJ2Z1bmN0aW9uJyA9PiAnZ2V0Um93cycsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDIgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvSW50ZXJCcmFuY2gucGhwJywKICAgICdsaW5lJyA9PiAzMjY2LAogICAgJ2Z1bmN0aW9uJyA9PiAnZGlzcGxheVRheCcsCiAgICAnY2xhc3MnID0+ICdCb29raW5nJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMyA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9Cb29raW5nLnBocCcsCiAgICAnbGluZScgPT4gMTMxNCwKICAgICdmdW5jdGlvbicgPT4gJ3ByaW50X2ludm9pY2UnLAogICAgJ2NsYXNzJyA9PiAnSW50ZXJCcmFuY2gnLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICA0ID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3ByaW50X2ludm9pY2UucGhwJywKICAgICdsaW5lJyA9PiA2LAogICAgJ2Z1bmN0aW9uJyA9PiAncHJpbnRfaW52b2ljZScsCiAgICAnY2xhc3MnID0+ICdCb29raW5nJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCik=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/print_invoice.php?id=2789&type=hotel',create_date= '2020-08-07 05:54:07';
[08/07/2020 05:58:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/print_invoice.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDIwMDBdOiBTeW50YXggZXJyb3Igb3IgYWNjZXNzIHZpb2xhdGlvbjogMTA2NCBZb3UgaGF2ZSBhbiBlcnJvciBpbiB5b3VyIFNRTCBzeW50YXg7IGNoZWNrIHRoZSBtYW51YWwgdGhhdCBjb3JyZXNwb25kcyB0byB5b3VyIE15U1FMIHNlcnZlciB2ZXJzaW9uIGZvciB0aGUgcmlnaHQgc3ludGF4IHRvIHVzZSBuZWFyICdBTkQgcGFyZW50X2Jvb2tpbmc9MCcgYXQgbGluZSA0IGZyb20gT3RyYW1zREIucGhwIG9uIDA3LTA4LTIwMjAgMDU6NTg6MjgKIFF1ZXJ5OlNFTEVDVCBiLmlkLCBJRignJz0nc3lzdGVtX2N1cnJlbmN5JyxicmkuYWdlbnRfcHJpY2UgKiBicmkuYWNjb3VudGluZ19tdWx0aXBsaWVyLGJyaS5hZ2VudF9wcmljZSkgQVMgcmF0ZSwKICAgICAgICAgICAgICAgICAgICBiLnNlcnZpY2VfdHlwZSBGUk9NIGJvb2tpbmdzIEFTIGIKICAgICAgICAgICAgICAgICAgICBJTk5FUiBKT0lOIGJvb2tpbmdfcmF0ZV9pbmZvIEFTIGJyaSBPTiBiLmlkID0gYnJpLmJvb2tpbmdfaWQgQU5EIGFjY190eXBlID0nc2FsZScKICAgICAgICAgICAgICAgICAgICBXSEVSRSBiLmludm9pY2VfbnVtYmVyID0gPyBBTkQgYi5wYXJlbnRfYWdlbnRfaWQgPSAgQU5EIHBhcmVudF9ib29raW5nPScyMDIwLzM2NScgCgovcHJpbnRfaW52b2ljZS5waHA/aWQ9Mjc4OSZ0eXBlPWhvdGVsJmV6X3F1ZXJpZXM9MQoKPHByZT4KSG9zdG5hbWU6IHF0ZWNoLm90cmFtcy5jb20KIDxicj4KCkNvbm5lY3Rpb246IG90cmFtc190aGVmYWJAMjA5LjIzNi4xMTQuMTc0CgpCYWNrdHJhY2U6CmFycmF5ICgKICAwID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL090cmFtc0RCLnBocCcsCiAgICAnbGluZScgPT4gODYsCiAgICAnZnVuY3Rpb24nID0+ICd3cml0ZUVycm9yJywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMSA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9Cb29raW5nLnBocCcsCiAgICAnbGluZScgPT4gMzQxOSwKICAgICdmdW5jdGlvbicgPT4gJ2dldFJvd3MnLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAyID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL0ludGVyQnJhbmNoLnBocCcsCiAgICAnbGluZScgPT4gMzI2NiwKICAgICdmdW5jdGlvbicgPT4gJ2Rpc3BsYXlUYXgnLAogICAgJ2NsYXNzJyA9PiAnQm9va2luZycsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDMgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvQm9va2luZy5waHAnLAogICAgJ2xpbmUnID0+IDEzMTQsCiAgICAnZnVuY3Rpb24nID0+ICdwcmludF9pbnZvaWNlJywKICAgICdjbGFzcycgPT4gJ0ludGVyQnJhbmNoJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgNCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy9wcmludF9pbnZvaWNlLnBocCcsCiAgICAnbGluZScgPT4gNiwKICAgICdmdW5jdGlvbicgPT4gJ3ByaW50X2ludm9pY2UnLAogICAgJ2NsYXNzJyA9PiAnQm9va2luZycsCiAgICAndHlwZScgPT4gJy0+JywKICApLAopCgovcHJpbnRfaW52b2ljZS5waHA/aWQ9Mjc4OSZ0eXBlPWhvdGVsJmV6X3F1ZXJpZXM9MQp1YXQudGZnLm90cmFtcy5uZXQsIENsaWVudCBJUDogNDUuMTIwLjE0Ny41NjwvcHJlPjxicj4KYXJyYXkgKAogIDAgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvT3RyYW1zREIucGhwJywKICAgICdsaW5lJyA9PiA4NiwKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL0Jvb2tpbmcucGhwJywKICAgICdsaW5lJyA9PiAzNDE5LAogICAgJ2Z1bmN0aW9uJyA9PiAnZ2V0Um93cycsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDIgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvSW50ZXJCcmFuY2gucGhwJywKICAgICdsaW5lJyA9PiAzMjY2LAogICAgJ2Z1bmN0aW9uJyA9PiAnZGlzcGxheVRheCcsCiAgICAnY2xhc3MnID0+ICdCb29raW5nJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMyA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9Cb29raW5nLnBocCcsCiAgICAnbGluZScgPT4gMTMxNCwKICAgICdmdW5jdGlvbicgPT4gJ3ByaW50X2ludm9pY2UnLAogICAgJ2NsYXNzJyA9PiAnSW50ZXJCcmFuY2gnLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICA0ID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3ByaW50X2ludm9pY2UucGhwJywKICAgICdsaW5lJyA9PiA2LAogICAgJ2Z1bmN0aW9uJyA9PiAncHJpbnRfaW52b2ljZScsCiAgICAnY2xhc3MnID0+ICdCb29raW5nJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCik=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/print_invoice.php?id=2789&type=hotel&ez_queries=1',create_date= '2020-08-07 05:58:28';
