Changeset 12875

Timestamp:

Sep 13, 2009, 2:08:45 AM (13 years ago)

Author:

urabe

Message:

#3309 Added file upload monitoring for backend

Location:

OpenPNE3/trunk

Files:

• apps/pc_backend/modules/monitoringFunction/actions/actions.class.php (modified) (5 diffs)
• data/fixtures/010_import_backend_monitoring_function_navi.yml (modified) (1 diff)
• lib/model/doctrine/FileTable.class.php (modified) (3 diffs)

OpenPNE3/trunk/apps/pc_backend/modules/monitoringFunction/actions/actions.class.php

@@ -37 +37 @@
     $params = $request->getParameter('page', 1);
     $this->pager = Doctrine::getTable('File')
-      ->getImageFiles($params);
+      ->getImageFilePager($params);
   }
 
+
  /**
-  * Executes adminUser action
+  * Executes fileDelete action
   *
   * @param sfRequest $request A request object
@@ -47 +48 @@
   public function executeDelete(sfWebRequest $request)
   {
-    $this->image = Doctrine::getTable('File')->find($request->getParameter('id'));
+    $this->image = Doctrine::getTable('File')
+      ->find($request->getParameter('id'));
     $this->forward404Unless($this->image);
 
@@ -55 +57 @@
       (
         'notice',
-        sfContext::getInstance()->getI18N()->__('画像の削除が完了しました')
+        sfContext::getInstance()->getI18N()
+          ->__('画像の削除が完了しました')
       );
       $this->redirect('monitoringFunction/list');
     }
   }
+
  /**
-  * Executes deleteUser action
+  * Executes editImage action
   *
   * @param sfRequest $request A request object
@@ -71 +75 @@
     if ($request->isMethod(sfWebRequest::POST))
     {
-        $this->form->bindAndSave(
+        $this->form->bindAndSave
+        (
           $request->getParameter('image'),
           $request->getFiles('image')
@@ -78 +83 @@
         (
           'notice',
-          sfContext::getInstance()->getI18N()->__('画像の追加が完了しました')
+          sfContext::getInstance()->getI18N()
+            ->__('画像の追加が完了しました')
         );
         $this->redirect('monitoringFunction/list');
     }
   }
+
+ /**
+  * Executes fileList action
+  *
+  * @param sfRequest $request A request object
+  */
+  public function executeFileList(sfWebRequest $request)
+  {
+    $params = $request->getParameter('page', 1);
+    $this->pager = Doctrine::getTable('File')
+      ->getFilePager($params);
+  }
+
+ /**
+  * Executes fileDelete action
+  *
+  * @param sfRequest $request A request object
+  */
+  public function executeDeleteFile(sfWebRequest $request)
+  {
+    $this->file = Doctrine::getTable('File')
+      ->find($request->getParameter('id'));
+
+    if ($request->isMethod(sfWebRequest::POST)) {
+      $this->file->delete();
+      $this->getUser()->setFlash
+      (
+        'notice',
+        sfContext::getInstance()->getI18N()
+          ->__('ファイルの削除が完了しました')
+      );
+      $this->redirect('monitoringFunction/fileList');
+    }
+  }
+
+ /**
+  * Executes downloadFile action
+  *
+  * @param sfRequest $request A request object
+  */
+  public function executeDownloadFile(sfWebRequest $request)
+  {
+    $this->file = Doctrine::getTable('File')
+      ->find($request->getParameter('id'));
+    $this->fileBin = Doctrine::getTable('FileBin')
+      ->find($request->getParameter('id'));
+    $original_filename = $this->file->getOriginalFilename();
+    if (strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE') !== false) {
+      $original_filename = mb_convert_encoding($original_filename, 'SJIS', 'UTF-8');
+    }
+    $original_filename = str_replace(array("\r", "\n"), '', $original_filename);
+
+    header('Content-Disposition: attachment; filename="' . $original_filename . '"');
+    header('Content-Length: '. strlen($this->fileBin->getBin()));
+    header('Content-Type: application/octet-stream');
+    echo $this->fileBin->getBin();
+    exit;
+  }
 }

OpenPNE3/trunk/data/fixtures/010_import_backend_monitoring_function_navi.yml

@@ -15 +15 @@
       ja_JP:
         caption: "画像アップロード・削除"
+
+  backend_monitoring_function_navi_file_list:
+    type: "monitoring_function_submenu"
+    uri:  "monitoringFunction/fileList"
+    sort_order: 30
+    Translation:
+      ja_JP:
+        caption: "ファイルアップロードリスト"

OpenPNE3/trunk/lib/model/doctrine/FileTable.class.php

@@ -18 +18 @@
   }
 
-  public function getImageFiles($page = 1, $size = 20)
+  public function getFilePager($page = 1, $size = 20)
   {
-    $q = $this->getImageOrderdQuery();
+    $q = $this->getImageOrderdQuery()
+      ->where('type NOT LIKE ?', 'image%');
     return $this->getPager($q, $page, $size);
   }
@@ -26 +27 @@
   public function getImageFilePager($page = 1, $size = 20)
   {
-    $q = $this->getImageOrderdQuery();
+    $q = $this->getImageOrderdQuery()
+      ->where('type LIKE ?', 'image%');
     return $this->getPager($q, $page, $size);
   }
@@ -42 +44 @@
   protected function getImageOrderdQuery()
   {
-    return $this->createQuery()->where('type LIKE ?', 'image%')->orderBy('id DESC');
+    return $this->createQuery()->orderBy('id DESC');
   }
 }