入库统计报表

354798ggg

2023-12-01 75339563cebc86759a1e8addab9ab5382b4fd1a1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
package com.product.project.management.service;
 
import com.product.core.dao.BaseDao;
import com.product.core.entity.DataTableEntity;
import com.product.core.entity.FieldSetEntity;
import com.product.core.permission.PermissionService;
import com.product.core.service.support.AbstractBaseService;
import com.product.core.service.support.QueryFilterService;
import com.product.project.management.config.Cmnconst;
import com.product.util.BaseUtil;
 
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
 
/**
 * 实现功能：
 *项目出库
 * @author 作者[zm]
 * @version 1.0.00  2023-08-01 16:44
 */
@Component
public class ProjectOutService  extends AbstractBaseService {
    
    @Autowired
    PermissionService permissionService;
    
    @Autowired
    QueryFilterService queryFilterService;
    
    
    public DataTableEntity listOutBound(FieldSetEntity fse) {
        
        String filter = fse.getString("filter");
        String searchFilter = queryFilterService.getQueryFilter(fse);
        if (!BaseUtil.strIsNull(searchFilter)) {
            filter += " AND " + searchFilter;
        }
        String limitFilter = permissionService.getDataFilter(Cmnconst.PRODUCT_PROJECT_QXLW, "project_leader,materialman");
        if (!BaseUtil.strIsNull(limitFilter)) {
            filter += " AND " + limitFilter;
        }
        
        String sql = "SELECT * FROM product_project_outbound A LEFT JOIN product_project_qxlw B ON A.project_uuid = B.uuid  WHERE " + filter;
        DataTableEntity dt = baseDao.listTable(sql, new Object[] {}, fse.getInteger(Cmnconst.PAGESIZE), fse.getInteger(Cmnconst.CPAGE));
        dt.getMeta().addAliasTable("product_project_outbound", "A");
        dt.getMeta().addAliasTable("product_project_qxlw", "B");
        baseDao.loadPromptData(dt);
        return dt;
    }
    
    /**
     * 出库撤销
     */
    @Autowired
    BaseDao baseDao;
    public void cancelOutbound(FieldSetEntity fse) {
        fse.setValue("flow_flag",0);
        baseDao.saveFieldSetEntity(fse);
    }
}