Integrate Map

[hesslau]

The map (see https://github.com/KilianZimmerer/nama_map) should be integrated as a view and should also use data from the same source. Some fields need to be migrated to rails:

CREATE` TABLE Shops (
    id int NOT NULL AUTO_INCREMENT,
    name varchar(255), // exists as "title" in table addresses
    street_name varchar(255), // exists as "address_line_1" in table addresses
    street_number varchar(255), // exists as "address_line_1" in table addresses
    latitute varchar(255),  // TODO: migrate to table addresses
    longitude varchar(255), // TODO: migrate to table addresses
    postal_code varchar(255), // exists in table addresses
    email varchar(255),  // exists in table users
    website_url varchar(255), // TODO: implement in table users
    phone_number varchar(255), // exists in table users

    // the phone availability is a bit complicated and should be refactored
    mo_do_phone_availability int, // TODO: migrate 
    mo_do_phone_availability_from varchar(255), // TODO: migrate
    mo_do_phone_availability_until varchar(255), // TODO: migrate
    fr_phone_availability int,
    fr_phone_availability_from varchar(255),
    fr_phone_availability_until varchar(255),

    shop_description TEXT,  // exists as "about" or "about_me" in table users
    merchandise_managment_system_description TEXT,  // TODO: implement
    categories varchar(255),  // exists

    // shipping info is stored on a per article basis
    shipping_pick_up int,
    shipping_bicycle_delivery int,
    shipping_postal int,
    shipping_misc varchar(255),
    PRIMARY KEY (id)
);

[hesslau]

Integrate map as shop main page