automatic subscription extension cancellation how to do?

[hans_bakker]

Question to the community:

I have a customer who would like to have subscriptions extended
automatically unless cancelled before 1 month before the ending of the
subscription period.

What i was thinking about is adding some fields to the subscription
entity called 'extent' which could be 'N' indicating the subscription
should not be extended. It is also required to be able to add a period
before the subscription can be cancelled.

Then we will need a service which creates automatically an order,
copying the original order for the next subscription period, at the
moment the subscription expires. This order will then create a new
subscription.

So i think we need 3 new fields:

extent: N or Y/blank
cancelPeriod
cancelPeriodUomId

Is this the best way to do it?

Regards,
Hans
--
AntWebsystems.com: Quality OFBiz services for competitive rates.....

[David E Jones]

The current design uses the Subscription entity only for already paid  
subscriptions.

For automatic renewals the current code and such uses the ShoppingList  
with the auto-reorder type to automatically reorder the product that  
will extend the Subscription.

-David


On May 15, 2008, at 12:30 AM, Hans Bakker wrote:

> Question to the community:
>
> I have a customer who would like to have subscriptions extended
> automatically unless cancelled before 1 month before the ending of the
> subscription period.
>
> What i was thinking about is adding some fields to the subscription
> entity called 'extent' which could be 'N' indicating the subscription
> should not be extended. It is also required to be able to add a period
> before the subscription can be cancelled.
>
> Then we will need a service which creates automatically an order,
> copying the original order for the next subscription period, at the
> moment the subscription expires. This order will then create a new
> subscription.
>
> So i think we need 3 new fields:
>
> extent: N or Y/blank
> cancelPeriod
> cancelPeriodUomId
>
> Is this the best way to do it?
>
> Regards,
> Hans
> --
> AntWebsystems.com: Quality OFBiz services for competitive rates.....
>

[hans_bakker]

Now we have a subscription, isn't using the subscription a better way to
go then the shopping list? A much better implementation especially if
you think that a subscription is repetitive in nature anyway.

and....one way should not exclude the other way? is there a problem when
i would add this? What is the opinion of the community?

On Thu, 2008-05-15 at 00:35 -0600, David E Jones wrote:

> The current design uses the Subscription entity only for already paid  
> subscriptions.
>
> For automatic renewals the current code and such uses the ShoppingList  
> with the auto-reorder type to automatically reorder the product that  
> will extend the Subscription.
>
> -David
>
>
> On May 15, 2008, at 12:30 AM, Hans Bakker wrote:
>
> > Question to the community:
> >
> > I have a customer who would like to have subscriptions extended
> > automatically unless cancelled before 1 month before the ending of the
> > subscription period.
> >
> > What i was thinking about is adding some fields to the subscription
> > entity called 'extent' which could be 'N' indicating the subscription
> > should not be extended. It is also required to be able to add a period
> > before the subscription can be cancelled.
> >
> > Then we will need a service which creates automatically an order,
> > copying the original order for the next subscription period, at the
> > moment the subscription expires. This order will then create a new
> > subscription.
> >
> > So i think we need 3 new fields:
> >
> > extent: N or Y/blank
> > cancelPeriod
> > cancelPeriodUomId
> >
> > Is this the best way to do it?
> >
> > Regards,
> > Hans
> > --
> > AntWebsystems.com: Quality OFBiz services for competitive rates.....
> >
>
>

--
AntWebsystems.com: Quality OFBiz services for competitive rates.....

[Bilgin Ibryam]

 Hans,

why you don't want to use auto reorder ShoppingList? It is already
working the way you described?

Bilgin

[Sandip_Hazra]

Dear all,
Is it possible to deploy one J2EE application in OFBiz Application
Server? Can we use Entity Engine of OFBiz in our J2EE application?
Please answer my doubt if possible.

Regards,
 
Sandip Hazra
Satyam Computer Services Ltd.| VBU-Retail
S - 1,Maitree Vihar Road,Chandrasekharpur,Bhubaneshwar Orissa - 751023
Phone - 0674 - 391 - 2323  Extn -2017  Mobile - 09937678195



DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.

[hans_bakker]

Bilgin,
The main problem i have is that this customer is not using the ecommerce
and want to handle this from the backend.

Did you try to add a recurring order from the backend?

enter the order for the subscription product, then:
1. go to party,
2. find the customer
3. create the shoppinglist
4. enter the recurrence: not available
5. enter the productid.
6. activate the shoppinglist

