<?php

/**
 *
 */
class EventsClass extends Viewdata
{

  public function LoadEvent($request)
  {
    $name_table = "t_events_mas";

    $count = "";
    //$count = "tem.*, tctem.CaseTypeActionId, tctm.CaseTypeId, tctm.CaseTypeCode, tctm.CaseTypeName";

    $search = "Deleted = 0";
    if(@$request['EventName']!=''){
        $search = $search." AND EventsName LIKE '%".@$request['EventName']."%'";
    }

    $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]['EventsId'] =$row['EventsId'];
        $data['Data'][$i]['EventsName'] =$row['EventsName'];
        $data['Data'][$i]['HasDeadLine'] =$row['HasDeadLine'];
        $data['Data'][$i]['CreateBy'] =$row['CreateBy'];
        $data['Data'][$i]['CreateDateTime'] =$row['CreateDateTime'];

        $data['Data'][$i]['StatusActive'] =$row['StatusActive'];
        $data['Data'][$i]['LastUpdateBy'] =$row['LastUpdateBy'];
        $data['Data'][$i]['LastUpdateDateTime'] =$row['LastUpdateDateTime'];
        $data['Data'][$i]['Deleted'] =$row['Deleted'];

        $name_table2 = "
        t_case_type_events_map tctem
          INNER JOIN t_case_type_mas tctm ON tctem.CaseTypeId=tctm.CaseTypeId
        ";
        $count2 = " tctem.CaseTypeActionId, tctem.Deleted, tctem.StatusActive, tctm.CaseTypeId, tctm.CaseTypeCode, tctm.CaseTypeName";
        $search2 = "tctem.EventId = '".$row['EventsId']."'";
        $sql2 = array('table'=>$name_table2, 'count'=>$count2,'where'=>$search2);
        $view2 = $this->view($sql2);
        $result2 = $this->q_re($view2);
        $i2=0;
        while ($row2 = $this->q_ro($result2)) {
          $data['Data'][$i]['Case'][$i2]['CaseTypeActionId'] =$row2['CaseTypeActionId'];
          $data['Data'][$i]['Case'][$i2]['CaseTypeCode'] =$row2['CaseTypeCode'];
          $data['Data'][$i]['Case'][$i2]['CaseTypeId'] =$row2['CaseTypeId'];
          $data['Data'][$i]['Case'][$i2]['CaseTypeName'] =$row2['CaseTypeName'];
          $data['Data'][$i]['Case'][$i2]['CaseDelete'] =$row2['Deleted'];
          $data['Data'][$i]['Case'][$i2]['CaseActive'] =$row2['StatusActive'];
          $i2++;
        }


        $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;
  }
}


 ?>