Пример #1
0
function get_inoutgoods_list()
{
    $result = get_filter();
    if ($result === false) {
        $filter = array();
        $filter['sid'] = empty($_REQUEST['sid']) ? '0' : intval($_REQUEST['sid']);
        $filter['ssid'] = empty($_REQUEST['ssid']) ? '0' : intval($_REQUEST['ssid']);
        $filter['inout_mode'] = empty($_REQUEST['inout_mode']) ? '0' : intval($_REQUEST['inout_mode']);
        $filter['inout_type'] = empty($_REQUEST['inout_type']) ? '0' : intval($_REQUEST['inout_type']);
        $filter['add_time1'] = empty($_REQUEST['add_time1']) ? '' : (strpos($_REQUEST['add_time1'], '-') > 0 ? local_strtotime($_REQUEST['add_time1']) : $_REQUEST['add_time1']);
        $filter['add_time2'] = empty($_REQUEST['add_time2']) ? '' : (strpos($_REQUEST['add_time2'], '-') > 0 ? local_strtotime($_REQUEST['add_time2']) : $_REQUEST['add_time2']);
        $filter['brand'] = empty($_REQUEST['brand']) ? '0' : intval($_REQUEST['brand']);
        $filter['goods_sn'] = empty($_REQUEST['goods_sn']) ? '' : trim($_REQUEST['goods_sn']);
        $filter['goods_name'] = empty($_REQUEST['goods_name']) ? '' : trim($_REQUEST['goods_name']);
        $filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'b.book_id' : trim($_REQUEST['sort_by']);
        $filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
        $where = ' AND b.supplier_id=' . $_SESSION['supplier_id'];
        if ($filter['ssid']) {
            $where .= " AND l.store_id = '" . $filter['ssid'] . "' ";
        } else {
            if ($filter['sid']) {
                $where .= " AND l.store_id in " . get_ssid_list($filter['sid']);
            }
        }
        if ($filter['inout_type']) {
            $where .= " AND l.inout_type = '" . $filter['inout_type'] . "' ";
        }
        if ($filter['add_time1']) {
            $where .= " AND l.add_time>=  '" . $filter['add_time1'] . "' ";
        }
        if ($filter['add_time2']) {
            $where .= " AND l.add_time<=  '" . $filter['add_time2'] . "' ";
        }
        if ($filter['inout_mode']) {
            $where .= " AND b.inout_mode = '" . $filter['inout_mode'] . "' ";
        }
        if ($filter['goods_sn']) {
            $where .= " AND g.goods_sn = '" . $filter['goods_sn'] . "' ";
        }
        if ($filter['goods_name']) {
            $where .= " AND g.goods_name like '%" . $filter['goods_name'] . "%' ";
        }
        if ($filter['brand']) {
            $where .= " AND g.brand_id = '" . $filter['brand'] . "' ";
        }
        /* 总数 */
        $sql = 'SELECT COUNT(*) FROM ' . $GLOBALS['ecs']->table('store_inout_xushibu') . ' AS b ' . ' left join ' . $GLOBALS['ecs']->table('store_inout_list') . ' AS l on b.inout_rec_id=l.rec_id  ' . ' left join ' . $GLOBALS['ecs']->table('goods') . ' AS g on b.goods_id = g.goods_id ' . ' WHERE 1 ' . $where;
        $filter['record_count'] = $GLOBALS['db']->getOne($sql);
        $filter = page_and_size($filter);
        /* 获取入库单数据 */
        $sql = 'SELECT b.book_id, b.attr_value, b.inout_mode, b.number_shishou, b.number_stock, g.goods_id, ' . 'g.goods_name, g.goods_sn, g.goods_thumb, l.store_id, l.inout_sn, l.order_sn, l.inout_type, l.takegoods_man, l.add_time  ' . 'FROM ' . $GLOBALS['ecs']->table('store_inout_xushibu') . ' AS b ' . ' left join ' . $GLOBALS['ecs']->table('store_inout_list') . ' AS l on b.inout_rec_id=l.rec_id  ' . ' left join ' . $GLOBALS['ecs']->table('goods') . ' AS g on b.goods_id=g.goods_id ' . ' WHERE 1 ' . $where . ' ORDER by ' . $filter['sort_by'] . ' ' . $filter['sort_order'];
        $filter['keyword'] = stripslashes($filter['keyword']);
        set_filter($filter, $sql);
    } else {
        $sql = $result['sql'];
        $filter = $result['filter'];
    }
    $arr = array();
    $res = $GLOBALS['db']->selectLimit($sql, $filter['page_size'], $filter['start']);
    while ($rows = $GLOBALS['db']->fetchRow($res)) {
        $rows['store_name'] = get_store_fullname($rows['store_id']);
        $rows['goods_attr_name'] = get_attr_name($rows['attr_value']);
        $rows['add_time'] = local_date($GLOBALS['_CFG']['time_format'], $rows['add_time']);
        $rows['goods_thumb'] = get_image_path($rows['goods_id'], $rows['goods_thumb'], true);
        $rows['inout_type_name'] = get_inout_type_name($rows['inout_type']);
        $arr[] = $rows;
    }
    return array('arr' => $arr, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
}
Пример #2
0
function get_inoutlist()
{
    $result = get_filter();
    if ($result === false) {
        $filter = array();
        $filter['sid'] = empty($_REQUEST['sid']) ? '0' : intval($_REQUEST['sid']);
        $filter['ssid'] = empty($_REQUEST['ssid']) ? '0' : intval($_REQUEST['ssid']);
        $filter['inout_status'] = empty($_REQUEST['inout_status']) ? '0' : intval($_REQUEST['inout_status']);
        $filter['inout_type'] = empty($_REQUEST['inout_type']) ? '0' : intval($_REQUEST['inout_type']);
        $filter['add_time1'] = empty($_REQUEST['add_time1']) ? '' : (strpos($_REQUEST['add_time1'], '-') > 0 ? local_strtotime($_REQUEST['add_time1']) : $_REQUEST['add_time1']);
        $filter['add_time2'] = empty($_REQUEST['add_time2']) ? '' : (strpos($_REQUEST['add_time2'], '-') > 0 ? local_strtotime($_REQUEST['add_time2']) : $_REQUEST['add_time2']);
        $filter['inout_sn'] = empty($_REQUEST['inout_sn']) ? '' : trim($_REQUEST['inout_sn']);
        $filter['takegoods_man'] = empty($_REQUEST['takegoods_man']) ? '' : trim($_REQUEST['takegoods_man']);
        $filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'rec_id' : trim($_REQUEST['sort_by']);
        $filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
        $where = 'AND store_type_id=0 ';
        if ($filter['ssid']) {
            $where .= " AND store_id = '" . $filter['ssid'] . "' ";
        } else {
            if ($filter['sid']) {
                $where .= " AND store_id in " . get_ssid_list($filter['sid']);
            }
        }
        if ($filter['inout_status']) {
            $where .= " AND inout_status = '" . $filter['inout_status'] . "' ";
        }
        if ($filter['inout_type']) {
            $where .= " AND inout_type = '" . $filter['inout_type'] . "' ";
        }
        if ($filter['add_time1']) {
            $where .= " AND add_time>=  '" . $filter['add_time1'] . "' ";
        }
        if ($filter['add_time2']) {
            $where .= " AND add_time<=  '" . $filter['add_time2'] . "' ";
        }
        if ($filter['inout_sn']) {
            $where .= " AND inout_sn = '" . $filter['inout_sn'] . "' ";
        }
        if ($filter['takegoods_man']) {
            $where .= " AND takegoods_man like '%" . $filter['takegoods_man'] . "%' ";
        }
        //获取当前管理员负责的store_id列表
        $storeid_list = "";
        $sql1 = "select store_id from " . $GLOBALS['ecs']->table('store_adminer') . " where admin_id = '{$_SESSION['admin_id']}' ";
        $res1 = $GLOBALS['db']->query($sql1);
        while ($row1 = $GLOBALS['db']->fetchRow($res1)) {
            $storeid_list .= $storeid_list ? "," : "";
            $storeid_list .= $row1['store_id'];
            $sql2 = "select store_id from " . $GLOBALS['ecs']->table('store_main') . " where parent_id = '{$row1['store_id']}' ";
            $res2 = $GLOBALS['db']->query($sql2);
            while ($row2 = $GLOBALS['db']->fetchRow($res2)) {
                $storeid_list .= $storeid_list ? "," : "";
                $storeid_list .= $row2['store_id'];
            }
        }
        if ($storeid_list) {
            $where .= " AND store_id in ({$storeid_list}) ";
        }
        /* 记录总数 */
        $sql = 'SELECT COUNT(*) FROM ' . $GLOBALS['ecs']->table('store_inout_list') . 'WHERE inout_mode=2 ' . $where;
        $filter['record_count'] = $GLOBALS['db']->getOne($sql);
        $filter = page_and_size($filter);
        /* 获取入库单数据 */
        $sql = 'SELECT *  ' . 'FROM ' . $GLOBALS['ecs']->table('store_inout_list') . 'WHERE inout_mode=2 ' . $where . ' ORDER by ' . $filter['sort_by'] . ' ' . $filter['sort_order'];
        $filter['keyword'] = stripslashes($filter['keyword']);
        set_filter($filter, $sql);
    } else {
        $sql = $result['sql'];
        $filter = $result['filter'];
    }
    $arr = array();
    $res = $GLOBALS['db']->selectLimit($sql, $filter['page_size'], $filter['start']);
    while ($rows = $GLOBALS['db']->fetchRow($res)) {
        $rows['store_name'] = get_store_fullname($rows['store_id']);
        $rows['add_time'] = local_date($GLOBALS['_CFG']['time_format'], $rows['add_time']);
        $rows['inout_status_name'] = $GLOBALS['_LANG']['inout_status'][$rows['inout_status']];
        $rows['inout_type_name'] = get_inout_type_name($rows['inout_type']);
        $rows['admin_name'] = $GLOBALS['db']->getOne("select admin_name from " . $GLOBALS['ecs']->table('store_adminer') . " where store_id='{$rows['store_id']}' ");
        if ($rows['inout_status'] == 1) {
            //是否有提交申请的权利
            $sql_sh = "select rec_id from " . $GLOBALS['ecs']->table('store_adminer') . " where store_id='{$rows['store_id']}' and admin_id='{$_SESSION['admin_id']}' ";
            $rec_id_sh = $GLOBALS['db']->getOne($sql_sh);
            if (!$rec_id_sh) {
                $rows['tjsq'] = 0;
            } else {
                $rows['tjsq'] = 1;
            }
        }
        $arr[] = $rows;
    }
    return array('arr' => $arr, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
}
Пример #3
0
function get_stocklist()
{
    $result = get_filter();
    if ($result === false) {
        $filter = array();
        $filter['sid'] = empty($_REQUEST['sid']) ? '0' : intval($_REQUEST['sid']);
        $filter['ssid'] = empty($_REQUEST['ssid']) ? '0' : intval($_REQUEST['ssid']);
        $filter['goods_sn'] = empty($_REQUEST['goods_sn']) ? '' : trim($_REQUEST['goods_sn']);
        $filter['goods_name'] = empty($_REQUEST['goods_name']) ? '' : trim($_REQUEST['goods_name']);
        $filter['sort_by'] = empty($_REQUEST['sort_by']) ? 's.goods_id' : trim($_REQUEST['sort_by']);
        $filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
        $where = ' AND store_type_id=0 ';
        if (!empty($filter['goods_sn'])) {
            $sql1 = "select goods_id from " . $GLOBALS['ecs']->table('goods') . " where goods_sn like '%{$filter['goods_sn']}%' ";
            $goods_id1 = $GLOBALS['db']->getCol($sql1);
            if (count($goods_id1) > 0) {
                $where .= " AND goods_id in (" . implode(',', $goods_id1) . ")";
            } else {
                $where .= " AND 1!=1 ";
            }
        } elseif (!empty($filter['goods_name'])) {
            $sql1 = "select goods_id from " . $GLOBALS['ecs']->table('goods') . " where goods_name LIKE '%" . mysql_like_quote($filter['goods_name']) . "%' ";
            $res_goods = $GLOBALS['db']->query($sql1);
            $goods_id = "0";
            while ($row_goods = $GLOBALS['db']->fetchRow($res_goods)) {
                $goods_id .= "," . $row_goods['goods_id'];
            }
            $where .= " AND goods_id in ({$goods_id})";
        }
        if ($filter['ssid']) {
            $where .= " AND store_id = '" . $filter['ssid'] . "' ";
        } else {
            if ($filter['sid']) {
                $where .= " AND store_id in " . get_ssid_list($filter['sid']);
            }
        }
        /* 库存总数 */
        $sql = 'select count(*) from (select count(*) from ' . $GLOBALS['ecs']->table('store_goods_stock') . ' WHERE 1 ' . $where . " group by goods_id,store_id) AS countTemp  ";
        $filter['record_count'] = $GLOBALS['db']->getOne($sql);
        $filter = page_and_size($filter);
        /* 获取库存数据 */
        $sql = 'SELECT stock_id, goods_id, store_id  ' . 'FROM ' . $GLOBALS['ecs']->table('store_goods_stock') . ' WHERE 1 ' . $where . ' group by goods_id,store_id  ORDER BY  NULL ';
        $filter['goods_name'] = stripslashes($filter['goods_name']);
        set_filter($filter, $sql);
    } else {
        $sql = $result['sql'];
        $filter = $result['filter'];
    }
    $arr = array();
    $res = $GLOBALS['db']->selectLimit($sql, $filter['page_size'], $filter['start']);
    while ($rows = $GLOBALS['db']->fetchRow($res)) {
        $sql = "select  goods_name, goods_sn, goods_thumb from " . $GLOBALS['ecs']->table('goods') . "  where goods_id='{$rows['goods_id']}' ";
        $goods_row = $GLOBALS['db']->getRow($sql);
        $rows['goods_thumb'] = get_image_path($rows['goods_id'], $goods_row['goods_thumb'], true);
        $rows['goods_name'] = $goods_row['goods_name'];
        $rows['goods_sn'] = $goods_row['goods_sn'];
        $rows['store_name'] = get_store_fullname($rows['store_id']);
        $rows['attr_stock'] = get_attr_stock($rows['goods_id'], $rows['store_id']);
        $arr[] = $rows;
    }
    return array('arr' => $arr, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
}