(1) mini ui 插件获取当前时间
setEvents: function() {
var me = this;
mini.get('search').on('click', function() {
me.loadGrid();
});
$('#basesalesrecord-grid').delegate('.detail', 'click', function() {
me.detail($(this).data('id'));
});
mini.get("date-search").setValue(new Date());//mini 获取当前时间
},
(2) 配字典值
1.首先在数据库里配好,dic-type ,dic-name
2.字典 js 写入
//栽培模式
CULTIVATION_TYPE: {//对应字段的名字
TYPE: 8957300300000,
TREE_ROOTSTOCK: { //name 的英文名字
NAME: '乔砧',
VALUE: '8957300300001'
},
DWARFING_STOCKS: {
NAME: '矮砧',
VALUE: '8957300300002'
}
},
3.使用到的界面加入路径
mini.get("status").setUrl(contextPath + '/dict-data/data-by-type.html?value=' + Dictionary.STATUS_TYPE.TYPE);
4.切记 jsp里使用字典值的发改为
(5) 输入框的模糊查询
(9)js 字段显示时间
(10)返回按钮
valueField="value" 当关联的是表的时候为 id
(3)下拉框的配置
jsp页面
(4)数字的模糊查询
<input class='mini-combobox' showNullItem="true" nullItemText="全部" emptyText="物候期" id="fkPhenologicalPeriodId-search" textField="name" valueField="id" name="fkPhenologicalPeriodId" />
js
this.grid.setUrl(contextPath + '/cultivationplan-cultivationplan/cultivationplan-grid-load-data.html');
jsp
<input class='mini-filteredit' filterValue=">" filterData="filters" id='quantity' name="quantity" emptyText="数量" />
<script>
var filters = [{
text: '大于',
value: '>'
}, {
text: '小于',
value: '<'
}, {
text: '大于等于',
value: '>='
}, {
text: '小于等于',
value: '<='
}, {
text: '等于',
value: '='
}];
</script>
DAO
if (StringUtils.isNotBlank(baseSalesRecordParamVo.getQuantity())) {
String quantity = baseSalesRecordParamVo.getQuantity();
if (StringUtils.isNotBlank(quantity.substring(quantity.indexOf(":"), quantity.length()))) {
paramSql.append(" AND base_sales_record.QUANTITY " + quantity.substring(0, quantity.indexOf(":"))
+ quantity.substring(quantity.indexOf(":") + 1, quantity.length()));
}
}
DAO
if (StringUtils.isNotBlank(baseParcelParamVo.getName())) {
baseParcelParamVo.setName("%" + baseParcelParamVo.getName() + "%");
paramSql.append(" AND base_parcel.NAME like :name ");
}
简单String查询 if (StringUtils.isNotBlank(baseParcelParamVo.getFkFarmerId())) {
paramSql.append(" AND base_parcel.FK_FARMER_ID = :fkFarmerId ");
简单的int 查询
/*
* if (null != baseSalesRecordParamVo.getQuantity()) {
* paramSql.append(" AND base_sales_record.QUANTITY= :quantity ");
* }
(6)sql 拼接过滤已经删除的数据 paramSql.append(" AND base_sales_record.DICT_DELETED_VALUE = 1110040000000002 ");
(7) 页面计算数值
Service
List<BaseSalesRecordGridVo> salesRecordGridVos = pageVo.getData();
for (BaseSalesRecordGridVo baseSalesRecordGridVo : salesRecordGridVos) {
if (null != baseSalesRecordGridVo.getQuantity() && null != baseSalesRecordGridVo.getPrice()) {
baseSalesRecordGridVo.setTotalCost(baseSalesRecordGridVo.getQuantity().doubleValue()
* baseSalesRecordGridVo.getPrice().doubleValue());
}
}
return GsonUtil.toJsonByDateTime24(pageVo);
}
vo 里自己添加字段
(8)非空校验
字段前边加入 <span class="required">*</span>
div 中加入 required="true"
(9)js 字段显示时间
{
header: "发布时间",
field: "lastUpdateTime",
allowSort: true,
width: "$field.gridWidth",
align: "center",
headerAlign: "center",
dateFormat: "yyyy-MM-dd"//加上这个
},
<div class="ibox-tools">
<a class="btn btn-default marr btn-sm" href="javascript:;" onclick="window.history.back();">
<i class="fa fa-reply"></i> 返 回
</a>
</div>
(10)返回按钮
<div class="ibox-tools">
<a class="btn btn-default marr btn-sm" href="javascript:;" onclick="window.history.back();">
<i class="fa fa-reply"></i> 返 回
</a>
</div>