List of usage examples for org.joda.time Minutes Minutes
private Minutes(int minutes)
From source file:technicalServices.persistence.TimeInvestmentHandler.java
public ArrayList<TimeInvestment> getUnassignedTimeInvestments() throws DatabaseException { ArrayList<TimeInvestment> timeInvestments = new ArrayList<>(); try {//w w w. j a va 2s . c o m Statement stmt = DatabaseConnection.getInstance().getConnection().createStatement(); //Hent eller timeInvestment-objekter hvor rum-linket er null. String sql = "select * from timeInvestment where roomName is null;"; ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { int id = rs.getInt("id"); Employee emp = EmployeeHandler.getInstance().getEmployee(rs.getInt("employeeNr")); Hours hours = Hours.hours(rs.getInt("hours")); Minutes minutes = Minutes.minutes(rs.getInt("minutes")); LocalDateTime startTime = LocalDateTime.parse(rs.getString("startTime")); timeInvestments.add(new TimeInvestment(id, hours, minutes, startTime, emp, null)); } return timeInvestments; } catch (SQLException ex) { throw new DatabaseException("Der kunne ikke hentes utildelte vagter fra databasen."); } }
From source file:technicalServices.persistence.TimeInvestmentHandler.java
public ArrayList<TimeInvestment> getAssignedTimeInvestments() throws DatabaseException { ArrayList<TimeInvestment> timeInvestments = new ArrayList<>(); try {// w w w.ja v a 2 s .c o m Statement stmt = DatabaseConnection.getInstance().getConnection().createStatement(); //Hent eller timeInvestment-objekter hvor rum-linket er null. String sql = "select * from timeInvestment where roomName is not null;"; ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { int id = rs.getInt("id"); Employee emp = EmployeeHandler.getInstance().getEmployee(rs.getInt("employeeNr")); Hours hours = Hours.hours(rs.getInt("hours")); Minutes minutes = Minutes.minutes(rs.getInt("minutes")); LocalDateTime startTime = LocalDateTime.parse(rs.getString("startTime")); Room room = RoomHandler.getInstance().getRoom(rs.getString("roomName")); timeInvestments.add(new TimeInvestment(id, hours, minutes, startTime, emp, room)); } return timeInvestments; } catch (SQLException ex) { throw new DatabaseException("Der kunne ikke hentes tildelte vagter fra databasen."); } }
From source file:view.popups.shift.ShiftChangePopup.java
public void display(String title, TimeInvestment shift) { lCurrentShiftEmployee = new Label( "Navn: " + shift.getEmployee().getFirstName() + " " + shift.getEmployee().getLastName()); lCurrentShiftDate = new Label("Vagtdato: " + shift.getStartTime().toLocalDate().getDayOfMonth() + "-" + shift.getStartTime().toLocalDate().getMonthOfYear() + "-" + shift.getStartTime().toLocalDate().getYear()); lCurrentShiftTime = new Label("Vagttidspunkt: " + shift.getStartTime().toLocalTime().getHourOfDay() + ":" + shift.getStartTime().toLocalTime().getMinuteOfHour()); lCurrentShiftRoom = new Label("Rum: " + shift.getRoom().getRoomName()); lChangeShift = new Label(""); //lChangeToRoom = new Label("Vlg et nyt rum"); lChangeToDate = new Label("Vlg en ny dato"); lChangeStartTime = new Label("Vlg et nyt starttidspunkt"); lChangeEndTime = new Label("Vlg et nyt sluttidspunkt"); lShiftChanged = new Label("Vagten er nu ndret"); lShiftChanged.setVisible(false);//w ww.ja va 2 s. co m cChangeRoom = new ComboBox(); cChangeYear = new ComboBox(); cChangeMonth = new ComboBox(); cChangeDay = new ComboBox(); cChangeStartHour = new ComboBox(); cChangeStartMinute = new ComboBox(); cChangeEndHour = new ComboBox(); cChangeEndMinute = new ComboBox(); // tChangeYear = new TextField("Indtast rstal"); // tChangeMonth = new TextField("Indtast mned"); // tChangeDay = new TextField("Indtast dag"); // tChangeStartHour = new TextField("Timeantal"); // tChangeStartMinute = new TextField("Minutantal"); // tChangeEndHour = new TextField("Timeantal"); // tChangeEndMinute = new TextField("Minutantal"); try { cChangeRoom.setPrefWidth(120); ArrayList<Room> rooms; rooms = Xray.getInstance().getRoomControl().getRooms(); for (Room room : rooms) { cChangeRoom.getItems().add(room); } cChangeRoom.setPrefWidth(400); cChangeRoom.setValue("Vlg et nyt rum p listen"); } catch (DatabaseException ex) { } for (int i = 1; i <= 31; i++) { cChangeDay.getItems().add(i); } cChangeDay.setValue("Vlg en dag"); for (int i = 1; i <= 12; i++) { cChangeMonth.getItems().add(i); } cChangeMonth.setValue("Vlg en mned"); for (int i = 2015; i <= 2025; i++) { cChangeYear.getItems().add(i); } cChangeYear.setValue("Vlg et r"); for (int i = 0; i <= 23; i++) { cChangeStartHour.getItems().add(i); } cChangeStartHour.setValue("Vlg starttime"); for (int i = 0; i <= 59; i = i + 5) { cChangeStartMinute.getItems().add(i); } cChangeStartMinute.setValue("Vlg startminut"); for (int i = 0; i <= 23; i++) { cChangeEndHour.getItems().add(i); } cChangeEndHour.setValue("Vlg sluttime"); for (int i = 00; i <= 59; i = i + 5) { cChangeEndMinute.getItems().add(i); } cChangeEndMinute.setValue("Vlg slutminut"); for (int i = 1; i <= 31; i++) { cChangeDay.getItems().add(i); } cChangeDay.setPrefWidth(400); cChangeDay.setValue("Vlg en dag"); for (int i = 1; i <= 12; i++) { cChangeMonth.getItems().add(i); } cChangeMonth.setPrefWidth(400); cChangeMonth.setValue("Vlg en mned"); for (int i = 2015; i <= 2025; i++) { cChangeYear.getItems().add(i); } cChangeYear.setPrefWidth(400); cChangeYear.setValue("Vlg et r"); for (int i = 0; i <= 23; i++) { cChangeStartHour.getItems().add(i); } cChangeStartHour.setPrefWidth(400); cChangeStartHour.setValue("Vlg starttime"); for (int i = 0; i <= 59; i = i + 5) { cChangeStartMinute.getItems().add(i); } cChangeStartMinute.setPrefWidth(400); cChangeStartMinute.setValue("Vlg startminut"); for (int i = 0; i <= 23; i++) { cChangeEndHour.getItems().add(i); } cChangeEndHour.setPrefWidth(400); cChangeEndHour.setValue("Vlg sluttime"); for (int i = 00; i <= 59; i = i + 5) { cChangeEndMinute.getItems().add(i); } cChangeEndMinute.setPrefWidth(400); cChangeEndMinute.getSelectionModel().select(1); VBox vBox = new VBox(15); vBox.setAlignment(Pos.BOTTOM_CENTER); vBox.setPadding(new Insets(0, 0, 15, 0)); /*vBox.getChildren().addAll(lCurrentShiftEmployee, lCurrentShiftDate, lCurrentShiftTime, lCurrentShiftRoom, lChangeShift, cChangeRoom, lChangeToDate, tChangeDay, tChangeMonth, tChangeYear, lChangeStartTime, tChangeStartHour, tChangeStartMinute, lChangeEndTime, tChangeEndHour, tChangeEndMinute, lShiftChanged*/ vBox.getChildren().addAll(lCurrentShiftEmployee, lCurrentShiftDate, lCurrentShiftTime, lCurrentShiftRoom, lChangeShift, cChangeRoom, lChangeToDate, cChangeDay, cChangeMonth, cChangeYear, lChangeStartTime, cChangeStartHour, cChangeStartMinute, lChangeEndTime, cChangeEndHour, cChangeEndMinute, lShiftChanged); changeShift = new PopupMenuButton("ndre vagt"); changeShift.setOnAction(e -> { // if (cChangeRoom.getSelectionModel().isEmpty()) { // exceptionPopup.display("Der skal vlges et rum"); // } else if (Integer.parseInt(tChangeDay.getText()) > 31) { // exceptionPopup.display("Dagstallet skal vre 31 eller under"); // } else if (Integer.parseInt(tChangeMonth.getText()) > 12) { // exceptionPopup.display("Mneden skal vre 12 eller under"); // } else if (Integer.parseInt(tChangeStartHour.getText()) >= 24 || Integer.parseInt(tChangeEndHour.getText()) >= 24) { // exceptionPopup.display("Timeantallet skal vre under 24"); // } else if (Integer.parseInt(tChangeEndMinute.getText()) >= 60 || Integer.parseInt(tChangeStartMinute.getText()) >= 60) { // exceptionPopup.display("Minutantal skal vre under 60"); // } else { // Room changedRoom = (Room) cChangeRoom.getSelectionModel().getSelectedItem(); // shift.setRoom(changedRoom); // int changedHours = (cChangeEndHour.getSelectionModel().getSelectedIndex()- cChangeStartHour.getSelectionModel().getSelectedIndex()); // Hours changedHour = Hours.hours(changedHours); // shift.setHours(changedHour); // // int changedMinutes = (cChangeEndMinute.getSelectionModel().getSelectedIndex() - cChangeStartMinute.getSelectionModel().getSelectedIndex()); // Minutes changedMinute = Minutes.minutes(changedMinutes); // shift.setMinutes(changedMinute); // int yearChanged = Integer.parseInt(cChangeYear.getValue().toString()); // int monthChanged = Integer.parseInt(cChangeMonth.getValue().toString()); // int dayChanged = Integer.parseInt(cChangeDay.getValue().toString()); // int hourChanged = Integer.parseInt(cChangeStartHour.getValue().toString()); // int minuteChanged = Integer.parseInt(cChangeStartMinute.getValue().toString()); // LocalDateTime changedDate = new LocalDateTime(yearChanged, monthChanged, dayChanged, hourChanged, minuteChanged); // shift.setStartTime(changedDate); hasFailed = false; if (!hasFailed) { try { Room changedRoom = (Room) cChangeRoom.getSelectionModel().getSelectedItem(); shift.setRoom(changedRoom); } catch (Exception ex) { hasFailed = true; exceptionPopup.display("Der skal vlges et nyt rum"); } } if (!hasFailed) { try { int changedHours = (Integer.parseInt(cChangeEndHour.getValue().toString())) - (Integer.parseInt(cChangeStartHour.getValue().toString())); Hours changedHour = Hours.hours(changedHours); shift.setHours(changedHour); } catch (NumberFormatException ex) { hasFailed = true; exceptionPopup.display("Der skal vlges timer"); } } if (!hasFailed) { try { int changedMinutes = (Integer.parseInt(cChangeEndMinute.getValue().toString())) - (Integer.parseInt(cChangeStartMinute.getValue().toString())); Minutes changedMinute = Minutes.minutes(changedMinutes); shift.setMinutes(changedMinute); } catch (NumberFormatException ex) { hasFailed = true; exceptionPopup.display("Der skal vlges minutter."); } } if (!hasFailed) { try { int yearChanged = Integer.parseInt(cChangeYear.getValue().toString()); int monthChanged = Integer.parseInt(cChangeMonth.getValue().toString()); int dayChanged = Integer.parseInt(cChangeDay.getValue().toString()); int hourChanged = Integer.parseInt(cChangeStartHour.getValue().toString()); int minuteChanged = Integer.parseInt(cChangeStartMinute.getValue().toString()); LocalDateTime changedDate = new LocalDateTime(yearChanged, monthChanged, dayChanged, hourChanged, minuteChanged); shift.setStartTime(changedDate); } catch (NumberFormatException ex) { hasFailed = true; exceptionPopup.display("Datoen skal vlges"); } } if (!hasFailed) { try { TimeInvestmentHandler.getInstance().updateTimeInvestment(shift); lShiftChanged.setVisible(true); Frontpage.getLastCreatedFrontpage().updateSchedule(); } catch (DatabaseException ex) { Logger.getLogger(ShiftChangePopup.class.getName()).log(Level.SEVERE, null, ex); } super.getStage().close(); } }); super.getBottomHBox().getChildren().add(0, changeShift); super.addToCenter(vBox); super.display(title); }
From source file:view.popups.shift.ShiftPanel.java
private void makeChange() { boolean inputError = false; LocalDateTime ldt = shift.getStartTime(); //Nulstiller timer. ldt = ldt.minusHours(ldt.getHourOfDay()); //Nulstiller minuttet. ldt = ldt.minusMinutes(ldt.getMinuteOfHour()); shift.setStartTime(ldt);// w ww .ja v a2s. c o m //Dernst skal det som der er indtastet i configpopuppen tilfjes til //den nulstillede dato. int modifiedStartHour = checkInput(configPanel.gettStartHour(), inputError, 23, 0); if (modifiedStartHour == -1) { inputError = true; } int modifiedStartMinute = checkInput(configPanel.gettStartMinute(), inputError, 59, 0); if (modifiedStartMinute == -1) { inputError = true; } int modifiedEndHour = checkInput(configPanel.gettEndHour(), inputError, 23, 0); if (modifiedEndHour == -1) { inputError = true; } int modifiedEndMinute = checkInput(configPanel.gettEndMinute(), inputError, 59, 0); if (modifiedEndMinute == -1) { inputError = true; } //Dernst udregnes vagttiden, alts hvor mange timer og minutter //vagten tager fra starttidspunktet. if (!inputError) { shift.setHours(Hours.hours(modifiedEndHour - modifiedStartHour)); shift.setMinutes(Minutes.minutes(modifiedEndMinute - modifiedStartMinute)); } }