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; }