文章添加,删除,修改,分页列表

Art:

<?php
/**
 * @name UserController
 * @author pangee
 * @desc 用户控制器
 */
class ArtController extends Yaf_Controller_Abstract {

	public function indexAction() {
		return $this->listAction();
	}
	public function addAction($artId=0){
		if(!$this->_isAdmin())
		{
			echo json_encode( array("errno"=>-2000, "errmsg"=>"需要管理员权限才可以操作") );
			return FALSE;
		}
		$submit = $this->getRequest()->getQuery( "submit", "0" );
		if($submit!="1"){
			echo json_encode(array("errno"=>-2001,"errmsg"=>"请通过正确渠道提交"));
			return false;
		}
		$title = $this->getRequest()->getPost( "title", false );
		$contents = $this->getRequest()->getPost( "contents", false );
		$author = $this->getRequest()->getPost( "author", false );
		$cate = $this->getRequest()->getPost( "cate", false );

		if(!$title||!$contents||!$author||!$cate){
			echo json_encode( array("errno"=>-2002, "errmsg"=>"标题、内容、作者、分类信息为空，不能为空") );
			return FALSE;
		}
		$model = new ArtModel();
		if ( $lastId = $model->add( trim($title), trim($contents), trim($author), trim($cate), $artId) ) {
			echo json_encode( array(
							"errno"=>0,
							"errmsg"=>"",
							"data"=>array("lastId"=>$lastId),
						));
		} else {
			echo json_encode( array(
						"errno"=>$model->errno,
						"errmsg"=>$model->errmsg,
					));
		}
		return TRUE;
	}
	public function editAction(){

		if(!$this->_isAdmin()){
		  	echo json_encode( array("errno"=>-2000, "errmsg"=>"需要管理员权限才可以操作") );
			return FALSE;
		  }
		$artId = $this->getRequest()->getQuery( "artId", "0" );
		if( is_numeric($artId) && $artId ) {
			return $this->addAction( $artId );
		} else {
			echo json_encode( array("errno"=>-2003, "errmsg"=>"缺少必要的文章ID参数") );
		}
		return TRUE;

	}
	public function delAction(){

		if(!$this->_isAdmin()){
		  	echo json_encode( array("errno"=>-2000, "errmsg"=>"需要管理员权限才可以操作") );
			return FALSE;
		  }
		$artId=$this->getRequest()->getQuery('artId',"0");
		if(is_numeric($artId)&&$artId){
			$model = new ArtModel();
			if( $model->del( $artId ) ) {
				echo json_encode( array(
							"errno"=>0,
							"errmsg"=>"",
						));
			} else {
				echo json_encode( array(
						"errno"=>$model->errno,
						"errmsg"=>$model->errmsg,
					));
			}
		} else {
			echo json_encode( array("errno"=>-2003, "errmsg"=>"缺少必要的文章标题参数") );
		}
		return TRUE;
	}
	public function statusAction(){

		if(!$this->_isAdmin()){
		  	echo json_encode( array("errno"=>-2000, "errmsg"=>"需要管理员权限才可以操作") );
			return FALSE;
		  }
		$artId=$this->getRequest()->getQuery('artId',"0");
		$status = $this->getRequest()->getQuery( "status", "offline" );
		if(is_numeric($artId)&&$artId){
			$model = new ArtModel();
			if( $model->status( $artId,$status) ) {
				echo json_encode( array(
							"errno"=>0,
							"errmsg"=>"",
						));
			} else {
				echo json_encode( array(
						"errno"=>$model->errno,
						"errmsg"=>$model->errmsg,
					));
			}
		} else {
			echo json_encode( array("errno"=>-2003, "errmsg"=>"缺少必要的文章标题参数") );
		}
		return TRUE;

	}
	public function getAction(){
		$artId = $this->getRequest()->getQuery( "artId", "0" );
		
		if( is_numeric($artId) && $artId ) {
			$model = new ArtModel();
			if( $data=$model->get( $artId ) ) {
				echo json_encode( array(
							"errno"=>0,
							"errmsg"=>"",
							"data"=>$data,
						));
			} else {
				echo json_encode( array("errno"=>-2009, "errmsg"=>"获取文章信息失败") );
			}
		} else {
			echo json_encode( array("errno"=>-2003, "errmsg"=>"缺少必要的文章标题参数") );
		}
		return TRUE;


	}
	public function listAction(){

		$pageNo = $this->getRequest()->getQuery( "pageNo", "0" );
		$pageSize = $this->getRequest()->getQuery( "pageSize", "10" );
		$cate = $this->getRequest()->getQuery( "cate", "0" );
		$status = $this->getRequest()->getQuery( "status", "online" );
		
		$model = new ArtModel();
		if( $data=$model->list( $pageNo, $pageSize, $cate, $status ) ) {
			echo json_encode( array(
						"errno"=>0,
						"errmsg"=>"",
						"data"=>$data,
					));
		} else {
			echo json_encode( array("errno"=>-2012, "errmsg"=>"获取文章列表失败") );
		}
		return TRUE;
	}
	public function _isAdmin(){
		return true;
	}

	
}

