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 } }