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.92 TB

🔧 Quick Actions

✏️ Editing: addbillbkp.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$action=isset($_REQUEST['action'])?$_REQUEST['action']:'Add';
if(isset($_POST['submitin']) && $_POST['submitin']=="Add") {
	$dc=date("Y-m-d");
	$totalitemval=0;
	$ctax_val=0;
	$gross=0;
	$net_val=0;
    $so_no=isset($_POST['so_no']) ? addslashes($_POST['so_no']) : '';
	$tax=isset($_POST['tax']) ? addslashes($_POST['tax']) : '';
	$doc_date=isset($_POST['doc_date']) ? addslashes($_POST['doc_date']) : '';
	$cus_pay=isset($_POST['cus_pay']) ? addslashes($_POST['cus_pay']) : '';
	$cus_name=isset($_POST['cus_name']) ? addslashes($_POST['cus_name']) : '';
	$cus_add=isset($_POST['cus_add']) ? addslashes($_POST['cus_add']) : '';
	$cus_phone=isset($_POST['cus_phone']) ? addslashes($_POST['cus_phone']) : '';
	$cus_dr=isset($_POST['cus_dr']) ? addslashes($_POST['cus_dr']) : '';
	$cus_regd=isset($_POST['cus_regd']) ? addslashes($_POST['cus_regd']) : '';
	$cus_hs=isset($_POST['cus_hs']) ? addslashes($_POST['cus_hs']) : '';
	$insert_sql_data=array('sl_date'=>$dc,
	'cus_pay'=>$cus_pay,
	'cus_name'=>$cus_name,
	'cus_add'=>$cus_add,
	'cus_phone'=>$cus_phone,
	'cus_dr'=>$cus_dr,
	'cus_regd'=>$cus_regd,
	'cus_hs'=>$cus_hs,
	'sl_st'=>'1',
	'sl_tax'=>$tax,
	'sl_unid'=>$so_no,
	'sl_docdate'=>$doc_date,
	);
    $ins_query=tep_db_perform("sales_header",$insert_sql_data, "insert");
	$ref=mysqli_insert_id($con);
	$norows=$_POST['norows'];
	for($i=1;$i<=$norows;$i++) {
		$itemtot="";
		$tax_val="";
		
		$one="product_ref".$i;
		$two="batch".$i;
		$three="bqty".$i;
		$four="rate".$i;
		$five="aqty".$i;
		$six="disc".$i;
		$seven="stotal".$i;
		
		$product_ref=$_POST[$one];
		$batch=$_POST[$two];
		$qty=$_POST[$three];
		$rate=$_POST[$four];
		$aqty=$_POST[$five];
		$disc=$_POST[$six];
		$stotal=$_POST[$seven];
	  
		$itemtot=round($stotal,2);
		$totalitemval+=$itemtot;
		$totalitemval=round($totalitemval,2);
	  
		if($product_ref!="" && $batch!="" && $qty!="" && $rate!="" && $stotal!="") {
			$comp=mysqli_fetch_array(mysqli_query($con,"select * from `product_master` where `pro_code`='".$product_ref."'"));
			$curtax=round(($itemtot*($comp['pro_gst']/100)),2);
			$tax_val+=$curtax;
			$itemtotwt=round(($totalitemval+$curtax),2);
			$insert_sql_data=array('sl_id'=>$ref,
			'pro_code'=>$product_ref,
			'batch'=>$batch,
			'qty'=>$qty,
			'sales_vat'=>$comp['pro_gst'],
			'sales_rate'=>$rate,
			'discount'=>$disc,
			'sales_valwvat'=>$itemtotwt,
			'sales_valwovat'=>$itemtot,
			'sales_vatval'=>$curtax
			);
			$ins_query=tep_db_perform("sales_item",$insert_sql_data, "insert");
			if($qty!="" && $aqty>=$qty) {
				$chkquan=mysqli_query($con,"select * from `stock_table` where `pro_code`='".$product_ref."' and `batch`='".$batch."'");
				if(mysqli_num_rows($chkquan)>=1) {
					$sysstock=mysqli_fetch_array(mysqli_query($con,"select * from `stock_table` where `pro_code`='".$product_ref."' and `batch`='".$batch."'"));
					$stock=$sysstock['qty']-$qty;
					mysqli_query($con,"update `stock_table` set `qty`='".$stock."' where `pro_code`='".$product_ref."' and `batch`='".$batch."'");
				}
			}
		}
	}
	$net_val=round(($totalitemval+$tax_val),2);
	mysqli_query($con,"update `sales_header` set `sl_taxval`='".$tax_val."', `sl_total`='".$net_val."' where `sl_id`='".$ref."'");
	if($ins_query) {
	    $_SESSION['msg']="Successfully Added.";
		header("location:addbill.php?sl_id=".$ref);
		exit();
	}
	else {
	    $_SESSION['msgerr']="Some Error Occured.";
		header("location:addbill.php");
		exit();
	}
}
$d=date("Y-m-d");
$new_id="";
$res=mysqli_query($con,"select * from `sales_header` order by `sl_id` desc");
$num=mysqli_num_rows($res);
if(mysqli_num_rows($res)<1) {
   $new_id="BLJ10001";
}
if(mysqli_num_rows($res)>=1) {
   $row=mysqli_fetch_array($res);
   $last_id=$row['sl_unid'];
   $last_no=substr($last_id,3,9);
   $new_no=$last_no+1;
   $new_id="BLJ";
   $new_id.=$new_no;
}
include("includes/headermain.php"); 
?>
<script language="javascript">
function addRow(tableID) {
    var table = document.getElementById(tableID);
    var rowCount = table.rows.length;
    var rowCount2 = document.getElementById("norows").value;
    var rcount = parseInt(rowCount2) + 1;
    var row = table.insertRow(rowCount);
    var colCount = table.rows[0].cells.length;
    for (var i = 0; i < colCount; i++) {
        if (i == 0) {
            var tname = "chk" + rcount;
            var newcell = row.insertCell(i);
            newcell.innerHTML = table.rows[0].cells[i].innerHTML;
            switch (newcell.childNodes[0].type) {
                case "text":
                    newcell.childNodes[0].value = "";
                    break;
                case "checkbox":
                    newcell.childNodes[0].checked = false;
                    break;
                case "select-one":
                    newcell.childNodes[0].selectedIndex = 0;
                    break;
            }
            newcell.childNodes[0].name = tname;
        }
        if (i == 1) {
            var tname = "product_ref" + rcount;
            var newcell = row.insertCell(i);
            newcell.innerHTML = table.rows[0].cells[i].innerHTML;
            switch (newcell.childNodes[0].type) {
                case "text":
                    newcell.childNodes[0].value = "";
                    break;
                case "checkbox":
                    newcell.childNodes[0].checked = false;
                    break;
                case "select-one":
                    newcell.childNodes[0].selectedIndex = 0;
                    break;
            }
            newcell.childNodes[0].name = tname;
            newcell.childNodes[0].id = tname;
        }
        if (i == 2) {
            var tname = "get" + rcount;
            var newcell = row.insertCell(i);
            newcell.innerHTML = table.rows[0].cells[i].innerHTML;
            switch (newcell.childNodes[0].type) {
                case "text":
                    newcell.childNodes[0].value = "";
                    break;
                case "checkbox":
                    newcell.childNodes[0].checked = false;
                    break;
                case "select-one":
                    newcell.childNodes[0].selectedIndex = 0;
                    break;
            }
            newcell.childNodes[1].name = tname;
            newcell.childNodes[1].id = tname;
        }
        if (i == 3) {
            var tname = "batchbl" + rcount;
            var newcell = row.insertCell(i);
            newcell.innerHTML = table.rows[0].cells[i].innerHTML;
            newcell.childNodes[1].id = tname;
        }
        if (i == 4) {
            var tname = "aqty" + rcount;
            var newcell = row.insertCell(i);
            newcell.innerHTML = table.rows[0].cells[i].innerHTML;
            switch (newcell.childNodes[0].type) {
                case "text":
                    newcell.childNodes[0].value = "";
                    break;
                case "checkbox":
                    newcell.childNodes[0].checked = false;
                    break;
                case "select-one":
                    newcell.childNodes[0].selectedIndex = 0;
                    break;
            }
            newcell.childNodes[0].name = tname;
            newcell.childNodes[0].id = tname;
        }
        if (i == 5) {
            var tname = "bqty" + rcount;
            var newcell = row.insertCell(i);
            newcell.innerHTML = table.rows[0].cells[i].innerHTML;
            switch (newcell.childNodes[0].type) {
                case "text":
                    newcell.childNodes[0].value = "";
                    break;
                case "checkbox":
                    newcell.childNodes[0].checked = false;
                    break;
                case "select-one":
                    newcell.childNodes[0].selectedIndex = 0;
                    break;
            }
            newcell.childNodes[0].name = tname;
            newcell.childNodes[0].id = tname;
        }
        if (i == 6) {
            var tname = "rate" + rcount;
            var newcell = row.insertCell(i);
            newcell.innerHTML = table.rows[0].cells[i].innerHTML;
            switch (newcell.childNodes[0].type) {
                case "text":
                    newcell.childNodes[0].value = "";
                    break;
                case "checkbox":
                    newcell.childNodes[0].checked = false;
                    break;
                case "select-one":
                    newcell.childNodes[0].selectedIndex = 0;
                    break;
            }
            newcell.childNodes[0].name = tname;
            newcell.childNodes[0].id = tname;
        }
		if (i == 7) {
            var tname = "disc" + rcount;
            var newcell = row.insertCell(i);
            newcell.innerHTML = table.rows[0].cells[i].innerHTML;
            switch (newcell.childNodes[0].type) {
                case "text":
                    newcell.childNodes[0].value = "";
                    break;
                case "checkbox":
                    newcell.childNodes[0].checked = false;
                    break;
                case "select-one":
                    newcell.childNodes[0].selectedIndex = 0;
                    break;
            }
            newcell.childNodes[0].name = tname;
            newcell.childNodes[0].id = tname;
        }
        if (i == 8) {
            var tname = "stotal" + rcount;
            var newcell = row.insertCell(i);
            newcell.innerHTML = table.rows[0].cells[i].innerHTML;
            switch (newcell.childNodes[0].type) {
                case "text":
                    newcell.childNodes[0].value = "";
                    break;
                case "checkbox":
                    newcell.childNodes[0].checked = false;
                    break;
                case "select-one":
                    newcell.childNodes[0].selectedIndex = 0;
                    break;
            }
            newcell.childNodes[0].name = tname;
            newcell.childNodes[0].id = tname;
        }
    }
    document.getElementById("norows").value = rcount;
}
function deleteRow(tableID) {
	try {
		var table=document.getElementById(tableID);
		var rowCount=table.rows.length;
		for(var i=0;i<rowCount;i++) {
		   var row=table.rows[i];
		   var chkbox=row.cells[0].childNodes[0];
		   if(null!=chkbox&&true==chkbox.checked) {
			 if(rowCount<=1) {
			 	alert("Cannot delete all the rows.");break;
			 }
			 var fr=row.cells[1].childNodes[0].value;
			 var done_mat_code=document.getElementById('done_mat_code').value;
			 var mat=done_mat_code.replace(fr, "");
			 document.getElementById('done_mat_code').value=mat;
			 table.deleteRow(i);rowCount--;i--;
			} 
		} 
	}
	catch(e) { alert(e); } 
}
</script>
<body>


