function category_new_action() { $cmd = Url::get('cmd', 'add'); $parent_id = Url::get('parent_id', 0); $id = Url::get('id'); $cate_id = $id; $zone_id = trim(Url::get('zone_id', 0)); if ($parent_id > 0) { $cate = DB::fetch("select * from products_category where id={$parent_id}"); $zone_id = $cate['zone_id']; } if (Url::get('name', '') == '') { echo 0; exit; } if ($parent_id == 0) { $level = 1; } else { $sql = "select * from products_category where id='{$parent_id}'"; $re = DB::fetch($sql); if ($re) { $level = $re['level'] + 1; } } $insert_arr = array('name' => trim(Url::get('name', '')), 'zone_id' => $zone_id, 'parent_id' => $parent_id, 'extra_fields_group' => Url::get('extra_fields_group', 0), 'published' => Url::get('published', 0), 'orders' => Url::get('orders', 0), 'level' => $level, 'description' => Url::get('description', '')); if ($cmd == 'add') { if ($insert_arr['orders'] == 0) { $orders = DB::fetch("select MAX(orders) as max from products_category where parent_id={$insert_arr['parent_id']} "); $insert_arr['orders'] = $orders['max'] + 1; } $id = DB::insert('products_category', $insert_arr); } elseif ($cmd == 'edit') { $re = DB::query("select zone_id from products_category where id={$id}"); $row = mysql_fetch_array($re); $old_zone_id = $row['zone_id']; $child_ids = get_child_category($id); if ($id == $parent_id) { echo 0; exit; } if ($child_ids != '') { $child_ids_arr = explode(',', $child_ids); if (in_array($insert_arr['parent_id'], $child_ids_arr)) { echo 0; exit; } $id = DB::update('products_category', $insert_arr, "id={$id}"); if ($old_zone_id != $insert_arr['zone_id']) { if ($child_ids != '') { DB::update('products_category', array('zone_id' => $insert_arr['zone_id']), "id in ({$child_ids} 0)"); DB::update('products_filter', array('zone_id' => $insert_arr['zone_id']), "cat_product_id in ({$child_ids} 0,{$cate_id} )"); } } } else { $id = DB::update('products_category', $insert_arr, "id={$id}"); DB::update('products_filter', array('zone_id' => $insert_arr['zone_id']), "cat_product_id ={$cate_id}"); } } else { echo 0; exit; } if ($id) { echo $id; if (!class_exists('eCate')) { require_once ROOT_PATH . 'core/eCate.php'; } eCateElectronic::delCacheRelated($cate_id); if (MEMCACHE_ON) { eb_memcache::do_remove('categories_new'); } } else { echo 0; } }
function on_submit() { $insert_arr = array('filter_name' => trim(Url::get('filter_name', '')), 'zone_id' => Url::get('zone_id', 0), 'cat_product_id' => Url::get('cat_product_id', 0), 'filter_type' => Url::get('filter_type', 0), 'status' => Url::get('status', 0), 'description' => Url::get('description', ''), 'lbl_price_search' => Url::get('lbl_price_search', ''), 'interval_price_search' => Url::get('interval_price_search', 0), 'orders' => Url::get('orders', 0), 'link_fix' => Url::get('link_fix', ''), 'type' => Url::get('type', 0)); //System::debug($insert_arr); $file_name = strtolower($_FILES['image']['name']); $upload_path = 'category/'; $max_upload_file_size = 2 * 1024 * 1024; $file_ext = EClassApi::getExtension(strtolower($file_name)); if ($file_name && in_array($file_ext, array('.jpg', '.jpeg', '.gif', '.png')) && filesize($_FILES['image']['tmp_name']) < $max_upload_file_size) { $new_path = $upload_path . date("YmdHis", TIME_NOW) . '_' . substr(EClassApi::make_safe_name(basename($file_name, $file_ext)), 0, 36) . $file_ext; $insert_arr['image'] = $new_path; @EClassApi::ftp_image_put_file($new_path, $_FILES['image']['tmp_name'], IMAGE_SERVER_NO); } else { $insert_arr['image'] = Url::get('filter_image_old'); } $filter_value = array(); $value = Url::get('value'); $title = Url::get('title', array()); $description = Url::get('des_filter'); $image = ''; $status = Url::get('status_filter'); $order = Url::get('order'); $bold = Url::get('bold_filter'); $image_old = Url::get('image_old', array()); foreach ($title as $key => $val) { if ($val != '') { $filter_value[$key]['title'] = $val; $filter_value[$key]['value'] = $value[$key]; $filter_value[$key]['description'] = $description[$key]; $filter_value[$key]['status'] = $status[$key]; $filter_value[$key]['bold'] = $bold[$key]; $filter_value[$key]['order'] = $order[$key]; $file_name = strtolower($_FILES['image']['name']); $upload_path = 'category/'; $max_upload_file_size = 2 * 1024 * 1024; $file_ext = EClassApi::getExtension(strtolower($file_name)); if ($file_name && in_array($file_ext, array('.jpg', '.jpeg', '.gif', '.png')) && filesize($_FILES['images_filter']['tmp_name'][$key]) < $max_upload_file_size) { $new_path = $upload_path . date("YmdHis", TIME_NOW) . '_' . substr(EClassApi::make_safe_name(basename($file_name, $file_ext)), 0, 36) . $file_ext; $filter_value[$key]['image'] = $new_path; @EClassApi::ftp_image_put_file($new_path, $_FILES['images_filter']['tmp_name'][$key], IMAGE_SERVER_NO); } else { $filter_value[$key]['image'] = $image_old[$key]; } } } $insert_arr['filter_value'] = json_encode($filter_value); if ($insert_arr['filter_name'] == '') { Url::redirect_current(); } $id = Url::get('id'); DB::update('products_filter', $insert_arr, "id=" . $id); if (MEMCACHE_ON) { eCateElectronic::delCacheRelated($insert_arr['cat_product_id']); } // Url::redirect_current(); }