if(isset($_GET['sotring'])){
if($_GET['sotring'] == 'by_alphabet')$order = array ('nickName','ASC');
if($_GET['sotring'] == 'by_creating_date')$order = array ('id','ASC');
}
elseif(isset($_POST['search_client'])) $order = array ('search',$_POST['search_client']);
else $order = array('nickName','ASC');
$filters = array();
if(isset($_GET['filter_by_rating']) && $_GET['filter_by_rating']) $filters[] = array ('type' =>'by_rating','val' => $_GET['filter_by_rating']);
if(isset($_GET['filter_by_letter']) && $_GET['filter_by_letter']) $filters[] = array ('type' =>'by_letter','col' =>'nickName','val' => $_GET['filter_by_letter']);
if(isset($_GET['filter_by_profies']) && $_GET['filter_by_profies']) $filters[] = array ('type' =>'by_profies','val' => $_GET['filter_by_profies']);
$range = isset($_GET['filter_by_cities'])? array ('by' =>'cities','val' => $_GET['filter_by_cities']):false;
$suppliers_data = get_suppliers_list($range,$order,$filters,$search,false/*$limit_str*/);
/*echo '<pre>';
print_r($suppliers_data);
echo '</pre>';*/
$file_prefix = ($curViewType == 'ordinary' || $curViewType == 'short')? 'ordinary':$curViewType;
//$tpl_name = './skins/tpl/clients/client_list/'.$curViewType.'_row.tpl';
$tpl_name = './skins/tpl/suppliers/suppliers_list/'.$file_prefix.'_row.tpl';
$fd = fopen($tpl_name,'r');
$tpl = fread($fd,filesize($tpl_name));
fclose($fd);
ob_start();
if(is_array($suppliers_data)){
/**
* 获取发货单列表信息
*
* @access public
* @param
*
* @return void
*/
function delivery_list()
{
$result = get_filter();
if ($result === false) {
$aiax = isset($_GET['is_ajax']) ? $_GET['is_ajax'] : 0;
/* 过滤信息 */
$filter['delivery_sn'] = empty($_REQUEST['delivery_sn']) ? '' : trim($_REQUEST['delivery_sn']);
$filter['order_sn'] = empty($_REQUEST['order_sn']) ? '' : trim($_REQUEST['order_sn']);
$filter['order_id'] = empty($_REQUEST['order_id']) ? 0 : intval($_REQUEST['order_id']);
if ($aiax == 1 && !empty($_REQUEST['consignee'])) {
$_REQUEST['consignee'] = json_str_iconv($_REQUEST['consignee']);
}
$filter['consignee'] = empty($_REQUEST['consignee']) ? '' : trim($_REQUEST['consignee']);
$filter['status'] = isset($_REQUEST['status']) ? $_REQUEST['status'] : -1;
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'update_time' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$where = 'WHERE 1 ';
if ($filter['order_sn']) {
$where .= " AND order_sn LIKE '%" . mysql_like_quote($filter['order_sn']) . "%'";
}
if ($filter['consignee']) {
$where .= " AND consignee LIKE '%" . mysql_like_quote($filter['consignee']) . "%'";
}
if ($filter['status'] >= 0) {
$where .= " AND status = '" . mysql_like_quote($filter['status']) . "'";
}
if ($filter['delivery_sn']) {
$where .= " AND delivery_sn LIKE '%" . mysql_like_quote($filter['delivery_sn']) . "%'";
}
/* 获取管理员信息 */
$admin_info = admin_info();
/* 如果管理员属于某个办事处，只列出这个办事处管辖的发货单 */
if ($admin_info['agency_id'] > 0) {
$where .= " AND agency_id = '" . $admin_info['agency_id'] . "' ";
}
/* 如果管理员属于某个供货商，只列出这个供货商的发货单 */
if ($admin_info['suppliers_id'] > 0) {
$where .= " AND suppliers_id = '" . $admin_info['suppliers_id'] . "' ";
}
/* 分页大小 */
$filter['page'] = empty($_REQUEST['page']) || intval($_REQUEST['page']) <= 0 ? 1 : intval($_REQUEST['page']);
if (isset($_REQUEST['page_size']) && intval($_REQUEST['page_size']) > 0) {
$filter['page_size'] = intval($_REQUEST['page_size']);
} elseif (isset($_COOKIE['ECSCP']['page_size']) && intval($_COOKIE['ECSCP']['page_size']) > 0) {
$filter['page_size'] = intval($_COOKIE['ECSCP']['page_size']);
} else {
$filter['page_size'] = 15;
}
/* 记录总数 */
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('delivery_order') . $where;
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
$filter['page_count'] = $filter['record_count'] > 0 ? ceil($filter['record_count'] / $filter['page_size']) : 1;
/* 查询 */
$sql = "SELECT delivery_id, delivery_sn, order_sn, order_id, add_time, action_user, consignee, country,\n province, city, district, tel, status, update_time, email, suppliers_id\n FROM " . $GLOBALS['ecs']->table("delivery_order") . "\n {$where}\n ORDER BY " . $filter['sort_by'] . " " . $filter['sort_order'] . "\n LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ", " . $filter['page_size'] . " ";
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
/* 获取供货商列表 */
$suppliers_list = get_suppliers_list();
$_suppliers_list = array();
foreach ($suppliers_list as $value) {
$_suppliers_list[$value['suppliers_id']] = $value['suppliers_name'];
}
$row = $GLOBALS['db']->getAll($sql);
/* 格式化数据 */
foreach ($row as $key => $value) {
$row[$key]['add_time'] = local_date($GLOBALS['_CFG']['time_format'], $value['add_time']);
$row[$key]['update_time'] = local_date($GLOBALS['_CFG']['time_format'], $value['update_time']);
if ($value['status'] == 1) {
$row[$key]['status_name'] = $GLOBALS['_LANG']['delivery_status'][1];
} elseif ($value['status'] == 2) {
$row[$key]['status_name'] = $GLOBALS['_LANG']['delivery_status'][2];
} else {
$row[$key]['status_name'] = $GLOBALS['_LANG']['delivery_status'][0];
}
$row[$key]['suppliers_name'] = isset($_suppliers_list[$value['suppliers_id']]) ? $_suppliers_list[$value['suppliers_id']] : '';
}
$arr = array('delivery' => $row, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}
/**
* 获取发货单列表信息
*
* @access public
* @param
*
* @return void
*/
function delivery_list()
{
$result = get_filter();
if ($result === false) {
$aiax = isset($_GET['is_ajax']) ? $_GET['is_ajax'] : 0;
/* 过滤信息 */
/* 代码增加_start By morestock_morecity */
$filter['sid'] = empty($_REQUEST['sid']) ? '0' : intval($_REQUEST['sid']);
$filter['ssid'] = empty($_REQUEST['ssid']) ? '0' : intval($_REQUEST['ssid']);
/* 代码增加_end By morestock_morecity */
$filter['delivery_sn'] = empty($_REQUEST['delivery_sn']) ? '' : trim($_REQUEST['delivery_sn']);
$filter['order_sn'] = empty($_REQUEST['order_sn']) ? '' : trim($_REQUEST['order_sn']);
$filter['order_id'] = empty($_REQUEST['order_id']) ? 0 : intval($_REQUEST['order_id']);
if ($aiax == 1 && !empty($_REQUEST['consignee'])) {
$_REQUEST['consignee'] = json_str_iconv($_REQUEST['consignee']);
}
$filter['consignee'] = empty($_REQUEST['consignee']) ? '' : trim($_REQUEST['consignee']);
$filter['status'] = isset($_REQUEST['status']) ? $_REQUEST['status'] : -1;
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'do.update_time' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$where = "where 1";
//判断是否是查询过来的
if (isset($_REQUEST['search']) && $_REQUEST['search']) {
$search = true;
} else {
$search = false;
}
/* 代码增加_start By morestock_morecity */
if ($filter['ssid']) {
$where .= " AND o.sub_id like '%|" . $filter['ssid'] . "|%' ";
} else {
if ($filter['sid']) {
$where .= " AND o.store_id = '" . $filter['sid'] . "' ";
}
}
//获取当前管理员负责的store_id列表
if ($search) {
//如果是查看自己的订单，就获取仓库列表
$storeid_list = "";
if ($_SESSION['action_list'] == 'all') {
//自营超级管理员，可以查看所有
$sql2 = "select store_id from " . $GLOBALS['ecs']->table('store_main') . " where supplier_id=0 and parent_id > 0";
$res2 = $GLOBALS['db']->query($sql2);
while ($row2 = $GLOBALS['db']->fetchRow($res2)) {
$storeid_list .= $storeid_list ? " or " : "";
$storeid_list .= " sub_id like '%|" . $row2['store_id'] . "|%' ";
}
} else {
$sql1 = "select store_id from " . $GLOBALS['ecs']->table('store_adminer') . " where supplier_id=0 and admin_id = " . $_SESSION['admin_id'];
$res1 = $GLOBALS['db']->query($sql1);
while ($row1 = $GLOBALS['db']->fetchRow($res1)) {
$storeid_list .= $storeid_list ? " or " : "";
$storeid_list .= " sub_id like '%|" . $row1['store_id'] . "|%' ";
$sql2 = "select store_id from " . $GLOBALS['ecs']->table('store_main') . " where supplier_id=0 and parent_id = '{$row1['store_id']}' ";
$res2 = $GLOBALS['db']->query($sql2);
while ($row2 = $GLOBALS['db']->fetchRow($res2)) {
$storeid_list .= $storeid_list ? " or " : "";
$storeid_list .= " sub_id like '%|" . $row2['store_id'] . "|%' ";
}
}
}
if ($storeid_list) {
$where .= " AND ({$storeid_list}) ";
}
}
/* 代码增加_end By morestock_morecity */
if ($filter['order_sn']) {
$where .= " AND do.order_sn LIKE '%" . mysql_like_quote($filter['order_sn']) . "%'";
}
if ($filter['consignee']) {
$where .= " AND do.consignee LIKE '%" . mysql_like_quote($filter['consignee']) . "%'";
}
if ($filter['status'] >= 0) {
$where .= " AND do.status = '" . mysql_like_quote($filter['status']) . "'";
}
if ($filter['delivery_sn']) {
$where .= " AND do.delivery_sn LIKE '%" . mysql_like_quote($filter['delivery_sn']) . "%'";
}
/* 获取管理员信息 */
$admin_info = admin_info();
/* 如果管理员属于某个办事处，只列出这个办事处管辖的发货单 */
if ($admin_info['agency_id'] > 0) {
$where .= " AND do.agency_id = '" . $admin_info['agency_id'] . "' ";
}
/* 如果管理员属于某个供货商，只列出这个供货商的发货单 */
if ($admin_info['suppliers_id'] > 0) {
$where .= " AND do.suppliers_id = '" . $admin_info['suppliers_id'] . "' ";
}
/* 分页大小 */
$filter['page'] = empty($_REQUEST['page']) || intval($_REQUEST['page']) <= 0 ? 1 : intval($_REQUEST['page']);
if (isset($_REQUEST['page_size']) && intval($_REQUEST['page_size']) > 0) {
$filter['page_size'] = intval($_REQUEST['page_size']);
} elseif (isset($_COOKIE['ECSCP']['page_size']) && intval($_COOKIE['ECSCP']['page_size']) > 0) {
$filter['page_size'] = intval($_COOKIE['ECSCP']['page_size']);
} else {
$filter['page_size'] = 15;
}
$where .= " AND do.order_id=o.order_id ";
/* 记录总数 */
$sql = "SELECT COUNT(do.delivery_id) FROM " . $GLOBALS['ecs']->table('delivery_order') . " as do," . $GLOBALS['ecs']->table('order_info') . " as o " . $where;
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
$filter['page_count'] = $filter['record_count'] > 0 ? ceil($filter['record_count'] / $filter['page_size']) : 1;
/* 查询 */
$sql = "SELECT do.delivery_id, do.delivery_sn, do.order_sn, do.order_id, do.add_time, do.action_user, do.consignee, do.country,\n do.province, do.city, do.district, do.tel, do.status, do.update_time, do.email, do.suppliers_id\n FROM " . $GLOBALS['ecs']->table("delivery_order") . "as do," . $GLOBALS['ecs']->table("order_info") . " as o \n {$where} \n ORDER BY " . $filter['sort_by'] . " " . $filter['sort_order'] . "\n LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ", " . $filter['page_size'] . " ";
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
/* 获取供货商列表 */
$suppliers_list = get_suppliers_list();
$_suppliers_list = array();
foreach ($suppliers_list as $value) {
$_suppliers_list[$value['suppliers_id']] = $value['suppliers_name'];
}
$row = $GLOBALS['db']->getAll($sql);
/* 格式化数据 */
foreach ($row as $key => $value) {
$row[$key]['add_time'] = local_date($GLOBALS['_CFG']['time_format'], $value['add_time']);
$row[$key]['update_time'] = local_date($GLOBALS['_CFG']['time_format'], $value['update_time']);
if ($value['status'] == 1) {
$row[$key]['status_name'] = $GLOBALS['_LANG']['delivery_status'][1];
} elseif ($value['status'] == 2) {
$row[$key]['status_name'] = $GLOBALS['_LANG']['delivery_status'][2];
} else {
$row[$key]['status_name'] = $GLOBALS['_LANG']['delivery_status'][0];
}
$row[$key]['suppliers_name'] = isset($_suppliers_list[$value['suppliers_id']]) ? $_suppliers_list[$value['suppliers_id']] : '';
}
$arr = array('delivery' => $row, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}
