========================2024-02-07 14:33:23======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kds1-1707283926 LGD_BUYER = 오정호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240207143206 LGD_HASHDATA = 5f8e1f4750df0dcaef47c3da92dd662a 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 = 2024020714380364DDDE1C10C1B7F1CC863D2C15E22BF329528CA2 Mname = 오정호 Mcompany = 메인로드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kds1 LGD_ESCROW_USEYN = N ========================2024-02-07 14:33:23======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240207143803 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003300 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****589* LGD_FINANCEAUTHNUM = 30177172 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e364eaacdd4d8d6a3de718e7dde8d468 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240207143803 LGD_PCANCELSTR = 0 LGD_BUYER = 오정호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240207143803atzX5 LGD_BUYERID = LGD_OID = Direct-kds1-1707283926 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7143803aFSV9 ========================2024-02-07 14:33:23======================== insert into mBoard_order set rOrdNo = 'Direct-kds1-1707283926', AuthTy = 'card', memberId = 'kds1', OrdNm ='오정호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '메인로드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****589*', rApprNo = 'mjsof20240207143803atzX5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-02-07 14:33:23', InvoiceNum = '결제성공:Direct-kds1-1707283926/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-02-07 14:33:23' ========================2024-02-07 14:33:23======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240207143803atzX5' 0 = 1 cnt = 1 ========================2024-02-07 14:33:23======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kds1' 0 = kds1 Mid = kds1 1 = 메인로드 Mcompany = 메인로드 2 = 1180300092 companyNum = 1180300092 3 = 031-267-3340 Mtel1 = 031-267-3340 4 = 010-8680-1206 Mhp = 010-8680-1206 ========================2024-02-07 14:33:23======================== select * from customers where id = 'kds1' ========================2024-02-07 14:33:23======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kds1','2024-02-07 14:33:23','52500','55000','온라인','0') ========================2024-02-07 14:48:23======================== res_start ========================2024-02-07 14:48:23======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다. Init_TX(LGD_MID)를 해주시기 바랍니다. 또는 mall.conf 에 상점키가 셋팅되어 있지 않습니다. ========================2024-02-07 14:53:38======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-azfoods01-1707285179 LGD_BUYER = 박정운 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240207145259 LGD_HASHDATA = 3987eb51bfbc78bf0aaf9de028d0f808 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 = 202402071458183AA05EB6BDC9C83E5F8BB7DF7DEFB045C49C7878 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 ========================2024-02-07 14:53:38======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240207145818 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = azfoods@chol.com 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 = 55852637****282* LGD_FINANCEAUTHNUM = 30022569 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6682d76677bb2f3e83de2160846a4def LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240207145818 LGD_PCANCELSTR = 0 LGD_BUYER = 박정운 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202402071458181aTQ2 LGD_BUYERID = LGD_OID = Direct-azfoods01-1707285179 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 714581810sW4 ========================2024-02-07 14:53:38======================== insert into mBoard_order set rOrdNo = 'Direct-azfoods01-1707285179', 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 = 'mjsof202402071458181aTQ2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-02-07 14:53:38', InvoiceNum = '결제성공:Direct-azfoods01-1707285179/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-02-07 14:53:38' ========================2024-02-07 14:53:38======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202402071458181aTQ2' 0 = 1 cnt = 1 ========================2024-02-07 14:53:38======================== 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 ========================2024-02-07 14:53:38======================== select * from customers where id = 'azfoods01' ========================2024-02-07 14:53:38======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('azfoods01','2024-02-07 14:53:38','108000','110000','온라인','0') ========================2024-02-07 15:09:48======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodyhs1-1707286099 LGD_BUYER = 유효상 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240207150819 LGD_HASHDATA = c1fb35798bb0ae20a159385a0bac741c 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 = 202402071514283E7A82080D9FB59D84A284FA395D0D8F66CC0A53 Mname = 유효상 Mcompany = 해로유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = goodyhs1 LGD_ESCROW_USEYN = N ========================2024-02-07 15:09:48======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240207151428 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 37918396****20* LGD_FINANCEAUTHNUM = 75796183 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 51400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c7a4ffb36fade3f2062e02713f96abc1 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20240207151428 LGD_PCANCELSTR = 0 LGD_BUYER = 유효상 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202402071514288diK4 LGD_BUYERID = LGD_OID = Direct-goodyhs1-1707286099 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-02-07 15:09:48======================== insert into mBoard_order set rOrdNo = 'Direct-goodyhs1-1707286099', AuthTy = 'card', memberId = 'goodyhs1', OrdNm ='유효상', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '해로유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '삼성AMEX 37918396****20*', rApprNo = 'mjsof202402071514288diK4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-02-07 15:09:48', InvoiceNum = '결제성공:Direct-goodyhs1-1707286099/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-02-07 15:09:48' ========================2024-02-07 15:09:48======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202402071514288diK4' 0 = 1 cnt = 1 ========================2024-02-07 15:09:48======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodyhs1' 0 = goodyhs1 Mid = goodyhs1 1 = 해로유통 Mcompany = 해로유통 2 = 5210600305 companyNum = 5210600305 3 = 062-671-7977 Mtel1 = 062-671-7977 4 = 010-9990-7977 Mhp = 010-9990-7977 ========================2024-02-07 15:09:48======================== select * from customers where id = 'goodyhs1' ========================2024-02-07 15:09:48======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodyhs1','2024-02-07 15:09:48','52500','55000','온라인','0') ========================2024-02-07 15:53:07======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-qnc1425-1707288721 LGD_BUYER = 은효미 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240207155201 LGD_HASHDATA = 244fb742ba24784b67b12c193fded498 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 = 2024020715574773AFA122447269ACDD2CDC3344E2B94E8453EC8A Mname = 은효미 Mcompany = (주)큐엔씨B2B점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = qnc1425 LGD_ESCROW_USEYN = N ========================2024-02-07 15:53:08======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240207155748 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = qnc1425@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 009061 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94454131****209* LGD_FINANCEAUTHNUM = 30161144 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 11000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 209a701399f5b316c0e0f04c5af4fcff LGD_BUYERADDRESS = LGD_FINANCENAME = 국민 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240207155748 LGD_PCANCELSTR = 0 LGD_BUYER = 은효미 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2024020715574897Ah7 LGD_BUYERID = LGD_OID = Direct-qnc1425-1707288721 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-02-07 15:53:08======================== insert into mBoard_order set rOrdNo = 'Direct-qnc1425-1707288721', AuthTy = 'card', memberId = 'qnc1425', OrdNm ='은효미', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)큐엔씨B2B점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '국민 94454131****209*', rApprNo = 'mjsof2024020715574897Ah7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-02-07 15:53:08', InvoiceNum = '결제성공:Direct-qnc1425-1707288721/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-02-07 15:53:08' ========================2024-02-07 15:53:08======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2024020715574897Ah7' 0 = 1 cnt = 1 ========================2024-02-07 15:53:08======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'qnc1425' 0 = qnc1425 Mid = qnc1425 1 = (주)큐엔씨B2B점 Mcompany = (주)큐엔씨B2B점 2 = 2038505014 companyNum = 2038505014 3 = 031-684-1425 Mtel1 = 031-684-1425 4 = 010-3675-2628 Mhp = 010-3675-2628 ========================2024-02-07 15:53:08======================== select * from customers where id = 'qnc1425' ========================2024-02-07 15:53:08======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('qnc1425','2024-02-07 15:53:08','30900','33000','온라인','0') ========================2024-02-07 15:59:12======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-fab9992-1707289102 LGD_BUYER = 신호철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240207155822 LGD_HASHDATA = b05c3e8f4fcd29d2ed7f61c99e6ce652 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 = 202402071603521F266220EFA4BE7464AFEA1A71926375A70589F0 Mname = 신호철 Mcompany = 대도스포츠 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = fab9992 LGD_ESCROW_USEYN = N ========================2024-02-07 15:59:12======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240207160352 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 004650 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658602****104* LGD_FINANCEAUTHNUM = 30010991 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e4611f426811276bcca4d0306bb6a0b5 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240207160352 LGD_PCANCELSTR = 0 LGD_BUYER = 신호철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2024020716035298dq4 LGD_BUYERID = LGD_OID = Direct-fab9992-1707289102 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-02-07 15:59:12======================== insert into mBoard_order set rOrdNo = 'Direct-fab9992-1707289102', AuthTy = 'card', memberId = 'fab9992', OrdNm ='신호철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대도스포츠', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민VISA 42658602****104*', rApprNo = 'mjsof2024020716035298dq4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-02-07 15:59:12', InvoiceNum = '결제성공:Direct-fab9992-1707289102/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-02-07 15:59:12' ========================2024-02-07 15:59:13======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2024020716035298dq4' 0 = 1 cnt = 1 ========================2024-02-07 15:59:13======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'fab9992' 0 = fab9992 Mid = fab9992 1 = 대도스포츠 Mcompany = 대도스포츠 2 = 5360302018 companyNum = 5360302018 3 = 02-853-5036 Mtel1 = 02-853-5036 4 = 010-4751-0004 Mhp = 010-4751-0004 ========================2024-02-07 15:59:13======================== select * from customers where id = 'fab9992' ========================2024-02-07 15:59:13======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('fab9992','2024-02-07 15:59:12','108000','110000','온라인','0')