| 1 |  |  | <?php | 
            
                                                                                                            
                            
            
                                    
            
            
                | 2 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 3 |  |  | namespace App\Api\Controllers; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 4 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 5 |  |  | use DB; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 6 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 7 |  |  | class ApiController extends Controller | 
            
                                                                                                            
                            
            
                                    
            
            
                | 8 |  |  | { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 9 |  |  |     /** | 
            
                                                                                                            
                            
            
                                    
            
            
                | 10 |  |  |      * Get info about the install | 
            
                                                                                                            
                            
            
                                    
            
            
                | 11 |  |  |      */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 12 | 1 |  |     public function getInfo() | 
            
                                                                                                            
                            
            
                                    
            
            
                | 13 |  |  |     { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 14 | 1 |  |         $versions              = array(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 15 | 1 |  |         $versions['git']       = `git rev-parse --short HEAD`; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 16 | 1 |  |         $versions['db_schema'] = DB::select('SELECT `version` FROM `dbSchema` LIMIT 1')[0]->version; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 17 | 1 |  |         $versions['php']       = phpversion(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 18 | 1 |  |         $versions['db_driver'] = strtoupper(DB::connection()->getDriverName()); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 19 | 1 |  |         if ($versions['db_driver'] == 'SQLITE') { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 20 | 1 |  |             $versions['db_version'] = DB::select('SELECT sqlite_version() AS version')[0]->version; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 21 | 1 |  |         } else { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 22 |  |  |             $versions['db_version'] = DB::select('SELECT version() AS version')[0]->version; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 23 |  |  |         } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 24 |  |  |         return $versions; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 25 | 1 |  |     } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 26 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 27 |  |  |     /** | 
            
                                                                                                            
                            
            
                                    
            
            
                | 28 |  |  |      * Get statistics about the install | 
            
                                                                                                            
                            
            
                                    
            
            
                | 29 |  |  |      */ | 
            
                                                                                                            
                                                                
            
                                    
            
            
                | 30 |  |  |     public function getStats() | 
            
                                                        
            
                                    
            
            
                | 31 | 1 |  |     { | 
            
                                                        
            
                                    
            
            
                | 32 |  |  |         $stats               = array(); | 
            
                                                        
            
                                    
            
            
                | 33 | 1 |  |         $stats['devices']    = \App\Models\Device::all()->count(); | 
            
                                                        
            
                                    
            
            
                | 34 | 1 |  |         $stats['ports']      = \App\Models\Port::all()->count(); | 
            
                                                        
            
                                    
            
            
                | 35 | 1 |  |         $stats['syslog']     = \App\Models\General\Syslog::all()->count(); | 
            
                                                        
            
                                    
            
            
                | 36 | 1 |  |         $stats['eventlog']   = \App\Models\General\Eventlog::all()->count(); | 
            
                                                        
            
                                    
            
            
                | 37 | 1 |  |         $stats['apps']       = DB::table('applications')->count(); | 
            
                                                        
            
                                    
            
            
                | 38 | 1 |  |         $stats['services']   = DB::table('services')->count(); | 
            
                                                        
            
                                    
            
            
                | 39 | 1 |  |         $stats['storage']    = DB::table('storage')->count(); | 
            
                                                        
            
                                    
            
            
                | 40 | 1 |  |         $stats['diskio']     = DB::table('ucd_diskio')->count(); | 
            
                                                        
            
                                    
            
            
                | 41 | 1 |  |         $stats['processors'] = DB::table('processors')->count(); | 
            
                                                        
            
                                    
            
            
                | 42 | 1 |  |         $stats['memory']     = DB::table('mempools')->count(); | 
            
                                                        
            
                                    
            
            
                | 43 | 1 |  |         $stats['sensors']    = DB::table('sensors')->count(); | 
            
                                                        
            
                                    
            
            
                | 44 | 1 |  |         $stats['toner']      = DB::table('toner')->count(); | 
            
                                                        
            
                                    
            
            
                | 45 | 1 |  |         $stats['hrmib']      = DB::table('hrDevice')->count(); | 
            
                                                        
            
                                    
            
            
                | 46 | 1 |  |         $stats['entmib']     = DB::table('entPhysical')->count(); | 
            
                                                        
            
                                    
            
            
                | 47 | 1 |  |         $stats['ipv4_addr']  = DB::table('ipv4_addresses')->count(); | 
            
                                                        
            
                                    
            
            
                | 48 | 1 |  |         $stats['ipv4_net']   = DB::table('ipv4_networks')->count(); | 
            
                                                        
            
                                    
            
            
                | 49 | 1 |  |         $stats['ipv6_addr']  = DB::table('ipv6_addresses')->count(); | 
            
                                                        
            
                                    
            
            
                | 50 | 1 |  |         $stats['ipv6_net']   = DB::table('ipv6_networks')->count(); | 
            
                                                        
            
                                    
            
            
                | 51 | 1 |  |         $stats['pw']         = DB::table('pseudowires')->count(); | 
            
                                                        
            
                                    
            
            
                | 52 | 1 |  |         $stats['vrf']        = DB::table('vrfs')->count(); | 
            
                                                        
            
                                    
            
            
                | 53 | 1 |  |         $stats['vlans']      = DB::table('vlans')->count(); | 
            
                                                        
            
                                    
            
            
                | 54 | 1 |  |         return $stats; | 
            
                                                        
            
                                    
            
            
                | 55 | 1 |  |     } | 
            
                                                        
            
                                    
            
            
                | 56 |  |  | } | 
            
                                                        
            
                                    
            
            
                | 57 |  |  |  |