public function getSqlLogsByTimestamp($startTime, $endTime, $offset, $perpage)
{
$sqlCondition = $endTime > 0 ? ' AND created_time <= ' . ACloudSysCoreS::sqlEscape($endTime) : '';
return $this->fetchAll(sprintf("SELECT * FROM %s WHERE created_time >= %s {$sqlCondition} %s", $this->tablename, ACloudSysCoreS::sqlEscape($startTime), ACloudSysCoreS::sqlLimit($offset, $perpage)), 'id');
}
private function getTableDataWithoutPrimaryKey($tableSetting, $tableName, $page)
{
list($offset, $limit) = $this->getPageRange($page);
$generalDataService = ACloudSysCoreCommon::loadSystemClass('generaldata', 'config.service');
$countSql = sprintf('SELECT COUNT(*) as count FROM %s', ACloudSysCoreS::sqlMetadata($tableSetting['name']));
list($count) = $generalDataService->executeSql($countSql);
$count = $count['count'];
if ($count < 1) {
return array(0, array());
}
$dataSql = sprintf('SELECT * FROM %s %s', ACloudSysCoreS::sqlMetadata($tableSetting['name']), ACloudSysCoreS::sqlLimit($offset, $limit));
$data = $generalDataService->executeSql($dataSql);
return array($count, $data);
}
public function getThreadsByModifiedTime($startTime, $endTime, $page, $perpage)
{
list($startTime, $endTime, $page, $perpage) = array(intval($startTime), intval($endTime), intval($page), intval($perpage));
if ($startTime < 1 || $endTime < 1 || $startTime > $endTime || $page < 1 || $perpage < 1) {
return array();
}
$offset = ($page - 1) * $perpage;
$sql = sprintf("SELECT t.* FROM %s t WHERE t.fid != 0 AND t.ischeck = 1 AND t.modified_time >= %s AND t.modified_time <= %s %s", ACloudSysCoreS::sqlMetadata('{{bbs_threads}}'), ACloudSysCoreS::sqlEscape($startTime), ACloudSysCoreS::sqlEscape($endTime), ACloudSysCoreS::sqlLimit($offset, $perpage));
$query = Wind::getComponent('db')->query($sql);
$result = $query->fetchAll(null, PDO::FETCH_ASSOC);
if (!ACloudSysCoreS::isArray($result)) {
return array();
}
$result = $this->getContentAndForumInfo($result);
return $this->_buildThreadData($result);
}
