string JoystickMapper::serializeMap()
{
vector<string> value;
for (JoystickMapperMap::iterator i = usageIdMap.begin();
i != usageIdMap.end();
i++)
{
JoystickMapperItem item;
value.push_back(getItemLabel(i->first));
value.push_back(getItemLabel(i->second.usageId));
value.push_back(getString(i->second.sensitivity));
value.push_back(getString(i->second.reverse));
}
return strjoin(value, ',');
}
static void lookupRetroAliLabels(struct track *tg)
/* This converts the retro ids to labels. */
{
struct sqlConnection *conn = hAllocConn(database);
char *retroInfoTbl = trackDbRequiredSetting(tg->tdb, retroInfoTblSetting);
struct linkedFeatures *lf;
unsigned labelSet = getLabelTypes(tg);
for (lf = tg->items; lf != NULL; lf = lf->next)
getItemLabel(conn, retroInfoTbl, labelSet, lf);
hFreeConn(&conn);
}
static void lookupTransMapLabels(struct track *tg)
/* This converts the transMap ids to labels. */
{
struct sqlConnection *conn = hAllocConn(database);
char *transMapInfoTbl = trackDbRequiredSetting(tg->tdb, transMapInfoTblSetting);
char *transMapGeneTbl = trackDbSetting(tg->tdb, transMapGeneTblSetting);
struct sqlConnection *geneConn = NULL;
if (transMapGeneTbl != NULL)
geneConn = hAllocConnDbTbl(transMapGeneTbl, &transMapGeneTbl, database);
struct linkedFeatures *lf;
unsigned labelSet = getLabelTypes(tg);
for (lf = tg->items; lf != NULL; lf = lf->next)
getItemLabel(conn, transMapInfoTbl, geneConn, transMapGeneTbl, labelSet, lf);
hFreeConn(&geneConn);
hFreeConn(&conn);
}
void odkFormReader::extractFields(QDomNode child, QString tableName, TtableDef &parentTable, QString groupCode, QString xmlCode)
{
QDomElement item;
QDomNode node;
QDomNode childNode;
QString fieldCode;
QString fieldName;
QString fieldOutput;
QString fieldType;
QStringList ftypes;
QStringList ftsizes;
QString sameTable;
QString grpCode;
QString childName;
QString mselptable;
QString repeatXMLCode;
QString fieldXMLCode;
TtableDef table;
TtableDef tempTable;
int pos;
tableIndex++;
int tindex;
tindex = tableIndex;
bool fieldinmselt;
TfieldDef fsurveyID;
TfieldDef foriginID;
if ((tableName.toLower() != parentTable.name.toLower()) || (parentTable.fields.count() == 0)) //We are not processing a group
{
//qDebug() << "Table: " + tableName.toLower() + " Parent: " + parentTable.name.toLower() + ". Fields: " + QString::number(parentTable.fields.count());
if (tableName.toLower() == mTable.toLower())
{
table.name = tableName;
table.desc = "Main survey Table - Change this description";
table.xmlCode = xmlCode;
table.parentTable = "NULL";
/*fsurveyID.name = "surveyid";
fsurveyID.desc = "Survey ID (UUID)";
fsurveyID.type = "varchar";
fsurveyID.size = 80;
fsurveyID.decSize = 0;
fsurveyID.section = "main";
fsurveyID.rField = "";
fsurveyID.rTable = "";
fsurveyID.key = false;
fsurveyID.xmlCode = "NONE";
table.fields.append(fsurveyID);
foriginID.name = "originid";
foriginID.desc = "Origin ID: formhub or aggregate";
foriginID.type = "varchar";
foriginID.size = 15;
foriginID.decSize = 0;
foriginID.section = "main";
foriginID.rField = "";
foriginID.rTable = "";
foriginID.key = false;
foriginID.xmlCode = "NONE";
table.fields.append(foriginID);*/
}
else
{
table.name = tableName;
table.xmlCode = xmlCode;
table.parentTable = parentTable.name;
table.desc = "Repeat " + tableName + " - Change this description";
/*
//Add the key fields of the parent
for (pos = 0; pos <= parentTable.fields.count()-1;pos++)
{
if (parentTable.fields[pos].key == true)
{
TfieldDef parentKeyField;
parentKeyField.name = parentTable.fields[pos].name;
parentKeyField.desc = parentTable.fields[pos].desc;
parentKeyField.key = true;
parentKeyField.type = parentTable.fields[pos].type;
parentKeyField.size = parentTable.fields[pos].size;
parentKeyField.decSize = parentTable.fields[pos].decSize;
parentKeyField.rTable = parentTable.name;
parentKeyField.rField = parentTable.fields[pos].name;
parentKeyField.xmlCode = "NONE";
table.fields.append(parentKeyField);
}
}*/
/*TfieldDef KeyField;
KeyField.name = tableName + "_rowid";
KeyField.section = "main";
KeyField.desc = "Unique row ID";
KeyField.key = true;
KeyField.type = "int";
KeyField.size = 3;
KeyField.decSize = 0;
KeyField.rTable = "";
KeyField.rField = "";
KeyField.xmlCode = "NONE";
table.fields.append(KeyField);*/
}
}
node = child;
while (!node.isNull())
{
item = node.toElement();
if ((item.tagName() == "input") || (item.tagName() == "select1") || (item.tagName() == "select"))
{
childNode = item.firstChild();
fieldCode = item.attribute("ref","CodeNotFound!");
fieldName = getItemLabel(childNode);
fieldOutput = getItemOutput(childNode);
if (fieldOutput != "NONE")
{
if (getFieldType(fieldOutput) != "Unknown")
fieldCode = fieldOutput;
}
fieldName = fieldName.replace("\r","");
fieldName = fieldName.replace("\n","");
fieldName = fieldName.replace("\t","");
fieldName = fieldName.replace("'","");
fieldName = fieldName.replace(";","");
fieldType = getFieldType(fieldCode);
fieldXMLCode = fieldCode.replace("/" + surveyID + "/","");
pos = fieldCode.lastIndexOf("/");
fieldCode = fieldCode.right(fieldCode.length()-pos-1);
fieldCode = fieldCode.replace("-","_");
fieldCode = fieldCode.replace("'","");
fieldCode = fieldCode.replace(";","");
//qDebug() << fieldCode;
//qDebug() << MainField.toLower();
if (fieldType != "READONLY")
{
TfieldDef field;
field.name = fieldCode;
field.xmlCode = fieldXMLCode;
field.section = groupCode;
field.desc = fieldName;
//if (fieldCode.toLower() == MainField.toLower())
// field.key = true;
//else
field.key = false;
ftypes = fieldType.split("|",QString::SkipEmptyParts);
if (ftypes.count() > 1)
{
field.type = ftypes[0];
ftsizes = ftypes[1].split(",",QString::SkipEmptyParts);
if (ftsizes.count() > 1)
{
field.size = ftsizes[0].toInt();
field.decSize = ftsizes[1].toInt();
}
else
{
field.size = ftsizes[0].toInt();
field.decSize = 0;
}
}
else
field.type = fieldType;
field.rTable = "";
field.rField = "";
fieldinmselt = false;
if (item.tagName() == "select1")
{
if ((isLookUpYesNo(getSelectValues(item)) == false) || ((isLookUpYesNo(getSelectValues(item)) == true) && (ignoreYesNo == false)))
{
TtableDef lktable;
lktable.lkpValues.append(getSelectValues(item));
if (areValuesStrings(lktable.lkpValues))
{
//qDebug() << lktable.name;
field.type = "varchar";
field.size = getMaxValueLength(lktable.lkpValues);
field.decSize = 0;
}
lktable.name = "lkp" + fieldCode;
lktable.desc = "Lookup table [" + fieldName + "]";
lktable.pos = -1;
lktable.islookup = true;
TfieldDef lkpCode;
lkpCode.name = fieldCode + "_cod";
lkpCode.desc = "Code";
lkpCode.key = true;
lkpCode.type = field.type;
lkpCode.size = field.size;
lkpCode.decSize = field.decSize;
lktable.fields.append(lkpCode);
TfieldDef lkpDesc;
lkpDesc.name = fieldCode + "_des";
lkpDesc.desc = "Description";
lkpDesc.key = false;
lkpDesc.type = "varchar";
lkpDesc.size = 255;
lkpDesc.decSize = 0;
lktable.fields.append(lkpDesc);
sameTable = isLkpDuplicated(lktable);
if (sameTable.isEmpty())
{
tables.append(lktable);
field.rTable = lktable.name;
field.rField = fieldCode + "_cod";
}
else
{
field.rTable = sameTable;
field.rField = getKeyField(sameTable);
//qDebug() << lktable.name + " = " + sameTable + ". " + sameTable + " used instead";
}
}
}
if (item.tagName() == "select")
{
//We change the field type to be varchar(255) and add it to the main table so stores values separated by space. The by a separate process we split the values in the child tables.
field.type = "varchar";
field.size = 255;
field.decSize = 0;
if (tableName.toLower() != parentTable.name.toLower()) //If we are not processing a group
table.fields.append(field);
else
parentTable.fields.append(field); //If we are processing a group then the field goes to the parent
//Then we change it back to a select type
field.type = "int";
field.size = 9;
//*********************Creates a new table to store the multiselect in different rows**************************
TtableDef mselTable;
if (tableName.toLower() != parentTable.name.toLower()) //If we are not processing a group
{
mselptable = table.name;
tempTable = table;
}
else
{
mselptable = parentTable.name;
tempTable = parentTable;
}
mselTable.name = mselptable + "_msel_" + fieldCode;
mselTable.desc = "Table for multiple select of field " + fieldCode;
mselTable.islookup = false;
tableIndex++;
mselTable.pos = tableIndex;
mselTable.xmlCode = "NONE";
//Move the keys to the multi select table
for (pos = 0; pos <= tempTable.fields.count()-1;pos++)
{
if (tempTable.fields[pos].key == true)
{
TfieldDef mselKeyField;
mselKeyField.name = tempTable.fields[pos].name;
mselKeyField.desc = tempTable.fields[pos].desc;
mselKeyField.key = true;
mselKeyField.type = tempTable.fields[pos].type;
mselKeyField.size = tempTable.fields[pos].size;
mselKeyField.decSize = tempTable.fields[pos].decSize;
mselKeyField.rTable = tempTable.name;
mselKeyField.rField = tempTable.fields[pos].name;
mselTable.fields.append(mselKeyField);
}
}
//************************* Creates the lookup table *********************************
if ((isLookUpYesNo(getSelectValues(item)) == false) || ((isLookUpYesNo(getSelectValues(item)) == true) && (ignoreYesNo == false)))
{
TtableDef lktable;
lktable.lkpValues.append(getSelectValues(item));
if (areValuesStrings(lktable.lkpValues))
{
//qDebug() << lktable.name;
field.type = "varchar";
field.size = getMaxValueLength(lktable.lkpValues);
field.decSize = 0;
}
lktable.name = "lkp" + fieldCode;
lktable.desc = "Lookup table [" + fieldName + "]";
lktable.pos = -1;
lktable.islookup = true;
TfieldDef lkpCode;
lkpCode.name = fieldCode + "_cod";
lkpCode.desc = "Code";
lkpCode.key = true;
lkpCode.type = field.type;
lkpCode.size = field.size;
lkpCode.decSize = field.decSize;
lktable.fields.append(lkpCode);
TfieldDef lkpDesc;
lkpDesc.name = fieldCode + "_des";
lkpDesc.desc = "Description";
lkpDesc.key = false;
lkpDesc.type = "varchar";
lkpDesc.size = 255;
lkpDesc.decSize = 0;
lktable.fields.append(lkpDesc);
sameTable = isLkpDuplicated(lktable);
if (sameTable.isEmpty())
{
tables.append(lktable);
field.rTable = lktable.name;
field.rField = fieldCode + "_cod";
}
else
{
field.rTable = sameTable;
field.rField = getKeyField(sameTable);
//qDebug() << lktable.name + " = " + sameTable + ". " + sameTable + " used instead";
}
}
fieldinmselt = true;
field.key = true;
mselTable.fields.append(field);
tables.append(mselTable);
}
if (fieldinmselt == false)
{
if (tableName.toLower() != parentTable.name.toLower()) //If we are not processing a group
table.fields.append(field);
else
parentTable.fields.append(field); //If we are processing a group then the field goes to the parent
}
}
}
else
{
if (item.tagName() == "group")
{
grpCode = item.attribute("ref","/GRPNotKnown");
pos = grpCode.lastIndexOf("/");
grpCode = grpCode.right(grpCode.length()-pos-1);
grpCode = grpCode;
//qDebug() << "Group:" + item.attribute("ref","/GRPNotKnown");
//qDebug() << "Group table:" + table.name;
if (!table.name.isEmpty())
extractFields(item.firstChild(),table.name,table,grpCode,xmlCode); //Recursive call for group
else
extractFields(item.firstChild(),parentTable.name,parentTable,grpCode,xmlCode); //Recursive call for group
}
if (item.tagName() == "repeat")
{
childName = item.attribute("nodeset","unknowrepeat");
repeatXMLCode = childName.replace("/" + surveyID + "/","");
pos = childName.lastIndexOf("/");
childName = childName.right(childName.length()-pos-1);
if (!table.name.isEmpty())
extractFields(item.firstChild(),childName,table,"main",repeatXMLCode); //Recursive call for repeat
else
extractFields(item.firstChild(),childName,parentTable,"main",repeatXMLCode); //Recursive call for repeat
}
}
node = node.nextSibling();
}
if (tableName.toLower() != parentTable.name.toLower())
{
table.pos = tindex;
table.islookup = false;
tables.append(table);
}
}
string JoystickMapper::getMap(OEInt usageId)
{
return getItemLabel(usageIdMap[usageId].usageId);
}
