webadmin.php

/home/mjc1/public_html/manage/faqBoard.php

<?
    include("./include/admin_include_header.php");
    
    $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 a.subject like  '%$keyword%' ";
        if( $searchCode == '2')  $Code =  " and a.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 from faqBoard a, faq_cate1 b, faq_cate2 c  where a.uid >  0 and a.cate1 = b.code and a.cate2 = c.code  $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  =  'faqBoard.php?SearchMsw1='+t;   
}

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

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

function faqWrite(b){
    location.href = "faqWrite.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 = "faqBoardProcess.php" ;
            document.getElementById("faqFrm").target="hidden_frame_mijin";          
            document.faqFrm.submit();
        }
    } else {
        alert("»èÁ¦ÇÒ Ç×¸ñÀ» ¼±ÅÃÇÏ¼¼¿ä.")
         return;
    }   
}     
</script>


        <div class="container">
            <div class="border_contents">

                <div class="admin_table">
                    <h3>
                        <img src="../img/admin/cscenter_title03.jpg" alt="FAQ(ÀÚÁÖÇÏ´ÂÁú¹®)">
                        <span>È¨ÆäÀÌÁöÀÇ FAQ(ÀÚÁÖÇÏ´ÂÁú¹®)À» µî·Ï/°ü¸®ÇÏ´Â ÆäÀÌÁö ÀÔ´Ï´Ù.</span>
                    </h3>


                    <form name='searchFrm' method=post>
                    <input type="hidden" name="search_mode" id="search_mode">
                        <div class="searchArea1">
                            <span class="searchAreaL1"></span>
                            <span class="searchAreaR1"></span>
                            <dl class="search_tender" style="width:640px;">
                                <dt>FAQ Á¶È¸</dt>
                                <dd>
                                    <em>´ëºÐ·ù :</em>
                                    <select name='SearchMsw1' onChange='programCh(this.value);'>
                                        <option value='all'  <? if($SearchMsw1 == $cateRow[0] ){ echo "selected"; } ?> >ÀüÃ¼ºÐ·ù</option>
<?
    $qry              =   " select code,name from faq_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>
                                    <em>ÁßºÐ·ù :</em>
                                    <select name='SearchMsw2' onChange='programCh2(this.value);'>
                                        <option value='all'  <? if($SearchMsw2 == $cateRow2[0] ){ echo "selected"; } ?> >ÀüÃ¼ºÐ·ù</option>
<?
    $qry              =   " select code,name from faq_cate2 where fave = 1 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>
                                    <select name='searchCode'>
                                        <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();">
                                </dd>
                                <dd>
                                    <a href='javascript:Search();' class="searchBtn">°Ë»ö</a>
                                    <input type='hidden' name='mode' value='search'>
                                </dd>
                            </dl><!--search_tender-->
                        </div><!-- //searchArea1-->
                    </form>
                    <!-- //°Ë»ö¹Ú½º -->
 
                    
                    <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">
                        <table class="borderTable">
                            <tr>
                                <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>±Û¼ø¼</th>
                            </tr>  
        
<?
    if($num = mysql_num_rows($result)){
    
        while($row  = mysql_fetch_array($result)) {
        
            $category_name    =      explode("->",$row[5]);
            $regdate          =      date('Y-m-d',$row[4]);
            $content                  =      stripcslashes($row[2]);
?>
                            <tr>
                                <td><input name="faqForm[]" type="checkbox" value="<?=$row[0];?>"></td>
                                <td class="family"><?=$row[0];?></td>
                                <td><?=$category_name[0];?><?=$row[7];?></td>
                                <td><a href='faqBoardMody.php?menu=<?=$menu?>&sub=<?=$sub?>&uid=<?=$row[0];?>'><?=$row[1];?></a></td>
                                <td class="family"><?=$row[3];?></td>
                                <td class="family"><?=$regdate;?></td>
                                <td class="family last"><? if ( $row[6] !== "00"){ ?><?=$row[6];?><? } ?></td>
                            </tr> 
<? 
        } 
    } else {  
?>
                            <tr>
                                <td colspan="7">µ¥ÀÌÅÍ°¡ ¾ø½À´Ï´Ù.</td>
                            </tr>
<? 
    } 
?>
                            <tr>
                                <td colspan="2" class="bottom" style="padding:5px 0;"><a href='javascript:allDel();' class="allDelBtn">ÀÏ°ý»èÁ¦</a></td>
                                <td colspan="5" class="blue bottom last">È¨ÆäÀÌÁö¿¡¼´Â '±Û¼ø¼'´Â ³ôÀº ¼øÀÚ°¡ ¸ÕÀú º¸ÀÔ´Ï´Ù. ex) 10, 2, 7, 1... ÀÌ¶ó´Â ¼ýÀÚ°¡ÀÖÀ¸¸é 10, 7, 2, 1 ¹ø ¼ø¼À¸·Î º¸ÀÔ´Ï´Ù.</td>
                            </tr>
                        </table><!-- //borderTable -->
                        </div><!-- //borderWarp -->
                        
                         <div class="btn1Warp">
                            <a href="javascript:faqWrite('<?=$SearchMsw1;?>');"><span class="btn1">±Ûµî·Ï</span></a>
                        </div>
                    </form>

                    <? echo pageListing($pg, $nPage, $cm_nCount, "faqBoard.php?menu=5&sub=3&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">°ü¸®ÀÚ¸ðµå > ÀÏ¹Ý°Ô½ÃÆÇ > FAQ(ÀÚÁÖÇÏ´ÂÁú¹®)</p>

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


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

</body>
</html>