========================2022-08-08 09:53:38======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jjk6788-1659919889 LGD_BUYER = 전중근 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220808095129 LGD_HASHDATA = c68ef9507a296a7280d773d3decc8865 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 = 20220808095533C450A156225FCE512D86E81B5DEBB4978C64963B Mname = 전중근 Mcompany = 동송유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = jjk6788 LGD_ESCROW_USEYN = N ========================2022-08-08 09:53:39======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220808095533 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****961* LGD_FINANCEAUTHNUM = 00372570 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 62a304ef1557f97750cc9865959b9f2e LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20220808095534 LGD_PCANCELSTR = 0 LGD_BUYER = 전중근 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20220808095533Epoh5 LGD_BUYERID = LGD_OID = Direct-jjk6788-1659919889 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-08-08 09:55:09======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jjk6788-1659920051 LGD_BUYER = 전중근 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220808095411 LGD_HASHDATA = e7198e806146c4e146cfeed3d73df629 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 = 202208080957034569EEF2B7D1471F0073C8EAA9FF3C82E5796009 Mname = 전중근 Mcompany = 동송유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = jjk6788 LGD_ESCROW_USEYN = N ========================2022-08-08 09:55:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220808095703 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****961* LGD_FINANCEAUTHNUM = 00758920 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 274c0882e79dfd769e7706a32ea32fe5 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20220808095704 LGD_PCANCELSTR = 0 LGD_BUYER = 전중근 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20220808095703CfR84 LGD_BUYERID = LGD_OID = Direct-jjk6788-1659920051 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-08-08 13:28:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-rocketbusan-1659932840 LGD_BUYER = 정지원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220808132720 LGD_HASHDATA = fe0709bb9dea9effb2fe7ebac159eb46 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 = 20220808133014B03618D699674952B41FEF2FA0BFFB17F864A724 Mname = 정지원 Mcompany = (주)로케트배터리부산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = rocketbusan LGD_ESCROW_USEYN = N ========================2022-08-08 13:28:21======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220808133015 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****298* LGD_FINANCEAUTHNUM = 56411881 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e8a8827cab73771952ab1055704ccf8a LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220808133015 LGD_PCANCELSTR = 0 LGD_BUYER = 정지원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220808133015GVzC6 LGD_BUYERID = LGD_OID = Direct-rocketbusan-1659932840 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8133015GVuB5 ========================2022-08-08 13:30:35======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-rocketbusan-1659932985 LGD_BUYER = 정지원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220808132945 LGD_HASHDATA = 45c22a70c66265ccc707d8d084363c73 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 = 202208081332302B66424AA1883DD5C82603990C3E005F502D021C Mname = 정지원 Mcompany = (주)로케트배터리부산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = rocketbusan LGD_ESCROW_USEYN = N ========================2022-08-08 13:30:36======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220808133230 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****298* LGD_FINANCEAUTHNUM = 56418789 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8a7b2ec7868bbf120b6748f89a8882bd LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220808133231 LGD_PCANCELSTR = 0 LGD_BUYER = 정지원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220808133230wJUg8 LGD_BUYERID = LGD_OID = Direct-rocketbusan-1659932985 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8133230waxN5 ========================2022-08-08 13:34:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-rocketbusan-1659933215 LGD_BUYER = 정지원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220808133335 LGD_HASHDATA = 4deaa179ed9c99366b892f135b9b63f4 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 = 202208081336079DCAFDFC47912F88692DA5F4A46482A490ED1CAD Mname = 정지원 Mcompany = (주)로케트배터리부산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = rocketbusan LGD_ESCROW_USEYN = N ========================2022-08-08 13:34:14======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220808133608 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400306****298* LGD_FINANCEAUTHNUM = 56471390 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fe81c383757712105a41ce4c3653498c LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220808133608 LGD_PCANCELSTR = 0 LGD_BUYER = 정지원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220808133608Dg6Y6 LGD_BUYERID = LGD_OID = Direct-rocketbusan-1659933215 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8133608DTGC2 ========================2022-08-08 13:34:14======================== insert into mBoard_order set rOrdNo = 'Direct-rocketbusan-1659933215', AuthTy = 'card', memberId = 'rocketbusan', OrdNm ='정지원', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)로케트배터리부산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41400306****298*', rApprNo = 'mjsof20220808133608Dg6Y6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-08-08 13:34:14', InvoiceNum = '결제성공:Direct-rocketbusan-1659933215/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-08-08 13:34:14' ========================2022-08-08 13:34:14======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220808133608Dg6Y6' 0 = 1 cnt = 1 ========================2022-08-08 13:34:14======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'rocketbusan' 0 = rocketbusan Mid = rocketbusan 1 = (주)로케트배터리부산 Mcompany = (주)로케트배터리부산 2 = 1998701222 companyNum = 1998701222 3 = 051-412-7730 Mtel1 = 051-412-7730 4 = 010-9076-2104 Mhp = 010-9076-2104 ========================2022-08-08 13:34:14======================== select * from customers where id = 'rocketbusan' ========================2022-08-08 13:34:14======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('rocketbusan','2022-08-08 13:34:14','220000','220000','온라인','0') ========================2022-08-08 13:48:59======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kukje9156-1659934035 LGD_BUYER = 조윤영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220808134715 LGD_HASHDATA = dc209e2e2daecffe39ed3a7911912115 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 = 202208081350542AB9B8E8D6F79ED20CAE3BAD48DCE063B9D1D690 Mname = 조윤영 Mcompany = 주식회사 국제안전 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = kukje9156 LGD_ESCROW_USEYN = N ========================2022-08-08 13:49:00======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220808135054 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****081* LGD_FINANCEAUTHNUM = 30018802 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3668c0e021b5937217d8c5a667fbc34d LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220808135054 LGD_PCANCELSTR = 0 LGD_BUYER = 조윤영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220808135054yUG86 LGD_BUYERID = LGD_OID = Direct-kukje9156-1659934035 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8135054ytsG4 ========================2022-08-08 13:49:00======================== insert into mBoard_order set rOrdNo = 'Direct-kukje9156-1659934035', AuthTy = 'card', memberId = 'kukje9156', OrdNm ='조윤영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 국제안전', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****081*', rApprNo = 'mjsof20220808135054yUG86', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-08-08 13:49:00', InvoiceNum = '결제성공:Direct-kukje9156-1659934035/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-08-08 13:49:00' ========================2022-08-08 13:49:00======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220808135054yUG86' 0 = 1 cnt = 1 ========================2022-08-08 13:49:00======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kukje9156' 0 = kukje9156 Mid = kukje9156 1 = 주식회사 국제안전 Mcompany = 주식회사 국제안전 2 = 2068666910 companyNum = 2068666910 3 = 02-469-9156 Mtel1 = 02-469-9156 4 = 010-2013-7302 Mhp = 010-2013-7302 ========================2022-08-08 13:49:00======================== select * from customers where id = 'kukje9156' ========================2022-08-08 13:49:00======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kukje9156','2022-08-08 13:49:00','108000','110000','온라인','0') ========================2022-08-08 15:34:35======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jinsungfood-1659940383 LGD_BUYER = 방용호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220808153303 LGD_HASHDATA = e5c592e76780a1e2ced324ab17431ba0 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 = 20220808153630C7C4F4E9A0A9F35E6F351E57688E13CF164BA6AE Mname = 방용호 Mcompany = 진성푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = jinsungfood LGD_ESCROW_USEYN = N ========================2022-08-08 15:34:36======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220808153630 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 = 55229000****850* LGD_FINANCEAUTHNUM = 00861349 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 92fefe8d425ba02411ba4d4f0245791b LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20220808153631 LGD_PCANCELSTR = 0 LGD_BUYER = 방용호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20220808153630ecFN9 LGD_BUYERID = LGD_OID = Direct-jinsungfood-1659940383 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-08-08 15:34:36======================== insert into mBoard_order set rOrdNo = 'Direct-jinsungfood-1659940383', AuthTy = 'card', memberId = 'jinsungfood', OrdNm ='방용호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '진성푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대MASTER 55229000****850*', rApprNo = 'mjsof20220808153630ecFN9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-08-08 15:34:36', InvoiceNum = '결제성공:Direct-jinsungfood-1659940383/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-08-08 15:34:36' ========================2022-08-08 15:34:36======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220808153630ecFN9' 0 = 1 cnt = 1 ========================2022-08-08 15:34:36======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jinsungfood' 0 = jinsungfood Mid = jinsungfood 1 = 진성푸드 Mcompany = 진성푸드 2 = 3891701142 companyNum = 3891701142 3 = 010-3165-3121 Mtel1 = 010-3165-3121 4 = 010-9325-4827 Mhp = 010-9325-4827 ========================2022-08-08 15:34:36======================== select * from customers where id = 'jinsungfood' ========================2022-08-08 15:34:36======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jinsungfood','2022-08-08 15:34:36','108000','110000','온라인','0') ========================2022-08-08 18:53:45======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-paintds-1659952311 LGD_BUYER = 성규호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220808185151 LGD_HASHDATA = 2ef94c4f47539fb1c1762bc45e2fe3d4 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 = 20220808185540A217B9DAEE2002387181EB843A9CAD14CFD263F6 Mname = 성규호 Mcompany = 대성상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = paintds LGD_ESCROW_USEYN = N ========================2022-08-08 18:53:46======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220808185541 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62641507****993* LGD_FINANCEAUTHNUM = 59040496 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 0440734016eee8cfd089e65ae0d7ab64 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220808185541 LGD_PCANCELSTR = 0 LGD_BUYER = 성규호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220808185540PRCM6 LGD_BUYERID = LGD_OID = Direct-paintds-1659952311 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8185540Pu3M4 ========================2022-08-08 18:53:54======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-paintds-1659952311 LGD_BUYER = 성규호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220808185151 LGD_HASHDATA = 2ef94c4f47539fb1c1762bc45e2fe3d4 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 = 20220808185540A217B9DAEE2002387181EB843A9CAD14CFD263F6 Mname = 성규호 Mcompany = 대성상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = paintds LGD_ESCROW_USEYN = N ========================2022-08-08 18:53:54======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220808185549 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 요청하신 거래[주문번호:Direct-paintds-1659952311]는 2022/08/08 18:55:40 에 이미 신용카드로 결제로 시도한 거래입니다. 상점연락처[02-401-5121] LGD_2TR_FLAG = Y LGD_CARDNUM = **************** LGD_FINANCEAUTHNUM = 59040496 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = c5bcecc41757d59330065f3171482468 LGD_BUYERADDRESS = LGD_FINANCENAME = LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 0 LGD_DEVICE = LGD_TIMESTAMP = 20220808185549 LGD_PCANCELSTR = 0 LGD_BUYER = 성규호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = 0 LGD_TID = mjsof20220808185540PRCM6 LGD_BUYERID = LGD_OID = Direct-paintds-1659952311 LGD_RESPCODE = S007 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 0 LGD_MID = mjsoft007 LGD_ISPKEY = ========================2022-08-08 18:53:58======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-paintds-1659952311 LGD_BUYER = 성규호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220808185151 LGD_HASHDATA = 2ef94c4f47539fb1c1762bc45e2fe3d4 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 = 20220808185540A217B9DAEE2002387181EB843A9CAD14CFD263F6 Mname = 성규호 Mcompany = 대성상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = paintds LGD_ESCROW_USEYN = N ========================2022-08-08 18:53:58======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220808185553 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 요청하신 거래[주문번호:Direct-paintds-1659952311]는 2022/08/08 18:55:40 에 이미 신용카드로 결제로 시도한 거래입니다. 상점연락처[02-401-5121] LGD_2TR_FLAG = Y LGD_CARDNUM = **************** LGD_FINANCEAUTHNUM = 59040496 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = 17d0a27e55a5c7fa7c2167b8908f0dff LGD_BUYERADDRESS = LGD_FINANCENAME = LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 0 LGD_DEVICE = LGD_TIMESTAMP = 20220808185553 LGD_PCANCELSTR = 0 LGD_BUYER = 성규호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = 0 LGD_TID = mjsof20220808185540PRCM6 LGD_BUYERID = LGD_OID = Direct-paintds-1659952311 LGD_RESPCODE = S007 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 0 LGD_MID = mjsoft007 LGD_ISPKEY = ========================2022-08-08 18:55:48======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-paintds-1659952462 LGD_BUYER = 성규호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220808185422 LGD_HASHDATA = d35cfdf77f7aa724e58eb124e31c98d4 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 = 20220808185743FF9499C2EC011A58C00517478D7B718501ACFAA9 Mname = 성규호 Mcompany = 대성상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = paintds LGD_ESCROW_USEYN = N ========================2022-08-08 18:55:49======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220808185744 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62641507****993* LGD_FINANCEAUTHNUM = 59038996 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 147b9f2f175fe6888d715ec633c9964d LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220808185744 LGD_PCANCELSTR = 0 LGD_BUYER = 성규호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220808185744RrxA0 LGD_BUYERID = LGD_OID = Direct-paintds-1659952462 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8185744ROgr9 ========================2022-08-08 18:58:34======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-paintds-1659952665 LGD_BUYER = 성규호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220808185745 LGD_HASHDATA = 01a34d647acb8ff90d66950f04a811e4 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 = 20220808190029C2EA7DAE91996EFC66013F314C1F24E9ABEBC626 Mname = 성규호 Mcompany = 대성상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = paintds LGD_ESCROW_USEYN = N ========================2022-08-08 18:58:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220808190030 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62641507****993* LGD_FINANCEAUTHNUM = 59066541 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 076f96b340e276b7a8f1f56ed1e6dc0e LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220808190030 LGD_PCANCELSTR = 0 LGD_BUYER = 성규호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220808190029OGNf1 LGD_BUYERID = LGD_OID = Direct-paintds-1659952665 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8190029OhFI4 ========================2022-08-08 18:58:35======================== insert into mBoard_order set rOrdNo = 'Direct-paintds-1659952665', AuthTy = 'card', memberId = 'paintds', OrdNm ='성규호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대성상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '비씨CUP 62641507****993*', rApprNo = 'mjsof20220808190029OGNf1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-08-08 18:58:35', InvoiceNum = '결제성공:Direct-paintds-1659952665/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-08-08 18:58:35' ========================2022-08-08 18:58:35======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220808190029OGNf1' 0 = 1 cnt = 1 ========================2022-08-08 18:58:35======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'paintds' 0 = paintds Mid = paintds 1 = 대성상사 Mcompany = 대성상사 2 = 126-86-04132 companyNum = 126-86-04132 3 = 031-767-9248 Mtel1 = 031-767-9248 4 = 010-2699-2835 Mhp = 010-2699-2835 ========================2022-08-08 18:58:35======================== select * from customers where id = 'paintds' ========================2022-08-08 18:58:35======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('paintds','2022-08-08 18:58:35','30900','33000','온라인','0')