watercat_web/application/index/logic/trainsignuserlogic.php

<?php
/*
 * @Author: wang jun
 * @Date: 2021-10-29 16:16:29
 * @Last Modified by: wang jun
 * @Last Modified time: 2021-12-30 10:20:43
 */
namespace app\index\logic;

use app\index\model\trainmodel;
use app\index\model\trainsignusermodel;
use app\index\model\userinfomodel;

class trainsignuserlogic
{
    /**
     * 新增培训
     * 20211224
     * wj
     */
    public function newinfo($info)
    {
        $fillField = ['userid', 'tid'];
        foreach ($fillField as $key => $value) {
            if (!isset($info[$value]) || empty($info[$value]) || !is_numeric($info[$value])) {
                return backarr(0, "请求失败");
            }
        }
        $userid = $info['userid'];
        $tid = $info['tid'];
        $m_t = new trainmodel();
        $m_tu = new trainsignusermodel();
        $m_u = new userinfomodel();
        $tuwhere = [
            'userid' => $userid,
            'tid' => $tid,
            'status' => 1,
        ];
        $tuinfo = $m_tu->getInfo($tuwhere, 'id');
        if (!empty($tuinfo)) {
            return backarr(0, "已报名");
        }
        $uwhere = [
            'id' => $userid,
        ];
        $uinfo = $m_u->getInfo($uwhere);
        if (empty($uinfo)) {
            return backarr(0, "无用户");
        }
        $twhere = [
            'id' => $tid,
        ];
        $tinfo = $m_t->getInfo($twhere);
        if (empty($tinfo)) {
            return backarr(0, "无培训信息");
        }
        if (!empty($tinfo['starttime']) || !empty($tinfo['endtime'])) {
            if ($tinfo['starttime']) {
                if (time() < strtotime($tinfo['starttime'])) {
                    return backarr(0, "非可报名时间段");
                }
            }
            if ($tinfo['endtime']) {
                if (time() > strtotime($tinfo['endtime'])) {
                    return backarr(0, "非可报名时间段");
                }
            }
        }
        $count = $m_tu->getList($tuwhere, 'count');
        if ($count >= $tinfo['maxpersion']) {
            return backarr(0, "已招满");
        }
        if (!isset($info['createtime']) || empty($info['createtime'])) {
            $info['createtime'] = date('Y-m-d H:i:s', time());
        }
        $id = $m_tu->insertData($info);
        if (!$id) {
            return backarr(0, "操作失败");
        }
        return backarr(1, "操作成功", ['id' => $id]);
    }

    /**
     * 获取信息根据userid
     * 20211224
     * wj
     */
    public function getinfobyuserid($arr)
    {
        if (!isset($arr['userid']) || empty($arr['userid'])) {
            return backarr(0, "请求失败");
        }
        $userid = $arr['userid'];
        $m_tu = new trainsignusermodel();
        $where = ['userid' => $userid, 'status' => 1];
        $cinfo = $m_tu->getInfo($where);
        if (empty($cinfo)) {
            return backarr(0, "无数据");
        }
        return backarr(1, "操作成功", $cinfo);
    }

    /***
     * 获取列表 按userid查询 按id倒序
     * 20211224
     * wj
     */
    public function getlistbyuserid($arr)
    {
        if (!isset($arr['userid']) || empty($arr['userid']) && !is_numeric($arr['userid'])) {
            return backarr(0, "请求失败");
        }
        $userid = $arr['userid'];
        $m_tu = new trainsignusermodel();
        $m_t = new trainmodel();
        $where = ['userid' => $userid];
        if (isset($arr['status']) && is_numeric($arr['status']) && in_array($arr['status'], [0, 1])) {
            $where['status'] = $arr['status'];
        }
        $page = isset($arr['page']) && !empty($arr['page']) ? $arr['page'] : 1;
        $size = isset($arr['size']) && !empty($arr['size']) ? $arr['size'] : 10;
        $count = $m_tu->getList($where, 'count');
        if ($count <= 0) {
            return backarr(0, "无数据");
        }
        $list = $m_tu->getList($where, '*', $page, $size);
        foreach ($list as $key => &$value) {
            $tinfo = $m_t->getInfo(['id' => $value['tid']], 'name');
            if (empty($tinfo)) {
                $list[$key]['name'] = '';
            } else {
                $list[$key]['name'] = $tinfo['name'];
            }
        }
        return backarr(1, "查询成功", $list);
    }
    /**
     * 修改status根据id 1报名 0取消报名
     * 20211224
     * wj
     */
    public function updatestatusbyid($arr)
    {
        if (!isset($arr['id']) || empty($arr['id']) || !isset($arr['status']) || !in_array($arr['status'], [0, 1])) {
            return backarr(0, "请求失败");
        }
        $id = $arr['id'];
        $status = $arr['status'];
        $m_tu = new trainsignusermodel();
        $where = ['id' => $id];
        $tuinfo = $m_tu->getInfo($where);
        if (empty($tuinfo)) {
            return backarr(0, "无数据");
        }
        $updateData = [];
        if ($status != $tuinfo['status']) {
            $updateData['status'] = $status;
        }
        if (empty($updateData)) {
            return backarr(0, "无修改数据");
        }
        $row = $m_tu->updateinfo($where, $updateData);
        if (!$row) {
            return backarr(0, "操作失败");
        }
        return backarr(1, "操作成功", ['id' => $id]);
    }
}