WebSVN – computer_asset_manager_v1 – Diff – //modules/file/upload_file.html

 <?php
    include_once( '../../header.php' );
    include_once( './functions.php' );
+   $expectedValues = array( 'file_id','device_id','site_id','client_id','file_mime_type_id','added_date', 'removed_date', 'name', 'description', 'name_on_disk' );
+   foreach ( $expectedValues as $field )
+      $oldValues[$field] = '';
+   $oldValues['added_date'] = date('Y-m-d', time() );
+   // next three lines are useless code. Picks up referrer even if we choose the menu option
+   // maybe add a parameter to the menu option to work around it, later.
-   $result = '';
+   $returnTo = '';
+   if ( isset( $_REQUEST['referer'] ) ) // we came from somewhere else, just to edit one record
+      $returnTo = $_REQUEST['referer'];
+   $mode = 'Edit';
+   $result = array();
-   $debug = '';
+   $debug = array();
+   logIt( "Beginning a run\n========================\n" );
    if ( isset( $_REQUEST['uploadfile'] ) ) {
       // clean up the input first
-      $client_id = cleanInput( $_REQUEST['client_id'] );
+      foreach ( $expectedValues as $field )
-      $site_id = cleanInput( $_REQUEST['site_id'] );
+         $fields[$field] = cleanInput( $_REQUEST[$field], $field == 'name' ? $_FILES['fileToUpload']['name'] : '' );
-      $device_id = cleanInput( $_REQUEST['device_id'] );
+      $mode = $fields['file_id'] ? 'Replace' : 'Add';
-      $name = cleanInput( $_REQUEST['name'], $_FILES['fileToUpload']['name'] );
+      logIt( "Mode set to $mode" );
-      $description = cleanInput( $_REQUEST['description'] );
+      if ( isset( $_FILES['fileToUpload']['error'] ) ) {
-      $mime_type_id = $_REQUEST['mime_type'];
+         $result = getFileUploadError( $_FILES['fileToUpload']['error'] );
-      // mime_type_id can be passed in, calculated from the 'type' of $_FILES, or looked up by extension
+         logIt( 'File Upload Status:<br>' . print_r( getFileUploadError( $_FILES['fileToUpload']['error'] ), true ) );
-      if ( $mime_type_id == 0 ) { // we need to calculate the mime type (auto mode)
+         if ( $_FILES['fileToUpload']['error'] == UPLOAD_ERR_NO_FILE ) {
-         // see if $_FILES has the info
-         $mime_type_id = check_mime_type( $_FILES['fileToUpload']['type'] );
+            $result = array( 'valid' => true, 'message' => "Entering Edit Mode" );
-         if ( $mime_type_id === null ) { // no, so see if we can figure it out from the file name
+            logIt( "Changing to Edit mode since they didn't upload a file" );
-            $mime_type_id = check_mime_type( pathinfo($_FILES['fileToUpload']['name'], PATHINFO_EXTENSION) );
+            $mode = 'Edit';
+         }
+      }
-      $debug = "client_id   =[$client_id]<br />
+      if ( $result['valid'] && $mode == 'Replace' ) {
-                site_id     =[$site_id]<br />
+         logIt( "Replace mode, removing record $fields[file_id]" );
-                device_id   =[$device_id]<br />
+         // we are overwriting a record, so just mark the previous one removed
-                name        =[$name]<br />
+         doSQL( "update file set removed_date = now() where file_id = $fields[file_id]" );
-                mime_type_id=[$mime_type_id]<br />
+         $fields['file_id'] = '';
-                description =[$description]<br />";
+         $mode = 'Add';
-      /*
+      }
-       * this documentation will use the following example
+      if ( $result['valid'] && $mode == 'Add' ) { // we are adding a file, so we upload it
-       * A file, joe.csv, is uploaded and attached to the client
+         logIt( "Actually uploading file" );
-       * Walder IP Law. makeFileName discovers it to be file number
+         // file_mime_type_id can be passed in, calculated from the 'type' of $_FILES, or looked up by extension
-       * 123456 (based on an internal counter)
+         if ( $fields['file_mime_type_id'] == 0 ) { // we need to calculate the mime type (auto mode)
-       * All comments below show what is returned
+            // see if $_FILES has the info
-       */
-      $result = makeFileName(
-            $_FILES['fileToUpload']['name'],
+            $fields['file_mime_type_id'] = check_mime_type( $_FILES['fileToUpload']['type'] );
-            $device_id,
+            if ( $fields['file_mime_type_id'] === null ) { // no, so see if we can figure it out from the file name
-            $client_id,
+               $fields['file_mime_type_id'] = check_mime_type( pathinfo($_FILES['fileToUpload']['name'], PATHINFO_EXTENSION) );
-            $site_id
+            }
-            );
+         }
-      // at this point, we have 12/34/123456-c-Walder IP Law.csv
+         logIt( 'Field List: ' . print_r( $fields, true ) );
-      if ( $result['valid'] ) {
+         /*
-         $nameOnDisk = $result['filename'];
+          * this documentation will use the following example
-         $saveTo = getAbsolutePath( $nameOnDisk );
+          * A file, joe.csv, is uploaded and attached to the client
-         // $saveT now has document root, etc... prepended, so
+          * Walder IP Law. makeFileName discovers it to be file number
-         // /var/www/computer_asset_management/modules/files/file_storage/12/34/123456-c-Walder IP Law.csv
-         if ( makePath( $saveTo ) ) {
+          * 123456 (based on an internal counter)
-            $result = "Path Made - $saveTo";
+          * All comments below show what is returned
-            if ( ( move_uploaded_file( $_FILES["fileToUpload"]["tmp_name"], $saveTo ) ) ) {
+          */
-               $result = addfile(
+         $result = makeFileName(
-                              $nameOnDisk,
+                  $_FILES['fileToUpload']['name'],
-                              $device_id,
+                  $fields['device_id'],
-                              $client_id,
+                  $fields['client_id'],
-                              $site_id,
+                  $fields['site_id']
-                              isset( $_REQUEST['mime_type'] ) ? $_REQUEST['mime_type'] : $_FILES["fileToUpload"]['type'],
-                              $name,
+                  );
-                              $description
+         // at this point, we have 12/34/123456-c-Walder IP Law.csv
-                           );
+         if ( $result['valid'] ) {
-               $result = $result === null ? "Could not add file<br />$nameOnDisk<br />to database" : 'Success';
+            logIt( 'preparing to upload file, result = ' . print_r( $result, true ) );
-            } else {
+            $fields['name_on_disk'] = $result['filename'];
-               $result = "Failed to upload to disk<br />$saveTo";
+            $result = uploadFile( $_FILES["fileToUpload"]["tmp_name"], $fields['name_on_disk'] );
-            } // if move_uploaded_file .. else
+            logIt( "After upload, result is " . print_r( $result, true ) );
          } else {
-            $result = "failed to make path<br />$saveTo";
+            $result = array( 'valid' => false, 'message' => "failed to make path<br />$saveTo" );
+         }
-      } else {
+      }
+      logIt( "Just before adding file, result =\n" . print_r( $result, true ) );
+      if ( $result['valid'] ) {
-         $result = $result['message'];
+         $result = addfile( $fields );
+      }
+      /*
+      if ( $returnTo )
+         header( "Location: $returnTo" );
+      */
+   } elseif ( $_REQUEST['file_id'] ) { // if isset uploadfile
+      $oldValues = queryDatabaseExtended( "select * from file where file_id = $_REQUEST[file_id]" );
+      if ( $oldValues ) {
+         $oldValues = $oldValues['data'][0];
+         switch ( $oldValues['owner_type'] ) {
+            case 'd' : $oldValues['device_id'] = $oldValues['owner_id'];
+                       break;
+            case 'c' : $oldValues['client_id'] = $oldValues['owner_id'];
-      } // if nameOnDisk .. else
+                       break;
+            case 's' : $oldValues['site_id'] = $oldValues['owner_id'];
-   } // if isset uploadfile
+                       break;
+         }
+      }
+   }
 ?>
 <?xml version="1.0" encoding="utf-8"?>
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml">
 <head>
 </head>
 <body>
 <?php include_once('../../menu.php'); ?>
 <div id="content">
    <?php
