public override IDictionary <string, QueryDefInfo> CreateQueryDictionary()
{
return(new Dictionary <string, QueryDefInfo>()
{
{ QueryKrokujPracPocitanyInfo.GetNameKey(), QueryKrokujPracPocitanyInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryKrokujPracovnikyInfo.GetNameKey(), QueryKrokujPracovnikyInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyberPracZarazeniInfo.GetNameKey(), QueryVyberPracZarazeniInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyberPPomZarazeniInfo.GetNameKey(), QueryVyberPPomZarazeniInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyberPracOpravneniInfo.GetNameKey(), QueryVyberPracOpravneniInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyberPracovnikyFiltrXOInfo.GetNameKey(), QueryVyberPracovnikyFiltrXOInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyberPracovnikyFiltrXPInfo.GetNameKey(), QueryVyberPracovnikyFiltrXPInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyberPracovnikyFiltrXZInfo.GetNameKey(), QueryVyberPracovnikyFiltrXZInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyberPracovnikyFiltrZPInfo.GetNameKey(), QueryVyberPracovnikyFiltrZPInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyberPracPocitanyInfo.GetNameKey(), QueryVyberPracPocitanyInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyberPracovnikyInfo.GetNameKey(), QueryVyberPracovnikyInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyberUtvaryInfo.GetNameKey(), QueryVyberUtvaryInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyberSestavyInfo.GetNameKey(), QueryVyberSestavyInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyberSbMediaInfo.GetNameKey(), QueryVyberSbMediaInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyberPlMediaInfo.GetNameKey(), QueryVyberPlMediaInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyberUcMediaInfo.GetNameKey(), QueryVyberUcMediaInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyberUcetPrPolozkyInfo.GetNameKey(), QueryVyberUcetPrPolozkyInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryHodnExtMListInfo.GetNameKey(), QueryHodnExtMListInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryCelkExtMListInfo.GetNameKey(), QueryCelkExtMListInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryHodnVyuctFinInfo.GetNameKey(), QueryHodnVyuctFinInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryCelkVyuctFinInfo.GetNameKey(), QueryCelkVyuctFinInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QuerySocialInfo.GetNameKey(), QuerySocialInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QuerySumaDanInfo.GetNameKey(), QuerySumaDanInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyplListkySortInfo.GetNameKey(), QueryVyplListkySortInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryMzvIIsspPredpisyInfo.GetNameKey(), QueryMzvIIsspPredpisyInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyberReldp09DavkaInfo.GetNameKey(), QueryVyberReldp09DavkaInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyberReldp09DataInfo.GetNameKey(), QueryVyberReldp09DataInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyberReldpDavkaInfo.GetNameKey(), QueryVyberReldpDavkaInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
{ QueryVyberReldpDataInfo.GetNameKey(), QueryVyberReldpDataInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
});
}
public QueryVyberPracovnikyFiltrZPInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600)
{
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PRAC", TablePracInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("firma_id"),
AliasName.Create("ppracovnik_id", "pracovnik_id"),
SimpleName.Create("logicky_zrusen"),
SimpleName.Create("logicky_neuplny"),
SimpleName.Create("osobni_cislo"),
SimpleName.Create("rodne_cislo"),
SimpleName.Create("nema_rodcis"),
SimpleName.Create("prijmeni"),
SimpleName.Create("jmeno"),
SimpleName.Create("titul_pred"),
SimpleName.Create("titul_za"),
SimpleName.Create("datum_narozeni"),
SimpleName.Create("pohlavi")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PPOMER", TablePpomerInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("cislo_pp"),
SimpleName.Create("pompopis"),
SimpleName.Create("funkce"),
SimpleName.Create("praczac"),
SimpleName.Create("prackon"),
SimpleName.Create("druh"),
SimpleName.Create("druh07"),
SimpleName.Create("ppomer_cislo"),
SimpleName.Create("kzam"),
SimpleName.Create("platova_trida"),
SimpleName.Create("platovy_stupen"),
SimpleName.Create("spraxe_roku"),
SimpleName.Create("praxe_dnu")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("OPR", QueryVyberPracOpravneniInfo.GetDictValue(lpszOwnerName, lpszUsersName).GetTableDef()).
AddColumns(
AliasName.Create("mesic", "opr_mesic"),
SimpleName.Create("uzivjmeno"),
SimpleName.Create("uzivatel_id"),
SimpleName.Create("personal_id"),
SimpleName.Create("prohlizet_id"),
SimpleName.Create("omezproh_id"),
SimpleName.Create("referzp_id"),
SimpleName.Create("uziv_pres"),
SimpleName.Create("pers_pres"),
SimpleName.Create("proh_pres"),
SimpleName.Create("omez_pres"),
SimpleName.Create("refz_pres"),
SimpleName.Create("uutvar_id"),
SimpleName.Create("vyuctgr"),
SimpleName.Create("vyuct_cast"),
SimpleName.Create("uupres_id"),
SimpleName.Create("nazev_upres")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("ZAR", QueryVyberPracZarazeniInfo.GetDictValue(lpszOwnerName, lpszUsersName).GetTableDef()).
AddColumns(
AliasName.Create("mesic", "zar_mesic"),
SimpleName.Create("nazev_utvar"),
SimpleName.Create("cislo_zeme"),
SimpleName.Create("cislo_utvar"),
SimpleName.Create("cislo_zdrpoj"),
SimpleName.Create("cislo_zdroj"),
SimpleName.Create("cislo_stred"),
SimpleName.Create("cislo_cinnost"),
SimpleName.Create("cislo_zakazka")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PPZ", QueryVyberPPomZarazeniInfo.GetDictValue(lpszOwnerName, lpszUsersName).GetTableDef()).
AddColumns(
SimpleName.Create("ppomer_zdroj"),
SimpleName.Create("ppomer_stred"),
SimpleName.Create("ppomer_cinnost"),
SimpleName.Create("ppomer_zakazka")
));
AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("PRAC", "PPOMER").
AddColumn("firma_id", "firma_id").
AddColumn("ppracovnik_id", "pracovnik_id"));
AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("PPOMER", "OPR").
AddColumn("firma_id", "firma_id").
AddColumn("pracovnik_id", "pracovnik_id"));
AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("PPOMER", "ZAR").
AddColumn("firma_id", "firma_id").
AddColumn("pracovnik_id", "pracovnik_id"));
AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("PPOMER", "PPZ").
AddColumn("firma_id", "firma_id").
AddColumn("pracovnik_id", "pracovnik_id").
AddColumn("cislo_pp", "cislo_pp").
AddRightColumn("mesic", "=", "ZAR.mesic"));
}
