<?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 logicResume() { $queueTaskLogDB = new QueueTaskLogModelDB(); $updateArr = array('' => 0); $whereArr = array(); $whereArr['id'] = $_GET['id']; $rs = $queueTaskLogDB->update($updateArr, $whereArr); Log::write($this->adminUserName, $this->ip, $_GET['id'], self::$state . "__" . self::$action, $rs); $rs ? Message::showSucc('恢复成功') : Message::showError('恢复失败:' . implode(" ", $queueTaskLogDB->getErrorInfo())); }