Giter VIP home page Giter VIP logo

timeclock's Introduction

NOTE

This version/fork of Timeclock is abandoned, please consider using the fork linked below.

https://github.com/BoatrightTBC/timeclock

About

This project is PHP Timeclock v1.04 with the Punchclock v0.8 add-on already installed.

Timeclock - What Is It?

(from http://timeclock.sf.net/ ...)

It is a simple yet effective web-based timeclock system. It allows you to track all employee time as well as upcoming vacations and more, and it can replace manual sign-in/sign-out sheets.

An administration piece is included which allows an administrator to add or delete users, change a user's time or password (if using passwords is enabled), and hide the reports from your users where only an admin or a reports user has access to them. These reports can be run to show daily activitiy or for a range of dates, and can be run for all users, or individually for each user.

This product is distributed under the GPL. This program is free software; you can redistribute it and/or modify it under the terms of the GNU GeneralPublic License version 2, as published by the Free Software Foundation.

Punchclock - What Is It?

(from http://www.acmebase.org/punchclock/ ...)

Punchclock is a drop-in enhancement to the Open Source PHP Timeclock software.

Punchclock enhances PHP Timeclock with 5 extra features:

Computes overtime hours.
Keeps time cards for each employee.
Punchclock entry intended to replace your punchclock at the door.
Personal data entry screen for office personnel and mobile devices.
Flexible export to your spreadsheet or business software.

PHP Timeclock Version 1.04 http://sourceforge.net/projects/timeclock Copyright (C) 2006 Ken Papizan <pappyzan_at_users.sourceforge.net>

REQUIREMENTS:

  • at least PHP 4.1.x, with mysql support
  • MySQL
  • Webserver

TESTED:

  • PHP 4.34, 5.1.2 with mysql support
  • MySQL 3.23.49, 4.0.17, 5.0.18
  • Apache 1.3.22, 1.3.29, 2.2.0
  • Firefox 1.0 - 1.5.0.4, Firefox 1.0 Preview Release, IE 6.0 SP1, IE 6.0 SP2 for XP, IE 7.0 beta 2

Any version of mysql or webserver software that supports php, whether it's an earlier version than what's tested or later, will probably work fine.

##Installation

New Install


  • Unpack the distribution into your webserver's document root directory.
  • Create a database named "timeclock" or whatever you wish to name it.
  • Create a mysql user named "timeclock" (or whatever you wish to name it) with a password.
  • Give this user at least SELECT, UPDATE, INSERT, DELETE, ALTER, and CREATE privileges to ONLY this database.
  • Import the tables using the create_tables.sql script included in this distribution.
  • Edit config.inc.php.
  • Open index.php with your web browser.
  • Click on the Administration link on the right side of the page. Input "admin" (without the quotes) for the username and "admin" (without the quotes) for the password. Please change the password for this admin user after the initial setup of PHP Timeclock is complete.
  • Create at least one office by clicking on the Create Office link on the left side of the page. You MUST create an office to achieve the desired results. Create more offices if needed.
  • Create at least one group by clicking on the Create Group link on the left side of the page. You MUST create a group to achieve the desired results. Create more groups if needed.
  • Add your users by clicking on the Create New Users link, and assign them to the office(s) and group(s) you created above. Give Sys Admin level access for users who will administrate PHP Timeclock. Give Time Admin level access for users who will need to edit users' time, but who will not need Sys Admin level access. If you require the reports to be secured so only certain users can run them, then give these users reports level access.

Migration from another verison of 1.04 (ie: old official release)


  • Backup your current install directory and database.
  • Delete all files in your current install directory.
  • Copy all files from a zip of this repo's master branch (https://github.com/andrew867/timeclock/archive/master.zip) into your install directory.
  • Modify the new config.inc.php file to match your old settings, make sure you correctly set your timezone in php.ini (recommended) or config.inc.php.

##Roles Admin level access and reports level access are completely separate from each other. Just because a user has admin level access does not give that user reports level access. You must specifically give them reports level access when you are creating or editing the users, if you choose to secure these reports for these users. To make PHP Timeclock lock down the reports to only these users, set the use_reports_password setting in config.inc.php to "yes".

##License


This software and changes made are licensed under the GNU GENERAL PUBLIC LICENSE 2 as found in docs/LICENSE

timeclock's People

Contributors

andrew867 avatar benscanfiles avatar duelafn avatar nexis81 avatar wjgeoghegan avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

timeclock's Issues

edit settings in timeclock

every time I go to edit system settings and click next I get an error at top paig that says undefined meter and the home page throw errors and all the displays are gone.. I am not able to edit settings at all and save.

usersearch.php

A server error 500 occurs when trying to view the usersearch.php page.

The problem is line 412 has a echo line being split into two lines causing line 412 to start with a %. lines 411 and 412 should be combined.

Edit System Settings is not working.

I have installed the master repository. When I click "Edit System Settings" I get a blank page. The Debugger shows an error in the function office_names(). The debugger indicates a problem in the following code:

function office_names() {
var select = document.form.office_name;
select.options[0] = new Option("all");
select.options[0].value = 'all';

    select.options[1] = new Option("Main");
    select.options[1].value = "Main";
}

It highlights the line "select.options[0] = new Option("all"); and says "Uncaught TypeError: Cannot read property 'options' of undefined".

I've managed to debug all the other minor issues, but I can't seem to figure this one out.

Can't detele time

if i try to delete a time i get

Warning: preg_match() [function.preg-match]: Unknown modifier ',' in /var/www/xn--pizzalg-v1a.dk/punch/admin/timedelete.php on line 288
No time for was found in the system for Kasper on //.

but if i go and edit there are a time

No migration documentation

Moving from Timeclock-1.04 to the Andrew867/timeclock, there is no explaination of migration path. Whatever migration changes to be done, if any, should be outlined.

running report

Is anyone else getting Warning: preg_match(): Unknown modifier '|' in /home/veasnak/public_html/time/reports/timerpt.php on line 247

"Computes overtime hours."

how is this done? i cant find anywhere to tell workhours

and it must need to know workhours etc before it can figure overtime

Calendar error

Date format is invalid. Please choose a date from the Date Picker if you are unsure of the date format you chose within the System Settings. in addtime.php and deletetime.php

some errors

as per BoatrightTBC fork of timeclock these following errors show up when performing certain tasks

https://pilotweb.nas.faa.gov/qryhtml/icao/ the link is dead

trying to delete a time clock entry for a user: Warning: preg_match(): Unknown modifier ',' in C:\xampp\htdocs\timeclock\admin\timedelete.php on line 288

Notice: Undefined variable: tzo in C:\xampp\htdocs\timeclock\admin\timeadd.php on line 546

Notice: Undefined variable: tzo in C:\xampp\htdocs\timeclock\admin\timeadd.php on line 693

hours workded report shows a different time than the time that was entered

can not find metar for the city of cleveland, OH as the above link is dead

Notice: Undefined index: metar in C:\xampp\htdocs\timeclock\admin\sysedit.php on line 1282
@BoatrightTBC

$use_client_tz is not working correctly

A DB column added to the user and set each user's home timezone independently of the server. You could then use the date_default_timezone_set() function with the returned user timezone.

Relying on Javascript to set a timezone and cookie is just asking for trouble. This is good for a company who has users in different areas.

Adding onto the new DB column fix, adding an option to enable a 'select current timezone' dropdown on the punch in/out page that would override the user selected and server timezone. This is good for users who are on the road.

Installation on Hosted account

I'm a GoDaddy shared hosting (NOT dedicated) customer. I have tried installing every version, however none work "out of the box". I can modify the config file and connect, the problem is that my logged in status doesn't get reported to any daughter pages like createoffice.php. I know that there are SESSION variables that are dying/not getting passed to daughter pages. Therefore, prompted to login time after time after time. I like what I see - What would it take to get this to run on my GoDaddy webspace?

timedelete.php fails because of a bad regex on line 289

As a workaround, I changed the regex seperators to % symbols like this:
elseif (preg_match('%' . "^([0-9]{1,2})-,/,.-,/,.$" . '%i', $post_date, $date_regs))

Now the error I am getting is about $tso not being set. As a workaround I set $tso = 0 at the top of the file. Now the delete function works.

erros that pop up when using the punchclock

first error is

Notice: Use of undefined constant print_header - assumed 'print_header' in C:\xampp\htdocs\time2\punchclock\lib.timecard.php on line 164

Notice: Use of undefined constant print_row - assumed 'print_row' in C:\xampp\htdocs\time2\punchclock\lib.timecard.php on line 164

Notice: Use of undefined constant print_footer - assumed 'print_footer' in C:\xampp\htdocs\time2\punchclock\lib.timecard.php on line 164

then if I try to edit and fix I get this error when I refresh the page

Parse error: syntax error, unexpected end of file in your code on line 174?>

•PHP Syntax Check: Errors parsing your code

?>

Php error

first error is

Notice: Use of undefined constant print_header - assumed 'print_header' in C:\xampp\htdocs\time2\punchclock\lib.timecard.php on line 164

Notice: Use of undefined constant print_row - assumed 'print_row' in C:\xampp\htdocs\time2\punchclock\lib.timecard.php on line 164

Notice: Use of undefined constant print_footer - assumed 'print_footer' in C:\xampp\htdocs\time2\punchclock\lib.timecard.php on line 164

then if I try to edit and fix I get this error when I refresh the page

Parse error: syntax error, unexpected end of file in your code on line 174?>

•PHP Syntax Check: Errors parsing your code

?>

A valid From Date is required.

I downloaded and installed the latest. Ran the create_tables.sql. When I try to run a report... I get the following: A valid From Date is required.

I also noticed that the user summary page is blank.

Am I missing something?

Replacement for discontinued NOAA metar site

The phpweather.php downloads its metar data from

http://weather.noaa.gov/pub/data/observations/metar/stations/$station.TXT

where $station is the 4 character ICAO code for a location.

This service is discontinued as explained at http://www.nws.noaa.gov/om/notification/scn16-16wngccb.htm

In fact, the entire weather.noaa.gov site was dropped in favor of weather.gov for most purposes. However, the METAR data is still available at

http://tgftp.nws.noaa.gov/data/observations/metar/stations/$station.TXT

where $station is an upper case 4 character ICAO code. The change goes on line 141 and 142 of phpweather.php, or you can replace phpweather with a different weather display library as in the fork at https://github.com/BoatrightTBC/timeclock

Admin Login

I am unable to log into the admin area.

This is the result when I try to log in "Could not log you in. Either your username or password is incorrect."

All the installation steps were followed correctly.

Page: https://www.sunsetoutsourcing.com/

Puncs card and time clock as SaaS

Hi Andrew,
Cold you please make an offer to develop an APP, with the functionality of punch in - out, with measuringactivities among the punch on-air, with at least four layers of activities, such as; working for company, business unit, activity. It should have mobile we code reader capabilities, for android, iOS, windows phone, and windows desktop.
Call me +36209388468 I'm at CET.

PHP7 Support?

I am assuming why I am getting a white page is because I am trying to do this in a PHP7 env.

Fatal error: Uncaught Error: Call to undefined function mysql_pconnect() in /var/www/timeclock/header.php:33

CSV audit reports missing data

I cant seem to figure it out, but when the "audit" is ran, and the csv option is selected, the name of the user modified is displayed, but it is not in the csv file. I have tried to add the code to get_csv.php but cant seem to get it right.

Errors on IPhone

When you restrict by IP, the IPhone 5 (Not on IPhone 4S)displays the Timeclock page and you get to view every staff member in the office along with Warnings mysql_query() access denied over an 4G LTE network. On all of the pages.
Warning at the top of the page Your database is out of date". It is not present when the IP restriction enables the IP via a Wifi network.

On the Android the restriction seems to work fine with "You are not authorized to view this page message". No user data is displayed.

Reports timezone is always in GMT

I have a potentially serious blocking bug, and that is that reports ignore the local timezone and are always in GMT. Dealing with date/time functions in php is not one of my stronger areas and I really need some help in fixing it. Even with using the server time, and client offset time, time displayed on reports AND on the main home screen are always in GMT. I have checked the cookie and have verified that it has the correct offset (-480 GMT-8). This cookie seems to get sent/set regardless of the settings you have chosen.

Personally, I would prefer to have a timezone setting in the settings page where I could simply choose what timezone I wanted to use globally. I've looked into this but frankly I'm not sure how I would do it. For the moment I need this particular bug solved before I can invest tons of time into it.

Punches are stored in local timezone

Currently punches are stored in info in the local timezone instead of GMT. Timeclock should be changed to store all punches in GMT and add another column that specifies the timezone it was created in.

README

Your README doesn't say much at all. Could you perhaps copy over the information from the link provided into the README.md format? It would be much clearer. Thanks!

Neither the "User Summary" nor "User Search" functions work in Admin screen

Neither the "User Summary" or "User Search" functions worked in the Admin screen - just got a blank page for both. Turns out both useradmin.php and usersearch.php have a commented-out line with an spurious line break in the middle of the line. Sorry, don't have line numbers, but look for a line starting with "%>" (without the quotes) in each of those files.

sysedit.php usage results in errors.

using sysedit.php does work. however, using it results in config lines being removed because of the method used for gathering the values from the config.inc.php file.

sysedit.php is not aware of the following:

/* Display weather in US or metric measurements. Options are "f" or "c". Default is "c" */
$weather_units = "f";

Using sysedit.php will cause the following error to occur due to the problem described above.
Undefined variable: weather_units in /path/to/phptimeclock/leftmain.php on line 85

Timezone not Sync with Client TZ Setting

My server in located in another state, if I want to use the old setting that allows you to use Client timezone, The settings do not sync over to Timeclock or punchtime plug-in. I was wondering if they are setup with the same configuration file as the original?

Changing the first day of the week

Hello,

Great saas soft used by a local radio in France. (http://www.radiocampustours.com) I am actually searching a clue in order to define the first day of the week as Monday and not Sunday. Where to fix this parameter please ?

I am also trying to be able to delete the information on a day as the issue #24 and others describe. I can't get through because it do not even want to search with the date I define, here is the message : "No time for was found in the system for samuel on //." What should I have to do please ?

Kind regards

Stéphane

Which of the Forks is the Successor?

Thx andrew867 for taking up this project. But with development here halted for some time, is there a particular fork (of the 46 at this writing) that can be named as the 'official successor'?

Notable is BoatrightTBC's (https://github.com/BoatrightTBC/timeclock) with 18 further commits. Starting with that version myself since it beats going through each fork one-by-one.

Problem with reserved word Group in mysql

Hallo People,

i have problem that the word group is a reserved word.

In great_tables.sql i bypassed it by givin ` to all group word.

But so i can not add a group.

SQL version is 8.0.27

Can anybody help me how to bypass?

Greetings Markus

duplicate punches are allowed

It is currently possible to punch "in" or "out" multiple times in a row. An employee could punch in when they arrive and when leaving accidentally press "in" instead of out again. Shouldn't the code validate the current status and make it unavailable to select again?

Editing time gives: A valid Time is required

I can add and delete times fine

But when i try to edit a staff time i get: A valid Time is required.

I have set my system for 24 hours without leading zero and it does not accept the time 22:57 when i try try to edit

Any Clues?

Thanks for keeping this one alive

Unable to create groups

Unable to create or show groups. Install the latest - master 05-05-21. Ubuntu 20.04, PHP 7.4.3. I even create Groups in the database but they are not shown in the Group Summary., when I create a group it states it "Group created successfully." but it never shows up in the Database.

Problem with create_tables.sql

I am trying to create my table on my Yahoo web host and when I try and run


CREATE TABLE audit (
  modified_by_ip   VARCHAR(39)  NOT NULL DEFAULT '',
  modified_by_user VARCHAR(50)  NOT NULL DEFAULT '',
  modified_when    BIGINT(14)   NOT NULL,
  modified_from    BIGINT(14)   NOT NULL,
  modified_to      BIGINT(14)   NOT NULL,
  modified_why     VARCHAR(250) NOT NULL DEFAULT '',
  user_modified    VARCHAR(50)  NOT NULL DEFAULT '',
  PRIMARY KEY (modified_when),
  UNIQUE KEY modified_when (modified_when)
)
  ENGINE =MyISAM;

I get and error mesage, "Unclosed quote" and #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''',
modified_by_user VARCHAR(50) NOT NULL DEFAULT '',
modified_when ' at line 2

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.