========================2024-05-03 05:47:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ksjinju-1714682674 LGD_BUYER = 양경호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240503054434 LGD_HASHDATA = 2d364d43ca11ec1cab3eb34e7ab089c1 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 = 20240503054722F11C1AE9B03FB31D2E81C41B764FEEFA29464C44 Mname = 양경호 Mcompany = 국신필터 진주영업소 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = ksjinju LGD_ESCROW_USEYN = N ========================2024-05-03 05:47:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240503054723 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = AFA00A LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 35629746****841* LGD_FINANCEAUTHNUM = 38939077 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 41300 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 37772bfb06b4f309fc02dd4ee5d982c7 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한JCB LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240503054723 LGD_PCANCELSTR = 0 LGD_BUYER = 양경호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202405030547232zwF5 LGD_BUYERID = LGD_OID = Direct-ksjinju-1714682674 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-05-03 05:47:20======================== insert into mBoard_order set rOrdNo = 'Direct-ksjinju-1714682674', AuthTy = 'card', memberId = 'ksjinju', OrdNm ='양경호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '국신필터 진주영업소', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '신한JCB 35629746****841*', rApprNo = 'mjsof202405030547232zwF5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-03 05:47:20', InvoiceNum = '결제성공:Direct-ksjinju-1714682674/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-03 05:47:20' ========================2024-05-03 05:47:20======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202405030547232zwF5' 0 = 1 cnt = 1 ========================2024-05-03 05:47:20======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ksjinju' 0 = ksjinju Mid = ksjinju 1 = 국신필터 진주영업소 Mcompany = 국신필터 진주영업소 2 = 6131934104 companyNum = 6131934104 3 = 010-4754-7898 Mtel1 = 010-4754-7898 4 = 010-3526-5125 Mhp = 010-3526-5125 ========================2024-05-03 05:47:20======================== select * from customers where id = 'ksjinju' ========================2024-05-03 05:47:20======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ksjinju','2024-05-03 05:47:20','30900','33000','온라인','0') ========================2024-05-03 08:42:14======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1714693271 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240503084111 LGD_HASHDATA = b1643777644d9658d427e6928bf25fe5 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 = 20240503084217DFE4E12EC855BDC657B05688327643E9C634FB13 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-05-03 08:42:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240503084218 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 = 94301703****448* LGD_FINANCEAUTHNUM = 42697607 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d78ef048d3d3351e23240f4dcf9c82b8 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240503084219 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202405030842183fnF7 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1714693271 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-05-03 08:42:15======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1714693271', 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 = 'mjsof202405030842183fnF7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-03 08:42:15', InvoiceNum = '결제성공:Direct-goodssal5707-1714693271/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-03 08:42:15' ========================2024-05-03 08:42:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202405030842183fnF7' 0 = 1 cnt = 1 ========================2024-05-03 08:42:15======================== 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-05-03 08:42:15======================== select * from customers where id = 'goodssal5707' ========================2024-05-03 08:42:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2024-05-03 08:42:15','220000','220000','온라인','0') ========================2024-05-03 08:43:05======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1714693346 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240503084226 LGD_HASHDATA = 2495b939c4738c8b54c2049b16b1a6fc 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 = 20240503084308ADDB81F8E36445EB940925D0282AC5B7D8D78C57 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-05-03 08:43:06======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240503084308 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 = 94301703****448* LGD_FINANCEAUTHNUM = 42702937 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 694d7a6a1d4fe0f7bffa1cdedfa8d2c8 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240503084309 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240503084308aFCv1 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1714693346 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-05-03 08:43:06======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1714693346', 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 = 'mjsof20240503084308aFCv1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-03 08:43:06', InvoiceNum = '결제성공:Direct-goodssal5707-1714693346/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-03 08:43:06' ========================2024-05-03 08:43:06======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240503084308aFCv1' 0 = 1 cnt = 1 ========================2024-05-03 08:43:06======================== 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-05-03 08:43:06======================== select * from customers where id = 'goodssal5707' ========================2024-05-03 08:43:06======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2024-05-03 08:43:06','220000','220000','온라인','0') ========================2024-05-03 10:31:52======================== res_start ========================2024-05-03 10:31:52======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다. Init_TX(LGD_MID)를 해주시기 바랍니다. 또는 mall.conf 에 상점키가 셋팅되어 있지 않습니다. ========================2024-05-03 10:55:48======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-joj0295-1714701301 LGD_BUYER = 주강규 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240503105501 LGD_HASHDATA = 1a52e13310f050b2ea9184e186a000c4 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 = 202405031055518C2A9AED6043ED618AE2127839AE3E12819BDF85 Mname = 주강규 Mcompany = 주식회사 제이오제이 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = joj0295 LGD_ESCROW_USEYN = N ========================2024-05-03 10:55:48======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240503105552 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 = 55852694****186* LGD_FINANCEAUTHNUM = 30109359 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 0aac76ceae36b9d57771f69aabe46687 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240503105552 LGD_PCANCELSTR = 0 LGD_BUYER = 주강규 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240503105552a0ON9 LGD_BUYERID = LGD_OID = Direct-joj0295-1714701301 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3105552aRaP3 ========================2024-05-03 10:55:48======================== insert into mBoard_order set rOrdNo = 'Direct-joj0295-1714701301', AuthTy = 'card', memberId = 'joj0295', OrdNm ='주강규', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 제이오제이', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****186*', rApprNo = 'mjsof20240503105552a0ON9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-03 10:55:48', InvoiceNum = '결제성공:Direct-joj0295-1714701301/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-03 10:55:48' ========================2024-05-03 10:55:49======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240503105552a0ON9' 0 = 1 cnt = 1 ========================2024-05-03 10:55:49======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'joj0295' 0 = joj0295 Mid = joj0295 1 = 주식회사 제이오제이 Mcompany = 주식회사 제이오제이 2 = 2058141890 companyNum = 2058141890 3 = 070-4388-9973 Mtel1 = 070-4388-9973 4 = 010-3667-9973 Mhp = 010-3667-9973 ========================2024-05-03 10:55:49======================== select * from customers where id = 'joj0295' ========================2024-05-03 10:55:49======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('joj0295','2024-05-03 10:55:48','108000','110000','온라인','0') ========================2024-05-03 14:04:48======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1714712647 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240503140407 LGD_HASHDATA = 7850110998422a862dbdf3645e228aa6 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 = 202405031404513DC563787CFDBFEDD69F5B8D5651EEBFB20C7CA5 Mname = 최경환 Mcompany = (주)매머드커피랩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = tax@mmth.co.kr UserId = mmthcoffee LGD_ESCROW_USEYN = N ========================2024-05-03 14:04:48======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240503140452 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = tax@mmth.co.kr LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400315****092* LGD_FINANCEAUTHNUM = 40287232 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4a80c52c2ac636504d48e8f15adbadf7 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240503140452 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0012 LGD_TID = mjsof2024050314045143qn7 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1714712647 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 31404514DKl9 ========================2024-05-03 14:04:48======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1714712647', AuthTy = 'card', memberId = 'mmthcoffee', OrdNm ='최경환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)매머드커피랩', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41400315****092*', rApprNo = 'mjsof2024050314045143qn7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-03 14:04:48', InvoiceNum = '결제성공:Direct-mmthcoffee-1714712647/0000', Deliver = '', senditem = 'tax@mmth.co.kr', salestopvalue = '', mod_date = '2024-05-03 14:04:48' ========================2024-05-03 14:04:49======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2024050314045143qn7' 0 = 1 cnt = 1 ========================2024-05-03 14:04:49======================== 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 ========================2024-05-03 14:04:49======================== select * from customers where id = 'mmthcoffee' ========================2024-05-03 14:04:49======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2024-05-03 14:04:48','220000','220000','온라인','0') ========================2024-05-03 14:25:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-blueseafood2-1714713708 LGD_BUYER = 곽동원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240503142149 LGD_HASHDATA = 0bedbd0d7ec9b7a848795b1eeeee85e8 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 = 20240503142558C5B2AFEC60BAEA02C582E26337FAA995F922B359 Mname = 곽동원 Mcompany = (주)블루씨푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = blueseafood2 LGD_ESCROW_USEYN = N ========================2024-05-03 14:25:56======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240503142559 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 244581 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41012020****747* LGD_FINANCEAUTHNUM = 40606276 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f0697014b5c4b7d4b6716cdd09e7f9a5 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240503142600 LGD_PCANCELSTR = 0 LGD_BUYER = 곽동원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2024050314255946855 LGD_BUYERID = LGD_OID = Direct-blueseafood2-1714713708 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 31425594Exj5 ========================2024-05-03 14:25:56======================== insert into mBoard_order set rOrdNo = 'Direct-blueseafood2-1714713708', AuthTy = 'card', memberId = 'blueseafood2', OrdNm ='곽동원', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)블루씨푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리비씨VISA 41012020****747*', rApprNo = 'mjsof2024050314255946855', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-03 14:25:56', InvoiceNum = '결제성공:Direct-blueseafood2-1714713708/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-03 14:25:56' ========================2024-05-03 14:25:56======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2024050314255946855' 0 = 1 cnt = 1 ========================2024-05-03 14:25:56======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'blueseafood2' 0 = blueseafood2 Mid = blueseafood2 1 = (주)블루씨푸드 Mcompany = (주)블루씨푸드 2 = 5478700548 companyNum = 5478700548 3 = 051-256-7005 Mtel1 = 051-256-7005 4 = 010-0000-0000 Mhp = 010-0000-0000 ========================2024-05-03 14:25:56======================== select * from customers where id = 'blueseafood2' ========================2024-05-03 14:25:56======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('blueseafood2','2024-05-03 14:25:56','220000','220000','온라인','0') ========================2024-05-03 14:47:34======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1714715203 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240503144643 LGD_HASHDATA = de301031f42f56f6d53a12ba890356e3 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 = 20240503144737FB99E9E0A32E8C9A22BDFEDAB7733F8333C1D146 Mname = 최경환 Mcompany = (주)매머드커피랩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = tax@mmth.co.kr UserId = mmthcoffee LGD_ESCROW_USEYN = N ========================2024-05-03 14:47:34======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240503144738 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = tax@mmth.co.kr 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 = 94300309****993* LGD_FINANCEAUTHNUM = 41049326 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 25e0f98260099659c9bb5db8ee437583 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240503144738 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2024050314473748ON1 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1714715203 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 31447374Fjy6 ========================2024-05-03 14:47:34======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1714715203', AuthTy = 'card', memberId = 'mmthcoffee', OrdNm ='최경환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)매머드커피랩', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 94300309****993*', rApprNo = 'mjsof2024050314473748ON1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-03 14:47:34', InvoiceNum = '결제성공:Direct-mmthcoffee-1714715203/0000', Deliver = '', senditem = 'tax@mmth.co.kr', salestopvalue = '', mod_date = '2024-05-03 14:47:34' ========================2024-05-03 14:47:35======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2024050314473748ON1' 0 = 1 cnt = 1 ========================2024-05-03 14:47:35======================== 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 ========================2024-05-03 14:47:35======================== select * from customers where id = 'mmthcoffee' ========================2024-05-03 14:47:35======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2024-05-03 14:47:34','220000','220000','온라인','0') ========================2024-05-03 14:51:10======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1714715424 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240503145024 LGD_HASHDATA = c8dc0d802980901ccf4603e484429a91 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 = 2024050314511318B49B928AE01CB5FA10698F907BA6C2E4F61911 Mname = 최경환 Mcompany = (주)매머드커피랩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = tax@mmth.co.kr UserId = mmthcoffee LGD_ESCROW_USEYN = N ========================2024-05-03 14:51:11======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240503145114 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = tax@mmth.co.kr 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 = 94300309****993* LGD_FINANCEAUTHNUM = 41081906 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2872ba975c4ed1827bb42365e356ab1c LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240503145114 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240503145114axN11 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1714715424 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3145114a1kg0 ========================2024-05-03 14:51:11======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1714715424', AuthTy = 'card', memberId = 'mmthcoffee', OrdNm ='최경환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)매머드커피랩', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 94300309****993*', rApprNo = 'mjsof20240503145114axN11', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-03 14:51:11', InvoiceNum = '결제성공:Direct-mmthcoffee-1714715424/0000', Deliver = '', senditem = 'tax@mmth.co.kr', salestopvalue = '', mod_date = '2024-05-03 14:51:11' ========================2024-05-03 14:51:11======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240503145114axN11' 0 = 1 cnt = 1 ========================2024-05-03 14:51:11======================== 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 ========================2024-05-03 14:51:11======================== select * from customers where id = 'mmthcoffee' ========================2024-05-03 14:51:11======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2024-05-03 14:51:11','220000','220000','온라인','0') ========================2024-05-03 15:56:53======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-guil09-1714719376 LGD_BUYER = 최해국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240503155616 LGD_HASHDATA = fe7d859aa8f53ddcef1552907edcadda 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 = 202405031556575428B303A8F9B382EA504DFBA550F0EDA56770D8 Mname = 최해국 Mcompany = 구일종합상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = guil09 LGD_ESCROW_USEYN = N ========================2024-05-03 15:56:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240503155657 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 = 45749380****302* LGD_FINANCEAUTHNUM = 00806459 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 507859ef8a661851287f010fe24ce0b7 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20240503155657 LGD_PCANCELSTR = 0 LGD_BUYER = 최해국 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202405031556576fJz5 LGD_BUYERID = LGD_OID = Direct-guil09-1714719376 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-05-03 15:56:53======================== insert into mBoard_order set rOrdNo = 'Direct-guil09-1714719376', AuthTy = 'card', memberId = 'guil09', OrdNm ='최해국', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '구일종합상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대VISA 45749380****302*', rApprNo = 'mjsof202405031556576fJz5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-03 15:56:53', InvoiceNum = '결제성공:Direct-guil09-1714719376/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-03 15:56:53' ========================2024-05-03 15:56:54======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202405031556576fJz5' 0 = 1 cnt = 1 ========================2024-05-03 15:56:54======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'guil09' 0 = guil09 Mid = guil09 1 = 구일종합상사 Mcompany = 구일종합상사 2 = 3052186849 companyNum = 3052186849 3 = 010-4224-4146 Mtel1 = 010-4224-4146 4 = 010-4224-4146 Mhp = 010-4224-4146 ========================2024-05-03 15:56:54======================== select * from customers where id = 'guil09' ========================2024-05-03 15:56:54======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('guil09','2024-05-03 15:56:53','108000','110000','온라인','0') ========================2024-05-03 17:41:33======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-zealgumi5577-1714725647 LGD_BUYER = 강민규 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240503174047 LGD_HASHDATA = d72bce6443e7dc6fd9545b54d03c0178 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 = 20240503174137DEAEAA9DE1B751A6D45AA681536E43A05241585A Mname = 강민규 Mcompany = 지얼 세라믹 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = zealgumi5577 LGD_ESCROW_USEYN = N ========================2024-05-03 17:41:34======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240503174138 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306F0C LGD_AFFILIATECODE = 004650 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852698****586* LGD_FINANCEAUTHNUM = 30045245 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6687d08d6ef7f73d2c05104a5f517161 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240503174138 LGD_PCANCELSTR = 0 LGD_BUYER = 강민규 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202405031741370RV95 LGD_BUYERID = LGD_OID = Direct-zealgumi5577-1714725647 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 31741370vAS0 ========================2024-05-03 17:41:34======================== insert into mBoard_order set rOrdNo = 'Direct-zealgumi5577-1714725647', AuthTy = 'card', memberId = 'zealgumi5577', OrdNm ='강민규', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '지얼 세라믹', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '국민MASTER 55852698****586*', rApprNo = 'mjsof202405031741370RV95', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-03 17:41:34', InvoiceNum = '결제성공:Direct-zealgumi5577-1714725647/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-03 17:41:34' ========================2024-05-03 17:41:34======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202405031741370RV95' 0 = 1 cnt = 1 ========================2024-05-03 17:41:34======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'zealgumi5577' 0 = zealgumi5577 Mid = zealgumi5577 1 = 지얼 세라믹 Mcompany = 지얼 세라믹 2 = 6023172323 companyNum = 6023172323 3 = 054-465-5577 Mtel1 = 054-465-5577 4 = 010-2648-5320 Mhp = 010-2648-5320 ========================2024-05-03 17:41:34======================== select * from customers where id = 'zealgumi5577' ========================2024-05-03 17:41:34======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('zealgumi5577','2024-05-03 17:41:34','10000','11000','온라인','0')