report_total_assets.inc

<?php
require_once SQ_SYSTEM_ROOT.'/core/assets/system/simple_report/simple_report.inc';

class Report_Total_Assets extends Simple_Report
{


    function __construct($assetid=0)
    {
        parent::__construct($assetid);

    }//end constructor


    public static function paintReport(Backend_Outputter &$o, $type_code)
    {
        $report = Report_Total_Assets::loadReport($type_code);

        if (empty($report)) {
            Report_Total_Assets::paintReportNotGenerated($type_code);
            return TRUE;
        }

        $generated = $report['generated'];
        $report = $report['report_data'];

        $row_format = '<tr>
                <td class="sq-backend-table-cell">
                    %s
                </td>
                <td class="sq-backend-table-cell" align="right">
                    %s
                </td>
                </tr>';

        $current_day_assets_table = '<table class="sq-backend-table">
                        <tr>
                            <th class="sq-backend-table-header" width="30%%">Assets currently in the system</th>
                            <td align="right">'.$report['num_assets_today'].'</td>
                        </tr>
                    </table>';

        $row_string = '';
        $report = $report['date_report'];
        foreach ($report as $date_description => $date_data) {
            $row_string .= sprintf($row_format, $date_description, $date_data['num_assets']);
        }

        $table_format = '<table class="sq-backend-table">
                    <tr>
                        <th class="sq-backend-table-header">Period</th>
                        <th class="sq-backend-table-header" width="35%%" align="right">Assets in the system</th>
                    </tr>
                    %s
                </table>';

        $table = sprintf($table_format, $row_string);
        Report_Total_Assets::paintLastGeneratedDate($type_code, date('d M Y, H:i:s', $generated));
        echo '<br>';
        Report_Total_Assets::_paintSystemInstallDate();
        echo $current_day_assets_table;
        echo $table;

    }//end paintReport()


    public static function processReport(Backend_Outputter &$o, $type_code)
    {
        $today = time();

        $year = date('Y', $today);
        $month = date('m', $today);
        $date = date('d', $today);

        $last_month = str_pad(date('m', $today) - 1, 2, '0', STR_PAD_LEFT);

        $date_yesterday = date('Y-m-d', $today - (24*3600));
        $last_week_date = date('Y-m-d', $today - (24*3600*7));
        $last_month_date = date('Y-m-d', $today - (30*24*3600));
        $last_quarter_date = date('Y-m-d', $today - (90*24*3600));
        $last_semester_date = date('Y-m-d', $today - (180*24*3600));
        $last_year_date = date('Y-m-d', $today - (365*24*3600));

        $date_report = Array(
                'Yesterday'     => Array(
                                'date'      => $date_yesterday,
                                'num_assets'    => 0,
                               ),
                'Last week'     => Array(
                                'date'      => $last_week_date,
                                'num_assets'    => 0,
                               ),
                'Last month'        => Array(
                                'date'      => $last_month_date,
                                'num_assets'    => 0,
                               ),
                'Last three months' => Array(
                                'date'      => $last_quarter_date,
                                'num_assets'    => 0,
                               ),
                'Last six months'   => Array(
                                'date'      => $last_semester_date,
                                'num_assets'    => 0,
                               ),
                'Last year'     => Array(
                                    'date'      => $last_year_date,
                                    'num_assets'    => 0,
                               ),
                   );

        $num_assets_today = Report_Total_Assets::_getTotalAssets();
        $last_period = FALSE;
        $remove_date_items = Array();

        foreach ($date_report as $date_description => $date_data) {
            if ($last_period) {
                $remove_date_items[] = $date_description;
                continue;
            }

            $num_assets = Report_Total_Assets::_getTotalAssets($date_data['date']);
            $date_report[$date_description]['num_assets'] = $num_assets_today - $num_assets;

            if ($date_report[$date_description]['num_assets'] === 0) {
                $last_period = TRUE;
            }
        }

        foreach ($remove_date_items as $date_description) {
            unset($date_report[$date_description]);
        }

        $report = Array(
                'generated'     => $today,
                'report_data'       => Array(
                                'num_assets_today'  => $num_assets_today,
                                'date_report'       => $date_report,
                               ),
              );

        Report_Total_Assets::saveReport($type_code, $report);

        return TRUE;

    }//end processReport()


    private static function _getTotalAssets($after_date='')
    {
        $after_date_query = '';
        if ($after_date != '') {
            $after_date_query = ' WHERE created >= '.MatrixDAL::quote($after_date);
        }

        $db = MatrixDAL::getDb();
        $sql = 'SELECT count(*) AS total '.
            'FROM sq_ast'.$after_date_query;

        $num_assets = MatrixDAL::executeSqlOne($sql);

        return $num_assets;

    }//end _getTotalAssets()


    private static function _paintSystemInstallDate()
    {
        $table_format = '<table class="sq-backend-table">
                    <tr>
                        <th class="sq-backend-table-header" width="30%%">System Install Date</th>
                        <td class="sq-backend-table-cell" align="right">%s</td>
                    </tr>
                </table>';

        $time = strtotime(Report_Total_Assets::_getSystemInstallDate());
        $date = date('d M Y, H:i:s', $time);

        $table = sprintf($table_format, $date);
        echo $table;

    }//end _paintSystemInstallDate()


    private static function _getSystemInstallDate()
    {
        $db = MatrixDAL::getDb();
        $sql = 'SELECT MIN(created)FROM sq_ast';

        $first_asset_date = MatrixDAL::executeSqlOne($sql);

        return $first_asset_date;

    }//end _getSystemInstallDate()


}//end class
?>