16/07/2022 09:33:04 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '37/A' AND id_document != '57793' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-16') 
16/07/2022 09:33:04 am >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '37/A',
                          document_date = '2022-05-16',
                          document_letter = 'A',
                          id_customer = '3712',
                          id_supplier = '',
                          id_address = '4671443',
                          address1 = 'VIA DALMAZIA 6 84121 SALERNO',
                          address2 = '',
                          note = '',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '0',
                          id_causal = '0',
                          price_tax_included = '64.90',
                          price_tax_excluded = '59.28',
                          date_upd = NOW()
                        WHERE id_document = '57793' 
16/07/2022 09:33:04 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 = '57793' 
16/07/2022 09:33:04 am >>  DELETE FROM ps_document_detail WHERE id_document = '57793' 
16/07/2022 09:33:04 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
                            ( '57793' , '7311' , 'OSTIA SOTTILE 74MM' , '6' ,  '-6' , '3' ,
                               '1.9000' , '1.8269230769231' , '4' , '0' , '11.40' ) 
16/07/2022 09:33:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 
16/07/2022 09:33:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 
16/07/2022 09:33:04 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
                            ( '57793' , '7935' , 'PERGAMENE - CRESIMA MOD. B' , '15' ,  '-15' , '1' ,
                               '0.3000' , '0.24590163934426' , '22' , '0' , '4.50' ) 
16/07/2022 09:33:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '7935' AND id_supplier = '' 
16/07/2022 09:33:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7935' , '' , '1' ) 
16/07/2022 09:33:05 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
                            ( '57793' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' ,  '-1' , '1' ,
                               '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 
16/07/2022 09:33:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 
16/07/2022 09:33:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 
16/07/2022 09:33:05 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
                            ( '57793' , '7673' , 'PARTICOLE MM38' , '9' ,  '-9' , '3' ,
                               '3.50' , '3.3653846153846' , '4' , '0' , '31.50' ) 
16/07/2022 09:33:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 
16/07/2022 09:33:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 
16/07/2022 09:33:05 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
                            ( '57793' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' ,  '-1' , '1' ,
                               '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 
16/07/2022 09:33:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 
16/07/2022 09:33:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 
16/07/2022 09:36:39 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2284' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-16') 
16/07/2022 09:36:39 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' ,
                          '2284' ,
                          '2022-07-16' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '58.00' ,
                          '47.54' ,
                          NOW() ,
                          NOW() ) 
16/07/2022 09:36:39 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 = '59706' 
16/07/2022 09:36:39 am >>  DELETE FROM ps_document_detail WHERE id_document = '59706' 
16/07/2022 09:36:39 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
                            ( '59706' , '14608' , 'ROMANO BIANCO - COTONE - 41' , '1' ,  '-1' , '1' ,
                               '58' , '47.540983606557' , '22' , '0' , '58.00' ) 
16/07/2022 09:36:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '14608' AND id_supplier = '' 
16/07/2022 09:36:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14608' , '' , '1' ) 
16/07/2022 09:40:02 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2285' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-16') 
16/07/2022 09:40:02 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' ,
                          '2285' ,
                          '2022-07-16' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '9.20' ,
                          '7.54' ,
                          NOW() ,
                          NOW() ) 
16/07/2022 09:40:02 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 = '59707' 
16/07/2022 09:40:02 am >>  DELETE FROM ps_document_detail WHERE id_document = '59707' 
16/07/2022 09:40:02 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
                            ( '59707' , '17994' , 'LOURDES CM 13 - 023LDS/13E' , '1' ,  '-1' , '1' ,
                               '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 
16/07/2022 09:40:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '17994' AND id_supplier = '' 
16/07/2022 09:40:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17994' , '' , '1' ) 
16/07/2022 09:40:02 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
                            ( '59707' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '1' ,  '-1' , '1' ,
                               '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 
16/07/2022 09:40:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19468' AND id_supplier = '' 
16/07/2022 09:40:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19468' , '' , '1' ) 
16/07/2022 09:50:53 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2286' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-16') 
16/07/2022 09:50:53 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' ,
                          '2286' ,
                          '2022-07-16' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '96.65' ,
                          '96.65' ,
                          NOW() ,
                          NOW() ) 
