/** * 功能:自动生成邮箱地址 * @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); }