　　Artmodel:

  

<?php
/**
 * @name UserModel
 * @desc 用户操作Model类
 * @author pangee
 */
class ArtModel {
	public $errno = 0;
	public $errmsg = "";
	private $_db;

    public function __construct() {
		$this->_db = new PDO("mysql:host=127.0.0.1;dbname=imooc;", "root", "");
		$this->_db->setAttribute( PDO::ATTR_EMULATE_PREPARES, false );
    }   
   public function add( $title, $contents, $author, $cate, $artId=0 ) {
       $isEdit=false;
       if($artId!=0&&is_numeric($artId)){
         $query = $this->_db->prepare("select count(*) from `art` where `id`= ? ");
			$query->execute( array($artId) );
			$ret = $query->fetchAll();
			if ( !$ret || count($ret)!=1 ) {
				$this->errno = -2004;
				$this->errmsg = "找不到你要编辑的文章！";
				return false;
			}
			$isEdit = true;
       }else{

       	$query=$this->_db->prepare("select count(*) from 'cate' where 'id' =?");
       	$query->execute(array($cate));
       	$ret=$query->fetchAll();
       	if ( !$ret || $ret[0][0]==0 ) {
				$this->errno = -2005;
				$this->errmsg = "找不到对应ID的分类信息，cate id:".$cate.", 请先创建该分类。";
				return false;
			}
       }
       $data=array($title,$contents,$author,intval($cate));
       if(!$isEdit){
       	  $query = $this->_db->prepare("insert into `art` (`title`,`contents`,`author`,`cate`) VALUES ( ?, ?, ?, ? )");
       }else {
			$query = $this->_db->prepare("update `art` set `title`=?, `contents`=?, `author`=?, `cate`=? where `id`= ?");
			$data[] = $artId;
		}
		$ret = $query->execute( $data );
		if ( !$ret ) {
			$this->errno = -2006;
			$this->errmsg = "操作文章数据表失败, ErrInfo:".end($query->errorInfo());
			return false;
		}
		if( !$isEdit ) {
			return intval($this->_db->lastInsertId());
		} else {
			return intval($artId);
		}

    }

   	public function del( $artId ){
		$query = $this->_db->prepare("delete from `art` where `id`=? ");
		$ret = $query->execute( array(intval($artId)) );
		if( !$ret ) {
			$this->errno = -2007;
			$this->errmsg = "删除失败, ErrInfo:".end($query->errorInfo());
			return false;
		}
		return true;
	}

