Codeigniter Report from MySQL
$30-250 AUD
Paid on delivery
Overview -
I have an existing website built on the WAMP platform & using the Codeigniter framework (with Grocery_CRUD), that allows customers to make bookings for couriers to pickup goods and then allows the couriers to enter their daily run details.
Summary -
I require a single report - Courier Run Report - to be developed that:
1) Is accessed via a web browser and will be located with the
existing reports on the 'Reports' drop down menu of the main page
of the existing website.
2) Asks a user to select a date range (1 day, 1 week, 1 month, etc) and the
date range selection boxes should be similar to the one used in the
existing report.
3) Queries the existing database (cb) and returns only the results for
the date rage selected.
4) Queries the following three tables in the existing cb database:
a)courier_run
b)courier_pickup
c)courier_run_code
Note: The information returned comes from all three tables so a JOIN or
multiple JOINs may be required
5) Displays the following columns in the report, from the following fields:
[url removed, login to view]
courier_run.total_time
courier_run.total_kms
[url removed, login to view]
[url removed, login to view]
[url removed, login to view]
courier_pickup.number_of_bags
6) Changes the display name of the columns to be more 'user friendly':
Date
Total Time
Total KMs
Run Code
Courier Run ID
Samples
Number of Bags
7) Returns/Displays the results in a similar time to the following SQL query
that returns the information required:
SELECT [url removed, login to view],courier_run.total_time,courier_run.total_kms,
[url removed, login to view],[url removed, login to view],[url removed, login to view],
courier_pickup.number_of_bags
FROM courier_run
JOIN Courier_run_code ON [url removed, login to view] = [url removed, login to view]
JOIN courier_pickup ON courier_pickup.courier_run = [url removed, login to view]
WHERE [url removed, login to view] BETWEEN '2012-12-01' AND '2012-12-31'
AND total_kms > 0
ORDER BY [url removed, login to view], [url removed, login to view]
8) Displays the results in user selectabled groups of either 10,25,50,75,100 as
per the existing report. I understand that this is standard
css/js/jquery fuctionality that is provided by Codeigniter or Grocery_CRUD
9) Is written/developed in a similar way to the exisitng report and the rest of
the website. The website has been developed using Codeignitor and
Grocery_CRUD so this is what I expect would be used for the new report.
10) Code should include comments in English where practical and not be encrypted.
System Details -
WAMP Server 2.2
Apache [url removed, login to view]
MySQL [url removed, login to view]
PHP v5.3.9
Codeigniter v2.1.0
Grocery_CRUD v1.1.7
Windows Server 2008R2 64bit
Project ID: #4092986
About the project
Awarded to:
27 freelancers are bidding on average $210 for this job
Experienced and serious team specializing in open sources like wordpress, joomla, Open Cart, PHP Frameworks like Yii, Zend, CakePHP, CodeIgniter, Seagull, Symfony and more with latest web trends and standards. Our tea More
Hi, I have posted few questions along with my qualification and work samples in private message. Kindly check and reply. Thanks Abilash
Hi, I am a php developer and working with php, mysql, ajax, javascript and using codeigniter framework. Please check your message box for details. thank you.
Hi, This is Sanjoy from techno web solutions. We have gone through with your requirements and we would like to state that we would be able to develop your project according to your exact specification immediately. Pl More
Hello, I'm very interested your project. Please check your inbox for more details, thanks!
Hello, I would be glad to work on your CodeIgniter/jQuery/MySQL based project. More details in PM. Thanks.
Hi, How are you doing? I believe I can handle all of your tasks with my experience hand. Please check your PMB and let me know if you have any queries. Thanks, Amran
I will provide you these reports with multiple dropdown selections specific to days you want.