public static function addgetWhInfo($set)
{
self::initDB();
$sql = "INSERT INTO wh_sample_info {$set}";
echo $sql . '<br>';
if (!self::$dbConn->query($sql)) {
self::$errCode = "1801";
self::$errMsg = "wh_sample_info";
return false;
} else {
return self::$dbConn->affected_rows();
}
}
public static function getModifyNum($sku)
{
self::initDB();
$start = date('Y') . "-" . date('m') . "-01";
$start = strtotime($start);
$end = time();
$sql = "SELECT count(*) as num FROM qc_sample_pending_products where sku='{$sku}' and modifyStatus=1 and startTime between {$start} and {$end} ";
//echo $sql . '<br>';
$query = self::$dbConn->query($sql);
if ($query) {
$ret = self::$dbConn->fetch_array_all($query);
return $ret[0]['num'];
} else {
self::$errCode = "1601";
self::$errMsg = "getWhInfo";
return false;
}
}
