docs/include/classes/DAO/ForumsCoursesDAO.class.php

   1 <?php
   2 /************************************************************************/
   3 /* AContent                                                             */
   4 /************************************************************************/
   5 /* Copyright (c) 2010                                                   */
   6 /* Inclusive Design Institute                                           */
   7 /*                                                                      */
   8 /* This program is free software. You can redistribute it and/or        */
   9 /* modify it under the terms of the GNU General Public License          */
  10 /* as published by the Free Software Foundation.                        */
  11 /************************************************************************/
  12
  13 /**
  14 * DAO for "forums_courses" table
  15 * @access       public
  16 * @author       Cindy Qi Li
  17 * @package      DAO
  18 */
  19
  20 if (!defined('TR_INCLUDE_PATH')) exit;
  21
  22 require_once(TR_INCLUDE_PATH. 'classes/DAO/DAO.class.php');
  23
  24 class ForumsCoursesDAO extends DAO {
  25
  26         /**
  27         * Insert a new row
  28         * @access  public
  29         * @param   forum_id, course_id
  30         * @return  true / false
  31         * @author  Cindy Qi Li
  32         */
  33         function Create($forum_id, $course_id)
  34         {
  35                 $sql =  'INSERT INTO ' . TABLE_PREFIX . 'forums_courses' .
  36                                 '(forum_id, course_id) ' .
  37                                 'VALUES (' . $forum_id . ", $course_id)";
  38             return $this->execute($sql);
  39         }
  40
  41         /**
  42         * Delete row by course ID
  43         * @access  public
  44         * @param   courseID
  45         * @return  true or false
  46         * @author  Cindy Qi Li
  47         */
  48         function DeleteByCourseID($courseID)
  49         {
  50             include_once(TR_INCLUDE_PATH.'classes/DAO/ForumsDAO.class.php');
  51             $forumsDAO = new ForumsDAO();
  52
  53                 $all_forums = $this->getByCourse($courseID);
  54             if (is_array($all_forums)) {
  55                 foreach ($all_forums as $forums) {
  56                         $forumsDAO->Delete($forums['forum_id']);
  57                 }
  58             }
  59                 $sql = "DELETE FROM ".TABLE_PREFIX."forums_courses
  60                      WHERE course_id = ".$courseID."";
  61             return $this->execute($sql);
  62         }
  63
  64         /**
  65         * Delete row by forum ID
  66         * @access  public
  67         * @param   forumID
  68         * @return  true or false
  69         * @author  Cindy Qi Li
  70         */
  71         function DeleteByForumID($forumID)
  72         {
  73             $sql = "DELETE FROM ".TABLE_PREFIX."forums_courses
  74                      WHERE forum_id = ".$forumID."";
  75             return $this->execute($sql);
  76         }
  77
  78         /**
  79         * Return rows by course ID
  80         * @access  public
  81         * @param   name
  82         * @return  table rows
  83         * @author  Cindy Qi Li
  84         */
  85         function getByCourse($course_id)
  86         {
  87             $sql = "SELECT * FROM ".TABLE_PREFIX."forums_courses WHERE course_id = '".$course_id."'";
  88             return $this->execute($sql);
  89         }
  90
  91         /**
  92         * Return rows by forum ID
  93         * @access  public
  94         * @param   name
  95         * @return  table rows
  96         * @author  Cindy Qi Li
  97         */
  98         function getByForum($forum_id)
  99         {
 100             $sql = "SELECT * FROM ".TABLE_PREFIX."forums_courses WHERE forum_id = '".$forum_id."'";
 101             return $this->execute($sql);
 102         }
 103 }
 104 ?>