public function importEmployeeAction($network_domain) { $request = $this->get("request"); $user = $this->get('security.context')->getToken()->getUser(); //判断当前导入人员是否是企业邮箱 $userDomain = explode("@", $user->getUserName()); $da = $this->get("we_data_access"); $sql = "select 1 from we_public_domain where domain_name=?"; $ds = $da->GetData("mt", $sql, array((string) $userDomain[1])); $mailType = count($ds["mt"]["rows"]) > 0 ? "0" : "1"; //1表示是企业邮箱 try { $upfile = $request->files->get("filedata"); $tmpPath = $upfile->getPathname(); $oldName = $upfile->getClientOriginalName(); $fixs = explode(".", strtolower($oldName)); if (count($fixs) < 2) { $re = array('s' => 0, 'message' => "文件类型不正确"); } else { $fixedType = $fixs[count($fixs) - 1]; if ($fixedType != "xlsx" && $fixedType != "xls") { $re = array('s' => 0, 'message' => "文件类型不正确"); } else { $newFileName = $user->openid . date('y-m-d-H-m-s') . "." . $fixedType; if (move_uploaded_file($tmpPath, 'upload/' . $newFileName)) { $da = $this->container->get('we_data_access'); $objReader = \PHPExcel_IOFactory::createReader($fixedType == "xlsx" ? 'Excel2007' : "Excel5"); //use excel2007 for 2007 format $objPHPExcel = $objReader->load($_SERVER['DOCUMENT_ROOT'] . '/upload/' . $newFileName); $objWorksheet = $objPHPExcel->getActiveSheet(); $highestRow = $objWorksheet->getHighestRow(); $highestColumn = $objWorksheet->getHighestColumn(); $highestColumnIndex = \PHPExcel_Cell::columnIndexFromString($highestColumn); //总列数 //获取标题行 $titleAry = array(); $account_index = 0; $name_index = 0; $mobile_index = 0; $pwd_index = 0; for ($row = 0; $row <= 1; $row++) { for ($col = 0; $col < $highestColumnIndex; $col++) { $titleAry[$col] = $objWorksheet->getCellByColumnAndRow($col, $row)->getValue(); if (strpos($titleAry[$col], "邮箱") !== false) { $account_index = $col; } else { if (strpos($titleAry[$col], "姓名") !== false) { $name_index = $col; } else { if (strpos($titleAry[$col], "手机") !== false) { $mobile_index = $col; } else { if (strpos($titleAry[$col], "密码") !== false) { $pwd_index = $col; } } } } } } $titleAry[] = "eno"; $err_list = array(); $da = $this->get("we_data_access"); $dm = $this->get("we_data_access_im"); //获取数据行 for ($row = 2; $row <= $highestRow; $row++) { $strs = array(); for ($col = 0; $col < $highestColumnIndex; $col++) { $strs[$col] = trim((string) $objWorksheet->getCellByColumnAndRow($col, $row)->getValue()); } $strs[] = $user->eno; $name = $strs[$name_index]; if (empty($name)) { $err_list[] = array("name" => "", "row" => $row, "msg" => "姓名不能为空"); continue; } if (strlen($name) == 1) { $err_list[] = array("name" => "", "row" => $row, "msg" => "姓名不能少于2个字符"); continue; } //获取填写的帐号 $account = $strs[$account_index]; if (empty($account)) { $err_list[] = array("name" => $name, "row" => $row, "msg" => "邮箱帐号不能为空"); continue; } if (!Utils::validateEmail($account)) { $err_list[] = array("name" => $name, "row" => $row, "msg" => "邮箱帐号格式不正确"); continue; } $staffmgr = new Staff($da, $dm, $account); if ($staffmgr->checkNickname($user->eno, $name) === true) { $err_list[] = array("name" => "", "row" => $row, "msg" => "[" . $name . "]已经注册,请检查!"); continue; } //if($mailType=="1" && explode("@",$account)[1]!=$userDomain[1] ) //{ // $err_list[]=array("name"=>$name,"row"=>($row),"msg"=>"不允许导入公共邮箱$account"); // continue; //} $mobile = $strs[$mobile_index]; if (!empty($mobile)) { if (!Utils::validateMobile($mobile)) { $err_list[] = array("name" => $name, "row" => $row, "msg" => "手机号码格式不正确"); continue; } } //判断帐号是否已经注册 $isexist = $staffmgr->isExist($mobile); if (!empty($isexist)) { //已注册 $err_list[] = array("name" => $name, "msg" => "邮箱或手机号已被使用"); continue; } //判断是否已导入,已导入,则不再发邮件 $isImport = false; try { $isImport = $staffmgr->getImportInfo(); } catch (\Exception $err) { } try { $staffmgr->importReg($titleAry, $strs); //判断是否设置了密码 $pwd = $strs[$pwd_index]; if (!empty($pwd)) { $sql = "select ename from we_enterprise where eno=?"; $ds = $da->GetData("t", $sql, array((string) $user->eno)); //自动激活 $active = new \Justsy\BaseBundle\Controller\ActiveController(); $active->setContainer($this->container); $active->doSave(array('account' => $account, 'realName' => $name, 'passWord' => $pwd, 'eno' => $user->eno, 'ename' => $ds["t"]["rows"][0]["ename"], 'isNew' => '0', 'mailtype' => "1", 'isSendMessage' => "N", 'import' => '1')); $staffmgr = new Staff($da, $dm, $account); $importData = $staffmgr->getImportInfo(); $staffmgr->updateByImport($importData); $staffmgr->deleteImportPhy(); } else { if ($isImport === false) { //发送邮件 $activeurl = $this->generateUrl("JustsyBaseBundle_empimport_setpass", array('account' => DES::encrypt($account)), true); $txt = $this->renderView('JustsyBaseBundle:Register:mail.html.twig', array('realName' => $user->nick_name, 'account' => $account, 'activeurl' => $activeurl)); Utils::saveMail($da, $this->container->getParameter('mailer_user'), $account, "欢迎加入Wefafa企业协作网络", $txt); } } } catch (\Exception $err) { //写导入数据发生异常 $err_list[] = array("name" => $name, "msg" => "导入失败:" . $err->getMessage()); continue; } } $re = array('s' => 1, 'error_list' => $err_list); } else { $re = array('s' => 0, 'message' => "文件上传失败"); } try { unlink($tmpPath); } catch (\Exception $e) { } } } } catch (\Exception $ex) { $re = array('s' => 0, 'message' => "导入失败"); } $response = new Response("<script>parent.import_callback(" . json_encode($re) . ")</script>"); $response->headers->set('Content-Type', 'text/html'); return $response; }
public function sendMsg2($from, $to, $msg, $type, $isCheckTo = false, $cctomail = "0", $msg_id = "") { $pre_code = '/"code":".*?"/i'; preg_match($pre_code, $msg, $result); if (count($result) > 0) { $type = str_replace(""", "", $result[0]); $type = str_replace("code:", "", $type); } //获取发送人和接收人jid或者openid $from = trim($from); $msg = urlencode(trim($msg)); if (empty($from)) { $domain = $this->container->getParameter('edomain'); $from = "admin@" . $domain; } if (empty($msg)) { return array('returncode' => '9999', 'msg' => '消息内容不能为空'); } $da = $this->get("we_data_access"); $senderMail = "admin@" . $this->container->getParameter('edomain'); if (!strpos($from, "@")) { //获取opendid对应的jid,没找到则返回错误 if (Utils::validateMobile($from)) { //手机号 $table = $da->GetData("staff", "select fafa_jid,login_account from we_staff where mobile_bind=? ", array((string) $from, (string) $from)); } else { $table = $da->GetData("staff", "select fafa_jid,login_account from we_staff where openid=? or ldap_uid=?", array((string) $from, (string) $from)); } if (count($table["staff"]["rows"]) == 0) { return array('returncode' => '9999', 'msg' => '消息发送者参数不能为空'); } $from = $table["staff"]["rows"][0]["fafa_jid"]; $senderMail = $table["staff"]["rows"][0]["login_account"]; } else { if (strpos($from, "admin") === false) { //jid $table = $da->GetData("staff", "select fafa_jid,login_account from we_staff where fafa_jid=? or login_account=?", array((string) $from, (string) $from)); if (count($table["staff"]["rows"]) == 0) { return array('returncode' => '9999', 'msg' => '消息发送者参数不能为空'); } $from = $table["staff"]["rows"][0]["fafa_jid"]; $senderMail = $table["staff"]["rows"][0]["login_account"]; } } //-------------check To-------------- if (empty($to)) { return array('returncode' => '9999', 'msg' => '消息接收者参数不能为空'); } $arr = is_array($to) ? $to : explode(",", $to); $regUrl = $this->container->getParameter("FAFA_REG_JID_URL"); $toLst = array(); $nosendLst = array(); foreach ($arr as $key => $value) { $to2 = $value; if ($isCheckTo === false && $cctomail != "1") { $toLst[] = $to2; continue; //是否需要检查接收人是否有效。当内部调用且100%能确定有效且不抄送邮箱(要抄送时还是得去查询一次)时,可设置为不再检查 } if (!strpos($to2, "@")) { //获取opendid对应的jid,没找到则返回错误 if (Utils::validateMobile($to2)) { //手机号 $table = $da->GetData("staff", "select fafa_jid,login_account from we_staff where mobile_bind=? ", array((string) $to2)); } else { $table = $da->GetData("staff", "select fafa_jid,login_account from we_staff where openid=? or ldap_uid=?", array((string) $to2, (string) $to2)); } if (count($table["staff"]["rows"]) == 0) { $nosendLst[] = $to2; continue; } $to2 = $table["staff"]["rows"][0]["fafa_jid"]; if ($cctomail == "1") { Utils::saveMail($da, $senderMail, $table["staff"]["rows"][0]["login_account"], $title, $msg); } } else { if (strpos($to2, "admin") === false) { //jid $staffMgr = new Staff($da, $this->get("we_data_access_im"), $to2, $this->get("logger"), $this->container); $staffinfo = $staffMgr->getInfo(); if (!empty($staffinfo)) { $to2 = $staffinfo["fafa_jid"]; } else { $table = $da->GetData("staff", "select fafa_jid,login_account from we_staff where fafa_jid=?", array((string) $to2)); if (count($table["staff"]["rows"]) == 0) { $nosendLst[] = $to2; continue; } $to2 = $table["staff"]["rows"][0]["fafa_jid"]; if ($cctomail == "1") { Utils::saveMail($da, $senderMail, $table["staff"]["rows"][0]["login_account"], urldecode(iconv('UTF-8', 'GBK', $title)), urldecode(iconv('UTF-8', 'GBK', $msg)), "business-message"); } } } } $toLst[] = $to2; } $regUrlOrg = $regUrl . "/service.yaws"; $data = "sendMicroMsg=1&from={$from}&to=" . implode(",", $toLst) . "&msg={$msg}&type={$type}&busdata={$msg_id}"; //$this->get("logger")->alert("SEND MSG URL:$regUrlOrg?$data"); $re = Utils::do_post_request($regUrlOrg, $data); if (count($nosendLst) == 0) { return array('returncode' => '0000', 'nosend' => ''); } else { return array('returncode' => '0000', 'nosend' => implode(",", $nosendLst)); } }
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 reSendInvitationAction() { $im_sender = $this->container->getParameter('im_sender'); $da = $this->get('we_data_access'); $user = $this->get('security.context')->getToken()->getUser(); $eno = $this->get("request")->request->get("eno"); $invite_recv_email = $this->get("request")->request->get("invite_recv_email"); $invInfo = array('inv_send_acc' => $user->getUsername(), 'inv_recv_acc' => $invite_recv_email, 'eno' => $eno, 'inv_rela' => '', 'inv_title' => '', 'inv_content' => '', 'active_addr' => ''); //被邀请帐号是否存在,存在则update we_invite,不存在 取we_invite的数据,重发邮件 $sql = "select fafa_jid from we_staff where login_account=?"; $ds = $da->GetData("we_staff", $sql, array((string) $invite_recv_email)); if ($ds && $ds['we_staff']['recordcount'] > 0) { InviteController::saveWeInvInfo($da, $invInfo); //发送即时消息 $fafa_jid = $ds['we_staff']['rows'][0]['fafa_jid']; $message = $user->nick_name . "邀请您加入圈子,请登录微发发进行确认。"; Utils::sendImMessage($im_sender, $fafa_jid, "邀请加入圈子", $message, $this->container, "", "", false, Utils::$systemmessage_code); } else { $sql = "select inv_title,inv_content from we_invite where invite_recv_email=? and invite_send_email=? and eno=?"; $ds = $da->GetData("we_invite", $sql, array((string) $invite_recv_email, (string) $user->getUsername(), (string) $eno)); if ($ds && $ds['we_invite']['recordcount'] > 0) { Utils::saveMail($da, $user->getUsername(), $invite_recv_email, $ds['we_invite']['rows'][0]['inv_title'], $ds['we_invite']['rows'][0]['inv_content'], $eno); //Utils::sendMail($this->get('mailer'),$ds['we_invite']['rows'][0]['inv_title'],$this->container->getParameter('mailer_user'),null,$invite_recv_email,$ds['we_invite']['rows'][0]['inv_content']); } InviteController::saveWeInvInfo($da, $invInfo); } return new Response("1"); }
public function invitedmemebersAction() { $re = array("returncode" => ReturnCode::$SUCCESS); $user = $this->get('security.context')->getToken()->getUser(); $request = $this->getRequest(); $circle_id = $request->get("circle_id"); $invitedmemebers = $request->get("invitedmemebers"); $da = $this->get('we_data_access'); $da_im = $this->get('we_data_access_im'); try { if (empty($invitedmemebers) || empty($circle_id)) { $re["returncode"] = ReturnCode::$SYSERROR; $response = new Response($request->get('jsoncallback') ? $request->get('jsoncallback') . "(" . json_encode($re) . ");" : json_encode($re)); $response->headers->set('Content-Type', 'text/json'); return $response; } $circlename = ""; $fafa_groupid = ""; $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' => ''); $invitedmemebersLst = explode(";", $invitedmemebers); $circleStaffs = array(); $sql = "select login_account from we_circle_staff where circle_id=?"; $ds = $da->GetData("circle_staffs", $sql, array($circle_id)); if ($ds && $ds["circle_staffs"]["recordcount"] > 0) { foreach ($ds["circle_staffs"]["rows"] as &$row) { $circleStaffs[] = $row['login_account']; } } $sql = "select circle_name,fafa_groupid from we_circle where circle_id=?"; $ds = $da->GetData("circle", $sql, array($circle_id)); if ($ds && $ds["circle"]["recordcount"] > 0) { $circlename = $ds["circle"]["rows"][0]['circle_name']; $fafa_groupid = $ds["circle"]["rows"][0]['fafa_groupid']; } 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) { if (count($circleStaffs) > 0 && in_array($invacc, $circleStaffs)) { continue; } //1.帐号存在,直接加入圈子 //受邀人员帐号,圈子id,邀请人帐号 $encode = DES::encrypt("{$invacc},{$circle_id}," . $user->getUsername()); $activeurl = $this->generateUrl("JustsyBaseBundle_invite_agreejoincircle", array('para' => $encode, 'eno' => 'c' . $circle_id), true); $rejectactiveurl = $this->generateUrl("JustsyBaseBundle_invite_refuse", array('para' => $encode, 'eno' => 'c' . $circle_id), 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["returncode"] = ReturnCode::$SUCCESS; } catch (\Exception $e) { $re["returncode"] = ReturnCode::$SYSERROR; $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 saveRetrieveReq_3GAction() { $da = $this->get('we_data_access'); $login_account = $this->get('request')->request->get('login_account'); $sql = "select nick_name from we_staff where login_account=?"; $ds = $da->GetData('we_staff', $sql, array((string) $login_account)); if (!$ds || $ds['we_staff']['recordcount'] == 0) { return $this->render('JustsyBaseBundle:Register:retrieve_pwd_index_3g.html.twig', array('err' => '您输入的帐号不存在!', 'login_account' => $login_account)); } $nick_name = $ds['we_staff']['rows'][0]['nick_name']; $id = SysSeq::GetSeqNextValue($da, "we_retrieve_password", "id"); $sql = "insert into we_retrieve_password (id,login_account,req_date,valid_date,valid) values (?,?,now(),adddate(now(),1),'1')"; $da->ExecSQL($sql, array($id, $login_account)); $req_date = getdate(); //帐号,申请id $repwd_url = $this->generateUrl("JustsyBaseBundle_reg_resetpwd", array('para' => DES::encrypt("{$login_account},{$id}")), true); $txt = $this->renderView("JustsyBaseBundle:Register:retrieve_pwd_mail.html.twig", array("nick_name" => $nick_name, "req_date" => $req_date['year'] . '年' . $req_date['mon'] . '月' . $req_date['mday'] . '日' . $req_date['hours'] . '时' . $req_date['minutes'] . '分', "repwd_url" => $repwd_url)); $title = "Wefafa密码找回邮件"; Utils::saveMail($da, $this->container->getParameter('mailer_user'), $login_account, $title, $txt); $tmp = explode("@", $login_account); if (count($tmp) > 1) { $tmp = $tmp[1]; } $mailaddr = "http://mail.{$tmp}"; return $this->render('JustsyBaseBundle:Register:retrieve_pwd_req_end_3g.html.twig', array('login_account' => $login_account, 'mailaddr' => $mailaddr)); }