ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ-🛒 PHP v7.4.33

Current Path: home/oshofree/public_html/chbluxuries.com/chb_data/

Name	Size	Permissions	Actions
📁 ..	-	0755	🗑️
📄 config.php	7.06 KB	0444	🗑️ ⬇️ ✏️
📄 error_log	5468.61 KB	0644	🗑️ ⬇️ ✏️

Editing: stock_request.php

<?php include "admin_header.php";

if(isset($_GET['stock'])){
$group=$_GET['stock'];
}else{header("location: available_stocks.php"); }

$sqc = "SELECT * from stocks where group_id='$group' AND store='3'";
$sqcs = mysqli_query($con,$sqc);
while ($roc = mysqli_fetch_array($sqcs)) {
$cats=$roc["name"];
$stockid=$roc["id"];
}

$from= 3; 
$to= 1;

//get store names
$sqc = "SELECT * from chb_stores where s='$from'";
$sqcs = mysqli_query($con,$sqc);
while ($roc = mysqli_fetch_array($sqcs)) {
$first_store=$roc["name"];}

$sqc = "SELECT * from chb_stores where s='$to'";
$sqcs = mysqli_query($con,$sqc);
while ($roc = mysqli_fetch_array($sqcs)) {
$second_store=$roc["name"];}
include"requestscript.php";
?>

<h1 class="h6 mb-4 text-black-700" style="color:#000;"><?php echo $cats;?>(Request from <?php echo $first_store ?> to <?php echo $second_store ?>)</h1>
                     <div style="overflow-x:scroll;"><form action='' method='post'>
	   <table class='table table-condensed table-hover' style="font-size:12px;" width='90%' border="0" style="color:black;" cellspacing='10' data-toggle='bootgrid'>
       <thead><tr bgcolor="#FF339A" style="color:white;">
       <th data-column-id='employee_salary'  width='200px'>Variation</th>
       <th data-column-id='employee_salary'  width='200px'><?php echo $first_store; ?>Stocks</th>
	   <th data-column-id='employee_name'  width='200px'> <?php echo $second_store; ?> Stocks</th>
       <th data-column-id='employee_salary'  width='200px'>Quantity to request</th>
					
			</tr>
			</thead>
<?php //Get serial number
$sql = "SELECT * from variation WHERE group_id='$group' AND store ='$to'";
if($requestedcolor!=""){$sql = "SELECT * from variation WHERE group_id='$group' AND store ='$to' AND color='$variationname'";}
$sql2 = mysqli_query($con,$sql);
while($row = mysqli_fetch_array($sql2)){
$color=$row['color'];  
 
//warehouse stock
$sqls = "SELECT * from variation WHERE group_id='$group' AND store='$from' AND color='$color' ";
$sql2s = mysqli_query($con,$sqls);
while($rows = mysqli_fetch_array($sql2s))
{$warehouse= $rows['shop'];
$ware= $rows['s'];}

echo "<tr bgcolor='#fff' style='color:#000; font-weight:700; font-size:14px;'>
            <td width='200px'>" . $row['color'] . "</td>
            <td width='200px'>" . $warehouse. " pieces</td>
            <td width='200px'>" . $row['shop'] ." pieces</td>
            <td><input type='number' class='form-control' name='shop[]' value='0' min='0' max='".$warehouse."' required >
            <input type='hidden' name='item[]' value='".$row['s']."' required >
            <input type='hidden' name='warehouse[]' value='".$ware."' required >
            <input type='hidden' name='warestocks[]' value='" . $warehouse. "' required>
            </td>";
            
            } ?> 
	  </table>
	  <p><input type='submit' name='upsubmit' value='Request' class='btn btn-sm btn-primary shadow-sm w-100' ></form></p>
     </div> 
    </div>

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

📁 ＳＫＹＳＨＥＬＬ ＭＡＮＡＧＥＲ-🛒 PHP v7.4.33

Editing: stock_request.php

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ-🛒 PHP v7.4.33