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);
    }
}