void K9_ONAR_BATCH::SETUP_FORM()
{
SET_PAGE_TITLE ( tr ( "K9 ONAR" ) );
SET_HELP_PAGE ( "yonetim-islemleri_k9-onar" );
SET_AUTO_EXIT_BATCH ( true );
REGISTER_BUTTON_WIDGET ( m_ui->widget_batch_buttons );
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
SET_SETTING_NAME ( "K9_ONAR" );
SET_NAME_OF_RUN_BATCH_BUTTON ( "Onar" );
// default olarak tum sistemi onar gelecek
m_ui->checkBox_tum_sistemi_onar->setChecked( true );
m_ui->label_moduller->setHidden(true);
m_ui->frame_moduller->setHidden(true);
m_tum_sistemi_onar = true;
//
SET_FIRST_FOCUS_WIDGET ( m_ui->checkBox_tum_sistemi_onar );
m_ui->textEdit_aciklama->setReadOnly ( true );
BILGILENDIR ( "Bulunduğunuz firmadaki , seçmiş olduğunuz modüllerin fişlerini,"
"hesap bakiyelerini, depodaki ve ürün kartındaki stok miktarını onarır." );
}
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 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 SQL_INDEX_BATCH::SETUP_FORM()
{
SET_NAME_OF_RUN_BATCH_BUTTON(tr("Save"));
SET_AUTO_EXIT_BATCH ( true );
SET_ENTER_KEY_FOR_RUN_BATCH(true);
REGISTER_BUTTON_WIDGET (m_ui->widget_batch_buttons);
SET_TABLE_WIDGET_DEFAULTS();
READ_INDEXES();
}
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 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 MUH_HESAP_PLANI_KOPYALA_BATCH::SETUP_FORM ()
{
SET_PAGE_TITLE ( tr ( "MUH - HESAP PLANI KOPYALA" ) );
SET_HELP_PAGE ("genel-muhasebe_hesap-plani-kopyala");
REGISTER_BUTTON_WIDGET ( m_ui->widget_batch_buttons );
SET_NAME_OF_RUN_BATCH_BUTTON ( "Kopyala" );
SET_FIRST_FOCUS_WIDGET ( m_ui->searchEdit_veritabani_ismi );
SET_SETTING_NAME ( "MUH_HESAP_PLANI_KOPYALA_BATCH" );
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
}
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 STOK_EKSTRESI_BATCH::SETUP_FORM()
{
SET_PAGE_TITLE ( tr ( "STK - STOK EKSTRESİ" ) );
SET_HELP_PAGE ("stok-islemleri_stok-ekstresi");
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_YIL_365_DATE());
SET_NAME_OF_RUN_BATCH_BUTTON ( "Rapor Al" );
SET_FIRST_FOCUS_WIDGET ( m_ui->search_edit_urun_kodu );
STK_FILL_ALIS_SATIS_DURUMU_COMBO_BOX ( m_ui->comboBox_stok_alis_satis_durumu );
SET_ENTER_KEY_FOR_RUN_BATCH(true);
SET_SETTING_NAME ("STOK_EKSTRESI_BATCH");
m_ui->checkBox_urun_kodu->setChecked( true );
m_ui->frame_urun->setEnabled( true );
m_ui->checkBox_urun_araligi->setChecked( false );
m_ui->frame_urun_araligi->setEnabled( false );
m_depo_id = SUBE_GET_UNITENIN_DEPOSU();
m_depo_islem_yetkisi = SUBE_GET_DEPO_ISLEM_YETKISI();
if ( m_depo_islem_yetkisi EQ SADECE_UNITE_DEPOSUNDA ) {
m_ui->frame_depo->setHidden(true);
m_ui->checkBox_depo->setHidden(true);
}
else {
QString depo_kodu;
QString depo_adi;
SUBE_GET_DEPO_KODU_ADI(m_depo_id, &depo_kodu, &depo_adi);
m_ui->searchEdit_depo_kodu->SET_TEXT(depo_kodu);
m_ui->lineedit_depo_ismi->setText(depo_adi);
m_ui->frame_depo->setDisabled(true);
}
}
void FAT_HIZMET_EKSTRESI_BATCH::SETUP_FORM ()
{
SET_PAGE_TITLE (tr("FAT - HİZMET EKSTRESİ"));
SET_HELP_PAGE ("fatura-islemleri_hizmet-ekstresi");
REGISTER_BUTTON_WIDGET ( m_ui->widget_batch_buttons );
m_entegrasyon_durumu = FIS_HER_IKI_SIRKET;
m_ui->frame_sirket_filtresi->setHidden(true);
K9_FILL_COMBOBOX_RAPOR_SIRKET_FILTRESI(m_ui->comboBox_sirket_filtresi);
if ( K9_KULLANICININ_CALISTIGI_SIRKET() EQ 1 ) {
m_entegrasyon_durumu = FIS_BIRINCI_SIRKET;
}
if ( K9_KULLANICI_SIRKET_DEGISTIRE_BILIR_MI() EQ EVET ) {
m_ui->frame_sirket_filtresi->setHidden(false);
m_entegrasyon_durumu = FIS_HER_IKI_SIRKET;
}
m_ui->comboBox_sirket_filtresi->setCurrentIndex(m_ui->comboBox_sirket_filtresi->findText(K9_GET_RAPOR_SIRKET_FILTRESI_STRING(m_entegrasyon_durumu)));
SET_NAME_OF_RUN_BATCH_BUTTON ( "Rapor Al" );
SET_FIRST_FOCUS_WIDGET ( m_ui->search_edit_hizmet_kodu );
SET_ENTER_KEY_FOR_RUN_BATCH(true);
SET_SETTING_NAME ("HIZMET_EKSTRESI_BATCH");
m_ui->adakDatebas_tarihi->SET_DATE( MALI_YIL_FIRST_DATE());
m_ui->adakDate_bitis_tarihi->SET_DATE( MALI_ARRAY_LAST_DATE());
m_ui->checkBox_hizmet_kodu->setChecked( true );
m_ui->frame_hizmet_kodu->setEnabled( true );
m_ui->frame_hizmet_araligi->setEnabled( false );
m_ui->frame_fatura_alis_satis_turu->setEnabled( false );
m_ui->combobox_hizmet_turu->addItems(QStringList() << QObject::tr("Alınan Hizmet") << QObject::tr("Satılan Hizmet") << QObject::tr( "Alınan / Satılan Hizmet") );
FAT_FILL_ALIS_SATIS_FAT_TURU_COMBO_BOX( m_ui->comboBox_fatura_alis_satis_turu );
m_ui->comboBox_fatura_alis_satis_turu->setCurrentIndex(-1);
}
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 STOK_URUN_LISTESI_BATCH::SETUP_FORM()
{
if ( m_urun_mu_hizmet_mi EQ ENUM_URUN_KARTI ) {
SET_PAGE_TITLE( tr ( "STK - ÜRÜN LİSTESİ" ) );
SET_SETTING_NAME( "STOK_URUN_LISTESI_BATCH" );
}
else {
SET_PAGE_TITLE( tr ( "STK - HİZMET LİSTESİ" ) );
SET_SETTING_NAME( "STOK_HIZMET_LISTESI_BATCH" );
}
SET_HELP_PAGE("urun-listesi");
REGISTER_BUTTON_WIDGET ( m_ui->widget_batch_buttons );
SET_NAME_OF_RUN_BATCH_BUTTON ( "Rapor Al" );
SET_FIRST_FOCUS_WIDGET ( m_ui->searchEdit_bas_urun_kodu );
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
SQL_QUERY query(DB);
query.PREPARE_SELECT( "stk_urunler", "urun_kodu,urun_adi", "hizmet_mi = :hizmet_mi" );
query.SET_VALUE(":hizmet_mi", m_urun_mu_hizmet_mi );
if ( query.SELECT("urun_kodu", 0, 1 ) NE 0 ) {
query.NEXT();
m_ui->searchEdit_bas_urun_kodu->SET_TEXT(query.VALUE(0).toString());
m_ui->lineEdit_bas_urun_adi->setText(query.VALUE(1).toString());
}
query.PREPARE_SELECT("stk_urunler","urun_kodu,urun_adi","hizmet_mi = :hizmet_mi");
query.SET_VALUE(":hizmet_mi", m_urun_mu_hizmet_mi );
if ( query.SELECT("urun_kodu DESC", 0, 1 ) NE 0 ) {
query.NEXT();
m_ui->searchEdit_bts_urun_kodu->SET_TEXT(query.VALUE(0).toString());
m_ui->lineEdit_bts_urun_adi->setText(query.VALUE(1).toString());
}
m_ui->frame_grup_kodu->setDisabled(true);
}
void MUH_GELIR_TABLOSU_BATCH::SETUP_FORM()
{
SET_HELP_PAGE ("genel-muhasebe_gelir-tablosu" );
SET_PAGE_TITLE ( tr ( "MUH - GELİR TABLOSU" ) );
REGISTER_BUTTON_WIDGET ( m_ui->widget_batch_buttons );
SET_SETTING_NAME ( "MUH_GELIR_TABLOSU_BATCH" );
SET_NAME_OF_RUN_BATCH_BUTTON ( "Rapor Al" );
SET_ENTER_KEY_FOR_RUN_BATCH(true);
SET_FIRST_FOCUS_WIDGET( m_ui->adakDate_baslangic_tarihi );
m_ui->adakDate_baslangic_tarihi->SET_DATE( MALI_YIL_FIRST_DATE() );
m_ui->adakDate_bitis_tarihi->SET_DATE( MALI_ARRAY_LAST_DATE() );
m_ui->comboBox_sirket_turu->setVisible(false);
m_ui->label_sirket->setVisible(false);
K9_FILL_COMBOBOX_RAPOR_SIRKET_FILTRESI(m_ui->comboBox_sirket_turu);
if ( K9_KULLANICININ_CALISTIGI_SIRKET() EQ 1 ) {
m_ui->comboBox_sirket_turu->setCurrentIndex(m_ui->comboBox_sirket_turu->findText(K9_GET_RAPOR_SIRKET_FILTRESI_STRING(FIS_BIRINCI_SIRKET)));
}
else {
m_ui->comboBox_sirket_turu->setCurrentIndex(m_ui->comboBox_sirket_turu->findText(K9_GET_RAPOR_SIRKET_FILTRESI_STRING(FIS_HER_IKI_SIRKET)));
}
if ( K9_KULLANICI_SIRKET_DEGISTIRE_BILIR_MI() EQ EVET ) {
m_ui->comboBox_sirket_turu->setVisible(true);
m_ui->label_sirket->setVisible(true);
m_ui->comboBox_sirket_turu->setCurrentIndex(m_ui->comboBox_sirket_turu->findText(K9_GET_RAPOR_SIRKET_FILTRESI_STRING(FIS_HER_IKI_SIRKET)));
}
m_ui->checkBox_bakiyesiz_hesaplar->setChecked(true);
}
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 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 LOGIN_BATCH::SETUP_FORM ()
{
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
SET_NAME_OF_RUN_BATCH_BUTTON ( tr ( "Giriş" ) );
REGISTER_BUTTON_WIDGET ( m_ui->widget_batch_buttons );
SET_PAGE_TITLE( ADAK_PROGRAM_SHORTNAME( ADAK_DISPLAY_ID() ) + tr(" Giriş Ekranı V") + ADAK_PROGRAM_VERSION(ADAK_DISPLAY_ID()));
SET_SETTING_NAME ( "LOGIN_BATCH");
SET_AUTO_EXIT_BATCH ( true );
SET_HELP_PAGE ( "E9_giris");
SET_FIRST_FOCUS_WIDGET( m_ui->line_edit_kullanici_kodu );
SET_WIDGETS_MAX_LENGTH();
m_ui->text_edit_status->setReadOnly(true);
if ( m_user_info->bilgisayar_id EQ -1 ) {
m_user_info->kullanici_kodu.clear();
}
FILL_SQL_PROFILLERI ();
SECILI_PROFILI_YUKLE( m_user_info->secili_sql_profili );
//////////////VERSIYON KONTROLU
// HER PROGRAMIN KENDI LOGOSU SETLENIYOR
switch ( ADAK_DISPLAY_ID() ) {
case E9_PROGRAMI:
m_ui->label_logo->setPixmap( QPixmap( QString::fromUtf8(":/e9_icons/E9_ICONS/e9_logo.png") ));
break;
default:
m_ui->label_logo->setPixmap( QPixmap( QString::fromUtf8(":/yonetim_icons/adak_logo.png") ));
break;
}
m_ui->label_program_adi->setText( ADAK_PROGRAM_LONGNAME (ADAK_DISPLAY_ID()));
QSettings settings ( "ADAK_SETTINGS", ADAK_PROGRAM_SHORTNAME(ADAK_DISPLAY_ID())) ;
//QString check_date = settings.value("last_program_update_check_date","").toString();
QString not_check_update_version = settings.value("not_check_update_version","").toString();
if ( ( not_check_update_version.isEmpty() EQ true OR not_check_update_version NE ADAK_PROGRAM_VERSION( ADAK_DISPLAY_ID() ) ) ) {
const QString html = QVariant ("http://www.adak.com.tr/DOWNLOADS/E9/version.txt").toByteArray();
QNetworkAccessManager * network_access_manager = new QNetworkAccessManager();
QUrl url(html);
QNetworkReply * network_reply = network_access_manager->get ( QNetworkRequest ( url ) );
QEventLoop answer_loop;
answer_loop.connect ( network_reply, SIGNAL ( finished() ), &answer_loop, SLOT ( quit() ) );
QTimer bekleme_suresi;
answer_loop.connect ( &bekleme_suresi, SIGNAL ( timeout() ), &answer_loop, SLOT ( quit() ) );
bekleme_suresi.start ( 1000 );
answer_loop.exec();
QByteArray result = network_reply->readAll();
if ( network_reply->error() != QNetworkReply::NoError ) {
return;
}
QStringList program_list = QVariant(result).toString().split("\n",QString::SkipEmptyParts,Qt::CaseInsensitive);
if (program_list.size() NE 0) {
int index_of_program = -1;
for ( int i = 0 ; i < program_list.size() ; i++ ) {
if ( program_list.at(i).contains(QString("%1-").arg(ADAK_PROGRAM_SHORTNAME(ADAK_DISPLAY_ID())),Qt::CaseInsensitive) EQ true ) {
index_of_program = i;
break;
}
}
if ( index_of_program EQ - 1) {
return;
}
QStringList program_info = program_list.at(index_of_program).split("-",QString::SkipEmptyParts,Qt::CaseInsensitive);
if ( program_info.size() EQ 3 ) {
if ( ADAK_PROGRAM_VERSION(ADAK_DISPLAY_ID()) < program_info.at(1) ) {
OPEN_PROGRAMI_GUNCELLESTIRIN_BATCH(program_info.at(2),program_info.at(1),NULL);
}
}
}
settings.setValue("last_program_update_check_date",QDate::currentDate().toString("yyyy.MM.dd"));
}
//////////////////////////////////////////////
}
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 CARI_ODEME_CEKSENET_BATCH::SETUP_FORM()
{
SET_HELP_PAGE ( "cari_odeme_cek_senet_batch.html" );
if ( m_islem_turu EQ ENUM_MUSTERI_SENEDI OR m_islem_turu EQ ENUM_KENDI_SENEDIMIZ ) {
m_ui->groupBox_musteri_banka_bilgisi->hide();
SET_PAGE_TITLE ( tr ( "CARİ - SENET BİLGİLERİ" ) );
m_ui->label_cek_senet_no->setText ( "Senet Numarası" );
m_ui->groupBox_cek_senet_bilgileri->setTitle ( "Senet Bilgileri" );
}
else {
SET_PAGE_TITLE ( "CARİ - ÇEK BİLGİLERİ" );
m_ui->label_cek_senet_no->setText ( "Çek Numarası" );
m_ui->groupBox_cek_senet_bilgileri->setTitle ( "Çek Bilgileri" );
}
REGISTER_BUTTON_WIDGET ( m_ui->run_batch_widget );
m_ui->adakDate_vade_tarihi->MALI_YIL_KISITI_YOK( true );
m_ui->adakDate_keside_tarihi->MALI_YIL_KISITI_YOK( true );
SET_AUTO_EXIT_BATCH ( true );
m_ui->adakDate_keside_tarihi->SET_DATE( QDate::currentDate() );
m_ui->adakDate_vade_tarihi->SET_DATE( QDate::currentDate() );
if ( m_fis_satiri_id NE -1 ) {
SQL_QUERY query(DB);
query.PREPARE_SELECT("car_fis_satirlari" , "cek_senet_id" ,"fis_satiri_id = :fis_satiri_id");
query.SET_VALUE(":fis_satiri_id" , m_fis_satiri_id);
if ( query.SELECT() NE 0 ) {
query.NEXT();
m_cek_senet_id = query.VALUE(0).toInt();
}
CEK_SENET_STRUCT CEK_STRUCT;
if ( m_cek_senet_id > 0 ) {
CEK_GET_TEMEL_BILGILER( &CEK_STRUCT , m_cek_senet_id);
m_cek_senet_turu = CEK_STRUCT.cek_senet_turu;
m_cek_senet_durumu = CEK_STRUCT.cek_senet_son_durumu;
}
}
SET_NAME_OF_RUN_BATCH_BUTTON ( "Tamam" );
SET_FIRST_FOCUS_WIDGET ( m_ui->adakDate_vade_tarihi );
if ( m_cek_senet_id NE 0 ) {
CEK_SENET_BILGILERINI_GOSTER();
}
if ( m_islem_turu EQ ENUM_MUSTERI_CEKI OR m_islem_turu EQ ENUM_MUSTERI_SENEDI ) {
m_ui->pushButton_duzenle->setHidden(true);
}
SET_ENTER_KEY_FOR_RUN_BATCH(true);
SET_SETTING_NAME ( "CARI_ODEME_CEKSENET_BATCH" );
}
void STOK_MIKTARLARI_BATCH::SETUP_FORM()
{
SET_PAGE_TITLE ( tr ( "STK - STOK MİKTARI RAPORU" ) );
SET_HELP_PAGE ("stok-islemleri_stok-miktarlari-raporu");
REGISTER_BUTTON_WIDGET ( m_ui->widget_batch_buttons );
m_ui->adakDate_stok_tarihi->SET_DATE( QDate::currentDate() );
m_depo_id = -1;
m_ui->frame_sirket->setHidden(true);
if ( E9_KULLANICI_SIRKET_DEGISTIRE_BILIR_MI() EQ EVET ) {
m_ui->frame_sirket->setHidden(false);
}
SET_NAME_OF_RUN_BATCH_BUTTON ( "Rapor Al" );
SET_ENTER_KEY_FOR_RUN_BATCH(true);
SET_FIRST_FOCUS_WIDGET ( m_ui->searchEdit_bas_urun_kodu );
SET_SETTING_NAME ("STOK_MIKTARLARI_BATCH");
SQL_QUERY query(DB);
query.PREPARE_SELECT("stk_urunler","urun_kodu,urun_adi" ,"hizmet_mi = :hizmet_mi" );
query.SET_VALUE(":hizmet_mi" , 0);
if ( query.SELECT("urun_kodu ASC",0,1) NE 0 ) {
query.NEXT();
m_ui->searchEdit_bas_urun_kodu->SET_TEXT(query.VALUE(0).toString());
m_ui->lineEdit_bas_urun_adi->setText(query.VALUE(1).toString());
}
query.PREPARE_SELECT("stk_urunler","urun_kodu,urun_adi" ,"hizmet_mi = :hizmet_mi" );
query.SET_VALUE(":hizmet_mi" , 0);
if ( query.SELECT("urun_kodu DESC",0,1) NE 0 ) {
query.NEXT();
m_ui->searchEdit_bts_urun_kodu->SET_TEXT(query.VALUE(0).toString());
m_ui->lineEdit_bts_urun_adi->setText(query.VALUE(1).toString());
}
m_depo_id = SUBE_GET_UNITENIN_DEPOSU();
if ( SUBE_GET_DEPO_ISLEM_YETKISI() EQ SADECE_UNITE_DEPOSUNDA ) {
m_ui->frame_depo_araligi->setHidden(true);
m_ui->checkBox_depo_kodu->setHidden(true);
}
else {
QString depo_kodu;
QString depo_adi;
SUBE_GET_DEPO_KODU_ADI(m_depo_id, &depo_kodu, &depo_adi);
m_ui->searchEdit_depo_kodu->SET_TEXT(depo_kodu);
m_ui->lineEdit_depo_ismi->setText(depo_adi);
}
m_ui->frame_depo_araligi->setDisabled(true);
m_ui->frame_grup_araligi->setDisabled(true);
m_ui->frame_stok_tarihi->setEnabled( false );
}
void FAT_FATURA_DETAYLARI_BATCH::SETUP_FORM()
{
SET_PAGE_TITLE( tr ( "FAT - FATURA ENTEGRASYON HESAPLARI" ) );
SET_SETTING_NAME( "FATURA_ENT_HESAPLARI_BATCH" );
SET_HELP_PAGE( "fatura-entegrasyon-hesaplari" );
REGISTER_BUTTON_WIDGET ( m_ui->widget_batch_buttons );
m_ui->commaEdit_cari_fis_no->VIRGULSUZ_CALIS ( true );
m_ui->commaEdit_cari_fis_no->SET_PRECISION ( 0 );
m_ui->commaEdit_cari_fis_no->SET_RETURN_EMPTY ( true );
m_ui->commaEdit_muh_fis_no->VIRGULSUZ_CALIS ( true );
m_ui->commaEdit_muh_fis_no->SET_PRECISION ( 0 );
m_ui->commaEdit_muh_fis_no->SET_RETURN_EMPTY ( true );
SUBE_ENTEGRASYON_HESAPLARI_STRUCT * SB_ENT_HESAPLARI = ( SUBE_ENTEGRASYON_HESAPLARI_STRUCT * ) SUBE_GET_ENTEGRASYON_HESAPLARI_STRUCT();
m_ui->commaEdit_tevkifat_yuzdesi->VIRGULSUZ_CALIS ( true );
if ( m_fatura_alis_satis_iade_turu EQ ENUM_ALIS_IRSALIYESI_FATURASI ) {
m_ui->label_yurtici_satislar->setHidden(true);
m_ui->searchEdit_sube_yurtici_satis_hsp_id->setHidden(true);
m_ui->lineEdit_sube_yurtici_satis_hsp_id->setHidden(true);
}
if ( M_FATURA_DETAYLARI->yurtici_satislar_hesap_id EQ 0 ) {
m_sube_yurtici_satis_hsp_id = SB_ENT_HESAPLARI->yurtici_sts_hsp_id;
}
else {
m_sube_yurtici_satis_hsp_id = M_FATURA_DETAYLARI->yurtici_satislar_hesap_id;
}
if ( M_FATURA_DETAYLARI->hizmet_urt_maliyeti_hesap_id EQ 0 ) {
m_sube_hizmet_urt_maliyet_hsp_id = SB_ENT_HESAPLARI->hizmet_uretim_maliyeti_hsp_id;
}
else {
m_sube_hizmet_urt_maliyet_hsp_id = M_FATURA_DETAYLARI->hizmet_urt_maliyeti_hesap_id;
}
if ( M_FATURA_DETAYLARI->satistan_iade_hesap_id EQ 0 ) {
m_satistan_iade_hesap_id = SB_ENT_HESAPLARI->satistan_iade_hesap_id;
}
else {
m_satistan_iade_hesap_id = M_FATURA_DETAYLARI->satistan_iade_hesap_id;
}
m_ui->checkBox_tevkifatli_fatura_mi->setChecked ( QVariant ( M_FATURA_DETAYLARI->tevkifatli_fatura_mi ).toBool() );
m_ui->frame_tevkifat->setEnabled ( m_ui->checkBox_tevkifatli_fatura_mi->isChecked() );
if ( m_ui->checkBox_tevkifatli_fatura_mi->isChecked() EQ true ) {
m_ui->commaEdit_tevkifat_yuzdesi->SET_DOUBLE ( M_FATURA_DETAYLARI->tevkifat_yuzdesi );
}
m_ui->checkBox_kdv_muaf_mi->setChecked(QVariant(M_FATURA_DETAYLARI->kdv_muaf_mi).toBool());
m_ui->checkBox_otv_muaf_mi->setChecked(QVariant(M_FATURA_DETAYLARI->otv_muaf_mi).toBool());
QString tam_hesap_kodu,hesap_ismi;
if ( m_sube_yurtici_satis_hsp_id > 0 ) {
MUH_GET_HESAP_KODU_HESAP_ISMI(m_sube_yurtici_satis_hsp_id , tam_hesap_kodu,hesap_ismi);
m_ui->searchEdit_sube_yurtici_satis_hsp_id->SET_TEXT ( tam_hesap_kodu );
m_ui->lineEdit_sube_yurtici_satis_hsp_id->setText ( hesap_ismi );
}
if ( m_sube_hizmet_urt_maliyet_hsp_id > 0 ) {
MUH_GET_HESAP_KODU_HESAP_ISMI(m_sube_hizmet_urt_maliyet_hsp_id , tam_hesap_kodu,hesap_ismi);
m_ui->searchEdit_sube_hizmet_urt_maliyet_hsp_id->SET_TEXT ( tam_hesap_kodu );
m_ui->lineEdit_sube_hizmet_urt_maliyet_hsp_id->setText ( hesap_ismi );
}
if ( m_satistan_iade_hesap_id > 0 ) {
MUH_GET_HESAP_KODU_HESAP_ISMI(m_satistan_iade_hesap_id , tam_hesap_kodu,hesap_ismi);
m_ui->searchEdit_satistan_iade_hesap_id->SET_TEXT ( tam_hesap_kodu );
m_ui->lineEdit_satistan_iade_hesap_id->setText ( hesap_ismi );
}
if ( M_FATURA_DETAYLARI->kdv_muaf_mi EQ 1 ) {
m_ui->checkBox_kdv_muaf_mi->setChecked(true);
}
if ( M_FATURA_DETAYLARI->otv_muaf_mi EQ 1 ){
m_ui->checkBox_otv_muaf_mi->setChecked(true);
}
m_ui->commaEdit_muh_fis_no->SET_INTEGER ( M_FATURA_DETAYLARI->muh_fis_no );
m_ui->commaEdit_cari_fis_no->SET_INTEGER ( M_FATURA_DETAYLARI->cari_fis_no );
SET_NAME_OF_RUN_BATCH_BUTTON ( tr ( "Detayları Kaydet" ) );
SET_FIRST_FOCUS_WIDGET ( m_ui->searchEdit_sube_yurtici_satis_hsp_id );
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
}
void FAT_FATURA_LISTESI_BATCH::SETUP_FORM()
{
SET_PAGE_TITLE ( tr ( "FAT - FATURA LİSTESİ" ) );
SET_HELP_PAGE ("fatura-islemleri_fatura-listesi");
REGISTER_BUTTON_WIDGET ( m_ui->widget_batch_buttons );
m_ui->frame_sirket_filtresi->setVisible( false );
m_ui->checkBox_sirket_filtresi->setVisible( false );
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->checkBox_tarih_araligi->setChecked( true );
m_ui->frame_tarih_araligi->setEnabled( true );
SET_FIRST_FOCUS_WIDGET( m_ui->adakDate_bas_tarihi );
if ( E9_KULLANICI_SIRKET_DEGISTIRE_BILIR_MI() EQ EVET ) {
m_ui->frame_sirket_filtresi->setVisible( true );
m_ui->checkBox_sirket_filtresi->setVisible( true );
m_ui->frame_sirket_filtresi->setEnabled( true );
m_ui->checkBox_sirket_filtresi->setChecked( true );
}
DISABLE_CLEAR_ON_WIDGET( m_ui->comboBox_sirket_filtresi );
SET_SETTING_NAME ("FAT_FATURA_LISTESI_BATCH");
SET_NAME_OF_RUN_BATCH_BUTTON ( "Rapor Al" );
SET_ENTER_KEY_FOR_RUN_BATCH( true );
m_ui->commaEdit_min_tutar->SET_PRECISION( 2 );
m_ui->commaEdit_min_tutar->SET_RETURN_EMPTY( false );
m_ui->commaEdit_min_tutar->SET_PRECISION( 2 );
m_ui->commaEdit_max_tutar->SET_RETURN_EMPTY( false );
m_ui->adakDate_bas_tarihi->SET_DATE(MALI_YIL_FIRST_DATE());
m_ui->adakDate_bts_tarihi->SET_DATE(MALI_ARRAY_LAST_DATE());
m_ui->frame_fatura_durumu->setDisabled(true);
m_ui->comboBox_irsaliye_durumu->addItems(QStringList() << tr("İrsaliyelenmiş") << tr("İrsaliyelenmemiş"));
m_ui->comboBox_irsaliye_durumu->setCurrentIndex(-1);
m_ui->frame_cari_hesap->setDisabled(true);
m_ui->frame_tutar_araligi->setDisabled(true);
m_ui->frame_fatura_alis_satis_turu->setDisabled(true);
m_ui->label_sirket->setDisabled(true);
m_ui->comboBox_sirket_filtresi->setDisabled(true);
m_ui->frame_fatura_turu->setEnabled( false );
FAT_FILL_ALIS_SATIS_FAT_TURU_COMBO_BOX( m_ui->comboBox_fatura_alis_satis_turu );
m_ui->comboBox_fatura_alis_satis_turu->setCurrentIndex(-1);
m_cari_hesap_id = -1;
m_depo_id = -1;
}
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 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 MUH_MIZAN_RAPORU_BATCH::SETUP_FORM()
{
SET_HELP_PAGE ( "mizan" );
SET_PAGE_TITLE ( "MUH - MİZAN" );
REGISTER_BUTTON_WIDGET ( m_ui->widget_batch_buttons );
SET_SETTING_NAME ( "MUH_MIZAN_RAPORU_BATCH" );
SET_NAME_OF_RUN_BATCH_BUTTON ( tr ( "Rapor Al" ) );
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
SET_FIRST_FOCUS_WIDGET( m_ui->comboBox_mizan_donemi );
m_grup_idleri.clear();
SQL_QUERY sql_query ( DB );
sql_query.PREPARE_SELECT("e9_kullanici_yetkileri" , "mizan_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());
m_ui->frame_tarih_araligi->setDisabled(true);
sql_query.PREPARE_SELECT("muh_hesaplar" , "tam_hesap_kodu,hesap_ismi" );
if (sql_query.SELECT("tam_hesap_kodu ASC" , 0,1) NE 0 ) {
sql_query.NEXT();
m_ui->search_edit_bas_hesap_kodu->SET_TEXT ( sql_query.VALUE(0).toString() );
m_ui->lineedit_bas_hesap_ismi->setText ( sql_query.VALUE(1).toString() );
}
sql_query.PREPARE_SELECT("muh_hesaplar" , "tam_hesap_kodu,hesap_ismi" );
if ( sql_query.SELECT("tam_hesap_kodu DESC" , 0,1) NE 0 ) {
sql_query.NEXT();
m_ui->search_edit_bts_hesap_kodu->SET_TEXT ( sql_query.VALUE(0).toString() );
m_ui->lineedit_bts_hesap_ismi->setText ( sql_query.VALUE(1).toString() );
}
m_ui->spinbox_mizan_seviyesi->setMinimum(1);
m_ui->spinbox_mizan_seviyesi->setMaximum(5);
if ( E9_KULLANICI_SIRKET_DEGISTIRE_BILIR_MI() EQ EVET ) {
m_ui->comboBox_sirket->setVisible(true);
m_ui->label_sirket->setVisible(true);
}
DISABLE_CLEAR_ON_WIDGET(m_ui->comboBox_mizan_donemi);
FILL_COMBOBOX_MIZAN_DONEMI(m_ui->comboBox_mizan_donemi);
if ( QDate::currentDate().year() EQ MALI_YIL_FIRST_DATE().year() OR
QDate::currentDate().year() EQ MALI_ARRAY_LAST_DATE().year() ) {
m_current_mizan_donemi = GET_MZN_DONEMI_AY_STR(QDate::currentDate().month()) +
QVariant(QDate::currentDate().year()).toString();
}
else {
m_current_mizan_donemi = GET_MZN_DONEMI_AY_STR(MALI_YIL_365_DATE().month()) +
QVariant(MALI_YIL_365_DATE().year()).toString();
}
m_ui->comboBox_mizan_donemi->setCurrentIndex(m_ui->comboBox_mizan_donemi->findText( m_current_mizan_donemi));
GET_MZN_DONEMINE_GORE_BAS_BTS_TARIHI(m_current_mizan_donemi , m_ui->adakDate_baslangic_tarihi,
m_ui->adakDate_bts_tarihi);
if ( nakli_yekun EQ 1 ) {
m_ui->adakDate_baslangic_tarihi->SET_DATE(MALI_YIL_FIRST_DATE());
m_ui->adakDate_baslangic_tarihi->setDisabled(true);
}
}
void E9_EFT_BATCH::SETUP_FORM()
{
SET_PAGE_TITLE ( tr ( "HAVALE / EFT DETAYLARI" ) );
SET_HELP_PAGE ( "e9-eft-havele" );
REGISTER_BUTTON_WIDGET ( m_ui->widget_batch_buttons );
SET_FIRST_FOCUS_WIDGET ( m_ui->comboBox_banka_hesap_kodu );
SET_NAME_OF_RUN_BATCH_BUTTON ( "Tamam" );
SET_ENTER_KEY_FOR_RUN_BATCH ( true );
SET_SETTING_NAME ( "E9_EFT_BATCH" );
SET_AUTO_EXIT_BATCH ( true );
BNK_FILL_COMBO_BOX_BANKA_HESAPLARI( m_ui->comboBox_banka_hesap_kodu );
DISABLE_CLEAR_ON_WIDGET(m_ui->combobox_banka_ismi);
m_hesap_no_id = 0;
m_ui->frame_musteri_banka_bilgisi->setHidden(true);
if ( m_fis_turu EQ ENUM_CARI_ODEME_FISI ){
GET_BANKALAR ( m_ui->combobox_banka_ismi );
if ( m_islem_turu EQ ENUM_HAVALE ) {
m_ui->combobox_banka_ismi->setDisabled(true);
}
m_ui->frame_musteri_banka_bilgisi->setHidden(false);
}
if ( m_modul_id EQ PERAKENDE_MODULU OR m_modul_id EQ SMM_MODULU OR m_modul_id
EQ ISLETME_MODULU ) {
if ( m_islem_turu EQ ENUM_HAVALE ) {
GET_BANKALAR ( m_ui->combobox_banka_ismi );
m_ui->combobox_banka_ismi->setDisabled(true);
}
}
if ( m_fis_satiri_id EQ -1 ) {
if ( m_modul_id EQ CARI_MODULU ) {
m_ui->lineedit_hesap_no->setText(M_ISLEM_DETAYLARI->hesap_no);
m_ui->combobox_banka_ismi->setEditText(M_ISLEM_DETAYLARI->sube_adi);
m_ui->lineedit_sube_kodu->setText(M_ISLEM_DETAYLARI->sube_kodu);
m_ui->combobox_sube_ismi->setEditText(M_ISLEM_DETAYLARI->sube_adi);
m_ui->combobox_banka_ismi->setEditText(M_ISLEM_DETAYLARI->banka_ismi);
}
m_hesap_no_id = M_ISLEM_DETAYLARI->bnk_hesap_no_id;
SQL_QUERY query(DB);
query.PREPARE_SELECT("bnk_hesaplar",
"banka_hesap_kodu,banka_ismi,sube_kodu,sube_ismi,hesap_numarasi,doviz_id",
"hesap_no_id = :hesap_no_id AND doviz_id = :doviz_id");
query.SET_VALUE(":hesap_no_id" , m_hesap_no_id);
query.SET_VALUE(":doviz_id" , m_makbuz_para_birimi_id);
if ( query.SELECT() NE 0 ) {
query.NEXT();
m_ui->comboBox_banka_hesap_kodu->setCurrentIndex(m_ui->comboBox_banka_hesap_kodu->findText(query.VALUE(0).toString()));
QString banka_bilgisi = query.VALUE(1).toString() + " / " + query.VALUE(2).toString() + " " + query.VALUE(3).toString()
+ " " + query.VALUE(4).toString();
m_ui->lineEdit_bnk_sube_bilgisi->setText(banka_bilgisi);
m_ui->lineEdit_doviz_cinsi->setText(DVZ_GET_DOVIZ_KODU(query.VALUE(5).toInt()));
}
}
else {
SQL_QUERY sql_query(DB);
if ( m_modul_id EQ CARI_MODULU ) {
sql_query.PREPARE_SELECT("car_fis_satirlari",
"hesap_no_id , musteri_banka_ismi , musteri_sube_kodu , musteri_sube_ismi,musteri_hesap_no",
"fis_satiri_id = :fis_satiri_id");
}
else if ( m_modul_id EQ PERAKENDE_MODULU ) {//Perakende modulu
sql_query.PREPARE_SELECT("prk_fis_satirlari",
"hesap_no_id",
"fis_satiri_id = :fis_satiri_id");
}
else if ( m_modul_id EQ ISLETME_MODULU ) {
sql_query.PREPARE_SELECT("isl_fis_satirlari",
"hesap_no_id",
"fis_satiri_id = :fis_satiri_id");
}
sql_query.SET_VALUE(":fis_satiri_id" , m_fis_satiri_id);
if ( sql_query.SELECT() NE 0 ) {
sql_query.NEXT();
m_hesap_no_id = sql_query.VALUE(0).toInt();
if ( m_fis_turu EQ ENUM_CARI_ODEME_FISI ) {
GET_BANKA_SUBE_ADLARI(m_ui->combobox_sube_ismi,sql_query.VALUE(1).toString());
if ( sql_query.VALUE(1).toString() EQ NULL) {
m_ui->combobox_banka_ismi->setEditText(M_ISLEM_DETAYLARI->banka_ismi);
}
else {
m_ui->combobox_banka_ismi->setEditText(sql_query.VALUE(1).toString());
}
if ( sql_query.VALUE(2).toString() EQ NULL ) {
m_ui->lineedit_sube_kodu->setText(M_ISLEM_DETAYLARI->sube_kodu);
}
else {
m_ui->lineedit_sube_kodu->setText(sql_query.VALUE(2).toString());
}
if ( sql_query.VALUE(3).toString() EQ NULL ) {
m_ui->combobox_sube_ismi->setEditText(M_ISLEM_DETAYLARI->sube_adi);
}
else {
m_ui->combobox_sube_ismi->setEditText(sql_query.VALUE(3).toString());
}
if ( sql_query.VALUE(4).toString() EQ NULL ) {
m_ui->lineedit_hesap_no->setText(M_ISLEM_DETAYLARI->hesap_no);
}
else {
m_ui->lineedit_hesap_no->setText(sql_query.VALUE(4).toString());
}
}
int row = BNK_HESAPLARI_MODEL_INDEX_BUL( m_hesap_no_id, m_ui->comboBox_banka_hesap_kodu );
if ( row > -1) {
m_ui->comboBox_banka_hesap_kodu->setCurrentIndex(m_ui->comboBox_banka_hesap_kodu->findText(BNK_GET_DATA_FROM_BNK_HESAPLARI_MODEL(m_ui->comboBox_banka_hesap_kodu,row,2).toString()));
m_ui->lineEdit_doviz_cinsi->setText ( DVZ_GET_DOVIZ_KODU ( BNK_GET_DATA_FROM_BNK_HESAPLARI_MODEL ( m_ui->comboBox_banka_hesap_kodu, row, 1 ).toInt()) );
QString banka_bilgisi = BNK_GET_DATA_FROM_BNK_HESAPLARI_MODEL ( m_ui->comboBox_banka_hesap_kodu, row, 3 ).toString() + " / " +
BNK_GET_DATA_FROM_BNK_HESAPLARI_MODEL ( m_ui->comboBox_banka_hesap_kodu, row, 4 ).toString() + " " +
BNK_GET_DATA_FROM_BNK_HESAPLARI_MODEL ( m_ui->comboBox_banka_hesap_kodu, row, 5 ).toString() + " " +
BNK_GET_DATA_FROM_BNK_HESAPLARI_MODEL ( m_ui->comboBox_banka_hesap_kodu, row, 6 ).toString();
m_ui->lineEdit_bnk_sube_bilgisi->setText ( banka_bilgisi );
}
}
}
}
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 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" );
}
