VERITABANI_SECIMI::VERITABANI_SECIMI( int kullanici_id , QString * veritabani_ismi , QString * veritabani_tanimi , QWidget *parent ) : SECIM_KERNELI ( parent )
{
    if ( kullanici_id EQ 1 ) {
        m_kullanici_id           = -1;
    }
    else {
        m_kullanici_id           = kullanici_id;
    }

    m_veritabani_ismi        = veritabani_ismi;
    m_veritabani_tanimi      = veritabani_tanimi;

    SET_WINDOW_SIZE  (400, 400 );
    SET_PAGE_TITLE ( QObject::tr ( "DATABASE SELECTION" ) );
    SET_HEADERS ( QStringList()<<QObject::tr("Database Id")<<QObject::tr ( "Database" )<<QObject::tr ( "Database Definition" ) );
    SET_SORTING ( false );

    SET_HELP_PAGE   ( "yonetim-islemleri_veritabani-degistir" );


    INIT_KERNEL (G_YONETIM_DB);

    QTableWidget * table_widget = GET_TABLE_WIDGET();

    table_widget->horizontalHeader()->setDefaultSectionSize(0);

    table_widget->hideColumn(0);
    table_widget->setColumnWidth ( 1,  30 );
    table_widget->setColumnWidth ( 2,  70 );

    SET_SETTING_NAME   ( "VERITABANI_SECIMI" );

}
KULLANICI_SECIMI::KULLANICI_SECIMI( bool p_yonetici_goster, QWidget * p_parent, QStringList * P_VAROLAN_KULLANICI_ID_LIST )
: SECIM_KERNELI ( p_parent ), m_yonetici_goster ( p_yonetici_goster )
{

    M_VAROLAN_KULLANICI_ID_LIST = P_VAROLAN_KULLANICI_ID_LIST;

    SET_WINDOW_SIZE                      ( 500, 700 );

    SET_PAGE_TITLE                       ( "KULLANICI SEÇİMİ");
    SET_HELP_PAGE                        ( "kullanici_secimi");

    SET_SORTING                          ( false );

    SET_HEADERS                          ( QStringList()<<"Kullanıcı_id"<<"kullanıcı kodu"
                                          <<"Kullanıcı Adı"<<"Email adresi");

    INIT_KERNEL                          ( G_YONETIM_DB );

    QTableWidget * table_widget = GET_TABLE_WIDGET ();

    table_widget->hideColumn(0);

    table_widget->setColumnWidth ( 1,  100 );
    table_widget->setColumnWidth ( 2,  250 );
    table_widget->setColumnWidth ( 3,  250 );

    SET_SETTING_NAME  ("KULLANICI_SECIMI");
}
STOK_GIDEN_PARTI_NO_SECIMI::STOK_GIDEN_PARTI_NO_SECIMI( int p_depo_id, int p_urun_id, int p_secili_parti_no, QWidget * parent ) : SECIM_KERNELI ( parent )
{
    m_depo_id = p_depo_id;
    m_urun_id = p_urun_id;

    SET_SORTING(false);
    SET_WINDOW_SIZE ( 300, 700 );
    QString urun_adi;
    STK_GET_URUN_KODU_ADI( p_urun_id, NULL, &urun_adi );

    SET_HEADERS ( QStringList()<<tr("part_no_id")<<tr("Parti Kodu")<<tr("Ürün Miktarı") << tr("Üretim Tarihi") << tr("Son K. Tarihi"));

    SET_PAGE_TITLE    ( "PARTİ KODU SEÇİMİ" );
    SET_SETTING_NAME  ( "STOK_GIDEN_PARTI_NO_SECIMI" );
    SET_HELP_PAGE     ( tr("stok_giden_parti_no_secimi.html") );

    INIT_KERNEL ( DB );

    QTableWidget * tablewidget = GET_TABLE_WIDGET();

    tablewidget->hideColumn(0);

    tablewidget->setColumnWidth( 1 , 40);
    tablewidget->setColumnWidth( 2 , 20);
    tablewidget->setColumnWidth( 3 , 20);
    tablewidget->setColumnWidth( 4 , 20);

    QList< int > secili_olacak_id;
    secili_olacak_id << p_secili_parti_no;
    SELECT_LINES( secili_olacak_id );
}
Example #4
0
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();
}
IRS_IADE_IRSALIYE_SECIMI::IRS_IADE_IRSALIYE_SECIMI ( QString p_irsaliye_tarihi, int p_cari_hesap_id, int p_irsaliye_alis_satis_turu,int p_irsaliye_turu, QWidget * p_parent ) : SECIM_KERNELI ( p_parent )
{
    SET_HELP_PAGE ("irs_iade_irsaliye_secimi.html");

    m_irsaliye_tarihi_bitis     = p_irsaliye_tarihi;
    m_cari_hesap_id             = p_cari_hesap_id;
    m_irsaliye_alis_satis_turu  = p_irsaliye_alis_satis_turu;
    m_irsaliye_turu             = p_irsaliye_turu;


    SET_WINDOW_SIZE     ( 300, 500 );
    SET_SORTING         ( false );
    SET_HEADERS         ( QStringList() << tr("irsaliye_id") << tr("İrsaliye No") <<tr("İrs. Seri No")
                                        << tr("İrs. Tarihi") );

    INIT_KERNEL         ( DB );

    QTableWidget * tableWidget = GET_TABLE_WIDGET();

    tableWidget->setColumnWidth ( FIS_NO_COLUMN,                    100 );
    tableWidget->setColumnWidth ( IRSALIYE_BELGE_SERI_NO_COLUMN,    100 );
    tableWidget->setColumnWidth ( IRSALIYE_TARIHI_COLUMN,           100 );

    SET_SETTING_NAME            ( "IRS_IADE_IRSALIYE_SECIMI" );

    SET_PAGE_TITLE              ( tr ( "İRS - İADE İRSALİYE SEÇİMİ" ) );

    tableWidget->hideColumn     ( 0 );

}
Example #6
0
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 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 );
}
Example #8
0
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();
}
TASARIM_BELGE_DEGISKENLERI_SECIMI::TASARIM_BELGE_DEGISKENLERI_SECIMI( QList< TASARIM_DEGISKENI*> p_degisken_listesi, QWidget * parent ) : SECIM_KERNELI ( parent )
{

    m_degisken_listesi = p_degisken_listesi;

    SET_SORTING( false );

    SET_WINDOW_SIZE ( 400, 350 );
    SET_HEADERS (QStringList() << "Degisken Id" << "Değişken Adı" );

    SET_PAGE_TITLE    ( tr ( "DEĞİŞKEN SEÇİMİ" ) );
    SET_SETTING_NAME  ( "DEGISKEN_SECIMI" );
    SET_HELP_PAGE     ( tr("degisken_secimi") );

    INIT_KERNEL ( DB );



    QTableWidget * table_widget = GET_TABLE_WIDGET();

    table_widget->hideColumn( 0 );
    table_widget->setColumnWidth( 1, 100 );
}
Example #11
0
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 ();
    }
}
Example #12
0
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" );
}
FAT_IRSALIYE_SATIR_SECIMI::FAT_IRSALIYE_SATIR_SECIMI ( QString p_fatura_tarihi, int p_cari_hesap_id, int p_fatura_turu, QWidget * p_parent ) : SECIM_KERNELI ( p_parent )
{

    SQL_QUERY sql_query ( DB );

    SET_HELP_PAGE  ( "fat_irsaliye_satir_secimi.html" );
    SET_PAGE_TITLE ( "FAT - İRSALİYE SATIRI SEÇİMİ " );

    m_irsaliye_tarihi_bitis = p_fatura_tarihi;
    m_cari_hesap_id         = p_cari_hesap_id;

    switch ( p_fatura_turu ) {

        case ENUM_FAT_ELLE_IRSALIYE_FATURALASTIRMA_ALIS :
            m_irsaliye_turu = ENUM_IRS_NORMAL_GIRIS;
            break;

        case ENUM_FAT_ELLE_IRSALIYE_FATURALASTIRMA_SATIS :
            m_irsaliye_turu = ENUM_IRS_NORMAL_CIKIS;
            break;

        case ENUM_FAT_ELLE_IRSALIYE_FATURALASTIRMA_KONSINYE_ALIS :
            m_irsaliye_turu = ENUM_IRS_KONSINYE_GIRIS;
            break;

        case ENUM_FAT_ELLE_IRSALIYE_FATURALASTIRMA_KONSINYE_SATIS:
            m_irsaliye_turu = ENUM_IRS_KONSINYE_CIKIS;
            break;

        default :
            m_irsaliye_turu = -1;
            break;
    }

    sql_query.PREPARE_SELECT ( "e9_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");
    }

    SET_SORTING ( false );

    SET_WINDOW_SIZE ( 600, 1100 );

    SET_HEADERS ( QStringList () <<tr("irsaliye_satiri_id")<<tr("İrs. No")<<tr("İrs. S. No")<<tr("İrsaliye Tarihi")
                                 <<tr("Ürün Kodu")<<tr("Ürün Adı")<<tr("S. No/P. Kodu")<<tr("Kalan Miktar")
                                 <<tr("Birimi")<<tr("Birim Fiyat")<<tr("KDV")<<tr("KDV %")<<tr("ÖTV %")
                                 <<tr("Fiyatı")<<tr("Para Brm")<< DVZ_GET_TEMEL_PARA_BIRIMI_KODU() + tr(" Tutarı"));
    INIT_KERNEL ( DB );

    QTableWidget * tableWidget = GET_TABLE_WIDGET();

    tableWidget->setColumnWidth ( IRSALIYE_NO_COLUMN                   , 45  );
    tableWidget->setColumnWidth ( IRSALIYE_BELGE_SERI_NO_COLUMN        , 58  );
    tableWidget->setColumnWidth ( IRSALIYE_TARIHI_COLUMN               , 103 );
    tableWidget->setColumnWidth ( URUN_KODU_COLUMN                     , 70  );
    tableWidget->setColumnWidth ( URUN_ADI_COLUMN                      , 100 );
    tableWidget->setColumnWidth ( SERI_NO_PARTI_KODU_COLUMN            , 80  );
    tableWidget->setColumnWidth ( KALAN_MIKTAR_COLUMN                  , 80  );
    tableWidget->setColumnWidth ( URUN_BIRIMI_COLUMN                   , 60  );
    tableWidget->setColumnWidth ( BIRIM_FIYAT_COLUMN                   , 75  );
    tableWidget->setColumnWidth ( KDV_DAHIL_MI_COLUMN                  , 50  );
    tableWidget->setColumnWidth ( KDV_ORANI_COLUMN                     , 47  );
    tableWidget->setColumnWidth ( OTV_ORANI_COLUMN                     , 47  );
    tableWidget->setColumnWidth ( FIYAT_COLUMN                         , 80  );
    tableWidget->setColumnWidth ( PARA_BIRIMI_COLUMN                   , 60  );
    tableWidget->setColumnWidth ( TEMEL_PARA_BIRIMI_TUTARI_COLUMN      , 80  );

    SET_SETTING_NAME            ( "FAT_IRSALIYE_SATIR_SECIMI" );

    QFont tableWidget_font = tableWidget->font();
    int   font_point_size  = tableWidget_font.pointSize();
    tableWidget_font.setPointSize ( font_point_size -1 );
    tableWidget->setFont ( tableWidget_font );

    tableWidget->hideColumn( IRSALIYE_SATIRI_ID_COLUMN );
}
Example #14
0
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 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 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" ) );
}
Example #17
0
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    " ) );
}