/**
* 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);
}
