ULTRA [ drganbuganapathi.com ]

Linux mail.drganbuganapathi.com 6.8.0-60-generic #63-Ubuntu SMP PREEMPT_DYNAMIC Tue Apr 15 19:04:15 UTC 2025 x86_64

Apache/2.4.58 (Ubuntu)

165.22.222.249 | Your IP: 216.73.216.90

Cant read [ /etc/named.conf ]

[ drwxr-xr-x ]

/ var / www / html / superadmin / order-admin / phpaction /

Home Upload Mass Deface Mass Delete Back Connect Notify

test_ajax.php

<?
set_time_limit(0);
function get_stock($pid, $conn){

//this part is for the previous dates
            $get_prod = mysqli_query($conn, "select * from shop_product where product_id = '$pid'");
            $set_prod = mysqli_fetch_array($get_prod, MYSQLI_ASSOC);
            $med_name = $set_prod['name'].' '.$set_prod['product_url'];
            $get_open = mysqli_query($conn, "select * from tbl_cron_stock_report where product_id='$pid' and snap_date='2023-12-19'");
            $set_open = mysqli_fetch_array($get_open, MYSQLI_ASSOC);
            $first_date = '2023-12-19';
            $your_date = strtotime("1 day", strtotime($first_date));
            $second_date = date("Y-m-d", $your_date);
            $open = $set_open['balance'];

$startDate = new \DateTime($second_date);
$endDate = new \DateTime();

$interval = new \DateInterval('P1D');
$period = new \DatePeriod ($startDate, $interval, $endDate);

$dates = array();
foreach ($period as $key) {
    array_push($dates,$key->format('Y-m-d'));
}

foreach ($dates as $date_arr){
            $arr = array();
$arr_1 = array();
$arr_2 = array();
$added = 0;
$returned = 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'];
                
              
            }
            $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'];
               
             }
             $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'];

}
         
                
$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;
    }

}
$arr_methane = array("balance"=>$open, "instock"=>$instock);
}

}
//          $arr = array();
//          $arr_1 = array();
//          $arr_2 = array();
//          $sold1 = 0;

