{"id":578,"date":"2022-03-04T15:24:49","date_gmt":"2022-03-04T07:24:49","guid":{"rendered":"http:\/\/learning.sino-vt.com:8988\/?p=578"},"modified":"2022-03-04T15:24:49","modified_gmt":"2022-03-04T07:24:49","slug":"%e3%80%904-9%e3%80%91%e7%bb%88%e7%ab%af%e7%ae%a1%e7%90%86%e7%95%8c%e9%9d%a2%e4%b8%8d%e6%98%be%e7%a4%ba%e7%bb%88%e7%ab%af%e4%bf%a1%e6%81%af","status":"publish","type":"post","link":"http:\/\/learning.sino-vt.com:8988\/index.php\/2022\/03\/04\/%e3%80%904-9%e3%80%91%e7%bb%88%e7%ab%af%e7%ae%a1%e7%90%86%e7%95%8c%e9%9d%a2%e4%b8%8d%e6%98%be%e7%a4%ba%e7%bb%88%e7%ab%af%e4%bf%a1%e6%81%af\/","title":{"rendered":"\u30104.9\u3011\u7ec8\u7aef\u7ba1\u7406\u754c\u9762\u4e0d\u663e\u793a\u7ec8\u7aef\u4fe1\u606f"},"content":{"rendered":"<p><strong>\u95ee\u9898\u7248\u672c\uff1a<\/strong><\/p>\n<p>4.9<\/p>\n<p><strong>\u95ee\u9898\u73b0\u8c61\/\u62a5\u9519\uff1a<\/strong><\/p>\n<p>\u7ec8\u7aef\u7ba1\u7406\u754c\u9762\u4e0d\u663e\u793a\u7ec8\u7aef\u4fe1\u606f<\/p>\n<p><strong>\u6392\u67e5\u601d\u8def\/\u89e3\u51b3\u65b9\u6848\uff1a<\/strong><\/p>\n<p>\u6392\u67e5\u601d\u8def\uff1a\u67e5\u770bcenter\u9519\u8bef\u65e5\u5fd7\uff0c\u53d1\u73b0\u6709\u63d0\u793a\uff1aorgname\u4e3a\uff1f\uff1f<\/p>\n<p>\u53ef\u77e5\u662f\u83b7\u53d6\u7ec4\u7ec7\u65f6\u51fa\u73b0\u4e86\u95ee\u9898<\/p>\n<p>\u89e3\u51b3\u529e\u6cd5\uff1a\u8fde\u63a5mysql\u6570\u636e\u5e93\uff0c<\/p>\n<p>1.use auditsys;<\/p>\n<p>2.\u901a\u8fc7select organization_id,agentgroupid from agent;\u547d\u4ee4\u67e5\u8be2agent\u8868\u91cc\u9762\u7684\u7ec4\u7ec7id\u548c\u7ec8\u7aef\u7ec4id<\/p>\n<p>3.\u901a\u8fc7select * from organization;\u548cselect * from agent_group;\u67e5\u8be2organization\u8868\u548cagent_group\u8868<\/p>\n<p>4.\u68c0\u67e5agent\u8868\u91cc\u7684organization_id,agentgroupid\u5728\u5bf9\u5e94\u7684\u8868\u91cc\u662f\u5426\u90fd\u5b58\u5728<\/p>\n<p>5.\u901a\u8fc7UPDATE agent set agentgroupid =7<strong><em><b><i>\uff08\u8868\u91cc\u6709\u7684ID\uff09<\/i><\/b><\/em><\/strong>\u00a0where agentgroupid =13<strong><em><b><i>\uff08\u8868\u91cc\u6ca1\u6709\u7684\u7ec8\u7aef\u7ec4ID\uff09<\/i><\/b><\/em><\/strong>\uff1b\u5c06\u8868\u91ccorganization_id\u6216agentgroupid\u4e0d\u5b58\u5728\u7684\u7ec8\u7aef\u8fdb\u884c\u66f4\u65b0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u95ee\u9898\u7248\u672c\uff1a 4.9 \u95ee\u9898\u73b0\u8c61\/\u62a5\u9519\uff1a \u7ec8\u7aef\u7ba1\u7406\u754c\u9762\u4e0d\u663e\u793a\u7ec8\u7aef\u4fe1\u606f \u6392\u67e5\u601d\u8def\/\u89e3\u51b3\u65b9\u6848\uff1a \u6392\u67e5\u601d\u8def\uff1a\u67e5\u770bcent [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-578","post","type-post","status-publish","format-standard","hentry","category-auditsys"],"_links":{"self":[{"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/posts\/578","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/comments?post=578"}],"version-history":[{"count":1,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/posts\/578\/revisions"}],"predecessor-version":[{"id":579,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/posts\/578\/revisions\/579"}],"wp:attachment":[{"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/media?parent=578"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/categories?post=578"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/tags?post=578"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}