when the customer cancels the subscription:
1. go to party,
2. find the customer
3. find the related shoppinglist (if there are more subscriptions)
4. remove the product from the shoppinglist

Now the proposed way:
---------------------
create:
enter the order for the subscription product

to cancel:
1. go to catalog -> subscriptions
2. list all subscriptions for that customer.
3. set the extent flag to 'N' on the particular subscription.

In the frontend, we could add an extra column in the orderlist:
subscription with the ability to cancel the subscription.

regards,
Hans



On Thu, 2008-05-15 at 11:29 +0300, Bilgin Ibryam wrote:
> Hans,
>
> why you don't want to use auto reorder ShoppingList? It is already
> working the way you described?
>
> Bilgin
>
>
>
--
AntWebsystems.com: Quality OFBiz services for competitive rates.....

[Bilgin Ibryam]

On Thu, 2008-05-15 at 16:09 +0700, Hans Bakker wrote:
> Bilgin,
> The main problem i have is that this customer is not using the
> ecommerce
> and want to handle this from the backend.

One solution could be adding a screen to order manager, where the user
can create auto reorders for existing orders.

Just my 2 cents

[jacques.le.roux-2]

From: "Sandip_Hazra" <[hidden email]>

> Dear all,
> Is it possible to deploy one J2EE application in OFBiz Application
> Server?
Yes, it is. Some examples  
http://docs.ofbiz.org/display/OFBTECH/Run+OFBiz+under+outside+Application+Servers. For more look  
at
framework\appserver

> Can we use Entity Engine of OFBiz in our J2EE application?
Yes, Jira is doing that  
http://www.atlassian.com/software/jira/docs/latest/entityengine.html

Jacques

[Eric DE MAULDE]

Hello,

I need advises in particular to implement an e-banking credit-card service
(Sherlocks by Atos Origin).
I have several errors with the response servlet (see below, the two fisrt
errors)
My servlet can't modify the "OrderComponentPreference" table

Thank you so much for you reply

Eric DE MAULDE

2008-05-16 17:57:12,480 (http-0.0.0.0-8443-Processor2) [
JavaEventHandler.java:112:ERROR] ---- runtime exception
report -------------------------------------------------- Problems
Processing Event Exception: java.lang.NullPointerException Message:
null ---- stack
trace ---------------------------------------------------------------
java.lang.NullPointerException
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:93)
org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:74)
org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:454)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:281)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:198)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:78)
javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:255)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:542)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
java.lang.Thread.run(Thread.java:595) --------------------------------------------------------------------------------
2008-05-16 17:57:12,481 (http-0.0.0.0-8443-Processor2) [
RequestHandler.java:314:ERROR] Request sherlocksResponse caused an error
with the following message: Erreur lors de l'appel de l'événement:
org.ofbiz.webapp.event.EventHandlerException: Problems processing event:
java.lang.NullPointerException (null)

[BJ Freeman]

this is a customization.
so how you implemented it would help.


Eric sent the following on 5/16/2008 9:03 AM:

> Hello,
>
> I need advises in particular to implement an e-banking credit-card service
> (Sherlocks by Atos Origin).
> I have several errors with the response servlet (see below, the two fisrt
> errors)
> My servlet can't modify the "OrderComponentPreference" table
>
> Thank you so much for you reply
>
> Eric DE MAULDE
>
> 2008-05-16 17:57:12,480 (http-0.0.0.0-8443-Processor2) [
> JavaEventHandler.java:112:ERROR] ---- runtime exception
> report -------------------------------------------------- Problems
> Processing Event Exception: java.lang.NullPointerException Message:
> null ---- stack
> trace ---------------------------------------------------------------
> java.lang.NullPointerException
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> java.lang.reflect.Method.invoke(Method.java:585)
> org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:93)
> org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:74)
> org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:454)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:281)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:198)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:78)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:255)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
>
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
>
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
>
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
>
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:542)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
>
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
>
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
>
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
>
> java.lang.Thread.run(Thread.java:595)
> --------------------------------------------------------------------------------
>
> 2008-05-16 17:57:12,481 (http-0.0.0.0-8443-Processor2) [
> RequestHandler.java:314:ERROR] Request sherlocksResponse caused an error
> with the following message: Erreur lors de l'appel de l'événement:
> org.ofbiz.webapp.event.EventHandlerException: Problems processing event:
> java.lang.NullPointerException (null)
>
>
>
>