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