public function formAction() { $id = $this->getRequest()->getParam('id'); try { if (empty($id)) { throw new ProductAntidumpingDutyException($this->i18n->_('The product id was not defined')); } $product = ProductQuery::create()->findByPK($id); if (!$product instanceof Product) { throw new ProductAntidumpingDutyException($this->i18n->_('The Product was not found')); } $productAntidumpingDuty = ProductAntidumpingDutyQuery::create()->findByParentKey($product->getKeyMother()); if (!$productAntidumpingDuty instanceof ProductAntidumpingDuty) { $productAntidumpingDuty = new ProductAntidumpingDuty(); } $productAntidumpingDuty->setParentKey($product->getKeyMother()); $comboHeader = $this->i18n->_('Select One'); $header = array('' => $comboHeader); $this->view->currencies = CurrencyQuery::create()->find()->toCombo($comboHeader); $this->view->types = $header + array_flip(ProductAntidumpingDuty::$Type); $this->view->rules = $header + array_flip(ProductAntidumpingDuty::$Rule); $this->view->contentTitle = $this->i18n->_('Compensatory Fee'); $this->view->productAntidumpingDuty = $productAntidumpingDuty; } catch (ProductAntidumpingDutyException $e) { $this->setFlash('error', $e->getMessage()); $this->_redirect('product/list'); } }
public function getEntriesToCompleteInfoArray(PurchaseOrderEntryCollection $entries) { $products = ProductQuery::create()->whereAdd(Product::ITEM_CODE, $entries->getProducts())->find(); $arrayEntries = array(); while ($entries->valid()) { $entry = $entries->read(); $product = $products->getByPK($entry->getIdProduct()); $arrayEntries[] = array("line" => $entry->getLine(), "itemCode" => $product->getItemCode(), "description" => $product->getItemName(), "unitPrice" => $entry->getPrice(), "quantity" => $entry->getQuantity(), "currency" => $entry->getCurrency()); } return $arrayEntries; }
/** * * @return array */ public function listAction() { $this->view->page = $page = $this->getRequest()->getParam('page') ?: 1; if ($this->getRequest()->isPost()) { $this->view->post = $post = $this->getRequest()->getParams(); } $total = PurchaseOrderEntryQuery::create()->filter($post)->count(); $this->view->purchaseOrderEntries = $purchaseOrderEntries = PurchaseOrderEntryQuery::create()->filter($post)->page($page, $this->getMaxPerPage())->find(); $this->view->paginator = $this->createPaginator($total, $page); $this->view->purchaseOrders = \Application\Query\PurchaseOrderQuery::create()->find()->toCombo(); $this->view->products = \Application\Query\ProductQuery::create()->find()->toCombo(); $this->view->warehouses = \Application\Query\WarehouseQuery::create()->find()->toCombo(); }
/** * * Product Collection and user for logs * @param ProductCollection $products * @param User $user * @return mixed */ public function save(ProductCollection $products, User $user) { $this->setUser($user); $existProducts = ProductQuery::create()->whereAdd(Product::ITEM_CODE, $products->getPrimaryKeys())->find(); while ($products->valid()) { $product = $products->read(); if ($existProducts->containsIndex($product->getIndex())) { $SAPProducts["Product"][] = $product->toSAPArray() + array("Movement" => 2); $this->newLogForUpdate($product); } else { $SAPProducts["Product"][] = $product->toSAPArray() + array("Movement" => 1); $this->newLogForCreate($product); } } $SAPConnectionClient = new SAPConnectorClient(); $response = $SAPConnectionClient->saveProducts($SAPProducts); return json_decode($response->productResult->message); }
/** * */ public function getListResultsAction() { $storage = $this->getStorageService(); $params = $this->getRequest()->getParams(); $page = $params['page']; $productQuery = ProductQuery::create()->useFileCache()->filter($params); $colors = ColorQuery::create()->find(); $brands = BrandQuery::create()->find(); $productCollection = $productQuery->find(); $freightFareCollection = FreightFareQuery::create()->find(); $freightTypeCollection = FreightTypeQuery::create()->find(); $customsTariffCodeCollection = CustomsTariffCodeQuery::create()->find(); $incotermCollection = IncotermQuery::create()->useFileCache()->find(); $products = $productQuery->findByPage($page, $this->getMaxPerPage()); // if (!$productStorage) // $storage->saveValue($productQuery->find(), 'products'); $productPrintingArea = ProductPrintingAreaQuery::create()->addColumn(ProductPrintingArea::ID_PRODUCT)->whereAdd(ProductPrintingArea::ID_PRODUCT, $products->getKeyMother(), ProductPrintingAreaQuery::IN)->fetchCol(); // $arrayProducts = array(); while ($products->valid()) { $product = $products->read(); $hasPrintingArea = in_array($product->getKeyMother(), $productPrintingArea) ? 1 : 0; $arrayProducts[$product->getIndex()] = $product->toArrayForList() + array("has_printing_area" => $hasPrintingArea); } die(json_encode($arrayProducts)); }
/** * * @param PurchaseOrderEntry $purchaseOrderEntry * @return CustomsTariffCode $tariffCode */ private function getPurchaseOrderEntryTariffCode(PurchaseOrderEntry $purchaseOrderEntry) { $idProduct = $purchaseOrderEntry->getIdProduct(); $idTariffCode = ProductQuery::create()->findByPK($idProduct)->getIdCustomsTariffCode(); $tariffCode = CustomsTariffCodeQuery::create()->findByPK($idTariffCode); return $tariffCode; }
/** * * @param string $idProduct * @return array */ private function getLandedCost($idProduct, Application\Model\Bean\ProductPriceList $productPriceList, $productPrice = null) { $product = ProductQuery::create()->findByPK($idProduct); if (FreightFareQuery::create()->whereAdd(FreightFare::ID_FREIGHT_FARE, $product->getDefaultFreightFare())->count()) { $freightFare = FreightFareQuery::create()->findByPK($product->getDefaultFreightFare()); $freightType = FreightTypeQuery::create()->findByPK($freightFare->getIdFreightType()); } else { $result['message'] = $this->i18n->_('You must edit the Freight Fare.'); $result['result'] = false; return $result; } if (CustomsTariffCodeQuery::create()->whereAdd(CustomsTariffCode::CODE, $product->getIdCustomsTariffCode())->count()) { $customsTariffCode = CustomsTariffCodeQuery::create()->findByPK($product->getIdCustomsTariffCode()); } else { $result['message'] = $this->i18n->_('You must edit the Customs Code.'); $result['result'] = false; return $result; } $unit = $freightFare->getUnit(); $unitCost = $freightFare->getUnitCost(); $maxLoad = $freightType->getMaxLoad(); $cbmByCarton = $product->getCbmByCarton(); if (!$cbmByCarton) { $result['message'] = $this->i18n->_('You must edit the Cartons.'); $result['result'] = false; return $result; } $containerCartons = ceil($maxLoad / $cbmByCarton); $containerWeight = $containerCartons * $product->getMcWeight(); $containerTotalProducts = $containerCartons * $product->getMcParts(); if (!$containerTotalProducts) { $result['message'] = $this->i18n->_('You must edit Master Carton Parts.'); $result['result'] = false; return $result; } if (!$productPrice) { if (!$product->getCost()) { $result['message'] = $this->i18n->_('You must edit the Price.'); $result['result'] = false; return $result; } $productCost = $productPriceList->getProductPriceInUsd() * $containerTotalProducts; } else { $productCost = $productPrice * $containerTotalProducts; } switch ($unit) { case FreightFare::$Units['CBM']: $freightCost = $unitCost * $maxLoad; break; case FreightFare::$Units['Container']: $freightCost = $unitCost; break; case FreightFare::$Units['KG']: $freightCost = $unitCost * $containerWeight; break; } $productCostAndFreightCost = $productCost + $freightCost; $igi = $productCostAndFreightCost * $customsTariffCode->getPercent() / 100; $dta = $productCostAndFreightCost * 0.8 / 100; $iva = ($productCostAndFreightCost + $dta + $igi) * 0.16; $totalCostProduct = $productCostAndFreightCost + $igi + $dta + $iva; $landedCost = $totalCostProduct / $containerTotalProducts; $result['message'] = $this->i18n->_('yep! everything goes well'); $result['result'] = strval(round($landedCost, 2)); return $result; }
/** * * */ public function getQuarantineListResultsAction() { $page = $this->getRequest()->getParam('page') ?: 1; $warehouseEntries = WarehouseEntranceQuery::create()->whereAdd(WarehouseEntrance::ID_FOLIO_IMPORT, null, WarehouseEntranceQuery::NOT_EQUAL)->whereAdd(WarehouseEntrance::ID_FOLIO_IMPORT, '0', WarehouseEntranceQuery::NOT_EQUAL)->find(); $params = $this->getRequest()->getParams(); $params['id_purchase_order'] = PurchaseOrderQuery::create()->whereAdd(PurchaseOrder::SAP_DOCUMENT_NUMBER, $params['sap_document_number'])->fetchOne(); if (empty($params['id_purchase_order']) && !empty($params['sap_document_number'])) { $params['id_purchase_order'] = -1; } $warehouseEntryProductQuery = WarehouseEntranceProductQuery::create()->whereAdd(WarehouseEntranceProduct::ID_PURCHASE_ORDER, null, WarehouseEntranceProductQuery::NOT_EQUAL)->whereAdd(WarehouseEntranceProduct::STATUS, WarehouseEntranceProduct::$Status['Quarantine'], WarehouseEntranceProductQuery::EQUAL)->whereAdd(WarehouseEntranceProduct::ID_WAREHOUSE_ENTRANCE, $warehouseEntries->getPrimaryKeys(), WarehouseEntranceProductQuery::IN)->filter($params)->orderBy(WarehouseEntranceProduct::ID_WAREHOUSE_ENTRANCE, 'DESC')->findByPage($page, $this->getMaxPerPage()); $purchaseOrderCollection = PurchaseOrderQuery::create()->whereAdd(PurchaseOrder::ID_PURCHASE_ORDER, $warehouseEntryProductQuery->getPurchaseOrderIds(), PurchaseOrderQuery::IN)->find(); $purchaseOrderEntryCollection = PurchaseOrderEntryQuery::create()->whereAdd(PurchaseOrderEntry::ID_PURCHASE_ORDER, $purchaseOrderCollection->getPrimaryKeys(), PurchaseOrderEntryQuery::IN)->find(); $i = 0; $this->getCatalog('QuarantineCatalog')->beginTransaction(); while ($warehouseEntryLine = $warehouseEntryProductQuery->read()) { $warehouseEntry = WarehouseEntranceQuery::create()->whereAdd(WarehouseEntrance::ID_WAREHOUSE_ENTRANCE, $warehouseEntryLine->getIdWarehouseEntrance())->findOne(); if (TransferLineLogQuery::create()->whereAdd(TransferLineLog::BASEENTRY, $warehouseEntryLine->getIdWarehouseEntrance())->whereAdd(TransferLineLog::BASELINE, $warehouseEntryLine->getIdWarehouseEntranceProduct())->count()) { $transferLine = TransferLineLogQuery::create()->whereAdd(TransferLineLog::BASEENTRY, $warehouseEntryLine->getIdWarehouseEntrance())->whereAdd(TransferLineLog::BASELINE, $warehouseEntryLine->getIdWarehouseEntranceProduct())->findOne(); $warehouseEntryLines[$i]['warehouse'] = WarehouseStoreQuery::create()->whereAdd(WarehouseStore::CODE, $transferLine->getWhsCode())->findOne()->getName(); } else { $warehouseEntryLines[$i]['warehouse'] = $this->i18n->_('Not Available'); } $claimReport = $this->getClaimReport($warehouseEntryLine->getIdWarehouseEntrance(), $warehouseEntryLine->getIdWarehouseEntranceProduct()); $folioImport = $this->getWarehouseEntryFolioImport($warehouseEntry->getIdFolioImport()); $quarantine = $this->getQuarantine($warehouseEntryLine->getIdWarehouseEntrance(), $warehouseEntryLine->getIdWarehouseEntranceProduct()); $product = ProductQuery::create()->findByPK($warehouseEntryLine->getIdProduct()); $warehouseEntryLines[$i]['id_warehouse_entrance_product'] = $warehouseEntryLine->getIdWarehouseEntranceProduct(); $warehouseEntryLines[$i]['id_warehouse_entrance'] = $warehouseEntry->getIdWarehouseEntrance(); $warehouseEntryLines[$i]['id_folio_import'] = $folioImport->getIdFolioImport(); $warehouseEntryLines[$i]['folio_import'] = $folioImport->getFolio(); if (PurchaseOrderQuery::create()->whereAdd(PurchaseOrder::ID_PURCHASE_ORDER, $warehouseEntryLine->getIdPurchaseOrder())->find()->count()) { $purchaseOrder = PurchaseOrderQuery::create()->findByPK($warehouseEntryLine->getIdPurchaseOrder()); } else { $purchaseOrder = new PurchaseOrder(); } $purchaseOrderEntry = PurchaseOrderEntryQuery::create()->whereAdd(PurchaseOrderEntry::ID_PURCHASE_ORDER, $purchaseOrder->getIdPurchaseOrder())->whereAdd(PurchaseOrderEntry::LINE, (string) $warehouseEntryLine->getBaseLine())->findOneOrElse(new PurchaseOrderEntry()); $proformaInvoice = ProformaInvoiceQuery::create()->whereAdd(ProformaInvoice::ID_PROFORMA_INVOICE, $purchaseOrderEntry->getBaseEntry())->findOneOrElse(new ProformaInvoice()); $warehouseEntryLines[$i]['proforma_invoice'] = $proformaInvoice->getSapDocumentNumber(); $warehouseEntryLines[$i]['purchase_order'] = $purchaseOrder->getSapDocumentNumber(); $warehouseEntryLines[$i]['item_code'] = $product->getItemCode(); $warehouseEntryLines[$i]['item_name'] = $product->getItemName(); $warehouseEntryLines[$i]['original_quantity'] = $warehouseEntryLine->getQuantity(); $warehouseEntryLines[$i]['current_quantity'] = $currentQuantity = $quarantine->getQuantity(); if ($warehouseEntryLine->getLineStatus() == 'C') { // $warehouseEntryLines[$i]['cancelled'] = true; // $warehouseEntryLines[$i]['status'] = 'Cancelled'; // $warehouseEntryLines[$i]['statusRow'] = ' '; } else { $warehouseEntryLines[$i]['cancelled'] = false; if (!$currentQuantity) { $warehouseEntryLines[$i]['status'] = 'Debugged'; $warehouseEntryLines[$i]['statusRow'] = 'success'; } else { $warehouseEntryLines[$i]['status'] = $warehouseEntryLine->getStatusName(); $warehouseEntryLines[$i]['statusRow'] = 'warning'; } } $warehouseEntryLines[$i]['quarantine'] = $warehouseEntryLine->getStatusName(); $warehouseEntryLines[$i]['claimed_amount'] = $claimReport->getClaimedAmount(); $warehouseEntryLines[$i]['final_amount'] = $claimReport->getFinalAmount(); $warehouseEntryLines[$i]['claim_report_status'] = $claimReport->getStatusName(); $warehouseEntryLines[$i]['allow_debug'] = TransferLineLogQuery::create()->whereAdd(TransferLineLog::BASEENTRY, $warehouseEntryLine->getIdWarehouseEntrance())->whereAdd(TransferLineLog::BASELINE, $warehouseEntryLine->getIdWarehouseEntranceProduct())->count(); if ($warehouseEntryLine->getStatus() == WarehouseEntranceProduct::$Status['Quarantine']) { $quarantineProduct = $this->getQuarantine($warehouseEntryLine->getIdWarehouseEntrance(), $warehouseEntryLine->getIdWarehouseEntranceProduct()); $warehouseEntryLines[$i]['initial_quantity'] = $quarantineProduct->getQuantity(); } $i++; } $this->getCatalog('QuarantineCatalog')->commit(); die(json_encode($warehouseEntryLines)); }
/** * * @param int $idFolioImport */ public function __construct($idFolioImport, $USDToMXN, $EURtoUSD) { $this->folioImport = FolioImportQuery::create()->findByPK($idFolioImport); if ($USDToMXN) { $this->USDToMXN = $USDToMXN; } if ($EURtoUSD) { $this->EURtoUSD = $EURtoUSD; } $this->purchaseOrders = PurchaseOrderQuery::create()->whereAdd(PurchaseOrder::ID_FOLIO_IMPORT, $idFolioImport)->find(); $this->purchaseOrdersEntries = PurchaseOrderEntryQuery::create()->whereAdd(PurchaseOrderEntry::ID_PURCHASE_ORDER, $this->getPurchaseOrders()->getPrimaryKeys())->find(); $this->products = $products = ProductQuery::create()->whereAdd(Product::ITEM_CODE, $this->getPurchaseOrdersEntries()->getProducts())->find(); $this->productAntidumpingDuties = ProductAntidumpingDutyQuery::create()->whereAdd(ProductAntidumpingDuty::PARENT_KEY, $products->getKeyMother())->find(); }
public function getPurchaseOrderEntriesForNewClaimReportAction() { $docNum = $this->getRequest()->getParam('docNum'); $values = array(); $query = PurchaseOrderQuery::create()->whereAdd(PurchaseOrder::SAP_DOCUMENT_NUMBER, $docNum)->findOne(); $entries = PurchaseOrderEntryQuery::create()->whereAdd(PurchaseOrderEntry::ID_PURCHASE_ORDER, $query->getIdPurchaseOrder())->find(); $i = 0; while ($entry = $entries->read()) { $product = ProductQuery::create()->findByPK($entry->getIdProduct()); $values[$i]['itemName'] = $product->getItemName(); $values[$i]['itemCode'] = $product->getItemCode(); $i++; } die(json_encode($values)); }
public function getProductPriceInUsd() { $product = ProductQuery::create()->findByPK($this->getIdProduct()); switch ($product->getCurrency()) { case 'USD': return $product->getCost(); break; case 'EUR': return $product->getCost() * $this->getExchangeRateEurToUsd(); break; case 'MXP': return $product->getCost() / $this->getExchangeRateUsdToPesos(); default: return $product->getCost(); } }
public function exportToExcelAction() { $params = $this->getRequest()->getParams(); $allPurchaseOrderEntries = PurchaseOrderEntryQuery::create()->find(); $purchaseOrders = PurchaseOrderQuery::create()->filter($params)->addDescendingOrderBy(PurchaseOrder::PURCHASE_ORDER_DATE)->whereAdd("PurchaseOrder.DocType", "I")->whereAdd("PurchaseOrderEntry.ItemCode", "TR%", 'NOT LIKE')->whereAdd("PurchaseOrderEntry.WhsCode", "9999", PurchaseOrderQuery::NOT_LIKE)->whereAdd(PurchaseOrder::ID_PURCHASE_ORDER, $allPurchaseOrderEntries->getDistinctPurchaseOrder(), PurchaseOrderQuery::IN)->find(); $products = ProductQuery::create()->whereAdd(Product::ITEM_CODE, $allPurchaseOrderEntries->getProducts(), ProductQuery::IN)->find(); $suppliers = SapSupplierQuery::create()->whereAdd(SapSupplier::ID_SUPPLIER, $purchaseOrders->getDistinctSuppliers(), SapSupplierQuery::IN)->find(); $warehousesStores = WarehouseStoreQuery::create()->whereAdd(WarehouseStore::CODE, $allPurchaseOrderEntries->getDistinctIdWarehouseStore(), WarehouseStoreQuery::IN)->find(); $warehouses = WarehouseQuery::create()->whereAdd(Warehouse::CODE, $warehousesStores->getDistinctWarehouses(), WarehouseQuery::IN)->find(); $currencies = CurrencyQuery::create()->find(); $countries = CountryQuery::create()->find(); require_once 'PHPExcel.php'; $objPHPExcel = new PHPExcel(); $activeSheet = $objPHPExcel->setActiveSheetIndex(0); $activeSheet->setCellValue('A1', $this->i18n->_('Purchase Order Folio'))->setCellValue('B1', $this->i18n->_('Destination Country'))->setCellValue('C1', $this->i18n->_('Supplier Code'))->setCellValue('D1', $this->i18n->_('Supplier Name'))->setCellValue('E1', $this->i18n->_('Creation Date'))->setCellValue('F1', $this->i18n->_('Status'))->setCellValue('G1', $this->i18n->_('Entry Line'))->setCellValue('H1', $this->i18n->_('Product Code'))->setCellValue('I1', $this->i18n->_('Product Description'))->setCellValue('J1', $this->i18n->_('Amount'))->setCellValue('K1', $this->i18n->_('Price'))->setCellValue('L1', $this->i18n->_('Import'))->setCellValue('M1', $this->i18n->_('Currency'))->setCellValue('N1', $this->i18n->_('Location'))->setCellValue('O1', $this->i18n->_('Warehouse')); $activeSheet->getDefaultStyle()->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $i = 2; while ($purchaseOrders->valid()) { $purchaseOrder = $purchaseOrders->read(); $currency = $currencies->getByPkOrEmpty($purchaseOrder->getIdCurrency()); $supplier = $suppliers->getByPkOrElse($purchaseOrder->getIdSupplier(), new SapSupplier()); $country = $countries->getByPK($purchaseOrder->getIdDestinationCountry()); $purchaseOrderEntries = $allPurchaseOrderEntries->filterByPurchaseOrderPk($purchaseOrder->getIdPurchaseOrder()); $entriesCount = $i; while ($purchaseOrderEntries->valid()) { $purchaseOrderEntry = $purchaseOrderEntries->read(); $product = $products->getByPK($purchaseOrderEntry->getIdProduct()) ? $products->getByPK($purchaseOrderEntry->getIdProduct()) : new Product(); $warehouseStore = $warehousesStores->getByPkOrElse($purchaseOrderEntry->getIdWarehouseStore(), new WarehouseStore()); $warehouse = $warehouseStore->getLocation() > 0 ? $warehouses->getByPK($warehouseStore->getLocation()) : new WarehouseStore(); $activeSheet->setCellValue('A' . $entriesCount, $purchaseOrder->getSapDocumentNumber())->setCellValue('B' . $entriesCount, utf8_encode($country->getName()))->setCellValue('C' . $entriesCount, $supplier->getCardCode())->setCellValue('D' . $entriesCount, $supplier->getCardname())->setCellValue('E' . $entriesCount, $purchaseOrder->getPurchaseOrderDate())->setCellValue('F' . $entriesCount, $purchaseOrder->getStatusName())->setCellValue("G" . $entriesCount, $purchaseOrderEntry->getLine())->setCellValue("H" . $entriesCount, $product->getItemCode())->setCellValue("I" . $entriesCount, $product->getItemName())->setCellValue("J" . $entriesCount, $purchaseOrderEntry->getAmount())->setCellValue("K" . $entriesCount, $purchaseOrderEntry->getPrice())->setCellValue("L" . $entriesCount, $purchaseOrderEntry->getImport())->setCellValue("M" . $entriesCount, $currency->getCurrCode())->setCellValue("N" . $entriesCount, $warehouse->getName())->setCellValue("O" . $entriesCount, $warehouseStore->getName()); $entriesCount++; } $i = $entriesCount; } $columns = range('A', 'O'); foreach ($columns as $column) { $activeSheet->getColumnDimension($column)->setAutoSize(true); } header("Content-Type: application/vnd.ms-excel"); $date = \Zend_Date::now(); $fileName = $this->i18n->_("Purchase_orders_report") . $date->get("ddMMyyyy"); header("Content-Disposition: attachment; filename=\"{$fileName}.xlsx\""); header("Cache-Control: max-age=0"); $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save("php://output"); exit; }
public function exportToExcelAction() { $report = new SimpleListReport(); $params = $this->getRequest()->getParams(); $productPrintingAreas = ProductPrintingAreaQuery::create()->filter($params)->find(); $i = 0; $tableContent = array(); while ($productPrintingArea = $productPrintingAreas->read()) { $productionTimePrintingTechniqueQuery = ProductionTimePrintingTechniqueQuery::create()->whereAdd(ProductionTimePrintingTechnique::ID_PRODUCT_PRINTING_AREA, $productPrintingArea->getIdProductPrintingArea())->find(); $j = 1; while ($productionTimePrintingTechnique = $productionTimePrintingTechniqueQuery->read()) { switch ($j) { case 1: $id_printing_technique = $productionTimePrintingTechnique->getIdPrintingTechnique(); $max_area = $productionTimePrintingTechnique->getMaxArea(); $max_inks = $productionTimePrintingTechnique->getMaxInks(); break; case 2: $id_printing_technique_alternative = $productionTimePrintingTechnique->getIdPrintingTechnique(); $max_area_alternative = $productionTimePrintingTechnique->getMaxArea(); $max_inks_alternative = $productionTimePrintingTechnique->getMaxInks(); break; } if ($j == 2) { break; } $j++; } $product = ProductQuery::create()->findByPK($productPrintingArea->getIdProduct()); $tableContent[$i][] = $productPrintingArea->getIdProduct(); $tableContent[$i][] = $product->getKeyMother(); $tableContent[$i][] = $product->getItemName(); $tableContent[$i][] = $productPrintingArea->getIdEShop(); $tableContent[$i][] = $id_printing_technique; $tableContent[$i][] = $productPrintingArea->getIncludedLogos(); $tableContent[$i][] = $productPrintingArea->getIdPrintingSize(); $tableContent[$i][] = $max_inks; $tableContent[$i][] = $id_printing_technique_alternative; $tableContent[$i][] = $max_inks_alternative; $tableContent[$i][] = $max_area; $tableContent[$i][] = $max_area_alternative; $tableContent[$i][] = $productPrintingArea->getPrintingOrder(); $i++; } $tableHeaders = array('SKU', 'Item', 'Item Name', 'Id E-Shop', 'Printing Technique', 'Included Logos', 'Surface', 'Max Inks', 'Printing Technique Alternative', 'Max Inks Alternative', 'Max Area', 'Max Area Alternative', 'Printing Order'); $report->setTableTitle('Product Printing Area Report'); $report->setTableHeaders($tableHeaders); $report->setTableContent($tableContent); $report->setFilename('product_printing_area_report'); $report->createSpreadsheet(); die; }
public function npdKeyAction() { $this->view->setTpl('Npd-key'); $this->view->contentTitle = 'NPD Key'; $idNPDSheet = $this->getRequest()->getParam('id'); $this->view->productNewKey = $this->getRequest()->getParam('product-new-key'); if (!empty($idNPDSheet)) { $this->view->npdSheet = $npdSheet = NpdSheetQuery::create()->findByPK($idNPDSheet); } $params = $this->getRequest()->getParams(); if ($this->getRequest()->isPost()) { $this->view->post = $post = $this->getRequest()->getParams(); $this->view->subGroup = $subFamily = SubfamilyQuery::create()->findByPK($post['id_subfamily']); $this->view->family = $family = FamilyQuery::create()->findByPK($post['id_family']); $this->view->productGroup = $productGroup = ProductGroupQuery::create()->findByPK($post['id_product_group']); $this->view->idPg = $family->getIdFamily(); $this->view->IdSd = $subFamily->getIdSubfamily(); } else { if (!empty($npdSheet)) { if ($npdSheet->getIdSubfamily() > 0) { $this->view->subGroup = $subFamily = SubfamilyQuery::create()->findByPK($npdSheet->getIdSubfamily()); } else { $this->view->subGroup = $subFamily = new Subfamily(); } $this->view->family = $family = FamilyQuery::create()->findByPK($npdSheet->getIdFamily()); $this->view->productGroup = $productGroup = ProductGroupQuery::create()->findByPK($family->getIdProductGroup()); $this->view->idPg = $family->getIdFamily(); /*if($subFamily > 0){ $idSd = $subFamily->getIdSubfamily(); } $this->view->IdSd = $idSd;*/ } } // Get Product Groups $productGroupQuery = ProductGroupQuery::create(); $productGroupQuery->where()->setOR(); $productGroupQuery->whereAdd(ProductGroup::ID_PRODUCT_GROUP, $productGroup->getIdProductGroup(), ProductGroupQuery::EQUAL); $productGroupCombo = $productGroupQuery->actives()->find()->toCombo(); $this->view->productGroups = $productGroupCombo; // Get Families $familyQuery = FamilyQuery::create(); $familyQuery->where()->setOR(); $familyQuery->whereAdd(Family::ID_PRODUCT_GROUP, $family->getIdProductGroup(), FamilyQuery::EQUAL); $familyQuery->where()->setAND(); $familyQuery->whereAdd(ProductGroup::ID_PRODUCT_GROUP, $productGroup->getIdProductGroup()); $familyCombo = $familyQuery->actives()->find()->toCombo(); // Get subgfamilies $subfamiliesQuery = SubfamilyQuery::create(); if ($subFamily->getIdSubfamily() > 0) { $subfamiliesQuery->where()->setOR(); $subfamiliesQuery->whereAdd(Subfamily::ID_SUBFAMILY, $subFamily->getIdSubfamily(), SubfamilyQuery::EQUAL); $subfamiliesQuery->where()->setAND(); } $subfamiliesQuery->whereAdd(Family::ID_FAMILY, $family->getIdFamily()); $subGroupCombo = array("" => "Select Subfamily") + $subfamiliesQuery->actives()->find()->toCombo(); // Get Colors NPD $colorsNpd = ColorQuery::create()->innerJoinNpdSheet()->whereAdd('NpdSheet.' . NpdSheet::ID_NPD_SHEET, $idNPDSheet)->find(); $productColors = ColorQuery::create()->find()->toCombo(); $select = array('' => $this->i18n->_('** Select **')); $this->view->colors = $select + $colorsNpd->toCombo(); $this->view->brands = $brands = $select + \Application\Query\BrandQuery::create()->actives()->find()->toCombo(); $this->view->productColors = $productColors; //search families for list products $idProductGroup = $this->getRequest()->getParam('id_product_group'); $clvProductGroup = $this->getRequest()->getParam('clv_family'); $idCategory = $this->getRequest()->getParam('clv_category'); $clvSubcategory = $this->getRequest()->getParam('clv_subcategory'); $clvcomposition = $this->getRequest()->getParam('clv_composition'); $clvBrand = $this->getRequest()->getParam('clv_brand'); $clvColor = $this->getRequest()->getParam('clv_color'); $idColor = $this->getRequest()->getParam('id_color'); if (isset($clvColor)) { $colorCode = $this->i18n->_("Not available"); } else { $colorCode = $clvColor; } $productsFam = ProductQuery::create()->distinct()->addColumns(array('Product.' . Product::ID_PRODUCT_GROUP, 'ProductGroup.' . ProductGroup::CODE))->innerJoinProductGroup()->addAscendingOrderBy('Product.' . Product::ID_PRODUCT_GROUP)->fetchAll(); foreach ($productsFam as $i => $productFam) { if ($productsFam[$i]["id_product_group"] == $idProductGroup) { $productGroupIds = array("prevFamily" => $productsFam[$i - 1]["id_product_group"], "productFamily" => $productsFam[$i]["id_product_group"], "nextFamily" => $productsFam[$i + 1]["id_product_group"]); } } $wantedProducts = ProductQuery::create(); $wantedProducts->where()->setOR(); $seachProducts = $wantedProducts->whereAdd('Product.' . Product::ID_PRODUCT_GROUP, $productGroupIds['productFamily'])->addColumns(array('Product.' . Product::ITEM_CODE, 'Product.' . Product::ITEM_NAME, 'Product.' . Product::STATUS, 'Product.' . Product::KEY_MOTHER, 'Product.' . Product::ID_COLOR))->whereAdd('Product.' . Product::ID_PRODUCT_GROUP, $productGroupIds['prevFamily'])->whereAdd('Product.' . Product::ID_PRODUCT_GROUP, $productGroupIds['nextFamily'])->fetchAll(); $newProduct = array(array('item_code' => $clvProductGroup . $idCategory . $clvSubcategory . $clvcomposition . $clvBrand . $clvColor, 'item_name' => $npdSheet->getName(), 'status' => 'H', 'key_mother' => $clvProductGroup . $idCategory . $clvSubcategory . $clvcomposition, 'id_color' => $colorCode)); //order total products $products = array_merge($seachProducts, $newProduct); array_multisort($products); //save index new product foreach ($products as $key => $val) { if ($newProduct[0]['item_code'] == $val['item_code']) { $index = $key; } } $parentKeys = ProductQuery::create()->whereAdd(Product::KEY_MOTHER, $newProduct[0]['key_mother'])->find()->count(); $idSupplierAut = SupplierBudgetQuery::create()->innerJoinNpdSheetSupplier()->addColumn(NpdSheetSupplier::ID_SUPPLIER)->whereAdd('NpdSheetSupplier.' . NpdSheetSupplier::ID_NPD_SHEET, $idNPDSheet)->whereAdd('SupplierBudget.' . SupplierBudget::IS_AUTHORIZED, 1)->fetchAll(); // die(print_r($idSupplierAut)); if ($idSupplierAut) { $currency = CurrencyQuery::create()->whereAdd(Currency::ID_CURRENCY, SapSupplierQuery::create()->findByPK($idSupplierAut[0]['id_supplier'])->getIdCurrency())->findOne(); } else { $this->setFlash('error', $this->i18n->_("there is no authorized supplier")); return $this->getHelper('redirector')->goto('list'); } $this->view->new = $newProduct[0]['key_mother']; $this->view->families = $familyCombo; $this->view->subgroups = $subGroupCombo; $this->view->products = $products; $this->view->index = $index; $this->view->parentKeys = $parentKeys; $this->view->supplier = $idSupplierAut[0]['id_supplier']; $this->view->currency = $currency->getName(); }
/** * * Gets all Products from SAP, searches the DB for the itemcode, then updates or creates */ public function syncProductsAction() { $r = SapProductQuery::create()->whereAdd(SapProduct::INVNTITEM, "Y")->find(); $errors = 0; $new = 0; $updated = 0; echo "<pre>"; echo "Name, itemcode, clave madre, resultado, mensaje \n"; while ($r->valid()) { $save = 0; $sapProduct = $r->read(); echo "\"" . trim($sapProduct->getItemname()) . "\", " . $sapProduct->getItemcode() . ", " . $sapProduct->getUMadre9() . ", "; if (strlen($sapProduct->getItemcode()) != 11) { echo "1, Error! ItemCode invalido: len " . strlen($sapProduct->getItemcode()) . "\n"; $errors++; continue; } $product = ProductQuery::create()->whereAdd(Product::ITEM_CODE, $sapProduct->getItemcode(), ProductQuery::EQUAL)->findOne(); if (!$product instanceof Product) { $product = new Product(); $save = 1; } $brand = BrandQuery::create()->whereAdd(Brand::CODE, substr($sapProduct->getItemcode(), 7, 2))->findOne(); if (!$brand instanceof Brand) { echo "2, Error! No Brand: " . substr($sapProduct->getItemcode(), 7, 2) . "\n"; $errors++; continue; } $product->setIdBrand($brand->getIdBrand()); $color = ColorQuery::create()->whereAdd(Color::CODE, substr($sapProduct->getItemcode(), 9, 2))->findOne(); if (!$color instanceof Color) { echo "3, Error! No Color: " . substr($sapProduct->getItemcode(), 9, 2) . "\n"; $errors++; continue; } $product->setIdColor($color->getIdColor()); $customsTariffCode = CustomsTariffCodeQuery::create()->whereAdd(CustomsTariffCode::CODE, $sapProduct->getCstGrpCode())->findOne(); if (!$customsTariffCode instanceof CustomsTariffCode) { echo "4, Error! No Tax Code: " . $sapProduct->getCstGrpCode() . "\n"; $errors++; continue; } $product->setIdCustomsTariffCode($customsTariffCode->getIdCustomsTariffCode()); $productGroup = ProductGroupQuery::create()->whereAdd(ProductGroup::CODE, substr($sapProduct->getItemcode(), 0, 2))->findOne(); if (!$productGroup instanceof ProductGroup) { echo "5, Error! No ProductGroup: " . substr($sapProduct->getItemcode(), 0, 2) . "\n"; $errors++; continue; } $product->setIdProductGroup($productGroup->getIdProductGroup()); $family = FamilyQuery::create()->whereAdd(Family::CODE, substr($sapProduct->getItemcode(), 2, 1))->whereAdd(Family::ID_PRODUCT_GROUP, $productGroup->getIdProductGroup())->findOne(); if (!$family instanceof Family) { echo "6, Error! No Family: " . substr($sapProduct->getItemcode(), 2, 1) . "\n"; $errors++; continue; } $product->setIdFamily($family->getIdFamily()); $subfamily = SubfamilyQuery::create()->whereAdd(Subfamily::CODE, substr($sapProduct->getItemcode(), 3, 1))->whereAdd(Subfamily::ID_FAMILY, $family->getIdFamily())->findOne(); if (!$subfamily instanceof Subfamily) { echo "7, Error! No SubFamily: " . substr($sapProduct->getItemcode(), 3, 1) . "\n"; $errors++; continue; } $product->setIdSubfamily($subfamily->getIdSubfamily()); $product->setBuyUnit($sapProduct->getBuyUnitMsr()); $product->setCost(0); $product->setIdCurrency(1); $product->setIdIncoterm(1); $product->setImportant(0); $product->setInventaryItem($sapProduct->getInvntItem() == 'Y' ? 1 : 0); $product->setInventoryUnit($sapProduct->getInvntryUom()); $product->setItemCode($sapProduct->getItemcode()); $product->setItemName($sapProduct->getItemname()); $product->setKeyMother(substr($sapProduct->getItemcode(), 0, 7)); $product->setMcDepth($sapProduct->getUMCProfundida()); $product->setMcFront($sapProduct->getUMCFrente()); $product->setMcHeight($sapProduct->getUMCAltura()); $product->setMcParts($sapProduct->getUPzasXCaja()); $product->setMcWeight($sapProduct->getUMCPeso()); $product->setNumBuy($sapProduct->getNumInBuy()); $product->setNumSales($sapProduct->getNumInSales()); $product->setPurchaseItem($sapProduct->getPrchseItem() == 'Y' ? 1 : 0); $product->setPzaDepth($sapProduct->getUPzaprofu()); $product->setPzaDiameter($sapProduct->getUPzadiametro()); $product->setPzaFront($sapProduct->getUPzafrente()); $product->setPzaHeight($sapProduct->getUPpzaaltura()); $product->setPzaWeight($sapProduct->getUPesoXPza()); $product->setRescue(0); $product->setSaiUnit($sapProduct->getSAlUnitMsr()); $product->setSellItem($sapProduct->getSellItem() == 'Y' ? 1 : 0); $product->setStatus($sapProduct->getSWW()); if ($save) { $this->getProductCatalog()->create($product); $new++; } else { $this->getProductCatalog()->update($product); $updated++; } echo "0, Ok! \n"; } echo "\n\nTotals:\nErrors: " . $errors . "\nNew: " . $new . "\nUpdated: " . $updated; die; }
/** * * @return array */ public function editAction() { $id = $this->getRequest()->getParam('id'); $productionTimePrintingTechniques = ProductionTimePrintingTechniqueQuery::create()->findByPKOrThrow($id, $this->i18n->_("Not exists the ProductionTimePrintingTechnique with id {$id}")); $this->view->setTpl("Form"); $this->view->productionTime = $productiontimeQuery = ProductionTimePrintingTechniqueQuery::create()->innerJoinProductPrintingArea()->findByPKOrThrow($id, $this->i18n->_("No exists Production Time Printing Technique")); $this->view->printingArea = $printingArea = ProductPrintingAreaQuery::create()->findByPKOrElse($productiontimeQuery->getIdProductPrintingArea(), new ProductPrintingArea()); $this->view->product = ProductQuery::create()->findOneOrElse($printingArea->getIdProduct(), new Product()); $this->view->technique = PrintingTechniqueQuery::create()->findByPKOrElse($productiontimeQuery->getIdPrintingTechnique(), new PrintingTechnique()); $this->view->size = $size = PrintingSizeQuery::create()->findByPKOrElse($printingArea->getIdPrintingSize(), new \Application\Model\Bean\PrintingSize()); // die(print_r($productiontimeQuery)); }
/** * * @param ProformaInvoiceEvent $proformaInvoiceEvent */ public function createProformaInvoiceProductionEndNotification(ProformaInvoiceEvent $proformaInvoiceEvent) { $proformaInvoice = $proformaInvoiceEvent->getProformaInvoice(); $proformaInvoiceEntries = $proformaInvoiceEvent->getProformaInvoiceEntries(); $products = ProductQuery::create()->whereAdd(Product::ITEM_CODE, $proformaInvoiceEntries->getIdProducts(), ProductQuery::IN)->find(); $vars = array('subject' => 'A Proforma Invoice Entry has finished its production', 'proforma_invoice' => $proformaInvoice->toArray()); $i = 0; $entries = array(); while ($proformaInvoiceEntry = $proformaInvoiceEntries->read()) { $entries[$i] = $proformaInvoiceEntry->toArray(); $entries[$i]['product'] = $products->getByPK($proformaInvoiceEntry->getIdProduct())->toArray(); $i++; } $vars['proforma_invoice_entries'] = $entries; $this->createNotification(NotificationType::$id['PROFORMA_INVOICE_END_PRODUCTION'], $vars); }
/** * */ public function exportToExcelAction() { $params = $this->getRequest()->getParams(); $proformasInvoice = ProformaInvoiceQuery::create()->filter($params)->find(); $proformasInvoiceEntries = ProformaInvoiceEntryQuery::create()->whereAdd(ProformaInvoiceEntry::ID_PROFORMA_INVOICE, $proformasInvoice->getPrimaryKeys(), ProformaInvoiceEntryQuery::IN)->find(); $suppliers = SapSupplierQuery::create()->whereAdd(SapSupplier::CARDCODE, $proformasInvoice->getDistinctSuppliers(), SupplierQuery::IN)->find(); $products = ProductQuery::create()->whereAdd(Product::ITEM_CODE, $proformasInvoiceEntries->getIdProducts(), ProductQuery::IN)->find(); $currencies = CurrencyQuery::create()->find(); $countries = CountryQuery::create()->find(); require_once 'PHPExcel.php'; $objPHPExcel = new PHPExcel(); $activeSheet = $objPHPExcel->setActiveSheetIndex(0); $activeSheet->setCellValue('A1', $this->i18n->_('Proforma Invoice Folio'))->setCellValue('B1', $this->i18n->_('Proforma Invoice Number'))->setCellValue('C1', $this->i18n->_('Proforma Invoice Status'))->setCellValue('D1', $this->i18n->_('Supplier Code'))->setCellValue('E1', $this->i18n->_('Supplier Name'))->setCellValue('F1', $this->i18n->_('Destination Country'))->setCellValue('G1', $this->i18n->_('Creation Date'))->setCellValue('H1', $this->i18n->_('Line Number'))->setCellValue('I1', $this->i18n->_('Line Status'))->setCellValue('J1', $this->i18n->_('Parent Key'))->setCellValue('K1', $this->i18n->_('Product Key'))->setCellValue('L1', $this->i18n->_('Description'))->setCellValue('M1', $this->i18n->_('Quantity'))->setCellValue('N1', $this->i18n->_('Open Price'))->setCellValue('O1', $this->i18n->_('Import'))->setCellValue('P1', $this->i18n->_('Currency')); $i = 2; while ($proformasInvoice->valid()) { $proformaInvoice = $proformasInvoice->read(); $supplier = $suppliers->getByPK($proformaInvoice->getIdSupplier()); $country = $countries->getByPK($proformaInvoice->getIdDestinationCountry()); $proformaInvoiceEntries = $proformasInvoiceEntries->getByIdProformaInvoice($proformaInvoice->getIdProformaInvoice()); $currency = $currencies->getByPkOrEmpty($proformaInvoice->getIdCurrency()); $entriesCount = $i; while ($proformaInvoiceEntries->valid()) { $proformaInvoiceEntry = $proformaInvoiceEntries->read(); $product = $products->getByPK($proformaInvoiceEntry->getIdProduct()); $activeSheet->setCellValue('A' . $entriesCount, $proformaInvoice->getIdProformaInvoice())->setCellValue('B' . $entriesCount, $proformaInvoice->getFolio())->setCellValue('C' . $entriesCount, $proformaInvoice->getStatusName())->setCellValue('D' . $entriesCount, $supplier->getCardCode())->setCellValue('E' . $entriesCount, $supplier->getCardname())->setCellValue('F' . $entriesCount, utf8_encode($country->getName()))->setCellValue('G' . $entriesCount, $proformaInvoice->getDocDate())->setCellValue("H" . $entriesCount, $proformaInvoiceEntry->getLine())->setCellValue("I" . $entriesCount, $proformaInvoiceEntry->getStatusName())->setCellValue("J" . $entriesCount, $product->getKeyMother())->setCellValue("K" . $entriesCount, $product->getItemCode())->setCellValue("L" . $entriesCount, $product->getItemName())->setCellValue("M" . $entriesCount, $proformaInvoiceEntry->getQuantity())->setCellValue("N" . $entriesCount, $proformaInvoiceEntry->getPrice())->setCellValue("O" . $entriesCount, $proformaInvoiceEntry->getQuantity() * $proformaInvoiceEntry->getPrice())->setCellValue("P" . $entriesCount, $currency->getCurrCode()); $entriesCount++; } $i = $entriesCount; } header("Content-Type: application/vnd.ms-excel"); $date = \Zend_Date::now(); $fileName = $this->i18n->_("Proforma_invoice_report") . $date->get("ddMMyyyy"); header("Content-Disposition: attachment; filename=\"{$fileName}.xlsx\""); header("Cache-Control: max-age=0"); $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save("php://output"); exit; }
private function getPurchaseOrders($idFolioImport, $status = null, $in = true) { $id = $idFolioImport; $purchaseOrderFolioQuery = PurchaseOrderFolioQuery::create()->addColumn(PurchaseOrderFolio::ID_PURCHASE_ORDER)->whereAdd(PurchaseOrderFolio::ID_FOLIO_IMPORT, $id); if ($status == null) { $query = PurchaseOrderQuery::create()->whereAdd(PurchaseOrder::ID_PURCHASE_ORDER, $purchaseOrderFolioQuery, PurchaseOrderQuery::IN)->count(); $purchaseOrderQuery = PurchaseOrderQuery::create()->whereAdd(PurchaseOrder::ID_PURCHASE_ORDER, $purchaseOrderFolioQuery, PurchaseOrderQuery::IN)->fetchAll(); } else { if ($in) { $query = PurchaseOrderQuery::create()->whereAdd(PurchaseOrder::ID_PURCHASE_ORDER, $purchaseOrderFolioQuery, PurchaseOrderQuery::IN)->whereAdd(PurchaseOrder::STATUS, PurchaseOrder::$Status[$status], PurchaseOrderQuery::IN)->count(); $purchaseOrderQuery = PurchaseOrderQuery::create()->whereAdd(PurchaseOrder::ID_PURCHASE_ORDER, $purchaseOrderFolioQuery, PurchaseOrderQuery::IN)->whereAdd(PurchaseOrder::STATUS, PurchaseOrder::$Status[$status], PurchaseOrderQuery::IN)->fetchAll(); } else { $query = PurchaseOrderQuery::create()->whereAdd(PurchaseOrder::ID_PURCHASE_ORDER, $purchaseOrderFolioQuery, PurchaseOrderQuery::IN)->whereAdd(PurchaseOrder::STATUS, PurchaseOrder::$Status[$status], PurchaseOrderQuery::NOT_EQUAL)->count(); $purchaseOrderQuery = PurchaseOrderQuery::create()->whereAdd(PurchaseOrder::ID_PURCHASE_ORDER, $purchaseOrderFolioQuery, PurchaseOrderQuery::IN)->whereAdd(PurchaseOrder::STATUS, PurchaseOrder::$Status[$status], PurchaseOrderQuery::NOT_EQUAL)->fetchAll(); } } if ($query) { $i = 0; foreach ($purchaseOrderQuery as $purchaseOrder) { try { $purchaseOrderEntryQuery = PurchaseOrderEntryQuery::create()->whereAdd(PurchaseOrder::ID_PURCHASE_ORDER, $purchaseOrder['id_purchase_order'])->fetchAll(); $price = 0; $cbm = 0; $individual_packs = 0; $cartons = 0; $quantity = 0; $weight = 0; $valuable = array(); $j = 0; $packingList = PurchaseOrderFileQuery::create()->whereAdd(PurchaseOrderFile::ID_PURCHASE_ORDER, $purchaseOrder['id_purchase_order'])->whereAdd(PurchaseOrderFile::DOCUMENT_TYPE, PurchaseOrderFile::$DocumentType['PackingList'])->count(); $commercialInvoice = PurchaseOrderFileQuery::create()->whereAdd(PurchaseOrderFile::ID_PURCHASE_ORDER, $purchaseOrder['id_purchase_order'])->whereAdd(PurchaseOrderFile::DOCUMENT_TYPE, PurchaseOrderFile::$DocumentType['CommercialInvoice'])->count(); if ($packingList) { $purchaseOrders[$i]['packing_list'] = true; } else { $purchaseOrders[$i]['packing_list'] = false; } if ($commercialInvoice) { $purchaseOrders[$i]['commercial_invoice'] = true; } else { $purchaseOrders[$i]['commercial_invoice'] = false; } foreach ($purchaseOrderEntryQuery as $purchaseOrderEntry) { $product = ProductQuery::create()->findByPK($purchaseOrderEntry['id_product'])->toArray(); if (!empty($product['mc_parts'])) { $cartonsEntry = ceil($purchaseOrderEntry['quantity'] / $product['mc_parts']); } else { $this->setFlash('warning', $this->i18n->_("You must edit MC Parts, it cannot be cero.")); $this->_redirect('product/edit/id/' . $product['id_product']); } $volume = $product['mc_front'] * $product['mc_height'] * $product['mc_depth'] / 1000000; $cbm += $cartonsEntry * $volume; $weight += $cartonsEntry * $product['mc_weight']; $price += $purchaseOrderEntry['quantity'] * $purchaseOrderEntry['price']; $cartons += $cartonsEntry; $quantity += $purchaseOrderEntry['quantity']; $entries[$j]['id_product'] = $product['id_product']; $entries[$j]['status'] = $this->getPurchaseOrderEntryStatus($purchaseOrderEntry['status']); $entries[$j]['important'] = $product['important']; $entries[$j]['item_code'] = $product['item_code']; $entries[$j]['product'] = $product['item_name']; $entries[$j]['price'] = $purchaseOrderEntry['price']; $entries[$j]['amount'] = $purchaseOrderEntry['quantity'] * $purchaseOrderEntry['price']; $entries[$j]['cartons'] = $cartonsEntry; $entries[$j]['quantity'] = $purchaseOrderEntry['quantity']; $entries[$j]['weight'] = $product['mc_weight'] * $cartonsEntry; $entries[$j]['volume'] = number_format($volume * $cartonsEntry, 2); $entries[$j]['default_shipping'] = FreightTypeQuery::create()->findByPK($product['default_freight_fare'])->getName(); if (!empty($product['import_permit'])) { $importPermit = FileQuery::create()->findByPK($product['import_permit']); if ($importPermit) { $entries[$j]['import_permit'] = true; } else { $entries[$j]['import_permit'] = false; } } else { $entries[$j]['import_permit'] = false; } $entries[$j]['row_status'] = 'success'; $purchaseOrders[$i]['row_status'] = 'success'; if (!$entries[$j]['import_permit']) { $entries[$j]['row_status'] = 'error'; $purchaseOrders[$i]['row_status'] = 'error'; $entries[$j]['label'] = $this->i18n->_('This product, does not have an Import Clearance Document.'); $purchaseOrders[$i]['label'] = $this->i18n->_('This Purchase Order has entries without Import Clearance.'); } else { if (!$purchaseOrders[$i]['commercial_invoice']) { $purchaseOrders[$i]['row_status'] = 'error'; $purchaseOrders[$i]['label'] = $this->i18n->_('This Purchase Order, does not have a Commercial Invoice Document.'); } else { if (!$purchaseOrders[$i]['packing_list']) { $purchaseOrders[$i]['row_status'] = 'error'; $purchaseOrders[$i]['label'] = $this->i18n->_('This Purchase Order, does not have a Packing List Document.'); } else { if ($product['important']) { $entries[$j]['row_status'] = 'warning'; $purchaseOrders[$i]['row_status'] = 'warning'; $entries[$j]['label'] = $this->i18n->_('This product is small and valuable.'); $purchaseOrders[$i]['label'] = $this->i18n->_('This Purchase Order has small and valuable stuff.'); } else { $entries[$j]['row_status'] = 'success'; $purchaseOrders[$i]['row_status'] = 'success'; } } } } $j++; } //Checks if the entry has important stuff if (count($valuable) == 1) { $purchaseOrders[$i]['importance'] = $valuable[1]; } else { $flag = 0; $value = $valuable[1]; for ($j = 2; $j <= count($valuable); $j++) { if ($valuable[$j] != $value) { $value = 2; break; } } $purchaseOrders[$i]['importance'] = $value; } switch ($purchaseOrders[$i]['importance']) { case '1': $purchaseOrders[$i]['importance'] = $this->i18n->_('Yes'); break; case '2': $purchaseOrders[$i]['importance'] = $this->i18n->_('Mixed'); break; default: $purchaseOrders[$i]['importance'] = $this->i18n->_('No'); } } catch (Exception $e) { var_dump($e->getMessage()); } $purchaseOrders[$i]['id_purchase_order_folio'] = PurchaseOrderFolioQuery::create()->whereAdd(PurchaseOrderFolio::ID_PURCHASE_ORDER, $purchaseOrder['id_purchase_order'])->whereAdd(PurchaseOrderFolio::ID_FOLIO_IMPORT, $idFolioImport)->findOne()->getIdPurchaseOrderFolio(); $cartons = 0; $quantity = 0; $weight = 0; $cbm = 0; $price = 0; foreach ($entries as $entry) { $cartons += intval($entry['cartons']); $quantity += intval($entry['quantity']); $weight += $entry['weight']; $cbm += $entry['volume']; $price += $entry['price'] * $entry['quantity']; } $purchaseOrders[$i]['entries'] = $entries; $purchaseOrders[$i]['cartons'] = $cartons; $purchaseOrders[$i]['quantity'] = $quantity; $purchaseOrders[$i]['weight'] = $weight; $purchaseOrders[$i]['cbm'] = number_format($cbm, 2); $purchaseOrders[$i]['price'] = $price; $purchaseOrders[$i]['id_purchase_order'] = $purchaseOrder['id_purchase_order']; $purchaseOrders[$i]['courtyard_arrival_date'] = $purchaseOrder['courtyard_arrival_date']; $i++; } return $purchaseOrders; } else { return null; } }
/** * * Brings the products from a storage that are used in de VIM * @param \Application\Model\Collection\InventoryRotationCollection $inventory * @return \Application\Model\Collection\ProductCollection */ private function getProducts($inventory) { $name = 'products'; $storageService = $this->getStorageService(); $products = $storageService->getValue($name); if (!$products) { $products = ProductQuery::create()->whereAdd(Product::ITEM_CODE, $inventory->getDistinctItemCodes(), BaseQuery::IN)->addAscendingOrderBy(Product::ITEM_CODE)->find(); $storageService->saveValue($products, $name); } return $products; }
public function dataAction() { $this->view->contentTitle = $this->i18n->_("Required Data"); $inventory = InventoryRotationQuery::create()->find(); $products = ProductQuery::create()->whereAdd(Product::ITEM_CODE, $inventory->getDistinctItemCodes(), BaseQuery::IN)->whereAdd(Product::STATUS, array(Product::$Status["Hold"], Product::$Status["Line"]), ProductQuery::IN)->addAscendingOrderBy(Product::ITEM_CODE)->find(); $this->view->products = $products->getProductsWithoutRestockRequiredData(); $this->view->setTpl("Data"); }
/** * * @param string $family * @return \Application\Managers\RotationsManager\Stocks\KeyMotherStock */ public function filterByStatus($status) { $newStock = $this->newInstance(); foreach ($this->stock as $stockLine) { $products = ProductQuery::create()->whereAdd(Product::ITEM_CODE, $stockLine->getKeyMother(), ProductQuery::LIKE)->find(); while ($product = $products->read()) { if ($product->getStatus() == $status) { $newStock->addStockable($stockLine); break; } } } return $newStock; }
public function exportToExcelAction() { $params = $this->getRequest()->getParams(); $requisitions = RequisitionQuery::create()->filter($params)->whereAdd(Requisition::STATUS, Requisition::$Status["Inactive"], BaseQuery::NOT_EQUAL)->find(); $requisitionIds = RequisitionQuery::create()->filter($params)->whereAdd(Requisition::STATUS, Requisition::$Status["Inactive"], BaseQuery::NOT_EQUAL)->fetchCol(); $allRequisitionEntries = RequisitionEntryQuery::create()->whereAdd(RequisitionEntry::ID_REQUISITION, $requisitionIds, RequisitionEntryQuery::IN)->find(); $currencies = CurrencyQuery::create()->find(); $products = ProductQuery::create()->whereAdd(Product::ITEM_CODE, $allRequisitionEntries->getDistinctProducts(), ProductQuery::IN)->find(); $countries = CountryQuery::create()->find(); $suppliers = SapSupplierQuery::create()->whereAdd(SapSupplier::CARDCODE, $allRequisitionEntries->getDistinctSuppliers(), SupplierQuery::IN)->find(); require_once 'PHPExcel.php'; $objPHPExcel = new PHPExcel(); $activeSheet = $objPHPExcel->setActiveSheetIndex(0); $activeSheet->setCellValue('A1', $this->i18n->_('Requisition Folio'))->setCellValue('B1', $this->i18n->_('Requisition Status'))->setCellValue('C1', $this->i18n->_('Reference'))->setCellValue('D1', $this->i18n->_('Creation Date'))->setCellValue('E1', $this->i18n->_('Destination'))->setCellValue('F1', $this->i18n->_('Parent Key'))->setCellValue('G1', $this->i18n->_('Product Status'))->setCellValue('H1', $this->i18n->_('Product Code'))->setCellValue('I1', $this->i18n->_('Product Description'))->setCellValue('J1', $this->i18n->_('Line Status'))->setCellValue('K1', $this->i18n->_('Supplier Default Code'))->setCellValue('L1', $this->i18n->_('Supplier Default Name'))->setCellValue('M1', $this->i18n->_('Ammount'))->setCellValue('N1', $this->i18n->_('Target Price'))->setCellValue('O1', $this->i18n->_('Price'))->setCellValue('P1', $this->i18n->_('Import'))->setCellValue('Q1', $this->i18n->_('currency')); $i = 2; while ($requisitions->valid()) { $requisition = $requisitions->read(); $requisitionEntries = $allRequisitionEntries->filterByIdRequisition($requisition->getIdRequisition()); $country = $countries->getByPK($requisition->getIdDestinationCountry()); $entriesCount = $i; while ($requisitionEntries->valid()) { $requisitionEntry = $requisitionEntries->read(); $product = $products->containsIndex($requisitionEntry->getIdProduct()) ? $products->getByPK($requisitionEntry->getIdProduct()) : new Product(); $supplier = $requisitionEntry->getIdSupplierDefault() > 0 ? $suppliers->getByPkOrElse($requisitionEntry->getIdSupplierDefault(), new SapSupplier()) : new SapSupplier(); $currency = $currencies->getByPK($requisitionEntry->getIdCurrency()); $activeSheet->setCellValue("F" . $entriesCount, $product->getKeyMother())->setCellValue("G" . $entriesCount, $product->getStatus())->setCellValue("H" . $entriesCount, $product->getItemCode())->setCellValue("I" . $entriesCount, $product->getItemName())->setCellValue("J" . $entriesCount, $requisitionEntry->getStatusName())->setCellValue("K" . $entriesCount, $supplier->getCardCode())->setCellValue("L" . $entriesCount, $supplier->getCardname())->setCellValue("M" . $entriesCount, $requisitionEntry->getQuantity())->setCellValue("N" . $entriesCount, $product->getCost())->setCellValue("O" . $entriesCount, $requisitionEntry->getPrice())->setCellValue("P" . $entriesCount, $requisitionEntry->getImport())->setCellValue("Q" . $entriesCount, $currency->getCurrCode()); $entriesCount++; } $activeSheet->mergeCells('A' . $i . ':A' . ($entriesCount - 1))->setCellValue('A' . $i, $requisition->getIdRequisition())->mergeCells('B' . $i . ':B' . ($entriesCount - 1))->setCellValue('B' . $i, $requisition->getStatusName())->mergeCells('C' . $i . ':C' . ($entriesCount - 1))->setCellValue('C' . $i, $requisition->getNumRequisition())->mergeCells('D' . $i . ':D' . ($entriesCount - 1))->setCellValue('D' . $i, $requisition->getDate())->mergeCells('E' . $i . ':E' . ($entriesCount - 1))->setCellValue('E' . $i, utf8_encode($country->getName())); $i = $entriesCount; } header("Content-Type: application/vnd.ms-excel"); $date = \Zend_Date::now(); $fileName = $this->i18n->_("Requisitions_report") . $date->get("ddMMyyyy"); header("Content-Disposition: attachment; filename=\"{$fileName}.xlsx\""); header("Cache-Control: max-age=0"); $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save("php://output"); exit; }