Basicinfo.php 9.2 KB
<?php

namespace app\school\controller\setting;

use app\common\controller\DoubleBase;

use app\school\model\setting\ProjectContainer;
use app\school\model\setting\ProjectFormSet;
use app\school\model\setting\ProjectType;
use think\Db;
use think\Exception;


class Basicinfo extends DoubleBase
{
    protected $containerId = null;

    /**
     * 编辑项目
    */
    public function edit($ids = NULL) {
        $this->containerId = $_COOKIE['container_id'];
        $projectTypeModel = new ProjectType();

        if ($this->request->isAjax()) {
            $rows = $this->request->param('row/a');
            $needSplitItems = ['project_time', 'midterm_review_time', 'conclusion_time'];

            foreach ($needSplitItems as $v) {
                if ( empty($rows[$v]) ) continue;
                $dateArr = explode(' - ', $rows[$v]);
                $preFixStr = substr($v, 0,-4);
                $rows[$preFixStr.'starttime'] = strtotime($dateArr[0]);
                $rows[$preFixStr.'endtime'] = strtotime($dateArr[1]);
                unset($rows[$v]);
            }

            // 项目类别
            $projectTypes = json_decode($rows['project_types'], true);
            $projectTypesUpdate = [];
            $projectTypesInsert = [];
            foreach ($projectTypes as $typeItem) {
                // 已存在的类别
                if (!empty($typeItem['id'])) {
                    $projectTypesUpdate[] = $typeItem;
                } else {
                    unset($typeItem['id']);
                    $typeItem['container_id'] = $this->containerId;
                    $typeItem['school_id'] = $this->auth->school_id;
                    $projectTypesInsert[] = $typeItem;
                }
            }
            // 被移除的项目类型id
            $delProjectTypes = explode(',', $rows['del_project_type_id']);
            foreach ($delProjectTypes as $id) {
                $projectTypesUpdate[] = ['id' => $id, 'deletetime' => time()];
            }
            Db::startTrans();
            try {
                $projectContainerModel = new ProjectContainer();
                $projectContainerModel->allowField(true)->save($rows, ['id' => $rows['id']]);
                // 修改的项目类型
                $projectTypeModel->saveAll($projectTypesUpdate);
                // 新增的项目类型
                $insertTypes = $projectTypeModel->isUpdate(false)->saveAll($projectTypesInsert);

                // 新增相关项目表单设置
                $typeIdArr = array_column(collection($insertTypes)->toArray(), 'id');
                $prjectFormSetModel = new ProjectFormSet();
                $prjectFormSetModel->isUpdate(false)->saveAll($this->projectFormSetData($typeIdArr));

                Db::commit();
            } catch (Exception $e) {
                Db::rollback();
                $this->error($e->getMessage());
            }

            $this->success('', '', $rows);
        }
        $row = Db::name('project_container')->where(['id' => $this->containerId])->find();
        if (!$row) {
            $this->error('No Results were found');
        }
        $projectTypesFields = ['name', 'desc_content', 'id'];
        $projectTypes = $projectTypeModel->field($projectTypesFields)->where(['container_id' => $this->containerId])->select();

        $needFormatterTimeItems = ['project_starttime', 'project_endtime', 'midterm_review_starttime', 'midterm_review_endtime', 'conclusion_starttime', 'conclusion_endtime'];
        foreach ($needFormatterTimeItems as $v) {
            $row[$v] = date('Y-m-d H:i:s', $row[$v]);
        }
        $this->assign('row', $row);
        $this->assignconfig('row', $row);
        $this->assign('project_types', json_encode($projectTypes));
        $this->assignconfig('project_types', $projectTypes);
        return $this->fetch();
    }

