FloatBackOfffice/application/views/subscription/view_subscribed_deals.php

<!-- Dashboard content -->
<div class="row">
    <div class="col-lg-12">
        <!-- Support tickets -->
        <div class="panel panel-white">
            <!-- overall summary -->
            <?php if ( $overall_summary ): ?>
                <?php
                    $overall_report = array();
                    
                    array_walk( $overall_summary, function( $v, $k ) use ( &$overall_report ) {
                        $overall_report[ $v['location'] ][] = array(
                            'last_24hours' => $v['last_24hours'],
                            'last_7days' => $v['last_7days'],
                            'last_14days' => $v['last_14days'],
                            'last_30days' => $v['last_30days'],
                            'total_sub' => $v['total_sub'],
                            'total_redeem' => $v['total_redeem'],
                            'total_deals' => $v['cardid']
                        );
                    } );

                    $overall_total = array();
                    array_walk( $overall_report, function( $value, $key ) use ( &$overall_total ) {
                        $overall_total[ $key ]['last_24hours'] = array_sum( array_map( function( $e ) { return $e['last_24hours']; }, $value ) );
                        $overall_total[ $key ]['last_7days'] = array_sum( array_map( function( $e ) { return $e['last_7days']; }, $value ) );
                        $overall_total[ $key ]['last_14days'] = array_sum( array_map( function( $e ) { return $e['last_14days']; }, $value ) );
                        $overall_total[ $key ]['last_30days'] = array_sum( array_map( function( $e ) { return $e['last_30days']; }, $value ) );
                        $overall_total[ $key ]['total_sub'] = array_sum( array_map( function( $e ) { return $e['total_sub']; }, $value ) );
                        $overall_total[ $key ]['total_redeem'] = array_sum( array_map( function( $e ) { return $e['total_redeem']; }, $value ) );
                        $overall_total[ $key ]['total_deals'] = count( array_map( function( $e ) { return $e['total_redeem']; }, $value ) );
                    } );
                ?>
                <h3>Overall Summary</h3>
                <div class="table-responsive">
                    <table class="table table-striped table-hover table-bordered table-condensed">
                        <thead class="bg-indigo">
                            <tr>
                                <th style="border-top: 1px solid #bbb;">Location</th>
                                <th style="border-top: 1px solid #bbb;">Total Deals</th>
                                <th style="border-top: 1px solid #bbb;">Total Subscribed in past 24 hours</th>
                                <th style="border-top: 1px solid #bbb;">Total Subscribed in past 7 days</th>
                                <th style="border-top: 1px solid #bbb;">Total Subscribed in past 14 days</th>
                                <th style="border-top: 1px solid #bbb;">Total Subscribed in past 30 days</th>
                                <th style="border-top: 1px solid #bbb;">Total Subscribed All Time</th>
                                <th style="border-top: 1px solid #bbb;">Deals Redeemed</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php foreach ( $overall_total as $key => $item ): ?>
                                <tr>
                                    <th><?php echo $key; ?></th>
                                    <td><?php echo $item['total_deals']; ?></td>
                                    <td><?php echo $item['last_24hours']; ?></td>
                                    <td><?php echo $item['last_7days']; ?></td>
                                    <td><?php echo $item['last_14days']; ?></td>
                                    <td><?php echo $item['last_30days']; ?></td>
                                    <td><?php echo $item['total_sub']; ?></td>
                                    <td><?php echo $item['total_redeem']; ?></td>
                                </tr>
                            <?php endforeach ?>
                        </tbody>
                    </table>                
                </div>
            <?php endif ?>
        </div>
        
        <!-- deals summary -->
        <div class="panel panel-flat">
            <h3>Deals Summary</h3>
            <div class="wrap-support-bar">
                <div class="pagination"><?php echo $link; ?></div>
                <div class="filter">
                    <form class="search-block" action="/subscription/subscribed_deals/" method="GET" autocomplete="off">
                        <div class="search-block-item">
                            <div class="form-group" style="width: 80px" data-label="Card ID">
                                <input type="search" class="form-control"
                                       name="card_id" value="<?= isset($card_id) ? $card_id : '' ?>"
                                       style="max-width: 100px"
                                       onkeyup="if (/\D/g.test(this.value)) this.value = this.value.replace(/\D/g,'')">
                            </div>
                            <div class="form-group" data-label="Deal Name">
                                <input type="search" class="form-control" name="name" value='<?= $name ?? ''; ?>'>
                            </div>
                            <div class="form-group" style="width: 102px" data-label="Location">
                                <input type="search" class="form-control" name="location" value="<?= $location ?? ''; ?>">
                            </div>
                            <div class="form-group" style="width: 100px" data-label="Points">
                                <?php echo $points; ?>
                            </div>
                            <input type="hidden" name="action_hidden" value="search" />
                            <div class="form-group">
                                <button class="btn btn-primary btn-search" type="submit">Search</button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
            
            <div class="panel panel-flat">
                <div class="table-responsive">
                    <?php echo $summary_report; ?>
                </div>
            </div>
        </div>
    </div>
</div>
<!-- /dashboard content -->
<script src="/assets/js/plugins/pickers/datepicker.js"></script>
<script src="/assets/js/app.js"></script>
<script type="text/javascript">
    // datatable init
    $('.deals-subscribed').DataTable();
</script>
<style>
    .search-block-item {
        display: flex;
        flex-wrap: wrap;
    }
    .search-block-item .form-control{
        padding: 4px 6px !important;
    }
    .search-block-item .search-by-date{
        margin-top: -3px;
    }

    .search-by-date {
        display: flex;
        flex-direction: row;
    }

    .search-by-date input {
        width: 95px;
    }
    
    .default_date {
        display: inline-block;
    }

    .wrap-support-bar {
        display: flex;
        flex-wrap: nowrap;
    }
    .wrap-support-bar .pagination {
        margin-right: 30px;
    }

    .wrap-support-bar .filter .form-group::before {
        content: attr(data-label);
        position: absolute;
        bottom: 35px;
    }

    .wrap-support-bar .filter .form-group {
        margin-right: 20px;
    }
</style>