========================2022-10-28 12:01:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jhs177-1666926043 LGD_BUYER = 진희성 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221028120043 LGD_HASHDATA = f664e12f6cb9ab2ab37f80576f105ac1 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 = 20221028120443A30C421D5E9EEE28AE98507A68E18E00F492F077 Mname = 진희성 Mcompany = 푸른교육사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = jhs177 LGD_ESCROW_USEYN = N ========================2022-10-28 12:01:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221028120444 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 009040 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 54092682****308* LGD_FINANCEAUTHNUM = 30029153 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3f78a2f57983b473f3a49b3b80bf85df LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20221028120444 LGD_PCANCELSTR = 0 LGD_BUYER = 진희성 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof2022102812044442r46 LGD_BUYERID = LGD_OID = Direct-jhs177-1666926043 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-28 13:15:04======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goyang8989-1666930318 LGD_BUYER = 임정범 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221028131158 LGD_HASHDATA = 719a0760ed577ae54521cf610071612f 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 = 20221028131829FFC01597ADCB789A1304AD9FAADD4A51B63E5DD7 Mname = 임정범 Mcompany = 고양가전총판 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = goyang8989 LGD_ESCROW_USEYN = N ========================2022-10-28 13:15:05======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221028131829 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003345 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 46323516****501* LGD_FINANCEAUTHNUM = 30011324 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = ec682817b00147a2c692d43957a04072 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20221028131830 LGD_PCANCELSTR = 0 LGD_BUYER = 임정범 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof202210281318290xSq6 LGD_BUYERID = LGD_OID = Direct-goyang8989-1666930318 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-28 13:15:05======================== insert into mBoard_order set rOrdNo = 'Direct-goyang8989-1666930318', AuthTy = 'card', memberId = 'goyang8989', OrdNm ='임정범', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '고양가전총판', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '국민VISA 46323516****501*', rApprNo = 'mjsof202210281318290xSq6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-28 13:15:05', InvoiceNum = '결제성공:Direct-goyang8989-1666930318/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-28 13:15:05' ========================2022-10-28 13:15:05======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202210281318290xSq6' 0 = 1 cnt = 1 ========================2022-10-28 13:15:05======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goyang8989' 0 = goyang8989 Mid = goyang8989 1 = 고양가전총판 Mcompany = 고양가전총판 2 = 218-26-70261 companyNum = 218-26-70261 3 = 031-962-5345 Mtel1 = 031-962-5345 4 = 010-2023-5345 Mhp = 010-2023-5345 ========================2022-10-28 13:15:05======================== select * from customers where id = 'goyang8989' ========================2022-10-28 13:15:05======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goyang8989','2022-10-28 13:15:05','30900','33000','온라인','0') ========================2022-10-28 13:44:57======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ksb7925-1666932235 LGD_BUYER = 고성배 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221028134355 LGD_HASHDATA = 581618c1ab3e4fce7278b99b7a20082d 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 = 20221028134822F27343A14E53B53020D043045BC9313EF014D64D Mname = 고성배 Mcompany = (주)디앤유 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ksb7925 LGD_ESCROW_USEYN = N ========================2022-10-28 13:44:58======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221028134823 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 328193 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 65413211****293* LGD_FINANCEAUTHNUM = 66541922 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31500 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 87b84fb67fc87eed28f3ed95006078b4 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨DINERS LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221028134823 LGD_PCANCELSTR = 0 LGD_BUYER = 고성배 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221028134822YrXh3 LGD_BUYERID = LGD_OID = Direct-ksb7925-1666932235 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8134822YlIL9 ========================2022-10-28 13:44:58======================== insert into mBoard_order set rOrdNo = 'Direct-ksb7925-1666932235', AuthTy = 'card', memberId = 'ksb7925', OrdNm ='고성배', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)디앤유', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨DINERS 65413211****293*', rApprNo = 'mjsof20221028134822YrXh3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-28 13:44:58', InvoiceNum = '결제성공:Direct-ksb7925-1666932235/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-28 13:44:58' ========================2022-10-28 13:44:58======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221028134822YrXh3' 0 = 1 cnt = 1 ========================2022-10-28 13:44:58======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ksb7925' 0 = ksb7925 Mid = ksb7925 1 = (주)디앤유 Mcompany = (주)디앤유 2 = 6178614271 companyNum = 6178614271 3 = 010-4782-0770 Mtel1 = 010-4782-0770 4 = 010-4782-0770 Mhp = 010-4782-0770 ========================2022-10-28 13:44:58======================== select * from customers where id = 'ksb7925' ========================2022-10-28 13:44:58======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ksb7925','2022-10-28 13:44:58','220000','220000','온라인','0') ========================2022-10-28 13:48:14======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jhs177-1666932429 LGD_BUYER = 진희성 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221028134709 LGD_HASHDATA = a42cbb3244afaa1876c4161352d4d128 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 = 2022102813513985D4E7985D85F06FC987C9CF4FC86295B0DCF7B4 Mname = 진희성 Mcompany = 푸른교육사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = jhs177 LGD_ESCROW_USEYN = N ========================2022-10-28 13:48:14======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221028135139 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 009040 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 54092647****700* LGD_FINANCEAUTHNUM = 30029164 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8074e71bb1489897747d59fe615b0ed3 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20221028135139 LGD_PCANCELSTR = 0 LGD_BUYER = 진희성 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof202210281351396uIG0 LGD_BUYERID = LGD_OID = Direct-jhs177-1666932429 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007