13/08/2024 08:51:44 am >> SELECT document_num FROM ps_document WHERE document_num = '88/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-08-13') 13/08/2024 08:51:44 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 ( '24' , '88/A' , '2024-08-13' , 'A' , '229' , '0' , '4673704' , 'VIA TORINO 84092 BELLIZZI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '295.70' , '250.59' , NOW() , NOW() ) 13/08/2024 08:51:44 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 = '92866' 13/08/2024 08:51:44 am >> DELETE FROM ps_document_detail WHERE id_document = '92866' 13/08/2024 08:51:44 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 ( '92866' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '12.90' ) 13/08/2024 08:51:44 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 ( '92866' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 13/08/2024 08:51:44 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 ( '92866' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 13/08/2024 08:51:44 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 ( '92866' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '112.80' ) 13/08/2024 08:51:44 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 ( '92866' , '22199' , 'VINO LIQUOROSO ROSSO ' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 13/08/2024 08:51:44 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 ( '92866' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 13/08/2024 08:51:44 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 ( '92866' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '30.00' ) 13/08/2024 08:52:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1672' AND id_document != '91905' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-18') 13/08/2024 08:52:31 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1672', document_date = '2024-05-18', 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 = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '91905' 13/08/2024 08:52:31 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 = '91905' 13/08/2024 08:52:31 am >> DELETE FROM ps_document_detail WHERE id_document = '91905' 13/08/2024 08:52:31 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 ( '91905' , '14079' , 'ALBERO DELLA VITA ROSSO 42X22' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 13/08/2024 08:53:55 am >> SELECT document_num FROM ps_document WHERE document_num = '2361' AND id_document != '92741' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 13/08/2024 08:53:55 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2361', document_date = '2024-07-26', 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 = '23.75', price_tax_excluded = '23.75', date_upd = NOW() WHERE id_document = '92741' 13/08/2024 08:53:55 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 = '92741' 13/08/2024 08:53:55 am >> DELETE FROM ps_document_detail WHERE id_document = '92741' 13/08/2024 08:53:55 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 ( '92741' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.85' , '5.85' , '0' , '0' , '5.85' ) 13/08/2024 08:53:55 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 ( '92741' , '10430' , 'TABOR' , '1' , '-1' , '4' , '17.90' , '17.9' , '0' , '0' , '17.90' ) 13/08/2024 08:54:32 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'TgJu75u8Vw7H0RCX' , NOW() , NOW() ) 13/08/2024 08:54:32 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4112' , '1' ) 13/08/2024 08:54:32 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4112' , '2' ) 13/08/2024 08:54:32 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4112' , '3' ) 13/08/2024 08:57:15 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4112' 13/08/2024 08:57:16 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4112' , '10' , '210' , 'JOLLY GROUP S.R.L.' , '' , '' , 'VIA ALLENDE 8' , '' , '84100' , 'SALERNO' , 'ANTONIO 3935213923' , '' , '' , '05126170652' , '' , NOW() , NOW() ) 13/08/2024 08:57:16 am >> UPDATE ps_customer SET email = 'villaggi@jollyanimation.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4112' 13/08/2024 08:57:25 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4112' 13/08/2024 08:57:25 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4112' , '10' , '210' , 'JOLLY GROUP S.R.L.' , '' , '' , 'VIA ALLENDE 8' , '' , '84100' , 'SALERNO' , 'ANTONIO 3935213923' , '' , '' , '05126170652' , '' , NOW() , NOW() ) 13/08/2024 08:57:25 am >> UPDATE ps_customer SET email = 'villaggi@jollyanimation.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4112' 13/08/2024 09:00:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1889' AND id_document != '92177' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 13/08/2024 09:00:29 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1889', document_date = '2024-06-05', 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 = '10.00', price_tax_excluded = '8.20', date_upd = NOW() WHERE id_document = '92177' 13/08/2024 09:00:29 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 = '92177' 13/08/2024 09:00:29 am >> DELETE FROM ps_document_detail WHERE id_document = '92177' 13/08/2024 09:00:30 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 ( '92177' , '14622' , 'IMMACOLATA CONCEZIONE BABY - 023 IC/9BB' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 13/08/2024 09:01:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1860' AND id_document != '92138' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-03') 13/08/2024 09:01:39 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1860', document_date = '2024-06-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 = '33.80', price_tax_excluded = '31.08', date_upd = NOW() WHERE id_document = '92138' 13/08/2024 09:01: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 = '92138' 13/08/2024 09:01:39 am >> DELETE FROM ps_document_detail WHERE id_document = '92138' 13/08/2024 09:01: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 ( '92138' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 13/08/2024 09:01: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 ( '92138' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 13/08/2024 09:01: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 ( '92138' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 13/08/2024 09:01: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 ( '92138' , '16244' , 'QUADRO 10X10' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' )