int BNK_VIRMAN_FORMU::FIND_FIRST_RECORD()
{
SQL_QUERY select_query(DB);
QString query_str = "modul_id = :modul_id";
if ( m_ent_filtresi_turu EQ FIS_BIRINCI_SIRKET ){
query_str.append( " AND kaydedilecek_sirket = 1 " );
}
else if( m_ent_filtresi_turu EQ FIS_IKINCI_SIRKET ){
query_str.append( " AND kaydedilecek_sirket = 0 " );
}
select_query.PREPARE_SELECT ( "bnk_virman_fisler","fis_id", query_str );
select_query.SET_VALUE(":modul_id" , BANKA_MODULU );
if ( select_query.SELECT(" fis_tarihi ASC, fis_no ASC",0,1) EQ 0 ) {
return 0;
}
select_query.NEXT();
return select_query.VALUE(0).toInt();
}
/**
* @brief db_select_query
* 查找操作
* @Param: colstr 列字段
* @Param: wheresrt 过滤字段
* @Param: tablename 表名
* @Param: retstr 查找结果
*
* Returns:
*/
static Uint32 db_select_query(const string &colstr, const string &wheresrt, const string &tablename, string &retstr)
{
retstr.clear();
if (colstr.empty())
{
LOG_ERROR("colstr is empty.\n");
return -1;
}
if(strcmp(tablename.c_str(),"") == 0 )
{
LOG_ERROR("no such table.\n");
return -1;
}
string sql = "SELECT ";
sql += colstr;
sql += " from ";
sql += tablename;
if (!wheresrt.empty())
{
sql += " where ";
sql += wheresrt;
}
LOG_DEBUG("SelectQuery len=%ld sql=%s\n", sql.length(), sql.c_str());
return select_query(sql,retstr);
}
int DMR_DEMIRBAS_KARTI::CHECK_DELETE ( int record_id )
{
Q_UNUSED ( record_id );
int demirbas_id = DMR_GET_DEMIRBAS_ID ( m_ui->lineedit_demirbas_kodu->text() );
SQL_QUERY select_query ( DB );
select_query.PREPARE_SELECT ( "dmr_fis_satirlari","fis_id ","demirbas_id = :demirbas_id" );
select_query.SET_VALUE ( ":demirbas_id" , demirbas_id );
if ( select_query.SELECT() NE 0 ) {
MSG_WARNING( tr ( "Demirbaş fişlerde kullanılmış,kartı silemezsiniz!.." ) , NULL );
return ADAK_FAIL;
}
int msg_secim = MSG_YES_NO( tr ( "Seçili demirbaş kayıtlardan silinecektir.\n Devam etmek istiyor musunuz?" ), NULL );
if ( msg_secim EQ ADAK_NO ) {
return ADAK_FAIL;
}
return ADAK_OK;
}
QStringList CARI_BAKIYE_RAPORU::GET_CARI_HESAPLAR_LIST()
{
QStringList cari_hesap;
QStringList cari_hesaplar_list;
SQL_QUERY select_query(DB);
select_query.PREPARE_SELECT ( "car_hesaplar", "cari_hesap_id,cari_hesap_kodu,adres_id" );
if ( M_CARI_RV->bas_hesap_kodu.isEmpty() NE true OR M_CARI_RV->bts_hesap_kodu.isEmpty() NE true ) {
select_query.AND_EKLE ( "cari_hesap_kodu BETWEEN :bas_hesap_kodu AND :bts_hesap_kodu " );
select_query.SET_VALUE ( ":bas_hesap_kodu",M_CARI_RV->bas_hesap_kodu );
select_query.SET_VALUE ( ":bts_hesap_kodu",M_CARI_RV->bts_hesap_kodu );
}
if ( select_query.SELECT( "cari_hesap_kodu ASC" ) EQ 0 ) {
return QStringList();
}
while (select_query.NEXT()) {
QString cari_hesap_id = select_query.VALUE(0).toString();
QString cari_hesap_kodu = select_query.VALUE(1).toString();
QString cari_hesap_ismi = ADR_GET_FIRMA_SAHIS_ADI(select_query.VALUE(2).toInt());
cari_hesap.clear();
cari_hesap.append(cari_hesap_id + "\t" + cari_hesap_kodu + "\t" + cari_hesap_ismi + "\t");
cari_hesaplar_list << cari_hesap;
}
return cari_hesaplar_list;
}
int DMR_DEMIRBAS_KARTI::FIND_LAST_RECORD ()
{
SQL_QUERY select_query ( DB );
select_query.PREPARE_SELECT ( "dmr_demirbaslar","demirbas_id " );
if ( select_query.SELECT("demirbas_kodu DESC",0,1) EQ 0 ) {
return 0;
}
select_query.NEXT();
return select_query.VALUE(0).toInt();
}
QString SUBE_GET_DEPO_KODU ( int p_depo_id )
{
SQL_QUERY select_query ( DB );
select_query.PREPARE_SELECT ( "sub_depolar","depo_kodu","depo_id = :depo_id" );
select_query.SET_VALUE ( ":depo_id" , p_depo_id );
if ( select_query.SELECT() EQ 0 ) {
return "";
}
select_query.NEXT();
return select_query.VALUE(0).toString();
}
int DMR_DEMIRBAS_KARTI::FIND_PREV_RECORD ()
{
SQL_QUERY select_query ( DB );
select_query.PREPARE_SELECT ( "dmr_demirbaslar","demirbas_id ","demirbas_kodu < :demirbas_kodu");
select_query.SET_VALUE ( ":demirbas_kodu" , m_ui->lineedit_demirbas_kodu->text() );
if ( select_query.SELECT( "demirbas_kodu DESC",0,1) EQ 0 ) {
return 0;
}
select_query.NEXT();
return select_query.VALUE(0).toInt();
}
int BNK_VIRMAN_FORMU::FIND_PREV_RECORD ()
{
SQL_QUERY select_query(DB);
QString where_str = "fis_no < :fis_no "
"AND modul_id = :modul_id "
"AND fis_tarihi = :fis_tarihi ";
if ( m_ent_filtresi_turu EQ FIS_BIRINCI_SIRKET ){
where_str.append( " AND kaydedilecek_sirket = 1 " );
}
else if( m_ent_filtresi_turu EQ FIS_IKINCI_SIRKET ){
where_str.append( " AND kaydedilecek_sirket = 0 " );
}
select_query.PREPARE_SELECT( "bnk_virman_fisler","fis_id", where_str);
select_query.SET_VALUE(":fis_no" , QVariant ( m_ui->lineEdit_fis_no->text()).toInt() );
select_query.SET_VALUE(":modul_id" , BANKA_MODULU );
select_query.SET_VALUE(":fis_tarihi" , m_ui->adakDate_tarih->DATE());
if ( select_query.SELECT("fis_no DESC",0,1) > 0 ) {
select_query.NEXT();
return select_query.VALUE(0).toInt();
}
where_str = "modul_id = :modul_id "
"AND fis_tarihi < :fis_tarihi ";
if ( m_ent_filtresi_turu EQ FIS_BIRINCI_SIRKET ){
where_str.append( " AND kaydedilecek_sirket = 1 " );
}
else if( m_ent_filtresi_turu EQ FIS_IKINCI_SIRKET ){
where_str.append( " AND kaydedilecek_sirket = 0 " );
}
select_query.PREPARE_SELECT( "bnk_virman_fisler","fis_id", where_str );
select_query.SET_VALUE(":modul_id" , BANKA_MODULU );
select_query.SET_VALUE(":fis_tarihi" , m_ui->adakDate_tarih->DATE());
if ( select_query.SELECT("fis_tarihi DESC, fis_no DESC",0,1) EQ 0 ) {
return 0;
}
select_query.NEXT();
return select_query.VALUE(0).toInt();
}
int STOK_HIZMET_KARTI_FORMU::FIND_LAST_RECORD ()
{
SQL_QUERY select_query(DB);
select_query.PREPARE_SELECT("stk_urunler","urun_id" ,"hizmet_mi = :hizmet_mi ");
select_query.SET_VALUE(":hizmet_mi" , 1);
if (select_query.SELECT("urun_kodu DESC" , 0,1) EQ 0 ) {
return 0;
}
select_query.NEXT();
return select_query.VALUE(0).toInt();
}
QString ADR_GET_GRUP_ISMI ( int grup_id )
{
SQL_QUERY select_query ( DB );
select_query.PREPARE_SELECT ( "adak_gruplar","grup_adi","grup_id = :grup_id" );
select_query.SET_VALUE ( ":grup_id" , grup_id );
if ( select_query.SELECT() EQ 0 ) {
return NULL;
}
select_query.NEXT();
return select_query.VALUE( 0 ).toString();
}
int ADR_GET_GRUP_ID ( QString tam_grup_kodu )
{
SQL_QUERY select_query ( DB );
select_query.PREPARE_SELECT ( "adak_gruplar","grup_id","tam_grup_kodu = :tam_grup_kodu" );
select_query.SET_VALUE ( ":grup_id" , tam_grup_kodu );
if (select_query.SELECT() EQ 0 ) {
return 0;
}
select_query.NEXT();
return select_query.VALUE( 0 ).toInt();
}
void CARI_FISI_YAZDIR_RAPORU::GET_CARI_FIS_SATIRLARI()
{
QStringList fis_satiri;
SQL_QUERY select_query ( DB );
SQL_QUERY query(DB);
select_query.PREPARE_SELECT ( "car_fis_satirlari", "cari_hesap_id , aciklama,borc_tutari,alacak_tutari , "
"doviz_id,doviz_kuru,parite,cari_para_birimi_tutari,temel_para_birimi_tutari ",
"fis_id = :fis_id");
select_query.SET_VALUE ( ":fis_id" , m_fis_id );
if ( select_query.SELECT() EQ 0 ) {
return;
}
while ( select_query.NEXT() EQ true ) {
int cari_hesap_id = select_query.VALUE(0).toInt();
QString aciklama = select_query.VALUE(1).toString();
double borc_tutari = select_query.VALUE(2).toDouble();
double alacak_tutari = select_query.VALUE(3).toDouble();
int doviz_id = select_query.VALUE(4).toInt();
double doviz_kuru = select_query.VALUE(5).toDouble();
double parite = select_query.VALUE(6).toDouble();
double cari_para_birimi_tutari = select_query.VALUE(7).toDouble();
double temel_para_birimi_tutari= select_query.VALUE(8).toDouble();
QString cari_hesap_kodu, cari_hesap_ismi;
int para_birim_id;
int result = CARI_GET_HESAP_KODU_ISMI_PARA_BIRIM_ID( cari_hesap_id, &cari_hesap_kodu, &cari_hesap_ismi, ¶_birim_id );
QString cari_hesap_kodu_adi;
if ( result NE 0 ) {
cari_hesap_kodu_adi = cari_hesap_kodu + ADD_HTML_SPACE(" ") +
cari_hesap_ismi + ADD_HTML_SPACE(" ") +
DVZ_GET_DOVIZ_KODU( para_birim_id );
}
fis_satiri.clear();
fis_satiri.append (cari_hesap_kodu_adi + "\t" + aciklama + "\t"+ VIRGUL_EKLE( QVariant(ROUND(borc_tutari )).toString(),2)
+ "\t" + VIRGUL_EKLE( QVariant(ROUND(alacak_tutari)).toString(),2) + "\t"
+ DVZ_GET_DOVIZ_KODU(doviz_id) + "\t" + VIRGUL_EKLE( QVariant(ROUND(doviz_kuru,-4)).toString(),2)
+ "\t" + VIRGUL_EKLE( QVariant(ROUND(parite,-4)).toString(),2) + "\t"
+ VIRGUL_EKLE( QVariant(ROUND(cari_para_birimi_tutari)).toString(),2)
+ "\t" + VIRGUL_EKLE( QVariant(ROUND(temel_para_birimi_tutari)).toString(),2));
m_fis_satirlari_list << fis_satiri;
}
}
int GRUP_KERNEL::CHECK_DELETE_ITEM (QStringList item)
{
int item_id = -1;
if ( item.size() NE 0 ) {
item_id = item.at( m_grp_id_column ).toInt();
}
if ( item_id EQ -1 ) {
return ADAK_FAIL;
}
if ( item.at(2).toInt() NE 0 ) {
MSG_ERROR(tr ( "You must delete sub-group for deleting this group. "),NULL);//Grubu silebilmek için,önce grubun alt gruplarını silmelisiniz!..
return ADAK_FAIL;
}
ADAK_MSG_ENUM answer = MSG_YES_NO(tr ( "Group will be deleted '%1 %2'" ).arg(item.at(7)).arg(item.at(1)),NULL);
if ( answer EQ ADAK_NO OR answer EQ ADAK_CANCEL) {
return ADAK_FAIL;
}
SQL_QUERY select_query ( m_db );
QString table_name = "";
QString column_name = "";
QString where_name = "";
QString order_by = "";
CREATE_SELECT_QUERY(&table_name,&column_name,&where_name,&order_by,item.at( 5 ).toInt());
select_query.PREPARE_SELECT ( table_name,column_name,where_name,"" );
if ( select_query.SELECT(order_by) EQ 1 ) {
if ( item.at(3).toInt() NE 0 ) {
m_grubu_parentine_aktar = true;
}
return ADAK_OK;
}
if ( item.at( 3 ).toInt() NE 0 ) {
MSG_ERROR(tr ( "It was recorded in the group. You can not delete the group..." ),NULL);//Gruba kayıt yapılmış. Grubu silemezsiniz..
return ADAK_FAIL;
}
return ADAK_OK;
}
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 main(int argc, char *argv[]) {
auto db = get_database(argc, argv);
test_init(4);
const int16_t negative_int = -16000;
const uint16_t high_int = 34000;
db->execute("CREATE TABLE rusqltest (`value` SMALLINT(3) NOT NULL)");
test_start_try(2);
try {
db->execute("INSERT INTO rusqltest VALUES (?)", negative_int);
pass("store negative int");
auto res = db->select_query("SELECT * FROM rusqltest");
test(res.get<int16_t>(0) == negative_int, "retrieve negative int");
} catch(std::exception &e) {
diag(e);
}
test_finish_try();
db->execute("DROP TABLE rusqltest");
db->execute("CREATE TABLE rusqltest (`value` SMALLINT(3) UNSIGNED NOT NULL)");
test_start_try(2);
try {
db->execute("INSERT INTO rusqltest VALUES (?)", high_int);
pass("store high int");
auto res = db->select_query("SELECT * FROM rusqltest");
diag(res.get_string(0));
test(res.get<uint16_t>(0) == high_int, "retrieve high int");
} catch(std::exception &e) {
diag(e);
}
test_finish_try();
db->execute("DROP TABLE rusqltest");
return 0;
}
int DMR_DEMIRBAS_KARTI::FIND_RECORD()
{
SQL_QUERY select_query ( DB );
select_query.PREPARE_SELECT ( "dmr_demirbaslar","demirbas_id ","demirbas_kodu = :demirbas_kodu");
select_query.SET_VALUE ( ":demirbas_kodu" , m_ui->lineedit_demirbas_kodu->text() );
if ( select_query.SELECT() EQ 0 ) {
MSG_WARNING( tr ( "Aradığınız demirbaş kodu bulunamadı!.." ), m_ui->lineedit_demirbas_kodu );
return 0;
}
select_query.NEXT();
return select_query.VALUE(0).toInt();
}
int STOK_HIZMET_KARTI_FORMU::FIND_PREV_RECORD ()
{
SQL_QUERY select_query(DB);
select_query.PREPARE_SELECT("stk_urunler" , "urun_id" , "hizmet_mi =:hizmet_mi AND "
"urun_kodu < :urun_kodu");
select_query.SET_VALUE(":hizmet_mi" , 1);
select_query.SET_VALUE(":urun_kodu" , m_ui->lineEdit_hizmet_kodu->text());
if(select_query.SELECT() EQ 0 ) {
return 0;
}
select_query.NEXT();
return select_query.VALUE(0).toInt();
}
void MetadataStorage::get_configs(std::string *creation_datetime)
{
{ // Read creation time
std::string query = "SELECT value FROM akumuli_configuration WHERE name='creation_time'";
auto results = select_query(query.c_str());
if (results.size() != 1) {
throw std::runtime_error("Invalid configuration (creation_time)");
}
auto tuple = results.at(0);
if (tuple.size() != 1) {
throw std::runtime_error("Invalid configuration query (creation_time)");
}
// This value can be encoded as dobule by the sqlite engine
*creation_datetime = tuple.at(0);
}
}
int STOK_HIZMET_KARTI_FORMU::FIND_RECORD()
{
SQL_QUERY select_query(DB);
select_query.PREPARE_SELECT("stk_urunler","urun_id" ,"hizmet_mi = :hizmet_mi AND urun_kodu = :urun_kodu");
select_query.SET_VALUE(":hizmet_mi" , 1);
select_query.SET_VALUE(":urun_kodu" , m_ui->lineEdit_hizmet_kodu->text());
if(select_query.SELECT() EQ 0 ) {
MSG_WARNING( tr(" Aradığınız hizmet kodu bulunamadı!.."), m_ui->lineEdit_hizmet_kodu );
return 0;
}
select_query.NEXT();
return select_query.VALUE(0).toInt();
}
QStringList BNK_KK_EKSTRESI_RAPORU::GET_KREDI_KARTI_ISLEMLERI()
{
SQL_QUERY select_query(DB);
QStringList kredi_karti_islemleri;
QString where_str = QString("fis_turu = :fis_turu "
"AND bnk_defter_fisler.fis_id = bnk_defter_fis_satirlari.fis_id AND "
"hesap_id = :hesap_id AND "
"hesap_turu = :hesap_turu "
"AND fis_tarihi BETWEEN :baslangic_tarihi AND :bitis_tarihi ");
if ( BNK_RV->entegre_filtresi EQ FIS_BIRINCI_SIRKET ) {
where_str += QString(" AND bnk_defter_fisler.kaydedilecek_sirket = 1 ");
}
else if ( BNK_RV->entegre_filtresi EQ FIS_IKINCI_SIRKET ) {
where_str += QString ( " AND bnk_defter_fisler.kaydedilecek_sirket = 0 ");
}
select_query.PREPARE_SELECT("bnk_defter_fisler,bnk_defter_fis_satirlari","fis_tarihi,fis_no,"
"hesaba_giren, hesaptan_cikan, bnk_defter_fis_satirlari.aciklama",where_str);
select_query.SET_VALUE(":fis_turu" , ENUM_BANKA_HAREKET_FISI );
select_query.SET_VALUE(":hesap_id" , BNK_RV->kredi_karti_id);
select_query.SET_VALUE(":hesap_turu" , ENUM_BNK_KREDI_KARTI_HESABI);
select_query.SET_VALUE(":baslangic_tarihi" , BNK_RV->baslangic_tarihi.toString("yyyy.MM.dd"));
select_query.SET_VALUE(":bitis_tarihi" , BNK_RV->bitis_tarihi.toString("yyyy.MM.dd"));
if ( select_query.SELECT("fis_tarihi ASC , fis_no ASC") EQ 0 ) {
return QStringList();
}
QString fis_no;
while (select_query.NEXT()) {
fis_no = select_query.VALUE(1).toString();
kredi_karti_islemleri.append(select_query.VALUE(0).toDate().toString("dd MMMM yyyy dddd") + "\t" +
fis_no + "\t" +
select_query.VALUE(4).toString() + "\t" +
QVariant ( ROUND(select_query.VALUE(2).toDouble())).toString() + "\t" +
QVariant ( ROUND(select_query.VALUE(3).toDouble())).toString() );
}
return kredi_karti_islemleri;
}
std::vector<MetadataStorage::VolumeDesc> MetadataStorage::get_volumes() const {
const char* query =
"SELECT id, path FROM akumuli_volumes;";
std::vector<VolumeDesc> tuples;
std::vector<UntypedTuple> untyped = select_query(query);
// get rows
auto ntuples = untyped.size();
for (size_t i = 0; i < ntuples; i++) {
// get id
std::string idrepr = untyped.at(i).at(0);
int id = boost::lexical_cast<int>(idrepr);
// get path
std::string path = untyped.at(i).at(1);
tuples.push_back(std::make_pair(id, path));
}
return tuples;
}
QStringList BNK_HAREKET_FISI_ARAMA::GET_UYGUN_BANKA_HESAPLARI_ID_LIST(QString banka_ismi)
{
SQL_QUERY select_query(DB);
select_query.PREPARE_SELECT("bnk_hesaplar","hesap_no_id","banka_ismi = :banka_ismi");
select_query.SET_VALUE(":banka_ismi" , banka_ismi);
if(select_query.SELECT() EQ 0){
return QStringList();
}
QStringList banka_hesaplari_id_list;
while (select_query.NEXT()) {
banka_hesaplari_id_list << select_query.VALUE(0).toString();
}
return banka_hesaplari_id_list;
}
int SUBE_GET_DEPO_ID ( QString p_depo_kodu , int p_sube_id )
{
SQL_QUERY select_query ( DB );
select_query.PREPARE_SELECT ( "sub_depolar","depo_id ","depo_kodu = :depo_kodu" );
select_query.SET_VALUE ( ":depo_kodu" , p_depo_kodu );
if ( p_sube_id NE 0 ) {
select_query.AND_EKLE ( "sube_id = :sube_id" );
select_query.SET_VALUE ( ":sube_id", p_sube_id );
}
if ( select_query.SELECT() EQ 0 ) {
return 0;
}
select_query.NEXT();
return select_query.VALUE(0).toInt();
}
void XYZ_FORMU::SEARCH_EDIT_CLICKED(QWidget *,QLineEdit * line_edit)
{
int xyz_id = OPEN_XYZ_ARAMA ( this );
if ( xyz_id EQ -1 ) {
return;
}
SQL_QUERY select_query (DB);
select_query.PREPARE_SELECT ( "xyz_gruplari","xyz_kodu","xyz_id = :xyz_id" );
select_query.SET_VALUE ( ":xyz_id", xyz_id );
if (select_query.SELECT() NE 0) {
select_query.NEXT();
line_edit->setText(select_query.VALUE(0).toString());
}
}
void CARI_FISI_YAZDIR_RAPORU::FILL_HEADER_STRUCT()
{
SQL_QUERY select_query ( DB );
select_query.PREPARE_SELECT ( "car_fisler", "fis_tarihi,fis_no,aciklama",
"fis_id = :fis_id" );
select_query.SET_VALUE ( ":fis_id" , m_fis_id );
if ( select_query.SELECT() EQ 0 ) {
return;
}
select_query.NEXT();
M_REPORT_HEADER_INFO.fis_tarihi = select_query.VALUE(0).toDate().toString("dd MMMM yyyy dddd");
M_REPORT_HEADER_INFO.fis_no = select_query.VALUE(1).toString();
M_REPORT_HEADER_INFO.aciklama = select_query.VALUE(2).toString();
}
aku_Status MetadataStorage::load_matcher_data(SeriesMatcher& matcher) {
auto query = "SELECT series_id || ' ' || keyslist, storage_id FROM akumuli_series;";
try {
auto results = select_query(query);
for(auto row: results) {
if (row.size() != 2) {
continue;
}
auto series = row.at(0);
auto id = boost::lexical_cast<uint64_t>(row.at(1));
matcher._add(series, id);
}
} catch(...) {
(*logger_)(AKU_LOG_ERROR, boost::current_exception_diagnostic_information().c_str());
return AKU_EGENERAL;
}
return AKU_SUCCESS;
}
uint64_t MetadataStorage::get_prev_largest_id() {
auto query = "SELECT max(storage_id) FROM akumuli_series;";
try {
auto results = select_query(query);
auto row = results.at(0);
if (row.empty()) {
AKU_PANIC("Can't get max storage id");
}
auto id = row.at(0);
if (id == "") {
// Table is empty
return 1ul;
}
return boost::lexical_cast<uint64_t>(id);
} catch(...) {
(*logger_)(AKU_LOG_ERROR, boost::current_exception_diagnostic_information().c_str());
AKU_PANIC("Can't get max storage id");
}
}
int SUBE_GET_UNITE_MUH_KASA_HESABI_ID()
{
SQL_QUERY select_query ( DB );
select_query.PREPARE_SELECT ( "sub_uniteler","muh_kasa_hesap_id ",
"unite_id = :unite_id" );
select_query.SET_VALUE ( ":unite_id",g_kasa_unite_id );
if ( select_query.SELECT() EQ 0 ) {
return 0;
}
select_query.NEXT();
int kasa_unite_muh_kasa_hesabi_id = select_query.VALUE(0).toInt();
if ( kasa_unite_muh_kasa_hesabi_id EQ 0 ) {
return 0;
}
return kasa_unite_muh_kasa_hesabi_id;
}
void DMR_DEMIRBAS_KARTI::NEW_RECORD()
{
m_cari_hesap_id = 0;
m_ui->checkBox_kist_amortisman->setChecked ( false );
m_ui->checkBox_yeniden_degerleme->setChecked ( true );
m_ui->checkBox_amortisman_ayrilacak_mi->setChecked(true);
SQL_QUERY select_query ( DB ) ;
select_query.PREPARE_SELECT ( "e9_sabit_degerler","dmr_amor_yntemi_degisebilir_mi, dmr_amortisman_ayirma_yontemi,"
"dmr_max_amortisman_orani ",
"sabit_deger_id = :sabit_deger_id" );
select_query.SET_VALUE(":sabit_deger_id",1);
bool amortisman_ayirma_yontemi_demirbaslara_gore_degisir_mi = 1;
m_max_amortisman_orani = 50;
if( select_query.SELECT() NE 0 ) {
select_query.NEXT();
amortisman_ayirma_yontemi_demirbaslara_gore_degisir_mi = select_query.VALUE(0).toBool();
m_max_amortisman_orani = select_query.VALUE(2).toDouble();
if ( amortisman_ayirma_yontemi_demirbaslara_gore_degisir_mi EQ false ) {
m_ui->comboBox_amortisman_yontemi->setDisabled ( true );
m_ui->label_amortisman_yontemi->setDisabled ( true );
m_ui->comboBox_amortisman_yontemi->setCurrentIndex ( m_ui->comboBox_amortisman_yontemi->findText(DMR_GET_AMORTISMAN_SEKLI_STRING(select_query.VALUE(1).toInt())));
}
}
else {
m_ui->comboBox_amortisman_yontemi->setCurrentIndex(-1);
}
}
int DMR_DEMIRBAS_KARTI::CHECK_VAR ( QObject * object )
{
if ( object EQ m_ui->searchedit_muh_hesap_kodu ) {
m_ui->lineedit_muh_hesap_ismi->clear();
int hesap_id;
QString hesap_ismi;
if ( MUH_GET_HESAP_ID_HESAP_ISMI(m_ui->searchedit_muh_hesap_kodu->GET_TEXT(),
hesap_id,hesap_ismi) EQ 0 ) {
MSG_WARNING( tr ( "Aradığınız muhasebe hesap kodu bulunamadı!.." ), m_ui->searchedit_muh_hesap_kodu );
return ADAK_FAIL;
}
m_muh_hesap_id = hesap_id;
m_ui->lineedit_muh_hesap_ismi->setText ( hesap_ismi );
}
else if ( object EQ m_ui->searchedit_amor_gdr_hesap_kodu ) {
m_ui->lineEdit_amor_gdr_hesap_ismi->clear();
int hesap_id;
QString hesap_ismi;
if ( MUH_GET_HESAP_ID_HESAP_ISMI(m_ui->searchedit_amor_gdr_hesap_kodu->GET_TEXT(),
hesap_id,hesap_ismi) EQ 0 ) {
MSG_WARNING( tr ( "Aradığınız muhasebe hesap kodu bulunamadı!.." ), m_ui->searchedit_amor_gdr_hesap_kodu );
return ADAK_FAIL;
}
m_amor_gider_hesap_id = hesap_id;
m_ui->lineEdit_amor_gdr_hesap_ismi->setText ( hesap_ismi);
}
else if ( object EQ m_ui->searchedit_bir_amortisman_hesap_kodu ) {
m_ui->lineEdit_bir_amortisman_hesap_ismi->clear();
int hesap_id;
QString hesap_ismi;
if ( MUH_GET_HESAP_ID_HESAP_ISMI(m_ui->searchedit_bir_amortisman_hesap_kodu->GET_TEXT(),
hesap_id,hesap_ismi) EQ 0 ) {
MSG_WARNING( tr ( "Aradığınız muhasebe hesap kodu bulunamadı!.." ), m_ui->searchedit_bir_amortisman_hesap_kodu );
return ADAK_FAIL;
}
m_bir_amor_hesap_id = hesap_id;
m_ui->lineEdit_bir_amortisman_hesap_ismi->setText ( hesap_ismi );
}
else if ( object EQ m_ui->searchedit_dmr_satis_kar_hesap_kodu ) {
m_ui->lineEdit_dmr_satis_kar_hesap_ismi->clear();
int hesap_id;
QString hesap_ismi;
if ( MUH_GET_HESAP_ID_HESAP_ISMI(m_ui->searchedit_dmr_satis_kar_hesap_kodu->GET_TEXT(),
hesap_id,hesap_ismi) EQ 0 ) {
MSG_WARNING( tr ( "Aradığınız muhasebe hesap kodu bulunamadı!.." ), m_ui->searchedit_dmr_satis_kar_hesap_kodu );
return ADAK_FAIL;
}
m_dmr_satis_kar_hesap_id = hesap_id;
m_ui->lineEdit_dmr_satis_kar_hesap_ismi->setText ( hesap_ismi);
}
else if ( object EQ m_ui->searchedit_dmr_satis_zarar_hesap_kodu ) {
m_ui->lineEdit_dmr_satis_zarar_hesap_ismi->clear();
int hesap_id;
QString hesap_ismi;
if ( MUH_GET_HESAP_ID_HESAP_ISMI(m_ui->searchedit_dmr_satis_zarar_hesap_kodu->GET_TEXT(),
hesap_id,hesap_ismi) EQ 0 ) {
MSG_WARNING( tr ( "Aradığınız muhasebe hesap kodu bulunamadı!.." ), m_ui->searchedit_dmr_satis_zarar_hesap_kodu );
return ADAK_FAIL;
}
m_dmr_satis_zarar_hesap_id = hesap_id;
m_ui->lineEdit_dmr_satis_zarar_hesap_ismi->setText (hesap_ismi);
}
else if ( object EQ m_ui->searchEdit_sube_kodu ) {
if ( m_ui->searchEdit_sube_kodu->GET_TEXT().isEmpty() EQ true ) {
m_ui->lineEdit_sube_ismi->clear();
m_sube_id = -1;
return ADAK_OK;
}
QString sube_adi;
int sube_id;
int result = SUBE_GET_SUBE_ID_ADI( m_ui->searchEdit_sube_kodu->GET_TEXT() , &sube_id, &sube_adi );
if ( result EQ 0 ) {
MSG_WARNING(tr("Aradığınız sube kodu bulunamadı.") , m_ui->searchEdit_sube_kodu);
SET_FOCUS( m_ui->searchEdit_sube_kodu );
return ADAK_FAIL_UNDO;
}
m_ui->lineEdit_sube_ismi->setText( sube_adi );
m_sube_id = sube_id;
}
else if ( object EQ m_ui->lineedit_amortisman_suresi ) {
QRegExp rx ( "^\\d\\d?$" );
if ( rx.indexIn ( m_ui->lineedit_amortisman_suresi->text()) EQ -1 ) {
MSG_WARNING( tr ( "Amortisman süresine sadece 1-99 arası bir sayı girebilirsiniz!.."), m_ui->lineedit_amortisman_suresi);
return ADAK_FAIL;
}
int amortisman_suresi = m_ui->lineedit_amortisman_suresi->text().toInt();
if ( amortisman_suresi EQ 0 ) {
MSG_WARNING( tr ( "Amortisman süresi sıfır olamaz."), m_ui->lineedit_amortisman_suresi );
return ADAK_FAIL;
}
double amortisman_orani = 100 / amortisman_suresi;
if ( ( amortisman_orani * 2 ) > m_max_amortisman_orani ) {
MSG_WARNING( tr ( "Demirbaşın amortisman oranı,max amortisman oranının en fazla yarısı kadar olabilir.Girdiğiniz amortisman süresi çok uzun lütfen düzeltiniz!.."), m_ui->lineedit_amortisman_suresi );
return ADAK_FAIL;
}
m_ui->commaEdit_amortisman_orani->SET_DOUBLE ( amortisman_orani );
}
else if ( object EQ m_ui->comboBox_amortisman_yontemi ) {
SQL_QUERY select_query ( DB );
select_query.PREPARE_SELECT ( "dmr_demirbaslar","amortisman_ayrilabilir_mi","demirbas_id = :demirbas_id" );
select_query.SET_VALUE ( ":demirbas_id" , DMR_GET_DEMIRBAS_ID(m_ui->lineedit_demirbas_kodu->text() ) );
if ( select_query.SELECT() NE 0 ) {
select_query.NEXT();
bool amortisman_ayrilabilir_mi = select_query.VALUE(0).toBool();
if ( amortisman_ayrilabilir_mi EQ false ) {
int msg_secim = MSG_YES_NO( tr ( "Demirbaş için amortisman ayrılmıştır..\n Amortisman yöntemini değiştirmek istediğinizden emin misiniz? "), NULL );
if ( msg_secim EQ ADAK_NO ) {
return ADAK_FAIL;
}
}
}
}
else if ( object EQ m_ui->comboBox_amortisman_yontemi OR object EQ m_ui->lineedit_amortisman_suresi
OR object EQ m_ui->commaEdit_alis_fiyati OR object EQ m_ui->checkBox_amortisman_ayrilacak_mi
OR object EQ m_ui->commaEdit_birikmis_amortisman) {
SQL_QUERY select_query ( DB );
select_query.PREPARE_SELECT ( "dmr_fis_satirlari","fis_satiri_id","demirbas_id = :demirbas_id" );
select_query.SET_VALUE ( ":demirbas_id" , DMR_GET_DEMIRBAS_ID ( m_ui->lineedit_demirbas_kodu->text() ) );
if ( select_query.SELECT() NE 0 ) {
MSG_WARNING( tr ( "Demirbaş fişlerde kullanılmıştır.Amortisman yöntemini,süresini,grubunu,alış fiyatı ve birikmiş amortisman tutarını değiştiremezsiniz!.."), NULL );
return ADAK_FAIL;
}
}
else if ( object EQ m_ui->searchEdit_personel_adi ) {
if ( m_ui->searchEdit_personel_adi->GET_TEXT().isEmpty() EQ true ) {
m_ui->lineEdit_personel_soyadi->clear();
m_cari_hesap_id = 0;
return ADAK_OK;
}
QString cari_hesap_ismi;
int result = CARI_GET_HESAP_KODU_ISMI_PARA_BIRIM_ID( m_ui->searchEdit_personel_adi->GET_TEXT(), &m_cari_hesap_id, &cari_hesap_ismi );
if ( result EQ 0 ) {
MSG_WARNING("Aradığınız personel bulunamadı." , m_ui->searchEdit_personel_adi);
return ADAK_FAIL;
}
m_ui->lineEdit_personel_soyadi->setText( cari_hesap_ismi );
}
else if ( object EQ m_ui->checkBox_amortisman_ayrilacak_mi ) {
if ( m_ui->checkBox_amortisman_ayrilacak_mi->isChecked() EQ true ) {
m_ui->comboBox_amortisman_yontemi->setEnabled(true);
m_ui->lineedit_amortisman_suresi->setEnabled(true);
m_ui->commaEdit_amortisman_orani->setEnabled(true);
}
else {
m_ui->comboBox_amortisman_yontemi->setEnabled(false);
m_ui->lineedit_amortisman_suresi->setEnabled(false);
m_ui->commaEdit_amortisman_orani->setEnabled(false);
}
}
return ADAK_OK;
}
