========================2023-08-01 08:55:38======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-vudghktkdtk-1690847644 LGD_BUYER = 강원호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230801085404 LGD_HASHDATA = 199004a1ca10031c18f40bf7417f1bee 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 = 20230801085644F7CAD6BF8562952C3294235B295ABDFA4B58501A Mname = 강원호 Mcompany = 평화상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = vudghktkdtk LGD_ESCROW_USEYN = N ========================2023-08-01 08:55:38======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230801085644 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****441* LGD_FINANCEAUTHNUM = 00843107 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fcf1d579d19592ab45c0fb3014210783 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20230801085645 LGD_PCANCELSTR = 0 LGD_BUYER = 강원호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202308010856447WFT9 LGD_BUYERID = LGD_OID = Direct-vudghktkdtk-1690847644 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-08-01 08:55:38======================== insert into mBoard_order set rOrdNo = 'Direct-vudghktkdtk-1690847644', AuthTy = 'card', memberId = 'vudghktkdtk', OrdNm ='강원호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '평화상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '현대MASTER 55314200****441*', rApprNo = 'mjsof202308010856447WFT9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-08-01 08:55:38', InvoiceNum = '결제성공:Direct-vudghktkdtk-1690847644/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-08-01 08:55:38' ========================2023-08-01 08:55:38======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202308010856447WFT9' 0 = 1 cnt = 1 ========================2023-08-01 08:55:38======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'vudghktkdtk' 0 = vudghktkdtk Mid = vudghktkdtk 1 = 평화상사 Mcompany = 평화상사 2 = 8570200394 companyNum = 8570200394 3 = 043-224-7982 Mtel1 = 043-224-7982 4 = 010-4243-6887 Mhp = 010-4243-6887 ========================2023-08-01 08:55:38======================== select * from customers where id = 'vudghktkdtk' ========================2023-08-01 08:55:38======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('vudghktkdtk','2023-08-01 08:55:38','52500','55000','온라인','0') ========================2023-08-01 08:57:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jjss5009-1690847786 LGD_BUYER = 한명화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230801085626 LGD_HASHDATA = 9d0fbdb31c8b69981d73e5234974b52e 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 = 20230801085833EB2DB2DFAA62D5490386439F3E66DCB6F4402BA6 Mname = 한명화 Mcompany = 주식회사제이앤에스팩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = jjss5009 LGD_ESCROW_USEYN = N ========================2023-08-01 08:57:28======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230801085834 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****441* LGD_FINANCEAUTHNUM = 00942337 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c725b96dd6c9d3937523e2303d367e4e LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20230801085834 LGD_PCANCELSTR = 0 LGD_BUYER = 한명화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230801085834auvJ7 LGD_BUYERID = LGD_OID = Direct-jjss5009-1690847786 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-08-01 08:57:28======================== insert into mBoard_order set rOrdNo = 'Direct-jjss5009-1690847786', AuthTy = 'card', memberId = 'jjss5009', OrdNm ='한명화', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사제이앤에스팩', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대MASTER 55314200****441*', rApprNo = 'mjsof20230801085834auvJ7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-08-01 08:57:28', InvoiceNum = '결제성공:Direct-jjss5009-1690847786/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-08-01 08:57:28' ========================2023-08-01 08:57:28======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230801085834auvJ7' 0 = 1 cnt = 1 ========================2023-08-01 08:57:28======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jjss5009' 0 = jjss5009 Mid = jjss5009 1 = 주식회사제이앤에스팩 Mcompany = 주식회사제이앤에스팩 2 = 5718701889 companyNum = 5718701889 3 = 043-224-7982 Mtel1 = 043-224-7982 4 = 010-4243-6887 Mhp = 010-4243-6887 ========================2023-08-01 08:57:28======================== select * from customers where id = 'jjss5009' ========================2023-08-01 08:57:28======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jjss5009','2023-08-01 08:57:28','108000','110000','온라인','0') ========================2023-08-01 09:45:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-myungsin2841-1690850592 LGD_BUYER = 한순옥 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230801094312 LGD_HASHDATA = 868105ab4571f2870445b32a6be3f292 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 = 202308010946217815A85DB9624BC6D33048FAAE28904CB7178ABE Mname = 한순옥 Mcompany = 명신종합상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = myungsin2841 LGD_ESCROW_USEYN = N ========================2023-08-01 09:45:16======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230801094622 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 = 40921703****526* LGD_FINANCEAUTHNUM = 58967176 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 91100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9738ab7f856fca59c067ee43e88b52f1 LGD_BUYERADDRESS = LGD_FINANCENAME = NH VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20230801094622 LGD_PCANCELSTR = 0 LGD_BUYER = 한순옥 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230801094622cxPj3 LGD_BUYERID = LGD_OID = Direct-myungsin2841-1690850592 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-08-01 09:45:16======================== insert into mBoard_order set rOrdNo = 'Direct-myungsin2841-1690850592', AuthTy = 'card', memberId = 'myungsin2841', OrdNm ='한순옥', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '명신종합상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = 'NH VISA 40921703****526*', rApprNo = 'mjsof20230801094622cxPj3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-08-01 09:45:16', InvoiceNum = '결제성공:Direct-myungsin2841-1690850592/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-08-01 09:45:16' ========================2023-08-01 09:45:16======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230801094622cxPj3' 0 = 1 cnt = 1 ========================2023-08-01 09:45:16======================== 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-8590-8554 Mhp = 010-8590-8554 ========================2023-08-01 09:45:16======================== select * from customers where id = 'myungsin2841' ========================2023-08-01 09:45:16======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('myungsin2841','2023-08-01 09:45:16','52500','55000','온라인','0') ========================2023-08-01 10:06:14======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pao7894-1690851927 LGD_BUYER = 심재후 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230801100527 LGD_HASHDATA = d8237697527968ea8156e71ef6121c0c 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 = 20230801100720029FE144E2EFDC388C5F96BF1A81A6666DDDF375 Mname = 심재후 Mcompany = (주)토탈엘앤씨 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = pao7894 LGD_ESCROW_USEYN = N ========================2023-08-01 10:06:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230801100721 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 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 = 41400306****197* LGD_FINANCEAUTHNUM = 39892892 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = cd46b41e883aaa82e68b202d5b5cdef0 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230801100722 LGD_PCANCELSTR = 0 LGD_BUYER = 심재후 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2023080110072175GJ9 LGD_BUYERID = LGD_OID = Direct-pao7894-1690851927 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 11007217b7g4 ========================2023-08-01 10:06:15======================== insert into mBoard_order set rOrdNo = 'Direct-pao7894-1690851927', AuthTy = 'card', memberId = 'pao7894', OrdNm =' 심재후', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)토탈엘앤씨', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41400306****197*', rApprNo = 'mjsof2023080110072175GJ9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-08-01 10:06:15', InvoiceNum = '결제성공:Direct-pao7894-1690851927/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-08-01 10:06:15' ========================2023-08-01 10:06:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2023080110072175GJ9' 0 = 1 cnt = 1 ========================2023-08-01 10:06:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'pao7894' 0 = pao7894 Mid = pao7894 1 = (주)토탈엘앤씨 Mcompany = (주)토탈엘앤씨 2 = 134-86-34108 companyNum = 134-86-34108 3 = 031-366-9051 Mtel1 = 031-366-9051 4 = 010-3022-2227 Mhp = 010-3022-2227 ========================2023-08-01 10:06:15======================== select * from customers where id = 'pao7894' ========================2023-08-01 10:06:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('pao7894','2023-08-01 10:06:15','220000','220000','온라인','0') ========================2023-08-01 10:10:33======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dlaehdwls84-1690852126 LGD_BUYER = 임동진 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230801100846 LGD_HASHDATA = 70d35eb0506ad62ec10dcc6aba876e19 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 = 20230801101139A9081FB3583A8D408C1231C6EC9FC28520E74389 Mname = 임동진 Mcompany = 백양자동차정비 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = dlaehdwls84 LGD_ESCROW_USEYN = N ========================2023-08-01 10:10:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230801101139 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306O0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 35651773****539* LGD_FINANCEAUTHNUM = 59219437 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 91300 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 71128c30999b10fc9496c6e1b46fb26e LGD_BUYERADDRESS = LGD_FINANCENAME = NH JCB LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20230801101140 LGD_PCANCELSTR = 0 LGD_BUYER = 임동진 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230801101139dAWR3 LGD_BUYERID = LGD_OID = Direct-dlaehdwls84-1690852126 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-08-01 10:10:33======================== insert into mBoard_order set rOrdNo = 'Direct-dlaehdwls84-1690852126', AuthTy = 'card', memberId = 'dlaehdwls84', OrdNm ='임동진', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '백양자동차정비', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = 'NH JCB 35651773****539*', rApprNo = 'mjsof20230801101139dAWR3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-08-01 10:10:33', InvoiceNum = '결제성공:Direct-dlaehdwls84-1690852126/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-08-01 10:10:33' ========================2023-08-01 10:10:33======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230801101139dAWR3' 0 = 1 cnt = 1 ========================2023-08-01 10:10:33======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dlaehdwls84' 0 = dlaehdwls84 Mid = dlaehdwls84 1 = 백양자동차정비 Mcompany = 백양자동차정비 2 = 609-01-06282 companyNum = 609-01-06282 3 = 010-9082-8123 Mtel1 = 010-9082-8123 4 = 010-9082-8123 Mhp = 010-9082-8123 ========================2023-08-01 10:10:33======================== select * from customers where id = 'dlaehdwls84' ========================2023-08-01 10:10:33======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('dlaehdwls84','백양자동차정비','6090106282','010-9082-8123','010-9082-8123','2023-08-01 10:10:33','온라인') ========================2023-08-01 10:10:34======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dlaehdwls84','2023-08-01 10:10:33','10000','11000','온라인','0') ========================2023-08-01 10:54:18======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nosqr9583-1690854687 LGD_BUYER = 김창민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230801105127 LGD_HASHDATA = 03397078779c3902b5d6e71a69d3663e 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 = 202308011055247C766FAFF9A828FA36A034A2F8418FEA3DBC6F7A Mname = 김창민 Mcompany = 앤오스퀘어(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = nosqr9583 LGD_ESCROW_USEYN = N ========================2023-08-01 10:54:19======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230801105524 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 = 51379100****927* LGD_FINANCEAUTHNUM = 64259284 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 71200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e1426c08488d9ee3d33c38a960efde49 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20230801105525 LGD_PCANCELSTR = 0 LGD_BUYER = 김창민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230801105524isnl9 LGD_BUYERID = LGD_OID = Direct-nosqr9583-1690854687 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-08-01 10:54:19======================== insert into mBoard_order set rOrdNo = 'Direct-nosqr9583-1690854687', AuthTy = 'card', memberId = 'nosqr9583', OrdNm ='김창민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '앤오스퀘어(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '롯데MASTER 51379100****927*', rApprNo = 'mjsof20230801105524isnl9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-08-01 10:54:19', InvoiceNum = '결제성공:Direct-nosqr9583-1690854687/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-08-01 10:54:19' ========================2023-08-01 10:54:19======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230801105524isnl9' 0 = 1 cnt = 1 ========================2023-08-01 10:54:19======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nosqr9583' 0 = nosqr9583 Mid = nosqr9583 1 = 앤오스퀘어(주) Mcompany = 앤오스퀘어(주) 2 = 7258800733 companyNum = 7258800733 3 = 055-363-9583 Mtel1 = 055-363-9583 4 = 010-4591-3793 Mhp = 010-4591-3793 ========================2023-08-01 10:54:19======================== select * from customers where id = 'nosqr9583' ========================2023-08-01 10:54:19======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nosqr9583','2023-08-01 10:54:19','108000','110000','온라인','0') ========================2023-08-01 12:52:39======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tophaeyang-1690861883 LGD_BUYER = 구본형 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230801125123 LGD_HASHDATA = 5a51920cd4c785c73edaa015c37252bc 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 = 202308011253460EA2E8191AEC87624BB9605290C83B39E3E1EC5D Mname = 구본형 Mcompany = 해양씨위드유한회사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = tophaeyang LGD_ESCROW_USEYN = N ========================2023-08-01 12:52:40======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230801125346 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 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 = 55852693****585* LGD_FINANCEAUTHNUM = 30038319 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 41b38969b7b47d2cda8dc4778636f704 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230801125346 LGD_PCANCELSTR = 0 LGD_BUYER = 구본형 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230801125346eIRd5 LGD_BUYERID = LGD_OID = Direct-tophaeyang-1690861883 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1125346e0Mo0 ========================2023-08-01 12:52:40======================== insert into mBoard_order set rOrdNo = 'Direct-tophaeyang-1690861883', AuthTy = 'card', memberId = 'tophaeyang', OrdNm ='구본형', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '해양씨위드유한회사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 55852693****585*', rApprNo = 'mjsof20230801125346eIRd5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-08-01 12:52:40', InvoiceNum = '결제성공:Direct-tophaeyang-1690861883/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-08-01 12:52:40' ========================2023-08-01 12:52:40======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230801125346eIRd5' 0 = 1 cnt = 1 ========================2023-08-01 12:52:40======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'tophaeyang' 0 = tophaeyang Mid = tophaeyang 1 = 해양씨위드유한회사 Mcompany = 해양씨위드유한회사 2 = 749-88-00888 companyNum = 749-88-00888 3 = 02-2279-3530 Mtel1 = 02-2279-3530 4 = 010-5523-3530 Mhp = 010-5523-3530 ========================2023-08-01 12:52:40======================== select * from customers where id = 'tophaeyang' ========================2023-08-01 12:52:40======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('tophaeyang','2023-08-01 12:52:40','220000','220000','온라인','0') ========================2023-08-01 17:47:41======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bigbrother-1690879616 LGD_BUYER = 신완철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230801174656 LGD_HASHDATA = 544e40526271c45ff1c4d7f38e372f08 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 = 2023080117484771D9CA328CCB2C2BEAFA77F45E11C0DC5ADB9B9F Mname = 신완철 Mcompany = (주)빅브라더 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = bigbrother LGD_ESCROW_USEYN = N ========================2023-08-01 17:47:42======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230801174848 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 224776 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55892098****400* LGD_FINANCEAUTHNUM = 44011033 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = be7c53d05caa23673dc907ceeddfdc40 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230801174848 LGD_PCANCELSTR = 0 LGD_BUYER = 신완철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230801174847wGv44 LGD_BUYERID = LGD_OID = Direct-bigbrother-1690879616 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1174847wgEE4 ========================2023-08-01 17:47:42======================== insert into mBoard_order set rOrdNo = 'Direct-bigbrother-1690879616', AuthTy = 'card', memberId = 'bigbrother', OrdNm ='신완철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)빅브라더', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리비씨MASTER 55892098****400*', rApprNo = 'mjsof20230801174847wGv44', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-08-01 17:47:42', InvoiceNum = '결제성공:Direct-bigbrother-1690879616/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-08-01 17:47:42' ========================2023-08-01 17:47:42======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230801174847wGv44' 0 = 1 cnt = 1 ========================2023-08-01 17:47:42======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bigbrother' 0 = bigbrother Mid = bigbrother 1 = (주)빅브라더 Mcompany = (주)빅브라더 2 = 7828800717 companyNum = 7828800717 3 = 010-3414-0228 Mtel1 = 010-3414-0228 4 = 010-7747-5701 Mhp = 010-7747-5701 ========================2023-08-01 17:47:42======================== select * from customers where id = 'bigbrother' ========================2023-08-01 17:47:42======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bigbrother','2023-08-01 17:47:42','220000','220000','온라인','0') ========================2023-08-01 18:19:54======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ksm03172002-1690881505 LGD_BUYER = 김상만 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230801181825 LGD_HASHDATA = aab50253ab9d2413524036a3a23896f3 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 = 20230801182100DB090689C5EE413D17DFBE31867FF7CADD3ECF6A Mname = 김상만 Mcompany = 롯데칠성음료수진점(대성음료상사) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = ksm03172002 LGD_ESCROW_USEYN = N ========================2023-08-01 18:19:54======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230801182101 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 = 37029921****71* LGD_FINANCEAUTHNUM = 00856039 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 41c3628b234b655a81d8a244c5417104 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20230801182101 LGD_PCANCELSTR = 0 LGD_BUYER = 김상만 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230801182101CWWE8 LGD_BUYERID = LGD_OID = Direct-ksm03172002-1690881505 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-08-01 18:19:54======================== insert into mBoard_order set rOrdNo = 'Direct-ksm03172002-1690881505', AuthTy = 'card', memberId = 'ksm03172002', OrdNm ='김상만', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '롯데칠성음료수진점(대성음료상사)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대AMEX 37029921****71*', rApprNo = 'mjsof20230801182101CWWE8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-08-01 18:19:54', InvoiceNum = '결제성공:Direct-ksm03172002-1690881505/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-08-01 18:19:54' ========================2023-08-01 18:19:54======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230801182101CWWE8' 0 = 1 cnt = 1 ========================2023-08-01 18:19:54======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ksm03172002' 0 = ksm03172002 Mid = ksm03172002 1 = 롯데칠성음료수진점(대성음료상사) Mcompany = 롯데칠성음료수진점(대성음료상사) 2 = 1292984340 companyNum = 1292984340 3 = 031-756-7037 Mtel1 = 031-756-7037 4 = 010-2748-0432 Mhp = 010-2748-0432 ========================2023-08-01 18:19:54======================== select * from customers where id = 'ksm03172002' ========================2023-08-01 18:19:54======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ksm03172002','2023-08-01 18:19:54','30900','33000','온라인','0') ========================2023-08-01 19:59:50======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-amfyoon369-1690887501 LGD_BUYER = 윤수진 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230801195821 LGD_HASHDATA = 9db77905f3e01e919654d694f3565f76 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 = 20230801200056DBAE6923271F97C94B8FEDF52E0D6C2578E245C8 Mname = 윤수진 Mcompany = 서흥물류 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = amfyoon369 LGD_ESCROW_USEYN = N ========================2023-08-01 19:59:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230801200057 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 = 45749200****660* LGD_FINANCEAUTHNUM = 00612567 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ed95d5c468398e1abded4d0fc34dfe1f LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20230801200057 LGD_PCANCELSTR = 0 LGD_BUYER = 윤수진 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230801200057lV2o6 LGD_BUYERID = LGD_OID = Direct-amfyoon369-1690887501 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-08-01 19:59:51======================== insert into mBoard_order set rOrdNo = 'Direct-amfyoon369-1690887501', AuthTy = 'card', memberId = 'amfyoon369', OrdNm ='윤수진', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '서흥물류', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '현대VISA 45749200****660*', rApprNo = 'mjsof20230801200057lV2o6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-08-01 19:59:51', InvoiceNum = '결제성공:Direct-amfyoon369-1690887501/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-08-01 19:59:51' ========================2023-08-01 19:59:51======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230801200057lV2o6' 0 = 1 cnt = 1 ========================2023-08-01 19:59:51======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'amfyoon369' 0 = amfyoon369 Mid = amfyoon369 1 = 서흥물류 Mcompany = 서흥물류 2 = 6122810585 companyNum = 6122810585 3 = 041-665-3463 Mtel1 = 041-665-3463 4 = 010-9682-9698 Mhp = 010-9682-9698 ========================2023-08-01 19:59:51======================== select * from customers where id = 'amfyoon369' ========================2023-08-01 19:59:51======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('amfyoon369','2023-08-01 19:59:51','220000','220000','온라인','0')