13/02/2025 05:01:21 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '475' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-13') 
13/02/2025 05:01:21 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' ,
                          '475' ,
                          '2025-02-13' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '40.00' ,
                          '38.46' ,
                          NOW() ,
                          NOW() ) 
13/02/2025 05:01:21 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 = '95724' 
13/02/2025 05:01:21 pm >>  DELETE FROM ps_document_detail WHERE id_document = '95724' 
13/02/2025 05:01:21 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '95724' , '7311' , 'OSTIA SOTTILE 74MM' , '20' ,  '-20' , '3' ,
                               '2.00' , '1.9230769230769' , '4' , '0' , '40.00' ) 
13/02/2025 05:02:26 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '475' AND id_document != '95724' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-13') 
13/02/2025 05:02:26 pm >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '475',
                          document_date = '2025-02-13',
                          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 = '69.50',
                          price_tax_excluded = '69.50',
                          date_upd = NOW()
                        WHERE id_document = '95724' 
13/02/2025 05:02: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 = '95724' 
13/02/2025 05:02:26 pm >>  DELETE FROM ps_document_detail WHERE id_document = '95724' 
13/02/2025 05:02: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
                            ( '95724' , '23231' , 'CLERGY MISTO ML' , '1' ,  '-1' , '4' ,
                               '30.00' , '30' , '0' , '0' , '30.00' ) 
13/02/2025 05:02: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
                            ( '95724' , '21132' , 'CLERGY F/F MC - C03' , '1' ,  '-1' , '4' ,
                               '39.50' , '39.5' , '0' , '0' , '39.50' ) 
13/02/2025 05:04:51 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '36/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-13') 
13/02/2025 05:04: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  (
                          '24' ,
                          '36/A' ,
                          '2025-02-13' ,
                          'A' ,
                          '3550' ,
                          '0' ,
                          '4671016' ,
                          'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' ,
                          '' ,
                          'vittoria' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '20.43' ,
                          '20.43' ,
                          NOW() ,
                          NOW() ) 
13/02/2025 05:04: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 = '95725' 
13/02/2025 05:04:51 pm >>  DELETE FROM ps_document_detail WHERE id_document = '95725' 
13/02/2025 05:04: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
                            ( '95725' , '16065' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' ,  '-1' , '4' ,
                               '2.50' , '2.5' , '0' , '5' , '2.38' ) 
13/02/2025 05:04: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
                            ( '95725' , '17959' , 'SACRAMENTO DELLA RICONCILIAZIONE - VADEMECUM' , '1' ,  '-1' , '4' ,
                               '5.00' , '5' , '0' , '5' , '4.75' ) 
13/02/2025 05:04: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
                            ( '95725' , '9647' , 'SANTO ROSARIO - A. COMASTRI - 8627' , '1' ,  '-1' , '4' ,
                               '7.00' , '7' , '0' , '5' , '6.65' ) 
13/02/2025 05:04: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
                            ( '95725' , '16836' , 'AMORE DELLE ANIME - 8199' , '1' ,  '-1' , '4' ,
                               '7.00' , '7' , '0' , '5' , '6.65' ) 
13/02/2025 05:16:15 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '37/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-13') 
13/02/2025 05:16:15 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '24' ,
                          '37/A' ,
                          '2025-02-13' ,
                          'A' ,
                          '3550' ,
                          '0' ,
                          '4671016' ,
                          'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '231.00' ,
                          '195.65' ,
                          NOW() ,
                          NOW() ) 
13/02/2025 05:16:15 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95726' 
13/02/2025 05:16:15 pm >>  DELETE FROM ps_document_detail WHERE id_document = '95726' 
13/02/2025 05:16:15 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
                            ( '95726' , '6014' , 'LUMINO BIANCO - 10B' , '384' ,  '-384' , '1' ,
                               '0.50' , '0.40983606557377' , '22' , '0' , '192.00' ) 
13/02/2025 05:16:15 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
                            ( '95726' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' ,  '-6' , '3' ,
                               '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 
13/02/2025 05:16:15 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
                            ( '95726' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' ,  '-2' , '3' ,
                               '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 
13/02/2025 05:16:15 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
                            ( '95726' , '21615' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.' , '1' ,  '-1' , '4' ,
                               '20.00' , '20' , '0' , '0' , '20.00' )