<?php

/**
 *
 */
class MastercaseClass extends Viewdata
{

  public function Index($request)
  {
    $Sorting = (@$request['Sorting']=='')?"CreatedAt":@$request['Sorting'];
    $searchCaseName = @$request['SEARCH_CASE_NAME'];
    $searchCountry = @$request['SEARCH_COUNTRY'];

    $name_table = "ct_master_case_type q";
    $count = " *
    ,(SELECT CountryCode FROM ct_country WHERE CountryId=q.CountryId) as CountryCode
    ";
    $search = "Del=0";
    $order = '';

    if(@$searchCaseName !=''){
      $search = $search." AND q.CaseTypeName LIKE  '%".$searchCaseName."%'";
    }
    if(@$searchCountry !=''){
      $search = $search." AND q.CountryId = '".$searchCountry."'";
    }

    if($request['OrderDirection']!=""){
      $order = " ORDER BY `q`.`".$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]['CurrentSort'] = $Sorting;
       $data['Data'][$i]['UsernameCss'] = "sorting";
       $data['Data'][$i]['NameCss'] = "sorting";
       $data['Data'][$i]['CaseTypeId'] = $row['CaseTypeId'];
       $data['Data'][$i]['CountryId'] = $row['CountryId'];
       $data['Data'][$i]['CaseTypeName'] = $row['CaseTypeName'];
       $data['Data'][$i]['CaseTypeAbbr'] = $row['CaseTypeAbbr'];
       $data['Data'][$i]['Status'] = $row['Status'];
       $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'];
       $data['Data'][$i]['Department'] = $row['Department'];
       $data['Data'][$i]['Sort'] = $row['Sort'];
       $data['Data'][$i]['CountryCode'] = $row['CountryCode'];



       $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 ManageEvent($request)
  {
    $sql = array('table'=>"ct_master_case_type",'where'=>"CaseTypeId = '".@$request['CaseTypeId']."'");
    $view = $this->view($sql);
    $result = $this->q_re($view);
    $result_count = $this->q_nr($result_count);

    if(@$result_count <= 0){
      $data['Data'][0]['massage'] = 'Not Data';
    }else{
      $row = $this->q($view);
      $sql2 = array('table'=>"ct_master_case_type_event",'where'=>"CaseTypeId = '".$row['CaseTypeId']."'");
      $view2 = $this->view($sql2);
      $result2 = $this->q_re($view2);
      $result2_count = $this->q_nr($result2);

      if(@$result2_count==0){
        $sql3 = array('table'=>"ct_master_event",'where'=>"DefaultFlag = '1'");
        $view3 = $this->view($sql3);
        $result3 = $this->q_re($view3);
        while ($row3 = $this->q_ro($result3)) {
           $data['Data'][$i]['defaultEvent'] = $row3;

           $sql4 = array('table'=>"ct_master_case_type_event",'where'=>"CaseTypeId = '".$row['CaseTypeId']."'");
           $view4 = $this->view($sql4);


           $i++;
        }

      }
    }

    return $data;
  }

  public function LoadMasterEvent($request)
  {
    $name_table = "
    ct_master_event ev
    INNER JOIN ct_master_case_type_event r on ev.EventId=r.EventId
    ";
    $count = " ev.EventId,ev.EventName,ev.DeadLineFlag,ev.FreeTextFlag,ev.TimeSheetFlag,ev.DefaultFlag,ev.Status ";
    $search = "ev.Del = 0 AND ev.Status = 1 AND r.CaseTypeId = '".@$request['CaseTypeId']."'";
    $order = "";

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

    $sql = array('table'=>$name_table,'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]['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]['DefaultFlag'] =$row['DefaultFlag'];
        $data['Data'][$i]['Status'] =$row['Status'];

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

}


 ?>