PHP Model_Config::where方法代码示例

 public static function getSemester($nim)
 {
     $config = new Model_Config();
     $mahasiswa = new Model_Mahasiswa($nim);
     $tahun = $config->where('name', '=', 'tahun')->find()->value;
     $semester = $config->where('name', '=', 'semester')->find()->value;
     return ($tahun - $mahasiswa->tahun_masuk) * 2 + $semester;
 }

 public function action_index()
 {
     // validation active
     Breadcrumbs::add(Breadcrumb::factory()->set_title(__('List')));
     $this->template->title = __('Translations');
     //scan project files and generate .po
     $parse = $this->request->query('parse');
     if ($parse) {
         //scan script
         require_once Kohana::find_file('vendor', 'POTCreator/POTCreator', 'php');
         $obj = new POTCreator();
         $obj->set_root(DOCROOT);
         $obj->set_exts('php');
         $obj->set_regular('/_[_|e]\\([\\"|\']([^\\"|\']+)[\\"|\']\\)/i');
         $obj->set_base_path('..');
         $obj->set_read_subdir(true);
         $obj->write_pot(i18n::get_language_path());
         Alert::set(Alert::SUCCESS, 'File regenerated');
     }
     //change default site language
     if ($this->request->param('id')) {
         //save language
         $locale = new Model_Config();
         $locale->where('group_name', '=', 'i18n')->where('config_key', '=', 'locale')->limit(1)->find();
         if (!$locale->loaded()) {
             $locale->group_name = 'i18n';
             $locale->config_key = 'locale';
         }
         $locale->config_value = $this->request->param('id');
         try {
             $locale->save();
             Alert::set(Alert::SUCCESS, __('Translations regenarated'));
         } catch (Exception $e) {
             throw HTTP_Exception::factory(500, $e->getMessage());
         }
         HTTP::redirect(Route::url('oc-panel', array('controller' => 'translations')));
     }
     //create language
     if (Core::post('locale')) {
         $language = $this->request->post('locale');
         $folder = DOCROOT . 'languages/' . $language . '/LC_MESSAGES/';
         // if folder does not exist, try to make it
         if (!file_exists($folder) and !@mkdir($folder, 0775, true)) {
             // mkdir not successful ?
             Alert::set(Alert::ERROR, __('Language folder cannot be created with mkdir. Please correct to be able to create new translation.'));
             HTTP::redirect(Route::url('oc-panel', array('controller' => 'translations')));
         }
         // write an empty .po file for $language
         $out = 'msgid ""' . PHP_EOL;
         $out .= 'msgstr ""' . PHP_EOL;
         File::write($folder . 'messages.po', $out);
         Alert::set(Alert::SUCCESS, $this->request->param('id') . ' ' . __('Language saved'));
     }
     $this->template->content = View::factory('oc-panel/pages/translations/index', array('languages' => i18n::get_languages(), 'current_language' => core::config('i18n.locale')));
 }

 public function action_index()
 {
     Breadcrumbs::add(Breadcrumb::factory()->set_title(__('Social Authentication for login')));
     $this->template->title = __('Social Auth');
     $this->template->styles = array('css/sortable.css' => 'screen');
     $this->template->scripts['footer'][] = 'js/jquery-sortable-min.js';
     //retrieve social_auth values
     $config = Social::get();
     if ($p = $this->request->post()) {
         $confit_old = $config;
         $config_new = array();
         foreach ($p as $key => $value) {
             if ($key != 'submit') {
                 // check if its id, secret .. and build multy d. array, same as they have
                 if (strpos($key, '_id')) {
                     $config_new['providers'][str_replace('_id', '', $key)]['keys']['id'] = $value;
                 } elseif (strpos($key, '_secret')) {
                     $config_new['providers'][str_replace('_secret', '', $key)]['keys']['secret'] = $value;
                 } elseif (strpos($key, '_key')) {
                     $config_new['providers'][str_replace('_key', '', $key)]['keys']['key'] = $value;
                 } elseif ($key == 'debug_mode') {
                     $config_new[$key] = $value;
                 } else {
                     $config_new['providers'][$key]['enabled'] = $value;
                 }
             }
         }
         // two fields not included
         $config_new['base_url'] = Route::url('default', array('controller' => 'social', 'action' => 'login', 'id' => 1));
         $config_new['debug_file'] = DOCROOT . 'oc/vendor/hybridauth/logs.txt';
         $obj_social_config = new Model_Config();
         $conf = $obj_social_config->where('group_name', '=', 'social')->where('config_key', '=', 'config')->limit(1)->find();
         if ($conf->loaded()) {
             $conf->config_value = json_encode($config_new);
             try {
                 $conf->save();
                 $config = $config_new;
                 //we update the form values if we changed them
                 Alert::set(Alert::SUCCESS, __('Social Auth updated'));
             } catch (Exception $e) {
                 throw HTTP_Exception::factory(500, $e->getMessage());
             }
         }
     }
     $this->template->content = View::factory('oc-panel/pages/social_auth/index', array('config' => $config));
 }

 public static function save($items)
 {
     // save widget to DB
     $conf = new Model_Config();
     $conf->where('group_name', '=', 'general')->where('config_key', '=', 'menu')->limit(1)->find();
     if (!$conf->loaded()) {
         $conf->group_name = 'general';
         $conf->config_key = 'menu';
     }
     $conf->config_value = json_encode($items);
     try {
         $conf->save();
         return TRUE;
     } catch (Exception $e) {
         throw HTTP_Exception::factory(500, $e->getMessage());
     }
     return FALSE;
 }

 public function action_index()
 {
     // validation active
     Breadcrumbs::add(Breadcrumb::factory()->set_title(__('List')));
     $this->template->title = __('Translations');
     //scan project files and generate .po
     $parse = $this->request->query('parse');
     if ($parse) {
         //scan script
         require_once Kohana::find_file('vendor', 'POTCreator/POTCreator', 'php');
         $obj = new POTCreator();
         $obj->set_root(DOCROOT);
         $obj->set_exts('php');
         $obj->set_regular('/_[_|e]\\([\\"|\']([^\\"|\']+)[\\"|\']\\)/i');
         $obj->set_base_path('..');
         $obj->set_read_subdir(true);
         $obj->write_pot(i18n::get_language_path());
         Alert::set(Alert::SUCCESS, 'File regenerated');
     }
     //change default site language
     if ($this->request->param('id')) {
         //save language
         $locale = new Model_Config();
         $locale->where('group_name', '=', 'i18n')->where('config_key', '=', 'locale')->limit(1)->find();
         if (!$locale->loaded()) {
             $locale->group_name = 'i18n';
             $locale->config_key = 'locale';
         }
         $locale->config_value = $this->request->param('id');
         try {
             $locale->save();
             Alert::set(Alert::SUCCESS, '');
             Request::current()->redirect(Route::url('oc-panel', array('controller' => 'translations')));
         } catch (Exception $e) {
             echo $e;
         }
     }
     $this->template->content = View::factory('oc-panel/pages/translations/index', array('languages' => i18n::get_languages(), 'current_language' => core::config('i18n.locale')));
 }

 /**
  * saves thme options as json 'theme.NAMETHEME' = array json
  * @param  string $theme theme to save at
  * @param  array $data to save
  * @return void 
  */
 public static function save($theme = NULL, $data = NULL)
 {
     if ($theme === NULL) {
         $theme = self::$theme;
     }
     if ($data === NULL) {
         $data = self::$data;
     }
     // save theme to DB
     $conf = new Model_Config();
     $conf->where('group_name', '=', 'theme')->where('config_key', '=', $theme)->limit(1)->find();
     if (!$conf->loaded()) {
         $conf->group_name = 'theme';
         $conf->config_key = $theme;
     }
     $conf->config_value = json_encode($data);
     try {
         $conf->save();
     } catch (Exception $e) {
         throw new HTTP_Exception_500();
     }
 }

 /**
  * Plugins configuration 
  * @return [view] Renders view with form inputs
  */
 public function action_plugins()
 {
     Breadcrumbs::add(Breadcrumb::factory()->set_title(__('Plugins')));
     $this->template->title = __('Plugins');
     // all form config values
     $generalconfig = new Model_Config();
     $config = $generalconfig->where('group_name', '=', 'general')->or_where('group_name', '=', 'i18n')->find_all();
     // config general array
     foreach ($config as $c) {
         $forms[$c->config_key] = $forms[$c->config_key] = array('key' => $c->group_name . '[' . $c->config_key . '][]', 'id' => $c->config_key, 'value' => $c->config_value);
     }
     // save only changed values
     if ($this->request->post()) {
         //d($this->request->post());
         foreach ($this->request->post('general') as $k => $v) {
             $this->request->post('general_' . $k, $v[0]);
         }
         $validation = Validation::factory($this->request->post());
         if ($validation->check()) {
             //save general
             foreach ($config as $c) {
                 $config_res = $this->request->post();
                 if (isset($config_res[$c->group_name][$c->config_key][0]) and $config_res[$c->group_name][$c->config_key][0] != $c->config_value) {
                     $c->config_value = $config_res[$c->group_name][$c->config_key][0];
                     Model_Config::set_value($c->group_name, $c->config_key, $c->config_value);
                 }
             }
         } else {
             $errors = $validation->errors('config');
             foreach ($errors as $error) {
                 Alert::set(Alert::ALERT, $error);
             }
             $this->redirect(Route::url('oc-panel', array('controller' => 'settings', 'action' => 'plugins')));
         }
         Alert::set(Alert::SUCCESS, __('Plugins configuration updated'));
         $this->redirect(Route::url('oc-panel', array('controller' => 'settings', 'action' => 'plugins')));
     }
     $this->template->content = View::factory('oc-panel/pages/settings/plugins', array('forms' => $forms));
 }

 /**
  * Image configuration 
  * @return [view] Renders view with form inputs
  */
 public function action_image()
 {
     $this->template->scripts['footer'][] = 'js/jquery.validate.min.js';
     $this->template->scripts['footer'][] = '/js/oc-panel/settings.js';
     Breadcrumbs::add(Breadcrumb::factory()->set_title(__('Image')));
     $this->template->title = __('Image');
     // all form config values
     $imageconf = new Model_Config();
     $config = $imageconf->where('group_name', '=', 'image')->find_all();
     // save only changed values
     if ($this->request->post()) {
         foreach ($this->request->post('image') as $k => $v) {
             $this->request->post('image_' . $k, $v[0]);
         }
         $validation = Validation::factory($this->request->post())->rule('image_max_image_size', 'not_empty')->rule('image_max_image_size', 'digit')->rule('image_height', 'digit')->rule('image_width', 'not_empty')->rule('image_width', 'digit')->rule('image_height_thumb', 'not_empty')->rule('image_height_thumb', 'digit')->rule('image_width_thumb', 'not_empty')->rule('image_width_thumb', 'digit')->rule('image_quality', 'not_empty')->rule('image_quality', 'digit')->rule('image_quality', 'range', array(':value', 1, 100))->rule('image_watermark', 'range', array(':value', 0, 1))->rule('image_watermark_position', 'not_empty')->rule('image_watermark_position', 'digit')->rule('image_watermark_position', 'range', array(':value', 0, 2))->rule('image_disallow_nudes', 'range', array(':value', 0, 1))->rule('image_aws_s3_active', 'range', array(':value', 0, 1));
         if ($validation->check()) {
             foreach ($config as $c) {
                 $config_res = $this->request->post();
                 if (!array_key_exists('allowed_formats', $config_res[$c->group_name])) {
                     Alert::set(Alert::ERROR, __('At least one image format should be allowed.'));
                     $this->redirect(Route::url('oc-panel', array('controller' => 'settings', 'action' => 'image')));
                 }
                 if ($config_res[$c->group_name][$c->config_key][0] != $c->config_value) {
                     if ($c->config_key == 'allowed_formats') {
                         $allowed_formats = '';
                         foreach ($config_res[$c->group_name][$c->config_key] as $key => $value) {
                             $allowed_formats .= $value . ",";
                         }
                         $config_res[$c->group_name][$c->config_key][0] = $allowed_formats;
                     }
                     if ($c->config_key == 'aws_s3_domain') {
                         switch ($config_res[$c->group_name]['aws_s3_domain'][0]) {
                             case 'bn-s3':
                                 $s3_domain = $config_res[$c->group_name]['aws_s3_bucket'][0] . '.s3.amazonaws.com';
                                 break;
                             case 'bn':
                                 $s3_domain = $config_res[$c->group_name]['aws_s3_bucket'][0];
                                 break;
                             default:
                                 $s3_domain = 's3.amazonaws.com/' . $config_res[$c->group_name]['aws_s3_bucket'][0];
                                 break;
                         }
                         $config_res[$c->group_name][$c->config_key][0] = $s3_domain . '/';
                     }
                     $c->config_value = $config_res[$c->group_name][$c->config_key][0];
                     Model_Config::set_value($c->group_name, $c->config_key, $c->config_value);
                 }
             }
         } else {
             $errors = $validation->errors('config');
             foreach ($errors as $error) {
                 Alert::set(Alert::ALERT, $error);
             }
             $this->redirect(Route::url('oc-panel', array('controller' => 'settings', 'action' => 'image')));
         }
         Alert::set(Alert::SUCCESS, __('Image Configuration updated'));
         $this->redirect(Route::url('oc-panel', array('controller' => 'settings', 'action' => 'image')));
     }
     $this->template->content = View::factory('oc-panel/pages/settings/image', array('config' => $config));
 }

 /**
  * changes the order to display fields
  * @param  array  $order 
  * @return bool
  */
 public function change_order(array $order)
 {
     $fields = self::get_all();
     $new_fields = array();
     //using order they send us
     foreach ($order as $name) {
         if (isset($fields[$name])) {
             $new_fields[$name] = $fields[$name];
         }
     }
     //save configs
     $conf = new Model_Config();
     $conf->where('group_name', '=', 'advertisement')->where('config_key', '=', 'fields')->limit(1)->find();
     if ($conf->loaded()) {
         try {
             $conf->config_value = json_encode($new_fields);
             $conf->save();
             return TRUE;
         } catch (Exception $e) {
             throw HTTP_Exception::factory(500, $e->getMessage());
         }
     }
     return FALSE;
 }

 /**
  * delete current widget data from the DB config
  * @return boolean 
  */
 public function delete()
 {
     if ($this->loaded) {
         // save widget to DB
         $confw = new Model_Config();
         $confw->where('group_name', '=', 'widget')->where('config_key', '=', $this->widget_name)->limit(1)->find();
         if ($confw->loaded()) {
             try {
                 $confw->delete();
                 //remove from previous placeholder, only if they are different
                 $confp = new Model_Config();
                 $confp->where('group_name', '=', 'placeholder')->where('config_key', '=', $this->placeholder)->limit(1)->find();
                 if ($confp->loaded()) {
                     //remove the key
                     $wid = json_decode($confp->config_value);
                     if (is_array($wid)) {
                         $wid = array_diff($wid, array($this->widget_name));
                         $confp->config_value = json_encode(array_values($wid));
                         $confp->save();
                     }
                 }
                 $this->data = array();
                 $this->loaded = FALSE;
                 return TRUE;
             } catch (Exception $e) {
                 throw HTTP_Exception::factory(500, $e->getMessage());
             }
         }
     }
     return FALSE;
 }

 public function action_sitemap()
 {
     $this->template->title = __('Sitemap');
     Breadcrumbs::add(Breadcrumb::factory()->set_title($this->template->title));
     // all sitemap config values
     $sitemapconfig = new Model_Config();
     $config = $sitemapconfig->where('group_name', '=', 'sitemap')->find_all();
     // save only changed values
     if ($this->request->post()) {
         foreach ($config as $c) {
             $config_res = $this->request->post($c->config_key);
             if ($config_res != $c->config_value) {
                 $c->config_value = $config_res;
                 try {
                     $c->save();
                 } catch (Exception $e) {
                     throw HTTP_Exception::factory(500, $e->getMessage());
                 }
             }
         }
         // Cache::instance()->delete_all();
         Alert::set(Alert::SUCCESS, __('Sitemap Configuration updated'));
         $this->redirect(Route::url('oc-panel', array('controller' => 'tools', 'action' => 'sitemap')));
     }
     //force regenerate sitemap
     if (Core::get('force') == 1) {
         Alert::set(Alert::SUCCESS, Sitemap::generate());
     }
     $this->template->content = View::factory('oc-panel/pages/tools/sitemap');
 }

 /**
  * affiliate configuration can be configured here
  * @return [view] Renders view with form inputs
  */
 public function action_affiliates()
 {
     Breadcrumbs::add(Breadcrumb::factory()->set_title(__('Affiliates')));
     $this->template->title = __('Affiliates');
     $this->template->scripts['footer'][] = 'js/jquery.validate.min.js';
     $this->template->scripts['footer'][] = 'js/oc-panel/settings.js';
     // all form config values
     $paymentconf = new Model_Config();
     $config = $paymentconf->where('group_name', '=', 'affiliate')->find_all();
     // save only changed values
     if ($this->request->post()) {
         $validation = Validation::factory($this->request->post())->rule('active', 'range', array(':value', 0, 1))->rule('cookie', 'not_empty')->rule('cookie', 'digit')->rule('payment_days', 'not_empty')->rule('payment_days', 'digit')->rule('payment_min', 'not_empty')->rule('payment_min', 'digit');
         if ($validation->check()) {
             foreach ($config as $c) {
                 $config_res = $this->request->post($c->config_key);
                 if ($config_res != $c->config_value) {
                     $c->config_value = $config_res;
                     try {
                         $c->save();
                     } catch (Exception $e) {
                         echo $e;
                     }
                 }
             }
         } else {
             $errors = $validation->errors('config');
             foreach ($errors as $error) {
                 Alert::set(Alert::ALERT, $error);
             }
             $this->redirect(Route::url('oc-panel', array('controller' => 'settings', 'action' => 'affiliates')));
         }
         Alert::set(Alert::SUCCESS, __('Affiliate Configuration updated'));
         $this->redirect(Route::url('oc-panel', array('controller' => 'settings', 'action' => 'affiliates')));
     }
     $pages = array('' => __('Deactivated'));
     foreach (Model_Content::get_pages() as $key => $value) {
         $pages[$value->seotitle] = $value->title;
     }
     $this->template->content = View::factory('oc-panel/pages/settings/affiliates', array('config' => $config, 'pages' => $pages));
 }

 public function action_saveplaceholders()
 {
     //deleting the fragment cache...a bit ugly but works.
     View::delete_fragment('sidebar_front');
     View::delete_fragment('footer_front');
     $this->auto_render = FALSE;
     $this->template = View::factory('js');
     DB::delete('config')->where('group_name', '=', 'placeholder')->execute();
     //for each placeholder
     foreach ($_GET as $placeholder => $widgets) {
         if (!is_array($widgets)) {
             $widgets = array($widgets);
         }
         // save palceholder to DB
         $confp = new Model_Config();
         $confp->where('group_name', '=', 'placeholder')->where('config_key', '=', $placeholder)->limit(1)->find();
         if (!$confp->loaded()) {
             $confp->group_name = 'placeholder';
             $confp->config_key = $placeholder;
         }
         $confp->config_value = json_encode($widgets);
         $confp->save();
         //edit each widget change placeholder
         foreach ($widgets as $wname) {
             $w = Widget::factory($wname);
             if ($w !== NULL) {
                 if ($w->loaded and $w->placeholder != $placeholder) {
                     $w->placeholder = $placeholder;
                     $w->save();
                 }
             }
         }
     }
     $this->template->content = __('Saved');
 }

 /**
  * Payment deatails and paypal configuration can be configured here
  * @return [view] Renders view with form inputs
  */
 public function action_payment()
 {
     // validation active
     //$this->template->scripts['footer'][]= '/js/oc-panel/settings.js';
     Breadcrumbs::add(Breadcrumb::factory()->set_title(__('Payments')));
     $this->template->title = __('Payments');
     // all form config values
     $paymentconf = new Model_Config();
     $config = $paymentconf->where('group_name', '=', 'payment')->find_all();
     $paypal_currency = Paypal::get_currency();
     // currencies limited by paypal
     // save only changed values
     if ($this->request->post()) {
         foreach ($config as $c) {
             $config_res = $this->request->post($c->config_key);
             if ($c->config_key == 'paypal_currency') {
                 $config_res = $paypal_currency[core::post('paypal_currency')];
             }
             if ($config_res != $c->config_value) {
                 $c->config_value = $config_res;
                 try {
                     $c->save();
                 } catch (Exception $e) {
                     echo $e;
                 }
             }
         }
         Alert::set(Alert::SUCCESS, __('General Configuration updated'));
         $this->request->redirect(Route::url('oc-panel', array('controller' => 'settings', 'action' => 'payment')));
     }
     $this->template->content = View::factory('oc-panel/pages/settings/payment', array('config' => $config, 'paypal_currency' => $paypal_currency));
 }

 /**
  * delete current widget data from the DB config
  * @return boolean 
  */
 public function delete()
 {
     if ($this->loaded) {
         // save widget to DB
         $confw = new Model_Config();
         $confw->where('group_name', '=', 'widget')->where('config_key', '=', $this->widget_name)->limit(1)->find();
         if ($confw->loaded()) {
             try {
                 $confw->delete();
                 //remove from previous placeholder, only if they are different
                 $confp = new Model_Config();
                 $confp->where('group_name', '=', 'placeholder')->where('config_key', '=', $this->placeholder)->limit(1)->find();
                 if ($confp->loaded()) {
                     //remove the key
                     $wid = json_decode($confp->config_value);
                     if (is_array($wid)) {
                         $key = array_search($this->widget_name, $wid);
                         if ($key !== FALSE) {
                             unset($wid[$key]);
                         }
                         $confp->config_value = json_encode($wid);
                         $confp->save();
                     }
                 }
                 $this->data = array();
                 $this->loaded = FALSE;
                 return TRUE;
             } catch (Exception $e) {
                 throw new HTTP_Exception_500($e);
             }
         }
     }
     return FALSE;
 }