public function insert(Merchandise $merchandise)
{
$merchandise->setItem_id(null);
$sql = '
INSERT INTO merchandise (item_id, item_name, item_price, original_url, img_url, company_id)
VALUES (:item_id, :item_name, :item_price, :original_url, :img_url, :company_id)';
return $this->execute($sql, $merchandise);
}
public static function map(Merchandise $merchandise, array $properties)
{
if (array_key_exists('item_id', $properties)) {
$merchandise->setItem_id((int) $properties['item_id']);
}
if (array_key_exists('item_name', $properties)) {
$merchandise->setItem_name($properties['item_name']);
}
if (array_key_exists('item_price', $properties)) {
$merchandise->setItem_price((double) $properties['item_price']);
}
if (array_key_exists('original_url', $properties)) {
$merchandise->setOriginal_url($properties['original_url']);
}
if (array_key_exists('img_url', $properties)) {
$merchandise->setImg_url($properties['img_url']);
}
if (array_key_exists('company_id', $properties)) {
$merchandise->setCompany_id((int) $properties['company_id']);
}
}
