where('setting', 'license_key')->where('module', 'clientx')->first(); if (!empty($getLicenseDetail)) { $CLIENTX = new CLASS_CLIENTX_INVOICE(); $license = $CLIENTX->wgs_clientx_get_license($getLicenseDetail->value); $status = trim($license['status']); if ($status == 'Active') $addonActivate = true; } } if (!empty($addonActivate)) { $getSetting = Capsule::table('mod_clientx_setting')->get(); $settings = []; foreach ($getSetting as $key => $setting) { $settings[$setting->setting] = $setting->value; } $width = 75; $heights = 25; if(!empty($settings['invoice_logo_width'])){ $width = str_replace("px","",$settings['invoice_logo_width']); } if(!empty($settings['invoice_logo_height'])){ $heights = str_replace("px","",$settings['invoice_logo_height']); } if(!empty($settings['invoice_logo'])){ $imageLink = $settings['invoice_logo']; $htmlImg = ''; $pdf->writeHTML($htmlImg, true, 0, true, 0); }else{ $logoFilename = 'placeholder.png'; if (file_exists(ROOTDIR . '/assets/img/logo.png')) { $logoFilename = 'logo.png'; } elseif (file_exists(ROOTDIR . '/assets/img/logo.jpg')) { $logoFilename = 'logo.jpg'; } if($width == 75 && $heights == 25){ $pdf->Image(ROOTDIR . '/assets/img/' . $logoFilename, 15, 25, 75); }else{ $imageLinkE = ROOTDIR . '/assets/img/' . $logoFilename; $htmlImgE = ''; $pdf->writeHTML($htmlImgE, true, 0, true, 0); } } }else{ # Logo $logoFilename = 'placeholder.png'; if (file_exists(ROOTDIR . '/assets/img/logo.png')) { $logoFilename = 'logo.png'; } elseif (file_exists(ROOTDIR . '/assets/img/logo.jpg')) { $logoFilename = 'logo.jpg'; } $pdf->Image(ROOTDIR . '/assets/img/' . $logoFilename, 15, 25, 75); } if (file_exists(dirname(dirname(__DIR__))) . '/modules/addons/gsttax/classes/class.php') { require_once dirname(dirname(__DIR__)) . '/modules/addons/gsttax/classes/class.php'; $GST_TAX = new GST_TAX(); $gstIn = $GST_TAX->getAddonModuleSetting('gst_in'); $oldTaxNumber = $GST_TAX->getAddonModuleSetting('old_tax_number'); $sacCode = $GST_TAX->getAddonModuleSetting('hsn_code'); $count = $GST_TAX->getAddonModuleSetting(); $licensekey = $GST_TAX->getAddonModuleSetting('license_key'); $licenseStatus = $GST_TAX->license($licensekey); if (isset($_GET['id']) && !empty($_GET['id'])) $invoiceId = $_GET['id']; else { $invoiceId = $id; } if (isset($invoiceId) && !empty($invoiceId)) { if (!empty($invoiceId)) { $data = Capsule::table('tblinvoices')->where('id', $invoiceId)->get(); if ((float) $data[0]->tax > 0 || (float) $data[0]->tax2 > 0) { $currencyData = getCurrency($data[0]->userid); $totalTaxInt = (float) $data[0]->tax + (float) $data[0]->tax2; $totalTax = formatCurrency($totalTaxInt, $currencyData['id']); } $invoiceData = (array) $data[0]; $invoiceDate = date("d-m-Y", strtotime($invoiceData['date'])); if (strtotime($invoiceDate) <= strtotime('30-06-2017')) { $taxlabel1 = $GST_TAX->getAddonModuleSetting('taxlabel1'); $taxlabel2 = $GST_TAX->getAddonModuleSetting('taxlabel2'); } else { $getGstInvoice = $GST_TAX->GstGetGstInoive('i-' . $invoiceId); if ($getGstInvoice['taxname']) $taxname = $getGstInvoice['taxname']; else { if ($taxrate) { $taxname = $GST_TAX->gstGetTaxName($taxrate, 1); } } if ($getGstInvoice['taxname2']) $taxname2 = $getGstInvoice['taxname2']; else { if ($taxrate2) { $taxname2 = $GST_TAX->gstGetTaxName($taxrate2, 2); } } } } } } $clientCountry = Capsule::table('tblclients')->where('id', $data[0]->userid)->first(); # Tax invoice Heading if ($clientCountry->country == 'IN') { if ($count > 0 && file_exists(dirname(dirname(__DIR__)) . '/modules/addons/gsttax/gsttax.php') && $licenseStatus['status'] == 'Active' && strtotime($invoiceDate) > strtotime('30-06-2017') && ($taxname == 'IGST' || $taxname == 'CGST' || $taxname == 'SGST' )) { $getEnableProformaInvoicing = $GST_TAX->gstGetEnableProformaInvoicing(); if ($getEnableProformaInvoicing['value'] == '1' && $status == 'Paid') { $pdf->SetFont($pdfFont, '', 15); $pdf->SetXY(12, 12); $pdf->Cell(0, 15, 'TAX INVOICE', 0, false, 'C', 0, '', 0, false, 'M', 'T'); }elseif($getEnableProformaInvoicing['value'] != '1'){ $pdf->SetFont($pdfFont, '', 15); $pdf->SetXY(12, 12); $pdf->Cell(0, 15, 'TAX INVOICE', 0, false, 'C', 0, '', 0, false, 'M', 'T'); } } } # Invoice Status $pdf->SetXY(0, 0); $pdf->SetFont($pdfFont, 'B', 28); $pdf->SetTextColor(255); $pdf->SetLineWidth(0.75); $pdf->StartTransform(); $pdf->Rotate(-35, 100, 225); if ($status == 'Draft') { $pdf->SetFillColor(200); $pdf->SetDrawColor(140); } elseif ($status == 'Paid') { $pdf->SetFillColor(151, 223, 74); $pdf->SetDrawColor(110, 192, 70); } elseif ($status == 'Cancelled') { $pdf->SetFillColor(200); $pdf->SetDrawColor(140); } elseif ($status == 'Refunded') { $pdf->SetFillColor(131, 182, 218); $pdf->SetDrawColor(91, 136, 182); } elseif ($status == 'Collections') { $pdf->SetFillColor(3, 3, 2); $pdf->SetDrawColor(127); } else { $pdf->SetFillColor(223, 85, 74); $pdf->SetDrawColor(171, 49, 43); } $pdf->Cell(100, 18, strtoupper(Lang::trans('invoices' . strtolower($status))), 'TB', 0, 'C', '1'); $pdf->StopTransform(); $pdf->SetTextColor(0); # Company Details $pdf->SetXY(15, 42); $pdf->SetFont($pdfFont, '', 13); foreach ($companyaddress as $addressLine) { $pdf->Cell(180, 4, trim($addressLine), 0, 1, 'R'); $pdf->SetFont($pdfFont, '', 9); } $addonActive = false; $oldVat = false; if ($clientCountry->country == 'IN') { if ($count > 0 && file_exists(dirname(dirname(__DIR__)) . '/modules/addons/gsttax/gsttax.php') && $licenseStatus['status'] == 'Active' && strtotime($invoiceDate) > strtotime('30-06-2017') && ($taxname == 'IGST' || $taxname == 'CGST' || $taxname == 'SGST' )) { $addonActive = true; $clientDetail = $GST_TAX->gstGetClientDetail($invoiceData['userid']); if (!empty($clientDetail['currency'])) $currencyId = $clientDetail['currency']; else { $currenyIdQuery = Capsule::table('tblcurrencies')->where('default', '1')->first(); $currencyId = $currenyIdQuery->id; } $getCurrencyCode = $GST_TAX->gstGetCurrencyCode($currencyId); if ((float) $invoiceData['credit'] > 0) { $wgs_gst_credit = formatCurrency($invoiceData['credit'], $currencyId); $creditDetail = $GST_TAX->wgsGstGetAppliedCreditDetail($invoiceData['id'], $invoiceData['credit'], $invoiceData['userid']); $transsactionCount = count($transactions); $date = date_create($creditDetail['date']); if ($transsactionCount > 0) $transactions[$transsactionCount] = array( 'id' => $creditDetail['id'], 'date' => date_format($date, "d/m/Y"), 'gateway' => 'Funds Applied', 'transid' => ' ', 'amount' => formatCurrency($invoiceData['credit'], $currencyId) ); else $transactions[0] = array( 'id' => $creditDetail['id'], 'date' => date_format($date, "d/m/Y"), 'gateway' => 'Funds Applied', 'transid' => ' ', 'amount' => formatCurrency($invoiceData['credit'], $currencyId) ); $wgs_gst_invoicetotal = formatCurrency(($invoiceData['tax'] + $invoiceData['tax2'] + $invoiceData['subtotal']), $currencyId); $invoiceData['total'] = ($invoiceData['tax'] + $invoiceData['tax2'] + $invoiceData['subtotal']); } $totalAmountInWords = $GST_TAX->GstNumberToWords($invoiceData['total']); $sign_image = $GST_TAX->gstGetSign(); $pdf->Ln(2); $pdf->SetFont($pdfFont, '', 10); $pdf->Cell(180, 6, 'GSTIN' . ': ' . $gstIn, 0, 1, 'R'); $pdf->Ln(5); /* $pdf->Ln(5); $pdf->SetXY(15, 55); $pdf->SetFillColor(239); $pdf->SetFont($pdfFont, '', 10); $pdf->Cell(65, 6, 'GSTIN' . ': ' . $gstIn, 10, 1, 'L', '1'); $pdf->Ln(10); */ } elseif ($count > 0 && file_exists(dirname(dirname(__DIR__)) . '/modules/addons/gsttax/gsttax.php') && $licenseStatus['status'] == 'Active' && strtotime($invoiceDate) <= strtotime('30-06-2017')) { $addonActive = true; $oldVat = true; if ($oldTaxNumber) { $pdf->Ln(2); $pdf->SetFont($pdfFont, '', 10); $pdf->Cell(180, 6, 'Service tax number' . ': ' . $oldTaxNumber, 0, 1, 'R'); $pdf->Ln(5); /* $pdf->Ln(5); $pdf->SetXY(15, 55); $pdf->SetFillColor(239); $pdf->SetFont($pdfFont, '', 10); $pdf->Cell(60, 6, 'Service tax number' . ': ' . $oldTaxNumber, 10, 1, 'L', '1'); $pdf->Ln(10); */ } else { $pdf->Ln(5); } } } # Header Bar /** * Invoice header * * You can optionally define a header/footer in a way that is repeated across page breaks. * For more information, see http://docs.whmcs.com/PDF_Invoice#Header.2FFooter */ $pdf->SetFont($pdfFont, 'B', 15); $pdf->SetFillColor(239); $pdf->Cell(0, 8, $pagetitle, 0, 1, 'L', '1'); $pdf->SetFont($pdfFont, '', 10); if($status == 'Paid') $pdf->Cell(0, 6, Lang::trans('invoicesdatecreated') . ': ' . substr($datepaid,0,10), 0, 1, 'L', '1'); else $pdf->Cell(0, 6, Lang::trans('invoicesdatecreated') . ': ' . $datecreated, 0, 1, 'L', '1'); $pdf->Cell(0, 6, Lang::trans('invoicesdatedue') . ': ' . $duedate, 0, 1, 'L', '1'); $pdf->Ln(5); $startpage = $pdf->GetPage(); # Clients Details $addressypos = $pdf->GetY(); $pdf->SetFont($pdfFont, 'B', 10); $pdf->Cell(0, 4, Lang::trans('invoicesinvoicedto'), 0, 1); $pdf->SetFont($pdfFont, '', 9); if ($clientsdetails["companyname"]) { $pdf->Cell(0, 4, $clientsdetails["companyname"], 0, 1, 'L'); $pdf->Cell(0, 4, Lang::trans('invoicesattn') . ': ' . $clientsdetails["firstname"] . ' ' . $clientsdetails["lastname"], 0, 1, 'L'); } else { $pdf->Cell(0, 4, $clientsdetails["firstname"] . " " . $clientsdetails["lastname"], 0, 1, 'L'); } $pdf->Cell(0, 4, $clientsdetails["address1"], 0, 1, 'L'); if ($clientsdetails["address2"]) { $pdf->Cell(0, 4, $clientsdetails["address2"], 0, 1, 'L'); } $pdf->Cell(0, 4, $clientsdetails["city"] . ", " . $clientsdetails["state"] . ", " . $clientsdetails["postcode"], 0, 1, 'L'); $pdf->Cell(0, 4, $clientsdetails["country"], 0, 1, 'L'); if ($customfields) { $pdf->Ln(); $gst_in = 'no'; if (!empty($addonActive) && empty($oldVat)) { foreach ($customfields as $customfield) { if ($customfield['fieldname'] == 'GSTIN') $gst_in = 'yes'; if ($customfield['fieldname'] == 'GSTIN' || $customfield['fieldname'] == 'Place of supply') { $pdf->Cell(0, 4, $customfield['fieldname'] . ': ' . $customfield['value'], 0, 1, 'L'); } else { $pdf->Cell(0, 4, $customfield['fieldname'] . ': ' . $customfield['value'], 0, 1, 'L'); } if ($gst_in == 'no') { $pdf->Cell(0, 4, 'GSTIN: Not Available', 0, 1, 'L'); } } } else { foreach ($customfields as $customfield) { if ($customfield['fieldname'] != 'GSTIN' && $customfield['fieldname'] != 'Place of supply') { $pdf->Cell(0, 4, $customfield['fieldname'] . ': ' . $customfield['value'], 0, 1, 'L'); } } } } else { if (!empty($addonActive)) { $pdf->Cell(0, 4, 'GSTIN: Not Available', 0, 1, 'L'); } } $pdf->Ln(10); if (!empty($addonActive) && empty($oldVat) && ($taxname == 'IGST' || $taxname == 'CGST' || $taxname == 'SGST' )) { $tblhtml = ' '; foreach ($invoiceitems as $key => $item) { $tblhtml .= ' '; } $tblhtml .= ''; if (isset($wgs_gst_invoicetotal) && !empty($wgs_gst_invoicetotal)) $tblhtml .= ''; else $tblhtml .= ''; $tblhtml .= ''; if ($totalAmountInWords && $getCurrencyCode == 'INR') { $tblhtml .= ''; } $tblhtml .=' '; $tblhtml .= '

' . Lang::trans('invoicesdescription') . '	Item type	SAC Code	' . Lang::trans('quotelinetotal') . '
' . nl2br($item['description']) . '	'; if (strpos(nl2br(strtolower($item['description'])), 'website design') !== false) $tblhtml .= 'Website Design'; elseif (strpos(nl2br(strtolower($item['description'])), 'web development') !== false) $tblhtml .= 'Web Development'; elseif (strpos(nl2br(strtolower($item['description'])), 'seo') !== false) $tblhtml .= 'SEO'; elseif (strpos(nl2br(strtolower($item['description'])), 'amc') !== false) $tblhtml .= 'AMC'; else $tblhtml .= $item['type']; $tblhtml .= '	'; if (strpos(nl2br(strtolower($item['description'])), 'website design') !== false || strpos(nl2br(strtolower($item['description'])), 'web development') !== false || strpos(nl2br(strtolower($item['description'])), 'seo') !== false || strpos(nl2br(strtolower($item['description'])), 'amc') !== false) $tblhtml .= '998314'; elseif ($item['type'] == 'Hosting') $tblhtml .= '998315'; elseif (strpos($item['type'], 'Domain') !== false || strpos($item['type'], 'Addon') !== false) $tblhtml .= '998319'; else $tblhtml .= '';//'998313'; $tblhtml .= '	' . $item['amount'] . '
' . Lang::trans('invoicessubtotal') . '			' . $subtotal . '
GST	CGST'; if ($taxrate && $taxname == 'CGST') { $tblhtml .= ' (' . $taxrate . '%)'; } else { $nbsp; } $tblhtml .= ' SGST'; if ($taxrate2 && $taxname2 == 'SGST') { $tblhtml .= ' (' . $taxrate2 . '%)'; } else { $nbsp; } $tblhtml .= ' IGST'; if ($taxrate && $taxname == 'IGST') { $tblhtml .= ' (' . $taxrate . '%)'; } else { $nbsp; } $tblhtml .= ' '; if ($taxrate && $taxname == 'CGST') { $tblhtml .= $tax; } else { $nbsp; } $tblhtml .= ' '; if ($taxrate2 && $taxname2 == 'SGST') { $tblhtml .= $tax2; } else { $nbsp; } $tblhtml .= ' '; if ($taxrate && $taxname == 'IGST') { $tblhtml .= $tax; } else { $nbsp; } $tblhtml .= '		' . $totalTax . '
Total Amount Incl. GST :			' . $wgs_gst_invoicetotal . '	' . $total . '
Total Amount Incl. GST (in words):	' . $totalAmountInWords . '
Funds Applied			' . $credit . '

'; //echo $tblhtml;exit; } else { # Invoice Items $tblhtml .= ''; foreach ($invoiceitems as $item) { $tblhtml .= ' '; } $tblhtml .= ' '; if ($taxname) { $tblhtml .= ' '; if (!empty($addonActive) && !empty($oldVat)) $tblhtml .= ''; else $tblhtml .= ''; $tblhtml .= ''; } if ($taxname2) { $tblhtml .= ' '; if (!empty($addonActive) && !empty($oldVat)) $tblhtml .= ''; else $tblhtml .= ''; $tblhtml .= ''; } $tblhtml .= '

' . Lang::trans('invoicesdescription') . '	' . Lang::trans('quotelinetotal') . '
' . nl2br($item['description']) . '	' . $item['amount'] . '
' . Lang::trans('invoicessubtotal') . '	' . $subtotal . '
' . $taxlabel1 . '	' . $taxrate . '% ' . $taxname . '	' . $tax . '
' . $taxlabel2 . '	' . $taxrate2 . '% ' . $taxname2 . '	' . $tax2 . '
' . Lang::trans('invoicescredit') . '	' . $credit . '
' . Lang::trans('invoicestotal') . '	' . $total . '

'; } $pdf->writeHTML($tblhtml, true, false, false, false, ''); $pdf->Ln(3); if (count($transactions)) { # Transactions $pdf->SetFont($pdfFont, 'B', 12); $pdf->Cell(0, 4, Lang::trans('invoicestransactions'), 0, 1); $pdf->Ln(3); $pdf->SetFont($pdfFont, '', 9); $tblhtml = ''; foreach ($transactions AS $trans) { $tblhtml .= ' '; } $tblhtml .= '

' . Lang::trans('invoicestransdate') . '	' . Lang::trans('invoicestransgateway') . '	' . Lang::trans('invoicestransid') . '	' . Lang::trans('invoicestransamount') . '
' . $trans['date'] . '	' . $trans['gateway'] . '	' . $trans['transid'] . '	' . $trans['amount'] . '
' . Lang::trans('invoicesbalance') . '			' . $balance . '

'; }else{ $tblhtml = '

' . Lang::trans('invoicesbalance') . '

' . $balance . '

'; } if (!empty($sign_image)) { $tblhtml .= '

Authorized Signatory

'; } //echo $tblhtml;die(); $pdf->writeHTML($tblhtml, true, false, false, false, ''); # Notes if ($notes) { $pdf->Ln(5); $pdf->SetFont($pdfFont, '', 8); $pdf->MultiCell(170, 5, Lang::trans('invoicesnotes') . ': ' . $notes); } if ($data[0]->userid) { $clientCountry = Capsule::table('tblclients')->where('id', $data[0]->userid)->first(); # Tax invoice Heading if ($clientCountry->country == 'IN') { if ($count > 0 && file_exists(dirname(dirname(__DIR__)) . '/modules/addons/gsttax/gsttax.php') && $licenseStatus['status'] == 'Active' && strtotime($invoiceDate) > strtotime('30-06-2017') && ($taxname == 'IGST' || $taxname == 'CGST' || $taxname == 'SGST' )) { $getEnableProformaInvoicing = $GST_TAX->gstGetEnableProformaInvoicing(); if ($getEnableProformaInvoicing['value'] == '1' && $status != 'Paid') { $pdf->SetFont($pdfFont, '', 8); $pdf->Ln(5); $pdf->Cell(180, 4, 'The invoice is computer generated invoice as proforma invoice and can not be used for tax purpose.', '', '', 'C'); } } } } # Generation Date $pdf->SetFont($pdfFont, '', 8); $pdf->Ln(5); $pdf->Cell(180, 4, Lang::trans('invoicepdfgenerated') . ' ' . getTodaysDate(1), '', '', 'C'); /** * Invoice footer */ ?>