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