zyedu/application/wap/model/user/UserNotice.php

<?php
// +----------------------------------------------------------------------
// | CRMEB [ CRMEB赋能开发者，助力企业发展 ]
// +----------------------------------------------------------------------
// | Copyright (c) 2016～2022 https://www.crmeb.com All rights reserved.
// +----------------------------------------------------------------------
// | Licensed CRMEB并不是自由软件，未经许可不能去掉CRMEB相关版权
// +----------------------------------------------------------------------
// | Author: CRMEB Team <admin@crmeb.com>
// +----------------------------------------------------------------------


namespace app\wap\model\user;

use app\admin\model\user\UserNoticeSee;
use traits\ModelTrait;
use basic\ModelBasic;

/**
 * 用户通知 model
 * Class UserNotice
 */
class UserNotice extends ModelBasic
{
    use ModelTrait;

    public static function getNotice($uid)
    {
        $count_notice = self::where('uid', 'like', "%,$uid,%")->where("is_send", 1)->count();
        $see_notice = UserNoticeSee::where("uid", $uid)->count();
        return $count_notice - $see_notice;
    }

    /**
     * @return array
     */
    public static function getNoticeList($uid, $page, $limit = 8)
    {
        //定义分页信息
        $count = self::where('uid', 'like', "%,$uid,%")->count();
        $data["lastpage"] = ceil($count / $limit) <= ($page + 1) ? 1 : 0;

        $where['uid'] = array("like", "%,$uid,%");
        $where['is_send'] = 1;
        $list = self::where($where)->field('id,user,title,content,add_time')->order("add_time desc")->limit($page * $limit, $limit)->select()->toArray();
        foreach ($list as $key => $value) {
            $list[$key]["add_time"] = date("Y-m-d H:i:s", $value["add_time"]);
            $list[$key]["is_see"] = UserNoticeSee::where("uid", $uid)->where("nid", $value["id"])->count() > 0 ? 1 : 0;
        }
        $data["list"] = $list;
        return $data;
    }

    /**
     * @return array
     */
    public static function seeNotice($uid, $nid)
    {
        if (UserNoticeSee::where("uid", $uid)->where("nid", $nid)->count() <= 0) {
            $data["nid"] = $nid;
            $data["uid"] = $uid;
            $data["add_time"] = time();
            UserNoticeSee::set($data);
        }
    }
}