<?php
/**
 * Created by PhpStorm.
 * User: xtong
 * Date: 17/9/1
 * Time: 17:39
 */
namespace Frontend\Controller\UpdateDB;

class TaskUpdateController extends AbstractController
{
    /**
     * 任务中心上线所需数据字段变更
     * @author daijun
     * @date 2017-09-15
     */
    public function Index()
    {
        $sql = $this->_updateSql();
        if (empty($sql)) {

            exit('没有可升级的sql');
        }

        $db = \Think\Db::getInstance();
        try {
            $db->execute($sql);
        } catch (\Exception $e) {
            exit("数据库升级失败：" . $e->getMessage());
        }

        exit("数据库升级完成，执行sql如下：{$sql}");
    }

    /**
     * 待升级的sql
     *      1. oa_activity_activity（活动主表），增加字段 activity_type
     *      2. oa_activity_activity（活动主表），增加索引 activity_type
     * @author daijun
     * @return string
     */
    private function _updateSql()
    {
        $sql = "
             ALTER TABLE `oa_activity_activity` add `activity_type` TINYINT(3) NOT NULL DEFAULT '1' COMMENT '活动状态 1=常规,2=任务' AFTER `ac_id`;
             ALTER TABLE `oa_activity_activity` ADD INDEX activity_type ( `activity_type`);
        ";
        return $sql;
    }
}