1. Start
  2. App Feature
  3. How to Setup(Videos)
  4. How to Upload & Setup
  5. Employee Attendance By Whitelisted IP
  6. Front End Job Application New
  7. Getting Attendance From Machine
  8. Technical Description
  9. Project File Structure

Royex

Version:2.0


 

Royex Application (Yahoo! Now It's Having a nice landing page in front)


Remember You Will Get HR backend (software) section in https://yourdomain.com/dashboard in newer version because it will have front end in root url 😊


Firstly, a huge thanks for purchasing this Royex, your support is truly appreciated!
Royex is a Open Source Human Resource and payroll management software. For maintaining HR & Payroll department of any company.

Royex Key Features
Full Features

 





How to Setup(Videos)


You Can See This Video Tutorial As a Reference for uploading into cpanel

How to setup or Install


Step 1

Step 2

Step 3


How to use

Login with pre-defined access first.

Dashboard

In Dashboard Some features of application will show ... as like todays attendnance ,if have any notice then it will show,Birthday,Leave Application to you,Warning etc.

Role

You Can Create Role For Different kind of user (don't delete super admin role from your application you can update the name !)

Role Permission

Which Role of application will find which menu you can control it from here ( employee and admin will have same admin panel but based on there permission they will have specific menu which is permit to them )

Employee Manage

Add edit delete employee are done from here . you have to set up Department Designation Branch before creating employee.During Creating employee if u select any supervisor he will find leave application of you and he will confirm or cancel it . Cool !.(Remember Supervisor Will Have The Leave Application of those employee which is belongs To him..Supervisor will accept or decline there request)

Employee Warning

Admin can send warning to any employee.Employee will find the warning notice into dashboard when he login his account

Employee Warning

Admin can send warning to any employee.Employee will find the warning notice into dashboard when he login his account


Terminate

Admin Can Terminate anyone from this module


Attendance by whitlisted ip New

Employee Now Can Update there Attendance By Check in / out from dashboard by whitelisted ip.You can also disable ip checking during attendance.

for finding setting and adding whitelisted ip please go to the menu attendance->setting->dashboard attendance

If you buy after this update u don't need to follow below steps

If u already using/buyed our system and wanting to update with this attendance system follow the bellow instruction (new buyer will get the system already in database)

Go To Your phpmyadmin and inside royex database on query section run this two query

CREATE TABLE `ip_settings` ( `id` int(10) UNSIGNED NOT NULL, `ip_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ip_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = not checking it 1 = checking ip', `status` tinyint(4) NOT NULL COMMENT '0 = not providing employee self attendance 1 = providing', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `ip_settings` (`id`, `ip_address`, `ip_status`, `status`, `created_at`, `updated_at`) VALUES (1, '127.0.0.1', 0, 1, NULL, '2020-07-19 04:32:30');

And Run Bellow Query for Creating whitelisted_ip table

CREATE TABLE `white_listed_ips` ( `id` int(10) UNSIGNED NOT NULL, `ip_setting_id` int(11) DEFAULT 0, `white_listed_ip` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Run This Query To Add The Setting Menus

INSERT INTO `menus` (`id`, `parent_id`, `action`, `name`, `menu_url`, `module_id`, `status`) VALUES(64, 18, NULL, 'Dashboard Attendance', 'attendance.dashboard', 4, 1);

Now Provide Permission to this menu from role permission and update your attendance setting as you want. and replace old file manger file by new software file you are done

Now People Can Apply To Job From Front End New

You will have front end in hr now there user can apply to job . and a premium landing page for adding your service about and basic contact page your backend software will be in https://yourwebsite.com/dashboard because it will have landing page in root url

for finding front end setting and service you have to go into setting->front end setting menu

If you buy after this update u don't need to follow below steps

If u previously buyed our application now wants to update with this front end option

First Replace All File And Folder with new download (if u have uploaded file then don't replace uploads folder)

Go To Your phpmyadmin and inside royex database on SQL section run this 4 query ( Or If u want to do it by uploading file then newly added database table will be given in a folder called new_db_table just import those table )

CREATE TABLE `services` ( `id` int(10) UNSIGNED NOT NULL, `service_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `service_icon` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `status` tinyint(4) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Bellow Query Will Create Front Setting table for controlling front end based on condition

CREATE TABLE `front_settings` ( `id` int(10) UNSIGNED NOT NULL, `company_title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `home_page_big_title` text COLLATE utf8mb4_unicode_ci NOT NULL, `short_description` text COLLATE utf8mb4_unicode_ci NOT NULL, `service_title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `job_title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `about_us_image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `logo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `footer_text` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `about_us_description` text COLLATE utf8mb4_unicode_ci NOT NULL, `contact_website` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `contact_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `contact_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `contact_address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `counter_1_title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `counter_1_value` int(11) NOT NULL, `counter_2_title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `counter_2_value` int(11) NOT NULL, `counter_3_title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `counter_3_value` int(11) NOT NULL, `counter_4_title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `counter_4_value` int(11) NOT NULL, `show_job` tinyint(4) DEFAULT 1, `show_service` tinyint(4) DEFAULT 1, `show_about` tinyint(4) DEFAULT 1, `show_contact` tinyint(4) DEFAULT 1, `show_counter` tinyint(4) DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

And Run Bellow Query for Creating basic setting data to start you can change them later from back end

INSERT INTO `front_settings` (`id`, `company_title`, `home_page_big_title`, `short_description`, `service_title`, `job_title`, `about_us_image`, `logo`, `footer_text`, `about_us_description`, `contact_website`, `contact_phone`, `contact_email`, `contact_address`, `counter_1_title`, `counter_1_value`, `counter_2_title`, `counter_2_value`, `counter_3_title`, `counter_3_value`, `counter_4_title`, `counter_4_value`, `show_job`, `show_service`, `show_about`, `show_contact`, `show_counter`, `created_at`, `updated_at`) VALUES (1, 'Royex', 'Royex - HR and Payroll Management Software', 'Royex is a Human Resource and payroll management software. For maintaining HR & Payroll department of any company', 'Service We Provide', 'Start Your Career With US', 'about_us.jpg', 'logo.png', '© 2020 Royex by BDWEBTRICKS', 'Aenean eros et nisl sagittis as vestibulum at Nullam nulla eros ultricies site amet nonummy id imperdiet feugiat pede as Sed lectuse Donec mollis hendrerit Phasellus at nec sem in at pellentesque facilisis at Praesent congue erat at massa Sed sit cursus turpis vitae tortor that a Donec posuere as vulputate arcu Phasellus accumsan velit.\r\n\r\nMaecenas tempus tellus eget as that condimentum rhoncus sem quam semper libero amete adipiscing sem neque sed ipsum Nam quam nunce blandit at luctus pulvinar hendrerit id lorem Maecenas nec et ante tincidunt tempus.\r\n\r\nSed consequat leo eget bibendum sodales augue at velit cursus nunc.', 'https//:royexbd.com', '0283932949', 'example@gmail.com', 'Royex LTd, 12005 NY', 'Project Done', 120, 'Content Written', 220, 'Client', 200, 'Training', 230, 1, 1, 1, 1, 1, '2020-09-23 04:43:29', '2020-09-24 01:04:04');

Run This Query in menus table in sql section to Add The Setting Menus

INSERT INTO `menus` (`id`, `parent_id`, `action`, `name`, `menu_url`, `module_id`, `status`) VALUES(65, 0, NULL, 'Front Setting', NULL, 11, 1), (66, 65, NULL, 'General Setting', 'front.setting', 11, 1), (67, 65, NULL, 'Front Service', 'service.index', 11, 1);

Now Provide Permission to this menu from role permission and update your front end setting as you want. and replace old file manger file by new software file you are done

Getting Atendance From Api

Remember For Getting Attendance Data from any kind of device make sure device Finger ID or Face ID,or some others ID, will have to be same with the employee Finger ID field during employee adding.

U have to use the .htaccess file different for that in server u will provide a .example_htaccess you can use it replace of .htacess

You Have To Call The API by POST method https://your_application_domain/api/attendnance from your attendance device with a perameter finger_id and an optional in_out_time perameter which will current timestamps if u don't give it the software will use the current time as in_out_time .. your first hit to the api will count as in time and last as out time . you can use postman for test in our application

Here is a Sample PHP Request with curl (you can request from any paltform)

              "http://http://hrms.limmexbd.com/api/attendnance?finger_id=4",
             CURLOPT_RETURNTRANSFER => true,
             CURLOPT_ENCODING => "",
             CURLOPT_MAXREDIRS => 10,
             CURLOPT_TIMEOUT => 0,
             CURLOPT_FOLLOWLOCATION => true,
             CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
             CURLOPT_CUSTOMREQUEST => "POST",
             ));

             $response = curl_exec($curl);

             curl_close($curl);
             echo $response;

             ?>
         

if request success the response will be
{ "status": 202, "message": "Employee attendnance updated" }

Technical Description


Technologies:

Technologies: we build this application using php laravel framework ,javascript and Jquery ajax

free Tools & Dependencies Used


Project File Structure


File Include

Royex

  - app

    - Http

      - Controllers

     - Middleware

     - helpers.php

     - Model

- Config

- public

   - js

     - all compiled js file

  - css

- resource

   - View

- route

   -web.php

- .env

- .htaccess

- composer.json

- index.php

- package.json


 

Once again, thank you so much for purchasing this Royex Full Application.
As I said at the beginning, We'd be glad to help you if you have any questions relating to this application. We I'll do our best to assist.

Thanks

iGlyphic