int SMM_HIZMET_TANIMLAMA_FISI::GET_FIS_RECORD ( int sube_id )
{
SQL_QUERY query(DB);
query.PREPARE_SELECT("smm_hizmetler" , "hizmet_adi, hizmet_hesap_id, vergi_hesap_id,"
"hizmet_id " ,
"sube_id = :sube_id AND hizmet_turu = :hizmet_turu ");
query.SET_VALUE(":sube_id" , sube_id);
query.SET_VALUE(":hizmet_turu" , m_hizmet_sekli);
if ( query.SELECT(" order_number ASC ") EQ 0 ) {
return ADAK_OK;
}
int current_row = 0;
QTableWidgetItem * item;
while ( query.NEXT() EQ true ) {
current_row = ADD_NEW_LINE();
QLineEdit * lineedit_hizmet_adi = ( QLineEdit * ) m_ui->tablewidget_fis_satirlari->cellWidget(current_row, HIZMET_ADI_COLUMN);
QSearchEdit * searchedit_hesap_kodu = ( QSearchEdit * ) m_ui->tablewidget_fis_satirlari->cellWidget(current_row,HESAP_KODU_COLUMN);
QLineEdit * lineedit_hesap_ismi = ( QLineEdit * ) m_ui->tablewidget_fis_satirlari->cellWidget(current_row,HESAP_ISMI_COLUMN);
QLineEdit * lineedit_hesap_id = ( QLineEdit * ) m_ui->tablewidget_fis_satirlari->cellWidget(current_row,HESAP_ID_COLUMN);
QSearchEdit * searchedit_vergi_hesap_kodu = ( QSearchEdit * ) m_ui->tablewidget_fis_satirlari->cellWidget(current_row , VERGI_HESAP_KODU_COLUMN);
QLineEdit * lineedit_vergi_hesap_ismi = ( QLineEdit * ) m_ui->tablewidget_fis_satirlari->cellWidget(current_row , VERGI_HESAP_ISMI_COLUMN);
QLineEdit * lineedit_vergi_hesap_id = ( QLineEdit * ) m_ui->tablewidget_fis_satirlari->cellWidget(current_row , VERGI_HESAP_ID_COLUMN);
lineedit_hizmet_adi->setText(query.VALUE("hizmet_adi").toString());
lineedit_hesap_id->setText(query.VALUE("hizmet_hesap_id").toString());
lineedit_vergi_hesap_id->setText(query.VALUE("vergi_hesap_id").toString());
QString tam_hesap_kodu;
QString hesap_ismi;
MUH_GET_HESAP_KODU_HESAP_ISMI(query.VALUE("hizmet_hesap_id").toInt(),tam_hesap_kodu,hesap_ismi);
searchedit_hesap_kodu->SET_TEXT(tam_hesap_kodu);
lineedit_hesap_ismi->setText(hesap_ismi);
MUH_GET_HESAP_KODU_HESAP_ISMI(query.VALUE("vergi_hesap_id").toInt(),tam_hesap_kodu , hesap_ismi );
searchedit_vergi_hesap_kodu->SET_TEXT(tam_hesap_kodu);
lineedit_vergi_hesap_ismi->setText(hesap_ismi);
item = new QTableWidgetItem ( query.VALUE("hizmet_id").toString());
m_ui->tablewidget_fis_satirlari->setItem(current_row,ROW_ID_COLUMN,item);
item = new QTableWidgetItem ( QVariant(sube_id).toString());
m_ui->tablewidget_fis_satirlari->setItem(current_row,FIS_ID_COLUMN,item);
}
return ADAK_OK;
}
int SUBE_GET_SUBE_ENT_HESAP_ID(int p_sube_id, QString p_column_name, QString *p_muh_hesap_kodu, QString *p_muh_hesap_adi)
{
SQL_QUERY query( DB );
query.PREPARE_SELECT("sub_subeler", p_column_name , "sube_id = :sube_id");
query.SET_VALUE (":sube_id", p_sube_id );
if( query.SELECT() EQ 0 ) {
return 0;
}
query.NEXT();
int sube_ent_hesap_id = query.VALUE(0).toInt();
QString tam_hesap_kodu;
QString hesap_ismi;
MUH_GET_HESAP_KODU_HESAP_ISMI(sube_ent_hesap_id ,tam_hesap_kodu,hesap_ismi);
if ( p_muh_hesap_adi NE NULL ) {
*p_muh_hesap_adi = hesap_ismi;
}
if ( p_muh_hesap_kodu NE NULL ) {
*p_muh_hesap_kodu = tam_hesap_kodu;
}
return sube_ent_hesap_id;
}
int STOK_HIZMET_KARTI_FORMU::GET_RECORD ( int record_id )
{
SQL_QUERY select_query(DB);
select_query.PREPARE_SELECT("stk_urunler" , "urun_kodu,urun_adi,barkod_numarasi,alis_fiyati,satis_fiyati,"
"urun_alis_doviz_id,urun_satis_doviz_id,aciklama,"
"alis_kdv_orani,muh_hesap_id,urun_temel_birimi,hizmet_turu, satis_kdv_orani" , "urun_id = :urun_id");
select_query.SET_VALUE(":urun_id" , record_id);
if(select_query.SELECT() EQ 0 ) {
return ADAK_FAIL;
}
select_query.NEXT();
m_ui->lineEdit_hizmet_kodu->setText(select_query.VALUE(0).toString());
m_ui->lineEdit_hizmet_ismi->setText(select_query.VALUE(1).toString());
m_ui->lineEdit_barkod_no->setText(select_query.VALUE(2).toString());
m_ui->commaEdit_alis_fiyati->SET_DOUBLE(select_query.VALUE(3).toDouble());
m_ui->commaEdit_satis_fiyati->SET_DOUBLE(select_query.VALUE(4).toDouble());
m_ui->comboBox_alis_doviz_cinsi->setCurrentIndex(m_ui->comboBox_alis_doviz_cinsi->findText(DVZ_GET_DOVIZ_KODU(select_query.VALUE(5).toInt())));
m_ui->comboBox_satis_doviz_cinsi->setCurrentIndex(m_ui->comboBox_satis_doviz_cinsi->findText(DVZ_GET_DOVIZ_KODU(select_query.VALUE(6).toInt())));
m_ui->limitedTextEdit->setPlainText(select_query.VALUE(7).toString());
m_ui->comboBox_alis_kdv_orani->setCurrentIndex(m_ui->comboBox_alis_kdv_orani->findText(select_query.VALUE(8).toString()));
m_ui->comboBox_satis_kdv_orani->setCurrentIndex(m_ui->comboBox_satis_kdv_orani->findText(select_query.VALUE(12).toString()));
m_muh_hesap_id = select_query.VALUE(9).toInt();
m_ui->lineEdit_hizmet_birimi->setText(select_query.VALUE(10).toString());
int hizmet_turu = select_query.VALUE(11).toInt();
m_ui->comboBox_hizmet_turu->setCurrentIndex(m_ui->comboBox_hizmet_turu->findText(STK_GET_HIZMET_TURU_STRING(hizmet_turu)));
if ( m_muh_hesap_id NE 0 ) {
QString tam_hesap_kodu,hesap_ismi;
MUH_GET_HESAP_KODU_HESAP_ISMI(m_muh_hesap_id , tam_hesap_kodu , hesap_ismi);
m_ui->searchEdit_muh_hesap_kodu->SET_TEXT(tam_hesap_kodu);
m_ui->lineEdit_muh_hesap_ismi->setText(hesap_ismi);
}
return ADAK_OK;
}
int PRK_GELIR_GIDER_TURLERI_FISI::GET_FIS_RECORD ( int sube_id )
{
SQL_QUERY query(DB);
query.PREPARE_SELECT("prk_gelir_gider_turleri" , "gelir_gider_adi, hesap_id, tur_id " ,
"sube_id = :sube_id AND gider_turu_mu = :gider_turu_mu ");
query.SET_VALUE(":sube_id" , sube_id);
query.SET_VALUE(":gider_turu_mu" , m_gider_turu_mu);
if ( query.SELECT(" order_number ASC ") EQ 0 ) {
return ADAK_OK;
}
int current_row = 0;
QTableWidgetItem * item;
while ( query.NEXT() EQ true ) {
current_row = ADD_NEW_LINE();
QLineEdit * lineedit_gelir_gider_adi= ( QLineEdit * ) m_ui->tablewidget_fis_satirlari->cellWidget(current_row, GELIR_GIDER_ADI_COLUMN);
QSearchEdit * searchedit_hesap_kodu = ( QSearchEdit *) m_ui->tablewidget_fis_satirlari->cellWidget(current_row,HESAP_KODU_COLUMN);
QLineEdit * lineedit_hesap_ismi = ( QLineEdit *) m_ui->tablewidget_fis_satirlari->cellWidget(current_row,HESAP_ISMI_COLUMN);
QLineEdit * lineedit_hesap_id = ( QLineEdit *) m_ui->tablewidget_fis_satirlari->cellWidget(current_row,HESAP_ID_COLUMN);
lineedit_gelir_gider_adi->setText(query.VALUE(0).toString());
lineedit_hesap_id->setText(query.VALUE(1).toString());
QString tam_hesap_kodu;
QString hesap_ismi;
MUH_GET_HESAP_KODU_HESAP_ISMI(query.VALUE(1).toInt(),tam_hesap_kodu,hesap_ismi);
searchedit_hesap_kodu->SET_TEXT(tam_hesap_kodu);
lineedit_hesap_ismi->setText(hesap_ismi);
item = new QTableWidgetItem ( query.VALUE(2).toString());
m_ui->tablewidget_fis_satirlari->setItem(current_row,ROW_ID_COLUMN,item);
item = new QTableWidgetItem ( QVariant(sube_id).toString());
m_ui->tablewidget_fis_satirlari->setItem(current_row,FIS_ID_COLUMN,item);
}
return ADAK_OK;
}
int DMR_DEMIRBAS_KARTI::GET_RECORD ( int record_id )
{
SQL_QUERY select_query ( DB );
select_query.PREPARE_SELECT ( "dmr_demirbaslar ","demirbas_kodu,demirbas_adi,grup_id,muh_hesap_id,alis_tarihi,alis_bedeli,"
"uretici_firma,marka,model,seri_numarasi,garanti_suresi,"
"amortisman_orani,amortisman_suresi,yeniden_degerleme_yapilacak_mi,kist_amortisman,"
"demirbasin_degeri,amortisman_yontemi,personel_id,"
"grup_id,fatura_id ,bir_amor_hesap_id , "
"amor_gider_hesap_id , dmr_satis_kar_hesap_id ,amortisman_ayrilacak_mi,dmr_satis_zarar_hesap_id",
"demirbas_id = :demirbas_id" );
select_query.SET_VALUE ( ":demirbas_id" , record_id );
if ( select_query.SELECT() EQ 0 ) {
return ADAK_FAIL;
}
select_query.NEXT();
m_ui->lineedit_demirbas_kodu->setText ( select_query.VALUE(0).toString() );
m_ui->lineedit_demirbas_adi->setText ( select_query.VALUE(1).toString() );
m_ui->searchedit_muh_hesap_kodu->SET_TEXT ( MUH_GET_HESAP_KODU(select_query.VALUE(3).toInt() ) );
m_ui->lineedit_muh_hesap_ismi->setText ( MUH_GET_HESAP_ISMI(select_query.VALUE(3).toInt() ) );
m_ui->adakDate_alis_tarihi->SET_DATE(select_query.VALUE(4).toString() );
m_ui->commaEdit_alis_fiyati->SET_DOUBLE ( select_query.VALUE(5).toDouble() );
m_ui->lineEdit_uretici_firma->setText(select_query.VALUE(6).toString() );
m_ui->lineEdit_marka->setText(select_query.VALUE(7).toString() );
m_ui->lineEdit_model->setText(select_query.VALUE(8).toString() );
m_ui->lineEdit_seri_no->setText(select_query.VALUE(9).toString() );
m_ui->lineedit_garanti_suresi->setText(select_query.VALUE(10).toString() );
m_ui->commaEdit_amortisman_orani->SET_DOUBLE(select_query.VALUE(11).toDouble() );
m_ui->lineedit_amortisman_suresi->setText(select_query.VALUE(12).toString() );
m_ui->checkBox_yeniden_degerleme->setChecked(select_query.VALUE(13).toBool() );
m_ui->checkBox_kist_amortisman->setChecked(select_query.VALUE(14).toBool() );
m_ui->commaEdit_demirbasin_degeri->SET_DOUBLE(select_query.VALUE(15).toDouble() );
m_ui->checkBox_amortisman_ayrilacak_mi->setChecked(QVariant(select_query.VALUE("amortisman_ayrilacak_mi")).toBool());
QList<int> m_grup_idleri;
m_grup_id = select_query.VALUE("grup_id").toInt();
m_muh_hesap_id = select_query.VALUE(3).toInt();
m_grup_idleri << select_query.VALUE("grup_id").toInt();
if (m_grup_idleri.isEmpty() EQ false) {
m_ui->search_edit_gruplar->SET_TEXT(GRP_GRUP_ADLARINI_BUL(&m_grup_idleri , new QStringList() , new QStringList()));
}
m_ui->textEdit_rapor_isl_gruplari->setText ( GRP_KAYDIN_GRUPLARINI_BUL ( E9_PROGRAMI , DEMIRBAS_GRUP_MODULU, record_id, &m_rpr_isl_grubu_idler, new QStringList, new QStringList ) );
double birikmis_amortisman_tutari = DMR_GET_BIRIKMIS_AMORTISMAN_TUTARI ( record_id, MALI_YIL_ARRAY_INDIS ( QDate::currentDate()));
double net_deger = select_query.VALUE(15).toDouble() - birikmis_amortisman_tutari;
m_ui->commaEdit_net_deger->SET_DOUBLE ( net_deger );
m_ui->commaEdit_birikmis_amortisman->SET_DOUBLE ( birikmis_amortisman_tutari );
m_ui->comboBox_amortisman_yontemi->setCurrentIndex ( m_ui->comboBox_amortisman_yontemi->findText ( DMR_GET_AMORTISMAN_SEKLI_STRING(select_query.VALUE("amortisman_yontemi").toInt())));
m_fatura_id = select_query.VALUE("fatura_id").toInt();
m_ui->lineedit_fatura_bilgileri->setText(DMR_GET_FATURA_BILGILERI(m_fatura_id));
m_bir_amor_hesap_id = select_query.VALUE("bir_amor_hesap_id").toInt();
m_amor_gider_hesap_id = select_query.VALUE("amor_gider_hesap_id").toInt();
m_dmr_satis_kar_hesap_id = select_query.VALUE("dmr_satis_kar_hesap_id").toInt();
m_dmr_satis_zarar_hesap_id = select_query.VALUE("dmr_satis_zarar_hesap_id").toInt();
int personel_id = select_query.VALUE(17).toInt();
int cari_hesap_id = PRS_GET_PERSONEL_CARI_HESAP_ID( personel_id );
QString cari_hesap_kodu, cari_hesap_ismi;
int result = CARI_GET_HESAP_KODU_ISMI_PARA_BIRIM_ID( cari_hesap_id, &cari_hesap_kodu, &cari_hesap_ismi );
if ( result NE 0 ) {
m_ui->searchEdit_personel_adi->SET_TEXT( cari_hesap_kodu );
m_ui->lineEdit_personel_soyadi->setText( cari_hesap_ismi );
m_cari_hesap_id = cari_hesap_id;
}
QString tam_hesap_kodu,hesap_ismi;
MUH_GET_HESAP_KODU_HESAP_ISMI(m_amor_gider_hesap_id , tam_hesap_kodu ,hesap_ismi);
m_ui->searchedit_amor_gdr_hesap_kodu->SET_TEXT(tam_hesap_kodu);
m_ui->lineEdit_amor_gdr_hesap_ismi->setText(hesap_ismi);
MUH_GET_HESAP_KODU_HESAP_ISMI(m_bir_amor_hesap_id , tam_hesap_kodu ,hesap_ismi);
m_ui->searchedit_bir_amortisman_hesap_kodu->SET_TEXT(tam_hesap_kodu);
m_ui->lineEdit_bir_amortisman_hesap_ismi->setText(hesap_ismi);
MUH_GET_HESAP_KODU_HESAP_ISMI(m_dmr_satis_kar_hesap_id , tam_hesap_kodu ,hesap_ismi);
m_ui->searchedit_dmr_satis_kar_hesap_kodu->SET_TEXT(tam_hesap_kodu);
m_ui->lineEdit_dmr_satis_kar_hesap_ismi->setText(hesap_ismi);
MUH_GET_HESAP_KODU_HESAP_ISMI(m_dmr_satis_zarar_hesap_id , tam_hesap_kodu ,hesap_ismi);
m_ui->searchedit_dmr_satis_zarar_hesap_kodu->SET_TEXT(tam_hesap_kodu);
m_ui->lineEdit_dmr_satis_zarar_hesap_ismi->setText(hesap_ismi);
return ADAK_OK;
}
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 );
}
