/php/lib/component/assessment_results_table_admin/assessment_results_table_overview_data_provider.class.php

<?php

namespace application\weblcms\tool\assessment;



use application\weblcms\ContentObjectPublicationCourseGroup;

use application\weblcms\ContentObjectPublicationUser;

use application\weblcms\ContentObjectPublication;

use application\weblcms\WeblcmsDataManager;

use application\weblcms\WeblcmsRights;

use application\weblcms\WeblcmsManager;



use repository\ContentObject;

use repository\RepositoryDataManager;

use repository\content_object\assessment\Assessment;

use repository\content_object\hotpotatoes\Hotpotatoes;



use user\User;



use common\libraries\SubselectCondition;

use common\libraries\OrCondition;

use common\libraries\InCondition;

use common\libraries\Utilities;

use common\libraries\AndCondition;

use common\libraries\EqualityCondition;

use common\libraries\ObjectTableDataProvider;



/**

 * $Id: assessment_results_table_overview_data_provider.class.php 216 2009-11-13 14:08:06Z kariboe $

 * @package application.lib.weblcms.tool.assessment.component.assessment_results_table_admin

 */

/**

 * This class represents a data provider for a results candidate table

 */

class AssessmentResultsTableOverviewAdminDataProvider extends ObjectTableDataProvider

{

    /**

     * The user id of the current active user.

     */

    private $owner;

    /**

     * The possible types of learning objects which can be selected.

     */

    private $types;

    /**

     * The search query, or null if none.

     */

    private $query;

    

    private $parent;

    

    private $pid;



    /**

     * Constructor.

     * @param int $owner The user id of the current active user.

     * @param array $types The possible types of learning objects which can be

     * selected.

     * @param string $query The search query.

     */

    function __construct($parent, $owner, $pid = null, $types = array(), $query = null)

    {

        $this->types = $types;

        $this->owner = $owner;

        $this->query = $query;

        $this->parent = $parent;

        $this->pid = $pid;

    }



    /*

	 * Inherited

	 */

    function get_objects($offset, $count, $order_property = null)

    {

        $order_property = $this->get_order_property($order_property);

        

        if ($this->pid == null)

        {

            $publications = $this->get_publications($offset, $count, $order_property);

        }

        else

        {

            $publications = $this->get_publication($this->pid);

        }

        //return $this->get_assessments($publications);

        return $publications;

    }



    function get_publication($pid)

    {

        $datamanager = WeblcmsDataManager :: get_instance();

        $publication = $datamanager->retrieve_content_object_publication($pid);

        if (! $publication->is_visible_for_target_users() && ! ($this->parent->is_allowed(WeblcmsRights :: DELETE_RIGHT) || $this->parent->is_allowed(WeblcmsRights :: EDIT_RIGHT)))

        {

            return array();

        }

        return array($publication);

    }



    function get_publications($from, $count, $column, $direction)

