if ($b) {
$da->ExecSQLs($sqls, $paras);
return new Response("1");
} else {
return new Response("0");
}
} catch (\Exception $e) {
$logger = $this->get('logger')->err($e);
return new Response("0");
}
}
public function applyCancelAction($groupid)
{
$da = $this->get("we_data_access");
$user = $this->get('security.context')->getToken()->getUser();
$apply = new \Justsy\BaseBundle\Management\ApplyMgr($da, null);
$apply->SetGroupApplyInvalid($user->GetUserName(), $groupid);
$re = array();
$re["success"] = "1";
$response = new Response(json_encode($re));
$response->headers->set('Content-Type', 'text/json');
return $response;
}
//申请加入群组
public function applyJoinGroupAction()
{
$da = $this->get("we_data_access");
$user = $this->get('security.context')->getToken()->getUser();
$group_id = $this->get('request')->request->get('group_id');
$group_name = $this->get('request')->request->get('group_name');
$create_staff = $this->get('request')->request->get('create_staff');
$network_domain = $this->get('request')->request->get('network_domain');
//判断加入群组数是否超过了限制
$ec = new \Justsy\BaseBundle\Management\EnoParamManager($da, $this->get('logger'));
if ($ec->IsBeyondJoinGroup($user->getUserName())) {
return new Response("-2");
public function creategroupAction()
{
$re = array("returncode" => ReturnCode::$SUCCESS);
$user = $this->get('security.context')->getToken()->getUser();
$request = $this->getRequest();
$circleid = $request->get("circle_id");
$groupname = $request->get("group_name");
$groupdesc = $request->get("group_desc");
$joinmethod = $request->get("join_method", "0");
$groupclassid = $request->get("group_class_id");
$invitedmemebers = $request->get("invitedmemebers");
$group_photo_path = $request->get("group_photo_path");
$da = $this->get('we_data_access');
$da_im = $this->get('we_data_access_im');
$ec = new \Justsy\BaseBundle\Management\EnoParamManager($da, $this->get('logger'));
try {
if ($ec->IsBeyondCreateGroup($user->getUserName())) {
$re["returncode"] = ReturnCode::$SYSERROR;
$re["error"] = "创建群组数量已超过限制！";
$response = new Response($request->get('jsoncallback') ? $request->get('jsoncallback') . "(" . json_encode($re) . ");" : json_encode($re));
$response->headers->set('Content-Type', 'text/json');
return $response;
}
if (empty($circleid) || empty($groupname)) {
$re["returncode"] = ReturnCode::$SYSERROR;
$re["error"] = "参数传递错误！";
$response = new Response($request->get('jsoncallback') ? $request->get('jsoncallback') . "(" . json_encode($re) . ");" : json_encode($re));
$response->headers->set('Content-Type', 'text/json');
return $response;
}
if (!$this->hasGroup($da, $groupname)) {
//根据typeid取出typename
$sql = "select typename from im_grouptype where typeid=?";
$ds = $da_im->GetData('im_grouptype', $sql, array($groupclassid));
$typename = '';
if ($ds['im_grouptype']["recordcount"] > 0) {
$typename = $ds["im_grouptype"]['rows'][0]["typename"];
} else {
$typename = $groupclassid;
}
//注册fafa_group
$sqls = array();
$paras = array();
$fafa_groupid = SysSeq::GetSeqNextValue($da_im, "im_group", "groupid");
$sqls[] = "insert into im_group (groupid, groupname, groupclass, groupdesc, creator, add_member_method, accessright) \n\t\t\t values (?, ?, ?, ?, ?, ?, 'any')";
$paras[] = array((string) $fafa_groupid, (string) $groupname, (string) $typename, (string) $groupdesc, (string) $user->fafa_jid, (string) $joinmethod);
$sqls[] = "insert into im_groupemployee (employeeid, groupid, employeenick, grouprole) values (?,?,?,'owner')";
$paras[] = array((string) $user->fafa_jid, (string) $fafa_groupid, (string) $user->nick_name);
//跟新群组版本号
$sqls[] = "delete from im_group_version where us=?";
$paras[] = array((string) $user->fafa_jid);
$da_im->ExecSQLs($sqls, $paras);
//保存图标
$sqls = array();
$paras = array();
$groupId = SysSeq::GetSeqNextValue($da, "we_groups", "group_id");
$sqls[] = "insert into we_groups (group_id,circle_id,group_name,group_desc,group_photo_path,join_method,create_staff,fafa_groupid,create_date, group_class)\n\t\t\t values (?,?,?,?,?,?,?,?,now(),?)";
$paras[] = array((string) $groupId, (string) $circleid, (string) $groupname, (string) $groupdesc, (string) $group_photo_path, (string) $joinmethod, (string) $user->getUserName(), (string) $fafa_groupid, (string) $groupclassid);
$sqls[] = "insert into we_group_staff (group_id,login_account) values (?,?)";
$paras[] = array((string) $groupId, (string) $user->getUserName());
$da->ExecSQLs($sqls, $paras);
//创建文档根目录
$docCtl = new \Justsy\BaseBundle\Controller\DocumentMgrController();
$docCtl->setContainer($this->container);
if ($docCtl->createDir("g" . $groupId, "c" . $circleid, $groupname, $circleid) > 0) {
$docCtl->saveShare("g" . $groupId, "0", $groupId, "g", "w");
//将群目录共享给该群组成员
}
$im_sender = $this->container->getParameter('im_sender');
//给创建者发送创建群组成功出席
Utils::sendImPresence($im_sender, $user->fafa_jid, "creategroup", json_encode(array("groupid" => $fafa_groupid, "logoid" => $group_photo_path, "groupname" => $groupname)), $this->container, "", "", false, Utils::$systemmessage_code);
//给邀请人员发送消息 站内和即时消息
if (!empty($invitedmemebers)) {
$invitedmemebers = str_replace("；", ";", $invitedmemebers);
$invs = explode(";", $invitedmemebers);
$title = "邀请加入群组";
foreach ($invs as $key => $value) {
if (empty($value)) {
continue;
}
//群编号,被邀请人帐号,network_domain,fafa_groupid
$encode = DES::encrypt("{$groupId},{$value},{$circleid}," . $fafa_groupid);
$activeurl = $this->generateUrl("JustsyBaseBundle_group_invjoin", array('para' => $encode), true);
$txt = $this->renderView("JustsyBaseBundle:Group:message.html.twig", array("ename" => $user->ename, "realName" => $user->nick_name, "activeurl" => $activeurl, 'gname' => $groupname));
//发送站内消息
$msgId = SysSeq::GetSeqNextValue($da, "we_message", "msg_id");
$sql = "insert into we_message(msg_id,sender,recver,title,content,send_date)values(?,?,?,?,?,now())";
$da->ExecSQL($sql, array((int) $msgId, (string) $user->getUserName(), (string) $value, "邀请加入群组", $txt));
//发送即时消息
$fafa_jid = Utils::getJidByAccount($da, $value);
//$this->get("logger")->info(Utils::makeHTMLElementTag('employee',$user->fafa_jid,$user->nick_name));
$message = Utils::makeHTMLElementTag('employee', $user->fafa_jid, $user->nick_name) . "邀请您加入群组【" . Utils::makeHTMLElementTag('group', $fafa_groupid, $groupname) . "】";
$buttons = array();
$buttons[] = array("text" => "立即加入", "code" => "agree", "value" => "1");
$buttons[] = array("text" => "拒绝", "code" => "agree", "value" => "0");
Utils::sendImMessage($im_sender, $fafa_jid, $title, $message, $this->container, $activeurl . "?invite_user="******"1");
}
}
$re["group"] = $this->getGroup($da, $user, $circleid, $groupId);
//变更版本信息
$eno = $user->eno;
$verchange = new \Justsy\BaseBundle\Management\VersionChange($da, $this->get("logger"));
$result = $verchange->SetVersionChange(2, $groupId, $eno);
} else {
$re["returncode"] = ReturnCode::$SYSERROR;
$re["error"] = "群组名称已存在！";
}
} catch (Exception $e) {
$re["returncode"] = ReturnCode::$SYSERROR;
$re["error"] = "系统错误，创建群组失败！";
$this->get('logger')->err($e);
}
$response = new Response($request->get('jsoncallback') ? $request->get('jsoncallback') . "(" . json_encode($re) . ");" : json_encode($re));
$response->headers->set('Content-Type', 'text/json');
return $response;
}
public function applyJoinAction()
{
$da = $this->get("we_data_access");
$user = $this->get('security.context')->getToken()->getUser();
$circleId = $this->get('request')->request->get('circleId');
$apply = new \Justsy\BaseBundle\Management\ApplyMgr($da, null);
//判断是否已加入该圈子
$sql = "select count(1) as cnt from we_circle_staff where circle_id=? and login_account=?";
$ds = $da->GetData('we_circle_staff', $sql, array((string) $circleId, (string) $user->getUserName()));
if (!$ds || $ds['we_circle_staff']['recordcount'] == 0) {
//已经是该圈子成员
return new Response("-1");
}
//判断是否已超出加入圈子数量的限制
$ec = new \Justsy\BaseBundle\Management\EnoParamManager($da, $this->get('logger'));
if ($ec->IsBeyondJoinCircle($user->getUserName())) {
return new Response("-2");
}
//判断改圈子成员数是否已满
if ($ec->IsBeyondCircleMembers($circleId)) {
return new Response("-3");
}
//判断是否已申请或者超出申请限制
$result = $apply->ApplyJoinCircle($user->getUsername(), $circleId, "");
if ($result == 0 || $result == 99999) {
return new Response((string) $result);
}
$circleObj = new \Justsy\BaseBundle\Management\CircleMgr($da, null, $circleId);
$circle = $circleObj->Get();
if ($circle == null) {
return new Response("0");
}
$createStaff = $circle["create_staff"];
$circleName = $circle["circle_name"];
//para 圈子ID,申请人帐号,申请人姓名,圈子名称 DES加密
$para = DES::encrypt($circleId . "," . $user->getUserName() . "," . $user->nick_name . "," . $circleName);
$addurl = $this->generateUrl("JustsyBaseBundle_publicpage_agreejoincircle", array('para' => $para), true);
$refuseurl = $this->generateUrl("JustsyBaseBundle_circle_refusejoincircle", array(), true);
$txt = $this->renderView("JustsyBaseBundle:Circle:mail_apply_join.html.twig", array("ename" => $user->ename, "realName" => $user->nick_name, "account" => DES::encrypt($user->getUserName()), "activeurl" => $addurl, "circlename" => $circleName, "refuseurl" => $refuseurl, "para" => $para));
//发送站内消息
$sqls = array();
$paras = array();
$msgId = SysSeq::GetSeqNextValue($da, "we_message", "msg_id");
$sqls[] = "insert into we_message(msg_id,sender,recver,send_date,title,content)values(?,?,?,now(),?,?)";
//$sqls[] = "insert into we_notify(notify_type, msg_id,notify_staff)values('01',?,?)";
$paras[] = array((int) $msgId, (string) $user->getUserName(), (string) $createStaff, "申请加入圈子", $txt);
//$paras[] = array((int)$msgId,(string)$createStaff);
$da->ExecSQLs($sqls, $paras);
Utils::saveMail($da, $user->getUsername(), $createStaff, "申请加入圈子", $txt, $circleId);
//Utils::sendMail($this->get('mailer'),"申请加入微发发企业社交圈子",$this->container->getParameter('mailer_user'),null,$createStaff,$txt);
//发送即时消息
$im_sender = $this->container->getParameter('im_sender');
$fafa_jid = $circle["fafa_jid"];
$message = Utils::makeHTMLElementTag('employee', $user->fafa_jid, $user->nick_name) . "申请加入您的圈子【" . $circleName . "】";
$buttons = array();
$buttons[] = array("text" => "拒绝", "code" => "agree", "value" => "0", "link" => $refuseurl . "?para=" . $para);
$buttons[] = array("text" => "同意", "code" => "agree", "value" => "1", "link" => $addurl);
Utils::sendImMessage($im_sender, $fafa_jid, "申请加入圈子", $message, $this->container, "", Utils::makeBusButton($buttons), false, Utils::$systemmessage_code);
return new Response("1");
}
public function createcircleAction()
{
$re = array("returncode" => ReturnCode::$SUCCESS);
$user = $this->get('security.context')->getToken()->getUser();
$request = $this->getRequest();
$circlename = $request->get("circle_name");
$circledesc = $request->get("circle_desc");
$joinmethod = $request->get("join_method", "0");
$allowcopy = $request->get("allow_copy", "0");
$circleclassid = $request->get("circle_class_id");
$invitedmemebers = $request->get("invitedmemebers");
$logo_path = $request->get("logo_path");
$logo_path_small = $request->get("logo_path_small");
$logo_path_big = $request->get("logo_path_big");
$da = $this->get('we_data_access');
$da_im = $this->get('we_data_access_im');
try {
if (empty($circlename) || empty($circleclassid)) {
$re["returncode"] = ReturnCode::$SYSERROR;
$re["error"] = "参数传递错误！";
$response = new Response($request->get('jsoncallback') ? $request->get('jsoncallback') . "(" . json_encode($re) . ");" : json_encode($re));
$response->headers->set('Content-Type', 'text/json');
return $response;
}
if (!$this->hasCircle($da, $circlename)) {
$ec = new \Justsy\BaseBundle\Management\EnoParamManager($da, $this->get('logger'));
if ($ec->IsBeyondCreateCircle($user->getUserName())) {
$re["returncode"] = ReturnCode::$SYSERROR;
$re["error"] = "创建圈子数量已超过限制！";
} else {
$circle_id = (string) SysSeq::GetSeqNextValue($da, "we_circle", "circle_id");
//创建圈子不再同步创建群组
//liling 2015-1-18
$fafa_groupid = "";
// SysSeq::GetSeqNextValue($da_im,"im_group","groupid");
$network = $circle_id;
$sqls = array("insert into we_circle(circle_id,circle_name,circle_desc,logo_path,logo_path_big,logo_path_small,create_staff,create_date,manager,join_method,network_domain,allow_copy,circle_class_id,fafa_groupid)value(?,?,?,?,?,?,?,now(),?,?,?,?,?,?)", "insert into we_circle_staff(circle_id,login_account,nick_name)values(?,?,?)");
$paras = array(array((string) $circle_id, (string) $circlename, (string) $circledesc, (string) $logo_path, (string) $logo_path_big, (string) $logo_path_small, (string) $user->getUsername(), (string) $user->getUsername(), (string) $joinmethod, $network, (string) $allowcopy, (string) $circleclassid, (string) $fafa_groupid), array((string) $circle_id, (string) $user->getUsername(), (string) $user->nick_name));
$da->ExecSQLs($sqls, $paras);
//创建文档根目录
$docCtl = new \Justsy\BaseBundle\Controller\DocumentMgrController();
$docCtl->setContainer($this->container);
if ($docCtl->createDir("c" . $circle_id, "", $circlename, $circle_id) > 0) {
$docCtl->saveShare("c" . $circle_id, "0", $circle_id, "c", "w");
//将圈子目录共享给该圈子成员
}
//给创建者发送创建群组成功出席
//Utils::sendImPresence($user->fafa_jid,$user->fafa_jid,"creategroup",json_encode(array("groupid"=> $fafa_groupid,"groupname"=> $circlename)),$this->container,"","",false,Utils::$systemmessage_code);
//发送邀请邮件
if (!empty($invitedmemebers)) {
$user = $this->get('security.context')->getToken()->getUser();
$invInfo = array('inv_send_acc' => $user->getUsername(), 'inv_recv_acc' => '', 'eno' => '', 'inv_rela' => '', 'inv_title' => '', 'inv_content' => '', 'active_addr' => '');
$invitedmemebers = str_replace("；", ";", $invitedmemebers);
$invitedmemebersLst = explode(";", $invitedmemebers);
foreach ($invitedmemebersLst as $key => $value) {
$invacc = trim($value);
if (empty($invacc)) {
continue;
}
$invInfo['inv_recv_acc'] = $invacc;
$sql = "select eno,fafa_jid from we_staff where login_account=?";
$ds = $da->GetData("we_staff", $sql, array((string) $invacc));
//帐号存在
if ($ds && $ds['we_staff']['recordcount'] > 0) {
//1.帐号存在，直接加入圈子
//受邀人员帐号,圈子id,邀请人帐号
$encode = DES::encrypt("{$invacc},{$circle_id}," . $user->getUsername());
$activeurl = $this->generateUrl("JustsyBaseBundle_invite_agreejoincircle", array('para' => $encode), true);
$rejectactiveurl = $this->generateUrl("JustsyBaseBundle_invite_refuse", array('para' => $encode), true);
$txt = $this->renderView('JustsyBaseBundle:Invite:circle_invitation_msg.html.twig', array("ename" => $user->ename, "nick_name" => $user->nick_name, "activeurl" => $activeurl, 'circle_name' => $circlename, 'invMsg' => '', 'staff' => array()));
$invInfo['eno'] = "c{$circle_id}";
$invInfo['inv_title'] = "邀请加入圈子【" . Utils::makeCircleTipHTMLTag($circle_id, $circlename) . "】";
$invInfo['inv_content'] = '';
$invInfo['active_addr'] = $activeurl;
//保存邀请信息
InviteController::saveWeInvInfo($da, $invInfo);
//发送即时消息
$fafa_jid = $ds['we_staff']['rows'][0]['fafa_jid'];
$message = Utils::makeHTMLElementTag('employee', $user->fafa_jid, $user->nick_name) . "邀请您加入圈子【" . Utils::makeHTMLElementTag('circle', $fafa_groupid, $circlename) . "】";
$buttons = array();
$buttons[] = array("text" => "拒绝", "code" => "agree", "value" => "0", "link" => $rejectactiveurl);
$buttons[] = array("text" => "立即加入", "code" => "agree", "value" => "1", "link" => $activeurl);
Utils::sendImMessage($im_sender, $fafa_jid, "邀请加入圈子", $message, $this->container, "", Utils::makeBusButton($buttons), false, Utils::$systemmessage_code);
} else {
//2.帐号不存在
$tmp = explode("@", $invacc);
$tmp = count($tmp) > 1 ? $tmp[1] : 'fafatime.com';
$sql = "select count(1) as cnt from we_public_domain where domain_name=?";
$ds = $da->GetData("we_public_domain", $sql, array((string) $tmp));
if ($ds && $ds['we_public_domain']['rows'][0]['cnt'] == 0) {
//2.1企业邮箱
$sql = "select eno from we_enterprise where edomain=?";
$ds = $da->GetData("we_enterprise", $sql, array((string) $tmp));
if ($ds && $ds['we_enterprise']['recordcount'] > 0) {
//2.1.1企业已创建 帐号,圈子id,企业edomain des encode
$eno = $ds['we_enterprise']['rows'][0]['eno'];
$encode = DES::encrypt($user->getUsername() . ",{$circle_id},{$eno}");
$activeurl = $this->generateUrl("JustsyBaseBundle_active_inv_s1", array('account' => DES::encrypt($invacc), 'invacc' => $encode), true);
} else {
//2.1.2企业未创建
$sql = "insert into we_register (login_account,ename,credential_path,active_code,ip,email_type,first_reg_date,last_reg_date,register_date,state_id)" . " values (?,?,?,?,?,?,now(),now(),now(),'0')";
$para = array($invacc, '', '', strtoupper(substr(uniqid(), 3, 10)), $_SERVER['REMOTE_ADDR'], '1');
$da->ExecSQL($sql, $para);
//发送邮件 帐号,圈子id,邀请发送者帐号,邀请人企业名 des encode
$encode = DES::encrypt("{$invacc},{$circle_id}," . $user->getUserName() . "," . $user->ename);
$activeurl = $this->generateUrl("JustsyBaseBundle_active_reg_s1", array('account' => $encode), true);
}
//保存邀请信息 circleid保存到eno字段，以字母'c'开头
$invInfo['eno'] = "c{$circle_id}";
$title = $user->nick_name . " 邀请您加入 " . Utils::makeCircleTipHTMLTag($circle_id, $circlename) . " 协作网络";
$txt = $this->renderView('JustsyBaseBundle:Invite:circle_invitation.html.twig', array("ename" => $user->ename, "nick_name" => $user->nick_name, "activeurl" => $activeurl, 'circle_name' => $circlename, 'invMsg' => '', 'staff' => array()));
$invInfo['inv_title'] = $title;
$invInfo['inv_content'] = $txt;
$invInfo['active_addr'] = $activeurl;
InviteController::saveWeInvInfo($da, $invInfo);
Utils::saveMail($da, $user->getUsername(), $invacc, $title, $txt, $invInfo['eno']);
} else {
//公共邮箱
$sql = "insert into we_register (login_account,ename,credential_path,active_code,ip,email_type,first_reg_date,last_reg_date,register_date,state_id) " . "select ?,'','','" . strtoupper(substr(uniqid(), 3, 10)) . "','" . $_SERVER['REMOTE_ADDR'] . "','0',now(),now(),now(),'2' from dual " . "where not exists (select 1 from we_register where login_account=?)";
$para = array($invacc, $invacc);
$da->ExecSQL($sql, $para);
//发送邮件 帐号,圈子id,邀请发送者帐号,邀请人企业名 des encode
$encode = DES::encrypt("{$invacc},{$circle_id}," . $user->getUserName() . "," . $user->ename);
$activeurl = $this->generateUrl("JustsyBaseBundle_active_reg_s1", array('account' => $encode), true);
$invInfo['eno'] = "c{$circle_id}";
$title = $user->nick_name . " 邀请您加入 " . Utils::makeCircleTipHTMLTag($circle_id, $circlename) . " 协作网络";
$txt = $this->renderView('JustsyBaseBundle:Invite:circle_invitation.html.twig', array("ename" => $user->ename, "nick_name" => $user->nick_name, "activeurl" => $activeurl, 'circle_name' => $circlename, 'invMsg' => '', 'staff' => array()));
//保存邀请信息
$invInfo['inv_title'] = $title;
$invInfo['inv_content'] = $txt;
$invInfo['active_addr'] = $activeurl;
InviteController::saveWeInvInfo($da, $invInfo);
Utils::saveMail($da, $user->getUsername(), $invacc, $title, $txt, $invInfo['eno']);
}
}
}
}
$re["circle"] = $this->getCricle($da, $circle_id);
}
} else {
$re["returncode"] = ReturnCode::$SYSERROR;
$re["error"] = "圈子名称已存在！";
}
} catch (\Exception $e) {
$re["returncode"] = ReturnCode::$SYSERROR;
$re["error"] = "系统错误，创建圈子失败！";
$this->get('logger')->err($e);
}
$response = new Response($request->get('jsoncallback') ? $request->get('jsoncallback') . "(" . json_encode($re) . ");" : json_encode($re));
$response->headers->set('Content-Type', 'text/json');
return $response;
}
