API tools faq
paste
Guest User

west gate only data

a guest
Jul 28th, 2015
264
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 30.33 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.0.10deb1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Jul 28, 2015 at 07:25 PM
  7. -- Server version: 5.5.44-0ubuntu0.14.04.1
  8. -- PHP Version: 5.5.9-1ubuntu4.11
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13. --
  14. -- Database: `wgcallcenter`
  15. --
  16.  
  17. --
  18. -- Dumping data for table `booking`
  19. --
  20.  
  21. INSERT INTO `booking` (`id`, `customer_id`, `order_id`, `ticket_hotel_id`, `user_id`, `passport_number`, `created_at`, `updated_at`) VALUES
  22. (1, 1, 1, 1, 1, '3140218', '2015-07-28 18:24:01', '2015-07-28 18:24:01'),
  23. (2, 5, 4, 5, 1, '3140222', '2015-07-28 18:32:59', '2015-07-28 18:32:59'),
  24. (3, 5, 4, 6, 1, '3140222', '2015-07-28 18:32:59', '2015-07-28 18:32:59'),
  25. (4, 5, 4, 7, 1, '3140222', '2015-07-28 18:32:59', '2015-07-28 18:32:59'),
  26. (5, 5, 4, 8, 1, '3140222', '2015-07-28 18:32:59', '2015-07-28 18:32:59'),
  27. (6, 7, 6, 9, 1, '3140224', '2015-07-28 18:35:53', '2015-07-28 18:35:53'),
  28. (7, 7, 6, 10, 1, '3140224', '2015-07-28 18:35:53', '2015-07-28 18:35:53');
  29.  
  30. --
  31. -- Dumping data for table `customer_info`
  32. --
  33.  
  34. INSERT INTO `customer_info` (`id`, `first_name`, `last_name`, `email`, `address1`, `address2`, `phone_number`, `city`, `state`, `zip_code`, `country`, `gender`, `marital_status`, `annual_income`, `total_travellers`, `campaign_id`, `cc_type`, `last_4_cc`, `income_group`, `age_group`, `citizenship`, `tour_with_spouse`, `already_toured`, `travelled_within_12_mnths_wg`, `travelled_with_other_party`, `created_at`, `updated_at`) VALUES
  35. (1, 'imtiaz', 'pabel', 'pabel@test.com', 'Dallas', 'Dallas', '1819534767', 'Dallas', 'GU', '75002', 'US', NULL, NULL, 'N/A', NULL, 403297, '', NULL, NULL, 0, NULL, 0, 0, 0, 0, '2015-07-28 18:24:01', '2015-07-28 18:24:01'),
  36. (2, 'imtiaz', 'pabel', 'pabel@test.com', 'Dallas', 'Dallas', '1819534767', 'Dallas', 'GU', '75002', 'US', NULL, NULL, 'N/A', NULL, 403297, '', NULL, NULL, 0, NULL, 0, 0, 0, 0, '2015-07-28 18:24:35', '2015-07-28 18:24:35'),
  37. (3, 'imtiaz', 'pabel', 'pabel@test.com', 'Dallas', 'Dallas', '1819534767', 'Dallas', 'GU', '75002', 'US', NULL, NULL, 'N/A', NULL, 403297, '', NULL, NULL, 0, NULL, 0, 0, 0, 0, '2015-07-28 18:30:32', '2015-07-28 18:30:32'),
  38. (4, 'imtiaz', 'pabel', 'pabel@test.com', 'Dallas', 'Dallas', '1819534767', 'Dallas', 'GU', '75002', 'US', NULL, NULL, 'N/A', NULL, 403297, '', NULL, NULL, 0, NULL, 0, 0, 0, 0, '2015-07-28 18:31:09', '2015-07-28 18:31:09'),
  39. (5, 'imtiaz', 'pabel', 'pabel@test.com', 'Dallas', 'Dallas', '1819534767', 'Dallas', 'GU', '75002', 'US', NULL, NULL, 'N/A', NULL, 403297, '', NULL, NULL, 0, NULL, 0, 0, 0, 0, '2015-07-28 18:32:59', '2015-07-28 18:32:59'),
  40. (6, 'imtiaz', 'pabel', 'pabel@test.com', 'Dallas', 'Dallas', '1819534767', 'Dallas', 'GU', '75002', 'US', NULL, NULL, 'N/A', NULL, 403297, '', NULL, NULL, 0, NULL, 0, 0, 0, 0, '2015-07-28 18:35:17', '2015-07-28 18:35:17'),
  41. (7, 'imtiaz', 'pabel', 'pabel@test.com', 'Dallas', 'Dallas', '1819534767', 'Dallas', 'GU', '75002', 'US', NULL, NULL, 'N/A', NULL, 403297, '', NULL, NULL, 0, NULL, 0, 0, 0, 0, '2015-07-28 18:35:53', '2015-07-28 18:35:53');
  42.  
  43. --
  44. -- Dumping data for table `order_info`
  45. --
  46.  
  47. INSERT INTO `order_info` (`id`, `api_order_id`, `passport_no`, `vacpac_no`, `prospect_id`, `custom_discount_price`, `total_price`, `cart_subtotal`, `cart_tax`, `cart_total_savings`, `cart_custom_discount`, `cart_total`, `session_raw`, `request_json`, `response_json`, `activity_started`, `activity_finished`, `activity_duration`, `begin_campaign`, `user_id`, `status`, `created_at`, `updated_at`) VALUES
  48. (1, 10011, 3140218, 3140218, 67264894, 0.00, 16, 17.00, 0.00, 4.29, 0.00, 17.00, 'a:7:{s:4:"user";s:14:"rqw23525asdf56";s:10:"slim.flash";a:0:{}s:16:"booking_activity";a:4:{s:7:"user_id";i:1;s:14:"campaign_begin";s:13:"VacPac Script";s:7:"started";s:19:"2015-07-28 06:23:04";s:8:"finished";s:19:"2015-07-28 06:24:01";}s:8:"customer";a:23:{s:19:"customer_first_name";s:6:"imtiaz";s:18:"customer_last_name";s:5:"pabel";s:14:"customer_email";s:14:"pabel@test.com";s:17:"customer_address1";s:6:"Dallas";s:17:"customer_address2";s:6:"Dallas";s:14:"customer_phone";s:10:"1819534767";s:13:"customer_city";s:6:"Dallas";s:14:"customer_state";s:2:"GU";s:12:"customer_zip";s:5:"75002";s:16:"customer_country";s:2:"US";s:20:"customer_citizenship";s:13:"United States";s:24:"customer_no_of_travelers";s:3:" 2 ";s:23:"customer_martial_status";s:6:"Single";s:15:"customer_gender";s:1:"1";s:22:"customer_annual_income";s:3:"N/A";s:18:"customer_age_group";s:1:"0";s:25:"customer_tour_with_spouse";s:1:"0";s:23:"customer_already_toured";s:1:"0";s:37:"customer_travelled_within_12_mnths_wg";s:1:"0";s:35:"customer_travelled_with_other_party";s:1:"0";s:20:"customer_campaign_id";s:6:"403297";s:16:"customer_cc_type";s:3:"N/A";s:18:"customer_last_4_cc";s:0:"";}s:23:"ticketSearchInformation";a:2:{s:17:"ticketDestination";s:7:"ORLANDO";s:14:"ticketQuantity";s:1:"1";}s:4:"cart";a:1:{i:2461049510926227;a:10:{s:9:"productID";s:6:"130901";s:15:"productCategory";b:0;s:11:"productName";s:24:"1 DAY CRAYOLA EXPERIENCE";s:18:"productDescription";s:0:"";s:11:"productType";s:6:"Ticket";s:3:"qty";s:1:"1";s:9:"unitPrice";s:2:"17";s:6:"others";a:4:{s:11:"retailPrice";s:5:"21.29";s:8:"nonPrice";s:5:"21.29";s:6:"saving";d:4.29;s:9:"tourPrice";i:0;}s:5:"total";i:17;s:13:"intAvailSeqId";s:0:"";}}s:22:"hotelSearchInformation";a:5:{s:14:"hotel_going_to";s:7:"ORLANDO";s:14:"hotel_check_in";s:11:"05-Aug-2015";s:15:"hotel_check_out";s:11:"10-Aug-2015";s:6:"nights";i:5;s:5:"guest";i:1;}}', 'https://api-services-qa.westgateresorts.com/pkg_sam_vacpac_pub_api.prc_online_booking?pnum_online_order_id=10011&pnum_marketing_campaign=403297&pchr_destination_id=ORLANDO&pchr_hotel_reservation_array=&pchr_customer_info_array=%2C%2C%2Cimtiaz%2Cpabel%2C%2C%2C1819534767%2C%2CDallas%2CDallas%2CDallas%2CGU%2C75002%2C%2CUS%2Cpabel%40test.com%2CEnglish&pchr_tickets_array=130901%2C1%2C21.29%2C4.29%2C17&pchr_travel_ins_array=&pchr_cc_type=&pnum_cc_number=&pnum_cc_exp=&pchr_cc_cardholder=&pnum_cc_charge_amount=&pnum_cc_cvv_number=&pnum_tour_discount=0.01', 'a:1:{s:13:"bookingResult";a:2:{s:7:"summary";a:5:{s:5:"order";s:5:"10011";s:6:"vacpac";s:7:"3140218";s:8:"prospect";s:8:"67264894";s:5:"price";s:5:"16.99";s:6:"ccauth";a:0:{}}s:19:"confirmationDetails";a:3:{s:12:"customerInfo";a:3:{s:4:"name";s:12:"Imtiaz Pabel";s:7:"address";s:35:"DALLAS DALLAS DALLAS, GU 75002 USA";s:5:"email";s:14:"pabel@test.com";}s:7:"tickets";a:1:{s:10:"ticketInfo";a:4:{s:8:"ticketId";s:6:"130901";s:10:"ticketDesc";s:24:"1 DAY CRAYOLA EXPERIENCE";s:9:"ticketQty";s:1:"1";s:11:"ticketPrice";s:2:"17";}}s:12:"tourDiscount";a:1:{s:11:"discountAmt";s:3:".01";}}}}', '2015-07-28 06:23:04', '2015-07-28 06:24:01', 57, 'VacPac Script', 1, 1, '2015-07-28 18:24:01', '2015-07-28 18:24:01'),
  49. (2, 10012, 3140220, 3140220, 67264894, 0.00, 839, 757.00, 0.00, 21.79, 0.00, 757.00, 'a:8:{s:4:"user";s:14:"rqw23525asdf56";s:10:"slim.flash";a:0:{}s:16:"booking_activity";a:3:{s:7:"started";s:19:"2015-07-28 06:26:20";s:14:"campaign_begin";s:13:"VacPac Script";s:8:"finished";s:19:"2015-07-28 06:30:32";}s:23:"ticketSearchInformation";a:2:{s:17:"ticketDestination";s:7:"ORLANDO";s:14:"ticketQuantity";s:1:"1";}s:9:"cart_tour";b:0;s:24:"packageSearchInformation";a:6:{s:18:"packageDestination";s:7:"ORLANDO";s:13:"packageInDate";s:11:"05-Aug-2015";s:14:"packageOutDate";s:11:"10-Aug-2015";s:6:"nights";i:5;s:5:"guest";i:1;s:15:"packageQuantity";i:1;}s:8:"customer";a:23:{s:19:"customer_first_name";s:6:"imtiaz";s:18:"customer_last_name";s:5:"pabel";s:14:"customer_email";s:14:"pabel@test.com";s:17:"customer_address1";s:6:"Dallas";s:17:"customer_address2";s:6:"Dallas";s:14:"customer_phone";s:10:"1819534767";s:13:"customer_city";s:6:"Dallas";s:14:"customer_state";s:2:"GU";s:12:"customer_zip";s:5:"75002";s:16:"customer_country";s:2:"US";s:20:"customer_citizenship";s:13:"United States";s:24:"customer_no_of_travelers";s:3:" 2 ";s:23:"customer_martial_status";s:6:"Single";s:15:"customer_gender";s:1:"1";s:22:"customer_annual_income";s:3:"N/A";s:18:"customer_age_group";s:1:"0";s:25:"customer_tour_with_spouse";s:1:"0";s:23:"customer_already_toured";s:1:"0";s:37:"customer_travelled_within_12_mnths_wg";s:1:"0";s:35:"customer_travelled_with_other_party";s:1:"0";s:20:"customer_campaign_id";s:6:"403297";s:16:"customer_cc_type";s:3:"N/A";s:18:"customer_last_4_cc";s:0:"";}s:4:"cart";a:2:{i:1772178377649817;a:10:{s:9:"productID";s:5:"97643";s:15:"productCategory";b:0;s:11:"productName";s:37:"1 DAY BUSCH GARDENS WEEKDAY ADMISSION";s:18:"productDescription";s:0:"";s:11:"productType";s:6:"Ticket";s:3:"qty";s:1:"1";s:9:"unitPrice";s:2:"94";s:6:"others";a:4:{s:11:"retailPrice";s:6:"103.79";s:8:"nonPrice";s:6:"103.79";s:6:"saving";d:9.7899999999999991;s:9:"tourPrice";i:0;}s:5:"total";i:94;s:13:"intAvailSeqId";s:0:"";}i:5937735113321599;a:10:{s:9:"productID";s:24:"3527STM - SUITE KING BED";s:15:"productCategory";b:0;s:11:"productName";s:59:"DOUBLETREE SUITES BY HILTON IN THE WALT DISNEY WORLD RESORT";s:18:"productDescription";s:0:"";s:11:"productType";s:5:"Hotel";s:3:"qty";s:1:"5";s:9:"unitPrice";s:5:"132.6";s:6:"others";a:9:{s:8:"roomType";s:20:"STM - SUITE KING BED";s:7:"hotelId";s:4:"3527";s:11:"arrivalDate";s:11:"05-Aug-2015";s:6:"nights";s:1:"5";s:5:"guest";i:1;s:11:"retailPrice";s:3:"135";s:9:"tourPrice";i:0;s:8:"nonPrice";s:5:"132.6";s:6:"saving";d:2.3999999999999999;}s:5:"total";d:663;s:13:"intAvailSeqId";s:3:"NaN";}}}', 'https://api-services-qa.westgateresorts.com/pkg_sam_vacpac_pub_api.prc_online_booking?pnum_online_order_id=10012&pnum_marketing_campaign=403297&pchr_destination_id=ORLANDO&pchr_hotel_reservation_array=3527%2CSTM+-+SUITE+KING+BED%2C05-Aug-2015%2C5%2C1%2C%2C135%2C12%2C123%2C0%2C&pchr_customer_info_array=%2C%2C%2Cimtiaz%2Cpabel%2C%2C%2C1819534767%2C%2CDallas%2CDallas%2CDallas%2CGU%2C75002%2C%2CUS%2Cpabel%40test.com%2CEnglish&pchr_tickets_array=97643%2C1%2C103.79%2C9.79%2C94&pchr_travel_ins_array=&pchr_cc_type=&pnum_cc_number=&pnum_cc_exp=&pchr_cc_cardholder=&pnum_cc_charge_amount=&pnum_cc_cvv_number=&pnum_tour_discount=0.01', 'a:1:{s:13:"bookingResult";a:2:{s:7:"summary";a:5:{s:5:"order";s:5:"10012";s:6:"vacpac";s:7:"3140220";s:8:"prospect";s:8:"67264894";s:5:"price";s:6:"839.87";s:6:"ccauth";a:0:{}}s:19:"confirmationDetails";a:3:{s:12:"customerInfo";a:3:{s:4:"name";s:12:"Imtiaz Pabel";s:7:"address";s:35:"DALLAS DALLAS DALLAS, GU 75002 USA";s:5:"email";s:14:"pabel@test.com";}s:7:"tickets";a:1:{s:10:"ticketInfo";a:4:{s:8:"ticketId";s:5:"97643";s:10:"ticketDesc";s:37:"1 DAY BUSCH GARDENS WEEKDAY ADMISSION";s:9:"ticketQty";s:1:"1";s:11:"ticketPrice";s:2:"94";}}s:12:"tourDiscount";a:1:{s:11:"discountAmt";s:3:".01";}}}}', '2015-07-28 06:26:20', '2015-07-28 06:30:32', 252, 'VacPac Script', 1, 1, '2015-07-28 18:30:32', '2015-07-28 18:30:32'),
  50. (3, 10013, 3140221, 3140221, 67264894, 0.00, 53, 649.29, 0.00, 208.15, 0.00, 649.29, 'a:6:{s:4:"user";s:14:"rqw23525asdf56";s:10:"slim.flash";a:0:{}s:16:"booking_activity";a:3:{s:7:"started";s:19:"2015-07-28 06:30:40";s:14:"campaign_begin";s:13:"VacPac Script";s:8:"finished";s:19:"2015-07-28 06:31:09";}s:8:"customer";a:23:{s:19:"customer_first_name";s:6:"imtiaz";s:18:"customer_last_name";s:5:"pabel";s:14:"customer_email";s:14:"pabel@test.com";s:17:"customer_address1";s:6:"Dallas";s:17:"customer_address2";s:6:"Dallas";s:14:"customer_phone";s:10:"1819534767";s:13:"customer_city";s:6:"Dallas";s:14:"customer_state";s:2:"GU";s:12:"customer_zip";s:5:"75002";s:16:"customer_country";s:2:"US";s:20:"customer_citizenship";s:13:"United States";s:24:"customer_no_of_travelers";s:3:" 2 ";s:23:"customer_martial_status";s:6:"Single";s:15:"customer_gender";s:1:"1";s:22:"customer_annual_income";s:3:"N/A";s:18:"customer_age_group";s:1:"0";s:25:"customer_tour_with_spouse";s:1:"0";s:23:"customer_already_toured";s:1:"0";s:37:"customer_travelled_within_12_mnths_wg";s:1:"0";s:35:"customer_travelled_with_other_party";s:1:"0";s:20:"customer_campaign_id";s:6:"403297";s:16:"customer_cc_type";s:3:"N/A";s:18:"customer_last_4_cc";s:0:"";}s:23:"ticketSearchInformation";a:2:{s:17:"ticketDestination";s:7:"ORLANDO";s:14:"ticketQuantity";s:1:"1";}s:4:"cart";a:3:{i:6018136401546281;a:10:{s:9:"productID";s:5:"45036";s:15:"productCategory";b:0;s:11:"productName";s:37:"1 DAY MAGIC YOUR WAY + HOPPER - CHILD";s:18:"productDescription";s:0:"";s:11:"productType";s:6:"Ticket";s:3:"qty";s:1:"1";s:9:"unitPrice";s:6:"163.69";s:6:"others";a:4:{s:11:"retailPrice";s:6:"163.69";s:8:"nonPrice";s:6:"163.69";s:6:"saving";i:0;s:9:"tourPrice";i:0;}s:5:"total";d:163.69;s:13:"intAvailSeqId";s:0:"";}s:16:"0005879155192263";a:10:{s:9:"productID";s:22:"3363STM - RUN OF HOUSE";s:15:"productCategory";b:0;s:11:"productName";s:25:"FLAMINGO WATERPARK RESORT";s:18:"productDescription";s:0:"";s:11:"productType";s:5:"Hotel";s:3:"qty";s:1:"5";s:9:"unitPrice";s:5:"45.51";s:6:"others";a:9:{s:8:"roomType";s:18:"STM - RUN OF HOUSE";s:7:"hotelId";s:4:"3363";s:11:"arrivalDate";s:11:"05-Aug-2015";s:6:"nights";s:1:"5";s:5:"guest";i:1;s:11:"retailPrice";s:5:"65.02";s:9:"tourPrice";i:0;s:8:"nonPrice";s:5:"45.51";s:6:"saving";d:19.509999999999998;}s:5:"total";d:227.54999999999998;s:13:"intAvailSeqId";s:3:"NaN";}i:2190541685991888;a:10:{s:9:"productID";s:18:"3352STM - STANDARD";s:15:"productCategory";b:0;s:11:"productName";s:17:"HERITAGE PARK INN";s:18:"productDescription";s:0:"";s:11:"productType";s:5:"Hotel";s:3:"qty";s:1:"5";s:9:"unitPrice";s:5:"51.61";s:6:"others";a:9:{s:8:"roomType";s:14:"STM - STANDARD";s:7:"hotelId";s:4:"3352";s:11:"arrivalDate";s:11:"05-Aug-2015";s:6:"nights";s:1:"5";s:5:"guest";i:1;s:11:"retailPrice";s:5:"73.73";s:9:"tourPrice";i:0;s:8:"nonPrice";s:5:"51.61";s:6:"saving";d:22.119999999999997;}s:5:"total";d:258.05000000000001;s:13:"intAvailSeqId";s:10:"1865891500";}}}', 'https://api-services-qa.westgateresorts.com/pkg_sam_vacpac_pub_api.prc_online_booking?pnum_online_order_id=10013&pnum_marketing_campaign=403297&pchr_destination_id=ORLANDO&pchr_hotel_reservation_array=3363%2CSTM+-+RUN+OF+HOUSE%2C05-Aug-2015%2C5%2C1%2C%2C65.02%2C97.55%2C-32.53%2C0%2C&pchr_customer_info_array=%2C%2C%2Cimtiaz%2Cpabel%2C%2C%2C1819534767%2C%2CDallas%2CDallas%2CDallas%2CGU%2C75002%2C%2CUS%2Cpabel%40test.com%2CEnglish&pchr_tickets_array=45036%2C1%2C163.69%2C0%2C163.69&pchr_travel_ins_array=&pchr_cc_type=&pnum_cc_number=&pnum_cc_exp=&pchr_cc_cardholder=&pnum_cc_charge_amount=&pnum_cc_cvv_number=&pnum_tour_discount=0.01', 'a:1:{s:13:"bookingResult";a:2:{s:7:"summary";a:5:{s:5:"order";s:5:"10013";s:6:"vacpac";s:7:"3140221";s:8:"prospect";s:8:"67264894";s:5:"price";s:5:"53.45";s:6:"ccauth";a:0:{}}s:19:"confirmationDetails";a:3:{s:12:"customerInfo";a:3:{s:4:"name";s:12:"Imtiaz Pabel";s:7:"address";s:35:"DALLAS DALLAS DALLAS, GU 75002 USA";s:5:"email";s:14:"pabel@test.com";}s:7:"tickets";a:1:{s:10:"ticketInfo";a:4:{s:8:"ticketId";s:5:"45036";s:10:"ticketDesc";s:37:"1 DAY MAGIC YOUR WAY + HOPPER - CHILD";s:9:"ticketQty";s:1:"1";s:11:"ticketPrice";s:6:"163.69";}}s:12:"tourDiscount";a:1:{s:11:"discountAmt";s:3:".01";}}}}', '2015-07-28 06:30:40', '2015-07-28 06:31:09', 29, 'VacPac Script', 1, 1, '2015-07-28 18:31:09', '2015-07-28 18:31:09'),
  51. (4, 10014, 3140222, 3140222, 67264894, 0.00, 1092, 943.83, 0.00, -68.87, 0.00, 943.83, 'a:7:{s:4:"user";s:14:"rqw23525asdf56";s:10:"slim.flash";a:0:{}s:16:"booking_activity";a:3:{s:7:"started";s:19:"2015-07-28 06:31:16";s:14:"campaign_begin";s:13:"VacPac Script";s:8:"finished";s:19:"2015-07-28 06:32:59";}s:8:"customer";a:23:{s:19:"customer_first_name";s:6:"imtiaz";s:18:"customer_last_name";s:5:"pabel";s:14:"customer_email";s:14:"pabel@test.com";s:17:"customer_address1";s:6:"Dallas";s:17:"customer_address2";s:6:"Dallas";s:14:"customer_phone";s:10:"1819534767";s:13:"customer_city";s:6:"Dallas";s:14:"customer_state";s:2:"GU";s:12:"customer_zip";s:5:"75002";s:16:"customer_country";s:2:"US";s:20:"customer_citizenship";s:13:"United States";s:24:"customer_no_of_travelers";s:3:" 2 ";s:23:"customer_martial_status";s:6:"Single";s:15:"customer_gender";s:1:"1";s:22:"customer_annual_income";s:3:"N/A";s:18:"customer_age_group";s:1:"0";s:25:"customer_tour_with_spouse";s:1:"0";s:23:"customer_already_toured";s:1:"0";s:37:"customer_travelled_within_12_mnths_wg";s:1:"0";s:35:"customer_travelled_with_other_party";s:1:"0";s:20:"customer_campaign_id";s:6:"403297";s:16:"customer_cc_type";s:3:"N/A";s:18:"customer_last_4_cc";s:0:"";}s:23:"ticketSearchInformation";a:2:{s:17:"ticketDestination";s:7:"ORLANDO";s:14:"ticketQuantity";s:1:"1";}s:4:"cart";a:4:{i:9350134910308588;a:10:{s:9:"productID";s:5:"97220";s:15:"productCategory";b:0;s:11:"productName";s:36:"1 DAY MYW MAGIC KINGDOM BASE - ADULT";s:18:"productDescription";s:0:"";s:11:"productType";s:6:"Ticket";s:3:"qty";s:1:"1";s:9:"unitPrice";s:6:"116.83";s:6:"others";a:4:{s:11:"retailPrice";s:6:"116.83";s:8:"nonPrice";s:6:"116.83";s:6:"saving";i:0;s:9:"tourPrice";i:0;}s:5:"total";d:116.83;s:13:"intAvailSeqId";s:0:"";}i:9060424439902714;a:10:{s:9:"productID";s:6:"120246";s:15:"productCategory";b:0;s:11:"productName";s:21:"1 HOUR PONTOON RENTAL";s:18:"productDescription";s:0:"";s:11:"productType";s:6:"Ticket";s:3:"qty";s:1:"1";s:9:"unitPrice";s:3:"118";s:6:"others";a:4:{s:11:"retailPrice";s:6:"133.13";s:8:"nonPrice";s:6:"133.13";s:6:"saving";d:15.130000000000001;s:9:"tourPrice";i:0;}s:5:"total";i:118;s:13:"intAvailSeqId";s:0:"";}i:6935627278200839;a:10:{s:9:"productID";s:28:"2155STM - 2 BEDROOM (SLPS 6)";s:15:"productCategory";b:0;s:11:"productName";s:15:"LEISURE RESORTS";s:18:"productDescription";s:0:"";s:11:"productType";s:5:"Hotel";s:3:"qty";s:1:"5";s:9:"unitPrice";s:4:"19.5";s:6:"others";a:9:{s:8:"roomType";s:24:"STM - 2 BEDROOM (SLPS 6)";s:7:"hotelId";s:4:"2155";s:11:"arrivalDate";s:11:"05-Aug-2015";s:6:"nights";s:1:"5";s:5:"guest";i:1;s:11:"retailPrice";s:1:"0";s:9:"tourPrice";i:0;s:8:"nonPrice";s:4:"19.5";s:6:"saving";d:-19.5;}s:5:"total";d:97.5;s:13:"intAvailSeqId";s:0:"";}i:8143560329338127;a:10:{s:9:"productID";s:25:"2367STM - 4 BEDROOM VILLA";s:15:"productCategory";b:0;s:11:"productName";s:16:"MAGICAL MEMORIES";s:18:"productDescription";s:0:"";s:11:"productType";s:5:"Hotel";s:3:"qty";s:1:"5";s:9:"unitPrice";s:5:"122.3";s:6:"others";a:9:{s:8:"roomType";s:21:"STM - 4 BEDROOM VILLA";s:7:"hotelId";s:4:"2367";s:11:"arrivalDate";s:11:"05-Aug-2015";s:6:"nights";s:1:"5";s:5:"guest";i:1;s:11:"retailPrice";s:3:"125";s:9:"tourPrice";i:0;s:8:"nonPrice";s:5:"122.3";s:6:"saving";d:2.7000000000000002;}s:5:"total";d:611.5;s:13:"intAvailSeqId";s:3:"NaN";}}s:22:"hotelSearchInformation";a:5:{s:14:"hotel_going_to";s:7:"ORLANDO";s:14:"hotel_check_in";s:11:"05-Aug-2015";s:15:"hotel_check_out";s:11:"10-Aug-2015";s:6:"nights";i:5;s:5:"guest";i:1;}}', 'https://api-services-qa.westgateresorts.com/pkg_sam_vacpac_pub_api.prc_online_booking?pnum_online_order_id=10014&pnum_marketing_campaign=403297&pchr_destination_id=ORLANDO&pchr_hotel_reservation_array=2155%2CSTM+-+2+BEDROOM+%28SLPS+6%29%2C05-Aug-2015%2C5%2C1%2C%2C0%2C-97.5%2C97.5%2C0%2C&pchr_customer_info_array=%2C%2C%2Cimtiaz%2Cpabel%2C%2C%2C1819534767%2C%2CDallas%2CDallas%2CDallas%2CGU%2C75002%2C%2CUS%2Cpabel%40test.com%2CEnglish&pchr_tickets_array=97220%2C1%2C116.83%2C0%2C116.83%21120246%2C1%2C133.13%2C15.13%2C118&pchr_travel_ins_array=&pchr_cc_type=&pnum_cc_number=&pnum_cc_exp=&pchr_cc_cardholder=&pnum_cc_charge_amount=&pnum_cc_cvv_number=&pnum_tour_discount=0.01', 'a:1:{s:13:"bookingResult";a:2:{s:7:"summary";a:5:{s:5:"order";s:5:"10014";s:6:"vacpac";s:7:"3140222";s:8:"prospect";s:8:"67264894";s:5:"price";s:7:"1092.41";s:6:"ccauth";a:0:{}}s:19:"confirmationDetails";a:3:{s:12:"customerInfo";a:3:{s:4:"name";s:12:"Imtiaz Pabel";s:7:"address";s:35:"DALLAS DALLAS DALLAS, GU 75002 USA";s:5:"email";s:14:"pabel@test.com";}s:7:"tickets";a:1:{s:10:"ticketInfo";a:2:{i:0;a:4:{s:8:"ticketId";s:5:"97220";s:10:"ticketDesc";s:36:"1 DAY MYW MAGIC KINGDOM BASE - ADULT";s:9:"ticketQty";s:1:"1";s:11:"ticketPrice";s:6:"116.83";}i:1;a:4:{s:8:"ticketId";s:6:"120246";s:10:"ticketDesc";s:21:"1 HOUR PONTOON RENTAL";s:9:"ticketQty";s:1:"1";s:11:"ticketPrice";s:3:"118";}}}s:12:"tourDiscount";a:1:{s:11:"discountAmt";s:3:".01";}}}}', '2015-07-28 06:31:16', '2015-07-28 06:32:59', 103, 'VacPac Script', 1, 1, '2015-07-28 18:32:59', '2015-07-28 18:32:59'),
  52. (5, 10015, 3140223, 3140223, 67264894, 0.00, 550, 490.80, 0.00, 53.20, 0.00, 490.80, 'a:8:{s:4:"user";s:14:"rqw23525asdf56";s:10:"slim.flash";a:0:{}s:16:"booking_activity";a:3:{s:7:"started";s:19:"2015-07-28 06:33:27";s:14:"campaign_begin";s:13:"VacPac Script";s:8:"finished";s:19:"2015-07-28 06:35:18";}s:8:"customer";a:23:{s:19:"customer_first_name";s:6:"imtiaz";s:18:"customer_last_name";s:5:"pabel";s:14:"customer_email";s:14:"pabel@test.com";s:17:"customer_address1";s:6:"Dallas";s:17:"customer_address2";s:6:"Dallas";s:14:"customer_phone";s:10:"1819534767";s:13:"customer_city";s:6:"Dallas";s:14:"customer_state";s:2:"GU";s:12:"customer_zip";s:5:"75002";s:16:"customer_country";s:2:"US";s:20:"customer_citizenship";s:13:"United States";s:24:"customer_no_of_travelers";s:3:" 2 ";s:23:"customer_martial_status";s:6:"Single";s:15:"customer_gender";s:1:"1";s:22:"customer_annual_income";s:3:"N/A";s:18:"customer_age_group";s:1:"0";s:25:"customer_tour_with_spouse";s:1:"0";s:23:"customer_already_toured";s:1:"0";s:37:"customer_travelled_within_12_mnths_wg";s:1:"0";s:35:"customer_travelled_with_other_party";s:1:"0";s:20:"customer_campaign_id";s:6:"403297";s:16:"customer_cc_type";s:3:"N/A";s:18:"customer_last_4_cc";s:0:"";}s:23:"ticketSearchInformation";a:1:{s:14:"ticketQuantity";i:1;}s:9:"cart_tour";b:0;s:24:"packageSearchInformation";a:6:{s:18:"packageDestination";s:7:"ORLANDO";s:13:"packageInDate";s:13:" 05-Aug-2015 ";s:14:"packageOutDate";s:13:" 10-Aug-2015 ";s:6:"nights";i:5;s:5:"guest";i:1;s:15:"packageQuantity";i:1;}s:4:"cart";a:2:{i:2903342456532419;a:10:{s:9:"productID";s:24:"2046STM - SUITE (SLPS 6)";s:15:"productCategory";s:4:"true";s:11:"productName";s:35:"COMFORT SUITES ORLANDO - MAJOR BLVD";s:18:"productDescription";s:0:"";s:11:"productType";s:5:"Hotel";s:3:"qty";s:1:"5";s:9:"unitPrice";s:5:"95.16";s:6:"others";a:9:{s:8:"roomType";s:20:"STM - SUITE (SLPS 6)";s:7:"hotelId";s:4:"2046";s:11:"arrivalDate";s:13:" 05-Aug-2015 ";s:6:"nights";s:1:"5";s:5:"guest";i:1;s:11:"retailPrice";s:5:"103.8";s:9:"tourPrice";i:0;s:8:"nonPrice";s:5:"95.16";s:6:"saving";d:8.6400000000000006;}s:5:"total";d:475.79999999999995;s:13:"intAvailSeqId";s:0:"";}i:2543282121575111;a:10:{s:9:"productID";s:5:"93616";s:15:"productCategory";s:4:"true";s:11:"productName";s:41:"$25 SMOKEHOUSE GRILL OR SERENITY SPA CERT";s:18:"productDescription";s:0:"";s:11:"productType";s:6:"Ticket";s:3:"qty";s:1:"1";s:9:"unitPrice";s:2:"15";s:6:"others";a:4:{s:11:"retailPrice";s:2:"25";s:8:"nonPrice";s:2:"25";s:6:"saving";i:10;s:9:"tourPrice";i:0;}s:5:"total";i:15;s:13:"intAvailSeqId";s:0:"";}}}', 'https://api-services-qa.westgateresorts.com/pkg_sam_vacpac_pub_api.prc_online_booking?pnum_online_order_id=10015&pnum_marketing_campaign=403297&pchr_destination_id=ORLANDO&pchr_hotel_reservation_array=2046%2CSTM+-+SUITE+%28SLPS+6%29%2C+05-Aug-2015+%2C5%2C1%2C%2C103.8%2C43.2%2C60.6%2C0%2C&pchr_customer_info_array=%2C%2C%2Cimtiaz%2Cpabel%2C%2C%2C1819534767%2C%2CDallas%2CDallas%2CDallas%2CGU%2C75002%2C%2CUS%2Cpabel%40test.com%2CEnglish&pchr_tickets_array=93616%2C1%2C25%2C10%2C15&pchr_travel_ins_array=&pchr_cc_type=&pnum_cc_number=&pnum_cc_exp=&pchr_cc_cardholder=&pnum_cc_charge_amount=&pnum_cc_cvv_number=&pnum_tour_discount=0.01', 'a:1:{s:13:"bookingResult";a:2:{s:7:"summary";a:5:{s:5:"order";s:5:"10015";s:6:"vacpac";s:7:"3140223";s:8:"prospect";s:8:"67264894";s:5:"price";s:6:"550.27";s:6:"ccauth";a:0:{}}s:19:"confirmationDetails";a:3:{s:12:"customerInfo";a:3:{s:4:"name";s:12:"Imtiaz Pabel";s:7:"address";s:35:"DALLAS DALLAS DALLAS, GU 75002 USA";s:5:"email";s:14:"pabel@test.com";}s:7:"tickets";a:1:{s:10:"ticketInfo";a:4:{s:8:"ticketId";s:5:"93616";s:10:"ticketDesc";s:41:"$25 SMOKEHOUSE GRILL OR SERENITY SPA CERT";s:9:"ticketQty";s:1:"1";s:11:"ticketPrice";s:2:"15";}}s:12:"tourDiscount";a:1:{s:11:"discountAmt";s:3:".01";}}}}', '2015-07-28 06:33:27', '2015-07-28 06:35:18', 111, 'VacPac Script', 1, 1, '2015-07-28 18:35:18', '2015-07-28 18:35:18'),
  53. (6, 10016, 3140224, 3140224, 67264894, 0.00, 31, 32.00, 0.00, 14.29, 0.00, 32.00, 'a:6:{s:4:"user";s:14:"rqw23525asdf56";s:10:"slim.flash";a:0:{}s:16:"booking_activity";a:2:{s:7:"started";s:19:"2015-07-28 06:35:29";s:8:"finished";s:19:"2015-07-28 06:35:53";}s:23:"ticketSearchInformation";a:2:{s:17:"ticketDestination";s:7:"ORLANDO";s:14:"ticketQuantity";s:1:"1";}s:4:"cart";a:2:{i:4551723516615917;a:10:{s:9:"productID";s:5:"93616";s:15:"productCategory";s:4:"true";s:11:"productName";s:41:"$25 SMOKEHOUSE GRILL OR SERENITY SPA CERT";s:18:"productDescription";s:0:"";s:11:"productType";s:6:"Ticket";s:3:"qty";s:1:"1";s:9:"unitPrice";s:2:"15";s:6:"others";a:4:{s:11:"retailPrice";s:2:"25";s:8:"nonPrice";s:2:"25";s:6:"saving";i:10;s:9:"tourPrice";i:0;}s:5:"total";i:15;s:13:"intAvailSeqId";s:0:"";}i:4909554933535358;a:10:{s:9:"productID";s:6:"130901";s:15:"productCategory";b:0;s:11:"productName";s:24:"1 DAY CRAYOLA EXPERIENCE";s:18:"productDescription";s:0:"";s:11:"productType";s:6:"Ticket";s:3:"qty";s:1:"1";s:9:"unitPrice";s:2:"17";s:6:"others";a:4:{s:11:"retailPrice";s:5:"21.29";s:8:"nonPrice";s:5:"21.29";s:6:"saving";d:4.29;s:9:"tourPrice";i:0;}s:5:"total";i:17;s:13:"intAvailSeqId";s:0:"";}}s:8:"customer";a:23:{s:19:"customer_first_name";s:6:"imtiaz";s:18:"customer_last_name";s:5:"pabel";s:14:"customer_email";s:14:"pabel@test.com";s:17:"customer_address1";s:6:"Dallas";s:17:"customer_address2";s:6:"Dallas";s:14:"customer_phone";s:10:"1819534767";s:13:"customer_city";s:6:"Dallas";s:14:"customer_state";s:2:"GU";s:12:"customer_zip";s:5:"75002";s:16:"customer_country";s:2:"US";s:20:"customer_citizenship";s:13:"United States";s:24:"customer_no_of_travelers";s:3:" 0 ";s:23:"customer_martial_status";s:6:"Single";s:15:"customer_gender";s:1:"1";s:22:"customer_annual_income";s:3:"N/A";s:18:"customer_age_group";s:1:"0";s:25:"customer_tour_with_spouse";s:1:"0";s:23:"customer_already_toured";s:1:"0";s:37:"customer_travelled_within_12_mnths_wg";s:1:"0";s:35:"customer_travelled_with_other_party";s:1:"0";s:20:"customer_campaign_id";s:6:"403297";s:16:"customer_cc_type";s:3:"N/A";s:18:"customer_last_4_cc";s:0:"";}}', 'https://api-services-qa.westgateresorts.com/pkg_sam_vacpac_pub_api.prc_online_booking?pnum_online_order_id=10016&pnum_marketing_campaign=403297&pchr_destination_id=ORLANDO&pchr_hotel_reservation_array=&pchr_customer_info_array=%2C%2C%2Cimtiaz%2Cpabel%2C%2C%2C1819534767%2C%2CDallas%2CDallas%2CDallas%2CGU%2C75002%2C%2CUS%2Cpabel%40test.com%2CEnglish&pchr_tickets_array=93616%2C1%2C25%2C10%2C15%21130901%2C1%2C21.29%2C4.29%2C17&pchr_travel_ins_array=&pchr_cc_type=&pnum_cc_number=&pnum_cc_exp=&pchr_cc_cardholder=&pnum_cc_charge_amount=&pnum_cc_cvv_number=&pnum_tour_discount=0.01', 'a:1:{s:13:"bookingResult";a:2:{s:7:"summary";a:5:{s:5:"order";s:5:"10016";s:6:"vacpac";s:7:"3140224";s:8:"prospect";s:8:"67264894";s:5:"price";s:5:"31.99";s:6:"ccauth";a:0:{}}s:19:"confirmationDetails";a:3:{s:12:"customerInfo";a:3:{s:4:"name";s:12:"Imtiaz Pabel";s:7:"address";s:35:"DALLAS DALLAS DALLAS, GU 75002 USA";s:5:"email";s:14:"pabel@test.com";}s:7:"tickets";a:1:{s:10:"ticketInfo";a:2:{i:0;a:4:{s:8:"ticketId";s:5:"93616";s:10:"ticketDesc";s:41:"$25 SMOKEHOUSE GRILL OR SERENITY SPA CERT";s:9:"ticketQty";s:1:"1";s:11:"ticketPrice";s:2:"15";}i:1;a:4:{s:8:"ticketId";s:6:"130901";s:10:"ticketDesc";s:24:"1 DAY CRAYOLA EXPERIENCE";s:9:"ticketQty";s:1:"1";s:11:"ticketPrice";s:2:"17";}}}s:12:"tourDiscount";a:1:{s:11:"discountAmt";s:3:".01";}}}}', '2015-07-28 06:35:29', '2015-07-28 06:35:53', 24, '', 1, 1, '2015-07-28 18:35:53', '2015-07-28 18:35:53');
  54.  
  55. --
  56. -- Dumping data for table `package_ticket`
  57. --
  58.  
  59. INSERT INTO `package_ticket` (`id`, `inventory_id`, `brand`, `name`, `description`, `destination`, `gate_price`, `price`, `cost`, `created_at`, `updated_at`) VALUES
  60. (1, 93616, NULL, '$25 SMOKEHOUSE GRILL OR SERENITY SPA CERT', 'SMOKEHOUSE GRILL: Enjoy breakfast or dinner at the award winning Westgate Smokehouse Grill. The menu offers a variety of entrees. A childs menu is also available. (407) 352-7933. SERENITY SPA: Pamper & spoil yourself in a relaxing haven with the finest ', 'ORLANDO', 25.00, 25.00, 18.75, '2015-07-28 18:34:49', '2015-07-28 18:34:49');
  61.  
  62. --
  63. -- Dumping data for table `package_ticket_pricing`
  64. --
  65.  
  66. INSERT INTO `package_ticket_pricing` (`id`, `ticket_id`, `inventory_id`, `quantity`, `price`, `user_id`, `created_at`, `updated_at`) VALUES
  67. (1, 1, 93616, 1, 15.00, 1, '2015-07-28 18:34:49', '2015-07-28 18:34:49');
  68.  
  69. --
  70. -- Dumping data for table `propel_migration`
  71. --
  72.  
  73. INSERT INTO `propel_migration` (`version`) VALUES
  74. (1438089681);
  75.  
  76. --
  77. -- Dumping data for table `ticket_hotel`
  78. --
  79.  
  80. INSERT INTO `ticket_hotel` (`id`, `product_id`, `name`, `description`, `type`, `destination`, `arrival_date`, `departure_date`, `quantity`, `unit_price`, `retail_price`, `non_tour_retail_price`, `saving`, `tour_price`, `total`, `created_at`, `updated_at`) VALUES
  81. (1, NULL, '1 DAY CRAYOLA EXPERIENCE', '', 'Ticket', NULL, NULL, NULL, 1, 17, 21.29, 21.29, 4.29, 0, 17, '2015-07-28 18:24:01', '2015-07-28 18:24:01'),
  82. (2, NULL, '1 DAY MYW HOPPER + WATER PARK FUN & MORE - ADULT', '', 'Ticket', NULL, NULL, NULL, 1, 212.68, 212.68, 212.68, 0, 0, 212.68, '2015-07-28 18:24:35', '2015-07-28 18:24:35'),
  83. (3, NULL, '1 DAY BUSCH GARDENS WEEKDAY ADMISSION', '', 'Ticket', NULL, NULL, NULL, 1, 94, 103.79, 103.79, 9.79, 0, 94, '2015-07-28 18:30:32', '2015-07-28 18:30:32'),
  84. (4, NULL, '1 DAY MAGIC YOUR WAY + HOPPER - CHILD', '', 'Ticket', NULL, NULL, NULL, 1, 163.69, 163.69, 163.69, 0, 0, 163.69, '2015-07-28 18:31:09', '2015-07-28 18:31:09'),
  85. (5, NULL, '1 DAY MYW MAGIC KINGDOM BASE - ADULT', '', 'Ticket', NULL, NULL, NULL, 1, 116.83, 116.83, 116.83, 0, 0, 116.83, '2015-07-28 18:32:59', '2015-07-28 18:32:59'),
  86. (6, NULL, '1 HOUR PONTOON RENTAL', '', 'Ticket', NULL, NULL, NULL, 1, 118, 133.13, 133.13, 15.13, 0, 118, '2015-07-28 18:32:59', '2015-07-28 18:32:59'),
  87. (7, NULL, 'LEISURE RESORTS', '', 'Hotel', 'ORLANDO', '2015-08-05', '2015-08-10', 5, 19.5, 0, 19.5, -19.5, 0, 97.5, '2015-07-28 18:32:59', '2015-07-28 18:32:59'),
  88. (8, NULL, 'MAGICAL MEMORIES', '', 'Hotel', 'ORLANDO', '2015-08-05', '2015-08-10', 5, 122.3, 125, 122.3, 2.7, 0, 611.5, '2015-07-28 18:32:59', '2015-07-28 18:32:59'),
  89. (9, NULL, '$25 SMOKEHOUSE GRILL OR SERENITY SPA CERT', '', 'Ticket', NULL, NULL, NULL, 1, 15, 25, 25, 10, 0, 15, '2015-07-28 18:35:53', '2015-07-28 18:35:53'),
  90. (10, NULL, '1 DAY CRAYOLA EXPERIENCE', '', 'Ticket', NULL, NULL, NULL, 1, 17, 21.29, 21.29, 4.29, 0, 17, '2015-07-28 18:35:53', '2015-07-28 18:35:53');
  91.  
  92. --
  93. -- Dumping data for table `user`
  94. --
  95.  
  96. INSERT INTO `user` (`id`, `uuid`, `email`, `password`, `first_name`, `last_name`, `role`, `created_at`, `updated_at`) VALUES
  97. (1, 'rqw23525asdf56', 'info@miteksoftware.com', '$2y$10$mETHeJDX9K8Re7rDBVnZ/OoUEW.QZzPrcgBSSjmal/P6V39Bl0k0u', 'MiTek Software', 'Solutions', 5, NULL, NULL);
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!