Posts

Showing posts from July, 2018

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...