| '.date('d-m-Y', strtotime($second_date)).' |
|
|
'.$open.' |
|
|
|
|
'.$open.' |
|
'.$open.' |
';
foreach ($dates as $date_arr){
$arr = array();
$arr_1 = array();
$arr_2 = array();
$added = 0;
$returned = 0;
$revised = 0;
//set new stock values first
$get_new_stock = mysqli_query($conn, "select * from tbl_india_update_stock where product_id = '$pid' and DATE(stock_date)='$date_arr'");
while($set_new_stock = mysqli_fetch_array($get_new_stock, MYSQLI_ASSOC)){
$added+=$set_new_stock['new_stock'];
echo ' | '.date('d-m-Y', strtotime($date_arr)).' |
|
'.$set_new_stock['from_name'].' |
|
|
'.$set_new_stock['new_stock'].' |
|
|
'.($open + $added).' |
|
'.($open + $added).' |
';
}
$get_return = mysqli_query($conn, "select * from tbl_record_returned where product_id = '$pid' and DATE(date_of_return)='$date_arr'");
while($set_return = mysqli_fetch_array($get_return, MYSQLI_ASSOC)){
$returned+=$set_return['returned_qty'];
echo ' | '.date('d-m-Y', strtotime($date_arr)).' |
|
'.$set_return['from_name'].' |
|
|
|
'.$set_return['returned_qty'].' |
|
'.($open + $added + $returned).' |
|
'.($open + $added + $returned).' |
';
}
$get_revision = mysqli_query($conn, "select * from tbl_record_revised where product_id = '$pid' and DATE(date_of_revision)='$date_arr'");
while($set_revision = mysqli_fetch_array($get_revision, MYSQLI_ASSOC)){
$revised+=$set_revision['revised_qty'];
echo ' | '.date('d-m-Y', strtotime($date_arr)).' |
|
'.$set_revision['from_name'].' |
|
|
|
|
'.$set_revision['revised_qty'].' |
'.($open + $added + $returned + $revised).' |
|
'.($open + $added + $returned + $revised).' |
';
}
//get returned stock values second
//get all the sales with refids and sold count
// echo ' | '.date('d-m-Y', strtotime($date_arr)).' |
// |
// |
// |
// |
// |
// |
// |
// |
// |
//
';
$get_orid = mysqli_query($conn,"Select * from tbl_confirmorder WHERE DATE_FORMAT(order_date_time, '%Y-%m-%d') = '$date_arr' AND refid NOT LIKE '%SYP%' and company_name not like 'Siddhayoga Pharma' and orderstatus not like '90'");
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";
array_push($arr, $set_orid['orderid']);
}
ksort($arr);
foreach($arr as $arrays){
$check_sy = mysqli_query($conn, "select * from tbl_confirmorder where refid like '%HC%' and company_name='Energy Foods' and userid='7444' and orderid='$arrays'");
$check_syp = mysqli_num_rows($check_sy);
if($check_syp == 0){
array_push($arr_2, $arrays);
}
}
foreach($arr_2 as $arr_zee){
$check_yv = mysqli_query($conn, "select * from tbl_order where orderid='$arr_zee'");
$yv_count = mysqli_num_rows($check_yv);
$check_yvs = mysqli_query($conn, "SELECT * FROM tbl_order td INNER JOIN shop_product sp on td.productid = sp.product_id WHERE td.orderid='$arr_zee' and sp.cloud_url<>'' ORDER BY td.ordid desc;");
$yvs_count = mysqli_num_rows($check_yvs);
if($yv_count != $yvs_count){
array_push($arr_1, $arr_zee);
}
}
ksort($arr_1);
$open=$open+$added+$returned+$revised;
foreach($arr_1 as $get_or){
$check_if = mysqli_query($conn, "select * from tbl_order where orderid = '$get_or' and productid='$pid'");
$myrows = mysqli_num_rows($check_if);
if($myrows > 0){
$set_if = mysqli_fetch_array($check_if, MYSQLI_ASSOC);
$sold = $set_if['qty'] + $set_if['freeqty'];
$get_ref = mysqli_query($conn, "select * from tbl_confirmorder where orderid='$get_or'");
$set_ref = mysqli_fetch_array($get_ref, MYSQLI_ASSOC);
$status='';
$pending = 0;
$open = $open - $sold;
//unpacked orders check
$get_packing = mysqli_query($conn, "SELECT sum(tb.qty + tb.freeqty) AS fqty FROM tbl_confirmorder tc INNER JOIN tbl_order tb ON tc.orderid = tb.orderid WHERE tc.orderstatus = 5 AND tc.varstatus!='Cash' and tc.userid!=7444 and tc.company_name='Energy Foods' and tb.productid='$pid' and tc.refid='$set_ref[refid]'");
$pack_rows = mysqli_num_rows($get_packing);
if($pack_rows > 0){
$set_packing = mysqli_fetch_array($get_packing, MYSQLI_ASSOC);
$packing = $set_packing['fqty'];
}else{
$packing = 0;
}
$get_new = mysqli_query($conn, "SELECT sum(tb.qty + tb.freeqty) AS fqty FROM tbl_confirmorder tc INNER JOIN tbl_order tb ON tc.orderid = tb.orderid WHERE tc.orderstatus = 0 AND tc.varstatus!='Cash' and tc.userid!=7444 and tc.company_name='Energy Foods' and tb.productid='$pid' and tc.refid='$set_ref[refid]'");
$new_rows = mysqli_num_rows($get_new);
if($new_rows > 0){
$set_new = mysqli_fetch_array($get_new, MYSQLI_ASSOC);
$new = $set_new['fqty'];
}else{
$new = 0;
}
$pending = $packing + $new;
$pending_mas+=($packing + $new);
if(!isset($pending)){
$pending = 0;
}
if(strpos($set_ref['refid'], 'CO') !== false){
$status= 'SENT';
}elseif($pending == 0){
$status= 'SENT';
}else{
$status = $sold;
}
if($status=='SENT'){
$instock = $open+$pending_mas;
}else{
$instock = $open+$pending_mas;
}
echo ' | '.date('d-m-Y', strtotime($date_arr)).' |
'. $set_ref['refid'].' |
|
|
'.$sold.' |
|
|
|
'.$open.' |
'.$status.' |
'.$instock.' |
';
}
}
}
?>