webadmin.php

/home/mjc1/public_html/html/m/mypagecertifi.php

<?php include_once("./_common2.php"); ?>
<? include("./include/header.php"); ?>

<?

    //print_r($_SESSION);

    $USERID = "" ; //20130807추가
    $currentDay = date('Y-m-d',Time());
  
    //if(  $_COOKIE['USERID'] == ""){
    if($_COOKIE['USERID']=='') $_COOKIE['USERID'] = $_SESSION['USERID'];;
    if( !isset($_COOKIE['USERID']) || $_COOKIE['USERID'] == "" ) {
?>

<script>
    location.href = "./logingo.php";
</script>

<?
  } 

    $enckey = sha1($_SESSION['USERID']."§§§".$_SESSION['USERID']);
    //_pr($enckey);
  
    $memberQry       =   " SELECT * FROM member WHERE Mid = '{$_COOKIE['USERID']}' "; 

    $memberResult    =     MYSQL_QUERY($memberQry,$connect_web);
    $memberRow       =     MYSQL_FETCH_ARRAY($memberResult);

    //20130903
    $programName_0 = "";
    $programName_1 = "";

    if($memberRow['Msw1'] !== "0"){    //사용프로그램 
        $programNameQry    =    " SELECT category_name FROM cate3 WHERE category_code = '{$memberRow['Msw1']}' ";
        $programResult     =      MYSQL_QUERY($programNameQry,$connect_web);
        $programRow        =      MYSQL_FETCH_ARRAY($programResult);
        $programName       =      explode("->",$programRow[0]);
        $programName_0 = $programName[0];
        if (count($programName)>=2) $programName_1 = $programName[1];
    }
    else {
    
        //$programName      =     "선택되지 않음";
        $programName_0       =     "선택되지 않음";
    }
   
   
  if($memberRow['Mdiv'] == "2")  $_certiNum   = "certi_num";  //정품번호
  else                         $_certiNum   = "rent_num";    //임대번호
     
   $certiQry      = "  SELECT $_certiNum, ver FROM  certinumManage WHERE substring( category_code , 5,2 ) = '{$memberRow['Msw1']}' ";
   //_pr($certiQry);
   $certiResult   =     mysql_query($certiQry,$connect_web);
   $certiRow      =     mysql_fetch_array($certiResult);
    //_pr($certiRow);
      
     //정품번호 업데이트 2010-11-09 추가:인증기간내일때만 업데이트

 $toDay = date('Y-m-d',Time());
  
 $j_query  = "select * from member where (Mdiv ='2' and  Mup ='1') and End_day > '$toDay' and Mid = '{$_COOKIE['USERID']}' ";
 $j_result = mysql_query($j_query,$connect_web);

 $i_query  = "select * from member where (Mdiv ='3' and  Mper ='1') and End_day > '$toDay' and Mid = '{$_COOKIE['USERID']}' ";
 $i_result  = mysql_query($i_query,$connect_web);
  
  if( MYSQL_NUM_ROWS($j_result) > 0  || MYSQL_NUM_ROWS($i_result) > 0 ){
  $certiUpdate      =  " update member set Certi_num = '$certiRow[0]', Certi_ver = '$certiRow[ver]'  WHERE Mid = '{$_COOKIE['USERID']}' ";  
                         mysql_query($certiUpdate,$connect_web);  
  }

    if($memberRow['Msw1']!=''){
        $sql = "select * from cate3 where category_code = '{$memberRow['Msw1']}' ";
        $prod_res1   =     mysql_query($sql,$connect_web);
        $prod_row1      =     mysql_fetch_array($prod_res1);
        $v = explode("->",$prod_row1['category_name']);
        $prod_row1['prod_name'] = $v[1];

        $sql = "select * from app_priv where user_id = '{$_COOKIE['USERID']}' and app_id = '{$memberRow['Msw1']}' ";
        $res = mysql_query($sql,$connect_app);
        $app_info1 = mysql_fetch_array($res);
    }

    //_pr($app_info1);

    if($memberRow['Msw2']!=''){
        $sql = "select * from cate3 where category_code = '{$memberRow['Msw2']}' ";
        $prod_res2   =     mysql_query($sql,$connect_web);
        $prod_row2      =     mysql_fetch_array($prod_res2);
        $v = explode("->",$prod_row2['category_name']);
        $prod_row2['prod_name'] = $v[1];
    }

    foreach($memberRow as $key=>$val){
        $memberRow[$key] = iconv("euc-kr","utf-8",$val);
    }
    $prod_row2['prod_name'] = iconv("euc-kr","utf-8",$prod_row2['prod_name']);
    $prod_row1['prod_name'] = iconv("euc-kr","utf-8",$prod_row1['prod_name']);
                         
  
