You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Vaibhav Jain <va...@hotwaxsystems.com> on 2017/12/01 05:12:11 UTC
Re: [Proposal] Extend facility entity
Hello all,
Sorry for late reply as I was out of town.
Thank you very much to all of you for sharing this valuable information.
As we can conclude this conversation here.
I will create a new entity facilityCalendar which will create the
one-to-many relationship between facility and calendar. Here are the entity
attributes:
1. facilityId*
2. calendarId*
3. fromDate*
4. thruDate
A calendar will be used to store *openingTime*, *closingTime*, working
weekdays and all this type of stuff.
If this looks good to everyone then I will raise a JIRA for this.
Thanks & Regards
Vaibhav Jain
Hotwax Systems,
vaibhav.jain@hotwaxsystems.com
On Mon, Nov 27, 2017 at 1:42 PM, Jacques Le Roux <
jacques.le.roux@les7arts.com> wrote:
> Hi Deepak,
>
> Seems to me that FacilityCalendar would be easier
>
> My 2cts
>
> Jacques
>
>
>
> Le 27/11/2017 à 07:00, Deepak Dixit a écrit :
>
>> I think we can use TemporalExpression to manage this data.
>>
>> Thanks & Regards
>> --
>> Deepak Dixit
>> www.hotwaxsystems.com
>> www.hotwax.co
>>
>> On Mon, Nov 27, 2017 at 9:46 AM, Arun Patidar <
>> arun.patidar@hotwaxsystems.com> wrote:
>>
>> +1 for FacilityCalendar entity with purpose.
>>>
>>> --
>>> Thanks & Regards
>>> ---
>>> Arun Patidar
>>> Manager, Enterprise Software Development
>>>
>>> HotWax Systems Pvt Ltd.
>>>
>>> www.hotwaxsystems.com
>>>
>>>
>>> On Sun, Nov 26, 2017 at 3:31 AM, pierre <pi...@nereide.biz>
>>> wrote:
>>>
>>> Hi Pierre,
>>>>
>>>> The "primary" pattern is often used such in productCategory or
>>>> productStore entity.
>>>> It can simplify acces for simple use.
>>>>
>>>> Thanks
>>>>
>>>> Pierre G
>>>>
>>>>
>>>>
>>>> On 25/11/2017 22:26, Pierre Smits wrote:
>>>>
>>>> Why would a new field called primaryCalendarId be required when this
>>>>
>>> could
>>>
>>>> be resolved through you proposed FacilityCalendar entity?
>>>> If there is only one it is the primary. And if multiple are required
>>>> then
>>>> one can have facilityCalendarPurposeId =
>>>> primary/default/whatever-your-Definition-for-that-is.
>>>>
>>>> Best regards,
>>>>
>>>> Pierre
>>>>
>>>>
>>>> On Sat, 25 Nov 2017 at 21:59 pierre.gaudin <pi...@nereide.fr> <
>>>>
>>> pierre.gaudin@nereide.fr> wrote:
>>>
>>>>
>>>> Can we set a primaryCalendarId field on Facility entity and add a join
>>>> entity FacilityCalendar with fields facilityId, caldendarId,
>>>> facilityCalendarPurposeId, description for complex use ?
>>>>
>>>> Pierre
>>>>
>>>>
>>>> On 25/11/2017 19:18, Pierre Smits wrote:
>>>>
>>>> Hi Jacques, All,
>>>>
>>>> Consider following scenarios:
>>>>
>>>> 1. A business with a facility in a city center, where city
>>>> government
>>>> has placed restrictions on the access of the city center for
>>>> trucks,
>>>>
>>>> and
>>>>
>>>> other set of restrictions of opening hours for customers:
>>>> 1. a calendar for suppliers and other logistics service
>>>> providers
>>>> 2. a calendar for customers
>>>> 2. A hospital with multiple child facilities:
>>>> 1. The warehouse: a calendar for suppliers and other logistics
>>>> service providers
>>>> 2. The outpatient clinic: a calendar for the opening hours
>>>> 3. The nursing departments: a calendar regarding visiting hours
>>>>
>>>> Plus , for any kind of legal entity: one or more calendars regarding
>>>> working hours of staff. I feel confident that you and others can dream
>>>> up
>>>> other scenarios too.
>>>>
>>>> Best regards,
>>>>
>>>> Pierre Smits
>>>> ORRTIZ.COM <http://www.orrtiz.com> <http://www.orrtiz.com>
>>>> OFBiz based solutions & services
>>>>
>>>> OEM - The OFBiz Extensions Marketplace1http://oem.ofbizci.net/oci-2/
>>>> 1 not affiliated to (and not endorsed by) the OFBiz project
>>>>
>>>> On Sat, Nov 25, 2017 at 5:32 PM, Jacques Le Roux <
>>>>
>>> jacques.le.roux@les7arts.com> wrote:
>>>
>>>>
>>>> Hi Pierre,
>>>>
>>>> Actually I was answering to Pierre Gaudin :)
>>>>
>>>> More than one calendar for a facility? Do you have an example?
>>>>
>>>> Jacques
>>>>
>>>>
>>>> Le 25/11/2017 à 15:53, Pierre Smits a écrit :
>>>>
>>>>
>>>> Hey Jacques,
>>>>
>>>> You're welcome.
>>>>
>>>> {quote}
>>>> Anyway, so Vaibhav, I think we can now put directly <field
>>>> name="calendarId" type="value" /> in Facility
>>>> {quote}
>>>>
>>>> Are you sure? Is there no scenario possible where a facility would
>>>>
>>>> need to
>>>>
>>>> apply more than 1 calendar?
>>>>
>>>> Best regards,
>>>>
>>>> Pierre Smits
>>>> ORRTIZ.COM <http://www.orrtiz.com> <http://www.orrtiz.com>
>>>>
>>>> OFBiz based solutions & services
>>>>
>>>> OEM - The OFBiz Extensions Marketplace1http://oem.ofbizci.net/oci-2/
>>>> 1 not affiliated to (and not endorsed by) the OFBiz project
>>>>
>>>> On Sat, Nov 25, 2017 at 3:24 PM, Jacques Le Roux <
>>>>
>>> jacques.le.roux@les7arts.com> wrote:
>>>
>>>> Thanks for the info Pierre,
>>>>
>>>> Exactly the right answer!
>>>>
>>>> I thought there was something in workeffort data model, I know less
>>>> manufacturing :)
>>>>
>>>> BTW, I wonder why TechDataCalendar is in manufacturing rather than in
>>>> workeffort where IMO it would better fit since it's more general
>>>>
>>>> there.
>>>>
>>>> Anyway, so Vaibhav, I think we can now put directly <field
>>>> name="calendarId" type="value" /> in Facility
>>>>
>>>> Jacques
>>>>
>>>>
>>>>
>>>> Le 25/11/2017 à 13:47, pierre.gaudin a écrit :
>>>>
>>>> Hi,
>>>>
>>>> Recently we had to store opening and closing hours for stores. To do
>>>>
>>>> so
>>>>
>>>> we have linked techDataCalendar with facility
>>>>
>>>> <extend-entity entity-name="Facility">
>>>>
>>>> <field name="calendarId" type="value" />
>>>> </extend-entity>
>>>>
>>>> Thanks
>>>>
>>>> Pierre
>>>> On 25/11/2017 11:53, Michael Brohl wrote:
>>>>
>>>> +1 for a timetable entity and linking it to facility
>>>>
>>>> This will give us much more flexibility and avoids adding more and
>>>>
>>>> more
>>>>
>>>> fields to the facility table.
>>>>
>>>> Thanks,
>>>>
>>>> Michael
>>>>
>>>>
>>>> Am 25.11.17 um 11:39 schrieb Jacques Le Roux:
>>>>
>>>> Hi Vaibhav,
>>>>
>>>> That sounds reasonable to me. I notably like this feature when
>>>> Googling
>>>> for a *physical* store to go buying things.
>>>>
>>>> Then you should maybe consider having a new Timetable Entity and
>>>>
>>>> link
>>>>
>>>> it from Facility.
>>>>
>>>> I had a look at what already exists in the Data Model, notably
>>>> Timesheet and TimeEntry, but they don't really fit here.
>>>>
>>>> Jacques
>>>>
>>>>
>>>> Le 25/11/2017 à 11:06, Vaibhav Jain a écrit :
>>>>
>>>> Hello all,
>>>>
>>>> *Facility* entity has attributes for *openedDate* and *closedDate*
>>>> which
>>>> specify that facility opening date and closing date if the
>>>>
>>>> facility
>>>>
>>>> is
>>>> closed i.e. not in-use.
>>>>
>>>> All facilities are not open on all weekdays. We can have an
>>>>
>>>> attribute
>>>>
>>>> to
>>>> record this.
>>>>
>>>> A retail store is also a facility and we should record
>>>>
>>>> *openingTime*
>>>>
>>>> and
>>>> *closingTime* in facility entity. *openingTime* and *closingTime*
>>>>
>>>> may
>>>>
>>>> be
>>>> different for some of the weekdays as well.
>>>>
>>>> Please share your thoughts on this.
>>>>
>>>> --
>>>> Thanks and Regards,
>>>> Vaibhav Jain
>>>> Hotwax Systems,vaibhav.jain@hotwaxsystems.com
>>>>
>>>>
>>>> --
>>>>
>>>> Pierre Smits
>>>> ORRTIZ.COM <http://www.orrtiz.com> <http://www.orrtiz.com>
>>>> OFBiz based solutions & services
>>>>
>>>> OEM - The OFBiz Extensions Marketplace1http://oem.ofbizci.net/oci-2/
>>>> 1 not affiliated to (and not endorsed by) the OFBiz project
>>>>
>>>>
>>>>
>>>> --
>>>> [image: logoNrd] <http://nereide.fr/>
>>>> Pierre GAUDIN
>>>> Consultant Fonctionnel Apache-OFBiz, ERP en logiciel Libre
>>>> information@nereide.fr
>>>> 8 rue des Déportés 37000 TOURS
>>>> Std: 02 47 50 30 54 - mob: 06 08 40 25 70
>>>> réseau LE <http://www.libre-entreprise.org/>
>>>>
>>>>
>>>>
>
Re: [Proposal] Extend facility entity
Posted by Vaibhav Jain <va...@hotwaxsystems.com>.
Hello all,
Here is the link to ticket OFBIZ-10040
<https://issues.apache.org/jira/browse/OFBIZ-10040> raised on JIRA.
Thanks & Regards,
Vaibhav Jain
Hotwax Systems,
vaibhav.jain@hotwaxsystems.com
On Fri, Dec 1, 2017 at 10:42 AM, Vaibhav Jain <
vaibhav.jain@hotwaxsystems.com> wrote:
> Hello all,
>
> Sorry for late reply as I was out of town.
>
> Thank you very much to all of you for sharing this valuable information.
>
> As we can conclude this conversation here.
>
> I will create a new entity facilityCalendar which will create the
> one-to-many relationship between facility and calendar. Here are the entity
> attributes:
>
> 1. facilityId*
> 2. calendarId*
> 3. fromDate*
> 4. thruDate
>
> A calendar will be used to store *openingTime*, *closingTime*, working
> weekdays and all this type of stuff.
>
> If this looks good to everyone then I will raise a JIRA for this.
>
> Thanks & Regards
>
> Vaibhav Jain
> Hotwax Systems,
> vaibhav.jain@hotwaxsystems.com
>
> On Mon, Nov 27, 2017 at 1:42 PM, Jacques Le Roux <
> jacques.le.roux@les7arts.com> wrote:
>
>> Hi Deepak,
>>
>> Seems to me that FacilityCalendar would be easier
>>
>> My 2cts
>>
>> Jacques
>>
>>
>>
>> Le 27/11/2017 à 07:00, Deepak Dixit a écrit :
>>
>>> I think we can use TemporalExpression to manage this data.
>>>
>>> Thanks & Regards
>>> --
>>> Deepak Dixit
>>> www.hotwaxsystems.com
>>> www.hotwax.co
>>>
>>> On Mon, Nov 27, 2017 at 9:46 AM, Arun Patidar <
>>> arun.patidar@hotwaxsystems.com> wrote:
>>>
>>> +1 for FacilityCalendar entity with purpose.
>>>>
>>>> --
>>>> Thanks & Regards
>>>> ---
>>>> Arun Patidar
>>>> Manager, Enterprise Software Development
>>>>
>>>> HotWax Systems Pvt Ltd.
>>>>
>>>> www.hotwaxsystems.com
>>>>
>>>>
>>>> On Sun, Nov 26, 2017 at 3:31 AM, pierre <pi...@nereide.biz>
>>>> wrote:
>>>>
>>>> Hi Pierre,
>>>>>
>>>>> The "primary" pattern is often used such in productCategory or
>>>>> productStore entity.
>>>>> It can simplify acces for simple use.
>>>>>
>>>>> Thanks
>>>>>
>>>>> Pierre G
>>>>>
>>>>>
>>>>>
>>>>> On 25/11/2017 22:26, Pierre Smits wrote:
>>>>>
>>>>> Why would a new field called primaryCalendarId be required when this
>>>>>
>>>> could
>>>>
>>>>> be resolved through you proposed FacilityCalendar entity?
>>>>> If there is only one it is the primary. And if multiple are required
>>>>> then
>>>>> one can have facilityCalendarPurposeId =
>>>>> primary/default/whatever-your-Definition-for-that-is.
>>>>>
>>>>> Best regards,
>>>>>
>>>>> Pierre
>>>>>
>>>>>
>>>>> On Sat, 25 Nov 2017 at 21:59 pierre.gaudin <pi...@nereide.fr>
>>>>> <
>>>>>
>>>> pierre.gaudin@nereide.fr> wrote:
>>>>
>>>>>
>>>>> Can we set a primaryCalendarId field on Facility entity and add a join
>>>>> entity FacilityCalendar with fields facilityId, caldendarId,
>>>>> facilityCalendarPurposeId, description for complex use ?
>>>>>
>>>>> Pierre
>>>>>
>>>>>
>>>>> On 25/11/2017 19:18, Pierre Smits wrote:
>>>>>
>>>>> Hi Jacques, All,
>>>>>
>>>>> Consider following scenarios:
>>>>>
>>>>> 1. A business with a facility in a city center, where city
>>>>> government
>>>>> has placed restrictions on the access of the city center for
>>>>> trucks,
>>>>>
>>>>> and
>>>>>
>>>>> other set of restrictions of opening hours for customers:
>>>>> 1. a calendar for suppliers and other logistics service
>>>>> providers
>>>>> 2. a calendar for customers
>>>>> 2. A hospital with multiple child facilities:
>>>>> 1. The warehouse: a calendar for suppliers and other logistics
>>>>> service providers
>>>>> 2. The outpatient clinic: a calendar for the opening hours
>>>>> 3. The nursing departments: a calendar regarding visiting hours
>>>>>
>>>>> Plus , for any kind of legal entity: one or more calendars regarding
>>>>> working hours of staff. I feel confident that you and others can dream
>>>>> up
>>>>> other scenarios too.
>>>>>
>>>>> Best regards,
>>>>>
>>>>> Pierre Smits
>>>>> ORRTIZ.COM <http://www.orrtiz.com> <http://www.orrtiz.com>
>>>>> OFBiz based solutions & services
>>>>>
>>>>> OEM - The OFBiz Extensions Marketplace1http://oem.ofbizci.net/oci-2/
>>>>> 1 not affiliated to (and not endorsed by) the OFBiz project
>>>>>
>>>>> On Sat, Nov 25, 2017 at 5:32 PM, Jacques Le Roux <
>>>>>
>>>> jacques.le.roux@les7arts.com> wrote:
>>>>
>>>>>
>>>>> Hi Pierre,
>>>>>
>>>>> Actually I was answering to Pierre Gaudin :)
>>>>>
>>>>> More than one calendar for a facility? Do you have an example?
>>>>>
>>>>> Jacques
>>>>>
>>>>>
>>>>> Le 25/11/2017 à 15:53, Pierre Smits a écrit :
>>>>>
>>>>>
>>>>> Hey Jacques,
>>>>>
>>>>> You're welcome.
>>>>>
>>>>> {quote}
>>>>> Anyway, so Vaibhav, I think we can now put directly <field
>>>>> name="calendarId" type="value" /> in Facility
>>>>> {quote}
>>>>>
>>>>> Are you sure? Is there no scenario possible where a facility would
>>>>>
>>>>> need to
>>>>>
>>>>> apply more than 1 calendar?
>>>>>
>>>>> Best regards,
>>>>>
>>>>> Pierre Smits
>>>>> ORRTIZ.COM <http://www.orrtiz.com> <http://www.orrtiz.com>
>>>>>
>>>>> OFBiz based solutions & services
>>>>>
>>>>> OEM - The OFBiz Extensions Marketplace1http://oem.ofbizci.net/oci-2/
>>>>> 1 not affiliated to (and not endorsed by) the OFBiz project
>>>>>
>>>>> On Sat, Nov 25, 2017 at 3:24 PM, Jacques Le Roux <
>>>>>
>>>> jacques.le.roux@les7arts.com> wrote:
>>>>
>>>>> Thanks for the info Pierre,
>>>>>
>>>>> Exactly the right answer!
>>>>>
>>>>> I thought there was something in workeffort data model, I know less
>>>>> manufacturing :)
>>>>>
>>>>> BTW, I wonder why TechDataCalendar is in manufacturing rather than in
>>>>> workeffort where IMO it would better fit since it's more general
>>>>>
>>>>> there.
>>>>>
>>>>> Anyway, so Vaibhav, I think we can now put directly <field
>>>>> name="calendarId" type="value" /> in Facility
>>>>>
>>>>> Jacques
>>>>>
>>>>>
>>>>>
>>>>> Le 25/11/2017 à 13:47, pierre.gaudin a écrit :
>>>>>
>>>>> Hi,
>>>>>
>>>>> Recently we had to store opening and closing hours for stores. To do
>>>>>
>>>>> so
>>>>>
>>>>> we have linked techDataCalendar with facility
>>>>>
>>>>> <extend-entity entity-name="Facility">
>>>>>
>>>>> <field name="calendarId" type="value" />
>>>>> </extend-entity>
>>>>>
>>>>> Thanks
>>>>>
>>>>> Pierre
>>>>> On 25/11/2017 11:53, Michael Brohl wrote:
>>>>>
>>>>> +1 for a timetable entity and linking it to facility
>>>>>
>>>>> This will give us much more flexibility and avoids adding more and
>>>>>
>>>>> more
>>>>>
>>>>> fields to the facility table.
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Michael
>>>>>
>>>>>
>>>>> Am 25.11.17 um 11:39 schrieb Jacques Le Roux:
>>>>>
>>>>> Hi Vaibhav,
>>>>>
>>>>> That sounds reasonable to me. I notably like this feature when
>>>>> Googling
>>>>> for a *physical* store to go buying things.
>>>>>
>>>>> Then you should maybe consider having a new Timetable Entity and
>>>>>
>>>>> link
>>>>>
>>>>> it from Facility.
>>>>>
>>>>> I had a look at what already exists in the Data Model, notably
>>>>> Timesheet and TimeEntry, but they don't really fit here.
>>>>>
>>>>> Jacques
>>>>>
>>>>>
>>>>> Le 25/11/2017 à 11:06, Vaibhav Jain a écrit :
>>>>>
>>>>> Hello all,
>>>>>
>>>>> *Facility* entity has attributes for *openedDate* and *closedDate*
>>>>> which
>>>>> specify that facility opening date and closing date if the
>>>>>
>>>>> facility
>>>>>
>>>>> is
>>>>> closed i.e. not in-use.
>>>>>
>>>>> All facilities are not open on all weekdays. We can have an
>>>>>
>>>>> attribute
>>>>>
>>>>> to
>>>>> record this.
>>>>>
>>>>> A retail store is also a facility and we should record
>>>>>
>>>>> *openingTime*
>>>>>
>>>>> and
>>>>> *closingTime* in facility entity. *openingTime* and *closingTime*
>>>>>
>>>>> may
>>>>>
>>>>> be
>>>>> different for some of the weekdays as well.
>>>>>
>>>>> Please share your thoughts on this.
>>>>>
>>>>> --
>>>>> Thanks and Regards,
>>>>> Vaibhav Jain
>>>>> Hotwax Systems,vaibhav.jain@hotwaxsystems.com
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> Pierre Smits
>>>>> ORRTIZ.COM <http://www.orrtiz.com> <http://www.orrtiz.com>
>>>>> OFBiz based solutions & services
>>>>>
>>>>> OEM - The OFBiz Extensions Marketplace1http://oem.ofbizci.net/oci-2/
>>>>> 1 not affiliated to (and not endorsed by) the OFBiz project
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> [image: logoNrd] <http://nereide.fr/>
>>>>> Pierre GAUDIN
>>>>> Consultant Fonctionnel Apache-OFBiz, ERP en logiciel Libre
>>>>> information@nereide.fr
>>>>> 8 rue des Déportés 37000 TOURS
>>>>> Std: 02 47 50 30 54 - mob: 06 08 40 25 70
>>>>> réseau LE <http://www.libre-entreprise.org/>
>>>>>
>>>>>
>>>>>
>>
>