bool HEADER_ICIN_INDEX_YAPISI_OLUSTUR (int index_sayisi, int tablo_id ) { int INDEXLER_ARRAY[INDEXLER_ARRAY_SIZE] = {0}; SQL_QUERY query (DB); query.PREPARE_SELECT("sql_tablolar","indexler_array","tablo_id=:tablo_id"); query.SET_VALUE (":tablo_id",tablo_id); if ( query.SELECT() EQ 0 ) { return false; } query.NEXT(); UNPACK_INT_ARRAY(query.VALUE(0).toString(),INDEXLER_ARRAY,INDEXLER_ARRAY_SIZE); for (int i = 0; i < INDEXLER_ARRAY_SIZE; i += 4 ) { if ( INDEXLER_ARRAY[i] EQ 0 ) { continue; } if ( i EQ 0 ) { QString alan_adi = GET_ALAN_ADI( tablo_id, INDEXLER_ARRAY[i]); file_content += tab (4, "{ "); file_content += QString("PRIMARY , 1, {") + "\"" + alan_adi + "\"" + "}"; file_content += " }"; index_sayisi--; if (index_sayisi > 0 ) { file_content += ","; } file_content += "\n"; } else { int indexteki_kolon_sayisi = 0; for ( int j = i; j < i + 4; j++ ) { if ( INDEXLER_ARRAY[j] NE 0 ) { indexteki_kolon_sayisi++; } } file_content += tab (4, "{ "); file_content += "INDEX , " + QVariant(indexteki_kolon_sayisi).toString() + ", { "; for (int j = 0; j < indexteki_kolon_sayisi; j++ ) { QString alan_adi = GET_ALAN_ADI( tablo_id, INDEXLER_ARRAY[i+j]); file_content += "\"" + alan_adi + "\"" ; if (j NE indexteki_kolon_sayisi -1 ) { file_content += ","; } } file_content += " } }"; index_sayisi--; if (index_sayisi > 0 ) { file_content += ","; } file_content += "\n"; } } return true; }
void SQL_INDEX_BATCH::READ_INDEXES() { SQL_QUERY query (DB); query.PREPARE_SELECT("sql_tablolar","indexler_array","tablo_id=:tablo_id"); query.SET_VALUE (":tablo_id",p_tablo_id); if ( query.SELECT() EQ 0 ) { return; } query.NEXT(); UNPACK_INT_ARRAY(query.VALUE(0).toString(),INDEXLER_ARRAY,INDEXLER_ARRAY_SIZE); int line_number = 1; for ( int i = 4; i < INDEXLER_ARRAY_SIZE; i++ ) { if ( INDEXLER_ARRAY[i] EQ 0 ) { if ( i+1 MOD 4 EQ 0 ) { line_number++; } continue; } COMBOBOX_ARRAY[line_number-1][i-(4*line_number)]->setCurrentIndex (COMBOBOX_ARRAY[line_number][i-(4*line_number)]->findText(GET_ALAN_ADI(p_tablo_id,INDEXLER_ARRAY[i]))); if ( i+1 MOD 4 EQ 0 ) { line_number++; } } }
void SMM_MAKBUZ_FORMU::SETUP_FORM () { if ( m_makbuz_turu EQ SMM_ALIS_MAKBUZU ) { SET_PAGE_TITLE ( tr ( "SMM - SERBEST MESLEK MAKBUZU (ALIŞ)" ) ); SET_HELP_PAGE ("serbest-meslek-makbuzu-alis"); } else { SET_PAGE_TITLE ( tr ( "SMM - SERBEST MESLEK MAKBUZU (SATIŞ)" ) ); SET_HELP_PAGE ("serbest-meslek-makbuzu-satis"); } REGISTER_SAVER_BUTTON( m_ui->pushButton_urettigi_fisler ); if ( K9_KULLANICI_FISIN_URETTIGI_ENT_FISLERINI_GOREBILIR_MI() EQ HAYIR ) { m_ui->pushButton_urettigi_fisler->setVisible( false ); } REGISTER_BUTTONS_WIDGET ( m_ui->kernel_buttons_widget ); SET_SETTING_NAME ( "SMM_MAKBUZ_FORMU" ); SET_FIRST_FOCUS_WIDGET ( m_ui->lineEdit_smmm_no ); M_ENT_DETAYLARI = new SMM_ENT_DETAYLARI; M_MAKBUZ = new SMM_MAKBUZ_STRUCT; BNK_FILL_COMBO_BOX_BANKA_HESAPLARI( m_ui->comboBox_banka_hesap_kodu ); SMM_CLEAR_MAKBUZ_STRUCT(M_MAKBUZ); m_ui->lineEdit_smmm_no->setText("*"); m_ui->lineEdit_smmm_no->setMaxLength(10); DISABLE_CLEAR_ON_WIDGET(m_ui->lineEdit_smmm_no); DISABLE_CLEAR_ON_WIDGET ( m_ui->comboBox_fis_filtresi); DISABLE_CLEAR_ON_WIDGET ( m_ui->comboBox_sirket ); K9_FILL_COMBOBOX_KAYDEDILECEK_SIRKET( m_ui->comboBox_sirket ); if ( K9_KULLANICININ_CALISTIGI_SIRKET() EQ SIRKET_1 ) { m_entegre_filtresi = FIS_BIRINCI_SIRKET; M_MAKBUZ->kaydedilecek_sirket = SIRKET_1; } else { m_entegre_filtresi = FIS_HER_IKI_SIRKET; M_MAKBUZ->kaydedilecek_sirket = SIRKET_2; } FIND_AND_SET_COMBOBOX_TEXT( m_ui->comboBox_sirket, K9_GET_KAYDEDILECEK_SIRKET_STRING( M_MAKBUZ->kaydedilecek_sirket )); K9_FILL_COMBOBOX_FIS_FILTRESI(m_ui->comboBox_fis_filtresi); if ( K9_KULLANICI_ENT_BILGILERINI_DEGISTIREBILIR_MI() EQ HAYIR ) { m_ui->pushButton_detaylar->setVisible( false ); } if ( K9_KULLANICI_SIRKET_DEGISTIRE_BILIR_MI() EQ HAYIR ) { m_ui->label_fis_filtresi->setVisible( false); m_ui->comboBox_fis_filtresi->setVisible( false ); m_ui->comboBox_sirket->setVisible( false ); m_ui->label_sirket->setVisible( false ); } m_ui->comboBox_fis_filtresi->setCurrentIndex(m_ui->comboBox_fis_filtresi->findText(K9_GET_FIS_FILTRESI_STRING(m_entegre_filtresi))); M_KDV_ORANLARI_ARRAY = new double [KDV_OTV_ORANLARI_SAYISI]; M_INDIRILECEK_KDV_HESABI_ID_ARRAY = new int [KDV_OTV_ORANLARI_SAYISI]; M_TEVKIFAT_HESAPLARI_ID_ARRAY = new int [KDV_OTV_ORANLARI_SAYISI]; GET_VERGI_DAIRELERI(m_ui->comboBox_vergi_dairesi); SQL_QUERY query(DB); query.PREPARE_SELECT("k9_sabit_degerler" , "ontanimli_kdv_orani,kdv_oranlari_array,ind_kdv_hesap_id_array," "tevkifat_kdv_hesap_id_array", "sabit_deger_id = :sabit_deger_id"); query.SET_VALUE(":sabit_deger_id" , 1); if ( query.SELECT() NE 0 ) { query.NEXT(); m_ontanimli_kdv_orani = query.VALUE(0).toDouble(); UNPACK_DOUBLE_ARRAY(query.VALUE(1).toString() , M_KDV_ORANLARI_ARRAY , KDV_OTV_ORANLARI_SAYISI); UNPACK_INT_ARRAY(query.VALUE(2).toString() , M_INDIRILECEK_KDV_HESABI_ID_ARRAY , KDV_OTV_ORANLARI_SAYISI ); UNPACK_INT_ARRAY(query.VALUE(3).toString() , M_TEVKIFAT_HESAPLARI_ID_ARRAY , KDV_OTV_ORANLARI_SAYISI); } m_ui->limitedTextEdit_aciklama->SET_MAX_STRING_LENGTH(512); m_ui->limitedTextEdit_adres->SET_MAX_STRING_LENGTH(512); SET_COMBOBOX_LENGTH(m_ui->comboBox_vergi_dairesi , 50); m_ui->lineEdit_vergi_numarasi->setMaxLength(15); m_ui->lineEdit_sm_sicil_numarasi->setMaxLength(20); m_ui->lineEdit_belge_seri->setMaxLength(3); m_ui->lineEdit_belge_numarasi->setMaxLength(15); DISABLE_CLEAR_ON_WIDGET(m_ui->comboBox_kdv_orani); K9_FILL_KDV_ORANLARI_COMBOBOX(m_ui->comboBox_kdv_orani); m_sube_kasa_hesap_id = SUBE_GET_UNITE_MUH_KASA_HESABI_ID(); SET_COMBOBOX_LENGTH(m_ui->comboBox_hizmet_turu , 128); query.PREPARE_SELECT("smm_hizmetler" ,"hizmet_adi" ,"hizmet_turu = :hizmet_turu"); if ( m_makbuz_turu EQ SMM_ALIS_MAKBUZU ) { query.SET_VALUE(":hizmet_turu" , SMM_ALINAN_HIZMET); } else { query.SET_VALUE(":hizmet_turu" , SMM_SATILAN_HIZMET); } if ( query.SELECT() NE 0 ) { while ( query.NEXT() ) { m_ui->comboBox_hizmet_turu->addItem(query.VALUE(0).toString()); } } else { MSG_WARNING( tr("Hizmet Alış/Satış tanımlamalısınız.!"), NULL ); } m_ui->comboBox_hizmet_turu->setCurrentIndex(-1); m_ui->comboBox_tah_odm_sekli->addItems(QStringList() << QObject::tr("Nakit")<< QObject::tr("Kredi Kartı") << QObject::tr("Havale")<< QObject::tr("Eft")); m_ui->comboBox_tah_odm_sekli->setCurrentIndex(-1); m_ui->comboBox_tah_odm_sekli->setEditable(false); m_ui->comboBox_hizmet_turu->setEditable(false); REGISTER_CHANGER_BUTTON ( m_ui->pushButton_detaylar ); REGISTER_SAVER_BUTTON ( m_ui->pushButton_yazdir ); AUTOSTART_FORM_KERNEL( m_form_id ); }