$GLOBALS['_LANG']['is_best'], 'is_new' => $GLOBALS['_LANG']['is_new'], 'is_hot' => $GLOBALS['_LANG']['is_hot'], 'is_promote' => $GLOBALS['_LANG']['is_promote'], 'all_type' => $GLOBALS['_LANG']['all_type'], ); } /** * 取得重量单位列表 * @return array 重量单位列表 */ function get_unit_list() { return array( '1' => $GLOBALS['_LANG']['unit_kg'], '0.001' => $GLOBALS['_LANG']['unit_g'], ); } /** * 取得会员等级列表 * @return array 会员等级列表 */ function get_user_rank_list() { $sql = "SELECT * FROM " . $GLOBALS['ecs']->table('user_rank') . " ORDER BY min_points"; return $GLOBALS['db']->getAll($sql); } /** * 取得某商品的会员价格列表 * @param int $goods_id 商品编号 * @return array 会员价格列表 user_rank => user_price */ function get_member_price_list($goods_id) { /* 取得会员价格 */ $price_list = array(); $sql = "SELECT user_rank, user_price FROM " . $GLOBALS['ecs']->table('member_price') . " WHERE goods_id = '$goods_id'"; $res = $GLOBALS['db']->query($sql); while ($row = $GLOBALS['db']->fetchRow($res)) { $price_list[$row['user_rank']] = $row['user_price']; } return $price_list; } /** * 插入或更新商品属性 * * @param int $goods_id 商品编号 * @param array $id_list 属性编号数组 * @param array $is_spec_list 是否规格数组 'true' | 'false' * @param array $value_price_list 属性值数组 * @return array 返回受到影响的goods_attr_id数组 */ function handle_goods_attr($goods_id, $id_list, $is_spec_list, $value_price_list) { $goods_attr_id = array(); /* 循环处理每个属性 */ foreach ($id_list AS $key => $id) { $is_spec = $is_spec_list[$key]; if ($is_spec == 'false') { $value = $value_price_list[$key]; $price = ''; } else { $value_list = array(); $price_list = array(); if ($value_price_list[$key]) { $vp_list = explode(chr(13), $value_price_list[$key]); foreach ($vp_list AS $v_p) { $arr = explode(chr(9), $v_p); $value_list[] = $arr[0]; $price_list[] = $arr[1]; } } $value = join(chr(13), $value_list); $price = join(chr(13), $price_list); } // 插入或更新记录 $sql = "SELECT goods_attr_id FROM " . $GLOBALS['ecs']->table('goods_attr') . " WHERE goods_id = '$goods_id' AND attr_id = '$id' AND attr_value = '$value' LIMIT 0, 1"; $result_id = $GLOBALS['db']->getOne($sql); if (!empty($result_id)) { $sql = "UPDATE " . $GLOBALS['ecs']->table('goods_attr') . " SET attr_value = '$value' WHERE goods_id = '$goods_id' AND attr_id = '$id' AND goods_attr_id = '$result_id'"; $goods_attr_id[$id] = $result_id; } else { $sql = "INSERT INTO " . $GLOBALS['ecs']->table('goods_attr') . " (goods_id, attr_id, attr_value, attr_price) " . "VALUES ('$goods_id', '$id', '$value', '$price')"; } $GLOBALS['db']->query($sql); if ($goods_attr_id[$id] == '') { $goods_attr_id[$id] = $GLOBALS['db']->insert_id(); } } return $goods_attr_id; } /** * 保存某商品的会员价格 * @param int $goods_id 商品编号 * @param array $rank_list 等级列表 * @param array $price_list 价格列表 * @return void */ function handle_member_price($goods_id, $rank_list, $price_list) { /* 循环处理每个会员等级 */ foreach ($rank_list AS $key => $rank) { /* 会员等级对应的价格 */ $price = $price_list[$key]; // 插入或更新记录 $sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('member_price') . " WHERE goods_id = '$goods_id' AND user_rank = '$rank'"; if ($GLOBALS['db']->getOne($sql) > 0) { /* 如果会员价格是小于0则删除原来价格，不是则更新为新的价格 */ if ($price < 0) { $sql = "DELETE FROM " . $GLOBALS['ecs']->table('member_price') . " WHERE goods_id = '$goods_id' AND user_rank = '$rank' LIMIT 1"; } else { $sql = "UPDATE " . $GLOBALS['ecs']->table('member_price') . " SET user_price = '$price' " . "WHERE goods_id = '$goods_id' " . "AND user_rank = '$rank' LIMIT 1"; } } else { if ($price == -1) { $sql = ''; } else { $sql = "INSERT INTO " . $GLOBALS['ecs']->table('member_price') . " (goods_id, user_rank, user_price) " . "VALUES ('$goods_id', '$rank', '$price')"; } } if ($sql) { $GLOBALS['db']->query($sql); } } } /** * 保存某商品的扩展分类 * @param int $goods_id 商品编号 * @param array $cat_list 分类编号数组 * @return void */ function handle_other_cat($goods_id, $cat_list) { /* 查询现有的扩展分类 */ $sql = "SELECT cat_id FROM " . $GLOBALS['ecs']->table('goods_cat') . " WHERE goods_id = '$goods_id'"; $exist_list = $GLOBALS['db']->getCol($sql); /* 删除不再有的分类 */ $delete_list = array_diff($exist_list, $cat_list); if ($delete_list) { $sql = "DELETE FROM " . $GLOBALS['ecs']->table('goods_cat') . " WHERE goods_id = '$goods_id' " . "AND cat_id " . db_create_in($delete_list); $GLOBALS['db']->query($sql); } /* 添加新加的分类 */ $add_list = array_diff($cat_list, $exist_list, array(0)); foreach ($add_list AS $cat_id) { // 插入记录 $sql = "INSERT INTO " . $GLOBALS['ecs']->table('goods_cat') . " (goods_id, cat_id) " . "VALUES ('$goods_id', '$cat_id')"; $GLOBALS['db']->query($sql); } } /** * 保存某商品的关联商品 * @param int $goods_id * @return void */ function handle_link_goods($goods_id) { $sql = "UPDATE " . $GLOBALS['ecs']->table('link_goods') . " SET " . " goods_id = '$goods_id' " . " WHERE goods_id = '0'" . " AND admin_id = '$_SESSION[admin_id]'"; $GLOBALS['db']->query($sql); $sql = "UPDATE " . $GLOBALS['ecs']->table('link_goods') . " SET " . " link_goods_id = '$goods_id' " . " WHERE link_goods_id = '0'" . " AND admin_id = '$_SESSION[admin_id]'"; $GLOBALS['db']->query($sql); } /** * 保存某商品的配件 * @param int $goods_id * @return void */ function handle_group_goods($goods_id) { $sql = "UPDATE " . $GLOBALS['ecs']->table('group_goods') . " SET " . " parent_id = '$goods_id' " . " WHERE parent_id = '0'" . " AND admin_id = '$_SESSION[admin_id]'"; $GLOBALS['db']->query($sql); } /** * 保存某商品的关联文章 * @param int $goods_id * @return void */ function handle_goods_article($goods_id) { $sql = "UPDATE " . $GLOBALS['ecs']->table('goods_article') . " SET " . " goods_id = '$goods_id' " . " WHERE goods_id = '0'" . " AND admin_id = '$_SESSION[admin_id]'"; $GLOBALS['db']->query($sql); } /** * 保存某商品的关联地区 create by qin * @param int $goods_id * @return void */ function handle_goods_area($goods_id) { $sql = "UPDATE " . $GLOBALS['ecs']->table('link_area_goods') . " SET " . " goods_id = '$goods_id' " . " WHERE goods_id = '0'" . " AND ru_id = (SELECT ru_id FROM " . $GLOBALS['ecs']->table('admin_user') . " WHERE user_id = '$_SESSION[admin_id]') "; $GLOBALS['db']->query($sql); } /** * 保存某商品的相册图片 * @param int $goods_id * @param array $image_files * @param array $image_descs * @return void */ function handle_gallery_image($goods_id, $image_files, $image_descs, $image_urls, $single_id = 0, $files_type = 0) { if($files_type == 0){ $files_type = 'single_id'; }elseif($files_type = 1){ $files_type = 'dis_id'; } /* 是否处理缩略图 */ $proc_thumb = (isset($GLOBALS['shop_id']) && $GLOBALS['shop_id'] > 0)? false : true; foreach ($image_descs AS $key => $img_desc) { /* 是否成功上传 */ $flag = false; if (isset($image_files['error'])) { if ($image_files['error'][$key] == 0) { $flag = true; } } else { if ($image_files['tmp_name'][$key] != 'none') { $flag = true; } } if ($flag) { // 生成缩略图 if ($proc_thumb) { $thumb_url = $GLOBALS['image']->make_thumb($image_files['tmp_name'][$key], $GLOBALS['_CFG']['thumb_width'], $GLOBALS['_CFG']['thumb_height']); $thumb_url = is_string($thumb_url) ? $thumb_url : ''; } $upload = array( 'name' => $image_files['name'][$key], 'type' => $image_files['type'][$key], 'tmp_name' => $image_files['tmp_name'][$key], 'size' => $image_files['size'][$key], ); if (isset($image_files['error'])) { $upload['error'] = $image_files['error'][$key]; } $img_original = $GLOBALS['image']->upload_image($upload); if ($img_original === false) { sys_msg($GLOBALS['image']->error_msg(), 1, array(), false); } $img_url = $img_original; if (!$proc_thumb) { $thumb_url = $img_original; } // 如果服务器支持GD 则添加水印 if ($proc_thumb && gd_version() > 0) { $pos = strpos(basename($img_original), '.'); $newname = dirname($img_original) . '/' . $GLOBALS['image']->random_filename() . substr(basename($img_original), $pos); if($goods_id == 0) { copy('./' . $img_original, './' . $newname); } else { copy('../' . $img_original, '../' . $newname); } $img_url = $newname; $GLOBALS['image']->add_watermark('../'.$img_url,'',$GLOBALS['_CFG']['watermark'], $GLOBALS['_CFG']['watermark_place'], $GLOBALS['_CFG']['watermark_alpha']); } /* 重新格式化图片名称 */ if($goods_id == 0) { $img_original = reformat_image_name('gallery', $single_id, $img_original, 'source'); $img_url = reformat_image_name('gallery', $single_id, $img_url, 'goods'); $thumb_url = reformat_image_name('gallery_thumb', $single_id, $thumb_url, 'thumb'); } else { $img_original = reformat_image_name('gallery', $goods_id, $img_original, 'source'); $img_url = reformat_image_name('gallery', $goods_id, $img_url, 'goods'); $thumb_url = reformat_image_name('gallery_thumb', $goods_id, $thumb_url, 'thumb'); } $sql = "INSERT INTO " . $GLOBALS['ecs']->table('goods_gallery') . " (goods_id, img_url, img_desc, thumb_url, img_original, " .$files_type. ") " . "VALUES ('$goods_id', '$img_url', '$img_desc', '$thumb_url', '$img_original', '$single_id')"; $GLOBALS['db']->query($sql); /* 不保留商品原图的时候删除原图 */ if ($proc_thumb && !$GLOBALS['_CFG']['retain_original_img'] && !empty($img_original)) { $GLOBALS['db']->query("UPDATE " . $GLOBALS['ecs']->table('goods_gallery') . " SET img_original='' WHERE `goods_id`='{$goods_id}'"); @unlink('../' . $img_original); } } elseif (!empty($image_urls[$key]) && ($image_urls[$key] != $GLOBALS['_LANG']['img_file']) && ($image_urls[$key] != 'http://') && copy(trim($image_urls[$key]), ROOT_PATH . 'temp/' . basename($image_urls[$key]))) { $image_url = trim($image_urls[$key]); //定义原图路径 $down_img = ROOT_PATH . 'temp/' . basename($image_url); // 生成缩略图 if ($proc_thumb) { $thumb_url = $GLOBALS['image']->make_thumb($down_img, $GLOBALS['_CFG']['thumb_width'], $GLOBALS['_CFG']['thumb_height']); $thumb_url = is_string($thumb_url) ? $thumb_url : ''; $thumb_url = reformat_image_name('gallery_thumb', $goods_id, $thumb_url, 'thumb'); } if (!$proc_thumb) { $thumb_url = htmlspecialchars($image_url); } /* 重新格式化图片名称 */ $img_url = $img_original = htmlspecialchars($image_url); $sql = "INSERT INTO " . $GLOBALS['ecs']->table('goods_gallery') . " (goods_id, img_url, img_desc, thumb_url, img_original, " .$files_type. ") " . "VALUES ('$goods_id', '$img_url', '$img_desc', '$thumb_url', '$img_original', '$single_id')"; $GLOBALS['db']->query($sql); @unlink($down_img); } //OSS文件存储ecmoban模板堂 --zhuo start if($GLOBALS['_CFG']['open_oss'] == 1){ $bucket_info = get_bucket_info(); $url = $GLOBALS['ecs']->url() . "api/mvc/index.php/Home/Index/upload"; $Http = new Http(); $post_data = array( 'bucket' => $bucket_info['bucket'], 'keyid' => $bucket_info['keyid'], 'keysecret' => $bucket_info['keysecret'], 'is_cname' => $bucket_info['is_cname'], 'endpoint' => $bucket_info['outside_site'], 'object' => array( $img_url, $thumb_url, $img_original ) ); $Http->doPost($url, $post_data); } //OSS文件存储ecmoban模板堂 --zhuo end } } /** * 修改商品某字段值 * @param string $goods_id 商品编号，可以为多个，用 ',' 隔开 * @param string $field 字段名 * @param string $value 字段值 * @return bool */ function update_goods($goods_id, $field, $value, $content = '', $type = '') //ecmoban模板堂 --zhuo $content = '' { if ($goods_id) { /* 清除缓存 */ clear_cache_files(); $date = array('model_attr'); $where = "goods_id = '$goods_id'"; $model_attr = get_table_date('goods', $where, $date, 2); //ecmoban模板堂 --zhuo start $table = "goods"; if($type == 'updateNum'){ if($model_attr == 1){ $table = "warehouse_goods"; $field = 'region_number'; }elseif($model_attr == 2){ $table = "warehouse_area_goods"; $field = 'region_number'; } } if($value == 2 && !empty($content)){ $content = "review_content = '$content', "; } //ecmoban模板堂 --zhuo end $sql = "UPDATE " . $GLOBALS['ecs']->table($table) . " SET $field = '$value' , " .$content. " last_update = '". gmtime() ."' " . "WHERE goods_id " . db_create_in($goods_id); return $GLOBALS['db']->query($sql); } else { return false; } } /** * 从回收站删除多个商品 * @param mix $goods_id 商品id列表：可以逗号格开，也可以是数组 * @return void */ function delete_goods($goods_id) { if (empty($goods_id)) { return; } /* 取得有效商品id */ $sql = "SELECT DISTINCT goods_id FROM " . $GLOBALS['ecs']->table('goods') . " WHERE goods_id " . db_create_in($goods_id) . " AND is_delete = 1"; $goods_id = $GLOBALS['db']->getCol($sql); if (empty($goods_id)) { return; } //OSS文件存储ecmoban模板堂 --zhuo start if($GLOBALS['_CFG']['open_oss'] == 1){ $bucket_info = get_bucket_info(); $url = $GLOBALS['ecs']->url() . "api/mvc/index.php/Home/Index/delFile"; $Http = new Http(); } //OSS文件存储ecmoban模板堂 --zhuo end /* 删除商品图片和轮播图片文件 */ $sql = "SELECT goods_thumb, goods_img, original_img " . "FROM " . $GLOBALS['ecs']->table('goods') . " WHERE goods_id " . db_create_in($goods_id); $res = $GLOBALS['db']->query($sql); while ($goods = $GLOBALS['db']->fetchRow($res)) { if (!empty($goods['goods_thumb'])) { @unlink('../' . $goods['goods_thumb']); } if (!empty($goods['goods_img'])) { @unlink('../' . $goods['goods_img']); } if (!empty($goods['original_img'])) { @unlink('../' . $goods['original_img']); } //OSS文件存储ecmoban模板堂 --zhuo start if($GLOBALS['_CFG']['open_oss'] == 1){ $post_data = array( 'bucket' => $bucket_info['bucket'], 'keyid' => $bucket_info['keyid'], 'keysecret' => $bucket_info['keysecret'], 'is_cname' => $bucket_info['is_cname'], 'endpoint' => $bucket_info['outside_site'], 'object' => array( $goods['goods_thumb'], $goods['goods_img'], $goods['original_img'] ) ); $Http->doPost($url, $post_data); } //OSS文件存储ecmoban模板堂 --zhuo end } /* 删除商品 */ $sql = "DELETE FROM " . $GLOBALS['ecs']->table('goods') . " WHERE goods_id " . db_create_in($goods_id); $GLOBALS['db']->query($sql); /* 删除商品的货品记录 */ $sql = "DELETE FROM " . $GLOBALS['ecs']->table('products') . " WHERE goods_id " . db_create_in($goods_id); $GLOBALS['db']->query($sql); /* 删除商品相册的图片文件 */ $sql = "SELECT img_url, thumb_url, img_original " . "FROM " . $GLOBALS['ecs']->table('goods_gallery') . " WHERE goods_id " . db_create_in($goods_id); $res = $GLOBALS['db']->query($sql); while ($row = $GLOBALS['db']->fetchRow($res)) { if (!empty($row['img_url'])) { @unlink('../' . $row['img_url']); } if (!empty($row['thumb_url'])) { @unlink('../' . $row['thumb_url']); } if (!empty($row['img_original'])) { @unlink('../' . $row['img_original']); } //OSS文件存储ecmoban模板堂 --zhuo start if($GLOBALS['_CFG']['open_oss'] == 1){ $post_data = array( 'bucket' => $bucket_info['bucket'], 'keyid' => $bucket_info['keyid'], 'keysecret' => $bucket_info['keysecret'], 'is_cname' => $bucket_info['is_cname'], 'endpoint' => $bucket_info['outside_site'], 'object' => array( $row['img_url'], $row['thumb_url'], $row['img_original'] ) ); $Http->doPost($url, $post_data); } //OSS文件存储ecmoban模板堂 --zhuo end } /* 删除商品相册 */ $sql = "DELETE FROM " . $GLOBALS['ecs']->table('goods_gallery') . " WHERE goods_id " . db_create_in($goods_id); $GLOBALS['db']->query($sql); /* 删除相关表记录 */ $sql = "DELETE FROM " . $GLOBALS['ecs']->table('collect_goods') . " WHERE goods_id " . db_create_in($goods_id); $GLOBALS['db']->query($sql); $sql = "DELETE FROM " . $GLOBALS['ecs']->table('goods_article') . " WHERE goods_id " . db_create_in($goods_id); $GLOBALS['db']->query($sql); $sql = "DELETE FROM " . $GLOBALS['ecs']->table('goods_attr') . " WHERE goods_id " . db_create_in($goods_id); $GLOBALS['db']->query($sql); $sql = "DELETE FROM " . $GLOBALS['ecs']->table('goods_cat') . " WHERE goods_id " . db_create_in($goods_id); $GLOBALS['db']->query($sql); $sql = "DELETE FROM " . $GLOBALS['ecs']->table('member_price') . " WHERE goods_id " . db_create_in($goods_id); $GLOBALS['db']->query($sql); $sql = "DELETE FROM " . $GLOBALS['ecs']->table('group_goods') . " WHERE parent_id " . db_create_in($goods_id); $GLOBALS['db']->query($sql); $sql = "DELETE FROM " . $GLOBALS['ecs']->table('group_goods') . " WHERE goods_id " . db_create_in($goods_id); $GLOBALS['db']->query($sql); $sql = "DELETE FROM " . $GLOBALS['ecs']->table('link_goods') . " WHERE goods_id " . db_create_in($goods_id); $GLOBALS['db']->query($sql); $sql = "DELETE FROM " . $GLOBALS['ecs']->table('link_goods') . " WHERE link_goods_id " . db_create_in($goods_id); $GLOBALS['db']->query($sql); $sql = "DELETE FROM " . $GLOBALS['ecs']->table('tag') . " WHERE goods_id " . db_create_in($goods_id); $GLOBALS['db']->query($sql); $sql = "DELETE FROM " . $GLOBALS['ecs']->table('comment') . " WHERE comment_type = 0 AND id_value " . db_create_in($goods_id); $GLOBALS['db']->query($sql); /* 删除相应虚拟商品记录 */ $sql = "DELETE FROM " . $GLOBALS['ecs']->table('virtual_card') . " WHERE goods_id " . db_create_in($goods_id); if (!$GLOBALS['db']->query($sql, 'SILENT') && $GLOBALS['db']->errno() != 1146) { die($GLOBALS['db']->error()); } /* 清除缓存 */ clear_cache_files(); } /** * 为某商品生成唯一的货号 * @param int $goods_id 商品编号 * @return string 唯一的货号 */ function generate_goods_sn($goods_id) { $goods_sn = $GLOBALS['_CFG']['sn_prefix'] . str_repeat('0', 6 - strlen($goods_id)) . $goods_id; $sql = "SELECT goods_sn FROM " . $GLOBALS['ecs']->table('goods') . " WHERE goods_sn LIKE '" . mysql_like_quote($goods_sn) . "%' AND goods_id <> '$goods_id' " . " ORDER BY LENGTH(goods_sn) DESC"; $sn_list = $GLOBALS['db']->getCol($sql); if (in_array($goods_sn, $sn_list)) { $max = pow(10, strlen($sn_list[0]) - strlen($goods_sn) + 1) - 1; $new_sn = $goods_sn . mt_rand(0, $max); while (in_array($new_sn, $sn_list)) { $new_sn = $goods_sn . mt_rand(0, $max); } $goods_sn = $new_sn; } return $goods_sn; } /** * 商品货号是否重复 * * @param string $goods_sn 商品货号；请在传入本参数前对本参数进行SQl脚本过滤 * @param int $goods_id 商品id；默认值为：0，没有商品id * @return bool true，重复；false，不重复 */ function check_goods_sn_exist($goods_sn, $goods_id = 0) { $goods_sn = trim($goods_sn); $goods_id = intval($goods_id); if (strlen($goods_sn) == 0) { return true; //重复 } if (empty($goods_id)) { $sql = "SELECT goods_id FROM " . $GLOBALS['ecs']->table('goods') ." WHERE goods_sn = '$goods_sn'"; } else { $sql = "SELECT goods_id FROM " . $GLOBALS['ecs']->table('goods') ." WHERE goods_sn = '$goods_sn' AND goods_id <> '$goods_id'"; } $res = $GLOBALS['db']->getOne($sql); if (empty($res)) { return false; //不重复 } else { return true; //重复 } } /** * 取得通用属性和某分类的属性，以及某商品的属性值 * @param int $cat_id 分类编号 * @param int $goods_id 商品编号 * @return array 规格与属性列表 */ function get_attr_list($cat_id, $goods_id = 0) { if (empty($cat_id)) { return array(); } // 查询属性值及商品的属性值 $sql = "SELECT a.attr_id, a.attr_name, a.attr_input_type, a.attr_type, a.attr_values, v.attr_value, v.attr_price, v.attr_sort, v.attr_checked ". "FROM " .$GLOBALS['ecs']->table('attribute'). " AS a ". "LEFT JOIN " .$GLOBALS['ecs']->table('goods_attr'). " AS v ". "ON v.attr_id = a.attr_id AND v.goods_id = '$goods_id' ". "WHERE a.cat_id = " . intval($cat_id) ." OR a.cat_id = 0 ". "ORDER BY a.sort_order, a.attr_type, a.attr_id, v.attr_price, v.goods_attr_id"; $row = $GLOBALS['db']->GetAll($sql); return $row; } /** * 获取商品类型中包含规格的类型列表 * * @access public * @return array */ function get_goods_type_specifications() { // 查询 $sql = "SELECT DISTINCT cat_id FROM " .$GLOBALS['ecs']->table('attribute'). " WHERE attr_type = 1"; $row = $GLOBALS['db']->GetAll($sql); $return_arr = array(); if (!empty($row)) { foreach ($row as $value) { $return_arr[$value['cat_id']] = $value['cat_id']; } } return $return_arr; } /** * 根据属性数组创建属性的表单 * * @access public * @param int $cat_id 分类编号 * @param int $goods_id 商品编号 * @return string */ function build_attr_html($cat_id, $goods_id = 0) { $attr = get_attr_list($cat_id, $goods_id); $html = ''; $spec = 0; foreach ($attr AS $key => $val) { $html .= "'; } $html .= '
"; if ($val['attr_type'] == 1 || $val['attr_type'] == 2) { $html .= ($spec != $val['attr_id']) ? "[+]" : "[-]"; $spec = $val['attr_id']; } $html .= "$val[attr_name]"; if ($val['attr_input_type'] == 0) { $html .= ' '; $attr_name = ",'" .$val['attr_value']. "'"; } elseif ($val['attr_input_type'] == 2) { $html .= ''; } else { $html .= ' '; } $html .= ($val['attr_type'] == 1 || $val['attr_type'] == 2) ? '' .$GLOBALS['_LANG']['spec_price'].' ' . '' : ' '; //ecmoban模板堂 --zhuo start if(!empty($val['attr_value'])){ $html .= ' ' .$GLOBALS['_LANG']['warehouse_spec_price']. ''; $html .= ' ' .$GLOBALS['_LANG']['area_spec_price']. ''; } $html .= ' 排序 '; if(!empty($val['attr_value'])){ $html .= ' ' .$GLOBALS['_LANG']['add_attr_img']. ''; } if($val['attr_checked'] == 1){ $html .= "（已选择默认）"; } //ecmoban模板堂 --zhuo end $html .= '
'; return $html; } /** * 获得指定商品相关的商品 * * @access public * @param integer $goods_id * @return array */ function get_linked_goods($goods_id) { $sql = "SELECT lg.link_goods_id AS goods_id, g.goods_name, lg.is_double " . "FROM " . $GLOBALS['ecs']->table('link_goods') . " AS lg, " . $GLOBALS['ecs']->table('goods') . " AS g " . "WHERE lg.goods_id = '$goods_id' " . "AND lg.link_goods_id = g.goods_id "; if ($goods_id == 0) { $sql .= " AND lg.admin_id = '$_SESSION[admin_id]'"; } $row = $GLOBALS['db']->getAll($sql); foreach ($row AS $key => $val) { $linked_type = $val['is_double'] == 0 ? $GLOBALS['_LANG']['single'] : $GLOBALS['_LANG']['double']; $row[$key]['goods_name'] = $val['goods_name'] . " -- [$linked_type]"; unset($row[$key]['is_double']); } return $row; } /** * 获得指定商品的配件 * * @access public * @param integer $goods_id * @return array */ function get_group_goods($goods_id) { $sql = "SELECT gg.goods_id, gg.group_id, CONCAT(g.goods_name, ' -- [', gg.goods_price, ']') AS goods_name " . "FROM " . $GLOBALS['ecs']->table('group_goods') . " AS gg, " . $GLOBALS['ecs']->table('goods') . " AS g " . "WHERE gg.parent_id = '$goods_id' " . "AND gg.goods_id = g.goods_id "; if ($goods_id == 0) { $sql .= " AND gg.admin_id = '$_SESSION[admin_id]'"; } $sql .= " order by gg.group_id asc, g.goods_id asc"; //by mike add $res = $GLOBALS['db']->getAll($sql); $group_goods = get_cfg_group_goods(); $arr = array(); foreach($res as $key=>$row){ $arr[$key] = $row; if($group_goods){ foreach($group_goods as $gkey=>$group){ if($row['group_id'] == $gkey){ $arr[$key]['group_name'] = $group; } } } } return $arr; } /** * 获得商品的关联文章 * * @access public * @param integer $goods_id * @return array */ function get_goods_articles($goods_id) { $sql = "SELECT g.article_id, a.title " . "FROM " .$GLOBALS['ecs']->table('goods_article') . " AS g, " . $GLOBALS['ecs']->table('article') . " AS a " . "WHERE g.goods_id = '$goods_id' " . "AND g.article_id = a.article_id "; if ($goods_id == 0) { $sql .= " AND g.admin_id = '$_SESSION[admin_id]'"; } $row = $GLOBALS['db']->getAll($sql); return $row; } /** * 获得商品列表 * * @access public * @params integer $isdelete * @params integer $real_goods * @params integer $conditions * @return array */ function goods_list($is_delete, $real_goods=1, $conditions = '') { //ecmoban模板堂 --zhuo start $adminru = get_admin_ru_id(); $ruCat = ''; if($adminru['ru_id'] > 0){ $ruCat = " and g.user_id = '" .$adminru['ru_id']. "' "; } //ecmoban模板堂 --zhuo end /* 过滤条件 */ $param_str = '-' . $is_delete . '-' . $real_goods; $result = get_filter($param_str); if ($result === false) { $day = getdate(); $today = local_mktime(23, 59, 59, $day['mon'], $day['mday'], $day['year']); $filter['cat_id'] = empty($_REQUEST['cat_id']) ? 0 : intval($_REQUEST['cat_id']); $filter['intro_type'] = empty($_REQUEST['intro_type']) ? '' : trim($_REQUEST['intro_type']); $filter['is_promote'] = empty($_REQUEST['is_promote']) ? 0 : intval($_REQUEST['is_promote']); $filter['stock_warning'] = empty($_REQUEST['stock_warning']) ? 0 : intval($_REQUEST['stock_warning']); $filter['sel_brand'] = empty($_REQUEST['sel_brand']) ? 0 : intval($_REQUEST['sel_brand']); //品牌归属 --自营或商家 $filter['brand_id'] = empty($_REQUEST['brand_id']) ? 0 : intval($_REQUEST['brand_id']); $sel_mode = empty($_REQUEST['sel_mode']) ? 0 : intval($_REQUEST['sel_mode']); $brand_keyword = empty($_REQUEST['brand_keyword']) ? '' : trim($_REQUEST['brand_keyword']); if ($sel_mode == 1 && !empty($brand_keyword)) { if($adminru['ru_id'] > 0) { /* 商家品牌 */ $filter['brand_id'] = $GLOBALS['db']->getALL("SELECT bid FROM ".$GLOBALS['ecs']->table('merchants_shop_brand')." WHERE brandName LIKE '%$brand_keyword%' "); } else { if($filter['sel_brand'] == 2) { /* 商家品牌 */ $filter['brand_id'] = $GLOBALS['db']->getALL("SELECT bid FROM ".$GLOBALS['ecs']->table('merchants_shop_brand')." WHERE brandName LIKE '%$brand_keyword%' "); } elseif($filter['sel_brand'] == 1) { /* 自营品牌 */ $filter['brand_id'] = $GLOBALS['db']->getAll("SELECT brand_id FROM ".$GLOBALS['ecs']->table('brand')." WHERE brand_name LIKE '%$brand_keyword%' "); } } // print_r($filter['brand_id']); $new_array = array(); foreach ($filter['brand_id'] as $key => $value) { $new_array[] = $value['brand_id']; } } elseif ($sel_mode == 1 && !empty($brand_keyword)) { $filter['brand_id'] = 0; } // $filter['brand_id'] = empty($filter['brand_id']) ? 0 : intval($filter['brand_id']); $filter['store_brand'] = empty($_REQUEST['store_brand']) ? 0 : intval($_REQUEST['store_brand']); //商家品牌 $filter['keyword'] = empty($_REQUEST['keyword']) ? '' : trim($_REQUEST['keyword']); $filter['suppliers_id'] = isset($_REQUEST['suppliers_id']) ? (empty($_REQUEST['suppliers_id']) ? '' : trim($_REQUEST['suppliers_id'])) : ''; $filter['is_on_sale'] = isset($_REQUEST['is_on_sale']) ? ((empty($_REQUEST['is_on_sale']) && $_REQUEST['is_on_sale'] === 0) ? '' : trim($_REQUEST['is_on_sale'])) : ''; if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) { $filter['keyword'] = json_str_iconv($filter['keyword']); } $filter['review_status'] = empty($_REQUEST['review_status']) ? 0 : intval($_REQUEST['review_status']); //ecmoban模板堂 --zhuo $filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'g.goods_id' : trim($_REQUEST['sort_by']); $filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']); $filter['extension_code'] = empty($_REQUEST['extension_code']) ? '' : trim($_REQUEST['extension_code']); $filter['is_delete'] = $is_delete; $filter['real_goods'] = $real_goods; $where = $filter['cat_id'] > 0 ? " AND (" . get_children($filter['cat_id']) . " OR " .get_children($filter['cat_id'], 1). ")" : ''; //管理员查询的权限 -- 店铺查询 start $filter['store_search'] = empty($_REQUEST['store_search']) ? 0 : intval($_REQUEST['store_search']); $filter['merchant_id'] = isset($_REQUEST['merchant_id']) ? intval($_REQUEST['merchant_id']) : 0; $filter['store_keyword'] = isset($_REQUEST['store_keyword']) ? trim($_REQUEST['store_keyword']) : ''; $store_where = ''; $store_search_where = ''; if($filter['store_search'] !=0){ if($adminru['ru_id'] == 0){ if($_REQUEST['store_type']){ $store_search_where = "AND msi.shopNameSuffix = '" .$_REQUEST['store_type']. "'"; } if($filter['store_search'] == 1){ $where .= " AND g.user_id = '" .$filter['merchant_id']. "' "; }elseif($filter['store_search'] == 2){ $store_where .= " AND msi.rz_shopName LIKE '%" . mysql_like_quote($filter['store_keyword']) . "%'"; }elseif($filter['store_search'] == 3){ $store_where .= " AND msi.shoprz_brandName LIKE '%" . mysql_like_quote($filter['store_keyword']) . "%' " . $store_search_where; } if($filter['store_search'] > 1){ $where .= " AND (SELECT msi.user_id FROM " . $GLOBALS['ecs']->table('merchants_shop_information') .' as msi ' . " WHERE msi.user_id = g.user_id $store_where) > 0 "; } } } //管理员查询的权限 -- 店铺查询 end /* 推荐类型 */ switch ($filter['intro_type']) { case 'is_best': $where .= " AND g.is_best=1"; break; case 'is_hot': $where .= ' AND g.is_hot=1'; break; case 'is_new': $where .= ' AND g.is_new=1'; break; case 'is_promote': $where .= " AND g.is_promote = 1 AND g.promote_price > 0 AND g.promote_start_date <= '$today' AND g.promote_end_date >= '$today'"; break; case 'all_type'; $where .= " AND (g.is_best=1 OR g.is_hot=1 OR g.is_new=1 OR (g.is_promote = 1 AND g.promote_price > 0 AND g.promote_start_date <= '" . $today . "' AND g.promote_end_date >= '" . $today . "'))"; } /* 库存警告 */ if ($filter['stock_warning']) { $where .= ' AND g.goods_number <= g.warn_number '; } //ecmoban模板堂 --zhuo start if($adminru['ru_id'] > 0){ /* 商家品牌 */ if ($sel_mode == 1) { if ($filter['brand_id']){ $where .= " AND (g.brand_id".db_create_in($new_array).") AND g.user_id > 0"; }else{ $where .= " AND g.user_id > 0"; } } else { if ($filter['brand_id']){ $where .= " AND (g.brand_id='$filter[brand_id]') AND g.user_id > 0"; }else{ $where .= " AND g.user_id > 0"; } } }else{ if ($sel_mode == 1) { if($filter['sel_brand'] == 2){ /* 商家品牌 */ if ($filter['store_brand']) { $where .= " AND (g.brand_id".db_create_in($new_array).") AND g.user_id > 0"; }else{ $where .= " AND g.user_id > 0"; } }elseif($filter['sel_brand'] == 1){ /* 自营品牌 */ if ($filter['brand_id']) { $where .= " AND (g.brand_id".db_create_in($new_array).") AND g.user_id = 0"; }else{ $where .= " AND g.user_id = 0"; } } } else { if($filter['sel_brand'] == 2){ /* 商家品牌 */ if ($filter['store_brand']) { $where .= " AND (g.brand_id='$filter[store_brand]') AND g.user_id > 0"; }else{ $where .= " AND g.user_id > 0"; } }elseif($filter['sel_brand'] == 1){ /* 自营品牌 */ if ($filter['brand_id']) { $where .= " AND (g.brand_id='$filter[brand_id]') AND g.user_id = 0"; }else{ $where .= " AND g.user_id = 0"; } } } } //ecmoban模板堂 --zhuo end /* 扩展 */ if ($filter['extension_code']) { $where .= " AND g.extension_code='$filter[extension_code]'"; } /* 关键字 */ if (!empty($filter['keyword'])) { $where .= " AND (g.goods_sn LIKE '%" . mysql_like_quote($filter['keyword']) . "%' OR g.goods_name LIKE '%" . mysql_like_quote($filter['keyword']) . "%'" . ")"; //ecmoban模板堂 --zhuo end } if ($real_goods > -1) { $where .= " AND g.is_real='$real_goods'"; } /* 上架 */ if ($filter['is_on_sale'] !== '') { $where .= " AND (g.is_on_sale = '" . $filter['is_on_sale'] . "')"; } /* 供货商 */ if (!empty($filter['suppliers_id'])) { $where .= " AND (g.suppliers_id = '" . $filter['suppliers_id'] . "')"; } /* 审核商品状态 ecmoban模板堂 --zhuo*/ if ($filter['review_status'] > 0) { if($filter['review_status'] == 3){ $where .= " AND (g.review_status >= '" . $filter['review_status'] . "')"; }else{ $where .= " AND (g.review_status = '" . $filter['review_status'] . "')"; } }else{ $where .= " AND (g.review_status > 0)"; } $where .= $ruCat; $where .= $conditions; /* 记录总数 */ $sql = "SELECT g.goods_id, g.goods_name, g.model_price, g.model_inventory, g.user_id, g.goods_type, g.goods_sn, g.shop_price, g.is_on_sale, g.is_best, g.is_new, g.is_hot, g.sort_order, g.goods_number, g.integral, " . " g.is_promote ". " FROM " . $GLOBALS['ecs']->table('goods') . " AS g " . " left join " .$GLOBALS['ecs']->table('goods_cat'). " as gc on g.goods_id = gc.goods_id" . " WHERE g.is_delete='$is_delete' $where" . " group by g.goods_id"; $filter['record_count'] = count($GLOBALS['db']->getAll($sql)); /* 分页大小 */ $filter = page_and_size($filter); $sql = "SELECT g.goods_id, g.goods_name, g.user_id, g.goods_type, g.goods_sn, g.shop_price, g.is_on_sale, g.is_best, g.is_new, g.is_hot, g.sort_order, g.goods_number, g.integral, " . " g.is_promote, g.model_price, g.model_inventory, g.model_attr, g.review_status, g.review_content, g.store_best, g.store_new , g.store_hot , g.is_real ". " FROM " . $GLOBALS['ecs']->table('goods') . " AS g " . " left join " .$GLOBALS['ecs']->table('goods_cat'). " as gc on g.goods_id = gc.goods_id" . " WHERE g.is_delete='$is_delete' $where" . " group by g.goods_id" . " ORDER BY $filter[sort_by] $filter[sort_order] ". " LIMIT " . $filter['start'] . ",$filter[page_size]"; $filter['keyword'] = stripslashes($filter['keyword']); set_filter($filter, $sql, $param_str); } else { $sql = $result['sql']; $filter = $result['filter']; } $row = $GLOBALS['db']->getAll($sql); $count = count($row); for ($i=0; $i<$count; $i++) { $row[$i]['user_name'] = get_shop_name($row[$i]['user_id'], 1); } return array('goods' => $row, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']); } /** * 检测商品是否有货品 * * @access public * @params integer $goods_id 商品id * @params string $conditions sql条件，AND语句开头 * @return string number -1，错误；1，存在；0，不存在 */ function check_goods_product_exist($goods_id, $conditions = '') { if (empty($goods_id)) { return -1; //$goods_id不能为空 } $sql = "SELECT goods_id FROM " . $GLOBALS['ecs']->table('products') . " WHERE goods_id = '$goods_id' " . $conditions . " LIMIT 0, 1"; $result = $GLOBALS['db']->getRow($sql); if (empty($result)) { return 0; } return 1; } /** * 获得商品的货品总库存 * * @access public * @params integer $goods_id 商品id * @params string $conditions sql条件，AND语句开头 * @return string number */ function product_number_count($goods_id, $conditions = '', $warehouse_id = 0) { if (empty($goods_id)) { return -1; //$goods_id不能为空 } $sql = "SELECT product_number FROM " . $GLOBALS['ecs']->table('products') . " WHERE goods_id = '$goods_id' " . $conditions; $nums = $GLOBALS['db']->getOne($sql); $nums = empty($nums) ? 0 : $nums; return $nums; } /** * 获得商品的规格属性值列表 * * @access public * @params integer $goods_id * @return array */ function product_goods_attr_list($goods_id) { if (empty($goods_id)) { return array(); //$goods_id不能为空 } $sql = "SELECT goods_attr_id, attr_value FROM " . $GLOBALS['ecs']->table('goods_attr') . " WHERE goods_id = '$goods_id'"; $results = $GLOBALS['db']->getAll($sql); $return_arr = array(); foreach ($results as $value) { $return_arr[$value['goods_attr_id']] = $value['attr_value']; } return $return_arr; } /** * 获得商品已添加的规格列表 * * @access public * @params integer $goods_id * @return array */ function get_goods_specifications_list($goods_id) { if (empty($goods_id)) { return array(); //$goods_id不能为空 } $sql = "SELECT g.goods_attr_id, g.attr_value, g.attr_id, a.attr_name FROM " . $GLOBALS['ecs']->table('goods_attr') . " AS g LEFT JOIN " . $GLOBALS['ecs']->table('attribute') . " AS a ON a.attr_id = g.attr_id WHERE goods_id = '$goods_id' AND a.attr_type = 1 ORDER BY g.attr_id ASC"; $results = $GLOBALS['db']->getAll($sql); return $results; } /** * 获得商品的货品列表 * * @access public * @params integer $goods_id * @params string $conditions * @return array */ function product_list($goods_id, $conditions = '') { /* 过滤条件 */ $param_str = '-' . $goods_id; $result = get_filter($param_str); if ($result === false) { $day = getdate(); $today = local_mktime(23, 59, 59, $day['mon'], $day['mday'], $day['year']); $filter['goods_id'] = $goods_id; $filter['keyword'] = empty($_REQUEST['keyword']) ? '' : trim($_REQUEST['keyword']); $filter['stock_warning'] = empty($_REQUEST['stock_warning']) ? 0 : intval($_REQUEST['stock_warning']); if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) { $filter['keyword'] = json_str_iconv($filter['keyword']); } $filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'product_id' : trim($_REQUEST['sort_by']); $filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']); $filter['extension_code'] = empty($_REQUEST['extension_code']) ? '' : trim($_REQUEST['extension_code']); $filter['page_count'] = isset($filter['page_count']) ? $filter['page_count'] : 1; $where = ''; /* 库存警告 */ if ($filter['stock_warning']) { $where .= ' AND goods_number <= warn_number '; } /* 关键字 */ if (!empty($filter['keyword'])) { $where .= " AND (product_sn LIKE '%" . $filter['keyword'] . "%')"; } $where .= $conditions; /* 记录总数 */ $sql = "SELECT COUNT(*) FROM " .$GLOBALS['ecs']->table('products'). " AS p WHERE goods_id = $goods_id $where"; $filter['record_count'] = $GLOBALS['db']->getOne($sql); $sql = "SELECT product_id, goods_id, goods_attr, product_sn, product_number FROM " . $GLOBALS['ecs']->table('products') . " AS g WHERE goods_id = $goods_id $where ORDER BY $filter[sort_by] $filter[sort_order]"; $filter['keyword'] = stripslashes($filter['keyword']); //set_filter($filter, $sql, $param_str); } else { $sql = $result['sql']; $filter = $result['filter']; } $row = $GLOBALS['db']->getAll($sql); /* 处理规格属性 */ $goods_attr = product_goods_attr_list($goods_id); foreach ($row as $key => $value) { $_goods_attr_array = explode('|', $value['goods_attr']); if (is_array($_goods_attr_array)) { $_temp = ''; foreach ($_goods_attr_array as $_goods_attr_value) { $_temp[] = $goods_attr[$_goods_attr_value]; } $row[$key]['goods_attr'] = $_temp; } } return array('product' => $row, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']); } /** * 取货品信息 * * @access public * @param int $product_id 货品id * @param int $filed 字段 * @return array */ function get_product_info($product_id, $filed = '') { $return_array = array(); if (empty($product_id)) { return $return_array; } $filed = trim($filed); if (empty($filed)) { $filed = '*'; } $sql = "SELECT $filed FROM " . $GLOBALS['ecs']->table('products') . " WHERE product_id = '$product_id'"; $return_array = $GLOBALS['db']->getRow($sql); return $return_array; } /** * 检查单个商品是否存在规格 * * @param int $goods_id 商品id * @return bool true，存在；false，不存在 */ function check_goods_specifications_exist($goods_id) { $goods_id = intval($goods_id); $sql = "SELECT COUNT(a.attr_id) FROM " .$GLOBALS['ecs']->table('attribute'). " AS a, " .$GLOBALS['ecs']->table('goods'). " AS g WHERE a.cat_id = g.goods_type AND g.goods_id = '$goods_id'"; $count = $GLOBALS['db']->getOne($sql); if ($count > 0) { return true; //存在 } else { return false; //不存在 } } /** * 商品的货品规格是否存在 * * @param string $goods_attr 商品的货品规格 * @param string $goods_id 商品id * @param int $product_id 商品的货品id；默认值为：0，没有货品id * @return bool true，重复；false，不重复 */ function check_goods_attr_exist($goods_attr, $goods_id, $product_id = 0) { $goods_id = intval($goods_id); if (strlen($goods_attr) == 0 || empty($goods_id)) { return true; //重复 } if (empty($product_id)) { $sql = "SELECT product_id FROM " . $GLOBALS['ecs']->table('products') ." WHERE goods_attr = '$goods_attr' AND goods_id = '$goods_id'"; } else { $sql = "SELECT product_id FROM " . $GLOBALS['ecs']->table('products') ." WHERE goods_attr = '$goods_attr' AND goods_id = '$goods_id' AND product_id <> '$product_id'"; } $res = $GLOBALS['db']->getOne($sql); if (empty($res)) { return false; //不重复 } else { return true; //重复 } } /** * 商品的货品货号是否重复 * * @param string $product_sn 商品的货品货号；请在传入本参数前对本参数进行SQl脚本过滤 * @param int $product_id 商品的货品id；默认值为：0，没有货品id * @return bool true，重复；false，不重复 */ function check_product_sn_exist($product_sn, $product_id = 0) { $product_sn = trim($product_sn); $product_id = intval($product_id); if (strlen($product_sn) == 0) { return true; //重复 } $sql="SELECT goods_id FROM ". $GLOBALS['ecs']->table('goods')."WHERE goods_sn='$product_sn'"; if($GLOBALS['db']->getOne($sql)) { return true; //重复 } if (empty($product_id)) { $sql = "SELECT product_id FROM " . $GLOBALS['ecs']->table('products') ." WHERE product_sn = '$product_sn'"; } else { $sql = "SELECT product_id FROM " . $GLOBALS['ecs']->table('products') ." WHERE product_sn = '$product_sn' AND product_id <> '$product_id'"; } $res = $GLOBALS['db']->getOne($sql); if (empty($res)) { return false; //不重复 } else { return true; //重复 } } /** * 格式化商品图片名称（按目录存储） * */ function reformat_image_name($type, $goods_id, $source_img, $position='') { $rand_name = gmtime() . sprintf("%03d", mt_rand(1,999)); $img_ext = substr($source_img, strrpos($source_img, '.')); $dir = 'images'; if (defined('IMAGE_DIR')) { $dir = IMAGE_DIR; } $sub_dir = date('Ym', gmtime()); if (!make_dir(ROOT_PATH.$dir.'/'.$sub_dir)) { return false; } if (!make_dir(ROOT_PATH.$dir.'/'.$sub_dir.'/source_img')) { return false; } if (!make_dir(ROOT_PATH.$dir.'/'.$sub_dir.'/goods_img')) { return false; } if (!make_dir(ROOT_PATH.$dir.'/'.$sub_dir.'/thumb_img')) { return false; } switch($type) { case 'goods': $img_name = $goods_id . '_G_' . $rand_name; break; case 'goods_thumb': $img_name = $goods_id . '_thumb_G_' . $rand_name; break; case 'gallery': $img_name = $goods_id . '_P_' . $rand_name; break; case 'gallery_thumb': $img_name = $goods_id . '_thumb_P_' . $rand_name; break; } if ($position == 'source') { if (move_image_file(ROOT_PATH.$source_img, ROOT_PATH.$dir.'/'.$sub_dir.'/source_img/'.$img_name.$img_ext)) { return $dir.'/'.$sub_dir.'/source_img/'.$img_name.$img_ext; } } elseif ($position == 'thumb') { if (move_image_file(ROOT_PATH.$source_img, ROOT_PATH.$dir.'/'.$sub_dir.'/thumb_img/'.$img_name.$img_ext)) { return $dir.'/'.$sub_dir.'/thumb_img/'.$img_name.$img_ext; } } else { if (move_image_file(ROOT_PATH.$source_img, ROOT_PATH.$dir.'/'.$sub_dir.'/goods_img/'.$img_name.$img_ext)) { return $dir.'/'.$sub_dir.'/goods_img/'.$img_name.$img_ext; } } return false; } function move_image_file($source, $dest) { if (@copy($source, $dest)) { @unlink($source); return true; } return false; } // 获取一层分类 function cat_list_one($cat_id=0, $cat_level=0) { if ($cat_id == 0) { $arr = cat_list($cat_id,0,true,1); return $arr; } else { $arr = cat_list($cat_id,0,false,2); foreach ($arr as $key => $value) { if ($key == $cat_id) { unset($arr[$cat_id]); } } // 拼接字符串 $str = ''; if($arr) { $cat_level ++; $str .= ""; } return $str; } } // 获取一层分类 function cat_list_one1($cat_id=0, $cat_level=0) { if ($cat_id == 0) { $arr = cat_list($cat_id,0,true,1); return $arr; } else { $arr = cat_list($cat_id,0,false,2); foreach ($arr as $key => $value) { if ($key == $cat_id) { unset($arr[$cat_id]); } } // 拼接字符串 $str = ''; if($arr) { $cat_level ++; $str .= ""; } return $str; } } // 获取一层分类 function cat_list_one2($cat_id=0, $cat_level=0) { if ($cat_id == 0) { $arr = cat_list($cat_id,0,true,1); return $arr; } else { $arr = cat_list($cat_id,0,false,2); foreach ($arr as $key => $value) { if ($key == $cat_id) { unset($arr[$cat_id]); } } // 拼接字符串 $str = ''; if($arr) { $cat_level ++; $str .= ""; } return $str; } } ?>