========================2022-10-05 10:10:26======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bslube-1664932165 LGD_BUYER = 김수영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221005100925 LGD_HASHDATA = 219a11178431348146f1244412445b83 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20221005101325EE5ADAF565E2D1ECF7C5AD17FBDD632CC8E9F105 Mname = 김수영 Mcompany = (주)비에스루브 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = bslube LGD_ESCROW_USEYN = N ========================2022-10-05 10:10:27======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221005101325 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 = 55314200****111* LGD_FINANCEAUTHNUM = 00651374 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f6c6c3cfc152efaed90cfc151112c592 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20221005101326 LGD_PCANCELSTR = 0 LGD_BUYER = 김수영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221005101325NEHt5 LGD_BUYERID = LGD_OID = Direct-bslube-1664932165 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-05 10:10:27======================== insert into mBoard_order set rOrdNo = 'Direct-bslube-1664932165', AuthTy = 'card', memberId = 'bslube', OrdNm ='김수영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)비에스루브', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '현대MASTER 55314200****111*', rApprNo = 'mjsof20221005101325NEHt5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-05 10:10:27', InvoiceNum = '결제성공:Direct-bslube-1664932165/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-05 10:10:27' ========================2022-10-05 10:10:27======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221005101325NEHt5' 0 = 1 cnt = 1 ========================2022-10-05 10:10:27======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bslube' 0 = bslube Mid = bslube 1 = (주)비에스루브 Mcompany = (주)비에스루브 2 = 6178195508 companyNum = 6178195508 3 = 051-646-4163 Mtel1 = 051-646-4163 4 = 010-8514-5189 Mhp = 010-8514-5189 ========================2022-10-05 10:10:27======================== select * from customers where id = 'bslube' ========================2022-10-05 10:10:27======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bslube','2022-10-05 10:10:27','220000','220000','온라인','0') ========================2022-10-05 13:57:22======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-phocos-1664945779 LGD_BUYER = (주)포코스 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221005135619 LGD_HASHDATA = 6d99f7f811422925bca11882f68a597c LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202210051400212DC391AA6E3784C57E1E4DCBC69CA49E4796FCB7 Mname = (주)포코스 Mcompany = (주)포코스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = phocos LGD_ESCROW_USEYN = N ========================2022-10-05 13:57:23======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221005140022 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 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 = 55852693****185* LGD_FINANCEAUTHNUM = 30089044 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d1a4f0aeeb6db3d0a1f5ea793aa6fce7 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20221005140022 LGD_PCANCELSTR = 0 LGD_BUYER = (주)포코스 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221005140021IaRg2 LGD_BUYERID = LGD_OID = Direct-phocos-1664945779 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5140021IYJD9 ========================2022-10-05 13:57:23======================== insert into mBoard_order set rOrdNo = 'Direct-phocos-1664945779', AuthTy = 'card', memberId = 'phocos', OrdNm ='(주)포코스', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)포코스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '국민MASTER 55852693****185*', rApprNo = 'mjsof20221005140021IaRg2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-05 13:57:23', InvoiceNum = '결제성공:Direct-phocos-1664945779/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-05 13:57:23' ========================2022-10-05 13:57:23======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221005140021IaRg2' 0 = 1 cnt = 1 ========================2022-10-05 13:57:23======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'phocos' 0 = phocos Mid = phocos 1 = (주)포코스 Mcompany = (주)포코스 2 = 140-81-22446 companyNum = 140-81-22446 3 = 031-487-1830 Mtel1 = 031-487-1830 4 = 010-6361-4527 Mhp = 010-6361-4527 ========================2022-10-05 13:57:23======================== select * from customers where id = 'phocos' ========================2022-10-05 13:57:23======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('phocos','2022-10-05 13:57:23','30900','33000','온라인','0') ========================2022-10-05 14:56:34======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kjchemi-1664949256 LGD_BUYER = 여기만 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221005145416 LGD_HASHDATA = 5be7892c868c77f729c55acec5a66e3f LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2022100514593440D798D9D24E5658E277B264A7A82CE488387DDB Mname = 여기만 Mcompany = (주)광주케미렌즈 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = kjchemi LGD_ESCROW_USEYN = N ========================2022-10-05 14:56:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221005145934 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = 005005 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45995281****566* LGD_FINANCEAUTHNUM = 45470814 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 46100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9087168bbae3872b1aa8599c5fcb48c8 LGD_BUYERADDRESS = LGD_FINANCENAME = 광주VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221005145935 LGD_PCANCELSTR = 0 LGD_BUYER = 여기만 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof20221005145934gO8M4 LGD_BUYERID = LGD_OID = Direct-kjchemi-1664949256 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 051459692957 ========================2022-10-05 14:56:35======================== insert into mBoard_order set rOrdNo = 'Direct-kjchemi-1664949256', AuthTy = 'card', memberId = 'kjchemi', OrdNm ='여기만', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)광주케미렌즈', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '광주VISA 45995281****566*', rApprNo = 'mjsof20221005145934gO8M4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-05 14:56:35', InvoiceNum = '결제성공:Direct-kjchemi-1664949256/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-05 14:56:35' ========================2022-10-05 14:56:36======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221005145934gO8M4' 0 = 1 cnt = 1 ========================2022-10-05 14:56:36======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kjchemi' 0 = kjchemi Mid = kjchemi 1 = (주)광주케미렌즈 Mcompany = (주)광주케미렌즈 2 = 408-81-78962 companyNum = 408-81-78962 3 = 062-224-9339 Mtel1 = 062-224-9339 4 = 011-622-8419 Mhp = 011-622-8419 ========================2022-10-05 14:56:36======================== select * from customers where id = 'kjchemi' ========================2022-10-05 14:56:36======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kjchemi','2022-10-05 14:56:35','108000','110000','온라인','0') ========================2022-10-05 15:02:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sky6863-1664949624 LGD_BUYER = 엄지원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221005150024 LGD_HASHDATA = 6af1e1f037fd5c5e2b544249581a69c5 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2022100515051913A0B5D52EC4EAE75A8DFAD928F331F089557F87 Mname = 엄지원 Mcompany = (주)제이에스산전 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = sky6863 LGD_ESCROW_USEYN = N ========================2022-10-05 15:02:21======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221005150520 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = jsis2014@bizmeka.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003320 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658691****289* LGD_FINANCEAUTHNUM = 30006302 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 90acfebccf6e833e31329f5fa24c4bc9 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20221005150520 LGD_PCANCELSTR = 0 LGD_BUYER = 엄지원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202210051505208MF93 LGD_BUYERID = LGD_OID = Direct-sky6863-1664949624 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 51505208daw4 ========================2022-10-05 15:02:21======================== insert into mBoard_order set rOrdNo = 'Direct-sky6863-1664949624', AuthTy = 'card', memberId = 'sky6863', OrdNm ='엄지원', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)제이에스산전', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민VISA 42658691****289*', rApprNo = 'mjsof202210051505208MF93', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-05 15:02:21', InvoiceNum = '결제성공:Direct-sky6863-1664949624/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-05 15:02:21' ========================2022-10-05 15:02:21======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202210051505208MF93' 0 = 1 cnt = 1 ========================2022-10-05 15:02:21======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sky6863' 0 = sky6863 Mid = sky6863 1 = (주)제이에스산전 Mcompany = (주)제이에스산전 2 = 6068652595 companyNum = 6068652595 3 = 051-319-0684 Mtel1 = 051-319-0684 4 = 010-2345-5921 Mhp = 010-2345-5921 ========================2022-10-05 15:02:21======================== select * from customers where id = 'sky6863' ========================2022-10-05 15:02:21======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sky6863','2022-10-05 15:02:21','108000','110000','온라인','0') ========================2022-10-05 15:05:58======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1664949909 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221005150509 LGD_HASHDATA = f30317b7c0af951b923856e319108755 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202210051508574852567A107B08F3A52FE0A78DD595ACF3A34CFE Mname = 최경환 Mcompany = (주)매머드커피랩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = mmthcoffee LGD_ESCROW_USEYN = N ========================2022-10-05 15:05:59======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221005150858 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 031095 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300306****798* LGD_FINANCEAUTHNUM = 45532727 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 07dd5b750c2b03a2bee5fa103f3698a6 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221005150858 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221005150857gP4S6 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1664949909 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5150857g1ii8 ========================2022-10-05 15:05:59======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1664949909', AuthTy = 'card', memberId = 'mmthcoffee', OrdNm ='최경환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)매머드커피랩', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 94300306****798*', rApprNo = 'mjsof20221005150857gP4S6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-05 15:05:59', InvoiceNum = '결제성공:Direct-mmthcoffee-1664949909/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-05 15:05:59' ========================2022-10-05 15:05:59======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221005150857gP4S6' 0 = 1 cnt = 1 ========================2022-10-05 15:05:59======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mmthcoffee' 0 = mmthcoffee Mid = mmthcoffee 1 = (주)매머드커피랩 Mcompany = (주)매머드커피랩 2 = 1058779176 companyNum = 1058779176 3 = 031-794-5086 Mtel1 = 031-794-5086 4 = 010-4595-5086 Mhp = 010-4595-5086 ========================2022-10-05 15:05:59======================== select * from customers where id = 'mmthcoffee' ========================2022-10-05 15:05:59======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2022-10-05 15:05:59','220000','220000','온라인','0') ========================2022-10-05 16:26:36======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1664954742 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221005162542 LGD_HASHDATA = f35bdb42fe20ff63d5abad7d9963f762 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20221005162936DFCD3BF9B526D9941096DFC6036CAD92B5CAAEC5 Mname = 최경환 Mcompany = (주)매머드커피랩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = mmthcoffee LGD_ESCROW_USEYN = N ========================2022-10-05 16:26:37======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221005162936 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 031095 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300306****798* LGD_FINANCEAUTHNUM = 46115194 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8a7f2f85adca1bd636bb987b96b3875e LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221005162937 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202210051629368VCP5 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1664954742 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 51629368gqt5 ========================2022-10-05 16:26:37======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1664954742', AuthTy = 'card', memberId = 'mmthcoffee', OrdNm ='최경환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)매머드커피랩', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 94300306****798*', rApprNo = 'mjsof202210051629368VCP5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-05 16:26:37', InvoiceNum = '결제성공:Direct-mmthcoffee-1664954742/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-05 16:26:37' ========================2022-10-05 16:26:37======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202210051629368VCP5' 0 = 1 cnt = 1 ========================2022-10-05 16:26:37======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mmthcoffee' 0 = mmthcoffee Mid = mmthcoffee 1 = (주)매머드커피랩 Mcompany = (주)매머드커피랩 2 = 1058779176 companyNum = 1058779176 3 = 031-794-5086 Mtel1 = 031-794-5086 4 = 010-4595-5086 Mhp = 010-4595-5086 ========================2022-10-05 16:26:37======================== select * from customers where id = 'mmthcoffee' ========================2022-10-05 16:26:37======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2022-10-05 16:26:37','220000','220000','온라인','0')