03/03/2023 08:40:42 am >> UPDATE ps_document SET id_document_type = '32', document_num = '40/23', document_date = '2023-02-28', document_letter = '23', id_customer = '0', id_supplier = '', id_address = '4670978', address1 = 'VIA TORQUATO TASSO 10 24020 GORLE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '10', id_causal = '0', price_tax_included = '143.00', price_tax_excluded = '137.50', date_upd = NOW() WHERE id_document = '82108' 03/03/2023 08:40:42 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 = '82108' 03/03/2023 08:40:42 am >> DELETE FROM ps_document_detail WHERE id_document = '82108' 03/03/2023 08:40:42 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 ( '82108' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '250' , '0' , '3' , '0.5500' , '0.52884615384615' , '4' , '0' , '143.00' ) 03/03/2023 10:08:51 am >> SELECT document_num FROM ps_document WHERE document_num = '704' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-03') 03/03/2023 10:08:51 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' , '704' , '2023-03-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.10' , '1.10' , NOW() , NOW() ) 03/03/2023 10:08:51 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 = '82116' 03/03/2023 10:08:51 am >> DELETE FROM ps_document_detail WHERE id_document = '82116' 03/03/2023 10:08:51 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 ( '82116' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.10' , '1.1' , '0' , '0' , '1.10' ) 03/03/2023 11:14:49 am >> SELECT document_num FROM ps_document WHERE document_num = '705' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-03') 03/03/2023 11:14:49 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' , '705' , '2023-03-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '456.00' , '373.77' , NOW() , NOW() ) 03/03/2023 11:14:49 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 = '82117' 03/03/2023 11:14:49 am >> DELETE FROM ps_document_detail WHERE id_document = '82117' 03/03/2023 11:14: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 ( '82117' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' ) 03/03/2023 11:14: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 ( '82117' , '12815' , 'LIBRO DEI CRESIMATI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' ) 03/03/2023 11:14: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 ( '82117' , '12607' , 'NAVETTA DORATA CON CUCCHIAINO ' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 03/03/2023 11:14: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 ( '82117' , '18905' , 'PORTA TURIBOLO CM 147' , '1' , '-1' , '1' , '335.00' , '274.59016393443' , '22' , '0' , '335.00' ) 03/03/2023 11:22:40 am >> SELECT document_num FROM ps_document WHERE document_num = '706' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-03') 03/03/2023 11:22:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '706' , '2023-03-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '50.00' , NOW() , NOW() ) 03/03/2023 11:22:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82118' 03/03/2023 11:22:40 am >> DELETE FROM ps_document_detail WHERE id_document = '82118' 03/03/2023 11:22:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82118' , '20729' , 'PRESAGI DI VITA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 03/03/2023 11:22:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82118' , '20710' , 'VIA CRUCIS DELLA PACE' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 03/03/2023 11:22:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82118' , '18084' , 'MEDITAZIONI SULLA PASSIONE - A. M. DE LIGUORI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 03/03/2023 11:22:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82118' , '20774' , 'MESSAGGIO PER LA QUARESIMA 2023' , '3' , '-3' , '4' , '1.00' , '1' , '0' , '0' , '3.00' ) 03/03/2023 11:22:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82118' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '17.35' , '17.35' , '0' , '0' , '17.35' ) 03/03/2023 11:44:40 am >> SELECT document_num FROM ps_document WHERE document_num = '707' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-03') 03/03/2023 11:44:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '707' , '2023-03-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 03/03/2023 11:44:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82119' 03/03/2023 11:44:40 am >> DELETE FROM ps_document_detail WHERE id_document = '82119' 03/03/2023 11:44:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82119' , '7484' , 'PAPA FRANCESCO - FOTO UFF. 25X35 ' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 03/03/2023 11:58:40 am >> SELECT document_num FROM ps_document WHERE document_num = '708' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-03') 03/03/2023 11:58:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '708' , '2023-03-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '98.90' , '83.11' , NOW() , NOW() ) 03/03/2023 11:58:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82120' 03/03/2023 11:58:40 am >> DELETE FROM ps_document_detail WHERE id_document = '82120' 03/03/2023 11:58:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82120' , '18561' , 'FORMELLA SAGOMATA 26X26 - TENERO ABBRACCIO 1025130' , '1' , '-1' , '1' , '85.00' , '69.672131147541' , '22' , '0' , '85.00' ) 03/03/2023 11:58:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82120' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '12.00' ) 03/03/2023 11:58:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82120' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.9' , '1.9' , '0' , '0' , '1.90' ) 03/03/2023 12:04:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '709' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-03') 03/03/2023 12:04:57 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' , '709' , '2023-03-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 03/03/2023 12:04:57 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 = '82121' 03/03/2023 12:04:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '82121' 03/03/2023 12:04:57 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 ( '82121' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '1' , '-1' , '4' , '0.85' , '0.85' , '0' , '0' , '0.85' ) 03/03/2023 12:04:57 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 ( '82121' , '20769' , 'SULLA STRADA DELLAMORE - V. ROSSI' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 03/03/2023 12:04:57 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 ( '82121' , '16094' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 03/03/2023 12:15:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '40' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-03') 03/03/2023 12:15:25 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' , '40' , '2023-03-03' , '' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '27.07' , '27.07' , NOW() , NOW() ) 03/03/2023 12:15:25 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 = '82122' 03/03/2023 12:15:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '82122' 03/03/2023 12:15:25 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 ( '82122' , '16094' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS' , '10' , '-10' , '4' , '2.00' , '2' , '0' , '5' , '19.00' ) 03/03/2023 12:15:25 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 ( '82122' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '10' , '-10' , '4' , '0.85' , '0.85' , '0' , '5' , '8.07' ) 03/03/2023 12:40:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '709' AND id_document != '82121' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-03') 03/03/2023 12:40:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '709', document_date = '2023-03-03', 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 = '4.75', price_tax_excluded = '4.75', date_upd = NOW() WHERE id_document = '82121' 03/03/2023 12:40:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82121' 03/03/2023 12:40:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '82121' 03/03/2023 12:40:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82121' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '0.85' , '0.85' , '0' , '0' , '0.85' ) 03/03/2023 12:40:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82121' , '20769' , 'SULLA STRADA DELLAMORE - V. ROSSI' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 03/03/2023 12:40:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82121' , '16094' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 03/03/2023 12:41:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '706' AND id_document != '82118' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-03') 03/03/2023 12:41:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '706', document_date = '2023-03-03', 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 = '50.00', price_tax_excluded = '50.00', date_upd = NOW() WHERE id_document = '82118' 03/03/2023 12:41:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82118' 03/03/2023 12:41:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '82118' 03/03/2023 12:41:29 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 ( '82118' , '20729' , 'PRESAGI DI VITA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 03/03/2023 12:41:29 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 ( '82118' , '20710' , 'VIA CRUCIS DELLA PACE' , '2' , '-2' , '4' , '2.0000' , '2' , '0' , '0' , '4.00' ) 03/03/2023 12:41:29 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 ( '82118' , '18084' , 'MEDITAZIONI SULLA PASSIONE - A. M. DE LIGUORI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 03/03/2023 12:41:29 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 ( '82118' , '20774' , 'MESSAGGIO PER LA QUARESIMA 2023' , '3' , '-3' , '4' , '1.0000' , '1' , '0' , '0' , '3.00' ) 03/03/2023 12:41:29 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 ( '82118' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '2' , '-2' , '4' , '0.6' , '0.6' , '0' , '0' , '1.20' ) 03/03/2023 12:41:29 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 ( '82118' , '20674' , 'GESU VOLTO DI DIO - L. MONTI' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 03/03/2023 12:41:39 pm >> DELETE FROM ps_document WHERE id_document = '81183' 03/03/2023 12:41:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '81183' 03/03/2023 02:16:15 pm >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 03/03/2023 02:16:15 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '519' , '1' ) 03/03/2023 02:16:15 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '519' , '2' ) 03/03/2023 02:16:15 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '519' , '3' ) 03/03/2023 02:16:15 pm >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '519' , '1' , 'FLACON SEVICE' , LOWER('FLACON-SEVICE') ) 03/03/2023 02:16:15 pm >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '519' , '1' , '0' ) 03/03/2023 02:16:21 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 03/03/2023 02:16:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20791' , '1' , '' , 'nuovo-prodotto' ) 03/03/2023 02:16:21 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20791' , '1' , '1' , '2' , NOW() , NOW() ) 03/03/2023 02:16:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20791' , '0' , '1' , '0' , '0' ) 03/03/2023 02:17:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002120' AND id_product != '20791' AND ean13 != '' 03/03/2023 02:17:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002120', date_upd = NOW() WHERE id_product = '20791' 03/03/2023 02:17:07 pm >> UPDATE ps_product_lang SET name = 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ', description = '' WHERE id_product = '20791' 03/03/2023 02:17:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.0327868852459' WHERE id_product = '20791' 03/03/2023 02:17:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.0327868852459', id_tax_rules_group = '1', id_category_default = '519', 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 = '20791' 03/03/2023 02:17:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '20791' 03/03/2023 02:17:29 pm >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 03/03/2023 02:17:29 pm >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '175' , '1' ) 03/03/2023 02:17:29 pm >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '175' , '1' ) 03/03/2023 02:17:29 pm >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '175' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 03/03/2023 02:21:35 pm >> UPDATE ps_address SET id_state = '170', lastname = 'FLACON SERVICE SRL', address1 = 'VIA CALENDONE 22/24', address2 = '', postcode = '23887', dni = '09424910157', vat_number = '01813890132', city = 'OLGIATE MOLGORA', phone = '0393310082', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '175' 03/03/2023 02:21:35 pm >> UPDATE ps_supplier SET email = 'posta@flaconservice.it', name = 'FLACON SERVICE SRL', date_upd = NOW() WHERE id_supplier = '175' 03/03/2023 02:21:35 pm >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '175' 03/03/2023 02:22:31 pm >> UPDATE ps_address SET id_state = '170', lastname = 'FLACON SERVICE SRL', address1 = 'VIA CALENDONE 22/24', address2 = '', postcode = '23887', dni = '09424910157', vat_number = '01813890132', city = 'OLGIATE MOLGORA', phone = '0393310082', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '175' 03/03/2023 02:22:31 pm >> UPDATE ps_supplier SET email = 'posta@flaconservice.it', name = 'FLACON SERVICE SRL', date_upd = NOW() WHERE id_supplier = '175' 03/03/2023 02:22:31 pm >> UPDATE ps_supplier_lang SET description = 'contatto: Simone Ferrari 339 2086509', meta_title = '', meta_description = '' WHERE id_supplier = '175' 03/03/2023 02:25:19 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 ( '31' , '57' , '2023-01-26' , '' , '0' , '175' , '4678840' , 'VIA CALENDONE 22/24 23887 OLGIATE MOLGORA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '146.40' , '120.00' , NOW() , NOW() ) 03/03/2023 02:25:19 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 = '82123' 03/03/2023 02:25:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '82123' 03/03/2023 02:25:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82123' , '' , 'TELAIO' , '1' , '1' , '1' , '120' , '98.360655737705' , '22' , '0' , '146.4000' ) 03/03/2023 02:25:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '175' 03/03/2023 02:25:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '175' , '1' ) 03/03/2023 02:35:32 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 ( '31' , '98' , '2023-01-31' , '' , '0' , '175' , '4678840' , 'VIA CALENDONE 22/24 23887 OLGIATE MOLGORA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '5022.24' , '4116.59' , NOW() , NOW() ) 03/03/2023 02:35:32 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 = '82124' 03/03/2023 02:35:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '82124' 03/03/2023 02:35:32 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 ( '82124' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '503' , '503' , '1' , '7.35' , '6.0245901639344' , '22' , '3' , '4375.0890' ) 03/03/2023 02:35:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20791' AND id_supplier = '175' 03/03/2023 02:35:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20791' , '175' , '1' ) 03/03/2023 02:35:32 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 ( '82124' , '10133' , 'SPESE DI TRASPORTO' , '1' , '1' , '1' , '350' , '286.88524590164' , '22' , '0' , '427.0000' ) 03/03/2023 02:35:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '175' 03/03/2023 02:35:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '175' , '1' ) 03/03/2023 02:35:32 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 ( '82124' , '' , 'SPESE CONAI' , '1' , '1' , '1' , '180.45' , '147.90983606557' , '22' , '0' , '220.1490' ) 03/03/2023 02:35:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '175' 03/03/2023 02:35:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '175' , '1' ) 03/03/2023 02:37:36 pm >> DELETE FROM ps_document WHERE id_document = '82123' 03/03/2023 02:37:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '82123' 03/03/2023 02:38:16 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '98', document_date = '2023-01-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4678840', address1 = 'VIA CALENDONE 22/24 23887 OLGIATE MOLGORA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '5168.64', price_tax_excluded = '4236.59', date_upd = NOW() WHERE id_document = '82124' 03/03/2023 02:38: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 = '82124' 03/03/2023 02:38:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '82124' 03/03/2023 02:38:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82124' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '503' , '503' , '1' , '7.3500' , '6.0245901639344' , '22' , '3' , '4375.09' ) 03/03/2023 02:38:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82124' , '10133' , 'SPESE DI TRASPORTO' , '1' , '1' , '1' , '350.0000' , '286.88524590164' , '22' , '0' , '427.00' ) 03/03/2023 02:38:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82124' , '0' , 'SPESE CONAI' , '1' , '1' , '1' , '180.4500' , '147.90983606557' , '22' , '0' , '220.15' ) 03/03/2023 02:38:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82124' , '' , 'TELAIO' , '1' , '1' , '1' , '120' , '98.360655737705' , '22' , '0' , '146.4000' ) 03/03/2023 02:39:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845279935' AND id_product != '13580' AND ean13 != '' 03/03/2023 02:39:37 pm >> UPDATE ps_product SET id_supplier = '47', reference = '', ean13 = '9788845279935', date_upd = NOW() WHERE id_product = '13580' 03/03/2023 02:39:38 pm >> UPDATE ps_product_lang SET name = 'CATTEDRaleE DEI NON CREDENTI - C.M. MARTINI', description = '' WHERE id_product = '13580' 03/03/2023 02:39:38 pm >> UPDATE ps_product SET wholesale_price = '17.50', on_sale = '0', price = '25.0000' WHERE id_product = '13580' 03/03/2023 02:39:38 pm >> UPDATE ps_product_shop SET wholesale_price = '17.50', price = '25.0000', id_tax_rules_group = '4', id_category_default = '330', id_argoment_default = '78', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '13580' 03/03/2023 02:39:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '13580' 03/03/2023 02:39:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845279935' AND id_product != '13580' AND ean13 != '' 03/03/2023 02:39:46 pm >> UPDATE ps_product SET id_supplier = '47', reference = '', ean13 = '9788845279935', date_upd = NOW() WHERE id_product = '13580' 03/03/2023 02:39:46 pm >> UPDATE ps_product_lang SET name = 'CATTEDRale DEI NON CREDENTI - C.M. MARTINI', description = '' WHERE id_product = '13580' 03/03/2023 02:39:46 pm >> UPDATE ps_product SET wholesale_price = '17.50', on_sale = '0', price = '25.0000' WHERE id_product = '13580' 03/03/2023 02:39:46 pm >> UPDATE ps_product_shop SET wholesale_price = '17.50', price = '25.0000', id_tax_rules_group = '4', id_category_default = '330', id_argoment_default = '78', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '13580' 03/03/2023 02:39:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '13580' 03/03/2023 02:40:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845279935' AND id_product != '13580' AND ean13 != '' 03/03/2023 02:40:31 pm >> UPDATE ps_product SET id_supplier = '47', reference = '', ean13 = '9788845279935', date_upd = NOW() WHERE id_product = '13580' 03/03/2023 02:40:31 pm >> UPDATE ps_product_lang SET name = 'CATTEDRE DEI NON CREDENTI - C.M. MARTINI', description = '' WHERE id_product = '13580' 03/03/2023 02:40:31 pm >> UPDATE ps_product SET wholesale_price = '17.50', on_sale = '0', price = '25.0000' WHERE id_product = '13580' 03/03/2023 02:40:31 pm >> UPDATE ps_product_shop SET wholesale_price = '17.50', price = '25.0000', id_tax_rules_group = '4', id_category_default = '330', id_argoment_default = '78', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '13580' 03/03/2023 02:40:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '13580' 03/03/2023 02:55:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '705' AND id_document != '82117' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-03') 03/03/2023 02:55:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '705', document_date = '2023-03-03', 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 = '456.00', price_tax_excluded = '373.77', date_upd = NOW() WHERE id_document = '82117' 03/03/2023 02:55: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 = '82117' 03/03/2023 02:55:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '82117' 03/03/2023 02:55: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 ( '82117' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '5' , '38.00' ) 03/03/2023 02:55: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 ( '82117' , '12815' , 'LIBRO DEI CRESIMATI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '5' , '38.00' ) 03/03/2023 02:55: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 ( '82117' , '18905' , 'PORTA TURIBOLO CM 147' , '1' , '-1' , '1' , '335.0000' , '274.59016393443' , '22' , '0' , '335.00' ) 03/03/2023 02:55: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 ( '82117' , '12617' , 'NAVETTA CON CUCCHIAINO' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 03/03/2023 04:00:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '710' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-03') 03/03/2023 04:00:51 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' , '710' , '2023-03-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '775.00' , '640.78' , NOW() , NOW() ) 03/03/2023 04:00:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82125' 03/03/2023 04:00:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '82125' 03/03/2023 04:00:51 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 ( '82125' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 03/03/2023 04:00:51 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 ( '82125' , '17748' , 'SEGNALIBRO - PR 349' , '175' , '-175' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '52.50' ) 03/03/2023 04:00:51 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 ( '82125' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 03/03/2023 04:00:51 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 ( '82125' , '19706' , 'PALLA 75/1634' , '1' , '-1' , '1' , '73.5' , '60.245901639344' , '22' , '0' , '73.50' ) 03/03/2023 04:00:51 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 ( '82125' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 03/03/2023 04:00:51 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 ( '82125' , '19448' , 'CASULA P/LANA - 8237L' , '1' , '-1' , '1' , '570' , '467.2131147541' , '22' , '0' , '570.00' ) 03/03/2023 05:11:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '711' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-03') 03/03/2023 05:11:05 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' , '711' , '2023-03-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.90' , '58.11' , NOW() , NOW() ) 03/03/2023 05:11:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82126' 03/03/2023 05:11:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '82126' 03/03/2023 05:11:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82126' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '66' , '54.098360655738' , '22' , '0' , '66.00' ) 03/03/2023 05:11:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82126' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 03/03/2023 05:16:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '30/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-03') 03/03/2023 05:16:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '30/A' , '2023-03-03' , 'A' , '1207' , '0' , '4672082' , 'VIA SS. SALVATORE, 2 84080 CALVANICO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '98.36' , NOW() , NOW() ) 03/03/2023 05:16:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82127' 03/03/2023 05:16:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '82127' 03/03/2023 05:16:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82127' , '13078' , 'LEGGIO IN LEGNO - 043' , '1' , '-1' , '1' , '120.00' , '98.360655737705' , '22' , '0' , '120.00' )