15/06/2024 09:15:43 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1996' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-15') 
15/06/2024 09:15: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' ,
                          '1996' ,
                          '2024-06-15' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '9.50' ,
                          '9.50' ,
                          NOW() ,
                          NOW() ) 
15/06/2024 09:15: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 = '92301' 
15/06/2024 09:15:43 am >>  DELETE FROM ps_document_detail WHERE id_document = '92301' 
15/06/2024 09:15: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
                            ( '92301' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' ,  '-1' , '4' ,
                               '5.00' , '5' , '0' , '5' , '4.75' ) 
15/06/2024 09:15: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
                            ( '92301' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' ,  '-1' , '4' ,
                               '5.00' , '5' , '0' , '5' , '4.75' ) 
15/06/2024 09:37:36 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1997' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-15') 
15/06/2024 09:37:36 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' ,
                          '1997' ,
                          '2024-06-15' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '89.00' ,
                          '72.95' ,
                          NOW() ,
                          NOW() ) 
15/06/2024 09:37:36 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 = '92302' 
15/06/2024 09:37:36 am >>  DELETE FROM ps_document_detail WHERE id_document = '92302' 
15/06/2024 09:37:36 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
                            ( '92302' , '18561' , 'FORMELLA SAGOMATA 26X26 ' , '1' ,  '-1' , '1' ,
                               '89.00' , '72.950819672131' , '22' , '0' , '89.00' ) 
15/06/2024 10:08:57 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1998' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-15') 
15/06/2024 10:08:57 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' ,
                          '1998' ,
                          '2024-06-15' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '2.50' ,
                          '2.05' ,
                          NOW() ,
                          NOW() ) 
15/06/2024 10:08:57 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 = '92303' 
15/06/2024 10:08:57 am >>  DELETE FROM ps_document_detail WHERE id_document = '92303' 
15/06/2024 10:08:57 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
                            ( '92303' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 
15/06/2024 10:27:21 am >> DELETE FROM ps_document WHERE id_document = '92227' 
15/06/2024 10:27:21 am >> DELETE FROM ps_document_detail WHERE id_document = '92227' 
15/06/2024 10:27:51 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1999' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-15') 
15/06/2024 10:27: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' ,
                          '1999' ,
                          '2024-06-15' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '26.55' ,
                          '26.55' ,
                          NOW() ,
                          NOW() ) 
15/06/2024 10:27: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 = '92304' 
15/06/2024 10:27:51 am >>  DELETE FROM ps_document_detail WHERE id_document = '92304' 
15/06/2024 10:27: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
                            ( '92304' , '475' , 'AMICO GESÙ - FIGURINE' , '59' ,  '-59' , '4' ,
                               '0.50' , '0.5' , '0' , '10' , '26.55' ) 
15/06/2024 10:36:52 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2000' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-15') 
15/06/2024 10:36:52 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' ,
                          '2000' ,
                          '2024-06-15' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '4.00' ,
                          '4.00' ,
                          NOW() ,
                          NOW() ) 
15/06/2024 10:36:52 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 = '92305' 
15/06/2024 10:36:52 am >>  DELETE FROM ps_document_detail WHERE id_document = '92305' 
15/06/2024 10:36:52 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
                            ( '92305' , '15602' , 'AMICO GESU ALBUM' , '2' ,  '-2' , '4' ,
                               '2.00' , '2' , '0' , '0' , '4.00' ) 
15/06/2024 11:15:32 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2001' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-15') 
15/06/2024 11:15:32 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' ,
                          '2001' ,
                          '2024-06-15' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '1.00' ,
                          '0.82' ,
                          NOW() ,
                          NOW() ) 
15/06/2024 11:15:32 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 = '92306' 
15/06/2024 11:15:32 am >>  DELETE FROM ps_document_detail WHERE id_document = '92306' 
15/06/2024 11:15:32 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
                            ( '92306' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' ,  '-1' , '1' ,
                               '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 
15/06/2024 11:16:15 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2002' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-15') 
15/06/2024 11:16:15 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' ,
                          '2002' ,
                          '2024-06-15' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          'VIA ROMA 84121 SALERNO' ,
                          '' ,
                          '' ,
                          '0.00' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '32.60' ,
                          '31.35' ,
                          NOW() ,
                          NOW() ) 
15/06/2024 11:16:15 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 = '92307' 
15/06/2024 11:16:15 am >>  DELETE FROM ps_document_detail WHERE id_document = '92307' 
15/06/2024 11:16:15 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
                            ( '92307' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' ,  '-4' , '3' ,
                               '3.5000' , '3.3654' , '4' , '0' , '14.00' ) 
15/06/2024 11:16:15 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
                            ( '92307' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' ,  '-5' , '3' ,
                               '2.0000' , '1.9231' , '4' , '0' , '10.00' ) 
15/06/2024 11:16:15 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
                            ( '92307' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' ,  '-2' , '3' ,
                               '4.3000' , '4.1346' , '4' , '0' , '8.60' ) 
15/06/2024 11:45:03 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2003' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-15') 
15/06/2024 11:45:03 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' ,
                          '2003' ,
                          '2024-06-15' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '6.80' ,
                          '6.30' ,
                          NOW() ,
                          NOW() ) 
15/06/2024 11:45:03 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 = '92308' 
15/06/2024 11:45:03 am >>  DELETE FROM ps_document_detail WHERE id_document = '92308' 
15/06/2024 11:45:03 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
                            ( '92308' , '13830' , 'VANGELO E ATTI - ECOPELLE BIANCA - 8592' , '1' ,  '-1' , '4' ,
                               '4.00' , '4' , '0' , '0' , '4.00' ) 
15/06/2024 11:45:03 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
                            ( '92308' , '19599' , 'ROSARIO PER LA PRIMA COMUNIONE - 197/13' , '1' ,  '-1' , '1' ,
                               '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 
15/06/2024 11:47:45 am >> DELETE FROM ps_document WHERE id_document = '92123' 
15/06/2024 11:47:45 am >> DELETE FROM ps_document_detail WHERE id_document = '92123'