MAINHACK

Viewing / Editing File: printDailySummaryReport.php

<a href="<?= base_url() . 'Report/dailySummaryReport' ?>" class="btn btn-block btn-primary pull-left no_print"><strong><?php echo lang('back'); ?></strong></a>

<h4 class="op_font_weight_b op_margin_top_30 text-left"><?php echo lang('purchases');?></h4>
                    <table class="tbl op_width_100_p">    
                        <tr>
                            <th class="op_font_weight_b w-5"><?php echo lang('sn'); ?></th>
                            <th class="w-15"><?php echo lang('ref_no'); ?></th>
                            <th class="w-20"><?php echo lang('supplier'); ?></th> 
                            <th class="w-20 text-center"><?php echo lang('g_total'); ?></th>
                            <th class="w-20 text-center"><?php echo lang('paid'); ?></th>
                            <th class="w-20"><?php echo lang('due'); ?></th> 
                        </tr> 
                        <?php  
                            $sum_of_gtotal = 0;
                            $sum_of_paid = 0;
                            $sum_of_due = 0;
                            if (!empty($result['purchases']) && isset($result['purchases'])):
                                foreach ($result['purchases'] as $key => $value): 
                                    $sum_of_gtotal += $value->grand_total; 
                                    $sum_of_paid += $value->paid;  
                                    $sum_of_due += $value->due_amount;  
                                    $key++;
                                    ?>
                                    <tr>
                                        <td><?php echo $key ?></td>
                                        <td><?php echo escape_output($value->reference_no); ?></td>
                                        <td><?php echo escape_output($value->supplier_name) ?></td>  
                                        <td class="text-center"><?php echo getAmtCustom(escape_output($value->grand_total)); ?></td>
                                        <td class="text-center"><?php echo getAmtCustom(escape_output($value->paid)); ?></td> 
                                        <td><?php echo getAmtCustom(escape_output($value->due_amount)); ?></td> 
                                    </tr>
                                    <?php
                                endforeach;
                            endif;
                        ?>
                        <tr> 
                            <td></td> 
                            <td></td> 
                            <td class="op_font_weight_b op_right"><?php echo lang('total'); ?></td>  
                            <td class="text-center"><?php echo getAmtCustom($sum_of_gtotal) ?></td>
                            <td class="text-center"><?php echo getAmtCustom($sum_of_paid) ?></td>
                            <td><?php echo getAmtCustom($sum_of_due) ?></td>
                        </tr>
                    </table>

<h4 class="op_font_weight_b op_margin_top_30 text-left"><?php echo lang('purchase_return');?></h4>
                    <table class="tbl op_width_100_p">  
                        <tr>
                            <th class="op_font_weight_b w-5"><?php echo lang('sn'); ?></th>
                            <th class="w-35"><?php echo lang('reference_no'); ?></th>
                            <th class="w-40"><?php echo lang('supplier'); ?></th> 
                            <th class="w-20"><?php echo lang('amount'); ?></th>
                        </tr> 
                        <?php  
                            $sum_of_total_return_amount = 0;
                            $sum_of_paid = 0;
                            $sum_of_due = 0;
                            if (!empty($result['purchase_return']) && isset($result['purchase_return'])):
                                foreach ($result['purchase_return'] as $key => $value): 
                                    $sum_of_total_return_amount += $value->total_return_amount; 
                                    $key++;
                                    ?>
                                    <tr>
                                        <td><?php echo $key ?></td>
                                        <td><?php echo escape_output($value->reference_no); ?></td>
                                        <td><?php echo escape_output($value->supplier_name) ?></td>  
                                        <td><?php echo getAmtCustom($value->total_return_amount); ?></td>
                                    </tr>
                                    <?php
                                endforeach;
                            endif;
                        ?>
                        <tr> 
                            <td></td> 
                            <td></td> 
                            <td class="op_font_weight_b"><?php echo lang('total'); ?></td>  
                            <td><?php echo getAmtCustom($sum_of_total_return_amount) ?></td>
                        </tr>
                    </table>

