/*!
Deletes the given \a row from the currently active database table.
This is a low-level method that operates directly on the database
and should not be called directly. Use removeRow() or removeRows()
to delete values. The model will decide depending on its edit strategy
when to modify the database.
Returns true if the row was deleted; otherwise returns false.
\sa removeRow(), removeRows()
*/
bool QSqlTableModel::deleteRowFromTable(int row)
{
Q_D(QSqlTableModel);
emit beforeDelete(row);
QSqlRecord rec = d->primaryValues(row);
bool prepStatement = d->db.driver()->hasFeature(QSqlDriver::PreparedQueries);
QString stmt = d->db.driver()->sqlStatement(QSqlDriver::DeleteStatement,
d->tableName,
QSqlRecord(),
prepStatement);
QString where = d->db.driver()->sqlStatement(QSqlDriver::WhereStatement,
d->tableName,
rec,
prepStatement);
if (stmt.isEmpty() || where.isEmpty()) {
d->error = QSqlError(QLatin1String("Unable to delete row"), QString(),
QSqlError::StatementError);
return false;
}
stmt.append(QLatin1Char(' ')).append(where);
return d->exec(stmt, prepStatement, rec);
}
/*!
Deletes the given \a row from the currently active database table.
This is a low-level method that operates directly on the database
and should not be called directly. Use removeRow() or removeRows()
to delete values. The model will decide depending on its edit strategy
when to modify the database.
Returns true if the row was deleted; otherwise returns false.
\sa removeRow(), removeRows()
*/
bool QSqlTableModel::deleteRowFromTable(int row)
{
Q_D(QSqlTableModel);
emit beforeDelete(row);
const QSqlRecord whereValues = d->strategy == OnManualSubmit ? d->cache[row].primaryValues : d->primaryValues(row);
bool prepStatement = d->db.driver()->hasFeature(QSqlDriver::PreparedQueries);
QString stmt = d->db.driver()->sqlStatement(QSqlDriver::DeleteStatement,
d->tableName,
QSqlRecord(),
prepStatement);
QString where = d->db.driver()->sqlStatement(QSqlDriver::WhereStatement,
d->tableName,
whereValues,
prepStatement);
if (stmt.isEmpty() || where.isEmpty()) {
d->error = QSqlError(QLatin1String("Unable to delete row"), QString(),
QSqlError::StatementError);
return false;
}
stmt.append(QLatin1Char(' ')).append(where);
return d->exec(stmt, prepStatement, QSqlRecord() /* no new values */, whereValues);
}
bool Q3DataBrowser::deleteCurrent()
{
if (isReadOnly())
return false;
QSqlRecord* buf = d->frm.record();
Q3SqlCursor* cur = d->cur.cursor();
if (!buf || !cur)
return false;
writeFields();
int n = cur->at();
emit beforeDelete(buf);
int ar = cur->del();
if (ar) {
refresh();
updateBoundary();
cursorChanged(Q3SqlCursor::Delete);
if (!cur->seek(n))
last();
if (cur->isValid()) {
cur->editBuffer(true);
readFields();
} else {
clearValues();
}
return true;
} else {
if (!cur->isActive()) {
handleError(cur->lastError());
refresh();
updateBoundary();
}
}
return false;
}
/** @brief Constructor
*
* @param parent Parent
*/
basicGood::basicGood(QWidget *parent):pluginInterface(parent)
{
m_table = new simpleTable(this);
m_table->setTableName("basic_good");
m_table->setColumnWidth(0,300);
m_table->setSelectionBehavior(QAbstractItemView::SelectRows);
m_table->addRelation(1,"unit_of_measurement","name","name");
QStringList header;
header << tr("Name") << tr("UM") << tr("Average cost");
m_table->setHeader(header);
QToolBar *toolBar = m_table->getToolBar();
toolBar->setToolButtonStyle(Qt::ToolButtonTextUnderIcon);
QAction *m_refresh = new QAction(QIcon(":/refresh.svg"),
tr("Refresh Costs"),toolBar);
toolBar->addSeparator();
toolBar->addAction(m_refresh);
QGridLayout *layout = new QGridLayout(this);
layout->addWidget(toolBar);
layout->addWidget(m_table);
setLayout(layout);
connect(m_table,SIGNAL(beforeDelete()),this,SLOT(deleteFromStock()));
connect(m_refresh,SIGNAL(triggered()),this,SLOT(refreshAvgCost()));
}
DeclarativeWindow::DeclarativeWindow (const QUrl& url, QVariantMap params,
const QPoint& orig, ViewManager *viewMgr, ICoreProxy_ptr proxy, QWidget *parent)
: QDeclarativeView (parent)
{
new Util::AutoResizeMixin (orig, [viewMgr] () { return viewMgr->GetFreeCoords (); }, this);
if (!params.take ("keepOnFocusLeave").toBool ())
new Util::UnhoverDeleteMixin (this, SLOT (beforeDelete ()));
setStyleSheet ("background: transparent");
setWindowFlags (Qt::Tool | Qt::FramelessWindowHint);
setAttribute (Qt::WA_TranslucentBackground);
for (const auto& cand : Util::GetPathCandidates (Util::SysPath::QML, ""))
engine ()->addImportPath (cand);
rootContext ()->setContextProperty ("colorProxy",
new Util::ColorThemeProxy (proxy->GetColorThemeManager (), this));
for (const auto& key : params.keys ())
rootContext ()->setContextProperty (key, params [key]);
engine ()->addImageProvider ("ThemeIcons", new Util::ThemeImageProvider (proxy));
setSource (url);
connect (rootObject (),
SIGNAL (closeRequested ()),
this,
SLOT (deleteLater ()));
}
/*!
Deletes the given \a row from the currently active database table.
This is a low-level method that operates directly on the database
and should not be called directly. Use removeRow() or removeRows()
to delete values. The model will decide depending on its edit strategy
when to modify the database.
Returns \c true if the row was deleted; otherwise returns \c false.
\sa removeRow(), removeRows()
*/
bool QSqlTableModel::deleteRowFromTable(int row)
{
Q_D(QSqlTableModel);
emit beforeDelete(row);
const QSqlRecord whereValues = primaryValues(row);
const bool prepStatement = d->db.driver()->hasFeature(QSqlDriver::PreparedQueries);
const QString stmt = d->db.driver()->sqlStatement(QSqlDriver::DeleteStatement,
d->tableName,
QSqlRecord(),
prepStatement);
const QString where = d->db.driver()->sqlStatement(QSqlDriver::WhereStatement,
d->tableName,
whereValues,
prepStatement);
if (stmt.isEmpty() || where.isEmpty()) {
d->error = QSqlError(QLatin1String("Unable to delete row"), QString(),
QSqlError::StatementError);
return false;
}
return d->exec(Sql::concat(stmt, where), prepStatement, QSqlRecord() /* no new values */, whereValues);
}
