========================2021-05-06 10:43:42======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-azfoods01-1620265379 LGD_BUYER = 박정운 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210506104259 LGD_HASHDATA = fcd709b41fe1263d6fbdacc363e30335 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210506104349AC98EE8BCDC44FE78D9B701176729842STNEEO5J Mname = 박정운 Mcompany = (주)에이젯푸즈 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = azfoods01 LGD_ESCROW_USEYN = N ========================2021-05-06 10:43:43======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210506104349 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = azfoods@chol.com 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 = 558526******2828 LGD_FINANCEAUTHNUM = 30008754 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5ecc3eb46fcbfb7b772228bbef53bab5 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210506104349 LGD_PCANCELSTR = 0 LGD_BUYER = 박정운 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021050610434960252 LGD_BUYERID = LGD_OID = Direct-azfoods01-1620265379 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 610434960203 ========================2021-05-06 10:43:43======================== insert into mBoard_order set rOrdNo = 'Direct-azfoods01-1620265379', AuthTy = 'card', memberId = 'azfoods01', OrdNm ='박정운', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)에이젯푸즈', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 558526******2828', rApprNo = 'mjsof2021050610434960252', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-05-06 10:43:43', InvoiceNum = '결제성공:Direct-azfoods01-1620265379/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-05-06 10:43:43' ========================2021-05-06 10:43:43======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021050610434960252' 0 = 1 cnt = 1 ========================2021-05-06 10:43:43======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'azfoods01' 0 = azfoods01 Mid = azfoods01 1 = (주)에이젯푸즈 Mcompany = (주)에이젯푸즈 2 = 4098625143 companyNum = 4098625143 3 = 062-524-0600 Mtel1 = 062-524-0600 4 = 010-7177-8486 Mhp = 010-7177-8486 ========================2021-05-06 10:43:43======================== select * from customers where id = 'azfoods01' ========================2021-05-06 10:43:43======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('azfoods01','2021-05-06 10:43:43','108000','110000','온라인','0') ========================2021-05-06 11:21:37======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kds1-1620267647 LGD_BUYER = 오정호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210506112047 LGD_HASHDATA = 92b9debd3208ebf2b328162613f67885 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 202105061121434A37D27AA1D545609E08C57E6C07E314UBIFS2VI Mname = 오정호 Mcompany = 메인로드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kds1 LGD_ESCROW_USEYN = N ========================2021-05-06 11:21:37======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210506112144 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003300 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******9875 LGD_FINANCEAUTHNUM = 30114379 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5b7c929b5aca4d04bd0a6ae18eac9ec2 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210506112144 LGD_PCANCELSTR = 0 LGD_BUYER = 오정호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021050611214460034 LGD_BUYERID = LGD_OID = Direct-kds1-1620267647 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 611214460018 ========================2021-05-06 11:21:37======================== insert into mBoard_order set rOrdNo = 'Direct-kds1-1620267647', AuthTy = 'card', memberId = 'kds1', OrdNm ='오정호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '메인로드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 558526******9875', rApprNo = 'mjsof2021050611214460034', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-05-06 11:21:37', InvoiceNum = '결제성공:Direct-kds1-1620267647/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-05-06 11:21:37' ========================2021-05-06 11:21:37======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021050611214460034' 0 = 1 cnt = 1 ========================2021-05-06 11:21:37======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kds1' 0 = kds1 Mid = kds1 1 = 메인로드 Mcompany = 메인로드 2 = 1180300092 companyNum = 1180300092 3 = 031-267-3340 Mtel1 = 031-267-3340 4 = 010-8680-1206 Mhp = 010-8680-1206 ========================2021-05-06 11:21:37======================== select * from customers where id = 'kds1' ========================2021-05-06 11:21:37======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kds1','2021-05-06 11:21:37','52500','55000','온라인','0') ========================2021-05-06 13:21:50======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-chparkg-1620274846 LGD_BUYER = 박춘화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210506132046 LGD_HASHDATA = 76205efefee09215f7de919d12f79c4f LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 202105061321577338EDD603744808BE076CD93121B577QYY4GI2A Mname = 박춘화 Mcompany = 주식회사 동보 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = chparkg LGD_ESCROW_USEYN = N ========================2021-05-06 13:21:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210506132157 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 943017******0893 LGD_FINANCEAUTHNUM = 49309093 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 79b94edee799a5fa1273f28348c594b7 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20210506132158 LGD_PCANCELSTR = 0 LGD_BUYER = 박춘화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021050613215760132 LGD_BUYERID = LGD_OID = Direct-chparkg-1620274846 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-05-06 13:21:51======================== insert into mBoard_order set rOrdNo = 'Direct-chparkg-1620274846', AuthTy = 'card', memberId = 'chparkg', OrdNm ='박춘화', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 동보', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH 943017******0893', rApprNo = 'mjsof2021050613215760132', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-05-06 13:21:51', InvoiceNum = '결제성공:Direct-chparkg-1620274846/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-05-06 13:21:51' ========================2021-05-06 13:21:51======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021050613215760132' 0 = 1 cnt = 1 ========================2021-05-06 13:21:51======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'chparkg' 0 = chparkg Mid = chparkg 1 = 주식회사 동보 Mcompany = 주식회사 동보 2 = 721-88-00857 companyNum = 721-88-00857 3 = 054-859-3315 Mtel1 = 054-859-3315 4 = 010-8004-3304 Mhp = 010-8004-3304 ========================2021-05-06 13:21:51======================== select * from customers where id = 'chparkg' ========================2021-05-06 13:21:51======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('chparkg','2021-05-06 13:21:51','108000','110000','온라인','0') ========================2021-05-06 13:50:16======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1620276550 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210506134910 LGD_HASHDATA = 717f94e4ee0126f2fad6a7935c014382 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 202105061350239F28D7B9FCFF48F9914373512162472DINYYUJG2 Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2021-05-06 13:50:17======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210506135023 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 943017******8249 LGD_FINANCEAUTHNUM = 49593904 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a66f36276c27bd44fa6278c9fecca1b9 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20210506135024 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021050613502360091 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1620276550 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-05-06 13:50:17======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1620276550', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 943017******8249', rApprNo = 'mjsof2021050613502360091', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-05-06 13:50:17', InvoiceNum = '결제성공:Direct-goodssal5707-1620276550/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-05-06 13:50:17' ========================2021-05-06 13:50:17======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021050613502360091' 0 = 1 cnt = 1 ========================2021-05-06 13:50:17======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-9718-9753 Mhp = 010-9718-9753 ========================2021-05-06 13:50:17======================== select * from customers where id = 'goodssal5707' ========================2021-05-06 13:50:17======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2021-05-06 13:50:17','220000','220000','온라인','0') ========================2021-05-06 13:51:23======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1620276628 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210506135028 LGD_HASHDATA = 4ef1ffece52ccc6163df403cd5835e1a LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210506135129D03D69A7473949AE95E7954E76FF5CC2BSFMZI56 Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2021-05-06 13:51:23======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210506135130 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 943017******8249 LGD_FINANCEAUTHNUM = 49604573 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 051bb83119636e18e5c5bed6045738a1 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20210506135130 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021050613513061246 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1620276628 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-05-06 13:51:23======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1620276628', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 943017******8249', rApprNo = 'mjsof2021050613513061246', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-05-06 13:51:23', InvoiceNum = '결제성공:Direct-goodssal5707-1620276628/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-05-06 13:51:23' ========================2021-05-06 13:51:23======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021050613513061246' 0 = 1 cnt = 1 ========================2021-05-06 13:51:23======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-9718-9753 Mhp = 010-9718-9753 ========================2021-05-06 13:51:23======================== select * from customers where id = 'goodssal5707' ========================2021-05-06 13:51:23======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2021-05-06 13:51:23','220000','220000','온라인','0') ========================2021-05-06 15:52:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sejifc-1620283897 LGD_BUYER = 이정화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210506155137 LGD_HASHDATA = b054d7723324decf950b420102388dc3 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 202105061552244AA6D76B0FD84B5C949CD15D3E827E63LTUOYZ9Z Mname = 이정화 Mcompany = (주)세지에프씨 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = sejifc LGD_ESCROW_USEYN = N ========================2021-05-06 15:52:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210506155224 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 = 940915******6902 LGD_FINANCEAUTHNUM = 48055888 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 71000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 67e2110c660f5a76596654f469f0d42d LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20210506155225 LGD_PCANCELSTR = 0 LGD_BUYER = 이정화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021050615522461036 LGD_BUYERID = LGD_OID = Direct-sejifc-1620283897 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-05-06 15:52:18======================== insert into mBoard_order set rOrdNo = 'Direct-sejifc-1620283897', AuthTy = 'card', memberId = 'sejifc', OrdNm ='이정화', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)세지에프씨', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '롯데 940915******6902', rApprNo = 'mjsof2021050615522461036', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-05-06 15:52:18', InvoiceNum = '결제성공:Direct-sejifc-1620283897/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-05-06 15:52:18' ========================2021-05-06 15:52:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021050615522461036' 0 = 1 cnt = 1 ========================2021-05-06 15:52:18======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sejifc' 0 = sejifc Mid = sejifc 1 = (주)세지에프씨 Mcompany = (주)세지에프씨 2 = 214-88-52124 companyNum = 214-88-52124 3 = 02-522-6777 Mtel1 = 02-522-6777 4 = 010-8952-2514 Mhp = 010-8952-2514 ========================2021-05-06 15:52:18======================== select * from customers where id = 'sejifc' ========================2021-05-06 15:52:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sejifc','2021-05-06 15:52:18','30900','33000','온라인','0') ========================2021-05-06 17:50:11======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bigbrother-1620290962 LGD_BUYER = 신완철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210506174922 LGD_HASHDATA = 764c9b58c8b16b8ee19eb9101182b2e7 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 202105061750184AA6C74F9C42476890058B5EBF900E90STILJNI1 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 ========================2021-05-06 17:50:12======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210506175019 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = big572@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = 224776 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558920******2390 LGD_FINANCEAUTHNUM = 45467184 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6e062a86f7d69fcaa463113db54b9946 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210506175019 LGD_PCANCELSTR = 0 LGD_BUYER = 신완철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021050617501860197 LGD_BUYERID = LGD_OID = Direct-bigbrother-1620290962 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 617501860128 ========================2021-05-06 17:50:12======================== insert into mBoard_order set rOrdNo = 'Direct-bigbrother-1620290962', AuthTy = 'card', memberId = 'bigbrother', OrdNm ='신완철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)빅브라더', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리MASTER 558920******2390', rApprNo = 'mjsof2021050617501860197', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-05-06 17:50:12', InvoiceNum = '결제성공:Direct-bigbrother-1620290962/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-05-06 17:50:12' ========================2021-05-06 17:50:12======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021050617501860197' 0 = 1 cnt = 1 ========================2021-05-06 17:50:12======================== 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 ========================2021-05-06 17:50:12======================== select * from customers where id = 'bigbrother' ========================2021-05-06 17:50:12======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bigbrother','2021-05-06 17:50:12','220000','220000','온라인','0') ========================2021-05-06 19:39:43======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sejongfnc-1620297165 LGD_BUYER = 권대근 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210506193245 LGD_HASHDATA = bd43b278aa5575bebe8397027292a251 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 202105061939508E25A51615C641A89AD4397A746AFD88NSGXPJA9 Mname = 권대근 Mcompany = (주)세종에프앤씨 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = sejongfnc LGD_ESCROW_USEYN = N ========================2021-05-06 19:39:44======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210506193950 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 943116******9108 LGD_FINANCEAUTHNUM = 53174467 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 52bce333036418729d5b83b1b223137f LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20210506193951 LGD_PCANCELSTR = 0 LGD_BUYER = 권대근 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021050619395060014 LGD_BUYERID = LGD_OID = Direct-sejongfnc-1620297165 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-05-06 19:39:44======================== insert into mBoard_order set rOrdNo = 'Direct-sejongfnc-1620297165', AuthTy = 'card', memberId = 'sejongfnc', OrdNm ='권대근', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)세종에프앤씨', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = 'NH 943116******9108', rApprNo = 'mjsof2021050619395060014', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-05-06 19:39:44', InvoiceNum = '결제성공:Direct-sejongfnc-1620297165/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-05-06 19:39:44' ========================2021-05-06 19:39:44======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021050619395060014' 0 = 1 cnt = 1 ========================2021-05-06 19:39:44======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sejongfnc' 0 = sejongfnc Mid = sejongfnc 1 = (주)세종에프앤씨 Mcompany = (주)세종에프앤씨 2 = 2228800796 companyNum = 2228800796 3 = 010-7173-2314 Mtel1 = 010-7173-2314 4 = 010-7173-2314 Mhp = 010-7173-2314 ========================2021-05-06 19:39:44======================== select * from customers where id = 'sejongfnc' ========================2021-05-06 19:39:44======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sejongfnc','2021-05-06 19:39:44','10000','11000','온라인','0')