16/07/2022 09:50:53 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 = '59708' 
16/07/2022 09:50:53 am >>  DELETE FROM ps_document_detail WHERE id_document = '59708' 
16/07/2022 09:50:53 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
                            ( '59708' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' ,  '-35' , '4' ,
                               '0.56' , '0.56' , '0' , '0' , '19.60' ) 
16/07/2022 09:50:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 
16/07/2022 09:50:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 
16/07/2022 09:50:53 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
                            ( '59708' , '19516' , 'AMEN - AGO 2022' , '5' ,  '-5' , '4' ,
                               '3.90' , '3.9' , '0' , '5' , '18.55' ) 
16/07/2022 09:50:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19516' AND id_supplier = '' 
16/07/2022 09:50:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19516' , '' , '1' ) 
16/07/2022 09:50:53 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
                            ( '59708' , '19515' , 'AMEN - LUG 2022' , '5' ,  '-5' , '4' ,
                               '3.90' , '3.9' , '0' , '5' , '18.55' ) 
16/07/2022 09:50:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19515' AND id_supplier = '' 
16/07/2022 09:50:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19515' , '' , '1' ) 
16/07/2022 09:50:53 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
                            ( '59708' , '19684' , 'AMEN - SETT. 2022' , '5' ,  '-5' , '4' ,
                               '3.90' , '3.9' , '0' , '5' , '18.55' ) 
16/07/2022 09:50:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19684' AND id_supplier = '' 
16/07/2022 09:50:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19684' , '' , '1' ) 
16/07/2022 09:50:54 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
                            ( '59708' , '19685' , 'AMEN - OTT 2022' , '5' ,  '-5' , '4' ,
                               '3.90' , '3.9' , '0' , '5' , '18.55' ) 
16/07/2022 09:50:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '19685' AND id_supplier = '' 
16/07/2022 09:50:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19685' , '' , '1' ) 
16/07/2022 09:50:54 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
                            ( '59708' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '1' ,  '-1' , '4' ,
                               '3.00' , '3' , '0' , '5' , '2.85' ) 
16/07/2022 09:50:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '19731' AND id_supplier = '' 
16/07/2022 09:50:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19731' , '' , '1' ) 
16/07/2022 09:51:25 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2287' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-16') 
16/07/2022 09:51:25 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' ,
                          '2287' ,
                          '2022-07-16' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '38.00' ,
                          '38.00' ,
                          NOW() ,
                          NOW() ) 
16/07/2022 09:51:25 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 = '59709' 
16/07/2022 09:51:25 am >>  DELETE FROM ps_document_detail WHERE id_document = '59709' 
16/07/2022 09:51:25 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
                            ( '59709' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '4' ,  '-4' , '4' ,
                               '5.00' , '5' , '0' , '5' , '19.00' ) 
16/07/2022 09:51:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 
16/07/2022 09:51:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 
16/07/2022 09:51:25 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
                            ( '59709' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '4' ,  '-4' , '4' ,
                               '5.00' , '5' , '0' , '5' , '19.00' ) 
16/07/2022 09:51:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 
16/07/2022 09:51:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 
16/07/2022 09:54:56 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2288' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-16') 
16/07/2022 09:54:56 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' ,
                          '2288' ,
                          '2022-07-16' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '20.81' ,
                          '20.81' ,
                          NOW() ,
                          NOW() ) 
16/07/2022 09:54:56 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 = '59710' 
16/07/2022 09:54:56 am >>  DELETE FROM ps_document_detail WHERE id_document = '59710' 
16/07/2022 09:54:56 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
                            ( '59710' , '1143' , 'BIBBIA DI GERUSALEMME - TASCABILE' , '1' ,  '-1' , '4' ,
                               '21.90' , '21.9' , '0' , '5' , '20.81' ) 
16/07/2022 09:54:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '1143' AND id_supplier = '' 
16/07/2022 09:54:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1143' , '' , '1' ) 
16/07/2022 10:14:18 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2039' AND id_document != '58896' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 
16/07/2022 10:14:18 am >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '2039',
                          document_date = '2022-06-24',
                          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 = '8.90',
                          price_tax_excluded = '8.56',
                          date_upd = NOW()
                        WHERE id_document = '58896' 
