public QueryVyberUtvaryInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600)
{
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UTVAR", TableUtvarInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("firma_id"),
SimpleName.Create("uutvar_id"),
SimpleName.Create("utvnazev"),
SimpleName.Create("poznamka"),
SimpleName.Create("zeme_cislo"),
SimpleName.Create("vyuctgr")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UZIVATEL", TableUzivatelInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("uuzivatel_id"),
SimpleName.Create("uzivjmeno"),
SimpleName.Create("uzivfunkce"),
SimpleName.Create("uplne_jmeno")
));
AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("UTVAR", "UZIVATEL").
AddColumn("firma_id", "firma_id").
AddColumn("uzivatel_id", "uuzivatel_id"));
}
public QueryKrokujPracPocitanyInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600)
{
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PRAC", TablePracVyberAggrInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("firma_id"),
SimpleName.Create("pracovnik_id"),
SimpleName.Create("logicky_zrusen"),
SimpleName.Create("logicky_neuplny"),
SimpleName.Create("pocitane_obdobi"),
SimpleName.Create("osobni_cislo"),
SimpleName.Create("datum_narozeni"),
SimpleName.Create("rodne_cislo"),
SimpleName.Create("prijmeni"),
SimpleName.Create("jmeno"),
SimpleName.Create("titul_pred"),
SimpleName.Create("titul_za"),
AliasName.Create("zar_mesic", "mesic"),
SimpleName.Create("vyuct_cast")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UTVAR", TableUtvarInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("uutvar_id"),
SimpleName.Create("utvnazev"),
SimpleName.Create("vyuctgr"),
SimpleName.Create("zeme_cislo"),
SimpleName.Create("uzivatel_id")
));
AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("PRAC", "UTVAR").
AddColumn("firma_id", "firma_id").
AddColumn("uutvar_id", "uutvar_id"));
}
public QueryVyberPlMediaInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600)
{
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PM", TablePlatebniMediumInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("firma_id"),
SimpleName.Create("pmedium_id"),
SimpleName.Create("info_medium"),
SimpleName.Create("nazev_klienta"),
SimpleName.Create("soubor_start"),
SimpleName.Create("soubor_stop"),
SimpleName.Create("soubor_next"),
SimpleName.Create("datum_predani"),
SimpleName.Create("pol_cis1"),
SimpleName.Create("pol_cis2"),
SimpleName.Create("pol_cis3"),
SimpleName.Create("pol_txt1"),
SimpleName.Create("pol_txt2"),
SimpleName.Create("pol_txt3"),
SimpleName.Create("soub_cis1"),
SimpleName.Create("soub_cis2"),
SimpleName.Create("soub_cis3"),
SimpleName.Create("soub_txt1"),
SimpleName.Create("soub_txt2"),
SimpleName.Create("soub_txt3"),
SimpleName.Create("mena"),
SimpleName.Create("ustav"),
SimpleName.Create("cislo_pobocky"),
SimpleName.Create("prideleny_kod"),
SimpleName.Create("banka_id")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("SLST", TableSestavyLstInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("nazev"),
SimpleName.Create("soubor"),
SimpleName.Create("trideni"),
SimpleName.Create("kod_lst"),
SimpleName.Create("kod_data")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("ULST", TableSestavyUlstInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("uzivatel_id"),
SimpleName.Create("sestavy_id"),
SimpleName.Create("exp_cesta")
));
AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("PM", "SLST").
AddColumn("firma_id", "firma_id").
AddColumn("pmedium_id", "subjekt_id").
AddRightColumn("typ_lst", "=", "3"));
AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("SLST", "ULST").
AddColumn("firma_id", "firma_id").
AddColumn("kod_lst", "kod_lst"));
}
public QueryVyberPracOpravneniInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600)
{
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("DAN_UTVAR", TableDanInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("firma_id"),
SimpleName.Create("pracovnik_id"),
SimpleName.Create("mesic"),
AliasName.Create("informace", "vyuct_cast")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UTVAR", TableUtvarInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("vyuctgr"),
SimpleName.Create("uutvar_id"),
AliasName.Create("utvnazev", "nazev_utvar"),
AliasName.Create("zeme_cislo", "cislo_zeme"),
SimpleName.Create("uzivatel_id"),
SimpleName.Create("personal_id"),
SimpleName.Create("prohlizet_id"),
SimpleName.Create("omezproh_id"),
SimpleName.Create("referzp_id")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UPRES", TableUtvarInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
AliasName.Create("uutvar_id", "uupres_id"),
AliasName.Create("utvnazev", "nazev_upres"),
AliasName.Create("uzivatel_id", "uziv_pres"),
AliasName.Create("personal_id", "pers_pres"),
AliasName.Create("prohlizet_id", "proh_pres"),
AliasName.Create("omezproh_id", "omez_pres"),
AliasName.Create("referzp_id", "refz_pres")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UZIVATEL", TableUzivatelInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("uzivjmeno")
));
AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("DAN_UTVAR", "UTVAR").
AddColumn("firma_id", "firma_id").
AddColumn("sazba", "uutvar_id").
AddLeftColumn("odkud", "=", "0").
AddLeftColumn("kod", "=", "6100").
AddLeftColumn("cislo", "=", "1"));
AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("DAN_UTVAR", "UPRES").
AddColumn("firma_id", "firma_id").
AddColumn("hodnota", "uutvar_id"));
AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("UTVAR", "UZIVATEL").
AddColumn("firma_id", "firma_id").
AddColumn("uzivatel_id", "uuzivatel_id"));
}
public QuerySocialInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600)
{
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PRAC", TableZsestSocialInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("firma_id"),
AliasName.Create("druh_cinnosti", "max_vymzakl"),
AliasName.Create("zap_prijem", "sum_prijem"),
AliasName.Create("pojist_org", "pojsum_org"),
AliasName.Create("pojistne_zam", "pojsum_zam")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PPOM", TableZsestSocialInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("uzivatel_id"),
SimpleName.Create("kod_data"),
SimpleName.Create("pracovnik_id"),
SimpleName.Create("cislo_pp"),
SimpleName.Create("socsprava_id"),
SimpleName.Create("info_org"),
SimpleName.Create("uplne_jmeno"),
SimpleName.Create("rodne_cislo"),
SimpleName.Create("ucast_poj"),
SimpleName.Create("ppom_stav"),
SimpleName.Create("koef_poj"),
SimpleName.Create("druh_cinnosti"),
SimpleName.Create("zap_prijem"),
SimpleName.Create("pojist_org"),
SimpleName.Create("pojistne_zam"),
SimpleName.Create("vyl_doby"),
SimpleName.Create("absence"),
SimpleName.Create("nemoc_dny"),
SimpleName.Create("nemoc_kc"),
SimpleName.Create("osetrovani_dny"),
SimpleName.Create("osetrovani_kc"),
SimpleName.Create("materstvi_kc"),
SimpleName.Create("materstvi_n"),
SimpleName.Create("vyrovnani_n"),
SimpleName.Create("vyrovnani_kc"),
SimpleName.Create("davka_e_kod"),
SimpleName.Create("davka_e_kc"),
SimpleName.Create("davka_f_kod"),
SimpleName.Create("davka_f_kc")
));
AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("PRAC", "PPOM").
AddColumn("firma_id", "firma_id").
AddColumn("uzivatel_id", "uzivatel_id").
AddColumn("kod_data", "kod_data").
AddColumn("pracovnik_id", "pracovnik_id").
AddColumn("socsprava_id", "socsprava_id").
AddLeftColumn("cislo_pp", "=", "0").
AddRightColumn("cislo_pp", "<>", "0"));
}
public QueryVyberUcetPrPolozkyInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600)
{
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UCPREDP", TableUcetniPredpisyInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("firma_id"),
AliasName.Create("ppredpis_id", "predpis_id"),
SimpleName.Create("predpis_uckod"),
SimpleName.Create("predpis_nazev"),
SimpleName.Create("predpis_druh")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UCPOLOZ", TableUcetniPolozkyInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("cislo"),
SimpleName.Create("poloz_nazev"),
SimpleName.Create("poloz_druh"),
SimpleName.Create("poloz_skup"),
SimpleName.Create("poloz_synt"),
SimpleName.Create("poloz_anal"),
SimpleName.Create("poloz_text1"),
SimpleName.Create("poloz_inf1"),
SimpleName.Create("poloz_delka1"),
SimpleName.Create("poloz_fmt1"),
SimpleName.Create("poloz_text2"),
SimpleName.Create("poloz_inf2"),
SimpleName.Create("poloz_delka2"),
SimpleName.Create("poloz_fmt2"),
SimpleName.Create("poloz_text3"),
SimpleName.Create("poloz_inf3"),
SimpleName.Create("poloz_delka3"),
SimpleName.Create("poloz_fmt3"),
SimpleName.Create("poloz_text4"),
SimpleName.Create("poloz_inf4"),
SimpleName.Create("poloz_delka4"),
SimpleName.Create("poloz_fmt4"),
SimpleName.Create("poloz_text5"),
SimpleName.Create("poloz_inf5"),
SimpleName.Create("poloz_delka5"),
SimpleName.Create("poloz_fmt5")
));
AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("UCPREDP", "UCPOLOZ").
AddColumn("firma_id", "firma_id").
AddColumn("ppredpis_id", "predpis_id"));
}
public QueryVyberPracZarazeniInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600)
{
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("MDAN_UTVAR", TableDanInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("firma_id"),
SimpleName.Create("pracovnik_id"),
SimpleName.Create("mesic"),
AliasName.Create("sazba", "cislo_utvar"),
AliasName.Create("pocjed", "cislo_zdrpoj")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("MDAN_STRCZ", TableDanInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("cislo_zdroj"),
SimpleName.Create("cislo_stred"),
SimpleName.Create("cislo_cinnost"),
SimpleName.Create("cislo_zakazka")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("MUTVAR", TableUtvarInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
AliasName.Create("utvnazev", "nazev_utvar"),
AliasName.Create("zeme_cislo", "cislo_zeme")
));
AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("MDAN_UTVAR", "MDAN_STRCZ").
AddColumn("firma_id", "firma_id").
AddColumn("pracovnik_id", "pracovnik_id").
AddColumn("mesic", "mesic").
AddRightColumn("odkud", "=", "0").
AddRightColumn("kod", "=", "6100").
AddRightColumn("cislo", "=", "1").
AddLeftColumn("odkud", "=", "0").
AddLeftColumn("kod", "=", "6101").
AddLeftColumn("cislo", "=", "1"));
AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("MDAN_UTVAR", "MUTVAR").
AddColumn("firma_id", "firma_id").
AddColumn("sazba", "uutvar_id"));
}
public QueryVyplListkySortInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600)
{
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("ZSEST_VYPL_LISTKY", TableZsestVyplListkyInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("firma_id"),
SimpleName.Create("uzivatel_id"),
SimpleName.Create("pracovnik_id"),
SimpleName.Create("vlist_info"),
SimpleName.Create("radek"),
SimpleName.Create("typ"),
SimpleName.Create("radtext"),
SimpleName.Create("engtext")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("LISTKYP", TableZsestVyplListkyInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
AliasName.Create("typ", "typ_pr"),
AliasName.Create("radtext", "text_pr")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("LISTKYU", TableZsestVyplListkyInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
AliasName.Create("typ", "typ_ut"),
AliasName.Create("radtext", "text_ut")
));
AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("ZSEST_VYPL_LISTKY", "LISTKYP").
AddColumn("firma_id", "firma_id").
AddColumn("uzivatel_id", "uzivatel_id").
AddColumn("pracovnik_id", "pracovnik_id").
AddRightColumn("typ", "=", "2"));
AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("ZSEST_VYPL_LISTKY", "LISTKYU").
AddColumn("firma_id", "firma_id").
AddColumn("uzivatel_id", "uzivatel_id").
AddColumn("pracovnik_id", "pracovnik_id").
AddRightColumn("typ", "=", "1"));
}
public QueryVyberReldp09DavkaInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600)
{
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UD", TableUzivReldpDavkaInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("firma_id"),
AliasName.Create("ddavka_reldp_id", "davka_reldp_id"),
SimpleName.Create("uzivatel_id"),
AliasName.Create("vydano_dat", "vydano_dat", "MAX({0})"),
AliasName.Create("info_davka", "info_davka", "MAX({0})")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PP", TablePracReldp09DataPracInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
AliasName.Create("eldp_rok", "eldp_rok", "MAX({0})")
));
AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("UD", "PP").
AddColumn("firma_id", "firma_id").
AddColumn("ddavka_reldp_id", "davka_reldp_id").
AddColumn("uzivatel_id", "uzivatel_id"));
AddClause("GROUP BY UD.firma_id, UD.ddavka_reldp_id, UD.uzivatel_id");
}
public QueryVyberReldp09DataInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600)
{
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UD", TableUzivReldpDavkaInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("firma_id"),
SimpleName.Create("ddavka_reldp_id"),
SimpleName.Create("uzivatel_id"),
SimpleName.Create("vydano_dat"),
SimpleName.Create("info_davka")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("EPRAC", TablePracReldp09DataPracInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("pracovnik_id"),
SimpleName.Create("sprava_id"),
SimpleName.Create("eldp_rok"),
SimpleName.Create("eldp_oprava"),
SimpleName.Create("prijmeni"),
SimpleName.Create("jmeno"),
SimpleName.Create("titul"),
SimpleName.Create("rodne_prijmeni"),
SimpleName.Create("datum_narozeni"),
SimpleName.Create("rodne_cislo"),
SimpleName.Create("ulice"),
SimpleName.Create("cislo_domu"),
SimpleName.Create("obec"),
SimpleName.Create("posta"),
SimpleName.Create("psc"),
SimpleName.Create("stat"),
SimpleName.Create("misto_narozeni")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("EPOJ", TablePracReldp09DataPojInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("pomer_id"),
SimpleName.Create("eldp_typ"),
SimpleName.Create("stranka"),
SimpleName.Create("radek"),
SimpleName.Create("kod"),
SimpleName.Create("maly_rozsah"),
SimpleName.Create("cinn_od"),
SimpleName.Create("cinn_do"),
SimpleName.Create("dny"),
SimpleName.Create("vyd_cinn_od"),
SimpleName.Create("s1"),
SimpleName.Create("s2"),
SimpleName.Create("s3"),
SimpleName.Create("s4"),
SimpleName.Create("s5"),
SimpleName.Create("s6"),
SimpleName.Create("s7"),
SimpleName.Create("s8"),
SimpleName.Create("s9"),
SimpleName.Create("s10"),
SimpleName.Create("s11"),
SimpleName.Create("s12"),
SimpleName.Create("s1_12"),
SimpleName.Create("vylouc_doby1"),
SimpleName.Create("vymer_zaklad1"),
SimpleName.Create("doby_odecet1"),
SimpleName.Create("vylouc_doby2"),
SimpleName.Create("vymer_zaklad2"),
SimpleName.Create("doby_odecet2"),
SimpleName.Create("vylouc_doby3"),
SimpleName.Create("vymer_zaklad3"),
SimpleName.Create("doby_odecet3"),
SimpleName.Create("vylouc_doby4"),
SimpleName.Create("vymer_zaklad4"),
SimpleName.Create("doby_odecet4"),
SimpleName.Create("vylouc_doby5"),
SimpleName.Create("vymer_zaklad5"),
SimpleName.Create("doby_odecet5"),
SimpleName.Create("vylouc_doby6"),
SimpleName.Create("vymer_zaklad6"),
SimpleName.Create("doby_odecet6"),
SimpleName.Create("vylouc_doby7"),
SimpleName.Create("vymer_zaklad7"),
SimpleName.Create("doby_odecet7"),
SimpleName.Create("vylouc_doby8"),
SimpleName.Create("vymer_zaklad8"),
SimpleName.Create("doby_odecet8"),
SimpleName.Create("vylouc_doby9"),
SimpleName.Create("vymer_zaklad9"),
SimpleName.Create("doby_odecet9"),
SimpleName.Create("vylouc_doby10"),
SimpleName.Create("vymer_zaklad10"),
SimpleName.Create("doby_odecet10"),
SimpleName.Create("vylouc_doby11"),
SimpleName.Create("vymer_zaklad11"),
SimpleName.Create("doby_odecet11"),
SimpleName.Create("vylouc_doby12"),
SimpleName.Create("vymer_zaklad12"),
SimpleName.Create("doby_odecet12")
));
AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("UD", "EPRAC").
AddColumn("firma_id", "firma_id").
AddColumn("ddavka_reldp_id", "davka_reldp_id").
AddColumn("uzivatel_id", "uzivatel_id"));
AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("EPRAC", "EPOJ").
AddColumn("firma_id", "firma_id").
AddColumn("davka_reldp_id", "davka_reldp_id").
AddColumn("uzivatel_id", "uzivatel_id").
AddColumn("pracovnik_id", "pracovnik_id").
AddColumn("sprava_id", "sprava_id"));
}
public QueryVyberReldpDataInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600)
{
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UD", TableUzivReldpDavkaInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("firma_id"),
SimpleName.Create("uzivatel_id"),
SimpleName.Create("vydano_dat"),
SimpleName.Create("neprijata"),
SimpleName.Create("info_davka")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PL", TablePracReldpListekInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("pracovnik_id"),
SimpleName.Create("davka_reldp_id"),
SimpleName.Create("eldppgn"),
SimpleName.Create("logicky_zrusen"),
SimpleName.Create("info_eldp"),
SimpleName.Create("eldprok"),
SimpleName.Create("datum_narozeni"),
SimpleName.Create("rodne_cislo"),
SimpleName.Create("rodne_prijmeni"),
SimpleName.Create("uplne_jmeno"),
SimpleName.Create("misto_narozeni"),
SimpleName.Create("posledni_prijmeni"),
SimpleName.Create("adresa1_3"),
SimpleName.Create("eldptyp"),
SimpleName.Create("zacatek"),
SimpleName.Create("eldpvydzedne"),
SimpleName.Create("eldpoprzedne")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PD", TablePracReldpDataInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("listek_reldp_id"),
SimpleName.Create("pomer_id"),
SimpleName.Create("eldpkod"),
SimpleName.Create("eldpod"),
SimpleName.Create("eldpdo"),
SimpleName.Create("eldppoj"),
SimpleName.Create("eldpdnym01"),
SimpleName.Create("eldpdnym02"),
SimpleName.Create("eldpdnym03"),
SimpleName.Create("eldpdnym04"),
SimpleName.Create("eldpdnym05"),
SimpleName.Create("eldpdnym06"),
SimpleName.Create("eldpdnym07"),
SimpleName.Create("eldpdnym08"),
SimpleName.Create("eldpdnym09"),
SimpleName.Create("eldpdnym10"),
SimpleName.Create("eldpdnym11"),
SimpleName.Create("eldpdnym12"),
SimpleName.Create("zaklvym01"),
SimpleName.Create("zaklvym02"),
SimpleName.Create("zaklvym03"),
SimpleName.Create("zaklvym04"),
SimpleName.Create("zaklvym05"),
SimpleName.Create("zaklvym06"),
SimpleName.Create("zaklvym07"),
SimpleName.Create("zaklvym08"),
SimpleName.Create("zaklvym09"),
SimpleName.Create("zaklvym10"),
SimpleName.Create("zaklvym11"),
SimpleName.Create("zaklvym12"),
SimpleName.Create("eldpvcm")
));
AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("UD", "PL").
AddColumn("firma_id", "firma_id").
AddColumn("ddavka_reldp_id", "davka_reldp_id"));
AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("PL", "PD").
AddColumn("firma_id", "firma_id").
AddColumn("llistek_reldp_id", "listek_reldp_id").
AddColumn("eldpPgn", "eldpPgn"));
}
public QueryVyberPracPocitanyInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600)
{
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("VPFZ", TablePracVyberAggrInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("firma_id"),
SimpleName.Create("pracovnik_id"),
AliasName.Create("zar_mesic", "mesic"),
SimpleName.Create("zar_mesic"),
SimpleName.Create("opr_mesic"),
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("cislo_pp"),
SimpleName.Create("pompopis"),
SimpleName.Create("funkce"),
SimpleName.Create("praczac"),
SimpleName.Create("prackon"),
SimpleName.Create("druh"),
SimpleName.Create("druh07"),
SimpleName.Create("datum_narozeni"),
SimpleName.Create("pohlavi"),
SimpleName.Create("ppomer_cislo"),
SimpleName.Create("kzam"),
SimpleName.Create("platova_trida"),
SimpleName.Create("platovy_stupen"),
SimpleName.Create("spraxe_roku"),
SimpleName.Create("praxe_dnu"),
SimpleName.Create("cislo_zdrpoj"),
SimpleName.Create("cislo_zdroj"),
SimpleName.Create("cislo_stred"),
SimpleName.Create("cislo_cinnost"),
SimpleName.Create("cislo_zakazka"),
SimpleName.Create("ppomer_zdroj"),
SimpleName.Create("ppomer_stred"),
SimpleName.Create("ppomer_cinnost"),
SimpleName.Create("ppomer_zakazka"),
SimpleName.Create("cislo_utvar"),
SimpleName.Create("uutvar_id"),
SimpleName.Create("vyuct_cast"),
SimpleName.Create("uupres_id")));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UTVAR", TableUtvarInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
AliasName.Create("utvnazev", "nazev_utvar"),
AliasName.Create("zeme_cislo", "cislo_zeme"),
SimpleName.Create("uzivatel_id"),
SimpleName.Create("personal_id"),
SimpleName.Create("prohlizet_id"),
SimpleName.Create("omezproh_id"),
SimpleName.Create("referzp_id")));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UPRES", TableUtvarInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
AliasName.Create("utvnazev", "nazev_upres"),
AliasName.Create("uzivatel_id", "uziv_pres"),
AliasName.Create("personal_id", "pers_pres"),
AliasName.Create("prohlizet_id", "proh_pres"),
AliasName.Create("omezproh_id", "omez_pres"),
AliasName.Create("referzp_id", "refz_pres")));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UZIVATEL", TableUzivatelInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("uzivjmeno")));
AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("VPFZ", "UTVAR").
AddColumn("firma_id", "firma_id").
AddColumn("cislo_utvar", "uutvar_id"));
AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("VPFZ", "UPRES").
AddColumn("firma_id", "firma_id").
AddColumn("uupres_id", "uutvar_id"));
AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("UTVAR", "UZIVATEL").
AddColumn("firma_id", "firma_id").
AddColumn("uzivatel_id", "uuzivatel_id"));
}
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"));
}
public QueryVyberSestavyInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600)
{
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("SLST", TableSestavyLstInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("firma_id"),
SimpleName.Create("kod_lst"),
SimpleName.Create("kod_data"),
SimpleName.Create("druh"),
SimpleName.Create("typ_lst"),
SimpleName.Create("trideni"),
SimpleName.Create("nazev"),
SimpleName.Create("soubor"),
SimpleName.Create("skupina"),
SimpleName.Create("subjekt_id"),
SimpleName.Create("informace")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UDATA", TableSestavyUdataInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("vytvor_vyuc"),
SimpleName.Create("vyuct_dat"),
SimpleName.Create("mesic_od"),
SimpleName.Create("mesic_do"),
SimpleName.Create("rok"),
SimpleName.Create("vytvor_txt"),
SimpleName.Create("vytvor_dat")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("ULST", TableSestavyUlstInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("tisknout"),
SimpleName.Create("sestavy_id"),
SimpleName.Create("pg_margins"),
SimpleName.Create("papir"),
SimpleName.Create("tridit"),
SimpleName.Create("exp_cesta"),
SimpleName.Create("lst_param"),
SimpleName.Create("txt_param"),
SimpleName.Create("msg_param"),
SimpleName.Create("filtr_zobr")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UZ", TableUzivatelInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("uuzivatel_id"),
AliasName.Create("sestavy_id", "usestavy_id")
));
AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("SLST", "UDATA").
AddColumn("firma_id", "firma_id").
AddColumn("kod_data", "kod_data"));
AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("SLST", "ULST").
AddColumn("firma_id", "firma_id").
AddColumn("kod_lst", "kod_lst").
AddRightColumn("uzivatel_id", "=", "UDATA.uzivatel_id"));
AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("ULST", "UZ").
AddColumn("firma_id", "firma_id").
AddColumn("uzivatel_id", "uuzivatel_id"));
}
public QueryVyberSbMediaInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600)
{
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("SM", TableSberneMediumInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("firma_id"),
SimpleName.Create("smedium_id"),
SimpleName.Create("info_medium"),
SimpleName.Create("nazev_klienta"),
SimpleName.Create("soubor_start"),
SimpleName.Create("soubor_stop"),
SimpleName.Create("soubor_next"),
SimpleName.Create("soub_cis1"),
SimpleName.Create("soub_cis2"),
SimpleName.Create("soub_cis3"),
SimpleName.Create("soub_txt1"),
SimpleName.Create("soub_txt2"),
SimpleName.Create("soub_txt3"),
SimpleName.Create("datum_predani"),
SimpleName.Create("datum_transakce"),
SimpleName.Create("datum_splatnosti"),
SimpleName.Create("datum_prevodu"),
SimpleName.Create("datum_popprev"),
SimpleName.Create("bezny_bkspoj_id"),
SimpleName.Create("debet_bkspoj_id"),
SimpleName.Create("cpopl_bkspoj_id"),
SimpleName.Create("dpopl_bkspoj_id"),
SimpleName.Create("par_kod_obr11"),
SimpleName.Create("par_kod_obr32"),
SimpleName.Create("crc"),
SimpleName.Create("prior_prevodu"),
SimpleName.Create("prior_popprev"),
SimpleName.Create("cislo_klienta"),
SimpleName.Create("telefon"),
SimpleName.Create("ucet_dal"),
SimpleName.Create("ucet_md"),
SimpleName.Create("ucetni_zdr"),
SimpleName.Create("ucetni_str"),
SimpleName.Create("ucetni_zak"),
SimpleName.Create("ucetni_cin"),
SimpleName.Create("prijem_id")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("SLST", TableSestavyLstInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("nazev"),
SimpleName.Create("soubor"),
SimpleName.Create("trideni"),
SimpleName.Create("kod_lst"),
SimpleName.Create("kod_data")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("ULST", TableSestavyUlstInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("uzivatel_id"),
SimpleName.Create("sestavy_id"),
SimpleName.Create("exp_cesta")
));
AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("SM", "SLST").
AddColumn("firma_id", "firma_id").
AddColumn("smedium_id", "subjekt_id").
AddRightColumn("typ_lst", "=", "2"));
AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("SLST", "ULST").
AddColumn("firma_id", "firma_id").
AddColumn("kod_lst", "kod_lst"));
}
public QueryVyberUcMediaInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600)
{
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UM", TableUcetniMediumInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("firma_id"),
SimpleName.Create("umedium_id"),
SimpleName.Create("info_medium"),
SimpleName.Create("doklad_druh"),
SimpleName.Create("soub_cis1"),
SimpleName.Create("soub_cis2"),
SimpleName.Create("soub_cis3"),
SimpleName.Create("soub_txt1"),
SimpleName.Create("soub_txt2"),
SimpleName.Create("soub_txt3"),
SimpleName.Create("doklad_cis1"),
SimpleName.Create("doklad_cis2"),
SimpleName.Create("doklad_cis3"),
SimpleName.Create("doklad_txt1"),
SimpleName.Create("doklad_txt2"),
SimpleName.Create("doklad_txt3"),
SimpleName.Create("ucto_klicmd"),
SimpleName.Create("ucto_klicdal"),
SimpleName.Create("znam_plus"),
SimpleName.Create("znam_minus"),
SimpleName.Create("domaci_mena"),
SimpleName.Create("spoj_ucet_md"),
SimpleName.Create("spoj_ucet_dal"),
SimpleName.Create("bezny_ucet_md"),
SimpleName.Create("bezny_ucet_dal"),
SimpleName.Create("korekce_zdr"),
SimpleName.Create("korekce_str"),
SimpleName.Create("korekce_zak"),
SimpleName.Create("korekce_cin")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("SLST", TableSestavyLstInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("nazev"),
SimpleName.Create("soubor"),
SimpleName.Create("trideni"),
SimpleName.Create("kod_lst"),
SimpleName.Create("kod_data")
));
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("ULST", TableSestavyUlstInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("uzivatel_id"),
SimpleName.Create("sestavy_id"),
SimpleName.Create("exp_cesta")
));
AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("UM", "SLST").
AddColumn("firma_id", "firma_id").
AddColumn("umedium_id", "subjekt_id").
AddRightColumn("typ_lst", "=", "1"));
AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("SLST", "ULST").
AddColumn("firma_id", "firma_id").
AddColumn("kod_lst", "kod_lst"));
}
