@isoftdata/universal-object-htp-utility - npm Package Compare versions

Comparing version 3.19.0 to 3.19.1

dist/payment.d.ts

@@ -5,5 +5,5 @@ export declare function upsertPaymentRows(connection: any, paymentArr: any, productCode: any): Promise<{
 }>;
-export declare function deletePaymentRow(connection: any, productCode: any, htpPaymentId: any): Promise<{
+export declare function deletePaymentRow(connection: any, productCode: any, storeId: any, paymentId: any): Promise<{
     success: boolean;
     data: any;
 }>;

dist/payment.js

@@ -33,8 +33,8 @@ import { multiRowUpsertQuery, write } from './shared.js';
 }
-export async function deletePaymentRow(connection, productCode, htpPaymentId) {
+export async function deletePaymentRow(connection, productCode, storeId, paymentId) {
     const responses = [];
     try {
         const queryOptions = {
-            sql: `DELETE FROM payment WHERE productcode = ? AND htppaymentid = ?`,
-            values: [productCode, htpPaymentId],
+            sql: `DELETE FROM payment WHERE productcode = ? AND storeid = ? AND paymentid = ?`,
+            values: [productCode, storeId, paymentId],
         };
@@ -41,0 +41,0 @@ const deleteResponse = await write(connection, queryOptions);

dist/paymentLine.d.ts

@@ -5,5 +5,5 @@ export declare function upsertPaymentLineRows(connection: any, paymentLineArr: any, productCode: any): Promise<{
 }>;
-export declare function deletePaymentLineRow(connection: any, productCode: any, htpPaymentLineId: any): Promise<{
+export declare function deletePaymentLineRow(connection: any, productCode: any, storeId: any, paymentId: any, paymentLineId: any): Promise<{
     success: boolean;
     data: any;
 }>;

dist/paymentLine.js

@@ -31,8 +31,8 @@ import { multiRowUpsertQuery, write } from './shared.js';
 }
-export async function deletePaymentLineRow(connection, productCode, htpPaymentLineId) {
+export async function deletePaymentLineRow(connection, productCode, storeId, paymentId, paymentLineId) {
     const responses = [];
     try {
         const queryOptions = {
-            sql: `DELETE FROM paymentline WHERE productcode = ? AND htppaymentlineid = ?`,
-            values: [productCode, htpPaymentLineId],
+            sql: `DELETE FROM paymentline WHERE productcode = ? AND storeid = ? AND paymentid = ? AND paymentlineid = ?`,
+            values: [productCode, storeId, paymentId, paymentLineId],
         };
@@ -39,0 +39,0 @@ const deleteResponse = await write(connection, queryOptions);

dist/salesOrder.d.ts

@@ -5,5 +5,5 @@ export declare function upsertSalesOrderRows(connection: any, salesOrderArr: any, productCode: any): Promise<{
 }>;
-export declare function deleteSalesOrderRow(connection: any, productCode: any, htpSalesOrderId: any): Promise<{
+export declare function deleteSalesOrderRow(connection: any, productCode: any, salesOrderId: any, storeId: any): Promise<{
     success: boolean;
     data: any;
 }>;

dist/salesOrder.js

@@ -71,8 +71,8 @@ import { multiRowUpsertQuery, write } from './shared.js';
 }
-export async function deleteSalesOrderRow(connection, productCode, htpSalesOrderId) {
+export async function deleteSalesOrderRow(connection, productCode, salesOrderId, storeId) {
     const responses = [];
     try {
         const queryOptions = {
-            sql: `DELETE FROM salesorder WHERE productcode = ? AND htpsalesorderid = ?`,
-            values: [productCode, htpSalesOrderId],
+            sql: `DELETE FROM salesorder WHERE productcode = ? AND storeid = ? AND salesorderid = ?`,
+            values: [productCode, storeId, salesOrderId],
         };
@@ -79,0 +79,0 @@ const deleteResponse = await write(connection, queryOptions);

dist/salesOrderAdjustment.d.ts

@@ -5,5 +5,5 @@ export declare function upsertSalesOrderAdjustmentRows(connection: any, salesOrderAdjustmentArr: any, productCode: any): Promise<{
 }>;
-export declare function deleteSalesOrderAdjustmentRow(connection: any, productCode: any, htpSalesOrderAdjustmentId: any): Promise<{
+export declare function deleteSalesOrderAdjustmentRow(connection: any, productCode: any, salesOrderId: any, salesOrderLineId: any, salesOrderStoreId: any, salesOrderAdjustmentId: any): Promise<{
     success: boolean;
     data: any;
 }>;

dist/salesOrderAdjustment.js

@@ -36,8 +36,8 @@ import { multiRowUpsertQuery, write } from './shared.js';
 }
-export async function deleteSalesOrderAdjustmentRow(connection, productCode, htpSalesOrderAdjustmentId) {
+export async function deleteSalesOrderAdjustmentRow(connection, productCode, salesOrderId, salesOrderLineId, salesOrderStoreId, salesOrderAdjustmentId) {
     const responses = [];
     try {
         const queryOptions = {
-            sql: `DELETE FROM salesorderadjustment WHERE productcode = ? AND htpsalesorderadjustmentid = ?`,
-            values: [productCode, htpSalesOrderAdjustmentId],
+            sql: `DELETE FROM salesorderadjustment WHERE productcode = ? AND salesorderid = ? AND salesorderlineid = ? AND salesorderstoreid = ? AND salesorderadjustmentid = ?`,
+            values: [productCode, salesOrderId, salesOrderLineId, salesOrderStoreId, salesOrderAdjustmentId],
         };
@@ -44,0 +44,0 @@ const deleteResponse = await write(connection, queryOptions);

dist/salesOrderLineRow.d.ts

@@ -5,5 +5,5 @@ export declare function upsertSalesOrderLineRows(connection: any, salesOrderLineArr: any, productCode: any): Promise<{
 }>;
-export declare function deleteSalesOrderLineRow(connection: any, productCode: any, htpSalesOrderLineId: any): Promise<{
+export declare function deleteSalesOrderLineRow(connection: any, productCode: any, storeId: any, salesOrderId: any, salesOrderLineId: any): Promise<{
     success: boolean;
     data: any;
 }>;

dist/salesOrderLineRow.js

@@ -77,8 +77,8 @@ import { multiRowUpsertQuery, write } from './shared.js';
 }
-export async function deleteSalesOrderLineRow(connection, productCode, htpSalesOrderLineId) {
+export async function deleteSalesOrderLineRow(connection, productCode, storeId, salesOrderId, salesOrderLineId) {
     const responses = [];
     try {
         const queryOptions = {
-            sql: `DELETE FROM salesorderline WHERE productcode = ? AND htpsalesorderlineid = ?`,
-            values: [productCode, htpSalesOrderLineId],
+            sql: `DELETE FROM salesorderline WHERE productcode = ? AND storeid = ? AND salesorderid = ? AND salesorderlineid = ?`,
+            values: [productCode, storeId, salesOrderId, salesOrderLineId],
         };
@@ -85,0 +85,0 @@ const deleteResponse = await write(connection, queryOptions);

package.json

 {
   "name": "@isoftdata/universal-object-htp-utility",
-  "version": "3.19.0",
+  "version": "3.19.1",
   "description": "Functions to convert universal objects to htp schema",
@@ -5,0 +5,0 @@ "main": "dist/index.js",

payment.ts

@@ -36,8 +36,8 @@ import { multiRowUpsertQuery, write } from './shared.js'
 
-export async function deletePaymentRow(connection, productCode, htpPaymentId) {
+export async function deletePaymentRow(connection, productCode, storeId, paymentId) {
     const responses = []
     try {
 		const queryOptions = {
-			sql: `DELETE FROM payment WHERE productcode = ? AND htppaymentid = ?`,
-			values: [productCode, htpPaymentId],
+			sql: `DELETE FROM payment WHERE productcode = ? AND storeid = ? AND paymentid = ?`,
+			values: [productCode, storeId, paymentId],
 		}
@@ -44,0 +44,0 @@ const deleteResponse = await write(connection, queryOptions)

paymentLine.ts

@@ -34,8 +34,8 @@ import { multiRowUpsertQuery, write } from './shared.js'
 
-export async function deletePaymentLineRow(connection, productCode, htpPaymentLineId) {
+export async function deletePaymentLineRow(connection, productCode, storeId, paymentId, paymentLineId) {
     const responses = []
     try {
         const queryOptions = {
-            sql: `DELETE FROM paymentline WHERE productcode = ? AND htppaymentlineid = ?`,
-            values: [productCode, htpPaymentLineId],
+            sql: `DELETE FROM paymentline WHERE productcode = ? AND storeid = ? AND paymentid = ? AND paymentlineid = ?`,
+            values: [productCode, storeId, paymentId, paymentLineId],
         }
@@ -42,0 +42,0 @@ const deleteResponse = await write(connection, queryOptions)

salesOrder.ts

@@ -74,8 +74,8 @@ import { multiRowUpsertQuery, write } from './shared.js'
 
-export async function deleteSalesOrderRow(connection, productCode, htpSalesOrderId) {
+export async function deleteSalesOrderRow(connection, productCode, salesOrderId, storeId) {
     const responses = []
     try {
 		const queryOptions = {
-			sql: `DELETE FROM salesorder WHERE productcode = ? AND htpsalesorderid = ?`,
-			values: [productCode, htpSalesOrderId],
+			sql: `DELETE FROM salesorder WHERE productcode = ? AND storeid = ? AND salesorderid = ?`,
+			values: [productCode, storeId, salesOrderId],
 		}
@@ -82,0 +82,0 @@ const deleteResponse = await write(connection, queryOptions)

salesOrderAdjustment.ts

@@ -39,8 +39,8 @@ import { multiRowUpsertQuery, write } from './shared.js'
 
-export async function deleteSalesOrderAdjustmentRow(connection, productCode, htpSalesOrderAdjustmentId) {
+export async function deleteSalesOrderAdjustmentRow(connection, productCode, salesOrderId, salesOrderLineId, salesOrderStoreId, salesOrderAdjustmentId ) {
     const responses = []
     try {
 		const queryOptions = {
-			sql: `DELETE FROM salesorderadjustment WHERE productcode = ? AND htpsalesorderadjustmentid = ?`,
-			values: [productCode, htpSalesOrderAdjustmentId],
+			sql: `DELETE FROM salesorderadjustment WHERE productcode = ? AND salesorderid = ? AND salesorderlineid = ? AND salesorderstoreid = ? AND salesorderadjustmentid = ?`,
+			values: [productCode, salesOrderId, salesOrderLineId, salesOrderStoreId, salesOrderAdjustmentId],
 		}
@@ -47,0 +47,0 @@ const deleteResponse = await write(connection, queryOptions)

salesOrderLineRow.ts

@@ -80,8 +80,8 @@ import { multiRowUpsertQuery, write } from './shared.js'
 
-export async function deleteSalesOrderLineRow(connection, productCode, htpSalesOrderLineId) {
+export async function deleteSalesOrderLineRow(connection, productCode, storeId, salesOrderId, salesOrderLineId) {
     const responses = []
     try {
 		const queryOptions = {
-			sql: `DELETE FROM salesorderline WHERE productcode = ? AND htpsalesorderlineid = ?`,
-			values: [productCode, htpSalesOrderLineId],
+			sql: `DELETE FROM salesorderline WHERE productcode = ? AND storeid = ? AND salesorderid = ? AND salesorderlineid = ?`,
+			values: [productCode, storeId, salesOrderId, salesOrderLineId],
 		}
@@ -88,0 +88,0 @@ const deleteResponse = await write(connection, queryOptions)

New alerts

URL strings

Supply chain risk

Package contains fragments of external URLs or IP addresses, which the package may be accessing at runtime.

Fixed alerts

Major refactor

Supply chain risk

Package has recently undergone a major refactor. It may be unstable or indicate significant internal changes. Use caution when updating to versions that include significant changes.

URL strings

Supply chain risk

Package contains fragments of external URLs or IP addresses, which the package may be accessing at runtime.

Improved metrics

Total package byte prevSize

319565

0.27%

Number of medium supply chain risk alerts

0

-100%

No dependency changes