<?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())); }