<div id="preloader">
	<div class="loader"></div>
</div>


<div class="page-container">
	
	<?php include("includes/leftmenu.php"); ?>
	
	
	<div class="main-content">
		
		<?php include("includes/header.php"); ?>
		
	 	<div class="main-content-innera">
			
			<div> 
				<div class="col-lg-12 mt-5">
					<div class="card">
						<div class="card-body">
							<h4 class="header-title">Add Bill</h4>
							<form action="#" method="post" name="rform" enctype="multipart/form-data">
								<input type="hidden" name="submitin" value="<?php print $action; ?>">
								<?php if($_SESSION['msgerr']) { ?><span class="redtxt"><?php print $_SESSION['msgerr']; $_SESSION['msgerr']=""; ?></span><div class="cleaner h10"></div><?php } ?>
								<?php if($_SESSION['msg']) { ?><span class="grtxt"><?php print $_SESSION['msg']; $_SESSION['msg']=""; ?></span><div class="cleaner h10"></div><?php } ?>				
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">Bill No.</label>
									<input class="form-control" type="text" name="so_no" id="so_no" required value="<?php print $new_id; ?>">
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">Date</label>
									<input class="form-control" type="date" name="doc_date" id="doc_date" required value="<?php print date("Y-m-d"); ?>">
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">Payment Mode</label>
									<select class="form-control" name="cus_pay" id="cus_pay">
										<option value="">Select
										<option value="Cash">Cash
										<option value="Credit">Credit
										<option value="UPI">UPI
										<option value="Others">Others
									</select>	
								</div>
								<div class="cleaner"></div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">Name</label>
									<input class="form-control" type="text" name="cus_name" id="cus_name" required>
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">Address</label>
									<input class="form-control" type="text" name="cus_add" id="cus_add">
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">Contact No.</label>
									<input class="form-control" type="number" name="cus_phone" id="cus_phone">
								</div>
								<div class="cleaner"></div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">Dr. Name</label>
									<input class="form-control" type="text" name="cus_dr" id="cus_dr">
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">REGD. No.</label>
									<input class="form-control" type="text" name="cus_regd" id="cus_regd">
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">Hospital</label>
									<input class="form-control" type="number" name="cus_hs" id="cus_hs">
								</div>
								<div class="cleaner h40"></div>
								<table width="100%" border="0">
									<tr>
										<td colspan="9" align="center">
										   <input type="button" class="btn btn-primary" value="+" onClick="addRow(&#39;dataTable&#39;)">
										   <input type="button" class="btn btn-primary" value="-" onClick="deleteRow(&#39;dataTable&#39;)">
										</td>
									</tr>
									<tr>
										<td colspan="9" align="center">&nbsp;</td>
									</tr>
									<tr>
										<th width="6%">Chk</th>
										<th width="17%">Product</th>
										<th width="8%"></th>
										<th width="13%">Batch</th>
										<th width="16%">Available Qty/Pc.</th>
										<th width="10%">Qty/Pc.</th>
										<th width="10%">Rate (MRP)</th>
										<th width="10%">Discount%</th>
										<th width="10%">Total</th>
									</tr>  
								</table>	  
								<table id="dataTable" width="100%" border="0">
									<tr>
										<td width="6%"><input type="checkbox" name="chk1"></td>
										<td width="17%"><input type="text" name="product_ref1" id="product_ref1" class="form_txtbox" size="15" onClick="fetchprob(this.name);" required readonly="true"></td>
										<td width="8%">
										<input type="button" name="get1" id="get1" value=" Get " onClick="fetchbatch(this.name);" class="spbut">
										</td>
										<td width="13%">
											<div id="batchbl1"></div>
										</td>
										<td width="16%"><input type="text" name="aqty1" id="aqty1" class="form_txtboxqty" readonly="true"></td>
										<td width="10%"><input type="text" name="bqty1" id="bqty1" class="form_txtboxqty" required autocomplete="off" onKeyUp="totamount(this.name,4);" onKeyDown="totamount(this.name,4);" onBlur="totamount(this.name,4);"></td>
										<td width="10%"><input type="text" name="rate1" id="rate1" class="form_txtboxqty" size="7" autocomplete="off" onKeyUp="totamount(this.name,4);" onKeyDown="totamount(this.name,4);" onBlur="totamount(this.name,4);"></td>
										<td width="10%"><input type="text" name="disc1" id="disc1" class="form_txtboxqty" size="7" autocomplete="off" onKeyUp="totamount(this.name,4);" onKeyDown="totamount(this.name,4);" onBlur="totamount(this.name,4);"></td>
										<td width="10%"><input type="text" name="stotal1" id="stotal1" class="form_txtboxqty" size="7"></td>
										</tr>
									</tr>
								</table>
								<div class="cleaner h20"></div>
								<div class="form-group col-md-6 floatleft" id="totalval"></div>	
								<div class="cleaner"></div>
								<input type="hidden" name="norows" id="norows" value="1">
								<input type="hidden" name="done_mat_code" id="done_mat_code">
								<input type="hidden" name="totalitemval" id="totalitemval" value="0">
								<div class="cleaner"></div>
								<button type="submit" class="btn btn-primary mt-4 pr-4 pl-4">Submit</button>
							</form>	
						</div>
					</div>
				</div>
			</div>
			
		</div>
	</div>
	
	<?php include("includes/footer.php"); ?>
</div>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: addbillbkp.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation