Exemplo n.º 1
0
 /**
  * Enter description here...
  *
  * @param array $columns
  * @param DevblocksSearchCriteria[] $params
  * @param integer $limit
  * @param integer $page
  * @param string $sortBy
  * @param boolean $sortAsc
  * @param boolean $withCounts
  * @return array
  */
 static function search($columns, $params, $limit = 10, $page = 0, $sortBy = null, $sortAsc = null, $withCounts = true)
 {
     $db = DevblocksPlatform::getDatabaseService();
     $fields = SearchFields_Sensor::getFields();
     // Sanitize
     if (!isset($fields[$sortBy])) {
         $sortBy = null;
     }
     list($tables, $wheres) = parent::_parseSearchParams($params, $columns, $fields, $sortBy);
     $start = $page * $limit;
     // [JAS]: 1-based [TODO] clean up + document
     $total = -1;
     $select_sql = sprintf("SELECT " . "s.id as %s, " . "s.name as %s, " . "s.extension_id as %s, " . "s.updated_date as %s, " . "s.status as %s, " . "s.metric as %s, " . "s.output as %s, " . "s.is_disabled as %s, " . "s.fail_count as %s ", SearchFields_Sensor::ID, SearchFields_Sensor::NAME, SearchFields_Sensor::EXTENSION_ID, SearchFields_Sensor::UPDATED_DATE, SearchFields_Sensor::STATUS, SearchFields_Sensor::METRIC, SearchFields_Sensor::OUTPUT, SearchFields_Sensor::IS_DISABLED, SearchFields_Sensor::FAIL_COUNT);
     $join_sql = "FROM sensor s ";
     // Custom field joins
     list($select_sql, $join_sql, $has_multiple_values) = self::_appendSelectJoinSqlForCustomFieldTables($tables, $params, 's.id', $select_sql, $join_sql);
     $where_sql = "" . (!empty($wheres) ? sprintf("WHERE %s ", implode(' AND ', $wheres)) : "");
     $sort_sql = !empty($sortBy) ? sprintf("ORDER BY %s %s ", $sortBy, $sortAsc || is_null($sortAsc) ? "ASC" : "DESC") : " ";
     $sql = $select_sql . $join_sql . $where_sql . ($has_multiple_values ? 'GROUP BY s.id ' : '') . $sort_sql;
     // [TODO] Could push the select logic down a level too
     if ($limit > 0) {
         $rs = $db->SelectLimit($sql, $limit, $start) or die(__CLASS__ . '(' . __LINE__ . ')' . ':' . $db->ErrorMsg());
     } else {
         $rs = $db->Execute($sql) or die(__CLASS__ . '(' . __LINE__ . ')' . ':' . $db->ErrorMsg());
         $total = mysql_num_rows($rs);
     }
     $results = array();
     while ($row = mysql_fetch_assoc($rs)) {
         $result = array();
         foreach ($row as $f => $v) {
             $result[$f] = $v;
         }
         $object_id = intval($row[SearchFields_Sensor::ID]);
         $results[$object_id] = $result;
     }
     mysql_free_result($rs);
     // [JAS]: Count all
     if ($withCounts) {
         $count_sql = ($has_multiple_values ? "SELECT COUNT(DISTINCT s.id) " : "SELECT COUNT(s.id) ") . $join_sql . $where_sql;
         $total = $db->GetOne($count_sql);
     }
     return array($results, $total);
 }
Exemplo n.º 2
0
 private function _getListAction($path)
 {
     $xml = new SimpleXMLElement("<sensors></sensors>");
     @($p_page = DevblocksPlatform::importGPC($_REQUEST['p'], 'integer', 0));
     list($sensors, $null) = DAO_Sensor::search(array(), array(), 50, $p_page, SearchFields_Sensor::NAME, true, false);
     $this->_renderResults($sensors, SearchFields_Sensor::getFields(), 'sensor', 'sensors');
 }
Exemplo n.º 3
0
 static function getFields()
 {
     return SearchFields_Sensor::getFields();
 }