In Progress

Hotel property list correction

Hi,

I am having trouble calculating the total price for each room type per hotel.

What happens is since it lists 2 seasons for the booking dates on the database, the total appears twice. Instead of giving the total price per each room type on each hotel.

This is what is happening:

ROOM:Junior Suite Date: 2008-05-30 PRICE: 40 MARKUP: 30%

ROOM:Junior Suite Date: 2008-05-31 PRICE: 40 MARKUP: 30%

Total: 80ROOM:Junior Suite Date: 2008-06-01 PRICE: 55 MARKUP: 30%

ROOM:Junior Suite Date: 2008-06-02 PRICE: 55 MARKUP: 30%

Total: 190

ROOM:Suite Date: 2008-05-30 PRICE: 55 MARKUP: 30%

ROOM:Suite Date: 2008-05-31 PRICE: 55 MARKUP: 30%

Total: 110ROOM:Suite Date: 2008-06-01 PRICE: 70 MARKUP: 30%

ROOM:Suite Date: 2008-06-02 PRICE: 70 MARKUP: 30%

Total: 250

NOTE: I have the total price for each room type at the end of each room type marked if you take a look you'll see twice the total for the room: suite and room: junior suite.

The final result should be this:

ROOM:Junior Suite Date: 2008-05-30 PRICE: 40 MARKUP: 30%

ROOM:Junior Suite Date: 2008-05-31 PRICE: 40 MARKUP: 30%

ROOM:Junior Suite Date: 2008-06-01 PRICE: 55 MARKUP: 30%

ROOM:Junior Suite Date: 2008-06-02 PRICE: 55 MARKUP: 30%

Total: 190

ROOM:Suite Date: 2008-05-30 PRICE: 55 MARKUP: 30%

ROOM:Suite Date: 2008-05-31 PRICE: 55 MARKUP: 30%

ROOM:Suite Date: 2008-06-01 PRICE: 70 MARKUP: 30%

ROOM:Suite Date: 2008-06-02 PRICE: 70 MARKUP: 30%

Total: 250

Also please use the code attached on the php file , don’t adapt tables or div tags on the code.

Skills: PHP

See more: price list, junior\, hotel room, correction, correction code, calculating, property code, hotel price database, list code, hotel room booking php, code correction, database hotel room booking, code hotel, Hotel List, hotel php, hotel price, booking php database, database booking, hotel code list, database booking hotel, correction php file, php 2008, price tags, per file attached, end dates

About the Employer:
( 6 reviews ) portimao, Spain

Project ID: #216908

Awarded to:

TechArts

Arthur is there :))

$30 USD in 0 days
(19 Reviews)
6.2

2 freelancers are bidding on average $30 for this job

Zuprem

So the total is shown twice instead of once? Fixing that is not a problem.

$30 USD in 0 days
(53 Reviews)
5.5