EVOLUTION-NINJA

Edit File: pdf_convert.php

<?php

//$logo_url = URL::to('assets/uploads/logo.png');
include("assets/mpdf60/mpdf.php");

//$mpdf=new mPDF('c','A4','','',32,25,47,47,10,10); 
$mpdf = new mPDF('c', 'A4-L'); 
$mpdf->mirrorMargins = 1;
$cts=0; $tax=0;  $inv=0; $fri=0; $paid=0; $due=0; $base=0; $base1=0; $tv1 =0;

$html = '';
$index = 1;
$html=$html.'<html><head></head><body>';
$html=$html.'<h3 style="text-align:center; color:blue;">PURCHASE ORDER</h3>';

$html=$html.'<table style="border-collapse: collapse;border:1px solid #000;width:100%;">';
$html = $html.'<tr><td style="border-right:1px solid #000;width:50%;padding:5px;">Yaskawa India Private Limited</td>';
$html = $html.'<td style="padding:5px;width:50%;">P. O. No# <span style="float:right;">'.$po.'</span></td></tr>';
$html = $html.'<tr><td style="border-right:1px solid #000;width:50%;padding:5px;">Plot No. 17/A, Electronic City, Phase I, Bangalore</td>';
$html = $html.'<td style="padding:5px;width:50%;">Date <span style="float:right;">'.date("d-m-Y").'</span></td></tr>';

$html = $html.'<tr><td style="border-right:1px solid #000;width:50%;padding:5px;">Tel : (080) 2200-0000, Fax : (080) 2200-0000</td>';
$html = $html.'<td style="padding:5px;width:50%;">Your Ref#</td></tr>';

$html = $html.'<tr><td style="border-right:1px solid #000;width:50%;padding:5px;">GSTIN -29AAACY4408P1ZR</td>';
$html = $html.'<td style="padding:5px;width:50%;">Our Ref#</td></tr></table>';
 
$html = $html.'<table style="border-collapse: collapse;border:1px solid #000;width:100%;margin-top:20px;"><tr>';
$html = $html.'<td style="width:50%;padding:5px;">Transaction Type</td>';
$html = $html.'<td style="padding:5px;width:50%;">Domestic</td></tr>';
$html = $html.'<tr><td style="width:50%;padding:5px;">Nature of Transaction</td>';

$html = $html.'<td style="padding:5px;width:50%;">Inter-State Purchase / Intra-State Purchase</td></tr>';
$html = $html.'<tr><td style="width:50%;padding:5px;">Nature of Supply</td>';

$html = $html.'<td style="padding:5px;width:50%;">Goods / Services / Goods & Services</td></tr></table>';
$html = $html.'<table style="border-collapse: collapse;width:100%;"><tr>';

$html = $html.'<td style="padding:5px 0px;width:50%;"><b><em>Billing To</em></b></td>';
$html = $html.'<td style="padding:5px 0px;width:50%;"><b><em>Deliver To</em></b></td></tr></table>';

$html = $html.'<table style="border-collapse: collapse;border:1px solid #000;width:100%;"><tr>';
$html = $html.'<td style="padding:5px;width:50%;border-right:1px solid #000;"><b>'.$address->billadd1.'</b></td>';
$html=$html.'<td style="padding:5px;width:50%;"><b>'.$address->shipadd1.'</b></td></tr>';
$html=$html.'<tr><td style="padding:5px;width:50%;border-right:1px solid #000;">'.$address->billadd2.'</td>';
$html = $html.'<td style="padding:5px;width:50%;">'.$address->shipadd2.'</td></tr>';
$html = $html.'<tr><td style="padding:5px;width:50%;border-right:1px solid #000;">State Code: '.$address->billstate_code.'</td>';
$html = $html.'<td style="padding:5px;width:50%;">State Code: '.$address->shipstate_code.'</td></tr>';
$html = $html.'<tr><td style="padding:5px;width:50%;border-right:1px solid #000;">India</td>';
$html = $html.'<td style="padding:5px;width:50%;">India</td></tr>';
$html = $html.'<tr><td style="padding:5px;width:50%;border-right:1px solid #000;">GSTIN: '.$address->billadd5.'</td>';
$html = $html.'<td style="padding:5px;width:50%;">GSTIN: '.$address->shipadd5.'</td></tr></table>';

$html = $html.'<table style="border-collapse: collapse;width:100%;"><tr>';

$html = $html.'<td style="padding:5px 0px;width:50%;">Attention To : Contact Person/ contact no /email-id</td>';
$html = $html.'<td style="padding:5px 0px;width:50%;">Attention To : Contact Person</td></tr></table>';

$html = $html.'<table style="border-collapse: collapse;width:100%;border:1px solid #000;"><tr>';
$html = $html.'<th style="border:1px solid #000;padding:3px;">HSN/SA CODE</th>';
$html = $html.'<th style="border:1px solid #000;padding:3px;">Description</th>';
$html = $html.'<th style="border:1px solid #000;padding:3px;">Qty</th>';
$html = $html.'<th style="border:1px solid #000;padding:3px;">Date</th>';
$html = $html.'<th style="border:1px solid #000;padding:3px;">Unit</th>';
$html = $html.'<th style="border:1px solid #000;padding:3px;">Unit<br>Price</th>';
$html = $html.'<th style="border:1px solid #000;padding:3px;">Trade<br>Discount</th>';
$html = $html.'<th style="border:1px solid #000;padding:3px;">Cash<br>Discount</th>';
$html = $html.'<th style="border:1px solid #000;padding:3px;">Unit Net<br>Price</th>';
$html = $html.'<th style="border:1px solid #000;padding:3px;">Base<br>Price</th>';
$html = $html.'<th style="border:1px solid #000;padding:3px;">IGST<br>Rate</th>';
$html = $html.'<th style="border:1px solid #000;padding:3px;">IGST<br>Amount</th>';
$html = $html.'<th style="border:1px solid #000;padding:3px;">SGST<br>Rate</th>';
$html = $html.'<th style="border:1px solid #000;padding:3px;">SGST<br>Amount</th>';
$html = $html.'<th style="border:1px solid #000;padding:3px;">CGST<br>Rate</th>';
$html = $html.'<th style="border:1px solid #000;padding:3px;">CGST<br>Amount</th>';
$html = $html.'<th style="border:1px solid #000;padding:3px;">Total<br>Amount</th>';

$html = $html.'</tr>';
foreach($po_details as $ct){
$base = $ct->base;
$base1 = str_replace( ',', '', $base );
$html = $html.'<tr>';
$html = $html.'<td style="border:1px solid #000;padding:3px;">'.$ct->hsn.'</td>';
$html = $html.'<td style="border:1px solid #000;padding:3px;">'.$ct->description.'</td>';
$html = $html.'<td style="border:1px solid #000;padding:3px;">'.$ct->quantity.'</td>';
$html = $html.'<td style="border:1px solid #000;padding:3px;">'.$ct->delivery_date.'</td>';
$html = $html.'<td style="border:1px solid #000;padding:3px;">'.$ct->unit.'</td>';
$html = $html.'<td style="border:1px solid #000;padding:3px;">'.$ct->price.'</td>';
$html = $html.'<td style="border:1px solid #000;padding:3px;">'.$ct->trade.'</td>';
$html = $html.'<td style="border:1px solid #000;padding:3px;">'.$ct->cash.'</td>';
$html = $html.'<td style="border:1px solid #000;padding:3px;">'.$ct->net.'</td>';
$html = $html.'<td style="border:1px solid #000;padding:3px;">'.$ct->base.'</td>';
$html = $html.'<td style="border:1px solid #000;padding:3px;">'.$ct->igst.'</td>';
if($ct->igst > 0){
	$c=(($base1 * $ct->igst)/100);
}
else
{
	$c=0;
}
$html = $html.'<td style="border:1px solid #000;padding:3px;">'.$c.'</td>';
$html = $html.'<td style="border:1px solid #000;padding:3px;">'.$ct->sgst.'</td>';
if($ct->sgst > 0){
	$a=(($base1 * $ct->sgst)/100);
}
else
{
	$a=0;
}
$html = $html.'<td style="border:1px solid #000;padding:3px;">'.$a.'</td>';
$html = $html.'<td style="border:1px solid #000;padding:3px;">'.$ct->cgst.'</td>';
if($ct->cgst > 0){
	$b=(($base1 * $ct->cgst)/100);
}
else
{
	$b=0;
}
$html = $html.'<td style="border:1px solid #000;padding:3px;">'.$b.'</td>';

$tv=$base1 +$a+$b+$c;
$tv1 = str_replace( ',', '', $tv);
$html = $html.'<td style="border:1px solid #000;padding:3px;">'.$tv1.'</td>';
$cts=$cts+$tv;									
$inv=$ct->invoice;
$fri=$ct->frieght;
$paid=$ct->paid;
$due=$ct->due;

$html = $html.'</tr>';
}

