Uncategorized

query

AND vjtv_wc_order_stats.date_created LIKE ‘%2021-12%’

$out_completed_orders_each_month

6733873 – 5832841

$processing = mysqli_fetch_row(mysqli_query($conn, “SELECT SUM(net_total) AS value_sum FROM vjtv_wc_order_stats WHERE status!=’wc-complete’ AND status!=’wc-cancel’ AND status!=’wc-cancelled’ AND parent_id=0 AND date_created LIKE ‘%”.$year.”%'”))[0];

6733873 (without not – 6736023)

$out_processing = mysqli_fetch_row(mysqli_query($conn, “SELECT sum(vjtv_wc_order_stats.net_total) FROM vjtv_postmeta INNER JOIN vjtv_wc_order_stats ON vjtv_postmeta.post_id=vjtv_wc_order_stats.order_id WHERE vjtv_postmeta.meta_value != ‘dhaka’ AND vjtv_postmeta.meta_key =’_select_city’ AND vjtv_wc_order_stats.status != ‘wc-complete’ AND vjtv_wc_order_stats.status != ‘wc-cancel’ AND parent_id=0 AND vjtv_wc_order_stats.date_created LIKE ‘%”.$year.”%’ “))[0];

5832841

SELECT sum(vjtv_wc_order_stats.net_total) FROM vjtv_postmeta INNER JOIN vjtv_wc_order_stats ON vjtv_postmeta.post_id=vjtv_wc_order_stats.order_id WHERE vjtv_postmeta.meta_value != ‘dhaka’ AND vjtv_postmeta.meta_key =’_select_city’ AND vjtv_wc_order_stats.status != ‘wc-complete’ AND vjtv_wc_order_stats.status != ‘wc-cancel’ AND parent_id=0 AND vjtv_wc_order_stats.date_created LIKE ‘%2021%’

Leave a Reply

Your email address will not be published. Required fields are marked *