-      if ( isset( $result ) ) print "<h3>$result</h3>";
+      if ( $result ) print '<h3>' . $result['valid'] ? "Success" : "Error" . $result['message'] . '</h3>';
-      //if ( isset( $debug ) ) print "<h3>$debug</h3>";
+      //if ( isset( $debug ) ) print "<h3>" . implode( '<br />', $debug ) . "</h3>";
     ?>
+    <h4>Upload a File</h4>
+    <p>Max size: <?php print maxUploadFileSize(); ?></p>
    <p>Choose only <b>one</b> of device, site or client to add the file to</p>
   <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" enctype="multipart/form-data">
+    <input type='hidden' name='referer' value='<?php print $_SERVER['HTTP_REFERER']; ?>' />
-    <input type="hidden" name="MAX_FILE_SIZE" value="100000" />
+    <input type='hidden' name='file_id' value='<?php print $oldValues['file_id']; ?>' />
     <table>
        <tr>
           <td>
              Attach To Device
           </td>
           <td>
              <select name='device_id' >
                 <option value='0'>------------</option>
-                <?php print queryToSelect('select device_id, Device from view_current_client_systems order by Device' ); ?>
+                <?php print queryToSelect('select device_id, Device from view_current_client_systems order by Device', $oldValues['device_id'] ); ?>
              </select>
           </td>
        </tr>
        <tr>
           <td>
              Attach To Site
           </td>
           <td>
              <select name='site_id' >
                 <option value='0'>------------</option>
