Example #1
0
 public static function updateUserCompetence($nameList, $smsnum)
 {
     self::initDB();
     $successnum = 0;
     $success = array();
     $error = array();
     //设置批量修改记录标志变量
     foreach ($nameList as $from) {
         $table = "`power_global_user`";
         //获取用户的global_user_id
         $filed = "global_user_id";
         $where = " global_user_status = 1 AND global_user_is_delete = 0 AND (global_user_login_name = '{$from}' OR global_user_name = '{$from}')  LIMIT 1 ";
         $ret = self::selectOneTable($table, $filed, $where);
         if (!$ret[0]['global_user_id']) {
             self::$errCode = "1057";
             self::$errMsg = "获取用户资料失败";
             return false;
         }
         $from = $ret[0]['global_user_id'];
         $username = $ret[0]['global_user_name'];
         $field = "num";
         $sql = "SELECT {$field} FROM `" . C('PREFIX') . self::$tabsmspower . "` WHERE 1 AND `global_user_id` = '{$from}' AND `is_delete` = 0 LIMIT 1 ";
         $query = self::$dbConn->query($sql);
         $sumnum = self::$dbConn->fetch_array_all($query);
         //查询在nt_sms_power中是否有sms_num记录
         if ($sumnum) {
             //存在记录则更新
             $field = "num";
             $sql = "UPDATE " . C('PREFIX') . self::$tabsmspower . " SET num = '{$smsnum}' WHERE global_user_id = '{$from}'";
             $query = self::$dbConn->query($sql);
             if ($query) {
                 $affectedrows = self::$dbConn->affected_rows();
                 $successnum++;
                 array_push($success, $username);
             } else {
                 array_push($error, $username);
             }
         } else {
             //不存在记录则插入
             $data = array("global_user_id" => $from, "num" => $smsnum, "is_delete" => "0");
             $def = array2sql($data);
             //将数组转为SET后面的sql语句
             $def = "INSERT INTO `" . C('PREFIX') . self::$tabsmspower . "` SET " . $def;
             $query = self::$dbConn->query($def);
             if ($query) {
                 $successnum++;
                 array_push($success, $username);
             } else {
                 array_push($error, $username);
             }
         }
     }
     if ($successnum === count($nameList)) {
         return array("ret" => "ok", "success" => $success);
     } else {
         return array("ret" => "no", "errorUser" => $error, "success" => $success);
     }
 }
Example #2
0
 /**
  * UserCompetenceModel::showCompetence($uid)
  * 查看用户权限
  * @param int $uid 用户id
  * @return  array
  */
 public static function showCompetence($uid)
 {
     self::initDB();
     $sql = "SELECT * FROM " . self::$prefix . self::$table_user . " WHERE user_id = {$uid}";
     $query = self::$dbConn->query($sql);
     if ($query) {
         $affectedrows = self::$dbConn->affected_rows();
         if ($affectedrows) {
             $ret = self::$dbConn->fetch_array_all($query);
             return $ret;
         } else {
             self::$errCode = "10000";
             self::$errMsg = "尚未数据,暂不能修改";
             return false;
         }
     } else {
         self::$errCode = "10001";
         self::$errMsg = "获取数据失败";
         return false;
     }
 }
Example #3
0
 /**
  * UserCompetenceModel::listAccount()
  * 列出某个或全部平台用户帐号
  * @param int $pid 平台ID
  * @return  array
  */
 public static function listAccount($pfid)
 {
     self::initDB();
     if ($pfid == 0) {
         $sql = "SELECT id,account FROM " . self::$table_account . " WHERE is_delete = 0";
     } else {
         $sql = "SELECT id,account FROM " . self::$table_account . " WHERE platformId = {$pfid} AND is_delete = 0";
     }
     //echo $sql;
     $query = self::$dbConn->query($sql);
     if ($query) {
         $ret = self::$dbConn->fetch_array_all($query);
         return $ret;
     } else {
         self::$errCode = "1060";
         self::$errMsg = "获取数据失败";
         return false;
     }
 }
Example #4
0
 /**
  * UserCompetenceModel::getCompetenceById()
  * 获取某个用户开放权限ID信息
  * @param integer $gid 权限ID
  * @return array
  */
 public static function getCompetenceById($gid)
 {
     self::initDB();
     $sql = "SELECT * FROM `" . self::$prefix . self::$table . "` WHERE gid = {$gid}";
     $query = self::$dbConn->query($sql);
     if ($query) {
         return self::$dbConn->fetch_array($query);
     } else {
         self::$errCode = 10000;
         self::$errMsg = "执行SQL语句出错";
         return false;
     }
 }
Example #5
0
 public static function getCompetenceVisiblePlat($uid)
 {
     self::initDB();
     $sql = "SELECT  * FROM wh_userCompetence where globalUserId={$uid}";
     $query = self::$dbConn->query($sql);
     if ($query) {
         $data = array();
         $ret = self::$dbConn->fetch_array($query);
         if (!empty($ret)) {
             $data = array();
             if (!empty($ret['visiblePlatformAccount'])) {
                 $visible_platform_account = json_decode($ret['visiblePlatformAccount'], true);
                 foreach ($visible_platform_account as $key => $value) {
                     $visible_account[] = $key;
                 }
                 $data = array_filter($visible_account);
             }
         }
         return $data;
     } else {
         self::$errCode = "401";
         self::$errMsg = "获取数据失败";
         return false;
     }
 }