You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
989 lines
34 KiB
989 lines
34 KiB
<?php
|
|
|
|
/**
|
|
* ECSHOP 会员管理程序
|
|
* ============================================================================
|
|
* * 版权所有 2005-2016 上海商创网络科技有限公司，并保留所有权利。
|
|
* 网站地址: http://www.ecmoban.com；
|
|
* ----------------------------------------------------------------------------
|
|
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
|
|
* 使用；不允许对程序代码以任何形式任何目的的再发布。
|
|
* ============================================================================
|
|
* $Author: liubo $
|
|
* $Id: users.php 17217 2011-01-19 06:29:08Z liubo $
|
|
*/
|
|
|
|
define('IN_ECS', true);
|
|
|
|
require(dirname(__FILE__) . '/includes/init.php');
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 用户帐号列表
|
|
/*------------------------------------------------------ */
|
|
|
|
if ($_REQUEST['act'] == 'warehouse_list')
|
|
{
|
|
/* 检查权限 */
|
|
admin_priv('goods_manage');
|
|
|
|
$goods_id = isset($_REQUEST['goods_id']) ? $_REQUEST['goods_id'] : 0;
|
|
|
|
$date = array('goods_name');
|
|
|
|
$where = "goods_id = '$goods_id'";
|
|
$goods_name = get_table_date('goods', $where, $date, 2);
|
|
|
|
$smarty->assign('ur_here', $goods_name);
|
|
$smarty->assign('action_link', array('text' => '商品列表', 'href'=>'goods.php?act=list'));
|
|
|
|
$warehouse_list = warehouse_product_list($goods_id);
|
|
|
|
$_SESSION['warehouse_goods_id'] = $goods_id;
|
|
|
|
$smarty->assign('goods_id', $goods_id);
|
|
$smarty->assign('warehouse_list', $warehouse_list['warehouse_list']);
|
|
$smarty->assign('filter', $warehouse_list['filter']);
|
|
$smarty->assign('record_count', $warehouse_list['record_count']);
|
|
$smarty->assign('page_count', $warehouse_list['page_count']);
|
|
$smarty->assign('full_page', 1);
|
|
$smarty->assign('sort_user_id', '<img src="images/sort_desc.gif">');
|
|
|
|
assign_query_info();
|
|
$smarty->display('goods_warehouse_attr_list.htm');
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- ajax返回用户列表
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'query')
|
|
{
|
|
$warehouse_list = warehouse_product_list($_SESSION['warehouse_goods_id']);
|
|
|
|
$smarty->assign('goods_id', $_SESSION['warehouse_goods_id']);
|
|
$smarty->assign('warehouse_list', $warehouse_list['warehouse_list']);
|
|
$smarty->assign('filter', $warehouse_list['filter']);
|
|
$smarty->assign('record_count', $warehouse_list['record_count']);
|
|
$smarty->assign('page_count', $warehouse_list['page_count']);
|
|
|
|
$sort_flag = sort_flag($warehouse_list['filter']);
|
|
$smarty->assign($sort_flag['tag'], $sort_flag['img']);
|
|
|
|
make_json_result($smarty->fetch('goods_warehouse_attr_list.htm'), '', array('filter' => $warehouse_list['filter'], 'page_count' => $warehouse_list['page_count']));
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 货品列表
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'product_list')
|
|
{
|
|
admin_priv('goods_manage');
|
|
|
|
$goods_id = isset($_REQUEST['goods_id']) ? $_REQUEST['goods_id'] : 0;
|
|
$warehouse_id = isset($_REQUEST['warehouse_id']) ? $_REQUEST['warehouse_id'] : 0;
|
|
|
|
$_SESSION['product_warehouse'] = $warehouse_id;
|
|
/* 是否存在商品id */
|
|
if (empty($goods_id))
|
|
{
|
|
$link[] = array('href' => 'goods.php?act=list', 'text' => $_LANG['cannot_found_goods']);
|
|
sys_msg($_LANG['cannot_found_goods'], 1, $link);
|
|
}
|
|
else
|
|
{
|
|
$goods_id = intval($goods_id);
|
|
}
|
|
|
|
/* 取出商品信息 */
|
|
$sql = "SELECT goods_sn, goods_name, goods_type, shop_price, model_attr FROM " . $ecs->table('goods') . " WHERE goods_id = '$goods_id'";
|
|
$goods = $db->getRow($sql);
|
|
if (empty($goods))
|
|
{
|
|
$link[] = array('href' => 'goods.php?act=list', 'text' => $_LANG['01_goods_list']);
|
|
sys_msg($_LANG['cannot_found_goods'], 1, $link);
|
|
}
|
|
|
|
$smarty->assign('sn', sprintf($_LANG['good_goods_sn'], $goods['goods_sn']));
|
|
$smarty->assign('price', sprintf($_LANG['good_shop_price'], $goods['shop_price']));
|
|
$smarty->assign('goods_name', sprintf($_LANG['products_title'], $goods['goods_name']));
|
|
$smarty->assign('goods_sn', sprintf($_LANG['products_title_2'], $goods['goods_sn']));
|
|
$smarty->assign('model_attr', $goods['model_attr']);
|
|
|
|
$region_name = get_table_date('region_warehouse', "region_id = '$warehouse_id'", array('region_name'), 2);
|
|
$smarty->assign('region_name', $region_name);
|
|
$smarty->assign('warehouse_id', $warehouse_id);
|
|
|
|
/* 获取商品规格列表 */
|
|
$attribute = get_goods_specifications_list($goods_id);
|
|
if (empty($attribute))
|
|
{
|
|
$link[] = array('href' => 'goods.php?act=edit&goods_id=' . $goods_id, 'text' => $_LANG['edit_goods']);
|
|
sys_msg($_LANG['not_exist_goods_attr'], 1, $link);
|
|
}
|
|
|
|
foreach ($attribute as $attribute_value)
|
|
{
|
|
//转换成数组
|
|
$_attribute[$attribute_value['attr_id']]['attr_values'][] = $attribute_value['attr_value'];
|
|
$_attribute[$attribute_value['attr_id']]['attr_id'] = $attribute_value['attr_id'];
|
|
$_attribute[$attribute_value['attr_id']]['attr_name'] = $attribute_value['attr_name'];
|
|
}
|
|
$attribute_count = count($_attribute);
|
|
|
|
$smarty->assign('attribute_count', $attribute_count);
|
|
$smarty->assign('attribute_count_3', ($attribute_count + 3));
|
|
$smarty->assign('attribute', $_attribute);
|
|
$smarty->assign('product_sn', $goods['goods_sn'] . '_');
|
|
$smarty->assign('product_number', $_CFG['default_storage']);
|
|
|
|
/* 取商品的货品 */
|
|
$product = product_warehouse_list($goods_id, '', $warehouse_id);
|
|
|
|
$smarty->assign('ur_here', $_LANG['18_product_list']);
|
|
$smarty->assign('action_link', array('href' => 'goods.php?act=list', 'text' => $_LANG['01_goods_list']));
|
|
$smarty->assign('product_list', $product['product']);
|
|
$smarty->assign('product_null', empty($product['product']) ? 0 : 1);
|
|
$smarty->assign('use_storage', empty($_CFG['use_storage']) ? 0 : 1);
|
|
$smarty->assign('goods_id', $goods_id);
|
|
$smarty->assign('filter', $product['filter']);
|
|
$smarty->assign('full_page', 1);
|
|
|
|
$smarty->assign('product_php', 'goods_warehouse_attr.php');
|
|
$smarty->assign('batch_php', 'goods_produts_warehouse_batch.php');
|
|
|
|
/* 显示商品列表页面 */
|
|
assign_query_info();
|
|
|
|
$smarty->display('product_info.htm');
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 货品排序、分页、查询
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'product_query')
|
|
{
|
|
$warehouse_id = isset($_REQUEST['warehouse_id']) ? $_REQUEST['warehouse_id'] : 0;
|
|
|
|
/* 是否存在商品id */
|
|
if (empty($_REQUEST['goods_id']))
|
|
{
|
|
make_json_error($_LANG['sys']['wrong'] . $_LANG['cannot_found_goods']);
|
|
}
|
|
else
|
|
{
|
|
$goods_id = intval($_REQUEST['goods_id']);
|
|
}
|
|
|
|
/* 取出商品信息 */
|
|
$sql = "SELECT goods_sn, goods_name, goods_type, shop_price FROM " . $ecs->table('goods') . " WHERE goods_id = '$goods_id'";
|
|
$goods = $db->getRow($sql);
|
|
if (empty($goods))
|
|
{
|
|
make_json_error($_LANG['sys']['wrong'] . $_LANG['cannot_found_goods']);
|
|
}
|
|
$smarty->assign('sn', sprintf($_LANG['good_goods_sn'], $goods['goods_sn']));
|
|
$smarty->assign('price', sprintf($_LANG['good_shop_price'], $goods['shop_price']));
|
|
$smarty->assign('goods_name', sprintf($_LANG['products_title'], $goods['goods_name']));
|
|
$smarty->assign('goods_sn', sprintf($_LANG['products_title_2'], $goods['goods_sn']));
|
|
|
|
$region_name = get_table_date('region_warehouse', "region_id = '$warehouse_id'", array('region_name'), 2);
|
|
$smarty->assign('region_name', $region_name);
|
|
$smarty->assign('warehouse_id', $warehouse_id);
|
|
|
|
/* 获取商品规格列表 */
|
|
$attribute = get_goods_specifications_list($goods_id);
|
|
if (empty($attribute))
|
|
{
|
|
make_json_error($_LANG['sys']['wrong'] . $_LANG['cannot_found_goods']);
|
|
}
|
|
foreach ($attribute as $attribute_value)
|
|
{
|
|
//转换成数组
|
|
$_attribute[$attribute_value['attr_id']]['attr_values'][] = $attribute_value['attr_value'];
|
|
$_attribute[$attribute_value['attr_id']]['attr_id'] = $attribute_value['attr_id'];
|
|
$_attribute[$attribute_value['attr_id']]['attr_name'] = $attribute_value['attr_name'];
|
|
}
|
|
$attribute_count = count($_attribute);
|
|
|
|
$smarty->assign('attribute_count', $attribute_count);
|
|
$smarty->assign('attribute', $_attribute);
|
|
$smarty->assign('attribute_count_3', ($attribute_count + 10));
|
|
$smarty->assign('product_sn', $goods['goods_sn'] . '_');
|
|
$smarty->assign('product_number', $_CFG['default_storage']);
|
|
|
|
/* 取商品的货品 */
|
|
$product = product_warehouse_list($goods_id, '', $warehouse_id);
|
|
|
|
$smarty->assign('ur_here', $_LANG['18_product_list']);
|
|
$smarty->assign('action_link', array('href' => 'goods.php?act=list', 'text' => $_LANG['01_goods_list']));
|
|
$smarty->assign('product_list', $product['product']);
|
|
$smarty->assign('use_storage', empty($_CFG['use_storage']) ? 0 : 1);
|
|
$smarty->assign('goods_id', $goods_id);
|
|
$smarty->assign('filter', $product['filter']);
|
|
$smarty->assign('product_php', 'goods_warehouse_attr.php');
|
|
|
|
/* 排序标记 */
|
|
$sort_flag = sort_flag($product['filter']);
|
|
$smarty->assign($sort_flag['tag'], $sort_flag['img']);
|
|
|
|
make_json_result($smarty->fetch('product_info.htm'), '',
|
|
array('filter' => $product['filter'], 'page_count' => $product['page_count']));
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 修改货品价格
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'edit_product_sn')
|
|
{
|
|
check_authz_json('goods_manage');
|
|
|
|
$product_id = intval($_REQUEST['id']);
|
|
$product_sn = json_str_iconv(trim($_POST['val']));
|
|
$product_sn = ($_LANG['n_a'] == $product_sn) ? '' : $product_sn;
|
|
|
|
if (check_product_warehouse_sn_exist($product_sn, $product_id))
|
|
{
|
|
make_json_error($_LANG['sys']['wrong'] . $_LANG['exist_same_product_sn']);
|
|
}
|
|
|
|
/* 修改 */
|
|
$sql = "UPDATE " . $ecs->table('products_warehouse') . " SET product_sn = '$product_sn' WHERE product_id = '$product_id'";
|
|
$result = $db->query($sql);
|
|
if ($result)
|
|
{
|
|
clear_cache_files();
|
|
make_json_result($product_sn);
|
|
}
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 修改货品库存
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'edit_product_number')
|
|
{
|
|
check_authz_json('goods_manage');
|
|
|
|
$product_id = intval($_POST['id']);
|
|
$product_number = intval($_POST['val']);
|
|
|
|
/* 货品库存 */
|
|
$product = get_product_warehouse_info($product_id, 'product_number, goods_id');
|
|
|
|
/* 修改货品库存 */
|
|
$sql = "UPDATE " . $ecs->table('products_warehouse') . " SET product_number = '$product_number' WHERE product_id = '$product_id'";
|
|
$result = $db->query($sql);
|
|
|
|
if ($result)
|
|
{
|
|
/* 修改商品库存 */ //ecmoban模板堂 --zhuo 注释
|
|
/*if (update_goods_stock($product['goods_id'], $product_number - $product['product_number'], $warehouse_id))
|
|
{*/
|
|
clear_cache_files();
|
|
make_json_result($product_number);
|
|
/*}*/
|
|
}
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 货品删除
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'product_remove')
|
|
{
|
|
/* 检查权限 */
|
|
check_authz_json('remove_back');
|
|
|
|
$product_id = intval($_REQUEST['id']);
|
|
|
|
/* 是否存在商品id */
|
|
if (empty($product_id))
|
|
{
|
|
make_json_error($_LANG['product_id_null']);
|
|
}
|
|
else
|
|
{
|
|
$product_id = intval($product_id);
|
|
}
|
|
|
|
/* 货品库存 */
|
|
$product = get_product_warehouse_info($product_id, 'product_number, goods_id');
|
|
|
|
/* 删除货品 */
|
|
$sql = "DELETE FROM " . $ecs->table('products_warehouse') . " WHERE product_id = '$product_id'";
|
|
$result = $db->query($sql);
|
|
|
|
if ($result)
|
|
{
|
|
/* 修改商品库存 */ //ecmoban模板堂 --zhuo 注释
|
|
/*if (update_goods_stock($product['goods_id'], $product_number - $product['product_number'], $warehouse_id))
|
|
{
|
|
//记录日志
|
|
admin_log('', 'update', 'goods');
|
|
}
|
|
|
|
//记录日志
|
|
admin_log('', 'trash', 'products');*/
|
|
|
|
$url = 'goods_warehouse_attr.php?act=product_query&warehouse_id=' .$_SESSION['product_warehouse']. '&' . str_replace('act=product_remove', '', $_SERVER['QUERY_STRING']);
|
|
|
|
ecs_header("Location: $url\n");
|
|
exit;
|
|
}
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 货品添加 执行
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'product_add_execute')
|
|
{
|
|
admin_priv('goods_manage');
|
|
|
|
$product['goods_id'] = intval($_POST['goods_id']);
|
|
$product['attr'] = $_POST['attr'];
|
|
$product['product_sn'] = $_POST['product_sn'];
|
|
$product['product_number'] = $_POST['product_number'];
|
|
$product['warehouse_id'] = $_POST['warehouse_id'];
|
|
|
|
/* 是否存在商品id */
|
|
if (empty($product['goods_id']))
|
|
{
|
|
sys_msg($_LANG['sys']['wrong'] . $_LANG['cannot_found_goods'], 1, array(), false);
|
|
}
|
|
|
|
/* 判断是否为初次添加 */
|
|
$insert = true;
|
|
if (product_warehouse_number_count($product['goods_id'], '', $product['warehouse_id']) > 0)
|
|
{
|
|
$insert = false;
|
|
}
|
|
|
|
/* 取出商品信息 */
|
|
$sql = "SELECT goods_sn, goods_name, goods_type, shop_price FROM " . $ecs->table('goods') . " WHERE goods_id = '" . $product['goods_id'] . "'";
|
|
$goods = $db->getRow($sql);
|
|
if (empty($goods))
|
|
{
|
|
sys_msg($_LANG['sys']['wrong'] . $_LANG['cannot_found_goods'], 1, array(), false);
|
|
}
|
|
|
|
/* */
|
|
foreach($product['product_sn'] as $key => $value)
|
|
{
|
|
//过滤
|
|
$product['product_number'][$key] = empty($product['product_number'][$key]) ? (empty($_CFG['use_storage']) ? 0 : $_CFG['default_storage']) : trim($product['product_number'][$key]); //库存
|
|
|
|
//获取规格在商品属性表中的id
|
|
foreach($product['attr'] as $attr_key => $attr_value)
|
|
{
|
|
/* 检测：如果当前所添加的货品规格存在空值或0 */
|
|
if (empty($attr_value[$key]))
|
|
{
|
|
continue 2;
|
|
}
|
|
|
|
$is_spec_list[$attr_key] = 'true';
|
|
|
|
$value_price_list[$attr_key] = $attr_value[$key] . chr(9) . ''; //$key，当前
|
|
|
|
$id_list[$attr_key] = $attr_key;
|
|
}
|
|
$goods_attr_id = handle_goods_attr($product['goods_id'], $id_list, $is_spec_list, $value_price_list);
|
|
|
|
/* 是否为重复规格的货品 */
|
|
$goods_attr = sort_goods_attr_id_array($goods_attr_id);
|
|
$goods_attr = implode('|', $goods_attr['sort']);
|
|
if (check_goods_attr_exist($goods_attr, $product['goods_id'], 0, $product['warehouse_id']))
|
|
{
|
|
continue;
|
|
//sys_msg($_LANG['sys']['wrong'] . $_LANG['exist_same_goods_attr'], 1, array(), false);
|
|
}
|
|
|
|
//货品号不为空
|
|
if (!empty($value))
|
|
{
|
|
/* 检测：货品货号是否在商品表和货品表中重复 */
|
|
if (check_goods_sn_exist($value))
|
|
{
|
|
continue;
|
|
//sys_msg($_LANG['sys']['wrong'] . $_LANG['exist_same_goods_sn'], 1, array(), false);
|
|
}
|
|
if (check_product_sn_exist($value))
|
|
{
|
|
continue;
|
|
//sys_msg($_LANG['sys']['wrong'] . $_LANG['exist_same_product_sn'], 1, array(), false);
|
|
}
|
|
}
|
|
|
|
/* 插入货品表 */
|
|
$sql = "INSERT INTO " . $GLOBALS['ecs']->table('products_warehouse') . " (goods_id, goods_attr, product_sn, product_number, warehouse_id) VALUES ('" . $product['goods_id'] . "', '$goods_attr', '$value', '" . $product['product_number'][$key] . "', '" . $product['warehouse_id'] . "')";
|
|
if (!$GLOBALS['db']->query($sql))
|
|
{
|
|
continue;
|
|
//sys_msg($_LANG['sys']['wrong'] . $_LANG['cannot_add_products'], 1, array(), false);
|
|
}
|
|
|
|
//货品号为空 自动补货品号
|
|
if (empty($value))
|
|
{
|
|
$sql = "UPDATE " . $GLOBALS['ecs']->table('products_warehouse') . "
|
|
SET product_sn = '" . $goods['goods_sn'] . "g_p" . $GLOBALS['db']->insert_id() . "'
|
|
WHERE product_id = '" . $GLOBALS['db']->insert_id() . "'";
|
|
$GLOBALS['db']->query($sql);
|
|
}
|
|
|
|
/* 修改商品表库存 */
|
|
$product_count = product_warehouse_number_count($product['goods_id'], '', $product['warehouse_id']);
|
|
if (update_warehouse_goods($product['goods_id'], 'goods_number', $product_count))
|
|
{
|
|
//记录日志
|
|
admin_log($product['goods_id'], 'update', 'goods');
|
|
}
|
|
}
|
|
|
|
clear_cache_files();
|
|
|
|
/* 返回 */
|
|
if ($insert)
|
|
{
|
|
$link[] = array('href' => 'goods.php?act=add', 'text' => $_LANG['02_goods_add']);
|
|
$link[] = array('href' => 'goods.php?act=list', 'text' => $_LANG['01_goods_list']);
|
|
$link[] = array('href' => 'goods_warehouse_attr.php?act=product_list&goods_id=' . $product['goods_id'] . '&warehouse_id='.$product['warehouse_id'], 'text' => $_LANG['18_product_list']);
|
|
}
|
|
else
|
|
{
|
|
$link[] = array('href' => 'goods.php?act=list&uselastfilter=1', 'text' => $_LANG['01_goods_list']);
|
|
$link[] = array('href' => 'goods.php?act=edit&goods_id=' . $product['goods_id'], 'text' => $_LANG['edit_goods']);
|
|
$link[] = array('href' => 'goods_warehouse_attr.php?act=product_list&goods_id=' . $product['goods_id'] . '&warehouse_id='.$product['warehouse_id'], 'text' => $_LANG['18_product_list']);
|
|
}
|
|
sys_msg($_LANG['save_products'], 0, $link);
|
|
}
|
|
|
|
/**
|
|
* 返回用户列表数据
|
|
*
|
|
* @access public
|
|
* @param
|
|
*
|
|
* @return void
|
|
*/
|
|
function warehouse_product_list($goods_id = 0)
|
|
{
|
|
$result = get_filter();
|
|
if ($result === false)
|
|
{
|
|
/* 过滤条件 */
|
|
$filter['keywords'] = isset($_REQUEST['keywords']) ? '' : trim($_REQUEST['keywords']);
|
|
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1)
|
|
{
|
|
$filter['keywords'] = json_str_iconv($filter['keywords']);
|
|
}
|
|
|
|
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'region_id' : trim($_REQUEST['sort_by']);
|
|
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
|
|
|
|
$ex_where = " where 1 and region_type = 0";
|
|
if ($filter['keywords'])
|
|
{
|
|
$ex_where .= " AND region_name LIKE '%" . mysql_like_quote($filter['keywords']) ."%'";
|
|
}
|
|
|
|
$filter['record_count'] = $GLOBALS['db']->getOne("SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('region_warehouse') . $ex_where);
|
|
|
|
/* 分页大小 */
|
|
$filter = page_and_size($filter);
|
|
$sql = "SELECT region_id, region_name ".
|
|
" FROM " . $GLOBALS['ecs']->table('region_warehouse') . $ex_where .
|
|
" ORDER by " . $filter['sort_by'] . ' ' . $filter['sort_order'] .
|
|
" LIMIT " . $filter['start'] . ',' . $filter['page_size'];
|
|
|
|
$filter['keywords'] = stripslashes($filter['keywords']);
|
|
set_filter($filter, $sql);
|
|
}
|
|
else
|
|
{
|
|
$sql = $result['sql'];
|
|
$filter = $result['filter'];
|
|
}
|
|
|
|
$warehouse_list = $GLOBALS['db']->getAll($sql);
|
|
|
|
$count = count($warehouse_list);
|
|
for ($i=0; $i<$count; $i++)
|
|
{
|
|
$warehouse_list[$i]['region_name'] = $warehouse_list[$i]['region_name'];
|
|
|
|
$sql = "select count(*) from " .$GLOBALS['ecs']->table('products_warehouse'). " where goods_id = '$goods_id' and warehouse_id = '" .$warehouse_list[$i]['region_id']. "'";
|
|
$warehouse_list[$i]['attr_num'] = $GLOBALS['db']->getOne($sql);
|
|
}
|
|
|
|
$arr = array('warehouse_list' => $warehouse_list, 'filter' => $filter,
|
|
'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
|
|
|
|
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_warehouse_list($goods_id, $conditions = '', $warehouse_id)
|
|
{
|
|
/* 过滤条件 */
|
|
$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']);
|
|
|
|
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['page_count'] = isset($filter['page_count']) ? $filter['page_count'] : 1;
|
|
|
|
$where = '';
|
|
|
|
/* 关键字 */
|
|
if (!empty($filter['keyword']))
|
|
{
|
|
$where .= " AND (product_sn LIKE '%" . $filter['keyword'] . "%')";
|
|
}
|
|
|
|
$where .= $conditions;
|
|
$where .= " and warehouse_id = '$warehouse_id'";
|
|
|
|
/* 记录总数 */
|
|
$sql = "SELECT COUNT(*) FROM " .$GLOBALS['ecs']->table('products_warehouse'). " 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_warehouse') . " AS g
|
|
WHERE goods_id = $goods_id $where
|
|
ORDER BY $filter[sort_by] $filter[sort_order]";
|
|
|
|
$filter['keyword'] = stripslashes($filter['keyword']);
|
|
}
|
|
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
|
|
* @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
|
|
* @param int $product_id 货品id
|
|
* @param int $filed 字段
|
|
* @return array
|
|
*/
|
|
function get_product_warehouse_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 string $product_sn 商品的货品货号；请在传入本参数前对本参数进行SQl脚本过滤
|
|
* @param int $product_id 商品的货品id；默认值为：0，没有货品id
|
|
* @return bool true，重复；false，不重复
|
|
*/
|
|
function check_product_warehouse_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_warehouse') ."
|
|
WHERE product_sn = '$product_sn'";
|
|
}
|
|
else
|
|
{
|
|
$sql = "SELECT product_id FROM " . $GLOBALS['ecs']->table('products_warehouse') ."
|
|
WHERE product_sn = '$product_sn'
|
|
AND product_id <> '$product_id'";
|
|
}
|
|
|
|
$res = $GLOBALS['db']->getOne($sql);
|
|
|
|
if (empty($res))
|
|
{
|
|
return false; //不重复
|
|
}
|
|
else
|
|
{
|
|
return true; //重复
|
|
}
|
|
}
|
|
|
|
/**
|
|
* 获得商品的货品总库存
|
|
*
|
|
* @access public
|
|
* @params integer $goods_id 商品id
|
|
* @params string $conditions sql条件，AND语句开头
|
|
* @return string number
|
|
*/
|
|
function product_warehouse_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_warehouse') . "
|
|
WHERE goods_id = '$goods_id' and warehouse_id = '$warehouse_id'
|
|
" . $conditions;
|
|
$nums = $GLOBALS['db']->getOne($sql);
|
|
$nums = empty($nums) ? 0 : $nums;
|
|
|
|
return $nums;
|
|
}
|
|
|
|
/**
|
|
* 修改商品某字段值
|
|
* @param string $goods_id 商品编号，可以为多个，用 ',' 隔开
|
|
* @param string $field 字段名
|
|
* @param string $value 字段值
|
|
* @return bool
|
|
*/
|
|
function update_warehouse_goods($goods_id, $field, $value)
|
|
{
|
|
if ($goods_id)
|
|
{
|
|
/* 清除缓存 */
|
|
clear_cache_files();
|
|
|
|
$date = array('model_attr');
|
|
|
|
$where = "goods_id = '$goods_id'";
|
|
$model_attr = get_table_date('goods', $where, $date, 2);
|
|
|
|
if($model_attr == 1){
|
|
$table = "warehouse_goods";
|
|
$field = 'region_number';
|
|
}elseif($model_attr == 2){
|
|
$table = "warehouse_area_goods";
|
|
$field = 'region_number';
|
|
}else{
|
|
$table = "goods";
|
|
}
|
|
|
|
$sql = "UPDATE " . $GLOBALS['ecs']->table($table) .
|
|
" SET $field = '$value' , last_update = '". gmtime() ."' " .
|
|
"WHERE goods_id " . db_create_in($goods_id);
|
|
return $GLOBALS['db']->query($sql);
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
|
|
/**
|
|
* 插入或更新商品属性
|
|
*
|
|
* @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 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, $warehouse_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_warehouse') ."
|
|
WHERE goods_attr = '$goods_attr'
|
|
AND goods_id = '$goods_id' and warehouse_id = '$warehouse_id'";
|
|
}
|
|
else
|
|
{
|
|
$sql = "SELECT product_id FROM " . $GLOBALS['ecs']->table('products_warehouse') ."
|
|
WHERE goods_attr = '$goods_attr'
|
|
AND goods_id = '$goods_id'
|
|
AND product_id <> '$product_id' and warehouse_id = '$warehouse_id'";
|
|
}
|
|
|
|
$res = $GLOBALS['db']->getOne($sql);
|
|
|
|
if (empty($res))
|
|
{
|
|
return false; //不重复
|
|
}
|
|
else
|
|
{
|
|
return true; //重复
|
|
}
|
|
}
|
|
|
|
/**
|
|
* 商品货号是否重复
|
|
*
|
|
* @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 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_warehouse') ."
|
|
WHERE product_sn = '$product_sn'";
|
|
}
|
|
else
|
|
{
|
|
$sql = "SELECT product_id FROM " . $GLOBALS['ecs']->table('products_warehouse') ."
|
|
WHERE product_sn = '$product_sn'
|
|
AND product_id <> '$product_id'";
|
|
}
|
|
|
|
$res = $GLOBALS['db']->getOne($sql);
|
|
|
|
if (empty($res))
|
|
{
|
|
return false; //不重复
|
|
}
|
|
else
|
|
{
|
|
return true; //重复
|
|
}
|
|
}
|
|
?>
|