/lenasys/trunk

To get this branch, use:
bzr branch http://gegoxaren.bato24.eu/bzr/lenasys/trunk

« back to all changes in this revision

Viewing changes to codeigniter/application/models/admin/admin_model.php

  • Committer: galaxyAbstractor
  • Date: 2013-04-24 14:31:47 UTC
  • mto: This revision was merged to the branch mainline in revision 52.
  • Revision ID: galaxyabstractor@gmail.com-20130424143147-1pdkbu65n1896lmu
Started implementing categories and a menu

Show diffs side-by-side

added added

removed removed

Lines of Context:
codeigniter/application/models/admin/admin_model.php
28
28
 
29
29
        }
30
30
 
31
 
        function getExamples($cid) {
32
 
                $query = $this->db->get_where('Examples', array("courseID" => $cid));
33
 
                return $query->result();
34
 
        }
35
 
 
36
 
        function addExample($cid, $example, $description){
 
31
        function getMenu(){
 
32
                $menu = array();
 
33
                $courses = $this->db->get("courses");
 
34
                foreach ($courses->result() as $course) {
 
35
                        $menu[$course->name] = array();
 
36
                        $menu[$course->name]['CID'] = $course->courseID;
 
37
                        $categories = $this->db->get_where("categories", array("courseID" => $course->courseID));
 
38
 
 
39
                        foreach($categories->result() as $category){
 
40
                                $menu[$course->name][$category->categoryName] = array();
 
41
 
 
42
                                $subcategories = $this->db->get_where("subcategories", array("courseID" => $course->courseID, "categoryName" => $category->categoryName));
 
43
 
 
44
                                foreach($subcategories->result() as $subcategory){
 
45
                                        $menu[$course->name][$category->categoryName][$subcategory->subCategoryName] = array();
 
46
 
 
47
                                }
 
48
                        }
 
49
                }
 
50
                
 
51
                return $menu;
 
52
 
 
53
        }
 
54
 
 
55
        function getCategories($cid) {
 
56
                $query = $this->db->get_where('Categories', array("courseID" => $cid));
 
57
                return $query->result();
 
58
        }
 
59
 
 
60
        function addCategory($cid, $categoryName){
 
61
                $this->db->select_max("orderNr");
 
62
                $query = $this->db->get_where('Categories', array("courseID" => $cid));
 
63
 
 
64
                $result = $query->result();
 
65
                $data = array(
 
66
                        'courseID' => $cid ,
 
67
                        'categoryName' => $categoryName,
 
68
                        'orderNr' => $result[0]->orderNr+1
 
69
                        );
 
70
 
 
71
                $this->db->insert('Categories', $data); 
 
72
                //mkdir("../courses/".$cid."/".$example);
 
73
 
 
74
        }
 
75
 
 
76
        function getSubCategories($cid, $categoryName) {
 
77
                $query = $this->db->get_where('subcategories', array("courseID" => $cid, "categoryName" => $categoryName));
 
78
                return $query->result();
 
79
        }
 
80
 
 
81
        function addSubCategory($cid, $categoryName, $subCategoryName){
 
82
                $this->db->select_max("orderNr");
 
83
                $query = $this->db->get_where('subcategories', array("courseID" => $cid, "categoryName" => $categoryName));
 
84
 
 
85
                $result = $query->result();
 
86
                $data = array(
 
87
                        'courseID' => $cid ,
 
88
                        'subCategoryName' => $subCategoryName,
 
89
                        'categoryName' => $categoryName,
 
90
                        'orderNr' => $result[0]->orderNr+1
 
91
                        );
 
92
 
 
93
                $this->db->insert('subcategories', $data); 
 
94
                //mkdir("../courses/".$cid."/".$example);
 
95
 
 
96
        }
 
97
 
 
98
        function getExamples($cid, $categoryName, $subCategoryName) {
 
99
                $query = $this->db->get_where('Examples', array("courseID" => $cid, "categoryName" => $categoryName, "subCategoryName" => $subCategoryName));
 
100
                return $query->result();
 
101
        }
 
102
 
 
103
        function addExample($cid, $categoryName, $subCategoryName, $example, $description){
 
104
                $this->db->select_max("orderNr");
 
105
                $query = $this->db->get_where('examples', array("courseID" => $cid, "categoryName" => $categoryName, "subCategoryName" => $subCategoryName));
 
106
                $result = $query->result();
37
107
                $data = array(
38
108
                        'courseID' => $cid ,
39
109
                        'exampleName' => $example,
40
 
                        'description' => $description
 
110
                        'description' => $description,
 
111
                        'categoryName' => $categoryName,
 
112
                        'subCategoryName' => $subCategoryName,
 
113
                        'orderNr' => $result[0]->orderNr+1
41
114
                        );
42
115
 
43
116
                $this->db->insert('Examples', $data);