public function indexAction() { $da = $this->get('we_data_access'); $da_im = $this->get('we_data_access_im'); $user = $this->get('security.context')->getToken()->getUser(); $login_account = $user->getUserName(); $groupMgr = new \Justsy\BaseBundle\Management\GroupMgr($da, $da_im, $this->container); $manager = $groupMgr->isManager($user->eno, $login_account); $exist = true; if (empty($manager)) { $sql = "select 1 from mb_staff_menu where staff_id=?;"; try { $ds = $da->GetData("table", $sql, array((string) $login_account)); if ($ds && $ds["table"]["recordcount"] == 0) { $exist = false; } } catch (\Exception $e) { } } if ($exist) { return $this->render('JustsyAdminAppBundle:Home:index.html.twig', array()); } else { return $this->render('JustsyAdminAppBundle:Home:error.html.twig', array()); } }
public function IndexAction() { $user = $this->get('security.context')->getToken()->getUser(); $login_account = $user->getUserName(); $eno = $user->eno; $da = $this->get('we_data_access'); $url = $this->container->getParameter('FILE_WEBSERVER_URL'); $groupMgr = new \Justsy\BaseBundle\Management\GroupMgr($this->get('we_data_access'), $this->get('we_data_access_im'), $this->container); $manager = $groupMgr->isManager($eno, $login_account); $request = $this->getRequest(); $type = $request->get("type"); if (empty($type)) { return $this->render("JustsyAdminAppBundle:Sys:service.html.twig", array("manager" => $manager)); } else { return $this->render("JustsyAdminAppBundle:Sys:service2.html.twig", array("manager" => $manager)); } }
public function FriendCircleAction() { $user = $this->get('security.context')->getToken()->getUser(); $login_account = $user->getUserName(); $eno = $user->eno; $groupMgr = new \Justsy\BaseBundle\Management\GroupMgr($this->get('we_data_access'), $this->get('we_data_access_im'), $this->container); $manager = $groupMgr->isManager($eno, $login_account); $da = $this->get('we_data_access'); $url = $this->container->getParameter('FILE_WEBSERVER_URL'); $head_img = ""; $sql = "select case when ifnull(photo_path,'')='' then '' else concat('{$url}',photo_path) end head_img from we_staff where login_account=?"; try { $ds = $da->GetData("table", $sql, array((string) $login_account)); if ($ds && $ds["table"]["recordcount"] > 0) { $head_img = $ds["table"]["rows"][0]["head_img"]; } } catch (\Exception $e) { } return $this->render("JustsyAdminAppBundle:Sys:friendcircle.html.twig", array("manager" => $manager, "account" => $user->getUserName(), "head_img" => $head_img, "nick_name" => $user->nick_name)); }
public function search_service($parameter) { $success = true; $data = array(); $staff = isset($parameter["staff"]) ? $parameter["staff"] : null; $user = $parameter["user"]; $curUser = $user->getUserName(); $pageindex = isset($parameter["pageindex"]) ? $parameter["pageindex"] : 1; $record = isset($parameter["record"]) ? $parameter["record"] : 100; $pageindex = $pageindex < 1 ? 1 : $pageindex; $limit = " limit " . ($pageindex - 1) * $record . "," . $record; $recordcount = 0; $groupMgr = new \Justsy\BaseBundle\Management\GroupMgr($this->conn, $this->conn_im, $this->container); $manager = $groupMgr->isManager($user->eno, $curUser); $fileurl = $this->container->getParameter("FILE_WEBSERVER_URL"); if (empty($manager)) { $sql = "select b.id as micro_id,a.fafa_jid as jid,a.login_account,a.nick_name,b.micro_use,concat('{$fileurl}',a.photo_path_big) photo_path,b.type,\n ifnull((select 'manager' from we_service s where s.objid='" . $curUser . "' and s.login_account=b.number and type=3 ),'') manager ,(select count(1) msgcount from we_micro_send_message msg where msg.send_account=b.number) msgcount\n from we_staff a inner join we_micro_account b on a.fafa_jid=b.jid where b.eno=? "; } else { $sql = "select b.id as micro_id,a.fafa_jid as jid,a.login_account,a.nick_name,b.micro_use,concat('{$fileurl}',a.photo_path_big) photo_path,b.type,'" . $manager . "' manager ,(select count(1) msgcount from we_micro_send_message msg where msg.send_account=b.number) msgcount\n from we_staff a inner join we_micro_account b on a.fafa_jid=b.jid where b.eno=? "; } $condition = ""; $page_sql = "select count(*) recordcount from we_staff a inner join we_micro_account b on a.fafa_jid=b.jid where b.eno=?"; $para = array((string) $user->eno); if (!empty($staff)) { if (strlen($staff) > mb_strlen($staff, 'utf8')) { $condition = " and a.nick_name like concat('%',?,'%') "; array_push($para, (string) $staff); } else { $condition = " and (a.login_account like concat('%',?,'%') or a.nick_name like concat('%',?,'%')) "; array_push($para, (string) $staff, (string) $staff); } } $sql .= $condition . " order by a.login_account asc " . $limit; try { $ds = null; if (count($para) == 0) { $ds = $this->conn->GetData("table", $sql); } else { $ds = $this->conn->GetData("table", $sql, $para); } if ($ds && $ds["table"]["recordcount"] > 0) { $data = $ds["table"]["rows"]; $sql = 'select a.send_account,a.send_datetime,b.msg_title,b.msg_text,b.msg_content,msg_summary,msg_img_url,msg_web_url,msg_type from we_micro_send_message a ,we_micro_message b where a.id=b.send_id and a.send_account=? order by a.send_datetime desc limit 1'; foreach ($data as $key => $value) { //获取最后推送的消息 $data[$key]["message"] = array(); if ($value['msgcount'] == 0) { continue; } $tmp_para = array((string) $value['login_account']); $tmp_ds = $this->conn->GetData("msg", $sql, $tmp_para); $data[$key]["message"] = $tmp_ds['msg']['rows']; } $count = $ds["table"]["recordcount"]; if ($pageindex == 1 && $count >= $record) { $page_sql .= $condition; if (count($para) == 0) { $ds = $this->conn->GetData("table", $page_sql); } else { $ds = $this->conn->GetData("table", $page_sql, $para); } if ($ds && $ds["table"]["recordcount"] > 0) { $recordcount = $ds["table"]["rows"][0]["recordcount"]; } } } } catch (\Exception $e) { $success = false; $this->logger->err($e->getMessage()); return Utils::WrapResultError($e->getMessage()); } return Utils::WrapResultOK($data); }