20 protected $m_sColumnQuoteBegin =
"[";
25 protected $m_sColumnQuoteEnd =
"]";
30 protected $m_aCatalogTables = [
48 "CouponSummaryActivity",
52 "CustomerCardDetails",
56 "DesignPropertyGroup",
57 "DiscountProductGroups",
58 "DiscountRestrictionList",
70 "GFSPackageDimension",
72 "InitialisationStatus",
76 "ML_TEMP_PRINTING_TABLE",
79 "OCCOptionalCurrencies",
81 "OCCProviderAttributes",
90 "OutstandingCouponChanges",
91 "OutstandingOrderChanges",
92 "OutstandingStockChanges",
95 "PaymentMethodLocations",
96 "PaymentMethodRegions",
98 "PaymentRegionLocations",
101 "PreprocessedTaxTable",
109 "SearchAttributeChoicesOrder",
110 "SearchGeneralFilterGroups",
113 "Section Classifications",
119 "SSPOnlineErrorData",
121 "SSPProviderClasses",
122 "SSPProviderFeature",
123 "SSPProviderFeatureSetup",
124 "SSPProviderVersions",
129 "TaxOrderOpaqueData",
134 "UserDefinedProperties",
167 $sQuery =
"INSERT INTO $sTableQuoted (" . $sColumnList .
") VALUES (" . $sValueList .
");";
168 $nResult = $this->m_oDB->exec($sQuery);
170 return $this->m_oDB->lastInsertId();
182 return str_replace(
"'",
"''", $sData);
194 $sSelectSQL =
"SELECT";
195 if (!empty($aQuery[
"limit"]))
197 $sSelectSQL .=
" TOP $aQuery[limit] ";
199 if (!empty($aQuery[
"select"]))
201 $sSelectSQL .=
" $aQuery[select] ";
205 $sSelectSQL .=
" * ";
207 if (!empty($aQuery[
"from"]))
209 $sSelectSQL .=
"FROM ";
210 if (!empty($aQuery[
"join"]))
212 $sSelectSQL .=
"($aQuery[from] $aQuery[join])";
216 $sSelectSQL .=
"$aQuery[from] ";
219 if (!empty($aQuery[
"where"]))
221 $sSelectSQL .=
"WHERE $aQuery[where] ";
223 if (!empty($aQuery[
"group_by"]))
225 $sSelectSQL .=
"GROUP BY $aQuery[group_by] ";
227 if (!empty($aQuery[
"order_by"]))
229 $sSelectSQL .=
"ORDER BY $aQuery[order_by] ";
243 return $bData ? 1 : 0;
static get($sChannel="default", $sLogRoot="")
CompileSelectSql($aQuery=[])
QuoteValueList($aUnquotedArray, $sSeparator=", ")
QuoteColumnList($aUnquotedArray, $sSeparator=", ")
BasicInsert($sTable, $aValues)