Changeset 502 for trunk/Common/Form

Timestamp:

Mar 12, 2013, 10:58:10 PM (12 years ago)

Author:

chronos

Message:

• Přidáno: Akce pro import plateb přes API nebo ze souboru z tabulky "Bankovní účty" ze správy dat.
• Přidáno: Prozatím zkoušení importu z Fio a Poštovní spořitelny.

Location:

trunk/Common/Form

Files:

• Form.php (modified) (1 diff)
• Types/File.php (modified) (5 diffs)
• Types/File/FileDownload.php (modified) (1 diff)
• Types/FileContent.php (deleted)
• Types/OneToMany.php (modified) (1 diff)
• Types/Type.php (modified) (2 diffs)

trunk/Common/Form/Form.php

@@ -83 +83 @@
     if(!array_key_exists($Item['Type'], $this->FormManager->FormTypes) or 
     (array_key_exists($Item['Type'], $this->FormManager->FormTypes) and 
-    ($$this->FormManager->FormTypes[$Item['Type']]['Type'] != 'ManyToOne')))
+    ($this->FormManager->FormTypes[$Item['Type']]['Type'] != 'ManyToOne')))
     {
       if(!array_key_exists($Index, $this->Values) and isset($Item['Default'])) $this->Values[$Index] = $Item['Default']; 

trunk/Common/Form/Types/File.php

@@ -1 +1 @@
 <?php
+
+class DbFile
+{
+  var $Id;
+  var $FileName;
+  var $Size;
+  var $Directory;
+  var $DirectoryId;
+  var $TempName;
+  
+  function DetectMimeType()
+  {
+    // For proper mime-type detection php-pecl-Fileinfo package should be installed on *nix systems
+    $FileInfo = new finfo(FILEINFO_MIME, '/usr/share/misc/magic');
+    $Result = $FileInfo->file($FileName);
+    //$FileInfo->close();
+    return($Result);
+  }
+  
+  function GetSize($Item)
+  {
+    $FileName = $this->GetFullName($Item);
+    if(file_exists($FileName)) $Result = filesize($FileName);
+      else $Result = 0;
+    return($Result); 
+  }
+  
+  function GetFullName()
+  {
+    $ParentId = $this->Directory;
+    while($ParenId != null)
+    {
+      $DbResult = $this->Database->select('FileDirectory', '*', 'Id='.$ParentId);
+      $DbRow = $DbResult->fetch_assoc();
+      $Path .= $DbRow['Name'].'/';
+      $ParentId = $DbRow['Parent'];
+    }     
+    $Result = $this->UploadFileFolder.'/'.$Path.$File->Name;
+    return($Result);
+  }
+  
+  function GetExt()
+  {
+    return(substr($this->Name, 0, strpos($this->Name, '.') - 1));
+  }
+  
+  function Delete()
+  {
+    if(file_exists($this->GetFullName())) unlink($this->GetFullName());
+  }
+  
+  function GetContent()
+  {
+    if($this->TempName != '') $Content = file_get_contents($this->TempName);
+      else $Content = file_get_contents($this->GetFullName());
+    return($Content);
+  }
+}
 
 class TypeFile extends TypeBase
@@ -7 +65 @@
   var $DirectoryId;
   
-  function __construct()
+  function __construct($FormManager)
   {
+    parent::__construct($FormManager);
     $this->FileDownloadURL = 'File.php';
     $this->DirectoryId = null;
@@ -15 +74 @@
   function OnView($Item)
   {
-    global $Database;
-
-    $DbResult = $Database->query('SELECT `Name`, `Size` FROM `SystemFile` WHERE `Id`='.$Item['Value']);
-    if($DbResult->num_rows > 0)
-    {
-      $DbRow = $DbResult->fetch_assoc();
-      return('<a href="'.$this->FileDownloadURL.'?Id='.$Item['Value'].'">'.$DbRow['Name'].'</a> ('.HumanSize($DbRow['Size']).')');
-    } else return('');
+    $File = &$Item['Value'];
+    return('<a href="'.$this->FileDownloadURL.'?Id='.$File->Id.'">'.
+      $File.'</a> ('.HumanSize($File->Size).')');
   }
 
@@ -30 +84 @@
     // ini_set("upload_max_filesize", "100M");
     // <input type="hidden" name="MAX_FILE_SIZE" value="10000000">
-    $Output = '<input type="file" name="'.$Item['Name'].'" value="">';
+    $File = &$Item['Value'];
+    $Output = '<input type="file" name="'.$Item['Name'].'" value="'.$File->Name.'">';
     return($Output);
   }
@@ -36 +91 @@
   function OnLoad($Item)
   {
-    global $Database, $Config;
-
-    $Result = 0;
-    print_r($_FILES);
-    print_r($_POST);
+    if(!is_object($Item['Value'])) $Item['Value'] = new DbFile();
+    $File = &$Item['Value'];
     if(array_key_exists($Item['Name'], $_FILES) and ($_FILES[$Item['Name']]['name'] != ''))
     {
-      if(file_exists($_FILES[$Item['Name']]['tmp_name']))
+      $UploadFile = $_FILES[$Item['Name']];
+      if(file_exists($UploadFile['tmp_name']))
       {
-        $FileName = substr($_FILES[$Item['Name']]['name'], strrpos($_FILES[$Item['Name']]['name'], '/'));
-        $Database->insert('File', array('Name' => $FileName, 'Size' => filesize($_FILES[$Item['Name']]['tmp_name']),
-           'Directory' => $this->DirectoryId));
-        $Result = $Database->insert_id;
-        if(!move_uploaded_file($_FILES[$Item['Name']]['tmp_name'], $this->UploadFileFolder.'/'.$Result)) 
-          SystemMessage('Nahrání souboru', 'Cílová složka není dostupná!');
+        $File->Name = $UploadFile['name'];
+        $File->Size = $UploadFile['size']; 
+        $File->TempName = $UploadFile['tmp_name'];
       }
     }
-    return($Result);
+    return($File);
   }
+  
+  function OnLoadDb($Item)
+  {
+    if(!is_object($Item['Value'])) $Item['Value'] = new DbFile();
+    $File = &$Item['Value'];
+    $DbResult = $this->Database->select('File', '*', 'Id='.$File->Id);
+    if($DbResult->num_rows() > 0)
+    {
+      $DbRow = $DbResult->fetch_assoc();
+      $File->Name = $DbRow['Name'];
+      $File->Size = $DbRow['Size'];
+      $File->Directory = $DbRow['Directory'];
+    }
+    return($File);
+  }
+  
+  function OnSaveDb($Item)
+  {
+    if(!is_object($Item['Value'])) $Item['Value'] = new DbFile();
+    $File = &$Item['Value'];
+    $Properties = array('Name' => $File->Name, 
+      'Size' => $File->GetSize(), 'Directory' => $File->Directory);
+    $DbResult = $this->Database->select('File', '*', 'Id='.$File->Id);
+    if($DbResult->num_rows() > 0)
+    {
+      $DbRow = $DbResult->fetch_assoc();
+      if($File->TempName != '') 
+      {
+        $FileName = $File->GetFullName();
+        unlink($FileName);
+      }
+      $this->Database->update('File', 'Id='.$File->Id, $Properties);
+    } else 
+    {
+      $this->Database->insert('File', $Properties);
+      $File->Id = $this->Database->insert_id;
+    }
+    if(!move_uploaded_file($File->TempName, $FileName))
+      SystemMessage('Nahrání souboru', 'Cílová složka není dostupná!');
+  }
+  
 }
 

