Database Shop mit BarcodeShipping

Vergeben Sie hier einen Namen für dieses Modul.

Tragen Sie hier die URL zu Ihrer Datenbank ein.
Beispiel: jdbc:sqlserver:"DATENBANK DOMÄNE":PORT;database="DATENBANK NAME";encrypt=false

Tragen Sie hier den Benutzernamen Ihrer Datenbank ein.

Tragen Sie hier das Passwort zu Ihrer Datenbank ein.

Beispiel:
SELECT
cBestellNr as orderNumber,
b.kBestellung as orderId,
b.dErstellt as orderedAt,
b.dErstellt as createdAt,
v.cVorname + ' ' + v.cName as shipToName,
v.cISO as shipToCountry
FROM tBestellung as b
JOIN ["DATENBANK NAME"].[Verkauf].[vAuftragLieferadresse] as v ON b.kBestellung = kAuftrag
JOIN tLieferschein as tL ON b.kBestellung = tl.kBestellung
WHERE b.tVersandArt_kVersandArt IN (32, 33, 34)
AND NOT EXISTS(
SELECT * FROM tVersand as v WHERE tl.kLieferschein = v.kLieferschein
AND v.cIdentCode != '')

Beispiel:
SELECT TOP 1
cBestellNr as orderNumber,
b.kBestellung as orderId,
cBestellNr as reference,
b.dErstellt as orderedAt,
b.dErstellt as createdAt,
a.cStrasse as shipToStreet,
a.cAdressZusatz as shiptoHouseNumber,
a.cFirma as shipToCompany,
a.cVorname as shipToFirstName,
a.cName as shipToLastName,
a.cISO as shipToCountry,
a.cPLZ as shipToPostCode,
a.cOrt as shipToCity,
a.cTel as shipToPhone,
a.cMail as shipToEmail,
'PROCESSING' as status,
v.kVersandArt as shippingMethod
FROM tBestellung as b
JOIN ["DATENBANK NAME"].[Verkauf].[vAuftragLieferadresse] as a ON b.kBestellung = kAuftrag
JOIN tLieferschein as tL ON b.kBestellung = tl.kBestellung
JOIN tVersand as v ON tl.kLieferschein = v.kLieferschein
WHERE b.kBestellung = :orderId ORDER BY v.kVersand ASC;

Beispiel:
SELECT
kBestellPos as itemId,
b.cArtNr as sku,
b.cArtNr as EAN,
cString as name,
b.fVKNetto as price,
CAST(nAnzahl AS INT) as quantityOrdered,
CAST(nAnzahl AS INT) as quantityInvoiced,
a.fVkNetto as netPrice,
fVKPreis as grossPrice,
fGewicht as weight,
cHerkunftsland as country,
cTaric as commodityCode
FROM tBestellpos as b
JOIN tArtikel as a ON b.tArtikel_kArtikel = a.kArtikel
WHERE tBestellung_kBestellung = :orderId

Beispiel:
UPDATE tVersand SET cIdentCode = :shipment.trackingNumber WHERE kLieferschein = (SELECT TOP 1 kLieferschein FROM tLieferschein WHERE kBestellung = :orderId ORDER BY kLieferschein DESC)