daily pastebin goal
69%
SHARE
TWEET

Untitled

a guest Dec 1st, 2015 76 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Контрагент: МХТ им. Чехова
  2.  
  3. Проверьте, пожалуйста, заказ № 1511-0010534 (SB16279) от 09.11.2015 г.
  4. В Профтикете заказ сформирован частично - 1 билет на сумму 1200 руб. -
  5. Партер, 10 ряд, 22 место.
  6. а в в нашей системе - 2 билета на сумму 1500 руб. - Партер, 10 ряд, 22
  7. место; Партер откидные А, 10 ряд, 0 место
  8.  
  9. Прошу разобраться в причинах этой проблемы.
  10.  
  11. Спасибо!
  12.  
  13. --
  14. С уважением,
  15. Вислобок Мария
  16. Bigbilet.ru
  17. Тел: 8 (495) 644-12-48
  18. Моб.: 8-916-908-69-49
  19.  
  20. select * from v$sales s
  21. where s.id_sale='1511-0010534'
  22. Голубева        Елена      Борисовна      M       1064977 79031344640
  23.  
  24.  
  25. select * from sales_params s
  26. where s.id_sale='1511-0010534'
  27. SB_REFUND       26.11.2015 18:20:00     OK
  28. SB_RESERVEID    09.11.2015 15:40:56     16279
  29. SB_SESSION      09.11.2015 15:40:56     1064977_20151109153844
  30. SOURCE  09.11.2015 15:40:56     billboard
  31.  
  32.  
  33. select * from sales_status_log s
  34. where s.id_sale='1511-0010534'
  35. 09.11.2015 15:41:29     W
  36. 09.11.2015 15:43:41     P
  37. 25.11.2015 16:01:56     R
  38.  
  39.  
  40. select pl.* from sales s, sales_items i, wrh_tickets ti, pos_sections_places pl
  41. where s.id_sale='1511-0010534'
  42. and s.id_sale = i.id_sale
  43. and i.id_ticket = ti.id_ticket
  44. and ti.id_place = pl.id
  45. NUM_ROW NUM_PLACE
  46. 10      22
  47. 10      0
  48.  
  49. select * from sb_tickets where id_ticket in (
  50. '241827C9BB713DB3E0504B5E01F54712',
  51. '241827C9F1B03DB3E0504B5E01F54712'
  52. )
  53. NUM_ROW NUM_PLACE
  54. 10      22 1200.000000
  55. 10      А 300.000000
  56.  
  57. sale.log
  58. INFO : 09.11.2015 15:40:20.517 SUPERBILET ==> PreSetReservation: <soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:STicketIntf-IProfTicket"><soapenv:Header/><soapenv:Body><urn:PreSetReservation soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"><strInp xsi:type="xsd:string">&lt;GateReq&gt;&lt;ReqBody&gt;&lt;InputRow NomBilKn="253" row="10" seat="А" cod_sec="186" session="1064977_20151109153844"/&gt;&lt;/ReqBody&gt;&lt;ReqLogin&gt;&lt;UserName&gt;GateProf&lt;/UserName&gt;&lt;UserPass&gt;G@teMXT1659&lt;/UserPass&gt;&lt;/ReqLogin&gt;&lt;/GateReq&gt;</strInp></urn:PreSetReservation></soapenv:Body></soapenv:Envelope> - ru.airlabs.superbilet.service.APISuperBiletService.preSetReservation(APISuperBiletService.java:290)
  59. INFO : 09.11.2015 15:40:20.965 SUPERBILET <== PreSetReservation: <?xml version="1.0"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"><SOAP-ENV:Body SOAP-ENC:encodingStyle="http://schemas.xmlsoap.org/soap/envelope/"><NS1:PreSetReservationResponse xmlns:NS1="urn:STicketIntf-IProfTicket"><return xsi:type="xsd:string">&lt;GateAnswer&gt;&lt;AnswerResult&gt;&lt;ResultCode&gt;0&lt;/ResultCode&gt;&lt;RecordCount&gt;1&lt;/RecordCount&gt;&lt;/AnswerResult&gt;&lt;AnswerBody&gt;&lt;Row NomBilKn="253" cod_sec="186" name_sec="Партер" row="10" seat="А" price="300.0000" priceSell="300.0000" session="1064977_20151109153844" TTL="1200" result_code="0" result_message="OK"/&gt;&lt;/AnswerBody&gt;&lt;/GateAnswer&gt;</return></NS1:PreSetReservationResponse></SOAP-ENV:Body></SOAP-ENV:Envelope> - ru.airlabs.superbilet.service.APISuperBiletService.preSetReservation(APISuperBiletService.java:293)
  60.  
  61. INFO : 09.11.2015 15:40:30.762 SUPERBILET ==> PreSetReservation: <soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:STicketIntf-IProfTicket"><soapenv:Header/><soapenv:Body><urn:PreSetReservation soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"><strInp xsi:type="xsd:string">&lt;GateReq&gt;&lt;ReqBody&gt;&lt;InputRow NomBilKn="253" row="10" seat="22" cod_sec="186" session="1064977_20151109153844"/&gt;&lt;/ReqBody&gt;&lt;ReqLogin&gt;&lt;UserName&gt;GateProf&lt;/UserName&gt;&lt;UserPass&gt;G@teMXT1659&lt;/UserPass&gt;&lt;/ReqLogin&gt;&lt;/GateReq&gt;</strInp></urn:PreSetReservation></soapenv:Body></soapenv:Envelope> - ru.airlabs.superbilet.service.APISuperBiletService.preSetReservation(APISuperBiletService.java:290)
  62. INFO : 09.11.2015 15:40:31.223 SUPERBILET <== PreSetReservation: <?xml version="1.0"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"><SOAP-ENV:Body SOAP-ENC:encodingStyle="http://schemas.xmlsoap.org/soap/envelope/"><NS1:PreSetReservationResponse xmlns:NS1="urn:STicketIntf-IProfTicket"><return xsi:type="xsd:string">&lt;GateAnswer&gt;&lt;AnswerResult&gt;&lt;ResultCode&gt;0&lt;/ResultCode&gt;&lt;RecordCount&gt;1&lt;/RecordCount&gt;&lt;/AnswerResult&gt;&lt;AnswerBody&gt;&lt;Row NomBilKn="253" cod_sec="186" name_sec="Партер" row="10" seat="22" price="1200.0000" priceSell="1200.0000" session="1064977_20151109153844" TTL="1200" result_code="0" result_message="OK"/&gt;&lt;/AnswerBody&gt;&lt;/GateAnswer&gt;</return></NS1:PreSetReservationResponse></SOAP-ENV:Body></SOAP-ENV:Envelope> - ru.airlabs.superbilet.service.APISuperBiletService.preSetReservation(APISuperBiletService.java:293)
  63.  
  64. INFO : 09.11.2015 15:40:55.568 SUPERBILET ==> setReservationExt: <soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:STicketIntf-IProfTicket"><soapenv:Header/><soapenv:Body><urn:SetReservation soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"><strInp xsi:type="xsd:string">&lt;GateReq&gt;&lt;ReqBody&gt;&lt;InputRow EmailSpektator="sales@bigbilet.ru" NomBilKn="253" NameSpektator="Голубева Елена Борисовна" price="300.0000" row="10" seat="А" cod_sec="186" session="1064977_20151109153844" TelSpektator="79031344640"/&gt;&lt;InputRow EmailSpektator="sales@bigbilet.ru" NomBilKn="253" NameSpektator="Голубева Елена Борисовна" price="1200.0000" row="10" seat="22" cod_sec="186" session="1064977_20151109153844" TelSpektator="79031344640"/&gt;&lt;/ReqBody&gt;&lt;ReqLogin&gt;&lt;UserName&gt;GateProf&lt;/UserName&gt;&lt;UserPass&gt;G@teMXT1659&lt;/UserPass&gt;&lt;/ReqLogin&gt;&lt;/GateReq&gt;</strInp></urn:SetReservation></soapenv:Body></soapenv:Envelope> - ru.airlabs.superbilet.service.APISuperBiletService.setReservationExt(APISuperBiletService.java:436)
  65. INFO : 09.11.2015 15:40:55.998 SUPERBILET <== setReservationExt: <?xml version="1.0"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"><SOAP-ENV:Body SOAP-ENC:encodingStyle="http://schemas.xmlsoap.org/soap/envelope/"><NS1:SetReservationResponse xmlns:NS1="urn:STicketIntf-IProfTicket"><return xsi:type="xsd:string">&lt;GateAnswer&gt;&lt;AnswerResult&gt;&lt;ResultCode&gt;0&lt;/ResultCode&gt;&lt;RecordCount&gt;2&lt;/RecordCount&gt;&lt;/AnswerResult&gt;&lt;AnswerBody&gt;&lt;Row NomBilKn="253" cod_sec="186" name_sec="Партер" row="10" seat="22" price="1200.00" priceSell="1200.00" IDSpectator="12390" NameSpektator="Голубева Елена Борисовна" TelSpektator="79031344640" EmailSpektator="sales@bigbilet.ru" session="1064977_20151109153844" ReservID="16279" Barcode="386960562102910834" BlockTTL="3600" ReservDate="11.11.2015" ReservTime="15:40:56" result_code="0" result_message="OK"/&gt;&lt;Row NomBilKn="253" cod_sec="186" name_sec="Партер" row="10" seat="А" price="300.00" priceSell="300.00" IDSpectator="12390" NameSpektator="Голубева Елена Борисовна" TelSpektator="79031344640" EmailSpektator="sales@bigbilet.ru" session="1064977_20151109153844" ReservID="16279" Barcode="205342638086732737" BlockTTL="3600" ReservDate="11.11.2015" ReservTime="15:40:56" result_code="0" result_message="OK"/&gt;&lt;/AnswerBody&gt;&lt;/GateAnswer&gt;</return></NS1:SetReservationResponse></SOAP-ENV:Body></SOAP-ENV:Envelope> - ru.airlabs.superbilet.service.APISuperBiletService.setReservationExt(APISuperBiletService.java:439)
  66. INFO : 09.11.2015 15:40:56.032 SUPERBILET ==> CheckSoldTickets: <soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:STicketIntf-IProfTicket"><soapenv:Header/><soapenv:Body><urn:CheckSoldTickets soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"><strInp xsi:type="xsd:string">&lt;GateReq&gt;&lt;ReqBody&gt;&lt;InputRow NomBilKn="253" price="300.00" ReservID="16279" row="10" seat="А" cod_sec="186" session="1064977_20151109153844"/&gt;&lt;InputRow NomBilKn="253" price="1200.00" ReservID="16279" row="10" seat="22" cod_sec="186" session="1064977_20151109153844"/&gt;&lt;/ReqBody&gt;&lt;ReqLogin&gt;&lt;UserName&gt;GateProf&lt;/UserName&gt;&lt;UserPass&gt;G@teMXT1659&lt;/UserPass&gt;&lt;/ReqLogin&gt;&lt;/GateReq&gt;</strInp></urn:CheckSoldTickets></soapenv:Body></soapenv:Envelope> - ru.airlabs.superbilet.service.APISuperBiletService.checkSoldTickets(APISuperBiletService.java:586)
  67. INFO : 09.11.2015 15:40:56.308 SUPERBILET <== CheckSoldTickets: <?xml version="1.0"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"><SOAP-ENV:Body SOAP-ENC:encodingStyle="http://schemas.xmlsoap.org/soap/envelope/"><NS1:CheckSoldTicketsResponse xmlns:NS1="urn:STicketIntf-IProfTicket"><return xsi:type="xsd:string">&lt;GateAnswer&gt;&lt;AnswerResult&gt;&lt;ResultCode&gt;0&lt;/ResultCode&gt;&lt;RecordCount&gt;2&lt;/RecordCount&gt;&lt;/AnswerResult&gt;&lt;AnswerBody&gt;&lt;Row NomBilKn="253" cod_sec="186" name_sec="Партер" row="10" seat="22" price="1200.0000" PriceSell="1200.0000" PriceDiscount="1200.0000" session="1064977_20151109153844" ReservID="16279" blocked="1" result_code="0" result_message="OK"/&gt;&lt;Row NomBilKn="253" cod_sec="186" name_sec="Партер" row="10" seat="А" price="300.0000" PriceSell="300.0000" PriceDiscount="300.0000" session="1064977_20151109153844" ReservID="16279" blocked="1" result_code="0" result_message="OK"/&gt;&lt;/AnswerBody&gt;&lt;/GateAnswer&gt;</return></NS1:CheckSoldTicketsResponse></SOAP-ENV:Body></SOAP-ENV:Envelope> - ru.airlabs.superbilet.service.APISuperBiletService.checkSoldTickets(APISuperBiletService.java:589)
  68.  
  69. pay-job.log
  70. INFO : 09.11.2015 15:44:01.062 SUPERBILET ==> SetSoldTickets: <soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:STicketIntf-IProfTicket"><soapenv:Header/><soapenv:Body><urn:SetSold soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"><strInp xsi:type="xsd:string">&lt;GateReq&gt;&lt;ReqBody&gt;&lt;InputRow NomBilKn="253" PaymentDate="09.11.2015" PaymentTime="15:43:37" price="1200.00" ReservID="16279" row="10" seat="22" cod_sec="186" session="1064977_20151109153844" TransactionID="531374470028"/&gt;&lt;/ReqBody&gt;&lt;ReqLogin&gt;&lt;UserName&gt;GateProf&lt;/UserName&gt;&lt;UserPass&gt;G@teMXT1659&lt;/UserPass&gt;&lt;/ReqLogin&gt;&lt;/GateReq&gt;</strInp></urn:SetSold></soapenv:Body></soapenv:Envelope>
  71. INFO : 09.11.2015 15:44:01.390 SUPERBILET <== SetSoldTickets: <?xml version="1.0"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"><SOAP-ENV:Body SOAP-ENC:encodingStyle="http://schemas.xmlsoap.org/soap/envelope/"><NS1:SetSoldResponse xmlns:NS1="urn:STicketIntf-IProfTicket"><return xsi:type="xsd:string">&lt;GateAnswer&gt;&lt;AnswerResult&gt;&lt;ResultCode&gt;0&lt;/ResultCode&gt;&lt;RecordCount&gt;1&lt;/RecordCount&gt;&lt;/AnswerResult&gt;&lt;AnswerBody&gt;&lt;Row NomBilKn="253" cod_sec="186" name_sec="Партер" row="10" seat="22" price="1200.00" PriceSell="1200.00" session="1064977_20151109153844" barcode="386960562102910834" BarCodeType="bcCode_2_5_interleaved" ReservID="16279" ReservDate="09.11.2015" PaymentDate="09.11.2015" PaymentTime="15:43:37" TransactionID="531374470028" result_code="0" result_message="OK"/&gt;&lt;/AnswerBody&gt;&lt;/GateAnswer&gt;</return></NS1:SetSoldResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>
RAW Paste Data
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
 
Top