проблема такова:
после обновления(крайнего на 01.03.2016) появились проблемы с кодировкой данных получаемых по http
вот примеры запросов URL, а в прицепе скрины ответов
озвращает вопросы
SQL
SELECT invoice.format_number AS 'НомерДок', DATE_FORMAT(invoice.create_dt,'%Y%m%d%H%m%s') AS 'ДатаДок',
invoice.id AS 'ИДДокумента', contract.title AS 'НомерДоговора', invoice.summ AS 'Сумма' ,invoice.xml,
Vid.Title AS 'ВидДокумента'
FROM bill_invoice_data_5 AS invoice
INNER JOIN contract ON (invoice.cid=contract.id) AND (contract.fc=1)
INNER JOIN bill_doc_type_5 AS Vid ON Vid.id=invoice.type
WHERE invoice.create_dt>='2016.01.31'
AND invoice.create_dt<='2016.01.31'
URL
http://10.78.2.1:8080/bgbilling/executer?
user=user&pswd=pass&module=sqleditor&action=SQLEditor&pageSize=100000&sql=%0A%20SELECT%20%20invoice.format_number%20AS%20%27%D0%9D%D0%BE%D0%BC%D0%B5%D1%80%D0%94%D0%BE%D0%BA%27%2C%20DATE_FORMAT%28invoice.create_dt%2C%27%25Y%25m%25d%25H%25m%25s%27%29%20AS%20%27%D0%94%D0%B0%D1%82%D0%B0%D0%94%D0%BE%D0%BA%27%2C%0A%20%09%09%20%20invoice.id%20AS%20%27%D0%98%D0%94%D0%94%D0%BE%D0%BA%D1%83%D0%BC%D0%B5%D0%BD%D1%82%D0%B0%27%2C%20contract.title%20AS%20%27%D0%9D%D0%BE%D0%BC%D0%B5%D1%80%D0%94%D0%BE%D0%B3%D0%BE%D0%B2%D0%BE%D1%80%D0%B0%27%2C%20invoice.summ%20AS%20%27%D0%A1%D1%83%D0%BC%D0%BC%D0%B0%27%20%2Cinvoice.xml%2C%0A%09%09%20%20Vid.Title%20AS%20%27%D0%92%D0%B8%D0%B4%D0%94%D0%BE%D0%BA%D1%83%D0%BC%D0%B5%D0%BD%D1%82%D0%B0%27%0A%20FROM%20%20bill_invoice_data_5%20AS%20invoice%20%0A%20INNER%20JOIN%20contract%20ON%20%28invoice.cid%3Dcontract.id%29%20AND%20%28contract.fc%3D1%29%0A%20INNER%20JOIN%20bill_doc_type_5%20AS%20Vid%20ON%20Vid.id%3Dinvoice.type%0A%20WHERE%20invoice.create_dt%3E%3D%272016.01.31%27%20%0A%09AND%20invoice.create_dt%3C%3D%272016.01.31%27
это норм
SQL
SELECT id, name, title FROM module WHERE name='bill'ORDER BY id
URL
http://10.78.2.1:8080/bgbilling/execute ... %20BY%20id
помогите кто чем могёт)
| Вложения: |
|
GN2.png [ 46.02 КБ | Просмотров: 9816 ] |
|
GN1.png [ 80.01 КБ | Просмотров: 9816 ] |