Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u176930106

Directory:

/home/u176930106/domains/inputdata.in/public_html/aminianew

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: testbill.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$res=mysqli_query($con,"select * from `sales_header` where 1");
while($row=mysqli_fetch_array($res)) {
	$totalitemval=0;
	$tax_val=0;
	$resp=mysqli_query($con,"select * from `sales_item` where `sl_id`='".$row['sl_id']."'");
	while($rowp=mysqli_fetch_array($resp)) {
		$rowpur=mysqli_fetch_array(mysqli_query($con,"select * from `purchase_item` where `pro_code`='".$rowp['pro_code']."' and `batch`='".$rowp['batch']."'"));
		$rowpro=mysqli_fetch_array(mysqli_query($con,"select * from `product_master` where `pro_code`='".$rowp['pro_code']."'"));
		$rate=round(($rowpur['purchase_mrp']-($rowpur['purchase_mrp']*$rowp['discount']/100)),2);
		$ratea=round(($rowpur['purchase_mrp']-($rowpur['purchase_mrp']*$rowp['discount']/100))/$rowpro['pro_strippc'],2);
		$itemtot=round($ratea*$rowp['qty'],2);
		$totalitemval+=$itemtot;
		$totalitemval=round($totalitemval,2);
		$totalfig=100+$rowp['sales_gst'];
		$ratewogst=round(($rate*(100/$totalfig)),2);
		$curtax=round(($itemtot*($rowp['sales_gst']/$totalfig)),2);
		$tax_val+=$curtax;
		$itemtotwt=round(($itemtot*(100/$totalfig)),2);
		$insert_sql_data=array('sales_rate'=>$rowpur['purchase_mrp'],
		'sales_grate'=>$rate,
		'sales_arate'=>$ratewogst,
		'sales_valwgst'=>$itemtot,
		'sales_valwogst'=>$itemtotwt,
		'sales_gstval'=>$curtax
		);
		$ins_query=tep_db_perform("sales_item",$insert_sql_data,"update","sales_id=".$rowp['sales_id']);
	}	
	$net_val=round($totalitemval,2);
	mysqli_query($con,"update `sales_header` set `sl_taxval`='".$tax_val."', `sl_total`='".$net_val."' where `sl_id`='".$row['sl_id']."'");
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: testbill.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation