========================2021-04-01 07:25:26======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-isdsl1-1617229438 LGD_BUYER = 박성준 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210401072358 LGD_HASHDATA = 177131d6ebb4356e1e7285de0431d34e 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 = 20210401072531D738927D89E8F134E0AF6852EEDCC5E119123561 Mname = 박성준 Mcompany = 아이원푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = isdsl1 LGD_ESCROW_USEYN = N ========================2021-04-01 07:25:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210401072531 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = CAC626 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 490298******5791 LGD_FINANCEAUTHNUM = 14895243 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e1dfc6169d31dd236e79c44839ebcec5 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210401072532 LGD_PCANCELSTR = 0 LGD_BUYER = 박성준 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021040107253161010 LGD_BUYERID = LGD_OID = Direct-isdsl1-1617229438 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-04-01 07:25:26======================== insert into mBoard_order set rOrdNo = 'Direct-isdsl1-1617229438', AuthTy = 'card', memberId = 'isdsl1', OrdNm ='박성준', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '아이원푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한VISA 490298******5791', rApprNo = 'mjsof2021040107253161010', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-01 07:25:26', InvoiceNum = '결제성공:Direct-isdsl1-1617229438/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-01 07:25:26' ========================2021-04-01 07:25:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021040107253161010' 0 = 1 cnt = 1 ========================2021-04-01 07:25:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'isdsl1' 0 = isdsl1 Mid = isdsl1 1 = 아이원푸드 Mcompany = 아이원푸드 2 = 1343298322 companyNum = 1343298322 3 = 003-401-6969 Mtel1 = 003-401-6969 4 = 010-7929-6969 Mhp = 010-7929-6969 ========================2021-04-01 07:25:26======================== select * from customers where id = 'isdsl1' ========================2021-04-01 07:25:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('isdsl1','2021-04-01 07:25:26','220000','220000','온라인','0') ========================2021-04-01 09:03:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-keyintech-1617235315 LGD_BUYER = 박기덕 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210401090155 LGD_HASHDATA = 5588a0fba9367ee45b68ba110a02105e 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 = 202104010903254D3D35C9384ACEF4AAF11411F83ABAAD7FCC468F Mname = 박기덕 Mcompany = 키인텍 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = keyintech LGD_ESCROW_USEYN = N ========================2021-04-01 09:03:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210401090325 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 = 558749******3081 LGD_FINANCEAUTHNUM = 97055692 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c2ecfc26af5ee5a1d447f59d86e4200e LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20210401090326 LGD_PCANCELSTR = 0 LGD_BUYER = 박기덕 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021040109032560206 LGD_BUYERID = LGD_OID = Direct-keyintech-1617235315 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-04-01 09:03:20======================== insert into mBoard_order set rOrdNo = 'Direct-keyintech-1617235315', AuthTy = 'card', memberId = 'keyintech', OrdNm ='박기덕', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '키인텍', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '삼성MASTER 558749******3081', rApprNo = 'mjsof2021040109032560206', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-01 09:03:20', InvoiceNum = '결제성공:Direct-keyintech-1617235315/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-01 09:03:20' ========================2021-04-01 09:03:20======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021040109032560206' 0 = 1 cnt = 1 ========================2021-04-01 09:03:20======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'keyintech' 0 = keyintech Mid = keyintech 1 = 키인텍 Mcompany = 키인텍 2 = 1358601954 companyNum = 1358601954 3 = 031-202-4220 Mtel1 = 031-202-4220 4 = 010-8494-6894 Mhp = 010-8494-6894 ========================2021-04-01 09:03:20======================== select * from customers where id = 'keyintech' ========================2021-04-01 09:03:20======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('keyintech','2021-04-01 09:03:20','52500','55000','온라인','0') ========================2021-04-01 09:26:40======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hty0077-1617236729 LGD_BUYER = 김순옥 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210401092529 LGD_HASHDATA = daf3fbd3b444a665fbbebe37ce1f5cd6 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 = 20210401092646BE890C4584F15DAA3EE92F112E68AA740C5F1289 Mname = 김순옥 Mcompany = 세림금속 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = hty0077 LGD_ESCROW_USEYN = N ========================2021-04-01 09:26:41======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210401092646 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 = 553142******3007 LGD_FINANCEAUTHNUM = 00187669 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a97adf53b2cf78e387ecbbba15fbba9d LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210401092647 LGD_PCANCELSTR = 0 LGD_BUYER = 김순옥 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021040109264660016 LGD_BUYERID = LGD_OID = Direct-hty0077-1617236729 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-04-01 09:26:41======================== insert into mBoard_order set rOrdNo = 'Direct-hty0077-1617236729', AuthTy = 'card', memberId = 'hty0077', OrdNm ='김순옥', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '세림금속', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대MASTER 553142******3007', rApprNo = 'mjsof2021040109264660016', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-01 09:26:41', InvoiceNum = '결제성공:Direct-hty0077-1617236729/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-01 09:26:41' ========================2021-04-01 09:26:41======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021040109264660016' 0 = 1 cnt = 1 ========================2021-04-01 09:26:41======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hty0077' 0 = hty0077 Mid = hty0077 1 = 세림금속 Mcompany = 세림금속 2 = 314-86-08375 companyNum = 314-86-08375 3 = 042-931-8103 Mtel1 = 042-931-8103 4 = 010-3116-3015 Mhp = 010-3116-3015 ========================2021-04-01 09:26:41======================== select * from customers where id = 'hty0077' ========================2021-04-01 09:26:41======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hty0077','2021-04-01 09:26:41','108000','110000','온라인','0') ========================2021-04-01 09:52:22======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-seamedi-1617238249 LGD_BUYER = 정덕구 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210401095049 LGD_HASHDATA = febdf2806b92f85cd52946d8808aaabb 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 = 202104010952285EB40B10663D5970A2C3C17BB013A01E364A6D00 Mname = 정덕구 Mcompany = (주)세아메디칼 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = seamedi LGD_ESCROW_USEYN = N ========================2021-04-01 09:52:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210401095228 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = CAC626 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 490298******9135 LGD_FINANCEAUTHNUM = 15815079 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 10710abc512446d1b0ae07520e9b1dd2 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210401095228 LGD_PCANCELSTR = 0 LGD_BUYER = 정덕구 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021040109522861287 LGD_BUYERID = LGD_OID = Direct-seamedi-1617238249 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-04-01 09:52:22======================== insert into mBoard_order set rOrdNo = 'Direct-seamedi-1617238249', AuthTy = 'card', memberId = 'seamedi', OrdNm ='정덕구', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)세아메디칼', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '신한VISA 490298******9135', rApprNo = 'mjsof2021040109522861287', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-01 09:52:22', InvoiceNum = '결제성공:Direct-seamedi-1617238249/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-01 09:52:22' ========================2021-04-01 09:52:22======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021040109522861287' 0 = 1 cnt = 1 ========================2021-04-01 09:52:22======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'seamedi' 0 = seamedi Mid = seamedi 1 = (주)세아메디칼 Mcompany = (주)세아메디칼 2 = 4118602240 companyNum = 4118602240 3 = 010-9110-2731 Mtel1 = 010-9110-2731 4 = 010-9110-2731 Mhp = 010-9110-2731 ========================2021-04-01 09:52:22======================== select * from customers where id = 'seamedi' ========================2021-04-01 09:52:22======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('seamedi','(주)세아메디칼','4118602240','010-9110-2731','010-9110-2731','2021-04-01 09:52:22','온라인') ========================2021-04-01 09:52:22======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('seamedi','2021-04-01 09:52:22','30900','33000','온라인','0') ========================2021-04-01 10:19:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-daintech-1617239910 LGD_BUYER = 주의화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210401101830 LGD_HASHDATA = 5b1c77465bca5127992e729840461649 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 = 202104011019332AA35A9874C341E010BBB44278C1A84F6D92C037 Mname = 주의화 Mcompany = 다인테크주식회사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = daintech LGD_ESCROW_USEYN = N ========================2021-04-01 10:19:28======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210401101934 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 393322 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 414039******6399 LGD_FINANCEAUTHNUM = 58648040 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 57cfebd367282300a95a53c5f5309cfd LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210401101934 LGD_PCANCELSTR = 0 LGD_BUYER = 주의화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021040110193361028 LGD_BUYERID = LGD_OID = Direct-daintech-1617239910 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 110193361037 ========================2021-04-01 10:19:28======================== insert into mBoard_order set rOrdNo = 'Direct-daintech-1617239910', AuthTy = 'card', memberId = 'daintech', OrdNm ='주의화', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '다인테크주식회사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '비씨VISA 414039******6399', rApprNo = 'mjsof2021040110193361028', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-01 10:19:28', InvoiceNum = '결제성공:Direct-daintech-1617239910/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-01 10:19:28' ========================2021-04-01 10:19:28======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021040110193361028' 0 = 1 cnt = 1 ========================2021-04-01 10:19:28======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'daintech' 0 = daintech Mid = daintech 1 = 다인테크주식회사 Mcompany = 다인테크주식회사 2 = 6098194930 companyNum = 6098194930 3 = 055-238-7961 Mtel1 = 055-238-7961 4 = 010-4298-7963 Mhp = 010-4298-7963 ========================2021-04-01 10:19:28======================== select * from customers where id = 'daintech' ========================2021-04-01 10:19:28======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('daintech','다인테크주식회사','6098194930','055-238-7961','010-4298-7963','2021-04-01 10:19:28','온라인') ========================2021-04-01 10:19:28======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('daintech','2021-04-01 10:19:28','30900','33000','온라인','0') ========================2021-04-01 10:45:53======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jjss5009-1617241402 LGD_BUYER = 한명화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210401104322 LGD_HASHDATA = 3a264a8ff16baed491d8d3345137460b 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 = 20210401104558F3BE5423F2957B6AD4B66EFF47E5E298DF8670C6 Mname = 한명화 Mcompany = 주식회사제이앤에스팩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = jjss5009 LGD_ESCROW_USEYN = N ========================2021-04-01 10:45:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210401104559 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 = 553142******7202 LGD_FINANCEAUTHNUM = 00442375 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 87f199cb68a8e809451b77accfb31a07 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210401104559 LGD_PCANCELSTR = 0 LGD_BUYER = 한명화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021040110455960202 LGD_BUYERID = LGD_OID = Direct-jjss5009-1617241402 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-04-01 10:45:53======================== insert into mBoard_order set rOrdNo = 'Direct-jjss5009-1617241402', AuthTy = 'card', memberId = 'jjss5009', OrdNm ='한명화', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사제이앤에스팩', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '현대MASTER 553142******7202', rApprNo = 'mjsof2021040110455960202', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-01 10:45:53', InvoiceNum = '결제성공:Direct-jjss5009-1617241402/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-01 10:45:53' ========================2021-04-01 10:45:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021040110455960202' 0 = 1 cnt = 1 ========================2021-04-01 10:45:53======================== 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 ========================2021-04-01 10:45:53======================== select * from customers where id = 'jjss5009' ========================2021-04-01 10:45:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jjss5009','2021-04-01 10:45:53','52500','55000','온라인','0') ========================2021-04-01 11:08:37======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-motorngear-1617242857 LGD_BUYER = 김혜영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210401110737 LGD_HASHDATA = 9134b7b6064a1226880eaa552efa67cc 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 = 20210401110843555786542DFF6F4FFDFFC76495775E4AAA994949 Mname = 김혜영 Mcompany = 모터앤기어 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = motorngear LGD_ESCROW_USEYN = N ========================2021-04-01 11:08:38======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210401110844 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 738987 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 414003******5950 LGD_FINANCEAUTHNUM = 58938881 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2ed33ac4aee60e0c42daa357d7c2ea77 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210401110844 LGD_PCANCELSTR = 0 LGD_BUYER = 김혜영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021040111084361192 LGD_BUYERID = LGD_OID = Direct-motorngear-1617242857 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 111084361178 ========================2021-04-01 11:08:38======================== insert into mBoard_order set rOrdNo = 'Direct-motorngear-1617242857', AuthTy = 'card', memberId = 'motorngear', OrdNm ='김혜영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '모터앤기어', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨VISA 414003******5950', rApprNo = 'mjsof2021040111084361192', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-01 11:08:38', InvoiceNum = '결제성공:Direct-motorngear-1617242857/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-01 11:08:38' ========================2021-04-01 11:08:38======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021040111084361192' 0 = 1 cnt = 1 ========================2021-04-01 11:08:38======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'motorngear' 0 = motorngear Mid = motorngear 1 = 모터앤기어 Mcompany = 모터앤기어 2 = 131-86-29931 companyNum = 131-86-29931 3 = 032-816-3697 Mtel1 = 032-816-3697 4 = 010-3384-2521 Mhp = 010-3384-2521 ========================2021-04-01 11:08:38======================== select * from customers where id = 'motorngear' ========================2021-04-01 11:08:38======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('motorngear','2021-04-01 11:08:38','52500','55000','온라인','0') ========================2021-04-01 14:25:31======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ositrade-1617254687 LGD_BUYER = (주)오에스아이무역 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210401142447 LGD_HASHDATA = 05ab0e87b45b70d45608cc80105c5983 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 = 20210401142537844588865052A723E8AE1B547FED03B53A6692B1 Mname = (주)오에스아이무역 Mcompany = (주)오에스아이무역 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = ositrade LGD_ESCROW_USEYN = N ========================2021-04-01 14:25:32======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210401142538 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 003332 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******2828 LGD_FINANCEAUTHNUM = 30239389 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 995414209446b3ef12ec6dbc0674d910 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210401142538 LGD_PCANCELSTR = 0 LGD_BUYER = (주)오에스아이무역 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021040114253760230 LGD_BUYERID = LGD_OID = Direct-ositrade-1617254687 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 114253760284 ========================2021-04-01 14:25:32======================== insert into mBoard_order set rOrdNo = 'Direct-ositrade-1617254687', AuthTy = 'card', memberId = 'ositrade', OrdNm ='(주)오에스아이무역', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)오에스아이무역', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 558526******2828', rApprNo = 'mjsof2021040114253760230', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-01 14:25:32', InvoiceNum = '결제성공:Direct-ositrade-1617254687/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-01 14:25:32' ========================2021-04-01 14:25:32======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021040114253760230' 0 = 1 cnt = 1 ========================2021-04-01 14:25:32======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ositrade' 0 = ositrade Mid = ositrade 1 = (주)오에스아이무역 Mcompany = (주)오에스아이무역 2 = 206-86-15838 companyNum = 206-86-15838 3 = 031-529-7155 Mtel1 = 031-529-7155 4 = 010-2253-8722 Mhp = 010-2253-8722 ========================2021-04-01 14:25:32======================== select * from customers where id = 'ositrade' ========================2021-04-01 14:25:32======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ositrade','2021-04-01 14:25:32','52500','55000','온라인','0') ========================2021-04-01 14:56:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-cywsc34-1617256463 LGD_BUYER = 백수형 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210401145423 LGD_HASHDATA = 71248abb61e31ddc4d770a818e14a2e5 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 = 2021040114563219AFE0A07AD3A817FB18E344144652D6558EC1D8 Mname = 백수형 Mcompany = 태권식품 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = cywsc34 LGD_ESCROW_USEYN = N ========================2021-04-01 14:56:27======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210401145633 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 = 457492******9911 LGD_FINANCEAUTHNUM = 00334692 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9a802c0b35fc8ad227bc640cb0f72bfc LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210401145633 LGD_PCANCELSTR = 0 LGD_BUYER = 백수형 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021040114563360055 LGD_BUYERID = LGD_OID = Direct-cywsc34-1617256463 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-04-01 14:56:27======================== insert into mBoard_order set rOrdNo = 'Direct-cywsc34-1617256463', AuthTy = 'card', memberId = 'cywsc34', OrdNm ='백수형', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '태권식품', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대VISA 457492******9911', rApprNo = 'mjsof2021040114563360055', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-01 14:56:27', InvoiceNum = '결제성공:Direct-cywsc34-1617256463/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-01 14:56:27' ========================2021-04-01 14:56:27======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021040114563360055' 0 = 1 cnt = 1 ========================2021-04-01 14:56:27======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'cywsc34' 0 = cywsc34 Mid = cywsc34 1 = 태권식품 Mcompany = 태권식품 2 = 5051278461 companyNum = 5051278461 3 = 054-751-2772 Mtel1 = 054-751-2772 4 = 010-4669-6910 Mhp = 010-4669-6910 ========================2021-04-01 14:56:27======================== select * from customers where id = 'cywsc34' ========================2021-04-01 14:56:27======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('cywsc34','2021-04-01 14:56:27','30900','33000','온라인','0') ========================2021-04-01 16:12:24======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-KYG2031-1617261088 LGD_BUYER = 김용국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210401161128 LGD_HASHDATA = 025c63e07c50b05ae29f36df3843d29b 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 = 202104011612301C226F71D35A9ECCF5A5A558F1FD2E7B1486E089 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 ========================2021-04-01 16:12:25======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210401161231 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = 0000V0 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 553531******0117 LGD_FINANCEAUTHNUM = 61445671 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 35200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ab6877c3d9e6f615e938f794bf12f51f LGD_BUYERADDRESS = LGD_FINANCENAME = 전북MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210401161231 LGD_PCANCELSTR = 0 LGD_BUYER = 김용국 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof2021040116123061230 LGD_BUYERID = LGD_OID = Direct-KYG2031-1617261088 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 011612202378 ========================2021-04-01 16:12:25======================== insert into mBoard_order set rOrdNo = 'Direct-KYG2031-1617261088', AuthTy = 'card', memberId = 'KYG2031', OrdNm ='김용국', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(유)성광물산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '전북MASTER 553531******0117', rApprNo = 'mjsof2021040116123061230', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-01 16:12:25', InvoiceNum = '결제성공:Direct-KYG2031-1617261088/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-01 16:12:25' ========================2021-04-01 16:12:25======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021040116123061230' 0 = 1 cnt = 1 ========================2021-04-01 16:12:25======================== 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-9875-4995 Mhp = 010-9875-4995 ========================2021-04-01 16:12:25======================== select * from customers where id = 'KYG2031' ========================2021-04-01 16:12:25======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('KYG2031','2021-04-01 16:12:25','52500','55000','온라인','0') ========================2021-04-01 16:21:28======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-taiji707-1617261643 LGD_BUYER = 임지영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210401162043 LGD_HASHDATA = bd530d81beeb23b2b64e6ed9aaf6ca86 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 = 202104011621340AA2A3BC1AA8D186DAC148DE6E78AE811EE10DAD Mname = 임지영 Mcompany = 주식회사 제이패스너 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = taiji707 LGD_ESCROW_USEYN = N ========================2021-04-01 16:21:29======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210401162134 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = hju202@jfastener.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 242241 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558903******2988 LGD_FINANCEAUTHNUM = 61512263 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = cd882355df6f8ccad1a8b6109542e561 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210401162135 LGD_PCANCELSTR = 0 LGD_BUYER = 임지영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021040116213461161 LGD_BUYERID = LGD_OID = Direct-taiji707-1617261643 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 116213461115 ========================2021-04-01 16:21:29======================== insert into mBoard_order set rOrdNo = 'Direct-taiji707-1617261643', AuthTy = 'card', memberId = 'taiji707', OrdNm ='임지영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 제이패스너', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨MASTER 558903******2988', rApprNo = 'mjsof2021040116213461161', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-01 16:21:29', InvoiceNum = '결제성공:Direct-taiji707-1617261643/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-01 16:21:29' ========================2021-04-01 16:21:29======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021040116213461161' 0 = 1 cnt = 1 ========================2021-04-01 16:21:29======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'taiji707' 0 = taiji707 Mid = taiji707 1 = 주식회사 제이패스너 Mcompany = 주식회사 제이패스너 2 = 3498600762 companyNum = 3498600762 3 = 031-8019-7706 Mtel1 = 031-8019-7706 4 = 010-7590-4644 Mhp = 010-7590-4644 ========================2021-04-01 16:21:29======================== select * from customers where id = 'taiji707' ========================2021-04-01 16:21:29======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('taiji707','2021-04-01 16:21:29','108000','110000','온라인','0') ========================2021-04-01 16:59:37======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hara-1617263928 LGD_BUYER = 박태진 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210401165848 LGD_HASHDATA = c2096940fcb94820659ec1780664ec6e 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 = 202104011659428A2CE97833CE227C0E30CDFD94DB87B51D604134 Mname = 박태진 Mcompany = 주식회사 하라 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = hara LGD_ESCROW_USEYN = N ========================2021-04-01 16:59:38======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210401165943 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 373ICC LGD_AFFILIATECODE = 755342 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 414003******5905 LGD_FINANCEAUTHNUM = 61749364 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 06966ad023df268fc9a6375323503cc4 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210401165944 LGD_PCANCELSTR = 0 LGD_BUYER = 박태진 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021040116594361160 LGD_BUYERID = LGD_OID = Direct-hara-1617263928 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 116594361180 ========================2021-04-01 16:59:38======================== insert into mBoard_order set rOrdNo = 'Direct-hara-1617263928', AuthTy = 'card', memberId = 'hara', OrdNm ='박태진', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 하라', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨VISA 414003******5905', rApprNo = 'mjsof2021040116594361160', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-01 16:59:38', InvoiceNum = '결제성공:Direct-hara-1617263928/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-01 16:59:38' ========================2021-04-01 16:59:38======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021040116594361160' 0 = 1 cnt = 1 ========================2021-04-01 16:59:38======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hara' 0 = hara Mid = hara 1 = 주식회사 하라 Mcompany = 주식회사 하라 2 = 6248700715 companyNum = 6248700715 3 = 061-278-5144 Mtel1 = 061-278-5144 4 = 010-8700-5002 Mhp = 010-8700-5002 ========================2021-04-01 16:59:38======================== select * from customers where id = 'hara' ========================2021-04-01 16:59:38======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hara','2021-04-01 16:59:38','108000','110000','온라인','0') ========================2021-04-01 20:50:30======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-cm8904-1617277669 LGD_BUYER = 석대환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210401204749 LGD_HASHDATA = e2ee94cba2744c780c523b85bb987f38 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 = 202104012050365A17FABBFAF77D66663292885D7E1D0C03AB38A0 Mname = 석대환 Mcompany = 대흥테크 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = cm8904 LGD_ESCROW_USEYN = N ========================2021-04-01 20:50:30======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210401205036 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 = 417233******2402 LGD_FINANCEAUTHNUM = 00583348 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1351128dc90d5482c7a488390928b8e8 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210401205037 LGD_PCANCELSTR = 0 LGD_BUYER = 석대환 LGD_CARDINSTALLMONTH = 02 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021040120503661208 LGD_BUYERID = LGD_OID = Direct-cm8904-1617277669 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-04-01 20:50:30======================== insert into mBoard_order set rOrdNo = 'Direct-cm8904-1617277669', AuthTy = 'card', memberId = 'cm8904', OrdNm ='석대환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대흥테크', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대VISA 417233******2402', rApprNo = 'mjsof2021040120503661208', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-01 20:50:30', InvoiceNum = '결제성공:Direct-cm8904-1617277669/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-01 20:50:30' ========================2021-04-01 20:50:30======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021040120503661208' 0 = 1 cnt = 1 ========================2021-04-01 20:50:30======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'cm8904' 0 = cm8904 Mid = cm8904 1 = 대흥테크 Mcompany = 대흥테크 2 = 1140251817 companyNum = 1140251817 3 = 02-596-8904 Mtel1 = 02-596-8904 4 = 010-5340-4987 Mhp = 010-5340-4987 ========================2021-04-01 20:50:30======================== select * from customers where id = 'cm8904' ========================2021-04-01 20:50:30======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('cm8904','2021-04-01 20:50:30','108000','110000','온라인','0')