private static function create_category_objects_from_sql_result($result)
 {
     $allcat = array();
     while ($data = Database::fetch_array($result)) {
         $cat = new Category();
         $cat->set_id($data['id']);
         $cat->set_name($data['name']);
         $cat->set_description($data['description']);
         $cat->set_user_id($data['user_id']);
         $cat->set_course_code($data['course_code']);
         $cat->set_parent_id($data['parent_id']);
         $cat->set_weight($data['weight']);
         $cat->set_visible($data['visible']);
         $cat->set_session_id($data['session_id']);
         $cat->set_certificate_min_score($data['certif_min_score']);
         $cat->set_grade_model_id($data['grade_model_id']);
         $cat->set_locked($data['locked']);
         $allcat[] = $cat;
     }
     return $allcat;
 }
 /**
  * Create a category object from a GradebookCategory entity
  * @param Chamilo\CoreBundle\Entity\GradebookCategory $gradebookCategory
  *         The entity
  * @return \Category
  */
 public static function createCategoryObjectFromEntity(Chamilo\CoreBundle\Entity\GradebookCategory $gradebookCategory)
 {
     $category = new Category();
     $category->set_id($gradebookCategory->getId());
     $category->set_name($gradebookCategory->getName());
     $category->set_description($gradebookCategory->getDescription());
     $category->set_user_id($gradebookCategory->getUserId());
     $category->set_course_code($gradebookCategory->getCourseCode());
     $category->set_parent_id($gradebookCategory->getParentId());
     $category->set_weight($gradebookCategory->getWeight());
     $category->set_visible($gradebookCategory->getVisible());
     $category->set_session_id($gradebookCategory->getSessionId());
     $category->set_certificate_min_score($gradebookCategory->getCertifMinScore());
     $category->set_grade_model_id($gradebookCategory->getGradeModelId());
     $category->set_locked($gradebookCategory->getLocked());
     $category->setGenerateCertificates($gradebookCategory->getGenerateCertificates());
     $category->setIsRequirement($gradebookCategory->getIsRequirement());
     return $category;
 }