$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]); } }