聊天列表

//聊天记录列表    function chat_list()    {//        $user_id = $_POST['send_man'];        //聊天记录        $chat_log = M('chat_log');        //请求传入的参数（当前用户）        $id = $chat_log->create();        $user_id = $id['send_man'];        //用户信息        $user_info = M('user_info');        //取出当前用户的联系人及与每个联系人的最后聊天时间        $sqlString = "select contact, max(time) as max_time from " .            "((select content,send_man as contact,time from lswoa_chat_log where receive_man=$user_id and (group_chat is null or group_chat='')) " .            "UNION " .            "(select content,receive_man as contact,time from lswoa_chat_log where send_man=$user_id and (group_chat is null or group_chat=''))) as chat_contact " .            "GROUP BY contact " .            "ORDER BY max_time DESC";        $chat_list = $chat_log->query($sqlString);        $chat_staff = M('chat_group_staff');        $chatmap['staff'] = $user_id;        $chatmap['status'] = 1;        //取出用户所在群组ID        $res_chat_staff = $chat_staff->where($chatmap)->field("chat_group_id")->select();        //群聊        if ($res_chat_staff) {            foreach ($res_chat_staff as $chatk => $chatv) {                $group_id[] = $chatv['chat_group_id'];            }            //用户所在群ID            $group_id_str = implode(',', $group_id);            //群聊天记录            $logres = "select *,max(time) as max_time from lswoa_chat_log where group_chat in(" . $group_id_str . ") GROUP BY group_chat order by max_time desc";            $lres = M()->query($logres);            foreach ($lres as $lok => $lov) {                $mapsta['chat_group_id'] = $lov['group_chat'];                $chat_li['cy'] = $chat_staff->where($mapsta)->field('staff')->select();                $group_name = M('chat_group')->where('id=' . $lov['group_chat'])->find();                $chat_li['group_chat'] = $lov['group_chat'];                //群名称                $chat_li['group_name'] = $group_name['name'];                //群好友id                $mapstaff['id'] = $lov['send_man'];                //群聊天内容                $chat_li['content'] = $lov['content'];                //查找该联系人（好友）信息                $user = $user_info->where($mapstaff)->find();                //取出姓名                $chat_li['name'] = $user['name'];                //最后聊天时间                $chat_li['max_time'] = $lov['max_time'];                //是否群聊                $chat_li['is_group'] = '1';                //头像                $chat_li['head_protrait'] = 'http://' . $_SERVER['HTTP_HOST'] . __ROOT__ . $user['head_protrait'];                //未读消息条数                $not_read_count = "select COUNT(*) as nr_count from lswoa_chat_log WHERE lswoa_chat_log.group_chat = " . $lov['group_chat'] . " and lswoa_chat_log.send_man != $user_id and lswoa_chat_log.id not in (select lswoa_chat_log_read.chat_log_id from lswoa_chat_log_read WHERE receive_man = " . $user_id . ")";                $not_read_count_res = M()->query($not_read_count);                $chat_li['not_read_count'] = $not_read_count_res[0]['nr_count'];                $list['list']['chat'][] = $chat_li;            }        }        //私聊        if ($chat_list) {            //取出该条聊天记录对应的聊天内容和用户信息            foreach ($chat_list as $key => $value) {                //联系人（好友）                $contact = $value['contact'];                //最后聊天时间                $max_time = $value['max_time'];                //聊天记录的查找条件                $map_chat_log["send_man"] = $contact;                $map_chat_log["receive_man"] = $user_id;                $map_chat_log["time"] = $max_time;                //用户信息的查找条件                $map_user_info["id"] = $contact;                //查找该条聊天信息                $chat_info = $chat_log->where($map_chat_log)->find();                if (!$chat_info) {                    //置换聊天记录的查找条件中的发送与接受方                    $map_chat_log["receive_man"] = $contact;                    $map_chat_log["send_man"] = $user_id;                    //查找该条聊天信息                    $chat_info = $chat_log->where($map_chat_log)->find();                }                //取出其聊天内容                $chat_list[$key]['content'] = $chat_info['content'];                //查找该联系人（好友）信息                $user = $user_info->where($map_user_info)->find();                //取出姓名                $chat_list[$key]['name'] = $user['name'];                //最后聊天时间                $chat_list[$key]['max_time'] = $max_time;                //是否群聊                $chat_list[$key]['is_group'] = '0';                //头像                $chat_list[$key]['head_protrait'] = 'http://' . $_SERVER['HTTP_HOST'] . __ROOT__ . $user['head_protrait'];                //未读消息条数                $not_read_count = "select COUNT(*) as nr_count from lswoa_chat_log WHERE (lswoa_chat_log.send_man = " . $contact . " and lswoa_chat_log.receive_man = " . $user_id . ") and (lswoa_chat_log.group_chat is null or lswoa_chat_log.group_chat='') and lswoa_chat_log.id not in (select lswoa_chat_log_read.chat_log_id from lswoa_chat_log_read WHERE receive_man = " . $user_id . ")";                $not_read_count_res = M()->query($not_read_count);                $chat_list[$key]['not_read_count'] = $not_read_count_res[0]['nr_count'];            }            foreach ($chat_list as $k => $v) {                //在聊天列表中按照max_time进行倒序排序                $size = count($list['list']['chat']);                for ($i=0; $i<=$size; $i++) {                    if ($list['list']['chat'][$i]['max_time'] < $v['max_time']) {                        array_splice($list['list']['chat'], $i, 0, array($v));                        break;                    }                }            }            $code = array('code' => 1, 'message' => '请求成功');            $this->ajaxReturn(array_merge($code, $list));        } else {            $code = array('code' => 2, 'message' => '请求失败');            $this->ajaxReturn($code);        }    }    //聊天记录详情    function chat_content()    {        $group_chat = $_POST['group_chat'];        $send_man = $_POST['send_man'];        $receive_man = $_POST['contact'];        if (!empty($group_chat)) {            //群组            $chat_log = M('chat_log');//                    $map['send_man'] = $send_man;            $map['group_chat'] = $group_chat;            $res = $chat_log->where($map)->order('time')->select();            $group_staff = M('chat_group_staff');            $comap['lswoa_chat_group_staff.chat_group_id'] = $group_chat;            $comap['lswoa_chat_group_staff.status'] = 1;            $head = $group_staff->where($comap)->join('LEFT JOIN lswoa_user_info ON lswoa_user_info.id=lswoa_chat_group_staff.staff')->field('lswoa_user_info.id,lswoa_user_info.name,lswoa_user_info.head_protrait')->select();            if ($res) {                //读出的信息如果没有写入已读数据表则写入                $sql_insert = "insert into lswoa_chat_log_read(chat_log_id,receive_man,read_time) select id,'".$send_man."' as receive_man,now() from lswoa_chat_log where group_chat=$group_chat and id not in (select chat_log_id from lswoa_chat_log_read)";                $Model = new \Think\Model();                $Model->execute($sql_insert);                foreach ($head as $k => $v) {                    $v['head_protrait'] = 'http://' . $_SERVER['HTTP_HOST'] . __ROOT__ . $v['head_protrait'];                    $list['list']['man'][] = $v;                }                foreach ($res as $ke => $ve) {                    $list['list']['chat_content'][] = $ve;                }                $code = array('code' => 1, 'message' => '请求成功');                $this->ajaxReturn(array_merge($code, $list));            } else {                $code = array('code' => 2, 'message' => '请求失败');                $this->ajaxReturn($code);            }        } else {            //私聊            $sql = "select id,content,send_man,receive_man,time from lswoa_chat_log where (send_man=$send_man and receive_man=$receive_man) or (send_man=$receive_man and receive_man=$send_man) ORDER BY time";            $res = M()->query($sql);            $user_info = M('user_info');            $condition['id'] = $receive_man;            $head = $user_info->where($condition)->field('id,name,head_protrait')->select();            //读出的信息如果没有写入已读数据表则写入            $sql_insert = "insert into lswoa_chat_log_read(chat_log_id,receive_man,read_time) select id,receive_man,now() from lswoa_chat_log where receive_man=$send_man and send_man=$receive_man and id not in (select chat_log_id from lswoa_chat_log_read)";            $Model = new \Think\Model();            $Model->execute($sql_insert);            if ($res) {                foreach ($head as $key => $val) {                    $val['head_protrait'] = 'http://' . $_SERVER['HTTP_HOST'] . __ROOT__ . $val['head_protrait'];                    $list['list']['man'][] = $val;                }                foreach ($res as $k => $v) {                    $list['list']['chat_content'][] = $v;                }                $code = array('code' => 1, 'message' => '请求成功');                $this->ajaxReturn(array_merge($code, $list));            } else {                $code = array('code' => 2, 'message' => '请求失败');                $this->ajaxReturn($code);            }        }    }