diff options
| -rw-r--r-- | includes/lookup_contact.php | 45 |
1 files changed, 45 insertions, 0 deletions
diff --git a/includes/lookup_contact.php b/includes/lookup_contact.php new file mode 100644 index 0000000..1be1658 --- /dev/null +++ b/includes/lookup_contact.php @@ -0,0 +1,45 @@ +<?php +/** + * JSON autocomplete endpoint — returns contacts matching ?q= by title or SCREF short name. + * + * @package contact + */ + +namespace Bitweaver\Contact; + +require_once '../../kernel/includes/setup_inc.php'; + +global $gBitDb, $gBitUser; + +if( !$gBitUser->hasPermission( 'p_contact_view' ) ) { + header( 'Content-Type: application/json' ); + echo '[]'; + exit; +} + +$q = trim( $_GET['q'] ?? '' ); +if( strlen( $q ) < 2 ) { + header( 'Content-Type: application/json' ); + echo '[]'; + exit; +} + +$like = '%'.strtolower( $q ).'%'; + +$rows = $gBitDb->getArray( + "SELECT FIRST 30 lc.content_id, lc.title, + (SELECT FIRST 1 sx.data FROM ".BIT_DB_PREFIX."liberty_xref sx + WHERE sx.content_id=lc.content_id AND sx.item='SCREF') AS scref + FROM ".BIT_DB_PREFIX."liberty_content lc + WHERE lc.content_type_guid='contact' + AND (LOWER(lc.title) LIKE ? OR EXISTS ( + SELECT 1 FROM ".BIT_DB_PREFIX."liberty_xref sx + WHERE sx.content_id=lc.content_id AND sx.item='SCREF' AND LOWER(sx.data) LIKE ? + )) + ORDER BY lc.title", + [ $like, $like ] +); + +header( 'Content-Type: application/json' ); +echo json_encode( array_values( $rows ?? [] ) ); +exit; |