Changeset 976 for trunk/Modules/Document/Document.php
- Timestamp:
- Jun 30, 2025, 3:24:41 PM (13 hours ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/Modules/Document/Document.php
r901 r976 120 120 $DbResult = $this->Database->query('SELECT * FROM `DocumentLineSequence` WHERE '. 121 121 '`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 } 123 131 124 132 if ($Sequence['YearPrefix'] == 1) 125 133 { 126 134 $Result = $DocumentLine['Shortcut'].$Sequence['NextNumber'].'/'.$FinanceYear['Year']; 127 } else $Result = $DocumentLine['Shortcut'].$Sequence['NextNumber']; 135 } else 136 { 137 $Result = $DocumentLine['Shortcut'].$Sequence['NextNumber']; 138 } 128 139 129 140 $this->Database->query('UPDATE `DocumentLineSequence` SET `NextNumber` = `NextNumber` + 1 '.
Note:
See TracChangeset
for help on using the changeset viewer.