{"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\/et\/blog\/administrirovanie\/udobnaya-sistema-upravleniya-bazami-dannyh","title":{"rendered":"Mugav andmebaasi halduss\u00fcsteem","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Soovin jagada kogemust andmebaasis\u00fcsteemide arengust GLASHA keele online-koolis.<\/p>\n

Kool loodi 2012. aastal ning kooli algusaegadel \u00f5ppis seal k\u00f5igest 12 \u00f5pilast, mist\u00f5ttu polnud ajakava ja maksete haldamisega probleeme. Kuid koos kasvamise, arengu ja uute \u00f5pilaste lisandumisega muutus andmebaasis\u00fcsteemi valik \u00fcha aktuaalsemaks.<\/p>\n

\u00dclesanne oli luua:
\n<\/a><\/noindex> <\/p>\n

    \n
  1. k\u00f5ikide klientide (\u00f5pilaste) register, kus on salvestatud nende nimi, ajav\u00f6\u00f6nd, kontaktandmed ja m\u00e4rkmed;<\/li>\n
  2. sarnane nimekiri \u00f5petajatest, kus on sama informatsioon nende kohta;<\/li>\n
  3. koostada \u00f5petajate ajakava samasse s\u00fcsteemi;<\/li>\n
  4. luua automaatne \u00f5ppetundide ajakava genereerimine;\n

    \"Mugav<\/li>\n

  5. j\u00e4lgida \u00f5ppetundide ajalugu;\n

    \"Mugav<\/li>\n

  6. raha liikluse arvestus nii \u00f5pilaste eelarvetelt mahav\u00f5tmise kui ka \u00f5petajate palgaarvestuse jaoks;\n

    \"Mugav<\/li>\n

  7. v\u00f5lgnike j\u00e4lgimise skeem \u00f5pilaste seas;<\/li>\n
  8. m\u00e4rkmik m\u00e4rkmete tegemiseks tundide n\u00fcansside kohta h\u00fcpikm\u00e4rkustega.<\/li>\n<\/ol>\n

    \nKummalisel kombel \u00f5nnestus kogu see keeruline arvestus teha Exceli abil.<\/p>\n

    Lisaks v\u00f5imaldasid tabelid \u00fchendada \u00f5pilaste eelarved \u00fcheks (kui tegelevad sama pere liikmed), \u00fchendama \u00f5petajate eelarved (kui nad esindavad partnerkoole), kehtestada \u00f5petajate palkade jaoks erinevad koefitsiendid, m\u00e4\u00e4rata \u00f5pilastele erinevad hinnad, j\u00e4lgida Skype'i kooli operaatorite boonuseid ja trahve, ning vaadata maksete ja tundide anal\u00fc\u00fctikat.<\/p>\n

    Kuid kui \u00f5pilaste arv suurenes kahesaja inimeseni ning \u00f5petajate arv 75-ni, siis see Exceli piiril tehtud funktsionaalsus muutus ebamugavaks. <\/p>\n

    Esiteks, aruanne oli s\u00fcsteemi haldamiseks ebapiisav, teiseks, vaikimisi versioon n\u00f5udis regulaarset puhastamist, et s\u00e4ilitada k\u00f5rge t\u00f6\u00f6kiirus. Peale selle oli vajalik integratsioon botidega \u00f5petajate vabade slotide kontrollimiseks, \u00f5pilaste j\u00e4\u00e4nud saldo kontrollimiseks, SMS-ide saatmiseks tundide t\u00fchistamisest jne.<\/p>\n

    Ja aja jooksul l\u00f5ime veebirakenduse GLASHA, mis on sisuliselt ERP s\u00fcsteem<\/a><\/noindex>, mis v\u00f5imaldab \u00f5petajate koormust planeerida, pidada isiklikke tunniplaane \u00fcli\u00f5pilastele ning j\u00e4lgida rahavoogusid. T\u00e4nu sellele on erinevad aruandevormid kergesti k\u00e4ttesaadavad, igakuine andmebaasi parandamine pole enam vajalik ning on v\u00f5imalik luua kliendi isiklik kabinet, kuhu saab \u00fcles laadida kodut\u00f6\u00f6d, teste teadmiste hindamiseks, siduda tunniplaan iga \u00fcli\u00f5pilase ajav\u00f6\u00f6ndiga jne.<\/p>\n

    \"Mugav
    \n
    \nMa arvan, et selline planeerimiss\u00fcsteem oleks igasuguste \u00e4ride optimeerimiseks kasulik.
    \n
    Allikas:     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\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\udd47Mugav andmebaasis\u00fcsteem | ProHoster","description":"Soovin jagada kogemust andmebaasis\u00fcsteemide arengust keelekooli GLASHA kasutamisel. Kool loodi 2012. aastal ja alguses \u00f5ppis seal k\u00f5ik 12 \u00fcli\u00f5pilast, nii et probleeme ei olnud.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/udobnaya-sistema-upravleniya-bazami-dannyh","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","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\/et\/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\/et\/wp-json\/wp\/v2\/posts\/36470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=36470"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/36470\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/27293"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=36470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=36470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=36470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}