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/systemuniq

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: addcbill.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$action=isset($_REQUEST['action'])?$_REQUEST['action']:'Add';
$editid=isset($_REQUEST['editid'])?$_REQUEST['editid']:'';
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']) : '';
	$doc_date=isset($_POST['doc_date']) ? addslashes($_POST['doc_date']) : '';
	$cus_pay=isset($_POST['cus_pay']) ? addslashes($_POST['cus_pay']) : '';
	$cust_id=isset($_POST['cust_id']) ? addslashes($_POST['cust_id']) : '';
	$insert_sql_data=array('sl_date'=>$dc,
	'cus_pay'=>$cus_pay,
	'cust_id'=>$cust_id,
	'sl_st'=>"1",
	'sl_unid'=>$so_no,
	'sl_docdate'=>$doc_date
	);
    $ins_query=tep_db_perform("sales_cheader",$insert_sql_data,"insert");
	//print $ins_query;exit();
	$ref=mysqli_insert_id($con);
	$norows=$_POST['norows'];
	for($i=1;$i<=$norows;$i++) {
		$itemtot="";
		
		$one="proname".$i;
		$three="bqty".$i;
		$thrun="unit".$i;
		$four="rate".$i;
		$seven="stotal".$i;
		
		$proname=$_POST[$one];
		$qty=$_POST[$three];
		$unit=$_POST[$thrun];
		$rate=$_POST[$four];
		//$stotal=$_POST[$seven];
	    
		$stotal=$rate*$qty;
		$itemtot=round($stotal,2);
		$totalitemval+=$itemtot;
			  
		if($proname!="" && $qty!="" && $rate!="") {
			$insert_sql_data=array('sl_id'=>$ref,
			'pro_name'=>$proname,
			'sales_qty'=>$qty,
			'sales_unit'=>$unit,
			'sales_rate'=>$rate,
			'sales_tval'=>$itemtot
			);
			$ins_query=tep_db_perform("sales_citem",$insert_sql_data,"insert");
		}
	}
	$totalitemval=round($totalitemval,2);
	mysqli_query($con,"update `sales_cheader` set `sl_total`='".$totalitemval."' where `sl_id`='".$ref."'");
	$insert_sql_data=array('customer'=>$cust_id,
	'blid'=>$ref,
	'blno'=>$so_no,
	'bamount'=>$totalitemval,
	'date'=>$doc_date,
	'status'=>'1'
	);
	tep_db_perform('cust_acc_ch',$insert_sql_data,'insert');
	if($ins_query) {
	    $_SESSION['msg']="Successfully Added.";
		//header("location:bill.php?id=".$ref);
		header("location:addcbill.php");
		exit();
	}
	else {
	    $_SESSION['msgerr']="Some Error Occured.";
		header("location:addcbill.php");
		exit();
	}
}
if(isset($_POST['submitin']) && $_POST['submitin']=="Edit") {
	$totalitemval=0;
	$ctax_val=0;
	$gross=0;
	$net_val=0;
    $doc_date=isset($_POST['doc_date']) ? addslashes($_POST['doc_date']) : '';
	$cus_pay=isset($_POST['cus_pay']) ? addslashes($_POST['cus_pay']) : '';
	$cust_id=isset($_POST['cust_id']) ? addslashes($_POST['cust_id']) : '';
	$insert_sql_data=array('cus_pay'=>$cus_pay,
	'cust_id'=>$cust_id,
	'sl_docdate'=>$doc_date,
	);
    $ins_query=tep_db_perform("sales_cheader",$insert_sql_data,"update","sl_id=".$editid);
	$ref=$editid;
	mysqli_query($con,"delete from `sales_citem` where `sl_id`='".$editid."'");
	$norows=$_POST['norows'];
	$norows=$_POST['norows'];
	for($i=1;$i<=$norows;$i++) {
		$itemtot="";
		
		$one="proname".$i;
		$three="bqty".$i;
		$thrun="unit".$i;
		$four="rate".$i;
		$seven="stotal".$i;
		
		$proname=$_POST[$one];
		$qty=$_POST[$three];
		$unit=$_POST[$thrun];
		$rate=$_POST[$four];
		//$stotal=$_POST[$seven];
	    
		$stotal=$rate*$qty;
		$itemtot=round($stotal,2);
		$totalitemval+=$itemtot;
			  
		if($proname!="" && $qty!="" && $rate!="") {
			$insert_sql_data=array('sl_id'=>$ref,
			'pro_name'=>$proname,
			'sales_qty'=>$qty,
			'sales_unit'=>$unit,
			'sales_rate'=>$rate,
			'sales_tval'=>$itemtot
			);
			$ins_query=tep_db_perform("sales_citem",$insert_sql_data,"insert");
		}
	}
	$totalitemval=round($totalitemval,2);
	mysqli_query($con,"update `sales_cheader` set `sl_total`='".$totalitemval."' where `sl_id`='".$ref."'");
	mysqli_query($con,"update `cust_acc_ch` set `bamount`='".$totalitemval."' where `blid`='".$ref."'");
	if($ins_query) {
	    $_SESSION['msg']="Successfully Added.";
		header("location:billc.php?id=".$editid);
		exit();
	}
	else {
	    $_SESSION['msgerr']="Some Error Occured.";
		header("location:addcbill.php");
		exit();
	}
}
if($_POST['submitin']=="" && $action=="Edit") {
	$rowm=mysqli_fetch_array(mysqli_query($con,"select * from `sales_cheader` where `sl_id`='".$editid."'"));
	$newid=$rowm['sl_unid'];
	$dt=$rowm['sl_docdate'];
}
if($dt=="") {
	$dt=date("Y-m-d");
}
if($action=="Add") {
	$newid="";
	$res=mysqli_query($con,"select * from `sales_cheader` order by `sl_id` desc"); //where `cust_id`='".$_REQUEST['customer']."' 
	$num=mysqli_num_rows($res);
	if(mysqli_num_rows($res)<1) {
	   $newid="1";
	}
	if(mysqli_num_rows($res)>=1) {
	   $row=mysqli_fetch_array($res);
	   $last_id=$row['sl_unid'];
	   //$last_no=substr($last_id,3,12);
	   //$new_no=$last_no+1;
	   $new_no=$last_id+1;
	   //$newid="BLJ";
	   //$newid.=$new_no;
	   $newid=$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 = "proname" + 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 = "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 == 3) {
            var tname = "unit" + 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 == 4) {
            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 == 5) {
            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); } 
}
function customer(val) {
	location.href='addcbill.php?customer='+val;
}
</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-3 floatleft">
									<label for="example-text-input" class="col-form-label">Customer</label>
									<select class="form-control" name="cust_id" id="cust_id" required>  
										<option value="">Select
										<?php
										$resc=mysqli_query($con,"select `id`,`name` from `customer_master_ch` where `status`='1'");
										while($rowc=mysqli_fetch_object($resc)) {
										?>
											<option value="<?php print $rowc->id; ?>" <?php if($rowc->id==$rowm['cust_id'] || $rowc->id==$_REQUEST['customer']) { ?>selected<?php } ?>><?php print $rowc->name ?>
										<?php } ?>
									</select>
								</div>		
								<div class="form-group col-md-3 floatleft">
									<label for="example-text-input" class="col-form-label">Bill No.</label>
									<input class="form-control sphgt" type="text" name="so_no" id="so_no" required value="<?php print $newid; ?>">
								</div>
								<div class="form-group col-md-3 floatleft">
									<label for="example-text-input" class="col-form-label">Date</label>
									<input class="form-control sphgt" type="date" name="doc_date" id="doc_date" required value="<?php print $dt; ?>">
								</div>
								<div class="form-group col-md-3 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" <?php if($rowm['cus_pay']=="Cash") { ?>selected<?php } ?>>Cash
										<option value="Credit" <?php if($rowm['cus_pay']=="Cash") { ?>selected<?php } ?>>Credit
										<option value="UPI" <?php if($rowm['cus_pay']=="Cash") { ?>selected<?php } ?>>UPI
										<option value="Others" <?php if($rowm['cus_pay']=="Cash") { ?>selected<?php } ?>>Others
									</select>	
								</div>
								<?php /* ?><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 value="<?php print $rowm['cus_name']; ?>">
								</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" value="<?php print $rowm['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" value="<?php print $rowm['cus_phone']; ?>" onKeyUp="fetchcname();fetchcaddress();" onKeyDown="fetchcname();fetchcaddress();" onBlur="fetchcname();fetchcaddress();">
								</div><?php */ ?>
								<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%" class="pd0">Chk</th>
										<th width="46%" class="pd0">Product</th>
										<th width="14%" class="pd0">Qty</th>
										<th width="14%" class="pd0">Unit</th>
										<th width="14%" class="pd0">Rate</th>
										<th width="12%" class="pd0">Total</th>
									</tr>  
								</table>	  
								<table id="dataTable" width="100%" border="0">
									<?php 
									if($action=="Add") { 
									?>
										<tr>
											<td width="6%" class="pd0"><input type="checkbox" name="chk1"></td>
											<td width="49%" class="pd0"><input type="text" name="proname1" id="proname1" class="form-control" style="width: 200px;" required></td>
											<td width="15%" class="pd0"><input type="text" name="bqty1" id="bqty1" class="form-control" style="width: 100px;" required autocomplete="off" onKeyUp="totcamount(this.name,4);" onKeyDown="totcamount(this.name,4);" onBlur="totcamount(this.name,4);"></td>
											<td width="15%" class="pd0">
												<select name="unit1" id="unit1" class="form-control" style="width: 100px;">
													<option value="">Select
													<option value="Box">Box
													<option value="Pc">Pc
													<option value="Pr">Pr
													<option value="Set">Set
												</select>
											</td>
											<td width="15%" class="pd0"><input type="text" name="rate1" id="rate1" class="form-control" style="width: 100px;" autocomplete="off" onKeyUp="totcamount(this.name,4);" onKeyDown="totcamount(this.name,4);" onBlur="totcamount(this.name,4);"></td>
											<td width="15%" class="pd0"><input type="text" name="stotal1" id="stotal1" class="form-control" style="width: 100px;"></td>
											</tr>
										</tr>
									<?php 
									} else { 
										$count=1;
										$done_mat_code="";
										$totalitemval=0;
										$respi=mysqli_query($con,"select * from `sales_citem` where `sl_id`='".$editid."'");
										while($rowpi=mysqli_fetch_array($respi)) {
											$totalitemval+=$rowpi['sales_tval'];
									?>
											<tr>
												<td width="6%" class="pd0" style="padding: 5px;"><input type="checkbox" name="chk<?php print $count; ?>"></td>
												<td width="49%" class="pd0" style="padding: 5px;"><input type="text" name="proname<?php print $count; ?>" id="proname<?php print $count; ?>" class="form-control" style="width: 200px;" required value="<?php print $rowpi['pro_name']; ?>"></td>
												<td width="15%" class="pd0" style="padding: 5px;"><input type="text" name="bqty<?php print $count; ?>" id="bqty<?php print $count; ?>" class="form-control" style="width: 100px;" required autocomplete="off" onKeyUp="totcamount(this.name,4);" onKeyDown="totcamount(this.name,4);" onBlur="totcamount(this.name,4);" value="<?php print $rowpi['sales_qty']; ?>"></td>
												<td width="15%" class="pd0" style="padding: 5px;">
													<select name="unit" id="unit" class="form-control" style="width: 100px;">
														<option value="">Select
														<option value="Pc" <?php if($rowpi['sales_unit']=="Pc") { ?>selected<?php } ?>>Pc
														<option value="Pr" <?php if($rowpi['sales_unit']=="Pr") { ?>selected<?php } ?>>Pr
														<option value="Set" <?php if($rowpi['sales_unit']=="Set") { ?>selected<?php } ?>>Set
													</select>
												</td>
												<td width="15%" class="pd0"><input type="text" name="rate<?php print $count; ?>" id="rate<?php print $count; ?>" class="form-control" style="width: 100px;" autocomplete="off" onKeyUp="totcamount(this.name,4);" onKeyDown="totcamount(this.name,4);" onBlur="totcamount(this.name,4);" value="<?php print $rowpi['sales_rate']; ?>"></td>
												<td width="15%" class="pd0"><input type="text" name="stotal<?php print $count; ?>" id="stotal<?php print $count; ?>" class="form-control" style="width: 100px;" value="<?php print $rowpi['sales_tval']; ?>"></td>
												</tr>
											</tr>
										<?php $count++; } ?>	
										<tr>
											<td width="6%" class="pd0"><input type="checkbox" name="chk<?php print $count; ?>"></td>
											<td width="49%" class="pd0"><input type="text" name="proname<?php print $count; ?>" id="proname<?php print $count; ?>" class="form-control" style="width: 200px;" required></td> 
											<td width="15%" class="pd0"><input type="text" name="bqty<?php print $count; ?>" id="bqty<?php print $count; ?>" class="form-control" style="width: 50px;" required autocomplete="off" onKeyUp="totcamount(this.name,4);" onKeyDown="totcamount(this.name,4);" onBlur="totcamount(this.name,4);"></td>
											<td width="15%" class="pd0">
												<select name="unit1" id="unit1" class="form-control" style="width: 100px;">
													<option value="">Select
													<option value="Pc">Pc
													<option value="Pr">Pr
													<option value="Set">Set
												</select>
											</td>
											<td width="15%" class="pd0"><input type="text" name="rate<?php print $count; ?>" id="rate<?php print $count; ?>" class="form-control" style="width: 100px;" autocomplete="off" onKeyUp="totcamount(this.name,4);" onKeyDown="totcamount(this.name,4);" onBlur="totcamount(this.name,4);"></td>
											<td width="15%" class="pd0"><input type="text" name="stotal<?php print $count; ?>" id="stotal<?php print $count; ?>" class="form-control" style="width: 100px;"></td>
											</tr>
										</tr>
									<?php } ?>	
								</table>
								<div id="productbox"></div>
								<div class="cleaner h20"></div>
								<div class="form-group floatleft ftbld" id="totalval"></div>	
								<div class="cleaner"></div>
								<?php if($action=="Add") { ?>
									<input type="hidden" name="norows" id="norows" value="1">
									<input type="hidden" name="totalitemval" id="totalitemval" value="0">
								<?php } else { ?>
									<input type="hidden" name="norows" id="norows" value="<?php print $count; ?>">
									<input type="hidden" name="totalitemval" id="totalitemval" value="<?php print $totalitemval; ?>">
								<?php } ?>	
								<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: addcbill.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation