void QAdakDate::REFRESH_DATE()
{
m_date_str = QDATE().toString(m_date_format);
if ( m_date_str.isEmpty() EQ true ) {
if ( m_old_date.isValid() EQ true ) {
SET_DATE( m_old_date );
}
else {
if (m_mali_yil_disable EQ false) {
SET_DATE( MALI_YIL_FIRST_DATE());
}
else {
SET_DATE( QDate::currentDate() );
}
}
return;
}
if (m_date_str EQ line_edit->text()) {
return;
}
if ( m_mali_yil_disable EQ true) {
line_edit->setText( m_date_str );
}
else { // false ise
if ( m_current_date >= MALI_YIL_FIRST_DATE() AND m_current_date <= MALI_ARRAY_LAST_DATE() ) {
line_edit->setText( m_date_str );
}
else {
if( m_date_changed EQ true ) {
QMessageBox::information( this, tr( "Uyarı" ), tr("Girmiş olduğunuz tarih mali yıl içinde değil, lütfen yeni bir tarih girin.!"));
m_date_changed = false;
}
if ( m_current_date < MALI_YIL_FIRST_DATE() ) {
line_edit->setText( MALI_YIL_FIRST_DATE().toString( m_date_format ) );
}
else {
line_edit->setText( MALI_ARRAY_LAST_DATE().toString( m_date_format ) );
}
}
}
if ( signalsBlocked() EQ false ) {
emit SIGNAL_DATE_CHANGED();
}
}
void MUH_TOPLU_FIS_RAPORU_BATCH::SETUP_FORM()
{
SET_HELP_PAGE ( "genel-muhasebe_toplu-fis-dokumu" );
SET_PAGE_TITLE ( tr ( "MUH - TOPLU FİŞ DÖKÜMÜ" ) );
REGISTER_BUTTON_WIDGET ( m_ui->widget_batch_buttons );
SET_SETTING_NAME ( "MUH_TOPLU_FIS_RAPORU_BATCH" );
m_ui->adakDate_bas_tarihi->SET_DATE( MALI_YIL_FIRST_DATE() );
m_ui->adakDate_bitis_tarihi->SET_DATE( MALI_ARRAY_LAST_DATE() );
SET_NAME_OF_RUN_BATCH_BUTTON ( "Rapor Al" );
SET_FIRST_FOCUS_WIDGET ( m_ui->adakDate_bas_tarihi );
if( K9_KULLANICININ_CALISTIGI_SIRKET() EQ 1 ){
m_ent_filtre_turu = FIS_BIRINCI_SIRKET;
}
else {
m_ent_filtre_turu = FIS_HER_IKI_SIRKET;
}
K9_FILL_COMBOBOX_RAPOR_SIRKET_FILTRESI( m_ui->comboBox_sirket_turu );
m_ui->comboBox_sirket_turu->setHidden(true );
m_ui->label_sirket_turu->setHidden(true);
if( K9_KULLANICI_SIRKET_DEGISTIRE_BILIR_MI() EQ EVET ){
m_ui->comboBox_sirket_turu->setHidden(false);
m_ui->label_sirket_turu->setHidden(false);
}
FIND_AND_SET_COMBOBOX_TEXT( m_ui->comboBox_sirket_turu, K9_GET_RAPOR_SIRKET_FILTRESI_STRING(m_ent_filtre_turu ) );
}
int CEK_MUSTERI_CEK_SENET_ARAMA::CHECK_VAR ( QObject * object )
{
if ( object EQ m_ui->searchEdit_cari_hesap_kodu ) {
QString cari_hesap_ismi;
int cari_hesap_id;
int result = CARI_GET_HESAP_KODU_ISMI_PARA_BIRIM_ID( m_ui->searchEdit_cari_hesap_kodu->GET_TEXT(), &cari_hesap_id, &cari_hesap_ismi );
if ( result EQ 0 ) {
MSG_WARNING( tr ( "Aradığınız cari hesap kodu bulunamadı!.." ), m_ui->searchEdit_cari_hesap_kodu );
return ADAK_FAIL;
}
m_ui->lineedit_cari_hesap_ismi->setText ( cari_hesap_ismi );
m_cari_hesap_id = cari_hesap_id;
}
else if ( object EQ m_ui->checkbox_vade_tarihi ) {
if ( m_ui->checkbox_vade_tarihi->isChecked() EQ true ) {
m_ui->date_frame->setEnabled ( 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() );
SET_FOCUS( m_ui->adakDate_vade_bas_tarihi );
}
else {
m_ui->date_frame->setEnabled ( false );
}
}
else if ( object EQ m_ui->checkbox_cari_hesap ) {
if ( m_ui->checkbox_cari_hesap->isChecked() EQ true ) {
m_ui->cari_hesap_frame->setEnabled ( true );
SET_FOCUS( m_ui->searchEdit_cari_hesap_kodu );
}
else {
m_ui->cari_hesap_frame->setEnabled ( false );
}
}
else if ( object EQ m_ui->checkbox_cekin_durumu ) {
if ( m_ui->checkbox_cekin_durumu->isChecked() EQ true ) {
m_ui->cekin_durumu_frame->setEnabled ( true );
m_ui->combobox_cekin_durumu->setCurrentIndex(-1);
SET_FOCUS( m_ui->combobox_cekin_durumu );
}
else {
m_ui->cekin_durumu_frame->setEnabled ( false );
m_ui->combobox_cekin_durumu->setCurrentIndex(-1);
}
}
else if ( object EQ m_ui->comboBox_sirket_filtresi ) {
m_entegre_filtresi = K9_GET_RAPOR_SIRKET_FILTRESI_ENUM(m_ui->comboBox_sirket_filtresi->currentText());
}
return ADAK_OK;
}
void QAdakDate::MALI_YIL_KISITI_YOK( bool p_disable )
{
m_mali_yil_disable = p_disable;
if (m_mali_yil_disable EQ false) {
calendar_widget->setDateRange(MALI_YIL_FIRST_DATE(), MALI_ARRAY_LAST_DATE());
}
else {
calendar_widget->setDateRange(QDate(1,1,1), QDate(9999,12,31));
}
}
int QAdakDate::MALI_YIL_ARRAY_INDIS()
{
if (m_current_date < MALI_YIL_FIRST_DATE()) {
return -1; // Will crash
}
if (m_current_date > MALI_ARRAY_LAST_DATE()) {
return -1; // Will crash
}
return MALI_YIL_FIRST_DATE().daysTo ( m_current_date ) + 1;
}
void PRS_FILL_COMBO_BOX_BORDRO_YILLARI ( QComboBox * p_combo_box )
{
// mali yil ilk tarih
QDate borda_ilk_yil = MALI_YIL_FIRST_DATE();
p_combo_box->addItem( QVariant ( borda_ilk_yil.year() ).toString() );
// e9_array son tarih
QDate bordro_son_yil = MALI_ARRAY_LAST_DATE();
p_combo_box->addItem( QVariant ( bordro_son_yil.year() ).toString() );
}
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" );
}
QAdakDate::QAdakDate(QWidget * parent) : QWidget(parent)
{
line_edit = new QLineEdit(this);
line_edit->setObjectName("adak_date_line_edit");
line_edit->setSizePolicy(QSizePolicy::Expanding,QSizePolicy::Fixed);
line_edit->installEventFilter(this);
line_edit->setMaxLength(100);
connect(line_edit,SIGNAL(editingFinished()),this,SLOT(SLOT_SET_DATE()));
tool_button = new QToolButton(this);
tool_button->setSizePolicy(QSizePolicy::Minimum, QSizePolicy::Fixed);
tool_button->setToolButtonStyle(Qt::ToolButtonIconOnly);
tool_button->setIcon(QIcon(":/kernel_icons/kernel_calendar_ikonu.png"));
tool_button->setObjectName("adak_date_tool_button");
tool_button->setMaximumSize(32,line_edit->height() - 9);
tool_button->setIconSize(QSize(tool_button->width(),line_edit->height() - 9));
tool_button->setFocusPolicy(Qt::ClickFocus);
connect(tool_button,SIGNAL(clicked()),this,SLOT(SLOT_POPUP_BUTTON_CLICKED()));
calendar_widget = new QCalendarWidget(this);
calendar_widget->setFirstDayOfWeek ( Qt::Monday );
calendar_widget->setDateRange(MALI_YIL_FIRST_DATE(), MALI_ARRAY_LAST_DATE());
calendar_widget->setWindowFlags(Qt::Popup);
calendar_widget->close();
connect(calendar_widget,SIGNAL(clicked(QDate)),this,SLOT(SLOT_POPUP_DATE_SELECTED(QDate)));
h_box_layout = new QHBoxLayout(this);
h_box_layout->setContentsMargins(0,0,0,0);
h_box_layout->setSpacing(0);
h_box_layout->addWidget(line_edit);
h_box_layout->addWidget(tool_button);
setLayout (h_box_layout);
setFocusPolicy (Qt::StrongFocus);
setFocusProxy (line_edit);
setMaximumHeight(line_edit->height());
setTabOrder (line_edit,tool_button);
m_mali_yil_disable = false;
m_date_changed = false;
m_current_date = QDate::currentDate();
m_old_date = QDate::currentDate();
SET_DATE_FORMAT ("dd MMMM yyyy dddd");
SET_DATE (QDate::currentDate());
}
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 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 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 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 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 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 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 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_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;
}
