Article ID: 1924, created on Jun 14, 2007, last review on Oct 10, 2014

  • Applies to:
  • Business Automation

Question

An upgrade order is created in the status 'New' and requires manual approval for further processing. How to make upgrade orders be created in the status Open instead of New to avoid manual orders opening?

Resolution

Solution #1

Initial orders statuses are stored in the table "OrderOperation" in the database:

pba=> select "OperID", "OrderStatusID", "OrderTypeID" from "OrderOperation";
                   OperID                    | OrderStatusID | OrderTypeID
---------------------------------------------+---------------+-------------
 generateBill                                | NW            | BO
 generateZeroBill                            | NW            | ZB
 handleSubscriptionCancellation              | CL            |
 makeAutoRenewalOrder                        | OP            | RN
 makeCancellationChargeOrder                 | NW            | CF
 makeCancellationOrder                       | NW            | CL
 makeCustomerPlanDowngradeOrder              | NW            | DG
 makeCustomerResourceDowngradeOrder          | NW            | DG
 makePaymentOrderByProv                      | OP            | PO
 makePaymentOrder                            | OP            | PO
 makePlanDowngradeOrder                      | NW            | DG
 makeResourceDowngradeOrder_API              | NW            | DG
 makeResourceDowngradeOrder                  | NW            | DG
 makeRestoreOrder                            | NW            | RN
 makeSynchrOrder                             | NW            | RC
 PlaceMyOrder                                | OP            | SO
 PlaceOrder_Step2                            | NW            | SO
 resubmitPaymentOrder                        | OP            | PO
 StorePlaceOrderBankTransfer_ExistingAccount | OP            | SO
 StorePlaceOrderBankTransfer                 | OP            | SO
 StorePlaceOrderCheckCash_ExistingAccount    | OP            | SO
 StorePlaceOrderCheckCash                    | OP            | SO
 StorePlaceOrder_ExistingAccount             | OP            | SO
 StorePlaceOrder                             | OP            | SO
 makePlanUpgradeOrder                        | NW            | UG
 makeResourceUpgradeOrder                    | NW            | UG
 makeCustomerPlanUpgradeOrder                | OP            | UG
 makeCustomerResourceUpgradeOrder            | OP            | UG
 makeResourceUpgradeOrder_API                | OP            | UG
 generateNipBill                             | CP            | BN
 makeRenewalOrder                            | NW            | RN
(31 rows)

To let upgrade orders created from the provider's control panel be created in the status Open the following SQL query may be used:

pba=> update "OrderOperation" set "OrderStatusID" = 'OP' where "OperID" = 'makeResourceUpgradeOrder';

For the order created from the customer CP, the prefix Customer is present in the operation name, e.g. makeCustomerResourceUpgradeOrder is an operation for creating a resource upgrade order from the CCP.

Solution #2.

Leave initial status for upgrade orders as New and make transition from New to Open automatic. To do this please refer to the following article - How to make manually created orders open automatically

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF