Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

General Attendance Logic clarification

M.broJul 13 2022

Hi All,
I am using Oracle DB - 12.1.1. I received one requirement related to Attendance related login hours, break hours, official visit hours, etc.
I can get the data from the biometric device to the SQL server and I will sync the data to the oracle database.
I can receive the data from the SQL server as per the below structure. My requirement is that I can receive multiple times for employee but the mode is different like a break-in or break-out, personal-in or personal-out. some of them click the break-out (to start the break) or some of them click the break-in (to start the break ) there is no control over the devices. The problem is I need to calculate the hours like break hours (multiple break entries for a single day against one employee). and official hours also I need to calculate. Please suggest some sample quey or PLSQL logic also.
Example: employee 2 break-in start 9:30 am to 9:40 (break time 10 minutes),
but employee 3 break-out starts at 08:30 to break-in 08:40 (break time 10 minutes and 11:32 to 11:50 18 minutes) total break hours is 18 minutes employee 3 at 13-06-2022
Note: multiple entries for a break and another mode too.

image.png
Thanks & Regards.
M.bro.

Comments

3081639

Okay I worked out how to change the background by calling setStyle("-fx-background-color: red") on the tab. However I can't work how to change the text colour. I have tried adding -fx-text-fill: white to the string in the style but the text stays black. Does anyone have any idea on how to change the text colour programatically in JavaFx 8?

jim_b_o

The Tab has a Label and that is where you need to set the text color.  In my case I do this dynamically by adding/removing a style class in code depending on a boolean isDirty value:

if (isDirty) {

                tab.getStyleClass().add("dirty");

} else {

                tab.getStyleClass().remove("dirty");

}

and the the following CSS:

.tab.dirty .tab-label {

     -fx-text-fill: orange;

}

Note the .tab-label is required so that we set the color of the text in the Label on the Tab and the .dirty selector is the style-class I'm adding/removing so that the color only changes from the default when I want it to.

1 - 2

Post Details

Added on Jul 13 2022
#date, #developer, #hrms, #plsql, #sql
10 comments
454 views
3 mentions