/**
* @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;
}
