17/02/2024 08:38:58 am >> SELECT document_num FROM ps_document WHERE document_num = '7/A' AND id_document != '89900' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-10') 17/02/2024 08:38:58 am >> UPDATE ps_document SET id_document_type = '24', document_num = '7/A', document_date = '2024-01-10', document_letter = 'A', id_customer = '3812', id_supplier = '', id_address = '4678843', address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ', 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 = '266.80', price_tax_excluded = '220.39', date_upd = NOW() WHERE id_document = '89900' 17/02/2024 08:38:58 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 = '89900' 17/02/2024 08:38:58 am >> DELETE FROM ps_document_detail WHERE id_document = '89900' 17/02/2024 08:38:58 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 ( '89900' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 17/02/2024 08:38:58 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 ( '89900' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 17/02/2024 08:38:58 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 ( '89900' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 17/02/2024 08:38:59 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 ( '89900' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 17/02/2024 08:38:59 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 ( '89900' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 17/02/2024 08:38:59 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 ( '89900' , '17161' , 'CARBONCINI NERI - CARNE' , '4' , '-4' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '48.00' ) 17/02/2024 08:38:59 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 ( '89900' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 17/02/2024 08:38:59 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 ( '89900' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 17/02/2024 08:39:27 am >> DELETE FROM ps_document WHERE id_document = '90165' 17/02/2024 08:39:27 am >> DELETE FROM ps_document_detail WHERE id_document = '90165' 17/02/2024 10:16:28 am >> SELECT document_num FROM ps_document WHERE document_num = '478' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-17') 17/02/2024 10:16:29 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' , '478' , '2024-02-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '53.51' , NOW() , NOW() ) 17/02/2024 10:16:29 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 = '90391' 17/02/2024 10:16:29 am >> DELETE FROM ps_document_detail WHERE id_document = '90391' 17/02/2024 10:16:29 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 ( '90391' , '14664' , 'DALL\'AURORA IO TI CERCO - A. CENCINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 17/02/2024 10:16:29 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 ( '90391' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 17/02/2024 10:16:29 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 ( '90391' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 17/02/2024 10:16:29 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 ( '90391' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '32' , '26.229508196721' , '22' , '0' , '32.00' ) 17/02/2024 10:16:29 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 ( '90391' , '18223' , 'CORONA MISSIONARIA - R102' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '3.00' ) 17/02/2024 10:16:29 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 ( '90391' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.24' , '4.24' , '0' , '0' , '4.24' ) 17/02/2024 10:20:35 am >> SELECT document_num FROM ps_document WHERE document_num = '479' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-17') 17/02/2024 10:20:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '479' , '2024-02-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 17/02/2024 10:20:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90392' 17/02/2024 10:20:35 am >> DELETE FROM ps_document_detail WHERE id_document = '90392' 17/02/2024 10:20:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90392' , '18138' , 'PORTACHIAVI DECINA CROCE - S46' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 17/02/2024 11:23:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821574528' AND id_product != '4134' AND ean13 != '' 17/02/2024 11:23:19 am >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9788821574528', date_upd = NOW() WHERE id_product = '4134' 17/02/2024 11:23:19 am >> UPDATE ps_product_lang SET name = 'FELICI DI CREDERE - ANNO DELLA FEDE', description = '' WHERE id_product = '4134' 17/02/2024 11:23:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.5000' WHERE id_product = '4134' 17/02/2024 11:23:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.5000', 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 = '4134' 17/02/2024 11:23:19 am >> DELETE FROM ps_specific_price WHERE id_product = '4134' 17/02/2024 11:35:43 am >> SELECT document_num FROM ps_document WHERE document_num = '480' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-17') 17/02/2024 11:35:43 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' , '480' , '2024-02-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.60' , '40.34' , NOW() , NOW() ) 17/02/2024 11:35:43 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 = '90393' 17/02/2024 11:35:43 am >> DELETE FROM ps_document_detail WHERE id_document = '90393' 17/02/2024 11:35:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90393' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 17/02/2024 11:35:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90393' , '19109' , 'LUCERNA IN VETRO TRASPARENTE - 1492' , '2' , '-2' , '1' , '15.80' , '12.950819672131' , '22' , '0' , '31.60' ) 17/02/2024 11:35:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90393' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 17/02/2024 11:35:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90393' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' ) 17/02/2024 11:36:30 am >> SELECT document_num FROM ps_document WHERE document_num = '481' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-17') 17/02/2024 11:36:30 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' , '481' , '2024-02-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 17/02/2024 11:36:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90394' 17/02/2024 11:36:30 am >> DELETE FROM ps_document_detail WHERE id_document = '90394' 17/02/2024 11:36:30 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 ( '90394' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 17/02/2024 11:37:28 am >> SELECT document_num FROM ps_document WHERE document_num = '482' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-17') 17/02/2024 11:37: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' , '482' , '2024-02-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 17/02/2024 11:37: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 = '90395' 17/02/2024 11:37:28 am >> DELETE FROM ps_document_detail WHERE id_document = '90395' 17/02/2024 11:37: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 ( '90395' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 17/02/2024 11:42:11 am >> SELECT document_num FROM ps_document WHERE document_num = '483' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-17') 17/02/2024 11:42:11 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' , '483' , '2024-02-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.29' , '4.29' , NOW() , NOW() ) 17/02/2024 11:42:11 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 = '90396' 17/02/2024 11:42:11 am >> DELETE FROM ps_document_detail WHERE id_document = '90396' 17/02/2024 11:42:11 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 ( '90396' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '3' , '-3' , '4' , '1.50' , '1.5' , '0' , '5' , '4.29' ) 17/02/2024 11:44:38 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1178' 17/02/2024 11:44: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 ( '1178' , '10' , '210' , 'PARROCCHIA S. PIETRO AP.' , 'BACCO ' , 'DON GENEROSO' , 'P. ZZA LINGUITI, 1' , '' , '84090' , 'GIFFONI VALLE PIANA' , '' , '' , '' , '' , '95017780651' , NOW() , NOW() ) 17/02/2024 11:44:38 am >> UPDATE ps_customer SET email = 'baccogene@tiscali.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1178' 17/02/2024 11:46:06 am >> SELECT document_num FROM ps_document WHERE document_num = '13' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-02-17') 17/02/2024 11:46:06 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' , '13' , '2024-02-17' , '' , '1178' , '0' , '172691788' , 'P. ZZA LINGUITI, 1 84090 GIFFONI VALLE PIANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '550.00' , '550.00' , NOW() , NOW() ) 17/02/2024 11:46:06 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 = '14194' 17/02/2024 11:46:06 am >> DELETE FROM ps_document_detail WHERE id_document = '14194' 17/02/2024 11:46:06 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 ( '14194' , '101' , 'GESU\' BENEDICI LA NOSTRA FAMIGLIA' , '500' , '-500' , '4' , '1.1' , '1.1' , '0' , '0' , '550.00' ) 17/02/2024 11:48:45 am >> SELECT document_num FROM ps_document WHERE document_num = '484' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-17') 17/02/2024 11:48:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '484' , '2024-02-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.00' , '41.80' , NOW() , NOW() ) 17/02/2024 11:48:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90397' 17/02/2024 11:48:45 am >> DELETE FROM ps_document_detail WHERE id_document = '90397' 17/02/2024 11:48:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90397' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 17/02/2024 11:48:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90397' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 17/02/2024 11:49:35 am >> SELECT document_num FROM ps_document WHERE document_num = '485' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-17') 17/02/2024 11:49:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '485' , '2024-02-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.89' , '7.89' , NOW() , NOW() ) 17/02/2024 11:49:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90398' 17/02/2024 11:49:35 am >> DELETE FROM ps_document_detail WHERE id_document = '90398' 17/02/2024 11:49:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90398' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 17/02/2024 11:49:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90398' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 17/02/2024 11:59:48 am >> SELECT document_num FROM ps_document WHERE document_num = '486' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-17') 17/02/2024 11:59:48 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' , '486' , '2024-02-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.52' , '32.52' , NOW() , NOW() ) 17/02/2024 11:59:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90399' 17/02/2024 11:59:48 am >> DELETE FROM ps_document_detail WHERE id_document = '90399' 17/02/2024 11:59:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90399' , '21684' , 'CEST LA CONFIANCE ' , '6' , '-6' , '4' , '1.90' , '1.9' , '0' , '5' , '10.86' ) 17/02/2024 11:59:49 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 ( '90399' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 17/02/2024 11:59:49 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 ( '90399' , '21668' , 'ALFABETO DI DIO - G. RAVASI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 17/02/2024 12:18:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '487' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-17') 17/02/2024 12:18:04 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' , '487' , '2024-02-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.60' , '8.60' , NOW() , NOW() ) 17/02/2024 12:18:04 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 = '90400' 17/02/2024 12:18:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '90400' 17/02/2024 12:18:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90400' , '21920' , 'AMEN - MAR 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 17/02/2024 12:18:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90400' , '21919' , 'AMEN - APR 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 17/02/2024 12:18:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90400' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' ) 17/02/2024 12:20:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '488' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-17') 17/02/2024 12:20:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '488' , '2024-02-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.00' , '41.80' , NOW() , NOW() ) 17/02/2024 12:20:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90401' 17/02/2024 12:20:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '90401' 17/02/2024 12:20:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90401' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '51' , '41.803278688525' , '22' , '0' , '51.00' ) 17/02/2024 12:21:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '13' AND id_document != '14194' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-02-17') 17/02/2024 12:21:18 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '13', document_date = '2024-02-17', document_letter = '', id_customer = '1178', id_supplier = '', id_address = '172691788', address1 = 'P. ZZA LINGUITI, 1 84090 GIFFONI VALLE PIANA', 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 = '550.00', price_tax_excluded = '550.00', date_upd = NOW() WHERE id_document = '14194' 17/02/2024 12:21:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14194' 17/02/2024 12:21:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '14194' 17/02/2024 12:21:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14194' , '101' , 'GESU\' BENEDICI LA NOSTRA FAMIGLIA' , '500' , '-500' , '4' , '1.1000' , '1.1' , '0' , '0' , '550.00' )