//  //calculate the sold items today
//  $get_orid = mysqli_query($conn,"Select * from tbl_confirmorder WHERE DATE_FORMAT(order_date_time, '%Y-%m-%d') = '".date('Y-m-d')."' 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);
//  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);
//      $sold1+= $set_if['qty'] + $set_if['freeqty'];    
//  }
// }
       
         return $arr_methane;
}
         ?>

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	root/root	drwxr-xr-x	2025-07-15 06:22:32
..	dir	-	root/root	drwxr-xr-x	2025-07-15 07:09:58
anb_auto_run	dir	-	root/root	drwxrwxrwx	2025-03-06 09:38:24
anb_reports	dir	-	root/root	drwxrwxrwx	2025-07-02 07:32:03
enf_auto_run	dir	-	root/root	drwxrwxrwx	2025-03-06 09:38:35
enf_reports	dir	-	root/root	drwxrwxrwx	2025-07-02 08:02:08
productwise_report	dir	-	root/root	drwxrwxrwx	2025-06-23 11:39:58
uploads	dir	-	root/root	drwxr-xr-x	2024-07-28 12:17:08
Telegram.php	text/x-php	121.29 KB	root/root	-rw-r--r--	2024-07-28 02:48:16
anb_report_cron.php	text/x-php	13.53 KB	root/root	-rw-r--r--	2025-03-06 09:40:51
btn-delete.php	text/x-php	163 B	root/root	-rw-r--r--	2024-07-28 02:48:15
btn-minus.php	text/x-php	729 B	root/root	-rw-r--r--	2024-07-28 02:48:15
btn-plus.php	text/x-php	557 B	root/root	-rw-r--r--	2024-07-28 02:48:15
btn-save-form.php	text/x-php	2.27 KB	root/root	-rw-r--r--	2024-07-28 02:48:15
btn-save-form1.php	text/x-php	2.44 KB	root/root	-rw-r--r--	2025-01-06 08:54:00
change_live_status.php	text/x-php	215 B	root/root	-rw-r--r--	2024-07-28 02:48:15
check_india_stock.php	text/x-php	396 B	root/root	-rw-r--r--	2024-07-28 02:48:15
check_stock.php	text/x-php	395 B	root/root	-rw-r--r--	2024-07-28 02:48:15
cron_stock_snapshot.php	text/x-php	746 B	root/root	-rw-r--r--	2024-07-28 02:48:15
curl_test.php	text/x-php	1.64 KB	root/root	-rw-r--r--	2024-07-28 02:48:15
daily_stock_excel_report.php	text/x-php	13.85 KB	root/root	-rw-r--r--	2024-07-28 02:48:15
daily_stock_excel_report_ajax.php	text/x-php	13.67 KB	root/root	-rw-r--r--	2024-07-28 02:48:15
date_wise_count_report_ajax.php	text/x-php	2.17 KB	root/root	-rw-r--r--	2024-07-28 02:48:15
delete_holiday.php	text/x-php	241 B	root/root	-rw-r--r--	2024-08-25 02:02:20
delete_missed_dc_order.php	text/x-php	578 B	root/root	-rw-r--r--	2024-09-15 11:21:40
delete_missed_oc_order.php	text/x-php	578 B	root/root	-rw-r--r--	2024-09-25 07:06:52
delete_returned.php	text/x-php	6.63 KB	root/root	-rw-r--r--	2024-07-28 02:48:15
delete_revision.php	text/x-php	6.63 KB	root/root	-rw-r--r--	2024-07-28 02:48:15
delete_stock.php	text/x-php	6.64 KB	root/root	-rw-r--r--	2024-07-28 02:48:15
download_daler_current_year_sales_report.php	text/x-php	1.82 KB	root/root	-rw-r--r--	2025-01-22 08:10:10
download_daler_current_year_sales_report_ap_cash.php	text/x-php	1.84 KB	root/root	-rw-r--r--	2025-01-22 08:10:10
download_daler_current_year_sales_report_ap_gst.php	text/x-php	1.84 KB	root/root	-rw-r--r--	2025-01-22 08:10:10
download_daler_select_month_sales_report.php	text/x-php	1.82 KB	root/root	-rw-r--r--	2025-01-22 08:10:10
download_daler_select_month_sales_report_ap_gst.php	text/x-php	1.85 KB	root/root	-rw-r--r--	2025-02-03 11:23:03
download_patient_select_month_sales_report.php	text/x-php	3.9 KB	root/root	-rw-r--r--	2025-01-22 11:12:13
enf_report_cron.php	text/x-php	13.54 KB	root/root	-rw-r--r--	2025-03-06 09:42:17
file_delete.php	text/x-php	209 B	root/root	-rw-r--r--	2024-07-28 02:48:15
fill_edit_div.php	text/x-php	1.09 KB	root/root	-rw-r--r--	2024-11-10 11:38:49
find_order_ajax.php	text/x-php	18.66 KB	root/root	-rw-r--r--	2024-10-23 10:29:08
fixed_process_one_third_order.php	text/x-php	23.36 KB	root/root	-rw-r--r--	2025-07-16 09:47:39
get_note.php	text/x-php	733 B	root/root	-rw-r--r--	2025-06-26 08:37:33
india_update_return_stock.php	text/x-php	1.25 KB	root/root	-rw-r--r--	2024-07-28 02:48:15
india_update_revise_stock.php	text/x-php	1.25 KB	root/root	-rw-r--r--	2024-07-28 02:48:15
india_update_stock.php	text/x-php	1.27 KB	root/root	-rw-r--r--	2024-07-28 02:48:15
invoice_print_anbu.php	text/html	55.88 KB	root/root	-rw-r--r--	2025-04-06 07:31:57
list_dealer_order.php	text/x-php	1.19 KB	root/root	-rw-r--r--	2025-04-18 09:45:42
list_dealer_order_success.php	text/x-php	5.37 KB	root/root	-rw-r--r--	2025-04-18 09:47:29
list_india_stock.php	text/x-php	3.39 KB	root/root	-rw-r--r--	2024-07-28 02:48:15
list_india_stock_ajax.php	text/x-php	7.68 KB	root/root	-rw-r--r--	2024-07-28 02:48:15
list_india_stock_cron_report.php	text/x-php	8.69 KB	root/root	-rw-r--r--	2024-07-28 02:48:15
list_india_stock_cron_report_backup.php	text/x-php	8.69 KB	root/root	-rw-r--r--	2024-07-28 02:48:15
list_india_stock_revised.php	text/x-php	1.77 KB	root/root	-rw-r--r--	2024-07-28 02:48:15
list_special_dealer.php	text/x-php	1.05 KB	root/root	-rw-r--r--	2024-11-13 08:09:11
list_stock.php	text/x-php	931 B	root/root	-rw-r--r--	2024-07-28 02:48:15
live_stock_excel_report_ajax.php	text/x-php	4.29 KB	root/root	-rw-r--r--	2024-07-28 02:48:15
load_events.php	text/x-php	589 B	root/root	-rw-r--r--	2024-07-28 02:48:15
load_feed.php	text/x-php	390 B	root/root	-rw-r--r--	2024-07-28 02:48:16
malayasia_update_stock.php	text/x-php	733 B	root/root	-rw-r--r--	2024-07-28 02:48:16
offer_test.php	text/x-php	1.8 KB	root/root	-rw-r--r--	2025-07-15 10:03:15
password_change.php	text/x-php	367 B	root/root	-rw-r--r--	2024-07-28 02:48:16
process_adc.php	text/x-php	987 B	root/root	-rw-r--r--	2024-07-28 02:48:16
process_add_med.php	text/x-php	3.46 KB	root/root	-rw-r--r--	2024-10-30 11:31:35
process_anb_date.php	text/x-php	26.94 KB	root/root	-rw-r--r--	2025-04-06 10:49:51
process_cash_order.php	text/x-php	9.02 KB	root/root	-rw-r--r--	2025-04-01 11:56:35
process_clear_order.php	text/x-php	1.18 KB	root/root	-rw-r--r--	2024-09-17 09:09:42
process_delete.php	text/x-php	1.42 KB	root/root	-rw-r--r--	2024-11-07 10:23:29
process_delete_order.php	text/x-php	1.05 KB	root/root	-rw-r--r--	2025-04-07 11:26:26
process_edit_div.php	text/x-php	2.51 KB	root/root	-rw-r--r--	2024-11-12 09:27:41
process_edit_emp.php	text/x-php	1.61 KB	root/root	-rw-r--r--	2024-08-08 10:59:13
process_edit_new_dealer_form.php	text/x-php	1.47 KB	root/root	-rw-r--r--	2024-12-17 10:14:02
process_emp.php	text/x-php	1.1 KB	root/root	-rw-r--r--	2024-08-08 11:18:36
process_enf_date.php	text/x-php	26.93 KB	root/root	-rw-r--r--	2025-04-03 09:06:35
process_enf_date_backup.php	text/x-php	25.37 KB	root/root	-rw-r--r--	2025-03-06 07:48:58
process_files.php	text/x-php	1.37 KB	root/root	-rw-r--r--	2024-07-28 02:48:16
process_gst_order.php	text/x-php	9.99 KB	root/root	-rw-r--r--	2025-05-04 02:16:38
process_holiday.php	text/x-php	366 B	root/root	-rw-r--r--	2024-08-23 10:39:55
process_missed_dc_order.php	text/x-php	2.35 KB	root/root	-rw-r--r--	2024-09-15 11:29:41
process_missed_dealer_oc_order.php	text/x-php	3.16 KB	root/root	-rw-r--r--	2024-10-09 10:32:18
process_missed_oc_order.php	text/x-php	3.23 KB	root/root	-rw-r--r--	2025-07-07 09:22:04
process_missed_sales_order.php	text/x-php	4.74 KB	root/root	-rw-r--r--	2025-05-04 02:16:37
process_missed_yoga_sales_order.php	text/x-php	3.7 KB	root/root	-rw-r--r--	2025-05-28 08:46:37
process_new_dealer_form.php	text/x-php	1.36 KB	root/root	-rw-r--r--	2024-12-04 10:41:41
process_no_stock.php	text/x-php	1.33 KB	root/root	-rw-r--r--	2024-10-24 10:11:19
process_one_third_order.php	text/x-php	23.38 KB	root/root	-rw-r--r--	2025-05-04 02:16:38
process_one_third_order_backup.php	text/x-php	2.71 KB	root/root	-rw-r--r--	2025-07-13 07:54:39
process_productwise_date.php	text/x-php	9.27 KB	root/root	-rw-r--r--	2025-06-23 11:06:24
process_start_product.php	text/x-php	204 B	root/root	-rw-r--r--	2024-12-25 09:57:11
process_stop_product.php	text/x-php	238 B	root/root	-rw-r--r--	2024-12-25 09:32:06
product_refresh.php	text/x-php	6.47 KB	root/root	-rw-r--r--	2024-07-28 02:48:16
save_adc.php	text/x-php	651 B	root/root	-rw-r--r--	2024-07-28 02:48:16
save_adc_date.php	text/x-php	597 B	root/root	-rw-r--r--	2024-07-28 02:48:16
special_id.php	text/x-php	33 B	root/root	-rw-r--r--	2024-11-10 12:11:50
test.php	text/x-php	6.96 KB	root/root	-rw-r--r--	2024-07-28 02:48:16
test_ajax.php	text/x-php	7.65 KB	root/root	-rw-r--r--	2024-07-28 02:48:16
test_ajax_api.php	text/x-php	6.86 KB	root/root	-rw-r--r--	2024-07-28 02:48:16
test_ajax_api_order.php	text/x-php	6.55 KB	root/root	-rw-r--r--	2024-07-28 02:48:16
update_courier_amount.php	text/x-php	518 B	root/root	-rw-r--r--	2025-03-10 10:27:46
view_courier_update_form.php	text/x-php	6.88 KB	root/root	-rw-r--r--	2025-03-19 09:56:35