use of com.jfinal.aop.Before in project my_curd by qinyou.
the class SysOrgController method queryUser.
@Before(SearchSql.class)
public void queryUser() {
int pageNumber = getAttr("pageNumber");
int pageSize = getAttr("pageSize");
String where = getAttr(Constant.SEARCH_SQL);
Integer id = getParaToInt("orgId");
String sqlSelect = " select * ";
String sqlExceptSelect = " from sys_user ";
if (id != null) {
Record record = Db.findFirst("select getChildLst(?,'sys_org') as childrenIds ", id);
// 子、孙 id
String childrenIds = record.getStr("childrenIds");
if (StrKit.notBlank(childrenIds)) {
sqlExceptSelect += " where org_id in (" + childrenIds + ")";
}
if (StrKit.notBlank(where)) {
sqlExceptSelect += " and ( " + where + " )";
}
} else {
if (StrKit.notBlank(where)) {
sqlExceptSelect += " where " + where;
}
}
sqlExceptSelect += " order by create_time ";
Page<SysUser> sysUsers = SysUser.dao.paginate(pageNumber, pageSize, sqlSelect, sqlExceptSelect);
renderDatagrid(sysUsers);
}
use of com.jfinal.aop.Before in project my_curd by qinyou.
the class SysRoleController method givePermission.
/**
* 用户赋权限
*/
@Before(Tx.class)
public void givePermission() {
Integer roleId = getParaToInt("roleId");
String permissIds = getPara("permissIds");
try {
String deleteSql = "delete from sys_role_menu where role_id = ?";
Db.update(deleteSql, roleId);
if (StrKit.notBlank(permissIds)) {
String[] menuIds = permissIds.split(";");
for (int i = 0; i < menuIds.length; i++) {
SysRoleMenu sysRoleMenu = new SysRoleMenu();
sysRoleMenu.setRoleId(roleId);
sysRoleMenu.setMenuId(Integer.parseInt(menuIds[i]));
sysRoleMenu.save();
}
}
renderText("赋权成功");
} catch (ActiveRecordException e) {
e.printStackTrace();
renderText("赋权失败");
}
}
use of com.jfinal.aop.Before in project fruit-manage by liuzhaozhao.
the class CustomerController method save.
@Before(Tx.class)
public void save() {
BusinessAuth businessAuth = getModel(BusinessAuth.class, "", true);
BusinessInfo businessInfo = getModel(BusinessInfo.class, "", true);
Integer businessAuthExtID = getParaToInt("businessAuthExtID");
businessAuth.setId(businessAuthExtID);
Integer saleUserId = getParaToInt("saleUserId");
// 给用户信息进行赋值
BusinessUser businessUser = new BusinessUser();
if (businessInfo.getPhone() != null) {
String pwd = "xiguo" + businessInfo.getPhone().substring(7, businessInfo.getPhone().length());
// 进行MD5加密
pwd = HashKit.md5(pwd);
businessUser.setPass(pwd);
}
if (businessInfo.getUId() != null && businessInfo.getUId() > 0) {
businessUser.setId(businessInfo.getUId());
}
businessUser.setPhone(businessInfo.getPhone());
businessUser.setAUserSalesId(saleUserId);
businessUser.setUpdateTime(new Date());
businessUser.setCreateTime(new Date());
// 判断是添加还是修改
if (businessInfo.getId() != null && businessInfo.getId() > 0) {
businessAuth.setUpdateTime(new Date());
businessInfo.setUpdateTime(new Date());
businessAuth.update();
businessInfo.update();
businessUser.update();
} else {
// 给店铺认证赋值
businessAuth.setCreateTime(new Date());
businessAuth.setUpdateTime(new Date());
businessAuth.setAudit(2);
businessUser.save();
// 设置商户ID
businessAuth.setUId(businessUser.get("id"));
// 给店铺信息
businessInfo.setUId(businessUser.get("id"));
businessInfo.setCreateTime(new Date());
businessInfo.setUpdateTime(new Date());
// 添加商户信息
businessInfo.save();
// 添加商户认证
businessAuth.save();
}
BusinessUser.dao.updateBusinessUserSaleIDByUid(1, saleUserId);
}
use of com.jfinal.aop.Before in project fruit-manage by liuzhaozhao.
the class PlanDetailController method updatePPlanDetail.
/**
* 根据时间字段更新采购计划
*/
@Before(Tx.class)
public void updatePPlanDetail() {
Integer uid = getSessionAttr(Constant.SESSION_UID);
// 获取当前操作用户
User user = User.dao.findById(uid);
Date createTime = getParaToDate("createTime");
String createTimeStr = DateAndStringFormat.getStringDateShort(createTime);
String[] createTimes = new String[2];
createTimes[0] = DateAndStringFormat.getNextDay(createTimeStr, "-1") + " 12:00:00";
createTimes[1] = createTimeStr + " 11:59:59";
// 获取要导出数据
List<ProcurementPlan> planList = ProcurementPlan.dao.getExportDataByPPlanID(createTimes);
// 先执行删除操作
// ProcurementPlanDetail.dao.delPPlanDetail(createTimes);
List<String> list = new ArrayList<>();
try {
for (ProcurementPlan procurementPlan : planList) {
ProcurementPlanDetail procurementPlanDetail2 = ProcurementPlanDetail.dao.getPPlanDetailByPSID(procurementPlan.get("productStandardID"), createTimes, null);
// 如果采购计划不存在就新增
if (procurementPlanDetail2 == null) {
Integer productId = procurementPlan.get("productId");
ProcurementPlanDetail procurementPlanDetail = new ProcurementPlanDetail();
procurementPlanDetail.setProductId(productId);
procurementPlanDetail.setProductStandardId(procurementPlan.get("productStandardID"));
procurementPlanDetail.setProcurementId(uid);
procurementPlanDetail.setProductName(procurementPlan.get("productName"));
procurementPlanDetail.setProductStandardName(procurementPlan.get("productStandardName"));
procurementPlanDetail.setSellPrice(procurementPlan.get("sellPrice"));
procurementPlanDetail.setInventoryNum(Integer.parseInt(procurementPlan.get("inventoryNum") + ""));
procurementPlanDetail.setProcurementNum(Integer.parseInt(procurementPlan.get("procurementNum") + ""));
procurementPlanDetail.setProductStandardNum(Integer.parseInt(procurementPlan.get("productStandardNum") + ""));
procurementPlanDetail.setProcurementNeedPrice(BigDecimal.valueOf(procurementPlan.get("procurementNeedPrice")));
procurementPlanDetail.setProcurementTotalPrice(BigDecimal.valueOf(procurementPlan.get("procurementTotalPrice")));
procurementPlanDetail.setOrderRemark(procurementPlan.get("orderRemark"));
procurementPlanDetail.setProcurementRemark(procurementPlan.get("procurementRemark"));
procurementPlanDetail.setCreateTime(createTime);
procurementPlanDetail.setUpdateTime(new Date());
procurementPlanDetail.save();
} else {
procurementPlanDetail2.setProductStandardNum(Integer.parseInt(procurementPlan.get("productStandardNum") + ""));
procurementPlanDetail2.setUpdateTime(new Date());
procurementPlanDetail2.update();
}
}
// 订单日志修改为1(被统计过)
ProcurementPlan.dao.updateOrderLog(createTimes);
list.add("0");
} catch (Exception e) {
list.add("1");
}
renderJson(list);
}
use of com.jfinal.aop.Before in project fruit-manage by liuzhaozhao.
the class OrderDetail method update.
@Before(Tx.class)
public boolean update(UserTypeConstant type, Integer uid) {
OrderDetail orderDetail = OrderDetail.dao.findById(super.getId());
super.update();
return getOrderLog(type, uid, orderDetail.getOrderId(), orderDetail.getProductId(), orderDetail.getProductStandardId(), super.getNum() - orderDetail.getNum()).save();
}
Aggregations