WebSVN - OpenInventory - Blame - Rev 116 - /trunk/DBViewer/database.cpp

Rev	Author	Line No.	Line
111	pingvin	1	#include "mainwindow.h"
		2	#include "ui_mainwindow.h"
		3
		4
		5
		6	void MainWindow::getDatabaseData(){
		7	int list_count;
		8
		9	if (rootItems.isEmpty()) return;
		10
		11	list_count = rootItems.count();
		12
		13	for (int i=0; i < list_count; i++){
		14
		15	buildTree(rootItems.at(i));
		16
		17	}
		18
		19	}
		20
		21	void MainWindow::buildTree(QTreeWidgetItem * model_item){
112	pingvin	22
		23
		24
		25
111	pingvin	26	QString model_name;
		27	QString rootClassID;
		28	QString rootClassInctance;
113	pingvin	29	QFont font;
111	pingvin	30
		31	QTreeWidgetItem * item;
		32	model_name = model_item->text(0);
		33	if (model_item->checkState(0) == false) return;
113	pingvin	34
114	pingvin	35	//font.setWeight(20);
113	pingvin	36	font.setItalic(true);
111	pingvin	37	item = new QTreeWidgetItem (ui->treeWidget_2);
113	pingvin	38	item->setFont(0, font);
111	pingvin	39	item->setText(0, model_name);
114	pingvin	40	item->setTextColor(0, Qt::darkGreen);
113	pingvin	41
		42
111	pingvin	43	rootClassID = model_item->child(0)->text(1);
		44	rootClassInctance = getClassInctance(rootClassID);
		45	if (model_item->child(0)->checkState(0)) // �� (�� ), ��
		46	{
113	pingvin	47	///// QTreeWidgetItem * item_tmp;
		48	///// item_tmp = new QTreeWidgetItem(item); // � ��, �� , ��
		49	///// item_tmp->setText(0, model_item->child(0)->text(0)); // � ��
111	pingvin	50
112	pingvin	51	//showClassObjects(item_tmp, model_item->child(0)); // � ��
		52
113	pingvin	53	///// showObjects(item_tmp, model_item->child(0), tr(""));
		54	showObjects(item, model_item->child(0), tr(""));
111	pingvin	55	}
112	pingvin	56
		57
		58	/*****************************************************/
		59
		60
111	pingvin	61	}
		62
		63
		64	// �� - ��
		65	QString MainWindow::getClassInctance(QString class_id){
		66	QSqlQuery q;
		67	QString sql_str;
		68	QString result;
		69	QString classInctance;
		70	int field_inctance;
		71	bool ok;
		72	sql_str = tr("select * "
		73	" from ListOfClasses where ListOfClasses.ID = '" //�� , ��
		74	);
		75	sql_str.append(class_id);
		76	sql_str.append(tr("'"));
		77	q.prepare(sql_str);
		78
		79	ok = q.exec();
		80	if (!ok) {
		81	QMessageBox::critical( // �� .
		82	this, // �� .
		83	QObject::tr("Database Error"), // ��.
		84	q.lastError().text()); // �� .
		85	return result;
		86	}
		87	field_inctance = q.record().indexOf(tr("TableWhithInstance"));
		88	while(q.next()){
		89
		90	classInctance = q.value(field_inctance).toString();
		91	result.append(classInctance);
		92	}
		93
		94	return result;
		95
		96	}
		97
		98	void MainWindow::showClassObjects(QTreeWidgetItem * parent_item, QTreeWidgetItem * model_item){
		99	QString classID; // ��
		100	QString inctance; // �� , ��
		101	QSqlQuery q;
		102	QString sql_str;
		103	QString str_tmp;
		104	bool ok;
		105	int field_ID;
		106	int i;
		107	classID = model_item->text(1);
		108	inctance = getClassInctance(classID);
		109
		110	sql_str = tr("select * "
		111	" from " //�� - ��
		112	);
		113	sql_str.append(inctance);
		114	q.prepare(sql_str);
		115
		116	ok = q.exec();
		117	if (!ok) {
		118	QMessageBox::critical( // �� .
		119	this, // �� .
		120	QObject::tr("Database Error"), // ��.
		121	q.lastError().text()); // �� .
		122	return;
		123	}
		124
		125	field_ID = q.record().indexOf(tr("ID"));
		126
		127
		128	while(q.next()){
		129	if (q.record().count() > 1)
		130	{
		131	QString value_tmp;
		132	QString ID_tmp;
		133	QTreeWidgetItem * itm;
		134	ID_tmp = q.value(field_ID).toString(); // ��
		135	value_tmp = q.value(1).toString(); // �� (�� )
		136	itm = new QTreeWidgetItem(parent_item); // �� , ��
		137	itm->setText(0, value_tmp);
		138	for (int i; i < model_item->childCount(); i++) // ��, ��
		139	{
		140	QTreeWidgetItem * model_item_tmp; // ��
		141	model_item_tmp = model_item->child(i); // ��
		142	MainWindow::showObjectChildrens(ID_tmp, itm, model_item_tmp);
		143
		144	}
		145	}
		146
		147	}
		148
		149
		150	i++;
		151	}
		152
		153
		154
		155	void MainWindow::showObjectChildrens(QString object_ID, QTreeWidgetItem * object_item, QTreeWidgetItem * model_item){ // ��
		156
		157	QString classID; // ��
		158
		159	QString inctance; // �� , ��
		160	QSqlQuery q;
		161	QString sql_str;
		162	QString str_tmp;
		163	bool ok;
		164	classID = model_item->text(1);
		165	inctance = getClassInctance(classID);
		166
		167	sql_str = tr("select * "
		168	" from '" //�� - ��
		169	);
		170	sql_str.append(inctance);
		171	sql_str.append(tr("' where "));
		172
		173
		174	q.prepare(sql_str);
		175
		176	ok = q.exec();
		177	if (!ok) {
		178	QMessageBox::critical( // �� .
		179	this, // �� .
		180	QObject::tr("Database Error"), // ��.
		181	q.lastError().text()); // �� .
		182	return;
		183	}
		184	}
		185
		186
