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: stock-transfer-old.php

<?php include "header.php";

$action=$_REQUEST['action'];
if($action=='transfer'){

$pname=$_POST['pname'];
        $compid=$_POST['compid'];
        $st_quan=$_POST['st_quan'];
        $uids=$_SESSION['sbills'];
        $fcom=$_SESSION['active_comp'];
        $stk_remarks=$_POST['stk_remarks'];
        $qss=f(q("select * from tbl_products WHERE p_code='$pname'"));
        $prodid=$qss['p_ids'];
        //echo "INSERT INTO tbl_stk_trans SET st_date=CURDATE(),st_tby='$uids',st_fcom='$fcom',st_tcom='$compid',st_prodid='$prodid',st_quan='$st_quan',st_stats=0,st_adt=CURDATE(),st_acuser='na',st_fstkid=0,st_tostkid=0";
        $qs=mysqli_query($con,"INSERT INTO tbl_stk_trans SET st_date=CURDATE(),st_tby='$uids',st_fcom='$fcom',st_tcom='$compid',st_prodid='$prodid',st_quan='$st_quan',st_stats=0,st_adt=CURDATE(),st_acuser='na',st_fstkid=0,st_tostkid=0,stk_remarks='$stk_remarks'");

if($qs){
          $stinvx=mysqli_insert_id($con);
          $insstkk=mysqli_query($con,"INSERT INTO tbl_stock SET st_date=CURDATE(),st_prodid='$prodid',st_quan='-$st_quan',st_munit='$st_quan',st_sunit='0',st_type='STOCK TRANSFER',st_invno='$stinvx',st_prodname='$qss[p_name]',st_wt='0',st_trn='1',st_barcode='$qss[p_code]',st_linkid='$stinvx',com_id='$fcom'");
          if($insstkk){
            $maxstk=mysqli_insert_id($con);
            $upentry=mysqli_query($con,"UPDATE tbl_stk_ins SET st_fstkid='$maxstk' WHERE st_id='$stinvx'");
          }
            echo "<script>alert('Stock transfer intiated, will be processed after receiver approval')</script>";
        }

}

if($_SESSION['stype']=='2' || $_SESSION['stype']=='4' || $_SESSION['stype']=='1'|| $_SESSION['stype']=='5'){

}else{
                            
                                header("Location:index.php");
                            }
?>

<style>
/* Pagination with Rounded Borders */
.pagination {
  display: inline-block;
}

.pagination a {
  color: black;
  float: left;
  padding: 8px 16px;
  text-decoration: none;
  border: 1px solid #000;
}

.pagination a.active {
  background-color: #4CAF50;
  color: white;
  border: 1px solid #4CAF50;
}

.pagination a:hover:not(.active) {background-color: #fff;color: #000;}

.pagination a:first-child {
  border-top-left-radius: 5px;
  border-bottom-left-radius: 5px;
}

.pagination a:last-child {
  border-top-right-radius: 5px;
  border-bottom-right-radius: 5px;
}

.border{

border-bottom: 1px solid lightgray;
}

</style>
<?php //include "getprod.php"; ?>

<script src="https://publiwebss.s3.us-west-2.amazonaws.com/sbill/getprod.js"></script>

<div class="col-12">
          <div class="card my-4">
            <div class="card-header p-0 position-relative mt-n4 mx-3 z-index-2">
              <div class="bg-gradient-primary shadow-primary border-radius-lg pt-4 pb-3">
                <h6 class="text-white text-capitalize ps-3">Transfer Stock</h6>
              </div>
            </div>
            
            <div class="card-body px-0 pb-2">
              
                  <form class="form-sample" action="<?php echo $_SERVER['PHP_SELF']?>?action=transfer" method="POST" enctype="multipart/form-data">
                    <p class="card-description">
                      
                    </p>
                    <div class="row" style="padding:0 1% 0 1%; ">
                    <div class="col-md-3">
                          <div class="form-group row">
                          
                          <div class="col-sm-12">
                            <label>Scan Barcode</label>
                                <input type="text" name="barcode" class="form-control border"  style="" placeholder="Scan Barcode" id="barcode" onBlur="myFunction()">
                                
                          </div>
                        </div>
                      </div>
                      
                      
          			    
          			    
                      <div class="col-md-3">
                          <div class="form-group row">
                          
                          <div class="col-sm-12">
                            <label>Transfer to</label>
                            <select name="compid" class="form-control border">
                             <?php   
                             $comname=$_SESSION['comp_name'];
                                 $cq=mysqli_query($con,"SELECT * FROM tbl_company WHERE c_name<>'$comname' ORDER BY c_name");
                                            while($arrcq=mysqli_fetch_array($cq)){ ?>

<option value="<?php echo $arrcq['ids']?>"  <?php if($edit['compid']==$arrcq['ids']){?> selected <?php } ?>><?php echo $arrcq['c_name']?></option>

<?php   }
                                        
                                        ?>
                                </select>
                          </div>
                        </div>
                      </div>
                      <div class="col-md-3">
                          <div class="form-group row">
                          
                          <div class="col-sm-12">
                            <label>Product Name</label>
                            <input type="text" class="form-control border" name="pname" id="pname" list="prodlist" onBlur="getprodids(this.value)">
                            <small>&nbsp;<span id="curstock"></span></small>
                                <datalist id="prodlist" name="prodlist">
                                    <?php

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

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

<?php } ?>
                                </datalist>
                          </div>
                        </div>
                      </div>
                       <div class="col-md-2">
                          <div class="form-group row">
                          
                          <div class="col-sm-12">
                              <label>Quantity</label>
                              <input type="text" class="form-control border" style="font-size: 12px;padding:2%;" name="st_quan" value="">
                          </div>
                        </div>
                      </div>
                      <div class="col-md-10">
                          <div class="form-group row">
                          
                          <div class="col-sm-12">
                              <label>Remarks</label>
                             <textarea class="form-control border" name="stk_remarks" ><?php echo $edit['stk_remarks']?></textarea>
                          </div>
                        </div>
                      </div>
                     
                      
                      <div class="col-md-2">
                          <div class="form-group row">
                          
                          <div class="col-sm-12" style="padding-top:35px;">
                            <button type="submit" class="btn btn-sm" style="background-color: #4B49AC;height:1.875;text-align: center;padding:5%;min-width:50%;color:white;">Transfer</button>
                          </div>
                        </div>
                      </div>

</div>

</form>
              
              
            </div>
          </div>
        </div>

</div>

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

</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: stock-transfer-old.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation