HomeAction::logsArchive PHP Method

    public function logsArchive()
    {
        // 列表key值 DOACTION表示操作
        $this->pageKeyList = array('Name', 'Engine', 'Version', 'Rows', 'Data_length', 'Data_free', 'Create_time', 'Update_time', 'Collation', 'DOACTION');
        // Tab选项
        $this->pageTab[] = array('title' => '日志列表', 'tabHash' => 'list', 'url' => U('admin/Home/logs'));
        $this->pageTab[] = array('title' => '日志归档', 'tabHash' => 'down', 'url' => U('admin/Home/logsArchive'));
        // 列表分页栏按钮
        $this->pageButton[] = array('title' => L('PUBLIC_LOGS_REMOVE_SEX'), 'onclick' => 'admin.cleanLogs(6)');
        $this->pageButton[] = array('title' => L('PUBLIC_LOGS_REMOVE_SET'), 'onclick' => 'admin.cleanLogs(12)');
        $this->pageButton[] = array('title' => L('PUBLIC_LOGS_REMOVE_LOG'), 'onclick' => 'admin.logsArchive()');
        $data['data'] = D('')->query("SHOW TABLE STATUS LIKE '" . C('DB_PREFIX') . "x_logs%'");
        foreach ($data['data'] as &$v) {
            foreach ($v as $vk => $vv) {
                $vk == 'Data_length' && ($v[$vk] = byte_format($vv));
            }
            $date = ltrim(str_replace(C('DB_PREFIX') . 'x_logs', '', $v['Name']), '_');
            $upTime = D('')->query('SELECT max( ctime ) AS Update_time FROM `' . $v['Name'] . '`');
            $v['Update_time'] = !empty($upTime[0]['Update_time']) ? date('Y-m-d H:i:s', $upTime[0]['Update_time']) : $v['Create_time'];
            $v['DOACTION'] = '<a href="' . U('admin/Home/logs', array('table' => $date)) . '">' . L('PUBLIC_VIEW') . '</a>';
        }
        $this->allSelected = false;
        $this->displayList($data);
    }