Example #1
0
 public static function genarateCatList()
 {
     $result = DB::getInstance()->directSelect("SELECT * FROM category;");
     $categoryStruct = array(array());
     foreach ($result as $key => $row) {
         $catagory = new Category();
         $catagory->set_id($row['category_id']);
         $catagory->set_label($row['category_no']);
         $catagory->set_name($row['category_name']);
         //$catagories[] = $catagory;
         $mainCat1 = substr($row['category_no'], 0, 1);
         $mainCat2 = substr($row['category_no'], 1, 1);
         $subCat1 = substr($row['category_no'], 2, 1);
         $subCat2 = substr($row['category_no'], 3, 1);
         //echo"$mainCat1 $mainCat2 $subCat1 $subCat2 # ";
         if ((int) $subCat1 == 0 && (int) $subCat2 == 0) {
             //echo"$mainCat1 $mainCat2 $subCat1 $subCat2";
             $categoryStruct[$mainCat1][(int) $mainCat2] = $catagory;
         }
     }
     return $categoryStruct;
 }
 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;
 }