public function __construct()
{
parent::__construct();
Asset::add('amcharts', 'assets/js/amcharts.js');
Asset::add('amchartsPie', 'assets/js/pie.js');
Asset::add('bootstrap-tooltip.js', 'assets/js/bootstrap-tooltip.js');
Asset::add('bootstrap-dropdown.js', 'assets/js/bootstrap-dropdown.js');
/* Html Exports Tables */
Asset::add('tableExport.js', 'assets/js/tableExport.js');
Asset::add('jquery.base64.js', 'assets/js/jquery.base64.js');
Asset::add('html2canvas.js', 'assets/js/html2canvas.js');
Asset::add('sprintf.js', 'assets/js/sprintf.js');
Asset::add('jspdf.js', 'assets/js/jspdf.js');
Asset::add('base64.js', 'assets/js/base64.js');
Asset::container('footer')->add('dashboard', 'assets/js/dashboard.js');
// Caching DbSize Value
$dbsize = Cache::rememberForever('dbsize', function () {
/* Get Database Size */
if (Config::get('database.default') == 'mysql') {
$dbsize = DB::select('SELECT table_schema "Data Base Name",
SUM( data_length + index_length) / 1024 / 1024 "dbsize"
FROM information_schema.TABLES
WHERE table_schema = "' . Config::get('database.connections.mysql.database') . '"
GROUP BY table_schema ;');
} else {
$dbsize = DB::select("SELECT pg_database_size('" . Config::get('database.connections.pgsql.database') . "') as dbsize");
}
return $dbsize[0]->dbsize;
}, 15);
// Caching Number of Clients
$clients = Cache::rememberForever('nclients', function () {
$clients = Client::get();
//where_in('name', $this->group_permissions_clients)
return count($clients);
}, 15);
// Caching Number of Files And Bytes
$media = Media::get(array(DB::raw('sum(volbytes) as bytes'), DB::raw('sum(volfiles) as files')))->first();
Cache::forever('nFiles', $media->files);
Cache::forever('nBytes', $media->bytes);
}
