X-Git-Url: https://git.stg.codes/stg.git/blobdiff_plain/ad32e2b6fbd75d8f77b2e9ca2f4d3bee0ad269de..da585bb94c437f06762a2042ef4c52166b8aafce:/projects/stargazer/plugins/store/firebird/firebird_store_tariffs.cpp diff --git a/projects/stargazer/plugins/store/firebird/firebird_store_tariffs.cpp b/projects/stargazer/plugins/store/firebird/firebird_store_tariffs.cpp index b00fd122..4e666794 100644 --- a/projects/stargazer/plugins/store/firebird/firebird_store_tariffs.cpp +++ b/projects/stargazer/plugins/store/firebird/firebird_store_tariffs.cpp @@ -160,20 +160,34 @@ try if (schemaVersion > 0) query += ", period = ?"; if (schemaVersion > 1) - query += ", change_policy = ?"; + query += ", change_policy = ?, \ + change_policy_timeout = ?"; query += " where pk_tariff = ?"; + unsigned num = 5; + st->Prepare(query); st->Set(1, td.tariffConf.fee); st->Set(2, td.tariffConf.free); st->Set(3, td.tariffConf.passiveCost); st->Set(4, td.tariffConf.traffType); if (schemaVersion > 0) + { st->Set(5, TARIFF::PeriodToString(td.tariffConf.period)); + ++num; + } + if (schemaVersion > 1) + { st->Set(6, TARIFF::ChangePolicyToString(td.tariffConf.changePolicy)); + IBPP::Timestamp policyTimeout; + time_t2ts(td.tariffConf.changePolicyTimeout, &policyTimeout); + st->Set(7, policyTimeout); + num += 2; + } + st->Set(num, id); st->Execute(); st->Close(); @@ -281,7 +295,10 @@ try if (schemaVersion > 0) td->tariffConf.period = TARIFF::StringToPeriod(Get(st, 7)); if (schemaVersion > 1) + { td->tariffConf.changePolicy = TARIFF::StringToChangePolicy(Get(st, 8)); + td->tariffConf.changePolicyTimeout = ts2time_t(Get(st, 9)); + } st->Close(); st->Prepare("select * from tb_tariffs_params where fk_tariff = ?"); st->Set(1, id);