public function index($offset = 0)
{
$columns = array(array('key' => 'name', 'title' => '名稱', 'sql' => 'name LIKE ?'));
$configs = array('admin', $this->get_class(), '%s');
$conditions = conditions($columns, $configs);
$limit = 25;
$total = ArticleTag::count(array('conditions' => $conditions));
$offset = $offset < $total ? $offset : 0;
$this->load->library('pagination');
$pagination = $this->pagination->initialize(array_merge(array('total_rows' => $total, 'num_links' => 5, 'per_page' => $limit, 'uri_segment' => 0, 'base_url' => '', 'page_query_string' => false, 'first_link' => '第一頁', 'last_link' => '最後頁', 'prev_link' => '上一頁', 'next_link' => '下一頁', 'full_tag_open' => '<ul class="pagination">', 'full_tag_close' => '</ul>', 'first_tag_open' => '<li>', 'first_tag_close' => '</li>', 'prev_tag_open' => '<li>', 'prev_tag_close' => '</li>', 'num_tag_open' => '<li>', 'num_tag_close' => '</li>', 'cur_tag_open' => '<li class="active"><a href="#">', 'cur_tag_close' => '</a></li>', 'next_tag_open' => '<li>', 'next_tag_close' => '</li>', 'last_tag_open' => '<li>', 'last_tag_close' => '</li>'), $configs))->create_links();
$tags = ArticleTag::find('all', array('offset' => $offset, 'limit' => $limit, 'order' => 'id DESC', 'conditions' => $conditions));
return $this->set_tab_index(1)->set_subtitle('文章類別列表')->load_view(array('tags' => $tags, 'pagination' => $pagination, 'columns' => $columns));
}
public function update()
{
if (!$this->has_post()) {
return redirect_message(array('admin', $this->get_class(), $this->article->id, 'edit'), array('_flash_message' => '非 POST 方法，錯誤的頁面請求。'));
}
$posts = OAInput::post();
$posts['content'] = OAInput::post('content', false);
$cover = OAInput::file('cover');
if (!((string) $this->article->cover || $cover)) {
return redirect_message(array('admin', $this->get_class(), $this->article->id, 'edit'), array('_flash_message' => '請選擇圖片(gif、jpg、png)檔案!', 'posts' => $posts));
}
if ($msg = $this->_validation_posts($posts)) {
return redirect_message(array('admin', $this->get_class(), $this->article->id, 'edit'), array('_flash_message' => $msg, 'posts' => $posts));
}
if ($columns = array_intersect_key($posts, $this->article->table()->columns)) {
foreach ($columns as $column => $value) {
$this->article->{$column} = $value;
}
}
$article = $this->article;
$update = ArticleTag::transaction(function () use($article, $cover) {
if (!$article->save()) {
return false;
}
if ($cover && !$article->cover->put($cover)) {
return false;
}
return true;
});
if (!$update) {
return redirect_message(array('admin', $this->get_class(), $this->article->id, 'edit'), array('_flash_message' => '更新失敗！', 'posts' => $posts));
}
$ori_ids = column_array($article->mappings, 'article_tag_id');
if (($del_ids = array_diff($ori_ids, $posts['tag_ids'])) && ($mappings = ArticleTagMapping::find('all', array('select' => 'id, article_tag_id', 'conditions' => array('article_id = ? AND article_tag_id IN (?)', $article->id, $del_ids))))) {
foreach ($mappings as $mapping) {
ArticleTagMapping::transaction(function () use($mapping) {
return $mapping->destroy();
});
}
}
if (($add_ids = array_diff($posts['tag_ids'], $ori_ids)) && ($tags = ArticleTag::find('all', array('select' => 'id', 'conditions' => array('id IN (?)', $add_ids))))) {
foreach ($tags as $tag) {
ArticleTagMapping::transaction(function () use($tag, $article) {
return verifyCreateOrm(ArticleTagMapping::create(Array_intersect_key(array('article_tag_id' => $tag->id, 'article_id' => $article->id), ArticleTagMapping::table()->columns)));
});
}
}
if ($article->sources) {
foreach ($article->sources as $source) {
ArticleSource::transaction(function () use($source) {
return $source->destroy();
});
}
}
if ($posts['sources']) {
foreach ($posts['sources'] as $i => $source) {
ArticleSource::transaction(function () use($i, $source, $article) {
return verifyCreateOrm(ArticleSource::create(array_intersect_key(array_merge($source, array('article_id' => $article->id, 'sort' => $i)), ArticleSource::table()->columns)));
});
}
}
$this->_clean_cell($article);
return redirect_message(($url = Session::getData('admin_articles_index_url')) ? $url : array('admin', $this->get_class()), array('_flash_message' => '更新成功！'));
}
