[DEBUG] 2019-07-24 20:21:14,293 org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3877) - ClusterManager: Check-in complete.
[DEBUG] 2019-07-24 20:21:15,471 org.nutz.mvc.impl.UrlMappingImpl.get(UrlMappingImpl.java:101) - Found mapping for [GET] path=/platform/cust/order/editUser/cb98483c016c4f22b6ceffd16fc3177d : CustOrderController.editUser(CustOrderController.java:120)
[DEBUG] 2019-07-24 20:21:15,471 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:166) - Get 'custOrderController'<class cn.wizzer.app.web.modules.controllers.platform.cust.CustOrderController>
[DEBUG] 2019-07-24 20:21:15,473 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) - SELECT * FROM cust_order WHERE id=?
| 1 |
|----------------------------------|
| cb98483c016c4f22b6ceffd16fc3177d |
For example:> "SELECT * FROM cust_order WHERE id='cb98483c016c4f22b6ceffd16fc3177d'"
[DEBUG] 2019-07-24 20:21:15,481 cn.wizzer.app.web.commons.processor.LogTimeProcessor.process(LogTimeProcessor.java:26) - [GET ]URI=/platform/cust/order/editUser/cb98483c016c4f22b6ceffd16fc3177d 10ms
@At
@Ok("json:full")
@RequiresPermissions("platform.cust.order")
public Object userData(@Param("orderid") String orderid, @Param("username") String username, @Param("country") String country, @Param("field") String field, @Param("language") String language, @Param("person") String person, @Param("length") int length, @Param("start") int start, @Param("draw") int draw, @Param("::order") List<DataTableOrder> order, @Param("::columns") List<DataTableColumn> columns){
String sql = "select a.* from cust_user a, cust_user_order b where a.id=b.userId";
if (!Strings.isBlank(orderid)){
sql += "amd b.orderid='" + orderid +"'";
}
if (!Strings.isBlank(username)){
sql += "and a.username like '%" + username +"%'";
}
String s = sql;
if (order != null && order.size() > 0) {
for (DataTableOrder o : order) {
DataTableColumn col = columns.get(o.getColumn());
s += "order by a." + Sqls.escapeSqlFieldValue(col.getData()).toString() + " " + o.getDir();
}
}
return orderService.data(length, start, draw, Sqls.create(sql), Sqls.create(s));
}
"ajax": {
"url": "${base}/platform/cust/order/selectData",
"type": "post",
"data": function (d) {
d.orderid = $('#orderid').val();
d.username = $('#username').val();
}
},
[DEBUG] 2019-07-24 20:25:55,193 org.nutz.mvc.impl.UrlMappingImpl.print(UrlMappingImpl.java:146) - '/platform/cust/order/selectuser' >> (CustOrderController.java:149).selectUser : void | @Ok(beetl:/platform/cust/order/selectUser.html) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)