package com.yuanchung.sales.dao.order;

import java.util.List;

import org.springframework.dao.DataAccessException;

import com.yuanchung.sales.model.order.Order;
import com.yuanchung.sales.model.user.User;
import com.yuanchung.sales.model.businessOpportunity.BusinessOpportunity;
import com.yuanchung.sales.model.businessOpportunity.ContactBusiopport;
import com.yuanchung.sales.model.customer.ConRole;
import com.yuanchung.sales.model.customer.Customer;
import com.yuanchung.sales.model.customer.CustomerContact;
import com.yuanchung.sales.util.Constants;
import com.yuanchung.sales.model.userDefined.UserDefined;
import com.yuanchung.sales.model.userDefined.UserField;
import com.yuanchung.sales.model.userDefined.UserFilter;

public interface OrderDAO {

	// 根據ID查找客戶
	public Customer getCustomerById(int customerId) throws DataAccessException;

	// 根據用戶查找客戶
	public List getCustomerByUser(User user, int flag)
			throws DataAccessException;

	// 根據名稱模糊查找客戶
	public List getCustomerByNamelike(User user, String customerName)
			throws DataAccessException;

	/*
	 * 暫時不做創建新選項 //保存用戶自定義選項 public void saveUserDefined(UserDefined
	 * userDefined) throws DataAccessException;
	 * 
	 * //保存自定義選項過濾條件 public void saveUserFilter(UserFilter userFilter) throws
	 * DataAccessException;
	 * 
	 * //保存用戶顯示字段 public void saveUserField(UserField userField) throws
	 * DataAccessException;
	 * 
	 * //根據用戶和類型查找選項 public List getUserDefinedByUserAndType(User user, int
	 * type) throws DataAccessException;
	 * 
	 * //根據id搜索選項 public UserDefined getUserDefinedById(int userDefinedId)
	 * throws DataAccessException;
	 * 
	 * //根據選項查找過濾條件 public List getUserFilterByOption(UserDefined userDefined)
	 * throws DataAccessException;
	 * 
	 * //根據選項搜索顯示字段 public UserField getUserFieldByOption(UserDefined
	 * userDefined) throws DataAccessException;
	 * 
	 * //更新用戶選項 public void updateUserDefined(UserDefined userDefined) throws
	 * DataAccessException;
	 * 
	 * //根據id查詢過濾條件 public UserFilter getUserFilter(int id) throws
	 * DataAccessException;
	 * 
	 * //更新過濾條件 public void updateUserFilter(UserFilter userFilter) throws
	 * DataAccessException;
	 * 
	 * //修改顯示字段 public void updateUserField(UserField userField) throws
	 * DataAccessException;
	 */

	// 1.查找所有的訂單
	public List getAllOrder(User user) throws DataAccessException;

	// 2.根據客戶名稱查找訂單
	public List getOrderByCustomerName(String customerName) throws DataAccessException;

	// 3.保存訂單
	public void save(Order order) throws DataAccessException;

	// 4.修改訂單
	public void update(Order order) throws DataAccessException;

	// 5.刪除訂單
	public void delete(Order order) throws DataAccessException;

	// 6.搜索前幾張訂單的記錄
	public List getTopOrder() throws DataAccessException;

	// 7.搜索刪除狀態的訂單
	public List getOrderByDelete(User user, int flag)
			throws DataAccessException;

	// 8.查找最近訂單
	public Order getLastestOrder() throws DataAccessException;
	
	// 9.根據ID查找聯系人
	public CustomerContact getCustomerContactById(int contactId) throws DataAccessException ;
	
	//根據訂單號查找訂單
	public  Order getOrderById(int orderId) throws DataAccessException;
}