<?php

/**
 *
 */
class TaxInvoiceClass extends ViewData
{
  public function Index($request)
  {
    $count = "";
    $name_table = "ct_tax_invoice";
    $search = "TaxInvoiceId = '".$request['TaxInvoiceId']."'";
    $order = "";
    $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]['TaxInvoiceId'] =$row['TaxInvoiceId'];
        $data['Data'][$i]['TaxInvoiceNo'] =$row['TaxInvoiceNo'];
        $data['Data'][$i]['InvoiceId'] =$row['InvoiceId'];
        $data['Data'][$i]['Del'] =$row['Del'];
        $data['Data'][$i]['Status'] =$row['Status'];
        $data['Data'][$i]['NotiEmail'] =$row['NotiEmail'];
        $data['Data'][$i]['IsCo'] =$row['IsCo'];
        $data['Data'][$i]['ResponseId'] = $row['ResponseId'];
        $data['Data'][$i]['CreateDateTime'] = $row['CreateDateTime'];
        $data['Data'][$i]['UpdateDateTime'] = $row['UpdateDateTime'];

        $sql2 = array('table'=>"ct_invoice",'where'=>"InvoiceId = '".@$row['InvoiceId']."'");
        $view2 = $this->view($sql2);
        $row2 = $this->q($view2);

        $data['Data'][$i]['InvoiceNo'] =$row2['InvoiceNo'];
        $data['Data'][$i]['QuotationId'] =$row2['QuotationId'];
        $data['Data'][$i]['CustomerId'] =$row2['CustomerId'];
        $data['Data'][$i]['Vat'] =$row2['Vat'];
        $data['Data'][$i]['BillDetail'] =$row2['BillDetail'];
        $data['Data'][$i]['Status'] =$row2['Status'];
        $data['Data'][$i]['Del_'] =$row2['Del'];
        $data['Data'][$i]['IsWitholdingTax'] =$row2['IsWitholdingTax'];
        $data['Data'][$i]['IsExcludeVat'] =$row2['IsExcludeVat'];
        $data['Data'][$i]['IsCo'] =$row2['IsCo'];
        $data['Data'][$i]['ResponseId'] =$row2['ResponseId'];

        $sql3 = array('table'=>"t_names_mas",'where'=>"NamesId = '".@$row2['CustomerId']."'");
        $view3 = $this->view($sql3);
        $row3 = $this->q($view3);

        $data['Data'][$i]['NamesName'] =$row3['NamesName'];
        $data['Data'][$i]['CustomerCode'] =$row3['NamesCode'];
        $data['Data'][$i]['Telephone'] =$row3['Telephone'];
        $data['Data'][$i]['Address'] =$row3['PostalAddress'];
        $data['Data'][$i]['Fax'] =$row3['Fax'];
        $data['Data'][$i]['Responsibility']='';
        $data['Data'][$i]['row3'] =$row3;

        if(@$row['ResponseId']>0){
          $sql4 = array('table'=>"t_system_users",'where'=>"Id = '".@$row['ResponseId']."'");
          $view4 = $this->view($sql4);
          $row4 = $this->q($view4);

          $data['Data'][$i]['Responsibility'] =$row4['Name']." ".$row4['Surname'];

        }


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

  public function LoadTaxInvoiceList($request)
  {
    $count = "
    ti.TaxInvoiceId,inv.InvoiceId,inv.InvoiceNo,ti.TaxInvoiceNo,ti.Status,inv.Vat,c.NamesId as CustomerId,c.NamesCode as CustomerCode,c.NamesName as CustomerName,c.PostalAddress as Address
    ,(SELECT COUNT(*) FROM ct_receipt WHERE InvoiceId = ti.InvoiceId AND Del = 0) as IsEdit
     ,(SELECT CONCAT(Name,' ',Surname) FROM t_system_users WHERE Id = ti.ResponseId) as Responsibility

    ";
    $name_table = "ct_tax_invoice ti INNER JOIN ct_invoice inv ON ti.InvoiceId = inv.InvoiceId INNER JOIN t_names_mas c ON inv.CustomerId = c.NamesId";
    $search = "ti.Del = 0";
    $order = "";
    if($request['TaxInvoiceNo']!=''){
      $search = $search. " AND ti.TaxInvoiceNo LIKE '%".$request['TaxInvoiceNo'] ."%' ";
    }
    if($request['CustomerId']!=''){
      $search = $search. " AND c.NamesId = '".$request['CustomerId'] ."' ";
    }
    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]['Address'] =$row['Address'];
        $data['Data'][$i]['CustomerCode'] =$row['CustomerCode'];
        $data['Data'][$i]['CustomerId'] =$row['CustomerId'];
        $data['Data'][$i]['CustomerName'] =$row['CustomerName'];
        $data['Data'][$i]['InvoiceId'] =$row['InvoiceId'];
        $data['Data'][$i]['InvoiceNo'] =$row['InvoiceNo'];

