suCuUser.data

<?php

$monLibrary = dirname(__FILE__) . "/../library";
require_once("$monLibrary/cu_top.i");
require_once("$monLibrary/ck_hticket.i");

// define namespaces
$operation = null;
$username  = null;
$cucode    = null;
$search    = null;
$Cu        = null;

dms_import(array("operation" => "string", "cucode" => "string", "username" => "string", "search" => "string"));

$operation = trim($operation);
$cucode = preg_replace("/[^A-Za-z0-9]/","",$cucode);
$username = prep_save($username);
$search = prep_save($search);

switch($operation) {
    case "searchUser":
        if (strlen($cucode) > 0 && strlen($search) > 0) {
            searchUser($dbh, $cucode, $username, $search);
        }
        break;
    default:
        $returnArray = array("error" => array("Operation not found."));
}

header('Content-type: application/json');

function searchUser($dbh, $cucode, $username, $search=null) {
    #
    # retrieve and return a list of cu codes
    #

    $usersearch           = new UserSearch;
    $usersearch->dbh      = $dbh;
    $usersearch->UserName = $username;
    $usersearch->Cu       = $cucode;
    $usersearch->Search   = $search;
    $usersearch->Results  = null;

    // by default, check for exact username match first
    $exact_match = $usersearch->LookUpByUserName($search);

    // old method, gives inconsistent results as some users have account numbers as user name, for example.
    // new method, make no assumptions.$_COOKIE
    $usersearch->SearchByUserAny($search);

    if (empty($exact_match)) { // no exact match, return search
        echo HCU_JsonEncode($usersearch->Results);
    } else { // exact match, merge with search results and return both
        echo HCU_JsonEncode(array_merge($exact_match, $usersearch->Results));
    }
    return array("error" => array(), "code" => 0);
}

class UserSearch {
    public $dbh            = null;
    public $Cu             = null;
    public $cucode         = null;
    public $UserName       = null;
    public $UserEmail      = null;
    public $PrimaryAccount = null;
    public $Search         = null;
    public $Results        = null;

    function LookUpByUserName($p_search) {
        $p_array = array();

        $sql = "select u.user_name, u.email, maa.accountnumber
                from {$this->Cu}user u
                left join (select row_number() over (partition by ua.user_id, ua.accountnumber) as rown, ua.user_id, ua.accountnumber from {$this->Cu}useraccounts ua
                    inner join {$this->Cu}memberacct ma on ua.accountnumber = ma.accountnumber) maa on u.user_id = maa.user_id and maa.rown = 1 where user_name = '$p_search'";
        $p_rs = db_query($sql, $this->dbh);
        while($p_element = db_fetch_assoc($p_rs)) {
            $p_array[] = ['user_name' => str_replace($p_search, "<b>" . $p_search . "</b>", trim($p_element["user_name"])),
                          'email' => str_replace($p_search, "<b>" . $p_search."</b>", trim($p_element["email"])),
                           'accountnumber' => str_replace($p_search, "<b>" . $p_search . "</b>", trim($p_element["accountnumber"])),
                           'search' => trim($p_element["user_name"]) . "|" . trim($p_element["email"]) . "|" . trim($p_element["accountnumber"])];
                       }
        $this->Results = $p_array;
        return $p_array;
    }

    function SearchByUserAny($p_search) {
        $p_array = array();
        $sql = "select u.user_name, u.email, maa.accountnumber
                from {$this->Cu}user u
                left join (select row_number() over (partition by ua.user_id, ua.accountnumber) as rown, ua.user_id, ua.accountnumber from {$this->Cu}useraccounts ua
                    inner join {$this->Cu}memberacct ma on ua.accountnumber = ma.accountnumber) maa on u.user_id = maa.user_id and maa.rown = 1
                where maa.accountnumber like '%$p_search%' or lower(user_name) like lower('%$p_search%') or lower(email) like lower('%$p_search%')";
        $p_rs = db_query($sql, $this->dbh);
        while($p_element = db_fetch_assoc($p_rs)) {
             $p_array[] = ['user_name' => str_replace($p_search, "<b>" . $p_search . "</b>", trim($p_element["user_name"])),
                           'email' => str_replace($p_search, "<b>" . $p_search."</b>", trim($p_element["email"])),
                           'accountnumber' => str_replace($p_search, "<b>" . $p_search."</b>", trim($p_element["accountnumber"])),
                           'search' => trim($p_element["user_name"]) . "|" . trim($p_element["email"]) . "|" . trim($p_element["accountnumber"])];
        }
        $this->Results = $p_array;
        return $p_array;
    }
}

?>