class.ilLPStatusSurveyFinished.php

Go to the documentation of this file.

<?php

// patch-begin svy_lp

/* Copyright (c) 1998-2010 ILIAS open source, Extended GPL, see docs/LICENSE */

include_once './Services/Tracking/classes/class.ilLPStatus.php';

class ilLPStatusSurveyFinished extends ilLPStatus
{
        static function _getInProgress($a_obj_id)
        {
                return self::getParticipants($a_obj_id);
        }
        
        static function _getCompleted($a_obj_id)
        {                                               
                return self::getParticipants($a_obj_id, true);
        }

        function determineStatus($a_obj_id, $a_user_id, $a_obj = null)
        {                               
                $survey_id = self::getSurveyId($a_obj_id);
                if(!$survey_id)
                {
                        return;
                }
                
                $status = ilLPStatus::LP_STATUS_NOT_ATTEMPTED_NUM;              
                
                include_once './Modules/Survey/classes/class.ilObjSurveyAccess.php';            
                if(ilObjSurveyAccess::_isSurveyParticipant($a_user_id, $survey_id))
                {
                        $status = ilLPStatus::LP_STATUS_IN_PROGRESS_NUM;
                        
                        if(ilObjSurveyAccess::_lookupFinished($a_obj_id, $a_user_id))
                        {
                                $status = ilLPStatus::LP_STATUS_COMPLETED_NUM;
                        }
                }

                return $status;         
        }
                
        protected static function getSurveyId($a_obj_id)
        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT survey_id FROM svy_svy".
                        " WHERE obj_fi = ".$ilDB->quote($a_obj_id));
                $row = $ilDB->fetchAssoc($set);
                return (int)$row["survey_id"];
        }
        
        public static function getParticipants($a_obj_id, $a_only_finished = false)
        {
                global $ilDB;
                
                $res = array();
                
                $survey_id = self::getSurveyId($a_obj_id);
                if(!$survey_id)
                {
                        return $res;
                }               
                
                $sql = "SELECT user_fi FROM svy_finished fin".
                                " WHERE fin.survey_fi = ".$ilDB->quote($survey_id, "integer");          
                
                if($a_only_finished)
                {
                        $sql .= " AND fin.state = ".$ilDB->quote(1, "integer");
                }
                
                $set = $ilDB->query($sql);
                while($row = $ilDB->fetchAssoc($set))
                {
                        $res[] = $row["user_fi"];
                }
                
                return $res;
        }

}

// patch-end svy_lp

?>