MAINHACK

Viewing / Editing File: supplierLedgerReport.php

<section class="content-header">
        <div class="row justify-content-between">
            <div class="col-6 p-0">
                <h3 class="top-left-header mt-2"><?php echo lang('supplier_ledger'); ?></h3>
            </div>
            <?php $this->view('updater/breadcrumb', ['firstSection'=> lang('report'), 'secondSection'=> lang('supplier_ledger')])?>
        </div>
    </section>

<div class="box-wrapper">
        
        <div class="report_header">
            <h3 class="company_name"><?php echo escape_output($this->session->userdata('business_name'));?> </h3>
            <h5 class="outlet_info">
                <strong><?php echo lang('supplier_ledger'); ?></strong>
            </h5>
            <?php if(isset($outlet_id) && $outlet_id){
                $outlet_info = getOutletInfoById($outlet_id); 
            }
            ?>
            <h5 class="outlet_info">
                <?php if(isset($outlet_id) && $outlet_id){ ?>
                    <strong><?php echo lang('outlet'); ?>: </strong> <?= escape_output($outlet_info->outlet_name); ?>
                <?php }?>
            </h5>
            <h5 class="outlet_info">
                <?php if(isset($outlet_id) && $outlet_id){ ?>
                    <strong><?php echo lang('address'); ?>: </strong> <?= escape_output($outlet_info->address); ?>
                <?php } ?>
            </h5>
            <h5 class="outlet_info">
                <?php if(isset($outlet_id) && $outlet_id){ ?>
                    <strong><?php echo lang('email'); ?>: </strong> <?= escape_output($outlet_info->email); ?>
                <?php } ?>
            </h5>
            <h5 class="outlet_info">
                <?php if(isset($outlet_id) && $outlet_id){ ?>
                    <strong><?php echo lang('phone'); ?>: </strong> <?= escape_output($outlet_info->phone); ?>
                <?php } ?>
            </h5>
            <?php if(isset($start_date) && $start_date != '' && $start_date != '1970-01-01' || isset($end_date) && $end_date != '' && $end_date != '1970-01-01'){ ?>
            <span class="outlet_info">
                <strong><?php echo lang('date');?>:</strong>
                <?php
                    if(!empty($start_date) && $start_date != '1970-01-01') {
                        echo dateFormat($start_date);
                    }
                    if((isset($start_date) && isset($end_date)) && ($start_date != '1970-01-01' && $end_date != '1970-01-01')){
                        echo ' - ';
                    }
                    if(!empty($end_date) && $end_date != '1970-01-01') {
                        echo dateFormat($end_date);
                    }
                ?>
            </span>
            <?php } ?>
            <h5 class="outlet_info">
                <?php if(isset($supplier_id) && $supplier_id){ ?>
                    <strong><?php echo lang('supplier'); ?>: </strong> <?= getSupplierName($supplier_id); ?>
                <?php } ?>
            </h5>
            <h5 class="outlet_info">
                <?php if(isset($type) && $type){ ?>
                    <strong><?php echo lang('type'); ?>: </strong> <?php echo $type; ?>
                <?php } ?>
            </h5>
            <h5 class="outlet_info">
                <?php if(isset($report_generate_time) && $report_generate_time){
                    echo $report_generate_time;
                } ?>
            </h5>
        </div>

