========================2024-02-02 00:51:33======================== res_start ========================2024-02-02 00:51:33======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다. Init_TX(LGD_MID)를 해주시기 바랍니다. 또는 mall.conf 에 상점키가 셋팅되어 있지 않습니다. ========================2024-02-02 08:22:36======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1706829647 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240202082047 LGD_HASHDATA = 4a50f22e19bb0566ec2842331a1e3364 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 = 2024020208271046B41E6F87207F7DA581F3493083F4E0A7E8494E Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2024-02-02 08:22:37======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240202082711 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94301703****448* LGD_FINANCEAUTHNUM = 53131152 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 08365ef0faab1b622461b5e60c0ad170 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240202082711 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240202082711BIvG0 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1706829647 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-02-02 08:22:37======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1706829647', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 94301703****448*', rApprNo = 'mjsof20240202082711BIvG0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-02-02 08:22:37', InvoiceNum = '결제성공:Direct-goodssal5707-1706829647/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-02-02 08:22:37' ========================2024-02-02 08:22:37======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240202082711BIvG0' 0 = 1 cnt = 1 ========================2024-02-02 08:22:37======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2024-02-02 08:22:37======================== select * from customers where id = 'goodssal5707' ========================2024-02-02 08:22:37======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2024-02-02 08:22:37','220000','220000','온라인','0') ========================2024-02-02 08:23:31======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1706829769 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240202082249 LGD_HASHDATA = d6c4f82c724946f98fde976c3b1d5aa7 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 = 202402020828056F3DAED393DA9E3FEDC16D0D5961AE3D842C22F8 Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2024-02-02 08:23:32======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240202082806 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94301703****448* LGD_FINANCEAUTHNUM = 53134889 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c8621f520dc58268928597aab028591e LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240202082806 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240202082805rR9N9 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1706829769 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-02-02 08:23:32======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1706829769', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH 94301703****448*', rApprNo = 'mjsof20240202082805rR9N9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-02-02 08:23:32', InvoiceNum = '결제성공:Direct-goodssal5707-1706829769/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-02-02 08:23:32' ========================2024-02-02 08:23:32======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240202082805rR9N9' 0 = 1 cnt = 1 ========================2024-02-02 08:23:32======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2024-02-02 08:23:32======================== select * from customers where id = 'goodssal5707' ========================2024-02-02 08:23:32======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2024-02-02 08:23:32','108000','110000','온라인','0') ========================2024-02-02 08:27:37======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodfood2023-1706829834 LGD_BUYER = 최상용 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240202082354 LGD_HASHDATA = 648f61b2dfab0766d4276f22ff6a189c 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 = 202402020832110F7F13483C41D74C5A07CD6536E44DA93BD155E7 Mname = 최상용 Mcompany = 좋은푸드컬리주식회사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = goodfood2023 LGD_ESCROW_USEYN = N ========================2024-02-02 08:27:38======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240202083211 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 101748 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55850313****697* LGD_FINANCEAUTHNUM = 40034466 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = db79a5d2308a38e44a2ec91e7952b60a LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240202083212 LGD_PCANCELSTR = 0 LGD_BUYER = 최상용 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240202083211BISH7 LGD_BUYERID = LGD_OID = Direct-goodfood2023-1706829834 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 2083211Bfwn7 ========================2024-02-02 08:27:38======================== insert into mBoard_order set rOrdNo = 'Direct-goodfood2023-1706829834', AuthTy = 'card', memberId = 'goodfood2023', OrdNm ='최상용', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '좋은푸드컬리주식회사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨MASTER 55850313****697*', rApprNo = 'mjsof20240202083211BISH7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-02-02 08:27:38', InvoiceNum = '결제성공:Direct-goodfood2023-1706829834/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-02-02 08:27:38' ========================2024-02-02 08:27:38======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240202083211BISH7' 0 = 1 cnt = 1 ========================2024-02-02 08:27:38======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodfood2023' 0 = goodfood2023 Mid = goodfood2023 1 = 좋은푸드컬리주식회사 Mcompany = 좋은푸드컬리주식회사 2 = 112-86-02741 companyNum = 112-86-02741 3 = 010-8880-9146 Mtel1 = 010-8880-9146 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2024-02-02 08:27:38======================== select * from customers where id = 'goodfood2023' ========================2024-02-02 08:27:38======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodfood2023','2024-02-02 08:27:38','108000','110000','온라인','0') ========================2024-02-02 08:46:30======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hotface-1706830949 LGD_BUYER = 백승령 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240202084229 LGD_HASHDATA = 4c9fcdbbab8a77d34dada8215819ea73 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 = 202402020851047E0F49B75AF387F4E689E3CE47FFDB9960BD37FB Mname = 백승령 Mcompany = (주)아신비에스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = hotface LGD_ESCROW_USEYN = N ========================2024-02-02 08:46:31======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240202085105 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 328193 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55853211****491* LGD_FINANCEAUTHNUM = 40121042 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 04510e53393b64a7a29d934be91f4cda LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240202085105 LGD_PCANCELSTR = 0 LGD_BUYER = 백승령 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240202085105mtke0 LGD_BUYERID = LGD_OID = Direct-hotface-1706830949 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 2085105mkq35 ========================2024-02-02 08:46:31======================== insert into mBoard_order set rOrdNo = 'Direct-hotface-1706830949', AuthTy = 'card', memberId = 'hotface', OrdNm ='백승령', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)아신비에스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨MASTER 55853211****491*', rApprNo = 'mjsof20240202085105mtke0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-02-02 08:46:31', InvoiceNum = '결제성공:Direct-hotface-1706830949/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-02-02 08:46:31' ========================2024-02-02 08:46:31======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240202085105mtke0' 0 = 1 cnt = 1 ========================2024-02-02 08:46:31======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hotface' 0 = hotface Mid = hotface 1 = (주)아신비에스 Mcompany = (주)아신비에스 2 = 603-81-71943 companyNum = 603-81-71943 3 = 051-256-7913 Mtel1 = 051-256-7913 4 = 010-3363-2209 Mhp = 010-3363-2209 ========================2024-02-02 08:46:31======================== select * from customers where id = 'hotface' ========================2024-02-02 08:46:31======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hotface','2024-02-02 08:46:31','220000','220000','온라인','0') ========================2024-02-02 18:15:00======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kclab-1706865231 LGD_BUYER = 홍성모 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240202181351 LGD_HASHDATA = 1b19a408513ab82194747bc939e7d024 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 = 202402021819349A814009371A944A4FC1951994E58FB6098EDD53 Mname = 홍성모 Mcompany = 주식회사케이씨랩그로운다이아몬드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = kclab LGD_ESCROW_USEYN = N ========================2024-02-02 18:15:00======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240202181935 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****888* LGD_FINANCEAUTHNUM = 30006489 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 893a8a2a64f33b253fa990e24eeef0df LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240202181935 LGD_PCANCELSTR = 0 LGD_BUYER = 홍성모 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240202181934j8dR1 LGD_BUYERID = LGD_OID = Direct-kclab-1706865231 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 2181934jMNO0 ========================2024-02-02 18:15:00======================== insert into mBoard_order set rOrdNo = 'Direct-kclab-1706865231', AuthTy = 'card', memberId = 'kclab', OrdNm ='홍성모', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사케이씨랩그로운다이아몬드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****888*', rApprNo = 'mjsof20240202181934j8dR1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-02-02 18:15:00', InvoiceNum = '결제성공:Direct-kclab-1706865231/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-02-02 18:15:00' ========================2024-02-02 18:15:01======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240202181934j8dR1' 0 = 1 cnt = 1 ========================2024-02-02 18:15:01======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kclab' 0 = kclab Mid = kclab 1 = 주식회사케이씨랩그로운다이아몬드 Mcompany = 주식회사케이씨랩그로운다이아몬드 2 = 748-87-01892 companyNum = 748-87-01892 3 = 02-766-8787 Mtel1 = 02-766-8787 4 = 010-5477-6018 Mhp = 010-5477-6018 ========================2024-02-02 18:15:01======================== select * from customers where id = 'kclab' ========================2024-02-02 18:15:01======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kclab','2024-02-02 18:15:00','108000','110000','온라인','0') ========================2024-02-02 20:17:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kimfanju-1706872498 LGD_BUYER = 이은희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240202201458 LGD_HASHDATA = 17d397213d53882869fe50ea4864a8c9 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 = 202402022021494A92F7AF81CDA88EE7BBFF6CBD17F54A438BEA3B Mname = 이은희 Mcompany = 바로푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = kimfanju LGD_ESCROW_USEYN = N ========================2024-02-02 20:17:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240202202149 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 328193 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55853211****599* LGD_FINANCEAUTHNUM = 45810371 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d79530fe50db08ee8b57ea9a7523c5a2 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240202202150 LGD_PCANCELSTR = 0 LGD_BUYER = 이은희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240202202149ieGY0 LGD_BUYERID = LGD_OID = Direct-kimfanju-1706872498 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 2202149ilCj9 ========================2024-02-02 20:17:15======================== insert into mBoard_order set rOrdNo = 'Direct-kimfanju-1706872498', AuthTy = 'card', memberId = 'kimfanju', OrdNm ='이은희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '바로푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '비씨MASTER 55853211****599*', rApprNo = 'mjsof20240202202149ieGY0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-02-02 20:17:15', InvoiceNum = '결제성공:Direct-kimfanju-1706872498/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-02-02 20:17:15' ========================2024-02-02 20:17:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240202202149ieGY0' 0 = 1 cnt = 1 ========================2024-02-02 20:17:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kimfanju' 0 = kimfanju Mid = kimfanju 1 = 바로푸드 Mcompany = 바로푸드 2 = 8805100280 companyNum = 8805100280 3 = 051-752-0017 Mtel1 = 051-752-0017 4 = 010-2980-0017 Mhp = 010-2980-0017 ========================2024-02-02 20:17:15======================== select * from customers where id = 'kimfanju' ========================2024-02-02 20:17:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kimfanju','2024-02-02 20:17:15','10000','11000','온라인','0')