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

<?php  include 'top.php';
$reqtyep=$_REQUEST['req'];
$tablename=$_REQUEST['hashtags'];
$fetchids=$_REQUEST['fetid'];
$lastval=$_REQUEST['lastval'];

if($reqtyep=='getunit'){ 
    
    $prodcode=$_REQUEST['prodcode'];
    $qs=f(q("select * from tbl_products WHERE p_code='$prodcode'"));
    $munit=$qs['m_unit'];
    $getu=f(q("SELECT * FROM  tbl_unit WHERE u_id='$munit'"));
    $uname=$getu['u_name'];
    echo $uname;

}

if($reqtyep=='getprod'){ 
    
    $brcodes=$_REQUEST['prodcode'];

// $strs=explode("(",$procode);
    // $prodcode=str_replace(")","",$strs[1]);

$compaid=$_SESSION['active_comp'];
    $qs=f(q("select * from tbl_products WHERE brcodes='$brcodes'"));
    $prodcode=$qs['p_code'];
    $prodname=$qs['p_name'];
    $munit=$qs['m_unit'];
    $prodid=$qs['p_ids'];
    $propr=$qs['s_unit'];
    $getu=f(q("SELECT * FROM  tbl_unit WHERE u_id='$munit'"));
    $uname=$getu['u_name'];
    //$getpsum=f(q("SELECT SUM(st_quan) as psum FROM tbl_stock WHERE st_prodid='$prodid' AND st_type='Purchase' AND com_id='$compaid'"));
    //$stktquan=f(q("SELECT SUM(st_quan) as msum FROM tbl_stock WHERE st_prodid='$prodid' AND st_type='STOCK TRANSFER' AND com_id='$compaid'"));
    //$getssum=f(q("SELECT SUM(st_quan) as ssum FROM tbl_stock WHERE st_prodid='$prodid' AND st_type='Sales' AND com_id='$compaid'"));
	//$getsret=f(q("SELECT SUM(st_quan) as ssum FROM tbl_stock WHERE st_prodid='$prodid' AND st_type='SALES STOCK RETURN' AND com_id='$compaid'"));
	//$getsums=""
	
	
    //$stk=floatval($getpsum['psum'])+floatval($getssum['ssum']);
    //$stk=floatval($stk)+floatval($stktquan['msum']);

$getsretsum=f(q("SELECT SUM(st_quan) as ssum FROM tbl_stock WHERE st_prodid='$prodid' AND com_id='$compaid'"));
    $stk=$getsretsum['ssum'];

$q=mysqli_query($con,"SELECT * FROM tbl_company");
    while($arrq=mysqli_fetch_array($q)){

// $igetpsum=f(q("SELECT SUM(st_quan) as psum FROM tbl_stock WHERE st_prodid='$prodid' AND st_type='Purchase' AND com_id='$arrq[ids]'"));
   // $istktquan=f(q("SELECT SUM(st_quan) as msum FROM tbl_stock WHERE st_prodid='$prodid' AND st_type='STOCK TRANSFER' AND com_id='$arrq[ids]'"));
    //$igetssum=f(q("SELECT SUM(st_quan) as ssum FROM tbl_stock WHERE st_prodid='$prodid' AND st_type='Sales' AND com_id='$arrq[ids]'"));
	//$igetstret=f(q("SELECT SUM(st_quan) as ssum FROM tbl_stock WHERE st_prodid='$prodid' AND st_type='SALES STOCK RETURN' AND com_id='$arrq[ids]'"));
    $istk=floatval($igetpsum['psum'])+floatval($igetssum['ssum']);
    $istk=floatval($istk)+floatval($istktquan['msum'])+floatval($igetstret['ssum']);
	
	
	$getindv=f(q("SELECT SUM(st_quan) as ssum FROM tbl_stock WHERE st_prodid='$prodid' AND com_id='$arrq[ids]'"));
       $istk=$getindv['ssum'];
	   
      
      $stokst=$stokst."<b>".$arrq['c_name']."</b>"."-".$istk.$uname."<br>";

}

}

