int ArchiveMan::archivePos( int archDocId, KraftDoc *doc )
{
/*
mysql> describe archdocpos;
+-----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+----------------+
| archPosID | int(11) | NO | PRI | NULL | auto_increment |
| archDocID | int(11) | NO | MUL | | |
| ordNumber | int(11) | NO | | | |
| text | text | YES | | NULL | |
| amount | decimal(6,2) | YES | | NULL | |
| unit | varchar(64) | YES | | NULL | |
| price | decimal(6,2) | YES | | NULL | |
| vat | decimal(3,1) | YES | | 0.0 | |
+-----------+--------------+------+-----+---------+----------------+
*/
if( ! doc ) return -1;
QSqlTableModel model;
model.setTable("archdocpos");
QSqlRecord record = model.record();
int cnt = 0;
DocPositionList posList = doc->positions();
DocPositionListIterator it( posList );
kDebug() << "Archiving pos for " << archDocId << endl;
while ( it.hasNext() ) {
DocPosition *dp = static_cast<DocPosition*>( it.next() );
record.setValue( "archDocID", archDocId );
record.setValue( "ordNumber", 1+cnt /* dp->position() */ );
record.setValue( "kind", dp->attribute( DocPosition::Kind ) );
record.setValue( "text", dp->text() ); // expandItemText( dp ) );
record.setValue( "amount", dp->amount() );
record.setValue( "unit", dp->unit().einheit( dp->amount() ) );
record.setValue( "price", dp->unitPrice().toDouble() );
record.setValue( "overallPrice", dp->overallPrice().toDouble() );
record.setValue( "taxType", dp->taxTypeNumeric() );
if(!model.insertRecord(-1, record)) {
kDebug() << model.lastError();
}
dbID id = KraftDB::self()->getLastInsertID();
// kDebug() << "Inserted for id " << id.toString() << endl;
cnt++;
// save the attributes of the positions in the attributes
// table but with a new host type which reflects the arch state
AttributeMap attribs = dp->attributes();
attribs.setHost( "ArchPosition" );
attribs.save( id );
}
return cnt;
}
KraftDoc& KraftDoc::operator=( KraftDoc& origDoc )
{
if ( this == &origDoc ) return *this;
mLocale.reset(new QLocale());
DocPositionListIterator it( origDoc.mPositions );
while ( it.hasNext() ) {
DocPosition *dp = static_cast<DocPosition*>( it.next() );
DocPosition *newPos = new DocPosition();
*newPos = *dp;
newPos->setDbId( -1 );
mPositions.append( newPos );
// qDebug () << "Appending position " << dp->dbId().toString() << endl;
}
mPositions.setLocale( mLocale.data() );
_modified = origDoc._modified;
mIsNew = true;
mAddressUid = origDoc.mAddressUid;
mProjectLabel = origDoc.mProjectLabel;
mPredecessor = origDoc.mPredecessor;
mPredecessorDbId = origDoc.mPredecessorDbId;
mAddress = origDoc.mAddress;
mPreText = origDoc.mPreText;
mPostText = origDoc.mPostText;
mDocType = origDoc.mDocType;
mDocTypeChanged = false;
mSalut = origDoc.mSalut;
mGoodbye = origDoc.mGoodbye;
mIdent = origDoc.mIdent;
mWhiteboard = origDoc.mWhiteboard;
// Two qualifiers for the locale settings.
mCountry = origDoc.mCountry;
mLanguage = origDoc.mLanguage;
mDate = origDoc.mDate;
mLastModified = origDoc.mLastModified;
// setPositionList( origDoc.mPositions );
mRemovePositions = origDoc.mRemovePositions;
mSaver = nullptr;
// mDocID = origDoc.mDocID;
return *this;
}
void KraftDoc::setPositionList( DocPositionList newList )
{
mPositions.clear();
DocPositionListIterator it( newList );
while ( it.hasNext() ) {
DocPositionBase *dpb = it.next();
DocPosition *dp = static_cast<DocPosition*>( dpb );
DocPosition *newDp = createPosition( dp->type() );
*newDp = *dp;
}
mPositions.setLocale( newList.locale() );
}
bool TemplKatalogView::currentItemToDocPosition( DocPosition& pos )
{
TemplKatalogListView* listview = static_cast<TemplKatalogListView*>(getListView());
bool res = false;
if( listview )
{
FloskelTemplate *currTempl = static_cast<FloskelTemplate*> (listview->currentItemData());
if( currTempl ) {
// create a new position and offer it to the document manager
pos.setText( currTempl->getText() );
pos.setUnit( currTempl->unit() );
pos.setUnitPrice( currTempl->unitPrice() );
pos.setAmount( 1.0 );
res = true;
}
}
return res;
}
DocPosition TemplKatalogListView::itemToDocPosition( QTreeWidgetItem *it )
{
DocPosition pos;
if ( ! it ) {
it = currentItem();
}
if ( ! it ) return pos;
FloskelTemplate *flos = it->data(0, Qt::UserRole).value<FloskelTemplate*>();
if ( flos ) {
pos.setText( flos->getText() );
pos.setUnit( flos->unit() );
pos.setUnitPrice( flos->unitPrice() );
} else {
kDebug() << "Can not find a template for the item" << endl;
}
return pos;
}
DocPosition TemplKatalogListView::itemToDocPosition( QTreeWidgetItem *it )
{
DocPosition pos;
if ( ! it ) {
it = currentItem();
}
if ( ! it ) return pos;
FloskelTemplate *flos = static_cast<FloskelTemplate*>( m_dataDict[ it ] );
if ( flos ) {
pos.setText( flos->getText() );
pos.setUnit( flos->unit() );
pos.setUnitPrice( flos->unitPrice() );
} else {
// qDebug () << "Can not find a template for the item" << endl;
}
return pos;
}
void KraftViewRO::setup( DocGuardedPtr doc )
{
KraftViewBase::setup( doc );
if ( !doc ) return;
KLocale *locale = doc->locale();
if ( !locale ) locale = KGlobal::locale();
// do stuff like open a template and render values into it.
KStandardDirs stdDirs;
QString templFileName = QString( "kraftdoc_ro.trml" );
QString findFile = "kraft/reports/" + templFileName;
QString tmplFile = stdDirs.findResource( "data", findFile );
QByteArray kraftHome = qgetenv("KRAFT_HOME");
if( !kraftHome.isEmpty() ) {
QString file = QString( "%1/reports/kraftdoc_ro.trml").arg(QString::fromLocal8Bit(kraftHome));
QFileInfo fi(file);
if( fi.exists() && fi.isReadable() ) {
tmplFile = file;
}
}
if( tmplFile.isEmpty() ) {
kDebug() << "Could not find template to render ro view of document.";
return;
}
TextTemplate tmpl( tmplFile );
if( !tmpl.open() ) {
return;
}
tmpl.setValue( DOC_RO_TAG( "HEADLINE" ), doc->docType() + " " + doc->ident() );
tmpl.setValue( DOC_RO_TAG( "DATE" ), locale->formatDate( doc->date(), KLocale::ShortDate ) );
tmpl.setValue( DOC_RO_TAG( "DOC_TYPE" ), doc->docType() );
QString address = doc->address();
address.replace( '\n', "<br/>" );
tmpl.setValue( DOC_RO_TAG( "ADDRESS" ), address );
tmpl.setValue( DOC_RO_TAG( "DOCNO" ), doc->ident() );
tmpl.setValue( DOC_RO_TAG( "PRETEXT" ), doc->preText() );
tmpl.setValue( DOC_RO_TAG( "POSTTEXT" ), doc->postText() );
tmpl.setValue( DOC_RO_TAG( "SALUT" ), doc->salut() );
tmpl.setValue( DOC_RO_TAG( "GOODBYE" ), doc->goodbye() );
DocPositionList positions = doc->positions();
// check the tax settings: If all items have the same settings, its not individual.
bool individualTax = false;
int ttype = -1;
foreach( DocPositionBase *dp, positions ) {
if( ttype == -1 ) {
ttype = dp->taxType();
} else {
if( ttype != dp->taxType() ) { // different from previous one?
individualTax = true;
break;
}
}
}
int pos = 1;
int taxFreeCnt = 0;
int reducedTaxCnt = 0;
int fullTaxCnt = 0;
QString docType = doc->docType();
DocType dt(docType);
foreach( DocPositionBase *dpb, positions ) {
DocPosition *dp = static_cast<DocPosition*>(dpb);
tmpl.createDictionary( "ITEMS" );
tmpl.setValue( "ITEMS", "NUMBER", QString::number( pos++ ) );
tmpl.setValue( "ITEMS", "TEXT", dp->text() );
tmpl.setValue( "ITEMS", "AMOUNT", locale->formatNumber( dp->amount() ) );
tmpl.setValue( "ITEMS", "UNIT", dp->unit().einheit( dp->amount() ) );
double singlePrice = dp->unitPrice().toDouble();
if( dt.pricesVisible() ) {
tmpl.createSubDictionary("ITEMS", "PRICE_DISPLAY");
tmpl.setValue( "PRICE_DISPLAY", "SINGLE_PRICE", locale->formatMoney( singlePrice ) );
QString style( "positive" );
if ( singlePrice < 0 ) {
style = "negative";
}
tmpl.setValue( "PRICE_DISPLAY", "PRICE_STYLE", style );
tmpl.setValue( "PRICE_DISPLAY", "PRICE", locale->formatMoney( dp->overallPrice().toDouble() ) );
}
#if 0
QString taxType;
if( individualTax ) {
if( dp->taxType() == 1 ) {
taxFreeCnt++;
taxType = "TAX_FREE";
} else if( dp->taxType() == 2 ) {
taxType = "REDUCED_TAX";
reducedTaxCnt++;
} else {
// ATTENTION: Default for all non known tax types is full tax.
fullTaxCnt++;
taxType = "FULL_TAX";
}
}
#endif
}
void DocumentSaverDB::saveDocumentPositions( KraftDoc *doc )
{
DocPositionList posList = doc->positions();
// invert all pos numbers to avoid a unique violation
// FIXME: We need non-numeric ids
QSqlQuery upq;
QString queryStr = "UPDATE docposition SET ordNumber = -1 * ordNumber WHERE docID=";
queryStr += doc->docID().toString();
queryStr += " AND ordNumber > 0";
upq.prepare( queryStr );
upq.exec();
int ordNumber = 1;
QSqlTableModel model;
model.setTable("docposition");
model.setEditStrategy(QSqlTableModel::OnManualSubmit);
QVector<int> deleteIds;
DocPositionListIterator it( posList );
while( it.hasNext() ) {
DocPositionBase *dpb = it.next();
DocPosition *dp = static_cast<DocPosition*>(dpb);
QSqlRecord record ;
bool doInsert = true;
int posDbID = dp->dbId().toInt();
kDebug() << "Saving Position DB-Id: " << posDbID << endl;
if( dp->toDelete() ) {
kDebug() << "Delete item " << dp->dbId().toString() << endl;
// store the id to delete, rather than killing the model index.
// did that before here, which removed wrong items.
deleteIds << posDbID;
// delete all existing attributes no, which will not disturb the model index
dp->attributes().dbDeleteAll( dp->dbId() );
continue;
}
if( posDbID > -1 ) {
const QString selStr = QString("docID=%1 AND positionID=%2").arg( doc->docID().toInt() ).arg( posDbID );
// kDebug() << "Selecting with " << selStr << endl;
model.setFilter( selStr );
model.select();
if ( model.rowCount() > 0 ) {
if( ! dp->toDelete() )
record = model.record(0);
doInsert = false;
} else {
kError() << "ERR: Could not select document position record" << endl;
return;
}
} else {
// The record is new
record = model.record();
}
if( record.count() > 0 ) {
// kDebug() << "Updating position " << dp->position() << " is " << dp->text() << endl;
QString typeStr = PosTypePosition;
double price = dp->unitPrice().toDouble();
if ( dp->type() == DocPositionBase::ExtraDiscount ) {
typeStr = PosTypeExtraDiscount;
}
record.setValue( "docID", QVariant(doc->docID().toInt()));
record.setValue( "ordNumber", QVariant(ordNumber));
record.setValue( "text", QVariant(dp->text()));
record.setValue( "postype", QVariant(typeStr));
record.setValue( "amount", QVariant(dp->amount()));
int unitId = dp->unit().id();
record.setValue( "unit", QVariant(unitId));
record.setValue( "price", QVariant(price));
record.setValue( "taxType", QVariant(dp->taxType()));
ordNumber++; // FIXME
if( doInsert ) {
kDebug() << "Inserting!" << endl;
model.insertRecord(-1, record);
model.submitAll();
dp->setDbId( KraftDB::self()->getLastInsertID().toInt() );
} else {
kDebug() << "Updating!" << endl;
model.setRecord(0, record);
model.submitAll();
}
} else {
kDebug() << "ERR: No record object found!" << endl;
}
dp->attributes().save( dp->dbId() );
QSqlError err = model.lastError();
if( err.type() != QSqlError::NoError ) {
kDebug() << "SQL-ERR: " << err.text() << " in " << model.tableName() << endl;
}
}
model.submitAll();
/* remove the docpositions that were marked to be deleted */
if( deleteIds.count() ) {
QSqlQuery delQuery;
delQuery.prepare( "DELETE FROM docposition WHERE positionID=:id" );
foreach( int id, deleteIds ) {
kDebug() << "Deleting attribute id " << id;
delQuery.bindValue( ":id", id );
delQuery.exec();
}
