/**
* edit item form
* @param $id
* @param $dbObj
* @return string
*/
function editItem($id, $dbObj)
{
$query = "SELECT t1.itemId, t1.name, t1.image, t2.price, t1.description,\n t2.quantity, t3.onsale, t3.salePrice FROM item t1\n JOIN inventory t2 ON t1.itemId = t2.itemId\n JOIN itemsale t3 ON t2.itemId = t3.itemId WHERE t1.itemId = :itemid";
$rs = $dbObj->select($query, array(":itemid" => $id));
$html = "<div class='container'><h2>Edit Item</h2><div class='jumbotron'><form method='POST' action='admin.php'>";
//save into fields
foreach ($rs as $result) {
$obj = new InventoryItem($result);
$html .= "<label name='id' value='" . $obj->getId() . "'>ID:" . $obj->getId() . "</label><label for='name'>Name: </label>\n <br><br><input type='text' name='name' id='name' value='" . $obj->getName() . "'>\n <br><br><label for='image'>Image: </label><input type='text' name='image' id='image' value='" . $obj->getImage() . "'>\n <br><br><label for='price'>Price: </label><input type='text' name='price' id='price' value='" . $obj->getPrice() . "'>\n <br><br><label for='quantity'>Quantity: </label><input type='text' name='quantity' id='quantity' value='" . $obj->getQuantity() . "'>\n <br><br><label for='description'>Description: </label><input type='text' name='description' id='description' value='" . $obj->getDescription() . "'>\n <br><br><label for='onsale'>On Sale: </label><input type='text' name='onsale' id='onsale' value='" . $obj->getOnSale() . "'>\n <br><br><label for='saleprice'>Sale Price: </label><input type='text' name='saleprice' id='saleprice' value='" . $obj->getSalePercent() . "'>";
}
$html .= "<br><br><button class='btn btn-primary' name='submit' value='update'>Submit</button></form></div></div>";
return $html;
}
