public function reply($data)
{
$noticeid = $data["noticeid"];
if (empty($noticeid)) {
return Utils::WrapResultError("noticeid不能为空");
}
$files = isset($data["files"]) ? $data["files"] : '';
if (!empty($files) && is_array($files)) {
$files = implode(',', $files);
}
$sql = 'update im_pushnotice_memebr set receive_time=now() where noticeid=? and employeeid=? and receive_time is not null';
$sql1 = 'insert into im_pushnotice_msg(id,replyid,msg,created,us,msgid)values(?,?,?,now(),?,?)';
$replyid = SysSeq::GetSeqNextValue($this->conn_im, "im_pushnotice_msg", "id");
$sql = 'select count(1)+1 cnt from im_pushnotice_msg where replyid=?';
$ds = $this->conn_im->Getdata('t', $sql, array((int) $noticeid));
$cnt = $ds['t']['rows'][0]['cnt'];
$senddata = array();
$senddata = array('noticeid' => $noticeid, 'reply_count' => $cnt, 'reply' => array('id' => $replyid, 'nickname' => $this->user["nick_name"], 'photo' => $this->user["photo_path"], 'jid' => $this->user["jid"], 'text' => $data["reply-text"], 'files' => $files, 'sendtime' => date("Y-m-d H:i:s", time())));
$notice = array();
// Utils::WrapMessageNoticeinfo($data["reply-text"],$this->module["appname"],null,$this->module["logo"]);
$msg = Utils::WrapMessage('push-notice-reply', $senddata, $notice);
$msgxml = Utils::WrapMessageXml($this->module["jid"], $msg, 'push-notice-reply-' . $replyid);
$this->conn_im->ExecSQLs(array($sql, $sql1), array(array((int) $noticeid, (string) $this->user["jid"]), array((int) $replyid, (int) $noticeid, (string) json_encode($senddata['reply']), $this->user['jid'], 'push-notice-reply-' . $replyid)));
$noticeinfo = $this->getinfo($noticeid);
$receiver = $this->getmember($noticeid);
$receiver[] = $noticeinfo["us"];
Utils::findonlinejid($this->conn_im, $receiver);
if (!empty($receiver)) {
//发送消息
$presence = new \Justsy\OpenAPIBundle\Controller\ApiController();
$presence->setContainer($this->container);
$presence->sendMsg($this->module["jid"], $receiver, '通知回复', json_encode($msg));
}
return Utils::WrapResultOK(array('noticeid' => $noticeid));
}
public function setFriendByDept($deptid, $user = null)
{
//判断部门是否设置了自动好友
$deptinfo = $this->getInfo($deptid);
if ($deptinfo['friend'] != '1') {
return;
}
$da = $this->conn_im;
$friendLst = array();
$success = true;
$msg = "";
if (!empty($user)) {
$login_account = $user["login_account"];
$fafa_jid = array(isset($user["fafa_jid"]) ? $user["fafa_jid"] : null);
$staffMgr = new Staff($this->conn, $this->conn_im, $login_account, $this->container->get("logger"), $this->container);
if (empty($fafa_jid)) {
$user = $staffMgr->getInfo();
}
$friendLst = array(array("jid" => $user["fafa_jid"], "nick_name" => $user["nick_name"]));
} else {
$domain = $this->container->getParameter('edomain');
$staffMgr = new Staff($this->conn, $this->conn_im, "admin@" . $domain, $this->container->get("logger"), $this->container);
$sql = 'SELECT a.loginname jid,a.employeename nick_name FROM im_employee a where a.deptid=? and not exists(select jid from rosterdept where deptid=? and a.loginname=jid)';
$ds = $da->GetData("t", $sql, array((string) $deptid, (string) $deptid));
$friendLst = $ds["t"]["rows"];
}
$to_jid = array();
$staffcount = count($friendLst);
if ($staffcount == 0) {
return array("success" => false, "message" => '该部门下没有人员，请进入子部门进行设置');
}
for ($i = 0; $i < $staffcount; $i++) {
$fafa_jid = $friendLst[$i]["jid"];
$nick_name = $friendLst[$i]["nick_name"];
//判断是否已全部成为好友
$sql = "SELECT a.loginname jid,a.employeename nick_name FROM im_employee a where a.deptid=? and not exists (select jid from rosterusers b where a.loginname=b.jid and b.username=? and b.subscription='B')";
try {
$ds_member = $da->GetData("member", $sql, array((string) $deptid, (string) $fafa_jid));
if ($ds_member && count($ds_member["member"]["rows"] > 0)) {
if (!empty($user)) {
//如果是指定人员与部门人员成为好友，通知对象为部门中还未不是该人的帐号jid
for ($ic = 0; $ic < count($ds_member["member"]["rows"]); $ic++) {
array_push($to_jid, $ds_member["member"]["rows"][$ic]["jid"]);
}
}
$state = $staffMgr->DeptAddFriend($this->container, $deptid, $fafa_jid, $nick_name, $ds_member["member"]["rows"]);
}
} catch (\Exception $e) {
$success = false;
$msg = "设置部门人员互为好友出错！";
$this->container->get("logger")->err($e->getMessage());
return array("success" => $success, "message" => $msg);
}
}
$to_jid = $this->getStaffJid($deptid);
if (count($to_jid) > 0) {
//获取在线帐号
Utils::findonlinejid($da, $to_jid);
//向成员发送出席
$message = array('deptid' => $deptid);
$msg = json_encode(Utils::WrapMessage('dept_friend', $message, array()));
Utils::sendImPresence($fafa_jid, $to_jid, "dept_friend", $msg, $this->container, "", "", false, '', '0');
}
return array("success" => $success, "message" => $msg);
}
public function sendPresenceCirlce($circleid, $caption = "circle_addmember", $msg, $buttons = "", $excludeLst = null)
{
$sql = "select c.fafa_jid,c.login_account from we_circle_staff a,we_circle b,we_staff c where b.circle_id=a.circle_id and a.login_account=c.login_account and b.circle_id=? and c.fafa_jid is not null";
$da = $this->get("we_data_access");
$ds = $da->GetData("ims", $sql, array((string) $circleid));
$staffArr = array();
$len = count($ds["ims"]["rows"]);
for ($i = 0; $i < $len; $i++) {
if (!empty($excludeLst) && in_array($ds["ims"]["rows"][$i]["login_account"], $excludeLst)) {
continue;
}
$staffArr[] = $ds["ims"]["rows"][$i]["fafa_jid"];
}
$sender = $this->container->getParameter('im_sender');
$staffArr = null;
$onlinejid = Utils::findonlinejid($this->get("we_data_access_im"), $staffArr);
$jidArr = array();
$len = count($onlinejid);
for ($i = 0; $i < $len; $i++) {
$jidArr[] = $onlinejid[$i];
if ($i > 0 && $i % 5000 == 0) {
Utils::sendImPresence($sender, implode(",", $jidArr), $caption, $msg, $this->container, "", $buttons, false, Utils::$systemmessage_code);
$jidArr = array();
}
}
if (count($jidArr) > 0) {
Utils::sendImPresence($sender, implode(",", $jidArr), $caption, $msg, $this->container, "", $buttons, false, Utils::$systemmessage_code);
}
}
public function service_sendjid($micro_jid, $onlyonline = false)
{
$jids = array();
$sql = "select a.employeeid jid from im_microaccount_memebr a where a.microaccount=?;";
try {
$ds = $this->conn_im->GetData("table", $sql, array((string) $micro_jid));
$count = $ds["table"]["recordcount"];
if ($ds && $count > 0) {
foreach ($ds["table"]["rows"] as $key => $value) {
$jids[] = $value["jid"];
}
} else {
return array();
}
} catch (\Exception $e) {
$this->logger->err($e->getMessage());
}
!$onlyonline ? Utils::resortjid($this->conn_im, $jids) : Utils::findonlinejid($this->conn_im, $jids);
return $jids;
}