Any ideas please

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • cmrhema
    Contributor
    • Jan 2007
    • 375
    #1

    Any ideas please

    Hi,

    I am preparing an employee portal. As the employee logs in website he/she will be treated as present, if he has not logged in it will treated as absence.

    This I have done. Now as he logs in I will compare with the previous day using datetime.add(-1) get the values and see whether he logged in the previous day. If not he will be required to fill out the reason of his absence. I will find out whether the day was sunday using day function. if so he will not be asked for any reason. Now my problem is if he puts leave more than one day Consider this situation an employee has taken leave on friday,saturday and sunday. saturday was some public holiday. Now only I have to ensure that friday was treated as absent not other days. Of course I will retrieve all the dates from where he last logged in.But how to proceed from now on.

    Please give some idea.



    Regards

    cmrhema
    Tags: None
    • Shashi Sadasivan
      Recognized Expert Top Contributor
      • Aug 2007
      • 1435
      #2
      you could retrieve all recods where the user was absent and has not filled a reason, (obviously skipping all the days the user had taken a leave, and when it was a holiday)

        Comment

        • cmrhema
          Contributor
          • Jan 2007
          • 375
          #3
          Originally posted by Shashi Sadasivan
          you could retrieve all recods where the user was absent and has not filled a reason, (obviously skipping all the days the user had taken a leave, and when it was a holiday)
          That means I should already have a database which has stored all the public holidays etc.

            Comment

            • Shashi Sadasivan
              Recognized Expert Top Contributor
              • Aug 2007
              • 1435
              #4
              Originally posted by cmrhema
              That means I should already have a database which has stored all the public holidays etc.
              Yes you would have to get the information of when public holidays happen,
              as they change from region to regio (that would either mein country to coutnry, or state to state, sometimes even cities matter)

                Comment

                • redhimanshu
                  New Member
                  • Dec 2007
                  • 6
                  #5
                  Hello,

                  I am new to this field but even then i ll try to solve it.

                  Only you have to do is...

                  Make a HOLIDAYPOINTER for each day. This field should be kept "1" if the day is holiday and kept "0" if the day is normal

                  After that when a user logged in just you have to check a single HOLIDAYPOINTER value, If it is 0 then ask for the EXCUSE. Otherwise leave it....

                  Hope it will work

                  All the best

                    Comment

                    • cmrhema
                      Contributor
                      • Jan 2007
                      • 375
                      #6
                      Originally posted by redhimanshu
                      Hello,

                      I am new to this field but even then i ll try to solve it.

                      Only you have to do is...

                      Make a HOLIDAYPOINTER for each day. This field should be kept "1" if the day is holiday and kept "0" if the day is normal

                      After that when a user logged in just you have to check a single HOLIDAYPOINTER value, If it is 0 then ask for the EXCUSE. Otherwise leave it....

                      Hope it will work

                      All the best
                      Thanks Himanshu for the idea
                      Its a pretty idea

                        Comment

                        • gr8tgrad
                          New Member
                          • Jan 2008
                          • 1
                          #7
                          Hello, Our US-based software firm has internally developed an online timesheet program that is used by employees submitting their worked hours (log ins, etc;). This software is for sale currently (Jan 08) as a complete Intellectual Buyout (IP) sale - working code and all files/folders. Our company has just released the site from beta testing and now has several companies using it. We are selling it - even though successful - because the work differentiates from our organization's current goals. Please email to customerservice @onlinetimetrac ker.net for further information. Thanks!


                          Originally posted by cmrhema
                          Hi,

                          I am preparing an employee portal. As the employee logs in website he/she will be treated as present, if he has not logged in it will treated as absence.

                          This I have done. Now as he logs in I will compare with the previous day using datetime.add(-1) get the values and see whether he logged in the previous day. If not he will be required to fill out the reason of his absence. I will find out whether the day was sunday using day function. if so he will not be asked for any reason. Now my problem is if he puts leave more than one day Consider this situation an employee has taken leave on friday,saturday and sunday. saturday was some public holiday. Now only I have to ensure that friday was treated as absent not other days. Of course I will retrieve all the dates from where he last logged in.But how to proceed from now on.

                          Please give some idea.



                          Regards

                          cmrhema

                            Comment

                            Previous template Next
                            Working...