17/01/2025 09:01:05 am >> SELECT document_num FROM ps_document
WHERE document_num = '169' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-17')
17/01/2025 09:01:05 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'169' ,
'2025-01-17' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'9.50' ,
'9.50' ,
NOW() ,
NOW() )
17/01/2025 09:01:05 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95321'
17/01/2025 09:01:05 am >> DELETE FROM ps_document_detail WHERE id_document = '95321'
17/01/2025 09:01:05 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95321' , '22854' , 'MESSALE FESTIVO 2025' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '5' , '9.50' )
17/01/2025 09:15:25 am >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '22809'
17/01/2025 09:16:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736475' AND id_product != '22809' AND ean13 != ''
17/01/2025 09:16:06 am >> UPDATE ps_product SET
id_supplier = '159',
reference = '13/3',
ean13 = '9791280736475',
date_upd = NOW()
WHERE id_product = '22809'
17/01/2025 09:16:06 am >> UPDATE ps_product_lang SET
name = 'O LUCE BEATISSIMA',
description = ''
WHERE id_product = '22809'
17/01/2025 09:16:06 am >> UPDATE ps_product SET
wholesale_price = '0.27',
on_sale = '0',
price = '2.5000'
WHERE id_product = '22809'
17/01/2025 09:16:06 am >> UPDATE ps_product_shop SET
wholesale_price = '0.27',
price = '2.5000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '28',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '22809'
17/01/2025 09:16:06 am >> DELETE FROM ps_specific_price WHERE id_product = '22809'
17/01/2025 09:16:06 am >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '22809' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
17/01/2025 09:58:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000522' AND id_product != '1375' AND ean13 != ''
17/01/2025 09:58:36 am >> UPDATE ps_product SET
id_supplier = '31',
reference = '2014',
ean13 = '000522',
date_upd = NOW()
WHERE id_product = '1375'
17/01/2025 09:58:36 am >> UPDATE ps_product_lang SET
name = 'BRUCIAINCENSI LEGNO - BRUL',
description = ''
WHERE id_product = '1375'
17/01/2025 09:58:36 am >> UPDATE ps_product SET
wholesale_price = '4.10',
on_sale = '0',
price = '8.934426229508198'
WHERE id_product = '1375'
17/01/2025 09:58:36 am >> UPDATE ps_product_shop SET
wholesale_price = '4.10',
price = '8.934426229508198',
id_tax_rules_group = '1',
id_category_default = '169',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '1375'
17/01/2025 09:58:36 am >> DELETE FROM ps_specific_price WHERE id_product = '1375'
17/01/2025 10:03:08 am >> SELECT document_num FROM ps_document
WHERE document_num = '170' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-17')
17/01/2025 10:03:08 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'170' ,
'2025-01-17' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'12.50' ,
'10.25' ,
NOW() ,
NOW() )
17/01/2025 10:03:08 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95322'
17/01/2025 10:03:08 am >> DELETE FROM ps_document_detail WHERE id_document = '95322'
17/01/2025 10:03:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95322' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '5' , '-5' , '1' ,
'2.50' , '2.0491803278689' , '22' , '0' , '12.50' )
17/01/2025 10:11:29 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'31' ,
'G88' ,
'2025-01-15' ,
'' ,
'0' ,
'31' ,
'2626' ,
'ZONA IND.LE PIAN DI LAURA 56043 LORENZANA' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'9' ,
'0' ,
'1040.39' ,
'852.78' ,
NOW() ,
NOW() )
17/01/2025 10:11:29 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95323'
17/01/2025 10:11:29 am >> DELETE FROM ps_document_detail WHERE id_document = '95323'
17/01/2025 10:11:29 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95323' , '15387' , 'VESTINA BATTESIMALE ' , '640' , '640' , '1' ,
'1.03' , '0.84426229508197' , '22' , '3' , '780.0973' )
17/01/2025 10:11:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '31'
17/01/2025 10:11:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '31' , '1' )
17/01/2025 10:11:29 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95323' , '1936' , 'CERETTI DIAM 26X700 ART. 400' , '20' , '20' , '1' ,
'3.76' , '3.0819672131148' , '22' , '50+3' , '44.4958' )
17/01/2025 10:11:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '1936' AND id_supplier = '31'
17/01/2025 10:11:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1936' , '31' , '1' )
17/01/2025 10:11:29 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95323' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '8' , '8' , '1' ,
'9.05' , '7.4180327868852' , '22' , '50+3' , '42.8391' )
17/01/2025 10:11:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '1375' AND id_supplier = '31'
17/01/2025 10:11:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1375' , '31' , '1' )
17/01/2025 10:11:29 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95323' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '200' , '200' , '1' ,
'1.46' , '1.1967213114754' , '22' , '50+3' , '172.7764' )
17/01/2025 10:11:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '31'
17/01/2025 10:11:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '31' , '1' )
17/01/2025 10:11:29 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95323' , '' , 'ARROTONDAMENTO' , '1' , '1' , '1' ,
'0.15' , '0.12295081967213' , '22' , '0' , '0.1830' )
17/01/2025 10:11:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '31'
17/01/2025 10:11:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '31' , '1' )
17/01/2025 10:19:29 am >> SELECT document_num FROM ps_document
WHERE document_num = '171' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-17')
17/01/2025 10:19:29 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'171' ,
'2025-01-17' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'9.41' ,
'9.41' ,
NOW() ,
NOW() )
17/01/2025 10:19:29 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95324'
17/01/2025 10:19:29 am >> DELETE FROM ps_document_detail WHERE id_document = '95324'
17/01/2025 10:19:29 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95324' , '1090' , 'BIBBIA' , '1' , '-1' , '4' ,
'9.90' , '9.9' , '0' , '5' , '9.41' )
17/01/2025 10:28:19 am >> SELECT document_num FROM ps_document
WHERE document_num = '172' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-17')
17/01/2025 10:28:19 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'172' ,
'2025-01-17' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'6.00' ,
'5.77' ,
NOW() ,
NOW() )
17/01/2025 10:28:19 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95325'
17/01/2025 10:28:19 am >> DELETE FROM ps_document_detail WHERE id_document = '95325'
17/01/2025 10:28:19 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95325' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '3' , '-3' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '6.00' )
17/01/2025 10:37:30 am >> SELECT document_num FROM ps_document
WHERE document_num = '173' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-17')
17/01/2025 10:37:30 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'173' ,
'2025-01-17' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'74.09' ,
'66.07' ,
NOW() ,
NOW() )
17/01/2025 10:37:30 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95326'
17/01/2025 10:37:30 am >> DELETE FROM ps_document_detail WHERE id_document = '95326'
17/01/2025 10:37:30 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95326' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' ,
'13.00' , '10.655737704918' , '22' , '0' , '13.00' )
17/01/2025 10:37:30 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95326' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '35.00' )
17/01/2025 10:37:30 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95326' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' ,
'2.20' , '2.2' , '0' , '5' , '2.09' )
17/01/2025 10:37:30 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95326' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '1' , '-1' , '1' ,
'24.00' , '19.672131147541' , '22' , '0' , '24.00' )
17/01/2025 10:48:02 am >> SELECT document_num FROM ps_document
WHERE document_num = '174' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-17')
17/01/2025 10:48:02 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'174' ,
'2025-01-17' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'253.60' ,
'210.61' ,
NOW() ,
NOW() )
17/01/2025 10:48:02 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95327'
17/01/2025 10:48:02 am >> DELETE FROM ps_document_detail WHERE id_document = '95327'
17/01/2025 10:48:02 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95327' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' ,
'8.5' , '6.9672131147541' , '22' , '0' , '51.00' )
17/01/2025 10:48:02 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95327' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' ,
'4.7' , '3.8524590163934' , '22' , '0' , '56.40' )
17/01/2025 10:48:02 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95327' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' ,
'30.00' , '24.590163934426' , '22' , '0' , '30.00' )
17/01/2025 10:48:02 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95327' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' ,
'13.00' , '10.655737704918' , '22' , '0' , '13.00' )
17/01/2025 10:48:02 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95327' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' ,
'70.00' , '57.377049180328' , '22' , '0' , '70.00' )
17/01/2025 10:48:02 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95327' , '22105' , 'CANDELINE NON GOCCIOLANTI IN BUSTA - CHA25' , '1' , '-1' , '1' ,
'18.00' , '14.754098360656' , '22' , '0' , '18.00' )
17/01/2025 10:48:02 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95327' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '1' , '-1' , '4' ,
'16.00' , '16' , '0' , '5' , '15.20' )
17/01/2025 11:15:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736451' AND id_product != '23348' AND ean13 != ''
17/01/2025 11:15:00 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9791280736451',
date_upd = NOW()
WHERE id_product = '23348'
17/01/2025 11:15:00 am >> UPDATE ps_product_lang SET
name = 'ECCE LIGNUM CRUCIS - V. SIRACUSA',
description = 'Camminiamo insieme a Gesù sulla via che lui ha percorso: la Via della Croce, perché possiamo anche noi imparare, come lui, ad
amare, amare sino alla fine, amare senza sconti. Il cardinale Angelo Comastri nel presentare questa Via Crucis scrive: Auguro al lettore di scendere dal calvario con questa certezza meravigliosa nel cuore: Dio è amore! E la croce è l’amore infinito di Dio piantato dentro la nostra orgogliosa inquietudine per vincerla e salvarla!
\"Signore Gesù, il venerdì santo è il giorno dell\'odio senza ragione, il giorno dell\'uccisione del Giusto!
Ma il Venerdì santo non è l\'ultima parola, è la Pasqua il trionfo della vita, la vittoria del bene sul male\".
Card. Angelo Comastri
'
WHERE id_product = '23348'
17/01/2025 11:15:00 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '3.0000'
WHERE id_product = '23348'
17/01/2025 11:15:00 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '3.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '50',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23348'
17/01/2025 11:15:00 am >> DELETE FROM ps_specific_price WHERE id_product = '23348'
17/01/2025 11:15:00 am >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '23348' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
17/01/2025 11:15:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736451' AND id_product != '23348' AND ean13 != ''
17/01/2025 11:15:11 am >> UPDATE ps_product SET
id_supplier = '',
reference = '13/3',
ean13 = '9791280736451',
date_upd = NOW()
WHERE id_product = '23348'
17/01/2025 11:15:11 am >> UPDATE ps_product_lang SET
name = 'ECCE LIGNUM CRUCIS - V. SIRACUSA',
description = 'Camminiamo insieme a Gesù sulla via che lui ha percorso: la Via della Croce, perché possiamo anche noi imparare, come lui, ad
amare, amare sino alla fine, amare senza sconti. Il cardinale Angelo Comastri nel presentare questa Via Crucis scrive: Auguro al lettore di scendere dal calvario con questa certezza meravigliosa nel cuore: Dio è amore! E la croce è l’amore infinito di Dio piantato dentro la nostra orgogliosa inquietudine per vincerla e salvarla!
\"Signore Gesù, il venerdì santo è il giorno dell\'odio senza ragione, il giorno dell\'uccisione del Giusto!
Ma il Venerdì santo non è l\'ultima parola, è la Pasqua il trionfo della vita, la vittoria del bene sul male\".
Card. Angelo Comastri
'
WHERE id_product = '23348'
17/01/2025 11:15:11 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '3.0000'
WHERE id_product = '23348'
17/01/2025 11:15:11 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '3.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '50',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23348'
17/01/2025 11:15:11 am >> DELETE FROM ps_specific_price WHERE id_product = '23348'
17/01/2025 11:15:11 am >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '23348' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
17/01/2025 11:18:54 am >> SELECT document_num FROM ps_document
WHERE document_num = '175' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-17')
17/01/2025 11:18:54 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'175' ,
'2025-01-17' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'20.90' ,
'20.90' ,
NOW() ,
NOW() )
17/01/2025 11:18:54 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95328'
17/01/2025 11:18:54 am >> DELETE FROM ps_document_detail WHERE id_document = '95328'
17/01/2025 11:18:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95328' , '23341' , 'SPERA - PAPA FRANCESCO' , '1' , '-1' , '4' ,
'22.00' , '22' , '0' , '5' , '20.90' )
17/01/2025 11:41:46 am >> SELECT document_num FROM ps_document
WHERE document_num = '176' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-17')
17/01/2025 11:41:46 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'176' ,
'2025-01-17' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'63.28' ,
'63.28' ,
NOW() ,
NOW() )
17/01/2025 11:41:46 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95329'
17/01/2025 11:41:46 am >> DELETE FROM ps_document_detail WHERE id_document = '95329'
17/01/2025 11:41:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95329' , '21713' , 'FEDE SPERANZA E CARITA - R. CANTALAMESSA' , '1' , '-1' , '4' ,
'19.00' , '19' , '0' , '5' , '18.05' )
17/01/2025 11:41:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95329' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '1' , '-1' , '4' ,
'9.50' , '9.5' , '0' , '5' , '9.03' )
17/01/2025 11:41:46 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95329' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '20' , '-20' , '4' ,
'1.90' , '1.9' , '0' , '5' , '36.20' )
17/01/2025 11:46:09 am >> SELECT document_num FROM ps_document
WHERE document_num = '177' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-17')
17/01/2025 11:46:09 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'177' ,
'2025-01-17' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'9.41' ,
'9.41' ,
NOW() ,
NOW() )
17/01/2025 11:46:09 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95330'
17/01/2025 11:46:09 am >> DELETE FROM ps_document_detail WHERE id_document = '95330'
17/01/2025 11:46:10 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95330' , '1090' , 'BIBBIA' , '1' , '-1' , '4' ,
'9.90' , '9.9' , '0' , '5' , '9.41' )
17/01/2025 12:11:33 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1' AND id_document != '' AND id_document_type LIKE '26' AND YEAR(document_date) = YEAR('2025-01-17')
17/01/2025 12:11:33 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'26' ,
'1' ,
'2025-01-17' ,
'' ,
'3581' ,
'0' ,
'4679136' ,
'PIAZZA 4 NOVEMBRE 84039 TEGGIANO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'1062.50' ,
'1062.50' ,
NOW() ,
NOW() )
17/01/2025 12:11:33 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95331'
17/01/2025 12:11:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '95331'
17/01/2025 12:11:33 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95331' , '9338' , 'SACROSANCTUM CONCILIUM' , '500' , '0' , '4' ,
'2.50' , '2.5' , '0' , '15' , '1062.50' )
17/01/2025 03:12:26 pm >> SELECT document_num FROM ps_document
WHERE document_num = '178' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-17')
17/01/2025 03:12:26 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'178' ,
'2025-01-17' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'34.00' ,
'27.87' ,
NOW() ,
NOW() )
17/01/2025 03:12:26 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95332'
17/01/2025 03:12:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '95332'
17/01/2025 03:12:26 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95332' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' ,
'17' , '13.934426229508' , '22' , '0' , '34.00' )
17/01/2025 03:12:41 pm >> SELECT document_num FROM ps_document
WHERE document_num = '179' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-17')
17/01/2025 03:12:41 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'179' ,
'2025-01-17' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'68.00' ,
'55.74' ,
NOW() ,
NOW() )
17/01/2025 03:12:41 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95333'
17/01/2025 03:12:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '95333'
17/01/2025 03:12:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95333' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '4' , '-4' , '1' ,
'17' , '13.934426229508' , '22' , '0' , '68.00' )
17/01/2025 03:22:14 pm >> SELECT document_num FROM ps_document
WHERE document_num = '15/A' AND id_document != '94983' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02')
17/01/2025 03:22:14 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '15/A',
document_date = '2025-01-02',
document_letter = 'A',
id_customer = '3812',
id_supplier = '',
id_address = '4679440',
address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '216.40',
price_tax_excluded = '184.16',
date_upd = NOW()
WHERE id_document = '94983'
17/01/2025 03:22:14 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94983'
17/01/2025 03:22:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '94983'
17/01/2025 03:22:14 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94983' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' ,
'2.0000' , '1.9230769230769' , '4' , '0' , '20.00' )
17/01/2025 03:22:14 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94983' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' ,
'0.7000' , '0.7' , '0' , '0' , '3.50' )
17/01/2025 03:22:14 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94983' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' ,
'8.5000' , '6.9672131147541' , '22' , '0' , '51.00' )
17/01/2025 03:22:14 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94983' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' ,
'4.7000' , '3.8524590163934' , '22' , '0' , '112.80' )
17/01/2025 03:22:14 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94983' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' ,
'3.5000' , '3.3653846153846' , '4' , '0' , '17.50' )
17/01/2025 03:22:14 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94983' , '20758' , 'SEGNALIBRO 5X15' , '35' , '-35' , '1' ,
'0.20' , '0.16393442622951' , '22' , '0' , '7.00' )
17/01/2025 03:22:14 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94983' , '22698' , 'CALENDARIO LITURGICO 2025' , '2' , '-2' , '4' ,
'0.80' , '0.8' , '0' , '0' , '1.60' )
17/01/2025 03:22:14 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94983' , '20629' , 'VITA FRATERNA IN COMUNITA' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '0' , '3.00' )
17/01/2025 03:22:37 pm >> SELECT document_num FROM ps_document
WHERE document_num = '180' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-17')
17/01/2025 03:22:37 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'180' ,
'2025-01-17' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'3.71' ,
'3.71' ,
NOW() ,
NOW() )
17/01/2025 03:22:37 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95334'
17/01/2025 03:22:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '95334'
17/01/2025 03:22:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95334' , '23119' , 'AMEN - FEB 25' , '1' , '-1' , '4' ,
'3.90' , '3.9' , '0' , '5' , '3.71' )
17/01/2025 04:41:14 pm >> SELECT document_num FROM ps_document
WHERE document_num = '10' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-17')
17/01/2025 04:41:14 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'10' ,
'2025-01-17' ,
'' ,
'3496' ,
'0' ,
'4679247' ,
'VIA ALLA BASILICA 1 23808 VERCURAGO' ,
'' ,
'COPIE OMAGGIO AUTORE' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'0.00' ,
'0.00' ,
NOW() ,
NOW() )
17/01/2025 04:41:14 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95335'
17/01/2025 04:41:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '95335'
17/01/2025 04:41:14 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95335' , '22809' , 'O LUCE BEATISSIMA' , '50' , '-50' , '4' ,
'2.50' , '2.5' , '0' , '100' , '0.00' )
17/01/2025 07:28:22 pm >> SELECT document_num FROM ps_document
WHERE document_num = '181' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-17')
17/01/2025 07:28:22 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'181' ,
'2025-01-17' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'17.80' ,
'14.59' ,
NOW() ,
NOW() )
17/01/2025 07:28:22 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95336'
17/01/2025 07:28:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '95336'
17/01/2025 07:28:22 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '95336' , '11389' , 'VINO ROSSO DOLCE - 103' , '2' , '-2' , '1' ,
'8.90' , '7.2950819672131' , '22' , '0' , '17.80' )