112	pingvin	187	void MainWindow::showObjects(QTreeWidgetItem * parent_object_item, QTreeWidgetItem * model_item, QString filtr){
		188	QString classID; // ��
		189	QString inctance; // �� , ��
		190	QString className; // ��
		191	int field_ID;
		192	bool filtr_empty;
		193	bool ok;
		194	QSqlQuery q;
		195	QString sql_str;
		196	QString str_tmp;
113	pingvin	197	QTreeWidgetItem * title_item;
		198	QFont font;
114	pingvin	199	// font.setWeight(40);
		200	font.setBold(true);
112	pingvin	201	filtr_empty = filtr.isEmpty();
		202	classID = model_item->text(1);
		203	className = model_item->text(0);
		204	inctance = getClassInctance(classID);
114	pingvin	205
113	pingvin	206	title_item = new QTreeWidgetItem(parent_object_item);
		207	title_item->setFont(0, font);
		208	title_item->setText(0, className);
114	pingvin	209	title_item->setText(1, tr("class"));
		210	title_item->setText(2, classID);
115	pingvin	211	title_item->setText(3, inctance);
114	pingvin	212	title_item->setTextColor(0, Qt::darkBlue);
		213
112	pingvin	214	sql_str = tr("select * "
		215	" from " //�� - ��
		216	);
		217	sql_str.append(inctance);
		218	if (!filtr.isEmpty()) { // ��
		219	sql_str.append(tr(" "));
		220	sql_str.append(filtr); // ��
		221	}
		222
		223	q.prepare(sql_str);
		224
		225	ok = q.exec();
		226	if (!ok) {
		227	QMessageBox::critical( // �� .
		228	this, // �� .
		229	QObject::tr("Database Error"), // ��.
		230	q.lastError().text()); // �� .
		231	return;
		232	}
		233
		234	field_ID = q.record().indexOf(tr("ID"));
114	pingvin	235
		236	/*
113	pingvin	237	if (q.size() <= 0) return;
		238	title_item = new QTreeWidgetItem(parent_object_item);
		239	title_item->setFont(0, font);
		240	title_item->setText(0, className);
114	pingvin	241	*/
112	pingvin	242
		243	while(q.next()){
		244	if (q.record().count() > 1)
		245	{
		246	QString value_tmp;
		247	QString ID_tmp;
		248	QTreeWidgetItem * itm;
		249	ID_tmp = q.value(field_ID).toString(); // ��
		250	value_tmp = q.value(1).toString(); // �� (�� )
113	pingvin	251	// itm = new QTreeWidgetItem(parent_object_item); // �� , ��
		252	itm = new QTreeWidgetItem(title_item); // �� , ��
112	pingvin	253	itm->setText(0, value_tmp);
114	pingvin	254	itm->setText(1, tr("object"));
		255	itm->setText(2, ID_tmp);
112	pingvin	256	for (int i=0; i < model_item->childCount(); i++) // ��, ��
		257	{
		258	QTreeWidgetItem * model_item_tmp; // ��
		259	QString pointer_name;
		260	QString filtr_tmp;
		261	bool pointer_isEmpty;
		262	model_item_tmp = model_item->child(i); // ��
		263	pointer_name = getPointerFieldName(classID, model_item->child(i)->text(1));
115	pingvin	264	itm->setText(4, pointer_name);
112	pingvin	265	pointer_isEmpty = pointer_name.isEmpty();
		266	filtr_tmp = tr("where ");
		267	filtr_tmp.append(tr("`"));
		268	filtr_tmp.append(pointer_name);
		269	filtr_tmp.append(tr("` = '"));
		270	filtr_tmp.append(ID_tmp);
		271	filtr_tmp.append(tr("'"));
		272	showObjects(itm, model_item_tmp, filtr_tmp);
		273	//MainWindow::showObjectChildrens(ID_tmp, itm, model_item_tmp);
		274
		275	}
		276
		277
		278	}
		279
		280	}
		281
		282
		283
		284
		285	for (int i; i < model_item->childCount(); i++) // ��, ��
		286	{
		287
		288
		289	}
		290
111	pingvin	291	}
		292
