package com.yuanchung.organize.treeview;

import java.util.List;

import com.yuanchung.sales.exception.SystemException;
import com.yuanchung.sales.model.Position;
import com.yuanchung.sales.model.Treeview;
import com.yuanchung.sales.model.admin.position.UserPosition;
import com.yuanchung.sales.model.user.User;

public interface TreeviewDAO {
	//根據主鍵查找
	public Treeview findByParentId(int parentID) throws SystemException;
	//根據父結點取得樹
	public List getAllTreeByParentId(int parentId) throws SystemException;
	//根據主鍵查找結點
	public Treeview findById(int id) throws SystemException;
	//根據樹結點查找用戶
	public List getUserByTreeview(Treeview treeview) throws SystemException;
	//根據用戶查找崗位
	public UserPosition getUserPositionByUser(User user) throws SystemException;
	//保存崗位
	public void addPosition(Position position)throws SystemException;
	//根據崗位名稱模糊查找
	public List findPositionLike(int treeviewId, String positionName)throws SystemException;
	//根據部門查找崗位
	public List getPositionByDeptId(int deptId, int isLeader)throws SystemException;
	//根據崗位ID查找崗位
	public Position getPositionById(int positionId)throws SystemException;
	//更新用戶---崗位
	public void updateUserPosition(UserPosition userPosition)throws SystemException;
	//根據用戶和崗位查找用戶---崗位
	public UserPosition getUserPositionByUserAndPosition(User user)throws SystemException;
	//根據ID查找用戶
	public User getUserById(int userId)throws SystemException;
	//更新用戶
	public void updateUser(User user)throws SystemException;
	//根據崗位查找用戶
	public User getUserByPosition(Position position)throws SystemException;
	
	//更新節點
	public void updateTreeview(Treeview treeview)throws SystemException;
	//新增組織
	public void saveTreeview(Treeview treeview) throws SystemException;
	//刪除節點
	public void deleteTreeview(Treeview treeview)throws SystemException;
	//查找所有的部門
	public List<Treeview> getTreeViewToDept() throws SystemException;
	//根據子節點ID查找父節點
	public Treeview getParentByChild(int childNodeId)throws SystemException ;
	//根據部門ID和崗位ID查找節點
	public Treeview findTreeviewByDeptIdAndPositionName(int deptId, String positionName) throws SystemException ;
	//根據姓名查找用戶
	public List getUserByFamilyName(String familyName) throws SystemException;
	//根據節點和姓名查找用戶
	public List getUserByTreeviewAndName(Treeview treeview, String familyName) throws SystemException ;
	//根據部門ID和崗位名稱查找唯一崗位
	public Position findPositionByNameAndDeptId(String positionName, int deptId)throws SystemException ;
	//刪除崗位
	public void deleteUser(User user) throws SystemException ;
	//更新崗位名稱
	public void updatePosition(Position position) throws SystemException ;
	//根據父部門節點ID查找所有子部門節點
	public List<Treeview> getSubDeptByParentId(int parentId) throws SystemException ;
	
	public List<Treeview> findChildIdsByParentId(int parentId);
	
	//搜索出所有有效的用戶
	public List<TreeviewVo> findAllUser() throws SystemException;
	
	public List<Treeview> findTreeViewByDeptID(int deptID) throws SystemException;
	
	public List<Treeview> findByDeptIDAndPositionName(int deptID,String positionName) throws SystemException;
	
	public List<Treeview> findByAllPara(int deptID,String positionName,String familyName) throws SystemException;
	
	public List<Treeview> findByDeptIDAndFamilyName(int deptID,String familyName) throws SystemException;
	
	
	
}