<div class="table-box">
            <div class="table-responsive">
                <input type="hidden" class="datatable_name"  data-filter="yes" data-title="<?php echo lang('supplier_ledger'); ?>" data-id_name="datatable">
                <div class="box-body">
                    <table id="datatable"  class="table table-bordered table-striped">
                        <thead>
                            <tr>
                                <th class="w-5"><?php echo lang('sn'); ?></th>
                                <th class="w-15"><?php echo lang('date_and_time'); ?></th>
                                <th class="w-20"><?php echo lang('transaction_type'); ?></th>
                                <th class="w-15"><?php echo lang('transaction_no'); ?></th>
                                <?php if(isset($ledger_type) && $ledger_type == 'Ledger Details'){ ?>
                                <th class="w-15"><?php echo lang('items'); ?></th>
                                <?php } ?>
                                <th class="w-15 text-center"><?php echo lang('debit'); ?></th>
                                <th class="w-15 text-center"><?php echo lang('credit'); ?></th>
                                <th class="w-15"><?php echo lang('outlet'); ?></th>
                            </tr>
                        </thead>
                        <tbody>
                        <?php 
                        $balance = 0; 
                        $sum_of_debit = 0; 
                        $sum_of_credit = 0; 
                        if(isset($type) && $type == 'All'){ 
                            if(isset($supplierLedger) && $supplierLedger){
                            foreach ($supplierLedger as $key=>$supplier){
                                if(isset($sum_of_op_before_date) && $key == 0){
                                    if($sum_of_op_before_date < 0){
                                        $balance += $sum_of_op_before_date;
                                        $sum_of_debit += $sum_of_op_before_date;
                                    }else{
                                        $balance -= absCustom($sum_of_op_before_date);
                                        $sum_of_credit += absCustom($sum_of_op_before_date);
                                    } 
                                }else{
                                    if($supplier->debit != 0){
                                        $balance += $supplier->debit;
                                        $sum_of_debit += $supplier->debit;
                                    }else{
                                        $balance -= $supplier->credit;
                                        $sum_of_credit += $supplier->credit;
                                    } 
                                }
                            ?>
                            <tr>
                                <td><?php echo $key + 1; ?></td>
                                <td>
                                    <?php echo escape_output($supplier->date) != '' ? dateFormat($supplier->date) : '' ;?>
                                </td>
                                <td><?php echo escape_output($supplier->type) ?></td>
                                <td><?php echo escape_output($supplier->reference_no) ?></td>
                                <?php if(isset($ledger_type) && $ledger_type == 'Ledger Details'){ ?>
                                <td>
                                <?php 
                                    $details = '';
                                    if($supplier->type == 'Purchase Due Amount'){
                                        $details = getPurchaseDetailsByPurchaseIdForSupplierLedger($supplier->id);
                                    }else if($supplier->type == 'Purchase Return'){
                                        $details = getPurchaseReturnDetailsByPurchaseReturnIdForSupplierLedger($supplier->id);
                                    }
                                    if($details){
                                        echo "<strong>Name(Code)-Qty(Unit)-Total</strong><br>";
                                        foreach($details as $item){
                                            echo escape_output($item->item_name). '('. $item->item_code . ')-' . $item->quantity . '(' .$item->unit_name . ')-' . getAmtCustom($item->subtotal) . "<br>";
                                        }
                                    }
                                ?>
                                </td>
                                <?php } ?>
                                <?php if(isset($sum_of_op_before_date) && $key == 0){ ?>
                                    <td class="text-center"><?php echo $sum_of_op_before_date < 0 ? getAmtCustom(absCustom($sum_of_op_before_date)) : getAmtCustom(0) ?></td>
                                    <td class="text-center"><?php echo $sum_of_op_before_date > 0 ? getAmtCustom(absCustom($sum_of_op_before_date)) : getAmtCustom(0); ?></td>
                                <?php }else{ ?>
                                    <td class="text-center"><?php echo getAmtCustom($supplier->debit) ?></td>
                                    <td class="text-center"><?php echo getAmtCustom($supplier->credit) ?></td>
                                <?php } ?>
                                <td><?php echo escape_output($supplier->outlet_name); ?></td>
                            </tr>
                            <?php } } ?>
                        <?php }else if($type == 'Credit'){ ?>
                            <?php
                            $balance = 0; 
                            $sum_of_credit = 0; 
                            if(isset($supplierLedger) && $supplierLedger){
                            foreach ($supplierLedger as $key=>$supplier){
                                if($supplier->debit === '0' && $supplier->type != 'Opening Balance'){
                                    $sum_of_credit += $supplier->credit;
                            ?>
                            <tr>
                                <td><?php echo $key + 1; ?></td>
                                <td>
                                    <?php echo escape_output($supplier->date) != '' ? dateFormat($supplier->date) : '' ;?>
                                </td>
                                <td><?php echo escape_output($supplier->type) ?></td>
                                <td><?php echo escape_output($supplier->reference_no) ?></td>
                                <?php if(isset($ledger_type) && $ledger_type == 'Ledger Details'){ ?>
                                <td>
                                <?php 
                                    $details = '';
                                    if($supplier->type == 'Purchase Due Amount'){
                                        $details = getPurchaseDetailsByPurchaseIdForSupplierLedger($supplier->id);
                                    }else if($supplier->type == 'Purchase Return'){
                                        $details = getPurchaseReturnDetailsByPurchaseReturnIdForSupplierLedger($supplier->id);
                                    }
                                    if($details){
                                        echo "<strong>Name(Code)-Qty(Unit)-Total</strong><br>";
                                        foreach($details as $item){
                                            echo escape_output($item->item_name). '('. $item->item_code . ')-' . $item->quantity . '(' .$item->unit_name . ')-' . getAmtCustom($item->subtotal) . "<br>";
                                        }
                                    }
                                ?>
                                </td>
                                <?php } ?>
                                <?php if(isset($sum_of_op_before_date) && $key == 0){ ?>
                                    <td class="text-center"><?php echo $sum_of_op_before_date < 0 ? getAmtCustom(absCustom($sum_of_op_before_date)) : getAmtCustom(0) ?></td>
                                    <td class="text-center"><?php echo $sum_of_op_before_date > 0 ? getAmtCustom(absCustom($sum_of_op_before_date)) : getAmtCustom(0); ?></td>
                                <?php }else{ ?>
                                    <td class="text-center"></td>
                                    <td class="text-center"><?php echo getAmtCustom($supplier->credit) ?></td>
                                <?php } ?>
                                <td><?php echo escape_output($supplier->outlet_name); ?></td>
                            </tr>
                            <?php } } } ?>
                        <?php } else if($type == 'Debit'){ ?>
                            <?php
                            $sum_of_debit = 0;
                            if(isset($supplierLedger) && $supplierLedger){
                            foreach ($supplierLedger as $key=>$supplier){
                                if($supplier->credit === '0' && $supplier->type != 'Opening Balance'){
                                    $sum_of_debit += $supplier->debit;
                                
                            ?>
                            <tr>
                                <td><?php echo $key + 1; ?></td>
                                <td>
                                    <?php echo escape_output($supplier->date) != '' ? dateFormat($supplier->date) : '' ;?>
                                </td>
                                <td><?php echo escape_output($supplier->type) ?></td>
                                <td><?php echo escape_output($supplier->reference_no) ?></td>
                                <?php if(isset($ledger_type) && $ledger_type == 'Ledger Details'){ ?>
                                <td>
                                <?php 
                                    $details = '';
                                    if($supplier->type == 'Purchase Due Amount'){
                                        $details = getPurchaseDetailsByPurchaseIdForSupplierLedger($supplier->id);
                                    }else if($supplier->type == 'Purchase Return'){
                                        $details = getPurchaseReturnDetailsByPurchaseReturnIdForSupplierLedger($supplier->id);
                                    }
                                    if($details){
                                        echo "<strong>Name(Code)-Qty(Unit)-Total</strong><br>";
                                        foreach($details as $item){
                                            echo escape_output($item->item_name). '('. $item->item_code . ')-' . $item->quantity . '(' .$item->unit_name . ')-' . getAmtCustom($item->subtotal) . "<br>";
                                        }
                                    }
                                ?>
                                </td>
                                <?php } ?>
                                <?php if(isset($sum_of_op_before_date) && $key == 0){ ?>
                                    <td class="text-center"><?php echo $sum_of_op_before_date < 0 ? getAmtCustom(absCustom($sum_of_op_before_date)) : getAmtCustom(0) ?></td>
                                    <td class="text-center"><?php echo $sum_of_op_before_date > 0 ? getAmtCustom(absCustom($sum_of_op_before_date)) : getAmtCustom(0); ?></td>
                                <?php }else{ ?>
                                    <td class="text-center"><?php echo getAmtCustom(absCustom($supplier->debit)) ?></td>
                                    <td class="text-center"></td>
                                <?php } ?>
                                <td><?php echo escape_output($supplier->outlet_name); ?></td>
                            </tr>
                            <?php } } } ?>
                        <?php } ?>

