API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 21st, 2016
90
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.52 KB | None | 0 0
raw download clone embed print report
  1. <data name="netrikayulia" serviceNamespace="http://www.w3.org/2001/XMLSchema-instance" transports="http https">
  2. <description>netrikayulia</description>
  3. <config id="lsd">
  4. <property name="driverClassName">org.postgresql.Driver</property>
  5. <property name="url">jdbc:postgresql://127.0.0.1:65312/lsd_bur</property>
  6. <property name="username">jenkins</property>
  7. <property name="password">Rm5dplM8W11@</property>
  8. <property name="defaultTransactionIsolation">TRANSACTION_READ_COMMITTED</property>
  9. <property name="initialSize">5</property>
  10. <property name="testOnReturn">true</property>
  11. <property name="removeAbandoned">true</property>
  12. <property name="logAbandoned">true</property>
  13. <property name="autoCommit">true</property>
  14. <property name="defaultReadOnly">true</property>
  15. </config>
  16. <query id="getdoctorlist" useConfig="lsd">
  17. <sql>select ? as IdHistory, true as Success, * from public.getdoctorlist(?::text, ?::integer,?::text)</sql>
  18. <result defaultNamespace="http://tempuri.org/" element="GetDoctorListResponse ">
  19. <element column="IdHistory" exportType="SCALAR" name="IdHistory" xsdType="xs:string"/>
  20. <element column="Success" exportType="SCALAR" name="Success" xsdType="xs:string"/>
  21. <element isComplexType="true" name="ErrorList"> </element>
  22. <element isComplexType="true" name="Docs">
  23. <element isComplexType="true" name="Doctor">
  24. <element column="CountFreeParticipantIE" exportType="SCALAR" name="CountFreeParticipantIE" xsdType="xs:string"/>
  25. <element column="CountFreeTicket" exportType="SCALAR" name="CountFreeTicket" xsdType="xs:string"/>
  26. <element column="IdDoc" exportType="SCALAR" name="IdDoc" xsdType="xs:string"/>
  27. <element column="LastDate" exportType="SCALAR" name="LastDate" xsdType="xs:string"/>
  28. <element column="Name" exportType="SCALAR" name="Name" xsdType="xs:string"/>
  29. <element column="NearestDate" exportType="SCALAR" name="NearestDate" xsdType="xs:string"/>
  30. <element column="Snils" exportType="SCALAR" name="Snils" xsdType="xs:string"/>
  31. </element>
  32. </element>
  33. </result>
  34. <param defaultValue="#{NULL}" name="IdHistory" paramType="SCALAR" sqlType="INTEGER" type="IN"/>
  35. <param defaultValue="#{NULL}" name="idSpesiality" paramType="SCALAR" sqlType="STRING" type="IN"/>
  36. <param defaultValue="#{NULL}" name="idLpu" paramType="SCALAR" sqlType="STRING" type="IN"/>
  37. <param defaultValue="#{NULL}" name="idPat" paramType="SCALAR" sqlType="STRING" type="IN"/>
  38. </query>
  39. <operation name="getdoctorlist">
  40. <call-query href="getdoctorlist">
  41. <with-param column="idSpesiality" name="idSpesiality"/>
  42. <with-param column="idLpu" name="idLpu"/>
  43. <with-param column="idPat" name="idPat"/>
  44. </call-query>
  45. </operation>
  46. <query id="searchtop10patient" useConfig="lsd">
  47. <sql>select ? as IdHistory, true as Success, * from public.searchtop10patient(?::integer, ?::date, ?::text,?::text, ?::text,?::text, ?::text,?::text, ?::text,?::text, ?::text,?::text)</sql>
  48. <result defaultNamespace="http://tempuri.org/" element="searchtop10patientResponse ">
  49. <element column="IdHistory" exportType="SCALAR" name="IdHistory" xsdType="xs:string"/>
  50. <element column="Success" exportType="SCALAR" name="Success" xsdType="xs:string"/>
  51. <element isComplexType="true" name="ErrorList"> </element>
  52. <element isComplexType="true" name="Docs">
  53. <element isComplexType="true" name="Doctor">
  54. <element column="AriaNumber" exportType="SCALAR" name="AriaNumber" xsdType="xs:string"/>
  55. <element column="Birthday" exportType="SCALAR" name="Birthday" xsdType="xs:dateTime"/>
  56. <element column="CellPhone" exportType="SCALAR" name="CellPhone" xsdType="xs:string"/>
  57. <element column="Document_N" exportType="SCALAR" name="Document_N" xsdType="xs:string"/>
  58. <element column="Document_S" exportType="SCALAR" name="Document_S" xsdType="xs:string"/>
  59. <element column="HomePhone" exportType="SCALAR" name="HomePhone" xsdType="xs:string"/>
  60. <element column="IdPat" exportType="SCALAR" name="IdPat" xsdType="xs:string"/>
  61. <element column="Name" exportType="SCALAR" name="Name" xsdType="xs:string"/>
  62. <element column="Polis_N" exportType="SCALAR" name="Polis_N" xsdType="xs:string"/>
  63. <element column="Polis_S" exportType="SCALAR" name="Polis_S" xsdType="xs:string"/>
  64. <element column="SecondName" exportType="SCALAR" name="SecondName" xsdType="xs:string"/>
  65. <element column="Surname" exportType="SCALAR" name="Surname" xsdType="xs:string"/>
  66. </element>
  67. </element>
  68. </result>
  69. <param defaultValue="#{NULL}" name="IdHistory" paramType="SCALAR" sqlType="INTEGER" type="IN"/>
  70. <param defaultValue="#{NULL}" name="idlpu" paramType="SCALAR" sqlType="DATE" type="IN"/>
  71. <param defaultValue="#{NULL}" name="p_bithday" paramType="SCALAR" sqlType="STRING" type="IN"/>
  72. <param defaultValue="#{NULL}" name="p_cellphone" paramType="SCALAR" sqlType="STRING" type="IN"/>
  73. <param defaultValue="#{NULL}" name="p_document_n" paramType="SCALAR" sqlType="STRING" type="IN"/>
  74. <param defaultValue="#{NULL}" name="p_document_s" paramType="SCALAR" sqlType="STRING" type="IN"/>
  75. <param defaultValue="#{NULL}" name="p_homephone" paramType="SCALAR" sqlType="STRING" type="IN"/>
  76. <param defaultValue="#{NULL}" name="p_idpat" paramType="SCALAR" sqlType="STRING" type="IN"/>
  77. <param defaultValue="#{NULL}" name="p_name" paramType="SCALAR" sqlType="STRING" type="IN"/>
  78. <param defaultValue="#{NULL}" name="p_polis_n" paramType="SCALAR" sqlType="STRING" type="IN"/>
  79. <param defaultValue="#{NULL}" name="p_polis_s" paramType="SCALAR" sqlType="STRING" type="IN"/>
  80. <param defaultValue="#{NULL}" name="p_secondname" paramType="SCALAR" sqlType="STRING" type="IN"/>
  81. <param defaultValue="#{NULL}" name="p_surname" paramType="SCALAR" sqlType="STRING" type="IN"/>
  82. </query>
  83. <operation name="searchtop10patient">
  84. <call-query href="searchtop10patient">
  85. <with-param column="idlpu" name="idlpu"/>
  86. <with-param column="p_bithday" name="p_bithday"/>
  87. <with-param column="p_cellphone" name="p_cellphone"/>
  88. <with-param column="p_document_n" name="p_document_n"/>
  89. <with-param column="p_document_s" name="p_document_s"/>
  90. <with-param column="p_homephone" name="p_homephone"/>
  91. <with-param column="p_idpat" name="p_idpat"/>
  92. <with-param column="p_name" name="p_name"/>
  93. <with-param column="p_polis_n" name="p_polis_n"/>
  94. <with-param column="p_polis_s" name="p_polis_s"/>
  95. <with-param column="p_secondname" name="p_secondname"/>
  96. <with-param column="p_surname" name="p_surname"/>
  97. </call-query>
  98. </operation>
  99. <query id="get_spesiality_list" useConfig="lsd">
  100. <sql>select ? as _idLpu, ? as _idPat, ? as guid, 0 as IdHistory, true as Success</sql>
  101. <result element="GetSpesialityListResponse">
  102. <!--
  103. <result defaultNamespace="http://tempuri.org/" element="GetSpesialityListResponse"> :-->
  104. <element isComplexType="true" name="GetSpesialityListResult" namespace="">
  105. <!--
  106. <element isComplexType="true" name="GetSpesialityListResult" namespace="http://schemas.datacontract.org/2004/07/HubService2"> :-->
  107. <element name="ErrorList"/>
  108. <element column="IdHistory" exportType="SCALAR" name="IdHistory" xsdType="xs:integer"/>
  109. <element column="Success" exportType="SCALAR" name="Success" xsdType="xs:boolean"/>
  110. <call-query href="ListSpesiality">
  111. <with-param column="_idLpu" name="_idLpu"/>
  112. <with-param column="_idPat" name="_idPat"/>
  113. </call-query>
  114. </element>
  115. </result>
  116. <param defaultValue="#{NULL}" name="idLpu" paramType="SCALAR" sqlType="STRING" type="IN"/>
  117. <param defaultValue="#{NULL}" name="idPat" paramType="SCALAR" sqlType="STRING" type="IN"/>
  118. <param defaultValue="#{NULL}" name="guid" paramType="SCALAR" sqlType="STRING" type="IN"/>
  119. <param defaultValue="#{NULL}" name="IdHistory" paramType="SCALAR" sqlType="STRING" type="IN"/>
  120. </query>
  121. <query id="ListSpesiality" useConfig="lsd">
  122. <sql>select countfreeparticipantie, countfreeticket, feridspesiality, idspesiality, substring (lastdate, 1, 10)||'T'|| substring (lastdate, 12) as LastDate, namespesiality, substring (nearestdate, 1, 10)||'T'|| substring (nearestdate, 12) as nearestdate from public.get_spesiality_list1(:_idLpu::integer, :_idPat::text)</sql>
  123. <result defaultNamespace="http://schemas.datacontract.org/2004/07/HubService2" element="ListSpesiality">
  124. <element isComplexType="true" name="Spesiality">
  125. <element column="CountFreeParticipantIE" exportType="SCALAR" name="CountFreeParticipantIE" xsdType="xs:integer"/>
  126. <element column="CountFreeTicket" exportType="SCALAR" name="CountFreeTicket" xsdType="xs:integer"/>
  127. <element column="FerIdSpesiality" exportType="SCALAR" name="FerIdSpesiality" xsdType="xs:string"/>
  128. <element column="IdSpesiality" exportType="SCALAR" name="IdSpesiality" xsdType="xs:string"/>
  129. <element column="LastDate" exportType="SCALAR" name="LastDate" xsdType="xs:dateTime"/>
  130. <element column="NameSpesiality" exportType="SCALAR" name="NameSpesiality" xsdType="xs:string"/>
  131. <element column="NearestDate" exportType="SCALAR" name="NearestDate" xsdType="xs:dateTime"/>
  132. </element>
  133. </result>
  134. <param name="_idLpu" sqlType="STRING"/>
  135. <param name="_idPat" sqlType="STRING"/>
  136. </query>
  137. <operation name="GetSpesialityList">
  138. <call-query href="get_spesiality_list">
  139. <with-param column="idLpu" name="idLpu"/>
  140. <with-param column="idPat" name="idPat"/>
  141. <with-param column="guid" name="guid"/>
  142. <with-param column="IdHistory" name="IdHistory"/>
  143. </call-query>
  144. </operation>
  145. <query id="GetAvailableDates" useConfig="lsd">
  146. <sql>select ? as _idLpu, ? as _idPat, ? as guid, 0 as IdHistory, true as Success</sql>
  147. <result defaultNamespace="http://tempuri.org/" element="GetAvailableDatesResponse">
  148. <element isComplexType="true" name="GetAvailableDatesResult" namespace="">
  149. <element name="ErrorList"/>
  150. <element column="IdHistory" exportType="SCALAR" name="IdHistory" xsdType="xs:string"/>
  151. <element column="Success" exportType="SCALAR" name="Success" xsdType="xs:string"/>
  152. <element isComplexType="true" name="AvailableDateList">
  153. <element column="getavailabledates" exportType="SCALAR" name="dateTime" xsdType="xs:string"/>
  154. </element>
  155. </element>
  156. </result>
  157. <param defaultValue="#{NULL}" name="_employee_id" paramType="SCALAR" sqlType="STRING" type="IN"/>
  158. <param defaultValue="#{NULL}" name="_bdate" paramType="SCALAR" sqlType="DATE" type="IN"/>
  159. <param defaultValue="#{NULL}" name="_edate" paramType="SCALAR" sqlType="DATE" type="IN"/>
  160. <param defaultValue="#{NULL}" name="IdHistory" paramType="SCALAR" sqlType="STRING" type="IN"/>
  161. </query>
  162. <query id="GetAvailableDates" useConfig="lsd">
  163. <sql>select true as Success, *, ? as IdHistory from public.getavailabledates( ?::integer,?::date,?::date)</sql>
  164. <result defaultNamespace="http://tempuri.org/" element="GetAvailableDatesResponse">
  165. <element isComplexType="true" name="GetAvailableDatesResult" namespace="">
  166. <element name="ErrorList"/>
  167. <element column="Success" exportType="SCALAR" name="Success" xsdType="xs:string"/>
  168. <element isComplexType="true" name="AvailableDateList">
  169. <element column="getavailabledates" exportType="SCALAR" name="dateTime" xsdType="xs:string"/>
  170. </element>
  171. <element column="IdHistory" exportType="SCALAR" name="IdHistory" xsdType="xs:string"/>
  172. </element>
  173. </result>
  174. <param defaultValue="#{NULL}" name="_employee_id" paramType="SCALAR" sqlType="STRING" type="IN"/>
  175. <param defaultValue="#{NULL}" name="_bdate" paramType="SCALAR" sqlType="DATE" type="IN"/>
  176. <param defaultValue="#{NULL}" name="_edate" paramType="SCALAR" sqlType="DATE" type="IN"/>
  177. <param defaultValue="#{NULL}" name="IdHistory" paramType="SCALAR" sqlType="STRING" type="IN"/>
  178. </query>
  179. <operation name="GetAvailableDates">
  180. <call-query href="GetAvailableDates">
  181. <with-param column="IdHistory" name="IdHistory"/>
  182. <with-param column="idDoc" name="_employee_id"/>
  183. <with-param column="visitStart" name="_bdate"/>
  184. <with-param column="visitEnd" name="_edate"/>
  185. </call-query>
  186. </operation>
  187. <query id="get_avaible_appointments" useConfig="lsd">
  188. <sql>select ? as IdHistory, true as Success, * from public.get_avaible_appointments( ?::integer,?::integer,?::date,?::date)</sql>
  189. <result defaultNamespace="http://tempuri.org/" element="get_avaible_appointmentsResponse ">
  190. <element column="IdHistory" exportType="SCALAR" name="IdHistory" xsdType="xs:string"/>
  191. <element column="Success" exportType="SCALAR" name="Success" xsdType="xs:boolean"/>
  192. <element isComplexType="true" name="ErrorList"> </element>
  193. <element isComplexType="true" name="Docs">
  194. <element isComplexType="true" name="Doctor">
  195. <element column="bdatetime" exportType="SCALAR" name="bdatetime" xsdType="xs:dateTime"/>
  196. <element column="edatetime" exportType="SCALAR" name="edatetime" xsdType="xs:dateTime"/>
  197. </element>
  198. </element>
  199.  
  200. </result>
  201. <param defaultValue="#{NULL}" name="IdHistory" paramType="SCALAR" sqlType="STRING" type="IN"/>
  202. <param defaultValue="#{NULL}" name="_employee_id" paramType="SCALAR" sqlType="STRING" type="IN"/>
  203. <param defaultValue="#{NULL}" name="_individual_id" paramType="SCALAR" sqlType="STRING" type="IN"/>
  204. <param defaultValue="#{NULL}" name="_bdate" paramType="SCALAR" sqlType="STRING" type="IN"/>
  205. <param defaultValue="#{NULL}" name="_edate" paramType="SCALAR" sqlType="STRING" type="IN"/>
  206. </query>
  207. <operation name="get_avaible_appointments">
  208. <call-query href="get_avaible_appointments">
  209. <with-param column="_employee_id" name="_employee_id"/>
  210. <with-param column="_individual_id" name="_individual_id"/>
  211. <with-param column="_bdate" name="_bdate"/>
  212. <with-param column="_edate" name="_edate"/>
  213. <with-param column="IdHistory" name="IdHistory"/>
  214. </call-query>
  215. </operation>
  216. </data>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!