Subversion Repositories computer_asset_manager_v2

<?php
   include_once( 'DatabaseDefinition.php' );
   include_once( 'owner.class.php' );
   include_once( 'location.class.php' );
   include_once( 'device.class.php' );
   
   global $LOGFILE;
   $LOGFILE='/tmp/camp.log';
   define( 'VERSION', '2.0b' );
   define( 'BUILD_DATE', '20130527');
   
   function loadConfig() {
      // Search through directories looking for a config file
      $return = array(
         'error' => '',
         'path'  => '',
         'configuration' => array()
      );
      $configFileName = 'camp2_config.yaml';
      $searchDirectories = array( 
         // one level up from document root
         $_SERVER['DOCUMENT_ROOT'] . "/../$configFileName",
         // directory private one level up from document root
         $_SERVER['DOCUMENT_ROOT'] . "/../private/$configFileName",
         // the current directory
         "./$configFileName",
      );
      foreach ( $searchDirectories as $search ) {
         if ( file_exists( realpath( $search ) ) ) {
            $return['path'] = realpath( $search );
            $return['configuration'] = yaml_parse_file( $return['path'] );
            $return['error'] = '';
            return $return;
         } // if
      } // for
      $return['error'] = "No configuration found in<br />" . implode( '<br />', $searchDirectories );
      return $return;
   }
   
   function saveConfig( $filename, $configuration ) {
      return yaml_emit_file( $filename, $configuration );
   }
   
   function insertValuesIntoQuery( $query, $values ) {
      foreach ( $values as $name => $value ) {
         $query = search_replace_string($query, "<$name>", $value );
      }
      return $query;
   }

   function search_replace_string($string, $searchFor, $replaceWith ) {
      $string = str_replace ( $searchFor, $replaceWith, $string );
      return $string;
   }
   
   function processStats ( $className, $info ) {
      $result = "<div class='stats'>\n\t<h3>$className</h3>\n";
      foreach ( $info as $key => $value ) {
         $result .= "\t<p>$value $key</p>\n";
      }
      $result .= "</div>\n";
      return $result;
   }
   
   function doAdmin () {
      global $dbConnection;
      global $url;
      
      if ( ! isset( $_REQUEST['action'] ) ) { // just show the menu
         $return[] = "<a href='$url?module=admin&action=motd'>Edit MOTD</a>";
         $return = '<table><tr><td>' . join( "</td><td>", $return ) . '</td></tr></table>';
      } else {
         if ( $_REQUEST['action'] == 'motd' ) {
            if ( isset( $_REQUEST['new_motd'] ) ) {
               $motd = $dbConnection->real_escape_string( $_REQUEST['new_motd'] );
               $dbConnection->doSQL( "update _system set key_value = '$motd' where group_name = 'program' and key_name = 'motd'" );
            } else {
               $return = '<h3>Enter the Message of the Day</h3>';
               $return .= "<form action='$url' method='post'>\n";
               $return .= "<input type='hidden' name='module' value='admin'>\n";
               $return .= "<input type='hidden' name='action' value='motd'>\n";
               $return .= "<label MOTD><textarea name='new_motd'></textarea></label>\n";
               $return .= "<input type='submit' name='submit' value='Update'>\n";
               $return .= "</form>\n";
            }
         }
      }
      return $return;
   }
      
   
   /**
    * uses $_REQUEST to decide what to display
    * 
    * @param string[] $request The contents for $_REQUEST
    * 
    * @returns string HTML to be inserted into page
    */
   function displayHTML( $request ) {
      global $connection;
      global $dbConnection;
      global $baseURL;
      
      $return = '';

      if ( isset( $_REQUEST['doAdmin'] ) ) {
         $return = $_SESSION['user']->admin($connection) .  $_SESSION['user']->errors();
         $_SESSION['user']->clearErrors();
      } elseif ( isset( $_REQUEST['searchfor'] ) ) {
         $return = print_r( doSearch( $_REQUEST['searchfor'] ), true );
      } elseif ( isset( $_REQUEST['module'] ) ) {
         /* do something for a particular module */
         switch ( $_REQUEST['module'] ) {
            case 'admin' : $return = doAdmin();
                           break;
            default:       $return = sprintf( '<p>%s is not implemented yet</p>', $return = $_REQUEST['module'] );
         }
      } else { // default to this if nothing else works
         $motd = $dbConnection->getOneDBValue( "select key_value from _system where group_name = 'program' and key_name = 'motd'" );
         $return .= "<div class='motd'>$motd</div>";
         $return .= processStats( 'Owner', Owner::getStats() );
         $return .= processStats( 'Location', Location::getStats() );
         $return .= processStats( 'Device', Device::getStats() );
         //$return .= '<div class="stats"><pre>' . print_r( $_SESSION['restrictions'], true ) . "</pre></div>";
      } // else
      return $return;
   }
   
   function buildRestrictions() {
      global $dbConnection;
      $rules = explode( "\n", $_SESSION['user']->restrictions );
      $_SESSION['restrictions'] = array();
      $temp = array();
      $workingOn = '';
      foreach ( $rules as $thisOne ) {
         //print "<pre>Working on $thisOne\n</pre>";
         if ( preg_match( '/\[([^\[\]]+)\]/', $thisOne, $match ) ) {
            //print "Adding as category\n<br />";
            $workingOn = $match[1];
         } else {
            //print "Adding as a value in $workingOn\n<br />";
            $temp[$workingOn][] = "'" . $dbConnection->real_escape_string(trim($thisOne)) . "'";
         }
      } // foreach
      if ( $temp['owner'] ) {
         $values = $dbConnection->columnToArray( sprintf( "select distinct owner_id id from view_device_location_owner_type where owner in (%s)", implode( ',', $temp['owner'] ) ) );
         $_SESSION['restrictions']['owner'] = sprintf( 'owner_id in ( %s )', implode( ',', $values ) );
      }
      if ( $temp['location'] ) {
         $values = $dbConnection->columnToArray( sprintf( "select distinct location_id id from view_device_location_owner_type where location in (%s)", implode( ',', $temp['location'] ) ) );
         $_SESSION['restrictions']['location'] = sprintf( 'location_id in ( %s )', implode( ',', $values ) );
      }
      if ( $temp['device'] ) {
         $values = $dbConnection->columnToArray( sprintf( "select distinct device_id id from view_device_location_owner_type where device in (%s)", implode( ',', $temp['device'] ) ) );
         $_SESSION['restrictions']['device'] = sprintf( 'device_id in ( %s )', implode( ',', $values ) );
      }
   }
         
   function makeHrefList( $data, $target, $template = "<a href='%s%s'>%s</a>", $before = '<table><tr><td>', $after = "</td></tr></table>", $inside = "\n</td></tr><tr><td>" ) {
      $return = array();
      foreach ( $data as $key => $value ) {
         $return[] = sprintf( $template, $target, $key, $value );
      }
      return $before . implode( $inside , $return ) . $after;
   }
      
      
      
   
?>