-                <?php print queryToSelect('select site_id, name from view_current_client_site order by name' ); ?>
+                <?php print queryToSelect('select site_id, name from view_current_client_site order by name', $oldValues['site_id'] ); ?>
              </select>
           </td>
        </tr>
        <tr>
           <td>
              Attach To Client
           </td>
           <td>
              <select name='client_id' >
                 <option value='0'>------------</option>
-                <?php print queryToSelect('select client_id, name from view_current_client order by name' ); ?>
+                <?php print queryToSelect('select client_id, name from view_current_client order by name', $oldValues['client_id'] ); ?>
              </select>
           </td>
        </tr>
        <tr>
           <td>
              Mime Type
           </td>
           <td>
-             <select name='mime_type_id' >
+             <select name='file_mime_type_id' >
                 <option value='0'>Autodetect</option>
-                <?php print queryToSelect("select file_mime_type_id, concat( extension, ' (', mime_type, ')') from file_mime_type order by extension" ); ?>
+                <?php print queryToSelect("select file_mime_type_id, concat( extension, ' (', mime_type, ')') from file_mime_type order by extension", $oldValues['file_mime_type_id'] ); ?>
              </select>
           </td>
        </tr>
        <tr>
           <td>
+             File Date
+          </td>
+          <td>
+             <input type='text' name='added_date' width='20' value='<?php print $oldValues['added_date']; ?>' >
+          </td>
+       </tr>
+       <tr>
+          <td>
+             Removed Date
+          </td>
+          <td>
+             <input type='text' name='removed_date' width='20' value='<?php print $oldValues['removed_date']; ?>' >
+          </td>
+       </tr>
+       <tr>
+          <td>
-             file Name
+             File Name
           </td>
           <td>
-             <input type="text" name="name" size="30" maxlength="64" />
+             <input type="text" name="name" size="30" maxlength="64" value='<?php print $oldValues['name']; ?>' />
           </td>
        </tr>
        <tr>
           <td valign='top'>
              Description
           </td>
           <td>
-             <textarea name="description" cols='50' rows='5'></textarea>
+             <textarea name="description" cols='50' rows='5'><?php print $oldValues['description']; ?></textarea>
           </td>
        </tr>
        <tr>
           <td>
              Choose File

Subversion Repositories computer_asset_manager_v1

(root)//modules/file/upload_file.html – Rev 60 → 63