?>
<style>
/*    @import url('https://fonts.googleapis.com/css2?family=Nanum+Myeongjo:wght@400;700;800&display=swap');*/
/*    .page {font-family: 'Nanum Myeongjo', serif;width: 712px;height: 1082px;margin: 20px auto;border: 1px #D3D3D3 solid;background: white;background:url('./img/mypage/certifi_frame.png') no-repeat;background-size:contain;color:#000;padding:93px;}*/
/*    .page h2 {font-family: 'Nanum Myeongjo', serif;text-align: center; font-weight:bold; font-size:36px;color:#000;margin-bottom:80px;margin-top:-15px;margin-right:25px;}*/
/*    .page p {font-family: 'Nanum Myeongjo', serif;font-size:16px;line-height:1.5;font-weight:bold;margin:auto;}*/
/*    .page p span {font-family: 'Nanum Myeongjo', serif;}*/
/*    .page a {color:inherit;}*/
/*    .page .certifi_text {font-size:24px;line-height:1.5;margin-top:80px;}*/
/*    .page .mb37 {margin-bottom:37px;}*/
/*    .certifi_num {font-weight:800;}*/

    @import url('https://fonts.googleapis.com/css2?family=Nanum+Myeongjo:wght@400;700;800&display=swap');
    .wrap {margin-top:25px;}
    .contents {padding:0 20px;box-sizing:border-box;}
    .sec_block {box-sizng:border-box;-moz-box-sizing:border-box;width: 210mm;margin:auto;zoom:0.4;}
    .page {font-family: 'Nanum Myeongjo', serif;width: 210mm; min-height: 297mm;padding: 10mm;margin: 10mm auto;border-radius:5px;background:white;box-sizing:border-box;}
    .subpage {background:url('./images/mypage/certifi_frame.png') no-repeat center;background-size:cover;color:#000;padding: 1cm;height:257mm;}
    .subpage .wrap_page {padding:0.7cm;}
    .subpage h2 {font-family: 'Nanum Myeongjo', serif;text-align: center; font-weight:bold; font-size:22pt;color:#000;margin-bottom:70px;margin-top:-3px;margin-right:25px;}
    .subpage p {font-family: 'Nanum Myeongjo', serif;font-size:10pt;line-height:1.5;font-weight:bold;margin:auto;}
    .subpage p span {font-family: 'Nanum Myeongjo', serif;}
    .subpage a {color:inherit;text-decoration:none;}
    .subpage .certifi_text {font-size:15pt;line-height:1.5;margin-top:60px;}
    .subpage .mb35 {margin-bottom:35px;}
    .certifi_num {font-weight:800;}
</style>

    <div class="wrap" onclick="closeNav()">

        <div class="contents">
            <div class="asideMenu">
                <? include("./Page/mypage/leftNavi.html"); ?>
            </div><!-- //leftNavi -->

            <div class="subContents">
                <h1 style="margin:10px;">
                    <img src="./images/titlebar/mypagecertifi.png" alt="인증서출력">
                </h1>

                <div class="section" style="margin-bottom:10px;border:1px solid #ccc;">
                    <div class="sec_block">
                        <div class="page">
                            <div class="subpage">
                                <div class="wrap_page">
                                    <h2>
                                        <img src="./images/mypage/seal.png"  style="vertical-align:middle;width:110px;">
                                        소프트웨어 사용권 인증서
                                    </h2>
                                    <p class="mb35">
                                        사용자 정보 확인<br>- 상호(이름) : <span><?php echo $memberRow['Mcompany']."(".$memberRow['Mname'].")";?></span><br>
                                        - 주소 : <span><?php echo $memberRow['Madd'];?></span><br>
                                        - ID : <span><?php echo $memberRow['Mid'];?></span>
                                    </p>
                                    <p class="mb35">
                                        소프트웨어 : <span><?php echo $prod_row1['prod_name']; if($prod_row2['prod_name']!=''){ echo ", ".$prod_row2['prod_name']; }?></span><br>
                                        인증번호 : <span class="certifi_num"><?php echo $certiRow['certi_num'];?></span><br>
                                        도입일 : <span><?php echo substr($memberRow['Start_day'],0,4)."년 ".substr($memberRow['Start_day'],5,2)."월 ".substr($memberRow['Start_day'],8,2)."일";?></span>
                                        <!--사용범위 : <span>PC 1대, PDA 3대(양도양수불가)</span><br>
                                        사용기간 : <span>2021년 2월 24일 ~ 평생</span>-->
                                    </p>
                                    <p class="mb35">
                                        소프트웨어설치경로 : <a href="http://www.mijinsoft.co.kr/download/<?php echo $prod_row1['DemoDownFile'];?>" target="_blank"><span>http://www.mijinsoft.co.kr/download/<?php echo $prod_row1['DemoDownFile'];?></span></a><br>
                                        - 설치파일을 다운로드 하신 후 백업 사본을 만들어 별도로 안전한 장소에 보관하시기 바랍니다. 일정기간이 경과 후에는 다운로드가 안 될 수 있습니다.
                                    </p>
                                    <p>
                                        제품등록<br>
                                        1. 본 프로그램을 먼저 다운로드하여 설치합니다.<br>
                                        2. 인증번호를 확인 후 기재된 정품번호로 정품등록 하시면 됩니다.
                                    </p>
                                    <p class="certifi_text">
                                        엠제이소프트는 본 소프트웨어 사용원 인증서를 통해 "소프트웨어" 사용에 대한 권리를 위와 같이 인증하며, "소프트웨어" 를 정당하게 취득하여 사용하고 있음을 증명합니다.
                                    </p>
                                    <p class="certifi_text" style="text-align:right;">
                                        <span style="margin-right:40px;"><span><?php echo date("Y");?></span>년</span><span style="margin-right:40px;"><span><?php echo date("m");?></span>월</span><span style="margin-right:118px;"><span><?php echo date("d");?></span>일</span>
                                    </p>
                                    <p class="certifi_text" style="text-align:center;margin-left:71px;">
                                        엠제이소프트<img src="./images/mypage/office_stamp.png" style="margin-left:14px;vertical-align:middle;width:60px;">
                                    </p>
                                </div>
                            </div>
                        </div>
                    </div>
                </div><!-- //section -->
                <div style="text-align:center;margin:30px 0;">
                    <img src="./images/mypage/pdf_bt.png" onclick="down_btn()" style="cursor:pointer;">
                </div>
            </div><!-- //subContents -->
        </div><!-- //contents -->
    </div><!-- //wrap -->
    <script>
        function print_btn() {
            var win = window.open("./certifi_print.php", "popupwin", "width=810, height=1200");
        };
        function down_btn() {
            if(confirm('PDF파일로 제공됩니다. 인증서를 다운로드 하시겠습니까?')){
                document.location.href="../millennium/certifi_download.php?Mid=<?php echo $_SESSION['USERID'];?>&enckey=<?php echo $enckey;?>&mode=mobile";
            }
        }
    </script>

<? include("./include/footer.php"); ?>