27/09/2022 08:35:20 am >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '5548'
27/09/2022 08:35:20 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '5548'
27/09/2022 08:44:01 am >> SELECT document_num FROM ps_document
WHERE document_num = '25' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 08:44:01 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'24' ,
'25' ,
'2022-09-27' ,
'' ,
'0' ,
'144' ,
'4670971' ,
'VIA DELLE FRATTE, 3 84080 PELLEZZANO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'1559.62' ,
'1559.62' ,
NOW() ,
NOW() )
27/09/2022 08:44:01 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 = '61951'
27/09/2022 08:44:01 am >> DELETE FROM ps_document_detail WHERE id_document = '61951'
27/09/2022 08:44:01 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
( '61951' , '6629' , 'MIA PREGHIERA' , '169' , '-169' , '4' ,
'0.13' , '0.13' , '0' , '0' , '21.97' )
27/09/2022 08:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '144'
27/09/2022 08:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '144' , '1' )
27/09/2022 08:44:01 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
( '61951' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '108' , '-108' , '4' ,
'3.46' , '3.46' , '0' , '0' , '373.68' )
27/09/2022 08:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '1886' AND id_supplier = '144'
27/09/2022 08:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1886' , '144' , '1' )
27/09/2022 08:44:01 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
( '61951' , '3511' , 'DIO PARLA ALLUOMO' , '117' , '-117' , '4' ,
'1.17' , '1.17' , '0' , '0' , '136.89' )
27/09/2022 08:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '3511' AND id_supplier = '144'
27/09/2022 08:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3511' , '144' , '1' )
27/09/2022 08:44:01 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
( '61951' , '5251' , 'INCONTRI EUCARISTICI' , '87' , '-87' , '4' ,
'0.8' , '0.8' , '0' , '0' , '69.60' )
27/09/2022 08:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '5251' AND id_supplier = '144'
27/09/2022 08:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5251' , '144' , '1' )
27/09/2022 08:44:01 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
( '61951' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '301' , '-301' , '4' ,
'0.5' , '0.5' , '0' , '0' , '150.50' )
27/09/2022 08:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '19160' AND id_supplier = '144'
27/09/2022 08:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19160' , '144' , '1' )
27/09/2022 08:44:01 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
( '61951' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '147' , '-147' , '4' ,
'1.33' , '1.33' , '0' , '0' , '195.51' )
27/09/2022 08:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '1001' AND id_supplier = '144'
27/09/2022 08:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1001' , '144' , '1' )
27/09/2022 08:44:01 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
( '61951' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '186' , '-186' , '4' ,
'1.33' , '1.33' , '0' , '0' , '247.38' )
27/09/2022 08:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '1002' AND id_supplier = '144'
27/09/2022 08:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1002' , '144' , '1' )
27/09/2022 08:44:01 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
( '61951' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '153' , '-153' , '4' ,
'1.33' , '1.33' , '0' , '0' , '203.49' )
27/09/2022 08:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '1003' AND id_supplier = '144'
27/09/2022 08:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1003' , '144' , '1' )
27/09/2022 08:44:01 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
( '61951' , '3978' , 'EUCARISTIA: RITO E VITA' , '146' , '-146' , '4' ,
'1.1' , '1.1' , '0' , '0' , '160.60' )
27/09/2022 08:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '3978' AND id_supplier = '144'
27/09/2022 08:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3978' , '144' , '1' )
27/09/2022 09:03:37 am >> SELECT document_num FROM ps_document
WHERE document_num = '10' AND id_document != '6083' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-09-22')
27/09/2022 09:03:37 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '10',
document_date = '2022-09-22',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '4670189',
address1 = 'VIA DEI CASTANI, 116 00172 ROMA',
address2 = '',
note = 'macero',
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 = '1234.67',
price_tax_excluded = '1234.67',
date_upd = NOW()
WHERE id_document = '6083'
27/09/2022 09:03:37 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '6083'
27/09/2022 09:03:38 am >> DELETE FROM ps_document_detail WHERE id_document = '6083'
27/09/2022 09:03:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '6083' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '349' , '-349' , '4' ,
'0.2600' , '0.26' , '0' , '0' , '90.74' )
27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '23' AND id_supplier = ''
27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23' , '' , '1' )
27/09/2022 09:03:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '6083' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '4' , '-4' , '4' ,
'0.2200' , '0.22' , '0' , '0' , '0.88' )
27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '67' AND id_supplier = ''
27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '67' , '' , '1' )
27/09/2022 09:03:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '6083' , '116' , 'DIZIONARIO DEI SIMBOLI DEL PICCOLO CRISTIANO NE' , '14' , '-14' , '4' ,
'0.2700' , '0.27' , '0' , '0' , '3.78' )
27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '116' AND id_supplier = ''
27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '116' , '' , '1' )
27/09/2022 09:03:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '6083' , '66' , 'BEATI GLI INVITATI ALLA CENA DEL SIGNORE' , '5' , '-5' , '4' ,
'0.9000' , '0.9' , '0' , '0' , '4.50' )
27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '66' AND id_supplier = ''
27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '66' , '' , '1' )
27/09/2022 09:03:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '6083' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '13' , '-13' , '4' ,
'0.5000' , '0.5' , '0' , '0' , '6.50' )
27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '127' AND id_supplier = ''
27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '127' , '' , '1' )
27/09/2022 09:03:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '6083' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '62' , '-62' , '4' ,
'0.3000' , '0.3' , '0' , '0' , '18.60' )
27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '118' AND id_supplier = ''
27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '118' , '' , '1' )
27/09/2022 09:03:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '6083' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '7' , '-7' , '4' ,
'0.3500' , '0.35' , '0' , '0' , '2.45' )
27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '25' AND id_supplier = ''
27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '25' , '' , '1' )
27/09/2022 09:03:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '6083' , '21' , 'LA COMUNIONE' , '4' , '-4' , '4' ,
'0.2600' , '0.26' , '0' , '0' , '1.04' )
27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '21' AND id_supplier = ''
27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21' , '' , '1' )
27/09/2022 09:03:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '6083' , '17' , 'LA FEDE NELLO ZAINETTO' , '3' , '-3' , '4' ,
'0.4000' , '0.4' , '0' , '0' , '1.20' )
27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '17' AND id_supplier = ''
27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17' , '' , '1' )
27/09/2022 09:03:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '6083' , '103' , 'Lo Spirito Santo raccontato ai ragazzi N.E.' , '3' , '-3' , '4' ,
'0.3000' , '0.3' , '0' , '0' , '0.90' )
27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '103' AND id_supplier = ''
27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '103' , '' , '1' )
27/09/2022 09:03:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '6083' , '60' , 'IL NATALE SPIEGATO AI BAMBINI' , '31' , '-31' , '4' ,
'0.3000' , '0.3' , '0' , '0' , '9.30' )
27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '60' AND id_supplier = ''
27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '60' , '' , '1' )
27/09/2022 09:03:38 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '6083' , '47' , 'IL ROSARIO SPIEGATO AI BAMBINI ' , '42' , '-42' , '4' ,
'0.1900' , '0.19' , '0' , '0' , '7.98' )
27/09/2022 09:03:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '47' AND id_supplier = ''
27/09/2022 09:03:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '47' , '' , '1' )
27/09/2022 09:03:39 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '6083' , '131' , 'LIBRO AGENDA CATTOLICO 2022' , '286' , '-286' , '4' ,
'3.8000' , '3.8' , '0' , '0' , '1086.80' )
27/09/2022 09:03:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '131' AND id_supplier = ''
27/09/2022 09:03:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '131' , '' , '1' )
27/09/2022 09:06:44 am >> SELECT document_num FROM ps_document
WHERE document_num = '2848' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 09:06:44 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' ,
'2848' ,
'2022-09-27' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'9.80' ,
'8.03' ,
NOW() ,
NOW() )
27/09/2022 09:06:44 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 = '61952'
27/09/2022 09:06:44 am >> DELETE FROM ps_document_detail WHERE id_document = '61952'
27/09/2022 09:06:44 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
( '61952' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' ,
'4.90' , '4.016393442623' , '22' , '0' , '9.80' )
27/09/2022 09:06:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = ''
27/09/2022 09:06:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' )
27/09/2022 09:10:17 am >> SELECT document_num FROM ps_document
WHERE document_num = '25' AND id_document != '61951' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 09:10:17 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '25',
document_date = '2022-09-27',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '4670971',
address1 = 'VIA DELLE FRATTE, 3 84080 PELLEZZANO',
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 = '1646.20',
price_tax_excluded = '1646.20',
date_upd = NOW()
WHERE id_document = '61951'
27/09/2022 09:10:17 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 = '61951'
27/09/2022 09:10:17 am >> DELETE FROM ps_document_detail WHERE id_document = '61951'
27/09/2022 09:10:18 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
( '61951' , '6629' , 'MIA PREGHIERA' , '835' , '-835' , '4' ,
'0.1300' , '0.13' , '0' , '0' , '108.55' )
27/09/2022 09:10:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = ''
27/09/2022 09:10:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' )
27/09/2022 09:10:18 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
( '61951' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '108' , '-108' , '4' ,
'3.4600' , '3.46' , '0' , '0' , '373.68' )
27/09/2022 09:10:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '1886' AND id_supplier = ''
27/09/2022 09:10:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1886' , '' , '1' )
27/09/2022 09:10:18 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
( '61951' , '3511' , 'DIO PARLA ALLUOMO' , '117' , '-117' , '4' ,
'1.1700' , '1.17' , '0' , '0' , '136.89' )
27/09/2022 09:10:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '3511' AND id_supplier = ''
27/09/2022 09:10:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3511' , '' , '1' )
27/09/2022 09:10:18 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
( '61951' , '5251' , 'INCONTRI EUCARISTICI' , '87' , '-87' , '4' ,
'0.8000' , '0.8' , '0' , '0' , '69.60' )
27/09/2022 09:10:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '5251' AND id_supplier = ''
27/09/2022 09:10:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5251' , '' , '1' )
27/09/2022 09:10:18 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
( '61951' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '301' , '-301' , '4' ,
'0.5000' , '0.5' , '0' , '0' , '150.50' )
27/09/2022 09:10:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '19160' AND id_supplier = ''
27/09/2022 09:10:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19160' , '' , '1' )
27/09/2022 09:10:18 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
( '61951' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '147' , '-147' , '4' ,
'1.3300' , '1.33' , '0' , '0' , '195.51' )
27/09/2022 09:10:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '1001' AND id_supplier = ''
27/09/2022 09:10:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1001' , '' , '1' )
27/09/2022 09:10:18 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
( '61951' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '186' , '-186' , '4' ,
'1.3300' , '1.33' , '0' , '0' , '247.38' )
27/09/2022 09:10:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '1002' AND id_supplier = ''
27/09/2022 09:10:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1002' , '' , '1' )
27/09/2022 09:10:18 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
( '61951' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '153' , '-153' , '4' ,
'1.3300' , '1.33' , '0' , '0' , '203.49' )
27/09/2022 09:10:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '1003' AND id_supplier = ''
27/09/2022 09:10:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1003' , '' , '1' )
27/09/2022 09:10:19 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61951' , '3978' , 'EUCARISTIA: RITO E VITA' , '146' , '-146' , '4' ,
'1.1000' , '1.1' , '0' , '0' , '160.60' )
27/09/2022 09:10:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '3978' AND id_supplier = ''
27/09/2022 09:10:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3978' , '' , '1' )
27/09/2022 09:12:07 am >> SELECT document_num FROM ps_document
WHERE document_num = '25' AND id_document != '61951' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 09:12:07 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '25',
document_date = '2022-09-27',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '4670971',
address1 = 'VIA DELLE FRATTE, 3 84080 PELLEZZANO',
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 = '1733.82',
price_tax_excluded = '1733.82',
date_upd = NOW()
WHERE id_document = '61951'
27/09/2022 09:12: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 = '61951'
27/09/2022 09:12:07 am >> DELETE FROM ps_document_detail WHERE id_document = '61951'
27/09/2022 09:12: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
( '61951' , '6629' , 'MIA PREGHIERA' , '1509' , '-1509' , '4' ,
'0.1300' , '0.13' , '0' , '0' , '196.17' )
27/09/2022 09:12:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = ''
27/09/2022 09:12:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' )
27/09/2022 09:12: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
( '61951' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '108' , '-108' , '4' ,
'3.4600' , '3.46' , '0' , '0' , '373.68' )
27/09/2022 09:12:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '1886' AND id_supplier = ''
27/09/2022 09:12:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1886' , '' , '1' )
27/09/2022 09:12:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61951' , '3511' , 'DIO PARLA ALLUOMO' , '117' , '-117' , '4' ,
'1.1700' , '1.17' , '0' , '0' , '136.89' )
27/09/2022 09:12:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '3511' AND id_supplier = ''
27/09/2022 09:12:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3511' , '' , '1' )
27/09/2022 09:12:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61951' , '5251' , 'INCONTRI EUCARISTICI' , '87' , '-87' , '4' ,
'0.8000' , '0.8' , '0' , '0' , '69.60' )
27/09/2022 09:12:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '5251' AND id_supplier = ''
27/09/2022 09:12:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5251' , '' , '1' )
27/09/2022 09:12:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61951' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '301' , '-301' , '4' ,
'0.5000' , '0.5' , '0' , '0' , '150.50' )
27/09/2022 09:12:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '19160' AND id_supplier = ''
27/09/2022 09:12:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19160' , '' , '1' )
27/09/2022 09:12:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61951' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '147' , '-147' , '4' ,
'1.3300' , '1.33' , '0' , '0' , '195.51' )
27/09/2022 09:12:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '1001' AND id_supplier = ''
27/09/2022 09:12:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1001' , '' , '1' )
27/09/2022 09:12:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61951' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '186' , '-186' , '4' ,
'1.3300' , '1.33' , '0' , '0' , '247.38' )
27/09/2022 09:12:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '1002' AND id_supplier = ''
27/09/2022 09:12:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1002' , '' , '1' )
27/09/2022 09:12:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61951' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '153' , '-153' , '4' ,
'1.3300' , '1.33' , '0' , '0' , '203.49' )
27/09/2022 09:12:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '1003' AND id_supplier = ''
27/09/2022 09:12:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1003' , '' , '1' )
27/09/2022 09:12:09 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61951' , '3978' , 'EUCARISTIA: RITO E VITA' , '146' , '-146' , '4' ,
'1.1000' , '1.1' , '0' , '0' , '160.60' )
27/09/2022 09:12:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '3978' AND id_supplier = ''
27/09/2022 09:12:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3978' , '' , '1' )
27/09/2022 10:06:27 am >> SELECT document_num FROM ps_document
WHERE document_num = '25' AND id_document != '61951' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 10:06:27 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '25',
document_date = '2022-09-27',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '4670971',
address1 = 'VIA DELLE FRATTE, 3 84080 PELLEZZANO',
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 = '1643.63',
price_tax_excluded = '1643.63',
date_upd = NOW()
WHERE id_document = '61951'
27/09/2022 10:06:27 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61951'
27/09/2022 10:06:27 am >> DELETE FROM ps_document_detail WHERE id_document = '61951'
27/09/2022 10:06:27 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61951' , '6629' , 'MIA PREGHIERA' , '1509' , '-1509' , '4' ,
'0.1300' , '0.13' , '0' , '0' , '196.17' )
27/09/2022 10:06:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = ''
27/09/2022 10:06:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' )
27/09/2022 10:06:27 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61951' , '3511' , 'DIO PARLA ALLUOMO' , '117' , '-117' , '4' ,
'1.1700' , '1.17' , '0' , '0' , '136.89' )
27/09/2022 10:06:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '3511' AND id_supplier = ''
27/09/2022 10:06:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3511' , '' , '1' )
27/09/2022 10:06:27 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61951' , '5251' , 'INCONTRI EUCARISTICI' , '87' , '-87' , '4' ,
'0.8000' , '0.8' , '0' , '0' , '69.60' )
27/09/2022 10:06:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '5251' AND id_supplier = ''
27/09/2022 10:06:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5251' , '' , '1' )
27/09/2022 10:06:27 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61951' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '301' , '-301' , '4' ,
'0.5000' , '0.5' , '0' , '0' , '150.50' )
27/09/2022 10:06:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '19160' AND id_supplier = ''
27/09/2022 10:06:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19160' , '' , '1' )
27/09/2022 10:06:27 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61951' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '147' , '-147' , '4' ,
'1.3300' , '1.33' , '0' , '0' , '195.51' )
27/09/2022 10:06:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '1001' AND id_supplier = ''
27/09/2022 10:06:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1001' , '' , '1' )
27/09/2022 10:06: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
( '61951' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '186' , '-186' , '4' ,
'1.3300' , '1.33' , '0' , '0' , '247.38' )
27/09/2022 10:06:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '1002' AND id_supplier = ''
27/09/2022 10:06:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1002' , '' , '1' )
27/09/2022 10:06: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
( '61951' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '153' , '-153' , '4' ,
'1.3300' , '1.33' , '0' , '0' , '203.49' )
27/09/2022 10:06:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '1003' AND id_supplier = ''
27/09/2022 10:06:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1003' , '' , '1' )
27/09/2022 10:06: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
( '61951' , '3978' , 'EUCARISTIA: RITO E VITA' , '46' , '-46' , '4' ,
'1.1000' , '1.1' , '0' , '0' , '50.60' )
27/09/2022 10:06:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '3978' AND id_supplier = ''
27/09/2022 10:06:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3978' , '' , '1' )
27/09/2022 10:06: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
( '61951' , '11426' , 'VITA DEL CRISTIANO' , '100' , '-100' , '4' ,
'1.1' , '1.1' , '0' , '0' , '110.00' )
27/09/2022 10:06:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '11426' AND id_supplier = ''
27/09/2022 10:06:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11426' , '' , '1' )
27/09/2022 10:06: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
( '61951' , '9970' , 'SIAMO CHIESA' , '183' , '-183' , '4' ,
'0.87' , '0.87' , '0' , '0' , '159.21' )
27/09/2022 10:06:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '9970' AND id_supplier = ''
27/09/2022 10:06:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9970' , '' , '1' )
27/09/2022 10:06: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
( '61951' , '5457' , 'IO SONO CON VOI 1 PARTE' , '478' , '-478' , '4' ,
'0.26' , '0.26' , '0' , '0' , '124.28' )
27/09/2022 10:06:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = ''
27/09/2022 10:06:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' )
27/09/2022 10:06: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
( '61951' , '5458' , 'IO SONO CON VOI 2 PARTE' , '333' , '-333' , '4' ,
'' , '0' , '0' , '0' , '0.00' )
27/09/2022 10:06:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = ''
27/09/2022 10:06:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' )
27/09/2022 10:06: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
( '61951' , '5458' , 'IO SONO CON VOI 2 PARTE' , '333' , '-333' , '4' ,
'0.26' , '0.26' , '0' , '0' , '86.58' )
27/09/2022 10:06:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = ''
27/09/2022 10:06:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' )
27/09/2022 10:07:52 am >> SELECT document_num FROM ps_document
WHERE document_num = '25' AND id_document != '61951' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 10:07:53 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '25',
document_date = '2022-09-27',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '4670971',
address1 = 'VIA DELLE FRATTE, 3 84080 PELLEZZANO',
address2 = '',
note = 'MACERO',
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 = '1845.34',
price_tax_excluded = '1845.34',
date_upd = NOW()
WHERE id_document = '61951'
27/09/2022 10:07:53 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 = '61951'
27/09/2022 10:07:53 am >> DELETE FROM ps_document_detail WHERE id_document = '61951'
27/09/2022 10:07:53 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
( '61951' , '6629' , 'MIA PREGHIERA' , '1509' , '-1509' , '4' ,
'0.1300' , '0.13' , '0' , '0' , '196.17' )
27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = ''
27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' )
27/09/2022 10:07:53 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
( '61951' , '3511' , 'DIO PARLA ALLUOMO' , '117' , '-117' , '4' ,
'1.1700' , '1.17' , '0' , '0' , '136.89' )
27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '3511' AND id_supplier = ''
27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3511' , '' , '1' )
27/09/2022 10:07:53 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
( '61951' , '5251' , 'INCONTRI EUCARISTICI' , '87' , '-87' , '4' ,
'0.8000' , '0.8' , '0' , '0' , '69.60' )
27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '5251' AND id_supplier = ''
27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5251' , '' , '1' )
27/09/2022 10:07:53 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
( '61951' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '301' , '-301' , '4' ,
'0.5000' , '0.5' , '0' , '0' , '150.50' )
27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19160' AND id_supplier = ''
27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19160' , '' , '1' )
27/09/2022 10:07:53 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
( '61951' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '147' , '-147' , '4' ,
'1.3300' , '1.33' , '0' , '0' , '195.51' )
27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '1001' AND id_supplier = ''
27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1001' , '' , '1' )
27/09/2022 10:07:53 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
( '61951' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '186' , '-186' , '4' ,
'1.3300' , '1.33' , '0' , '0' , '247.38' )
27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '1002' AND id_supplier = ''
27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1002' , '' , '1' )
27/09/2022 10:07:53 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
( '61951' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '153' , '-153' , '4' ,
'1.3300' , '1.33' , '0' , '0' , '203.49' )
27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '1003' AND id_supplier = ''
27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1003' , '' , '1' )
27/09/2022 10:07:53 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
( '61951' , '3978' , 'EUCARISTIA: RITO E VITA' , '46' , '-46' , '4' ,
'1.1000' , '1.1' , '0' , '0' , '50.60' )
27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '3978' AND id_supplier = ''
27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3978' , '' , '1' )
27/09/2022 10:07:53 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
( '61951' , '11426' , 'VITA DEL CRISTIANO' , '100' , '-100' , '4' ,
'1.1000' , '1.1' , '0' , '0' , '110.00' )
27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '11426' AND id_supplier = ''
27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11426' , '' , '1' )
27/09/2022 10:07:53 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
( '61951' , '9970' , 'SIAMO CHIESA' , '183' , '-183' , '4' ,
'0.8700' , '0.87' , '0' , '0' , '159.21' )
27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '9970' AND id_supplier = ''
27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9970' , '' , '1' )
27/09/2022 10:07:53 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
( '61951' , '5457' , 'IO SONO CON VOI 1 PARTE' , '478' , '-478' , '4' ,
'0.2600' , '0.26' , '0' , '0' , '124.28' )
27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = ''
27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' )
27/09/2022 10:07:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61951' , '5458' , 'IO SONO CON VOI 2 PARTE' , '333' , '-333' , '4' ,
'0.26' , '0.26' , '0' , '0' , '86.58' )
27/09/2022 10:07:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = ''
27/09/2022 10:07:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' )
27/09/2022 10:07:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61951' , '11192' , 'VENITE CON ME 2 PARTE' , '397' , '-397' , '4' ,
'0.29' , '0.29' , '0' , '0' , '115.13' )
27/09/2022 10:07:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = ''
27/09/2022 10:07:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' )
27/09/2022 10:18:28 am >> SELECT document_num FROM ps_document
WHERE document_num = '2849' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 10:18: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' ,
'2849' ,
'2022-09-27' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'6.00' ,
'6.00' ,
NOW() ,
NOW() )
27/09/2022 10:18: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 = '61953'
27/09/2022 10:18:28 am >> DELETE FROM ps_document_detail WHERE id_document = '61953'
27/09/2022 10:18: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
( '61953' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
27/09/2022 10:18:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = ''
27/09/2022 10:18:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' )
27/09/2022 10:18: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
( '61953' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '1' , '-1' , '4' ,
'1.25' , '1.25' , '0' , '' , '1.25' )
27/09/2022 10:18:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '11103' AND id_supplier = ''
27/09/2022 10:18:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11103' , '' , '1' )
27/09/2022 10:53:54 am >> SELECT document_num FROM ps_document
WHERE document_num = '123' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 10:53:54 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'123' ,
'2022-09-27' ,
'' ,
'3191' ,
'0' ,
'4670958' ,
'VIA QUINTINO DI VONA 84133 SALERNO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'54.60' ,
'52.38' ,
NOW() ,
NOW() )
27/09/2022 10:53:54 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61954'
27/09/2022 10:53:54 am >> DELETE FROM ps_document_detail WHERE id_document = '61954'
27/09/2022 10:53:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61954' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '10' , '9.00' )
27/09/2022 10:53:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61954' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' ,
'3.50' , '3.5' , '0' , '10' , '3.15' )
27/09/2022 10:53:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61954' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '1' ,
'1.00' , '0.81967213114754' , '22' , '10' , '0.90' )
27/09/2022 10:53:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61954' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' ,
'3.50' , '3.5' , '0' , '10' , '3.15' )
27/09/2022 10:53:54 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61954' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' ,
'3.50' , '3.5' , '0' , '10' , '3.15' )
27/09/2022 10:53:55 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
( '61954' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '10' , '9.00' )
27/09/2022 10:53:55 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
( '61954' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '10' , '9.00' )
27/09/2022 10:53:55 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
( '61954' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '10' , '4.50' )
27/09/2022 10:53:55 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
( '61954' , '10419' , 'SUPPLICA ALLA REGINA DEL SS. ROSARIO' , '100' , '-100' , '1' ,
'0.10' , '0.081967213114754' , '22' , '0' , '10.00' )
27/09/2022 10:53:55 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
( '61954' , '13840' , 'NONNI SONO UN TESORO' , '1' , '-1' , '4' ,
'1.50' , '1.5' , '0' , '10' , '1.35' )
27/09/2022 10:53:55 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
( '61954' , '18222' , 'ROSARIO COLORATO - R316' , '2' , '-2' , '1' ,
'0.70' , '0.57377049180328' , '22' , '0' , '1.40' )
27/09/2022 11:03:14 am >> SELECT document_num FROM ps_document
WHERE document_num = '124' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 11:03: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 (
'21' ,
'124' ,
'2022-09-27' ,
'' ,
'835' ,
'0' ,
'4671989' ,
'VIA BRIGNANO INF 84135 SALERNO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'31.46' ,
'31.46' ,
NOW() ,
NOW() )
27/09/2022 11:03: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 = '61955'
27/09/2022 11:03:14 am >> DELETE FROM ps_document_detail WHERE id_document = '61955'
27/09/2022 11:03: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
( '61955' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' ,
'10.00' , '10' , '0' , '15' , '17.00' )
27/09/2022 11:03: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
( '61955' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' ,
'3.50' , '3.5' , '0' , '15' , '2.98' )
27/09/2022 11:03: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
( '61955' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '15' , '8.50' )
27/09/2022 11:03: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
( '61955' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' ,
'3.50' , '3.5' , '0' , '15' , '2.98' )
27/09/2022 11:03:31 am >> SELECT document_num FROM ps_document
WHERE document_num = '124' AND id_document != '61955' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 11:03:31 am >> UPDATE ps_document SET
id_document_type = '21',
document_num = '124',
document_date = '2022-09-27',
document_letter = '',
id_customer = '835',
id_supplier = '',
id_address = '4671989',
address1 = 'VIA BRIGNANO INF 84135 SALERNO',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '1',
id_causal = '0',
price_tax_included = '31.46',
price_tax_excluded = '31.46',
date_upd = NOW()
WHERE id_document = '61955'
27/09/2022 11:03:31 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 = '61955'
27/09/2022 11:03:31 am >> DELETE FROM ps_document_detail WHERE id_document = '61955'
27/09/2022 11:03:31 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61955' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' ,
'10.0000' , '10' , '0' , '15' , '17.00' )
27/09/2022 11:03:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = ''
27/09/2022 11:03:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' )
27/09/2022 11:03:32 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61955' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '15' , '2.98' )
27/09/2022 11:03:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = ''
27/09/2022 11:03:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' )
27/09/2022 11:03:32 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61955' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '15' , '8.50' )
27/09/2022 11:03:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = ''
27/09/2022 11:03:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' )
27/09/2022 11:03:32 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61955' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '15' , '2.98' )
27/09/2022 11:03:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = ''
27/09/2022 11:03:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' )
27/09/2022 11:10:08 am >> SELECT document_num FROM ps_document
WHERE document_num = '123' AND id_document != '61954' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 11:10:08 am >> UPDATE ps_document SET
id_document_type = '21',
document_num = '123',
document_date = '2022-09-27',
document_letter = '',
id_customer = '3191',
id_supplier = '',
id_address = '4670958',
address1 = 'VIA QUINTINO DI VONA 84133 SALERNO',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '1',
id_causal = '0',
price_tax_included = '54.60',
price_tax_excluded = '52.38',
date_upd = NOW()
WHERE id_document = '61954'
27/09/2022 11:10:08 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61954'
27/09/2022 11:10:08 am >> DELETE FROM ps_document_detail WHERE id_document = '61954'
27/09/2022 11:10:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61954' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '10' , '9.00' )
27/09/2022 11:10:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = ''
27/09/2022 11:10:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' )
27/09/2022 11:10:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61954' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '10' , '3.15' )
27/09/2022 11:10:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = ''
27/09/2022 11:10:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' )
27/09/2022 11:10:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61954' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '1' ,
'1.0000' , '0.81967213114754' , '22' , '10' , '0.90' )
27/09/2022 11:10:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = ''
27/09/2022 11:10:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' )
27/09/2022 11:10:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61954' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '10' , '3.15' )
27/09/2022 11:10:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = ''
27/09/2022 11:10:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' )
27/09/2022 11:10:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61954' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '10' , '3.15' )
27/09/2022 11:10:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = ''
27/09/2022 11:10:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' )
27/09/2022 11:10:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61954' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '10' , '9.00' )
27/09/2022 11:10:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = ''
27/09/2022 11:10:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' )
27/09/2022 11:10:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61954' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '10' , '9.00' )
27/09/2022 11:10:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = ''
27/09/2022 11:10:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' )
27/09/2022 11:10:08 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61954' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' ,
'5.0000' , '5' , '0' , '10' , '4.50' )
27/09/2022 11:10:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = ''
27/09/2022 11:10:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' )
27/09/2022 11:10:09 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61954' , '10419' , 'SUPPLICA ALLA REGINA DEL SS. ROSARIO' , '100' , '-100' , '1' ,
'0.1000' , '0.081967213114754' , '22' , '0' , '10.00' )
27/09/2022 11:10:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '10419' AND id_supplier = ''
27/09/2022 11:10:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10419' , '' , '1' )
27/09/2022 11:10:09 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61954' , '13840' , 'NONNI SONO UN TESORO' , '1' , '-1' , '4' ,
'1.5000' , '1.5' , '0' , '10' , '1.35' )
27/09/2022 11:10:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '13840' AND id_supplier = ''
27/09/2022 11:10:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13840' , '' , '1' )
27/09/2022 11:10:09 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61954' , '18222' , 'ROSARIO COLORATO - R316' , '2' , '-2' , '1' ,
'0.7000' , '0.57377049180328' , '22' , '0' , '1.40' )
27/09/2022 11:10:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = ''
27/09/2022 11:10:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' )
27/09/2022 11:14:26 am >> SELECT document_num FROM ps_document
WHERE document_num = '125' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 11:14:26 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' ,
'125' ,
'2022-09-27' ,
'' ,
'3134' ,
'0' ,
'4672062' ,
'VIA MIGHELANGELO, 2 94013 LEONFORTE' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'6' ,
'0' ,
'239.00' ,
'239.00' ,
NOW() ,
NOW() )
27/09/2022 11:14:26 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 = '61956'
27/09/2022 11:14:26 am >> DELETE FROM ps_document_detail WHERE id_document = '61956'
27/09/2022 11:14:26 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
( '61956' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '6' , '-6' , '4' ,
'5.50' , '5.5' , '0' , '5' , '31.35' )
27/09/2022 11:14:26 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
( '61956' , '9675' , 'SARETE MIEI TESTIMONI' , '15' , '-15' , '4' ,
'3.00' , '3' , '0' , '15' , '38.25' )
27/09/2022 11:14:26 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
( '61956' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '15' , '2.13' )
27/09/2022 11:14:26 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
( '61956' , '11193' , 'VENITE CON ME CAT.' , '7' , '-7' , '4' ,
'5.50' , '5.5' , '0' , '5' , '36.57' )
27/09/2022 11:14:26 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
( '61956' , '11191' , 'VENITE CON ME 1 PARTE' , '15' , '-15' , '4' ,
'2.50' , '2.5' , '0' , '15' , '31.88' )
27/09/2022 11:14:26 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
( '61956' , '11192' , 'VENITE CON ME 2 PARTE' , '15' , '-15' , '4' ,
'2.50' , '2.5' , '0' , '15' , '31.88' )
27/09/2022 11:14:26 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
( '61956' , '5444' , 'IO SONO CON VOI - CAT.' , '7' , '-7' , '4' ,
'5.50' , '5.5' , '0' , '5' , '36.57' )
27/09/2022 11:14:26 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
( '61956' , '5458' , 'IO SONO CON VOI 2 PARTE' , '13' , '-13' , '4' ,
'2.50' , '2.5' , '0' , '15' , '27.63' )
27/09/2022 11:14:26 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
( '61956' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' ,
'2.74' , '2.74' , '0' , '0' , '2.74' )
27/09/2022 11:32:38 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3134'
27/09/2022 11:32:38 am >> 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 (
'3134' ,
'10' ,
'154' ,
'PARROCCHIA MARIA SS. DELLA CATENA' ,
'LO GRASSO' ,
'DON ANTONINO' ,
'VIA MICHELANGELO, 2' ,
'' ,
'94013' ,
'LEONFORTE' ,
'' ,
'0935901388' ,
'' ,
'' ,
'91005260863' ,
NOW() ,
NOW() )
27/09/2022 11:32:38 am >> UPDATE ps_customer SET
email = 'antoninolograsso@alice.it',
sdi = '',
pec = '',
date_upd = NOW()
WHERE id_customer = '3134'
27/09/2022 11:36:23 am >> SELECT document_num FROM ps_document
WHERE document_num = '123' AND id_document != '61954' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 11:36:23 am >> UPDATE ps_document SET
id_document_type = '21',
document_num = '123',
document_date = '2022-09-27',
document_letter = '',
id_customer = '3191',
id_supplier = '',
id_address = '4670958',
address1 = 'VIA QUINTINO DI VONA 84133 SALERNO',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '1',
id_causal = '0',
price_tax_included = '43.20',
price_tax_excluded = '43.20',
date_upd = NOW()
WHERE id_document = '61954'
27/09/2022 11:36:23 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61954'
27/09/2022 11:36:23 am >> DELETE FROM ps_document_detail WHERE id_document = '61954'
27/09/2022 11:36: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
( '61954' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '10' , '9.00' )
27/09/2022 11:36:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = ''
27/09/2022 11:36:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' )
27/09/2022 11:36: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
( '61954' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '10' , '3.15' )
27/09/2022 11:36:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = ''
27/09/2022 11:36:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' )
27/09/2022 11:36: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
( '61954' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' ,
'1.00' , '1' , '0' , '10' , '0.90' )
27/09/2022 11:36:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = ''
27/09/2022 11:36:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' )
27/09/2022 11:36: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
( '61954' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '10' , '3.15' )
27/09/2022 11:36:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = ''
27/09/2022 11:36:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' )
27/09/2022 11:36: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
( '61954' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '10' , '3.15' )
27/09/2022 11:36:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = ''
27/09/2022 11:36:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' )
27/09/2022 11:36: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
( '61954' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '10' , '9.00' )
27/09/2022 11:36:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = ''
27/09/2022 11:36:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' )
27/09/2022 11:36: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
( '61954' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '10' , '9.00' )
27/09/2022 11:36:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = ''
27/09/2022 11:36:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' )
27/09/2022 11:36: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
( '61954' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' ,
'5.0000' , '5' , '0' , '10' , '4.50' )
27/09/2022 11:36:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = ''
27/09/2022 11:36:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' )
27/09/2022 11:36: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
( '61954' , '13840' , 'NONNI SONO UN TESORO' , '1' , '-1' , '4' ,
'1.5000' , '1.5' , '0' , '10' , '1.35' )
27/09/2022 11:36:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '13840' AND id_supplier = ''
27/09/2022 11:36:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13840' , '' , '1' )
27/09/2022 12:18:00 pm >> SELECT document_num FROM ps_document
WHERE document_num = '125' AND id_document != '61956' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 12:18:00 pm >> UPDATE ps_document SET
id_document_type = '21',
document_num = '125',
document_date = '2022-09-27',
document_letter = '',
id_customer = '3134',
id_supplier = '',
id_address = '4672062',
address1 = 'VIA MIGHELANGELO, 2 94013 LEONFORTE',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '6',
id_causal = '0',
price_tax_included = '254.84',
price_tax_excluded = '254.84',
date_upd = NOW()
WHERE id_document = '61956'
27/09/2022 12:18: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 = '61956'
27/09/2022 12:18:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '61956'
27/09/2022 12:18: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
( '61956' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '7' , '-7' , '4' ,
'5.5000' , '5.5' , '0' , '5' , '36.57' )
27/09/2022 12:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = ''
27/09/2022 12:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '' , '1' )
27/09/2022 12:18: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
( '61956' , '9675' , 'SARETE MIEI TESTIMONI' , '15' , '-15' , '4' ,
'3.0000' , '3' , '0' , '15' , '38.25' )
27/09/2022 12:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9675' AND id_supplier = ''
27/09/2022 12:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9675' , '' , '1' )
27/09/2022 12:18: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
( '61956' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '-1' , '4' ,
'2.5000' , '2.5' , '0' , '15' , '2.13' )
27/09/2022 12:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2880' AND id_supplier = ''
27/09/2022 12:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2880' , '' , '1' )
27/09/2022 12:18: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
( '61956' , '11193' , 'VENITE CON ME CAT.' , '8' , '-8' , '4' ,
'5.5000' , '5.5' , '0' , '5' , '41.80' )
27/09/2022 12:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = ''
27/09/2022 12:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' )
27/09/2022 12:18: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
( '61956' , '11191' , 'VENITE CON ME 1 PARTE' , '15' , '-15' , '4' ,
'2.5000' , '2.5' , '0' , '15' , '31.88' )
27/09/2022 12:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = ''
27/09/2022 12:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' )
27/09/2022 12:18: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
( '61956' , '11192' , 'VENITE CON ME 2 PARTE' , '15' , '-15' , '4' ,
'2.5000' , '2.5' , '0' , '15' , '31.88' )
27/09/2022 12:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = ''
27/09/2022 12:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' )
27/09/2022 12:18: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
( '61956' , '5444' , 'IO SONO CON VOI - CAT.' , '8' , '-8' , '4' ,
'5.5000' , '5.5' , '0' , '5' , '41.80' )
27/09/2022 12:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = ''
27/09/2022 12:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '' , '1' )
27/09/2022 12:18: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
( '61956' , '5458' , 'IO SONO CON VOI 2 PARTE' , '13' , '-13' , '4' ,
'2.5000' , '2.5' , '0' , '15' , '27.63' )
27/09/2022 12:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = ''
27/09/2022 12:18:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' )
27/09/2022 12:18:01 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61956' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' ,
'2.9' , '2.9' , '0' , '0' , '2.90' )
27/09/2022 12:18:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = ''
27/09/2022 12:18:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' )
27/09/2022 12:33:42 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2850' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 12:33:42 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' ,
'2850' ,
'2022-09-27' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'60.00' ,
'49.18' ,
NOW() ,
NOW() )
27/09/2022 12:33:42 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61957'
27/09/2022 12:33:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '61957'
27/09/2022 12:33:42 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61957' , '19429' , 'QUADRO DECORATO 35X29 - RC' , '1' , '-1' , '1' ,
'48' , '39.344262295082' , '22' , '0' , '48.00' )
27/09/2022 12:33:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19429' AND id_supplier = ''
27/09/2022 12:33:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19429' , '' , '1' )
27/09/2022 12:33:42 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61957' , '16252' , 'CUORE PENDENTE' , '1' , '-1' , '1' ,
'12' , '9.8360655737705' , '22' , '0' , '12.00' )
27/09/2022 12:33:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16252' AND id_supplier = ''
27/09/2022 12:33:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16252' , '' , '1' )
27/09/2022 12:41:48 pm >> SELECT document_num FROM ps_document
WHERE document_num = '72/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 12:41: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 (
'24' ,
'72/A' ,
'2022-09-27' ,
'A' ,
'3030' ,
'0' ,
'4671709' ,
'VIA SAN FELICE IN FELLINE, 10 84134 SALERNO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'144.00' ,
'144.00' ,
NOW() ,
NOW() )
27/09/2022 12:41: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 = '61958'
27/09/2022 12:41:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '61958'
27/09/2022 12:41: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
( '61958' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '60' , '-60' , '4' ,
'2.40' , '2.4' , '0' , '0' , '144.00' )
27/09/2022 12:47:39 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2851' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 12:47:39 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' ,
'2851' ,
'2022-09-27' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.50' ,
'4.33' ,
NOW() ,
NOW() )
27/09/2022 12:47:39 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 = '61959'
27/09/2022 12:47:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '61959'
27/09/2022 12:47:39 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
( '61959' , '17710' , 'OSTIA MAGNA CM 14 - OM 140' , '1' , '-1' , '3' ,
'4.50' , '4.3269230769231' , '4' , '0' , '4.50' )
27/09/2022 12:47:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17710' AND id_supplier = ''
27/09/2022 12:47:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17710' , '' , '1' )
27/09/2022 02:43:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788864344065' AND id_product != '19851' AND ean13 != ''
27/09/2022 02:43:27 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '',
ean13 = '9788864344065',
date_upd = NOW()
WHERE id_product = '19851'
27/09/2022 02:43:27 pm >> UPDATE ps_product_lang SET
name = 'SINODALMENTE',
description = ''
WHERE id_product = '19851'
27/09/2022 02:43:27 pm >> UPDATE ps_product SET
wholesale_price = '15.00',
on_sale = '0',
price = '20.0000'
WHERE id_product = '19851'
27/09/2022 02:43:27 pm >> UPDATE ps_product_shop SET
wholesale_price = '15.00',
price = '20.0000',
id_tax_rules_group = '4',
id_category_default = '30',
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 = '19851'
27/09/2022 02:43:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '19851'
27/09/2022 02:43:53 pm >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' )
27/09/2022 02:43:53 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '505' , '1' )
27/09/2022 02:43:53 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '505' , '2' )
27/09/2022 02:43:53 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '505' , '3' )
27/09/2022 02:43:53 pm >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '505' , '1' , 'NERBINI' , LOWER('NERBINI') )
27/09/2022 02:43:53 pm >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '505' , '1' , '0' )
27/09/2022 02:44:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788864344065' AND id_product != '19851' AND ean13 != ''
27/09/2022 02:44:11 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '',
ean13 = '9788864344065',
date_upd = NOW()
WHERE id_product = '19851'
27/09/2022 02:44:11 pm >> UPDATE ps_product_lang SET
name = 'SINODALMENTE',
description = ''
WHERE id_product = '19851'
27/09/2022 02:44:11 pm >> UPDATE ps_product SET
wholesale_price = '15.00',
on_sale = '0',
price = '20.0000'
WHERE id_product = '19851'
27/09/2022 02:44:11 pm >> UPDATE ps_product_shop SET
wholesale_price = '15.00',
price = '20.0000',
id_tax_rules_group = '4',
id_category_default = '505',
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 = '19851'
27/09/2022 02:44:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '19851'
27/09/2022 02:45:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861452091' AND id_product != '19850' AND ean13 != ''
27/09/2022 02:45:10 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '',
ean13 = '9788861452091',
date_upd = NOW()
WHERE id_product = '19850'
27/09/2022 02:45:10 pm >> UPDATE ps_product_lang SET
name = 'CANTO DI BERNADETTE',
description = ''
WHERE id_product = '19850'
27/09/2022 02:45:10 pm >> UPDATE ps_product SET
wholesale_price = '16.50',
on_sale = '0',
price = '22.0000'
WHERE id_product = '19850'
27/09/2022 02:45:10 pm >> UPDATE ps_product_shop SET
wholesale_price = '16.50',
price = '22.0000',
id_tax_rules_group = '4',
id_category_default = '505',
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 = '19850'
27/09/2022 02:45:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '19850'
27/09/2022 02:46:46 pm >> DELETE FROM ps_document WHERE id_document = '61712'
27/09/2022 02:46:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '61712'
27/09/2022 02:47:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001754' AND id_product != '18319' AND ean13 != ''
27/09/2022 02:47:32 pm >> UPDATE ps_product SET
id_supplier = '149',
reference = '',
ean13 = '001754',
date_upd = NOW()
WHERE id_product = '18319'
27/09/2022 02:47:32 pm >> UPDATE ps_product_lang SET
name = 'CALICE IN ARG. g 1170 - 049A',
description = ''
WHERE id_product = '18319'
27/09/2022 02:47:32 pm >> UPDATE ps_product SET
wholesale_price = '1,350.00',
on_sale = '0',
price = '0.0000'
WHERE id_product = '18319'
27/09/2022 02:47:32 pm >> UPDATE ps_product_shop SET
wholesale_price = '1,350.00',
price = '0.0000',
id_tax_rules_group = '1',
id_category_default = '480',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '18319'
27/09/2022 02:47:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '18319'
27/09/2022 04:40:33 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2852' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 04:40:33 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'2852' ,
'2022-09-27' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'168.00' ,
'143.66' ,
NOW() ,
NOW() )
27/09/2022 04:40:33 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61960'
27/09/2022 04:40:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '61960'
27/09/2022 04:40:33 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61960' , '19716' , 'MEDAGLIA SAN BENEDETTO - Q1001-OX' , '500' , '-500' , '1' ,
'0.27' , '0.22131147540984' , '22' , '0' , '135.00' )
27/09/2022 04:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19716' AND id_supplier = ''
27/09/2022 04:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19716' , '' , '1' )
27/09/2022 04:40:33 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61960' , '19574' , 'FINO A FARSI FRATELLO DI TUTTI - SALVARANI' , '1' , '-1' , '4' ,
'14' , '14' , '0' , '0' , '14.00' )
27/09/2022 04:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19574' AND id_supplier = ''
27/09/2022 04:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19574' , '' , '1' )
27/09/2022 04:40:33 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61960' , '19342' , 'VOLTI DELLA PREGHIERA - R. CHEAIB' , '1' , '-1' , '4' ,
'20.00' , '20' , '0' , '5' , '19.00' )
27/09/2022 04:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19342' AND id_supplier = ''
27/09/2022 04:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19342' , '' , '1' )
27/09/2022 05:18:37 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2227' AND id_document != '59125' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09')
27/09/2022 05:18:37 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '2227',
document_date = '2022-07-09',
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 = '23.00',
price_tax_excluded = '19.03',
date_upd = NOW()
WHERE id_document = '59125'
27/09/2022 05:18: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 = '59125'
27/09/2022 05:18:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '59125'
27/09/2022 05:18: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
( '59125' , '8195' , 'GIGLER COMPLETO DORATO - 250 ' , '1' , '-1' , '1' ,
'4.0000' , '3.2786885245902' , '22' , '0' , '4.00' )
27/09/2022 05:18:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8195' AND id_supplier = ''
27/09/2022 05:18:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8195' , '' , '1' )
27/09/2022 05:18: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
( '59125' , '564' , 'GIGLER COMPLETO PER ART. 534/536/537 - 249' , '1' , '-1' , '1' ,
'3.2000' , '2.6229508196721' , '22' , '0' , '3.20' )
27/09/2022 05:18:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '564' AND id_supplier = ''
27/09/2022 05:18:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '564' , '' , '1' )
27/09/2022 05:18: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
( '59125' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' ,
'4.9000' , '4.016393442623' , '22' , '0' , '4.90' )
27/09/2022 05:18:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = ''
27/09/2022 05:18:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' )
27/09/2022 05:18: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
( '59125' , '18176' , 'ANTIQUUM MINISTERIUM - PAPA FRANCESCO' , '1' , '-1' , '4' ,
'1.0000' , '1' , '0' , '0' , '1.00' )
27/09/2022 05:18:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18176' AND id_supplier = ''
27/09/2022 05:18:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18176' , '' , '1' )
27/09/2022 05:18: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
( '59125' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' ,
'4.90' , '4.016393442623' , '22' , '0' , '4.90' )
27/09/2022 05:18:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = ''
27/09/2022 05:18:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' )
27/09/2022 05:18: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
( '59125' , '8039' , 'PINZE PER CARBONI - PIN ' , '1' , '-1' , '1' ,
'2.50' , '2.0491803278689' , '22' , '0' , '2.50' )
27/09/2022 05:18:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8039' AND id_supplier = ''
27/09/2022 05:18:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8039' , '' , '1' )
27/09/2022 05:18: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
( '59125' , '18216' , 'BRACCIALE PERLA - BC534' , '1' , '-1' , '1' ,
'1.50' , '1.2295081967213' , '22' , '0' , '1.50' )
27/09/2022 05:18:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18216' AND id_supplier = ''
27/09/2022 05:18:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18216' , '' , '1' )
27/09/2022 05:18: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
( '59125' , '7940' , 'PERGAMENE - OCCASIONI MOD. A' , '2' , '-2' , '1' ,
'0.50' , '0.40983606557377' , '22' , '0' , '1.00' )
27/09/2022 05:18:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7940' AND id_supplier = ''
27/09/2022 05:18:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7940' , '' , '1' )
27/09/2022 05:19:16 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2021' AND id_document != '58874' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23')
27/09/2022 05:19:16 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '2021',
document_date = '2022-06-23',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '46.00',
price_tax_excluded = '37.70',
date_upd = NOW()
WHERE id_document = '58874'
27/09/2022 05:19:16 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 = '58874'
27/09/2022 05:19:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '58874'
27/09/2022 05:19: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
( '58874' , '15893' , 'CINGOLO - CING17' , '1' , '-1' , '1' ,
'46' , '37.704918032787' , '22' , '0' , '46.00' )
27/09/2022 05:19:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15893' AND id_supplier = ''
27/09/2022 05:19:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15893' , '' , '1' )
27/09/2022 05:28:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886423687' AND id_product != '8509' AND ean13 != ''
27/09/2022 05:28:05 pm >> UPDATE ps_product SET
id_supplier = '53',
reference = '4/1',
ean13 = '9788886423687',
date_upd = NOW()
WHERE id_product = '8509'
27/09/2022 05:28:05 pm >> UPDATE ps_product_lang SET
name = 'PRIMI PASSI CON GESÙ - ANNO A',
description = 'Il sussidio offre una catechesi biblico-liturgica, per bambini di 6-7 anni alla scoperta di Gesù attraverso il Vangelo della domenica.
Il disegno da colorare e le frasi da completare, aiutano i bambini a cogliere il messaggio del Vangelo.
'
WHERE id_product = '8509'
27/09/2022 05:28:05 pm >> UPDATE ps_product SET
wholesale_price = '0.58',
on_sale = '0',
price = '3.5'
WHERE id_product = '8509'
27/09/2022 05:28:05 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.58',
price = '3.5',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '12',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '8509'
27/09/2022 05:28:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '8509'
27/09/2022 05:28:05 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' , '8509' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
27/09/2022 05:57: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 (
'33' ,
'347' ,
'2022-09-22' ,
'' ,
'0' ,
'145' ,
'4670978' ,
'VIA TORQUATO TASSO 10 24020 GORLE' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'500.00' ,
'500.00' ,
NOW() ,
NOW() )
27/09/2022 05:57: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 = '61961'
27/09/2022 05:57:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '61961'
27/09/2022 05:57: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
( '61961' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '200' , '200' , '4' ,
'2.50' , '2.5' , '0' , '0' , '500.0000' )
27/09/2022 05:57:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19730' AND id_supplier = '145'
27/09/2022 05:57:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19730' , '145' , '1' )
27/09/2022 05:59:17 pm >> INSERT INTO ps_customer
( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` )
VALUES
( '1' , '' , '' , '' , 'xsFaqqN3OZOxKs3I' , NOW() , NOW() )
27/09/2022 05:59:17 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6981' , '1' )
27/09/2022 05:59:17 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6981' , '2' )
27/09/2022 05:59:17 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6981' , '3' )
27/09/2022 06:01:12 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6981'
27/09/2022 06:01:12 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 (
'6981' ,
'10' ,
'183' ,
'PARROCCHIA S. PIETRO AP.' ,
'MILO' ,
'DON GIUSEPPE' ,
'VIA ROMA 52' ,
'' ,
'80051' ,
'AGEROLA' ,
'' ,
'' ,
'3386115777' ,
'' ,
'' ,
NOW() ,
NOW() )
27/09/2022 06:01:12 pm >> UPDATE ps_customer SET
email = 'josephum.m@hotmail.it',
sdi = '',
pec = '',
date_upd = NOW()
WHERE id_customer = '6981'
27/09/2022 06:02:49 pm >> INSERT INTO ps_customer
( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` )
VALUES
( '1' , '' , '' , '' , 'VReDG9l41Jrv9454' , NOW() , NOW() )
27/09/2022 06:02:49 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3908' , '1' )
27/09/2022 06:02:49 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3908' , '2' )
27/09/2022 06:02:49 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3908' , '3' )
27/09/2022 06:04:26 pm >> SELECT document_num FROM ps_document
WHERE document_num = '2853' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 06:04:26 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'2853' ,
'2022-09-27' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'14.70' ,
'12.05' ,
NOW() ,
NOW() )
27/09/2022 06:04:26 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61962'
27/09/2022 06:04:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '61962'
27/09/2022 06:04:26 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61962' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' ,
'4.90' , '4.016393442623' , '22' , '0' , '14.70' )
27/09/2022 06:04:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = ''
27/09/2022 06:04:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' )
27/09/2022 06:06:10 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3908'
27/09/2022 06:06:10 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 (
'3908' ,
'10' ,
'183' ,
'PARROCCHIA SAN PIETRO AP.' ,
'MILO' ,
'DON GIUSEPPE' ,
'VIA ROMA 52' ,
'' ,
'80051' ,
'AGEROLA' ,
'' ,
'' ,
'3386115777' ,
'' ,
'' ,
NOW() ,
NOW() )
27/09/2022 06:06:10 pm >> UPDATE ps_customer SET
email = 'josephum.m@hotmail.it',
sdi = '',
pec = '',
date_upd = NOW()
WHERE id_customer = '3908'
27/09/2022 06:08:46 pm >> SELECT document_num FROM ps_document
WHERE document_num = '126' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 06:08:46 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' ,
'126' ,
'2022-09-27' ,
'' ,
'3908' ,
'0' ,
'4674904' ,
'VIA ROMA 52 80051 AGEROLA' ,
'' ,
'' ,
'5' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'53.51' ,
'53.51' ,
NOW() ,
NOW() )
27/09/2022 06:08: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 = '61963'
27/09/2022 06:08:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '61963'
27/09/2022 06:08: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
( '61963' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '2' , '-2' , '0' ,
'12.00' , '12' , '' , '5' , '22.80' )
27/09/2022 06:08: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
( '61963' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '5' , '2.38' )
27/09/2022 06:08: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
( '61963' , '12819' , 'REGISTRO DEL CATECHISTA ' , '12' , '-12' , '0' ,
'1.00' , '1' , '' , '5' , '11.40' )
27/09/2022 06:08: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
( '61963' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' ,
'6.00' , '6' , '0' , '5' , '5.70' )
27/09/2022 06:08: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
( '61963' , '1829' , 'CATECHISMO PRIMARIO DEI SACRAMENTI' , '1' , '-1' , '4' ,
'3.50' , '3.5' , '0' , '5' , '3.33' )
27/09/2022 06:08: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
( '61963' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' ,
'2.9' , '2.9' , '0' , '0' , '2.90' )
27/09/2022 06:10:27 pm >> SELECT document_num FROM ps_document
WHERE document_num = '127' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 06:10: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 (
'21' ,
'127' ,
'2022-09-27' ,
'' ,
'284' ,
'0' ,
'4671723' ,
'VIA GUIDO D\\\'AREZZO snc 92027 LICATA' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'7' ,
'0' ,
'395.25' ,
'395.25' ,
NOW() ,
NOW() )
27/09/2022 06:10: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 = '61964'
27/09/2022 06:10:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '61964'
27/09/2022 06:10: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
( '61964' , '18176' , 'ANTIQUUM MINISTERIUM - PAPA FRANCESCO' , '10' , '-10' , '4' ,
'1.00' , '1' , '0' , '15' , '8.50' )
27/09/2022 06:10: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
( '61964' , '12819' , 'REGISTRO DEL CATECHISTA ' , '10' , '-10' , '0' ,
'1.00' , '1' , '' , '15' , '8.50' )
27/09/2022 06:10: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
( '61964' , '5457' , 'IO SONO CON VOI 1 PARTE' , '80' , '-80' , '4' ,
'2.50' , '2.5' , '0' , '15' , '170.00' )
27/09/2022 06:10: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
( '61964' , '11192' , 'VENITE CON ME 2 PARTE' , '80' , '-80' , '4' ,
'2.50' , '2.5' , '0' , '15' , '170.00' )
27/09/2022 06:10: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
( '61964' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '5' , '-5' , '4' ,
'9.00' , '9' , '0' , '15' , '38.25' )
27/09/2022 06:10:53 pm >> SELECT document_num FROM ps_document
WHERE document_num = '126' AND id_document != '61963' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27')
27/09/2022 06:10:54 pm >> UPDATE ps_document SET
id_document_type = '21',
document_num = '126',
document_date = '2022-09-27',
document_letter = '',
id_customer = '3908',
id_supplier = '',
id_address = '4674904',
address1 = 'VIA ROMA 52 80051 AGEROLA',
address2 = '',
note = '',
price_shipping = '5.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '6',
id_causal = '0',
price_tax_included = '53.51',
price_tax_excluded = '53.51',
date_upd = NOW()
WHERE id_document = '61963'
27/09/2022 06:10:54 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61963'
27/09/2022 06:10:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '61963'
27/09/2022 06:10:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61963' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '2' , '-2' , '0' ,
'12.0000' , '12' , '0' , '5' , '22.80' )
27/09/2022 06:10:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16603' AND id_supplier = ''
27/09/2022 06:10:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16603' , '' , '1' )
27/09/2022 06:10:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61963' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '-1' , '4' ,
'2.5000' , '2.5' , '0' , '5' , '2.38' )
27/09/2022 06:10:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2880' AND id_supplier = ''
27/09/2022 06:10:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2880' , '' , '1' )
27/09/2022 06:10:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61963' , '12819' , 'REGISTRO DEL CATECHISTA ' , '12' , '-12' , '0' ,
'1.0000' , '1' , '0' , '5' , '11.40' )
27/09/2022 06:10:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = ''
27/09/2022 06:10:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' )
27/09/2022 06:10:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61963' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' ,
'6.0000' , '6' , '0' , '5' , '5.70' )
27/09/2022 06:10:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12842' AND id_supplier = ''
27/09/2022 06:10:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12842' , '' , '1' )
27/09/2022 06:10:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61963' , '1829' , 'CATECHISMO PRIMARIO DEI SACRAMENTI' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '5' , '3.33' )
27/09/2022 06:10:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1829' AND id_supplier = ''
27/09/2022 06:10:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1829' , '' , '1' )
27/09/2022 06:10:54 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '61963' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '2.90' )
27/09/2022 06:10:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = ''
27/09/2022 06:10:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' )