========================2024-01-04 09:03:50======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sejifc-1704326551 LGD_BUYER = 이정화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240104090231 LGD_HASHDATA = 3b3d723c095974c08aa7acaaa2e2518d LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20240104090752FBE1E7B66AA947BB9AF62EA84FE7E62E41CD668E Mname = 이정화 Mcompany = (주)세지에프씨 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = sejifc LGD_ESCROW_USEYN = N ========================2024-01-04 09:03:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240104090752 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94091511****982* LGD_FINANCEAUTHNUM = 59449201 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 71000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5d1918773ee8865e333999196a189286 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20240104090753 LGD_PCANCELSTR = 0 LGD_BUYER = 이정화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240104090752HizJ7 LGD_BUYERID = LGD_OID = Direct-sejifc-1704326551 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-01-04 09:03:51======================== insert into mBoard_order set rOrdNo = 'Direct-sejifc-1704326551', AuthTy = 'card', memberId = 'sejifc', OrdNm ='이정화', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)세지에프씨', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '롯데 94091511****982*', rApprNo = 'mjsof20240104090752HizJ7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-04 09:03:51', InvoiceNum = '결제성공:Direct-sejifc-1704326551/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-04 09:03:51' ========================2024-01-04 09:03:51======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240104090752HizJ7' 0 = 1 cnt = 1 ========================2024-01-04 09:03:51======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sejifc' 0 = sejifc Mid = sejifc 1 = (주)세지에프씨 Mcompany = (주)세지에프씨 2 = 214-88-52124 companyNum = 214-88-52124 3 = 02-522-6777 Mtel1 = 02-522-6777 4 = 010-8952-2514 Mhp = 010-8952-2514 ========================2024-01-04 09:03:51======================== select * from customers where id = 'sejifc' ========================2024-01-04 09:03:51======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sejifc','2024-01-04 09:03:51','52500','55000','온라인','0') ========================2024-01-04 09:03:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-todamls-1704326584 LGD_BUYER = 유대웅 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240104090304 LGD_HASHDATA = 524b1ebd61d50791a07a83aad051df58 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20240104090754D89D57465091AE3F04669C2E64C4B512645E888F Mname = 유대웅 Mcompany = (주)토담유통상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = todamls LGD_ESCROW_USEYN = N ========================2024-01-04 09:03:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240104090754 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = todamls@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 005772 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 51107002****015* LGD_FINANCEAUTHNUM = 20266097 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 35200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = de41c8cc30c73b521042061ba016733e LGD_BUYERADDRESS = LGD_FINANCENAME = 전북MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240104090755 LGD_PCANCELSTR = 0 LGD_BUYER = 유대웅 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof20240104090754EM4A6 LGD_BUYERID = LGD_OID = Direct-todamls-1704326584 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 040907682995 ========================2024-01-04 09:03:53======================== insert into mBoard_order set rOrdNo = 'Direct-todamls-1704326584', AuthTy = 'card', memberId = 'todamls', OrdNm ='유대웅', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)토담유통상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '전북MASTER 51107002****015*', rApprNo = 'mjsof20240104090754EM4A6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-04 09:03:53', InvoiceNum = '결제성공:Direct-todamls-1704326584/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-04 09:03:53' ========================2024-01-04 09:03:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240104090754EM4A6' 0 = 1 cnt = 1 ========================2024-01-04 09:03:53======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'todamls' 0 = todamls Mid = todamls 1 = (주)토담유통상사 Mcompany = (주)토담유통상사 2 = 403-81-36254 companyNum = 403-81-36254 3 = 063-837-7799 Mtel1 = 063-837-7799 4 = 010-9626-7293 Mhp = 010-9626-7293 ========================2024-01-04 09:03:53======================== select * from customers where id = 'todamls' ========================2024-01-04 09:03:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('todamls','2024-01-04 09:03:53','52500','55000','온라인','0') ========================2024-01-04 09:38:52======================== res_start ========================2024-01-04 09:38:52======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다. Init_TX(LGD_MID)를 해주시기 바랍니다. 또는 mall.conf 에 상점키가 셋팅되어 있지 않습니다. ========================2024-01-04 09:40:54======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hanapaper-1704328781 LGD_BUYER = 이전상 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240104093941 LGD_HASHDATA = 00833d9fc691581f5977eae4891e5857 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20240104094455473F141F86003D9D6F6D49B23649489C06023D50 Mname = 이전상 Mcompany = (주)미르티앤엠 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = hanapaper LGD_ESCROW_USEYN = N ========================2024-01-04 09:40:55======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240104094456 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41452000****446* LGD_FINANCEAUTHNUM = 58122440 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 84e7a2f9fa2d926327c3181343155292 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240104094457 LGD_PCANCELSTR = 0 LGD_BUYER = 이전상 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240104094456GOVw6 LGD_BUYERID = LGD_OID = Direct-hanapaper-1704328781 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-01-04 09:40:55======================== insert into mBoard_order set rOrdNo = 'Direct-hanapaper-1704328781', AuthTy = 'card', memberId = 'hanapaper', OrdNm ='이전상', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)미르티앤엠', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '우리비씨VISA 41452000****446*', rApprNo = 'mjsof20240104094456GOVw6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-04 09:40:55', InvoiceNum = '결제성공:Direct-hanapaper-1704328781/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-04 09:40:55' ========================2024-01-04 09:40:55======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240104094456GOVw6' 0 = 1 cnt = 1 ========================2024-01-04 09:40:55======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hanapaper' 0 = hanapaper Mid = hanapaper 1 = (주)미르티앤엠 Mcompany = (주)미르티앤엠 2 = 1348736286 companyNum = 1348736286 3 = 031-521-6690 Mtel1 = 031-521-6690 4 = 010-2216-5552 Mhp = 010-2216-5552 ========================2024-01-04 09:40:55======================== select * from customers where id = 'hanapaper' ========================2024-01-04 09:40:55======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hanapaper','2024-01-04 09:40:55','52500','55000','온라인','0') ========================2024-01-04 10:23:21======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-paolo1117-1704331344 LGD_BUYER = 권혁래 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240104102224 LGD_HASHDATA = 6d394630fcfd3db5cdcebfda2b10e315 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20240104102723AB44A3893EC4BE9096CB10C0A90BDE3389D03CA6 Mname = 권혁래 Mcompany = 푸드스토어 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = paolo1117 LGD_ESCROW_USEYN = N ========================2024-01-04 10:23:21======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240104102723 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = DAAAPS LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55315240****235* LGD_FINANCEAUTHNUM = 49269808 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d7463818e605e8cfbe1da92c19840d9b LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240104102723 LGD_PCANCELSTR = 0 LGD_BUYER = 권혁래 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240104102723Lb6s4 LGD_BUYERID = LGD_OID = Direct-paolo1117-1704331344 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-01-04 10:23:21======================== insert into mBoard_order set rOrdNo = 'Direct-paolo1117-1704331344', AuthTy = 'card', memberId = 'paolo1117', OrdNm ='권혁래', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '푸드스토어', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한MASTER 55315240****235*', rApprNo = 'mjsof20240104102723Lb6s4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-04 10:23:21', InvoiceNum = '결제성공:Direct-paolo1117-1704331344/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-04 10:23:21' ========================2024-01-04 10:23:22======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240104102723Lb6s4' 0 = 1 cnt = 1 ========================2024-01-04 10:23:22======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'paolo1117' 0 = paolo1117 Mid = paolo1117 1 = 푸드스토어 Mcompany = 푸드스토어 2 = 1308706795 companyNum = 1308706795 3 = 032-676-6626 Mtel1 = 032-676-6626 4 = 010-8999-6626 Mhp = 010-8999-6626 ========================2024-01-04 10:23:22======================== select * from customers where id = 'paolo1117' ========================2024-01-04 10:23:22======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('paolo1117','2024-01-04 10:23:21','52500','55000','온라인','0') ========================2024-01-04 11:56:36======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-miracl0-1704336948 LGD_BUYER = 박영미 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240104115548 LGD_HASHDATA = 2827130f0a05ee0a0a5c33cb2b9a86b4 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202401041200385B68FC906469F26DECBC4A1C2788B71B62660740 Mname = 박영미 Mcompany = 와이피리테일 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = miracl0 LGD_ESCROW_USEYN = N ========================2024-01-04 11:56:37======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240104120038 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 755339 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400306****699* LGD_FINANCEAUTHNUM = 58901030 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = bd05930a57d764ab4e8a061804f8b585 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240104120039 LGD_PCANCELSTR = 0 LGD_BUYER = 박영미 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240104120038PnN22 LGD_BUYERID = LGD_OID = Direct-miracl0-1704336948 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4120038PG2c4 ========================2024-01-04 11:56:37======================== insert into mBoard_order set rOrdNo = 'Direct-miracl0-1704336948', AuthTy = 'card', memberId = 'miracl0', OrdNm ='박영미', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '와이피리테일', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '비씨VISA 41400306****699*', rApprNo = 'mjsof20240104120038PnN22', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-04 11:56:37', InvoiceNum = '결제성공:Direct-miracl0-1704336948/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-04 11:56:37' ========================2024-01-04 11:56:37======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240104120038PnN22' 0 = 1 cnt = 1 ========================2024-01-04 11:56:37======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'miracl0' 0 = miracl0 Mid = miracl0 1 = 와이피리테일 Mcompany = 와이피리테일 2 = 4100652482 companyNum = 4100652482 3 = 010-9936-6658 Mtel1 = 010-9936-6658 4 = 010-9936-6658 Mhp = 010-9936-6658 ========================2024-01-04 11:56:37======================== select * from customers where id = 'miracl0' ========================2024-01-04 11:56:37======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('miracl0','2024-01-04 11:56:37','10000','11000','온라인','0') ========================2024-01-04 12:26:58======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mail2020-1704338587 LGD_BUYER = 임요한 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240104122307 LGD_HASHDATA = d391bdfc8313d9249dc4519c781ef5ed LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20240104123100B1F569E5012EAA1EA326449F4F57B88B93B5665F Mname = 임요한 Mcompany = 매일우유천전점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = mail2020 LGD_ESCROW_USEYN = N ========================2024-01-04 12:26:59======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240104123101 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 004288 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55704276****400* LGD_FINANCEAUTHNUM = 30025416 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d6bfd7faca18aba930ca315081e5c232 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240104123101 LGD_PCANCELSTR = 0 LGD_BUYER = 임요한 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240104123101H8eO0 LGD_BUYERID = LGD_OID = Direct-mail2020-1704338587 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-01-04 12:26:59======================== insert into mBoard_order set rOrdNo = 'Direct-mail2020-1704338587', AuthTy = 'card', memberId = 'mail2020', OrdNm ='임요한', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '매일우유천전점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '국민MASTER 55704276****400*', rApprNo = 'mjsof20240104123101H8eO0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-04 12:26:59', InvoiceNum = '결제성공:Direct-mail2020-1704338587/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-04 12:26:59' ========================2024-01-04 12:26:59======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240104123101H8eO0' 0 = 1 cnt = 1 ========================2024-01-04 12:26:59======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mail2020' 0 = mail2020 Mid = mail2020 1 = 매일우유천전점 Mcompany = 매일우유천전점 2 = 2174400621 companyNum = 2174400621 3 = 010-9198-1005 Mtel1 = 010-9198-1005 4 = 010-5330-1535 Mhp = 010-5330-1535 ========================2024-01-04 12:26:59======================== select * from customers where id = 'mail2020' ========================2024-01-04 12:26:59======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mail2020','2024-01-04 12:26:59','30900','33000','온라인','0') ========================2024-01-04 13:09:54======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-rocketbusan-1704341347 LGD_BUYER = 정지원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240104130907 LGD_HASHDATA = 7075bfb2e9f22b98a91f64ba43824945 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2024010413135609BB9CCE2F831CC91A4F6919A9AD878869DF18F4 Mname = 정지원 Mcompany = (주)로케트배터리부산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = rocketbusan LGD_ESCROW_USEYN = N ========================2024-01-04 13:09:55======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240104131356 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = rocketbusan@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 926871 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400311****093* LGD_FINANCEAUTHNUM = 59355866 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 39818866e19a691b4999e4c771f19504 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240104131357 LGD_PCANCELSTR = 0 LGD_BUYER = 정지원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240104131356ELa08 LGD_BUYERID = LGD_OID = Direct-rocketbusan-1704341347 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4131356ETiS0 ========================2024-01-04 13:09:55======================== insert into mBoard_order set rOrdNo = 'Direct-rocketbusan-1704341347', AuthTy = 'card', memberId = 'rocketbusan', OrdNm ='정지원', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)로케트배터리부산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41400311****093*', rApprNo = 'mjsof20240104131356ELa08', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-04 13:09:55', InvoiceNum = '결제성공:Direct-rocketbusan-1704341347/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-04 13:09:55' ========================2024-01-04 13:09:55======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240104131356ELa08' 0 = 1 cnt = 1 ========================2024-01-04 13:09:55======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'rocketbusan' 0 = rocketbusan Mid = rocketbusan 1 = (주)로케트배터리부산 Mcompany = (주)로케트배터리부산 2 = 1998701222 companyNum = 1998701222 3 = 051-412-7730 Mtel1 = 051-412-7730 4 = 010-9076-2104 Mhp = 010-9076-2104 ========================2024-01-04 13:09:55======================== select * from customers where id = 'rocketbusan' ========================2024-01-04 13:09:55======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('rocketbusan','2024-01-04 13:09:55','220000','220000','온라인','0') ========================2024-01-04 13:16:34======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sw9376-1704341757 LGD_BUYER = 고승환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240104131557 LGD_HASHDATA = fac7d5703d2e813d7d507a24e147b009 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20240104132036CEB95516215ACE6A714930C02D5E6B92F702DB96 Mname = 고승환 Mcompany = 주식회사 신우 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = sw9376 LGD_ESCROW_USEYN = N ========================2024-01-04 13:16:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240104132037 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400307****994* LGD_FINANCEAUTHNUM = 59388778 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4a4031d1ad3b9fc1c93461f196364b2c LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240104132037 LGD_PCANCELSTR = 0 LGD_BUYER = 고승환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240104132037PEM39 LGD_BUYERID = LGD_OID = Direct-sw9376-1704341757 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4132037PLxE4 ========================2024-01-04 13:16:35======================== insert into mBoard_order set rOrdNo = 'Direct-sw9376-1704341757', AuthTy = 'card', memberId = 'sw9376', OrdNm ='고승환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 신우', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41400307****994*', rApprNo = 'mjsof20240104132037PEM39', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-04 13:16:35', InvoiceNum = '결제성공:Direct-sw9376-1704341757/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-04 13:16:35' ========================2024-01-04 13:16:35======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240104132037PEM39' 0 = 1 cnt = 1 ========================2024-01-04 13:16:35======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sw9376' 0 = sw9376 Mid = sw9376 1 = 주식회사 신우 Mcompany = 주식회사 신우 2 = 125-81-89093 companyNum = 125-81-89093 3 = 031-611-1000 Mtel1 = 031-611-1000 4 = 010-2540-5599 Mhp = 010-2540-5599 ========================2024-01-04 13:16:35======================== select * from customers where id = 'sw9376' ========================2024-01-04 13:16:35======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sw9376','2024-01-04 13:16:35','220000','220000','온라인','0') ========================2024-01-04 15:10:39======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-volume0305-1704348614 LGD_BUYER = 모민수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240104151014 LGD_HASHDATA = f1424f61619917cb4105039cc26c7ce4 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202401041514413ADB39C02B8D1942523F968B3F7E50A34ED25CBB Mname = 모민수 Mcompany = 충청건재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = volume0305 LGD_ESCROW_USEYN = N ========================2024-01-04 15:10:41======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240104151442 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62436303****674* LGD_FINANCEAUTHNUM = 66157916 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 91800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = c35af285451f2418b0ee7d29c10783e3 LGD_BUYERADDRESS = LGD_FINANCENAME = 농협CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240104151443 LGD_PCANCELSTR = 0 LGD_BUYER = 모민수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240104151442GzUe6 LGD_BUYERID = LGD_OID = Direct-volume0305-1704348614 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-01-04 15:10:41======================== insert into mBoard_order set rOrdNo = 'Direct-volume0305-1704348614', AuthTy = 'card', memberId = 'volume0305', OrdNm ='모민수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '충청건재', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '농협CUP 62436303****674*', rApprNo = 'mjsof20240104151442GzUe6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-04 15:10:41', InvoiceNum = '결제성공:Direct-volume0305-1704348614/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-04 15:10:41' ========================2024-01-04 15:10:41======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240104151442GzUe6' 0 = 1 cnt = 1 ========================2024-01-04 15:10:41======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'volume0305' 0 = volume0305 Mid = volume0305 1 = 충청건재 Mcompany = 충청건재 2 = 733-15-01592 companyNum = 733-15-01592 3 = 010-2750-8222 Mtel1 = 010-2750-8222 4 = 010-2750-8222 Mhp = 010-2750-8222 ========================2024-01-04 15:10:41======================== select * from customers where id = 'volume0305' ========================2024-01-04 15:10:41======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('volume0305','2024-01-04 15:10:41','10000','11000','온라인','0') ========================2024-01-04 20:40:50======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-puduly-1704368272 LGD_BUYER = 곽윤희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240104203752 LGD_HASHDATA = d592f38e10386254db2cbaf686f6cc6a LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20240104204452083589F865695DC2A0B787FC1071C4C7188CE6FA Mname = 곽윤희 Mcompany = (주)원앤원사무용가구 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = puduly LGD_ESCROW_USEYN = N ========================2024-01-04 20:40:51======================== xpay_res LGD_DCNO = DC LGD_BUYERPHONE = LGD_PAYDATE = 20240104204453 LGD_DISCOUNTUSEYN = 1 LGD_BUYEREMAIL = puduly@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 53664800****544* LGD_FINANCEAUTHNUM = 28468376 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 1000 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b399254947c63b79ef229819b350b5dc LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20240104204453 LGD_PCANCELSTR = 0 LGD_BUYER = 곽윤희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240104204453H6TP5 LGD_BUYERID = LGD_OID = Direct-puduly-1704368272 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-01-04 20:40:51======================== insert into mBoard_order set rOrdNo = 'Direct-puduly-1704368272', AuthTy = 'card', memberId = 'puduly', OrdNm ='곽윤희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)원앤원사무용가구', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '삼성MASTER 53664800****544*', rApprNo = 'mjsof20240104204453H6TP5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-04 20:40:51', InvoiceNum = '결제성공:Direct-puduly-1704368272/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-04 20:40:51' ========================2024-01-04 20:40:51======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240104204453H6TP5' 0 = 1 cnt = 1 ========================2024-01-04 20:40:51======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'puduly' 0 = puduly Mid = puduly 1 = (주)원앤원사무용가구 Mcompany = (주)원앤원사무용가구 2 = 6628800242 companyNum = 6628800242 3 = 010-3333-8091 Mtel1 = 010-3333-8091 4 = 010-3333-8091 Mhp = 010-3333-8091 ========================2024-01-04 20:40:51======================== select * from customers where id = 'puduly' ========================2024-01-04 20:40:51======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('puduly','2024-01-04 20:40:51','52500','55000','온라인','0')