@@ -16,7 +16,7 @@ |
||
16 | 16 | * |
17 | 17 | * NOTE, this file must be saved in UTF-8 encoding. |
18 | 18 | */ |
19 | -return array ( |
|
19 | +return array( |
|
20 | 20 | 'Category Post Count' => '', |
21 | 21 | 'Content Post Cost' => '', |
22 | 22 | 'Date Format' => '', |
@@ -17,30 +17,30 @@ |
||
17 | 17 | * NOTE, this file must be saved in UTF-8 encoding. |
18 | 18 | */ |
19 | 19 | return array ( |
20 | - 'Category Post Count' => '', |
|
21 | - 'Content Post Cost' => '', |
|
22 | - 'Date Format' => '', |
|
23 | - 'Default Language' => '', |
|
24 | - 'Discourse' => '', |
|
25 | - 'Discourse URL' => '', |
|
26 | - 'Display Settings' => '', |
|
27 | - 'Disqus' => '', |
|
28 | - 'Disqus Shortcode' => '', |
|
29 | - 'Force SSL for Secure Areas' => '', |
|
30 | - 'Offline Mode' => '', |
|
31 | - 'Openstack API Key' => '', |
|
32 | - 'Openstack Container Name' => '', |
|
33 | - 'Openstack Identity URL' => '', |
|
34 | - 'Openstack Region' => '', |
|
35 | - 'Openstack Username' => '', |
|
36 | - 'Password Strength Settings' => '', |
|
37 | - 'Search Post Count' => '', |
|
38 | - 'Site Name' => '', |
|
39 | - 'Site Settings' => '', |
|
40 | - 'Time Format' => '', |
|
41 | - 'Upload Settings' => '', |
|
42 | - 'Use Discourse Comments' => '', |
|
43 | - 'Use Disqus Comments' => '', |
|
44 | - 'Use Openstack for Uploads?' => '', |
|
45 | - 'Use Rackspace CDN?' => '', |
|
20 | + 'Category Post Count' => '', |
|
21 | + 'Content Post Cost' => '', |
|
22 | + 'Date Format' => '', |
|
23 | + 'Default Language' => '', |
|
24 | + 'Discourse' => '', |
|
25 | + 'Discourse URL' => '', |
|
26 | + 'Display Settings' => '', |
|
27 | + 'Disqus' => '', |
|
28 | + 'Disqus Shortcode' => '', |
|
29 | + 'Force SSL for Secure Areas' => '', |
|
30 | + 'Offline Mode' => '', |
|
31 | + 'Openstack API Key' => '', |
|
32 | + 'Openstack Container Name' => '', |
|
33 | + 'Openstack Identity URL' => '', |
|
34 | + 'Openstack Region' => '', |
|
35 | + 'Openstack Username' => '', |
|
36 | + 'Password Strength Settings' => '', |
|
37 | + 'Search Post Count' => '', |
|
38 | + 'Site Name' => '', |
|
39 | + 'Site Settings' => '', |
|
40 | + 'Time Format' => '', |
|
41 | + 'Upload Settings' => '', |
|
42 | + 'Use Discourse Comments' => '', |
|
43 | + 'Use Disqus Comments' => '', |
|
44 | + 'Use Openstack for Uploads?' => '', |
|
45 | + 'Use Rackspace CDN?' => '', |
|
46 | 46 | ); |
@@ -16,7 +16,7 @@ |
||
16 | 16 | * |
17 | 17 | * NOTE, this file must be saved in UTF-8 encoding. |
18 | 18 | */ |
19 | -return array ( |
|
19 | +return array( |
|
20 | 20 | 'Access Token' => '', |
21 | 21 | 'Access Token Secret' => '', |
22 | 22 | 'AddThis' => '', |
@@ -17,21 +17,21 @@ |
||
17 | 17 | * NOTE, this file must be saved in UTF-8 encoding. |
18 | 18 | */ |
19 | 19 | return array ( |
20 | - 'Access Token' => '', |
|
21 | - 'Access Token Secret' => '', |
|
22 | - 'AddThis' => '', |
|
23 | - 'AddThis Publisher ID' => '', |
|
24 | - 'App ID' => '', |
|
25 | - 'App Secret' => '', |
|
26 | - 'Client ID' => '', |
|
27 | - 'Client Secret' => '', |
|
28 | - 'Consumer Key' => '', |
|
29 | - 'Consumer Secret' => '', |
|
30 | - 'Facebook' => '', |
|
31 | - 'Google+' => '', |
|
32 | - 'LinkedIn' => '', |
|
33 | - 'Public Server API Key' => '', |
|
34 | - 'Scope' => '', |
|
35 | - 'Social Auth' => '', |
|
36 | - 'Twitter' => '', |
|
20 | + 'Access Token' => '', |
|
21 | + 'Access Token Secret' => '', |
|
22 | + 'AddThis' => '', |
|
23 | + 'AddThis Publisher ID' => '', |
|
24 | + 'App ID' => '', |
|
25 | + 'App Secret' => '', |
|
26 | + 'Client ID' => '', |
|
27 | + 'Client Secret' => '', |
|
28 | + 'Consumer Key' => '', |
|
29 | + 'Consumer Secret' => '', |
|
30 | + 'Facebook' => '', |
|
31 | + 'Google+' => '', |
|
32 | + 'LinkedIn' => '', |
|
33 | + 'Public Server API Key' => '', |
|
34 | + 'Scope' => '', |
|
35 | + 'Social Auth' => '', |
|
36 | + 'Twitter' => '', |
|
37 | 37 | ); |
@@ -16,7 +16,7 @@ |
||
16 | 16 | * |
17 | 17 | * NOTE, this file must be saved in UTF-8 encoding. |
18 | 18 | */ |
19 | -return array ( |
|
19 | +return array( |
|
20 | 20 | 'All Posts' => '', |
21 | 21 | 'Theme' => '', |
22 | 22 | ); |
@@ -17,6 +17,6 @@ |
||
17 | 17 | * NOTE, this file must be saved in UTF-8 encoding. |
18 | 18 | */ |
19 | 19 | return array ( |
20 | - 'All Posts' => '', |
|
21 | - 'Theme' => '', |
|
20 | + 'All Posts' => '', |
|
21 | + 'Theme' => '', |
|
22 | 22 | ); |
@@ -16,7 +16,7 @@ |
||
16 | 16 | * |
17 | 17 | * NOTE, this file must be saved in UTF-8 encoding. |
18 | 18 | */ |
19 | -return array ( |
|
19 | +return array( |
|
20 | 20 | 'Change Theme Settings' => '', |
21 | 21 | 'There are no settings for this section.' => '', |
22 | 22 | 'Unable to save uploaded image.' => '', |
@@ -17,7 +17,7 @@ |
||
17 | 17 | * NOTE, this file must be saved in UTF-8 encoding. |
18 | 18 | */ |
19 | 19 | return array ( |
20 | - 'Change Theme Settings' => '', |
|
21 | - 'There are no settings for this section.' => '', |
|
22 | - 'Unable to save uploaded image.' => '', |
|
20 | + 'Change Theme Settings' => '', |
|
21 | + 'There are no settings for this section.' => '', |
|
22 | + 'Unable to save uploaded image.' => '', |
|
23 | 23 | ); |
@@ -16,7 +16,7 @@ |
||
16 | 16 | * |
17 | 17 | * NOTE, this file must be saved in UTF-8 encoding. |
18 | 18 | */ |
19 | -return array ( |
|
19 | +return array( |
|
20 | 20 | '< Previous' => '', |
21 | 21 | '<< First' => '', |
22 | 22 | 'CApcCache requires PHP apc extension to be loaded.' => '', |
@@ -17,14 +17,14 @@ |
||
17 | 17 | * NOTE, this file must be saved in UTF-8 encoding. |
18 | 18 | */ |
19 | 19 | return array ( |
20 | - '< Previous' => '', |
|
21 | - '<< First' => '', |
|
22 | - 'CApcCache requires PHP apc extension to be loaded.' => '', |
|
23 | - 'CMemCache server configuration must be an array.' => '', |
|
24 | - 'CMemCache server configuration must have "host" value.' => '', |
|
25 | - 'Go to page: ' => '', |
|
26 | - 'Last >>' => '', |
|
27 | - 'Next >' => '', |
|
28 | - 'The "forceCopy" and "linkAssets" cannot be both true.' => '', |
|
29 | - 'The asset "{asset}" to be published does not exist.' => '', |
|
20 | + '< Previous' => '', |
|
21 | + '<< First' => '', |
|
22 | + 'CApcCache requires PHP apc extension to be loaded.' => '', |
|
23 | + 'CMemCache server configuration must be an array.' => '', |
|
24 | + 'CMemCache server configuration must have "host" value.' => '', |
|
25 | + 'Go to page: ' => '', |
|
26 | + 'Last >>' => '', |
|
27 | + 'Next >' => '', |
|
28 | + 'The "forceCopy" and "linkAssets" cannot be both true.' => '', |
|
29 | + 'The asset "{asset}" to be published does not exist.' => '', |
|
30 | 30 | ); |
@@ -3,286 +3,286 @@ |
||
3 | 3 | class m141001_145619_init extends CDbMigration |
4 | 4 | { |
5 | 5 | |
6 | - /** |
|
7 | - * For data insertions, this is the current time. |
|
8 | - * @var integer |
|
9 | - */ |
|
10 | - private $_moment = 0; |
|
11 | - |
|
12 | - public function safeUp() |
|
13 | - { |
|
14 | - $this->_moment = time(); |
|
15 | - |
|
16 | - // Try to get the table names, if we get something back, do not run this migration |
|
17 | - try |
|
18 | - { |
|
19 | - $test = Yii::app()->db->schema->getTables(); |
|
20 | - if (count($test) <= 1) |
|
21 | - throw new Exception('CiiMS doesn\'t exist. Applying base migration'); |
|
22 | - return true; |
|
23 | - } |
|
24 | - catch (Exception $e) |
|
25 | - { |
|
26 | - // Yii will throw an exception if Yii::app()->db->schema is undefined (which is should be if we're doing this for the first time) |
|
27 | - // This SHOULD throw an error if we're running this for the first time - it's the only way to check if we have a valid db or not. |
|
28 | - } |
|
29 | - |
|
30 | - // Otherwise, run the install migration |
|
31 | - $this->createUserTables(); |
|
32 | - |
|
33 | - $this->createCategories(); |
|
34 | - |
|
35 | - $this->createContent(); |
|
36 | - |
|
37 | - $this->createConfiguration(); |
|
38 | - } |
|
39 | - |
|
40 | - public function safeDown() |
|
41 | - { |
|
42 | - echo "m141001_145619_init does not support migration down.\n"; |
|
43 | - return false; |
|
44 | - } |
|
45 | - |
|
46 | - /** |
|
47 | - * Creates the tables, indexes, and relations for users |
|
48 | - */ |
|
49 | - private function createUserTables() |
|
50 | - { |
|
51 | - $this->createTable('users', array( |
|
52 | - 'id' => 'pk', |
|
53 | - 'email' => 'string NOT NULL', |
|
54 | - 'password' => 'string NOT NULL', |
|
55 | - 'username' => 'string NOT NULL', |
|
56 | - 'user_role' => 'integer DEFAULT 1', |
|
57 | - 'status' => 'integer DEFAULT 1', |
|
58 | - 'created' => 'integer', |
|
59 | - 'updated' => 'integer' |
|
60 | - )); |
|
61 | - |
|
62 | - $this->createTable('user_roles', array( |
|
63 | - 'id' => 'pk', |
|
64 | - 'name' => 'string NOT NULL', |
|
65 | - 'created' => 'integer', |
|
66 | - 'updated' => 'integer' |
|
67 | - )); |
|
68 | - |
|
69 | - $this->createTable('user_metadata', array( |
|
70 | - 'user_id' => 'integer', |
|
71 | - 'key' => 'string NOT NULL', |
|
72 | - 'value' => 'text NOT NULL', |
|
73 | - 'entity_type' => 'integer', |
|
74 | - 'created' => 'integer', |
|
75 | - 'updated' => 'integer' |
|
76 | - )); |
|
77 | - |
|
78 | - // Create the necessary indexes on the columns |
|
79 | - $this->createIndex('user_email', 'users', 'email', true); |
|
80 | - $this->createIndex('user_username', 'users', 'username', true); |
|
81 | - $this->createIndex('user_metadata', 'user_metadata', 'user_id, key', false); |
|
82 | - |
|
83 | - $this->addPrimaryKey('user_metadata_composite', 'user_metadata', 'user_id,key'); |
|
84 | - |
|
85 | - // Setup the foreign key constraints |
|
86 | - $this->addForeignKey('user_roles_relation_fk', 'user_metadata', 'user_id', 'users', 'id', 'CASCADE', 'NO ACTION'); |
|
87 | - |
|
88 | - // Insert data into the tables |
|
89 | - $this->insert('user_roles', array( |
|
90 | - 'id' => 1, |
|
91 | - 'name' => 'User', |
|
92 | - 'created' => $this->_moment, |
|
93 | - 'updated' => $this->_moment |
|
94 | - )); |
|
95 | - |
|
96 | - $this->insert('user_roles', array( |
|
97 | - 'id' => 2, |
|
98 | - 'name' => 'Pending', |
|
99 | - 'created' => $this->_moment, |
|
100 | - 'updated' => $this->_moment |
|
101 | - )); |
|
102 | - |
|
103 | - $this->insert('user_roles', array( |
|
104 | - 'id' => 3, |
|
105 | - 'name' => 'Suspended', |
|
106 | - 'created' => $this->_moment, |
|
107 | - 'updated' => $this->_moment |
|
108 | - )); |
|
109 | - |
|
110 | - $this->insert('user_roles', array( |
|
111 | - 'id' => 5, |
|
112 | - 'name' => 'Collaborator', |
|
113 | - 'created' => $this->_moment, |
|
114 | - 'updated' => $this->_moment |
|
115 | - )); |
|
116 | - |
|
117 | - $this->insert('user_roles', array( |
|
118 | - 'id' => 6, |
|
119 | - 'name' => 'Author', |
|
120 | - 'created' => $this->_moment, |
|
121 | - 'updated' => $this->_moment |
|
122 | - )); |
|
123 | - |
|
124 | - $this->insert('user_roles', array( |
|
125 | - 'id' => 7, |
|
126 | - 'name' => 'User', |
|
127 | - 'created' => $this->_moment, |
|
128 | - 'updated' => $this->_moment |
|
129 | - )); |
|
130 | - |
|
131 | - $this->insert('user_roles', array( |
|
132 | - 'id' => 8, |
|
133 | - 'name' => 'Publisher', |
|
134 | - 'created' => $this->_moment, |
|
135 | - 'updated' => $this->_moment |
|
136 | - )); |
|
137 | - |
|
138 | - $this->insert('user_roles', array( |
|
139 | - 'id' => 9, |
|
140 | - 'name' => 'Administrator', |
|
141 | - 'created' => $this->_moment, |
|
142 | - 'updated' => $this->_moment |
|
143 | - )); |
|
144 | - } |
|
145 | - |
|
146 | - /** |
|
147 | - * Create the categories and relations |
|
148 | - */ |
|
149 | - private function createCategories() |
|
150 | - { |
|
151 | - // Categories |
|
152 | - $this->createTable('categories', array( |
|
153 | - 'id' => 'pk', |
|
154 | - 'parent_id' => 'integer DEFAULT 1', |
|
155 | - 'name' => 'string NOT NULL', |
|
156 | - 'slug' => 'string NOT NULL', |
|
157 | - 'created' => 'integer', |
|
158 | - 'updated' => 'integer' |
|
159 | - )); |
|
160 | - |
|
161 | - $this->createTable('categories_metadata', array( |
|
162 | - 'category_id' => 'integer', |
|
163 | - 'key' => 'string NOT NULL', |
|
164 | - 'value' => 'text NOT NULL', |
|
165 | - 'created' => 'integer', |
|
166 | - 'updated' => 'integer' |
|
167 | - )); |
|
168 | - |
|
169 | - // Insert the first record into the categories table |
|
170 | - $this->insert('categories', array( |
|
171 | - 'id' => 1, |
|
172 | - 'name' => 'Uncategorized', |
|
173 | - 'slug' => 'uncategorized', |
|
174 | - 'created' => $this->_moment, |
|
175 | - 'updated' => $this->_moment |
|
176 | - )); |
|
177 | - |
|
178 | - $this->addPrimaryKey('categories_metadata_composite', 'categories_metadata', 'category_id,key'); |
|
179 | - $this->addForeignKey('categories_parents_fk', 'categories', 'parent_id', 'categories', 'id', 'CASCADE', 'NO ACTION'); |
|
180 | - $this->addForeignKey('categories_metadata_fk', 'categories_metadata', 'category_id', 'categories', 'id', 'CASCADE', 'NO ACTION'); |
|
181 | - } |
|
182 | - |
|
183 | - /** |
|
184 | - * Creates the content, comemnts, and necessary relations |
|
185 | - */ |
|
186 | - private function createContent() |
|
187 | - { |
|
188 | - $this->createTable('content', array( |
|
189 | - 'id' => 'integer NOT NULL', |
|
190 | - 'vid' => 'integer NOT NULL DEFAULT 1', |
|
191 | - 'title' => 'string NOT NULL', |
|
192 | - 'content' => 'text NOT NULL', |
|
193 | - 'excerpt' => 'text NOT NULL', |
|
194 | - 'slug' => 'string NOT NULL', |
|
195 | - 'category_id' => 'integer DEFAULT 1', |
|
196 | - 'author_id' => 'integer DEFAULT 1', |
|
197 | - 'type_id' => 'integer DEFAULT 2', |
|
198 | - 'commentable' => 'integer DEFAULT 1', |
|
199 | - 'password' => 'string DEFAULT NULL', |
|
200 | - 'status' => 'integer DEFAULT 0', |
|
201 | - 'like_count' => 'integer DEFAULT 0', |
|
202 | - 'published' => 'integer', |
|
203 | - 'created' => 'integer', |
|
204 | - 'updated' => 'integer' |
|
205 | - )); |
|
206 | - |
|
207 | - $this->createTable('content_types', array( |
|
208 | - 'id' => 'pk', |
|
209 | - 'name' => 'string NOT NULL', |
|
210 | - 'created' => 'integer', |
|
211 | - 'updated' => 'integer' |
|
212 | - )); |
|
213 | - |
|
214 | - $this->createTable('content_metadata', array( |
|
215 | - 'content_id' => 'integer', |
|
216 | - 'key' => 'string NOT NULL', |
|
217 | - 'value' => 'text NOT NULL', |
|
218 | - 'created' => 'integer', |
|
219 | - 'updated' => 'integer' |
|
220 | - )); |
|
221 | - |
|
222 | - $this->createTable('comments', array( |
|
223 | - 'id' => 'pk', |
|
224 | - 'content_id' => 'integer', |
|
225 | - 'author_id' => 'integer', |
|
226 | - 'comment' => 'integer', |
|
227 | - 'created' => 'integer', |
|
228 | - 'updated' => 'integer' |
|
229 | - )); |
|
230 | - |
|
231 | - $this->insert('content_types', array( |
|
232 | - 'id' => 1, |
|
233 | - 'name' => 'Static Page', |
|
234 | - 'created' => $this->_moment, |
|
235 | - 'updated' => $this->_moment |
|
236 | - )); |
|
237 | - |
|
238 | - $this->insert('content_types', array( |
|
239 | - 'id' => 2, |
|
240 | - 'name' => 'Blog Post', |
|
241 | - 'created' => $this->_moment, |
|
242 | - 'updated' => $this->_moment |
|
243 | - )); |
|
244 | - |
|
245 | - $this->addPrimaryKey('content_composite', 'content', 'id, vid'); |
|
246 | - |
|
247 | - $this->execute('ALTER TABLE `content` CHANGE id id INT( 11 ) NOT NULL AUTO_INCREMENT'); |
|
248 | - |
|
249 | - $this->addPrimaryKey('content_metadata_composite', 'content_metadata', 'content_id,key'); |
|
250 | - |
|
251 | - $this->createIndex('content_author', 'content', 'author_id', false); |
|
252 | - $this->createIndex('content_category', 'content', 'category_id', false); |
|
253 | - $this->createIndex('content_type', 'content', 'type_id', false); |
|
254 | - $this->createIndex('comment_content', 'comments', 'content_id', false); |
|
255 | - $this->createIndex('comment_author', 'comments', 'author_id', false); |
|
256 | - |
|
257 | - $this->addForeignKey('content_category_fk', 'content', 'category_id', 'categories', 'id', 'CASCADE', 'NO ACTION'); |
|
258 | - $this->addForeignKey('content_author_fk', 'content', 'author_id', 'users', 'id', 'CASCADE', 'NO ACTION'); |
|
259 | - $this->addForeignKey('content_type_fk', 'content', 'type_id', 'content_types', 'id', 'CASCADE', 'NO ACTION'); |
|
260 | - |
|
261 | - $this->addForeignKey('comments_content_id_fk', 'comments', 'content_id', 'content', 'id', 'CASCADE', 'NO ACTION'); |
|
262 | - $this->addForeignKey('comments_author_fk', 'comments', 'author_id', 'users', 'id', 'CASCADE', 'NO ACTION'); |
|
263 | - } |
|
264 | - |
|
265 | - /** |
|
266 | - * Creates the configuration and events tables |
|
267 | - */ |
|
268 | - private function createConfiguration() |
|
269 | - { |
|
270 | - $this->createTable('configuration', array( |
|
271 | - 'key' => 'string', |
|
272 | - 'value' => 'text NOT NULL', |
|
273 | - 'created' => 'integer', |
|
274 | - 'updated' => 'integer' |
|
275 | - )); |
|
276 | - |
|
277 | - $this->createTable('events', array( |
|
278 | - 'id' => 'pk', |
|
279 | - 'event' => 'string NOT NULL', |
|
280 | - 'event_data' => 'text DEFAULT NULL', |
|
281 | - 'uri' => 'string DEFAULT NULL', |
|
282 | - 'content_id' => 'integer DEFAULT NULL', |
|
283 | - 'created' => 'integer' |
|
284 | - )); |
|
285 | - |
|
286 | - $this->addPrimaryKey('configuration_pk', 'configuration', 'key'); |
|
287 | - } |
|
6 | + /** |
|
7 | + * For data insertions, this is the current time. |
|
8 | + * @var integer |
|
9 | + */ |
|
10 | + private $_moment = 0; |
|
11 | + |
|
12 | + public function safeUp() |
|
13 | + { |
|
14 | + $this->_moment = time(); |
|
15 | + |
|
16 | + // Try to get the table names, if we get something back, do not run this migration |
|
17 | + try |
|
18 | + { |
|
19 | + $test = Yii::app()->db->schema->getTables(); |
|
20 | + if (count($test) <= 1) |
|
21 | + throw new Exception('CiiMS doesn\'t exist. Applying base migration'); |
|
22 | + return true; |
|
23 | + } |
|
24 | + catch (Exception $e) |
|
25 | + { |
|
26 | + // Yii will throw an exception if Yii::app()->db->schema is undefined (which is should be if we're doing this for the first time) |
|
27 | + // This SHOULD throw an error if we're running this for the first time - it's the only way to check if we have a valid db or not. |
|
28 | + } |
|
29 | + |
|
30 | + // Otherwise, run the install migration |
|
31 | + $this->createUserTables(); |
|
32 | + |
|
33 | + $this->createCategories(); |
|
34 | + |
|
35 | + $this->createContent(); |
|
36 | + |
|
37 | + $this->createConfiguration(); |
|
38 | + } |
|
39 | + |
|
40 | + public function safeDown() |
|
41 | + { |
|
42 | + echo "m141001_145619_init does not support migration down.\n"; |
|
43 | + return false; |
|
44 | + } |
|
45 | + |
|
46 | + /** |
|
47 | + * Creates the tables, indexes, and relations for users |
|
48 | + */ |
|
49 | + private function createUserTables() |
|
50 | + { |
|
51 | + $this->createTable('users', array( |
|
52 | + 'id' => 'pk', |
|
53 | + 'email' => 'string NOT NULL', |
|
54 | + 'password' => 'string NOT NULL', |
|
55 | + 'username' => 'string NOT NULL', |
|
56 | + 'user_role' => 'integer DEFAULT 1', |
|
57 | + 'status' => 'integer DEFAULT 1', |
|
58 | + 'created' => 'integer', |
|
59 | + 'updated' => 'integer' |
|
60 | + )); |
|
61 | + |
|
62 | + $this->createTable('user_roles', array( |
|
63 | + 'id' => 'pk', |
|
64 | + 'name' => 'string NOT NULL', |
|
65 | + 'created' => 'integer', |
|
66 | + 'updated' => 'integer' |
|
67 | + )); |
|
68 | + |
|
69 | + $this->createTable('user_metadata', array( |
|
70 | + 'user_id' => 'integer', |
|
71 | + 'key' => 'string NOT NULL', |
|
72 | + 'value' => 'text NOT NULL', |
|
73 | + 'entity_type' => 'integer', |
|
74 | + 'created' => 'integer', |
|
75 | + 'updated' => 'integer' |
|
76 | + )); |
|
77 | + |
|
78 | + // Create the necessary indexes on the columns |
|
79 | + $this->createIndex('user_email', 'users', 'email', true); |
|
80 | + $this->createIndex('user_username', 'users', 'username', true); |
|
81 | + $this->createIndex('user_metadata', 'user_metadata', 'user_id, key', false); |
|
82 | + |
|
83 | + $this->addPrimaryKey('user_metadata_composite', 'user_metadata', 'user_id,key'); |
|
84 | + |
|
85 | + // Setup the foreign key constraints |
|
86 | + $this->addForeignKey('user_roles_relation_fk', 'user_metadata', 'user_id', 'users', 'id', 'CASCADE', 'NO ACTION'); |
|
87 | + |
|
88 | + // Insert data into the tables |
|
89 | + $this->insert('user_roles', array( |
|
90 | + 'id' => 1, |
|
91 | + 'name' => 'User', |
|
92 | + 'created' => $this->_moment, |
|
93 | + 'updated' => $this->_moment |
|
94 | + )); |
|
95 | + |
|
96 | + $this->insert('user_roles', array( |
|
97 | + 'id' => 2, |
|
98 | + 'name' => 'Pending', |
|
99 | + 'created' => $this->_moment, |
|
100 | + 'updated' => $this->_moment |
|
101 | + )); |
|
102 | + |
|
103 | + $this->insert('user_roles', array( |
|
104 | + 'id' => 3, |
|
105 | + 'name' => 'Suspended', |
|
106 | + 'created' => $this->_moment, |
|
107 | + 'updated' => $this->_moment |
|
108 | + )); |
|
109 | + |
|
110 | + $this->insert('user_roles', array( |
|
111 | + 'id' => 5, |
|
112 | + 'name' => 'Collaborator', |
|
113 | + 'created' => $this->_moment, |
|
114 | + 'updated' => $this->_moment |
|
115 | + )); |
|
116 | + |
|
117 | + $this->insert('user_roles', array( |
|
118 | + 'id' => 6, |
|
119 | + 'name' => 'Author', |
|
120 | + 'created' => $this->_moment, |
|
121 | + 'updated' => $this->_moment |
|
122 | + )); |
|
123 | + |
|
124 | + $this->insert('user_roles', array( |
|
125 | + 'id' => 7, |
|
126 | + 'name' => 'User', |
|
127 | + 'created' => $this->_moment, |
|
128 | + 'updated' => $this->_moment |
|
129 | + )); |
|
130 | + |
|
131 | + $this->insert('user_roles', array( |
|
132 | + 'id' => 8, |
|
133 | + 'name' => 'Publisher', |
|
134 | + 'created' => $this->_moment, |
|
135 | + 'updated' => $this->_moment |
|
136 | + )); |
|
137 | + |
|
138 | + $this->insert('user_roles', array( |
|
139 | + 'id' => 9, |
|
140 | + 'name' => 'Administrator', |
|
141 | + 'created' => $this->_moment, |
|
142 | + 'updated' => $this->_moment |
|
143 | + )); |
|
144 | + } |
|
145 | + |
|
146 | + /** |
|
147 | + * Create the categories and relations |
|
148 | + */ |
|
149 | + private function createCategories() |
|
150 | + { |
|
151 | + // Categories |
|
152 | + $this->createTable('categories', array( |
|
153 | + 'id' => 'pk', |
|
154 | + 'parent_id' => 'integer DEFAULT 1', |
|
155 | + 'name' => 'string NOT NULL', |
|
156 | + 'slug' => 'string NOT NULL', |
|
157 | + 'created' => 'integer', |
|
158 | + 'updated' => 'integer' |
|
159 | + )); |
|
160 | + |
|
161 | + $this->createTable('categories_metadata', array( |
|
162 | + 'category_id' => 'integer', |
|
163 | + 'key' => 'string NOT NULL', |
|
164 | + 'value' => 'text NOT NULL', |
|
165 | + 'created' => 'integer', |
|
166 | + 'updated' => 'integer' |
|
167 | + )); |
|
168 | + |
|
169 | + // Insert the first record into the categories table |
|
170 | + $this->insert('categories', array( |
|
171 | + 'id' => 1, |
|
172 | + 'name' => 'Uncategorized', |
|
173 | + 'slug' => 'uncategorized', |
|
174 | + 'created' => $this->_moment, |
|
175 | + 'updated' => $this->_moment |
|
176 | + )); |
|
177 | + |
|
178 | + $this->addPrimaryKey('categories_metadata_composite', 'categories_metadata', 'category_id,key'); |
|
179 | + $this->addForeignKey('categories_parents_fk', 'categories', 'parent_id', 'categories', 'id', 'CASCADE', 'NO ACTION'); |
|
180 | + $this->addForeignKey('categories_metadata_fk', 'categories_metadata', 'category_id', 'categories', 'id', 'CASCADE', 'NO ACTION'); |
|
181 | + } |
|
182 | + |
|
183 | + /** |
|
184 | + * Creates the content, comemnts, and necessary relations |
|
185 | + */ |
|
186 | + private function createContent() |
|
187 | + { |
|
188 | + $this->createTable('content', array( |
|
189 | + 'id' => 'integer NOT NULL', |
|
190 | + 'vid' => 'integer NOT NULL DEFAULT 1', |
|
191 | + 'title' => 'string NOT NULL', |
|
192 | + 'content' => 'text NOT NULL', |
|
193 | + 'excerpt' => 'text NOT NULL', |
|
194 | + 'slug' => 'string NOT NULL', |
|
195 | + 'category_id' => 'integer DEFAULT 1', |
|
196 | + 'author_id' => 'integer DEFAULT 1', |
|
197 | + 'type_id' => 'integer DEFAULT 2', |
|
198 | + 'commentable' => 'integer DEFAULT 1', |
|
199 | + 'password' => 'string DEFAULT NULL', |
|
200 | + 'status' => 'integer DEFAULT 0', |
|
201 | + 'like_count' => 'integer DEFAULT 0', |
|
202 | + 'published' => 'integer', |
|
203 | + 'created' => 'integer', |
|
204 | + 'updated' => 'integer' |
|
205 | + )); |
|
206 | + |
|
207 | + $this->createTable('content_types', array( |
|
208 | + 'id' => 'pk', |
|
209 | + 'name' => 'string NOT NULL', |
|
210 | + 'created' => 'integer', |
|
211 | + 'updated' => 'integer' |
|
212 | + )); |
|
213 | + |
|
214 | + $this->createTable('content_metadata', array( |
|
215 | + 'content_id' => 'integer', |
|
216 | + 'key' => 'string NOT NULL', |
|
217 | + 'value' => 'text NOT NULL', |
|
218 | + 'created' => 'integer', |
|
219 | + 'updated' => 'integer' |
|
220 | + )); |
|
221 | + |
|
222 | + $this->createTable('comments', array( |
|
223 | + 'id' => 'pk', |
|
224 | + 'content_id' => 'integer', |
|
225 | + 'author_id' => 'integer', |
|
226 | + 'comment' => 'integer', |
|
227 | + 'created' => 'integer', |
|
228 | + 'updated' => 'integer' |
|
229 | + )); |
|
230 | + |
|
231 | + $this->insert('content_types', array( |
|
232 | + 'id' => 1, |
|
233 | + 'name' => 'Static Page', |
|
234 | + 'created' => $this->_moment, |
|
235 | + 'updated' => $this->_moment |
|
236 | + )); |
|
237 | + |
|
238 | + $this->insert('content_types', array( |
|
239 | + 'id' => 2, |
|
240 | + 'name' => 'Blog Post', |
|
241 | + 'created' => $this->_moment, |
|
242 | + 'updated' => $this->_moment |
|
243 | + )); |
|
244 | + |
|
245 | + $this->addPrimaryKey('content_composite', 'content', 'id, vid'); |
|
246 | + |
|
247 | + $this->execute('ALTER TABLE `content` CHANGE id id INT( 11 ) NOT NULL AUTO_INCREMENT'); |
|
248 | + |
|
249 | + $this->addPrimaryKey('content_metadata_composite', 'content_metadata', 'content_id,key'); |
|
250 | + |
|
251 | + $this->createIndex('content_author', 'content', 'author_id', false); |
|
252 | + $this->createIndex('content_category', 'content', 'category_id', false); |
|
253 | + $this->createIndex('content_type', 'content', 'type_id', false); |
|
254 | + $this->createIndex('comment_content', 'comments', 'content_id', false); |
|
255 | + $this->createIndex('comment_author', 'comments', 'author_id', false); |
|
256 | + |
|
257 | + $this->addForeignKey('content_category_fk', 'content', 'category_id', 'categories', 'id', 'CASCADE', 'NO ACTION'); |
|
258 | + $this->addForeignKey('content_author_fk', 'content', 'author_id', 'users', 'id', 'CASCADE', 'NO ACTION'); |
|
259 | + $this->addForeignKey('content_type_fk', 'content', 'type_id', 'content_types', 'id', 'CASCADE', 'NO ACTION'); |
|
260 | + |
|
261 | + $this->addForeignKey('comments_content_id_fk', 'comments', 'content_id', 'content', 'id', 'CASCADE', 'NO ACTION'); |
|
262 | + $this->addForeignKey('comments_author_fk', 'comments', 'author_id', 'users', 'id', 'CASCADE', 'NO ACTION'); |
|
263 | + } |
|
264 | + |
|
265 | + /** |
|
266 | + * Creates the configuration and events tables |
|
267 | + */ |
|
268 | + private function createConfiguration() |
|
269 | + { |
|
270 | + $this->createTable('configuration', array( |
|
271 | + 'key' => 'string', |
|
272 | + 'value' => 'text NOT NULL', |
|
273 | + 'created' => 'integer', |
|
274 | + 'updated' => 'integer' |
|
275 | + )); |
|
276 | + |
|
277 | + $this->createTable('events', array( |
|
278 | + 'id' => 'pk', |
|
279 | + 'event' => 'string NOT NULL', |
|
280 | + 'event_data' => 'text DEFAULT NULL', |
|
281 | + 'uri' => 'string DEFAULT NULL', |
|
282 | + 'content_id' => 'integer DEFAULT NULL', |
|
283 | + 'created' => 'integer' |
|
284 | + )); |
|
285 | + |
|
286 | + $this->addPrimaryKey('configuration_pk', 'configuration', 'key'); |
|
287 | + } |
|
288 | 288 | } |
289 | 289 | \ No newline at end of file |
@@ -9,16 +9,16 @@ discard block |
||
9 | 9 | */ |
10 | 10 | private $_moment = 0; |
11 | 11 | |
12 | - public function safeUp() |
|
12 | + public function safeUp () |
|
13 | 13 | { |
14 | - $this->_moment = time(); |
|
14 | + $this->_moment = time (); |
|
15 | 15 | |
16 | 16 | // Try to get the table names, if we get something back, do not run this migration |
17 | 17 | try |
18 | 18 | { |
19 | - $test = Yii::app()->db->schema->getTables(); |
|
20 | - if (count($test) <= 1) |
|
21 | - throw new Exception('CiiMS doesn\'t exist. Applying base migration'); |
|
19 | + $test = Yii::app ()->db->schema->getTables (); |
|
20 | + if (count ($test) <= 1) |
|
21 | + throw new Exception ('CiiMS doesn\'t exist. Applying base migration'); |
|
22 | 22 | return true; |
23 | 23 | } |
24 | 24 | catch (Exception $e) |
@@ -28,16 +28,16 @@ discard block |
||
28 | 28 | } |
29 | 29 | |
30 | 30 | // Otherwise, run the install migration |
31 | - $this->createUserTables(); |
|
31 | + $this->createUserTables (); |
|
32 | 32 | |
33 | - $this->createCategories(); |
|
33 | + $this->createCategories (); |
|
34 | 34 | |
35 | - $this->createContent(); |
|
35 | + $this->createContent (); |
|
36 | 36 | |
37 | - $this->createConfiguration(); |
|
37 | + $this->createConfiguration (); |
|
38 | 38 | } |
39 | 39 | |
40 | - public function safeDown() |
|
40 | + public function safeDown () |
|
41 | 41 | { |
42 | 42 | echo "m141001_145619_init does not support migration down.\n"; |
43 | 43 | return false; |
@@ -46,9 +46,9 @@ discard block |
||
46 | 46 | /** |
47 | 47 | * Creates the tables, indexes, and relations for users |
48 | 48 | */ |
49 | - private function createUserTables() |
|
49 | + private function createUserTables () |
|
50 | 50 | { |
51 | - $this->createTable('users', array( |
|
51 | + $this->createTable ('users', array( |
|
52 | 52 | 'id' => 'pk', |
53 | 53 | 'email' => 'string NOT NULL', |
54 | 54 | 'password' => 'string NOT NULL', |
@@ -59,14 +59,14 @@ discard block |
||
59 | 59 | 'updated' => 'integer' |
60 | 60 | )); |
61 | 61 | |
62 | - $this->createTable('user_roles', array( |
|
62 | + $this->createTable ('user_roles', array( |
|
63 | 63 | 'id' => 'pk', |
64 | 64 | 'name' => 'string NOT NULL', |
65 | 65 | 'created' => 'integer', |
66 | 66 | 'updated' => 'integer' |
67 | 67 | )); |
68 | 68 | |
69 | - $this->createTable('user_metadata', array( |
|
69 | + $this->createTable ('user_metadata', array( |
|
70 | 70 | 'user_id' => 'integer', |
71 | 71 | 'key' => 'string NOT NULL', |
72 | 72 | 'value' => 'text NOT NULL', |
@@ -76,66 +76,66 @@ discard block |
||
76 | 76 | )); |
77 | 77 | |
78 | 78 | // Create the necessary indexes on the columns |
79 | - $this->createIndex('user_email', 'users', 'email', true); |
|
80 | - $this->createIndex('user_username', 'users', 'username', true); |
|
81 | - $this->createIndex('user_metadata', 'user_metadata', 'user_id, key', false); |
|
79 | + $this->createIndex ('user_email', 'users', 'email', true); |
|
80 | + $this->createIndex ('user_username', 'users', 'username', true); |
|
81 | + $this->createIndex ('user_metadata', 'user_metadata', 'user_id, key', false); |
|
82 | 82 | |
83 | - $this->addPrimaryKey('user_metadata_composite', 'user_metadata', 'user_id,key'); |
|
83 | + $this->addPrimaryKey ('user_metadata_composite', 'user_metadata', 'user_id,key'); |
|
84 | 84 | |
85 | 85 | // Setup the foreign key constraints |
86 | - $this->addForeignKey('user_roles_relation_fk', 'user_metadata', 'user_id', 'users', 'id', 'CASCADE', 'NO ACTION'); |
|
86 | + $this->addForeignKey ('user_roles_relation_fk', 'user_metadata', 'user_id', 'users', 'id', 'CASCADE', 'NO ACTION'); |
|
87 | 87 | |
88 | 88 | // Insert data into the tables |
89 | - $this->insert('user_roles', array( |
|
89 | + $this->insert ('user_roles', array( |
|
90 | 90 | 'id' => 1, |
91 | 91 | 'name' => 'User', |
92 | 92 | 'created' => $this->_moment, |
93 | 93 | 'updated' => $this->_moment |
94 | 94 | )); |
95 | 95 | |
96 | - $this->insert('user_roles', array( |
|
96 | + $this->insert ('user_roles', array( |
|
97 | 97 | 'id' => 2, |
98 | 98 | 'name' => 'Pending', |
99 | 99 | 'created' => $this->_moment, |
100 | 100 | 'updated' => $this->_moment |
101 | 101 | )); |
102 | 102 | |
103 | - $this->insert('user_roles', array( |
|
103 | + $this->insert ('user_roles', array( |
|
104 | 104 | 'id' => 3, |
105 | 105 | 'name' => 'Suspended', |
106 | 106 | 'created' => $this->_moment, |
107 | 107 | 'updated' => $this->_moment |
108 | 108 | )); |
109 | 109 | |
110 | - $this->insert('user_roles', array( |
|
110 | + $this->insert ('user_roles', array( |
|
111 | 111 | 'id' => 5, |
112 | 112 | 'name' => 'Collaborator', |
113 | 113 | 'created' => $this->_moment, |
114 | 114 | 'updated' => $this->_moment |
115 | 115 | )); |
116 | 116 | |
117 | - $this->insert('user_roles', array( |
|
117 | + $this->insert ('user_roles', array( |
|
118 | 118 | 'id' => 6, |
119 | 119 | 'name' => 'Author', |
120 | 120 | 'created' => $this->_moment, |
121 | 121 | 'updated' => $this->_moment |
122 | 122 | )); |
123 | 123 | |
124 | - $this->insert('user_roles', array( |
|
124 | + $this->insert ('user_roles', array( |
|
125 | 125 | 'id' => 7, |
126 | 126 | 'name' => 'User', |
127 | 127 | 'created' => $this->_moment, |
128 | 128 | 'updated' => $this->_moment |
129 | 129 | )); |
130 | 130 | |
131 | - $this->insert('user_roles', array( |
|
131 | + $this->insert ('user_roles', array( |
|
132 | 132 | 'id' => 8, |
133 | 133 | 'name' => 'Publisher', |
134 | 134 | 'created' => $this->_moment, |
135 | 135 | 'updated' => $this->_moment |
136 | 136 | )); |
137 | 137 | |
138 | - $this->insert('user_roles', array( |
|
138 | + $this->insert ('user_roles', array( |
|
139 | 139 | 'id' => 9, |
140 | 140 | 'name' => 'Administrator', |
141 | 141 | 'created' => $this->_moment, |
@@ -146,10 +146,10 @@ discard block |
||
146 | 146 | /** |
147 | 147 | * Create the categories and relations |
148 | 148 | */ |
149 | - private function createCategories() |
|
149 | + private function createCategories () |
|
150 | 150 | { |
151 | 151 | // Categories |
152 | - $this->createTable('categories', array( |
|
152 | + $this->createTable ('categories', array( |
|
153 | 153 | 'id' => 'pk', |
154 | 154 | 'parent_id' => 'integer DEFAULT 1', |
155 | 155 | 'name' => 'string NOT NULL', |
@@ -158,7 +158,7 @@ discard block |
||
158 | 158 | 'updated' => 'integer' |
159 | 159 | )); |
160 | 160 | |
161 | - $this->createTable('categories_metadata', array( |
|
161 | + $this->createTable ('categories_metadata', array( |
|
162 | 162 | 'category_id' => 'integer', |
163 | 163 | 'key' => 'string NOT NULL', |
164 | 164 | 'value' => 'text NOT NULL', |
@@ -167,7 +167,7 @@ discard block |
||
167 | 167 | )); |
168 | 168 | |
169 | 169 | // Insert the first record into the categories table |
170 | - $this->insert('categories', array( |
|
170 | + $this->insert ('categories', array( |
|
171 | 171 | 'id' => 1, |
172 | 172 | 'name' => 'Uncategorized', |
173 | 173 | 'slug' => 'uncategorized', |
@@ -175,17 +175,17 @@ discard block |
||
175 | 175 | 'updated' => $this->_moment |
176 | 176 | )); |
177 | 177 | |
178 | - $this->addPrimaryKey('categories_metadata_composite', 'categories_metadata', 'category_id,key'); |
|
179 | - $this->addForeignKey('categories_parents_fk', 'categories', 'parent_id', 'categories', 'id', 'CASCADE', 'NO ACTION'); |
|
180 | - $this->addForeignKey('categories_metadata_fk', 'categories_metadata', 'category_id', 'categories', 'id', 'CASCADE', 'NO ACTION'); |
|
178 | + $this->addPrimaryKey ('categories_metadata_composite', 'categories_metadata', 'category_id,key'); |
|
179 | + $this->addForeignKey ('categories_parents_fk', 'categories', 'parent_id', 'categories', 'id', 'CASCADE', 'NO ACTION'); |
|
180 | + $this->addForeignKey ('categories_metadata_fk', 'categories_metadata', 'category_id', 'categories', 'id', 'CASCADE', 'NO ACTION'); |
|
181 | 181 | } |
182 | 182 | |
183 | 183 | /** |
184 | 184 | * Creates the content, comemnts, and necessary relations |
185 | 185 | */ |
186 | - private function createContent() |
|
186 | + private function createContent () |
|
187 | 187 | { |
188 | - $this->createTable('content', array( |
|
188 | + $this->createTable ('content', array( |
|
189 | 189 | 'id' => 'integer NOT NULL', |
190 | 190 | 'vid' => 'integer NOT NULL DEFAULT 1', |
191 | 191 | 'title' => 'string NOT NULL', |
@@ -204,14 +204,14 @@ discard block |
||
204 | 204 | 'updated' => 'integer' |
205 | 205 | )); |
206 | 206 | |
207 | - $this->createTable('content_types', array( |
|
207 | + $this->createTable ('content_types', array( |
|
208 | 208 | 'id' => 'pk', |
209 | 209 | 'name' => 'string NOT NULL', |
210 | 210 | 'created' => 'integer', |
211 | 211 | 'updated' => 'integer' |
212 | 212 | )); |
213 | 213 | |
214 | - $this->createTable('content_metadata', array( |
|
214 | + $this->createTable ('content_metadata', array( |
|
215 | 215 | 'content_id' => 'integer', |
216 | 216 | 'key' => 'string NOT NULL', |
217 | 217 | 'value' => 'text NOT NULL', |
@@ -219,7 +219,7 @@ discard block |
||
219 | 219 | 'updated' => 'integer' |
220 | 220 | )); |
221 | 221 | |
222 | - $this->createTable('comments', array( |
|
222 | + $this->createTable ('comments', array( |
|
223 | 223 | 'id' => 'pk', |
224 | 224 | 'content_id' => 'integer', |
225 | 225 | 'author_id' => 'integer', |
@@ -228,53 +228,53 @@ discard block |
||
228 | 228 | 'updated' => 'integer' |
229 | 229 | )); |
230 | 230 | |
231 | - $this->insert('content_types', array( |
|
231 | + $this->insert ('content_types', array( |
|
232 | 232 | 'id' => 1, |
233 | 233 | 'name' => 'Static Page', |
234 | 234 | 'created' => $this->_moment, |
235 | 235 | 'updated' => $this->_moment |
236 | 236 | )); |
237 | 237 | |
238 | - $this->insert('content_types', array( |
|
238 | + $this->insert ('content_types', array( |
|
239 | 239 | 'id' => 2, |
240 | 240 | 'name' => 'Blog Post', |
241 | 241 | 'created' => $this->_moment, |
242 | 242 | 'updated' => $this->_moment |
243 | 243 | )); |
244 | 244 | |
245 | - $this->addPrimaryKey('content_composite', 'content', 'id, vid'); |
|
245 | + $this->addPrimaryKey ('content_composite', 'content', 'id, vid'); |
|
246 | 246 | |
247 | - $this->execute('ALTER TABLE `content` CHANGE id id INT( 11 ) NOT NULL AUTO_INCREMENT'); |
|
247 | + $this->execute ('ALTER TABLE `content` CHANGE id id INT( 11 ) NOT NULL AUTO_INCREMENT'); |
|
248 | 248 | |
249 | - $this->addPrimaryKey('content_metadata_composite', 'content_metadata', 'content_id,key'); |
|
249 | + $this->addPrimaryKey ('content_metadata_composite', 'content_metadata', 'content_id,key'); |
|
250 | 250 | |
251 | - $this->createIndex('content_author', 'content', 'author_id', false); |
|
252 | - $this->createIndex('content_category', 'content', 'category_id', false); |
|
253 | - $this->createIndex('content_type', 'content', 'type_id', false); |
|
254 | - $this->createIndex('comment_content', 'comments', 'content_id', false); |
|
255 | - $this->createIndex('comment_author', 'comments', 'author_id', false); |
|
251 | + $this->createIndex ('content_author', 'content', 'author_id', false); |
|
252 | + $this->createIndex ('content_category', 'content', 'category_id', false); |
|
253 | + $this->createIndex ('content_type', 'content', 'type_id', false); |
|
254 | + $this->createIndex ('comment_content', 'comments', 'content_id', false); |
|
255 | + $this->createIndex ('comment_author', 'comments', 'author_id', false); |
|
256 | 256 | |
257 | - $this->addForeignKey('content_category_fk', 'content', 'category_id', 'categories', 'id', 'CASCADE', 'NO ACTION'); |
|
258 | - $this->addForeignKey('content_author_fk', 'content', 'author_id', 'users', 'id', 'CASCADE', 'NO ACTION'); |
|
259 | - $this->addForeignKey('content_type_fk', 'content', 'type_id', 'content_types', 'id', 'CASCADE', 'NO ACTION'); |
|
257 | + $this->addForeignKey ('content_category_fk', 'content', 'category_id', 'categories', 'id', 'CASCADE', 'NO ACTION'); |
|
258 | + $this->addForeignKey ('content_author_fk', 'content', 'author_id', 'users', 'id', 'CASCADE', 'NO ACTION'); |
|
259 | + $this->addForeignKey ('content_type_fk', 'content', 'type_id', 'content_types', 'id', 'CASCADE', 'NO ACTION'); |
|
260 | 260 | |
261 | - $this->addForeignKey('comments_content_id_fk', 'comments', 'content_id', 'content', 'id', 'CASCADE', 'NO ACTION'); |
|
262 | - $this->addForeignKey('comments_author_fk', 'comments', 'author_id', 'users', 'id', 'CASCADE', 'NO ACTION'); |
|
261 | + $this->addForeignKey ('comments_content_id_fk', 'comments', 'content_id', 'content', 'id', 'CASCADE', 'NO ACTION'); |
|
262 | + $this->addForeignKey ('comments_author_fk', 'comments', 'author_id', 'users', 'id', 'CASCADE', 'NO ACTION'); |
|
263 | 263 | } |
264 | 264 | |
265 | 265 | /** |
266 | 266 | * Creates the configuration and events tables |
267 | 267 | */ |
268 | - private function createConfiguration() |
|
268 | + private function createConfiguration () |
|
269 | 269 | { |
270 | - $this->createTable('configuration', array( |
|
270 | + $this->createTable ('configuration', array( |
|
271 | 271 | 'key' => 'string', |
272 | 272 | 'value' => 'text NOT NULL', |
273 | 273 | 'created' => 'integer', |
274 | 274 | 'updated' => 'integer' |
275 | 275 | )); |
276 | 276 | |
277 | - $this->createTable('events', array( |
|
277 | + $this->createTable ('events', array( |
|
278 | 278 | 'id' => 'pk', |
279 | 279 | 'event' => 'string NOT NULL', |
280 | 280 | 'event_data' => 'text DEFAULT NULL', |
@@ -283,6 +283,6 @@ discard block |
||
283 | 283 | 'created' => 'integer' |
284 | 284 | )); |
285 | 285 | |
286 | - $this->addPrimaryKey('configuration_pk', 'configuration', 'key'); |
|
286 | + $this->addPrimaryKey ('configuration_pk', 'configuration', 'key'); |
|
287 | 287 | } |
288 | 288 | } |
289 | 289 | \ No newline at end of file |
@@ -17,11 +17,11 @@ |
||
17 | 17 | try |
18 | 18 | { |
19 | 19 | $test = Yii::app()->db->schema->getTables(); |
20 | - if (count($test) <= 1) |
|
21 | - throw new Exception('CiiMS doesn\'t exist. Applying base migration'); |
|
20 | + if (count($test) <= 1) { |
|
21 | + throw new Exception('CiiMS doesn\'t exist. Applying base migration'); |
|
22 | + } |
|
22 | 23 | return true; |
23 | - } |
|
24 | - catch (Exception $e) |
|
24 | + } catch (Exception $e) |
|
25 | 25 | { |
26 | 26 | // Yii will throw an exception if Yii::app()->db->schema is undefined (which is should be if we're doing this for the first time) |
27 | 27 | // This SHOULD throw an error if we're running this for the first time - it's the only way to check if we have a valid db or not. |
@@ -19,319 +19,319 @@ |
||
19 | 19 | */ |
20 | 20 | class Categories extends CiiModel |
21 | 21 | { |
22 | - public $pageSize = 15; |
|
23 | - |
|
24 | - public $description = NULL; |
|
25 | - |
|
26 | - public $keywords = array(); |
|
27 | - |
|
28 | - /** |
|
29 | - * Returns the static model of the specified AR class. |
|
30 | - * @param string $className active record class name. |
|
31 | - * @return Categories the static model class |
|
32 | - */ |
|
33 | - public static function model($className=__CLASS__) |
|
34 | - { |
|
35 | - return parent::model($className); |
|
36 | - } |
|
37 | - |
|
38 | - /** |
|
39 | - * @return string the associated database table name |
|
40 | - */ |
|
41 | - public function tableName() |
|
42 | - { |
|
43 | - return 'categories'; |
|
44 | - } |
|
45 | - |
|
46 | - /** |
|
47 | - * @return array validation rules for model attributes. |
|
48 | - */ |
|
49 | - public function rules() |
|
50 | - { |
|
51 | - // NOTE: you should only define rules for those attributes that |
|
52 | - // will receive user inputs. |
|
53 | - return array( |
|
54 | - array('parent_id, name', 'required'), |
|
55 | - array('parent_id', 'numerical', 'integerOnly'=>true), |
|
56 | - array('name, slug', 'length', 'max'=>150), |
|
57 | - // The following rule is used by search(). |
|
58 | - // Please remove those attributes that should not be searched. |
|
59 | - array('id, parent_id, name, slug', 'safe', 'on'=>'search'), |
|
60 | - ); |
|
61 | - } |
|
62 | - |
|
63 | - /** |
|
64 | - * @return array relational rules. |
|
65 | - */ |
|
66 | - public function relations() |
|
67 | - { |
|
68 | - // NOTE: you may need to adjust the relation name and the related |
|
69 | - // class name for the relations automatically generated below. |
|
70 | - return array( |
|
71 | - 'parent' => array(self::BELONGS_TO, 'Categories', 'parent_id'), |
|
72 | - 'metadata' => array(self::HAS_MANY, 'CategoriesMetadata', 'category_id'), |
|
73 | - 'content' => array(self::HAS_MANY, 'Content', 'category_id'), |
|
74 | - ); |
|
75 | - } |
|
76 | - |
|
77 | - /** |
|
78 | - * @return array customized attribute labels (name=>label) |
|
79 | - */ |
|
80 | - public function attributeLabels() |
|
81 | - { |
|
82 | - return array( |
|
83 | - 'id' => Yii::t('ciims.models.Categories', 'ID'), |
|
84 | - 'parent_id' => Yii::t('ciims.models.Categories', 'Parent'), |
|
85 | - 'name' => Yii::t('ciims.models.Categories', 'Name'), |
|
86 | - 'slug' => Yii::t('ciims.models.Categories', 'Slug'), |
|
87 | - 'description' => Yii::t('ciims.models.Categories', 'Description'), |
|
88 | - 'created' => Yii::t('ciims.models.Categories', 'Created'), |
|
89 | - 'updated' => Yii::t('ciims.models.Categories', 'Updated'), |
|
90 | - ); |
|
91 | - } |
|
92 | - |
|
93 | - public function getDescription() |
|
94 | - { |
|
95 | - $this->description = CategoriesMetadata::model()->findByAttributes(array('category_id' => $this->id, 'key' => 'description')); |
|
96 | - if ($this->description == null || $this->description == false) |
|
97 | - return NULL; |
|
98 | - |
|
99 | - $this->description = $this->description->value; |
|
100 | - return $this->description; |
|
101 | - } |
|
102 | - |
|
103 | - /** |
|
104 | - * Retrieves a list of models based on the current search/filter conditions. |
|
105 | - * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions. |
|
106 | - */ |
|
107 | - public function search() |
|
108 | - { |
|
109 | - $criteria=new CDbCriteria; |
|
110 | - |
|
111 | - $criteria->compare('id',$this->id); |
|
112 | - $criteria->compare('parent_id',$this->parent_id); |
|
113 | - $criteria->compare('name',$this->name,true); |
|
114 | - $criteria->compare('slug',$this->slug,true); |
|
115 | - $criteria->compare('created',$this->created,true); |
|
116 | - $criteria->compare('updated',$this->updated,true); |
|
117 | - $criteria->order = "id DESC"; |
|
118 | - |
|
119 | - return new CActiveDataProvider($this, array( |
|
120 | - 'criteria' => $criteria, |
|
121 | - 'pagination' => array( |
|
122 | - 'pageSize' => $this->pageSize |
|
123 | - ) |
|
124 | - )); |
|
125 | - } |
|
126 | - |
|
127 | - /** |
|
128 | - * Gets keyword tags for this entry |
|
129 | - * @return array |
|
130 | - */ |
|
131 | - public function getKeywords() |
|
132 | - { |
|
133 | - $tags = CategoriesMetadata::model()->findByAttributes(array('category_id' => $this->id, 'key' => 'keywords')); |
|
134 | - return $tags === NULL ? array() : CJSON::decode($tags->value); |
|
135 | - } |
|
136 | - |
|
137 | - /** |
|
138 | - * Adds a tag to the model |
|
139 | - * @param string $tag The tag to add |
|
140 | - * @return bool If the insert was successful or not |
|
141 | - */ |
|
142 | - public function addKeyword($tag) |
|
143 | - { |
|
144 | - $tags = $this->keywords; |
|
145 | - if (in_array($tag, $tags) || $tag == "") |
|
146 | - return false; |
|
147 | - |
|
148 | - $tags[] = $tag; |
|
149 | - $tags = CJSON::encode($tags); |
|
150 | - $metaTag = CategoriesMetadata::model()->findByAttributes(array('category_id' => $this->id, 'key' => 'keywords')); |
|
151 | - if ($metaTag == false || $metaTag == NULL) |
|
152 | - { |
|
153 | - $metaTag = new CategoriestMetadata; |
|
154 | - $metaTag->content_id = $this->id; |
|
155 | - $metaTag->key = 'keywords'; |
|
156 | - } |
|
157 | - |
|
158 | - $metaTag->value = $tags; |
|
159 | - return $metaTag->save(); |
|
160 | - } |
|
161 | - |
|
162 | - /** |
|
163 | - * Removes a tag from the model |
|
164 | - * @param string $tag The tag to remove |
|
165 | - * @return bool If the removal was successful |
|
166 | - */ |
|
167 | - public function removeKeyword($tag) |
|
168 | - { |
|
169 | - $tags = $this->keywords; |
|
170 | - if (!in_array($tag, $tags) || $tag == "") |
|
171 | - return false; |
|
172 | - |
|
173 | - $key = array_search($tag, $tags); |
|
174 | - unset($tags[$key]); |
|
175 | - $tags = CJSON::encode($tags); |
|
176 | - |
|
177 | - $metaTag = CategoryMetadata::model()->findByAttributes(array('category_id' => $this->id, 'key' => 'keywords')); |
|
178 | - $metaTag->value = $tags; |
|
179 | - return $metaTag->save(); |
|
180 | - } |
|
181 | - |
|
182 | - /** |
|
183 | - * Verifies the slug before validating the model |
|
184 | - */ |
|
185 | - public function beforeValidate() |
|
186 | - { |
|
187 | - $this->slug = $this->verifySlug($this->slug, $this->name); |
|
188 | - |
|
189 | - return parent::beforeValidate(); |
|
190 | - } |
|
191 | - |
|
192 | - /** |
|
193 | - * Flushes URL data from the cache before the model is updated |
|
194 | - */ |
|
195 | - public function afterSave() |
|
196 | - { |
|
197 | - $meta = CategoriesMetadata::model()->findByAttributes(array('category_id' => $this->id, 'key' => 'description')); |
|
198 | - if ($meta == NULL) |
|
199 | - $meta = new CategoriesMetadata; |
|
200 | - |
|
201 | - $meta->category_id = $this->id; |
|
202 | - $meta->key = 'description'; |
|
203 | - $meta->value = $this->description; |
|
204 | - |
|
205 | - $meta->save(); |
|
206 | - |
|
207 | - Yii::app()->cache->delete('CiiMS::Content::list'); |
|
208 | - Yii::app()->cache->delete('CiiMS::Routes'); |
|
209 | - Yii::app()->cache->delete('categories-pid'); |
|
210 | - |
|
211 | - return parent::afterSave(); |
|
212 | - } |
|
213 | - |
|
214 | - /** |
|
215 | - * Automatically corrects parent tree issues that arise when a parent category node |
|
216 | - * is deleted. |
|
217 | - * @return boolean |
|
218 | - */ |
|
219 | - public function beforeDelete() |
|
220 | - { |
|
221 | - // Prevents the main "uncategorized category from being deleted" |
|
222 | - if ($this->id == 1) |
|
223 | - { |
|
224 | - Yii::app()->user->setFlash('error', Yii::t('ciims.models.Categories', 'This category cannot be deleted')); |
|
225 | - return false; |
|
226 | - } |
|
227 | - |
|
228 | - Yii::app()->cache->delete('CiiMS::Content::list'); |
|
229 | - Yii::app()->cache->delete('CiiMS::Routes'); |
|
230 | - Yii::app()->cache->delete('categories-pid'); |
|
231 | - |
|
232 | - $parent = $this->parent_id; |
|
233 | - $id = $this->id; |
|
234 | - |
|
235 | - // Reassign all posts to the parent category |
|
236 | - Yii::app()->db |
|
237 | - ->createCommand('UPDATE content SET category_id = :parent_id WHERE category_id = :id') |
|
238 | - ->bindParam(':parent_id', $parent) |
|
239 | - ->bindParam(':id', $id) |
|
240 | - ->execute(); |
|
241 | - |
|
242 | - // Reassign all child categories to the parent category |
|
243 | - $data = $this->findAllByAttributes(array('parent_id' => $id)); |
|
244 | - |
|
245 | - foreach ($data as $row) |
|
246 | - { |
|
247 | - $id = $row->id; |
|
248 | - Yii::app()->db |
|
249 | - ->createCommand('UPDATE categories SET parent_id = :parent_id WHERE id = :id') |
|
250 | - ->bindParam(':parent_id', $parent) |
|
251 | - ->bindParam(':id', $id) |
|
252 | - ->execute(); |
|
253 | - } |
|
254 | - |
|
255 | - return parent::beforeDelete(); |
|
256 | - } |
|
257 | - |
|
258 | - /** |
|
259 | - * Retrieves the parent categories for a given category_id |
|
260 | - * @param int $id |
|
261 | - * @return array |
|
262 | - */ |
|
263 | - public function getParentCategories($id) |
|
264 | - { |
|
265 | - // Retrieve the data from cache if necessary |
|
266 | - $response = Yii::app()->cache->get('categories-pid'); |
|
267 | - if ($response == NULL) |
|
268 | - { |
|
269 | - $response = Yii::app()->db->createCommand('SELECT id, parent_id, name, slug FROM categories')->queryAll(); |
|
270 | - Yii::app()->cache->set('categories-pid', $response); |
|
271 | - } |
|
272 | - |
|
273 | - return $this->_getParentCategories($response, $id); |
|
274 | - } |
|
275 | - |
|
276 | - /** |
|
277 | - * Recursive callback for retrieving parent categories |
|
278 | - * @param int $id The category we're seeking |
|
279 | - * @param array $stack A stack to hold the entire tree |
|
280 | - * @return array |
|
281 | - */ |
|
282 | - private function _getParentCategories($all_categories, $id, array $stack = array()) |
|
283 | - { |
|
284 | - if ($id == 1) |
|
285 | - return array_reverse($stack); |
|
286 | - |
|
287 | - foreach ($all_categories as $k=>$v) |
|
288 | - { |
|
289 | - if ($v['id'] == $id) |
|
290 | - { |
|
291 | - $stack[$v['name']] = array(str_replace(Yii::app()->baseUrl, NULL, Yii::app()->createUrl($v['slug']))); |
|
292 | - return $this->_getParentCategories($all_categories, $v['parent_id'], $stack); |
|
293 | - } |
|
294 | - } |
|
295 | - } |
|
296 | - |
|
297 | - /** |
|
298 | - * checkSlug - Recursive method to verify that the slug can be used |
|
299 | - * This method is purposfuly declared here to so that Content::findByPk is used instead of CiiModel::findByPk |
|
300 | - * @param string $slug - the slug to be checked |
|
301 | - * @param int $id - the numeric id to be appended to the slug if a conflict exists |
|
302 | - * @return string $slug - the final slug to be used |
|
303 | - */ |
|
304 | - public function checkSlug($slug, $id=NULL) |
|
305 | - { |
|
306 | - $content = false; |
|
307 | - |
|
308 | - // Find the number of items that have the same slug as this one |
|
309 | - $count = $this->countByAttributes(array('slug'=>$slug . $id)); |
|
310 | - |
|
311 | - if ($count == 0) |
|
312 | - { |
|
313 | - $content = true; |
|
314 | - $count = Content::model()->countByAttributes(array('slug'=>$slug . $id)); |
|
315 | - } |
|
316 | - |
|
317 | - // If we found an item that matched, it's possible that it is the current item (or a previous version of it) |
|
318 | - // in which case we don't need to alter the slug |
|
319 | - if ($count >= 1) |
|
320 | - { |
|
321 | - if ($content) |
|
322 | - return $this->checkSlug($slug, ($id === NULL ? 1 : ($id+1))); |
|
323 | - |
|
324 | - // Pull the data that matches |
|
325 | - $data = $this->findByPk($this->id === NULL ? -1 : $this->id); |
|
326 | - |
|
327 | - // Check the pulled data id to the current item |
|
328 | - if ($data !== NULL && $data->id == $this->id) |
|
329 | - return $slug; |
|
330 | - } |
|
331 | - |
|
332 | - if ($count == 0 && !in_array($slug, $this->forbiddenRoutes)) |
|
333 | - return $slug . $id; |
|
334 | - else |
|
335 | - return $this->checkSlug($slug, ($id === NULL ? 1 : ($id+1))); |
|
336 | - } |
|
22 | + public $pageSize = 15; |
|
23 | + |
|
24 | + public $description = NULL; |
|
25 | + |
|
26 | + public $keywords = array(); |
|
27 | + |
|
28 | + /** |
|
29 | + * Returns the static model of the specified AR class. |
|
30 | + * @param string $className active record class name. |
|
31 | + * @return Categories the static model class |
|
32 | + */ |
|
33 | + public static function model($className=__CLASS__) |
|
34 | + { |
|
35 | + return parent::model($className); |
|
36 | + } |
|
37 | + |
|
38 | + /** |
|
39 | + * @return string the associated database table name |
|
40 | + */ |
|
41 | + public function tableName() |
|
42 | + { |
|
43 | + return 'categories'; |
|
44 | + } |
|
45 | + |
|
46 | + /** |
|
47 | + * @return array validation rules for model attributes. |
|
48 | + */ |
|
49 | + public function rules() |
|
50 | + { |
|
51 | + // NOTE: you should only define rules for those attributes that |
|
52 | + // will receive user inputs. |
|
53 | + return array( |
|
54 | + array('parent_id, name', 'required'), |
|
55 | + array('parent_id', 'numerical', 'integerOnly'=>true), |
|
56 | + array('name, slug', 'length', 'max'=>150), |
|
57 | + // The following rule is used by search(). |
|
58 | + // Please remove those attributes that should not be searched. |
|
59 | + array('id, parent_id, name, slug', 'safe', 'on'=>'search'), |
|
60 | + ); |
|
61 | + } |
|
62 | + |
|
63 | + /** |
|
64 | + * @return array relational rules. |
|
65 | + */ |
|
66 | + public function relations() |
|
67 | + { |
|
68 | + // NOTE: you may need to adjust the relation name and the related |
|
69 | + // class name for the relations automatically generated below. |
|
70 | + return array( |
|
71 | + 'parent' => array(self::BELONGS_TO, 'Categories', 'parent_id'), |
|
72 | + 'metadata' => array(self::HAS_MANY, 'CategoriesMetadata', 'category_id'), |
|
73 | + 'content' => array(self::HAS_MANY, 'Content', 'category_id'), |
|
74 | + ); |
|
75 | + } |
|
76 | + |
|
77 | + /** |
|
78 | + * @return array customized attribute labels (name=>label) |
|
79 | + */ |
|
80 | + public function attributeLabels() |
|
81 | + { |
|
82 | + return array( |
|
83 | + 'id' => Yii::t('ciims.models.Categories', 'ID'), |
|
84 | + 'parent_id' => Yii::t('ciims.models.Categories', 'Parent'), |
|
85 | + 'name' => Yii::t('ciims.models.Categories', 'Name'), |
|
86 | + 'slug' => Yii::t('ciims.models.Categories', 'Slug'), |
|
87 | + 'description' => Yii::t('ciims.models.Categories', 'Description'), |
|
88 | + 'created' => Yii::t('ciims.models.Categories', 'Created'), |
|
89 | + 'updated' => Yii::t('ciims.models.Categories', 'Updated'), |
|
90 | + ); |
|
91 | + } |
|
92 | + |
|
93 | + public function getDescription() |
|
94 | + { |
|
95 | + $this->description = CategoriesMetadata::model()->findByAttributes(array('category_id' => $this->id, 'key' => 'description')); |
|
96 | + if ($this->description == null || $this->description == false) |
|
97 | + return NULL; |
|
98 | + |
|
99 | + $this->description = $this->description->value; |
|
100 | + return $this->description; |
|
101 | + } |
|
102 | + |
|
103 | + /** |
|
104 | + * Retrieves a list of models based on the current search/filter conditions. |
|
105 | + * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions. |
|
106 | + */ |
|
107 | + public function search() |
|
108 | + { |
|
109 | + $criteria=new CDbCriteria; |
|
110 | + |
|
111 | + $criteria->compare('id',$this->id); |
|
112 | + $criteria->compare('parent_id',$this->parent_id); |
|
113 | + $criteria->compare('name',$this->name,true); |
|
114 | + $criteria->compare('slug',$this->slug,true); |
|
115 | + $criteria->compare('created',$this->created,true); |
|
116 | + $criteria->compare('updated',$this->updated,true); |
|
117 | + $criteria->order = "id DESC"; |
|
118 | + |
|
119 | + return new CActiveDataProvider($this, array( |
|
120 | + 'criteria' => $criteria, |
|
121 | + 'pagination' => array( |
|
122 | + 'pageSize' => $this->pageSize |
|
123 | + ) |
|
124 | + )); |
|
125 | + } |
|
126 | + |
|
127 | + /** |
|
128 | + * Gets keyword tags for this entry |
|
129 | + * @return array |
|
130 | + */ |
|
131 | + public function getKeywords() |
|
132 | + { |
|
133 | + $tags = CategoriesMetadata::model()->findByAttributes(array('category_id' => $this->id, 'key' => 'keywords')); |
|
134 | + return $tags === NULL ? array() : CJSON::decode($tags->value); |
|
135 | + } |
|
136 | + |
|
137 | + /** |
|
138 | + * Adds a tag to the model |
|
139 | + * @param string $tag The tag to add |
|
140 | + * @return bool If the insert was successful or not |
|
141 | + */ |
|
142 | + public function addKeyword($tag) |
|
143 | + { |
|
144 | + $tags = $this->keywords; |
|
145 | + if (in_array($tag, $tags) || $tag == "") |
|
146 | + return false; |
|
147 | + |
|
148 | + $tags[] = $tag; |
|
149 | + $tags = CJSON::encode($tags); |
|
150 | + $metaTag = CategoriesMetadata::model()->findByAttributes(array('category_id' => $this->id, 'key' => 'keywords')); |
|
151 | + if ($metaTag == false || $metaTag == NULL) |
|
152 | + { |
|
153 | + $metaTag = new CategoriestMetadata; |
|
154 | + $metaTag->content_id = $this->id; |
|
155 | + $metaTag->key = 'keywords'; |
|
156 | + } |
|
157 | + |
|
158 | + $metaTag->value = $tags; |
|
159 | + return $metaTag->save(); |
|
160 | + } |
|
161 | + |
|
162 | + /** |
|
163 | + * Removes a tag from the model |
|
164 | + * @param string $tag The tag to remove |
|
165 | + * @return bool If the removal was successful |
|
166 | + */ |
|
167 | + public function removeKeyword($tag) |
|
168 | + { |
|
169 | + $tags = $this->keywords; |
|
170 | + if (!in_array($tag, $tags) || $tag == "") |
|
171 | + return false; |
|
172 | + |
|
173 | + $key = array_search($tag, $tags); |
|
174 | + unset($tags[$key]); |
|
175 | + $tags = CJSON::encode($tags); |
|
176 | + |
|
177 | + $metaTag = CategoryMetadata::model()->findByAttributes(array('category_id' => $this->id, 'key' => 'keywords')); |
|
178 | + $metaTag->value = $tags; |
|
179 | + return $metaTag->save(); |
|
180 | + } |
|
181 | + |
|
182 | + /** |
|
183 | + * Verifies the slug before validating the model |
|
184 | + */ |
|
185 | + public function beforeValidate() |
|
186 | + { |
|
187 | + $this->slug = $this->verifySlug($this->slug, $this->name); |
|
188 | + |
|
189 | + return parent::beforeValidate(); |
|
190 | + } |
|
191 | + |
|
192 | + /** |
|
193 | + * Flushes URL data from the cache before the model is updated |
|
194 | + */ |
|
195 | + public function afterSave() |
|
196 | + { |
|
197 | + $meta = CategoriesMetadata::model()->findByAttributes(array('category_id' => $this->id, 'key' => 'description')); |
|
198 | + if ($meta == NULL) |
|
199 | + $meta = new CategoriesMetadata; |
|
200 | + |
|
201 | + $meta->category_id = $this->id; |
|
202 | + $meta->key = 'description'; |
|
203 | + $meta->value = $this->description; |
|
204 | + |
|
205 | + $meta->save(); |
|
206 | + |
|
207 | + Yii::app()->cache->delete('CiiMS::Content::list'); |
|
208 | + Yii::app()->cache->delete('CiiMS::Routes'); |
|
209 | + Yii::app()->cache->delete('categories-pid'); |
|
210 | + |
|
211 | + return parent::afterSave(); |
|
212 | + } |
|
213 | + |
|
214 | + /** |
|
215 | + * Automatically corrects parent tree issues that arise when a parent category node |
|
216 | + * is deleted. |
|
217 | + * @return boolean |
|
218 | + */ |
|
219 | + public function beforeDelete() |
|
220 | + { |
|
221 | + // Prevents the main "uncategorized category from being deleted" |
|
222 | + if ($this->id == 1) |
|
223 | + { |
|
224 | + Yii::app()->user->setFlash('error', Yii::t('ciims.models.Categories', 'This category cannot be deleted')); |
|
225 | + return false; |
|
226 | + } |
|
227 | + |
|
228 | + Yii::app()->cache->delete('CiiMS::Content::list'); |
|
229 | + Yii::app()->cache->delete('CiiMS::Routes'); |
|
230 | + Yii::app()->cache->delete('categories-pid'); |
|
231 | + |
|
232 | + $parent = $this->parent_id; |
|
233 | + $id = $this->id; |
|
234 | + |
|
235 | + // Reassign all posts to the parent category |
|
236 | + Yii::app()->db |
|
237 | + ->createCommand('UPDATE content SET category_id = :parent_id WHERE category_id = :id') |
|
238 | + ->bindParam(':parent_id', $parent) |
|
239 | + ->bindParam(':id', $id) |
|
240 | + ->execute(); |
|
241 | + |
|
242 | + // Reassign all child categories to the parent category |
|
243 | + $data = $this->findAllByAttributes(array('parent_id' => $id)); |
|
244 | + |
|
245 | + foreach ($data as $row) |
|
246 | + { |
|
247 | + $id = $row->id; |
|
248 | + Yii::app()->db |
|
249 | + ->createCommand('UPDATE categories SET parent_id = :parent_id WHERE id = :id') |
|
250 | + ->bindParam(':parent_id', $parent) |
|
251 | + ->bindParam(':id', $id) |
|
252 | + ->execute(); |
|
253 | + } |
|
254 | + |
|
255 | + return parent::beforeDelete(); |
|
256 | + } |
|
257 | + |
|
258 | + /** |
|
259 | + * Retrieves the parent categories for a given category_id |
|
260 | + * @param int $id |
|
261 | + * @return array |
|
262 | + */ |
|
263 | + public function getParentCategories($id) |
|
264 | + { |
|
265 | + // Retrieve the data from cache if necessary |
|
266 | + $response = Yii::app()->cache->get('categories-pid'); |
|
267 | + if ($response == NULL) |
|
268 | + { |
|
269 | + $response = Yii::app()->db->createCommand('SELECT id, parent_id, name, slug FROM categories')->queryAll(); |
|
270 | + Yii::app()->cache->set('categories-pid', $response); |
|
271 | + } |
|
272 | + |
|
273 | + return $this->_getParentCategories($response, $id); |
|
274 | + } |
|
275 | + |
|
276 | + /** |
|
277 | + * Recursive callback for retrieving parent categories |
|
278 | + * @param int $id The category we're seeking |
|
279 | + * @param array $stack A stack to hold the entire tree |
|
280 | + * @return array |
|
281 | + */ |
|
282 | + private function _getParentCategories($all_categories, $id, array $stack = array()) |
|
283 | + { |
|
284 | + if ($id == 1) |
|
285 | + return array_reverse($stack); |
|
286 | + |
|
287 | + foreach ($all_categories as $k=>$v) |
|
288 | + { |
|
289 | + if ($v['id'] == $id) |
|
290 | + { |
|
291 | + $stack[$v['name']] = array(str_replace(Yii::app()->baseUrl, NULL, Yii::app()->createUrl($v['slug']))); |
|
292 | + return $this->_getParentCategories($all_categories, $v['parent_id'], $stack); |
|
293 | + } |
|
294 | + } |
|
295 | + } |
|
296 | + |
|
297 | + /** |
|
298 | + * checkSlug - Recursive method to verify that the slug can be used |
|
299 | + * This method is purposfuly declared here to so that Content::findByPk is used instead of CiiModel::findByPk |
|
300 | + * @param string $slug - the slug to be checked |
|
301 | + * @param int $id - the numeric id to be appended to the slug if a conflict exists |
|
302 | + * @return string $slug - the final slug to be used |
|
303 | + */ |
|
304 | + public function checkSlug($slug, $id=NULL) |
|
305 | + { |
|
306 | + $content = false; |
|
307 | + |
|
308 | + // Find the number of items that have the same slug as this one |
|
309 | + $count = $this->countByAttributes(array('slug'=>$slug . $id)); |
|
310 | + |
|
311 | + if ($count == 0) |
|
312 | + { |
|
313 | + $content = true; |
|
314 | + $count = Content::model()->countByAttributes(array('slug'=>$slug . $id)); |
|
315 | + } |
|
316 | + |
|
317 | + // If we found an item that matched, it's possible that it is the current item (or a previous version of it) |
|
318 | + // in which case we don't need to alter the slug |
|
319 | + if ($count >= 1) |
|
320 | + { |
|
321 | + if ($content) |
|
322 | + return $this->checkSlug($slug, ($id === NULL ? 1 : ($id+1))); |
|
323 | + |
|
324 | + // Pull the data that matches |
|
325 | + $data = $this->findByPk($this->id === NULL ? -1 : $this->id); |
|
326 | + |
|
327 | + // Check the pulled data id to the current item |
|
328 | + if ($data !== NULL && $data->id == $this->id) |
|
329 | + return $slug; |
|
330 | + } |
|
331 | + |
|
332 | + if ($count == 0 && !in_array($slug, $this->forbiddenRoutes)) |
|
333 | + return $slug . $id; |
|
334 | + else |
|
335 | + return $this->checkSlug($slug, ($id === NULL ? 1 : ($id+1))); |
|
336 | + } |
|
337 | 337 | } |
@@ -17,8 +17,8 @@ discard block |
||
17 | 17 | * @property CategoriesMetadata[] $categoriesMetadatas |
18 | 18 | * @property Content[] $contents |
19 | 19 | */ |
20 | -class Categories extends CiiModel |
|
21 | -{ |
|
20 | +class Categories extends CiiModel |
|
21 | +{ |
|
22 | 22 | public $pageSize = 15; |
23 | 23 | |
24 | 24 | public $description = NULL; |
@@ -30,24 +30,24 @@ discard block |
||
30 | 30 | * @param string $className active record class name. |
31 | 31 | * @return Categories the static model class |
32 | 32 | */ |
33 | - public static function model($className=__CLASS__) |
|
34 | - { |
|
33 | + public static function model($className=__CLASS__) |
|
34 | + { |
|
35 | 35 | return parent::model($className); |
36 | 36 | } |
37 | 37 | |
38 | 38 | /** |
39 | 39 | * @return string the associated database table name |
40 | 40 | */ |
41 | - public function tableName() |
|
42 | - { |
|
41 | + public function tableName() |
|
42 | + { |
|
43 | 43 | return 'categories'; |
44 | 44 | } |
45 | 45 | |
46 | 46 | /** |
47 | 47 | * @return array validation rules for model attributes. |
48 | 48 | */ |
49 | - public function rules() |
|
50 | - { |
|
49 | + public function rules() |
|
50 | + { |
|
51 | 51 | // NOTE: you should only define rules for those attributes that |
52 | 52 | // will receive user inputs. |
53 | 53 | return array( |
@@ -63,8 +63,8 @@ discard block |
||
63 | 63 | /** |
64 | 64 | * @return array relational rules. |
65 | 65 | */ |
66 | - public function relations() |
|
67 | - { |
|
66 | + public function relations() |
|
67 | + { |
|
68 | 68 | // NOTE: you may need to adjust the relation name and the related |
69 | 69 | // class name for the relations automatically generated below. |
70 | 70 | return array( |
@@ -77,8 +77,8 @@ discard block |
||
77 | 77 | /** |
78 | 78 | * @return array customized attribute labels (name=>label) |
79 | 79 | */ |
80 | - public function attributeLabels() |
|
81 | - { |
|
80 | + public function attributeLabels() |
|
81 | + { |
|
82 | 82 | return array( |
83 | 83 | 'id' => Yii::t('ciims.models.Categories', 'ID'), |
84 | 84 | 'parent_id' => Yii::t('ciims.models.Categories', 'Parent'), |
@@ -90,11 +90,12 @@ discard block |
||
90 | 90 | ); |
91 | 91 | } |
92 | 92 | |
93 | - public function getDescription() |
|
94 | - { |
|
93 | + public function getDescription() |
|
94 | + { |
|
95 | 95 | $this->description = CategoriesMetadata::model()->findByAttributes(array('category_id' => $this->id, 'key' => 'description')); |
96 | - if ($this->description == null || $this->description == false) |
|
97 | - return NULL; |
|
96 | + if ($this->description == null || $this->description == false) { |
|
97 | + return NULL; |
|
98 | + } |
|
98 | 99 | |
99 | 100 | $this->description = $this->description->value; |
100 | 101 | return $this->description; |
@@ -104,8 +105,8 @@ discard block |
||
104 | 105 | * Retrieves a list of models based on the current search/filter conditions. |
105 | 106 | * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions. |
106 | 107 | */ |
107 | - public function search() |
|
108 | - { |
|
108 | + public function search() |
|
109 | + { |
|
109 | 110 | $criteria=new CDbCriteria; |
110 | 111 | |
111 | 112 | $criteria->compare('id',$this->id); |
@@ -128,8 +129,8 @@ discard block |
||
128 | 129 | * Gets keyword tags for this entry |
129 | 130 | * @return array |
130 | 131 | */ |
131 | - public function getKeywords() |
|
132 | - { |
|
132 | + public function getKeywords() |
|
133 | + { |
|
133 | 134 | $tags = CategoriesMetadata::model()->findByAttributes(array('category_id' => $this->id, 'key' => 'keywords')); |
134 | 135 | return $tags === NULL ? array() : CJSON::decode($tags->value); |
135 | 136 | } |
@@ -139,11 +140,12 @@ discard block |
||
139 | 140 | * @param string $tag The tag to add |
140 | 141 | * @return bool If the insert was successful or not |
141 | 142 | */ |
142 | - public function addKeyword($tag) |
|
143 | - { |
|
143 | + public function addKeyword($tag) |
|
144 | + { |
|
144 | 145 | $tags = $this->keywords; |
145 | - if (in_array($tag, $tags) || $tag == "") |
|
146 | - return false; |
|
146 | + if (in_array($tag, $tags) || $tag == "") { |
|
147 | + return false; |
|
148 | + } |
|
147 | 149 | |
148 | 150 | $tags[] = $tag; |
149 | 151 | $tags = CJSON::encode($tags); |
@@ -164,11 +166,12 @@ discard block |
||
164 | 166 | * @param string $tag The tag to remove |
165 | 167 | * @return bool If the removal was successful |
166 | 168 | */ |
167 | - public function removeKeyword($tag) |
|
168 | - { |
|
169 | + public function removeKeyword($tag) |
|
170 | + { |
|
169 | 171 | $tags = $this->keywords; |
170 | - if (!in_array($tag, $tags) || $tag == "") |
|
171 | - return false; |
|
172 | + if (!in_array($tag, $tags) || $tag == "") { |
|
173 | + return false; |
|
174 | + } |
|
172 | 175 | |
173 | 176 | $key = array_search($tag, $tags); |
174 | 177 | unset($tags[$key]); |
@@ -182,8 +185,8 @@ discard block |
||
182 | 185 | /** |
183 | 186 | * Verifies the slug before validating the model |
184 | 187 | */ |
185 | - public function beforeValidate() |
|
186 | - { |
|
188 | + public function beforeValidate() |
|
189 | + { |
|
187 | 190 | $this->slug = $this->verifySlug($this->slug, $this->name); |
188 | 191 | |
189 | 192 | return parent::beforeValidate(); |
@@ -192,11 +195,12 @@ discard block |
||
192 | 195 | /** |
193 | 196 | * Flushes URL data from the cache before the model is updated |
194 | 197 | */ |
195 | - public function afterSave() |
|
196 | - { |
|
198 | + public function afterSave() |
|
199 | + { |
|
197 | 200 | $meta = CategoriesMetadata::model()->findByAttributes(array('category_id' => $this->id, 'key' => 'description')); |
198 | - if ($meta == NULL) |
|
199 | - $meta = new CategoriesMetadata; |
|
201 | + if ($meta == NULL) { |
|
202 | + $meta = new CategoriesMetadata; |
|
203 | + } |
|
200 | 204 | |
201 | 205 | $meta->category_id = $this->id; |
202 | 206 | $meta->key = 'description'; |
@@ -216,8 +220,8 @@ discard block |
||
216 | 220 | * is deleted. |
217 | 221 | * @return boolean |
218 | 222 | */ |
219 | - public function beforeDelete() |
|
220 | - { |
|
223 | + public function beforeDelete() |
|
224 | + { |
|
221 | 225 | // Prevents the main "uncategorized category from being deleted" |
222 | 226 | if ($this->id == 1) |
223 | 227 | { |
@@ -260,8 +264,8 @@ discard block |
||
260 | 264 | * @param int $id |
261 | 265 | * @return array |
262 | 266 | */ |
263 | - public function getParentCategories($id) |
|
264 | - { |
|
267 | + public function getParentCategories($id) |
|
268 | + { |
|
265 | 269 | // Retrieve the data from cache if necessary |
266 | 270 | $response = Yii::app()->cache->get('categories-pid'); |
267 | 271 | if ($response == NULL) |
@@ -279,10 +283,11 @@ discard block |
||
279 | 283 | * @param array $stack A stack to hold the entire tree |
280 | 284 | * @return array |
281 | 285 | */ |
282 | - private function _getParentCategories($all_categories, $id, array $stack = array()) |
|
283 | - { |
|
284 | - if ($id == 1) |
|
285 | - return array_reverse($stack); |
|
286 | + private function _getParentCategories($all_categories, $id, array $stack = array()) |
|
287 | + { |
|
288 | + if ($id == 1) { |
|
289 | + return array_reverse($stack); |
|
290 | + } |
|
286 | 291 | |
287 | 292 | foreach ($all_categories as $k=>$v) |
288 | 293 | { |
@@ -301,8 +306,8 @@ discard block |
||
301 | 306 | * @param int $id - the numeric id to be appended to the slug if a conflict exists |
302 | 307 | * @return string $slug - the final slug to be used |
303 | 308 | */ |
304 | - public function checkSlug($slug, $id=NULL) |
|
305 | - { |
|
309 | + public function checkSlug($slug, $id=NULL) |
|
310 | + { |
|
306 | 311 | $content = false; |
307 | 312 | |
308 | 313 | // Find the number of items that have the same slug as this one |
@@ -318,20 +323,23 @@ discard block |
||
318 | 323 | // in which case we don't need to alter the slug |
319 | 324 | if ($count >= 1) |
320 | 325 | { |
321 | - if ($content) |
|
322 | - return $this->checkSlug($slug, ($id === NULL ? 1 : ($id+1))); |
|
326 | + if ($content) { |
|
327 | + return $this->checkSlug($slug, ($id === NULL ? 1 : ($id+1))); |
|
328 | + } |
|
323 | 329 | |
324 | 330 | // Pull the data that matches |
325 | 331 | $data = $this->findByPk($this->id === NULL ? -1 : $this->id); |
326 | 332 | |
327 | 333 | // Check the pulled data id to the current item |
328 | - if ($data !== NULL && $data->id == $this->id) |
|
329 | - return $slug; |
|
334 | + if ($data !== NULL && $data->id == $this->id) { |
|
335 | + return $slug; |
|
336 | + } |
|
330 | 337 | } |
331 | 338 | |
332 | - if ($count == 0 && !in_array($slug, $this->forbiddenRoutes)) |
|
333 | - return $slug . $id; |
|
334 | - else |
|
335 | - return $this->checkSlug($slug, ($id === NULL ? 1 : ($id+1))); |
|
339 | + if ($count == 0 && !in_array($slug, $this->forbiddenRoutes)) { |
|
340 | + return $slug . $id; |
|
341 | + } else { |
|
342 | + return $this->checkSlug($slug, ($id === NULL ? 1 : ($id+1))); |
|
343 | + } |
|
336 | 344 | } |
337 | 345 | } |
@@ -30,15 +30,15 @@ discard block |
||
30 | 30 | * @param string $className active record class name. |
31 | 31 | * @return Categories the static model class |
32 | 32 | */ |
33 | - public static function model($className=__CLASS__) |
|
33 | + public static function model ($className = __CLASS__) |
|
34 | 34 | { |
35 | - return parent::model($className); |
|
35 | + return parent::model ($className); |
|
36 | 36 | } |
37 | 37 | |
38 | 38 | /** |
39 | 39 | * @return string the associated database table name |
40 | 40 | */ |
41 | - public function tableName() |
|
41 | + public function tableName () |
|
42 | 42 | { |
43 | 43 | return 'categories'; |
44 | 44 | } |
@@ -46,7 +46,7 @@ discard block |
||
46 | 46 | /** |
47 | 47 | * @return array validation rules for model attributes. |
48 | 48 | */ |
49 | - public function rules() |
|
49 | + public function rules () |
|
50 | 50 | { |
51 | 51 | // NOTE: you should only define rules for those attributes that |
52 | 52 | // will receive user inputs. |
@@ -63,7 +63,7 @@ discard block |
||
63 | 63 | /** |
64 | 64 | * @return array relational rules. |
65 | 65 | */ |
66 | - public function relations() |
|
66 | + public function relations () |
|
67 | 67 | { |
68 | 68 | // NOTE: you may need to adjust the relation name and the related |
69 | 69 | // class name for the relations automatically generated below. |
@@ -77,22 +77,22 @@ discard block |
||
77 | 77 | /** |
78 | 78 | * @return array customized attribute labels (name=>label) |
79 | 79 | */ |
80 | - public function attributeLabels() |
|
80 | + public function attributeLabels () |
|
81 | 81 | { |
82 | 82 | return array( |
83 | - 'id' => Yii::t('ciims.models.Categories', 'ID'), |
|
84 | - 'parent_id' => Yii::t('ciims.models.Categories', 'Parent'), |
|
85 | - 'name' => Yii::t('ciims.models.Categories', 'Name'), |
|
86 | - 'slug' => Yii::t('ciims.models.Categories', 'Slug'), |
|
87 | - 'description' => Yii::t('ciims.models.Categories', 'Description'), |
|
88 | - 'created' => Yii::t('ciims.models.Categories', 'Created'), |
|
89 | - 'updated' => Yii::t('ciims.models.Categories', 'Updated'), |
|
83 | + 'id' => Yii::t ('ciims.models.Categories', 'ID'), |
|
84 | + 'parent_id' => Yii::t ('ciims.models.Categories', 'Parent'), |
|
85 | + 'name' => Yii::t ('ciims.models.Categories', 'Name'), |
|
86 | + 'slug' => Yii::t ('ciims.models.Categories', 'Slug'), |
|
87 | + 'description' => Yii::t ('ciims.models.Categories', 'Description'), |
|
88 | + 'created' => Yii::t ('ciims.models.Categories', 'Created'), |
|
89 | + 'updated' => Yii::t ('ciims.models.Categories', 'Updated'), |
|
90 | 90 | ); |
91 | 91 | } |
92 | 92 | |
93 | - public function getDescription() |
|
93 | + public function getDescription () |
|
94 | 94 | { |
95 | - $this->description = CategoriesMetadata::model()->findByAttributes(array('category_id' => $this->id, 'key' => 'description')); |
|
95 | + $this->description = CategoriesMetadata::model ()->findByAttributes (array('category_id' => $this->id, 'key' => 'description')); |
|
96 | 96 | if ($this->description == null || $this->description == false) |
97 | 97 | return NULL; |
98 | 98 | |
@@ -104,19 +104,19 @@ discard block |
||
104 | 104 | * Retrieves a list of models based on the current search/filter conditions. |
105 | 105 | * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions. |
106 | 106 | */ |
107 | - public function search() |
|
107 | + public function search () |
|
108 | 108 | { |
109 | - $criteria=new CDbCriteria; |
|
110 | - |
|
111 | - $criteria->compare('id',$this->id); |
|
112 | - $criteria->compare('parent_id',$this->parent_id); |
|
113 | - $criteria->compare('name',$this->name,true); |
|
114 | - $criteria->compare('slug',$this->slug,true); |
|
115 | - $criteria->compare('created',$this->created,true); |
|
116 | - $criteria->compare('updated',$this->updated,true); |
|
109 | + $criteria = new CDbCriteria; |
|
110 | + |
|
111 | + $criteria->compare ('id', $this->id); |
|
112 | + $criteria->compare ('parent_id', $this->parent_id); |
|
113 | + $criteria->compare ('name', $this->name, true); |
|
114 | + $criteria->compare ('slug', $this->slug, true); |
|
115 | + $criteria->compare ('created', $this->created, true); |
|
116 | + $criteria->compare ('updated', $this->updated, true); |
|
117 | 117 | $criteria->order = "id DESC"; |
118 | 118 | |
119 | - return new CActiveDataProvider($this, array( |
|
119 | + return new CActiveDataProvider ($this, array( |
|
120 | 120 | 'criteria' => $criteria, |
121 | 121 | 'pagination' => array( |
122 | 122 | 'pageSize' => $this->pageSize |
@@ -128,10 +128,10 @@ discard block |
||
128 | 128 | * Gets keyword tags for this entry |
129 | 129 | * @return array |
130 | 130 | */ |
131 | - public function getKeywords() |
|
131 | + public function getKeywords () |
|
132 | 132 | { |
133 | - $tags = CategoriesMetadata::model()->findByAttributes(array('category_id' => $this->id, 'key' => 'keywords')); |
|
134 | - return $tags === NULL ? array() : CJSON::decode($tags->value); |
|
133 | + $tags = CategoriesMetadata::model ()->findByAttributes (array('category_id' => $this->id, 'key' => 'keywords')); |
|
134 | + return $tags === NULL ? array() : CJSON::decode ($tags->value); |
|
135 | 135 | } |
136 | 136 | |
137 | 137 | /** |
@@ -139,15 +139,15 @@ discard block |
||
139 | 139 | * @param string $tag The tag to add |
140 | 140 | * @return bool If the insert was successful or not |
141 | 141 | */ |
142 | - public function addKeyword($tag) |
|
142 | + public function addKeyword ($tag) |
|
143 | 143 | { |
144 | 144 | $tags = $this->keywords; |
145 | - if (in_array($tag, $tags) || $tag == "") |
|
145 | + if (in_array ($tag, $tags) || $tag == "") |
|
146 | 146 | return false; |
147 | 147 | |
148 | 148 | $tags[] = $tag; |
149 | - $tags = CJSON::encode($tags); |
|
150 | - $metaTag = CategoriesMetadata::model()->findByAttributes(array('category_id' => $this->id, 'key' => 'keywords')); |
|
149 | + $tags = CJSON::encode ($tags); |
|
150 | + $metaTag = CategoriesMetadata::model ()->findByAttributes (array('category_id' => $this->id, 'key' => 'keywords')); |
|
151 | 151 | if ($metaTag == false || $metaTag == NULL) |
152 | 152 | { |
153 | 153 | $metaTag = new CategoriestMetadata; |
@@ -156,7 +156,7 @@ discard block |
||
156 | 156 | } |
157 | 157 | |
158 | 158 | $metaTag->value = $tags; |
159 | - return $metaTag->save(); |
|
159 | + return $metaTag->save (); |
|
160 | 160 | } |
161 | 161 | |
162 | 162 | /** |
@@ -164,51 +164,51 @@ discard block |
||
164 | 164 | * @param string $tag The tag to remove |
165 | 165 | * @return bool If the removal was successful |
166 | 166 | */ |
167 | - public function removeKeyword($tag) |
|
167 | + public function removeKeyword ($tag) |
|
168 | 168 | { |
169 | 169 | $tags = $this->keywords; |
170 | - if (!in_array($tag, $tags) || $tag == "") |
|
170 | + if (!in_array ($tag, $tags) || $tag == "") |
|
171 | 171 | return false; |
172 | 172 | |
173 | - $key = array_search($tag, $tags); |
|
173 | + $key = array_search ($tag, $tags); |
|
174 | 174 | unset($tags[$key]); |
175 | - $tags = CJSON::encode($tags); |
|
175 | + $tags = CJSON::encode ($tags); |
|
176 | 176 | |
177 | - $metaTag = CategoryMetadata::model()->findByAttributes(array('category_id' => $this->id, 'key' => 'keywords')); |
|
177 | + $metaTag = CategoryMetadata::model ()->findByAttributes (array('category_id' => $this->id, 'key' => 'keywords')); |
|
178 | 178 | $metaTag->value = $tags; |
179 | - return $metaTag->save(); |
|
179 | + return $metaTag->save (); |
|
180 | 180 | } |
181 | 181 | |
182 | 182 | /** |
183 | 183 | * Verifies the slug before validating the model |
184 | 184 | */ |
185 | - public function beforeValidate() |
|
185 | + public function beforeValidate () |
|
186 | 186 | { |
187 | - $this->slug = $this->verifySlug($this->slug, $this->name); |
|
187 | + $this->slug = $this->verifySlug ($this->slug, $this->name); |
|
188 | 188 | |
189 | - return parent::beforeValidate(); |
|
189 | + return parent::beforeValidate (); |
|
190 | 190 | } |
191 | 191 | |
192 | 192 | /** |
193 | 193 | * Flushes URL data from the cache before the model is updated |
194 | 194 | */ |
195 | - public function afterSave() |
|
195 | + public function afterSave () |
|
196 | 196 | { |
197 | - $meta = CategoriesMetadata::model()->findByAttributes(array('category_id' => $this->id, 'key' => 'description')); |
|
197 | + $meta = CategoriesMetadata::model ()->findByAttributes (array('category_id' => $this->id, 'key' => 'description')); |
|
198 | 198 | if ($meta == NULL) |
199 | 199 | $meta = new CategoriesMetadata; |
200 | 200 | |
201 | 201 | $meta->category_id = $this->id; |
202 | 202 | $meta->key = 'description'; |
203 | - $meta->value = $this->description; |
|
203 | + $meta->value = $this->description; |
|
204 | 204 | |
205 | - $meta->save(); |
|
205 | + $meta->save (); |
|
206 | 206 | |
207 | - Yii::app()->cache->delete('CiiMS::Content::list'); |
|
208 | - Yii::app()->cache->delete('CiiMS::Routes'); |
|
209 | - Yii::app()->cache->delete('categories-pid'); |
|
207 | + Yii::app ()->cache->delete ('CiiMS::Content::list'); |
|
208 | + Yii::app ()->cache->delete ('CiiMS::Routes'); |
|
209 | + Yii::app ()->cache->delete ('categories-pid'); |
|
210 | 210 | |
211 | - return parent::afterSave(); |
|
211 | + return parent::afterSave (); |
|
212 | 212 | } |
213 | 213 | |
214 | 214 | /** |
@@ -216,43 +216,43 @@ discard block |
||
216 | 216 | * is deleted. |
217 | 217 | * @return boolean |
218 | 218 | */ |
219 | - public function beforeDelete() |
|
219 | + public function beforeDelete () |
|
220 | 220 | { |
221 | 221 | // Prevents the main "uncategorized category from being deleted" |
222 | 222 | if ($this->id == 1) |
223 | 223 | { |
224 | - Yii::app()->user->setFlash('error', Yii::t('ciims.models.Categories', 'This category cannot be deleted')); |
|
224 | + Yii::app ()->user->setFlash ('error', Yii::t ('ciims.models.Categories', 'This category cannot be deleted')); |
|
225 | 225 | return false; |
226 | 226 | } |
227 | 227 | |
228 | - Yii::app()->cache->delete('CiiMS::Content::list'); |
|
229 | - Yii::app()->cache->delete('CiiMS::Routes'); |
|
230 | - Yii::app()->cache->delete('categories-pid'); |
|
228 | + Yii::app ()->cache->delete ('CiiMS::Content::list'); |
|
229 | + Yii::app ()->cache->delete ('CiiMS::Routes'); |
|
230 | + Yii::app ()->cache->delete ('categories-pid'); |
|
231 | 231 | |
232 | 232 | $parent = $this->parent_id; |
233 | 233 | $id = $this->id; |
234 | 234 | |
235 | 235 | // Reassign all posts to the parent category |
236 | - Yii::app()->db |
|
237 | - ->createCommand('UPDATE content SET category_id = :parent_id WHERE category_id = :id') |
|
238 | - ->bindParam(':parent_id', $parent) |
|
239 | - ->bindParam(':id', $id) |
|
240 | - ->execute(); |
|
236 | + Yii::app ()->db |
|
237 | + ->createCommand ('UPDATE content SET category_id = :parent_id WHERE category_id = :id') |
|
238 | + ->bindParam (':parent_id', $parent) |
|
239 | + ->bindParam (':id', $id) |
|
240 | + ->execute (); |
|
241 | 241 | |
242 | 242 | // Reassign all child categories to the parent category |
243 | - $data = $this->findAllByAttributes(array('parent_id' => $id)); |
|
243 | + $data = $this->findAllByAttributes (array('parent_id' => $id)); |
|
244 | 244 | |
245 | 245 | foreach ($data as $row) |
246 | 246 | { |
247 | 247 | $id = $row->id; |
248 | - Yii::app()->db |
|
249 | - ->createCommand('UPDATE categories SET parent_id = :parent_id WHERE id = :id') |
|
250 | - ->bindParam(':parent_id', $parent) |
|
251 | - ->bindParam(':id', $id) |
|
252 | - ->execute(); |
|
248 | + Yii::app ()->db |
|
249 | + ->createCommand ('UPDATE categories SET parent_id = :parent_id WHERE id = :id') |
|
250 | + ->bindParam (':parent_id', $parent) |
|
251 | + ->bindParam (':id', $id) |
|
252 | + ->execute (); |
|
253 | 253 | } |
254 | 254 | |
255 | - return parent::beforeDelete(); |
|
255 | + return parent::beforeDelete (); |
|
256 | 256 | } |
257 | 257 | |
258 | 258 | /** |
@@ -260,17 +260,17 @@ discard block |
||
260 | 260 | * @param int $id |
261 | 261 | * @return array |
262 | 262 | */ |
263 | - public function getParentCategories($id) |
|
263 | + public function getParentCategories ($id) |
|
264 | 264 | { |
265 | 265 | // Retrieve the data from cache if necessary |
266 | - $response = Yii::app()->cache->get('categories-pid'); |
|
266 | + $response = Yii::app ()->cache->get ('categories-pid'); |
|
267 | 267 | if ($response == NULL) |
268 | 268 | { |
269 | - $response = Yii::app()->db->createCommand('SELECT id, parent_id, name, slug FROM categories')->queryAll(); |
|
270 | - Yii::app()->cache->set('categories-pid', $response); |
|
269 | + $response = Yii::app ()->db->createCommand ('SELECT id, parent_id, name, slug FROM categories')->queryAll (); |
|
270 | + Yii::app ()->cache->set ('categories-pid', $response); |
|
271 | 271 | } |
272 | 272 | |
273 | - return $this->_getParentCategories($response, $id); |
|
273 | + return $this->_getParentCategories ($response, $id); |
|
274 | 274 | } |
275 | 275 | |
276 | 276 | /** |
@@ -279,17 +279,17 @@ discard block |
||
279 | 279 | * @param array $stack A stack to hold the entire tree |
280 | 280 | * @return array |
281 | 281 | */ |
282 | - private function _getParentCategories($all_categories, $id, array $stack = array()) |
|
282 | + private function _getParentCategories ($all_categories, $id, array $stack = array()) |
|
283 | 283 | { |
284 | 284 | if ($id == 1) |
285 | - return array_reverse($stack); |
|
285 | + return array_reverse ($stack); |
|
286 | 286 | |
287 | 287 | foreach ($all_categories as $k=>$v) |
288 | 288 | { |
289 | 289 | if ($v['id'] == $id) |
290 | 290 | { |
291 | - $stack[$v['name']] = array(str_replace(Yii::app()->baseUrl, NULL, Yii::app()->createUrl($v['slug']))); |
|
292 | - return $this->_getParentCategories($all_categories, $v['parent_id'], $stack); |
|
291 | + $stack[$v['name']] = array(str_replace (Yii::app ()->baseUrl, NULL, Yii::app ()->createUrl ($v['slug']))); |
|
292 | + return $this->_getParentCategories ($all_categories, $v['parent_id'], $stack); |
|
293 | 293 | } |
294 | 294 | } |
295 | 295 | } |
@@ -301,17 +301,17 @@ discard block |
||
301 | 301 | * @param int $id - the numeric id to be appended to the slug if a conflict exists |
302 | 302 | * @return string $slug - the final slug to be used |
303 | 303 | */ |
304 | - public function checkSlug($slug, $id=NULL) |
|
304 | + public function checkSlug ($slug, $id = NULL) |
|
305 | 305 | { |
306 | 306 | $content = false; |
307 | 307 | |
308 | 308 | // Find the number of items that have the same slug as this one |
309 | - $count = $this->countByAttributes(array('slug'=>$slug . $id)); |
|
309 | + $count = $this->countByAttributes (array('slug'=>$slug.$id)); |
|
310 | 310 | |
311 | 311 | if ($count == 0) |
312 | 312 | { |
313 | 313 | $content = true; |
314 | - $count = Content::model()->countByAttributes(array('slug'=>$slug . $id)); |
|
314 | + $count = Content::model ()->countByAttributes (array('slug'=>$slug.$id)); |
|
315 | 315 | } |
316 | 316 | |
317 | 317 | // If we found an item that matched, it's possible that it is the current item (or a previous version of it) |
@@ -319,19 +319,19 @@ discard block |
||
319 | 319 | if ($count >= 1) |
320 | 320 | { |
321 | 321 | if ($content) |
322 | - return $this->checkSlug($slug, ($id === NULL ? 1 : ($id+1))); |
|
322 | + return $this->checkSlug ($slug, ($id === NULL ? 1 : ($id + 1))); |
|
323 | 323 | |
324 | 324 | // Pull the data that matches |
325 | - $data = $this->findByPk($this->id === NULL ? -1 : $this->id); |
|
325 | + $data = $this->findByPk ($this->id === NULL ? -1 : $this->id); |
|
326 | 326 | |
327 | 327 | // Check the pulled data id to the current item |
328 | 328 | if ($data !== NULL && $data->id == $this->id) |
329 | 329 | return $slug; |
330 | 330 | } |
331 | 331 | |
332 | - if ($count == 0 && !in_array($slug, $this->forbiddenRoutes)) |
|
333 | - return $slug . $id; |
|
332 | + if ($count == 0 && !in_array ($slug, $this->forbiddenRoutes)) |
|
333 | + return $slug.$id; |
|
334 | 334 | else |
335 | - return $this->checkSlug($slug, ($id === NULL ? 1 : ($id+1))); |
|
335 | + return $this->checkSlug ($slug, ($id === NULL ? 1 : ($id + 1))); |
|
336 | 336 | } |
337 | 337 | } |
@@ -16,83 +16,83 @@ |
||
16 | 16 | */ |
17 | 17 | class CategoriesMetadata extends CiiModel |
18 | 18 | { |
19 | - /** |
|
20 | - * Returns the static model of the specified AR class. |
|
21 | - * @param string $className active record class name. |
|
22 | - * @return CategoriesMetadata the static model class |
|
23 | - */ |
|
24 | - public static function model($className=__CLASS__) |
|
25 | - { |
|
26 | - return parent::model($className); |
|
27 | - } |
|
19 | + /** |
|
20 | + * Returns the static model of the specified AR class. |
|
21 | + * @param string $className active record class name. |
|
22 | + * @return CategoriesMetadata the static model class |
|
23 | + */ |
|
24 | + public static function model($className=__CLASS__) |
|
25 | + { |
|
26 | + return parent::model($className); |
|
27 | + } |
|
28 | 28 | |
29 | - /** |
|
30 | - * @return string the associated database table name |
|
31 | - */ |
|
32 | - public function tableName() |
|
33 | - { |
|
34 | - return 'categories_metadata'; |
|
35 | - } |
|
29 | + /** |
|
30 | + * @return string the associated database table name |
|
31 | + */ |
|
32 | + public function tableName() |
|
33 | + { |
|
34 | + return 'categories_metadata'; |
|
35 | + } |
|
36 | 36 | |
37 | - /** |
|
38 | - * @return array validation rules for model attributes. |
|
39 | - */ |
|
40 | - public function rules() |
|
41 | - { |
|
42 | - // NOTE: you should only define rules for those attributes that |
|
43 | - // will receive user inputs. |
|
44 | - return array( |
|
45 | - array('category_id, key, value', 'required'), |
|
46 | - array('category_id', 'numerical', 'integerOnly'=>true), |
|
47 | - array('key, value', 'length', 'max'=>50), |
|
48 | - // The following rule is used by search(). |
|
49 | - // Please remove those attributes that should not be searched. |
|
50 | - array('id, category_id, key, value, created, updated', 'safe', 'on'=>'search'), |
|
51 | - ); |
|
52 | - } |
|
37 | + /** |
|
38 | + * @return array validation rules for model attributes. |
|
39 | + */ |
|
40 | + public function rules() |
|
41 | + { |
|
42 | + // NOTE: you should only define rules for those attributes that |
|
43 | + // will receive user inputs. |
|
44 | + return array( |
|
45 | + array('category_id, key, value', 'required'), |
|
46 | + array('category_id', 'numerical', 'integerOnly'=>true), |
|
47 | + array('key, value', 'length', 'max'=>50), |
|
48 | + // The following rule is used by search(). |
|
49 | + // Please remove those attributes that should not be searched. |
|
50 | + array('id, category_id, key, value, created, updated', 'safe', 'on'=>'search'), |
|
51 | + ); |
|
52 | + } |
|
53 | 53 | |
54 | - /** |
|
55 | - * @return array relational rules. |
|
56 | - */ |
|
57 | - public function relations() |
|
58 | - { |
|
59 | - // NOTE: you may need to adjust the relation name and the related |
|
60 | - // class name for the relations automatically generated below. |
|
61 | - return array( |
|
62 | - 'category' => array(self::BELONGS_TO, 'Categories', 'category_id'), |
|
63 | - ); |
|
64 | - } |
|
54 | + /** |
|
55 | + * @return array relational rules. |
|
56 | + */ |
|
57 | + public function relations() |
|
58 | + { |
|
59 | + // NOTE: you may need to adjust the relation name and the related |
|
60 | + // class name for the relations automatically generated below. |
|
61 | + return array( |
|
62 | + 'category' => array(self::BELONGS_TO, 'Categories', 'category_id'), |
|
63 | + ); |
|
64 | + } |
|
65 | 65 | |
66 | - /** |
|
67 | - * @return array customized attribute labels (name=>label) |
|
68 | - */ |
|
69 | - public function attributeLabels() |
|
70 | - { |
|
71 | - return array( |
|
72 | - 'category_id' => Yii::t('ciims.models.CategoriesMetadata', 'Category ID'), |
|
73 | - 'key' => Yii::t('ciims.models.CategoriesMetadata', 'Key'), |
|
74 | - 'value' => Yii::t('ciims.models.CategoriesMetadata', 'Value'), |
|
75 | - 'created' => Yii::t('ciims.models.CategoriesMetadata', 'Created'), |
|
76 | - 'updated' => Yii::t('ciims.models.CategoriesMetadata', 'Updated'), |
|
77 | - ); |
|
78 | - } |
|
66 | + /** |
|
67 | + * @return array customized attribute labels (name=>label) |
|
68 | + */ |
|
69 | + public function attributeLabels() |
|
70 | + { |
|
71 | + return array( |
|
72 | + 'category_id' => Yii::t('ciims.models.CategoriesMetadata', 'Category ID'), |
|
73 | + 'key' => Yii::t('ciims.models.CategoriesMetadata', 'Key'), |
|
74 | + 'value' => Yii::t('ciims.models.CategoriesMetadata', 'Value'), |
|
75 | + 'created' => Yii::t('ciims.models.CategoriesMetadata', 'Created'), |
|
76 | + 'updated' => Yii::t('ciims.models.CategoriesMetadata', 'Updated'), |
|
77 | + ); |
|
78 | + } |
|
79 | 79 | |
80 | - /** |
|
81 | - * Retrieves a list of models based on the current search/filter conditions. |
|
82 | - * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions. |
|
83 | - */ |
|
84 | - public function search() |
|
85 | - { |
|
86 | - $criteria=new CDbCriteria; |
|
80 | + /** |
|
81 | + * Retrieves a list of models based on the current search/filter conditions. |
|
82 | + * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions. |
|
83 | + */ |
|
84 | + public function search() |
|
85 | + { |
|
86 | + $criteria=new CDbCriteria; |
|
87 | 87 | |
88 | - $criteria->compare('category_id',$this->category_id); |
|
89 | - $criteria->compare('t.key',$this->key,true); |
|
90 | - $criteria->compare('value',$this->value,true); |
|
91 | - $criteria->compare('created',$this->created,true); |
|
92 | - $criteria->compare('updated',$this->updated,true); |
|
88 | + $criteria->compare('category_id',$this->category_id); |
|
89 | + $criteria->compare('t.key',$this->key,true); |
|
90 | + $criteria->compare('value',$this->value,true); |
|
91 | + $criteria->compare('created',$this->created,true); |
|
92 | + $criteria->compare('updated',$this->updated,true); |
|
93 | 93 | |
94 | - return new CActiveDataProvider($this, array( |
|
95 | - 'criteria'=>$criteria, |
|
96 | - )); |
|
97 | - } |
|
94 | + return new CActiveDataProvider($this, array( |
|
95 | + 'criteria'=>$criteria, |
|
96 | + )); |
|
97 | + } |
|
98 | 98 | } |
@@ -21,15 +21,15 @@ discard block |
||
21 | 21 | * @param string $className active record class name. |
22 | 22 | * @return CategoriesMetadata the static model class |
23 | 23 | */ |
24 | - public static function model($className=__CLASS__) |
|
24 | + public static function model ($className = __CLASS__) |
|
25 | 25 | { |
26 | - return parent::model($className); |
|
26 | + return parent::model ($className); |
|
27 | 27 | } |
28 | 28 | |
29 | 29 | /** |
30 | 30 | * @return string the associated database table name |
31 | 31 | */ |
32 | - public function tableName() |
|
32 | + public function tableName () |
|
33 | 33 | { |
34 | 34 | return 'categories_metadata'; |
35 | 35 | } |
@@ -37,7 +37,7 @@ discard block |
||
37 | 37 | /** |
38 | 38 | * @return array validation rules for model attributes. |
39 | 39 | */ |
40 | - public function rules() |
|
40 | + public function rules () |
|
41 | 41 | { |
42 | 42 | // NOTE: you should only define rules for those attributes that |
43 | 43 | // will receive user inputs. |
@@ -54,7 +54,7 @@ discard block |
||
54 | 54 | /** |
55 | 55 | * @return array relational rules. |
56 | 56 | */ |
57 | - public function relations() |
|
57 | + public function relations () |
|
58 | 58 | { |
59 | 59 | // NOTE: you may need to adjust the relation name and the related |
60 | 60 | // class name for the relations automatically generated below. |
@@ -66,14 +66,14 @@ discard block |
||
66 | 66 | /** |
67 | 67 | * @return array customized attribute labels (name=>label) |
68 | 68 | */ |
69 | - public function attributeLabels() |
|
69 | + public function attributeLabels () |
|
70 | 70 | { |
71 | 71 | return array( |
72 | - 'category_id' => Yii::t('ciims.models.CategoriesMetadata', 'Category ID'), |
|
73 | - 'key' => Yii::t('ciims.models.CategoriesMetadata', 'Key'), |
|
74 | - 'value' => Yii::t('ciims.models.CategoriesMetadata', 'Value'), |
|
75 | - 'created' => Yii::t('ciims.models.CategoriesMetadata', 'Created'), |
|
76 | - 'updated' => Yii::t('ciims.models.CategoriesMetadata', 'Updated'), |
|
72 | + 'category_id' => Yii::t ('ciims.models.CategoriesMetadata', 'Category ID'), |
|
73 | + 'key' => Yii::t ('ciims.models.CategoriesMetadata', 'Key'), |
|
74 | + 'value' => Yii::t ('ciims.models.CategoriesMetadata', 'Value'), |
|
75 | + 'created' => Yii::t ('ciims.models.CategoriesMetadata', 'Created'), |
|
76 | + 'updated' => Yii::t ('ciims.models.CategoriesMetadata', 'Updated'), |
|
77 | 77 | ); |
78 | 78 | } |
79 | 79 | |
@@ -81,17 +81,17 @@ discard block |
||
81 | 81 | * Retrieves a list of models based on the current search/filter conditions. |
82 | 82 | * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions. |
83 | 83 | */ |
84 | - public function search() |
|
84 | + public function search () |
|
85 | 85 | { |
86 | - $criteria=new CDbCriteria; |
|
86 | + $criteria = new CDbCriteria; |
|
87 | 87 | |
88 | - $criteria->compare('category_id',$this->category_id); |
|
89 | - $criteria->compare('t.key',$this->key,true); |
|
90 | - $criteria->compare('value',$this->value,true); |
|
91 | - $criteria->compare('created',$this->created,true); |
|
92 | - $criteria->compare('updated',$this->updated,true); |
|
88 | + $criteria->compare ('category_id', $this->category_id); |
|
89 | + $criteria->compare ('t.key', $this->key, true); |
|
90 | + $criteria->compare ('value', $this->value, true); |
|
91 | + $criteria->compare ('created', $this->created, true); |
|
92 | + $criteria->compare ('updated', $this->updated, true); |
|
93 | 93 | |
94 | - return new CActiveDataProvider($this, array( |
|
94 | + return new CActiveDataProvider ($this, array( |
|
95 | 95 | 'criteria'=>$criteria, |
96 | 96 | )); |
97 | 97 | } |
@@ -14,31 +14,31 @@ discard block |
||
14 | 14 | * The followings are the available model relations: |
15 | 15 | * @property Categories $category |
16 | 16 | */ |
17 | -class CategoriesMetadata extends CiiModel |
|
18 | -{ |
|
17 | +class CategoriesMetadata extends CiiModel |
|
18 | +{ |
|
19 | 19 | /** |
20 | 20 | * Returns the static model of the specified AR class. |
21 | 21 | * @param string $className active record class name. |
22 | 22 | * @return CategoriesMetadata the static model class |
23 | 23 | */ |
24 | - public static function model($className=__CLASS__) |
|
25 | - { |
|
24 | + public static function model($className=__CLASS__) |
|
25 | + { |
|
26 | 26 | return parent::model($className); |
27 | 27 | } |
28 | 28 | |
29 | 29 | /** |
30 | 30 | * @return string the associated database table name |
31 | 31 | */ |
32 | - public function tableName() |
|
33 | - { |
|
32 | + public function tableName() |
|
33 | + { |
|
34 | 34 | return 'categories_metadata'; |
35 | 35 | } |
36 | 36 | |
37 | 37 | /** |
38 | 38 | * @return array validation rules for model attributes. |
39 | 39 | */ |
40 | - public function rules() |
|
41 | - { |
|
40 | + public function rules() |
|
41 | + { |
|
42 | 42 | // NOTE: you should only define rules for those attributes that |
43 | 43 | // will receive user inputs. |
44 | 44 | return array( |
@@ -54,8 +54,8 @@ discard block |
||
54 | 54 | /** |
55 | 55 | * @return array relational rules. |
56 | 56 | */ |
57 | - public function relations() |
|
58 | - { |
|
57 | + public function relations() |
|
58 | + { |
|
59 | 59 | // NOTE: you may need to adjust the relation name and the related |
60 | 60 | // class name for the relations automatically generated below. |
61 | 61 | return array( |
@@ -66,8 +66,8 @@ discard block |
||
66 | 66 | /** |
67 | 67 | * @return array customized attribute labels (name=>label) |
68 | 68 | */ |
69 | - public function attributeLabels() |
|
70 | - { |
|
69 | + public function attributeLabels() |
|
70 | + { |
|
71 | 71 | return array( |
72 | 72 | 'category_id' => Yii::t('ciims.models.CategoriesMetadata', 'Category ID'), |
73 | 73 | 'key' => Yii::t('ciims.models.CategoriesMetadata', 'Key'), |
@@ -81,8 +81,8 @@ discard block |
||
81 | 81 | * Retrieves a list of models based on the current search/filter conditions. |
82 | 82 | * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions. |
83 | 83 | */ |
84 | - public function search() |
|
85 | - { |
|
84 | + public function search() |
|
85 | + { |
|
86 | 86 | $criteria=new CDbCriteria; |
87 | 87 | |
88 | 88 | $criteria->compare('category_id',$this->category_id); |
@@ -19,155 +19,155 @@ |
||
19 | 19 | */ |
20 | 20 | class Comments extends CiiModel |
21 | 21 | { |
22 | - /** |
|
23 | - * API Attribute for retrieving the counts |
|
24 | - * @var int |
|
25 | - */ |
|
26 | - public $count = 0; |
|
27 | - |
|
28 | - /** |
|
29 | - * AfterSave IsNewRecord |
|
30 | - * @var boolean |
|
31 | - */ |
|
32 | - private $_isNewRecord = false; |
|
33 | - |
|
34 | - /** |
|
35 | - * Returns the static model of the specified AR class. |
|
36 | - * @param string $className active record class name. |
|
37 | - * @return Comments the static model class |
|
38 | - */ |
|
39 | - public static function model($className=__CLASS__) |
|
40 | - { |
|
41 | - return parent::model($className); |
|
42 | - } |
|
43 | - |
|
44 | - /** |
|
45 | - * @return string the associated database table name |
|
46 | - */ |
|
47 | - public function tableName() |
|
48 | - { |
|
49 | - return 'comments'; |
|
50 | - } |
|
51 | - |
|
52 | - /** |
|
53 | - * @return array validation rules for model attributes. |
|
54 | - */ |
|
55 | - public function rules() |
|
56 | - { |
|
57 | - // NOTE: you should only define rules for those attributes that |
|
58 | - // will receive user inputs. |
|
59 | - return array( |
|
60 | - array('content_id, author_id, comment', 'required'), |
|
61 | - array('content_id, author_id', 'numerical', 'integerOnly'=>true), |
|
62 | - // The following rule is used by search(). |
|
63 | - array('id, content_id, author_id, comment, created, updated', 'safe', 'on'=>'search'), |
|
64 | - ); |
|
65 | - } |
|
66 | - |
|
67 | - /** |
|
68 | - * @return array relational rules. |
|
69 | - */ |
|
70 | - public function relations() |
|
71 | - { |
|
72 | - // NOTE: you may need to adjust the relation name and the related |
|
73 | - // class name for the relations automatically generated below. |
|
74 | - return array( |
|
75 | - 'content' => array(self::BELONGS_TO, 'Content', 'content_id'), |
|
76 | - 'author' => array(self::BELONGS_TO, 'Users', 'author_id'), |
|
77 | - ); |
|
78 | - } |
|
79 | - |
|
80 | - /** |
|
81 | - * @return array customized attribute labels (name=>label) |
|
82 | - */ |
|
83 | - public function attributeLabels() |
|
84 | - { |
|
85 | - return array( |
|
86 | - 'id' => Yii::t('ciims.models.Comments', 'ID'), |
|
87 | - 'content_id' => Yii::t('ciims.models.Comments', 'Content'), |
|
88 | - 'author_id' => Yii::t('ciims.models.Comments', 'User'), |
|
89 | - 'comment' => Yii::t('ciims.models.Comments', 'Comment'), |
|
90 | - 'created' => Yii::t('ciims.models.Comments', 'Created'), |
|
91 | - 'updated' => Yii::t('ciims.models.Comments', 'Updated'), |
|
92 | - ); |
|
93 | - } |
|
94 | - |
|
95 | - /** |
|
96 | - * Retrieves a list of models based on the current search/filter conditions. |
|
97 | - * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions. |
|
98 | - */ |
|
99 | - public function search() |
|
100 | - { |
|
101 | - $criteria=new CDbCriteria; |
|
102 | - |
|
103 | - $criteria->compare('id',$this->id); |
|
104 | - $criteria->compare('content_id',$this->content_id); |
|
105 | - $criteria->compare('author_id',$this->author_id); |
|
106 | - $criteria->compare('comment',$this->comment,true); |
|
107 | - $criteria->compare('created',$this->created,true); |
|
108 | - $criteria->compare('updated',$this->updated,true); |
|
109 | - |
|
110 | - return new CActiveDataProvider($this, array( |
|
111 | - 'criteria'=>$criteria, |
|
112 | - )); |
|
113 | - } |
|
114 | - |
|
115 | - /** |
|
116 | - * Returns the API attributes for the model |
|
117 | - * @return array |
|
118 | - */ |
|
119 | - public function getApiAttributes($params = array(), $relations = false) |
|
120 | - { |
|
121 | - $data = parent::getApiAttributes($params, $relations); |
|
122 | - $user = Users::model()->findByPk($this->author_id); |
|
123 | - $attributes = $user->getApiAttributes(); |
|
124 | - $data['user'] = array( |
|
125 | - 'firstName' => $attributes['firstName'], |
|
126 | - 'lastName' => $attributes['lastName'], |
|
127 | - 'username' => $attributes['username'], |
|
128 | - ); |
|
129 | - |
|
130 | - $content = Content::model()->findByPk($data['content_id']); |
|
131 | - $data['content'] = array( |
|
132 | - 'id' => $data['content_id'], |
|
133 | - 'title' => $content->title, |
|
134 | - 'slug' => $content->slug |
|
135 | - ); |
|
136 | - |
|
137 | - // If this user cannot comment without approval |
|
138 | - if ($user->getReputation() < 100) |
|
139 | - $data['banned_comment'] = true; |
|
140 | - |
|
141 | - return $data; |
|
142 | - } |
|
143 | - |
|
144 | - /** |
|
145 | - * Set the created and updated records |
|
146 | - * @see CiiModel::beforeSave(); |
|
147 | - */ |
|
148 | - public function beforeSave() |
|
149 | - { |
|
150 | - if ($this->isNewRecord) |
|
151 | - $this->_isNewRecord = true; |
|
152 | - |
|
153 | - if (Content::model()->findByPk($this->content_id)->commentable) |
|
154 | - return parent::beforeSave(); |
|
155 | - else |
|
156 | - return false; |
|
157 | - } |
|
158 | - |
|
159 | - /** |
|
160 | - * After a new comment is posted, set the reputation += 10 |
|
161 | - * @see parent::afterSave(); |
|
162 | - */ |
|
163 | - public function afterSave() |
|
164 | - { |
|
165 | - if ($this->_isNewRecord) |
|
166 | - { |
|
167 | - $user = Users::model()->findByPk($this->author_id); |
|
168 | - $user->setReputation(10); |
|
169 | - } |
|
170 | - |
|
171 | - return parent::afterSave(); |
|
172 | - } |
|
22 | + /** |
|
23 | + * API Attribute for retrieving the counts |
|
24 | + * @var int |
|
25 | + */ |
|
26 | + public $count = 0; |
|
27 | + |
|
28 | + /** |
|
29 | + * AfterSave IsNewRecord |
|
30 | + * @var boolean |
|
31 | + */ |
|
32 | + private $_isNewRecord = false; |
|
33 | + |
|
34 | + /** |
|
35 | + * Returns the static model of the specified AR class. |
|
36 | + * @param string $className active record class name. |
|
37 | + * @return Comments the static model class |
|
38 | + */ |
|
39 | + public static function model($className=__CLASS__) |
|
40 | + { |
|
41 | + return parent::model($className); |
|
42 | + } |
|
43 | + |
|
44 | + /** |
|
45 | + * @return string the associated database table name |
|
46 | + */ |
|
47 | + public function tableName() |
|
48 | + { |
|
49 | + return 'comments'; |
|
50 | + } |
|
51 | + |
|
52 | + /** |
|
53 | + * @return array validation rules for model attributes. |
|
54 | + */ |
|
55 | + public function rules() |
|
56 | + { |
|
57 | + // NOTE: you should only define rules for those attributes that |
|
58 | + // will receive user inputs. |
|
59 | + return array( |
|
60 | + array('content_id, author_id, comment', 'required'), |
|
61 | + array('content_id, author_id', 'numerical', 'integerOnly'=>true), |
|
62 | + // The following rule is used by search(). |
|
63 | + array('id, content_id, author_id, comment, created, updated', 'safe', 'on'=>'search'), |
|
64 | + ); |
|
65 | + } |
|
66 | + |
|
67 | + /** |
|
68 | + * @return array relational rules. |
|
69 | + */ |
|
70 | + public function relations() |
|
71 | + { |
|
72 | + // NOTE: you may need to adjust the relation name and the related |
|
73 | + // class name for the relations automatically generated below. |
|
74 | + return array( |
|
75 | + 'content' => array(self::BELONGS_TO, 'Content', 'content_id'), |
|
76 | + 'author' => array(self::BELONGS_TO, 'Users', 'author_id'), |
|
77 | + ); |
|
78 | + } |
|
79 | + |
|
80 | + /** |
|
81 | + * @return array customized attribute labels (name=>label) |
|
82 | + */ |
|
83 | + public function attributeLabels() |
|
84 | + { |
|
85 | + return array( |
|
86 | + 'id' => Yii::t('ciims.models.Comments', 'ID'), |
|
87 | + 'content_id' => Yii::t('ciims.models.Comments', 'Content'), |
|
88 | + 'author_id' => Yii::t('ciims.models.Comments', 'User'), |
|
89 | + 'comment' => Yii::t('ciims.models.Comments', 'Comment'), |
|
90 | + 'created' => Yii::t('ciims.models.Comments', 'Created'), |
|
91 | + 'updated' => Yii::t('ciims.models.Comments', 'Updated'), |
|
92 | + ); |
|
93 | + } |
|
94 | + |
|
95 | + /** |
|
96 | + * Retrieves a list of models based on the current search/filter conditions. |
|
97 | + * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions. |
|
98 | + */ |
|
99 | + public function search() |
|
100 | + { |
|
101 | + $criteria=new CDbCriteria; |
|
102 | + |
|
103 | + $criteria->compare('id',$this->id); |
|
104 | + $criteria->compare('content_id',$this->content_id); |
|
105 | + $criteria->compare('author_id',$this->author_id); |
|
106 | + $criteria->compare('comment',$this->comment,true); |
|
107 | + $criteria->compare('created',$this->created,true); |
|
108 | + $criteria->compare('updated',$this->updated,true); |
|
109 | + |
|
110 | + return new CActiveDataProvider($this, array( |
|
111 | + 'criteria'=>$criteria, |
|
112 | + )); |
|
113 | + } |
|
114 | + |
|
115 | + /** |
|
116 | + * Returns the API attributes for the model |
|
117 | + * @return array |
|
118 | + */ |
|
119 | + public function getApiAttributes($params = array(), $relations = false) |
|
120 | + { |
|
121 | + $data = parent::getApiAttributes($params, $relations); |
|
122 | + $user = Users::model()->findByPk($this->author_id); |
|
123 | + $attributes = $user->getApiAttributes(); |
|
124 | + $data['user'] = array( |
|
125 | + 'firstName' => $attributes['firstName'], |
|
126 | + 'lastName' => $attributes['lastName'], |
|
127 | + 'username' => $attributes['username'], |
|
128 | + ); |
|
129 | + |
|
130 | + $content = Content::model()->findByPk($data['content_id']); |
|
131 | + $data['content'] = array( |
|
132 | + 'id' => $data['content_id'], |
|
133 | + 'title' => $content->title, |
|
134 | + 'slug' => $content->slug |
|
135 | + ); |
|
136 | + |
|
137 | + // If this user cannot comment without approval |
|
138 | + if ($user->getReputation() < 100) |
|
139 | + $data['banned_comment'] = true; |
|
140 | + |
|
141 | + return $data; |
|
142 | + } |
|
143 | + |
|
144 | + /** |
|
145 | + * Set the created and updated records |
|
146 | + * @see CiiModel::beforeSave(); |
|
147 | + */ |
|
148 | + public function beforeSave() |
|
149 | + { |
|
150 | + if ($this->isNewRecord) |
|
151 | + $this->_isNewRecord = true; |
|
152 | + |
|
153 | + if (Content::model()->findByPk($this->content_id)->commentable) |
|
154 | + return parent::beforeSave(); |
|
155 | + else |
|
156 | + return false; |
|
157 | + } |
|
158 | + |
|
159 | + /** |
|
160 | + * After a new comment is posted, set the reputation += 10 |
|
161 | + * @see parent::afterSave(); |
|
162 | + */ |
|
163 | + public function afterSave() |
|
164 | + { |
|
165 | + if ($this->_isNewRecord) |
|
166 | + { |
|
167 | + $user = Users::model()->findByPk($this->author_id); |
|
168 | + $user->setReputation(10); |
|
169 | + } |
|
170 | + |
|
171 | + return parent::afterSave(); |
|
172 | + } |
|
173 | 173 | } |
@@ -36,15 +36,15 @@ discard block |
||
36 | 36 | * @param string $className active record class name. |
37 | 37 | * @return Comments the static model class |
38 | 38 | */ |
39 | - public static function model($className=__CLASS__) |
|
39 | + public static function model ($className = __CLASS__) |
|
40 | 40 | { |
41 | - return parent::model($className); |
|
41 | + return parent::model ($className); |
|
42 | 42 | } |
43 | 43 | |
44 | 44 | /** |
45 | 45 | * @return string the associated database table name |
46 | 46 | */ |
47 | - public function tableName() |
|
47 | + public function tableName () |
|
48 | 48 | { |
49 | 49 | return 'comments'; |
50 | 50 | } |
@@ -52,7 +52,7 @@ discard block |
||
52 | 52 | /** |
53 | 53 | * @return array validation rules for model attributes. |
54 | 54 | */ |
55 | - public function rules() |
|
55 | + public function rules () |
|
56 | 56 | { |
57 | 57 | // NOTE: you should only define rules for those attributes that |
58 | 58 | // will receive user inputs. |
@@ -67,7 +67,7 @@ discard block |
||
67 | 67 | /** |
68 | 68 | * @return array relational rules. |
69 | 69 | */ |
70 | - public function relations() |
|
70 | + public function relations () |
|
71 | 71 | { |
72 | 72 | // NOTE: you may need to adjust the relation name and the related |
73 | 73 | // class name for the relations automatically generated below. |
@@ -80,15 +80,15 @@ discard block |
||
80 | 80 | /** |
81 | 81 | * @return array customized attribute labels (name=>label) |
82 | 82 | */ |
83 | - public function attributeLabels() |
|
83 | + public function attributeLabels () |
|
84 | 84 | { |
85 | 85 | return array( |
86 | - 'id' => Yii::t('ciims.models.Comments', 'ID'), |
|
87 | - 'content_id' => Yii::t('ciims.models.Comments', 'Content'), |
|
88 | - 'author_id' => Yii::t('ciims.models.Comments', 'User'), |
|
89 | - 'comment' => Yii::t('ciims.models.Comments', 'Comment'), |
|
90 | - 'created' => Yii::t('ciims.models.Comments', 'Created'), |
|
91 | - 'updated' => Yii::t('ciims.models.Comments', 'Updated'), |
|
86 | + 'id' => Yii::t ('ciims.models.Comments', 'ID'), |
|
87 | + 'content_id' => Yii::t ('ciims.models.Comments', 'Content'), |
|
88 | + 'author_id' => Yii::t ('ciims.models.Comments', 'User'), |
|
89 | + 'comment' => Yii::t ('ciims.models.Comments', 'Comment'), |
|
90 | + 'created' => Yii::t ('ciims.models.Comments', 'Created'), |
|
91 | + 'updated' => Yii::t ('ciims.models.Comments', 'Updated'), |
|
92 | 92 | ); |
93 | 93 | } |
94 | 94 | |
@@ -96,18 +96,18 @@ discard block |
||
96 | 96 | * Retrieves a list of models based on the current search/filter conditions. |
97 | 97 | * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions. |
98 | 98 | */ |
99 | - public function search() |
|
99 | + public function search () |
|
100 | 100 | { |
101 | - $criteria=new CDbCriteria; |
|
101 | + $criteria = new CDbCriteria; |
|
102 | 102 | |
103 | - $criteria->compare('id',$this->id); |
|
104 | - $criteria->compare('content_id',$this->content_id); |
|
105 | - $criteria->compare('author_id',$this->author_id); |
|
106 | - $criteria->compare('comment',$this->comment,true); |
|
107 | - $criteria->compare('created',$this->created,true); |
|
108 | - $criteria->compare('updated',$this->updated,true); |
|
103 | + $criteria->compare ('id', $this->id); |
|
104 | + $criteria->compare ('content_id', $this->content_id); |
|
105 | + $criteria->compare ('author_id', $this->author_id); |
|
106 | + $criteria->compare ('comment', $this->comment, true); |
|
107 | + $criteria->compare ('created', $this->created, true); |
|
108 | + $criteria->compare ('updated', $this->updated, true); |
|
109 | 109 | |
110 | - return new CActiveDataProvider($this, array( |
|
110 | + return new CActiveDataProvider ($this, array( |
|
111 | 111 | 'criteria'=>$criteria, |
112 | 112 | )); |
113 | 113 | } |
@@ -116,18 +116,18 @@ discard block |
||
116 | 116 | * Returns the API attributes for the model |
117 | 117 | * @return array |
118 | 118 | */ |
119 | - public function getApiAttributes($params = array(), $relations = false) |
|
119 | + public function getApiAttributes ($params = array(), $relations = false) |
|
120 | 120 | { |
121 | - $data = parent::getApiAttributes($params, $relations); |
|
122 | - $user = Users::model()->findByPk($this->author_id); |
|
123 | - $attributes = $user->getApiAttributes(); |
|
121 | + $data = parent::getApiAttributes ($params, $relations); |
|
122 | + $user = Users::model ()->findByPk ($this->author_id); |
|
123 | + $attributes = $user->getApiAttributes (); |
|
124 | 124 | $data['user'] = array( |
125 | 125 | 'firstName' => $attributes['firstName'], |
126 | 126 | 'lastName' => $attributes['lastName'], |
127 | 127 | 'username' => $attributes['username'], |
128 | 128 | ); |
129 | 129 | |
130 | - $content = Content::model()->findByPk($data['content_id']); |
|
130 | + $content = Content::model ()->findByPk ($data['content_id']); |
|
131 | 131 | $data['content'] = array( |
132 | 132 | 'id' => $data['content_id'], |
133 | 133 | 'title' => $content->title, |
@@ -135,7 +135,7 @@ discard block |
||
135 | 135 | ); |
136 | 136 | |
137 | 137 | // If this user cannot comment without approval |
138 | - if ($user->getReputation() < 100) |
|
138 | + if ($user->getReputation () < 100) |
|
139 | 139 | $data['banned_comment'] = true; |
140 | 140 | |
141 | 141 | return $data; |
@@ -145,13 +145,13 @@ discard block |
||
145 | 145 | * Set the created and updated records |
146 | 146 | * @see CiiModel::beforeSave(); |
147 | 147 | */ |
148 | - public function beforeSave() |
|
148 | + public function beforeSave () |
|
149 | 149 | { |
150 | 150 | if ($this->isNewRecord) |
151 | 151 | $this->_isNewRecord = true; |
152 | 152 | |
153 | - if (Content::model()->findByPk($this->content_id)->commentable) |
|
154 | - return parent::beforeSave(); |
|
153 | + if (Content::model ()->findByPk ($this->content_id)->commentable) |
|
154 | + return parent::beforeSave (); |
|
155 | 155 | else |
156 | 156 | return false; |
157 | 157 | } |
@@ -160,14 +160,14 @@ discard block |
||
160 | 160 | * After a new comment is posted, set the reputation += 10 |
161 | 161 | * @see parent::afterSave(); |
162 | 162 | */ |
163 | - public function afterSave() |
|
163 | + public function afterSave () |
|
164 | 164 | { |
165 | 165 | if ($this->_isNewRecord) |
166 | 166 | { |
167 | - $user = Users::model()->findByPk($this->author_id); |
|
168 | - $user->setReputation(10); |
|
167 | + $user = Users::model ()->findByPk ($this->author_id); |
|
168 | + $user->setReputation (10); |
|
169 | 169 | } |
170 | 170 | |
171 | - return parent::afterSave(); |
|
171 | + return parent::afterSave (); |
|
172 | 172 | } |
173 | 173 | } |
@@ -17,8 +17,8 @@ discard block |
||
17 | 17 | * @property Content $content |
18 | 18 | * @property Users $user |
19 | 19 | */ |
20 | -class Comments extends CiiModel |
|
21 | -{ |
|
20 | +class Comments extends CiiModel |
|
21 | +{ |
|
22 | 22 | /** |
23 | 23 | * API Attribute for retrieving the counts |
24 | 24 | * @var int |
@@ -36,24 +36,24 @@ discard block |
||
36 | 36 | * @param string $className active record class name. |
37 | 37 | * @return Comments the static model class |
38 | 38 | */ |
39 | - public static function model($className=__CLASS__) |
|
40 | - { |
|
39 | + public static function model($className=__CLASS__) |
|
40 | + { |
|
41 | 41 | return parent::model($className); |
42 | 42 | } |
43 | 43 | |
44 | 44 | /** |
45 | 45 | * @return string the associated database table name |
46 | 46 | */ |
47 | - public function tableName() |
|
48 | - { |
|
47 | + public function tableName() |
|
48 | + { |
|
49 | 49 | return 'comments'; |
50 | 50 | } |
51 | 51 | |
52 | 52 | /** |
53 | 53 | * @return array validation rules for model attributes. |
54 | 54 | */ |
55 | - public function rules() |
|
56 | - { |
|
55 | + public function rules() |
|
56 | + { |
|
57 | 57 | // NOTE: you should only define rules for those attributes that |
58 | 58 | // will receive user inputs. |
59 | 59 | return array( |
@@ -67,8 +67,8 @@ discard block |
||
67 | 67 | /** |
68 | 68 | * @return array relational rules. |
69 | 69 | */ |
70 | - public function relations() |
|
71 | - { |
|
70 | + public function relations() |
|
71 | + { |
|
72 | 72 | // NOTE: you may need to adjust the relation name and the related |
73 | 73 | // class name for the relations automatically generated below. |
74 | 74 | return array( |
@@ -80,8 +80,8 @@ discard block |
||
80 | 80 | /** |
81 | 81 | * @return array customized attribute labels (name=>label) |
82 | 82 | */ |
83 | - public function attributeLabels() |
|
84 | - { |
|
83 | + public function attributeLabels() |
|
84 | + { |
|
85 | 85 | return array( |
86 | 86 | 'id' => Yii::t('ciims.models.Comments', 'ID'), |
87 | 87 | 'content_id' => Yii::t('ciims.models.Comments', 'Content'), |
@@ -96,8 +96,8 @@ discard block |
||
96 | 96 | * Retrieves a list of models based on the current search/filter conditions. |
97 | 97 | * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions. |
98 | 98 | */ |
99 | - public function search() |
|
100 | - { |
|
99 | + public function search() |
|
100 | + { |
|
101 | 101 | $criteria=new CDbCriteria; |
102 | 102 | |
103 | 103 | $criteria->compare('id',$this->id); |
@@ -116,8 +116,8 @@ discard block |
||
116 | 116 | * Returns the API attributes for the model |
117 | 117 | * @return array |
118 | 118 | */ |
119 | - public function getApiAttributes($params = array(), $relations = false) |
|
120 | - { |
|
119 | + public function getApiAttributes($params = array(), $relations = false) |
|
120 | + { |
|
121 | 121 | $data = parent::getApiAttributes($params, $relations); |
122 | 122 | $user = Users::model()->findByPk($this->author_id); |
123 | 123 | $attributes = $user->getApiAttributes(); |
@@ -135,8 +135,9 @@ discard block |
||
135 | 135 | ); |
136 | 136 | |
137 | 137 | // If this user cannot comment without approval |
138 | - if ($user->getReputation() < 100) |
|
139 | - $data['banned_comment'] = true; |
|
138 | + if ($user->getReputation() < 100) { |
|
139 | + $data['banned_comment'] = true; |
|
140 | + } |
|
140 | 141 | |
141 | 142 | return $data; |
142 | 143 | } |
@@ -145,23 +146,25 @@ discard block |
||
145 | 146 | * Set the created and updated records |
146 | 147 | * @see CiiModel::beforeSave(); |
147 | 148 | */ |
148 | - public function beforeSave() |
|
149 | - { |
|
150 | - if ($this->isNewRecord) |
|
151 | - $this->_isNewRecord = true; |
|
152 | - |
|
153 | - if (Content::model()->findByPk($this->content_id)->commentable) |
|
154 | - return parent::beforeSave(); |
|
155 | - else |
|
156 | - return false; |
|
149 | + public function beforeSave() |
|
150 | + { |
|
151 | + if ($this->isNewRecord) { |
|
152 | + $this->_isNewRecord = true; |
|
153 | + } |
|
154 | + |
|
155 | + if (Content::model()->findByPk($this->content_id)->commentable) { |
|
156 | + return parent::beforeSave(); |
|
157 | + } else { |
|
158 | + return false; |
|
159 | + } |
|
157 | 160 | } |
158 | 161 | |
159 | 162 | /** |
160 | 163 | * After a new comment is posted, set the reputation += 10 |
161 | 164 | * @see parent::afterSave(); |
162 | 165 | */ |
163 | - public function afterSave() |
|
164 | - { |
|
166 | + public function afterSave() |
|
167 | + { |
|
165 | 168 | if ($this->_isNewRecord) |
166 | 169 | { |
167 | 170 | $user = Users::model()->findByPk($this->author_id); |