From user-return-53824-archive-asf-public=cust-asf.ponee.io@ofbiz.apache.org Mon May 14 06:38:50 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 1A289180627 for ; Mon, 14 May 2018 06:38:49 +0200 (CEST) Received: (qmail 49051 invoked by uid 500); 14 May 2018 04:38:43 -0000 Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ofbiz.apache.org Delivered-To: mailing list user@ofbiz.apache.org Received: (qmail 49033 invoked by uid 99); 14 May 2018 04:38:42 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 May 2018 04:38:42 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id A925018045C for ; Mon, 14 May 2018 04:38:41 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.179 X-Spam-Level: * X-Spam-Status: No, score=1.179 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id QBzdIz3MwUdH for ; Mon, 14 May 2018 04:38:40 +0000 (UTC) Received: from mail-it0-f50.google.com (mail-it0-f50.google.com [209.85.214.50]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id CE29D5F21E for ; Mon, 14 May 2018 04:38:39 +0000 (UTC) Received: by mail-it0-f50.google.com with SMTP id c3-v6so9022251itj.4 for ; Sun, 13 May 2018 21:38:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=oFePmKzJRyl7i9QiTObfIgvVuZgYNc4PTxqbdowwQtg=; b=tZcmtNA+pqGnsx5dE59zDB4UPeaefKoeSaAZcKfAuY2QxzXtOcB7KcvzGuSkcluPhe bql4AlYOeQWRaa2yY7LtAhlspQbL17kHFAjgQNPgzP9rl897HuyO97X2e1fM77e4W9SX Zz3FXnW94yK9KlocjR2OygxU6yDidjwXXnDQdH2pfdvJChCL4F0jDelgBpc2c/5yZX9e uxUj2D5FoVEFFHdnjfHxCq4/V5IoNlr7Q5oEgqyxa5JVSmbNQfEofj1H1+PAiiaYE53B 7yMoW9e0wp2xDRwkIghVNda3qYJDC2Nly1tMh2EuwIoh6lCgVvTMjW/qxtPCsMl6kfb/ 7gDQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=oFePmKzJRyl7i9QiTObfIgvVuZgYNc4PTxqbdowwQtg=; b=C8CRhWWyNwiik59M6975a0e0dRbwha5f4u0yLHbIjKu4ayu1oWO7yyd5L2sMZ0teWb HyY3kn9BdbpoGc9CgqzTkBq6M446sKxymVfCLkZWI7sj5MdwoluQno/byfcRkcPqIWIm Zf77rnc6ZrMT/m9XcevN+E4MFTIN/bjX9S4K76MLno+GMTOKMAScIP3e9pSI50fU61yk To9C9yQcPl6GE9bvCtxBPUQQN7/uR2uNv1377On9r6kMAmOS1Cg3cbn8ukAozNN8lVwG aBGk1gXInT0kCdClRc7z0j6VJ8AeZrdnpwwMwCoNvBNcu0NL5ZNtb9oAm9Q3u4m+SL88 oHMQ== X-Gm-Message-State: ALKqPwerSpFd+dLdLNxXtfHxNhfMH33Ah125wcZUxswKNvEvgwXsV8GO h3QTf6rpXLb/8gW20Ro2F3x/cWUUJ8C2vgwu/G+7DQ== X-Google-Smtp-Source: AB8JxZr41T9jrs273UuiIBZOwJkXo7Zgi6b0ePYykU9exuoo2D9y5IfQDOwzG5elcrfKwLyWwhk7YPVk4dPR7eMPlj4= X-Received: by 2002:a24:b953:: with SMTP id k19-v6mr8328233iti.140.1526272712738; Sun, 13 May 2018 21:38:32 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.6.14 with HTTP; Sun, 13 May 2018 21:38:32 -0700 (PDT) In-Reply-To: References: From: Rajesh Mallah Date: Mon, 14 May 2018 10:08:32 +0530 Message-ID: Subject: Re: allowed order status changes To: user@ofbiz.apache.org Content-Type: multipart/alternative; boundary="000000000000df907f056c230e13" --000000000000df907f056c230e13 Content-Type: text/plain; charset="UTF-8" Thanks Aditya , OFbiz keeps exceeding my expectations on every respect ! I could figure out the other valid status changes too. I hope the status changes have a general applicability and can be borrowed in most use cases. select status_id,status_id_to, transition_name from ofbiz.status_valid_change where status_id ilike 'order%' order by status_id ; status_id | status_id_to | transition_name ------------------+------------------+----------------- ORDER_APPROVED | ORDER_SENT | Send Order ORDER_APPROVED | ORDER_HOLD | Hold Order ORDER_APPROVED | ORDER_CANCELLED | Cancel Order ORDER_APPROVED | ORDER_COMPLETED | Complete Order ORDER_APPROVED | ORDER_PROCESSING | Process Order ORDER_COMPLETED | ORDER_APPROVED | Approve Order ORDER_CREATED | ORDER_PROCESSING | Process Order ORDER_CREATED | ORDER_CANCELLED | Cancel Order ORDER_CREATED | ORDER_REJECTED | Reject Order ORDER_CREATED | ORDER_HOLD | Hold Order ORDER_CREATED | ORDER_APPROVED | Approve Order ORDER_HOLD | ORDER_CANCELLED | Cancel Order ORDER_HOLD | ORDER_PROCESSING | Process Order ORDER_HOLD | ORDER_APPROVED | Approve Order ORDER_PROCESSING | ORDER_HOLD | Hold Order ORDER_PROCESSING | ORDER_REJECTED | Reject Order ORDER_PROCESSING | ORDER_CANCELLED | Cancel Order ORDER_PROCESSING | ORDER_APPROVED | Approve Order ORDER_SENT | ORDER_COMPLETED | Order Completed ORDER_SENT | ORDER_CANCELLED | Order Cancelled (20 rows) On Mon, May 14, 2018 at 9:56 AM, Aditya Sharma < aditya.sharma@hotwaxsystems.com> wrote: > Hi Rajesh, > > In OFBiz valid status changes are handled using StatusValidChange entity. > You can refer applications/datamodel/data/seed/OrderSeedData.xml for the > valid status change data of order. > > Currently, ORDER_HOLD, ORDER_APPROVED, ORDER_REJECTED and ORDER_CANCELLED > are the valid status changes available from ORDER_PROCESSING > > HTH > Thanks and Regards, > > *Aditya Sharma* | Enterprise Software Engineer > HotWax Commerce by HotWax Systems > > > > > > On Mon, May 14, 2018 at 9:35 AM Rajesh Mallah > wrote: > > > Hi , > > > > I am not able to change status of a order , the service > *changeOrderStatus > > * > > says: > > > > > > Could not change order status; status is not a valid change.: > > [ORDER_PROCESSING] -> [ORDER_SENT]" > > > > > > As per the Sales Order Management Process Overview > > > > https://cwiki.apache.org/confluence/display/OFBIZ/ > Sales+Order+Management+ > > Process+Overview > > > > Order Status > > An Order Status is an easy visual indication to alert business about the > > orders requiring actions or not. > > > > An Order can have the following status: > > > > Created > > Approved > > Processing > > Sent > > Held > > Rejected > > Completed > > Cancelled > > > > > > Can any one pls guide what are the allowed status changes if current > status > > is ORDER_PROCESSING > > > > regds > > mallah > > > --000000000000df907f056c230e13--