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 QueryCelkExtMListInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600)
{
AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("EXTML", TableZsestExtMzdlistInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddColumns(
SimpleName.Create("firma_id"),
SimpleName.Create("kod_data"),
SimpleName.Create("uzivatel_id"),
SimpleName.Create("pracovnik_id"),
SimpleName.Create("pomer_id"),
SimpleName.Create("mesic_opr"),
SimpleName.Create("kod"),
SimpleName.Create("hodnota_numb", "SUM({0})")));
AddFiltr(QueryWhereDefInfo.GetQueryWhereDefInfo("EXTML", TableZsestExtMzdlistInfo.GetDictValue(lpszOwnerName, lpszUsersName)).
AddConstraints(
QueryFilterDefInfo.Create("mesic", "<>", "0"),
QueryFilterDefInfo.Create("poradi", "=", "0")));
AddClause("GROUP BY firma_id, kod_data, uzivatel_id, pracovnik_id, pomer_id, mesic_opr, kod");
}
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 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")
));
}