D:\CRM_Project\CRM_Metadata_Structure\NetBeamsICM_TestProject\ICM_DB_TestComponents\src\java\unstructured_data_idao\ExcelColumnMap2DAO.java
  1 /*
  2  * To change this license header, choose License Headers in Project Properties.
  3  * To change this template file, choose Tools | Templates
  4  * and open the template in the editor.
  5  */
  6 package unstructured_data_idao;
  7 
  8 /**
  9  * To build an intelligent system is kind of vague, but the best answer is how spreadsheets calculate values on the run
 10  * Our first attempt here is build an IDAO which mimic spreadsheets and performs calculation based on formulas.
 11  * The DOA help parse excel sheet vertically and will be part of the parsing code
 12  * @author sameldin
 13  */
 14 public class ExcelColumnMap2DAO {
 15   
 16     
 17         private int     totalCount                  = 0;
 18         private int     booleanCount                = 0;
 19         private int     blankCount                  = 0;
 20         private int     errorCount                  = 0;
 21         private int     formulaCount                = 0;
 22         private int     formulaSumCount             = 0;
 23         private int     formulaComplexCount         = 0;
 24         private int     formulaMultiplicationCount  = 0;
 25         private int     knownheaderCount            = 0;
 26         private int     labelCount                  = 0;
 27         private int     commentCount                = 0;
 28         private int     numericCount                = 0;
 29         private int     unknownheaderCount          = 0;
 30         private int     miscCount                   = 0;
 31     
 32     
 33     public ExcelColumnMap2DAO () {
 34         
 35     }
 36 
 37     /**
 38      * @return the booleanCount
 39      */
 40     public int getBooleanCount() {
 41         return booleanCount;
 42     }
 43 
 44     /**
 45      * @param booleanCount the booleanCount to set
 46      */
 47     public void setBooleanCount(int booleanCount) {
 48         this.booleanCount = booleanCount;
 49     }
 50 
 51     /**
 52      * @return the blankCount
 53      */
 54     public int getBlankCount() {
 55         return blankCount;
 56     }
 57 
 58     /**
 59      * @param blankCount the blankCount to set
 60      */
 61     public void setBlankCount(int blankCount) {
 62         this.blankCount = blankCount;
 63     }
 64 
 65     /**
 66      * @return the errorCount
 67      */
 68     public int getErrorCount() {
 69         return errorCount;
 70     }
 71 
 72     /**
 73      * @param errorCount the errorCount to set
 74      */
 75     public void setErrorCount(int errorCount) {
 76         this.errorCount = errorCount;
 77     }
 78 
 79     /**
 80      * @return the formulaCount
 81      */
 82     public int getFormulaCount() {
 83         return formulaCount;
 84     }
 85 
 86     /**
 87      * @param formulaCount the formulaCount to set
 88      */
 89     public void setFormulaCount(int formulaCount) {
 90         this.formulaCount = formulaCount;
 91     }
 92 
 93     /**
 94      * @return the formulaSumCount
 95      */
 96     public int getFormulaSumCount() {
 97         return formulaSumCount;
 98     }
 99 
100     /**
101      * @param formulaSumCount the formulaSumCount to set
102      */
103     public void setFormulaSumCount(int formulaSumCount) {
104         this.formulaSumCount = formulaSumCount;
105     }
106 
107     /**
108      * @return the formulaComplexCount
109      */
110     public int getFormulaComplexCount() {
111         return formulaComplexCount;
112     }
113 
114     /**
115      * @param formulaComplexCount the formulaComplexCount to set
116      */
117     public void setFormulaComplexCount(int formulaComplexCount) {
118         this.formulaComplexCount = formulaComplexCount;
119     }
120 
121     /**
122      * @return the formulaMultiplicationCount
123      */
124     public int getFormulaMultiplicationCount() {
125         return formulaMultiplicationCount;
126     }
127 
128     /**
129      * @param formulaMultiplicationCount the formulaMultiplicationCount to set
130      */
131     public void setFormulaMultiplicationCount(int formulaMultiplicationCount) {
132         this.formulaMultiplicationCount = formulaMultiplicationCount;
133     }
134 
135     /**
136      * @return the knownheaderCount
137      */
138     public int getKnownheaderCount() {
139         return knownheaderCount;
140     }
141 
142     /**
143      * @param knownheaderCount the knownheaderCount to set
144      */
145     public void setKnownheaderCount(int knownheaderCount) {
146         this.knownheaderCount = knownheaderCount;
147     }
148 
149     /**
150      * @return the labelCount
151      */
152     public int getLabelCount() {
153         return labelCount;
154     }
155 
156     /**
157      * @param labelCount the labelCount to set
158      */
159     public void setLabelCount(int labelCount) {
160         this.labelCount = labelCount;
161     }
162 
163     /**
164      * @return the commentCount
165      */
166     public int getCommentCount() {
167         return commentCount;
168     }
169 
170     /**
171      * @param commentCount the commentCount to set
172      */
173     public void setCommentCount(int commentCount) {
174         this.commentCount = commentCount;
175     }
176 
177     /**
178      * @return the numericCount
179      */
180     public int getNumericCount() {
181         return numericCount;
182     }
183 
184     /**
185      * @param numericCount the numericCount to set
186      */
187     public void setNumericCount(int numericCount) {
188         this.numericCount = numericCount;
189     }
190 
191     /**
192      * @return the unknownheaderCount
193      */
194     public int getUnknownheaderCount() {
195         return unknownheaderCount;
196     }
197 
198     /**
199      * @param unknownheaderCount the unknownheaderCount to set
200      */
201     public void setUnknownheaderCount(int unknownheaderCount) {
202         this.unknownheaderCount = unknownheaderCount;
203     }
204 
205     /**
206      * @return the miscCount
207      */
208     public int getMiscCount() {
209         return miscCount;
210     }
211 
212     /**
213      * @param miscCount the miscCount to set
214      */
215     public void setMiscCount(int miscCount) {
216         this.miscCount = miscCount;
217     }
218     /**
219      * @return the totalCount
220      */
221     public int getTotalCount() {
222         return totalCount;
223     }
224 
225     /**
226      * @param totalCount the totalCount to set
227      */
228     public void setTotalCount(int totalCount) {
229         this.totalCount = totalCount;
230     }    
231     
232     /**
233      * toString
234      */
235     public String toString()    {
236                    return("total Count                    " + getTotalCount()
237                            + "booleanCount                " + getBooleanCount()
238                            + "blankCount                  " + getBlankCount()
239                            + "errorCount                  " + getErrorCount()
240                            + "formulaCount                " + getFormulaCount()
241                            + "formulaSumCount             " + getFormulaSumCount()
242                            + "formulaComplexCount         " + getFormulaComplexCount()
243                            + "formulaMultiplicationCount  " + getFormulaMultiplicationCount()
244                            + "knownheaderCount            " + getKnownheaderCount()
245                            + "labelCount                  " + getLabelCount()
246                            + "commentCount                " + getCommentCount()
247                            + "numericCount                " + getNumericCount()
248                            + "unknownheaderCount          " + getUnknownheaderCount()
249                            + "miscCount                   " + getMiscCount()
250                         );
251     }
252 
253 
254 
255     
256 }
257