{"id":4856,"date":"2021-05-27T12:48:00","date_gmt":"2021-05-27T12:48:00","guid":{"rendered":"https:\/\/podpora.nuggetsw.cz\/?post_type=lsvr_kba&#038;p=4856"},"modified":"2024-02-15T12:39:02","modified_gmt":"2024-02-15T12:39:02","slug":"query-a-mzdova-statistika-ve-spolecnem-vystupu-pouze-v-modulu-mzdy","status":"publish","type":"lsvr_kba","link":"https:\/\/podpora.nuggetsw.cz\/index.php\/knowledge-base\/query-a-mzdova-statistika-ve-spolecnem-vystupu-pouze-v-modulu-mzdy\/","title":{"rendered":"Sestavy: Query a mzdov\u00e1 statistika ve spole\u010dn\u00e9m v\u00fdstupu"},"content":{"rendered":"\n<h6 class=\"has-text-align-center wp-block-heading\">Query a mzdovou statistiku m\u016f\u017eete propojit pouze v modulu Mzdy.<\/h6>\n\n\n\n<p><strong>Pot\u0159ebujete vytvo\u0159it u\u017eivatelskou sestavu, kde krom\u011b \u00fadaj\u016f z kmenov\u00e9ho souboru tak\u00e9 pot\u0159ebujete \u00fadaje, kter\u00e9 jste si vytvo\u0159ili ve mzdov\u00e9 statistice d\u0159\u00edve.&nbsp;<\/strong><\/p>\n\n\n\n<p>Ji\u017e um\u00edte vytvo\u0159it Query (n\u00e1vod <a rel=\"noreferrer noopener\" href=\"https:\/\/podpora.nuggetsw.cz\/index.php\/knowledge-base\/query\/\" target=\"_blank\">zde<\/a>) a mzdovou statistiku (n\u00e1vod <a rel=\"noreferrer noopener\" href=\"https:\/\/podpora.nuggetsw.cz\/index.php\/knowledge-base\/mzdova-statistika\/\" target=\"_blank\">zde<\/a>) a nyn\u00ed se nau\u010d\u00edme propojit oboje do jednoho v\u00fdstupu (stejn\u00fd n\u00e1vod najdete i v n\u00e1vodu pro Query)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Postup<\/h3>\n\n\n\n<p><strong>Vytvo\u0159\u00edme si mzdovou statistiku<\/strong> (nap\u0159. ve funkci Mzdy 2-7-3), v na\u0161em p\u0159\u00edpad\u011b statistiku s n\u00e1zvem ZAD_01<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"691\" height=\"591\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_01.jpg\" alt=\"\" class=\"wp-image-4857\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_01.jpg 691w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_01-300x257.jpg 300w\" sizes=\"auto, (max-width: 691px) 100vw, 691px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>v t\u00e9to statistice zad\u00e1me n\u00e1sleduj\u00edc\u00ed mzdov\u00e9 slo\u017eky, kter\u00e9 se budou nas\u010d\u00edt\u00e1vat do jedn\u00e9 bu\u0148ky): <\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"507\" height=\"198\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_02.jpg\" alt=\"\" class=\"wp-image-4858\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_02.jpg 507w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_02-300x117.jpg 300w\" sizes=\"auto, (max-width: 507px) 100vw, 507px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>a tak\u00e9 jsme si ka\u017edou polo\u017eku pojmenovali pro \u00fadaj Query:<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"693\" height=\"594\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_03.jpg\" alt=\"\" class=\"wp-image-4859\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_03.jpg 693w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_03-300x257.jpg 300w\" sizes=\"auto, (max-width: 693px) 100vw, 693px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>statistiku m\u00e1me ulo\u017eenou.<\/li><\/ul>\n\n\n\n<p><strong>P\u0159ejdeme do quer\u016f <\/strong>(funkce Mzdy 12-4)<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>nejprve najdete \u00fadaje z query (tzn. \u00fadaje vlevo p\u0159et\u00e1hnete doprava a ve sloupci Text do hlavi\u010dky p\u0159ejmenujete \u00fadaj):<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"930\" height=\"741\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_04-1.jpg\" alt=\"\" class=\"wp-image-4861\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_04-1.jpg 930w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_04-1-300x239.jpg 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_04-1-768x612.jpg 768w\" sizes=\"auto, (max-width: 930px) 100vw, 930px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>pot\u00e9 p\u0159id\u00e1te \u00fadaje ze mzdov\u00e9 statistiky: otev\u0159ete tla\u010d\u00edtko Soubor vlevo dole a zaklikn\u011bte \u00fadaj LS722 \u2013 Mzdov\u00e1 statistika a p\u0159es \u0161ipku v rozev\u00edrac\u00edm menu najdeme n\u00e1zev mzdov\u00e9 statistiky (v na\u0161em p\u0159\u00edpad\u011b ZAD_01) <\/li><li>pokud chcete ve v\u00fdstupu naj\u00edt v\u0161echny zam\u011bstnance bez ohledu na to, jestli maj\u00ed n\u011bjak\u00fd \u00fadaj ve statistice, zaklin\u011bte <img loading=\"lazy\" decoding=\"async\" width=\"246\" height=\"24\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query3.jpg\" alt=\"\"><\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>pokud byste \u00fadaj V\u017edy generovat data z kmenov\u00e9ho souboru neza\u0161krtli a v dan\u00e9 statistice by nap\u0159. byl \u00fadaj, kter\u00fd m\u00e1 jen \u010d\u00e1st zam\u011bstnanc\u016f, ve v\u00fdstupu by se objevili pouze ti zam\u011bstnanci, kte\u0159\u00ed tento \u00fadaj maj\u00ed<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"580\" height=\"332\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query2.jpg\" alt=\"\" class=\"wp-image-1450\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query2.jpg 580w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query2-300x172.jpg 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>tla\u010d\u00edtkem OK potvrd\u00edte p\u0159id\u00e1n\u00ed mzdov\u00e9 statistiky a horn\u00ed lev\u00e1 \u010d\u00e1st se v\u00e1m &#8222;p\u0159eroluje&#8220; a kdy\u017e si p\u0159et\u00e1hnete li\u0161tu \u00fapln\u011b dol\u016f, najdete p\u0159idan\u00e9 \u00fadaje z p\u0159idan\u00e9 mzdov\u00e9 statistiky &#8211; tyto \u00fadaje (nebo jen \u010d\u00e1st z nich) p\u0159et\u00e1hn\u011bte doprava, aby se v\u00e1m dostali do v\u00fdstupu<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"926\" height=\"736\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_05.jpg\" alt=\"\" class=\"wp-image-4862\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_05.jpg 926w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_05-300x238.jpg 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_05-768x610.jpg 768w\" sizes=\"auto, (max-width: 926px) 100vw, 926px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"926\" height=\"745\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_06.jpg\" alt=\"\" class=\"wp-image-4863\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_06.jpg 926w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_06-300x241.jpg 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_06-768x618.jpg 768w\" sizes=\"auto, (max-width: 926px) 100vw, 926px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>a\u017e budete m\u00edt vpravo v\u0161echny polo\u017eky, m\u016f\u017eete upravit v\u00fdb\u011brov\u00e9 krit\u00e9rium (\u00fapln\u011b dole uprost\u0159ed &#8211; rozev\u00edrac\u00ed menu V\u00fdb\u011brov\u00e9 krit\u00e9rium) a potvr\u010fte tla\u010d\u00edtkem OK<\/li><\/ul>\n\n\n\n<p>Nyn\u00ed m\u00e1te query ulo\u017een\u00e9 a m\u016f\u017eete je vytvo\u0159it pomoc\u00ed tla\u010d\u00edtka V\u00fdstup do excelu a v\u00fdb\u011bru obdob\u00ed, p\u0159\u00edp. \u00fapravy v\u00fdb\u011brov\u00e9ho krit\u00e9ria, vytvo\u0159\u00edte v\u00fdstup do Pracovn\u00edho adres\u00e1\u0159e<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"623\" height=\"399\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_07.jpg\" alt=\"\" class=\"wp-image-4864\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_07.jpg 623w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2023\/04\/MS_07-300x192.jpg 300w\" sizes=\"auto, (max-width: 623px) 100vw, 623px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>potvrd\u00edte tla\u010d\u00edtkem OK a v pracovn\u00edm adres\u00e1\u0159i zkontrolujete vytvo\u0159enou u\u017eivatelskou sestavu (jeliko\u017e jsme vytv\u00e1\u0159eli mzdovou statistiku&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/podpora.nuggetsw.cz\/index.php\/knowledge-base\/mzdova-statistika\/\" target=\"_blank\">zde<\/a>, kde jsme kontrolovali hrubou mzdu se sou\u010dtovou v\u00fdplatn\u00ed p\u00e1skou za cel\u00fd rok, m\u016f\u017eeme vytvo\u0159it sou\u010dtov\u00fd \u0159\u00e1dek a zkontrolovat, jestli n\u00e1m sou\u010det na celkovou hrubou mzdu sed\u00ed.)<\/li><li><strong><em>Pozor<\/em><\/strong>: n\u011bkter\u00e9 \u00fadaje jsou v\u017edy zapisov\u00e1ny na pracovn\u00ed pom\u011br 0. M\u016f\u017ee se proto st\u00e1t, \u017ee pokud m\u00e1te u jednoho zam\u011bstnance neaktivn\u00ed PP = 0 a aktivn\u00ed PP = 1, tak n\u011bkter\u00e9 \u00fadaje se v\u00e1m mohou ve v\u00fdsledn\u00e9m v\u00fdstupu objevit pr\u00e1v\u011b na tom neaktivn\u00edm pracovn\u00edm pom\u011bru 0<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1544\" height=\"480\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query7.jpg\" alt=\"\" class=\"wp-image-1454\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query7.jpg 1544w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query7-300x93.jpg 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query7-1024x318.jpg 1024w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query7-768x239.jpg 768w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query7-1536x478.jpg 1536w\" sizes=\"auto, (max-width: 1544px) 100vw, 1544px\" \/><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Query a mzdovou statistiku m\u016f\u017eete propojit pouze v modulu Mzdy. Pot\u0159ebujete vytvo\u0159it u\u017eivatelskou sestavu, kde krom\u011b \u00fadaj\u016f z kmenov\u00e9ho souboru tak\u00e9 pot\u0159ebujete \u00fadaje, kter\u00e9 jste si vytvo\u0159ili ve mzdov\u00e9 statistice d\u0159\u00edve.&nbsp; Ji\u017e um\u00edte vytvo\u0159it Query (n\u00e1vod zde) a mzdovou statistiku (n\u00e1vod zde) a nyn\u00ed se nau\u010d\u00edme propojit oboje do jednoho v\u00fdstupu (stejn\u00fd n\u00e1vod najdete i [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"template":"","format":"standard","meta":{"footnotes":""},"lsvr_kba_cat":[77],"lsvr_kba_tag":[],"class_list":["post-4856","lsvr_kba","type-lsvr_kba","status-publish","format-standard","hentry","lsvr_kba_cat-uzivatelske-sestavy"],"_links":{"self":[{"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_kba\/4856","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_kba"}],"about":[{"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/types\/lsvr_kba"}],"author":[{"embeddable":true,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/users\/3"}],"version-history":[{"count":4,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_kba\/4856\/revisions"}],"predecessor-version":[{"id":7676,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_kba\/4856\/revisions\/7676"}],"wp:attachment":[{"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/media?parent=4856"}],"wp:term":[{"taxonomy":"lsvr_kba_cat","embeddable":true,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_kba_cat?post=4856"},{"taxonomy":"lsvr_kba_tag","embeddable":true,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_kba_tag?post=4856"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}