<?php
                            if(isset($type) && $type == 'Credit'){
                        ?>
                        <tr>
                            <th></th>
                            <th></th>
                            <th></th>
                            <?php if(isset($ledger_type) && $ledger_type == 'Ledger Details'){ ?>
                                <th></th>
                            <?php } ?>
                            <th><?php echo lang('closing_balance');?></th>
                            <th></th>
                            <th class="text-center"><?php echo getAmtCustom(absCustom($sum_of_credit)); ?></th>
                            <th></th>
                        </tr>
                        <?php } ?>
                        <?php
                            if(isset($type) && $type == 'Debit'){
                        ?>
                        <tr>
                            <th></th>
                            <th></th>
                            <th></th>
                            <?php if(isset($ledger_type) && $ledger_type == 'Ledger Details'){ ?>
                                <th></th>
                            <?php } ?>
                            <th><?php echo lang('closing_balance');?></th>
                            <th class="text-center"><?php echo getAmtCustom(absCustom($sum_of_debit)); ?></th>
                            <th></th>
                            <th></th>
                        </tr>
                        <?php } ?>
                        <?php
                            if(isset($type) && $type == 'All'){
                        ?>
                        <tr>
                            <th></th>
                            <th></th>
                            <th></th>
                            <?php if(isset($ledger_type) && $ledger_type == 'Ledger Details'){ ?>
                                <th></th>
                            <?php } ?>
                            <th><?php echo lang('closing_balance');?></th>
                            <?php
                                $closing_result = 0;
                                $closing_result =  ($sum_of_debit -  $sum_of_credit); 
                            ?>
                            <?php if($closing_result < 0){?>
                                <th></th>
                                <th class="text-center"><?php echo getAmtCustom(absCustom($closing_result)) ?></th>
                            <?php } else if($closing_result > 0){ ?>
                                <th class="text-center"><?php echo getAmtCustom(absCustom($closing_result)) ?></th>
                                <th></th>
                            <?php } ?>
                            <th></th>
                        </tr>
                        <?php } ?>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="filter-overlay"></div>
