void KImportDialog::setData(uint row, uint col, const QString &value)
{
QString val = value;
val.replace("\\n", "\n");
if(row >= mData.count())
{
mData.resize(row + 1);
}
QValueVector<QString> *rowVector = mData[ row ];
if(!rowVector)
{
rowVector = new QValueVector<QString>;
mData.insert(row, rowVector);
}
if(col >= rowVector->size())
{
rowVector->resize(col + 1);
}
KImportColumn *c = mColumnDict.find(col);
if(c)
rowVector->at(col) = c->preview(val, findFormat(col));
else
rowVector->at(col) = val;
}
QString Driver::defaultSQLTypeName(int id_t)
{
if (id_t>=Field::Null)
return "Null";
if (dflt_typeNames.isEmpty()) {
dflt_typeNames.resize(Field::LastType + 1);
dflt_typeNames[Field::InvalidType]="InvalidType";
dflt_typeNames[Field::Byte]="Byte";
dflt_typeNames[Field::ShortInteger]="ShortInteger";
dflt_typeNames[Field::Integer]="Integer";
dflt_typeNames[Field::BigInteger]="BigInteger";
dflt_typeNames[Field::Boolean]="Boolean";
dflt_typeNames[Field::Date]="Date";
dflt_typeNames[Field::DateTime]="DateTime";
dflt_typeNames[Field::Time]="Time";
dflt_typeNames[Field::Float]="Float";
dflt_typeNames[Field::Double]="Double";
dflt_typeNames[Field::Text]="Text";
dflt_typeNames[Field::LongText]="LongText";
dflt_typeNames[Field::BLOB]="BLOB";
}
return dflt_typeNames[id_t];
}
bool TableEditor::setTableArea( int bLine, int bCol, int eLine, int eCol, Parser *docParser )
{
const uint pInitialTableSize = 20;
m_bLine = bLine;
m_bCol = bCol;
m_eLine = eLine;
m_eCol = eCol;
m_createNodes = false; //don't create the cell and row content when adding a new cell/row
Node *node = docParser->nodeAt(bLine, bCol + 1);
Node *lastNode = docParser->nodeAt(eLine, eCol);
if (node)
kdDebug(24000) << "node = " << node->tag->name << endl;
if (lastNode)
kdDebug(24000) << "lastnode = " << lastNode->tag->name << endl;
if (!node || !lastNode)
return false;
m_write = node->tag->write();
m_dtd = node->tag->dtd();
if ( !QuantaCommon::closesTag(node->tag, lastNode->tag) ) {
return false;
}
int nCol, nRow, maxCol;
nCol = nRow = maxCol = 0;
bool countRows = false;
bool missingBody = false;
m_rowSpin = 0L;
m_colSpin = 0L;
m_dataTable = 0L;
QValueList<TableNode> tableRowTags;
QValueVector< QValueVector<TableNode> > mergeMatrix;
mergeMatrix.resize(pInitialTableSize);
for (uint i = 0; i < pInitialTableSize; i++)
mergeMatrix[i].resize(pInitialTableSize);
TableNode tableNode;
Node *n = node;
while (n != lastNode->nextSibling())
{
QString tagName = n->tag->name.lower();
if (tagName == "table")
{
if (m_table && m_dataTable && nRow > 0 && nCol > 0) //nested table!
{
int line, col;
n->tag->beginPos(line, col);
NestedTable table;
table.row = nRow -1;
table.col = nCol - 1;
table.bLine = line;
table.bCol = col;
if (n->next && QuantaCommon::closesTag(n->tag, n->next->tag)) {
n->next->tag->endPos(table.eLine, table.eCol);
table.node = n;
table.nestedData = m_write->text(table.bLine, table.bCol, table.eLine, table.eCol);
m_nestedTables.append(table);
m_dataTable->item(nRow -1, nCol -1)->setPixmap(QIconSet(UserIcon("quick_table")).pixmap());
m_dataTable->updateCell(nRow - 1, nCol - 1);
}
n = n->next;
} else
{
m_table = new Tag(*(n->tag));
newNum++;
}
}
else if (tagName == "thead")
{
headerCheckBox->setChecked(true);
countRows = true;
m_rowSpin = headerRowSpinBox;
m_colSpin = headerColSpinBox;
m_dataTable= headerTableData;
m_tableTags = m_tableHeaderTags;
m_tableRows = m_tableHeaderRows;
if (m_thead) { //there was already a <thead> tag in the area
nRow = m_dataTable->numRows();
} else {
m_thead = new Tag(*(n->tag));
newNum++;
}
}
else if (tagName == "/thead")
{
headerRowSpinBox->setValue(nRow);
headerColSpinBox->setValue(maxCol);
countRows = false;
nCol = nRow = maxCol = 0;
m_rowSpin = 0L;
m_colSpin = 0L;
m_dataTable = 0L;
}
else if (tagName == "tfoot")
{
footerCheckBox->setChecked(true);
m_rowSpin = footerRowSpinBox;
m_colSpin = footerColSpinBox;
m_tableTags = m_tableFooterTags;
m_tableRows = m_tableFooterRows;
m_dataTable = footerTableData;
countRows = true;
if (m_tfoot) { //there was already a <tfoot> tag in the area
nRow = m_dataTable->numRows();
} else {
m_tfoot = new Tag(*(n->tag));
newNum++;
}
}
else if (tagName == "/tfoot")
{
footerRowSpinBox->setValue(nRow);
footerColSpinBox->setValue(maxCol);
countRows = false;
nCol = nRow = maxCol = 0;
m_rowSpin = 0L;
m_colSpin = 0L;
m_dataTable = 0L;
}
else if (tagName == "tbody")
{
m_rowSpin = rowSpinBox;
m_colSpin = colSpinBox;
m_tableTags = m_tableDataTags;
m_tableRows = m_tableDataRows;
m_dataTable = tableData;
countRows = true;
m_tbody = new Tag(*(n->tag));
newNum++;
}
else if (tagName == "/tbody")
{
rowSpinBox->setValue(nRow);
colSpinBox->setValue(maxCol);
countRows = false;
nCol = nRow = maxCol = 0;
m_tableTags = 0L;
m_tableRows = 0L;
m_rowSpin = 0L;
m_colSpin = 0L;
m_dataTable = 0L;
}
else if (tagName == "tr")
{
if (!countRows)
{
missingBody = true;
m_rowSpin = rowSpinBox;
m_colSpin = colSpinBox;
m_tableTags = m_tableDataTags;
m_tableRows = m_tableDataRows;
m_dataTable = tableData;
countRows = true;
m_tbody = new Tag();
newNum++;
m_tbody->parse("<tbody>", m_write);
}
nRow++;
if ((uint)nRow >= mergeMatrix.size()) { // Check if there are enough rows in mergeMatriz
mergeMatrix.resize(2 * mergeMatrix.size());
for (uint i = mergeMatrix.size() / 2; i < mergeMatrix.size(); i++)
mergeMatrix[i].resize(mergeMatrix[0].size());
}
m_rowSpin->setValue(nRow);
nCol = 0;
tableNode.node = new Node(0L);
tableNode.node->tag = new Tag(*(n->tag));
newNum++;
tableNode.merged = false;
m_tableRows->append(tableNode);
}
else if (tagName == "/tr")
{
if (countRows)
{
maxCol = (nCol > maxCol) ? nCol : maxCol;
maxCol = (maxCol == 0) ? 1 : maxCol;
for (int col = nCol; col < maxCol; col++)
{
if (mergeMatrix[nRow - 1][col].node != 0L) {
if (m_colSpin->value() < col)
m_colSpin->setValue(col);
TableNode tableN = mergeMatrix[nRow - 1][col];
Node *n = tableN.node;
setCellText(m_dataTable, nRow - 1, col, i18n("Merged with (%1, %2).").arg(tableN.mergedRow + 1).arg(tableN.mergedCol + 1));
m_dataTable->item(nRow-1, col)->setEnabled(false);
tableNode.node = new Node(0L);
tableNode.node->tag = new Tag(*(n->tag));
configureCell(nRow-1, col, tableNode.node);
newNum++;
tableNode.merged = true;
tableNode.mergedRow = tableN.mergedRow;
tableNode.mergedCol = tableN.mergedCol;
tableRowTags.append(tableNode);
if ((uint)nCol >= mergeMatrix[0].size()) // Check if there are enough cols
for (uint i=0; i<mergeMatrix.size(); i++)
mergeMatrix[i].resize(2 * mergeMatrix[i].size());
} else
{
tableNode.node = new Node(0L);
newNum++;
tableNode.node->tag = new Tag();
tableNode.node->tag->setDtd(m_dtd);
tableNode.node->tag->parse("<td>", m_write);
tableNode.merged = false;
tableRowTags.append(tableNode);
}
}
if (!tableRowTags.isEmpty())
m_tableTags->append(tableRowTags);
tableRowTags.clear();
}
}
else if (tagName == "th" || tagName == "td")
{
if (countRows)
{
int col = nCol;
while (mergeMatrix[nRow - 1][col].node != 0L) {
if (m_colSpin->value() < col)
m_colSpin->setValue(col);
TableNode tableN = mergeMatrix[nRow - 1][col];
Node *n = tableN.node;
setCellText(m_dataTable, nRow - 1, col, i18n("Merged with (%1, %2).").arg(tableN.mergedRow + 1).arg(tableN.mergedCol + 1));
m_dataTable->item(nRow-1, col)->setEnabled(false);
tableNode.node = new Node(0L);
tableNode.node->tag = new Tag(*(n->tag));
configureCell(nRow-1, col, tableNode.node);
newNum++;
tableNode.merged = true;
tableNode.mergedRow = tableN.mergedRow;
tableNode.mergedCol = tableN.mergedCol;
tableRowTags.append(tableNode);
col++;
nCol++;
if ((uint)nCol >= mergeMatrix[0].size()) // Check if there are enough cols
for (uint i = 0; i < mergeMatrix.size(); i++)
mergeMatrix[i].resize(2 * mergeMatrix[i].size());
}
nCol++;
if (m_rowSpin && m_colSpin && m_dataTable)
{
m_rowSpin->setValue(nRow);
if (m_colSpin->value() < nCol)
m_colSpin->setValue(nCol);
setCellText(m_dataTable, nRow - 1, nCol - 1, tagContent(n));
tableNode.node = new Node(0L);
tableNode.node->tag = new Tag(*(n->tag));
configureCell(nRow-1, col, tableNode.node);
newNum++;
tableNode.merged = false;
tableRowTags.append(tableNode);
}
QString colspanValue = n->tag->attributeValue("colspan", true);
int colValue = 1;
int lastCol = nCol;
if (!colspanValue.isEmpty())
{
bool ok;
colValue = colspanValue.toInt(&ok, 10);
if (ok && colValue > 1)
{
nCol += (colValue - 1);
if (m_colSpin->value() < nCol)
m_colSpin->setValue(nCol);
for (int i = 0; i < colValue - 1; i++)
{
setCellText(m_dataTable, nRow - 1, lastCol + i, i18n("Merged with (%1, %2).").arg(nRow).arg(lastCol));
m_dataTable->item(nRow-1, lastCol + i)->setEnabled(false);
tableNode.node = new Node(0L);
tableNode.node->tag = new Tag(*(n->tag));
configureCell(nRow-1, col, tableNode.node);
newNum++;
tableNode.merged = true;
tableNode.mergedRow = nRow - 1;
tableNode.mergedCol = lastCol - 1;
tableRowTags.append(tableNode);
}
} else
colValue = 1;
}
QString rowspanValue = n->tag->attributeValue("rowspan", true);
if (!rowspanValue.isEmpty())
{
bool ok;
int rowValue = rowspanValue.toInt(&ok, 10);
if (ok && rowValue > 1)
{
lastCol--;
// Check if there are enough columns in mergeMatriz
if ((uint)(lastCol + colValue) >= mergeMatrix[0].size())
for (uint i = 0; i < mergeMatrix.size(); i++)
mergeMatrix[i].resize(2 * mergeMatrix[i].size());
// Check if there are enough rows in mergeMatriz
if ((uint)(nRow + rowValue) >= mergeMatrix.size()) {
mergeMatrix.resize(2 * mergeMatrix.size());
for (uint i = mergeMatrix.size() / 2; i < mergeMatrix.size(); i++)
mergeMatrix[i].resize(mergeMatrix[0].size());
}
for (int i = 0; i < rowValue - 1; i++)
for (int j = 0; j < colValue; j++) {
mergeMatrix[nRow + i][lastCol + j].mergedRow = nRow - 1;
mergeMatrix[nRow + i][lastCol + j].mergedCol = lastCol;
mergeMatrix[nRow + i][lastCol + j].node = n;
}
}
}
}
}
else if (tagName == "caption")
{
captionText->setText(tagContent(n));
} else if (tagName == "col" || tagName == "colgroup") {
m_colTags.append(n->tag);
}
n = n->nextSibling();
}
/* if (missingBody) { //Hm, why do we need it? I don't remember now. ;-)
rowSpinBox->setValue(nRow);
colSpinBox->setValue(maxCol);
} */
//by default the current page is the data handling page
m_tableTags = m_tableDataTags;
m_tableRows = m_tableDataRows;
m_dataTable = tableData;
m_rowSpin = rowSpinBox;
m_colSpin = colSpinBox;
//create the thead, tbody, tfoot tags if they were not present in the parsed area
if (!m_thead) {
m_thead = new Tag();
newNum++;
m_thead->parse("<thead>", m_write);
}
if (!m_tfoot) {
m_tfoot = new Tag();
newNum++;
m_tfoot->parse("<tfoot>", m_write);
}
m_createNodes = true; //enable cell/row creation
configureTable(tableData);
configureTable(headerTableData);
configureTable(footerTableData);
return true;
}
QValueVector<QColor> amaroK::readMood(const QString path)
{
debug() << "MakeMood: Reading mood file " << path << endl;
QString filebase = path;
QValueVector<QColor> theArray;
filebase.truncate(filebase.findRev('.'));
filebase += ".mood";
QString dotfilebase = filebase, homefilebase = filebase;
dotfilebase.insert(filebase.findRev('/') + 1, '.');
homefilebase.replace('/', ',');
homefilebase = ::locateLocal("data", "amarok/moods/" + homefilebase);
QFile mood;
if(QFile::exists(filebase)) mood.setName(filebase);
if(QFile::exists(dotfilebase)) mood.setName(dotfilebase);
if(QFile::exists(homefilebase)) mood.setName(homefilebase);
if(mood.name() != "" && mood.open(IO_ReadOnly))
{
int r, g, b, s = mood.size() / 3;
debug() << "ReadMood: File opened. Proceeding to read contents... s=" << s << endl;
QMemArray<int> huedist(360);
int total = 0, mx = 0;
for(int i = 0; i < 360; i++) huedist[i] = 0;
theArray.resize(s);
for(int i = 0; i < s; i++)
{
r = mood.getch();
g = mood.getch();
b = mood.getch();
theArray[i] = QColor(CLAMP(0, r, 255), CLAMP(0, g, 255), CLAMP(0, b, 255), QColor::Rgb);
int h, s, v;
theArray[i].getHsv(&h, &s, &v);
if(h < 0) h = 0; else h = h % 360;
huedist[h]++;
if(mx < huedist[h]) mx = huedist[h];
}
debug() << "ReadMood: File read. Maximum hue bin size = " << mx << endl;
if(AmarokConfig::makeMoodier())
{
debug() << "ReadMood: Making moodier!" << endl;
int threshold, rangeStart = 0, rangeDelta = 359, sat = 100, val = 100;
switch(AmarokConfig::alterMood())
{
// Angry
case 1: threshold = s / 360 * 9; rangeStart = 45; rangeDelta = -45; sat = 200; val = 100; break;
// Frozen
case 2: threshold = s / 360 * 1; rangeStart = 140; rangeDelta = 160; sat = 50; val = 100; break;
// Happy
default: threshold = s / 360 * 2; rangeStart = 0; rangeDelta = 359; sat = 150; val = 250;
}
debug() << "ReadMood: Appling filter t=" << threshold << ", rS=" << rangeStart << ", rD=" << rangeDelta << ", s=" << sat << "%, v=" << val << "%" << endl;
for(int i = 0; i < 360; i++) if(huedist[i] > threshold) total++;
debug() << "ReadMood: Total=" << total << endl;
if(total < 360 && total > 0)
{
for(int i = 0, n = 0; i < 360; i++)
huedist[i] = ((huedist[i] > threshold ? n++ : n) * rangeDelta / total + rangeStart) % 360;
for(uint i = 0; i < theArray.size(); i++)
{ int h, s, v;
theArray[i].getHsv(&h, &s, &v);
if(h < 0) h = 0; else h = h % 360;
if(h > 359) debug() << "ReadMood: Bad hue in array[" << i << "]: " << h << endl;
theArray[i].setHsv(CLAMP(0, huedist[h], 359), CLAMP(0, s * sat / 100, 255), CLAMP(0, v * val / 100, 255));
}
}
}
}
debug() << "ReadMood: All done." << endl;
return theArray;
}
