/**
* 添加分类插入数据库函数
*/
function insert()
{
$category = new CategoryModel();
//如果没有选择单元
if ($_POST['sectionid'] == -1) {
$this->assign('jumpUrl', __URL__ . '/add');
$this->error('请选择正确的单元');
} else {
//如果数据压入成功
if (($data = $category->create()) !== false) {
if ($category->add()) {
$this->assign('jumpUrl', __URL__ . '/index');
$this->success('添加新类别成功');
} else {
$this->assign('jumpUrl', __URL__ . '/index');
$this->error('添加新类别失败' . $category->getDbError());
}
} else {
$this->assign('jumpUrl', __URL__ . '/index');
$this->error('添加失败' . $category->getError());
}
}
}
function add($values)
{
//ak produkt nie je, pridaj
if ($values['Name_sk'] == '') {
return false;
}
//ak je pridany aby ho system nemusel prepisovat
$is_added = false;
if (!isset($this->all_product_param_db[$values['Code']]) and $values['Name_sk'] != '') {
/* [Code] => 21420011
[Name_sk] => Ladies polo shirt, S, white/ blue (01)
[Name_cz] => Dámska poloko?e?a, S, white/ blue (01)
[Name_en] => Ladies polo shirt, S, white/ blue (01)
[Name_de] =>
[Name_hu] =>
[Package] => 1
[Price_CZK] => 124.000000
[Price_EUR] => 4.770000
[Price_SK] => 143.700000
[Image] => p990.02.jpg
[Mark] => Best in Town
[Stock] => 2
[Category1_sk] => Textil
[Category1_cz] => Textil
[Category1_en] => Textile
[Category1_de] =>
[Category1_hu] =>
[Category2_sk] => Výpredaj
[Category2_cz] => Výprodej
[Category2_en] => Discount
[Category2_de] =>
[Category2_hu] =>
[Category3_sk] =>
[Category3_cz] =>
[Category3_en] =>
[Category3_de] =>
[Category3_hu] =>
*/
//zisti ci je v product_temp_parse aby sme zistili group
$product_temp_parse = dibi::fetch("SELECT * FROM product_temp_parse WHERE code = %s", $values['Code']);
if (!$product_temp_parse) {
throw new Exception('Polozka nie je v product_temp_parse. Nemame ako zistit skupinu resp. group_code');
}
//zisti ci group_code je v nasej db ak nie je pridaj
if (!isset($this->all_product_db[$product_temp_parse['group_code']])) {
$arr = array('mark' => $values['Mark'], 'group_code' => $product_temp_parse['group_code']);
$id_product = ProductModel::add($arr);
if (!$id_product) {
throw new Exception('Nastala chyba. Nexistuje id_product');
}
$arr_lang = array('id_product' => $id_product, 'id_lang' => 1, 'name' => $product_temp_parse['groupnameSK'], 'link_rewrite' => NStrings::webalize($product_temp_parse['groupnameSK']));
ProductModel::addProductLang($arr_lang);
$this->all_product_db[$product_temp_parse['group_code']] = $id_product;
$this->all_product_param_db[$values['Code']] = $id_product;
} else {
$id_product = $this->all_product_db[$product_temp_parse['group_code']];
$this->all_product_param_db[$values['Code']] = $id_product;
}
//pridanie parametru produktu
$arr = array('id_product' => $id_product, 'code' => trim($values['Code']), 'capacity' => $values['Package'], 'color' => trim($product_temp_parse['color']), 'size' => trim($product_temp_parse['dimension'] != '' ? $product_temp_parse['dimension'] : $product_temp_parse['size']), 'material' => trim($product_temp_parse['material']), 'price' => $values['Price_EUR'], 'stock' => $values['Stock'], 'image' => $values['Image']);
ProductModel::addProductParamValue($arr);
$is_added = true;
}
$id_product = $this->all_product_param_db[$values['Code']];
/*
* Uprava produktu
*/
if (!$is_added and $values['Name_sk'] != '') {
//upravi len co je v xml - nie co je parsovane z CSV
$arr = array('price' => $values['Price_EUR'], 'stock' => $values['Stock']);
$id_product_param = $this->all_product_param_db[$values['Code']];
ProductModel::setProductParamValue($arr, $id_product_param, 1);
}
$id_categories = array();
//echo $values['Category1_sk'];
if ($id_category = array_search($values['Category1_sk'], $this->category_1)) {
$id_categories[] = $id_category;
}
if ($id_category = array_search($values['Category2_sk'], $this->category_2)) {
$id_categories[] = $id_category;
}
if ($id_category = array_search($values['Category3_sk'], $this->category_3)) {
$id_categories[] = $id_category;
}
ProductModel::removeAllCategory($id_product);
// print_r($id_categories);
ProductModel::addProductToCategory($id_categories, $id_product);
$pom = 0;
//ak nie je kategoria pridaj
if (!in_array($values['Category1_sk'], $this->category_1) and $values['Category1_sk'] != '') {
$id_category = CategoryModel::add(array('id_parent' => NULL, 'active' => 1));
$arr = array('id_category' => $id_category, 'id_lang' => 1, 'name' => $values['Category1_sk']);
CategoryModel::addCategoryLang($arr);
$this->category_1[] = $values['Category1_sk'];
++$pom;
}
if (!in_array($values['Category2_sk'], $this->category_2) and $values['Category2_sk'] != '') {
$cat1 = dibi::fetchSingle("SELECT category.id_category FROM [category] JOIN [category_lang] USING(id_category) WHERE name = %s", $values['Category1_sk'], " AND id_lang = 1 AND id_parent IS NULL");
if (!$cat1) {
throw new Exception('Rodic pre kategoriu neexistuje : ' . $values['Category1_sk']);
}
$id_category = CategoryModel::add(array('id_parent' => $cat1, 'active' => 1));
$arr = array('id_category' => $id_category, 'id_lang' => 1, 'name' => $values['Category2_sk']);
// print_r(array('id_parent'=>$cat1,'active'=>1,'name'=>$values['Category2_sk'] ));
CategoryModel::addCategoryLang($arr);
$this->category_2[] = $values['Category2_sk'];
++$pom;
}
//
if (!in_array($values['Category3_sk'], $this->category_3) and $values['Category3_sk'] != '') {
$cat2 = dibi::fetchSingle("SELECT category.id_category FROM [category] JOIN [category_lang] USING(id_category) WHERE name = %s", $values['Category2_sk'], " AND id_lang = 1 AND id_parent IS NOT NULL");
if (!$cat2) {
throw new Exception('Rodic pre kategoriu neexistuje : ' . $values['Category2_sk']);
}
if ($values['Category3_sk'] == 'Pullovers') {
var_dump($cat2);
}
$id_category = CategoryModel::add(array('id_parent' => $cat2, 'active' => 1));
if ($values['Category3_sk'] == 'Pullovers') {
var_dump($id_category);
}
$arr = array('id_category' => $id_category, 'id_lang' => 1, 'name' => $values['Category3_sk']);
if ($values['Category3_sk'] == 'Pullovers') {
var_dump($arr);
}
CategoryModel::addCategoryLang($arr);
$this->category_3[] = $values['Category3_sk'];
++$pom;
}
if ($pom > 0) {
// echo "cat1: ". $values['Category1_sk']." - cat2: ". $values['Category2_sk']." - cat3:". $values['Category3_sk']."
// ";
}
}
public function zeng() {
$category=new CategoryModel();
$category->add(array(
'name' => '华硕',
'content' => 'good',
'cid' => 2
));
}
function categoryAction(NForm $form)
{
$values = $form->getValues();
$langs = Setting::getLangs();
switch ($this->mode) {
case 'edit':
$id_category = $values['id_category'];
foreach ($langs as $l) {
$lang_val = array();
foreach ($values as $k => $v) {
if (strpos($k, self::$_separator . $l['iso'])) {
list($name) = explode(self::$_separator . $l['iso'], $k);
$lang_val[$name] = $v;
//pridanie linky rewrite
if ($name == 'link_rewrite' and $v == '') {
$lang_val[$name] = NStrings::webalize($values['name' . self::$_separator . $l['iso']]);
} elseif ($name == 'link_rewrite') {
$lang_val[$name] = NStrings::webalize($lang_val[$name]);
}
// unset($values[$k]);
}
}
$lang_val += array('id_parent' => $values['id_parent'], 'active' => $values['active'], 'show_on_bottom' => $values['show_on_bottom']);
$c = new CategoryModel($l['id_lang']);
$c->save($lang_val, $id_category);
}
$c = new CategoryModel(1);
$c->repairSequence();
// print_r($values);
CategoryModel::repairCategoryRewriteLink();
CategoryModel::invalidateCache();
$this->getPresenter()->flashMessage(_('Kategória bola upravená.'));
$this->getPresenter()->redirect("this");
break;
case 'add':
$id_category = CategoryModel::add(array('id_parent' => $values['id_parent'], 'active' => $values['active']));
unset($values['id_parent'], $values['active']);
foreach ($langs as $l) {
$lang_val = array();
foreach ($values as $k => $v) {
if (strpos($k, self::$_separator . $l['iso'])) {
list($name) = explode(self::$_separator . $l['iso'], $k);
$lang_val[$name] = $v;
//pridanie linky rewrite
if ($name == 'link_rewrite' and $v == '') {
$lang_val[$name] = NStrings::webalize($values['name' . self::$_separator . $l['iso']]);
}
}
}
$lang_val += array('id_category' => $id_category, 'id_lang' => $l['id_lang']);
CategoryModel::addCategoryLang($lang_val);
}
$c = new CategoryModel(1);
$c->repairSequence();
// prepisanie file_node na novy id_category
dibi::query("UPDATE [file_node] SET id_module = %i", $id_category, "WHERE id_module = 999999 AND type_module = 'category'");
CategoryModel::repairCategoryRewriteLink();
CategoryModel::invalidateCache();
// print_r($values);
$this->getPresenter()->flashMessage(_('Kategória bola pridaná.'));
$this->getPresenter()->redirect("Eshop:default");
break;
}
}
static function add($data)
{
if (!$data) {
return false;
}
$model = new CategoryModel();
$result = $model->add($data);
return $result;
}
<?php
define('ACC', true);
require '../system/init.php';
/***
Controller:
file category.php
作用：接受添加category表单。
调用category model，入库
***/
//print_r($_POST);
//第一步：后台检查数据
if (empty($_POST['cat_name'])) {
exit('category name has to be set');
}
//第二步：接受数据
$data['cat_name'] = $_POST['cat_name'];
$data['dscrpt'] = $_POST['cat_desc'];
$data['parent_id'] = $_POST['parent_id'];
//print_r($data);
//第三步：实例化model，调用方法
$cat = new CategoryModel();
if ($cat->add($data)) {
echo "category added successfully";
} else {
echo "category added unsuccessfully";
}
