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 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 QuerySumaDanInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("DAN", TableDanInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("mesic"), SimpleName.Create("odkud"), SimpleName.Create("kod"), AliasName.Create("hodnota", "hodnota", "SUM({0})"), AliasName.Create("pocjed", "pocjed", "SUM({0})"), AliasName.Create("pocdal", "pocdal", "SUM({0})"), AliasName.Create("sazba", "sazba", "SUM({0})") )); AddClause("GROUP BY firma_id, mesic, odkud, kod"); }
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 QueryCelkVyuctFinInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("VFIN", TableZsestPrehvyuctfinInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("kod_data"), SimpleName.Create("uzivatel_id"), SimpleName.Create("kod"), AliasName.Create("hodnota_numb", "hodnota_numb", "SUM({0})") )); AddFiltr(QueryWhereDefInfo.GetQueryWhereDefInfo("VFIN", TableZsestPrehvyuctfinInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddConstraints( QueryFilterDefInfo.Create("mesic", "<>", "0"), QueryFilterDefInfo.Create("poradi", "=", "0") )); AddClause("GROUP BY firma_id, kod_data, uzivatel_id, kod"); }
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 QueryVyberPPomZarazeniInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("MMZDA_STRCZ", TableMzdaInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("pracovnik_id"), SimpleName.Create("cislo_pp"), SimpleName.Create("mesic"), AliasName.Create("cislo_zdroj", "ppomer_zdroj"), AliasName.Create("cislo_stred", "ppomer_stred"), AliasName.Create("cislo_cinnost", "ppomer_cinnost"), AliasName.Create("cislo_zakazka", "ppomer_zakazka") )); AddFiltr(QueryWhereDefInfo.GetQueryWhereDefInfo("MMZDA_STRCZ", TableZsestExtMzdlistInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddConstraints( QueryFilterDefInfo.Create("odkud", "=", "0"), QueryFilterDefInfo.Create("kod", "=", "6000"), QueryFilterDefInfo.Create("cislo", "=", "1") )); }
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 QueryVyberPracovnikyInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("VPFZ", QueryVyberPracovnikyFiltrZPInfo.GetDictValue(lpszOwnerName, lpszUsersName).GetTableDef()). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("pracovnik_id"), AliasName.Create("zar_mesic", "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("uzivjmeno"), SimpleName.Create("nazev_utvar"), SimpleName.Create("cislo_zeme"), 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("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"), SimpleName.Create("cislo_utvar"), 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") )); AddFiltr(QueryWhereDefInfo.GetQueryWhereDefInfo("VPFZ", QueryVyberPracovnikyFiltrZPInfo.GetDictValue(lpszOwnerName, lpszUsersName).GetTableDef()). AddConstraints( QueryFilterDefInfo.Create("zar_mesic", "=", "opr_mesic") )); }
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 QueryVyberPracovnikyFiltrXOInfo(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", "zar_mesic"), AliasName.Create("mesic", "opr_mesic"), SimpleName.Create("uzivjmeno"), SimpleName.Create("nazev_utvar"), SimpleName.Create("cislo_zeme"), 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") )); 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")); }
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")); }