package com.yuanchung.sales.dao.service;

import java.util.Date;
import java.util.List;
import java.util.Set;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.LockMode;
import org.springframework.context.ApplicationContext;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.yuanchung.sales.model.customer.Customer;
import com.yuanchung.sales.model.customer.CustomerContact;
import com.yuanchung.sales.model.service.Category;
import com.yuanchung.sales.model.service.ProcessCource;
import com.yuanchung.sales.model.service.ServiceOrder;
import com.yuanchung.sales.model.service.ServiceOrderFile;
import com.yuanchung.sales.model.user.User;
import com.yuanchung.sales.model.userDefined.UserDefined;
import com.yuanchung.sales.model.userDefined.UserField;
import com.yuanchung.sales.model.userDefined.UserFilter;
import com.yuanchung.sales.util.Page;

/**
 * A data access object (DAO) providing persistence and search support for
 * ServiceOrder entities. Transaction control of the save(), update() and
 * delete() operations can directly support Spring container-managed
 * transactions or they can be augmented to handle user-managed Spring
 * transactions. Each of these methods provides additional information for how
 * to configure it for the desired type of transaction control.
 * 
 * @see com.yuanchung.sales.hibernate.ServiceOrder
 * @author MyEclipse Persistence Tools
 */

public interface ServiceOrderDAO {

	public void save(ServiceOrder transientInstance) ;

	public void delete(ServiceOrder persistentInstance) ;

	public ServiceOrder findById(java.lang.Integer id) ;

	public List findByExample(ServiceOrder instance) ;

	public List findByProperty(String propertyName, Object value);

	public List findBySerialNum(Object serialNum) ;

	public List findByName(Object name) ;
	
	public List findByFlag(Object flag) ;

	public List findByContactName(Object contactName) ;

	public List findByTitle(Object title);

	public List findByDescribe(Object describe) ;

	public List findBySource(Object source);
	
	public List findByMoney(Object money) ;

	public List findByOtherMoney(Object otherMoney) ;

	public List findByCaption(Object caption);

	public List findByBefirst(Object befirst) ;

	public List findByRemarks(Object remarks) ;

	public List findByProcessCource(Object processCource) ;

	public List findByState(Object state) ;

	public List findBySatisfaction(Object satisfaction) ;

	public List findByPhone(Object phone) ;

	public List findByEmail(Object email) ;

	public List findByAddress(Object address);

	public List findByCompanyName(Object companyName) ;

	public List findByContactPhone(Object contactPhone);

	public List findByContactEmail(Object contactEmail) ;

	public List findByContactAddress(Object contactAddress) ;

	public List findByReason(Object reason) ;

	public List findAll() ;

	public ServiceOrder merge(ServiceOrder detachedInstance);

	public void attachDirty(ServiceOrder instance) ;
	
	public void attachClean(ServiceOrder instance);
	
	public void saveUserDefined(UserDefined userDefined);
	
	// 更新服務單自定義選項
	public void updateUserDefined(UserDefined userDefined);
	
	public void saveUserFilter(UserFilter userFilter);
	
	public void saveUserField(UserField userField);
	
	// 保存服務單文件
	public void saveSOFile(ServiceOrderFile soFile);
	
	public List getUserDefined(int type,User user);
	
	//取得用戶定義的默認顯示選項
	public UserDefined getUserDefinedOption(int isDefined, User user);
	
	public UserDefined getUserDefinedById(int userDefinedId);
	
	public List getServiceOrderUserFilter(UserDefined userDefined);
	
	public UserField getServiceOrderUserField(UserDefined userDefined);
	
	public void modifySOUserDefined(UserDefined soUserDefined);
	
	public void deleteAllUserFilter(int userDefinedId);
	
	public void deleteAllUserField(int userDefinedId);
	
	public List<User> getUserPage(String familyName,String path ,int currentPage,
			int rowsPerPage);
	
	public int getUserPageCount(String familyName);
	
	public User getUserById(int userId);
	
	public ServiceOrder getServiceOrderByMaxId();
	
	// 通過狀態和顯示條數取得服務單
	public List<ServiceOrder> getServiceOrder(int userId,String userIds,Set<UserFilter> userFilterSet,String path,int currentPage,int rowsPerPage);
	
	// 通過狀態和顯示條數取得服務單個數
	public int getServiceOrderCount(int userId,String userIds,Set<UserFilter> userFilterSet);
	
	//通過過濾條件搜索服務單
	public List<ServiceOrder> searchServiceOrder(int userId,String userIds,Set<UserFilter> userFilterSet,String path,int currentPage,int rowsPerPage);
	
	//通過過濾條件搜索服務單個數
	public int searchServiceOrderCount(int userId,String userIds,Set<UserFilter> userFilterSet);

	//在線獲取客戶服務單
	public List<ServiceOrder> getMyOnlineOrder(String state,int flag,int customerId,String path,int currentPage,int rowsPerPage);
	
	// 在線獲取客戶服務單個數
	public int getMyOnlineOrderCount(String state, int flag, int customerId); 

	public List<Customer> searchCustomers(String customerName,String path, int currentPage, int rowsPerPage);
	
	public int searchCustomersCount(String customerName);
	
	public List<CustomerContact> searchContacters(int customerId,String contactName,String path, int currentPage, int rowsPerPage);
	
	public int searchContactersCount(int customerId,String contactName);
	
	//通過id取聯系人
	public Customer getCustomerById(int customerId);
	
	//通過id取聯系人
	public CustomerContact getContactById(int contactId);
	
	//通過客戶ID查找聯系人
	public List<CustomerContact> getContactByCustomerId(int customerId);
	
	//更新該用戶所有自定義的選項為非默認的搜索選項
	public void updateMyAllOption(int type,int isDefined,User user);
	
	//保存處理過程
	public void saveProcessCource(ProcessCource processCource);
	
	//更新處理過程
	public void updateProcessCource(ProcessCource processCource);
	
	//通過ID查找附件
	public ServiceOrderFile getSOFileById(int soFileId);
	
	//通過ID刪除附件
	public void deleteSOFileById(int soFileId);
	
	//保存臨時聯系人
	public void saveCustomerContact(CustomerContact customerContact);
	
	//取ID最大的聯系人也就是剛保存的聯系人
	public CustomerContact getCustomerContactByMaxId();
}