ProjectViewData.php 7.0 KB
<?php

namespace app\school\controller\project_common;

use app\school\model\basic\User;
use app\school\model\setting\ProjectFormSet;
use think\Db;

trait ProjectViewData
{
    /**
     * 返回项目报名数据
     * @param $projectId
     * @return array
     */
    private function signUpData($projectId)
    {
        $rowFields = ['a.id,
                        a.user_id,
                        a.project_type,
                        a.project_college,
                        a.project_details,
                        a.project_des,
                        a.project_endtime,
                        a.project_lv1_subject,
                        a.project_lv2_subject,
                        a.project_name,
                        a.project_source,
                        a.project_starttiem,
                        a.declaration_attachment,
                        a.mid_attachment,
                        a.conclusion_attachment,
                        a.custom_form_data,
                        u.student_no, u.username, u.mobile, u.college, u.specialty, u.entry_year, u.email'];
        // 项目报名信息
        $row = $this->model
            ->alias('a')
            ->field($rowFields)
            ->join('fa_user u', 'a.user_id = u.id', 'left')
            ->where(['a.id' => $projectId])
            ->find();

        return $row;
    }

    /**
     * 返回各个表单(非新增表单)自定义的表单项
     * @param $projectTypeId
     * @return array
     */
    private function extraFormSets($projectTypeId)
    {
        $formSets = (new ProjectFormSet())->where(['project_type_id' => $projectTypeId, 'stage_type' => ['<>', 'default']])->column('fields_setting', 'stage_type');
        return $this->formatterFormSets($formSets);
    }

    /**
     * 返回各个表单(新增表单,类型为default)自定义的表单项
     * @param $projectTypeId
     * @return array
     */
    private function extraNewFormSets($projectTypeId)
    {
        $newFormSets = [];
        $formSets = (new ProjectFormSet())->where(['project_type_id' => $projectTypeId, 'stage_type' => 'default'])->column('id, fields_setting');
        foreach ($formSets as $v) {
            $newFormSets['default_' . $v['id']] = $v['fields_setting'];
        }
        return $this->formatterFormSets($newFormSets);
    }

    /**
     * 收集表单的自定义字段
     * @param array $formSets 格式为 [ 表单类型 => 表单字段设置json ]的数组
     * @return array
     */
    private function formatterFormSets($formSets = [])
    {
        $result = [];
        foreach ($formSets as $formName => $formSet) {
            $formSet = json_decode($formSet, true);
            foreach ($formSet as $item) {
                // 新增的表单项以 _name_ 开头
//                if (strstr($item['name'], '_name_')) {
                    $options = [];
                    // 如果有选项,将选项格式修改为 key: value
                    if (isset($item['data'])) {
                        foreach ($item['data'] as $v) {
                            $options[$v['value']] = $v['label'];
                        }
                    }

                    $result[$formName][$item['name']] = [
                        'title' => $item['title'],
                        'type' => $item['type'],
                        'required' => $item['required'],
                        'options' => $options,
                        'name'      => $item['name'],
                        'mimeType'  => (isset($item['mimeType']) && !empty($item['mimeType'])) ? implode(',',$item['mimeType']) : '',
                        'size'  => (isset($item['size'])) ? $item['size'].'M' : '',
                        'file_key'  => (isset($item['file_key'])) ? $item['file_key'] : '',
                    ];
//                }
            }
        }
        return $result;
    }

    /**
     * 给表单的自定义项关联对应的值
     * @param array $extraFormSets 各表单自定义表单项数组
     * @param json $formFieldsValueArr 各表单自定义表单项键值对json数据
     * @return array
     */
    private function setExtraFormItemsValue($extraFormSets = [], $formFieldsValueArr = '{}')
    {
        $arr = json_decode($formFieldsValueArr,true);
        foreach ($extraFormSets as $formType => &$v) {
            $formValueArr = isset($arr[$formType]) ? $arr[$formType] : [];
            foreach ($v as $name => &$val) {
                $val['value'] = isset($formValueArr[$name]) ? $formValueArr[$name] : '';
            }
        }
        return $extraFormSets;
    }

    /**
     * 返回项目详细信息数据
     * @param $projectId 项目id
     * @return array
     */
    private function detailsData($id)
    {
        // 项目详情
        $details = Db::name('project_register_details')->where(['id' => $id])->value('project_details');
        $details = json_decode($details, true);
        $detailsFields = ['apply_reason',
            'project_purpose',
            'project_content',
            'project_conditions',
            'project_plan',
            'school_support',
            'expected_results',
            'project_budget',
            'declaration'];
        // 项目详情设置默认值
        foreach ($detailsFields as $field) {
            if (empty($details[$field])) {
                $details[$field] = '';
            }
        }
        return $details;
    }

    /**
     * 返回项目成员数据
     * @param $projectId
     * @return array
     */
    private function membersData($projectId)
    {
        $rows = [];
        $membersJson = $this->model->where('id', $projectId)->value('project_members');
        $members = json_decode($membersJson, true);

        if (0 !== count((array)$members)) {
            $rowsFields = ['id, student_no, college, specialty, username,nickname,entry_year,gender,school_id,clazz'];
            $rows = (new User())
                ->alias('a')
                ->field($rowsFields)
                ->where(['id' => ['IN', array_keys($members)]])
                ->select();

            foreach ($rows as &$v) {
                $member = $members[$v['id']];
                $v['mobile'] = $member['mobile'];
                $v['email'] = $member['email'];
            }
        }

        return $rows;
    }


    /**
     * 返回项目指导教师数据
     * @param $projectId
     * @return array
     */
    private function teachersData($projectId)
    {
        $rows = [];
        $teachersJson = $this->model->where('id', $projectId)->value('project_teachers');
        $teachers = json_decode($teachersJson, true);

        if (0 !== count((array)$teachers)) {
            $rows = Db::name('teacher')
                ->alias('a')
                ->where(['id' => ['IN', array_keys($teachers)]])
                ->select();

            foreach ($rows as &$v) {
                $teacher = $teachers[$v['id']];
                $v['mobile'] = isset($teacher['mobile']) ? $teacher['mobile'] : '';
                $v['main_results'] = $teacher['main_results'];
            }
        }

        return $rows;
    }

}