{"status":"SELECT *, sum(amount - delivery_charge) as total_amount, vendor.*,vendor.name as vendor_name,vendor.reg_commision as reg_commision,vendor.shipping_charge_amt as vendor_shipping_charge,temporder.order_id as order_id FROM `temporder` inner JOIN vendor on temporder.vendor_id = vendor.email WHERE temporder.order_date >= '' AND temporder.order_date <= '' AND temporder.order_type = 'shopping' AND temporder.vendor_id = '' GROUP by temporder.order_date desc","msg":"Error"}