========================2021-09-30 10:58:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kimfanju-1632967054 LGD_BUYER = 이은희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210930105734 LGD_HASHDATA = 851cf5eb0aa3b4785a5c3d5d6503cb07 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl_nosess.php LGD_VERSION = PHP_Non-ActiveX_Standard LGD_CUSTOM_USABLEPAY = SC0010,SC0030,SC0040 LGD_CUSTOM_SWITCHINGTYPE = IFRAME LGD_OSTYPE_CHECK = P LGD_WINDOW_VER = 2.5 LGD_CASNOTEURL = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20210930110053E69239FE96E84945BC48109C55D5DEAE8QY0PLNH Mname = 이은희 Mcompany = 바로푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = kimfanju LGD_ESCROW_USEYN = N ========================2021-09-30 10:58:52======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210930110054 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 242868 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 490220******2522 LGD_FINANCEAUTHNUM = 54240046 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 023284e5a67aac6da18f82cf06d225fb LGD_BUYERADDRESS = LGD_FINANCENAME = 우리VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210930110054 LGD_PCANCELSTR = 0 LGD_BUYER = 이은희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021093011005415019 LGD_BUYERID = LGD_OID = Direct-kimfanju-1632967054 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 011005415082 ========================2021-09-30 10:58:52======================== insert into mBoard_order set rOrdNo = 'Direct-kimfanju-1632967054', AuthTy = 'card', memberId = 'kimfanju', OrdNm ='이은희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '바로푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '우리VISA 490220******2522', rApprNo = 'mjsof2021093011005415019', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-09-30 10:58:52', InvoiceNum = '결제성공:Direct-kimfanju-1632967054/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-09-30 10:58:52' ========================2021-09-30 10:58:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021093011005415019' 0 = 1 cnt = 1 ========================2021-09-30 10:58:53======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kimfanju' 0 = kimfanju Mid = kimfanju 1 = 바로푸드 Mcompany = 바로푸드 2 = 8805100280 companyNum = 8805100280 3 = 051-752-0017 Mtel1 = 051-752-0017 4 = 010-2980-0017 Mhp = 010-2980-0017 ========================2021-09-30 10:58:53======================== select * from customers where id = 'kimfanju' ========================2021-09-30 10:58:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kimfanju','2021-09-30 10:58:52','10000','11000','온라인','0') ========================2021-09-30 11:04:59======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tkddn9-1632967430 LGD_BUYER = 이의호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210930110350 LGD_HASHDATA = 4a9dac4cb6f75e17c21afe3eee057869 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl_nosess.php LGD_VERSION = PHP_Non-ActiveX_Standard LGD_CUSTOM_USABLEPAY = SC0010,SC0030,SC0040 LGD_CUSTOM_SWITCHINGTYPE = IFRAME LGD_OSTYPE_CHECK = P LGD_WINDOW_VER = 2.5 LGD_CASNOTEURL = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202109301107016A931C8DAA2A497A90B2687F36B32F2AAQTK8WZD Mname = 이의호 Mcompany = (주) 엠알에스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = tkddn9 LGD_ESCROW_USEYN = N ========================2021-09-30 11:04:59======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210930110701 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = tkddn9@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 949019******7811 LGD_FINANCEAUTHNUM = 00070283 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 61000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9f97e26929e8f4c6879f850d6d43bcea LGD_BUYERADDRESS = LGD_FINANCENAME = 현대 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210930110701 LGD_PCANCELSTR = 0 LGD_BUYER = 이의호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021093011070115094 LGD_BUYERID = LGD_OID = Direct-tkddn9-1632967430 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-09-30 11:04:59======================== insert into mBoard_order set rOrdNo = 'Direct-tkddn9-1632967430', AuthTy = 'card', memberId = 'tkddn9', OrdNm ='이의호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주) 엠알에스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '현대 949019******7811', rApprNo = 'mjsof2021093011070115094', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-09-30 11:04:59', InvoiceNum = '결제성공:Direct-tkddn9-1632967430/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-09-30 11:04:59' ========================2021-09-30 11:04:59======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021093011070115094' 0 = 1 cnt = 1 ========================2021-09-30 11:04:59======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'tkddn9' 0 = tkddn9 Mid = tkddn9 1 = (주) 엠알에스 Mcompany = (주) 엠알에스 2 = 1378623158 companyNum = 1378623158 3 = 031-981-2306 Mtel1 = 031-981-2306 4 = 010-2363-9107 Mhp = 010-2363-9107 ========================2021-09-30 11:04:59======================== select * from customers where id = 'tkddn9' ========================2021-09-30 11:04:59======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('tkddn9','2021-09-30 11:04:59','10000','11000','온라인','0') ========================2021-09-30 14:26:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ma2171-1632979500 LGD_BUYER = 송백석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210930142500 LGD_HASHDATA = cc17ea29e03526adb7b3a36c27f96a3b LGD_RETURNURL = http://mjsoft.co/xpay/returnurl_nosess.php LGD_VERSION = PHP_Non-ActiveX_Standard LGD_CUSTOM_USABLEPAY = SC0010,SC0030,SC0040 LGD_CUSTOM_SWITCHINGTYPE = IFRAME LGD_OSTYPE_CHECK = P LGD_WINDOW_VER = 2.5 LGD_CASNOTEURL = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202109301428349282E372DB3E4192A6501E5805490CACENCJR9WH Mname = 송백석 Mcompany = 부산비지니스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = ma2171 LGD_ESCROW_USEYN = N ========================2021-09-30 14:26:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210930142835 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 543333******5030 LGD_FINANCEAUTHNUM = 00036190 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ddd745eae2133aa79c34094bcc76dfc2 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210930142835 LGD_PCANCELSTR = 0 LGD_BUYER = 송백석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021093014283561111 LGD_BUYERID = LGD_OID = Direct-ma2171-1632979500 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-09-30 14:26:33======================== insert into mBoard_order set rOrdNo = 'Direct-ma2171-1632979500', AuthTy = 'card', memberId = 'ma2171', OrdNm ='송백석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '부산비지니스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대MASTER 543333******5030', rApprNo = 'mjsof2021093014283561111', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-09-30 14:26:33', InvoiceNum = '결제성공:Direct-ma2171-1632979500/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-09-30 14:26:33' ========================2021-09-30 14:26:33======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021093014283561111' 0 = 1 cnt = 1 ========================2021-09-30 14:26:33======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ma2171' 0 = ma2171 Mid = ma2171 1 = 부산비지니스 Mcompany = 부산비지니스 2 = 605-17-59191 companyNum = 605-17-59191 3 = 051-868-3200 Mtel1 = 051-868-3200 4 = 010-8266-3200 Mhp = 010-8266-3200 ========================2021-09-30 14:26:33======================== select * from customers where id = 'ma2171' ========================2021-09-30 14:26:33======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ma2171','2021-09-30 14:26:33','108000','110000','온라인','0') ========================2021-09-30 16:27:16======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-oil1-1632986781 LGD_BUYER = 임찬 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210930162621 LGD_HASHDATA = 5f80ff18662c9d9ba2a3cc0f5dee74dc LGD_RETURNURL = http://mjsoft.co/xpay/returnurl_nosess.php LGD_VERSION = PHP_Non-ActiveX_Standard LGD_CUSTOM_USABLEPAY = SC0010,SC0030,SC0040 LGD_CUSTOM_SWITCHINGTYPE = IFRAME LGD_OSTYPE_CHECK = P LGD_WINDOW_VER = 2.5 LGD_CASNOTEURL = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2021093016291893B28239C0E24647B397DA89E5629AF7JC5URM6X Mname = 임찬 Mcompany = 오일원 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = oil1 LGD_ESCROW_USEYN = N ========================2021-09-30 16:27:17======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210930162919 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 005005 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 533014******4982 LGD_FINANCEAUTHNUM = 58190354 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 46200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 85a07cfa6ec5e6ed887fc214b781a2e5 LGD_BUYERADDRESS = LGD_FINANCENAME = 광주Master LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210930162919 LGD_PCANCELSTR = 0 LGD_BUYER = 임찬 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof2021093016291915294 LGD_BUYERID = LGD_OID = Direct-oil1-1632986781 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 301629608534 ========================2021-09-30 16:27:30======================== res_start ========================2021-09-30 16:27:30======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다. Init_TX(LGD_MID)를 해주시기 바랍니다. 또는 mall.conf 에 상점키가 셋팅되어 있지 않습니다. ========================2021-09-30 16:31:44======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-oil1-1632987069 LGD_BUYER = 임찬 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210930163109 LGD_HASHDATA = 2d5550e07fe21fc628bd3b035115890a LGD_RETURNURL = http://mjsoft.co/xpay/returnurl_nosess.php LGD_VERSION = PHP_Non-ActiveX_Standard LGD_CUSTOM_USABLEPAY = SC0010,SC0030,SC0040 LGD_CUSTOM_SWITCHINGTYPE = IFRAME LGD_OSTYPE_CHECK = P LGD_WINDOW_VER = 2.5 LGD_CASNOTEURL = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20210930163346668C22906B244DB1BDF96B871366EEB0XO8PUH8E Mname = 임찬 Mcompany = 오일원 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = oil1 LGD_ESCROW_USEYN = N ========================2021-09-30 16:31:45======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210930163347 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 005005 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 533014******4982 LGD_FINANCEAUTHNUM = 58217232 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 46200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 45f0c20cc39302bb9aa1025f26058529 LGD_BUYERADDRESS = LGD_FINANCENAME = 광주Master LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210930163347 LGD_PCANCELSTR = 0 LGD_BUYER = 임찬 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof2021093016334615272 LGD_BUYERID = LGD_OID = Direct-oil1-1632987069 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 301633226868 ========================2021-09-30 16:35:26======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-oil1-1632987291 LGD_BUYER = 임찬 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210930163451 LGD_HASHDATA = 450b449e7d9114eded958b9e8b184054 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl_nosess.php LGD_VERSION = PHP_Non-ActiveX_Standard LGD_CUSTOM_USABLEPAY = SC0010,SC0030,SC0040 LGD_CUSTOM_SWITCHINGTYPE = IFRAME LGD_OSTYPE_CHECK = P LGD_WINDOW_VER = 2.5 LGD_CASNOTEURL = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2021093016372882227F3C111C45F5857A80CD82B01EAFELVVFT7Q Mname = 임찬 Mcompany = 오일원 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = oil1 LGD_ESCROW_USEYN = N ========================2021-09-30 16:35:28======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210930163729 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 005005 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 533014******4982 LGD_FINANCEAUTHNUM = 58250716 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 46200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 07129a37f0eb4fe7c85bc6e35a6f8f1a LGD_BUYERADDRESS = LGD_FINANCENAME = 광주Master LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210930163730 LGD_PCANCELSTR = 0 LGD_BUYER = 임찬 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof2021093016372960274 LGD_BUYERID = LGD_OID = Direct-oil1-1632987291 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 301637288595 ========================2021-09-30 16:35:28======================== insert into mBoard_order set rOrdNo = 'Direct-oil1-1632987291', AuthTy = 'card', memberId = 'oil1', OrdNm ='임찬', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '오일원', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '광주Master 533014******4982', rApprNo = 'mjsof2021093016372960274', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-09-30 16:35:28', InvoiceNum = '결제성공:Direct-oil1-1632987291/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-09-30 16:35:28' ========================2021-09-30 16:35:28======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021093016372960274' 0 = 1 cnt = 1 ========================2021-09-30 16:35:28======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'oil1' 0 = oil1 Mid = oil1 1 = 오일원 Mcompany = 오일원 2 = 5818601123 companyNum = 5818601123 3 = 062-576-0261 Mtel1 = 062-576-0261 4 = 010-8616-9346 Mhp = 010-8616-9346 ========================2021-09-30 16:35:28======================== select * from customers where id = 'oil1' ========================2021-09-30 16:35:28======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('oil1','2021-09-30 16:35:28','220000','220000','온라인','0') ========================2021-09-30 18:04:49======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sunmro-1632992650 LGD_BUYER = 강찬수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210930180410 LGD_HASHDATA = 4efc2c921542ec5e45c75fe74aa6decc LGD_RETURNURL = http://mjsoft.co/xpay/returnurl_nosess.php LGD_VERSION = PHP_Non-ActiveX_Standard LGD_CUSTOM_USABLEPAY = SC0010,SC0030,SC0040 LGD_CUSTOM_SWITCHINGTYPE = IFRAME LGD_OSTYPE_CHECK = P LGD_WINDOW_VER = 2.5 LGD_CASNOTEURL = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202109301806513445E05B91F24FF6AA0BB69150BC6988PLXHOYK1 Mname = 강찬수 Mcompany = (주)태양엠알오 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = sunmro LGD_ESCROW_USEYN = N ========================2021-09-30 18:04:50======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210930180652 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 834865 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558920******2440 LGD_FINANCEAUTHNUM = 59050464 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 685a46a9457d812027f7841f0dc89378 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210930180652 LGD_PCANCELSTR = 0 LGD_BUYER = 강찬수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021093018065260249 LGD_BUYERID = LGD_OID = Direct-sunmro-1632992650 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 018065260257 ========================2021-09-30 18:04:50======================== insert into mBoard_order set rOrdNo = 'Direct-sunmro-1632992650', AuthTy = 'card', memberId = 'sunmro', OrdNm ='강찬수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)태양엠알오', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리MASTER 558920******2440', rApprNo = 'mjsof2021093018065260249', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-09-30 18:04:50', InvoiceNum = '결제성공:Direct-sunmro-1632992650/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-09-30 18:04:50' ========================2021-09-30 18:04:50======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021093018065260249' 0 = 1 cnt = 1 ========================2021-09-30 18:04:50======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sunmro' 0 = sunmro Mid = sunmro 1 = (주)태양엠알오 Mcompany = (주)태양엠알오 2 = 262-81-00306 companyNum = 262-81-00306 3 = 02-1899-0942 Mtel1 = 02-1899-0942 4 = 010-5482-0951 Mhp = 010-5482-0951 ========================2021-09-30 18:04:50======================== select * from customers where id = 'sunmro' ========================2021-09-30 18:04:50======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sunmro','2021-09-30 18:04:50','220000','220000','온라인','0')