die($json->encode($res)); } die($json->encode($res)); } elseif ($_REQUEST['act'] == 'manage_receipt') { $res = array(); if (isset($_REQUEST['ext'])) { $file = basename($_SERVER['PHP_SELF'], '.php'); $nav = list_nav(); $smarty->assign('nav_2nd', $nav[1][$file]); $smarty->assign('nav_3rd', $nav[2]); $smarty->assign('file_name', $file); $res['left'] = $smarty->fetch('left.htm'); } $smarty->assign('curr_title', '商品列表'); // 获取进货单列表 @($stock_list = stock_list($stock_id, $type)); $smarty->assign('num', sprintf('(共%d条)', $stock_list['record_count'])); $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('pageprev', $stock_list['filter']['page'] - 1); $smarty->assign('pagenext', $stock_list['filter']['page'] + 1); $res['main'] = $smarty->fetch('manage_receipt.htm'); die($json->encode($res)); } elseif ($_REQUEST['act'] == 'detail_stock') { //查找进货单管理 $id = isset($_GET['id']) ? $_GET['id'] : 1; $sql_select = 'SELECT stock_id, stock_sn, FROM_UNIXTIME(arrival_day, "%Y-%m-%d") arrival_day, confirmer, contacter, phone,adder,add_time,class_num FROM ' . $GLOBALS['ecs']->table('stock') . " WHERE stock_id={$id}"; $st_list = $GLOBALS['db']->getRow($sql_select); $smarty->assign('st_list', $st_list);
$stock_id = $db->insert_id(); $sql = 'INSERT INTO ' . $ecs->table('stock_goods') . '(stock_id, goods_sn, goods_name, quantity, prickle, production_day, manufacturer, nochange)VALUES'; foreach ($_POST['goods_sn'] as $key => $val) { $values[] = "('{$stock_id}', '{$val}', '{$_POST[goods_name][$key]}', '{$_POST[quantity][$key]}', '{$_POST[prickle][$key]}', UNIX_TIMESTAMP('{$_POST[production_day][$key]}'), '{$_POST[manufacturer][$key]}', '{$_POST[quantity][$key]}')"; } $sql .= implode(',', $values); $db->query($sql); /* 将订单中的产品数量汇总至库存总量 $sql = 'UPDATE '.$ecs->table('goods').' g, '.$ecs->table('stock_goods').' s' .' SET g.goods_number=g.goods_number+s.quantity, s.collect=1 WHERE g.goods_sn=s.goods_sn AND s.collect=0'; $db->query($sql); */ sys_msg('进货单添加成功', 1, $link); sys_msg($is_insert ? $_LANG['add_goods_ok'] : $_LANG['edit_goods_ok'], 0, $link); } elseif ($_REQUEST['act'] == 'query') { $stock_list = stock_list(); $handler_list = array(); $handler_list['virtual_card'][] = array('url' => 'virtual_card.php?act=card', 'title' => $_LANG['card'], 'img' => 'icon_send_bonus.gif'); $handler_list['virtual_card'][] = array('url' => 'virtual_card.php?act=replenish', 'title' => $_LANG['replenish'], 'img' => 'icon_add.gif'); $handler_list['virtual_card'][] = array('url' => 'virtual_card.php?act=batch_card_add', 'title' => $_LANG['batch_card_add'], 'img' => 'icon_output.gif'); if (isset($handler_list[$code])) { $smarty->assign('add_handler', $handler_list[$code]); } $smarty->assign('code', $code); $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('list_type', 'stock'); $smarty->assign('use_storage', empty($_CFG['use_storage']) ? 0 : 1); /* 排序标记 */