1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / eltoro /
Filename : reports_stocks.php
back
<?php
require "includes/config.php";

check_logged_in();
check_is_admin();

$user_id = input('user_id');
$start_date = input('start_date');
$end_date = input('end_date');

$sql = "";
if($user_id){
    $sql .= " AND s.createdBy = '".$user_id."'";
}

if($start_date && $end_date){
    $sql .= " AND DATE(s.createdTime) between '".$start_date."' AND '".$end_date."'";
}

if($sql){
    //$attendance = $db->select('attendance','*','status=1'.$sql, 'attendance_date desc');

    $newQuery = "select u.name, s.* from users u, stocks s where s.status = 1 and s.createdBy = u.id $sql order by s.createdBy, s.createdTime desc";
    $stocks = $db->query($newQuery);
}


layoutHeader();



$stores = $db->select('stores','*','status = 1');
$users = $db->select('users','*','status = 1 and store_id <> 0');



?>


<div id="layoutSidenav_content">
    <main>
        <div class="container-fluid px-4">
            <h1 class="mt-4">Stock Reports</h1>
            <ol class="breadcrumb mb-4">
                <li class="breadcrumb-item">Dashboard</li>
                <li class="breadcrumb-item active">Stock Reports</li>
            </ol>
            <div class="card mb-4">
                <div class="card-body">
                    <?php if($session->check('stock_error')){ ?>
                        <div class="text-center py-3 text-danger">
                            <?php echo $session->get('stock_error', true);?>
                        </div>
                    <?php } ?>

                    <?php if($session->check('stock_success')){ ?>
                        <div class="text-center py-3 text-success">
                            <?php echo $session->get('stock_success', true);?>
                        </div>
                    <?php } ?>


                    <form method="POST" action="">
                    <div class="row">
                        <div class="form-group col-md-3">
                            <label for="">User</label>
                            <select class="form-control" id="user_id" name="user_id" data-error="User is required">
                                <option value="">Select</option>
                                <?php
                                foreach($users as $user){
                                    echo "<option value='".$user['id']."' ".($user_id == $user['id']?'selected':'').">".$user['name']."</option>";
                                }
                                ?>
                            </select>
                            <span class="text-danger Errors" id="user_idrror"></span>
                        </div>

                        <div class="form-group col-md-3">
                            <label for="">Start Date</label>
                            <input type="date" class="form-control" id="start_date" name="start_date" data-error="Date is required" value="<?php echo $start_date;?>">
                            <span class="text-danger Errors" id="start_daterror"></span>
                        </div>

                        <div class="form-group col-md-3">
                            <label for="">End Date</label>
                            <input type="date" class="form-control" id="end_date" name="end_date" data-error="Date is required" value="<?php echo $end_date;?>">
                            <span class="text-danger Errors" id="end_dateError"></span>
                        </div>


                        <div class="clear"></div>

                        <div class="form-group col-md-3">
                            <a href="<?php echo base_url();?>reports_stocks.php" class="btn btn-warning">Reset</a>
                            <button type="submit" class="btn btn-primary">Submit</button>
                        </div>
                    </div>
                    </form>

                                  
                    
                    <table class="table">
                        <thead class="thead-dark">
                            <tr>
                            <th scope="col" width="10%">#</th>
                            <?php if(!$user_id){ ?>
                                <th scope="col">Name</th>
                            <?php } ?>
                            <th scope="col">Remarks</th>
                            <th scope="col" width="20%">Date</th>
                            <th scope="col" width="20%">Download  File</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                                $i = 1;
                                foreach($stocks as $row){
                                    $access_url = "";
                                    if(!empty($row['file_name'])){
                                        $access_url = base_url().'uploads/stocks_files/'.$row['file_name'];
                                    }
                            ?>
                                    <tr>
                                        <th scope="row"><?php echo $i++;?></th>
                                        <?php if(!$user_id){ ?>
                                            <td scope="col"><?php echo $row ['name'];?></td>
                                        <?php } ?>
                                        <td><?php echo $row['remarks'];?></td>
                                        <td><?php echo date("d-m-Y", strtotime($row['createdTime']));?></td>
                                        <td><a class="btn btn-success" target="_blank" href="<?= $access_url ?>"><i class="fas fa-download"></i></a></td>                                        
                                    </tr>
                            <?php 
                                }
                                if($i==1){
                                    echo "<tr>";
                                        echo "<td colspan='5'>No More Records</td>";
                                    echo "</tr>";
                                }
                            ?>
                                
                        </tbody>
                    </table>
                                
                    

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

    
<script>


$(document).ready(function(){

});    

</script>