Interactive PHP/MySQL Report Generation

$30-250 USD

Igangværende

Slået op

2 måneder siden

$30-250 USD

Betales ved levering

I need a capable and experienced PHP/MySQL developer to create an interactive historical results report for me. The report will be generated based on user-selected parameters in a web page. Data to be arranged in tables, generally organized like in the attached image. A list of departments is in another of the attached images. User should be able to click to hide/display prior years and click to hide/display min/avg/max values as well. At the bottom of the report, a grand total section that includes all departments should be displayed in a similar fashion as the departments. The MySQL query that is used to obtain a given total from the data is: ------------------------ SELECT SUM(llx_facturedet.total_ht) AS Total FROM llx_facture AS t LEFT JOIN llx_societe ON t.fk_soc = [login to view URL] LEFT JOIN llx_facturedet ON [login to view URL] = llx_facturedet.fk_facture LEFT JOIN llx_product ON llx_facturedet.fk_product = [login to view URL] WHERE llx_product.accountancy_code_sell = "4012" AND YEAR([login to view URL])='2023' AND MONTH([login to view URL])='12' ------------------------ Access to live data will NOT be provided. mysqli should be used. - Report Format: The report should be generated and displayed in HTML format and should look nice. Ideal Skills and Experience: - Proficiency in PHP and MySQL is a must. - Prior experience in creating dynamic, user-friendly web interfaces. - Ability to build flexible databases to accommodate future updates to data fields in the report. - Extensive experience with HTML for report generation.

Projekt-ID: 37844629

Om projektet

91 forslag

Projekt på afstand

Aktiv 2 måneder siden

Leder du efter muligheder for at tjene penge?

Emailadresse

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme

Bliv betalt for dit arbejde

Oprids dit forslag

Det er gratis at skrive sig op og byde på jobs

Tildel til:

@VadymLes

❤️Hi Eriks G.❤️ Thank you for considering my bid. I have carefully read your requirements and understand what want. This opportunity interests me because I have extensive experience and deep knowledge in this field, including MySQL, PHP, JavaScript and HTML. I have previously completed very similar work and can deliver excellent results within a short time frame. Please feel free to message me to discuss further details about your project. I am looking forward to the possibility of working with you. Best regards, Vadym Les.

$135 USD på 2 dage

5,0

(2 anmeldelser)

2,7

91 freelancere byder i gennemsnit $164 USD på dette job

@webperfection123

Hi There, I am a capable and experienced PHP/MySQL developer to create an interactive historical results report for you . I have read your job description and assure you that I am a perfect fit for the job.I am a senior Designer & Developer having vast and proven experience in web development and Web Designing using PHP, wordpress , WooCommerce ,Shopify, magento 1 & 2, Bootstrap, Opencart ,CS-Cart, Laravel, Codeigniter , Yii, React JS , Angular JS , Vue JS, javascript, jquery, PSD to HTML conversion , PSD to Wordpress , graphic design , UX/UI, CSS, HTML, MYsql, JavaScript , AJAX, APIs and many other. I'm available right away to discuss the requirements. Looking for the soonest reply from you. Thanks

$250 USD på 3 dage

4,9

(318 anmeldelser)

8,2

@seefattechnologi

Hello~~~~~I am here to creating interactive historical results report for you as per the given attachments and description ~~~~I have done so many similar Task in past as well. I will complete this task effectively. Let’s have a quick discussion over chat Thanks !!

$310 USD på 5 dage

4,9

(149 anmeldelser)

8,0

@BZain

Hi I read all, understood the task required from Attached Images and great with PHP/MySQL I am Confident PHP Developer and have 8+ years of expertise in field, delivered tons of CRMs, CMS, ERPs and much more I also have great expertise working with APIs, ReactJS, Custom JS, Ajax and much more ... My Profile Reviews speak for my Quality Work and I assure you won't regret working with me on this :)

$220 USD på 3 dage

5,0

(154 anmeldelser)

7,7

@divumanocha

Hello Greetings, After going through your project description, I feel confident and excited to work on this project for you. But I have some crucial things and queries to clear out. Can you please leave a message on chat so we can discuss this and I can share my recent work similar to your requirements? Thanks for your time! I look forward to hearing from you soon. Best Regards

$250 USD på 4 dage

4,9

(131 anmeldelser)

7,6

@techwelfare

PHP AND MYSQL EXPERTS! We are working on php and mysql since last 11 years. We could do it. Could we discuss in details over chat now? Best Regards Techwelfare

