========================2022-09-30 10:40:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kyg2031-1664501991 LGD_BUYER = 김용국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220930103951 LGD_HASHDATA = 649faba5d8ed2f9a50224870c7cc2918 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 = 20220930104345E5A2AE2A370FBCC35EB9031104117228B5F0AB64 Mname = 김용국 Mcompany = (유)성광물산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kyg2031 LGD_ESCROW_USEYN = N ========================2022-09-30 10:40:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220930104345 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = 005770 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55353109****738* LGD_FINANCEAUTHNUM = 20074616 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 35200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 261705b979548108d42274894d0c4e7a LGD_BUYERADDRESS = LGD_FINANCENAME = 전북MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220930104346 LGD_PCANCELSTR = 0 LGD_BUYER = 김용국 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220930104345drin7 LGD_BUYERID = LGD_OID = Direct-kyg2031-1664501991 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0104345dWL06 ========================2022-09-30 10:40:53======================== insert into mBoard_order set rOrdNo = 'Direct-kyg2031-1664501991', AuthTy = 'card', memberId = 'kyg2031', OrdNm ='김용국', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(유)성광물산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '전북MASTER 55353109****738*', rApprNo = 'mjsof20220930104345drin7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-09-30 10:40:53', InvoiceNum = '결제성공:Direct-kyg2031-1664501991/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-09-30 10:40:53' ========================2022-09-30 10:40:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220930104345drin7' 0 = 1 cnt = 1 ========================2022-09-30 10:40:53======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kyg2031' 0 = kyg2031 Mid = kyg2031 1 = (유)성광물산 Mcompany = (유)성광물산 2 = 4018113328 companyNum = 4018113328 3 = 063-442-0360 Mtel1 = 063-442-0360 4 = 010-8987-6747 Mhp = 010-8987-6747 ========================2022-09-30 10:40:53======================== select * from customers where id = 'kyg2031' ========================2022-09-30 10:40:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kyg2031','2022-09-30 10:40:53','52500','55000','온라인','0') ========================2022-09-30 11:10:37======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kumhocnp-1664503786 LGD_BUYER = 오충우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220930110946 LGD_HASHDATA = 54c53824de00acfd97ca16ec6b2f5a07 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 = 20220930111330983D1ECC36B01BF1071B64D5175C04983D296135 Mname = 오충우 Mcompany = 주식회사금호씨엔피 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kumhocnp LGD_ESCROW_USEYN = N ========================2022-09-30 11:10:38======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220930111332 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 755339 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400308****699* LGD_FINANCEAUTHNUM = 44804132 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ded0af39eb2716a33421c0cdbd5a43e6 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220930111332 LGD_PCANCELSTR = 0 LGD_BUYER = 오충우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0012 LGD_TID = mjsof20220930111331aoFy2 LGD_BUYERID = LGD_OID = Direct-kumhocnp-1664503786 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0111331aakr7 ========================2022-09-30 11:10:38======================== insert into mBoard_order set rOrdNo = 'Direct-kumhocnp-1664503786', AuthTy = 'card', memberId = 'kumhocnp', OrdNm ='오충우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사금호씨엔피', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨VISA 41400308****699*', rApprNo = 'mjsof20220930111331aoFy2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-09-30 11:10:38', InvoiceNum = '결제성공:Direct-kumhocnp-1664503786/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-09-30 11:10:38' ========================2022-09-30 11:10:38======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220930111331aoFy2' 0 = 1 cnt = 1 ========================2022-09-30 11:10:38======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kumhocnp' 0 = kumhocnp Mid = kumhocnp 1 = 주식회사금호씨엔피 Mcompany = 주식회사금호씨엔피 2 = 138-81-94592 companyNum = 138-81-94592 3 = 031-347-8161 Mtel1 = 031-347-8161 4 = 010-4232-8162 Mhp = 010-4232-8162 ========================2022-09-30 11:10:38======================== select * from customers where id = 'kumhocnp' ========================2022-09-30 11:10:38======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kumhocnp','2022-09-30 11:10:38','52500','55000','온라인','0') ========================2022-09-30 11:28:46======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mando2b-1664504833 LGD_BUYER = 권덕로 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220930112713 LGD_HASHDATA = 2099b2be1dc04cc0a1a38add55ccb578 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 = 20220930113140F39D6152EF5F4EDE70DC1B293A88AB64F1578D73 Mname = 권덕로 Mcompany = 만도실업(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = mando2b LGD_ESCROW_USEYN = N ========================2022-09-30 11:28:47======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220930113140 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = mdfence@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 000000 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94104992****365* LGD_FINANCEAUTHNUM = 30135948 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8baa1f1e1408876936910b6f629bd024 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220930113141 LGD_PCANCELSTR = 0 LGD_BUYER = 권덕로 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220930113140cjNY4 LGD_BUYERID = LGD_OID = Direct-mando2b-1664504833 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0113140c9g42 ========================2022-09-30 11:28:47======================== insert into mBoard_order set rOrdNo = 'Direct-mando2b-1664504833', AuthTy = 'card', memberId = 'mando2b', OrdNm ='권덕로', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '만도실업(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민 94104992****365*', rApprNo = 'mjsof20220930113140cjNY4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-09-30 11:28:47', InvoiceNum = '결제성공:Direct-mando2b-1664504833/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-09-30 11:28:47' ========================2022-09-30 11:28:47======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220930113140cjNY4' 0 = 1 cnt = 1 ========================2022-09-30 11:28:47======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mando2b' 0 = mando2b Mid = mando2b 1 = 만도실업(주) Mcompany = 만도실업(주) 2 = 128-81-20017 companyNum = 128-81-20017 3 = 031-945-6311 Mtel1 = 031-945-6311 4 = 031-945-6311 Mhp = 031-945-6311 ========================2022-09-30 11:28:47======================== select * from customers where id = 'mando2b' ========================2022-09-30 11:28:47======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mando2b','2022-09-30 11:28:47','52500','55000','온라인','0') ========================2022-09-30 12:56:08======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nbmedical-1664509976 LGD_BUYER = 유미나 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220930125256 LGD_HASHDATA = 6e534c41c56dcdc1421b0e4b6d2c0fd1 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 = 20220930125901BBF92BFC0E2678E66DDA63054F3621F54795F1DE Mname = 유미나 Mcompany = 남북메디칼 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = nbmedical LGD_ESCROW_USEYN = N ========================2022-09-30 12:56:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220930125902 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = DAA6B6 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94106440****712* LGD_FINANCEAUTHNUM = 19667623 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 41000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ebd84facaef247eaa39dc568686d589f LGD_BUYERADDRESS = LGD_FINANCENAME = 신한 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20220930125902 LGD_PCANCELSTR = 0 LGD_BUYER = 유미나 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof202209301259029OJn3 LGD_BUYERID = LGD_OID = Direct-nbmedical-1664509976 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-09-30 12:56:09======================== insert into mBoard_order set rOrdNo = 'Direct-nbmedical-1664509976', AuthTy = 'card', memberId = 'nbmedical', OrdNm ='유미나', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '남북메디칼', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '신한 94106440****712*', rApprNo = 'mjsof202209301259029OJn3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-09-30 12:56:09', InvoiceNum = '결제성공:Direct-nbmedical-1664509976/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-09-30 12:56:09' ========================2022-09-30 12:56:09======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202209301259029OJn3' 0 = 1 cnt = 1 ========================2022-09-30 12:56:09======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nbmedical' 0 = nbmedical Mid = nbmedical 1 = 남북메디칼 Mcompany = 남북메디칼 2 = 5148130827 companyNum = 5148130827 3 = 053-653-9360 Mtel1 = 053-653-9360 4 = 010-6531-9909 Mhp = 010-6531-9909 ========================2022-09-30 12:56:09======================== select * from customers where id = 'nbmedical' ========================2022-09-30 12:56:09======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nbmedical','2022-09-30 12:56:09','10000','11000','온라인','0') ========================2022-09-30 15:06:53======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bruce1211-1664517892 LGD_BUYER = 이찬행 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220930150452 LGD_HASHDATA = 53b2fe9ade03ec1ed4e2c0152867079e 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 = 20220930150947F239B231EDD380DC4A08939F067F40F06B6D412A Mname = 이찬행 Mcompany = 카피포엠 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = bruce1211 LGD_ESCROW_USEYN = N ========================2022-09-30 15:06:54======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220930150947 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****951* LGD_FINANCEAUTHNUM = 00051138 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 03159294f5e0fee7bbe5d15e315f744f LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20220930150948 LGD_PCANCELSTR = 0 LGD_BUYER = 이찬행 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20220930150947aJRE6 LGD_BUYERID = LGD_OID = Direct-bruce1211-1664517892 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-09-30 15:24:08======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bruce1211-1664518902 LGD_BUYER = 이찬행 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220930152142 LGD_HASHDATA = 53ca961446b6d51d90ffd7797b3d64d6 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 = 202209301527022BE247E94B37ACCDA67AE5B3D176F2D018883CA4 Mname = 이찬행 Mcompany = 카피포엠 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = bruce1211 LGD_ESCROW_USEYN = N ========================2022-09-30 15:24:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220930152702 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****951* LGD_FINANCEAUTHNUM = 00100316 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ed9cc8bdaa393c037c2f294264985bb4 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20220930152703 LGD_PCANCELSTR = 0 LGD_BUYER = 이찬행 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20220930152702dR0b3 LGD_BUYERID = LGD_OID = Direct-bruce1211-1664518902 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-09-30 15:53:10======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-lkg002-1664520495 LGD_BUYER = 이갑구 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220930154815 LGD_HASHDATA = 879c8e524c2d6c324acd49dd7680ad5d 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 = 20220930155604140BF23F87EA95F040BCF650293283C0413FB160 Mname = 이갑구 Mcompany = 미래씰링시스템 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = lkg002 LGD_ESCROW_USEYN = N ========================2022-09-30 15:53:11======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220930155604 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 002245 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94454258****605* LGD_FINANCEAUTHNUM = 30063249 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 88dacbdb38804950157755428c5da14b LGD_BUYERADDRESS = LGD_FINANCENAME = 국민 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220930155605 LGD_PCANCELSTR = 0 LGD_BUYER = 이갑구 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220930155604dTx39 LGD_BUYERID = LGD_OID = Direct-lkg002-1664520495 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-09-30 15:53:11======================== insert into mBoard_order set rOrdNo = 'Direct-lkg002-1664520495', AuthTy = 'card', memberId = 'lkg002', OrdNm ='이갑구', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '미래씰링시스템', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민 94454258****605*', rApprNo = 'mjsof20220930155604dTx39', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-09-30 15:53:11', InvoiceNum = '결제성공:Direct-lkg002-1664520495/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-09-30 15:53:11' ========================2022-09-30 15:53:11======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220930155604dTx39' 0 = 1 cnt = 1 ========================2022-09-30 15:53:11======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'lkg002' 0 = lkg002 Mid = lkg002 1 = 미래씰링시스템 Mcompany = 미래씰링시스템 2 = 1303635323 companyNum = 1303635323 3 = 031-366-5166 Mtel1 = 031-366-5166 4 = 010-3729-2427 Mhp = 010-3729-2427 ========================2022-09-30 15:53:11======================== select * from customers where id = 'lkg002' ========================2022-09-30 15:53:11======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('lkg002','2022-09-30 15:53:11','108000','110000','온라인','0') ========================2022-09-30 17:17:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-poweroioi-1664525781 LGD_BUYER = 김원석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220930171621 LGD_HASHDATA = fbdb6c8d91ee7a60a09ce771eb791987 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 = 20220930172014EB175C79B2D8183D6CBAE5441F80C739B5B5EF03 Mname = 김원석 Mcompany = (주)다사랑아이엔씨 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = poweroioi LGD_ESCROW_USEYN = N ========================2022-09-30 17:17:21======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220930172014 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003338 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658667****503* LGD_FINANCEAUTHNUM = 30020323 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d09fc88e88daf8cb218a3936bf357d01 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220930172015 LGD_PCANCELSTR = 0 LGD_BUYER = 김원석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof202209301720149cxb5 LGD_BUYERID = LGD_OID = Direct-poweroioi-1664525781 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-09-30 17:17:21======================== insert into mBoard_order set rOrdNo = 'Direct-poweroioi-1664525781', AuthTy = 'card', memberId = 'poweroioi', OrdNm ='김원석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)다사랑아이엔씨', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민VISA 42658667****503*', rApprNo = 'mjsof202209301720149cxb5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-09-30 17:17:21', InvoiceNum = '결제성공:Direct-poweroioi-1664525781/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-09-30 17:17:21' ========================2022-09-30 17:17:21======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202209301720149cxb5' 0 = 1 cnt = 1 ========================2022-09-30 17:17:21======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'poweroioi' 0 = poweroioi Mid = poweroioi 1 = (주)다사랑아이엔씨 Mcompany = (주)다사랑아이엔씨 2 = 1388603820 companyNum = 1388603820 3 = 010-3017-3597 Mtel1 = 010-3017-3597 4 = 010-3017-3597 Mhp = 010-3017-3597 ========================2022-09-30 17:17:21======================== select * from customers where id = 'poweroioi' ========================2022-09-30 17:17:21======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('poweroioi','2022-09-30 17:17:21','52500','55000','온라인','0') ========================2022-09-30 18:09:18======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-landhbio-1664528910 LGD_BUYER = 이승환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220930180830 LGD_HASHDATA = 24507ba8fc70f0294567e313b5dd3bf9 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 = 20220930181211398E789FC020CDA23BB7F3EEC03EBDE75E950D90 Mname = 이승환 Mcompany = (주)엘엔에이치바이오 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = landhbio LGD_ESCROW_USEYN = N ========================2022-09-30 18:09:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220930181212 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****430* LGD_FINANCEAUTHNUM = 50407154 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 00d583247a9da4a47fdda63edb5daaad LGD_BUYERADDRESS = LGD_FINANCENAME = 우리VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220930181212 LGD_PCANCELSTR = 0 LGD_BUYER = 이승환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202209301812127dKz9 LGD_BUYERID = LGD_OID = Direct-landhbio-1664528910 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 01812127QSK2 ========================2022-09-30 18:10:37======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-landhbio-1664529003 LGD_BUYER = 이승환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220930181003 LGD_HASHDATA = 3002f61d3c21cc0ecec33994ee1f6e3c 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 = 2022093018133129FB39D039731BF3EE22673F3ED3615CC20E7CF5 Mname = 이승환 Mcompany = (주)엘엔에이치바이오 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = landhbio LGD_ESCROW_USEYN = N ========================2022-09-30 18:10:38======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220930181331 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****430* LGD_FINANCEAUTHNUM = 50429987 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = df0b837541b734746bef06f5ce62fa53 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220930181331 LGD_PCANCELSTR = 0 LGD_BUYER = 이승환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220930181331gHZv5 LGD_BUYERID = LGD_OID = Direct-landhbio-1664529003 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0181331gTYh7