Function to upload an Excel file (.XLS, .XLSX) to MySQL using PHP and some outputs

Closed

Description

We have a control panel build in PHP with usernames and passwords for an HR firm. The Panel has 3 levels of users (admin,manager,client), when each type of user logs in, the menu changes depending on the user privileges. (This section is already build).

For admins: it only has the function to create, edit, and erase users, and their general data. The URL field is used only for clients and it is to let the panel know where the clients profile and work process is saved. (This section is already build).

For the managers: there will only have the option to pull the payroll corresponding to a previously selected week filtered by client and week number a simple form is fine. the output will need to be in a PDF so it cannot be edited. The PDF will need to look like the excel file attached (pre-nomina,xlsx).

If no data is found the program must trow a dialog box with the message: "No hay datos de la seleccion"

--

For clients: Since each client requires a different process all clients profiles are different and we will need to create a folder on the server for each one, so we can save the php files from each client in their respective folders. This folder will need to hold all the files needed to complete the tasks each client needs, the URL path will need to be saved previously in the user profile...

--

Implement the first client named: Zuribaja

This client has a raw dump from a biometric equipment used to check the in and out of each employee. we need to calculate how many days each employee worked, and their salary based on this file and other info.

In this first step, the client will need to upload the file from biometric equipment see example ([url removed, login to view]), the first column is the employee ID, employee name, and then each day starting from monday to sunday, 0 means employee was absent and 1 means employee was present. The client should select the file to upload, and he will also need to input in a text field the week number it belongs to, and then submit the file.

Based on this file which will be uploaded every week the software will need to calculate how many days the employee worked and whether it was present on sunday or not. Each time the client upload the excel file the software will take the the client to the next screen which will have to look like the attached file ([url removed, login to view]).

This next screen will be in HTML and will need to be edited by the user, each time the user edits the form it should automatically add,multiply or subtract to see realtime action, you can do this in JAVA or AJAX which ever you prefer, All fields should make calculations automatically like in the excel file attached. ([url removed, login to view]). This screen will have a SAVE button for the user to save the edited data. The program should alert the user if he has finished editing the data or not and he will need to confirm to save.

Once saved it cannot be modified, and it can only be accessed by a manager on their history section.

The salary will be default to $78/day no Mather what and it will need to be edited by the user if different.

After this is saved and each time the client uploads a new file, the software will send an email to all managers letting them know that a new file has been uploaded for them to be ready to download.

Skills: HTML, Java, MySQL, PHP, Website Design

See more: function php upload xlsx mysql, java excel file upload save, upload xlsx php mysql, what software needed to create a website, what can you do with php and mysql, to hold, salary of a hr manager, salary history example, salary history, php program to upload files, php and mysql pdf, payroll example excel, number function, need a hr manager, java and excel, hr payroll in excel, hr manager salary, how to program a website in java, how to make a website with profiles, how to design website by using html, how to create website by using html, how to create general website, how to create a website with user profiles, how to create a website with profiles, how to check a php program

Project ID: #5466987

Awarded to:

prashushinde9

Hi, I (Myself a senior PHP, ASP.NET programmer using C# and VB) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bu More

$257 USD in 10 days
(18 Reviews)
5.7

14 freelancers are bidding on average $224 for this job

kabirchy

A proposal has not yet been provided

$773 USD in 20 days
(922 Reviews)
8.5
DeamonBizz

We can help you. Please have a look on below links: http://www.smartmedia3.com/ http://zooeymagazine.com http://lifeinsurancequotes-online.org www.facelook.com www.miketyson.com http://bergenwatergarden More

$200 USD in 7 days
(117 Reviews)
7.1
trustus

Hello , We have a team of Skilled Java-J2EE professionals with experience up to 8 yrs. You will be able to directly communicate with our technical expert. Our Expertise is J2EE: 1) Frameworks: Struts More

$199 USD in 8 days
(82 Reviews)
7.0
mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

$226 USD in 7 days
(48 Reviews)
6.0
MakhijaRavi

Hello Sir/Madam, I have just seen your Job posting and upon reading thoroughly, I felt strongly that I would be the most qualified contractor for this project. My skills include Web Design, Graphic Design, and Web Deve More

$231 USD in 3 days
(20 Reviews)
4.9
solafort

Hi, sir. I'm interested in your job. I can do this perfectly. If you give me the chance to do this, I'll do my best and you will be satisfy. I hope to discuss more detail and forward/ Thanks

$260 USD in 3 days
(11 Reviews)
4.4
jblsolution

hi,i have already done same type of work i can do now please contact me work will be start now READY TO START YOUR WORK NOW... s k ype bhagyavendra1 NO NEED TO PAY NOW.FIRST I WILL GIVE YOU UPDATE THEN YO More

$103 USD in 1 day
(23 Reviews)
4.3
websoftrajesh

• Five+ years of experience as PHP Web Development programming. • Excellent team player with positive attitude • Familiar in Magento, Joomla,OpenCart, code-igniter and Wordpress • High knowledge of MySql and More

$133 USD in 3 days
(16 Reviews)
4.1
mehul12nagar

hi sir i understand your requirements and ready to start it now. i can easily complete this in just 3days with quality. i will not waste your time. i am right now doing the same project as your requirements. i have cr More

$166 USD in 3 days
(3 Reviews)
3.9
seofutureprofile

Hello, I would like to work for you in this project. I have 3+ years of experience in Website Development and website designing. Please review some of websites developed by us: www.care-dynamic.net, www.solarwind More

$100 USD in 4 days
(1 Review)
3.5
phpcheenu

Hello sir, I have done this type of work many time. we will deliver you work ASAP. We have good experience of Photoshop,Banner Design ,Flayer mail, .NET,Logo Design, PHP, HTML,HTML5,CSS,JavaScript,Mysql,JOOMLA,wordpr More

$80 USD in 1 day
(12 Reviews)
2.4
prajapatidilip

Hi i am ready to start this work. i will Provide Web Solutions Fast - Accurate - Professional. Our main target is 101% client satisfaction. We are part of a Professionals network.. i have brief knowledge of More

$64 USD in 4 days
(3 Reviews)
1.6
CWP10

Hello....I have an experience of more than 4 years in web development and maintenance. I have in-depth knowledge of php, mysql, jquery, paypal integrations, API's, css, html, html5. We have gone through the details More

$98 USD in 6 days
(5 Reviews)
1.6
akansha511

Hello , I have 6+ year experience in web development using PHP/MYSQL. I am working on all major CMS's (like wordpress, joomla etc..) , MVC's (like codeigniter , cakephp etc..) , Smarty Template of PHP. i h More

$155 USD in 3 days
(0 Reviews)
0.0
sevenmmo

A proposal has not yet been provided

$222 USD in 3 days
(0 Reviews)
0.0
DaisyShah

Hello, i have checked your project and would like to have your project. I am confident to fulfill your requirements in timely manner, along with quality work. Please check your pmb.

$155 USD in 3 days
(0 Reviews)
0.0