diff options
| author | Lester Caine <lester@lsces.co.uk> | 2026-06-03 20:59:10 +0100 |
|---|---|---|
| committer | Lester Caine <lester@lsces.co.uk> | 2026-06-03 20:59:10 +0100 |
| commit | bd83a2fe21894707ccb49f987dff4d1c0f6121cd (patch) | |
| tree | b9f3884d1ff3893acb06a47bbb0eda77f8d4e933 /includes | |
| parent | e61e527351614a53a4eab3a204c798cb328d281a (diff) | |
| download | stock-bd83a2fe21894707ccb49f987dff4d1c0f6121cd.tar.gz stock-bd83a2fe21894707ccb49f987dff4d1c0f6121cd.tar.bz2 stock-bd83a2fe21894707ccb49f987dff4d1c0f6121cd.zip | |
stock: drop Ref column, sortable Ordered/Received, fix smartlink isort
- Remove redundant ref_key column (shown in Reference already)
- Add ref_start_date sort to getList() match block (subquery-based, avoids
Firebird alias restriction)
- Fix isort values: smartlink appends _asc/_desc itself — passing _desc in
isort was generating ref_start_date_desc_desc
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
Diffstat (limited to 'includes')
| -rw-r--r-- | includes/classes/StockMovement.php | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/includes/classes/StockMovement.php b/includes/classes/StockMovement.php index 9256e03..6ad7011 100644 --- a/includes/classes/StockMovement.php +++ b/includes/classes/StockMovement.php @@ -244,8 +244,10 @@ class StockMovement extends LibertyContent { $sortMode = $pListHash['sort_mode'] ?? ''; $orderby = match( $sortMode ) { - 'event_time_asc' => ' ORDER BY lc.event_time ASC', - 'event_time_desc' => ' ORDER BY lc.event_time DESC', + 'event_time_asc' => ' ORDER BY lc.event_time ASC', + 'event_time_desc' => ' ORDER BY lc.event_time DESC', + 'ref_start_date_asc' => ' ORDER BY (SELECT FIRST 1 x.start_date FROM '.BIT_DB_PREFIX.'liberty_xref x WHERE x.content_id=lc.content_id AND x.item IN (\'REQN\',\'TRANS\',\'ORDER\') ORDER BY x.xorder) ASC', + 'ref_start_date_desc' => ' ORDER BY (SELECT FIRST 1 x.start_date FROM '.BIT_DB_PREFIX.'liberty_xref x WHERE x.content_id=lc.content_id AND x.item IN (\'REQN\',\'TRANS\',\'ORDER\') ORDER BY x.xorder) DESC', default => !empty( $sortMode ) ? ' ORDER BY '.$this->mDb->convertSortmode( $sortMode ) : ' ORDER BY lc.last_modified DESC', |