========================2023-06-08 10:36:58======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-H00327-1686188131 LGD_BUYER = 문정민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230608103531 LGD_HASHDATA = 9eeb47ac8c52504e0d51d869c5471f3c 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 = 20230608103704D966A8AE08F28D00FABC69749924A0892CB619CD Mname = 문정민 Mcompany = (주)현대비아이디 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = H00327 LGD_ESCROW_USEYN = N ========================2023-06-08 10:36:59======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230608103704 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = DAF9C4 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94108101****282* LGD_FINANCEAUTHNUM = 18630879 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1cb9479da818b18f3aafce48ef465aed LGD_BUYERADDRESS = LGD_FINANCENAME = 신한 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20230608103704 LGD_PCANCELSTR = 0 LGD_BUYER = 문정민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230608103704fHzF3 LGD_BUYERID = LGD_OID = Direct-H00327-1686188131 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-06-08 10:36:59======================== insert into mBoard_order set rOrdNo = 'Direct-H00327-1686188131', AuthTy = 'card', memberId = 'H00327', OrdNm ='문정민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)현대비아이디', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한 94108101****282*', rApprNo = 'mjsof20230608103704fHzF3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-06-08 10:36:59', InvoiceNum = '결제성공:Direct-H00327-1686188131/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-06-08 10:36:59' ========================2023-06-08 10:36:59======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230608103704fHzF3' 0 = 1 cnt = 1 ========================2023-06-08 10:36:59======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'H00327' 0 = h00327 Mid = h00327 1 = (주)현대비아이디 Mcompany = (주)현대비아이디 2 = 6868100327 companyNum = 6868100327 3 = 032-426-3907 Mtel1 = 032-426-3907 4 = 010-6389-2099 Mhp = 010-6389-2099 ========================2023-06-08 10:36:59======================== select * from customers where id = 'H00327' ========================2023-06-08 10:36:59======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('H00327','2023-06-08 10:36:59','220000','220000','온라인','0') ========================2023-06-08 10:37:45======================== res_start ========================2023-06-08 10:37:45======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다. Init_TX(LGD_MID)를 해주시기 바랍니다. 또는 mall.conf 에 상점키가 셋팅되어 있지 않습니다. ========================2023-06-08 11:24:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nhfood-1686190999 LGD_BUYER = 이경림 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230608112319 LGD_HASHDATA = f945245f2b9c06485958db8deed05a54 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 = 20230608112437043F4F21F514DCB95762E6CD8DE7887FB905AE4A Mname = 이경림 Mcompany = 엔에이치푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = nhfood LGD_ESCROW_USEYN = N ========================2023-06-08 11:24:32======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230608112438 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****483* LGD_FINANCEAUTHNUM = 30064339 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f94c15901f415adedb0f4ff7c7545b7c LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230608112438 LGD_PCANCELSTR = 0 LGD_BUYER = 이경림 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230608112437b39I4 LGD_BUYERID = LGD_OID = Direct-nhfood-1686190999 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8112437bpTP1 ========================2023-06-08 11:24:32======================== insert into mBoard_order set rOrdNo = 'Direct-nhfood-1686190999', AuthTy = 'card', memberId = 'nhfood', OrdNm ='이경림', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '엔에이치푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****483*', rApprNo = 'mjsof20230608112437b39I4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-06-08 11:24:32', InvoiceNum = '결제성공:Direct-nhfood-1686190999/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-06-08 11:24:32' ========================2023-06-08 11:24:32======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230608112437b39I4' 0 = 1 cnt = 1 ========================2023-06-08 11:24:32======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nhfood' 0 = nhfood Mid = nhfood 1 = 엔에이치푸드 Mcompany = 엔에이치푸드 2 = 6218198770 companyNum = 6218198770 3 = 055-375-6601 Mtel1 = 055-375-6601 4 = 010-9210-1876 Mhp = 010-9210-1876 ========================2023-06-08 11:24:32======================== select * from customers where id = 'nhfood' ========================2023-06-08 11:24:32======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nhfood','2023-06-08 11:24:32','52500','55000','온라인','0') ========================2023-06-08 13:28:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kog1223-1686198448 LGD_BUYER = 김원귀 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230608132728 LGD_HASHDATA = 34c14abb0c25dca5d253d52518102d12 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 = 202306081328302C91D068CC606300A44B7C2FF5EA65FE82850864 Mname = 김원귀 Mcompany = (주)닭사부 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = kog1223 LGD_ESCROW_USEYN = N ========================2023-06-08 13:28:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230608132831 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 004686 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658692****784* LGD_FINANCEAUTHNUM = 30014798 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5afe99318cb6c9b0f72226b5d33c2dd3 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230608132832 LGD_PCANCELSTR = 0 LGD_BUYER = 김원귀 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230608132831kGZ33 LGD_BUYERID = LGD_OID = Direct-kog1223-1686198448 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8132831k0eb9 ========================2023-06-08 13:28:26======================== insert into mBoard_order set rOrdNo = 'Direct-kog1223-1686198448', AuthTy = 'card', memberId = 'kog1223', OrdNm ='김원귀', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)닭사부', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민VISA 42658692****784*', rApprNo = 'mjsof20230608132831kGZ33', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-06-08 13:28:26', InvoiceNum = '결제성공:Direct-kog1223-1686198448/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-06-08 13:28:26' ========================2023-06-08 13:28:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230608132831kGZ33' 0 = 1 cnt = 1 ========================2023-06-08 13:28:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kog1223' 0 = kog1223 Mid = kog1223 1 = (주)닭사부 Mcompany = (주)닭사부 2 = 6528100417 companyNum = 6528100417 3 = 010-8220-1531 Mtel1 = 010-8220-1531 4 = 010-8220-1531 Mhp = 010-8220-1531 ========================2023-06-08 13:28:26======================== select * from customers where id = 'kog1223' ========================2023-06-08 13:28:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kog1223','2023-06-08 13:28:26','220000','220000','온라인','0') ========================2023-06-08 14:40:02======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kyg2031-1686202678 LGD_BUYER = 김용국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230608143758 LGD_HASHDATA = 7ba9da91fd32ca9c522aeecc63b9b750 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 = 2023060814400841EF9032B5A9DC0AFDB350636CF7E34EF426F6FE Mname = 김용국 Mcompany = (유)성광물산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kyg2031 LGD_ESCROW_USEYN = N ========================2023-06-08 14:40:03======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230608144008 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = 005770 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55353109****738* LGD_FINANCEAUTHNUM = 26264089 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 35200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7a1f1c8e6cdcb4d53d5c85bcd7e71c7f LGD_BUYERADDRESS = LGD_FINANCENAME = 전북MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230608144009 LGD_PCANCELSTR = 0 LGD_BUYER = 김용국 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof20230608144008qnRp3 LGD_BUYERID = LGD_OID = Direct-kyg2031-1686202678 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 081440634219 ========================2023-06-08 14:40:03======================== insert into mBoard_order set rOrdNo = 'Direct-kyg2031-1686202678', AuthTy = 'card', memberId = 'kyg2031', OrdNm ='김용국', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(유)성광물산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '전북MASTER 55353109****738*', rApprNo = 'mjsof20230608144008qnRp3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-06-08 14:40:03', InvoiceNum = '결제성공:Direct-kyg2031-1686202678/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-06-08 14:40:03' ========================2023-06-08 14:40:03======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230608144008qnRp3' 0 = 1 cnt = 1 ========================2023-06-08 14:40:03======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kyg2031' 0 = kyg2031 Mid = kyg2031 1 = (유)성광물산 Mcompany = (유)성광물산 2 = 4018113328 companyNum = 4018113328 3 = 063-442-0360 Mtel1 = 063-442-0360 4 = 010-8987-6747 Mhp = 010-8987-6747 ========================2023-06-08 14:40:03======================== select * from customers where id = 'kyg2031' ========================2023-06-08 14:40:03======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kyg2031','2023-06-08 14:40:03','52500','55000','온라인','0') ========================2023-06-08 14:56:42======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ltweenn-1686203618 LGD_BUYER = (주)벨벳 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230608145338 LGD_HASHDATA = 3d33f96086251de48feb68515f389837 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 = 202306081456483F231459632A25EC90031639DCE81898F0DE91C2 Mname = (주)벨벳 Mcompany = (주)벨벳 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ltweenn LGD_ESCROW_USEYN = N ========================2023-06-08 14:56:43======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230608145648 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 = 41012020****454* LGD_FINANCEAUTHNUM = 36599713 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c39d04dd5655b358c96d45772d685cf1 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230608145648 LGD_PCANCELSTR = 0 LGD_BUYER = (주)벨벳 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230608145648s6q06 LGD_BUYERID = LGD_OID = Direct-ltweenn-1686203618 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-06-08 14:56:43======================== insert into mBoard_order set rOrdNo = 'Direct-ltweenn-1686203618', AuthTy = 'card', memberId = 'ltweenn', OrdNm ='(주)벨벳', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)벨벳', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리비씨VISA 41012020****454*', rApprNo = 'mjsof20230608145648s6q06', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-06-08 14:56:43', InvoiceNum = '결제성공:Direct-ltweenn-1686203618/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-06-08 14:56:43' ========================2023-06-08 14:56:43======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230608145648s6q06' 0 = 1 cnt = 1 ========================2023-06-08 14:56:43======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ltweenn' 0 = ltweenn Mid = ltweenn 1 = (주)벨벳 Mcompany = (주)벨벳 2 = 2128600475 companyNum = 2128600475 3 = 02-478-1440 Mtel1 = 02-478-1440 4 = 010-2743-1484 Mhp = 010-2743-1484 ========================2023-06-08 14:56:43======================== select * from customers where id = 'ltweenn' ========================2023-06-08 14:56:43======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ltweenn','2023-06-08 14:56:43','220000','220000','온라인','0') ========================2023-06-08 17:00:48======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-harry0603-1686211201 LGD_BUYER = 최규윤 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230608170001 LGD_HASHDATA = e3d263df3ebcfa5223656d3ac0e6a0aa 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 = 20230608170053087FFCA54BFC4705ED61666C101C555E5BE283E1 Mname = 최규윤 Mcompany = 한국종합물류 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = harry0603 LGD_ESCROW_USEYN = N ========================2023-06-08 17:00:49======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230608170054 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 328193 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 65413255****080* LGD_FINANCEAUTHNUM = 37660930 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31500 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 00adacbc445aefad3fdc46dac28247b1 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨DINERS LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230608170054 LGD_PCANCELSTR = 0 LGD_BUYER = 최규윤 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230608170054ZSJT1 LGD_BUYERID = LGD_OID = Direct-harry0603-1686211201 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8170054ZjjV1 ========================2023-06-08 17:00:49======================== insert into mBoard_order set rOrdNo = 'Direct-harry0603-1686211201', AuthTy = 'card', memberId = 'harry0603', OrdNm ='최규윤', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '한국종합물류', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨DINERS 65413255****080*', rApprNo = 'mjsof20230608170054ZSJT1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-06-08 17:00:49', InvoiceNum = '결제성공:Direct-harry0603-1686211201/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-06-08 17:00:49' ========================2023-06-08 17:00:49======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230608170054ZSJT1' 0 = 1 cnt = 1 ========================2023-06-08 17:00:49======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'harry0603' 0 = harry0603 Mid = harry0603 1 = 한국종합물류 Mcompany = 한국종합물류 2 = 4191100947 companyNum = 4191100947 3 = 010-4331-0111 Mtel1 = 010-4331-0111 4 = 010-4331-0111 Mhp = 010-4331-0111 ========================2023-06-08 17:00:49======================== select * from customers where id = 'harry0603' ========================2023-06-08 17:00:49======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('harry0603','2023-06-08 17:00:49','220000','220000','온라인','0')