예제 #1
0
<?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()));
 }