mint/api-v8/public/app/article/function.php

<?php
require_once "../config.php";
require_once "../share/function.php";
require_once "../db/table.php";

class Article extends Table
{
    function __construct($redis=false) {
		parent::__construct(_FILE_DB_USER_ARTICLE_, _TABLE_ARTICLE_, _DB_USERNAME_,_DB_PASSWORD_,$redis);
    }

    public function getInfo($id){
		$output = array();
		if($this->redis!==false){
			if($this->redis->exists("article://".$id)===1){
				$output["id"]=$this->redis->hGet("article://".$id,"id");
				$output["title"]=$this->redis->hGet("article://".$id,"title");
				$output["subtitle"]=$this->redis->hGet("article://".$id,"subtitle");
				$output["owner"]=$this->redis->hGet("article://".$id,"owner");
				$output["summary"]=$this->redis->hGet("article://".$id,"summary");
				$output["lang"]=$this->redis->hGet("article://".$id,"lang");
				$output["tag"]="";
				$output["status"]=$this->redis->hGet("article://".$id,"status");
				$output["create_time"]=$this->redis->hGet("article://".$id,"create_time");
				$output["modify_time"]=$this->redis->hGet("article://".$id,"modify_time");
				return $output;
			}
		}
        $query = "SELECT uid as id,title,owner,subtitle,summary,lang,status,create_time,modify_time FROM "._TABLE_ARTICLE_." WHERE uid= ? ";
        $stmt = $this->dbh->prepare($query);
        $stmt->execute(array($id));
        $output = $stmt->fetch(PDO::FETCH_ASSOC);
        if($output){
			if($this->redis!==false){
				$this->redis->hSet("article://".$id,"id",$output["id"]);
				$this->redis->hSet("article://".$id,"title",$output["title"]);
				if(isset($output["subtitle"])){
					$this->redis->hSet("article://".$id,"subtitle",$output["subtitle"]);
				}
				$this->redis->hSet("article://".$id,"summary",$output["summary"]);
				$this->redis->hSet("article://".$id,"lang",$output["lang"]);
				$this->redis->hSet("article://".$id,"owner",$output["owner"]);
				$this->redis->hSet("article://".$id,"status",$output["status"]);
				$this->redis->hSet("article://".$id,"create_time",$output["create_time"]);
				$this->redis->hSet("article://".$id,"modify_time",$output["modify_time"]);
			}
            return $output;
        }
        else{
            return false;
        }
	}

    public function getContent($id){
		$output = array();
		if($this->redis!==false){
			if($this->redis->hExists("article://".$id,"content")===TRUE){
				$content=$this->redis->hGet("article://".$id,"content");
				return $content;
			}
		}
        $query = "SELECT content FROM ".$this->table." WHERE uid= ? ";
        $stmt = $this->dbh->prepare($query);
        $stmt->execute(array($id));
        $output = $stmt->fetch(PDO::FETCH_ASSOC);
        if($output){
			if($this->redis!==false){
				$this->redis->hSet("article://".$id,"content",$output["content"]);
			}
            return $output["content"];
        }
        else{
            return false;
        }
	}

	public function getPower($id,$collectionId=""){
		#查询用户对此是否有权限	
		if(isset($_COOKIE["user_uid"])){
			$userId = $_COOKIE["user_uid"];
		}
		else{
			$userId=0;
		}

		if($this->redis!==false){
			$power = $this->redis->hGet("power://article/".$id,$userId);
			if($power!==FALSE){
				return $power;
			}
		}

		$iPower = 0;
		$query = "SELECT owner,status FROM "._TABLE_ARTICLE_." WHERE uid=?  ";
		$stmt = $this->dbh->prepare($query);
		$stmt->execute(array($id));
		$channel = $stmt->fetch(PDO::FETCH_ASSOC);
		if($channel){
			if(!isset($_COOKIE["user_uid"])){
				#未登录用户
				if($channel["status"]==30){
					#全网公开有读取和建议权限
					$iPower =  10;
				}
				else{
					#其他状态没有任何权限
					$iPower =  0;
				}
			}
			else{
				if($channel["owner"]==$_COOKIE["user_uid"]){
					#自己的
					$iPower =  30;
				}
				else if($channel["status"]>=30){
					#全网公开的 可以提交pr
					$iPower = 10;
				}				
			}
		}
		#查询共享权限，如果共享权限更大，覆盖上面的的
		$sharePower = share_get_res_power($userId,$id);
		if($collectionId!=""){
			$sharePowerCollection = share_get_res_power($userId,$collectionId);
		}
		else{
			$sharePowerCollection =0;
		}
		if($sharePower>$iPower){
			$iPower=$sharePower;
		}
		if($sharePowerCollection>$iPower){
			$iPower=$sharePowerCollection;
		}
		if($this->redis!==false){
			$this->redis->hSet("power://article/".$id,$userId,$iPower);
		}
		return $iPower;
	}

}


class ArticleList extends Table
{
    function __construct($redis=false) {
		parent::__construct(_FILE_DB_USER_ARTICLE_, _TABLE_ARTICLE_COLLECTION_, _DB_USERNAME_,_DB_PASSWORD_,$redis);
    }

	function upgrade($collectionId,$articleList=array()){
		# 更新 article_list 表
		$query = "DELETE FROM ".$this->table." WHERE collect_id = ? ";
		$stmt = $this->dbh->prepare($query);
		if($stmt){
			$stmt->execute(array($collectionId));
		}

		if(count($articleList)>0){
			/* 开始一个事务，关闭自动提交 */
			$this->dbh->beginTransaction();
			$query = "INSERT INTO ".$this->table." (id, collect_id, article_id,level,title) VALUES (?, ?, ?, ? , ? )";
			$sth = $this->dbh->prepare($query);
			foreach ($articleList as $row) {
				$sth->execute(
                    array(
                        $this->SnowFlake->id(),
                        $collectionId,
                        $row["article"],
                        $row["level"],
                        $row["title"]
                        ));
				if($this->redis){
					#删除article权限缓存
					$this->redis->del("power://article/".$row["article"]);
				}
			}
			$this->dbh->commit();
			if (!$sth || ($sth && $sth->errorCode() != 0)) {
				/*  识别错误且回滚更改  */
				$this->dbh->rollBack();
				$error = $this->dbh->errorInfo();;
				$respond['status']=1;
				$respond['message']=$error[2];
			}
		}
	}
}
?>