New Queries on Pocket
to Find Current time income not deleted and status not canceled
SELECT * FROM b_pocketpa.vendor_appointment_payments where vendor_id=204 and payment_timestamp between "2018-07-01" and "2018-07-31" and status != 4 and deleted !=1
// fetch all the appointments agains a vendor in this timespam
SELECT COUNT(*) FROM `vendor_appointments` WHERE vendor_id=532 and appointment_datetime BETWEEN "2018-07-01" and "2018-07-31" and deleted =0
ORDER BY `vendor_appointments`.`id` ASC
find all apointment that are Attended by Vendor and Payment status is not paid(un-pain,partialy paid)
SELECT * FROM `vendor_appointments` WHERE vendor_id=532 and appointment_datetime BETWEEN "2018-07-09" and "2018-07-15" and deleted =0 and appointment_status = 2 and payment_status IN (2,3)
ORDER BY `vendor_appointments`.`id` ASC
Vendors appointments paid or partialy paid after provided time spam and apointment status is pending
SELECT * FROM `vendor_appointments` WHERE vendor_id=532 and appointment_datetime > "2018-07-15" and deleted =0 and appointment_status = 1 and payment_status IN (1,3)
ORDER BY `vendor_appointments`.`id` ASC
Vendors appointments status is Pending or Rescheduled
SELECT * FROM `vendor_appointments` WHERE vendor_id=532 and appointment_datetime BETWEEN "2018-07-09" and "2018-07-15" and deleted =0 and appointment_status in (1,3)
ORDER BY `vendor_appointments`.`id` ASC
Delete Dummy Emails
UPDATE `vendor_clients` as vc1 SET vc1.email = ''
WHERE vc1.email LIKE '%@pocketpa.com'
SELECT * FROM b_pocketpa.vendor_appointment_payments where vendor_id=204 and payment_timestamp between "2018-07-01" and "2018-07-31" and status != 4 and deleted !=1
// fetch all the appointments agains a vendor in this timespam
SELECT COUNT(*) FROM `vendor_appointments` WHERE vendor_id=532 and appointment_datetime BETWEEN "2018-07-01" and "2018-07-31" and deleted =0
ORDER BY `vendor_appointments`.`id` ASC
find all apointment that are Attended by Vendor and Payment status is not paid(un-pain,partialy paid)
SELECT * FROM `vendor_appointments` WHERE vendor_id=532 and appointment_datetime BETWEEN "2018-07-09" and "2018-07-15" and deleted =0 and appointment_status = 2 and payment_status IN (2,3)
ORDER BY `vendor_appointments`.`id` ASC
Vendors appointments paid or partialy paid after provided time spam and apointment status is pending
SELECT * FROM `vendor_appointments` WHERE vendor_id=532 and appointment_datetime > "2018-07-15" and deleted =0 and appointment_status = 1 and payment_status IN (1,3)
ORDER BY `vendor_appointments`.`id` ASC
Vendors appointments status is Pending or Rescheduled
SELECT * FROM `vendor_appointments` WHERE vendor_id=532 and appointment_datetime BETWEEN "2018-07-09" and "2018-07-15" and deleted =0 and appointment_status in (1,3)
ORDER BY `vendor_appointments`.`id` ASC
Delete Dummy Emails
UPDATE `vendor_clients` as vc1 SET vc1.email = ''
WHERE vc1.email LIKE '%@pocketpa.com'
Comments
Post a Comment