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：

  1 <?php  2 define('IN_ECS', true);  3 require(dirname(__FILE__) . '/includes/init.php');  4 include_once(ROOT_PATH . 'includes/cls_image.php');  5 $image = new cls_image($_CFG['bgcolor']);  6 $exc = new exchange($ecs->table("materials"), $db, 'id', 'name');  7 $_REQUEST['act']=!empty($_REQUEST['act']) ? $_REQUEST['act']:'list';  8 admin_priv('stock_alert');//權限：庫存數量修改  9 if($_REQUEST['act'] == 'list') 10 { 11     $stock_list=material_list(); 12     $smarty->assign('ur_here',      '物料庫存列表'); 13     $smarty->assign('stock_list',     $stock_list['stock_list']); 14     $smarty->assign('filter',       $stock_list['filter']); 15     $smarty->assign('record_count', $stock_list['record_count']); 16     $smarty->assign('page_count',   $stock_list['page_count']); 17      18     $smarty->assign('shelf_list',     $shelf_list); 19     $smarty->assign('full_page',    1); 20     $smarty->assign('action_link',  array('href' => 'goods_stock.php?act=list', 'text' => '商品庫存列表')); 21     $smarty->assign('action_link2',  array('href' => 'materials.php?act=export', 'text' => '導出采購單')); 22     $smarty->assign('action_link3',  array('href' => 'materials.php?act=add', 'text' => '添加物料')); 23      24     $smarty->display('material_list.htm'); 25 } 26 elseif($_REQUEST['act'] == 'add') 27 {     28     $smarty->assign('ur_here',      "添加物料"); 29     $smarty->assign('action_link', array('href' => 'materials.php?act=list', 'text' => '返回物料庫存列表')); 30     $smarty->assign('form_action', "insert"); 31  32     assign_query_info(); 33     $smarty->display('material_info.htm'); 34 } 35 elseif($_REQUEST['act'] == 'insert') 36 { 37     $material['is_buy']    = isset($_REQUEST['is_buy']) ? intval($_REQUEST['is_buy']) : 1; 38     $material['name']      = isset($_REQUEST['name']) ? trim($_REQUEST['name']) : ''; 39     $material['modulus']   = isset($_REQUEST['modulus']) ? trim($_REQUEST['modulus']) : ''; 40     $material['safe_day']  = isset($_REQUEST['safe_day']) ? intval($_REQUEST['safe_day']) : 0; 41     $material['intent_day']= isset($_REQUEST['intent_day']) ? intval($_REQUEST['intent_day']) : 0; 42     $material['price']     = isset($_REQUEST['price']) ? floatval($_REQUEST['price']) : '0.00'; 43     $material['weight']    = isset($_REQUEST['weight']) ? intval($_REQUEST['weight']) : 0; 44     $material['desc_info'] = isset($_REQUEST['desc_info']) ? trim($_REQUEST['desc_info']) : ''; 45     $material['remark']    = isset($_REQUEST['remark']) ? trim($_REQUEST['remark']) : ''; 46     $material['update_time']= gmtime(); 47     $material['admin_id']   = $_session['admin_id']; 48      49     if(empty($material['name']) || empty($material['modulus']) || empty($material['safe_day']) || empty($material['intent_day'])) 50     { 51         sys_msg('名稱、系數、安全天數、目標天數，不能為空或者格式不正確', 1); 52     } 53      54     $is_only = $exc->is_only('name', $material['name']); 55     if (!$is_only) 56     { 57         sys_msg($material['name'].'，已存在', 1); 58     } 59  60      /*處理圖片*/ 61     $material['img'] = basename($image->upload_image($_FILES['img'],'material')); 62      /*處理URL*/ 63     $material['buy_url'] = sanitize_url($_POST['buy_url']); 64     /*插入數據*/ 65     $db->autoExecute($ecs->table('materials'), $material, 'INSERT', '', 'SILENT'); 66  67     $link[0]['text'] = '繼續添加'; 68     $link[0]['href'] = 'materials.php?act=add'; 69     $link[1]['text'] = '返回列表'; 70     $link[1]['href'] = 'materials.php?act=list'; 71     sys_msg('添加成功', 0, $link); 72 } 73 elseif($_REQUEST['act'] == 'updata') 74 { 75     $id    = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : 0; 76     $material['is_buy']    = isset($_REQUEST['is_buy']) ? intval($_REQUEST['is_buy']) : 1; 77     $material['name']      = isset($_REQUEST['name']) ? trim($_REQUEST['name']) : ''; 78     $material['modulus']   = isset($_REQUEST['modulus']) ? trim($_REQUEST['modulus']) : ''; 79     $material['safe_day']  = isset($_REQUEST['safe_day']) ? intval($_REQUEST['safe_day']) : 0; 80     $material['intent_day']= isset($_REQUEST['intent_day']) ? intval($_REQUEST['intent_day']) : 0; 81     $material['price']     = isset($_REQUEST['price']) ? floatval($_REQUEST['price']) : '0.00'; 82     $material['weight']    = isset($_REQUEST['weight']) ? intval($_REQUEST['weight']) : 0; 83     $material['desc_info'] = isset($_REQUEST['desc_info']) ? trim($_REQUEST['desc_info']) : ''; 84     $material['remark']    = isset($_REQUEST['remark']) ? trim($_REQUEST['remark']) : ''; 85     $material['update_time']= gmtime(); 86     $material['admin_id']   = $_SESSION['admin_id']; 87      88     if(empty($id)) 89     { 90         sys_msg('ID不能為空', 1); 91     } 92      93     if(empty($material['name']) || empty($material['modulus']) || empty($material['safe_day']) || empty($material['intent_day'])) 94     { 95         sys_msg('名稱、系數、安全天數、目標天數，不能為空或者格式不正確', 1); 96     } 97  98      /*處理圖片*/ 99      if(!empty($_FILES['img']['name']))100      {101         $material['img'] = basename($image->upload_image($_FILES['img'],'material'));102      }103      /*處理URL*/104     $material['buy_url'] = sanitize_url($_POST['buy_url']);105     /*插入數據*/106     $db->autoExecute($ecs->table('materials'), $material, 'UPDATE', "id = '$id'");107 108     $link[0]['text'] = '繼續編輯';109     $link[0]['href'] = 'materials.php?act=edit&id='.$id;110     $link[1]['text'] = '返回列表';111     $link[1]['href'] = 'materials.php?act=list';112     sys_msg('編輯成功', 0, $link);113 }114 elseif ($_REQUEST['act'] =='edit')115 {116     $sql = "SELECT * FROM " .$ecs->table('materials'). " WHERE id='$_REQUEST[id]'";117     $material = $db->GetRow($sql);118     $smarty->assign('ur_here',     "編輯物料");119     $smarty->assign('action_link', array('href' => 'materials.php?act=list', 'text' => '返回物料庫存列表'));120     $smarty->assign('material',    $material);121     $smarty->assign('form_action', 'updata');122     assign_query_info();123     $smarty->display('material_info.htm');124 }125 elseif ($_REQUEST['act'] == 'remove')126 {127     $id = intval($_GET['id']);128     $exc->drop($id);129     $url = 'materials.php?act=query&' . str_replace('act=remove', '', $_SERVER['QUERY_STRING']);130     ecs_header("Location: $url/n");131     exit;132 }133 elseif ($_REQUEST['act'] == 'drop_img')134 {135     $id = isset($_GET['id']) ? intval($_GET['id']) : 0;136 137     $sql = "SELECT img FROM " .$ecs->table('materials'). " WHERE id = '$id'";138     $img_name = $db->getOne($sql);139 140     if (!empty($img_name))141     {142         @unlink(ROOT_PATH . DATA_DIR . '/material/' .$img_name);143         $sql = "UPDATE " .$ecs->table('materials'). " SET img = '' WHERE id = '$id'";144         $db->query($sql);145     }146     $link= array(array('text' => '繼續編輯', 'href' => 'materials.php?act=edit&id=' . $id), array('text' =>