<?php
include_once 'global.php';
$db = new QueueTaskLogModelDB();
$minId = $db->getFirst('SELECT MIN(id) FROM ' . $db->getTableName());
$addTime = strtotime('-1 month');
$lastId = $db->getFirst('SELECT MAX(id) FROM ' . $db->getTableName() . " WHERE begin_time<{$addTime} ORDER BY id DESC");
$limit = 1000;
while (true) {
$db->exec('DELETE FROM ' . $db->getTableName() . " WHERE id >= {$minId} LIMIT {$limit}");
$minId += $limit;
if ($minId > $lastId) {
break;
}
}
public function delete()
{
$queueTaskLogDB = new QueueTaskLogModelDB();
$whereArr = array();
$whereArr['id'] = $_GET['id'];
$sql = "SELECT * FROM `" . $queueTaskLogDB->getTableName() . "` WHERE `id` = ?";
$row = $queueTaskLogDB->getRow($sql, array_values($whereArr));
$rs = $queueTaskLogDB->delete($whereArr);
Log::write($this->adminUserName, $this->ip, $_GET['id'], self::$state . "__" . self::$action, $rs, Log::arrayToLog($row));
$rs ? Message::showSucc('删除成功') : Message::showError('删除失败：' . implode(" ", $queueTaskLogDB->getErrorInfo()));
}
