package com.web.supplier.service.internal;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletResponse;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.PageRequest;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;

import com.app.base.data.ApiResponseResult;
import com.utils.UserUtil;
import com.web.supplier.service.SearchService;

@Service(value = "SearchService")
@Transactional(propagation = Propagation.REQUIRED)
public class Searchlmpl extends PrcUtils implements SearchService {

	/**
	 * 查询-获取采购订单列表-2022-6-8
	 **/
	public ApiResponseResult getPurchaseOrder(String billNo, String materialNo, String begTime, String endTime,
			PageRequest pageRequest) throws Exception {
		List<Object> list = getPurchaseOrderPrc(UserUtil.getSessionUser().getFcompany() + "", billNo,
				UserUtil.getSessionUser().getFcode() + "", materialNo, begTime, endTime, pageRequest.getPageSize(),
				pageRequest.getPageNumber());
		if (!list.get(0).toString().equals("0")) {// 存储过程调用失败 //判断返回游标
			return ApiResponseResult.failure(list.get(1).toString());
		}
		Map map = new HashMap();
		map.put("total", list.get(2));
		map.put("rows", list.get(3));
		return ApiResponseResult.success().data(map);
	}
	
	/**
	 * 查询-获取送货计划列表，通过采购订单带出-2022-6-8 
	 **/
	public ApiResponseResult getDeliveryPlanByOrder(String materialNo,PageRequest pageRequest) throws Exception {
		List<Object> list = getDeliveryPlanByOrderPrc(UserUtil.getSessionUser().getFcompany() + "", 
				materialNo, pageRequest.getPageSize(),
				pageRequest.getPageNumber());
		if (!list.get(0).toString().equals("0")) {// 存储过程调用失败 //判断返回游标
			return ApiResponseResult.failure(list.get(1).toString());
		}
		Map map = new HashMap();
		map.put("total", list.get(2));
		map.put("rows", list.get(3));
		return ApiResponseResult.success().data(map);
	}

	/**
	 * 查询-获取送货单明细从表-2022-6-20
	 **/
	public ApiResponseResult getDeliveryDet(String billNo,String lineNo,String materialNo,PageRequest pageRequest)throws Exception {
		List<Object> list = getDeliveryDetPrc(UserUtil.getSessionUser().getFcompany() + "", billNo,lineNo,
				materialNo, pageRequest.getPageSize(),
				pageRequest.getPageNumber());
		if (!list.get(0).toString().equals("0")) {// 存储过程调用失败 //判断返回游标
			return ApiResponseResult.failure(list.get(1).toString());
		}
		Map map = new HashMap();
		map.put("total", list.get(2));
		map.put("rows", list.get(3));
		return ApiResponseResult.success().data(map);
	}

	/**
	 * 查询-获取条码历史记录-2022-6-20
	 **/
	public ApiResponseResult getBarcodeHistory(String billNo,String begTime, String endTime,String materialNo,
			String materialName,String barcode, PageRequest pageRequest)throws Exception {
		List<Object> list = getBarcodeHistoryPrc(UserUtil.getSessionUser().getFcompany() + "", billNo,
				UserUtil.getSessionUser().getFcode() + "", begTime,endTime,materialNo, materialName,
				barcode,pageRequest.getPageSize(),pageRequest.getPageNumber());
		if (!list.get(0).toString().equals("0")) {// 存储过程调用失败 //判断返回游标
			return ApiResponseResult.failure(list.get(1).toString());
		}
		Map map = new HashMap();
		map.put("total", list.get(2));
		map.put("rows", list.get(3));
		return ApiResponseResult.success().data(map);
	}
	
	/**
	 * 查询-获取送货单据-2022-6-21
	 **/
	public ApiResponseResult getDeliveryRecord(String deliveryNo,String billNo, String begTime, String endTime, String materialNo,
			String materialName, PageRequest pageRequest)throws Exception {
		List<Object> list = getDeliveryRecordPrc(UserUtil.getSessionUser().getFcompany() + "",deliveryNo, billNo,
				UserUtil.getSessionUser().getFcode() + "", begTime,endTime,materialNo, materialName,
				pageRequest.getPageSize(),pageRequest.getPageNumber());
		if (!list.get(0).toString().equals("0")) {// 存储过程调用失败 //判断返回游标
			return ApiResponseResult.failure(list.get(1).toString());
		}
		Map map = new HashMap();
		map.put("total", list.get(2));
		map.put("rows", list.get(3));
		return ApiResponseResult.success().data(map);
	}
	
	/**
	 * 查询-获取送货计划-2022-6-21
	 **/
	public ApiResponseResult getDeliveryPlan(String planOrder,String materialNo,String materialName, 
			String begTime, String endTime,PageRequest pageRequest)throws Exception {
		List<Object> list = getDeliveryPlanPrc(UserUtil.getSessionUser().getFcompany() + "",UserUtil.getSessionUser().getFcode() + "",
				planOrder, begTime,endTime,materialNo, materialName,pageRequest.getPageSize(),pageRequest.getPageNumber());
		if (!list.get(0).toString().equals("0")) {// 存储过程调用失败 //判断返回游标
			return ApiResponseResult.failure(list.get(1).toString());
		}
		Map map = new HashMap();
		map.put("total", list.get(2));
		map.put("rows", list.get(3));
		return ApiResponseResult.success().data(map);
	}
}