18/11/2023 08:13:47 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7077' 18/11/2023 08:13:47 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 ( '7077' , '10' , '146' , 'PARROCCHIA MARIA SS DELLA CATENA' , 'SCIUTO' , 'CARMELO' , 'VIA CAMPOFIORITO 12' , '' , '95022' , 'ACI CATENA' , 'IN CASO DI NON RISPOSTA AL CITOFONO DELLA PARROCCHIA, IL PACCO PUO ESSERE CONSEGNATO AL COMANDO DEI VIGILI URBANI, PIAZZA MATRICE 5' , '' , '095801511' , '' , '90002410877' , NOW() , NOW() ) 18/11/2023 08:13:47 am >> UPDATE ps_customer SET email = 'santuariomatriceacicatena@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7077' 18/11/2023 08:14:20 am >> SELECT document_num FROM ps_document WHERE document_num = '106' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-18') 18/11/2023 08:14:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '106' , '2023-11-18' , '' , '7077' , '0' , '163357303' , 'VIA CAMPOFIORITO 12 95022 ACI CATENA' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '125.65' , '125.65' , NOW() , NOW() ) 18/11/2023 08:14:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '13752' 18/11/2023 08:14:20 am >> DELETE FROM ps_document_detail WHERE id_document = '13752' 18/11/2023 08:14:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13752' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '50' , '-50' , '4' , '2.50' , '2.5' , '0' , '5' , '118.75' ) 18/11/2023 08:14:28 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7077' 18/11/2023 08:14:28 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 ( '7077' , '10' , '146' , 'PARROCCHIA MARIA SS DELLA CATENA' , 'SCIUTO' , 'CARMELO' , 'VIA CAMPOFIORITO 12' , '' , '95022' , 'ACI CATENA' , 'IN CASO DI NON RISPOSTA AL CITOFONO DELLA PARROCCHIA, IL PACCO PUO ESSERE CONSEGNATO AL COMANDO DEI VIGILI URBANI, PIAZZA MATRICE 5' , '' , '095801511' , '' , '90002410877' , NOW() , NOW() ) 18/11/2023 08:14:28 am >> UPDATE ps_customer SET email = 'santuariomatriceacicatena@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7077' 18/11/2023 09:28:04 am >> SELECT document_num FROM ps_document WHERE document_num = '3656' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-18') 18/11/2023 09:28:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3656' , '2023-11-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.00' , '41.80' , NOW() , NOW() ) 18/11/2023 09:28:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89026' 18/11/2023 09:28:04 am >> DELETE FROM ps_document_detail WHERE id_document = '89026' 18/11/2023 09:28:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89026' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 18/11/2023 09:49:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3657' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-18') 18/11/2023 09:49: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 ( '11' , '3657' , '2023-11-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 18/11/2023 09:49: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 = '89027' 18/11/2023 09:49:26 am >> DELETE FROM ps_document_detail WHERE id_document = '89027' 18/11/2023 09:49: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 ( '89027' , '21524' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 18/11/2023 11:17:47 am >> SELECT document_num FROM ps_document WHERE document_num = '130/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-18') 18/11/2023 11:17:47 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' , '130/A' , '2023-11-18' , 'A' , '3812' , '0' , '4678843' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.30' , '31.42' , NOW() , NOW() ) 18/11/2023 11:17:47 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 = '89028' 18/11/2023 11:17:47 am >> DELETE FROM ps_document_detail WHERE id_document = '89028' 18/11/2023 11:17:47 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 ( '89028' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 18/11/2023 11:17:47 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 ( '89028' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 18/11/2023 11:28:56 am >> SELECT document_num FROM ps_document WHERE document_num = '3658' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-18') 18/11/2023 11:28:56 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' , '3658' , '2023-11-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '26.00' , NOW() , NOW() ) 18/11/2023 11:28:56 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 = '89029' 18/11/2023 11:28:56 am >> DELETE FROM ps_document_detail WHERE id_document = '89029' 18/11/2023 11:28:56 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 ( '89029' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '26' , '26' , '0' , '0' , '26.00' )