Giter VIP home page Giter VIP logo

homenet's Introduction

Credits

Konkurrenter

Turistcenter syd

http://www.turistcentersyd.se/ l�gger ut sina bost�der p� http://www.sverigesemester.com/.

http://sveaborg.cybercow.se/ad

Specification

  • Spara bilder p� flickr?

Kolla: http://www.sverigesemester.com/semester/stuga-stugor/boende-2145/vinter-sommar-0/erbjudande-0/0-index.html

accommodation_id name description livinig_space max_people description minimum_rental_period minimum_rental_period_type [dag|vecka|m�nad] change_day: {S�ndag} type [L�genhet|hus|hotell|vandrarhem] bussiness_type [for_sale|rental]

rooms bedrooms kitchens livingrooms bathrooms toilets other_rooms

beds singel_beds double_beds single_sofabeds double_sofabeds bunk_beds extra_beds cots

meters_to_beach meters_to_lake meters_to_sea meters_to_trainstation meters_to_airport meters_to_restaurant meters_to_fishing meters_to_skiing meters_to_golf

PROPERTIES cdplayer_available tv_available radio_available shower_available fireplace_available bath_available garden_furniure_available bicyble_available parking_available stove_available barbecue_available oven_available refrigerator_available freezer_available balcony_available terrace_available microwave_available coffe_machine_available boat_available motorbot_available dishwasher_available laundry_machine_available tumble_dryer_available pool_available sauna_available

ALLOWED smoking_allowed anmial_allowed

Kommentarer {discus?} Tillg�ngliga datum: och priser

DATABASE

accommodation

accommodation_id name description livinig_space max_people

price

price_id from_date to_date day_price currency

reservation

reservation_id accomodation_id customer_id checkin_date checkout_date

customer

customer_id name phone

�verlappade pris perioder? SELECT sum(((to_date - $to) - ($from - from_date))*day_price) as price FROM accommodation INNER JOIN price USING(accomodation_id) LEFT JOIN reservation ON (accommodation.accomodation_id = reservation.accommodation_id and checkin_date > $from and checkout_date < $to) WHERE price.from_date > $from AND price.to_date < $to AND reservation_id IS NULL GROUP BY accommodation_id

homenet's People

Contributors

arlukin avatar

Stargazers

 avatar

Watchers

 avatar  avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.