	public function status( $artId, $status="offline" ){
		$query = $this->_db->prepare("update `art` set `status`=? where `id`=? ");
		$ret = $query->execute( array( $status, intval($artId)) );
		if( !$ret ) {
			$this->errno = -2008;
			$this->errmsg = "更新文章状态失败, ErrInfo:".end($query->errorInfo());
			return false;
		}
		return true;
	}

	public function get( $artId ){
		$query = $this->_db->prepare("select `title`,`contents`,`author`,`cate`,`ctime`,`mtime`,`status` from `art` where `id`=? ");
		$status = $query->execute( array( intval($artId)) );
		$ret = $query->fetchAll();
		if( !$status || !$ret ) {
			$this->errno = -2009;
			$this->errmsg = "查询失败, ErrInfo:".end($query->errorInfo());
			return false;
		}
		$artInfo = $ret[0];
		/**
		 * 获取分类信息
		 */
		$query = $this->_db->prepare("select `name` from `cate` where `id`=?");
		$query->execute( array( $artInfo['cate']) );
		$ret = $query->fetchAll();
		if( !$ret ) {
			$this->errno = -2010;
			$this->errmsg = "获取分类信息失败, ErrInfo:".end($query->errorInfo());
			return false;
		}
		$artInfo['cateName'] = $ret[0]['name'];

		$data = array(
					'id' => intval($artId),
					'title'=> $artInfo['title'],
					'contents'=> $artInfo['contents'],
					'author'=> $artInfo['author'],
					'cateName'=> $artInfo['cateName'],
					'cateId'=> intval($artInfo['cate']),
					'ctime'=> $artInfo['ctime'],
					'mtime'=> $artInfo['mtime'],
					'status'=> $artInfo['status'],
				);
		return $data;
	}

	public function list($pageNo=0, $pageSize=10, $cate=0, $status="online"){
       $start=$pageNo*$pageSize+($pageNo==0?0:1);
      	if( $cate == 0 ) {
			$filter = array( $status, intval($start), intval($pageSize) );
			$query = $this->_db->prepare("select `id`, `title`,`contents`,`author`,`cate`,`ctime`,`mtime`,`status` from `art` where `status`=? order by `ctime` desc limit ?,?  ");
		} else {
			$filter = array( intval($cate), $status, intval($start), intval($pageSize) );
			$query = $this->_db->prepare("select `id`, `title`,`contents`,`author`,`cate`,`ctime`,`mtime`,`status` from `art` where `cate`=? and `status`=? order by `ctime` desc limit ?,?  ");
		}
		$stat=$query->execute($filter);
		$ret=$stat->fetchAll();
		if(!$ret){
			$this->errno = -2011;
			$this->errmsg = "获取文章列表失败, ErrInfo:".end($query->errorInfo());
			return false;
		}

		$data = array();
		$cateInfo = array();

		foreach( $ret as $item ) {
			/**
			 * 获取分类信息
			 */
			if( isset($cateInfo[$item['cate']]) ){ 
				$cateName = $cateInfo[$item['cate']];
			} else {
				$query = $this->_db->prepare("select `name` from `cate` where `id`=?");
				$query->execute( array( $item['cate']) );
				$retCate = $query->fetchAll();
				if( !$retCate ) {
					$this->errno = -2010;
					$this->errmsg = "获取分类信息失败, ErrInfo:".end($query->errorInfo());
					return false;
				}
				$cateName = $cateInfo[$item['cate']] = $retCate[0]['name'];
			}

			/**
			 * 正文太长则剪切
			 */
			$contents = mb_strlen($item['contents'])>30 ? mb_substr($item['contents'], 0, 30)."..." : $item['contents'];

			$data[] = array(
						'id' => intval($item['id']),
						'title'=> $item['title'],
						'contents'=> $contents,
						'author'=> $item['author'],
						'cateName'=> $cateName,
						'cateId'=> intval($item['cate']),
						'ctime'=> $item['ctime'],
						'mtime'=> $item['mtime'],
						'status'=> $item['status'],
					);
		}
		return $data;
	}
    
	

}