@@ -13,63 +13,63 @@ |
||
13 | 13 | public function up() |
14 | 14 | { |
15 | 15 | /** |
16 | - * Insert the permissions related to this module. |
|
17 | - */ |
|
18 | - DB::table('permissions')->insert( |
|
19 | - [ |
|
20 | - /** |
|
21 | - * Users model permissions. |
|
22 | - */ |
|
23 | - [ |
|
24 | - 'name' => 'save', |
|
25 | - 'model' => 'settings', |
|
26 | - 'created_at' => \DB::raw('NOW()'), |
|
27 | - 'updated_at' => \DB::raw('NOW()') |
|
28 | - ], |
|
29 | - [ |
|
30 | - 'name' => 'find', |
|
31 | - 'model' => 'settings', |
|
32 | - 'created_at' => \DB::raw('NOW()'), |
|
33 | - 'updated_at' => \DB::raw('NOW()') |
|
34 | - ], |
|
35 | - [ |
|
36 | - 'name' => 'search', |
|
37 | - 'model' => 'settings', |
|
38 | - 'created_at' => \DB::raw('NOW()'), |
|
39 | - 'updated_at' => \DB::raw('NOW()') |
|
40 | - ], |
|
41 | - [ |
|
42 | - 'name' => 'list', |
|
43 | - 'model' => 'settings', |
|
44 | - 'created_at' => \DB::raw('NOW()'), |
|
45 | - 'updated_at' => \DB::raw('NOW()') |
|
46 | - ], |
|
47 | - [ |
|
48 | - 'name' => 'findby', |
|
49 | - 'model' => 'settings', |
|
50 | - 'created_at' => \DB::raw('NOW()'), |
|
51 | - 'updated_at' => \DB::raw('NOW()') |
|
52 | - ], |
|
53 | - [ |
|
54 | - 'name' => 'first', |
|
55 | - 'model' => 'settings', |
|
56 | - 'created_at' => \DB::raw('NOW()'), |
|
57 | - 'updated_at' => \DB::raw('NOW()') |
|
58 | - ], |
|
59 | - [ |
|
60 | - 'name' => 'paginate', |
|
61 | - 'model' => 'settings', |
|
62 | - 'created_at' => \DB::raw('NOW()'), |
|
63 | - 'updated_at' => \DB::raw('NOW()') |
|
64 | - ], |
|
65 | - [ |
|
66 | - 'name' => 'paginateby', |
|
67 | - 'model' => 'settings', |
|
68 | - 'created_at' => \DB::raw('NOW()'), |
|
69 | - 'updated_at' => \DB::raw('NOW()') |
|
70 | - ] |
|
71 | - ] |
|
72 | - ); |
|
16 | + * Insert the permissions related to this module. |
|
17 | + */ |
|
18 | + DB::table('permissions')->insert( |
|
19 | + [ |
|
20 | + /** |
|
21 | + * Users model permissions. |
|
22 | + */ |
|
23 | + [ |
|
24 | + 'name' => 'save', |
|
25 | + 'model' => 'settings', |
|
26 | + 'created_at' => \DB::raw('NOW()'), |
|
27 | + 'updated_at' => \DB::raw('NOW()') |
|
28 | + ], |
|
29 | + [ |
|
30 | + 'name' => 'find', |
|
31 | + 'model' => 'settings', |
|
32 | + 'created_at' => \DB::raw('NOW()'), |
|
33 | + 'updated_at' => \DB::raw('NOW()') |
|
34 | + ], |
|
35 | + [ |
|
36 | + 'name' => 'search', |
|
37 | + 'model' => 'settings', |
|
38 | + 'created_at' => \DB::raw('NOW()'), |
|
39 | + 'updated_at' => \DB::raw('NOW()') |
|
40 | + ], |
|
41 | + [ |
|
42 | + 'name' => 'list', |
|
43 | + 'model' => 'settings', |
|
44 | + 'created_at' => \DB::raw('NOW()'), |
|
45 | + 'updated_at' => \DB::raw('NOW()') |
|
46 | + ], |
|
47 | + [ |
|
48 | + 'name' => 'findby', |
|
49 | + 'model' => 'settings', |
|
50 | + 'created_at' => \DB::raw('NOW()'), |
|
51 | + 'updated_at' => \DB::raw('NOW()') |
|
52 | + ], |
|
53 | + [ |
|
54 | + 'name' => 'first', |
|
55 | + 'model' => 'settings', |
|
56 | + 'created_at' => \DB::raw('NOW()'), |
|
57 | + 'updated_at' => \DB::raw('NOW()') |
|
58 | + ], |
|
59 | + [ |
|
60 | + 'name' => 'paginate', |
|
61 | + 'model' => 'settings', |
|
62 | + 'created_at' => \DB::raw('NOW()'), |
|
63 | + 'updated_at' => \DB::raw('NOW()') |
|
64 | + ], |
|
65 | + [ |
|
66 | + 'name' => 'paginateby', |
|
67 | + 'model' => 'settings', |
|
68 | + 'created_at' => \DB::raw('NOW()'), |
|
69 | + 'updated_at' => \DB::raw('NOW()') |
|
70 | + ] |
|
71 | + ] |
|
72 | + ); |
|
73 | 73 | } |
74 | 74 | |
75 | 75 | /** |
@@ -13,63 +13,63 @@ |
||
13 | 13 | public function up() |
14 | 14 | { |
15 | 15 | /** |
16 | - * Insert the permissions related to this module. |
|
17 | - */ |
|
18 | - DB::table('permissions')->insert( |
|
19 | - [ |
|
20 | - /** |
|
21 | - * Reports model permissions. |
|
22 | - */ |
|
23 | - [ |
|
24 | - 'name' => 'find', |
|
25 | - 'model' => 'reports', |
|
26 | - 'created_at' => \DB::raw('NOW()'), |
|
27 | - 'updated_at' => \DB::raw('NOW()') |
|
28 | - ], |
|
29 | - [ |
|
30 | - 'name' => 'search', |
|
31 | - 'model' => 'reports', |
|
32 | - 'created_at' => \DB::raw('NOW()'), |
|
33 | - 'updated_at' => \DB::raw('NOW()') |
|
34 | - ], |
|
35 | - [ |
|
36 | - 'name' => 'list', |
|
37 | - 'model' => 'reports', |
|
38 | - 'created_at' => \DB::raw('NOW()'), |
|
39 | - 'updated_at' => \DB::raw('NOW()') |
|
40 | - ], |
|
41 | - [ |
|
42 | - 'name' => 'findby', |
|
43 | - 'model' => 'reports', |
|
44 | - 'created_at' => \DB::raw('NOW()'), |
|
45 | - 'updated_at' => \DB::raw('NOW()') |
|
46 | - ], |
|
47 | - [ |
|
48 | - 'name' => 'first', |
|
49 | - 'model' => 'reports', |
|
50 | - 'created_at' => \DB::raw('NOW()'), |
|
51 | - 'updated_at' => \DB::raw('NOW()') |
|
52 | - ], |
|
53 | - [ |
|
54 | - 'name' => 'paginate', |
|
55 | - 'model' => 'reports', |
|
56 | - 'created_at' => \DB::raw('NOW()'), |
|
57 | - 'updated_at' => \DB::raw('NOW()') |
|
58 | - ], |
|
59 | - [ |
|
60 | - 'name' => 'paginateby', |
|
61 | - 'model' => 'reports', |
|
62 | - 'created_at' => \DB::raw('NOW()'), |
|
63 | - 'updated_at' => \DB::raw('NOW()') |
|
64 | - ], |
|
65 | - [ |
|
66 | - 'name' => 'admin_count', |
|
67 | - 'model' => 'reports', |
|
68 | - 'created_at' => \DB::raw('NOW()'), |
|
69 | - 'updated_at' => \DB::raw('NOW()') |
|
70 | - ] |
|
71 | - ] |
|
72 | - ); |
|
16 | + * Insert the permissions related to this module. |
|
17 | + */ |
|
18 | + DB::table('permissions')->insert( |
|
19 | + [ |
|
20 | + /** |
|
21 | + * Reports model permissions. |
|
22 | + */ |
|
23 | + [ |
|
24 | + 'name' => 'find', |
|
25 | + 'model' => 'reports', |
|
26 | + 'created_at' => \DB::raw('NOW()'), |
|
27 | + 'updated_at' => \DB::raw('NOW()') |
|
28 | + ], |
|
29 | + [ |
|
30 | + 'name' => 'search', |
|
31 | + 'model' => 'reports', |
|
32 | + 'created_at' => \DB::raw('NOW()'), |
|
33 | + 'updated_at' => \DB::raw('NOW()') |
|
34 | + ], |
|
35 | + [ |
|
36 | + 'name' => 'list', |
|
37 | + 'model' => 'reports', |
|
38 | + 'created_at' => \DB::raw('NOW()'), |
|
39 | + 'updated_at' => \DB::raw('NOW()') |
|
40 | + ], |
|
41 | + [ |
|
42 | + 'name' => 'findby', |
|
43 | + 'model' => 'reports', |
|
44 | + 'created_at' => \DB::raw('NOW()'), |
|
45 | + 'updated_at' => \DB::raw('NOW()') |
|
46 | + ], |
|
47 | + [ |
|
48 | + 'name' => 'first', |
|
49 | + 'model' => 'reports', |
|
50 | + 'created_at' => \DB::raw('NOW()'), |
|
51 | + 'updated_at' => \DB::raw('NOW()') |
|
52 | + ], |
|
53 | + [ |
|
54 | + 'name' => 'paginate', |
|
55 | + 'model' => 'reports', |
|
56 | + 'created_at' => \DB::raw('NOW()'), |
|
57 | + 'updated_at' => \DB::raw('NOW()') |
|
58 | + ], |
|
59 | + [ |
|
60 | + 'name' => 'paginateby', |
|
61 | + 'model' => 'reports', |
|
62 | + 'created_at' => \DB::raw('NOW()'), |
|
63 | + 'updated_at' => \DB::raw('NOW()') |
|
64 | + ], |
|
65 | + [ |
|
66 | + 'name' => 'admin_count', |
|
67 | + 'model' => 'reports', |
|
68 | + 'created_at' => \DB::raw('NOW()'), |
|
69 | + 'updated_at' => \DB::raw('NOW()') |
|
70 | + ] |
|
71 | + ] |
|
72 | + ); |
|
73 | 73 | } |
74 | 74 | |
75 | 75 | /** |
@@ -13,69 +13,69 @@ |
||
13 | 13 | public function up() |
14 | 14 | { |
15 | 15 | /** |
16 | - * Insert the permissions related to this module. |
|
17 | - */ |
|
18 | - DB::table('permissions')->insert( |
|
19 | - [ |
|
20 | - /** |
|
21 | - * Logs model permissions. |
|
22 | - */ |
|
23 | - [ |
|
24 | - 'name' => 'find', |
|
25 | - 'model' => 'notifications', |
|
26 | - 'created_at' => \DB::raw('NOW()'), |
|
27 | - 'updated_at' => \DB::raw('NOW()') |
|
28 | - ], |
|
29 | - [ |
|
30 | - 'name' => 'search', |
|
31 | - 'model' => 'notifications', |
|
32 | - 'created_at' => \DB::raw('NOW()'), |
|
33 | - 'updated_at' => \DB::raw('NOW()') |
|
34 | - ], |
|
35 | - [ |
|
36 | - 'name' => 'list', |
|
37 | - 'model' => 'notifications', |
|
38 | - 'created_at' => \DB::raw('NOW()'), |
|
39 | - 'updated_at' => \DB::raw('NOW()') |
|
40 | - ], |
|
41 | - [ |
|
42 | - 'name' => 'findby', |
|
43 | - 'model' => 'notifications', |
|
44 | - 'created_at' => \DB::raw('NOW()'), |
|
45 | - 'updated_at' => \DB::raw('NOW()') |
|
46 | - ], |
|
47 | - [ |
|
48 | - 'name' => 'first', |
|
49 | - 'model' => 'notifications', |
|
50 | - 'created_at' => \DB::raw('NOW()'), |
|
51 | - 'updated_at' => \DB::raw('NOW()') |
|
52 | - ], |
|
53 | - [ |
|
54 | - 'name' => 'paginate', |
|
55 | - 'model' => 'notifications', |
|
56 | - 'created_at' => \DB::raw('NOW()'), |
|
57 | - 'updated_at' => \DB::raw('NOW()') |
|
58 | - ], |
|
59 | - [ |
|
60 | - 'name' => 'paginateby', |
|
61 | - 'model' => 'notifications', |
|
62 | - 'created_at' => \DB::raw('NOW()'), |
|
63 | - 'updated_at' => \DB::raw('NOW()') |
|
64 | - ], |
|
65 | - [ |
|
66 | - 'name' => 'notified', |
|
67 | - 'model' => 'notifications', |
|
68 | - 'created_at' => \DB::raw('NOW()'), |
|
69 | - 'updated_at' => \DB::raw('NOW()') |
|
70 | - ], |
|
71 | - [ |
|
72 | - 'name' => 'notifyall', |
|
73 | - 'model' => 'notifications', |
|
74 | - 'created_at' => \DB::raw('NOW()'), |
|
75 | - 'updated_at' => \DB::raw('NOW()') |
|
76 | - ], |
|
77 | - ] |
|
78 | - ); |
|
16 | + * Insert the permissions related to this module. |
|
17 | + */ |
|
18 | + DB::table('permissions')->insert( |
|
19 | + [ |
|
20 | + /** |
|
21 | + * Logs model permissions. |
|
22 | + */ |
|
23 | + [ |
|
24 | + 'name' => 'find', |
|
25 | + 'model' => 'notifications', |
|
26 | + 'created_at' => \DB::raw('NOW()'), |
|
27 | + 'updated_at' => \DB::raw('NOW()') |
|
28 | + ], |
|
29 | + [ |
|
30 | + 'name' => 'search', |
|
31 | + 'model' => 'notifications', |
|
32 | + 'created_at' => \DB::raw('NOW()'), |
|
33 | + 'updated_at' => \DB::raw('NOW()') |
|
34 | + ], |
|
35 | + [ |
|
36 | + 'name' => 'list', |
|
37 | + 'model' => 'notifications', |
|
38 | + 'created_at' => \DB::raw('NOW()'), |
|
39 | + 'updated_at' => \DB::raw('NOW()') |
|
40 | + ], |
|
41 | + [ |
|
42 | + 'name' => 'findby', |
|
43 | + 'model' => 'notifications', |
|
44 | + 'created_at' => \DB::raw('NOW()'), |
|
45 | + 'updated_at' => \DB::raw('NOW()') |
|
46 | + ], |
|
47 | + [ |
|
48 | + 'name' => 'first', |
|
49 | + 'model' => 'notifications', |
|
50 | + 'created_at' => \DB::raw('NOW()'), |
|
51 | + 'updated_at' => \DB::raw('NOW()') |
|
52 | + ], |
|
53 | + [ |
|
54 | + 'name' => 'paginate', |
|
55 | + 'model' => 'notifications', |
|
56 | + 'created_at' => \DB::raw('NOW()'), |
|
57 | + 'updated_at' => \DB::raw('NOW()') |
|
58 | + ], |
|
59 | + [ |
|
60 | + 'name' => 'paginateby', |
|
61 | + 'model' => 'notifications', |
|
62 | + 'created_at' => \DB::raw('NOW()'), |
|
63 | + 'updated_at' => \DB::raw('NOW()') |
|
64 | + ], |
|
65 | + [ |
|
66 | + 'name' => 'notified', |
|
67 | + 'model' => 'notifications', |
|
68 | + 'created_at' => \DB::raw('NOW()'), |
|
69 | + 'updated_at' => \DB::raw('NOW()') |
|
70 | + ], |
|
71 | + [ |
|
72 | + 'name' => 'notifyall', |
|
73 | + 'model' => 'notifications', |
|
74 | + 'created_at' => \DB::raw('NOW()'), |
|
75 | + 'updated_at' => \DB::raw('NOW()') |
|
76 | + ], |
|
77 | + ] |
|
78 | + ); |
|
79 | 79 | } |
80 | 80 | |
81 | 81 | /** |
@@ -39,37 +39,37 @@ |
||
39 | 39 | * Create Default users. |
40 | 40 | */ |
41 | 41 | $adminUserId = DB::table('users')->insertGetId( |
42 | - [ |
|
42 | + [ |
|
43 | 43 | 'email' => '[email protected]', |
44 | 44 | 'password' => bcrypt('123456'), |
45 | 45 | 'created_at' => \DB::raw('NOW()'), |
46 | 46 | 'updated_at' => \DB::raw('NOW()') |
47 | 47 | ] |
48 | - ); |
|
48 | + ); |
|
49 | 49 | |
50 | 50 | /** |
51 | 51 | * Assign users to groups. |
52 | 52 | */ |
53 | 53 | $adminGroupId = DB::table('groups')->where('name', 'Admin')->first()->id; |
54 | 54 | DB::table('users_groups')->insert( |
55 | - [ |
|
56 | - [ |
|
55 | + [ |
|
56 | + [ |
|
57 | 57 | 'user_id' => $adminUserId, |
58 | 58 | 'group_id' => $adminGroupId, |
59 | 59 | 'created_at' => \DB::raw('NOW()'), |
60 | 60 | 'updated_at' => \DB::raw('NOW()') |
61 | - ] |
|
62 | - ] |
|
63 | - ); |
|
61 | + ] |
|
62 | + ] |
|
63 | + ); |
|
64 | 64 | |
65 | - /** |
|
65 | + /** |
|
66 | 66 | * Create default settings. |
67 | 67 | */ |
68 | - DB::table('settings')->insert( |
|
69 | - [ |
|
68 | + DB::table('settings')->insert( |
|
69 | + [ |
|
70 | 70 | |
71 | - ] |
|
72 | - ); |
|
71 | + ] |
|
72 | + ); |
|
73 | 73 | } |
74 | 74 | |
75 | 75 | /** |
@@ -50,7 +50,7 @@ |
||
50 | 50 | /** |
51 | 51 | * Assign users to groups. |
52 | 52 | */ |
53 | - $adminGroupId = DB::table('groups')->where('name', 'Admin')->first()->id; |
|
53 | + $adminGroupId = DB::table('groups')->where('name', 'Admin')->first()->id; |
|
54 | 54 | DB::table('users_groups')->insert( |
55 | 55 | [ |
56 | 56 | [ |
@@ -13,57 +13,57 @@ |
||
13 | 13 | public function up() |
14 | 14 | { |
15 | 15 | /** |
16 | - * Insert the permissions related to this module. |
|
17 | - */ |
|
18 | - DB::table('permissions')->insert( |
|
19 | - [ |
|
20 | - /** |
|
21 | - * Logs model permissions. |
|
22 | - */ |
|
23 | - [ |
|
24 | - 'name' => 'find', |
|
25 | - 'model' => 'logs', |
|
26 | - 'created_at' => \DB::raw('NOW()'), |
|
27 | - 'updated_at' => \DB::raw('NOW()') |
|
28 | - ], |
|
29 | - [ |
|
30 | - 'name' => 'search', |
|
31 | - 'model' => 'logs', |
|
32 | - 'created_at' => \DB::raw('NOW()'), |
|
33 | - 'updated_at' => \DB::raw('NOW()') |
|
34 | - ], |
|
35 | - [ |
|
36 | - 'name' => 'list', |
|
37 | - 'model' => 'logs', |
|
38 | - 'created_at' => \DB::raw('NOW()'), |
|
39 | - 'updated_at' => \DB::raw('NOW()') |
|
40 | - ], |
|
41 | - [ |
|
42 | - 'name' => 'findby', |
|
43 | - 'model' => 'logs', |
|
44 | - 'created_at' => \DB::raw('NOW()'), |
|
45 | - 'updated_at' => \DB::raw('NOW()') |
|
46 | - ], |
|
47 | - [ |
|
48 | - 'name' => 'first', |
|
49 | - 'model' => 'logs', |
|
50 | - 'created_at' => \DB::raw('NOW()'), |
|
51 | - 'updated_at' => \DB::raw('NOW()') |
|
52 | - ], |
|
53 | - [ |
|
54 | - 'name' => 'paginate', |
|
55 | - 'model' => 'logs', |
|
56 | - 'created_at' => \DB::raw('NOW()'), |
|
57 | - 'updated_at' => \DB::raw('NOW()') |
|
58 | - ], |
|
59 | - [ |
|
60 | - 'name' => 'paginateby', |
|
61 | - 'model' => 'logs', |
|
62 | - 'created_at' => \DB::raw('NOW()'), |
|
63 | - 'updated_at' => \DB::raw('NOW()') |
|
64 | - ], |
|
65 | - ] |
|
66 | - ); |
|
16 | + * Insert the permissions related to this module. |
|
17 | + */ |
|
18 | + DB::table('permissions')->insert( |
|
19 | + [ |
|
20 | + /** |
|
21 | + * Logs model permissions. |
|
22 | + */ |
|
23 | + [ |
|
24 | + 'name' => 'find', |
|
25 | + 'model' => 'logs', |
|
26 | + 'created_at' => \DB::raw('NOW()'), |
|
27 | + 'updated_at' => \DB::raw('NOW()') |
|
28 | + ], |
|
29 | + [ |
|
30 | + 'name' => 'search', |
|
31 | + 'model' => 'logs', |
|
32 | + 'created_at' => \DB::raw('NOW()'), |
|
33 | + 'updated_at' => \DB::raw('NOW()') |
|
34 | + ], |
|
35 | + [ |
|
36 | + 'name' => 'list', |
|
37 | + 'model' => 'logs', |
|
38 | + 'created_at' => \DB::raw('NOW()'), |
|
39 | + 'updated_at' => \DB::raw('NOW()') |
|
40 | + ], |
|
41 | + [ |
|
42 | + 'name' => 'findby', |
|
43 | + 'model' => 'logs', |
|
44 | + 'created_at' => \DB::raw('NOW()'), |
|
45 | + 'updated_at' => \DB::raw('NOW()') |
|
46 | + ], |
|
47 | + [ |
|
48 | + 'name' => 'first', |
|
49 | + 'model' => 'logs', |
|
50 | + 'created_at' => \DB::raw('NOW()'), |
|
51 | + 'updated_at' => \DB::raw('NOW()') |
|
52 | + ], |
|
53 | + [ |
|
54 | + 'name' => 'paginate', |
|
55 | + 'model' => 'logs', |
|
56 | + 'created_at' => \DB::raw('NOW()'), |
|
57 | + 'updated_at' => \DB::raw('NOW()') |
|
58 | + ], |
|
59 | + [ |
|
60 | + 'name' => 'paginateby', |
|
61 | + 'model' => 'logs', |
|
62 | + 'created_at' => \DB::raw('NOW()'), |
|
63 | + 'updated_at' => \DB::raw('NOW()') |
|
64 | + ], |
|
65 | + ] |
|
66 | + ); |
|
67 | 67 | } |
68 | 68 | |
69 | 69 | /** |
@@ -13,185 +13,185 @@ |
||
13 | 13 | public function up() |
14 | 14 | { |
15 | 15 | /** |
16 | - * Insert the permissions related to this module. |
|
17 | - */ |
|
18 | - DB::table('permissions')->insert( |
|
19 | - [ |
|
20 | - /** |
|
21 | - * Users model permissions. |
|
22 | - */ |
|
23 | - [ |
|
24 | - 'name' => 'save', |
|
25 | - 'model' => 'users', |
|
26 | - 'created_at' => \DB::raw('NOW()'), |
|
27 | - 'updated_at' => \DB::raw('NOW()') |
|
28 | - ], |
|
29 | - [ |
|
30 | - 'name' => 'delete', |
|
31 | - 'model' => 'users', |
|
32 | - 'created_at' => \DB::raw('NOW()'), |
|
33 | - 'updated_at' => \DB::raw('NOW()') |
|
34 | - ], |
|
35 | - [ |
|
36 | - 'name' => 'find', |
|
37 | - 'model' => 'users', |
|
38 | - 'created_at' => \DB::raw('NOW()'), |
|
39 | - 'updated_at' => \DB::raw('NOW()') |
|
40 | - ], |
|
41 | - [ |
|
42 | - 'name' => 'list', |
|
43 | - 'model' => 'users', |
|
44 | - 'created_at' => \DB::raw('NOW()'), |
|
45 | - 'updated_at' => \DB::raw('NOW()') |
|
46 | - ], |
|
47 | - [ |
|
48 | - 'name' => 'search', |
|
49 | - 'model' => 'users', |
|
50 | - 'created_at' => \DB::raw('NOW()'), |
|
51 | - 'updated_at' => \DB::raw('NOW()') |
|
52 | - ], |
|
53 | - [ |
|
54 | - 'name' => 'findby', |
|
55 | - 'model' => 'users', |
|
56 | - 'created_at' => \DB::raw('NOW()'), |
|
57 | - 'updated_at' => \DB::raw('NOW()') |
|
58 | - ], |
|
59 | - [ |
|
60 | - 'name' => 'first', |
|
61 | - 'model' => 'users', |
|
62 | - 'created_at' => \DB::raw('NOW()'), |
|
63 | - 'updated_at' => \DB::raw('NOW()') |
|
64 | - ], |
|
65 | - [ |
|
66 | - 'name' => 'paginate', |
|
67 | - 'model' => 'users', |
|
68 | - 'created_at' => \DB::raw('NOW()'), |
|
69 | - 'updated_at' => \DB::raw('NOW()') |
|
70 | - ], |
|
71 | - [ |
|
72 | - 'name' => 'paginateby', |
|
73 | - 'model' => 'users', |
|
74 | - 'created_at' => \DB::raw('NOW()'), |
|
75 | - 'updated_at' => \DB::raw('NOW()') |
|
76 | - ], |
|
77 | - [ |
|
78 | - 'name' => 'assigngroup', |
|
79 | - 'model' => 'users', |
|
80 | - 'created_at' => \DB::raw('NOW()'), |
|
81 | - 'updated_at' => \DB::raw('NOW()') |
|
82 | - ], |
|
16 | + * Insert the permissions related to this module. |
|
17 | + */ |
|
18 | + DB::table('permissions')->insert( |
|
19 | + [ |
|
20 | + /** |
|
21 | + * Users model permissions. |
|
22 | + */ |
|
23 | + [ |
|
24 | + 'name' => 'save', |
|
25 | + 'model' => 'users', |
|
26 | + 'created_at' => \DB::raw('NOW()'), |
|
27 | + 'updated_at' => \DB::raw('NOW()') |
|
28 | + ], |
|
29 | + [ |
|
30 | + 'name' => 'delete', |
|
31 | + 'model' => 'users', |
|
32 | + 'created_at' => \DB::raw('NOW()'), |
|
33 | + 'updated_at' => \DB::raw('NOW()') |
|
34 | + ], |
|
35 | + [ |
|
36 | + 'name' => 'find', |
|
37 | + 'model' => 'users', |
|
38 | + 'created_at' => \DB::raw('NOW()'), |
|
39 | + 'updated_at' => \DB::raw('NOW()') |
|
40 | + ], |
|
41 | + [ |
|
42 | + 'name' => 'list', |
|
43 | + 'model' => 'users', |
|
44 | + 'created_at' => \DB::raw('NOW()'), |
|
45 | + 'updated_at' => \DB::raw('NOW()') |
|
46 | + ], |
|
47 | + [ |
|
48 | + 'name' => 'search', |
|
49 | + 'model' => 'users', |
|
50 | + 'created_at' => \DB::raw('NOW()'), |
|
51 | + 'updated_at' => \DB::raw('NOW()') |
|
52 | + ], |
|
53 | + [ |
|
54 | + 'name' => 'findby', |
|
55 | + 'model' => 'users', |
|
56 | + 'created_at' => \DB::raw('NOW()'), |
|
57 | + 'updated_at' => \DB::raw('NOW()') |
|
58 | + ], |
|
59 | + [ |
|
60 | + 'name' => 'first', |
|
61 | + 'model' => 'users', |
|
62 | + 'created_at' => \DB::raw('NOW()'), |
|
63 | + 'updated_at' => \DB::raw('NOW()') |
|
64 | + ], |
|
65 | + [ |
|
66 | + 'name' => 'paginate', |
|
67 | + 'model' => 'users', |
|
68 | + 'created_at' => \DB::raw('NOW()'), |
|
69 | + 'updated_at' => \DB::raw('NOW()') |
|
70 | + ], |
|
71 | + [ |
|
72 | + 'name' => 'paginateby', |
|
73 | + 'model' => 'users', |
|
74 | + 'created_at' => \DB::raw('NOW()'), |
|
75 | + 'updated_at' => \DB::raw('NOW()') |
|
76 | + ], |
|
77 | + [ |
|
78 | + 'name' => 'assigngroup', |
|
79 | + 'model' => 'users', |
|
80 | + 'created_at' => \DB::raw('NOW()'), |
|
81 | + 'updated_at' => \DB::raw('NOW()') |
|
82 | + ], |
|
83 | 83 | |
84 | - /** |
|
85 | - * Permissions model permissions. |
|
86 | - */ |
|
87 | - [ |
|
88 | - 'name' => 'find', |
|
89 | - 'model' => 'permissions', |
|
90 | - 'created_at' => \DB::raw('NOW()'), |
|
91 | - 'updated_at' => \DB::raw('NOW()') |
|
92 | - ], |
|
93 | - [ |
|
94 | - 'name' => 'search', |
|
95 | - 'model' => 'permissions', |
|
96 | - 'created_at' => \DB::raw('NOW()'), |
|
97 | - 'updated_at' => \DB::raw('NOW()') |
|
98 | - ], |
|
99 | - [ |
|
100 | - 'name' => 'list', |
|
101 | - 'model' => 'permissions', |
|
102 | - 'created_at' => \DB::raw('NOW()'), |
|
103 | - 'updated_at' => \DB::raw('NOW()') |
|
104 | - ], |
|
105 | - [ |
|
106 | - 'name' => 'findby', |
|
107 | - 'model' => 'permissions', |
|
108 | - 'created_at' => \DB::raw('NOW()'), |
|
109 | - 'updated_at' => \DB::raw('NOW()') |
|
110 | - ], |
|
111 | - [ |
|
112 | - 'name' => 'first', |
|
113 | - 'model' => 'permissions', |
|
114 | - 'created_at' => \DB::raw('NOW()'), |
|
115 | - 'updated_at' => \DB::raw('NOW()') |
|
116 | - ], |
|
117 | - [ |
|
118 | - 'name' => 'paginate', |
|
119 | - 'model' => 'permissions', |
|
120 | - 'created_at' => \DB::raw('NOW()'), |
|
121 | - 'updated_at' => \DB::raw('NOW()') |
|
122 | - ], |
|
123 | - [ |
|
124 | - 'name' => 'paginateby', |
|
125 | - 'model' => 'permissions', |
|
126 | - 'created_at' => \DB::raw('NOW()'), |
|
127 | - 'updated_at' => \DB::raw('NOW()') |
|
128 | - ], |
|
84 | + /** |
|
85 | + * Permissions model permissions. |
|
86 | + */ |
|
87 | + [ |
|
88 | + 'name' => 'find', |
|
89 | + 'model' => 'permissions', |
|
90 | + 'created_at' => \DB::raw('NOW()'), |
|
91 | + 'updated_at' => \DB::raw('NOW()') |
|
92 | + ], |
|
93 | + [ |
|
94 | + 'name' => 'search', |
|
95 | + 'model' => 'permissions', |
|
96 | + 'created_at' => \DB::raw('NOW()'), |
|
97 | + 'updated_at' => \DB::raw('NOW()') |
|
98 | + ], |
|
99 | + [ |
|
100 | + 'name' => 'list', |
|
101 | + 'model' => 'permissions', |
|
102 | + 'created_at' => \DB::raw('NOW()'), |
|
103 | + 'updated_at' => \DB::raw('NOW()') |
|
104 | + ], |
|
105 | + [ |
|
106 | + 'name' => 'findby', |
|
107 | + 'model' => 'permissions', |
|
108 | + 'created_at' => \DB::raw('NOW()'), |
|
109 | + 'updated_at' => \DB::raw('NOW()') |
|
110 | + ], |
|
111 | + [ |
|
112 | + 'name' => 'first', |
|
113 | + 'model' => 'permissions', |
|
114 | + 'created_at' => \DB::raw('NOW()'), |
|
115 | + 'updated_at' => \DB::raw('NOW()') |
|
116 | + ], |
|
117 | + [ |
|
118 | + 'name' => 'paginate', |
|
119 | + 'model' => 'permissions', |
|
120 | + 'created_at' => \DB::raw('NOW()'), |
|
121 | + 'updated_at' => \DB::raw('NOW()') |
|
122 | + ], |
|
123 | + [ |
|
124 | + 'name' => 'paginateby', |
|
125 | + 'model' => 'permissions', |
|
126 | + 'created_at' => \DB::raw('NOW()'), |
|
127 | + 'updated_at' => \DB::raw('NOW()') |
|
128 | + ], |
|
129 | 129 | |
130 | - /** |
|
131 | - * Groups model permissions. |
|
132 | - */ |
|
133 | - [ |
|
134 | - 'name' => 'save', |
|
135 | - 'model' => 'groups', |
|
136 | - 'created_at' => \DB::raw('NOW()'), |
|
137 | - 'updated_at' => \DB::raw('NOW()') |
|
138 | - ], |
|
139 | - [ |
|
140 | - 'name' => 'delete', |
|
141 | - 'model' => 'groups', |
|
142 | - 'created_at' => \DB::raw('NOW()'), |
|
143 | - 'updated_at' => \DB::raw('NOW()') |
|
144 | - ], |
|
145 | - [ |
|
146 | - 'name' => 'find', |
|
147 | - 'model' => 'groups', |
|
148 | - 'created_at' => \DB::raw('NOW()'), |
|
149 | - 'updated_at' => \DB::raw('NOW()') |
|
150 | - ], |
|
151 | - [ |
|
152 | - 'name' => 'search', |
|
153 | - 'model' => 'groups', |
|
154 | - 'created_at' => \DB::raw('NOW()'), |
|
155 | - 'updated_at' => \DB::raw('NOW()') |
|
156 | - ], |
|
157 | - [ |
|
158 | - 'name' => 'list', |
|
159 | - 'model' => 'groups', |
|
160 | - 'created_at' => \DB::raw('NOW()'), |
|
161 | - 'updated_at' => \DB::raw('NOW()') |
|
162 | - ], |
|
163 | - [ |
|
164 | - 'name' => 'findby', |
|
165 | - 'model' => 'groups', |
|
166 | - 'created_at' => \DB::raw('NOW()'), |
|
167 | - 'updated_at' => \DB::raw('NOW()') |
|
168 | - ], |
|
169 | - [ |
|
170 | - 'name' => 'first', |
|
171 | - 'model' => 'groups', |
|
172 | - 'created_at' => \DB::raw('NOW()'), |
|
173 | - 'updated_at' => \DB::raw('NOW()') |
|
174 | - ], |
|
175 | - [ |
|
176 | - 'name' => 'paginate', |
|
177 | - 'model' => 'groups', |
|
178 | - 'created_at' => \DB::raw('NOW()'), |
|
179 | - 'updated_at' => \DB::raw('NOW()') |
|
180 | - ], |
|
181 | - [ |
|
182 | - 'name' => 'paginateby', |
|
183 | - 'model' => 'groups', |
|
184 | - 'created_at' => \DB::raw('NOW()'), |
|
185 | - 'updated_at' => \DB::raw('NOW()') |
|
186 | - ], |
|
187 | - [ |
|
188 | - 'name' => 'assignpermissions', |
|
189 | - 'model' => 'groups', |
|
190 | - 'created_at' => \DB::raw('NOW()'), |
|
191 | - 'updated_at' => \DB::raw('NOW()') |
|
192 | - ], |
|
193 | - ] |
|
194 | - ); |
|
130 | + /** |
|
131 | + * Groups model permissions. |
|
132 | + */ |
|
133 | + [ |
|
134 | + 'name' => 'save', |
|
135 | + 'model' => 'groups', |
|
136 | + 'created_at' => \DB::raw('NOW()'), |
|
137 | + 'updated_at' => \DB::raw('NOW()') |
|
138 | + ], |
|
139 | + [ |
|
140 | + 'name' => 'delete', |
|
141 | + 'model' => 'groups', |
|
142 | + 'created_at' => \DB::raw('NOW()'), |
|
143 | + 'updated_at' => \DB::raw('NOW()') |
|
144 | + ], |
|
145 | + [ |
|
146 | + 'name' => 'find', |
|
147 | + 'model' => 'groups', |
|
148 | + 'created_at' => \DB::raw('NOW()'), |
|
149 | + 'updated_at' => \DB::raw('NOW()') |
|
150 | + ], |
|
151 | + [ |
|
152 | + 'name' => 'search', |
|
153 | + 'model' => 'groups', |
|
154 | + 'created_at' => \DB::raw('NOW()'), |
|
155 | + 'updated_at' => \DB::raw('NOW()') |
|
156 | + ], |
|
157 | + [ |
|
158 | + 'name' => 'list', |
|
159 | + 'model' => 'groups', |
|
160 | + 'created_at' => \DB::raw('NOW()'), |
|
161 | + 'updated_at' => \DB::raw('NOW()') |
|
162 | + ], |
|
163 | + [ |
|
164 | + 'name' => 'findby', |
|
165 | + 'model' => 'groups', |
|
166 | + 'created_at' => \DB::raw('NOW()'), |
|
167 | + 'updated_at' => \DB::raw('NOW()') |
|
168 | + ], |
|
169 | + [ |
|
170 | + 'name' => 'first', |
|
171 | + 'model' => 'groups', |
|
172 | + 'created_at' => \DB::raw('NOW()'), |
|
173 | + 'updated_at' => \DB::raw('NOW()') |
|
174 | + ], |
|
175 | + [ |
|
176 | + 'name' => 'paginate', |
|
177 | + 'model' => 'groups', |
|
178 | + 'created_at' => \DB::raw('NOW()'), |
|
179 | + 'updated_at' => \DB::raw('NOW()') |
|
180 | + ], |
|
181 | + [ |
|
182 | + 'name' => 'paginateby', |
|
183 | + 'model' => 'groups', |
|
184 | + 'created_at' => \DB::raw('NOW()'), |
|
185 | + 'updated_at' => \DB::raw('NOW()') |
|
186 | + ], |
|
187 | + [ |
|
188 | + 'name' => 'assignpermissions', |
|
189 | + 'model' => 'groups', |
|
190 | + 'created_at' => \DB::raw('NOW()'), |
|
191 | + 'updated_at' => \DB::raw('NOW()') |
|
192 | + ], |
|
193 | + ] |
|
194 | + ); |
|
195 | 195 | } |
196 | 196 | |
197 | 197 | /** |
@@ -8,16 +8,16 @@ |
||
8 | 8 | class ReportsController extends BaseApiController |
9 | 9 | { |
10 | 10 | /** |
11 | - * The name of the model that is used by the base api controller |
|
12 | - * to preform actions like (add, edit ... etc). |
|
13 | - * @var string |
|
14 | - */ |
|
15 | - protected $model = 'reports'; |
|
11 | + * The name of the model that is used by the base api controller |
|
12 | + * to preform actions like (add, edit ... etc). |
|
13 | + * @var string |
|
14 | + */ |
|
15 | + protected $model = 'reports'; |
|
16 | 16 | |
17 | - /** |
|
18 | - * List of all route actions that the base api controller |
|
19 | - * will skip permissions check for them. |
|
20 | - * @var array |
|
21 | - */ |
|
22 | - protected $skipPermissionCheck = ['find', 'first']; |
|
17 | + /** |
|
18 | + * List of all route actions that the base api controller |
|
19 | + * will skip permissions check for them. |
|
20 | + * @var array |
|
21 | + */ |
|
22 | + protected $skipPermissionCheck = ['find', 'first']; |
|
23 | 23 | } |
@@ -12,7 +12,7 @@ |
||
12 | 12 | * to preform actions like (add, edit ... etc). |
13 | 13 | * @var string |
14 | 14 | */ |
15 | - protected $model = 'reports'; |
|
15 | + protected $model = 'reports'; |
|
16 | 16 | |
17 | 17 | /** |
18 | 18 | * List of all route actions that the base api controller |
@@ -5,7 +5,7 @@ discard block |
||
5 | 5 | |
6 | 6 | class Report extends Model{ |
7 | 7 | |
8 | - use SoftDeletes; |
|
8 | + use SoftDeletes; |
|
9 | 9 | protected $table = 'reports'; |
10 | 10 | protected $dates = ['created_at', 'updated_at', 'deleted_at']; |
11 | 11 | protected $hidden = ['deleted_at']; |
@@ -13,22 +13,22 @@ discard block |
||
13 | 13 | protected $fillable = ['report_name', 'view_name']; |
14 | 14 | |
15 | 15 | public function getCreatedAtAttribute($value) |
16 | - { |
|
17 | - return \Carbon\Carbon::parse($value)->addHours(\Session::get('timeZoneDiff'))->toDateTimeString(); |
|
18 | - } |
|
16 | + { |
|
17 | + return \Carbon\Carbon::parse($value)->addHours(\Session::get('timeZoneDiff'))->toDateTimeString(); |
|
18 | + } |
|
19 | 19 | |
20 | - public function getUpdatedAtAttribute($value) |
|
21 | - { |
|
22 | - return \Carbon\Carbon::parse($value)->addHours(\Session::get('timeZoneDiff'))->toDateTimeString(); |
|
23 | - } |
|
20 | + public function getUpdatedAtAttribute($value) |
|
21 | + { |
|
22 | + return \Carbon\Carbon::parse($value)->addHours(\Session::get('timeZoneDiff'))->toDateTimeString(); |
|
23 | + } |
|
24 | 24 | |
25 | - public function getDeletedAtAttribute($value) |
|
26 | - { |
|
27 | - return \Carbon\Carbon::parse($value)->addHours(\Session::get('timeZoneDiff'))->toDateTimeString(); |
|
28 | - } |
|
25 | + public function getDeletedAtAttribute($value) |
|
26 | + { |
|
27 | + return \Carbon\Carbon::parse($value)->addHours(\Session::get('timeZoneDiff'))->toDateTimeString(); |
|
28 | + } |
|
29 | 29 | |
30 | - public static function boot() |
|
31 | - { |
|
32 | - parent::boot(); |
|
33 | - } |
|
30 | + public static function boot() |
|
31 | + { |
|
32 | + parent::boot(); |
|
33 | + } |
|
34 | 34 | } |
@@ -3,7 +3,7 @@ |
||
3 | 3 | use Illuminate\Database\Eloquent\Model; |
4 | 4 | use Illuminate\Database\Eloquent\SoftDeletes; |
5 | 5 | |
6 | -class Report extends Model{ |
|
6 | +class Report extends Model { |
|
7 | 7 | |
8 | 8 | use SoftDeletes; |
9 | 9 | protected $table = 'reports'; |
@@ -22,15 +22,15 @@ |
||
22 | 22 | "); |
23 | 23 | |
24 | 24 | DB::table('reports')->insert( |
25 | - [ |
|
26 | - [ |
|
25 | + [ |
|
26 | + [ |
|
27 | 27 | 'report_name' => 'admin_count', |
28 | 28 | 'view_name' => 'admin_count', |
29 | 29 | 'created_at' => \DB::raw('NOW()'), |
30 | 30 | 'updated_at' => \DB::raw('NOW()') |
31 | - ] |
|
32 | - ] |
|
33 | - ); |
|
31 | + ] |
|
32 | + ] |
|
33 | + ); |
|
34 | 34 | } |
35 | 35 | |
36 | 36 | /** |
@@ -12,8 +12,8 @@ |
||
12 | 12 | */ |
13 | 13 | public function up() |
14 | 14 | { |
15 | - DB::statement( "DROP VIEW IF EXISTS admin_count"); |
|
16 | - DB::statement( "CREATE VIEW admin_count AS |
|
15 | + DB::statement("DROP VIEW IF EXISTS admin_count"); |
|
16 | + DB::statement("CREATE VIEW admin_count AS |
|
17 | 17 | select count(u.id) |
18 | 18 | from users u, groups g ,users_groups ug |
19 | 19 | where |