<?php

/**
 *
 */
class MastereventClass extends ViewData
{

  public function Index($request)
  {

    $sql1 = array('table'=>'ct_master_case_type','where'=>'CaseTypeId = "'.$request['CaseTypeId'].'"');
    $view1 = $this->view($sql1);
    $row1 = $this->q($view1);

    $sql2 = array('table'=>'ct_country','where'=>'CountryId = "'.$row1['CountryId'].'"','order'=>$order);
    $view2 = $this->view($sql2);
    $row2 = $this->q($view2);


    $name_table = "ct_master_case_type_event";
    $secrch = "CaseTypeId = '".$request['Id']."'";
    $sql = array('table'=>$name_table,'where'=>$secrch);
    $view = $this->view($sql);
    $result = $this->q_re($view);
    $i=0;$data=array();
    while ($row = $this->q_ro($result)) {

     $sql3 = array('table'=>'ct_master_event','where'=>'EventId = "'.$row['EventId'].'"');
     $view3 = $this->view($sql3);
     $row3 = $this->q($view3);

     //$data['data'][$i]['row3'] =$row3;

     $i++;


    }

    $data['CaseTypeName'] = $row1['CaseTypeName'];
    $data['CountryId'] = $row1['CountryId'];
    $data['countryName'] = $row2['CountryCode'];
    return $data;
  }

  public function LoadAll($request)
  {
    $name_table = "ct_master_event";
    $order='';
    $count='';
    $secrch = "Del = 0 AND Status =1 ";
    if(@$request['Keyword']!=''){
      $secrch .= " AND EventName LIKE '%".$request['Keyword']."%'";
    }

    if(@$request['OrderDirection']!=''){
      $order = "ORDER BY ".$request['OrderBy']." ".$request['OrderDirection'];
    }
    $sql = array('table'=>$name_table,'where'=>$secrch, 'order' => $order);

    if($request['PageSize']!=''){
      $page_number = $request['PageNumber'] - 1;
      $max_rows = $request['PageSize'];
      $list_count = array('table'=>$name_table,'count'=>$count,'where'=>$secrch); //,'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'=>$secrch, 'limit'=> "$start_count,$max_rows",'order'=> $order);
    }


    $view = $this->view($sql);
    $result = $this->q_re($view);
    $i=0;$data=array();
    while ($row = $this->q_ro($result)) {
     $data['Data'][$i]['EventId'] =$row['EventId'];
     $data['Data'][$i]['EventName'] =$row['EventName'];
     $data['Data'][$i]['DeadLineFlag'] =$row['DeadLineFlag'];
     $data['Data'][$i]['FreeTextFlag'] =$row['FreeTextFlag'];
     $data['Data'][$i]['TimeSheetFlag'] =$row['TimeSheetFlag'];
     $data['Data'][$i]['Status'] =$row['Status'];
     $data['Data'][$i]['DefaultFlag'] =$row['DefaultFlag'];
     $data['Data'][$i]['Del'] =$row['Del'];
     $data['Data'][$i]['CreateBy'] =$row['CreateBy'];
     $data['Data'][$i]['CreateDateTime'] =$row['CreateDateTime'];
     $data['Data'][$i]['UpdateBy'] =$row['UpdateBy'];
     $data['Data'][$i]['UpdateDateTime'] =$row['UpdateDateTime'];
     $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;

    return $data;

  }
  public function LoadItem($request)
  {
    $name_table = "ct_master_event";
    $order='';
    $secrch = "Del = 0 AND Status =1 ";
    if(@$request['EventId']!=''){
      $secrch .= " AND EventId = '".$request['EventId']."'";
    }
    $sql = array('table'=>$name_table,'where'=>$secrch);
    $view = $this->view($sql);
    $result = $this->q_re($view);
    $i=0;$data=array();
    while ($row = $this->q_ro($result)) {
     $data[$i]['EventId'] =$row['EventId'];
     $data[$i]['EventName'] =$row['EventName'];
     $data[$i]['DeadLineFlag'] =$row['DeadLineFlag'];
     $data[$i]['FreeTextFlag'] =$row['FreeTextFlag'];
     $data[$i]['TimeSheetFlag'] =$row['TimeSheetFlag'];
     $data[$i]['Status'] =$row['Status'];
     $data[$i]['DefaultFlag'] =$row['DefaultFlag'];
     $data[$i]['Del'] =$row['Del'];
     $data[$i]['CreateBy'] =$row['CreateBy'];
     $data[$i]['CreateDateTime'] =$row['CreateDateTime'];
     $data[$i]['UpdateBy'] =$row['UpdateBy'];
     $data[$i]['UpdateDateTime'] =$row['UpdateDateTime'];
     $i++;
    }
    return $data;

  }

  public function Edit($request)
  {

  }

  public function LoadList($request)
  {
    $name_table = "ct_master_event";
    $order='';
    $count='';
    $secrch = "Del = 0";
    if(@$request['Keyword']!=''){
      $secrch .= " AND EventName LIKE '%".$request['Keyword']."%'";
    }

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

    }
    $sql = array('table'=>$name_table,'where'=>$secrch, 'order' => $order);

    if($request['PageSize']!=''){
      $page_number = $request['PageNumber'] - 1;
      $max_rows = $request['PageSize'];
      $list_count = array('table'=>$name_table,'count'=>$count,'where'=>$secrch); //,'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'=>$secrch, 'limit'=> "$start_count,$max_rows",'order'=> $order);
    }


    $view = $this->view($sql);
    $result = $this->q_re($view);
    $i=0;$data=array();
    while ($row = $this->q_ro($result)) {
     $data['Data'][$i]['EventId'] =$row['EventId'];
     $data['Data'][$i]['EventName'] =$row['EventName'];
     $data['Data'][$i]['DeadLineFlag'] =$row['DeadLineFlag'];
     $data['Data'][$i]['FreeTextFlag'] =$row['FreeTextFlag'];
     $data['Data'][$i]['TimeSheetFlag'] =$row['TimeSheetFlag'];
     $data['Data'][$i]['Status'] =$row['Status'];
     $data['Data'][$i]['DefaultFlag'] =$row['DefaultFlag'];
     $data['Data'][$i]['Del'] =$row['Del'];
     $data['Data'][$i]['CreateBy'] =$row['CreateBy'];
     $data['Data'][$i]['CreateBy'] =$row['CreateBy'];

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

  }

}


 ?>