1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
| #include <QApplication>
#include <QWidget>
#include <QTableView>
#include <QSqlTableModel>
#include <QMimeData>
#include <QSqlQuery>
#include <QSqlRecord>
#include <QSortFilterProxyModel>
class Model: public QSqlTableModel
{
public:
Model(): QSqlTableModel(nullptr)
{}
Qt::ItemFlags flags(const QModelIndex& index) const
{
return Qt::ItemIsDragEnabled | Qt::ItemIsDropEnabled | QSqlTableModel::flags(index);
}
Qt::DropActions supportedDropActions() const
{
return Qt::CopyAction | Qt::MoveAction;
}
};
class ProxyModel: public QSortFilterProxyModel
{
QList<int> order;
public:
ProxyModel(): QSortFilterProxyModel(nullptr)
{
int i;
Model* model = new Model();
model->setTable("table1");
model->select();
model->setEditStrategy(QSqlTableModel::OnManualSubmit);
for (i = 0; i < model->rowCount(); ++i)
order.append(i);
setSourceModel(model);
}
bool lessThan(const QModelIndex &left, const QModelIndex &right) const
{
return order.indexOf(left.row(), 0) > order.indexOf(right.row(), 0);
}
QMimeData* mimeData(const QModelIndexList &indexes) const
{
QMimeData *mimeData = new QMimeData();
QByteArray encodedData;
QDataStream stream(&encodedData, QIODevice::WriteOnly);
stream << indexes[0].row();
mimeData->setData("application/x-qabstractitemmodeldatalist", encodedData);
return mimeData;
}
bool canDropMimeData(const QMimeData *data,
Qt::DropAction action, int row, int column, const QModelIndex &parent) const
{
Q_UNUSED(action)
Q_UNUSED(row)
Q_UNUSED(column)
Q_UNUSED(parent)
if (!data->hasFormat("application/x-qabstractitemmodeldatalist"))
return false;
return true;
}
bool dropMimeData(const QMimeData *data,
Qt::DropAction action, int row, int column, const QModelIndex &parent)
{
if (!canDropMimeData(data, action, row, column, parent))
return false;
if (action == Qt::IgnoreAction)
return true;
int r;
int dropRow;
if (row != -1)
dropRow = row;
else if (parent.isValid())
dropRow = parent.row();
else
dropRow = rowCount(QModelIndex());
QByteArray encodedData = data->data("application/x-qabstractitemmodeldatalist");
QDataStream stream(&encodedData, QIODevice::ReadOnly);
stream >> r;
if (dropRow > r)
--dropRow;
order.move(r, dropRow);
sort(0, Qt::DescendingOrder);
static_cast<Model*>(sourceModel())->select();
return true;
}
};
class Window: public QTableView
{
public:
Window() : QTableView(nullptr)
{
resize(500, 500);
QSqlDatabase db;
db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(":memory:");
db.open();
QSqlQuery query(db);
query.exec("CREATE TABLE table1 (id INT, name TEXT);");
query.exec("INSERT INTO table1 (id, name) VALUES (0, 'a');");
query.exec("INSERT INTO table1 (id, name) VALUES (1, 'b');");
query.exec("INSERT INTO table1 (id, name) VALUES (2, 'c');");
query.exec("INSERT INTO table1 (id, name) VALUES (3, 'd');");
query.exec("INSERT INTO table1 (id, name) VALUES (4, 'e');");
ProxyModel* model = new ProxyModel();
setModel(model);
setSortingEnabled(true);
setDragDropMode(QAbstractItemView::DragDropMode::InternalMove);
setDragEnabled(true);
setAcceptDrops(true);
setDropIndicatorShown(true);
viewport()->setAcceptDrops(true);
setDefaultDropAction(Qt::MoveAction);
setDragDropOverwriteMode(false);
setColumnHidden(0, true);
}
};
int main(int argc, char *argv[])
{
QApplication app(argc, argv);
Window window;
window.show();
return app.exec();
} |
(
Сообщение от kapbepucm
