public function getExprienceAround($exprience)
{
$re = array();
$level = \Justsy\BaseBundle\Common\ExperienceLevel::getLevel($exprience);
$ExperienceLevels = \Justsy\BaseBundle\Common\ExperienceLevel::getExperienceLevels();
$re["PreLevelExperience"] = $ExperienceLevels[$level];
$re["NextLevelExperience"] = !array_key_exists($level + 1, $ExperienceLevels) ? $ExperienceLevels[$level] : $ExperienceLevels[$level + 1];
return $re;
}
public function loadUserByUsername($username)
{
$dataset = $this->getUserInfo($username);
$DataAccess = $this->get('we_data_access');
if ($dataset && $dataset["we_staff"]["recordcount"] > 0) {
$we_staff_row = $dataset["we_staff"]["rows"][0];
$password = $we_staff_row['password'];
$salt = $we_staff_row['login_account'];
$roles = array('ROLE_USER');
$sqls = array();
$params = array();
//获取用户角色和对应功能点数据
$sqls[] = "select DISTINCT d.`code`,d.`name`\n\t from we_staff_role a ,we_role b, we_role_function c,we_function d \n\t\t\twhere a.roleid=b.id and b.id=c.roleid and c.functionid=d.id and a.staff=? ;";
//获取用户角色
$sqls[] = "select DISTINCT b.name,b.code from we_staff_role a,we_role b where a.roleid=b.id and a.staff=?";
$params[] = array((string) $salt);
$params[] = array((string) $salt);
$ds = $DataAccess->GetDatas(array("we_function", "we_role"), $sqls, $params);
$us = new UserSession($we_staff_row['login_account'], $password, $salt, $roles);
$us->nick_name = $we_staff_row['nick_name'];
//$us->identify = $we_staff_row['identify'];
$us->photo_path = $we_staff_row['photo_path'];
$us->photo_path_small = $we_staff_row['photo_path_small'];
$us->photo_path_big = $we_staff_row['photo_path_big'];
$us->dept_id = $we_staff_row['dept_id'];
$us->dept_name = $we_staff_row['dept_name'];
$us->dept_name = $us->dept_name == null ? "[未设置部门]" : $us->dept_name;
$us->eno = $we_staff_row['eno'];
$us->fafa_jid = $we_staff_row['fafa_jid'];
$us->duty = $we_staff_row['duty'];
$us->work_phone = $we_staff_row['work_phone'];
$us->mobile = $we_staff_row['mobile'];
$us->birthday = $we_staff_row['birthday'];
$us->sex_id = $we_staff_row['sex_id'];
$us->openid = $we_staff_row['openid'];
$us->t_code = trim(DES::decrypt($we_staff_row['t_code']));
$us->edomain = $we_staff_row['edomain'];
$us->ename = $we_staff_row['ename'];
$us->eshortname = $we_staff_row['eshortname'];
$us->total_point = $we_staff_row['total_point'];
$us->level = \Justsy\BaseBundle\Common\ExperienceLevel::getLevel($us->total_point);
$us->vip_level = empty($we_staff_row['vip_level']) ? '1' : $we_staff_row['vip_level'];
$us->auth_level = empty($we_staff_row['auth_level']) ? 'J' : $we_staff_row['auth_level'];
if ($us->auth_level != 'S') {
$us->vip_level = $us->level;
}
$us->eno_level = $we_staff_row['eno_level'];
$us->we_level = $we_staff_row['we_level'];
foreach ($dataset["we_circle"]["rows"] as &$row) {
$us->circle_ids[] = $row['circle_id'];
$us->circle_names[] = $row['circle_name'];
$us->network_domains[] = $row['network_domain'];
$us->circle_logo_path_small[] = $row['logo_path_small'];
}
$us->manager_circles = $this->get_manager_circles($we_staff_row['login_account']);
foreach ($ds["we_function"]["rows"] as &$row) {
$us->function_names[] = $row['name'];
$us->function_codes[] = $row['code'];
$us->function_array[] = array("name" => $row['name'], "code" => $row['code']);
}
foreach ($ds["we_role"]["rows"] as &$row) {
$us->role_names[] = $row['name'];
$us->role_codes[] = $row['code'];
$us->role_array[] = array("name" => $row['name'], "code" => $row['code']);
}
return $us;
} else {
return null;
}
}
public function calcLevel($exprience)
{
return \Justsy\BaseBundle\Common\ExperienceLevel::getLevel($exprience);
}
public function getShareTrendAction($conv_root_id)
{
$FILE_WEBSERVER_URL = $this->container->getParameter('FILE_WEBSERVER_URL');
$user = $this->get('security.context')->getToken()->getUser();
$da = $this->get('we_data_access');
$conv = new \Justsy\BaseBundle\Business\Conv();
$ds = $conv->getShareTrend($da, $user, $conv_root_id, $FILE_WEBSERVER_URL);
if (count($ds["we_convers_list"]["rows"]) == 0) {
return new Response("");
}
if ($ds["we_convers_list"]["rows"][0]["auth_level"] != 'S') {
$ds["we_convers_list"]["rows"][0]["vip_level"] = \Justsy\BaseBundle\Common\ExperienceLevel::getLevel($ds["we_convers_list"]["rows"][0]["total_point"]);
} else {
$ds["we_convers_list"]["rows"][0]["vip_level"] = "1";
//
}
$css_level = (int) ($ds["we_convers_list"]["rows"][0]["we_level"] / 10);
return $this->render('JustsyBaseBundle:CDisplayArea:sharetrend.html.twig', array('this' => $this, 'ds' => $ds, 'css_level' => $css_level, 'trend' => $this->getRequest()->get("trend")));
}
function getUserInfo($username)
{
$DataAccess = $this->container->get('we_data_access');
$curuser = $this->get('security.context')->getToken()->getUser();
if (Utils::validateEmail($username)) {
//帐号
$sqls = "select f_checkAttentionWithAccount(?,a.login_account) attention,a.login_account, a.nick_name, a.photo_path_big, a.password, a.dept_id, a.eno,a.fafa_jid,a.duty,a.work_phone,a.mobile,date_format(a.birthday,'%Y-%c-%d') birthday, b.edomain, b.ename, b.eshortname, c.dept_name ,\n\t\t\t\t\tifnull(a.self_desc,'未设置个性签名') self_desc,ifnull(a.we_level, 0) we_level,b.vip_level,a.auth_level,a.total_point, a.attenstaff_num, a.fans_num, a.publish_num,ifnull(d.id,0) addcard from we_staff a\n\t\t\t\t\t join we_enterprise b on a.eno=b.eno\n\t\t\t\t\t left join we_department c on a.eno=c.eno and a.dept_id=c.dept_id \n\t\t\t\t\t left join we_addrlist_main d on d.owner=? and d.typeid='M001' and d.addr_account=a.login_account\n\t\t\t\t\twhere a.login_account=? ";
$params = array($curuser->getUsername(), $curuser->getUsername(), (string) $username);
} else {
$userNameAry = $this->parseUserName($username);
$sqls = "select f_checkAttentionWithAccount(?,a.login_account) attention,a.login_account, a.nick_name, a.photo_path_big, a.password, a.dept_id, a.eno,a.fafa_jid,a.duty,a.work_phone,a.mobile,date_format(a.birthday,'%Y-%c-%d') birthday, b.edomain, b.ename, b.eshortname, c.dept_name ,\n\t\t\t\t\tifnull(a.self_desc,'未设置个性签名') self_desc,ifnull(a.we_level, 0) we_level,b.vip_level,a.auth_level,a.total_point, a.attenstaff_num, a.fans_num, a.publish_num,ifnull(d.id,0) addcard from we_staff a\n\t\t\t\t\t join we_enterprise b on a.eno=b.eno\n\t\t\t\t\t left join we_department c on a.eno=c.eno and a.dept_id=c.dept_id \n\t\t\t\t\t left join we_addrlist_main d on d.owner=? and d.typeid='M001' and d.addr_account=a.login_account\n\t\t\t\t\twhere a.nick_name=? and b.eshortname=?";
$params = array($curuser->getUsername(), $curuser->getUsername(), (string) $userNameAry[0], (string) $userNameAry[1]);
}
$dataset = $DataAccess->GetData("we_staff", $sqls, $params);
if ($dataset && $dataset["we_staff"]["recordcount"] > 0) {
$this->isSelf = $curuser->getUsername() == $dataset["we_staff"]["rows"][0]["login_account"];
$dataset["we_staff"]["rows"][0]["vip_level"] = $dataset["we_staff"]["rows"][0]["auth_level"] != 'S' ? \Justsy\BaseBundle\Common\ExperienceLevel::getLevel($dataset["we_staff"]["rows"][0]["total_point"]) : "1";
return $dataset["we_staff"]["rows"][0];
} else {
return "";
}
}