if you wish to change the name of the database, the ip address, the account or the password
you must also change the constant DB_NAME in file timeclock/include/connect.php
create database mdr_clock;
use mdr_clock;
GRANT ALL PRIVILEGES ON mdr_clock.* TO 'timemaster'@'localhost' IDENTIFIED BY 'password';
The file timeclock/include/connect_utilities.php is for the admin users that run the site.
The 2 are seperate classes so you can have the admins users in another database if you wish.
Engine for table employee must be MyISAM if MySQL version is < 5.6
This table contains all of the employee information BARCODE and LNAME are the only required fields
drop table if exists employee;
create table employee(
employeeid integer unsigned not null auto_increment,
is_active boolean not null default 1,
barcode char(12) not null,
fname varchar(30),
lname varchar(30) not null,
email varchar(50),
add1 varchar(30),
add2 varchar(30),
city varchar(30),
st varchar(2),
zip varchar(10),
phone varchar(10),
social varchar(10),
hire_date timestamp not null default now(),
group_id varchar(30) DEFAULT NULL,
emergency_number varchar(10) DEFAULT NULL,
emergency_contact varchar(50) DEFAULT NULL,
primary key(employeeid),
unique key (barcode)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
This table contains all of the timestamps.
This is populated by program unless you have some history to add.
drop table if exists stamp;
create table stamp (
id bigint unsigned not null auto_increment,
employeeid integer unsigned not null,
punch timestamp not null default now(),
primary key(id),
index(employeeid),
index(punch),
CONSTRAINT FK_id FOREIGN KEY (employeeid) REFERENCES employee(employeeid)
) ENGINE=Innodb DEFAULT CHARSET=utf8;
This is for groups if you want to divide up the payroll
MUST HAVE at least one record.
drop table if exists groups;
create table groups(
id integer unsigned not null auto_increment,
groupname varchar(30) not null,
primary key(id),
index(groupname)
) ENGINE=Innodb DEFAULT CHARSET=utf8;
These are the users that can log into site and print reports
The default user is 'admin' with a default password 'tc#egp2017!'
DROP TABLE IF EXISTS users;
CREATE TABLE users (
userid int(11) NOT NULL AUTO_INCREMENT,
username varchar(50) NOT NULL,
hashed_password varchar(60) NOT NULL,
fname varchar(20),
lname varchar(20),
PRIMARY KEY (userid)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
INSERT INTO users ( username, hashed_password, fname, lname ) VALUES
('admin', '$2y$10$YWIyMDc3YWJkNzg0OGJiO.XajNA7hN8/YuihmMh19vDHTmBGR3qH.', '', ''),
Enter employees in table, the minimum information is barcode and lastname. The barcode length is set to 12. You can change that requirement in timeclock/admin/add_employee.php. I suggest you use checksum on the barcode to avoid reading errors.
They are now ready to use timeclock.
The username and passwords class (utilities) is separate from the MySQLiDatabase class so you can setup the accounts in another database. If you are using Active Directory you can use LDAP class to login using your windows account.
If you change the encryption settings
1 - login as admin
2 - change the encryption settings (don't exit or quit session)
3 - create a new account, this password will have your new settings.
4 - make sure you can login with the new account. Preferably in another browser so you can leave the admin signed in.
if it doesn't work, restore encryption settings and try again.
5 - if successful change the password of admin account, or delete it entirely.
6 - pick an image for background called work.jpg
You can contact me at edpol03@gmail.com