========================2024-06-03 08:40:49======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-babobong76-1717371497 LGD_BUYER = 신광섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240603083817 LGD_HASHDATA = 2eb1d5c56bb55a7e317630a652a916a4 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 = 20240603084128DE59B49CF4B8457E5AE23EC699CB7093AE56A7FD Mname = 신광섭 Mcompany = 풍성유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = babobong76 LGD_ESCROW_USEYN = N ========================2024-06-03 08:40:50======================== xpay_res LGD_DCNO = DC LGD_BUYERPHONE = LGD_PAYDATE = 20240603084128 LGD_DISCOUNTUSEYN = 1 LGD_BUYEREMAIL = BABOBONG76@HANMAIL.NET 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 = 51202899****607* LGD_FINANCEAUTHNUM = 91363843 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 1000 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a242723648579f0cf768dff6f6a0cf6a LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20240603084129 LGD_PCANCELSTR = 0 LGD_BUYER = 신광섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240603084128dIBS4 LGD_BUYERID = LGD_OID = Direct-babobong76-1717371497 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-06-03 08:40:50======================== insert into mBoard_order set rOrdNo = 'Direct-babobong76-1717371497', AuthTy = 'card', memberId = 'babobong76', OrdNm ='신광섭', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '풍성유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '삼성MASTER 51202899****607*', rApprNo = 'mjsof20240603084128dIBS4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-03 08:40:50', InvoiceNum = '결제성공:Direct-babobong76-1717371497/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-03 08:40:50' ========================2024-06-03 08:40:50======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240603084128dIBS4' 0 = 1 cnt = 1 ========================2024-06-03 08:40:50======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'babobong76' 0 = babobong76 Mid = babobong76 1 = 풍성유통 Mcompany = 풍성유통 2 = 1283414317 companyNum = 1283414317 3 = 070-5017-5882 Mtel1 = 070-5017-5882 4 = 010-4798-0526 Mhp = 010-4798-0526 ========================2024-06-03 08:40:50======================== select * from customers where id = 'babobong76' ========================2024-06-03 08:40:50======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('babobong76','2024-06-03 08:40:50','108000','110000','온라인','0') ========================2024-06-03 10:35:07======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-samwha135-1717378392 LGD_BUYER = 곽상영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240603103312 LGD_HASHDATA = 1a7abaa2fc4c9c956f189d4f359e0c22 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 = 20240603103546FC57308078E066A7E149955EF0AD60D8B878B1C4 Mname = 곽상영 Mcompany = 삼화종합중기 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = samwha135 LGD_ESCROW_USEYN = N ========================2024-06-03 10:35:08======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240603103546 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = k2hnws@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 496C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94118100****115* LGD_FINANCEAUTHNUM = 27104405 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 21000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c8c57ef57cf2716b5651fd4cab81827e LGD_BUYERADDRESS = LGD_FINANCENAME = 하나 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20240603103547 LGD_PCANCELSTR = 0 LGD_BUYER = 곽상영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2024060310354624PY8 LGD_BUYERID = LGD_OID = Direct-samwha135-1717378392 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-06-03 10:35:08======================== insert into mBoard_order set rOrdNo = 'Direct-samwha135-1717378392', AuthTy = 'card', memberId = 'samwha135', OrdNm ='곽상영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '삼화종합중기', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '하나 94118100****115*', rApprNo = 'mjsof2024060310354624PY8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-03 10:35:08', InvoiceNum = '결제성공:Direct-samwha135-1717378392/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-03 10:35:08' ========================2024-06-03 10:35:08======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2024060310354624PY8' 0 = 1 cnt = 1 ========================2024-06-03 10:35:08======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'samwha135' 0 = samwha135 Mid = samwha135 1 = 삼화종합중기 Mcompany = 삼화종합중기 2 = 1352954706 companyNum = 1352954706 3 = 010-3753-9095 Mtel1 = 010-3753-9095 4 = 010-8929-9095 Mhp = 010-8929-9095 ========================2024-06-03 10:35:08======================== select * from customers where id = 'samwha135' ========================2024-06-03 10:35:08======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('samwha135','2024-06-03 10:35:08','220000','220000','온라인','0') ========================2024-06-03 11:33:14======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-youngor0505-1717381537 LGD_BUYER = 안영오 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240603112537 LGD_HASHDATA = 75a84951cf2009d9289b91c5dc809b76 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 = 20240603113353815B808EAF177878E5C195202DEA06001BC033CB Mname = 안영오 Mcompany = 첨단유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = youngor0505 LGD_ESCROW_USEYN = N ========================2024-06-03 11:33:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240603113353 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = juyounggg@daum.net 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 = 40091119****961* LGD_FINANCEAUTHNUM = 29139517 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 51100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d163d2dc39ae70d97a6866023cfdbd4c LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20240603113354 LGD_PCANCELSTR = 0 LGD_BUYER = 안영오 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240603113353avjZ3 LGD_BUYERID = LGD_OID = Direct-youngor0505-1717381537 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-06-03 11:33:15======================== insert into mBoard_order set rOrdNo = 'Direct-youngor0505-1717381537', AuthTy = 'card', memberId = 'youngor0505', OrdNm ='안영오', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '첨단유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '삼성VISA 40091119****961*', rApprNo = 'mjsof20240603113353avjZ3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-03 11:33:15', InvoiceNum = '결제성공:Direct-youngor0505-1717381537/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-03 11:33:15' ========================2024-06-03 11:33:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240603113353avjZ3' 0 = 1 cnt = 1 ========================2024-06-03 11:33:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'youngor0505' 0 = youngor0505 Mid = youngor0505 1 = 첨단유통 Mcompany = 첨단유통 2 = 2044065504 companyNum = 2044065504 3 = 010-5601-8411 Mtel1 = 010-5601-8411 4 = 010-5602-8411 Mhp = 010-5602-8411 ========================2024-06-03 11:33:15======================== select * from customers where id = 'youngor0505' ========================2024-06-03 11:33:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('youngor0505','2024-06-03 11:33:15','10000','11000','온라인','0') ========================2024-06-03 14:07:36======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kyg2031-1717391137 LGD_BUYER = 김용국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240603140537 LGD_HASHDATA = 72f8db30ab35ce3273f03b47e1c66657 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 = 202406031408145F2077A5C6C86D4521E0C4CF448DEA1B086E166B 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-06-03 14:07:37======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240603140815 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 = 27280117 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 35200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5285edb01d8a4bdaaea31c277da6c86f LGD_BUYERADDRESS = LGD_FINANCENAME = 전북MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240603140816 LGD_PCANCELSTR = 0 LGD_BUYER = 김용국 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof20240603140815hY1N1 LGD_BUYERID = LGD_OID = Direct-kyg2031-1717391137 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 031408612899 ========================2024-06-03 14:07:37======================== insert into mBoard_order set rOrdNo = 'Direct-kyg2031-1717391137', 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 = 'mjsof20240603140815hY1N1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-03 14:07:37', InvoiceNum = '결제성공:Direct-kyg2031-1717391137/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-03 14:07:37' ========================2024-06-03 14:07:37======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240603140815hY1N1' 0 = 1 cnt = 1 ========================2024-06-03 14:07:37======================== 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-06-03 14:07:37======================== select * from customers where id = 'kyg2031' ========================2024-06-03 14:07:37======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kyg2031','2024-06-03 14:07:37','52500','55000','온라인','0') ========================2024-06-03 15:37:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-zqca97-1717396573 LGD_BUYER = 염서울 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240603153613 LGD_HASHDATA = 713e227ca4b752f3363c44103b00a6eb 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 = 20240603153756DB472E3DAF3B4B33B31513DBE10926C3959629E2 Mname = 염서울 Mcompany = 경제금속 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = zqca97 LGD_ESCROW_USEYN = N ========================2024-06-03 15:37:18======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_CARD LGD_BUYERPHONE = LGD_PAYDATE = 20240603153757 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = zqca72@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_UPAYFLG = U LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 37798801****816* LGD_FINANCEAUTHNUM = 05989289 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 41400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1ae2654283c7dec43bd548f018b1e569 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240603153757 LGD_PCANCELSTR = 0 LGD_BUYER = 염서울 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240603153742mgV68 LGD_BUYERID = LGD_OID = Direct-zqca97-1717396573 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-06-03 15:37:18======================== insert into mBoard_order set rOrdNo = 'Direct-zqca97-1717396573', AuthTy = 'card', memberId = 'zqca97', OrdNm ='염서울', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '경제금속', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '신한AMEX 37798801****816*', rApprNo = 'mjsof20240603153742mgV68', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-03 15:37:18', InvoiceNum = '결제성공:Direct-zqca97-1717396573/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-03 15:37:18' ========================2024-06-03 15:37:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240603153742mgV68' 0 = 1 cnt = 1 ========================2024-06-03 15:37:18======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'zqca97' 0 = zqca97 Mid = zqca97 1 = 경제금속 Mcompany = 경제금속 2 = companyNum = 3 = 010-8785-9797 Mtel1 = 010-8785-9797 4 = Mhp = ========================2024-06-03 15:37:18======================== select * from customers where id = 'zqca97' ========================2024-06-03 15:37:18======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('zqca97','경제금속','','010-8785-9797','','2024-06-03 15:37:18','온라인') ========================2024-06-03 15:37:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('zqca97','2024-06-03 15:37:18','30900','33000','온라인','0')