/**
*通过sku 获取供应商名
*@param str $sku
*@author wxb
*/
public static function getComNameBySku($sku)
{
self::initDB();
$sql = "SELECT p.username FROM `" . self::$prefix . "partner` AS p ";
$sql .= " LEFT JOIN " . self::$prefix . "goods_partner_relation AS gp ";
$sql .= " ON p.id = gp.partnerId ";
$sql .= " WHERE gp.sku = '{$sku}' LIMIT 1";
$query = self::$dbConn->query($sql);
if ($query) {
$ret = self::$dbConn->fetch_array_all($query);
if ($ret[0]['username']) {
return $ret[0]['username'];
} else {
self::$errMsg = "result empty " . $sql;
return false;
}
} else {
self::$errMsg = "query wrong " . $sql;
return false;
}
}
/**
*通过id 获取中文名
*@param str $sku
*@author wxb
*/
public function getComNameBySku($sku)
{
$ret = UnusualOrderModel::getComNameBySku($sku);
self::$errMsg = UnusualOrderModel::$errMsg;
return $ret;
}