$250 USD på 15 dage

4,7

(238 anmeldelser)

7,6

@smrutiran

Hi , I am php expert and 12 year web development experience. I can solve your any kind of issue on site. you can view my profile at https://www.freelancer.com/u/smrutiran Please let me know if you are interested. Thanks Mishra

$140 USD på 7 dage

5,0

(16 anmeldelser)

6,9

@usamae

Hi there! Your project sounds intriguing and right up my alley. I have a solid background in PHP, MySQL, JavaScript, and HTML, making me a great fit for creating interactive reports like the one you described. I'm excited about the opportunity to collaborate on this challenging project. Could you provide more details on the specific user parameters and customization options you'd like to see in the report?

$250 USD på 7 dage

4,9

(102 anmeldelser)

6,5

@bestphpjobs

Our bid encompasses the development of a tailored interactive historical results report, driven by our expertise in PHP, MySQL, HTML, and JavaScript. We'll craft a user-friendly interface allowing seamless parameter selection and dynamic report generation. Starting with meticulous database design, we'll ensure efficient storage and flexible querying capabilities, empowering your team with insightful data analysis. Using PHP's mysqli extension, we'll establish secure connections to your MySQL database, prioritizing data integrity. On the frontend, we'll employ HTML, CSS, and JavaScript to create an intuitive web interface. Users can effortlessly toggle between prior years and view min/avg/max values, enhancing their analytical experience. Our commitment to quality encompasses thorough testing across browsers and devices, ensuring seamless functionality and compatibility. Post-deployment, we'll provide comprehensive documentation and ongoing support to facilitate seamless integration into your workflow. Empower your team with actionable insights derived from your historical data. Partner with us to unlock the full potential of your data assets and drive informed decision-making. Let's embark on this journey of innovation together.

$159 USD på 2 dage

5,0

(252 anmeldelser)

6,6

@indiainfosoft

As an experienced and dedicated PHP developer with over 18+ years in the field, I am confident in my abilities to deliver your interactive historical results report with precision and efficiency. My profound knowledge of PHP permits me to work collaboratively or independently, whilst still delivering top-tier results. I have had extensive experience in creating dynamic, user-friendly web interfaces similar to the one you require making this report generation project right within my wheelhouse. Furthermore, my expertise extends to building and maintaining flexible databases, which will be invaluable for future-proofing the data fields in your report. Though access to live data won't be provided, I assure you that using mysqli I can connect seamlessly with your database and create a streamlined solution for analyzing it. I also excel at using HTML for report generation and can ensure that the reports are not only accurate but also aesthetically pleasing. Finally, let's not forget about my Android and iOS developing team who have been utilizing their skills for over 8+ years. This means your mobile audience will get the same high-quality experience as those accessing from a desktop. Rest assured of a 100% quality work from me and dedicated support even after project completion. Let me turn your vision of powerful visual data representation into reality – choose me for your project today!

$180 USD på 2 dage

4,9

(247 anmeldelser)

6,7

@sellingsparrow

Hello, Hope you are doing well, I reviewed your project thoroughly. I posses over 8+ years of extensive experience and intimate knowledge of HTML, CSS, JavaScript, PHP and MySQL. I can proficiently utilize PHP to handle user requests and interact with the MySQL database, develop SQL queries to retrieve data based on user-selected parameters such as year, department, etc. I can efficiently design a user-friendly web interface using HTML and CSS for the report display and implement JavaScript/jQuery for interactivity, such as hiding/displaying prior years and min/avg/max values. I can design a flexible database structure to accommodate future updates to data fields in the report, normalize the database to minimize redundancy and ensure efficient data storage and retrieval. I can dynamically generate HTML content for the report based on the data retrieved from the database and organize the data in tables as per the provided image layout.I can understand you vision and will give a firm consideration to continued collaboration and communication to bring your vision to life. I am committed to offer assistance post completion to the best of my ability. Looking forward to have an elaborated discussion regarding project. Regards, Vaishnavi.

$160 USD på 4 dage

5,0

(105 anmeldelser)

6,3

@DevBench

