<?php

/**
 *
 */
class AttachmentClass extends Viewdata
{

  public function LoadDetail($request)
  {
    $name_table = "ct_attachment";
    $search = "ParentId = 0 AND AttachmentId = '".$request['Id']."' AND Del = 0";
    $order='';


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

    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]['AttachmentId'] = $row['AttachmentId'];
        $data['Data'][$i]['AttachmentNumber'] =$row['AttachmentNumber'];
        $data['Data'][$i]['DocumentName'] =$row['DocumentName'];
        $data['Data'][$i]['DocumentDate'] =$row['DocumentDate'];
        $data['Data'][$i]['DocumentType'] =$row['DocumentType'];
        $data['Data'][$i]['DocumentTypeName'] =($row['DocumentType']==1)?"Customer Doc":($row['DocumentType']==2)?"Lawyer Doc":($row['DocumentType']==3)? "Gov. Doc":"";
        $data['Data'][$i]['FilePath'] =$row['FilePath'];
        $data['Data'][$i]['AttachmentDate'] =$row['AttachmentDate'];
        $data['Data'][$i]['Seq'] =$row['Seq'];
        $data['Data'][$i]['CaseNumber'] ='';
        $data['Data'][$i]['CustomerCode'] ='';
        $data['Data'][$i]['NamesName'] ='';
        if(@$row['CaseId']!=''){
          $sql2 = array('table'=>"ct_case",'where'=>"CaseId = '".$row['CaseId']."'");
          $view2 = $this->view($sql2);
          $row2 = $this->q($view2);
          $data['Data'][$i]['CaseNumber'] =$row2['CaseNumber'];
        }

        if(@$row['CustomerId']!=''){
          $sql3 = array('table'=>"t_names_mas",'where'=>"NamesId = '".$row['CustomerId']."'");
          $view3 = $this->view($sql3);
          $row3 = $this->q($view3);
          $data['Data'][$i]['CustomerCode'] = $row3['NamesCode'];
          $data['Data'][$i]['CustomerName'] = $row3['NamesName'];
        }

       $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;
    return $data;
  }
  public function LoadList($request)
  {
    $name_table = "ct_attachment";
    $search = "Del = 0";
    $order='';
    if(@$request['DocumentName']!=''){
        $search = $search." AND AttachmentNumber LIKE '%".$request['AttachmentNumber']."%'";
    }
    if(@$request['AttachmentNumber']!=''){
        $search = $search." AND DocumentName LIKE '%".$request['DocumentName']."%'";
    }
    if(@$request['OrderDirection']!=''){
        $order = " ORDER BY ".$request['OrderBy'] ." ".$request['OrderDirection'];
    }else{
        $order = " ORDER BY AttachmentNumber DESC";
    }


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

    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]['AttachmentId'] = $row['AttachmentId'];
        $data['Data'][$i]['ParentId'] = $row['ParentId'];
        $data['Data'][$i]['AttachmentNumber'] = $row['AttachmentNumber'];
        $data['Data'][$i]['DocumentName'] =$row['DocumentName'];
        $data['Data'][$i]['DocumentDate'] =$row['DocumentDate'];
        $data['Data'][$i]['DocumentType'] =$row['DocumentType'];
        $data['Data'][$i]['DocumentTypeName'] =($row['DocumentType']==1)?"Customer Doc":($row['DocumentType']==2)?"Lawyer Doc":($row['DocumentType']==3)? "Gov. Doc":"";
        $data['Data'][$i]['FilePath'] =$row['FilePath'];
        $data['Data'][$i]['AttachmentDate'] =$row['AttachmentDate'];
        $data['Data'][$i]['Seq'] =$row['Seq'];
        $data['Data'][$i]['CaseNumber'] ='';
        $data['Data'][$i]['CustomerCode'] ='';
        //$data['Data'][$i]['NamesName'] ='';
        if(@$row['CaseNumber']!=''){
          $sql2 = array('table'=>"ct_case",'where'=>"CaseId = '".$row['CaseId']."'");
          $view2 = $this->view($sql2);
          $row2 = $this->q($view2);
          $data['Data'][$i]['CaseNumber'] =$row2['CaseNumber'];
        }

        if(@$row['CustomerId']!=''){
          $sql3 = array('table'=>"t_names_mas",'where'=>"NamesId = '".$row['CustomerId']."'");
          $view3 = $this->view($sql3);
          $row3 = $this->q($view3);
          $data['Data'][$i]['CustomerCode'] =$row3['NamesCode'];
          //$data['Data'][$i]['NamesName'] =$row3['NamesName'];
        }

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


 ?>