webadmin.php

/home/mjc1/public_html/manage/cs3_manualBoard.php

<?
    include("./include/admin_include_header.php");

    $admin_info = admin_member_info();
if($admin_info['psn_auth']=='0' || substr($admin_info['psn_rwed'],0,1)=='0'){
    echo "<script>alert('ÇØ´ç Á¢±Ù±ÇÇÑÀÌ ¾ø½À´Ï´Ù.');window.history.go(-1);</script>"; exit;
}
auth_access_log("LIST");
    
    $cm_nCount          =      10;
    $cm_item_nCount     =      30;            

    function pageListing($cur_page, $total_page, $n, $url, $mode, $SearchMdiv ,$SearchMup,$SearchMper,$searchCode ,$keyword ,$SearchMsw1 , $cm_nCount, $menu, $sub  ) {

        $retValue = "<div class='paging'>";
        if ($cur_page > 1) {

            $retValue .= "<a href='" . $url . ($cur_page-1) ."' class='page'><span class='next'>ÀÌÀü</span></a>";
        } else {
            $retValue .= "";
            $retValue .= "";
        }

        $retValue .= "";

        $start_page = ( ( (int)( ($cur_page - 1 ) / 10 ) ) * 10 ) + 1;

        $end_page = $start_page + 9;
        if ($end_page >= $total_page) $end_page = $total_page;
            if ($start_page > 1) $retValue .= "<a href='" . $url . ($start_page-1) . "' class='page'><span class='next10'>ÀÌÀü 10°³</span></a>";

                if ($total_page > 1)
                    for ($k=$start_page;$k<=$end_page;$k++)
                if ($cur_page != $k) $retValue .= "<a href='$url$k'>$k</a>";
                    else $retValue .= "<a href='$url$k' class='on'>$k</a>";

        if ($total_page > $end_page) $retValue .= "<a href='" . $url . ($end_page+1) . "' class='page'><span class='pro10'>´ÙÀ½ 10°³</span></a>";

        $retValue .= "";

        if ($cur_page < $total_page) {
            $retValue .= "<a href='$url" . ($cur_page+1) ."' class='page'><span class='pro'>´ÙÀ½</span></a>";

        } else {
            $retValue .= "";
            $retValue .= "";
        }

        $retValue .= "</div>";
        return $retValue;
    }
    
    if( isset($keyword) && $keyword !== ""){
    
        if( $searchCode == '1')  $Code =  " and subject like  '%$keyword%' ";
        if( $searchCode == '2')  $Code =  " and content like '%$keyword%' ";
        
    }

    if( isset($SearchMsw1) && $SearchMsw1 !== "all" && $SearchMsw1 !== "" ){
        $SearchMswQry   =   " and  a.cate1 = '$SearchMsw1' ";   
    }

    if( isset($SearchMsw2) && $SearchMsw2 !== "all" && $SearchMsw2 !== "" ){
        $SearchMswQry2   =   " and  a.cate2 = '$SearchMsw2' "; 
    }
    
 
    /*$total_sql  .=   " SELECT a.uid ,a.subject ,a.content ,a.hit ,a.reg_date, b.name, LPAD(a.thread,2,'0') AS gongcout, c.name ,a.chapter  
                                    FROM cs3_manualBoard a, cs3_manual_cate1 b, cs3_manual_cate2 c  
                                    WHERE a.uid >  0 and a.cate1 = b.code and a.cate2 = c.code  $Code $SearchMswQry $SearchMswQry2 ";*/
    $total_sql .= " SELECT a.uid ,a.subject ,a.content ,a.hit ,a.reg_date, LPAD(a.thread,2,'0') AS gongcout, a.chapter , 
                            b.name as cate1_name, ifnull(c.name,'') as cate2_name, ifnull(d.name,'') as cate3_name
                         FROM cs3_manualBoard a 
                         left join cs3_manual_cate1 b on a.cate1 = b.code
                         left join cs3_manual_cate2 c on a.cate2 = c.code
                         left join cs3_manual_cate3 d on a.cate2 = d.code
                         WHERE 1=1 $Code $SearchMswQry $SearchMswQry2 ";
 
    $result      = mysql_query($total_sql) or die (mysql_error());
    $nTotalCount = mysql_num_rows($result);
    $nPage       = ceil($nTotalCount / $cm_nCount);
    
    if ($pg == "") $pg = 1;
    if ($_POST['search_mode'] == "Y"){ // °Ë»ö ½Ã ÆäÀÌÂ¡³Ñ¹ö ³¯¸®±â À§ÇØ ¾Æ·§ÂÊ hidden °ª Æ÷ÇÔÇÏ¿© ¼±¾ð 2013.12.02 by.jyh
      $pg = 1;      
    }    

        $nFrom = ($pg - 1) * $cm_nCount;
        $sql    = $total_sql . "  order by gongcout DESC, a.uid DESC limit $nFrom, $cm_nCount ";
        $result = mysql_query($sql) or die (mysql_error());


 
