yyky/application/admin/logic/HouseserverLogic.php

<?php
namespace app\admin\logic;

use app\admin\server\Webuserserver;
use app\common\model\houseservermodel;
use app\common\model\serverappointmentmodel;

class HouseserverLogic
{
    /**
     * 获取类型列表
     *
     * @return void
     * @author wj
     * @date 2023-01-18
     */
    public function gettypelist($arr)
    {
        $userinfo = checkToken();
        $wherefield = ['servername'];
        $where = [];
        foreach ($wherefield as $key => $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);
    }
}