int SMM_HIZMET_TANIMLAMA_FISI::GET_FIS_RECORD ( int sube_id )
{
SQL_QUERY query(DB);
query.PREPARE_SELECT("smm_hizmetler" , "hizmet_adi, hizmet_hesap_id, vergi_hesap_id,"
"hizmet_id " ,
"sube_id = :sube_id AND hizmet_turu = :hizmet_turu ");
query.SET_VALUE(":sube_id" , sube_id);
query.SET_VALUE(":hizmet_turu" , m_hizmet_sekli);
if ( query.SELECT(" order_number ASC ") EQ 0 ) {
return ADAK_OK;
}
int current_row = 0;
QTableWidgetItem * item;
while ( query.NEXT() EQ true ) {
current_row = ADD_NEW_LINE();
QLineEdit * lineedit_hizmet_adi = ( QLineEdit * ) m_ui->tablewidget_fis_satirlari->cellWidget(current_row, HIZMET_ADI_COLUMN);
QSearchEdit * searchedit_hesap_kodu = ( QSearchEdit * ) m_ui->tablewidget_fis_satirlari->cellWidget(current_row,HESAP_KODU_COLUMN);
QLineEdit * lineedit_hesap_ismi = ( QLineEdit * ) m_ui->tablewidget_fis_satirlari->cellWidget(current_row,HESAP_ISMI_COLUMN);
QLineEdit * lineedit_hesap_id = ( QLineEdit * ) m_ui->tablewidget_fis_satirlari->cellWidget(current_row,HESAP_ID_COLUMN);
QSearchEdit * searchedit_vergi_hesap_kodu = ( QSearchEdit * ) m_ui->tablewidget_fis_satirlari->cellWidget(current_row , VERGI_HESAP_KODU_COLUMN);
QLineEdit * lineedit_vergi_hesap_ismi = ( QLineEdit * ) m_ui->tablewidget_fis_satirlari->cellWidget(current_row , VERGI_HESAP_ISMI_COLUMN);
QLineEdit * lineedit_vergi_hesap_id = ( QLineEdit * ) m_ui->tablewidget_fis_satirlari->cellWidget(current_row , VERGI_HESAP_ID_COLUMN);
lineedit_hizmet_adi->setText(query.VALUE("hizmet_adi").toString());
lineedit_hesap_id->setText(query.VALUE("hizmet_hesap_id").toString());
lineedit_vergi_hesap_id->setText(query.VALUE("vergi_hesap_id").toString());
QString tam_hesap_kodu;
QString hesap_ismi;
MUH_GET_HESAP_KODU_HESAP_ISMI(query.VALUE("hizmet_hesap_id").toInt(),tam_hesap_kodu,hesap_ismi);
searchedit_hesap_kodu->SET_TEXT(tam_hesap_kodu);
lineedit_hesap_ismi->setText(hesap_ismi);
MUH_GET_HESAP_KODU_HESAP_ISMI(query.VALUE("vergi_hesap_id").toInt(),tam_hesap_kodu , hesap_ismi );
searchedit_vergi_hesap_kodu->SET_TEXT(tam_hesap_kodu);
lineedit_vergi_hesap_ismi->setText(hesap_ismi);
item = new QTableWidgetItem ( query.VALUE("hizmet_id").toString());
m_ui->tablewidget_fis_satirlari->setItem(current_row,ROW_ID_COLUMN,item);
item = new QTableWidgetItem ( QVariant(sube_id).toString());
m_ui->tablewidget_fis_satirlari->setItem(current_row,FIS_ID_COLUMN,item);
}
return ADAK_OK;
}
int PRK_GELIR_GIDER_TURLERI_FISI::GET_FIS_RECORD ( int sube_id )
{
SQL_QUERY query(DB);
query.PREPARE_SELECT("prk_gelir_gider_turleri" , "gelir_gider_adi, hesap_id, tur_id " ,
"sube_id = :sube_id AND gider_turu_mu = :gider_turu_mu ");
query.SET_VALUE(":sube_id" , sube_id);
query.SET_VALUE(":gider_turu_mu" , m_gider_turu_mu);
if ( query.SELECT(" order_number ASC ") EQ 0 ) {
return ADAK_OK;
}
int current_row = 0;
QTableWidgetItem * item;
while ( query.NEXT() EQ true ) {
current_row = ADD_NEW_LINE();
QLineEdit * lineedit_gelir_gider_adi= ( QLineEdit * ) m_ui->tablewidget_fis_satirlari->cellWidget(current_row, GELIR_GIDER_ADI_COLUMN);
QSearchEdit * searchedit_hesap_kodu = ( QSearchEdit *) m_ui->tablewidget_fis_satirlari->cellWidget(current_row,HESAP_KODU_COLUMN);
QLineEdit * lineedit_hesap_ismi = ( QLineEdit *) m_ui->tablewidget_fis_satirlari->cellWidget(current_row,HESAP_ISMI_COLUMN);
QLineEdit * lineedit_hesap_id = ( QLineEdit *) m_ui->tablewidget_fis_satirlari->cellWidget(current_row,HESAP_ID_COLUMN);
lineedit_gelir_gider_adi->setText(query.VALUE(0).toString());
lineedit_hesap_id->setText(query.VALUE(1).toString());
QString tam_hesap_kodu;
QString hesap_ismi;
MUH_GET_HESAP_KODU_HESAP_ISMI(query.VALUE(1).toInt(),tam_hesap_kodu,hesap_ismi);
searchedit_hesap_kodu->SET_TEXT(tam_hesap_kodu);
lineedit_hesap_ismi->setText(hesap_ismi);
item = new QTableWidgetItem ( query.VALUE(2).toString());
m_ui->tablewidget_fis_satirlari->setItem(current_row,ROW_ID_COLUMN,item);
item = new QTableWidgetItem ( QVariant(sube_id).toString());
m_ui->tablewidget_fis_satirlari->setItem(current_row,FIS_ID_COLUMN,item);
}
return ADAK_OK;
}
int MUH_HESAP_EKLEME_FISI::GET_FIS_RECORD ( int p_fis_id )
{
SQL_QUERY query ( DB );
query.PREPARE_SELECT("muh_hesaplar" , "tam_hesap_kodu, hesap_ismi, hesap_seviyesi, hesap_kodu" ,
"hesap_id = :hesap_id");
query.SET_VALUE (":hesap_id", p_fis_id );
if ( query.SELECT() EQ 0 ) {
return ADAK_FAIL;
}
query.NEXT();
m_ui->line_edit_hesap_kodu->setText( query.VALUE(0).toString() );
m_ui->lineEdit_hesap_ismi->setText( query.VALUE(1).toString() );
m_ana_hesap_seviyesi = query.VALUE(2).toInt();
m_ana_hesap_kodu = query.VALUE(3).toString();
m_ui->line_edit_hesap_kodu->setEnabled( false );
m_ui->lineEdit_hesap_ismi->setEnabled( false );
if ( m_ana_hesap_seviyesi EQ 1 ) {
m_ui->line_edit_hesap_kodu->setEnabled( true );
m_ui->lineEdit_hesap_ismi->setEnabled ( true );
}
query.PREPARE_SELECT("muh_hesaplar" , "hesap_id, hesap_kodu, hesap_ismi" ,
"parent_id = :parent_id");
query.SET_VALUE ( ":parent_id", p_fis_id );
if ( query.SELECT("hesap_kodu") EQ 0 ) {
return ADAK_OK;
}
int current_row = 0;
while ( query.NEXT() EQ true ) {
current_row = ADD_NEW_LINE();
QLineEdit * lineEdit_hesap_kodu = ( QLineEdit * ) m_ui->tablewidget_alt_hesaplar->cellWidget ( current_row, HESAP_KODU_COLUMN );
QLineEdit * lineEdit_hesap_ismi = ( QLineEdit * ) m_ui->tablewidget_alt_hesaplar->cellWidget ( current_row, HESAP_ISMI_COLUMN );
QLineEdit * lineEdit_gruplar = ( QLineEdit * ) m_ui->tablewidget_alt_hesaplar->cellWidget ( current_row, HESAP_GRUPLAR );
QLineEdit * lineEdit_tam_hesap_kodu = ( QLineEdit * ) m_ui->tablewidget_alt_hesaplar->cellWidget ( current_row, TAM_HESAP_KODU_COLUMN );
QTableWidgetItem * new_item;
new_item = new QTableWidgetItem ( query.VALUE(0).toString() );
m_ui->tablewidget_alt_hesaplar->setItem ( current_row, ROW_ID_COLUMN, new_item );
new_item = new QTableWidgetItem ( QVariant ( p_fis_id ).toString() );
m_ui->tablewidget_alt_hesaplar->setItem ( current_row, ANA_HESAP_ID_COLUMN, new_item );
lineEdit_hesap_kodu->setText ( query.VALUE(1).toString() );
lineEdit_hesap_ismi->setText ( query.VALUE(2).toString() );
lineEdit_tam_hesap_kodu->setText ( m_ui->line_edit_hesap_kodu->text() + m_delimeter + query.VALUE(1).toString() );
QList<int> grup_idleri;
lineEdit_gruplar->setText(GRP_KAYDIN_GRUPLARINI_BUL(E9_PROGRAMI,MUHASEBE_MODULU,query.VALUE(0).toInt(),&grup_idleri,new QStringList(), new QStringList()));
QString grup_id_str = "";
for ( int i = 0 ; i < grup_idleri.size() ; i++ ) {
if ( grup_id_str.isEmpty() EQ false ) {
grup_id_str.append("\t");
}
grup_id_str .append( QVariant(grup_idleri.at(i)).toString());
}
m_ui->tablewidget_alt_hesaplar->setItem(current_row,GRUP_IDLERI,new QTableWidgetItem(grup_id_str));
}
return ADAK_OK;
}
int PRS_PERSONEL_AILE_FISI::GET_FIS_RECORD ( int record_id )
{
SQL_QUERY sql_query_personel (DB);
SQL_QUERY query (DB);
int cari_hesap_id = 0 ;
sql_query_personel.PREPARE_SELECT( "prs_personeller ","sicil_no, cari_hesap_id","personel_id = :personel_id" );
sql_query_personel.SET_VALUE(":personel_id", record_id);
if ( sql_query_personel.SELECT() NE 0 ) {
sql_query_personel.NEXT();
line_edit_personel_sicil_no->setText ( sql_query_personel.VALUE(0).toString() );
cari_hesap_id = sql_query_personel.VALUE( 1 ).toInt();
}
CARI_HESAP_STRUCT hesap_bilgileri;
CARI_SET_HESAP_STRUCT_DEFAULTS(&hesap_bilgileri);
CARI_KART_BILGILERINI_OKU( cari_hesap_id, &hesap_bilgileri );
line_edit_personel_adi->setText ( hesap_bilgileri.cari_hesap_ismi);
query.PREPARE_SELECT ( "prs_personel_aile_uyeleri ",
"aile_bilgi_id , personel_id, order_number, aciklama, "
"adi_soyadi, tc_kimlik_no,akrabalik_derecesi,dogum_tarihi, "
"ogrenim_durumu, calisma_durumu,"
"cinsiyet, asgari_gecim_ind_durumu ",
"personel_id = :personel_id ");
query.SET_VALUE ( ":personel_id", record_id );
if ( query.SELECT("order_number ASC" ) NE 0 ) {
while ( query.NEXT() EQ true ) {
int p_current_row;
p_current_row = ADD_NEW_LINE ();
QWidget * cell_widget = table_widget_aile_satirlari->cellWidget( p_current_row, AD_SOYAD_COLUMN );
QLineEdit * line_edit_ad_soyad = static_cast < QLineEdit * > ( cell_widget );
line_edit_ad_soyad->setText( query.VALUE("adi_soyadi").toString() );
cell_widget = table_widget_aile_satirlari->cellWidget( p_current_row, TC_KIMLIK_NO_COLUMN );
QLineEdit * line_edit_tc_kimlik_no = static_cast < QLineEdit * > ( cell_widget );
line_edit_tc_kimlik_no->setText( query.VALUE("tc_kimlik_no").toString() );
cell_widget = table_widget_aile_satirlari->cellWidget( p_current_row, AKRABALIK_DERECESI_COLUMN );
QComboBox * combo_box_akrabalik_derecesi = static_cast < QComboBox * > ( cell_widget );
FIND_AND_SET_COMBOBOX_TEXT(combo_box_akrabalik_derecesi ,
PRS_GET_AKRABALIK_DERECESI_STRING(query.VALUE("akrabalik_derecesi").toInt()));
cell_widget = table_widget_aile_satirlari->cellWidget( p_current_row, CALISMA_DURUMU_COLUMN );
QComboBox * combo_box_calisma_durumu = static_cast < QComboBox * > ( cell_widget );
FIND_AND_SET_COMBOBOX_TEXT(combo_box_calisma_durumu , PRS_GET_CALISMA_DURUMU_STRING(query.VALUE("calisma_durumu").toInt()));
cell_widget = table_widget_aile_satirlari->cellWidget( p_current_row, DOGUM_TARIHI_COLUMN);
QAdakDate * adakDate_dogum_tarihi = static_cast<QAdakDate*> (cell_widget);
adakDate_dogum_tarihi->SET_DATE( query.VALUE("dogum_tarihi").toString());
cell_widget = table_widget_aile_satirlari->cellWidget( p_current_row, EGITIM_DURUMU_COLUMN );
QComboBox * combo_box_egitim_durumu = static_cast < QComboBox * > ( cell_widget );
FIND_AND_SET_COMBOBOX_TEXT(combo_box_egitim_durumu , query.VALUE("ogrenim_durumu").toString());
cell_widget = table_widget_aile_satirlari->cellWidget( p_current_row, CINSIYET_COLUMN );
QComboBox * combo_box_cinsiyet = static_cast < QComboBox * > ( cell_widget );
FIND_AND_SET_COMBOBOX_TEXT(combo_box_cinsiyet , query.VALUE("cinsiyet").toString());
cell_widget = table_widget_aile_satirlari->cellWidget( p_current_row, ACIKLAMA_COLUMN );
QLineEdit * line_edit_aciklama = static_cast < QLineEdit * > ( cell_widget );
line_edit_aciklama->setText( query.VALUE("aciklama").toString() );
cell_widget = table_widget_aile_satirlari->cellWidget( p_current_row, ASGARI_GECIM_IND_DURUMU_COLUMN );
QComboBox * combo_box_asagari_gecim_ind_durumu = static_cast < QComboBox * > ( cell_widget );
int asgari_gecim_ind_durumu = query.VALUE( "asgari_gecim_ind_durumu" ).toInt();
FIND_AND_SET_COMBOBOX_TEXT( combo_box_asagari_gecim_ind_durumu , PRS_GET_EVET_HAYIR_DURUMU_STRING(asgari_gecim_ind_durumu));
QString id = query.VALUE("aile_bilgi_id").toString();
QString personel_id = query.VALUE("personel_id").toString();
QString order_number = query.VALUE("order_number").toString();
QTableWidgetItem * new_item;
table_widget_aile_satirlari->setHorizontalHeaderLabels(QStringList()<<"id"<<"record_id"<<"satir_order"
<<tr("Ad Soyad")<<tr("TC Kimlik No")<<tr("Akrabalık Derecesi")<<("Çalışma Durumu")
<<tr("Doğum Tarihi")<<tr("Eğitim Düzeyi")
<<tr("Cinsiyet")<< tr("Asgari Geçim \n İndirimi") << tr("Açıklama")<<tr("")<<tr("") );
new_item = new QTableWidgetItem(tr("%1").arg(id));
table_widget_aile_satirlari->setItem(p_current_row, ROW_ID_COLUMN, new_item);
new_item = new QTableWidgetItem(tr("%1").arg(personel_id));
table_widget_aile_satirlari->setItem(p_current_row, RECORD_ID_COLUMN, new_item);
new_item = new QTableWidgetItem(tr("%1").arg(order_number));
table_widget_aile_satirlari->setItem(p_current_row, ORDER_COLUMN, new_item);
}
}
return ADAK_OK;
}
int PRS_PERSONEL_ODENEK_EKLEME_FISI::GET_FIS_RECORD ( int record_id )
{
SQL_QUERY sql_query(DB);
SQL_QUERY query (DB);
sql_query.PREPARE_SELECT( "prs_personeller ",
"sicil_no, cari_hesap_id",
"personel_id = :personel_id" );
sql_query.SET_VALUE( ":personel_id", record_id );
if ( sql_query.SELECT() EQ 0 ) {
return ADAK_FAIL;
}
sql_query.NEXT();
line_edit_personel_sicil_no->setText ( sql_query.VALUE(0).toString() );
int cari_hesap_id = sql_query.VALUE( 1 ).toInt();
CARI_HESAP_STRUCT hesap_bilgileri;
CARI_SET_HESAP_STRUCT_DEFAULTS(&hesap_bilgileri);
CARI_KART_BILGILERINI_OKU( cari_hesap_id, &hesap_bilgileri );
line_edit_personel_adi_soyadi->setText( hesap_bilgileri.cari_hesap_ismi );
query.PREPARE_SELECT ( "prs_ek_kesintiler_odenekler",
"kesinti_odenek_id, personel_id, order_number, "
"odenek_kesinti_adi, bordro_donemi_ay, bordro_donemi_yil, ssk_kesintisi_iceriyor_mu, "
"gelir_vergisi_iceriyor_mu, damga_vergisi_iceriyor_mu, "
"yuzde_mi, yuzde_orani, tutar, aciklama, bordro_id ",
"personel_id = :personel_id "
"AND kesinti_odenek_turu = :kesinti_odenek_turu ");
query.SET_VALUE ( ":personel_id", record_id );
query.SET_VALUE ( ":kesinti_odenek_turu" , ENUM_PRS_ODENEK);
query.SELECT("order_number ASC" );
while ( query.NEXT() EQ true ) {
int p_current_row;
p_current_row = ADD_NEW_LINE ();
QWidget * cell_widget = table_widget_odenek_satirlari->cellWidget( p_current_row, BORDRO_DONEMI_AY_COLUMN );
QLineEdit * line_edit_odenek_adi = ( QLineEdit * ) table_widget_odenek_satirlari->cellWidget( p_current_row, ODENEK_ADI_COLUMN );
QComboBox * combo_box_bordro_donemi_ay = ( QComboBox * ) table_widget_odenek_satirlari->cellWidget( p_current_row, BORDRO_DONEMI_AY_COLUMN );
QComboBox * combo_box_bordro_donemi_yil = ( QComboBox * ) table_widget_odenek_satirlari->cellWidget( p_current_row, BORDRO_DONEMI_YIL_COLUMN );
QCheckBox * check_box_odenek_ssk_kesintisi_iceriyor_mu = ( QCheckBox * ) table_widget_odenek_satirlari->cellWidget( p_current_row, ODENEK_SSK_KESINTISI_ICERIYOR_MU_COLUMN );
QCheckBox * check_box_odenek_gelir_vergisi_iceriyor_mu = ( QCheckBox * ) table_widget_odenek_satirlari->cellWidget( p_current_row, ODENEK_GELIR_VERGISI_ICERIYOR_MU_COLUMN );
QCheckBox * check_box_odenek_damga_vergisi_iceriyor_mu = ( QCheckBox * ) table_widget_odenek_satirlari->cellWidget( p_current_row, ODENEK_DAMGA_VERGISI_ICERIYOR_MU_COLUMN );
QComboBox * combo_box_odenek_yuzde_mi = ( QComboBox * ) table_widget_odenek_satirlari->cellWidget( p_current_row, ODENEK_YUZDE_MI_COLUMN );
QCommaEdit * comma_edit_yuzde_orani = ( QCommaEdit * ) table_widget_odenek_satirlari->cellWidget( p_current_row, YUZDE_COLUMN );
QCommaEdit * comma_edit_tutar = ( QCommaEdit * ) table_widget_odenek_satirlari->cellWidget( p_current_row, TUTAR_COLUMN );
line_edit_odenek_adi->setText( query.VALUE("odenek_kesinti_adi").toString() );
combo_box_bordro_donemi_ay->setCurrentIndex( query.VALUE("bordro_donemi_ay").toInt() );
combo_box_bordro_donemi_yil->setCurrentIndex( combo_box_bordro_donemi_yil->findText( query.VALUE("bordro_donemi_yil").toString()) );
check_box_odenek_ssk_kesintisi_iceriyor_mu->setChecked( query.VALUE("ssk_kesintisi_iceriyor_mu").toInt() );
check_box_odenek_gelir_vergisi_iceriyor_mu->setChecked( query.VALUE("gelir_vergisi_iceriyor_mu").toInt() );
check_box_odenek_damga_vergisi_iceriyor_mu->setChecked( query.VALUE("damga_vergisi_iceriyor_mu").toInt() );
combo_box_odenek_yuzde_mi->setCurrentIndex( query.VALUE("yuzde_mi").toInt() );
comma_edit_yuzde_orani->SET_DOUBLE ( query.VALUE("yuzde_orani").toDouble() );
comma_edit_tutar->SET_DOUBLE ( query.VALUE("tutar").toDouble() );
if ( combo_box_odenek_yuzde_mi->currentText() EQ tr("TUTAR") ) {
comma_edit_tutar->setEnabled( true );
}
else {
comma_edit_yuzde_orani->setEnabled( true );
}
cell_widget = table_widget_odenek_satirlari->cellWidget( p_current_row, ACIKLAMA_COLUMN );
QLineEdit * line_edit_aciklama = static_cast < QLineEdit * > ( cell_widget );
line_edit_aciklama->setText( query.VALUE("aciklama").toString() );
QString id = query.VALUE("kesinti_odenek_id").toString();
QString personel_id = query.VALUE("personel_id").toString();
QString order_number = query.VALUE("order_number").toString();
QTableWidgetItem * new_item;
new_item = new QTableWidgetItem(tr("%1").arg(id));
table_widget_odenek_satirlari->setItem(p_current_row, ROW_ID_COLUMN, new_item);
new_item = new QTableWidgetItem(tr("%1").arg(personel_id));
table_widget_odenek_satirlari->setItem(p_current_row, RECORD_ID_COLUMN, new_item);
new_item = new QTableWidgetItem(tr("%1").arg(order_number));
table_widget_odenek_satirlari->setItem(p_current_row, ORDER_COLUMN, new_item);
}
return ADAK_OK;
}
int PRS_PUANTAJLARI_GOR_VE_DUZELT_FISI::GET_FIS_RECORD ( int record_id )
{
SQL_QUERY query ( DB );
SQL_QUERY s_query ( DB );
QString bordro_bas_donemi = PRS_GET_BORDRO_DONEMI_BAS_STRING( m_bordro_yili, m_bordro_ayi );
QString bordro_bts_donemi = PRS_GET_BORDRO_DONEMI_BTS_STRING( m_bordro_yili, m_bordro_ayi );
// isten ayrilanlar
query.PREPARE_SELECT("prs_personel_nufus_blgler, prs_personeller, prs_personel_kisisel_blgler " ,
"prs_personel_nufus_blgler.personel_id, "
"ucret_sekli, "
"net_ucret, "
"brut_ucret , "
"ise_giris_tarihi, "
"cari_hesap_id, "
"ise_giris_tarihi, "
"calisma_sekli, "
"haftalik_calisilan_gun_sayisi,"
"isten_cikis_tarihi",
"prs_personel_nufus_blgler.personel_id = prs_personeller.personel_id "
"AND prs_personel_kisisel_blgler.personel_id = prs_personeller.personel_id "
"AND sube_id = :sube_id "
"AND ise_giris_tarihi <= :ise_giris_tarihi "
"AND isten_cikis_tarihi >= :isten_cikis_tarihi " );
query.SET_VALUE(":sube_id" , m_sube_id);
query.SET_VALUE(":ise_giris_tarihi" , bordro_bts_donemi );
query.SET_VALUE(":isten_cikis_tarihi" , bordro_bas_donemi );
if ( query.SELECT() EQ 0) {
return ADAK_OK;
}
int current_row = -1;
int prs_doviz_id = 0;
while ( query.NEXT() NE 0 ) {
int personel_id = query.VALUE("personel_id").toInt();
int cari_hesap_id = query.VALUE( "cari_hesap_id").toInt();
QDate ise_giris_tarihi = QDate::fromString( query.VALUE( "ise_giris_tarihi" ).toString(), "yyyy.MM.dd" );
QString isten_cikis_tarihi = query.VALUE( "isten_cikis_tarihi" ).toString();
CARI_HESAP_STRUCT hesap_bilgileri;
CARI_SET_HESAP_STRUCT_DEFAULTS(&hesap_bilgileri);
CARI_KART_BILGILERINI_OKU( cari_hesap_id, &hesap_bilgileri );
current_row = ADD_NEW_LINE();
QLineEdit * line_edit_adi_soyad = ( QLineEdit * ) m_ui->table_widget_gun_satirlari->cellWidget(current_row ,ADI_COLUMN);
line_edit_adi_soyad->setText( hesap_bilgileri.cari_hesap_ismi );
int calisma_sekli = query.VALUE("calisma_sekli").toInt();
prs_doviz_id = CARI_GET_PARA_BIRIM_ID( cari_hesap_id );
int ucret_sekli_enum = query.VALUE( "ucret_sekli" ).toInt();
double net_ucret = query.VALUE( "net_ucret" ).toDouble();
double brut_ucret = query.VALUE( "brut_ucret" ).toDouble();
double haftalik_calisilan_gun_sayisi = query.VALUE( "haftalik_calisilan_gun_sayisi" ).toDouble();
double prs_personel_ucret = net_ucret;
if ( ucret_sekli_enum EQ PRS_BRUT ) {
prs_personel_ucret = brut_ucret;
}
QTableWidgetItem * new_item;
new_item = new QTableWidgetItem(tr("%1").arg(personel_id));
m_ui->table_widget_gun_satirlari->setItem(current_row ,ROW_ID_COLUMN ,new_item);
new_item=new QTableWidgetItem(tr("%1").arg(record_id));
m_ui->table_widget_gun_satirlari->setItem(current_row ,RECORD_ID_COLUMN ,new_item);
QLineEdit * line_edit_calisma_sekli = ( QLineEdit * ) m_ui->table_widget_gun_satirlari->cellWidget(current_row, CALISMA_SEKLI);
line_edit_calisma_sekli->setText( QVariant ( calisma_sekli ).toString() );
s_query.PREPARE_SELECT ("prs_puantaj","gun_sayisi ",
"personel_id = :personel_id "
"AND bordro_donemi_yil = :bordro_donemi_yil "
"AND bordro_donemi_ay = :bordro_donemi_ay ");
s_query.SET_VALUE (":personel_id" , personel_id );
s_query.SET_VALUE (":bordro_donemi_yil" , m_bordro_yili );
s_query.SET_VALUE (":bordro_donemi_ay" , m_bordro_ayi );
QCommaEdit * comma_edit_doviz_kuru = ( QCommaEdit * ) m_ui->table_widget_gun_satirlari->cellWidget( current_row, KUR_COLUMN );
QCommaEdit * comma_edit_aldigi_ucret = ( QCommaEdit * ) m_ui->table_widget_gun_satirlari->cellWidget( current_row, ALDIGI_UCRET );
QCommaEdit * comma_edit_ucret_tutari = ( QCommaEdit * ) m_ui->table_widget_gun_satirlari->cellWidget( current_row, TEMEL_PARABIRIMI_UCRET );
QCommaEdit * comma_edit_gun = ( QCommaEdit * ) m_ui->table_widget_gun_satirlari->cellWidget(current_row,CALISTIGI_GUN_COLUMN);
QCommaEdit * comma_edit_ek_odenek = ( QCommaEdit * ) m_ui->table_widget_gun_satirlari->cellWidget(current_row,EK_ODENEK_TUTARI);
QCommaEdit * comma_edit_ek_kesinti = ( QCommaEdit * ) m_ui->table_widget_gun_satirlari->cellWidget(current_row,EK_KESINTI_TUTARI);
QCommaEdit * comma_edit_gunluk_ucret = ( QCommaEdit * ) m_ui->table_widget_gun_satirlari->cellWidget(current_row,GUNLUK_UCRET );
QCommaEdit * comma_edit_yemek_verilen_gun_sayisi= ( QCommaEdit * ) m_ui->table_widget_gun_satirlari->cellWidget(current_row,YEMEK_VERILEN_GUN_SAYISI );
comma_edit_yemek_verilen_gun_sayisi->SET_DOUBLE( haftalik_calisilan_gun_sayisi * 4 );
double eksik_gun_sayisi = PRS_GET_EKSIK_GUN_SAYISI( personel_id, m_bordro_ayi, m_bordro_yili );
if ( eksik_gun_sayisi > 0.00 ) {
if ( isten_cikis_tarihi NE "9999.99.99" ) {
comma_edit_gun->SET_DOUBLE( QDate::fromString( isten_cikis_tarihi, "yyyy.MM.dd").daysInMonth() - eksik_gun_sayisi );
}
else {
comma_edit_gun->SET_DOUBLE( QDate::fromString( bordro_bts_donemi, "yyyy.MM.dd").daysInMonth() - eksik_gun_sayisi );
}
}
else {
if ( isten_cikis_tarihi NE "9999.99.99" ) {
QDate isten_cikis_date = QDate::fromString( isten_cikis_tarihi, "yyyy.MM.dd");
comma_edit_gun->SET_DOUBLE( isten_cikis_date.day() );
}
else {
comma_edit_gun->SET_DOUBLE( 30 );
}
}
int gun_sayisi = comma_edit_gun->GET_DOUBLE();
if ( ise_giris_tarihi.year() EQ m_bordro_yili ) {
QDate bordro_tarihi;
if ( ise_giris_tarihi.month() EQ m_bordro_ayi ) {
int ise_giris_gunu = ise_giris_tarihi.day();
bordro_tarihi = QDate::fromString( bordro_bts_donemi, "yyyy.MM.dd" );
if ( isten_cikis_tarihi NE "9999.99.99" ) {
bordro_tarihi = QDate::fromString( isten_cikis_tarihi, "yyyy.MM.dd" );
gun_sayisi = bordro_tarihi.day();
}
else {
gun_sayisi = bordro_tarihi.daysInMonth();
}
gun_sayisi = gun_sayisi - ise_giris_gunu + 1 ;
comma_edit_gun->SET_INTEGER( gun_sayisi );
}
comma_edit_yemek_verilen_gun_sayisi->SET_DOUBLE( haftalik_calisilan_gun_sayisi * floor( comma_edit_gun->GET_DOUBLE() / 7.0 ) );
}
// GUNLUK UCRET PUANTAJ'DA GUN DEGISTIRILIRSE OTOMATIK CARPILACAK
comma_edit_gunluk_ucret->SET_DOUBLE( ROUND( prs_personel_ucret / 30 ));
if ( calisma_sekli EQ ENUM_GUNLUK ) {
comma_edit_gunluk_ucret->SET_DOUBLE( prs_personel_ucret );
}
if ( calisma_sekli EQ ENUM_AYLIK and gun_sayisi > 30 ) {
comma_edit_gun->SET_DOUBLE( 30 );
}
if ( calisma_sekli EQ ENUM_GUNLUK ) {
prs_personel_ucret = ROUND( comma_edit_gun->GET_DOUBLE() * comma_edit_gunluk_ucret->GET_DOUBLE() );
}
if ( prs_doviz_id NE DVZ_GET_TEMEL_PARA_BIRIMI_ID() ) {
comma_edit_doviz_kuru->setEnabled( true );
}
// personel ek odenek bilgileri sorgulaniyor.
double toplam_ek_odenek = 0.00;
double toplam_ek_kesinti = 0.00;
SQL_QUERY t_query( DB );
t_query.PREPARE_SELECT( "prs_ek_kesintiler_odenekler",
"yuzde_mi, yuzde_orani, tutar, kesinti_odenek_turu ",
"personel_id = :personel_id AND "
"bordro_donemi_yil = :bordro_donemi_yil AND "
"bordro_donemi_ay = :bordro_donemi_ay ");
t_query.SET_VALUE( ":personel_id" , personel_id );
t_query.SET_VALUE( ":bordro_donemi_yil" , m_bordro_yili );
t_query.SET_VALUE( ":bordro_donemi_ay " , m_bordro_ayi );
if ( t_query.SELECT() NE 0 ) {
while ( t_query.NEXT() EQ true ) {
int yuzde_mi = t_query.VALUE( "yuzde_mi" ).toInt();
int kesinti_odenek_turu = t_query.VALUE( "kesinti_odenek_turu" ).toInt();
double yuzde_orani = t_query.VALUE( "yuzde_orani" ).toDouble();
double tutar = t_query.VALUE( "tutar" ).toDouble();
if ( yuzde_mi EQ 1 ) {
if ( kesinti_odenek_turu EQ ENUM_PRS_ODENEK ) {
toplam_ek_odenek += ROUND( prs_personel_ucret * yuzde_orani );
}
if ( kesinti_odenek_turu EQ ENUM_PRS_KESINTI ) {
toplam_ek_kesinti += ROUND( prs_personel_ucret * yuzde_orani );
}
}
else {
if ( kesinti_odenek_turu EQ ENUM_PRS_ODENEK ) {
toplam_ek_odenek += tutar;
}
if ( kesinti_odenek_turu EQ ENUM_PRS_KESINTI ) {
toplam_ek_kesinti += tutar;
}
}
}
}
comma_edit_aldigi_ucret->SET_DOUBLE ( prs_personel_ucret );
comma_edit_ek_odenek->SET_DOUBLE ( toplam_ek_odenek );
comma_edit_ek_kesinti->SET_DOUBLE ( toplam_ek_kesinti );
comma_edit_doviz_kuru->SET_DOUBLE ( DVZ_DOVIZ_KURUNU_AL( prs_doviz_id, QDate::currentDate(), ENUM_SATIS ) );
comma_edit_ucret_tutari->SET_DOUBLE ( ROUND( comma_edit_doviz_kuru->GET_DOUBLE() * prs_personel_ucret ) );
if ( s_query.SELECT() EQ 0 ) {
DB->START_TRANSACTION();
QCommaEdit * comma_edit_kur = ( QCommaEdit * ) m_ui->table_widget_gun_satirlari->cellWidget(current_row ,KUR_COLUMN);
SQL_QUERY insert_query(DB);
insert_query.PREPARE_INSERT("prs_puantaj", "puantaj_id" ,
"personel_id , gun_sayisi ,doviz_kuru, "
"temel_para_birim_tutari , bordro_donemi_yil, bordro_donemi_ay, yemek_verilen_gun_sayisi ");
insert_query.SET_VALUE(":personel_id" , personel_id);
insert_query.SET_VALUE(":gun_sayisi" , comma_edit_gun->GET_DOUBLE());
insert_query.SET_VALUE(":doviz_kuru" , comma_edit_kur->GET_DOUBLE());
insert_query.SET_VALUE(":temel_para_birim_tutari" , comma_edit_ucret_tutari->GET_DOUBLE() );
insert_query.SET_VALUE(":bordro_donemi_yil" , m_bordro_yili );
insert_query.SET_VALUE(":bordro_donemi_ay" , m_bordro_ayi );
insert_query.SET_VALUE(":yemek_verilen_gun_sayisi" , comma_edit_yemek_verilen_gun_sayisi->GET_DOUBLE() );
insert_query.INSERT();
DB->COMMIT_TRANSACTION();
}
}
return ADAK_OK;
}
int ADRES_YETKILILER_FISI::GET_FIS_RECORD ( int p_adres_id )
{
SQL_QUERY sql_query ( DB );
sql_query.PREPARE_SELECT ( "adr_adresler","firma_sahis_adi","adres_id=:adres_id");
sql_query.SET_VALUE ( ":adres", p_adres_id );
if ( sql_query.SELECT() NE 0 ) {
sql_query.NEXT();
m_ui->label_adres_kaydi->setText(sql_query.VALUE(0).toString());
}
sql_query.PREPARE_SELECT ( "adr_yetkili_bilgileri, adr_adresler","yetkili_id, order_number, gorevi, "
"firma_sahis_adi, tel_ulke_kodu, tel_alan_kodu, telefon,"
"is_tel_alan_kodu, is_telefonu, cep_tel_gsm_kodu, cep_telefonu, "
"adr_yetkili_bilgileri.adres_id, is_telefonu_dahili",
"adr_yetkili_bilgileri.adres_id = adr_adresler.adres_id "
"AND adr_yetkili_bilgileri.firma_id = :firma_id ");
sql_query.SET_VALUE ( ":firma_id", p_adres_id );
if ( sql_query.SELECT("order_number") EQ 0 ) {
return ADAK_OK;
}
int current_row = 0;
while ( sql_query.NEXT() EQ true ) {
current_row = ADD_NEW_LINE ();
QTableWidgetItem * yetkili_id_item = new QTableWidgetItem ( sql_query.VALUE(0).toString() );
m_ui->table_widget_yetkililer->setItem ( current_row, YETKILI_ID_COLUMN, yetkili_id_item );
QTableWidgetItem * firma_id_item = new QTableWidgetItem ( QVariant ( p_adres_id ).toString() );
m_ui->table_widget_yetkililer->setItem ( current_row, FIRMA_ID_COLUMN, firma_id_item );
QTableWidgetItem * yetki_order_item = new QTableWidgetItem ( sql_query.VALUE(1).toString() );
m_ui->table_widget_yetkililer->setItem ( current_row, ORDER_COLUMN, yetki_order_item );
QLineEdit * lineEdit_sahis_id = ( QLineEdit * ) m_ui->table_widget_yetkililer->cellWidget ( current_row, SAHIS_ID_COLUMN );
QLineEdit * lineEdit_yetkili_adi_soyadi = ( QLineEdit * ) m_ui->table_widget_yetkililer->cellWidget ( current_row, YETKILI_ADI_SOYADI_COLUMN );
QLineEdit * lineEdit_yetkili_gorevi = ( QLineEdit * ) m_ui->table_widget_yetkililer->cellWidget ( current_row, YETKILI_GOREVI );
QLineEdit * lineEdit_yetkili_is_telefonu = ( QLineEdit * ) m_ui->table_widget_yetkililer->cellWidget ( current_row, YETKILI_IS_TELEFONU );
QLineEdit * lineEdit_yetkili_gsm = ( QLineEdit * ) m_ui->table_widget_yetkililer->cellWidget ( current_row, YETKILI_CEP_TELEFONU );
QLineEdit * lineEdit_yetkili_ev_telefonu = ( QLineEdit * ) m_ui->table_widget_yetkililer->cellWidget ( current_row, YETKILI_EV_TELEFONU );
QComboBox * comboBox_ulke_kodu = ( QComboBox * ) m_ui->table_widget_yetkililer->cellWidget ( current_row, YETKILI_ULKE_KODU );
QComboBox * comboBox_ev_tel_alan_kodu = ( QComboBox * ) m_ui->table_widget_yetkililer->cellWidget ( current_row, YETKILI_EV_TEL_ALAN_KODU );
QComboBox * comboBox_is_tel_alan_kodu = ( QComboBox * ) m_ui->table_widget_yetkililer->cellWidget ( current_row, YETKILI_IS_TEL_ALAN_KODU );
QComboBox * comboBox_gsm_kodu = ( QComboBox * ) m_ui->table_widget_yetkililer->cellWidget ( current_row, YETKILI_GSM_KODU );
QCommaEdit * commaEdit_is_tel_dahili = ( QCommaEdit * ) m_ui->table_widget_yetkililer->cellWidget ( current_row, YETKILI_IS_TELEFONU_DAHILI );
lineEdit_yetkili_gorevi->setText ( sql_query.VALUE(2).toString() );
lineEdit_yetkili_adi_soyadi->setText ( sql_query.VALUE(3).toString() );
FIND_AND_SET_COMBOBOX_TEXT ( comboBox_ulke_kodu, sql_query.VALUE(4).toString() );
SATIR_TELEFON_ALAN_KODLARINI_DOLDUR ( current_row );
FIND_AND_SET_COMBOBOX_TEXT ( comboBox_ev_tel_alan_kodu, sql_query.VALUE(5).toString() );
lineEdit_yetkili_ev_telefonu->setText ( sql_query.VALUE(6).toString() );
FIND_AND_SET_COMBOBOX_TEXT ( comboBox_is_tel_alan_kodu, sql_query.VALUE(7).toString() );
lineEdit_yetkili_is_telefonu->setText ( sql_query.VALUE(8).toString() );
FIND_AND_SET_COMBOBOX_TEXT ( comboBox_gsm_kodu, sql_query.VALUE(9).toString() );
lineEdit_yetkili_gsm->setText ( sql_query.VALUE(10).toString() );
lineEdit_sahis_id->setText ( sql_query.VALUE(11).toString() );
commaEdit_is_tel_dahili->SET_INTEGER ( sql_query.VALUE(12).toInt() );
}
return ADAK_OK;
}
int PRS_EK_ODENEK_VE_KESINTI_FISI::GET_FIS_RECORD ( int record_id )
{
SQL_QUERY sql_query(DB);
SQL_QUERY query (DB);
sql_query.PREPARE_SELECT( "prs_kesinti_odenek_tanimlar ",
"kes_ode_tanim_id, kesinti_odenek_adi, aciklama, "
"bordro_donemi_ay, bordro_donemi_yil, "
"ssk_kesintisi_iceriyor_mu, damga_vergisi_iceriyor_mu,"
"gelir_vergisi_iceriyor_mu, kesinti_odenek_tarihi,"
"yuzde_mi, tutar, kesinti_odenek_no, bordrosu_kesildi_mi ",
"kes_ode_tanim_id = :kes_ode_tanim_id "
"AND kesinti_odenek_turu = :kesinti_odenek_turu ");
sql_query.SET_VALUE( ":kes_ode_tanim_id", record_id );
sql_query.SET_VALUE( ":kesinti_odenek_turu", m_fis_turu );
if ( sql_query.SELECT() EQ 0 ) {
return ADAK_FAIL;
}
sql_query.NEXT();
m_odenek_kesinti_no = sql_query.VALUE("kesinti_odenek_no").toInt();
m_bordrosu_kesildi_mi = sql_query.VALUE("bordrosu_kesildi_mi").toInt();
m_ui->lineEdit_odenek_kesinti_adi->setText( sql_query.VALUE("kesinti_odenek_adi").toString() );
m_ui->adakDate_odenek_kesinti_tarihi->SET_DATE( sql_query.VALUE("kesinti_odenek_tarihi").toString() );
FIND_AND_SET_COMBOBOX_TEXT( m_ui->comboBox_bordro_donemi_ay, K9_GET_AYLAR_STRING( sql_query.VALUE("bordro_donemi_ay").toInt()));
FIND_AND_SET_COMBOBOX_TEXT( m_ui->comboBox_bordro_donemi_yil, sql_query.VALUE("bordro_donemi_yil").toString() );
FIND_AND_SET_COMBOBOX_TEXT( m_ui->comboBox_yuzde_mi, tr("TUTAR"));
if ( sql_query.VALUE( "yuzde_mi").toInt() EQ PRS_YUZDE ) {
FIND_AND_SET_COMBOBOX_TEXT( m_ui->comboBox_yuzde_mi, tr("YÜZDE"));
}
m_ui->commaEdit_tutar->SET_DOUBLE( sql_query.VALUE("tutar").toDouble());
m_ui->checkBox_ssk_kesintisi->setChecked( sql_query.VALUE("ssk_kesintisi_iceriyor_mu").toInt() );
m_ui->checkBox_gelir_vergisi_kesintisi->setChecked( sql_query.VALUE("gelir_vergisi_iceriyor_mu").toInt() );
m_ui->checkBox_damga_vergisi_kesintisi->setChecked( sql_query.VALUE("damga_vergisi_iceriyor_mu").toInt() );
query.PREPARE_SELECT ( "prs_ek_kesintiler_odenekler, prs_personeller",
"kesinti_odenek_id, prs_ek_kesintiler_odenekler.personel_id, cari_hesap_id, order_number ",
"prs_ek_kesintiler_odenekler.personel_id = prs_personeller.personel_id "
"AND kes_ode_tanim_id = :kes_ode_tanim_id ");
query.SET_VALUE ( ":kes_ode_tanim_id" , record_id );
query.SELECT("order_number ASC" );
while ( query.NEXT() EQ true ) {
int p_current_row;
p_current_row = ADD_NEW_LINE ();
QSearchEdit * search_edit_persosnel_kodu = ( QSearchEdit * ) m_ui->table_widget->cellWidget ( p_current_row, PERSONEL_KODU );
QLineEdit * lineedit_personel_adi_soyadi = ( QLineEdit * ) m_ui->table_widget->cellWidget ( p_current_row, PERSONEL_AD_SOYAD );
search_edit_persosnel_kodu->SET_TEXT( CARI_FIND_HESAP_KODU( query.VALUE("cari_hesap_id").toInt()));
lineedit_personel_adi_soyadi->setText( CARI_FIND_HESAP_ISMI( query.VALUE("cari_hesap_id").toInt() ));
QString id = query.VALUE("kesinti_odenek_id").toString();
QString order_number = query.VALUE("order_number").toString();
QTableWidgetItem * new_item;
new_item = new QTableWidgetItem(tr("%1").arg(id));
m_ui->table_widget->setItem(p_current_row, ROW_ID_COLUMN, new_item);
new_item = new QTableWidgetItem(tr("%1").arg(record_id));
m_ui->table_widget->setItem(p_current_row, RECORD_ID_COLUMN, new_item);
new_item = new QTableWidgetItem(tr("%1").arg(order_number));
m_ui->table_widget->setItem(p_current_row, ORDER_NUMBER_COLUMN, new_item);
}
return ADAK_OK;
}
int ADRES_TELEFON_FISI::GET_FIS_RECORD ( int p_adres_id )
{
SQL_QUERY sql_query ( DB );
sql_query.PREPARE_SELECT ( "adr_adresler","firma_sahis_adi,adres_kart_turu","adres_id = :adres_id" );
sql_query.SET_VALUE ( ":adres_id", p_adres_id );
if ( sql_query.SELECT() EQ 0 ) {
return ADAK_FAIL;
}
sql_query.NEXT();
m_ui->label_firma_sahis_adi->setText ( sql_query.VALUE(0).toString());
if (sql_query.VALUE(1) EQ FIRMA_KAYDI ) {
m_ui->tableWidget_telefonlar->hideColumn ( IS_DAHILI_TELEFON_COLUMN );
}
sql_query.PREPARE_SELECT ( "adr_telefonlar","telefon_id, order_number, telefon_ulke_kodu, telefon_alan_kodu, "
"telefon, telefon_dahili,aciklama ","adres_kayit_id = :adres_kayit_id AND gizli_kayit = :gizli_kayit ");
sql_query.SET_VALUE ( ":adres_kayit_id", p_adres_id );
sql_query.SET_VALUE ( ":gizli_kayit" , 0);
if ( sql_query.SELECT("order_number") EQ 0 ) {
return ADAK_OK;
}
int current_row = 0;
while ( sql_query.NEXT() EQ true ) {
current_row = ADD_NEW_LINE ();
QComboBox * comboBox_ulke_kodu = ( QComboBox * ) m_ui->tableWidget_telefonlar->cellWidget ( current_row, TEL_ULKE_KODU_COLUMN );
QComboBox * comboBox_alan_kodu = ( QComboBox * ) m_ui->tableWidget_telefonlar->cellWidget ( current_row, TEL_ALAN_KODU_COLUMN );
QLineEdit * lineEdit_telefon = ( QLineEdit * ) m_ui->tableWidget_telefonlar->cellWidget ( current_row, TELEFON_COLUMN );
QCommaEdit * commaEdit_dahili = ( QCommaEdit * ) m_ui->tableWidget_telefonlar->cellWidget ( current_row, IS_DAHILI_TELEFON_COLUMN );
QLineEdit * lineEdit_aciklama = ( QLineEdit * ) m_ui->tableWidget_telefonlar->cellWidget ( current_row, ACIKLAMA_COLUMN );
QTableWidgetItem * telefon_id_item = new QTableWidgetItem ( sql_query.VALUE(0).toString() );
QTableWidgetItem * adres_id_item = new QTableWidgetItem ( QVariant ( p_adres_id ).toString() );
QTableWidgetItem * telefon_order_item = new QTableWidgetItem ( sql_query.VALUE(1).toString() );
FIND_AND_SET_COMBOBOX_TEXT ( comboBox_ulke_kodu, sql_query.VALUE(2).toString() );
GET_ALAN_KODLARI ( comboBox_alan_kodu, comboBox_ulke_kodu->currentText() );
FIND_AND_SET_COMBOBOX_TEXT ( comboBox_alan_kodu, sql_query.VALUE(3).toString() );
lineEdit_telefon->setText ( sql_query.VALUE(4).toString() );
commaEdit_dahili->SET_INTEGER ( sql_query.VALUE(5).toInt() );
lineEdit_aciklama->setText(sql_query.VALUE(6).toString());
m_ui->tableWidget_telefonlar->setItem ( current_row, TELEFON_ID_COLUMN, telefon_id_item );
m_ui->tableWidget_telefonlar->setItem ( current_row, KAYIT_ID_COLUMN, adres_id_item );
m_ui->tableWidget_telefonlar->setItem ( current_row, TELEFON_ORDER_NUM, telefon_order_item );
}
return ADAK_OK;
}
int SQL_TABLOLAR_FISI::GET_FIS_RECORD ( int p_tablo_id )
{
SQL_QUERY sql_query (DB);
sql_query.PREPARE_SELECT ( "sql_tablolar","tablo_adi,aciklama","tablo_id = :tablo_id");
sql_query.SET_VALUE ( ":tablo_id", p_tablo_id );
if ( sql_query.SELECT() EQ 0 ) {
return ADAK_FAIL;
}
sql_query.NEXT();
m_ui->lineEdit_tablo_adi->setText( sql_query.VALUE(0).toString());
m_ui->limitedTextEdit_aciklama->setText( sql_query.VALUE(1).toString());
sql_query.PREPARE_SELECT ( "sql_alanlar","alan_id, tablo_id, alan_order_num, alan_adi, veritabanindaki_adi, alan_tipi, "
"uzunluk, auto_increment_mi, not_null_mi, dizi_mi, dizi_boyutu, aciklama ",
"tablo_id = :tablo_id" );
sql_query.SET_VALUE ( ":tablo_id" , p_tablo_id );
if ( sql_query.SELECT("alan_order_num") EQ 0 ) {
return ADAK_OK;
}
while ( sql_query.NEXT() EQ true ) {
if ( sql_query.VALUE(2).toInt() EQ 1 ) {
m_ui->lineEdit_alan_adi->setText(sql_query.VALUE(3).toString());
continue;
}
int current_row = ADD_NEW_LINE();
QString alan_id = sql_query.VALUE(0).toString();
QString alan_order_num = sql_query.VALUE(2).toString();
QString alan_adi = sql_query.VALUE(3).toString();
QString alan_tipi = sql_query.VALUE(5).toString();
QString alan_uzunlugu = sql_query.VALUE(6).toString();
QString auto_increment_mi = sql_query.VALUE(7).toString();
QString not_null_mi = sql_query.VALUE(8).toString();
QString dizi_mi = sql_query.VALUE(9).toString();
QString dizi_boyutu = sql_query.VALUE(10).toString();
QString aciklama = sql_query.VALUE(11).toString();
QComboBox * cell_combobox = ( QComboBox * ) m_ui->tablewidget_tablo_satirlari->cellWidget( current_row, ALAN_TIPI_COLUMN );
cell_combobox->setCurrentIndex( GET_ADAK_SQL_ENUM (alan_tipi) );
QCheckBox * cell_checkbox = ( QCheckBox * ) m_ui->tablewidget_tablo_satirlari->cellWidget ( current_row, DIZI_MI_COLUMN );
cell_checkbox->setChecked(dizi_mi.toInt());
if ( dizi_mi.toInt() > 0 ) {
QCommaEdit * dizi_boyutu_commaedit = ( QCommaEdit * ) m_ui->tablewidget_tablo_satirlari->cellWidget ( current_row, DIZI_BOYUT_COLUMN );
dizi_boyutu_commaedit->setEnabled(true);
}
cell_checkbox = ( QCheckBox * ) m_ui->tablewidget_tablo_satirlari->cellWidget ( current_row, AUTO_INCREMENT_COLUMN );
cell_checkbox->setChecked( auto_increment_mi.toInt() );
cell_checkbox = ( QCheckBox * ) m_ui->tablewidget_tablo_satirlari->cellWidget ( current_row, NOT_NULL_COLUMN );
cell_checkbox->setChecked( not_null_mi.toInt() );
QTableWidgetItem * new_item;
new_item = new QTableWidgetItem(tr("%1").arg(alan_id));
m_ui->tablewidget_tablo_satirlari->setItem(current_row, ROW_ID_COLUMN, new_item);
new_item = new QTableWidgetItem(tr("%1").arg(p_tablo_id));
m_ui->tablewidget_tablo_satirlari->setItem(current_row, TABLO_ID_COLUMN, new_item);
new_item = new QTableWidgetItem(tr("%1").arg(alan_order_num));
m_ui->tablewidget_tablo_satirlari->setItem(current_row, ORDER_COLUMN, new_item);
QCommaEdit * commaEdit = ( QCommaEdit * ) m_ui->tablewidget_tablo_satirlari->cellWidget(current_row, ALAN_BOYUT_COLUMN);
commaEdit->SET_INTEGER(alan_uzunlugu.toInt());
commaEdit = ( QCommaEdit * ) m_ui->tablewidget_tablo_satirlari->cellWidget(current_row, DIZI_BOYUT_COLUMN);
commaEdit->SET_INTEGER(dizi_boyutu.toInt());
QLineEdit * lineEdit = ( QLineEdit * ) m_ui->tablewidget_tablo_satirlari->cellWidget(current_row, ACIKLAMA_COLUMN );
lineEdit->setText(aciklama);
lineEdit = ( QLineEdit * ) m_ui->tablewidget_tablo_satirlari->cellWidget(current_row, ALAN_ADI_COLUMN );
lineEdit->setText(alan_adi);
}
return ADAK_OK;
}
