/
Отчёты для SetRetail5 (процедура на стороне SetRetail5/SetCentrum5)

Публичный ресурс

Отчёты для SetRetail5 (процедура на стороне SetRetail5/SetCentrum5)

    Отчёт об очередях в SetCentrum5

    https://crystals.atlassian.net/browse/SRTE-1148

    10.2.36.0

    Метод преобразует массив с объектами в список в формате xml двухуровневой вложенности

    Служба в фоновом режиме опрашивает очередь ответов кассиров и отправляет сформированный xml в хранимую процедуру расположенную на SetCentrum5

    Наименование процедуры в MSSQL:  set10PutCashierQuestion

    root/messages/cashierQuestion

    Наименование атрибута

    Тип данных

    Описание

    Обязательное

    cash_number

    String

    Номер кассы

    Да

    shop_number

    String

    Номер магазина

    Да

    Наименование элемента

    Тип данных

    Описание

    Обязательное

    cashierQuestion

    Комплексный

    Список ответов

    Да

     

    tab_number

    String

    Табельный номер кассира

    Да

    question

    String

    Код вопроса кассиру

    (1=вопрос о длине очереди в кассе)

    Да

    answer

    String

    Ответ кассира на заданный вопрос 

    (для вопроса о длине очереди: null, 0,...,9)

    Да

    date

    String

    Дата-время проведения опроса

    Да

    XSD
    <?xml version="1.0" encoding="utf-8"?> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:wmh="http://www.wmhelp.com/2003/eGenerator" elementFormDefault="qualified"> <xs:element name="root"> <xs:complexType> <xs:sequence> <xs:element ref="messages"/> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="messages"> <xs:complexType> <xs:sequence> <xs:element ref="cashierQuestion" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="cash_number" type="xs:string" use="required"/> <xs:attribute name="shop_number" type="xs:string" use="required"/> </xs:complexType> </xs:element> <xs:element name="cashierQuestion"> <xs:complexType> <xs:attribute name="answer" type="xs:string" use="required"/> <xs:attribute name="date" type="xs:string" use="required"/> <xs:attribute name="question" type="xs:string" use="required"/> <xs:attribute name="tab_number" type="xs:string" use="required"/> </xs:complexType> </xs:element> </xs:schema>
    Пример XML:
    <?xml version="1.0" encoding="windows-1251"?> <root> <messages cash_number="32" shop_number="8176"> <cashierQuestion answer="0" date="2017-10-09T16:32:07.123" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T16:33:37.853" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T17:17:43.418" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T17:33:48.763" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T16:31:03.816" question="1" tab_number="2"/> <cashierQuestion answer="1" date="2017-10-09T16:19:51.847" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T16:39:37.943" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T17:20:43.565" question="1" tab_number="2"/> <cashierQuestion answer="3" date="2017-10-09T16:26:33.102" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T17:32:18.753" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T16:28:03.778" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T16:53:18.965" question="1" tab_number="2"/> <cashierQuestion answer="7" date="2017-10-09T16:43:41.800" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T17:30:48.706" question="1" tab_number="2"/> <cashierQuestion answer="7" date="2017-10-09T17:13:12.748" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T16:51:48.938" question="1" tab_number="2"/> <cashierQuestion answer="4" date="2017-10-09T16:25:21.604" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T16:47:19.721" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T16:54:48.993" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T17:23:43.614" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T17:22:13.589" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T16:38:07.919" question="1" tab_number="2"/> <cashierQuestion answer="4" date="2017-10-09T17:06:52.192" question="1" tab_number="2"/> <cashierQuestion answer="4" date="2017-10-09T16:45:48.887" question="1" tab_number="2"/> <cashierQuestion answer="1" date="2017-10-09T16:44:44.919" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T16:36:37.904" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T17:29:18.721" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T16:35:07.874" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T17:25:13.640" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T16:48:49.749" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T16:50:18.919" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T16:57:49.044" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T17:19:13.492" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T17:11:06.299" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T17:14:43.350" question="1" tab_number="2"/> <cashierQuestion answer="7" date="2017-10-09T16:21:00.324" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T16:56:19.019" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T17:27:48.685" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T16:42:38.632" question="1" tab_number="2"/> <cashierQuestion answer="3" date="2017-10-09T17:08:05.431" question="1" tab_number="2"/> <cashierQuestion answer="4" date="2017-10-09T17:12:08.810" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T17:16:13.382" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T17:09:36.271" question="1" tab_number="2"/> <cashierQuestion answer="8" date="2017-10-09T17:26:17.719" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T16:29:33.802" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T16:41:08.603" question="1" tab_number="2"/> <cashierQuestion answer="9" date="2017-10-09T16:24:18.364" question="1" tab_number="2"/> <cashierQuestion answer="null" date="2017-10-09T17:35:18.796" question="1" tab_number="2"/> </messages> </root>