void SalesModel::prepare(const QString &dateFilter, const QSqlDatabase &db)
{
this->db = db;
QString fullQuery = baseQuery;
fullQuery += " WHERE strftime('%Y-%m', sales_date) = ? ";
fullQuery += " limit 100;";
QSqlQuery q(db);
q.prepare(fullQuery);
q.addBindValue(dateFilter);
if(!q.exec()){
qWarning() <<"could not load sales report"<<q.lastError()<<q.lastQuery();
}
setQuery(q);
if (lastError().isValid()){
qWarning() << "error in query for model sales report"<<lastError();
}
QSqlQuery qupdate(db);
setUpdateQuery(qupdate);
}
static boolean qsmoothLocal(tree *tr, nodeptr p, int n)
{
nodeptr q;
if(n == 0)
return TRUE;
else
{
if (! qupdate(tr, p)) return FALSE; /* Adjust branch */
if (!isTip(p->number, tr->rdta->numsp))
{ /* Adjust descendants */
q = p->next;
while (q != p)
{
if (! qsmoothLocal(tr, q->back, n - 1)) return FALSE;
q = q->next;
}
newviewGeneric(tr, p);
}
return TRUE;
}
}
