/** * Preload all metadata from storage. * * @return void */ public function preload() { $all = Model::all(); foreach ($all as $data) { $this->cache[$data[Model::KEY_NAME]] = $data[Model::VALUE_NAME]; } }
public function all() { if ($instance = parent::all()) { $data = $this->relationSelect($instance); return $data; } else { return $instance; } }
/** * Get all projects * @param boolean $full Project with all data (buttons, tags...) * @return array */ public function all($full = false) { $projects = parent::all(); if ($full) { $this->addTags($projects, false); $this->addButtons($projects); } return $projects; }
function selectModel(Model $model) { $foreignKey = $this->foreignKey; if (isset($model->{$foreignKey})) { $select = $this->augmentSelect($model->all()); $select = $select->equal(Model::tableFor($this->localClass) . '.' . $this->foreignKey, $model->{$foreignKey}); } else { $select = $this->augmentSelect($model->select()); } if (isset($select[0])) { return $select[0]; } else { return null; } }
public function Get_New_Three() { $sql = "select \r\n\t\t\t\t\t\t\t\t\tc.username as c_username,\r\n\t\t\t\t\t\t\t\t\tc.content,\r\n\t\t\t\t\t\t\t\t\tc.date,\r\n\t\t\t\t\t\t\t\t\tc.state,\r\n\t\t\t\t\t\t\t\t\tc.manner,\r\n\t\t\t\t\t\t\t\t\tc.id,\r\n\t\t\t\t\t\t\t\t\tc.cid,\r\n\t\t\t\t\t\t\t\t\tc.sustain,\r\n\t\t\t\t\t\t\t\t\tc.oppose,\r\n\t\t\t\t\t\t\t\t\tu.username as u_username,\r\n\t\t\t\t\t\t\t\t\tu.face as face\r\n\t\t\t\t\t\t\tfrom \r\n\t\t\t\t\t\t\t\t\tcomment as c\r\n\t\t\t\t\t\tleft join\r\n\t\t\t\t\t\t\t\t\tuser as u \r\n\t\t\t\t\t\t\ton\r\n\t\t\t\t\t\t\t\t\tu.username=c.username\r\n\t\t\t\t\t\t\twhere \r\n\t\t\t\t\t\t\t\t\tc.cid='{$this->cid}' \r\n\t\t\t\t\t\t\torder by \r\n\t\t\t\t\t\t\t\t\tdate \r\n\t\t\t\t\t\t\tDESC \r\n\t\t\t\t\t\t\tlimit 0,3"; return parent::all($sql); }
public function getFiveTag() { $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\t\ttagname,count \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\t\tcms_tag \n\t\t\t\t\t\tORDER BY \n\t\t\t\t\t\t\t\t\t\t\tcount DESC \n\t\t\t\t\t\t\t\tLIMIT \n\t\t\t\t\t\t\t\t\t\t\t0,5"; return parent::all($_sql); }
public function getAllLimitLevel() { $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\tid,\n\t\t\t\t\t\t\t\t\t\tlevel_name,\n\t\t\t\t\t\t\t\t\t\tlevel_info,\n\t\t\t\t\t\t\t\t\t\tpremission \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\tcms_level\n\t\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\t\t\t\t\tid DESC\n\t\t\t\t\t\t\t\t{$this->limit}"; return parent::all($_sql); }
public function getLaterUser() { $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\t\tuser,\n\t\t\t\t\t\t\t\t\t\t\tface \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\t\tcms_user \n\t\t\t\t\t\tORDER BY \n\t\t\t\t\t\t\t\t\t\t\ttime DESC \n\t\t\t\t\t\t\t\tLIMIT \n\t\t\t\t\t\t\t\t\t\t\t0,6"; return parent::all($_sql); }
public function getAllNav() { $_sql = "SELECT mid,module_name FROM tg_module ORDER BY mid ASC"; return parent::all($_sql); }
public function Get_All_Childid() { $sql = "select id from nav where parid <> 0"; return parent::all($sql); }
public function getAllRotatain() { $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\t\t\tid,\n\t\t\t\t\t\t\t\t\t\t\t\ttitle,\n\t\t\t\t\t\t\t\t\t\t\t\tlink,\n\t\t\t\t\t\t\t\t\t\t\t\tlink full,\n\t\t\t\t\t\t\t\t\t\t\t\tstate \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\t\t\tcms_rotatain\n\t\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\t\t\t\t\t\t\tstate DESC,date DESC\n\t\t\t\t\t\t\t\t\t{$this->limit}"; return parent::all($_sql); }
public function delMenu() { $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\tDISTINCT l.pid\n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\ttg_menu r,\n\t\t\t\t\t\t\t\t\t\ttg_menu l\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\tl.mid = '{$this->mid}'\n\t\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\t \t\tl.pid = r.cid"; return parent::all($_sql); }
public function getAllComment() { $_sql = "SELECT \t\n\t\t\t\t\t\t\t\t\t\t\tc.id,\n\t\t\t\t\t\t\t\t\t\t\tc.cid,\n\t\t\t\t\t\t\t\t\t\t\tc.user,\n\t\t\t\t\t\t\t\t\t\t\tc.manner,\n\t\t\t\t\t\t\t\t\t\t\tc.content,\n\t\t\t\t\t\t\t\t\t\t\tc.date,\n\t\t\t\t\t\t\t\t\t\t\tc.sustain,\n\t\t\t\t\t\t\t\t\t\t\tc.oppose,\n\t\t\t\t\t\t\t\t\t\t\tu.face \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\t\tcms_comment c\n\t\t\t\t\t\tLEFT JOIN\n\t\t\t\t\t\t\t\t\t\t\tcms_user u\n\t\t\t\t\t\t\t\t\tON\n\t\t\t\t\t\t\t\t\t\t\tc.user=u.user\n\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\tc.state=1\n\t\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\t\t\t\tc.cid='{$this->cid}'\n\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\t\t\t\t\t\tc.date DESC\n\t\t\t\t\t\t\t\t\t\t{$this->limit}"; return parent::all($_sql); }
public function getAllLimitPremission() { $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\t\tid,\n\t\t\t\t\t\t\t\t\t\t\tname,\n\t\t\t\t\t\t\t\t\t\t\tinfo \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\t\tcms_premission\n\t\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\t\t\t\t\t\tid DESC\n\t\t\t\t\t\t\t\t{$this->limit}"; return parent::all($_sql); }
public function getSecMenu() { $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\tl.menu_name as fir_nemu,\n\t\t\t\t\t\t\t\t\t\tr.mid,\n\t\t\t\t\t\t\t\t\t\tr.menu_name as sec_nemu,\n\t\t\t\t\t\t\t\t\t\tr.pid\n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\ttg_menu r,\n\t\t\t\t\t\t\t\t\t\ttg_menu l\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\tl.mid = {$this->mid}\n\t\t\t\t\t\t\t\tAND \n \t\t\t\t\t\t\t\t l.pid = r.cid\n\t\t\t\t\t\t\t\t{$this->reg}\n\t\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\t\t\t\t\tl.menu_name desc"; return parent::all($_sql); }
public function getAllAdver() { $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\t\t\tid,\n\t\t\t\t\t\t\t\t\t\t\t\ttitle,\n\t\t\t\t\t\t\t\t\t\t\t\tlink,\n\t\t\t\t\t\t\t\t\t\t\t\ttype,\n\t\t\t\t\t\t\t\t\t\t\t\tstate \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\t\t\tcms_adver\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t\t\ttype IN ({$this->kind})\n\t\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\t\t\t\t\t\t\tdate DESC\n\t\t\t\t\t\t\t\t{$this->limit}"; return parent::all($_sql); }
public function getUserInfo() { $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\t* \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\ttg_user"; return parent::all($_sql); }
public function getLaterUser() { $_sql = "select user, face from cms_user order by time desc limit 0, 6;"; return parent::all($_sql); }
public function getAllChildFrontNav() { $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\tid,\n\t\t\t\t\t\t\t\t\t\tnav_name,\n\t\t\t\t\t\t\t\t\t\tnav_info,\n\t\t\t\t\t\t\t\t\t\tsort \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\tcms_nav\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\tpid='{$this->id}'\n\t\t\t\t\t\t\tORDER BY \n\t\t\t\t\t\t\t\t\t\tsort ASC"; return parent::all($_sql); }
public function getModule() { $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\t* \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\ttg_module"; return parent::all($_sql); }
public function getAllComment() { $_sql = "select c.id, c.cid, c.user, c.manner, c.content, c.date, c.sustain, c.oppose, u.face from cms_comment c left join cms_user u on c.user=u.user where c.cid='{$this->cid}' order by c.date desc {$this->limit};"; return parent::all($_sql); }
public function getAllLimitLevel() { $_sql = "select id, level_name, level_info from cms_level order by id desc {$this->limit};"; return parent::all($_sql); }
public function getAllManage() { $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\tm.id,\n\t\t\t\t\t\t\t\t\t\tm.admin_user,\n\t\t\t\t\t\t\t\t\t\tm.login_count,\n\t\t\t\t\t\t\t\t\t\tm.last_ip,\n\t\t\t\t\t\t\t\t\t\tm.last_time, \n\t\t\t\t\t\t\t\t\t\tl.level_name\n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\tcms_manage m,\n\t\t\t\t\t\t\t\t\t\tcms_level l\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\tl.id = m.level\n\t\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\t\t\t\t\tm.id ASC\n\t\t\t\t\t\t\t\t\t{$this->limit}"; return parent::all($_sql); }
public function All_Index_Rotatain() { $sql = "select id,title,info,pic,link,state from rotatain where state=1"; return parent::all($sql); }
public function Get_ALL_User() { //获取数据 $sql = "select\r\n\t\t\t\t\t\t\t\t*\r\n\t\t\t\t\t from\r\n\t\t\t\t\t\t\t\tuser\r\n\t\t\t\t\torder by\r\n\t\t\t\t\t\t\t\ttime\r\n\t\t\t\t\tDESC\r\n\t\t\t\t\t{$this->limit}"; return parent::all($sql); }
public function Get_ALL_Level() { //获取数据 $sql = "select \r\n\t\t\t\t\t\t\t\tid,\r\n\t\t\t\t\t\t\t\tlevel_position,\r\n\t\t\t\t\t\t\t\tlevel_info\r\n\t\t\t\t\t from\r\n\t\t\t\t\t\t\t\tmanage_level\r\n\t\t\t\t\torder by\r\n\t\t\t\t\t\t\t\tid\r\n\t\t\t\t\tDESC"; return parent::all($sql); }
public function all() { return $this->model->all(); }
public function getListContent() { $_sql = "select c.id, c.title, c.nav, c.title t, c.attr, c.keyword, c.date, c.info, c.gold, c.thumbnail, c.count, n.nav_name from cms_content c, cms_nav n where c.nav=n.id and c.nav in ({$this->nav}) order by c.date desc {$this->limit};"; return parent::all($_sql); }
public function getAll() { $obj = new Model($this->db); echo json_encode($obj->all()); }
public function getAllLevel() { $sql = "select id,level_position from manage_level;"; return parent::all($sql); }