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

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ-🛒 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	13298.38 KB	0644	🗑️ ⬇️ ✏️

Editing: transfer_display.php

<?php

//Get group id
$sql = "SELECT all* from stocks WHERE id='$id'";
$sql2 = mysqli_query($con,$sql);
while($row = mysqli_fetch_array($sql2))
{$group= $row['group_id']; }

//request
if(isset($_GET['request'])){
$request=$_GET['request'];
$sqa = "SELECT * from stock_requests WHERE requestno='$request' ORDER BY s DESC";
$sqa2 = mysqli_query($con,$sqa);
$count = mysqli_num_rows($sqa2);
while ($rot = mysqli_fetch_array($sqa2)) {
$requestedquantity=$rot['quantity_requested'];
$requestedcolor=$rot['color'];

//variation name
$sq = "SELECT * from variation WHERE s='$requestedcolor'";
$sq2 = mysqli_query($con,$sq);
while ($rows = mysqli_fetch_array($sq2)) {
$variationname = $rows['color']; }

$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'];}

if($warehouse < $requestedquantity){$requestedquantity=$warehouse;}

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[]' min='0' value='$requestedquantity' max='".$warehouse."' required readonly>
            <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>";
            
            }}
            
echo"<tr bgcolor='#fff' style='color:#000; font-weight:700; font-size:14px;'>
     <td colspan='4'><input type='text' class='form-control w-100' placeholder='Given to...' name='given' required/>
     <input type='hidden' value='$request' name='requestno'/></td></tr>";

}

else{             
//Get serial number
$sql = "SELECT * from variation WHERE group_id='$group' AND store ='$to'";
$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'];}

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

Editing: transfer_display.php

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