Notes

NSERT INTO `odemeler`(`id`, `odeme_tip_id`, `bayi_id`, `bayi_yetkili_id`, `musteri_temsilci_id`, `uye_id`, `siparis_id`, `toplam_fiyat`, `indirim_orani`, `odenen_toplam`, `odenen_toplam_tl`, `doviz_id`, `doviz_fiyati`, `odeme_durum_id`, `kampanya_id`, `muhasebe_odeme_id`, `muhasebe_kayit_no`, `pos_id`, `durum_3d`, `banka_kart_id`, `taksit_sayisi`, `kk_oran`, `kk_oran_kat`, `kart_bin`, `kart_son_dort`, `kart_sahibi`, `kart_son_kullanma_tarihi`, `maliyet_orani`, `maliyet_kat`, `siparis_pos_id`, `pos_takip_id`, `pos_hatasi`, `pos_3d_durum`, `on_gonderilen_xml`, `on_gelen_xml`, `gonderilen_xml`, `gelen_xml`, `banka_hesap_id`, `eft_ad_soyad`, `banka_adi`, `sube_adi`, `hesap_sahibi`, `hesap_no`, `IBAN`, `paypal_guid`, `paypal_token`, `paypal_odeyici_id`, `paypal_email`, `paypal_adi`, `paypal_soyadi`, `paypal_hata`, `eklenme_tarihi`, `ekleyen_id`, `ekleyen_ip`, `duzenleme_tarihi`, `duzenleyen_id`, `duzenleyen_ip`, `kampanya_json`, `kampanya_icerik_json`, `usd_fiyati`, `euro_fiyati`, `email_durumu`, `odeme_indirimi`, `iptal_tutar`, `iptal_evrak_seri`, `iptal_evrak_no`, `iptal_mikro_id`) VALUES ('212426', '6', '13338', '5258', '0', '0', '0', '304.0560', '0.0000', '315.7384', '1250.9553', '2', '4.1142', '5', '0', '0', '0', '5', '0', '4', '6', '3.700000', '3.842160', '432072', '9704', 'C?HANG?R BAYRAMO?LU', '07-2022', '3.700000', '3.842160', 'ihv031803315abf6ce2bdd67', '', 'Manual onay icin bankayi arayiniz ', '0', '', '', '<?xml version="1.0" encoding="UTF-8"?>
<CC5Request>
<Name>web</Name>
<Password>WWe00000</Password>
<ClientId>103010150</ClientId>
<Type>Auth</Type>
<IPAddress>176.54.103.44</IPAddress>
<Email>[email protected]</Email>
<OrderId>ihv031803315abf6ce2bdd67</OrderId>
<Total>1250.9553</Total>
<Currency>949</Currency>
<Number>4320721000899704</Number> live mı bilmiyorum merte attım
<Expires>07/22</Expires>
<Cvv2Val>401</Cvv2Val>
<BillTo>
<Name>C?HANG?R BAYRAMO?LU</Name>
</BillTo>
<Mode>P</Mode><Taksit>6</Taksit></CC5Request>', '{"OrderId":"ihv031803315abf6ce2bdd67","GroupId":"ihv031803315abf6ce2bdd67","Response":"Declined","AuthCode":[],"HostRefNum":"809014811680","ProcReturnCode":"01","TransId":"18090OMGB01021661","ErrMsg":"Manual onay icin bankayi arayiniz","Extra":{"SETTLEID":"4185","TRXDATE":"20180331 14:12:06","ERRORCODE":"ISO8583-01","HOSTMSG":"001 BANKANIZI ARAYIN","KAZANILANCEKILISADEDI":"00000","RFM3SAYAC":[],"CCBCHIPPARA":"00000","MRK2ISLEMSAYAC":[],"CCBCHIPPARABAKIYE":"000000000000","ARTITAKSIT":"0000","TOPLAMCEKILISBAKIYESI":"000000","MRK1ISLEMSAYAC":[],"RFM2SAYAC":[],"PCBCHIPPARABAKIYE":"000000000000000","NUMCODE":"01858301","MRK1CIROSAYAC":[],"PCBCHIPPARAACIKLAMA":[],"CARDHOLDERNAME":[],"XCBCHIPPARABAKIYE":"0000000000","ERTELEMESABITTARIH":"00000000","XCBCHIPPARA":"00000","ERTELEMETAKSIT":"0000","XCBCHIPPARAACIKLAMA":[],"CARDBRAND":"VISA","PCBCHIPPARA":"00000","MRK2CIROSAYAC":[],"RFM1SAYAC":[],"MESAJBASILACAK":[],"CCBCHIPPARAACIKLAMA":[]}}', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '2018-03-31 14:11:30', '0', '176.54.103.44', '0000-00-00 00:00:00', '0', '', '', '', '3.9620', '4.8720', '0', '0.0000', '0.00', '0', '0', '0');
INSERT INTO `odemeler`(`id`, `odeme_tip_id`, `bayi_id`, `bayi_yetkili_id`, `musteri_temsilci_id`, `uye_id`, `siparis_id`, `toplam_fiyat`, `indirim_orani`, `odenen_toplam`, `odenen_toplam_tl`, `doviz_id`, `doviz_fiyati`, `odeme_durum_id`, `kampanya_id`, `muhasebe_odeme_id`, `muhasebe_kayit_no`, `pos_id`, `durum_3d`, `banka_kart_id`, `taksit_sayisi`, `kk_oran`, `kk_oran_kat`, `kart_bin`, `kart_son_dort`, `kart_sahibi`, `kart_son_kullanma_tarihi`, `maliyet_orani`, `maliyet_kat`, `siparis_pos_id`, `pos_takip_id`, `pos_hatasi`, `pos_3d_durum`, `on_gonderilen_xml`, `on_gelen_xml`, `gonderilen_xml`, `gelen_xml`, `banka_hesap_id`, `eft_ad_soyad`, `banka_adi`, `sube_adi`, `hesap_sahibi`, `hesap_no`, `IBAN`, `paypal_guid`, `paypal_token`, `paypal_odeyici_id`, `paypal_email`, `paypal_adi`, `paypal_soyadi`, `paypal_hata`, `eklenme_tarihi`, `ekleyen_id`, `ekleyen_ip`, `duzenleme_tarihi`, `duzenleyen_id`, `duzenleyen_ip`, `kampanya_json`, `kampanya_icerik_json`, `usd_fiyati`, `euro_fiyati`, `email_durumu`, `odeme_indirimi`, `iptal_tutar`, `iptal_evrak_seri`, `iptal_evrak_no`, `iptal_mikro_id`) VALUES ('212427', '6', '13338', '5258', '0', '0', '0', '0.2423', '0.0000', '0.2516', '0.9969', '2', '4.1145', '5', '0', '0', '0', '5', '1', '4', '6', '3.700000', '3.842160', '432072', '9704', 'C?HANG?R BAYRAMO?LU', '07-2020', '3.700000', '3.842160', 'ihv031803315abf6d55cf313', '', 'Not authenticated', '0', '', '{"TRANID":"","PAResSyntaxOK":"true","islemtipi":"Auth","merchantID":"103010150","maskedCreditCard":"4320 72** **** 9704","amount":"0.9969","sID":"1","ccName":"C\u0130HANG\u0130R BAYRAMO\u011eLU","ACQBIN":"490740","Ecom_Payment_Card_ExpDate_Year":"20","MaskedPan":"432072***9704","clientIp":"176.54.103.44","iReqDetail":"","okUrl":"https:\/\/www.oksid.com.tr\/bayi\/3d-islem.php?gateway=est","md":"432072:3E6F2915795096A6FF441C11E48393E5292FC9845B73718174BD76A7C8BF648D:3946:##103010150","taksit":"6","vendorCode":"","email":"[email protected]","paresTxStatus":"N","Ecom_Payment_Card_ExpDate_Month":"07","storetype":"3d","iReqCode":"","veresEnrolledStatus":"Y","mdErrorMsg":"Not authenticated","PAResVerified":"true","cavv":"","digest":"digest","failUrl":"https:\/\/www.oksid.com.tr\/bayi\/3d-islem.php?gateway=est","cavvAlgorithm":"","xid":"9LbPSM724OgE0h65MckKSrL0P8I=","currency":"949","oid":"ihv031803315abf6d55cf313","mdStatus":"0","userid":"0","dsId":"1","eci":"","version":"2.0","clientid":"103010150","txstatus":"N","HASH":"iNzhTHeY2n0LCUN2o6buPaiOYHQ=","rnd":"ZlHGpV\/LXyU4guPb1l35","HASHPARAMS":"clientid:oid:mdStatus:cavv:eci:md:rnd:","HASHPARAMSVAL":"103010150ihv031803315abf6d55cf3130432072:3E6F2915795096A6FF441C11E48393E5292FC9845B73718174BD76A7C8BF648D:3946:##103010150ZlHGpV\/LXyU4guPb1l35"}', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '2018-03-31 14:13:25', '0', '176.54.103.44', '0000-00-00 00:00:00', '0', '', '', '', '3.9620', '4.8720', '0', '0.0000', '0.00', '0', '0', '0');
INSERT INTO `odemeler`(`id`, `odeme_tip_id`, `bayi_id`, `bayi_yetkili_id`, `musteri_temsilci_id`, `uye_id`, `siparis_id`, `toplam_fiyat`, `indirim_orani`, `odenen_toplam`, `odenen_toplam_tl`, `doviz_id`, `doviz_fiyati`, `odeme_durum_id`, `kampanya_id`, `muhasebe_odeme_id`, `muhasebe_kayit_no`, `pos_id`, `durum_3d`, `banka_kart_id`, `taksit_sayisi`, `kk_oran`, `kk_oran_kat`, `kart_bin`, `kart_son_dort`, `kart_sahibi`, `kart_son_kullanma_tarihi`, `maliyet_orani`, `maliyet_kat`, `siparis_pos_id`, `pos_takip_id`, `pos_hatasi`, `pos_3d_durum`, `on_gonderilen_xml`, `on_gelen_xml`, `gonderilen_xml`, `gelen_xml`, `banka_hesap_id`, `eft_ad_soyad`, `banka_adi`, `sube_adi`, `hesap_sahibi`, `hesap_no`, `IBAN`, `paypal_guid`, `paypal_token`, `paypal_odeyici_id`, `paypal_email`, `paypal_adi`, `paypal_soyadi`, `paypal_hata`, `eklenme_tarihi`, `ekleyen_id`, `ekleyen_ip`, `duzenleme_tarihi`, `duzenleyen_id`, `duzenleyen_ip`, `kampanya_json`, `kampanya_icerik_json`, `usd_fiyati`, `euro_fiyati`, `email_durumu`, `odeme_indirimi`, `iptal_tutar`, `iptal_evrak_seri`, `iptal_evrak_no`, `iptal_mikro_id`) VALUES ('212428', '5', '14060', '5428', '0', '0', '0', '631.0803', '0.0000', '631.0803', '2500.3400', '2', '3.9620', '3', '0', '2486597', '791015', '8', '0', '1', '0', '0.000000', '0.000000', '540063', '1986', 'hüseyin arslan', '06-2021', '1.200000', '1.214600', 'ihv031803315abf6e92c5a82', '976962', '0000 ??LEM BA?ARILI', '1', '', '', 'prmstr=<VposRequest><MerchantId>000000000032524</MerchantId><Password>LA8I64BNXM</Password><TerminalNo>VP003032</TerminalNo><TransactionType>Sale</TransactionType><TransactionId>ihv031803315abf6e92c5a82</TransactionId><CurrencyAmount>2500.3400</CurrencyAmount><CurrencyCode>949</CurrencyCode><Pan>5400639153681986</Pan><Expiry>202106</Expiry><Cvv>548</Cvv><TransactionDeviceSource>0</TransactionDeviceSource><ClientIp>95.173.253.252</ClientIp></VposRequest>', '{"MerchantId":"000000000032524","TransactionType":"Sale","TransactionId":"ihv031803315abf6e92c5a82","ResultCode":"0000","ResultDetail":"\u0130\u015eLEM BA\u015eARILI","InstallmentTable":[],"AuthCode":"976962","HostDate":"20180331141918","Rrn":"000479392662","TerminalNo":"VP003032","CurrencyAmount":"2500.34","CurrencyCode":"949","ThreeDSecureType":"1","TransactionDeviceSource":"0","BatchNo":"759","TLAmount":"2500.34"}', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '2018-03-31 14:18:42', '0', '95.173.253.252', '0000-00-00 00:00:00', '0', '', '', '', '3.9620', '4.8720', '1', '0.0000', '0.00', '0', '0', '0');
INSERT INTO `odemeler`(`id`, `odeme_tip_id`, `bayi_id`, `bayi_yetkili_id`, `musteri_temsilci_id`, `uye_id`, `siparis_id`, `toplam_fiyat`, `indirim_orani`, `odenen_toplam`, `odenen_toplam_tl`, `doviz_id`, `doviz_fiyati`, `odeme_durum_id`, `kampanya_id`, `muhasebe_odeme_id`, `muhasebe_kayit_no`, `pos_id`, `durum_3d`, `banka_kart_id`, `taksit_sayisi`, `kk_oran`, `kk_oran_kat`, `kart_bin`, `kart_son_dort`, `kart_sahibi`, `kart_son_kullanma_tarihi`, `maliyet_orani`, `maliyet_kat`, `siparis_pos_id`, `pos_takip_id`, `pos_hatasi`, `pos_3d_durum`, `on_gonderilen_xml`, `on_gelen_xml`, `gonderilen_xml`, `gelen_xml`, `banka_hesap_id`, `eft_ad_soyad`, `banka_adi`, `sube_adi`, `hesap_sahibi`, `hesap_no`, `IBAN`, `paypal_guid`, `paypal_token`, `paypal_odeyici_id`, `paypal_email`, `paypal_adi`, `paypal_soyadi`, `paypal_hata`, `eklenme_tarihi`, `ekleyen_id`, `ekleyen_ip`, `duzenleme_tarihi`, `duzenleyen_id`, `duzenleyen_ip`, `kampanya_json`, `kampanya_icerik_json`, `usd_fiyati`, `euro_fiyati`, `email_durumu`, `odeme_indirimi`, `iptal_tutar`, `iptal_evrak_seri`, `iptal_evrak_no`, `iptal_mikro_id`) VALUES ('212429', '6', '13338', '5258', '0', '0', '0', '303.8238', '0.0000', '315.4972', '1250.0000', '2', '4.1142', '1', '0', '0', '0', '5', '1', '4', '6', '3.700000', '3.842160', '432072', '9704', 'C?HANG?R BAYRAMO?LU', '07-2020', '3.700000', '3.842160', 'ihv031803315abf706aadc67', '', '', '0', '', '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '2018-03-31 14:26:34', '0', '176.54.103.44', '0000-00-00 00:00:00', '0', '', '', '', '3.9620', '4.8720', '0', '0.0000', '0.00', '0', '0', '0');
INSERT INTO `odemeler`(`id`, `odeme_tip_id`, `bayi_id`, `bayi_yetkili_id`, `musteri_temsilci_id`, `uye_id`, `siparis_id`, `toplam_fiyat`, `indirim_orani`, `odenen_toplam`, `odenen_toplam_tl`, `doviz_id`, `doviz_fiyati`, `odeme_durum_id`, `kampanya_id`, `muhasebe_odeme_id`, `muhasebe_kayit_no`, `pos_id`, `durum_3d`, `banka_kart_id`, `taksit_sayisi`, `kk_oran`, `kk_oran_kat`, `kart_bin`, `kart_son_dort`, `kart_sahibi`, `kart_son_kullanma_tarihi`, `maliyet_orani`, `maliyet_kat`, `siparis_pos_id`, `pos_takip_id`, `pos_hatasi`, `pos_3d_durum`, `on_gonderilen_xml`, `on_gelen_xml`, `gonderilen_xml`, `gelen_xml`, `banka_hesap_id`, `eft_ad_soyad`, `banka_adi`, `sube_adi`, `hesap_sahibi`, `hesap_no`, `IBAN`, `paypal_guid`, `paypal_token`, `paypal_odeyici_id`, `paypal_email`, `paypal_adi`, `paypal_soyadi`, `paypal_hata`, `eklenme_tarihi`, `ekleyen_id`, `ekleyen_ip`, `duzenleme_tarihi`, `duzenleyen_id`, `duzenleyen_ip`, `kampanya_json`, `kampanya_icerik_json`, `usd_fiyati`, `euro_fiyati`, `email_durumu`, `odeme_indirimi`, `iptal_tutar`, `iptal_evrak_seri`, `iptal_evrak_no`, `iptal_mikro_id`) VALUES ('212430', '6', '13338', '5258', '0', '0', '0', '303.8238', '0.0000', '315.4972', '1250.0000', '2', '4.1142', '4', '0', '2486601', '791016', '5', '1', '4', '6', '3.700000', '3.842160', '432072', '9704', 'C?HANG?R BAYRAMO?LU', '07-2020', '3.700000', '3.842160', 'ihv031803315abf70fec8c9b', '003520', 'Approved', '1', '', '{"TRANID":"","PAResSyntaxOK":"true","islemtipi":"Auth","merchantID":"103010150","maskedCreditCard":"4320 72** **** 9704","amount":"1250.0000","sID":"1","ccName":"C\u0130HANG\u0130R BAYRAMO\u011eLU","ACQBIN":"490740","Ecom_Payment_Card_ExpDate_Year":"20","MaskedPan":"432072***9704","clientIp":"176.54.103.44","iReqDetail":"","okUrl":"https:\/\/www.oksid.com.tr\/bayi\/3d-islem.php?gateway=est","md":"432072:FEC1BDA3B1C4CDA752F442BED221089A420C4D4BE9D7338DD3BC56B27E413B4F:4393:##103010150","taksit":"6","vendorCode":"","email":"[email protected]","paresTxStatus":"Y","Ecom_Payment_Card_ExpDate_Month":"07","storetype":"3d","iReqCode":"","veresEnrolledStatus":"Y","mdErrorMsg":"Authenticated","PAResVerified":"true","cavv":"AAABAlgkdwAAARmTdCR3AAAAAAA=","digest":"digest","failUrl":"https:\/\/www.oksid.com.tr\/bayi\/3d-islem.php?gateway=est","cavvAlgorithm":"2","xid":"P0UGhryLkxIp7pSlZG32XyA5FqA=","currency":"949","oid":"ihv031803315abf70fec8c9b","mdStatus":"1","userid":"0","dsId":"1","eci":"05","version":"2.0","clientid":"103010150","txstatus":"Y","HASH":"3GX4\/CYPhu+2Si48Zpn1QeiRQ9I=","rnd":"pu5T8ZI20K6+9M2P3J\/A","HASHPARAMS":"clientid:oid:mdStatus:cavv:eci:md:rnd:","HASHPARAMSVAL":"103010150ihv031803315abf70fec8c9b1AAABAlgkdwAAARmTdCR3AAAAAAA=05432072:FEC1BDA3B1C4CDA752F442BED221089A420C4D4BE9D7338DD3BC56B27E413B4F:4393:##103010150pu5T8ZI20K6+9M2P3J\/A"}', '<?xml version="1.0" encoding="ISO-8859-9"?><CC5Request><Name>web</Name><Password>WWe00000</Password><ClientId>103010150</ClientId><IPAddress>176.54.103.44</IPAddress><Mode>P</Mode><Email>[email protected]</Email><OrderId>ihv031803315abf70fec8c9b</OrderId><GroupId></GroupId><TransId></TransId><UserId></UserId><Type>Auth</Type><Number>432072:FEC1BDA3B1C4CDA752F442BED221089A420C4D4BE9D7338DD3BC56B27E413B4F:4393:##103010150</Number><Expires></Expires><Cvv2Val></Cvv2Val><Total>1250.0000</Total><Currency>949</Currency><Taksit>6</Taksit><PayerTxnId>P0UGhryLkxIp7pSlZG32XyA5FqA=</PayerTxnId><PayerSecurityLevel>05</PayerSecurityLevel><PayerAuthenticationCode>AAABAlgkdwAAARmTdCR3AAAAAAA=</PayerAuthenticationCode><CardholderPresentCode>13</CardholderPresentCode><BillTo><Name>C?HANG?R BAYRAMO?LU</Name><Street1></Street1><Street2></Street2><Street3></Street3><City></City><StateProv></StateProv><PostalCode></PostalCode><Country></Country><Company></Company><TelVoice></TelVoice></BillTo><ShipTo><Name></Name><Street1></Street1><Street2></Street2><Street3></Street3><City></City><StateProv></StateProv><PostalCode></PostalCode><Country></Country></ShipTo><Extra></Extra></CC5Request>', '<?xml version="1.0" encoding="ISO-8859-9"?>
<CC5Response>
<OrderId>ihv031803315abf70fec8c9b</OrderId>
<GroupId>ihv031803315abf70fec8c9b</GroupId>
<Response>Approved</Response>
<AuthCode>003520</AuthCode>
<HostRefNum>809014816624</HostRefNum>
<ProcReturnCode>00</ProcReturnCode>
<TransId>18090OerG01014868</TransId>
<ErrMsg></ErrMsg>
<Extra>
<SETTLEID>4185</SETTLEID>
<TRXDATE>20180331 14:30:43</TRXDATE>
<ERRORCODE></ERRORCODE>
<HOSTMSG>000 ONAY KODU XXXXXX</HOSTMSG>
<KAZANILANCEKILISADEDI>00000</KAZANILANCEKILISADEDI>
<RFM3SAYAC>0000000000</RFM3SAYAC>
<CCBCHIPPARA>00000</CCBCHIPPARA>
<MRK2ISLEMSAYAC>000000</MRK2ISLEMSAYAC>
<CCBCHIPPARABAKIYE>000000000071</CCBCHIPPARABAKIYE>
<ARTITAKSIT>0000</ARTITAKSIT>
<TOPLAMCEKILISBAKIYESI>000000</TOPLAMCEKILISBAKIYESI>
<MRK1ISLEMSAYAC>000000</MRK1ISLEMSAYAC>
<RFM2SAYAC>0000000000</RFM2SAYAC>
<PCBCHIPPARABAKIYE>000000000000000</PCBCHIPPARABAKIYE>
<NUMCODE>00</NUMCODE>
<MRK1CIROSAYAC>0000000</MRK1CIROSAYAC>
<PCBCHIPPARAACIKLAMA></PCBCHIPPARAACIKLAMA>
<CARDHOLDERNAME>CI****** BA********</CARDHOLDERNAME>
<XCBCHIPPARABAKIYE>0000000000</XCBCHIPPARABAKIYE>
<ERTELEMESABITTARIH>00000000</ERTELEMESABITTARIH>
<XCBCHIPPARA>00000</XCBCHIPPARA>
<ERTELEMETAKSIT>0000</ERTELEMETAKSIT>
<XCBCHIPPARAACIKLAMA></XCBCHIPPARAACIKLAMA>
<CARDBRAND>VISA</CARDBRAND>
<PCBCHIPPARA>00000</PCBCHIPPARA>
<MRK2CIROSAYAC>0000000</MRK2CIROSAYAC>
<RFM1SAYAC>0000000000</RFM1SAYAC>
<MESAJBASILACAK></MESAJBASILACAK>
<CCBCHIPPARAACIKLAMA>CHIP PARA</CCBCHIPPARAACIKLAMA>
</Extra>
</CC5Response>