yuanchengpasc/application/common/library/Message.php

<?php

namespace app\common\library;

use think\Db;
use app\common\library\UUIDs;

/**
 * 结果整理类
 */
class Message {
    public static function read($id){
        DB::table('messages')->where('id',$id)->update(['is_read'=>1,'htime'=>date('Y-m-d H:i:s',time())]);
    }

    public static function get_messages(){

    }

    //  新增消息
    public static function insert($title,$content,$did,$type,$url,$count =1,$aid = ''){
        $info['id'] = UUIDs::uuid16();
        $info['title'] = $title;
        $info['content'] = $content;
        $info['doctor_id'] = $did;
        $info['type'] = $type;
        $info['ctime'] = date('Y-m-d H:i:s',time());
        $info['is_read'] = 0;
        $info['status'] = 0;
        $info['url'] = $url;
        $info['count'] = $count;
        $info['application_id'] = $aid;
        DB::table('messages')->insert($info);
    }

    // 获取跳转url
    public static function url($sessionid,$id,$is_remote,$exam_class,$report_id=''){
        $url = 'remotereport/edit/6?sessionid='.$sessionid.'&id='.$id.'&is_remote='.$is_remote.'&exam_class='.$exam_class.'&report_id='.$report_id;
        return $url;
    }

    // 消息未读条数自增
    public static function bbs_message($aid,$doctor,$content,$did,$is_remote,$sessionid){
        $message = DB::table('messages')->where('application_id',$aid)->where('doctor_id',$doctor)->where('is_read',0)->find();
        if($message){
            Db::table('messages')->where('application_id',$aid)->where('doctor_id',$doctor)->where('is_read',0)->setInc('count');
        }else{
            $title = '您收到一条远程诊断咨询消息';
            $type = '远程诊断对话';
            $application = DB::table('remote_application')->where('id',$aid)->find();
            $exam = DB::table('exams')->where('id',$application['exam_id'])->field('exam_class')->find();
            $report = DB::table('report')->where('remote_application_id',$aid)->field('id')->find();
            $url = self::url($sessionid,$application['exam_id'],$is_remote,$exam['exam_class'],$report['id']);
            self::insert($title,$content,$did,$type,$url,$count =1,$aid);
        }

    }

    public static function delete($id){

    }
}