trunk/Common/Form/Types/File/FileDownload.php

@@ -1 +1 @@
 <?php
 
-// For proper mime-type detection php-pecl-Fileinfo package should be installed on *nix systems
-function DetectMimeType($FileName)
-{
-  $FileInfo = new finfo(FILEINFO_MIME, '/usr/share/misc/magic');
-  $Result = $FileInfo->file($FileName);
-  //$FileInfo->close();
-  return($Result);
-}
 
 chdir('../..');

trunk/Common/Form/Types/OneToMany.php

@@ -7 +7 @@
   function OnView($Item)
   {
-    $Type = $this->System->Type->TypeDefinitionList[$Item['Type']];
+    $Type = $this->FormManager->Type->TypeDefinitionList[$Item['Type']];
     if($Item['Value'] != '')
     {
       if(array_key_exists('View', $Type['Parameters'])) $Table = $Type['Parameters']['View'];
         else $Table = $Type['Parameters']['Table'];
-      $DbResult = $this->System->Database->query('SELECT '.$Type['Parameters']['Name'].
+      $DbResult = $this->Database->query('SELECT '.$Type['Parameters']['Name'].
         ' AS `Name` FROM '.$Table.' WHERE `'.
         $Type['Parameters']['Id'].'`='.$Item['Value']);

trunk/Common/Form/Types/Type.php

@@ -17 +17 @@
 include(dirname(__FILE__).'/Hidden.php');
 include(dirname(__FILE__).'/File.php');
-include(dirname(__FILE__).'/FileContent.php');
 include(dirname(__FILE__).'/GPS.php');
 include(dirname(__FILE__).'/IPv4Address.php');
@@ -53 +52 @@
       'Color' => array('Name' => 'Color', 'Class' => 'Color', 'ParentType' => '', 'Parameters' => array()),
       'RandomHash' => array('Name' => 'RandomHash', 'Class' => 'RandomHash', 'ParentType' => '', 'Parameters' => array()),
-      'FileContent' => array('Name' => 'FileContent', 'Class' => 'FileContent', 'ParentType' => '', 'Parameters' => array()),
     );
   }