========================2024-05-31 10:21:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sknba-1717118031 LGD_BUYER = 신수진 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240531101351 LGD_HASHDATA = 0a714a249bdd9047cab764a144dfda8a 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 = 202405311022260083B2F330AA8D58CBC0B356FB15283D71C8FCB5 Mname = 신수진 Mcompany = 서광엔비에이(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = sknba LGD_ESCROW_USEYN = N ========================2024-05-31 10:21:52======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240531102227 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = sknba@hanmail.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852695****689* LGD_FINANCEAUTHNUM = 30132852 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ec4790fb0755cb91ec77d61dc37c2420 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240531102227 LGD_PCANCELSTR = 0 LGD_BUYER = 신수진 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240531102227dHqP5 LGD_BUYERID = LGD_OID = Direct-sknba-1717118031 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1102227dXsD1 ========================2024-05-31 10:21:52======================== insert into mBoard_order set rOrdNo = 'Direct-sknba-1717118031', AuthTy = 'card', memberId = 'sknba', OrdNm ='신수진', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '서광엔비에이(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852695****689*', rApprNo = 'mjsof20240531102227dHqP5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-31 10:21:52', InvoiceNum = '결제성공:Direct-sknba-1717118031/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-31 10:21:52' ========================2024-05-31 10:21:52======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240531102227dHqP5' 0 = 1 cnt = 1 ========================2024-05-31 10:21:52======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sknba' 0 = sknba Mid = sknba 1 = 서광엔비에이(주) Mcompany = 서광엔비에이(주) 2 = 1138134090 companyNum = 1138134090 3 = 02-2631-0112 Mtel1 = 02-2631-0112 4 = 010-4142-9515 Mhp = 010-4142-9515 ========================2024-05-31 10:21:52======================== select * from customers where id = 'sknba' ========================2024-05-31 10:21:52======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sknba','2024-05-31 10:21:52','108000','110000','온라인','0') ========================2024-05-31 11:34:38======================== res_start ========================2024-05-31 11:34:38======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다. Init_TX(LGD_MID)를 해주시기 바랍니다. 또는 mall.conf 에 상점키가 셋팅되어 있지 않습니다. ========================2024-05-31 12:57:16======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-cschem2010-1717127515 LGD_BUYER = 안준식 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240531125155 LGD_HASHDATA = d645cfa3a975999dee32b629f48148d3 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 = 2024053112575171A4D8CB3FF2274A4ECCC7FD76F63870EBD833D0 Mname = 안준식 Mcompany = (주)블루마운트 테크놀러지 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = cschem2010 LGD_ESCROW_USEYN = N ========================2024-05-31 12:57:17======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240531125752 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 = 55888100****934* LGD_FINANCEAUTHNUM = 13068712 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 21200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 462c609d6aec2ebacabffeda60c585b5 LGD_BUYERADDRESS = LGD_FINANCENAME = 하나MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20240531125752 LGD_PCANCELSTR = 0 LGD_BUYER = 안준식 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202405311257524fkU6 LGD_BUYERID = LGD_OID = Direct-cschem2010-1717127515 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-05-31 12:57:17======================== insert into mBoard_order set rOrdNo = 'Direct-cschem2010-1717127515', AuthTy = 'card', memberId = 'cschem2010', OrdNm ='안준식', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)블루마운트 테크놀러지', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '하나MASTER 55888100****934*', rApprNo = 'mjsof202405311257524fkU6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-31 12:57:17', InvoiceNum = '결제성공:Direct-cschem2010-1717127515/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-31 12:57:17' ========================2024-05-31 12:57:17======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202405311257524fkU6' 0 = 1 cnt = 1 ========================2024-05-31 12:57:17======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'cschem2010' 0 = cschem2010 Mid = cschem2010 1 = (주)블루마운트 테크놀러지 Mcompany = (주)블루마운트 테크놀러지 2 = 3028101578 companyNum = 3028101578 3 = 043-733-0055 Mtel1 = 043-733-0055 4 = 010-5920-0916 Mhp = 010-5920-0916 ========================2024-05-31 12:57:17======================== select * from customers where id = 'cschem2010' ========================2024-05-31 12:57:17======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('cschem2010','2024-05-31 12:57:17','220000','220000','온라인','0') ========================2024-05-31 13:27:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-boysdream-1717129564 LGD_BUYER = 유현일 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240531132604 LGD_HASHDATA = 9dc5b94da75e93b4aad03a08599d5394 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 = 20240531132754C5161AE11899CACA91EAC9509E7D5F0E4CBF8E9D Mname = 유현일 Mcompany = 유진메디칼 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = boysdream LGD_ESCROW_USEYN = N ========================2024-05-31 13:27:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240531132755 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 = 91000300****928* LGD_FINANCEAUTHNUM = 61754695 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f73b5f5cdbea6c41622276ab2a233f8a LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240531132755 LGD_PCANCELSTR = 0 LGD_BUYER = 유현일 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202405311327558LX84 LGD_BUYERID = LGD_OID = Direct-boysdream-1717129564 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 11327558Cxi6 ========================2024-05-31 13:27:20======================== insert into mBoard_order set rOrdNo = 'Direct-boysdream-1717129564', AuthTy = 'card', memberId = 'boysdream', OrdNm ='유현일', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '유진메디칼', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨 91000300****928*', rApprNo = 'mjsof202405311327558LX84', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-31 13:27:20', InvoiceNum = '결제성공:Direct-boysdream-1717129564/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-31 13:27:20' ========================2024-05-31 13:27:20======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202405311327558LX84' 0 = 1 cnt = 1 ========================2024-05-31 13:27:20======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'boysdream' 0 = boysdream Mid = boysdream 1 = 유진메디칼 Mcompany = 유진메디칼 2 = 7943200090 companyNum = 7943200090 3 = 055-327-0085 Mtel1 = 055-327-0085 4 = 010-3848-8444 Mhp = 010-3848-8444 ========================2024-05-31 13:27:20======================== select * from customers where id = 'boysdream' ========================2024-05-31 13:27:20======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('boysdream','2024-05-31 13:27:20','108000','110000','온라인','0') ========================2024-05-31 14:00:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mbbond-1717131517 LGD_BUYER = 이동훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240531135837 LGD_HASHDATA = 9c8bc91dc1625de25bcf8c7d11490165 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 = 20240531140054D99A6594D243A93814B9A60349B4A23B3F5C5835 Mname = 이동훈 Mcompany = 엠비본드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = mbbond LGD_ESCROW_USEYN = N ========================2024-05-31 14:00:21======================== xpay_res LGD_EASYPAY_TRANTYPE = KAKAOPAY LGD_BUYERPHONE = LGD_PAYDATE = 20240531140056 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 = 475503********** LGD_FINANCEAUTHNUM = 61990729 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 3K000 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4eb9d5ed24f8d8d89d57c305e89a6c74 LGD_BUYERADDRESS = LGD_FINANCENAME = IBK기업 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240531140056 LGD_PCANCELSTR = 0 LGD_BUYER = 이동훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof20240531140008XQMn7 LGD_BUYERID = LGD_OID = Direct-mbbond-1717131517 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-05-31 14:00:21======================== insert into mBoard_order set rOrdNo = 'Direct-mbbond-1717131517', AuthTy = 'card', memberId = 'mbbond', OrdNm ='이동훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '엠비본드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'IBK기업 475503**********', rApprNo = 'mjsof20240531140008XQMn7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-31 14:00:21', InvoiceNum = '결제성공:Direct-mbbond-1717131517/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-31 14:00:21' ========================2024-05-31 14:00:21======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240531140008XQMn7' 0 = 1 cnt = 1 ========================2024-05-31 14:00:21======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mbbond' 0 = mbbond Mid = mbbond 1 = 엠비본드 Mcompany = 엠비본드 2 = 8753500236 companyNum = 8753500236 3 = 010-2848-2883 Mtel1 = 010-2848-2883 4 = 010-2848-2883 Mhp = 010-2848-2883 ========================2024-05-31 14:00:21======================== select * from customers where id = 'mbbond' ========================2024-05-31 14:00:21======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mbbond','2024-05-31 14:00:21','220000','220000','온라인','0') ========================2024-05-31 14:06:45======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bkguys-1717131858 LGD_BUYER = 이현우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240531140418 LGD_HASHDATA = 58e269004c1bc45570c8184cf84c2ccc 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 = 202405311407203FA33B81E4CEABAA04C603CB8FACBEA445344DC5 Mname = 이현우 Mcompany = 봄찬 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = bkguys LGD_ESCROW_USEYN = N ========================2024-05-31 14:06:46======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_CARD LGD_BUYERPHONE = LGD_PAYDATE = 20240531140721 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = bkguys@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_UPAYFLG = U LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 51883100****344* LGD_FINANCEAUTHNUM = 66388705 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 83821d3386f4b502e30114d68c574e6c LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20240531140721 LGD_PCANCELSTR = 0 LGD_BUYER = 이현우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240531140641YAIH7 LGD_BUYERID = LGD_OID = Direct-bkguys-1717131858 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-05-31 14:06:46======================== insert into mBoard_order set rOrdNo = 'Direct-bkguys-1717131858', AuthTy = 'card', memberId = 'bkguys', OrdNm ='이현우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '봄찬', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '삼성MASTER 51883100****344*', rApprNo = 'mjsof20240531140641YAIH7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-31 14:06:46', InvoiceNum = '결제성공:Direct-bkguys-1717131858/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-31 14:06:46' ========================2024-05-31 14:06:46======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240531140641YAIH7' 0 = 1 cnt = 1 ========================2024-05-31 14:06:46======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bkguys' 0 = bkguys Mid = bkguys 1 = 봄찬 Mcompany = 봄찬 2 = 139-62-00780 companyNum = 139-62-00780 3 = 010-5313-9719 Mtel1 = 010-5313-9719 4 = 010-5313-9719 Mhp = 010-5313-9719 ========================2024-05-31 14:06:46======================== select * from customers where id = 'bkguys' ========================2024-05-31 14:06:46======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bkguys','2024-05-31 14:06:46','220000','220000','온라인','0') ========================2024-05-31 15:47:30======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-naeson9-1717137997 LGD_BUYER = 김정희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240531154637 LGD_HASHDATA = 56963b6913783f38510db657902abe48 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 = 20240531154806BCF5F428048C4394921F4969DC926FF30B91B2C3 Mname = 김정희 Mcompany = 주식회사 내손 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = naeson9 LGD_ESCROW_USEYN = N ========================2024-05-31 15:47:31======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240531154807 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****484* LGD_FINANCEAUTHNUM = 30055185 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a6b8353fdf175235c85c15778d2e5614 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240531154807 LGD_PCANCELSTR = 0 LGD_BUYER = 김정희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240531154806bqQM6 LGD_BUYERID = LGD_OID = Direct-naeson9-1717137997 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1154806bNdf7 ========================2024-05-31 15:47:31======================== insert into mBoard_order set rOrdNo = 'Direct-naeson9-1717137997', AuthTy = 'card', memberId = 'naeson9', OrdNm ='김정희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 내손', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****484*', rApprNo = 'mjsof20240531154806bqQM6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-31 15:47:31', InvoiceNum = '결제성공:Direct-naeson9-1717137997/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-31 15:47:31' ========================2024-05-31 15:47:31======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240531154806bqQM6' 0 = 1 cnt = 1 ========================2024-05-31 15:47:31======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'naeson9' 0 = naeson9 Mid = naeson9 1 = 주식회사 내손 Mcompany = 주식회사 내손 2 = companyNum = 3 = 031-462-0944 Mtel1 = 031-462-0944 4 = 010-2229-0959 Mhp = 010-2229-0959 ========================2024-05-31 15:47:31======================== select * from customers where id = 'naeson9' ========================2024-05-31 15:47:31======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('naeson9','2024-05-31 15:47:31','220000','220000','온라인','0') ========================2024-05-31 17:00:18======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kimchnet-1717142321 LGD_BUYER = 김충현 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240531165841 LGD_HASHDATA = b5635ccfabf7ba6db276124434c7eb2d 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 = 20240531170053502C77BDCFC3527BB1A86EDDF208C1207BB12FE1 Mname = 김충현 Mcompany = 정우종합상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = kimchnet LGD_ESCROW_USEYN = N ========================2024-05-31 17:00:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240531170054 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = kimchnet@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 = 45749380****740* LGD_FINANCEAUTHNUM = 00738527 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = da3f8d4e88347f68f039d656ff2ffbe1 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20240531170054 LGD_PCANCELSTR = 0 LGD_BUYER = 김충현 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240531170054aR6q0 LGD_BUYERID = LGD_OID = Direct-kimchnet-1717142321 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-05-31 17:00:18======================== insert into mBoard_order set rOrdNo = 'Direct-kimchnet-1717142321', AuthTy = 'card', memberId = 'kimchnet', OrdNm ='김충현', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '정우종합상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '현대VISA 45749380****740*', rApprNo = 'mjsof20240531170054aR6q0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-31 17:00:18', InvoiceNum = '결제성공:Direct-kimchnet-1717142321/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-31 17:00:18' ========================2024-05-31 17:00:19======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240531170054aR6q0' 0 = 1 cnt = 1 ========================2024-05-31 17:00:19======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kimchnet' 0 = kimchnet Mid = kimchnet 1 = 정우종합상사 Mcompany = 정우종합상사 2 = 307-11-53888 companyNum = 307-11-53888 3 = 010-9289-5964 Mtel1 = 010-9289-5964 4 = 010-9289-5964 Mhp = 010-9289-5964 ========================2024-05-31 17:00:19======================== select * from customers where id = 'kimchnet' ========================2024-05-31 17:00:19======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kimchnet','2024-05-31 17:00:18','10000','11000','온라인','0') ========================2024-05-31 18:05:34======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-davis747-1717146273 LGD_BUYER = 홍연호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240531180433 LGD_HASHDATA = 74d21fbe3e31813f322f1b2e10adbd41 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 = 20240531180609C98E3E5E4CAF9F511F55ABFFD0728F2D55D73A2F Mname = 홍연호 Mcompany = (주)다비스다이아몬드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = davis747 LGD_ESCROW_USEYN = N ========================2024-05-31 18:05:34======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240531180610 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 000000 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658696****764* LGD_FINANCEAUTHNUM = 30056417 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a339c6e033f9d83ab37551b8c57c294d LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240531180610 LGD_PCANCELSTR = 0 LGD_BUYER = 홍연호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202405311806109Vmh9 LGD_BUYERID = LGD_OID = Direct-davis747-1717146273 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 11806109q7R1 ========================2024-05-31 18:05:34======================== insert into mBoard_order set rOrdNo = 'Direct-davis747-1717146273', AuthTy = 'card', memberId = 'davis747', OrdNm ='홍연호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)다비스다이아몬드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민VISA 42658696****764*', rApprNo = 'mjsof202405311806109Vmh9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-31 18:05:34', InvoiceNum = '결제성공:Direct-davis747-1717146273/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-31 18:05:34' ========================2024-05-31 18:05:35======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202405311806109Vmh9' 0 = 1 cnt = 1 ========================2024-05-31 18:05:35======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'davis747' 0 = davis747 Mid = davis747 1 = (주)다비스다이아몬드 Mcompany = (주)다비스다이아몬드 2 = 101-81-80077 companyNum = 101-81-80077 3 = 02-747-1802 Mtel1 = 02-747-1802 4 = 010-7528-2227 Mhp = 010-7528-2227 ========================2024-05-31 18:05:35======================== select * from customers where id = 'davis747' ========================2024-05-31 18:05:35======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('davis747','2024-05-31 18:05:34','108000','110000','온라인','0') ========================2024-05-31 21:29:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ksm03172002-1717158464 LGD_BUYER = 김상만 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240531212744 LGD_HASHDATA = 4a742599b69194172e33c3cbc2dec68e 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 = 20240531213030EE5DDD48CB2BCDAF5D059F4961FCFC86155D15EA Mname = 김상만 Mcompany = 롯데칠성음료수진점(대성음료상사) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = ksm03172002 LGD_ESCROW_USEYN = N ========================2024-05-31 21:29:56======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240531213031 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 = 37029923****52* LGD_FINANCEAUTHNUM = 00434768 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b1c89da90dc4203eae0afbb0221bdb00 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20240531213031 LGD_PCANCELSTR = 0 LGD_BUYER = 김상만 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202405312130318HSu0 LGD_BUYERID = LGD_OID = Direct-ksm03172002-1717158464 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-05-31 21:29:56======================== insert into mBoard_order set rOrdNo = 'Direct-ksm03172002-1717158464', AuthTy = 'card', memberId = 'ksm03172002', OrdNm ='김상만', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '롯데칠성음료수진점(대성음료상사)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대AMEX 37029923****52*', rApprNo = 'mjsof202405312130318HSu0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-31 21:29:56', InvoiceNum = '결제성공:Direct-ksm03172002-1717158464/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-31 21:29:56' ========================2024-05-31 21:29:56======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202405312130318HSu0' 0 = 1 cnt = 1 ========================2024-05-31 21:29:56======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ksm03172002' 0 = ksm03172002 Mid = ksm03172002 1 = 롯데칠성음료수진점(대성음료상사) Mcompany = 롯데칠성음료수진점(대성음료상사) 2 = 1292984340 companyNum = 1292984340 3 = 031-756-7037 Mtel1 = 031-756-7037 4 = 010-2748-0432 Mhp = 010-2748-0432 ========================2024-05-31 21:29:56======================== select * from customers where id = 'ksm03172002' ========================2024-05-31 21:29:56======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ksm03172002','2024-05-31 21:29:56','30900','33000','온라인','0')