function getTableDataWithoutPrimaryKey($tableSetting, $tableName, $page)
{
list($offset, $limit) = $this->getPageRange($page);
$generalDataService = ACloud_Sys_Core_Common::loadSystemClass('generaldata', 'config.service');
$countSql = sprintf('SELECT COUNT(*) as count FROM %s', ACloud_Sys_Core_S::sqlMetadata($tableSetting['name']));
list($count) = $generalDataService->executeSql($countSql);
$count = $count['count'];
if ($count < 1) {
return array(0, array());
}
$dataSql = sprintf('SELECT * FROM %s %s', ACloud_Sys_Core_S::sqlMetadata($tableSetting['name']), ACloud_Sys_Core_S::sqlLimit($offset, $limit));
$data = $generalDataService->executeSql($dataSql);
return array($count, $data);
}
function getSqlLogsByTimestamp($startTime, $endTime, $offset, $perpage)
{
$sqlCondition = $endTime > 0 ? ' AND created_time <= ' . ACloud_Sys_Core_S::sqlEscape($endTime) : '';
return $this->fetchAll(sprintf("SELECT * FROM %s WHERE created_time >= %s {$sqlCondition} %s", $this->tablename, ACloud_Sys_Core_S::sqlEscape($startTime), ACloud_Sys_Core_S::sqlLimit($offset, $perpage)), 'id');
}
