========================2023-10-06 04:54:30======================== res_start ========================2023-10-06 04:54:30======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다. Init_TX(LGD_MID)를 해주시기 바랍니다. 또는 mall.conf 에 상점키가 셋팅되어 있지 않습니다. ========================2023-10-06 08:37:48======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-badafarm-1696548984 LGD_BUYER = 장대정 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231006083624 LGD_HASHDATA = c04d26800b9e046f58c74b8bdecbaa3b 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 = 202310060840084C63397450E9611F3D3BA0180E37155792F85FA8 Mname = 장대정 Mcompany = 바다농장 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = badafarm LGD_ESCROW_USEYN = N ========================2023-10-06 08:37:49======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231006084009 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55318103****259* LGD_FINANCEAUTHNUM = 53735325 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 25e8d1e456ee6e9c925c1cfea9467674 LGD_BUYERADDRESS = LGD_FINANCENAME = NH MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20231006084010 LGD_PCANCELSTR = 0 LGD_BUYER = 장대정 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231006084009UVPd3 LGD_BUYERID = LGD_OID = Direct-badafarm-1696548984 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-06 08:37:49======================== insert into mBoard_order set rOrdNo = 'Direct-badafarm-1696548984', AuthTy = 'card', memberId = 'badafarm', OrdNm ='장대정', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '바다농장', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH MASTER 55318103****259*', rApprNo = 'mjsof20231006084009UVPd3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-06 08:37:49', InvoiceNum = '결제성공:Direct-badafarm-1696548984/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-06 08:37:49' ========================2023-10-06 08:37:49======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231006084009UVPd3' 0 = 1 cnt = 1 ========================2023-10-06 08:37:49======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'badafarm' 0 = badafarm Mid = badafarm 1 = 바다농장 Mcompany = 바다농장 2 = 4158148281 companyNum = 4158148281 3 = 061-553-3139 Mtel1 = 061-553-3139 4 = 010-8870-4436 Mhp = 010-8870-4436 ========================2023-10-06 08:37:49======================== select * from customers where id = 'badafarm' ========================2023-10-06 08:37:49======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('badafarm','2023-10-06 08:37:49','220000','220000','온라인','0') ========================2023-10-06 10:16:39======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-azfoods01-1696554968 LGD_BUYER = 박정운 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231006101608 LGD_HASHDATA = 1f2722e877983ced685d7dd93e9667a0 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 = 202310061019003BB63D24A939B71D8C97E474087F9E2E336930E5 Mname = 박정운 Mcompany = (주)에이젯푸즈 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = azfoods01 LGD_ESCROW_USEYN = N ========================2023-10-06 10:16:39======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231006101900 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = azfoods@chol.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852637****282* LGD_FINANCEAUTHNUM = 30020769 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 31babed12669b49b56a0921f83e1a968 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231006101900 LGD_PCANCELSTR = 0 LGD_BUYER = 박정운 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231006101900YerU6 LGD_BUYERID = LGD_OID = Direct-azfoods01-1696554968 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 6101900Y0sf1 ========================2023-10-06 10:16:39======================== insert into mBoard_order set rOrdNo = 'Direct-azfoods01-1696554968', AuthTy = 'card', memberId = 'azfoods01', OrdNm ='박정운', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)에이젯푸즈', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852637****282*', rApprNo = 'mjsof20231006101900YerU6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-06 10:16:39', InvoiceNum = '결제성공:Direct-azfoods01-1696554968/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-06 10:16:39' ========================2023-10-06 10:16:39======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231006101900YerU6' 0 = 1 cnt = 1 ========================2023-10-06 10:16:39======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'azfoods01' 0 = azfoods01 Mid = azfoods01 1 = (주)에이젯푸즈 Mcompany = (주)에이젯푸즈 2 = 4098625143 companyNum = 4098625143 3 = 062-524-0600 Mtel1 = 062-524-0600 4 = 010-7177-8486 Mhp = 010-7177-8486 ========================2023-10-06 10:16:39======================== select * from customers where id = 'azfoods01' ========================2023-10-06 10:16:39======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('azfoods01','2023-10-06 10:16:39','108000','110000','온라인','0') ========================2023-10-06 12:18:59======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-gumjin3-1696562302 LGD_BUYER = 김다영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231006121822 LGD_HASHDATA = 9d47a064de852820b470bedee307c697 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 = 2023100612212099C3B0F8E2BB8C93DB14D5B73479D0EA22942C36 Mname = 김다영 Mcompany = 세영종합상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = gumjin3 LGD_ESCROW_USEYN = N ========================2023-10-06 12:19:00======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231006122121 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ALZCCX LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 43123600****604* LGD_FINANCEAUTHNUM = 21695865 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 0fff10d185cd1ab8819957fc6f0a1f8d LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20231006122121 LGD_PCANCELSTR = 0 LGD_BUYER = 김다영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231006122121MIKH1 LGD_BUYERID = LGD_OID = Direct-gumjin3-1696562302 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-06 12:19:00======================== insert into mBoard_order set rOrdNo = 'Direct-gumjin3-1696562302', AuthTy = 'card', memberId = 'gumjin3', OrdNm ='김다영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '세영종합상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한VISA 43123600****604*', rApprNo = 'mjsof20231006122121MIKH1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-06 12:19:00', InvoiceNum = '결제성공:Direct-gumjin3-1696562302/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-06 12:19:00' ========================2023-10-06 12:19:00======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231006122121MIKH1' 0 = 1 cnt = 1 ========================2023-10-06 12:19:00======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'gumjin3' 0 = gumjin3 Mid = gumjin3 1 = 세영종합상사 Mcompany = 세영종합상사 2 = 1262974765 companyNum = 1262974765 3 = 010-9292-5964 Mtel1 = 010-9292-5964 4 = 010-9292-5964 Mhp = 010-9292-5964 ========================2023-10-06 12:19:00======================== select * from customers where id = 'gumjin3' ========================2023-10-06 12:19:00======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('gumjin3','2023-10-06 12:19:00','108000','110000','온라인','0') ========================2023-10-06 14:13:14======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bizpharma-1696568991 LGD_BUYER = 이진원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231006140951 LGD_HASHDATA = 019c3dcbc3bf9519d78af867419a1c6a 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 = 20231006141535C8F6CCB2BC3F0EBE73963B62335586ABB2185204 Mname = 이진원 Mcompany = (주)비즈파마 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = bizpharma LGD_ESCROW_USEYN = N ========================2023-10-06 14:13:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231006141535 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 37922030****52* LGD_FINANCEAUTHNUM = 25680009 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 71400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ac3700a8e657a994905831a538eaac72 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20231006141536 LGD_PCANCELSTR = 0 LGD_BUYER = 이진원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231006141535Lfg57 LGD_BUYERID = LGD_OID = Direct-bizpharma-1696568991 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-06 14:13:15======================== insert into mBoard_order set rOrdNo = 'Direct-bizpharma-1696568991', AuthTy = 'card', memberId = 'bizpharma', OrdNm ='이진원', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)비즈파마', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '롯데AMEX 37922030****52*', rApprNo = 'mjsof20231006141535Lfg57', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-06 14:13:15', InvoiceNum = '결제성공:Direct-bizpharma-1696568991/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-06 14:13:15' ========================2023-10-06 14:13:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231006141535Lfg57' 0 = 1 cnt = 1 ========================2023-10-06 14:13:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bizpharma' 0 = bizpharma Mid = bizpharma 1 = (주)비즈파마 Mcompany = (주)비즈파마 2 = 214-88-19260 companyNum = 214-88-19260 3 = 010-5326-6120 Mtel1 = 010-5326-6120 4 = 010-5326-6120 Mhp = 010-5326-6120 ========================2023-10-06 14:13:15======================== select * from customers where id = 'bizpharma' ========================2023-10-06 14:13:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bizpharma','2023-10-06 14:13:15','10000','11000','온라인','0') ========================2023-10-06 14:21:08======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-landhbio-1696569618 LGD_BUYER = 이승환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231006142018 LGD_HASHDATA = f528e00d4014e1e8691ff0d8e599afc1 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 = 202310061423295442322F4BE351EDBD5C8F38E3A21B489CAFBC74 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 ========================2023-10-06 14:21:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231006142330 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 834865 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55892098****903* LGD_FINANCEAUTHNUM = 56279546 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 509770a9a42a3339167da354ab0935c6 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231006142330 LGD_PCANCELSTR = 0 LGD_BUYER = 이승환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231006142329Lg264 LGD_BUYERID = LGD_OID = Direct-landhbio-1696569618 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 6142329Lfwv5 ========================2023-10-06 14:21:09======================== insert into mBoard_order set rOrdNo = 'Direct-landhbio-1696569618', 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 = 'mjsof20231006142329Lg264', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-06 14:21:09', InvoiceNum = '결제성공:Direct-landhbio-1696569618/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-06 14:21:09' ========================2023-10-06 14:21:09======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231006142329Lg264' 0 = 1 cnt = 1 ========================2023-10-06 14:21:09======================== 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 ========================2023-10-06 14:21:09======================== select * from customers where id = 'landhbio' ========================2023-10-06 14:21:09======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('landhbio','2023-10-06 14:21:09','52500','55000','온라인','0') ========================2023-10-06 14:32:47======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kog1223-1696570307 LGD_BUYER = 김원귀 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231006143147 LGD_HASHDATA = 9ce0b59f6214df7bb3b542129839a66c 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 = 2023100614350850C670C37EDEBA298BC452DEF6D12268D1392820 Mname = 김원귀 Mcompany = (주)닭사부 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = kog1223 LGD_ESCROW_USEYN = N ========================2023-10-06 14:32:48======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231006143509 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 004686 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658692****784* LGD_FINANCEAUTHNUM = 30017735 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = cc28f80647d09182aabe330fff8e9efa LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231006143509 LGD_PCANCELSTR = 0 LGD_BUYER = 김원귀 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231006143508YDRj1 LGD_BUYERID = LGD_OID = Direct-kog1223-1696570307 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 6143508Y9288 ========================2023-10-06 14:32:48======================== insert into mBoard_order set rOrdNo = 'Direct-kog1223-1696570307', AuthTy = 'card', memberId = 'kog1223', OrdNm ='김원귀', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)닭사부', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민VISA 42658692****784*', rApprNo = 'mjsof20231006143508YDRj1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-06 14:32:48', InvoiceNum = '결제성공:Direct-kog1223-1696570307/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-06 14:32:48' ========================2023-10-06 14:32:48======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231006143508YDRj1' 0 = 1 cnt = 1 ========================2023-10-06 14:32:48======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kog1223' 0 = kog1223 Mid = kog1223 1 = (주)닭사부 Mcompany = (주)닭사부 2 = 6528100417 companyNum = 6528100417 3 = 010-8220-1531 Mtel1 = 010-8220-1531 4 = 010-8220-1531 Mhp = 010-8220-1531 ========================2023-10-06 14:32:48======================== select * from customers where id = 'kog1223' ========================2023-10-06 14:32:48======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kog1223','2023-10-06 14:32:48','220000','220000','온라인','0') ========================2023-10-06 15:13:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-wakeblue1-1696572694 LGD_BUYER = 허린 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231006151134 LGD_HASHDATA = 6b85032a59206e83d8eed31e83ed114f 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 = 20231006151541EF6402B632C8E33CBB5FB69FD1FCF5F1B1913EBB Mname = 허린 Mcompany = 웨이크블루 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = wakeblue1 LGD_ESCROW_USEYN = N ========================2023-10-06 15:13:21======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231006151542 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = BJBBE4 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 46195410****299* LGD_FINANCEAUTHNUM = 24211418 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = c48c0ba80ce5d47feef2c53b4e85874c LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20231006151542 LGD_PCANCELSTR = 0 LGD_BUYER = 허린 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231006151542MZhN7 LGD_BUYERID = LGD_OID = Direct-wakeblue1-1696572694 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-06 15:13:21======================== insert into mBoard_order set rOrdNo = 'Direct-wakeblue1-1696572694', AuthTy = 'card', memberId = 'wakeblue1', OrdNm ='허린', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '웨이크블루', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한VISA 46195410****299*', rApprNo = 'mjsof20231006151542MZhN7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-06 15:13:21', InvoiceNum = '결제성공:Direct-wakeblue1-1696572694/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-06 15:13:21' ========================2023-10-06 15:13:21======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231006151542MZhN7' 0 = 1 cnt = 1 ========================2023-10-06 15:13:21======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'wakeblue1' 0 = wakeblue1 Mid = wakeblue1 1 = 웨이크블루 Mcompany = 웨이크블루 2 = 2262720319 companyNum = 2262720319 3 = 010-9030-6695 Mtel1 = 010-9030-6695 4 = 010-9030-6695 Mhp = 010-9030-6695 ========================2023-10-06 15:13:21======================== select * from customers where id = 'wakeblue1' ========================2023-10-06 15:13:21======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('wakeblue1','2023-10-06 15:13:21','108000','110000','온라인','0') ========================2023-10-06 16:22:23======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dnjsdlf1-1696576883 LGD_BUYER = 조숙형 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231006162123 LGD_HASHDATA = e27a99afd3f7db4fad4c680d5b9a3d0a 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 = 202310061624449015FF19E32958606F7B97CF18C8F7B862DA1125 Mname = 조숙형 Mcompany = (주)원일유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = dnjsdlf1 LGD_ESCROW_USEYN = N ========================2023-10-06 16:22:23======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231006162444 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = dnjsdlfckacl@hanmail.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852697****985* LGD_FINANCEAUTHNUM = 30285910 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6184c89d1219437e28bf183cd18dbfce LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231006162444 LGD_PCANCELSTR = 0 LGD_BUYER = 조숙형 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231006162444Vsu35 LGD_BUYERID = LGD_OID = Direct-dnjsdlf1-1696576883 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 6162444VZHc2 ========================2023-10-06 16:22:23======================== insert into mBoard_order set rOrdNo = 'Direct-dnjsdlf1-1696576883', AuthTy = 'card', memberId = 'dnjsdlf1', OrdNm ='조숙형', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)원일유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 55852697****985*', rApprNo = 'mjsof20231006162444Vsu35', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-06 16:22:23', InvoiceNum = '결제성공:Direct-dnjsdlf1-1696576883/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-06 16:22:23' ========================2023-10-06 16:22:23======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231006162444Vsu35' 0 = 1 cnt = 1 ========================2023-10-06 16:22:23======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dnjsdlf1' 0 = dnjsdlf1 Mid = dnjsdlf1 1 = (주)원일유통 Mcompany = (주)원일유통 2 = 140-81-34073 companyNum = 140-81-34073 3 = 031-439-3731 Mtel1 = 031-439-3731 4 = 010-4151-9749 Mhp = 010-4151-9749 ========================2023-10-06 16:22:23======================== select * from customers where id = 'dnjsdlf1' ========================2023-10-06 16:22:23======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dnjsdlf1','2023-10-06 16:22:23','220000','220000','온라인','0') ========================2023-10-06 20:34:47======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-wellbio-1696591955 LGD_BUYER = 이진원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231006203235 LGD_HASHDATA = c0226c52808eb3b92b8dd5a40ffb516c 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 = 202310062037085D1EF9E1EC21869920739D9B71E8251D02B6FB10 Mname = 이진원 Mcompany = post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = wellbio LGD_ESCROW_USEYN = N ========================2023-10-06 20:34:47======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231006203709 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = jwlee0501@bizpharma.co.kr LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 37922030****52* LGD_FINANCEAUTHNUM = 35606010 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 71400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 0efcdc31c1f4474a51df4e77845a2b99 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20231006203709 LGD_PCANCELSTR = 0 LGD_BUYER = 이진원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231006203709PLQg8 LGD_BUYERID = LGD_OID = Direct-wellbio-1696591955 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-06 20:34:47======================== insert into mBoard_order set rOrdNo = 'Direct-wellbio-1696591955', AuthTy = 'card', memberId = 'wellbio', OrdNm ='이진원', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '롯데AMEX 37922030****52*', rApprNo = 'mjsof20231006203709PLQg8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-06 20:34:47', InvoiceNum = '결제성공:Direct-wellbio-1696591955/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-06 20:34:47' ========================2023-10-06 20:34:48======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231006203709PLQg8' 0 = 1 cnt = 1 ========================2023-10-06 20:34:48======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'wellbio' 0 = wellbio Mid = wellbio 1 = Mcompany = 2 = companyNum = 3 = 010-5326-6120 Mtel1 = 010-5326-6120 4 = Mhp = ========================2023-10-06 20:34:48======================== select * from customers where id = 'wellbio' ========================2023-10-06 20:34:48======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('wellbio','','','010-5326-6120','','2023-10-06 20:34:47','온라인') ========================2023-10-06 20:34:48======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('wellbio','2023-10-06 20:34:47','10000','11000','온라인','0')