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