115	pingvin	293
112	pingvin	294	QString MainWindow::getPointerFieldName(QString parent_class_id, QString chield_class_id){
		295
		296	QSqlQuery q;
		297	QString sql_str;
		298	QString str_tmp;
		299	QString field;
		300	QString result;
		301	int field_name;
		302	bool ok;
		303	sql_str = tr("select * "
		304	" from `DescriptionOfClasses` where `DescriptionOfClasses`.`FieldType` = 'pointer' and `DescriptionOfClasses`.`DefaultValue` = " //�� - ��
		305	);
		306
		307	sql_str.append(tr("'"));
		308	sql_str.append(parent_class_id);
		309	sql_str.append(tr("' "));
		310	sql_str.append(tr(" and `DescriptionOfClasses`.`ClassIdentifer` = '"));
		311	sql_str.append(chield_class_id);
		312	sql_str.append(tr("'"));
		313	q.prepare(sql_str);
		314
		315	ok = q.exec();
		316	if (!ok) {
		317	QMessageBox::critical( // �� .
		318	this, // �� .
		319	QObject::tr("Database Error"), // ��.
		320	q.lastError().text()); // �� .
		321	return result;
		322	}
		323	field_name = q.record().indexOf(tr("FieldName"));
		324	while(q.next()){
		325	result = q.value(field_name).toString();
		326	}
		327	return result;
		328	}
		329
115	pingvin	330
		331
		332	void MainWindow::on_treeWidget_2_itemClicked ( QTreeWidgetItem * item, int column ){
		333	QString item_type; // �� (�� )
		334	QString parent_object_id;
		335	int i;
		336	QTreeWidgetItem * parent_item;
		337	item_type = item->text(1);
		338	parent_item = item->parent();
		339	if (item_type == tr("object"))
		340	{
		341	QString class_id;
116	pingvin	342	QString ID;
		343	QString inctance;
		344	QString filtr_tmp;
115	pingvin	345	class_id = parent_item->text(2);
116	pingvin	346	ID = item->text(2);
		347	inctance = parent_item->text(3);
		348	delete sql_mogel;
		349	sql_mogel = new QSqlTableModel();
		350	// sql_mogel = new QSqlTableModel(this);
		351	sql_mogel->setTable(inctance);
		352	sql_mogel->setEditStrategy(QSqlTableModel::OnFieldChange);
		353
		354	filtr_tmp.append(tr("`"));
		355	filtr_tmp.append(tr("ID"));
		356	filtr_tmp.append(tr("`"));
		357	filtr_tmp.append(tr(" = '"));
		358	filtr_tmp.append(ID);
		359	filtr_tmp.append(tr("'"));
		360	sql_mogel->setFilter(filtr_tmp);
		361	sql_mogel->select();
		362	ui->tableView->setModel(sql_mogel);
		363
		364	//sql_mogel->clear();
		365	//sql_mogel->select();
		366	// ui->tableView->setVisible(false);
		367	// i++;
115	pingvin	368	}
		369	if (item_type == tr("class"))
		370	{
		371	QString parent_object_id; // ��
		372	QString class_id; // ��
		373	QString inctance;
		374	QString pointer_name;
		375	QString filtr_tmp;
116	pingvin	376	// sql_mogel->clear();
		377
115	pingvin	378	parent_object_id = parent_item->text(2);
		379	class_id = item->text(2);
		380	inctance = item->text(3);
		381	pointer_name = parent_item->text(4);
		382
116	pingvin	383	delete sql_mogel;
		384	sql_mogel = new QSqlTableModel();
		385	// sql_mogel = new QSqlTableModel(this);
115	pingvin	386	sql_mogel->setTable(inctance);
		387	sql_mogel->setEditStrategy(QSqlTableModel::OnFieldChange);
116	pingvin	388
		389	if (!parent_object_id.isEmpty())
		390	{
		391	filtr_tmp.append(tr("`"));
		392	filtr_tmp.append(pointer_name);
		393	filtr_tmp.append(tr("`"));
		394	filtr_tmp.append(tr(" = '"));
		395	filtr_tmp.append(parent_object_id);
		396	filtr_tmp.append(tr("'"));
		397	sql_mogel->setFilter(filtr_tmp);
		398	}
115	pingvin	399	sql_mogel->select();
116	pingvin	400
115	pingvin	401	ui->tableView->setModel(sql_mogel);
		402
116	pingvin	403	// ui->tableView->setVisible(true);;
115	pingvin	404	i++;
		405	}
		406
		407	//parent_object_id = parent_object_item->text(1);
		408
		409
		410
		411
		412
		413	i++;
		414
		415	}
		416
		417

Subversion Repositories OpenInventory

(root)/trunk/DBViewer/database.cpp @ 208 - Rev 116