========================2022-05-09 09:39:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-cham-1652056595 LGD_BUYER = 이창국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220509093635 LGD_HASHDATA = 29cf892647714152b1413c5038f4f861 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20220509093932F45CC7CDB5B64B349AD57D61F4D1313AUDP6UZUE Mname = 이창국 Mcompany = 농업회사법인참살이주식회사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = cham LGD_ESCROW_USEYN = N ========================2022-05-09 09:39:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220509093933 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******5943 LGD_FINANCEAUTHNUM = 53895621 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 76615816c24c88c13d8b31fb23a4537b LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220509093934 LGD_PCANCELSTR = 0 LGD_BUYER = 이창국 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220509093933Q9Lj9 LGD_BUYERID = LGD_OID = Direct-cham-1652056595 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 9093933QwTz3 ========================2022-05-09 09:39:20======================== insert into mBoard_order set rOrdNo = 'Direct-cham-1652056595', AuthTy = 'card', memberId = 'cham', OrdNm ='이창국', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '농업회사법인참살이주식회사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '비씨MASTER 558503******5943', rApprNo = 'mjsof20220509093933Q9Lj9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-05-09 09:39:20', InvoiceNum = '결제성공:Direct-cham-1652056595/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-05-09 09:39:20' ========================2022-05-09 09:39:20======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220509093933Q9Lj9' 0 = 1 cnt = 1 ========================2022-05-09 09:39:20======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'cham' 0 = cham Mid = cham 1 = 농업회사법인참살이주식회사 Mcompany = 농업회사법인참살이주식회사 2 = 1268653458 companyNum = 1268653458 3 = 031-462-8333 Mtel1 = 031-462-8333 4 = 010-8755-8842 Mhp = 010-8755-8842 ========================2022-05-09 09:39:20======================== select * from customers where id = 'cham' ========================2022-05-09 09:39:20======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('cham','2022-05-09 09:39:20','30900','33000','온라인','0') ========================2022-05-09 10:11:08======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woorimart-1652058590 LGD_BUYER = 유봉천 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220509100950 LGD_HASHDATA = 02f7dc30c6c3c54cb2b89d76476dc0ad LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20220509101121F715911AAD9E49679D5F1A2C3A216473N8OZG0ND 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 ========================2022-05-09 10:11:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220509101122 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 414011******2040 LGD_FINANCEAUTHNUM = 54110382 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = dc5954d03605119659e241a600c5f8c1 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220509101122 LGD_PCANCELSTR = 0 LGD_BUYER = 유봉천 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220509101121YyDD3 LGD_BUYERID = LGD_OID = Direct-woorimart-1652058590 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 9101121YasT1 ========================2022-05-09 10:11:09======================== insert into mBoard_order set rOrdNo = 'Direct-woorimart-1652058590', AuthTy = 'card', memberId = 'woorimart', OrdNm ='유봉천', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)우리유통식자재', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 414011******2040', rApprNo = 'mjsof20220509101121YyDD3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-05-09 10:11:09', InvoiceNum = '결제성공:Direct-woorimart-1652058590/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-05-09 10:11:09' ========================2022-05-09 10:11:09======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220509101121YyDD3' 0 = 1 cnt = 1 ========================2022-05-09 10:11:09======================== 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 ========================2022-05-09 10:11:09======================== select * from customers where id = 'woorimart' ========================2022-05-09 10:11:09======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woorimart','2022-05-09 10:11:09','220000','220000','온라인','0') ========================2022-05-09 10:38:37======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-chparkg-1652060137 LGD_BUYER = 박춘화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220509103537 LGD_HASHDATA = 87df3df21c45f437073b34b8f0d69163 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2022050910385126F56846494A41CCB93C408F75BF2A01F3PR1LI1 Mname = 박춘화 Mcompany = 주식회사 동보 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = chparkg LGD_ESCROW_USEYN = N ========================2022-05-09 10:38:38======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220509103851 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 = 943017******0893 LGD_FINANCEAUTHNUM = 47551868 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7c8ad08aa8d36a8c4062dd72add7070b LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20220509103852 LGD_PCANCELSTR = 0 LGD_BUYER = 박춘화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220509103851YzNl9 LGD_BUYERID = LGD_OID = Direct-chparkg-1652060137 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-05-09 10:38:38======================== insert into mBoard_order set rOrdNo = 'Direct-chparkg-1652060137', AuthTy = 'card', memberId = 'chparkg', OrdNm ='박춘화', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 동보', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH 943017******0893', rApprNo = 'mjsof20220509103851YzNl9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-05-09 10:38:38', InvoiceNum = '결제성공:Direct-chparkg-1652060137/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-05-09 10:38:38' ========================2022-05-09 10:38:38======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220509103851YzNl9' 0 = 1 cnt = 1 ========================2022-05-09 10:38:38======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'chparkg' 0 = chparkg Mid = chparkg 1 = 주식회사 동보 Mcompany = 주식회사 동보 2 = 721-88-00857 companyNum = 721-88-00857 3 = 054-859-3315 Mtel1 = 054-859-3315 4 = 010-8004-3304 Mhp = 010-8004-3304 ========================2022-05-09 10:38:38======================== select * from customers where id = 'chparkg' ========================2022-05-09 10:38:38======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('chparkg','2022-05-09 10:38:38','108000','110000','온라인','0') ========================2022-05-09 13:40:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pro5500-1652071169 LGD_BUYER = 최원철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220509133929 LGD_HASHDATA = 5693bcfe2dafbfa123f698d49bc5815d LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202205091340400CFF21BC25014305883F18678285887EZEXO8U7D Mname = 최원철 Mcompany = 대원화장품 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = pro5500 LGD_ESCROW_USEYN = N ========================2022-05-09 13:40:28======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220509134041 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 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 = 558420******0281 LGD_FINANCEAUTHNUM = 55591505 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b84f4b0c4d4030706735fa9cf02c87b8 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220509134041 LGD_PCANCELSTR = 0 LGD_BUYER = 최원철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202205091340418FZ17 LGD_BUYERID = LGD_OID = Direct-pro5500-1652071169 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 913404189ni0 ========================2022-05-09 13:40:28======================== insert into mBoard_order set rOrdNo = 'Direct-pro5500-1652071169', AuthTy = 'card', memberId = 'pro5500', OrdNm ='최원철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대원화장품', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '우리MASTER 558420******0281', rApprNo = 'mjsof202205091340418FZ17', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-05-09 13:40:28', InvoiceNum = '결제성공:Direct-pro5500-1652071169/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-05-09 13:40:28' ========================2022-05-09 13:40:28======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202205091340418FZ17' 0 = 1 cnt = 1 ========================2022-05-09 13:40:28======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'pro5500' 0 = pro5500 Mid = pro5500 1 = 대원화장품 Mcompany = 대원화장품 2 = 106-08-30787 companyNum = 106-08-30787 3 = 02-3272-5500 Mtel1 = 02-3272-5500 4 = 010-2054-4385 Mhp = 010-2054-4385 ========================2022-05-09 13:40:28======================== select * from customers where id = 'pro5500' ========================2022-05-09 13:40:28======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('pro5500','2022-05-09 13:40:28','10000','11000','온라인','0') ========================2022-05-09 14:09:24======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-max4971-1652072845 LGD_BUYER = 배현경 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220509140725 LGD_HASHDATA = 18850862b5ecf46044f7fcbe063ecd67 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202205091409372A9CCFEE71E94185809367C53BC49022NZ1YPEPP Mname = 배현경 Mcompany = 카페지니플라넷 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = max4971 LGD_ESCROW_USEYN = N ========================2022-05-09 14:09:24======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220509140938 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 = 625320******5202 LGD_FINANCEAUTHNUM = 56192814 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 33800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7bbc8651bd03858ae0a3d6ecb7364567 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220509140938 LGD_PCANCELSTR = 0 LGD_BUYER = 배현경 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220509140938ezxl7 LGD_BUYERID = LGD_OID = Direct-max4971-1652072845 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-05-09 14:09:24======================== insert into mBoard_order set rOrdNo = 'Direct-max4971-1652072845', AuthTy = 'card', memberId = 'max4971', OrdNm ='배현경', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '카페지니플라넷', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '우리CUP 625320******5202', rApprNo = 'mjsof20220509140938ezxl7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-05-09 14:09:24', InvoiceNum = '결제성공:Direct-max4971-1652072845/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-05-09 14:09:24' ========================2022-05-09 14:09:25======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220509140938ezxl7' 0 = 1 cnt = 1 ========================2022-05-09 14:09:25======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'max4971' 0 = max4971 Mid = max4971 1 = 카페지니플라넷 Mcompany = 카페지니플라넷 2 = 5521800433 companyNum = 5521800433 3 = 010-6489-8544 Mtel1 = 010-6489-8544 4 = 010-2490-8544 Mhp = 010-2490-8544 ========================2022-05-09 14:09:25======================== select * from customers where id = 'max4971' ========================2022-05-09 14:09:25======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('max4971','2022-05-09 14:09:24','52500','55000','온라인','0') ========================2022-05-09 14:38:44======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kjchemi-1652073468 LGD_BUYER = 여기만 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220509141748 LGD_HASHDATA = 90c9f5f035cb1f1bab112d46bc63b6a0 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2022050914385735B720B41BFE4EBD9CCAEBAA495E9635IUSOCGTB Mname = 여기만 Mcompany = (주)광주케미렌즈 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = kjchemi LGD_ESCROW_USEYN = N ========================2022-05-09 14:38:45======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220509143858 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = 005005 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 459952******5669 LGD_FINANCEAUTHNUM = 56395315 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 46100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 281453270e2737ce8fd2cbf8dc81f9d3 LGD_BUYERADDRESS = LGD_FINANCENAME = 광주VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220509143859 LGD_PCANCELSTR = 0 LGD_BUYER = 여기만 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof20220509143858avaM2 LGD_BUYERID = LGD_OID = Direct-kjchemi-1652073468 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 091438224017 ========================2022-05-09 14:38:45======================== insert into mBoard_order set rOrdNo = 'Direct-kjchemi-1652073468', AuthTy = 'card', memberId = 'kjchemi', OrdNm ='여기만', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)광주케미렌즈', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '광주VISA 459952******5669', rApprNo = 'mjsof20220509143858avaM2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-05-09 14:38:45', InvoiceNum = '결제성공:Direct-kjchemi-1652073468/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-05-09 14:38:45' ========================2022-05-09 14:38:45======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220509143858avaM2' 0 = 1 cnt = 1 ========================2022-05-09 14:38:45======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kjchemi' 0 = kjchemi Mid = kjchemi 1 = (주)광주케미렌즈 Mcompany = (주)광주케미렌즈 2 = 408-81-78962 companyNum = 408-81-78962 3 = 062-224-9339 Mtel1 = 062-224-9339 4 = 011-622-8419 Mhp = 011-622-8419 ========================2022-05-09 14:38:45======================== select * from customers where id = 'kjchemi' ========================2022-05-09 14:38:45======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kjchemi','2022-05-09 14:38:45','108000','110000','온라인','0') ========================2022-05-09 15:54:12======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dream1admin-1652079209 LGD_BUYER = 김영석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220509155329 LGD_HASHDATA = beb8d4875baf8ef898f07b23609bc61f LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20220509155426941DB1647C044DAB9CF6EE3D667BB9F9LXJICUMJ Mname = 김영석 Mcompany = 드림엠앤에스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = dream1admin LGD_ESCROW_USEYN = N ========================2022-05-09 15:54:13======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220509155426 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = CAC626 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 490298******8636 LGD_FINANCEAUTHNUM = 22619554 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9ccfee15710d13f0c9e73585e4da6c89 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20220509155427 LGD_PCANCELSTR = 0 LGD_BUYER = 김영석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202205091554268KPp1 LGD_BUYERID = LGD_OID = Direct-dream1admin-1652079209 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-05-09 15:54:13======================== insert into mBoard_order set rOrdNo = 'Direct-dream1admin-1652079209', AuthTy = 'card', memberId = 'dream1admin', OrdNm ='김영석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '드림엠앤에스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한VISA 490298******8636', rApprNo = 'mjsof202205091554268KPp1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-05-09 15:54:13', InvoiceNum = '결제성공:Direct-dream1admin-1652079209/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-05-09 15:54:13' ========================2022-05-09 15:54:13======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202205091554268KPp1' 0 = 1 cnt = 1 ========================2022-05-09 15:54:13======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dream1admin' 0 = dream1admin Mid = dream1admin 1 = 드림엠앤에스 Mcompany = 드림엠앤에스 2 = 2638100288 companyNum = 2638100288 3 = 010-9095-8778 Mtel1 = 010-9095-8778 4 = 010-8814-6666 Mhp = 010-8814-6666 ========================2022-05-09 15:54:13======================== select * from customers where id = 'dream1admin' ========================2022-05-09 15:54:13======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dream1admin','2022-05-09 15:54:13','108000','110000','온라인','0') ========================2022-05-09 19:37:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nosqr9583-1652092576 LGD_BUYER = 김창민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220509193616 LGD_HASHDATA = af8c9b1219d9c254f6e8325ee55b6a6e LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20220509193733F36B3E1A78304012BE07A0F33820A6A4FK5DMX3L Mname = 김창민 Mcompany = 앤오스퀘어(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = nosqr9583 LGD_ESCROW_USEYN = N ========================2022-05-09 19:37:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220509193733 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 = 467008******6022 LGD_FINANCEAUTHNUM = 35187873 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 71100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 35315829e4667f7d0c54a4309aa36621 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20220509193734 LGD_PCANCELSTR = 0 LGD_BUYER = 김창민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220509193733UWQw8 LGD_BUYERID = LGD_OID = Direct-nosqr9583-1652092576 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-05-09 19:37:20======================== insert into mBoard_order set rOrdNo = 'Direct-nosqr9583-1652092576', AuthTy = 'card', memberId = 'nosqr9583', OrdNm ='김창민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '앤오스퀘어(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '롯데VISA 467008******6022', rApprNo = 'mjsof20220509193733UWQw8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-05-09 19:37:20', InvoiceNum = '결제성공:Direct-nosqr9583-1652092576/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-05-09 19:37:20' ========================2022-05-09 19:37:20======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220509193733UWQw8' 0 = 1 cnt = 1 ========================2022-05-09 19:37:20======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nosqr9583' 0 = nosqr9583 Mid = nosqr9583 1 = 앤오스퀘어(주) Mcompany = 앤오스퀘어(주) 2 = 7258800733 companyNum = 7258800733 3 = 010-3199-5304 Mtel1 = 010-3199-5304 4 = 010-3199-5304 Mhp = 010-3199-5304 ========================2022-05-09 19:37:20======================== select * from customers where id = 'nosqr9583' ========================2022-05-09 19:37:20======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nosqr9583','2022-05-09 19:37:20','52500','55000','온라인','0')