        $data['Data'][$i]['Responsibility'] =$row['Responsibility'];
        $data['Data'][$i]['TaxInvoiceId'] =$row['TaxInvoiceId'];
        $data['Data'][$i]['TaxInvoiceNo'] =$row['TaxInvoiceNo'];
        $data['Data'][$i]['Status'] =$row['Status'];
        $data['Data'][$i]['Vat'] =$row['Vat'];
        $data['Data'][$i]['IsEdit'] =($row['IsEdit']!='')?$row['IsEdit']:'';
        /*
        $sql_IsEdit = array('table'=>"ct_receipt", 'count'=>"COUNT(*) AS IsEdit",'where'=>" InvoiceId = '".$row['InvoiceId']."' AND Del = '0'");
        $view_IsEdit = $this->view($sql_IsEdit);
        $row_IsEdit = $this->q($view_IsEdit);
        $data['Data'][$i]['IsEdit'] =($row_IsEdit['IsEdit']!='')?$row_IsEdit['IsEdit']:'';
        */

       $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;
    $data['re'] = $request;
    return $data;
  }

  public function LoadInvoiceList($request)
  {
    $count = "
    inv.*,c.NamesName as CustomerName,c.NamesCode as CustomerCode,c.PostalAddress as Address

    ";
    $name_table = "ct_invoice inv INNER JOIN t_names_mas c ON inv.CustomerId=c.NamesId";
    $search = "inv.Del = 0 AND (SELECT Count(*) FROM ct_tax_invoice WHERE InvoiceId = inv.InvoiceId AND Del = 0) = 0";
    $order = "";
    $sql = array('table'=>$name_table,'where'=>$search);
    if(@$request['InvoiceNo']!=''){
      $search = $search." AND inv.InvoiceNo Like '%".$request['InvoiceNo']."%'";
    }
    if(@$request['CustomerId'] > 0){
      $search = $search." AND c.NamesId Like '%".$request['CustomerId']."%'";
    }
    if($request['OrderDirection']!=''){
      $order = " Order By ".$request['OrderBy'] ." ".$request['OrderDirection'];
    }

    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]['Address'] =$row['Address'];
        $data['Data'][$i]['CustomerCode'] =$row['CustomerCode'];
        $data['Data'][$i]['CustomerId'] =$row['CustomerId'];
        $data['Data'][$i]['CustomerName'] =$row['CustomerName'];
        $data['Data'][$i]['InvoiceId'] =$row['InvoiceId'];
        $data['Data'][$i]['InvoiceNo'] =$row['InvoiceNo'];
        $data['Data'][$i]['IsEdit'] =$row['IsEdit'];
        $data['Data'][$i]['Responsibility'] =$row['Responsibility'];
        $data['Data'][$i]['TaxInvoiceId'] =$row['TaxInvoiceId'];
        $data['Data'][$i]['TaxInvoiceNo'] =$row['TaxInvoiceNo'];
        $data['Data'][$i]['Vat'] =$row['Vat'];

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


  public function ExportPdf($id){

    $matterNo =""; $isConsultService=0;
    $name_table = "
    ct_tax_invoice ti INNER JOIN ct_invoice inv ON ti.InvoiceId = inv.InvoiceId
    INNER JOIN ct_quotation q ON inv.QuotationId = q.QuotationId
    INNER JOIN t_names_mas c ON inv.CustomerId = c.NamesId
    ";
    $count = "ti.TaxInvoiceId,ti.Status,inv.InvoiceId,inv.InvoiceNo,ti.TaxInvoiceNo,inv.Vat,c.NamesId as CustomerId,c.NamesCode as CustomerCode,c.TaxID,c.PostalAddress as Address,ti.CreateDateTime,ti.UpdateDateTime,c.NamesName as CustomerName,inv.QuotationId,inv.IsConsultService
     ,q.Currency,(SELECT COUNT(*) FROM ct_receipt WHERE InvoiceId = ti.InvoiceId AND Del = 0) as IsEdit";

    $InvoiceId = "";
    $QuotationId = "";
    $secrch = "ti.TaxInvoiceId = '".@$id."'";
    $sql = array('table'=>$name_table,'count'=>$count,'where'=>$secrch);
    $view = $this->view($sql);
    $result = $this->q_re($view);
    $result_num = $this->q_nr($result);
    $i=0;$data=array();
    if(@$result_num>0){
      while ($row = $this->q_ro($result)) {
        $data['Data'][$i]['TaxInvoiceId'] = $row['TaxInvoiceId'];
        $data['Data'][$i]['TaxInvoiceNo'] = $row['TaxInvoiceNo'];
        $data['Data'][$i]['InvoiceId'] = $row['InvoiceId'];
        $data['Data'][$i]['Del'] = $row['Del'];
        $data['Data'][$i]['Status'] = $row['Status'];
        $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]['IsCo'] = $row['IsCo'];
        $data['Data'][$i]['NotiEmail'] = $row['NotiEmail'];
        $data['Data'][$i]['ResponseId'] = $row['ResponseId'];
        $data['Data'][$i]['InvoiceNo'] = $row['InvoiceNo'];
        $data['Data'][$i]['QuotationId'] = $row['QuotationId'];
        $data['Data'][$i]['CustomerId'] = $row['CustomerId'];
        $data['Data'][$i]['CustomerName'] = $row['CustomerName'];
        $data['Data'][$i]['Address'] = $row['Address'];
        $data['Data'][$i]['Vat'] = $row['Vat'];
        $data['Data'][$i]['BillDetail'] = $row['BillDetail'];
        $data['Data'][$i]['IsWitholdingTax'] = $row['IsWitholdingTax'];
        $data['Data'][$i]['IsExcludeVat'] = $row['IsExcludeVat'];
        $data['Data'][$i]['IsConsultService'] = $row['IsConsultService'];
        $data['Data'][$i]['QuotationNo'] = $row['QuotationNo'];
        $data['Data'][$i]['CountryId'] = $row['CountryId'];
        $data['Data'][$i]['QuotationType'] = $row['QuotationType'];
        $data['Data'][$i]['RetainerStart'] = $row['RetainerStart'];
        $data['Data'][$i]['RetainerEnd'] = $row['RetainerEnd'];
        $data['Data'][$i]['Condition'] = $row['Condition'];
        $data['Data'][$i]['CaseTypeId'] = $row['CaseTypeId'];
        $data['Data'][$i]['CreditType'] = $row['CreditType'];
        $data['Data'][$i]['CreditTerms'] = $row['CreditTerms'];
        $data['Data'][$i]['ContactPerson'] = $row['ContactPerson'];
        $data['Data'][$i]['Currency'] = $row['Currency'];
        $data['Data'][$i]['LocalQuantity'] = $row['LocalQuantity'];
        $data['Data'][$i]['InterQuantity'] = $row['InterQuantity'];
        $data['Data'][$i]['NamesId'] = $row['NamesId'];
        $data['Data'][$i]['NamesName'] = $row['NamesName'];
        $data['Data'][$i]['NamesCode'] = $row['NamesCode'];
        $data['Data'][$i]['Telephone'] = $row['Telephone'];
        $data['Data'][$i]['PostalAddress'] = $row['PostalAddress'];
        $data['Data'][$i]['Fax'] = $row['Fax'];
        $data['Data'][$i]['ElectronicMail'] = $row['ElectronicMail'];
        $data['Data'][$i]['TaxID'] = $row['TaxID'];
        $data['Data'][$i]['Remark'] = $row['Remark'];
        $data['Data'][$i]['Initial'] = $row['Initial'];
        $data['Data'][$i]['StatusActive'] = $row['StatusActive'];
        $data['Data'][$i]['LastUpdateBy'] = $row['LastUpdateBy'];
        $data['Data'][$i]['LastUpdateDateTime'] = $row['LastUpdateDateTime'];
        $data['Data'][$i]['Deleted'] = $row['Deleted'];

        $InvoiceId = $row['InvoiceId'];
        $QuotationId = $row['QuotationId'];
        $i++;
      }
    }else{
      $data['Data'] = '';
    }

    $sql_item = array('table'=>"ct_invoice_item",'where'=>"InvoiceId = '".@$InvoiceId."'");
    $view_item = $this->view($sql_item);
    $result_item = $this->q_re($view_item);
    $count_item = $this->q_nr($result_item);
    $i2=0;
    if(@$count_item>0){
        while ($row_item = $this->q_ro($result_item)) {
          $data['Data2'][$i2]['InvoiceItemId'] = $row_item['InvoiceItemId'];
          $data['Data2'][$i2]['InvoiceId'] = $row_item['InvoiceId'];
          $data['Data2'][$i2]['Description'] = $row_item['Description'];
          $data['Data2'][$i2]['Amount'] = $row_item['Amount'];
          $data['Data2'][$i2]['QuotationPaymentTermId'] = $row_item['QuotationPaymentTermId'];
          $data['Data2'][$i2]['Remark'] = $row_item['Remark'];
          $data['Data2'][$i2]['IsExcludeVat'] = $row_item['IsExcludeVat'];
          $data['Data2'][$i2]['CaseDisburseId'] = $row_item['CaseDisburseId'];
          $data['Data2'][$i2]['CaseExpenseId'] = $row_item['CaseExpenseId'];
          $data['Data2'][$i2]['ActionDate'] = $row_item['ActionDate'];
          $data['Data2'][$i2]['Category'] = $row_item['Category'];
          $data['Data2'][$i2]['view_item'] = $view_item;
          $i2++;
        }
    }else{
      $data['Data2'] = "";
    }

    $sql_case = array('table'=>"ct_case",'where'=>"QuotationId = '".$QuotationId."'");
    $view_case = $this->view($sql_case);
    $result_case = $this->q_re($view_case);
    $count_case = $this->q_nr($result_case);
    $i3=0;
    if(@$count_case>0){
        while ($row_case = $this->q_ro($result_case)) {
          $data['Data3'][$i3]['CaseId'] = $row_case['CaseId'];
          $data['Data3'][$i3]['CaseNumber'] = $row_case['CaseNumber'];
          $data['Data3'][$i3]['CaseTypeId'] = $row_case['CaseTypeId'];
          $data['Data3'][$i3]['CaseDescription'] = $row_case['CaseDescription'];
          $data['Data3'][$i3]['QuotationId'] = $row_case['QuotationId'];
          $data['Data3'][$i3]['CustomerId'] = $row_case['CustomerId'];
          $data['Data3'][$i3]['CreateBy'] = $row_case['CreateBy'];
          $data['Data3'][$i3]['CreateDateTime'] = $row_case['CreateDateTime'];
          $data['Data3'][$i3]['UpdateBy'] = $row_case['UpdateBy'];
          $data['Data3'][$i3]['UpdateDateTime'] = $row_case['UpdateDateTime'];
          $data['Data3'][$i3]['LocalQuantity'] = $row_case['LocalQuantity'];
          $data['Data3'][$i3]['InterQuantity'] = $row_case['InterQuantity'];
          $data['Data3'][$i3]['ResponseId'] = $row_case['ResponseId'];
          $i3++;
        }
    }else{
      $data['Data3'] = "";
    }



    $data['view_item'] = $view_item;
    $data['view'] = $view;
    return $data;
  }
}


 ?>