/**
* 功能：自动生成邮箱地址
* @author wxb
* 日期：2013/10/31
* */
function act_createEmailField()
{
$table = "power_global_user";
$filed = "global_user_id";
$where = " global_user_is_delete = 0 AND global_user_status = 1 ";
$ret = NoticeApiModel::selectOneTable($table, $filed, $where);
if (!$ret) {
exit('search user fail');
}
$err = array();
$rightCount = 0;
foreach ($ret as $val) {
$where = " global_user_status = 1 AND global_user_is_delete = 0 AND global_user_id = '{$val['global_user_id']}' ";
$loginName = NoticeApiModel::selectOneTable($table, 'global_user_login_name', $where);
if (!$loginName[0]['global_user_login_name']) {
$err[] = $val['global_user_id'];
continue;
}
$loginName = $loginName[0]['global_user_login_name'];
$email = $loginName . "@sailvan.com";
$res = UserModel::createEmailField($email, $where);
if (!$res) {
$err[] = $val['global_user_id'];
} else {
$rightCount++;
}
}
var_dump(count($ret), $rightCount, $err);
}
/**
* UserModel::userLogin()
* 用户登录走开放系统
* add by 管拥军 2013-08-21
*
* @return bool
*/
public static function userLogin($username, $password)
{
$paramArr = array('method' => 'power.user.login.get', 'format' => 'json', 'v' => '1.0', 'username' => 'notice', 'user_name' => $username, 'pwd' => rawurldecode($password), 'sysName' => self::$sysName, 'sysToken' => self::$sysToken);
$loginInfo = callOpenSystem($paramArr);
unset($paramArr);
$loginInfo = json_decode($loginInfo);
if (isset($loginInfo->errCode)) {
echo $loginInfo->errMsg;
self::$errCode = $loginInfo->errCode;
self::$errMsg = $loginInfo->errMsg;
return false;
}
if (isset($loginInfo->error_response)) {
echo $loginInfo->error_response->msg;
self::$errCode = $loginInfo->error_response->code;
self::$errMsg = $loginInfo->error_response->msg;
return false;
}
$_SESSION['userToken'] = $loginInfo->userToken;
$_SESSION['sysUserId'] = $loginInfo->userId;
// 分系统用户ID
$_SESSION['userId'] = $loginInfo->globalUserId;
// 统一用户系统ID
$_SESSION['userName'] = $loginInfo->userName;
$_SESSION['companyId'] = $loginInfo->company;
//获取中文名
$table = "`power_global_user`";
$filed = "global_user_name";
$where = " global_user_is_delete = 0 AND global_user_status = 1 AND global_user_login_name='{$username}' LIMIT 1";
$ret = NoticeApiModel::selectOneTable($table, $filed, $where);
if ($ret) {
$cnName = $ret[0]['global_user_name'];
}
$_SESSION['cnName'] = $cnName;
$isAdmin = '0';
$_SESSION['isAdmin'] = $isAdmin;
log::write(var_export($_SESSION, true), log::DEBUG);
return "ok";
}
public function selectOneTable($table, $filed, $where)
{
return NoticeApiModel::selectOneTable($table, $filed, $where);
}
/**
* 功能：拉取某个用户收到的信息 包括短信和邮件
* @param str $from ,str $type,str $pageGet 页码,str $perNum 每页数据条数
* @return
* @author wxb
* 日期：2013/10/28
*/
public function act_getAllRecByTo()
{
//notice.NoticeApi.getAllRecByTo
if (empty($_GET['type']) || empty($_GET['to'])) {
//必传参数
self::$errCode = '113';
self::$errMsg = 'param error';
return null;
} else {
$type = trim($_GET['type']);
$to = trim($_GET['to']);
//登入名
}
$pageGet = trim($_GET['page']);
//请求页码
$perNum = !empty($_GET['perNum']) ? trim($_GET['perNum']) : 50;
//指定每页显示条数
if ($type == 'email') {
$table = "nt_email";
} elseif ($type == 'sms') {
$table = "nt_sms";
}
$filed = "*";
$nameWhere = " global_user_status = 1 AND global_user_is_delete = 0 AND global_user_login_name='{$to}' LIMIT 1 ";
$userName = NoticeApiModel::selectOneTable("`power_global_user` ", "global_user_name", $nameWhere);
$userName = $userName[0]['global_user_name'];
$where = " is_delete =0 AND to_name ='{$userName}' ";
$total = NoticeApiModel::selectOneTable($table, $filed, $where, $count = '1');
if ($total) {
$total = $total[0]['total'];
} else {
self::$errCode = '124';
self::$errMsg = 'get count recor error';
return null;
}
$page = new Page($total, $perNum, $pa = '', $lang = 'CN');
$list = NoticeApiModel::selectOneTable($table, $filed, $where . " " . $page->limit);
self::$errCode = '001';
self::$errMsg = 'get recor success';
return array($list, $total);
}
