public function actionCreateItem()
{
if ($_GET['product']) {
$sql = $this->db->prepare(QueryBuilder::getInstance()->select('id,name,type')->from('field')->where('productid=?'));
$sql->execute(array($_GET['product']));
$out = array();
while ($row = $sql->fetch()) {
if (Item::checkHidden($row['type'])) {
continue;
}
unset($row['type']);
$out[] = $row;
}
echo json_encode($out);
exit;
}
$message = $this->user->message();
if (isset($_POST['save'])) {
$item = $_POST['item'];
//validate
try {
if (empty($item['productid'])) {
throw new Exception('لطفا یک محصول مناسب انتخاب کنید');
}
$sql = $this->db->prepare(QueryBuilder::getInstance()->insert('item')->into(array('productid', 'status', 'createtime'), true));
$item['createtime'] = time();
$item['status'] = Application::STATUS_PENDING;
$sql->execute($item);
$id = $this->db->lastInsertId();
foreach ($_POST['value'] as $key => $field) {
if (!$field['value']) {
continue;
}
$sql = $this->db->prepare(QueryBuilder::getInstance()->insert('value')->into(array('fieldid', 'itemid', 'value'), true, false));
$sql->execute(array($field['fieldid'], $id, $field['value']));
}
$message['content'] = 'تغییرات با موفقیت ذخیره شد';
$message['type'] = 'success';
$this->user->message($message);
CShop::app()->redirect('edititem.php?id=' . $id);
} catch (Exception $e) {
$message['content'] = $e->getMessage();
}
} else {
$item = array('productid' => '');
}
if (is_array($_POST['value'])) {
$values = $_POST['value'];
}
$products = array();
$sql = $this->db->query(QueryBuilder::getInstance()->select('product.*,category.name as categoryname')->from('product')->leftJoin('category')->on('categoryid = category.id')->where('skipitem =0')->order('`order`'));
while ($row = $sql->fetch()) {
$products[$row['categoryname']][$row['id']] = $row['name'];
}
$this->render('admin/itemform', array('message' => $message, 'item' => $item, 'values' => $values, 'products' => $products));
}
echo $message['content'];
?>
</div>
</div>
<?php
foreach ($items as $item) {
?>
<div class="show">
<div class="title">
<?php
echo $item[0]['name'];
?>
</div>
<?php
foreach ($item as $i) {
if (!isset($i['value']) || Item::checkHidden($i['type'])) {
continue;
}
echo '<span><li>' . $i['fieldname'] . '</li>';
echo Item::proccess($i['type'], $i['value']) . '</span>';
}
?>
<div class="bottom"><?php
echo $item[0]['description'];
?>
</div>
</div>
<?php
}
?>
</div>
