========================2024-11-07 10:15:57======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-fab9992-1730942108 LGD_BUYER = 신호철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241107101508 LGD_HASHDATA = 4c6bb0fa6b353a9603f2570998e54541 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 = 20241107101934EEDC6CDB47BEE42ACA12E7569314C8998C49FF51 Mname = 신호철 Mcompany = 대도스포츠 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = fab9992 LGD_ESCROW_USEYN = N ========================2024-11-07 10:15:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241107101935 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 004650 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658641****708* LGD_FINANCEAUTHNUM = 30013589 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 066c90deaf65d568d8b4a18b82f4a97e LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20241107101935 LGD_PCANCELSTR = 0 LGD_BUYER = 신호철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241107101934rvud7 LGD_BUYERID = LGD_OID = Direct-fab9992-1730942108 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-11-07 10:15:57======================== insert into mBoard_order set rOrdNo = 'Direct-fab9992-1730942108', AuthTy = 'card', memberId = 'fab9992', OrdNm ='신호철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대도스포츠', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민VISA 42658641****708*', rApprNo = 'mjsof20241107101934rvud7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-07 10:15:57', InvoiceNum = '결제성공:Direct-fab9992-1730942108/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-07 10:15:57' ========================2024-11-07 10:15:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241107101934rvud7' 0 = 1 cnt = 1 ========================2024-11-07 10:15:57======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'fab9992' 0 = fab9992 Mid = fab9992 1 = 대도스포츠 Mcompany = 대도스포츠 2 = 5360302018 companyNum = 5360302018 3 = 02-853-5036 Mtel1 = 02-853-5036 4 = 010-4751-0004 Mhp = 010-4751-0004 ========================2024-11-07 10:15:57======================== select * from customers where id = 'fab9992' ========================2024-11-07 10:15:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('fab9992','2024-11-07 10:15:57','108000','110000','온라인','0') ========================2024-11-07 11:34:57======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-snbfood-1730946684 LGD_BUYER = 임승순 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241107113124 LGD_HASHDATA = dee3264c3beedefae7d1d56151c6fd46 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 = 202411071138353458BE8A547A97270D3F0F41D28BB3488AE95BB0 Mname = 임승순 Mcompany = (주)비에스푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = snbfood LGD_ESCROW_USEYN = N ========================2024-11-07 11:34:58======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241107113836 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 = A8:고객님의 신용카드 한도가 부족하거나, 체크카드인 경우 통장잔액 부족입니다(한도초과 또는 잔액부족) LGD_2TR_FLAG = Y LGD_CARDNUM = 94301604****416* LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d2d4ec6ef8a6eca2612513546b04e814 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20241107113836 LGD_PCANCELSTR = 0 LGD_BUYER = 임승순 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241107113835k48P3 LGD_BUYERID = LGD_OID = Direct-snbfood-1730946684 LGD_RESPCODE = 3000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-11-07 13:39:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nhfood-1730954030 LGD_BUYER = 김성수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241107133350 LGD_HASHDATA = dd7eaca9d40384f0f98d1192f06d1002 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 = 2024110713430552A5BDD1907AA96989AF3DB3EA61B01174AE317E Mname = 김성수 Mcompany = 엔에이치푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = nhfood LGD_ESCROW_USEYN = N ========================2024-11-07 13:39:28======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241107134306 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = foodmi2010@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003320 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****188* LGD_FINANCEAUTHNUM = 30085789 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 672d2d2d28d6c44fbefb49160db584e3 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20241107134306 LGD_PCANCELSTR = 0 LGD_BUYER = 김성수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241107134306bCsv9 LGD_BUYERID = LGD_OID = Direct-nhfood-1730954030 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7134306bsCz3 ========================2024-11-07 13:39:28======================== insert into mBoard_order set rOrdNo = 'Direct-nhfood-1730954030', AuthTy = 'card', memberId = 'nhfood', OrdNm ='김성수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '엔에이치푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****188*', rApprNo = 'mjsof20241107134306bCsv9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-07 13:39:28', InvoiceNum = '결제성공:Direct-nhfood-1730954030/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-07 13:39:28' ========================2024-11-07 13:39:28======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241107134306bCsv9' 0 = 1 cnt = 1 ========================2024-11-07 13:39:28======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nhfood' 0 = nhfood Mid = nhfood 1 = 엔에이치푸드 Mcompany = 엔에이치푸드 2 = 6218198770 companyNum = 6218198770 3 = 055-375-6601 Mtel1 = 055-375-6601 4 = 010-9210-1876 Mhp = 010-9210-1876 ========================2024-11-07 13:39:28======================== select * from customers where id = 'nhfood' ========================2024-11-07 13:39:28======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nhfood','2024-11-07 13:39:28','52500','55000','온라인','0') ========================2024-11-07 13:52:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kog1223-1730955068 LGD_BUYER = 김원귀 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241107135108 LGD_HASHDATA = 7a041ad5fad40e6cbdf2eba6d4f429c2 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 = 2024110713555173CCEDEC97C489B0653FBACAB2A3E3623E4616E8 Mname = 김원귀 Mcompany = (주)닭사부 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = kog1223 LGD_ESCROW_USEYN = N ========================2024-11-07 13:52:14======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241107135552 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 004686 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658692****784* LGD_FINANCEAUTHNUM = 30028322 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 33cc2f37d931f74b15b6b73bea636d40 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20241107135552 LGD_PCANCELSTR = 0 LGD_BUYER = 김원귀 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241107135552l0hZ5 LGD_BUYERID = LGD_OID = Direct-kog1223-1730955068 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7135552l3GB3 ========================2024-11-07 13:52:14======================== insert into mBoard_order set rOrdNo = 'Direct-kog1223-1730955068', AuthTy = 'card', memberId = 'kog1223', OrdNm ='김원귀', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)닭사부', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민VISA 42658692****784*', rApprNo = 'mjsof20241107135552l0hZ5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-07 13:52:14', InvoiceNum = '결제성공:Direct-kog1223-1730955068/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-07 13:52:14' ========================2024-11-07 13:52:14======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241107135552l0hZ5' 0 = 1 cnt = 1 ========================2024-11-07 13:52:14======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kog1223' 0 = kog1223 Mid = kog1223 1 = (주)닭사부 Mcompany = (주)닭사부 2 = 6528100417 companyNum = 6528100417 3 = 010-8220-1531 Mtel1 = 010-8220-1531 4 = 010-8220-1531 Mhp = 010-8220-1531 ========================2024-11-07 13:52:14======================== select * from customers where id = 'kog1223' ========================2024-11-07 13:52:14======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kog1223','2024-11-07 13:52:14','220000','220000','온라인','0') ========================2024-11-07 14:23:57======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-miracl0-1730956985 LGD_BUYER = 박주하 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241107142305 LGD_HASHDATA = 53b4319ec7e912259924571e2cf66da4 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 = 20241107142735373307B4901556430572D8DFDD0A91304A0E51AC Mname = 박주하 Mcompany = 와이피리테일 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = miracl0 LGD_ESCROW_USEYN = N ========================2024-11-07 14:23:58======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241107142736 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 = 41400317****095* LGD_FINANCEAUTHNUM = 62934165 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 16fbd8eb91aaa289ab8692fadf0ff4cd LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20241107142736 LGD_PCANCELSTR = 0 LGD_BUYER = 박주하 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241107142735octX5 LGD_BUYERID = LGD_OID = Direct-miracl0-1730956985 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7142735oKji0 ========================2024-11-07 14:23:58======================== insert into mBoard_order set rOrdNo = 'Direct-miracl0-1730956985', AuthTy = 'card', memberId = 'miracl0', OrdNm ='박주하', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '와이피리테일', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '비씨VISA 41400317****095*', rApprNo = 'mjsof20241107142735octX5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-07 14:23:58', InvoiceNum = '결제성공:Direct-miracl0-1730956985/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-07 14:23:58' ========================2024-11-07 14:23:58======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241107142735octX5' 0 = 1 cnt = 1 ========================2024-11-07 14:23:58======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'miracl0' 0 = miracl0 Mid = miracl0 1 = 와이피리테일 Mcompany = 와이피리테일 2 = 4100652482 companyNum = 4100652482 3 = 010-9936-6658 Mtel1 = 010-9936-6658 4 = 010-9936-6658 Mhp = 010-9936-6658 ========================2024-11-07 14:23:58======================== select * from customers where id = 'miracl0' ========================2024-11-07 14:23:58======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('miracl0','2024-11-07 14:23:58','30900','33000','온라인','0') ========================2024-11-07 15:03:08======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-snbfood-1730959178 LGD_BUYER = 임승순 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241107145938 LGD_HASHDATA = fedf72f6149a00e945bebcb43fddb823 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 = 202411071506465A2647F50EB38800CD87CE4470E98D48B3298087 Mname = 임승순 Mcompany = (주)비에스푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = snbfood LGD_ESCROW_USEYN = N ========================2024-11-07 15:03:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241107150646 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 = 94301604****416* LGD_FINANCEAUTHNUM = 42904824 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5fa697bfc379bbf382dab85c6f6b2595 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20241107150647 LGD_PCANCELSTR = 0 LGD_BUYER = 임승순 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241107150646kxNT5 LGD_BUYERID = LGD_OID = Direct-snbfood-1730959178 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-11-07 15:03:09======================== insert into mBoard_order set rOrdNo = 'Direct-snbfood-1730959178', AuthTy = 'card', memberId = 'snbfood', OrdNm ='임승순', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)비에스푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH 94301604****416*', rApprNo = 'mjsof20241107150646kxNT5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-07 15:03:09', InvoiceNum = '결제성공:Direct-snbfood-1730959178/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-07 15:03:09' ========================2024-11-07 15:03:09======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241107150646kxNT5' 0 = 1 cnt = 1 ========================2024-11-07 15:03:09======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'snbfood' 0 = snbfood Mid = snbfood 1 = (주)비에스푸드 Mcompany = (주)비에스푸드 2 = 4098701740 companyNum = 4098701740 3 = 042-823-6330 Mtel1 = 042-823-6330 4 = 010-5612-3122 Mhp = 010-5612-3122 ========================2024-11-07 15:03:09======================== select * from customers where id = 'snbfood' ========================2024-11-07 15:03:09======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('snbfood','2024-11-07 15:03:09','108000','110000','온라인','0') ========================2024-11-07 15:55:43======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jinsco2277-1730962498 LGD_BUYER = (주)우리유통 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241107155458 LGD_HASHDATA = f11b03e911c5d8517611767d8d30cbae 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 = 20241107155921581AE8BF41C3F815BB33BAE62BF338EC383053B5 Mname = (주)우리유통 Mcompany = (주)우리유통 진스코 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = jinsco2277 LGD_ESCROW_USEYN = N ========================2024-11-07 15:55:44======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241107155921 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41401176****720* LGD_FINANCEAUTHNUM = 63659410 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f77220bfaed15d1c1627bc32dee33aa1 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20241107155922 LGD_PCANCELSTR = 0 LGD_BUYER = (주)우리유통 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202411071559219mq66 LGD_BUYERID = LGD_OID = Direct-jinsco2277-1730962498 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 71559219mHR7 ========================2024-11-07 15:55:44======================== insert into mBoard_order set rOrdNo = 'Direct-jinsco2277-1730962498', AuthTy = 'card', memberId = 'jinsco2277', OrdNm ='(주)우리유통', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)우리유통 진스코', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41401176****720*', rApprNo = 'mjsof202411071559219mq66', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-07 15:55:44', InvoiceNum = '결제성공:Direct-jinsco2277-1730962498/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-07 15:55:44' ========================2024-11-07 15:55:44======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202411071559219mq66' 0 = 1 cnt = 1 ========================2024-11-07 15:55:44======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jinsco2277' 0 = jinsco2277 Mid = jinsco2277 1 = (주)우리유통 진스코 Mcompany = (주)우리유통 진스코 2 = 609-81-01557 companyNum = 609-81-01557 3 = 055-542-2277 Mtel1 = 055-542-2277 4 = 010-8935-4203 Mhp = 010-8935-4203 ========================2024-11-07 15:55:44======================== select * from customers where id = 'jinsco2277' ========================2024-11-07 15:55:44======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jinsco2277','2024-11-07 15:55:44','220000','220000','온라인','0') ========================2024-11-07 18:26:06======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kde26-1730971395 LGD_BUYER = 김영호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241107182315 LGD_HASHDATA = 94032aa7f588edc6629d4a3c44688096 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 = 2024110718294471A308A795A79715A24943056B1F02B7A3F1B2AE Mname = 김영호 Mcompany = 파인enc post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kde26 LGD_ESCROW_USEYN = N ========================2024-11-07 18:26:07======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241107182945 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = kdu04@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 001946 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 52728906****406* LGD_FINANCEAUTHNUM = 30112722 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 2c0a2c3b40aa81452dd8d60ae8fa6b69 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20241107182945 LGD_PCANCELSTR = 0 LGD_BUYER = 김영호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241107182945nbfv5 LGD_BUYERID = LGD_OID = Direct-kde26-1730971395 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-11-07 18:26:07======================== insert into mBoard_order set rOrdNo = 'Direct-kde26-1730971395', AuthTy = 'card', memberId = 'kde26', OrdNm ='김영호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '파인enc', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 52728906****406*', rApprNo = 'mjsof20241107182945nbfv5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-07 18:26:07', InvoiceNum = '결제성공:Direct-kde26-1730971395/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-07 18:26:07' ========================2024-11-07 18:26:07======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241107182945nbfv5' 0 = 1 cnt = 1 ========================2024-11-07 18:26:07======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kde26' 0 = kde26 Mid = kde26 1 = 파인enc Mcompany = 파인enc 2 = 217-07-54724 companyNum = 217-07-54724 3 = 02-994-2561 Mtel1 = 02-994-2561 4 = 010-5398-9976 Mhp = 010-5398-9976 ========================2024-11-07 18:26:07======================== select * from customers where id = 'kde26' ========================2024-11-07 18:26:07======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kde26','2024-11-07 18:26:07','52500','55000','온라인','0') ========================2024-11-07 20:37:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jjk6788-1730979395 LGD_BUYER = 전중근 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241107203635 LGD_HASHDATA = 8fd460bf5108b2e7004539e59d61436a 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 = 20241107204129A8EE24CABE54D4504FC1739C43F80D88DD1A48E4 Mname = 전중근 Mcompany = 동송유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = jjk6788 LGD_ESCROW_USEYN = N ========================2024-11-07 20:37:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241107204129 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 = 45749380****961* LGD_FINANCEAUTHNUM = 00776370 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 420c3c663c153a753d20b6dcab7327cb LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20241107204129 LGD_PCANCELSTR = 0 LGD_BUYER = 전중근 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241107204129gdly8 LGD_BUYERID = LGD_OID = Direct-jjk6788-1730979395 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-11-07 20:37:51======================== insert into mBoard_order set rOrdNo = 'Direct-jjk6788-1730979395', AuthTy = 'card', memberId = 'jjk6788', OrdNm ='전중근', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '동송유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '현대VISA 45749380****961*', rApprNo = 'mjsof20241107204129gdly8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-07 20:37:51', InvoiceNum = '결제성공:Direct-jjk6788-1730979395/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-07 20:37:51' ========================2024-11-07 20:37:52======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241107204129gdly8' 0 = 1 cnt = 1 ========================2024-11-07 20:37:52======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jjk6788' 0 = jjk6788 Mid = jjk6788 1 = 동송유통 Mcompany = 동송유통 2 = 127-40-50704 companyNum = 127-40-50704 3 = 033-455-9624 Mtel1 = 033-455-9624 4 = 010-3823-9624 Mhp = 010-3823-9624 ========================2024-11-07 20:37:52======================== select * from customers where id = 'jjk6788' ========================2024-11-07 20:37:52======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jjk6788','2024-11-07 20:37:51','52500','55000','온라인','0')