void PRS_PERSONEL_AILE_FISI::SETUP_FORM()
{
SET_HELP_PAGE ( "personel-sicil-karti" );
SET_PAGE_TITLE ( tr ( "PRS - AİLE FİŞİ" ) );
int num_of_columns = 12;
SET_SINGLE_RECORD_ID (m_record_id);
REGISTER_BUTTONS_WIDGET ( navigation_button_widget );
REGISTER_TABLE_WIDGET ( table_widget_aile_satirlari , num_of_columns );
SET_FORM_ID_COLUMN_POSITION ( RECORD_ID_COLUMN );
SET_FIS_ORDER_COLUMN_NUMBER ( ORDER_COLUMN );
SET_ROW_ID_COLUMN_POSITION ( ROW_ID_COLUMN );
SET_NUMBER_OF_HIDDEN_COLUMN ( 3 );
SET_FIS_ORDER_DATABASE ( "prs_personel_aile_bilgileri", "order_number", "aile_bilgi_id" );
SET_TABLE_ROW_WIDGETS ( AD_SOYAD_COLUMN , WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( TC_KIMLIK_NO_COLUMN , WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( AKRABALIK_DERECESI_COLUMN , WIDGET_COMBO_BOX );
SET_TABLE_ROW_WIDGETS ( CALISMA_DURUMU_COLUMN , WIDGET_COMBO_BOX );
SET_TABLE_ROW_WIDGETS ( DOGUM_TARIHI_COLUMN , WIDGET_ADAK_DATE);
SET_TABLE_ROW_WIDGETS ( EGITIM_DURUMU_COLUMN , WIDGET_COMBO_BOX );
SET_TABLE_ROW_WIDGETS ( CINSIYET_COLUMN , WIDGET_COMBO_BOX );
SET_TABLE_ROW_WIDGETS ( ASGARI_GECIM_IND_DURUMU_COLUMN , WIDGET_COMBO_BOX );
SET_TABLE_ROW_WIDGETS ( ACIKLAMA_COLUMN , WIDGET_LINE_EDIT );
table_widget_aile_satirlari->setHorizontalHeaderLabels(QStringList()<<"id"<<"record_id"<<"satir_order"
<<tr("Ad Soyad") <<tr("TC Kimlik No")<<tr("Akrabalık\n Derecesi")<<tr("Ç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("") );
table_widget_aile_satirlari->setColumnWidth ( AD_SOYAD_COLUMN , 150 );
table_widget_aile_satirlari->setColumnWidth ( TC_KIMLIK_NO_COLUMN , 150 );
table_widget_aile_satirlari->setColumnWidth ( AKRABALIK_DERECESI_COLUMN , 140 );
table_widget_aile_satirlari->setColumnWidth ( CALISMA_DURUMU_COLUMN , 180 );
table_widget_aile_satirlari->setColumnWidth ( DOGUM_TARIHI_COLUMN , 250 );
table_widget_aile_satirlari->setColumnWidth ( EGITIM_DURUMU_COLUMN , 150 );
table_widget_aile_satirlari->setColumnWidth ( CINSIYET_COLUMN , 120 );
table_widget_aile_satirlari->setColumnWidth ( ASGARI_GECIM_IND_DURUMU_COLUMN , 140 );
table_widget_aile_satirlari->setColumnWidth ( ACIKLAMA_COLUMN , 150 );
SET_SETTING_NAME ( "PRS_PERSONEL_VE_AILE_FISI" );
SET_FIRST_FOCUS_WIDGET ( table_widget_aile_satirlari );
FOCUS_FIRST_WIDGET();
SET_WIDGETS_MAXIMUM_SIZE ();
line_edit_personel_sicil_no->setReadOnly(true);
line_edit_personel_adi->setReadOnly(true);
}
void TREE_KERNEL::INIT_KERNEL ( QObject * parent,ADAK_SQL * database )
{
SET_ADAK_WINDOW_DEFAULTS ( parent );
SET_DB_CONN ( database );
m_tree_widget->setHeaderLabels(m_column_headers);
SET_TREE_WIDGET_DEFAULTS();
ADD_PARENT_ITEMS();
FOCUS_FIRST_WIDGET();
}
void CARI_HESAP_EKSTRESI_BATCH::SETUP_FORM()
{
SET_HELP_PAGE ( "cari-hesap-islemleri_cari-hesap-ekstresi" );
SET_PAGE_TITLE ( tr ( "CARİ - CARİ HESAP EKSTRESİ" ) ) ;
REGISTER_BUTTON_WIDGET ( m_ui->widget_batch_buttons );
m_ui->adakDate_bsl_tarihi->SET_DATE( MALI_YIL_FIRST_DATE() );
m_ui->adakDate_bts_tarihi->SET_DATE( MALI_ARRAY_LAST_DATE() );
m_ui->checkbox_tek_hesap->setChecked( true );
m_ui->frame_tek_hesap->setEnabled( true );
m_ui->checkbox_bakiyesiz_hesaplar->setChecked( true );
m_ui->checkbox_bakiyesiz_hesaplar->setEnabled( false );
m_ui->frame_hesap_araligi->setDisabled ( true );
m_ui->frame_bakiyesiz_hesaplar->setDisabled ( true );
m_ui->frame_calismamis_hesaplar->setDisabled ( true );
SET_NAME_OF_RUN_BATCH_BUTTON ( tr ( "Rapor Al" ) );
SET_FIRST_FOCUS_WIDGET ( m_ui->searchedit_tek_hesap );
FOCUS_FIRST_WIDGET ();
if ( m_cari_hesap_id NE -1 ) {
m_ui->checkbox_tek_hesap->setChecked(true);
m_ui->frame_hesap_araligi->setDisabled(true);
m_ui->checkbox_hesap_araligi->setCheckState(Qt::Unchecked);
m_ui->frame_tek_hesap->setEnabled(true);
SQL_QUERY query(DB);
query.PREPARE_SELECT("car_hesaplar","cari_hesap_kodu,adres_id","cari_hesap_id = :cari_hesap_id");
query.SET_VALUE(":cari_hesap_id" , m_cari_hesap_id);
if( query.SELECT() NE 0 ) {
query.NEXT();
m_ui->searchedit_tek_hesap->SET_TEXT(query.VALUE(0).toString());
m_ui->lineedit_tek_hesap_ismi->setText(ADR_GET_FIRMA_SAHIS_ADI(query.VALUE(0).toInt()));
}
}
if ( E9_KULLANICI_SIRKET_DEGISTIRE_BILIR_MI() EQ EVET ) {
m_ui->frame_entegre_filtresi->setVisible( true );
}
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
SET_SETTING_NAME ( "CARI_HESAP_EKSTRESI" );
}
void BNK_BANKA_DEFTERI_BATCH::SETUP_FORM()
{
SET_HELP_PAGE ("banka-islemleri_banka-defteri" );
SET_PAGE_TITLE ( tr ( "BNK - BANKA DEFTERİ" ) );
REGISTER_BUTTON_WIDGET(m_ui->widget_batch_buttons);
m_ui->adakDate_bsl_tarihi->SET_DATE(MALI_YIL_FIRST_DATE());
m_ui->adakDate_bts_tarihi->SET_DATE(MALI_ARRAY_LAST_DATE());
m_ui->combo_box_banka_hesap_kodu->setEditable(false);
SET_NAME_OF_RUN_BATCH_BUTTON("Rapor Al");
SET_ENTER_KEY_FOR_RUN_BATCH(true);
SET_FIRST_FOCUS_WIDGET(m_ui->combo_box_banka_hesap_kodu);
FOCUS_FIRST_WIDGET();
SET_ENTER_KEY_FOR_RUN_BATCH(true);
BNK_FILL_COMBO_BOX_BANKA_HESAPLARI(m_ui->combo_box_banka_hesap_kodu);
m_bnk_hesap_no_id = 0;
SET_SETTING_NAME ( "BANKA_DEFTERI_BATCH" );
m_ui->frame_entegre_filtresi->setVisible(false);
K9_FILL_COMBOBOX_RAPOR_SIRKET_FILTRESI(m_ui->comboBox_sirket_filtresi);
if ( K9_KULLANICININ_CALISTIGI_SIRKET() EQ 1 ) {
m_ui->comboBox_sirket_filtresi->setCurrentIndex( m_ui->comboBox_sirket_filtresi->findText(K9_GET_RAPOR_SIRKET_FILTRESI_STRING(FIS_BIRINCI_SIRKET)));
}
else {
m_ui->comboBox_sirket_filtresi->setCurrentIndex( m_ui->comboBox_sirket_filtresi->findText(K9_GET_RAPOR_SIRKET_FILTRESI_STRING(FIS_HER_IKI_SIRKET)));
}
if ( K9_KULLANICI_ENT_BILGILERINI_DEGISTIREBILIR_MI() EQ 1 ) {
m_ui->frame_entegre_filtresi->setVisible(true);
m_ui->comboBox_sirket_filtresi->setCurrentIndex(m_ui->comboBox_sirket_filtresi->findText(K9_GET_RAPOR_SIRKET_FILTRESI_STRING(FIS_HER_IKI_SIRKET)));
}
}
void TREE_ARAMA_KERNEL::INIT_KERNEL ( QTreeWidget * tree_widget ,QObject * parent,ADAK_SQL * database )
{
Q_UNUSED ( parent );
m_tree_widget = tree_widget;
m_tree_widget->setHeaderLabels(m_headers);
SET_ADAK_WINDOW_DEFAULTS ( parent );
SET_EVENTS_AND_SIGNALS ( parent, ADAK_BATCH_KERNEL );
SET_DB_CONN ( database );
m_tree_widget->setEditTriggers ( QTreeView::NoEditTriggers );
SET_TREE_WIDGET_DEFAULTS();
FOCUS_FIRST_WIDGET();
connect(m_tree_widget , SIGNAL ( clicked ( QModelIndex)) ,this, SLOT ( SLOT_ROW_CLICKED() ) );
connect(m_tree_widget , SIGNAL ( doubleClicked ( QModelIndex)),this, SLOT ( FIND_SELECTED_ROW() ) );
connect(m_tree_widget , SIGNAL ( activated ( QModelIndex)) ,this, SLOT ( FIND_SELECTED_ROW() ) );
}
void ADRES_TELEFON_FISI::SETUP_FORM()
{
SET_HELP_PAGE ( tr("telefon-fisi") );
SET_PAGE_TITLE ( tr ( "ADR - TELEFONLAR" ) );
SET_SETTING_NAME ( "ADRES_TELEFON_FISI" );
SET_SINGLE_RECORD_ID ( m_adres_id );
REGISTER_BUTTONS_WIDGET ( m_ui->kernel_buttons_widget, true );
REGISTER_TABLE_WIDGET ( m_ui->tableWidget_telefonlar, 8 );
SET_FIS_ORDER_COLUMN_NUMBER ( TELEFON_ORDER_NUM );
SET_FORM_ID_COLUMN_POSITION ( KAYIT_ID_COLUMN );
SET_ROW_ID_COLUMN_POSITION ( TELEFON_ID_COLUMN );
SET_NUMBER_OF_HIDDEN_COLUMN ( 3 );
SET_FIS_ORDER_DATABASE ("adr_telefonlar", "order_number", "telefon_id" );
SET_TABLE_ROW_WIDGETS ( TEL_ULKE_KODU_COLUMN, WIDGET_COMBO_BOX );
SET_TABLE_ROW_WIDGETS ( TEL_ALAN_KODU_COLUMN, WIDGET_COMBO_BOX );
SET_TABLE_ROW_WIDGETS ( TELEFON_COLUMN, WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( IS_DAHILI_TELEFON_COLUMN, WIDGET_COMMA_EDIT );
SET_TABLE_ROW_WIDGETS ( ACIKLAMA_COLUMN, WIDGET_LINE_EDIT );
m_ui->tableWidget_telefonlar->setHorizontalHeaderLabels(QStringList()<<"telefon_id"<<"adres_id"<<"order_column"
<<tr ( "Ülke kodu" )<<tr ( "Alan Kodu" )
<<tr ( "Telefon" )<<tr("Dahili")<<tr("Açıklama")<<tr ( "" )<<tr("") );
m_ui->tableWidget_telefonlar->setColumnWidth ( TEL_ULKE_KODU_COLUMN, 90 );
m_ui->tableWidget_telefonlar->setColumnWidth ( TEL_ALAN_KODU_COLUMN, 90 );
m_ui->tableWidget_telefonlar->setColumnWidth ( TELEFON_COLUMN, 110 );
m_ui->tableWidget_telefonlar->setColumnWidth ( IS_DAHILI_TELEFON_COLUMN, 90 );
m_ui->tableWidget_telefonlar->setColumnWidth ( ACIKLAMA_COLUMN, 170 );
m_ui->tableWidget_telefonlar->setSelectionMode ( QAbstractItemView::NoSelection );
m_ui->tableWidget_telefonlar->setFocus ( Qt::OtherFocusReason );
FOCUS_FIRST_WIDGET ();
}
void DMR_DEMIRBAS_KARTI::SETUP_FORM()
{
SET_HELP_PAGE ( "sabit-kiymetler-demirbaslar_sabit-kiymet-kaydi" );
SET_PAGE_TITLE ( tr ( "DMR - SABİT KIYMET KAYDI" ) );
REGISTER_BUTTONS_WIDGET ( m_ui->navigation_buttons_widget );
SET_FIRST_FOCUS_WIDGET ( m_ui->lineedit_demirbas_kodu );
REGISTER_CHANGER_BUTTON(m_ui->pushButton_guplar);
REGISTER_CHANGER_BUTTON(m_ui->pushButton_fatura_sec);
m_ui->lineEdit_temel_para_birimi->setText(DVZ_GET_TEMEL_PARA_BIRIMI_KODU());
m_ui->comboBox_amortisman_yontemi->addItems ( QStringList() << "Normal Bakiye" << "Azalan Bakiye" );
DISABLE_CLEAR_ON_WIDGET(m_ui->lineEdit_temel_para_birimi);
m_ui->checkBox_yeniden_degerleme->setChecked ( true );
SET_SETTING_NAME ( "DMR_DEMIRBAS_KARTI" );
FOCUS_FIRST_WIDGET ();
m_ui->lineedit_amortisman_suresi->setMaxLength(2);
m_ui->lineedit_demirbas_adi->setMaxLength(128);
m_ui->lineedit_demirbas_kodu->setMaxLength(20);
m_ui->lineedit_garanti_suresi->setMaxLength(2);
m_ui->lineEdit_marka->setMaxLength(128);
m_ui->lineEdit_model->setMaxLength(128);
m_ui->lineedit_muh_hesap_ismi->setMaxLength(60);
m_ui->lineEdit_seri_no->setMaxLength(20);
m_ui->lineEdit_uretici_firma->setMaxLength(128);
DISABLE_CLEAR_ON_WIDGET(m_ui->checkBox_amortisman_ayrilacak_mi);
m_ui->checkBox_amortisman_ayrilacak_mi->setChecked(true);
DISABLE_CLEAR_ON_WIDGET(m_ui->comboBox_amortisman_yontemi);
DISABLE_CLEAR_ON_WIDGET(m_ui->searchedit_muh_hesap_kodu);
DISABLE_CLEAR_ON_WIDGET(m_ui->lineedit_muh_hesap_ismi );
DISABLE_CLEAR_ON_WIDGET(m_ui->searchedit_amor_gdr_hesap_kodu);
DISABLE_CLEAR_ON_WIDGET(m_ui->lineEdit_amor_gdr_hesap_ismi );
DISABLE_CLEAR_ON_WIDGET(m_ui->searchedit_bir_amortisman_hesap_kodu);
DISABLE_CLEAR_ON_WIDGET(m_ui->lineEdit_bir_amortisman_hesap_ismi );
DISABLE_CLEAR_ON_WIDGET(m_ui->searchEdit_sube_kodu);
DISABLE_CLEAR_ON_WIDGET(m_ui->lineEdit_sube_ismi);
DISABLE_CLEAR_ON_WIDGET(m_ui->searchedit_dmr_satis_kar_hesap_kodu);
DISABLE_CLEAR_ON_WIDGET(m_ui->lineEdit_dmr_satis_kar_hesap_ismi);
DISABLE_CLEAR_ON_WIDGET(m_ui->searchedit_dmr_satis_zarar_hesap_kodu);
DISABLE_CLEAR_ON_WIDGET(m_ui->lineEdit_dmr_satis_zarar_hesap_ismi);
SQL_QUERY query(DB);
m_grup_id = -1;
m_muh_hesap_id = 0;
m_fatura_id = 0;
m_amor_gider_hesap_id = 0;
m_bir_amor_hesap_id = 0;
m_dmr_satis_kar_hesap_id = 0;
QString demirbas_hesap_kodu, demirbas_hesap_adi;
m_muh_hesap_id = SUBE_GET_SUBE_ENT_HESAP_ID( SUBE_GET_SUBE_ID(), "demirbaslar_ent_hesap_id", &demirbas_hesap_kodu, &demirbas_hesap_adi );
m_ui->searchedit_muh_hesap_kodu->SET_TEXT ( demirbas_hesap_kodu );
m_ui->lineedit_muh_hesap_ismi->setText ( demirbas_hesap_adi );
QString amortisman_hesap_kodu, amortisman_hesap_adi;
m_bir_amor_hesap_id = SUBE_GET_SUBE_ENT_HESAP_ID( SUBE_GET_SUBE_ID(), "bir_amortismanlar_hsp_id", &amortisman_hesap_kodu, &amortisman_hesap_adi );
m_ui->searchedit_bir_amortisman_hesap_kodu->SET_TEXT ( amortisman_hesap_kodu );
m_ui->lineEdit_bir_amortisman_hesap_ismi->setText ( amortisman_hesap_adi );
QString amor_gider_hesap_kodu, amor_gider_hesap_adi;
m_amor_gider_hesap_id = SUBE_GET_SUBE_ENT_HESAP_ID( SUBE_GET_SUBE_ID(), "amor_giderleri_hsp_id", &amor_gider_hesap_kodu, &amor_gider_hesap_adi );
m_ui->searchedit_amor_gdr_hesap_kodu->SET_TEXT ( amortisman_hesap_kodu );
m_ui->lineEdit_amor_gdr_hesap_ismi->setText ( amortisman_hesap_adi );
QString dmr_satis_kar_hesap_kodu, dmr_satis_kar_hesap_adi;
m_dmr_satis_kar_hesap_id = SUBE_GET_SUBE_ENT_HESAP_ID( SUBE_GET_SUBE_ID(), "dmr_satis_kar_ent_hesap_id", &dmr_satis_kar_hesap_kodu, &dmr_satis_kar_hesap_adi );
m_ui->searchedit_dmr_satis_kar_hesap_kodu->SET_TEXT ( dmr_satis_kar_hesap_kodu );
m_ui->lineEdit_dmr_satis_kar_hesap_ismi->setText ( dmr_satis_kar_hesap_adi );
QString dmr_satis_zarar_hesap_kodu, dmr_satis_zarar_hesap_adi;
m_dmr_satis_zarar_hesap_id = SUBE_GET_SUBE_ENT_HESAP_ID( SUBE_GET_SUBE_ID(), "dmr_satis_zarar_ent_hesap_id", &dmr_satis_zarar_hesap_kodu, &dmr_satis_zarar_hesap_adi );
m_ui->searchedit_dmr_satis_zarar_hesap_kodu->SET_TEXT ( dmr_satis_zarar_hesap_kodu );
m_ui->lineEdit_dmr_satis_zarar_hesap_ismi->setText ( dmr_satis_zarar_hesap_adi );
if ( E9_KULLANICI_ENT_BILGILERINI_DEGISTIREBILIR_MI() EQ 0 ) {
m_ui->searchedit_muh_hesap_kodu->setHidden(true);
m_ui->lineedit_muh_hesap_ismi->setHidden(true);
m_ui->label_muhasebe_hesabi->setHidden(true);
}
m_sube_id = 1;
QString sube_kodu, sube_adi;
SUBE_GET_SUBE_KODU_ADI( m_sube_id, &sube_kodu, &sube_adi );
m_ui->searchEdit_sube_kodu->SET_TEXT( sube_kodu );
m_ui->lineEdit_sube_ismi->setText( sube_adi );
}
void BATCH_KERNEL::INIT_KERNEL ()
{
FOCUS_FIRST_WIDGET();
}
void PRK_GELIR_GIDER_TURLERI_FISI::SETUP_FORM()
{
if ( m_gider_turu_mu EQ 1 ) {
SET_PAGE_TITLE ( tr ( "PRK - ALIŞ / GİDER TÜRLERİ" ) );
SET_HELP_PAGE ("kasa-perakende_alisgider-turlari");
}
else {
SET_PAGE_TITLE ( tr ( "PRK - SATIŞ / GELİR TÜRLERİ" ) );
SET_HELP_PAGE ("kasa-perakende_satisgelir-turleri");
}
DISABLE_CLEAR_ON_WIDGET(m_ui->searchEdit_sube_kodu);
DISABLE_CLEAR_ON_WIDGET(m_ui->lineEdit_sube_ismi);
SET_SETTING_NAME ("PRK_GELIR_GIDER_TURLERI_FISI");
QString sube_kodu, sube_adi;
SUBE_GET_SUBE_KODU_ADI( m_sube_id, &sube_kodu, &sube_adi );
SET_SINGLE_RECORD_ID ( m_sube_id);
REGISTER_BUTTONS_WIDGET ( m_ui->kernel_buttons_widget );
m_ui->searchEdit_sube_kodu->SET_TEXT(sube_kodu);
m_ui->searchEdit_sube_kodu->setDisabled(true);
m_ui->lineEdit_sube_ismi->setText(sube_adi);
m_ui->lineEdit_sube_ismi->setDisabled(true);
if ( SUBE_GET_SUBE_ISLEM_YETKISI() EQ SADECE_UNITE_SUBESINDE ) {
m_ui->searchEdit_sube_kodu->setHidden(true);
m_ui->lineEdit_sube_ismi->setHidden(true);
m_ui->label_sube_kodu->setHidden(true);
}
SET_FIRST_FOCUS_WIDGET( m_ui->tablewidget_fis_satirlari );
REGISTER_TABLE_WIDGET ( m_ui->tablewidget_fis_satirlari, 7 );
SET_FIS_ORDER_COLUMN_NUMBER ( ORDER_NUMBER_COLUMN );
SET_FORM_ID_COLUMN_POSITION ( FIS_ID_COLUMN );
SET_ROW_ID_COLUMN_POSITION ( ROW_ID_COLUMN );
SET_NUMBER_OF_HIDDEN_COLUMN ( 4 );
SET_FIS_ORDER_DATABASE ("prk_gelir_gider_turleri", "order_number", "tur_id" );
SET_TABLE_ROW_WIDGETS ( GELIR_GIDER_ADI_COLUMN , WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( HESAP_KODU_COLUMN , WIDGET_SEARCH_EDIT );
SET_TABLE_ROW_WIDGETS ( HESAP_ISMI_COLUMN , WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( HESAP_ID_COLUMN , WIDGET_LINE_EDIT );
if ( m_gider_turu_mu EQ 1 ) {
m_ui->tablewidget_fis_satirlari->setHorizontalHeaderLabels
(QStringList() << "row_id" << "fis_id" << "order_number_column"<<"gider hsp id"
<< tr("Gider Türü") << tr("Gider Hesabı Kodu")
<< tr("Gider Hesabı İsmi") << tr("") << tr("") );
}
else {
m_ui->tablewidget_fis_satirlari->setHorizontalHeaderLabels
(QStringList() << "row_id" << "fis_id" << "order_number_column"<<"gelir hsp id"
<< tr("Gelir Türü") << tr("Gelir Hesabı Kodu")
<< tr("Gelir Hesabı İsmi") << tr("") << tr("") );
}
m_ui->tablewidget_fis_satirlari->setColumnWidth(GELIR_GIDER_ADI_COLUMN , 300);
m_ui->tablewidget_fis_satirlari->setColumnWidth(HESAP_KODU_COLUMN , 150);
m_ui->tablewidget_fis_satirlari->setColumnWidth(HESAP_ISMI_COLUMN , 300);
m_ui->lineEdit_sube_ismi->setMaxLength(30);
if ( K9_KULLANICI_ENT_BILGILERINI_DEGISTIREBILIR_MI() EQ 0 ) {
m_ui->tablewidget_fis_satirlari->hideColumn(HESAP_KODU_COLUMN);
m_ui->tablewidget_fis_satirlari->hideColumn(HESAP_ISMI_COLUMN);
}
FOCUS_FIRST_WIDGET ();
}
void PRS_PERSONEL_ODENEK_EKLEME_FISI::SETUP_FORM()
{
SET_HELP_PAGE ( "personel-bordrosu_ek-odenek-tanimlama" );
SET_PAGE_TITLE ( tr ( "PRS - EK ÖDENEK EKLEME" ) );
SET_SETTING_NAME ( "PRS_PERSONEL_ODENEK_EKLEME_FISI" );
int num_of_columns = 13;
if ( m_who_called EQ PRS_PERSONEL_SICIL_KARTI ) {
SET_SINGLE_RECORD_ID (m_record_id);
}
REGISTER_BUTTONS_WIDGET ( navigation_button_widget);
SET_WIDGETS_MAXIMUM_SIZE ();
REGISTER_TABLE_WIDGET ( table_widget_odenek_satirlari , num_of_columns );
SET_FORM_ID_COLUMN_POSITION ( RECORD_ID_COLUMN );
SET_FIS_ORDER_COLUMN_NUMBER ( ORDER_COLUMN );
SET_ROW_ID_COLUMN_POSITION ( ROW_ID_COLUMN );
SET_NUMBER_OF_HIDDEN_COLUMN ( 3 );
SET_FIS_ORDER_DATABASE ( "prs_ek_kesintiler_odenekler", "order_number", "kesinti_odenek_id" );
SET_TABLE_ROW_WIDGETS ( BORDRO_DONEMI_AY_COLUMN, WIDGET_COMBO_BOX );
SET_TABLE_ROW_WIDGETS ( BORDRO_DONEMI_YIL_COLUMN, WIDGET_COMBO_BOX );
SET_TABLE_ROW_WIDGETS ( ODENEK_ADI_COLUMN, WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( ODENEK_SSK_KESINTISI_ICERIYOR_MU_COLUMN, WIDGET_CHECK_BOX);
SET_TABLE_ROW_WIDGETS ( ODENEK_GELIR_VERGISI_ICERIYOR_MU_COLUMN, WIDGET_CHECK_BOX);
SET_TABLE_ROW_WIDGETS ( ODENEK_DAMGA_VERGISI_ICERIYOR_MU_COLUMN, WIDGET_CHECK_BOX);
SET_TABLE_ROW_WIDGETS ( ODENEK_YUZDE_MI_COLUMN, WIDGET_COMBO_BOX);
SET_TABLE_ROW_WIDGETS ( YUZDE_COLUMN, WIDGET_COMMA_EDIT);
SET_TABLE_ROW_WIDGETS ( TUTAR_COLUMN, WIDGET_COMMA_EDIT );
SET_TABLE_ROW_WIDGETS ( ACIKLAMA_COLUMN, WIDGET_LINE_EDIT );
table_widget_odenek_satirlari->setHorizontalHeaderLabels(QStringList()<<"id"<<"record_id"<<"satir_order"
<<tr("Bordro \nDönemi Ay") <<tr("Bordro \nDönemi Yıl")
<<tr("Ödenek Adı")
<<tr("SSK Kesintisi")<<tr("Gelir Vergisi")<<tr("Damga Vergisi")
<<("Yüzde Mi")<<("Yüzde")<<tr("Tutar")
<<tr("Açıklama")<<tr("")<<tr("") );
table_widget_odenek_satirlari->setColumnWidth ( BORDRO_DONEMI_AY_COLUMN , 120 );
table_widget_odenek_satirlari->setColumnWidth ( BORDRO_DONEMI_YIL_COLUMN , 120 );
table_widget_odenek_satirlari->setColumnWidth ( ODENEK_ADI_COLUMN , 120 );
table_widget_odenek_satirlari->setColumnWidth ( ODENEK_SSK_KESINTISI_ICERIYOR_MU_COLUMN , 180 );
table_widget_odenek_satirlari->setColumnWidth ( ODENEK_GELIR_VERGISI_ICERIYOR_MU_COLUMN , 180 );
table_widget_odenek_satirlari->setColumnWidth ( ODENEK_DAMGA_VERGISI_ICERIYOR_MU_COLUMN , 180 );
table_widget_odenek_satirlari->setColumnWidth ( ODENEK_YUZDE_MI_COLUMN , 120 );
table_widget_odenek_satirlari->setColumnWidth ( YUZDE_COLUMN , 80 );
table_widget_odenek_satirlari->setColumnWidth ( TUTAR_COLUMN , 80 );
table_widget_odenek_satirlari->setColumnWidth ( ACIKLAMA_COLUMN , 150 );
SET_FIRST_FOCUS_WIDGET ( table_widget_odenek_satirlari );
FOCUS_FIRST_WIDGET();
line_edit_personel_sicil_no->setReadOnly(true);
line_edit_personel_adi_soyadi->setReadOnly(true);
}
void PRS_PUANTAJLARI_GOR_VE_DUZELT_FISI::SETUP_FORM()
{
SET_PAGE_TITLE ( tr ( "PRS - PUANTAJ TABLOSU" ) );
SET_HELP_PAGE ( "maas-bordrosu" );
SET_SINGLE_RECORD_ID (m_record_id);
REGISTER_BUTTONS_WIDGET ( m_ui->navigation_button_widget );
int num_of_columns = 13;
REGISTER_SAVER_BUTTON( m_ui->push_button_bordro_al );
REGISTER_TABLE_WIDGET ( m_ui->table_widget_gun_satirlari , num_of_columns );
SET_FIS_ORDER_COLUMN_NUMBER ( ORDER_COLUMN );
SET_FORM_ID_COLUMN_POSITION ( RECORD_ID_COLUMN );
SET_ROW_ID_COLUMN_POSITION ( ROW_ID_COLUMN );
SET_NUMBER_OF_HIDDEN_COLUMN ( 5 );
SET_FIS_ORDER_DATABASE ("puantaj_bilgileri", "order_number", "personel_id" );
SET_TABLE_ROW_WIDGETS ( ADI_COLUMN , WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( CALISTIGI_GUN_COLUMN , WIDGET_COMMA_EDIT);
SET_TABLE_ROW_WIDGETS ( ALDIGI_UCRET , WIDGET_COMMA_EDIT);
SET_TABLE_ROW_WIDGETS ( EK_ODENEK_TUTARI , WIDGET_COMMA_EDIT);
SET_TABLE_ROW_WIDGETS ( EK_KESINTI_TUTARI , WIDGET_COMMA_EDIT);
SET_TABLE_ROW_WIDGETS ( KUR_COLUMN , WIDGET_COMMA_EDIT);
SET_TABLE_ROW_WIDGETS ( TEMEL_PARABIRIMI_UCRET , WIDGET_COMMA_EDIT);
SET_TABLE_ROW_WIDGETS ( CALISMA_SEKLI , WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( YEMEK_VERILEN_GUN_SAYISI , WIDGET_COMMA_EDIT);
SET_TABLE_ROW_WIDGETS ( GUNLUK_UCRET , WIDGET_COMMA_EDIT);
SET_FIRST_FOCUS_WIDGET ( m_ui->table_widget_gun_satirlari);
SET_SETTING_NAME ("PRS_PUANTAJ_GOR_VE_DUZELT_FISI");
m_ui->table_widget_gun_satirlari->setHorizontalHeaderLabels (QStringList() << "row_id" << "record_id"
<< "order_number_column" << tr("") << tr("")<< tr("Adı / Soyadı")
<< tr( "Brüt/Net Ücret" )<< tr("Ek \nÖdenek Tutarı") << tr("Ek \nKesinti Tutarı")
<< tr("Kur") << tr( "Personel Ücret" ) << tr("Yemek Verilen\nGün Sayısı ") << tr("Çalıştığı Gün") << "" <<"" << "");
m_ui->table_widget_gun_satirlari->setColumnWidth( ADI_COLUMN , 200 );
m_ui->table_widget_gun_satirlari->setColumnWidth( ALDIGI_UCRET , 100 );
m_ui->table_widget_gun_satirlari->setColumnWidth( EK_ODENEK_TUTARI , 100 );
m_ui->table_widget_gun_satirlari->setColumnWidth( EK_KESINTI_TUTARI , 100 );
m_ui->table_widget_gun_satirlari->setColumnWidth( KUR_COLUMN , 100 );
m_ui->table_widget_gun_satirlari->setColumnWidth( TEMEL_PARABIRIMI_UCRET , 100 );
m_ui->table_widget_gun_satirlari->setColumnWidth( CALISTIGI_GUN_COLUMN , 100 );
m_ui->table_widget_gun_satirlari->setColumnWidth( YEMEK_VERILEN_GUN_SAYISI , 100 );
m_ui->lineEdit_ay->setDisabled(true);
m_ui->lineEdit_yil->setDisabled(true);
m_ui->lineEdit_sube_adi->setDisabled(true);
m_ui->lineEdit_sube_kodu->setDisabled(true);
DISABLE_CLEAR_ON_WIDGET(m_ui->lineEdit_sube_kodu);
DISABLE_CLEAR_ON_WIDGET(m_ui->lineEdit_sube_adi);
DISABLE_CLEAR_ON_WIDGET(m_ui->lineEdit_yil);
DISABLE_CLEAR_ON_WIDGET(m_ui->lineEdit_ay);
QString sube_kodu, sube_adi;
SUBE_GET_SUBE_KODU_ADI( m_sube_id, &sube_kodu, &sube_adi );
m_ui->lineEdit_sube_kodu->setText ( sube_kodu );
m_ui->lineEdit_sube_adi->setText ( sube_adi );
m_ui->lineEdit_yil->setText(QVariant(m_bordro_yili).toString());
m_ui->lineEdit_ay->setText(QDate::longMonthName(m_bordro_ayi));
FOCUS_FIRST_WIDGET ();
}
void ADRES_YETKILILER_FISI::SETUP_FORM()
{
SET_HELP_PAGE ( tr("firma_yetkilileri_fisi.html") );
SET_PAGE_TITLE ( tr ( "FİRMA YETKİLİLERİ" ) );
SET_SETTING_NAME ( "ADRES_YETKILILER_FISI" );
SET_SINGLE_RECORD_ID(m_start_fis_kernel);
REGISTER_BUTTONS_WIDGET ( m_ui->kernel_buttons_widget );
int num_of_columns = 15;
REGISTER_TABLE_WIDGET ( m_ui->table_widget_yetkililer, num_of_columns );
SET_FIS_ORDER_COLUMN_NUMBER ( ORDER_COLUMN );
SET_FORM_ID_COLUMN_POSITION ( FIRMA_ID_COLUMN );
SET_ROW_ID_COLUMN_POSITION ( YETKILI_ID_COLUMN );
SET_NUMBER_OF_HIDDEN_COLUMN ( 4 );
SET_FIS_ORDER_DATABASE ( "adr_yetkili_bilgileri", "order_number", "yetkili_id" );
SET_TABLE_ROW_WIDGETS ( SAHIS_ID_COLUMN, WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( YETKILI_ADI_SOYADI_COLUMN, WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( YETKILI_GOREVI, WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( YETKILI_EV_TELEFONU, WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( YETKILI_IS_TELEFONU, WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( YETKILI_CEP_TELEFONU, WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( YETKILI_ULKE_KODU, WIDGET_COMBO_BOX );
SET_TABLE_ROW_WIDGETS ( YETKILI_EV_TEL_ALAN_KODU, WIDGET_COMBO_BOX );
SET_TABLE_ROW_WIDGETS ( YETKILI_GSM_KODU, WIDGET_COMBO_BOX );
SET_TABLE_ROW_WIDGETS ( YETKILI_IS_TEL_ALAN_KODU, WIDGET_COMBO_BOX );
SET_TABLE_ROW_WIDGETS ( YETKILI_IS_TELEFONU_DAHILI, WIDGET_COMMA_EDIT );
SET_TABLE_ROW_WIDGETS ( DETAYLAR_BUTTON_COLUMN, WIDGET_PUSH_BUTTON );
SET_FIRST_FOCUS_WIDGET ( m_ui->table_widget_yetkililer );
SET_LINE_BUTTON_ICON ( QStringList()<<"" );
SET_LINE_BUTTON_ICON ( QStringList()<<"" );
m_ui->table_widget_yetkililer->setHorizontalHeaderLabels ( QStringList()<<"id"<<"fis_id"<<"Column Order"
<<tr ( "adres_id" )<<tr ( "Yetkili Adı Soyadı" )
<<tr ( "Görevi")<<tr ( "Ülke Kodu" )
<<tr ( "Alan Kodu")<<tr ( "Ev Telefonu" )
<<tr ( "Gsm Kodu" )<<tr("Cep Telefonu")
<<tr ( "Alan Kodu" )
<<tr ( "İş Telefonu" )
<<tr ( "İş Tel Dahili" )
<<tr ( "" ) <<tr ( "" ) <<tr ( "" ) );
m_ui->table_widget_yetkililer->setColumnWidth ( YETKILI_ADI_SOYADI_COLUMN , 275 );
m_ui->table_widget_yetkililer->setColumnWidth ( YETKILI_GOREVI , 145 );
m_ui->table_widget_yetkililer->setColumnWidth ( YETKILI_ULKE_KODU , 85 );
m_ui->table_widget_yetkililer->setColumnWidth ( YETKILI_EV_TEL_ALAN_KODU , 78 );
m_ui->table_widget_yetkililer->setColumnWidth ( YETKILI_EV_TELEFONU , 87 );
m_ui->table_widget_yetkililer->setColumnWidth ( YETKILI_GSM_KODU , 78 );
m_ui->table_widget_yetkililer->setColumnWidth ( YETKILI_CEP_TELEFONU , 95 );
m_ui->table_widget_yetkililer->setColumnWidth ( YETKILI_IS_TEL_ALAN_KODU , 72 );
m_ui->table_widget_yetkililer->setColumnWidth ( YETKILI_IS_TELEFONU , 91 );
m_ui->table_widget_yetkililer->setColumnWidth ( YETKILI_IS_TELEFONU_DAHILI , 87 );
m_ui->table_widget_yetkililer->setColumnWidth ( DETAYLAR_BUTTON_COLUMN , 90 );
m_ui->table_widget_yetkililer->setSelectionMode ( QAbstractItemView::NoSelection );
m_ui->table_widget_yetkililer->setFocus ( Qt::OtherFocusReason );
FOCUS_FIRST_WIDGET ();
//AUTOSTART_FIS_KERNEL ( m_start_fis_kernel );
}
void PRS_EK_ODENEK_VE_KESINTI_FISI::SETUP_FORM()
{
SET_SETTING_NAME ("EK_ODENEK_VE_KESINTI_FISI");
SET_HELP_PAGE ("personel-bordrosu_ek-odenek-tanimlama");
if ( m_fis_turu EQ ENUM_PRS_ODENEK ) {
SET_PAGE_TITLE ( tr ( "PRS - EK ÖDENEK TANIMLAMA" ) );
}
else {
SET_PAGE_TITLE ( tr ( "PRS - EK KESİNTİ TANIMLAMA" ) );
}
REGISTER_BUTTONS_WIDGET ( m_ui->kernel_buttons_widget );
SET_FIRST_FOCUS_WIDGET( m_ui->lineEdit_odenek_kesinti_adi );
REGISTER_TABLE_WIDGET ( m_ui->table_widget, 6 );
SET_FIS_ORDER_COLUMN_NUMBER ( ORDER_NUMBER_COLUMN );
SET_FORM_ID_COLUMN_POSITION ( RECORD_ID_COLUMN );
SET_ROW_ID_COLUMN_POSITION ( ROW_ID_COLUMN );
SET_NUMBER_OF_HIDDEN_COLUMN ( 4 );
// Bu fonksiyon ise kernelin otomatik olarak satir order numlarin reorganize edilmesi saglar.
// Burda kernela database bilgilerini setleyerek bu isi yapabiliriz.
DISABLE_CLEAR_ON_WIDGET( m_ui->comboBox_yuzde_mi );
QStringList kesinti_yuzde_mi;
kesinti_yuzde_mi << tr("TUTAR")<< tr("YÜZDE");
m_ui->comboBox_yuzde_mi->addItems( kesinti_yuzde_mi );
SET_FIS_ORDER_DATABASE ("prs_ek_kesintiler_odenekler", "order_number", "kesinti_odenek_id" );
SET_TABLE_ROW_WIDGETS ( PERSONEL_KODU , WIDGET_SEARCH_EDIT );
SET_TABLE_ROW_WIDGETS ( PERSONEL_AD_SOYAD , WIDGET_LINE_EDIT );
DISABLE_CLEAR_ON_WIDGET( m_ui->comboBox_bordro_donemi_ay );
DISABLE_CLEAR_ON_WIDGET( m_ui->comboBox_bordro_donemi_yil );
K9_FILL_COMBOBOX_AYLAR( m_ui->comboBox_bordro_donemi_ay );
PRS_FILL_COMBO_BOX_BORDRO_YILLARI( m_ui->comboBox_bordro_donemi_yil );
int current_month = QDate::currentDate().month();
FIND_AND_SET_COMBOBOX_TEXT( m_ui->comboBox_bordro_donemi_ay, K9_GET_AYLAR_STRING( current_month) );
m_ui->lineEdit_odenek_kesinti_adi->setMaxLength( 50 );
m_ui->limitedTextEdit_aciklama->SET_MAX_STRING_LENGTH( 512 );
m_ui->table_widget->setHorizontalHeaderLabels (QStringList() << "row_id" << "fis_id" << "order_number_column" << "personel_id"
<< tr("Personel Kodu") << tr("Personel Adı Soyadı") << tr("") << tr("") );
m_ui->table_widget->setColumnWidth( PERSONEL_KODU , 100 );
m_ui->table_widget->setColumnWidth( PERSONEL_AD_SOYAD , 550 );
FOCUS_FIRST_WIDGET ();
if ( m_fis_turu EQ ENUM_PRS_KESINTI ) {
m_ui->checkBox_ssk_kesintisi->setVisible( false );
m_ui->checkBox_gelir_vergisi_kesintisi->setVisible( false );
m_ui->checkBox_damga_vergisi_kesintisi->setVisible( false );
}
}
void MUH_HESAP_EKSTRESI_BATCH::SETUP_FORM()
{
SET_HELP_PAGE( "genel-muhasebe_hesap-ekstresi-muavin" );
SET_PAGE_TITLE( tr ( "MUH - HESAP EKSTRESİ ( MUAVİN )" ) );
REGISTER_BUTTON_WIDGET( m_ui->widget_batch_buttons );
SET_SETTING_NAME( "MUH_HESAP_EKSTRESI_BATCH" );
SET_NAME_OF_RUN_BATCH_BUTTON( tr ( "Rapor Al" ) );
SET_ENTER_KEY_FOR_RUN_BATCH( true );
m_ui->adakDate_baslangic_tarihi->SET_DATE( MALI_YIL_FIRST_DATE() );
m_ui->adakDate_bitis_tarihi->SET_DATE( MALI_ARRAY_LAST_DATE() );
m_ui->frame_sadece_ana_hesaplari_goster->setDisabled ( true );
if ( E9_KULLANICI_SIRKET_DEGISTIRE_BILIR_MI() EQ EVET ) {
m_ui->comboBox_sirket_turu->setVisible(true);
m_ui->label_sirket_turu->setVisible(true);
m_ui->frame_sirket->setVisible(true);
}
if (m_secili_hesap.isEmpty() EQ false) {
m_ui->frame_tek_hesap->setEnabled(true);
m_ui->checkbox_tek_hesap->setChecked(true);
m_ui->frame_hesap_araligi->setEnabled(false);
m_ui->checkbox_hesap_araligi->setChecked(false);
m_ui->search_edit_tek_hesap_kodu->SET_TEXT(m_secili_hesap);
SQL_QUERY query ( DB );
query.PREPARE_SELECT("muh_hesaplar" , "hesap_ismi" , "tam_hesap_kodu = :tam_hesap_kodu");
query.SET_VALUE ( ":tam_hesap_kodu" , m_secili_hesap );
if ( query.SELECT() EQ 0 ) {
m_ui->search_edit_tek_hesap_kodu->SET_TEXT("");
}
else {
query.NEXT();
m_ui->lineedit_tek_hesap_ismi->setText(query.VALUE(0).toString());
}
}
m_ui->checkbox_hesap_araligi->setChecked( false );
m_ui->frame_hesap_araligi->setEnabled( false );
m_ui->checkbox_tek_hesap->setChecked( true );
// tum bakiler tek hesapta bunlar degıstırılmez
m_ui->frame_bakiyesiz_hesaplar->setEnabled( false );
m_ui->frame_calismamis_hesaplar->setEnabled( false );
FIND_AND_SET_COMBOBOX_TEXT( m_ui->combo_box_bakiye, "Tüm Hesaplar");
FIND_AND_SET_COMBOBOX_TEXT( m_ui->combo_box_islem, "Tüm Hesaplar");
SQL_QUERY sql_query ( DB );
sql_query.PREPARE_SELECT("e9_kullanici_yetkileri" , "hesap_ekstresi_nakli_yekun" ,
"kullanici_id = :kullanici_id");
sql_query.SET_VALUE(":kullanici_id" , KULLANICI_ID());
int nakli_yekun = 1;
if ( sql_query.SELECT() NE 0 ) {
sql_query.NEXT();
nakli_yekun = sql_query.VALUE(0).toInt();
}
m_ui->checkbox_nakli_yekun->setChecked(QVariant(nakli_yekun).toBool());
if ( m_rapor_turu NE ENUM_MUH_HESAP_EKSTRESI ) {
m_ui->checkbox_nakli_yekun->setChecked(true);
m_ui->frame_bakiyesiz_hesaplar->setHidden(true);
m_ui->frame_calismamis_hesaplar->setHidden(true);
m_ui->frame_hesap_araligi->setHidden(true);
m_ui->frame_nakli_yekun->setHidden(true);
m_ui->frame_sadece_ana_hesaplari_goster->setHidden(true);
m_ui->frame_tek_hesap->setHidden(true);
m_ui->checkbox_ana_hesaplar->setHidden(true);
m_ui->checkbox_hesap_araligi->setHidden(true);
m_ui->checkbox_nakli_yekun->setHidden(true);
m_ui->checkbox_tarih_araligi->setHidden(true);
m_ui->checkbox_tek_hesap->setHidden(true);
SET_PAGE_TITLE(QObject::tr( "KASA RAPORU" ) );
SET_HELP_PAGE( "kasa-perakende_kasa-raporu" );
if ( E9_KULLANICI_ENT_BILGILERINI_DEGISTIREBILIR_MI() EQ 1 ) {
m_ui->checkbox_tek_hesap->setHidden(false);
m_ui->frame_tek_hesap->setHidden(false);
}
}
SET_FIRST_FOCUS_WIDGET(m_ui->search_edit_tek_hesap_kodu);
FOCUS_FIRST_WIDGET();
}
void SMM_HIZMET_TANIMLAMA_FISI::SETUP_FORM()
{
if ( m_hizmet_sekli EQ SMM_ALINAN_HIZMET ) {
SET_PAGE_TITLE ( tr ( "SMM - SMMM ALINAN HİZMETLER" ) );
SET_HELP_PAGE ("serbest-meslek-makbuzu_alinan-hizmetler");
}
else {
SET_PAGE_TITLE ( tr ( "SMM - SMMM SATILAN HİZMETLER" ) );
SET_HELP_PAGE ("serbest-meslek-makbuzu_satilan-hizmetler");
}
DISABLE_CLEAR_ON_WIDGET(m_ui->searchEdit_sube_kodu);
DISABLE_CLEAR_ON_WIDGET(m_ui->lineEdit_sube_ismi);
SET_SETTING_NAME ("SMM_HIZMET_TANIMLAMA_FISI");
QString sube_kodu, sube_adi;
SUBE_GET_SUBE_KODU_ADI( m_sube_id, &sube_kodu, &sube_adi );
m_ui->searchEdit_sube_kodu->SET_TEXT(sube_kodu);
m_ui->searchEdit_sube_kodu->setDisabled(true);
m_ui->lineEdit_sube_ismi->setText(sube_adi);
m_ui->lineEdit_sube_ismi->setDisabled(true);
if ( SUBE_GET_SUBE_ISLEM_YETKISI() EQ SADECE_UNITE_SUBESINDE ) {
m_ui->searchEdit_sube_kodu->setHidden(true);
m_ui->lineEdit_sube_ismi->setHidden(true);
m_ui->label_sube_kodu->setHidden(true);
}
SET_SINGLE_RECORD_ID (m_sube_id);
REGISTER_BUTTONS_WIDGET ( m_ui->kernel_buttons_widget );
REGISTER_TABLE_WIDGET ( m_ui->tablewidget_fis_satirlari, 10 );
SET_FIS_ORDER_COLUMN_NUMBER ( ORDER_NUMBER_COLUMN );
SET_FORM_ID_COLUMN_POSITION ( FIS_ID_COLUMN );
SET_ROW_ID_COLUMN_POSITION ( ROW_ID_COLUMN );
SET_NUMBER_OF_HIDDEN_COLUMN ( 5 );
SET_FIS_ORDER_DATABASE ("smm_hizmetler", "order_number", "hizmet_id" );
SET_TABLE_ROW_WIDGETS ( HIZMET_ADI_COLUMN , WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( HESAP_KODU_COLUMN , WIDGET_SEARCH_EDIT );
SET_TABLE_ROW_WIDGETS ( HESAP_ISMI_COLUMN , WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( HESAP_ID_COLUMN , WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( VERGI_HESAP_ID_COLUMN , WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( VERGI_HESAP_KODU_COLUMN , WIDGET_SEARCH_EDIT );
SET_TABLE_ROW_WIDGETS ( VERGI_HESAP_ISMI_COLUMN , WIDGET_LINE_EDIT );
SET_FIRST_FOCUS_WIDGET (m_ui->tablewidget_fis_satirlari );
if ( m_hizmet_sekli EQ SMM_ALINAN_HIZMET ) {
m_ui->tablewidget_fis_satirlari->setHorizontalHeaderLabels
(QStringList() << "row_id" << "fis_id" << "order_number_column"<<"gider hsp id"<<"vergi_hsp_id"
<< tr("Alınan Hizmet") << tr("Gider Hesabı Kodu")
<< tr("Gider Hesabı İsmi") << tr("Vergi Hesabı Kodu")
<< tr("Vergi Hesabı İsmi") << tr("") << tr("") );
}
else {
m_ui->tablewidget_fis_satirlari->setHorizontalHeaderLabels
(QStringList() << "row_id" << "fis_id" << "order_number_column"<<"gelir hsp id"<<"vergi_hsp_id"
<< tr("Satılan Hizmet") << tr("Gelir Hesabı Kodu")
<< tr("Gelir Hesabı İsmi") << tr("Vergi Hesabı Kodu")
<< tr("Vergi Hesabı İsmi") << tr("") << tr("") );
}
m_ui->tablewidget_fis_satirlari->setColumnWidth(HIZMET_ADI_COLUMN , 200);
m_ui->tablewidget_fis_satirlari->setColumnWidth(HESAP_KODU_COLUMN , 125);
m_ui->tablewidget_fis_satirlari->setColumnWidth(HESAP_ISMI_COLUMN , 175);
m_ui->tablewidget_fis_satirlari->setColumnWidth(VERGI_HESAP_KODU_COLUMN , 125);
m_ui->tablewidget_fis_satirlari->setColumnWidth(VERGI_HESAP_ISMI_COLUMN , 175);
m_ui->lineEdit_sube_ismi->setMaxLength(30);
if ( K9_KULLANICI_ENT_BILGILERINI_DEGISTIREBILIR_MI() EQ 0 ) {
m_ui->tablewidget_fis_satirlari->hideColumn(HESAP_KODU_COLUMN);
m_ui->tablewidget_fis_satirlari->hideColumn(HESAP_ISMI_COLUMN);
m_ui->tablewidget_fis_satirlari->hideColumn(VERGI_HESAP_KODU_COLUMN);
m_ui->tablewidget_fis_satirlari->hideColumn(VERGI_HESAP_ISMI_COLUMN);
}
FOCUS_FIRST_WIDGET ();
}
void SQL_TABLOLAR_FISI::SETUP_FORM()
{
setWindowState(Qt::WindowMaximized);
REGISTER_BUTTONS_WIDGET ( m_ui->navigation_button_widget );
num_of_columns = 11;
REGISTER_TABLE_WIDGET ( m_ui->tablewidget_tablo_satirlari, num_of_columns );
SET_FIS_ORDER_COLUMN_NUMBER ( ORDER_COLUMN );
SET_FORM_ID_COLUMN_POSITION ( TABLO_ID_COLUMN );
SET_ROW_ID_COLUMN_POSITION ( ROW_ID_COLUMN );
SET_NUMBER_OF_HIDDEN_COLUMN ( 3 );
SET_FIS_ORDER_DATABASE ( "sql_alanlar", "alan_order_num", "alan_id" );
SET_COMMA_EDIT_PRECISION ( ALAN_BOYUT_COLUMN, 0);
SET_COMMA_EDIT_PRECISION ( DIZI_BOYUT_COLUMN, 0);
SET_FIRST_FOCUS_WIDGET ( m_ui->lineEdit_tablo_adi );
SET_TABLE_ROW_WIDGETS ( ALAN_TIPI_COLUMN , WIDGET_COMBO_BOX );
SET_TABLE_ROW_WIDGETS ( DIZI_MI_COLUMN , WIDGET_CHECK_BOX );
SET_TABLE_ROW_WIDGETS ( AUTO_INCREMENT_COLUMN , WIDGET_CHECK_BOX );
SET_TABLE_ROW_WIDGETS ( NOT_NULL_COLUMN , WIDGET_CHECK_BOX );
SET_TABLE_ROW_WIDGETS ( ALAN_ADI_COLUMN , WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( ACIKLAMA_COLUMN , WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( ALAN_BOYUT_COLUMN , WIDGET_COMMA_EDIT );
SET_TABLE_ROW_WIDGETS ( DIZI_BOYUT_COLUMN , WIDGET_COMMA_EDIT );
m_ui->lineEdit_tablo_adi->setMaxLength ( 27 );
m_ui->lineEdit_alan_adi->setMaxLength ( 30 ); // Oracle 30 hane ile sinirli
m_ui->limitedTextEdit_aciklama->SET_MAX_STRING_LENGTH ( 512 );
SET_PAGE_TITLE ( tr("SQL DESIGNER - TABLES"));
REGISTER_SAVER_BUTTON ( m_ui->button_indexler );
REGISTER_SAVER_BUTTON ( m_ui->button_header_olustur );
m_ui->tablewidget_tablo_satirlari->setHorizontalHeaderLabels(QStringList()<<"alan_id"<<"tablo_id"
<<"alan_order_num"
<<tr("Field Name")<<tr("Field Type")
<<tr("Length")<<tr("Is Array?")
<<tr("Array Size")<<tr("Statement")
<<tr("Auto Increment")<<tr("Not Null")
<<tr("")<<tr(""));
QHeaderView * header = m_ui->tablewidget_tablo_satirlari->horizontalHeader();
m_ui->tablewidget_tablo_satirlari->setColumnWidth ( ALAN_ADI_COLUMN , 300 );
m_ui->tablewidget_tablo_satirlari->setColumnWidth ( ALAN_TIPI_COLUMN , 150 );
m_ui->tablewidget_tablo_satirlari->setColumnWidth ( ALAN_BOYUT_COLUMN , 100 );
m_ui->tablewidget_tablo_satirlari->setColumnWidth ( DIZI_MI_COLUMN , 75 );
m_ui->tablewidget_tablo_satirlari->setColumnWidth ( DIZI_BOYUT_COLUMN , 100 );
m_ui->tablewidget_tablo_satirlari->setColumnWidth ( ACIKLAMA_COLUMN , 446 );
m_ui->tablewidget_tablo_satirlari->hideColumn ( AUTO_INCREMENT_COLUMN );
m_ui->tablewidget_tablo_satirlari->hideColumn ( NOT_NULL_COLUMN );
header->setStretchLastSection(QHeaderView::Stretch);
m_ui->tablewidget_tablo_satirlari->setSelectionMode ( QAbstractItemView::NoSelection );
m_ui->tablewidget_tablo_satirlari->setFocus( Qt::OtherFocusReason );
FOCUS_FIRST_WIDGET();
}
