========================2023-04-19 10:56:03======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-davis747-1681869302 LGD_BUYER = 홍연호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230419105502 LGD_HASHDATA = e30446b7c467bfebc5ee889f2c31de91 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 = 20230419110239BF0BF7D3FFA9BA068279721AE216721BA7DA919A 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 ========================2023-04-19 10:56:04======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230419110240 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 000000 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658696****764* LGD_FINANCEAUTHNUM = 30053302 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ddd037305344d49ed411dd49c2865036 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230419110240 LGD_PCANCELSTR = 0 LGD_BUYER = 홍연호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230419110239k8319 LGD_BUYERID = LGD_OID = Direct-davis747-1681869302 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 9110239k6JC2 ========================2023-04-19 10:56:04======================== insert into mBoard_order set rOrdNo = 'Direct-davis747-1681869302', 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 = 'mjsof20230419110239k8319', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-04-19 10:56:04', InvoiceNum = '결제성공:Direct-davis747-1681869302/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-04-19 10:56:04' ========================2023-04-19 10:56:04======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230419110239k8319' 0 = 1 cnt = 1 ========================2023-04-19 10:56:04======================== 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 ========================2023-04-19 10:56:04======================== select * from customers where id = 'davis747' ========================2023-04-19 10:56:04======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('davis747','2023-04-19 10:56:04','108000','110000','온라인','0') ========================2023-04-19 16:01:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tlsehvmfkwk-1681887637 LGD_BUYER = 정성희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230419160037 LGD_HASHDATA = 8d8f31c5d3d21c69a83f56f623e6ad05 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 = 20230419160808908F8025B32218A554B2D8A48D8B25BE679DE3AF Mname = 정성희 Mcompany = 신도oa프라자 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = tlsehvmfkwk LGD_ESCROW_USEYN = N ========================2023-04-19 16:01:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230419160809 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55991300****283* LGD_FINANCEAUTHNUM = 00833730 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 50da5e235efbf08b9c02843e5e6723e6 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20230419160809 LGD_PCANCELSTR = 0 LGD_BUYER = 정성희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230419160809DleZ3 LGD_BUYERID = LGD_OID = Direct-tlsehvmfkwk-1681887637 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-04-19 16:01:33======================== insert into mBoard_order set rOrdNo = 'Direct-tlsehvmfkwk-1681887637', AuthTy = 'card', memberId = 'tlsehvmfkwk', OrdNm ='정성희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '신도oa프라자', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '현대MASTER 55991300****283*', rApprNo = 'mjsof20230419160809DleZ3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-04-19 16:01:33', InvoiceNum = '결제성공:Direct-tlsehvmfkwk-1681887637/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-04-19 16:01:33' ========================2023-04-19 16:01:33======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230419160809DleZ3' 0 = 1 cnt = 1 ========================2023-04-19 16:01:33======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'tlsehvmfkwk' 0 = tlsehvmfkwk Mid = tlsehvmfkwk 1 = 신도oa프라자 Mcompany = 신도oa프라자 2 = 608-03-23846 companyNum = 608-03-23846 3 = 055-222-8572 Mtel1 = 055-222-8572 4 = 010-8776-0850 Mhp = 010-8776-0850 ========================2023-04-19 16:01:33======================== select * from customers where id = 'tlsehvmfkwk' ========================2023-04-19 16:01:33======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('tlsehvmfkwk','2023-04-19 16:01:33','220000','220000','온라인','0') ========================2023-04-19 16:44:30======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-soda278-1681890208 LGD_BUYER = 박승완 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230419164328 LGD_HASHDATA = 773ed8a9bc8681f15fdd7199a976ae1d 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 = 20230419165106A4641E6E5308619311706769CAF0E07BB83516FC Mname = 박승완 Mcompany = 하이키한의원 부설 원외탕전 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = soda278 LGD_ESCROW_USEYN = N ========================2023-04-19 16:44:31======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230419165106 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55318440****752* LGD_FINANCEAUTHNUM = 46784913 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 21200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d20cc09c7bd6cfb9dd84938f0965a3fc LGD_BUYERADDRESS = LGD_FINANCENAME = 하나MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20230419165107 LGD_PCANCELSTR = 0 LGD_BUYER = 박승완 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230419165106ALcH5 LGD_BUYERID = LGD_OID = Direct-soda278-1681890208 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-04-19 16:44:31======================== insert into mBoard_order set rOrdNo = 'Direct-soda278-1681890208', AuthTy = 'card', memberId = 'soda278', OrdNm ='박승완', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '하이키한의원 부설 원외탕전', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '하나MASTER 55318440****752*', rApprNo = 'mjsof20230419165106ALcH5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-04-19 16:44:31', InvoiceNum = '결제성공:Direct-soda278-1681890208/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-04-19 16:44:31' ========================2023-04-19 16:44:31======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230419165106ALcH5' 0 = 1 cnt = 1 ========================2023-04-19 16:44:31======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'soda278' 0 = soda278 Mid = soda278 1 = 하이키한의원 부설 원외탕전 Mcompany = 하이키한의원 부설 원외탕전 2 = 1140654544 companyNum = 1140654544 3 = 010-5423-0269 Mtel1 = 010-5423-0269 4 = 010-5423-0269 Mhp = 010-5423-0269 ========================2023-04-19 16:44:31======================== select * from customers where id = 'soda278' ========================2023-04-19 16:44:31======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('soda278','2023-04-19 16:44:31','52500','55000','온라인','0')