18/07/2023 08:39:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002000' AND id_product != '19659' AND ean13 != ''
18/07/2023 08:39:05 am >> UPDATE ps_product SET
id_supplier = '143',
reference = '',
ean13 = '002000',
date_upd = NOW()
WHERE id_product = '19659'
18/07/2023 08:39:05 am >> UPDATE ps_product_lang SET
name = 'CASULA POLIESTERE - 65/18355',
description = ''
WHERE id_product = '19659'
18/07/2023 08:39:05 am >> UPDATE ps_product SET
wholesale_price = '126.10',
on_sale = '0',
price = '262.2950819672131'
WHERE id_product = '19659'
18/07/2023 08:39:05 am >> UPDATE ps_product_shop SET
wholesale_price = '126.10',
price = '262.2950819672131',
id_tax_rules_group = '1',
id_category_default = '468',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19659'
18/07/2023 08:39:05 am >> DELETE FROM ps_specific_price WHERE id_product = '19659'
18/07/2023 08:39:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002000' AND id_product != '19659' AND ean13 != ''
18/07/2023 08:39:16 am >> UPDATE ps_product SET
id_supplier = '143',
reference = '',
ean13 = '002000',
date_upd = NOW()
WHERE id_product = '19659'
18/07/2023 08:39:17 am >> UPDATE ps_product_lang SET
name = 'CASULA POLIESTERE - 65/18355',
description = ''
WHERE id_product = '19659'
18/07/2023 08:39:17 am >> UPDATE ps_product SET
wholesale_price = '126.10',
on_sale = '0',
price = '262.2950819672131'
WHERE id_product = '19659'
18/07/2023 08:39:17 am >> UPDATE ps_product_shop SET
wholesale_price = '126.10',
price = '262.2950819672131',
id_tax_rules_group = '1',
id_category_default = '468',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '19659'
18/07/2023 08:39:17 am >> DELETE FROM ps_specific_price WHERE id_product = '19659'
18/07/2023 08:40:13 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'31' ,
'315' ,
'2023-07-14' ,
'' ,
'0' ,
'143' ,
'4670947' ,
'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'648.50' ,
'531.56' ,
NOW() ,
NOW() )
18/07/2023 08:40:13 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 = '86788'
18/07/2023 08:40:13 am >> DELETE FROM ps_document_detail WHERE id_document = '86788'
18/07/2023 08:40:13 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
( '86788' , '19659' , 'CASULA POLIESTERE - 65/18355' , '3' , '3' , '1' ,
'140' , '114.75409836066' , '22' , '3' , '497.0280' )
18/07/2023 08:40:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '19659' AND id_supplier = '143'
18/07/2023 08:40:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19659' , '143' , '1' )
18/07/2023 08:40:13 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
( '86788' , '17544' , 'CAMICE BAMBOO' , '2' , '2' , '1' ,
'64' , '52.459016393443' , '22' , '3' , '151.4752' )
18/07/2023 08:40:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '17544' AND id_supplier = '143'
18/07/2023 08:40:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17544' , '143' , '1' )
18/07/2023 08:44:36 am >> UPDATE ps_document SET
id_document_type = '31',
document_num = '78',
document_date = '2023-02-27',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '4670947',
address1 = 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '9',
id_causal = '0',
price_tax_included = '447.32',
price_tax_excluded = '366.66',
date_upd = NOW()
WHERE id_document = '82152'
18/07/2023 08:44:36 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 = '82152'
18/07/2023 08:44:36 am >> DELETE FROM ps_document_detail WHERE id_document = '82152'
18/07/2023 08:44:36 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
( '82152' , '17408' , 'CAMICE MISTO COT. 70/001035' , '3' , '3' , '1' ,
'63.0000' , '51.639344262295' , '22' , '3' , '223.66' )
18/07/2023 08:44:36 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
( '82152' , '17408' , 'CAMICE MISTO COT. 70/001035' , '3' , '3' , '1' ,
'63' , '51.639344262295' , '22' , '3' , '223.6626' )
18/07/2023 09:11:05 am >> SELECT document_num FROM ps_document
WHERE document_num = '1245' AND id_document != '82799' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-13')
18/07/2023 09:11:05 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1245',
document_date = '2023-04-13',
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 = '18.00',
price_tax_excluded = '14.75',
date_upd = NOW()
WHERE id_document = '82799'
18/07/2023 09:11:05 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82799'
18/07/2023 09:11:05 am >> DELETE FROM ps_document_detail WHERE id_document = '82799'
18/07/2023 09:11:05 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82799' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '1' , '-1' , '1' ,
'4.0000' , '3.2786885245902' , '22' , '0' , '4.00' )
18/07/2023 09:11:05 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82799' , '7192' , 'NUPTIAE DECORO CIELO ' , '1' , '-1' , '1' ,
'8.00' , '6.5573770491803' , '22' , '0' , '8.00' )
18/07/2023 09:11:05 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '82799' , '4840' , 'HOLY CARD - MISERICORDIOSO - M0100/G001' , '12' , '-12' , '1' ,
'0.5000' , '0.40983606557377' , '22' , '0' , '6.00' )
18/07/2023 09:11:56 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
18/07/2023 09:11:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21417' , '1' , '' , 'nuovo-prodotto' )
18/07/2023 09:11:56 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'21417' , '1' , '1' , '2' , NOW() , NOW()
)
18/07/2023 09:11:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21417' , '0' , '1' , '0' , '0' )
18/07/2023 09:15:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736215' AND id_product != '21417' AND ean13 != ''
18/07/2023 09:15:37 am >> UPDATE ps_product SET
id_supplier = '',
reference = '13/2',
ean13 = '9791280736215',
date_upd = NOW()
WHERE id_product = '21417'
18/07/2023 09:15:37 am >> UPDATE ps_product_lang SET
name = 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!',
description = 'La pace è il desiderio più profondo dell’essere umano, ma non sempre è chiaro il suo significato e purtroppo spesso le vie per ottenerla non coincidono con le vie di Dio. Tutta la Bibbia è percorsa da un anelito di pace.“Shalom” è la parola ebraica biblica che traduciamo i con “pace” che esprime un concetto molto più ampio, di armonia con gli altri e con la natura, con se stesso e con Dio, di benedizione e prosperità, di ricchezza e realizzazione, di vita piena, di giustizia in opposizione all’iniquità, di definitiva salvezza e felicità. L’uomo biblico si rende conto presto che questa pace, non può venire se non da Dio: da qui la preghiera per ottenere la pace; nello stesso tempo intuisce che Dio vuole la sua attiva cooperazione alla costruzione di questa pace sulla terra.Solo nella misura in cui faremo entrare il Signore nelle nostre vite, potremo avere lo “shalom” e potremo diffonderlo intorno a noi. Questo sussidio per l’Avvento e il Natale ci ispiri quotidianamente l’accorata preghiera: “Vieni, non tardare, Signore nostra Pace!” e ci prepari ad accoglierlo insieme nella verità e nella gioia.
'
WHERE id_product = '21417'
18/07/2023 09:15:37 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.5'
WHERE id_product = '21417'
18/07/2023 09:15:37 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.5',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '39',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '21417'
18/07/2023 09:15:37 am >> DELETE FROM ps_specific_price WHERE id_product = '21417'
18/07/2023 09:15:37 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' , '21417' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
18/07/2023 09:23:13 am >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '21417'
18/07/2023 09:36:10 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
18/07/2023 09:36:10 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21418' , '1' , '' , 'nuovo-prodotto' )
18/07/2023 09:36:10 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'21418' , '1' , '1' , '2' , NOW() , NOW()
)
18/07/2023 09:36:10 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21418' , '0' , '1' , '0' , '0' )
18/07/2023 09:38:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736314' AND id_product != '21418' AND ean13 != ''
18/07/2023 09:38:32 am >> UPDATE ps_product SET
id_supplier = '',
reference = '13/3',
ean13 = '9791280736314',
date_upd = NOW()
WHERE id_product = '21418'
18/07/2023 09:38:32 am >> UPDATE ps_product_lang SET
name = 'CRISTO NOSTRA PACE - V. SALVORDI',
description = 'È apparsa la grazia in quel lontano Natale che illumina e rende vera e sacra ogni nascita, ogni vita e ogni morte. Cristo gode per le nostre gioie, ama in ogni nostro amore, piange ogni lacrima e vive ogni morte. In ogni realtà pone un seme divino, perché tutto diventi grazia. Cristo in noi, speranza di pace, ci immerge un quel silenzio che preserva l’anima dal caduco rumore di un nome presto ricoperto dalla terra: solo il cielo lo rende eterno. Valentino Salvoldi ci prepara a vivere bene l’Avvento e a celebrare con gioia la nascita del Principe affinché ogni giorno per noi sia Natale. È Natale quando mi fido degli altri come Dio si è fidato di me. È Natale quando porto pace al mondo, perdonando gli altri come Dio mi perdona. È Natale quando ospito in casa una persona che è sola. È Natale quando mi chino su di un bambino vedendo in lui i lineamenti del “Dio che si è fatto uomo, perché l’uomo si faccia Dio”.
'
WHERE id_product = '21418'
18/07/2023 09:38:32 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.5'
WHERE id_product = '21418'
18/07/2023 09:38:32 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.5',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '39',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '21418'
18/07/2023 09:38:32 am >> DELETE FROM ps_specific_price WHERE id_product = '21418'
18/07/2023 09:38:32 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' , '21418' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
18/07/2023 09:39:18 am >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '21418'
18/07/2023 09:53:03 am >> SELECT document_num FROM ps_document
WHERE document_num = '2413' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-18')
18/07/2023 09:53:03 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' ,
'2413' ,
'2023-07-18' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'2.10' ,
'2.10' ,
NOW() ,
NOW() )
18/07/2023 09:53:03 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 = '86789'
18/07/2023 09:53:03 am >> DELETE FROM ps_document_detail WHERE id_document = '86789'
18/07/2023 09:53:03 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
( '86789' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '3' , '-3' , '4' ,
'0.70' , '0.7' , '0' , '0' , '2.10' )
18/07/2023 10:12:19 am >> SELECT document_num FROM ps_document
WHERE document_num = '77/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-18')
18/07/2023 10:12:20 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' ,
'77/A' ,
'2023-07-18' ,
'A' ,
'204' ,
'0' ,
'4671483' ,
'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'31.30' ,
'28.81' ,
NOW() ,
NOW() )
18/07/2023 10:12:20 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 = '86790'
18/07/2023 10:12:20 am >> DELETE FROM ps_document_detail WHERE id_document = '86790'
18/07/2023 10:12:20 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
( '86790' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' ,
'0.70' , '0.7' , '0' , '0' , '17.50' )
18/07/2023 10:12:20 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
( '86790' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' ,
'3.80' , '3.1147540983607' , '22' , '0' , '3.80' )
18/07/2023 10:12:20 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
( '86790' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' ,
'10.00' , '8.1967213114754' , '22' , '0' , '10.00' )
18/07/2023 10:12:38 am >> SELECT document_num FROM ps_document
WHERE document_num = '77/A' AND id_document != '86790' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-18')
18/07/2023 10:12:38 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '77/A',
document_date = '2023-07-18',
document_letter = 'A',
id_customer = '204',
id_supplier = '',
id_address = '4671483',
address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO',
address2 = '',
note = 'capp. osp battipaglia',
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 = '31.30',
price_tax_excluded = '28.81',
date_upd = NOW()
WHERE id_document = '86790'
18/07/2023 10:12:38 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 = '86790'
18/07/2023 10:12:38 am >> DELETE FROM ps_document_detail WHERE id_document = '86790'
18/07/2023 10:12:38 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
( '86790' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' ,
'0.7000' , '0.7' , '0' , '0' , '17.50' )
18/07/2023 10:12:38 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
( '86790' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' ,
'3.8000' , '3.1147540983607' , '22' , '0' , '3.80' )
18/07/2023 10:12:38 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
( '86790' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' ,
'10.0000' , '8.1967213114754' , '22' , '0' , '10.00' )
18/07/2023 10:13:05 am >> SELECT document_num FROM ps_document
WHERE document_num = '2414' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-18')
18/07/2023 10:13:05 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'2414' ,
'2023-07-18' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'20.24' ,
'20.24' ,
NOW() ,
NOW() )
18/07/2023 10:13:05 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86791'
18/07/2023 10:13:05 am >> DELETE FROM ps_document_detail WHERE id_document = '86791'
18/07/2023 10:13:05 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '86791' , '21205' , 'MI AMI TU? - CD' , '1' , '-1' , '4' ,
'16.80' , '16.8' , '0' , '5' , '15.96' )
18/07/2023 10:13:05 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '86791' , '21143' , 'AGGIUNTA CANTI 2023' , '1' , '-1' , '4' ,
'4.50' , '4.5' , '0' , '5' , '4.28' )
18/07/2023 10:18:20 am >> DELETE FROM ps_product WHERE id_product = '9598'
18/07/2023 10:18:20 am >> DELETE FROM ps_product_shop WHERE id_product = '9598'
18/07/2023 10:18:20 am >> DELETE FROM ps_product_lang WHERE id_product = '9598'
18/07/2023 10:18:20 am >> DELETE FROM ps_stock_available WHERE id_product = '9598'
18/07/2023 11:51:40 am >> SELECT document_num FROM ps_document
WHERE document_num = '2415' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-18')
18/07/2023 11:51:40 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' ,
'2415' ,
'2023-07-18' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'144.00' ,
'122.29' ,
NOW() ,
NOW() )
18/07/2023 11:51:40 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 = '86792'
18/07/2023 11:51:40 am >> DELETE FROM ps_document_detail WHERE id_document = '86792'
18/07/2023 11:51:40 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
( '86792' , '541' , 'AMPOLLE ALTARE NIK - 503' , '1' , '-1' , '1' ,
'118.50' , '97.131147540984' , '22' , '0' , '118.50' )
18/07/2023 11:51:40 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
( '86792' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '-1' , '4' ,
'3.40' , '3.4' , '0' , '5' , '3.23' )
18/07/2023 11:51:40 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
( '86792' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '5' , '2.85' )
18/07/2023 11:51:40 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
( '86792' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '5' , '2.85' )
18/07/2023 11:51:40 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
( '86792' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '5' , '2.38' )
18/07/2023 11:51:40 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
( '86792' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' ,
'5.19' , '5.19' , '0' , '' , '5.19' )
18/07/2023 11:51:40 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
( '86792' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '7.00' )
18/07/2023 11:51:40 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
( '86792' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '2.00' )
18/07/2023 11:56:28 am >> SELECT document_num FROM ps_document
WHERE document_num = '2416' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-18')
18/07/2023 11:56:28 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' ,
'2416' ,
'2023-07-18' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'105.60' ,
'87.64' ,
NOW() ,
NOW() )
18/07/2023 11:56:28 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 = '86793'
18/07/2023 11:56:28 am >> DELETE FROM ps_document_detail WHERE id_document = '86793'
18/07/2023 11:56:28 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
( '86793' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '-1' , '1' ,
'98.00' , '80.327868852459' , '22' , '0' , '98.00' )
18/07/2023 11:56:28 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
( '86793' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' ,
'4.30' , '4.1346153846154' , '4' , '0' , '4.30' )
18/07/2023 11:56:28 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
( '86793' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '1' , '-1' , '3' ,
'3.30' , '3.1730769230769' , '4' , '0' , '3.30' )
18/07/2023 12:38:52 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2417' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-18')
18/07/2023 12:38:52 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' ,
'2417' ,
'2023-07-18' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'158.00' ,
'129.51' ,
NOW() ,
NOW() )
18/07/2023 12:38:52 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 = '86794'
18/07/2023 12:38:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '86794'
18/07/2023 12:38:52 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
( '86794' , '17101' , 'CASULA POLIESTERE CROCE ORO - AECU04' , '1' , '-1' , '1' ,
'79.00' , '64.754098360656' , '22' , '0' , '79.00' )
18/07/2023 12:38:52 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
( '86794' , '14919' , 'CASULA - POLIESTERE - PCA022' , '1' , '-1' , '1' ,
'79.00' , '64.754098360656' , '22' , '0' , '79.00' )
18/07/2023 03:16:28 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2418' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-18')
18/07/2023 03:16: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' ,
'2418' ,
'2023-07-18' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'9.50' ,
'9.50' ,
NOW() ,
NOW() )
18/07/2023 03:16: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 = '86795'
18/07/2023 03:16:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '86795'
18/07/2023 03:16: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
( '86795' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
18/07/2023 03:16: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
( '86795' , '21037' , 'SULLA TUA PAROLA LUG/AGO 23' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
18/07/2023 03:49:20 pm >> SELECT document_num FROM ps_document
WHERE document_num = '75/A' AND id_document != '86754' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-14')
18/07/2023 03:49:20 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '75/A',
document_date = '2023-07-14',
document_letter = 'A',
id_customer = '3550',
id_supplier = '',
id_address = '4671016',
address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA',
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 = '689.80',
price_tax_excluded = '689.80',
date_upd = NOW()
WHERE id_document = '86754'
18/07/2023 03:49:20 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 = '86754'
18/07/2023 03:49:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '86754'
18/07/2023 03:49: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
( '86754' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' , '-1' , '0' ,
'8.5000' , '8.5' , '0' , '0' , '8.50' )
18/07/2023 03:49: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
( '86754' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '7' , '-7' , '0' ,
'13.5000' , '13.5' , '0' , '0' , '94.50' )
18/07/2023 03:49: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
( '86754' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '3' , '-3' , '0' ,
'13.0000' , '13' , '0' , '0' , '39.00' )
18/07/2023 03:49: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
( '86754' , '21003' , 'FARE CATECHESI OGGI - U. MONTISCI' , '1' , '-1' , '4' ,
'38.0000' , '38' , '0' , '' , '38.00' )
18/07/2023 03:49: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
( '86754' , '3269' , 'CUSTODIA TRACOLLA VOL. UNICO - OGGETTI' , '1' , '-1' , '0' ,
'38.0000' , '38' , '0' , '0' , '38.00' )
18/07/2023 03:49: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
( '86754' , '3260' , 'CUSTODIA LITURGIA DELLE ORE IN PELLE - 4 VOL ' , '1' , '-1' , '0' ,
'27.0000' , '27' , '0' , '0' , '27.00' )
18/07/2023 03:49: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
( '86754' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '0' ,
'4.9000' , '4.9' , '0' , '0' , '58.80' )
18/07/2023 03:49: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
( '86754' , '19106' , 'FRAGRANZA NARDO' , '1' , '-1' , '0' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
18/07/2023 03:49: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
( '86754' , '19105' , 'FRAGRANZA MIRRA' , '1' , '-1' , '0' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
18/07/2023 03:49: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
( '86754' , '19087' , 'SERVIZIO MESSA LINO - 74101' , '1' , '-1' , '0' ,
'68.0000' , '68' , '0' , '0' , '68.00' )
18/07/2023 03:49: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
( '86754' , '19705' , 'COMPLETO MESSA FIANDRA LINO - 45/720' , '1' , '-1' , '0' ,
'125.0000' , '125' , '0' , '0' , '125.00' )
18/07/2023 03:49: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
( '86754' , '0' , 'AMPOLLINE IN CRISTALLO' , '1' , '-1' , '0' ,
'165.0000' , '165' , '0' , '0' , '165.00' )
18/07/2023 03:49:42 pm >> SELECT document_num FROM ps_document
WHERE document_num = '74/A' AND id_document != '86725' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-12')
18/07/2023 03:49:42 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '74/A',
document_date = '2023-07-12',
document_letter = 'A',
id_customer = '3550',
id_supplier = '',
id_address = '4671016',
address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA',
address2 = '',
note = 'PREZZI SCONTATI',
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 = '561.00',
price_tax_excluded = '561.00',
date_upd = NOW()
WHERE id_document = '86725'
18/07/2023 03:49: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 = '86725'
18/07/2023 03:49:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '86725'
18/07/2023 03:49: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
( '86725' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' , '-1' , '0' ,
'8.5000' , '8.5' , '0' , '0' , '8.50' )
18/07/2023 03:49: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
( '86725' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '7' , '-7' , '0' ,
'11.0000' , '11' , '0' , '0' , '77.00' )
18/07/2023 03:49: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
( '86725' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '3' , '-3' , '0' ,
'11.0000' , '11' , '0' , '0' , '33.00' )
18/07/2023 03:49: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
( '86725' , '21003' , 'FARE CATECHESI OGGI - U. MONTISCI' , '1' , '-1' , '4' ,
'36.5000' , '36.5' , '0' , '' , '36.50' )
18/07/2023 03:49:43 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
( '86725' , '3269' , 'CUSTODIA TRACOLLA VOL. UNICO - OGGETTI' , '1' , '-1' , '4' ,
'35.0000' , '35' , '0' , '0' , '35.00' )
18/07/2023 03:49:43 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
( '86725' , '3260' , 'CUSTODIA LITURGIA DELLE ORE IN PELLE - 4 VOL ' , '1' , '-1' , '4' ,
'25.0000' , '25' , '0' , '0' , '25.00' )
18/07/2023 03:49:43 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
( '86725' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '4' ,
'4.5000' , '4.5' , '0' , '0' , '54.00' )
18/07/2023 03:49:43 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
( '86725' , '19106' , 'FRAGRANZA NARDO' , '1' , '-1' , '0' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
18/07/2023 03:49:43 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
( '86725' , '19105' , 'FRAGRANZA MIRRA' , '1' , '-1' , '0' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
18/07/2023 03:49:43 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
( '86725' , '19087' , 'SERVIZIO MESSA LINO - 74101' , '1' , '-1' , '0' ,
'50.0000' , '50' , '0' , '0' , '50.00' )
18/07/2023 03:49:43 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
( '86725' , '19705' , 'COMPLETO MESSA FIANDRA LINO - 45/720' , '1' , '-1' , '0' ,
'95.0000' , '95' , '0' , '0' , '95.00' )
18/07/2023 03:49:43 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
( '86725' , '0' , 'AMPOLLINE CRISTALLO' , '1' , '-1' , '0' ,
'125.0000' , '125' , '0' , '0' , '125.00' )
18/07/2023 03:50:21 pm >> SELECT document_num FROM ps_document
WHERE document_num = '75/A' AND id_document != '86754' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-14')
18/07/2023 03:50:21 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '75/A',
document_date = '2023-07-14',
document_letter = 'A',
id_customer = '3550',
id_supplier = '',
id_address = '4671016',
address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA',
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 = '3560.00',
price_tax_excluded = '3560.00',
date_upd = NOW()
WHERE id_document = '86754'
18/07/2023 03:50: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 = '86754'
18/07/2023 03:50:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '86754'
18/07/2023 03:50: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
( '86754' , '18389' , 'CASULA MINIMAL LANA LUREX' , '4' , '-4' , '0' ,
'890.00' , '890' , '' , '0' , '3560.00' )
18/07/2023 03:50:47 pm >> SELECT document_num FROM ps_document
WHERE document_num = '74/A' AND id_document != '86725' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-12')
18/07/2023 03:50:47 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '74/A',
document_date = '2023-07-12',
document_letter = 'A',
id_customer = '3550',
id_supplier = '',
id_address = '4671016',
address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA',
address2 = '',
note = 'PREZZI SCONTATI',
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 = '3125.00',
price_tax_excluded = '2561.48',
date_upd = NOW()
WHERE id_document = '86725'
18/07/2023 03:50: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 = '86725'
18/07/2023 03:50:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '86725'
18/07/2023 03:50: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
( '86725' , '18389' , 'CASULA MINIMAL LANA LUREX' , '5' , '-5' , '1' ,
'625' , '512.29508196721' , '22' , '0' , '3125.00' )
18/07/2023 03:51:05 pm >> SELECT document_num FROM ps_document
WHERE document_num = '75/A' AND id_document != '86754' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-14')
18/07/2023 03:51:05 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '75/A',
document_date = '2023-07-14',
document_letter = 'A',
id_customer = '3550',
id_supplier = '',
id_address = '4671016',
address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA',
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 = '4450.00',
price_tax_excluded = '4450.00',
date_upd = NOW()
WHERE id_document = '86754'
18/07/2023 03:51:05 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 = '86754'
18/07/2023 03:51:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '86754'
18/07/2023 03:51:05 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
( '86754' , '18389' , 'CASULA MINIMAL LANA LUREX' , '5' , '-5' , '0' ,
'890.0000' , '890' , '' , '0' , '4450.00' )
18/07/2023 03:57:22 pm >> SELECT document_num FROM ps_document
WHERE document_num = '74/A' AND id_document != '86725' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-12')
18/07/2023 03:57:22 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '74/A',
document_date = '2023-07-12',
document_letter = 'A',
id_customer = '3550',
id_supplier = '',
id_address = '4671016',
address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA',
address2 = '',
note = 'PREZZI SCONTATI',
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 = '3125.00',
price_tax_excluded = '3125.00',
date_upd = NOW()
WHERE id_document = '86725'
18/07/2023 03:57:22 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86725'
18/07/2023 03:57:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '86725'
18/07/2023 03:57:22 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '86725' , '18389' , 'CASULA MINIMAL LANA LUREX' , '5' , '-5' , '0' ,
'625.0000' , '625' , '' , '0' , '3125.00' )
18/07/2023 03:58:58 pm >> DELETE FROM ps_document WHERE id_document = '86725'
18/07/2023 03:58:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '86725'
18/07/2023 03:59:00 pm >> DELETE FROM ps_document WHERE id_document = '86754'
18/07/2023 03:59:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '86754'
18/07/2023 04:40:09 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2419' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-18')
18/07/2023 04:40: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' ,
'2419' ,
'2023-07-18' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'1.00' ,
'1.00' ,
NOW() ,
NOW() )
18/07/2023 04:40: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 = '86796'
18/07/2023 04:40:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '86796'
18/07/2023 04:40: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
( '86796' , '21196' , 'CALENDARIO LITURGICO 2024' , '2' , '-2' , '4' ,
'0.50' , '0.5' , '0' , '0' , '1.00' )
18/07/2023 05:32:41 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2420' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-18')
18/07/2023 05:32:41 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'2420' ,
'2023-07-18' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'8.50' ,
'8.17' ,
NOW() ,
NOW() )
18/07/2023 05:32:41 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86797'
18/07/2023 05:32:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '86797'
18/07/2023 05:32:41 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '86797' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' , '-1' , '3' ,
'8.50' , '8.1730769230769' , '4' , '0' , '8.50' )
18/07/2023 05:34:31 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1641' AND id_document != '84309' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-12')
18/07/2023 05:34:31 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1641',
document_date = '2023-05-12',
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 = '26.40',
price_tax_excluded = '21.64',
date_upd = NOW()
WHERE id_document = '84309'
18/07/2023 05:34:31 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 = '84309'
18/07/2023 05:34:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '84309'
18/07/2023 05:34:31 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
( '84309' , '20547' , 'MEDAGLIA LOURDES - OV22/L' , '27' , '-27' , '1' ,
'0.2' , '0.16393442622951' , '22' , '0' , '5.40' )
18/07/2023 05:34:31 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
( '84309' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '6' , '-6' , '1' ,
'3.50' , '2.8688524590164' , '22' , '0' , '21.00' )
18/07/2023 05:42:03 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2421' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-18')
18/07/2023 05:42:03 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' ,
'2421' ,
'2023-07-18' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.30' ,
'4.13' ,
NOW() ,
NOW() )
18/07/2023 05:42:03 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 = '86798'
18/07/2023 05:42:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '86798'
18/07/2023 05:42:03 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
( '86798' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' ,
'4.30' , '4.1346153846154' , '4' , '0' , '4.30' )
18/07/2023 06:44:07 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2422' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-18')
18/07/2023 06:44:07 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' ,
'2422' ,
'2023-07-18' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'120.00' ,
'98.36' ,
NOW() ,
NOW() )
18/07/2023 06:44:07 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 = '86799'
18/07/2023 06:44:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '86799'
18/07/2023 06:44:07 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
( '86799' , '20116' , 'FATIMA CM 70 - 1037' , '1' , '-1' , '1' ,
'120.00' , '98.360655737705' , '22' , '0' , '120.00' )
18/07/2023 07:03:11 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2423' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-18')
18/07/2023 07:03:11 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' ,
'2423' ,
'2023-07-18' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'30.00' ,
'24.59' ,
NOW() ,
NOW() )
18/07/2023 07:03:11 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 = '86800'
18/07/2023 07:03:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '86800'
18/07/2023 07:03:11 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
( '86800' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '50' , '-50' , '1' ,
'0.60' , '0.49180327868852' , '22' , '0' , '30.00' )