public static function getUserAreas($uid = 0)
{
if (!$uid) {
$uid = 0;
}
$sql = "select a.areaId, b.areaName from wh_wave_area_user_relation a \n\t\t\t\tleft join wh_wave_area_info b ON(a.areaId=b.id AND b.is_delete=0)\n\t\t\t\twhere a.userId='{$uid}' AND a.is_delete=0 group by b.id";
$list = WhWaveAreaUserRelationModel::query($sql);
return $list ? $list : array();
}
foreach ($wave_info as $key => $wave) {
$receive_info = array();
//区域路由
/*$receive_area = WhWaveReceiveRecordModel::select(array('waveId'=>$wave['id'], 'order by'=> 'id asc'), 'area');
if(!empty($receive_area)){
foreach($receive_area as $v){
$receive_info .= " {$v['area']} =>";
}
$receive_info = trim($receive_info, '=>');
}*/
$page_num = 35;
$scan_record = WhWaveScanRecordModel::get_scan_record_union_area($wave['id']);
//获取配货记录及区域负责人id
//print_r($scan_record);exit;
$area_info = array_unique(get_filed_array('area', $scan_record));
$area_user = WhWaveAreaUserRelationModel::get_user_by_areaName($area_info);
$area_user = reverse_array($area_user, 'user', 'area');
$note = '';
/** 获取单发货单配货备注**/
if ($wave['waveType'] == 1) {
$note = WhShippingOrderNoteRecordModel::get_order_note_by_waveId($wave['id']);
if (!empty($note)) {
$note = get_filed_array('content', $note);
$note = implode("<br />", $note);
} else {
$note = '';
}
}
/** **/
//print_r($area_info);exit;
$receive_info = implode(' =>', $area_info);
private function getUserAreaList($uid)
{
$areas = array();
$arealist = WhWaveAreaUserRelationModel::getUserAreas($uid);
if ($arealist) {
foreach ($arealist as $val) {
$areas[] = $val['areaName'];
}
}
return $areas;
}
/**
* WaveInfoManageView::get_search_where()
* 处理配货单搜索条件
* @author Gary
* @return void
*/
private function get_search_where()
{
$areaUser = trim($_GET['areaUser']) ? intval(trim($_GET['areaUser'])) : '';
//区域负责人
$shipOrderId = trim($_GET['shipOrderId']) ? intval(trim($_GET['shipOrderId'])) : '';
//发货单ID
$waveType = trim($_GET['waveType']) ? intval(trim($_GET['waveType'])) : '';
//配货单类型
$waveZone = trim($_GET['waveZone']) ? intval(trim($_GET['waveZone'])) : '';
//配货单区域类型
$storey = isset($_REQUEST['storey']) ? intval(trim($_REQUEST['storey'])) : '';
//配货单打印楼层
$choose_area = trim($_GET['choose_area']);
//选择的区域
$waveStatus = trim($_GET['waveStatus']);
//配货单状态
$waveNumber = trim($_GET['waveNumber']);
//配货单编号
$startdate = trim($_GET['startdate']);
//开始日期
$enddate = trim($_GET['enddate']);
//结束日日
foreach ($_GET as $key => $v) {
//传递搜索条件到配货单管理页面
$this->smarty->assign($key, ${$key});
}
//print_r($choose_area);exit;
$searchArr = array();
$areas = array();
//区域集合
$wave_ids = array();
//配货单ID数组
if ($choose_area) {
$areas[] = $choose_area;
}
if ($areaUser) {
//区域负责人
$areaId = WhWaveAreaUserRelationModel::select(array('userId' => $areaUser, 'is_delete' => 0), 'areaId');
if (!empty($areaId)) {
$areaName = WhWaveAreaInfoModel::get_area_info('areaName', $areaId[0]['areaId']);
if (!empty($areaName)) {
$areas[] = $areaName[0]['areaName'];
}
}
}
if ($waveNumber) {
$wave_id = WhBaseModel::number_decode($waveNumber);
//获取配货单ID
$wave_ids[] = $wave_id;
}
if ($startdate) {
$searchArr['a.createTime >='] = strtotime($startdate);
}
if ($enddate) {
$searchArr['a.createTime <='] = strtotime($enddate);
}
if ($shipOrderId) {
$ids = WhWaveShippingRelationModel::select(array('shipOrderId' => $shipOrderId, 'is_delete' => 0), 'waveId');
$tmp_ids = array();
if (!empty($ids)) {
foreach ($ids as $val) {
$tmp_ids[] = $val['waveId'];
}
} else {
$tmp_ids[] = 0;
}
if (!empty($wave_ids)) {
$wave_ids = array_intersect($wave_ids, $tmp_ids);
$wave_ids = empty($wave_ids) ? array(0) : $wave_ids;
} else {
$wave_ids = $tmp_ids;
}
}
if ($waveStatus) {
$searchArr['a.waveStatus'] = $waveStatus;
}
if ($waveType) {
$searchArr['a.waveType'] = $waveType;
}
if ($waveZone) {
$searchArr['a.waveZone'] = $waveZone;
}
if (!empty($areas)) {
$searchArr['c.area in'] = array_unique($areas);
}
if (!empty($wave_ids)) {
$searchArr['a.id in'] = array_unique($wave_ids);
}
if ($storey) {
$searchArr['a.printStorey'] = $storey;
}
$searchArr['a.waveStatus !='] = 0;
$searchArr['a.createUserId !='] = 0;
$searchArr['a.is_delete'] = 0;
$searchArr['group by'] = 'a.id';
return $searchArr;
}
