<?php
foreach ($products as $index => $product) {
?>
<h1><?php
echo link_to($product->getName(), "product/edit?id=" . $product->getId());
?>
</h1>
<table border=1>
<tr>
<td>Warehouse</td>
<td>Qty</td>
<td>View</td>
</tr>
<?php
foreach (WarehouseTable::fetchAll() as $warehouse) {
$stock = StockTable::fetch($warehouse->getId(), $product->getId());
?>
<tr>
<td><?php
echo $warehouse->getName();
?>
</td>
<td><?php
echo $stock->getCurrentQty();
?>
</td>
<td><?php
echo link_to("View", "stock/view?id=" . $stock->getId());
?>
</td>
public function executeStocksearch(sfWebRequest $request)
{
$this->searchstring = $request->getParameter("searchstring");
$requestparams = $request->getParameter("invoicedetail");
$this->product_id = $requestparams["product_id"];
$this->warehouses = WarehouseTable::fetchAll();
$this->products = array();
if ($this->searchstring != "") {
$this->products = Doctrine_Query::create()->from('Product p')->orderBy('p.name')->where('p.name like "%' . $this->searchstring . '%"')->execute();
} else {
if ($this->product_id) {
$this->products = Doctrine_Query::create()->from('Product p, p.Stock s, s.Warehouse w')->where('p.id =' . $this->product_id)->execute();
}
}
}
