========================2024-07-31 10:18:45======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ositrade-1722388659 LGD_BUYER = (주)오에스아이무역 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240731101739 LGD_HASHDATA = 427be08753e4cbbe1a943929e9d3e372 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 = 202407311020307E3C257672014413C2F0502A9A6CFCDF1BEDE79C Mname = (주)오에스아이무역 Mcompany = (주)오에스아이무역 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ositrade LGD_ESCROW_USEYN = N ========================2024-07-31 10:18:46======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240731102030 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003332 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****689* LGD_FINANCEAUTHNUM = 30420944 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2622de36eb6c6804b9a8d3e770ad0d66 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240731102031 LGD_PCANCELSTR = 0 LGD_BUYER = (주)오에스아이무역 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240731102030gZX35 LGD_BUYERID = LGD_OID = Direct-ositrade-1722388659 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1102030g2GB9 ========================2024-07-31 10:18:46======================== insert into mBoard_order set rOrdNo = 'Direct-ositrade-1722388659', AuthTy = 'card', memberId = 'ositrade', OrdNm ='(주)오에스아이무역', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)오에스아이무역', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****689*', rApprNo = 'mjsof20240731102030gZX35', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-31 10:18:46', InvoiceNum = '결제성공:Direct-ositrade-1722388659/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-31 10:18:46' ========================2024-07-31 10:18:46======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240731102030gZX35' 0 = 1 cnt = 1 ========================2024-07-31 10:18:46======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ositrade' 0 = ositrade Mid = ositrade 1 = (주)오에스아이무역 Mcompany = (주)오에스아이무역 2 = 206-86-15838 companyNum = 206-86-15838 3 = 031-529-7155 Mtel1 = 031-529-7155 4 = 010-2253-8722 Mhp = 010-2253-8722 ========================2024-07-31 10:18:46======================== select * from customers where id = 'ositrade' ========================2024-07-31 10:18:46======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ositrade','2024-07-31 10:18:46','220000','220000','온라인','0') ========================2024-07-31 15:56:16======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-euungut-1722408903 LGD_BUYER = 임수미 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240731155503 LGD_HASHDATA = 69962ccbaa1841864f6bcdafe057e12f 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 = 2024073115580163B0D3CB7FA886FB7D606E7845D10240F27B354F Mname = 임수미 Mcompany = (주)이찌마루로꾸일공육에이앤 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = euungut LGD_ESCROW_USEYN = N ========================2024-07-31 15:56:17======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240731155802 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003322 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****880* LGD_FINANCEAUTHNUM = 30144836 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b67c758c3db953ad7f3014f6dcd36a8f LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240731155802 LGD_PCANCELSTR = 0 LGD_BUYER = 임수미 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240731155801JRl15 LGD_BUYERID = LGD_OID = Direct-euungut-1722408903 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1155801JkhQ6 ========================2024-07-31 15:56:17======================== insert into mBoard_order set rOrdNo = 'Direct-euungut-1722408903', AuthTy = 'card', memberId = 'euungut', OrdNm ='임수미', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)이찌마루로꾸일공육에이앤', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****880*', rApprNo = 'mjsof20240731155801JRl15', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-31 15:56:17', InvoiceNum = '결제성공:Direct-euungut-1722408903/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-31 15:56:17' ========================2024-07-31 15:56:17======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240731155801JRl15' 0 = 1 cnt = 1 ========================2024-07-31 15:56:17======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'euungut' 0 = euungut Mid = euungut 1 = (주)이찌마루로꾸일공육에이앤 Mcompany = (주)이찌마루로꾸일공육에이앤 2 = 211-88-77785 companyNum = 211-88-77785 3 = 02-3445-0813 Mtel1 = 02-3445-0813 4 = 010-7122-3588 Mhp = 010-7122-3588 ========================2024-07-31 15:56:17======================== select * from customers where id = 'euungut' ========================2024-07-31 15:56:17======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('euungut','2024-07-31 15:56:17','108000','110000','온라인','0') ========================2024-07-31 15:58:23======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-cm8904-1722408864 LGD_BUYER = 석대환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240731155424 LGD_HASHDATA = 7c5e145246d414e93380da7ab734f8bf 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 = 202407311600085CA2C57D564E4D61F45F113C6FFF463B175744B8 Mname = 석대환 Mcompany = 대흥테크 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = cm8904 LGD_ESCROW_USEYN = N ========================2024-07-31 15:58:24======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240731160008 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = sdw8904@gmail.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = BAAAES LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42201500****713* LGD_FINANCEAUTHNUM = 32963868 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 01949fe7d1766cd5e01b7dc4735e8204 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240731160009 LGD_PCANCELSTR = 0 LGD_BUYER = 석대환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240731160008U9OG8 LGD_BUYERID = LGD_OID = Direct-cm8904-1722408864 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-07-31 15:58:24======================== insert into mBoard_order set rOrdNo = 'Direct-cm8904-1722408864', AuthTy = 'card', memberId = 'cm8904', OrdNm ='석대환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대흥테크', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '신한VISA 42201500****713*', rApprNo = 'mjsof20240731160008U9OG8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-31 15:58:24', InvoiceNum = '결제성공:Direct-cm8904-1722408864/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-31 15:58:24' ========================2024-07-31 15:58:24======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240731160008U9OG8' 0 = 1 cnt = 1 ========================2024-07-31 15:58:24======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'cm8904' 0 = cm8904 Mid = cm8904 1 = 대흥테크 Mcompany = 대흥테크 2 = 1140251817 companyNum = 1140251817 3 = 02-596-8904 Mtel1 = 02-596-8904 4 = 010-5340-4987 Mhp = 010-5340-4987 ========================2024-07-31 15:58:24======================== select * from customers where id = 'cm8904' ========================2024-07-31 15:58:24======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('cm8904','2024-07-31 15:58:24','10000','11000','온라인','0') ========================2024-07-31 17:13:57======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sunmro-1722413605 LGD_BUYER = 강찬수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240731171325 LGD_HASHDATA = 2f5c9156be23079378bd02f9528ecaed 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 = 20240731171541414F207E00FE1D7BB9D74024D0C9D457FAD74203 Mname = 강찬수 Mcompany = (주)태양엠알오 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = sunmro LGD_ESCROW_USEYN = N ========================2024-07-31 17:13:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240731171542 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 834865 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55892098****244* LGD_FINANCEAUTHNUM = 40972251 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 0e7227c8f2db5b2d9ada856abd22a882 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240731171542 LGD_PCANCELSTR = 0 LGD_BUYER = 강찬수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240731171542Ki4z5 LGD_BUYERID = LGD_OID = Direct-sunmro-1722413605 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1171542Kluj3 ========================2024-07-31 17:13:57======================== insert into mBoard_order set rOrdNo = 'Direct-sunmro-1722413605', AuthTy = 'card', memberId = 'sunmro', OrdNm ='강찬수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)태양엠알오', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리비씨MASTER 55892098****244*', rApprNo = 'mjsof20240731171542Ki4z5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-31 17:13:57', InvoiceNum = '결제성공:Direct-sunmro-1722413605/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-31 17:13:57' ========================2024-07-31 17:13:58======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240731171542Ki4z5' 0 = 1 cnt = 1 ========================2024-07-31 17:13:58======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sunmro' 0 = sunmro Mid = sunmro 1 = (주)태양엠알오 Mcompany = (주)태양엠알오 2 = 262-81-00306 companyNum = 262-81-00306 3 = 02-1899-0942 Mtel1 = 02-1899-0942 4 = 010-5482-0951 Mhp = 010-5482-0951 ========================2024-07-31 17:13:58======================== select * from customers where id = 'sunmro' ========================2024-07-31 17:13:58======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sunmro','2024-07-31 17:13:57','220000','220000','온라인','0') ========================2024-07-31 18:20:31======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woo602r-1722417495 LGD_BUYER = 김재우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240731181815 LGD_HASHDATA = 5e2c21e8170aba459f57b49377f4da32 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 = 20240731182216B7976D57F3F173843FF544D88E5AF643FD7364B0 Mname = 김재우 Mcompany = 서울치즈울산동부가공고객센타 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = woo602r LGD_ESCROW_USEYN = N ========================2024-07-31 18:20:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240731182217 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 = 54611120****500* LGD_FINANCEAUTHNUM = 57453458 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 91200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 410784ee36966015577bff131588021d LGD_BUYERADDRESS = LGD_FINANCENAME = NH MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240731182218 LGD_PCANCELSTR = 0 LGD_BUYER = 김재우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240731182216NaWL3 LGD_BUYERID = LGD_OID = Direct-woo602r-1722417495 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-07-31 18:20:33======================== insert into mBoard_order set rOrdNo = 'Direct-woo602r-1722417495', AuthTy = 'card', memberId = 'woo602r', OrdNm ='김재우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '서울치즈울산동부가공고객센타', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = 'NH MASTER 54611120****500*', rApprNo = 'mjsof20240731182216NaWL3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-31 18:20:33', InvoiceNum = '결제성공:Direct-woo602r-1722417495/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-31 18:20:33' ========================2024-07-31 18:20:33======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240731182216NaWL3' 0 = 1 cnt = 1 ========================2024-07-31 18:20:33======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woo602r' 0 = woo602r Mid = woo602r 1 = 서울치즈울산동부가공고객센타 Mcompany = 서울치즈울산동부가공고객센타 2 = 620-10-47661 companyNum = 620-10-47661 3 = 052-257-3287 Mtel1 = 052-257-3287 4 = 010-4057-3287 Mhp = 010-4057-3287 ========================2024-07-31 18:20:33======================== select * from customers where id = 'woo602r' ========================2024-07-31 18:20:33======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woo602r','2024-07-31 18:20:33','30900','33000','온라인','0') ========================2024-07-31 19:41:59======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-roastercow-1722422052 LGD_BUYER = 민경언 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240731193412 LGD_HASHDATA = 1405edf9233d21d8aeec6d5c1e9b07ee 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 = 20240731194343AB7C92DE869512FE3F166E21E3F728DD951C19FC Mname = 민경언 Mcompany = 매일우유 이태원 대리점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = roastercow LGD_ESCROW_USEYN = N ========================2024-07-31 19:41:59======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240731194344 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = mke0927@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = AFA00A LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 35629746****013* LGD_FINANCEAUTHNUM = 36261687 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41300 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 36d4fc308e6ba572d21a0428e8dddcfb LGD_BUYERADDRESS = LGD_FINANCENAME = 신한JCB LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240731194344 LGD_PCANCELSTR = 0 LGD_BUYER = 민경언 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240731194344Ix671 LGD_BUYERID = LGD_OID = Direct-roastercow-1722422052 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-07-31 19:41:59======================== insert into mBoard_order set rOrdNo = 'Direct-roastercow-1722422052', AuthTy = 'card', memberId = 'roastercow', OrdNm ='민경언', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '매일우유 이태원 대리점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한JCB 35629746****013*', rApprNo = 'mjsof20240731194344Ix671', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-31 19:41:59', InvoiceNum = '결제성공:Direct-roastercow-1722422052/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-31 19:41:59' ========================2024-07-31 19:42:00======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240731194344Ix671' 0 = 1 cnt = 1 ========================2024-07-31 19:42:00======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'roastercow' 0 = roastercow Mid = roastercow 1 = 매일우유 이태원 대리점 Mcompany = 매일우유 이태원 대리점 2 = 8040201730 companyNum = 8040201730 3 = 010-6234-0927 Mtel1 = 010-6234-0927 4 = 010-6234-0927 Mhp = 010-6234-0927 ========================2024-07-31 19:42:00======================== select * from customers where id = 'roastercow' ========================2024-07-31 19:42:00======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('roastercow','2024-07-31 19:41:59','220000','220000','온라인','0')