{"id":3315,"date":"2019-11-29T13:18:05","date_gmt":"2019-11-29T11:18:05","guid":{"rendered":"https:\/\/portal.winmentor.ro\/wme\/?page_id=3315"},"modified":"2019-11-29T13:18:05","modified_gmt":"2019-11-29T11:18:05","slug":"proceduri-actualizare-date","status":"publish","type":"page","link":"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/proceduri-actualizare-date\/","title":{"rendered":"Proceduri actualizare date"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Optiunea se gaseste in MENTOR &gt; Alte module \n&gt; AdminJOBs &gt; Proceduri de date. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Procedurile de date sunt utilizate pentru a \nproduce actualizari automate in baza de date, pentru a bloca la facturare \nparteneri care nu intrunesc conditiile impuse de politica firmei, care au \nautorizatii de functionare expirate, pentru a bloca la vanzare marfuri expirate, \nsau pentru a controla starea stocurilor cu data de expirare in vederea \nrestrictionarii vanzarilor de marfuri sau produse apropiate de data \nexpirarii.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Interogarea bazei de date se executa automat, \npe baza unui orar atasat procedurii. Programul ofera un set de proceduri \npredefinite, dar se pot imagina si alte actiuni de actualizare, in functie de \nspecificul firmei. Descrierea frazei SQL de executat&nbsp; poate fi facuta de catre \noperatori pe baza exemplelor din procedurile predefinite. Adaugarea sau \nmodificarea frazelor SQL de interogare este facilitata de sistemul automat de \npropunere a denumirilor de campuri pentru fiecare tabela in parte. Editorul SQL \nevidentiaza pe baza de culori cuvintele cheie ale limbajului pe masura \ndescrierii frazei.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Actualizarea procedurilor predefinite se \nrealizeaza din Service &#8211; Actualizari &#8211; Actualizare sabloane proceduri de date \nsau direct din view-ul de proceduri. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" loading=\"lazy\" src=\"\/Images\/14_03_01.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">In cadrul alertei se completeaza obligatoriu \nurmatoarele campuri: Explicatii, Nume ORACLE, Orar executie, Activa = Da\/Nu . \nDesigur, fraza SQL de interogare trebuie sa fie corecta pentru a obtine \nrezultatul dorit. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u201cNume obiect Oracle\u201d reprezinta o denumire \nunica in baza de date si este folosit de server pentru a identifica orarul in \nsistemul scheduler al motorului bazei de date. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Procedurile de date predefinite pe care le \nputeti importa din sabloane:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Actualizare stare stocuri \n<\/li><li>Blocare articole fara autorizatie \n<\/li><li>Blocare parteneri fara autorizatie \n<\/li><li>Blocare parteneri cu datorii mari <\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Optiunea se gaseste in MENTOR &gt; Alte module &gt; AdminJOBs &gt; Proceduri de date. Procedurile de date sunt utilizate pentru a produce actualizari automate in baza de date, pentru a bloca la facturare parteneri care nu intrunesc conditiile impuse de politica firmei, care au autorizatii de functionare expirate, pentru a bloca la vanzare marfuri expirate, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1867,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"tags":[],"class_list":["post-3315","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Proceduri actualizare date - WinMENTOR ENTERPRISE<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/proceduri-actualizare-date\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Proceduri actualizare date - WinMENTOR ENTERPRISE\" \/>\n<meta property=\"og:description\" content=\"Optiunea se gaseste in MENTOR &gt; Alte module &gt; AdminJOBs &gt; Proceduri de date. Procedurile de date sunt utilizate pentru a produce actualizari automate in baza de date, pentru a bloca la facturare parteneri care nu intrunesc conditiile impuse de politica firmei, care au autorizatii de functionare expirate, pentru a bloca la vanzare marfuri expirate, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/proceduri-actualizare-date\/\" \/>\n<meta property=\"og:site_name\" content=\"WinMENTOR ENTERPRISE\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/suport\\\/help\\\/proceduri-actualizare-date\\\/\",\"url\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/suport\\\/help\\\/proceduri-actualizare-date\\\/\",\"name\":\"Proceduri actualizare date - WinMENTOR ENTERPRISE\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/#website\"},\"datePublished\":\"2019-11-29T11:18:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/suport\\\/help\\\/proceduri-actualizare-date\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/suport\\\/help\\\/proceduri-actualizare-date\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/suport\\\/help\\\/proceduri-actualizare-date\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Suport\",\"item\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/suport\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Help\",\"item\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/suport\\\/help\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Proceduri actualizare date\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/#website\",\"url\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/\",\"name\":\"WinMENTOR ENTERPRISE\",\"description\":\"WinMENTOR ENTERPRISE: ERP gestiune, contabilitate Romania\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Proceduri actualizare date - WinMENTOR ENTERPRISE","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/proceduri-actualizare-date\/","og_locale":"en_US","og_type":"article","og_title":"Proceduri actualizare date - WinMENTOR ENTERPRISE","og_description":"Optiunea se gaseste in MENTOR &gt; Alte module &gt; AdminJOBs &gt; Proceduri de date. Procedurile de date sunt utilizate pentru a produce actualizari automate in baza de date, pentru a bloca la facturare parteneri care nu intrunesc conditiile impuse de politica firmei, care au autorizatii de functionare expirate, pentru a bloca la vanzare marfuri expirate, [&hellip;]","og_url":"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/proceduri-actualizare-date\/","og_site_name":"WinMENTOR ENTERPRISE","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/proceduri-actualizare-date\/","url":"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/proceduri-actualizare-date\/","name":"Proceduri actualizare date - WinMENTOR ENTERPRISE","isPartOf":{"@id":"https:\/\/portal.winmentor.ro\/wme\/#website"},"datePublished":"2019-11-29T11:18:05+00:00","breadcrumb":{"@id":"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/proceduri-actualizare-date\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/portal.winmentor.ro\/wme\/suport\/help\/proceduri-actualizare-date\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/proceduri-actualizare-date\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/portal.winmentor.ro\/wme\/"},{"@type":"ListItem","position":2,"name":"Suport","item":"https:\/\/portal.winmentor.ro\/wme\/suport\/"},{"@type":"ListItem","position":3,"name":"Help","item":"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/"},{"@type":"ListItem","position":4,"name":"Proceduri actualizare date"}]},{"@type":"WebSite","@id":"https:\/\/portal.winmentor.ro\/wme\/#website","url":"https:\/\/portal.winmentor.ro\/wme\/","name":"WinMENTOR ENTERPRISE","description":"WinMENTOR ENTERPRISE: ERP gestiune, contabilitate Romania","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/portal.winmentor.ro\/wme\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/pages\/3315","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/comments?post=3315"}],"version-history":[{"count":1,"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/pages\/3315\/revisions"}],"predecessor-version":[{"id":3316,"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/pages\/3315\/revisions\/3316"}],"up":[{"embeddable":true,"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/pages\/1867"}],"wp:attachment":[{"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/media?parent=3315"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/tags?post=3315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}