$html = $html.'<tr><td colspan="4" rowspan="7" style="border:1px solid #000;padding:3px;">Comments:';
foreach($po_details as $pos) {
	$html= $html.$pos->note;
	break; }
$html = $html.'</td>';
$html = $html.'<td colspan="12" style="border:1px solid #000;padding:3px;">Sub Total</td>';

$html = $html.'<td style="border:1px solid #000;padding:3px;">'.$cts.'</td></tr>';

$html=$html.'<tr><td colspan="12" style="border:1px solid #000;padding:3px;">Freight</td>';
$html= $html.'<td style="border:1px solid #000;padding:3px;">'.$fri.'</td></tr>';

$html= $html.'<tr><td colspan="12" style="border:1px solid #000;padding:3px;">Invoice Total</td>';
$html= $html.'<td style="border:1px solid #000;padding:3px;">'.$inv.'</td></tr>';

$html=$html.'<tr><td colspan="12" style="border:1px solid #000;padding:3px;">Amount Paid</td>';
$html=$html.'<td style="border:1px solid #000;padding:3px;">'.$paid.'</td></tr>';

$html= $html.'<tr><td colspan="12" style="border:1px solid #000;padding:3px;">Balance Due</td>';
$html= $html.'<td style="border:1px solid #000;padding:3px;">'.$due.'</td></tr></table>';

foreach($po_details as $posd) {
$html= $html.'<p style="margin-bottom:3px;">Terms & Conditions</p>';
$html= $html.'<p style="margin-bottom:3px; margin-top:3px;">1. Material Delivery: '.$posd->delivery.'</p>';
$html= $html.'<p style="margin-bottom:3px; margin-top:3px;">2. Tax: '.$posd->taxes.'</p>';
$html= $html.'<p style="margin-bottom:3px; margin-top:3px;">3. Terms of Payment: '.$posd->term.'</p>';
$html= $html.'<p style="margin-bottom:3px; margin-top:3px;">4. Bank Details: '.$posd->bank.'</p>';
break; }
$html= $html.'</body>';

$html= $html.'</html>';

$mpdf->SetDisplayMode('fullpage');

$mpdf->SetWatermarkText('');
$mpdf->watermark_font = 'DejaVuSansCondensed';
$mpdf->showWatermarkText = true;

//$mpdf->WriteHTML($html);
//$mpdf->AddPage();
//
//$mpdf->SetWatermarkImage('tiger.wmf', 1, '', array(160,10));
//$mpdf->showWatermarkImage = true;

$mpdf->WriteHTML($html);
$data = date('d-M-y-H-i');
$file='generated_po/yaskawa'.$data.'PO.pdf';
$mpdf->Output('generated_po/yaskawa'.$data.'PO.pdf', 'F');
$table='po_link';
$data=array('po_no'=>$po,'po_path'=>$file);
$this->model->insert($table,$data);

//redirect('controller/purchase_order');
exit;

//==============================================================
//==============================================================
//==============================================================