[
https://issues.apache.org/jira/browse/OFBIZ-1590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12562394#action_12562394
]
purewing edited comment on OFBIZ-1590 at 1/25/08 12:36 AM:
--------------------------------------------------------------------
thanks Valentina,
Now I created three entities and added new example data and extended
workeffort, but I not sure about my data model. In "nrOfSpaces" of
AccommodationSpot I added space for person. With my demo provide customer
select fixedasset,class and tables number (get accommSpotId into workeffort)
and input time for make reservation (restaurant).
Can you check it again about my data?
My data
--------------------------
<?xml version="1.0" encoding="UTF-8"?>
<entity-engine-xml>
<FixedAsset fixedAssetId="Restaurant" parentFixedAssetId=""
fixedAssetName="Restaurant" locatedAtFacilityId="Tableservice"/>
<FixedAsset fixedAssetId="Private Rooms" parentFixedAssetId="Restaurant"
fixedAssetName="Private Rooms" locatedAtFacilityId="Tableservice"/>
<FixedAsset fixedAssetId="Communal tables" parentFixedAssetId="Restaurant"
fixedAssetName="Communal tables" locatedAtFacilityId="Tableservice"/>
<FixedAsset fixedAssetId="Bar/Lounge" parentFixedAssetId="Restaurant"
fixedAssetName="Bar/Lounge" locatedAtFacilityId="Tableservice"/>
<AccommodationClass accommClassId="Tables" parAccommClassId=""
description="Tables"/>
<AccommodationClass accommClassId="VIPTables" parAccommClassId="Tables"
description="VIP table"/>
<AccommodationClass accommClassId="PartyTables" parAccommClassId="Tables"
description="Party Table"/>
<AccommodationClass accommClassId="Chairs" parAccommClassId=""
description="Chairs"/>
<AccommodationMap accommClassId="Tables" fixedAssetId="Restaurant"
nrOfSpaces="20" overbooked="0"/>
<AccommodationMap accommClassId="PartyTables" fixedAssetId="Private Rooms"
nrOfSpaces="3" overbooked="0"/>
<AccommodationMap accommClassId="VIPTables" fixedAssetId="Private Rooms"
nrOfSpaces="5" overbooked="0"/>
<AccommodationMap accommClassId="VIPTables" fixedAssetId="Communal tables"
nrOfSpaces="3" overbooked="0"/>
<AccommodationMap accommClassId="Tables" fixedAssetId="Communal tables"
nrOfSpaces="5" overbooked="0"/>
<AccommodationMap accommClassId="Chairs" fixedAssetId="Bar/Lounge"
nrOfSpaces="10" overbooked="0"/>
<AccommodationSpot accommSpotId="1" accommClassId="PartyTables"
fixedAssetId="Private Rooms" nrOfSpaces="30"
accomNumber="PrPy-1"/>
<AccommodationSpot accommSpotId="2" accommClassId="PartyTables"
fixedAssetId="Private Rooms" nrOfSpaces="30"
accomNumber="PrPy-2"/>
<AccommodationSpot accommSpotId="3" accommClassId="PartyTables"
fixedAssetId="Private Rooms" nrOfSpaces="30"
accomNumber="PrPy-3"/>
<AccommodationSpot accommSpotId="4" accommClassId="VIPTables"
fixedAssetId="Private Rooms" nrOfSpaces="2"
accomNumber="PrVIP-1"/>
<AccommodationSpot accommSpotId="5" accommClassId="VIPTables"
fixedAssetId="Private Rooms" nrOfSpaces="2"
accomNumber="PrVIP-2"/>
<AccommodationSpot accommSpotId="6" accommClassId="VIPTables"
fixedAssetId="Private Rooms" nrOfSpaces="2"
accomNumber="PrVIP-3"/>
<AccommodationSpot accommSpotId="7" accommClassId="VIPTables"
fixedAssetId="Private Rooms" nrOfSpaces="4"
accomNumber="PrVIP-4"/>
<AccommodationSpot accommSpotId="8" accommClassId="VIPTables"
fixedAssetId="Private Rooms" nrOfSpaces="4"
accomNumber="PrVIP-5"/>
<AccommodationSpot accommSpotId="9" accommClassId="Tables"
fixedAssetId="Communal tables" nrOfSpaces="4"
accomNumber="CmT-1"/>
<AccommodationSpot accommSpotId="10" accommClassId="Tables"
fixedAssetId="Communal tables" nrOfSpaces="4"
accomNumber="CmT-2"/>
<AccommodationSpot accommSpotId="11" accommClassId="Tables"
fixedAssetId="Communal tables" nrOfSpaces="6"
accomNumber="CmT-3"/>
<AccommodationSpot accommSpotId="12" accommClassId="Tables"
fixedAssetId="Communal tables" nrOfSpaces="6"
accomNumber="CmT-4"/>
<AccommodationSpot accommSpotId="13" accommClassId="Tables"
fixedAssetId="Communal tables" nrOfSpaces="6"
accomNumber="CmT-5"/>
<AccommodationSpot accommSpotId="14" accommClassId="VIPTables"
fixedAssetId="Communal tables" nrOfSpaces="10"
accomNumber="CmVIP-1"/>
<AccommodationSpot accommSpotId="15" accommClassId="VIPTables"
fixedAssetId="Communal tables" nrOfSpaces="10"
accomNumber="CmVIP-2"/>
<AccommodationSpot accommSpotId="16" accommClassId="VIPTables"
fixedAssetId="Communal tables" nrOfSpaces="10"
accomNumber="CmVIP-3"/>
<AccommodationSpot accommSpotId="17" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-1"/>
<AccommodationSpot accommSpotId="18" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-2"/>
<AccommodationSpot accommSpotId="19" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-3"/>
<AccommodationSpot accommSpotId="20" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-4"/>
<AccommodationSpot accommSpotId="21" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-5"/>
<AccommodationSpot accommSpotId="22" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-6"/>
<AccommodationSpot accommSpotId="23" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-7"/>
<AccommodationSpot accommSpotId="24" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-8"/>
<AccommodationSpot accommSpotId="25" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-9"/>
<AccommodationSpot accommSpotId="26" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-10"/>
</entity-engine-xml>
was (Author: purewing):
thanks Valentina,
Now I created three entities and added new example data and extended
workeffort, but I not sure about my data model. In "nrOfSpaces" of
AccommodationSpot I added space for person. With my demo provide customer
select fixedasset,class and tables number (get accommSpotId into workeffort)
and input time for make reservation (restaurant).
Can you check it again about my data? and if it work can I commit?
My data
--------------------------
<?xml version="1.0" encoding="UTF-8"?>
<entity-engine-xml>
<FixedAsset fixedAssetId="Restaurant" parentFixedAssetId=""
fixedAssetName="Restaurant" locatedAtFacilityId="Tableservice"/>
<FixedAsset fixedAssetId="Private Rooms" parentFixedAssetId="Restaurant"
fixedAssetName="Private Rooms" locatedAtFacilityId="Tableservice"/>
<FixedAsset fixedAssetId="Communal tables" parentFixedAssetId="Restaurant"
fixedAssetName="Communal tables" locatedAtFacilityId="Tableservice"/>
<FixedAsset fixedAssetId="Bar/Lounge" parentFixedAssetId="Restaurant"
fixedAssetName="Bar/Lounge" locatedAtFacilityId="Tableservice"/>
<AccommodationClass accommClassId="Tables" parAccommClassId=""
description="Tables"/>
<AccommodationClass accommClassId="VIPTables" parAccommClassId="Tables"
description="VIP table"/>
<AccommodationClass accommClassId="PartyTables" parAccommClassId="Tables"
description="Party Table"/>
<AccommodationClass accommClassId="Chairs" parAccommClassId=""
description="Chairs"/>
<AccommodationMap accommClassId="Tables" fixedAssetId="Restaurant"
nrOfSpaces="20" overbooked="0"/>
<AccommodationMap accommClassId="PartyTables" fixedAssetId="Private Rooms"
nrOfSpaces="3" overbooked="0"/>
<AccommodationMap accommClassId="VIPTables" fixedAssetId="Private Rooms"
nrOfSpaces="5" overbooked="0"/>
<AccommodationMap accommClassId="VIPTables" fixedAssetId="Communal tables"
nrOfSpaces="3" overbooked="0"/>
<AccommodationMap accommClassId="Tables" fixedAssetId="Communal tables"
nrOfSpaces="5" overbooked="0"/>
<AccommodationMap accommClassId="Chairs" fixedAssetId="Bar/Lounge"
nrOfSpaces="10" overbooked="0"/>
<AccommodationSpot accommSpotId="1" accommClassId="PartyTables"
fixedAssetId="Private Rooms" nrOfSpaces="30"
accomNumber="PrPy-1"/>
<AccommodationSpot accommSpotId="2" accommClassId="PartyTables"
fixedAssetId="Private Rooms" nrOfSpaces="30"
accomNumber="PrPy-2"/>
<AccommodationSpot accommSpotId="3" accommClassId="PartyTables"
fixedAssetId="Private Rooms" nrOfSpaces="30"
accomNumber="PrPy-3"/>
<AccommodationSpot accommSpotId="4" accommClassId="VIPTables"
fixedAssetId="Private Rooms" nrOfSpaces="2"
accomNumber="PrVIP-1"/>
<AccommodationSpot accommSpotId="5" accommClassId="VIPTables"
fixedAssetId="Private Rooms" nrOfSpaces="2"
accomNumber="PrVIP-2"/>
<AccommodationSpot accommSpotId="6" accommClassId="VIPTables"
fixedAssetId="Private Rooms" nrOfSpaces="2"
accomNumber="PrVIP-3"/>
<AccommodationSpot accommSpotId="7" accommClassId="VIPTables"
fixedAssetId="Private Rooms" nrOfSpaces="4"
accomNumber="PrVIP-4"/>
<AccommodationSpot accommSpotId="8" accommClassId="VIPTables"
fixedAssetId="Private Rooms" nrOfSpaces="4"
accomNumber="PrVIP-5"/>
<AccommodationSpot accommSpotId="9" accommClassId="Tables"
fixedAssetId="Communal tables" nrOfSpaces="4"
accomNumber="CmT-1"/>
<AccommodationSpot accommSpotId="10" accommClassId="Tables"
fixedAssetId="Communal tables" nrOfSpaces="4"
accomNumber="CmT-2"/>
<AccommodationSpot accommSpotId="11" accommClassId="Tables"
fixedAssetId="Communal tables" nrOfSpaces="6"
accomNumber="CmT-3"/>
<AccommodationSpot accommSpotId="12" accommClassId="Tables"
fixedAssetId="Communal tables" nrOfSpaces="6"
accomNumber="CmT-4"/>
<AccommodationSpot accommSpotId="13" accommClassId="Tables"
fixedAssetId="Communal tables" nrOfSpaces="6"
accomNumber="CmT-5"/>
<AccommodationSpot accommSpotId="14" accommClassId="VIPTables"
fixedAssetId="Communal tables" nrOfSpaces="10"
accomNumber="CmVIP-1"/>
<AccommodationSpot accommSpotId="15" accommClassId="VIPTables"
fixedAssetId="Communal tables" nrOfSpaces="10"
accomNumber="CmVIP-2"/>
<AccommodationSpot accommSpotId="16" accommClassId="VIPTables"
fixedAssetId="Communal tables" nrOfSpaces="10"
accomNumber="CmVIP-3"/>
<AccommodationSpot accommSpotId="17" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-1"/>
<AccommodationSpot accommSpotId="18" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-2"/>
<AccommodationSpot accommSpotId="19" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-3"/>
<AccommodationSpot accommSpotId="20" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-4"/>
<AccommodationSpot accommSpotId="21" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-5"/>
<AccommodationSpot accommSpotId="22" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-6"/>
<AccommodationSpot accommSpotId="23" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-7"/>
<AccommodationSpot accommSpotId="24" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-8"/>
<AccommodationSpot accommSpotId="25" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-9"/>
<AccommodationSpot accommSpotId="26" accommClassId="Chairs"
fixedAssetId="Bar/Lounge" nrOfSpaces="1"
accomNumber="brc-10"/>
</entity-engine-xml>
> Introduction of new reservation entities
> ----------------------------------------
>
> Key: OFBIZ-1590
> URL: https://issues.apache.org/jira/browse/OFBIZ-1590
> Project: OFBiz
> Issue Type: Improvement
> Components: order
> Affects Versions: SVN trunk
> Reporter: Valentina Sirkova
> Attachments: spot_class_map_entities.patch
>
>
> I propose the introduction of the following entities: AccommodationClass,
> AccommodationSpot,AccommodationMap. Their design is based on the book "The
> data model resource book".
> - AccommodationClass could define classes for hotels, cars, planes etc. I
> have added one more field here parentAccClass, as I thought it could be
> valuable for building more complicated hierarchies.
> - AccommodationMap is used to say how many spaces a class has. I have
> extended it further with a field overbooked, which could store the
> overbooking data for each class. E.g if we have that field we might know how
> many rooms of class "deluxe" could be overbooked. The primary key of
> AccommodationMap in the book includes the "NrOfSpaces" field but I did not
> add it in the patch as I am not sure of its exact purpose.
> - AccommodationSpot defines the specific seat,room etc of a given class. It
> is very powerful entity as it let us define the seat as a spot simply. This
> is very useful for planes and buses for example as we have the chance to
> define all the seats as spots and are not required to make them fas. I have
> modified the type of the field "accomNumber" to be of type short-varchar as
> plane seats for example are mixture of letters and numbers(The book models it
> of type numeric). The fk fields include the "nrOfSpaces" field in the book
> which I have not included in my patch.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
