06/02/2023 10:09:32 am >> SELECT document_num FROM ps_document
WHERE document_num = '26' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 10:09: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 (
'21' ,
'26' ,
'2023-02-06' ,
'' ,
'3191' ,
'0' ,
'4670958' ,
'VIA QUINTINO DI VONA 84133 SALERNO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'50.00' ,
'50.00' ,
NOW() ,
NOW() )
06/02/2023 10:09: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 = '81234'
06/02/2023 10:09:32 am >> DELETE FROM ps_document_detail WHERE id_document = '81234'
06/02/2023 10:09: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
( '81234' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '5' , '-5' , '4' ,
'10' , '10' , '0' , '0' , '50.00' )
06/02/2023 10:38:15 am >> SELECT document_num FROM ps_document
WHERE document_num = '418' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 10:38: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' ,
'418' ,
'2023-02-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'7.00' ,
'5.74' ,
NOW() ,
NOW() )
06/02/2023 10:38: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 = '81235'
06/02/2023 10:38:15 am >> DELETE FROM ps_document_detail WHERE id_document = '81235'
06/02/2023 10:38: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
( '81235' , '17941' , 'LOURDES - ISONZO 119 bis' , '2' , '-2' , '1' ,
'3.50' , '2.8688524590164' , '22' , '0' , '7.00' )
06/02/2023 11:10:23 am >> SELECT document_num FROM ps_document
WHERE document_num = '20/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 11:10:23 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' ,
'20/A' ,
'2023-02-06' ,
'A' ,
'3030' ,
'0' ,
'4671709' ,
'VIA SAN FELICE IN FELLINE, 10 84134 SALERNO' ,
'' ,
'acconto €40,00' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'135.00' ,
'110.66' ,
NOW() ,
NOW() )
06/02/2023 11:10:23 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 = '81236'
06/02/2023 11:10:23 am >> DELETE FROM ps_document_detail WHERE id_document = '81236'
06/02/2023 11:10:23 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
( '81236' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '1' , '-1' , '1' ,
'135.00' , '110.65573770492' , '22' , '0' , '135.00' )
06/02/2023 11:10:36 am >> SELECT document_num FROM ps_document
WHERE document_num = '419' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 11:10: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' ,
'419' ,
'2023-02-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'60.00' ,
'49.18' ,
NOW() ,
NOW() )
06/02/2023 11:10: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 = '81237'
06/02/2023 11:10:36 am >> DELETE FROM ps_document_detail WHERE id_document = '81237'
06/02/2023 11:10: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
( '81237' , '18399' , 'CAMICE DUE PIEGONI POL. CERNIERA DAVANTI - 405TPAD' , '1' , '-1' , '1' ,
'60' , '49.180327868852' , '22' , '0' , '60.00' )
06/02/2023 11:45:41 am >> SELECT document_num FROM ps_document
WHERE document_num = '26' AND id_document != '81234' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 11:45:41 am >> UPDATE ps_document SET
id_document_type = '21',
document_num = '26',
document_date = '2023-02-06',
document_letter = '',
id_customer = '3191',
id_supplier = '',
id_address = '4670958',
address1 = 'VIA QUINTINO DI VONA 84133 SALERNO',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '1',
id_causal = '0',
price_tax_included = '50.00',
price_tax_excluded = '50.00',
date_upd = NOW()
WHERE id_document = '81234'
06/02/2023 11:45:41 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 = '81234'
06/02/2023 11:45:41 am >> DELETE FROM ps_document_detail WHERE id_document = '81234'
06/02/2023 11:45:41 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
( '81234' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '5' , '-5' , '4' ,
'10.0000' , '10' , '0' , '0' , '50.00' )
06/02/2023 12:10:52 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3402'
06/02/2023 12:10:52 pm >> 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 (
'3402' ,
'10' ,
'125' ,
'PARROCCHIA SAN GREGORI MAGNO' ,
'PIEROSARA' ,
'DON GINO ' ,
'VIA COLLEPONI 10' ,
'' ,
'60040' ,
'GENGA' ,
'' ,
'' ,
'3383756483' ,
'' ,
'' ,
NOW() ,
NOW() )
06/02/2023 12:10:52 pm >> UPDATE ps_customer SET
email = 'donginopierosara@libero.it',
sdi = '',
pec = '',
date_upd = NOW()
WHERE id_customer = '3402'
06/02/2023 12:11:34 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3402'
06/02/2023 12:11:34 pm >> 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 (
'3402' ,
'10' ,
'125' ,
'PARROCCHIA SAN GREGORI MAGNO' ,
'PIEROSARA' ,
'DON GINO ' ,
'VIA COLLEPONI 10' ,
'' ,
'60040' ,
'GENGA' ,
'' ,
'' ,
'3383756483' ,
'' ,
'90003000420' ,
NOW() ,
NOW() )
06/02/2023 12:11:34 pm >> UPDATE ps_customer SET
email = 'donginopierosara@libero.it',
sdi = '',
pec = '',
date_upd = NOW()
WHERE id_customer = '3402'
06/02/2023 12:12:44 pm >> SELECT document_num FROM ps_document
WHERE document_num = '27' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 12:12:44 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 (
'21' ,
'27' ,
'2023-02-06' ,
'' ,
'3402' ,
'0' ,
'4678649' ,
'VIA COLLEPONI 10 60040 GENGA' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'306.00' ,
'306.00' ,
NOW() ,
NOW() )
06/02/2023 12:12:44 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 = '81238'
06/02/2023 12:12:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '81238'
06/02/2023 12:12:44 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
( '81238' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '400' , '-400' , '4' ,
'0.90' , '0.9' , '0' , '15' , '306.00' )
06/02/2023 12:17:02 pm >> SELECT document_num FROM ps_document
WHERE document_num = '420' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 12:17:02 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' ,
'420' ,
'2023-02-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'83.60' ,
'83.60' ,
NOW() ,
NOW() )
06/02/2023 12:17:02 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 = '81239'
06/02/2023 12:17:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '81239'
06/02/2023 12:17:02 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
( '81239' , '1147' , 'BIBBIA DI GERUSALEMME X STUDIO' , '2' , '-2' , '4' ,
'44.00' , '44' , '0' , '5' , '83.60' )
06/02/2023 12:18:29 pm >> SELECT document_num FROM ps_document
WHERE document_num = '421' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 12:18:29 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' ,
'421' ,
'2023-02-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'7.40' ,
'7.40' ,
NOW() ,
NOW() )
06/02/2023 12:18:29 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 = '81240'
06/02/2023 12:18:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '81240'
06/02/2023 12:18:29 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
( '81240' , '20660' , 'QUARESIMA E PASQUA ' , '1' , '-1' , '4' ,
'2.90' , '2.9' , '0' , '0' , '2.90' )
06/02/2023 12:18:29 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
( '81240' , '20710' , 'VIA CRUCIS DELLA PACE' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '0' , '2.00' )
06/02/2023 12:18:29 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
( '81240' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' ,
'1.00' , '1' , '0' , '0' , '1.00' )
06/02/2023 12:18:29 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
( '81240' , '18528' , 'CON GESU VERSO IL CALVARIO - P. G. VALSECCHI' , '1' , '-1' , '4' ,
'1.50' , '1.5' , '0' , '0' , '1.50' )
06/02/2023 12:25:52 pm >> SELECT document_num FROM ps_document
WHERE document_num = '422' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 12:25:52 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' ,
'422' ,
'2023-02-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'66.32' ,
'66.32' ,
NOW() ,
NOW() )
06/02/2023 12:25:52 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 = '81241'
06/02/2023 12:25:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '81241'
06/02/2023 12:25:52 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
( '81241' , '16345' , 'REGOLA DELLORDINE FRANCESCANO SECOLARE' , '22' , '-22' , '4' ,
'3.00' , '3' , '0' , '5' , '62.70' )
06/02/2023 12:25:52 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
( '81241' , '19423' , 'PELLEGRINI DI SPERANZA' , '2' , '-2' , '4' ,
'1.90' , '1.9' , '0' , '5' , '3.62' )
06/02/2023 12:27:05 pm >> SELECT document_num FROM ps_document
WHERE document_num = '423' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 12:27:05 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' ,
'423' ,
'2023-02-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'1.00' ,
'0.82' ,
NOW() ,
NOW() )
06/02/2023 12:27:05 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 = '81242'
06/02/2023 12:27:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '81242'
06/02/2023 12:27:05 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
( '81242' , '18131' , 'TAU MEDIO CM3 - T6' , '1' , '-1' , '1' ,
'1.00' , '0.81967213114754' , '22' , '0' , '1.00' )
06/02/2023 12:34:26 pm >> SELECT document_num FROM ps_document
WHERE document_num = '424' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 12:34:26 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' ,
'424' ,
'2023-02-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'12.26' ,
'12.26' ,
NOW() ,
NOW() )
06/02/2023 12:34: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 = '81243'
06/02/2023 12:34:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '81243'
06/02/2023 12:34:27 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
( '81243' , '19501' , 'PACE INTERIORE - C. AMIRANTE' , '1' , '-1' , '4' ,
'12.90' , '12.9' , '0' , '5' , '12.26' )
06/02/2023 12:39:20 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3402'
06/02/2023 12:39:20 pm >> 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 (
'3402' ,
'10' ,
'125' ,
'PARROCCHIA SAN GREGORIO MAGNO' ,
'PIEROSARA' ,
'DON GINO ' ,
'VIA COLLEPONI 10' ,
'' ,
'60040' ,
'GENGA' ,
'' ,
'' ,
'3383756483' ,
'' ,
'90003000420' ,
NOW() ,
NOW() )
06/02/2023 12:39:20 pm >> UPDATE ps_customer SET
email = 'donginopierosara@libero.it',
sdi = '',
pec = '',
date_upd = NOW()
WHERE id_customer = '3402'
06/02/2023 03:49:20 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
06/02/2023 03:49:20 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20719' , '1' , '' , 'nuovo-prodotto' )
06/02/2023 03:49:20 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'20719' , '1' , '1' , '2' , NOW() , NOW()
)
06/02/2023 03:49:20 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20719' , '0' , '1' , '0' , '0' )
06/02/2023 03:51:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736130' AND id_product != '20719' AND ean13 != ''
06/02/2023 03:51:20 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/3',
ean13 = '9791280736130',
date_upd = NOW()
WHERE id_product = '20719'
06/02/2023 03:51:20 pm >> UPDATE ps_product_lang SET
name = 'CORONA DELL’ADDOLORATA',
description = ''
WHERE id_product = '20719'
06/02/2023 03:51:20 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '1.8'
WHERE id_product = '20719'
06/02/2023 03:51:20 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '1.8',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '28',
id_internal_category = '4',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20719'
06/02/2023 03:51:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '20719'
06/02/2023 03:52:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736130' AND id_product != '20719' AND ean13 != ''
06/02/2023 03:52:18 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '13/3',
ean13 = '9791280736130',
date_upd = NOW()
WHERE id_product = '20719'
06/02/2023 03:52:18 pm >> UPDATE ps_product_lang SET
name = 'CORONA DELL’ADDOLORATA',
description = 'La Chiesa ricorda i dolori di Maria, l’Addolorata. Da secoli questa venerazione è diffusa fra il popolo di Dio. La devozione ai dolori di Maria fu prima una devozione popolare e solo in seguito liturgica e contempla i sette momenti messi in rilievo dai Vangeli.
La pietà cristiana ha raccolto i dolori della Madonna e parla dei “sette dolori”.
'
WHERE id_product = '20719'
06/02/2023 03:52:18 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '1.8'
WHERE id_product = '20719'
06/02/2023 03:52:18 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '1.8',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '28',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '1',
date_upd = NOW()
WHERE id_product = '20719'
06/02/2023 03:52:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '20719'
06/02/2023 03:52:18 pm >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '20719' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
06/02/2023 03:52:34 pm >> INSERT INTO ps_product (
id_tax_rules_group , `date_add` , `date_upd`
) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20719'
06/02/2023 03:52:34 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20720' , '1' , '' , 'nuovo-prodotto' )
06/02/2023 03:52:34 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
) SELECT '20720' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20719'
06/02/2023 03:52:34 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '20720' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20719'
06/02/2023 03:55:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736161' AND id_product != '20720' AND ean13 != ''
06/02/2023 03:55:55 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '1/3',
ean13 = '9791280736161',
date_upd = NOW()
WHERE id_product = '20720'
06/02/2023 03:55:55 pm >> UPDATE ps_product_lang SET
name = 'PADRE NOSTRO',
description = 'Questo commento al Padre Nostro vuole presentarsi come un piccolo aiuto per penetrare nella bellezza di una preghiera che è unica al mondo.
La preghiera del Padre nostro è la più importante di tutte le altre preghiere cristiane per l’autorità di chi l’ha composta, per la brevità delle parole, perché contiene tutto ciò che è necessario e utile per questa vita e per l’altra.
'
WHERE id_product = '20720'
06/02/2023 03:55:55 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '4.5'
WHERE id_product = '20720'
06/02/2023 03:55:56 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '4.5',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '145',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20720'
06/02/2023 03:55:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '20720'
06/02/2023 03:55:56 pm >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '20720' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
06/02/2023 03:56:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736161' AND id_product != '20720' AND ean13 != ''
06/02/2023 03:56:18 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '1/3',
ean13 = '9791280736161',
date_upd = NOW()
WHERE id_product = '20720'
06/02/2023 03:56:18 pm >> UPDATE ps_product_lang SET
name = 'PADRE NOSTRO - L. CALABRETTA',
description = 'Questo commento al Padre Nostro vuole presentarsi come un piccolo aiuto per penetrare nella bellezza di una preghiera che è unica al mondo.
La preghiera del Padre nostro è la più importante di tutte le altre preghiere cristiane per l’autorità di chi l’ha composta, per la brevità delle parole, perché contiene tutto ciò che è necessario e utile per questa vita e per l’altra.
'
WHERE id_product = '20720'
06/02/2023 03:56:18 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '4.5'
WHERE id_product = '20720'
06/02/2023 03:56:18 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '4.5',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '145',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20720'
06/02/2023 03:56:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '20720'
06/02/2023 03:56:19 pm >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '20720' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
06/02/2023 04:00:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736161' AND id_product != '20720' AND ean13 != ''
06/02/2023 04:00:15 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '1/3',
ean13 = '9791280736161',
date_upd = NOW()
WHERE id_product = '20720'
06/02/2023 04:00:15 pm >> UPDATE ps_product_lang SET
name = 'PADRE NOSTRO - L. CALABRETTA',
description = 'Questo commento al Padre Nostro vuole presentarsi come un piccolo aiuto per penetrare nella bellezza di una preghiera che è unica al mondo.
La preghiera del Padre nostro è la più importante di tutte le altre preghiere cristiane per l’autorità di chi l’ha composta, per la brevità delle parole, perché contiene tutto ciò che è necessario e utile per questa vita e per l’altra.
'
WHERE id_product = '20720'
06/02/2023 04:00:15 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '4.5'
WHERE id_product = '20720'
06/02/2023 04:00:15 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '4.5',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '145',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20720'
06/02/2023 04:00:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '20720'
06/02/2023 04:00:15 pm >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '20720' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
06/02/2023 04:00:44 pm >> INSERT INTO ps_product (
id_tax_rules_group , `date_add` , `date_upd`
) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20720'
06/02/2023 04:00:44 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20721' , '1' , '' , 'nuovo-prodotto' )
06/02/2023 04:00:44 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
) SELECT '20721' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20720'
06/02/2023 04:00:44 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '20721' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20720'
06/02/2023 04:01:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736154' AND id_product != '20721' AND ean13 != ''
06/02/2023 04:01:46 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '1/3',
ean13 = '9791280736154',
date_upd = NOW()
WHERE id_product = '20721'
06/02/2023 04:01:46 pm >> UPDATE ps_product_lang SET
name = 'AVE MARIA - L. CALABRETTA',
description = 'Ogni volta che preghiamo l’Ave Maria confidiamo nel ruolo fondamentale che è stato affidato alla Madonna: esserci Madre e quindi essere mediatrice privilegiata fra noi e il suo Figlio Gesù.
Questo testo ci invita a suscitare nel nostro cuore profonda confidenza in Maria, serena certezza nel suo affetto materno, dolce tranquillità di spirito al pensiero.
'
WHERE id_product = '20721'
06/02/2023 04:01:46 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '4.5'
WHERE id_product = '20721'
06/02/2023 04:01:46 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '4.5',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '145',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20721'
06/02/2023 04:01:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '20721'
06/02/2023 04:01:46 pm >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '20721' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
06/02/2023 04:01:47 pm >> INSERT INTO ps_product (
id_tax_rules_group , `date_add` , `date_upd`
) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20721'
06/02/2023 04:01:47 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20722' , '1' , '' , 'nuovo-prodotto' )
06/02/2023 04:01:47 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
) SELECT '20722' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20721'
06/02/2023 04:01:47 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '20722' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20721'
06/02/2023 04:06:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736178' AND id_product != '20722' AND ean13 != ''
06/02/2023 04:06:37 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '1/3',
ean13 = '9791280736178',
date_upd = NOW()
WHERE id_product = '20722'
06/02/2023 04:06:37 pm >> UPDATE ps_product_lang SET
name = 'SEMINATORI DI GIOIA',
description = 'In occasione del decimo anniversario di pontificato di Papa Francesco, questo opuscolo intende offrire, in maniera semplice, alcune idee fondamentali sull’identità e la missione del catechista, proprio a partire da quanto Papa Francesco ha detto e scritto. Ma chi è il catechista? Quali sono le caratteristiche principali del suo ministero? Proviamo a rispondere a queste domande, lasciandoci aiutare dallo stesso Papa Francesco. Spulciando fra i suoi discorsi e le sue lettere, possiamo individuare dieci caratteristiche che delineano i tratti peculiari del catechista.
'
WHERE id_product = '20722'
06/02/2023 04:06:37 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.5'
WHERE id_product = '20722'
06/02/2023 04:06:37 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.5',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '22',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '1',
date_upd = NOW()
WHERE id_product = '20722'
06/02/2023 04:06:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '20722'
06/02/2023 04:06:37 pm >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '20722' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
06/02/2023 04:14:56 pm >> SELECT document_num FROM ps_document
WHERE document_num = '425' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 04:14:56 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' ,
'425' ,
'2023-02-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'109.00' ,
'97.17' ,
NOW() ,
NOW() )
06/02/2023 04:14:56 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 = '81244'
06/02/2023 04:14:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '81244'
06/02/2023 04:14:56 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
( '81244' , '5458' , 'IO SONO CON VOI 2 PARTE' , '3' , '-3' , '4' ,
'2.50' , '2.5' , '0' , '5' , '7.14' )
06/02/2023 04:14:56 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
( '81244' , '15703' , 'CARTONCINO CRESIMA CON CROCETTA - 2370/K51' , '27' , '-27' , '1' ,
'2.30' , '1.8852459016393' , '22' , '0' , '62.10' )
06/02/2023 04:14:56 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
( '81244' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' ,
'3.50' , '2.8688524590164' , '22' , '0' , '3.50' )
06/02/2023 04:14:56 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
( '81244' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'18.91' , '18.91' , '0' , '0' , '18.91' )
06/02/2023 04:14:56 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
( '81244' , '20670' , 'CIO CHE CONTA E AMARE' , '1' , '-1' , '4' ,
'3.70' , '3.7' , '0' , '5' , '3.52' )
06/02/2023 04:14:56 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
( '81244' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' ,
'1.00' , '1' , '0' , '0' , '1.00' )
06/02/2023 04:14:56 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
( '81244' , '20661' , 'LASCIATI AMARE - P. CURTAZ' , '1' , '-1' , '4' ,
'4.00' , '4' , '0' , '5' , '3.80' )
06/02/2023 04:14:56 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
( '81244' , '20710' , 'VIA CRUCIS DELLA PACE' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '5' , '1.90' )
06/02/2023 04:14:56 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
( '81244' , '20711' , 'VIA CRUCIS IN CAMMINO CON LA CHIESA ' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '5' , '1.90' )
06/02/2023 04:14:56 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
( '81244' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '5' , '2.38' )
06/02/2023 04:14:56 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
( '81244' , '16667' , 'VIA CRUCIS' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '5' , '2.85' )
06/02/2023 04:19:23 pm >> SELECT document_num FROM ps_document
WHERE document_num = '426' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 04:19:23 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' ,
'426' ,
'2023-02-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'17.50' ,
'14.34' ,
NOW() ,
NOW() )
06/02/2023 04:19:23 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 = '81245'
06/02/2023 04:19:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '81245'
06/02/2023 04:19:23 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
( '81245' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' ,
'3.50' , '2.8688524590164' , '22' , '0' , '17.50' )
06/02/2023 04:42:19 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '20719'
06/02/2023 04:42:38 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '20721'
06/02/2023 04:42:48 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '20720'
06/02/2023 04:42:59 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '20722'
06/02/2023 04:56:45 pm >> SELECT document_num FROM ps_document
WHERE document_num = '427' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 04:56:45 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' ,
'427' ,
'2023-02-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'70.00' ,
'64.96' ,
NOW() ,
NOW() )
06/02/2023 04:56:45 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 = '81246'
06/02/2023 04:56:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '81246'
06/02/2023 04:56:45 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
( '81246' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' ,
'10.00' , '8.1967213114754' , '22' , '0' , '10.00' )
06/02/2023 04:56:45 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
( '81246' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' ,
'3.50' , '2.8688524590164' , '22' , '0' , '10.50' )
06/02/2023 04:56:45 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
( '81246' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '35.00' )
06/02/2023 04:56:45 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
( '81246' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'14.5' , '14.5' , '0' , '0' , '14.50' )
06/02/2023 05:35:38 pm >> SELECT document_num FROM ps_document
WHERE document_num = '428' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 05:35:38 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' ,
'428' ,
'2023-02-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'11.40' ,
'11.40' ,
NOW() ,
NOW() )
06/02/2023 05:35:38 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 = '81247'
06/02/2023 05:35:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '81247'
06/02/2023 05:35:38 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
( '81247' , '3511' , 'DIO PARLA ALLUOMO' , '1' , '-1' , '4' ,
'12.00' , '12' , '0' , '5' , '11.40' )
06/02/2023 05:41:57 pm >> SELECT document_num FROM ps_document
WHERE document_num = '429' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 05:41:57 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' ,
'429' ,
'2023-02-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'22.00' ,
'18.03' ,
NOW() ,
NOW() )
06/02/2023 05:41:57 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 = '81248'
06/02/2023 05:41:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '81248'
06/02/2023 05:41:57 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
( '81248' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'22' , '18.032786885246' , '22' , '0' , '22.00' )
06/02/2023 06:03:58 pm >> SELECT document_num FROM ps_document
WHERE document_num = '427' AND id_document != '81246' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 06:03:58 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '427',
document_date = '2023-02-06',
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 = '70.00',
price_tax_excluded = '64.96',
date_upd = NOW()
WHERE id_document = '81246'
06/02/2023 06:03:58 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 = '81246'
06/02/2023 06:03:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '81246'
06/02/2023 06:03:58 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
( '81246' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' ,
'10.0000' , '8.1967213114754' , '22' , '0' , '10.00' )
06/02/2023 06:03:58 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
( '81246' , '6074' , 'MADONNA DI LOURDES - 120' , '3' , '-3' , '1' ,
'3.50' , '2.8688524590164' , '22' , '0' , '10.50' )
06/02/2023 06:03:58 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
( '81246' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' ,
'3.5000' , '3.3653846153846' , '4' , '0' , '35.00' )
06/02/2023 06:03:58 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
( '81246' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'14.5000' , '14.5' , '0' , '0' , '14.50' )
06/02/2023 06:32:14 pm >> SELECT document_num FROM ps_document
WHERE document_num = '430' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 06:32:14 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' ,
'430' ,
'2023-02-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'11.00' ,
'9.02' ,
NOW() ,
NOW() )
06/02/2023 06:32:14 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 = '81249'
06/02/2023 06:32:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '81249'
06/02/2023 06:32: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
( '81249' , '18212' , 'CORONA DELLE LACRIME' , '1' , '-1' , '1' ,
'11.00' , '9.016393442623' , '22' , '0' , '11.00' )
06/02/2023 06:39:34 pm >> SELECT document_num FROM ps_document
WHERE document_num = '431' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 06:39:35 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' ,
'431' ,
'2023-02-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'13.60' ,
'11.15' ,
NOW() ,
NOW() )
06/02/2023 06:39:35 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 = '81250'
06/02/2023 06:39:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '81250'
06/02/2023 06:39:35 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
( '81250' , '19754' , 'BRUCIA INCENSI CAMPANA' , '1' , '-1' , '1' ,
'10.90' , '8.9344262295082' , '22' , '0' , '10.90' )
06/02/2023 06:39:35 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
( '81250' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' ,
'1.50' , '1.2295081967213' , '22' , '0' , '1.50' )
06/02/2023 06:39:35 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
( '81250' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' ,
'1.2' , '0.98360655737705' , '22' , '0' , '1.20' )
06/02/2023 06:59:37 pm >> SELECT document_num FROM ps_document
WHERE document_num = '432' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 06:59:37 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' ,
'432' ,
'2023-02-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'2.80' ,
'2.30' ,
NOW() ,
NOW() )
06/02/2023 06:59:37 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 = '81251'
06/02/2023 06:59:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '81251'
06/02/2023 06:59:37 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
( '81251' , '15387' , 'VESTINA BATTESIMALE ' , '1' , '-1' , '1' ,
'2.80' , '2.2950819672131' , '22' , '0' , '2.80' )
06/02/2023 07:00:00 pm >> DELETE FROM ps_document WHERE id_document = '81251'
06/02/2023 07:00:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '81251'
06/02/2023 07:00:13 pm >> SELECT document_num FROM ps_document
WHERE document_num = '432' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 07:00:13 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' ,
'432' ,
'2023-02-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'2.80' ,
'2.30' ,
NOW() ,
NOW() )
06/02/2023 07:00:13 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 = '81252'
06/02/2023 07:00:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '81252'
06/02/2023 07:00:13 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
( '81252' , '15387' , 'VESTINA BATTESIMALE ' , '1' , '-1' , '1' ,
'2.80' , '2.2950819672131' , '22' , '0' , '2.80' )
06/02/2023 07:12:03 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3402'
06/02/2023 07:12:03 pm >> 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 (
'3402' ,
'10' ,
'125' ,
'PARROCCHIA SAN GREGORIO MAGNO' ,
'PIEROSARA' ,
'DON GINO ' ,
'FRAZ. COLLEPONI 10' ,
'' ,
'60040' ,
'GENGA' ,
'' ,
'' ,
'3383756483' ,
'' ,
'90003000420' ,
NOW() ,
NOW() )
06/02/2023 07:12:03 pm >> UPDATE ps_customer SET
email = 'donginopierosara@libero.it',
sdi = '',
pec = '',
date_upd = NOW()
WHERE id_customer = '3402'
06/02/2023 07:16:19 pm >> SELECT document_num FROM ps_document
WHERE document_num = '1/E' AND id_document != '79907' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-27')
06/02/2023 07:16:19 pm >> UPDATE ps_document SET
id_document_type = '23',
document_num = '1/E',
document_date = '2023-01-27',
document_letter = 'E',
id_customer = '3000',
id_supplier = '',
id_address = '4669629',
address1 = 'VIA DEI CASTANI, 116 00172 ROMA',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '14',
id_causal = '0',
price_tax_included = '864.00',
price_tax_excluded = '708.20',
date_upd = NOW()
WHERE id_document = '79907'
06/02/2023 07:16:19 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 = '79907'
06/02/2023 07:16:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '79907'
06/02/2023 07:16:19 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
( '79907' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '30' , '-30' , '1' ,
'12.0000' , '9.8360655737705' , '22' , '40' , '216.00' )
06/02/2023 07:16:19 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
( '79907' , '12849' , 'LIBRO DELLE SS. MESSE' , '30' , '-30' , '1' ,
'20.0000' , '16.393442622951' , '22' , '40' , '360.00' )
06/02/2023 07:16:19 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
( '79907' , '12817' , 'LIBRO DEI MATRIMONI' , '12' , '-12' , '1' ,
'40.0000' , '32.786885245902' , '22' , '40' , '288.00' )
06/02/2023 08:04:19 pm >> SELECT document_num FROM ps_document
WHERE document_num = '433' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06')
06/02/2023 08:04:19 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' ,
'433' ,
'2023-02-06' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'109.00' ,
'89.34' ,
NOW() ,
NOW() )
06/02/2023 08:04:19 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 = '81253'
06/02/2023 08:04:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '81253'
06/02/2023 08:04:19 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
( '81253' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' ,
'3.3' , '2.7049180327869' , '22' , '0' , '99.00' )
06/02/2023 08:04:19 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
( '81253' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'10' , '8.1967213114754' , '22' , '0' , '10.00' )