========================2021-03-02 06:39:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-filsy82-1614634641 LGD_BUYER = 이승환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210302063721 LGD_HASHDATA = 0aa35db877766133c322d01446db8949 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202103020639202773746EBCA2AC8A8446BFD0F119F3C0C6E19141 Mname = 이승환 Mcompany = 동원상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = filsy82 LGD_ESCROW_USEYN = N ========================2021-03-02 06:39:17======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210302063920 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = BBBBPW LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 554481******6314 LGD_FINANCEAUTHNUM = 46641165 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c76fc0865a0e3ae2baed328e33b53b55 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210302063921 LGD_PCANCELSTR = 0 LGD_BUYER = 이승환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021030206392060296 LGD_BUYERID = LGD_OID = Direct-filsy82-1614634641 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-03-02 06:39:17======================== insert into mBoard_order set rOrdNo = 'Direct-filsy82-1614634641', AuthTy = 'card', memberId = 'filsy82', OrdNm ='이승환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '동원상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '신한MASTER 554481******6314', rApprNo = 'mjsof2021030206392060296', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-03-02 06:39:17', InvoiceNum = '결제성공:Direct-filsy82-1614634641/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-03-02 06:39:17' ========================2021-03-02 06:39:17======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021030206392060296' 0 = 1 cnt = 1 ========================2021-03-02 06:39:17======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'filsy82' 0 = filsy82 Mid = filsy82 1 = 동원상사 Mcompany = 동원상사 2 = 1243632559 companyNum = 1243632559 3 = 010-3363-5661 Mtel1 = 010-3363-5661 4 = -- Mhp = -- ========================2021-03-02 06:39:17======================== select * from customers where id = 'filsy82' ========================2021-03-02 06:39:17======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('filsy82','2021-03-02 06:39:17','10000','11000','온라인','0') ========================2021-03-02 11:34:30======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mnziper-1614652327 LGD_BUYER = 정형관 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210302113207 LGD_HASHDATA = 55eca52a0ea8a6ba618fa870f1e1f97f LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202103021134347DA4323284ED856F9CB6F9430363DFEF71C6A728 Mname = 정형관 Mcompany = (주)만나케미칼 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = mnziper LGD_ESCROW_USEYN = N ========================2021-03-02 11:34:31======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210302113435 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = mnzipper@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******5896 LGD_FINANCEAUTHNUM = 30038902 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4e21756ed0a81d85e674a0c35a2b8362 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210302113435 LGD_PCANCELSTR = 0 LGD_BUYER = 정형관 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021030211343460249 LGD_BUYERID = LGD_OID = Direct-mnziper-1614652327 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 211343460266 ========================2021-03-02 11:34:31======================== insert into mBoard_order set rOrdNo = 'Direct-mnziper-1614652327', AuthTy = 'card', memberId = 'mnziper', OrdNm ='정형관', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)만나케미칼', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 558526******5896', rApprNo = 'mjsof2021030211343460249', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-03-02 11:34:31', InvoiceNum = '결제성공:Direct-mnziper-1614652327/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-03-02 11:34:31' ========================2021-03-02 11:34:31======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021030211343460249' 0 = 1 cnt = 1 ========================2021-03-02 11:34:31======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mnziper' 0 = mnziper Mid = mnziper 1 = (주)만나케미칼 Mcompany = (주)만나케미칼 2 = 3518600993 companyNum = 3518600993 3 = 032-671-8070 Mtel1 = 032-671-8070 4 = 010-4569-3717 Mhp = 010-4569-3717 ========================2021-03-02 11:34:31======================== select * from customers where id = 'mnziper' ========================2021-03-02 11:34:31======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mnziper','2021-03-02 11:34:31','52500','55000','온라인','0') ========================2021-03-02 13:09:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bs215-1614658121 LGD_BUYER = 대륜기공사 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210302130841 LGD_HASHDATA = 1a79e414431343f0554fa37f05119514 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20210302130917F6A1669C8B3C6C70B23E0768D64636C526A84B54 Mname = 대륜기공사 Mcompany = 대륜기공사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = bs215 LGD_ESCROW_USEYN = N ========================2021-03-02 13:09:14======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210302130917 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 031095 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 414003******1936 LGD_FINANCEAUTHNUM = 37662249 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 847af4ad6365dc725080cc060676dc1b LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210302130918 LGD_PCANCELSTR = 0 LGD_BUYER = 대륜기공사 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021030213091760028 LGD_BUYERID = LGD_OID = Direct-bs215-1614658121 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 213091760012 ========================2021-03-02 13:09:14======================== insert into mBoard_order set rOrdNo = 'Direct-bs215-1614658121', AuthTy = 'card', memberId = 'bs215', OrdNm ='대륜기공사', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대륜기공사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨VISA 414003******1936', rApprNo = 'mjsof2021030213091760028', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-03-02 13:09:14', InvoiceNum = '결제성공:Direct-bs215-1614658121/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-03-02 13:09:14' ========================2021-03-02 13:09:14======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021030213091760028' 0 = 1 cnt = 1 ========================2021-03-02 13:09:14======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bs215' 0 = bs215 Mid = bs215 1 = 대륜기공사 Mcompany = 대륜기공사 2 = 609-54-63877 companyNum = 609-54-63877 3 = 055-265-5107 Mtel1 = 055-265-5107 4 = 010-5498-1991 Mhp = 010-5498-1991 ========================2021-03-02 13:09:14======================== select * from customers where id = 'bs215' ========================2021-03-02 13:09:14======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bs215','2021-03-02 13:09:14','52500','55000','온라인','0') ========================2021-03-02 13:56:37======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kyg2031-1614660943 LGD_BUYER = 김용국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210302135543 LGD_HASHDATA = cc46d1761413e3dd46359af39da7ec96 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202103021356413FCF420AE635031325B6FC3387B454B03F6072B8 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 ========================2021-03-02 13:56:38======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210302135641 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = 0000V0 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 553531******0117 LGD_FINANCEAUTHNUM = 38564146 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 35200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ae453ac6d4a4c4864b9123d5a98f3b81 LGD_BUYERADDRESS = LGD_FINANCENAME = 전북MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210302135642 LGD_PCANCELSTR = 0 LGD_BUYER = 김용국 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof2021030213564160030 LGD_BUYERID = LGD_OID = Direct-kyg2031-1614660943 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 021356624906 ========================2021-03-02 13:56:38======================== insert into mBoard_order set rOrdNo = 'Direct-kyg2031-1614660943', AuthTy = 'card', memberId = 'kyg2031', OrdNm ='김용국', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(유)성광물산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '전북MASTER 553531******0117', rApprNo = 'mjsof2021030213564160030', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-03-02 13:56:38', InvoiceNum = '결제성공:Direct-kyg2031-1614660943/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-03-02 13:56:38' ========================2021-03-02 13:56:38======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021030213564160030' 0 = 1 cnt = 1 ========================2021-03-02 13:56:38======================== 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-9875-4995 Mhp = 010-9875-4995 ========================2021-03-02 13:56:38======================== select * from customers where id = 'kyg2031' ========================2021-03-02 13:56:38======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kyg2031','2021-03-02 13:56:38','52500','55000','온라인','0') ========================2021-03-02 14:12:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jis3900-1614661861 LGD_BUYER = 김준환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210302141101 LGD_HASHDATA = a53402739429c1c0d7c94f64c817573a LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20210302141259E64E1E451497453E89A2545FD941747FD95357B1 Mname = 김준환 Mcompany = 제일안전 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = jis3900 LGD_ESCROW_USEYN = N ========================2021-03-02 14:12:55======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210302141259 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 941000******5590 LGD_FINANCEAUTHNUM = 39754963 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 21000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b566cbd78518135e441368b879bebd31 LGD_BUYERADDRESS = LGD_FINANCENAME = 외환 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20210302141259 LGD_PCANCELSTR = 0 LGD_BUYER = 김준환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021030214125961198 LGD_BUYERID = LGD_OID = Direct-jis3900-1614661861 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-03-02 14:12:55======================== insert into mBoard_order set rOrdNo = 'Direct-jis3900-1614661861', AuthTy = 'card', memberId = 'jis3900', OrdNm ='김준환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '제일안전', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '외환 941000******5590', rApprNo = 'mjsof2021030214125961198', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-03-02 14:12:55', InvoiceNum = '결제성공:Direct-jis3900-1614661861/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-03-02 14:12:55' ========================2021-03-02 14:12:56======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021030214125961198' 0 = 1 cnt = 1 ========================2021-03-02 14:12:56======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jis3900' 0 = jis3900 Mid = jis3900 1 = 제일안전 Mcompany = 제일안전 2 = 4021421208 companyNum = 4021421208 3 = 010-3608-9568 Mtel1 = 010-3608-9568 4 = 010-3608-9568 Mhp = 010-3608-9568 ========================2021-03-02 14:12:56======================== select * from customers where id = 'jis3900' ========================2021-03-02 14:12:56======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jis3900','2021-03-02 14:12:55','108000','110000','온라인','0') ========================2021-03-02 15:24:43======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dsdb1011-1614666224 LGD_BUYER = 윤경미 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210302152344 LGD_HASHDATA = 517b675a386533d45593e45b6e16190e LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202103021524471A439A2B7C814357EBA1598A13E5E2233E00738E Mname = 윤경미 Mcompany = (주)디에스동부대리점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = dsdb1011 LGD_ESCROW_USEYN = N ========================2021-03-02 15:24:44======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210302152447 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 328193 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 654132******5962 LGD_FINANCEAUTHNUM = 39504571 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7d15ad55b15edeba49a7606415fe253b LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210302152448 LGD_PCANCELSTR = 0 LGD_BUYER = 윤경미 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021030215244761008 LGD_BUYERID = LGD_OID = Direct-dsdb1011-1614666224 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 215244761007 ========================2021-03-02 15:24:44======================== insert into mBoard_order set rOrdNo = 'Direct-dsdb1011-1614666224', AuthTy = 'card', memberId = 'dsdb1011', OrdNm ='윤경미', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)디에스동부대리점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 654132******5962', rApprNo = 'mjsof2021030215244761008', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-03-02 15:24:44', InvoiceNum = '결제성공:Direct-dsdb1011-1614666224/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-03-02 15:24:44' ========================2021-03-02 15:24:44======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021030215244761008' 0 = 1 cnt = 1 ========================2021-03-02 15:24:44======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dsdb1011' 0 = dsdb1011 Mid = dsdb1011 1 = (주)디에스동부대리점 Mcompany = (주)디에스동부대리점 2 = 6458601112 companyNum = 6458601112 3 = 010-4556-6507 Mtel1 = 010-4556-6507 4 = 010-4564-2692 Mhp = 010-4564-2692 ========================2021-03-02 15:24:44======================== select * from customers where id = 'dsdb1011' ========================2021-03-02 15:24:44======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dsdb1011','2021-03-02 15:24:44','52500','55000','온라인','0') ========================2021-03-02 15:53:02======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woo1934-1614667786 LGD_BUYER = 정동인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210302154946 LGD_HASHDATA = 67d802fc7a4342197b51c5185458b424 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20210302155306DB5FEC4F3447E2F5724C31D0279CA4E9A46C6037 Mname = 정동인 Mcompany = (주)우진글로벌 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = 아이디 두개 woo1934 / woo1935 11만원씩 충전 UserId = woo1934 LGD_ESCROW_USEYN = N ========================2021-03-02 15:53:03======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210302155307 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 426586******6816 LGD_FINANCEAUTHNUM = 30020546 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3871d4fc3a6787caeaf472ff05a7afca LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210302155307 LGD_PCANCELSTR = 0 LGD_BUYER = 정동인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021030215530760114 LGD_BUYERID = LGD_OID = Direct-woo1934-1614667786 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 215530760196 ========================2021-03-02 15:53:03======================== insert into mBoard_order set rOrdNo = 'Direct-woo1934-1614667786', AuthTy = 'card', memberId = 'woo1934', OrdNm ='정동인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)우진글로벌', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민VISA 426586******6816', rApprNo = 'mjsof2021030215530760114', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-03-02 15:53:03', InvoiceNum = '결제성공:Direct-woo1934-1614667786/0000', Deliver = '', senditem = '아이디 두개 woo1934 / woo1935 11만원씩 충전', salestopvalue = '', mod_date = '2021-03-02 15:53:03' ========================2021-03-02 15:53:03======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021030215530760114' 0 = 1 cnt = 1 ========================2021-03-02 15:53:03======================== 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 ========================2021-03-02 15:53:03======================== select * from customers where id = 'woo1934' ========================2021-03-02 15:53:03======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woo1934','2021-03-02 15:53:03','220000','220000','온라인','0') ========================2021-03-02 16:20:43======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ssignmall-1614669537 LGD_BUYER = 김혜연 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210302161857 LGD_HASHDATA = eea71e6bc5d7dfe0ad160a8cfe3be723 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202103021620475F2EE0D50B7B1E0CC76CA108E7718320E670AD6C Mname = 김혜연 Mcompany = 싸인몰 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = ssignmall LGD_ESCROW_USEYN = N ========================2021-03-02 16:20:44======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210302162048 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = gemini31@nate.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 036951 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 910003******7649 LGD_FINANCEAUTHNUM = 39868351 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fdac2ea7be7e08ed1d0b8c831e7e31ce LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210302162048 LGD_PCANCELSTR = 0 LGD_BUYER = 김혜연 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021030216204760216 LGD_BUYERID = LGD_OID = Direct-ssignmall-1614669537 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 216204760276 ========================2021-03-02 16:20:44======================== insert into mBoard_order set rOrdNo = 'Direct-ssignmall-1614669537', AuthTy = 'card', memberId = 'ssignmall', OrdNm ='김혜연', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '싸인몰', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 910003******7649', rApprNo = 'mjsof2021030216204760216', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-03-02 16:20:44', InvoiceNum = '결제성공:Direct-ssignmall-1614669537/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-03-02 16:20:44' ========================2021-03-02 16:20:44======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021030216204760216' 0 = 1 cnt = 1 ========================2021-03-02 16:20:44======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ssignmall' 0 = ssignmall Mid = ssignmall 1 = 싸인몰 Mcompany = 싸인몰 2 = 1198663278 companyNum = 1198663278 3 = 02-862-8768 Mtel1 = 02-862-8768 4 = 010-3311-1970 Mhp = 010-3311-1970 ========================2021-03-02 16:20:44======================== select * from customers where id = 'ssignmall' ========================2021-03-02 16:20:44======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ssignmall','2021-03-02 16:20:44','52500','55000','온라인','0') ========================2021-03-02 16:57:47======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hanakk-1614671792 LGD_BUYER = 이성희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210302165632 LGD_HASHDATA = e04108bdfe1c62441b4872e1b8752498 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20210302165751714BDD4068F44355C8C41DB412F6FF8652389CE9 Mname = 이성희 Mcompany = (주)하나계기 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = hanakk LGD_ESCROW_USEYN = N ========================2021-03-02 16:57:48======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210302165751 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = hana2540101@hanmail.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 244581 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 410120******7811 LGD_FINANCEAUTHNUM = 40171225 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 48a33a9625b131dec9f9810da0d7ca5b LGD_BUYERADDRESS = LGD_FINANCENAME = 우리VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210302165752 LGD_PCANCELSTR = 0 LGD_BUYER = 이성희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021030216575161236 LGD_BUYERID = LGD_OID = Direct-hanakk-1614671792 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 216575161238 ========================2021-03-02 16:57:48======================== insert into mBoard_order set rOrdNo = 'Direct-hanakk-1614671792', AuthTy = 'card', memberId = 'hanakk', OrdNm ='이성희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)하나계기', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '우리VISA 410120******7811', rApprNo = 'mjsof2021030216575161236', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-03-02 16:57:48', InvoiceNum = '결제성공:Direct-hanakk-1614671792/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-03-02 16:57:48' ========================2021-03-02 16:57:48======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021030216575161236' 0 = 1 cnt = 1 ========================2021-03-02 16:57:48======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hanakk' 0 = hanakk Mid = hanakk 1 = (주)하나계기 Mcompany = (주)하나계기 2 = 504-81-59526 companyNum = 504-81-59526 3 = 053-254-0101 Mtel1 = 053-254-0101 4 = 010-4934-2791 Mhp = 010-4934-2791 ========================2021-03-02 16:57:48======================== select * from customers where id = 'hanakk' ========================2021-03-02 16:57:48======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hanakk','2021-03-02 16:57:48','108000','110000','온라인','0') ========================2021-03-02 17:44:22======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-foodmall-1614674602 LGD_BUYER = 문현태 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210302174322 LGD_HASHDATA = 2d1c0ba380b74e08c1527dbb0dcbc4ae LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20210302174425B8142EDD72BBF54929C488BC767A37DF57176744 Mname = 문현태 Mcompany = (주)다다통상 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = foodmall LGD_ESCROW_USEYN = N ========================2021-03-02 17:44:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210302174426 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 = 474290******8543 LGD_FINANCEAUTHNUM = 04135866 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 51100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e2606ba542e4e7f9836d80f1d4605c29 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20210302174426 LGD_PCANCELSTR = 0 LGD_BUYER = 문현태 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021030217442661147 LGD_BUYERID = LGD_OID = Direct-foodmall-1614674602 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-03-02 17:44:22======================== insert into mBoard_order set rOrdNo = 'Direct-foodmall-1614674602', AuthTy = 'card', memberId = 'foodmall', OrdNm ='문현태', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)다다통상', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '삼성VISA 474290******8543', rApprNo = 'mjsof2021030217442661147', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-03-02 17:44:22', InvoiceNum = '결제성공:Direct-foodmall-1614674602/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-03-02 17:44:22' ========================2021-03-02 17:44:22======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021030217442661147' 0 = 1 cnt = 1 ========================2021-03-02 17:44:22======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'foodmall' 0 = foodmall Mid = foodmall 1 = (주)다다통상 Mcompany = (주)다다통상 2 = 6058601749 companyNum = 6058601749 3 = 051-701-1901 Mtel1 = 051-701-1901 4 = 010-7167-7871 Mhp = 010-7167-7871 ========================2021-03-02 17:44:22======================== select * from customers where id = 'foodmall' ========================2021-03-02 17:44:22======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('foodmall','2021-03-02 17:44:22','30900','33000','온라인','0')