source: pro-violet-viettel/sourcecode/application/modules/admin/views/reportpackage/province.php

<div class="page-content">

    <div class="row">
        <div class="col-xs-12">
            <!-- PAGE CONTENT BEGINS -->
            <div style="padding-bottom:4px" class="table-header">
                Báo cáo doanh thu theo tỉnh / thà nh phố theo gói cước.
            <div class="pull-right" style="margin:5px;">
                    <a style="color:#fff" href="<?php echo base_url();?>admin/reportpackage/export/<?php echo $date;?>/<?php echo $month;?>/<?php echo $year;?>/-/<?php echo $to_date;?>/<?php echo $to_month;?>/<?php echo $to_year;?>">Xuất ra Excel</a>
                </div>
            </div>
            <!-- PAGE CONTENT BEGINS -->
            <div class="table-responsive">
                <div role="grid" class="dataTables_wrapper" id="sample-table-2_wrapper">
                    <form autocomplete="off" onsubmit="return false;" id="province" >
                        <div class="row">
                            <div class="col-sm-1">
                                <div class="" style="display: inline-block"><label><strong>Từ: </strong></label></div>
                                                        </div>
                                                        <div class="col-sm-6">
                                                                <div class="" style="display: inline-block"><label>Ngà y</label>

                                        <select aria-controls="sample-table-2" size="1" name="date" onchange="filter();">                                      
                                            <?php for ($i=1;$i<=31;$i++) { ?>
                                            <option value="<?php echo $i;?>" <?php if($date==$i) { ?> selected <?php }?>><?php echo $i;?></option>
                                            <?php }?>
                                        </select>
                                </div>
                                                                <div class="" style="display: inline-block"><label>Tháng</label>

                                        <select aria-controls="sample-table-2" size="1" name="month" onchange="filter();">                                      
                                            <?php for ($i=1;$i<=12;$i++) { ?>
                                            <option value="<?php echo $i;?>" <?php if($month==$i) { ?> selected <?php }?>><?php echo $i;?></option>
                                            <?php }?>
                                        </select>
                                </div>
                                <div class=""  style="display: inline-block"><label>Năm

                                        <select aria-controls="sample-table-2" size="1" name="year" onchange="filter();">                                      
                                            <?php for ($i=2014;$i<=date("Y");$i++) { ?>
                                            <option value="<?php echo $i;?>" <?php if($year==$i) { ?> selected <?php }?>><?php echo $i;?></option>
                                            <?php }?>
                                        </select>
                                </div>
                                                        </div>
                                                        

                            <div class="col-sm-6">

                            </div>
                        </div>
                                                
                                                <div class="row">
                                                        <div class="col-sm-1">
                                <div class="" style="display: inline-block"><label><strong>Đến: </strong></label></div>
                                                        </div>
                                                        <div class="col-sm-6">
                                                                <div class="" style="display: inline-block"><label>Ngà y</label>

                                        <select aria-controls="sample-table-2" size="1" name="to_date" onchange="filter();">                                      
                                            <?php for ($i=1;$i<=31;$i++) { ?>
                                            <option value="<?php echo $i;?>" <?php if($to_date==$i) { ?> selected <?php }?>><?php echo $i;?></option>
                                            <?php }?>
                                        </select>
                                </div>
                                <div class="" style="display: inline-block"><label>Tháng</label>

                                        <select aria-controls="sample-table-2" size="1" name="to_month" onchange="filter();">                                      
                                            <?php for ($i=1;$i<=12;$i++) { ?>
                                            <option value="<?php echo $i;?>" <?php if($to_month==$i) { ?> selected <?php }?>><?php echo $i;?></option>
                                            <?php }?>
                                        </select>
                                </div>
                                <div class=""  style="display: inline-block"><label>Năm

                                        <select aria-controls="sample-table-2" size="1" name="to_year" onchange="filter();">                                      
                                            <?php for ($i=2014;$i<=date("Y");$i++) { ?>
                                            <option value="<?php echo $i;?>" <?php if($to_year==$i) { ?> selected <?php }?>><?php echo $i;?></option>
                                            <?php }?>
                                        </select>
                                </div>
                            </div>
                                                </div>
                                                
                          </form>
                    <table class="table table-striped table-bordered table-hover dataTable" id="sample-table-2" aria-describedby="sample-table-2_info">
                        <thead>
                            <tr>
                                <th class="center sorting_disabled" role="columnheader" rowspan="1" colspan="1" style="width: 44px;" aria-label="">
                                    Thứ tự
                                </th>
                                <th class="">Tỉnh/TP</th>
                                <?php foreach ($packages as $package) {?>
                                <th class=""><?php echo $package['p_name']; ?></th>
                                <th class="">Tỉ lệ %</th>
                                <?php }?>
                                <th>Tổng TB</th>
                            </tr>
                        </thead>
                                                <tr>
                                                                <td colspan=2 align="center" style="font-weight:bold;">Tổng</td>
                                                                <?php $d = 0; ?>
                                                                <?php foreach ($totalVip as $vipName => $total): ?>     
                                                                        <?php $d++;?>
                                                                        <td style="font-weight:bold;"><?php echo $total; ?></td>
                                                                        <?php if($d<count($totalVip)): ?>
                                                                        <td></td>
                                                                        <?php endif;?>
                                                                <?php endforeach; ?>
                                                        </tr>
                        <tbody role="alert" aria-live="polite" aria-relevant="all">
                            <?php
                                                        $total = array();
                            foreach ($provinces as $province) {
                                ?>
                                <tr class="odd">


                                    <td class=" ">
                                        <?php echo $province['stt']; ?>
                                    </td>
                                    <td class=" "><?php echo $province['province']; ?></td>
                                    <?php foreach ($province['packages'] as $package) { ?>
                                    <td><?php echo $package['total']?></td>
                                    <td><?php echo $package['percent']?></td>
                                    <?php } ?>
                                    <td class=" "><?php echo $province['total']?></td>

                                </tr>
                            <?php } ?>
                                                        <?php //var_dump($total);?>
                                                        
                        </tbody>
                    </table>
                    <!--<div class="row"><div class="col-sm-6">-->

                        </div>
                    </div>
                </div><!-- /.table-responsive -->

                <!-- PAGE CONTENT ENDS -->
            </div><!-- /.col -->
        </div><!-- /.row -->
    </div><!-- /.page-content -->