========================2023-04-28 09:03:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-volume0305-1682640187 LGD_BUYER = 모민수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230428090307 LGD_HASHDATA = ce40420213fd0b9fc186074eb9e7db74 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2023042809103773EB813433BDA5F7F109E3655E10ED680778D4D7 Mname = 모민수 Mcompany = 충청건재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = volume0305 LGD_ESCROW_USEYN = N ========================2023-04-28 09:03:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230428091038 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62436303****674* LGD_FINANCEAUTHNUM = 41044677 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 91800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 3afc68b8c3df1366a4b2056a0f9eb154 LGD_BUYERADDRESS = LGD_FINANCENAME = 농협CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20230428091039 LGD_PCANCELSTR = 0 LGD_BUYER = 모민수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230428091038DPtM0 LGD_BUYERID = LGD_OID = Direct-volume0305-1682640187 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-04-28 09:03:53======================== insert into mBoard_order set rOrdNo = 'Direct-volume0305-1682640187', AuthTy = 'card', memberId = 'volume0305', OrdNm ='모민수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '충청건재', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '농협CUP 62436303****674*', rApprNo = 'mjsof20230428091038DPtM0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-04-28 09:03:53', InvoiceNum = '결제성공:Direct-volume0305-1682640187/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-04-28 09:03:53' ========================2023-04-28 09:03:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230428091038DPtM0' 0 = 1 cnt = 1 ========================2023-04-28 09:03:53======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'volume0305' 0 = volume0305 Mid = volume0305 1 = 충청건재 Mcompany = 충청건재 2 = 733-15-01592 companyNum = 733-15-01592 3 = 010-2750-8222 Mtel1 = 010-2750-8222 4 = 010-2750-8222 Mhp = 010-2750-8222 ========================2023-04-28 09:03:53======================== select * from customers where id = 'volume0305' ========================2023-04-28 09:03:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('volume0305','2023-04-28 09:03:53','10000','11000','온라인','0') ========================2023-04-28 13:08:28======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-song1110-1682654783 LGD_BUYER = 송대현 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230428130623 LGD_HASHDATA = 2e92ee0da95c983d07f728415bc51fad LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202304281315141BB1989472900352E6412F76683274074190EC41 Mname = 송대현 Mcompany = 주식회사브이지 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = song1110 LGD_ESCROW_USEYN = N ========================2023-04-28 13:08:29======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230428131514 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852690****301* LGD_FINANCEAUTHNUM = 30016595 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5e58ad0a770560e399d317b55a055414 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230428131515 LGD_PCANCELSTR = 0 LGD_BUYER = 송대현 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230428131514hzs17 LGD_BUYERID = LGD_OID = Direct-song1110-1682654783 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-04-28 13:08:29======================== insert into mBoard_order set rOrdNo = 'Direct-song1110-1682654783', AuthTy = 'card', memberId = 'song1110', OrdNm ='송대현', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사브이지', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852690****301*', rApprNo = 'mjsof20230428131514hzs17', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-04-28 13:08:29', InvoiceNum = '결제성공:Direct-song1110-1682654783/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-04-28 13:08:29' ========================2023-04-28 13:08:29======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230428131514hzs17' 0 = 1 cnt = 1 ========================2023-04-28 13:08:29======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'song1110' 0 = song1110 Mid = song1110 1 = 주식회사브이지 Mcompany = 주식회사브이지 2 = 2698600938 companyNum = 2698600938 3 = 010-2791-8010 Mtel1 = 010-2791-8010 4 = 010-2791-8010 Mhp = 010-2791-8010 ========================2023-04-28 13:08:29======================== select * from customers where id = 'song1110' ========================2023-04-28 13:08:29======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('song1110','2023-04-28 13:08:29','108000','110000','온라인','0') ========================2023-04-28 14:06:30======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jjs8862-1682658340 LGD_BUYER = 정정수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230428140540 LGD_HASHDATA = 881f1877c5a5c9c9f30e905c6d55f0a7 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20230428141316B6981DA1A3638EF47035C013A5E34F9B26F36430 Mname = 정정수 Mcompany = (주)엘리스메드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = jjs8862 LGD_ESCROW_USEYN = N ========================2023-04-28 14:06:31======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230428141317 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 = 55850308****796* LGD_FINANCEAUTHNUM = 68423021 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3c02c1a0d3e25b27df000c7a611a0d51 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230428141317 LGD_PCANCELSTR = 0 LGD_BUYER = 정정수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202304281413178Urm0 LGD_BUYERID = LGD_OID = Direct-jjs8862-1682658340 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8141317845x9 ========================2023-04-28 14:06:31======================== insert into mBoard_order set rOrdNo = 'Direct-jjs8862-1682658340', AuthTy = 'card', memberId = 'jjs8862', OrdNm ='정정수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)엘리스메드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨MASTER 55850308****796*', rApprNo = 'mjsof202304281413178Urm0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-04-28 14:06:31', InvoiceNum = '결제성공:Direct-jjs8862-1682658340/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-04-28 14:06:31' ========================2023-04-28 14:06:31======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202304281413178Urm0' 0 = 1 cnt = 1 ========================2023-04-28 14:06:31======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jjs8862' 0 = jjs8862 Mid = jjs8862 1 = (주)엘리스메드 Mcompany = (주)엘리스메드 2 = 8748600249 companyNum = 8748600249 3 = 055-381-5771 Mtel1 = 055-381-5771 4 = 010-6382-5771 Mhp = 010-6382-5771 ========================2023-04-28 14:06:31======================== select * from customers where id = 'jjs8862' ========================2023-04-28 14:06:31======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jjs8862','2023-04-28 14:06:31','220000','220000','온라인','0') ========================2023-04-28 14:53:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sw9376-1682661135 LGD_BUYER = 고승환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230428145215 LGD_HASHDATA = 5f35fba39a6f5657b8874b1f8ceaf1f3 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2023042814594756F06A09B7CAFF2F72C647A3CDD7566690F542E5 Mname = 고승환 Mcompany = 주식회사 신우 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = sw9376 LGD_ESCROW_USEYN = N ========================2023-04-28 14:53:02======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230428145947 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 = 41400307****994* LGD_FINANCEAUTHNUM = 30686460 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ca559fe774faeb7f72d372236ddab0f1 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230428145948 LGD_PCANCELSTR = 0 LGD_BUYER = 고승환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230428145947a3Rz3 LGD_BUYERID = LGD_OID = Direct-sw9376-1682661135 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8145947aexI6 ========================2023-04-28 14:53:02======================== insert into mBoard_order set rOrdNo = 'Direct-sw9376-1682661135', AuthTy = 'card', memberId = 'sw9376', OrdNm ='고승환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 신우', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41400307****994*', rApprNo = 'mjsof20230428145947a3Rz3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-04-28 14:53:02', InvoiceNum = '결제성공:Direct-sw9376-1682661135/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-04-28 14:53:02' ========================2023-04-28 14:53:02======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230428145947a3Rz3' 0 = 1 cnt = 1 ========================2023-04-28 14:53:02======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sw9376' 0 = sw9376 Mid = sw9376 1 = 주식회사 신우 Mcompany = 주식회사 신우 2 = 125-81-89093 companyNum = 125-81-89093 3 = 031-611-1000 Mtel1 = 031-611-1000 4 = 010-2540-5599 Mhp = 010-2540-5599 ========================2023-04-28 14:53:02======================== select * from customers where id = 'sw9376' ========================2023-04-28 14:53:02======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sw9376','2023-04-28 14:53:02','220000','220000','온라인','0') ========================2023-04-28 14:55:40======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hjlifine-1682661280 LGD_BUYER = 김은혜 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230428145440 LGD_HASHDATA = 13fc070c6bf308f9154199470d7393d8 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202304281502266C1862D729BF4AF4D8D22AEAF80EDCDF061A4212 Mname = 김은혜 Mcompany = (주)화진리파인 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = hjlifine LGD_ESCROW_USEYN = N ========================2023-04-28 14:55:41======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230428150227 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 031095 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400307****291* LGD_FINANCEAUTHNUM = 30756314 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3145414cdb3e8810642096d62d57b83a LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230428150227 LGD_PCANCELSTR = 0 LGD_BUYER = 김은혜 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230428150226711F7 LGD_BUYERID = LGD_OID = Direct-hjlifine-1682661280 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 81502267ZeG4 ========================2023-04-28 14:55:41======================== insert into mBoard_order set rOrdNo = 'Direct-hjlifine-1682661280', AuthTy = 'card', memberId = 'hjlifine', OrdNm ='김은혜', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)화진리파인', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41400307****291*', rApprNo = 'mjsof20230428150226711F7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-04-28 14:55:41', InvoiceNum = '결제성공:Direct-hjlifine-1682661280/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-04-28 14:55:41' ========================2023-04-28 14:55:41======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230428150226711F7' 0 = 1 cnt = 1 ========================2023-04-28 14:55:41======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hjlifine' 0 = hjlifine Mid = hjlifine 1 = (주)화진리파인 Mcompany = (주)화진리파인 2 = 3128185712 companyNum = 3128185712 3 = 041-578-8012 Mtel1 = 041-578-8012 4 = 010-6349-2885 Mhp = 010-6349-2885 ========================2023-04-28 14:55:41======================== select * from customers where id = 'hjlifine' ========================2023-04-28 14:55:41======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hjlifine','2023-04-28 14:55:41','220000','220000','온라인','0') ========================2023-04-28 17:15:18======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-thanks018-1682669661 LGD_BUYER = 강동훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230428171421 LGD_HASHDATA = 5d64f0d10a927d5c2e4bb1e425c42371 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20230428172204612F1997C5B1ADD2DD6B11F673FC3367DFEE3A99 Mname = 강동훈 Mcompany = (주)비전정보전산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = thanks018 LGD_ESCROW_USEYN = N ========================2023-04-28 17:15:19======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230428172205 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55317203****507* LGD_FINANCEAUTHNUM = 46993601 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2efabdfb1e3162820472de6bd052d4de LGD_BUYERADDRESS = LGD_FINANCENAME = NH MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20230428172205 LGD_PCANCELSTR = 0 LGD_BUYER = 강동훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230428172205eGVi0 LGD_BUYERID = LGD_OID = Direct-thanks018-1682669661 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-04-28 17:15:19======================== insert into mBoard_order set rOrdNo = 'Direct-thanks018-1682669661', AuthTy = 'card', memberId = 'thanks018', OrdNm ='강동훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)비전정보전산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH MASTER 55317203****507*', rApprNo = 'mjsof20230428172205eGVi0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-04-28 17:15:19', InvoiceNum = '결제성공:Direct-thanks018-1682669661/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-04-28 17:15:19' ========================2023-04-28 17:15:19======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230428172205eGVi0' 0 = 1 cnt = 1 ========================2023-04-28 17:15:19======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'thanks018' 0 = thanks018 Mid = thanks018 1 = (주)비전정보전산 Mcompany = (주)비전정보전산 2 = 418-81-36163 companyNum = 418-81-36163 3 = 063-214-1911 Mtel1 = 063-214-1911 4 = 018-281-5525 Mhp = 018-281-5525 ========================2023-04-28 17:15:19======================== select * from customers where id = 'thanks018' ========================2023-04-28 17:15:19======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('thanks018','2023-04-28 17:15:19','108000','110000','온라인','0') ========================2023-04-28 17:19:33======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-uksung1966-1682669862 LGD_BUYER = 이성춘 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230428171742 LGD_HASHDATA = dad29802a85578b347f32774463cfefc LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2023042817261926389532C2CA35BA303975564E7AFBFB78AF8D45 Mname = 이성춘 Mcompany = 욱성화학공업사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = uksung1966 LGD_ESCROW_USEYN = N ========================2023-04-28 17:19:34======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230428172620 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = uksung1966@hanmail.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003302 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****181* LGD_FINANCEAUTHNUM = 30102706 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 09c38e9717f1a913ef381d3754a7ff16 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230428172620 LGD_PCANCELSTR = 0 LGD_BUYER = 이성춘 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230428172620hYPj1 LGD_BUYERID = LGD_OID = Direct-uksung1966-1682669862 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8172620hBmt1 ========================2023-04-28 17:19:34======================== insert into mBoard_order set rOrdNo = 'Direct-uksung1966-1682669862', AuthTy = 'card', memberId = 'uksung1966', OrdNm ='이성춘', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '욱성화학공업사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****181*', rApprNo = 'mjsof20230428172620hYPj1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-04-28 17:19:34', InvoiceNum = '결제성공:Direct-uksung1966-1682669862/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-04-28 17:19:34' ========================2023-04-28 17:19:34======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230428172620hYPj1' 0 = 1 cnt = 1 ========================2023-04-28 17:19:34======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'uksung1966' 0 = uksung1966 Mid = uksung1966 1 = 욱성화학공업사 Mcompany = 욱성화학공업사 2 = 113-05-62312 companyNum = 113-05-62312 3 = 031-949-4516 Mtel1 = 031-949-4516 4 = 010-4749-2036 Mhp = 010-4749-2036 ========================2023-04-28 17:19:34======================== select * from customers where id = 'uksung1966' ========================2023-04-28 17:19:34======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('uksung1966','2023-04-28 17:19:34','108000','110000','온라인','0')