WebSVN - OpenInventory - Blame - Rev 114 - /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);
		211	title_item->setTextColor(0, Qt::darkBlue);
		212
112	pingvin	213	sql_str = tr("select * "
		214	" from " //�� - ��
		215	);
		216	sql_str.append(inctance);
		217	if (!filtr.isEmpty()) { // ��
		218	sql_str.append(tr(" "));
		219	sql_str.append(filtr); // ��
		220	}
		221
		222	q.prepare(sql_str);
		223
		224	ok = q.exec();
		225	if (!ok) {
		226	QMessageBox::critical( // �� .
		227	this, // �� .
		228	QObject::tr("Database Error"), // ��.
		229	q.lastError().text()); // �� .
		230	return;
		231	}
		232
		233	field_ID = q.record().indexOf(tr("ID"));
114	pingvin	234
		235	/*
113	pingvin	236	if (q.size() <= 0) return;
		237	title_item = new QTreeWidgetItem(parent_object_item);
		238	title_item->setFont(0, font);
		239	title_item->setText(0, className);
114	pingvin	240	*/
112	pingvin	241
		242	while(q.next()){
		243	if (q.record().count() > 1)
		244	{
		245	QString value_tmp;
		246	QString ID_tmp;
		247	QTreeWidgetItem * itm;
		248	ID_tmp = q.value(field_ID).toString(); // ��
		249	value_tmp = q.value(1).toString(); // �� (�� )
113	pingvin	250	// itm = new QTreeWidgetItem(parent_object_item); // �� , ��
		251	itm = new QTreeWidgetItem(title_item); // �� , ��
112	pingvin	252	itm->setText(0, value_tmp);
114	pingvin	253	itm->setText(1, tr("object"));
		254	itm->setText(2, ID_tmp);
112	pingvin	255	for (int i=0; i < model_item->childCount(); i++) // ��, ��
		256	{
		257	QTreeWidgetItem * model_item_tmp; // ��
		258	QString pointer_name;
		259	QString filtr_tmp;
		260	bool pointer_isEmpty;
		261	model_item_tmp = model_item->child(i); // ��
		262	pointer_name = getPointerFieldName(classID, model_item->child(i)->text(1));
		263	pointer_isEmpty = pointer_name.isEmpty();
		264	filtr_tmp = tr("where ");
		265	filtr_tmp.append(tr("`"));
		266	filtr_tmp.append(pointer_name);
		267	filtr_tmp.append(tr("` = '"));
		268	filtr_tmp.append(ID_tmp);
		269	filtr_tmp.append(tr("'"));
		270	showObjects(itm, model_item_tmp, filtr_tmp);
		271	//MainWindow::showObjectChildrens(ID_tmp, itm, model_item_tmp);
		272
		273	}
		274
		275
		276	}
		277
		278	}
		279
		280
		281
		282
		283	for (int i; i < model_item->childCount(); i++) // ��, ��
		284	{
		285
		286
		287	}
		288
111	pingvin	289	}
		290
112	pingvin	291	QString MainWindow::getPointerFieldName(QString parent_class_id, QString chield_class_id){
		292
		293	QSqlQuery q;
		294	QString sql_str;
		295	QString str_tmp;
		296	QString field;
		297	QString result;
		298	int field_name;
		299	bool ok;
		300	sql_str = tr("select * "
		301	" from `DescriptionOfClasses` where `DescriptionOfClasses`.`FieldType` = 'pointer' and `DescriptionOfClasses`.`DefaultValue` = " //�� - ��
		302	);
		303
		304	sql_str.append(tr("'"));
		305	sql_str.append(parent_class_id);
		306	sql_str.append(tr("' "));
		307	sql_str.append(tr(" and `DescriptionOfClasses`.`ClassIdentifer` = '"));
		308	sql_str.append(chield_class_id);
		309	sql_str.append(tr("'"));
		310	q.prepare(sql_str);
		311
		312	ok = q.exec();
		313	if (!ok) {
		314	QMessageBox::critical( // �� .
		315	this, // �� .
		316	QObject::tr("Database Error"), // ��.
		317	q.lastError().text()); // �� .
		318	return result;
		319	}
		320	field_name = q.record().indexOf(tr("FieldName"));
		321	while(q.next()){
		322	result = q.value(field_name).toString();
		323	}
		324	return result;
		325	}
		326

Subversion Repositories OpenInventory

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