<?php

/**
 *
 */
class CasegoryClass extends Viewdata
{

  public function LoadCategory($request)
  {
    //$name_table = "ct_master_disburse_cat";
    $name_table = "ct_category";
    $order='';
    $count='';
    //$search = "Del = '0' AND Status ='1' ";
    $search = "";
//    if(@$request['CategoryId']!=''){
//      $search .= " AND CategoryId = '".$request['CategoryId']."'";
//    }

    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;$data=array();
    if($respons_count_num>0){
      while ($row = $this->q_ro($result)) {
        /*
        $data['Data'][$i]['DisburseCategoryId'] =$row['DisburseCategoryId'];
        $data['Data'][$i]['Name'] =$row['Name'];
        */
        $data['Data'][$i]['CategoryId'] =$row['CategoryId'];
        $data['Data'][$i]['CategoryName'] =$row['CategoryName'];
        $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]['Sort'] =$row['Sort'];

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

  
}


 ?>