========================2021-01-08 11:34:31======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dongnam4051-1610073246 LGD_BUYER = 이정훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210108113406 LGD_HASHDATA = acc27e8707529014cfba12b1feea8c9a 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 = 2021010811343886DBB8A6D064C94C9DAC71F4825B18F3D389325D Mname = 이정훈 Mcompany = 동남상회 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = dongnam4051 LGD_ESCROW_USEYN = N ========================2021-01-08 11:34:31======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210108113438 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 = 457493******4205 LGD_FINANCEAUTHNUM = 00102146 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6bc7c6026b45aa94cd7f9d53bf8e1ec1 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210108113438 LGD_PCANCELSTR = 0 LGD_BUYER = 이정훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021010811343861028 LGD_BUYERID = LGD_OID = Direct-dongnam4051-1610073246 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-01-08 11:34:31======================== insert into mBoard_order set rOrdNo = 'Direct-dongnam4051-1610073246', AuthTy = 'card', memberId = 'dongnam4051', OrdNm ='이정훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '동남상회', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '현대VISA 457493******4205', rApprNo = 'mjsof2021010811343861028', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-08 11:34:31', InvoiceNum = '결제성공:Direct-dongnam4051-1610073246/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-08 11:34:31' ========================2021-01-08 11:34:31======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021010811343861028' 0 = 1 cnt = 1 ========================2021-01-08 11:34:31======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dongnam4051' 0 = dongnam4051 Mid = dongnam4051 1 = 동남상회 Mcompany = 동남상회 2 = 3053766242 companyNum = 3053766242 3 = 010-2019-7470 Mtel1 = 010-2019-7470 4 = 010-2019-7470 Mhp = 010-2019-7470 ========================2021-01-08 11:34:31======================== select * from customers where id = 'dongnam4051' ========================2021-01-08 11:34:31======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dongnam4051','2021-01-08 11:34:31','10000','11000','온라인','0') ========================2021-01-08 13:58:30======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kds1-1610081865 LGD_BUYER = 오정호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210108135745 LGD_HASHDATA = df7edc217029519af0d705ef703f48de 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 = 20210108135836785128DDBBC47C8D04CB53E4D2BD8F857119813B 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 ========================2021-01-08 13:58:30======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210108135837 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 000000 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******9822 LGD_FINANCEAUTHNUM = 30108453 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 85a3d0555f339cf80425c095f8c0e661 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210108135837 LGD_PCANCELSTR = 0 LGD_BUYER = 오정호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021010813583761265 LGD_BUYERID = LGD_OID = Direct-kds1-1610081865 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 813583761255 ========================2021-01-08 13:58:30======================== insert into mBoard_order set rOrdNo = 'Direct-kds1-1610081865', AuthTy = 'card', memberId = 'kds1', OrdNm ='오정호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '메인로드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 558526******9822', rApprNo = 'mjsof2021010813583761265', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-08 13:58:30', InvoiceNum = '결제성공:Direct-kds1-1610081865/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-08 13:58:30' ========================2021-01-08 13:58:30======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021010813583761265' 0 = 1 cnt = 1 ========================2021-01-08 13:58:30======================== 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 ========================2021-01-08 13:58:30======================== select * from customers where id = 'kds1' ========================2021-01-08 13:58:30======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kds1','2021-01-08 13:58:30','52500','55000','온라인','0') ========================2021-01-08 14:04:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woorimart-1610082208 LGD_BUYER = 유봉천 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210108140328 LGD_HASHDATA = 64e20faac1ed898d213dddc8648d0089 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 = 20210108140420BE13DD897522099D76AE9278E9DCF299563B4670 Mname = 유봉천 Mcompany = (주)우리유통식자재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = woorimart LGD_ESCROW_USEYN = N ========================2021-01-08 14:04:14======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210108140420 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = 393487 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 538839******4647 LGD_FINANCEAUTHNUM = 30742903 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9bc612d89587bb915fc06531b9d4ec3f LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210108140421 LGD_PCANCELSTR = 0 LGD_BUYER = 유봉천 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021010814042014271 LGD_BUYERID = LGD_OID = Direct-woorimart-1610082208 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 814042014299 ========================2021-01-08 14:04:14======================== insert into mBoard_order set rOrdNo = 'Direct-woorimart-1610082208', AuthTy = 'card', memberId = 'woorimart', OrdNm ='유봉천', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)우리유통식자재', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨MASTER 538839******4647', rApprNo = 'mjsof2021010814042014271', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-08 14:04:14', InvoiceNum = '결제성공:Direct-woorimart-1610082208/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-08 14:04:14' ========================2021-01-08 14:04:14======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021010814042014271' 0 = 1 cnt = 1 ========================2021-01-08 14:04:14======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woorimart' 0 = woorimart Mid = woorimart 1 = (주)우리유통식자재 Mcompany = (주)우리유통식자재 2 = 609-85-27254 companyNum = 609-85-27254 3 = 055-541-6100 Mtel1 = 055-541-6100 4 = 016-594-7327 Mhp = 016-594-7327 ========================2021-01-08 14:04:14======================== select * from customers where id = 'woorimart' ========================2021-01-08 14:04:14======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woorimart','2021-01-08 14:04:14','220000','220000','온라인','0') ========================2021-01-08 14:21:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sali-1610083228 LGD_BUYER = 유재일 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210108142028 LGD_HASHDATA = 1c78c330c2228f8eb6d50e549a77e5b1 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 = 20210108142132F184151EACBCD8995FE3CD490BCFF56F8B33D8DE Mname = 유재일 Mcompany = 참살이 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = sali LGD_ESCROW_USEYN = N ========================2021-01-08 14:21:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210108142133 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 755339 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558503******7995 LGD_FINANCEAUTHNUM = 31148296 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 93071ceb6bd1ab3608364f6b7cb4fbc0 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210108142133 LGD_PCANCELSTR = 0 LGD_BUYER = 유재일 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021010814213260104 LGD_BUYERID = LGD_OID = Direct-sali-1610083228 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 814213260121 ========================2021-01-08 14:21:26======================== insert into mBoard_order set rOrdNo = 'Direct-sali-1610083228', AuthTy = 'card', memberId = 'sali', OrdNm ='유재일', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '참살이', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '비씨MASTER 558503******7995', rApprNo = 'mjsof2021010814213260104', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-08 14:21:26', InvoiceNum = '결제성공:Direct-sali-1610083228/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-08 14:21:26' ========================2021-01-08 14:21:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021010814213260104' 0 = 1 cnt = 1 ========================2021-01-08 14:21:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sali' 0 = sali Mid = sali 1 = 참살이 Mcompany = 참살이 2 = 138-98-05549 companyNum = 138-98-05549 3 = 070-4632-3188 Mtel1 = 070-4632-3188 4 = 010-3137-3188 Mhp = 010-3137-3188 ========================2021-01-08 14:21:26======================== select * from customers where id = 'sali' ========================2021-01-08 14:21:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sali','2021-01-08 14:21:26','30900','33000','온라인','0') ========================2021-01-08 19:55:14======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tjdwo-1610103205 LGD_BUYER = 장성재 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210108195325 LGD_HASHDATA = 61afd93816082522040d327d207e0e6c 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 = 20210108195521FE7B015915E1E3386F4C928CF2AE65C4B17D5894 Mname = 장성재 Mcompany = 철인유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = tjdwo LGD_ESCROW_USEYN = N ========================2021-01-08 19:55:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210108195522 LGD_BUYEREMAIL = dbs988@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0030 LGD_PAYNOW_TRANTYPE = LGD_RECEIVERPHONE = LGD_IFOS = 376ICC LGD_CASHRECEIPTKIND = 1 LGD_RESPMSG = 결제 성공 LGD_2TR_FLAG = Y LGD_ESCROWYN = N LGD_FINANCECODE = 011 LGD_CASHRECEIPTCODE = 0000 LGD_HASHDATA = 396c06d965099df9bc928b5f1ed53a36 LGD_BUYERADDRESS = LGD_CASHRECEIPTSELFYN = N LGD_FINANCENAME = 농협 LGD_DEVICE = LGD_TIMESTAMP = 20210108195522 LGD_BUYER = 장성재 LGD_CASHRECEIPTNUM = 159680702 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = . LGD_PRODUCTCODE = LGD_TID = mjsof2021010819552131160 LGD_BUYERID = LGD_OID = Direct-tjdwo-1610103205 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_ACCOUNTOWNER = 윤상혁 LGD_MID = mjsoft007 ========================2021-01-08 19:55:15======================== insert into mBoard_order set rOrdNo = 'Direct-tjdwo-1610103205', AuthTy = 'iche', memberId = 'tjdwo', OrdNm ='장성재', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '철인유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '농협 ', rApprNo = 'mjsof2021010819552131160', ICHE_OUTBANKNAME = '159680702/N/지출증빙', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '윤상혁', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-08 19:55:15', InvoiceNum = '결제 성공:Direct-tjdwo-1610103205/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-08 19:55:15' ========================2021-01-08 19:55:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021010819552131160' 0 = 1 cnt = 1 ========================2021-01-08 19:55:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'tjdwo' 0 = tjdwo Mid = tjdwo 1 = 철인유통 Mcompany = 철인유통 2 = 613-12-19818 companyNum = 613-12-19818 3 = 051-941-9113 Mtel1 = 051-941-9113 4 = 010-8477-0149 Mhp = 010-8477-0149 ========================2021-01-08 19:55:15======================== select * from customers where id = 'tjdwo' ========================2021-01-08 19:55:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('tjdwo','2021-01-08 19:55:15','52500','55000','온라인','0')