Closed

THAILAND ONLY: jomres / php / sql coding only

Job must be made in thailand

Job is to make a Booking engine for hotels on website [url removed, login to view]

this file was made for a friend and updated several times so i’m sorry if it looks incomplete or sometimes stupid or funny...

THIS IS MOST OF THE WORK, THERE WILL BE SOME MORE MINOR MODIFICATIONS AND ADDUPS WHILE SOME OF THE THINGS DESCRIBED BELOW MIGHT ALREADY BE FEATURED IN JOMRES.

I NEED TO SPEND TIME WITH DEVELOPER TO EXPLORE THE SYSTEM TO REALLY KNOW WHAT IS TO DO IN DETAIL

BUDGET IS 20.000 BAHT FOR THE WHOLE THING (there will be an additional bonus UP TO 5000 baht if all goes smoothly and developer goes the extra mile. bonus to be given 3 months after completion of project)

I PAY PER SECTION, 1/4 AT START, 1/4 AT MIDDLE, 1/4 AT END, 1/4 45 DAYS AFTER FINISH EACH SECTION

I PURCHASE EXTENSION JOMRES AND MAXIMUM SUPPORT FROM JOMRES DEVELOPER (ANSWERS IN LESS THAN 24 HOURS) AND I DO NOT MIND PURCHASING AN EXTENSION THAT WOULD FACILITATE SECTION B/C/D (budget 150$)

BUSINESS TARGET:

BE ABLE TO SELL ROOMS ONLINE WITH COMM TO PAY BY CUSTOMER OR BY HOTEL WITH SIMPLE BE VERY FLEXIBLE ROOM/PACKAGES/SEASON/EXTRAS

BE ABLE TO GENERATE AND RE-DISTRIBUTE CUSTOMER AND HOTEL FEEDBACK (POLLS, COMMENTS, NEWS, PROMOTIONS...) ON THIS SITE OR ON OTHER JOOMLA SITES

HAVE A POWERFUL YET FLEXIBLE APPLICATION THAT ALLOWS ME TO KEEP ON DEVELOPPING IT LATER

APPROXIMATION OF TASKS AND BUDGET PER SECTION (A/B-C/D-F-G-J/E-H-I/bonus)

A/ 7000b modify core to suite booking requirements

(rooms, supplements, availability, reporting system, user types, multi-property account (i think already there), affiliate agents, installation and integration of relevant plugins ...

updatable xml files for locations...)

B/ 1000b installation and integration and modification of an event calendar (jomres support told me he's got a script ready for that) very much related to C/

C/ 4000b Insert the news distribution and feedback engine

(polls, feedbacks, descriptions, events, remote db access(to post on my other sites),

rss builders/burner, things that u know are easy to setup/use and effective...)

D/ 2000b install the link exchanger allow/disallow externat links / join used locations and categories... in order to make a special partner program linked to specific hotel payement/commission settings

E/ 1000b inhence security features (incl ssl/db protection/disallow right click/captchas/ automatic backups other things tht u know and i dont...)

F/ 500b override random modules

G/ 1000b Install a SEF that can read the hotel names/city/country and put them up in the url

H/ 1000b Additional little things or brilliant details that will come up

I/ 1000b setup of basic online chat / talk funcions with customiz hotel or site pickup

(ideas that i dont know ^_^ (flash gallery, flash menu... ) page setups... not sure yet

J/ 1500b Overall accessibility, joomla integration, critical support or freindly help later when i use the thing

K/ + up to 5000 bonus

JOB IS NOT FOR DESIGN / CONTENT / PROMOTION / HOSTING but get the whole 5000 bonus would mean that dev has also helped with design and advise

I SHOULD BE VERY INVOLVED IN TESTING AND FEEDBACK FOR DEVELOPER TO SAVE AS MUCH TIME AS POSSIBLE AND MAKE THE JOB WORTH IT.

DEV CAN COME TO RAYONG OR I CAN COME TO BKK / SOMETIMES OR WEEKLY OR FOR THE WHOLE PROJECT / I CAN SUPPLY FOOD AND ACCOMMODATION ON HAD MAE RAMPEUNG BEACH.

MOST FUNCTIONS NEEDED ARE ALREADY IN THE EXTENSION, SOME I DIDNT SEE YET BECAUSE THIS SYSTEM IS NEW FOR ME, SOME NEED TO BE MODIFIED, SOME CREATED.

I’M FLEXIBLE ON SOME POINTS AND ACCEPT TO COMPROMISE IN SOME CASES

A/

ROOM TYPES:

there is need of one more level of rooms or make global room types become individual per property

Hotels enter their own room types

sub room types = packages

only shb admin can list all room types

NOW IT’S DISPLAYING ROOM TYPES INSIDE ROOM CATEGORIES DOUBLE/TWIN/TRIPLE (THAT IS TO SAY ROOM BED ARRANGEMENT, NOT ROOM TYPE, I THINK THERE IS NEED OF ONE MORE LEVEL)

AND THEN ROOM TYPES

NOW SUB ROOM TYPES ARE NOT THERE

I ALSO SEE THAT SOME OPTIONS FOR ROOMS SUCH AS RECURRING PERIODS, PRICE PER ROOM OR PER PERSON, OF STAY ARE GLOBAL?

Exemple of room type table and sub room:

Global

Room type Hotel Room type Room description

DB Superior Queen Accommodation in a Double Room with Breakfast

DB Deluxe King Accommodation in a Deluxe Room with King size bed and inclusinve of Breakfast, free newspaper

DT Deluxe Twin Accommodation in a Deluxe Twin Bed Room with Breakfast, free newspaper

SU Junior Suite Accommodation in a Junior Suite with ... Sauna in Room...

DT Garden View Romantic Mezzanine Room overlooking the garder....

Global room type Package name Room (package) description

DT Honeymoon package (sub room type of Garden View) Honeymoon package: Accommodation in Garden View with Room Service, music played on balcony every night... (can have minimum stay or exact stay while GView doesn’t, but when HM package is booked, Garden View must drop of 1 and vice versa, but if HP pack is shut down, GView is still on)

(Honeymoon package is a sub room type of Garden View unless each hotel can rename DB DT...) in our exemple Honeymoon package must have minimum stay 5 days, minimum and maximum number of adult per room is 2, 50% for childrenhotel can also propose the limosine pickup option from their supplements and things...

black day (closed rooms) can be separated for each room / subroom type?

price per person or per room can select for each room type (but that's not main requirement, if only for all room types it's ok, and if cannot choose, then per room)

(room includes... or compulsory free supplements? or room attributes? (such as breakfast included/ cover bed / free shuttle...)

I’d like to discuss with you how room system is working now and hw recycle at best

there could be for each room a small free text window so owner can add small 150 descripion (for rooms) or package inclusion (for sub rooms)

Now that i see advanced mode, i understand a little bit better how rooms are made... i still can’t find sub rooms... well anyway, it’s not the right way to use them as package the way i was thinking... got to talk with u for that then

CONFIGURATION MENU

I had seen that menu, but i thought it was in admin... so it’s a problem because most of the options here must be global and hotels cannot see... it’s true that some i didnt’ see (like weekends)

* AVAILABILITY CAL. – use global

* BOOKING ROOMS use global for all except all smoking options and weekends (but i dotn like the way they make weekends... but still can use

* BOOKING ROOMS2 use global for all (not sure for room image / elapse time between departure and arrival (shouldn’t that be zero by default? And not 1?) (don’t understand wht is days before arrival and gust type default)

* EDIT LANGUAGE not sure

* ENCRYPTION not sure

* GALLERY LINK user, but function can be disabled by admin for individual hotels, default is disable for all

* GATEWAYS global

* JS CALENDAR global

* MISC. (def country: location of user’s computer / the rest is global)

* REQUIRED global

* SLIDESHOWS global (but the choice of slideshow style from admin could be choice to user... but it’s probably a problem...)

* SRPS (all global (tariff charge at weekly figure & booking for fixed period + details = user )

* SUPPLEMENTS user

* TARIFFS & CURRENCY all global (per person / per room is = user)

* WISE PRICE user

remark 1: auto addup lines when adding data (seasons, room features...) without reloading page

Is it possible to have all properties set like that but some can still use the full control mode? Just asking. If that is much work then forget it

FEATURES:

So far I see features, i’m not sure if their for hotel or for rooms, i guess hotel and rooms feature come in description. Im’ not sure with features what is global and what is not, but it’d be nice to have global features and then free text ones (remark 1)

**ex developer reported a bug with “you will probably want to get some support from the jomres guy as it looks like you have not installed the component completely as there are some features that are not working correctly. Notably the room features code”

RATES:

customer is adults or children (usually are discounts or free for children for room, also important for some supplements) (children = % discount for each price category (1 for all rooms, 1 for each supplement)

DAYS:

It’s not exactly how I wanted, but weekends are there, let’s keep it as is for now

but really i dont like the way it’s presented, I prefer to have 7 boxes to click (in some specific cases, hotels can have 2 rates in a week and it’s not a weekend), but it’s not a requirement

click box in the header of the room type table: your hotel has different prices during weekdays and weekend?

yes opends popup: click your weekends

disabled by default

when disabled, enter second price is not compulsory (or auto-fills with first price)

auto renew, option to owner by cliking off and on again

SEASON

season is provisory standard price change, maybe maximum 6 is enough... not sure...

can that be on a form with “add 1 more season” that opens another small box without reloading the page (remark 1)

click season in calendar and key in we and wd prices

now the best software i saw (1500$) was having people filling up the whole year with concurring date boxes for 365 days (spread in an number of lines decided by hotel)... there's got to be a reason to that... is there a difficulty just having a main price and periods where that price changes?... why did they have to cut up the year in slices?)

season settings are automatically renewed with option with disable renew (see compatibility with C/ yearly message to owner for renew settings)

SUPPLEMENTS (EXTRAS):

important (really will make the difference with other booking engines):chargeable supplements should have options:

some supplements client can choose, some are compulsory (allows 1st night charge or other wierd typical thing)

they can be free or charged per day, week, month, year / per stay per fixed day (compulsory gala dinner (frequently used = compulsory supplement/per adult/31/12/* + compulsory supplement/per child/31/12/* (and not per person, avoids to have to have put another option for discount for children in supplements, if same price for children, so it is per person)

per person / per room ,

HOTEL MUST CHOOSE: compulsory or option AND free or charge (+price). IF CHARGE: per (day or week or month or year or per stay or per fixed day) AND per person or adult or child or room IF CHILDREN: discount for children? (+ specific % discount)

allows to charge airport pickups or to make recurrent charges from supplement without having to create new packages / sell packages with options (maybe)

if well thought, it really duplicates the capabilities of the engines by itself. tricky part with children discount

REGISTER NEW HOTEL PROCESS: so much more infor for rates and tings... maybe that will crowd the registration pages... maybe need to touch up process

1 big page or step by step, up to you... but for sure there are several big sections

(if step/b/step, each step has if possible option "return,skip this step for now (reminded later by email)" :

got different price for weekend?room types (packages should be in option at reg), numberrooms available per type, stadard price (wd-we?), smoking-nosmoking-display-that-u-got-smoking-no-smoking-rooms?(changes property display for customer only)

/ seasons

/ supplements

/ attributes

/ (last, after register) participate to cross link program,commission paid by hotel programme(this just sends me a mail), whatever marketing support maybe...

/ upload pictures, upload logo, descriptions (no editor plugin here i think)

/ review-correct profile ;

publish property needs approval)

Icons: if i remember well, when hotel makes a room type, hes got to choose a room icon. that's fine. is it possible that when he's choosing sub room type he can choose in another set of icon? (not important... there could also be no icon at all... ) now icon brings overlib.... so there must be a default information icon

IN HOUSE CUSTOMER TOOLBAR: i'm not sure that whole area of the soft is necessary... some reporting there, but dont need the check in check out...

ERROR MESSAGING: need to have small error messages on all impossibility: cannot have max user is zero / cannot rent room for zero guests / cannot book room for children alone... whatever impossible thing... if not i'm sure some big bintz may happen one day)

LANGUAGES: I read in a manual that languages are tricky to install ... still this is something I should do but how should we work? coz u're working on ur server right? I can't really work on my side apart from other joomla things, testing, learning to use and css...

we should how difficult... but max i need eng-fra-spa-ger, minimum fra-eng (thai? thai’d be great:)

I know somebody who can help with traductions in ger and span

PROPERTY PRESENTATION:

main description of hotels should come on searche results and all listing pages (now it's only pics and links to profile).

The concept they have from presenting the properties is not adequate (rooms on the right with overlib) it's that way because it's oriented to sell chalets, cottages, apartments... and manage that online

so they show the room information in overlibs because people want to compare room types in a certain geographical area (that's probably just a setting in a module...)

i need to show rooms only when property is displayed individually, but i need to show the rooms in content pane with all info next to it in a table with a booking button, rather than overlib*... room types/prices is info at a glance

one page with all room info, packages, supplements

one page with all desctiptions

one page with availability chart (without number of room available on cuustomer hand)

One page with terms and conditions shb, no-show/cancellation policies of hotel

... or some grouped together... what do you think?

*overlib: if you tell me how, i'll reconvert overlib into and advanced mouseover support for all imporant functions

Display of availability: too many visual availability options at front end... front end should only have available/full

frontend admin can see them all, why not, but must have at least available/some bookings/full (is it easy to have 2 different displays?)

can there be option for hotels to upload an area map on the profile (or as popup link) for those who dont yet have googlemap, or even if they have googlemap?

should owners be able to book rooms to their own property?

MODE BOOKING ONLY (no menu, only hotel profile and booking)4/5

when somebody comes from from certain clicks (from embedded booking forms in other websites), page opens without any navigation, only the hotel profile and booking functions... is that something to do with "wrapper" thing?

HOTEL AVAILABILITY

at front admin, hotels can update their availability.

it's good that rooms are available from configuration time coz certain websites keep on bugging you coz u should reconfigure ur rooms each year... if u didnt get bookings from them, u just go and delete your profile

There's got to be a reason for that legally... at hotel registration there should be a small box with a click already on that says "make my rooms available from now and renew automatically each year"

each year they got to receive a mail 1 month before expire of the year, mail informs them that "do not reply to this mail, your rooms in shb will be renewed next month for the duration of a year. if you wish not to review your room availability, please visit your account

BOOKING PROCESS:

I looks already pretty straight up like that... only thing is how to present all the new features

there must be a print of all hotel info together with the bill (** must be mentionned on each profile so people dont panic when they can't right click to save the map for exemple)

TERMINAISON OF CONTRACTS:

customer or hotels that terminate the account get a questionnaire by mail

customers or hotels that get suspended or terminated get a mail

LOCATION XML:

can that be auto updated?

DIRECTORY APPROACH:

can there be a small directory approach that builds as the hotels list up (as opposed to having a full directory of empty locations...)?

i can publish it in the future

REGIONAL DETECTION:

is it possible to detect from where the user connects and to open a page with his nearest availabilities in default language for the country (if he's in mexico and that there's no hotel there, the page will open the full content of the nearest parent directory... and in spanish

GOOGLEMAP:

I guess it's not possible to have it auto-registering properties in google... is it very difficult to have it pinned-on by owner? I'd put 15$ if there's a stable extension for that...

REPORTING:

so far i've not been impressed with what i saw on jomres, bt there's got to be much i didnt see about reporting, maybe in the plugins...

for sure hotels must have access to their past and future bookings and revenue

I dont need something that looks good,

Just an idea: what about something with complete and flexible filters...

and possibility to print or mail reports of booking per property ... no, that's not necessary i think...

filters (dont know, just listing): number of property / locations / customers / hotels / bookings / hotel income / shb income / property type / cutomer type / by date booked/ per month / per year / by arrival date /

if not second idea: simplified reporting, several standard report form with filter (many can be grouped: customer report?/ bookings report per hotel or global/ hotels report (all hotel with status, number of rooms in system, number of rooms sold/ regional report? / boookings to come / bookings past / check-in with x days / debitor hotels and payements per period)

ACCOUNTS

In each hotel account that is on mode money collection i must be able to write in when they make payements (if affiliate, then when I make payements)

they'll be very few... just keeping a small report of "written off money per hotel" with dates somewhere will suffice...

(remark the customer management module i dont need could be used to manage that?)

AGENT ACCOUNTS

it’s probably somewhere in the plugins

SITEMAP GENERATOR

B/

EVENT CALENDAR:

The guy from jomres said he had something on the side for that and if i remember well its got rss functions in it

C/

RSS AND MAILING: there's so much to do... tell me if there's need to buy an extention for that (budget < 150$)

mails to customers:

newsletter (not really important from this website... rather reminders to hotels adjust your property availability before newy year, your availability has been prolongued one year...)

/ mail at booking time (confirmation of booking with maps and access)

/ 48 hours before booking get resa details again as well as attachement with map and access info again, plus link to hotel profile.

/ 24 hours after check out receive guest comment form

constitution of guest comment form: nts theme of ranking are keys

1: automated message advertisement signature

2: standard guest comment review for the site with standard rating 1 to 5 (cleanliness, friendliness, comfort, value for money, area)

3: confidential (not on website) guest comment form to hotel owner

(food quality (breakfast, lunch, dinner, theme restaurants, in room F&B), (Remark: actually all the hotel's attributes can just be dropped in there automatically and be rated... but that'd be too much for customer) broken things in room, advise on what customer expects, gets..good, bad surprises (can push teh vice to rss that one... that could become fun)

+ guestbook section that owner can publish or not

4: guest comment to webmaster (free text, no rss)

** monthly mail to hotel asking them to send all their information in a custom form (most important rss with hotel description)

this form comes in several text boxes, 1 per even or promotion, with option for a picture in attachement for each event. each text box comes with click box main theme option F&B event/ Lodging promotion / general news / special or package - and rss return considers user profile geography(continent/country/city/district), language code, hotel category... (actually it's already doing that for each RSSed content right?)

that's got to go directly in the db, pre-formatted with pic randomly left or right.

themes: genereal hotel data / news and info / regional (city country continent as per db) / francophone, spanish, english (default), german / f&B event, gastronomy, banquetting / rooms division / special - funny / 1 to 3 stars , 3 to 5 stars / beach, city, mountain, country, business, golf, ski, historic monument, theme hotel, sports/adventure/green, budget/guesthouse/hostel,

everything must wait my approval before being released on news network

rss are automatic with orerride

yearly message to hotel (after 11 months registration: we've prolongued (in advance) your profile's settings for next year: your weekends are... your room rates types and rates are... yuor locaction description, phone number, email... we can't give your password but you can login automatically if you click here if all ok, clck yes (or whatever) if not please reply to this email

MAILING SYSTEM:

All mails require certification of reception

all mails with links to account settings bear user and pssword so that they dont have to login (that's very important if not too hard to do or too unsafe... but there's no much risk in accessing an account like htat right

You'll tell me what email address i got to create

rss themes: i need to be able to assign any (or most or some) content item to rss feeds that i create per theme... i'm not sure exactly about that... just something easy for you to install and easy for me to use ... and powerful :P ... i know shit about taht area, i dodtn know the best way to recycle all that content

Event calendar shoudl be recycalble as well..

D/

Partnership

... what do you tink about that...? if i want some kind of different levels of partnership some of which require link back from main url..., some from any page... maybe with custom commission rate,... still paid by customer or hotel...

I'm not sure yet what, but something like that can become handy on the web-designer aspect of the project... that's one of the last thing to do though... but good to know from start...

whatever that is, it's got to be simple.... that's not that important

***the link mgr already uses joomSEF patched through plugin

E/

Security: all that you know... i know nothing about that... as you know

ssl/[url removed, login to view] coders/captcha things/no right click... all there need to be...

F/

Override possibility for all ranking modules and polls

G/

Need a SEF module of your choice that gives continent/country/city/(district?)/hotel_name/

the standard 2 titles of the content...

H/

Nothing so far... these ones are already in the core modification i think...

I got to do all the design myself

note to self: flash header with top menu switching from booking engine to main website (what theme is main website? secure and hotel and booking) with all main functions

I/ not yet sure about that one

J/ not yet sure about that one

this file is not complete but it’s more or less it

TESTING:

I'm going to book a room for roots through different engines and see all they do, and print screen of how they present it and copy their licence agreements

I mean i can do it,but maybe you want to do it as well to get the feels of how they make it...

I'll go and try ghix with my friends hotel in switzerland... i also have backend access to their hotel, they said it's ok if i look

I already registered my guesthouse in many of these things. If you want to go and try register a fake guesthouse to see how they chose to do structure it, I recommend you try hostelbookers

NOTES TO SELF

I will try to work on a wide format for container... something like 980px.. sorry for who still on 800x600

will go for windows vista feel template but sober...

main theme:safety booking

MAIN KEYWORDING:

Online Booking Engine, register property, hotel, reservation, book, booking, (all destinations), hotel profile

secure

#### ERRORS

1/ (cookie problem?)Ie only, on both my computers / hotelbam / Create property, choose country (congo), page reloads to get cities but get blank page. browser back button and try again then works (happens often) [url removed, login to view];task=registerProp_step1&Itemid=26&selectedCountry=CG

City comes, i choose and submit, blank page again: [url removed, login to view];task=registerProp_step2

back and forth 3 times then page comes

fill up page, submit and blank pages comes again

press back button / page is expired... but when i back again, hotel is created

That used to happen to me on the link exchanger website... the guy was telling me that his website was ok, like if it was only with me... but it was keeping giving me blank pages while information was still submitted

I hope it's not the same problem...

used to have the problem on ie and ff with that other website

2/ website is set in euro / euro symbol at back end config but shows prices in pound at front end

*************************************************************************

Skills: Javascript, Joomla, Legal, PHP, Script Install

See more: change minimum number price child jomres, check sql jomres, jomres overlib pic booking, jomres nearest property plugin, blank page jomres, sql departure arrival airports, jomres show, jomres bed breakfast, sql design give number days property empty month, jomres developer, zero soft, you ve got an idea for a business need money, your wish come true, yearly review, x rates, xml task editor, xml generator online, xml compare online, xml code generator, written signature ideas, written logo designer, write your own book online free, write your name on the beach, write your name in thai, write xml code website

About the Employer:
( 0 reviews ) Paris, Thailand

Project ID: #212873