{"id":36470,"date":"2019-10-31T22:11:48","date_gmt":"2019-10-31T19:11:48","guid":{"rendered":"https:\/\/prohoster.info\/blog\/udobnaya-sistema-upravleniya-bazami-dannyh\/"},"modified":"2019-10-31T22:11:48","modified_gmt":"2019-10-31T19:11:48","slug":"udobnaya-sistema-upravleniya-bazami-dannyh","status":"publish","type":"post","link":"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/udobnaya-sistema-upravleniya-bazami-dannyh","title":{"rendered":"Pohodln\u00fd syst\u00e9m \u0159\u00edzen\u00ed datab\u00e1z\u00ed","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Chci se pod\u011blit o zku\u0161enosti s evoluc\u00ed pou\u017e\u00edv\u00e1n\u00ed datab\u00e1zov\u00fdch syst\u00e9m\u016f v jazykov\u00e9 online \u0161kole GLASHA.<\/p>\n

\u0160kola byla zalo\u017eena v roce 2012 a na za\u010d\u00e1tku jej\u00edho fungov\u00e1n\u00ed v n\u00ed studovalo pouze 12 student\u016f, tak\u017ee nebyly \u017e\u00e1dn\u00e9 probl\u00e9my s \u0159\u00edzen\u00edm rozvrhu a plateb. Nicm\u00e9n\u011b s r\u016fstem, rozvojem a p\u0159\u00edchodem nov\u00fdch student\u016f se nal\u00e9hav\u011b polo\u017eila ot\u00e1zka v\u00fdb\u011bru datab\u00e1zov\u00e9ho syst\u00e9mu.<\/p>\n

\u00dakol spo\u010d\u00edval v tom, aby se vytvo\u0159ilo:
\n<\/a><\/noindex> <\/p>\n

    \n
  1. adres\u00e1\u0159 v\u0161ech klient\u016f (student\u016f), kter\u00fd uchov\u00e1v\u00e1 jejich jm\u00e9na a p\u0159\u00edjmen\u00ed, \u010dasov\u00e9 p\u00e1smo, kontaktn\u00ed \u00fadaje a pozn\u00e1mky;<\/li>\n
  2. analogick\u00fd seznam u\u010ditel\u016f se stejn\u00fdmi informacemi o nich;<\/li>\n
  3. vytvo\u0159it rozvrh u\u010ditel\u016f v tomto syst\u00e9mu;<\/li>\n
  4. zautomatizovat generov\u00e1n\u00ed protokolu o lekc\u00edch;\n

    \"Pohodln\u00fd<\/li>\n

  5. sledovat historii lekc\u00ed;\n

    \"Pohodln\u00fd<\/li>\n

  6. evidence financ\u00ed jak pro odpisy z rozpo\u010dt\u016f student\u016f, tak pro platby u\u010ditel\u016fm;\n

    \"Pohodln\u00fd<\/li>\n

  7. sch\u00e9ma pro sledov\u00e1n\u00ed dlu\u017en\u00edk\u016f mezi studenty;<\/li>\n
  8. blok na pozn\u00e1mky o n\u011bkter\u00fdch nuanc\u00edch lekc\u00ed s vysko\u010d\u00edc\u00edmi p\u0159ipom\u00ednkami.<\/li>\n<\/ol>\n

    \nJak p\u0159ekvapiv\u00e9, \u017ee ve\u0161kerou tuto slo\u017eitou \u00fa\u010dt\u00e1rnu se poda\u0159ilo zvl\u00e1dnout pomoc\u00ed Excelu.<\/p>\n

    Nav\u00edc, elektronick\u00e9 tabulky umo\u017enily spojit rozpo\u010dty student\u016f do jednoho (pokud se jedn\u00e1 o \u010dleny jedn\u00e9 rodiny), spojit rozpo\u010dty u\u010ditel\u016f (pokud zastupuj\u00ed \u0161koly partnery), zav\u00e1d\u011bt r\u016fzn\u00e9 koeficienty pro platby u\u010ditel\u016fm, sestavovat r\u016fzn\u00e9 ceny pro studenty, sledovat bonusy a pokuty oper\u00e1tor\u016f Skype \u0161koly, a prohl\u00ed\u017eet analytiku o platb\u00e1ch a lekc\u00edch.<\/p>\n

    Nicm\u00e9n\u011b, kdy\u017e se po\u010det student\u016f zv\u00fd\u0161il na dv\u011b st\u011b a po\u010det u\u010ditel\u016f na 75, tento funk\u010dn\u00ed syst\u00e9m na hranici mo\u017enost\u00ed Excelu p\u0159estal b\u00fdt pohodln\u00fd. <\/p>\n

    Za prv\u00e9, po\u010det report\u016f se stal nedostate\u010dn\u00fdm pro syst\u00e9m \u0159\u00edzen\u00ed, a za druh\u00e9, offline verze vy\u017eadovala pravidelnou \u00fadr\u017ebu pro udr\u017een\u00ed vysok\u00e9 rychlosti pr\u00e1ce. Krom\u011b toho bylo t\u0159eba integrovat boty pro kontrolu voln\u00fdch slot\u016f u u\u010ditel\u016f, kontrolu z\u016fstatku na \u017e\u00e1dost student\u016f, zas\u00edl\u00e1n\u00ed SMS o zru\u0161en\u00ed lekc\u00ed atd.<\/p>\n

    A \u010dasem jsme vytvo\u0159ili webovou aplikaci GLASHA, v podstat\u011b se jednalo o ERP syst\u00e9m<\/a><\/noindex>, kter\u00fd umo\u017e\u0148uje pl\u00e1nov\u00e1n\u00ed u\u010ditel\u016f, veden\u00ed osobn\u00edch rozvrh\u016f student\u016f a rovn\u011b\u017e sledov\u00e1n\u00ed financ\u00ed. D\u00edky n\u011bmu jsou k dispozici r\u016fzn\u00e9 formy zpr\u00e1v, odpadla pot\u0159eba m\u011bs\u00ed\u010dn\u00edch \u00faprav datab\u00e1ze, vznikla mo\u017enost vytvo\u0159it z\u00e1kaznick\u00fd \u00fa\u010det a nahr\u00e1vat tam dom\u00e1c\u00ed \u00fakoly, testy pro ov\u011b\u0159ov\u00e1n\u00ed znalost\u00ed, nav\u00e1zat rozvrh na \u010dasov\u00e1 p\u00e1sma ka\u017ed\u00e9ho studenta atd.<\/p>\n

    \"Pohodln\u00fd
    \n
    \nMysl\u00edm, \u017ee takov\u00fd pl\u00e1novac\u00ed syst\u00e9m by byl u\u017eite\u010dn\u00fd pro optimalizaci jak\u00e9hokoli typu podnik\u00e1n\u00ed.
    \n
    Zdroj:     habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

    \u0425\u043e\u0447\u0443 \u043f\u043e\u0434\u0435\u043b\u0438\u0442\u044c\u0441\u044f \u043e\u043f\u044b\u0442\u043e\u043c \u044d\u0432\u043e\u043b\u044e\u0446\u0438\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u0441\u0438\u0441\u0442\u0435\u043c \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u044f\u0437\u044b\u043a\u043e\u0432\u043e\u0439 \u043e\u043d\u043b\u0430\u0439\u043d \u0448\u043a\u043e\u043b\u0435 GLASHA. \u0428\u043a\u043e\u043b\u0430 \u043e\u0431\u0440\u0430\u0437\u043e\u0432\u0430\u043b\u0430\u0441\u044c \u0432 2012 \u0433\u043e\u0434\u0443 \u0438 \u0432 \u043d\u0430\u0447\u0430\u043b\u0435 \u0440\u0430\u0431\u043e\u0442\u044b \u0432 \u043d\u0435\u0439 \u043e\u0431\u0443\u0447\u0430\u043b\u043e\u0441\u044c \u0432\u0441\u0435 12 \u0441\u0442\u0443\u0434\u0435\u043d\u0442\u043e\u0432, \u0442\u0430\u043a \u0447\u0442\u043e \u043d\u0438\u043a\u0430\u043a\u0438\u0445 \u043f\u0440\u043e\u0431\u043b\u0435\u043c \u0441 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435\u043c \u0440\u0430\u0441\u043f\u0438\u0441\u0430\u043d\u0438\u0435\u043c \u0438 \u043e\u043f\u043b\u0430\u0442\u0430\u043c\u0438 \u043d\u0435 \u0431\u044b\u043b\u043e. \u041e\u0434\u043d\u0430\u043a\u043e \u043f\u043e \u043c\u0435\u0440\u0435 \u0440\u043e\u0441\u0442\u0430, \u0440\u0430\u0437\u0432\u0438\u0442\u0438\u044f \u0438 \u043f\u043e\u044f\u0432\u043b\u0435\u043d\u0438\u044f \u043d\u043e\u0432\u044b\u0445 \u0441\u0442\u0443\u0434\u0435\u043d\u0442\u043e\u0432 \u043e\u0441\u0442\u0440\u043e \u0432\u0441\u0442\u0430\u043b \u0432\u043e\u043f\u0440\u043e\u0441 \u043e \u0432\u044b\u0431\u043e\u0440\u0435 \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u0431\u0430\u0437\u044b […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":27293,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-36470","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47 Komfortn\u00ed syst\u00e9m spr\u00e1vy datab\u00e1z\u00ed | ProHoster","description":"Cht\u011bl bych se pod\u011blit o zku\u0161enosti s evoluc\u00ed vyu\u017e\u00edv\u00e1n\u00ed datab\u00e1zov\u00fdch syst\u00e9m\u016f ve jazykov\u00e9 online \u0161kole GLASHA. \u0160kola byla zalo\u017eena v roce 2012 a na za\u010d\u00e1tku v n\u00ed studovalo pouze 12 student\u016f, tak\u017ee nedoch\u00e1zelo k \u017e\u00e1dn\u00fdm probl\u00e9m\u016fm.","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/udobnaya-sistema-upravleniya-bazami-dannyh","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"cs_CZ","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0423\u0434\u043e\u0431\u043d\u0430\u044f \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 | ProHoster","og:description":"\u0425\u043e\u0447\u0443 \u043f\u043e\u0434\u0435\u043b\u0438\u0442\u044c\u0441\u044f \u043e\u043f\u044b\u0442\u043e\u043c \u044d\u0432\u043e\u043b\u044e\u0446\u0438\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u0441\u0438\u0441\u0442\u0435\u043c \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u044f\u0437\u044b\u043a\u043e\u0432\u043e\u0439 \u043e\u043d\u043b\u0430\u0439\u043d \u0448\u043a\u043e\u043b\u0435 GLASHA. \u0428\u043a\u043e\u043b\u0430 \u043e\u0431\u0440\u0430\u0437\u043e\u0432\u0430\u043b\u0430\u0441\u044c \u0432 2012 \u0433\u043e\u0434\u0443 \u0438 \u0432 \u043d\u0430\u0447\u0430\u043b\u0435 \u0440\u0430\u0431\u043e\u0442\u044b \u0432 \u043d\u0435\u0439 \u043e\u0431\u0443\u0447\u0430\u043b\u043e\u0441\u044c \u0432\u0441\u0435 12 \u0441\u0442\u0443\u0434\u0435\u043d\u0442\u043e\u0432, \u0442\u0430\u043a \u0447\u0442\u043e \u043d\u0438\u043a\u0430\u043a\u0438\u0445 \u043f\u0440\u043e\u0431\u043b\u0435\u043c \u0441.","og:url":"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/udobnaya-sistema-upravleniya-bazami-dannyh","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-10-31T19:11:48+00:00","article:modified_time":"2019-10-31T19:11:48+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"36470","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-22 03:28:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 15:14:33","updated":"2026-01-22 03:28:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/36470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=36470"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/36470\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media\/27293"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=36470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=36470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=36470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}