public static function checkContent($content)
{
self::initDB();
$content = trim($content);
$sql = "select id from " . self::$table . " where content = '{$content}' limit 1";
//echo $sql;
$query = self::$dbConn->query($sql);
if ($query) {
$ret = self::$dbConn->fetch_array_all($query);
return (int) $ret[0]['id'];
//count($ret); //成功， 返回列表数据
} else {
self::$errCode = "003";
self::$errMsg = "error";
return false;
}
}
/**
* CommonModel::getPartnerIdBySku()
* 根据SKU获取供应商ID
* @param string $sku 料号
* @return 供应商ID
* add by wangminwei 2013-11-13
*/
public static function getPartnerIdBySku($sku)
{
self::initDB();
//$sql = "SELECT partnerId FROM pc_goods_partner_relation WHERE sku = '{$sku}'";
$sql = "SELECT partnerId FROM ph_user_partner_relation WHERE sku = '{$sku}'";
$query = self::$dbConn->query($sql);
if ($query) {
$rtn = self::$dbConn->fetch_array_all($query);
if (!empty($rtn)) {
return $rtn[0]['partnerId'];
} else {
return false;
}
} else {
self::$errCode = 10000;
self::$errMsg = "获取数据失败";
return false;
}
}
public static function addIoRecores($paraArr)
{
self::initDB();
$ordersn = isset($paraArr['ordersn']) ? $paraArr['ordersn'] : '';
//发货单号或者是单据的ordersn
$sku = $paraArr['sku'];
//sku
$amount = $paraArr['amount'];
//数量
$positionId = isset($paraArr['positionId']) ? $paraArr['positionId'] : 0;
//仓位ID
$purchaseId = $paraArr['purchaseId'];
//采购员id
$ioType = $paraArr['ioType'];
//出/入库，1为出库，2为入库
$ioTypeId = $paraArr['ioTypeId'];
//出入库类型id，即出入库类型表中对应的id
$userId = $paraArr['userId'];
//添加人id
$reason = isset($paraArr['reason']) ? $paraArr['reason'] : '';
//原因
$storeId = isset($paraArr['storeId']) ? intval($paraArr['storeId']) : 1;
//仓库，默认为1
$createdTime = time();
$tName = 'wh_iorecords';
$set = "SET ordersn='{$ordersn}',sku='{$sku}',amount='{$amount}',positionId='{$positionId}',purchaseId='{$purchaseId}',ioType='{$ioType}',ioTypeId='{$ioTypeId}',userId='{$userId}',reason='{$reason}',createdTime='{$createdTime}',storeId='{$storeId}'";
$sql = "INSERT INTO {$tName} {$set}";
$query = self::$dbConn->query($sql);
if ($query) {
$insertId = self::$dbConn->insert_id($query);
return $insertId;
//成功， 返回插入的id
} else {
self::$errCode = "002";
self::$errMsg = "添加失败";
return false;
//失败则设置错误码和错误信息， 返回false
}
}
