ecshop添加物料库存管理功能_ecshop教程_php教程

1、创建物流库存表。sql语句：

CREATE TABLE IF NOT EXISTS `emws_materials` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`name` varchar(60) NOT NULL,
`modulus` varchar(60) NOT NULL,
`stock_number` smallint(5) unsigned NOT NULL default '0',
`stock_in` smallint(5) unsigned NOT NULL default '0',
`stock_out` smallint(5) unsigned NOT NULL default '0',
`safe_day` smallint(5) unsigned NOT NULL default '0',
`intent_day` smallint(5) unsigned NOT NULL default '0',
`is_buy` tinyint(1) unsigned NOT NULL default '1',
`buy_url` varchar(60) NOT NULL,
`price` decimal(10,2) NOT NULL,
`weight` smallint(5) unsigned NOT NULL default '0',
`img` varchar(60) NOT NULL,
`desc_info` varchar(60) NOT NULL,
`remark` varchar(60) NOT NULL,
`admin_id` smallint(5) unsigned NOT NULL,
`update_time` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

2、php程序，materials.php：

<?php

define('IN_ECS', true);

require(dirname(__FILE__) . '/includes/init.php');

include_once(ROOT_PATH . 'includes/cls_image.php');

$image = new cls_image($_CFG['bgcolor']);

$exc = new exchange($ecs->table("materials"), $db, 'id', 'name');

$_REQUEST['act']=!empty($_REQUEST['act']) ? $_REQUEST['act']:'list';

admin_priv('stock_alert');//权限：库存数量修改

if($_REQUEST['act'] == 'list')

{

$stock_list=material_list();

$smarty->assign('ur_here', '物料库存列表');

$smarty->assign('stock_list', $stock_list['stock_list']);

$smarty->assign('filter', $stock_list['filter']);

$smarty->assign('record_count', $stock_list['record_count']);

$smarty->assign('page_count', $stock_list['page_count']);

$smarty->assign('shelf_list', $shelf_list);

$smarty->assign('full_page', 1);

$smarty->assign('action_link', array('href' => 'goods_stock.php?act=list', 'text' => '商品库存列表'));

$smarty->assign('action_link2', array('href' => 'materials.php?act=export', 'text' => '导出采购单'));

$smarty->assign('action_link3', array('href' => 'materials.php?act=add', 'text' => '添加物料'));

$smarty->display('material_list.htm');

}

elseif($_REQUEST['act'] == 'add')

{

$smarty->assign('ur_here', "添加物料");

$smarty->assign('action_link', array('href' => 'materials.php?act=list', 'text' => '返回物料库存列表'));

$smarty->assign('form_action', "insert");

assign_query_info();

$smarty->display('material_info.htm');

}

elseif($_REQUEST['act'] == 'insert')

{

$material['is_buy'] = isset($_REQUEST['is_buy']) ? intval($_REQUEST['is_buy']) : 1;

$material['name'] = isset($_REQUEST['name']) ? trim($_REQUEST['name']) : '';

$material['modulus'] = isset($_REQUEST['modulus']) ? trim($_REQUEST['modulus']) : '';

$material['safe_day'] = isset($_REQUEST['safe_day']) ? intval($_REQUEST['safe_day']) : 0;

$material['intent_day']= isset($_REQUEST['intent_day']) ? intval($_REQUEST['intent_day']) : 0;

$material['price'] = isset($_REQUEST['price']) ? floatval($_REQUEST['price']) : '0.00';

$material['weight'] = isset($_REQUEST['weight']) ? intval($_REQUEST['weight']) : 0;

$material['desc_info'] = isset($_REQUEST['desc_info']) ? trim($_REQUEST['desc_info']) : '';

$material['remark'] = isset($_REQUEST['remark']) ? trim($_REQUEST['remark']) : '';

$material['update_time']= gmtime();

$material['admin_id'] = $_SESSION['admin_id'];

if(empty($material['name']) || empty($material['modulus']) || empty($material['safe_day']) || empty($material['intent_day']))

{

sys_msg('名称、系数、安全天数、目标天数，不能为空或者格式不正确', 1);

}

$is_only = $exc->is_only('name', $material['name']);

if (!$is_only)

{

sys_msg($material['name'].'，已存在', 1);

}

/*处理图片*/

$material['img'] = basename($image->upload_image($_FILES['img'],'material'));

/*处理URL*/

$material['buy_url'] = sanitize_url($_POST['buy_url']);

/*插入数据*/

$db->autoExecute($ecs->table('materials'), $material, 'INSERT', '', 'SILENT');

$link[0]['text'] = '继续添加';

$link[0]['href'] = 'materials.php?act=add';

$link[1]['text'] = '返回列表';

$link[1]['href'] = 'materials.php?act=list';

sys_msg('添加成功', 0, $link);

}

elseif($_REQUEST['act'] == 'updata')

{

$id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : 0;