========================2023-08-10 04:58:06======================== res_start ========================2023-08-10 04:58:06======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다. Init_TX(LGD_MID)를 해주시기 바랍니다. 또는 mall.conf 에 상점키가 셋팅되어 있지 않습니다. ========================2023-08-10 10:15:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-medicore0295-1691630016 LGD_BUYER = 김혜령 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230810101336 LGD_HASHDATA = 91419b6c49092339c634b8140885d477 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 = 2023081010163153961716F422DDAD33F93085C41306A81B2BA208 Mname = 김혜령 Mcompany = 메디코어 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = medicore0295 LGD_ESCROW_USEYN = N ========================2023-08-10 10:15:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230810101632 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 004651 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94104991****082* LGD_FINANCEAUTHNUM = 30024816 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 80d62152854dc933a269c81abb7b6ef1 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230810101632 LGD_PCANCELSTR = 0 LGD_BUYER = 김혜령 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230810101631yqSA8 LGD_BUYERID = LGD_OID = Direct-medicore0295-1691630016 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0101631y3DN9 ========================2023-08-10 10:15:15======================== insert into mBoard_order set rOrdNo = 'Direct-medicore0295-1691630016', AuthTy = 'card', memberId = 'medicore0295', OrdNm ='김혜령', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '메디코어', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민 94104991****082*', rApprNo = 'mjsof20230810101631yqSA8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-08-10 10:15:15', InvoiceNum = '결제성공:Direct-medicore0295-1691630016/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-08-10 10:15:15' ========================2023-08-10 10:15:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230810101631yqSA8' 0 = 1 cnt = 1 ========================2023-08-10 10:15:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'medicore0295' 0 = medicore0295 Mid = medicore0295 1 = 메디코어 Mcompany = 메디코어 2 = 2062929829 companyNum = 2062929829 3 = 070-4388-9973 Mtel1 = 070-4388-9973 4 = 010-3667-9973 Mhp = 010-3667-9973 ========================2023-08-10 10:15:15======================== select * from customers where id = 'medicore0295' ========================2023-08-10 10:15:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('medicore0295','2023-08-10 10:15:15','52500','55000','온라인','0') ========================2023-08-10 11:32:08======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dhhousing1-1691634701 LGD_BUYER = 서태화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230810113141 LGD_HASHDATA = 2c6a14c61c5d5ba3fb4563232067b325 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 = 202308101133244E0D1B9CA6BDBB4C9F8B806C0F60B537B84ABCC2 Mname = 서태화 Mcompany = (주)디에이치하우징 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = dhhousing1 LGD_ESCROW_USEYN = N ========================2023-08-10 11:32:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230810113325 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 = 41400307****698* LGD_FINANCEAUTHNUM = 33617593 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a26cd0d32da9040ccffe681441d97ae2 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230810113325 LGD_PCANCELSTR = 0 LGD_BUYER = 서태화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230810113324rOzo4 LGD_BUYERID = LGD_OID = Direct-dhhousing1-1691634701 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0113324rwX17 ========================2023-08-10 11:32:09======================== insert into mBoard_order set rOrdNo = 'Direct-dhhousing1-1691634701', AuthTy = 'card', memberId = 'dhhousing1', OrdNm ='서태화', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)디에이치하우징', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨VISA 41400307****698*', rApprNo = 'mjsof20230810113324rOzo4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-08-10 11:32:09', InvoiceNum = '결제성공:Direct-dhhousing1-1691634701/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-08-10 11:32:09' ========================2023-08-10 11:32:09======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230810113324rOzo4' 0 = 1 cnt = 1 ========================2023-08-10 11:32:09======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dhhousing1' 0 = dhhousing1 Mid = dhhousing1 1 = (주)디에이치하우징 Mcompany = (주)디에이치하우징 2 = 1358186545 companyNum = 1358186545 3 = 031-695-5977 Mtel1 = 031-695-5977 4 = 010-5115-1221 Mhp = 010-5115-1221 ========================2023-08-10 11:32:09======================== select * from customers where id = 'dhhousing1' ========================2023-08-10 11:32:09======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dhhousing1','2023-08-10 11:32:09','52500','55000','온라인','0') ========================2023-08-10 11:33:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-lala-1691634769 LGD_BUYER = 박진완 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230810113249 LGD_HASHDATA = 5a092c7d2caf9ea59e235a3ea8d58a36 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 = 202308101135087189DCDC4D5BC2C0DC3901D8DB9F3BEC43F7471D Mname = 박진완 Mcompany = 라라컴퍼니 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = lala LGD_ESCROW_USEYN = N ========================2023-08-10 11:33:52======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230810113509 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658618****282* LGD_FINANCEAUTHNUM = 30031578 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 0b8b5a7c7ca7b982457e80eadd6d3293 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230810113509 LGD_PCANCELSTR = 0 LGD_BUYER = 박진완 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230810113508yBBf7 LGD_BUYERID = LGD_OID = Direct-lala-1691634769 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0113508y7rh9 ========================2023-08-10 11:33:52======================== insert into mBoard_order set rOrdNo = 'Direct-lala-1691634769', AuthTy = 'card', memberId = 'lala', OrdNm ='박진완', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '라라컴퍼니', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '국민VISA 42658618****282*', rApprNo = 'mjsof20230810113508yBBf7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-08-10 11:33:52', InvoiceNum = '결제성공:Direct-lala-1691634769/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-08-10 11:33:52' ========================2023-08-10 11:33:52======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230810113508yBBf7' 0 = 1 cnt = 1 ========================2023-08-10 11:33:52======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'lala' 0 = lala Mid = lala 1 = 라라컴퍼니 Mcompany = 라라컴퍼니 2 = 765-87-01505 companyNum = 765-87-01505 3 = 010-4996-3386 Mtel1 = 010-4996-3386 4 = 010-4996-3386 Mhp = 010-4996-3386 ========================2023-08-10 11:33:52======================== select * from customers where id = 'lala' ========================2023-08-10 11:33:52======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('lala','라라컴퍼니','7658701505','010-4996-3386','010-4996-3386','2023-08-10 11:33:52','온라인') ========================2023-08-10 11:33:52======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('lala','2023-08-10 11:33:52','10000','11000','온라인','0') ========================2023-08-10 15:58:03======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ltweenn-1691650507 LGD_BUYER = (주)벨벳 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230810155507 LGD_HASHDATA = c6f4b580fcd32cde8eca89fca46385ef 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 = 20230810155920C4D00B09EC15B26067E18E6D975E5723EB0389DE 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-08-10 15:58:04======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230810155921 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41012020****445* LGD_FINANCEAUTHNUM = 36929654 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2f6e43c3ffebcd448a8cdba57169b6f9 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230810155921 LGD_PCANCELSTR = 0 LGD_BUYER = (주)벨벳 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230810155921Nx9t9 LGD_BUYERID = LGD_OID = Direct-ltweenn-1691650507 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0155921Ne119 ========================2023-08-10 15:58:04======================== insert into mBoard_order set rOrdNo = 'Direct-ltweenn-1691650507', AuthTy = 'card', memberId = 'ltweenn', OrdNm ='(주)벨벳', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)벨벳', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리비씨VISA 41012020****445*', rApprNo = 'mjsof20230810155921Nx9t9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-08-10 15:58:04', InvoiceNum = '결제성공:Direct-ltweenn-1691650507/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-08-10 15:58:04' ========================2023-08-10 15:58:05======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230810155921Nx9t9' 0 = 1 cnt = 1 ========================2023-08-10 15:58:05======================== 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-08-10 15:58:05======================== select * from customers where id = 'ltweenn' ========================2023-08-10 15:58:05======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ltweenn','2023-08-10 15:58:04','220000','220000','온라인','0') ========================2023-08-10 15:59:45======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-swgy7887-1691650684 LGD_BUYER = (주)현대미디어에이스 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230810155804 LGD_HASHDATA = 0459b27c363982295bcd9aa59d3aed30 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 = 20230810160102790F8FA91DF9FD063186B6FCF52FC06364DA0A85 Mname = (주)현대미디어에이스 Mcompany = 주식회사 현대미디어에이스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = swgy7887 LGD_ESCROW_USEYN = N ========================2023-08-10 15:59:46======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230810160102 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94303213****598* LGD_FINANCEAUTHNUM = 36950320 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5b7e9aff56f5fd3effd71f6a654cae34 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230810160103 LGD_PCANCELSTR = 0 LGD_BUYER = (주)현대미디어에이스 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230810160102sUH22 LGD_BUYERID = LGD_OID = Direct-swgy7887-1691650684 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0160102s6v62 ========================2023-08-10 15:59:46======================== insert into mBoard_order set rOrdNo = 'Direct-swgy7887-1691650684', AuthTy = 'card', memberId = 'swgy7887', OrdNm ='(주)현대미디어에이스', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 현대미디어에이스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 94303213****598*', rApprNo = 'mjsof20230810160102sUH22', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-08-10 15:59:46', InvoiceNum = '결제성공:Direct-swgy7887-1691650684/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-08-10 15:59:46' ========================2023-08-10 15:59:46======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230810160102sUH22' 0 = 1 cnt = 1 ========================2023-08-10 15:59:46======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'swgy7887' 0 = swgy7887 Mid = swgy7887 1 = 주식회사 현대미디어에이스 Mcompany = 주식회사 현대미디어에이스 2 = 609-81-94115 companyNum = 609-81-94115 3 = 070-4618-4426 Mtel1 = 070-4618-4426 4 = 010-6653-6816 Mhp = 010-6653-6816 ========================2023-08-10 15:59:46======================== select * from customers where id = 'swgy7887' ========================2023-08-10 15:59:46======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('swgy7887','2023-08-10 15:59:46','52500','55000','온라인','0') ========================2023-08-10 16:02:26======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-swgy7887-1691650831 LGD_BUYER = (주)현대미디어에이스 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230810160031 LGD_HASHDATA = 1dd4990370d030684293b1c9b337f270 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 = 20230810160343778FB2C98538F6A7456D1D0E1161AE80693E2DE2 Mname = (주)현대미디어에이스 Mcompany = 주식회사 현대미디어에이스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = swgy7887 LGD_ESCROW_USEYN = N ========================2023-08-10 16:02:27======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230810160344 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 고객님의 신용카드 한도가 부족하거나, 체크카드인 경우 통장잔액 부족입니다(1회사용한도초과) LGD_2TR_FLAG = Y LGD_CARDNUM = **************** LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = 4d3b2bd855a9e99de16a73162b7d1d7c LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230810160344 LGD_PCANCELSTR = 부분취소 불가 카드입니다. LGD_BUYER = (주)현대미디어에이스 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230810160343sUZ17 LGD_BUYERID = LGD_OID = Direct-swgy7887-1691650831 LGD_RESPCODE = 0016 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 0 LGD_MID = mjsoft007 LGD_ISPKEY = ========================2023-08-10 16:20:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woo1934-1691651861 LGD_BUYER = 정동인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230810161741 LGD_HASHDATA = 36ec7a2573c66b96daba44786ebdbf39 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 = 20230810162142DEF3CFFFE03DF67C026F92FC6160C32B132D5D8E Mname = 정동인 Mcompany = (주)우진글로벌 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = woo1934 LGD_ESCROW_USEYN = N ========================2023-08-10 16:20:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230810162142 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = woojinglobal@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 = 51055400****369* LGD_FINANCEAUTHNUM = 40663109 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 71200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 709b5661cd6b9240bf607e0c7fbcc9cc LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20230810162143 LGD_PCANCELSTR = 0 LGD_BUYER = 정동인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230810162142ulY26 LGD_BUYERID = LGD_OID = Direct-woo1934-1691651861 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-08-10 16:20:26======================== insert into mBoard_order set rOrdNo = 'Direct-woo1934-1691651861', AuthTy = 'card', memberId = 'woo1934', OrdNm ='정동인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)우진글로벌', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '롯데MASTER 51055400****369*', rApprNo = 'mjsof20230810162142ulY26', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-08-10 16:20:26', InvoiceNum = '결제성공:Direct-woo1934-1691651861/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-08-10 16:20:26' ========================2023-08-10 16:20:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230810162142ulY26' 0 = 1 cnt = 1 ========================2023-08-10 16:20:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woo1934' 0 = woo1934 Mid = woo1934 1 = (주)우진글로벌 Mcompany = (주)우진글로벌 2 = 4038178083 companyNum = 4038178083 3 = 010-8643-1934 Mtel1 = 010-8643-1934 4 = 010-8371-3533 Mhp = 010-8371-3533 ========================2023-08-10 16:20:26======================== select * from customers where id = 'woo1934' ========================2023-08-10 16:20:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woo1934','2023-08-10 16:20:26','220000','220000','온라인','0') ========================2023-08-10 16:36:04======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-we32-1691652701 LGD_BUYER = 이승민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230810163141 LGD_HASHDATA = 7f14c8d758d65c38fd38d88d3305324a 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 = 20230810163720A8AD64BA7BC3865AEA7C2D107B6F881FC1BF229B Mname = 이승민 Mcompany = 승진종합유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = we32 LGD_ESCROW_USEYN = N ========================2023-08-10 16:36:04======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230810163721 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 = 40493380****762* LGD_FINANCEAUTHNUM = 00754082 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7382e18c6085ae6fa8745f61b26b287d LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20230810163721 LGD_PCANCELSTR = 0 LGD_BUYER = 이승민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230810163721dgsK6 LGD_BUYERID = LGD_OID = Direct-we32-1691652701 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-08-10 16:36:04======================== insert into mBoard_order set rOrdNo = 'Direct-we32-1691652701', AuthTy = 'card', memberId = 'we32', OrdNm ='이승민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '승진종합유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대VISA 40493380****762*', rApprNo = 'mjsof20230810163721dgsK6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-08-10 16:36:04', InvoiceNum = '결제성공:Direct-we32-1691652701/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-08-10 16:36:04' ========================2023-08-10 16:36:04======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230810163721dgsK6' 0 = 1 cnt = 1 ========================2023-08-10 16:36:04======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'we32' 0 = we32 Mid = we32 1 = 승진종합유통 Mcompany = 승진종합유통 2 = 2042832170 companyNum = 2042832170 3 = 010-5366-6466 Mtel1 = 010-5366-6466 4 = 010-5366-6466 Mhp = 010-5366-6466 ========================2023-08-10 16:36:04======================== select * from customers where id = 'we32' ========================2023-08-10 16:36:04======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('we32','2023-08-10 16:36:04','30900','33000','온라인','0') ========================2023-08-10 20:59:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-vnem103-1691668678 LGD_BUYER = 엄형섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230810205758 LGD_HASHDATA = 910b0729c96a998f949e3d22900e2489 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 = 20230810210035844407293AAA02EE7BC48633878FC7A479834A7B Mname = 엄형섭 Mcompany = 청아푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = vnem103 LGD_ESCROW_USEYN = N ========================2023-08-10 20:59:19======================== xpay_res LGD_DCNO = DC LGD_BUYERPHONE = LGD_PAYDATE = 20230810210036 LGD_DISCOUNTUSEYN = 1 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 = 37918394****70* LGD_FINANCEAUTHNUM = 32595756 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 51400 LGD_DISCOUNTUSEAMOUNT = 1000 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5c126e3c074dc168a38ff226e755341d LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20230810210036 LGD_PCANCELSTR = 0 LGD_BUYER = 엄형섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230810210036Rmmw4 LGD_BUYERID = LGD_OID = Direct-vnem103-1691668678 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-08-10 20:59:19======================== insert into mBoard_order set rOrdNo = 'Direct-vnem103-1691668678', AuthTy = 'card', memberId = 'vnem103', OrdNm ='엄형섭', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '청아푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '삼성AMEX 37918394****70*', rApprNo = 'mjsof20230810210036Rmmw4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-08-10 20:59:19', InvoiceNum = '결제성공:Direct-vnem103-1691668678/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-08-10 20:59:19' ========================2023-08-10 20:59:20======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230810210036Rmmw4' 0 = 1 cnt = 1 ========================2023-08-10 20:59:20======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'vnem103' 0 = vnem103 Mid = vnem103 1 = 청아푸드 Mcompany = 청아푸드 2 = 4491101928 companyNum = 4491101928 3 = 010-6577-1022 Mtel1 = 010-6577-1022 4 = 010-6577-1022 Mhp = 010-6577-1022 ========================2023-08-10 20:59:20======================== select * from customers where id = 'vnem103' ========================2023-08-10 20:59:20======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('vnem103','2023-08-10 20:59:19','52500','55000','온라인','0')