if($reqtyep=='getprodids'){ 
    $compaid=$_SESSION['active_comp'];
    $prodcode=$_REQUEST['prodcode'];
    $qs=f(q("select * from tbl_products WHERE p_code='$prodcode'"));
    $munit=$qs['m_unit'];
    $prodid=$qs['p_ids'];
    $propr=$qs['s_unit'];
    $getu=f(q("SELECT * FROM  tbl_unit WHERE u_id='$munit'"));
    $uname=$getu['u_name'];
    //$getpsum=f(q("SELECT SUM(st_quan) as psum FROM tbl_stock WHERE st_prodid='$prodid' AND st_type='Purchase' AND com_id='$compaid'"));
    //$stktquan=f(q("SELECT SUM(st_quan) as msum FROM tbl_stock WHERE st_prodid='$prodid' AND st_type='STOCK TRANSFER' AND com_id='$compaid'"));
    //$getssum=f(q("SELECT SUM(st_quan) as ssum FROM tbl_stock WHERE st_prodid='$prodid' AND st_type='Sales' AND com_id='$compaid'"));
    //$getsretsum=f(q("SELECT SUM(st_quan) as ssum FROM tbl_stock WHERE st_prodid='$prodid' AND st_type='Sales' AND com_id='$compaid'"));
    //$stk=floatval($getpsum['psum'])-floatval($getssum['ssum']);
    //$stk=floatval($stk)+floatval($stktquan['msum']);
    $getsretsum=f(q("SELECT SUM(st_quan) as ssum FROM tbl_stock WHERE st_prodid='$prodid' AND com_id='$compaid'"));
    $stk=$getsretsum['ssum'];

echo $uname."|".$stk."|".$propr;

}
  
  if($reqtyep=='getotp'){

$uids=$_REQUEST['uids'];
    $gentp=rand(1111,9999);
    
  
    $chk=f(q("SELECT * FROM tbl_login WHERE uids='$uids'"));
    if($chk['uids']!=''){
      $emails=$chk['emids'];
      $uptp=mysqli_query($con,"UPDATE tbl_login SET passw='$gentp' WHERE uids='$uids'");
      
    if($uptp){
      $mbody="Dear user, <br><br> New login request received for your account at Simple Billing, below are your login OTP. Please do not share it with others<br><br><br><center><h1>$gentp</h1></center>";
      $res=sendemails($mbody,$emails,"Login OTP ");
      if($res="Mail Sent"){
  
        $ret="<span style='color:green;'>OTP sent</span>";
  
      }else{
  
        $ret="<span style='color:green;'>$res</span>";
      }
       
  
  
    }
   
  
    }else{
  
      $ret="<span style='color:red'>User not registered</span>";
    }
    
  
    echo $ret;
  
  }

