22/08/2024 09:43:51 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2462' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-22') 
22/08/2024 09:43: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' ,
                          '2462' ,
                          '2024-08-22' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '1' ,
                          '0' ,
                          '65.70' ,
                          '57.61' ,
                          NOW() ,
                          NOW() ) 
22/08/2024 09:43: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 = '92867' 
22/08/2024 09:43:51 am >>  DELETE FROM ps_document_detail WHERE id_document = '92867' 
22/08/2024 09:43: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
                            ( '92867' , '11272' , 'VETRO ROSSO RUBINO - VKINGS' , '1' ,  '-1' , '1' ,
                               '16.50' , '13.524590163934' , '22' , '0' , '16.50' ) 
22/08/2024 09:43: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
                            ( '92867' , '7553' , 'PARAFIAMMA PIREX PER CARTUCCIA 3.2 - 474/25' , '1' ,  '-1' , '1' ,
                               '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 
22/08/2024 09:43: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
                            ( '92867' , '15003' , 'GIGLER CON STOPPINO PER LUCERNA SS' , '1' ,  '-1' , '1' ,
                               '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 
22/08/2024 09:43: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
                            ( '92867' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' ,  '-1' , '3' ,
                               '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 
22/08/2024 09:43: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
                            ( '92867' , '16689' , 'OSTIA PAN DI CENA mm80' , '8' ,  '-8' , '3' ,
                               '2.00' , '1.9230769230769' , '4' , '0' , '16.00' ) 
22/08/2024 09:43: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
                            ( '92867' , '7311' , 'OSTIA SOTTILE 74MM' , '1' ,  '-1' , '3' ,
                               '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 
22/08/2024 09:43: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
                            ( '92867' , '22501' , 'BRACCIALE COLORATO PRIMA COMUNIONE' , '1' ,  '-1' , '1' ,
                               '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 
22/08/2024 09:43: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
                            ( '92867' , '22499' , 'BRACCIALE PRIMA COMUNIONE' , '1' ,  '-1' , '1' ,
                               '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 
22/08/2024 09:43: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
                            ( '92867' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' ,  '-1' , '1' ,
                               '6.20' , '5.0819672131148' , '22' , '0' , '6.20' ) 
22/08/2024 09:46:57 am >> DELETE FROM ps_document WHERE id_document = '92867' 
22/08/2024 09:46:57 am >> DELETE FROM ps_document_detail WHERE id_document = '92867'