15/01/2024 09:13:07 am >> SELECT document_num FROM ps_document
WHERE document_num = '140' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-15')
15/01/2024 09:13:07 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' ,
'140' ,
'2024-01-15' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'75.50' ,
'72.60' ,
NOW() ,
NOW() )
15/01/2024 09:13:07 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 = '89941'
15/01/2024 09:13:07 am >> DELETE FROM ps_document_detail WHERE id_document = '89941'
15/01/2024 09:13:07 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
( '89941' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '12' , '-12' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '42.00' )
15/01/2024 09:13:07 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
( '89941' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '12.00' )
15/01/2024 09:13:07 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
( '89941' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '5' , '-5' , '3' ,
'4.30' , '4.1346153846154' , '4' , '0' , '21.50' )
15/01/2024 09:26:04 am >> SELECT document_num FROM ps_document
WHERE document_num = '4' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-15')
15/01/2024 09:26:04 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' ,
'4' ,
'2024-01-15' ,
'' ,
'5685' ,
'0' ,
'4672435' ,
'VIA UMBERTO I, 69 98046 S. LUCIA DEL MELA' ,
'' ,
'' ,
'2.9' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'7' ,
'0' ,
'20.00' ,
'20.00' ,
NOW() ,
NOW() )
15/01/2024 09:26: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 = '14032'
15/01/2024 09:26:04 am >> DELETE FROM ps_document_detail WHERE id_document = '14032'
15/01/2024 09:26: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
( '14032' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' ,
'18.00' , '18' , '0' , '5' , '17.10' )
15/01/2024 09:46:12 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
15/01/2024 09:46:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22053' , '1' , '' , 'nuovo-prodotto' )
15/01/2024 09:46:12 am >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'22053' , '1' , '1' , '2' , NOW() , NOW()
)
15/01/2024 09:46:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22053' , '0' , '1' , '0' , '0' )
15/01/2024 09:47:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736406' AND id_product != '22053' AND ean13 != ''
15/01/2024 09:47:56 am >> UPDATE ps_product SET
id_supplier = '',
reference = '13/3',
ean13 = '9791280736406',
date_upd = NOW()
WHERE id_product = '22053'
15/01/2024 09:47:56 am >> UPDATE ps_product_lang SET
name = 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA',
description = '
Il tempo quaresimale è sempre stato caratterizzato, in vista di un’autentica conversione personale, da tre dinamismi cardini della vita del cristiano: il digiuno, l’elemosina e la preghiera. Papa Francesco, nel percorso verso il Giubileo del 2025, ha pensato di dedicare l’anno precedente alla preghiera. In cui i cuori si aprano a ricevere l’abbondanza della grazia, facendo del ‘Padre nostro’ il programma di vita di ogni suo discepolo”. Sulla scia di questo progetto dedichiamo la guida alla Quaresima di quest’anno alla preghiera. Meditando il Padre nostro, i Salmi, le orazioni liturgiche e le preghiere di grandi santi e testimoni della fede, ci disponiamo ad una speciale scuola di preghiera che è anche scuola di teologia, non solo quindi fonte di ispirazione nel nostro dialogo intimo o comunitario con il Signore, ma anche prezioso approfondimento dottrinale. In questo percorso ci aiuta anche una breve riflessione sul Padre nostro, nelle pagine finali del sussidio. La preghiera porta necessariamente alla carità, altrimenti risulta vuota, arida, senza alcun senso.
'
WHERE id_product = '22053'
15/01/2024 09:47:56 am >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '2.5'
WHERE id_product = '22053'
15/01/2024 09:47:56 am >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '2.5',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '50',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '22053'
15/01/2024 09:47:56 am >> DELETE FROM ps_specific_price WHERE id_product = '22053'
15/01/2024 09:47:56 am >> 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' , '22053' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
15/01/2024 09:48:56 am >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '22053'
15/01/2024 10:21:17 am >> SELECT document_num FROM ps_document
WHERE document_num = '141' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-15')
15/01/2024 10:21:17 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' ,
'141' ,
'2024-01-15' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'18.50' ,
'18.50' ,
NOW() ,
NOW() )
15/01/2024 10:21:17 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 = '89942'
15/01/2024 10:21:17 am >> DELETE FROM ps_document_detail WHERE id_document = '89942'
15/01/2024 10:21:17 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
( '89942' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' ,
'18.50' , '18.5' , '0' , '0' , '18.50' )
15/01/2024 10:54:13 am >> SELECT document_num FROM ps_document
WHERE document_num = '142' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-15')
15/01/2024 10:54:14 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' ,
'142' ,
'2024-01-15' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'2.25' ,
'1.84' ,
NOW() ,
NOW() )
15/01/2024 10:54:14 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 = '89943'
15/01/2024 10:54:14 am >> DELETE FROM ps_document_detail WHERE id_document = '89943'
15/01/2024 10:54:14 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
( '89943' , '18620' , 'MEDAGLIA MIRACOLOSA BLU PICCOLA - 022M/SM' , '4' , '-4' , '1' ,
'0.50' , '0.40983606557377' , '22' , '0' , '2.00' )
15/01/2024 10:54:14 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
( '89943' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' ,
'0.25' , '0.20491803278689' , '22' , '0' , '0.25' )
15/01/2024 11:09:58 am >> SELECT document_num FROM ps_document
WHERE document_num = '143' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-15')
15/01/2024 11:09:58 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' ,
'143' ,
'2024-01-15' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.75' ,
'4.75' ,
NOW() ,
NOW() )
15/01/2024 11:09:58 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 = '89944'
15/01/2024 11:09:58 am >> DELETE FROM ps_document_detail WHERE id_document = '89944'
15/01/2024 11:09:58 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
( '89944' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
15/01/2024 11:13:06 am >> SELECT document_num FROM ps_document
WHERE document_num = '144' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-15')
15/01/2024 11:13:06 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' ,
'144' ,
'2024-01-15' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'9.50' ,
'9.50' ,
NOW() ,
NOW() )
15/01/2024 11:13:06 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 = '89945'
15/01/2024 11:13:06 am >> DELETE FROM ps_document_detail WHERE id_document = '89945'
15/01/2024 11:13:06 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
( '89945' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '2' , '-2' , '4' ,
'5.00' , '5' , '0' , '5' , '9.50' )
15/01/2024 11:16:31 am >> SELECT document_num FROM ps_document
WHERE document_num = '3284' AND id_document != '88470' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-23')
15/01/2024 11:16:31 am >> UPDATE ps_document SET
id_document_type = '11',
document_num = '3284',
document_date = '2023-10-23',
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 = '138.00',
price_tax_excluded = '113.11',
date_upd = NOW()
WHERE id_document = '88470'
15/01/2024 11:16: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 = '88470'
15/01/2024 11:16:31 am >> DELETE FROM ps_document_detail WHERE id_document = '88470'
15/01/2024 11:16: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
( '88470' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' ,
'3' , '2.4590163934426' , '22' , '0' , '6.00' )
15/01/2024 11:16: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
( '88470' , '20504' , 'CROCE PLEX - 3886' , '1' , '-1' , '1' ,
'39.0000' , '31.967213114754' , '22' , '0' , '39.00' )
15/01/2024 11:16: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
( '88470' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' ,
'59.0000' , '48.360655737705' , '22' , '0' , '59.00' )
15/01/2024 11:16: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
( '88470' , '19250' , 'CROCE MURANO FIOCCO - F. ORO' , '1' , '-1' , '1' ,
'34.00' , '27.868852459016' , '22' , '0' , '34.00' )
15/01/2024 11:49:41 am >> SELECT document_num FROM ps_document
WHERE document_num = '10' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-15')
15/01/2024 11:49:41 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' ,
'10' ,
'2024-01-15' ,
'' ,
'586' ,
'0' ,
'4676029' ,
'P.ZZA MADONNA DI FATIMA 3 83031 ARIANO IRPINO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'7' ,
'0' ,
'132.60' ,
'132.60' ,
NOW() ,
NOW() )
15/01/2024 11:49: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 = '89946'
15/01/2024 11:49:41 am >> DELETE FROM ps_document_detail WHERE id_document = '89946'
15/01/2024 11:49: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
( '89946' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '30' , '-30' , '4' ,
'2.40' , '2.4' , '0' , '15' , '61.20' )
15/01/2024 11:49: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
( '89946' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '30' , '-30' , '4' ,
'2.80' , '2.8' , '0' , '15' , '71.40' )
15/01/2024 03:29:23 pm >> SELECT document_num FROM ps_document
WHERE document_num = '145' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-15')
15/01/2024 03:29: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' ,
'145' ,
'2024-01-15' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'12.00' ,
'12.00' ,
NOW() ,
NOW() )
15/01/2024 03:29: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 = '89947'
15/01/2024 03:29:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '89947'
15/01/2024 03:29: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
( '89947' , '18362' , 'MIE PREGHIERE DI OGNI GIORNO' , '1' , '-1' , '4' ,
'12.00' , '12' , '0' , '0' , '12.00' )
15/01/2024 03:49:17 pm >> SELECT document_num FROM ps_document
WHERE document_num = '114' AND id_document != '89913' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-11')
15/01/2024 03:49:18 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '114',
document_date = '2024-01-11',
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 = '15.00',
price_tax_excluded = '13.74',
date_upd = NOW()
WHERE id_document = '89913'
15/01/2024 03:49:18 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 = '89913'
15/01/2024 03:49:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '89913'
15/01/2024 03:49:18 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
( '89913' , '20123' , 'FATIMA CM 17 - 1012' , '1' , '-1' , '1' ,
'7.0000' , '5.7377049180328' , '22' , '0' , '7.00' )
15/01/2024 03:49:18 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
( '89913' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'3' , '3' , '0' , '0' , '3.00' )
15/01/2024 03:49:18 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
( '89913' , '14529' , 'PANE E VINO - SUSSIDIO' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '' , '5.00' )
15/01/2024 05:33:08 pm >> SELECT document_num FROM ps_document
WHERE document_num = '146' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-15')
15/01/2024 05:33:08 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' ,
'146' ,
'2024-01-15' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'2.00' ,
'2.00' ,
NOW() ,
NOW() )
15/01/2024 05:33:08 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 = '89948'
15/01/2024 05:33:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '89948'
15/01/2024 05:33:08 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
( '89948' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'2' , '2' , '0' , '0' , '2.00' )
15/01/2024 07:07:36 pm >> SELECT document_num FROM ps_document
WHERE document_num = '147' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-15')
15/01/2024 07:07: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' ,
'147' ,
'2024-01-15' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.00' ,
'3.28' ,
NOW() ,
NOW() )
15/01/2024 07:07: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 = '89949'
15/01/2024 07:07:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '89949'
15/01/2024 07:07: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
( '89949' , '9181' , 'ROSARIO S. BENEDETTO LEGNO - 0341870BR' , '1' , '-1' , '1' ,
'4.00' , '3.2786885245902' , '22' , '0' , '4.00' )
15/01/2024 07:18:14 pm >> SELECT document_num FROM ps_document
WHERE document_num = '148' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-15')
15/01/2024 07:18: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' ,
'148' ,
'2024-01-15' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'5.70' ,
'5.70' ,
NOW() ,
NOW() )
15/01/2024 07:18: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 = '89950'
15/01/2024 07:18:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '89950'
15/01/2024 07:18:14 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
( '89950' , '21751' , 'MESSALINO QUOTIDIANO - FEB-MAR-APR 2024' , '1' , '-1' , '4' ,
'6.00' , '6' , '0' , '5' , '5.70' )