void GRUP_KERNEL::ADD_PARENT_ITEMS() { SQL_QUERY sql_query ( m_db ); QString table_name = ""; QString column_name = ""; QString where_name = ""; QString order_by = ""; CREATE_SELECT_QUERY(&table_name,&column_name,&where_name,&order_by); sql_query.PREPARE_SELECT ( table_name,column_name,where_name,"" ); if ( sql_query.SELECT(order_by) NE 0 ) { while ( sql_query.NEXT() EQ true ) { //QString id = sql_query.VALUE(0).toString(); QStringList tree_row_str; tree_row_str << sql_query.VALUE(3).toString() << sql_query.VALUE(4).toString() << sql_query.VALUE(8).toString() << sql_query.VALUE(7).toString() << sql_query.VALUE(0).toString() << sql_query.VALUE(1).toString() << sql_query.VALUE(6).toString() << sql_query.VALUE(5).toString(); ADD_PARENT_ITEM ( tree_row_str , sql_query.VALUE(8).toInt() ); } } }
void DMR_GRUP_TREE_SECIMI::FILL_TREE_TABLE() { SQL_QUERY sql_query ( DB ); //parent itemlarimizi query ile buluyoruz. sql_query.PREPARE_SELECT ("adak_gruplar" ,"grup_id,grup_parent_id,grup_seviyesi,grup_kodu, " "grup_adi,tam_grup_kodu,grup_son_seviye_mi,gruptaki_kayit_sayisi, " "alt_grup_sayisi","modul_id=:modul_id AND program_id=:program_id" ); sql_query.SET_VALUE (":program_id",K9_PROGRAMI); sql_query.SET_VALUE (":modul_id" ,DEMIRBAS_MODULU); if ( sql_query.SELECT() NE 0 ) { while ( sql_query.NEXT() EQ true ) { int grup_id = sql_query.VALUE(0).toInt(); QStringList tree_row; tree_row << QVariant( grup_id ).toString() << sql_query.VALUE("grup_kodu").toString() << sql_query.VALUE("grup_adi" ).toString() << sql_query.VALUE("alt_grup_sayisi").toString() << sql_query.VALUE("gruptaki_kayit_sayisi").toString(); //ve bu row u tree ye ekleriz. ADD_PARENT_ITEM ( tree_row , sql_query.VALUE("alt_grup_sayisi").toInt()); } } }
void XYZ_TREE_ARAMA::SEARCH () { // Asagidaki sekilde verilerimizi ekleriz her \t de diger column a yazar. int num_of_child = 99; QString tree_row = "000\t000 Grubu"; ADD_PARENT_ITEM ( tree_row , num_of_child ); }
void GRUP_KERNEL::ADD_ITEM (QObject *button, QStringList column_datas ) { int item_id = -1; if ( button EQ m_ui->push_button_add_alt_grup OR button->metaObject()->className() EQ QAction::staticMetaObject.className()) { if (m_ui->tree_widget->topLevelItemCount() EQ 0) { MSG_INFO(tr("There are not opened main group. Firstly, you must open a group.") , NULL);//Açılmış olan ana grup bulunmamaktadır.Önce ana grup açmalısınız. return; } if (m_ui->tree_widget->currentItem() EQ NULL) { MSG_INFO(tr("You must select a main group for adding sub-group.") , NULL);//Alt grup ekleyebilmek için önce ana grup seçmelisiniz. return; } if ( column_datas.size() EQ 0 ) { return; } item_id = column_datas.at( m_grp_id_column ).toInt(); F_GRUP_KERNEL_GRUP_FISI ( item_id, ENUM_ALT_GRUP, static_cast< BASE_GRUP_KERNEL *>(this) ,this , m_db ); if ( m_grup_satir_guncellendi_mi EQ true ) { RESET_GUI_UPDATE_VALUES(); } REFRESH_TREE_WIDGET(); } else { F_GRUP_KERNEL_GRUP_FISI ( item_id, ENUM_ANA_GRUP, static_cast< BASE_GRUP_KERNEL *>(this) ,this , m_db ); if ( m_grup_satir_eklendi_mi EQ true ) { ADD_PARENT_ITEM ( m_grup_eklenen_kayit, 0 ); RESET_GUI_UPDATE_VALUES(); } REFRESH_TREE_WIDGET(); } }