<?php

/**
 *
 */
class HomeClass extends ViewData
{

  public function LoadUsersAutoComplete($Keyword)
  {
    $name_table = "t_system_users";
    $start_count = 0;
    $max_rows = 10;
    $count='';
    //$count = "distinct T2.NamesId as custId,T2.NamesName as custName, T2.NamesCode as custCode,T2.PostalAddress as address,T2.TaxID as taxId";
    $search = "Id Like '%".$Keyword."%' || UserName Like '%".$Keyword."%' || Name Like '%".$Keyword."%' || Surname Like '%".$Keyword."%'";
    $count ='';
    $sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search, 'limit'=> "$start_count,$max_rows");
    $view = $this->view($sql);
    $result = $this->q_re($view);
    $numrows = $this->q_nr($result);
    $i=0;$data=array();
    if($numrows>0){
      while ($row = $this->q_ro($result)) {
        $data[$i]['Id'] =$row['Id'];
        $data[$i]['UserName'] =$row['UserName'];
        $data[$i]['EmailAddress'] =$row['EmailAddress'];
        $data[$i]['Title'] =$row['Title'];
        $data[$i]['Name'] =$row['Name'];
        $data[$i]['MiddleName'] =$row['MiddleName'];
        $data[$i]['Surname'] =$row['Surname'];
        $data[$i]['IsDeleted'] =$row['IsDeleted'];
        $data[$i]['StatusActive'] =$row['StatusActive'];
        $data[$i]['CreationTime'] =$row['CreationTime'];
        $data[$i]['CreatorUserId'] =$row['CreatorUserId'];
        $data[$i]['LastUpdateDateTime'] =$row['LastUpdateDateTime'];
        $data[$i]['LastUpdateBy'] =$row['LastUpdateBy'];

        $i++;
      }

    }else{
      $data['Data'] = '';
    }
    //$data['view'] = $view;
    return $data;
  }
  public function LoadUsersAutoCompleteId($Keyword)
  {
    $name_table = "t_system_users";
    $start_count = 0;
    $max_rows = 10;
    $count='';
    //$count = "distinct T2.NamesId as custId,T2.NamesName as custName, T2.NamesCode as custCode,T2.PostalAddress as address,T2.TaxID as taxId";
    $search = "Id = '".$Keyword."'";
    $count ='';
    $sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search, 'limit'=> "$start_count,$max_rows");
    $view = $this->view($sql);
    $result = $this->q_re($view);
    $numrows = $this->q_nr($result);
    $i=0;$data=array();
    if($numrows>0){
      while ($row = $this->q_ro($result)) {
        $data[$i]['Id'] =$row['Id'];
        $data[$i]['UserName'] =$row['UserName'];
        $data[$i]['EmailAddress'] =$row['EmailAddress'];
        $data[$i]['Title'] =$row['Title'];
        $data[$i]['Name'] =$row['Name'];
        $data[$i]['MiddleName'] =$row['MiddleName'];
        $data[$i]['Surname'] =$row['Surname'];
        $data[$i]['IsDeleted'] =$row['IsDeleted'];
        $data[$i]['StatusActive'] =$row['StatusActive'];
        $data[$i]['CreationTime'] =$row['CreationTime'];
        $data[$i]['CreatorUserId'] =$row['CreatorUserId'];
        $data[$i]['LastUpdateDateTime'] =$row['LastUpdateDateTime'];
        $data[$i]['LastUpdateBy'] =$row['LastUpdateBy'];

        $data[$i]['namefull'] =$row['Name']." ".$row['Surname'];

        $i++;
      }

    }else{
      $data['Data'] = '';
    }
    //$data['view'] = $view;
    return $data;
  }


}


 ?>