16/07/2022 10:14:18 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 = '58896' 
16/07/2022 10:14:18 am >>  DELETE FROM ps_document_detail WHERE id_document = '58896' 
16/07/2022 10:14:18 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
                            ( '58896' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' ,  '-2' , '3' ,
                               '3.5' , '3.3653846153846' , '4' , '0' , '7.00' ) 
16/07/2022 10:14:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 
16/07/2022 10:14:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 
16/07/2022 10:14:18 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
                            ( '58896' , '7311' , 'OSTIA SOTTILE 74MM' , '1' ,  '-1' , '3' ,
                               '1.9000' , '1.8269230769231' , '4' , '0' , '1.90' ) 
16/07/2022 10:14:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 
16/07/2022 10:14:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 
16/07/2022 11:07:12 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2289' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-16') 
16/07/2022 11:07:13 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' ,
                          '2289' ,
                          '2022-07-16' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '18.00' ,
                          '18.00' ,
                          NOW() ,
                          NOW() ) 
16/07/2022 11:07:13 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 = '59711' 
16/07/2022 11:07:13 am >>  DELETE FROM ps_document_detail WHERE id_document = '59711' 
16/07/2022 11:07:13 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
                            ( '59711' , '11151' , 'LIBRI' , '1' ,  '-1' , '4' ,
                               '18' , '18' , '0' , '0' , '18.00' ) 
16/07/2022 11:07:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 
16/07/2022 11:07:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 
16/07/2022 12:27:49 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '2290' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-16') 
16/07/2022 12:27:49 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' ,
                          '2290' ,
                          '2022-07-16' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '7.42' ,
                          '7.42' ,
                          NOW() ,
                          NOW() ) 
16/07/2022 12:27:49 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 = '59712' 
16/07/2022 12:27:49 pm >>  DELETE FROM ps_document_detail WHERE id_document = '59712' 
16/07/2022 12:27:49 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
                            ( '59712' , '19684' , 'AMEN - SETT. 2022' , '2' ,  '-2' , '4' ,
                               '3.90' , '3.9' , '0' , '5' , '7.42' ) 
16/07/2022 12:27:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19684' AND id_supplier = '' 
16/07/2022 12:27:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19684' , '' , '1' ) 
16/07/2022 12:44:33 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '2291' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-16') 
16/07/2022 12:44:33 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' ,
                          '2291' ,
                          '2022-07-16' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '12.60' ,
                          '10.33' ,
                          NOW() ,
                          NOW() ) 
16/07/2022 12:44:33 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 = '59713' 
16/07/2022 12:44:33 pm >>  DELETE FROM ps_document_detail WHERE id_document = '59713' 
16/07/2022 12:44:33 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
                            ( '59713' , '17610' , 'CATENINA IN ACCIAIO CM 55' , '3' ,  '-3' , '1' ,
                               '4.20' , '3.4426229508197' , '22' , '0' , '12.60' ) 
16/07/2022 12:44:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17610' AND id_supplier = '' 
16/07/2022 12:44:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17610' , '' , '1' ) 
16/07/2022 12:45:39 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '2291' AND id_document != '59713' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-16') 
16/07/2022 12:45:40 pm >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '2291',
                          document_date = '2022-07-16',
                          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 = '12.60',
                          price_tax_excluded = '10.33',
                          date_upd = NOW()
                        WHERE id_document = '59713' 
16/07/2022 12:45:40 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 = '59713' 
16/07/2022 12:45:40 pm >>  DELETE FROM ps_document_detail WHERE id_document = '59713' 
16/07/2022 12:45:40 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
                            ( '59713' , '17610' , 'CATENINA IN ACCIAIO CM 55' , '4' ,  '-4' , '1' ,
                               '3.15' , '2.5819672131148' , '22' , '0' , '12.60' ) 
16/07/2022 12:45:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17610' AND id_supplier = '' 
16/07/2022 12:45:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17610' , '' , '1' )