/** * model * * @param me */ @Override public void configPlugin(Plugins me) { componentSscan(basePackage); IDataSourceProvider iDataSourceProvider = setDataSource(); try { me.add((IPlugin) iDataSourceProvider); } catch (Exception e) { throw new RuntimeException("is not IPlugin type"); } ActiveRecordPlugin arp = new ActiveRecordPlugin(iDataSourceProvider); addActiveRecord(arp); // 加入附加的活动记录 Scan driven = new Scan(); for (String pake : basePackage) { Set<Class<?>> clazzs = driven.getClasses(pake); for (Class<?> clazz : clazzs) { LOG.info(clazz.getName()); Class superClass = clazz.getSuperclass(); Class<?> jfClz = com.jfinal.plugin.activerecord.Model.class; if (superClass == jfClz || superClass.getSuperclass() == jfClz) { M model = clazz.getAnnotation(M.class); if (null != model) { arp.addMapping(model.value(), model.id(), (Class<? extends Model<?>>) clazz); } } } } me.add(arp); }
/** * controller * * @param me */ @Override public void configRoute(Routes me) { // String path = this.getClass().getClassLoader().getResource("").getPath(); controlSscan(controlPackage); // 获取需要扫描的包 // 扫描器 Scan driven = new Scan(); for (String pake : controlPackage) { Set<Class<?>> clazzs = driven.getClasses(pake); /*System.out.println("pake: " + pake);*/ for (Class<?> clazz : clazzs) { // System.out.println(clazz.getSuperclass()); LOG.info(clazz.getName()); Class<?> superclass = clazz.getSuperclass(); Class<?> jfClz = com.jfinal.core.Controller.class; if (superclass == jfClz || superclass.getSuperclass() == jfClz) { C con = clazz.getAnnotation(C.class); if (null != con) { me.add(con.value(), (Class<? extends Controller>) clazz); } } } } }
/** Create by tanliansheng on 2015年10月29日 */ @ControllerBind(controllerKey = "/admin/user", viewPath = "/ftl/admin/user") public class UserAdminController extends Controller { private static final Logger LOG = Logger.getLogger(UserAdminController.class); public void index() { int pageNo = getParaToInt("pageNo", 1); int pageSize = getParaToInt("pageSize", 10); Page<User> userPage = User.dao.paginate( pageNo, pageSize, "select u.username,u.is_locked,u.id,r.name,r.description ", "from system_user u " + "LEFT JOIN system_user_role ur on ur.user_id = u.id " + "LEFT JOIN system_role r on r.id = ur.role_id "); TablePage tp = new TablePage(pageNo, pageSize, userPage.getTotalRow(), userPage.getTotalPage()); setAttr("page", userPage); setAttr("pageStr", tp.toString()); render("index.html"); } public void update() { int id = getParaToInt("id", 0); if (id > 0) { setAttr("user", User.dao.findByUserId(id)); render("update.html"); } } }
@Override public boolean start() { createShardedJedisPool(); RedisKit.init(shardedJedisPool); logger.info("初始化redis插件成功"); return true; }
private static void checkFileModify() { Set<String> filenames = lastmodifies.keySet(); for (String filename : filenames) { File file = new File(filename); if (lastmodifies.get(filename) != file.lastModified()) { LOG.info(filename + " changed, reload."); init(includeResources, excludeResources, reload); } } }
/** * 查询空值或者不为空值的情况 setNullFieldQuery * * @param queryType 参数说明 * @param filedName 字段名 */ public void setNullOrNotNullFieldQuery(String queryType, String... filedName) { if (StringUtils.isNotBlank(queryType) && !JFinalExtKit.isNullOrEmpty(filedName)) { if (!QueryType.NOT_EMPTY.equals(queryType) && !QueryType.EMPTY.equals(queryType)) { log.error("空值或者非空查询的类型只能为:EMPTY、NOT_EMPTY"); throw new RuntimeException("空值或者非空查询的类型只能为:EMPTY、NOT_EMPTY"); } Map<String, Object[]> map = conditionMap.get(); map.put(queryType, filedName); conditionMap.set(map); } }
public class ConfigPlugin implements IPlugin { static String suffix = "txt"; protected final Logger logger = Logger.getLogger(getClass()); private final List<String> includeResources = Lists.newArrayList(); private final List<String> excludeResources = Lists.newArrayList(); private boolean reload = true; public ConfigPlugin(String... includeResources) { if (includeResources != null) { for (String includeResource : includeResources) { this.includeResources.add(includeResource); } } } public ConfigPlugin excludeResource(String... resource) { if (includeResources != null) { for (String excludeResource : excludeResources) { excludeResources.add(excludeResource); } } return this; } public ConfigPlugin addResource(String resource) { includeResources.add(resource); return this; } public ConfigPlugin reload(boolean reload) { this.reload = reload; return this; } public static void setSuffix(String suffix) { ConfigPlugin.suffix = suffix; } @Override public boolean start() { ConfigKit.init(includeResources, excludeResources, reload); return true; } @Override public boolean stop() { return true; } }
/** * @param includeResources * @param excludeResources * @param reload */ static void init(List<String> includeResources, List<String> excludeResources, boolean reload) { ConfigKit.includeResources = includeResources; ConfigKit.excludeResources = excludeResources; ConfigKit.reload = reload; for (final String resource : includeResources) { LOG.debug("include :" + resource); File[] propertiesFiles = null; propertiesFiles = new File(PathKit.getRootClassPath()) .listFiles( new FileFilter() { @Override public boolean accept(File pathname) { return Pattern.compile(resource).matcher(pathname.getName()).matches(); } }); for (File file : propertiesFiles) { String fileName = file.getAbsolutePath(); LOG.debug("fileName:" + fileName); if (fileName.endsWith("-test." + ConfigPlugin.getSuffix())) { continue; } boolean excluded = false; for (String exclude : excludeResources) { if (Pattern.compile(exclude).matcher(file.getName()).matches()) { excluded = true; } } if (excluded) { continue; } lastmodifies.put(fileName, new File(fileName).lastModified()); map = ResourceKit.readProperties(fileName); testMap = ResourceKit.readProperties(testFileName(fileName)); } } LOG.debug("map" + map); LOG.debug("testMap" + testMap); LOG.info("config init success!"); }
/** ActionException. */ public class ActionException extends RuntimeException { private static final long serialVersionUID = 1998063243843477017L; private static final Logger log = Logger.getLogger(ActionException.class); private int errorCode; private Render errorRender; public ActionException(final int errorCode, final Render errorRender) { if (errorRender == null) throw new IllegalArgumentException("The parameter errorRender can not be null."); this.errorCode = errorCode; if (errorRender instanceof com.jfinal.render.ErrorRender) { this.errorRender = errorRender; } else { this.errorRender = new Render() { public Render setContext( HttpServletRequest req, HttpServletResponse res, String viewPath) { errorRender.setContext(req, res, viewPath); res.setStatus(errorCode); // important return this; } public void render() { errorRender.render(); } }; } } public ActionException(int errorCode, String errorView) { if (StrKit.isBlank(errorView)) throw new IllegalArgumentException("The parameter errorView can not be blank."); this.errorCode = errorCode; this.errorRender = RenderFactory.me().getErrorRender(errorCode, errorView); } public ActionException(int errorCode, Render errorRender, String errorMessage) { this(errorCode, errorRender); log.warn(errorMessage); } public int getErrorCode() { return errorCode; } public Render getErrorRender() { return errorRender; } }
/** * 构建redis集群配置信息 * * @param bundle * @return */ private List<JedisShardInfo> createJedisShardInfoList(ResourceBundle bundle) { List<JedisShardInfo> list = new LinkedList<JedisShardInfo>(); String defaultRedisPort = bundle.getString("redis.port"); for (int i = 0; i < 10; i++) { if (!bundle.containsKey("redis" + (i == 0 ? "" : i) + ".ip")) { continue; } String redisIp = bundle.getString("redis" + (i == 0 ? "" : i) + ".ip"); String redisPort = bundle.getString("redis" + (i == 0 ? "" : i) + ".port"); if (StringUtils.isEmpty(redisPort)) { redisPort = defaultRedisPort; } if (StringUtils.isNotEmpty(redisIp) && StringUtils.isNotEmpty(redisPort)) { JedisShardInfo jedisShardInfo = new JedisShardInfo(redisIp, redisPort); logger.info("初始化redis,redis" + (i == 0 ? "" : i) + ".ip:" + redisIp + ",端口:" + redisPort); list.add(jedisShardInfo); } } return list; }
public class ThreadParamInit extends Thread { private static Logger log = Logger.getLogger(ThreadParamInit.class); public static String cacheStart_role = "role_"; public static String cacheStart_permission = "permission_"; public static String cacheStart_user = "******"; public static String cacheStart_branch = "branch_"; public static String cacheStart_apartment = "apartment_"; public static String cacheStart_position = "position_"; public static String cacheStart_operator = "operator_"; public static String cacheStart_dict = "dict_"; public static String cacheStart_dict_child = "dict_child_"; public static String cacheStart_etype = "etype_"; public static String cacheStart_etype_child = "etype_child_"; @Override public void run() { cacheAll(); } public static synchronized void cacheAll() {} }
public class ConfigKit { protected static final Logger LOG = Logger.getLogger(ConfigKit.class); private static List<String> includeResources; private static List<String> excludeResources; private static Map<String, String> map = Maps.newHashMap(); private static Map<String, String> testMap = Maps.newHashMap(); private static Map<String, Long> lastmodifies = new HashMap<String, Long>(); private static boolean reload = true; /** * @param includeResources * @param excludeResources * @param reload */ static void init(List<String> includeResources, List<String> excludeResources, boolean reload) { ConfigKit.includeResources = includeResources; ConfigKit.excludeResources = excludeResources; ConfigKit.reload = reload; for (final String resource : includeResources) { LOG.debug("include :" + resource); File[] propertiesFiles = null; propertiesFiles = new File(PathKit.getRootClassPath()) .listFiles( new FileFilter() { @Override public boolean accept(File pathname) { return Pattern.compile(resource).matcher(pathname.getName()).matches(); } }); for (File file : propertiesFiles) { String fileName = file.getAbsolutePath(); LOG.debug("fileName:" + fileName); if (fileName.endsWith("-test." + ConfigPlugin.getSuffix())) { continue; } boolean excluded = false; for (String exclude : excludeResources) { if (Pattern.compile(exclude).matcher(file.getName()).matches()) { excluded = true; } } if (excluded) { continue; } lastmodifies.put(fileName, new File(fileName).lastModified()); map = ResourceKit.readProperties(fileName); testMap = ResourceKit.readProperties(testFileName(fileName)); } } LOG.debug("map" + map); LOG.debug("testMap" + testMap); LOG.info("config init success!"); } private static String testFileName(String fileName) { return fileName.substring(0, fileName.indexOf("." + ConfigPlugin.getSuffix())) + "-test." + ConfigPlugin.getSuffix(); } public static String getStr(String key, String defaultVal) { if (testMap == null || map == null) { throw new RuntimeException(" please start ConfigPlugin first~"); } if (reload) { checkFileModify(); } String val = testMap.get(key); if (val == null || "".equals(val.trim())) { val = map.get(key); } return val == null ? defaultVal : val + ""; } private static void checkFileModify() { Set<String> filenames = lastmodifies.keySet(); for (String filename : filenames) { File file = new File(filename); if (lastmodifies.get(filename) != file.lastModified()) { LOG.info(filename + " changed, reload."); init(includeResources, excludeResources, reload); } } } public static String getStr(String key) { return getStr(key, ""); } public static long getLong(String key) { return getLong(key, 0); } public static long getLong(String key, long defaultVal) { String val = getStr(key).trim(); if ("".equals(val)) { return defaultVal; } return Long.parseLong(val); } public static int getInt(String key, int defaultVal) { String val = getStr(key).trim(); if ("".equals(val)) { return defaultVal; } return Integer.parseInt(val); } public static int getInt(String key) { return getInt(key, 0); } public static void set(String key, String val) { // TODO throw new RuntimeException("I do not know how to do it now.."); } }
public ActionException(int errorCode, Render errorRender, String errorMessage) { this(errorCode, errorRender); log.warn(errorMessage); }
public class BigwheelController extends BaseController { private static Logger log = Logger.getLogger(AppraiseController.class); /** * \ // Object[][] prizeArr = new Object[][]{ // //id,min,max,prize【奖项】,v【中奖率】 // //外面的转盘转动 // // * {1,1,14,"一等奖",1}, // // {2,346,364,"一等奖",1}, // // {3,16,44,"不要灰心",10}, // // * {4,46,74,"神马也没有",10}, // // {5,76,104,"祝您好运",10}, // // {6,106,134,"二等奖",2}, // // * {7,136,164,"再接再厉",10}, // // {8,166,194,"神马也没有",10}, // // {9,196,224,"运气先攒着",10}, // // * {10,226,254,"三等奖",5}, // // {11,256,284,"要加油哦",10}, // // {12,286,314,"神马也没有",10}, // // * {13,316,344,"谢谢参与",10} // // //里面的指针转动 // {1,1,14,"一等奖",1}, // {2,346,364,"一等奖",1}, // * {3,16,44,"不要灰心",10}, // {4,46,74,"神马也没有",10}, // {5,76,104,"祝您好运",10}, // {6,106,134,"二等奖",2}, * // {7,136,164,"再接再厉",10}, // {8,166,194,"神马也没有",10}, // {9,196,224,"运气先攒着",10}, // * {10,226,254,"三等奖",5}, // {11,256,284,"要加油哦",10}, // {12,286,314,"神马也没有",10}, // * {13,316,344,"谢谢参与",10} // }; */ public void award() { JSONObject json = new JSONObject(); Member member = Member.dao.findById(getUserIds()); String storeId = getPara("storeId"); String programId = getPara("programId"); ActiveProgram activeProgram = ActiveProgram.dao.findById(programId); // 查询是否中奖 Integer prizeCount = ActivePrizeInfo.dao.prizeCount( member.getStr("id"), DateUtil.format(new Date(), "yyyyMMdd") + "%", storeId, programId); if (prizeCount > 0) { json.put("msg", "你已中奖,今天不能在抽奖了"); json.put("isRight", false); renderJson(json.toString()); return; } // 查询是否超过限制 // String time = ""; Integer count = ActivePrizeInfo.dao.findCountBydate( member.getStr("id"), storeId, activeProgram.getStr("activetype_id"), programId, DateUtil.format(new Date(), "yyyyMMdd") + "%"); if (count >= activeProgram.getInt("repeat_prize_count")) { json.put("msg", "你的抽奖次数已经用完!"); json.put("isRight", false); renderJson(json.toString()); return; } List<ActiveProgramItem> activeProgramItems = ActiveProgramItem.dao.findActiveProgramItem(programId); // 封装 List<Object[]> prizeArr = new ArrayList<Object[]>(); Integer totalCount = 0; // 计算总数 for (int i = 0; i < activeProgramItems.size(); i++) { totalCount += activeProgramItems.get(i).getInt("item_count"); } // 设置未中奖信息 double cal_isPrize = totalCount / (double) activeProgram.getInt("partake_num"); // 中奖概率 Object[] result_ = new Object[6]; result_[0] = "-1"; result_[1] = 31; result_[2] = 89; result_[3] = "你未中奖"; result_[4] = (int) ((1 - cal_isPrize) * 100); result_[5] = ""; prizeArr.add(result_); // 设置中奖信息 for (int i = 0; i < activeProgramItems.size(); i++) { ActiveProgramItem item = activeProgramItems.get(i); if (totalCount == 0) continue; double cal = item.getInt("item_count") / (double) activeProgram.getInt("partake_num"); // 每次概率 if (item.getInt("px") == 1) { Object[] r1 = new Object[6]; r1[0] = item.get("id"); r1[1] = 1; r1[2] = 29; r1[3] = item.get("name"); r1[4] = (int) (cal * 100); r1[5] = item.get("active_prize_item_id"); prizeArr.add(r1); Object[] r2 = new Object[6]; r2[0] = item.get("id"); r2[1] = 331; r2[2] = 359; r2[3] = item.get("name"); r2[4] = (int) (cal * 100); r2[5] = item.get("active_prize_item_id"); prizeArr.add(r2); } else { Object[] result = new Object[6]; result[0] = item.get("id"); result[1] = 360 - (item.getInt("px") - 1) * 60 - 30 + 1; result[2] = 360 - (item.getInt("px") - 2) * 60 - 30 - 1; result[3] = item.getStr("name"); result[4] = (int) (cal * 100); result[5] = item.get("active_prize_item_id"); prizeArr.add(result); } } Object result[] = award(prizeArr); // 抽奖后返回角度和奖品等级 // 1 得到奖项 更新数量 String itemId = (String) result[3]; // 判断是否中奖 String provavilit = (String) result[4]; // 奖项类型ID // 1.更新奖品数量 if (StringUtil.isNotBlank(itemId) && !"-1".equals(itemId)) { ActiveProgramItem.dao.updateCount(itemId); // 更新数量 } Store store = Store.dao.findById(activeProgram.get("store_id")); ActivePrizeItem item = ActivePrizeItem.dao.findById(provavilit); ActivePrizeInfo info = new ActivePrizeInfo(); info.set("id", ToolUtil.getUuidByJdk(true)) .set("user_id", member.get("id")) .set("store_id", activeProgram.get("store_id")) .set("store_name", store.get("name")) .set("active_type_id", activeProgram.get("activetype_id")) .set("active_program_id", activeProgram.get("id")) .set("active_program_name", activeProgram.get("name")) .set("active_program_item_id", itemId) .set("prize_code", "JL" + GenerateUtils.consumCode()) .set("status", 1) .set("loose_time", activeProgram.get("end_time")) .set("prize_time", DateUtil.format(new Date(), "yyyyMMddHHmmss")) .set("prize_item_name", item != null ? item.get("item_name") : ""); ActivePrizeInfo.dao.saveInfo(info, item, member.getStr("id")); json.put("angle", result[0]); json.put("msg", result[2]); json.put("isRight", true); renderJson(json.toString()); } // 抽奖并返回角度和奖项 public Object[] award(List<Object[]> prizeArr) { // 概率数组 Integer obj[] = new Integer[prizeArr.size()]; for (int i = 0; i < prizeArr.size(); i++) { obj[i] = (Integer) prizeArr.get(i)[4]; } Integer prize = getRand(obj); // 根据概率获取奖项id // 旋转角度 int angle = new Random().nextInt((Integer) prizeArr.get(prize)[2] - (Integer) prizeArr.get(prize)[1]) + (Integer) prizeArr.get(prize)[1]; String msg = (String) prizeArr.get(prize)[3]; // 提示信息 String prizeId = (String) prizeArr.get(prize)[0]; // 提示信息 return new Object[] {angle, prize, msg, prizeId, prizeArr.get(prize)[5]}; } // 根据概率获取奖项 public Integer getRand(Integer obj[]) { Integer result = null; try { int sum = 0; // 概率数组的总概率精度 for (int i = 0; i < obj.length; i++) { sum += obj[i]; } for (int i = 0; i < obj.length; i++) { // 概率数组循环 int randomNum = new Random().nextInt(sum); // 随机生成1到sum的整数 if (randomNum < obj[i]) { // 中奖 result = i; break; } else { sum -= obj[i]; } } } catch (Exception e) { e.printStackTrace(); } return result; } }
/** * 采购入库单 * * @author 熊涛 2013.9.25 */ @RouteBind(path = "/ckjhcheck") @Before({ManagerPowerInterceptor.class}) public class CkjhcheckController extends BaseController { public static Logger log = Logger.getLogger(CkjhcheckController.class); private static String navTabId = "ckjhcheck"; private String supplierCodePara = null; private byte[] lock = new byte[0]; @Override public void index() { select(); render("index.html"); } public void list() { supplierCodePara = getPara(); select(); render("list.html"); } private void select() { StringBuffer whee = new StringBuffer(); List<Object> param = new ArrayList<Object>(); String startTime = getPara("startTime"); if (startTime != null && !"".equals(startTime.trim())) { whee.append(" and UNIX_TIMESTAMP(p.OrderDate) >= UNIX_TIMESTAMP(?)"); param.add(startTime); } setAttr("startTime", startTime); String endTime = getPara("endTime"); if (endTime != null && !"".equals(endTime.trim())) { whee.append(" and UNIX_TIMESTAMP(p.OrderDate) <= UNIX_TIMESTAMP(?)"); param.add(endTime); } setAttr("endTime", endTime); String supplierCode = getPara("supplier.supplierCode"); if (supplierCodePara != null) supplierCode = supplierCodePara; if (supplierCode != null && !"".equals(supplierCode.trim())) { whee.append(" and p.SupplierCode = ?"); param.add(Long.parseLong(supplierCode)); } setAttr("supplierCode", supplierCode); setAttr("supplierName", getPara("supplier.supplierName")); String storeCd = getPara("store.StoreCode"); if (storeCd != null && !"".equals(storeCd.trim())) { whee.append(" and p.StoreCode = ?"); param.add(Long.parseLong(storeCd)); } setAttr("StoreCode", storeCd); setAttr("StoreName", getPara("store.StoreName")); String sql = " from ckjhcheck p left join jbsupplier b on p.SupplierCode = b.supplierCode "; sql += " left join jbstore c on p.StoreCode = c.StoreCode "; sql += " left join employee d on d.usr_no = p.EmpCode "; sql += " left join partment e on e.deptCode = p.deptCode "; sql += " left join types t on t.id=p.inoutTypeNo and t.function='入库类型'"; sql += " where 1=1 "; setAttr( "page", Db.paginate( getParaToInt("pageNum", 1), getParaToInt("numPerPage", 10), "select p.id,p.OrderCode 订单号, p.OrderDate 进货日期,p.remark 备注, t.name 入库类型,p.BillOrderNo 采购单号,p.CKAmount 入库金额, p.payAmount 已付金额,p.checkflag 审核, b.supplierName 供应商,c.StoreName 订货仓库,d.usr_name 业务员, e.`name` 部门 ", sql + whee.toString(), param.toArray())); setAttr( "collist", new String[] { "订单号", "进货日期", "供应商", "业务员", "部门", "收货日期", "订货仓库", "入库类型", "采购单号", "入库金额", "已付金额", "审核", "备注" }); } // 采购入库 public void cgInStore() { Ckjhcheck ckjhcheck = new Ckjhcheck(); Jbsupplier jbsupplier = new Jbsupplier(); Jbstore jbstore = new Jbstore(); List<Object> param = new ArrayList<Object>(); // 采购入库单号 String ordCdNw = null; synchronized (lock) { ordCdNw = BsUtil.getMaxOrdNo("OrderCode", "PK", "ckjhcheck"); } ckjhcheck.set("OrderCode", ordCdNw); String obj = getPara(); Cgorder cgOrd = new Cgorder(); cgOrd = Cgorder.dao.findFirst("select * from cgorder where orderCode = ?", new Object[] {obj}); jbsupplier = Jbsupplier.dao.findFirst( "select * from jbsupplier where supplierCode = ?", cgOrd.getStr("supplierCode")); jbstore = Jbstore.dao.findFirst( "select * from jbstore where StoreCode = ?", cgOrd.getStr("StoreCode")); // ckjhcheck.set("OrderCode", ordCdNw); ckjhcheck.set("OrderDate", cgOrd.getDate("DeliveryDate")); ckjhcheck.set("supplierCode", cgOrd.getStr("supplierCode")); ckjhcheck.set("StoreCode", cgOrd.getStr("StoreCode")); // ckjhcheck.set("InOutTypeNo", "52"); ckjhcheck.set("BillOrderNo", cgOrd.getStr("orderCode")); ckjhcheck.set("deptCode", cgOrd.getStr("deptcode")); ckjhcheck.set("Empcode", cgOrd.getStr("Empcode")); ckjhcheck.set("Operator", cgOrd.getStr("Operator")); ckjhcheck.set("CheckFlag", 0); ckjhcheck.set("SettleTypeFlag", 0); StringBuffer whee = new StringBuffer(); whee.append(" and a.orderCode = ?"); param.add(obj); String sql = "select a.id,b.GoodsCode 商品编号,b.GoodsName 商品名称,b.Model 商品规格,b.BaseUnit 基本单位,b.BRefPrice 原价,a.Discount 折扣, a.Quantity 数量,"; sql += " a.TaxRate 税率,a.TaxAmount 税额,a.Amount 税后金额"; String sqlSelect = " from cgorderdetail a"; sqlSelect += " left join jbgoods b on a.GoodsCode = b.GoodsCode where 1=1 "; Page<Record> redLst = Db.paginate( getParaToInt("pageNum", 1), getParaToInt("numPerPage", 20), sql, sqlSelect + whee.toString(), param.toArray()); int size = redLst.getList().size(); // 不足10条,补足10条显示 if (size < 10) { for (int i = 0; i < 10 - size; i++) { redLst.getList().add(new Record()); } } setAttr("page", redLst); setAttr( "collist", new String[] { "商品编号", "商品名称", "商品规格", "基本单位", "原价", "折扣%", "单价", "数量", "税率%", "折后金额", "税后金额" }); setAttr("ckjhcheck", ckjhcheck); setAttr("store", jbstore); setAttr("supplier", jbsupplier); setAttr(InOutTypeNoSelectTarget.targetName, new InOutTypeNoSelectTarget()); setAttr(PartmentSelectTarget.targetName, new PartmentSelectTarget()); setAttr(EmployeeSelectTarget.targetName, new EmployeeSelectTarget()); render("add.html"); } public void add() { Ckjhcheck ckjhcheck = new Ckjhcheck(); Jbsupplier jbsupplier = new Jbsupplier(); Jbstore jbstore = new Jbstore(); // 采购入库单号 String ordCdNw = null; // 不是采购订单导入 Long id = getParaToLong(0, 0L); List<Object> param = new ArrayList<Object>(); StringBuffer whee = new StringBuffer(); whee.append(" and a.OrderCode = ?"); if (id != 0) { // 修改 ckjhcheck = Ckjhcheck.dao.findById(id); jbsupplier = Jbsupplier.dao.findFirst( "select * from jbsupplier where supplierCode = ?", ckjhcheck.getStr("SupplierCode")); jbstore = Jbstore.dao.findFirst( "select * from jbstore where StoreCode = ?", ckjhcheck.getStr("StoreCode")); param.add(ckjhcheck.get("orderCode")); } else { synchronized (lock) { ordCdNw = BsUtil.getMaxOrdNo("OrderCode", "PK", "ckjhcheck"); } ckjhcheck.set("OrderCode", ordCdNw); param.add(ordCdNw); // 赋值当前时间 Date dt = new Date(); SimpleDateFormat ckDate = new SimpleDateFormat("yyyy-MM-dd"); ckjhcheck.set("orderdate", ckDate.format(dt)); // 赋值制单人 Record m = getCurrentUser(); ckjhcheck.set("operator", m.getStr("usr_name")); } String sql = "select a.id,b.GoodsCode 商品编号,b.GoodsName 商品名称,b.Model 商品规格,b.BaseUnit 基本单位,b.BRefPrice 原价,a.Discount 折扣, a.Quantity 数量,"; sql += " a.TaxRate 税率,a.TaxAmount 税额,a.Amount 金额"; String sqlSelect = " from ckjhcheckdetail a"; sqlSelect += " left join jbgoods b on a.GoodsCode = b.GoodsCode where 1=1 "; Page<Record> redLst = Db.paginate( getParaToInt("pageNum", 1), getParaToInt("numPerPage", 20), sql, sqlSelect + whee.toString(), param.toArray()); int size = redLst.getList().size(); // 不足10条,补足10条显示 if (size < 10) { for (int i = 0; i < 10 - size; i++) { redLst.getList().add(new Record()); } } setAttr("page", redLst); setAttr( "collist", new String[] {"商品编号", "商品名称", "商品规格", "单位", "原价", "折扣%", "数量", "订单金额", "税率%", "税额", "金额"}); setAttr("ckjhcheck", ckjhcheck); setAttr("store", jbstore); setAttr("supplier", jbsupplier); setAttr(InOutTypeNoSelectTarget.targetName, new InOutTypeNoSelectTarget()); setAttr(PartmentSelectTarget.targetName, new PartmentSelectTarget()); setAttr(EmployeeSelectTarget.targetName, new EmployeeSelectTarget()); render("add.html"); } public void save() { try { boolean settleTypeFlag = false; Jhpay jhpay = null; Ckjhcheck m = getModel(Ckjhcheck.class, "ckjhcheck"); Jbsupplier supplier = getModel(Jbsupplier.class, "supplier"); Jbstore store = getModel(Jbstore.class, "store"); m.set("SupplierCode", supplier.getStr("supplierCode")); m.set("StoreCode", store.getStr("StoreCode")); Double amount = Double.parseDouble(getPara("amount")); m.set("CKAmount", amount); if (getPara("typeFlg") != null && getParaToInt("typeFlg") == 1) { m.set("SettleTypeFlag", getParaToInt("typeFlg")); settleTypeFlag = true; } if (m.getLong("id") != null) { m.update(); } else { m.save(); } // 当面付模式 if (settleTypeFlag) { jhpay = Jhpay.dao.findFirst("select * from jhpay where BillOrderNo = ?", m.getStr("OrderDate")); if (jhpay == null) { // 生成付款单信息 jhpay = new Jhpay(); synchronized (lock) { String ordCdNw = BsUtil.getMaxOrdNo("OrderCode", "CF", "jhpay"); jhpay.set("OrderCode", ordCdNw); } jhpay.set( "OrderDate", DateUtil.string2Date( DateUtil.date2String(new Date(), DateUtil.FORMAT_DATE), DateUtil.FORMAT_DATE)); jhpay.set("SupplierCode", m.get("SupplierCode")); jhpay.set("DeptCode", m.get("DeptCode")); jhpay.set("EmpCode", m.get("EmpCode")); jhpay.set("PayType", BsUtil.DIR_PAY); jhpay.set("BankNo", supplier.get("BankNo")); jhpay.set("Amount", amount); jhpay.set("BillOrderNo", m.get("OrderCode")); Record man = getCurrentUser(); jhpay.set("checkman", man.getStr("usr_name")); jhpay.set("CheckDate", new Date()); jhpay.set("CheckFlag", 1); jhpay.save(); Jhpaydetail jhpaydetail = new Jhpaydetail(); jhpaydetail.set("OrderCode", m.get("OrderCode")); jhpaydetail.set("PayOrderNo", jhpay.get("OrderCode")); jhpaydetail.set("CollateType", "采购入库单"); jhpaydetail.set("NowCollated", amount); jhpaydetail.set("Adjust", 0); jhpaydetail.set("Amount", amount); } } String orderCode = m.get("OrderCode"); // 保存明细 int size = 0; // 通过【新建商品明细】按钮新追加记录 String[] index = getParaValues("lineId"); size = Db.queryLong( "select count(*) from ckjhcheckdetail where orderCode = '" + orderCode + "'") .intValue(); if (!(index == null || index.length == 0)) { size = size + index.length; } // 不足10条,补足10条显示并保存 if (size < 10) { size = 10; } for (int i = 0; i < size; i++) { Ckjhcheckdetail md = getModel(Ckjhcheckdetail.class, "ckjhcheckDetail" + i); Jbgoods goods = getModel(Jbgoods.class, "goods" + i); if (goods.getStr("GoodsCode") != null) { md.set("GoodsCode", goods.get("GoodsCode")); Ckjhcheckdetail tmp = Ckjhcheckdetail.dao.findById(md.getLong("id")); if (tmp != null) { md.set("price", goods.get("BRefPrice")); md.update(); } else { md.set("ordercode", orderCode); md.set("price", goods.get("BRefPrice")); md.save(); } } } toDwzJson(200, "保存成功!", navTabId, "closeCurrent"); } catch (Exception e) { log.error("保存仓库分类异常", e); toDwzJson(300, "保存异常!"); } } public void del() { Long id = getParaToLong(0, 0L); try { if (id != null) { Ckjhcheck r = Ckjhcheck.dao.findById(id); Ckjhcheck.dao.deleteById(id); Db.update("delete from ckjhcheckdetail where OrderCode=?", r.getStr("OrderCode")); } toDwzJson(200, "删除成功!", navTabId); } catch (Exception e) { toDwzJson(300, "删除失败!"); } } // 审核 @Before(Tx.class) public void review() throws Exception { Long id = getParaToLong(0, 0L); try { if (id != null) { Ckjhcheck r = Ckjhcheck.dao.findById(id); /* * if (r.getInt("SettleTypeFlag") == 2) { toDwzJson(300, * "已清货不能审核!", navTabId); return; } */ if (r.getInt("CheckFlag") == null || r.getInt("CheckFlag") != 1) { // 登录人即审核者 Record m = getCurrentUser(); r.set("checkman", m.getStr("usr_name")); r.set("CheckDate", new Date()); r.set("CheckFlag", 1); r.update(); // 审核后更新库存表及供应商表应付款 CkjhDbProc oracleDbK = new CkjhDbProc( r.getStr("StoreCode"), r.getStr("orderCode"), r.getStr("SupplierCode"), 1); Db.execute(oracleDbK); } toDwzJson(200, "审核通过!", navTabId); } } catch (Exception e) { toDwzJson(300, "审核失败!" + e.getMessage()); throw e; } } // 未审核 @Before(Tx.class) public void unreview() throws Exception { Long id = getParaToLong(0, 0L); try { if (id != null) { Ckjhcheck r = Ckjhcheck.dao.findById(id); /* * if (r.getInt("SettleTypeFlag") == 2) { toDwzJson(300, * "已清货不能反审核!", navTabId); return; } */ if (r.getInt("CheckFlag") != null && r.getInt("CheckFlag") != 0) { // 登录人即审核者 Record m = getCurrentUser(); r.set("CheckFlag", 0); r.set("checkman", m.getStr("usr_name")); r.set("CheckDate", new Date()); r.update(); // 审核后更新库存表及供应商表应付款 CkjhDbProc oracleDbK = new CkjhDbProc( r.getStr("StoreCode"), r.getStr("orderCode"), r.getStr("SupplierCode"), 2); Db.execute(oracleDbK); } toDwzJson(200, "反审核通过!", navTabId); } } catch (Exception e) { toDwzJson(300, "删除失败!"); throw e; } } }
// @Controller(controllerKey = "/buyer/collect") @Before(LoginInteceptor.class) public class CollectController extends BaseController { private static Logger log = Logger.getLogger(CollectController.class); // 查询用户的收藏(默认查询的是用户收藏的商品) public void collectlist() { Member member = Member.dao.findById(getUserIds()); Map<String, Object> params = new HashMap<String, Object>(); params.put("userId", member.getStr("id")); Integer pageNum = getParaToInt("pageNum"); Integer pageSize = getParaToInt("pageSize"); if (pageNum == null || pageNum.intValue() < 1) { pageNum = 1; // 默认第一页 } if (pageSize == null || pageSize.intValue() < 0) { pageSize = 10; // 默认每页显示10条 } else if (pageSize.intValue() > 100) { pageSize = 10; // 最大100条 } Page<Collect> collects = Collect.dao.findGoodsCollectByUserId(pageNum, pageSize, params); setAttr("collects", collects); setAttr("param", paramsToStr(params)); render(""); } // 删除用户收藏(商品) public void deleteGoodsCollect() { Collect.dao.deleteById(getPara("collect_id")); redirect("/buyer/collect/collectlist"); } // 查询用户收藏(店铺) public void storecollect() { Member member = Member.dao.findById(getUserIds()); Map<String, Object> params = new HashMap<String, Object>(); params.put("userId", member.getStr("id")); Integer pageNum = getParaToInt("pageNum"); Integer pageSize = getParaToInt("pageSize"); if (pageNum == null || pageNum.intValue() < 1) { pageNum = 1; // 默认第一页 } if (pageSize == null || pageSize.intValue() < 0) { pageSize = 10; // 默认每页显示10条 } else if (pageSize.intValue() > 100) { pageSize = 10; // 最大100条 } Page<Collect> collects = Collect.dao.findStoreCollectByUserId(pageNum, pageSize, params); setAttr("collects", collects); setAttr("param", paramsToStr(params)); render(""); } // 删除用户收藏(店铺) public void deleteStoreCollect() { Collect.dao.deleteById(getPara("collect_id")); redirect("/buyer/collect/storecollect"); } // 添加收藏 @ClearInterceptor public void saveCollect() { Member member = Member.dao.findById(getUserIds()); Collect collect = Collect.dao.findByCollect(getPara("collect_type"), getPara("collect"), member.getStr("id")); if (collect == null) { new Collect() .set("user_id", member.getStr("id")) .set("id", ToolUtil.getUuidByJdk(true)) .set("collect", getPara("collect")) .set("collect_type", getPara("collect_type")) .save(); setAttr("massege", true); } else { // 已经收藏 setAttr("massege", false); } setAttr("collect_type", getPara("collect_type")); render("/store/shoucangDialog.html"); } @ClearInterceptor public void islogin() { JSONObject result = new JSONObject(); // 验证是否登陆 if (StringUtil.isBlank(getUserIds())) { result.put("isLogin", false); result.put("error", "请先登录"); renderJson(result.toString()); return; } result.put("isLogin", true); renderJson(result.toString()); } }
/** * 用于动态生成JFinal的SQL查询语句 * * @author Lims * @date 2015年9月18日 * @version 1.1 */ public class QueryCondition { static Logger log = Logger.getLogger(QueryCondition.class); // 用于接收SQL语句 private ThreadLocal<String> sql = new ThreadLocal<String>(); // 用于接收参数数组 private ThreadLocal<ArrayList<Object>> paramList = new ThreadLocal<ArrayList<Object>>(); // 用于存放设置的条件 private ThreadLocal<Map<String, Object[]>> conditionMap = new ThreadLocal<Map<String, Object[]>>(); // 用于存放需要排除的字段 private ThreadLocal<Map<String, String>> excludeFieldMap = new ThreadLocal<Map<String, String>>(); /** 构造方法(表示没有设置查询类型的字段全部按照等于来处理) */ public QueryCondition() { conditionMap.set(new HashMap<String, Object[]>()); excludeFieldMap.set(new HashMap<String, String>()); } /** * 构造方法(设置后表示字段所有的查询方式按照设置类型来处理,除非后面针对字段的重新设置) * * @param type 查询类型 */ public QueryCondition(String type) { Map<String, Object[]> map = new HashMap<String, Object[]>(); map.put("GLOBALTYPE", new String[] {type}); conditionMap.set(map); excludeFieldMap.set(new HashMap<String, String>()); } /** * ************************************************************************* 设置字段的查询类型 * * @param queryType 查询类型 * @param filedName 字段名称数组 */ public void setFiledQuery(String queryType, String... filedName) { if (StringUtils.isNotBlank(queryType) && !JFinalExtKit.isNullOrEmpty(filedName)) { Map<String, Object[]> map = conditionMap.get(); map.put(queryType, filedName); conditionMap.set(map); } } /** * ************************************************************************* 设置需要排除的字段 * setexcludeField * * @param filedName 参数说明 */ public void setExcludeField(String... filedName) { if (!JFinalExtKit.isNullOrEmpty(filedName)) { Map<String, String> map = excludeFieldMap.get(); for (String str : filedName) { map.put(str, str); } excludeFieldMap.set(map); } } /** * 查询空值或者不为空值的情况 setNullFieldQuery * * @param queryType 参数说明 * @param filedName 字段名 */ public void setNullOrNotNullFieldQuery(String queryType, String... filedName) { if (StringUtils.isNotBlank(queryType) && !JFinalExtKit.isNullOrEmpty(filedName)) { if (!QueryType.NOT_EMPTY.equals(queryType) && !QueryType.EMPTY.equals(queryType)) { log.error("空值或者非空查询的类型只能为:EMPTY、NOT_EMPTY"); throw new RuntimeException("空值或者非空查询的类型只能为:EMPTY、NOT_EMPTY"); } Map<String, Object[]> map = conditionMap.get(); map.put(queryType, filedName); conditionMap.set(map); } } /** * ************************************************************************* 传值查询 * 注:如果queryType为in或者not in那么filedValue必须为一个list对象 * * @param queryType 查询类型 * @param fieldName 字段名称 * @param filedValue 字段值 */ public void setValueQuery(String queryType, String fieldName, Object filedValue) { if (StringUtils.isNotBlank(queryType) && StringUtils.isNotBlank(fieldName) && !JFinalExtKit.isNullOrEmpty(filedValue)) { Object[] param = new Object[2]; param[0] = fieldName; // 字段名 param[1] = filedValue; // 字段值 Map<String, Object[]> map = conditionMap.get(); map.put(queryType + "#" + fieldName, param); // 避免类型重复被覆盖掉就加上字段名 conditionMap.set(map); } } /** * ************************************************************************* 用于生成SQL条件语句不带别名 * * @param modelClass 必须继承于Model */ public void modelToCondition(Model<?> modelClass) { modelToCondition(modelClass, null); } /** * ************************************************************************* 用于生成SQL条件语句不带别名 * * @param recordClass 必须是一个Record类 */ public void recordToCondition(Record recordClass) { recordToCondition(recordClass, null); } /** * ************************************************************************* 用于生成SQL条件语句带别名 * * @param modelClass 必须继承于Model * @param alias 别名 */ public void modelToCondition(Model<?> modelClass, String alias) { alias = StringUtils.isNotBlank(alias) ? alias + "." : ""; if (modelClass != null) { // 所有的字段 String[] fieldNames = modelClass.getAttrNames(); // 字段名和值的map集合 Map<String, Object> valueMap = JFinalExtKit.modelToMap(modelClass); // 构建查询条件 buildCondition(alias, fieldNames, valueMap); } else { if (!conditionMap.get().isEmpty()) { buildCondition(alias, new String[] {}, new HashMap<String, Object>()); } else { sql.set(""); paramList.set(new ArrayList<Object>()); } } } /** * ************************************************************************* 用于生成SQL条件语句不带别名 * * @param recordClass 必须是一个Record类 * @param alias 别名 */ public void recordToCondition(Record recordClass, String alias) { // 别名 alias = StringUtils.isNotBlank(alias) ? alias + "." : ""; if (recordClass != null) { // 所有的字段 String[] fieldNames = recordClass.getColumnNames(); // 字段名和值的map集合 Map<String, Object> valueMap = JFinalExtKit.recordToMap(recordClass); // 构建查询条件 buildCondition(alias, fieldNames, valueMap); } else { if (!conditionMap.get().isEmpty()) { buildCondition(alias, new String[] {}, new HashMap<String, Object>()); } else { sql.set(""); paramList.set(new ArrayList<Object>()); } } } /** * ************************************************************************* 构建条件语句 * * @param alias 别名 * @param fieldNames 所有查询的字段名称 * @param valueMap 所有的值的map */ private void buildCondition(String alias, String[] fieldNames, Map<String, Object> valueMap) { try { // 构建条件前先清空变量 sql.set(""); paramList.set(new ArrayList<Object>()); // 用于存放参数列表 ArrayList<Object> paramArrayList = new ArrayList<Object>(); StringBuilder sb = new StringBuilder(); // 所有的字段名称 Map<String, String> usedFieldMap = new HashMap<String, String>(); if (!conditionMap.get().isEmpty()) { for (Entry<String, Object[]> map : conditionMap.get().entrySet()) { String queryType = map.getKey(); Object[] array = map.getValue(); if (queryType.indexOf("#") > 0) { // 传值查询 String fieldQueryType = queryType.split("#")[0]; String fieldName = array[0] != null ? array[0].toString() : ""; Object fieldValue = array[1]; // 将设置过的字段保存到数组中 usedFieldMap.put(fieldName, fieldName); // 构建SQL语句 buildSQL(sb, fieldQueryType, fieldName, fieldValue, alias, paramArrayList); } else { // 字段查询 if (!"GLOBALTYPE".equals(queryType)) { for (Object field : array) { String filedName = field != null ? field.toString() : ""; if (!excludeFieldMap.get().containsKey(filedName)) { Object fieldValue = valueMap.get(filedName); if (QueryType.EMPTY.equals(queryType) || QueryType.NOT_EMPTY.equals(queryType)) { fieldValue = null; } // 将设置过的字段保存到数组中 usedFieldMap.put(filedName, filedName); // 构建查询语句 buildSQL(sb, queryType, filedName, fieldValue, alias, paramArrayList); } } } } } } // 对没有设置条件的字段进行查询类型设置 String queryType = QueryType.EQUAL; if (conditionMap.get().containsKey("GLOBALTYPE")) { String[] typeArray = (String[]) conditionMap.get().get("GLOBALTYPE"); queryType = typeArray[0]; } // 对未使用过的字段进行build for (String field : fieldNames) { if (!usedFieldMap.containsKey(field)) { Object fieldValue = valueMap.get(field); // 构建查询语句 buildSQL(sb, queryType, field, fieldValue, alias, paramArrayList); } } // 合并传入的参数到参数对象中 sql.set(sb.toString()); paramList.set(paramArrayList); conditionMap.set(new HashMap<String, Object[]>()); // 清空本次的条件map excludeFieldMap.set(new HashMap<String, String>()); // 清空本次的排除字段 } catch (Exception e) { log.error("Conditions构建SQL语句出现错误,请仔细检查!", e); e.printStackTrace(); } } /** * ************************************************************************* 构建SQL语句 * * @param sb 用于拼接SQL语句 * @param queryType 查询类型 * @param fieldName 字段名称 * @param fieldValue 字段值 * @param alias 别名 */ @SuppressWarnings("rawtypes") private void buildSQL( StringBuilder sb, String queryType, String fieldName, Object fieldValue, String alias, ArrayList<Object> params) { // 非空的时候进行设置 if (!JFinalExtKit.isNullOrEmpty(fieldValue) && !JFinalExtKit.isNullOrEmpty(fieldName)) { if (QueryType.EQUAL.equals(queryType)) { sb.append(" and " + alias + fieldName + " = ? "); params.add(fieldValue); } else if (QueryType.NOT_EQUAL.equals(queryType)) { sb.append(" and " + alias + fieldName + " <> ? "); params.add(fieldValue); } else if (QueryType.LESS_THEN.equals(queryType)) { sb.append(" and " + alias + fieldName + " < ? "); params.add(fieldValue); } else if (QueryType.LESS_EQUAL.equals(queryType)) { sb.append(" and " + alias + fieldName + " <= ? "); params.add(fieldValue); } else if (QueryType.GREATER_THEN.equals(queryType)) { sb.append(" and " + alias + fieldName + " > ? "); params.add(fieldValue); } else if (QueryType.GREATER_EQUAL.equals(queryType)) { sb.append(" and " + alias + fieldName + " >= ? "); params.add(fieldValue); } else if (QueryType.FUZZY.equals(queryType)) { sb.append(" and " + alias + fieldName + " like ? "); params.add("%" + fieldValue + "%"); } else if (QueryType.FUZZY_LEFT.equals(queryType)) { sb.append(" and " + alias + fieldName + " like ? "); params.add("%" + fieldValue); } else if (QueryType.FUZZY_RIGHT.equals(queryType)) { sb.append(" and " + alias + fieldName + " like ? "); params.add(fieldValue + "%"); } else if (QueryType.IN.equals(queryType)) { try { List list = (List) fieldValue; StringBuffer instr = new StringBuffer(); sb.append(" and " + alias + fieldName + " in ("); for (Object obj : list) { instr.append(StringUtils.isNotBlank(instr) ? ",?" : "?"); params.add(obj); } sb.append(instr + ") "); } catch (Exception e) { throw new RuntimeException( "使用IN条件的时候传入的值必须是个List对象,否则将会转换出错!例如将 in('1','2','3')中的'1','2','3'分为三个分别添加到List中做为值传入.", e); } } else if (QueryType.NOT_IN.equals(queryType)) { try { List list = (List) fieldValue; StringBuffer instr = new StringBuffer(); sb.append(" and " + alias + fieldName + " not in ("); for (Object obj : list) { instr.append(StringUtils.isNotBlank(instr) ? ",?" : "?"); params.add(obj); } sb.append(instr + ") "); } catch (Exception e) { throw new RuntimeException( "使用NOT IN条件的时候传入的值必须是个List对象,否则将会转换出错!例如将 not in('1','2','3')中的'1','2','3'分为三个分别添加到List中做为值传入.", e); } } } else { if (QueryType.EMPTY.equals(queryType)) { sb.append(" and " + alias + fieldName + " is null "); } else if (QueryType.NOT_EMPTY.equals(queryType)) { sb.append(" and " + alias + fieldName + " is not null "); } } } /** * 获取sql语句 * * @return 封装好的sql语句 */ public String getSql() { return sql.get(); } /** * 查询条件的值 * * @return List<Object> 查询条件的值 */ public List<Object> getParamList() { return paramList.get(); } }
/** * ************************************************************************* 构建条件语句 * * @param alias 别名 * @param fieldNames 所有查询的字段名称 * @param valueMap 所有的值的map */ private void buildCondition(String alias, String[] fieldNames, Map<String, Object> valueMap) { try { // 构建条件前先清空变量 sql.set(""); paramList.set(new ArrayList<Object>()); // 用于存放参数列表 ArrayList<Object> paramArrayList = new ArrayList<Object>(); StringBuilder sb = new StringBuilder(); // 所有的字段名称 Map<String, String> usedFieldMap = new HashMap<String, String>(); if (!conditionMap.get().isEmpty()) { for (Entry<String, Object[]> map : conditionMap.get().entrySet()) { String queryType = map.getKey(); Object[] array = map.getValue(); if (queryType.indexOf("#") > 0) { // 传值查询 String fieldQueryType = queryType.split("#")[0]; String fieldName = array[0] != null ? array[0].toString() : ""; Object fieldValue = array[1]; // 将设置过的字段保存到数组中 usedFieldMap.put(fieldName, fieldName); // 构建SQL语句 buildSQL(sb, fieldQueryType, fieldName, fieldValue, alias, paramArrayList); } else { // 字段查询 if (!"GLOBALTYPE".equals(queryType)) { for (Object field : array) { String filedName = field != null ? field.toString() : ""; if (!excludeFieldMap.get().containsKey(filedName)) { Object fieldValue = valueMap.get(filedName); if (QueryType.EMPTY.equals(queryType) || QueryType.NOT_EMPTY.equals(queryType)) { fieldValue = null; } // 将设置过的字段保存到数组中 usedFieldMap.put(filedName, filedName); // 构建查询语句 buildSQL(sb, queryType, filedName, fieldValue, alias, paramArrayList); } } } } } } // 对没有设置条件的字段进行查询类型设置 String queryType = QueryType.EQUAL; if (conditionMap.get().containsKey("GLOBALTYPE")) { String[] typeArray = (String[]) conditionMap.get().get("GLOBALTYPE"); queryType = typeArray[0]; } // 对未使用过的字段进行build for (String field : fieldNames) { if (!usedFieldMap.containsKey(field)) { Object fieldValue = valueMap.get(field); // 构建查询语句 buildSQL(sb, queryType, field, fieldValue, alias, paramArrayList); } } // 合并传入的参数到参数对象中 sql.set(sb.toString()); paramList.set(paramArrayList); conditionMap.set(new HashMap<String, Object[]>()); // 清空本次的条件map excludeFieldMap.set(new HashMap<String, String>()); // 清空本次的排除字段 } catch (Exception e) { log.error("Conditions构建SQL语句出现错误,请仔细检查!", e); e.printStackTrace(); } }
/** Created by ZaoSheng on 2015/5/24. */ public abstract class JFinalConfig extends com.jfinal.config.JFinalConfig { private static final Logger LOG = Logger.getLogger(JFinalConfig.class); private static final List<String> controlPackage = new ArrayList<String>(); private static final List<String> basePackage = new ArrayList<String>(); /** Scan control */ public abstract void controlSscan(List<String> controlPackage); /** Scan basePackage */ public abstract void componentSscan(List<String> basePackage); /** * 设置数据源 * * @return IDataSourceProvider */ public abstract IDataSourceProvider setDataSource(); /** * controller * * @param me */ @Override public void configRoute(Routes me) { // String path = this.getClass().getClassLoader().getResource("").getPath(); controlSscan(controlPackage); // 获取需要扫描的包 // 扫描器 Scan driven = new Scan(); for (String pake : controlPackage) { Set<Class<?>> clazzs = driven.getClasses(pake); /*System.out.println("pake: " + pake);*/ for (Class<?> clazz : clazzs) { // System.out.println(clazz.getSuperclass()); LOG.info(clazz.getName()); Class<?> superclass = clazz.getSuperclass(); Class<?> jfClz = com.jfinal.core.Controller.class; if (superclass == jfClz || superclass.getSuperclass() == jfClz) { C con = clazz.getAnnotation(C.class); if (null != con) { me.add(con.value(), (Class<? extends Controller>) clazz); } } } } } /** * model * * @param me */ @Override public void configPlugin(Plugins me) { componentSscan(basePackage); IDataSourceProvider iDataSourceProvider = setDataSource(); try { me.add((IPlugin) iDataSourceProvider); } catch (Exception e) { throw new RuntimeException("is not IPlugin type"); } ActiveRecordPlugin arp = new ActiveRecordPlugin(iDataSourceProvider); addActiveRecord(arp); // 加入附加的活动记录 Scan driven = new Scan(); for (String pake : basePackage) { Set<Class<?>> clazzs = driven.getClasses(pake); for (Class<?> clazz : clazzs) { LOG.info(clazz.getName()); Class superClass = clazz.getSuperclass(); Class<?> jfClz = com.jfinal.plugin.activerecord.Model.class; if (superClass == jfClz || superClass.getSuperclass() == jfClz) { M model = clazz.getAnnotation(M.class); if (null != model) { arp.addMapping(model.value(), model.id(), (Class<? extends Model<?>>) clazz); } } } } me.add(arp); } /** * 这里进行附加的活动记录的添加, * * @param arp 活动记录插件 */ public void addActiveRecord(ActiveRecordPlugin arp) { // arp.setShowSql(true);//设置是sql显示开关 } /** * Interceptors * * @param me */ @Override public void configInterceptor(Interceptors me) {} @Override public void configHandler(Handlers me) {} }
/** * 工单model * * @author 陈宇佳 */ @SuppressWarnings("unused") @TableBind(tableName = "com_order") public class Order extends BaseModel<Order> { private static final long serialVersionUID = -3474341426070972713L; private static Logger log = Logger.getLogger(Order.class); public static final Order dao = new Order(); /** * @描述 查询Reports 分页 * * @param pageNumber * @param pageSize * @param where * @param orderby * @param paras * @return */ public Page<Record> findReportsByUserId( int pageNumber, int pageSize, String where, String orderby, Object... paras) { return Db.paginate( pageNumber, pageSize, getSql("order.findOfferQueryBySelect"), getSql("order.findOfferQueryByFrom") + getWhere(where) + orderby, paras); } /** * @描述 查询Report 详细内容 * * @param where * @param paras * @return */ public Record findReportById(String where, Object... paras) { return Db.findFirst( getSql("order.findOrderInfoBySelect") + blank + getSql("order.findOrderInfoByFrom") + getWhere(where), paras); } /** * @描述 查询Operates 分页 * * @param pageNumber * @param pageSize * @param where * @param orderby * @param paras * @return */ public Page<Record> findOperatesByUserId( int pageNumber, int pageSize, String where, String orderby, Object... paras) { return Db.paginate( pageNumber, pageSize, getSql("order.findOfferQueryBySelect"), getSql("order.findOfferQueryByFrom") + getWhere(where) + orderby, paras); } public List<Record> findOperatesByUserId(String where, String orderby, Object... paras) { return Db.find( getSql("order.findOfferQueryBySelect") + getSql("order.findOfferQueryByFrom") + getWhere(where) + orderby, paras); } /** * @描述 查询Operate 详细内容 * * @param where * @param paras * @return */ public Record findOperateById(String where, Object... paras) { return Db.findFirst( getSql("order.findOrderInfoBySelect") + blank + getSql("order.findOrderInfoByFrom") + getWhere(where), paras); } /** * @描述 查询Orders 主页 分页 * * @param pageNumber * @param pageSize * @param where * @param orderby * @param paras * @return */ public Page<Record> findIndexOrders( int pageNumber, int pageSize, String where, String orderby, Object... paras) { return Db.paginate( pageNumber, pageSize, getSql("order.findOfferQueryBySelect"), getSql("order.findOfferQueryByFrom") + getWhere(where) + orderby, paras); } /** * @描述 查询Orders 管理员 不分页 * * @param where * @param orderby * @param paras * @return */ public List<Record> findAdminOrders(String where, String orderby, Object... paras) { return Db.find( getSql("order.findOfferQueryBySelect") + getSql("order.findOfferQueryByFrom") + getWhere(where) + orderby, paras); } public List<Record> exporter(String where, String orderby, Object... paras) { return Db.find(getSql("order.exporter") + getWhere(where) + orderby, paras); } public List<Record> exporterWithComments(String where, String orderby, Object... paras) { return Db.find(getSql("order.exporterWithComments") + getWhere(where) + orderby, paras); } /** * @描述 查询order 管理员 * * @param where * @param paras * @return */ public Record query(String where, Object... paras) { return Db.findFirst( getSql("order.findOfferQueryBySelect") + getSql("order.findOfferQueryByFrom") + getWhere(where), paras); } /** * 获得所有故障类型(弃用) * * @return */ @Deprecated public List<Record> getAllType() { return Db.find("select * from com_type"); } /** * @描述 如果attr,如description的长度超过30(随机,由Random决定),则后面用...代替。 * * @param page * @param paras */ public void format(Page<Record> page, String... paras) { for (Record record : page.getList()) { for (String attr : paras) { record.set( attr, StringUtils.abbreviate(record.getStr(attr), (new Random().nextInt(2) + 35))); } } } public void format(List<Record> list, String... paras) { for (Record record : list) { for (String attr : paras) { record.set( attr, StringUtils.abbreviate(record.getStr(attr), (new Random().nextInt(2) + 35))); } } } /** * 根据status获取Order。 * * @param paras * @return */ public List<Order> findOrderByStatus(Object... paras) { return find("select * from com_order where status=?", paras); } /** * 根据条件获取Order。 * * @param where * @param paras * @return */ public Page<Record> findExceptionOrders( int pageNumber, int pageSize, String where, Object... paras) { return Db.paginate( pageNumber, pageSize, getSql("order.findOrderInfoBySelect"), getSql("order.findOrderInfoByFrom") + getWhere(where), paras); } }
public void save() { try { boolean settleTypeFlag = false; Jhpay jhpay = null; Ckjhcheck m = getModel(Ckjhcheck.class, "ckjhcheck"); Jbsupplier supplier = getModel(Jbsupplier.class, "supplier"); Jbstore store = getModel(Jbstore.class, "store"); m.set("SupplierCode", supplier.getStr("supplierCode")); m.set("StoreCode", store.getStr("StoreCode")); Double amount = Double.parseDouble(getPara("amount")); m.set("CKAmount", amount); if (getPara("typeFlg") != null && getParaToInt("typeFlg") == 1) { m.set("SettleTypeFlag", getParaToInt("typeFlg")); settleTypeFlag = true; } if (m.getLong("id") != null) { m.update(); } else { m.save(); } // 当面付模式 if (settleTypeFlag) { jhpay = Jhpay.dao.findFirst("select * from jhpay where BillOrderNo = ?", m.getStr("OrderDate")); if (jhpay == null) { // 生成付款单信息 jhpay = new Jhpay(); synchronized (lock) { String ordCdNw = BsUtil.getMaxOrdNo("OrderCode", "CF", "jhpay"); jhpay.set("OrderCode", ordCdNw); } jhpay.set( "OrderDate", DateUtil.string2Date( DateUtil.date2String(new Date(), DateUtil.FORMAT_DATE), DateUtil.FORMAT_DATE)); jhpay.set("SupplierCode", m.get("SupplierCode")); jhpay.set("DeptCode", m.get("DeptCode")); jhpay.set("EmpCode", m.get("EmpCode")); jhpay.set("PayType", BsUtil.DIR_PAY); jhpay.set("BankNo", supplier.get("BankNo")); jhpay.set("Amount", amount); jhpay.set("BillOrderNo", m.get("OrderCode")); Record man = getCurrentUser(); jhpay.set("checkman", man.getStr("usr_name")); jhpay.set("CheckDate", new Date()); jhpay.set("CheckFlag", 1); jhpay.save(); Jhpaydetail jhpaydetail = new Jhpaydetail(); jhpaydetail.set("OrderCode", m.get("OrderCode")); jhpaydetail.set("PayOrderNo", jhpay.get("OrderCode")); jhpaydetail.set("CollateType", "采购入库单"); jhpaydetail.set("NowCollated", amount); jhpaydetail.set("Adjust", 0); jhpaydetail.set("Amount", amount); } } String orderCode = m.get("OrderCode"); // 保存明细 int size = 0; // 通过【新建商品明细】按钮新追加记录 String[] index = getParaValues("lineId"); size = Db.queryLong( "select count(*) from ckjhcheckdetail where orderCode = '" + orderCode + "'") .intValue(); if (!(index == null || index.length == 0)) { size = size + index.length; } // 不足10条,补足10条显示并保存 if (size < 10) { size = 10; } for (int i = 0; i < size; i++) { Ckjhcheckdetail md = getModel(Ckjhcheckdetail.class, "ckjhcheckDetail" + i); Jbgoods goods = getModel(Jbgoods.class, "goods" + i); if (goods.getStr("GoodsCode") != null) { md.set("GoodsCode", goods.get("GoodsCode")); Ckjhcheckdetail tmp = Ckjhcheckdetail.dao.findById(md.getLong("id")); if (tmp != null) { md.set("price", goods.get("BRefPrice")); md.update(); } else { md.set("ordercode", orderCode); md.set("price", goods.get("BRefPrice")); md.save(); } } } toDwzJson(200, "保存成功!", navTabId, "closeCurrent"); } catch (Exception e) { log.error("保存仓库分类异常", e); toDwzJson(300, "保存异常!"); } }
/** 角色 */ @Control(controllerKey = "/role") public class RoleController extends BaseController { private static final Logger LOG = Logger.getLogger(RoleController.class); public void index() { List<SysRolesModel> role = SysRolesModel.dao.allRoles(); List<SysMenusModel> menu = SysMenusModel.dao.allMenus(); setAttr("rolesJson", JsonKit.toJson(role)); setAttr("menusJson", JsonKit.toJson(menu)); render("tissue/role_mgr"); } public void list() { setAttr(DATA, SysRolesModel.dao.getRoleByParent(getUser().getInt("roleID"))); setAttr(RESULT, true); renderJson(); } public void add() { SysRolesModel menu = getModelWithOutModelName(SysRolesModel.class, true); if (menu.save()) { setAttr(MESSAGE, "新增成功!"); setAttr("id", menu.get("id")); setAttr(RESULT, true); DisplayTool.removeCache(DisplayTool.ROLE_KEY); } else { setAttr(RESULT, false); setAttr(MESSAGE, "新增失败!"); } renderJson(); } public void update() { SysRolesModel role = getModelWithOutModelName(SysRolesModel.class, true); if (role.get("id") != null && role.update()) { setAttr(RESULT, true); setAttr(MESSAGE, "更新成功!"); DisplayTool.removeCache(DisplayTool.ROLE_KEY); } else { setAttr(RESULT, false); setAttr(MESSAGE, "更新失败!"); } renderJson(); } public void del() { Integer id = getParaToInt("id"); if (id != null && SysRolesModel.dao.deleteById(id)) { setAttr(RESULT, true); setAttr(MESSAGE, "删除成功!"); } else { setAttr(RESULT, false); setAttr(MESSAGE, "删除失败!"); } renderJson(); } public void roleMenu() { Integer id = getParaToInt("id"); if (id != null) { setAttr(RESULT, true); setAttr(DATA, SysRoleMenuModel.dao.getRoleMenus(id)); } else { setAttr(RESULT, false); setAttr(MESSAGE, "参数错误,获取数据失败!"); } renderJson(); } public void menuChecked() { Boolean checked = getParaToBoolean("checked"); SysRoleMenuModel roleMenu = getModelWithOutModelName(SysRoleMenuModel.class, true); if (checked != null && roleMenu.get("roleID") != null && roleMenu.get("menuID") != null) { setAttr(RESULT, true); SysRoleMenuModel.dao.changeRoleMenu(roleMenu, checked); setAttr(MESSAGE, "修改成功!"); } else { setAttr(RESULT, false); setAttr(MESSAGE, "参数错误,获取数据失败!"); } renderJson(); } }
/** * Redis插件 * * @author june 2015年3月2日 下午3:02:57 */ public class RedisPlugin implements IPlugin { /** 集群连接池 */ private static ShardedJedisPool shardedJedisPool; /** 配置文件路径 */ private String configurationFileName = "redis"; private final Logger logger = Logger.getLogger(getClass()); public RedisPlugin() {} public RedisPlugin(String configurationFileName) { this.configurationFileName = configurationFileName; } @Override public boolean start() { createShardedJedisPool(); RedisKit.init(shardedJedisPool); logger.info("初始化redis插件成功"); return true; } /** 初始化连接池 */ private void createShardedJedisPool() { ResourceBundle bundle = ResourceBundle.getBundle(configurationFileName); if (bundle == null) { throw new IllegalArgumentException(configurationFileName + " is not found!"); } JedisPoolConfig config = new JedisPoolConfig(); config.setMaxTotal(Integer.valueOf(bundle.getString("redis.pool.maxTotal"))); config.setMaxIdle(Integer.valueOf(bundle.getString("redis.pool.maxIdle"))); config.setMaxWaitMillis(Long.valueOf(bundle.getString("redis.pool.maxWait"))); config.setTestOnBorrow(Boolean.valueOf(bundle.getString("redis.pool.testOnBorrow"))); config.setTestOnReturn(Boolean.valueOf(bundle.getString("redis.pool.testOnReturn"))); List<JedisShardInfo> list = createJedisShardInfoList(bundle); shardedJedisPool = new ShardedJedisPool(config, list); } /** * 构建redis集群配置信息 * * @param bundle * @return */ private List<JedisShardInfo> createJedisShardInfoList(ResourceBundle bundle) { List<JedisShardInfo> list = new LinkedList<JedisShardInfo>(); String defaultRedisPort = bundle.getString("redis.port"); for (int i = 0; i < 10; i++) { if (!bundle.containsKey("redis" + (i == 0 ? "" : i) + ".ip")) { continue; } String redisIp = bundle.getString("redis" + (i == 0 ? "" : i) + ".ip"); String redisPort = bundle.getString("redis" + (i == 0 ? "" : i) + ".port"); if (StringUtils.isEmpty(redisPort)) { redisPort = defaultRedisPort; } if (StringUtils.isNotEmpty(redisIp) && StringUtils.isNotEmpty(redisPort)) { JedisShardInfo jedisShardInfo = new JedisShardInfo(redisIp, redisPort); logger.info("初始化redis,redis" + (i == 0 ? "" : i) + ".ip:" + redisIp + ",端口:" + redisPort); list.add(jedisShardInfo); } } return list; } @Override public boolean stop() { if (shardedJedisPool != null) { shardedJedisPool.destroy(); } return true; } }