Exemple #1
0
        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);
Exemple #2
0
    $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);
    /* 排序标记 */