========================2021-11-30 08:57:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kimfanju-1638230160 LGD_BUYER = 이은희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211130085600 LGD_HASHDATA = 5c8a8aeb509205aace62a0f65a95e559 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 = 20211130090029D99CC6F195404AD7BF1003CF13B648FAKE8WVDPD Mname = 이은희 Mcompany = 바로푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = kimfanju LGD_ESCROW_USEYN = N ========================2021-11-30 08:57:21======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211130090030 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 242868 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 490220******2522 LGD_FINANCEAUTHNUM = 60040125 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e94fed62e34ab3f81c2a45bce66ea2e8 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211130090030 LGD_PCANCELSTR = 0 LGD_BUYER = 이은희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211130090029pVig0 LGD_BUYERID = LGD_OID = Direct-kimfanju-1638230160 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0090029pHfj1 ========================2021-11-30 08:57:21======================== insert into mBoard_order set rOrdNo = 'Direct-kimfanju-1638230160', AuthTy = 'card', memberId = 'kimfanju', OrdNm ='이은희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '바로푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '우리VISA 490220******2522', rApprNo = 'mjsof20211130090029pVig0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-30 08:57:21', InvoiceNum = '결제성공:Direct-kimfanju-1638230160/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-30 08:57:21' ========================2021-11-30 08:57:21======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211130090029pVig0' 0 = 1 cnt = 1 ========================2021-11-30 08:57:21======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kimfanju' 0 = kimfanju Mid = kimfanju 1 = 바로푸드 Mcompany = 바로푸드 2 = 8805100280 companyNum = 8805100280 3 = 051-752-0017 Mtel1 = 051-752-0017 4 = 010-2980-0017 Mhp = 010-2980-0017 ========================2021-11-30 08:57:21======================== select * from customers where id = 'kimfanju' ========================2021-11-30 08:57:21======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kimfanju','2021-11-30 08:57:21','10000','11000','온라인','0') ========================2021-11-30 10:44:41======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-gas0034-1638236470 LGD_BUYER = 정용석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211130104110 LGD_HASHDATA = 7e8f91ef3a5fb834471d08b449177139 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 = 202111301047519B6FC38D118447188AE14E1317C66942CKRMNKLW Mname = 정용석 Mcompany = 영동종합가스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = gas0034 LGD_ESCROW_USEYN = N ========================2021-11-30 10:44:43======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211130104751 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = jysgas@naver.com 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 = 910003******2488 LGD_FINANCEAUTHNUM = 60702874 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = bacd9437dbbd68a5368faf3fd9ceb683 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211130104752 LGD_PCANCELSTR = 0 LGD_BUYER = 정용석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211130104751r5o19 LGD_BUYERID = LGD_OID = Direct-gas0034-1638236470 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0104751rwMg0 ========================2021-11-30 10:44:43======================== insert into mBoard_order set rOrdNo = 'Direct-gas0034-1638236470', AuthTy = 'card', memberId = 'gas0034', OrdNm ='정용석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '영동종합가스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨 910003******2488', rApprNo = 'mjsof20211130104751r5o19', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-30 10:44:43', InvoiceNum = '결제성공:Direct-gas0034-1638236470/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-30 10:44:43' ========================2021-11-30 10:44:43======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211130104751r5o19' 0 = 1 cnt = 1 ========================2021-11-30 10:44:43======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'gas0034' 0 = gas0034 Mid = gas0034 1 = 영동종합가스 Mcompany = 영동종합가스 2 = 3902400312 companyNum = 3902400312 3 = 010-2747-0592 Mtel1 = 010-2747-0592 4 = 010-5277-5706 Mhp = 010-5277-5706 ========================2021-11-30 10:44:43======================== select * from customers where id = 'gas0034' ========================2021-11-30 10:44:43======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('gas0034','2021-11-30 10:44:43','108000','110000','온라인','0') ========================2021-11-30 13:02:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-k114-1638244906 LGD_BUYER = 김상옥 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211130130146 LGD_HASHDATA = 9abaebc47a79b9df9fb6fc625ecee045 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 = 20211130130600AC0DB2C9E4714E339D82AAF8D4336F27LF6AYECA Mname = 김상옥 Mcompany = 강원산업안전(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = k114 LGD_ESCROW_USEYN = N ========================2021-11-30 13:02:52======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211130130601 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 224776 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558920******9219 LGD_FINANCEAUTHNUM = 61602751 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fc7cbd6c656eb66297d47c7c49c0fa50 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211130130601 LGD_PCANCELSTR = 0 LGD_BUYER = 김상옥 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211130130600qDEr3 LGD_BUYERID = LGD_OID = Direct-k114-1638244906 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0130600qW7O6 ========================2021-11-30 13:02:52======================== insert into mBoard_order set rOrdNo = 'Direct-k114-1638244906', AuthTy = 'card', memberId = 'k114', OrdNm ='김상옥', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '강원산업안전(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리MASTER 558920******9219', rApprNo = 'mjsof20211130130600qDEr3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-30 13:02:52', InvoiceNum = '결제성공:Direct-k114-1638244906/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-30 13:02:52' ========================2021-11-30 13:02:52======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211130130600qDEr3' 0 = 1 cnt = 1 ========================2021-11-30 13:02:52======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'k114' 0 = k114 Mid = k114 1 = 강원산업안전(주) Mcompany = 강원산업안전(주) 2 = 2388100225 companyNum = 2388100225 3 = 033-732-3114 Mtel1 = 033-732-3114 4 = 01-5115-3114 Mhp = 01-5115-3114 ========================2021-11-30 13:02:52======================== select * from customers where id = 'k114' ========================2021-11-30 13:02:52======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('k114','2021-11-30 13:02:52','220000','220000','온라인','0') ========================2021-11-30 14:12:06======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-neotool-1638249064 LGD_BUYER = 김동섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211130141104 LGD_HASHDATA = 51bb06cc9314244ae6840a0f56d88484 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 = 2021113014151548F352C4717040FC9B81581B0F0C1A34AFYLPLYA Mname = 김동섭 Mcompany = (주)네오툴 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = neotool LGD_ESCROW_USEYN = N ========================2021-11-30 14:12:07======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211130141516 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 = 625003******2941 LGD_FINANCEAUTHNUM = 62769548 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 67b93d4e2b71f5f8b06ae06f4d694aed LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211130141516 LGD_PCANCELSTR = 0 LGD_BUYER = 김동섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211130141515qFqz1 LGD_BUYERID = LGD_OID = Direct-neotool-1638249064 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0141515qX1g4 ========================2021-11-30 14:12:07======================== insert into mBoard_order set rOrdNo = 'Direct-neotool-1638249064', AuthTy = 'card', memberId = 'neotool', OrdNm ='김동섭', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)네오툴', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨 625003******2941', rApprNo = 'mjsof20211130141515qFqz1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-30 14:12:07', InvoiceNum = '결제성공:Direct-neotool-1638249064/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-30 14:12:07' ========================2021-11-30 14:12:07======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211130141515qFqz1' 0 = 1 cnt = 1 ========================2021-11-30 14:12:07======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'neotool' 0 = neotool Mid = neotool 1 = (주)네오툴 Mcompany = (주)네오툴 2 = 1138686104 companyNum = 1138686104 3 = 02-1644-0946 Mtel1 = 02-1644-0946 4 = 010-5306-7049 Mhp = 010-5306-7049 ========================2021-11-30 14:12:07======================== select * from customers where id = 'neotool' ========================2021-11-30 14:12:07======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('neotool','2021-11-30 14:12:07','108000','110000','온라인','0') ========================2021-11-30 14:30:04======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-asliquid-1638250131 LGD_BUYER = 조성균 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211130142851 LGD_HASHDATA = 24e647d267c3fdf7ca05b152c4099d7d 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 = 202111301433139B15C6FE8118441097273663844A8B1CMDW1CUKR Mname = 조성균 Mcompany = 오르카 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = asliquid LGD_ESCROW_USEYN = N ========================2021-11-30 14:30:04======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211130143314 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = BFAB8J LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 515594******6198 LGD_FINANCEAUTHNUM = 38060218 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 805912995f48684423bb3ea373df09e7 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20211130143314 LGD_PCANCELSTR = 0 LGD_BUYER = 조성균 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211130143313oc6q6 LGD_BUYERID = LGD_OID = Direct-asliquid-1638250131 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-11-30 14:30:04======================== insert into mBoard_order set rOrdNo = 'Direct-asliquid-1638250131', AuthTy = 'card', memberId = 'asliquid', OrdNm ='조성균', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '오르카', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한MASTER 515594******6198', rApprNo = 'mjsof20211130143313oc6q6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-30 14:30:04', InvoiceNum = '결제성공:Direct-asliquid-1638250131/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-30 14:30:04' ========================2021-11-30 14:30:04======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211130143313oc6q6' 0 = 1 cnt = 1 ========================2021-11-30 14:30:04======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'asliquid' 0 = asliquid Mid = asliquid 1 = 오르카 Mcompany = 오르카 2 = 3170555107 companyNum = 3170555107 3 = 010-9118-5984 Mtel1 = 010-9118-5984 4 = 010-4418-7654 Mhp = 010-4418-7654 ========================2021-11-30 14:30:04======================== select * from customers where id = 'asliquid' ========================2021-11-30 14:30:04======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('asliquid','2021-11-30 14:30:04','108000','110000','온라인','0') ========================2021-11-30 16:17:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jjss5009-1638256589 LGD_BUYER = 한명화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211130161629 LGD_HASHDATA = b29c0f6013d2e398c7a3a19ef86d1f7b 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 = 2021113016210645ECBECEC1E446ECA2B111FF693A5C51QEH54SOK 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-11-30 16:17:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211130162106 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 = 00935682 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8896ea0bfeff97abc730c8c2b71fdade LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20211130162106 LGD_PCANCELSTR = 0 LGD_BUYER = 한명화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211130162106rfnf1 LGD_BUYERID = LGD_OID = Direct-jjss5009-1638256589 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-11-30 16:17:57======================== insert into mBoard_order set rOrdNo = 'Direct-jjss5009-1638256589', 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 = 'mjsof20211130162106rfnf1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-30 16:17:57', InvoiceNum = '결제성공:Direct-jjss5009-1638256589/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-30 16:17:57' ========================2021-11-30 16:17:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211130162106rfnf1' 0 = 1 cnt = 1 ========================2021-11-30 16:17:57======================== 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-11-30 16:17:57======================== select * from customers where id = 'jjss5009' ========================2021-11-30 16:17:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jjss5009','2021-11-30 16:17:57','52500','55000','온라인','0') ========================2021-11-30 18:03:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-feinstyle-1638262965 LGD_BUYER = 최대영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211130180245 LGD_HASHDATA = ad3285772cdc54fab9fcd7b9ffac66c2 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 = 202111301806367E6F234C163B4B70811BE7B8746C5375151VAHRX Mname = 최대영 Mcompany = 더바이스산업공구상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = feinstyle LGD_ESCROW_USEYN = N ========================2021-11-30 18:03:27======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211130180637 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 = 473867******3997 LGD_FINANCEAUTHNUM = 30215129 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 51100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4898ac5bf8bd596240e610ec6cc331d8 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20211130180637 LGD_PCANCELSTR = 0 LGD_BUYER = 최대영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211130180637qPpD3 LGD_BUYERID = LGD_OID = Direct-feinstyle-1638262965 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-11-30 18:03:27======================== insert into mBoard_order set rOrdNo = 'Direct-feinstyle-1638262965', AuthTy = 'card', memberId = 'feinstyle', OrdNm ='최대영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '더바이스산업공구상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '삼성VISA 473867******3997', rApprNo = 'mjsof20211130180637qPpD3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-30 18:03:27', InvoiceNum = '결제성공:Direct-feinstyle-1638262965/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-30 18:03:27' ========================2021-11-30 18:03:28======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211130180637qPpD3' 0 = 1 cnt = 1 ========================2021-11-30 18:03:28======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'feinstyle' 0 = feinstyle Mid = feinstyle 1 = 더바이스산업공구상사 Mcompany = 더바이스산업공구상사 2 = 621-21-51072 companyNum = 621-21-51072 3 = 070-4127-0909 Mtel1 = 070-4127-0909 4 = 010-4437-6515 Mhp = 010-4437-6515 ========================2021-11-30 18:03:28======================== select * from customers where id = 'feinstyle' ========================2021-11-30 18:03:28======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('feinstyle','2021-11-30 18:03:27','10000','11000','온라인','0')