{"action":"created","issue":{"url":"https://api.github.com/repos/e-government-ua/i/issues/1146","repository_url":"https://api.github.com/repos/e-government-ua/i","labels_url":"https://api.github.com/repos/e-government-ua/i/issues/1146/labels{/name}","comments_url":"https://api.github.com/repos/e-government-ua/i/issues/1146/comments","events_url":"https://api.github.com/repos/e-government-ua/i/issues/1146/events","html_url":"https://github.com/e-government-ua/i/issues/1146","id":132739405,"number":1146,"title":"Реализовать сервис получения отчета о поданных заявках,","user":{"login":"bvv4ik","id":4208821,"avatar_url":"https://avatars.githubusercontent.com/u/4208821?v=3","gravatar_id":"","url":"https://api.github.com/users/bvv4ik","html_url":"https://github.com/bvv4ik","followers_url":"https://api.github.com/users/bvv4ik/followers","following_url":"https://api.github.com/users/bvv4ik/following{/other_user}","gists_url":"https://api.github.com/users/bvv4ik/gists{/gist_id}","starred_url":"https://api.github.com/users/bvv4ik/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bvv4ik/subscriptions","organizations_url":"https://api.github.com/users/bvv4ik/orgs","repos_url":"https://api.github.com/users/bvv4ik/repos","events_url":"https://api.github.com/users/bvv4ik/events{/privacy}","received_events_url":"https://api.github.com/users/bvv4ik/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/e-government-ua/i/labels/active","name":"active","color":"eb6420"},{"url":"https://api.github.com/repos/e-government-ua/i/labels/_activiti","name":"_activiti","color":"0052cc"},{"url":"https://api.github.com/repos/e-government-ua/i/labels/_wf-central","name":"_wf-central","color":"0052cc"}],"state":"open","locked":false,"assignee":{"login":"ASkosyr","id":12980290,"avatar_url":"https://avatars.githubusercontent.com/u/12980290?v=3","gravatar_id":"","url":"https://api.github.com/users/ASkosyr","html_url":"https://github.com/ASkosyr","followers_url":"https://api.github.com/users/ASkosyr/followers","following_url":"https://api.github.com/users/ASkosyr/following{/other_user}","gists_url":"https://api.github.com/users/ASkosyr/gists{/gist_id}","starred_url":"https://api.github.com/users/ASkosyr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ASkosyr/subscriptions","organizations_url":"https://api.github.com/users/ASkosyr/orgs","repos_url":"https://api.github.com/users/ASkosyr/repos","events_url":"https://api.github.com/users/ASkosyr/events{/privacy}","received_events_url":"https://api.github.com/users/ASkosyr/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/e-government-ua/i/milestones/5","html_url":"https://github.com/e-government-ua/i/milestones/BackEnd_Java","labels_url":"https://api.github.com/repos/e-government-ua/i/milestones/5/labels","id":1063352,"number":5,"title":"BackEnd_Java","description":"Разработка кастомных общих API/REST, которые вначале позволят реализовывать  нужные нам сервисы по авторизации(и не только), а потом станут общей-единой точкой входа, включающую текущие REST Activiti","creator":{"login":"bvv4ik","id":4208821,"avatar_url":"https://avatars.githubusercontent.com/u/4208821?v=3","gravatar_id":"","url":"https://api.github.com/users/bvv4ik","html_url":"https://github.com/bvv4ik","followers_url":"https://api.github.com/users/bvv4ik/followers","following_url":"https://api.github.com/users/bvv4ik/following{/other_user}","gists_url":"https://api.github.com/users/bvv4ik/gists{/gist_id}","starred_url":"https://api.github.com/users/bvv4ik/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bvv4ik/subscriptions","organizations_url":"https://api.github.com/users/bvv4ik/orgs","repos_url":"https://api.github.com/users/bvv4ik/repos","events_url":"https://api.github.com/users/bvv4ik/events{/privacy}","received_events_url":"https://api.github.com/users/bvv4ik/received_events","type":"User","site_admin":false},"open_issues":42,"closed_issues":235,"state":"open","created_at":"2015-04-11T19:27:45Z","updated_at":"2016-02-13T21:32:48Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2016-02-10T15:57:36Z","updated_at":"2016-02-14T21:11:04Z","closed_at":null,"body":"- [x] 1) Контекст и название: /action/event/getServiceHistoryReport\r\n\r\n- [x] 2) Параметры:\r\n> sDateAt - дата \"с\" (в формате YYYY-MM-DD hh:mm:ss)\r\n> sDateTo - дата \"по\" (включительно, в формате YYYY-MM-DD hh:mm:ss)\r\n\r\n- [x] 3) Данные отдавать в виде csv-файла\r\n\r\n- [x] 4) Поля с данными:\r\n> sID_Order - Строка-ИД заявки\r\n> nID_Server - Номер-ИД сервера\r\n> nID_Service - Номер-ИД услуги\r\n> sID_Place - Строка-ИД услуги (брать из поля sID_UA)\r\n> nID_Subject - Номер-ИД субьекта\r\n> nRate - число-рейтинг\r\n> sTextFeedback - строка-текст отзыва\r\n> sUserTaskName - строка названия текущей юзертаски (этапа)\r\n> sHead - строка заголовка\r\n> sBody - строка тела (описания)\r\n> nTimeMinutes - число минут, ушедших на отработку заявки\r\n> sPhone - строка с телефоном\r\n\r\n- [x] 5) Базовый список формировать из сущности HistoryEvent_Service, а к ней подгружать:\r\n- [x] 5.1) данные по отзыву (sTextFeedback) из сущности SubjectMessage, у которой nID_SubjectMessageType = 2\r\n- [x] 5.2) телефон - подгружая на региональном сервере заявку через сервис /getStartFormData, где nID_Task брать с одноименного поля сущности HistoryEvent_Service\r\n\r\n- [x] 6) коментировать сервис и параметры для автогенерации документации по АПИ\r\n"},"comment":{"url":"https://api.github.com/repos/e-government-ua/i/issues/comments/183977593","html_url":"https://github.com/e-government-ua/i/issues/1146#issuecomment-183977593","issue_url":"https://api.github.com/repos/e-government-ua/i/issues/1146","id":183977593,"user":{"login":"ASkosyr","id":12980290,"avatar_url":"https://avatars.githubusercontent.com/u/12980290?v=3","gravatar_id":"","url":"https://api.github.com/users/ASkosyr","html_url":"https://github.com/ASkosyr","followers_url":"https://api.github.com/users/ASkosyr/followers","following_url":"https://api.github.com/users/ASkosyr/following{/other_user}","gists_url":"https://api.github.com/users/ASkosyr/gists{/gist_id}","starred_url":"https://api.github.com/users/ASkosyr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ASkosyr/subscriptions","organizations_url":"https://api.github.com/users/ASkosyr/orgs","repos_url":"https://api.github.com/users/ASkosyr/repos","events_url":"https://api.github.com/users/ASkosyr/events{/privacy}","received_events_url":"https://api.github.com/users/ASkosyr/received_events","type":"User","site_admin":false},"created_at":"2016-02-14T21:11:04Z","updated_at":"2016-02-14T21:11:04Z","body":"Пример запроса:\r\nhttps://test.igov.org.ua/wf/service/action/event/getServiceHistoryReport?sDateAt=2016-02-09 00:00:00&sDateTo=2016-02-11 00:00:00\r\n\r\nПример результата\r\n```csv\r\nsID_Order,nID_Server,nID_Service,sID_Place,nID_Subject,nRate,sTextFeedback,sUserTaskName,sHead,sBody,nTimeMinutes,sPhone\r\n0-101277690,0,687,6800000000,44674,,,,Надання довідки про те, що посвідчення батьків та дитини з багатодітної сім'ї не видавалося,,20911,+380 97 729 9676\r\n0-88625055,0,740,6500000000,20045,,,,,Необхідно уточнити дані, за коментарем: не вірно вказані дані членів родини. Син - не відповідні ПІБ, бат - відсутні обов'язкові дані,,+380 97 225 5363\r\n```"}}