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);
}