?>

<script> 
function programCh(t){
    location.href  =  'cs3_manualBoard.php?SearchMsw1='+t;   
}

function programCh2(t){
    location.href  =  'cs3_manualBoard.php?SearchMsw2='+t;   
}

function Search(){
    document.getElementById('search_mode').value = "Y";    
    searchFrm.submit();

}

function manualWrite(b){
    location.href = "cs3_manualWrite.php?categoryCode=" + b;
} 

function CheckAll() {

    if( document.faqFrm.all.value == 1){
        document.chkImg.src = "bt_allcheck_not.gif";

        for (var i=0;i<document.faqFrm.elements.length;i++){
            if (document.faqFrm.elements[i].name == 'faqForm[]'){
                document.faqFrm.elements[i].checked = true;

            }
    }
    document.faqFrm.all.value = '0'; 
} else {
    document.chkImg.src = "bt_allcheck.gif";

    for (var i=0;i<document.faqFrm.elements.length;i++){
        if (document.faqFrm.elements[i].name == 'faqForm[]'){
            document.faqFrm.elements[i].checked = false;
        }
    }

    document.faqFrm.all.value = '1'; 
    }
} 


function allDel(){
    
    var cnt=0;
    
    for (var i=0;i<document.faqFrm.elements.length;i++){
        if (document.faqFrm.elements[i].name == 'faqForm[]'){
        
            if( document.faqFrm.elements[i].checked == true ) cnt++;
        }
    }
    
    if(cnt>0){ 
        
        if(confirm("¼±ÅÃÇÏ½Å "+ cnt +" °³ÀÇ °Ô½Ã¹° Á¤º¸¸¦ »èÁ¦ÇÏ½Ã°Ú½À´Ï±î?") ){
            document.faqFrm.action = "cs3_manualBoardProcess.php" ;
            document.getElementById("faqFrm").target="hidden_frame_mijin";          
            document.faqFrm.submit();
        }
        
    } else {
        alert("»èÁ¦ÇÒ Ç×¸ñÀ» ¼±ÅÃÇÏ¼¼¿ä.")
        return;
    }   
}     
</script>
<link rel='stylesheet' type='text/css' href='./css/new.css'>
<div class="container">
    <div class="border_contents">
        <div class="admin_table">
            <h3 class="list_ttl">
                Ãµ³â3 ¿Â¶óÀÎ¸Þ´º¾ó
                <span class="list_sub_ttl bgb">Ãµ³â°æ¿µ3 ¿Â¶óÀÎ¸Þ´º¾óÀ» µî·Ï/°ü¸®ÇÏ´Â ÆäÀÌÁöÀÔ´Ï´Ù.</span>
            </h3>

            <form name='searchFrm' method='post'>
                <input type="hidden" name="search_mode" id="search_mode">

                <div class="searchArea searchAreaPlus">
                    <span class="searchAreaL"></span>
                    <span class="searchAreaR"></span>
                    <dl class="search_tender requestSearchArea" style="width: 675px;">
                        <dd class="relative">
                            <p class="arrow"></p>
                            <select name='SearchMsw1' class="nonearrow" onChange='programCh(this.value);'>
                                <option value='all'  <? if($SearchMsw1 == $cateRow[0] ){ echo "selected"; } ?> >ÀüÃ¼ ´ëºÐ·ù</option>
