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>