PHP Base_model类代码示例

 /**
  * Get all the article_lang data + the page URL of the current language (page_url in the output array)
  *
  * @param	string	String to search
  * @return	array	Array of articles
  *
  */
 function get_articles($realm)
 {
     $realm = '\'%' . $realm . '%\'';
     $this->set_table('article');
     $this->set_lang_table('article_lang');
     $this->set_pk_name('id_article');
     $lang = Settings::get_lang();
     // Page_Article table
     $this->{$this->db_group}->select($this->parent_table . '.*', FALSE);
     $this->{$this->db_group}->join($this->parent_table, $this->parent_table . '.id_article = ' . $this->table . '.id_article', 'left');
     // Page table
     $this->{$this->db_group}->select('page.online');
     $this->{$this->db_group}->join($this->page_table, $this->page_table . '.id_page = ' . $this->parent_table . '.id_page', 'left');
     // Page lang table
     $this->{$this->db_group}->select('page_lang.lang');
     $this->{$this->db_group}->join($this->page_lang_table, $this->page_lang_table . '.id_page = ' . $this->page_table . '.id_page', 'left');
     // Menu table
     $this->{$this->db_group}->select('menu.id_menu, menu.name as menu_name');
     $this->{$this->db_group}->join($this->menu_table, $this->menu_table . '.id_menu = ' . $this->page_table . '.id_menu', 'left');
     // URL table : For Article's URL building
     $this->{$this->db_group}->select('url.path');
     $this->{$this->db_group}->join($this->url_table, $this->url_table . '.id_entity = ' . $this->table . '.id_article' . ' AND ' . $this->url_table . '.active=1 ' . ' AND ' . $this->url_table . '.lang = \'' . $lang . '\'', 'left');
     // Published filter
     $this->filter_on_published(self::$publish_filter, $lang);
     // Add the 'date' field to the query
     $this->{$this->db_group}->select('IF(article.logical_date !=0, article.logical_date, IF(article.publish_on !=0, article.publish_on, article.created )) AS date');
     // Search where
     $this->{$this->db_group}->where('(' . ' article_lang.title LIKE ' . $realm . ' OR article_lang.subtitle LIKE ' . $realm . ' OR article_lang.content LIKE ' . $realm . ')');
     $where = array("page.online" => 1, "article.indexed" => 1, "page_article.online" => 1, "page_article.main_parent" => 1, "article_lang.online" => 1, "article_lang.lang" => $lang, "page_lang.lang" => $lang);
     // Base_model->get_lang_list()
     $articles = parent::get_lang_list($where, $lang);
     return $articles;
 }

 function __construct()
 {
     parent::__construct();
     $table = 'omc_languages';
     $this->_TABLES = array(    'Langs' => 'omc_languages',
                         );
 }

 function __construct()
 {
     parent::__construct();
     $this->load->library(array('contentfactory'));
     $this->config->load('position', true);
     $this->position = $this->config->item('position', 'position');
 }

 /**
  * Class constructor
  *
  * @access public
  * @return void
  */
 public function __construct()
 {
     parent::__construct('user_bag');
     $this->config->load("props");
     $this->load->model('Points_model', 'points');
     $this->load->model('User_bag_order_model', 'user_bag_order');
 }

 /**
  * Constructor
  *
  * @access	public
  */
 public function __construct()
 {
     parent::__construct();
     $this->table = 'users';
     $this->pk_name = 'id_user';
     $this->meta_table = 'users_meta';
 }

 public function __construct()
 {
     parent::__construct('recharge_order');
     $this->load->model('User_model', 'usermodel');
     $this->load->model('User_info_model', 'User_info');
     $this->load->model('Borrow_model', 'borrow');
 }

 public function __construct()
 {
     parent::__construct();
     $this->set_table('setting');
     $this->set_pk_name('id_setting');
     $this->load->helper('path_helper');
 }

 /**
  * Model Constructor
  *
  * @access	public
  */
 public function __construct()
 {
     parent::__construct();
     $this->set_table('page');
     $this->set_pk_name('id_page');
     $this->set_lang_table('page_lang');
 }

 public function __construct()
 {
     parent::__construct();
     $this->load->model('loan_model', 'loan');
     $this->load->model('task_flow_model', 'task_flow');
     $this->load->model('Loan_item_model', 'loan_item');
 }

 /**
  * Model Constructor
  *
  * @access	public
  */
 public function __construct()
 {
     // Call the Model constructor
     parent::__construct();
     $this->table = 'menu';
     $this->pk_name = 'id_menu';
 }

 public function remove($id)
 {
     $this->load->model('Ad_model', 'ad');
     $this->ad->rm_by_position($id);
     $result = parent::remove($id);
     return $result;
 }

 /**
  * Constructor
  *
  * @access	public
  */
 public function __construct()
 {
     parent::__construct();
     $this->table = 'country';
     $this->pk_name = 'id_country';
     $this->lang_table = 'country_lang';
 }

 function replace($id, $params)
 {
     if ($id) {
         unset($params['created_at']);
     }
     return parent::replace($id, $params);
 }

 public function __construct()
 {
     parent::__construct();
     if (!isset($this->CI->product_model)) {
         $this->CI->load->model('product_model');
     }
 }

 /**
  * @积分(图腾币)记录
  * @param uid int 用户uid
  * @param tob string 业务类型
  * @param scores int 积分(图腾币)点数
  * @param round int 第几轮签到记录
  * @param title string 名称
  * @return boolean(true/false)
  */
 public function addPointsLog($data)
 {
     $user = $this->user->get($data['uid']);
     $this->load->model('Dcredit_model', 'dcredit');
     $froum_credit = $this->dcredit->get_user_credit($user['mobile']);
     $round = empty($data['round']) ? 1 : $data['round'];
     $userinfo = $this->user_info->get($data['uid']);
     $all_point = $userinfo['points'] + $froum_credit;
     if (in_array($data['tob'], $this->tob_get, true)) {
         $points = $all_point + $data['scores'];
     } elseif (in_array($data['tob'], $this->tob_use, true)) {
         if ($userinfo['points'] < $data['scores']) {
             return false;
         }
         $points = $all_point - $data['scores'];
     }
     $pointlogs = array('uid' => $data['uid'], 'tob' => $data['tob'], 'scores' => $data['scores'], 'round' => $round, 'title' => $data['title'], 'after_points' => $points, 'created' => date('Y-m-d H:i:s', time()));
     $this->db->trans_begin();
     parent::create($pointlogs);
     $dta['points'] = $userinfo['points'] + $data['scores'];
     $this->user_info->save($dta, $userinfo['uid']);
     if ($this->db->trans_status() === false) {
         $this->db->trans_rollback();
         return false;
     } else {
         $this->db->trans_commit();
         return true;
     }
 }