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/ccadmultiservices.com/public_html/admin

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: testimportjn.php

<?php
ob_start();
session_start();
include("../includes/connectionwos.php");
include("includes/functions.php");
$uppath="docs/febjn2023lastup.xls";
require_once 'excel_reader.php';
$excel=new PhpExcelReader;
$excel->read($uppath);
$nr_sheets=count($excel->sheets);
$dt=date("Y-m-d");
$flag="";
for($x=1;$x<=$excel->sheets[0]['numRows'];$x++) {
	$pdate=trim($excel->sheets[0]["cells"][$x][1]);  
	$dtar=explode("/",$pdate);
	$pdate=$dtar[2]."-".$dtar[1]."-".$dtar[0];
	$cusid=trim($excel->sheets[0]["cells"][$x][2]); 
	$row=mysqli_fetch_array(mysqli_query($con,"select * from `registration` where `cusid`='".$cusid."'"));
	$regid=$row['reg_id'];
	$segr=trim($excel->sheets[0]["cells"][$x][4]); 
	$procode=trim($excel->sheets[0]["cells"][$x][6]);
	$qty=$excel->sheets[0]["cells"][$x][7];
	$rate=trim($excel->sheets[0]["cells"][$x][8]);
	$pack=trim($excel->sheets[0]["cells"][$x][9]);
	//print $qty;exit();
	$paym=trim($excel->sheets[0]["cells"][$x][12]);
	$type=trim($excel->sheets[0]["cells"][$x][13]);
	$orid="CJN".rand(111111,999999);
	if($paym=="Y") {
		$rowp=mysqli_fetch_array(mysqli_query($con,"select * from `products` where `pro_id`='".$procode."'"));
		if($flag!=$segr) {
			$flag=$segr;
			$subtot=$qty*$rate;
			$tax=round((($subtot*$rowp['gst'])/(100+$rowp['gst'])),2);
			$taxtot=$tax;
			$subtotbftx=round(($subtot-$tax),2);
			$subtotbftxtot=$subtotbftx;
			$net=$subtot+$pack;
			$packv=$pack;
			$insert_sql_data=array('or_id'=>$orid,
			'or_inv_id'=>$orid,
			'or_category'=>'Gateway',
			'or_value'=>$subtotbftx,
			'or_gst'=>$tax,
			'or_pckval'=>$packv,
			'or_net'=>$net,
			'or_delmode'=>'Prepaid',
			'or_date'=>$pdate,
			'orderstatus'=>'Order Delivered',
			'paymentstatus'=>'Done',
			'cusid'=>$regid,
			'bkby'=>$regid
			);
			$ins_query=tep_db_perform("orderp",$insert_sql_data,"insert");
			$id=mysqli_insert_id($con);
			$insert_sql_data=array('orderpro_ref'=>$id,
			'orderpro_pro'=>$procode,
			'orderpro_qty'=>$qty,
			'orderpro_mrp'=>$rate,
			'orderpro_val'=>$rate,
			'status'=>'Order Delivered'
			);
			$ins_query=tep_db_perform("orderpro",$insert_sql_data,"insert");
		} else {
			$subtot=$qty*$rate;
			$tax=round((($subtot*$rowp['gst'])/(100+$rowp['gst'])),2);
			$taxtot+=$tax;
			$subtotbftx=round(($subtot-$tax),2);
			$subtotbftxtot+=$subtotbftx;
			$net+=$subtot+$pack;
			$packv+=$pack;
			mysqli_query($con,"update `orderp` set `or_value`='".$subtotbftxtot."',`or_gst`='".$taxtot."',`or_pckval`='".$packv."',`or_net`='".$net."' where `order_id`='".$id."'");
			$insert_sql_data=array('orderpro_ref'=>$id,
			'orderpro_pro'=>$procode,
			'orderpro_qty'=>$qty,
			'orderpro_mrp'=>$rate,
			'orderpro_val'=>$rate,
			'status'=>'Order Delivered'
			);
			$ins_query=tep_db_perform("orderpro",$insert_sql_data,"insert");
		}	
	}	
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: testimportjn.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation