Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Контрагент: МХТ им. Чехова
- Проверьте, пожалуйста, заказ № 1511-0010534 (SB16279) от 09.11.2015 г.
- В Профтикете заказ сформирован частично - 1 билет на сумму 1200 руб. -
- Партер, 10 ряд, 22 место.
- а в в нашей системе - 2 билета на сумму 1500 руб. - Партер, 10 ряд, 22
- место; Партер откидные А, 10 ряд, 0 место
- Прошу разобраться в причинах этой проблемы.
- Спасибо!
- --
- С уважением,
- Вислобок Мария
- Bigbilet.ru
- Тел: 8 (495) 644-12-48
- Моб.: 8-916-908-69-49
- select * from v$sales s
- where s.id_sale='1511-0010534'
- Голубева Елена Борисовна M 1064977 79031344640
- select * from sales_params s
- where s.id_sale='1511-0010534'
- SB_REFUND 26.11.2015 18:20:00 OK
- SB_RESERVEID 09.11.2015 15:40:56 16279
- SB_SESSION 09.11.2015 15:40:56 1064977_20151109153844
- SOURCE 09.11.2015 15:40:56 billboard
- select * from sales_status_log s
- where s.id_sale='1511-0010534'
- 09.11.2015 15:41:29 W
- 09.11.2015 15:43:41 P
- 25.11.2015 16:01:56 R
- select pl.* from sales s, sales_items i, wrh_tickets ti, pos_sections_places pl
- where s.id_sale='1511-0010534'
- and s.id_sale = i.id_sale
- and i.id_ticket = ti.id_ticket
- and ti.id_place = pl.id
- NUM_ROW NUM_PLACE
- 10 22
- 10 0
- select * from sb_tickets where id_ticket in (
- '241827C9BB713DB3E0504B5E01F54712',
- '241827C9F1B03DB3E0504B5E01F54712'
- )
- NUM_ROW NUM_PLACE
- 10 22 1200.000000
- 10 А 300.000000
- sale.log
- 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"><GateReq><ReqBody><InputRow NomBilKn="253" row="10" seat="А" cod_sec="186" session="1064977_20151109153844"/></ReqBody><ReqLogin><UserName>GateProf</UserName><UserPass>G@teMXT1659</UserPass></ReqLogin></GateReq></strInp></urn:PreSetReservation></soapenv:Body></soapenv:Envelope> - ru.airlabs.superbilet.service.APISuperBiletService.preSetReservation(APISuperBiletService.java:290)
- 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"><GateAnswer><AnswerResult><ResultCode>0</ResultCode><RecordCount>1</RecordCount></AnswerResult><AnswerBody><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"/></AnswerBody></GateAnswer></return></NS1:PreSetReservationResponse></SOAP-ENV:Body></SOAP-ENV:Envelope> - ru.airlabs.superbilet.service.APISuperBiletService.preSetReservation(APISuperBiletService.java:293)
- 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"><GateReq><ReqBody><InputRow NomBilKn="253" row="10" seat="22" cod_sec="186" session="1064977_20151109153844"/></ReqBody><ReqLogin><UserName>GateProf</UserName><UserPass>G@teMXT1659</UserPass></ReqLogin></GateReq></strInp></urn:PreSetReservation></soapenv:Body></soapenv:Envelope> - ru.airlabs.superbilet.service.APISuperBiletService.preSetReservation(APISuperBiletService.java:290)
- 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"><GateAnswer><AnswerResult><ResultCode>0</ResultCode><RecordCount>1</RecordCount></AnswerResult><AnswerBody><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"/></AnswerBody></GateAnswer></return></NS1:PreSetReservationResponse></SOAP-ENV:Body></SOAP-ENV:Envelope> - ru.airlabs.superbilet.service.APISuperBiletService.preSetReservation(APISuperBiletService.java:293)
- 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"><GateReq><ReqBody><InputRow EmailSpektator="sales@bigbilet.ru" NomBilKn="253" NameSpektator="Голубева Елена Борисовна" price="300.0000" row="10" seat="А" cod_sec="186" session="1064977_20151109153844" TelSpektator="79031344640"/><InputRow EmailSpektator="sales@bigbilet.ru" NomBilKn="253" NameSpektator="Голубева Елена Борисовна" price="1200.0000" row="10" seat="22" cod_sec="186" session="1064977_20151109153844" TelSpektator="79031344640"/></ReqBody><ReqLogin><UserName>GateProf</UserName><UserPass>G@teMXT1659</UserPass></ReqLogin></GateReq></strInp></urn:SetReservation></soapenv:Body></soapenv:Envelope> - ru.airlabs.superbilet.service.APISuperBiletService.setReservationExt(APISuperBiletService.java:436)
- 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"><GateAnswer><AnswerResult><ResultCode>0</ResultCode><RecordCount>2</RecordCount></AnswerResult><AnswerBody><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"/><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"/></AnswerBody></GateAnswer></return></NS1:SetReservationResponse></SOAP-ENV:Body></SOAP-ENV:Envelope> - ru.airlabs.superbilet.service.APISuperBiletService.setReservationExt(APISuperBiletService.java:439)
- 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"><GateReq><ReqBody><InputRow NomBilKn="253" price="300.00" ReservID="16279" row="10" seat="А" cod_sec="186" session="1064977_20151109153844"/><InputRow NomBilKn="253" price="1200.00" ReservID="16279" row="10" seat="22" cod_sec="186" session="1064977_20151109153844"/></ReqBody><ReqLogin><UserName>GateProf</UserName><UserPass>G@teMXT1659</UserPass></ReqLogin></GateReq></strInp></urn:CheckSoldTickets></soapenv:Body></soapenv:Envelope> - ru.airlabs.superbilet.service.APISuperBiletService.checkSoldTickets(APISuperBiletService.java:586)
- 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"><GateAnswer><AnswerResult><ResultCode>0</ResultCode><RecordCount>2</RecordCount></AnswerResult><AnswerBody><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"/><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"/></AnswerBody></GateAnswer></return></NS1:CheckSoldTicketsResponse></SOAP-ENV:Body></SOAP-ENV:Envelope> - ru.airlabs.superbilet.service.APISuperBiletService.checkSoldTickets(APISuperBiletService.java:589)
- pay-job.log
- 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"><GateReq><ReqBody><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"/></ReqBody><ReqLogin><UserName>GateProf</UserName><UserPass>G@teMXT1659</UserPass></ReqLogin></GateReq></strInp></urn:SetSold></soapenv:Body></soapenv:Envelope>
- 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"><GateAnswer><AnswerResult><ResultCode>0</ResultCode><RecordCount>1</RecordCount></AnswerResult><AnswerBody><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"/></AnswerBody></GateAnswer></return></NS1:SetSoldResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
