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: ptransfer.php

<?php include "header.php";

$uids=$_SESSION['sbills'];
$page = $_REQUEST["page"];

$start_limit = 0;
                $end_limit = 100 ;

if ($page != '' && floatval($page) > 1)
                {
                    $start_limit = ($page - 1) * 100;
                    $end_limit=($page)*100;
                }
                
                	//SELECT * FROM db_sales WHERE company_id='$comid' ORDER BY id DESC LIMIT $start_limit, $end_limit

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

$cid=$_REQUEST['cids'];
    if($_SESSION['stype']=='1'){

$deld=mysqli_query($con,"DELETE FROM tbl_pstk_ret WHERE st_id='$cid'");
        if($deld){

$delstk=mysqli_query($con,"DELETE FROM tbl_stock WHERE st_type='PURCHASE STOCK RETURN' AND st_invno='$cid'");

}

}else{

$deld=mysqli_query($con,"DELETE FROM tbl_pstk_ret WHERE st_id='$cid' AND st_stats=0");
        if($deld){
            
          $delstk=mysqli_query($con,"DELETE FROM tbl_stock WHERE st_type='PURCHASE STOCK RETURN' AND st_invno='$cid'");
        }
    
    }

echo "<script>alert('Request Deleted Successfully')</script>";

}

$uids=$_SESSION['sbills'];
$actcom=$_SESSION['active_comp'];
if($_SESSION['stype']=='1'){

$qry="SELECT * FROM tbl_pstk_ret";

}else{

$qry="SELECT * FROM tbl_pstk_ret WHERE st_fcom='$actcom'";

}

//echo $qry;

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>

<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">List of Stock Return</h6>
              </div>
            </div>

<div class="card-body px-0 pb-2">
              <div class="table-responsive p-0">
                <table class="table align-items-center mb-0">
                  <thead>
                    <tr>
                      <th class="text-uppercase text-secondary text-xxs font-weight-bolder opacity-7 text-center">Date</th>
                      <th class="text-uppercase text-secondary text-xxs font-weight-bolder opacity-7 text-center">Company</th>
                      <th class="text-uppercase text-secondary text-xxs font-weight-bolder opacity-7 ps-2 text-center">Supplier</th>
                      <th class="text-uppercase text-secondary text-xxs font-weight-bolder opacity-7 ps-2 text-center">Product</th>
                      <th class="text-center text-uppercase text-secondary text-xxs font-weight-bolder opacity-7 text-center">Quantity</th>
                      <th class="text-center text-uppercase text-secondary text-xxs font-weight-bolder opacity-7 text-center">Reason</th>
                      <th class="text-secondary opacity-7"></th>
                    </tr>
                  </thead>
                  <tbody>
                    <?php 
                        
                        $q=mysqli_query($con,$qry);
                        while($arr=mysqli_fetch_array($q)){

$getcom=f(q("SELECT * FROM tbl_company WHERE ids='$arr[st_fcom]'"));
                            $getcomm=f(q("SELECT * FROM tbl_suppl WHERE s_id='$arr[st_tcom]'"));
                            $getprod=f(q("SELECT * FROM tbl_products WHERE p_ids='$arr[st_prodid]'"));

?>
                    <tr>
                      <td  class="align-middle text-center text-sm">
                       
                        <p class="text-xs font-weight-bold mb-0"> <?php echo $arr['st_date']?></p>
                      </td>
                       <td class="align-middle text-center text-sm">
                        <p class="text-xs font-weight-bold mb-0 text-center" ><?php echo $getcom['c_name']?></p>
                      </td>
                      <td class="align-middle text-center text-sm">
                        <p class="text-xs font-weight-bold mb-0 text-center" ><?php echo $getcomm['s_name']?></p>
                      </td>
                      <td class="align-middle text-center text-sm">
                        <p class="text-xs font-weight-bold mb-0 text-center" ><?php echo $getprod['p_name']?></p>
                      </td>
                      
                      <td class="align-middle text-center text-sm">
                        <p class="text-xs font-weight-bold mb-0 text-center" ><?php echo $arr['st_quan']?></p>
                      </td>
                      <td class="align-middle text-center text-sm">
                        <p class="text-xs font-weight-bold mb-0 text-center" ><?php echo $arr['stk_remarks']?></p>
                      </td>
                      
                      <td class="align-middle">
                        <?php if($_SESSION['stype']=='1'){?>
                            <a href="transfer-list.php?action=delete&cids=<?php echo $arr['st_id']?>" onclick="return confirm('Are you sure you want to delete this Bill?');" class="text-secondary font-weight-bold text-xs" data-toggle="tooltip" data-original-title="Delete Bill">
                          Delete
                        </a>
                            
                            <?php }else{ ?>

<?php if($arr['st_tby']==$uids){?>
                            <?php if($arr['st_stats']=='0'){?> &nbsp;<a href="ptransfer.php?action=delete&cids=<?php echo $arr['st_id']?>" onclick="return confirm('Are you sure you want to delete this Bill?');" class="text-secondary font-weight-bold text-xs" data-toggle="tooltip" data-original-title="Delete Bill">
                          Delete
                        </a><br><?php } } }?>
                        
                            
                      </td>
                    </tr>
                   <?php } ?>
                    
                  </tbody>
                </table>
              </div>
              
            </div>
          </div>
        </div>

</div>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: ptransfer.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation