@Override
public Project selectNewProject(Project project) {
// TODO Auto-generated method stub
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
Project p = memberMapper.selectNewProject(project);
return p;
}
@Override
public ArrayList<Member> userAssignList(int PRO_ID) {
// TODO Auto-generated method stub
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
ArrayList<Member> result = memberMapper.userAssignList(PRO_ID);
return result;
}
@Override
public int projectCount() {
// TODO Auto-generated method stub
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
int totalCount = memberMapper.projectCount();
return totalCount;
}
@Override
public ArrayList<Member> selectJoinMember(int PRO_ID) {
// TODO Auto-generated method stub
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
ArrayList<Member> member = memberMapper.selectJoinMember(PRO_ID);
return member;
}
@Override
public ArrayList<ProjectBoard> projectBoardList(int PRO_ID) {
// TODO Auto-generated method stub
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
ArrayList<ProjectBoard> result = memberMapper.projectBoardList(PRO_ID);
return result;
}
@Override
public ArrayList<Project> projectJoinList(String USER_ID) {
// TODO Auto-generated method stub
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
ArrayList<Project> result = memberMapper.projectJoinList(USER_ID);
return result;
}
@Override
public Member selectInfo(String USER_ID) {
// TODO Auto-generated method stub
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
Member member = memberMapper.selectInfo(USER_ID);
return member;
}
@Override
public ArrayList<NoticeBoard> notice() {
// TODO Auto-generated method stub
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
ArrayList<NoticeBoard> pb = memberMapper.notice();
return pb;
}
@Override
public Project projectDetail(int PRO_ID) {
// TODO Auto-generated method stub
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
Project p = new Project();
p = memberMapper.projectDetail(PRO_ID);
return p;
}
@Override
public ProjectBoard projectBoardDetail(int PRO_BOARD_ID) {
// TODO Auto-generated method stub
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
ProjectBoard pb = memberMapper.projectBoardDetail(PRO_BOARD_ID);
return pb;
}
@Override
public ArrayList<Project> projectTrack(Project project) {
ArrayList<Project> result = new ArrayList<Project>();
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
// getMember()�� �ҵ��� mapper.mxl�� id�� �����ؾ��Ѵ�.
result = memberMapper.projectTrack(project);
return result;
}
@Override
public ArrayList<Member> getMembers() {
ArrayList<Member> result = new ArrayList<Member>();
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
// getMember()�� �ҵ��� mapper.mxl�� id�� �����ؾ��Ѵ�.
result = memberMapper.getMembers();
return result;
}
@Override
public ArrayList<Project> projectTrackETC(Project project) {
// TODO Auto-generated method stub
ArrayList<Project> result = new ArrayList<Project>();
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
// getMember()�� �ҵ��� mapper.mxl�� id�� �����ؾ��Ѵ�.
result = memberMapper.projectTrackETC(project);
return result;
}
public Member addOrUpdate(Member member) {
checkMid(member.getUid(), member.getMid());
checkMemberLevelId(member.getUid(), member.getMember_level_id());
Member finded = memberMapper.get(member.getUid(), member.getMid());
if (finded == null) {
member.defaultValue();
memberMapper.add(member);
userMapper.joinMember(member.getUid(), member.getMid());
} else {
memberMapper.update(member);
}
return memberMapper.get(member.getUid(), member.getMid());
}
public void deleteAllByUidAndMid(long uid, long mid) {
userContactMapper.delete(uid, mid);
userExtMapper.delete(uid, mid);
userLastActiveMappper.delete(uid, mid);
userTagMapper.deleteUserTag(uid, mid);
platformMapper.delete(uid, mid);
userMapper.delete(uid, mid);
memberExpRecordMapper.delete(uid, mid);
memberPointRecordMapper.delete(uid, mid);
addressMapper.deleteAll(mid);
memberMapper.deleteMember(uid, mid);
}
private void fillUserExtInfo(User user) {
if (user == null) {
return;
}
if (user.getIs_member() == 1) {
user.setMember(memberMapper.get(user.getUid(), user.getMid()));
}
user.setPlatforms(platformMapper.list(user.getUid(), user.getMid()));
user.setTags(userTagMapper.getUserTags(user.getUid(), user.getMid()));
user.setUserExts(Arrays.asList(userExtMapper.query(user.getUid(), user.getMid())));
user.setUserContacts(userContactMapper.queryForList(user.getUid(), user.getMid()));
user.setUserLastActives(
Arrays.asList(userLastActiveMappper.query(user.getUid(), user.getMid())));
}
@Override
public void insertProjectMentor(Member member) {
// TODO Auto-generated method stub
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
memberMapper.insertProjectMentor(member);
}
@Override
public void projectAssign(Member member) {
// TODO Auto-generated method stub
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
memberMapper.projectAssign(member);
}
public Member getMember(long uid, long mid) {
return memberMapper.get(uid, mid);
}
public Member update(Member member) {
checkMemberLevelId(member.getUid(), member.getMember_level_id());
memberMapper.update(member);
return memberMapper.get(member.getUid(), member.getMid());
}
@Override
public void deleteMember(String name) {
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
memberMapper.deleteMember(name);
}
@Override
public int loginCheck(Member member) {
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
return memberMapper.loginCheck(member);
}
@Override
public void writeNoticeBoard(ProjectBoard pb) {
// TODO Auto-generated method stub
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
memberMapper.writeNoticeBoard(pb);
}
@Override
public void insertMember(Member member) {
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
memberMapper.insertMember(member);
}
public int queryMemberCountByUid(long uid) {
return memberMapper.queryCountByUid(uid);
}
public void add(MemberExpRecord record) {
checkMid(record.getUid(), record.getMid());
memberExpRecordMapper.add(record);
memberMapper.addExp(record);
}
@Override
public void updateInfo(Member member) {
// TODO Auto-generated method stub
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
memberMapper.updateInfo(member);
}
public void add(MemberPointRecord record) {
checkMid(record.getUid(), record.getMid());
memberPointRecordMapper.add(record);
memberMapper.addPoint(record);
}
public void deleteMember(long uid, long mid) {
checkMid(uid, mid);
userMapper.exitMember(uid, mid);
memberMapper.delete(uid, mid);
}
@Override
public void delAssignList(Member member) {
// TODO Auto-generated method stub
MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);
memberMapper.delAssignList(member);
}
