========================2023-07-03 10:39:47======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-rim5534-1688348260 LGD_BUYER = 임동환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230703103740 LGD_HASHDATA = 59d71752e7f4578163f906070186b89d 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 = 20230703104020091A01A5D537D0A76D3FBAB9B15CA075B4380274 Mname = 임동환 Mcompany = 메인미디어 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = rim5534 LGD_ESCROW_USEYN = N ========================2023-07-03 10:39:48======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230703104021 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62641507****292* LGD_FINANCEAUTHNUM = 41764249 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = db77751ff6a44e970302c03482b3e134 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230703104021 LGD_PCANCELSTR = 0 LGD_BUYER = 임동환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2023070310402120k66 LGD_BUYERID = LGD_OID = Direct-rim5534-1688348260 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 31040212chI6 ========================2023-07-03 10:39:48======================== insert into mBoard_order set rOrdNo = 'Direct-rim5534-1688348260', AuthTy = 'card', memberId = 'rim5534', OrdNm ='임동환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '메인미디어', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨CUP 62641507****292*', rApprNo = 'mjsof2023070310402120k66', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-07-03 10:39:48', InvoiceNum = '결제성공:Direct-rim5534-1688348260/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-07-03 10:39:48' ========================2023-07-03 10:39:48======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2023070310402120k66' 0 = 1 cnt = 1 ========================2023-07-03 10:39:48======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'rim5534' 0 = rim5534 Mid = rim5534 1 = 메인미디어 Mcompany = 메인미디어 2 = 7588102028 companyNum = 7588102028 3 = 062-222-7440 Mtel1 = 062-222-7440 4 = 010-7155-7900 Mhp = 010-7155-7900 ========================2023-07-03 10:39:48======================== select * from customers where id = 'rim5534' ========================2023-07-03 10:39:48======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('rim5534','2023-07-03 10:39:48','220000','220000','온라인','0') ========================2023-07-03 15:12:41======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-samwoo406-1688364647 LGD_BUYER = 곽노석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230703151047 LGD_HASHDATA = 9ba3b93189006919d7fd9172f5e5c9f7 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 = 20230703151315B4ED4FD4594E3D00BB7F76260204587F5E8E2BF9 Mname = 곽노석 Mcompany = 삼우건기 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = samwoo406 LGD_ESCROW_USEYN = N ========================2023-07-03 15:12:42======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230703151315 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 396C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94118100****115* LGD_FINANCEAUTHNUM = 15794155 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 21000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 246ac443a1cfd235c9b9921bf7212675 LGD_BUYERADDRESS = LGD_FINANCENAME = 하나 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20230703151316 LGD_PCANCELSTR = 0 LGD_BUYER = 곽노석 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202307031513153tJg2 LGD_BUYERID = LGD_OID = Direct-samwoo406-1688364647 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-07-03 15:12:42======================== insert into mBoard_order set rOrdNo = 'Direct-samwoo406-1688364647', AuthTy = 'card', memberId = 'samwoo406', OrdNm ='곽노석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '삼우건기', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '하나 94118100****115*', rApprNo = 'mjsof202307031513153tJg2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-07-03 15:12:42', InvoiceNum = '결제성공:Direct-samwoo406-1688364647/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-07-03 15:12:42' ========================2023-07-03 15:12:42======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202307031513153tJg2' 0 = 1 cnt = 1 ========================2023-07-03 15:12:42======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'samwoo406' 0 = samwoo406 Mid = samwoo406 1 = 삼우건기 Mcompany = 삼우건기 2 = 406-29-00456 companyNum = 406-29-00456 3 = 010-3753-9095 Mtel1 = 010-3753-9095 4 = 010-3753-9095 Mhp = 010-3753-9095 ========================2023-07-03 15:12:42======================== select * from customers where id = 'samwoo406' ========================2023-07-03 15:12:42======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('samwoo406','2023-07-03 15:12:42','220000','220000','온라인','0') ========================2023-07-03 15:28:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-azfoods01-1688365696 LGD_BUYER = 박정운 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230703152816 LGD_HASHDATA = 73b9196efc863eb3b1e403ae5c371834 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 = 20230703152924CB4421C28521013B227B1AFEE58A66FAAC6F0207 Mname = 박정운 Mcompany = (주)에이젯푸즈 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = azfoods01 LGD_ESCROW_USEYN = N ========================2023-07-03 15:28:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230703152925 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = azfoods@chol.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852637****282* LGD_FINANCEAUTHNUM = 30019497 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c851980c2c6ca24ee6f9487cf5d801cf LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230703152925 LGD_PCANCELSTR = 0 LGD_BUYER = 박정운 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230703152925frFM8 LGD_BUYERID = LGD_OID = Direct-azfoods01-1688365696 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3152925fBZK6 ========================2023-07-03 15:28:51======================== insert into mBoard_order set rOrdNo = 'Direct-azfoods01-1688365696', AuthTy = 'card', memberId = 'azfoods01', OrdNm ='박정운', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)에이젯푸즈', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852637****282*', rApprNo = 'mjsof20230703152925frFM8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-07-03 15:28:51', InvoiceNum = '결제성공:Direct-azfoods01-1688365696/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-07-03 15:28:51' ========================2023-07-03 15:28:52======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230703152925frFM8' 0 = 1 cnt = 1 ========================2023-07-03 15:28:52======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'azfoods01' 0 = azfoods01 Mid = azfoods01 1 = (주)에이젯푸즈 Mcompany = (주)에이젯푸즈 2 = 4098625143 companyNum = 4098625143 3 = 062-524-0600 Mtel1 = 062-524-0600 4 = 010-7177-8486 Mhp = 010-7177-8486 ========================2023-07-03 15:28:52======================== select * from customers where id = 'azfoods01' ========================2023-07-03 15:28:52======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('azfoods01','2023-07-03 15:28:51','108000','110000','온라인','0') ========================2023-07-03 19:19:16======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-rnfmadk0-1688379157 LGD_BUYER = 이장석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230703191237 LGD_HASHDATA = dcc1a6b3e2b5b08a5d85ae9f58eee637 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 = 202307031919505654FE58A94FC6D86BD40078B7675B04B409ED33 Mname = 이장석 Mcompany = 샬롬유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = rnfmadk0 LGD_ESCROW_USEYN = N ========================2023-07-03 19:19:17======================== xpay_res LGD_DCNO = DC LGD_BUYERPHONE = LGD_PAYDATE = 20230703191951 LGD_DISCOUNTUSEYN = 1 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 = 94108524****000* LGD_FINANCEAUTHNUM = 94780429 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 51000 LGD_DISCOUNTUSEAMOUNT = 1500 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = cf88c02c8a8b7054d45eeba8f7a514bd LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20230703191951 LGD_PCANCELSTR = 0 LGD_BUYER = 이장석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230703191951oeAZ9 LGD_BUYERID = LGD_OID = Direct-rnfmadk0-1688379157 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-07-03 19:19:17======================== insert into mBoard_order set rOrdNo = 'Direct-rnfmadk0-1688379157', AuthTy = 'card', memberId = 'rnfmadk0', OrdNm ='이장석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '샬롬유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '삼성 94108524****000*', rApprNo = 'mjsof20230703191951oeAZ9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-07-03 19:19:17', InvoiceNum = '결제성공:Direct-rnfmadk0-1688379157/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-07-03 19:19:17' ========================2023-07-03 19:19:17======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230703191951oeAZ9' 0 = 1 cnt = 1 ========================2023-07-03 19:19:17======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'rnfmadk0' 0 = rnfmadk0 Mid = rnfmadk0 1 = 샬롬유통 Mcompany = 샬롬유통 2 = 2098801550 companyNum = 2098801550 3 = 02-6448-3940 Mtel1 = 02-6448-3940 4 = 010-2215-3940 Mhp = 010-2215-3940 ========================2023-07-03 19:19:17======================== select * from customers where id = 'rnfmadk0' ========================2023-07-03 19:19:17======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('rnfmadk0','2023-07-03 19:19:17','108000','110000','온라인','0')