========================2024-09-04 01:34:23======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sd105908-1725381181 LGD_BUYER = 김진이 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240904013301 LGD_HASHDATA = a4020d79daea499ec0885884ab8f0a3d 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 = 202409040136476B7B44363EF1A7C3F96A46ABF6F01CAC851D29CD Mname = 김진이 Mcompany = (주)뉴숄더 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = sd105908 LGD_ESCROW_USEYN = N ========================2024-09-04 01:34:24======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240904013648 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = nshoulder@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 000000 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****161* LGD_FINANCEAUTHNUM = 30142113 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 13c72186e962816b10e44762e3d89784 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240904013648 LGD_PCANCELSTR = 0 LGD_BUYER = 김진이 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240904013647Vcen9 LGD_BUYERID = LGD_OID = Direct-sd105908-1725381181 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4013647VJfg6 ========================2024-09-04 01:34:24======================== insert into mBoard_order set rOrdNo = 'Direct-sd105908-1725381181', AuthTy = 'card', memberId = 'sd105908', OrdNm ='김진이', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)뉴숄더', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****161*', rApprNo = 'mjsof20240904013647Vcen9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-04 01:34:24', InvoiceNum = '결제성공:Direct-sd105908-1725381181/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-04 01:34:24' ========================2024-09-04 01:34:24======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240904013647Vcen9' 0 = 1 cnt = 1 ========================2024-09-04 01:34:24======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sd105908' 0 = sd105908 Mid = sd105908 1 = (주)뉴숄더 Mcompany = (주)뉴숄더 2 = 215-81-94133 companyNum = 215-81-94133 3 = 031-551-8533 Mtel1 = 031-551-8533 4 = 010-3745-5183 Mhp = 010-3745-5183 ========================2024-09-04 01:34:24======================== select * from customers where id = 'sd105908' ========================2024-09-04 01:34:24======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sd105908','2024-09-04 01:34:24','52500','55000','온라인','0') ========================2024-09-04 10:02:34======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kukje9156-1725411698 LGD_BUYER = 조윤영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240904100138 LGD_HASHDATA = e14588512866cd95f4d64bb5f5179ef7 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 = 2024090410045904C7BFD3C2BD7F73F29BE1528B3B7250E475838C Mname = 조윤영 Mcompany = 주식회사 국제안전 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = kukje9156 LGD_ESCROW_USEYN = N ========================2024-09-04 10:02:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240904100459 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 = 55852694****081* LGD_FINANCEAUTHNUM = 30029130 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 62af17a38949b7330dfe05c4140f58a3 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240904100500 LGD_PCANCELSTR = 0 LGD_BUYER = 조윤영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202409041004599vpx7 LGD_BUYERID = LGD_OID = Direct-kukje9156-1725411698 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 41004599npa2 ========================2024-09-04 10:02:35======================== insert into mBoard_order set rOrdNo = 'Direct-kukje9156-1725411698', AuthTy = 'card', memberId = 'kukje9156', OrdNm ='조윤영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 국제안전', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****081*', rApprNo = 'mjsof202409041004599vpx7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-04 10:02:35', InvoiceNum = '결제성공:Direct-kukje9156-1725411698/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-04 10:02:35' ========================2024-09-04 10:02:35======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202409041004599vpx7' 0 = 1 cnt = 1 ========================2024-09-04 10:02:35======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kukje9156' 0 = kukje9156 Mid = kukje9156 1 = 주식회사 국제안전 Mcompany = 주식회사 국제안전 2 = 2068666910 companyNum = 2068666910 3 = 02-469-9156 Mtel1 = 02-469-9156 4 = 010-2013-7302 Mhp = 010-2013-7302 ========================2024-09-04 10:02:35======================== select * from customers where id = 'kukje9156' ========================2024-09-04 10:02:35======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kukje9156','2024-09-04 10:02:35','108000','110000','온라인','0') ========================2024-09-04 10:54:41======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kds1-1725414821 LGD_BUYER = 오정호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240904105341 LGD_HASHDATA = 39a20ae129de3754064a6a4eef58317f 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 = 2024090410570562517F302BAD8ECDE102A9D7E2268395FEA2050B Mname = 오정호 Mcompany = 메인로드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kds1 LGD_ESCROW_USEYN = N ========================2024-09-04 10:54:42======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240904105706 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003300 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****589* LGD_FINANCEAUTHNUM = 30189827 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6174f09cb23a0a00f694aa481c746ddb LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240904105706 LGD_PCANCELSTR = 0 LGD_BUYER = 오정호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240904105706YPCV7 LGD_BUYERID = LGD_OID = Direct-kds1-1725414821 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4105706YFLb9 ========================2024-09-04 10:54:42======================== insert into mBoard_order set rOrdNo = 'Direct-kds1-1725414821', AuthTy = 'card', memberId = 'kds1', OrdNm ='오정호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '메인로드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****589*', rApprNo = 'mjsof20240904105706YPCV7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-04 10:54:42', InvoiceNum = '결제성공:Direct-kds1-1725414821/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-04 10:54:42' ========================2024-09-04 10:54:42======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240904105706YPCV7' 0 = 1 cnt = 1 ========================2024-09-04 10:54:42======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kds1' 0 = kds1 Mid = kds1 1 = 메인로드 Mcompany = 메인로드 2 = 1180300092 companyNum = 1180300092 3 = 031-267-3340 Mtel1 = 031-267-3340 4 = 010-8680-1206 Mhp = 010-8680-1206 ========================2024-09-04 10:54:42======================== select * from customers where id = 'kds1' ========================2024-09-04 10:54:42======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kds1','2024-09-04 10:54:42','52500','55000','온라인','0') ========================2024-09-04 12:36:16======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-cp2201-1725420572 LGD_BUYER = 주훈석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240904122932 LGD_HASHDATA = 559824b1bfc474f217d00f1be00e4350 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 = 2024090412384090E8E4DEB7B719DBE700D5275043DCC915986BD9 Mname = 주훈석 Mcompany = 주식회사 지얼 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = cp2201 LGD_ESCROW_USEYN = N ========================2024-09-04 12:36:17======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240904123841 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 = 42890993****834* LGD_FINANCEAUTHNUM = 27170703 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 21100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 37234a419b45dcc878e854c9db3d2616 LGD_BUYERADDRESS = LGD_FINANCENAME = 하나VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20240904123842 LGD_PCANCELSTR = 0 LGD_BUYER = 주훈석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2024090412384109AG0 LGD_BUYERID = LGD_OID = Direct-cp2201-1725420572 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-09-04 12:36:17======================== insert into mBoard_order set rOrdNo = 'Direct-cp2201-1725420572', AuthTy = 'card', memberId = 'cp2201', OrdNm ='주훈석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 지얼', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '하나VISA 42890993****834*', rApprNo = 'mjsof2024090412384109AG0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-04 12:36:17', InvoiceNum = '결제성공:Direct-cp2201-1725420572/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-04 12:36:17' ========================2024-09-04 12:36:17======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2024090412384109AG0' 0 = 1 cnt = 1 ========================2024-09-04 12:36:17======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'cp2201' 0 = cp2201 Mid = cp2201 1 = 주식회사 지얼 Mcompany = 주식회사 지얼 2 = 583-86-00135 companyNum = 583-86-00135 3 = 051-503-3010 Mtel1 = 051-503-3010 4 = 010-6482-3010 Mhp = 010-6482-3010 ========================2024-09-04 12:36:17======================== select * from customers where id = 'cp2201' ========================2024-09-04 12:36:17======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('cp2201','2024-09-04 12:36:17','220000','220000','온라인','0') ========================2024-09-04 13:17:57======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sltfood-1725423028 LGD_BUYER = 최성수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240904131028 LGD_HASHDATA = 44c808093e2ea8718804538a774c3c88 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 = 20240904132022BB311248F0B10AA0219A5A71C23DB23A0B3EF49F Mname = 최성수 Mcompany = (주)셀랙푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = sltfood LGD_ESCROW_USEYN = N ========================2024-09-04 13:17:58======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240904132022 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = selectfood@selectfood.co.kr 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 = 51055400****783* LGD_FINANCEAUTHNUM = 69766077 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 71200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b3a49d628cdcf64122c9812871ea5cb0 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20240904132023 LGD_PCANCELSTR = 0 LGD_BUYER = 최성수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240904132022XnJ02 LGD_BUYERID = LGD_OID = Direct-sltfood-1725423028 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-09-04 13:17:58======================== insert into mBoard_order set rOrdNo = 'Direct-sltfood-1725423028', AuthTy = 'card', memberId = 'sltfood', OrdNm ='최성수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)셀랙푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '롯데MASTER 51055400****783*', rApprNo = 'mjsof20240904132022XnJ02', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-04 13:17:58', InvoiceNum = '결제성공:Direct-sltfood-1725423028/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-04 13:17:58' ========================2024-09-04 13:17:58======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240904132022XnJ02' 0 = 1 cnt = 1 ========================2024-09-04 13:17:58======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sltfood' 0 = sltfood Mid = sltfood 1 = (주)셀랙푸드 Mcompany = (주)셀랙푸드 2 = 4018800346 companyNum = 4018800346 3 = 070-8878-8572 Mtel1 = 070-8878-8572 4 = 010-9054-8572 Mhp = 010-9054-8572 ========================2024-09-04 13:17:58======================== select * from customers where id = 'sltfood' ========================2024-09-04 13:17:58======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sltfood','2024-09-04 13:17:58','220000','220000','온라인','0') ========================2024-09-04 14:14:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mail2020-1725426646 LGD_BUYER = 임요한 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240904141046 LGD_HASHDATA = 8d9c7ab60dc2445c796ff715eab3a33a 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 = 20240904141644F0EC7FDBDCA43C352F6E138C2F6D169E1065E7EC 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 ========================2024-09-04 14:14:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240904141644 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 = 21004011 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 21200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7d0eb47b2d819b359512cd2477398f55 LGD_BUYERADDRESS = LGD_FINANCENAME = 하나MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20240904141645 LGD_PCANCELSTR = 0 LGD_BUYER = 임요한 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240904141644Xwti4 LGD_BUYERID = LGD_OID = Direct-mail2020-1725426646 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-09-04 14:14:20======================== insert into mBoard_order set rOrdNo = 'Direct-mail2020-1725426646', 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 = 'mjsof20240904141644Xwti4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-04 14:14:20', InvoiceNum = '결제성공:Direct-mail2020-1725426646/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-04 14:14:20' ========================2024-09-04 14:14:20======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240904141644Xwti4' 0 = 1 cnt = 1 ========================2024-09-04 14:14: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 ========================2024-09-04 14:14:20======================== select * from customers where id = 'mail2020' ========================2024-09-04 14:14:20======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mail2020','2024-09-04 14:14:20','10000','11000','온라인','0') ========================2024-09-04 14:43:33======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bosungsf8727-1725428473 LGD_BUYER = 김태화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240904144113 LGD_HASHDATA = 963882ae64e86b1e43a9b3e1cb16af38 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 = 20240904144558D58EF4D4F1287D3752138B2F33E5C37DC61F648B Mname = 김태화 Mcompany = (주)보성씨푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = bosungsf8727 LGD_ESCROW_USEYN = N ========================2024-09-04 14:43:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240904144559 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62641517****399* LGD_FINANCEAUTHNUM = 40563933 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9dea959e79001c242a6f90f19c6b1a0c LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240904144559 LGD_PCANCELSTR = 0 LGD_BUYER = 김태화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240904144559fKlX5 LGD_BUYERID = LGD_OID = Direct-bosungsf8727-1725428473 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4144559fyf73 ========================2024-09-04 14:43:35======================== insert into mBoard_order set rOrdNo = 'Direct-bosungsf8727-1725428473', AuthTy = 'card', memberId = 'bosungsf8727', OrdNm ='김태화 ', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)보성씨푸드 ', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨CUP 62641517****399*', rApprNo = 'mjsof20240904144559fKlX5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-04 14:43:35', InvoiceNum = '결제성공:Direct-bosungsf8727-1725428473/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-04 14:43:35' ========================2024-09-04 14:43:35======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240904144559fKlX5' 0 = 1 cnt = 1 ========================2024-09-04 14:43:35======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bosungsf8727' 0 = bosungsf8727 Mid = bosungsf8727 1 = (주)보성씨푸드 Mcompany = (주)보성씨푸드 2 = 1088126792 companyNum = 1088126792 3 = 031-481-8727 Mtel1 = 031-481-8727 4 = 010-8638-0714 Mhp = 010-8638-0714 ========================2024-09-04 14:43:35======================== select * from customers where id = 'bosungsf8727' ========================2024-09-04 14:43:35======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bosungsf8727','2024-09-04 14:43:35','220000','220000','온라인','0') ========================2024-09-04 15:03:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-youngor0505-1725429749 LGD_BUYER = 안영오 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240904150229 LGD_HASHDATA = 2bf6b561250b37fc9f3c3d3000024a10 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 = 202409041506211E316E9E438F45EF32F55DB2A1269DF243D50AAB Mname = 안영오 Mcompany = 첨단유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = youngor0505 LGD_ESCROW_USEYN = N ========================2024-09-04 15:03:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240904150621 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 = 40091119****961* LGD_FINANCEAUTHNUM = 41397479 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 51100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ec90efb234b3138739b350385fb8fa7d LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20240904150621 LGD_PCANCELSTR = 0 LGD_BUYER = 안영오 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202409041506219Sm66 LGD_BUYERID = LGD_OID = Direct-youngor0505-1725429749 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-09-04 15:03:57======================== insert into mBoard_order set rOrdNo = 'Direct-youngor0505-1725429749', AuthTy = 'card', memberId = 'youngor0505', OrdNm ='안영오', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '첨단유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '삼성VISA 40091119****961*', rApprNo = 'mjsof202409041506219Sm66', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-04 15:03:57', InvoiceNum = '결제성공:Direct-youngor0505-1725429749/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-04 15:03:57' ========================2024-09-04 15:03:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202409041506219Sm66' 0 = 1 cnt = 1 ========================2024-09-04 15:03:57======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'youngor0505' 0 = youngor0505 Mid = youngor0505 1 = 첨단유통 Mcompany = 첨단유통 2 = 2044065504 companyNum = 2044065504 3 = 010-5601-8411 Mtel1 = 010-5601-8411 4 = 010-5602-8411 Mhp = 010-5602-8411 ========================2024-09-04 15:03:57======================== select * from customers where id = 'youngor0505' ========================2024-09-04 15:03:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('youngor0505','2024-09-04 15:03:57','10000','11000','온라인','0') ========================2024-09-04 15:48:06======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-leejh771-1725432303 LGD_BUYER = 이정형 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240904154503 LGD_HASHDATA = 9ff1c50e8b55f9451b6413cc99c3f897 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 = 202409041550319BD7EF2D118B232FB0D2EC18759106883D79782E Mname = 이정형 Mcompany = 다랑수산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = leejh771 LGD_ESCROW_USEYN = N ========================2024-09-04 15:48:08======================== xpay_res LGD_EASYPAY_TRANTYPE = KAKAOPAY LGD_BUYERPHONE = LGD_PAYDATE = 20240904155032 LGD_BUYEREMAIL = leejh771@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 = LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 098 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = b7a44521fe24704be7da879bf76f4c41 LGD_BUYERADDRESS = LGD_FINANCENAME = 카카오페이 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = LGD_DEVICE = LGD_TIMESTAMP = 20240904155032 LGD_PCANCELSTR = 0 LGD_BUYER = 이정형 LGD_CARDINSTALLMONTH = LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof20240904154925pSIy0 LGD_BUYERID = LGD_OID = Direct-leejh771-1725432303 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-09-04 15:48:08======================== insert into mBoard_order set rOrdNo = 'Direct-leejh771-1725432303', AuthTy = 'card', memberId = 'leejh771', OrdNm ='이정형', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '다랑수산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '카카오페이 ', rApprNo = 'mjsof20240904154925pSIy0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-04 15:48:08', InvoiceNum = '결제성공:Direct-leejh771-1725432303/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-04 15:48:08' ========================2024-09-04 15:48:08======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240904154925pSIy0' 0 = 1 cnt = 1 ========================2024-09-04 15:48:08======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'leejh771' 0 = leejh771 Mid = leejh771 1 = 다랑수산 Mcompany = 다랑수산 2 = 129-90-39049 companyNum = 129-90-39049 3 = 010-3771-3471 Mtel1 = 010-3771-3471 4 = 010-3771-3471 Mhp = 010-3771-3471 ========================2024-09-04 15:48:08======================== select * from customers where id = 'leejh771' ========================2024-09-04 15:48:08======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('leejh771','2024-09-04 15:48:08','52500','55000','온라인','0') ========================2024-09-04 16:25:50======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-alldayfood-1725434696 LGD_BUYER = 박강철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240904162456 LGD_HASHDATA = f3740696f6b541dfa673ec4c3cc16528 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 = 202409041628157131C00DBDBEA3B3E7D0362B057B972310AD3A6B Mname = 박강철 Mcompany = 올데이푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = alldayfood LGD_ESCROW_USEYN = N ========================2024-09-04 16:25:52======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240904162816 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 756448 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 91000300****030* LGD_FINANCEAUTHNUM = 41258087 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 295431239b36b4d5db6bf4273c16d776 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240904162817 LGD_PCANCELSTR = 0 LGD_BUYER = 박강철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240904162816f0a44 LGD_BUYERID = LGD_OID = Direct-alldayfood-1725434696 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4162816fCyK6 ========================2024-09-04 16:25:52======================== insert into mBoard_order set rOrdNo = 'Direct-alldayfood-1725434696', AuthTy = 'card', memberId = 'alldayfood', OrdNm ='박강철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '올데이푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 91000300****030*', rApprNo = 'mjsof20240904162816f0a44', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-04 16:25:52', InvoiceNum = '결제성공:Direct-alldayfood-1725434696/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-04 16:25:52' ========================2024-09-04 16:25:52======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240904162816f0a44' 0 = 1 cnt = 1 ========================2024-09-04 16:25:52======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'alldayfood' 0 = alldayfood Mid = alldayfood 1 = 올데이푸드 Mcompany = 올데이푸드 2 = 4310201357 companyNum = 4310201357 3 = 010-3414-0228 Mtel1 = 010-3414-0228 4 = 010-7422-3317 Mhp = 010-7422-3317 ========================2024-09-04 16:25:52======================== select * from customers where id = 'alldayfood' ========================2024-09-04 16:25:52======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('alldayfood','2024-09-04 16:25:52','220000','220000','온라인','0') ========================2024-09-04 16:30:24======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-medicore0295-1725434977 LGD_BUYER = 김혜령 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240904162937 LGD_HASHDATA = bc4b85fdaef7f661e6c828406f3318f8 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 = 20240904163249456DB92FD44C622278552E19497E107680C45386 Mname = 김혜령 Mcompany = 메디코어 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = medicore0295 LGD_ESCROW_USEYN = N ========================2024-09-04 16:30:25======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240904163250 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 = 55852694****186* LGD_FINANCEAUTHNUM = 30117640 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 282665cd928ee1ea118e4b439241c931 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240904163250 LGD_PCANCELSTR = 0 LGD_BUYER = 김혜령 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202409041632490vrC6 LGD_BUYERID = LGD_OID = Direct-medicore0295-1725434977 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 41632490z1i0 ========================2024-09-04 16:30:25======================== insert into mBoard_order set rOrdNo = 'Direct-medicore0295-1725434977', AuthTy = 'card', memberId = 'medicore0295', OrdNm ='김혜령', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '메디코어', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****186*', rApprNo = 'mjsof202409041632490vrC6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-04 16:30:25', InvoiceNum = '결제성공:Direct-medicore0295-1725434977/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-04 16:30:25' ========================2024-09-04 16:30:25======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202409041632490vrC6' 0 = 1 cnt = 1 ========================2024-09-04 16:30:25======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'medicore0295' 0 = medicore0295 Mid = medicore0295 1 = 메디코어 Mcompany = 메디코어 2 = 2062929829 companyNum = 2062929829 3 = 070-4388-9973 Mtel1 = 070-4388-9973 4 = -- Mhp = -- ========================2024-09-04 16:30:25======================== select * from customers where id = 'medicore0295' ========================2024-09-04 16:30:25======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('medicore0295','2024-09-04 16:30:25','108000','110000','온라인','0') ========================2024-09-04 17:58:40======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kjs120532-1725440216 LGD_BUYER = 김종석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240904175656 LGD_HASHDATA = f11564419f0e95e05778431fef559e6f 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 = 20240904180105A9B30E26E0748BB8B68995D56F081471747430C9 Mname = 김종석 Mcompany = 서원상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = kjs120532 LGD_ESCROW_USEYN = N ========================2024-09-04 17:58:41======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240904180106 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = seowonkw@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 = 42321000****421* LGD_FINANCEAUTHNUM = 00738355 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f6cde44931cc91e7c49d3dad973ecaba LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20240904180106 LGD_PCANCELSTR = 0 LGD_BUYER = 김종석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240904180106YX7o4 LGD_BUYERID = LGD_OID = Direct-kjs120532-1725440216 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-09-04 17:58:41======================== insert into mBoard_order set rOrdNo = 'Direct-kjs120532-1725440216', AuthTy = 'card', memberId = 'kjs120532', OrdNm ='김종석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '서원상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대VISA 42321000****421*', rApprNo = 'mjsof20240904180106YX7o4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-04 17:58:41', InvoiceNum = '결제성공:Direct-kjs120532-1725440216/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-04 17:58:41' ========================2024-09-04 17:58:41======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240904180106YX7o4' 0 = 1 cnt = 1 ========================2024-09-04 17:58:41======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kjs120532' 0 = kjs120532 Mid = kjs120532 1 = 서원상사 Mcompany = 서원상사 2 = 2210629644 companyNum = 2210629644 3 = 010-8780-3502 Mtel1 = 010-8780-3502 4 = 010-8780-3502 Mhp = 010-8780-3502 ========================2024-09-04 17:58:41======================== select * from customers where id = 'kjs120532' ========================2024-09-04 17:58:41======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kjs120532','2024-09-04 17:58:41','30900','33000','온라인','0')