public function __construct()
{
parent::__construct();
Asset::add('select2.css', 'assets/css/select2.css');
Asset::add('select2.min.js', 'assets/js/select2.min.js');
/* Html Exports Tables */
Asset::add('bootstrap-dropdown.js', 'assets/js/bootstrap-dropdown.js');
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::add('volumes', 'assets/js/volumes.js');
/* Fill Up the Select Box */
$volumesall = Media::select(array('mediaid', 'volumename'))->groupby('volumename')->groupby('mediaid')->orderby('volumename', 'asc')->get()->toArray();
$volumeName = array_fetch($volumesall, 'volumename');
$volumeId = array_fetch($volumesall, 'mediaid');
$this->volumeSelectBox = array_combine($volumeId, $volumeName);
}
public function getpools()
{
$pool = Input::get('Pool', "");
$volumes = Media::select(array('mediaid', 'volumename', 'slot', 'mediatype', 'lastwritten', 'voljobs', 'volfiles', 'volbytes', 'volretention', 'volstatus'))->where('poolid', '=', $pool);
return Datatables::of($volumes)->edit_column('volretention', '{{ date("d", $volretention)." Days" }}')->edit_column('volumename', '{{ link_to_route("volumes", $volumename ,array("Volume" => $mediaid)) }} ')->remove_column('mediaid')->make();
}