========================2025-02-10 07:51:09======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-harry-1739141418 LGD_BUYER = 최규윤 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250210075018 LGD_HASHDATA = 2726468fc404d2ec50d267a1111a017b 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 = 2025021007524597E3D0081C30ADF7B357EE2768CB40EB225964DF Mname = 최규윤 Mcompany = (주)한국종합물류 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = harry LGD_ESCROW_USEYN = N ========================2025-02-10 07:51:10======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250210075246 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 328193 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 65413255****080* LGD_FINANCEAUTHNUM = 48610351 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31500 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1fb3aa75973e39fee35f848f0a24b061 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨DINERS LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250210075246 LGD_PCANCELSTR = 0 LGD_BUYER = 최규윤 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250210075246M3Jw4 LGD_BUYERID = LGD_OID = Direct-harry-1739141418 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0075246Mecz5 ========================2025-02-10 07:51:10======================== insert into mBoard_order set rOrdNo = 'Direct-harry-1739141418', AuthTy = 'card', memberId = 'harry', OrdNm ='최규윤', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)한국종합물류', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨DINERS 65413255****080*', rApprNo = 'mjsof20250210075246M3Jw4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-10 07:51:10', InvoiceNum = '결제성공:Direct-harry-1739141418/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-10 07:51:10' ========================2025-02-10 07:51:10======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250210075246M3Jw4' 0 = 1 cnt = 1 ========================2025-02-10 07:51:10======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'harry' 0 = harry Mid = harry 1 = (주)한국종합물류 Mcompany = (주)한국종합물류 2 = 5448801472 companyNum = 5448801472 3 = 010-4331-0111 Mtel1 = 010-4331-0111 4 = 010-4331-0111 Mhp = 010-4331-0111 ========================2025-02-10 07:51:10======================== select * from customers where id = 'harry' ========================2025-02-10 07:51:10======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('harry','2025-02-10 07:51:10','220000','220000','온라인','0') ========================2025-02-10 08:35:08======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1739144063 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250210083423 LGD_HASHDATA = 0d77d7b035c34a1c6a92a512a5586b29 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 = 2025021008364417686A2C3829BA453428A92A8EE22520241C57BE Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2025-02-10 08:35:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250210083645 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94301703****448* LGD_FINANCEAUTHNUM = 70629712 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 02534899b8993aabcf7e8a6b6f235dfe LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20250210083645 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250210083645M9RR5 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1739144063 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-02-10 08:35:09======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1739144063', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 94301703****448*', rApprNo = 'mjsof20250210083645M9RR5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-10 08:35:09', InvoiceNum = '결제성공:Direct-goodssal5707-1739144063/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-10 08:35:09' ========================2025-02-10 08:35:09======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250210083645M9RR5' 0 = 1 cnt = 1 ========================2025-02-10 08:35:09======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2025-02-10 08:35:09======================== select * from customers where id = 'goodssal5707' ========================2025-02-10 08:35:09======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2025-02-10 08:35:09','220000','220000','온라인','0') ========================2025-02-10 12:29:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mail2020-1739157984 LGD_BUYER = 임요한 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250210122624 LGD_HASHDATA = 44d0dae21ff45a21b608c8af8139e8d7 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 = 20250210123055182D82402C6C19EF412369AB4781356C4400F6F1 Mname = 임요한 Mcompany = 매일우유천전점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = mail2020 LGD_ESCROW_USEYN = N ========================2025-02-10 12:29:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250210123055 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 51818500****839* LGD_FINANCEAUTHNUM = 26302802 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 21200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e3bff66a79bbf6d2551e6d47cf3954c3 LGD_BUYERADDRESS = LGD_FINANCENAME = 하나MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20250210123056 LGD_PCANCELSTR = 0 LGD_BUYER = 임요한 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250210123055QJvn5 LGD_BUYERID = LGD_OID = Direct-mail2020-1739157984 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-02-10 12:29:20======================== insert into mBoard_order set rOrdNo = 'Direct-mail2020-1739157984', AuthTy = 'card', memberId = 'mail2020', OrdNm ='임요한', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '매일우유천전점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '하나MASTER 51818500****839*', rApprNo = 'mjsof20250210123055QJvn5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-10 12:29:20', InvoiceNum = '결제성공:Direct-mail2020-1739157984/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-10 12:29:20' ========================2025-02-10 12:29:20======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250210123055QJvn5' 0 = 1 cnt = 1 ========================2025-02-10 12:29:20======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mail2020' 0 = mail2020 Mid = mail2020 1 = 매일우유천전점 Mcompany = 매일우유천전점 2 = 2174400621 companyNum = 2174400621 3 = 010-9198-1005 Mtel1 = 010-9198-1005 4 = 010-5330-1535 Mhp = 010-5330-1535 ========================2025-02-10 12:29:20======================== select * from customers where id = 'mail2020' ========================2025-02-10 12:29:20======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mail2020','2025-02-10 12:29:20','10000','11000','온라인','0') ========================2025-02-10 14:06:57======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-phceramic-1739163957 LGD_BUYER = 박세환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250210140557 LGD_HASHDATA = b27572a628d8d36d4ddc605acc0aec7d 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 = 2025021014083337639DFFCE1DC0FF77C0FB1B87AB51A669FEE378 Mname = 박세환 Mcompany = (주) 가우디 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = phceramic LGD_ESCROW_USEYN = N ========================2025-02-10 14:06:58======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250210140834 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 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 = 94364610****004* LGD_FINANCEAUTHNUM = 30016368 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 11000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = fd875a816d7003338191e2484483d126 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20250210140834 LGD_PCANCELSTR = 0 LGD_BUYER = 박세환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250210140834TOBb5 LGD_BUYERID = LGD_OID = Direct-phceramic-1739163957 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-02-10 14:06:58======================== insert into mBoard_order set rOrdNo = 'Direct-phceramic-1739163957', AuthTy = 'card', memberId = 'phceramic', OrdNm ='박세환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주) 가우디', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '국민 94364610****004*', rApprNo = 'mjsof20250210140834TOBb5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-10 14:06:58', InvoiceNum = '결제성공:Direct-phceramic-1739163957/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-10 14:06:58' ========================2025-02-10 14:06:58======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250210140834TOBb5' 0 = 1 cnt = 1 ========================2025-02-10 14:06:58======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'phceramic' 0 = phceramic Mid = phceramic 1 = (주) 가우디 Mcompany = (주) 가우디 2 = 1418601018 companyNum = 1418601018 3 = 010-8989-5709 Mtel1 = 010-8989-5709 4 = 010-8989-5709 Mhp = 010-8989-5709 ========================2025-02-10 14:06:58======================== select * from customers where id = 'phceramic' ========================2025-02-10 14:06:58======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('phceramic','2025-02-10 14:06:58','30900','33000','온라인','0') ========================2025-02-10 16:21:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-samyung-1739172034 LGD_BUYER = 삼영푸드 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250210162034 LGD_HASHDATA = 66fb3dcb6aec31c10e590c0dc76a48aa 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 = 20250210162332037059DCF24B7EA14F6384C5261C86DC125BF097 Mname = 삼영푸드 Mcompany = 삼영푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = samyung LGD_ESCROW_USEYN = N ========================2025-02-10 16:21:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250210162333 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = DAA6B6 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45184445****087* LGD_FINANCEAUTHNUM = 05702135 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fd57f0bc4a84333f8b8109b73fd52af5 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20250210162333 LGD_PCANCELSTR = 0 LGD_BUYER = 삼영푸드 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250210162333PqR11 LGD_BUYERID = LGD_OID = Direct-samyung-1739172034 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-02-10 16:21:57======================== insert into mBoard_order set rOrdNo = 'Direct-samyung-1739172034', AuthTy = 'card', memberId = 'samyung', OrdNm ='삼영푸드', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '삼영푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한VISA 45184445****087*', rApprNo = 'mjsof20250210162333PqR11', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-10 16:21:57', InvoiceNum = '결제성공:Direct-samyung-1739172034/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-10 16:21:57' ========================2025-02-10 16:21:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250210162333PqR11' 0 = 1 cnt = 1 ========================2025-02-10 16:21:57======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'samyung' 0 = samyung Mid = samyung 1 = 삼영푸드 Mcompany = 삼영푸드 2 = 6788100137 companyNum = 6788100137 3 = 010-6522-8197 Mtel1 = 010-6522-8197 4 = 010-6522-8197 Mhp = 010-6522-8197 ========================2025-02-10 16:21:57======================== select * from customers where id = 'samyung' ========================2025-02-10 16:21:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('samyung','2025-02-10 16:21:57','52500','55000','온라인','0') ========================2025-02-10 19:14:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hama5354-1739182282 LGD_BUYER = 정은영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250210191122 LGD_HASHDATA = ad61243f3320c0e71fd4a75334e5b45f 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 = 2025021019155086B53720F8ACBB0DE143E04A1053E0EE3367D3E2 Mname = 정은영 Mcompany = 주식회사 하마 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = hama5354 LGD_ESCROW_USEYN = N ========================2025-02-10 19:14:14======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_POINT LGD_BUYERPHONE = LGD_PAYDATE = 20250210191551 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = receiptSelf = N LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 075 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = f3b356197c525a19986b14dadd22f91f LGD_BUYERADDRESS = receiptKind = LGD_FINANCENAME = 네이버페이 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = LGD_DEVICE = LGD_TIMESTAMP = 20250210191551 LGD_PCANCELSTR = 0 LGD_BUYER = 정은영 LGD_CARDINSTALLMONTH = LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 11000 LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof20250210191531RO260 LGD_BUYERID = LGD_OID = Direct-hama5354-1739182282 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-02-10 19:14:14======================== insert into mBoard_order set rOrdNo = 'Direct-hama5354-1739182282', AuthTy = 'card', memberId = 'hama5354', OrdNm ='정은영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 하마', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '네이버페이 ', rApprNo = 'mjsof20250210191531RO260', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-10 19:14:14', InvoiceNum = '결제성공:Direct-hama5354-1739182282/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-10 19:14:14' ========================2025-02-10 19:14:14======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250210191531RO260' 0 = 1 cnt = 1 ========================2025-02-10 19:14:14======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hama5354' 0 = hama5354 Mid = hama5354 1 = 주식회사 하마 Mcompany = 주식회사 하마 2 = 572-88-02933 companyNum = 572-88-02933 3 = 010-7504-5354 Mtel1 = 010-7504-5354 4 = Mhp = ========================2025-02-10 19:14:14======================== select * from customers where id = 'hama5354' ========================2025-02-10 19:14:14======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hama5354','2025-02-10 19:14:14','10000','11000','온라인','0') ========================2025-02-10 20:23:39======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-taynys-1739186516 LGD_BUYER = 성재현 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250210202156 LGD_HASHDATA = a72c2bd9651fe0dfcd4976a859970e52 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 = 20250210202515F268F9B1E05DAD9181E1BE6B86349E8DFEE007DE Mname = 성재현 Mcompany = 오케이푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = taynys LGD_ESCROW_USEYN = N ========================2025-02-10 20:23:39======================== xpay_res LGD_CASTAMOUNT = 0 LGD_BUYERPHONE = 01086382955 LGD_PAYDATE = 20250210202516 LGD_BUYEREMAIL = taynys@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0040 LGD_ACCOUNTNUM = 79019641182818 LGD_CASSEQNO = 000 LGD_RECEIVERPHONE = LGD_IFOS = 406C0C LGD_CASHRECEIPTKIND = 1 LGD_RESPMSG = 11: LGD_2TR_FLAG = Y LGD_PAYER = 성병학(오케이푸드) LGD_CASFLAG = R LGD_ESCROWYN = N LGD_FINANCECODE = 011 LGD_CASHRECEIPTCODE = 0000 LGD_HASHDATA = a07e621464e6cb99faaeb3bc58c7559f LGD_BUYERADDRESS = LGD_FINANCENAME = 농협 LGD_ACCOUNT_TYPE = 0 LGD_DEVICE = LGD_TIMESTAMP = 20250210202516 LGD_BUYER = 성재현 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = . LGD_PRODUCTCODE = LGD_TID = mjsof20250210202515RtKK4 LGD_BUYERID = LGD_OID = Direct-taynys-1739186516 LGD_RESPCODE = 0000 LGD_CASCAMOUNT = 0 LGD_AMOUNT = 220000 LGD_SAOWNER = 엠제이소프트 LGD_MID = mjsoft007 ========================2025-02-10 21:05:38======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-taynys-1739189045 LGD_BUYER = 성재현 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250210210405 LGD_HASHDATA = 36962a7fcba3128c9e4118ebe36d9ea8 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 = 20250210210715A240CC5A7F93ECE36455F7D1EFC65F4C37914486 Mname = 성재현 Mcompany = 오케이푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = taynys LGD_ESCROW_USEYN = N ========================2025-02-10 21:05:39======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250210210715 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = taynys@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 51883100****695* LGD_FINANCEAUTHNUM = 44538504 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c4b2eef529a59638a41768448ba192bc LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20250210210716 LGD_PCANCELSTR = 0 LGD_BUYER = 성재현 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250210210715UQx59 LGD_BUYERID = LGD_OID = Direct-taynys-1739189045 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-02-10 21:05:39======================== insert into mBoard_order set rOrdNo = 'Direct-taynys-1739189045', AuthTy = 'card', memberId = 'taynys', OrdNm ='성재현', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '오케이푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '삼성MASTER 51883100****695*', rApprNo = 'mjsof20250210210715UQx59', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-10 21:05:39', InvoiceNum = '결제성공:Direct-taynys-1739189045/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-10 21:05:39' ========================2025-02-10 21:05:39======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250210210715UQx59' 0 = 1 cnt = 1 ========================2025-02-10 21:05:39======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'taynys' 0 = taynys Mid = taynys 1 = 오케이푸드 Mcompany = 오케이푸드 2 = 3934400357 companyNum = 3934400357 3 = 054-821-4148 Mtel1 = 054-821-4148 4 = 010-8638-2955 Mhp = 010-8638-2955 ========================2025-02-10 21:05:39======================== select * from customers where id = 'taynys' ========================2025-02-10 21:05:39======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('taynys','2025-02-10 21:05:39','30900','33000','온라인','0')