protected function getJsonView($data, \Request $request)
{
$db = \Database::newDB();
$sd = $db->addTable('systems_device');
$conditional = $this->createSearchConditional($db);
if (!empty($conditional)) {
$db->addConditional($conditional);
}
$dbpager = new \DatabasePager($db);
$dbpager->setHeaders(array('physical_id' => 'Physical ID', 'department_id' => 'Department', 'location_id' => 'Location', 'model' => 'Model', 'room_number' => 'Room Number', 'username' => 'Username', 'purchase_date' => 'Purchase Date'));
$tbl_headers['physical_id'] = $sd->getField('physical_id');
$tbl_headers['department_id'] = $sd->getField('department_id');
$tbl_headers['location_id'] = $sd->getField('location_id');
$tbl_headers['model'] = $sd->getField('model');
$tbl_headers['room_number'] = $sd->getField('room_number');
$tbl_headers['username'] = $sd->getField('username');
$tbl_headers['purchase_date'] = $sd->getField('purchase_date');
$dbpager->setTableHeaders($tbl_headers);
$dbpager->setId('device-list');
$dbpager->setRowIdColumn('id');
$dbpager->setCallback(array('\\systemsinventory\\Controller\\Search', 'alterSearchRow'));
$data = $dbpager->getJson();
return parent::getJsonView($data, $request);
}
/**
* Serve index.js
* @param \http\Controller $ctl
*/
private function serveJavascript($ctl)
{
$ctl->detachAll(Observer\View::class);
$ctl->getResponse()->setHeader("Content-Type", "application/javascript");
$ctl->getResponse()->setBody(new \http\Message\Body(fopen(ROOT . "/public/index.js", "r")));
}
private function listSchedules(\Request $request)
{
$db = \Database::getDB();
$schedule_table = $db->addTable('pulse_schedule');
$pager = new \DatabasePager($db);
$pager->setId('schedule-list');
$headers = array('status' => 'Status', 'id' => 'ID', 'name' => 'Name', 'interim' => 'Interim', 'execute_after' => 'Execute after', 'start_time' => 'Start time', 'end_time' => 'End time');
$pager->setHeaders($headers);
$table_headers['status'] = $schedule_table->getField('status');
$table_headers['id'] = $schedule_table->getField('id');
$table_headers['name'] = $schedule_table->getField('name');
$table_headers['interim'] = $schedule_table->getField('interim');
$table_headers['execute_after'] = $schedule_table->getField('execute_after');
$table_headers['start_time'] = $schedule_table->getField('start_time');
$table_headers['end_time'] = $schedule_table->getField('end_time');
$pager->setTableHeaders($table_headers);
$pager->setRowIdColumn('id');
$pager->setCallback(array('pulse\\PulseFactory', 'pagerRows'));
$data = $pager->getJson();
return parent::getJsonView($data, $request);
}
<?php
define("ROOT", dirname(__DIR__));
define("REFS", getenv("REFPATH") ?: implode(PATH_SEPARATOR, glob(ROOT . "/refs/*")));
#ini_set("open_basedir", ROOT.":".REFS);
$loader = (require ROOT . "/vendor/autoload.php");
/* @var $loader \Composer\Autoload\ClassLoader */
$loader->add("mdref", ROOT);
use http\Controller;
use http\Controller\Url;
use http\Controller\Observer\Layout;
use mdref\ExceptionHandler;
use mdref\Action;
new ExceptionHandler();
$ctl = new Controller();
$ctl->setDependency("baseUrl", new Url())->attach(new Action(["refpath" => REFS]))->attach(new Layout())->notify()->getResponse()->send();
