/** * 功能:通过采购员的id获取名字 * @param str $id * @return void * @author wxb * @date 2013/11/8 */ public static function purchaseNameById($id) { if (empty($id)) { self::$errCode = "0312"; self::$errMsg = "id empty"; return false; } self::initDB(); $sql = "SELECT global_user_name FROM " . self::$usertab; $sql .= " WHERE global_user_is_delete =0 AND global_user_status = 1 AND global_user_id = {$id} LIMIT 1"; $query = self::$dbConn->query($sql); if ($query) { $ret = self::$dbConn->fetch_array($query); return $ret['global_user_name']; } else { self::$errCode = "0338"; self::$errMsg = "mysql:" . $sql . " error"; return false; } }
public static function getMaterInfo() { global $memc_obj; $cacheName = md5("om_pmInfo"); $list = $memc_obj->get_extral($cacheName); if ($list) { return $list; } else { require_once WEB_PATH . "api/include/functions.php"; $url = 'http://gw.open.valsun.cn:88/router/rest?'; $paramArr = array('method' => 'pc.getPmInfoAll', 'format' => 'json', 'v' => '1.0', 'username' => 'purchase'); $result = callOpenSystem($paramArr); $data = json_decode($result, true); if (!$data['data']) { self::$errCode = 101; self::$errMsg = "没取到值!"; return false; } else { $isok = $memc_obj->set_extral($cacheName, $data['data']); if (!$isok) { self::$errCode = 102; self::$errMsg = 'memcache缓存账号信息出错!'; return $data['data']; } return $data['data']; } } }
public static function getPropertyRelationList($id) { self::initDB(); $sql = "SELECT a.propertyId,b.propertyName FROM pc_goods_property_relation AS a \n\t\t\t\t LEFT JOIN pc_goods_property as b on a.propertyId=b.id WHERE a.goodsId='{$id}'"; $query = self::$dbConn->query($sql); if ($query) { $ret = self::$dbConn->fetch_array_all($query); return $ret; } else { self::$errCode = "003"; self::$errMsg = "444444444"; return false; } }