MemberLookup

Member Lookup modules take cashier input and search for member accounts. Custom modules could provide additional search methods beyond the default member number / last name options. Custom modules could also provide additional processing or even reroute POS entirely to a different page for additional input.

Methods

• boolean handle_numbers()
  Indicates whether the module handles numeric input. Defaults to true.
• boolean handle_text()
  Indicates whether the module handles text input. Defaults to true.
• array lookup_by_number(integer $num)
  Search by numeric input. See Return Values for details on search result format.
• array lookup_by_text(string $text)
  Search by text input. See Return Values for details on search result format.

Return Values
Search results should return a keyed array. The class method default_value() provides an empty, default return value. The array should have two keys.

• url - string URL or boolean False. Return a string value will redirect POS to that page.
• results - an array of matching memberships to display as a <select> field. Array keys for results should be custdata.CardNo::custdata.personNum. Array values are the labels that will appear on the screen.

Example: find member by phone number

class LookupByPhone extends MemberLookup {

	public function handle_text(){
		return False;
	}

	public function lookup_by_number($num){
		$db = Database::pDataConnect();
		$ret = $this->default_value();

		// need table for lookup
		if (!$db->table_exists('meminfo'))
			return $ret;

		$query = 'SELECT CardNo,personNum,
			LastName,FirstName,phone
			FROM custdata AS c LEFT JOIN
			meminfo AS m ON c.CardNo=m.card_no
			WHERE m.phone='.((int)$num);
		$result = $db->query($query);
		while($row = $db->fetch_row($result)){
			$key = $row['CardNo'].'::'.$row['personNum'];
			$label = $row['LastName'].', '.$row['FirstName']
				.' ('.$row['phone'].')';
			$ret['results'][$key] = $label;
		}
		return $ret;
	}
}