';
}
$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";
$dis_res = mysqli_query($conn, $dis_com_sql);
while ($get_dis = mysqli_fetch_array($dis_res, MYSQLI_ASSOC)){
echo strtoupper($get_dis['company_name']).' ';
echo '
';
echo '
PRODUCT NAME
CONTENT
QTY
';
$group_sql= "SELECT tsp.name, tsp.product_url, sum(tbo.qty) 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 '