<?php
  $ck='not';
  //putenv("NLS_LANG=AMERICAN_AMERICA.TH8TISASCII");
  include("../include/class.php");
  include("../include/table_name.php");





  $date_year = date("Y");
  $date_month = date("m");

  $request = array(
  'CountryId' => @$_REQUEST['CountryId'],
  'CaseTypeId' => @$_REQUEST['CaseTypeId'],
  'CaseNumber' => @$_REQUEST['CaseNumber'],
  'CaseId' => @$_REQUEST['CaseId'],
  'CustomerId' => @$_REQUEST['CustomerId'],
  'Status' => @$_REQUEST['Status'],
  'IsRetainer' => @$_REQUEST['IsRetainer'],
  );

  $data = $report_db->CaseSummaryExcelandPdf($request);


/*
  echo "<pre>";
  print_r($request);
  echo "</pre>";
*/

require('mc_table.php');

function GenerateWord()
{
    // Get a random word
    $nb = rand(3, 10);
    $w = '';
    for($i=1;$i<=$nb;$i++)
        $w .= chr(rand(ord('a'), ord('z')));
    return $w;
}

function GenerateSentence()
{
    // Get a random sentence
    $nb = rand(1, 10);
    $s = '';
    for($i=1;$i<=$nb;$i++)
        $s .= GenerateWord().' ';
    return substr($s, 0, -1);
}



$pdf = new PDF_MC_Table();
$pdf->AddPage();
$pdf->AddFont('FS1','','THSarabunNew.php');
$pdf->AddFont('FS1','B','THSarabunNew Bold.php');
$pdf->SetFont('FS1','',12);
$h = 5;
/*
$txt = 'Country: TH , Case Type: Corporate Registration , Case Number: - , Customer: - , Status: Opening , Quotation Type: One Time only';
$pdf->Cell($w,$h,iconv('utf-8','cp874',$txt),0,1,'C');
*/

$pdf->SetWidths(array(13, 25, 15, 18, 25, 20, 18, 25, 20, 18));
//$pdf->SetLineHeight(5);


$columnName = ['No.', 'Case Number', 'Due Date', 'Case Type', 'Customer Name', 'Last Event', 'Task Date', 'Task Descripton', 'Task By', 'Duration'];

$pdf->Cell(13,$h,$columnName[0],0);
$pdf->Cell(25,$h,$columnName[1],0);
$pdf->Cell(15,$h,$columnName[2],0);
$pdf->Cell(18,$h,$columnName[3],0);
$pdf->Cell(25,$h,$columnName[4],0);
$pdf->Cell(20,$h,$columnName[5],0);
$pdf->Cell(18,$h,$columnName[6],0);
$pdf->Cell(25,$h,$columnName[7],0);
$pdf->Cell(20,$h,$columnName[8],0);
$pdf->Cell(18,$h,$columnName[9],0);

$pdf->Ln();

// Table with 20 rows and 4 columns

    $CaseId='';
    $ct = 0;
    foreach ($data as $key => $value) {
      if(@$CaseId=='')
      {
        $pdf->Row(
          array(
            $value['CaseId'],
            $value['CaseNumber'],
            $value['DueDate'],
            $value['CaseType'],
            iconv('utf-8','cp874',$value['CustomerName']),
            $value['LastEvent'],
            $value['TaskDate'],
            iconv('utf-8','cp874',$value['TaskDescription']),
            $value['TaskBy'],
            $value['Duration']
          )
        );

        $CaseId = $value['CaseId'];

      }else{
        if(@$CaseId != $value['CaseId'])
        {
          $pdf->Row(
            array(
              $value['CaseId'],
              $value['CaseNumber'],
              $value['DueDate'],
              $value['CaseType'],
              iconv('utf-8','cp874',$value['CustomerName']),
              $value['LastEvent'],
              $value['TaskDate'],
              iconv('utf-8','cp874',$value['TaskDescription']),
              $value['TaskBy'],
              $value['Duration']
            )
          );
          $CaseId = $value['CaseId'];

        }
        else
        {

          $pdf->Row(
            array(
              $value['CaseId'],
              $value['CaseNumber'],
              $value['DueDate'],
              $value['CaseType'],
              iconv('utf-8','cp874',$value['CustomerName']),
              $value['LastEvent'],
              $value['TaskDate'],
              iconv('utf-8','cp874',$value['TaskDescription']),
              $value['TaskBy'],
              $value['Duration']
            )
          );

        }
      }


    }


$pdf->Output();
?>