Hikashop Orders to Xero Invoices - My Working PHP Code

<?php /** * @package HikaShop for Joomla! * @version 2.3.5 * @author hikashop.com * @copyright (C) 2010-2015 HIKARI SOFTWARE. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?><?php while (ob_get_level() > 1) ob_end_clean(); $config =& hikashop_config(); $format = $config->get('export_format', 'csv'); $separator = $config->get('csv_separator', ';'); $force_quote = $config->get('csv_force_quote', 1); $export = hikashop_get('helper.spreadsheet'); date_default_timezone_set('Africa/Johannesburg'); $export->init($format, 'Hikashop Order Export ' . date('Y-m-d H:i'), $separator, $force_quote); if (!empty($this->orders)) { // // HEADER ROW // $headerRow = array(); $o = reset($this->orders); $o = null; // Add dynamic keys $headerRow[] = 'InventoryItemCode'; $headerRow[] = 'Description'; $headerRow[] = 'Quantity'; $headerRow[] = 'UnitAmount'; $headerRow[] = 'AccountCode'; $headerRow[] = 'TaxType'; // Add static keys $headerRow[] = 'ContactName'; $headerRow[] = 'EmailAddress'; $headerRow[] = 'POAddressLine1'; $headerRow[] = 'POAddressLine2'; $headerRow[] = 'POAddressLine3'; $headerRow[] = 'POAddressLine4'; $headerRow[] = 'POCity'; $headerRow[] = 'POPostalCode'; $headerRow[] = 'POCountry'; $headerRow[] = 'InvoiceNumber'; $headerRow[] = 'Reference'; $headerRow[] = 'InvoiceDate'; $headerRow[] = 'DueDate'; $headerRow[] = 'Currency'; // // WRITE ROW // $export->writeLine($headerRow); // // PROCESS ORDERS // function compileContentLine(&$static, &$variable) { // set dynamic key values $contentRow[InventoryItemCode] = $variable[InventoryItemCode]; $contentRow[Description] = $variable[Description]; $contentRow[Quantity] = $variable[Quantity]; $contentRow[UnitAmount] = $variable[UnitAmount]; $contentRow[AccountCode] = $variable[AccountCode]; $contentRow[TaxType] = $variable[TaxType]; // set static key values $contentRow[ContactName] = $static[ContactName]; $contentRow[EmailAddress] = $static[EmailAddress]; $contentRow[POAddressLine1] = $static[POAddressLine1]; $contentRow[POAddressLine2] = $static[POAddressLine2]; $contentRow[POAddressLine3] = $static[POAddressLine3]; $contentRow[POAddressLine4] = $static[POAddressLine4]; $contentRow[POCity] = $static[POCity]; $contentRow[POPostalCode] = $static[POPostalCode]; $contentRow[POCountry] = $static[POCountry]; $contentRow[InvoiceNumber] = $static[InvoiceNumber]; $contentRow[Reference] = $static[Reference]; $contentRow[InvoiceDate] = $static[InvoiceDate]; $contentRow[DueDate] = $static[DueDate]; $contentRow[Currency] = $static[Currency]; return $contentRow; } function checkIfInternational($ShippingName) { if (strpos($ShippingName, 'International Courier') !== false) { $variable[AccountCode] = 260; $variable[TaxType] = 'Tax Exempt'; } else { $variable[AccountCode] = 200; $variable[TaxType] = 'Tax on Sales'; } return $variable; } foreach ($this->orders as $orderRow) { // skip if order is "processed" if ($orderRow->order_status === 'processed') { continue; } else { // // STATIC VALUES // $static[ContactName] = $orderRow->billing_address_firstname . ' ' . $orderRow->billing_address_lastname; $static[EmailAddress] = $orderRow->user_email; $static[POAddressLine1] = $orderRow->billing_address_street; $static[POAddressLine2] = $orderRow->billing_address_state . ', ' . $orderRow->billing_address_post_code . ', ' . $orderRow->billing_address_country; $static[POAddressLine3] = ' ~ SHIP TO: ' . strtoupper($orderRow->shipping_address_firstname) . ' ' . strtoupper($orderRow->shipping_address_lastname) . ', ' . $orderRow->shipping_address_telephone . ($orderRow->shipping_address_telephone2 == NULL ? '' : ' OR ' . $orderRow->shipping_address_telephone2); $static[POAddressLine4] = strtoupper($orderRow->shipping_address_street); $static[POCity] = $orderRow->shipping_address_state; $static[POPostalCode] = $orderRow->shipping_address_post_code; $static[POCountry] = $orderRow->shipping_address_country; $static[InvoiceNumber] = 'OIK' . $orderRow->order_number; // prepare order weight for reference $totalProducts = count($orderRow->products); $totalWeight = 0; for ($i = 1; $i <= $totalProducts; $i++) { $orderProduct = $orderRow->products[$i - 1]; $hikaProductClass = hikashop_get('class.product'); // get hikashop product class $hikaProduct = $hikaProductClass->get($orderProduct->product_id); $totalWeight += $hikaProduct->product_weight * $orderProduct->order_product_quantity; } // prepare shipping class object and courier service required for reference $hikaShippingClass = hikashop_get('class.shipping'); $orderShipping = $hikaShippingClass->get($orderRow->order_shipping_id); if (strpos($orderShipping->shipping_name, 'Courier (L') !== false) { if ($totalWeight < 1) { $serviceRequired = '| Service: LOF | '; } else { $serviceRequired = '| Service: LOX | '; } } elseif (strpos($orderShipping->shipping_name, 'International Courier') !== false) { $serviceRequired = '| Aramex waybill no. 00000000000 | '; } else { if ($totalWeight < 2) { $serviceRequired = '| Service: OVN | '; } elseif ($totalWeight < 6) { $serviceRequired = '| Service: AIR | '; } elseif ($totalWeight >= 6) { $serviceRequired = '| Service: ECO | '; } else { $serviceRequired = '| '; } } $orderNotes = trim($orderRow->notes); $orderNotes = ($orderNotes !== '') ? ' ' . $orderNotes : $orderNotes; $static[Reference] = $serviceRequired . 'Mass: ' . round($totalWeight, 2) . 'KG | Pieces: 1' . ' | Reference: order:0' . $orderRow->order_id . ' - ' . $orderRow->user_email . ' | Parcel Description: Educational Text books | Special Instructions: Please phone receiver before delivering.' . $orderNotes . ' |'; // prepare order date format if (!empty($orderRow->order_created)) { $order_created_date = hikashop_getDate($orderRow->order_created, '%Y-%m-%d'); // Assign Hikashop getDate function result to variable $order_created_date = new DateTime($order_created_date); // Change variable to DateTime object $order_created_date = $order_created_date->format('d M Y'); // Change output format of datetime object to 01 Mon YYYY $orderRow->order_created = $order_created_date; // Assign this date to $orderRow array } if (!empty($orderRow->order_modified)) { $order_modified_date = hikashop_getDate($orderRow->order_modified, '%Y-%m-%d'); // Assign Hikashop getDate function result to variable $order_modified_date = new DateTime($order_modified_date); // Change variable to DateTime object $order_modified_date = $order_modified_date->format('d M Y'); // Change output format of datetime object to 01 Mon YYYY $orderRow->order_modified = $order_modified_date; // Assign this date to $orderRow array } $static[InvoiceDate] = $orderRow->order_created; $static[DueDate] = $orderRow->order_modified; $static[Currency] = 'ZAR'; // // PRODUCT ROWS // $TaxType = checkIfInternational($orderShipping->shipping_name); for ($i = 1; $i <= $totalProducts; $i++) { // prepare dynamic key values $orderProduct = $orderRow->products[$i - 1]; $variable[InventoryItemCode] = $orderProduct->order_product_code; $variable[Description] = $orderProduct->order_product_name; $variable[Quantity] = $orderProduct->order_product_quantity; $variable[UnitAmount] = $orderProduct->order_product_price + $orderProduct->order_product_tax; // Check if children at risk if ($orderProduct->order_product_code === 'R10_donation_to_children_at_risk') { $variable[AccountCode] = 250; $variable[TaxType] = 'Tax Exempt'; } else { $variable[AccountCode] = $TaxType[AccountCode]; $variable[TaxType] = $TaxType[TaxType]; } $export->writeLine(compileContentLine($static, $variable)); } // // SHIPPING ROW // // prepare dynamic key values $variable[InventoryItemCode] = 'Shipping - ' . $orderShipping->shipping_name; $variable[Description] = $orderShipping->shipping_name; $variable[Quantity] = 1; $variable[UnitAmount] = $orderRow->order_shipping_price; // Check if international $variable[AccountCode] = $TaxType[AccountCode]; $variable[TaxType] = $TaxType[TaxType]; $export->writeLine(compileContentLine($static, $variable)); // // ADMIN FEE ROW // // prepare dynamic key values $variable[InventoryItemCode] = 'ADMIN-FEE'; $variable[Description] = 'Admin fee'; $variable[Quantity] = 1; $variable[UnitAmount] = $orderRow->order_payment_price; // Check if international $variable[AccountCode] = $TaxType[AccountCode]; $variable[TaxType] = $TaxType[TaxType]; $export->writeLine(compileContentLine($static, $variable)); } } } $export->send(); exit;