var unreadAlerts = '1';
You have one unread private message from dkota titled Welcome to the Forum!

megacabs.com - 4/4 - 7K records [travel bookings]
#1
Hello, this is the final part of the megacabs.com db. All of their trip booking reports w customer info.

samples:
Code:
{'id': 487191, 'megaCabsBookingNo': 'KK1117044581', 'financialYearId': 8, 'serviceCityId': 3, 'currentTripStatusType': 'Complete', 'bookingViaType': 'MobileApp', 'custName': 'Bilton Kumar das', 'custMobile': '9883091063', 'custAlternateNo': '9883091063', 'custEmail': 'bilton82@gmail.com', 'pickUpDateTime': '2017-11-23T11:23:59+05:30', 'pickUpAddress': '20, SN Banerjee Rd, Shyampur, Budge Budge, Kolkata, West Bengal 700137, India', 'pickUpZoneId': 3, 'pickUpZoneName': 'Kolkata', 'pickUpSuburb': None, 'pickUpNearestLandmark': None, 'pickUpLat': 22.48921584, 'pickUpLng': 88.19581043, 'destAddress': '104, Nabapalli Circular Rd, Surendranath Colony, Laxmi Narayan Colony, Chkravartipara, Nabapally, Kolkata, West Bengal 700126, India', 'destSuburb': None, 'destNearestLandmark': None, 'destLat': 22.7235098, 'destLng': 88.4722845, 'isCorporateBooking': False, 'companyName': None, 'loyaltyTokenNumber': None, 'isPackaged': False, 'packagingId': None, 'packageName': None, 'packageType': None, 'isAutoAssigned': False, 'driverAssignedById': 3444, 'driverAssignedByUserType': 'Dispatcher', 'driverId': 4397, 'driverName': 'KAMTA PRASAD YADAV', 'driverMobileNo': '9903246830', 'driverAssignOn': '2017-11-23T10:32:20+05:30', 'carNo': 'WB05-1749', 'carTypeId': 0, 'carType': 'Sedan', 'paymentModeType': 'Cash', 'tripStartTime': '2017-11-23T11:23:59+05:30', 'tripEndTime': '2017-11-23T15:00:17+05:30', 'estimatedDistanceInKm': None, 'estimatedFare': None, 'cancelReason': None, 'cancelReasonRemarks': None, 'cancelReasonCode': None, 'cancelById': None, 'canceledByUserType': None, 'isDeleted': False, 'deletedOn': None, 'deletedById': None, 'ratingCustomer': 5, 'ratingCustomerPostedOn': '2017-11-23T15:02:27+05:30', 'ratingDriver': None, 'ratingDriverPostedOn': None, 'ratingCustomerRemark': '', 'ratingDriverRemark': None, 'rideType': 'RideLater', 'carId': 717, 'bookingTime': '2017-11-23T02:50:46+05:30', 'tripImageUrl': 'https://media.megacabs.com/img/b/e/beb51f958accabfc9c2ad95eb017f90c.png', 'tripImageUrlContentType': None, 'isHighRisk': False, 'isVip': False, 'isInternational': False, 'loyaltyProgramType': None, 'loyaltyProgramNumber': None, 'cancelledOn': None, 'corporateBookingTokenNumber': None, 'integratorId': None, 'integratorName': 'MegaCabs', 'remark': None, 'isMeterConnected': False, 'bookingViaDeviceType': 'Android', 'isShortDistance': False, 'isDriverConfirmed': None, 'isMojoSent': False, 'paymentRequestId': None, 'instaWebhookData': None, 'biddingTime': '2017-11-23T10:10:00+05:30', 'isDistanceCalcByGoogle': False, 'fareUpdatedByAdmin': False, 'customer': {'id': 450647, 'userId': 9067, 'fullName': 'Bilton Kumar das', 'email': 'bilton82@gmail.com', 'mobile': '9883091063', 'dob': None, 'gender': None, 'marriageAniversary': None, 'addressLine': '79/1', 'city': 'Kolkata', 'pincode': None, 'state': None, 'country': None, 'phone1': None, 'phone2': None, 'fax': None, 'avatarUrl': None, 'avatarUrlContentType': None, 'isInternational': False, 'isVip': False, 'vipCategory': None, 'isRegistered': True, 'isCorporateAccount': False, 'noOfBookingsMade': None, 'noOfCancellationsMade': None, 'totalRevenueEarned': None, 'isBlacklisted': False, 'ratingSum': 66, 'ratingCount': 15, 'ratingAvg': 4.4, 'createdViaType': 'MobileApp', 'createdOn': '2017-02-23T13:14:53+05:30', 'deviceType': None, 'createdById': 9067, 'isDeleted': False, 'deletedOn': None, 'deletedById': None, 'facebookUrl': None, 'twitterUrl': None, 'linkedInUrl': None, 'isZohoUploaded': True, 'registeredLat': None, 'registeredLng': None, 'registeredServicecity': None, 'corporateClient': None, 'tags': []}, 'corporateClient': None, 'booking': {'id': 301974, 'megaCabsBookingNo': 'KK1117044581', 'serviceCityId': 3, 'financialYearId': 8, 'currentBookingStatusType': 'Completed', 'bookingViaType': 'MobileApp', 'custId': 450647, 'custName': 'Bilton Kumar das', 'custMobile': '9883091063', 'custAlternateNo': '9883091063', 'custEmail': 'bilton82@gmail.com', 'pickUpDateTime': '2017-11-23T11:23:59+05:30', 'pickUpAddress': '20, SN Banerjee Rd, Shyampur, Budge Budge, Kolkata, West Bengal 700137, India', 'pickUpZoneId': 3, 'pickUpZoneName': 'Kolkata', 'pickUpSuburb': None, 'pickUpNearestLandmark': None, 'pickUpLat': 22.48921584, 'pickUpLng': 88.19581043, 'destAddress': 'Not Available', 'destSuburb': None, 'destNearestLandmark': None, 'destLat': 22.7235098, 'destLng': 88.4722845, 'bookedFromIpAddress': '202.142.117.104', 'packageId': None, 'packageName': None, 'isCompanyBooking': False, 'corporateClientId': None, 'companyName': None, 'carTypeId': None, 'paymentModeType': 'Cash', 'canceledOn': None, 'cancelReason': None, 'cancelReasonRemarks': None, 'canceledById': None, 'canceledByUserType': None, 'createdOn': '2017-11-23T02:50:46+05:30', 'createdById': 9067, 'createdByUserType': 'Customer', 'serviceCityName': 'Kolkatta', 'financialYear': 'FY2017-2018', 'carType': 'Sedan', 'rideType': 'RideLater', 'isHighRisk': False, 'isVip': False, 'isInternational': False, 'loyaltyProgramType': None, 'loyaltyProgramNumber': None, 'corporateBookingTokenNumber': None, 'integratorId': None, 'integratorName': 'MegaCabs', 'remark': None, 'bookingViaDeviceType': 'Android', 'isShortDistance': False, 'viaSms': None, 'alertToTMS': None, 'isConvenienceApply': True, 'tags': [], 'imageUrl': 'https://media.megacabs.com/img/b/e/beb51f958accabfc9c2ad95eb017f90c.png', 'biddingTime': '2017-11-23T10:10:00+05:30', 'websiteRefererId': None, 'websiteRefererUrl': None, 'thirdPartySettings': None, 'airportBookingRemarks': None, 'mmtReferenceId': None, 'isMmt': False, 'thirdpartyBookingRequest': None, 'airportTerminal': None, 'bookingTotalFare': None, 'bookingTotalDistance': None, 'bookingClientAdvance': None, 'isPartPayment': False, 'isFlatNightCharges': False, 'flatNightCharges': None, 'estimatedEndTime': None, 'isOnTripAssigned': False, 'custAlternateEmail': None, 'isMoveToComplete': False, 'isAssignLogoutDriver': False}, 'tags': [], 'airportBookingRemarks': None, 'appVersion': None, 'deviceModel': None, 'googleEstimatedKM': None, 'gpsKM': None, 'vendor': None},
{'id': 500085, 'megaCabsBookingNo': 'AM1117043487', 'financialYearId': 8, 'serviceCityId': 8, 'currentTripStatusType': 'Complete', 'bookingViaType': 'CustomerService', 'custName': 'mani kapoor', 'custMobile': '9878081565', 'custAlternateNo': None, 'custEmail': None, 'pickUpDateTime': '2017-11-25T23:38:55+05:30', 'pickUpAddress': 'Gali Number 3, Batala Rd, Main Bazar, New Pavan Nagar, Pawan Nagar, Amritsar, Punjab 143001, India', 'pickUpZoneId': 8, 'pickUpZoneName': 'Amritsar', 'pickUpSuburb': None, 'pickUpNearestLandmark': 'PAWAN NAGAR DAMOHI MANDIR', 'pickUpLat': 31.6373878, 'pickUpLng': 74.8956654, 'destAddress': 'Amritsar Jn FOB, Guru Arjun Nagar, Putligarh, Amritsar, Punjab 143001, India', 'destSuburb': None, 'destNearestLandmark': None, 'destLat': 31.6339396, 'destLng': 74.867821, 'isCorporateBooking': False, 'companyName': None, 'loyaltyTokenNumber': None, 'isPackaged': False, 'packagingId': None, 'packageName': None, 'packageType': None, 'isAutoAssigned': False, 'driverAssignedById': 8821, 'driverAssignedByUserType': 'ShiftIncharge', 'driverId': 942, 'driverName': 'Amrik Singh', 'driverMobileNo': '8146175241', 'driverAssignOn': '2017-11-25T23:03:31+05:30', 'carNo': 'PB-02-CC-6612', 'carTypeId': 0, 'carType': 'Sedan', 'paymentModeType': 'Cash', 'tripStartTime': '2017-11-25T23:38:55+05:30', 'tripEndTime': '2017-11-25T23:45:33+05:30', 'estimatedDistanceInKm': None, 'estimatedFare': None, 'cancelReason': None, 'cancelReasonRemarks': None, 'cancelReasonCode': None, 'cancelById': None, 'canceledByUserType': None, 'isDeleted': False, 'deletedOn': None, 'deletedById': None, 'ratingCustomer': 5, 'ratingCustomerPostedOn': '2017-11-25T23:46:02+05:30', 'ratingDriver': 5, 'ratingDriverPostedOn': '2017-11-26T14:13:21+05:30', 'ratingCustomerRemark': '', 'ratingDriverRemark': '', 'rideType': 'RideLater', 'carId': 2315, 'bookingTime': '2017-11-25T16:47:50+05:30', 'tripImageUrl': 'https://media.megacabs.com/img/8/f/8f2447ebd1e5511bdaecb29a515f9eec.png', 'tripImageUrlContentType': None, 'isHighRisk': False, 'isVip': False, 'isInternational': False, 'loyaltyProgramType': None, 'loyaltyProgramNumber': None, 'cancelledOn': None, 'corporateBookingTokenNumber': None, 'integratorId': None, 'integratorName': 'MegaCabs', 'remark': None, 'isMeterConnected': False, 'bookingViaDeviceType': 'Customer Service', 'isShortDistance': False, 'isDriverConfirmed': None, 'isMojoSent': False, 'paymentRequestId': None, 'instaWebhookData': None, 'biddingTime': '2017-11-25T23:00:00+05:30', 'isDistanceCalcByGoogle': False, 'fareUpdatedByAdmin': False, 'customer': {'id': 908949, 'userId': 39486, 'fullName': 'Manni', 'email': 'manni_kapoor@hotmail.com', 'mobile': '9878081565', 'dob': None, 'gender': 'M', 'marriageAniversary': None, 'addressLine': None, 'city': None, 'pincode': None, 'state': None, 'country': None, 'phone1': None, 'phone2': None, 'fax': None, 'avatarUrl': None, 'avatarUrlContentType': None, 'isInternational': False, 'isVip': False, 'vipCategory': None, 'isRegistered': True, 'isCorporateAccount': False, 'noOfBookingsMade': None, 'noOfCancellationsMade': None, 'totalRevenueEarned': None, 'isBlacklisted': False, 'ratingSum': 5, 'ratingCount': 1, 'ratingAvg': 5.0, 'createdViaType': 'MobileApp', 'createdOn': None, 'deviceType': None, 'createdById': 39486, 'isDeleted': False, 'deletedOn': None, 'deletedById': None, 'facebookUrl': None, 'twitterUrl': None, 'linkedInUrl': None, 'isZohoUploaded': False, 'registeredLat': None, 'registeredLng': None, 'registeredServicecity': None, 'corporateClient': None, 'tags': []}, 'corporateClient': None, 'booking': {'id': 306534, 'megaCabsBookingNo': 'AM1117043487', 'serviceCityId': 8, 'financialYearId': 8, 'currentBookingStatusType': 'Completed', 'bookingViaType': 'CustomerService', 'custId': 908949, 'custName': 'mani kapoor', 'custMobile': '9878081565', 'custAlternateNo': None, 'custEmail': None, 'pickUpDateTime': '2017-11-25T23:38:55+05:30', 'pickUpAddress': 'Gali Number 3, Batala Rd, Main Bazar, New Pavan Nagar, Pawan Nagar, Amritsar, Punjab 143001, India', 'pickUpZoneId': 8, 'pickUpZoneName': 'Amritsar', 'pickUpSuburb': None, 'pickUpNearestLandmark': 'PAWAN NAGAR DAMOHI MANDIR', 'pickUpLat': 31.6373878, 'pickUpLng': 74.8956654, 'destAddress': 'Not Available', 'destSuburb': None, 'destNearestLandmark': None, 'destLat': 31.6339396, 'destLng': 74.867821, 'bookedFromIpAddress': '180.151.87.58', 'packageId': None, 'packageName': None, 'isCompanyBooking': False, 'corporateClientId': None, 'companyName': None, 'carTypeId': 1, 'paymentModeType': 'Cash', 'canceledOn': None, 'cancelReason': None, 'cancelReasonRemarks': None, 'canceledById': None, 'canceledByUserType': None, 'createdOn': '2017-11-25T16:47:50+05:30', 'createdById': 5561, 'createdByUserType': 'CallTaker', 'serviceCityName': 'Amritsar', 'financialYear': 'FY2017-2018', 'carType': 'Sedan', 'rideType': 'RideLater', 'isHighRisk': False, 'isVip': False, 'isInternational': False, 'loyaltyProgramType': None, 'loyaltyProgramNumber': None, 'corporateBookingTokenNumber': None, 'integratorId': None, 'integratorName': 'MegaCabs', 'remark': None, 'bookingViaDeviceType': 'Customer Service', 'isShortDistance': False, 'viaSms': None, 'alertToTMS': None, 'isConvenienceApply': True, 'tags': [], 'imageUrl': 'https://media.megacabs.com/img/8/f/8f2447ebd1e5511bdaecb29a515f9eec.png', 'biddingTime': '2017-11-25T23:00:00+05:30', 'websiteRefererId': None, 'websiteRefererUrl': None, 'thirdPartySettings': None, 'airportBookingRemarks': None, 'mmtReferenceId': None, 'isMmt': False, 'thirdpartyBookingRequest': None, 'airportTerminal': None, 'bookingTotalFare': None, 'bookingTotalDistance': None, 'bookingClientAdvance': None, 'isPartPayment': False, 'isFlatNightCharges': False, 'flatNightCharges': None, 'estimatedEndTime': None, 'isOnTripAssigned': False, 'custAlternateEmail': None, 'isMoveToComplete': False, 'isAssignLogoutDriver': False}, 'tags': [], 'airportBookingRemarks': None, 'appVersion': None, 'deviceModel': None, 'googleEstimatedKM': None, 'gpsKM': None, 'vendor': None},
{'id': 532578, 'megaCabsBookingNo': 'DL1217145714', 'financialYearId': 8, 'serviceCityId': 1, 'currentTripStatusType': 'Complete', 'bookingViaType': 'BookingWeb', 'custName': 'Anupam Singh', 'custMobile': '9971063332', 'custAlternateNo': None, 'custEmail': 'anupampsingh@gmail.com', 'pickUpDateTime': '2017-12-04T00:17:24+05:30', 'pickUpAddress': '', 'pickUpZoneId': 1, 'pickUpZoneName': 'Delhi', 'pickUpSuburb': None, 'pickUpNearestLandmark': 'G-1403', 'pickUpLat': 28.5134725, 'pickUpLng': 77.4072593, 'destAddress': 'Terminal 1D Departure Rd, Indira Gandhi International Airport, New Delhi, Delhi 110037, India', 'destSuburb': None, 'destNearestLandmark': None, 'destLat': 28.5625802, 'destLng': 77.1201041, 'isCorporateBooking': False, 'companyName': None, 'loyaltyTokenNumber': None, 'isPackaged': False, 'packagingId': None, 'packageName': None, 'packageType': None, 'isAutoAssigned': False, 'driverAssignedById': 3468, 'driverAssignedByUserType': 'ShiftIncharge', 'driverId': 2407, 'driverName': 'DESHRAJ CHOURASIA', 'driverMobileNo': '9582879425', 'driverAssignOn': '2017-12-03T23:22:48+05:30', 'carNo': 'DL1RY6089', 'carTypeId': 0, 'carType': 'Sedan', 'paymentModeType': 'Cash', 'tripStartTime': '2017-12-04T00:17:24+05:30', 'tripEndTime': '2017-12-04T01:00:18+05:30', 'estimatedDistanceInKm': None, 'estimatedFare': None, 'cancelReason': None, 'cancelReasonRemarks': None, 'cancelReasonCode': None, 'cancelById': None, 'canceledByUserType': None, 'isDeleted': False, 'deletedOn': None, 'deletedById': None, 'ratingCustomer': 5, 'ratingCustomerPostedOn': '2017-12-04T01:00:37+05:30', 'ratingDriver': None, 'ratingDriverPostedOn': None, 'ratingCustomerRemark': '', 'ratingDriverRemark': None, 'rideType': 'RideLater', 'carId': 9095, 'bookingTime': '2017-12-02T13:27:36+05:30', 'tripImageUrl': 'https://media.megacabs.com/img/0/9/097114f4cb42277b8d273cd2236a4602.png', 'tripImageUrlContentType': None, 'isHighRisk': False, 'isVip': None, 'isInternational': False, 'loyaltyProgramType': None, 'loyaltyProgramNumber': None, 'cancelledOn': None, 'corporateBookingTokenNumber': None, 'integratorId': None, 'integratorName': 'MegaCabs', 'remark': None, 'isMeterConnected': False, 'bookingViaDeviceType': 'iOS', 'isShortDistance': False, 'isDriverConfirmed': None, 'isMojoSent': False, 'paymentRequestId': None, 'instaWebhookData': None, 'biddingTime': '2017-12-03T23:15:00+05:30', 'isDistanceCalcByGoogle': False, 'fareUpdatedByAdmin': False, 'customer': {'id': 868110, 'userId': 40737, 'fullName': 'Anupam Singh', 'email': 'anupampsingh@gmail.com', 'mobile': '9971063332', 'dob': None, 'gender': None, 'marriageAniversary': None, 'addressLine': None, 'city': None, 'pincode': None, 'state': None, 'country': None, 'phone1': None, 'phone2': None, 'fax': None, 'avatarUrl': None, 'avatarUrlContentType': None, 'isInternational': False, 'isVip': False, 'vipCategory': None, 'isRegistered': True, 'isCorporateAccount': False, 'noOfBookingsMade': None, 'noOfCancellationsMade': None, 'totalRevenueEarned': None, 'isBlacklisted': False, 'ratingSum': 10, 'ratingCount': 2, 'ratingAvg': 5.0, 'createdViaType': 'MobileApp', 'createdOn': '2017-10-14T18:53:28+05:30', 'deviceType': None, 'createdById': 40737, 'isDeleted': False, 'deletedOn': None, 'deletedById': None, 'facebookUrl': None, 'twitterUrl': None, 'linkedInUrl': None, 'isZohoUploaded': True, 'registeredLat': None, 'registeredLng': None, 'registeredServicecity': None, 'corporateClient': None, 'tags': []}, 'corporateClient': None, 'booking': {'id': 316299, 'megaCabsBookingNo': 'DL1217145714', 'serviceCityId': 1, 'financialYearId': 8, 'currentBookingStatusType': 'Completed', 'bookingViaType': 'BookingWeb', 'custId': 868110, 'custName': '9971063332', 'custMobile': '9971063332', 'custAlternateNo': None, 'custEmail': '', 'pickUpDateTime': '2017-12-04T00:17:24+05:30', 'pickUpAddress': '', 'pickUpZoneId': 1, 'pickUpZoneName': 'Delhi', 'pickUpSuburb': None, 'pickUpNearestLandmark': 'G-1403', 'pickUpLat': 28.5134725, 'pickUpLng': 77.4072593, 'destAddress': 'Not Available', 'destSuburb': None, 'destNearestLandmark': None, 'destLat': 28.5625802, 'destLng': 77.1201041, 'bookedFromIpAddress': '103.219.230.107', 'packageId': None, 'packageName': None, 'isCompanyBooking': False, 'corporateClientId': None, 'companyName': None, 'carTypeId': 1, 'paymentModeType': 'Cash', 'canceledOn': None, 'cancelReason': None, 'cancelReasonRemarks': None, 'canceledById': None, 'canceledByUserType': None, 'createdOn': '2017-12-02T13:27:36+05:30', 'createdById': 2, 'createdByUserType': 'Admin', 'serviceCityName': 'Delhi', 'financialYear': 'FY2017-2018', 'carType': 'Sedan', 'rideType': 'RideLater', 'isHighRisk': False, 'isVip': None, 'isInternational': False, 'loyaltyProgramType': None, 'loyaltyProgramNumber': None, 'corporateBookingTokenNumber': None, 'integratorId': None, 'integratorName': 'MegaCabs', 'remark': None, 'bookingViaDeviceType': 'iOS', 'isShortDistance': False, 'viaSms': None, 'alertToTMS': None, 'isConvenienceApply': True, 'tags': [], 'imageUrl': 'https://media.megacabs.com/img/0/9/097114f4cb42277b8d273cd2236a4602.png', 'biddingTime': '2017-12-03T23:15:00+05:30', 'websiteRefererId': None, 'websiteRefererUrl': None, 'thirdPartySettings': None, 'airportBookingRemarks': None, 'mmtReferenceId': None, 'isMmt': False, 'thirdpartyBookingRequest': None, 'airportTerminal': None, 'bookingTotalFare': None, 'bookingTotalDistance': None, 'bookingClientAdvance': None, 'isPartPayment': False, 'isFlatNightCharges': False, 'flatNightCharges': None, 'estimatedEndTime': None, 'isOnTripAssigned': False, 'custAlternateEmail': None, 'isMoveToComplete': False, 'isAssignLogoutDriver': False}, 'tags': [], 'airportBookingRemarks': None, 'appVersion': None, 'deviceModel': None, 'googleEstimatedKM': None, 'gpsKM': None, 'vendor': None},
{'id': 556026, 'megaCabsBookingNo': 'AM1217046502', 'financialYearId': 8, 'serviceCityId': 8, 'currentTripStatusType': 'Cancelled', 'bookingViaType': 'CustomerService', 'custName': 'gaurav  9818777379', 'custMobile': '9818777379', 'custAlternateNo': None, 'custEmail': 'matrixma.gaurav@gmail.com', 'pickUpDateTime': '2017-12-09T08:30:00+05:30', 'pickUpAddress': 'Hyatt Amritsar, Amritsar, Punjab, India', 'pickUpZoneId': 8, 'pickUpZoneName': 'Amritsar', 'pickUpSuburb': None, 'pickUpNearestLandmark': None, 'pickUpLat': 31.618922, 'pickUpLng': 74.908819, 'destAddress': 'Radisson Blu Hotel Amritsar, Amritsar, Punjab, India', 'destSuburb': None, 'destNearestLandmark': None, 'destLat': 31.70583, 'destLng': 74.81889, 'isCorporateBooking': False, 'companyName': None, 'loyaltyTokenNumber': None, 'isPackaged': False, 'packagingId': None, 'packageName': None, 'packageType': None, 'isAutoAssigned': False, 'driverAssignedById': 8821, 'driverAssignedByUserType': 'ShiftIncharge', 'driverId': 1768, 'driverName': 'Harpreet Singh VI', 'driverMobileNo': '8558839636', 'driverAssignOn': '2017-12-09T08:16:07+05:30', 'carNo': 'PB-02-CC-9395', 'carTypeId': 0, 'carType': 'Sedan', 'paymentModeType': 'Cash', 'tripStartTime': None, 'tripEndTime': None, 'estimatedDistanceInKm': None, 'estimatedFare': None, 'cancelReason': 'done 9395', 'cancelReasonRemarks': None, 'cancelReasonCode': 'Other', 'cancelById': 8821, 'canceledByUserType': 'ShiftIncharge', 'isDeleted': False, 'deletedOn': None, 'deletedById': None, 'ratingCustomer': None, 'ratingCustomerPostedOn': None, 'ratingDriver': None, 'ratingDriverPostedOn': None, 'ratingCustomerRemark': None, 'ratingDriverRemark': None, 'rideType': 'RideLater', 'carId': 2258, 'bookingTime': '2017-12-09T08:14:38+05:30', 'tripImageUrl': 'https://media.megacabs.com/img/7/5/7562f2924bf31ea32010d2cd2d295ffa.png', 'tripImageUrlContentType': None, 'isHighRisk': False, 'isVip': False, 'isInternational': False, 'loyaltyProgramType': None, 'loyaltyProgramNumber': None, 'cancelledOn': '2017-12-09T09:15:00+05:30', 'corporateBookingTokenNumber': None, 'integratorId': None, 'integratorName': 'MegaCabs', 'remark': None, 'isMeterConnected': False, 'bookingViaDeviceType': 'Customer Service', 'isShortDistance': False, 'isDriverConfirmed': None, 'isMojoSent': False, 'paymentRequestId': None, 'instaWebhookData': None, 'biddingTime': '2017-12-09T08:00:00+05:30', 'isDistanceCalcByGoogle': False, 'fareUpdatedByAdmin': False, 'customer': {'id': 763155, 'userId': 9533, 'fullName': 'gaurav  9818777379', 'email': 'matrixma.gaurav@gmail.com', 'mobile': '9818777379', 'dob': '1970-01-01', 'gender': 'M', 'marriageAniversary': '1970-01-01', 'addressLine': None, 'city': None, 'pincode': None, 'state': None, 'country': None, 'phone1': None, 'phone2': None, 'fax': None, 'avatarUrl': None, 'avatarUrlContentType': None, 'isInternational': False, 'isVip': False, 'vipCategory': None, 'isRegistered': True, 'isCorporateAccount': False, 'noOfBookingsMade': None, 'noOfCancellationsMade': None, 'totalRevenueEarned': None, 'isBlacklisted': False, 'ratingSum': 17, 'ratingCount': 4, 'ratingAvg': 4.25, 'createdViaType': 'Website', 'createdOn': None, 'deviceType': None, 'createdById': 9533, 'isDeleted': False, 'deletedOn': None, 'deletedById': None, 'facebookUrl': None, 'twitterUrl': None, 'linkedInUrl': None, 'isZohoUploaded': False, 'registeredLat': None, 'registeredLng': None, 'registeredServicecity': None, 'corporateClient': None, 'tags': []}, 'corporateClient': None, 'booking': {'id': 327129, 'megaCabsBookingNo': 'AM1217046502', 'serviceCityId': 8, 'financialYearId': 8, 'currentBookingStatusType': 'Cancelled', 'bookingViaType': 'CustomerService', 'custId': 763155, 'custName': 'gaurav  9818777379', 'custMobile': '9818777379', 'custAlternateNo': None, 'custEmail': 'matrixma.gaurav@gmail.com', 'pickUpDateTime': '2017-12-09T08:30:00+05:30', 'pickUpAddress': 'Hyatt Amritsar, Amritsar, Punjab, India', 'pickUpZoneId': 8, 'pickUpZoneName': 'Amritsar', 'pickUpSuburb': None, 'pickUpNearestLandmark': None, 'pickUpLat': 31.618922, 'pickUpLng': 74.908819, 'destAddress': 'Radisson Blu Hotel Amritsar, Amritsar, Punjab, India', 'destSuburb': None, 'destNearestLandmark': None, 'destLat': 31.70583, 'destLng': 74.81889, 'bookedFromIpAddress': '180.151.87.58', 'packageId': None, 'packageName': None, 'isCompanyBooking': False, 'corporateClientId': None, 'companyName': None, 'carTypeId': 1, 'paymentModeType': 'Cash', 'canceledOn': '2017-12-09T09:15:00+05:30', 'cancelReason': 'done 9395', 'cancelReasonRemarks': None, 'canceledById': 8821, 'canceledByUserType': 'ShiftIncharge', 'createdOn': '2017-12-09T08:14:38+05:30', 'createdById': 3531, 'createdByUserType': 'CallTaker', 'serviceCityName': 'Amritsar', 'financialYear': 'FY2017-2018', 'carType': 'Sedan', 'rideType': 'RideLater', 'isHighRisk': False, 'isVip': False, 'isInternational': False, 'loyaltyProgramType': None, 'loyaltyProgramNumber': None, 'corporateBookingTokenNumber': None, 'integratorId': None, 'integratorName': 'MegaCabs', 'remark': None, 'bookingViaDeviceType': 'Customer Service', 'isShortDistance': False, 'viaSms': None, 'alertToTMS': None, 'isConvenienceApply': True, 'tags': [], 'imageUrl': 'https://media.megacabs.com/img/7/5/7562f2924bf31ea32010d2cd2d295ffa.png', 'biddingTime': '2017-12-09T08:00:00+05:30', 'websiteRefererId': None, 'websiteRefererUrl': None, 'thirdPartySettings': None, 'airportBookingRemarks': None, 'mmtReferenceId': None, 'isMmt': False, 'thirdpartyBookingRequest': None, 'airportTerminal': None, 'bookingTotalFare': None, 'bookingTotalDistance': None, 'bookingClientAdvance': None, 'isPartPayment': False, 'isFlatNightCharges': False, 'flatNightCharges': None, 'estimatedEndTime': None, 'isOnTripAssigned': False, 'custAlternateEmail': None, 'isMoveToComplete': False, 'isAssignLogoutDriver': False}, 'tags': [], 'airportBookingRemarks': None, 'appVersion': None, 'deviceModel': None, 'googleEstimatedKM': None, 'gpsKM': None, 'vendor': None},
Please pay credits to unlock the content.

Please pay the required credits to unlock the content.



s t a r d u s t   c o l l e c t i v e
- * . *✦٭。 ⋆⚜⋆。 ٭✦* . * -
Jabber: stardust@jabb.im [OTR]
stardust00@mail2tor.com

Report


Quick Reply
Message
Type your reply to this message here.



Possibly Related Threads…
Thread Author Replies Views Last Post
  Comprehensive Database of Mandiri Bank Indonesia: 350,000 Customer Records Makishougo 24 169 4 hours ago
Last Post: poustime
megacabs.com - 3/4 - 6K records [travel logs] stardust 0 14 06-14-2023, 01:23 AM
Last Post: stardust
megacabs.com - 2/4 - 3K records stardust 0 13 06-14-2023, 01:19 AM
Last Post: stardust
13K megacabs.com Drivers DB (1/5) stardust 0 106 05-25-2023, 11:14 PM
Last Post: stardust



Users browsing this thread: purely_cabbage
var thread_deleted = "0"; if(thread_deleted == "1") { $("#quick_reply_form, .new_reply_button, .thread_tools, .inline_rating").hide(); $("#moderator_options_selector option.option_mirage").attr("disabled","disabled"); }