<?php
/**
* 栏目管理
* @作者 qinggan <admin@phpok.com>
* @主页 http://www.phpok.com
* @版本 4.x
* @授权 http://www.phpok.com/lgpl.html PHPOK开源授权协议：GNU Lesser General Public License
* @时间 2017年08月23日
**/
if(!defined("PHPOK_SET")){exit("<h1>Access Denied</h1>");}
class cate_model_base extends phpok_model
{
public function __construct()
{
parent::model();
}
public function get_root_id(&$rootid,$id)
{
$sql = "SELECT parent_id FROM ".$this->db->prefix."cate WHERE id='".$id."'";
$rs = $this->db->get_one($sql);
if($rs){
if(!$rs['parent_id']){
$rootid = $id;
}else{
$this->get_root_id($rootid,$rs['parent_id']);
}
}
}
public function get_one($id,$field="id",$ext=true,$is_edit=false)
{
if(!$id){
return false;
}
$sql = " SELECT * FROM ".$this->db->prefix."cate WHERE `".$field."`='".$id."' AND site_id='".$this->site_id."'";
$rs = $this->db->get_one($sql);
if(!$rs){
return false;
}
if(!$ext){
return $rs;
}
$ext_rs = $this->cate_module($rs['id'],$is_edit);
if($ext_rs){
$rs = array_merge($ext_rs,$rs);
}
$tmplist = $this->model('ext')->ext_all('cate-'.$rs['id'],true);
if(!$tmplist){
return $rs;
}
$ext_rs = array();
foreach($tmplist as $key=>$value){
$ext_rs[$value['identifier']] = $value['content'];
if(!$is_edit){
$ext_rs[$value['identifier']] = $this->lib('form')->show($value);
}
}
$rs = array_merge($ext_rs,$rs);
return $rs;
}
protected function cate_module($id,$is_edit=false)
{
$sql = "SELECT parent_id,module_id FROM ".$this->db->prefix."cate WHERE id='".$id."'";
$tmp = $this->db->get_one($sql);
if(!$tmp){
return false;
}
if(!$tmp['parent_id']){
$rootid = $id;
}else{
$rootid = $tmp['parent_id'];
$this->get_root_id($rootid,$tmp['parent_id']);
}
if(!$rootid){
return false;
}
$sql = "SELECT module_id FROM ".$this->db->prefix."cate WHERE id='".$rootid."'";
$info = $this->db->get_one($sql);
if(!$info){
return false;
}
$flist = $this->model('module')->fields_all($info['module_id']);
if(!$flist){
return false;
}
$fields = array();
foreach($flist as $key=>$value){
$fields[] = $value['identifier'];
}
$sql = "SELECT ".implode(",",$fields)." FROM ".$this->db->prefix."cate_".$info['module_id']." WHERE id='".$id."'";
$rs = $this->db->get_one($sql);
if(!$rs){
return false;
}
if($is_edit){
return $rs;
}
foreach($flist as $key=>$value){
$rs[$value['identifier']] = $this->lib('form')->show($value,$rs[$value['identifier']]);
}
return $rs;
}
protected function catelist_module($mid)
{
$flist = $this->model('module')->fields_all($mid);
if(!$flist){
return false;
}
$fields = array();
$fields[] = 'id';
foreach($flist as $key=>$value){
$fields[] = $value['identifier'];
}
$sql = "SELECT ".implode(",",$fields)." FROM ".$this->db->prefix."cate_".$mid;
$tmplist = $this->db->get_all($sql);
if(!$tmplist){
return false;
}
$rslist = array();
foreach($tmplist as $key=>$value){
foreach($flist as $k=>$v){
$value[$v['identifier']] = $this->lib('form')->show($v,$value[$v['identifier']]);
}
$rslist[$value['id']] = $value;
}
return $rslist;
}
public function cate_info($id,$ext=false)
{
if($ext){
return $this->get_one($id,'id',true);
}
$sql = "SELECT * FROM ".$this->db->prefix."cate WHERE id='".$id."'";
return $this->db->get_one($sql);
}
public function max_cateid()
{
$sql = "SELECT max(id) FROM ".$this->db->prefix."cate";
return $this->db->count($sql);
}
public function cate_one($id,$site_id=0)
{
if($site_id){
$rslist = $this->cate_all($site_id,true);
if($rslist[$id]){
return $rslist[$id];
}
return false;
}else{
$sql = "SELECT * FROM ".$this->db->prefix."cate WHERE id='".$id."' AND status=1";
return $this->db->get_one($sql);
}
}
public function get_all($site_id=0,$status=0,$pid=0)
{
$rslist = $this->cate_all($site_id,$status);
if(!$rslist){
return false;
}
$tmplist = array();
$this->format_list($tmplist,$rslist,$pid,"0");
$this->cate_list = $tmplist;
return $tmplist;
}
public function cate_list($condition='',$offset=0,$psize=0,$orderby="")
{
$sql = " SELECT * FROM ".$this->db->prefix."cate ";
if($condition){
$sql .= " WHERE ".$condition." ";
}
if(!$orderby){
$orderby = "taxis ASC,id DESC";
}
$sql .= " ORDER BY ".$orderby." ";
if($psize && intval($psize)>0){
$sql .= " LIMIT ".intval($offset).",".intval($psize);
}
$rslist = $this->db->get_all($sql,'id');
if(!$rslist){
return false;
}
$extlist = array();
$idlist = array_keys($rslist);
foreach($rslist as $key=>$value){
if($value['parent_id']){
$rootid = 0;
$this->get_root_id($rootid,$value['parent_id']);
if(!$rootid){
continue;
}
$tmp = $this->get_one($rootid,'id',false,false);
$value['module_id'] = $tmp['module_id'];
}
if(!$value['module_id']){
continue;
}
$tmplist = $this->catelist_module($value['module_id']);
if(!$tmplist){
continue;
}
foreach($tmplist as $k=>$v){
if(!$v['id'] || !$rslist[$v['id']]){
continue;
}
foreach($flist as $kk=>$vv){
if(!$v[$vv['identifier']]){
continue;
}
$rslist[$v['id']][$vv['identifier']] = $v[$vv['identifier']];
}
}
}
return $this->cate_ext($rslist);
}
public function cate_all($site_id=0,$status=0,$orderby='')
{
$sql = " SELECT * FROM ".$this->db->prefix."cate WHERE site_id='".$site_id."'";
if($status){
$sql .= " AND status='1' ";
}
if(!$orderby){
$orderby = "taxis ASC,id DESC";
}
$sql .= " ORDER BY ".$orderby." ";
$rslist = $this->db->get_all($sql,'id');
if(!$rslist){
return false;
}
$extlist = array();
$idlist = array_keys($rslist);
foreach($rslist as $key=>$value){
if($value['parent_id']){
continue;
}
if(!$value['module_id']){
continue;
}
$flist = $this->model('module')->fields_all($value['module_id']);
if(!$flist){
continue;
}
$tmplist = $this->catelist_module($value['module_id']);
if(!$tmplist){
continue;
}
foreach($tmplist as $k=>$v){
if(!$v['id'] || !$rslist[$v['id']]){
continue;
}
foreach($flist as $kk=>$vv){
if(!$v[$vv['identifier']]){
continue;
}
$rslist[$v['id']][$vv['identifier']] = $v[$vv['identifier']];
}
}
}
return $this->cate_ext($rslist);
}
public function format_list(&$rslist,$tmplist,$parent_id=0,$layer=0)
{
if(!$tmplist && !is_array($tmplist)){
$tmplist = array();
}
foreach($tmplist as $key=>$value){
if($value["parent_id"] == $parent_id){
$is_end = true;
foreach($tmplist as $k=>$v){
if($v["parent_id"] == $value["id"]){
$is_end = false;
break;
}
}
$value["_layer"] = $layer;
$value["_is_end"] = $is_end;
$rslist[] = $value;
$new_layer = $layer+1;
$this->format_list($rslist,$tmplist,$value["id"],$new_layer);
}
}
}
public function cate_option_list($list)
{
if(!$list || !is_array($list)){
return false;
}
$rslist = array();
foreach($list as $key=>$value){
$value["_space"] = "";
for($i=0;$i<$value["_layer"];$i++){
$value["_space"] .= " │";
}
if($value["_is_end"] && $value["_layer"]){
$value["_space"] .= " ├";
}
$rslist[$key] = $value;
}
return $rslist;
}
public function cate_fields(&$idlist)
{
$sql = "SHOW FIELDS FROM ".$this->db->prefix."cate";
$rslist = $this->db->get_all($sql);
if($rslist){
foreach($rslist as $key=>$value){
$idlist[] = $value["Field"];
}
}
}
public function get_son_id_list($id,$status=0)
{
if(!$id){
return false;
}
$sql = "SELECT id FROM ".$this->db->prefix."cate WHERE parent_id IN(".$id.")";
if($status){
$sql .= " AND status='1'";
}
$rslist = $this->db->get_all($sql,"id");
if(!$rslist){
return false;
}
$id_list = array_keys($rslist);
return $id_list;
}
public function get_sublist(&$list,$id,$space="")
{
if(!$id){
return false;
}
$sql = "SELECT * FROM ".$this->db->prefix."cate WHERE parent_id='".$id."'";
$rslist = $this->db->get_all($sql);
if($rslist){
foreach($rslist as $key=>$value){
$value["space"] = $space ? $space."├ " : "";
$list[] = $value;
$newspace = $space ." ";
$this->get_sublist($list,$value["id"],$newspace);
}
}
}
public function get_sonlist($id=0,$status=0)
{
$id = $this->_ids($id);
if(!$id){
return false;
}
$list = array();
$sql = "SELECT id FROM ".$this->db->prefix."cate WHERE parent_id IN(".$id.") ";
if($status){
$sql .= " AND status=1 ";
}
$sql .= " ORDER BY SUBSTRING_INDEX('".$id."',id,1),taxis ASC";
$rslist = $this->db->get_all($sql);
if($rslist){
foreach($rslist as $key=>$value){
$list[] = $value['id'];
}
}
$list = array_unique($list);
$id = implode(",",$list);
return $this->catelist_cid($id,true);
}
public function parent_list(&$list,$id=0,$status=0,$ext=false)
{
$rs = $this->get_one($id,'id',$ext,false);
if($status && !$rs['status']){
return false;
}
$list[] = $rs;
if($rs['parent_id']){
$this->parent_list($list,$rs['parent_id'],$status,$ext);
}
}
public function get_sonlist_id(&$list,$id=0,$status=0)
{
$id = $this->_ids($id);
if(!$id){
return false;
}
$sql = "SELECT id FROM ".$this->db->prefix."cate WHERE parent_id IN(".$id.") ";
if($status){
$sql .= " AND status=1 ";
}
$sql .= " ORDER BY SUBSTRING_INDEX('".$id."',id,1),taxis ASC";
$rslist = $this->db->get_all($sql);
if($rslist){
$idlist = array();
foreach($rslist as $key=>$value){
$list[] = $value["id"];
$idlist[] = $value['id'];
}
$idstring = implode(",",$idlist);
$this->get_sonlist_id($list,$idstring,$status);
}
}
public function count_sublist($ids = 0)
{
if(!$ids){
$ids = 0;
}
if($ids && is_array($ids)){
$ids = implode(",",$ids);
}
$sql = "SELECT count(id) as total,parent_id FROM ".$this->db->prefix."cate WHERE parent_id IN(".$ids.") GROUP BY parent_id";
$rs = $this->db->get_all($sql);
if(!$rs){
return false;
}
$rslist = array();
foreach($rs as $key=>$value){
$rslist[$value['parent_id']] = $value['total'];
}
return $rslist;
}
public function update_taxis($id,$taxis=255)
{
$sql = "UPDATE ".$this->db->prefix."cate SET taxis='".$taxis."' WHERE id='".$id."'";
return $this->db->query($sql);
}
public function cate_delete($id)
{
$rs = $this->get_one($id);
if($rs['parent_id']){
$rootid = $rs['parent_id'];
$this->get_root_id($rootid,$rs['parent_id']);
$root = $this->get_one($rootid);
if($root['module_id']){
$sql = "DELETE FROM ".$this->db->prefix."cate_".$root['module_id']." WHERE id='".$rs['id']."'";
$this->db->query($sql);
}
}
$sql = "DELETE FROM ".$this->db->prefix."cate WHERE id='".$id."'";
$this->db->query($sql);
$sql = "UPDATE ".$this->db->prefix."list SET cate_id=0 WHERE cate_id='".$id."'";
$this->db->query($sql);
$sql = "DELETE FROM ".$this->db->prefix."list_cate WHERE cate_id='".$id."'";
$this->db->query($sql);
$sql = "SELECT id FROM ".$this->db->prefix."fields WHERE ftype='cate-".$id."'";
$rslist = $this->db->get_all($sql,'id');
if($rslist){
$idlist = array_keys($rslist);
$sql = "DELETE FROM ".$this->db->prefix."extc WHERE id IN(".implode(',',$idlist).")";
$this->db->query($sql);
$sql = "DELETE FROM ".$this->db->prefix."fields WHERE id IN(".implode(',',$idlist).")";
$this->db->query($sql);
}
$this->model('tag')->stat_delete('c'.$id,"title_id");
return true;
}
public function root_catelist($site_id=0)
{
if(!$site_id){
$site_id = $this->site_id;
}
if(!$site_id){
return false;
}
$sql = "SELECT * FROM ".$this->db->prefix."cate WHERE parent_id=0 AND site_id='".$site_id."' ORDER BY taxis ASC,id DESC";
return $this->db->get_all($sql,"id");
}
public function catelist_cid($cid,$ext=true)
{
if(!$cid){
return false;
}
if(is_array($cid)){
$cid = implode(",",$cid);
}
$sql = "SELECT * FROM ".$this->db->prefix."cate WHERE id IN(".$cid.") AND status=1 ORDER BY SUBSTRING_INDEX('".$cid."',id,1) ";
$rslist = $this->db->get_all($sql,"id");
if(!$rslist){
return false;
}
if(!$ext){
return $rslist;
}
return $this->cate_ext($rslist);
}
public function catelist_sonlist($cid,$ext=true,$status=1)
{
if(!$cid){
return false;
}
$sql = "SELECT * FROM ".$this->db->prefix."cate WHERE parent_id=".intval($cid)." ";
if($status){
$sql .= ' AND status=1 ';
}
$sql.= " ORDER BY taxis ASC,id DESC ";
$rslist = $this->db->get_all($sql,"id");
if(!$rslist){
return false;
}
if(!$ext){
return $rslist;
}
return $this->cate_ext($rslist);
}
public function cate_ext($rslist)
{
if(!$rslist){
return false;
}
$idlist = array_keys($rslist);
$total = count($idlist);
$clist = array();
foreach($idlist as $key=>$value){
$clist[] = "cate-".$value;
}
$cateinfo = implode(",",$clist);
$extlist = $this->model('ext')->get_all($cateinfo,true);
foreach($rslist as $key=>$value){
$tmp = $extlist["cate-".$key];
if($tmp){
$rslist[$key] = array_merge($tmp,$value);
}
}
return $rslist;
}
public function catelist_extlist($mid,$format=true)
{
$flist = $this->model('module')->fields_all($mid);
if(!$flist){
return false;
}
$fields = array("id");
foreach($flist as $key=>$value){
$fields[] = $value['identifier'];
}
$sql = "SELECT ".implode(",",$fields)." FROM ".$this->db->prefix."cate_".$mid;
$tmplist = $this->db->get_all($sql);
if(!$tmplist){
return false;
}
if(!$format){
$rslist = array();
foreach($tmplist as $key=>$value){
$rslist[$value['id']] = $value;
}
return $rslist;
}
$rslist = array();
foreach($tmplist as $key=>$value){
foreach($flist as $k=>$v){
if($value[$v['identifier']] == ''){
continue;
}
$value[$v['identifier']] = $this->lib('form')->show($v,$value[$v['identifier']]);
}
$rslist[$value['id']] = $value;
}
return $rslist;
}
public function cate_ids(&$array,$parent_id=0,$rslist='')
{
if($rslist && is_array($rslist)){
foreach($rslist as $key=>$value){
if($value['parent_id'] == $parent_id){
$array[] = $value['id'];
$this->cate_ids($array,$value['id'],$rslist);
}
}
}
}
public function ext_catelist($id,$pri="id")
{
$sql = "SELECT c.* FROM ".$this->db->prefix."list_cate lc JOIN ".$this->db->prefix."cate c ON(lc.cate_id=c.id) ";
$sql.= "WHERE lc.id='".$id."' AND c.status=1 ORDER BY c.taxis ASC,c.id DESC";
return $this->db->get_all($sql,$pri);
}
public function list_ids($ids,$project_identifier='')
{
if(!$ids){
return false;
}
$ids = is_array($ids) ? implode(",",$ids) : $ids;
$sql = "SELECT * FROM ".$this->db->prefix."cate WHERE id IN(".$ids.") AND status=1";
$rslist = $this->db->get_all($sql,'id');
if(!$rslist){
return false;
}
foreach($rslist as $key=>$value){
if($project_identifier){
$value['url'] = $this->url($project_identifier,$value['identifier']);
}
$cate_tmp = $this->model('ext')->ext_all('cate-'.$value['id'],true);
if($cate_tmp){
$cate_ext = array();
foreach($cate_tmp as $k=>$v){
$cate_ext[$v['identifier']] = $this->lib('form')->show($v);
if($v['form_type'] == 'url' && $v['content']){
$v['content'] = unserialize($v['content']);
$value['url'] = $v['content']['default'];
if($this->site['url_type'] == 'rewrite' && $v['content']['rewrite']){
$value['url'] = $v['content']['rewrite'];
}
}
}
$value = array_merge($cate_ext,$value);
unset($cate_ext,$cate_tmp);
}
$rslist[$key] = $value;
}
return $rslist;
}
}