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

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

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

SRTE-1148 - Получение подробных данных проблемы… СТАТУС

10.2.36.0

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

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

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

root/messages/cashierQuestion

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

Тип данных

Описание

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

cash_number

StringНомер кассыДа
shop_numberStringНомер магазинаДа
Наименование элементаТип данныхОписаниеОбязательное
cashierQuestionКомплексныйСписок ответовДа

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

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

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

Да
answerString

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

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

Да
dateStringДата-время проведения опросаДа
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>

© 1994-2021, ООО "Кристалл Сервис Интеграция".
Все права защищены.

Политика обработки персональных данных