/** * Enter description here... * * @param DevblocksSearchCriteria[] $params * @param integer $limit * @param integer $page * @param string $sortBy * @param boolean $sortAsc * @param boolean $withCounts * @return array */ static function search($params, $limit = 10, $page = 0, $sortBy = null, $sortAsc = null, $withCounts = true) { $db = DevblocksPlatform::getDatabaseService(); $fields = SearchFields_Worker::getFields(); // Sanitize if (!isset($fields[$sortBy])) { $sortBy = null; } list($tables, $wheres) = parent::_parseSearchParams($params, array(), $fields, $sortBy); $start = $page * $limit; // [JAS]: 1-based [TODO] clean up + document $total = -1; $sql = sprintf("SELECT " . "w.id as %s, " . "w.last_activity_date as %s " . "FROM worker w ", SearchFields_Worker::ID, SearchFields_Worker::LAST_ACTIVITY_DATE) . (!empty($wheres) ? sprintf("WHERE %s ", implode(' AND ', $wheres)) : "") . (!empty($sortBy) ? sprintf("ORDER BY %s %s", $sortBy, $sortAsc || is_null($sortAsc) ? "ASC" : "DESC") : ""); // [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()); /* @var $rs ADORecordSet */ } else { $rs = $db->Execute($sql) or die(__CLASS__ . '(' . __LINE__ . ')' . ':' . $db->ErrorMsg()); /* @var $rs ADORecordSet */ $total = $rs->RecordCount(); } $results = array(); if (is_a($rs, 'ADORecordSet')) { while (!$rs->EOF) { $result = array(); foreach ($rs->fields as $f => $v) { $result[$f] = $v; } $ticket_id = intval($rs->fields[SearchFields_Worker::ID]); $results[$ticket_id] = $result; $rs->MoveNext(); } } // [JAS]: Count all if ($withCounts) { $rs = $db->Execute($sql); $total = $rs->RecordCount(); } return array($results, $total); }
static function getFields() { return SearchFields_Worker::getFields(); }
/** * Enter description here... * * @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_Worker::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 " . "w.id as %s, " . "w.first_name as %s, " . "w.last_name as %s, " . "w.title as %s, " . "w.email as %s, " . "w.is_superuser as %s, " . "w.last_activity_date as %s, " . "w.is_disabled as %s ", SearchFields_Worker::ID, SearchFields_Worker::FIRST_NAME, SearchFields_Worker::LAST_NAME, SearchFields_Worker::TITLE, SearchFields_Worker::EMAIL, SearchFields_Worker::IS_SUPERUSER, SearchFields_Worker::LAST_ACTIVITY_DATE, SearchFields_Worker::IS_DISABLED); $join_sql = "FROM worker w "; // Custom field joins list($select_sql, $join_sql, $has_multiple_values) = self::_appendSelectJoinSqlForCustomFieldTables($tables, $params, 'w.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 w.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_Worker::ID]); $results[$object_id] = $result; } // [JAS]: Count all if ($withCounts) { $count_sql = ($has_multiple_values ? "SELECT COUNT(DISTINCT w.id) " : "SELECT COUNT(w.id) ") . $join_sql . $where_sql; $total = $db->GetOne($count_sql); } mysql_free_result($rs); return array($results, $total); }