$value) { if (isset($arr[$value]) && !empty($arr[$value])) { $where[] = [$value, 'like', '%' . $arr[$value] . '%']; } } $wherefield2 = ['isactive']; foreach ($wherefield2 as $key => $value) { if (isset($arr[$value]) && is_numeric($arr[$value])) { $where[] = [$value, '=', $arr[$value]]; } } $page = isset($arr['page']) && is_numeric($arr['page']) && !empty($arr['page']) && $arr['page'] > 0 ? $arr['page'] : 1; $size = isset($arr['size']) && is_numeric($arr['size']) && !empty($arr['size']) && $arr['size'] > 0 ? $arr['size'] : 10; $m_hs = new houseservermodel(); $count = $m_hs->getList($where, "count", $page, $size); if ($count <= 0) { return backarr(0, "无数据"); } $totalpage = ceil($count / $size); $page > $totalpage && $page = $totalpage; $list = $m_hs->getList($where, "*", $page, $size)->toArray(); $data = [ 'page' => $page, 'size' => $size, 'count' => $count, 'list' => $list, ]; return backarr(1, "查询成功", $data); } /** * 新建类型 * * @return void * @author wj * @date 2023-01-18 */ public function newtype($arr) { $userinfo = checkToken(); $fillfields = ['servername']; foreach ($fillfields as $key => $value) { if (!isset($arr[$value]) || empty($arr[$value])) { return backarr(0, "参数缺少"); } } $servername = $arr['servername']; $m_hs = new houseservermodel(); $hsinfo = $m_hs->getInfo(['servername' => $servername]); if (!empty($hsinfo)) { return backarr(0, "服务已存在"); } $hsid = $m_hs->insertData($arr); if (empty($hsid)) { return backarr(0, "添加失败"); } //保存日志 $s_w = new Webuserserver(); $logData = [ 'node' => '创建服务类型:' . $hsid . ":" . $servername, 'type' => 1, 'tablename' => 'houseserver', 'refid' => $hsid, ]; $s_w->savelog($userinfo['id'], $logData); return backarr(1, "操作成功", ['hsid' => $hsid]); } /** * 编辑类型 * * @return void * @author wj * @date 2023-01-19 */ public function edittype($arr) { $userinfo = checkToken(); $fillfields = ['servername', 'id', 'sprice']; foreach ($fillfields as $key => $value) { if (!isset($arr[$value]) || empty($arr[$value])) { return backarr(0, "参数缺少"); } } $servername = $arr['servername']; $id = $arr['id']; $sprice = $arr['sprice']; $m_hs = new houseservermodel(); $hsinfo = $m_hs->getInfo(['id' => $id]); if (empty($hsinfo)) { return backarr(0, "无数据"); } $updateData = []; if ($hsinfo['servername'] != $servername) { $hssninfo = $m_hs->getInfo(['servername' => $servername]); if (!empty($hssninfo)) { return backarr(0, "服务已存在"); } $updateData['servername'] = $servername; } if ($hsinfo['sprice'] != $sprice) { $updateData['sprice'] = $sprice; } if (isset($arr['hserverphoto']) && !empty($arr['hserverphoto'])) { $hserverphoto = $arr['hserverphoto']; if ($hsinfo['hserverphoto'] != $hserverphoto) { $updateData['hserverphoto'] = $hserverphoto; } } $row = $m_hs->updateinfo(['id' => $id], $updateData); if (empty($row)) { return backarr(0, "修改失败"); } //保存日志 $s_w = new Webuserserver(); $logData = [ 'node' => '修改服务类型:' . $id, 'type' => 1, 'tablename' => 'houseserver', 'refid' => $id, ]; $s_w->savelog($userinfo['id'], $logData); return backarr(1, "操作成功", ['hsid' => $id]); } /** * 改类型有效 * * @return void * @author wj * @date 2023-01-19 */ public function updateisactive($arr) { $userinfo = checkToken(); $fillfields = ['isactive', 'id']; foreach ($fillfields as $key => $value) { if (!isset($arr[$value])) { return backarr(0, "参数缺少"); } } $id = $arr['id']; $isactive = $arr['isactive']; $where = [['id', '=', $id]]; if ($isactive == 1) { $where[] = ['isactive', 'in', [0]]; } else { $where[] = ['isactive', 'in', [1]]; } $m_hs = new houseservermodel(); $hsinfo = $m_hs->getInfo($where); if (empty($hsinfo)) { return backarr(0, "无数据"); } $updateData = ['isactive' => $isactive]; $row = $m_hs->updateinfo(['id' => $id], $updateData); if (empty($row)) { return backarr(0, "修改失败"); } //保存日志 $s_w = new Webuserserver(); $logData = [ 'node' => '修改服务类型可用:' . $id . ":" . $isactive, 'type' => 1, 'tablename' => 'houseserver', 'refid' => $id, ]; $s_w->savelog($userinfo['id'], $logData); return backarr(1, "操作成功", ['hsid' => $id]); } /** * 获取预定列表 * * @return void * @author wj * @date 2023-01-19 */ public function getappointmentlist($arr) { $userinfo = checkToken(); $wherefield = ['orderno', 'receiver_address']; $where = []; foreach ($wherefield as $key => $value) { if (isset($arr[$value]) && !empty($arr[$value])) { $where[] = [$value, 'like', '%' . $arr[$value] . '%']; } } $wherefield2 = ['serverid', 'paystatus', 'serverstatus']; foreach ($wherefield2 as $key => $value) { if (isset($arr[$value]) && is_numeric($arr[$value])) { $where[] = [$value, '=', $arr[$value]]; } } $page = isset($arr['page']) && is_numeric($arr['page']) && !empty($arr['page']) && $arr['page'] > 0 ? $arr['page'] : 1; $size = isset($arr['size']) && is_numeric($arr['size']) && !empty($arr['size']) && $arr['size'] > 0 ? $arr['size'] : 10; $m_hs = new houseservermodel(); $m_sa = new serverappointmentmodel(); $count = $m_sa->getList($where, "count", $page, $size); if ($count <= 0) { return backarr(0, "无数据"); } $totalpage = ceil($count / $size); $page > $totalpage && $page = $totalpage; $list = $m_sa->getList($where, "*", $page, $size)->toArray(); foreach ($list as $key => $value) { $hsinfo = $m_hs->getInfo(['id' => $value['serverid']], ['servername']); if (empty($hsinfo)) { $value['servername'] = ''; } else { $value['servername'] = $hsinfo['servername']; } $list[$key] = $value; } $data = [ 'page' => $page, 'size' => $size, 'count' => $count, 'list' => $list, ]; return backarr(1, "查询成功", $data); } }