if($reqtyep=='getprosbyinv'){

$invno=$_REQUEST['invid'];
      $geti=f(q("SELECT * FROM tbl_sbill WHERE invsno='$invno'"));
      $invid=$geti['ids'];
      $q=mysqli_query($con,"SELECT * FROM tbl_sbilld WHERE bid='$invid'");
      while($arr=mysqli_fetch_array($q)){ ?>

<?php }

}
  
  
  if($reqtyep=='getprosbybarcode'){
	  
	  $invid=$_REQUEST['invid'];
	  
	  ?>
	  
	  
	  <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">#SL</th>
                      <th class="text-uppercase text-secondary text-xxs font-weight-bolder opacity-7 text-center">Product Name</th>
                      <th class="text-uppercase text-secondary text-xxs font-weight-bolder opacity-7 ps-2 text-center">Barcode</th>
                      <?php

$comq=mysqli_query($con,"SELECT * FROM tbl_company ORDER BY ord");
                        while($arrcom=mysqli_fetch_array($comq)){
                      
                      ?>
                      <th class="text-center text-uppercase text-secondary text-xxs font-weight-bolder opacity-7 text-center">Quan (<?php echo $arrcom['c_name']?>)</th>
                      <?php } ?>
                    </tr>
                  </thead>
                  <tbody>
                    <?php

$wh=0;

//$invid=mysqli_real_escape_string($con,$invid);
                            $ptype=mysqli_real_escape_string($con,$ptype);

$qry="SELECT * FROM tbl_products";

if($invid!=''){

$wh=1;

$qry=$qry." WHERE brcodes='$invid'";

}

if($ptype!=''){

if($wh==0){

$wh=1;
                                             $qry=$qry." WHERE p_type='$ptype'";

}else{

$qry=$qry." AND p_type='$ptype'";

}

//echo $qry;

$q=mysqli_query($con,$qry);
                        while($arr=mysqli_fetch_array($q)){

$i++;

//echo $arr['s_unit'];
                          if($arr['s_unit']!='0'){

$getuns=f(q("SELECT * FROM tbl_unit WHERE u_id='$arr[s_unit]'"));
                              $getunm=f(q("SELECT * FROM tbl_unit WHERE u_id='$arr[m_unit]'"));
                              $mtos=$arr['mtos'];

$purquan=f(q("SELECT SUM(st_quan) as msum FROM tbl_stock WHERE st_prodid='$arr[p_ids]' AND st_type='Purchase'"));

$packquan=f(q("SELECT SUM(st_quan) as msum FROM tbl_stock WHERE st_prodid='$arr[p_ids]' AND st_type='Packaging'"));

$salequan=f(q("SELECT SUM(st_quan) as msum FROM tbl_stock WHERE st_prodid='$arr[p_ids]' AND st_type='Sales'"));

$stokoquan=f(q("SELECT SUM(st_quan) as msum FROM tbl_stock WHERE st_prodid='$arr[p_ids]' AND st_type='Stock Out'"));

$puramt=$purquan['msum'];
                          $pakamt=$packquan['msum'];
                          $saleamt=$salequan['msum'];
                          $stockamt=$stokoquan['msum'];

$fk=(floatval($puramt)+floatval($pakamt))-(floatval($saleamt)+floatval($stockamt));
                          $finalstock=floatval($fk)*floatval($mtos);
                          $funit=$getuns['u_name'];

}else{

//echo "2nd";
                              $getuns=f(q("SELECT * FROM tbl_unit WHERE u_id='$arr[s_unit]'"));
                              $getunm=f(q("SELECT * FROM tbl_unit WHERE u_id='$arr[m_unit]'"));
                              $mtos=$arr['mtos'];

$purquan=f(q("SELECT SUM(st_quan) as msum FROM tbl_stock WHERE st_prodid='$arr[p_ids]' AND st_type='Purchase'"));
                          $packquan=f(q("SELECT SUM(st_quan) as msum FROM tbl_stock WHERE st_prodid='$arr[p_ids]' AND st_type='Packaging'"));

$salequan=f(q("SELECT SUM(st_quan) as msum FROM tbl_stock WHERE st_prodid='$arr[p_ids]' AND st_type='Sales'"));

$stokoquan=f(q("SELECT SUM(st_quan) as msum FROM tbl_stock WHERE st_prodid='$arr[p_ids]' AND st_type='Stock Out'"));

$puramt=$purquan['msum'];
                          $pakamt=$packquan['msum'];
                          $saleamt=$salequan['msum'];
                          $stockamt=$stokoquan['msum'];

$fk=(floatval($puramt)+floatval($pakamt))-(floatval($saleamt)+floatval($stockamt));
                          $finalstock=floatval($fk);
                          $funit=$getunm['u_name'];

}

?>
                    <tr>
                      <td  class="align-middle text-center text-sm">
                        
                        <p class="text-xs font-weight-bold mb-0"> <?php echo $i?></p>
                      </td>
                       <td class="align-middle text-center text-sm">
                        <p class="text-xs font-weight-bold mb-0 text-center" ><?php echo $arr['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['brcodes']?></p>
                      </td>
                      <?php

$comq=mysqli_query($con,"SELECT * FROM tbl_company ORDER BY ord");
while($arrcom=mysqli_fetch_array($comq)){
  $comid=$arrcom['ids'];

$purquan=f(q("SELECT SUM(st_quan) as msum FROM tbl_stock WHERE st_prodid='$arr[p_ids]' AND st_type='Purchase' AND com_id='$comid'"));
  $stktquan=f(q("SELECT SUM(st_quan) as msum FROM tbl_stock WHERE st_prodid='$arr[p_ids]' AND st_type='STOCK TRANSFER' AND com_id='$comid'"));
  $packquan=f(q("SELECT SUM(st_quan) as msum FROM tbl_stock WHERE st_prodid='$arr[p_ids]' AND st_type='Packaging' AND com_id='$comid'"));

$salequan=f(q("SELECT SUM(st_quan) as msum FROM tbl_stock WHERE st_prodid='$arr[p_ids]' AND st_type='Sales' AND com_id='$comid'"));

$stokoquan=f(q("SELECT SUM(st_quan) as msum FROM tbl_stock WHERE st_prodid='$arr[p_ids]' AND com_id='$comid'"));

$puramt=$purquan['msum'];
$pakamt=$packquan['msum'];
$saleamt=$salequan['msum'];
$stockamt=$stokoquan['msum'];

$fk=(floatval($puramt))-(floatval($saleamt));
$finalstock=floatval($fk)+floatval($stktquan['msum']);
$finalstock=$stockamt;
if($finalstock==''){

$finalstock=0;
}
$funit=$getunm['u_name'];

?>                      <td style="text-align:center;">
                        <p class="text-xs font-weight-bold mb-0"><?php echo $finalstock?> <?php echo $funit?></p>
                        </td>
                   <?php } ?>
                     
                    </tr>
                   <?php } ?>
                    
                  </tbody>
                </table>
	  
 <?php  }

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: getthings.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation