Codeigniter Report from MySQL

Completed Posted Jan 3, 2013 Paid on delivery
Completed 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

Codeigniter HTML MySQL PHP

Project ID: #4092986

About the project

27 proposals Remote project Active Jan 8, 2013

Awarded to:

udanaudayanga

Please check private message.

$100 AUD in 2 days
(47 Reviews)
5.7

27 freelancers are bidding on average $210 for this job

denisCh

Please check PM

$180 AUD in 3 days
(62 Reviews)
7.5
shibin123sl

Experts here, Please check PMB.

$500 AUD in 10 days
(99 Reviews)
7.2
webedeveloper

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

$350 AUD in 9 days
(87 Reviews)
6.8
khanhhuyna

I can do this. Thanks.

$250 AUD in 5 days
(90 Reviews)
6.5
trustus

Please check PM.

$90 AUD in 5 days
(37 Reviews)
6.2
yopesh

Hi, I sent a PM.

$250 AUD in 5 days
(46 Reviews)
5.9
gisterpages

Hi, I have posted few questions along with my qualification and work samples in private message. Kindly check and reply. Thanks Abilash

$200 AUD in 6 days
(49 Reviews)
5.8
cse031sust02

Hi, I can do it. Thanks

$180 AUD in 7 days
(64 Reviews)
5.7
csajit

LETS GET IT DONE!!!

$250 AUD in 5 days
(120 Reviews)
5.5
phpplay

Please see inbox message. Thanks

$165 AUD in 7 days
(17 Reviews)
5.5
bhavinhjoshi

Hello, I have provided the details in private message. Please check PM. Regards.

$250 AUD in 4 days
(31 Reviews)
5.7
thesad

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.

$250 AUD in 5 days
(29 Reviews)
5.4
sanjoy2prosenjit

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

$210 AUD in 7 days
(12 Reviews)
5.1
phanhuutri

Hello, I'm very interested your project. Please check your inbox for more details, thanks!

$250 AUD in 4 days
(41 Reviews)
5.1
abanipatra

Please check PM for more details.

$200 AUD in 15 days
(48 Reviews)
4.9
fldw

Hello, I would be glad to work on your CodeIgniter/jQuery/MySQL based project. More details in PM. Thanks.

$250 AUD in 5 days
(8 Reviews)
4.5
alrazon

Read your details and interested to work, thanks.

$250 AUD in 15 days
(28 Reviews)
4.3
shaoncse06

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

$250 AUD in 10 days
(8 Reviews)
4.0
rjsultan

I will provide you these reports with multiple dropdown selections specific to days you want.

$50 AUD in 3 days
(10 Reviews)
3.8
BitBull

Professional with Codeigniter and Grocery CRUD experience interested in your project.

$200 AUD in 10 days
(3 Reviews)
2.1