<h4 class="op_font_weight_b op_margin_top_30 text-left"><?php echo lang('supplier_due_payment'); ?></h4>
                    <table class="tbl op_width_100_p">   
                        <tr>
                            <th class="w-5 op_font_weight_b"><?php echo lang('sn'); ?></th>
                            <th class="w-30"><?php echo lang('reference_no'); ?></th>
                            <th class="w-35"><?php echo lang('supplier'); ?></th> 
                            <th class="w-30"><?php echo lang('amount'); ?></th>
                        </tr> 
                        <?php  
                            $sum_of_samount = 0; 
                            if (!empty($result['supplier_due_payments']) && isset($result['supplier_due_payments'])):
                                foreach ($result['supplier_due_payments'] as $key => $value): 
                                    $sum_of_samount += $value->amount;  
                                    $key++;
                                    ?>
                                    <tr>
                                        <td><?php echo $key ?></td>
                                        <td><?php echo getAmtCustom($value->reference_no); ?></td>
                                        <td><?php echo escape_output($value->supplier_name); ?></td>
                                        <td><?php echo getAmtCustom($value->amount); ?></td>
                                    </tr>
                                    <?php
                                endforeach;
                            endif;
                        ?>
                        <tr>   
                            <td></td>
                            <td></td>
                            <td class="op_font_weight_b op_right"><?php echo lang('total'); ?></td>  
                            <td><?php echo getAmtCustom($sum_of_samount) ?></td>
                            <td></td>                            
                        </tr>
                        
                    </table>

<h4 class="op_font_weight_b op_margin_top_30 text-left"><?php echo lang('sales'); ?></h4>
                    <table class="tbl op_width_100_p">   
                        <tr>
                            <th class="op_font_weight_b"><?php echo lang('sn'); ?></th>
                            <th><?php echo lang('invoice_no'); ?></th>
                            <th><?php echo lang('customer'); ?></th>
                            <th class="text-center"><?php echo lang('sub_total'); ?></th>
                            <th class="text-center"><?php echo lang('tax'); ?></th>
                            <th class="text-center"><?php echo lang('charge'); ?></th>
                            <th class="text-center"><?php echo lang('discount'); ?></th> 
                            <th class="text-center"><?php echo lang('total_payable'); ?></th>
                            <th class="text-center"><?php echo lang('paid'); ?></th>
                            <th><?php echo lang('due'); ?></th>  
                        </tr> 
                        <?php
                            $sum_of_stotal_payable = 0;
                            $sum_of_sdisc_actual = 0;
                            $sum_of_spaid_amount = 0;
                            $sum_of_sdue_amount = 0;
                            $sum_of_sdelivery_charge = 0;
                            $sum_of_svat = 0;
                            $sum_of_ssub_total = 0;
                            if (!empty($result['sales']) && isset($result['sales'])):
                                foreach ($result['sales'] as $key => $value):
                                    $sum_of_stotal_payable += $value->total_payable;
                                    $sum_of_sdisc_actual += $value->total_discount_amount;
                                    $sum_of_spaid_amount += $value->paid_amount;
                                    $sum_of_sdue_amount += $value->due_amount;
                                    $sum_of_sdelivery_charge += $value->total_discount_amount;
                                    $sum_of_svat += $value->vat;
                                    $sum_of_ssub_total += $value->sub_total;
                                    $key++;
                        ?>
                            <tr>
                                <td><?php echo escape_output($key); ?></td>
                                <td><?php echo escape_output($value->sale_no); ?></td>
                                <td><?php echo escape_output($value->customer_name) ?></td>
                                <td class="text-center"><?php echo getAmtCustom($value->sub_total) ?></td>
                                <td class="text-center"><?php echo getAmtCustom($value->vat) ?></td>
                                <td class="text-center"><?php echo getAmtCustom($value->delivery_charge) ?></td>
                                <td class="text-center"><?php echo getAmtCustom($value->total_discount_amount); ?></td>
                                <td class="text-center"><?php echo getAmtCustom($value->total_payable); ?></td>
                                <td class="text-center"><?php echo getAmtCustom($value->paid_amount); ?></td>
                                <td><?php echo getAmtCustom($value->due_amount); ?></td>
                            </tr>
                            <?php endforeach; endif; ?>
                            <tr>  
                                <td></td> 
                                <td></td>
                                <td class="op_font_weight_b op_right text-left"><?php echo lang('total'); ?></td>  
                                <td class="text-center"><?php echo getAmtCustom($sum_of_ssub_total) ?></td>
                                <td class="text-center"><?php echo getAmtCustom($sum_of_svat) ?></td>
                                <td class="text-center"><?php echo getAmtCustom($sum_of_sdelivery_charge) ?></td>
                                <td class="text-center"><?php echo getAmtCustom($sum_of_sdisc_actual) ?></td>
                                <td class="text-center"><?php echo getAmtCustom($sum_of_stotal_payable) ?></td>
                                <td class="text-center"><?php echo getAmtCustom($sum_of_spaid_amount) ?></td>
                                <td><?php echo getAmtCustom($sum_of_sdue_amount) ?></td>
                            </tr>
                    </table>

<h4 class="op_font_weight_b op_margin_top_30 text-left"><?php echo lang('sale_return'); ?></h4>
                    <table class="tbl op_width_100_p"> 
                        <tr>
                            <th class="op_font_weight_b"><?php echo lang('sn'); ?></th>
                            <th><?php echo lang('ref_no'); ?></th>
                            <th><?php echo lang('customer'); ?></th>
                            <th><?php echo lang('return_amount'); ?></th>
                        </tr> 
                        <?php
                        $sum_of_stotal_payable = 0;
                        if (!empty($result['sale_return']) && isset($result['sale_return'])):
                            foreach ($result['sale_return'] as $key => $value):
                                $sum_of_stotal_payable += $value->total_return_amount;
                                $key++;
                        ?>
                        <tr>
                            <td><?php echo escape_output($key); ?></td>
                            <td><?php echo escape_output($value->reference_no) ?></td>
                            <td><?php echo escape_output($value->customer_name . '(' . $value->phone . ')')  ?></td>
                            <td><?php echo getAmtCustom($value->total_return_amount); ?></td>
                        </tr>
                        <?php endforeach; endif; ?>
                        <tr>  
                            <td></td> 
                            <td class="op_font_weight_b op_right"><?php echo lang('total'); ?></td>  
                            <td><?php echo getAmtCustom($sum_of_stotal_payable) ?></td>
                            <td></td>
                        </tr>
                    </table>

<h4 class="op_font_weight_b op_margin_top_30 text-left"><?php echo lang('customer_due_receive'); ?></h4>
                    <table class="tbl op_width_100_p">   
                        <tr>
                            <th class="op_font_weight_b"><?php echo lang('sn'); ?></th>
                            <th class="w-30"><?php echo lang('reference_no'); ?></th>
                            <th class="w-30"><?php echo lang('customer'); ?></th> 
                            <th class="w-35"><?php echo lang('amount'); ?></th>
                        </tr> 
                        <?php  
                            $sum_of_camount = 0; 
                            if (!empty($result['customer_due_receives']) && isset($result['customer_due_receives'])):
                                foreach ($result['customer_due_receives'] as $key => $value): 
                                    $sum_of_camount += $value->amount;  
                                    $key++;
                                    ?>
                                    <tr>
                                        <td><?php echo $key ?></td>
                                        <td><?php echo escape_output($value->reference_no); ?></td>
                                        <td><?php echo escape_output($value->customer_name); ?></td>
                                        <td><?php echo getAmtCustom($value->amount); ?></td>
                                    </tr>
                                    <?php
                                endforeach;
                            endif;
                        ?>
                        <tr>   
                            <td></td>
                            <td></td>
                            <td class="op_font_weight_b"><?php echo lang('total'); ?></td>  
                            <td><?php echo getAmtCustom($sum_of_camount) ?></td>
                        </tr>
                    </table>
                    
                    <h4 class="op_font_weight_b op_margin_top_30 text-left"><?php echo lang('expense'); ?></h4>
                    <table class="tbl op_width_100_p">    
                            <tr>
                                <th class="op_font_weight_b"><?php echo lang('sn'); ?></th>
                                <th><?php echo lang('reference_no'); ?></th>
                                <th><?php echo lang('expense_category'); ?></th>
                                <th><?php echo lang('responsible_person'); ?></th>
                                <th class="text-center"><?php echo lang('amount'); ?></th>
                                <th><?php echo lang('payment_method'); ?></th>
                            </tr> 
                        <?php  
                            $sum_of_eamount = 0; 
                            if (!empty($result['expenses']) && isset($result['expenses'])):
                                foreach ($result['expenses'] as $key => $value): 
                                    $sum_of_eamount += $value->amount;  
                                    $key++;
                                    ?>
                                    <tr>
                                        <td><?php echo $key ?></td>
                                        <td><?php echo escape_output($value->reference_no) ?></td>
                                        <td><?php echo escape_output($value->expense_category); ?></td>  
                                        <td><?php echo escape_output($value->responsible_person_name); ?></td>
                                        <td class="text-center"><?php echo getAmtCustom($value->amount) ?></td>
                                        <td><?php echo escape_output($value->payment_name); ?></td>
                                    </tr>
                                    <?php
                                endforeach;
                            endif;
                        ?>
                        <tr>   
                            <td></td>
                            <td></td>
                            <td></td>
                            <td class="op_font_weight_b op_right"><?php echo lang('total'); ?></td>  
                            <td class="text-center"><?php echo getAmtCustom($sum_of_eamount) ?></td>
                            <td></td>
                        </tr>
                    </table>

<h4 class="op_font_weight_b op_margin_top_30 text-left"><?php echo lang('income'); ?></h4>
                    <table class="tbl op_width_100_p">  
                        <tr>
                            <th class="op_font_weight_b"><?php echo lang('sn'); ?></th>
                            <th><?php echo lang('reference_no'); ?></th>
                            <th><?php echo lang('income_category'); ?></th>
                            <th><?php echo lang('responsible_person'); ?></th>
                            <th class="text-center"><?php echo lang('amount'); ?></th>
                            <th><?php echo lang('payment_method'); ?></th>
                        </tr> 
                        <?php  
                            $sum_of_iamount = 0; 
                            if (!empty($result['incomes']) && isset($result['incomes'])):
                                foreach ($result['incomes'] as $key => $value): 
                                    $sum_of_iamount += $value->amount;  
                                    $key++;
                                    ?>
                                    <tr>
                                        <td><?php echo $key ?></td>
                                        <td><?php echo escape_output($value->reference_no) ?></td>
                                        <td><?php echo escape_output($value->income_category_name); ?></td>  
                                        <td><?php echo escape_output($value->responsible_person_name); ?></td>
                                        <td class="text-center"><?php echo getAmtCustom($value->amount) ?></td>
                                        <td><?php echo escape_output($value->payment_name); ?></td> 
                                    </tr>
                                    <?php
                                endforeach;
                            endif;
                        ?>
                        <tr>   
                            <td></td>
                            <td></td>
                            <td></td>
                            <td class="op_font_weight_b op_right"><?php echo lang('total'); ?></td>  
                            <td class="text-center"><?php echo getAmtCustom($sum_of_iamount) ?></td>
                            <td></td>
                        </tr>
                    </table>

<h4 class="op_font_weight_b op_margin_top_30 text-left"><?php echo lang('damage'); ?></h4>
                    <table class="tbl op_width_100_p">    
                        <tr>
                            <th class="op_font_weight_b"><?php echo lang('sn'); ?></th>
                            <th><?php echo lang('ref_no'); ?></th>
                            <th class="text-center"><?php echo lang('loss_amount'); ?></th> 
                            <th><?php echo lang('responsible_person'); ?></th> 
                            <th><?php echo lang('items'); ?></th> 
                        </tr> 
                        <?php  
                            $sum_of_wamount = 0; 
                            if (!empty($result['wastes']) && isset($result['wastes'])):
                                foreach ($result['wastes'] as $key => $value): 
                                    $sum_of_wamount += $value->total_loss;  
                                    $key++;
                                    ?>
                                    <tr>
                                        <td><?php echo $key ?></td>
                                        <td><?php echo escape_output($value->reference_no); ?></td> 
                                        <td class="text-center"><?php echo getAmtCustom($value->total_loss); ?></td>
                                        <td><?php echo escape_output($value->responsible_person); ?></td>
                                        <td>
                                        <?php 
                                            $damageItems = damageItemDetailsByDamageId($value->id);
                                            if($damageItems){
                                                echo "<strong>Name(Code)-Qty(Unit)-Price</strong><br>";
                                                foreach($damageItems as $d){
                                                    echo escape_output($d->item_name). '(' . $d->code . ')-' . $d->damage_quantity . '('  . $d->unit_name . ')-' . getAmtCustom($d->loss_amount) . '<br>';
                                                }
                                            }
                                        ?>
                                        </td> 
                                    </tr>
                                    <?php
                                endforeach;
                            endif;
                        ?>
                        <tr>   
                            <td></td>
                            <td class="op_font_weight_b op_right"><?php echo lang('total'); ?></td>  
                            <td class="text-center"><?php echo getAmtCustom($sum_of_wamount) ?></td>
                            <td></td>
                            <td></td>
                        </tr>
                    </table> 
            
                    <h4 class="op_font_weight_b op_margin_top_30 text-left"><?php echo lang('installment_collection'); ?></h4>
                    <table class="tbl op_width_100_p">    
                        <tr>
                            <th class="op_font_weight_b"><?php echo lang('sn'); ?></th>
                            <th><?php echo lang('invoice_no'); ?></th>
                            <th><?php echo lang('customer'); ?></th>
                            <th><?php echo lang('amount'); ?></th> 
                        </tr> 
                        <?php  
                            $sum_of_wamount = 0; 
                            if (!empty($result['installments']) && isset($result['installments'])):
                                foreach ($result['installments'] as $key => $value): 
                                    $sum_of_wamount += $value->paid_amount;  
                                    $key++;
                                    ?>
                                    <tr>
                                        <td><?php echo $key ?></td>
                                        <td><?php echo escape_output($value->reference_no); ?></td> 
                                        <td><?php echo escape_output($value->customer_name); ?></td> 
                                        <td><?php echo getAmtCustom($value->paid_amount); ?></td>
                                    </tr>
                                    <?php
                                endforeach;
                            endif;
                        ?>
                        <tr>   
                            <td></td>
                            <td></td>
                            <td class="op_font_weight_b op_right"><?php echo lang('total'); ?></td>  
                            <td><?php echo getAmtCustom($sum_of_wamount) ?></td>
                        </tr>
                    </table>

<h4 class="op_font_weight_b op_margin_top_30 text-left"><?php echo lang('installment_down_payment'); ?></h4>
                    <table class="tbl op_width_100_p">    
                        <tr>
                            <th class="op_font_weight_b"><?php echo lang('sn'); ?></th>
                            <th><?php echo lang('reference_no'); ?></th> 
                            <th><?php echo lang('customer'); ?></th> 
                            <th><?php echo lang('amount'); ?></th> 
                        </tr> 
                        <?php  
                            $sum_of_damount = 0; 
                            if (!empty($result['installments_down_payment']) && isset($result['installments_down_payment'])):
                                foreach ($result['installments_down_payment'] as $key => $value): 
                                    $sum_of_damount += $value->down_payment;  
                                    $key++;
                                    ?>
                                    <tr>
                                        <td><?php echo $key ?></td>
                                        <td><?php echo escape_output($value->reference_no); ?></td> 
                                        <td><?php echo escape_output($value->customer_name); ?></td> 
                                        <td><?php echo getAmtCustom($value->down_payment); ?></td> 
                                    </tr>
                                    <?php
                                endforeach;
                            endif;
                        ?>
                        <tr>   
                            <td></td>
                            <td></td>
                            <td class="op_font_weight_b op_right"><?php echo lang('total'); ?></td>  
                            <td><?php echo getAmtCustom($sum_of_damount) ?></td>
                        </tr>
                    </table>

<h4 class="op_font_weight_b op_margin_top_30 text-left"><?php echo lang('servicing'); ?></h4>
                    <table class="tbl op_width_100_p">    
                        <tr>
                            <th class="op_font_weight_b"><?php echo lang('sn'); ?></th>
                            <th><?php echo lang('customer'); ?></th> 
                            <th class="text-center"><?php echo lang('servicing_charge'); ?></th> 
                            <th class="text-center"><?php echo lang('paid_amount'); ?></th> 
                            <th><?php echo lang('due_amount'); ?></th> 
                        </tr> 
                        <?php  
                            $sum_of_service = 0; 
                            $sum_of_paid = 0; 
                            $sum_of_due = 0; 
                            if (!empty($result['total_servicing']) && isset($result['total_servicing'])):
                                foreach ($result['total_servicing'] as $key => $value): 
                                    $sum_of_service = $value->servicing_charge; 
                                    $sum_of_paid += $value->paid_amount; 
                                    $sum_of_due += $value->due_amount; 
                                    $key++;
                                    ?>
                                    <tr>
                                        <td><?php echo $key ?></td>
                                        <td><?php echo escape_output($value->customer_name); ?></td> 
                                        <td class="text-center"><?php echo getAmtCustom($value->servicing_charge); ?></td> 
                                        <td class="text-center"><?php echo getAmtCustom($value->paid_amount); ?></td> 
                                        <td><?php echo getAmtCustom($value->due_amount); ?></td> 
                                    </tr>
                                    <?php
                                endforeach;
                            endif;
                        ?>
                        <tr>    
                            <td></td>
                            <td class="op_font_weight_b op_right"><?php echo lang('total'); ?></td>  
                            <td class="text-center"><?php echo getAmtCustom($sum_of_service) ?></td>
                            <td class="text-center"><?php echo getAmtCustom($sum_of_paid) ?></td>
                            <td><?php echo getAmtCustom($sum_of_due) ?></td>
                        </tr>
                    </table> 
                </div>
                
            </div> 
        </div> 
    </div> 
</section>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: printDailySummaryReport.php

Server Info

System Features

User Info