private function showUserList()
{
/*获得Amazon message本地用户列表*/
extract($this->generateInfo());
$currentDep = $defaultDep;
$dep = isset($_GET['depname']) ? trim($_GET['depname']) : FALSE;
//部门名称
if (!empty($dep)) {
$currentDep = $dep;
}
$dep_obj = new GetDeptInfoModel();
$dep_info = $dep_obj->getDepartName($currentDep, 1);
//获取部门信息
if (empty($dep_info)) {
//不存在的部门
$promptdata = array('data' => array('使用了不存在的部门信息!'), 'link' => $gobackurl);
goErrMsgPage($promptdata);
exit;
}
$sys_obj = new PowerSystemModel();
$msgsysinfo = $sys_obj->getSysInfoByName('Message');
$localuser_obj = new GetLoacalUserModel();
$userlist = $localuser_obj->getAllMessageUserList($msgsysinfo['system_id'], $dep_info['dept_id']);
$Lp_obj = new LocalPowerAmazonModel();
$cat_obj = new amazonmessagecategoryModel();
//这里只是根据power_user中的user_name和user_company来在global_user_name中获得用户的真实姓名
foreach ($userlist as &$usrval) {
$userinfo = $localuser_obj->getGlobalUserInfoByName(array('global_user_name'), $usrval['user_name'], $usrval['user_company']);
$usrval['realname'] = empty($userinfo) ? '' : $userinfo['global_user_name'];
//print_r($userlist);
/* 文件夹列表 */
//通过power_user中的系统为message,部门为Amazon的用户的user_id来获得其能浏览的所有分类。
$fieldid = $Lp_obj->getUserInfo($usrval['user_id']);
// print_r($fieldid);
if (empty($fieldid) || empty($fieldid['power'])) {
$usrval['localpower'] = '';
} else {
$powerlist = $cat_obj->getFieldInfoByIds($fieldid['power']);
$str = '';
foreach ($powerlist as $pval) {
$str .= '【' . $pval['category_name'] . '】';
}
$usrval['localpower'] = $str;
}
}
/*----- 获得公司部门列表 -----*/
$dept_obj = DeptModel::getInstance();
$department_list = $dept_obj->getDeptLists('*', ' where dept_isdelete=0 and dept_company_id=1');
// print_r($department_list);exit;
$this->smarty->assign('sec_menue', $sec_menue);
$this->smarty->assign('editUrl', $editUrl);
$this->smarty->assign('currentDep', $currentDep);
$this->smarty->assign('skipurl', $gobackurl);
$this->smarty->assign('deptlist', $department_list);
$this->smarty->assign('userlist', $userlist);
$this->smarty->assign('toplevel', 5);
$this->smarty->assign('toptitle', '用户列表');
$this->smarty->display('localuserlistAmazon.htm');
}
/**
* 部门管理页面
*
*/
public function index()
{
//$role_id = I('role_id');
$dName = I('dName');
$type = I('type');
$dept = new DeptModel();
$data = $dept->get_dept_list($dName);
if ('searchDeptList' == $type) {
$data = json_encode($data);
echo $data;
exit;
}
$deptinfodata = $data['data'];
$this->assign('deptinfolist', $deptinfodata);
$this->assign('dName', $dName);
$this->assign('page', $show);
$this->display();
}
public function getDeptLists($filed, $where, $order = '', $limit = '')
{
self::initDB();
$sql = 'SELECT ' . $filed . ' FROM ' . self::$table_dept_info . '
LEFT JOIN ' . self::$table_company_info . ' ON dept_company_id=company_id
' . $where . ' ' . $order . ' ' . $limit;
$query = self::$dbConn->query($sql);
if (!$query) {
self::$errCode = '1803';
self::$errMsg = "[{$sql}] is error";
return false;
}
if ($this->is_count === true) {
$this->is_count = false;
return self::$dbConn->num_rows($query);
}
return self::$dbConn->fetch_array_all($query);
}
/**
* 检查用户密码是否正确
* 检查是否存在此机构号
*
* @param string $head
* @return boolean
*/
private function check($head, &$result)
{
try {
//检查用户/密码
if ($head["user"] != "webbusiness" & $head["pass"] != "web4321") {
$result = $this->createResult($head["type"], -2);
return false;
}
//检查是否有此机构号
if (!trim($head["organid"])) {
$result = $this->createResult($head["type"], -3);
return false;
}
if ($head["organid"] == 'super') {
return true;
}
$model = new DeptModel();
$rs = $model->find("organid = '" . $head["organid"] . "' and type = 'organ'");
if (!$rs) {
$result = $this->createResult($head["type"], -3);
return false;
} else {
$this->company = $rs["DeptNo"];
}
//$this->company = '000003';
return true;
} catch (Exception $e) {
$this->addLog("NotException error from checkUser:"******"type"]);
return false;
}
}
/**
* 添加员工
*
* @param array $data
* @return int $id
*/
private function memberAdd($info)
{
$data["UserNo"] = $info["EmployeeId"];
$data["UserName"] = $info["Name"];
$data["LoginName"] = $info["LoginName"];
$data["Password"] = "******";
$data["Verify"] = "%";
$data["Mobil"] = $info["Mobile"];
$data["Nodetype"] = "x";
$data["OrganId"] = $info["OrganId"];
$data["DeptId"] = $info["DeptId"];
$data["UserId"] = $info["UserId"];
$model = new DeptModel();
if ($info["DeptId"]) {
$result = $model->find("DeptId = '" . $info["DeptId"] . "' and Type ='Department'");
if (!$result) {
$this->addLog("member-no parent dept:" . $info["DeptId"]);
return false;
}
} else {
$result = $model->find("OrganId = '" . $info["OrganId"] . "' and Type ='Organ'");
if (!$result) {
$this->addLog("member-no organ organ:" . $info["OrganId"]);
return false;
}
}
$data["Upnode"] = $result["DeptNo"];
$model = new MemberModel();
//添加
$result = $model->add($data);
return $result;
}
/**
* 计算可用现金
*
* @param string $company
* @param string $group
* @param string $dept
* @param string $year
* @param stirng $month
*/
private function calCash($company, $group, $dept, $year, $month, &$total, &$used, &$balance)
{
$model = new DeptModel();
$sql = "select liquidity from dept where deptno = '{$group}'";
$result = $model->query($sql);
$total = $result[0]["liquidity"] ? $result[0]["liquidity"] : 0;
$sql = "select sum(geted - payed) as used from cashbook,dept where cashbook.deptno = dept.deptno and dept.groups = '{$group}'";
$result = $model->query($sql);
$used = $result[0]["used"] ? $result[0]["used"] : 0;
$balance = $total + $used;
}
private function showUserList($platform)
{
/*获得message本地用户列表*/
extract($this->generateInfo($platform));
$currentDep = $defaultDep;
$dep = isset($_GET['depname']) ? trim($_GET['depname']) : FALSE;
//部门名称
if (!empty($dep)) {
$currentDep = $dep;
} else {
$currentDep = 'eBay客服一部';
}
$dep_obj = new GetDeptInfoModel();
$dep_info = $dep_obj->getDepartmentInfoByName($currentDep, 1);
//获取部门信息
if (empty($dep_info)) {
//不存在的部门
$promptdata = array('data' => array('使用了不存在的部门信息!'), 'link' => $gobackurl);
goErrMsgPage($promptdata);
exit;
}
$sys_obj = new PowerSystemModel();
$msginfo = $sys_obj->getSysInfoByName('Message');
//获取message系统信息
$localuser_obj = new GetLoacalUserModel();
$dept = "(16,95)";
//eBay客服一部、二部部门编号
$deptNew = "(" . $dep_info['dept_id'] . ")";
$userlist = $localuser_obj->getAllMessageUserInfo($msginfo['system_id'], $deptNew);
//$dept);
$Lp_obj = new LocalPowerModel();
$cat_obj = new messagecategoryModel();
foreach ($userlist as $key => &$usrval) {
$userinfo = $localuser_obj->getGlobalUserInfoByName(array('global_user_name', 'global_user_status'), $usrval['user_name'], $usrval['user_company']);
if ($userinfo['global_user_status'] == 0) {
//去除离职人员
unset($userlist[$key]);
continue;
}
$usrval['realname'] = empty($userinfo) ? '' : $userinfo['global_user_name'];
$fieldid = $Lp_obj->{$getpowerfunc}($usrval['user_id']);
if (empty($fieldid['field'])) {
$usrval['localpower'] = '';
} else {
$powerlist = $cat_obj->getFieldInfoByIds($fieldid['field']);
$str = '';
foreach ($powerlist as $pval) {
$str .= '【' . $pval['category_name'] . '】';
}
$usrval['localpower'] = $str;
}
}
$dept_obj = DeptModel::getInstance();
$department_list = $dept_obj->getDeptLists('*', ' where dept_isdelete=0 and dept_company_id=1');
$this->smarty->assign('sec_menue', $sec_menue);
$this->smarty->assign('editUrl', $editUrl);
$this->smarty->assign('currentDep', $currentDep);
$this->smarty->assign('skipurl', $gobackurl);
$this->smarty->assign('deptlist', $department_list);
$this->smarty->assign('userlist', $userlist);
$this->smarty->assign('toplevel', 5);
$this->smarty->assign('toptitle', '用户列表');
$this->smarty->display('localuserlist.htm');
}
/**
* DeptAct::act_delete()
* 删除部门act
* @return string
*/
public function act_delete()
{
$deptId = intval($_POST['deptId']);
if (!$deptId) {
return false;
exit;
}
$result = DeptModel::deptDelete($deptId);
return $result;
}
