Changeset 901 for trunk/Modules/Document/Document.php

Timestamp:

Feb 17, 2021, 9:27:32 PM (3 years ago)

Author:

chronos

Message:

• Added: Documents section accessible from users panel.
• Added: Contract model moved to separate module Contract.
• Added: New action to generate PDF from Contract.
• Fixed: Allow users to download files only by hash instead of direct id.
• Added: Support for SHA1 as allowed mysql function.

File:

• trunk/Modules/Document/Document.php (modified) (1 diff)

trunk/Modules/Document/Document.php

@@ -80 +80 @@
     ));
   }
+
+  static function Cast(Module $Module): ModuleDocument
+  {
+    if ($Module instanceof ModuleDocument)
+    {
+      return $Module;
+    }
+    throw new Exception('Expected ModuleDocument type but '.gettype($Module));
+  }
+
+  function GetFinanceYear(int $Year): array
+  {
+    if ($Year == 0)
+    {
+      // Get latest year
+      $DbResult = $this->Database->select('FinanceYear', '*', '1 ORDER BY `Year` DESC LIMIT 1');
+    } else $DbResult = $this->Database->select('FinanceYear', '*', '`Year`='.$Year);
+    if ($DbResult->num_rows == 0)
+    {
+            if ($Year == date('Y'))
+            {
+                    $this->CreateFinanceYear($Year);
+        $DbResult = $this->Database->select('FinanceYear', '*', '`Year`='.$Year);
+            } else throw new Exception('Rok '.$Year.' nenalezen');
+          }
+    $FinanceYear = $DbResult->fetch_assoc();
+    if ($FinanceYear['Closed'] == 1)
+      throw new Exception('Rok '.$FinanceYear['Year'].' je již uzavřen. Nelze do něj přidávat položky.');
+    return $FinanceYear;
+  }
+
+  function GetNextDocumentLineNumber(string $Id, int $FinanceYear = 0): string
+  {
+          $FinanceYear = $this->GetFinanceYear($FinanceYear);
+
+    $DbResult = $this->Database->query('SELECT `Shortcut`, `Id` FROM `DocumentLine` WHERE `Id`='.$Id);
+    $DocumentLine = $DbResult->fetch_assoc();
+
+    $DbResult = $this->Database->query('SELECT * FROM `DocumentLineSequence` WHERE '.
+      '`DocumentLine`='.$Id.' AND `FinanceYear`='.$FinanceYear['Id']);
+    $Sequence = $DbResult->fetch_assoc();
+
+    if ($Sequence['YearPrefix'] == 1)
+    {
+      $Result = $DocumentLine['Shortcut'].$Sequence['NextNumber'].'/'.$FinanceYear['Year'];
+    } else $Result = $DocumentLine['Shortcut'].$Sequence['NextNumber'];
+
+    $this->Database->query('UPDATE `DocumentLineSequence` SET `NextNumber` = `NextNumber` + 1 '.
+      'WHERE (`DocumentLine`='.$Id.') AND (`FinanceYear`='.$FinanceYear['Id'].')');
+    return $Result;
+  }
+
+  function GetNextDocumentLineNumberId(string $Id, int $FinanceYear = 0): int
+  {
+    $Code = $this->GetNextDocumentLineNumber($Id, $FinanceYear);
+    $this->Database->insert('DocumentLineCode', array('DocumentLine' => $Id, 'Name' => $Code));
+    return $this->Database->insert_id;
+  }
+
+  function CreateFinanceYear(int $Year)
+  {
+    $StartTime = mktime(0, 0, 0, 1, 1, $Year);
+    $EndTime = mktime(0, 0, 0, 12, 31, $Year);
+    $this->Database->insert('FinanceYear', array('Year' => $Year,
+            'DateStart' => TimeToMysqlDate($StartTime), 'DateEnd' => TimeToMysqlDate($EndTime), 'Closed' => 0));
+          $YearId = $this->Database->insert_id;
+
+    // Create DocumentLineSequence from previous
+    $DbResult = $this->Database->select('DocumentLine', 'Id', '`Yearly` = 1');
+    while ($DbRow = $DbResult->fetch_assoc())
+    {
+            $this->Database->insert('DocumentLineSequence', array('FinanceYear' => $YearId,
+              'NextNumber' => 1, 'YearPrefix' => 1, 'DocumentLine' => $DbRow['Id']));
+          }
+  }
 }