<?php

/**
 *
 */
class ManageUserClass extends ViewData
{

  public function Index($request)
  {
    $Sorting = (@$request['Sorting']=='')?"CreatedAt":@$request['Sorting'];
    $Email = @$request['Email'];
    $Name = @$request['Name'];

    $name_table = "t_system_users";
    $count = "";
    $search = "IsDeleted=0";
    $order = '';

    if(@$searchCaseName !=''){
      $search = $search." AND EmailAddress LIKE  '%".$Email."%'";
    }
    if(@$Name !=''){
      $search = $search." AND Name = '".$Name."' OR Surname = '".$Name."' OR UserName = '".$Name."'";
    }

    if($request['OrderDirection']!=""){
      $order = " ORDER BY ".$request['OrderBy']." ".$request['OrderDirection'];
    }


    $sql = array('table'=>$name_table,'where'=>$search,'order'=>$order);
    if($request['PageSize']!=''){
      $page_number = $request['PageNumber'] - 1;
      $max_rows = $request['PageSize'];
      $list_count = array('table'=>$name_table,'count'=>$count,'where'=>$search); //,'order' => 'ORDER BY `QuotationId` DESC '
      $start_count = $page_number * $max_rows;
      $view_count = $this->view($list_count);
      $result_count = $this->q_re($view_count);
      $respons_count = $this->q_nr($result_count);
      $respons_count_num = mysqli_num_rows($result_count);
      $respons_pages = ceil($respons_count/$max_rows)-1;
      $data_c['page_number'] = $page_number;
      $data_c['respons_pages'] = $respons_pages;

      $sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search, 'limit'=> "$start_count,$max_rows",'order'=> $order);
    }
    $view = $this->view($sql);
    $result = $this->q_re($view);
    $i=0;
    while ($row = $this->q_ro($result)) {
       $data['Data'][$i]['CreationTime'] = $row['CreationTime'];
       $data['Data'][$i]['CreatorUserId'] = $row['CreatorUserId'];
       $data['Data'][$i]['EmailAddress'] = $row['EmailAddress'];
       $data['Data'][$i]['Id'] = $row['Id'];
       $data['Data'][$i]['IsDeleted'] = $row['IsDeleted'];
       $data['Data'][$i]['LastUpdateBy'] = $row['LastUpdateBy'];
       $data['Data'][$i]['LastUpdateDateTime'] = $row['LastUpdateDateTime'];
       $data['Data'][$i]['MiddleName'] = $row['MiddleName'];
       $data['Data'][$i]['Name'] = $row['Name'];
       $data['Data'][$i]['StatusActive'] = $row['StatusActive'];
       $data['Data'][$i]['Surname'] = $row['Surname'];
       $data['Data'][$i]['Title'] = $row['Title'];
       $data['Data'][$i]['UserName'] = $row['UserName'];

       $i++;
    }

    $data['PageNumber'] = $request['PageNumber'];
    $data['OrderBy'] = $request['OrderBy'];
    $data['OrderDirection'] = $request['OrderDirection'];
    $data['PageSize'] = $request['PageSize'];
    $data['numrows'] = @$respons_count_num;
    $data['TotalRecords'] = @$respons_count_num;
    $data['sql'] = @$view;

    return $data;
  }

  public function LoadRoleUser($userId)
  {
    $name_table = "ct_role_user";
    $count = "";
    $search = "UserId='".@$userId."'";
    $order = "";
    $sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search,'order'=> $order);

    $view = $this->view($sql);
    $result = $this->q_re($view);
    $i=0;
    while ($row = $this->q_ro($result)) {
       $data['Data'][$i]['RoleId'] = $row['RoleId'];
       $data['Data'][$i]['UserId'] = $row['UserId'];

       $i++;
    }
    $data['sql'] = $view;
    return $data;
  }

  public function Edit($Id)
  {
    $name_table = "t_system_users";
    $count = "";
    $search = "Id='".@$Id."'";
    $order = "";
    $sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search,'order'=> $order);

    $view = $this->view($sql);
    $result = $this->q_re($view);
    $i=0;
    while ($row = $this->q_ro($result)) {
      $data['Data'][$i]['CreationTime'] = $row['CreationTime'];
      $data['Data'][$i]['CreatorUserId'] = $row['CreatorUserId'];
      $data['Data'][$i]['EmailAddress'] = $row['EmailAddress'];
      $data['Data'][$i]['Id'] = $row['Id'];
      $data['Data'][$i]['IsDeleted'] = $row['IsDeleted'];
      $data['Data'][$i]['LastUpdateBy'] = $row['LastUpdateBy'];
      $data['Data'][$i]['LastUpdateDateTime'] = $row['LastUpdateDateTime'];
      $data['Data'][$i]['MiddleName'] = $row['MiddleName'];
      $data['Data'][$i]['Name'] = $row['Name'];
      $data['Data'][$i]['StatusActive'] = $row['StatusActive'];
      $data['Data'][$i]['Surname'] = $row['Surname'];
      $data['Data'][$i]['Title'] = $row['Title'];
      $data['Data'][$i]['UserName'] = $row['UserName'];

       $i++;
    }



    $sql = array('table'=>'ct_role_user','where'=>"UserId='".@$Id."'");
    $view = $this->view($sql);
    $result = $this->q_re($view);
    $i2=1;
    while ($row = $this->q_ro($result)) {
      $set[$i2] =  $row['RoleId'];
      $i2++;
    }
      $data['Data'][0]['RoleId'][0] = (array_search(1,$set)>0)?$set[array_search(1,$set)]:'';
      $data['Data'][0]['RoleId'][1] = (array_search(2,$set)>0)?$set[array_search(2,$set)]:'';
      $data['Data'][0]['RoleId'][2] = (array_search(3,$set)>0)?$set[array_search(3,$set)]:'';
      $data['Data'][0]['RoleId'][3] = (array_search(4,$set)>0)?$set[array_search(4,$set)]:'';
      $data['Data'][0]['RoleId'][4] = (array_search(5,$set)>0)?$set[array_search(5,$set)]:'';

      $data['Data'][0]['RoleId_set'] = $set;


    $data['sql'] = $view;
    return $data;
  }
}


 ?>