|
两张表的关系是这样的
现在我修改mporder_detail 的查询queryaction ,其中的sql字段填写
- SELECT d.detailID,d.porderID,d.factory,d.styleCode,d.itemCode,
- d.orderNum,d.endTime,SUM(t.amount) AS sum FROM mporder_detail d LEFT JOIN mporder_track t ON d.detaiID = t.detailID WHERE (t.processName = :search) or (0=:useSearch)
复制代码 js文件中的设置:
- Model.prototype.detailDataBeforeRefresh = function(event){
- var searchVal = "生产中";
- var data = event.source;
- data.filters.setVar("search",searchVal);
- data.filters.setVar("useSearch",searchVal?1:0);
- };
复制代码
结果运行报错:
这个怎么解决呢?
|
|