@Override
public StudentManagerDTO saveStudent(String name, String classId, String schoolId) {
UserDTO userDTO = new UserDTO();
userDTO.setRealName(name);
userDTO.setIdentityId(IdentityIdConstants.STUDENT);
userDTO.setIdentityDescription("学生");
userDTO.setSchoolId(schoolId);
userDTO.setArea(mSchoolMapper.selectByPrimaryKey(schoolId).getArea());
UserDTO users = userService.saveUser(userDTO);
MClass mclass = classMapper.selectByPrimaryKey(classId, schoolId);
StudentDTO studentDTO = new StudentDTO();
studentDTO.setUserId(users.getUserId());
studentDTO.setSchoolId(mclass.getSchoolId());
studentDTO.setSchoolName(mclass.getSchoolName());
studentDTO.setClassName(mclass.getName());
studentDTO.setClassId(classId);
studentDTO.setClassAliasName(mclass.getAliasName());
studentDTO.setJoinClass(new Date());
MStudent mStudent = new MStudent();
BeanUtils.copyProperties(studentDTO, mStudent);
studentMapper.insert(mStudent);
MStudentManager studentManager =
studentMapper.selectStudentByUserId(mStudent.getUserId(), schoolId);
StudentManagerDTO studentManagerDTO = new StudentManagerDTO();
BeanUtils.copyProperties(studentManager, studentManagerDTO);
studentManagerDTO.setClassAliasName(
ClassNameUtil.getFullName(studentManager.getYears(), studentManager.getClassAliasName()));
return studentManagerDTO;
}
public void testHuaTai_nologinUnderWriting() throws Exception {
System.out.println("华泰-----------------------------免登录投保");
// 用户相关信息
UserDTO user = (new UserSet()).setXYZ_nologin();
String payPwd = user.getPayPwd();
int loginId = user.getLoginId();
// 产品相关信息
String[] products = (new AllProductSet()).setHuaTai();
PayResultDTO[] payResults = new PayResultDTO[products.length];
// CheckAfterPay check = new CheckAfterPay();
Ins_Front insF = new Ins_Front();
int start = 0;
for (int i = start; i < products.length; i++) {
System.out.println(i + 1);
String proName = products[i];
// 前台购买保险产品
payResults[i] = insF.pay_YJX(selenium, proName, payPwd, 4, true, loginId);
System.err.println(payResults[i].getFlag());
if (payResults[i].getFlag().equalsIgnoreCase("noProduct")) start++;
else {
selenium.close();
selenium.selectWindow(null);
}
}
// 购买后查询投保单状态
// Thread.sleep(50000);
// if (!check.checkAppStatus(payResults, start)) {
// String report = "未全部承保，请检查！！！";
// selenium.click("link=" + report);
// }
}
@RequestMapping("add")
public String register(UserDTO userDTO) {
userService.createNewUser(userDTO.getUsername(), userDTO.getPassword(), userDTO.isEnable());
return "index";
}
public void setTempPassword(UserDTO user) {
try (Connection conn = Conn.getConnection();
PreparedStatement pstmt =
conn.prepareStatement("update user set password=? where user_id=?"); ) {
pstmt.setString(1, Sha256.encrypt(user.getPassword()));
pstmt.setInt(2, user.getUid());
pstmt.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
}
public void userAdd(UserDTO user) {
try (Connection conn = Conn.getConnection();
PreparedStatement pstmt = conn.prepareStatement("insert into user values(?,?,?,?)"); ) {
pstmt.setInt(1, user.getUid());
pstmt.setString(2, Sha256.encrypt(user.getPassword()));
pstmt.setString(3, user.getName());
pstmt.setString(4, user.getAuth());
pstmt.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
}
public static String checkLogin(String userMobileNo, Context _context) throws Exception {
String errorCode = "";
try {
JSONObject reqParameters = new JSONObject();
reqParameters.put("UMOBILENO", userMobileNo);
JsonHandler jsonHandler = JsonHandler.getInstance();
String url = jsonHandler.getFullUrl("UserLogin.php");
JSONObject result = jsonHandler.postJsonDataToServer(url, reqParameters, _context);
if (result != null) {
String resultCode = result.getString("RESULT");
if (resultCode.contentEquals(AppConstant.PHPRESPONSE_KO)) {
errorCode = result.getString("ERRORCODE");
} else {
JSONObject jsonData = result.getJSONObject("USERDATA");
UserDTO userDto = new UserDTO();
LaunchActivity.loginUserId = jsonData.getInt("USERID");
userDto.setUserId(LaunchActivity.loginUserId);
userDto.setFirstName(jsonData.getString("UFNAME"));
userDto.setLastName(jsonData.getString("ULNAME"));
userDto.setCityId(jsonData.getInt("CITYID"));
userDto.setGender(jsonData.getInt("GENDER"));
userDto.setAge(jsonData.getInt("AGE"));
userDto.setContactNo(jsonData.getString("UCONTACTNO"));
userDto.setUserCity(jsonData.getString("USERCITY"));
userDto.setAppLoginUser(true);
LaunchActivity.repository.addUserDTO(userDto);
}
} else {
errorCode = PHP_ERROR_CODE.TECHNICAL;
}
} catch (JSONException e) {
// e.printStackTrace();
throw e;
} catch (ClientProtocolException e) {
// e.printStackTrace();
throw e;
} catch (IOException e) {
// e.printStackTrace();
throw e;
} catch (Exception e) {
// e.printStackTrace();
throw e;
}
return errorCode;
}
// Container managed transaction
public List<UserDTO> findAllUsers() {
LOG.debug("findAllUsers()");
// TODO: Exception handling
List<User> list = dao.findAll();
List<UserDTO> result = UserDTO.toUserDTOList(list);
return result;
}
boolean checkExpire() {
long curTime = Calendar.getInstance().getTimeInMillis();
if ((curTime - UserDTO.getInstance().startTime) > 36000000) {
return true;
} else {
return false;
}
}
@Override
public StudentDTO queryStudentForAPP(String userId, String schoolId) {
UserDTO mUsers = userService.getByUserId(userId);
if (mUsers == null) {
logger.debug("未找到学乐号为" + userId + "的学生用户");
return null;
}
MStudent mStudent = studentMapper.selectByPrimaryKey(userId, schoolId);
if (mStudent == null) {
logger.debug("未找到学生id为" + userId + "的学生");
throw new MemberException("未找到学生id为" + userId + "的学生");
}
// 学生信息
StudentDTO studentDTO = new StudentDTO();
studentDTO.setUserId(userId);
studentDTO.setRealName(mUsers.getRealName());
studentDTO.setSchoolId(mStudent.getSchoolId());
studentDTO.setSchoolName(mStudent.getSchoolName());
studentDTO.setClassId(mStudent.getClassId());
studentDTO.setClassName(mStudent.getClassName());
studentDTO.setMobile(mUsers.getMobile());
studentDTO.setEmail(mUsers.getEmail());
// 学校所在区域信息
MSchool mSchool = mSchoolMapper.selectByPrimaryKey(mUsers.getSchoolId());
if (mSchool == null) {
logger.debug("未找到学乐号为" + userId + "的学生用户所在的学校");
return null;
}
studentDTO.setAreaCode(mSchool.getArea());
studentDTO.setAreaName(mSchool.getAreaName());
// 班级信息
MClass mClass = classMapper.selectByPrimaryKey(mStudent.getClassId(), schoolId);
if (mClass == null) {
logger.debug("未找到学乐号为" + userId + "的学生用户所在的班级");
return null;
}
studentDTO.setGradeNum(getGradeNum(mClass.getYears()));
studentDTO.setYear(mClass.getYears());
return studentDTO;
}
public boolean passwordCheck(UserDTO user) {
boolean check = false;
try (Connection conn = Conn.getConnection();
PreparedStatement pstmt =
conn.prepareStatement("select user_id from user where user_id=? and password=? "); ) {
pstmt.setInt(1, user.getUid());
pstmt.setString(2, Sha256.encrypt(user.getPassword()));
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
check = true;
} else {
check = false;
}
} catch (Exception e) {
e.printStackTrace();
}
return check;
}
public boolean userDelete(UserDTO user) {
try (Connection conn = Conn.getConnection();
PreparedStatement pstmt = conn.prepareStatement("delete from user where user_id=?"); ) {
pstmt.setInt(1, user.getUid());
pstmt.executeUpdate();
} catch (Exception e) {
return false;
}
return true;
}
public UserDTO login(UserDTO user) {
UserDTO dto = null;
try (Connection conn = Conn.getConnection();
PreparedStatement pstmt =
conn.prepareStatement(
"select user_id,name,auth from user where user_id=? and password=?"); ) {
pstmt.setInt(1, user.getUid());
pstmt.setString(2, Sha256.encrypt(user.getPassword()));
// pstmt.setString(2, user.getPassword());
try (ResultSet rs = pstmt.executeQuery(); ) {
if (rs.next()) {
dto = new UserDTO();
dto.setUid(rs.getInt("user_id"));
dto.setName(rs.getString("name"));
dto.setAuth(rs.getString("auth"));
}
} catch (Exception e) {
e.printStackTrace();
}
} catch (Exception e) {
e.printStackTrace();
}
return dto;
}
public boolean overlapCheck(UserDTO user) {
boolean check = false;
try (Connection conn = Conn.getConnection();
PreparedStatement pstmt =
conn.prepareStatement("select user_id from user where user_id=?"); ) {
pstmt.setInt(1, user.getUid());
try (ResultSet rs = pstmt.executeQuery(); ) {
if (rs.next()) {
check = true;
}
} catch (Exception e) {
e.printStackTrace();
return check;
}
} catch (Exception e) {
e.printStackTrace();
return check;
}
return check;
}
public void testThirdPayYJX() throws Exception {
// 用户相关信息
UserDTO user = (new UserSet()).setNormalUser();
String username = user.getUsername();
String password = user.getPassword();
String payPwd = user.getPayPwd();
int loginId = user.getLoginId();
BigDecimal acc = user.getAcc(); // 账户最低余额：0-普通账户，-5000-vip账户
BigDecimal before_pay = null; // 支付前账户余额
BigDecimal after_pay = null; // 支付后账户余额
// 产品相关信息
ProductDTO[] products = new ProductDTO[2];
products[0] = (new ProductSet()).setYJX();
products[1] = (new ProductSet()).setYJX_Coupon();
// 登录
Ins_Front insF = new Ins_Front();
insF.loginFront(selenium, username, password);
for (int i = 0; i < products.length; i++) {
System.out.println(i + 1);
String proName = products[i].getProName();
String proType = products[i].getProductType();
int coupon = products[i].getPCoupon(); // 支付时是否可以使用优惠券：0-不可以，1-可以
// 前台购买保险产品,购买前查询账户余额
before_pay = (new CommSql()).getAccBall(loginId, acc);
PayResultDTO payResult = insF.pay_YJX(selenium, proName, payPwd, 4, true, loginId);
Thread.sleep(30000);
after_pay = (new CommSql()).getAccBall(loginId, acc);
System.out.println("购买前账户余额：" + before_pay);
System.out.println("购买后账户余额：" + after_pay);
// 支付完成后判断订单、投保单状态及账户余额的正确性
CheckAfterPay check = new CheckAfterPay();
check.checkAfterThirdPay(selenium, before_pay, after_pay, payResult, coupon, proType);
}
}
public UserDTO build() {
UserDTO userDTO = new UserDTO();
userDTO.setId(id);
userDTO.setLogin(login);
userDTO.setPassword(password);
userDTO.setUserRole(userRole);
userDTO.setFirstName(firstName);
userDTO.setLastName(lastName);
userDTO.setEmail(email);
userDTO.setLastModified(lastModified);
userDTO.setState(state);
userDTO.setGroups(groups);
return userDTO;
}
public static ProjectDTO getProjectByName(String name) {
Project p;
p = ProxyManager.getProjectProxy().findProjectByName(name);
if (p != null) {
ProjectDTO projectDTO = new ProjectDTO();
projectDTO.setProjectId(p.getProjectId());
projectDTO.setName(p.getName());
projectDTO.setDescription(p.getDescription());
projectDTO.setStatus(p.getStatus());
Team team = p.getTeamTeamId();
if (team != null) {
TeamDTO teamDTO = new TeamDTO();
teamDTO.setTeamId(team.getTeamId());
teamDTO.setProductOwnerId(team.getProductOwnerId());
teamDTO.setScrumMasterId(team.getScrumMasterId());
ArrayList<UserDTO> userDTOList = new ArrayList<UserDTO>();
for (User user : team.getUserList()) {
UserDTO userDTO = new UserDTO();
userDTO.setUserId(user.getUserId());
userDTO.setUsername(user.getUsername());
userDTO.setPassword(user.getPassword());
userDTO.setFirstName(user.getFirstName());
userDTO.setLastName(user.getLastName());
userDTO.setEmail(user.getEmail());
userDTO.setAdmin(user.getIsAdmin());
userDTO.setSalt(user.getSalt());
userDTO.setActive(user.getIsActive());
userDTO.setTimeCreated(user.getTimeCreated());
userDTOList.add(userDTO);
}
teamDTO.setUserList(userDTOList);
projectDTO.setTeamTeamId(teamDTO);
} else projectDTO.setTeamTeamId(null);
List<SprintDTO> sprintDTOList = new ArrayList<SprintDTO>();
if (p.getSprintList() != null) {
for (Sprint s : p.getSprintList()) {
s = ProxyManager.getSprintProxy().findSprint(s.getSprintPK());
SprintDTO sprintDTO = new SprintDTO();
SprintPKDTO sprintPKDTO = new SprintPKDTO();
sprintPKDTO.setSprintId(s.getSprintPK().getSprintId());
sprintPKDTO.setProjectProjectId(s.getSprintPK().getProjectProjectId());
sprintDTO.setSprintPK(sprintPKDTO);
sprintDTO.setSeqNumber(s.getSeqNumber());
sprintDTO.setStatus(s.getStatus());
sprintDTO.setStartDate(s.getStartDate());
sprintDTO.setEndDate(s.getEndDate());
sprintDTO.setVelocity(s.getVelocity());
if (s.getUserStoryList() != null) {
List<UserStoryDTO> userStoryDTOList = new ArrayList<UserStoryDTO>();
for (UserStory userStory : s.getUserStoryList()) {
userStory = ProxyManager.getUserStoryProxy().findUserStory(userStory.getStoryId());
UserStoryDTO userStoryDTO = new UserStoryDTO();
userStoryDTO.setStoryId(userStory.getStoryId());
userStoryDTO.setName(userStory.getName());
userStoryDTO.setContent(userStory.getContent());
userStoryDTO.setBusinessValue(userStory.getBusinessValue());
userStoryDTO.setStatus(userStory.getStatus());
if (userStory.getEstimateTime() != null) {
userStoryDTO.setEstimateTime(userStory.getEstimateTime().doubleValue());
} else userStoryDTO.setEstimateTime(null);
userStoryDTO.setStoryId(userStory.getStoryId());
userStoryDTO.setProjectProjectId(projectDTO);
userStoryDTO.setComment(userStory.getComment());
userStoryDTO.setSprint(sprintDTO);
PriorityDTO priorityDTO = new PriorityDTO();
priorityDTO.setPriorityId(userStory.getPriorityPriorityId().getPriorityId());
priorityDTO.setName(userStory.getPriorityPriorityId().getName());
userStoryDTO.setPriorityPriorityId(priorityDTO);
List<AcceptanceTestDTO> acceptanceTestDTOList = new ArrayList<AcceptanceTestDTO>();
for (AcceptanceTest at : userStory.getAcceptanceTestList()) {
AcceptanceTestDTO acceptanceTestDTO = new AcceptanceTestDTO();
acceptanceTestDTO.setAcceptanceTestId(at.getAcceptanceTestId());
acceptanceTestDTO.setContent(at.getContent());
acceptanceTestDTOList.add(acceptanceTestDTO);
}
userStoryDTO.setAcceptanceTestList(acceptanceTestDTOList);
if (userStory.getTaskList() != null) {
List<TaskDTO> taskDTOList = new ArrayList<TaskDTO>();
for (Task task : userStory.getTaskList()) {
task = ProxyManager.getTaskProxy().findTask(task.getTaskPK());
TaskDTO taskDTO = new TaskDTO();
taskDTO.setDescription(task.getDescription());
taskDTO.setTimeRemaining(task.getTimeRemaining());
taskDTO.setEstimatedTime(task.getEstimatedTime());
taskDTO.setStatus(task.getStatus());
taskDTO.setPreassignedUserName(task.getPreassignedUserName());
taskDTO.setAssignedDate(task.getAssignedDate());
taskDTO.setUserStory(userStoryDTO);
TaskPKDTO taskPKDTO = new TaskPKDTO();
taskPKDTO.setTaskId(task.getTaskPK().getTaskId());
taskPKDTO.setUserStoryStoryId(task.getTaskPK().getUserStoryStoryId());
taskDTO.setTaskPK(taskPKDTO);
if (task.getUserUserId() != null) {
User user =
ProxyManager.getUserProxy().findUser(task.getUserUserId().getUserId());
UserDTO userDTO = new UserDTO();
userDTO.setUserId(user.getUserId());
userDTO.setUsername(user.getUsername());
userDTO.setPassword(user.getPassword());
userDTO.setFirstName(user.getFirstName());
userDTO.setLastName(user.getLastName());
userDTO.setEmail(user.getEmail());
userDTO.setAdmin(user.getIsAdmin());
userDTO.setSalt(user.getSalt());
userDTO.setActive(user.getIsActive());
userDTO.setTimeCreated(user.getTimeCreated());
taskDTO.setUserUserId(userDTO);
}
List<WorkloadDTO> workloadDTOList = new ArrayList<WorkloadDTO>();
for (Workload workload : task.getWorkloadList()) {
workload =
ProxyManager.getWorkloadProxy().findWorkload(workload.getWorkloadPK());
WorkloadDTO workloadDTO = new WorkloadDTO();
workloadDTO.setDay(workload.getDay());
workloadDTO.setTimeRemaining(workload.getTimeRemaining());
workloadDTO.setTimeSpent(workload.getTimeSpent());
workloadDTO.setStarted(workload.getStarted());
workloadDTO.setStartTime(workload.getStartTime());
workloadDTO.setStopTime(workload.getStopTime());
User user =
ProxyManager.getUserProxy().findUser(workload.getUser().getUserId());
UserDTO userDTO = new UserDTO();
userDTO.setUserId(user.getUserId());
userDTO.setUsername(user.getUsername());
userDTO.setPassword(user.getPassword());
userDTO.setFirstName(user.getFirstName());
userDTO.setLastName(user.getLastName());
userDTO.setEmail(user.getEmail());
userDTO.setAdmin(user.getIsAdmin());
userDTO.setSalt(user.getSalt());
userDTO.setActive(user.getIsActive());
userDTO.setTimeCreated(user.getTimeCreated());
workloadDTO.setUser(userDTO);
workloadDTO.setTask(taskDTO);
WorkloadPKDTO workloadPKDTO = new WorkloadPKDTO();
WorkloadPK workloadPK = workload.getWorkloadPK();
workloadPKDTO.setTaskTaskId(workloadPK.getTaskTaskId());
workloadPKDTO.setTaskUserStoryStoryId(workloadPK.getTaskUserStoryStoryId());
workloadPKDTO.setUserUserId(workloadPK.getUserUserId());
workloadPKDTO.setWorkloadId(workloadPK.getWorkloadId());
workloadDTO.setWorkloadPK(workloadPKDTO);
List<WorkblockDTO> workblockDTOList = new ArrayList<WorkblockDTO>();
for (Workblock workblock : workload.getWorkblockList()) {
workblock =
ProxyManager.getWorkblockProxy()
.findWorkblock(workblock.getWorkblockPK());
WorkblockDTO workblockDTO = new WorkblockDTO();
workblockDTO.setTimeStart(workblock.getTimeStart());
workblockDTO.setTimeStop(workblock.getTimeStop());
workblockDTO.setWorkload(workloadDTO);
WorkblockPKDTO workblockPKDTO = new WorkblockPKDTO();
WorkblockPK workblockPK = workblock.getWorkblockPK();
workloadPKDTO.setWorkloadId(workblockPK.getWorkloadWorkloadId());
workblockPKDTO.setWorkloadTaskTaskId(workloadPK.getTaskTaskId());
workblockPKDTO.setWorkloadTaskUserStoryStoryId(
workblockPK.getWorkloadTaskUserStoryStoryId());
workblockPKDTO.setWorkloadUserUserId(workblockPK.getWorkloadUserUserId());
workblockPKDTO.setWorkloadWorkloadId(workblockPK.getWorkloadWorkloadId());
workblockDTO.setWorkblockPK(workblockPKDTO);
workblockDTOList.add(workblockDTO);
}
workloadDTO.setWorkblockList(workblockDTOList);
workloadDTOList.add(workloadDTO);
}
taskDTO.setWorkloadList(workloadDTOList);
taskDTOList.add(taskDTO);
}
userStoryDTO.setTaskList(taskDTOList);
}
userStoryDTOList.add(userStoryDTO);
}
sprintDTO.setUserStoryList(userStoryDTOList);
}
sprintDTOList.add(sprintDTO);
}
projectDTO.setSprintList(sprintDTOList);
} else projectDTO.setSprintList(null);
List<UserStoryDTO> userStoryDTOList = new ArrayList<UserStoryDTO>();
if (p.getUserStoryList() != null) {
for (UserStory us : p.getUserStoryList()) {
UserStoryDTO userStoryDTO = new UserStoryDTO();
userStoryDTO.setStoryId(us.getStoryId());
userStoryDTO.setName(us.getName());
userStoryDTO.setContent(us.getContent());
userStoryDTO.setBusinessValue(us.getBusinessValue());
userStoryDTO.setStatus(us.getStatus());
if (us.getEstimateTime() != null) {
userStoryDTO.setEstimateTime(us.getEstimateTime().doubleValue());
} else userStoryDTO.setEstimateTime(null);
userStoryDTO.setStoryId(us.getStoryId());
userStoryDTO.setProjectProjectId(projectDTO);
PriorityDTO priorityDTO = new PriorityDTO();
priorityDTO.setPriorityId(us.getPriorityPriorityId().getPriorityId());
priorityDTO.setName(us.getPriorityPriorityId().getName());
userStoryDTO.setPriorityPriorityId(priorityDTO);
List<AcceptanceTestDTO> acceptanceTestDTOList = new ArrayList<AcceptanceTestDTO>();
for (AcceptanceTest at : us.getAcceptanceTestList()) {
AcceptanceTestDTO acceptanceTestDTO = new AcceptanceTestDTO();
acceptanceTestDTO.setAcceptanceTestId(at.getAcceptanceTestId());
acceptanceTestDTO.setContent(at.getContent());
acceptanceTestDTOList.add(acceptanceTestDTO);
}
userStoryDTO.setAcceptanceTestList(acceptanceTestDTOList);
// TODO: Set taskList to userStoryDTO
if (us.getTaskList() != null) {
List<TaskDTO> taskDTOList = new ArrayList<TaskDTO>();
for (Task task : us.getTaskList()) {
task = ProxyManager.getTaskProxy().findTask(task.getTaskPK());
TaskDTO taskDTO = new TaskDTO();
taskDTO.setDescription(task.getDescription());
taskDTO.setTimeRemaining(task.getTimeRemaining());
taskDTO.setEstimatedTime(task.getEstimatedTime());
taskDTO.setStatus(task.getStatus());
taskDTO.setPreassignedUserName(task.getPreassignedUserName());
taskDTO.setAssignedDate(task.getAssignedDate());
taskDTO.setUserStory(userStoryDTO);
TaskPKDTO taskPKDTO = new TaskPKDTO();
taskPKDTO.setTaskId(task.getTaskPK().getTaskId());
taskPKDTO.setUserStoryStoryId(task.getTaskPK().getUserStoryStoryId());
taskDTO.setTaskPK(taskPKDTO);
if (task.getUserUserId() != null) {
User user = ProxyManager.getUserProxy().findUser(task.getUserUserId().getUserId());
UserDTO userDTO = new UserDTO();
userDTO.setUserId(user.getUserId());
userDTO.setUsername(user.getUsername());
userDTO.setPassword(user.getPassword());
userDTO.setFirstName(user.getFirstName());
userDTO.setLastName(user.getLastName());
userDTO.setEmail(user.getEmail());
userDTO.setAdmin(user.getIsAdmin());
userDTO.setSalt(user.getSalt());
userDTO.setActive(user.getIsActive());
userDTO.setTimeCreated(user.getTimeCreated());
taskDTO.setUserUserId(userDTO);
}
List<WorkloadDTO> workloadDTOList = new ArrayList<WorkloadDTO>();
for (Workload workload : task.getWorkloadList()) {
workload = ProxyManager.getWorkloadProxy().findWorkload(workload.getWorkloadPK());
WorkloadDTO workloadDTO = new WorkloadDTO();
workloadDTO.setDay(workload.getDay());
workloadDTO.setTimeRemaining(workload.getTimeRemaining());
workloadDTO.setTimeSpent(workload.getTimeSpent());
User user = ProxyManager.getUserProxy().findUser(workload.getUser().getUserId());
UserDTO userDTO = new UserDTO();
userDTO.setUserId(user.getUserId());
userDTO.setUsername(user.getUsername());
userDTO.setPassword(user.getPassword());
userDTO.setFirstName(user.getFirstName());
userDTO.setLastName(user.getLastName());
userDTO.setEmail(user.getEmail());
userDTO.setAdmin(user.getIsAdmin());
userDTO.setSalt(user.getSalt());
userDTO.setActive(user.getIsActive());
userDTO.setTimeCreated(user.getTimeCreated());
workloadDTO.setUser(userDTO);
workloadDTO.setTask(taskDTO);
WorkloadPKDTO workloadPKDTO = new WorkloadPKDTO();
WorkloadPK workloadPK = workload.getWorkloadPK();
workloadPKDTO.setTaskTaskId(workloadPK.getTaskTaskId());
workloadPKDTO.setTaskUserStoryStoryId(workloadPK.getTaskUserStoryStoryId());
workloadPKDTO.setUserUserId(workloadPK.getUserUserId());
workloadPKDTO.setWorkloadId(workloadPK.getWorkloadId());
workloadDTO.setWorkloadPK(workloadPKDTO);
List<WorkblockDTO> workblockDTOList = new ArrayList<WorkblockDTO>();
for (Workblock workblock : workload.getWorkblockList()) {
workblock =
ProxyManager.getWorkblockProxy().findWorkblock(workblock.getWorkblockPK());
WorkblockDTO workblockDTO = new WorkblockDTO();
workblockDTO.setTimeStart(workblock.getTimeStart());
workblockDTO.setTimeStop(workblock.getTimeStop());
workblockDTO.setWorkload(workloadDTO);
WorkblockPKDTO workblockPKDTO = new WorkblockPKDTO();
WorkblockPK workblockPK = workblock.getWorkblockPK();
workloadPKDTO.setWorkloadId(workblockPK.getWorkloadWorkloadId());
workblockPKDTO.setWorkloadTaskTaskId(workloadPK.getTaskTaskId());
workblockPKDTO.setWorkloadTaskUserStoryStoryId(
workblockPK.getWorkloadTaskUserStoryStoryId());
workblockPKDTO.setWorkloadUserUserId(workblockPK.getWorkloadUserUserId());
workblockPKDTO.setWorkloadWorkloadId(workblockPK.getWorkloadWorkloadId());
workblockDTO.setWorkblockPK(workblockPKDTO);
workblockDTOList.add(workblockDTO);
}
workloadDTO.setWorkblockList(workblockDTOList);
workloadDTOList.add(workloadDTO);
}
taskDTO.setWorkloadList(workloadDTOList);
taskDTOList.add(taskDTO);
}
userStoryDTO.setTaskList(taskDTOList);
} else userStoryDTO.setTaskList(null);
SprintDTO sprintDTO = new SprintDTO();
if (us.getSprint() != null) {
SprintPKDTO sprintPKDTO = new SprintPKDTO();
sprintPKDTO.setSprintId(us.getSprint().getSprintPK().getSprintId());
sprintPKDTO.setProjectProjectId(us.getSprint().getSprintPK().getProjectProjectId());
sprintDTO.setSprintPK(sprintPKDTO);
sprintDTO.setSeqNumber(us.getSprint().getSeqNumber());
sprintDTO.setStatus(us.getSprint().getStatus());
sprintDTO.setStartDate(us.getSprint().getStartDate());
sprintDTO.setEndDate(us.getSprint().getEndDate());
sprintDTO.setVelocity(us.getSprint().getVelocity());
} else sprintDTO = null;
userStoryDTO.setSprint(sprintDTO);
userStoryDTOList.add(userStoryDTO);
}
projectDTO.setUserStoryList(userStoryDTOList);
}
return projectDTO;
} else return null;
}
public static Pair<Boolean, String> updateProject(
ProjectDTO projectDTO, boolean changedProjectName, String originalProjectName) {
try {
// Additional duplication control
Project existingProject;
if (changedProjectName) {
existingProject = ProxyManager.getProjectProxy().findProjectByName(projectDTO.getName());
} else existingProject = null;
if (existingProject != null && changedProjectName) {
System.out.println("Existing project exists!");
return Pair.of(false, "Project with this name already exists!");
}
Project p = ProxyManager.getProjectProxy().findProjectByName(originalProjectName);
p.setProjectId(projectDTO.getProjectId());
p.setName(projectDTO.getName());
p.setDescription(projectDTO.getDescription());
p.setStatus(projectDTO.getStatus());
Team team = new Team();
team.setTeamId(projectDTO.getTeamTeamId().getTeamId());
team.setScrumMasterId(projectDTO.getTeamTeamId().getScrumMasterId());
team.setProductOwnerId(projectDTO.getTeamTeamId().getProductOwnerId());
List<User> userList = new ArrayList<User>();
if (projectDTO.getTeamTeamId().getUserList() != null) {
for (UserDTO userDTO : projectDTO.getTeamTeamId().getUserList()) {
User user = new User();
user.setUserId(userDTO.getUserId());
user.setUsername(userDTO.getUsername());
user.setPassword(userDTO.getPassword());
user.setFirstName(userDTO.getFirstName());
user.setLastName(userDTO.getLastName());
user.setEmail(userDTO.getEmail());
user.setIsAdmin(userDTO.isAdmin());
user.setSalt(userDTO.getSalt());
user.setIsActive(userDTO.isActive());
user.setTimeCreated(userDTO.getTimeCreated());
userList.add(user);
}
team.setUserList(userList);
} else return Pair.of(false, "No project list when saving team.");
p.setTeamTeamId(team);
try {
if (p == null) return Pair.of(false, "Data error!");
ProxyManager.getProjectProxy().edit(p);
} catch (Exception e) {
System.err.println("Error: " + e.getMessage());
return Pair.of(false, e.getMessage());
}
} catch (Exception e) {
e.printStackTrace();
return Pair.of(false, e.getMessage());
}
return Pair.of(true, "Project updated successfully.");
}
@Override
public void reset() {
super.reset();
}
public static Pair<Boolean, String> saveNewProject(ProjectDTO projectDTO) {
// check for project in database
System.out.println("Project to check in base: " + projectDTO.getName());
Project existingProject =
ProxyManager.getProjectProxy().findProjectByName(projectDTO.getName());
try {
if (existingProject != null) {
System.out.println("Existing project exists!");
return Pair.of(false, "Project with this name already exists!");
} else System.out.println("Project check passed, no existing project.");
Project p = new Project();
p.setName(projectDTO.getName());
p.setDescription(projectDTO.getDescription());
p.setStatus(projectDTO.getStatus());
Team team = new Team();
team.setTeamId(projectDTO.getTeamTeamId().getTeamId());
team.setScrumMasterId(projectDTO.getTeamTeamId().getScrumMasterId());
team.setProductOwnerId(projectDTO.getTeamTeamId().getProductOwnerId());
List<User> userList = new ArrayList<User>();
if (projectDTO.getTeamTeamId().getUserList() != null) {
for (UserDTO userDTO : projectDTO.getTeamTeamId().getUserList()) {
User user = new User();
user.setUserId(userDTO.getUserId());
user.setUsername(userDTO.getUsername());
user.setPassword(userDTO.getPassword());
user.setFirstName(userDTO.getFirstName());
user.setLastName(userDTO.getLastName());
user.setEmail(userDTO.getEmail());
user.setIsAdmin(userDTO.isAdmin());
user.setSalt(userDTO.getSalt());
user.setIsActive(userDTO.isActive());
user.setTimeCreated(userDTO.getTimeCreated());
userList.add(user);
}
team.setUserList(userList);
} else return Pair.of(false, "No user list when saving team.");
p.setTeamTeamId(team);
try {
if (p == null) return Pair.of(false, "Data error!");
ProxyManager.getProjectProxy().create(p);
} catch (Exception e) {
System.err.println("Error: " + e.getMessage());
return Pair.of(false, e.getMessage());
}
} catch (Exception e) {
e.printStackTrace();
return Pair.of(false, e.getMessage());
}
return Pair.of(true, "Project saved successfully.");
}
@Override
public StudentDTO updateStudentForAPP(StudentDTO studentDTO) {
// 更新联系方式
UserDTO userDTO = new UserDTO();
boolean isAllNot = true;
// 学生姓名
String name = studentDTO.getRealName();
if (!StringUtils.isEmpty(name)) {
userDTO.setRealName(name);
isAllNot = false;
}
String school = studentDTO.getSchoolId();
if (school != null) {
userDTO.setSchoolId(school);
isAllNot = false;
} else {
logger.warn("schoolId不能为空");
return null;
}
String userId = studentDTO.getUserId();
if (!StringUtils.isEmpty(userId)) {
userDTO.setUserId(userId);
} else {
logger.warn("userId不能为空");
return null;
}
String mobile = studentDTO.getMobile();
if (!StringUtils.isEmpty(mobile)) {
userDTO.setMobile(mobile);
isAllNot = false;
}
String email = studentDTO.getEmail();
if (!StringUtils.isEmpty(email)) {
userDTO.setEmail(email);
isAllNot = false;
}
if (!isAllNot) {
userService.updateByUserId(userDTO);
}
// 更新班级
String schoolId = userService.getSchoolId(userId);
if (StringUtils.isEmpty(schoolId)) {
throw new MemberException("该学生没有学校");
}
MSchool mSchool = mSchoolMapper.selectByPrimaryKey(schoolId);
String classId = studentDTO.getClassId();
if (!StringUtils.isEmpty(classId)) {
MClass mClass = classMapper.selectByPrimaryKey(classId, schoolId);
if (mClass == null) {
logger.warn("找不到班级号为" + classId + "的班级");
return null;
}
MStudent mStudent = new MStudent();
mStudent.setUserId(studentDTO.getUserId());
mStudent.setClassName(mClass.getName());
mStudent.setClassId(classId);
mStudent.setSchoolId(schoolId);
studentMapper.updateByPrimaryKey(mStudent);
}
studentDTO.setClassId(classId);
studentDTO.setSchoolId(schoolId);
studentDTO.setSchoolName(mSchool.getName());
return studentDTO;
}
@Test
public void testUserCreate() throws Exception {
System.out.println("testUserCreate: START");
// =================================================================================
int id = 0;
String username = "******";
String password = "******";
boolean active = true;
boolean admin = true;
String dob = "11/03/1966";
String email = "*****@*****.**";
String securityQuestion1 = "XXX";
String securityAnswer1 = "XXX";
String securityQuestion2 = "YYY";
String securityAnswer2 = "YYY";
Date birthDate = sdf.parse(dob);
// =================================================================================
System.out.println("testUserCreate: START: CREATE");
UserDTO user = new UserDTO();
assertNotNull(user);
// ***************************************************************
user.setId(id);
user.setUsername(username);
user.setPassword(password);
user.setActive(active);
user.setEmail(email);
user.setSecurityQuestion1(securityQuestion1);
user.setSecurityAnswer1(securityAnswer1);
user.setSecurityQuestion2(securityQuestion2);
user.setSecurityAnswer2(securityAnswer2);
System.out.println("testUserCreate: user="******"testUserCreate: FINISH: CREATE");
}
public static List<ProjectDTO> getAllProject() {
// Get project list
List<Project> projectList;
// retrieve project list from JPA controller
projectList = ProxyManager.getProjectProxy().getProjectsList();
ArrayList<ProjectDTO> resList = new ArrayList<ProjectDTO>();
ProjectDTO projectDTO;
for (Project p : projectList) {
projectDTO = new ProjectDTO();
projectDTO.setName(p.getName());
projectDTO.setDescription(p.getDescription());
projectDTO.setStatus(p.getStatus());
Team team = p.getTeamTeamId();
if (team != null) {
TeamDTO teamDTO = new TeamDTO();
teamDTO.setTeamId(team.getTeamId());
teamDTO.setProductOwnerId(team.getProductOwnerId());
teamDTO.setScrumMasterId(team.getScrumMasterId());
ArrayList<UserDTO> userDTOList = new ArrayList<UserDTO>();
for (User user : team.getUserList()) {
UserDTO userDTO = new UserDTO();
userDTO.setUserId(user.getUserId());
userDTO.setUsername(user.getUsername());
userDTO.setPassword(user.getPassword());
userDTO.setFirstName(user.getFirstName());
userDTO.setLastName(user.getLastName());
userDTO.setEmail(user.getEmail());
userDTO.setAdmin(user.getIsAdmin());
userDTO.setSalt(user.getSalt());
userDTO.setActive(user.getIsActive());
userDTO.setTimeCreated(user.getTimeCreated());
userDTOList.add(userDTO);
}
teamDTO.setUserList(userDTOList);
projectDTO.setTeamTeamId(teamDTO);
} else projectDTO.setTeamTeamId(null); // TODO: possible break
resList.add(projectDTO);
}
return resList;
}
