· 9 years ago · May 29, 2016, 03:03 PM
1Job Ravin *
2Cliente - Gustavo Garcia *
3Data 28-05-2016 *
4Por: Felipe Almeida *
5**************************************************************************************************************************************************
6
7job description:
8Alterar a tabela de preço os produtos possuem o cod_tabelapreco 001 para 004.
9
10cod_tabelapreco - 001 = desc_tabela - Padrao_SP
11cod_tabelapreco - 004 = desc_tabela - SITE
12
13
14---=== 0.1) Tabelas que possuem a coluna cod_tabelapreco
15
16 mbl_arqipe
17 mbl_arqped
18 mbl_tabpreco_item --> Tabela origem.
19
20
21
22---=== 1.) Identificação e validação dos registros a serem alterados que possuem cod_tabelapreco 001 para 004.
23---=== Tabela - mbl_tabpreco_item
24
25-- Quais são os produtos que possuem cod_tabelapreco igual a 001 e 004
26-- 2129 registros
27select * from mbl_tabpreco_item
28where cod_tabelapreco in ('001','004')
29order by cod_tabelapreco
30
31-- 1154 registro para 001
32select * from mbl_tabpreco_item
33where cod_tabelapreco in ('001')
34order by cod_tabelapreco
35
36-- 975 registros para 004
37select * from mbl_tabpreco_item
38where cod_tabelapreco in ('004')
39order by cod_tabelapreco
40
41
42
43---=== 2.) Identificação URL
44
45
46---===2.1) scriptComprasNovo.php
47
48
49--------====== URL - http://www.ravin.com.br/scriptComprasNovo.php
50-- Retorno --
51
52'Resultado Compras-> '.signing request: http://www.ravin.com.br/api/rest/orders?limit=100&filter[0][attribute]=status&filter[0][in][0]=processing&filter[0][in][1]=complete&filter[1][attribute]=created_at&filter[1][gt]=2016-05-08
53setting token to: Token[i63nf293g1ubtcuo8b7sj7t0ebkcanlm , 3tasd5m65jggxfkp5o7l1fs1rm6w8fmw]
54generating signature...
55using base64 encoder: CommonsCodec
56base string is: GET&http%3A%2F%2Fwww.ravin.com.br%2Fapi%2Frest%2Forders&filter%255B0%255D%255Battribute%255D%3Dstatus%26filter%255B0%255D%255Bin%255D%255B0%255D%3Dprocessing%26filter%255B0%255D%255Bin%255D%255B1%255D%3Dcomplete%26filter%255B1%255D%255Battribute%255D%3Dcreated_at%26filter%255B1%255D%255Bgt%255D%3D2016-05-08%26limit%3D100%26oauth_consumer_key%3Dwmrc2wr4edf26b2bvmmadvkoappn1bxq%26oauth_nonce%3D954529088%26oauth_signature_method%3DHMAC-SHA1%26oauth_timestamp%3D1464453890%26oauth_token%3Di63nf293g1ubtcuo8b7sj7t0ebkcanlm%26oauth_version%3D1.0
57signature is: ZrrahoHMxPRVaHI319w2I4/7OS4=
58appended additional OAuth parameters: { oauth_signature -> ZrrahoHMxPRVaHI319w2I4/7OS4= , oauth_version -> 1.0 , oauth_nonce -> 954529088 , oauth_signature_method -> HMAC-SHA1 , oauth_consumer_key -> wmrc2wr4edf26b2bvmmadvkoappn1bxq , oauth_token -> i63nf293g1ubtcuo8b7sj7t0ebkcanlm , oauth_timestamp -> 1464453890 }
59using Http Header signature
60[]
61Total de Ids encontrados: 0
62Encerrou a rotina de compras
63
64-- .php --
65
66<?php
67
68$output = shell_exec('cd /home/ravin/webapps/ROOT/java; ./jre/bin/java -Xmx128M -Xmx64M -cp ./:./postgresql-9.2-1002.jdbc4.jar -jar ravmbm.jar compras');
69//$output = 'cd webapps/ROOT/java';
70
71//$output = shell_exec('./compras.sh');
72echo "<pre>'Resultado Compras-> '.$output</pre>
73
74
75
76
77
78
79
80
81---=== 2.2) scriptFaturarNovo.php
82
83
84--------======= URL - http://www.ravin.com.br/scriptFaturarNovo.php
85-- Retorno --
86
87'Resultado Faturar: '.signing request: http://www.ravin.com.br/api/rest/orders?limit=100&filter[0][attribute]=status&filter[0][in][0]=pending&filter[1][attribute]=created_at&filter[1][gt]=2016-05-08
88setting token to: Token[i63nf293g1ubtcuo8b7sj7t0ebkcanlm , 3tasd5m65jggxfkp5o7l1fs1rm6w8fmw]
89generating signature...
90using base64 encoder: CommonsCodec
91base string is: GET&http%3A%2F%2Fwww.ravin.com.br%2Fapi%2Frest%2Forders&filter%255B0%255D%255Battribute%255D%3Dstatus%26filter%255B0%255D%255Bin%255D%255B0%255D%3Dpending%26filter%255B1%255D%255Battribute%255D%3Dcreated_at%26filter%255B1%255D%255Bgt%255D%3D2016-05-08%26limit%3D100%26oauth_consumer_key%3Dwmrc2wr4edf26b2bvmmadvkoappn1bxq%26oauth_nonce%3D720783918%26oauth_signature_method%3DHMAC-SHA1%26oauth_timestamp%3D1464453897%26oauth_token%3Di63nf293g1ubtcuo8b7sj7t0ebkcanlm%26oauth_version%3D1.0
92signature is: 3DJ9rVwD+6GjqMOqbu3mUbFyvLg=
93appended additional OAuth parameters: { oauth_signature -> 3DJ9rVwD+6GjqMOqbu3mUbFyvLg= , oauth_version -> 1.0 , oauth_nonce -> 720783918 , oauth_signature_method -> HMAC-SHA1 , oauth_consumer_key -> wmrc2wr4edf26b2bvmmadvkoappn1bxq , oauth_token -> i63nf293g1ubtcuo8b7sj7t0ebkcanlm , oauth_timestamp -> 1464453897 }
94using Http Header signature
95{"1061":{"entity_id":"1061","status":"pending","coupon_code":null,"shipping_description":"Frete gr\u00e1tis - Frete gr\u00e1tis","customer_id":"1879","base_discount_amount":"0.0000","base_grand_total":"479.6000","base_shipping_amount":"0.0000","base_shipping_tax_amount":"0.0000","base_subtotal":"436.0000","base_tax_amount":"43.6000","base_total_paid":null,"base_total_refunded":null,"discount_amount":"0.0000","grand_total":"479.6000","shipping_amount":"0.0000","shipping_tax_amount":"0.0000","store_to_order_rate":"1.0000","subtotal":"436.0000","tax_amount":"43.6000","total_paid":null,"total_refunded":null,"base_shipping_discount_amount":"0.0000","base_subtotal_incl_tax":"479.6000","base_total_due":null,"shipping_discount_amount":"0.0000","subtotal_incl_tax":"479.6000","total_due":null,"increment_id":"100002026","base_currency_code":"BRL","discount_description":"Frete Gr\u00e1tis - Entrega em at\u00e9 2 dias \u00fateis","remote_ip":"187.51.127.180","store_currency_code":"BRL","store_name":"Main Website\nMain Website Store\nDefault Store View","created_at":"2016-05-09 13:36:31","shipping_incl_tax":"0.0000","payment_method":"pagseguro","gift_message_from":null,"gift_message_to":null,"gift_message_body":null,"tax_name":"IPI","tax_rate":"10.0000","addresses":[{"region":"S\u00e3o Paulo","postcode":"05444-010","lastname":"SAYAD MAIA","street":"RUA DOS TAMANAS\n211\nVila Madalena","city":"SAO PAULO","email":"darcio@sp.senac.br","telephone":"(11) 3815-7869","country_id":"BR","firstname":"DARCIO","address_type":"billing","prefix":null,"middlename":null,"suffix":"4628593","company":null},{"region":"S\u00e3o Paulo","postcode":"05444-010","lastname":"SAYAD MAIA","street":"RUA DOS TAMANAS\n211\nVila Madalena","city":"SAO PAULO","email":"darcio@sp.senac.br","telephone":"(11) 3815-7869","country_id":"BR","firstname":"DARCIO","address_type":"shipping","prefix":null,"middlename":null,"suffix":"4628593","company":null}],"order_items":[{"item_id":"1858","parent_item_id":null,"sku":"CHA00111","name":"CHACRA BARDA PINOT NOIR 2011","qty_canceled":"0.0000","qty_invoiced":"0.0000","qty_ordered":"2.0000","qty_refunded":"0.0000","qty_shipped":"0.0000","price":"218.0000","base_price":"218.0000","original_price":"218.0000","base_original_price":"218.0000","tax_percent":"10.0000","tax_amount":"43.6000","base_tax_amount":"43.6000","discount_amount":"0.0000","base_discount_amount":"0.0000","row_total":"436.0000","base_row_total":"436.0000","price_incl_tax":"239.8000","base_price_incl_tax":"239.8000","row_total_incl_tax":"479.6000","base_row_total_incl_tax":"479.6000"}],"order_comments":[{"is_customer_notified":"1","is_visible_on_front":"0","comment":null,"status":"pending","created_at":"2016-05-09 13:36:33"}]},"1069":{"entity_id":"1069","status":"pending","coupon_code":null,"shipping_description":"Transportadora - Frete Transportadora","customer_id":"1884","base_discount_amount":"0.0000","base_grand_total":"201.0000","base_shipping_amount":"25.0000","base_shipping_tax_amount":"0.0000","base_subtotal":"160.0000","base_tax_amount":"16.0000","base_total_paid":null,"base_total_refunded":null,"discount_amount":"0.0000","grand_total":"201.0000","shipping_amount":"25.0000","shipping_tax_amount":"0.0000","store_to_order_rate":"1.0000","subtotal":"160.0000","tax_amount":"16.0000","total_paid":null,"total_refunded":null,"base_shipping_discount_amount":"0.0000","base_subtotal_incl_tax":"176.0000","base_total_due":null,"shipping_discount_amount":"0.0000","subtotal_incl_tax":"176.0000","total_due":null,"increment_id":"100002034","base_currency_code":"BRL","discount_description":null,"remote_ip":"187.37.244.9","store_currency_code":"BRL","store_name":"Main Website\nMain Website Store\nDefault Store View","created_at":"2016-05-20 16:45:23","shipping_incl_tax":"25.0000","payment_method":"pagseguro","gift_message_from":null,"gift_message_to":null,"gift_message_body":null,"tax_name":"IPI","tax_rate":"10.0000","addresses":[{"region":"S\u00e3o Paulo","postcode":"04517-050","lastname":"Grandeza","street":"AVENIDA DOS EUCALIPTOS\n155\nIndian\u00f3polis\napto 152","city":"SAO PAULO","email":"dgrandeza@hotmail.com","telephone":"(11) 2372-8860","country_id":"BR","firstname":"Daniela ","address_type":"billing","prefix":null,"middlename":null,"suffix":"234097012","company":null},{"region":"S\u00e3o Paulo","postcode":"04704-100","lastname":"Marinho","street":"RUA TESSATUNGA\n39\nJardim das Ac\u00e1cias\nVila","city":"SAO PAULO","email":null,"telephone":"11 97363-0101","country_id":"BR","firstname":"Paulo","address_type":"shipping","prefix":null,"middlename":null,"suffix":"234097012","company":null}],"order_items":[{"item_id":"1896","parent_item_id":null,"sku":"VMP01313","name":"VITRAL CARMENERE 2013","qty_canceled":"0.0000","qty_invoiced":"0.0000","qty_ordered":"2.0000","qty_refunded":"0.0000","qty_shipped":"0.0000","price":"80.0000","base_price":"80.0000","original_price":"80.0000","base_original_price":"80.0000","tax_percent":"10.0000","tax_amount":"16.0000","base_tax_amount":"16.0000","discount_amount":"0.0000","base_discount_amount":"0.0000","row_total":"160.0000","base_row_total":"160.0000","price_incl_tax":"88.0000","base_price_incl_tax":"88.0000","row_total_incl_tax":"176.0000","base_row_total_incl_tax":"176.0000"}],"order_comments":[{"is_customer_notified":"1","is_visible_on_front":"0","comment":null,"status":"pending","created_at":"2016-05-20 16:45:25"}]},"1075":{"entity_id":"1075","status":"pending","coupon_code":null,"shipping_description":"Frete gr\u00e1tis - Frete gr\u00e1tis","customer_id":"1888","base_discount_amount":"0.0000","base_grand_total":"346.5000","base_shipping_amount":"0.0000","base_shipping_tax_amount":"0.0000","base_subtotal":"315.0000","base_tax_amount":"31.5000","base_total_paid":null,"base_total_refunded":null,"discount_amount":"0.0000","grand_total":"346.5000","shipping_amount":"0.0000","shipping_tax_amount":"0.0000","store_to_order_rate":"1.0000","subtotal":"315.0000","tax_amount":"31.5000","total_paid":null,"total_refunded":null,"base_shipping_discount_amount":"0.0000","base_subtotal_incl_tax":"346.5000","base_total_due":null,"shipping_discount_amount":"0.0000","subtotal_incl_tax":"346.5000","total_due":null,"increment_id":"100002040","base_currency_code":"BRL","discount_description":"Frete Gr\u00e1tis - Entrega em at\u00e9 2 dias \u00fateis","remote_ip":"177.33.112.219","store_currency_code":"BRL","store_name":"Main Website\nMain Website Store\nDefault Store View","created_at":"2016-05-22 22:26:37","shipping_incl_tax":"0.0000","payment_method":"itaushopline_standard","gift_message_from":null,"gift_message_to":null,"gift_message_body":null,"tax_name":"IPI","tax_rate":"10.0000","addresses":[{"region":"S\u00e3o Paulo","postcode":"03337-070","lastname":"giraldi santana","street":"RUA NAGIB IZAR \n405\nJardim An\u00e1lia Franco\napt 251","city":"SAO PAULO","email":"doutorsantana@uol.com.br","telephone":"(11) 3473-8010","country_id":"BR","firstname":"marcelo ","address_type":"billing","prefix":null,"middlename":null,"suffix":"25754514-1","company":null},{"region":"S\u00e3o Paulo","postcode":"03337-070","lastname":"giraldi santana","street":"RUA NAGIB IZAR \n405\nJardim An\u00e1lia Franco\napt 251","city":"SAO PAULO","email":"doutorsantana@uol.com.br","telephone":"(11) 3473-8010","country_id":"BR","firstname":"marcelo ","address_type":"shipping","prefix":null,"middlename":null,"suffix":"25754514-1","company":null}],"order_items":[{"item_id":"1906","parent_item_id":null,"sku":"VLD00313","name":"VALDIVIESO CABERNET SAUVIGNON 2013","qty_canceled":"0.0000","qty_invoiced":"0.0000","qty_ordered":"5.0000","qty_refunded":"0.0000","qty_shipped":"0.0000","price":"63.0000","base_price":"63.0000","original_price":"63.0000","base_original_price":"63.0000","tax_percent":"10.0000","tax_amount":"31.5000","base_tax_amount":"31.5000","discount_amount":"0.0000","base_discount_amount":"0.0000","row_total":"315.0000","base_row_total":"315.0000","price_incl_tax":"69.3000","base_price_incl_tax":"69.3000","row_total_incl_tax":"346.5000","base_row_total_incl_tax":"346.5000"}],"order_comments":[{"is_customer_notified":"2","is_visible_on_front":"0","comment":"Valor autorizado de R$346,50.","status":"processing","created_at":"2016-05-22 22:26:41"},{"is_customer_notified":"1","is_visible_on_front":"0","comment":null,"status":"pending","created_at":"2016-05-22 22:26:41"}]},"1077":{"entity_id":"1077","status":"pending","coupon_code":null,"shipping_description":"Correios - PAC - Prazo dos Correios: em m\u00e9dia 6 dia(s) \u00fateis","customer_id":"1828","base_discount_amount":"0.0000","base_grand_total":"2147.3000","base_shipping_amount":"35.3000","base_shipping_tax_amount":"0.0000","base_subtotal":"1920.0000","base_tax_amount":"192.0000","base_total_paid":null,"base_total_refunded":null,"discount_amount":"0.0000","grand_total":"2147.3000","shipping_amount":"35.3000","shipping_tax_amount":"0.0000","store_to_order_rate":"1.0000","subtotal":"1920.0000","tax_amount":"192.0000","total_paid":null,"total_refunded":null,"base_shipping_discount_amount":"0.0000","base_subtotal_incl_tax":"2112.0000","base_total_due":null,"shipping_discount_amount":"0.0000","subtotal_incl_tax":"2112.0000","total_due":null,"increment_id":"100002042","base_currency_code":"BRL","discount_description":null,"remote_ip":"179.185.107.237","store_currency_code":"BRL","store_name":"Main Website\nMain Website Store\nDefault Store View","created_at":"2016-05-24 18:30:21","shipping_incl_tax":"35.3000","payment_method":"itaushopline_standard","gift_message_from":null,"gift_message_to":null,"gift_message_body":null,"tax_name":"IPI","tax_rate":"10.0000","addresses":[{"region":"Distrito Federal","postcode":"70736-050","lastname":"HON\u00d3RIO MEREGALLI DA SILVA","street":"SQN 304 BLOCO E APARTAMENTO 502\n304\nASA NORTE\nAPTO 502","city":"Bras\u00edlia","email":"rogerhms@gmail.com","telephone":"(61) 3532-1939","country_id":"BR","firstname":"ROGER ","address_type":"billing","prefix":null,"middlename":null,"suffix":"1032455634","company":null},{"region":"Distrito Federal","postcode":"70736-050","lastname":"HON\u00d3RIO MEREGALLI DA SILVA","street":"SQN 304 BLOCO E APARTAMENTO 502\n304\nASA NORTE\nAPTO 502","city":"Bras\u00edlia","email":"rogerhms@gmail.com","telephone":"(61) 3532-1939","country_id":"BR","firstname":"ROGER ","address_type":"shipping","prefix":null,"middlename":null,"suffix":"1032455634","company":null}],"order_items":[{"item_id":"1908","parent_item_id":null,"sku":"FFC02411","name":"DIRECTOR\u00b4S CUT DRY CREEK VALLEY CINEMA 2011","qty_canceled":"0.0000","qty_invoiced":"0.0000","qty_ordered":"4.0000","qty_refunded":"0.0000","qty_shipped":"0.0000","price":"480.0000","base_price":"480.0000","original_price":"480.0000","base_original_price":"480.0000","tax_percent":"10.0000","tax_amount":"192.0000","base_tax_amount":"192.0000","discount_amount":"0.0000","base_discount_amount":"0.0000","row_total":"1920.0000","base_row_total":"1920.0000","price_incl_tax":"528.0000","base_price_incl_tax":"528.0000","row_total_incl_tax":"2112.0000","base_row_total_incl_tax":"2112.0000"}],"order_comments":[{"is_customer_notified":"2","is_visible_on_front":"0","comment":"Valor autorizado de R$2.147,30.","status":"processing","created_at":"2016-05-24 18:30:23"},{"is_customer_notified":"1","is_visible_on_front":"0","comment":null,"status":"pending","created_at":"2016-05-24 18:30:23"}]}}
96Total de Ids encontrados: 4
97
98Sending 'POST' request to URL : https://shopline.itau.com.br/shopline/consulta.asp
99Post parameters : DC=S183H175Z210W13Y233V110X154A161M236I57L165M217P103S205S4P128M92K103Q208J14N7C146H45N98X243P247J59P118O57E42K204I209Q4D222R147Y
100Response Code : 200
101]>
102Pedido: 100002026: pending
103
104Sending 'POST' request to URL : https://shopline.itau.com.br/shopline/consulta.asp
105Post parameters : DC=M183C175J210T13F233I110U154M161H236V57O165W217G103W205B4X128F92T103F208P14A7W146F45L98G243G247G59C118L57I42F204W209T5L220Y147I
106Response Code : 200
107]>
108Pedido: 100002034: pending
109
110Sending 'POST' request to URL : https://shopline.itau.com.br/shopline/consulta.asp
111Post parameters : DC=P183B175M210S13X233S110T154R161A236S57K165O217G103I205J4N128K92T103F208G14B7Q146C45V98X243B247G59I118R57Y42H204R209R2C216C147Q
112Response Code : 200
113]>
114Pedido: 100002040: pending
115
116Sending 'POST' request to URL : https://shopline.itau.com.br/shopline/consulta.asp
117Post parameters : DC=Y183J175I210S13L233G110Z154U161H236O57A165N217K103L205O4J128F92N103Q208A14S7G146Z45N98E243D247Z59D118E57C42R204I209F2M218Z147G
118Response Code : 200
119]>
120Pedido: 100002042: pending
121Encerrou a rotina de faturar
122
123-- .php --
124
125<?php
126
127$output = shell_exec('cd /home/ravin/webapps/ROOT/java; ./jre/bin/java -Xmx128M -Xmx64M -cp ./:./postgresql-9.2-1002.jdbc4.jar -jar ravmbm.jar faturar');
128//$output = 'cd webapps/ROOT/java';
129
130//$output = shell_exec('./compras.sh');
131echo "<pre>'Resultado Faturar-> '.$output</pre>
132
133
134
135
136
137
138---=== 2.3) scriptProdutosNovo.php
139
140
141
142--------======= URL - http://www.ravin.com.br/scriptProdutosNovo.php
143-- Retorno --
144
145'Resultado Produtos: '.Total de linhas: 845
146Total de produtos encontrados: 725
147Finalizou
148
149
150-- .php --
151
152$output = shell_exec('cd /home/ravin/webapps/ROOT/java; ./jre/bin/java -Xmx128M -Xmx64M -cp ./:./postgresql-9.2-1002.jdbc4.jar -jar produtos.jar produtos');
153//$output = 'cd webapps/ROOT/java';
154
155//$output = shell_exec('./compras.sh');
156echo "<pre>'Resultado Produtos-> '.$output</pre>
157
158
159
160
161
162
163
164-----------=== 3.0 ) Transferia dos .jar
165
166 - postgresql-9.2-1002.jdbc4.jar
167 - produtos.jar
168 - ravmbm.jar
169
170
171
172-----------=== 3.1 )
173
174Realizado a descompilação dos arquivos dando inicio a analise da sintaxe SQL a ser alterada.
175Conforme detalhado em "JOB DESCRIPTION" (Inicio do documento)
176
177
178Querys Alteradas:
179
180--===== Arquivo OrderController20140811
181
182-- Linha 266
183INSERT INTO mbl_arqped(numero, data, cliente, condicao, area, valor, tipo, modopagto, codcondicao, fornecedor, cnpjcpf, integrado, cod_tabelapreco, cod_natoperacao, cod_empresa, cod_transp, cod_moeda, cod_tipofrete, cod_tipopedvenda, val_frete, situacao,mensagem,mensagem_nf)
184VALUES (?, ?, ?, ?, ?, ?, ?, ?, \t ?, ?, ?, ?, ?, \t ?, ?, ?, ?, ?, ?, ?, ?,?,?);
185
186-- Linha 454
187select p.cod_item,p.descricao,p.saldo_estoque,p.codigo,p.preco_venda ,pi.preco_venda as preco_venda_site, e.qtd_atual qtd_atual
188from mbl_arqprodutos p
189left join mbl_tabpreco_item pi on pi.codigo = trim(p.codigo)
190left join mbl_estoque e on e.codigo = trim(p.codigo)
191where trim(pi.cod_tabelapreco) = '004' and e.cod_deposito = '001'
192
193-- Linha 916
194select p.cod_item,p.descricao,p.saldo_estoque,p.codigo,p.preco_venda ,pi.preco_venda as preco_venda_site
195from mbl_arqprodutos p left join mbl_tabpreco_item pi on pi.codigo = trim(p.codigo)
196where trim(pi.cod_tabelapreco) = '004' and p.codigo = ''
197
198-- Linha 1.064
199select p.cod_item,p.descricao,p.saldo_estoque,p.codigo,p.preco_venda ,pi.preco_venda as preco_venda_site
200from mbl_arqprodutos p inner join mbl_tabpreco_item pi on pi.codigo = trim(p.codigo)
201where trim(pi.cod_tabelapreco) = '004'
202
203
204--===== Arquivo OrderControler.jad
205
206-- Linha 266
207INSERT INTO mbl_arqped(numero, data, cliente, condicao, area, valor, tipo, modopagto, codcondicao, fornecedor, cnpjcpf, integrado, cod_tabelapreco, cod_natoperacao, cod_empresa, cod_transp, cod_moeda, cod_tipofrete, cod_tipopedvenda, val_frete, situacao,mensagem,mensagem_nf)
208VALUES (?, ?, ?, ?, ?, ?, ?, ?, \t ?, ?, ?, ?, ?, \t ?, ?, ?, ?, ?, ?, ?, ?,?,?)
209
210--Linha 453
211SELECT P.COD_ITEM, P.DESCRICAO, P.SALDO_ESTOQUE, P.CODIGO, P.PRECO_VENDA, COALESCE(PI.PRECO_VENDA,0) AS PRECO_VENDA_SITE, COALESCE(E.QTD_ATUAL,0) AS QTD_ATUAL
212FROM MBL_ARQPRODUTOS P
213
214
215
216LEFT JOIN MBL_TABPRECO_ITEM PI ON PI.CODIGO = TRIM(P.CODIGO)
217AND PI.COD_TABELAPRECO = '004'
218LEFT JOIN MBL_ESTOQUE E ON E.CODIGO = TRIM(P.CODIGO)
219AND E.COD_DEPOSITO = '001'
220WHERE 1 = 1
221AND TRIM(P.CODIGO) NOT IN ('MOT00100', 'CARRO', 'ATF00001', 'ATF00002')
222AND SUBSTRING(TRIM(P.CODIGO),1,3) <> 'MER'
223AND SUBSTRING(TRIM(P.CODIGO),1,3) <> 'EMB'
224ORDER BY 4
225
226-- Linha 909 ( Editada )
227-- URL uri = new URL("http://ravin.web915.uni5.net/interface/importaSqlS.php");
228select p.cod_item,p.descricao,p.saldo_estoque,p.codigo,p.preco_venda ,pi.preco_venda as preco_venda_site
229from mbl_arqprodutos p
230left join mbl_tabpreco_item pi on pi.codigo = trim(p.codigo)
231where trim(pi.cod_tabelapreco) = '004'
232and p.codigo = ''
233
234-- Linha 1.057 ( Editada )
235-- URL uri = new URL("http://ravin.web915.uni5.net/interface/importa2.php");
236select p.cod_item,p.descricao,p.saldo_estoque,p.codigo,p.preco_venda ,pi.preco_venda as preco_venda_site
237from mbl_arqprodutos p
238inner join mbl_tabpreco_item pi on pi.codigo = trim(p.codigo)
239where trim(pi.cod_tabelapreco) = '004'
240
241
242
243----------======== 4.) Realizado a compilação para " postgresql-9.2-1002-rebuild.jdbc4.jar "
244----------======== 4.1) Realizado a subida do arquivo via FTP para o destino
245----------======== 4.2) Renomeado o antigo .jar para postgresql-9.2-1002.jdbc4.jar_29052016old
246
247
248
249
250
251
252----------======== 5.) Realizado o backup dos arquivos.
253
254Arquivos a serem alterados
255scriptProdutosNovo.php - Renoameado para scriptProdutosNovo.php_29052016old
256scriptFaturarNovo.php -Renomeado para scriptFaturarNovo.php_29052016old
257scriptComprasNovo.php - Renomeado para scriptComprasNovo.php_29052016old
258
259
260----------======== 5.1) Realizado a atualização do apontamento dos scripts;
261
262 scriptComprasNovo.php
263 scriptFaturarNovo.php
264 scriptProdutosNovo.php
265
266 Para o .jar atualizado.
267
268
269
270Criado novos arquivos a partir dos arquivos renomeados, com o nome anterior. Porém com o caminho apontando para o .jar atualizado (dentro dos scripts .php), contendo a modificação solicitada
271
272scriptComprasNovo.php - Atualizado
273scriptFaturarNovo.php - Atualizado
274scriptProdutosNovo.php - Atualizado