diff options
| author | Lester Caine <lsces@lsces.co.uk> | 2011-03-10 15:35:55 +0000 |
|---|---|---|
| committer | Lester Caine <lsces@lsces.co.uk> | 2011-03-10 15:35:55 +0000 |
| commit | aa9f4bd0cf158b1eebe6031ce0939ae11f85e9ff (patch) | |
| tree | d42871857e540ca25bd20e84ed22bafd205aff05 /ContactXref.php | |
| parent | b595f3d931e2610415f799215ac7f3d68fa568f5 (diff) | |
| download | contact-aa9f4bd0cf158b1eebe6031ce0939ae11f85e9ff.tar.gz contact-aa9f4bd0cf158b1eebe6031ce0939ae11f85e9ff.tar.bz2 contact-aa9f4bd0cf158b1eebe6031ce0939ae11f85e9ff.zip | |
Add xref type specific templates in parallal with the xref generic view and edit functions
Template field has been added to CONTACT_XREF_SOURCE table.
Diffstat (limited to 'ContactXref.php')
| -rw-r--r-- | ContactXref.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/ContactXref.php b/ContactXref.php index cb6164d..e5f76e8 100644 --- a/ContactXref.php +++ b/ContactXref.php @@ -48,7 +48,8 @@ class ContactXref extends BitBase { ELSE s.`cross_ref_title` || '-' || x.`xorder` END AS source_title, s.`source`, s.`xref_type`, CASE WHEN x.`start_date` IS NULL THEN 'y' ELSE 'n' END AS `ignore_start_date`, - CASE WHEN x.`end_date` IS NULL THEN 'y' ELSE 'n' END AS `ignore_end_date` + CASE WHEN x.`end_date` IS NULL THEN 'y' ELSE 'n' END AS `ignore_end_date`, + s.`cross_ref_title` AS `template_title`, s.`template` FROM `".BIT_DB_PREFIX."contact_xref` x JOIN `".BIT_DB_PREFIX."contact_xref_source` s ON s.`source` = x.`source` WHERE x.`xref_id` = ? |