06/07/2023 08:17:27 am >> SELECT document_num FROM ps_document
WHERE document_num = '2308' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 08:17: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' ,
'2308' ,
'2023-07-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'99.00' ,
'81.15' ,
NOW() ,
NOW() )
06/07/2023 08:17: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 = '86650'
06/07/2023 08:17:28 am >> DELETE FROM ps_document_detail WHERE id_document = '86650'
06/07/2023 08:17: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
( '86650' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' ,
'3.3' , '2.7049180327869' , '22' , '0' , '99.00' )
06/07/2023 10:12:00 am >> SELECT document_num FROM ps_document
WHERE document_num = '2309' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 10:12: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 (
'11' ,
'2309' ,
'2023-07-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'90.00' ,
'79.42' ,
NOW() ,
NOW() )
06/07/2023 10:12: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 = '86651'
06/07/2023 10:12:00 am >> DELETE FROM ps_document_detail WHERE id_document = '86651'
06/07/2023 10:12: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
( '86651' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' ,
'58.65' , '48.073770491803' , '22' , '0' , '58.65' )
06/07/2023 10:12: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
( '86651' , '21068' , 'MESSALINO AGO/SET/OTT 2023' , '1' , '-1' , '4' ,
'6.00' , '6' , '0' , '5' , '5.70' )
06/07/2023 10:12: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
( '86651' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '2' , '-2' , '4' ,
'5.00' , '5' , '0' , '5' , '9.50' )
06/07/2023 10:12: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
( '86651' , '21037' , 'SULLA TUA PAROLA LUG/AGO 23' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
06/07/2023 10:12: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
( '86651' , '20816' , 'FRANCESCANESIMO DI UN PAPA GESUITA - M. SEMERARO' , '1' , '-1' , '4' ,
'12.00' , '12' , '0' , '5' , '11.40' )
06/07/2023 10:30:08 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
06/07/2023 10:30:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21348' , '1' , '' , 'nuovo-prodotto' )
06/07/2023 10:30:08 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'21348' , '1' , '1' , '2' , NOW() , NOW()
)
06/07/2023 10:30:08 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21348' , '0' , '1' , '0' , '0' )
06/07/2023 10:31:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280546623' AND id_product != '21348' AND ean13 != ''
06/07/2023 10:31:28 am >> UPDATE ps_product SET
id_supplier = '',
reference = 'GONDOLA 1',
ean13 = '9791280546623',
date_upd = NOW()
WHERE id_product = '21348'
06/07/2023 10:31:28 am >> UPDATE ps_product_lang SET
name = 'PAPA FRANCESCO - UN RITRATTO SPIRITUALE - G. VIGINI',
description = ''
WHERE id_product = '21348'
06/07/2023 10:31:28 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '13'
WHERE id_product = '21348'
06/07/2023 10:31:28 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '13',
id_tax_rules_group = '4',
id_category_default = '483',
id_argoment_default = '71',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '21348'
06/07/2023 10:31:28 am >> DELETE FROM ps_specific_price WHERE id_product = '21348'
06/07/2023 10:32: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 (
'33' ,
'635894' ,
'2023-07-04' ,
'' ,
'0' ,
'7' ,
'2602' ,
'P. ZZA SAN PAOLO, 14 12051 ALBA' ,
'' ,
'' ,
'2.48' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'11' ,
'0' ,
'87.68' ,
'87.68' ,
NOW() ,
NOW() )
06/07/2023 10:32: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 = '86652'
06/07/2023 10:32:24 am >> DELETE FROM ps_document_detail WHERE id_document = '86652'
06/07/2023 10:32: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
( '86652' , '21118' , 'MARIA MADRE DELLEUCARISTIA - D. RUOTOLO' , '1' , '1' , '4' ,
'16.00' , '16' , '0' , '30' , '11.2000' )
06/07/2023 10:32:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '21118' AND id_supplier = '7'
06/07/2023 10:32:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21118' , '7' , '1' )
06/07/2023 10:32: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
( '86652' , '21067' , 'AMEN - AGO 23' , '2' , '2' , '4' ,
'3.90' , '3.9' , '0' , '33' , '5.2260' )
06/07/2023 10:32:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '21067' AND id_supplier = '7'
06/07/2023 10:32:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21067' , '7' , '1' )
06/07/2023 10:32: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
( '86652' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '1' , '4' ,
'16.00' , '16' , '0' , '33' , '10.7200' )
06/07/2023 10:32:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '12995' AND id_supplier = '7'
06/07/2023 10:32:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12995' , '7' , '1' )
06/07/2023 10:32: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
( '86652' , '21199' , 'AMEN - OTT 2023' , '2' , '2' , '4' ,
'3.90' , '3.9' , '0' , '33' , '5.2260' )
06/07/2023 10:32:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '21199' AND id_supplier = '7'
06/07/2023 10:32:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21199' , '7' , '1' )
06/07/2023 10:32: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
( '86652' , '21198' , 'AMEN - SET 2023' , '2' , '2' , '4' ,
'3.90' , '3.9' , '0' , '33' , '5.2260' )
06/07/2023 10:32:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '21198' AND id_supplier = '7'
06/07/2023 10:32:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21198' , '7' , '1' )
06/07/2023 10:32:25 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
( '86652' , '21068' , 'MESSALINO AGO/SET/OTT 2023' , '4' , '4' , '4' ,
'6.00' , '6' , '0' , '30' , '16.8000' )
06/07/2023 10:32:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '21068' AND id_supplier = '7'
06/07/2023 10:32:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21068' , '7' , '1' )
06/07/2023 10:32:25 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
( '86652' , '15939' , 'AMORE CHE DECIDE - L. EPICOCO' , '1' , '1' , '4' ,
'10.00' , '10' , '0' , '30' , '7.0000' )
06/07/2023 10:32:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '15939' AND id_supplier = '7'
06/07/2023 10:32:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15939' , '7' , '1' )
06/07/2023 10:32:25 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
( '86652' , '11743' , 'MINISTERO STRAORDINARIO DELLA COMUNIONE' , '1' , '1' , '4' ,
'9.00' , '9' , '0' , '30' , '6.3000' )
06/07/2023 10:32:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '11743' AND id_supplier = '7'
06/07/2023 10:32:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11743' , '7' , '1' )
06/07/2023 10:32:25 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
( '86652' , '20935' , 'TU X TUTTI' , '1' , '1' , '4' ,
'12.00' , '12' , '0' , '30' , '8.4000' )
06/07/2023 10:32:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '20935' AND id_supplier = '7'
06/07/2023 10:32:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20935' , '7' , '1' )
06/07/2023 10:32:25 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
( '86652' , '21348' , 'PAPA FRANCESCO - UN RITRATTO SPIRITUALE - G. VIGINI' , '1' , '1' , '4' ,
'13.00' , '13' , '0' , '30' , '9.1000' )
06/07/2023 10:32:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '21348' AND id_supplier = '7'
06/07/2023 10:32:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21348' , '7' , '1' )
06/07/2023 10:35:45 am >> SELECT document_num FROM ps_document
WHERE document_num = '34' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 10:35:45 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' ,
'34' ,
'2023-07-06' ,
'' ,
'3463' ,
'0' ,
'4670120' ,
'VIA MARCO AURELIO 81 80126 NAPOLI' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'9' ,
'0' ,
'18.00' ,
'18.00' ,
NOW() ,
NOW() )
06/07/2023 10:35:45 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 = '11353'
06/07/2023 10:35:45 am >> DELETE FROM ps_document_detail WHERE id_document = '11353'
06/07/2023 10:35:45 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
( '11353' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' ,
'18.00' , '18' , '0' , '0' , '18.00' )
06/07/2023 10:56:07 am >> SELECT document_num FROM ps_document
WHERE document_num = '106' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 10:56: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 (
'21' ,
'106' ,
'2023-07-06' ,
'' ,
'690' ,
'0' ,
'4670873' ,
'VIA MUNICIPIO, 2 31014 COLLE UMBERTO' ,
'' ,
'' ,
'4.9' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'6' ,
'0' ,
'42.00' ,
'42.00' ,
NOW() ,
NOW() )
06/07/2023 10:56: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 = '86653'
06/07/2023 10:56:07 am >> DELETE FROM ps_document_detail WHERE id_document = '86653'
06/07/2023 10:56: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
( '86653' , '1041' , 'BENEDIZIONI' , '200' , '-200' , '4' ,
'0.18' , '0.18' , '0' , '5' , '34.20' )
06/07/2023 10:56: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
( '86653' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' ,
'2.9' , '2.9' , '0' , '0' , '2.90' )
06/07/2023 11:30:35 am >> SELECT document_num FROM ps_document
WHERE document_num = '2310' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 11:30:35 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' ,
'2310' ,
'2023-07-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'247.60' ,
'202.95' ,
NOW() ,
NOW() )
06/07/2023 11:30:35 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 = '86654'
06/07/2023 11:30:35 am >> DELETE FROM ps_document_detail WHERE id_document = '86654'
06/07/2023 11:30:35 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
( '86654' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'240' , '196.72131147541' , '22' , '0' , '240.00' )
06/07/2023 11:30: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
( '86654' , '6058' , 'MADONNA DEL CARMINE - 117 BIS ' , '2' , '-2' , '1' ,
'3.80' , '3.1147540983607' , '22' , '0' , '7.60' )
06/07/2023 11:56:14 am >> SELECT document_num FROM ps_document
WHERE document_num = '2311' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 11:56:14 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' ,
'2311' ,
'2023-07-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'33.25' ,
'33.25' ,
NOW() ,
NOW() )
06/07/2023 11:56: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 = '86655'
06/07/2023 11:56:14 am >> DELETE FROM ps_document_detail WHERE id_document = '86655'
06/07/2023 11:56: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
( '86655' , '5894' , 'LITURGIA DELLE ORE IV - FRANCESCANA' , '1' , '-1' , '4' ,
'35.00' , '35' , '0' , '5' , '33.25' )
06/07/2023 12:04:10 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2312' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 12:04:10 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' ,
'2312' ,
'2023-07-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'120.00' ,
'98.36' ,
NOW() ,
NOW() )
06/07/2023 12:04:10 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 = '86656'
06/07/2023 12:04:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '86656'
06/07/2023 12:04:10 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
( '86656' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'120' , '98.360655737705' , '22' , '0' , '120.00' )
06/07/2023 12:05:22 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3226'
06/07/2023 12:05:22 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 (
'3226' ,
'10' ,
'210' ,
'' ,
'IANNONE' ,
'DON PASQUALE' ,
'via' ,
'' ,
'84100' ,
'salerno' ,
'' ,
'' ,
'3478274631' ,
'' ,
'' ,
NOW() ,
NOW() )
06/07/2023 12:05:22 pm >> UPDATE ps_customer SET
email = '',
sdi = '',
pec = '',
date_upd = NOW()
WHERE id_customer = '3226'
06/07/2023 12:08:15 pm >> SELECT document_num FROM ps_document
WHERE document_num = '73/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 12:08:15 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 (
'24' ,
'73/A' ,
'2023-07-06' ,
'A' ,
'3226' ,
'0' ,
'4679059' ,
'via 84100 salerno' ,
'' ,
'acconto € 80,00' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'600.00' ,
'491.80' ,
NOW() ,
NOW() )
06/07/2023 12:08:15 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 = '86657'
06/07/2023 12:08:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '86657'
06/07/2023 12:08:16 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
( '86657' , '15680' , 'CAMICE LANA/POL. SFILATURE A MANO' , '1' , '-1' , '1' ,
'600' , '491.80327868852' , '22' , '0' , '600.00' )
06/07/2023 12:11:27 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2313' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 12:11:27 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' ,
'2313' ,
'2023-07-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'51.50' ,
'42.21' ,
NOW() ,
NOW() )
06/07/2023 12:11:27 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 = '86658'
06/07/2023 12:11:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '86658'
06/07/2023 12:11:27 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
( '86658' , '11756' , 'VINO BIANCO SECCO - 14%' , '6' , '-6' , '1' ,
'6.50' , '5.327868852459' , '22' , '0' , '39.00' )
06/07/2023 12:11:27 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
( '86658' , '7940' , 'PERGAMENE - OCCASIONI MOD. A' , '25' , '-25' , '1' ,
'0.50' , '0.40983606557377' , '22' , '0' , '12.50' )
06/07/2023 12:30:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825055764' AND id_product != '20816' AND ean13 != ''
06/07/2023 12:30:55 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '7/6',
ean13 = '9788825055764',
date_upd = NOW()
WHERE id_product = '20816'
06/07/2023 12:30:55 pm >> UPDATE ps_product_lang SET
name = 'FRANCESCANESIMO DI UN PAPA GESUITA - M. SEMERARO',
description = ''
WHERE id_product = '20816'
06/07/2023 12:30:55 pm >> UPDATE ps_product SET
wholesale_price = '8.40',
on_sale = '0',
price = '12.0000'
WHERE id_product = '20816'
06/07/2023 12:30:55 pm >> UPDATE ps_product_shop SET
wholesale_price = '8.40',
price = '12.0000',
id_tax_rules_group = '4',
id_category_default = '17',
id_argoment_default = '10',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20816'
06/07/2023 12:30:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '20816'
06/07/2023 04:22:34 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 (
'32' ,
'6023274660' ,
'2023-06-30' ,
'' ,
'0' ,
'109' ,
'4669106' ,
'VIA G. VERDI, 8 20090 ASSAGO' ,
'' ,
'' ,
'' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'13' ,
'0' ,
'625.20' ,
'623.38' ,
NOW() ,
NOW() )
06/07/2023 04:22:34 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 = '86659'
06/07/2023 04:22:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '86659'
06/07/2023 04:22:34 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
( '86659' , '21296' , 'PIETRE DI GERUSALEMME' , '1' , '0' , '4' ,
'16.54' , '16.54' , '0' , '0' , '16.5400' )
06/07/2023 04:22:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21296' AND id_supplier = '109'
06/07/2023 04:22:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21296' , '109' , '1' )
06/07/2023 04:22:34 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
( '86659' , '21318' , 'TRAUMI DEUROPA' , '1' , '0' , '4' ,
'7.68' , '7.68' , '0' , '0' , '7.6800' )
06/07/2023 04:22:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21318' AND id_supplier = '109'
06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21318' , '109' , '1' )
06/07/2023 04:22:35 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
( '86659' , '21335' , 'AMARSI SEDUZIONE E DESIDERIO' , '1' , '0' , '4' ,
'28.35' , '28.35' , '0' , '0' , '28.3500' )
06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21335' AND id_supplier = '109'
06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21335' , '109' , '1' )
06/07/2023 04:22:35 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
( '86659' , '21317' , 'GRANDE RACCONTO DI ROMA ANTICA' , '1' , '0' , '4' ,
'23.62' , '23.62' , '0' , '0' , '23.6200' )
06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21317' AND id_supplier = '109'
06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21317' , '109' , '1' )
06/07/2023 04:22:35 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
( '86659' , '21337' , 'GRANDE RACCONTO DEL FAVOLOSO ORIENTE' , '1' , '0' , '4' ,
'28.35' , '28.35' , '0' , '0' , '28.3500' )
06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21337' AND id_supplier = '109'
06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21337' , '109' , '1' )
06/07/2023 04:22:35 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
( '86659' , '21299' , 'DONNE DI DANTE' , '1' , '0' , '4' ,
'22.46' , '22.46' , '0' , '0' , '22.4600' )
06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21299' AND id_supplier = '109'
06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21299' , '109' , '1' )
06/07/2023 04:22:35 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
( '86659' , '21324' , 'DONNA ROMANA' , '1' , '0' , '4' ,
'7.68' , '7.68' , '0' , '0' , '7.6800' )
06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21324' AND id_supplier = '109'
06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21324' , '109' , '1' )
06/07/2023 04:22:35 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
( '86659' , '21332' , 'GUERRIERO LOPLITA IL LEGIONARIO' , '1' , '0' , '4' ,
'7.68' , '7.68' , '0' , '0' , '7.6800' )
06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21332' AND id_supplier = '109'
06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21332' , '109' , '1' )
06/07/2023 04:22:35 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
( '86659' , '21303' , 'OLTREMARE' , '1' , '0' , '4' ,
'9.45' , '9.45' , '0' , '0' , '9.4500' )
06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21303' AND id_supplier = '109'
06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21303' , '109' , '1' )
06/07/2023 04:22:35 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
( '86659' , '21336' , 'PARADISO VISTA INFERNO' , '1' , '0' , '4' ,
'22.46' , '22.46' , '0' , '0' , '22.4600' )
06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21336' AND id_supplier = '109'
06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21336' , '109' , '1' )
06/07/2023 04:22:35 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
( '86659' , '21306' , 'FEDERICO II' , '1' , '0' , '4' ,
'7.68' , '7.68' , '0' , '0' , '7.6800' )
06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21306' AND id_supplier = '109'
06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21306' , '109' , '1' )
06/07/2023 04:22:35 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
( '86659' , '21304' , 'SICILIA MUSULMANA' , '1' , '0' , '4' ,
'7.68' , '7.68' , '0' , '0' , '7.6800' )
06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21304' AND id_supplier = '109'
06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21304' , '109' , '1' )
06/07/2023 04:22:35 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
( '86659' , '21320' , 'CONTRO UN NEMICO INVISIBILE' , '1' , '0' , '4' ,
'8.26' , '8.26' , '0' , '0' , '8.2600' )
06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21320' AND id_supplier = '109'
06/07/2023 04:22:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21320' , '109' , '1' )
06/07/2023 04:22:35 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
( '86659' , '21319' , 'STORIA ECONOMICA DELLEUROPA' , '1' , '0' , '4' ,
'8.86' , '8.86' , '0' , '0' , '8.8600' )
06/07/2023 04:22:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21319' AND id_supplier = '109'
06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21319' , '109' , '1' )
06/07/2023 04:22:36 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
( '86659' , '21327' , 'STORIA DEL REGNO DELLE DUE SICILIE' , '1' , '0' , '4' ,
'8.26' , '8.26' , '0' , '0' , '8.2600' )
06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21327' AND id_supplier = '109'
06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21327' , '109' , '1' )
06/07/2023 04:22:36 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
( '86659' , '21329' , 'MILITARI ITALIANI NEI LAGER NAZISTI' , '1' , '0' , '4' ,
'8.86' , '8.86' , '0' , '0' , '8.8600' )
06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21329' AND id_supplier = '109'
06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21329' , '109' , '1' )
06/07/2023 04:22:36 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
( '86659' , '21313' , 'TEMPLARI' , '1' , '0' , '4' ,
'7.10' , '7.1' , '0' , '0' , '7.1000' )
06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21313' AND id_supplier = '109'
06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21313' , '109' , '1' )
06/07/2023 04:22:36 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
( '86659' , '21328' , 'RIBELLI CONTRO ROMA' , '1' , '0' , '4' ,
'7.68' , '7.68' , '0' , '0' , '7.6800' )
06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21328' AND id_supplier = '109'
06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21328' , '109' , '1' )
06/07/2023 04:22:36 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
( '86659' , '21312' , 'ERETICI ED ERESIE MEDIEVALI' , '1' , '0' , '4' ,
'7.10' , '7.1' , '0' , '0' , '7.1000' )
06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21312' AND id_supplier = '109'
06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21312' , '109' , '1' )
06/07/2023 04:22:36 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
( '86659' , '21307' , 'IN VIAGGIO NEL MEDIOEVO' , '1' , '0' , '4' ,
'8.26' , '8.26' , '0' , '0' , '8.2600' )
06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21307' AND id_supplier = '109'
06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21307' , '109' , '1' )
06/07/2023 04:22:36 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
( '86659' , '21322' , 'TERRASANTA PELLEGRINI ITALIANI' , '1' , '0' , '4' ,
'9.45' , '9.45' , '0' , '0' , '9.4500' )
06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21322' AND id_supplier = '109'
06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21322' , '109' , '1' )
06/07/2023 04:22:36 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
( '86659' , '21305' , 'STORIA DI BISANZIO' , '1' , '0' , '4' ,
'8.26' , '8.26' , '0' , '0' , '8.2600' )
06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21305' AND id_supplier = '109'
06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21305' , '109' , '1' )
06/07/2023 04:22:36 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
( '86659' , '21302' , 'PERCHE IL SUD E RIMASTO INDIETRO' , '1' , '0' , '4' ,
'7.68' , '7.68' , '0' , '0' , '7.6800' )
06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21302' AND id_supplier = '109'
06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21302' , '109' , '1' )
06/07/2023 04:22:36 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
( '86659' , '21300' , 'PREDOMINIO DELLOCCIDENTE' , '1' , '0' , '4' ,
'8.26' , '8.26' , '0' , '0' , '8.2600' )
06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21300' AND id_supplier = '109'
06/07/2023 04:22:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21300' , '109' , '1' )
06/07/2023 04:22:36 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
( '86659' , '21308' , 'COMUNISTI MANGIANO I BAMBINI' , '1' , '0' , '4' ,
'7.1' , '7.1' , '0' , '0' , '7.1000' )
06/07/2023 04:22:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21308' AND id_supplier = '109'
06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21308' , '109' , '1' )
06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '86659' , '21334' , 'RACCONTO DI ULISSE' , '1' , '0' , '4' ,
'32.49' , '32.49' , '0' , '0' , '32.4900' )
06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21334' AND id_supplier = '109'
06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21334' , '109' , '1' )
06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '86659' , '21310' , 'GRANDE RACCONTO DELLE RELIGIONI' , '1' , '0' , '4' ,
'29.54' , '29.54' , '0' , '0' , '29.5400' )
06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21310' AND id_supplier = '109'
06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21310' , '109' , '1' )
06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '86659' , '21333' , 'CROCIATE DEL NORD' , '1' , '0' , '4' ,
'8.26' , '8.26' , '0' , '0' , '8.2600' )
06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21333' AND id_supplier = '109'
06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21333' , '109' , '1' )
06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '86659' , '21301' , 'IMPERATORI DI BISANZIO' , '1' , '0' , '4' ,
'7.1' , '7.1' , '0' , '0' , '7.1000' )
06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21301' AND id_supplier = '109'
06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21301' , '109' , '1' )
06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '86659' , '21321' , 'SECOLO DEI GENOCIDI' , '1' , '0' , '4' ,
'8.26' , '8.26' , '0' , '0' , '8.2600' )
06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21321' AND id_supplier = '109'
06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21321' , '109' , '1' )
06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '86659' , '21326' , 'IL CAPO' , '1' , '0' , '4' ,
'8.26' , '8.26' , '0' , '0' , '8.2600' )
06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21326' AND id_supplier = '109'
06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21326' , '109' , '1' )
06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '86659' , '21298' , 'SEDUCENTI IMMAGINI' , '1' , '0' , '4' ,
'20.67' , '20.67' , '0' , '0' , '20.6700' )
06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21298' AND id_supplier = '109'
06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21298' , '109' , '1' )
06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '86659' , '21309' , 'GRANDE RACCONTO DEI VIAGGI DESPLORAZIONE' , '1' , '0' , '4' ,
'28.35' , '28.35' , '0' , '0' , '28.3500' )
06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21309' AND id_supplier = '109'
06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21309' , '109' , '1' )
06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '86659' , '21315' , 'SANTITA NEL MEDIOEVO' , '1' , '0' , '4' ,
'11.23' , '11.23' , '0' , '0' , '11.2300' )
06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21315' AND id_supplier = '109'
06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21315' , '109' , '1' )
06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '86659' , '21311' , 'STORIA DELLA MASSONERIA ITALIANA' , '1' , '0' , '4' ,
'9.45' , '9.45' , '0' , '0' , '9.4500' )
06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21311' AND id_supplier = '109'
06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21311' , '109' , '1' )
06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '86659' , '21314' , 'GRANDE RACCONTO DELLE CITTA ITALIANE' , '1' , '0' , '4' ,
'29.54' , '29.54' , '0' , '0' , '29.5400' )
06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21314' AND id_supplier = '109'
06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21314' , '109' , '1' )
06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '86659' , '21331' , 'RAZZISMI DALLE CROCIATE AL XX SECOLO' , '1' , '0' , '4' ,
'12.99' , '12.99' , '0' , '0' , '12.9900' )
06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21331' AND id_supplier = '109'
06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21331' , '109' , '1' )
06/07/2023 04:22:37 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '86659' , '21323' , 'ARABI E LEUROPA NEL MEDIO EVO' , '1' , '0' , '4' ,
'8.26' , '8.26' , '0' , '0' , '8.2600' )
06/07/2023 04:22:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21323' AND id_supplier = '109'
06/07/2023 04:22:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21323' , '109' , '1' )
06/07/2023 04:22:38 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
( '86659' , '21316' , 'ERETICI' , '1' , '0' , '4' ,
'7.1' , '7.1' , '0' , '0' , '7.1000' )
06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21316' AND id_supplier = '109'
06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21316' , '109' , '1' )
06/07/2023 04:22:38 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
( '86659' , '21297' , 'VINO E LA CARNE' , '1' , '0' , '4' ,
'7.1' , '7.1' , '0' , '0' , '7.1000' )
06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21297' AND id_supplier = '109'
06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21297' , '109' , '1' )
06/07/2023 04:22:38 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
( '86659' , '21325' , 'ITALIA FASCISTA E LA PERSECUZIONE' , '1' , '0' , '4' ,
'9.45' , '9.45' , '0' , '0' , '9.4500' )
06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21325' AND id_supplier = '109'
06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21325' , '109' , '1' )
06/07/2023 04:22:38 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
( '86659' , '21330' , 'CROCIATE' , '1' , '0' , '4' ,
'7.10' , '7.1' , '0' , '0' , '7.1000' )
06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21330' AND id_supplier = '109'
06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21330' , '109' , '1' )
06/07/2023 04:22:38 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
( '86659' , '21295' , 'GUERRA SANTA - J. FLORI' , '1' , '0' , '1' ,
'8.26' , '6.7704918032787' , '22' , '0' , '10.0772' )
06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21295' AND id_supplier = '109'
06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21295' , '109' , '1' )
06/07/2023 04:22:38 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
( '86659' , '21213' , 'Le exterae gentes in Valerio Massimo' , '1' , '0' , '4' ,
'18.2' , '18.2' , '0' , '0' , '18.2000' )
06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21213' AND id_supplier = '109'
06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21213' , '109' , '1' )
06/07/2023 04:22:38 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
( '86659' , '21214' , 'Migranti e lavoro qualificato nel mondo antico' , '1' , '0' , '4' ,
'16.8' , '16.8' , '0' , '0' , '16.8000' )
06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21214' AND id_supplier = '109'
06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21214' , '109' , '1' )
06/07/2023 04:22:38 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
( '86659' , '21218' , 'Tra mare e continente: lisola dEubea' , '1' , '0' , '4' ,
'15.6' , '15.6' , '0' , '0' , '15.6000' )
06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21218' AND id_supplier = '109'
06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21218' , '109' , '1' )
06/07/2023 04:22:38 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
( '86659' , '21221' , 'L «Onomasticon» di Giulio Polluce. Tra lessicografia e antiquaria' , '1' , '0' , '4' ,
'9.60' , '9.6' , '0' , '0' , '9.6000' )
06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21221' AND id_supplier = '109'
06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21221' , '109' , '1' )
06/07/2023 04:22:38 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
( '86659' , '21212' , 'Erodiano. Tra crisi e trasformazione' , '1' , '0' , '4' ,
'15.01' , '15.01' , '0' , '0' , '15.0100' )
06/07/2023 04:22:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21212' AND id_supplier = '109'
06/07/2023 04:22:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21212' , '109' , '1' )
06/07/2023 04:31:14 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2314' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 04:31:14 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'2314' ,
'2023-07-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'390.00' ,
'319.67' ,
NOW() ,
NOW() )
06/07/2023 04:31: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 = '86660'
06/07/2023 04:31:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '86660'
06/07/2023 04:31: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
( '86660' , '19855' , 'STOLA ROMANA S/MOIRE - 7606S' , '1' , '-1' , '1' ,
'390.00' , '319.67213114754' , '22' , '0' , '390.00' )
06/07/2023 04:33:22 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2315' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 04:33:22 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'2315' ,
'2023-07-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'155.00' ,
'127.05' ,
NOW() ,
NOW() )
06/07/2023 04:33: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 = '86661'
06/07/2023 04:33:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '86661'
06/07/2023 04:33: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
( '86661' , '14367' , 'CLERGY TESS. BOSTON - GRIGIO - MISTO ML 38' , '1' , '-1' , '1' ,
'44.1' , '36.147540983607' , '22' , '0' , '44.10' )
06/07/2023 04:33: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
( '86661' , '14380' , 'CLERGY TESS. BOSTON - BLU - MISTO ML 38' , '1' , '-1' , '1' ,
'40' , '32.786885245902' , '22' , '0' , '40.00' )
06/07/2023 04:33: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
( '86661' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' ,
'35' , '28.688524590164' , '22' , '0' , '35.00' )
06/07/2023 04:33: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
( '86661' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' ,
'35.9' , '29.426229508197' , '22' , '0' , '35.90' )
06/07/2023 04:39:51 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2315' AND id_document != '86661' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 04:39:51 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '2315',
document_date = '2023-07-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 = '155.00',
price_tax_excluded = '127.05',
date_upd = NOW()
WHERE id_document = '86661'
06/07/2023 04:39:51 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 = '86661'
06/07/2023 04:39:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '86661'
06/07/2023 04:39: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
( '86661' , '14367' , 'CLERGY TESS. BOSTON - GRIGIO - MISTO ML 38' , '1' , '-1' , '1' ,
'50' , '40.983606557377' , '22' , '0' , '50.00' )
06/07/2023 04:39: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
( '86661' , '14380' , 'CLERGY TESS. BOSTON - BLU - MISTO ML 38' , '1' , '-1' , '1' ,
'50' , '40.983606557377' , '22' , '0' , '50.00' )
06/07/2023 04:39: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
( '86661' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' ,
'39.9' , '32.704918032787' , '22' , '0' , '39.90' )
06/07/2023 04:39: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
( '86661' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'15.1' , '12.377049180328' , '22' , '0' , '15.10' )
06/07/2023 04:40:46 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1269' AND id_document != '82831' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-17')
06/07/2023 04:40:46 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '1269',
document_date = '2023-04-17',
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 = '15.00',
price_tax_excluded = '12.30',
date_upd = NOW()
WHERE id_document = '82831'
06/07/2023 04:40:46 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 = '82831'
06/07/2023 04:40:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '82831'
06/07/2023 04:40:46 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
( '82831' , '17005' , 'BIGLIETTO AUGURALE medio' , '7' , '-7' , '1' ,
'1.00' , '0.81967213114754' , '22' , '0' , '7.00' )
06/07/2023 04:40:46 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
( '82831' , '739' , 'ARC. GABRIELE BABY - 023 AR/G/9 BB' , '1' , '-1' , '1' ,
'8.0000' , '6.5573770491803' , '22' , '0' , '8.00' )
06/07/2023 04:43:20 pm >> UPDATE ps_document SET
id_document_type = '32',
document_num = '6023274660',
document_date = '2023-06-30',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '4669106',
address1 = 'VIA G. VERDI, 8 20090 ASSAGO',
address2 = '',
note = '',
price_shipping = '19.2',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '13',
id_causal = '0',
price_tax_included = '644.40',
price_tax_excluded = '642.58',
date_upd = NOW()
WHERE id_document = '86659'
06/07/2023 04:43: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 = '86659'
06/07/2023 04:43:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '86659'
06/07/2023 04:43:20 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
( '86659' , '21296' , 'PIETRE DI GERUSALEMME' , '1' , '0' , '4' ,
'16.5400' , '16.54' , '0' , '0' , '16.54' )
06/07/2023 04:43:20 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
( '86659' , '21318' , 'TRAUMI DEUROPA' , '1' , '0' , '4' ,
'7.6800' , '7.68' , '0' , '0' , '7.68' )
06/07/2023 04:43:20 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
( '86659' , '21335' , 'AMARSI SEDUZIONE E DESIDERIO' , '1' , '0' , '4' ,
'28.3500' , '28.35' , '0' , '0' , '28.35' )
06/07/2023 04:43:20 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
( '86659' , '21317' , 'GRANDE RACCONTO DI ROMA ANTICA' , '1' , '0' , '4' ,
'23.6200' , '23.62' , '0' , '0' , '23.62' )
06/07/2023 04:43:20 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
( '86659' , '21337' , 'GRANDE RACCONTO DEL FAVOLOSO ORIENTE' , '1' , '0' , '4' ,
'28.3500' , '28.35' , '0' , '0' , '28.35' )
06/07/2023 04:43:20 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
( '86659' , '21299' , 'DONNE DI DANTE' , '1' , '0' , '4' ,
'22.4600' , '22.46' , '0' , '0' , '22.46' )
06/07/2023 04:43:20 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
( '86659' , '21324' , 'DONNA ROMANA' , '1' , '0' , '4' ,
'7.6800' , '7.68' , '0' , '0' , '7.68' )
06/07/2023 04:43:20 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
( '86659' , '21332' , 'GUERRIERO LOPLITA IL LEGIONARIO' , '1' , '0' , '4' ,
'7.6800' , '7.68' , '0' , '0' , '7.68' )
06/07/2023 04:43:20 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
( '86659' , '21303' , 'OLTREMARE' , '1' , '0' , '4' ,
'9.4500' , '9.45' , '0' , '0' , '9.45' )
06/07/2023 04:43:20 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
( '86659' , '21336' , 'PARADISO VISTA INFERNO' , '1' , '0' , '4' ,
'22.4600' , '22.46' , '0' , '0' , '22.46' )
06/07/2023 04:43:20 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
( '86659' , '21306' , 'FEDERICO II' , '1' , '0' , '4' ,
'7.6800' , '7.68' , '0' , '0' , '7.68' )
06/07/2023 04:43:20 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
( '86659' , '21304' , 'SICILIA MUSULMANA' , '1' , '0' , '4' ,
'7.6800' , '7.68' , '0' , '0' , '7.68' )
06/07/2023 04:43:20 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
( '86659' , '21320' , 'CONTRO UN NEMICO INVISIBILE' , '1' , '0' , '4' ,
'8.2600' , '8.26' , '0' , '0' , '8.26' )
06/07/2023 04:43:20 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
( '86659' , '21319' , 'STORIA ECONOMICA DELLEUROPA' , '1' , '0' , '4' ,
'8.8600' , '8.86' , '0' , '0' , '8.86' )
06/07/2023 04:43:20 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
( '86659' , '21327' , 'STORIA DEL REGNO DELLE DUE SICILIE' , '1' , '0' , '4' ,
'8.2600' , '8.26' , '0' , '0' , '8.26' )
06/07/2023 04:43:20 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
( '86659' , '21329' , 'MILITARI ITALIANI NEI LAGER NAZISTI' , '1' , '0' , '4' ,
'8.8600' , '8.86' , '0' , '0' , '8.86' )
06/07/2023 04:43:20 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
( '86659' , '21313' , 'TEMPLARI' , '1' , '0' , '4' ,
'7.1000' , '7.1' , '0' , '0' , '7.10' )
06/07/2023 04:43:20 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
( '86659' , '21328' , 'RIBELLI CONTRO ROMA' , '1' , '0' , '4' ,
'7.6800' , '7.68' , '0' , '0' , '7.68' )
06/07/2023 04:43:20 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
( '86659' , '21312' , 'ERETICI ED ERESIE MEDIEVALI' , '1' , '0' , '4' ,
'7.1000' , '7.1' , '0' , '0' , '7.10' )
06/07/2023 04:43:20 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
( '86659' , '21307' , 'IN VIAGGIO NEL MEDIOEVO' , '1' , '0' , '4' ,
'8.2600' , '8.26' , '0' , '0' , '8.26' )
06/07/2023 04:43:20 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
( '86659' , '21322' , 'TERRASANTA PELLEGRINI ITALIANI' , '1' , '0' , '4' ,
'9.4500' , '9.45' , '0' , '0' , '9.45' )
06/07/2023 04:43: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
( '86659' , '21305' , 'STORIA DI BISANZIO' , '1' , '0' , '4' ,
'8.2600' , '8.26' , '0' , '0' , '8.26' )
06/07/2023 04:43: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
( '86659' , '21302' , 'PERCHE IL SUD E RIMASTO INDIETRO' , '1' , '0' , '4' ,
'7.6800' , '7.68' , '0' , '0' , '7.68' )
06/07/2023 04:43: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
( '86659' , '21300' , 'PREDOMINIO DELLOCCIDENTE' , '1' , '0' , '4' ,
'8.2600' , '8.26' , '0' , '0' , '8.26' )
06/07/2023 04:43: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
( '86659' , '21308' , 'COMUNISTI MANGIANO I BAMBINI' , '1' , '0' , '4' ,
'7.1000' , '7.1' , '0' , '0' , '7.10' )
06/07/2023 04:43: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
( '86659' , '21334' , 'RACCONTO DI ULISSE' , '1' , '0' , '4' ,
'32.4900' , '32.49' , '0' , '0' , '32.49' )
06/07/2023 04:43: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
( '86659' , '21310' , 'GRANDE RACCONTO DELLE RELIGIONI' , '1' , '0' , '4' ,
'29.5400' , '29.54' , '0' , '0' , '29.54' )
06/07/2023 04:43: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
( '86659' , '21333' , 'CROCIATE DEL NORD' , '1' , '0' , '4' ,
'8.2600' , '8.26' , '0' , '0' , '8.26' )
06/07/2023 04:43: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
( '86659' , '21301' , 'IMPERATORI DI BISANZIO' , '1' , '0' , '4' ,
'7.1000' , '7.1' , '0' , '0' , '7.10' )
06/07/2023 04:43: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
( '86659' , '21321' , 'SECOLO DEI GENOCIDI' , '1' , '0' , '4' ,
'8.2600' , '8.26' , '0' , '0' , '8.26' )
06/07/2023 04:43: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
( '86659' , '21326' , 'IL CAPO' , '1' , '0' , '4' ,
'8.2600' , '8.26' , '0' , '0' , '8.26' )
06/07/2023 04:43: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
( '86659' , '21298' , 'SEDUCENTI IMMAGINI' , '1' , '0' , '4' ,
'20.6700' , '20.67' , '0' , '0' , '20.67' )
06/07/2023 04:43: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
( '86659' , '21309' , 'GRANDE RACCONTO DEI VIAGGI DESPLORAZIONE' , '1' , '0' , '4' ,
'28.3500' , '28.35' , '0' , '0' , '28.35' )
06/07/2023 04:43: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
( '86659' , '21315' , 'SANTITA NEL MEDIOEVO' , '1' , '0' , '4' ,
'11.2300' , '11.23' , '0' , '0' , '11.23' )
06/07/2023 04:43: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
( '86659' , '21311' , 'STORIA DELLA MASSONERIA ITALIANA' , '1' , '0' , '4' ,
'9.4500' , '9.45' , '0' , '0' , '9.45' )
06/07/2023 04:43: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
( '86659' , '21314' , 'GRANDE RACCONTO DELLE CITTA ITALIANE' , '1' , '0' , '4' ,
'29.5400' , '29.54' , '0' , '0' , '29.54' )
06/07/2023 04:43: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
( '86659' , '21331' , 'RAZZISMI DALLE CROCIATE AL XX SECOLO' , '1' , '0' , '4' ,
'12.9900' , '12.99' , '0' , '0' , '12.99' )
06/07/2023 04:43: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
( '86659' , '21323' , 'ARABI E LEUROPA NEL MEDIO EVO' , '1' , '0' , '4' ,
'8.2600' , '8.26' , '0' , '0' , '8.26' )
06/07/2023 04:43: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
( '86659' , '21316' , 'ERETICI' , '1' , '0' , '4' ,
'7.1000' , '7.1' , '0' , '0' , '7.10' )
06/07/2023 04:43: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
( '86659' , '21297' , 'VINO E LA CARNE' , '1' , '0' , '4' ,
'7.1000' , '7.1' , '0' , '0' , '7.10' )
06/07/2023 04:43: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
( '86659' , '21325' , 'ITALIA FASCISTA E LA PERSECUZIONE' , '1' , '0' , '4' ,
'9.4500' , '9.45' , '0' , '0' , '9.45' )
06/07/2023 04:43: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
( '86659' , '21330' , 'CROCIATE' , '1' , '0' , '4' ,
'7.1000' , '7.1' , '0' , '0' , '7.10' )
06/07/2023 04:43: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
( '86659' , '21295' , 'GUERRA SANTA - J. FLORI' , '1' , '0' , '1' ,
'8.2600' , '6.7704918032787' , '22' , '0' , '10.08' )
06/07/2023 04:43: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
( '86659' , '21213' , 'Le exterae gentes in Valerio Massimo' , '1' , '0' , '4' ,
'18.2000' , '18.2' , '0' , '0' , '18.20' )
06/07/2023 04:43: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
( '86659' , '21214' , 'Migranti e lavoro qualificato nel mondo antico' , '1' , '0' , '4' ,
'16.8000' , '16.8' , '0' , '0' , '16.80' )
06/07/2023 04:43: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
( '86659' , '21218' , 'Tra mare e continente: lisola dEubea' , '1' , '0' , '4' ,
'15.6000' , '15.6' , '0' , '0' , '15.60' )
06/07/2023 04:43: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
( '86659' , '21221' , 'L «Onomasticon» di Giulio Polluce. Tra lessicografia e antiquaria' , '1' , '0' , '4' ,
'9.6000' , '9.6' , '0' , '0' , '9.60' )
06/07/2023 04:43: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
( '86659' , '21212' , 'Erodiano. Tra crisi e trasformazione' , '1' , '0' , '4' ,
'15.0100' , '15.01' , '0' , '0' , '15.01' )
06/07/2023 05:13:06 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2316' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 05:13:06 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' ,
'2316' ,
'2023-07-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'12.00' ,
'9.84' ,
NOW() ,
NOW() )
06/07/2023 05:13:06 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 = '86662'
06/07/2023 05:13:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '86662'
06/07/2023 05:13:06 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
( '86662' , '1369' , 'BROCCHETTE DECORATE RICAMBIO ART. 500 - 556' , '1' , '-1' , '1' ,
'12' , '9.8360655737705' , '22' , '0' , '12.00' )
06/07/2023 05:22:50 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7054'
06/07/2023 05:22:50 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 (
'7054' ,
'10' ,
'173' ,
'' ,
'Appetecchi' ,
'Monica' ,
'Via Galileo Galilei , 19/21/25' ,
'' ,
'55041' ,
'Camaiore fraz. Lido di Camaiore' ,
'' ,
'' ,
'3398207911' ,
'' ,
'' ,
NOW() ,
NOW() )
06/07/2023 05:22:50 pm >> UPDATE ps_customer SET
email = 'monicaap@me.com',
sdi = '',
pec = '',
date_upd = NOW()
WHERE id_customer = '7054'
06/07/2023 05:24:05 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7054'
06/07/2023 05:24:05 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 (
'7054' ,
'10' ,
'173' ,
'' ,
'Appetecchi' ,
'Monica' ,
'Via Galileo Galilei , 19/21/25' ,
'' ,
'55041' ,
'Camaiore fraz. Lido di Camaiore' ,
'' ,
'' ,
'3398207911' ,
'' ,
'' ,
NOW() ,
NOW() )
06/07/2023 05:24:06 pm >> UPDATE ps_customer SET
email = 'monicaap@me.com',
sdi = '',
pec = '',
date_upd = NOW()
WHERE id_customer = '7054'
06/07/2023 05:28:18 pm >> SELECT document_num FROM ps_document
WHERE document_num = '35' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 05:28:18 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'35' ,
'2023-07-06' ,
'' ,
'7054' ,
'0' ,
'140021163' ,
'Via Galileo Galilei , 19/21/25 55041 Camaiore fraz. Lido di Camaiore' ,
'' ,
'' ,
'6.90' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'9' ,
'0' ,
'43.91' ,
'43.91' ,
NOW() ,
NOW() )
06/07/2023 05:28:18 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 = '11864'
06/07/2023 05:28:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '11864'
06/07/2023 05:28:18 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
( '11864' , '17' , 'LA FEDE NELLO ZAINETTO' , '1' , '-1' , '4' ,
'6.00' , '6' , '0' , '5' , '5.70' )
06/07/2023 05:28:18 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
( '11864' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU\'' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '5' , '2.85' )
06/07/2023 05:28:18 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
( '11864' , '67' , 'CON GESU\' SULLA VIA DELLA CROCE - VIA CRUCIS ' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '5' , '1.90' )
06/07/2023 05:28:18 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
( '11864' , '96' , 'LA PREGHIERA - MEDICINA DELL\'ANIMA' , '1' , '-1' , '4' ,
'1.50' , '1.5' , '0' , '5' , '1.43' )
06/07/2023 05:28:18 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
( '11864' , '110' , 'SE MI AMI NON PIANGERE' , '1' , '-1' , '4' ,
'1.80' , '1.8' , '0' , '5' , '1.71' )
06/07/2023 05:28:18 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
( '11864' , '115' , 'SAN FRANCESCO D\'ASSISI RACCONTATO AI RAGAZZI N.E.' , '1' , '-1' , '4' ,
'4.00' , '4' , '0' , '5' , '3.80' )
06/07/2023 05:28:18 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
( '11864' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '5' , '2.38' )
06/07/2023 05:28:18 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
( '11864' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '5' , '2.38' )
06/07/2023 05:28:18 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
( '11864' , '123' , 'DIO E\' IN DIECI PAROLE - COMANDAMENTI' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '5' , '2.85' )
06/07/2023 05:28:18 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
( '11864' , '126' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '5' , '1.90' )
06/07/2023 05:28:18 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
( '11864' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '5' , '2.38' )
06/07/2023 05:28:18 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
( '11864' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '5' , '2.85' )
06/07/2023 05:28:18 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
( '11864' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '5' , '2.38' )
06/07/2023 05:28: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
( '11864' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '0' , '2.50' )
06/07/2023 05:30:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571351' AND id_product != '132' AND ean13 != ''
06/07/2023 05:30:56 pm >> UPDATE ps_product SET
id_supplier = '53',
reference = '',
ean13 = '9788899571351',
date_upd = NOW()
WHERE id_product = '132'
06/07/2023 05:30:56 pm >> UPDATE ps_product_lang SET
name = 'MINISTRANTI IERI, OGGI, DOMANI',
description = 'Per rendere solenne la liturgia eucaristica, la Chiesa chiama i ragazzi a renderla bella, dignitosa e solenne, tramite il loro servizio sull\'altare, ciascuno con un suo specifico ufficio o incarico.
Ad essi era dato il nome di \"chierichetti\", sostituito oggi con quello di \"ministranti\" che significa \"coloro che servono\':
'
WHERE id_product = '132'
06/07/2023 05:30:56 pm >> UPDATE ps_product SET
wholesale_price = '0.30',
on_sale = '0',
price = '2.50'
WHERE id_product = '132'
06/07/2023 05:30:56 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.30',
price = '2.50',
id_tax_rules_group = '4',
id_category_default = '2',
id_argoment_default = '',
id_internal_category = '449',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '132'
06/07/2023 05:30:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '132'
06/07/2023 05:30:56 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' , '132' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
06/07/2023 05:34:24 pm >> SELECT document_num FROM ps_document
WHERE document_num = '32/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 05:34: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 (
'23' ,
'32/E' ,
'2023-07-06' ,
'E' ,
'2938' ,
'0' ,
'4678844' ,
'VIA ARCIVESCOVATO 31 55100 LUCCA' ,
'' ,
'' ,
'10' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'190.00' ,
'190.00' ,
NOW() ,
NOW() )
06/07/2023 05:34: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 = '86663'
06/07/2023 05:34:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '86663'
06/07/2023 05:34: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
( '86663' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '30' , '-30' , '4' ,
'10.00' , '10' , '0' , '40' , '180.00' )
06/07/2023 06:13:17 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2317' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 06:13:17 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' ,
'2317' ,
'2023-07-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'17.00' ,
'13.93' ,
NOW() ,
NOW() )
06/07/2023 06:13:17 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 = '86664'
06/07/2023 06:13:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '86664'
06/07/2023 06:13:17 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
( '86664' , '11389' , 'VINO ROSSO DOLCE - 103' , '2' , '-2' , '1' ,
'8.50' , '6.9672131147541' , '22' , '0' , '17.00' )
06/07/2023 06:40:38 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2318' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 06:40:38 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' ,
'2318' ,
'2023-07-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'36.50' ,
'29.92' ,
NOW() ,
NOW() )
06/07/2023 06:40:38 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 = '86665'
06/07/2023 06:40:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '86665'
06/07/2023 06:40:38 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
( '86665' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' ,
'36.50' , '29.918032786885' , '22' , '0' , '36.50' )
06/07/2023 06:44:12 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2319' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 06:44:12 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' ,
'2319' ,
'2023-07-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'13.00' ,
'10.66' ,
NOW() ,
NOW() )
06/07/2023 06:44:12 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 = '86666'
06/07/2023 06:44:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '86666'
06/07/2023 06:44:12 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
( '86666' , '15206' , 'ANELLO CROCE/MIRACOLOSA' , '1' , '-1' , '1' ,
'13.00' , '10.655737704918' , '22' , '0' , '13.00' )
06/07/2023 06:49:48 pm >> SELECT document_num FROM ps_document
WHERE document_num = '36' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 06:49:48 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'36' ,
'2023-07-06' ,
'' ,
'3456' ,
'0' ,
'4670110' ,
'VIA UNIONE SOVIETICA, 81 58100 GROSSETO' ,
'' ,
'' ,
'2.9' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'6' ,
'0' ,
'20.00' ,
'20.00' ,
NOW() ,
NOW() )
06/07/2023 06:49:48 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 = '11865'
06/07/2023 06:49:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '11865'
06/07/2023 06:49:48 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
( '11865' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' ,
'18.00' , '18' , '0' , '5' , '17.10' )
06/07/2023 07:05:13 pm >> SELECT document_num FROM ps_document
WHERE document_num = '32/E' AND id_document != '86663' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-06')
06/07/2023 07:05:13 pm >> UPDATE ps_document SET
id_document_type = '23',
document_num = '32/E',
document_date = '2023-07-06',
document_letter = 'E',
id_customer = '2938',
id_supplier = '',
id_address = '4678844',
address1 = 'VIA ARCIVESCOVATO 31 55100 LUCCA',
address2 = '',
note = '',
price_shipping = '',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '3',
id_causal = '0',
price_tax_included = '190.00',
price_tax_excluded = '190.00',
date_upd = NOW()
WHERE id_document = '86663'
06/07/2023 07:05:13 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 = '86663'
06/07/2023 07:05:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '86663'
06/07/2023 07:05:13 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
( '86663' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '30' , '-30' , '4' ,
'10.0000' , '10' , '0' , '40' , '180.00' )
06/07/2023 07:05:13 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
( '86663' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '4' ,
'10' , '10' , '0' , '0' , '10.00' )
06/07/2023 07:36:00 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 (
'32' ,
'6023274656' ,
'2023-06-30' ,
'' ,
'0' ,
'109' ,
'4669106' ,
'VIA G. VERDI, 8 20090 ASSAGO' ,
'' ,
'' ,
'1.82' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'12' ,
'0' ,
'60.96' ,
'60.96' ,
NOW() ,
NOW() )
06/07/2023 07:36:00 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 = '86667'
06/07/2023 07:36:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '86667'
06/07/2023 07:36:00 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
( '86667' , '21160' , 'STORIA DELLA TEOLOGIA 1 - B. MONDIN' , '1' , '0' , '4' ,
'38.35' , '38.35' , '0' , '0' , '38.3500' )
06/07/2023 07:36:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21160' AND id_supplier = '109'
06/07/2023 07:36:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21160' , '109' , '1' )
06/07/2023 07:36:00 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
( '86667' , '21338' , 'DIO DI ABRAMO - A. MELLO' , '1' , '0' , '4' ,
'11.04' , '11.04' , '0' , '0' , '11.0400' )
06/07/2023 07:36:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21338' AND id_supplier = '109'
06/07/2023 07:36:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21338' , '109' , '1' )
06/07/2023 07:36:00 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
( '86667' , '21343' , 'LETTERE DI GIOVANNI - G.I. GARGANO' , '1' , '0' , '4' ,
'9.75' , '9.75' , '0' , '0' , '9.7500' )
06/07/2023 07:36:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21343' AND id_supplier = '109'
06/07/2023 07:36:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21343' , '109' , '1' )