</tr>
</thead>
<tbody>
<?php
foreach ($items as $item) {
?>
<tr>
<td>
<?php
echo $item->prepareItemId();
?>
</td>
<?php
$total = 0;
for ($i = 1; $i <= 12; $i++) {
$value = Inv_movement::findByMonth($branch, $i, $item->getItemId());
$arr[$item->getItemId()][$i] = $value;
echo "<td>" . ($value > 0 ? "+" . $value : $value);
$total = $total + $arr[$item->getItemId()][$i];
echo "(" . $total . ")</td>";
}
?>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<?php
$tmpl->place('footer');
static function resetStock($id, $quantity)
{
try {
$record = new self($id);
$previous_q = $record->getQuantity();
$record->setQuantity($quantity);
$record->store();
$movement = new Inv_movement();
$movement->setItemId($record->getItemId());
$movement->setBranchId($record->getBranchId());
$movement->setDocumentNumber("Reset");
$movement->setQuantity($quantity - $previous_q);
$movement->setDate(date('n/j/Y'));
$movement->store();
} catch (fExpectedException $e) {
echo $e->printMessage();
}
echo $record->getQuantity();
}