Account


1   /*
2    ******************************************************************************
3    * The contents of this file are subject to the   Compiere License  Version 1.1
4    * ("License"); You may not use this file except in compliance with the License
5    * You may obtain a copy of the License at http://www.compiere.org/license.html
6    * Software distributed under the License is distributed on an  "AS IS"  basis,
7    * WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for
8    * the specific language governing rights and limitations under the License.
9    * The Original Code is                  Compiere  ERP & CRM  Business Solution
10   * The Initial Developer of the Original Code is Jorg Janke  and ComPiere, Inc.
11   * Portions created by Jorg Janke are Copyright (C) 1999-2001 Jorg Janke, parts
12   * created by ComPiere are Copyright (C) ComPiere, Inc.;   All Rights Reserved.
13   * Contributor(s): Openbravo SL
14   * Contributions are Copyright (C) 2001-2006 Openbravo S.L.
15   ******************************************************************************
16  */
17  package org.openbravo.erpCommon.ad_forms;
18  
19  import java.io.Serializable  ;
20  import org.openbravo.database.ConnectionProvider;
21  import org.apache.log4j.Logger ;
22  import javax.servlet.*;
23  import java.sql.Connection  ;
24  import java.util.ArrayList  ;
25  
26  
27  public final class Account implements Serializable   {
28    static Logger log4jAccount = Logger.getLogger(Account.class);
29  
30   public Account() {
31          C_ValidCombination_ID = "";
32          C_AcctSchema_ID = "";
33          AD_Client_ID = "";
34          AD_Org_ID = "";
35          Account_ID = "";
36          M_Product_ID = "";
37          C_BPartner_ID = "";
38          AD_OrgTrx_ID = "";
39          C_LocFrom_ID = "";
40          C_LocTo_ID = "";
41          C_SalesRegion_ID = "";
42          C_Project_ID = "";
43          C_Channel_ID = "";
44          C_Campaign_ID = "";
45          C_Activity_ID = "";
46          User1_ID = "";
47          User2_ID = "";
48          alias = "";
49          combination = "";
50          description = "";
51          active = "Y";
52          updatedBy = "";
53          fullyQualified = "F";
54          m_AcctType = ' ';
55          m_IsValid = null;
56          m_OldAccount_ID = "";
57          m_changed = "Y";
58      }
59  
60      public Account(ConnectionProvider conn, String   newC_ValidCombination_ID) throws ServletException {
61          C_ValidCombination_ID = "";
62          C_AcctSchema_ID = "";
63          AD_Client_ID = "";
64          AD_Org_ID = "";
65          Account_ID = "";
66          M_Product_ID = "";
67          C_BPartner_ID = "";
68          AD_OrgTrx_ID = "";
69          C_LocFrom_ID = "";
70          C_LocTo_ID = "";
71          C_SalesRegion_ID = "";
72          C_Project_ID = "";
73          C_Channel_ID = "";
74          C_Campaign_ID = "";
75          C_Activity_ID = "";
76          User1_ID = "";
77          User2_ID = "";
78          alias = "";
79          combination = "";
80          description = "";
81          active = "Y";
82          updatedBy = "";
83          fullyQualified = "N";
84          m_AcctType = ' ';
85          m_IsValid = null;
86          m_OldAccount_ID = "";
87          m_changed = "Y";
88          if(newC_ValidCombination_ID == "") {
89              return;
90          } else {
91              load(null, conn, newC_ValidCombination_ID);
92              return;
93          }
94      }
95  
96      public void load(Connection   conn1, ConnectionProvider conn, String   newC_ValidCombination_ID) throws ServletException {
97          AccountData [] data = null;
98          try {
99              log4jAccount.debug("C_ValidCombination_ID: " + C_ValidCombination_ID);
100             if (conn1 == null)
101             data = AccountData.select(conn, newC_ValidCombination_ID);
102             else
103               data = AccountData.selectConnection(conn1, conn, newC_ValidCombination_ID);
104             if(data.length > 0) {
105                 AD_Client_ID = data[0].adClientId;
106                 AD_Org_ID = data[0].adOrgId;
107                 active = data[0].isactive;
108                 updatedBy =data[0].updatedby;
109                 alias = data[0].alias;
110                 combination = data[0].combination;
111                 description = data[0].description;
112                 fullyQualified = data[0].isfullyqualified;
113                 C_AcctSchema_ID = data[0].cAcctschemaId;
114                 Account_ID = data[0].accountId;
115                 M_Product_ID = data[0].mProductId;
116                 C_BPartner_ID = data[0].cBpartnerId;
117                 AD_OrgTrx_ID = data[0].adOrgtrxId;
118                 C_LocFrom_ID = data[0].cLocfromId;
119                 C_LocTo_ID = data[0].cLoctoId;
120                 C_SalesRegion_ID = data[0].cSalesregionId;
121                 C_Project_ID = data[0].cProjectId;
122                 C_Campaign_ID = data[0].cCampaignId;
123                 C_Activity_ID = data[0].cActivityId;
124                 User1_ID = data[0].user1Id;
125                 User2_ID = data[0].user2Id;
126                 C_ValidCombination_ID = newC_ValidCombination_ID;
127                 m_changed = "N";
128             } else {
129                 log4jAccount.warn("Account.getAccount - " + newC_ValidCombination_ID + " not found");
130             }
131         } catch(ServletException e) {
132             C_ValidCombination_ID = "";
133             log4jAccount.warn("Account.load: " + e);
134             throw new ServletException(e);
135         }
136         log4jAccount.debug("C_ValidCombination_ID(fin): " + C_ValidCombination_ID);
137     }
138 
139     public static Account getDefault(ConnectionProvider conn, String   C_AcctSchema_ID, boolean optionalNull) {
140         AcctSchema acctSchema = new AcctSchema(conn, C_AcctSchema_ID);
141         return getDefault(acctSchema, optionalNull);
142     }
143 
144     public static Account getDefault(AcctSchema acctSchema, boolean optionalNull) {
145         Account vc = new Account();
146         vc.C_AcctSchema_ID = acctSchema.m_C_AcctSchema_ID;
147         ArrayList   list = acctSchema.m_elementList;
148         for(int i = 0; i < list.size(); i++) {
149             AcctSchemaElement ase = (AcctSchemaElement)list.get(i);
150             String   segmentType = ase.m_segmentType;
151             String   defaultValue = ase.m_defaultValue;
152             boolean setValue = ase.m_mandatory.equals("Y") || !ase.m_mandatory.equals("Y") && !optionalNull;
153             if(segmentType.equals("OO")) vc.AD_Org_ID = defaultValue;
154             else if(segmentType.equals("AC")) vc.Account_ID = defaultValue;
155             else if(segmentType.equals("BP") && setValue) vc.C_BPartner_ID = defaultValue;
156             else if(segmentType.equals("PR") && setValue) vc.M_Product_ID = defaultValue;
157             else if(segmentType.equals("AY") && setValue) vc.C_Activity_ID = defaultValue;
158             else if(segmentType.equals("LF") && setValue) vc.C_LocFrom_ID = defaultValue;
159             else if(segmentType.equals("LT") && setValue) vc.C_LocTo_ID = defaultValue;
160             else if(segmentType.equals("MC") && setValue) vc.C_Campaign_ID = defaultValue;
161             else if(segmentType.equals("OT") && setValue) vc.AD_OrgTrx_ID = defaultValue;
162             else if(segmentType.equals("PJ") && setValue) vc.C_Project_ID = defaultValue;
163             else if(segmentType.equals("SR") && setValue) vc.C_SalesRegion_ID = defaultValue;
164             else if(segmentType.equals("U1") && setValue) vc.User1_ID = defaultValue;
165             else if(segmentType.equals("U2") && setValue) vc.User2_ID = defaultValue;
166         }
167 
168         log4jAccount.debug("Account.getDefault - Client_ID=" + vc.AD_Client_ID + ", Org_ID=" + vc.AD_Org_ID + "AcctSchema_ID=" + vc.C_AcctSchema_ID + ", Account_ID=" + vc.Account_ID);
169         return vc;
170     }
171 
172     public static Account getAccount(ConnectionProvider conn, String   C_ValidCombination_ID) throws ServletException {
173         return new Account(conn, C_ValidCombination_ID);
174     }
175 
176     public boolean save(Connection   conn1, ConnectionProvider conn, String   newAD_Client_ID, String   newUpdatedBy) throws ServletException {
177         AD_Client_ID = newAD_Client_ID;
178         updatedBy = newUpdatedBy;
179         return save(conn1, conn);
180     }
181 
182     public boolean save(Connection   conn1, ConnectionProvider conn) throws ServletException {
183         log4jAccount.debug("Account.save - Client_ID=" + AD_Client_ID + ", Org_ID=" + AD_Org_ID + "AcctSchema_ID=" + C_AcctSchema_ID + ", Account_ID=" + Account_ID);
184         String   C_ValidCombination_ID = "";
185         boolean saved = false;
186         RespuestaCS respuestaCS;
187         try {
188             log4jAccount.debug("Account.save - Client_ID=" + AD_Client_ID + ", Org_ID=" + AD_Org_ID + "AcctSchema_ID=" + C_AcctSchema_ID + ", Account_ID=" + Account_ID + "alias : " + alias + ", updatedBy: " + updatedBy + ", M_Product_ID: " + M_Product_ID + ", C_BPartner_ID: " + C_BPartner_ID + ", AD_OrgTrx_ID: "  + AD_OrgTrx_ID + ", C_LocFrom_ID : " + C_LocFrom_ID + ", C_SalesRegion_ID : " + C_SalesRegion_ID + ", C_Project_ID : " + C_Project_ID + ", C_Project_ID: " + C_Project_ID + ", C_Campaign_ID: " + C_Campaign_ID + ", C_Activity_ID: " + C_Activity_ID + ", User1_ID: " + User1_ID + ", User1_ID: " + User1_ID);
189             respuestaCS = AccountData.GetValidAccountCombination(conn1, conn, AD_Client_ID, AD_Org_ID, C_AcctSchema_ID, Account_ID, "", "Y", alias, updatedBy, M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID, C_LocTo_ID, C_SalesRegion_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID, User1_ID, User2_ID);
190             C_ValidCombination_ID = respuestaCS.CValidCombinationId;
191             m_changed = "Y";
192             saved = true;
193         }
194         catch(ServletException e) {
195             log4jAccount.warn("Account.save: " + e);
196             m_changed = "N";
197         }
198         load(conn1, conn, C_ValidCombination_ID);
199         return saved;
200     }
201 
202     /**
203      * Is this a Balance Sheet Account
204      * @return boolean
205      */
206     public boolean isBalanceSheet(){
207         return (m_AcctType == 'A' || m_AcctType == 'L' || m_AcctType == 'O');
208     }   //  isBalanceSheet
209 
210     public String   getAD_Org_ID(){
211         return AD_Org_ID;
212     }
213 
214     public String   getAccount_ID(){
215         return Account_ID;
216     }
217 
218 
219 
220     public String   C_ValidCombination_ID;
221     public String   C_AcctSchema_ID;
222     public String   AD_Client_ID;
223     public String   AD_Org_ID;
224     public String   Account_ID;
225     public String   M_Product_ID;
226     public String   C_BPartner_ID;
227     public String   AD_OrgTrx_ID;
228     public String   C_LocFrom_ID;
229     public String   C_LocTo_ID;
230     public String   C_SalesRegion_ID;
231     public String   C_Project_ID;
232     public String   C_Channel_ID;
233     public String   C_Campaign_ID;
234     public String   C_Activity_ID;
235     public String   User1_ID;
236     public String   User2_ID;
237     public String   alias;
238     public String   combination;
239     public String   description;
240     public String   active;
241     public String   updatedBy;
242     public String   fullyQualified;
243     public char m_AcctType;
244     public Boolean   m_IsValid;
245     public String   m_OldAccount_ID;
246     public String   m_changed;
247 
248 }
249
A to Z: JavaDoc & Examples Daily Java News & Articles Open Source Projects Open Source Codes Free Computer Books Remove Frame
Popular Tags