users/users_controller.php at master · tuxudo/users · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
<?php

/**
 * Users module class
 *
 * @package munkireport
 * @author tuxudo
 **/
class Users_controller extends Module_controller
{

	/*** Protect methods with auth! ****/
	function __construct()
	{
		// Store module path
		$this->module_path = dirname(__FILE__);

        // Add local config
        configAppendFile(__DIR__ . '/config.php');
	}

	/**
	 * Default method
	 * @author tuxudo
	 *
	 **/
	function index()
	{
		echo "You've loaded the users module!";
	}

    /**
     * REST API for retrieving screen sharing users for widget
     * @tuxudo
     *
     **/
     public function screensharing_users()
     {
        jsonView(
            Users_model::selectRaw('record_name, COUNT(record_name) AS count')
                ->where('screenshare_access', '=', 1)
                ->filter()
                ->groupBy('record_name')
                ->orderBy('count', 'desc')
                ->get()
                ->toArray()
        );
   }

    /**
     * REST API for retrieving ssh users for widget
     * @tuxudo
     *
     **/
     public function ssh_users()
     {
        jsonView(
            Users_model::selectRaw('record_name, COUNT(record_name) AS count')
                ->where('ssh_access', '=', 1)
                ->filter()
                ->groupBy('record_name')
                ->orderBy('count', 'desc')
                ->get()
                ->toArray()
        );
   }

    /**
     * REST API for retrieving local admin users count for widget
     * @tuxudo
     *
     **/
     public function get_local_admin()
     {
        $threshold = (int) conf('users_local_admin_threshold');

        jsonView(
            Users_model::selectRaw('users.serial_number, machine.computer_name, COUNT(users.record_name) AS count')
                ->join('machine', 'machine.serial_number', '=', 'users.serial_number')
                ->where('administrator', '=', 1)
                ->having('count', '>=', $threshold)
                ->filter()
                ->orderBy('count', 'desc')
                ->groupBy('machine.computer_name', 'users.serial_number')
                ->get()
                ->toArray()
        );
   }

    /**
     * REST API for retrieving admin users for widget
     * @tuxudo
     *
     **/
     public function admin_users()
     {
         jsonView(
            Users_model::selectRaw('record_name, COUNT(record_name) AS count')
                ->where('administrator', '=', 1)
                ->filter()
                ->groupBy('record_name')
                ->orderBy('count', 'desc')
                ->get()
                ->toArray()
         );
   }

	/**
     * Retrieve data in json format
     *
     **/
    public function get_tab_data($serial_number = '')
    {
         jsonView(
            Users_model::selectRaw('record_name, real_name, unique_id, password_hint, home_directory, primary_group_id, administrator, ssh_access, screenshare_access, user_shell, generated_uuid, last_login_timestamp, creation_time, password_last_set_time, failed_login_count, failed_login_timestamp, password_history_depth, linked_full_name, linked_timestamp, group_memership, meta_record_name, email_address, smb_group_rid, smb_home, smb_home_drive, smb_primary_group_sid, smb_sid, smb_script_path, smb_password_last_set, original_node_name, primary_nt_domain, copy_timestamp')
                ->where('users.serial_number', $serial_number)
                ->filter()
                ->get()
                ->toArray()
         );
    }
} // End class Users_controller