Hello. I am an experienced PHP/MySQL developer having more than 8 years of experience in web development. I am confident that I can help you create the interactive historical results report you need. To clarify the requirements, I kindly request the following information: 1. Will the report be generated based on user-selected parameters from a form on the web page? 2. Do you have specific design requirements for the report interface? 3. Are there any specific features or functionalities you would like to include in the report? 4. Do you have a preferred method for handling user interactions, such as JavaScript libraries or frameworks? Price and timeline fields are placeholders and will be discussed after clarification of the scope. Let's have a quick chat session so we can discuss the project thoroughly. I look forward to connecting with you on this project.

$160 USD på 2 dage

5,0

(22 anmeldelser)

6,1

@mamunstudios

Hello there, Having gone through your project description, and having the requisite skill set comprising PHP, MySQL, HTML and JavaScript, I enthusiastically put forth my candidacy for your Interactive PHP/MySQL Report Generation project. What sets me apart is the manner in which I fuse these skills to create dynamic, user-friendly web interfaces that cater to your specific needs. Moreover, my extensive experience with HTML ensures that your report would not only be organized efficiently like you require but also aesthetically pleasing. To embellish this feature even further, I'm well-versed in JavaScript and jQuery, enabling me to develop interactive elements such as the ability to hide/display prior years' data when clicked. Additionally, given that a robust database is crucial for efficient operation of a project like this, my expertise in MySQL can come in handy. I've built databases that not only perform flawlessly but also have a more flexible structure to accommodate future updates to data fields - think of it as a design future-proofed against evolving requirements. Trusting me with your Interactive Report Generation project would effectively result in prompt delivery overshadowed by none and a finished product of incomparable standard. Let's transform your vision into reality together! Thank you

$200 USD på 3 dage

5,0

(99 anmeldelser)

6,2

@testotorko

Hey. I am an experienced Web Developer and have worked with wide variety of skills like PHP, MySQl, jQuery / Prototype, Javascript, HTML, CSS and more for many years. Can start right now.

$65 USD på 14 dage

5,0

(141 anmeldelser)

5,9

@DGM999

Hello Eriks G., I am Sadat Saeed, with 8 years of expertise in PHP, JavaScript, MySQL, and HTML. I have carefully reviewed your project requirements for creating an interactive historical results report with user-selectable parameters. I have a proven track record of successfully delivering similar projects and ensuring user-friendly interfaces. Please review my portfolio at https://www.freelancer.ca/u/DGM999 and let's discuss further. Best regards, Sadat Saeed

$85 USD på 3 dage

4,8

(40 anmeldelser)

5,8

@ahsan423

Greetings, I hope you are doing well. With over 10 years of experience in PHP, MySQL, and JavaScript, I am well-equipped to handle your project requirements. I have a proven track record of creating dynamic and user-friendly web interfaces, as well as building flexible databases to accommodate evolving data needs. My expertise in HTML ensures that the generated reports will be both visually appealing and functional. I look forward to discussing further details and working on this project with you. Best Regards, Ahsan

$140 USD på 7 dage

5,0

(12 anmeldelser)

5,6

@Developerdeepika

Hello sir, I have read about your project in detail and I would love to work on your project. we are a team of 40+ experienced developers with a deep knowledge of HTML,JAVASCRIPT,WEBSITE DESIGN,GRAPHIC DESIGN,WEB DEVELOPMENT ,MySQL, CSS, WORDPRESS,LARAVEL,PHP ETC. kindly message me for further discussion and we assure you to serve our best to you. Thanks & Regards Developer Deepika

$30 USD på 7 dage

4,5

(93 anmeldelser)

6,3

@akhilvl1302

"Hi, I am an expert in PHP and Mysql. Can create interactive table design and features based on your requirement Skills: NodeJs, Python, PHP Please message me for further discussion. Thanks!"

$140 USD på 7 dage

4,9

(83 anmeldelser)

5,7

@VakiYT

Hello, my name is Vladimir and i am Web Developer from Serbia. I can finish your project, contact me and we will talk more about project.

$100 USD på 2 dage

5,0

(44 anmeldelser)

5,6

@subinpvasu

Hi, I'm interested in your requirements. I have rich experience in web development using HTML, PHP and MySQL. Let's have a chat for more details. Thanks!

$170 USD på 3 dage

5,0

(33 anmeldelser)

5,5

@louislafata

Dear, I am an experienced PHP/MySQL developer and I'd love to have the opportunity to work on your project. I've taken a look at your project carefully and I'm confident in my ability to deliver outstanding results for your project. I'm available to start work immediately and I can complete that within your timeline. Please don't hesitate to reach out if you have any questions or would like to discuss the project more. Regards, Louis

$155,56 USD på 3 dage