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'








Comments

Popular posts from this blog

OPEN Cart Find Parent Categories and there Child Categories list in Ms Excel export

Git Commands