========================2024-04-03 08:04:10======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1712098986 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240403080306 LGD_HASHDATA = 15f9f86883c75e64746e9762a0fd45f3 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 = 2024040308095349BA3F4773C04BE2FB598549284098C3C7FB7A29 Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2024-04-03 08:04:11======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240403080953 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 = 94301703****448* LGD_FINANCEAUTHNUM = 47743207 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1a3dafd2f444f25ece08e5a39bf334fa LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240403080954 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2024040308095337mb3 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1712098986 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-04-03 08:04:11======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1712098986', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 94301703****448*', rApprNo = 'mjsof2024040308095337mb3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-04-03 08:04:11', InvoiceNum = '결제성공:Direct-goodssal5707-1712098986/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-04-03 08:04:11' ========================2024-04-03 08:04:11======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2024040308095337mb3' 0 = 1 cnt = 1 ========================2024-04-03 08:04:11======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2024-04-03 08:04:11======================== select * from customers where id = 'goodssal5707' ========================2024-04-03 08:04:11======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2024-04-03 08:04:11','220000','220000','온라인','0') ========================2024-04-03 08:04:58======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1712099060 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240403080420 LGD_HASHDATA = 8d1bc1e8bd79e109a533120573c03112 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 = 202404030810416CF5FC27A8932F81B84B6E75297745F0D3DF2997 Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2024-04-03 08:04:59======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240403081041 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 = 94301703****448* LGD_FINANCEAUTHNUM = 47746631 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d1fe2e9e93d734827a02d4e0d30864c7 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240403081042 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202404030810411Ukj3 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1712099060 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-04-03 08:04:59======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1712099060', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 94301703****448*', rApprNo = 'mjsof202404030810411Ukj3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-04-03 08:04:59', InvoiceNum = '결제성공:Direct-goodssal5707-1712099060/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-04-03 08:04:59' ========================2024-04-03 08:04:59======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202404030810411Ukj3' 0 = 1 cnt = 1 ========================2024-04-03 08:04:59======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2024-04-03 08:04:59======================== select * from customers where id = 'goodssal5707' ========================2024-04-03 08:04:59======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2024-04-03 08:04:59','220000','220000','온라인','0') ========================2024-04-03 09:16:36======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-volume0305-1712103366 LGD_BUYER = 모민수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240403091606 LGD_HASHDATA = d4f53acae6423e6c28de169eb869c303 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 = 20240403092218DAEC36734438690FD8496F23C5F8D2D1D3024681 Mname = 모민수 Mcompany = 충청건재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = volume0305 LGD_ESCROW_USEYN = N ========================2024-04-03 09:16:36======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240403092219 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 = 62436303****674* LGD_FINANCEAUTHNUM = 48161228 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 91800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = cc80d95aad893a49c6db43bb28a35415 LGD_BUYERADDRESS = LGD_FINANCENAME = 농협CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240403092219 LGD_PCANCELSTR = 0 LGD_BUYER = 모민수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202404030922195QE31 LGD_BUYERID = LGD_OID = Direct-volume0305-1712103366 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-04-03 09:16:36======================== insert into mBoard_order set rOrdNo = 'Direct-volume0305-1712103366', AuthTy = 'card', memberId = 'volume0305', OrdNm ='모민수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '충청건재', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '농협CUP 62436303****674*', rApprNo = 'mjsof202404030922195QE31', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-04-03 09:16:36', InvoiceNum = '결제성공:Direct-volume0305-1712103366/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-04-03 09:16:36' ========================2024-04-03 09:16:37======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202404030922195QE31' 0 = 1 cnt = 1 ========================2024-04-03 09:16:37======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'volume0305' 0 = volume0305 Mid = volume0305 1 = 충청건재 Mcompany = 충청건재 2 = 733-15-01592 companyNum = 733-15-01592 3 = 010-2750-8222 Mtel1 = 010-2750-8222 4 = 010-2750-8222 Mhp = 010-2750-8222 ========================2024-04-03 09:16:37======================== select * from customers where id = 'volume0305' ========================2024-04-03 09:16:37======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('volume0305','2024-04-03 09:16:36','10000','11000','온라인','0') ========================2024-04-03 10:08:40======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-joygarden-1712106465 LGD_BUYER = 백성희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240403100745 LGD_HASHDATA = 8a6be4a382da67007380a9dc5ec3a5c6 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 = 20240403101423020B0E64FB12DC595E498B313C4A67CE2C883ED9 Mname = 백성희 Mcompany = (주)조이가든센터 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = joygarden LGD_ESCROW_USEYN = N ========================2024-04-03 10:08:41======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240403101424 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = joyjoy7080@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62641511****295* LGD_FINANCEAUTHNUM = 36476488 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c92bec28ba8f9d683a69083634be7b5f LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240403101424 LGD_PCANCELSTR = 0 LGD_BUYER = 백성희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202404031014230qHB7 LGD_BUYERID = LGD_OID = Direct-joygarden-1712106465 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 31014230lS24 ========================2024-04-03 10:08:41======================== insert into mBoard_order set rOrdNo = 'Direct-joygarden-1712106465', AuthTy = 'card', memberId = 'joygarden', OrdNm ='백성희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)조이가든센터', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨CUP 62641511****295*', rApprNo = 'mjsof202404031014230qHB7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-04-03 10:08:41', InvoiceNum = '결제성공:Direct-joygarden-1712106465/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-04-03 10:08:41' ========================2024-04-03 10:08:41======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202404031014230qHB7' 0 = 1 cnt = 1 ========================2024-04-03 10:08:41======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'joygarden' 0 = joygarden Mid = joygarden 1 = (주)조이가든센터 Mcompany = (주)조이가든센터 2 = 1388179553 companyNum = 1388179553 3 = 02-632-5334 Mtel1 = 02-632-5334 4 = 010-7558-8381 Mhp = 010-7558-8381 ========================2024-04-03 10:08:41======================== select * from customers where id = 'joygarden' ========================2024-04-03 10:08:41======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('joygarden','2024-04-03 10:08:41','108000','110000','온라인','0') ========================2024-04-03 14:40:21======================== res_start ========================2024-04-03 14:40:21======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다. Init_TX(LGD_MID)를 해주시기 바랍니다. 또는 mall.conf 에 상점키가 셋팅되어 있지 않습니다. ========================2024-04-03 14:45:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-myungsin2841-1712122935 LGD_BUYER = 한순옥 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240403144215 LGD_HASHDATA = 27afc64b5462bed6cb213c8a5637ecbe 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 = 20240403145044E3E39010799E9E775449A713629D69032161DBAC Mname = 한순옥 Mcompany = 명신종합상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = myungsin2841 LGD_ESCROW_USEYN = N ========================2024-04-03 14:45:03======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_CARD LGD_BUYERPHONE = LGD_PAYDATE = 20240403145045 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 = 40921703****526* LGD_FINANCEAUTHNUM = 51639904 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 91100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 278afb9d3f741ede0958945ebc0b1d5a LGD_BUYERADDRESS = LGD_FINANCENAME = NH VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240403145046 LGD_PCANCELSTR = 0 LGD_BUYER = 한순옥 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240403145016CIQm0 LGD_BUYERID = LGD_OID = Direct-myungsin2841-1712122935 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-04-03 14:45:03======================== insert into mBoard_order set rOrdNo = 'Direct-myungsin2841-1712122935', AuthTy = 'card', memberId = 'myungsin2841', OrdNm ='한순옥', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '명신종합상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = 'NH VISA 40921703****526*', rApprNo = 'mjsof20240403145016CIQm0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-04-03 14:45:03', InvoiceNum = '결제성공:Direct-myungsin2841-1712122935/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-04-03 14:45:03' ========================2024-04-03 14:45:03======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240403145016CIQm0' 0 = 1 cnt = 1 ========================2024-04-03 14:45:03======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'myungsin2841' 0 = myungsin2841 Mid = myungsin2841 1 = 명신종합상사 Mcompany = 명신종합상사 2 = 3122308786 companyNum = 3122308786 3 = 010-5890-8554 Mtel1 = 010-5890-8554 4 = 010-5890-8554 Mhp = 010-5890-8554 ========================2024-04-03 14:45:03======================== select * from customers where id = 'myungsin2841' ========================2024-04-03 14:45:03======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('myungsin2841','2024-04-03 14:45:03','30900','33000','온라인','0') ========================2024-04-03 15:30:14======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-brothers-1712125746 LGD_BUYER = 조만식 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240403152906 LGD_HASHDATA = bd9717c41705dfe9b39e524fb01871ac 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 = 20240403153557B80E608E56043ED5FB5A22ACF969D6F0482C11FD Mname = 조만식 Mcompany = 주식회사 브라더 리테일 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = brothers LGD_ESCROW_USEYN = N ========================2024-04-03 15:30:14======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240403153557 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = brother-3@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = DAA6B6 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45184445****167* LGD_FINANCEAUTHNUM = 44472470 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ad1c5bb827016ee4a882688a8ad3312c LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240403153558 LGD_PCANCELSTR = 0 LGD_BUYER = 조만식 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240403153557Vquo8 LGD_BUYERID = LGD_OID = Direct-brothers-1712125746 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-04-03 15:30:14======================== insert into mBoard_order set rOrdNo = 'Direct-brothers-1712125746', AuthTy = 'card', memberId = 'brothers', OrdNm ='조만식', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 브라더 리테일', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한VISA 45184445****167*', rApprNo = 'mjsof20240403153557Vquo8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-04-03 15:30:14', InvoiceNum = '결제성공:Direct-brothers-1712125746/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-04-03 15:30:14' ========================2024-04-03 15:30:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240403153557Vquo8' 0 = 1 cnt = 1 ========================2024-04-03 15:30:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'brothers' 0 = brothers Mid = brothers 1 = 주식회사 브라더 리테일 Mcompany = 주식회사 브라더 리테일 2 = 889-81-02638 companyNum = 889-81-02638 3 = 010-9132-2424 Mtel1 = 010-9132-2424 4 = 010-9444-7213 Mhp = 010-9444-7213 ========================2024-04-03 15:30:15======================== select * from customers where id = 'brothers' ========================2024-04-03 15:30:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('brothers','2024-04-03 15:30:14','52500','55000','온라인','0') ========================2024-04-03 16:29:35======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-the0930-1712129296 LGD_BUYER = 조만규 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240403162816 LGD_HASHDATA = af17b9539632bd76c2a0ad00cd9351f8 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 = 20240403163518186E0692203CA926646FDF356FF3896E0A6CF647 Mname = 조만규 Mcompany = (주)더맑음 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = the0930 LGD_ESCROW_USEYN = N ========================2024-04-03 16:29:36======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240403163519 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 834865 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55892098****522* LGD_FINANCEAUTHNUM = 39202340 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 52becdf3e9cfadbb674b8191d6a1957e LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240403163519 LGD_PCANCELSTR = 0 LGD_BUYER = 조만규 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202404031635180i5E2 LGD_BUYERID = LGD_OID = Direct-the0930-1712129296 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 31635180C8n1 ========================2024-04-03 16:29:36======================== insert into mBoard_order set rOrdNo = 'Direct-the0930-1712129296', AuthTy = 'card', memberId = 'the0930', OrdNm ='조만규', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)더맑음', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '우리비씨MASTER 55892098****522*', rApprNo = 'mjsof202404031635180i5E2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-04-03 16:29:36', InvoiceNum = '결제성공:Direct-the0930-1712129296/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-04-03 16:29:36' ========================2024-04-03 16:29:36======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202404031635180i5E2' 0 = 1 cnt = 1 ========================2024-04-03 16:29:36======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'the0930' 0 = the0930 Mid = the0930 1 = (주)더맑음 Mcompany = (주)더맑음 2 = 515-86-02988 companyNum = 515-86-02988 3 = 010-3930-8153 Mtel1 = 010-3930-8153 4 = 010-9269-8402 Mhp = 010-9269-8402 ========================2024-04-03 16:29:36======================== select * from customers where id = 'the0930' ========================2024-04-03 16:29:36======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('the0930','2024-04-03 16:29:36','108000','110000','온라인','0')