package com.product.mobile.core.service;
|
|
import java.text.SimpleDateFormat;
|
import java.util.Date;
|
import java.util.HashMap;
|
import java.util.Map;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Component;
|
|
import com.product.common.lang.StringUtils;
|
import com.product.core.config.Global;
|
import com.product.core.dao.BaseDao;
|
import com.product.core.entity.DataTableEntity;
|
import com.product.core.entity.FieldSetEntity;
|
import com.product.core.exception.BaseException;
|
import com.product.core.log.SystemLogger;
|
import com.product.core.service.support.AbstractBaseService;
|
import com.product.core.spring.context.SpringMVCContextHolder;
|
import com.product.mobile.core.config.MobileCoreConst;
|
import com.product.module.sys.entity.SystemUser;
|
import com.product.util.BaseUtil;
|
|
/**
|
* 手机端，获取用户所有应用
|
* @author Administrator
|
*
|
*/
|
@Component
|
public class ContanctOrgListService extends AbstractBaseService{
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); //制定输出格式
|
|
@Autowired
|
public BaseDao baseDao;
|
/**
|
* 先查出历史打卡记录
|
* @param cpage
|
* @param pagesize
|
* @return
|
* @throws BaseException
|
*/
|
public DataTableEntity orgList(FieldSetEntity fse) throws BaseException{
|
SystemUser user=SpringMVCContextHolder.getCurrentUser();
|
boolean all=Global.getPropertyToBoolean("mobile.contanct.org.all", "false").booleanValue();
|
boolean delay=Global.getPropertyToBoolean("mobile.contanct.org.delay", "false").booleanValue();
|
|
String code=user.getCurrentCompany().getString("org_level_code");
|
//公司部门
|
StringBuilder b=new StringBuilder();
|
b.append("select uuid,org_level_name name, org_level_type,org_level_code code,org_level_code_parent,org_level_type type from product_sys_org_levels where org_level_status=0 ");
|
if(!all) {b.append(" and org_level_code like '").append(code).append("%'");}//只加载公司
|
b.append(" order by LENGTH(org_level_code) ,org_level_type");
|
DataTableEntity org=baseDao.listTable(b.toString(), new String[] {});
|
//员工
|
b=new StringBuilder();
|
b.append("select a.uuid,a.tricode code, a.show_name name,a.contact_address,a.sex,b.thumbnail_img,a.job_post_uuid,c.job_post_name post,a.staff_email mail,a.office_telephone tel,a.mobile_phone mobile,2 type,d.org_level_name com from product_sys_staffs a left join product_sys_users b on a.user_id=b.user_id left join product_sys_job_posts c on a.job_post_uuid=c.uuid left join product_sys_org_levels d on a.org_level_uuid=d.uuid where b.status=1 ");
|
|
if(delay) {//延迟回载，只加载当前人所在部门的人员
|
b.append(" and a.tricode like '").append(user.getCurrentDept().getString("org_level_code")).append("%'");
|
}else if(!all) {
|
b.append(" and a.tricode like '").append(code).append("%'");
|
}//只加载公司人员
|
b.append(" order by CONVERT(a.show_name USING gbk) COLLATE gbk_chinese_ci ASC");
|
DataTableEntity staff=baseDao.listTable(b.toString(), new String[] {});
|
|
return parseData(org,staff);
|
}
|
/**
|
* 先查出历史打卡记录
|
* @param cpage
|
* @param pagesize
|
* @return
|
* @throws BaseException
|
*/
|
public DataTableEntity orgList(String orgCode) throws BaseException{
|
SystemUser user=SpringMVCContextHolder.getCurrentUser();
|
if(StringUtils.isEmpty(orgCode) || orgCode.equals(user.getCurrentDept().getString("tricode") ) ) {//当前人部门，也不用传
|
return new DataTableEntity();
|
}
|
//员工
|
StringBuilder b=new StringBuilder();
|
b.append("select a.uuid,a.tricode code, a.show_name name,a.contact_address,a.sex,b.thumbnail_img,a.job_post_uuid,c.job_post_name post,a.staff_email mail,a.office_telephone tel,a.mobile_phone mobile,2 type,d.org_level_name com from product_sys_staffs a left join product_sys_users b on a.user_id=b.user_id left join product_sys_job_posts c on a.job_post_uuid=c.uuid left join product_sys_org_levels d on a.org_level_uuid=d.uuid where b.status=1 ");
|
b.append(" and a.tricode = '").append(orgCode).append("'");
|
DataTableEntity staff=baseDao.listTable(b.toString(), new String[] {});
|
return staff;
|
}
|
/**
|
* 对数据进行封装
|
* @param dt
|
* @return
|
*/
|
private DataTableEntity parseData(DataTableEntity org,DataTableEntity staffs) {
|
Map <String,FieldSetEntity> mf=new HashMap<>();
|
DataTableEntity pdt=new DataTableEntity();
|
for(int i=0;i<org.getRows();i++) {
|
FieldSetEntity f=org.getFieldSetEntity(i);
|
f.setTableName("sub");
|
FieldSetEntity pf=mf.get(f.getObject("org_level_code_parent"));
|
mf.put(f.getString("code"), f);
|
if(pf==null) {
|
f.setValue("grade",0);
|
pdt.addFieldSetEntity(f);
|
}else {
|
f.setValue("grade",pf.getInteger("grade").intValue()+1);
|
DataTableEntity sub=pf.getSubDataTable("sub");
|
if(DataTableEntity.isEmpty(sub)) {
|
sub=new DataTableEntity();
|
sub.setMeta(f.getMeta());
|
pf.addSubDataTable(sub);
|
}
|
sub.addFieldSetEntity(f);
|
}
|
}
|
for(int i=0;i<staffs.getRows();i++) {
|
FieldSetEntity f=staffs.getFieldSetEntity(i);
|
f.setTableName("sub");
|
String code=f.getString("code");
|
if(code ==null) {
|
continue;
|
}
|
int c=code.lastIndexOf('-');
|
if(c>0) {
|
FieldSetEntity pf=mf.get(code.substring(0,c));
|
if(pf==null) {
|
SpringMVCContextHolder.getSystemLogger().error("员工编码错误："+f.getString("show_name")+"找不到所属部门");
|
}else {
|
f.setValue("dept",pf.getString("name"));
|
f.setValue("grade",pf.getInteger("grade").intValue()+1);
|
DataTableEntity sub=pf.getSubDataTable("sub");
|
if(DataTableEntity.isEmpty(sub)) {
|
sub=new DataTableEntity();
|
sub.setMeta(f.getMeta());
|
pf.addSubDataTable(sub);
|
}
|
sub.addFieldSetEntity(f);
|
}
|
}
|
|
}
|
|
return pdt;
|
}
|
}
|
