GNU/adm/faqmasterlist.php



<title>GNU/adm/faqmasterlist.php</title>


<div class="header">GNU/adm/faqmasterlist.php</div>
<pre>&lt;?php
$sub_menu = &#039;300700&#039;;
require_once &#039;./_common.php&#039;;

auth_check_menu($auth, $sub_menu, &quot;r&quot;);

//dbconfig파일에 $g5[&#039;faq_table&#039;] , $g5[&#039;faq_master_table&#039;] 배열변수가 있는지 체크
if (!isset($g5[&#039;faq_table&#039;]) || !isset($g5[&#039;faq_master_table&#039;])) {
    die(&#039;&lt;meta charset=&quot;utf-8&quot;&gt;/data/dbconfig.php 파일에 &lt;br &gt;&lt;strong&gt;$g5[\&#039;faq_table\&#039;] = G5_TABLE_PREFIX.\&#039;faq\&#039;;&lt;/strong&gt;&lt;br &gt;&lt;strong&gt;$g5[\&#039;faq_master_table\&#039;] = G5_TABLE_PREFIX.\&#039;faq_master\&#039;;&lt;/strong&gt;&lt;br &gt; 를 추가해 주세요.&#039;);
}

//자주하시는 질문 마스터 테이블이 있는지 검사한다.
if (!sql_query(&quot; DESCRIBE {$g5[&#039;faq_master_table&#039;]} &quot;, false)) {
    if (sql_query(&quot; DESCRIBE {$g5[&#039;g5_shop_faq_master_table&#039;]} &quot;, false)) {
        sql_query(&quot; ALTER TABLE {$g5[&#039;g5_shop_faq_master_table&#039;]} RENAME TO `{$g5[&#039;faq_master_table&#039;]}` ;&quot;, false);
    } else {
        $query_cp = sql_query(
            &quot; CREATE TABLE IF NOT EXISTS `{$g5[&#039;faq_master_table&#039;]}` (
                      `fm_id` int(11) NOT NULL AUTO_INCREMENT,
                      `fm_subject` varchar(255) NOT NULL DEFAULT &#039;&#039;,
                      `fm_head_html` text NOT NULL,
                      `fm_tail_html` text NOT NULL,
                      `fm_order` int(11) NOT NULL DEFAULT &#039;0&#039;,
                      PRIMARY KEY (`fm_id`)
                    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 &quot;,
            true
        );
    }
    // FAQ Master
    sql_query(&quot; insert into `{$g5[&#039;faq_master_table&#039;]}` set fm_id = &#039;1&#039;, fm_subject = &#039;자주하시는 질문&#039; &quot;, false);
}

//자주하시는 질문 테이블이 있는지 검사한다.
if (!sql_query(&quot; DESCRIBE {$g5[&#039;faq_table&#039;]} &quot;, false)) {
    if (sql_query(&quot; DESCRIBE {$g5[&#039;g5_shop_faq_table&#039;]} &quot;, false)) {
        sql_query(&quot; ALTER TABLE {$g5[&#039;g5_shop_faq_table&#039;]} RENAME TO `{$g5[&#039;faq_table&#039;]}` ;&quot;, false);
    } else {
        $query_cp = sql_query(
            &quot; CREATE TABLE IF NOT EXISTS `{$g5[&#039;faq_table&#039;]}` (
                      `fa_id` int(11) NOT NULL AUTO_INCREMENT,
                      `fm_id` int(11) NOT NULL DEFAULT &#039;0&#039;,
                      `fa_subject` text NOT NULL,
                      `fa_content` text NOT NULL,
                      `fa_order` int(11) NOT NULL DEFAULT &#039;0&#039;,
                      PRIMARY KEY (`fa_id`),
                      KEY `fm_id` (`fm_id`)
                    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 &quot;,
            true
        );
    }
}

$g5[&#039;title&#039;] = &#039;FAQ관리&#039;;
require_once G5_ADMIN_PATH . &#039;/admin.head.php&#039;;

$sql_common = &quot; from {$g5[&#039;faq_master_table&#039;]} &quot;;

// 테이블의 전체 레코드수만 얻음
$sql = &quot; select count(*) as cnt &quot; . $sql_common;
$row = sql_fetch($sql);
$total_count = $row[&#039;cnt&#039;];

$rows = $config[&#039;cf_page_rows&#039;];
$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산
if ($page &lt; 1) {
    $page = 1;
} // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함

$sql = &quot;select * $sql_common order by fm_order, fm_id limit $from_record, {$config[&#039;cf_page_rows&#039;]} &quot;;
$result = sql_query($sql);
?&gt;

&lt;div class=&quot;local_ov01 local_ov&quot;&gt;
    &lt;?php if ($page &gt; 1) { ?&gt;
        &lt;a href=&quot;&lt;?php echo $_SERVER[&#039;SCRIPT_NAME&#039;]; ?&gt;&quot;&gt;처음으로&lt;/a&gt;
    &lt;?php } ?&gt;
    &lt;span class=&quot;btn_ov01&quot;&gt;&lt;span class=&quot;ov_txt&quot;&gt; 전체 FAQ &lt;/span&gt;&lt;span class=&quot;ov_num&quot;&gt; &lt;?php echo $total_count; ?&gt;건&lt;/span&gt;&lt;/span&gt;
&lt;/div&gt;

&lt;div class=&quot;local_desc01 local_desc&quot;&gt;
    &lt;ol&gt;
        &lt;li&gt;FAQ는 무제한으로 등록할 수 있습니다&lt;/li&gt;
        &lt;li&gt;&lt;strong&gt;FAQ추가&lt;/strong&gt;를 눌러 FAQ Master를 생성합니다. (하나의 FAQ 타이틀 생성 : 자주하시는 질문, 이용안내..등 )&lt;/li&gt;
        &lt;li&gt;생성한 FAQ Master 의 &lt;strong&gt;제목&lt;/strong&gt;을 눌러 세부 내용을 관리할 수 있습니다.&lt;/li&gt;
    &lt;/ol&gt;
&lt;/div&gt;

&lt;div class=&quot;btn_fixed_top&quot;&gt;
    &lt;a href=&quot;./faqmasterform.php&quot; class=&quot;btn_01 btn&quot;&gt;FAQ추가&lt;/a&gt;
&lt;/div&gt;

&lt;div class=&quot;tbl_head01 tbl_wrap&quot;&gt;
    &lt;table&gt;
        &lt;caption&gt;&lt;?php echo $g5[&#039;title&#039;]; ?&gt; 목록&lt;/caption&gt;
        &lt;thead&gt;
            &lt;tr&gt;
                &lt;th scope=&quot;col&quot;&gt;ID&lt;/th&gt;
                &lt;th scope=&quot;col&quot;&gt;제목&lt;/th&gt;
                &lt;th scope=&quot;col&quot;&gt;FAQ수&lt;/th&gt;
                &lt;th scope=&quot;col&quot;&gt;순서&lt;/th&gt;
                &lt;th scope=&quot;col&quot;&gt;관리&lt;/th&gt;
            &lt;/tr&gt;
        &lt;/thead&gt;
        &lt;tbody&gt;
            &lt;?php for ($i = 0; $row = sql_fetch_array($result); $i++) {
                $sql1 = &quot; select COUNT(*) as cnt from {$g5[&#039;faq_table&#039;]} where fm_id = &#039;{$row[&#039;fm_id&#039;]}&#039; &quot;;
                $row1 = sql_fetch($sql1);
                $cnt = $row1[&#039;cnt&#039;];
                $bg = &#039;bg&#039; . ($i % 2);
                ?&gt;
                &lt;tr class=&quot;&lt;?php echo $bg; ?&gt;&quot;&gt;
                    &lt;td class=&quot;td_num&quot;&gt;&lt;?php echo $row[&#039;fm_id&#039;]; ?&gt;&lt;/td&gt;
                    &lt;td class=&quot;td_left&quot;&gt;&lt;a href=&quot;./faqlist.php?fm_id=&lt;?php echo $row[&#039;fm_id&#039;]; ?&gt;&amp;amp;fm_subject=&lt;?php echo $row[&#039;fm_subject&#039;]; ?&gt;&quot;&gt;&lt;?php echo stripslashes($row[&#039;fm_subject&#039;]); ?&gt;&lt;/a&gt;&lt;/td&gt;
                    &lt;td class=&quot;td_num&quot;&gt;&lt;?php echo $cnt; ?&gt;&lt;/td&gt;
                    &lt;td class=&quot;td_num&quot;&gt;&lt;?php echo $row[&#039;fm_order&#039;] ?&gt;&lt;/td&gt;
                    &lt;td class=&quot;td_mng td_mng_l&quot;&gt;
                        &lt;a href=&quot;./faqmasterform.php?w=u&amp;amp;fm_id=&lt;?php echo $row[&#039;fm_id&#039;]; ?&gt;&quot; class=&quot;btn btn_03&quot;&gt;&lt;span class=&quot;sound_only&quot;&gt;&lt;?php echo stripslashes($row[&#039;fm_subject&#039;]); ?&gt; &lt;/span&gt;수정&lt;/a&gt;
                        &lt;a href=&quot;&lt;?php echo G5_BBS_URL; ?&gt;/faq.php?fm_id=&lt;?php echo $row[&#039;fm_id&#039;]; ?&gt;&quot; class=&quot;btn btn_02&quot;&gt;&lt;span class=&quot;sound_only&quot;&gt;&lt;?php echo stripslashes($row[&#039;fm_subject&#039;]); ?&gt; &lt;/span&gt;보기&lt;/a&gt;
                        &lt;a href=&quot;./faqmasterformupdate.php?w=d&amp;amp;fm_id=&lt;?php echo $row[&#039;fm_id&#039;]; ?&gt;&quot; onclick=&quot;return delete_confirm(this);&quot; class=&quot;btn btn_02&quot;&gt;&lt;span class=&quot;sound_only&quot;&gt;&lt;?php echo stripslashes($row[&#039;fm_subject&#039;]); ?&gt; &lt;/span&gt;삭제&lt;/a&gt;
                    &lt;/td&gt;
                &lt;/tr&gt;
                &lt;?php
            }

            if ($i == 0) {
                echo &#039;&lt;tr&gt;&lt;td colspan=&quot;5&quot; class=&quot;empty_table&quot;&gt;&lt;span&gt;자료가 한건도 없습니다.&lt;/span&gt;&lt;/td&gt;&lt;/tr&gt;&#039;;
            }
            ?&gt;
        &lt;/tbody&gt;
    &lt;/table&gt;
&lt;/div&gt;

&lt;?php echo get_paging(G5_IS_MOBILE ? $config[&#039;cf_mobile_pages&#039;] : $config[&#039;cf_write_pages&#039;], $page, $total_page, &quot;{$_SERVER[&#039;SCRIPT_NAME&#039;]}?$qstr&amp;amp;page=&quot;); ?&gt;

&lt;?php
require_once G5_ADMIN_PATH . &#039;/admin.tail.php&#039;;
</pre>