GNU/skin/board/outline_target/ajax.list.php



<title>GNU/skin/board/outline_target/ajax.list.php</title>


<div class="header">GNU/skin/board/outline_target/ajax.list.php</div>
<pre>&lt;?php
include_once(&#039;./_common.php&#039;);

// =================================================================
// 1. [구멍 뚫기] 오빠의 UPBIT DB (upbit_data) 연결
// =================================================================
include_once(&#039;/home/www/DB/db_upbit.php&#039;); 

if (!isset($pdo)) {
    die(&quot;오빠! ajax 호출인데 db_upbit.php 연결이 안 됐어!&quot;);
}
$db_upbit = $pdo; // ★ UPBIT 전용 DB 핸들러

$page = (int)$_GET[&#039;page&#039;];
if ($page &lt; 1) $page = 1;
$limit = 15;
$start = ($page - 1) * $limit;

$sql_where = &quot; WHERE wr_is_comment = &#039;0&#039; AND wr_parent = wr_id AND IFNULL(TRIM(x2_top), &#039;&#039;) &lt;&gt; &#039;1&#039; &quot;; // 댓글/답글 제외 + 상단 고정 제외

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;;
    }
}

// 필터 조건 반영
if($_GET[&#039;s_ca2&#039;]) $sql_where .= &quot; AND x2_ca2 = &#039;&quot;.sql_real_escape_string($_GET[&#039;s_ca2&#039;]).&quot;&#039; &quot;;
if($_GET[&#039;s_ca3&#039;]) $sql_where .= &quot; AND x2_ca3 = &#039;&quot;.sql_real_escape_string($_GET[&#039;s_ca3&#039;]).&quot;&#039; &quot;;
if($_GET[&#039;s_ca4&#039;]) $sql_where .= &quot; AND x2_ca4 = &#039;&quot;.sql_real_escape_string($_GET[&#039;s_ca4&#039;]).&quot;&#039; &quot;;
if($_GET[&#039;is_ing&#039;] == &#039;y&#039;) $sql_where .= &quot; AND x2_ca4 &lt;&gt; &#039;완료&#039; &quot;;
if($_GET[&#039;is_project&#039;] == &#039;y&#039;) $sql_where .= &quot; AND TRIM(IFNULL(x2_project, &#039;&#039;)) &lt;&gt; &#039;&#039; &quot;;
if($_GET[&#039;is_label&#039;] == &#039;y&#039;) $sql_where .= &quot; AND x2_label = &#039;1&#039; &quot;;

// 검색어(stx) 반영
$stx = isset($_GET[&#039;stx&#039;]) ? sql_real_escape_string($_GET[&#039;stx&#039;]) : &#039;&#039;;
if($stx) {
    $sql_where .= &quot; AND (wr_subject LIKE &#039;%{$stx}%&#039; OR wr_content LIKE &#039;%{$stx}%&#039;) &quot;;
}

$sql = &quot; SELECT * FROM {$write_table} {$sql_where} ORDER BY wr_id DESC LIMIT {$start}, {$limit} &quot;;
$result = sql_query($sql);

$i = 0;
while($row = sql_fetch_array($result)) {
    $delay = ($i * 0.04) + 0.1;
    $st_class = &quot;st_default&quot;;
    if($row[&#039;x2_ca4&#039;] == &quot;진행&quot;) $st_class = &quot;st_blue&quot;;
    else if($row[&#039;x2_ca4&#039;] == &quot;완료&quot;) $st_class = &quot;st_purple&quot;;
    
    $href = get_pretty_url($bo_table, $row[&#039;wr_id&#039;]);
    $clean_subject = preg_replace(&#039;/^\[[^\]]+\]\s*/&#039;, &#039;&#039;, $row[&#039;wr_subject&#039;]);
    $project_icon = work_project_icon($row[&#039;x2_project&#039;]);
?&gt;
&lt;tr onclick=&quot;location.href=&#039;&lt;?php echo $href; ?&gt;&#039;&quot; class=&quot;&lt;?php echo (!empty($row[&#039;x2_see&#039;]) &amp;&amp; $row[&#039;x2_see&#039;] == &#039;1&#039;) ? &#039;see-row&#039; : &#039;&#039;; ?&gt;&quot; style=&quot;animation: listFadeUp 0.6s ease forwards; animation-delay: &lt;?php echo $delay; ?&gt;s;&quot;&gt;
    &lt;td class=&quot;Num&quot;&gt;&lt;?php echo $row[&#039;wr_id&#039;]; ?&gt;&lt;/td&gt;
    &lt;td class=&quot;Subject&quot;&gt;
        &lt;?php echo $clean_subject; ?&gt;
        &lt;?php if ($row[&#039;wr_comment&#039;]) echo &quot;&lt;span class=&#039;subject-comment&#039;&gt;[&quot;.$row[&#039;wr_comment&#039;].&quot;]&lt;/span&gt;&quot;; ?&gt;
    &lt;/td&gt;
    &lt;td class=&quot;Day&quot;&gt;
        &lt;span class=&quot;item-icons&quot;&gt;
            &lt;?php if($project_icon) echo &#039;&lt;i class=&quot;&#039;.$project_icon.&#039;&quot; title=&quot;PROJECT: &#039;.get_text($row[&#039;x2_project&#039;]).&#039;&quot;&gt;&lt;/i&gt;&#039;; ?&gt;
            &lt;?php if($row[&#039;x2_label&#039;]) echo &#039;&lt;i class=&quot;fa-solid fa-star label-star-icon&quot; title=&quot;LABEL&quot;&gt;&lt;/i&gt;&#039;; ?&gt;
            &lt;?php if($row[&#039;wr_link1&#039;] || $row[&#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[&#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[&#039;x2_txt&#039;])) echo &#039;&lt;i class=&quot;fa-solid fa-code&quot; title=&quot;추가 코드&quot;&gt;&lt;/i&gt;&#039;; ?&gt;
            &lt;?php if(trim($row[&#039;x2_memo&#039;])) echo &#039;&lt;i class=&quot;fa-solid fa-note-sticky&quot; title=&quot;메모&quot;&gt;&lt;/i&gt;&#039;; ?&gt;
            &lt;?php if(trim($row[&#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[&#039;x2_ca4&#039;]) { ?&gt;&lt;span class=&quot;st_badge &lt;?php echo $st_class; ?&gt;&quot;&gt;&lt;?php echo $row[&#039;x2_ca4&#039;]; ?&gt;&lt;/span&gt;&lt;?php } ?&gt;
        &lt;?php echo substr($row[&#039;wr_datetime&#039;], 2, 8); ?&gt;
    &lt;/td&gt;
&lt;/tr&gt;
&lt;?php 
    $i++; 
} 
?&gt;</pre>