/**
* @Title: WarehouseService.java
* @Package com.glacier.frame.service.basicdatas
* @author junjie.zheng
* @email 1203807137@qq.com
* @date 2015-1-13 下午2:19:54
* @company (开发公司) 珠海市冰川软件有限公司
* @copyright (版权) 本文件归属珠海市冰川软件有限公司所有
* @version V1.0
* @modify (修改)
* <p>
第一次修改：
时间：2015-1-13
修改人：xichao.dong
修改内容简介 ：
</p>
* @Review (审核人) ：xichao.dong
*
*/
package com.glacier.frame.service.basicdatas;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.apache.commons.lang3.StringUtils;
import org.apache.shiro.SecurityUtils;
import org.apache.shiro.subject.Subject;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
import com.glacier.basic.util.JackJson;
import com.glacier.basic.util.RandomGUID;
import com.glacier.frame.dao.basicdatas.ParWarGoodsTypeMapper;
import com.glacier.frame.dao.basicdatas.WarehouseMapper;
import com.glacier.frame.dao.basicdatas.ParWarGoodsClassifyMapper;
import com.glacier.frame.dto.query.basicdatas.WarehouseQueryDTO;
import com.glacier.frame.entity.basicdatas.ParWarGoodsClassifyExample;
import com.glacier.frame.entity.basicdatas.ParWarGoodsTypeExample;
import com.glacier.frame.entity.basicdatas.Warehouse;
import com.glacier.frame.entity.basicdatas.ParWarGoodsType;
import com.glacier.frame.entity.basicdatas.ParWarGoodsClassify;
import com.glacier.frame.entity.basicdatas.WarehouseExample;
import com.glacier.frame.entity.basicdatas.WarehouseExample.Criteria;
import com.glacier.frame.entity.system.User;
import com.glacier.frame.util.MethodLog;
import com.glacier.jqueryui.util.JqGridReturn;
import com.glacier.jqueryui.util.JqPager;
import com.glacier.jqueryui.util.JqReturnJson;
/**
* @ClassName: WarehouseService
* @Description: TODO(仓库信息业务层)
* @author junjie.zheng
* @email 1203807137@qq.com
* @date 2015-1-13 下午2:19:54
*/
@Service
@Transactional(readOnly=true,propagation = Propagation.REQUIRED)
public class WarehouseService {
@Autowired
private WarehouseMapper warehouseMapper;
@Autowired
private ParWarGoodsTypeMapper warGoodsTypeMapper;
@Autowired
private ParWarGoodsClassifyMapper warGoodsClassifyMapper;
/**
* @Title: listAsGrid
* @Description: TODO(获取所有仓库信息)
* @param @param pager
* @param @return 设定文件
* @return Object 返回类型
* @throws
*/
public Object listAsGrid(JqPager jqPager,WarehouseQueryDTO warehouseQueryDTO) {
JqGridReturn returnResult = new JqGridReturn();
WarehouseExample warehouseExample = new WarehouseExample();
Criteria queryCriteria = warehouseExample.createCriteria();
warehouseQueryDTO.setQueryCondition(queryCriteria);
if (null != jqPager.getPage() && null != jqPager.getRows()) {// 设置排序信息
warehouseExample.setLimitStart((jqPager.getPage() - 1)* jqPager.getRows());
warehouseExample.setLimitEnd(jqPager.getRows());
}
if (StringUtils.isNotBlank(jqPager.getSort())&& StringUtils.isNotBlank(jqPager.getOrder())) {// 设置排序信息
warehouseExample.setOrderByClause(jqPager.getOrderBy("temp_warehouse_"));
}
List<Warehouse> warehouse = warehouseMapper.selectByExample(warehouseExample); // 查询所有仓库信息列表
int total = warehouseMapper.countByExample(warehouseExample); // 查询总页数
returnResult.setRows(warehouse);
returnResult.setTotal(total);
return returnResult;// 返回ExtGrid表
}
/**
* @Title: listAsGoodsClassify
* @Description: TODO(获取仓库信息对象)
* @param @param goodsId
* @param @return 设定文件
* @return Object 返回类型
* @throws
*/
public Object listAsGoodsClassify(String warehouseId) {
ParWarGoodsClassifyExample warGoodsClassifyExample = new ParWarGoodsClassifyExample();
warGoodsClassifyExample.createCriteria().andWarehouseIdEqualTo(warehouseId);
List<ParWarGoodsClassify> list=warGoodsClassifyMapper.selectByExample(warGoodsClassifyExample);
return JackJson.fromObjectToJson(list);
}
/**
* @Title: listWarehouse
* @Description: TODO(获取特定类型下仓库信息)
* @param @param warehouseTypeId
* @param @return 设定文件
* @return Object 返回类型
* @throws
*/
public Object listWarehouse(String warehouseTypeId){
//获取特定类型下仓库ID
ParWarGoodsClassifyExample warGoodsClassifyExample = new ParWarGoodsClassifyExample();
warGoodsClassifyExample.createCriteria().andWarGoodsTypeIdEqualTo(warehouseTypeId);
List<ParWarGoodsClassify> listWarGoodsClassify=warGoodsClassifyMapper.selectByExample(warGoodsClassifyExample);
List<Warehouse> Warehouse=new ArrayList<Warehouse>();
List<String> listId=new ArrayList<String>();
if(listWarGoodsClassify.size()>0){
for(int i=0;i<listWarGoodsClassify.size();i++){
listId.add(listWarGoodsClassify.get(i).getWarehouseId());
}
WarehouseExample warehouseExample = new WarehouseExample();
warehouseExample.createCriteria().andWarehouseIdIn(listId);
Warehouse=warehouseMapper.selectByExample(warehouseExample);
}
return JackJson.fromObjectToJson(Warehouse);
}
/**
* @Title: getWareHouseCombo
* @Description: TODO(仓库下拉项)
* @param @return 设定文件
* @return Object 返回类型
* @throws
*/
public Object getWareHouseCombo(){
WarehouseExample warehouseExample = new WarehouseExample();
warehouseExample.createCriteria().andEnabledEqualTo("enable");
List<Warehouse> list=warehouseMapper.selectByExample(warehouseExample);
return JackJson.fromObjectToJson(list);
}
/**
* @Title: getWarehouse
* @Description: TODO(获取仓库信息对象)
* @param @param goodsId
* @param @return 设定文件
* @return Object 返回类型
* @throws
*/
public Object getWarehouse(String warehouseId) {
Warehouse warehouse = warehouseMapper.selectByPrimaryKey(warehouseId);
return warehouse;
}
/**
* @Title: getWarehouseGoodsDetail
* @Description: TODO(获取仓库货品类型信息)
* @param @param goodsId
* @param @return 设定文件
* @return Object 返回类型
* @throws
*/
public Object getWarehouseGoodsDetail(String warehouseId) {
ParWarGoodsClassifyExample warGoodsClassifyExample = new ParWarGoodsClassifyExample();
warGoodsClassifyExample.createCriteria().andWarehouseIdEqualTo(warehouseId);
List<ParWarGoodsClassify> listWarGoodsClassify=warGoodsClassifyMapper.selectByExample(warGoodsClassifyExample);
List<String> listId=new ArrayList<String>();
for(int i=0;i<listWarGoodsClassify.size();i++){
listId.add(listWarGoodsClassify.get(i).getWarGoodsTypeId());
}
ParWarGoodsTypeExample warGoodsTypeExample=new ParWarGoodsTypeExample();
warGoodsTypeExample.createCriteria().andWarGoodsTypeIdIn(listId);
List<ParWarGoodsType> listParWarGoodsType=warGoodsTypeMapper.selectByExample(warGoodsTypeExample);
return JackJson.fromObjectToJson(listParWarGoodsType);
}
/**
* @Title: addWarehouse
* @Description: TODO(新增仓库信息)
* @param @param warehouse
* @param @return 设定文件
* @return Object 返回类型
* @throws
*/
@Transactional(readOnly = false)
@MethodLog(opera = "Warehouse_add")
public Object addWarehouse(Warehouse warehouse,String[] warehouseTypeName) {
Subject pricipalSubject = SecurityUtils.getSubject();
User pricipalUser = (User) pricipalSubject.getPrincipal();
JqReturnJson returnResult = new JqReturnJson();// 构建返回结果，默认结果为false
WarehouseExample warehouseExample = new WarehouseExample();
int count = 0;
//防止仓库类型未赋值
if(warehouseTypeName.length<=0){
returnResult.setMsg("仓库类型为空,请选择仓库类型!");
returnResult.setSuccess(false);
return returnResult;
}
// 防止仓库名称重复
warehouseExample.createCriteria().andWarehouseNameEqualTo(warehouse.getWarehouseName());
count = warehouseMapper.countByExample(warehouseExample);
if (count > 0) {
returnResult.setMsg("仓库名称信息重复,请重新填写!");
returnResult.setSuccess(false);
return returnResult;
}
//随机号生成
SimpleDateFormat SF=new SimpleDateFormat("yyyy-MM-DD-HHmmss");
//仓库信息赋值
warehouse.setWarehouseId(RandomGUID.getRandomGUID());
warehouse.setWarehouseCode("WH_"+SF.format(new Date()));
warehouse.setEnabled("enable");
warehouse.setCreater(pricipalUser.getUserCnName());
warehouse.setCreateTime(new Date());
warehouse.setUpdater(pricipalUser.getUserCnName());
warehouse.setUpdateTime(new Date());
count = warehouseMapper.insert(warehouse);
//仓库信息主键
String id=warehouse.getWarehouseId();
//类型信息赋值
for(int i=0;i<warehouseTypeName.length;i++){
ParWarGoodsClassify warGoodsClassify=new ParWarGoodsClassify();
warGoodsClassify.setWarehouseClassifyId(RandomGUID.getRandomGUID());
warGoodsClassify.setWarehouseId(id);
warGoodsClassify.setWarGoodsTypeId(warehouseTypeName[i]);
warGoodsClassifyMapper.insert(warGoodsClassify);
}
if (count == 1) {
returnResult.setSuccess(true);
returnResult.setMsg("【" + warehouse.getWarehouseName()+ "】仓库信息已保存");
} else {
returnResult.setMsg("发生未知错误，仓库信息保存失败");
}
return returnResult;
}
/**
* @Title: editWarehouse
* @Description: TODO(修改仓库信息)
* @param @param warehouse
* @param @return 设定文件
* @return Object 返回类型
* @throws
*/
@Transactional(readOnly = false)
@MethodLog(opera = "Warehouse_edit")
public Object editWarehouse(Warehouse warehouse,String[] warehouseTypeName) {
Subject pricipalSubject = SecurityUtils.getSubject();
User pricipalUser = (User) pricipalSubject.getPrincipal();
JqReturnJson returnResult = new JqReturnJson();// 构建返回结果，默认结果为false
int count = 0;
// 防止仓库名称重复
WarehouseExample warehouseExample = new WarehouseExample();
warehouseExample.createCriteria().andWarehouseNameEqualTo(warehouse.getWarehouseName()).andWarehouseIdNotEqualTo(warehouse.getWarehouseId());
count = warehouseMapper.countByExample(warehouseExample);
if (count > 0) {
returnResult.setMsg("仓库名称信息重复,请重新填写!");
returnResult.setSuccess(false);
return returnResult;
}
warehouse.setUpdater(pricipalUser.getUserCnName());
warehouse.setUpdateTime(new Date());
count = warehouseMapper.updateByPrimaryKeySelective(warehouse);
//修改仓库货品类型
if(warehouseTypeName.length>0){
ParWarGoodsClassifyExample warGoodsClassifyExample=new ParWarGoodsClassifyExample();
warGoodsClassifyExample.createCriteria().andWarehouseIdEqualTo(warehouse.getWarehouseId());
int num=warGoodsClassifyMapper.deleteByExample(warGoodsClassifyExample);
if(num>0){
for(int i=0;i<warehouseTypeName.length;i++){
ParWarGoodsClassify warGoodsClassify_Add=new ParWarGoodsClassify();
warGoodsClassify_Add.setWarehouseClassifyId(RandomGUID.getRandomGUID());
warGoodsClassify_Add.setWarehouseId(warehouse.getWarehouseId());
warGoodsClassify_Add.setWarGoodsTypeId(warehouseTypeName[i]);
warGoodsClassifyMapper.insert(warGoodsClassify_Add);
}
}
}else{
returnResult.setMsg("仓库货品分类不允许为空!");
returnResult.setSuccess(false);
return returnResult;
}
//判断结果集
if (count == 1) {
returnResult.setSuccess(true);
returnResult.setMsg("【" + warehouse.getWarehouseName()+ "】仓库信息已保存");
} else {
returnResult.setMsg("发生未知错误，仓库保存失败");
}
return returnResult;
}
/**
* @Title: delWarehouse
* @Description: TODO(删除仓库信息)
* @param @param warehouseIds
* @param @return 设定文件
* @return Object 返回类型
* @throws
*/
@Transactional(readOnly = false)
@MethodLog(opera = "Warehouse_del")
public Object delWarehouse(List<String> warehouseIds) {
JqReturnJson returnResult = new JqReturnJson();// 构建返回结果，默认结果为false
int count = 0;
if (warehouseIds.size() > 0) {
WarehouseExample warehouseExample = new WarehouseExample();
warehouseExample.createCriteria().andWarehouseIdIn(warehouseIds);
count = warehouseMapper.deleteByExample(warehouseExample);
if (count > 0) {
returnResult.setSuccess(true);
returnResult.setMsg("成功删除了【 " + count+ " 】条仓库信息");
} else {
returnResult.setMsg("发生未知错误，仓库信息删除失败");
}
}
return returnResult;
}
}