|
1
17 package org.openbravo.erpCommon.ad_forms;
18
19 import java.io.Serializable  ;
20 import java.util.ArrayList ;
21 import org.openbravo.database.ConnectionProvider;
22 import org.apache.log4j.Logger ;
23 import javax.servlet.*;
24
25 public final class AcctSchemaElement implements Serializable {
26 static Logger log4jAcctSchemaElement = Logger.getLogger(AcctSchemaElement.class);
27
28 public AcctSchemaElement(String id, String seqNo, String name, String segmentType, String C_Element_ID, String defaultValue, String mandatory, String balanced) {
29 m_ID = id;
30 m_seqNo = seqNo;
31 m_name = name;
32 m_segmentType = segmentType;
33 m_C_Element_ID = C_Element_ID;
34 m_defaultValue = defaultValue;
35 m_mandatory = mandatory;
36 m_balanced = balanced;
37 }
38
39 public static ArrayList <Object > getAcctSchemaElementList(ConnectionProvider conn, String C_AcctSchema_ID) {
40 log4jAcctSchemaElement.debug( "AcctSchamaElement.getAcctSchemaElementList - " + C_AcctSchema_ID);
41 ArrayList <Object > list = new ArrayList <Object >();
42 AcctSchemaElementData [] data;
43 try {
44 data = AcctSchemaElementData.select(conn, C_AcctSchema_ID);
45 AcctSchemaElement e;
46 for(int i=0;i< data.length;i++) {
47 String id = data[i].cAcctschemaElementId;
48 String seqNo = data[i].seqno;
49 String name = data[i].name;
50 String segmentType = data[i].elementtype;
51 String C_Element_ID = data[i].cElementId;
52 String mandatory = data[i].ismandatory;
53 String balanced = data[i].isbalanced;
54 String defaultValue = "";
55 if(segmentType.equals("OO"))
56 defaultValue = data[i].orgId;
57 else
58 if(segmentType.equals("AC"))
59 defaultValue = data[i].cElementvalueId;
60 else
61 if(segmentType.equals("BP"))
62 defaultValue = data[i].cBpartnerId;
63 else
64 if(segmentType.equals("PR"))
65 defaultValue = data[i].mProductId;
66 else
67 if(segmentType.equals("AY"))
68 defaultValue = data[i].cActivityId;
69 else
70 if(segmentType.equals("LF"))
71 defaultValue = data[i].cLocationId;
72 else
73 if(segmentType.equals("LT"))
74 defaultValue = data[i].cLocationId;
75 else
76 if(segmentType.equals("MC"))
77 defaultValue = data[i].cCampaignId;
78 else
79 if(segmentType.equals("OT"))
80 defaultValue = data[i].orgId;
81 else
82 if(segmentType.equals("PJ"))
83 defaultValue = data[i].cProjectId;
84 else
85 if(segmentType.equals("SR"))
86 defaultValue = data[i].cSalesregionId;
87 else
88 if(segmentType.equals("U1"))
89 defaultValue = data[i].cElementvalueId;
90 else
91 if(segmentType.equals("U2"))
92 defaultValue = data[i].cElementvalueId;
93 log4jAcctSchemaElement.debug(seqNo + " " + name + " " + segmentType + "=" + defaultValue);
94 if(mandatory.equals("Y") && defaultValue == "")
95 log4jAcctSchemaElement.warn("AcctSchameElement.getAcctSchemaElementList - No default value for " + name);
96 e = new AcctSchemaElement(id, seqNo, name, segmentType, C_Element_ID, defaultValue, mandatory, balanced);
97 list.add(e);
98 }
99 }
100 catch(ServletException e) {
101 log4jAcctSchemaElement.warn("AcctSchemaElement.getAcctSchemaElementList", e);
102 }
103 return list;
104 }
105
106 public String m_ID;
107 public String m_seqNo;
108 public String m_name;
109 public String m_segmentType;
110 public String m_C_Element_ID;
111 public String m_defaultValue;
112 public String m_mandatory;
113 public String m_balanced = "N";
114 public String m_active;
115 public static final String SEGMENT_Org = "OO";
116 public static final String SEGMENT_Account = "AC";
117 public static final String SEGMENT_BPartner = "BP";
118 public static final String SEGMENT_Product = "PR";
119 public static final String SEGMENT_Activity = "AY";
120 public static final String SEGMENT_LocationFrom = "LF";
121 public static final String SEGMENT_LocationTo = "LT";
122 public static final String SEGMENT_Campaign = "MC";
123 public static final String SEGMENT_OrgTrx = "OT";
124 public static final String SEGMENT_Project = "PJ";
125 public static final String SEGMENT_SalesRegion = "SR";
126 public static final String SEGMENT_User1 = "U1";
127 public static final String SEGMENT_User2 = "U2";
128 }
129 |
Popular Tags |
Java API By Example, From Geeks To Geeks.