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 );
}
