You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Chandresh Turakhia <ch...@bhartitelesoft.com> on 2006/12/13 10:03:05 UTC
Order BlackListing...
Hi ,
How to use this feature. How does the orderid gets generated
Thanks in advance
Chand
----- Original Message -----
From: "David E. Jones (JIRA)" <ji...@apache.org>
To: <of...@incubator.apache.org>
Sent: Tuesday, December 12, 2006 10:59 PM
Subject: [jira] Closed: (OFBIZ-401) upgrade bsf to something a bit more
modern
> [ http://issues.apache.org/jira/browse/OFBIZ-401?page=all ]
>
> David E. Jones closed OFBIZ-401.
> --------------------------------
>
> Resolution: Fixed
>
> Thanks for your patience on this one Adam. Hopefully it's in SVN for good
> now, in rev 486518.
>
>> upgrade bsf to something a bit more modern
>> ------------------------------------------
>>
>> Key: OFBIZ-401
>> URL: http://issues.apache.org/jira/browse/OFBIZ-401
>> Project: OFBiz (The Open for Business Project)
>> Issue Type: Bug
>> Components: framework
>> Affects Versions: SVN trunk
>> Reporter: Adam Heath
>> Assigned To: David E. Jones
>> Priority: Trivial
>> Fix For: SVN trunk
>>
>> Attachments: bsf.diff
>>
>>
>> OfBiz still uses a bsf version from when it was hosted/maintained by ibm.
>> The attached patch fixes this(does a search/replace), changing the
>> package names.
>
> --
> This message is automatically generated by JIRA.
> -
> If you think it was sent incorrectly contact one of the administrators:
> http://issues.apache.org/jira/secure/Administrators.jspa
> -
> For more information on JIRA, see: http://www.atlassian.com/software/jira
>
>
>
>
Re: Order �d Prefix
Posted by Chris Howe <cj...@yahoo.com>.
This is really a User's mailing list question, you'll
tend to get a faster response there.
IMO I would never convey information about a record
through a convention of the primary key. The only
time I would have the primary key have actual
information about the record is if it's a natural part
of the record (ie a credit card number being a primary
key in a table of credit cards if security weren't an
issue). If you want to convey information about when
an order was placed do it based on the actual data of
when it was placed.
For instance when an order is placed, the time that
the order was created is entered in OrderStatus. Base
your application distinguishing when it was placed
based on that, not on some convention of the orderId
prefix. In the enterprise world, your data is going
to live long after your application and more
specifically, long after the developer who decided on
the conventions will be employed by the user of the
data.
This is best shown in the difficulties that arise in
the Product entity by using Product.productId as both
a primary key and the item number that people place
orders on. If your productId wasn't relevant data
before it was created in the database, the only thing
that extra data should be relevant to is the database,
not the people using the data.
--- Chandresh Turakhia
<ch...@bhartitelesoft.com> wrote:
> Hi ,
>
> Whats the best way to update the
> Order_number_prefix.
>
> Should Order_Number_Prefix be allowed for change
> once the store is
> operational. Becomes Design issues. Do we need some
> constraint.
>
> Basically trying to change transaction prefix based
> on weekdays or weekends.
>
> Changing from backend so that new transaction use
> different prefix gave
> errors in next time startup. Ofbiz ecommerce page
> even did not turn up.
>
> Chand
>
>
> ----- Original Message -----
> From: "Chris Howe" <cj...@yahoo.com>
> To: <of...@incubator.apache.org>
> Sent: Wednesday, December 13, 2006 6:52 AM
> Subject: Re: Order BlackListing...
>
>
> > WS comes from ProductStore.orderNumberPrefix. The
> > number is based on SequenceValueItem. I can't
> tell if
> > you had another question in there.
> >
> >
> > --- Chandresh Turakhia
> > <ch...@bhartitelesoft.com> wrote:
> >
> >> Dear all ,
> >>
> >> I was trying to decip how WS10010 gets generated.
> >> While Checking SequenceUtil , Delegator , was
> >> wondering why does it seem to need parent.
> >>
> >> when we call partyId =
> >> delegator.getNextSeqId("Party"), does Party
> string
> >> links id generation to PARTY table ?
> >>
> >> Code in GeneralDelegator.java
> >> sql = "INSERT INTO " + parentUtil.tableName + "
> (" +
> >> parentUtil.nameColName + ", " +
> parentUtil.idColName
> >> + ") VALUES ('" + this.seqName + "', " +
> startSeqId
> >> + ")";
> >>
> >> I have question where is string "WS" configured .
> >> Rest seems be based on bank and increment.
> >>
> >> Chand
> >>
> >> ----- Original Message -----
> >> From: "Chandresh Turakhia"
> >> <ch...@bhartitelesoft.com>
> >> To: <of...@incubator.apache.org>
> >> Sent: Wednesday, December 13, 2006 1:03 AM
> >> Subject: Order BlackListing...
> >>
> >>
> >> > Hi ,
> >> >
> >> > How to use this feature. How does the orderid
> gets
> >> generated
> >> >
> >> > Thanks in advance
> >> > Chand
> >> > ----- Original Message -----
> >> > From: "David E. Jones (JIRA)" <ji...@apache.org>
> >> > To: <of...@incubator.apache.org>
> >> > Sent: Tuesday, December 12, 2006 10:59 PM
> >> > Subject: [jira] Closed: (OFBIZ-401) upgrade bsf
> to
> >> something a bit more
> >> > modern
> >> >
> >> >
> >> >> [
> >>
> >
>
http://issues.apache.org/jira/browse/OFBIZ-401?page=all
> >> ]
> >> >>
> >> >> David E. Jones closed OFBIZ-401.
> >> >> --------------------------------
> >> >>
> >> >> Resolution: Fixed
> >> >>
> >> >> Thanks for your patience on this one Adam.
> >> Hopefully it's in SVN for good
> >> >> now, in rev 486518.
> >> >>
> >> >>> upgrade bsf to something a bit more modern
> >> >>> ------------------------------------------
> >> >>>
> >> >>> Key: OFBIZ-401
> >> >>> URL:
> >> http://issues.apache.org/jira/browse/OFBIZ-401
> >> >>> Project: OFBiz (The Open for
> >> Business Project)
> >> >>> Issue Type: Bug
> >> >>> Components: framework
> >> >>> Affects Versions: SVN trunk
> >> >>> Reporter: Adam Heath
> >> >>> Assigned To: David E. Jones
> >> >>> Priority: Trivial
> >> >>> Fix For: SVN trunk
> >> >>>
> >> >>> Attachments: bsf.diff
> >> >>>
> >> >>>
> >> >>> OfBiz still uses a bsf version from when it
> was
> >> hosted/maintained by ibm.
> >> >>> The attached patch fixes this(does a
> >> search/replace), changing the
> >> >>> package names.
> >> >>
> >> >> --
> >> >> This message is automatically generated by
> JIRA.
> >> >> -
> >> >> If you think it was sent incorrectly contact
> one
> >> of the administrators:
> >> >>
> >>
> >
>
http://issues.apache.org/jira/secure/Administrators.jspa
> >> >> -
> >> >> For more information on JIRA, see:
> >> http://www.atlassian.com/software/jira
> >> >>
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >> >
> >
> >
>
>
>
Order Ïd Prefix
Posted by Chandresh Turakhia <ch...@bhartitelesoft.com>.
Hi ,
Whats the best way to update the Order_number_prefix.
Should Order_Number_Prefix be allowed for change once the store is
operational. Becomes Design issues. Do we need some constraint.
Basically trying to change transaction prefix based on weekdays or weekends.
Changing from backend so that new transaction use different prefix gave
errors in next time startup. Ofbiz ecommerce page even did not turn up.
Chand
----- Original Message -----
From: "Chris Howe" <cj...@yahoo.com>
To: <of...@incubator.apache.org>
Sent: Wednesday, December 13, 2006 6:52 AM
Subject: Re: Order BlackListing...
> WS comes from ProductStore.orderNumberPrefix. The
> number is based on SequenceValueItem. I can't tell if
> you had another question in there.
>
>
> --- Chandresh Turakhia
> <ch...@bhartitelesoft.com> wrote:
>
>> Dear all ,
>>
>> I was trying to decip how WS10010 gets generated.
>> While Checking SequenceUtil , Delegator , was
>> wondering why does it seem to need parent.
>>
>> when we call partyId =
>> delegator.getNextSeqId("Party"), does Party string
>> links id generation to PARTY table ?
>>
>> Code in GeneralDelegator.java
>> sql = "INSERT INTO " + parentUtil.tableName + " (" +
>> parentUtil.nameColName + ", " + parentUtil.idColName
>> + ") VALUES ('" + this.seqName + "', " + startSeqId
>> + ")";
>>
>> I have question where is string "WS" configured .
>> Rest seems be based on bank and increment.
>>
>> Chand
>>
>> ----- Original Message -----
>> From: "Chandresh Turakhia"
>> <ch...@bhartitelesoft.com>
>> To: <of...@incubator.apache.org>
>> Sent: Wednesday, December 13, 2006 1:03 AM
>> Subject: Order BlackListing...
>>
>>
>> > Hi ,
>> >
>> > How to use this feature. How does the orderid gets
>> generated
>> >
>> > Thanks in advance
>> > Chand
>> > ----- Original Message -----
>> > From: "David E. Jones (JIRA)" <ji...@apache.org>
>> > To: <of...@incubator.apache.org>
>> > Sent: Tuesday, December 12, 2006 10:59 PM
>> > Subject: [jira] Closed: (OFBIZ-401) upgrade bsf to
>> something a bit more
>> > modern
>> >
>> >
>> >> [
>>
> http://issues.apache.org/jira/browse/OFBIZ-401?page=all
>> ]
>> >>
>> >> David E. Jones closed OFBIZ-401.
>> >> --------------------------------
>> >>
>> >> Resolution: Fixed
>> >>
>> >> Thanks for your patience on this one Adam.
>> Hopefully it's in SVN for good
>> >> now, in rev 486518.
>> >>
>> >>> upgrade bsf to something a bit more modern
>> >>> ------------------------------------------
>> >>>
>> >>> Key: OFBIZ-401
>> >>> URL:
>> http://issues.apache.org/jira/browse/OFBIZ-401
>> >>> Project: OFBiz (The Open for
>> Business Project)
>> >>> Issue Type: Bug
>> >>> Components: framework
>> >>> Affects Versions: SVN trunk
>> >>> Reporter: Adam Heath
>> >>> Assigned To: David E. Jones
>> >>> Priority: Trivial
>> >>> Fix For: SVN trunk
>> >>>
>> >>> Attachments: bsf.diff
>> >>>
>> >>>
>> >>> OfBiz still uses a bsf version from when it was
>> hosted/maintained by ibm.
>> >>> The attached patch fixes this(does a
>> search/replace), changing the
>> >>> package names.
>> >>
>> >> --
>> >> This message is automatically generated by JIRA.
>> >> -
>> >> If you think it was sent incorrectly contact one
>> of the administrators:
>> >>
>>
> http://issues.apache.org/jira/secure/Administrators.jspa
>> >> -
>> >> For more information on JIRA, see:
>> http://www.atlassian.com/software/jira
>> >>
>> >>
>> >>
>> >>
>> >
>> >
>> >
>
>
Re: Order BlackListing...
Posted by Chris Howe <cj...@yahoo.com>.
WS comes from ProductStore.orderNumberPrefix. The
number is based on SequenceValueItem. I can't tell if
you had another question in there.
--- Chandresh Turakhia
<ch...@bhartitelesoft.com> wrote:
> Dear all ,
>
> I was trying to decip how WS10010 gets generated.
> While Checking SequenceUtil , Delegator , was
> wondering why does it seem to need parent.
>
> when we call partyId =
> delegator.getNextSeqId("Party"), does Party string
> links id generation to PARTY table ?
>
> Code in GeneralDelegator.java
> sql = "INSERT INTO " + parentUtil.tableName + " (" +
> parentUtil.nameColName + ", " + parentUtil.idColName
> + ") VALUES ('" + this.seqName + "', " + startSeqId
> + ")";
>
> I have question where is string "WS" configured .
> Rest seems be based on bank and increment.
>
> Chand
>
> ----- Original Message -----
> From: "Chandresh Turakhia"
> <ch...@bhartitelesoft.com>
> To: <of...@incubator.apache.org>
> Sent: Wednesday, December 13, 2006 1:03 AM
> Subject: Order BlackListing...
>
>
> > Hi ,
> >
> > How to use this feature. How does the orderid gets
> generated
> >
> > Thanks in advance
> > Chand
> > ----- Original Message -----
> > From: "David E. Jones (JIRA)" <ji...@apache.org>
> > To: <of...@incubator.apache.org>
> > Sent: Tuesday, December 12, 2006 10:59 PM
> > Subject: [jira] Closed: (OFBIZ-401) upgrade bsf to
> something a bit more
> > modern
> >
> >
> >> [
>
http://issues.apache.org/jira/browse/OFBIZ-401?page=all
> ]
> >>
> >> David E. Jones closed OFBIZ-401.
> >> --------------------------------
> >>
> >> Resolution: Fixed
> >>
> >> Thanks for your patience on this one Adam.
> Hopefully it's in SVN for good
> >> now, in rev 486518.
> >>
> >>> upgrade bsf to something a bit more modern
> >>> ------------------------------------------
> >>>
> >>> Key: OFBIZ-401
> >>> URL:
> http://issues.apache.org/jira/browse/OFBIZ-401
> >>> Project: OFBiz (The Open for
> Business Project)
> >>> Issue Type: Bug
> >>> Components: framework
> >>> Affects Versions: SVN trunk
> >>> Reporter: Adam Heath
> >>> Assigned To: David E. Jones
> >>> Priority: Trivial
> >>> Fix For: SVN trunk
> >>>
> >>> Attachments: bsf.diff
> >>>
> >>>
> >>> OfBiz still uses a bsf version from when it was
> hosted/maintained by ibm.
> >>> The attached patch fixes this(does a
> search/replace), changing the
> >>> package names.
> >>
> >> --
> >> This message is automatically generated by JIRA.
> >> -
> >> If you think it was sent incorrectly contact one
> of the administrators:
> >>
>
http://issues.apache.org/jira/secure/Administrators.jspa
> >> -
> >> For more information on JIRA, see:
> http://www.atlassian.com/software/jira
> >>
> >>
> >>
> >>
> >
> >
> >
Re: Order BlackListing...
Posted by Chandresh Turakhia <ch...@bhartitelesoft.com>.
Dear all ,
I was trying to decip how WS10010 gets generated. While Checking SequenceUtil , Delegator , was wondering why does it seem to need parent.
when we call partyId = delegator.getNextSeqId("Party"), does Party string links id generation to PARTY table ?
Code in GeneralDelegator.java
sql = "INSERT INTO " + parentUtil.tableName + " (" + parentUtil.nameColName + ", " + parentUtil.idColName + ") VALUES ('" + this.seqName + "', " + startSeqId + ")";
I have question where is string "WS" configured . Rest seems be based on bank and increment.
Chand
----- Original Message -----
From: "Chandresh Turakhia" <ch...@bhartitelesoft.com>
To: <of...@incubator.apache.org>
Sent: Wednesday, December 13, 2006 1:03 AM
Subject: Order BlackListing...
> Hi ,
>
> How to use this feature. How does the orderid gets generated
>
> Thanks in advance
> Chand
> ----- Original Message -----
> From: "David E. Jones (JIRA)" <ji...@apache.org>
> To: <of...@incubator.apache.org>
> Sent: Tuesday, December 12, 2006 10:59 PM
> Subject: [jira] Closed: (OFBIZ-401) upgrade bsf to something a bit more
> modern
>
>
>> [ http://issues.apache.org/jira/browse/OFBIZ-401?page=all ]
>>
>> David E. Jones closed OFBIZ-401.
>> --------------------------------
>>
>> Resolution: Fixed
>>
>> Thanks for your patience on this one Adam. Hopefully it's in SVN for good
>> now, in rev 486518.
>>
>>> upgrade bsf to something a bit more modern
>>> ------------------------------------------
>>>
>>> Key: OFBIZ-401
>>> URL: http://issues.apache.org/jira/browse/OFBIZ-401
>>> Project: OFBiz (The Open for Business Project)
>>> Issue Type: Bug
>>> Components: framework
>>> Affects Versions: SVN trunk
>>> Reporter: Adam Heath
>>> Assigned To: David E. Jones
>>> Priority: Trivial
>>> Fix For: SVN trunk
>>>
>>> Attachments: bsf.diff
>>>
>>>
>>> OfBiz still uses a bsf version from when it was hosted/maintained by ibm.
>>> The attached patch fixes this(does a search/replace), changing the
>>> package names.
>>
>> --
>> This message is automatically generated by JIRA.
>> -
>> If you think it was sent incorrectly contact one of the administrators:
>> http://issues.apache.org/jira/secure/Administrators.jspa
>> -
>> For more information on JIRA, see: http://www.atlassian.com/software/jira
>>
>>
>>
>>
>
>
>