========================2024-11-01 08:25:37======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-parkco6338-1730417075 LGD_BUYER = 박재호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241101082435 LGD_HASHDATA = 4a0abfe1971b03051bda07bc66b2caec 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 = 202411010829085FAEAD8F6EFB5C86EEB933B6169AEDF3F16733A5 Mname = 박재호 Mcompany = (주)극광사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = parkco6338 LGD_ESCROW_USEYN = N ========================2024-11-01 08:25:38======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241101082909 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003397 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 52297176****586* LGD_FINANCEAUTHNUM = 30065366 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8fe0aab240b6c83c1b304435d309ca3f LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20241101082909 LGD_PCANCELSTR = 0 LGD_BUYER = 박재호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241101082908Jrl99 LGD_BUYERID = LGD_OID = Direct-parkco6338-1730417075 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1082908JJso0 ========================2024-11-01 08:25:38======================== insert into mBoard_order set rOrdNo = 'Direct-parkco6338-1730417075', AuthTy = 'card', memberId = 'parkco6338', OrdNm ='박재호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)극광사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 52297176****586*', rApprNo = 'mjsof20241101082908Jrl99', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-01 08:25:38', InvoiceNum = '결제성공:Direct-parkco6338-1730417075/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-01 08:25:38' ========================2024-11-01 08:25:38======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241101082908Jrl99' 0 = 1 cnt = 1 ========================2024-11-01 08:25:38======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'parkco6338' 0 = parkco6338 Mid = parkco6338 1 = (주)극광사 Mcompany = (주)극광사 2 = 5068166232 companyNum = 5068166232 3 = 010-8581-1957 Mtel1 = 010-8581-1957 4 = 010-8581-1957 Mhp = 010-8581-1957 ========================2024-11-01 08:25:38======================== select * from customers where id = 'parkco6338' ========================2024-11-01 08:25:38======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('parkco6338','2024-11-01 08:25:38','220000','220000','온라인','0') ========================2024-11-01 09:16:36======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bigbrother-1730420126 LGD_BUYER = 신완철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241101091526 LGD_HASHDATA = c94281e42a16f00c8cd85a247e7ff97a 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 = 202411010920073A3F4565F4BDD3EEDA9C8A63E47A639CED0EC445 Mname = 신완철 Mcompany = (주)빅브라더 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = bigbrother LGD_ESCROW_USEYN = N ========================2024-11-01 09:16:37======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241101092008 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 224776 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55892098****400* LGD_FINANCEAUTHNUM = 55100033 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 71fe68c15256fbc4e69bbdc6f357fd75 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20241101092008 LGD_PCANCELSTR = 0 LGD_BUYER = 신완철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202411010920071PRw2 LGD_BUYERID = LGD_OID = Direct-bigbrother-1730420126 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 10920071z8x9 ========================2024-11-01 09:16:37======================== insert into mBoard_order set rOrdNo = 'Direct-bigbrother-1730420126', AuthTy = 'card', memberId = 'bigbrother', OrdNm ='신완철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)빅브라더', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리비씨MASTER 55892098****400*', rApprNo = 'mjsof202411010920071PRw2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-01 09:16:37', InvoiceNum = '결제성공:Direct-bigbrother-1730420126/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-01 09:16:37' ========================2024-11-01 09:16:38======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202411010920071PRw2' 0 = 1 cnt = 1 ========================2024-11-01 09:16:38======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bigbrother' 0 = bigbrother Mid = bigbrother 1 = (주)빅브라더 Mcompany = (주)빅브라더 2 = 7828800717 companyNum = 7828800717 3 = 010-3414-0228 Mtel1 = 010-3414-0228 4 = 010-7747-5701 Mhp = 010-7747-5701 ========================2024-11-01 09:16:38======================== select * from customers where id = 'bigbrother' ========================2024-11-01 09:16:38======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bigbrother','2024-11-01 09:16:37','220000','220000','온라인','0') ========================2024-11-01 09:42:39======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woo1934-1730421624 LGD_BUYER = 정동인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241101094024 LGD_HASHDATA = 403dff96843b575abc27d3530f7ba11d 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 = 202411010946105074B745E8E7B24729EFB8F4EA04AC14301E1773 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-11-01 09:42:40======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241101094610 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = woojinglobal@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 = 51055400****369* LGD_FINANCEAUTHNUM = 46283397 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 71200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = eb8bf51448dd5bd330dc20a7e5a708bb LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20241101094611 LGD_PCANCELSTR = 0 LGD_BUYER = 정동인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241101094610R50E0 LGD_BUYERID = LGD_OID = Direct-woo1934-1730421624 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-11-01 09:42:40======================== insert into mBoard_order set rOrdNo = 'Direct-woo1934-1730421624', 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 = 'mjsof20241101094610R50E0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-01 09:42:40', InvoiceNum = '결제성공:Direct-woo1934-1730421624/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-01 09:42:40' ========================2024-11-01 09:42:40======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241101094610R50E0' 0 = 1 cnt = 1 ========================2024-11-01 09:42:40======================== 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-11-01 09:42:40======================== select * from customers where id = 'woo1934' ========================2024-11-01 09:42:40======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woo1934','2024-11-01 09:42:40','220000','220000','온라인','0') ========================2024-11-01 10:02:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kyg2031-1730422879 LGD_BUYER = 김용국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241101100119 LGD_HASHDATA = 04c56a6b57b4cfd5dcfc814f04dd6f8f 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 = 202411011005444EE9BFB6E863C48B86D3725FF605CA6656229750 Mname = 김용국 Mcompany = (유)성광물산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kyg2031 LGD_ESCROW_USEYN = N ========================2024-11-01 10:02:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241101100544 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 005759 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55353101****671* LGD_FINANCEAUTHNUM = 22290329 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 35200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = cccc102676970bb98b527b10a6624ad8 LGD_BUYERADDRESS = LGD_FINANCENAME = 전북MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20241101100546 LGD_PCANCELSTR = 0 LGD_BUYER = 김용국 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof20241101100544PG3O4 LGD_BUYERID = LGD_OID = Direct-kyg2031-1730422879 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 011005625590 ========================2024-11-01 10:02:15======================== insert into mBoard_order set rOrdNo = 'Direct-kyg2031-1730422879', AuthTy = 'card', memberId = 'kyg2031', OrdNm ='김용국', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(유)성광물산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '전북MASTER 55353101****671*', rApprNo = 'mjsof20241101100544PG3O4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-01 10:02:15', InvoiceNum = '결제성공:Direct-kyg2031-1730422879/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-01 10:02:15' ========================2024-11-01 10:02:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241101100544PG3O4' 0 = 1 cnt = 1 ========================2024-11-01 10:02:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kyg2031' 0 = kyg2031 Mid = kyg2031 1 = (유)성광물산 Mcompany = (유)성광물산 2 = 4018113328 companyNum = 4018113328 3 = 063-442-0360 Mtel1 = 063-442-0360 4 = 010-6796-1030 Mhp = 010-6796-1030 ========================2024-11-01 10:02:15======================== select * from customers where id = 'kyg2031' ========================2024-11-01 10:02:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kyg2031','2024-11-01 10:02:15','52500','55000','온라인','0') ========================2024-11-01 12:04:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hanmotor-1730430194 LGD_BUYER = 전한별 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241101120314 LGD_HASHDATA = b1499ce058ecadd8bf616f1cae0da05b 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 = 20241101120756F1D52C6CADF55B42E1B4D075D3905B366F2072BC Mname = 전한별 Mcompany = 한명기전 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = hanmotor LGD_ESCROW_USEYN = N ========================2024-11-01 12:04:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241101120756 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 393322 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94303980****558* LGD_FINANCEAUTHNUM = 56234065 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3fceb6595ada26835589b8b906dde3a8 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20241101120757 LGD_PCANCELSTR = 0 LGD_BUYER = 전한별 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241101120756KEkD9 LGD_BUYERID = LGD_OID = Direct-hanmotor-1730430194 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1120756K5mG6 ========================2024-11-01 12:04:26======================== insert into mBoard_order set rOrdNo = 'Direct-hanmotor-1730430194', AuthTy = 'card', memberId = 'hanmotor', OrdNm ='전한별', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '한명기전', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 94303980****558*', rApprNo = 'mjsof20241101120756KEkD9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-01 12:04:26', InvoiceNum = '결제성공:Direct-hanmotor-1730430194/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-01 12:04:26' ========================2024-11-01 12:04:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241101120756KEkD9' 0 = 1 cnt = 1 ========================2024-11-01 12:04:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hanmotor' 0 = hanmotor Mid = hanmotor 1 = 한명기전 Mcompany = 한명기전 2 = 608-16-87404 companyNum = 608-16-87404 3 = 055-287-3723 Mtel1 = 055-287-3723 4 = 010-8817-8534 Mhp = 010-8817-8534 ========================2024-11-01 12:04:26======================== select * from customers where id = 'hanmotor' ========================2024-11-01 12:04:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hanmotor','2024-11-01 12:04:26','52500','55000','온라인','0') ========================2024-11-01 16:14:29======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mdatlas2-1730445159 LGD_BUYER = 박재천 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241101161239 LGD_HASHDATA = 63108f215a3de8ff040ad9cbef2c18a5 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 = 2024110116175990421CC8F382C9AFA6DA50B3B6FE26FA7961EADE Mname = 박재천 Mcompany = (주)동창물산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = mdatlas2 LGD_ESCROW_USEYN = N ========================2024-11-01 16:14:29======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241101161800 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = mdatlas@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = DALC6G LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94108101****279* LGD_FINANCEAUTHNUM = 21282075 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a34a1a4f68aedbfa2a8ad9f1dc06073b LGD_BUYERADDRESS = LGD_FINANCENAME = 신한 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20241101161800 LGD_PCANCELSTR = 0 LGD_BUYER = 박재천 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241101161800R9db3 LGD_BUYERID = LGD_OID = Direct-mdatlas2-1730445159 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-11-01 16:14:29======================== insert into mBoard_order set rOrdNo = 'Direct-mdatlas2-1730445159', AuthTy = 'card', memberId = 'mdatlas2', OrdNm ='박재천', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)동창물산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한 94108101****279*', rApprNo = 'mjsof20241101161800R9db3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-01 16:14:29', InvoiceNum = '결제성공:Direct-mdatlas2-1730445159/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-01 16:14:29' ========================2024-11-01 16:14:29======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241101161800R9db3' 0 = 1 cnt = 1 ========================2024-11-01 16:14:29======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mdatlas2' 0 = mdatlas2 Mid = mdatlas2 1 = (주)동창물산 Mcompany = (주)동창물산 2 = 3048126406 companyNum = 3048126406 3 = 043-647-4396 Mtel1 = 043-647-4396 4 = 010-4396-2996 Mhp = 010-4396-2996 ========================2024-11-01 16:14:29======================== select * from customers where id = 'mdatlas2' ========================2024-11-01 16:14:29======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mdatlas2','2024-11-01 16:14:29','108000','110000','온라인','0')