public function getAll($sql, $pageCondition = false)
{
if (is_array($pageCondition)) {
$pageCondition['page'] = ($page = functions::uint($pageCondition['page'])) ? $page : 1;
$pageCondition['pagesize'] = ($pagesize = functions::uint($pageCondition['pagesize'])) ? $pagesize : 20;
$resource = odb::db()->getAll($sql);
$rows = count($resource);
$pageInfo = functions::pageInfo($rows, $pageCondition['pagesize'], $pageCondition['page']);
}
$startRow = ($pageCondition['page'] - 1) * $pageCondition['pagesize'];
$sql = is_array($pageCondition) ? $sql . " LIMIT {$startRow}, {$pageCondition['pagesize']}" : $sql;
$list = odb::db()->getAll($sql, MYSQL_ASSOC);
if (is_array($pageCondition)) {
$response = array('list' => $list, 'pageInfo' => $pageInfo);
return $response;
}
return $list;
}
public function findAll($noPrint = true)
{
extract(self::$_rcdata);
$sql = "SELECT {$field} FROM {$table} {$join} {$where} {$order} {$limit}";
if (!$noPrint) {
echo $sql;
exit;
}
self::$_rcdata['lastsql'] = $sql;
$list = $this->getAll($sql, MYSQL_ASSOC);
if (self::$_rcdata['page'] && !empty($list)) {
$sql = "SELECT COUNT(*) AS count FROM {$table} {$join} {$where} {$order}";
$rows = $this->getOne($sql, MYSQL_ASSOC);
$rows = $rows['count'];
$list = array('aList' => $list, 'pageInfo' => functions::pageInfo($rows, self::$_rcdata['limit_get']['pagesize'], self::$_rcdata['limit_get']['page']));
}
$this->__freeMemory();
return $list;
}