    /**
     * 新增项目
    */
    public function add() {
        if ($this->request->isAjax()) {
            $rows = $this->request->param('row/a');
            $needSplitItems = ['project_time', 'midterm_review_time', 'conclusion_time'];
            foreach ($needSplitItems as $v) {
                $dateArr = explode(' - ', $rows[$v]);
                $preFixStr = substr($v, 0,-4);
                $rows[$preFixStr.'starttime'] = strtotime($dateArr[0]);
                $rows[$preFixStr.'endtime'] = strtotime($dateArr[1]);
                unset($rows[$v]);
            }
            $rows['project_double_starttime'] = $rows['project_starttime'];
            $rows['project_double_endtime'] = $rows['project_endtime'];
            $rows['is_open'] = 1;

            // 项目类别
            $projectTypes = json_decode($rows['project_types'], true);
            foreach ($projectTypes as $v) {
                $v['name'] = trim($v['name']);
                $v['desc_content'] = trim($v['desc_content']);
                if(empty($v['name']) || empty($v['desc_content'])) {
                    $this->error('项目名称或项目介绍不能为空');
                }
            }
            $projectTypesInsert = [];
            $formSetTeyps = ['reg','members','teachers','meta_check','conclusion'];
            Db::startTrans();
            try {
                // 新增项目
                $projectContainerModel = new ProjectContainer();
                $projectContainerModel->allowField(true)->save($rows);
                $addContianerId = $projectContainerModel->id;

                foreach ($projectTypes as $typeItem) {
                    unset($typeItem['id']);
                    $typeItem['container_id'] = $addContianerId;
                    $typeItem['school_id'] = $this->auth->school_id;
                    $projectTypesInsert[] = $typeItem;
                }

                // 新增相关项目类型
                $projectTypeModel = new ProjectType();
                $insertTypes = $projectTypeModel->isUpdate(false)->saveAll($projectTypesInsert);

                // 新增相关项目表单设置
                $typeIdArr = array_column(collection($insertTypes)->toArray(), 'id');
                $prjectFormSetModel = new ProjectFormSet();
                $prjectFormSetModel->isUpdate(false)->saveAll($this->projectFormSetData($typeIdArr));

                Db::commit();
            } catch (Exception $e) {
                Db::rollback();
                $this->error($e->getMessage());
            }
            $this->success('新建成功', '', $rows);
        }

        $row = [
            'school_id' => $this->auth->school_id
        ];
        $projectTypes = $this->projectTypesData();

        $this->assign('row', $row);
        $this->assign('project_types', json_encode($projectTypes));
        $this->assignconfig('project_types', $projectTypes);
        return $this->fetch();
    }


    /**
     * 返回固定格式的项目类型数据
     * @return array
    */
    private function projectTypesData() {
        return [
            [
                'name' => '创新训练项目',
                'desc_content'  => '自主完成创新性研究项目设计、研究条件准备和项目实施、研究报告撰写、成果(学术)交流等工作'
            ],
            [
                'name' => '创业训练项目',
                'desc_content'  => '编制商业计划书、开展可行性研究、模拟企业运行、参加企业实践、撰写创业报告等工作'
            ],
            [
                'name' => '创业实践项目',
                'desc_content'  => '提出一项具有市场前景的创新性产品或者服务,以此为基础开展创业实践活动'
            ]
        ];
    }

    /**
     * 根据传入的项目类型id,返回需要新增的项目报名设置数据
     * @param array $typeIdArr 项目类型id集合
     * @return array
    */
    private function projectFormSetData($typeIdArr = []) {
        $result = [];
        $schoolId = $this->auth->school_id;
        foreach ($typeIdArr as $id) {
            $result[] = [ 'school_id' => $schoolId, 'project_type_id' => $id, 'stage_title' => '报名', 'stage_type' => 'reg', 'fields_setting' => null ];
            $result[] = [ 'school_id' => $schoolId, 'project_type_id' => $id, 'stage_title' => '项目成员', 'stage_type' => 'members', 'fields_setting' => null ];
            $result[] = [ 'school_id' => $schoolId, 'project_type_id' => $id, 'stage_title' => '指导教师', 'stage_type' => 'teachers', 'fields_setting' => null ];
            $result[] = [ 'school_id' => $schoolId, 'project_type_id' => $id, 'stage_title' => '项目详细信息', 'stage_type' => 'details', 'fields_setting' => null ];
            $result[] = [ 'school_id' => $schoolId, 'project_type_id' => $id, 'stage_title' => '中期检查', 'stage_type' => 'meta_check', 'fields_setting' => null ];
            $result[] = [ 'school_id' => $schoolId, 'project_type_id' => $id, 'stage_title' => '项目结题', 'stage_type' => 'conclusion', 'fields_setting' => null ];
        }

        $formFieldsMap = json_decode(file_get_contents('assets/js/school/setting/formFieldsMap.json', FILE_USE_INCLUDE_PATH), true);
        foreach ($result as &$formSet) {
            $fieldsSetting = json_encode($formFieldsMap[$formSet['stage_type']]);
            $formSet['fields_setting'] = $fieldsSetting;
        }
        return $result;
    }
}