public function create()
 {
     $comment = new Comment();
     $count = $comment->where('article_id=' . $_POST['article_id'])->count();
     $data = $_POST;
     $data['created_at'] = date("Y-m-d H:i:s", time());
     $data['updated_at'] = date("Y-m-d H:i:s", time());
     if ($comment->add($data)) {
         // $mod = new Article;
         // $article = $mod->where('article_id='.$_POST['article_id'])->find();
         // $msg = '文章:['.$article['title'].'] 下有新的评论:'.$_POST['content'];
         //评论成功后给管理员发邮件
         // sendMail('*****@*****.**','有人发表评论',$msg);
         //  session('home.success_msg','评论成功');
         // //$this->success('评论成功');
         // $this->redirect('Article/show',array('id'=>$_POST['article_id']), 0, '');
         $item = array('ret' => 0, 'data' => $data, 'key' => $count + 1);
         $this->ajaxReturn($item);
     } else {
         $this->ajaxReturn(array('ret' => 1));
     }
 }
 /**
  * 同时删除相关表里面的数据
  * $noNeedTrans表示不需要事务控制
  * 返回值:true/false
  */
 public function deleteById($id, $noNeedTrans = false)
 {
     $map['id'] = $id;
     $pariseList = $this->getPraiseList($id);
     $commentList = $this->getCommentList($id);
     $pariseTable = new PraiseMoodModel();
     $commentTable = new CommentModel();
     if (!$noNeedTrans) {
         $this->startTrans();
     }
     while (list($key, $parise) = each($pariseList)) {
         if ($pariseTable->deleteByMoodId($id, true) === false) {
             if (!$noNeedTrans) {
                 $this->rollback();
             }
             return false;
         }
     }
     while (list($key, $comment) = each($commentList)) {
         if ($commentTable->deleteById($comment['id'], true) === false) {
             if (!$noNeedTrans) {
                 $this->rollback();
             }
             return false;
         }
     }
     if ($this->where($map)->delete() === false) {
         if (!$noNeedTrans) {
             $this->rollback();
         }
         return false;
     }
     if (!$noNeedTrans) {
         return $this->commit();
     } else {
         return true;
     }
 }
예제 #3
0
 /**
  *动作: 删除文章
  **/
 public function delete()
 {
     $article = new Article();
     $comments = new Comment();
     $id = $_GET['id'];
     $comments->where('article_id=' . $id)->delete();
     $article->where('article_id=' . $id)->delete();
     $data = array('ret' => 0, 'msg' => '删除成功');
     $this->ajaxReturn($data);
 }
 /**
  *动作: 删除评论
  **/
 public function delete()
 {
     $comment = new Comment();
     $id = $_GET['id'];
     if ($comment->where('id=' . $id)->delete()) {
         $data = array('ret' => 0, 'msg' => '删除成功');
         $this->ajaxReturn($data);
     }
 }
예제 #5
0
 /**
  * 同时删除相关表里面的数据
  * $noNeedTrans表示不需要事务控制
  * 返回值:返回false表示删除失败,返回true表示删除成功
  */
 public function deleteById($id, $noNeedTrans = false)
 {
     $map['id'] = $id;
     $moodList = $this->getRelatedMoodById($id);
     $moodTable = new MoodListModel();
     if (!$noNeedTrans) {
         $this->startTrans();
     }
     while (list($key, $mood) = each($moodList)) {
         if ($moodTable->deleteById($mood['id'], true) === false) {
             if (!$noNeedTrans) {
                 $this->rollback();
             }
             return false;
         }
     }
     $praiseList = $this->getRelatedPraiseById($id);
     $praiseTable = new PraiseMoodModel();
     while (list($key, $praise) = each($praiseList)) {
         if ($praiseTable->deleteByUserId($praise['user_id'], true) === false) {
             if (!$noNeedTrans) {
                 $this->rollback();
             }
             return false;
         }
     }
     $commentList = $this->getRelatedCommentById($id);
     $commentTable = new CommentModel();
     while (list($key, $comment) = each($commentList)) {
         if ($commentTable->deleteById($comment['id'], true) === false) {
             if (!$noNeedTrans) {
                 $this->rollback();
             }
             return false;
         }
     }
     $letterList = $this->getRelatedLetterById($id);
     $letterTable = new LetterListModel();
     while (list($key, $letter) = each($letterList)) {
         if ($letterTable->deleteById($letter['id'], true) === false) {
             if (!$noNeedTrans) {
                 $this->rollback();
             }
             return false;
         }
     }
     if ($this->where($map)->delete() === false) {
         if (!$noNeedTrans) {
             $this->rollback();
         }
         return false;
     }
     if (!$noNeedTrans) {
         return $this->commit();
     } else {
         return true;
     }
 }