function processFile($filename)
{
//extract the filename to get the exact filename on the folder
$newFile = substr($filename, 3);
$dirname = substr($filename, 0, 2);
$fs = new Filesystem();
if ($fs->exists('../Repo/' . $dirname . '/' . $newFile)) {
$xml = simplexml_load_file('../Repo/' . $dirname . '/' . $newFile, null, LIBXML_NOCDATA);
$newXML = json_decode(json_encode($xml), true);
$data = formulateData($newXML, $dirname);
//insert data to db
$po = new PurchaseOrder();
$po->setFilename($newFile);
$po->setStore($dirname);
$po->setCustomerCode($data['customer_code']);
$po->setDeliveryDate($data['delivery_date']);
$po->setNumber($data['number']);
$po->save();
$po_id = $po->getId();
//insert all items
foreach ($data['items'] as $key => $value) {
$items = new Item();
$items->setPurchaseOrderId($po_id);
$items->setUpc($value['upc']);
$items->setQty($value['qty']);
$items->setQty($value['discount']);
$items->save();
}
$formulated_data = formulateData($newXML, $dirname);
$formulated_data['id'] = $po_id;
//print_r($formulated_data);
return $formulated_data;
}
}
/**
* function to generate inventory (quote,invoice,sales order,purchase order) PDF
* @param integer $idquotes
* @param boolean $save
* @see http://www.mpdf1.com/mpdf/index.php
*/
public function generate_inventory_pdf($idrecord, $idmodule, $save = false)
{
include_once BASE_PATH . THIRD_PARTY_LIB_PATH . "/mpdf/mpdf.php";
//echo BASE_PATH.THIRD_PARTY_LIB_PATH ;exit;
$pdf = new \mPDF();
$crm_global_settings = new \CRMGlobalSettings();
if ($idmodule == 13) {
$obj = new \Quotes();
$obj->getId($idrecord);
$prefix = $crm_global_settings->get_setting_data_by_name('quote_num_prefix');
$inventory_type = _('QUOTE');
$inv = 'q';
$inv_number_fld = 'quote_number';
$inv_date_fld = 'valid_till';
$file_name = 'Quote_' . $prefix . $obj->quote_number . '.pdf';
$inventory_number = _('Quote #');
} elseif ($idmodule == 14) {
$obj = new \SalesOrder();
$obj->getId($idrecord);
$prefix = $crm_global_settings->get_setting_data_by_name('salesorder_num_prefix');
$inventory_type = _('SALES ORDER');
$inv = 'so';
$inv_number_fld = 'sales_order_number';
$inv_date_fld = 'due_date';
$file_name = 'SalesOrder_' . $prefix . $obj->sales_order_number . '.pdf';
$inventory_number = _('Sales Order #');
} elseif ($idmodule == 15) {
$obj = new \Invoice();
$obj->getId($idrecord);
$prefix = $crm_global_settings->get_setting_data_by_name('invoice_num_prefix');
$inventory_type = _('INVOICE');
$inv = 'inv';
$inv_number_fld = 'invoice_number';
$inv_date_fld = 'due_date';
$file_name = 'Invoice_' . $prefix . $obj->invoice_number . '.pdf';
$inventory_number = _('Invoice #');
} elseif ($idmodule == 16) {
$obj = new \PurchaseOrder();
$obj->getId($idrecord);
$prefix = $crm_global_settings->get_setting_data_by_name('purchaseorder_num_prefix');
$inventory_type = _('PURCHASE ORDER');
$inv = 'po';
$inv_number_fld = 'po_number';
$inv_date_fld = 'due_date';
$file_name = 'PurchaseOrder_' . $prefix . $obj->po_number . '.pdf';
$inventory_number = _('Purchase Order #');
}
$inventory_logo = $crm_global_settings->get_setting_data_by_name('inventory_logo');
$company_address = $crm_global_settings->get_setting_data_by_name('company_address');
$do_lineitems = new \Lineitems();
$do_lineitems->get_line_items($idmodule, $idrecord);
$lineitems = array();
if ($do_lineitems->getNumRows() > 0) {
while ($do_lineitems->next()) {
$lineitems[] = array("idlineitems" => $do_lineitems->idlineitems, "item_type" => $do_lineitems->item_type, "item_name" => $do_lineitems->item_name, "item_value" => $do_lineitems->item_value, "item_description" => $do_lineitems->item_description, "item_quantity" => $do_lineitems->item_quantity, "item_price" => $do_lineitems->item_price, "discount_type" => $do_lineitems->discount_type, "discount_value" => $do_lineitems->discount_value, "discounted_amount" => $do_lineitems->discounted_amount, "tax_values" => $do_lineitems->tax_values, "taxed_amount" => $do_lineitems->taxed_amount, "total_after_discount" => $do_lineitems->total_after_discount, "total_after_tax" => $do_lineitems->total_after_tax, "net_total" => $do_lineitems->net_total);
}
}
$html = '';
if (is_array($lineitems) && count($lineitems) > 0) {
//--load the stylesheet
$stylesheet = file_get_contents(BASE_PATH . '/themes/custom-css/inventory_export.css');
$pdf->WriteHTML($stylesheet, 1);
$html .= '
<div>
<div class="inv_wrapper">
<h1 class="inv_heading">' . $inventory_type . '</h1>
<div class="inv_address_wrapper">
<p class="inv_address_section">
<span class="inv_address_to_from">FROM:</span><br>
' . nl2br($company_address) . '
</p>
</div>
<div class="inv_company_address_wrapper">
<img class="inv_company_address_logo" src="' . $GLOBALS['FILE_UPLOAD_DISPLAY_PATH'] . '/' . $inventory_logo . '">
</div>
</div>
<div style="clear:both;"></div>
<div class="inv_wrapper">
<div class="inv_address_wrapper">
<p class="inv_address_section">
<span class="inv_address_to_from">To:</span><br>' . $this->generate_to_address($obj, $inv) . '
</p>
</div>
<div class="inv_brief_section">
<table class="inv_brief_section_table">
<tr>
<th class="inv_brief_section_table_heading">
<span>' . $inventory_number . '</span>
</th>
<td class="inv_brief_section_table_content">
<span>' . $prefix . $obj->{$inv_number_fld} . '</span>
</td>
</tr>
<tr>
<th class="inv_brief_section_table_heading">
<span>Date</span>
</th>
<td class="inv_brief_section_table_content">
<span>' . \FieldType9::display_value($obj->{$inv_date_fld}) . '</span>
</td>
</tr>
<tr>
<th class="inv_brief_section_table_heading">
<span>Amount Due</span>
</th>
<td class="inv_brief_section_table_content">
<span>' . \FieldType30::display_value($obj->grand_total) . '</span>
</td>
</tr>
</table>
</div>
</div>
<div style="clear:both;"></div>
<br>
';
$html .= '
<table class="inv_line_table">
<thead>
<tr>
<th class="inv_line_table_header inv_line_table_header_width_30">
<span>Item Name</span>
</th>
<th class="inv_line_table_header inv_line_table_header_width_10">
<span>Qty</span>
</th>
<th class="inv_line_table_header inv_line_table_header_width_30">
<span>Price</span>
</th>
<th class="inv_line_table_header inv_line_table_header_width_15">
<span>Total</span>
</th>
<th class="inv_line_table_header inv_line_table_header_width_15">
<span>Net Price</span>
</th>
</tr>
</thead>
';
$html .= '<tbody>';
foreach ($lineitems as $key => $items) {
$line_discount = '';
if ($items["discount_type"] == 'direct') {
$line_discount = _('Discount') . '-' . \FieldType30::display_value($items["discount_value"]);
} elseif ($items["discount_type"] == 'percentage') {
$line_discount = _('Discount') . '-' . $items["discount_value"] . ' %';
} else {
$line_discount = _('Discount') . '-' . _('no discount');
}
$line_tax = '';
if ($items["tax_values"] != '') {
$line_tax = ' - ' . rtrim($items["tax_values"], ',');
} else {
$line_tax = ' - no tax';
}
$html .= '
<tr>
<td class="inv_line_table_content inv_line_table_content_vertical_top">
<div class="inv_line_table_content_block">
' . $items["item_name"] . ' <br><br>
' . nl2br($items["item_description"]) . '
</div>
</td>
<td class="inv_line_table_content inv_line_table_content_vertical_top">
<div class="inv_line_table_content_block">
' . \FieldType16::display_value($items["item_quantity"]) . '
</div>
</td>
<td class="inv_line_table_content">
<div class="inv_line_table_content_block">
' . \FieldType30::display_value($items["item_price"]) . '
</div>
<div class="inv_line_table_content_block">
' . $line_discount . '
</div>
<div class="inv_line_table_content_block">
<b>Total after discount</b>
</div>
<div class="inv_line_table_content_block">
<b>Tax </b> ' . $line_tax . '
</div>
</td>
<td class="inv_line_table_content">
<div class="inv_line_table_content_block">
' . \FieldType30::display_value($items["item_price"] * $items["item_quantity"]) . '
</div>
<div class="inv_line_table_content_block">
' . \FieldType30::display_value($items["discounted_amount"]) . '
</div>
<div class="inv_line_table_content_block">
' . \FieldType30::display_value($items["total_after_discount"]) . '
</div>
<div class="inv_line_table_content_block">
' . \FieldType30::display_value($items["taxed_amount"]) . '
</div>
</td>
<td class="inv_line_table_content inv_line_table_content_vertical_top">
' . \FieldType30::display_value($items["net_total"]) . '
</td>
</tr>';
}
$html .= '
</tbody></table>';
$net_discount = '';
if ($obj->discount_type == 'percentage') {
$net_discount = $obj->discount_value . ' %';
} elseif ($obj->discount_type == 'direct') {
$net_discount = FieldType30::display_value($obj->discount_value);
} else {
$net_discount = _('no discount');
}
$net_tax = '';
if ($obj->tax_values != '') {
$net_tax = rtrim($obj->tax_values, ',');
}
$ship_hand_tax = '';
if ($obj->shipping_handling_tax_values != '') {
$ship_hand_tax = rtrim($obj->shipping_handling_tax_values, ',');
}
$final_adj = '';
if ($obj->final_adjustment_type == 'add') {
$final_adj = '(+)';
} elseif ($obj->final_adjustment_type == 'deduct') {
$final_adj = '(-)';
}
$html .= '
<div style="clear:both;"></div>
<br>
<div class="inv_grand_total_section">
<table class="inv_grand_total_table">
<tr>
<td class="inv_grand_total_table_header">
<span><b>Net Total</b></span>
</td>
<td class="inv_grand_total_table_content">
<span>' . \FieldType30::display_value($obj->net_total) . '</span>
</td>
</tr>
<tr>
<td class="inv_grand_total_table_header">
<span><b>Discount -</b> ' . $net_discount . '</span>
</td>
<td class="inv_grand_total_table_content">
<span>' . \FieldType30::display_value($obj->discounted_amount) . '</span>
</td>
</tr>
<tr>
<td class="inv_grand_total_table_header">
<span><b>Tax -</b> ' . $net_tax . ' </span>
</td>
<td class="inv_grand_total_table_content">
<span>' . \FieldType30::display_value($obj->taxed_amount) . '</span>
</td>
</tr>
<tr>
<td class="inv_grand_total_table_header">
<span><b>Shipping/Handling charges</b></span>
</td>
<td class="inv_grand_total_table_content">
<span>' . \FieldType30::display_value($obj->shipping_handling_charge) . '</span>
</td>
</tr>
<tr>
<td class="inv_grand_total_table_header">
<span><b>Shipping/Handling Tax -</b>' . $ship_hand_tax . '</span>
</td>
<td class="inv_grand_total_table_content">
<span>' . \FieldType30::display_value($obj->shipping_handling_taxed_amount) . '</span>
</td>
</tr>
<tr>
<td class="inv_grand_total_table_header">
<span><b>Final Adjustment</b>' . $final_adj . '</span>
</td>
<td class="inv_grand_total_table_content">
<span>' . \FieldType30::display_value($obj->final_adjustment_amount) . '</span>
</td>
</tr>
<tr>
<td class="inv_grand_total_table_header">
<span><b>Grand Total</span>
</td>
<td class="inv_grand_total_table_content">
<span>' . \FieldType30::display_value($obj->grand_total) . '</span>
</td>
</tr>
</table>
</div>
<div style="clear:both;"></div>
<br>
<h3 class="inv_terms_cond_section">
<span>Terms & Condition</span>
</h3>
<div style="top:2px;">
<p>
' . nl2br($obj->terms_condition) . '
</p>
</div></div>';
}
if (true === $save) {
$pdf->WriteHTML($html);
$pdf->Output(OUTBOUND_PATH . '/' . $file_name, 'F');
return $file_name;
} else {
$pdf->WriteHTML($html, 2);
$pdf->Output($file_name, 'D');
exit;
}
}
function processFile($filename)
{
//extract the filename to get the exact filename on the folder
$newFile = substr($filename, 3);
$dirname = substr($filename, 0, 2);
$fs = new Filesystem();
if ($fs->exists('../Repo/' . $dirname . '/' . $newFile)) {
$xml = simplexml_load_file('../Repo/' . $dirname . '/' . $newFile, null, LIBXML_NOCDATA);
$newXML = json_decode(json_encode($xml), true);
$data = formulateData($newXML, $dirname);
//checks if the record is already processed before
$hasRecord = PurchaseOrderQuery::create()->filterByNumber($data['number'])->find();
if ($hasRecord->count() === 0) {
logMessage("No duplicate data: processFile " . date('m/d/Y h:i:s') . ".\n");
//log something
//insert data to db
$po = new PurchaseOrder();
$po->setFilename($newFile);
$po->setStore($dirname);
$po->setCustomerCode($data['customer_code']);
$po->setDeliveryDate($data['delivery_date']);
$po->setNumber($data['number']);
$po->save();
$po_id = $po->getId();
//insert all items
foreach ($data['items'] as $key => $value) {
$items = new Item();
$items->setPurchaseOrderId($po_id);
$items->setUpc($value['upc']);
$items->setQty($value['qty']);
$items->setQty($value['discount']);
$items->save();
}
$formulated_data = formulateData($newXML, $dirname);
$formulated_data['id'] = $po_id;
//print_r($formulated_data);
logMessage("Return data in JSON: processFile " . date('m/d/Y h:i:s') . ".\n");
//log something
return $formulated_data;
print_r($formulated_data);
} else {
logMessage("This file(" . $newFile . ") with store(" . $dirname . ") is already processed before: processFile " . date('m/d/Y h:i:s') . ".\n");
//log something
}
print_r($data);
} else {
logMessage("Return no such file: processFile " . date('m/d/Y h:i:s') . ".\n");
//log something
return "No such file!";
}
}
<?php
// Copyright SQCRM. For licensing, reuse, modification and distribution see license.txt
/**
* PurchaseOrder detail
* @author Abhik Chakraborty
*/
$do_crmfields = new CRMFields();
$do_block = new Block();
$do_block->get_block_by_module($module_id);
$module_obj = new PurchaseOrder();
$module_obj->getId($sqcrm_record_id);
$do_lineitems = new Lineitems();
$do_lineitems->get_line_items($module_id, $sqcrm_record_id);
$lineitems = array();
if ($do_lineitems->getNumRows() > 0) {
while ($do_lineitems->next()) {
$lineitems[] = array("idlineitems" => $do_lineitems->idlineitems, "item_type" => $do_lineitems->item_type, "item_name" => $do_lineitems->item_name, "item_value" => $do_lineitems->item_value, "item_description" => $do_lineitems->item_description, "item_quantity" => $do_lineitems->item_quantity, "item_price" => $do_lineitems->item_price, "discount_type" => $do_lineitems->discount_type, "discount_value" => $do_lineitems->discount_value, "discounted_amount" => $do_lineitems->discounted_amount, "tax_values" => $do_lineitems->tax_values, "taxed_amount" => $do_lineitems->taxed_amount, "total_after_discount" => $do_lineitems->total_after_discount, "total_after_tax" => $do_lineitems->total_after_tax, "net_total" => $do_lineitems->net_total);
}
}
//updates detail, just add and last updated
$do_crmentity = new CRMEntity();
$update_history = $do_crmentity->get_last_updates($sqcrm_record_id, $module_id, $module_obj);
if (isset($_GET['ajaxreq']) && $_GET['ajaxreq'] == true) {
require_once 'view/detail_view_entry.php';
} else {
require_once 'view/detail_view.php';
}
/**
* Getting the JSon for PurchaseOrder
*
* @param PurchaseOrder $po
*
* @return Ambigous <multitype:, multitype:multitype:string NULL >
*/
private function _getPOJson(PurchaseOrder $po)
{
$array = $po->getJson();
$array['totalProductCount'] = $po->getTotalProductCount();
$array['totalReceivedValue'] = $po->getTotalRecievedValue();
$array['purchaseOrderItem'] = array();
foreach (PurchaseOrderItem::getAllByCriteria('po_item.purchaseOrderId = :purchaseOrderId', array('purchaseOrderId' => $po->getId())) as $purchaseOrderItem) {
$product = $purchaseOrderItem->getProduct();
$EANcodes = ProductCode::getAllByCriteria('pro_code.productId = :productId and pro_code.typeId = :typeId', array('productId' => $product->getId(), 'typeId' => ProductCodeType::ID_EAN), true, 1, 1);
$EANcodes = count($EANcodes) ? $EANcodes[0]->getCode() : '';
$UPCcodes = ProductCode::getAllByCriteria('pro_code.productId = :productId and pro_code.typeId = :typeId', array('productId' => $product->getId(), 'typeId' => ProductCodeType::ID_UPC), true, 1, 1);
$UPCcodes = count($UPCcodes) ? $UPCcodes[0]->getCode() : '';
$warehouseLocations = PreferredLocation::getAllByCriteria('productId = :productId and typeId = :typeId', array('productId' => $product->getId(), 'typeId' => PreferredLocationType::ID_WAREHOUSE), true, 1, 1);
$warehouseLocation = count($warehouseLocations) > 0 && $warehouseLocations[0]->getLocation() instanceof Location ? $warehouseLocations[0]->getLocation()->getName() : '';
$productArray = $product->getJson();
$productArray['codes'] = array('EAN' => $EANcodes, 'UPC' => $UPCcodes);
$productArray['warehouseLocation'] = $warehouseLocation;
$array['purchaseOrderItem'][] = array('purchaseOrderItem' => $purchaseOrderItem->getJson(), 'product' => $productArray);
}
return $array;
}