/* Add existing datasheets */
$datasheetQuery = "SELECT datasheeturl FROM datasheets WHERE part_id = ".$part["id"];
$r3 = mysql_query($datasheetQuery);
while ($res = mysql_fetch_assoc($r3)) {
$attachment = new PartAttachment();
$attachment->setPart($oPart);
$attachment->replaceFromURL($res["datasheeturl"]);
$attachment->setDescription(PartKeepr::i18n("Datasheet"));
$oPart->getAttachments()->add($attachment);
}
PartKeepr::getEM()->persist($oPart);
$oStock = new StockEntry($oPart, $part["instock"]);
$priceQuery = "SELECT AVG(preis) AS preis FROM preise WHERE part_id = ".$part["id"];
$r2 = mysql_query($priceQuery);
$res = mysql_fetch_assoc($r2);
if ($res) {
if ($res["preis"] !== null) {
$oStock->setPrice(floatval($res["preis"]));
}
}
PartKeepr::getEM()->persist($oStock);
/* Add some random parameters */
public function addStock () {
$part = PartManager::getInstance()->getPart($this->getParameter("part"));
$user = SessionManager::getCurrentSession()->getUser();
$stock = new StockEntry($part, intval($this->getParameter("stock")), $user);
$price = floatval($this->getParameter("price"));
if ($price != 0) {
$stock->setPrice($price);
}
PartKeepr::getEM()->persist($stock);
PartKeepr::getEM()->flush();
$part->updateStockLevel();
PartKeepr::getEM()->flush();
return true;
}
