========================2022-01-03 00:38:20======================== res_start ========================2022-01-03 00:38:20======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID Çʵ尡 ´©¶ôµÇ¾ú½À´Ï´Ù. Init_TX(LGD_MID)¸¦ ÇØÁֽñ⠹ٶø´Ï´Ù. ¶Ç´Â mall.conf ¿¡ »óÁ¡Å°°¡ ¼ÂÆÃµÇ¾î ÀÖÁö ¾Ê½À´Ï´Ù. ========================2022-01-03 09:04:57======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jjss5009-1641168192 LGD_BUYER = ÇѸíÈ­ LGD_PRODUCTINFO = [¹Ù·Î°áÁ¦] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220103090312 LGD_HASHDATA = 61d6d8eafb986c29c2f54a6d1c25b6a2 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 = 202201030908430DC65ED3EC6542319A7586834AEBD03FNPHXLOAG Mname = ÇѸíÈ­ Mcompany = ÁÖ½Äȸ»çÁ¦À̾ؿ¡½ºÆÑ post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = jjss5009 LGD_ESCROW_USEYN = N ========================2022-01-03 09:04:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220103090843 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 = 553142******7202 LGD_FINANCEAUTHNUM = 00810781 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 02e7d4a7606d4009af148b893a428f9e LGD_BUYERADDRESS = LGD_FINANCENAME = Çö´ëMASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20220103090844 LGD_PCANCELSTR = 0 LGD_BUYER = ÇѸíÈ­ LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [¹Ù·Î°áÁ¦] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202201030908430SYg2 LGD_BUYERID = LGD_OID = Direct-jjss5009-1641168192 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-01-03 09:04:57======================== insert into mBoard_order set rOrdNo = 'Direct-jjss5009-1641168192', AuthTy = 'card', memberId = 'jjss5009', OrdNm ='ÇѸíÈ­', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = 'ÁÖ½Äȸ»çÁ¦À̾ؿ¡½ºÆÑ', ProductCode = 'point', rProdNm = '[Æ÷ÀÎÆ®ÃæÀü]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = 'Çö´ëMASTER 553142******7202', rApprNo = 'mjsof202201030908430SYg2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-01-03 09:04:57', InvoiceNum = '°áÁ¦¼º°ø:Direct-jjss5009-1641168192/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-01-03 09:04:57' ========================2022-01-03 09:04:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202201030908430SYg2' 0 = 1 cnt = 1 ========================2022-01-03 09:04:57======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jjss5009' 0 = jjss5009 Mid = jjss5009 1 = ÁÖ½Äȸ»çÁ¦À̾ؿ¡½ºÆÑ Mcompany = ÁÖ½Äȸ»çÁ¦À̾ؿ¡½ºÆÑ 2 = 5718701889 companyNum = 5718701889 3 = 043-224-7982 Mtel1 = 043-224-7982 4 = 010-4243-6887 Mhp = 010-4243-6887 ========================2022-01-03 09:04:57======================== select * from customers where id = 'jjss5009' ========================2022-01-03 09:04:58======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jjss5009','2022-01-03 09:04:57','30900','33000','¿Â¶óÀÎ','0') ========================2022-01-03 09:11:41======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yasri1-1641168573 LGD_BUYER = ±èº´±¹ LGD_PRODUCTINFO = [¹Ù·Î°áÁ¦] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220103090933 LGD_HASHDATA = eafcada9a887c07223e4d73257034009 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 = 202201030915275FD6060CB9544EDC9C6B1A0EFA0BCD32TG42A5MI Mname = ±èº´±¹ Mcompany = Çѱ¹½Äǰ post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = yasri1 LGD_ESCROW_USEYN = N ========================2022-01-03 09:11:41======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220103091527 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 = 433028******5152 LGD_FINANCEAUTHNUM = 00192399 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 607c8d865bdd92758519889e6b8f0391 LGD_BUYERADDRESS = LGD_FINANCENAME = Çö´ëVISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20220103091528 LGD_PCANCELSTR = 0 LGD_BUYER = ±èº´±¹ LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [¹Ù·Î°áÁ¦] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220103091527Qh2l3 LGD_BUYERID = LGD_OID = Direct-yasri1-1641168573 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-01-03 09:11:41======================== insert into mBoard_order set rOrdNo = 'Direct-yasri1-1641168573', AuthTy = 'card', memberId = 'yasri1', OrdNm ='±èº´±¹', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = 'Çѱ¹½Äǰ', ProductCode = 'point', rProdNm = '[Æ÷ÀÎÆ®ÃæÀü]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'Çö´ëVISA 433028******5152', rApprNo = 'mjsof20220103091527Qh2l3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-01-03 09:11:41', InvoiceNum = '°áÁ¦¼º°ø:Direct-yasri1-1641168573/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-01-03 09:11:41' ========================2022-01-03 09:11:41======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220103091527Qh2l3' 0 = 1 cnt = 1 ========================2022-01-03 09:11:41======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'yasri1' 0 = yasri1 Mid = yasri1 1 = Çѱ¹½Äǰ Mcompany = Çѱ¹½Äǰ 2 = 3080764474 companyNum = 3080764474 3 = 010-8907-5013 Mtel1 = 010-8907-5013 4 = 010-8626-8706 Mhp = 010-8626-8706 ========================2022-01-03 09:11:41======================== select * from customers where id = 'yasri1' ========================2022-01-03 09:11:41======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yasri1','2022-01-03 09:11:41','220000','220000','¿Â¶óÀÎ','0') ========================2022-01-03 09:54:41======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sunmro-1641171236 LGD_BUYER = °­Âù¼ö LGD_PRODUCTINFO = [¹Ù·Î°áÁ¦] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220103095356 LGD_HASHDATA = 4647dbbc25cd4ed01e1c488f69498e38 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 = 20220103095828D8A2139862F84709A352D79B8F85B11ELAPIGOIU 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 ========================2022-01-03 09:54:42======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220103095828 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 834865 LGD_RESPMSG = °áÁ¦¼º°ø LGD_2TR_FLAG = Y LGD_CARDNUM = 558920******2440 LGD_FINANCEAUTHNUM = 44410857 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 96b8f4214651c179cb19407e9cfa9991 LGD_BUYERADDRESS = LGD_FINANCENAME = ¿ì¸®MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220103095828 LGD_PCANCELSTR = 0 LGD_BUYER = °­Âù¼ö LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [¹Ù·Î°áÁ¦] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220103095828QisA4 LGD_BUYERID = LGD_OID = Direct-sunmro-1641171236 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3095828QLYG0 ========================2022-01-03 09:54:42======================== insert into mBoard_order set rOrdNo = 'Direct-sunmro-1641171236', AuthTy = 'card', memberId = 'sunmro', OrdNm ='°­Âù¼ö', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(ÁÖ)ž翥¾Ë¿À', ProductCode = 'point', rProdNm = '[Æ÷ÀÎÆ®ÃæÀü]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '¿ì¸®MASTER 558920******2440', rApprNo = 'mjsof20220103095828QisA4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-01-03 09:54:42', InvoiceNum = '°áÁ¦¼º°ø:Direct-sunmro-1641171236/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-01-03 09:54:42' ========================2022-01-03 09:54:42======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220103095828QisA4' 0 = 1 cnt = 1 ========================2022-01-03 09:54:42======================== 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 ========================2022-01-03 09:54:42======================== select * from customers where id = 'sunmro' ========================2022-01-03 09:54:42======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sunmro','2022-01-03 09:54:42','220000','220000','¿Â¶óÀÎ','0') ========================2022-01-03 09:58:31======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-isuccm-1641170707 LGD_BUYER = Á¤Å¼º LGD_PRODUCTINFO = [¹Ù·Î°áÁ¦] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220103094507 LGD_HASHDATA = e88148b76bdc09514e4e8f5b67e8aea2 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 = 20220103100217213BE582934B4328B9B2CD2FFF6BE179PRYFPW2T Mname = Á¤Å¼º Mcompany = À̼öÁ¾ÇÕ°ÇÀç post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = isuccm LGD_ESCROW_USEYN = N ========================2022-01-03 09:58:32======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220103100217 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 373ICC LGD_AFFILIATECODE = DAB6HT LGD_RESPMSG = °áÁ¦¼º°ø LGD_2TR_FLAG = Y LGD_CARDNUM = 941019******8459 LGD_FINANCEAUTHNUM = 17162757 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 41000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 75a20429df703170c946b5de12c2d8fe LGD_BUYERADDRESS = LGD_FINANCENAME = ½ÅÇÑ LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20220103100218 LGD_PCANCELSTR = 0 LGD_BUYER = Á¤Å¼º LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [¹Ù·Î°áÁ¦] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220103100217TSf28 LGD_BUYERID = LGD_OID = Direct-isuccm-1641170707 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-01-03 09:58:32======================== insert into mBoard_order set rOrdNo = 'Direct-isuccm-1641170707', AuthTy = 'card', memberId = 'isuccm', OrdNm ='Á¤Å¼º', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = 'À̼öÁ¾ÇÕ°ÇÀç', ProductCode = 'point', rProdNm = '[Æ÷ÀÎÆ®ÃæÀü]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '½ÅÇÑ 941019******8459', rApprNo = 'mjsof20220103100217TSf28', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-01-03 09:58:32', InvoiceNum = '°áÁ¦¼º°ø:Direct-isuccm-1641170707/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-01-03 09:58:32' ========================2022-01-03 09:58:32======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220103100217TSf28' 0 = 1 cnt = 1 ========================2022-01-03 09:58:32======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'isuccm' 0 = isuccm Mid = isuccm 1 = À̼öÁ¾ÇÕ°ÇÀç Mcompany = À̼öÁ¾ÇÕ°ÇÀç 2 = 2718800634 companyNum = 2718800634 3 = 043-645-5881 Mtel1 = 043-645-5881 4 = Mhp = ========================2022-01-03 09:58:32======================== select * from customers where id = 'isuccm' ========================2022-01-03 09:58:32======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('isuccm','2022-01-03 09:58:32','10000','11000','¿Â¶óÀÎ','0') ========================2022-01-03 10:04:35======================== res_start ========================2022-01-03 10:04:35======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID Çʵ尡 ´©¶ôµÇ¾ú½À´Ï´Ù. Init_TX(LGD_MID)¸¦ ÇØÁֽñ⠹ٶø´Ï´Ù. ¶Ç´Â mall.conf ¿¡ »óÁ¡Å°°¡ ¼ÂÆÃµÇ¾î ÀÖÁö ¾Ê½À´Ï´Ù. ========================2022-01-03 10:10:05======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tarancokr-1641172098 LGD_BUYER = ±è¹Î¼® LGD_PRODUCTINFO = [¹Ù·Î°áÁ¦] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220103100818 LGD_HASHDATA = 67259ad8fc11757753fed904f8bd1e3a 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 = 20220103101351D2911D95AC2349A5BB1C116D2F82CBECZENBIJCS Mname = ±è¹Î¼® Mcompany = Ÿ¶õ½Ç¾÷ post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = tarancokr LGD_ESCROW_USEYN = N ========================2022-01-03 10:10:06======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220103101351 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 331012 LGD_RESPMSG = °áÁ¦¼º°ø LGD_2TR_FLAG = Y LGD_CARDNUM = 910003******4334 LGD_FINANCEAUTHNUM = 44501074 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f1a64130f484676eefcfea525547f791 LGD_BUYERADDRESS = LGD_FINANCENAME = ºñ¾¾ LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220103101352 LGD_PCANCELSTR = 0 LGD_BUYER = ±è¹Î¼® LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [¹Ù·Î°áÁ¦] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220103101351VRCb9 LGD_BUYERID = LGD_OID = Direct-tarancokr-1641172098 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3101351VvIq8 ========================2022-01-03 10:10:06======================== insert into mBoard_order set rOrdNo = 'Direct-tarancokr-1641172098', AuthTy = 'card', memberId = 'tarancokr', OrdNm ='±è¹Î¼®', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = 'Ÿ¶õ½Ç¾÷', ProductCode = 'point', rProdNm = '[Æ÷ÀÎÆ®ÃæÀü]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'ºñ¾¾ 910003******4334', rApprNo = 'mjsof20220103101351VRCb9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-01-03 10:10:06', InvoiceNum = '°áÁ¦¼º°ø:Direct-tarancokr-1641172098/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-01-03 10:10:06' ========================2022-01-03 10:10:06======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220103101351VRCb9' 0 = 1 cnt = 1 ========================2022-01-03 10:10:06======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'tarancokr' 0 = tarancokr Mid = tarancokr 1 = Ÿ¶õ½Ç¾÷ Mcompany = Ÿ¶õ½Ç¾÷ 2 = 1380716956 companyNum = 1380716956 3 = 031-429-4222 Mtel1 = 031-429-4222 4 = 010-6332-1003 Mhp = 010-6332-1003 ========================2022-01-03 10:10:06======================== select * from customers where id = 'tarancokr' ========================2022-01-03 10:10:06======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('tarancokr','2022-01-03 10:10:06','108000','110000','¿Â¶óÀÎ','0') ========================2022-01-03 10:21:41======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-vudghktkdtk-1641172831 LGD_BUYER = °­¿øÈ£ LGD_PRODUCTINFO = [¹Ù·Î°áÁ¦] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220103102031 LGD_HASHDATA = 6516a28a1b2a77a82c1dc58a37661e94 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 = 202201031025273A7327FA4E9A42CFB2AF5009F72D86E0VFV2LFE5 Mname = °­¿øÈ£ Mcompany = ÆòÈ­»ó»ç post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = vudghktkdtk LGD_ESCROW_USEYN = N ========================2022-01-03 10:21:41======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220103102528 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 = 553142******7202 LGD_FINANCEAUTHNUM = 00210471 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = bcac6a53244cc5cd339e5802b4ceaa3d LGD_BUYERADDRESS = LGD_FINANCENAME = Çö´ëMASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20220103102528 LGD_PCANCELSTR = 0 LGD_BUYER = °­¿øÈ£ LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [¹Ù·Î°áÁ¦] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220103102527TTga2 LGD_BUYERID = LGD_OID = Direct-vudghktkdtk-1641172831 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-01-03 10:21:41======================== insert into mBoard_order set rOrdNo = 'Direct-vudghktkdtk-1641172831', AuthTy = 'card', memberId = 'vudghktkdtk', OrdNm ='°­¿øÈ£', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = 'ÆòÈ­»ó»ç', ProductCode = 'point', rProdNm = '[Æ÷ÀÎÆ®ÃæÀü]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = 'Çö´ëMASTER 553142******7202', rApprNo = 'mjsof20220103102527TTga2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-01-03 10:21:41', InvoiceNum = '°áÁ¦¼º°ø:Direct-vudghktkdtk-1641172831/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-01-03 10:21:41' ========================2022-01-03 10:21:41======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220103102527TTga2' 0 = 1 cnt = 1 ========================2022-01-03 10:21:41======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'vudghktkdtk' 0 = vudghktkdtk Mid = vudghktkdtk 1 = ÆòÈ­»ó»ç Mcompany = ÆòÈ­»ó»ç 2 = 8570200394 companyNum = 8570200394 3 = 043-224-7982 Mtel1 = 043-224-7982 4 = 010-4243-6887 Mhp = 010-4243-6887 ========================2022-01-03 10:21:41======================== select * from customers where id = 'vudghktkdtk' ========================2022-01-03 10:21:41======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('vudghktkdtk','2022-01-03 10:21:41','52500','55000','¿Â¶óÀÎ','0') ========================2022-01-03 15:31:35======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ositrade-1641191444 LGD_BUYER = (ÁÖ)¿À¿¡½º¾ÆÀ̹«¿ª LGD_PRODUCTINFO = [¹Ù·Î°áÁ¦] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220103153044 LGD_HASHDATA = dd8e8460fa1bb945e86f61a7baeaffb7 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 = 20220103153521643E5A9F6F1C4B598B7381FC4B2D899AFAUNRO1A Mname = (ÁÖ)¿À¿¡½º¾ÆÀ̹«¿ª Mcompany = (ÁÖ)¿À¿¡½º¾ÆÀ̹«¿ª post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = ositrade LGD_ESCROW_USEYN = N ========================2022-01-03 15:31:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220103153522 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 003332 LGD_RESPMSG = °áÁ¦¼º°ø LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******2828 LGD_FINANCEAUTHNUM = 30266514 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f4e15d02a0dc78ae49e854dc62add479 LGD_BUYERADDRESS = LGD_FINANCENAME = ±¹¹ÎMASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220103153522 LGD_PCANCELSTR = 0 LGD_BUYER = (ÁÖ)¿À¿¡½º¾ÆÀ̹«¿ª LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [¹Ù·Î°áÁ¦] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2022010315352108T13 LGD_BUYERID = LGD_OID = Direct-ositrade-1641191444 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 31535210atw0 ========================2022-01-03 15:31:35======================== insert into mBoard_order set rOrdNo = 'Direct-ositrade-1641191444', AuthTy = 'card', memberId = 'ositrade', OrdNm ='(ÁÖ)¿À¿¡½º¾ÆÀ̹«¿ª', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(ÁÖ)¿À¿¡½º¾ÆÀ̹«¿ª', ProductCode = 'point', rProdNm = '[Æ÷ÀÎÆ®ÃæÀü]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '±¹¹ÎMASTER 558526******2828', rApprNo = 'mjsof2022010315352108T13', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-01-03 15:31:35', InvoiceNum = '°áÁ¦¼º°ø:Direct-ositrade-1641191444/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-01-03 15:31:35' ========================2022-01-03 15:31:35======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2022010315352108T13' 0 = 1 cnt = 1 ========================2022-01-03 15:31:35======================== 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 ========================2022-01-03 15:31:35======================== select * from customers where id = 'ositrade' ========================2022-01-03 15:31:35======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ositrade','2022-01-03 15:31:35','108000','110000','¿Â¶óÀÎ','0') ========================2022-01-03 17:54:06======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-well1934-1641199301 LGD_BUYER = Á¤Àº°æ LGD_PRODUCTINFO = [¹Ù·Î°áÁ¦] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220103174141 LGD_HASHDATA = 9737c6388ac6ead9d46d9c354eba794d 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 = 2022010317575376F06DA714CC4872A267D903AE6F732C8IEKMNH6 Mname = Á¤Àº°æ Mcompany = À£Äĸ¶ÄÏ post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = well1934 LGD_ESCROW_USEYN = N ========================2022-01-03 17:54:07======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220103175753 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = BA7A3X LGD_RESPMSG = °áÁ¦¼º°ø LGD_2TR_FLAG = Y LGD_CARDNUM = 356908******3989 LGD_FINANCEAUTHNUM = 23006411 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 41300 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ee1a90fd22a2cf9d48a4e484f8477f40 LGD_BUYERADDRESS = LGD_FINANCENAME = ½ÅÇÑJCB LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20220103175754 LGD_PCANCELSTR = 0 LGD_BUYER = Á¤Àº°æ LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [¹Ù·Î°áÁ¦] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220103175753S8s31 LGD_BUYERID = LGD_OID = Direct-well1934-1641199301 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-01-03 17:54:07======================== insert into mBoard_order set rOrdNo = 'Direct-well1934-1641199301', AuthTy = 'card', memberId = 'well1934', OrdNm ='Á¤Àº°æ', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = 'À£Äĸ¶ÄÏ', ProductCode = 'point', rProdNm = '[Æ÷ÀÎÆ®ÃæÀü]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '½ÅÇÑJCB 356908******3989', rApprNo = 'mjsof20220103175753S8s31', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-01-03 17:54:07', InvoiceNum = '°áÁ¦¼º°ø:Direct-well1934-1641199301/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-01-03 17:54:07' ========================2022-01-03 17:54:07======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220103175753S8s31' 0 = 1 cnt = 1 ========================2022-01-03 17:54:07======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'well1934' 0 = well1934 Mid = well1934 1 = À£Äĸ¶ÄÏ Mcompany = À£Äĸ¶ÄÏ 2 = 232-18-01047 companyNum = 232-18-01047 3 = 010-4442-1658 Mtel1 = 010-4442-1658 4 = 010-4442-1658 Mhp = 010-4442-1658 ========================2022-01-03 17:54:07======================== select * from customers where id = 'well1934' ========================2022-01-03 17:54:07======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('well1934','À£Äĸ¶ÄÏ','2321801047','010-4442-1658','010-4442-1658','2022-01-03 17:54:07','¿Â¶óÀÎ') ========================2022-01-03 17:54:07======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('well1934','2022-01-03 17:54:07','10000','11000','¿Â¶óÀÎ','0') ========================2022-01-03 21:56:07======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-vnem103-1641214488 LGD_BUYER = ¾öÇü¼· LGD_PRODUCTINFO = [¹Ù·Î°áÁ¦] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220103215448 LGD_HASHDATA = 17948f35ed9ce79b1487ec4b30278334 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 = 20220103215954FFBED1A322DD4A54A291DF31E08304D7USJDPDY5 Mname = ¾öÇü¼· Mcompany = û¾ÆÇªµå post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = vnem103 LGD_ESCROW_USEYN = N ========================2022-01-03 21:56:08======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220103215955 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = BJCBLP LGD_RESPMSG = °áÁ¦¼º°ø LGD_2TR_FLAG = Y LGD_CARDNUM = 478892******8111 LGD_FINANCEAUTHNUM = 25496386 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e22c888e95812fe1ce68bc1af7246bb7 LGD_BUYERADDRESS = LGD_FINANCENAME = ½ÅÇÑVISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20220103215955 LGD_PCANCELSTR = 0 LGD_BUYER = ¾öÇü¼· LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [¹Ù·Î°áÁ¦] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220103215955Tjhu0 LGD_BUYERID = LGD_OID = Direct-vnem103-1641214488 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-01-03 21:56:08======================== insert into mBoard_order set rOrdNo = 'Direct-vnem103-1641214488', AuthTy = 'card', memberId = 'vnem103', OrdNm ='¾öÇü¼·', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = 'û¾ÆÇªµå', ProductCode = 'point', rProdNm = '[Æ÷ÀÎÆ®ÃæÀü]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '½ÅÇÑVISA 478892******8111', rApprNo = 'mjsof20220103215955Tjhu0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-01-03 21:56:08', InvoiceNum = '°áÁ¦¼º°ø:Direct-vnem103-1641214488/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-01-03 21:56:08' ========================2022-01-03 21:56:09======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220103215955Tjhu0' 0 = 1 cnt = 1 ========================2022-01-03 21:56:09======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'vnem103' 0 = vnem103 Mid = vnem103 1 = û¾ÆÇªµå Mcompany = û¾ÆÇªµå 2 = 4491101928 companyNum = 4491101928 3 = 010-6577-1022 Mtel1 = 010-6577-1022 4 = 010-6577-1022 Mhp = 010-6577-1022 ========================2022-01-03 21:56:09======================== select * from customers where id = 'vnem103' ========================2022-01-03 21:56:09======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('vnem103','2022-01-03 21:56:08','30900','33000','¿Â¶óÀÎ','0')