$_GET['ctid'] = $ctid;
}
}
//START TEMPLATE
$cat_id = tep_db_prepare_input($_GET['id']);
if ($cat_id == 'new') {
$cat_id = '0';
$cat = null;
$parent_name = '';
$cat_prefix = '';
$ctid = tep_db_prepare_input($_GET['ctid']);
$ct = new CategoryTop($ctid);
$mod_title = 'Create New Category - ' . $ct->name;
} else {
$cat = new Category($cat_id);
$ct = $cat->getCategoryTop();
$ctid = $ct->id;
$parent = $cat->getParent();
if ($parent === false) {
$parent_name = '';
} else {
$parent_name = $parent->getName($default_lid);
}
$cat_prefix = $cat->getProductCodePrefix();
$mod_title = 'Manage Category Detail - ' . $ct->name;
}
/* SUB CATEGORIES IS NO LONGER SUPPORTED
$categories_query = "SELECT c.categories_id, c.parent_id, cd.categories_name, IF(c.parent_id=0, c.categories_id, c.parent_id) AS parent_grouping FROM categories c";
$categories_query .= " LEFT JOIN categories_description cd ON cd.categories_id=c.categories_id AND cd.language_id=$default_lid";
$categories_query .= " ORDER BY parent_grouping, c.parent_id";
$categories_result = tep_db_query($categories_query);
/**
* Create a new product in database
* @param Int $category_id
* @param Float $products_price
* @param Float $products_weight
* @param String $pname
* @param String $pdesc
* @param Int $brand_id
* @parmm Boolean $is_wholesale
* @return Int New Product ID
*/
public static function createNewProduct($category_id, $products_price, $products_weight, $pname, $pdesc, $brand_id, $is_wholesale = false)
{
$cat = new Category($category_id);
$prefix = $cat->getProductCodePrefix();
$conflict = true;
while ($conflict) {
//CONSTRUCT PRODUCT CODE
$randno = rand(1, 9) . rand(1, 9);
$products_model = $prefix . date('m' . $randno . 'dy');
$check_duplication = tep_db_query("SELECT products_id," . " products_model FROM products WHERE products_model =" . " '{$products_model}'");
$conflict = tep_db_num_rows($check_duplication) >= 1;
}
$pda = array();
$pda['categories_top_id'] = $cat->getCategoryTop()->id;
$pda['products_model'] = $products_model;
$pda['products_price'] = $products_price;
$pda['products_weight'] = $products_weight;
$pda['products_brand_id'] = $brand_id;
$pda['is_wholesale'] = $is_wholesale ? '1' : '0';
$pda['products_date_added'] = date('Y-m-d H:i:s');
tep_db_perform('products', $pda);
$product_id = tep_db_insert_id();
$ptc = array('products_id' => $product_id, 'categories_id' => $cat->id);
tep_db_perform('products_to_categories', $ptc);
$pdda = array();
$pdda['products_id'] = $product_id;
$pdda['language_id'] = '2';
$pdda['products_name'] = $pname;
$pdda['products_description'] = $pdesc;
tep_db_perform('products_description', $pdda);
return $product_id;
}
$product_errors[] = 'Product Brand is not yet set';
}
//NAME CHECK
if ($pdata['pd'][$lid]['products_name'] == '') {
$product_errors[] = 'Product Name is empty';
}
//KEYWORDS CHECK
if ($pdata['pd'][$lid]['products_head_keywords_tag'] == '') {
$product_errors[] = 'Product Keywords is empty';
}
//CATEGORY CHECK
if ($category_name == '' || $category_name == 'No Category Name') {
$product_errors[] = 'Product Category is not yet set';
}
//SUBCATEGORY CHECK
$subcat_group = $category->getCategoryTop()->getSubCategoryGroup();
$attributes = $class_s->getProductStyles($pid);
$subcategory = $attributes[$subcat_group];
$subcattotal = count($subcategory);
if ($subcattotal == 0) {
$product_errors[] = 'Product has no Subcategory';
} elseif ($subcattotal > 1) {
$product_errors[] = 'Product can only have 1 Subcategory';
}
//COLORS CHECK
$pdata['colors'] = $class_pm->loadColorPatternNames($pid, $lid);
$pdata['colors_total'] = count($pdata['colors']);
$include_neon = isset($pdata['colors']['22']);
//ID 22 = neon
$color_reject1 = !$include_neon && $pdata['colors_total'] > 1;
$color_reject2 = $include_neon && $pdata['colors_total'] > 2;
