Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.19.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u802471691

Directory:

/home/u802471691/domains/thetechnozone.in/public_html/stock

Free Space:

9.31 TB

🔧 Quick Actions

✏️ Editing: sbill.php

<?php include "header.php";

$tpid=$_SESSION['stype'];$pgid=getpgids($pagename);if(chkacc($pgid,$tpid,'vu')=='1'){}else{header("Location:index.php"); }

$userid=$_SESSION['sbills'];
	$action=$_REQUEST['action'];

if($action=='save'){

$bdate=date('Y-m-d', strtotime($_POST['bdate']));
			$invno=$_POST['invno'];
			$cmobile=$_POST['cmobile'];
			$grandtot=$_POST['grandtot'];
			$taxtot=$_POST['taxtot'];
            $c_id=$_POST['c_id'];
            $invsno=$_POST['invsno'];
            $techname=$_POST['techname'];
            $hname=$_POST['hname'];
            $getsu=f(q("SELECT * FROM tbl_customer WHERE c_phone='$cmobile'"));
            if($cmobile==''){

$c_id=$getsu['c_id'];

}
			$cname=$_POST['cname'];
			$caddress=$_POST['caddress'];
			$cgst=$_POST['cgst'];

if($getsu['cname']==''){

$inscust=mysqli_query($con,"INSERT INTO tbl_customer SET c_name='$cname',c_phone='$cmobile',c_addr='$caddress',c_gstn='$cgst'");

$c_id=mysqli_insert_id($con);

}else{

$c_id=$getsu['c_id'];

}

// echo "INSERT INTO tbl_sbill SET invno='$invno',bdate='$bdate',cmobile='$cmobile',ctot='$grandtot',ctax='$taxtot',cname='$cname',caddress='$caddress',cgst='$cgst',c_id='$c_id',com_id='$compaid',buser='$userid'"; 
            //  die();
			$res=mysqli_query($con,"INSERT INTO tbl_sbill SET invno='$invno',bdate='$bdate',cmobile='$cmobile',ctot='$grandtot',ctax='$taxtot',cname='$cname',caddress='$caddress',cgst='$cgst',c_id='$c_id',com_id='$compaid',buser='$userid',invsno='$invsno',techname='$techname',hname='$hname'");

$getmax=mysqli_insert_id($con);

$rowcnt=$_POST['rowcnt'];

for($i=1;$i<=$rowcnt;$i++){

$prodname=$_POST['prodname'.$i];
						if(strstr($_POST['quan'.$i],'-')) {
						    $quan=str_replace('-','',$_POST['quan'.$i]);
						} else {
						    $quan=$_POST['quan'.$i];
						}
						$price=$_POST['price'.$i];
						$gst=$_POST['gst'.$i];
						$tax=$_POST['tax'.$i];
						$total=$_POST['total'.$i];
                        $unit=$_POST['unit'.$i];
                        $pbarcode=$_POST['pbarcode'.$i];
                        $proddesc=$_POST['proddesc'.$i];

$subt=floatval($total)-floatval($tax);

if($prodname!=''){

$getprods=f(q("SELECT * FROM tbl_products WHERE p_code='$prodname'"));
                                    $pnames=$getprods['p_name'];
                                    $pids=$getprods['p_ids'];
                                    $muq=f(q("SELECT * FROM tbl_unit WHERE u_id='$getprods[m_unit]'"));
                                    $suq=f(q("SELECT * FROM tbl_unit WHERE u_id='$getprods[s_unit]'"));

$munit=$muq['u_name'];
                                    $sunit=$suq['u_name'];
                                    $conv=$getprods['mtos'];

if($sunit!=''){

$squan=floatval($quan)*floatval($conv);
                                        $mquan=$quan;

}else{

$squan=0;
                                        $mquan=$quan;
                                    }

$insdet=mysqli_query($con,"INSERT INTO tbl_sbilld SET bid='$getmax',bdate='$bdate',prodcode='$prodname',prodesc='$pnames',prodq='$quan',prodpr='$price',prodgst='$gst',prodgstv='$tax',prodtotal='$total',prodsub='$subt',produnit='$unit',prodbarcode='$pbarcode',proddesc='$proddesc',com_id='$compaid'");

if($insdet){

$lastbilld=mysqli_insert_id($con);
                                                $instock=mysqli_query($con,"INSERT INTO tbl_stock SET st_date='$bdate',st_prodid='$pids',st_quan='-$quan',st_munit='$mquan',st_sunit='$squan',st_type='Sales',st_invno='$invno',st_prodname='$pnames',st_trn=1,st_barcode='$pbarcode',st_linkid='$lastbilld',com_id='$compaid'");
                                                //echo "INSERT INTO tbl_stock SET st_date='$bdate',st_prodid='$pids',st_quan='$quan',st_munit='$mquan',st_sunit='$squan',st_type='Sales',st_invno='$invno',st_prodname='$pnames',st_trn=1,st_barcode='$pbarcode',st_linkid='$lastbilld',com_id='$compaid'";
                                               
                                    }

}

?>
                <script>	
			window.open("saleprint.php?cid=<?php echo $getmax?>","_blank");
		</script>		
				<script type="text/javascript">
				swal({ title: "Smart Billing",
				text: "Bill Created Successfully",
				type: "success"}).then(okay => {
				if (okay) {
				window.location.href = "sbill.php";
				}
				});
				</script>
<?php

<?php

// header("Location:sbill.php");

}elseif($action=='update'){

$bdate=date('Y-m-d', strtotime($_POST['bdate']));
			$invno=$_POST['invno'];
			$cmobile=$_POST['cmobile'];
			$grandtot=$_POST['grandtot'];
			$taxtot=$_POST['taxtot'];
			$cid=$_REQUEST['cids'];
			$cname=$_POST['cname'];
			$caddress=$_POST['caddress'];
			$cgst=$_POST['cgst'];
            $invsno=$_POST['invsno'];
            $techname=$_POST['techname'];
            $hname=$_POST['hname'];

$res=mysqli_query($con,"UPDATE tbl_sbill SET bdate='$bdate',cmobile='$cmobile',ctot='$grandtot',ctax='$taxtot',cname='$cname',caddress='$caddress',cgst='$cgst',invsno='$invsno',techname='$techname',hname='$hname' WHERE ids='$cid'");

$getmax=mysqli_insert_id($con);

$rowcnt=$_POST['rowcnt'];

$deldet=mysqli_query($con,"DELETE FROM tbl_sbilld WHERE bid='$cid'");
                $delstk=mysqli_query($con,"DELETE FROM tbl_stock WHERE st_invno='$invno'");

for($i=1;$i<=$rowcnt;$i++){

$prodname=$_POST['prodname'.$i];
						$quan=$_POST['quan'.$i];
						$price=$_POST['price'.$i];
						$gst=$_POST['gst'.$i];
						$tax=$_POST['tax'.$i];
						$total=$_POST['total'.$i];
                        $unit=$_POST['unit'.$i];
                        $pbarcode=$_POST['pbarcode'.$i];
                        $proddesc=$_POST['proddesc'.$i];
						$subt=floatval($total)-floatval($tax);

if($prodname!=''){

$getprods=f(q("SELECT * FROM tbl_products WHERE p_name='$prodname'"));
                                    $pnames=$getprods['p_name'];
                                    $pids=$getprods['p_ids'];
                                    $muq=f(q("SELECT * FROM tbl_unit WHERE u_id='$getprods[m_unit]'"));
                                    $suq=f(q("SELECT * FROM tbl_unit WHERE u_id='$getprods[s_unit]'"));

$munit=$muq['u_name'];
                                    $sunit=$suq['u_name'];
                                    $conv=$getprods['mtos'];

if($sunit!=''){

$squan=floatval($quan)*floatval($conv);
                                        $mquan=$quan;

}else{

$squan=0;
                                        $mquan=$quan;
                                    }

$insdet=mysqli_query($con,"INSERT INTO tbl_sbilld SET bid='$cid',bdate='$bdate',prodcode='$prodname',prodesc='$prodname',prodq='$quan',prodpr='$price',prodgst='$gst',prodgstv='$tax',prodtotal='$total',prodsub='$subt',produnit='$unit',prodbarcode='$pbarcode',proddesc='$proddesc',com_id='$compaid'");

if($insdet){
                                            $lastbilld=mysqli_insert_id($con);
                                             $instock=mysqli_query($con,"INSERT INTO tbl_stock SET st_date='$bdate',st_prodid='$pids',st_quan='-$quan',st_munit='$mquan',st_sunit='$squan',st_type='Sales',st_invno='$invno',st_prodname='$pnames',st_trn=1,st_barcode='$pbarcode',st_linkid='$lastbilld',com_id='$compaid'");

}

//echo "<script>alert('Data Updated Successfully')</script>"; ?>
			<script>	
			window.open("saleprint.php?cid=<?php echo $cid?>","_blank");
		</script>
        		
				<script type="text/javascript">
				swal({ title: "Smart Billing",
				text: "Data Updated",
				type: "success"}).then(okay => {
				if (okay) {
				window.location.href = "salebilllist.php";
				}
				});
				</script>

<?php

//header("Location:create.php");

}elseif($action=='edit'){

$cid=$_REQUEST['cids'];

$edit=f(q("SELECT * FROM tbl_sbill WHERE ids='$cid'"));
				$cnts=f(q("SELECT COUNT(*) as cnt FROM tbl_sbilld WHERE bid='$cid'"));
				$rowcnt=$cnts['cnt'];

}

$getmaxids=f(q("SELECT MAX(ids) as maxid FROM tbl_sbill"));
$newinv=floatval($getmaxids['maxid'])+1;

width: 150px;
			font-size: 12px;
		}
		.oinput{

width: 120px;
			font-size: 12px;
		}
        th{

font-size:12px;
        }

</style>
	 <script>
                    function addtablerow(){
                        var table = document.getElementById("purtable");
                        var pname=document.getElementById('pname').value;
                        var unt=document.getElementById('unit').value;
                        var quan=document.getElementById('quan').value;
                        var price=document.getElementById('price').value;
                        var gst=document.getElementById('gst').value;
                        var tax=document.getElementById('gstval').value;
                        var total=document.getElementById('rowtot').value;
                        var cnt=document.getElementById('rowcnt').value;
                        var pbarcode=document.getElementById('pbarcode').value;
                        var proddesc=document.getElementById('proddesc').value;
                        document.getElementById('pbarcode').value = "";
                        
                        if(cnt==0){

cnt=parseFloat(cnt)+1;
                        }else{
                            cnt=parseFloat(cnt)+1;
                        }
                        document.getElementById('rowcnt').value=cnt;

var tr = document.createElement("tr");
                            var tdprodname = document.createElement("td");
                            var tdpbarcode = document.createElement("td");
                            var tdproddesc = document.createElement("td");
                            var tdquan = document.createElement("td");
                            var tdunit = document.createElement("td");
                            var tdprice = document.createElement("td");
                           var tdgst = document.createElement("td");
                            var tdtax = document.createElement("td");
                            var tdtotal = document.createElement("td");
                            var tddelete = document.createElement("td");

var txtpbarcode = document.createElement('input'); 
                            txtpbarcode.setAttribute('type','text'); // set attributes ...
                            txtpbarcode.setAttribute('name','pbarcode'+cnt);
                            txtpbarcode.setAttribute('class','prodet');
                            txtpbarcode.setAttribute('value',pbarcode);
                            
                            var txtproddesc = document.createElement('input'); 
                            txtproddesc.setAttribute('type','text'); // set attributes ...
                            txtproddesc.setAttribute('name','proddesc'+cnt);
                            txtproddesc.setAttribute('class','prodet');
                            txtproddesc.setAttribute('value',proddesc);

var txtprodid =document.createElement('input'); 
                            txtprodid.setAttribute('type','text'); // set attributes ...
                            txtprodid.setAttribute('name','prodname'+cnt);
                            txtprodid.setAttribute('class','prodet');
                            txtprodid.setAttribute('value',pname);  //document.createTextNode(prodid);

var txtunit = document.createElement('input'); 
                            txtunit.setAttribute('type','text'); // set attributes ...
                            txtunit.setAttribute('name','unit'+cnt);
                            txtunit.setAttribute('class','oinput');
                            txtunit.setAttribute('value',unt);  //document.createTextNode(quan);

var txtquan = document.createElement('input'); 
                            txtquan.setAttribute('type','text'); // set attributes ...
                            txtquan.setAttribute('name','quan'+cnt);
                            txtquan.setAttribute('class','oinput');
                            txtquan.setAttribute('value',quan);  //document.createTextNode(quan);

var txtprice = document.createElement('input'); 
                            txtprice.setAttribute('type','text'); // set attributes ...
                            txtprice.setAttribute('name','price'+cnt);
                            txtprice.setAttribute('class','oinput');
                            txtprice.setAttribute('value',price);  //document.createTextNode(price);

var txtgst = document.createElement('input'); 
                            txtgst.setAttribute('type','text'); // set attributes ...
                            txtgst.setAttribute('name','gst'+cnt);
                            txtgst.setAttribute('class','oinput');
                            txtgst.setAttribute('value',gst);  //document.createTextNode(gst);

var txttax = document.createElement('input'); 
                            txttax.setAttribute('type','text'); // set attributes ...
                            txttax.setAttribute('name','tax'+cnt);
                            txttax.setAttribute('id','tax'+cnt);
                            txttax.setAttribute('class','oinput');
                            txttax.setAttribute('value',tax);  //document.createTextNode(tax);

var txttotal = document.createElement('input'); 
                            txttotal.setAttribute('type','text'); // set attributes ...
                            txttotal.setAttribute('name','total'+cnt);
                            txttotal.setAttribute('id','total'+cnt);
                            txttotal.setAttribute('class','oinput');
                            txttotal.setAttribute('value',total);  //document.createTextNode(total);

var butt = document.createElement('input'); // create a button
								butt.setAttribute('type','button'); // set attributes ...
								butt.setAttribute('name','javaSubmit');
								butt.setAttribute('class','oinput');
								butt.setAttribute('value','remove');

butt.onclick = function() { // set onclick handler
								  deleteRow(this);
								  
								}

tdpbarcode.appendChild(txtpbarcode);    
                            tdprodname.appendChild(txtprodid);
                            tdproddesc.appendChild(txtproddesc);
                            tdquan.appendChild(txtquan);
                            tdunit.appendChild(txtunit);    
                            tdprice.appendChild(txtprice);
                            tdgst.appendChild(txtgst);
                            tdtax.appendChild(txttax);
                            tdtotal.appendChild(txttotal);
                            tddelete.appendChild(butt);

tr.appendChild(tdpbarcode);   
                            tr.appendChild(tdprodname);
                            tr.appendChild(tdproddesc); 
                            tr.appendChild(tdquan);
                             tr.appendChild(tdunit);
                            tr.appendChild(tdprice);
                            tr.appendChild(tdgst);
                            tr.appendChild(tdtax);
                            tr.appendChild(tdtotal);
                            tr.appendChild(tddelete);

table.appendChild(tr);

var gtot=0;
                                var txtoto=0;
                                    for(a=1;a<=cnt;a++){
                                        try{
                                            var tots=document.getElementById('total'+a).value;
                                        var taxtots=document.getElementById('tax'+a).value;
                                        //alert(tots);
                                        gtot=parseFloat(gtot)+parseFloat(tots);
                                        txtoto=parseFloat(txtoto) + parseFloat(taxtots);

}catch(e) {
                                                        
                                                    }

}
                                    document.getElementById('grandtot').value=gtot;
                                   document.getElementById('taxtot').value=txtoto;
                                  //calculateRowtot('purtable');

document.getElementById('pbarcode').focus();
                                   document.getElementById('pname').value='';
                                   document.getElementById('quan').value='0';
                                   document.getElementById('price').value='0';
                                   document.getElementById('rowtot').value='0';
                                   document.getElementById('gstval').value='0';

}
                    function deleteRow(btn) {
                        var row = btn.parentNode.parentNode;
                        row.parentNode.removeChild(row);
                        var cnt=document.getElementById('rowcnt').value;
                        //cnt=parseFloat(cnt)-1;    
                        var gtot=0;
                        var txtoto=0;
                                    for(a=1;a<=cnt;a++){
                                        try{
                                            var tots=document.getElementById('total'+a).value;
                                        var taxtots=document.getElementById('tax'+a).value;
                                        //alert(tots);
                                        gtot=parseFloat(gtot)+parseFloat(tots);
                                        txtoto=parseFloat(txtoto) + parseFloat(taxtots);

}catch(e) {
                                                        
                                                    }

}
                                    document.getElementById('grandtot').value=gtot;
                                    document.getElementById('taxtot').value=txtoto;
                        }
                    function CalculateRow() {
                        var gst=document.getElementById('gst').value;
                        var quan=document.getElementById('quan').value;
                        var price=document.getElementById('price').value;
                       var netamt=parseFloat(quan)*parseFloat(price);
                      // alert(netamt);
                       var gstamt=parseFloat(netamt)*(parseFloat(gst)/100);
                       document.getElementById('gstval').value=gstamt;
                       var totamt=parseFloat(netamt)+parseFloat(gstamt);
                       document.getElementById('rowtot').value=totamt;
                        }

border: 1px solid lightgray;
                		padding-left: 5px;
                	}
                    label{

font-size: 10px;
                    }

.form-control{

font-size: 0.575rem !important;
                    }
                </style>
    
   <script src="https://stock.thetechnozone.in/getprod.js"></script>
	
	<div class="container-fluid py-4">
    <link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
      
      <div class="row mb-4" style="margin-top: 1%;">
        
        <div class="col-lg-12 col-md-12">
          <div class="card h-100" style="min-height: 300px;padding: 3%;">

<h4>Create New Sales Bill</h4>
          		<form action="<?php echo $_SERVER['PHP_SELF']?>?action=<?php if($action=='edit'){?>update&cids=<?php echo $cid;}else{?>save<?php } ?>" method="POST">
          		<div class="row">
          				<input type="hidden" name="rowcnt" id="rowcnt" value="<?php if($action=='edit'){ ?><?php echo $rowcnt;}else{?>0<?php } ?>">
          			
			                    <input type="hidden" class="form-control border" name="invno" required placeholder="Invoice Number" value="<?php if($action=='edit'){?><?php echo $edit['invno']?><?php }else{ echo $newinv; }?> ">
			                
          			<div class="col-md-3">
          					<?php

$bdt=date("Y-m-d",strtotime($edit['bdate']));

?>
          					
			                    <label class="form-label">Date</label>
			                    <input type="text" id="strdt" class="form-control border" name="bdate" placeholder="Invoice Date" value="<?php if($action=='edit'){?><?php echo $bdt?><?php }else{ echo date("d-m-Y"); }?> " style="font-size: 14px !important;">

</div>
                      <div class="col-md-3">

<label class="form-label">Jobsheet/Invoice</label>
    <input type="text" class="form-control border" placeholder="Jobsheet / Invoice" name="invsno" value="<?php if($action=='edit'){?><?php echo $edit['invsno']?><?php }?> " required>

</div>
                    <div class="col-md-3">

<label class="form-label">Mobile Number</label>
                                <input type="text" class="form-control border" placeholder="Mobile Number" name="cmobile" value="<?php if($action=='edit'){?><?php echo $edit['cmobile']?><?php }?> ">

</div>
          			<div class="col-md-3">

<label class="form-label">Customer Name</label>
			                    <input type="text" name="cname" class="form-control border" value="<?php if($action=='edit'){?><?php echo $edit['cname']?><?php }?> ">

</div>
          			
                    <div class="col-md-3">

<label class="form-label">Address</label>
                                <input type="text" class="form-control border" placeholder="Address" name="caddress" value="<?php if($action=='edit'){?><?php echo $edit['caddress']?><?php }?> ">

</div>
                    <div class="col-md-3">

<label class="form-label">GSTN</label>
                                <input type="text" class="form-control border" placeholder="GSTN" name="cgst" value="<?php if($action=='edit'){?><?php echo $edit['cgst']?><?php }?> ">

</div>
                    <div class="col-md-3">

<label class="form-label">Technician Name</label>
                                <input type="text" class="form-control border" placeholder="Technician Name" name="techname" value="<?php if($action=='edit'){?><?php echo $edit['techname']?><?php }?> ">

</div>
                    <div class="col-md-3">

<label class="form-label">Handler Name</label>
                                <input type="text" class="form-control border" placeholder="Handler Name" name="hname" value="<?php if($action=='edit'){?><?php echo $edit['hname']?><?php }?> ">

</div>

</div>
          		<div class="row">
          				<div class="col-md-12">
          							<h6>Add Product Details</h6>
          				</div>
                          <div class="col-md-12">
                                <div class="row">
                                    <div class="col-md-4">
                                    <label>Scan Barcode</label>
                                        <div class="input-group input-group-outline">
                                            <input type="text" class="form-control" name="pbarcode" id="pbarcode" onblur="getprod(this.value)" onchange="getprod(this.value)"><br>
                                            
                                        </div>
                                        <small>&nbsp;<span id="curstock" style="font-size:12px;"></span></small>
                                    </div>
									 <div class="col-md-4" >
									 
										<img src="loading-image.gif" id="loading-image" style="visibility:hidden;">
									 </div>
                                </div>

<hr>

</div>    
          			<div class="col-md-3">
          					<label>Product Details</label>
          					<div class="input-group input-group-outline">
			                    <input type="text" class="form-control" name="pname" id="pname" list="" readonly>
                                <datalist id="prodlist" name="prodlist">
                                    <?php

$pr=mysqli_query($con,"SELECT * FROM tbl_products WHERE p_for<>'1'");
                                         while($arrp=mysqli_fetch_array($pr)){

?>
                                    <option value="<?php echo $arrp['p_code']?>"><?php echo  $arrp['p_name']?></option>

<?php } ?>
                                </datalist>
			                   
			                    
			                 </div>

</div>
                      <div class="col-md-4">
                            <label>Description</label>
                            <div class="input-group input-group-outline">
                               
                               <textarea name="proddesc" id="proddesc" class="form-control"></textarea>
                             </div>

</div>
          			<div class="col-md-3">
          					<label>Quantity</label>
          					<div class="input-group input-group-outline">
			                   
			                    <input type="text" class="form-control" placeholder="Quan" id="quan" name="quan"  value="0">
                                <input type="text" class="form-control" placeholder="unit" id="unit" name="unit"  value="" list="ulist">
                                <datalist id="ulist">
                                        <?php

$qs=mysqli_query($con,"SELECT * FROM  tbl_unit");
                                            while($arru=mysqli_fetch_array($qs)){

<?php } ?>

</datalist>
			                 </div>

</div>
                    
          			<div class="col-md-2">
          					<label>Price</label>
          					<div class="input-group input-group-outline">
			                   
			                    <input type="text" class="form-control" placeholder="Price" id="price" name="price"  value="0" onblur="CalculateRow()">
			                 </div>

</div>
          			<div class="col-md-1">
          					<label>GST</label>
          					<div class="input-group input-group-outline">
			                   
			                    <select class="form-control" name="gst" id="gst" onchange="CalculateRow()">
			                    		<option value="0">GST</option>
			                    		<option value="0">0%</option>
			                    		<option value="5">5%</option>
			                    		<option value="12">12%</option>
			                    		<option value="18">18%</option>
			                    		<option value="24">24%</option>
			                    </select>
			                 </div>

</div>
          			<div class="col-md-1">
          					<label>GST Amt</label>
          					<div class="input-group input-group-outline">
			                   
			                    <input type="text" class="form-control" placeholder="Tax Amount" name="gstval" id="gstval"  value="0">
			                 </div>

</div>
          			<div class="col-md-2">
          					<label>Total Amt</label>
          					<div class="input-group input-group-outline">
			                   
			                    <input type="text" class="form-control" placeholder="Total Amount" id="rowtot" name="rowtot"  value="0">
			                 </div>

</div>
          			<div class="col-md-1" style="padding-top: 6px;">

</div>

</div><br>
          		<div class="row">

<table id="purtable" style="width:100%;">
                                        <tr style="background-color: #1c1446;">
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label" style="color:white;">Batch No</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label" style="color:white;">Product</label></th>
                                        
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label" style="color:white;">Details</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label" style="color:white;">Quantity</label></th>
                                         <th><label for="fname" class="col-sm-12 control-label col-form-label" style="color:white;">Unit</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label" style="color:white;">Price</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label" style="color:white;">GST</label></th>
                                        <th> <label for="fname" class="col-sm-12 control-label col-form-label" style="color:white;">Tax Amount</label></th>
                                        <th>  <label for="fname" class="col-sm-12 control-label col-form-label" style="color:white;">Total Amount</label></th>
                                        <th style="text-align: center;">  <label for="fname" class="col-sm-12 control-label col-form-label"  style="color:white;"><i class="fa fa-minus"></i></label></th>
                                        </tr>
                                        <? if($action=='edit'){ 
                                                $i=1;
                                                $getprodet=mysqli_query($con,"SELECT * FROM tbl_sbilld WHERE bid='$cid'");
                                                while($arrdets=mysqli_fetch_array($getprodet)){
                                                    
                                            ?>
                                            <tr>
                                            <td><input type="text" class="prodet" name="pbarcode<?php echo $i?>" value="<?php echo $arrdets['prodbarcode']?>"></td>
                                                <td><input type="text" class="prodet" name="prodname<?php echo $i?>" value="<?php echo $arrdets['prodesc']?>"></td>
                                                
                                                <td><input type="text" class="prodet" name="proddesc<?php echo $i?>" value="<?php echo $arrdets['proddesc']?>"></td>
                                                <td><input type="text"  class="oinput"  name="quan<?php echo $i?>" value="<?php echo $arrdets['prodq']?>"></td>
                                                <td><input type="text"  class="oinput"  name="unit<?php echo $i?>" value="<?php echo $arrdets['produnit']?>"></td>
                                                <td><input type="text" class="oinput" name="price<?php echo $i?>" value="<?php echo $arrdets['prodpr']?>"></td>
                                                <td><input type="text"  class="oinput" name="gst<?php echo $i?>" value="<?php echo $arrdets['prodgst']?>"></td>
                                                <td><input type="text"  class="oinput" name="tax<?php echo $i?>" id="tax<?php echo $i?>" value="<?php echo $arrdets['prodgstv']?>"></td>
                                                <td><input type="text" class="oinput"  name="total<?php echo $i?>" id="total<?php echo $i?>" value="<?php echo $arrdets['prodtotal']?>"></td>
                                                <td><input type="button" name="javaSubmit" value="remove" onClick="deleteRow(this)"></td>

</tr>   
                                                <? $i=$i+1; } ?> 
                                        <? } ?>

</table>
                                    <table style="width:100%;">
                                        <tr>
                                            <td class="prodet" ></td>
                                            <td  class="oinput"></td>
                                            <td  class="oinput"></td>
                                            <td  class="oinput"></td>
                                            <td  class="oinput"></td>
                                            <td  class="oinput"></td>
                                            <td  class="oinput"><b>TOTAL : </b></td>
                                            
                                            <td><input type="text" name="taxtot" id="taxtot" class="oinput" value="<?php if($action=='edit'){ echo $edit['ctax'];}?>"></td>
                                            <td><input type="text" name="grandtot" id="grandtot"  class="oinput" value="<?php if($action=='edit'){ echo $edit['ctot'];}?>"></td>
                                            <td  class="oinput"></td>
                                        </tr>

</table>

</div>

</div>
          		<div class="row">

</div>

</form>

</div>
        </div>
      </div>

<?php include "footer.php"; ?>
	
<script type="text/javascript">
	$(document).ready(function() {
  $(window).keydown(function(event){
    if(event.keyCode == 13) {
      event.preventDefault();
      return false;
    }
  });
});
</script>
<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
  <script>
  $( function() {
    $( "#strdt" ).datepicker({
      changeMonth: true,
      changeYear: true,
      dateFormat: "dd-mm-yy"
    });
    //$( "#strdt" ).datepicker( "option", "dateFormat", "yy-mm-dd" );

$( "#enddt" ).datepicker({
      changeMonth: true,
      changeYear: true
    });
    //$( "#enddt" ).datepicker( "option", "dateFormat", "yy-mm-dd" );
  } );

</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: sbill.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation