========================2022-12-30 08:44:10======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kjhg519-1672357372 LGD_BUYER = 노세현 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221230084252 LGD_HASHDATA = 37ca276843d5260464e9c3981952f54d 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 = 20221230084844380B1FF418CED175AC61317C8D3D257E4E9F4F4F Mname = 노세현 Mcompany = 새한상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kjhg519 LGD_ESCROW_USEYN = N ========================2022-12-30 08:44:11======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221230084844 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 100957 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 91000300****035* LGD_FINANCEAUTHNUM = 34252835 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = afb610bf50e2a67715cb977c354057a9 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221230084845 LGD_PCANCELSTR = 0 LGD_BUYER = 노세현 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202212300848443c257 LGD_BUYERID = LGD_OID = Direct-kjhg519-1672357372 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 00848443C8S2 ========================2022-12-30 08:44:11======================== insert into mBoard_order set rOrdNo = 'Direct-kjhg519-1672357372', AuthTy = 'card', memberId = 'kjhg519', OrdNm ='노세현', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '새한상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 91000300****035*', rApprNo = 'mjsof202212300848443c257', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-30 08:44:11', InvoiceNum = '결제성공:Direct-kjhg519-1672357372/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-30 08:44:11' ========================2022-12-30 08:44:11======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202212300848443c257' 0 = 1 cnt = 1 ========================2022-12-30 08:44:11======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kjhg519' 0 = kjhg519 Mid = kjhg519 1 = 새한상사 Mcompany = 새한상사 2 = 4762201533 companyNum = 4762201533 3 = 010-5174-4763 Mtel1 = 010-5174-4763 4 = 010-5174-4763 Mhp = 010-5174-4763 ========================2022-12-30 08:44:11======================== select * from customers where id = 'kjhg519' ========================2022-12-30 08:44:11======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kjhg519','2022-12-30 08:44:11','52500','55000','온라인','0') ========================2022-12-30 11:08:49======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hanscb-1672366022 LGD_BUYER = 한상석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221230110702 LGD_HASHDATA = 6cb47d6212dcc1d2bfe2a8706513abca 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 = 20221230111323E45FF79BECB0A2F44D24CEDE27D5AD18F27302D4 Mname = 한상석 Mcompany = 이인시스템 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = hanscb LGD_ESCROW_USEYN = N ========================2022-12-30 11:08:49======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221230111324 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 755741 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300307****599* LGD_FINANCEAUTHNUM = 35072525 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 0a8e681e082e7ebbfd7c17c52d96e578 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221230111324 LGD_PCANCELSTR = 0 LGD_BUYER = 한상석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221230111323XJeD7 LGD_BUYERID = LGD_OID = Direct-hanscb-1672366022 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0111323Xg6I0 ========================2022-12-30 11:08:49======================== insert into mBoard_order set rOrdNo = 'Direct-hanscb-1672366022', AuthTy = 'card', memberId = 'hanscb', OrdNm ='한상석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '이인시스템', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '비씨 94300307****599*', rApprNo = 'mjsof20221230111323XJeD7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-30 11:08:49', InvoiceNum = '결제성공:Direct-hanscb-1672366022/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-30 11:08:49' ========================2022-12-30 11:08:50======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221230111323XJeD7' 0 = 1 cnt = 1 ========================2022-12-30 11:08:50======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hanscb' 0 = hanscb Mid = hanscb 1 = 이인시스템 Mcompany = 이인시스템 2 = 308-09-18917 companyNum = 308-09-18917 3 = 031-497-7395 Mtel1 = 031-497-7395 4 = 010-9901-7395 Mhp = 010-9901-7395 ========================2022-12-30 11:08:50======================== select * from customers where id = 'hanscb' ========================2022-12-30 11:08:50======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hanscb','2022-12-30 11:08:49','30900','33000','온라인','0') ========================2022-12-30 11:36:34======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-foodpackage-1672367733 LGD_BUYER = 최별 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221230113533 LGD_HASHDATA = 09b844b906e3fe71b680f7f2fcc9265d 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 = 20221230114108A5A9B605E386FB94DA58884814E71EDE061D3ED2 Mname = 최별 Mcompany = 푸드패키지 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = foodpackage LGD_ESCROW_USEYN = N ========================2022-12-30 11:36:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221230114109 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400308****199* LGD_FINANCEAUTHNUM = 35238093 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ef8f6b9b873c140507036419cfad946b LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221230114109 LGD_PCANCELSTR = 0 LGD_BUYER = 최별 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221230114108Yshm8 LGD_BUYERID = LGD_OID = Direct-foodpackage-1672367733 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0114108YfWu6 ========================2022-12-30 11:37:50======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-foodpackage-1672367800 LGD_BUYER = 최별 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221230113640 LGD_HASHDATA = af2b6abf6c3af468cb10dc109d3e7a1d 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 = 20221230114224C639D09D6D185CFDB4A2F5563521910AD78E4B05 Mname = 최별 Mcompany = 푸드패키지 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = foodpackage LGD_ESCROW_USEYN = N ========================2022-12-30 11:37:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221230114225 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400308****199* LGD_FINANCEAUTHNUM = 35252203 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 132445ab1a441f64075ce3add0771fbe LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221230114225 LGD_PCANCELSTR = 0 LGD_BUYER = 최별 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202212301142247tZL5 LGD_BUYERID = LGD_OID = Direct-foodpackage-1672367800 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 011422478Ol3 ========================2022-12-30 11:38:36======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-foodpackage-1672367876 LGD_BUYER = 최별 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221230113756 LGD_HASHDATA = a6f0bc903fb98efbcc5a812a01a6cb2c 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 = 20221230114310C74846D672D0A9B70E6B0C2477AD2EE2B4820E5C Mname = 최별 Mcompany = 푸드패키지 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = foodpackage LGD_ESCROW_USEYN = N ========================2022-12-30 11:38:37======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221230114311 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = BCCBYF LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 54287966****971* LGD_FINANCEAUTHNUM = 26029970 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a90061376769d13a1074a19637888840 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20221230114311 LGD_PCANCELSTR = 0 LGD_BUYER = 최별 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202212301143113smD5 LGD_BUYERID = LGD_OID = Direct-foodpackage-1672367876 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-12-30 12:44:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-labedu-1672371818 LGD_BUYER = 김봉국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221230124338 LGD_HASHDATA = ce1b8932c7f1d6708eef2951b6710e7f 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 = 20221230124859D364CE681DD379E73D916C8A2CCA7C46D3FC812A Mname = 김봉국 Mcompany = 명지과학 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = labedu LGD_ESCROW_USEYN = N ========================2022-12-30 12:44:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221230124900 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 001665 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 52728922****030* LGD_FINANCEAUTHNUM = 30035114 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 342b3e4b1a5a30299a4dbe525b20e409 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20221230124900 LGD_PCANCELSTR = 0 LGD_BUYER = 김봉국 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202212301249007zAc4 LGD_BUYERID = LGD_OID = Direct-labedu-1672371818 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 01249007aQp9 ========================2022-12-30 12:44:26======================== insert into mBoard_order set rOrdNo = 'Direct-labedu-1672371818', AuthTy = 'card', memberId = 'labedu', OrdNm ='김봉국', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '명지과학', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 52728922****030*', rApprNo = 'mjsof202212301249007zAc4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-30 12:44:26', InvoiceNum = '결제성공:Direct-labedu-1672371818/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-30 12:44:26' ========================2022-12-30 12:44:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202212301249007zAc4' 0 = 1 cnt = 1 ========================2022-12-30 12:44:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'labedu' 0 = labedu Mid = labedu 1 = 명지과학 Mcompany = 명지과학 2 = 101-05-47813 companyNum = 101-05-47813 3 = 02-741-8513 Mtel1 = 02-741-8513 4 = 010-9655-4360 Mhp = 010-9655-4360 ========================2022-12-30 12:44:26======================== select * from customers where id = 'labedu' ========================2022-12-30 12:44:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('labedu','2022-12-30 12:44:26','52500','55000','온라인','0') ========================2022-12-30 12:49:08======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yookil34-1672372080 LGD_BUYER = 황준상 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221230124800 LGD_HASHDATA = c8d703198cd615aa3815f0c97fed8700 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 = 202212301253430A66C4589355204F604BBA6477B0B26AC0AC5E3A Mname = 황준상 Mcompany = 주식회사 육일상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = yookil34 LGD_ESCROW_USEYN = N ========================2022-12-30 12:49:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221230125343 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400380****997* LGD_FINANCEAUTHNUM = 35711543 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b2e4364ae5344a8d1f3eee1ae08dd705 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221230125344 LGD_PCANCELSTR = 0 LGD_BUYER = 황준상 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202212301253437zYa0 LGD_BUYERID = LGD_OID = Direct-yookil34-1672372080 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 01253437aZn5 ========================2022-12-30 12:49:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yookil34-1672372166 LGD_BUYER = 황준상 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221230124926 LGD_HASHDATA = febca437511932e05cfd0be83da9fdad 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 = 20221230125431A5E7D27668CE2660C94F32C8737EDBDB156FA0ED Mname = 황준상 Mcompany = 주식회사 육일상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = yookil34 LGD_ESCROW_USEYN = N ========================2022-12-30 12:49:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221230125431 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400380****997* LGD_FINANCEAUTHNUM = 35724234 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 257e48ce321e59162c7eba50de545c65 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221230125432 LGD_PCANCELSTR = 0 LGD_BUYER = 황준상 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202212301254318Nn57 LGD_BUYERID = LGD_OID = Direct-yookil34-1672372166 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 012543184iq8 ========================2022-12-30 17:48:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mr5457-1672390061 LGD_BUYER = 양인숙 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221230174741 LGD_HASHDATA = 18e33c21abb0b395b05f55df9c9c6ed9 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 = 20221230175325CC8B9457BC08A7EFD05D06931A5C9D7B2E0A05C3 Mname = 양인숙 Mcompany = (주)미래물산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = mr5457 LGD_ESCROW_USEYN = N ========================2022-12-30 17:48:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221230175326 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 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 = 55318440****719* LGD_FINANCEAUTHNUM = 06734319 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 21200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9b7437e9edd03c95ab797b23333cc5e2 LGD_BUYERADDRESS = LGD_FINANCENAME = 하나MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20221230175326 LGD_PCANCELSTR = 0 LGD_BUYER = 양인숙 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof202212301753264FWd3 LGD_BUYERID = LGD_OID = Direct-mr5457-1672390061 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-12-30 17:48:51======================== insert into mBoard_order set rOrdNo = 'Direct-mr5457-1672390061', AuthTy = 'card', memberId = 'mr5457', OrdNm ='양인숙', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)미래물산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '하나MASTER 55318440****719*', rApprNo = 'mjsof202212301753264FWd3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-30 17:48:51', InvoiceNum = '결제성공:Direct-mr5457-1672390061/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-30 17:48:51' ========================2022-12-30 17:48:52======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202212301753264FWd3' 0 = 1 cnt = 1 ========================2022-12-30 17:48:52======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mr5457' 0 = mr5457 Mid = mr5457 1 = (주)미래물산 Mcompany = (주)미래물산 2 = 5148196886 companyNum = 5148196886 3 = 010-3256-9809 Mtel1 = 010-3256-9809 4 = 010-3256-9809 Mhp = 010-3256-9809 ========================2022-12-30 17:48:52======================== select * from customers where id = 'mr5457' ========================2022-12-30 17:48:52======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mr5457','2022-12-30 17:48:51','108000','110000','온라인','0')