<div id="product-filter" class="filter-modal">
    <div class="filter-modal-body">
        <header>
            <h3 class="filter-modal-title"><span><?php echo lang('FilterOptions'); ?></span></h3>
            <button type="button" class="close-filter-modal" data-bs-dismiss="modal" aria-label="Close">
                <span aria-hidden="true">
                    <i data-feather="x"></i>
                </span>
            </button>
        </header>
        <?php echo form_open(base_url() . 'Company_report/supplierLedgerReport', $arrayName = array('id' => 'supplierReport')) ?>
        <div class="row">
            <div class="col-sm-12 col-md-6 mb-2">
                <div class="form-group">
                    <input  autocomplete="off" type="text" id="startDate" name="startDate" readonly class="form-control customDatepicker" placeholder="<?php echo lang('start_date'); ?>" value="<?php echo isset($_POST['startDate']) && $_POST['startDate'] ? $_POST['startDate'] : '' ?>">
                </div>
                <div class="alert alert-error error-msg startDate_err_msg_contnr ">
                    <p id="startDate_err_msg"></p>
                </div>
            </div>
            <div class="col-sm-12 col-md-6 mb-2">
                <div class="form-group">
                    <input  autocomplete="off" type="text" id="endDate" name="endDate" readonly class="form-control customDatepicker" placeholder="<?php echo lang('end_date'); ?>" value="<?php echo isset($_POST['endDate']) && $_POST['endDate'] ? $_POST['endDate'] : '' ?>">
                </div>
                <div class="alert alert-error error-msg endDate_err_msg_contnr ">
                    <p id="endDate_err_msg"></p>
                </div>
            </div>
            <div class="col-sm-12 col-md-6 mb-2">
                <div class="form-group">
                    <select  class="form-control select2 op_width_100_p" id="supplier_id" name="supplier_id">
                        <option value=""><?php echo lang('select_supplier'); ?></option>
                        <?php
                        foreach ($suppliers as $value) {
                            ?>
                            <option <?php echo isset($_POST['supplier_id']) && $_POST['supplier_id'] ? ($_POST['supplier_id'] == $value->id ? 'selected' : '') : '' ?> value="<?php echo escape_output($value->id) ?>"><?php echo escape_output($value->name) ?></option>
                        <?php } ?>
                    </select>
                    <div class="alert alert-error error-msg supplier_id_err_msg_contnr ">
                        <p id="supplier_id_err_msg"></p>
                    </div>
                </div>
            </div>
            <?php
                if(isLMni()):
            ?>
            <div class="col-sm-12 col-md-6 mb-2">
                <div class="form-group">
                    <select  class="form-control select2 ir_w_100" id="outlet_id" name="outlet_id">
                        <?php
                            $role = $this->session->userdata('role');
                            if($role == '1'){
                        ?>
                        <option value=""><?php echo lang('select_outlet') ?></option>
                        <?php } ?>
                        <?php
                        $outlets = getOutletsForReport();
                        foreach ($outlets as $value):
                            ?>
                            <option <?= set_select('outlet_id',$value->id)?>  value="<?php echo escape_output($value->id) ?>"><?php echo escape_output($value->outlet_name) ?></option>
                            <?php
                        endforeach;
                        ?>
                    </select>
                </div>
            </div>
            <?php
                endif;
            ?>

<?php $this->view('updater/reuseJs_w_pagination'); ?>
<script src="<?php echo base_url();?>frequent_changing/js/report-js/master_report_validation.js"></script>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: supplierLedgerReport.php

Server Info

System Features

User Info