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

Timestamp:

Jun 30, 2025, 3:24:41 PM (3 weeks ago)

Author:

chronos

Message:

• Fixed: Autocreate missing DocumentSequenceNumber records for new years.
• Fixed: Wrong page index selection.
• Fixed: RSS feed formatting variable reference.
• Fixed: Do not parse RouterOS signal import if not connected to the remote host.

File:

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

trunk/Modules/Document/Document.php

@@ -120 +120 @@
     $DbResult = $this->Database->query('SELECT * FROM `DocumentLineSequence` WHERE '.
       '`DocumentLine`='.$Id.' AND `FinanceYear`='.$FinanceYear['Id']);
-    $Sequence = $DbResult->fetch_assoc();
+    if ($DbResult->num_rows > 0)
+    {
+      $Sequence = $DbResult->fetch_assoc();
+    } else 
+    {
+      $Sequence = array('DocumentLine' => $Id, 'FinanceYear' => $FinanceYear['Id'], 
+        'NextNumber' => 1, 'YearPrefix' => 1);
+      $Sequence['Id'] = $this->Database->insert('DocumentLineSequence', $Sequence);
+    }
 
     if ($Sequence['YearPrefix'] == 1)
     {
       $Result = $DocumentLine['Shortcut'].$Sequence['NextNumber'].'/'.$FinanceYear['Year'];
-    } else $Result = $DocumentLine['Shortcut'].$Sequence['NextNumber'];
+    } else
+    {
+      $Result = $DocumentLine['Shortcut'].$Sequence['NextNumber'];
+    }
 
     $this->Database->query('UPDATE `DocumentLineSequence` SET `NextNumber` = `NextNumber` + 1 '.