23/03/2023 08:19:22 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
23/03/2023 08:19:22 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20876' , '1' , '' , 'nuovo-prodotto' )
23/03/2023 08:19:22 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'20876' , '1' , '1' , '2' , NOW() , NOW()
)
23/03/2023 08:19:22 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20876' , '0' , '1' , '0' , '0' )
23/03/2023 08:22:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736208' AND id_product != '20876' AND ean13 != ''
23/03/2023 08:22:29 am >> UPDATE ps_product SET
id_supplier = '',
reference = '7/2',
ean13 = '9791280736208',
date_upd = NOW()
WHERE id_product = '20876'
23/03/2023 08:22:29 am >> UPDATE ps_product_lang SET
name = 'HO DATO LORO LA TUA PAROLA - A/B/C',
description = 'Il volume contiene il commento esegetico e pastorale alle letture bibliche domenicali del tempo ordinario A-B-C e si affianca al volume per i Tempi di Avvento, Natale, Quaresima e Pasqua.
'
WHERE id_product = '20876'
23/03/2023 08:22:29 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '20'
WHERE id_product = '20876'
23/03/2023 08:22:29 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '20',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '64',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20876'
23/03/2023 08:22:29 am >> DELETE FROM ps_specific_price WHERE id_product = '20876'
23/03/2023 08:22:29 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' , '20876' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
23/03/2023 08:23:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736208' AND id_product != '20876' AND ean13 != ''
23/03/2023 08:23:23 am >> UPDATE ps_product SET
id_supplier = '',
reference = '7/2',
ean13 = '9791280736208',
date_upd = NOW()
WHERE id_product = '20876'
23/03/2023 08:23:23 am >> UPDATE ps_product_lang SET
name = 'HO DATO LORO LA TUA PAROLA - A/B/C - P. G. VALSECCHI',
description = 'Il volume contiene il commento esegetico e pastorale alle letture bibliche domenicali del tempo ordinario A-B-C e si affianca al volume per i Tempi di Avvento, Natale, Quaresima e Pasqua.
'
WHERE id_product = '20876'
23/03/2023 08:23:23 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '20.0000'
WHERE id_product = '20876'
23/03/2023 08:23:23 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '20.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '64',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20876'
23/03/2023 08:23:23 am >> DELETE FROM ps_specific_price WHERE id_product = '20876'
23/03/2023 08:23:23 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' , '20876' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
23/03/2023 08:23:32 am >> SELECT document_num FROM ps_document
WHERE document_num = '57' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 08:23:32 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 (
'21' ,
'57' ,
'2023-03-23' ,
'' ,
'3496' ,
'0' ,
'4670853' ,
'VIALE GIOVANNI XXIII 4 23808 VERCURAGO' ,
'' ,
'COPIE OMAGGIO AUTORE' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'0.00' ,
'0.00' ,
NOW() ,
NOW() )
23/03/2023 08:23:32 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 = '82418'
23/03/2023 08:23:32 am >> DELETE FROM ps_document_detail WHERE id_document = '82418'
23/03/2023 08:23:32 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
( '82418' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C' , '30' , '-30' , '4' ,
'20.00' , '20' , '0' , '100' , '0.00' )
23/03/2023 08:34:39 am >> SELECT document_num FROM ps_document
WHERE document_num = '18' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 08:34:39 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 (
'24' ,
'18' ,
'2023-03-23' ,
'' ,
'3000' ,
'0' ,
'4669629' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'3480.00' ,
'3480.00' ,
NOW() ,
NOW() )
23/03/2023 08:34:39 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 = '82419'
23/03/2023 08:34:39 am >> DELETE FROM ps_document_detail WHERE id_document = '82419'
23/03/2023 08:34:39 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
( '82419' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '100' , '-100' , '4' ,
'5.00' , '5' , '0' , '0' , '500.00' )
23/03/2023 08:34:39 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
( '82419' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '30' , '-30' , '4' ,
'6.00' , '6' , '0' , '0' , '180.00' )
23/03/2023 08:34:39 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
( '82419' , '20722' , 'SEMINATORI DI GIOIA' , '400' , '-400' , '4' ,
'2.50' , '2.5' , '0' , '0' , '1000.00' )
23/03/2023 08:34:39 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
( '82419' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - P. G. VALSECCHI' , '90' , '-90' , '4' ,
'20.00' , '20' , '0' , '0' , '1800.00' )
23/03/2023 08:35:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895783512' AND id_product != '50' AND ean13 != ''
23/03/2023 08:35:56 am >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788895783512',
date_upd = NOW()
WHERE id_product = '50'
23/03/2023 08:35:56 am >> UPDATE ps_product_lang SET
name = 'PERDONAMI SIGNORE',
description = 'E un aiuto per prepararsi\r\nalla confessione, rivolto in particolare ai ragazzi. Partendo dalla parabola del\r\nPadre\r\nmisericordioso, il lettore viene condotto a una semplice analisi del peccato, riconosciuto dalla\r\nnostra coscienza, e al perdono di Dio.
Dopo le formule della confessione e dell\'assoluzione, termina con una bella preghiera di ringraziamento al\r\nSignore per il perdono ottenuto.
'
WHERE id_product = '50'
23/03/2023 08:35:56 am >> UPDATE ps_product SET
wholesale_price = '0.17',
on_sale = '0',
price = '2.5'
WHERE id_product = '50'
23/03/2023 08:35:56 am >> UPDATE ps_product_shop SET
wholesale_price = '0.17',
price = '2.5',
id_tax_rules_group = '4',
id_category_default = '2',
id_argoment_default = '',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '1',
date_upd = NOW()
WHERE id_product = '50'
23/03/2023 08:35:56 am >> DELETE FROM ps_specific_price WHERE id_product = '50'
23/03/2023 08:35:56 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' , '50' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
23/03/2023 08:37:42 am >> SELECT document_num FROM ps_document
WHERE document_num = '7' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 08:37:42 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 (
'24' ,
'7' ,
'2023-03-23' ,
'' ,
'3000' ,
'0' ,
'4669629' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'3710.00' ,
'3710.00' ,
NOW() ,
NOW() )
23/03/2023 08:37:42 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 = '11060'
23/03/2023 08:37:42 am >> DELETE FROM ps_document_detail WHERE id_document = '11060'
23/03/2023 08:37:43 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
( '11060' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '800' , '-800' , '4' ,
'1.50' , '1.5' , '0' , '0' , '1200.00' )
23/03/2023 08:37:43 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
( '11060' , '50' , 'PERDONAMI SIGNORE' , '200' , '-200' , '4' ,
'2.5' , '2.5' , '0' , '0' , '500.00' )
23/03/2023 08:37:43 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
( '11060' , '126' , 'SACRAMENTO DEL PERDONO' , '300' , '-300' , '4' ,
'2.00' , '2' , '0' , '0' , '600.00' )
23/03/2023 08:37:43 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
( '11060' , '33' , '100 GIORNI CON LO SPIRITO' , '100' , '-100' , '4' ,
'7.50' , '7.5' , '0' , '0' , '750.00' )
23/03/2023 08:37:43 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
( '11060' , '13' , 'BUSSATE E VI SARÀ APERTO' , '200' , '-200' , '4' ,
'1.50' , '1.5' , '0' , '0' , '300.00' )
23/03/2023 08:37:43 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
( '11060' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '200' , '-200' , '4' ,
'1.80' , '1.8' , '0' , '0' , '360.00' )
23/03/2023 09:03:30 am >> SELECT document_num FROM ps_document
WHERE document_num = '433' AND id_document != '81253' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
23/03/2023 09:03:30 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '433',
document_date = '2023-02-06',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
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 = '109.00',
price_tax_excluded = '89.34',
date_upd = NOW()
WHERE id_document = '81253'
23/03/2023 09:03: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 = '81253'
23/03/2023 09:03:31 am >> DELETE FROM ps_document_detail WHERE id_document = '81253'
23/03/2023 09:03:31 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
( '81253' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' ,
'3.3000' , '2.7049180327869' , '22' , '0' , '99.00' )
23/03/2023 09:03:31 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
( '81253' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' ,
'10.00' , '8.1967213114754' , '22' , '0' , '10.00' )
23/03/2023 09:04:48 am >> SELECT document_num FROM ps_document
WHERE document_num = '574' AND id_document != '81436' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-20')
23/03/2023 09:04:48 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '574',
document_date = '2023-02-20',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
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 = '42.64',
price_tax_excluded = '35.88',
date_upd = NOW()
WHERE id_document = '81436'
23/03/2023 09:04:48 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 = '81436'
23/03/2023 09:04:48 am >> DELETE FROM ps_document_detail WHERE id_document = '81436'
23/03/2023 09:04:48 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
( '81436' , '20722' , 'SEMINATORI DI GIOIA' , '1' , '-1' , '4' ,
'2.5000' , '2.5' , '0' , '5' , '2.38' )
23/03/2023 09:04:48 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
( '81436' , '20660' , 'QUARESIMA E PASQUA ' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '5' , '2.76' )
23/03/2023 09:04:48 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
( '81436' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'17.5' , '14.344262295082' , '22' , '0' , '17.50' )
23/03/2023 09:04:48 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
( '81436' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' ,
'3.5000' , '2.8688524590164' , '22' , '0' , '7.00' )
23/03/2023 09:04:48 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
( '81436' , '9223' , 'S. MICHELE - CM 15 - 023 SMK/15' , '1' , '-1' , '1' ,
'13.00' , '10.655737704918' , '22' , '0' , '13.00' )
23/03/2023 09:08:07 am >> SELECT document_num FROM ps_document
WHERE document_num = '935' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 09:08:07 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' ,
'935' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.00' ,
'3.85' ,
NOW() ,
NOW() )
23/03/2023 09:08:07 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 = '82420'
23/03/2023 09:08:07 am >> DELETE FROM ps_document_detail WHERE id_document = '82420'
23/03/2023 09:08:07 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
( '82420' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' ,
'4.00' , '3.8461538461538' , '4' , '0' , '4.00' )
23/03/2023 09:08:41 am >> DELETE FROM ps_document WHERE id_document = '82420'
23/03/2023 09:08:41 am >> DELETE FROM ps_document_detail WHERE id_document = '82420'
23/03/2023 09:09:04 am >> SELECT document_num FROM ps_document
WHERE document_num = '935' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 09:09:04 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' ,
'935' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.00' ,
'3.85' ,
NOW() ,
NOW() )
23/03/2023 09:09:04 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 = '82421'
23/03/2023 09:09:04 am >> DELETE FROM ps_document_detail WHERE id_document = '82421'
23/03/2023 09:09:04 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
( '82421' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' ,
'4.00' , '3.8461538461538' , '4' , '0' , '4.00' )
23/03/2023 09:43:16 am >> SELECT document_num FROM ps_document
WHERE document_num = '936' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 09:43:16 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' ,
'936' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'29.49' ,
'27.69' ,
NOW() ,
NOW() )
23/03/2023 09:43:16 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 = '82422'
23/03/2023 09:43:16 am >> DELETE FROM ps_document_detail WHERE id_document = '82422'
23/03/2023 09:43:16 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
( '82422' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' ,
'5.50' , '5.5' , '0' , '5' , '5.23' )
23/03/2023 09:43:16 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
( '82422' , '11192' , 'VENITE CON ME 2 PARTE' , '2' , '-2' , '4' ,
'2.50' , '2.5' , '0' , '5' , '4.76' )
23/03/2023 09:43:16 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
( '82422' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'10' , '8.1967213114754' , '22' , '0' , '10.00' )
23/03/2023 09:43:16 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
( '82422' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '2' , '-2' , '4' ,
'5.00' , '5' , '0' , '5' , '9.50' )
23/03/2023 10:17:42 am >> SELECT document_num FROM ps_document
WHERE document_num = '937' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 10:17:42 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' ,
'937' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'95.00' ,
'77.87' ,
NOW() ,
NOW() )
23/03/2023 10:17:42 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 = '82423'
23/03/2023 10:17:42 am >> DELETE FROM ps_document_detail WHERE id_document = '82423'
23/03/2023 10:17:42 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
( '82423' , '15089' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2950' , '10' , '-10' , '1' ,
'6.50' , '5.327868852459' , '22' , '0' , '65.00' )
23/03/2023 10:17:42 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
( '82423' , '11805' , 'TECA IHS - 823' , '1' , '-1' , '1' ,
'25.00' , '20.491803278689' , '22' , '0' , '25.00' )
23/03/2023 10:17:42 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
( '82423' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'5' , '4.0983606557377' , '22' , '0' , '5.00' )
23/03/2023 10:19:33 am >> SELECT document_num FROM ps_document
WHERE document_num = '938' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 10:19:33 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' ,
'938' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'135.00' ,
'110.66' ,
NOW() ,
NOW() )
23/03/2023 10:19:33 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 = '82424'
23/03/2023 10:19:33 am >> DELETE FROM ps_document_detail WHERE id_document = '82424'
23/03/2023 10:19:33 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
( '82424' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'135' , '110.65573770492' , '22' , '0' , '135.00' )
23/03/2023 10:29:09 am >> SELECT document_num FROM ps_document
WHERE document_num = '939' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 10:29: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' ,
'939' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'169.60' ,
'148.66' ,
NOW() ,
NOW() )
23/03/2023 10:29: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 = '82425'
23/03/2023 10:29:09 am >> DELETE FROM ps_document_detail WHERE id_document = '82425'
23/03/2023 10:29:09 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
( '82425' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '35.00' )
23/03/2023 10:29:09 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
( '82425' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '20.00' )
23/03/2023 10:29:09 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
( '82425' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' ,
'4.7' , '3.8524590163934' , '22' , '0' , '56.40' )
23/03/2023 10:29:09 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
( '82425' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' ,
'8' , '6.5573770491803' , '22' , '0' , '48.00' )
23/03/2023 10:29:09 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
( '82425' , '20773' , 'VIA CRUCIS CON BENEDETTO XVI' , '2' , '-2' , '4' ,
'2.00' , '2' , '0' , '0' , '4.00' )
23/03/2023 10:29:09 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
( '82425' , '20675' , 'SULLA VIA DELLA CROCE CON PAPA FRANCESCO' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '0' , '3.00' )
23/03/2023 10:29:09 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
( '82425' , '2699' , 'CONTEMPLIAMO GESÙ RISORTO - VIA LUCIS' , '1' , '-1' , '4' ,
'1.20' , '1.2' , '0' , '0' , '1.20' )
23/03/2023 10:29:09 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
( '82425' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '0' , '2.00' )
23/03/2023 10:55:24 am >> SELECT document_num FROM ps_document
WHERE document_num = '940' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 10:55:24 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' ,
'940' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'30.00' ,
'24.59' ,
NOW() ,
NOW() )
23/03/2023 10:55:24 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 = '82426'
23/03/2023 10:55:24 am >> DELETE FROM ps_document_detail WHERE id_document = '82426'
23/03/2023 10:55:24 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
( '82426' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'30' , '24.590163934426' , '22' , '0' , '30.00' )
23/03/2023 11:01:27 am >> SELECT document_num FROM ps_document
WHERE document_num = '897' AND id_document != '82370' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-20')
23/03/2023 11:01:27 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '897',
document_date = '2023-03-20',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
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 = '37.75',
price_tax_excluded = '37.75',
date_upd = NOW()
WHERE id_document = '82370'
23/03/2023 11:01:27 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 = '82370'
23/03/2023 11:01:27 am >> DELETE FROM ps_document_detail WHERE id_document = '82370'
23/03/2023 11:01:27 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
( '82370' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' ,
'0.7000' , '0.7' , '0' , '0' , '0.70' )
23/03/2023 11:01:27 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
( '82370' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'37.05' , '37.05' , '0' , '0' , '37.05' )
23/03/2023 11:02:14 am >> SELECT document_num FROM ps_document
WHERE document_num = '940' AND id_document != '82426' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 11:02:14 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '940',
document_date = '2023-03-23',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
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 = '30.00',
price_tax_excluded = '24.59',
date_upd = NOW()
WHERE id_document = '82426'
23/03/2023 11:02:14 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 = '82426'
23/03/2023 11:02:14 am >> DELETE FROM ps_document_detail WHERE id_document = '82426'
23/03/2023 11:02:14 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
( '82426' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' ,
'7.50' , '6.1475409836066' , '22' , '0' , '7.50' )
23/03/2023 11:02:14 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
( '82426' , '20644' , 'STOLA - PST022' , '1' , '-1' , '1' ,
'19.90' , '16.311475409836' , '22' , '0' , '19.90' )
23/03/2023 11:02:14 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
( '82426' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'2.6' , '2.1311475409836' , '22' , '0' , '2.60' )
23/03/2023 11:04:41 am >> SELECT document_num FROM ps_document
WHERE document_num = '874' AND id_document != '82337' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16')
23/03/2023 11:04:41 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '874',
document_date = '2023-03-16',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
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 = '45.00',
price_tax_excluded = '36.89',
date_upd = NOW()
WHERE id_document = '82337'
23/03/2023 11:04:41 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 = '82337'
23/03/2023 11:04:41 am >> DELETE FROM ps_document_detail WHERE id_document = '82337'
23/03/2023 11:04:41 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
( '82337' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'5.2' , '4.2622950819672' , '22' , '0' , '5.20' )
23/03/2023 11:04:41 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
( '82337' , '20644' , 'STOLA - PST022' , '2' , '-2' , '1' ,
'19.90' , '16.311475409836' , '22' , '0' , '39.80' )
23/03/2023 11:05:57 am >> UPDATE ps_document SET
id_document_type = '33',
document_num = '27',
document_date = '2023-01-17',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '4669556',
address1 = 'VIA XXV APRILE, 17 24050 GRASSOBBIO',
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 = '147.13',
price_tax_excluded = '120.60',
date_upd = NOW()
WHERE id_document = '80509'
23/03/2023 11:05:57 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 = '80509'
23/03/2023 11:05:57 am >> DELETE FROM ps_document_detail WHERE id_document = '80509'
23/03/2023 11:05:57 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
( '80509' , '18881' , 'STOLA POLIESTERE - PST020' , '8' , '8' , '1' ,
'8.2000' , '6.7213114754098' , '22' , '0' , '80.03' )
23/03/2023 11:05:57 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
( '80509' , '18128' , 'PETTORINA PER COLLETTI DOPPI - AEPE02N00' , '10' , '10' , '1' ,
'5.5000' , '4.5081967213115' , '22' , '0' , '67.10' )
23/03/2023 11:12:23 am >> UPDATE ps_document SET
id_document_type = '33',
document_num = '27',
document_date = '2023-01-17',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '4669556',
address1 = 'VIA XXV APRILE, 17 24050 GRASSOBBIO',
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 = '147.13',
price_tax_excluded = '120.60',
date_upd = NOW()
WHERE id_document = '80509'
23/03/2023 11:12:23 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 = '80509'
23/03/2023 11:12:23 am >> DELETE FROM ps_document_detail WHERE id_document = '80509'
23/03/2023 11:12:23 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
( '80509' , '20644' , 'STOLA - PST022' , '8' , '8' , '1' ,
'8.2' , '6.7213114754098' , '22' , '0' , '80.0320' )
23/03/2023 11:12:23 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
( '80509' , '18128' , 'PETTORINA PER COLLETTI DOPPI - AEPE02N00' , '10' , '10' , '1' ,
'5.5000' , '4.5081967213115' , '22' , '0' , '67.10' )
23/03/2023 11:14:37 am >> UPDATE ps_document SET
id_document_type = '32',
document_num = '42-1C2',
document_date = '2023-01-30',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '4669556',
address1 = 'VIA XXV APRILE, 17 24050 GRASSOBBIO',
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 = '147.13',
price_tax_excluded = '120.60',
date_upd = NOW()
WHERE id_document = '81134'
23/03/2023 11:14:37 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 = '81134'
23/03/2023 11:14:37 am >> DELETE FROM ps_document_detail WHERE id_document = '81134'
23/03/2023 11:14:37 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
( '81134' , '20644' , 'STOLA - PST022' , '8' , '0' , '1' ,
'8.2' , '6.7213114754098' , '22' , '0' , '80.0320' )
23/03/2023 11:14:37 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
( '81134' , '18128' , 'PETTORINA PER COLLETTI DOPPI - AEPE02N00' , '10' , '0' , '1' ,
'5.5000' , '4.5081967213115' , '22' , '0' , '67.10' )
23/03/2023 11:29:00 am >> SELECT document_num FROM ps_document
WHERE document_num = '58' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 11:29:00 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 (
'21' ,
'58' ,
'2023-03-23' ,
'' ,
'973' ,
'0' ,
'4677360' ,
'VIA MUNICIPIO 83020 TORCHIATI-MONTORO ' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'122.50' ,
'122.50' ,
NOW() ,
NOW() )
23/03/2023 11:29:00 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 = '82427'
23/03/2023 11:29:00 am >> DELETE FROM ps_document_detail WHERE id_document = '82427'
23/03/2023 11:29:00 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
( '82427' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '50' , '-50' , '4' ,
'1.60' , '1.6' , '0' , '0' , '80.00' )
23/03/2023 11:29:00 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
( '82427' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '50' , '-50' , '4' ,
'1.00' , '1' , '0' , '15' , '42.50' )
23/03/2023 12:05:24 pm >> SELECT document_num FROM ps_document
WHERE document_num = '941' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 12:05:24 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' ,
'941' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'112.50' ,
'92.21' ,
NOW() ,
NOW() )
23/03/2023 12:05:24 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 = '82428'
23/03/2023 12:05:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '82428'
23/03/2023 12:05:24 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
( '82428' , '11272' , 'VETRO ROSSO RUBINO - VKINGS' , '1' , '-1' , '1' ,
'12.50' , '10.245901639344' , '22' , '0' , '12.50' )
23/03/2023 12:05:24 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
( '82428' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' ,
'20' , '16.393442622951' , '22' , '0' , '100.00' )
23/03/2023 12:17:26 pm >> SELECT document_num FROM ps_document
WHERE document_num = '942' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 12:17: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' ,
'942' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'130.00' ,
'111.35' ,
NOW() ,
NOW() )
23/03/2023 12:17: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 = '82429'
23/03/2023 12:17:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '82429'
23/03/2023 12:17: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
( '82429' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' ,
'7' , '5.7377049180328' , '22' , '0' , '42.00' )
23/03/2023 12:17: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
( '82429' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' ,
'1.90' , '1.8269230769231' , '4' , '0' , '9.50' )
23/03/2023 12:17: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
( '82429' , '17710' , 'OSTIA MAGNA CM 14 - OM 140' , '1' , '-1' , '3' ,
'4.50' , '4.3269230769231' , '4' , '0' , '4.50' )
23/03/2023 12:17: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
( '82429' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '6' , '-6' , '3' ,
'3.30' , '3.1730769230769' , '4' , '0' , '19.80' )
23/03/2023 12:17: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
( '82429' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' ,
'13.00' , '10.655737704918' , '22' , '0' , '13.00' )
23/03/2023 12:17: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
( '82429' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' ,
'13.00' , '10.655737704918' , '22' , '0' , '13.00' )
23/03/2023 12:17: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
( '82429' , '19101' , 'INCENSO C' , '1' , '-1' , '1' ,
'28.2' , '23.114754098361' , '22' , '0' , '28.20' )
23/03/2023 12:22:08 pm >> SELECT document_num FROM ps_document
WHERE document_num = '943' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 12:22:08 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' ,
'943' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'66.70' ,
'58.77' ,
NOW() ,
NOW() )
23/03/2023 12:22:08 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 = '82430'
23/03/2023 12:22:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '82430'
23/03/2023 12:22:08 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
( '82430' , '19089' , 'OSTIA MAGNA 150 -OM150' , '1' , '-1' , '3' ,
'4.50' , '4.3269230769231' , '4' , '0' , '4.50' )
23/03/2023 12:22:08 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
( '82430' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' ,
'13.00' , '10.655737704918' , '22' , '0' , '13.00' )
23/03/2023 12:22:08 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
( '82430' , '20773' , 'VIA CRUCIS CON BENEDETTO XVI' , '2' , '-2' , '4' ,
'2.00' , '2' , '0' , '0' , '4.00' )
23/03/2023 12:22:08 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
( '82430' , '20869' , 'CARA MAMMA - TONINO BELLO' , '1' , '-1' , '4' ,
'16.00' , '16' , '0' , '5' , '15.20' )
23/03/2023 12:22:08 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
( '82430' , '19101' , 'INCENSO C' , '1' , '-1' , '1' ,
'30.00' , '24.590163934426' , '22' , '0' , '30.00' )
23/03/2023 12:35:37 pm >> SELECT document_num FROM ps_document
WHERE document_num = '944' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 12:35: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' ,
'944' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'26.00' ,
'26.00' ,
NOW() ,
NOW() )
23/03/2023 12:35: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 = '82431'
23/03/2023 12:35:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '82431'
23/03/2023 12:35: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
( '82431' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'26' , '26' , '0' , '0' , '26.00' )
23/03/2023 12:41:28 pm >> SELECT document_num FROM ps_document
WHERE document_num = '945' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 12:41:28 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' ,
'945' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'330.00' ,
'270.49' ,
NOW() ,
NOW() )
23/03/2023 12:41:28 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 = '82432'
23/03/2023 12:41:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '82432'
23/03/2023 12:41:28 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
( '82432' , '19449' , 'CAMICE F/LANA - 6995' , '1' , '-1' , '1' ,
'330' , '270.49180327869' , '22' , '0' , '330.00' )
23/03/2023 12:47:57 pm >> SELECT document_num FROM ps_document
WHERE document_num = '946' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 12:47:57 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' ,
'946' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'45.60' ,
'45.60' ,
NOW() ,
NOW() )
23/03/2023 12:47:57 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 = '82433'
23/03/2023 12:47:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '82433'
23/03/2023 12:47:57 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
( '82433' , '15020' , 'PREGARE OGNI GIORNO' , '30' , '-30' , '4' ,
'1.00' , '1' , '0' , '0' , '30.00' )
23/03/2023 12:47:57 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
( '82433' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '6' , '-6' , '4' ,
'0.70' , '0.7' , '0' , '0' , '4.20' )
23/03/2023 12:47:57 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
( '82433' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. M. EPICOCO' , '1' , '-1' , '4' ,
'12.00' , '12' , '0' , '5' , '11.40' )
23/03/2023 12:48:30 pm >> SELECT document_num FROM ps_document
WHERE document_num = '947' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 12:48:30 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' ,
'947' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'66.00' ,
'54.10' ,
NOW() ,
NOW() )
23/03/2023 12:48:30 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 = '82434'
23/03/2023 12:48:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '82434'
23/03/2023 12:48:30 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
( '82434' , '17161' , 'CARBONCINI NERI - CARNE' , '3' , '-3' , '1' ,
'12.00' , '9.8360655737705' , '22' , '0' , '36.00' )
23/03/2023 12:48:30 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
( '82434' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' ,
'30.00' , '24.590163934426' , '22' , '0' , '30.00' )
23/03/2023 01:11:47 pm >> SELECT document_num FROM ps_document
WHERE document_num = '58' AND id_document != '82427' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 01:11:47 pm >> UPDATE ps_document SET
id_document_type = '21',
document_num = '58',
document_date = '2023-03-23',
document_letter = '',
id_customer = '973',
id_supplier = '',
id_address = '4677360',
address1 = 'VIA MUNICIPIO 83020 TORCHIATI-MONTORO ',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '1',
id_causal = '0',
price_tax_included = '122.50',
price_tax_excluded = '122.50',
date_upd = NOW()
WHERE id_document = '82427'
23/03/2023 01:11:47 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 = '82427'
23/03/2023 01:11:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '82427'
23/03/2023 01:11:47 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
( '82427' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '50' , '-50' , '4' ,
'1.6000' , '1.6' , '0' , '0' , '80.00' )
23/03/2023 01:11:47 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
( '82427' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '50' , '-50' , '4' ,
'1.0000' , '1' , '0' , '15' , '42.50' )
23/03/2023 02:16:14 pm >> SELECT document_num FROM ps_document
WHERE document_num = '329' AND id_document != '81116' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31')
23/03/2023 02:16:14 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '329',
document_date = '2023-01-31',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
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 = '40.67',
price_tax_excluded = '40.67',
date_upd = NOW()
WHERE id_document = '81116'
23/03/2023 02:16: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 = '81116'
23/03/2023 02:16:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '81116'
23/03/2023 02:16: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
( '81116' , '19376' , 'INCONTRARE IL CROCIFISSO - T. HALIK' , '1' , '-1' , '4' ,
'3.0000' , '3' , '0' , '5' , '2.85' )
23/03/2023 02:16: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
( '81116' , '20528' , 'AMEN - MAR 23' , '1' , '-1' , '4' ,
'3.9000' , '3.9' , '0' , '5' , '3.71' )
23/03/2023 02:16: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
( '81116' , '20527' , 'AMEN - APR 23' , '1' , '-1' , '4' ,
'3.9000' , '3.9' , '0' , '5' , '3.71' )
23/03/2023 02:16: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
( '81116' , '5887' , 'LITURGIA DELLE ORE - VOL. I - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' ,
'30.4' , '30.4' , '0' , '0' , '30.40' )
23/03/2023 02:16:49 pm >> SELECT document_num FROM ps_document
WHERE document_num = '568' AND id_document != '81428' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-20')
23/03/2023 02:16:49 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '568',
document_date = '2023-02-20',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
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 = '68.00',
price_tax_excluded = '68.00',
date_upd = NOW()
WHERE id_document = '81428'
23/03/2023 02:16:50 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 = '81428'
23/03/2023 02:16:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '81428'
23/03/2023 02:16:50 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
( '81428' , '5888' , 'LITURGIA DELLE ORE - VOL. II - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' ,
'34' , '34' , '0' , '0' , '34.00' )
23/03/2023 02:16:50 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
( '81428' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' ,
'34' , '34' , '0' , '0' , '34.00' )
23/03/2023 02:17:30 pm >> SELECT document_num FROM ps_document
WHERE document_num = '948' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 02:17:30 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' ,
'948' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'33.25' ,
'33.25' ,
NOW() ,
NOW() )
23/03/2023 02:17:30 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 = '82435'
23/03/2023 02:17:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '82435'
23/03/2023 02:17:30 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
( '82435' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' ,
'35.00' , '35' , '0' , '5' , '33.25' )
23/03/2023 03:03:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259752444' AND id_product != '20804' AND ean13 != ''
23/03/2023 03:03:54 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = 'GONDOLA 2',
ean13 = '9791259752444',
date_upd = NOW()
WHERE id_product = '20804'
23/03/2023 03:03:55 pm >> UPDATE ps_product_lang SET
name = 'AFFIDABILI STORIE DI DONNE - L. EPICOCO',
description = ''
WHERE id_product = '20804'
23/03/2023 03:03:55 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '12.0000'
WHERE id_product = '20804'
23/03/2023 03:03:55 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '267',
id_argoment_default = '20',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20804'
23/03/2023 03:03:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '20804'
23/03/2023 03:07:21 pm >> SELECT document_num FROM ps_document
WHERE document_num = '937' AND id_document != '82423' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 03:07:21 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '937',
document_date = '2023-03-23',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
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 = '95.00',
price_tax_excluded = '77.87',
date_upd = NOW()
WHERE id_document = '82423'
23/03/2023 03:07:21 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 = '82423'
23/03/2023 03:07:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '82423'
23/03/2023 03:07:21 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
( '82423' , '15089' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2950' , '3' , '-3' , '1' ,
'6.50' , '5.327868852459' , '22' , '0' , '19.50' )
23/03/2023 03:07:21 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
( '82423' , '11805' , 'TECA IHS - 823' , '1' , '-1' , '1' ,
'25.0000' , '20.491803278689' , '22' , '0' , '25.00' )
23/03/2023 03:07:21 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
( '82423' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'50.5' , '41.393442622951' , '22' , '0' , '50.50' )
23/03/2023 03:12:41 pm >> SELECT document_num FROM ps_document
WHERE document_num = '18' AND id_document != '82419' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 03:12:42 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '18',
document_date = '2023-03-23',
document_letter = '',
id_customer = '3000',
id_supplier = '',
id_address = '4669629',
address1 = 'VIA DEI CASTANI, 116 00172 ROMA',
address2 = '',
note = 'EDIZIONI',
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 = '3480.00',
price_tax_excluded = '3480.00',
date_upd = NOW()
WHERE id_document = '82419'
23/03/2023 03:12:42 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 = '82419'
23/03/2023 03:12:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '82419'
23/03/2023 03:12:42 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
( '82419' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '100' , '-100' , '4' ,
'5.0000' , '5' , '0' , '0' , '500.00' )
23/03/2023 03:12:42 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
( '82419' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '30' , '-30' , '4' ,
'6.0000' , '6' , '0' , '0' , '180.00' )
23/03/2023 03:12:42 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
( '82419' , '20722' , 'SEMINATORI DI GIOIA' , '400' , '-400' , '4' ,
'2.5000' , '2.5' , '0' , '0' , '1000.00' )
23/03/2023 03:12:42 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
( '82419' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - P. G. VALSECCHI' , '90' , '-90' , '4' ,
'20.0000' , '20' , '0' , '0' , '1800.00' )
23/03/2023 03:32:33 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '20876'
23/03/2023 03:33:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736208' AND id_product != '20876' AND ean13 != ''
23/03/2023 03:33:27 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '7/2',
ean13 = '9791280736208',
date_upd = NOW()
WHERE id_product = '20876'
23/03/2023 03:33:27 pm >> UPDATE ps_product_lang SET
name = 'HO DATO LORO LA TUA PAROLA - A/B/C - P. G. VALSECCHI',
description = 'Il volume contiene il commento esegetico e pastorale alle letture bibliche domenicali del tempo ordinario A-B-C e si affianca al volume per i Tempi di Avvento, Natale, Quaresima e Pasqua. Si tratta di commenti alla Sacra Scrittura a partire dal Magistero, soprattutto degli ultimi Papi, di aneddoti sulla vita dei Santi e del vissuto dell’autore.
Questo libro può essere una bella occasione per chi desidera approfondire la Parola di Dio domenicale ed essere aiutato nella preghiera.
'
WHERE id_product = '20876'
23/03/2023 03:33:27 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '20.0000'
WHERE id_product = '20876'
23/03/2023 03:33:27 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '20.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '64',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20876'
23/03/2023 03:33:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '20876'
23/03/2023 03:33:27 pm >> 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' , '20876' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
23/03/2023 03:37:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983936' AND id_product != '18657' AND ean13 != ''
23/03/2023 03:37:09 pm >> UPDATE ps_product SET
id_supplier = '53',
reference = '7/2',
ean13 = '9788895983936',
date_upd = NOW()
WHERE id_product = '18657'
23/03/2023 03:37:09 pm >> UPDATE ps_product_lang SET
name = 'HO DATO LORO LA TUA PAROLA - g. VALSECCHI',
description = ''
WHERE id_product = '18657'
23/03/2023 03:37:09 pm >> UPDATE ps_product SET
wholesale_price = '3.80',
on_sale = '0',
price = '16.0000'
WHERE id_product = '18657'
23/03/2023 03:37:09 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.80',
price = '16.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '64',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18657'
23/03/2023 03:37:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '18657'
23/03/2023 03:37:09 pm >> 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' , '18657' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
23/03/2023 03:40:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983936' AND id_product != '18657' AND ean13 != ''
23/03/2023 03:40:39 pm >> UPDATE ps_product SET
id_supplier = '53',
reference = '7/2',
ean13 = '9788895983936',
date_upd = NOW()
WHERE id_product = '18657'
23/03/2023 03:40:39 pm >> UPDATE ps_product_lang SET
name = 'HO DATO LORO LA TUA PAROLA - G. VALSECCHI',
description = ''
WHERE id_product = '18657'
23/03/2023 03:40:39 pm >> UPDATE ps_product SET
wholesale_price = '3.80',
on_sale = '0',
price = '16.0000'
WHERE id_product = '18657'
23/03/2023 03:40:39 pm >> UPDATE ps_product_shop SET
wholesale_price = '3.80',
price = '16.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '64',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18657'
23/03/2023 03:40:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '18657'
23/03/2023 03:40:39 pm >> 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' , '18657' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
23/03/2023 03:41:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983790' AND id_product != '18176' AND ean13 != ''
23/03/2023 03:41:58 pm >> UPDATE ps_product SET
id_supplier = '145',
reference = '14',
ean13 = '9788895983790',
date_upd = NOW()
WHERE id_product = '18176'
23/03/2023 03:41:58 pm >> UPDATE ps_product_lang SET
name = 'ANTIQUUM MINISTERIUM ',
description = 'Lettera apostolica di Papa Francesco con la quale istituisce il ministero di Catechista.
'
WHERE id_product = '18176'
23/03/2023 03:41:58 pm >> UPDATE ps_product SET
wholesale_price = '0.22',
on_sale = '0',
price = '1.0000'
WHERE id_product = '18176'
23/03/2023 03:41:58 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.22',
price = '1.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '69',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18176'
23/03/2023 03:41:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '18176'
23/03/2023 03:41:58 pm >> 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' , '18176' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
23/03/2023 03:43:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983851' AND id_product != '18528' AND ean13 != ''
23/03/2023 03:43:01 pm >> UPDATE ps_product SET
id_supplier = '53',
reference = '',
ean13 = '9788895983851',
date_upd = NOW()
WHERE id_product = '18528'
23/03/2023 03:43:01 pm >> UPDATE ps_product_lang SET
name = 'CON GESU\' VERSO IL CALVARIO - G. VALSECCHI',
description = 'Ripercorrendo le stazioni della Via Crucis, accompagnando Gesù fino al Calvario, noi cerchiamo di comprendere, per quanto possibile, la grandezza del suo amore. Un amore che deve diventare il nostro programma di vita.
'
WHERE id_product = '18528'
23/03/2023 03:43:01 pm >> UPDATE ps_product SET
wholesale_price = '0.18',
on_sale = '0',
price = '1.5000'
WHERE id_product = '18528'
23/03/2023 03:43:01 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.18',
price = '1.5000',
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 = '18528'
23/03/2023 03:43:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '18528'
23/03/2023 03:43:01 pm >> 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' , '18528' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
23/03/2023 03:43:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736208' AND id_product != '20876' AND ean13 != ''
23/03/2023 03:43:25 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '7/2',
ean13 = '9791280736208',
date_upd = NOW()
WHERE id_product = '20876'
23/03/2023 03:43:25 pm >> UPDATE ps_product_lang SET
name = 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI',
description = 'Il volume contiene il commento esegetico e pastorale alle letture bibliche domenicali del tempo ordinario A-B-C e si affianca al volume per i Tempi di Avvento, Natale, Quaresima e Pasqua. Si tratta di commenti alla Sacra Scrittura a partire dal Magistero, soprattutto degli ultimi Papi, di aneddoti sulla vita dei Santi e del vissuto dell’autore.
Questo libro può essere una bella occasione per chi desidera approfondire la Parola di Dio domenicale ed essere aiutato nella preghiera.
'
WHERE id_product = '20876'
23/03/2023 03:43:25 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '20.0000'
WHERE id_product = '20876'
23/03/2023 03:43:25 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '20.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '64',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20876'
23/03/2023 03:43:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '20876'
23/03/2023 03:43:25 pm >> 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' , '20876' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
23/03/2023 03:45:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736147' AND id_product != '20652' AND ean13 != ''
23/03/2023 03:45:10 pm >> UPDATE ps_product SET
id_supplier = '53',
reference = '13/3',
ean13 = '9791280736147',
date_upd = NOW()
WHERE id_product = '20652'
23/03/2023 03:45:10 pm >> UPDATE ps_product_lang SET
name = 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI',
description = 'Questo schema di Via Crucis, è molto breve ed essenziale.
Ogni singola stazione è illustrata da una lettura biblica e da un breve commento tratto dagli scritti di Chiara Lubich.
'
WHERE id_product = '20652'
23/03/2023 03:45:10 pm >> UPDATE ps_product SET
wholesale_price = '1,250.00',
on_sale = '0',
price = '2.0000'
WHERE id_product = '20652'
23/03/2023 03:45:10 pm >> UPDATE ps_product_shop SET
wholesale_price = '1,250.00',
price = '2.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 = '20652'
23/03/2023 03:45:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '20652'
23/03/2023 03:45:10 pm >> 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' , '20652' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
23/03/2023 03:56:58 pm >> SELECT document_num FROM ps_document
WHERE document_num = '949' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 03:56:58 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' ,
'949' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'21.45' ,
'21.45' ,
NOW() ,
NOW() )
23/03/2023 03:56:58 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 = '82436'
23/03/2023 03:56:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '82436'
23/03/2023 03:56:58 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
( '82436' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '15' , '-15' , '4' ,
'1.50' , '1.5' , '0' , '5' , '21.45' )
23/03/2023 04:39:53 pm >> SELECT document_num FROM ps_document
WHERE document_num = '950' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 04:39:53 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' ,
'950' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'15.80' ,
'12.95' ,
NOW() ,
NOW() )
23/03/2023 04:39:53 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 = '82437'
23/03/2023 04:39:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '82437'
23/03/2023 04:39:53 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
( '82437' , '3051' , 'CROCE METALLO CORPO RIP.OX CM 4X2 - G184OX' , '5' , '-5' , '1' ,
'0.70' , '0.57377049180328' , '22' , '0' , '3.50' )
23/03/2023 04:39:53 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
( '82437' , '3103' , 'CROCE SAN BENEDETTO' , '1' , '-1' , '1' ,
'1.30' , '1.0655737704918' , '22' , '0' , '1.30' )
23/03/2023 04:39:53 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
( '82437' , '19750' , 'INCENSO LUCAS' , '1' , '-1' , '1' ,
'11.00' , '9.016393442623' , '22' , '0' , '11.00' )
23/03/2023 05:51:21 pm >> SELECT document_num FROM ps_document
WHERE document_num = '951' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 05:51:21 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' ,
'951' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'1.20' ,
'0.98' ,
NOW() ,
NOW() )
23/03/2023 05:51:21 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 = '82438'
23/03/2023 05:51:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '82438'
23/03/2023 05:51:21 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
( '82438' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' ,
'1.20' , '0.98360655737705' , '22' , '0' , '1.20' )
23/03/2023 06:09:09 pm >> SELECT document_num FROM ps_document
WHERE document_num = '952' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 06:09:09 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' ,
'952' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'8.28' ,
'8.28' ,
NOW() ,
NOW() )
23/03/2023 06:09:09 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 = '82439'
23/03/2023 06:09:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '82439'
23/03/2023 06:09:09 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
( '82439' , '20764' , 'PAROLA E PREGHIERA - MAG 2023' , '1' , '-1' , '4' ,
'2.90' , '2.9' , '0' , '5' , '2.76' )
23/03/2023 06:09:09 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
( '82439' , '20867' , 'PAROLA E PREGHIERA - GIU 23' , '1' , '-1' , '4' ,
'2.90' , '2.9' , '0' , '5' , '2.76' )
23/03/2023 06:09:09 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
( '82439' , '20731' , 'PAROLA E PREGHIERA APR 23' , '1' , '-1' , '4' ,
'2.90' , '2.9' , '0' , '5' , '2.76' )
23/03/2023 06:30:30 pm >> SELECT document_num FROM ps_document
WHERE document_num = '611' AND id_document != '81483' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-23')
23/03/2023 06:30:30 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '611',
document_date = '2023-02-23',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
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 = '39.00',
price_tax_excluded = '31.97',
date_upd = NOW()
WHERE id_document = '81483'
23/03/2023 06:30:30 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 = '81483'
23/03/2023 06:30:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '81483'
23/03/2023 06:30:30 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
( '81483' , '6811' , 'MOCCOLO 80X200' , '2' , '-2' , '1' ,
'9.0000' , '7.3770491803279' , '22' , '0' , '18.00' )
23/03/2023 06:30:30 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
( '81483' , '19782' , 'BRACCIALE ARGENTO/EMATITE' , '1' , '-1' , '1' ,
'21' , '17.213114754098' , '22' , '0' , '21.00' )
23/03/2023 06:40:17 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3812'
23/03/2023 06:40:18 pm >> INSERT INTO ps_address
( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd )
VALUES (
'3812' ,
'10' ,
'210' ,
'SEMINARIO ARCIVESCOVILE SALERNO' ,
'' ,
'' ,
'LARGO PLEBISCITO 12' ,
'VIA POMPEI 6 - 84098 PONTECAGNANO SA' ,
'84121' ,
'SALERNO ' ,
'' ,
'089202040' ,
'' ,
'' ,
'80031940655' ,
NOW() ,
NOW() )
23/03/2023 06:40:18 pm >> UPDATE ps_customer SET
email = 'seminariogp2sa@gmail.com',
sdi = '0000000',
pec = 'seminariosalerno@pec.it',
date_upd = NOW()
WHERE id_customer = '3812'
23/03/2023 06:42:19 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 06:42:19 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 (
'23' ,
'2/L' ,
'2023-03-23' ,
'L' ,
'3812' ,
'0' ,
'4672633' ,
'LARGO PLEBISCITO 12 84121 SALERNO ' ,
'' ,
'' ,
'0.00' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'210.40' ,
'207.36' ,
NOW() ,
NOW() )
23/03/2023 06:42:19 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 = '82440'
23/03/2023 06:42:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '82440'
23/03/2023 06:42:19 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
( '82440' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '14' , '-14' , '3' ,
'3.5000' , '3.3653846153846' , '4' , '0' , '49.00' )
23/03/2023 06:42:19 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
( '82440' , '20530' , 'ULTIME PAROLE - TERESA DI GESU BAMBINO' , '1' , '-1' , '4' ,
'20.0000' , '20' , '0' , '5' , '19.00' )
23/03/2023 06:42:19 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
( '82440' , '0' , 'OSTENSORIO MINI' , '1' , '-1' , '0' ,
'111.0000' , '111' , '' , '0' , '111.00' )
23/03/2023 06:42:19 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
( '82440' , '16689' , 'OSTIA PAN DI CENA mm80' , '15' , '-15' , '3' ,
'2.0000' , '1.9231' , '4' , '0' , '30.00' )
23/03/2023 06:42:19 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
( '82440' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' ,
'0.7000' , '0.7' , '0' , '0' , '1.40' )
23/03/2023 06:58:54 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 (
'31' ,
'110/23' ,
'2023-03-22' ,
'23' ,
'0' ,
'159' ,
'4673403' ,
'VIA PANNOSE 45 83025 MONTORO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'1404.00' ,
'1350.00' ,
NOW() ,
NOW() )
23/03/2023 06:58:54 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 = '82441'
23/03/2023 06:58:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '82441'
23/03/2023 06:58:54 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
( '82441' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '500' , '500' , '3' ,
'2.7' , '2.5961538461538' , '4' , '0' , '1404.0000' )
23/03/2023 06:58:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20876' AND id_supplier = '159'
23/03/2023 06:58:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20876' , '159' , '1' )
23/03/2023 07:06:01 pm >> SELECT document_num FROM ps_document
WHERE document_num = '953' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23')
23/03/2023 07:06:01 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' ,
'953' ,
'2023-03-23' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'20.90' ,
'20.90' ,
NOW() ,
NOW() )
23/03/2023 07:06:01 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 = '82442'
23/03/2023 07:06:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '82442'
23/03/2023 07:06:01 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
( '82442' , '6263' , 'MARIA, DONNA DEI GIORNI NOSTRI - T.BELLO' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '5' , '9.50' )
23/03/2023 07:06:01 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
( '82442' , '17862' , 'DALLINFORMATICA AL CIELO C. ACUTIS - N. GORI' , '1' , '-1' , '4' ,
'12.00' , '12' , '0' , '5' , '11.40' )