PHP Tpl::factory方法代码示例

 /**
  * Action tutorial
  */
 public function action_tutorial()
 {
     $file = 'tutorial' . $this->request->param('key', 1);
     /**
      * View
      */
     // Get content file and Factory
     $content_file = Tpl::get_file($file, $this->settings->back_tpl_dir . '/home', $this->partials);
     $this->content = Tpl::factory($content_file);
 }

 /**
  * Generate a Response for the 500 Exception.
  *
  * Internal
  * The user should be shown a nice 500 page.
  *
  * @return Response
  */
 public function get_response()
 {
     // Lets log the Exception, Just in case it's important!
     Kohana_Exception::log($this);
     if (Kohana::$environment >= Kohana::DEVELOPMENT) {
         // Show the normal Kohana error page.
         return parent::get_response();
     } else {
         // Get tpl directory
         $front_tpl_dir = Cms_Helper::settings('front_tpl_dir');
         // Get file
         $content_file = Tpl::get_file($this->code, $front_tpl_dir . '/error');
         // Set variable and render
         $content = Tpl::factory($content_file)->set('code', $this->getCode())->set('message', $this->getMessage())->set('request_url', URL::site(Request::current()->url(), "http"))->render();
         // Factory response
         $response = Response::factory();
         $response->body($content);
         return $response;
     }
 }

 /**
  * Action index
  */
 public function action_index()
 {
     /*
      * Build columns
      */
     // <editor-fold defaultstate="collapsed" desc="Build columns">
     // Get order
     $query = $this->request->query();
     $order_column = Arr::get($query, 'order_column', 'created');
     $order_direction = Arr::get($query, 'order_direction', 'DESC');
     // Build columns
     $columns = array(array('name' => 'id', 'order_column' => 'id', 'order_direction' => 'ASC'), array('name' => 'item segment', 'order_column' => 'item_segment', 'order_direction' => 'ASC'), array('name' => 'item title', 'order_column' => 'item_title', 'order_direction' => 'ASC'), array('name' => 'item id', 'order_column' => 'item_id', 'order_direction' => 'ASC'), array('name' => 'user id', 'order_column' => 'user_id', 'order_direction' => 'ASC'), array('name' => 'replay id', 'order_column' => 'replay_id', 'order_direction' => 'ASC'), array('name' => 'display name', 'order_column' => 'display_name', 'order_direction' => 'ASC'), array('name' => 'subject', 'order_column' => 'subject', 'order_direction' => 'ASC'), array('name' => 'created', 'order_column' => 'created', 'order_direction' => 'ASC'), array('name' => 'is accept', 'order_column' => 'is_accept', 'order_direction' => 'ASC'));
     foreach ($columns as &$column) {
         if (isset($column['order_column'])) {
             if ($column['order_column'] == $order_column) {
                 $column['current'] = TRUE;
                 if ($order_direction == 'ASC') {
                     $column['order_direction'] = 'DESC';
                     $column['current_asc'] = TRUE;
                 } else {
                     $column['order_direction'] = 'ASC';
                     $column['current_desc'] = TRUE;
                 }
             }
             $column['url'] = URL::base(TRUE) . Request::current()->uri() . URL::query(array('order_column' => $column['order_column'], 'order_direction' => $column['order_direction']), FALSE);
         }
     }
     // </editor-fold>
     /*
      * If delete
      */
     // <editor-fold defaultstate="collapsed" desc="If delete">
     if ($this->request->post('delete')) {
         // Database transaction start
         Database::instance()->begin();
         // Try
         try {
             // Get delete received comment ids
             $delete_received_comment_ids = Arr::get($this->request->post(), 'delete_received_comment_id', array());
             // Iterate and chack and delete
             foreach ($delete_received_comment_ids as $delete_received_comment_id) {
                 // Get received comment
                 $received_comment = Tbl::factory('received_comments')->get($delete_received_comment_id);
                 // Delete
                 $received_comment->delete();
             }
             // Database commit
             Database::instance()->commit();
             // Add success notice
             if ($delete_received_comment_ids) {
                 Notice::add(Notice::SUCCESS, Kohana::message('general', 'delete_success'));
             } else {
                 Notice::add(Notice::SUCCESS, Kohana::message('general', 'no_delete'), array(':text' => 'emil'));
             }
         } catch (HTTP_Exception_302 $e) {
             $this->redirect($e->location());
         } catch (Warning_Exception $e) {
             // Database rollback
             Database::instance()->rollback();
             // Add
             Notice::add(Notice::WARNING, $e->getMessage());
         } catch (Exception $e) {
             // Database rollback
             Database::instance()->rollback();
             // Add error notice
             Notice::add(Notice::ERROR, $e->getMessage() . $e->getFile() . $e->getLine());
         }
     }
     // </editor-fold>
     /*
      * Get received_comments
      */
     // <editor-fold defaultstate="collapsed" desc="Get received_comments">
     $all_received_comments = Tbl::factory('received_comments')->select('received_comments.*')->select(array('items.segment', 'item_segment'))->select(array('items.title', 'item_title'))->join('items')->on('received_comments.item_id', '=', 'items.id')->order_by($order_column, $order_direction)->read()->as_array();
     $pagenate = Pgn::factory(array('total_items' => count($all_received_comments), 'items_per_page' => $this->settings->pagenate_items_per_page_for_received_comments, 'follow' => $this->settings->pagenate_items_follow_for_received_comments));
     // Paginated items
     $received_comments = array_slice($all_received_comments, $pagenate->offset, $pagenate->items_per_page);
     foreach ($received_comments as $received_comment) {
         $received_comment->delete_url = URL::site("{$this->settings->backend_name}/received_comments/delete/{$received_comment->id}", 'http') . URL::query();
     }
     // </editor-fold>
     /*
      * If update
      */
     // <editor-fold defaultstate="collapsed" desc="If update">
     if ($this->request->post('update')) {
         $post = $this->request->post();
         // Set post to tag
         foreach ($received_comments as $received_comment) {
             $received_comment->is_accept = isset($post['is_accept'][$received_comment->id]) ? $post['is_accept'][$received_comment->id] : 0;
         }
         // Database transaction start
         Database::instance()->begin();
         // Try
         try {
             // Update
             foreach ($received_comments as $received_comment) {
//.........这里部分代码省略.........

 /**
  * Action login
  */
 public function action_login()
 {
     $post = $this->request->post();
     $username = Arr::get($post, 'username');
     $password = Arr::get($post, 'password');
     $remember = Arr::get($post, 'remember') ?: 0;
     // If there is post login
     if ($this->request->post('login')) {
         // ログインチェック
         if (Auth::instance()->login($username, $password, $remember)) {
             // ロールチェック
             if (Auth::instance()->logged_in('direct') or Auth::instance()->logged_in('admin') or Auth::instance()->logged_in('edit')) {
                 // Add success notice
                 Notice::add(Notice::SUCCESS, Kohana::message('auth', 'login_success'), array(':user' => $username));
                 // Redirect to home
                 $this->redirect(URL::site($this->settings->backend_name, 'http'));
             } else {
                 // Add error notice
                 Notice::add(Notice::ERROR, Kohana::message('auth', 'login_refusal'), NULL, Kohana::message('auth', 'login_refusal_messages'));
             }
         } else {
             // Add error notice
             Notice::add(Notice::ERROR, Kohana::message('auth', 'login_failed'), NULL, Kohana::message('auth', 'login_failed_messages'));
         }
     }
     /**
      * View
      */
     // Get content
     $content_file = Tpl::get_file('login', $this->settings->back_tpl_dir . '/auth');
     $this->content = Tpl::factory($content_file)->set('post', $post);
 }

 /**
  * Action index
  */
 public function action_index()
 {
     //		//---------------------------------------------------------------//
     //		if (Kohana::$profiling === TRUE)
     //		{
     //			// Start a new benchmark
     //			$benchmark = Profiler::start('check', __FUNCTION__);
     //		}
     //		//Do some stuff--------------------------------------------------//
     //		try
     //		{
     //
     //		}
     //		catch (Exception $e)
     //		{
     //			echo Debug::vars($e);
     //		}
     //
     //
     //		//Do some stuff--------------------------------------------------//
     //		if (isset($benchmark))
     //		{
     //			// Stop the benchmark
     //			Profiler::stop($benchmark);
     //		}
     //		echo View::factory('profiler/stats');
     //		//---------------------------------------------------------------//
     /**
      * Get settings
      */
     // <editor-fold defaultstate="collapsed" desc="Get settings">
     $settings = Cms_Helper::settings();
     // </editor-fold>
     /**
      * Lang
      */
     // <editor-fold defaultstate="collapsed" desc="Lang">
     I18n::lang($settings->lang);
     // </editor-fold>
     /**
      * Get item：セグメントからURLを取得　間はなんでもOK　でもセグメントはユニーク
      */
     // <editor-fold defaultstate="collapsed" desc="Get segment and item">
     // Get item
     $item = Cms_Functions::get_item($this->request->param('segment'), TRUE, TRUE, FALSE);
     // Check issued
     if (Date::formatted_time($item->issued, 'U') > time()) {
         $item = FALSE;
     }
     // itemがないとき（false）は404へ飛ばす
     if (!$item) {
         throw HTTP_Exception::factory(404);
     }
     // </editor-fold>
     /**
      * If login
      */
     // <editor-fold defaultstate="collapsed" desc="If login">
     // If switch and post ログイン機能ONのときポストがあったら
     if ($settings->author_login_is_on and $this->request->post('login')) {
         $this->login_result = Cms_Item::login($this->request->post());
     }
     // </editor-fold>
     /**
      * login check：ログインのチェック
      */
     // <editor-fold defaultstate="collapsed" desc="login check">
     // ログインのチェック
     if (Auth::instance()->logged_in()) {
         // Get user from auth
         $get_user = Auth::instance()->get_user();
         // Build logged_in_user
         $this->logged_in_user = (object) array('id' => $get_user->id, 'email' => $get_user->email, 'username' => $get_user->username, 'logins' => $get_user->logins, 'last_login' => $get_user->last_login, 'ext' => $get_user->ext, 'avatar' => FALSE, 'detail' => FALSE, 'role' => FALSE);
         // Set logged in user avatar
         if (is_file('application/' . Cms_Helper::settings('image_dir') . '/user/' . $get_user->username . '/avatar' . $get_user->ext)) {
             $this->logged_in_user->avatar = (object) array('path' => URL::site("imagefly", 'http') . '/user/' . $get_user->username . '/', 'file' => '/' . 'avatar' . $get_user->ext);
         }
         // Set logged in user detail
         $this->logged_in_user->detail = Tbl::factory('users_details')->join('details')->on('users_details.detail_id', '=', 'details.id')->select('users_details.*')->select('details.name')->select('details.segment')->where('users_details.user_id', '=', $get_user->id)->read()->as_array('segment');
         // Set logged in user role
         $this->logged_in_user->role = Tbl::factory('roles_users')->select('roles.*')->join('roles')->on('roles_users.role_id', '=', 'roles.id')->where('roles_users.user_id', '=', $get_user->id)->where('roles.name', '!=', 'login')->read('name');
     }
     // </editor-fold>
     /**
      * Set global value
      */
     // <editor-fold defaultstate="collapsed" desc="Set global value">
     // Get site details
     $site = array();
     $site_detail_string = explode("\n", $settings->site_details);
     if ($site_detail_string) {
         foreach ($site_detail_string as $value) {
             $array = explode(':', $value);
             $site[trim($array[0])] = trim($array[1]);
         }
     }
     // Build logged_in_user
//.........这里部分代码省略.........

 /**
  * Action edit
  */
 public function action_edit()
 {
     // Get id from param, if there is nothing then throw to 404
     $id = $this->request->param('key');
     if (!$id) {
         throw HTTP_Exception::factory(404);
     }
     // Get wrapper, if there is nothing then throw to 404
     $wrapper = Tbl::factory('wrappers')->where('id', '=', $id)->read(1);
     if (!$wrapper) {
         throw HTTP_Exception::factory(404);
     }
     // Get content from file and direct set to wrppaer
     $wrapper->content = Tpl::get_file($wrapper->segment, $this->settings->front_tpl_dir . '/wrapper');
     $wrapper->delete_url = URL::site("{$this->settings->backend_name}/wrappers/delete/{$wrapper->id}", 'http');
     // Save present segment
     $oldfile = "wrapper/{$wrapper->segment}";
     // If there are post
     if ($this->request->post()) {
         // Set post to wrapper
         $wrapper->segment = $this->request->post('segment');
         $wrapper->name = $this->request->post('name');
         $wrapper->content_type = $this->request->post('content_type');
         $wrapper->content = $this->request->post('content');
         // Database transaction start
         Database::instance()->begin();
         // Try
         try {
             // Update
             Tbl::factory('wrappers')->get($wrapper->id)->update(array('segment' => $this->request->post('segment'), 'name' => $this->request->post('name'), 'content_type' => $this->request->post('content_type')));
             // New file
             $newfile = "wrapper/{$wrapper->segment}";
             // rename file
             Cms_Helper::rename_file($oldfile, $newfile, $this->settings->front_tpl_dir);
             // Update file
             Cms_Helper::set_file($newfile, $this->settings->front_tpl_dir, $this->request->post('content'));
             // Database commit
             Database::instance()->commit();
             // Add success notice
             Notice::add(Notice::SUCCESS, Kohana::message('general', 'update_success'));
         } catch (HTTP_Exception_302 $e) {
             $this->redirect($e->location());
         } catch (Validation_Exception $e) {
             // Database rollback
             Database::instance()->rollback();
             // Add validation notice
             Notice::add(Notice::VALIDATION, Kohana::message('general', 'update_failed'), NULL, $e->errors('validation'));
         } catch (Exception $e) {
             // Database rollback
             Database::instance()->rollback();
             // Add error notice
             Notice::add(Notice::ERROR, $e->getMessage());
         }
     }
     /**
      * View
      */
     $content_file = Tpl::get_file('edit', $this->settings->back_tpl_dir . '/wrappers', $this->partials);
     $this->content = Tpl::factory($content_file)->set('wrapper', $wrapper);
 }

 /**
  * Action details
  */
 public function action_detail()
 {
     // Get id from param, if there is nothing then throw to 404
     $id = $this->request->param('key');
     if (!$id) {
         throw HTTP_Exception::factory(404);
     }
     // Get user, if there is nothing then throw to 404
     $user = Tbl::factory('users')->get($id);
     if (!$user) {
         throw HTTP_Exception::factory(404);
     }
     /**
      * Get and build details
      */
     // <editor-fold defaultstate="collapsed" desc="Get and build details">
     $details = Tbl::factory('users_details')->select('users_details.*')->select(array('details.segment', 'segment'))->select(array('details.name', 'name'))->join('details')->on('users_details.detail_id', '=', 'details.id')->where('users_details.user_id', '=', $user->id)->order_by('order')->read()->as_array('segment');
     // </editor-fold>
     /**
      * If there are post
      */
     if ($this->request->post()) {
         // Database transaction start
         Database::instance()->begin();
         // Try
         try {
             // Get rules
             $rules = Tbl::factory('detail_rules')->join('details')->on('detail_rules.detail_id', '=', 'details.id')->read()->as_array();
             // Set post to details
             foreach ($this->request->post() as $key => $value) {
                 if ($key != 'update') {
                     $details[$key]->value = $value;
                 }
             }
             /*
              * validation
              */
             // <editor-fold defaultstate="collapsed" desc="validation">
             // convert to array for validation
             $posts = array();
             foreach ($details as $key => $detail) {
                 $posts[$key] = $detail->value;
             }
             // Validation factory
             $validation = Validation::factory($posts);
             // Iterate post set rule and label
             foreach ($rules as $rule) {
                 // if param is null or 0 or ''
                 if (!$rule->param) {
                     $rule->param = NULL;
                 } elseif (strpos($rule->param, ',') === FALSE) {
                     $rule->param = array(trim($rule->param));
                 } else {
                     $rule->param = array($param[] = trim(substr($rule->param, 0, strpos($rule->param, ','))), $param[] = trim(substr($rule->param, strpos($rule->param, ',') + 1)));
                 }
                 $validation->rule($rule->segment, $rule->callback, $rule->param)->label($rule->segment, __($rule->name));
             }
             // If validation check is false
             if (!$validation->check()) {
                 throw new Validation_Exception($validation);
             }
             // </editor-fold>
             foreach ($details as $detail) {
                 Tbl::factory('users_details')->get($detail->id)->update(array('value' => $detail->value));
             }
             /**
              * Get and build details
              */
             // <editor-fold defaultstate="collapsed" desc="Get and build details">
             $details = Tbl::factory('users_details')->select('users_details.*')->select(array('details.segment', 'segment'))->select(array('details.name', 'name'))->join('details')->on('users_details.detail_id', '=', 'details.id')->where('users_details.user_id', '=', $user->id)->order_by('order')->read()->as_array('segment');
             // </editor-fold>
             /**
              * Database commit
              */
             Database::instance()->commit();
             // Add success notice
             Notice::add(Notice::SUCCESS, Kohana::message('general', 'update_success'));
         } catch (HTTP_Exception_302 $e) {
             $this->redirect($e->location());
         } catch (Validation_Exception $e) {
             // Database rollback
             Database::instance()->rollback();
             // Add validation notice
             Notice::add(Notice::VALIDATION, Kohana::message('general', 'update_failed'), NULL, $e->errors('validation'));
         } catch (Exception $e) {
             // Database rollback
             Database::instance()->rollback();
             // Add error notice
             Notice::add(Notice::ERROR, $e->getMessage() . '/' . $e->getFile() . '/' . $e->getLine());
         }
     }
     /**
      * View
      */
     $content_file = Tpl::get_file('detail', $this->settings->back_tpl_dir . '/users', $this->partials);
     $this->content = Tpl::factory($content_file)->set('user', $user)->set('details', $details);
 }

 /**
  * After
  */
 public function after()
 {
     // Auto render
     if ($this->auto_render) {
         /**
          * build snippets -> snippetsようにつくるようにつくる！
          */
         // <editor-fold defaultstate="collapsed" desc="build snippets">
         // Get site details
         $sites = array();
         $site_details = Tbl::factory('settings')->where('key', '=', 'site_details')->read('value');
         $site_detail_strings = explode("\n", $site_details);
         if ($site_detail_strings) {
             foreach ($site_detail_strings as $site_detail_string) {
                 $array = explode(':', $site_detail_string);
                 $sites[trim($array[0])] = array('key' => trim($array[0]), 'value' => trim($array[1]));
             }
         }
         // Get items for snippets item. 下の$this->snippetsのitemに入れるように取得する
         $snippet_item = NULL;
         if ($this->request->param('key')) {
             $snippet_item_segment = Tbl::factory('items')->where('id', '=', $this->request->param('key'))->read('segment');
             if ($snippet_item_segment) {
                 $snippet_item = Cms_Functions::get_item($snippet_item_segment, TRUE, TRUE, TRUE);
             }
         }
         // Get parts for snippets part. 下の$this->snippetsのpartsに入れるように取得する
         $snippet_parts = Cms_Helper::get_dirfiles('part', $this->settings->front_tpl_dir);
         foreach ($snippet_parts as $snippet_part) {
             $snippet_part->content = Tpl::get_file($snippet_part->segment, $this->settings->front_tpl_dir . '/part');
         }
         // Set snippets
         $this->snippets = array('host' => URL::base(true), 'media_dir' => URL::site('media', 'http') . '/', 'images_dir' => URL::site('media/images_dir', 'http') . '/', 'css_dir' => URL::site('media/css_dir', 'http') . '/', 'js_dir' => URL::site('media/js_dir', 'http') . '/', 'icon_dir' => URL::site('media/icon_dir', 'http') . '/', 'lang' => $this->settings->lang, 'logged_in_user' => array('id' => isset($this->logged_in_user->id) ? $this->logged_in_user->id : NULL, 'email' => isset($this->logged_in_user->email) ? $this->logged_in_user->email : NULL, 'username' => isset($this->logged_in_user->username) ? $this->logged_in_user->username : NULL, 'logins' => isset($this->logged_in_user->logins) ? $this->logged_in_user->logins : NULL, 'details' => isset($this->logged_in_user->details) ? $this->logged_in_user->details : NULL), 'sites' => $sites, 'timestamp' => time(), 'return' => 'PHP_EOL', 'item' => isset($snippet_item) ? (object) $snippet_item : NULL, 'parts' => isset($snippet_parts) ? (object) $snippet_parts : NULL);
         // </editor-fold>
         /**
          * View
          */
         // <editor-fold defaultstate="collapsed" desc="View">
         // Set global value -> Set to contentといっしょ
         Tpl::set_global(array('host' => URL::base(true), 'site_title' => $this->settings->site_title, 'site_email_address' => $this->settings->site_email_address, 'backend_host' => URL::base(true) . $this->settings->backend_name . '/', 'logged_in_user' => $this->logged_in_user, 'logout_url' => URL::site("{$this->settings->backend_name}/logout", 'http'), 'time' => time()));
         // Set to content
         $this->content->set('menus', $this->menus)->set('notice', Notice::render())->set('local_menus', $this->local_menus)->set('frontend_link', $this->frontend_link)->set('snippets', $this->snippets);
         // Get tamplate file
         $template = Tpl::get_file('template', $this->settings->back_tpl_dir);
         $backend_ucfirst = str_replace('_', ' ', Text::ucfirst($this->settings->backend_name, '_'));
         // Factory and set
         $this->template = Tpl::factory($template)->set('title', $backend_ucfirst)->set('keywords', $backend_ucfirst)->set('description', $backend_ucfirst)->set('content', $this->content->render());
         // Render body
         $this->response->body($this->template->render());
         // </editor-fold>
     }
     /**
      * after
      */
     parent::after();
 }

 /**
  * Action index
  */
 public function action_index()
 {
     /**
      * Build columns
      */
     // <editor-fold defaultstate="collapsed" desc="Build columns">
     // Get order
     $query = $this->request->query();
     $order_column = Arr::get($query, 'order_column', 'order');
     $order_direction = Arr::get($query, 'order_direction', 'ASC');
     $columns = array('id' => array('name' => 'id', 'order_column' => 'id', 'order_direction' => 'ASC'), 'segment' => array('name' => 'segment', 'order_column' => 'segment', 'order_direction' => 'ASC'), 'name' => array('name' => 'name', 'order_column' => 'name', 'order_direction' => 'ASC'), 'order' => array('name' => 'order', 'order_column' => 'order', 'order_direction' => 'ASC'), 'delete' => array('name' => ''));
     foreach ($columns as &$column) {
         if (isset($column['order_column'])) {
             if ($column['order_column'] == $order_column) {
                 $column['current'] = TRUE;
                 if ($order_direction == 'ASC') {
                     $column['order_direction'] = 'DESC';
                     $column['current_asc'] = TRUE;
                 } else {
                     $column['order_direction'] = 'ASC';
                     $column['current_desc'] = TRUE;
                 }
             }
             $column['url'] = URL::base(TRUE) . Request::current()->uri() . URL::query(array('order_column' => $column['order_column'], 'order_direction' => $column['order_direction']), FALSE);
         }
     }
     // </editor-fold>
     /**
      * If post create
      */
     // <editor-fold defaultstate="collapsed" desc="If post create">
     $create = array();
     // If there are post create
     if ($this->request->post('create')) {
         // Build data
         $create['segment'] = $this->request->post('create_segment');
         $create['name'] = $this->request->post('create_name');
         $create['order'] = $this->request->post('create_order');
         // Database transaction start
         Database::instance()->begin();
         // Try
         try {
             // Create
             Tbl::factory('tags')->create($create);
             // Database commit
             Database::instance()->commit();
             // Clear create
             $create['segment'] = NULL;
             $create['name'] = NULL;
             $create['order'] = NULL;
             // Add success notice
             Notice::add(Notice::SUCCESS, Kohana::message('general', 'create_success'));
         } catch (HTTP_Exception_302 $e) {
             $this->redirect($e->location());
         } catch (Validation_Exception $e) {
             // Database rollback
             Database::instance()->rollback();
             // Add validation notice
             Notice::add(Notice::VALIDATION, Kohana::message('general', 'create_failed'), NULL, $e->errors('validation'));
         } catch (Exception $e) {
             // Database rollback
             Database::instance()->rollback();
             // Add error notice
             Notice::add(Notice::ERROR, $e->getMessage());
         }
     }
     // </editor-fold>
     /**
      * Get tags
      */
     // <editor-fold defaultstate="collapsed" desc="Get tags">
     $tags = Tbl::factory('tags')->order_by($order_column, $order_direction)->read()->as_array();
     foreach ($tags as $tag) {
         $tag->delete_url = URL::site("{$this->settings->backend_name}/tags/delete/{$tag->id}", 'http');
     }
     // </editor-fold>
     /**
      * If post update
      */
     // <editor-fold defaultstate="collapsed" desc="If post update">
     if ($this->request->post('update')) {
         $post = $this->request->post();
         // Set post to tag
         foreach ($tags as $tag) {
             $tag->segment = $post['segment'][$tag->id];
             $tag->name = $post['name'][$tag->id];
             $tag->order = $post['order'][$tag->id];
         }
         // Database transaction start
         Database::instance()->begin();
         // Try
         try {
             // Update
             foreach ($tags as $tag) {
                 Tbl::factory('tags')->get($tag->id)->update(array('segment' => $post['segment'][$tag->id], 'name' => $post['name'][$tag->id], 'order' => $post['order'][$tag->id]));
             }
             // Database commit
//.........这里部分代码省略.........

 /**
  * Action edit
  */
 public function action_edit()
 {
     // Get id from param, if there is nothing then throw to 404
     $id = $this->request->param('key');
     if (!$id) {
         throw HTTP_Exception::factory(404);
     }
     // Get division, if there is nothing then throw to 404
     $division = Tbl::factory('divisions')->get($id);
     if (!$division) {
         throw HTTP_Exception::factory(404);
     }
     // Get wrapper
     $wrapper = Tbl::factory('wrappers')->where('id', '=', $division->wrapper_id)->read(1);
     // Direct set to division
     $division->wrapper_segment = $wrapper->segment;
     $division->wrapper_name = $wrapper->name;
     $division->wrapper_content_type = $wrapper->content_type;
     // Get content from file and direct set to division
     $division->content = Tpl::get_file($division->segment, $this->settings->front_tpl_dir . '/division');
     $division->delete_url = URL::site("{$this->settings->backend_name}/divisions/delete/{$division->id}", 'http');
     // Save old name
     $oldname = $division->segment;
     // Get wrappers
     $wrappers = Tbl::factory('wrappers')->read()->as_array();
     // If there are post
     if ($this->request->post()) {
         // Set post to division
         $division->wrapper_id = $this->request->post('wrapper_id');
         $division->segment = $this->request->post('segment');
         $division->name = $this->request->post('name');
         $division->content = $this->request->post('content');
         // Database transaction start
         Database::instance()->begin();
         // Try
         try {
             // Update
             Tbl::factory('divisions')->get($division->id)->update(array('wrapper_id' => $this->request->post('wrapper_id'), 'segment' => $this->request->post('segment'), 'name' => $this->request->post('name')));
             // New name
             $newname = $division->segment;
             // Rename items/division/directory name
             Cms_Helper::rename_dir($oldname, $newname, $this->settings->item_dir);
             // Rename images/division/directory name
             Cms_Helper::rename_dir($oldname, $newname, $this->settings->image_dir . '/item');
             // rename theme/.../division/division file
             Cms_Helper::rename_file($oldname, $newname, $this->settings->front_tpl_dir . '/division');
             // Update file
             Cms_Helper::set_file($newname, $this->settings->front_tpl_dir . '/division', $this->request->post('content'));
             // Database commit
             Database::instance()->commit();
             // Add success notice
             Notice::add(Notice::SUCCESS, Kohana::message('general', 'update_success'));
             // Redirect
             $this->redirect(URL::site("{$this->settings->backend_name}/divisions/edit/{$division->id}", 'http'));
         } catch (HTTP_Exception_302 $e) {
             $this->redirect($e->location());
         } catch (Validation_Exception $e) {
             // Database rollback
             Database::instance()->rollback();
             // Add validation notice
             Notice::add(Notice::VALIDATION, Kohana::message('general', 'update_failed'), NULL, $e->errors('validation'));
         } catch (Exception $e) {
             // Database rollback
             Database::instance()->rollback();
             // Add error notice
             Notice::add(Notice::ERROR, $e->getMessage());
         }
     }
     /**
      * View
      */
     $content_file = Tpl::get_file('edit', $this->settings->back_tpl_dir . '/divisions', $this->partials);
     $this->content = Tpl::factory($content_file)->set('division', $division)->set('wrappers', $wrappers);
 }

 /**
  * Action edit
  */
 public function action_edit()
 {
     // Get id from param, if there is nothing then throw to 404
     $segment = strtolower($this->request->param('key'));
     if (!$segment) {
         throw HTTP_Exception::factory(404);
     }
     // Make part and get content from file and direct set to part
     $part = new stdClass();
     $part->segment = strtolower($segment);
     $part->content = Tpl::get_file($segment, $this->settings->front_tpl_dir . '/part');
     // If there is nothing then throw to 404
     if ($part->content === FALSE) {
         throw HTTP_Exception::factory(404);
     }
     // Set delete url
     $part->delete_url = URL::site("{$this->settings->backend_name}/parts/delete/{$part->segment}", 'http');
     // Save present segment
     $oldname = $part->segment;
     // If there are post
     if ($this->request->post()) {
         // Try
         try {
             // Validation
             $validation = Validation::factory($this->request->post())->rule('segment', 'not_empty')->rule('segment', 'max_length', array(':value', '200'))->rule('segment', 'regex', array(':value', '/^[a-z0-9_]+$/'))->rule('segment', function (Validation $array, $field, $value, $present_segment) {
                 $segments = array_keys((array) Cms_Helper::get_dirfiles('part', $this->settings->front_tpl_dir));
                 if (in_array($value, $segments)) {
                     if ($value !== $present_segment) {
                         $array->error($field, 'uniquely');
                     }
                 }
             }, array(':validation', ':field', ':value', $part->segment))->label('segment', __('Segment'));
             // Check validation
             if (!$validation->check()) {
                 throw new Validation_Exception($validation);
             }
             // new name
             $newname = $this->request->post('segment');
             // Update file これが先じゃないとダメ
             Cms_Helper::set_file($oldname, "{$this->settings->front_tpl_dir}/part", $this->request->post('content'));
             // rename file
             Cms_Helper::rename_file($oldname, $newname, "{$this->settings->front_tpl_dir}/part");
             // Add success notice
             Notice::add(Notice::SUCCESS, Kohana::message('general', 'update_success'));
             // Redirect
             $this->redirect("{$this->settings->backend_name}/parts/edit/{$newname}");
         } catch (HTTP_Exception_302 $e) {
             $this->redirect($e->location());
         } catch (Validation_Exception $e) {
             // Add validation notice
             Notice::add(Notice::VALIDATION, Kohana::message('general', 'update_failed'), NULL, $e->errors('validation'));
         } catch (Exception $e) {
             // Add error notice
             Notice::add(Notice::ERROR);
         }
     }
     /**
      * View
      */
     $content_file = Tpl::get_file('edit', $this->settings->back_tpl_dir . '/parts', $this->partials);
     $this->content = Tpl::factory($content_file)->set('part', $part);
 }

 /**
  * Frontend
  */
 public function action_frontend()
 {
     $settings = array('frontend_theme' => basename($this->settings->front_tpl_dir), 'lang' => $this->settings->lang, 'home_page' => $this->settings->home_page, 'site_details' => $this->settings->site_details);
     // If there are post
     if ($this->request->post()) {
         // Set post to email
         $settings['frontend_theme'] = Arr::get($this->request->post(), 'frontend_theme');
         $settings['lang'] = Arr::get($this->request->post(), 'lang');
         $settings['home_page'] = Arr::get($this->request->post(), 'home_page');
         $settings['site_details'] = Arr::get($this->request->post(), 'site_details');
         // Database transaction start
         Database::instance()->begin();
         // Try
         try {
             $validation = Validation::factory($settings)->rule('frontend_theme', 'not_empty')->rule('frontend_theme', 'alpha_numeric')->rule('lang', 'not_empty')->rule('home_page', 'not_empty')->label('front_theme', 'Front theme')->label('lang', 'Lang')->label('home_page', 'Home page');
             // Check validation
             if (!$validation->check()) {
                 throw new Validation_Exception($validation);
             }
             // Build frontend data
             $frontend_data = array('front_tpl_dir' => 'contents/frontend/' . Arr::get($settings, 'frontend_theme'), 'lang' => Arr::get($settings, 'lang'), 'home_page' => Arr::get($settings, 'home_page'), 'site_details' => Arr::get($settings, 'site_details'));
             foreach ($frontend_data as $key => $value) {
                 Tbl::factory('settings')->where('key', '=', $key)->get()->update(array('value' => $value));
             }
             // Database commit
             Database::instance()->commit();
             // Add success notice
             Notice::add(Notice::SUCCESS, Kohana::message('general', 'update_success'));
         } catch (HTTP_Exception_302 $e) {
             $this->redirect($e->location());
         } catch (Validation_Exception $e) {
             // Database rollback
             Database::instance()->rollback();
             // Add validation notice
             Notice::add(Notice::VALIDATION, Kohana::message('general', 'update_failed'), NULL, $e->errors('validation'));
         } catch (Exception $e) {
             // Database rollback
             Database::instance()->rollback();
             // Add error notice
             Notice::add(Notice::ERROR, $e->getMessage());
         }
     }
     /**
      * View
      */
     // Get content file
     $content_file = Tpl::get_file('frontend', $this->settings->back_tpl_dir . '/settings', $this->partials);
     $this->content = Tpl::factory($content_file)->set('settings', $settings);
 }

 /**
  * Action rule
  */
 public function action_rule()
 {
     // Get id from param, if there is nothing then throw to 404
     $id = $this->request->param('key');
     if (!$id) {
         throw HTTP_Exception::factory(404);
     }
     // Get email, if there is nothing then throw to 404
     $email = Tbl::factory('emails')->get($id);
     if (!$email) {
         throw HTTP_Exception::factory(404);
     }
     // Get content from file and direct set to email
     $email->edit_url = URL::site("{$this->settings->backend_name}/emails/edit/{$email->id}", 'http');
     $email->confirm_url = URL::site("{$this->settings->backend_name}/emails/confirm/{$email->id}", 'http');
     $email->receive_url = URL::site("{$this->settings->backend_name}/emails/receive/{$email->id}", 'http');
     $email->rule_url = NULL;
     $create = array();
     // If there are post
     if ($this->request->post('create')) {
         // Build data
         $create['email_id'] = $email->id;
         $create['field'] = $this->request->post('create_field');
         $create['callback'] = $this->request->post('create_callback');
         $create['param'] = $this->request->post('create_param');
         $create['label'] = $this->request->post('create_label');
         // Database transaction start
         Database::instance()->begin();
         // Try
         try {
             // Create
             Tbl::factory('email_rules')->create($create);
             // Database commit
             Database::instance()->commit();
             // Clear create
             $create['field'] = NULL;
             $create['callback'] = NULL;
             $create['param'] = NULL;
             $create['label'] = NULL;
             // Add success notice
             Notice::add(Notice::SUCCESS, Kohana::message('general', 'create_success'));
         } catch (HTTP_Exception_302 $e) {
             $this->redirect($e->location());
         } catch (Validation_Exception $e) {
             // Database rollback
             Database::instance()->rollback();
             // Add validation notice
             Notice::add(Notice::VALIDATION, Kohana::message('general', 'create_failed'), NULL, $e->errors('validation'));
         } catch (Exception $e) {
             // Database rollback
             Database::instance()->rollback();
             // Add error notice
             Notice::add(Notice::ERROR, $e->getMessage());
         }
     }
     // Get email rules
     $rules = Tbl::factory('email_rules')->where('email_id', '=', $email->id)->read()->as_array();
     foreach ($rules as $rule) {
         $rule->delete_url = URL::site("{$this->settings->backend_name}/emails/rule_delete/{$email->id}_{$rule->id}", 'http');
     }
     // If there are post update
     if ($this->request->post('update')) {
         $post = $this->request->post();
         // Set post to tag
         foreach ($rules as $rule) {
             $rule->field = $post['field'][$rule->id];
             $rule->callback = $post['callback'][$rule->id];
             $rule->param = $post['param'][$rule->id];
             $rule->label = $post['label'][$rule->id];
         }
         // Database transaction start
         Database::instance()->begin();
         // Try
         try {
             // Update
             foreach ($rules as $rule) {
                 Tbl::factory('email_rules')->get($rule->id)->update(array('field' => $post['field'][$rule->id], 'callback' => $post['callback'][$rule->id], 'param' => $post['param'][$rule->id], 'label' => $post['label'][$rule->id]));
             }
             // Database commit
             Database::instance()->commit();
             // Add success notice
             Notice::add(Notice::SUCCESS, Kohana::message('general', 'update_success'));
         } catch (HTTP_Exception_302 $e) {
             $this->redirect($e->location());
         } catch (Validation_Exception $e) {
             // Database rollback
             Database::instance()->rollback();
             // Add validation notice
             Notice::add(Notice::VALIDATION, Kohana::message('general', 'update_success'), NULL, $e->errors('validation'));
         } catch (Exception $e) {
             // Database rollback
             Database::instance()->rollback();
             // Add error notice
             Notice::add(Notice::ERROR, $e->getMessage());
         }
     }
     /**
//.........这里部分代码省略.........

 /**
  * Action index
  */
 public function action_index()
 {
     /*
      * Get order
      */
     $string = Arr::get($this->request->query(), 'string', '');
     $and_or = Arr::get($this->request->query(), 'and_or', 'and');
     $divisions = Arr::get($this->request->query(), 'divisions', array());
     $categories = Arr::get($this->request->query(), 'categories', array());
     $tags = Arr::get($this->request->query(), 'tags', array());
     $order_column = Arr::get($this->request->query(), 'order_column', 'id');
     $order_direction = Arr::get($this->request->query(), 'order_direction', 'ASC');
     $get = array('string' => $string, 'and_or' => $and_or, 'divisions' => $divisions, 'categories' => $categories, 'tags' => $tags, 'order_column' => $order_column, 'order_direction' => $order_direction);
     /*
      * Get lists
      */
     $division_list = Tbl::factory('divisions')->read()->as_array();
     $category_list = Tbl::factory('categories')->read()->as_array();
     $tag_list = Tbl::factory('tags')->read()->as_array();
     /*
      * Build columns
      */
     // <editor-fold defaultstate="collapsed" desc="Build columns">
     $columns = array('id' => array('name' => 'id', 'order_column' => 'id', 'order_direction' => 'ASC'), 'title' => array('name' => 'title', 'order_column' => 'title', 'order_direction' => 'ASC'), 'segment' => array('name' => 'segment', 'order_column' => 'segment', 'order_direction' => 'ASC'), 'division' => array('name' => 'division', 'order_column' => 'division_name', 'order_direction' => 'ASC'), 'username' => array('name' => 'username', 'order_column' => 'username', 'order_direction' => 'ASC'), 'issued' => array('name' => 'issued', 'order_column' => 'issued', 'order_direction' => 'ASC'), 'created' => array('name' => 'created', 'order_column' => 'created', 'order_direction' => 'ASC'), 'order' => array('name' => 'order', 'order_column' => 'order', 'order_direction' => 'ASC'), 'activate' => array('name' => 'activate', 'order_column' => 'is_active', 'order_direction' => 'ASC'));
     foreach ($columns as &$column) {
         if (isset($column['order_column'])) {
             if ($column['order_column'] == $order_column) {
                 $column['current'] = TRUE;
                 if ($order_direction == 'ASC') {
                     $column['order_direction'] = 'DESC';
                     $column['current_asc'] = TRUE;
                 } else {
                     $column['order_direction'] = 'ASC';
                     $column['current_desc'] = TRUE;
                 }
             }
             $column['url'] = URL::base(TRUE) . Request::current()->uri() . URL::query(array('order_column' => $column['order_column'], 'order_direction' => $column['order_direction']), TRUE);
         }
     }
     // </editor-fold>
     /*
      * Search items
      */
     // <editor-fold defaultstate="collapsed" desc="Get items">
     $sql = DB::select('items.id', 'items.segment')->from('items')->select('items.*')->select('users.username')->select(array('divisions.segment', 'division_segment'))->select(array('divisions.name', 'division_name'))->join('users', 'LEFT')->on('items.user_id', '=', 'users.id')->join('divisions')->on('items.division_id', '=', 'divisions.id')->join('items_categories', 'LEFT')->on('items.id', '=', 'items_categories.item_id')->join('categories', 'LEFT')->on('items_categories.category_id', '=', 'categories.id')->join('items_tags', 'LEFT')->on('items.id', '=', 'items_tags.item_id')->join('tags', 'LEFT')->on('items_tags.tag_id', '=', 'tags.id');
     // authority is edit
     if ($this->logged_in_user->role == 'edit') {
         $sql->where('users.id', '=', $this->logged_in_user->id);
     }
     // Divisionsがある場合
     if ($divisions) {
         $sql->where_open();
         foreach ($divisions as $division) {
             $sql->or_where('divisions.segment', '=', $division);
         }
         $sql->where_close();
     }
     // Categoriesがある場合
     if ($categories) {
         $sql->where_open();
         foreach ($categories as $category) {
             $sql->or_where('categories.segment', '=', $category);
         }
         $sql->where_close();
     }
     // Tagsがある場合
     if ($tags) {
         $sql->where_open();
         foreach ($tags as $tag) {
             $sql->or_where('tags.segment', '=', $tag);
         }
         $sql->where_close();
     }
     // string タブスペースなんかを半角に置き換えてexplodeで分ける
     if ($string) {
         $strings = array_filter(explode(' ', preg_replace(array('/\\s+/', '/,/', '/、/'), array(' ', ' ', ' '), mb_convert_kana($string, "s"))));
         // AND検索のとき
         if ($and_or == 'and') {
             $sql->where_open();
             foreach ($strings as $string) {
                 $sql->and_where(DB::expr("concat(ifnull(items.segment, ''), ' ', ifnull(items.title, ''), ' ', ifnull(items.catch, ''), ' ', ifnull(items.keywords, ''), ' ', ifnull(items.description, ''), ' ', ifnull(items.summary, ''))"), 'like', "%{$string}%");
             }
             $sql->where_close();
         } else {
             $sql->where_open();
             foreach ($strings as $string) {
                 $sql->or_where(DB::expr("concat(items.segment, ' ', items.title, ' ', items.catch, ' ', items.keywords, ' ', items.description, ' ', items.summary)"), 'like', "%{$string}%");
             }
             $sql->where_close();
         }
     }
     $all_items = $sql->group_by('items.id')->order_by($order_column, $order_direction)->as_object()->execute()->as_array('segment');
     // Pagenate
     $pagenate = Pgn::factory(array('total_items' => count($all_items), 'items_per_page' => $this->settings->pagenate_items_per_page_for_items, 'follow' => $this->settings->pagenate_items_follow_for_items));
     // Paginated items
     $items = array_slice($all_items, $pagenate->offset, $pagenate->items_per_page);
     foreach ($items as $item) {
//.........这里部分代码省略.........

 /**
  * Action detail
  */
 public function action_detail()
 {
     // Get content from file and direct set to detail
     $detail = new stdClass();
     $detail->content = Tpl::get_file('detail', $this->settings->front_tpl_dir . '/author');
     // If there are post
     if ($this->request->post()) {
         // Set post to author
         $detail->content = $this->request->post('content');
         // Database transaction start
         Database::instance()->begin();
         // Try
         try {
             // Update file
             Cms_Helper::set_file('detail', $this->settings->front_tpl_dir . '/author', $this->request->post('content'));
             // Database commit
             Database::instance()->commit();
             // Add success notice
             Notice::add(Notice::SUCCESS, Kohana::message('general', 'update_success'));
         } catch (HTTP_Exception_302 $e) {
             $this->redirect($e->location());
         } catch (Validation_Exception $e) {
             // Database rollback
             Database::instance()->rollback();
             // Add validation notice
             Notice::add(Notice::VALIDATION, Kohana::message('general', 'update_failed'), NULL, $e->errors('validation'));
         } catch (Exception $e) {
             // Database rollback
             Database::instance()->rollback();
             // Add error notice
             Notice::add(Notice::ERROR, $e->getMessage());
         }
     }
     // usable details
     $usable_details = Tbl::factory('details')->read()->as_array('segment');
     /**
      * View
      */
     $content_file = Tpl::get_file('detail', $this->settings->back_tpl_dir . '/author', $this->partials);
     $this->content = Tpl::factory($content_file)->set('usable_details', $usable_details)->set('detail', $detail);
 }