<?
    $qry  =   " select code,name from cs3_manual_cate1 order by uid ";
    $cateResult = mysql_query($qry);
    
        while( $cateRow = mysql_fetch_array($cateResult) ){
?>   

                                <option value='<?=$cateRow[0];?>' <? if($SearchMsw1 == $cateRow[0] ){ echo "selected"; } ?> > <?=$cateRow[1];?></option>";

<? } ?> 
                            </select>
                        </dd>
                        <dd class="relative">
                            <p class="arrow"></p>
                            <select name='SearchMsw2' class="nonearrow" onChange='programCh2(this.value);'>
                                <option value='all'  <? if($SearchMsw2 == $cateRow2[0] ){ echo "selected"; } ?> >ÀüÃ¼ ÁßºÐ·ù</option>
<?
    $qry = " select code,name from cs3_manual_cate2 order by uid ";
    $cateResult = mysql_query($qry);
    
        while( $cateRow2 = mysql_fetch_array($cateResult) ){
?> 

                                <option value='<?=$cateRow2['code'];?>' <? if($SearchMsw2 == $cateRow2['code'] ){ echo "selected"; } ?> ><?=$cateRow2['name'];?></option>";
                                    
<? } ?> 
                            </select>
                        </dd>
                        <dd class="relative">
                            <p class="arrow"></p>
                            <select name='searchCode' class="nonearrow">
                                <option value=1  <? if($searchCode == '1'){ echo "selected"; } ?>>Á¦¸ñ</option>
                                <option value=2  <? if($searchCode == '2'){ echo "selected"; } ?>>³»¿ë</option>
                            </select>
                        </dd>
                        <dd>
                            <input type='text' name='keyword' size='20' value='<?=$keyword;?>' onKeyDown="javascript:if(event.keyCode == 13) Search();"  style="width:143px;height:29px;" class="keyword">
                        </dd>
                        <dd class="searchbtnarea">
                            <a href='javascript:Search();' class="searchBtn bgb">°Ë»ö</a>
                            <input type='hidden' name='mode' value='search'>
                        </dd>
                    </dl><!--search_tender-->
                </div><!-- //searchArea1-->
            </form>

            <p class="mt10 mb5">
                <img src="./img/check.png" width="20">
                <span style="padding:4px;">È¨ÆäÀÌÁö¿¡¼´Â '±Û¼ø¼'´Â <span class="red">³ôÀº ¼ýÀÚ°¡ ¸ÕÀú º¸ÀÔ´Ï´Ù.</span> ex) 10, 2, 7, 1... ÀÌ¶ó´Â ¼ýÀÚ°¡ÀÖÀ¸¸é <span class="red">10, 7, 2, 1 ¹ø ¼ø¼</span>·Î º¸ÀÔ´Ï´Ù.</span>
            </p>

            <form name='faqFrm' id='faqFrm'>
                <input type='hidden' name='all' value='1'>
                <input type='hidden' name='exCode' value='alldel'>
                <input type="hidden" name="menu" value="<?=$menu?>">
                <input type="hidden" name="sub" value="<?=$sub?>">
                <div class="borderWarp" style="margin:0 0 40px; border-bottom:0 none;">
                    <table class="borderTable requestarea">
                        <colgroup>
                            <col style="width:50px;"><col style="width:52px;">
                            <col style="width:200px;"><col style="width:160px;">
                            <col style="width:325px;">
                            <col style="width:135px;"><col style="width:70px;">
                        </colgroup>
                        <tr class="bgb">
                            <th><img src="./images/common/bt_allcheck_all.gif" alt="¸ðµÎ¼±ÅÃ" style="cursor:pointer;" name='chkImg' onClick="CheckAll();"></th>
                            <th>±Û¹øÈ£</th>
                            <th>ºÐ·ù</th>
                            <th>È¸é¸í</th>
                            <th>Á¦¸ñ</th>
                            <th>µî·ÏÀÏ</th>
                            <th class="last">±Û¼ø¼</th>
                        </tr>
        <?
            if($num = mysql_num_rows($result)){
            
                while($row  = mysql_fetch_array($result)) {
                
                    $category_name  =   explode("->",$row[5]);
                    $content        =   stripcslashes($row[2]);
        ?>
                        <tr>
                            <td><input name="faqForm[]" type="checkbox" value="<?=$row[0];?>"></td>
                            <td class="family"><?=$row[0];?></td>
                            <td><?=$row['cate1_name'];?><?if($row['cate2_name']!=''){ echo "&nbsp;¡æ {$row['cate2_name']}"; }?><?if($row['cate3_name']!=''){ echo "<br>&nbsp;¡æ {$row['cate3_name']}"; }?></td>
                            <td><a href='cs3_manualBoardMody.php?menu=<?=$menu?>&sub=<?=$sub?>&uid=<?=$row[0];?>'><?=$row[8];?></a></td>
                            <td style="line-height:1.25;"><a href='cs3_manualBoardMody.php?menu=<?=$menu?>&sub=<?=$sub?>&uid=<?=$row[0];?>'><?=$row[1];?></a></td>
                            <td class="family" style="line-height:1.25;"><?=$row[4];?></td>
                            <td class="blue family last"><? if ( $row[6] !== "00"){ ?><?=$row[6];?><? } ?> </td>
                        </tr>
        <? 
                } 
            } else{ 
        ?>
                        <tr>
                            <td colspan="7">µ¥ÀÌÅÍ°¡ ¾ø½À´Ï´Ù.</td>
                        </tr>
        <? 
            } 
        ?>
                        <tr>
                            <td colspan="2" class="" style="padding:5px 0;"><a href='javascript:allDel();' class="allDelBtn">ÀÏ°ý»èÁ¦</a></td>
                            <td colspan="5" class="last"></td>
                        </tr>
                    </table><!-- //borderTable -->
                </div><!-- //borderWarp -->

                <div class="insertbtnarea" style="width:1000px;text-align:center;">
                    <a href="javascript:manualWrite('<?=$SearchMsw1;?>');"><span class="insertbtn2 bgb">±Ûµî·Ï</span></a>
                </div>
            </form>

            <? echo pageListing($pg, $nPage, $cm_nCount, "cs3_manualBoard.php?menu=5&sub=9&search_mode=$search_mode&SearchMsw1=$SearchMsw1&SearchMsw2=$SearchMsw2&searchCode=$searchCode&keyword=$keyword&mode=$mode&pg=" , $mode, $SearchMdiv ,$SearchMup,$SearchMper,$searchCode ,$keyword ,$SearchMsw1 , $cm_nCount, $menu, $sub)?>
            
            <?//print_r($_REQUEST)?>

            <iframe id='hidden_frame_mijin' name='hidden_frame_mijin' style="display:none;"></iframe>

        </div><!-- //admin_table -->

        <p class="navi">°ü¸®ÀÚ¸ðµå > ÀÏ¹Ý°Ô½ÃÆÇ > ¿Â¶óÀÎ¸Þ´º¾ó</p>

        <div class="footer">
            <?php include("./include/admin_include_footer.php"); ?>
        </div><!-- //footer -->

    </div><!-- //border_contents -->
</div><!-- //container -->
</div><!-- //wrap -->

</body>
</html>