========================2024-01-02 09:46:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sun55-1704156353 LGD_BUYER = 류나영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240102094553 LGD_HASHDATA = af5c9c0adc8b4be44025329c0dccfd26 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 = 2024010209503186AF21BBC3A6D15622510EDAE18CBE9B9FA3BAA2 Mname = 류나영 Mcompany = 주식회사다인유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = sun55 LGD_ESCROW_USEYN = N ========================2024-01-02 09:46:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240102095032 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 = 41400307****792* LGD_FINANCEAUTHNUM = 43261255 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c131524154cf187f7eec3b90bfd57046 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240102095033 LGD_PCANCELSTR = 0 LGD_BUYER = 류나영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240102095032DrLe6 LGD_BUYERID = LGD_OID = Direct-sun55-1704156353 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 2095032Dp806 ========================2024-01-02 09:46:33======================== insert into mBoard_order set rOrdNo = 'Direct-sun55-1704156353', AuthTy = 'card', memberId = 'sun55', OrdNm ='류나영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사다인유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '비씨VISA 41400307****792*', rApprNo = 'mjsof20240102095032DrLe6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-02 09:46:33', InvoiceNum = '결제성공:Direct-sun55-1704156353/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-02 09:46:33' ========================2024-01-02 09:46:33======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240102095032DrLe6' 0 = 1 cnt = 1 ========================2024-01-02 09:46:33======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sun55' 0 = sun55 Mid = sun55 1 = 주식회사다인유통 Mcompany = 주식회사다인유통 2 = 132-86-29477 companyNum = 132-86-29477 3 = 031-511-9764 Mtel1 = 031-511-9764 4 = 010-9204-0230 Mhp = 010-9204-0230 ========================2024-01-02 09:46:33======================== select * from customers where id = 'sun55' ========================2024-01-02 09:46:33======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sun55','2024-01-02 09:46:33','30900','33000','온라인','0') ========================2024-01-02 10:49:25======================== res_start ========================2024-01-02 10:49:25======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다. Init_TX(LGD_MID)를 해주시기 바랍니다. 또는 mall.conf 에 상점키가 셋팅되어 있지 않습니다. ========================2024-01-02 13:44:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-alldayfood-1704170627 LGD_BUYER = 박강철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240102134347 LGD_HASHDATA = 2c3a1b0774eb990b4d3904dc7ca8b071 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 = 20240102134826B6777EC0C3D20033FAA92BA9F3BC84E687EAF5AC 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-01-02 13:44:28======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240102134827 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****571* LGD_FINANCEAUTHNUM = 45032550 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8bdf3a5b8d9f775a01e011cb7a1fc74a LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240102134827 LGD_PCANCELSTR = 0 LGD_BUYER = 박강철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240102134827wy4y8 LGD_BUYERID = LGD_OID = Direct-alldayfood-1704170627 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 2134827wXtV1 ========================2024-01-02 13:44:28======================== insert into mBoard_order set rOrdNo = 'Direct-alldayfood-1704170627', AuthTy = 'card', memberId = 'alldayfood', OrdNm ='박강철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '올데이푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 91000300****571*', rApprNo = 'mjsof20240102134827wy4y8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-02 13:44:28', InvoiceNum = '결제성공:Direct-alldayfood-1704170627/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-02 13:44:28' ========================2024-01-02 13:44:28======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240102134827wy4y8' 0 = 1 cnt = 1 ========================2024-01-02 13:44:28======================== 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-01-02 13:44:28======================== select * from customers where id = 'alldayfood' ========================2024-01-02 13:44:28======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('alldayfood','2024-01-02 13:44:28','220000','220000','온라인','0') ========================2024-01-02 13:59:08======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-koris-1704171143 LGD_BUYER = 한국코리스(주) LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240102135223 LGD_HASHDATA = bb8051c17c491e46c419f4bf05995c2b 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 = 20240102140308695A507E058FB14F50C92D857DD5A6C2DAFE6B81 Mname = 한국코리스(주) Mcompany = 한국코리스(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = koris LGD_ESCROW_USEYN = N ========================2024-01-02 13:59:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240102140308 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = koreakoris@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 834865 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55892098****270* LGD_FINANCEAUTHNUM = 45677231 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 46e998172379eab8e64c5a7ab0ffdaa8 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240102140309 LGD_PCANCELSTR = 0 LGD_BUYER = 한국코리스(주) LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240102140308EXWe6 LGD_BUYERID = LGD_OID = Direct-koris-1704171143 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 2140308ED6r5 ========================2024-01-02 13:59:09======================== insert into mBoard_order set rOrdNo = 'Direct-koris-1704171143', AuthTy = 'card', memberId = 'koris', OrdNm ='한국코리스(주)', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '한국코리스(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '우리비씨MASTER 55892098****270*', rApprNo = 'mjsof20240102140308EXWe6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-02 13:59:09', InvoiceNum = '결제성공:Direct-koris-1704171143/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-02 13:59:09' ========================2024-01-02 13:59:09======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240102140308EXWe6' 0 = 1 cnt = 1 ========================2024-01-02 13:59:09======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'koris' 0 = koris Mid = koris 1 = 한국코리스(주) Mcompany = 한국코리스(주) 2 = 215-81-61175 companyNum = 215-81-61175 3 = 02-400-1233 Mtel1 = 02-400-1233 4 = 010-3885-2232 Mhp = 010-3885-2232 ========================2024-01-02 13:59:09======================== select * from customers where id = 'koris' ========================2024-01-02 13:59:09======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('koris','2024-01-02 13:59:09','52500','55000','온라인','0') ========================2024-01-02 14:51:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woo1934-1704174487 LGD_BUYER = 정동인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240102144807 LGD_HASHDATA = 836dd736043fbf9906e4105425b534b9 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 = 202401021455017B5301C136E1D3B27B9C746062B160C8112DC756 Mname = 정동인 Mcompany = (주)우진글로벌 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = woo1934 LGD_ESCROW_USEYN = N ========================2024-01-02 14:51:02======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240102145501 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 = 51055400****369* LGD_FINANCEAUTHNUM = 27318217 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 71200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 21f4396c7f0dc403762121fdfa87af96 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20240102145501 LGD_PCANCELSTR = 0 LGD_BUYER = 정동인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240102145501JTlY2 LGD_BUYERID = LGD_OID = Direct-woo1934-1704174487 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-01-02 14:51:02======================== insert into mBoard_order set rOrdNo = 'Direct-woo1934-1704174487', AuthTy = 'card', memberId = 'woo1934', OrdNm ='정동인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)우진글로벌', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '롯데MASTER 51055400****369*', rApprNo = 'mjsof20240102145501JTlY2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-02 14:51:02', InvoiceNum = '결제성공:Direct-woo1934-1704174487/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-02 14:51:02' ========================2024-01-02 14:51:02======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240102145501JTlY2' 0 = 1 cnt = 1 ========================2024-01-02 14:51:02======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woo1934' 0 = woo1934 Mid = woo1934 1 = (주)우진글로벌 Mcompany = (주)우진글로벌 2 = 4038178083 companyNum = 4038178083 3 = 010-8643-1934 Mtel1 = 010-8643-1934 4 = 010-8371-3533 Mhp = 010-8371-3533 ========================2024-01-02 14:51:02======================== select * from customers where id = 'woo1934' ========================2024-01-02 14:51:02======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woo1934','2024-01-02 14:51:02','220000','220000','온라인','0') ========================2024-01-02 16:31:14======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pjw1439-1704180393 LGD_BUYER = 박흥수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240102162633 LGD_HASHDATA = 49e64209e50f4fc856b317e28bdb6560 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 = 2024010216351488DDA77C60B41221AC21DD84195ADCB659E9B713 Mname = 박흥수 Mcompany = (주)모닝에프디 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = pjw1439 LGD_ESCROW_USEYN = N ========================2024-01-02 16:31:16======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240102163515 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 = 55317172****375* LGD_FINANCEAUTHNUM = 49735059 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 91200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 22f04c7862208dd0c2e884b457399a5b LGD_BUYERADDRESS = LGD_FINANCENAME = NH MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240102163515 LGD_PCANCELSTR = 0 LGD_BUYER = 박흥수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240102163515GwyO6 LGD_BUYERID = LGD_OID = Direct-pjw1439-1704180393 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-01-02 16:31:16======================== insert into mBoard_order set rOrdNo = 'Direct-pjw1439-1704180393', AuthTy = 'card', memberId = 'pjw1439', OrdNm ='박흥수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)모닝에프디', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = 'NH MASTER 55317172****375*', rApprNo = 'mjsof20240102163515GwyO6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-02 16:31:16', InvoiceNum = '결제성공:Direct-pjw1439-1704180393/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-02 16:31:16' ========================2024-01-02 16:31:16======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240102163515GwyO6' 0 = 1 cnt = 1 ========================2024-01-02 16:31:16======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'pjw1439' 0 = pjw1439 Mid = pjw1439 1 = (주)모닝에프디 Mcompany = (주)모닝에프디 2 = 4328800262 companyNum = 4328800262 3 = 010-4820-4572 Mtel1 = 010-4820-4572 4 = 010-2545-9942 Mhp = 010-2545-9942 ========================2024-01-02 16:31:16======================== select * from customers where id = 'pjw1439' ========================2024-01-02 16:31:16======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('pjw1439','2024-01-02 16:31:16','52500','55000','온라인','0') ========================2024-01-02 16:59:06======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-landhbio-1704182307 LGD_BUYER = 이승환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240102165827 LGD_HASHDATA = 4a20b259688b670be26574ee8e37cd87 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 = 20240102170306F9C3314A749D5EDC43272C73670055EA6243A667 Mname = 이승환 Mcompany = (주)엘엔에이치바이오 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = landhbio LGD_ESCROW_USEYN = N ========================2024-01-02 16:59:07======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240102170307 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 834865 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55892098****903* LGD_FINANCEAUTHNUM = 47366992 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 26bed01714b97f3d3b41f7d7826a75ba LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240102170307 LGD_PCANCELSTR = 0 LGD_BUYER = 이승환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240102170306GD2J5 LGD_BUYERID = LGD_OID = Direct-landhbio-1704182307 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 2170306GtLo4 ========================2024-01-02 16:59:07======================== insert into mBoard_order set rOrdNo = 'Direct-landhbio-1704182307', AuthTy = 'card', memberId = 'landhbio', OrdNm ='이승환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)엘엔에이치바이오', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '우리비씨MASTER 55892098****903*', rApprNo = 'mjsof20240102170306GD2J5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-02 16:59:07', InvoiceNum = '결제성공:Direct-landhbio-1704182307/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-02 16:59:07' ========================2024-01-02 16:59:07======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240102170306GD2J5' 0 = 1 cnt = 1 ========================2024-01-02 16:59:07======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'landhbio' 0 = landhbio Mid = landhbio 1 = (주)엘엔에이치바이오 Mcompany = (주)엘엔에이치바이오 2 = 1448113110 companyNum = 1448113110 3 = 070-4111-0496 Mtel1 = 070-4111-0496 4 = 010-2703-0694 Mhp = 010-2703-0694 ========================2024-01-02 16:59:07======================== select * from customers where id = 'landhbio' ========================2024-01-02 16:59:07======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('landhbio','2024-01-02 16:59:07','52500','55000','온라인','0') ========================2024-01-02 21:17:53======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-antwin77-1704197747 LGD_BUYER = 김태우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240102211547 LGD_HASHDATA = 8f753c3e8768938e87915b6bef3ded4b 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 = 20240102212153DDC8C72B0380F5F05AA1AAA1FCA6A0F7ABD69C31 Mname = 김태우 Mcompany = 새미래식품 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = antwin77 LGD_ESCROW_USEYN = N ========================2024-01-02 21:17:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240102212153 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 = 40330200****251* LGD_FINANCEAUTHNUM = 00809682 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c357328b330dfa701001595bc45cc41d LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20240102212153 LGD_PCANCELSTR = 0 LGD_BUYER = 김태우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240102212153Jdap7 LGD_BUYERID = LGD_OID = Direct-antwin77-1704197747 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-01-02 21:17:53======================== insert into mBoard_order set rOrdNo = 'Direct-antwin77-1704197747', AuthTy = 'card', memberId = 'antwin77', OrdNm ='김태우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '새미래식품', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '현대VISA 40330200****251*', rApprNo = 'mjsof20240102212153Jdap7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-02 21:17:53', InvoiceNum = '결제성공:Direct-antwin77-1704197747/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-02 21:17:53' ========================2024-01-02 21:17:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240102212153Jdap7' 0 = 1 cnt = 1 ========================2024-01-02 21:17:53======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'antwin77' 0 = antwin77 Mid = antwin77 1 = 새미래식품 Mcompany = 새미래식품 2 = 6212013066 companyNum = 6212013066 3 = 051-515-6374 Mtel1 = 051-515-6374 4 = 010-2823-6378 Mhp = 010-2823-6378 ========================2024-01-02 21:17:53======================== select * from customers where id = 'antwin77' ========================2024-01-02 21:17:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('antwin77','2024-01-02 21:17:53','52500','55000','온라인','0')