void PRK_GELIR_GIDER_TURLERI_FISI::LINE_SEARCH_EDIT_CLICKED(int row_number, QWidget *, QLineEdit * line_edit)
{
int hesap_id = OPEN_MUH_HESAP_ARAMA("",this,true);
QLineEdit * lineedit_gider_hesabi_id = (QLineEdit * ) m_ui->tablewidget_fis_satirlari->cellWidget(row_number,HESAP_ID_COLUMN);
lineedit_gider_hesabi_id->setText(QVariant(hesap_id).toString());
line_edit->setText(MUH_GET_HESAP_KODU(hesap_id));
}
void STOK_HIZMET_KARTI_FORMU::SEARCH_EDIT_CLICKED(QWidget *widget, QLineEdit *line_edit)
{
Q_UNUSED(widget);
int muh_hesap_id = OPEN_MUH_HESAP_ARAMA( line_edit->text(), this,true );
if ( muh_hesap_id > 0 ) {
m_muh_hesap_id = muh_hesap_id;
line_edit->setText(MUH_GET_HESAP_KODU(muh_hesap_id));
}
}
void SMM_HIZMET_TANIMLAMA_FISI::LINE_SEARCH_EDIT_CLICKED(int row_number, QWidget *, QLineEdit * line_edit)
{
Q_UNUSED(row_number);
int hesap_id = OPEN_MUH_HESAP_ARAMA("",this,true);
if ( hesap_id NE -1 ) {
line_edit->setText(MUH_GET_HESAP_KODU(hesap_id));
}
}
void MUH_MIZAN_RAPORU_BATCH::SEARCH_EDIT_CLICKED ( QWidget * p_widget, QLineEdit * p_lineEdit )
{
Q_UNUSED(p_widget);
SQL_QUERY sql_query ( DB );
int hesap_id = OPEN_MUH_HESAP_ARAMA ( p_lineEdit->text(), this );
if ( hesap_id EQ -1 ) {
return;
}
p_lineEdit->setText ( MUH_GET_HESAP_KODU(hesap_id) );
}
void FAT_FATURA_DETAYLARI_BATCH::SEARCH_EDIT_CLICKED ( QWidget * p_widget, QLineEdit * p_lineEdit )
{
int hesap_id = OPEN_MUH_HESAP_ARAMA ( p_lineEdit->text(), this, 1 );
if ( hesap_id > 0 ) {
p_lineEdit->setText ( MUH_GET_HESAP_KODU ( hesap_id ) );
}
if ( p_widget EQ m_ui->searchEdit_sube_yurtici_satis_hsp_id ) {
m_ui->lineEdit_sube_yurtici_satis_hsp_id->clear();
}
else if ( p_widget EQ m_ui->searchEdit_sube_hizmet_urt_maliyet_hsp_id ) {
m_ui->lineEdit_sube_yurtici_satis_hsp_id->clear();
}
}
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 DMR_DEMIRBAS_KARTI::SEARCH_EDIT_CLICKED ( QWidget * widget,QLineEdit * line_edit )
{
if ( widget EQ m_ui->searchedit_muh_hesap_kodu ) {
m_muh_hesap_id = OPEN_MUH_HESAP_ARAMA ( m_ui->searchedit_muh_hesap_kodu->GET_TEXT(),this,1 );
if ( m_muh_hesap_id NE -1 ) {
line_edit->setText ( MUH_GET_HESAP_KODU ( m_muh_hesap_id ) );
}
}
else if ( widget EQ m_ui->searchedit_bir_amortisman_hesap_kodu ) {
int m_bir_amor_hesap_id = OPEN_MUH_HESAP_ARAMA ( m_ui->searchedit_bir_amortisman_hesap_kodu->GET_TEXT(),this,1 );
if ( m_bir_amor_hesap_id NE -1 ) {
line_edit->setText ( MUH_GET_HESAP_KODU ( m_bir_amor_hesap_id ) );
}
}
else if ( widget EQ m_ui->searchedit_amor_gdr_hesap_kodu ) {
m_amor_gider_hesap_id = OPEN_MUH_HESAP_ARAMA ( m_ui->searchedit_amor_gdr_hesap_kodu->GET_TEXT(),this,1 );
if ( m_amor_gider_hesap_id NE -1 ) {
line_edit->setText ( MUH_GET_HESAP_KODU ( m_amor_gider_hesap_id ) );
}
}
else if ( widget EQ m_ui->searchedit_dmr_satis_kar_hesap_kodu ) {
m_dmr_satis_kar_hesap_id = OPEN_MUH_HESAP_ARAMA ( m_ui->searchedit_dmr_satis_kar_hesap_kodu->GET_TEXT(),this,1 );
if ( m_dmr_satis_kar_hesap_id NE -1 ) {
line_edit->setText ( MUH_GET_HESAP_KODU ( m_dmr_satis_kar_hesap_id ) );
}
}
else if ( widget EQ m_ui->searchEdit_personel_adi ) {
m_cari_hesap_id = OPEN_CARI_KART_ARAMA("",SAHIS_ARTI_FIRMA ,this,1,E9_PROGRAMI,PERSONEL_MODULU,QObject::tr("PERSONEL ARAMA"));
if ( m_cari_hesap_id > 0 ) {
line_edit->setText(CARI_FIND_HESAP_KODU(m_cari_hesap_id));
}
}
else if ( widget EQ m_ui->search_edit_gruplar ) {
int grup_id = SHOW_DMR_GRUP_TREE_SECIMI( this );
if ( grup_id EQ m_grup_id ) {
return;
}
m_grup_id = grup_id;
QList<int> m_grup_idleri;
m_grup_idleri << m_grup_id;
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() ));
}
}
else if ( widget EQ m_ui->searchEdit_sube_kodu ) {
m_sube_id = OPEN_SUBE_ARAMA(m_ui->searchEdit_sube_kodu->GET_TEXT(),this);
if ( m_sube_id NE -1 ) {
QString sube_kodu;
SUBE_GET_SUBE_KODU_ADI( m_sube_id, &sube_kodu );
m_ui->searchEdit_sube_kodu->SET_TEXT( sube_kodu );
}
}
}
void MUH_HESAP_EKLEME_FISI::ADD_LINE ( int fis_id, int row_number )
{
SQL_QUERY sql_query ( DB );
QString yeni_tam_hesap_kodu;
QLineEdit * lineEdit_hesap_kodu = ( QLineEdit * ) m_ui->tablewidget_alt_hesaplar->cellWidget( row_number, HESAP_KODU_COLUMN );
QString yeni_alt_hesap_kodu = lineEdit_hesap_kodu->text();
QLineEdit * lineEdit_hesap_ismi = ( QLineEdit * ) m_ui->tablewidget_alt_hesaplar->cellWidget( row_number, HESAP_ISMI_COLUMN );
QString yeni_alt_hesap_ismi = lineEdit_hesap_ismi->text();
yeni_tam_hesap_kodu.append ( MUH_GET_HESAP_KODU ( fis_id ) );
yeni_tam_hesap_kodu.append ( m_delimeter );
yeni_tam_hesap_kodu.append ( yeni_alt_hesap_kodu );
int parent_id = fis_id;
int hesap_seviyesi = m_ana_hesap_seviyesi + 1;
int alt_hesap_sayisi = 0;
sql_query.PREPARE_SELECT("muh_hesaplar" , "alt_hesap_sayisi" , "hesap_id = :hesap_id");
sql_query.SET_VALUE ( ":hesap_id",fis_id );
if ( sql_query.SELECT() NE 0 ) {
sql_query.NEXT();
alt_hesap_sayisi = sql_query.VALUE(0).toInt();
alt_hesap_sayisi++;
}
sql_query.PREPARE_UPDATE("muh_hesaplar" ,"hesap_id" , "tali_hesap , alt_hesap_sayisi",
"hesap_id = :hesap_id");
sql_query.SET_VALUE ( ":tali_hesap" , 0 );
sql_query.SET_VALUE ( ":alt_hesap_sayisi", alt_hesap_sayisi );
sql_query.SET_VALUE ( ":hesap_id " , fis_id );
sql_query.UPDATE();
sql_query.PREPARE_INSERT("muh_hesaplar" , "hesap_id" , "tali_hesap,alt_hesap_sayisi");
sql_query.SET_VALUE(":tali_hesap" , 1);
sql_query.SET_VALUE(":alt_hesap_sayisi" , 0);
int alt_hesap_id = sql_query.INSERT();
QTableWidgetItem * new_item = new QTableWidgetItem ( QVariant ( alt_hesap_id ).toString() );
m_ui->tablewidget_alt_hesaplar->setItem ( row_number, ROW_ID_COLUMN, new_item );
new_item = new QTableWidgetItem ( QVariant ( fis_id ).toString() );
m_ui->tablewidget_alt_hesaplar->setItem ( row_number, ANA_HESAP_ID_COLUMN, new_item );
sql_query.PREPARE_UPDATE("muh_hesaplar" , "hesap_id" , "parent_id , hesap_seviyesi, "
"hesap_kodu , hesap_ismi , tam_hesap_kodu , tali_hesap" ,
"hesap_id = :hesap_id");
sql_query.SET_VALUE ( ":parent_id" , parent_id );
sql_query.SET_VALUE ( ":hesap_seviyesi" , hesap_seviyesi );
sql_query.SET_VALUE ( ":hesap_kodu" , yeni_alt_hesap_kodu );
sql_query.SET_VALUE ( ":hesap_ismi" , yeni_alt_hesap_ismi );
sql_query.SET_VALUE ( ":tam_hesap_kodu" , yeni_tam_hesap_kodu );
sql_query.SET_VALUE ( ":tali_hesap" , 1 );
sql_query.SET_VALUE ( ":hesap_id" , alt_hesap_id );
sql_query.UPDATE();
int yeni_hesap_id = alt_hesap_id;
int yeni_hesap_parent_id = fis_id;
if ( m_ana_hesap_aktarilmalimi EQ true ) {
sql_query.PREPARE_SELECT("muh_hesaplar" , "parent_id,hesap_seviyesi" , "hesap_id = :hesap_id");
sql_query.SET_VALUE ( ":hesap_id", alt_hesap_id );
if ( sql_query.SELECT() EQ 0 ) {
return;
}
sql_query.NEXT();
yeni_hesap_id = alt_hesap_id;
yeni_hesap_parent_id = sql_query.VALUE ( "parent_id" ).toInt();
int yeni_hesap_seviyesi = sql_query.VALUE ( "hesap_seviyesi" ).toInt();
sql_query.PREPARE_SELECT("muh_hesaplar" , "parent_id, hesap_seviyesi ,hesap_kodu , hesap_ismi , tam_hesap_kodu, "
"toplam_borc_array,toplam_alacak_array" , "hesap_id = :hesap_id");
sql_query.SET_VALUE ( ":hesap_id", yeni_hesap_parent_id );
if (sql_query.SELECT() EQ 0 ) {
return;
}
sql_query.NEXT();
int temp_parent_id = sql_query.VALUE(0).toInt();
QString temp_hesap_seviyesi = sql_query.VALUE(1).toString();
QString temp_hesap_kodu = sql_query.VALUE(2).toString();
QString temp_hesap_ismi = sql_query.VALUE(3).toString();
QString temp_tam_hesap_kodu = sql_query.VALUE(4).toString();
double toplam_borc_array [ E9_ARRAY_SIZE ];
double toplam_alacak_array[ E9_ARRAY_SIZE ];
UNPACK_DOUBLE_ARRAY ( sql_query.VALUE(5).toString(),toplam_borc_array ,E9_ARRAY_SIZE );
UNPACK_DOUBLE_ARRAY ( sql_query.VALUE(6).toString(),toplam_alacak_array ,E9_ARRAY_SIZE );
SQL_QUERY update_query ( DB );
update_query.PREPARE_UPDATE ( "muh_hesaplar","hesap_id" ,"parent_id, hesap_seviyesi ,hesap_kodu , hesap_ismi,"
"tam_hesap_kodu , tali_hesap , alt_hesap_sayisi", "hesap_id = :hesap_id" );
update_query.SET_VALUE ( ":parent_id" , yeni_hesap_id );
update_query.SET_VALUE ( ":hesap_seviyesi" , yeni_hesap_seviyesi );
update_query.SET_VALUE ( ":hesap_kodu" , yeni_alt_hesap_kodu );
update_query.SET_VALUE ( ":hesap_ismi" , yeni_alt_hesap_ismi );
update_query.SET_VALUE ( ":tam_hesap_kodu" , yeni_tam_hesap_kodu );
update_query.SET_VALUE ( ":tali_hesap" , 1 );
update_query.SET_VALUE ( ":hesap_id" , yeni_hesap_parent_id );
update_query.SET_VALUE ( ":alt_hesap_sayisi", 0 );
update_query.UPDATE();
update_query.PREPARE_UPDATE ( "muh_hesaplar","hesap_id","parent_id , hesap_seviyesi ,"
"hesap_kodu , hesap_ismi , tam_hesap_kodu , tali_hesap ,"
"alt_hesap_sayisi, "
"toplam_borc_array, toplam_alacak_array" ,
"hesap_id = :hesap_id" );
update_query.SET_VALUE ( ":parent_id" , temp_parent_id );
update_query.SET_VALUE ( ":hesap_seviyesi" , temp_hesap_seviyesi );
update_query.SET_VALUE ( ":hesap_kodu" , temp_hesap_kodu );
update_query.SET_VALUE ( ":hesap_ismi" , temp_hesap_ismi );
update_query.SET_VALUE ( ":tam_hesap_kodu" , temp_tam_hesap_kodu );
update_query.SET_VALUE ( ":tali_hesap" , 0 );
update_query.SET_VALUE ( ":hesap_id" , yeni_hesap_id );
update_query.SET_VALUE ( ":alt_hesap_sayisi" , alt_hesap_sayisi );
update_query.SET_VALUE ( ":toplam_borc_array" , PACK_DOUBLE_ARRAY ( toplam_borc_array,E9_ARRAY_SIZE ) );
update_query.SET_VALUE ( ":toplam_alacak_array" , PACK_DOUBLE_ARRAY ( toplam_alacak_array,E9_ARRAY_SIZE ) );
update_query.UPDATE();
REFRESH_FIS_RECORD ( yeni_hesap_id );
int last_column = m_ui->tablewidget_alt_hesaplar->rowCount() -1;
m_ui->tablewidget_alt_hesaplar->setCurrentCell ( last_column,HESAP_KODU_COLUMN );
m_ana_hesap_id = yeni_hesap_id;
}
if ( m_ui->tablewidget_alt_hesaplar->item(row_number,GRUP_IDLERI) NE NULL ) {
QStringList grup_idleri_str = m_ui->tablewidget_alt_hesaplar->item(row_number,GRUP_IDLERI)->text().split("\t");
QList<int> grup_idleri;
for ( int i = 0 ; i < grup_idleri_str.size() ; i++ ) {
grup_idleri << grup_idleri_str.at(i).toInt();
}
GRP_KAYDI_GRUPLARA_EKLE(E9_PROGRAMI , MUHASEBE_MODULU , yeni_hesap_id , &grup_idleri );
}
m_ana_hesap_aktarilmalimi = false;
m_muh_hesap_plani->m_added_record << yeni_alt_hesap_kodu << yeni_alt_hesap_ismi << "0" <<
MUH_GET_BORC_ARRAY( yeni_hesap_parent_id ) << " " << MUH_GET_ALACAK_ARRAY( yeni_hesap_parent_id) << " " << QVariant ( yeni_hesap_parent_id ).toString();
m_muh_hesap_plani->m_updated_record << m_ana_hesap_kodu << m_ui->lineEdit_hesap_ismi->text() <<
QVariant ( alt_hesap_sayisi ).toString() << MUH_GET_BORC_ARRAY(yeni_hesap_id ) <<
" " << MUH_GET_ALACAK_ARRAY(yeni_hesap_id)+ " " << QVariant(yeni_hesap_parent_id).toString();
m_muh_hesap_plani->m_line_added = true;
m_muh_hesap_plani->m_record_updated = true;
QString log_detaylari = yeni_tam_hesap_kodu + " " + yeni_alt_hesap_ismi + QObject::tr ( " Hesabı Eklendi." );
E9_LOG_KAYDI_EKLE ( MUHASEBE_MODULU , LOG_MUH_HESAP_PLANI , LOG_ISLEM_ADD , log_detaylari );
}
