/**
*功能:返回采购员负责的SKU信息
*@param $purid 采购员编号
*@param $skulist SKU
*日期:2013/08/06
*作者:王民伟
*/
public static function getSkuByPurId($purid, $skulist)
{
self::initDB();
$inskulist = '';
if (!empty($skulist)) {
for ($i = 0; $i < count($skulist); $i++) {
$inskulist .= "'" . $skulist[$i] . "',";
}
}
$info = "SELECT a.sku, a.purchase_days, a.alert_days, a.stock_qty, a.everyday_sale, a.autointerceptnums, a.interceptnums, a.waiting_send, b.warehouseid, b.partnerid FROM " . C('DB_PREFIX') . "sku_info_tmp AS a ";
$info .= "LEFT JOIN pc_goods AS b ON a.sku = b.sku WHERE b.purchaseId = '{$purid}' AND b.is_delete = 0 ";
if (!empty($inskulist)) {
$info .= "AND a.sku in ({$inskulist})";
}
$query = self::$dbConn->query($info);
if ($query) {
$list = self::$dbConn->fetch_array_all($query);
if (!empty($list)) {
return $list;
} else {
self::$errCode = "8004";
self::$errMsg = "返回数据为空";
return false;
}
} else {
self::$errCode = "8001";
self::$errMsg = "查询语句错误";
return false;
}
}
