354798ggg
2023-10-30 a44e41f30ec70520528a5a089d38eb90d78b6842
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
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.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;
    
    
    public DataTableEntity listOutBound(Integer cpage, Integer pageSize, String filter) {
        
        String queryFilter = permissionService.getDataFilter(Cmnconst.PRODUCT_PROJECT_QXLW, "project_leader,materialman");
        if (!BaseUtil.strIsNull(queryFilter)) {
            filter += " AND " + queryFilter;
        }
        
        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[] {}, pageSize, cpage);
        baseDao.loadPromptData(dt);
        return dt;
    }
    
    /**
     * 出库撤销
     */
    @Autowired
    BaseDao baseDao;
    public void cancelOutbound(FieldSetEntity fse) {
        fse.setValue("flow_flag",0);
        baseDao.saveFieldSetEntity(fse);
    }
}