芝麻web文件管理V1.00

编辑当前文件:/home/sditechnicalteam/socialsolargreens.pk/ledger.php

<?php   
        include_once('controller/Ledgure_controller.php');
        $Ledgure = new Ledgure();
        $Ledgure_List = $Ledgure->LedgureList();
        if(isset($_GET['thirdlevel'])){
            $aaa = $Ledgure->thirdlevel_dropdown();
            echo $aaa;
            die;
        }
        include_once('partial/link.php');
        include_once('partial/header.php');
        include_once('partial/navbar.php');
        //  print_r($Ledgure_List);
        //  die;
?>
            
            
            
            <div class="main-content">

<div class="row">
    <div class="col-lg-12" style="margin-top:20px">
        <div class="card">
            <div class="card-body">
                <h5><i class="fa fa-save"></i> Ledger</h5>
                <br />
                <form asp-action="Search" method="get">
                    <div class="form-row">
                        <div class="col-md-3">
                            <div class="form-group">
                                <label>Start Date</label>   <i class="fa fa-star text-danger" style="font-size:8px"></i>
                                <input type="date" class="form-control" name="StDate" id="s" required>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="form-group">
                                <label>End Date</label>   <i class="fa fa-star text-danger" style="font-size:8px"></i>
                                <input type="date" class="form-control" required id="e" name="EnDate">
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="form-group">
                                <label>Select Account</label>   <i class="fa fa-star text-danger" style="font-size:8px"></i>
                                <select id="TL" class="form-control select2" required name="cat">
                                    <option value="">select</option>
                                </select>
                            </div>
                        </div>
                    </div>
                    <div class="offset-md-4 col-md-5" style="margin-top:20px">
                        <button type="submit" class="btn btn-success pull-right col-md-5"><i class="fa fa-search"></i>  Search</button>
                    </div>
                </form>

<?php 
                if(isset($_GET['StDate']) && isset($_GET['EnDate']) && isset($_GET['cat'])){

?>
                <hr />
                <h5><i class="fa fa-table"></i> Ledger Record</h5>
                <hr>
                <div style="overflow-x:auto">
                    <table class="table table-striped table-bordered nowrap" style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                        <?php
                            $result = $Ledgure->Search($_GET['cat'], $_GET['StDate'] , $_GET['EnDate']);
                        ?>
                        <thead class="bordered-darkorange" style="background-color: #2CA579; color: white">
                            <tr style="background-color: #2CA579; color: white">
                                <th colspan="4">(Account Holder Name : <u><?= $result['ThirdLevel'] ?></u>)</th>
                                <th colspan="3">( Opening Balance Pkr : <u><?= number_format($result['openBalance']); ?>)</u></th>
                            </tr>
                            <tr>
                                <th>Trans Id</th>
                                <th style="width:120px">Date</th>
                                <th>Vtype</th>
                                <th>Description</th>
                                <th>DEBIT</th>
                                <th>CREDIT</th>
                                <th>Balance</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                            echo '<pre>';
                            // print_r($result);
                            echo '</pre>';
                            $sum_cr = '0'; $sum_dr = '0';
                             foreach ($result['trans_list'] as $result_data)
                            {
                                // print_r($result_data);
                                $bal = $result['openBalance'];
                                $sum_cr += $result_data['Cr'];
                                $sum_dr += $result_data['Dr'];
                                if ($result_data['Headid'] == 1 || $result_data['Headid'] == 5)
                                {
                                    $bal = ($bal + ($sum_dr - $sum_cr));
                                }
                                else
                                {
                                    $bal = ($bal + ($sum_cr - $sum_dr));
                                }?>
                                <tr>
                                    <td><?= $result_data['Transid']; ?> </td>
                                    <td style="width:100px"><?= $result_data['TransDate']; ?></td>
                                    <?php
                                    if ($result_data['Vtype'] == "PINV")
                                    {
                                        echo '<td>PV</td>';
                                    }
                                    else if ($result_data['Vtype'] == "CPVPINV")
                                    {
                                        echo '<td>CPV</td>';
                                    }
                                    else if ($result_data['Vtype'] == "SINV")
                                    {
                                        echo '<td>SV</td>';
                                    }
                                    else if ($result_data['Vtype'] == "CRVSINV")
                                    {
                                        echo '<td>CRV</td>';
                                    }
                                    else
                                    {
                                        echo '<td>'.$result_data['Vtype'].'</td>';
                                    }
                                    ?>
                                    <td> <?= $result_data['TransDes']; ?></td>
                                    <td><?= number_format($result_data['Dr']); ?></td>
                                    <td><?= number_format($result_data['Cr']); ?></td>

<td><?= number_format($bal); ?></td>
                                    </tr>
                            <?php
                            }
                            ?>
                        </tbody>
                        <tfoot>
                            <tr style="border:2px solid #CCCCCC">
                                <th style="text-align:center;" colspan="4"> <label class="btn btn-upload" style="font-size: 15px; color: #fff; background-color: #757575 ">Grand Total</label></th>
                                <th style="border:2px solid #CCCCCC ;border-radius:20px"><label class="btn btn-upload" style="font-size: 15px; color: #fff; background-color: #757575 "><?= number_format($sum_dr); ?></label></th>
                                <th style="border: 2px solid #CCCCCC; border-radius: 20px"><label class="btn btn-upload" style="font-size: 15px; color: #fff; background-color: #757575 "><?= number_format($sum_cr); ?></label></th>
                                <th style="border: 2px solid #CCCCCC; border-radius: 20px"><label class="btn btn-upload" style="font-size: 15px; color: #fff; background-color: #757575 "><?= number_format($bal); ?></label></th>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            <?php } ?>

</div>
        </div>
    </div>
</div>
<script>
    $(document).ready(function (){
    //    alert('aaa');
       $.ajax({
            type: "GET",
            url: "<?=BASE_URL?>ledger.php?thirdlevel=all",
            data: "{}",
            success: function (data) {
                // debugger
                console.log(data);
                $('#TL').html(data);
            }
        });
    });

let d = (new Date()).toISOString().split('T')[0];
    $('#s').val(d);
    $('#e').val(d);
</script>

</div> 
                </div>

<?php include 'partial/footer.php'; ?>