public tableListWord(tableList t, int[] indexField)
{
this.name = t.getName();
this.header = t.getHeader();
header = new string[indexField.Length]; // exception null or 0 element.
string[] htmp = t.getHeader();
// clone header
for (int i = 0; i < indexField.Length; i++)
{
if (indexField[i] < htmp.Length)
{
header[i] = htmp[indexField[i]];
}
else
{
header[i] = "";
}
}
// clone rows
for (int i = 0; i < t.getRowNumber(); i++)
{
object[] tmps1 = t.getRow(i);
object[] tmps2 = new object[indexField.Length]; // exception null or 0 element.
for (int j = 0; j < indexField.Length; j++)
{
if (indexField[j] < htmp.Length)
{
tmps2[j] = tmps1[indexField[j]];
}
else
{
tmps2[j] = "";
}
}
addRow(tmps2);
}
//this.circleIndex = t.circleIndex;
}
public object translate(string text, string mode, SetOfTableList tables)
{ /* please check undefined case */
//String ans = "";
/* mode case */
if (mode.Equals("s") || mode.Equals("p"))
{
/* get table name */
int i = 0;
int k = 3;
while (i < text.Length && k != 0)
{
if (text[i] == '@')
{
k--;
}
i++;
}
if (i == text.Length)
{
return(null);
}
string tableName = text.Substring(0, i - 1);
/* get key */
int j = i;
k = 1;
while (i < text.Length && k != 0)
{
if (text[i] == '@')
{
k--;
}
i++;
}
string key = text.Substring(j, i - j - 1); //fixed
/* get indexField */
/*j = i;
* k = 1;
* while (i < text.length() && k != 0) {
* if (text.charAt(i) == '@') {
* k--;
* }
* i++;
* }*/
int indexField = int.Parse(text.Substring(i)); /// may use tryParse
tableList table = tables.getTableList(tableName);
if (table != null)
{
if (mode.Equals("s"))
{
return(table.searchField(key, indexField));
}
else if (mode.Equals("p"))
{
return(table.searchPrefixField(key, indexField));
}
}
}
else if (mode.Equals("T")) //////////////////////////////////////////////////////////////////////////
{
/* get table name */
int i = 0;
int k = 3;
while (i < text.Length && k != 0)
{
if (text[i] == '@')
{
k--;
}
i++;
}
if (i == text.Length)
{
return(null);
}
string tableName = text.Substring(0, i - 1);
/* get a sequence of column */
int j = i;
k = 1;
int c = 0;
while (i < text.Length && k != 0)
{
if (text[i] == '@')
{
k--;
}
else if (text[i] == '-')
{
c++;
}
i++;
}
int[] col = new int[c + 1];
string[] header = new string[c + 1];
string[] colWidth = null;
string strtmp = text.Substring(j, i - j - 1); //fixed
c = 0;
k = 0;
for (int m = 0; m < strtmp.Length; m++)
{
if (strtmp[m] == '-')
{
col[c] = int.Parse(strtmp.Substring(k, m - k)); /// may use tryParse fixed//fixed
c++;
k = m + 1;
}
}
col[c] = int.Parse(strtmp.Substring(k)); /// may use tryParse
/* get header */
///////////////////////////////////
j = i;
k = 1;
while (i < text.Length && k != 0)
{
if (text[i] == '@')
{
k--;
}
i++;
}
if (k == 0) // add column width
{
strtmp = text.Substring(j, i - j - 1);
colWidth = new string[header.Length];
c = 0;
k = 0;
string strtmp2 = text.Substring(i);
for (int m = 0; m < strtmp2.Length; m++)
{
if (strtmp2[m] == '-')
{
colWidth[c] = strtmp2.Substring(k, m - k); //fixed
c++;
k = m + 1;
}
}
colWidth[c] = strtmp2.Substring(k);
}
else
{
strtmp = text.Substring(j);
}
///////////////////////////////////
c = 0;
k = 0;
//strtmp = text.Substring(i);
for (int m = 0; m < strtmp.Length; m++)
{
if (strtmp[m] == '-')
{
header[c] = strtmp.Substring(k, m - k); //fixed
c++;
k = m + 1;
}
}
header[c] = strtmp.Substring(k);
tableList table = tables.getTableList(tableName);
if (table != null)
{
tableListWord tlwtmp = new tableListWord(table, col); //// may be also add border
tlwtmp.addHeader(header);
if (colWidth != null)
{
tlwtmp.addColWidth(colWidth);
}
return(tlwtmp); ////////////////////////////////////// change
}
}
else if (mode.Equals("e"))
{
/* get table name */
int i = 0;
int k = 3;
while (i < text.Length && k != 0)
{
if (text[i] == '@')
{
k--;
}
i++;
}
if (i == text.Length)
{
return(null);
}
string tableName = text.Substring(0, i - 1);
/* get indexField */
int j = i;
k = 1;
while (i < text.Length && k != 0)
{
if (text[i] == '@')
{
k--;
}
i++;
}
//String acol = text.substring(j, i-1);
int indexField = int.Parse(text.Substring(j, i - j - 1)); /// may use tryParse//fixed
/* get a sequence of element */
j = i;
k = 1;
int c = 0;
while (i < text.Length && k != 0)
{
if (text[i] == '|')
{
if (i + 1 >= text.Length)
{
return(null);
}
else if (text[i + 1] == '|')
{
i++;
}
else if (text[i + 1] == '-')
{
i++;
}
else
{
return(null);
}
}
else if (text[i] == '@')
{
k--;
}
else if (text[i] == '-')
{
c++;
}
i++;
}
string[] element = new string[c + 1];
string[] value = new string[c + 2];
string strtmp = text.Substring(j, i - j - 1); //fixed
for (int z = 0; z <= c; z++)
{
element[z] = "";
value[z] = "";
}
value[c + 1] = "";
c = 0;
k = 0;
for (int m = 0; m < strtmp.Length; m++)
{
if (strtmp[m] == '|')
{
if (m + 1 >= strtmp.Length)
{
return(null);
}
else if (strtmp[m + 1] == '|')
{
element[c] += strtmp.Substring(k, m - k) + "|";
m++;
k = m + 1;
}
else if (strtmp[m + 1] == '-')
{
element[c] += strtmp.Substring(k, m - k) + "-";
m++;
k = m + 1;
}
else
{
return(null);
}
}
else if (strtmp[m] == '-')
{
element[c] += strtmp.Substring(k, m - k); //fixed
c++;
k = m + 1;
}
}
element[c] += strtmp.Substring(k);
/* get a sequence of value */
c = 0;
k = 0;
strtmp = text.Substring(i);
for (int m = 0; m < strtmp.Length; m++)
{
if (strtmp[m] == '|')
{
if (m + 1 >= strtmp.Length)
{
return(null);
}
else if (strtmp[m + 1] == '|')
{
value[c] += strtmp.Substring(k, m - k) + "|";
m++;
k = m + 1;
}
else if (strtmp[m + 1] == '-')
{
value[c] += strtmp.Substring(k, m - k) + "-";
m++;
k = m + 1;
}
else
{
return(null);
}
}
else if (strtmp[m] == '-')
{
value[c] += strtmp.Substring(k, m - k); //fixed
c++;
k = m + 1;
}
}
if (c == value.Length - 1)
{ // there is else case
value[c] += strtmp.Substring(k);
}
else if (c == value.Length - 2)
{ // non else case
value[c] += strtmp.Substring(k);
value[c + 1] = "";
}
tableList table = tables.getTableList(tableName);
if (table != null)
{
object[] tmps = table.getRow(0);
if (indexField < tmps.Length && tmps[indexField] is string)
{
for (j = 0; j < element.Length; j++)
{
if (((string)tmps[indexField]).Equals(element[j]))
{
return(value[j]);
}
}
return(value[j]);
}
}
return(null);
}
else if (mode.Equals("E"))
{
/* get table name */
int i = 0;
int k = 3;
while (i < text.Length && k != 0)
{
if (text[i] == '@')
{
k--;
}
i++;
}
if (i == text.Length)
{
return(null);
}
string tableName = text.Substring(0, i - 1);
/* get key indexField */
int j = i;
k = 1;
while (i < text.Length && k != 0)
{
if (text[i] == '@')
{
k--;
}
i++;
}
//String acol = text.substring(j, i-1);
int keyIndexField = int.Parse(text.Substring(j, i - j - 1)); /// may use tryParse//fixed
/* get key */
j = i;
k = 1;
while (i < text.Length && k != 0)
{
if (text[i] == '@')
{
k--;
}
i++;
}
string key = text.Substring(j, i - j - 1); //fixed
/* get indexField */
j = i;
k = 1;
while (i < text.Length && k != 0)
{
if (text[i] == '@')
{
k--;
}
i++;
}
int indexField = int.Parse(text.Substring(j, i - j - 1)); /// may use tryParse//fixed
/* get a sequence of element */
j = i;
k = 1;
int c = 0;
while (i < text.Length && k != 0)
{
if (text[i] == '|')
{
if (i + 1 >= text.Length)
{
return(null);
}
else if (text[i + 1] == '|')
{
i++;
}
else if (text[i + 1] == '-')
{
i++;
}
else
{
return(null);
}
}
else if (text[i] == '@')
{
k--;
}
else if (text[i] == '-')
{
c++;
}
i++;
}
string[] element = new string[c + 1];
string[] value = new string[c + 3];
string strtmp = text.Substring(j, i - j - 1); //fixed
for (int z = 0; z <= c; z++)
{
element[z] = "";
value[z] = "";
}
value[c + 1] = "";
c = 0;
k = 0;
for (int m = 0; m < strtmp.Length; m++)
{
if (strtmp[m] == '|')
{
if (m + 1 >= strtmp.Length)
{
return(null);
}
else if (strtmp[m + 1] == '|')
{
element[c] += strtmp.Substring(k, m - k) + "|";
m++;
k = m + 1;
}
else if (strtmp[m + 1] == '-')
{
element[c] += strtmp.Substring(k, m - k) + "-";
m++;
k = m + 1;
}
else
{
return(null);
}
}
else if (strtmp[m] == '-')
{
element[c] += strtmp.Substring(k, m - k); //fixed
c++;
k = m + 1;
}
}
element[c] += strtmp.Substring(k);
/* get a sequence of value */
c = 0;
k = 0;
strtmp = text.Substring(i);
for (int m = 0; m < strtmp.Length; m++)
{
if (strtmp[m] == '|')
{
if (m + 1 >= strtmp.Length)
{
return(null);
}
else if (strtmp[m + 1] == '|')
{
value[c] += strtmp.Substring(k, m - k) + "|";
m++;
k = m + 1;
}
else if (strtmp[m + 1] == '-')
{
value[c] += strtmp.Substring(k, m - k) + "-";
m++;
k = m + 1;
}
else
{
return(null);
}
}
else if (strtmp[m] == '-')
{
value[c] += strtmp.Substring(k, m - k); //fixed
c++;
k = m + 1;
}
}
if (c == value.Length - 1)
{ // there is else case
value[c] += strtmp.Substring(k);
}
else if (c == value.Length - 2)
{ // non else case
value[c] += strtmp.Substring(k);
value[c + 1] = "";
}
else if (c == value.Length - 3)
{ // non else case
value[c] += strtmp.Substring(k);
value[c + 1] = "";
value[c + 2] = "";
}
tableList table = tables.getTableList(tableName);
if (table != null)
{
strtmp = (string)table.searchField(keyIndexField, key, indexField);
if (strtmp != null)
{
for (j = 0; j < element.Length; j++)
{
if (strtmp.Equals(element[j]))
{
return(value[j]);
}
}
return(value[j]);
}
else
{
return(value[value.Length - 1]);
}
}
return(null);
}
else if (mode.Equals("c"))
{
/* get table name */
int i = 0;
int k = 3;
while (i < text.Length && k != 0)
{
if (text[i] == '@')
{
k--;
}
i++;
}
if (i == text.Length)
{
return(null);
}
string tableName = text.Substring(0, i - 1);
/* get indexField */
int indexField = int.Parse(text.Substring(i)); /// may use tryParse
tableList table = tables.getTableList(tableName);
if (table != null)
{
object[] tmps = table.getRow(0);
if (indexField < tmps.Length && tmps[indexField] is string)
{
return((string)tmps[indexField]);
}
}
}
else if (mode.Equals("x"))
{
/* get table name */
int i = 0;
int k = 3;
while (i < text.Length && k != 0)
{
if (text[i] == '@')
{
k--;
}
i++;
}
if (i == text.Length)
{
return(null);
}
string tableName = text.Substring(0, i - 1);
/* get a sequence of output */
string[] output = new string[2];
string strtmp = text.Substring(i);
int c = 0;
k = 0;
for (int m = 0; m < strtmp.Length; m++)
{
if (strtmp[m] == '-')
{
output[c] = strtmp.Substring(k, m - k); //fixed
c++;
k = m + 1;
}
}
output[c] = strtmp.Substring(k);
tableList table = tables.getTableList(tableName);
if (table == null)
{
return(output[0]);
}
else
{
return(output[1]);
}
}
else if (mode.Equals("X"))
{
/* get table name */
int i = 0;
int k = 3;
while (i < text.Length && k != 0)
{
if (text[i] == '@')
{
k--;
}
i++;
}
if (i == text.Length)
{
return(null);
}
string tableName = text.Substring(0, i - 1);
/* get key */
int j = i;
k = 1;
while (i < text.Length && k != 0)
{
if (text[i] == '@')
{
k--;
}
i++;
}
string key = text.Substring(j, i - j - 1); //fixed
/* get indexField */
j = i;
k = 1;
while (i < text.Length && k != 0)
{
if (text[i] == '@')
{
k--;
}
i++;
}
int indexField = int.Parse(text.Substring(j, i - j - 1)); /// may use tryParse//fixed
/* get a sequence of output */
string[] output = new string[2];
string strtmp = text.Substring(i);
int c = 0;
k = 0;
for (int m = 0; m < strtmp.Length; m++)
{
if (strtmp[m] == '-')
{
output[c] = strtmp.Substring(k, m - k); //fixed
c++;
k = m + 1;
}
}
output[c] = strtmp.Substring(k);
tableList table = tables.getTableList(tableName);
if (table != null)
{
object tmp = table.searchField(indexField, key, indexField);
if (tmp != null && tmp is string && key.Equals((string)tmp))
{
return(output[1]);
}
}
return(output[0]);
}
return(null);
}