    {

        $datamanager = WeblcmsDataManager :: get_instance();

        $tool_condition = new EqualityCondition(ContentObjectPublication :: PROPERTY_TOOL, 'assessment');

        $condition = $tool_condition;

        $lo_condition = $this->get_condition();

        if ($this->parent->is_allowed(WeblcmsRights :: EDIT_RIGHT))

        {

            $user_id = null;

            $course_group_ids = null;

        }

        else

        {

            $user_id = $this->parent->get_user_id();

            $course_groups = $this->parent->get_course_groups();

            

            $course_group_ids = array();

            

            foreach ($course_groups as $course_group)

            {

                $course_group_ids[] = $course_group->get_id();

            }

        }

        $course = $this->parent->get_course_id();

        

        $conditions = array();

        $conditions[] = new EqualityCondition(ContentObjectPublication :: PROPERTY_COURSE_ID, $course);

        $conditions[] = new EqualityCondition(ContentObjectPublication :: PROPERTY_TOOL, 'assessment');

        

        /*$access = array();

        if (! empty($user_id) || ! empty($course_group_ids))

        {

            $access[] = new InCondition('user_id', $user_id, $datamanager->get_alias('content_object_publication_user'));

            $access[] = new InCondition('course_group_id', $course_group_ids, $datamanager->get_alias('content_object_publication_course_group'));

            $access[] = new AndCondition(array(new EqualityCondition('user_id', null, $datamanager->get_alias('content_object_publication_user')), new EqualityCondition('course_group_id', null, $datamanager->get_alias('content_object_publication_course_group'))));

            $conditions[] = new OrCondition($access);

        }*/

        

        $access = array();

        if ($user_id)

        {

            $access[] = new InCondition(ContentObjectPublicationUser :: PROPERTY_USER, $user_id, ContentObjectPublicationUser :: get_table_name());

        }

        

        if (count($course_group_ids) > 0)

        {

            $access[] = new InCondition(ContentObjectPublicationCourseGroup :: PROPERTY_COURSE_GROUP_ID, $course_group_ids, ContentObjectPublicationCourseGroup :: get_table_name());

        }

        

        if (! empty($user_id) || ! empty($course_group_ids))

        {

            $access[] = new AndCondition(array(

                    new EqualityCondition(ContentObjectPublicationUser :: PROPERTY_USER, null, ContentObjectPublicationUser :: get_table_name()), 

                    new EqualityCondition(ContentObjectPublicationCourseGroup :: PROPERTY_COURSE_GROUP_ID, null, ContentObjectPublicationCourseGroup :: get_table_name())));

        }

        

        $conditions[] = new OrCondition($access);

        

        $subselect_conditions = array();

        $subselect_conditions[] = $this->get_condition();

        /*if($this->parent->get_condition())

		{

			$subselect_conditions[] = $this->parent->get_condition();

		}*/

        $subselect_condition = new AndCondition($subselect_conditions);

        

        $conditions[] = new SubselectCondition(ContentObjectPublication :: PROPERTY_CONTENT_OBJECT_ID, ContentObject :: PROPERTY_ID, ContentObject :: get_table_name(), $subselect_condition, null, RepositoryDataManager :: get_instance());

        $condition = new AndCondition($conditions);

        

        $publications = $datamanager->retrieve_content_object_publications($condition);

        while ($publication = $publications->next_result())

        {

            // If the results is hidden and the user is not allowed to DELETE or EDIT, don't show this results

            if (! $publication->is_visible_for_target_users() && ! ($this->parent->is_allowed(WeblcmsRights :: DELETE_RIGHT) || $this->parent->is_allowed(WeblcmsRights :: EDIT_RIGHT)))

            {

                continue;

            }

            $visible_publications[] = $publication;

        }

        $publications = $visible_publications;

        return $publications;

    }



    /*

	 * Inherited

	 */

    function get_object_count()

    {

        return count($this->get_publications());

    }



    /**

     * Gets the condition by which the learning objects should be selected.

     * @return Condition The condition.

     */

    function get_condition()

    {

        $owner = $this->owner;

        

        $conds = array();

        $parent = $this->parent;

        $category = $parent->get_parameter(WeblcmsManager :: PARAM_CATEGORY);

        $category = $category ? $category : 0;

        $conds[] = new EqualityCondition(ContentObjectPublication :: PROPERTY_CATEGORY_ID, $category, ContentObjectPublication :: get_table_name());

        

        $type_cond = array();

        $types = array(Assessment :: get_type_name(), Hotpotatoes :: get_type_name());

        foreach ($types as $type)

        {

            $type_cond[] = new EqualityCondition(ContentObject :: PROPERTY_TYPE, $type);

        }

        $conds[] = new OrCondition($type_cond);

        $c = Utilities :: query_to_condition($this->query);

        if (! is_null($c))

        {

            $conds[] = $c;

        }

        return new AndCondition($conds);

    }

}

?>