WebSVN – computer_asset_manager_v1 – Diff – /modules/file/functions.php

 <?php
    include_once("library.php");
    include_once('reports.php');
    include_once( './database.php' );
+   function logIt ( $message ) {
+      //return;
+      $LOGFILE = '/home/rodolico/www/web/computer_asset_manager_v1/logs/debug.log';
+      $fp = fopen( $LOGFILE , 'a');
+      fwrite($fp, "$message\n" );
+      fclose($fp);
+   }
    /*
     * function designed to handle input from a form. If the input is
     * unset, will retrun the $default value.
     * Otherwise, will filter the value based on $filter
     * First, it will pass it through get_magic_quotes_gpc,
     * then will run through mysql_real_escape_string
+    *
     * For strings, will encapsulate in quotes
     * Dates will attempt a conversion, then change to YYYY-MM-DD and encapsulate in quotes
+    *    if default is the constant now(), will pass that through to MySQL
     * DateTime will perform the same, but change to YYYY-MM-DD HH:MM:SS
     * Integer and Floats are passed through builtins intval and floatval
     * Boolean only checks the first character, a '0', 'f' and 'n' denoting false
     *    all else denoting true. The result is converted based on the variable
     *    $falsetrue, with the first char denoting false and the second denoting true
                   $value = mysql_real_escape_string( $value );
                   $value = strlen( $value ) > 0 ? "'$value'" : $default;
                   break;
          case 'date' :
          case 'd' :
-                  if ( $value != 'null' ) {
+                  if ( $value != 'null' && $value != 'now()' ) {
                      $result = strtotime( $value );
                      $value = ( $result === false ) ? $default : "'" . Date( 'Y-m-d', $result) . "'";
+                  }
                   break;
          case 'datetime':
          case 'timestamp':
          case 'dt':
-                  if ( $value != 'null' ) {
+                  if ( $value != 'null' && $value != 'now()' ) {
                      $result = strtotime( $value );
                      $value = ( $result === false ) ? $default : "'" . Date( 'Y-m-d H:i:s', $result) . "'";
+                  }
                   break;
          case 'integer':
+      }
       return $string;
+   }
    function makeFileName ( $name, $device_id, $client_id, $site_id ) {
       // we are getting an index. There is a small chance we could end up with duplicates, but since the file
       // name will not consist solely of the index, it should not cause a collision.
       $thisIndex = getOneDBValue( "select theValue from _system where group_name= 'Files' and key_name = 'last index'" );
       $thisIndex++;
       doSQL( "update _system set theValue = '$thisIndex' where group_name= 'Files' and key_name = 'last index'" );
          $nameOnDisk .= 'c-';
          $nameOnDisk .= getOneDBValue( "select name from client where client_id = $client_id" );
       } else {
          return array( 'valid' => false, 'message' => 'Error: not able to find client/site/device info' );
+      }
+      logIt( "File name set to $nameOnDisk before processing" );
       // add the extension
       $nameOnDisk .= '.' . pathinfo($name, PATHINFO_EXTENSION);
+      logIt( "File name set to $nameOnDisk after adding extension" );
       // and calculate the relative path to be added to the Files root path value
       $nameOnDisk = getRelativePath( $nameOnDisk ) . $nameOnDisk;
+      logIt( "File name set to $nameOnDisk after adding rel path" );
       return array( 'valid' => true, 'filename' => $nameOnDisk );
    } // function saveFile
    /*
          return getOneDBValue( "select file_mime_type_id from file_mime_type where extension = $value" );
+      }
       return null;
+   }
+   function addFile ( $fields ) {
-   function addFile ( $nameOnDisk, $device_id, $client_id, $site_id, $mime_type, $name, $description ) {
+      logIt( "entering addFile with fields set to\n" . print_r( $fields, true ) );
+      // file_id is not set in any query, so get rid of it
+      $file_id = $fields['file_id'];
+      unset( $fields['file_id'] );
+      // based on device, site or client, two fields are created
-      if ( $device_id ) {
+      if ( $fields['device_id'] ) {
-         $owner_type = 'd';
+         $fields['owner_type'] = 'd';
-         $owner_id = $device_id;
+         $fields['owner_id'] = $fields['device_id'];
-      } elseif ( $site_id ) {
+      } elseif ( $fields['site_id'] ) {
-         $owner_type = 's';
+         $fields['owner_type'] = 's';
-         $owner_id = $site_id;
+         $fields['owner_id'] = $fields['site_id'];
-      } elseif ( $client_id ) {
+      } elseif ( $fields['client_id'] ) {
-         $owner_type = 'c';
+         $fields['owner_type'] = 'c';
-         $owner_id = $client_id;
+         $fields['owner_id'] = $fields['client_id'];
+      }
+      // these are not actually part of the database, so trash them
+      unset( $fields['client_id'] );
+      unset( $fields['site_id'] );
+      unset( $fields['device_id'] );
-      if ( ! isset( $mime_type ) ) {
+      if ( ! isset( $fields['mime_type'] ) ) {
-         $extension = pathinfo( $nameOnDisk, PATHINFO_EXTENSION);
+         $extension = pathinfo( $fields['name_on_disk'], PATHINFO_EXTENSION);
-         $mime_type = getOneDBValue( "select mime_type from file_mime_type where extension = '$extension'" );
+         $fields['mime_type'] = getOneDBValue( "select mime_type from file_mime_type where extension = '$extension'" );
       } // if we need to find the mime_type
-      $nameOnDisk = makeSafeSQLConstant( $nameOnDisk );
+      foreach ( $fields as $key => $value ) {
-      $description = makeSafeSQLConstant( $description );
+         if ( strpos( $key, 'date' ) ) { // field name has date in it
-      $mime_type = makeSafeSQLConstant( $mime_type );
+            $fields[$key] = makeSafeSQLConstant( $value, 'd' );
-      $owner_type = makeSafeSQLConstant( $owner_type );
+         } else {
-      $name = makeSafeSQLConstant( $name );
+            $fields[$key] = makeSafeSQLConstant( $value );
+         }
+      }
-      $file_mime_type_id = getOneDBValue( "select file_mime_type_id from file_mime_type where mime_type = $mime_type" );
+      $fields['file_mime_type_id'] = getOneDBValue( "select file_mime_type_id from file_mime_type where mime_type = $fields[mime_type]" );
+      unset( $fields['mime_type'] );
-      if ( ! $file_mime_type_id ) $file_mime_type_id = 'null';
+      if ( ! $fields['file_mime_type_id'] ) $fields['file_mime_type_id'] = 'null';
+      if ( $file_id  ) { // we are updating an existing record
+         $query = array();
+         foreach ( $fields as $key => $value ) {
+            $query[] = "$key = $value";
+         }
-      $query = "insert into file ( name,owner_type,owner_id,description, file_mime_type_id, name_on_disk, added_date )
+         $query = 'update file set ' . implode( ',', $query ) . " where file_id = $file_id";
+      } else { // we are adding a new record
-                              values ( $name, $owner_type, $owner_id, $description, $file_mime_type_id, $nameOnDisk, now() )";
+         $query = 'insert into file (' . implode( ',', array_keys( $fields ) ) . ') values (' . implode( ',', array_values( $fields ) ) . ')';
+      }
+      logIt( $query );
       $result = queryDatabaseExtended( $query );
+      if ( $result['insert_id'] )
-      return isset( $result['insert_id'] ) ? $result['insert_id'] : null;
+         return array( 'valid' => true, 'message' => "New Record $result[insert_id]" );
+      else
+         return array( 'valid' => false, 'message' => "Database Error" );
+   }
+   function return_bytes($val) {
+       $val = trim($val);
+       $last = strtolower($val[strlen($val)-1]);
+       switch($last)
+       {
+           case 'g':
+           $val *= 1024;
+           case 'm':
+           $val *= 1024;
+           case 'k':
+           $val *= 1024;
+       }
+       return $val;
+   } // return_bytes
+   function prettyPrintBytes( $value ) {
+      $sizes = array( '', 'kilo', 'mega', 'giga', 'tera' );
+      while ( $value > 1024 ) {
+         $value /= 1024;
+         $index++;
+      }
+      return intval( $value ) . ' ' . $sizes[$index] . 'bytes';
+   }
+   function maxUploadFileSize () {
+       //select maximum upload size
+       $max_upload = return_bytes(ini_get('upload_max_filesize'));
+       //select post limit
+       $max_post = return_bytes(ini_get('post_max_size'));
+       //select memory limit
+       $memory_limit = return_bytes(ini_get('memory_limit'));
+       // return the smallest of them, this defines the real limit
+       return prettyPrintBytes( min($max_upload, $max_post, $memory_limit) );
+    } // maxUploadFileSize
+    function getFileUploadError( $error ) {
+       $message = '';
+       switch ( $error ) {
+          case 0 : $message = 'There is no error, the file uploaded with success';
+                   break;
+          case 1 : $message = 'The uploaded file exceeds the upload_max_filesize directive in php.ini';
+                   break;
+          case 2 : $message = 'The uploaded file exceeds the MAX_FILE_SIZE directive that was specified in the HTML form';
+                   break;
+          case 3 : $message = 'The uploaded file was only partially uploaded';
+                   break;
+          case 4 : $message = 'No file was uploaded';
+                   break;
+          case 6 : $message = 'Missing a temporary folder';
+                   break;
+          case 7 : $message = 'Failed to write file to disk.';
+                   break;
+          case 8 : $message = 'A PHP extension stopped the file upload.';
+       }
+       return array( 'valid' => $error == 0, 'message' => $message );
+    } // getFileUploadError
+   function uploadFile ( $source, $nameOnDisk ) {
+      $saveTo = getAbsolutePath( $nameOnDisk );
+      if ( makePath( $saveTo ) ) {
+         logIt( "Path Made - $saveTo" );
+         logIt( "moving $source to $saveTo" );
+         $result['valid'] = move_uploaded_file( $source, $saveTo );
+      } else {
+         $result = array( 'valid'=>false, 'message' => print_r(error_get_last(), true) );
+      } // if move_uploaded_file .. else
+      return $result;
+   } // uploadFile
 ?>

Subversion Repositories computer_asset_manager_v1

(root)/modules/file/functions.php – Rev 59 → 63