GNU/skin/board/work/list.skin.php



<title>GNU/skin/board/work/list.skin.php</title>


<div class="header">GNU/skin/board/work/list.skin.php</div>
<pre>&lt;?php
if (!defined(&#039;_GNUBOARD_&#039;)) exit;

// =================================================================
// 1. [구멍 뚫기] 오빠의 UPBIT DB (upbit_data) 연결
// =================================================================
include_once(&#039;/home/www/DB/db_upbit.php&#039;); 

// 혹시 몰라 연결 변수($db_upbit)가 제대로 살아있는지 확인 (혜정이의 센스)
if (!isset($pdo)) {
    die(&quot;오빠! db_upbit.php 파일은 불렀는데 연결이 안 됐어! 파일 다시 확인해줘!&quot;);
}
$db_upbit = $pdo; // ★ UPBIT 전용 DB 핸들러

// 상단 아이콘 및 폰트 추가 (원본 유지)
add_stylesheet(&#039;&lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css&quot;&gt;&#039;, 0);
add_stylesheet(&#039;&lt;link rel=&quot;stylesheet&quot; href=&quot;https://fonts.googleapis.com/css2?family=Orbitron:wght@400;700&amp;family=Noto+Sans+KR:wght@300;500&amp;display=swap&quot;&gt;&#039;, 0);
add_stylesheet(&#039;&lt;link rel=&quot;stylesheet&quot; href=&quot;&#039;.$board_skin_url.&#039;/style.list.css&quot;&gt;&#039;, 0);

error_reporting(E_ALL &amp; ~E_NOTICE);
ini_set(&#039;display_errors&#039;, &#039;0&#039;);

// bo_1, bo_2, bo_3 값을 배열로 변환 (셀렉트 메뉴용)
$ca2_list = explode(&#039;|&#039;, $board[&#039;bo_1&#039;]);
$ca3_list = explode(&#039;|&#039;, $board[&#039;bo_2&#039;]);
$ca4_list = explode(&#039;|&#039;, $board[&#039;bo_3&#039;]);

// 필터 및 검색 값 설정
$s_ca2 = isset($_GET[&#039;s_ca2&#039;]) ? $_GET[&#039;s_ca2&#039;] : &#039;&#039;;
$s_ca3 = isset($_GET[&#039;s_ca3&#039;]) ? $_GET[&#039;s_ca3&#039;] : &#039;&#039;;
$s_ca4 = isset($_GET[&#039;s_ca4&#039;]) ? $_GET[&#039;s_ca4&#039;] : &#039;&#039;;
$is_ing = isset($_GET[&#039;is_ing&#039;]) ? $_GET[&#039;is_ing&#039;] : &#039;&#039;;
$is_project = isset($_GET[&#039;is_project&#039;]) ? $_GET[&#039;is_project&#039;] : &#039;&#039;;
$is_label = isset($_GET[&#039;is_label&#039;]) ? $_GET[&#039;is_label&#039;] : &#039;&#039;;
$stx = isset($_GET[&#039;stx&#039;]) ? $_GET[&#039;stx&#039;] : &#039;&#039;;

if (!function_exists(&#039;work_project_icon&#039;)) {
    function work_project_icon($project_name) {
        $project_name = strtolower(trim((string)$project_name));
        if ($project_name === &#039;&#039;) return &#039;&#039;;
        if (strpos($project_name, &#039;api&#039;) !== false || strpos($project_name, &#039;server&#039;) !== false) return &#039;fa-solid fa-server&#039;;
        if (strpos($project_name, &#039;mobile&#039;) !== false || strpos($project_name, &#039;app&#039;) !== false) return &#039;fa-solid fa-mobile-screen-button&#039;;
        if (strpos($project_name, &#039;db&#039;) !== false || strpos($project_name, &#039;data&#039;) !== false) return &#039;fa-solid fa-database&#039;;
        if (strpos($project_name, &#039;web&#039;) !== false || strpos($project_name, &#039;site&#039;) !== false) return &#039;fa-solid fa-globe&#039;;
        return &#039;fa-solid fa-diagram-project&#039;;
    }
}

$list_params = array(
    &#039;bo_table&#039; =&gt; $bo_table,
    &#039;s_ca2&#039; =&gt; $s_ca2,
    &#039;s_ca3&#039; =&gt; $s_ca3,
    &#039;s_ca4&#039; =&gt; $s_ca4,
    &#039;is_ing&#039; =&gt; $is_ing,
    &#039;is_project&#039; =&gt; $is_project,
    &#039;is_label&#039; =&gt; $is_label,
    &#039;stx&#039; =&gt; $stx
);

$ing_toggle_url = G5_BBS_URL.&#039;/board.php?&#039;.http_build_query(array_merge($list_params, array(
    &#039;is_ing&#039; =&gt; ($is_ing == &#039;y&#039;) ? &#039;&#039; : &#039;y&#039;
)));
$project_toggle_url = G5_BBS_URL.&#039;/board.php?&#039;.http_build_query(array_merge($list_params, array(
    &#039;is_project&#039; =&gt; ($is_project == &#039;y&#039;) ? &#039;&#039; : &#039;y&#039;
)));
$label_toggle_url = G5_BBS_URL.&#039;/board.php?&#039;.http_build_query(array_merge($list_params, array(
    &#039;is_label&#039; =&gt; ($is_label == &#039;y&#039;) ? &#039;&#039; : &#039;y&#039;
)));

$sql_count_where = &quot; WHERE wr_is_comment = &#039;0&#039; AND wr_parent = wr_id &quot;;
if($s_ca2) $sql_count_where .= &quot; AND x2_ca2 = &#039;&quot;.sql_real_escape_string($s_ca2).&quot;&#039; &quot;;
if($s_ca3) $sql_count_where .= &quot; AND x2_ca3 = &#039;&quot;.sql_real_escape_string($s_ca3).&quot;&#039; &quot;;
if($s_ca4) $sql_count_where .= &quot; AND x2_ca4 = &#039;&quot;.sql_real_escape_string($s_ca4).&quot;&#039; &quot;;
if($is_ing == &#039;y&#039;) $sql_count_where .= &quot; AND x2_ca4 &lt;&gt; &#039;완료&#039; &quot;;
if($is_project == &#039;y&#039;) $sql_count_where .= &quot; AND TRIM(IFNULL(x2_project, &#039;&#039;)) &lt;&gt; &#039;&#039; &quot;;
if($is_label == &#039;y&#039;) $sql_count_where .= &quot; AND x2_label = &#039;1&#039; &quot;;
if($stx) {
    $stx_esc = sql_real_escape_string($stx);
    $sql_count_where .= &quot; AND (wr_subject LIKE &#039;%{$stx_esc}%&#039; OR wr_content LIKE &#039;%{$stx_esc}%&#039;) &quot;;
}

$total_count_row = sql_fetch(&quot;SELECT COUNT(*) AS cnt FROM {$write_table} {$sql_count_where}&quot;);
$total_count = isset($total_count_row[&#039;cnt&#039;]) ? (int)$total_count_row[&#039;cnt&#039;] : 0;

$memo_cards = array();
$memo_sql = &quot;SELECT wr_id, wr_subject, wr_datetime, x2_memo FROM {$write_table} WHERE wr_is_comment = &#039;0&#039; AND wr_parent = wr_id AND TRIM(IFNULL(x2_memo, &#039;&#039;)) &lt;&gt; &#039;&#039; AND IFNULL(x2_memo_clean, &#039;0&#039;) &lt;&gt; &#039;1&#039; ORDER BY wr_id DESC&quot;;
$memo_res = sql_query($memo_sql);
while($memo_row = sql_fetch_array($memo_res)) {
    $memo_plain = trim(preg_replace(&#039;/\s+/&#039;, &#039; &#039;, strip_tags($memo_row[&#039;x2_memo&#039;])));
    if ($memo_plain === &#039;&#039;) continue;
    if (function_exists(&#039;mb_substr&#039;)) {
        $memo_preview = mb_substr($memo_plain, 0, 110, &#039;UTF-8&#039;);
        if (mb_strlen($memo_plain, &#039;UTF-8&#039;) &gt; 110) $memo_preview .= &#039;...&#039;;
    } else {
        $memo_preview = substr($memo_plain, 0, 110);
        if (strlen($memo_plain) &gt; 110) $memo_preview .= &#039;...&#039;;
    }
    $memo_cards[] = array(
        &#039;wr_id&#039; =&gt; $memo_row[&#039;wr_id&#039;],
        &#039;subject&#039; =&gt; $memo_row[&#039;wr_subject&#039;],
        &#039;datetime&#039; =&gt; $memo_row[&#039;wr_datetime&#039;],
        &#039;preview&#039; =&gt; $memo_preview,
        &#039;href&#039; =&gt; get_pretty_url($bo_table, $memo_row[&#039;wr_id&#039;])
    );
}

// 데이터 로드 (원본 유지)
$new_board = sql_query(&quot;select * from $write_table where wr_is_comment = &#039;0&#039; AND wr_parent = wr_id order by wr_datetime desc limit 1&quot;);
$lat_board = sql_fetch_array($new_board);

// 그누보드 최근 게시물 100 개중 프로젝트 버튼 ON 게시물 중 최근 게시물 호출
$sql = &quot; SELECT wr_id FROM (
            SELECT wr_id, x2_project_bt FROM {$write_table} 
            WHERE wr_is_comment = 0 
            ORDER BY wr_id DESC 
            LIMIT 100
         ) AS t 
         WHERE x2_project_bt = &#039;1&#039; 
         ORDER BY wr_id DESC 
         LIMIT 1 &quot;;
$row = sql_fetch($sql);
// 최근 프로젝트 ON 게시물 중 최근 게시물 아이디로 호출
$sql = &quot; SELECT * FROM {$write_table} WHERE wr_id = {$row[&#039;wr_id&#039;]} &quot;;
$wr = sql_fetch($sql);
?&gt;

&lt;div id=&quot;SPACE_WRAP&quot;&gt;
    &lt;!-- 배경 --&gt;
    &lt;div class=&quot;nebula&quot;&gt;&lt;/div&gt;
    &lt;article id=&#039;LIST&#039;&gt;
        &lt;!-- 즐겨찾기 --&gt;
        &lt;section class=&quot;bar&quot;&gt;
            &lt;ul id=&quot;bm-bar&quot; style=&quot;display:none;&quot;&gt;
                &lt;li&gt;
                    &lt;a href=&quot;&lt;?php echo G5_BBS_URL;?&gt;/board.php?bo_table=daily&quot; target=&quot;_blank&quot;&gt;&lt;button type=&quot;button&quot; class=&quot;btn-admin&quot;&gt; 하루&lt;/button&gt;&lt;/a&gt;
                    &lt;a href=&quot;&lt;?php echo G5_BBS_URL;?&gt;/board.php?bo_table=memo&quot; target=&quot;_blank&quot;&gt;&lt;button type=&quot;button&quot; class=&quot;btn-admin&quot;&gt; 메모&lt;/button&gt;&lt;/a&gt;
                    &lt;a href=&quot;&lt;?php echo G5_BBS_URL;?&gt;/board.php?bo_table=server_setting&quot; target=&quot;_blank&quot;&gt;&lt;button type=&quot;button&quot; class=&quot;btn-admin&quot;&gt; 서버세팅&lt;/button&gt;&lt;/a&gt;
                    &lt;a href=&quot;&lt;?php echo G5_BBS_URL;?&gt;/board.php?bo_table=daemon_production&quot; target=&quot;_blank&quot;&gt;&lt;button type=&quot;button&quot; class=&quot;btn-admin&quot;&gt; 데몬제작&lt;/button&gt;&lt;/a&gt;
                    &lt;a href=&quot;&lt;?php echo G5_BBS_URL;?&gt;/board.php?bo_table=chatgpt&quot; target=&quot;_blank&quot;&gt;&lt;button type=&quot;button&quot; class=&quot;btn-admin&quot;&gt; 도움말&lt;/button&gt;&lt;/a&gt;
                &lt;/li&gt;
                &lt;li&gt;
                    &lt;?php if ($is_admin) { ?&gt;
                        &lt;button type=&quot;button&quot; class=&quot;btn-admin&quot; onclick=&quot;document.getElementById(&#039;popup&#039;).style.display=&#039;flex&#039;&quot;&gt; 보드옵션&lt;/button&gt;
                    &lt;?php } ?&gt;
                &lt;/li&gt;
                &lt;!-- 팝업 오버레이 --&gt;
                &lt;div id=&quot;popup&quot; class=&quot;pop_admin&quot;&gt;
                    &lt;div class=&quot;pop_box&quot;&gt;
                        &lt;div class=&quot;title&quot;&gt;
                            &lt;button onclick=&quot;document.getElementById(&#039;popup&#039;).style.display=&#039;none&#039;&quot;&gt;✕&lt;/button&gt;
                        &lt;/div&gt;
                        &lt;div&gt;
                            &lt;iframe src=&quot;&lt;?php echo $board_skin_url; ?&gt;/bo_admin.php?bo_table=&lt;?php echo $bo_table; ?&gt;&quot; width=&quot;900&quot; height=&quot;700&quot; frameborder=&quot;0&quot; style=&quot;display:block;&quot;&gt;&lt;/iframe&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
            &lt;/ul&gt;
            &lt;ul&gt;
                &lt;button type=&quot;button&quot; onclick=&quot;bmToggle()&quot;&gt;&lt;i class=&quot;fa-solid fa-star&quot;&gt;&lt;/i&gt; BOOKMARK&lt;/button&gt;
            &lt;/ul&gt;
        &lt;/section&gt;

        &lt;section class=&quot;TopTitle&quot;&gt;
            &lt;p&gt;&lt;?php echo strtoupper($bo_table); ?&gt;&lt;/p&gt;
            &lt;span&gt;&lt;i class=&quot;fa-solid fa-satellite&quot;&gt;&lt;/i&gt; &lt;?php echo $board[&quot;bo_subject&quot;]; ?&gt;&lt;/span&gt;
            &lt;div class=&quot;board-ver&quot;&gt;
                &lt;span class=&quot;board-total&quot;&gt;TOTAL &lt;?php echo number_format($total_count); ?&gt;&lt;/span&gt;
                &lt;?php if (!empty($lat_board[&#039;x2_ver&#039;])) { ?&gt;
                    &lt;span class=&quot;board-ver-sep&quot;&gt;|&lt;/span&gt;
                    &lt;span class=&quot;board-version&quot;&gt;VER &lt;?php echo get_text($lat_board[&#039;x2_ver&#039;]); ?&gt;&lt;/span&gt;
                &lt;?php } ?&gt;
            &lt;/div&gt;
        &lt;/section&gt;

        &lt;?php if ($wr[&#039;x2_project_bt&#039;]) { ?&gt;
            &lt;section class=&quot;project&quot; id=&quot;project-section&quot;&gt;
                &lt;ul&gt;
                    &lt;li&gt;
                        &lt;p&gt;&lt;i class=&quot;fa-solid fa-globe&quot;&gt;&lt;/i&gt; PROJECT&lt;/p&gt;
                        &lt;p&gt;&lt;?php echo nl2br(get_text($wr[&#039;x2_project_txt&#039;])); ?&gt;&lt;/p&gt;
                        &lt;p&gt;                            
                            &lt;a href=&quot;&lt;?php echo G5_BBS_URL;?&gt;/board.php?bo_table=work&amp;wr_id=&lt;?php echo $wr[&#039;wr_id&#039;]; ?&gt;&quot;&gt;&lt;button type=&quot;button&quot; class=&quot;bt_view&quot;&gt;&lt;i class=&quot;fa-solid fa-link&quot;&gt;&lt;/i&gt; VIEW&lt;/button&gt;&lt;/a&gt;
                            &lt;?php if ($wr[&#039;wr_link1&#039;] || $wr[&#039;wr_link2&#039;]) { ?&gt;
                                &lt;?php if ($wr[&#039;wr_link1&#039;]) { ?&gt;
                                    &lt;a href=&quot;&lt;?php echo $wr[&#039;wr_link1&#039;]; ?&gt;&quot; target=&quot;_blank&quot;&gt;&lt;button type=&quot;button&quot;&gt;&lt;i class=&quot;fa-solid fa-link&quot;&gt;&lt;/i&gt; LINK #1&lt;/button&gt;&lt;/a&gt;
                                &lt;?php } ?&gt;
                                &lt;?php if ($wr[&#039;wr_link2&#039;]) { ?&gt;
                                    &lt;a href=&quot;&lt;?php echo $wr[&#039;wr_link2&#039;]; ?&gt;&quot; target=&quot;_blank&quot;&gt;&lt;button type=&quot;button&quot;&gt;&lt;i class=&quot;fa-solid fa-link&quot;&gt;&lt;/i&gt; LINK #2&lt;/button&gt;&lt;/a&gt;
                                &lt;?php } ?&gt;
                            &lt;?php } ?&gt;
                        &lt;/p&gt;                        
                    &lt;/li&gt;
                &lt;/ul&gt;
            &lt;/section&gt;
            &lt;p class=&quot;pro_bt&quot;&gt;&lt;span id=&quot;links-toggle&quot; onclick=&quot;toggleLinks()&quot;&gt;&lt;i class=&quot;fa-solid fa-arrow-up&quot;&gt;&lt;/i&gt;PROJECT&lt;i class=&quot;fa-solid fa-arrow-down&quot;&gt;&lt;/i&gt;&lt;/span&gt;&lt;/p&gt;
        &lt;?php } ?&gt;


        &lt;div class=&quot;Control-Bar&quot;&gt;
            &lt;div class=&quot;Left control-left&quot;&gt;
                &lt;button type=&quot;button&quot; class=&quot;label-toggle-btn label-toggle-btn2&quot; onclick=&quot;$(&#039;#NoticeLayer&#039;).fadeIn();&quot;&gt;&lt;i class=&quot;fa-solid fa-bullhorn&quot;&gt;&lt;/i&gt; NOTICE&lt;/button&gt;
                
                &lt;select onchange=&quot;location.href=&#039;?bo_table=&lt;?php echo $bo_table ?&gt;&amp;s_ca2=&#039;+this.value+&#039;&amp;s_ca3=&lt;?php echo urlencode($s_ca3); ?&gt;&amp;s_ca4=&lt;?php echo urlencode($s_ca4); ?&gt;&amp;is_ing=&lt;?php echo urlencode($is_ing); ?&gt;&amp;is_project=&lt;?php echo urlencode($is_project); ?&gt;&amp;is_label=&lt;?php echo urlencode($is_label); ?&gt;&amp;stx=&lt;?php echo urlencode($stx); ?&gt;&#039;;&quot;&gt;
                    &lt;option value=&quot;&quot;&gt;KIND&lt;/option&gt;
                    &lt;?php foreach($ca2_list as $ca) { if(!trim($ca)) continue; $sel = ($s_ca2==$ca)?&quot;selected&quot;:&quot;&quot;; echo &quot;&lt;option value=&#039;&quot;.urlencode($ca).&quot;&#039; $sel&gt;$ca&lt;/option&gt;&quot;; } ?&gt;
                &lt;/select&gt;
                &lt;select onchange=&quot;location.href=&#039;?bo_table=&lt;?php echo $bo_table ?&gt;&amp;s_ca2=&lt;?php echo urlencode($s_ca2); ?&gt;&amp;s_ca3=&#039;+this.value+&#039;&amp;s_ca4=&lt;?php echo urlencode($s_ca4); ?&gt;&amp;is_ing=&lt;?php echo urlencode($is_ing); ?&gt;&amp;is_project=&lt;?php echo urlencode($is_project); ?&gt;&amp;is_label=&lt;?php echo urlencode($is_label); ?&gt;&amp;stx=&lt;?php echo urlencode($stx); ?&gt;&#039;;&quot;&gt;
                    &lt;option value=&quot;&quot;&gt;FORM&lt;/option&gt;
                    &lt;?php foreach($ca3_list as $ca) { if(!trim($ca)) continue; $sel = ($s_ca3==$ca)?&quot;selected&quot;:&quot;&quot;; echo &quot;&lt;option value=&#039;&quot;.urlencode($ca).&quot;&#039; $sel&gt;$ca&lt;/option&gt;&quot;; } ?&gt;
                &lt;/select&gt;
                &lt;select onchange=&quot;location.href=&#039;?bo_table=&lt;?php echo $bo_table ?&gt;&amp;s_ca2=&lt;?php echo urlencode($s_ca2); ?&gt;&amp;s_ca3=&lt;?php echo urlencode($s_ca3); ?&gt;&amp;s_ca4=&#039;+this.value+&#039;&amp;is_ing=&lt;?php echo urlencode($is_ing); ?&gt;&amp;is_project=&lt;?php echo urlencode($is_project); ?&gt;&amp;is_label=&lt;?php echo urlencode($is_label); ?&gt;&amp;stx=&lt;?php echo urlencode($stx); ?&gt;&#039;;&quot;&gt;
                    &lt;option value=&quot;&quot;&gt;STATE&lt;/option&gt;
                    &lt;?php foreach($ca4_list as $ca) { if(!trim($ca)) continue; $sel = ($s_ca4==$ca)?&quot;selected&quot;:&quot;&quot;; echo &quot;&lt;option value=&#039;&quot;.urlencode($ca).&quot;&#039; $sel&gt;$ca&lt;/option&gt;&quot;; } ?&gt;
                &lt;/select&gt;

                &lt;button type=&quot;button&quot; class=&quot;label-toggle-btn btn-project-filter &lt;?php echo ($is_project==&#039;y&#039;)?&#039;active&#039;:&#039;&#039; ?&gt;&quot; onclick=&quot;location.href=&#039;&lt;?php echo $project_toggle_url; ?&gt;&#039;&quot;&gt;
                    &lt;i class=&quot;fa-solid fa-diagram-project&quot;&gt;&lt;/i&gt; PROJECT
                &lt;/button&gt;

                &lt;button type=&quot;button&quot; class=&quot;label-toggle-btn btn-ing-filter &lt;?php echo ($is_ing==&#039;y&#039;)?&#039;active&#039;:&#039;&#039; ?&gt;&quot; onclick=&quot;location.href=&#039;&lt;?php echo $ing_toggle_url; ?&gt;&#039;&quot;&gt;
                    &lt;i class=&quot;fa-solid fa-bolt&quot;&gt;&lt;/i&gt; &lt;?php echo ($is_ing==&#039;y&#039;)?&#039;ING&#039;:&#039;ALL&#039; ?&gt;
                &lt;/button&gt;
                &lt;button type=&quot;button&quot; class=&quot;label-toggle-btn btn-label-filter &lt;?php echo ($is_label==&#039;y&#039;)?&#039;active&#039;:&#039;&#039; ?&gt;&quot; onclick=&quot;location.href=&#039;&lt;?php echo $label_toggle_url; ?&gt;&#039;&quot; title=&quot;LABEL&quot;&gt;
                    &lt;i class=&quot;fa-solid fa-star&quot;&gt;&lt;/i&gt;
                &lt;/button&gt;
                &lt;button type=&quot;button&quot; class=&quot;label-toggle-btn memo-note-btn&quot; id=&quot;memoPanelToggleBtn&quot; title=&quot;메모지&quot;&gt;
                    &lt;i class=&quot;fa-solid fa-note-sticky&quot;&gt;&lt;/i&gt; MEMO
                &lt;/button&gt;
            &lt;/div&gt;
            
            &lt;div class=&quot;Right control-right&quot;&gt;
                &lt;input type=&quot;text&quot; id=&quot;live_search&quot; value=&quot;&lt;?php echo stripslashes($stx); ?&gt;&quot; placeholder=&quot;LIVE SIGNAL...&quot; class=&quot;live-search-input&quot;&gt;
                &lt;button type=&quot;button&quot; class=&quot;label-toggle-btn label-toggle-btn2&quot; onclick=&quot;$(&#039;#SCH&#039;).css(&#039;display&#039;,&#039;flex&#039;).fadeIn();&quot;&gt;&lt;i class=&quot;fa-solid fa-magnifying-glass&quot;&gt;&lt;/i&gt; SEARCH&lt;/button&gt;

                &lt;?php if ($is_admin) { ?&gt;
                    &lt;button type=&quot;button&quot; onclick=&quot;location.href=&#039;&lt;?php echo G5_ADMIN_URL; ?&gt;/board_form.php?w=u&amp;bo_table=&lt;?php echo $bo_table; ?&gt;&#039;&quot; class=&quot;btn-admin&quot;&gt;&lt;i class=&quot;fa-solid fa-gear&quot;&gt;&lt;/i&gt; ADMIN&lt;/button&gt;
                &lt;?php } ?&gt;

                &lt;?php if ($write_href) { ?&gt;
                    &lt;button type=&quot;button&quot; onclick=&quot;location.href=&#039;&lt;?php echo $write_href; ?&gt;&#039;&quot; class=&quot;btn-write&quot;&gt;&lt;i class=&quot;fa-solid fa-pen&quot;&gt;&lt;/i&gt; WRITE&lt;/button&gt;
                &lt;?php } ?&gt;
            &lt;/div&gt;
        &lt;/div&gt;

        &lt;div id=&quot;TOP_FIXED_AREA&quot;&gt;
            &lt;table class=&quot;List-Table top-fixed-table&quot;&gt;
                &lt;tbody&gt;
                &lt;?php
                $sql_top_where = &quot; where wr_is_comment = &#039;0&#039; AND wr_parent = wr_id AND IFNULL(TRIM(x2_top), &#039;&#039;) = &#039;1&#039; &quot;;
                if($s_ca2) $sql_top_where .= &quot; AND x2_ca2 = &#039;&quot;.sql_real_escape_string($s_ca2).&quot;&#039; &quot;;
                if($s_ca3) $sql_top_where .= &quot; AND x2_ca3 = &#039;&quot;.sql_real_escape_string($s_ca3).&quot;&#039; &quot;;
                if($s_ca4) $sql_top_where .= &quot; AND x2_ca4 = &#039;&quot;.sql_real_escape_string($s_ca4).&quot;&#039; &quot;;
                if($is_ing == &#039;y&#039;) $sql_top_where .= &quot; AND x2_ca4 &lt;&gt; &#039;완료&#039; &quot;;
                if($is_project == &#039;y&#039;) $sql_top_where .= &quot; AND TRIM(IFNULL(x2_project, &#039;&#039;)) &lt;&gt; &#039;&#039; &quot;;
                if($is_label == &#039;y&#039;) $sql_top_where .= &quot; AND x2_label = &#039;1&#039; &quot;;
                if($stx) {
                    $stx_esc = sql_real_escape_string($stx);
                    $sql_top_where .= &quot; AND (wr_subject LIKE &#039;%{$stx_esc}%&#039; OR wr_content LIKE &#039;%{$stx_esc}%&#039;) &quot;;
                }

                $sql_top = &quot; select * from $write_table {$sql_top_where} order by wr_id desc &quot;;
                $res_top = sql_query($sql_top);
                while($row_t = sql_fetch_array($res_top)) {
                    $st_cl = ($row_t[&#039;x2_ca4&#039;] == &quot;진행&quot;) ? &quot;st_blue&quot; : (($row_t[&#039;x2_ca4&#039;] == &quot;완료&quot;) ? &quot;st_purple&quot; : &quot;st_default&quot;);
                    $href_t = get_pretty_url($bo_table, $row_t[&#039;wr_id&#039;]);
                    $project_icon_t = work_project_icon($row_t[&#039;x2_project&#039;]);
                ?&gt;
                &lt;tr onclick=&quot;location.href=&#039;&lt;?php echo $href_t; ?&gt;&#039;&quot; class=&quot;top-row &lt;?php echo (!empty($row_t[&#039;x2_see&#039;]) &amp;&amp; $row_t[&#039;x2_see&#039;] == &#039;1&#039;) ? &#039;see-row&#039; : &#039;&#039;; ?&gt;&quot;&gt;
                    &lt;td class=&quot;Num top-num&quot;&gt;&lt;i class=&quot;fa-solid fa-anchor&quot;&gt;&lt;/i&gt;&lt;/td&gt;
                    &lt;td class=&quot;Subject&quot;&gt;
                        &lt;strong&gt;&lt;?php echo $row_t[&#039;wr_subject&#039;]; ?&gt;&lt;/strong&gt;
                    &lt;/td&gt;
                    &lt;td class=&quot;Day&quot;&gt;
                        &lt;span class=&quot;item-icons&quot;&gt;
                            &lt;?php if(trim($row_t[&#039;x2_relay&#039;])) echo &#039;&lt;i class=&quot;fa-solid fa-bicycle relay-icon&quot; title=&quot;릴레이&quot;&gt;&lt;/i&gt;&#039;; ?&gt;
                            &lt;?php if($project_icon_t) echo &#039;&lt;i class=&quot;red-icon &#039;.$project_icon_t.&#039;&quot; title=&quot;PROJECT: &#039;.get_text($row_t[&#039;x2_project&#039;]).&#039;&quot; title=&quot;프로젝트&quot;&gt;&lt;/i&gt;&#039;; ?&gt;
                            &lt;?php if(trim($row_t[&#039;x2_project_bt&#039;])) echo &#039;&lt;i class=&quot;fa-solid fa-signs-post red-icon2&quot; title=&quot;프로젝트 타이틀&quot;&gt;&lt;/i&gt;&#039;; ?&gt;
                            &lt;?php if($row_t[&#039;x2_label&#039;]) echo &#039;&lt;i class=&quot;fa-solid fa-star label-star-icon&quot; title=&quot;라벨&quot;&gt;&lt;/i&gt;&#039;; ?&gt;
                            &lt;?php if($row_t[&#039;wr_link1&#039;] || $row_t[&#039;wr_link2&#039;]) echo &#039;&lt;i class=&quot;fa-solid fa-link&quot; title=&quot;링크&quot;&gt;&lt;/i&gt;&#039;; ?&gt;
                            &lt;?php if($row_t[&#039;wr_file&#039;]) echo &#039;&lt;i class=&quot;fa-solid fa-paperclip&quot; title=&quot;첨부파일&quot;&gt;&lt;/i&gt;&#039;; ?&gt;
                            &lt;?php if(trim($row_t[&#039;x2_txt&#039;])) echo &#039;&lt;i class=&quot;fa-solid fa-code code-icon&quot; title=&quot;추가 코드&quot;&gt;&lt;/i&gt;&#039;; ?&gt;
                            &lt;?php if(trim($row_t[&#039;x2_memo&#039;])) echo &#039;&lt;i class=&quot;fa-solid fa-note-sticky memo-icon&quot; title=&quot;메모&quot;&gt;&lt;/i&gt;&#039;; ?&gt;
                            &lt;?php if(trim($row_t[&#039;x2_line&#039;])) echo &#039;&lt;i class=&quot;fa-solid fa-list-check&quot; title=&quot;작업라인&quot;&gt;&lt;/i&gt;&#039;; ?&gt;
                        &lt;/span&gt;
                        &lt;?php if($row_t[&#039;x2_ca4&#039;]) { ?&gt;&lt;span class=&quot;st_badge &lt;?php echo $st_cl; ?&gt;&quot;&gt;&lt;?php echo $row_t[&#039;x2_ca4&#039;]; ?&gt;&lt;/span&gt;&lt;?php } ?&gt;
                        &lt;?php echo substr($row_t[&#039;wr_datetime&#039;], 2, 8); ?&gt;
                    &lt;/td&gt;
                &lt;/tr&gt;
                &lt;?php } ?&gt;
                &lt;/tbody&gt;
            &lt;/table&gt;
        &lt;/div&gt;

        &lt;form name=&quot;fboardlist&quot; id=&quot;fboardlist&quot; action=&quot;./board_list_update.php&quot; method=&quot;post&quot;&gt;
            &lt;table class=&quot;List-Table&quot;&gt;
                &lt;tbody id=&quot;board-list-body&quot;&gt;&lt;/tbody&gt;
            &lt;/table&gt;
        &lt;/form&gt;

        &lt;div id=&quot;list_loader&quot; class=&quot;list-loader&quot;&gt;
            &lt;i class=&quot;fa-solid fa-spinner fa-spin fa-2x&quot;&gt;&lt;/i&gt;
        &lt;/div&gt;

        &lt;aside id=&quot;memo_side_panel&quot; class=&quot;memo-side-panel&quot; aria-hidden=&quot;true&quot;&gt;
            &lt;div class=&quot;memo-panel-head&quot;&gt;
                &lt;div class=&quot;memo-panel-title&quot;&gt;&lt;i class=&quot;fa-solid fa-note-sticky&quot;&gt;&lt;/i&gt; MENO&lt;/div&gt;
                &lt;button type=&quot;button&quot; class=&quot;memo-panel-close&quot; id=&quot;memoPanelCloseBtn&quot;&gt;&lt;i class=&quot;fa-solid fa-xmark&quot;&gt;&lt;/i&gt;&lt;/button&gt;
            &lt;/div&gt;

            &lt;div class=&quot;memo-panel-layout-wrap&quot;&gt;
                &lt;button type=&quot;button&quot; class=&quot;memo-layout-switch&quot; id=&quot;memoLayoutToggle&quot; aria-pressed=&quot;false&quot;&gt;
                    &lt;span class=&quot;memo-layout-label memo-layout-label-1&quot;&gt;1x1&lt;/span&gt;
                    &lt;span class=&quot;memo-layout-thumb&quot;&gt;&lt;/span&gt;
                    &lt;span class=&quot;memo-layout-label memo-layout-label-2&quot;&gt;1x2&lt;/span&gt;
                &lt;/button&gt;
                &lt;span class=&quot;memo-total-text&quot;&gt;TOTAL : &lt;?php echo number_format(count($memo_cards)); ?&gt;&lt;/span&gt;
            &lt;/div&gt;

            &lt;div class=&quot;memo-card-list layout-1&quot; id=&quot;memoCardList&quot;&gt;
                &lt;?php if (!empty($memo_cards)) { ?&gt;
                    &lt;?php foreach ($memo_cards as $memo_card) { ?&gt;
                    &lt;article class=&quot;memo-card-item&quot;&gt;
                        &lt;div class=&quot;memo-card-date&quot;&gt;&lt;?php echo date(&#039;Y-m-d H:i&#039;, strtotime($memo_card[&#039;datetime&#039;])); ?&gt;&lt;/div&gt;
                        &lt;div class=&quot;memo-card-content&quot;&gt;&lt;?php echo get_text($memo_card[&#039;preview&#039;]); ?&gt;&lt;/div&gt;
                        &lt;a href=&quot;&lt;?php echo $memo_card[&#039;href&#039;]; ?&gt;&quot; class=&quot;memo-card-link&quot;&gt;VIEW POST&lt;/a&gt;
                    &lt;/article&gt;
                    &lt;?php } ?&gt;
                &lt;?php } else { ?&gt;
                    &lt;div class=&quot;memo-empty&quot;&gt;표시할 메모가 없습니다.&lt;/div&gt;
                &lt;?php } ?&gt;
            &lt;/div&gt;
        &lt;/aside&gt;

        &lt;div id=&quot;NoticeLayer&quot; class=&quot;NoticeLayer&quot;&gt;
            &lt;h3 class=&quot;notice-title&quot;&gt;&lt;i class=&quot;fa-solid fa-terminal&quot;&gt;&lt;/i&gt; SYSTEM NOTICE&lt;/h3&gt;
            &lt;div class=&quot;notice-content&quot;&gt;
                &lt;?php echo nl2br(stripslashes($board[&#039;notice&#039;])); // notice.php에서 저장하는 컬럼으로 수정 ?&gt;
            &lt;/div&gt;
            &lt;div class=&quot;notice-actions&quot;&gt;
                &lt;?php if ($is_admin) { ?&gt;
                    &lt;button type=&quot;button&quot; onclick=&quot;const w=800, h=850; const left=(screen.availWidth-w)/2, top=(screen.availHeight-h)/2; window.open(&#039;&lt;?php echo $board_skin_url;?&gt;/notice.php?bo_table=&lt;?php echo $bo_table;?&gt;&#039;, &#039;notice_win&#039;, &#039;width=&#039;+w+&#039;,height=&#039;+h+&#039;,left=&#039;+left+&#039;,top=&#039;+top+&#039;,scrollbars=yes&#039;);&quot; class=&quot;btn-edit-notice&quot;&gt;EDIT NOTICE&lt;/button&gt;
                &lt;?php } ?&gt;
                &lt;button type=&quot;button&quot; class=&quot;btn-edit-notice-dis&quot; onclick=&quot;$(&#039;#NoticeLayer&#039;).fadeOut();&quot;&gt;DISMISS&lt;/button&gt;
            &lt;/div&gt;
        &lt;/div&gt;

        &lt;section id=&quot;SCH&quot; class=&quot;Search&quot;&gt;
            &lt;div class=&quot;search-modal-box&quot;&gt;
                &lt;form name=&quot;fsearch&quot; method=&quot;get&quot;&gt;
                    &lt;input type=&quot;hidden&quot; name=&quot;bo_table&quot; value=&quot;&lt;?php echo $bo_table; ?&gt;&quot;&gt;
                    &lt;h3 class=&quot;search-title&quot;&gt;TERMINAL SEARCH&lt;/h3&gt;
                    &lt;input type=&quot;text&quot; name=&quot;stx&quot; value=&quot;&lt;?php echo stripslashes($stx); ?&gt;&quot; required placeholder=&quot;Keyword entry...&quot; class=&quot;search-input&quot;&gt;
                    &lt;div class=&quot;search-actions&quot;&gt;
                        &lt;button type=&quot;submit&quot; class=&quot;btn-search-submit&quot;&gt;EXECUTE&lt;/button&gt;
                        &lt;button type=&quot;button&quot; onclick=&quot;$(&#039;#SCH&#039;).fadeOut();&quot; class=&quot;btn-search-cancel&quot;&gt;CANCEL&lt;/button&gt;
                    &lt;/div&gt;
                &lt;/form&gt;
            &lt;/div&gt;
        &lt;/section&gt;
    &lt;/article&gt;
&lt;/div&gt;

&lt;?php include_once(&quot;{$board_skin_path}/list/list.script.php&quot;); ?&gt;</pre>