========================2025-01-02 10:13:06======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nolbu44-1735780290 LGD_BUYER = 김상철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250102101131 LGD_HASHDATA = 6e4a3815ffc3cdbf3958514c24408131 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 = 202501021014000421D9F1BDA27AE2D2C71D85CFDF19C81BF744EE Mname = 김상철 Mcompany = 인사랑 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = nolbu44 LGD_ESCROW_USEYN = N ========================2025-01-02 10:13:07======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_CARD LGD_BUYERPHONE = LGD_PAYDATE = 20250102101400 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 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 = 94101021****531* LGD_FINANCEAUTHNUM = 58478736 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 51000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9c203d4e86cc93ea15154315270e559c LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20250102101401 LGD_PCANCELSTR = 0 LGD_BUYER = 김상철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250102101339cNH31 LGD_BUYERID = LGD_OID = Direct-nolbu44-1735780290 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-01-02 10:13:07======================== insert into mBoard_order set rOrdNo = 'Direct-nolbu44-1735780290', AuthTy = 'card', memberId = 'nolbu44', OrdNm ='김상철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '인사랑', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '삼성 94101021****531*', rApprNo = 'mjsof20250102101339cNH31', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-02 10:13:07', InvoiceNum = '결제성공:Direct-nolbu44-1735780290/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-02 10:13:07' ========================2025-01-02 10:13:07======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250102101339cNH31' 0 = 1 cnt = 1 ========================2025-01-02 10:13:07======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nolbu44' 0 = nolbu44 Mid = nolbu44 1 = 인사랑 Mcompany = 인사랑 2 = 514-11-55596 companyNum = 514-11-55596 3 = 070-7639-7492 Mtel1 = 070-7639-7492 4 = 010-9300-4001 Mhp = 010-9300-4001 ========================2025-01-02 10:13:07======================== select * from customers where id = 'nolbu44' ========================2025-01-02 10:13:07======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nolbu44','2025-01-02 10:13:07','108000','110000','온라인','0') ========================2025-01-02 13:41:57======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-koryo88-1735792808 LGD_BUYER = 정지원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250102134008 LGD_HASHDATA = 0ac7fbdf8eb20184a9ad22bbace5221d 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 = 2025010213425192ADEFDEF21A2A94B67FE156DFE3D458625445FD Mname = 정지원 Mcompany = 고려종합상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = koryo88 LGD_ESCROW_USEYN = N ========================2025-01-02 13:41:58======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250102134251 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = rhfu5772@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 = 51915700****110* LGD_FINANCEAUTHNUM = 29388816 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 71200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 85617d379f10500a426f147dcf344f20 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20250102134252 LGD_PCANCELSTR = 0 LGD_BUYER = 정지원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202501021342515hf31 LGD_BUYERID = LGD_OID = Direct-koryo88-1735792808 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-01-02 13:41:58======================== insert into mBoard_order set rOrdNo = 'Direct-koryo88-1735792808', AuthTy = 'card', memberId = 'koryo88', OrdNm ='정지원', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '고려종합상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '롯데MASTER 51915700****110*', rApprNo = 'mjsof202501021342515hf31', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-02 13:41:58', InvoiceNum = '결제성공:Direct-koryo88-1735792808/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-02 13:41:58' ========================2025-01-02 13:41:58======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202501021342515hf31' 0 = 1 cnt = 1 ========================2025-01-02 13:41:58======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'koryo88' 0 = koryo88 Mid = koryo88 1 = 고려종합상사 Mcompany = 고려종합상사 2 = 126-15-83670 companyNum = 126-15-83670 3 = 010-9912-5771 Mtel1 = 010-9912-5771 4 = 010-9912-5771 Mhp = 010-9912-5771 ========================2025-01-02 13:41:58======================== select * from customers where id = 'koryo88' ========================2025-01-02 13:41:58======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('koryo88','2025-01-02 13:41:58','108000','110000','온라인','0') ========================2025-01-02 14:13:42======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-wmhyair-1735794781 LGD_BUYER = 김성용 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250102141301 LGD_HASHDATA = 94a2552e75a7afa329494b6e00f78de7 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 = 202501021414364B5ED6B6512DF3E68B4DCFA87E019BCFDB196720 Mname = 김성용 Mcompany = 우민전기유공압 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = wmhyair LGD_ESCROW_USEYN = N ========================2025-01-02 14:13:43======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_CARD LGD_BUYERPHONE = LGD_PAYDATE = 20250102141436 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = woomincorp@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 = 91000300****229* LGD_FINANCEAUTHNUM = 57080801 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ec162ac62b659e9aedc69a0c644e5c1c LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250102141437 LGD_PCANCELSTR = 0 LGD_BUYER = 김성용 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202501021414226vRW6 LGD_BUYERID = LGD_OID = Direct-wmhyair-1735794781 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-01-02 14:13:43======================== insert into mBoard_order set rOrdNo = 'Direct-wmhyair-1735794781', AuthTy = 'card', memberId = 'wmhyair', OrdNm ='김성용', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '우민전기유공압', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 91000300****229*', rApprNo = 'mjsof202501021414226vRW6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-02 14:13:43', InvoiceNum = '결제성공:Direct-wmhyair-1735794781/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-02 14:13:43' ========================2025-01-02 14:13:44======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202501021414226vRW6' 0 = 1 cnt = 1 ========================2025-01-02 14:13:44======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'wmhyair' 0 = wmhyair Mid = wmhyair 1 = 우민전기유공압 Mcompany = 우민전기유공압 2 = 609-07-96108 companyNum = 609-07-96108 3 = 051-831-2345 Mtel1 = 051-831-2345 4 = 011-559-0179 Mhp = 011-559-0179 ========================2025-01-02 14:13:44======================== select * from customers where id = 'wmhyair' ========================2025-01-02 14:13:44======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('wmhyair','2025-01-02 14:13:43','220000','220000','온라인','0') ========================2025-01-02 14:16:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woomin-1735794944 LGD_BUYER = 김성용 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250102141544 LGD_HASHDATA = e80ab7b4beb43232d62211406c0d570c 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 = 202501021417065B5210696440DCB241BEC88787F8D1BE1D84977E Mname = 김성용 Mcompany = 우민전기 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = woomin LGD_ESCROW_USEYN = N ========================2025-01-02 14:16:14======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_CARD LGD_BUYERPHONE = LGD_PAYDATE = 20250102141707 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = woomincorp@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 = 91000300****229* LGD_FINANCEAUTHNUM = 57088044 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2ffbb448acf7f5b72669a8e4f7f148f5 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250102141707 LGD_PCANCELSTR = 0 LGD_BUYER = 김성용 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202501021417007CCA0 LGD_BUYERID = LGD_OID = Direct-woomin-1735794944 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-01-02 14:16:14======================== insert into mBoard_order set rOrdNo = 'Direct-woomin-1735794944', AuthTy = 'card', memberId = 'woomin', OrdNm ='김성용', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '우민전기', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨 91000300****229*', rApprNo = 'mjsof202501021417007CCA0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-02 14:16:14', InvoiceNum = '결제성공:Direct-woomin-1735794944/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-02 14:16:14' ========================2025-01-02 14:16:14======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202501021417007CCA0' 0 = 1 cnt = 1 ========================2025-01-02 14:16:14======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woomin' 0 = woomin Mid = woomin 1 = 우민전기 Mcompany = 우민전기 2 = 6032966520 companyNum = 6032966520 3 = 051-262-6806 Mtel1 = 051-262-6806 4 = 011-262-6801 Mhp = 011-262-6801 ========================2025-01-02 14:16:14======================== select * from customers where id = 'woomin' ========================2025-01-02 14:16:14======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woomin','2025-01-02 14:16:14','108000','110000','온라인','0') ========================2025-01-02 15:24:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-lala-1735798950 LGD_BUYER = 김지환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250102152230 LGD_HASHDATA = 2bb2a86c73c4b1cceb148cafd73527d3 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 = 20250102152510153EE19680501BF99D209805F6A474F0569099EA 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 ========================2025-01-02 15:24:17======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250102152511 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = BA7A3X LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 35690801****786* LGD_FINANCEAUTHNUM = 28344722 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 41300 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 58e2c3516f686c8db769258af0877ced LGD_BUYERADDRESS = LGD_FINANCENAME = 신한JCB LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20250102152511 LGD_PCANCELSTR = 0 LGD_BUYER = 김지환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2025010215251182YR1 LGD_BUYERID = LGD_OID = Direct-lala-1735798950 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-01-02 15:24:17======================== insert into mBoard_order set rOrdNo = 'Direct-lala-1735798950', AuthTy = 'card', memberId = 'lala', OrdNm ='김지환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '라라컴퍼니', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '신한JCB 35690801****786*', rApprNo = 'mjsof2025010215251182YR1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-02 15:24:17', InvoiceNum = '결제성공:Direct-lala-1735798950/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-02 15:24:17' ========================2025-01-02 15:24:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2025010215251182YR1' 0 = 1 cnt = 1 ========================2025-01-02 15:24:18======================== 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 ========================2025-01-02 15:24:18======================== select * from customers where id = 'lala' ========================2025-01-02 15:24:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('lala','2025-01-02 15:24:17','10000','11000','온라인','0') ========================2025-01-02 16:06:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-chul9999-1735801451 LGD_BUYER = 김현철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250102160411 LGD_HASHDATA = 93e590ca0760b8ebeacaed26637cce04 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 = 2025010216070798971D6FF928E0ED278309BBA7517D2DA7CB979A Mname = 김현철 Mcompany = 새청푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = chul9999 LGD_ESCROW_USEYN = N ========================2025-01-02 16:06:14======================== xpay_res LGD_DCNO = DC LGD_BUYERPHONE = LGD_PAYDATE = 20250102160707 LGD_DISCOUNTUSEYN = 1 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 = 94100900****107* LGD_FINANCEAUTHNUM = 59718095 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 51000 LGD_DISCOUNTUSEAMOUNT = 1000 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c7001a9082ae5e4057cf62ba8456e154 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20250102160707 LGD_PCANCELSTR = 0 LGD_BUYER = 김현철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202501021607071e0n9 LGD_BUYERID = LGD_OID = Direct-chul9999-1735801451 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-01-02 16:06:14======================== insert into mBoard_order set rOrdNo = 'Direct-chul9999-1735801451', AuthTy = 'card', memberId = 'chul9999', OrdNm ='김현철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '새청푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '삼성 94100900****107*', rApprNo = 'mjsof202501021607071e0n9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-02 16:06:14', InvoiceNum = '결제성공:Direct-chul9999-1735801451/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-02 16:06:14' ========================2025-01-02 16:06:14======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202501021607071e0n9' 0 = 1 cnt = 1 ========================2025-01-02 16:06:14======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'chul9999' 0 = chul9999 Mid = chul9999 1 = 새청푸드 Mcompany = 새청푸드 2 = 6691600227 companyNum = 6691600227 3 = 033-257-0104 Mtel1 = 033-257-0104 4 = 010-5365-4668 Mhp = 010-5365-4668 ========================2025-01-02 16:06:14======================== select * from customers where id = 'chul9999' ========================2025-01-02 16:06:14======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('chul9999','2025-01-02 16:06:14','52500','55000','온라인','0') ========================2025-01-02 19:49:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-galliot2-1735814797 LGD_BUYER = 신현기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250102194637 LGD_HASHDATA = 0d52ed1a834a4d3711f78dae44ea55c9 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 = 20250102195013B3D3F13A1B43880F8DA527B26B6DB3DA8A871988 Mname = 신현기 Mcompany = 주식회사 유성푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = galliot2 LGD_ESCROW_USEYN = N ========================2025-01-02 19:49:21======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_POINT LGD_BUYERPHONE = LGD_PAYDATE = 20250102195015 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 = receiptSelf = N LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 098 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = eaeda35c057b4e5223374a93648134ac LGD_BUYERADDRESS = receiptKind = 1 LGD_FINANCENAME = 네이버페이 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = LGD_DEVICE = LGD_TIMESTAMP = 20250102195015 LGD_PCANCELSTR = 0 LGD_BUYER = 신현기 LGD_CARDINSTALLMONTH = LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof202501021949305qdr3 LGD_BUYERID = LGD_OID = Direct-galliot2-1735814797 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-01-02 19:49:21======================== insert into mBoard_order set rOrdNo = 'Direct-galliot2-1735814797', AuthTy = 'card', memberId = 'galliot2', OrdNm ='신현기', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 유성푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '네이버페이 ', rApprNo = 'mjsof202501021949305qdr3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-02 19:49:21', InvoiceNum = '결제성공:Direct-galliot2-1735814797/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-02 19:49:21' ========================2025-01-02 19:49:21======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202501021949305qdr3' 0 = 1 cnt = 1 ========================2025-01-02 19:49:21======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'galliot2' 0 = galliot2 Mid = galliot2 1 = 주식회사 유성푸드 Mcompany = 주식회사 유성푸드 2 = 5698601803 companyNum = 5698601803 3 = 061-243-4961 Mtel1 = 061-243-4961 4 = 010-6877-4961 Mhp = 010-6877-4961 ========================2025-01-02 19:49:21======================== select * from customers where id = 'galliot2' ========================2025-01-02 19:49:21======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('galliot2','2025-01-02 19:49:21','108000','110000','온라인','0') ========================2025-01-02 19:49:22======================== res_start ========================2025-01-02 19:49:22======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다. ========================2025-01-02 22:11:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nolbu44-1735823431 LGD_BUYER = 김상철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250102221031 LGD_HASHDATA = 9f05505cb6d7adaea0a5ac931c1d44cf 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 = 20250102221211E565F8DD66C86753EF955DCCC89F3D28A656D0F3 Mname = 김상철 Mcompany = 노코딩팜 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = nolbu44 LGD_ESCROW_USEYN = N ========================2025-01-02 22:11:18======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_CARD LGD_BUYERPHONE = LGD_PAYDATE = 20250102221212 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 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 = 45184214****397* LGD_FINANCEAUTHNUM = 33112575 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = eb434daa1900111a30bdb685b1f11c8e LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20250102221212 LGD_PCANCELSTR = 0 LGD_BUYER = 김상철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202501022211586zFC8 LGD_BUYERID = LGD_OID = Direct-nolbu44-1735823431 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-01-02 22:11:18======================== insert into mBoard_order set rOrdNo = 'Direct-nolbu44-1735823431', AuthTy = 'card', memberId = 'nolbu44', OrdNm ='김상철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '노코딩팜', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한VISA 45184214****397*', rApprNo = 'mjsof202501022211586zFC8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-02 22:11:18', InvoiceNum = '결제성공:Direct-nolbu44-1735823431/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-02 22:11:18' ========================2025-01-02 22:11:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202501022211586zFC8' 0 = 1 cnt = 1 ========================2025-01-02 22:11:18======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nolbu44' 0 = nolbu44 Mid = nolbu44 1 = 인사랑 Mcompany = 인사랑 2 = 514-11-55596 companyNum = 514-11-55596 3 = 070-7639-7492 Mtel1 = 070-7639-7492 4 = 010-9300-4001 Mhp = 010-9300-4001 ========================2025-01-02 22:11:18======================== select * from customers where id = 'nolbu44' ========================2025-01-02 22:11:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nolbu44','2025-01-02 22:11:18','52500','55000','온라인','0')