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);
 }
示例#2
0
 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);
 }
示例#3
0
 public static function departmentsList($data, $request)
 {
     $rows = array();
     $no_department = 1;
     $db = \Database::getDB();
     $tbl = $db->addTable('systems_department');
     $tbl->addField('display_name');
     $tbl->addField('parent_department');
     $tbl->addField('description');
     $tbl->addField('active');
     $tbl->addField('id');
     $tbl->addFieldConditional('id', '1', '!=');
     $tbl->addOrderBy('display_name');
     $pager = new \DatabasePager($db);
     $pager->setCallback(array('\\systemsinventory\\Controller\\Settings', 'formatDepartmentList'));
     $pager->setId('department-list');
     $pager->setRowIdColumn('id');
     $pager->setHeaders(array('display_name' => 'Name', 'description' => 'Description', 'parent_department' => 'Parent Department', 'dept_active' => 'Is Active'));
     $data = $pager->getJson();
     return $data;
 }
示例#4
0
 private function purgeListing()
 {
     $db = \Database::newDB();
     $pages = $db->addTable('ps_page');
     $pages->addFieldConditional('deleted', 1);
     $pager = new \DatabasePager($db);
     $pager->setId('purge-list');
     $pager->setHeaders(array('title' => 'Title', 'last_updated' => 'Deleted'));
     $tbl_headers['title'] = $pages->getField('title');
     $tbl_headers['last_updated'] = $pages->getField('last_updated');
     $pager->setTableHeaders($tbl_headers);
     $pager->setCallBack(array('PS_Page', 'purgeRows'));
     $data = $pager->getJson();
     echo json_encode($data);
 }