Magellan Linux

Diff of /alx-src/branches/alx-web-070/index.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 8006 by niro, Wed Dec 16 15:26:57 2015 UTC revision 13245 by niro, Wed Jul 10 08:54:02 2019 UTC
# Line 3  Line 3 
3  include('include/basesql.php');  include('include/basesql.php');
4  include('include/common-functions.php');  include('include/common-functions.php');
5    
6  session_start();  if(session_status() !== PHP_SESSION_ACTIVE) session_start();
7  //session_register('alx_sort_krit'); session_register('alx_sort_onfirst'); session_register('alx_sort_loc');  //session_register('alx_sort_krit'); session_register('alx_sort_onfirst'); session_register('alx_sort_loc');
8  $_SESSION['alx_sort_krit'] = $alx_sort_krit;  if(isset($_SESSION['alx_sort_krit'])) $alx_sort_krit = $_SESSION['alx_sort_krit'];
9  $_SESSION['alx_sort_onfirst'] = $alx_sort_onfirst;  if(isset($_SESSION['alx_sort_onfirst'])) $alx_sort_onfirst = $_SESSION['alx_sort_onfirst'];
10  $_SESSION['alx_sort_loc'] = $alx_sort_loc;  if(isset($_SESSION['alx_sort_loc'])) $alx_sort_loc = $_SESSION['alx_sort_loc'];
11    
12    // fix reload php debug message
13    if(!isset($reload)) $reload = 'not set';
14    
15  $locations = sqlarr('SELECT location FROM client_locations where enabled="1"', '', 'location');  $locations = sqlarr('SELECT location FROM client_locations where enabled="1"', '', 'location');
16  $locations[] = '';  $locations[] = '';
# Line 22  if($_SESSION['alx_sort_krit']==null) Line 25  if($_SESSION['alx_sort_krit']==null)
25  if(isset($_GET['s_krit']))  if(isset($_GET['s_krit']))
26  {  {
27   $_SESSION['alx_sort_krit']=$_GET['s_krit'];   $_SESSION['alx_sort_krit']=$_GET['s_krit'];
28   $_SESSION['alx_sort_onfirst']=0+$_GET['s_on'];  
29   $_SESSION['alx_sort_loc']['DEAD']=$_GET['s_dead'];   if(isset($_GET['s_on'])) $_SESSION['alx_sort_onfirst']=0+$_GET['s_on'];
30   foreach($locations as $l) $_SESSION['alx_sort_loc'][$l]=$_GET['s_'.$l];   else $_SESSION['alx_sort_onfirst']=0+NULL;
31    
32     if(isset($_GET['s_dead'])) $_SESSION['alx_sort_loc']['DEAD']=$_GET['s_dead'];
33     else $_SESSION['alx_sort_loc']['DEAD']=NULL;
34    
35     foreach($locations as $l) {
36     if(isset($_GET['s_'.$l])) $_SESSION['alx_sort_loc'][$l]=$_GET['s_'.$l];
37     else $_SESSION['alx_sort_loc'][$l]=NULL;
38     }
39  }  }
40    
41  function check_online($dat, $bla)  function check_online($dat, $bla)
42  {  {
43   global $comps;   global $comps;
  global $ssh_port;  
44   global $mcore_port;   global $mcore_port;
45   global $ping_timeout;   global $ping_timeout;
46   if(!isset($comps[$dat['serial']])) return false;   if(!isset($comps[$dat['serial']])) return false;
47    
  // first try mcore, then get ssh  
48   $retval = ping_host($dat['ip'],$mcore_port,$ping_timeout);   $retval = ping_host($dat['ip'],$mcore_port,$ping_timeout);
  if($retval==1) $retval = ping_host($dat['ip'],$ssh_port,$ping_timeout);  
49   if($retval==0)   if($retval==0)
50   {   {
51   $comps[$dat['serial']]['online'] = true;   $comps[$dat['serial']]['online'] = true;
# Line 56  function sortcomp($a,$b) Line 64  function sortcomp($a,$b)
64    
65   if($_SESSION['alx_sort_onfirst'])   if($_SESSION['alx_sort_onfirst'])
66   {   {
67   if($a['online'] && !$b['online']) return -1;   if(isset($a['online']) && !isset($b['online'])) return -1;
68   if($b['online'] && !$a['online']) return 1;   if(isset($b['online']) && !isset($a['online'])) return 1;
69   }   }
70   if($_SESSION['alx_sort_krit']=='hostname')   if($_SESSION['alx_sort_krit']=='hostname')
71   {   {
# Line 73  function checkif($b) Line 81  function checkif($b)
81   else return '';   else return '';
82  }  }
83    
84  $comps = sqlarr("select client_serials.serial, client_serials.location, client_serials.mac, cfg_network.hostname, state_connected.mtime, state_connected.netboot from client_serials left join cfg_network on client_serials.serial=cfg_network.serial left join state_connected on client_serials.serial=state_connected.serial", "serial");  $comps = sqlarr("select client_serials.serial, client_serials.enabled, client_serials.location, client_serials.mac, cfg_network.hostname, state_connected.mtime, state_connected.netboot from client_serials left join cfg_network on client_serials.serial=cfg_network.serial left join state_connected on client_serials.serial=state_connected.serial", "serial");
85    
86  sqlforeach('SELECT state_connected.serial, state_connected.ip, cfg_network.hostname, state_connected.mac FROM state_connected left join cfg_network on cfg_network.serial=state_connected.serial', 'check_online', null);  sqlforeach('SELECT state_connected.serial, state_connected.ip, cfg_network.hostname, state_connected.mac FROM state_connected left join cfg_network on cfg_network.serial=state_connected.serial', 'check_online', null);
87  usort($comps, 'sortcomp');  usort($comps, 'sortcomp');
88  echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"  echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
89      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">';   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">';
90  echo '<head>';  echo '<head>';
91   echo '<title>ALX Config - Index</title>';   echo '<title>ALX Config - Index</title>';
92   echo '<script language="JavaScript">';   echo '<script language="JavaScript">';
# Line 91  echo '<script type="text/javascript" src Line 99  echo '<script type="text/javascript" src
99    
100  if($reload!='off') echo '<body onload="window.setTimeout(\'location.reload()\',60000)">';  if($reload!='off') echo '<body onload="window.setTimeout(\'location.reload()\',60000)">';
101    
 /*  
 echo '<img src="logo.jpg" align=middle>';  
 echo '<a href="index.php" style="padding-left:170px; color:#000000;text-decoration:none; font-weight:bold">[REFRESH]</a><br>';  
   
 echo '<form action="index.php" method="get" style="margin-top:0px"><b>SORT BY</b> <input onclick="this.form.submit()" type="radio" name="s_krit" value="serial"'.checkif($_SESSION['alx_sort_krit']=='serial').'>serial <input onclick="this.form.submit()" type="radio" name="s_krit" value="hostname"'.checkif($_SESSION['alx_sort_krit']=='hostname').'>hostname';  
 echo '<input onclick="this.form.submit()" style="margin-left:125px" name="s_on" type="checkbox" value="1"'.checkif($_SESSION['alx_sort_onfirst']).'>online clients on top</form><br>';  
 */  
   
102  echo '<form action="index.php" method="get" style="margin:0px">';  echo '<form action="index.php" method="get" style="margin:0px">';
103  echo '<table width=480><tr>';  echo '<table width=480><tr>';
104  echo '<td><img src="pics/logo.jpg"></td>';  // print version info
105    $version = file_get_contents('./VERSION', FILE_USE_INCLUDE_PATH);
106    echo '<td><img src="pics/logo.jpg"><font size="1">v'.$version.'</font></td>';
107  echo '<td align=right valign=top><a href="index.php" style="color:#000000;text-decoration:none; font-weight:bold">[REFRESH]</a></td>';  echo '<td align=right valign=top><a href="index.php" style="color:#000000;text-decoration:none; font-weight:bold">[REFRESH]</a></td>';
108  echo '</tr><tr>';  echo '</tr><tr>';
109  echo '<td valign=top><b>SORT BY</b> <input onclick="this.form.submit()" type="radio" name="s_krit" value="serial"'.checkif($_SESSION['alx_sort_krit']=='serial').'>serial <input onclick="this.form.submit()" type="radio" name="s_krit" value="hostname"'.checkif($_SESSION['alx_sort_krit']=='hostname').'>hostname<br>';  echo '<td valign=top><b>SORT BY</b> <input onclick="this.form.submit()" type="radio" name="s_krit" value="serial"'.checkif($_SESSION['alx_sort_krit']=='serial').'>serial <input onclick="this.form.submit()" type="radio" name="s_krit" value="hostname"'.checkif($_SESSION['alx_sort_krit']=='hostname').'>hostname<br>';
# Line 120  echo '</form>'; Line 122  echo '</form>';
122    
123  echo '<table border="1" id="mytab">';  echo '<table border="1" id="mytab">';
124  echo '<thead><tr style="font-weight:bold;background-color:#d5e5ff"><th>edit</th><th colspan=3>serial</th><th width=170>hostname</th><th width=100>ip</th><th width=100>mac</th><th width=100>last connected</th>';  echo '<thead><tr style="font-weight:bold;background-color:#d5e5ff"><th>edit</th><th colspan=3>serial</th><th width=170>hostname</th><th width=100>ip</th><th width=100>mac</th><th width=100>last connected</th>';
125  //always enable showversion atm  echo '<th colspan=3>version</th>';
 $showversion = "on";  
 if($showversion=='on') echo '<th colspan=2>version</th>';  
126  echo '<th width=100>boot</th>';  echo '<th width=100>boot</th>';
127  echo '<th width=150>up/down</th></tr></thead><tbody>';  echo '<th width=150>up/down</th></tr></thead><tbody>';
128    
129  foreach($comps as $c)  foreach($comps as $c)
130  {  {
131   if(!$_SESSION['alx_sort_loc'][$c['location']]) Continue;   $alxinfo = array();
132   if($c['serial']<0 && !$_SESSION['alx_sort_loc']['DEAD']) Continue;  
133     if(!isset($_SESSION['alx_sort_loc'][$c['location']])) Continue;
134     if($c['enabled']==0 && !$_SESSION['alx_sort_loc']['DEAD']) Continue;
135    
136   if($c['online']) $pic='online';   if(isset($c['online'])) $pic='online';
137   else $pic='offline';   else $pic='offline';
138    
139   if($c['serial']<0)   if($c['enabled']==0)
140   {   {
141   echo '<tr style="text-decoration:line-through; color:#aaaaaa">';   echo '<tr style="text-decoration:line-through; color:#aaaaaa">';
142   $pic = 'deact';   $pic = 'deact';
# Line 147  foreach($comps as $c) Line 149  foreach($comps as $c)
149   echo '<td width=40><b>#'.$c['serial'].'</b></td>';   echo '<td width=40><b>#'.$c['serial'].'</b></td>';
150   echo '<td><nobr>'.$c['hostname'].'</nobr></td>';   echo '<td><nobr>'.$c['hostname'].'</nobr></td>';
151    
152   echo '<td><nobr>'.$c['ip'].'</nobr></td>';   echo '<td><nobr>'.$c['ip'].'</nobr></td>';
153   echo '<td><nobr>'.$c['mac'].'</nobr></td>';   echo '<td><nobr>'.$c['mac'].'</nobr></td>';
154   if($c['mtime']) { echo '<td><nobr>'.date('Y-m-d, H:i:s',$c['mtime']).'</nobr></td>'; }   if($c['mtime']) { echo '<td><nobr>'.date('Y-m-d, H:i:s',$c['mtime']).'</nobr></td>'; }
  //if($c['mtime']) { echo '<td><nobr>'.$c['mtime'].'</nobr></td>'; }  
155   else echo '<td></td>';   else echo '<td></td>';
156    
157   if($showversion=='on')   // get alx version info for
158   {   $alxinfo = sqlfirst('SELECT * FROM client_version WHERE serial='.$c['serial']);
159   // get alx version info for   if (isset($alxinfo['os'])) $alxver = $alxinfo['os'];
160   $alxinfo = sqlfirst('SELECT * FROM client_version WHERE serial='.$c['serial']);   else $alxver = 'unknown';
161   $alxver = $alxinfo[os];   if (isset($alxinfo['utils'])) $alxutils = $alxinfo['utils'];
162   $alxutils = $alxinfo[utils];   else $alxutils = 'unknown';
163    
164  // if( $alxver == '')   if (isset($alxinfo['arch'])) $alxarch = $alxinfo['arch'];
165  // {   else $alxarch = 'unknown';
166  // if($c['online'])  
167  // {   echo '<td>'.$alxver.'</td>';
168  // //$alxinfo = @sshdo('os_ver=$(</etc/mageversion);cfg_ver=$(/sbin/magequery -n alxconfig-ng | cut -d" " -f5);pname=${cfg_ver%-*-*};cfg_ver=${cfg_ver/${pname}-};echo "${os_ver}:${cfg_ver}"', $c['ip']);   echo '<td>'.$alxutils.'</td>';
169  // //$alxinfo = explode(':',$alxinfo[1]);   echo '<td>'.$alxarch.'</td>';
 // //$alxver = $alxinfo[0];  
 // //$alxutils = $alxinfo[1];  
 // }  
 // }  
  if($alxver == '') $alxver='unknown';  
  if($alxutils == '') $alxutils='unknown';  
   
  echo '<td>'.$alxver.'</td>';  
  echo '<td>'.$alxutils.'</td>';  
  }  
170    
171   //netboot state   // netboot state
172   if($c['netboot'] == 1) echo '<td>Netboot (PXE)</td>';   if($c['netboot'] == 1) echo '<td>Netboot (PXE)</td>';
173   else echo '<td>Local Disk</td>';   else echo '<td>Local Disk</td>';
174    
175   echo '<td>';   echo '<td>';
176   if($c['online'])   if(isset($c['online']))
177   {   {
178   echo '<input type=button style="width:24%" value="RB" onclick="if(confirm(\'REBOOT CLIENT #'.$c['serial'].' ?\')) window.open(\'reboot.php?client='.$c['serial'].'&ip='.$c['ip'].'&op=reboot\', \'ShutdownWin\', \'width=200,height=100\')">';   echo '<input type=button style="width:24%" value="RB" onclick="if(confirm(\'REBOOT CLIENT #'.$c['serial'].' ?\')) window.open(\'reboot.php?client='.$c['serial'].'&ip='.$c['ip'].'&op=reboot\', \'ShutdownWin\', \'width=200,height=100\')">';
179   echo '<input type=button style="width:24%" value="SD" onclick="if(confirm(\'SHUTDOWN CLIENT #'.$c['serial'].' ?\')) window.open(\'reboot.php?client='.$c['serial'].'&ip='.$c['ip'].'&op=halt\', \'ShutdownWin\', \'width=200,height=100\')">';   echo '<input type=button style="width:24%" value="SD" onclick="if(confirm(\'SHUTDOWN CLIENT #'.$c['serial'].' ?\')) window.open(\'reboot.php?client='.$c['serial'].'&ip='.$c['ip'].'&op=halt\', \'ShutdownWin\', \'width=200,height=100\')">';

Legend:
Removed from v.8006  
changed lines
  Added in v.13245