Project.php 6.1 KB
<?php

namespace app\school\controller;

use app\common\controller\ManystoreBase;
use app\school\model\project_common\ProjectRegister;
use app\school\model\setting\ProjectContainer;
use app\school\model\setting\ProjectType;
use think\Db;

class Project extends ManystoreBase
{

    protected $noNeedRight = ['*'];

    protected $projectContainerModel = null;

    public function _initialize()
    {
        parent::_initialize();
        $this->projectContainerModel = new ProjectContainer();
    }

    public function index() {
        if ($this->request->isAjax()) {
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();

            $containerFields = ['id, container_name, project_year'];
            $total = $this->projectContainerModel->where($where)->count();
            $containers = $this->projectContainerModel->field($containerFields)->order('id desc')->where($where)->limit($offset, $limit)->select();

            $containerIds = array_map(function ($container) {
                return $container['id'];
            }, $containers);




            $projectFields = 'a.container_id, a.project_type, a.project_members, a.project_teachers, b.name project_type_name';
            $projects = collection((new ProjectRegister())
                ->alias('a')
                ->field($projectFields)
                ->join('fa_project_type b', 'a.project_type = b.id', 'left')
                ->where([ 'a.container_id' => ['IN', $containerIds] ])
                ->select())->toArray();

            // 各个项目容器下的项目类型
            $projectTypeFields = 'GROUP_CONCAT(id, \'__\' ,name SEPARATOR \'_,_\')';
            $projectTypes = (new ProjectType())->where([ 'container_id' => ['IN', $containerIds] ])->group("container_id")->column($projectTypeFields, 'container_id');

            // 计算各个项目类型的报名情况(报名组数、报名人数、教师人数)
            $projectRegisterDetails = [];
            // 整个项目的报名情况
            $containerAllRegisterDetails = [];

            foreach ($containerIds as $id) {
                if (!isset($projectTypes[$id])) continue;
                $_projectTypes = explode('_,_', $projectTypes[$id]);
                foreach ($_projectTypes as $v) {
                    $tempTypeData = explode('__', $v);
                    $projectRegisterDetails[$id][$tempTypeData[0]] = [
                        'project_type_name' => $tempTypeData[1],
                        'group_num' => 0,
                        'student_num' => 0,
                        'teacher_num' => 0
                    ];
                }

                $containerAllRegisterDetails[$id] = [
                    'group_num' => 0,
                    'student_num' => 0,
                    'teacher_num' => 0
                ];
            }
            foreach ($projects as $project) {
                // dump($project);die;
                // 项目的报名情况
                $projectRegisterDetail = &$projectRegisterDetails[$project['container_id']];
                // 计算出的报名人数数据
                $registerDetail = $this->getRegisterDetail($project);

                // 报名已删除项目类型的项目,不加入计数
                if ( empty($projectRegisterDetail[$project['project_type']]) ) continue;

                // 更新某项目类型的报名情况
                $registerTypeDetail = &$projectRegisterDetail[$project['project_type']];
                $registerTypeDetail['group_num']++;
                $registerTypeDetail['student_num'] += $registerDetail['student_num'];
                $registerTypeDetail['teacher_num'] += $registerDetail['teacher_num'];

                // 更新项目容器的报名情况
                $containerAllRegisterDetails[$project['container_id']]['group_num']++;
                $containerAllRegisterDetails[$project['container_id']]['student_num'] += $registerDetail['student_num'];
                $containerAllRegisterDetails[$project['container_id']]['teacher_num'] += $registerDetail['teacher_num'];
            }



            // 给项目容器添加项目报名数据
            foreach ($containers as &$container) {
                if (!isset($projectRegisterDetails[$container['id']])) continue;
                // 项目下各项目类型的报名情况
                $container['details'] = $projectRegisterDetails[$container['id']];
                // 整个项目的报名情况
                $containerAllRegisterDetail = $containerAllRegisterDetails[$container['id']];
                $container['group_num'] = $containerAllRegisterDetail['group_num'];
                $container['student_num'] = $containerAllRegisterDetail['student_num'];
                $container['teacher_num'] = $containerAllRegisterDetail['teacher_num'];
            }

            $res = [
                'total' => $total,
                'rows'   => $containers
            ];
            return $res;
        }

        return $this->fetch();
    }

    /**
     * 删除项目(软删除)
     */
    public function del($ids = "")
    {
        $info = Db::name("project_register")->where(['container_id'=>$ids])->find();
        if($info){
            $this->error("该项目下产生了数据,不能删除");
        }
        if ($ids) {
            Db::startTrans();
            try {
                $this->projectContainerModel->get($ids)->delete();
                Db::commit();
            } catch (Exception $e) {
                Db::rollback();
                $this->error($e->getMessage());
            }
            $this->success('删除成功');
        }
        $this->error(__('Parameter %s can not be empty', 'ids'));
    }

    /**
     * 根据传入的项目报名数据,返回该项目的学生人数和教师人数
     * @param $project
     * @return array
     */
    private function getRegisterDetail($project)
    {
        $res['student_num'] = count( (array)json_decode($project['project_members']) );
        $res['teacher_num'] = count( (array)json_decode($project['project_teachers']) );
        $res['project_type_name'] = $project['project_type_name'];
        return $res;
    }
}