========================2024-08-06 12:46:21======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pao7894-1722915938 LGD_BUYER = 심재후 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240806124538 LGD_HASHDATA = ea3a5f7b4dad466e94c1afbe70b31c21 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 = 20240806124813D91A5123C6FEA38F80BD90682BCE1D67AEDFC75D 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 ========================2024-08-06 12:46:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240806124813 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400316****596* LGD_FINANCEAUTHNUM = 45311348 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d177e0db04b1b288381be67446e0e40a LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240806124814 LGD_PCANCELSTR = 0 LGD_BUYER = 심재후 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240806124813k4zw8 LGD_BUYERID = LGD_OID = Direct-pao7894-1722915938 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 6124813kMu46 ========================2024-08-06 12:46:22======================== insert into mBoard_order set rOrdNo = 'Direct-pao7894-1722915938', AuthTy = 'card', memberId = 'pao7894', OrdNm =' 심재후', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)토탈엘앤씨', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41400316****596*', rApprNo = 'mjsof20240806124813k4zw8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-08-06 12:46:22', InvoiceNum = '결제성공:Direct-pao7894-1722915938/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-08-06 12:46:22' ========================2024-08-06 12:46:22======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240806124813k4zw8' 0 = 1 cnt = 1 ========================2024-08-06 12:46:22======================== 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 ========================2024-08-06 12:46:22======================== select * from customers where id = 'pao7894' ========================2024-08-06 12:46:22======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('pao7894','2024-08-06 12:46:22','220000','220000','온라인','0') ========================2024-08-06 13:08:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-samanrpc-1722917000 LGD_BUYER = 이인숙 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240806130320 LGD_HASHDATA = 0cd1723c6863322c822fe0ccb2365758 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 = 20240806131018C038C71150B0F21FAC2C43373DDDE66B6A891DD8 Mname = 이인숙 Mcompany = (주)미래물산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = samanrpc LGD_ESCROW_USEYN = N ========================2024-08-06 13:08:28======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240806131019 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = insook3535@nate.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003345 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 52050423****697* LGD_FINANCEAUTHNUM = 30005180 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 5de5366b3d5659b91680dd5fe85ed8de LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240806131019 LGD_PCANCELSTR = 0 LGD_BUYER = 이인숙 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240806131019oafP1 LGD_BUYERID = LGD_OID = Direct-samanrpc-1722917000 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 6131019odCy2 ========================2024-08-06 13:08:28======================== insert into mBoard_order set rOrdNo = 'Direct-samanrpc-1722917000', AuthTy = 'card', memberId = 'samanrpc', OrdNm ='이인숙', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)미래물산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 52050423****697*', rApprNo = 'mjsof20240806131019oafP1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-08-06 13:08:28', InvoiceNum = '결제성공:Direct-samanrpc-1722917000/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-08-06 13:08:28' ========================2024-08-06 13:08:28======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240806131019oafP1' 0 = 1 cnt = 1 ========================2024-08-06 13:08:28======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'samanrpc' 0 = samanrpc Mid = samanrpc 1 = (주)미래물산 Mcompany = (주)미래물산 2 = 5148196886 companyNum = 5148196886 3 = 010-3256-9809 Mtel1 = 010-3256-9809 4 = 010-3256-9809 Mhp = 010-3256-9809 ========================2024-08-06 13:08:28======================== select * from customers where id = 'samanrpc' ========================2024-08-06 13:08:28======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('samanrpc','2024-08-06 13:08:28','108000','110000','온라인','0') ========================2024-08-06 15:26:21======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-davis747-1722925533 LGD_BUYER = 홍연호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240806152533 LGD_HASHDATA = f4b35fb099b1aed67f2b6ad493916375 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 = 202408061528124E4CB4CFFC0D53CA6DA506E34F4E99767602F484 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 ========================2024-08-06 15:26:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240806152813 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852695****086* LGD_FINANCEAUTHNUM = 30008788 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7a0313adfc97912f450a92ec70dc2176 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240806152813 LGD_PCANCELSTR = 0 LGD_BUYER = 홍연호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240806152813wPHV7 LGD_BUYERID = LGD_OID = Direct-davis747-1722925533 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 6152813wIvV5 ========================2024-08-06 15:26:22======================== insert into mBoard_order set rOrdNo = 'Direct-davis747-1722925533', AuthTy = 'card', memberId = 'davis747', OrdNm ='홍연호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)다비스다이아몬드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852695****086*', rApprNo = 'mjsof20240806152813wPHV7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-08-06 15:26:22', InvoiceNum = '결제성공:Direct-davis747-1722925533/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-08-06 15:26:22' ========================2024-08-06 15:26:22======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240806152813wPHV7' 0 = 1 cnt = 1 ========================2024-08-06 15:26:22======================== 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 ========================2024-08-06 15:26:22======================== select * from customers where id = 'davis747' ========================2024-08-06 15:26:22======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('davis747','2024-08-06 15:26:22','108000','110000','온라인','0') ========================2024-08-06 15:35:00======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-familyfood82-1722925199 LGD_BUYER = 패밀리푸드 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240806151959 LGD_HASHDATA = 8e2c12ed4d7168f7c2e5019652f046c6 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 = 20240806153652BE09CC98613ACBB920FFAEF64A854516058C768C Mname = 패밀리푸드 Mcompany = 패밀리푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = familyfood82 LGD_ESCROW_USEYN = N ========================2024-08-06 15:35:01======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240806153652 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = familyfood82@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = BGGC7R LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 48703300****619* LGD_FINANCEAUTHNUM = 10759579 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 888a3c238ef4293e735ef9e5c549f372 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240806153653 LGD_PCANCELSTR = 0 LGD_BUYER = 패밀리푸드 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240806153652jHqH7 LGD_BUYERID = LGD_OID = Direct-familyfood82-1722925199 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-08-06 15:35:01======================== insert into mBoard_order set rOrdNo = 'Direct-familyfood82-1722925199', AuthTy = 'card', memberId = 'familyfood82', OrdNm ='패밀리푸드', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '패밀리푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한VISA 48703300****619*', rApprNo = 'mjsof20240806153652jHqH7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-08-06 15:35:01', InvoiceNum = '결제성공:Direct-familyfood82-1722925199/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-08-06 15:35:01' ========================2024-08-06 15:35:01======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240806153652jHqH7' 0 = 1 cnt = 1 ========================2024-08-06 15:35:01======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'familyfood82' 0 = familyfood82 Mid = familyfood82 1 = 패밀리푸드 Mcompany = 패밀리푸드 2 = 2112715814 companyNum = 2112715814 3 = 010-4804-2528 Mtel1 = 010-4804-2528 4 = 010-7652-2982 Mhp = 010-7652-2982 ========================2024-08-06 15:35:01======================== select * from customers where id = 'familyfood82' ========================2024-08-06 15:35:01======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('familyfood82','2024-08-06 15:35:01','220000','220000','온라인','0') ========================2024-08-06 15:45:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-haeyang201-1722926640 LGD_BUYER = 이임규 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240806154400 LGD_HASHDATA = b71381e6dc06abb0fc2d9f39d1507f92 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 = 2024080615472336C84BE82CD242474355595F6F195DAA5222D4EA Mname = 이임규 Mcompany = 해양수산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = haeyang201 LGD_ESCROW_USEYN = N ========================2024-08-06 15:45:32======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240806154724 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003320 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852697****684* LGD_FINANCEAUTHNUM = 30048057 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = def483d3e98ff26cb66f6552ff064b44 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240806154724 LGD_PCANCELSTR = 0 LGD_BUYER = 이임규 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240806154724oAOx7 LGD_BUYERID = LGD_OID = Direct-haeyang201-1722926640 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 6154724olDz7 ========================2024-08-06 15:45:32======================== insert into mBoard_order set rOrdNo = 'Direct-haeyang201-1722926640', AuthTy = 'card', memberId = 'haeyang201', OrdNm ='이임규', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '해양수산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852697****684*', rApprNo = 'mjsof20240806154724oAOx7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-08-06 15:45:32', InvoiceNum = '결제성공:Direct-haeyang201-1722926640/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-08-06 15:45:32' ========================2024-08-06 15:45:33======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240806154724oAOx7' 0 = 1 cnt = 1 ========================2024-08-06 15:45:33======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'haeyang201' 0 = haeyang201 Mid = haeyang201 1 = 해양수산 Mcompany = 해양수산 2 = 2019061047 companyNum = 2019061047 3 = 010-5523-3530 Mtel1 = 010-5523-3530 4 = 010-5523-3530 Mhp = 010-5523-3530 ========================2024-08-06 15:45:33======================== select * from customers where id = 'haeyang201' ========================2024-08-06 15:45:33======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('haeyang201','2024-08-06 15:45:32','108000','110000','온라인','0') ========================2024-08-06 16:14:30======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-samyang0028-1722928405 LGD_BUYER = 주식회사 삼양상사 노형지점 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240806161325 LGD_HASHDATA = 76abf689b242c8646f3deddcd4cbb384 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 = 202408061616223268CC57740619BA20B2C088DC7A5A272B2D964C Mname = 주식회사 삼양상사 노형지점 Mcompany = 주식회사 삼양상사 노형지점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = samyang0028 LGD_ESCROW_USEYN = N ========================2024-08-06 16:14:31======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240806161622 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = bakeryall@bakeryall.co.kr LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = CAC626 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 49029841****938* LGD_FINANCEAUTHNUM = 11265399 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c87f4b0ef1eab7a38072dfa035f4244d LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240806161623 LGD_PCANCELSTR = 0 LGD_BUYER = 주식회사 삼양상사 노형지점 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240806161622kFnB7 LGD_BUYERID = LGD_OID = Direct-samyang0028-1722928405 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-08-06 16:14:31======================== insert into mBoard_order set rOrdNo = 'Direct-samyang0028-1722928405', AuthTy = 'card', memberId = 'samyang0028', OrdNm ='주식회사 삼양상사 노형지점', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 삼양상사 노형지점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '신한VISA 49029841****938*', rApprNo = 'mjsof20240806161622kFnB7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-08-06 16:14:31', InvoiceNum = '결제성공:Direct-samyang0028-1722928405/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-08-06 16:14:31' ========================2024-08-06 16:14:31======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240806161622kFnB7' 0 = 1 cnt = 1 ========================2024-08-06 16:14:31======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'samyang0028' 0 = samyang0028 Mid = samyang0028 1 = 주식회사 삼양상사 노형지점 Mcompany = 주식회사 삼양상사 노형지점 2 = 214-85-58506 companyNum = 214-85-58506 3 = 064-755-0028 Mtel1 = 064-755-0028 4 = 7550028 Mhp = 7550028 ========================2024-08-06 16:14:31======================== select * from customers where id = 'samyang0028' ========================2024-08-06 16:14:31======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('samyang0028','주식회사 삼양상사 노형지점','2148558506','064-755-0028','7550028','2024-08-06 16:14:31','온라인') ========================2024-08-06 16:14:31======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('samyang0028','2024-08-06 16:14:31','10000','11000','온라인','0') ========================2024-08-06 16:19:30======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-samyang0028-1722928711 LGD_BUYER = 주식회사 삼양상사 노형지점 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240806161831 LGD_HASHDATA = 3610ac5e1472beada459dd2e9a51fcb6 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 = 20240806162122DC825096472A448F5F4E70F6ED07E87093643F06 Mname = 주식회사 삼양상사 노형지점 Mcompany = 주식회사 삼양상사 노형지점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = samyang0028 LGD_ESCROW_USEYN = N ========================2024-08-06 16:19:31======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240806162122 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = bakeryall@bakeryall.co.kr LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = CAC626 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 49029841****938* LGD_FINANCEAUTHNUM = 11332621 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5ea84fe7d43416fbeb9d99a9b559e1dd LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240806162122 LGD_PCANCELSTR = 0 LGD_BUYER = 주식회사 삼양상사 노형지점 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240806162122kG6Z1 LGD_BUYERID = LGD_OID = Direct-samyang0028-1722928711 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-08-06 16:19:31======================== insert into mBoard_order set rOrdNo = 'Direct-samyang0028-1722928711', AuthTy = 'card', memberId = 'samyang0028', OrdNm ='주식회사 삼양상사 노형지점', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 삼양상사 노형지점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한VISA 49029841****938*', rApprNo = 'mjsof20240806162122kG6Z1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-08-06 16:19:31', InvoiceNum = '결제성공:Direct-samyang0028-1722928711/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-08-06 16:19:31' ========================2024-08-06 16:19:31======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240806162122kG6Z1' 0 = 1 cnt = 1 ========================2024-08-06 16:19:31======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'samyang0028' 0 = samyang0028 Mid = samyang0028 1 = 주식회사 삼양상사 노형지점 Mcompany = 주식회사 삼양상사 노형지점 2 = 214-85-58506 companyNum = 214-85-58506 3 = 064-755-0028 Mtel1 = 064-755-0028 4 = Mhp = ========================2024-08-06 16:19:31======================== select * from customers where id = 'samyang0028' ========================2024-08-06 16:19:31======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('samyang0028','2024-08-06 16:19:31','52500','55000','온라인','0')