========================2023-03-03 11:13:12======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pao7894-1677809531 LGD_BUYER = 심재후 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230303111211 LGD_HASHDATA = 074b689e72cc36bbca049b55f0438374 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 = 2023030311185611DCE56B384350712CD95C77EA9B589C626C94FA Mname = 심재후 Mcompany = (주)토탈엘앤씨 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = pao7894 LGD_ESCROW_USEYN = N ========================2023-03-03 11:13:13======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230303111857 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400306****197* LGD_FINANCEAUTHNUM = 67252945 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 21bbfe67d24428a79d018096c75fdf5f LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230303111857 LGD_PCANCELSTR = 0 LGD_BUYER = 심재후 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0012 LGD_TID = mjsof20230303111856V8Qf1 LGD_BUYERID = LGD_OID = Direct-pao7894-1677809531 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3111856VuKJ7 ========================2023-03-03 11:13:13======================== insert into mBoard_order set rOrdNo = 'Direct-pao7894-1677809531', AuthTy = 'card', memberId = 'pao7894', OrdNm =' 심재후', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)토탈엘앤씨', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41400306****197*', rApprNo = 'mjsof20230303111856V8Qf1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-03 11:13:13', InvoiceNum = '결제성공:Direct-pao7894-1677809531/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-03 11:13:13' ========================2023-03-03 11:13:13======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230303111856V8Qf1' 0 = 1 cnt = 1 ========================2023-03-03 11:13:13======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'pao7894' 0 = pao7894 Mid = pao7894 1 = (주)토탈엘앤씨 Mcompany = (주)토탈엘앤씨 2 = 134-86-34108 companyNum = 134-86-34108 3 = 031-366-9051 Mtel1 = 031-366-9051 4 = 010-3022-2227 Mhp = 010-3022-2227 ========================2023-03-03 11:13:13======================== select * from customers where id = 'pao7894' ========================2023-03-03 11:13:13======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('pao7894','2023-03-03 11:13:13','220000','220000','온라인','0') ========================2023-03-03 11:36:05======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-unicomtape-1677810796 LGD_BUYER = (주)유니콤 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230303113316 LGD_HASHDATA = 8e806b35f4f9a22e8cb5c6f4dd78acc6 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 = 202303031141493CC2850C93BA637492BB27729BAE683D97C7BC57 Mname = (주)유니콤 Mcompany = (주)유니콤 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = unicomtape LGD_ESCROW_USEYN = N ========================2023-03-03 11:36:06======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230303114149 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 038535 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55850307****996* LGD_FINANCEAUTHNUM = 67389598 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ec8d27f96d2a30337e6569a49cc5f345 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230303114150 LGD_PCANCELSTR = 0 LGD_BUYER = (주)유니콤 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230303114149OSCO2 LGD_BUYERID = LGD_OID = Direct-unicomtape-1677810796 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3114149OUHV7 ========================2023-03-03 11:36:06======================== insert into mBoard_order set rOrdNo = 'Direct-unicomtape-1677810796', AuthTy = 'card', memberId = 'unicomtape', OrdNm ='(주)유니콤', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)유니콤', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '비씨MASTER 55850307****996*', rApprNo = 'mjsof20230303114149OSCO2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-03 11:36:06', InvoiceNum = '결제성공:Direct-unicomtape-1677810796/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-03 11:36:06' ========================2023-03-03 11:36:06======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230303114149OSCO2' 0 = 1 cnt = 1 ========================2023-03-03 11:36:06======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'unicomtape' 0 = unicomtape Mid = unicomtape 1 = (주)유니콤 Mcompany = (주)유니콤 2 = 505-81-47339 companyNum = 505-81-47339 3 = 054-744-0811 Mtel1 = 054-744-0811 4 = 010-7741-3035 Mhp = 010-7741-3035 ========================2023-03-03 11:36:06======================== select * from customers where id = 'unicomtape' ========================2023-03-03 11:36:06======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('unicomtape','2023-03-03 11:36:06','10000','11000','온라인','0') ========================2023-03-03 11:54:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1677811847 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230303115047 LGD_HASHDATA = a8c12bb41119fec73f3ad2154cdc8d23 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 = 2023030312000115AC9EE621CD783673487CF60135ACEC1500C2D6 Mname = 최경환 Mcompany = (주)매머드커피랩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = mmthcoffee LGD_ESCROW_USEYN = N ========================2023-03-03 11:54:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230303120002 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = tax@mmth.co.kr LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 031095 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300309****993* LGD_FINANCEAUTHNUM = 67497385 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 39d813ed5917c42f81e48526ef06fc01 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230303120002 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230303120001Upr93 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1677811847 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3120001Ug7y2 ========================2023-03-03 11:54:18======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1677811847', AuthTy = 'card', memberId = 'mmthcoffee', OrdNm ='최경환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)매머드커피랩', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 94300309****993*', rApprNo = 'mjsof20230303120001Upr93', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-03 11:54:18', InvoiceNum = '결제성공:Direct-mmthcoffee-1677811847/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-03 11:54:18' ========================2023-03-03 11:54:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230303120001Upr93' 0 = 1 cnt = 1 ========================2023-03-03 11:54:18======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mmthcoffee' 0 = mmthcoffee Mid = mmthcoffee 1 = (주)매머드커피랩 Mcompany = (주)매머드커피랩 2 = 1058779176 companyNum = 1058779176 3 = 031-794-5086 Mtel1 = 031-794-5086 4 = 010-4595-5086 Mhp = 010-4595-5086 ========================2023-03-03 11:54:18======================== select * from customers where id = 'mmthcoffee' ========================2023-03-03 11:54:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2023-03-03 11:54:18','220000','220000','온라인','0') ========================2023-03-03 13:21:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bakeryall-1677817200 LGD_BUYER = 박병배 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230303132000 LGD_HASHDATA = 53150a5df0091678845a8d4a91effbc3 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 = 202303031327365B684BBF0A677C1B013BD1565C690414D6473A38 Mname = 박병배 Mcompany = (주)베이커리의 모든 것 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = bakeryall LGD_ESCROW_USEYN = N ========================2023-03-03 13:21:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230303132736 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 = 49029841****938* LGD_FINANCEAUTHNUM = 45603605 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8e6509f5e9cd78d54e4bd6b300d8055f LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20230303132737 LGD_PCANCELSTR = 0 LGD_BUYER = 박병배 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230303132736VkHv7 LGD_BUYERID = LGD_OID = Direct-bakeryall-1677817200 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-03-03 13:21:53======================== insert into mBoard_order set rOrdNo = 'Direct-bakeryall-1677817200', AuthTy = 'card', memberId = 'bakeryall', OrdNm ='박병배', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)베이커리의 모든 것', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한VISA 49029841****938*', rApprNo = 'mjsof20230303132736VkHv7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-03 13:21:53', InvoiceNum = '결제성공:Direct-bakeryall-1677817200/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-03 13:21:53' ========================2023-03-03 13:21:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230303132736VkHv7' 0 = 1 cnt = 1 ========================2023-03-03 13:21:53======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bakeryall' 0 = bakeryall Mid = bakeryall 1 = (주)베이커리의 모든 것 Mcompany = (주)베이커리의 모든 것 2 = 5768800922 companyNum = 5768800922 3 = 064-722-2446 Mtel1 = 064-722-2446 4 = 010-9257-0407 Mhp = 010-9257-0407 ========================2023-03-03 13:21:53======================== select * from customers where id = 'bakeryall' ========================2023-03-03 13:21:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bakeryall','2023-03-03 13:21:53','220000','220000','온라인','0') ========================2023-03-03 13:54:30======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-fab9992-1677819223 LGD_BUYER = 신호철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230303135343 LGD_HASHDATA = 878a91f9a5451b43d527bafbb5e0caaa 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 = 202303031400144F99C838BD2FF993B7E838EA6191BBB55070D1A4 Mname = 신호철 Mcompany = 대도스포츠 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = fab9992 LGD_ESCROW_USEYN = N ========================2023-03-03 13:54:31======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230303140014 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 004650 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658629****806* LGD_FINANCEAUTHNUM = 30007807 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 732b832a2ff717b6d46d4e3452887eee LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230303140015 LGD_PCANCELSTR = 0 LGD_BUYER = 신호철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230303140014W64Z3 LGD_BUYERID = LGD_OID = Direct-fab9992-1677819223 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-03-03 13:54:31======================== insert into mBoard_order set rOrdNo = 'Direct-fab9992-1677819223', AuthTy = 'card', memberId = 'fab9992', OrdNm ='신호철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대도스포츠', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민VISA 42658629****806*', rApprNo = 'mjsof20230303140014W64Z3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-03 13:54:31', InvoiceNum = '결제성공:Direct-fab9992-1677819223/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-03 13:54:31' ========================2023-03-03 13:54:31======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230303140014W64Z3' 0 = 1 cnt = 1 ========================2023-03-03 13:54:31======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'fab9992' 0 = fab9992 Mid = fab9992 1 = 대도스포츠 Mcompany = 대도스포츠 2 = 5360302018 companyNum = 5360302018 3 = 02-853-5036 Mtel1 = 02-853-5036 4 = 010-4751-0004 Mhp = 010-4751-0004 ========================2023-03-03 13:54:31======================== select * from customers where id = 'fab9992' ========================2023-03-03 13:54:31======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('fab9992','2023-03-03 13:54:31','108000','110000','온라인','0') ========================2023-03-03 15:10:00======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-c00771-1677823716 LGD_BUYER = 전세일 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230303150836 LGD_HASHDATA = 5c989f2e9a148eae90b5e0282ad38707 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 = 20230303151544939C4FADBA64762E25861E3A4541353B01DAB1C8 Mname = 전세일 Mcompany = 척테크 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = c00771 LGD_ESCROW_USEYN = N ========================2023-03-03 15:10:00======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230303151544 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = chucktech1516@naver.com 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 = 45749200****911* LGD_FINANCEAUTHNUM = 00333198 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 49a99b2495a419e4860961faedfa20b2 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20230303151544 LGD_PCANCELSTR = 0 LGD_BUYER = 전세일 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230303151544uHrG8 LGD_BUYERID = LGD_OID = Direct-c00771-1677823716 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-03-03 15:10:00======================== insert into mBoard_order set rOrdNo = 'Direct-c00771-1677823716', AuthTy = 'card', memberId = 'c00771', OrdNm ='전세일', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '척테크', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '현대VISA 45749200****911*', rApprNo = 'mjsof20230303151544uHrG8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-03 15:10:00', InvoiceNum = '결제성공:Direct-c00771-1677823716/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-03 15:10:00' ========================2023-03-03 15:10:01======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230303151544uHrG8' 0 = 1 cnt = 1 ========================2023-03-03 15:10:01======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'c00771' 0 = c00771 Mid = c00771 1 = 척테크 Mcompany = 척테크 2 = 539-14-00771 companyNum = 539-14-00771 3 = 02-3394-7801 Mtel1 = 02-3394-7801 4 = 010-6280-7566 Mhp = 010-6280-7566 ========================2023-03-03 15:10:01======================== select * from customers where id = 'c00771' ========================2023-03-03 15:10:01======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('c00771','2023-03-03 15:10:00','220000','220000','온라인','0') ========================2023-03-03 17:49:23======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-davis747-1677833278 LGD_BUYER = 홍연호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230303174758 LGD_HASHDATA = e42d41b44b89041be758f1390c3d15b6 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 = 202303031755059BE5D12A78405D409E00BF8F2344E4FA31C56837 Mname = 홍연호 Mcompany = (주)다비스다이아몬드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = davis747 LGD_ESCROW_USEYN = N ========================2023-03-03 17:49:24======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230303175508 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 000000 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658696****764* LGD_FINANCEAUTHNUM = 30052705 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 51d5833dc8551747bbb8dddae2d74588 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230303175508 LGD_PCANCELSTR = 0 LGD_BUYER = 홍연호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230303175507PWyv1 LGD_BUYERID = LGD_OID = Direct-davis747-1677833278 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3175507PNM91 ========================2023-03-03 17:53:08======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-davis747-1677833548 LGD_BUYER = 홍연호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230303175228 LGD_HASHDATA = 4ce3b4d3343eb7bae56cfeb3c9167e10 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 = 20230303175852E25C4E36DBD258E9617FBED8F98EFAA639ED56A4 Mname = 홍연호 Mcompany = (주)다비스다이아몬드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = davis747 LGD_ESCROW_USEYN = N ========================2023-03-03 17:53:08======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230303175852 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 000000 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658696****764* LGD_FINANCEAUTHNUM = 30052716 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 110e9b2f6edb47b42042dc64185df6d5 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230303175852 LGD_PCANCELSTR = 0 LGD_BUYER = 홍연호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230303175852Tvrd1 LGD_BUYERID = LGD_OID = Direct-davis747-1677833548 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3175852TWkH5 ========================2023-03-03 17:55:09======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-davis747-1677833654 LGD_BUYER = 홍연호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230303175414 LGD_HASHDATA = d43a2911753560107f65207b3e2ccbfd 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 = 20230303180052133F93EBF094E864CF50DB0F8AC30E23E5F7297F Mname = 홍연호 Mcompany = (주)다비스다이아몬드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = davis747 LGD_ESCROW_USEYN = N ========================2023-03-03 17:55:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230303180053 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 000000 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658696****764* LGD_FINANCEAUTHNUM = 30052727 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 391e4848d1a19fee207288e5b363146e LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230303180053 LGD_PCANCELSTR = 0 LGD_BUYER = 홍연호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230303180053WUJ60 LGD_BUYERID = LGD_OID = Direct-davis747-1677833654 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3180053WV2g8 ========================2023-03-03 17:55:09======================== insert into mBoard_order set rOrdNo = 'Direct-davis747-1677833654', AuthTy = 'card', memberId = 'davis747', OrdNm ='홍연호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)다비스다이아몬드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민VISA 42658696****764*', rApprNo = 'mjsof20230303180053WUJ60', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-03 17:55:09', InvoiceNum = '결제성공:Direct-davis747-1677833654/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-03 17:55:09' ========================2023-03-03 17:55:09======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230303180053WUJ60' 0 = 1 cnt = 1 ========================2023-03-03 17:55:09======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'davis747' 0 = davis747 Mid = davis747 1 = (주)다비스다이아몬드 Mcompany = (주)다비스다이아몬드 2 = 101-81-80077 companyNum = 101-81-80077 3 = 02-747-1802 Mtel1 = 02-747-1802 4 = 010-7528-2227 Mhp = 010-7528-2227 ========================2023-03-03 17:55:09======================== select * from customers where id = 'davis747' ========================2023-03-03 17:55:09======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('davis747','2023-03-03 17:55:09','108000','110000','온라인','0')