void MUH_HESAP_ARAMA::SETUP_FORM()
{
SET_HELP_PAGE ( tr("muhasebe_hesap_arama.html") );
SET_PAGE_TITLE ( tr ( "MUH - HESAP ARAMA" ) );
SET_SETTING_NAME ( "MUH_HESAP_ARAMA" );
SET_FIRST_FOCUS_WIDGET ( m_ui->line_edit_hesap_kodu_ismi );
REGISTER_TABLE_WIDGET ( m_ui->tableWidget ) ;
REGISTER_ARAMA_BUTTONS_WIDGET ( m_ui->widget_batch_buttons );
SET_HEADERS(QStringList()<<tr ( "Hesap Id" )<<tr ( "Tam Hesap Kodu" )<<tr ( "Hesap İsmi" ) );
m_ui->tableWidget->setColumnWidth ( 1, 40 );
m_ui->tableWidget->setColumnWidth ( 2, 60 );
m_ui->tableWidget->hideColumn(0);
SET_FIND_BUTTON_NAME ( tr ( "Hesap Bul" ) );
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
if ( m_hesap_kodu_baslangici.isEmpty() EQ true ) {
m_hesap_kodu_baslangici = "*";
}
m_ui->line_edit_hesap_kodu_ismi->setText ( m_hesap_kodu_baslangici );
if ( m_ui->line_edit_hesap_kodu_ismi->text() NE "*" ) {
AUTO_START ();
}
}
void FAT_IRSALIYE_ARAMA::SETUP_FORM ()
{
SET_PAGE_TITLE( tr ( "FAT - İRSALİYE SEÇİMİ" ) );
REGISTER_TABLE_WIDGET ( m_ui->tableWidget );
REGISTER_ARAMA_BUTTONS_WIDGET ( m_ui->widget_batch_buttons );
SET_HEADERS( QStringList() << tr("irsaliye_id") <<tr("İrs. Seri No") << tr("İrsaliye No") << tr("İrs. Tarihi") );
SET_SORTING ( false );
m_ui->tableWidget->hideColumn(0);
m_ui->tableWidget->setColumnWidth ( 1, 20 );
m_ui->tableWidget->setColumnWidth ( 2, 10 );
m_ui->tableWidget->setColumnWidth ( 3, 200 );
// Programa ilk girildiginde focuslanacak widget setlenmelidir.
SET_FIRST_FOCUS_WIDGET ( m_ui->adakDate_bas_tarihi );
SET_HELP_PAGE ("fat_irsaliye_secimi.html");
m_ui->tableWidget->setColumnWidth( 3 , 10);
SET_SETTING_NAME ( "FAT_IRSALIYE_SECIMI" );
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
SET_FIND_BUTTON_NAME ( "İrsaliye Bul" );
SQL_QUERY sql_query ( DB );
sql_query.PREPARE_SELECT ( "k9_sabit_degerler","irs_faturalandirilacak_gun" ,"sabit_deger_id = :sabit_deger_id");
sql_query.SET_VALUE(":sabit_deger_id" , 1);
if ( sql_query.SELECT() EQ 0 ) {
return;
}
sql_query.NEXT();
int faturandirilacak_gun = sql_query.VALUE(0).toInt();
QDate irsaliye_tarihi_bitis = QDate::fromString ( m_irsaliye_tarihi_bitis, "yyyy.MM.dd" );
int irsaliye_tarihi_bitis_month = irsaliye_tarihi_bitis.month();
QDate irsaliye_tarihi_baslangic = irsaliye_tarihi_bitis.addDays ( -1 * faturandirilacak_gun );
int irsaliye_tarihi_baslangic_month = irsaliye_tarihi_baslangic.month();
if ( irsaliye_tarihi_baslangic_month NE irsaliye_tarihi_bitis_month ) {
m_irsaliye_tarihi_baslangic = QDate( irsaliye_tarihi_bitis.year(), irsaliye_tarihi_bitis_month, 01 ).toString("yyyy.MM.dd");
}
else {
m_irsaliye_tarihi_baslangic = irsaliye_tarihi_baslangic.toString("yyyy.MM.dd");
}
m_ui->adakDate_bas_tarihi->SET_DATE( m_irsaliye_tarihi_baslangic );
m_ui->adakDate_bts_tarihi->SET_DATE( m_irsaliye_tarihi_bitis );
AUTO_START();
}
void MUH_HESAP_EKLEME_FISI::SETUP_FORM()
{
SET_HELP_PAGE ( tr("hesap-plani") );
SET_PAGE_TITLE( tr( "MUH - ALT HESAP EKLEME" ) );
m_num_of_columns = 10;
REGISTER_TABLE_WIDGET ( m_ui->tablewidget_alt_hesaplar, m_num_of_columns );
REGISTER_BUTTONS_WIDGET ( m_ui->navigation_button_widget );
SET_FIRST_FOCUS_WIDGET( m_ui->line_edit_hesap_kodu );
m_muh_hesap_plani->m_record_updated = false;
m_muh_hesap_plani->m_line_added = false;
m_muh_hesap_plani->m_line_updated = false;
m_ui->lineEdit_hesap_ismi->setMaxLength(60);
m_ui->line_edit_hesap_kodu->setMaxLength(30);
SET_ROW_ID_COLUMN_POSITION ( ROW_ID_COLUMN );
SET_FORM_ID_COLUMN_POSITION ( ANA_HESAP_ID_COLUMN );
SET_FIS_ORDER_COLUMN_NUMBER ( ORDER_COLUMN );
SET_NUMBER_OF_HIDDEN_COLUMN ( 4 );
m_ana_hesap_aktarilmalimi = false;
SET_TABLE_ROW_WIDGETS ( ANA_HESAP_KODU_COLUMN, WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( HESAP_KODU_COLUMN, WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( TAM_HESAP_KODU_COLUMN, WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( HESAP_ISMI_COLUMN, WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( HESAP_GRUPLAR , WIDGET_LINE_EDIT );
SET_TABLE_ROW_WIDGETS ( HESAP_GRUP_SECIMI_COLUMN, WIDGET_PUSH_BUTTON );
SET_LINE_BUTTON_ICON ( QStringList() << "" << "" );
m_ui->tablewidget_alt_hesaplar->setHorizontalHeaderLabels ( QStringList()<< "row_id" << "hesap_id" << "satir_order" << "grup_idleri"
<< tr ( "Ana Hesap Kodu" )
<< tr ( "Hesap Kodu" )
<< tr ( "Tam Hesap Kodu" )
<< tr ( "Hesap İsmi" )
<< tr ( "Hesabın Grupları" )
<< "" << "" << "" );
m_ui->tablewidget_alt_hesaplar->setSelectionMode ( QAbstractItemView::NoSelection );
m_ui->tablewidget_alt_hesaplar->setFocus ( Qt::OtherFocusReason );
m_ui->tablewidget_alt_hesaplar->setColumnWidth ( ANA_HESAP_KODU_COLUMN, 140 );
m_ui->tablewidget_alt_hesaplar->setColumnWidth ( HESAP_KODU_COLUMN, 130 );
m_ui->tablewidget_alt_hesaplar->setColumnWidth ( TAM_HESAP_KODU_COLUMN, 200 );
m_ui->tablewidget_alt_hesaplar->setColumnWidth ( HESAP_ISMI_COLUMN, 200 );
m_ui->tablewidget_alt_hesaplar->setColumnWidth ( HESAP_GRUPLAR, 170 );
m_ui->tablewidget_alt_hesaplar->setColumnWidth ( HESAP_GRUP_SECIMI_COLUMN, 100 );
SET_SETTING_NAME ( "MUH_HESAP_EKLEME_FISI" );
if ( m_ana_hesap_id NE -1 ) {
AUTOSTART_FIS_KERNEL( m_ana_hesap_id );
}
}
void E9_LOG_KAYDI_ARAMA::SETUP_FORM()
{
SET_HELP_PAGE ( "yonetim-islemleri_e9-log-bilgileri" );
QString page_title = tr("E9 Log Bilgisi Arama");
m_ui->frame_kullanici_secimi->setEnabled ( false );
m_ui->frame_log_turu->setEnabled ( false );
m_ui->textEdit_yapilan_islem->setVisible ( false );
m_ui->adakDate_first_date->SET_DATE( MALI_YIL_FIRST_DATE() );
m_ui->adakDate_second_date->SET_DATE( QDate::currentDate() );
E9_FILL_COMBOBOX_ADAK_MODULES ( m_ui->comboBox_modul_secimi );
SET_FIRST_FOCUS_WIDGET( m_ui->adakDate_first_date );
#ifdef ADRES_BAGIMSIZ
m_ui->adakDate_first_date->SET_DATE( QDate::currentDate().addDays(-30) );
m_ui->comboBox_modul_secimi->setCurrentIndex ( m_ui->comboBox_modul_secimi->findText ( E9_GET_ADAK_MODULES_STRING ( ADRES_MODULU ) ));
m_ui->comboBox_modul_secimi->setEnabled ( false );
page_title = tr( "ADRES 007 LOG ARAMA" );
#endif
FILL_LOG_TURLERI_COMBOBOX ();
m_kullanici_id = -1;
REGISTER_TABLE_WIDGET ( m_ui->tableWidget );
REGISTER_ARAMA_BUTTONS_WIDGET ( m_ui->widget_batch_buttons );
SET_PAGE_TITLE ( page_title );
SET_HEADERS ( QStringList() << tr ("log_id") << tr ("İşlem Tarihi") << tr ("İşlem Zamanı")
<< tr ("Kullanıcı") << tr ("Bilgisayar") << tr ("Log Türü")
<< tr ("İşlem Türü"));
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
SET_SORTING ( false );
SET_FIND_BUTTON_NAME ( tr("Log Kaydı Ara") );
m_ui->tableWidget->hideColumn ( LOG_ID_COLUMN );
m_ui->tableWidget->setColumnWidth ( ISLEM_TARIHI_COLUMN, 144 );
m_ui->tableWidget->setColumnWidth ( ISLEM_ZAMANI_COLUMN, 98 );
m_ui->tableWidget->setColumnWidth ( KULLANICI_COLUMN, 147 );
m_ui->tableWidget->setColumnWidth ( BILGISAYAR_COLUMN, 149 );
m_ui->tableWidget->setColumnWidth ( LOG_TURU_COLUMN, 155 );
m_ui->tableWidget->setColumnWidth ( ISLEM_TURU_COLUMN, 142 );
SET_SETTING_NAME ( "E9_LOG_KAYDI_ARAMA" );
}
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 YONETIM_007_ARAMA::SETUP_FORM ()
{
REGISTER_TABLE_WIDGET ( m_ui->tableWidget );
REGISTER_ARAMA_BUTTONS_WIDGET ( m_ui->widget_batch_buttons );
SET_HEADERS(QStringList()<<tr ( "log_id")<<tr ( "Tarih" )<<tr ( "Saat" )<<tr ( "Kullanıcı Bilgisi")
<<tr ( "Bilgisayar Bilgisi" )<<tr ( "LOG Türü" )<<tr ( "LOG İşlemi" ) );
SET_ENTER_KEY_FOR_RUN_BATCH(true);
SET_FIND_BUTTON_NAME(tr("Kayıtları Göster"));
SET_SORTING ( false );
m_ui->frame_tarih->setEnabled(false);
m_ui->frame_log_turu->setEnabled(false);
m_ui->frame_kullanici->setEnabled(false);
m_ui->dateEdit_first_date->setDate(QDate::currentDate());
m_ui->dateEdit_second_date->setDate(QDate::currentDate());
SQL_QUERY sql_query(G_YONETIM_DB);
sql_query.PREPARE_SELECT("ynt_kullanicilar","kullanici_kodu","silinmis_mi = 0");
if ( sql_query.SELECT() > 0 ) {
while (sql_query.NEXT() EQ true ) {
m_ui->comboBox_kullanicilar->addItem(sql_query.VALUE(0).toString());
}
}
m_ui->comboBox_log_turu->addItem("BILGISAYARLAR");
m_ui->comboBox_log_turu->addItem("KULLANICILAR");
m_ui->comboBox_log_turu->addItem("VERITABANLARI");
m_ui->comboBox_log_turu->addItem("PROGRAM");
SET_PAGE_TITLE ( tr("YÖNETİM 007 / LOG BİLGİLERİ"));
SET_SETTING_NAME ("YONETIM_007");
SET_HELP_PAGE ("yonetim-islemleri_yonetim-log-bilgileri");
m_ui->tableWidget->setColumnWidth ( ISLEM_TARIHI_COLUMN , 130 );
m_ui->tableWidget->setColumnWidth ( ISLEM_SAATI_COLUMN , 50 );
m_ui->tableWidget->setColumnWidth ( KULLANICI_BILGISI_COLUMN , 120 );
m_ui->tableWidget->setColumnWidth ( BILGISAYAR_BILGISI_COLUMN, 250 );
m_ui->tableWidget->hideColumn ( LOG_ID_COLUMN);
m_ui->limitedTextEdit_ekstra_bilgiler->SET_LINE_LIMIT(5);
m_ui->limitedTextEdit_ekstra_bilgiler->SET_MAX_STRING_LENGTH(500);
m_ui->checkbox_tarih->setChecked( true );
m_ui->frame_tarih->setEnabled( true );
SET_FIRST_FOCUS_WIDGET( m_ui->dateEdit_first_date );
}
void PRK_FIS_ARAMA::SETUP_FORM()
{
REGISTER_TABLE_WIDGET ( m_ui->tableWidget );
REGISTER_ARAMA_BUTTONS_WIDGET ( m_ui->widget_batch_buttons );
SET_HEADERS ( QStringList() << tr ("Fis id") << tr("Fiş Tarihi") << tr("Fiş No") << tr("Açıklama")
<< tr("Kdv \n Hariç Toplam") << tr("Kdv Toplam")<<tr("Kdv \n Dahil Toplam"));
SET_SORTING ( false );
SET_FIRST_FOCUS_WIDGET ( m_ui->adakDate_bas_tarihi );
SET_PAGE_TITLE ( tr ( "PRK - PERAKENDE FİŞİ ARAMA" ) );
SET_HELP_PAGE ("perakende_fisi_arama.html");
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
SET_FIND_BUTTON_NAME ( "Bul" );
m_ui->checkBox_tarih_araligi->setChecked(true);
m_ui->frame_aciklama_icerigi->setDisabled(true);
m_ui->adakDate_bas_tarihi->SET_DATE( MALI_YIL_FIRST_DATE());
m_ui->adakDate_bts_tarihi->SET_DATE( MALI_YIL_365_DATE());
m_ui->tableWidget->setColumnWidth(FIS_ID_COLUMN , 10 );
m_ui->tableWidget->setColumnWidth(FIS_TARIHI_COLUMN , 150);
m_ui->tableWidget->setColumnWidth(FIS_NO_COLUMN , 80 );
m_ui->tableWidget->setColumnWidth(ACIKLAMA_COLUMN , 200);
m_ui->tableWidget->setColumnWidth(KDV_HARIC_TOPLAM_COLUMN , 180);
m_ui->tableWidget->setColumnWidth(KDV_TOPLAM_COLUMN , 100);
m_ui->tableWidget->setColumnWidth(KDV_DAHIL_TOPLAM_COLUMN , 180);
SET_SETTING_NAME ("PERAKENDE_FIS_ARAMA");
m_ui->tableWidget->hideColumn(FIS_ID_COLUMN);
if ( E9_KULLANICI_SIRKET_DEGISTIRE_BILIR_MI() EQ EVET ) {
m_ui->frame_fis_filtresi->setHidden(false);
}
}
void CARI_OTO_EKSTRE_ARAMA::SETUP_FORM ()
{
REGISTER_TABLE_WIDGET ( m_ui->tableWidget );
REGISTER_ARAMA_BUTTONS_WIDGET ( m_ui->widget_batch_buttons );
m_ui->adakDate_bas_tarihi->SET_DATE( MALI_YIL_FIRST_DATE() );
m_ui->adakDate_bts_tarihi->SET_DATE( MALI_ARRAY_LAST_DATE() );
SET_HEADERS ( QStringList() << tr("base_fis_id") << tr("") << tr("") << tr("") << tr("")<< tr("") << tr("")
<< tr("Fiş Tarihi") << tr("Fiş No") <<tr("Açıklama") << tr("Borç") << tr("Alacak"));
SET_SORTING ( false );
SET_FIRST_FOCUS_WIDGET ( m_ui->adakDate_bas_tarihi );
SET_PAGE_TITLE (tr("CARİ EKSTRESİ"));
SET_HELP_PAGE ("cari_ekstresi");
m_ui->tableWidget->hideColumn( BASE_FIS_ID_COLUMN );
m_ui->tableWidget->hideColumn( MODUL_ID_COLUMN );
m_ui->tableWidget->hideColumn( FIS_TURU_COLUMN );
m_ui->tableWidget->hideColumn( IADE_FATURASI_MI_COLUMN );
m_ui->tableWidget->hideColumn( BORDRO_ISLEM_TURU_COLUMN );
m_ui->tableWidget->hideColumn( FIS_ID_COLUMN );
m_ui->tableWidget->hideColumn( SMM_MAKBUZ_TURU_COLUMN );
m_ui->tableWidget->setColumnWidth( FIS_TARIHI_COLUMN , 100 );
m_ui->tableWidget->setColumnWidth( FIS_NO_COLUMN , 40 );
m_ui->tableWidget->setColumnWidth( ACIKLAMA_COLUMN , 200 );
m_ui->tableWidget->setColumnWidth( TOPLAM_BORC_COLUMN , 80 );
m_ui->tableWidget->setColumnWidth( TOPLAM_ALACAK_COLUMN , 80 );
SET_SETTING_NAME ("CARI_OTO_EKSTRE_ARAMA");
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
SET_FIND_BUTTON_NAME ( "Bul" );
AUTO_START();
}
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 SUBE_ARAMA::SETUP_FORM()
{
SET_HELP_PAGE ( "sube_arama.html" );
SET_PAGE_TITLE ( tr( "ŞUBE - ŞUBE ARAMA" ) );
m_ui->checkBox_sube_adi_sube_kodu->setChecked ( true );
m_ui->frame_kasa_unite->setEnabled ( false );
REGISTER_TABLE_WIDGET ( m_ui->tableWidget );
REGISTER_ARAMA_BUTTONS_WIDGET ( m_ui->widget_batch_buttons );
if ( m_sube_adi_sube_kodu.isEmpty() EQ true ) {
m_ui->lineEdit_sube_adi_sube_kodu->setText("*");
}
else {
m_ui->lineEdit_sube_adi_sube_kodu->setText( m_sube_adi_sube_kodu );
}
SET_HEADERS ( QStringList()<<tr("Şube Id")<<tr("Şube Kodu")<<tr("Şube Adı"));
SET_SORTING ( false );
SET_FIRST_FOCUS_WIDGET ( m_ui->lineEdit_sube_adi_sube_kodu );
m_ui->tableWidget->hideColumn(0);
m_ui->tableWidget->setColumnWidth ( 1, 40 );
m_ui->tableWidget->setColumnWidth ( 2, 60 );
SET_SETTING_NAME ( "SUBE_ARAMA" );
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
SET_FIND_BUTTON_NAME ( tr( "Şube Bul" ) );
if ( m_ui->lineEdit_sube_adi_sube_kodu->text().isEmpty() EQ false ) {
AUTO_START ();
}
}
void CEK_MUSTERI_CEK_SENET_ARAMA::SETUP_FORM()
{
REGISTER_TABLE_WIDGET ( m_ui->tableWidget );
REGISTER_ARAMA_BUTTONS_WIDGET ( m_ui->widget_batch_buttons );
SET_FIRST_FOCUS_WIDGET ( m_ui->combobox_cekin_durumu );
m_ui->adakDate_vade_bas_tarihi->MALI_YIL_KISITI_YOK( true );
m_ui->adakDate_vade_bts_tarih->MALI_YIL_KISITI_YOK( true );
m_ui->adakDate_vade_bas_tarihi->SET_DATE( MALI_YIL_FIRST_DATE() );
m_ui->adakDate_vade_bts_tarih->SET_DATE( MALI_ARRAY_LAST_DATE() );
if ( m_cek_senet_turu EQ ENUM_CEK ) {
m_ui->label_cek_senet_durumu->setText("Çekin Durumu");
SET_HEADERS(QStringList()<<tr ( "Çek Id" )<<tr ( "Çek No" )<<tr ( "Vade Tarihi")<<tr ( "Düzenleme Tarihi")<<tr("Cari Hesap")<<
tr ( "Banka İsmi" )<<tr("Şube İsmi")<<tr("Tutar")<<tr ( "Durumu" ) );
SET_FIND_BUTTON_NAME ( tr ( "Çekleri Bul" ) );
SET_PAGE_TITLE ( tr ( "ÇEK-SNT - MÜŞTERİ ÇEKLERİ ARAMA" ) );
SET_HELP_PAGE ( "cek-senet-islemleri_musteri-cekleri-arama" );
}
else {
m_ui->label_cek_senet_durumu->setText("Senedin Durumu");
SET_HEADERS ( QStringList()<<tr( "Senet Id" )<<tr ( "Senet No" )<<tr ( "Vade Tarihi" )<<tr ( "Düzenleme Tarihi" )<<tr ( "Cari Hesap" )
<<tr( "Tutar" )<< ( "Senedin Durumu" ) );
SET_FIND_BUTTON_NAME ( tr ( "Senetleri Bul" ) );
SET_PAGE_TITLE ( tr( "ÇEK-SNT - MÜŞTERİ SENETLERİ ARAMA" ) );
SET_HELP_PAGE ( "cek-senet-islemleri_musteri-senetleri-arama" );
}
m_ui->date_frame->setEnabled ( false );
m_ui->cari_hesap_frame->setEnabled ( false );
m_ui->cekin_durumu_frame->setEnabled ( false );
m_cari_hesap_id = 0;
FILL_COMBOBOX_CEKIN_DURUMU();
K9_FILL_COMBOBOX_RAPOR_SIRKET_FILTRESI(m_ui->comboBox_sirket_filtresi);
if ( K9_KULLANICININ_CALISTIGI_SIRKET() EQ 1 ) {
m_entegre_filtresi = FIS_BIRINCI_SIRKET;
}
else {
m_entegre_filtresi = FIS_HER_IKI_SIRKET;
}
m_ui->comboBox_sirket_filtresi->setHidden(true);
m_ui->label_sirket->setHidden(true);
if ( K9_KULLANICI_SIRKET_DEGISTIRE_BILIR_MI() EQ EVET ) {
m_ui->comboBox_sirket_filtresi->setHidden(false);
m_ui->label_sirket->setHidden(false);
}
m_ui->comboBox_sirket_filtresi->setCurrentIndex(m_ui->comboBox_sirket_filtresi->findText(K9_GET_RAPOR_SIRKET_FILTRESI_STRING(m_entegre_filtresi)));
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
if ( m_cek_senet_turu EQ ENUM_CEK ) {
m_ui->tableWidget->setColumnWidth ( 1,100 );
m_ui->tableWidget->setColumnWidth ( 2,170 );
m_ui->tableWidget->setColumnWidth ( 3,170 );
m_ui->tableWidget->setColumnWidth ( 4,100 );
m_ui->tableWidget->setColumnWidth ( 5,90 );
m_ui->tableWidget->setColumnWidth ( 6,100 );
m_ui->tableWidget->setColumnWidth ( 7,80 );
m_ui->tableWidget->setColumnWidth ( 8,100 );
SET_SETTING_NAME ( "CEK_MUS_CEK_SENET_ARAMA_CEK" );
}
else {
m_ui->tableWidget->setColumnWidth ( 1,100 );
m_ui->tableWidget->setColumnWidth ( 2,190 );
m_ui->tableWidget->setColumnWidth ( 3,190 );
m_ui->tableWidget->setColumnWidth ( 4,140 );
m_ui->tableWidget->setColumnWidth ( 5,110 );
m_ui->tableWidget->setColumnWidth ( 6,180 );
SET_SETTING_NAME ( "CEK_MUS_CEK_SENET_ARAMA_SENET" );
}
m_ui->lineedit_cari_hesap_ismi->setMaxLength(60);
m_ui->tableWidget->hideColumn(0);
m_ui->checkbox_cekin_durumu->setChecked( true );
m_ui->cekin_durumu_frame->setEnabled( true );
}
void FAT_FATURA_ARAMA::SETUP_FORM()
{
SET_HELP_PAGE ("fatura_arama.html");
SET_PAGE_TITLE ( tr ( "FATURA ARAMA" ) );
//m_ui->frame_entegre_filtresi->setVisible( false );
m_ui->groupBox_entegre_filtresi->setVisible( false );
m_ui->frame_fatura_turu->setEnabled( false );
m_ui->frame_acik_kapali_fatura->setEnabled( false );
K9_FILL_COMBOBOX_FIS_FILTRESI( m_ui->comboBox_fis_filtresi );
FAT_FILL_COMBOBOX_FATURA_TURU( m_ui->comboBox_fatura_turu, m_fatura_alis_satis_turu, -1 , m_iade_faturasi_mi );
m_ui->comboBox_fatura_turu->setCurrentIndex( -1 );
if ( K9_KULLANICININ_CALISTIGI_SIRKET() EQ 1 ) {
m_entegre_filtresi_turu = FIS_BIRINCI_SIRKET;
}
else {
m_entegre_filtresi_turu = FIS_HER_IKI_SIRKET;
}
if ( K9_KULLANICI_ENT_BILGILERINI_DEGISTIREBILIR_MI() EQ 1 ) {
//m_ui->frame_entegre_filtresi->setVisible( true );
m_ui->groupBox_entegre_filtresi->setVisible( false );
m_entegre_filtresi_turu = FIS_HER_IKI_SIRKET;
}
FIND_AND_SET_COMBOBOX_TEXT( m_ui->comboBox_fis_filtresi, K9_GET_FIS_FILTRESI_STRING( m_entegre_filtresi_turu ));
FAT_FILL_ACIK_KAPALI_COMBO_BOX( m_ui->comboBox_acik_kapali_fatura );
FIND_AND_SET_COMBOBOX_TEXT( m_ui->comboBox_acik_kapali_fatura, FAT_GET_ACIK_KAPALI_FATURA_STRING( ENUM_TUM_FATURALAR ));
m_ui->commaEdit_min_tutar->SET_PRECISION( 2 );
m_ui->commaEdit_min_tutar->SET_RETURN_EMPTY( false );
m_ui->commaEdit_max_tutar->SET_PRECISION( 2 );
m_ui->commaEdit_max_tutar->SET_RETURN_EMPTY( false );
m_ui->checkBox_tarih_araligi->setChecked ( true );
m_ui->groupBox_tarih_araligi->setEnabled ( true );
m_ui->groupBox_aciklama_icerigi->setEnabled ( false );
m_ui->groupBox_cari_hesap_kodu->setEnabled ( false );
m_ui->groupBox_urun->setEnabled ( false );
m_ui->groupBox_tutar_araligi->setEnabled ( false );
m_ui->adakDate_ilk_tarih->SET_DATE( QDate::currentDate().addDays( -7 ) );
m_ui->adakDate_son_tarih->SET_DATE( QDate::currentDate() );
REGISTER_TABLE_WIDGET ( m_ui->tableWidget );
REGISTER_ARAMA_BUTTONS_WIDGET ( m_ui->widget_batch_buttons );
SET_HEADERS ( QStringList() <<tr("Fatura Id")<<tr("Fatura Tarihi")<<tr("Fiş No")<<tr("Cari Hesap") << tr("Fatura Seri / No")<< tr("Fatura Tutarı"));
SET_SORTING ( false );
SET_FIRST_FOCUS_WIDGET ( m_ui->adakDate_ilk_tarih );
m_ui->tableWidget->setColumnWidth ( FATURA_TARIHI_COLUMN, 120 );
m_ui->tableWidget->setColumnWidth ( FIS_NO_COLUMN, 60 );
m_ui->tableWidget->setColumnWidth ( CARI_HESAP_COLUMN, 200 );
m_ui->tableWidget->setColumnWidth ( FATURA_SERI_NO_COLUMN, 120 );
m_ui->tableWidget->setColumnWidth ( FATURA_TUTARI_COLUMN, 120 );
m_ui->tableWidget->hideColumn ( FIS_ID_COLUMN );
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
SET_FIND_BUTTON_NAME ( tr ( "Fatura Bul" ) );
SET_SETTING_NAME ( "FATURA_ARAMA" );
}
void CEK_SENET_ARAMA::SETUP_FORM()
{
REGISTER_TABLE_WIDGET ( m_ui->tableWidget );
REGISTER_ARAMA_BUTTONS_WIDGET ( m_ui->widget_batch_buttons );
DISABLE_CLEAR_ON_WIDGET(m_ui->combobox_sirket_filtresi);
m_ui->adak_date_vade_bas_tarihi->MALI_YIL_KISITI_YOK( true );
m_ui->adak_date_vade_bts_tarihi->MALI_YIL_KISITI_YOK( true );
m_ui->adak_date_vade_bas_tarihi->SET_DATE( MALI_YIL_FIRST_DATE() );
m_ui->adak_date_vade_bts_tarihi->SET_DATE( MALI_ARRAY_LAST_DATE() );
SET_HELP_PAGE( "cek-senet-islemleri");
SET_FIRST_FOCUS_WIDGET( m_ui->combobox_cekin_durumu );
if ( E9_KULLANICI_SIRKET_DEGISTIRE_BILIR_MI() EQ HAYIR ) {
m_ui->combobox_sirket_filtresi->setHidden(true);
m_ui->label_sirket->setHidden(true);
}
if (m_cek_mi_senet_mi EQ ENUM_CEK OR m_cek_mi_senet_mi EQ ENUM_HEPSI ) {
SET_HEADERS(QStringList()<<tr ( "Çek Id" )<<tr ( "Portföy No" )<<tr("Çek Numarası")<<tr ( "Vade Tarihi" )<<tr ( "Düzenleme Tarihi" )<<
tr ( "Banka İsmi")<<tr ( "Şube İsmi" )<<tr("Hesap No" )<<tr("Tutar")<<tr ( "Para Birimi" ) );
}
else {
SET_HEADERS ( QStringList()<<tr ( "Senet Id")<<tr ( "Portföy Numarası" )<<tr ( "Senet Numarası" )<<tr ( "Vade Tarihi" )
<<tr ( "Düzenleme Tarihi" )<<tr("Tutar") << tr( "Para Birimi" ) );
}
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
if ( m_cek_mi_senet_mi EQ ENUM_CEK OR m_cek_mi_senet_mi EQ ENUM_HEPSI ) {
m_ui->tableWidget->setColumnWidth( 1, 110 );
m_ui->tableWidget->setColumnWidth( 2, 110 );
m_ui->tableWidget->setColumnWidth( 3, 140 );
m_ui->tableWidget->setColumnWidth( 4, 130 );
m_ui->tableWidget->setColumnWidth( 5, 110 );
m_ui->tableWidget->setColumnWidth( 6, 110 );
m_ui->tableWidget->setColumnWidth( 7, 110 );
m_ui->tableWidget->setColumnWidth( 8, 80 );
m_ui->tableWidget->setColumnWidth( 9, 70 );
SET_SETTING_NAME( "CEK_SENET_ARAMA_CEK" );
if ( m_cek_mi_senet_mi EQ ENUM_CEK ) {
SET_FIND_BUTTON_NAME ( tr ( "Çekleri Bul" ) );
SET_PAGE_TITLE ( tr ( "ÇEK-SNT - ÇEK ARAMA" ) );
}
else { //Hepsi
SET_FIND_BUTTON_NAME ( tr ( "Bul" ) );
SET_PAGE_TITLE ( tr ( "ÇEK-SNT - ÇEK / SENET ARAMA" ) );
}
if ( m_musteri_cek_senedi_mi EQ 1 ) {
GET_BANKALAR(m_ui->combobox_banka_ismi );
}
else {
QStringList kullanilan_banka_list = BNK_GET_BANKA_ISIMLERI();
for( int i = 0; i < kullanilan_banka_list.size(); i++ ) {
m_ui->combobox_banka_ismi->addItem ( kullanilan_banka_list.at( i ) );
}
m_ui->combobox_banka_ismi->setCurrentIndex(-1);
}
}
else { //senetler
m_ui->tableWidget->setColumnWidth( 1, 130 );
m_ui->tableWidget->setColumnWidth( 2, 180 );
m_ui->tableWidget->setColumnWidth( 3, 200 );
m_ui->tableWidget->setColumnWidth( 4, 200 );
m_ui->tableWidget->setColumnWidth( 5, 140 );
m_ui->tableWidget->setColumnWidth( 6, 70 );
SET_SETTING_NAME( "CEK_SENET_ARAMA_SENET" );
SET_FIND_BUTTON_NAME( tr ( "Senetleri Bul" ) );
SET_PAGE_TITLE( tr ( "ÇEK-SNT - SENET ARAMA" ) );
m_ui->banka_bilgisi_frame->hide ();
m_ui->checkbox_banka_bilgisi->hide ();
}
m_ui->tableWidget->hideColumn( 0 );
m_ui->date_frame->setEnabled( false );
m_ui->banka_bilgisi_frame->setEnabled( false );
m_ui->cekin_durumu_frame->setEnabled( false );
if ( m_aranacak_cek_senet_turu EQ ENUM_CEK_IADE_ALINDI_BANKADAN OR
m_aranacak_cek_senet_turu EQ ENUM_CEK_ODENDI_HESAPTAN) {
m_ui->checkbox_banka_bilgisi->hide();
m_ui->banka_bilgisi_frame->hide();
}
if ( m_aranacak_cek_senet_turu NE ENUM_CEK_TAHSIL_EDILDI_HESABA AND
m_aranacak_cek_senet_turu NE ENUM_CEK_TAHSIL_EDILDI_NKT AND
m_aranacak_cek_senet_turu NE ENUM_CEK_IADE_ALINDI_BANKADAN ) {
m_ui->cekin_durumu_frame->hide();
m_ui->checkbox_cekin_durumu->hide();
}
else {
FILL_COMBOBOX_CEKIN_DURUMU();
}
}
void STOK_FISI_ARAMA::SETUP_FORM()
{
switch ( m_irsaliye_mi_stok_fisi_mi ) {
case ENUM_STOK_FISI :
default :
SET_HELP_PAGE ( "stok_fisi_arama.html" );
SET_PAGE_TITLE ( tr ( "STK - STOK FİŞİ ARAMA") );
break;
case ENUM_IRSALIYE :
SET_HELP_PAGE ( "irsaliye_arama.html" );
SET_PAGE_TITLE ( tr ( "İRSALİYE ARAMA") );
break;
}
m_ui->frame_cari_hesap_kodu->setEnabled( false );
m_ui->adakDate_baslangic_tarihi->SET_DATE( QDate::currentDate().addDays( -7 ) );
m_ui->adakDate_bitis_tarihi->SET_DATE( QDate::currentDate() );
if ( m_irsaliye_mi_stok_fisi_mi EQ ENUM_IRSALIYE ) {
IRS_FILL_IRSALIYE_TURU_COMBOBOX ( m_ui->comboBox_fis_turu, m_irsaliye_stok_fisi_alis_satis_turu, m_fis_turu );
m_ui->label_fis_turu->setText( "İrsaliye Türü " );
}
else {
STK_FILL_STOK_FIS_TURU_COMBOBOX ( m_ui->comboBox_fis_turu );
}
m_ui->comboBox_fis_turu->setCurrentIndex(-1);
m_ui->checkBox_tarih_araligi->setChecked ( true );
m_ui->frame_aciklama_icerigi->setEnabled ( false );
m_ui->frame_fis_turu->setEnabled ( false );
REGISTER_TABLE_WIDGET ( m_ui->tableWidget );
REGISTER_ARAMA_BUTTONS_WIDGET ( m_ui->widget_batch_buttons );
SET_HEADERS(QStringList()<<tr("fis_id")<<tr("Fiş Tarihi") << tr( "Cari Hesap İsmi" )<<tr("Fiş No")<<tr("Fiş Türü"));
SET_SORTING ( false );
SET_FIRST_FOCUS_WIDGET ( m_ui->adakDate_baslangic_tarihi );
m_ui->tableWidget->setColumnWidth ( FIS_TARIHI_COLUMN, 100 );
m_ui->tableWidget->setColumnWidth ( CARI_HESAP_ISMI_COLUMN, 180 );
m_ui->tableWidget->setColumnWidth ( FIS_NO_COLUMN, 60 );
m_ui->tableWidget->setColumnWidth ( FIS_TURU_COLUMN, 140 );
switch ( m_irsaliye_mi_stok_fisi_mi ) {
case ENUM_STOK_FISI :
default :
SET_SETTING_NAME ( "STOK_FIS_ARAMA" );
break;
case ENUM_IRSALIYE :
SET_SETTING_NAME ( "IRSALIYE_ARAMA" );
break;
}
if ( E9_KULLANICI_SIRKET_DEGISTIRE_BILIR_MI() EQ EVET ) {
m_ui->frame_fis_filtresi->setHidden(false);
}
m_ui->tableWidget->hideColumn( FIS_ID_COLUMN );
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
SET_FIND_BUTTON_NAME ( tr ( "Ara" ) );
}
void BNK_HAREKET_FISI_ARAMA::SETUP_FORM()
{
SET_HELP_PAGE ( "banka-islemleri" );
// Ekran Entegras
if ( m_fis_turu EQ ENUM_BANKA_ENT_FISI ) {
SET_PAGE_TITLE( tr ( "BNK - BANKA ENTEGRASYON FİŞLERİ" ) );
SET_HELP_PAGE( "Banka-islemleri_banka-entegrasyon-fisleri");
SET_FIRST_FOCUS_WIDGET( m_ui->comboBox_ent_fis_turu );
m_ui->checkbox_banka_ismi->setVisible( false );
m_ui->frame_banka->setVisible( false );
m_ui->checkBox_ent_fis_turu->setChecked( true );
}
else {
SET_PAGE_TITLE( tr ( "BNK - BANKA FİŞ ARAMA" ) );
SET_FIRST_FOCUS_WIDGET( m_ui->adakDate_first_date )
;
m_ui->checkBox_ent_fis_turu->setVisible( false );
m_ui->frame_ent_fis_turu->setVisible( false );
}
REGISTER_TABLE_WIDGET (m_ui->tableWidget);
REGISTER_ARAMA_BUTTONS_WIDGET (m_ui->widget_batch_buttons);
m_ui->frame_entegre_filtresi->setVisible( false );
m_ui->checkBox->setVisible( false );
m_ui->label_fis_filtresi->setVisible(false);
if ( E9_KULLANICI_SIRKET_DEGISTIRE_BILIR_MI() EQ EVET ) {
m_ui->comboBox_fis_filtresi->setVisible( true );
m_ui->label_fis_filtresi->setVisible(true);
m_ui->frame_entegre_filtresi->setVisible( true );
m_ui->checkBox->setVisible( true );
}
QStringList headers;
if ( m_base_fisi_turu EQ ENUM_BANKA_ACILIS_FISI ) {
headers <<tr("Fiş Id")<<tr("Fiş Tarihi")<<tr("Fiş No")<<tr("Açıklama")<<tr("Banka \n Hesabı Tutarı") << tr("Kredi Kartı \n Hesabı Tutarı") << tr("Pos \n Hesabı Tutarı");
}
else {
headers <<tr("Fiş Id")<<tr("Fiş Tarihi")<<tr("Fiş No")<<tr("Açıklama")<<tr("Toplam \n Hesaba Giren")<<tr("Toplam \n Hesaptan Çıkan");
}
SET_HEADERS(headers);
SET_SORTING(false);
m_ui->adakDate_first_date->SET_DATE(MALI_YIL_FIRST_DATE());
m_ui->frame_banka->setEnabled(false);
m_ui->frame_tarih->setEnabled(false);
SQL_QUERY select_query(DB);
select_query.PREPARE_SELECT("bnk_hesaplar","banka_ismi");
if(select_query.SELECT("banka_ismi") NE 0 ) {
while (select_query.NEXT()) {
m_ui->combobox_banka_ismi->addItem(select_query.VALUE(0).toString());
}
m_ui->combobox_banka_ismi->setCurrentIndex(-1);
}
m_ui->tableWidget->hideColumn ( FIS_ID_COLUMN );
m_ui->tableWidget->setColumnWidth ( FIS_TARIHI_COLUMN, 240 );
m_ui->tableWidget->setColumnWidth ( FIS_NO_COLUMN, 70 );
if( m_base_fisi_turu EQ ENUM_BANKA_VIRMAN_FISI ) {
m_ui->tableWidget->setColumnWidth ( FIS_TARIHI_COLUMN, 200 );
m_ui->tableWidget->setColumnWidth ( ACIKLAMA_COLUMN, 400 );
SET_SETTING_NAME("BANKA_VIRMAN_FISI");
}
else if ( m_base_fisi_turu EQ ENUM_BANKA_ACILIS_FISI ) {
m_ui->tableWidget->setColumnWidth ( FIS_TARIHI_COLUMN, 200 );
m_ui->tableWidget->setColumnWidth ( ACIKLAMA_COLUMN, 250 );
m_ui->tableWidget->setColumnWidth ( MAKRO_TUTARI_COLUMN, 120 );
m_ui->tableWidget->setColumnWidth ( MAKRO_TUTARI_COLUMN_2, 120 );
m_ui->tableWidget->setColumnWidth ( MAKRO_TUTARI_COLUMN_2, 120 );
SET_SETTING_NAME("BANKA_ACILIS_FISI");
}
else {
m_ui->tableWidget->setColumnWidth ( FIS_TARIHI_COLUMN, 200 );
m_ui->tableWidget->setColumnWidth ( ACIKLAMA_COLUMN, 250 );
m_ui->tableWidget->setColumnWidth ( MAKRO_TUTARI_COLUMN, 120 );
m_ui->tableWidget->setColumnWidth ( MAKRO_TUTARI_COLUMN_2, 120 );
SET_SETTING_NAME("BANKA_HAREKET_FISI");
}
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
SET_FIND_BUTTON_NAME ( tr ( "Fişleri Bul" ) );
}
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 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_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 FAT_TOPLU_FATURALASTIR_ARAMA::SETUP_FORM()
{
SQL_QUERY query ( DB );
SET_HELP_PAGE( "fatura-islemleri_satis-toplu-irsaliye-faturalastirma" );
SET_PAGE_TITLE( tr ( "FAT - TOPLU İRSALİYE FATURALAŞTIRMA" ) );
SET_NAME_OF_RUN_BATCH_BUTTON ( "Faturala" );
REGISTER_TABLE_WIDGET ( m_ui->tableWidget );
REGISTER_ARAMA_BUTTONS_WIDGET ( m_ui->widget_batch_buttons );
SET_FIRST_FOCUS_WIDGET ( m_ui->searchEdit_cari_hesap_kodu );
REGISTER_SAVER_BUTTON ( m_ui->toolButton_faturalastir );
SET_FIRST_FOCUS_WIDGET ( m_ui->adakDate_irs_baslangic_tarihi );
//! default value
m_ui->toolButton_faturalastir->setEnabled( false );
m_ui->checkBox_irsaliye_tarih_araligi->setChecked( true );
m_ui->frame_irsaliye_tarih_araligi->setEnabled ( true );
m_ui->checkBox_fatura_tarihi->setEnabled( false );
m_ui->frame_gruplar->setEnabled( false );
m_ui->frame_cari_hesap_kodu->setEnabled( false );
//! end
m_sube_id = SUBE_GET_SUBE_ID();
if ( SUBE_GET_SUBE_ISLEM_YETKISI() EQ SADECE_UNITE_SUBESINDE ) {
m_ui->frame_sube->setVisible( false );
m_ui->checkBox_sube_kodu->setVisible( false );
}
else {
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 );
}
m_irs_faturalandirilacak_gun_sayisi = 0;
query.PREPARE_SELECT ( "e9_sabit_degerler","irs_faturalandirilacak_gun" ,"sabit_deger_id = :sabit_deger_id" );
query.SET_VALUE(":sabit_deger_id" , 1);
if ( query.SELECT() > 0 ) {
query.NEXT();
m_irs_faturalandirilacak_gun_sayisi = query.VALUE(0).toInt();
}
int bas_tarihi_gunu = m_ui->adakDate_fatura_tarihi->QDATE().day() - m_irs_faturalandirilacak_gun_sayisi;
if ( bas_tarihi_gunu > 0 ) {
m_ui->adakDate_irs_baslangic_tarihi->SET_DATE( QDate(m_ui->adakDate_fatura_tarihi->QDATE().year(),
m_ui->adakDate_fatura_tarihi->QDATE().month(),
bas_tarihi_gunu) );
}
else {
bas_tarihi_gunu += m_irs_faturalandirilacak_gun_sayisi;
m_ui->adakDate_irs_baslangic_tarihi->SET_DATE( QDate ( m_ui->adakDate_fatura_tarihi->QDATE().year(),
m_ui->adakDate_fatura_tarihi->QDATE().month(),
bas_tarihi_gunu ) );
}
SET_HEADERS ( QStringList() <<tr("Fiş No")<<tr("Fiş Tarihi")<<tr("Cari Hesap Adı")<<tr("Fiş Tutarı") );
SET_SORTING ( false );
m_ui->tableWidget->setColumnWidth ( 0, 50 );
m_ui->tableWidget->setColumnWidth ( 1, 100 );
m_ui->tableWidget->setColumnWidth ( 2, 200 );
m_ui->tableWidget->setColumnWidth ( 3, 100 );
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
SET_SETTING_NAME ( "FAT_TOPLU_FATURALASTIR_ARAMA" );
}
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 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 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();
}
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 CARI_KART_ARAMA::SETUP_FORM()
{
SET_HELP_PAGE ( "cari_kart_arama.html" );
// PERSOANEL MODULU BU ARAMAYI KULLANIYOR KENDI BASLIGI GELMESI LAZIM
if ( m_program_id EQ E9_PROGRAMI AND m_modul_id NE PERSONEL_MODULU ) {
if ( m_cari_kart_turu EQ SAHIS_KAYDI ) {
SET_PAGE_TITLE("CARİ - ŞAHIS KARTI ARAMA");
}
else if( m_cari_kart_turu EQ FIRMA_KAYDI ) {
SET_PAGE_TITLE("CARİ - FİRMA KARTI ARAMA");
}
else {
SET_PAGE_TITLE("CARİ - CARİ KART ARAMA");
}
}
m_ui->checkbox_cari_hesap_ismi_hesap_kodu->setChecked ( true );
m_ui->frame_ili_ilcesi->setEnabled ( false );
m_ui->frame_telefon->setEnabled( false );
m_ui->frame_sektor_or_meslek->setEnabled( false );
if ( m_cari_kart_turu EQ SAHIS_KAYDI ) {
GET_MESLEKLER( m_ui->comboBox_sektor_or_meslek );
}
else if ( m_cari_kart_turu EQ FIRMA_KAYDI ) {
GET_SEKTORLER( m_ui->comboBox_sektor_or_meslek );
}
else {
m_ui->frame_sektor_or_meslek->hide();
m_ui->checkBox_sektor_or_meslek->hide();
}
GET_ILLER ( m_ui->combobox_sehir_ismi );
REGISTER_TABLE_WIDGET ( m_ui->table_widget );
REGISTER_ARAMA_BUTTONS_WIDGET ( m_ui->widget_batch_button );
SET_HEADERS(QStringList()<<tr("Cari \n Hesap Id")<<tr("Kodu")<<tr("Adı")
<< QObject::tr("Borcu") << "" << QObject::tr("Alacağı") << ""
<<tr("Şehir")<<tr("İlçe")<<tr("Semt") << tr(""));
SET_SORTING ( false );
SET_FIRST_FOCUS_WIDGET ( m_ui->lineedit_hesap_ismi_hesap_kodu );
m_ui->table_widget->hideColumn(0);
m_ui->lineedit_hesap_ismi_hesap_kodu->setText( m_cari_hesap_ismi_hesap_kodu );
if ( m_ui->lineedit_hesap_ismi_hesap_kodu->text().isEmpty() EQ false ) {
AUTO_START ();
}
else {
m_ui->lineedit_hesap_ismi_hesap_kodu->setText("*");
}
m_ui->checkbox_gruplar->setChecked ( false );
m_ui->frame_gruplar->setEnabled ( false );
m_ui->table_widget->setColumnWidth ( 1, 90 );
m_ui->table_widget->setColumnWidth ( 2, 190 );
m_ui->table_widget->setColumnWidth ( 3, 90 );
m_ui->table_widget->setColumnWidth ( 4, 30 );
m_ui->table_widget->setColumnWidth ( 5, 90 );
m_ui->table_widget->setColumnWidth ( 6, 30 );
m_ui->table_widget->setColumnWidth ( 7, 90 );
m_ui->table_widget->setColumnWidth ( 8, 90 );
m_ui->table_widget->setColumnWidth ( 9, 90 );
m_ui->table_widget->setColumnWidth ( 10,25 );
if ( m_islem_turu EQ CARI_KART_ARAMA_ISLEMI ) {
m_ui->label_dosya_encoding->setVisible ( false );
m_ui->comboBox_dosya_encoding->setVisible( false );
m_ui->tool_button_export->setVisible ( false );
SET_PAGE_TITLE ( m_ekran_ismi );
}
else {
QList< QByteArray > available_coding_list = QTextCodec::availableCodecs() ;
for( int i = 0 ; i < available_coding_list.size() ; ++i ){
m_ui->comboBox_dosya_encoding->addItem( available_coding_list.at(i) );
}
FIND_AND_SET_COMBOBOX_TEXT( m_ui->comboBox_dosya_encoding, tr("UTF-8"));
SET_PAGE_TITLE ( tr ( "DIŞARIYA KAYIT İHRAÇ ET") );
AUTO_START();
}
SET_SETTING_NAME ( "CARI_KART_ARAMA" );
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
SET_FIND_BUTTON_NAME ( tr ( " Bul " ) );
}
