Cisco LAB Booking Site - Database & Calling Shell Scripts Knowledge - Required

I would like a business website preferably in Wordpress/Joomla or any of the content management system (CMS). The looks of the site and layout should be IDENTICAL to Juniper Networks - This business site allows clients to book their Cisco Lab time for the purpose of practice in preparation for their exam. The finished site will be hosted from my NAS - Synology RS812. Here is an overview of how the site should flow:

1. Clients are presented with a graphical calender for them to book a date and start time with a defined time interval; 4, 8 12, 24, 48, and 72 hours (These variables are stored for later use). When they are finished, a "Continue" button is pressed to transition to the registration page. The registration section will request for their valid email address, confirm email (Must match email address), password (Password must be between 8 and 14 characters), along with their full contact information; First Name, Last Name, Street Address, Suite/Apt Number, City, Province/State, Postal Code/Zip, and Country with all of them being a required field in order to continue. There should be two types of payment method made available for the client - Credit Card and Paypal. The client will choose either one before clicking the "Continue" button. The next page is a confirmation page with all their account information including the date and start time booked for the client to verify. They should have the option to go back and edit or change if an error is spotted. They should also have the ability later to change their appointment time as needed after registration through their login. As the appointment times are "booked", they are no longer available for another client to book that time.

3. Once the payment is processed and verified, PayPal is to redirect back to the business site with a confirmation statement to the client screen indicating that payment was successful and an email is sent to the client with it's log in credentials. If the client decided to pay via credit card system, payment should also be processed and verified with confirmation statement along with an email sent to the client with it's log in credentials, just like the PayPal method.

4. Once directed back to my website from paypal or the credit card system (confirmation statement page), you are required to call a shell script file that is located on the server. When calling this shell script, you will be responsible for passing in the following variables:

Username: Username is generated by the first character of their first name appended to their last name - all in small letter caps. For example, the name Matthew Jackson = "mjackson".

Password: Client password that client sets upon registeration.

Start Date: ex. "01 September 2013" - for single digit dates, a numerical "0" must prepended).

Start Time: In 24 hour format; ex. "08:00" = 8:00AM, 17:30 = 5:30PM).

End Time: Computed by adding the defined time intervals they selected in registration or login page; ex. [start time = 08:00] + [time interval = 12 hours] = "20:00".

End Date: The end date must be computed based on the [start date] + [time interval selected]; ex. Start date is "01. September 2013", time interval selected from client is 72 hours. Therefore, the end date is "04 September 2013".

Minutes: the time interval selected in hours must be converted in minutes.


When the client registers, if the email is not valid, a notification should pop up next to the email field informing the client. There will also be a "forget password" link below the password field on the login screen. I require a page where clients may log in with their email and password which bring them to their portal. Once logged in, they may change their user details such as email and password, etc... except their first and last name cannot be changed. Additionally, users may view their appointment time and reschedule appointment time (Only allowed up until 5 hours to booking. It should be locked and no modifications to booking is allowed) as well as booking a new appointment time AFTER their current booking expires. There can only be one booking session at a time and not multiple. They should also be able to see a history of their transaction - method of payment, amount paid and package selected, date and time stamp. A link named "Network Topology" is also made available for the clients to click on when they are in their portal. I will create the diagram for this link myself. Anytime a variable is changed by the client such as the username, password, reschedule appointment time or booking a new appointment time, the same shell script must be called again with the newly updated variables. Username will always remain the same as the client do not have the ability to change their first and last name. Payment system should also include PayPal AND my own credit card processing system directly from my site. Once payment is made, we must record the users appointment in a database and associate it with this client. The database table for this appointment should also have a column called "confirmed" which by default, is set to FALSE. I will require the query script to update this database in order to change it's value to TRUE. is needed As the administrator, I should have access to a master account where I can login and see all clients reflecting the database status under the column, "confirmed" - otherwise known as an admin panel. The admin panel should also include a calendar with all the booking times selected from all the users for a quick overview look. Each client's within the admin panel should be click-able whereby it displays all the client's account details including their password. I should have the read/write permission to change whatever information for the client I wish. Admin panel should also allow the administrator to modify pricing of time intervals. Lastly, a "Delete" button in the user account details should be made available in the admin panel whereby it will completely remove the client from the database and ANOTHER new shell script file must be called with the sames variables passed in from before.


If client selects the following packages:

4 Hours = $30

8 Hours = $50

12 Hours = $70

24 Hours = $100

48 Hours = $180

72 Hours = $300

* The developer I hire must accommodate and be understanding of minor changes required for this project as it won't be perfect the first time around. FULL testing of site functionality should be completed in order for it to meet the above requirements.

* If you have any questions, please let me know and I'll be glad to have a chat! Thank you! :)



1. You are to create a shell script file on the server from Step 4 (above). With the passed in variables, here are the exact commands, in order, that you must include in the shell script in order for the intended operations to function correctly:

/* --------------------CREATE.SCRIPT-------------------- */
ssh username@x.x.x.x
config terminal
time-range [username]
absolute start [start.time] [] end [end.time] []
group-policy [username] internal
group-policy [username] attributes
vpn-access-hours value [username]
vpn-session-timeout [minutes]
vpn-tunnel-protocol IPSec
username [username] password [password] privilege 0
username [username] attributes
vpn-group-policy [username]
service-type remote-access
write memory
/* --------------------CREATE.SCRIPT-------------------- */

* I will provide the SSH username, x.x.x.x (IP Address) and [admin.password] at a future date.

Once the script has executed successfully and completed, You are to update the database column "confirmed" from FALSE to TRUE.

2. You are to create another script for the purpose of account deletion with only the [username] variable passed in. When the admin or client presses the "Delete" button in the user account details page, they are prompted with a message to "Confirm delete?". Once pressed, the below shell script must execute.

/* --------------------DELETE.SCRIPT-------------------- */

ssh username@x.x.x.x
config terminal
no time-range [username]
no group-policy [username] attributes
no group-policy [username] internal
no username [username] attributes
no username [username]
write memory
/* --------------------DELETE.SCRIPT-------------------- */

Database must update with client's recorded deleted.

Skills: Database Administration, Graphic Design, Joomla, Shell Script, WordPress

See more: knowledge calling, write my own book, wordpress website design business site content, wordpress developer package, wordpress developer book, wordpress design packages, wordpress design by hour, which site do i create my own site, website packages pricing, website design packages wordpress, verified credentials, types of graphical design, the perfect business card, thank you letter format, thank you letter example, thank you letter email, start my own graphic design business, stamp website design, stamp design website, shell credit card

About the Employer:
( 1 review ) Toronto, Canada

Project ID: #4904836

4 freelancers are bidding on average $370 for this job


Hello, We are ready for this job, Please check Private Message. Regards.

$578 CAD in 7 days
(64 Reviews)

*******Dear Sir, We are experts with similar expertise to your project requirement. We are very much interested & eager to provide professional and quality service for you. Please check private message to discuss furth More

$235 CAD in 8 days
(51 Reviews)

Hello Sir, We have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and We are sure you will not be disappointed if you give us More

$278 CAD in 7 days
(28 Reviews)

Dear Sir, We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! More

$388 CAD in 3 days
(5 Reviews)

Please read my PMB

$360 CAD in 10 days
(5 Reviews)