trans(trim($_REQUEST["search_keyword"])); $var_Page = $mod->trans(trim($_REQUEST["page"])); $search_language = "ENG"; $var_Num = $mod->trans(trim($_REQUEST["target"])); if ($search_division == "") $search_division = "ALL"; if ($search_language == "") $search_language = "ENG"; $var_SQL = "SELECT"; $var_SQL .= " BOARD_SEQ"; $var_SQL .= ", DIVISION"; $var_SQL .= ", SUBJECT"; $var_SQL .= ", CONTENT"; $var_SQL .= ", HIT"; $var_SQL .= ", NOTICE_YN"; $var_SQL .= ", EDITOR_YN"; $var_SQL .= ", VIEW_YN"; $var_SQL .= ", DEL_YN"; $var_SQL .= ", LANGUAGE_TYPE"; $var_SQL .= ", REG_DATE"; $var_SQL .= ", USER_NAME"; $var_SQL .= ", PASSWORD"; $var_SQL .= ", USER_DIVISION"; $var_SQL .= ", USER_SEQ"; $var_SQL .= ", ETC_1"; $var_SQL .= ", ETC_2"; $var_SQL .= ", ETC_3"; $var_SQL .= " FROM TB_BOARD_NOTICE "; $var_SQL .= " WHERE DEL_YN='N' AND BOARD_SEQ=?"; $stmt = $pdo->prepare($var_SQL); $stmt->bindParam(1, $var_Num); $stmt->execute(); $stmt->bindColumn(1, $col_board_seq); $stmt->bindColumn(2, $col_division); $stmt->bindColumn(3, $col_subject); $stmt->bindColumn(4, $col_content); $stmt->bindColumn(5, $col_hit); $stmt->bindColumn(6, $col_notice_yn); $stmt->bindColumn(7, $col_editor_yn); $stmt->bindColumn(8, $col_view_yn); $stmt->bindColumn(9, $col_del_yn); $stmt->bindColumn(10, $col_language_type); $stmt->bindColumn(11, $col_reg_date); $stmt->bindColumn(12, $col_user_name); $stmt->bindColumn(13, $col_password); $stmt->bindColumn(14, $col_user_division); $stmt->bindColumn(15, $col_user_seq); $stmt->bindColumn(16, $col_etc_1); $stmt->bindColumn(17, $col_etc_2); $stmt->bindColumn(18, $col_etc_3); $stmt->bindColumn(19, $col_admin_user_name); $stmt->bindColumn(20, $col_admin_user_id); $stmt->bindColumn(21, $col_file_count_attach_one); $stmt->bindColumn(22, $col_file_count_attach_images); $stmt->bindColumn(23, $col_file_count_attach_catalogue); $stmt->bindColumn(24, $col_file_count_attach_all); $stmt->fetch(PDO::FETCH_ASSOC); $stmt->closeCursor(); If ($col_notice_yn != "Y") { //아랫글 $var_SQL = " SELECT BOARD_SEQ, SUBJECT"; $var_SQL .= " FROM TB_BOARD_NOTICE A"; if ($BOARD_NOTICE) { $var_SQL .= " WHERE A.DEL_YN='N' AND A.NOTICE_YN='N'"; } else { $var_SQL .= " WHERE A.DEL_YN='N'"; } $var_SQL .= " AND A.DIVISION=:DIVISION"; $param[] = array(":DIVISION"=>$search_division); if ($BOARD_REG_DATE) { $var_SQL .= " AND REG_DATE < :REG_DATE"; $param[] = array(":REG_DATE"=>$col_reg_date); } else { $var_SQL .= " AND BOARD_SEQ < :BOARD_SEQ"; $param[] = array(":BOARD_SEQ"=>$var_Num); } if ($search_language != "") { $var_SQL .= " AND A.LANGUAGE_TYPE=:LANG_TYPE"; $param[] = array(":LANG_TYPE"=>$search_language); } if ($search_view_yn != "") { $var_SQL .= " AND A.VIEW_YN=:VIEW_YN"; $param[] = array(":VIEW_YN"=>$search_view_yn); } if ($search_keyword != "" && $search_field != "") { if ($search_field == "all") { $var_SQL .= " AND (SUBJECT LIKE CONCAT('%',:keyword1,'%') OR CONTENT LIKE CONCAT('%',:keyword2,'%'))"; $param[] = array(":keyword1"=>$search_keyword); $param[] = array(":keyword2"=>$search_keyword); } else if ($search_field == "user_name") { $var_SQL .= " AND (A.USER_SEQ IN (SELECT C.USER_SEQ FROM TB_USER C WHERE C.USER_NAME LIKE CONCAT('%',:keyword1,'%'))"; $var_SQL .= " OR A.USER_NAME LIKE CONCAT('%',:keyword2,'%'))"; $param[] = array(":keyword1"=>$search_keyword); $param[] = array(":keyword2"=>$search_keyword); } else { $var_SQL .= " AND ".$search_field." LIKE CONCAT('%',:keyword,'%')"; $param[] = array(":keyword"=>$search_keyword); } } if ($BOARD_REG_DATE) { $var_SQL .= " ORDER BY A.REG_DATE DESC, A.BOARD_SEQ DESC LIMIT 1"; } else { $var_SQL .= " ORDER BY BOARD_SEQ DESC LIMIT 1"; } $stmt = $mod->select($pdo, $var_SQL, $param); $stmt->bindColumn(1, $col_prev_seq); $stmt->bindColumn(2, $col_prev_sbjt); $stmt->fetch(PDO::FETCH_ASSOC); $stmt->closeCursor(); //윗글 $var_SQL = " SELECT BOARD_SEQ, SUBJECT"; $var_SQL .= " FROM TB_BOARD_NOTICE A"; if ($BOARD_NOTICE) { $var_SQL .= " WHERE A.DEL_YN='N' AND A.NOTICE_YN='N'"; } else { $var_SQL .= " WHERE A.DEL_YN='N'"; } $var_SQL .= " AND A.DIVISION=:DIVISION"; $param[] = array(":DIVISION"=>$search_division); if ($BOARD_REG_DATE) { $var_SQL .= " AND REG_DATE > :REG_DATE"; $param[] = array(":REG_DATE"=>$col_reg_date); } else { $var_SQL .= " AND BOARD_SEQ > :BOARD_SEQ"; $param[] = array(":BOARD_SEQ"=>$var_Num); } if ($search_language != "") { $var_SQL .= " AND A.LANGUAGE_TYPE=:LANG_TYPE"; $param[] = array(":LANG_TYPE"=>$search_language); } if ($search_view_yn != "") { $var_SQL .= " AND A.VIEW_YN=:VIEW_YN"; $param[] = array(":VIEW_YN"=>$search_view_yn); } if ($search_keyword != "" && $search_field != "") { if ($search_field == "all") { $var_SQL .= " AND (SUBJECT LIKE CONCAT('%',:keyword1,'%') OR CONTENT LIKE CONCAT('%',:keyword2,'%'))"; $param[] = array(":keyword1"=>$search_keyword); $param[] = array(":keyword2"=>$search_keyword); } else if ($search_field == "user_name") { $var_SQL .= " AND (A.USER_SEQ IN (SELECT C.USER_SEQ FROM TB_USER C WHERE C.USER_NAME LIKE CONCAT('%',:keyword1,'%'))"; $var_SQL .= " OR A.USER_NAME LIKE CONCAT('%',:keyword2,'%'))"; $param[] = array(":keyword1"=>$search_keyword); $param[] = array(":keyword2"=>$search_keyword); } else { $var_SQL .= " AND ".$search_field." LIKE CONCAT('%',:keyword,'%')"; $param[] = array(":keyword"=>$search_keyword); } } if ($BOARD_REG_DATE) { $var_SQL .= " ORDER BY A.REG_DATE ASC, A.BOARD_SEQ ASC LIMIT 1"; } else { $var_SQL .= " ORDER BY BOARD_SEQ ASC LIMIT 1"; } $stmt = $mod->select($pdo, $var_SQL, $param); $stmt->bindColumn(1, $col_next_seq); $stmt->bindColumn(2, $col_next_sbjt); $stmt->fetch(PDO::FETCH_ASSOC); $stmt->closeCursor(); } ?>
korust
inquiry
utims a3
celleon
ginoxell
cruise
careway
bettra

NEWS & EVENTS

tit($col_subject,200)?> DATE :
prepare($var_SQL); $stmt->bindParam(":BOARD_SEQ", $var_Num); $stmt->execute(); $totalc = $stmt->rowCount(); if ($totalc > 0) { for ($i = 0; $i < $totalc; $i++) { $rs = $stmt->fetch(PDO::FETCH_ASSOC); $col_file_seq = trim($rs["FILE_SEQ"]); $col_file_path = trim($rs["FILE_PATH"]); $col_file_name = trim($rs["FILE_NAME"]); $col_file_save = trim($rs["FILE_SAVE"]); $col_file_desc = trim($rs["FILE_DESC"]); $col_file_down_cnt = trim($rs["DOWN_COUNT"]); $col_file_regdate = trim($rs["REG_DATE"]); $attach_number = $i+1; ?>