'.date('d-m-Y', strtotime($_POST['from_date'])).' - SALES REPORT
'; include '../../include/conf.php'; $from_date = date('Y-m-d', strtotime($_POST['from_date'])); $arr = array(); $get_orid = mysqli_query($conn,"Select * from tbl_confirmorder WHERE DATE_FORMAT(order_date_time, '%Y-%m-%d') = '$from_date' AND refid NOT LIKE '%SYP%'"); while($set_orid = mysqli_fetch_array($get_orid, MYSQLI_ASSOC)) { $pattern1 = "/CO/i"; $pattern2 = "/Siddhayoga/i"; $pattern3 = "/Cash/i"; $pattern4 = "/HC/i"; $pattern5 = "/Energy/i"; if((!preg_match($pattern1, $set_orid['refid']) && !preg_match($pattern2, $set_orid['company_name']) && !preg_match($pattern3, $set_orid['varstatus'])) || (!preg_match($pattern4, $set_orid['refid']) && !preg_match($pattern5, $set_orid['company_name']))) { array_push($arr, $set_orid['orderid']); } } ksort($arr); foreach($arr as $array){ $get_pro = mysqli_query($conn, "SELECT tc.order_date_time as mytime, tc.refid, tc.userid as myuser, tc.company_name, ts.orderdate,sp.name,sp.product_url,ts.qty+ts.freeqty as qty,tc.dif_name FROM tbl_confirmorder tc inner join tbl_order ts on tc.orid = ts.orderid inner join shop_product sp on ts.productid=sp.product_id where tc.orid = '$array'"); $get_c = mysqli_fetch_array($get_pro, MYSQLI_ASSOC); $get_shop = mysqli_query($conn, "select * from shop_user where user_id='".$get_c['myuser']."'"); $set_shop = mysqli_fetch_array($get_shop, MYSQLI_ASSOC); echo $get_c['refid'].' '.$set_shop['name'].' '.date("g:i A", strtotime($get_c['mytime'])).'
'; $get_pro = mysqli_query($conn, "SELECT tc.refid, tc.company_name, ts.orderdate,sp.name,sp.product_url,ts.qty+ts.freeqty as qty FROM tbl_confirmorder tc inner join tbl_order ts on tc.orid = ts.orderid inner join shop_product sp on ts.productid=sp.product_id where tc.orid = '$array'"); if($get_c['no_note']!='nonote'){ echo 'Note: '.$get_c['no_note'].'
'; } echo ''; while($get_c = mysqli_fetch_array($get_pro, MYSQLI_ASSOC)) { echo ''; } echo '

'.$get_c['name'].'

'.$get_c['product_url'].'

'.$get_c['qty'].'

'; } $str = implode(",", $arr); $group_sql= "SELECT sp.name,sp.product_url, sum(ts.qty) as qty, tcm.id AS company_id FROM tbl_confirmorder tc inner join tbl_order ts on tc.orid = ts.orderid inner join shop_product sp on ts.productid=sp.product_id inner join tbl_company tcm on sp.vstatus =tcm.id where tc.orid IN ($str) GROUP BY sp.name ORDER BY tcm.id"; $group_res = mysqli_query($conn, $group_sql); $dis_com_sql = "SELECT distinct tcm.id AS company_id, tcm.name AS company_name FROM tbl_confirmorder tc inner join tbl_order ts on tc.orid = ts.orderid inner join shop_product sp on ts.productid=sp.product_id inner join tbl_company tcm on sp.vstatus =tcm.id where tc.orid IN ($str) GROUP BY tcm.id"; echo '

TOTAL SALES

'; echo ''; $dis_res = mysqli_query($conn, $dis_com_sql); while ($get_dis = mysqli_fetch_array($dis_res, MYSQLI_ASSOC)){ // echo strtoupper($get_dis['company_name']).'
'; $group_sql= "SELECT tsp.name, tsp.product_url, sum(tbo.qty)+sum(tbo.freeqty) AS qty, tbc.id as company_id FROM tbl_confirmorder tco INNER JOIN tbl_order tbo ON tbo.orderid = tco.orderid inner join shop_product tsp ON tsp.product_id = tbo.productid inner join tbl_company tbc on tsp.vstatus = tbc.id where tco.orderid IN ($str) GROUP BY tbo.productid ORDER BY tsp.name,tbc.id"; $group_res = mysqli_query($conn, $group_sql); while($get_group = mysqli_fetch_array($group_res, MYSQLI_ASSOC)){ if($get_group['company_id'] == $get_dis['company_id'] ){ echo ''; } } } echo '

PRODUCT NAME	CONTENT	QTY
'.$get_group['name'].'	'.$get_group['product_url'].'	'.$get_group['qty'].'

'; $select = "select new_stock, product_id,from_name from tbl_india_update_stock where stock_date='$from_date' group by product_id"; $get_sto = mysqli_query($conn, $select); echo '

NEW STOCK

'; echo ''; while($set_sto = mysqli_fetch_array($get_sto, MYSQLI_ASSOC)){ $get_prod = mysqli_query($conn, "select * from shop_product where product_id = '".$set_sto['product_id']."'"); $set_prod = mysqli_fetch_array($get_prod, MYSQLI_ASSOC); echo ''; } echo '

PRODUCT NAME	CONTENT	QTY	NAME
'.$set_prod['name'].'	'.$set_prod['product_url'].'	'.$set_sto['new_stock'].'	'.$set_sto['from_name'].'

'; ?>