Ignore:
Timestamp:
Jun 30, 2025, 3:24:41 PM (13 hours 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:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/Modules/Document/Document.php

    r901 r976  
    120120    $DbResult = $this->Database->query('SELECT * FROM `DocumentLineSequence` WHERE '.
    121121      '`DocumentLine`='.$Id.' AND `FinanceYear`='.$FinanceYear['Id']);
    122     $Sequence = $DbResult->fetch_assoc();
     122    if ($DbResult->num_rows > 0)
     123    {
     124      $Sequence = $DbResult->fetch_assoc();
     125    } else
     126    {
     127      $Sequence = array('DocumentLine' => $Id, 'FinanceYear' => $FinanceYear['Id'],
     128        'NextNumber' => 1, 'YearPrefix' => 1);
     129      $Sequence['Id'] = $this->Database->insert('DocumentLineSequence', $Sequence);
     130    }
    123131
    124132    if ($Sequence['YearPrefix'] == 1)
    125133    {
    126134      $Result = $DocumentLine['Shortcut'].$Sequence['NextNumber'].'/'.$FinanceYear['Year'];
    127     } else $Result = $DocumentLine['Shortcut'].$Sequence['NextNumber'];
     135    } else
     136    {
     137      $Result = $DocumentLine['Shortcut'].$Sequence['NextNumber'];
     138    }
    128139
    129140    $this->Database->query('UPDATE `DocumentLineSequence` SET `NextNumber` = `NextNumber` + 1 '.
Note: See TracChangeset for help on using the changeset viewer.