<?php

/**
 *
 */
class RoleClass extends Viewdata
{

  public function LoadRole($request)
  {
    $name_table = "
    t_system_role tsr
    INNER JOIN t_system_role_permission_menu tsrpm ON tsr.Id = tsrpm.RoleId
    INNER JOIN t_system_menu tsm ON tsrpm.MenuId = tsm.Id
    ";

    $count = "tsr.*, tsrpm.MenuId, tsrpm.IsView, tsrpm.IsCreate, tsrpm.IsUpdate, tsrpm.IsDelete,
    tsm.ParentId, tsm.Icon, tsm.Label, tsm.LinkTo, tsm.OrderSeq ";

    $search = "tsr.IsDeleted = 0";
    if(@$request['RoleName']!=''){
        $search = $search." AND tsr.RoleName = '".@$request['RoleName']."'";
    }

    $order = '';

    if($request['OrderDirection']!=''){
      $order = " Order By tsr.".$request['OrderBy'] ." ".$request['OrderDirection'];
    }

    $sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search);
    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, 'order'=> $order); //'limit'=> "$start_count,$max_rows"
    }
    $view = $this->view($sql);
    $result = $this->q_re($view);
    $i=0;$data=array();
    $read = "";
    if(@$respons_count_num>0){
      while ($row = $this->q_ro($result)) {
        if($read==$row['Id']){
          $data['Data'][$i]['Menu'][$i2]['MenuId'] =$row['MenuId'];
          $data['Data'][$i]['Menu'][$i2]['Label'] =$row['Label'];
          $data['Data'][$i]['Menu'][$i2]['IsView'] =$row['IsView'];
          $data['Data'][$i]['Menu'][$i2]['IsCreate'] =$row['IsCreate'];
          $data['Data'][$i]['Menu'][$i2]['IsUpdate'] =$row['IsUpdate'];
          $data['Data'][$i]['Menu'][$i2]['IsDelete'] =$row['IsDelete'];
          $i2++;

        }else {
          $i2=0;
          if($data['Data'][$i]['Id']!=""){$i++;}

          $data['Data'][$i]['Id'] =$row['Id'];
          $data['Data'][$i]['RoleName'] =$row['RoleName'];
          $data['Data'][$i]['Remark'] =$row['Remark'];
          $data['Data'][$i]['StatusActive'] =$row['StatusActive'];
          $data['Data'][$i]['CreateBy'] =$row['CreateBy'];
          $data['Data'][$i]['LastUpdateBy'] =$row['LastUpdateBy'];
          $data['Data'][$i]['CreateDateTime'] =$row['CreateDateTime'];
          $data['Data'][$i]['LastUpdateDateTime'] =$row['LastUpdateDateTime'];
          $data['Data'][$i]['ParentId'] =$row['ParentId'];
          $data['Data'][$i]['Icon'] =$row['Icon'];
          $data['Data'][$i]['LinkTo'] =$row['LinkTo'];
          $data['Data'][$i]['OrderSeq '] =$row['OrderSeq'];

          $data['Data'][$i]['Menu'][$i2]['MenuId'] =$row['MenuId'];
          $data['Data'][$i]['Menu'][$i2]['Label'] =$row['Label'];
          $data['Data'][$i]['Menu'][$i2]['IsView'] =$row['IsView'];
          $data['Data'][$i]['Menu'][$i2]['IsCreate'] =$row['IsCreate'];
          $data['Data'][$i]['Menu'][$i2]['IsUpdate'] =$row['IsUpdate'];
          $data['Data'][$i]['Menu'][$i2]['IsDelete'] =$row['IsDelete'];
          $i2++;

          $read = $row['Id'];
        }


      }

    }else{
      $data['Data'] = '';
    }
    $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 LoadRoleId($request)
  {
    $name_table = "
    t_system_role_permission_menu tsr
    INNER JOIN t_system_role ts ON tsr.RoleId = ts.Id
    INNER JOIN t_system_menu tsm ON tsm.Id = tsr.MenuId
    ";

    $count = "tsr.*, ts.RoleName, ts.Remark, tsm.ParentId, tsm.Icon, tsm.Label, tsm.LinkTo, tsm.OrderSeq";

    $search = "IsDeleted = 0";
    if(@$request['RoleName']!=''){
        $search = $search." AND ts.RoleName = '".@$request['RoleName']."'";
    }

    $order = '';

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

    $sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search);
    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;$data=array();
    if(@$respons_count_num>0){
      while ($row = $this->q_ro($result)) {

        $data['Data'][$i]['Id'] =$row['Id'];
        $data['Data'][$i]['RoleName'] =$row['RoleName'];
        $data['Data'][$i]['Remark'] =$row['Remark'];
        $data['Data'][$i]['StatusActive'] =$row['StatusActive'];
        $data['Data'][$i]['CreateBy'] =$row['CreateBy'];
        $data['Data'][$i]['LastUpdateBy'] =$row['LastUpdateBy'];
        $data['Data'][$i]['CreateDateTime'] =$row['CreateDateTime'];
        $data['Data'][$i]['LastUpdateDateTime'] =$row['LastUpdateDateTime'];
        $i++;
      }

    }else{
      $data['Data'] = '';
    }
    $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 LoadRoleMenu($request)
  {
    $name_table = "t_system_menu";
    $count = "";
    $search = "IsDeleted = 0 AND Id != '1'";
    $order = 'ORDER BY OrderSeq ASC ';
    if($request['OrderDirection']!=''){
      $order = " Order By ".$request['OrderBy'] ." ".$request['OrderDirection'];
    }

    $sql = array('table'=>$name_table, 'count'=>$count,'where'=>$search, 'order'=>$order);
    $view = $this->view($sql);
    $result = $this->q_re($view);
    $respons_count_num = mysqli_num_rows($result);
    $i=0;$i2=0;$data=array();
    $read = "";
    if(@$respons_count_num>0){
      while ($row = $this->q_ro($result)) {
        $data['Data'][$i]['Id'] =$row['Id'];
        $data['Data'][$i]['ParentId'] =$row['ParentId'];
        $data['Data'][$i]['Icon'] =$row['Icon'];
        $data['Data'][$i]['Label'] =$row['Label'];
        $data['Data'][$i]['LinkTo'] =$row['LinkTo'];
        $data['Data'][$i]['OrderSeq '] =$row['OrderSeq'];
        $data['Data'][$i]['StatusActive '] =$row['StatusActive'];
        $data['Data'][$i]['CreatorUserId'] =$row['CreatorUserId'];
        $data['Data'][$i]['CreationTime'] =$row['CreationTime'];
        $i++;
      }

    }else{
      $data['Data'] = '';
    }
    $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;
  }

}


 ?>