/**
Helper: update vendor costs when updating a product cost
if the product has a defined vendor
*/
public function updateCostByUPC($upc, $cost, $vendorID)
{
$updateP = $this->connection->prepare('
UPDATE vendorItems
SET cost=?,
modified=' . $this->connection->now() . '
WHERE vendorID=?
AND sku=?');
$skuModel = new VendorSKUtoPLUModel($this->connection);
$skuModel->vendorID($vendorID);
$skuModel->upc($upc);
foreach ($skuModel->find() as $obj) {
$this->connection->execute($updateP, array($cost, $vendorID, $obj->sku()));
}
$vModel = new VendorItemsModel($this->connection);
$vModel->vendorID($vendorID);
$vModel->upc($upc);
foreach ($vModel->find() as $obj) {
$this->connection->execute($updateP, array($cost, $vendorID, $obj->sku()));
}
}
