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: addstock.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");
    $po_no=isset($_POST['po_no']) ? addslashes($_POST['po_no']) : '';
	$doc_date=isset($_POST['doc_date']) ? addslashes($_POST['doc_date']) : '';
	$insert_sql_data=array('pr_date'=>$dc,
	'pr_st'=>"1",
	'pr_unid'=>$po_no,
	'pr_docdate'=>$doc_date
	);
    $ins_query=tep_db_perform("pr_header",$insert_sql_data,"insert");
	$ref=mysqli_insert_id($con);
	$norows=$_POST['norows'];
	for($i=1;$i<=$norows;$i++) {
		$one="proref".$i;
		$three="qty".$i;
		
		$proref=$_POST[$one];
		$prorefarr=explode("-",$proref);
		$proref=$prorefarr['0'];
		$qty=$_POST[$three];
	
		if($proref!="" && $qty!="") {
			$comp=mysqli_fetch_array(mysqli_query($con,"select * from `product_master` where `pro_code`='".$proref."'"));
			$insert_sql_data=array('pr_id'=>$ref,
			'pro_code'=>$proref,
			'pr_qty'=>$qty
			);
			$ins_query=tep_db_perform("pr_item",$insert_sql_data,"insert");
			if($qty!="") {
				$stock=$comp['pro_stock']+$qty;
				mysqli_query($con,"update `product_master` set `pro_stock`='".$stock."' where `pro_code`='".$proref."'");
			}
		}
	}
	if($ins_query) {
	    $_SESSION['msg']="Successfully Added.";
		header("location:viewstocks.php");
		exit();
	}
	else {
	    $_SESSION['msgerr']="Some Error Occured.";
		header("location:viewstocks.php");
		exit();
	}
}
if(isset($_POST['submitin']) && $_POST['submitin']=="Edit") {
    $doc_date=isset($_POST['doc_date']) ? addslashes($_POST['doc_date']) : '';
	$insert_sql_data=array('pr_docdate'=>$doc_date,
	);
    $ins_query=tep_db_perform("pr_header",$insert_sql_data,"update","pr_id=".$editid);
	$ref=$editid;
	$respi=mysqli_query($con,"select * from `pr_item` where `pr_id`='".$editid."'");
	while($rowpi=mysqli_fetch_array($respi)) {
		$rowstk=mysqli_fetch_array(mysqli_query($con,"select `pro_stock` from `product_master` where `pro_code`='".$rowpi['pro_code']."'"));
		$stk=$rowstk['pro_stock']-$rowpi['qty'];
		mysqli_query($con,"update `product_master` set `pro_stock`='".$stk."' where `pro_code`='".$rowpi['pro_code']."'");
	}
	mysqli_query($con,"delete from `pr_item` where `pr_id`='".$editid."'");
	$norows=$_POST['norows'];
	for($i=1;$i<=$norows;$i++) {
		$one="proref".$i;
		$three="qty".$i;
		
		$proref=$_POST[$one];
		$prorefarr=explode("-",$proref);
		$proref=$prorefarr['0'];
		$qty=$_POST[$three];
	
		if($proref!="" && $qty!="") {
			$comp=mysqli_fetch_array(mysqli_query($con,"select * from `product_master` where `pro_code`='".$proref."'"));
			$insert_sql_data=array('pr_id'=>$ref,
			'pro_code'=>$proref,
			'pr_qty'=>$qty
			);
			$ins_query=tep_db_perform("pr_item",$insert_sql_data,"insert");
			if($qty!="") {
				$stock=$comp['pro_stock']+$qty;
				mysqli_query($con,"update `product_master` set `pro_stock`='".$stock."' where `pro_code`='".$proref."'");
			}
		}
	}
	if($ins_query) {
	    //$_SESSION['msg']="Successfully Added.";
		header("location:bill.php?id=".$editid);
		exit();
	}
	else {
	    $_SESSION['msgerr']="Some Error Occured.";
		header("location:addbill.php");
		exit();
	}
}
if($_POST['submitin']=="" && $action=="Edit") {
	$rowm=mysqli_fetch_array(mysqli_query($con,"select * from `pr_header` where `pr_id`='".$editid."'"));
	$newid=$rowm['pr_unid'];
	$dt=$rowm['pr_docdate'];
}
if($dt=="") {
	$dt=date("Y-m-d");
}
if($action=="Add") {
	$newid="";
	$res=mysqli_query($con,"select * from `pr_header` order by `pr_id` desc");
	$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['pr_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 = "proref" + 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 = "size" + 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 = "shape" + 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 == 4) {
            var tname = "color" + 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 = "qty" + 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 karigar(val) {
	location.href='addbill.php?karigar='+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 Stock</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-6 floatleft">
									<label for="example-text-input" class="col-form-label">Purchase Bill No.</label>
									<input class="form-control sphgt" type="text" name="po_no" id="po_no" required value="<?php print $newid; ?>">
								</div>
								<div class="form-group col-md-6 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="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="34%" class="pd0">Product</th>
										<th width="15%" class="pd0">Size</th>
										<th width="15%" class="pd0">Shape</th>
										<th width="15%" class="pd0">Color</th>
										<th width="15%" class="pd0">Qty/Pc.</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="34%" class="pd0"><input type="text" name="proref1" id="proref1" class="form_txtbox wd150" size="15" onKeyUp="fetchproductst(this.name);" onKeyDown="fetchproductst(this.name);" required></td>
											<td width="15%" class="pd0"><input type="text" name="size1" id="size1" class="form_txtboxqty" size="15" required></td>
											<td width="15%" class="pd0"><input type="text" name="shape1" id="shape1" class="form_txtboxqty" size="15" required></td> 
											<td width="15%" class="pd0"><input type="text" name="color1" id="color1" class="form_txtboxqty" size="15" required></td> 
											<td width="15%" class="pd0"><input type="text" name="qty1" id="qty1" class="form_txtboxqty"></td>
											</tr>
										</tr>
									<?php 
									} else { 
										$count=1;
										$done_mat_code="";
										$totalitemval=0;
										$respi=mysqli_query($con,"select * from `pr_item` where `pr_id`='".$editid."'");
										while($rowpi=mysqli_fetch_array($respi)) {
											if($count==1) {
												$done_mat_code=$rowpi['pro_code'];
											} else {	
												$done_mat_code=",".$rowpi['pro_code'];
											}
											$rowstk=mysqli_fetch_array(mysqli_query($con,"select `pro_size`, `pro_shape`, `pro_color`, `pro_stock` from `product_master` where `pro_code`='".$rowpi['pro_code']."'"));
											$aqty=$rowstk['pro_stock']+$rowpi['qty'];
									?>
											<tr>
												<td width="6%" class="pd0"><input type="checkbox" name="chk<?php print $count; ?>"></td>
												<td width="34%" class="pd0"><input type="text" name="proref<?php print $count; ?>" id="proref<?php print $count; ?>" class="form_txtbox wd150" size="15" onKeyUp="fetchproductst(this.name);" onKeyDown="fetchproductst(this.name);" required value="<?php print $rowpi['pro_code']; ?>"></td> 
												<td width="15%" class="pd0"><input type="text" name="size<?php print $count; ?>" id="size<?php print $count; ?>" class="form_txtboxqty " readonly="true" value="<?php print $rowpi['pro_size']; ?>"></td>
												<td width="15%" class="pd0"><input type="text" name="shape<?php print $count; ?>" id="shape<?php print $count; ?>" class="form_txtboxqty " readonly="true" value="<?php print $rowpi['pro_shape']; ?>"></td>
												<td width="15%" class="pd0"><input type="text" name="color<?php print $count; ?>" id="color<?php print $count; ?>" class="form_txtboxqty " readonly="true" value="<?php print $rowpi['pro_color']; ?>"></td>
												<td width="15%" class="pd0"><input type="text" name="aqty<?php print $count; ?>" id="aqty<?php print $count; ?>" class="form_txtboxqty" value="<?php print $aqty; ?>"></td>
												</tr>
											</tr>
										<?php $count++; } ?>	
										<tr>
											<td width="6%" class="pd0"><input type="checkbox" name="chk<?php print $count; ?>"></td>
											<td width="34%" class="pd0"><input type="text" name="proref<?php print $count; ?>" id="proref<?php print $count; ?>" class="form_txtbox wd150" size="15" onKeyUp="fetchproductst(this.name);" onKeyDown="fetchproductst(this.name);" required></td> 
											<td width="15%" class="pd0"><input type="text" name="size<?php print $count; ?>" id="size<?php print $count; ?>" class="form_txtboxqty " readonly="true" value="<?php print $rowpi['pro_size']; ?>"></td>
											<td width="15%" class="pd0"><input type="text" name="shape<?php print $count; ?>" id="shape<?php print $count; ?>" class="form_txtboxqty " readonly="true"></td>
											<td width="15%" class="pd0"><input type="text" name="color<?php print $count; ?>" id="color<?php print $count; ?>" class="form_txtboxqty"></td>
											</tr>
										</tr>
									<?php } ?>	
								</table>
								<div id="productbox"></div>
								<div class="cleaner h20"></div>
								<?php if($action=="Add") { ?>
									<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">
								<?php } else { ?>
									<input type="hidden" name="norows" id="norows" value="<?php print $count; ?>">
									<input type="hidden" name="done_mat_code" id="done_mat_code" value="<?php print $done_mat_code; ?>">
									<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: addstock.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation