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'); }