package com.product.mobile.core.service;
|
|
import com.product.common.lang.StringUtils;
|
import com.product.core.config.CoreConst;
|
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.service.support.AbstractBaseService;
|
import com.product.mobile.core.config.MobileCoreCode;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Component;
|
|
import java.text.SimpleDateFormat;
|
|
/**
|
* 手机端，获取用户所有应用
|
* @author Administrator
|
*
|
*/
|
@Component
|
public class CommonMVCService extends AbstractBaseService{
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); //制定输出格式
|
|
@Autowired
|
public BaseDao baseDao;
|
/**
|
* 查询数据数据是否有走审批流程
|
* @param table
|
* @param uuid
|
*/
|
public String getApproveDetailUUID(String table,String uuid) {
|
|
DataTableEntity dt = getBaseDao().listTable("product_sys_flow_detail", " record_uuid=? and table_name=? ",new Object[]{uuid,table});
|
if(dt.isEmpty()) {
|
return null;
|
}else {
|
return dt.getFieldSetEntity(0).getUUID();
|
}
|
}
|
/**
|
* 查出MVC中按钮操作的界面，界面后面的所有按钮
|
* @param button 有可能是类型，有可能是uuid
|
* @param table
|
* @param functionUuid
|
* @return
|
* @throws BaseException
|
*/
|
public FieldSetEntity getPageButtons(FieldSetEntity fse) throws BaseException{
|
|
String buttonUuid=fse.getString("buttonUuid");
|
|
String table=fse.getString(CoreConst.SYSTEM_TABLE_NAME_LABEL);
|
if(table==null) table=fse.getTableName();
|
String functionUuid=fse.getString("functionUuid");
|
String buttonType=fse.getString("buttonType");
|
if(StringUtils.isEmpty(functionUuid) && !StringUtils.isEmpty(table)) {
|
///根据表去查功能，如有多个，取第一个
|
FieldSetEntity f=baseDao.getFieldSetByFilter("product_sys_functions", "table_uuid=(select uuid from product_sys_datamodel_table where table_name=?) or table_uuid=? ", new String[] {table,table}, false);
|
if(!FieldSetEntity.isEmpty(f)) {
|
functionUuid=f.getUUID();
|
}
|
}
|
FieldSetEntity page=null;
|
|
if(!StringUtils.isEmpty(functionUuid)) {
|
//根据按钮类型查出按钮uuid
|
if(StringUtils.isEmpty(buttonUuid)&& !StringUtils.isEmpty(buttonType) ) {
|
DataTableEntity d=baseDao.listTable("product_sys_function_buttons", " function_uuid=? and button_category_uuid=? ", new String[] {functionUuid,buttonType},"button_type");
|
if(!DataTableEntity.isEmpty(d)) {
|
buttonUuid=d.getFieldSetEntity(0).getUUID();//取第一条
|
}
|
}
|
//查出按钮对应界面，可能按钮有多个，取第一个
|
if(!StringUtils.isEmpty(buttonUuid)) {
|
StringBuilder b=new StringBuilder();
|
b.append("select * from product_sys_mvc_page where function_uuid=? and uuid in (\r\n")
|
.append("select line_to from product_sys_link where function_uuid=? and line_from=?\r\n")
|
.append(" union all ")
|
.append("select line_to from product_sys_link where function_uuid=? and line_from=\r\n")
|
.append(" (select line_to mainUuid from product_sys_link where function_uuid=? and line_from=?) ")
|
.append(")");
|
DataTableEntity d=baseDao.listTable(b.toString() , new String[] {functionUuid,functionUuid,buttonUuid,functionUuid,functionUuid,buttonUuid} );
|
if(!DataTableEntity.isEmpty(d)) {
|
page=d.getFieldSetEntity(0);//取第一条
|
}else {
|
|
}
|
}
|
if(page!=null) {
|
//查界面后的所有按钮
|
StringBuilder b=new StringBuilder();
|
b.append("select * from product_sys_function_buttons where function_uuid=? and uuid in(\r\n")
|
.append("select line_to from product_sys_link where function_uuid=? and line_from=?\r\n")
|
.append(")");
|
DataTableEntity d=baseDao.listTable(b.toString() , new String[] {functionUuid,functionUuid,page.getUUID()} );
|
page.addSubDataTable(d);
|
}else {
|
throw new BaseException(MobileCoreCode.GET_ROUTER_FAIL);
|
}
|
return page;
|
}else {
|
throw new BaseException(MobileCoreCode.GET_ROUTER_FAIL);
|
}
|
}
|
/**
|
* 执行表达式
|
* @param exp
|
* @return
|
*/
|
public FieldSetEntity excuteExp(String exp) {
|
String sql="select "+exp+" expValue";
|
FieldSetEntity fs=baseDao.getFieldSetBySQL(sql, null, false);
|
return fs;
|
}
|
|
/**
|
* 根据按钮uuid找到连接的第一个页面
|
* @param fse
|
* @return
|
*/
|
public FieldSetEntity getNextPageByButtonUUID(FieldSetEntity fse) {
|
String buttonUUID = fse.getUUID();
|
StringBuilder sql = new StringBuilder(128);
|
sql.append("\nSELECT p.flow_uuid type_code,p.flow_title");
|
sql.append("\nFROM product_sys_mvc_page p");
|
sql.append("\nINNER JOIN product_sys_link l ON p.uuid=l.line_to");
|
sql.append("\nWHERE l.line_from=?");
|
sql.append("\nORDER BY p.id DESC");
|
DataTableEntity nextPageDte = baseDao.listTable(sql.toString(), new Object[]{buttonUUID});
|
if (DataTableEntity.isEmpty(nextPageDte)) {
|
throw new BaseException(MobileCoreCode.GET_MVC_PAGE_INFO_FAIL);
|
}
|
return nextPageDte.getFieldSetEntity(0);
|
}
|
}
|
