/** * @author Jose luis */ public function getCountryAction() { $id = $this->getRequest()->getParam('id'); $idAddress = SupplierQuery::create()->findByPK($id)->getIdInvoiceAddress(); $country = AddressQuery::create()->findByPK($idAddress)->getCountry(); die(json_encode($country)); }
public function createGenericPayment(PurchaseOrderEvent $event, $type) { $purchaseOrder = $event->getPurchaseOrder(); //TODO: agregar arreglo de eventos a PurchaseOrderPaymentTerm $paymentTerms = PurchaseOrderPaymentTermQuery::create()->whereAdd(PurchaseOrderPaymentTerm::ID_EVENT, $type)->whereAdd(PurchaseOrderPaymentTerm::ID_PURCHASE_ORDER, $purchaseOrder->getIdPurchaseOrder())->find(); try { $this->getPurchaseOrderProgrammedPaymentCatalog()->beginTransaction(); while ($paymentTerms->valid()) { $paymentTerm = $paymentTerms->read(); if (PurchaseOrderProgrammedPaymentQuery::create()->whereAdd(PurchaseOrderProgrammedPayment::ID_PURCHASE_ORDER_PAYMENT_TERM, $paymentTerm->getIdPurchaseOrderPaymentTerm())->find()->count() > 0) { continue; } $payment = new PurchaseOrderProgrammedPayment(); $payment->setIdPurchaseOrderPaymentTerm($paymentTerm->getIdPurchaseOrderPaymentTerm()); $payment->setAmmount($paymentTerm->getAmount()); $payment->setDueDate(\Zend_Date::now()->addDay(15)->get("YYYY-MM-dd")); //TODO: dias del cat�logo $payment->setIdCompany(SupplierQuery::create()->findByPK($purchaseOrder->getIdSupplier())->getIdCompany()); $payment->setIdCurrency($purchaseOrder->getIdCurrency()); $payment->setIdPurchaseOrder($purchaseOrder->getIdPurchaseOrder()); $payment->setStatus(PurchaseOrderProgrammedPayment::$TypeStatus['Pending']); $payment->setType(PurchaseOrderProgrammedPayment::$TypePayment['PurchaseOrder']); $this->getPurchaseOrderProgrammedPaymentCatalog()->create($payment); } $this->getPurchaseOrderProgrammedPaymentCatalog()->commit(); } catch (Exception $e) { $this->getPurchaseOrderProgrammedPaymentCatalog()->rollBack(); throw $e; } }
/** * * @param int $idFolioImport * @return array $warehouseEntries */ private function getWarehouseEntries($idFolioImport) { $count = WarehouseEntranceQuery::create()->whereAdd(WarehouseEntrance::ID_FOLIO_IMPORT, $idFolioImport)->count(); if ($count) { $warehouseEntries = WarehouseEntranceQuery::create()->addColumn('WarehouseEntrance.' . WarehouseEntrance::ID_WAREHOUSE_ENTRANCE)->addColumn('WarehouseEntrance.' . WarehouseEntrance::ID_PURCHASE_ORDER)->addColumn('WarehouseEntrance.' . WarehouseEntrance::GROUPNUM)->addColumn('WarehouseEntrance.' . WarehouseEntrance::ARRIVAL_DATE)->addColumn('WarehouseEntrance.' . WarehouseEntrance::ID_SUPPLIER)->addColumn('WarehouseEntrance.' . WarehouseEntrance::COMMENTS)->addColumn('WarehouseEntrance.' . WarehouseEntrance::STATUS)->addColumn('Warehouse.' . Warehouse::LOCATION, 'warehouse')->whereAdd(WarehouseEntrance::ID_FOLIO_IMPORT, $idFolioImport)->innerJoinWarehouse()->fetchAll(); foreach ($warehouseEntries as $key => $warehouseEntry) { $warehouseEntries[$key]['supplier'] = SupplierQuery::create()->findByPK($warehouseEntry['id_supplier'])->getName(); $status = WarehouseEntrance::$Status; $status = array_flip($status); $warehouseEntries[$key]['status'] = $status[$warehouseEntries[$key]['status']]; } return $warehouseEntries; } else { return null; } }
/** * * Gets all Suppliers from SAP, searches the DB for the cardcode, then updates or creates */ public function syncSuppliersAction() { $r = SapSupplierQuery::create()->whereAdd(SapSupplier::CARDTYPE, "s", SapSupplierQuery::EQUAL)->find(); echo "<pre>"; $errors = 0; $new = 0; $updated = 0; while ($r->valid()) { $save = 0; $sapSupplier = $r->read(); echo "Name: " . $sapSupplier->getCardname() . " Code: " . $sapSupplier->getCardcode() . "\n"; $supplier = SupplierQuery::create()->whereAdd(Supplier::SAP_ID_BUSSINESS_ASSOCIATE, $sapSupplier->getCardcode(), SupplierQuery::EQUAL)->findOne(); if (!$supplier instanceof Supplier) { $supplier = new Supplier(); $save = 1; } $currency = CurrencyQuery::create()->whereAdd(Currency::CODE, substr($sapSupplier->getCardcode(), 0, 3))->findOne(); if (!$currency instanceof Currency) { echo " Error! No Currency: " . substr($sapSupplier->getCardcode(), 0, 3) . "\n"; $errors++; continue; } $supplier->setIdCurrency($currency->getIdCurrency()); $supplier->setCardName($sapSupplier->getCardname()); $supplier->setConsistency(0); $supplier->setIdApprovalStatus(1); $supplier->setIdPaymentTerm(1); $supplier->setName($sapSupplier->getCardname()); $supplier->setQuality(0); $supplier->setRfc($sapSupplier->getLicTradNum()); $supplier->setSapIdBussinessAssociate($sapSupplier->getCardcode()); $supplier->setStatus(1); $supplier->setTime(0); $supplier->setIdDefaultPort(1); $supplier->setTypePerson($sapSupplier->getCmpPrivate()); try { $this->getSupplierCatalog()->beginTransaction(); if ($save) { $this->getSupplierCatalog()->create($supplier); $new++; } else { $this->getSupplierCatalog()->update($supplier); $updated++; } $this->getSupplierCatalog()->commit(); } catch (Exception $e) { $this->getSupplierCatalog()->rollBack(); echo "\nError al intentar guardar el proveedor: " . $e->getMessage(); } } echo "\n\nTotals:\nErrors: " . $errors . "\nNew: " . $new . "\nUpdated: " . $updated; die; }