Date: Fri, 29 Mar 2024 01:24:24 +0800 (CST) Message-ID: <1257383088.239211.1711646664096@smartbi-wiki-7-5457b896d6-jhmkq> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_239210_236240390.1711646664096" ------=_Part_239210_236240390.1711646664096 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
=E7=94=A8=E6=88=B7=E9=9B=86=E6=88=90=E6=98=AF=E7=B3=BB=E7=BB=9F=E9=9B=86= =E6=88=90=E4=B8=AD=E6=9C=80=E5=B8=B8=E8=A7=81=E7=9A=84=E8=A6=81=E6=B1=82=E4= =B9=8B=E4=B8=80=E3=80=82=E5=BD=93=E6=9C=89=E5=A4=9A=E5=A5=97=E7=B3=BB=E7=BB= =9F=E5=90=8C=E6=97=B6=E4=BD=BF=E7=94=A8=E6=97=B6=EF=BC=8C=E5=AE=A2=E6=88=B7= =E5=BE=80=E5=BE=80=E5=B8=8C=E6=9C=9B=E7=BB=9F=E4=B8=80=E8=BF=9B=E8=A1=8C=E7= =94=A8=E6=88=B7=E7=AE=A1=E7=90=86=E3=80=81=E7=BB=9F=E4=B8=80=E7=99=BB=E5=BD= =95=E8=AE=A4=E8=AF=81=EF=BC=8C=E4=B9=9F=E5=B0=B1=E6=98=AF=E8=AF=B4=E5=8F=AA= =E5=9C=A8=E4=B8=80=E4=B8=AA=E7=B3=BB=E7=BB=9F=E4=B8=AD=E7=BB=B4=E6=8A=A4=E5= =9F=BA=E7=A1=80=E7=94=A8=E6=88=B7=E4=BF=A1=E6=81=AF=E3=80=81=E5=8F=AA=E7=99= =BB=E5=BD=95=E4=B8=80=E6=AC=A1=EF=BC=88=E5=8D=95=E7=82=B9=E7=99=BB=E5=BD=95= =EF=BC=89=E5=B0=B1=E5=8F=AF=E4=BB=A5=E8=AE=BF=E9=97=AE=E4=B8=8D=E5=90=8C=E7= =B3=BB=E7=BB=9F=E7=9A=84=E5=86=85=E5=AE=B9=E3=80=82=E7=94=A8=E6=88=B7=E9=9B= =86=E6=88=90=E5=8C=85=E5=90=AB=E4=B8=A4=E4=B8=AA=E6=96=B9=E9=9D=A2=E5=86=85= =E5=AE=B9=EF=BC=9A
=E6=B3=A8=E6=84=8F=E4=BA=8B= =E9=A1=B9=EF=BC=9ASmartbi =E8=BF=98=E6=9C=89=E8=A7=92=E8=89=B2=E6= =A6=82=E5=BF=B5=EF=BC=8C=E6=97=A0=E8=AE=BA=E5=93=AA=E7=A7=8D=E9=9B=86=E6=88= =90=E6=96=B9=E5=BC=8F=EF=BC=8C=E9=83=BD=E8=A6=81=E6=B1=82=E5=9C=A8 Smartbi = =E2=80=9C=E7=AE=A1=E7=90=86 -> =E7=94=A8=E6=88=B7=E7=AE=A1=E7=90= =86=E2=80=9D=E6=A8=A1=E5=9D=97=E4=B8=AD=E5=88=9B=E5=BB=BA=E8=A7=92= =E8=89=B2=EF=BC=8C=E5=B9=B6=E8=AE=BE=E7=BD=AE=E8=A7=92=E8=89=B2=E7=9A=84=E6= =93=8D=E4=BD=9C=E6=9D=83=E9=99=90=E5=92=8C=E6=95=B0=E6=8D=AE=E6=9D=83=E9=99= =90=EF=BC=9B=E7=94=A8=E6=88=B7=E5=BF=85=E9=A1=BB=E8=A2=AB=E8=B5=8B=E4=BA=88= =E8=A7=92=E8=89=B2=EF=BC=8C=E6=89=8D=E8=83=BD=E7=99=BB=E5=BD=95 Smartbi =E5= =B9=B6=E4=BD=BF=E7=94=A8=E7=9B=B8=E5=BA=94=E7=9A=84=E5=8A=9F=E8=83=BD=E3=80= =82
=E7=9B=B8=E5=85=B3=E6=96=87=E6=A1=A3=EF=BC=9A
=20=E8=AF=B4=E6=98=8E=EF=BC=9A
=E5=8F=AF=E4=BB=A5=E9=80=9A=E8=BF=87=E5=AD=98=E5=82=A8=E8=BF=87=E7=A8=8B= =E6=88=96 ETL =E5=AE=9A=E6=97=B6=E5=B0=86=E7=AC=AC=E4=B8=89=E6=96=B9=E7=B3= =BB=E7=BB=9F=E7=9A=84=E7=94=A8=E6=88=B7=E4=BF=A1=E6=81=AF=E5=90=8C=E6=AD=A5= =E5=88=B0 Smartbi =E7=9F=A5=E8=AF=86=E5=BA=93=E7=9B=B8=E5=85=B3=E7=9A=84=E7= =94=A8=E6=88=B7=E8=A1=A8=E4=B8=AD=E3=80=82=E5=90=8C=E6=AD=A5=E6=95=B0=E6=8D= =AE=E5=BA=93=E6=97=B6=E6=B6=89=E5=8F=8A=E5=88=B0=E7=9A=84=E8=A1=A8=E5=A6=82= =E4=B8=8B=EF=BC=9A
=E6=95=B0=E6=8D=AE=E8=A1=A8<= /p> |
=E5=90=AB=E4=B9=89=E8=AF=B4=E6=98=8E<= /strong> |
---|---|
=E7=94=A8=E6=88=B7=E7=BB=84=E8=A1=A8=EF=BC=8C= =E8=AE=B0=E5=BD=95=E7=94=A8=E6=88=B7=E7=BB=84=EF=BC=88=E6=9C=BA=E6=9E=84=EF= =BC=89=E7=9A=84=E4=BF=A1=E6=81=AF=E3=80=82 |
|
= td> | =E7=94=A8=E6=88=B7=E8=A1=A8=EF=BC=8C=E8=AE=B0= =E5=BD=95=E6=89=80=E6=9C=89=E7=94=A8=E6=88=B7=E4=BF=A1=E6=81=AF=E3=80=82 |
=E7=94=A8=E6=88=B7=E7=BB=84=E4=B8=8E=E7=94=A8= =E6=88=B7=E5=AF=B9=E5=BA=94=E8=A1=A8=E3=80=82=E7=9B=B8=E5=85=B3=E5=AD=97=E6= =AE=B5=EF=BC=9At_user.c_userid=E3=80=81t_group. c_groupid |
|
=E8=A7=92=E8=89=B2=E8=A1=A8=EF=BC=8C=E8=AE=B0= =E5=BD=95=E7=B3=BB=E7=BB=9F=E6=89=80=E6=9C=89=E8=A7=92=E8=89=B2=E7=9A=84=E4= =BF=A1=E6=81=AF=E3=80=82=E7=9B=B8=E5=85=B3=E5=AD=97=E6=AE=B5=EF=BC=9At_grou= p. c_groupid |
|
=E7=94=A8=E6=88=B7=E7=BB=84=E4=B8=8E=E8=A7=92= =E8=89=B2=E5=AF=B9=E5=BA=94=E5=85=B3=E7=B3=BB=E8=A1=A8=E3=80=82=E7=9B=B8=E5= =85=B3=E5=AD=97=E6=AE=B5=EF=BC=9At_role.c_roleid=E3=80=81t_group. c_groupid= |
|
=E7=94=A8=E6=88=B7=E4=B8=8E=E8=A7=92=E8=89=B2= =E5=AF=B9=E5=BA=94=E5=85=B3=E7=B3=BB=E8=A1=A8=E3=80=82=E7=9B=B8=E5=85=B3=E5= =AD=97=E6=AE=B5=EF=BC=9At_role.c_roleid=E3=80=81t_user. c_userid |
|
=E6=93=8D=E4=BD=9C=E6=9D=83=E9=99=90=E8=A1=A8= =E3=80=82 |
|
=E8=A7=92=E8=89=B2=E4=B8=8E=E6=93=8D=E4=BD=9C= =E6=9D=83=E9=99=90=E5=85=B3=E7=B3=BB=E8=A1=A8=E3=80=82=E7=9B=B8=E5=85=B3=E5= =AD=97=E6=AE=B5=EF=BC=9At_role.c_roleid=E3=80=81t_funclist. c_funcid |
=E5=AD=97=E6=AE=B5=E7=B1=BB=E5=9E=8B=EF=BC=9A
=E4=B8=8B=E6=96=87=E8=A1=A8=E7=BB=93=E6=9E=84=E4=B8=AD=E7=9A=84=E5=AD=97= =E6=AE=B5=E7=B1=BB=E5=9E=8B=E7=AD=89=E4=BF=A1=E6=81=AF=EF=BC=8C=E5=9D=87=E6= =98=AF=E9=92=88=E5=AF=B9 MySQL 5.0 =E8=80=8C=E8=A8=80=EF=BC=8C=E5=85=B6=E5= =AE=83=E6=95=B0=E6=8D=AE=E5=BA=93=E7=B1=BB=E5=9E=8B=E7=9A=84=E5=AF=B9=E5=BA= =94=E5=85=B3=E7=B3=BB=E5=A6=82=E4=B8=8B=E8=A1=A8=E6=89=80=E7=A4=BA=EF=BC=9A=
=E6=95=B0=E6=8D=AE=E5=BA=93=E7=B1=BB= =E5=9E=8B |
MySQL |
Oracle |
DB2 |
---|---|---|---|
=E5=AD=97=E7=AC=A6=E4=B8=B2 | VARCHAR |
VARCHAR2 |
VARCHAR |
=E6=95=B4=E6=95=B0 |
INTEGER |
INTEGER |
INTEGER |
=E6=B5=AE=E7=82=B9=E6=95=B0 |
DOUBLE |
DOUBLE |
DOUBLE |
=E6=97=A5=E6=9C=9F=E6=97=B6=E9=97=B4 |
DATETIME |
DATE |
DATE |
=E9=95=BF=E6=96=87=E6=9C=AC |
LONGTEXT |
CLOB |
CLOB |
=E6=B3=A8=E6=84=8F=E4=BA=8B=E9=A1=B9=EF=BC=9A
t_group =E7=94=A8=E6=88=B7=E7=BB=84=E8=A1=A8=EF= =BC=8C=E8=AE=B0=E5=BD=95=E7=94=A8=E6=88=B7=E7=BB=84=E7=9A=84=E4=BF=A1=E6=81= =AF=E3=80=82=E9=80=9A=E8=BF=87=E5=AD=97=E6=AE=B5c_orgid=EF=BC=8C=E5=AE=9E= =E7=8E=B0=E7=94=A8=E6=88=B7=E4=B8=8E=E6=9C=BA=E6=9E=84=E7=9A=84=E5=85=B3=E8= =81=94=E3=80=82
=E5=AD=97=E6=AE=B5=E5=90=8D<= /p> |
=E4=B8=AD=E6=96=87=E5=90=AB=E4=B9=89<= /strong> |
=E6=95=B0=E6=8D=AE=E7=B1=BB=E5=9E=8B<= /strong> |
=E7=BA=A6=E6=9D=9F |
---|---|---|---|
c_groupid |
=E7=BB=84ID |
VARCHAR(255) |
NOT NULL |
c_pgroupid |
=E7=88=B6=E7=BB=84ID |
VARCHAR(255) |
default NULL |
c_groupname |
=E7=BB=84=E5=90=8D=E7=A7=B0 |
VARCHAR(255) |
default NULL |
c_groupalias |
=E7=BB=84=E5=88=AB=E5=90=8D |
VARCHAR(255) |
default NULL |
c_groupdesc |
=E6=8F=8F=E8=BF=B0 |
VARCHAR(255) |
default NULL |
c_orgid |
=E6=9C=BA=E6=9E=84=E7=BC=96=E5=8F=B7 |
VARCHAR(255) |
default NULL |
t_user =E7=94=A8=E6=88=B7= =E8=A1=A8=EF=BC=8C=E8=AE=B0=E5=BD=95=E6=89=80=E6=9C=89=E7=94=A8=E6=88=B7=E4= =BF=A1=E6=81=AF=E3=80=82
=E5=AD=97=E6=AE=B5=E5=90=8D<= /p> |
=E4=B8=AD=E6=96=87=E5=90=AB=E4=B9=89<= /strong> |
=E6=95=B0=E6=8D=AE=E7=B1=BB=E5=9E=8B<= /strong> |
=E7=BA=A6=E6=9D=9F |
---|---|---|---|
c_userid |
=E7=94=A8=E6=88=B7ID |
VARCHAR(255) |
NOT NULL |
c_username |
=E7=94=A8=E6=88=B7=E5=90=8D=E7=A7=B0 |
VARCHAR(255) |
default NULL |
c_useralias |
=E7=94=A8=E6=88=B7=E5=88=AB=E5=90=8D |
VARCHAR(255) |
default NULL |
c_userpwd |
=E7=94=A8=E6=88=B7=E5=AF=86=E7=A0=81 |
VARCHAR(255) |
default NULL |
c_userdesc |
=E6=8F=8F=E8=BF=B0 |
VARCHAR(255) |
default NULL |
c_isenabled |
=E7=94=A8=E6=88=B7=E6=98=AF=E5=90=A6=E5=90=AF= =E7=94=A8 |
VARCHAR(255) |
default NULL |
c_extended |
=E7=94=A8=E6=88=B7=E6=89=A9=E5=B1=95=E4=BF=A1= =E6=81=AF |
LONGTEXT |
default NULL |
c_defaultgrp |
=E9=BB=98=E8=AE=A4=E7=BB=84 |
VARCHAR(255) |
default NULL |
=E5=A4=87=E6=B3=A8=EF=BC=9Ac_defaultgrp =E5=9C=A8=E6=96=B0=E7=89=88=E6= =9C=AC=E4=B8=AD=E8=AF=A5=E5=AD=97=E6=AE=B5=E5=B7=B2=E8=A2=AB=E5=BC=83=E7=94= =A8=E3=80=82
t_group_user =E7=94=A8=E6=88=B7=E7=BB=84=E4=B8=8E= =E7=94=A8=E6=88=B7=E5=AF=B9=E5=BA=94=E8=A1=A8=E3=80=82=E7=9B=B8=E5=85=B3=E5= =AD=97=E6=AE=B5=EF=BC=9At_user.c_userid=E3=80=81t_group. c_groupid=E3=80=82=
=E5=AD=97=E6=AE=B5=E5=90=8D<= /p> |
=E4=B8=AD=E6=96=87=E5=90=AB=E4=B9=89<= /strong> |
=E6=95=B0=E6=8D=AE=E7=B1=BB=E5=9E=8B<= /strong> |
=E7=BA=A6=E6=9D=9F |
---|---|---|---|
c_id |
ID |
VARCHAR(255) |
NOT NULL |
c_userid |
=E7=94=A8=E6=88=B7ID |
VARCHAR(255) |
default NULL |
c_groupid |
=E7=BB=84=E7=BC=96=E5=8F=B7 |
VARCHAR(255) |
default NULL |
c_isdefault |
=E6=98=AF=E5=90=A6=E9=BB=98=E8=AE=A4=E7=BB=84= |
INTEGER |
default NULL |
t_role =E8=A7=92=E8=89=B2=E8=A1=A8=EF=BC=8C=E8=AE= =B0=E5=BD=95=E7=B3=BB=E7=BB=9F=E6=89=80=E6=9C=89=E8=A7=92=E8=89=B2=E7=9A=84= =E4=BF=A1=E6=81=AF=E3=80=82=E7=9B=B8=E5=85=B3=E5=AD=97=E6=AE=B5=EF=BC=9At_g= roup. c_groupid=E3=80=82
=E5=AD=97=E6=AE=B5=E5=90=8D<= /p> |
=E4=B8=AD=E6=96=87=E5=90=AB=E4=B9=89<= /strong> |
=E6=95=B0=E6=8D=AE=E7=B1=BB=E5=9E=8B<= /strong> |
=E7=BA=A6=E6=9D=9F |
---|---|---|---|
c_roleid |
=E8=A7=92=E8=89=B2ID |
VARCHAR(255) |
NOT NULL |
c_rolename |
=E8=A7=92=E8=89=B2=E5=90=8D=E7=A7=B0 |
VARCHAR(255) |
default NULL |
c_rolealias |
=E8=A7=92=E8=89=B2=E5=88=AB=E5=90=8D |
VARCHAR(255) |
default NULL |
c_groupid |
=E7=BB=84ID |
VARCHAR(255) |
default NULL |
c_roledesc |
=E6=8F=8F=E8=BF=B0 |
VARCHAR(255) |
default NULL |
c_sysid |
=E5=BA=94=E7=94=A8=E7=B3=BB=E7=BB=9FID | VARCHAR(255) |
default NULL |
t_group_role =E7=94=A8=E6=88=B7=E7=BB=84=E4=B8=8E=E8=A7=92=E8=89=B2=E5= =AF=B9=E5=BA=94=E8=A1=A8=E3=80=82=E7=9B=B8=E5=85=B3=E5=AD=97=E6=AE=B5=EF=BC= =9At_role.c_roleid=E3=80=81t_group. c_groupid=E3=80=82
=E5=AD=97=E6=AE=B5=E5=90=8D<= /p> |
=E4=B8=AD=E6=96=87=E5=90=AB=E4=B9=89<= /strong> |
=E6=95=B0=E6=8D=AE=E7=B1=BB=E5=9E=8B<= /strong> |
=E7=BA=A6=E6=9D=9F |
---|---|---|---|
c_id |
ID |
VARCHAR(255) |
NOT NULL |
c_roleid |
=E8=A7=92=E8=89=B2ID |
VARCHAR(255) |
default NULL |
c_groupid |
=E7=BB=84ID |
VARCHAR(255) |
default NULL |
c_isdescend |
=E6=98=AF=E5=90=A6=E5=AD=90=E5=AD=99=E7=94=A8= |
INTEGER |
default NULL |
t_user_role =E7=94=A8=E6=88=B7=E4=B8=8E=E8=A7=92= =E8=89=B2=E5=AF=B9=E5=BA=94=E8=A1=A8=E3=80=82=E7=9B=B8=E5=85=B3=E5=AD=97=E6= =AE=B5=EF=BC=9At_role.c_roleid=E3=80=81t_user. c_userid=E3=80=82
=E5=AD=97=E6=AE=B5=E5=90=8D<= /p> |
=E4=B8=AD=E6=96=87=E5=90=AB=E4=B9=89<= /strong> |
=E6=95=B0=E6=8D=AE=E7=B1=BB=E5=9E=8B<= /strong> |
=E7=BA=A6=E6=9D=9F |
---|---|---|---|
c_roleid |
=E8=A7=92=E8=89=B2ID |
VARCHAR(255) |
default NULL |
c_userid |
=E7=94=A8=E6=88=B7ID |
VARCHAR(255) |
default NULL |
t_funclist =E6=93=8D=E4= =BD=9C=E6=9D=83=E9=99=90=E8=A1=A8=E3=80=82
=E5=AD=97=E6=AE=B5=E5=90=8D<= /p> |
=E4=B8=AD=E6=96=87=E5=90=AB=E4=B9=89<= /strong> |
=E6=95=B0=E6=8D=AE=E7=B1=BB=E5=9E=8B<= /strong> |
=E7=BA=A6=E6=9D=9F |
---|---|---|---|
c_funcid |
=E5=8A=9F=E8=83=BDID |
VARCHAR(255) |
PK |
c_funcname |
=E5=8A=9F=E8=83=BD=E4=B8=AD=E6=96=87=E5=90=8D= |
VARCHAR(255) |
default NULL |
c_funcalias |
=E5=8A=9F=E8=83=BD=E5=88=AB=E5=90=8D |
VARCHAR(255) |
default NULL |
c_funcdesc |
=E5=8A=9F=E8=83=BD=E6=8F=8F=E8=BF=B0 |
VARCHAR(255) |
default NULL |
c_sysid |
=E6=89=80=E5=B1=9E=E7=B3=BB=E7=BB=9FID | VARCHAR(255) |
default NULL |
c_pfuncid |
=E7=88=B6=E5=8A=9F=E8=83=BDID |
VARCHAR(255) |
default NULL |
c_isbuiltin |
=E6=98=AF=E5=90=A6=E5=86=85=E7=BD=AE=E6=93=8D= =E4=BD=9C=E6=9D=83=E9=99=90=EF=BC=8C"1"=E4=B8=BA=E6=98=AF=E3=80=82 |
VARCHAR(255) |
default NULL |
t_role_func =E8=A7=92=E8=89=B2=E4=B8=8E=E6=93=8D=E4=BD=9C=E6=9D=83=E9=99= =90=E5=85=B3=E7=B3=BB=E8=A1=A8=E3=80=82=E7=9B=B8=E5=85=B3=E5=AD=97=E6=AE=B5= =EF=BC=9At_role.c_roleid=E3=80=81t_funclist. c_funcid=E3=80=82
=E5=AD=97=E6=AE=B5=E5=90=8D<= /p> |
=E4=B8=AD=E6=96=87=E5=90=AB=E4=B9=89<= /strong> |
=E6=95=B0=E6=8D=AE=E7=B1=BB=E5=9E=8B<= /strong> |
=E7=BA=A6=E6=9D=9F |
---|---|---|---|
c_roleid |
=E8=A7=92=E8=89=B2=E7=BC=96=E5=8F=B7 |
VARCHAR(255) |
default NULL |
c_funcid |
=E5=8A=9F=E8=83=BD=E7=BC=96=E5=8F=B7 |
VARCHAR(255) |
default NULL |
=E8=AF=B4=E6=98=8E=EF=BC=9A
Smartbi =E6=8F=90=E4=BE=9B Java =E5=92=8C JavaScript =E4=B8=A4=E7=A7=8D = API =E4=BE=9B=E5=A4=96=E9=83=A8=E7=B3=BB=E7=BB=9F=E8=B0=83=E7=94=A8=E5=AE= =9E=E7=8E=B0=E7=94=A8=E6=88=B7=E4=BF=A1=E6=81=AF=E5=90=8C=E6=AD=A5=E3=80=82=
=E5=AE=9E=E7=8E=B0=E6=AD=A5=E9=AA=A4=EF=BC=9A
1=E3=80=81=E5=BD=93=E5=9C=A8=E7=AC=AC=E4=B8=89=E6=96=B9=E7=B3=BB=E7=BB= =9F=E8=BF=9B=E8=A1=8C=E5=A2=9E=E5=88=A0=E7=94=A8=E6=88=B7/=E7=94=A8=E6=88= =B7=E7=BB=84=E7=AD=89=E6=93=8D=E4=BD=9C=E6=97=B6=EF=BC=8C=E5=90=8E=E5=8F=B0= =E7=A8=8B=E5=BA=8F=E8=B0=83=E7=94=A8 Smartbi =E6=8F=90=E4=BE=9B=E7=9A=84 AP= I =E6=8E=A5=E5=8F=A3=E5=90=8C=E6=AD=A5=E5=B0=86=E7=94=A8=E6=88=B7=E4=BF=A1= =E6=81=AF=E5=90=8C=E6=AD=A5=E5=88=B0 Smartbi =E7=B3=BB=E7=BB=9F=E4=B8=AD=E3= =80=82
2=E3=80=81=E8=B0=83=E7=94=A8=E6=96=B9=E6=B3=95=E8=AF=B7=E5=8F=82=E8=80= =83=E5=BC=80=E5=8F=91=E6=8E=A5=E5=8F=A3=E4=B8=AD =E6=9C=8D= =E5=8A=A1=E5=99=A8=E7=AB=AFSDK =E5=92=8C =E6=B5=8F=E8=A7=88=E5=99=A8=E7=AB=AFSDK =E4=B8=AD=E7=9A= =84=E6=93=8D=E4=BD=9C=E6=AD=A5=E9=AA=A4=E3=80=82
=E7=B3=BB=E7=BB=9F=E6=96=B9=E6=B3=95=EF=BC=9A
=E7=B3=BB=E7=BB=9F=E6=8F=90=E4=BE=9B=E7=9A=84=E7=94=A8=E6=88=B7=E7=AE=A1= =E7=90=86=E6=96=B9=E6=B3=95=E7=A4=BA=E4=BE=8B=E5=A6=82=E4=B8=8B=E3=80=82
=E6=96=B9=E6=B3=95=E5=90=8D<= /p> |
=E4=BD=9C=E7=94=A8 |
---|---|
= createDepartment(parentGroupId, groupName, groupAlias, desc, departmentCode) | =E5=88=9B=E5=BB=BA=E7=94=A8=E6=88=B7=E7=BB=84= =E3=80=82 |
= createRole(roleName, roleAlias, desc, groupId) |
=E5=88=9B=E5=BB=BA=E8=A7=92=E8=89=B2=E3=80=82= |
= createUser(parentGroupId, userName, userAlias, desc, password, isEnabled) |
=E5=88=9B=E5=BB=BA=E7=94=A8=E6=88=B7=E3=80=82= |
= deleteDepartment(groupId) |
=E5=88=A0=E9=99=A4=E7=94=A8=E6=88=B7=E7=BB=84= =E3=80=82 |
= deleteRole(roleId) |
=E5=88=A0=E9=99=A4=E8=A7=92=E8=89=B2=E3=80=82= |
= deleteUser(userId) |
=E5=88=A0=E9=99=A4=E7=94=A8=E6=88=B7=E3=80=82= |
= getCurrentUser<= /span>() |
=E8=8E=B7=E5=8F=96=E5=BD=93=E5=89=8D=E7=99=BB= =E5=BD=95=E7=94=A8=E6=88=B7=E4=BF=A1=E6=81=AF=E3=80=82 |
= getDefaultDepartment(userId,hierId) |
=E8=8E=B7=E5=8F=96=E7=94=A8=E6=88=B7=E7=9A=84= =E9=BB=98=E8=AE=A4=E7=BB=84=EF=BC=8ChierId=E4=B8=BA"DEPARTMENT"=E3=80=82 |
= getDepartmentById(id) |
=E9=80=9A=E8=BF=87=E7=94=A8=E6=88=B7=E7=BB=84= ID=E8=8E=B7=E5=8F=96=E7=94=A8=E6=88=B7=E7=BB=84=E4=BF=A1=E6=81=AF=E3=80=82<= /p> |
= getDepartmentByName(name) |
=E9=80=9A=E8=BF=87=E5=90=8D=E7=A7=B0=E8=8E=B7= =E5=8F=96=E7=94=A8=E6=88=B7=E7=BB=84=E5=AF=B9=E8=B1=A1=E3=80=82 |
= updateDepartment(groupId, groupAlias, desc, departmentCode) |
=E4=BF=AE=E6=94=B9=E7=94=A8=E6=88=B7=E7=BB=84= =E3=80=82 |
= updateRole(roleId, roleAlias, desc) |
=E4=BF=AE=E6=94=B9=E8=A7=92=E8=89=B2=E3=80=82= |
= updateUser(userId, alias, desc, password, isEnabled) |
=E4=BF=AE=E6=94=B9=E7=94=A8=E6=88=B7=E3=80=82= |
= assignDepartmentsToRole<= /strong>(roleId, groupIdList) |
=E7=BB=99=E8=A7=92=E8=89=B2=E5=88=86=E9=85=8D= =E7=94=A8=E6=88=B7=E7=BB=84=E3=80=82 |
= assignDepartmentsToUser<= /strong>(userId, groupIdList) |
=E4=BF=AE=E6=94=B9=E7=94=A8=E6=88=B7=E7=9A=84= =E6=89=80=E5=B1=9E=E7=BB=84=E3=80=82 |
= assignRolesToDepartment<= /strong>(groupId, roleForGroupList) |
=E5=88=86=E9=85=8D=E8=A7=92=E8=89=B2=E7=BB=99= =E7=94=A8=E6=88=B7=E7=BB=84=E3=80=82 |
= assignRolesToUser(userId, roleIdList) |
=E7=BB=99=E7=94=A8=E6=88=B7=E5=88=86=E9=85=8D= =E8=A7=92=E8=89=B2=E3=80=82 |
= assignUsersToGroup(groupId, userIdList) |
=E4=BF=AE=E6=94=B9=E7=BB=84=E6=89=80=E6=8B=A5= =E6=9C=89=E7=9A=84=E7=94=A8=E6=88=B7=E3=80=82 |
= assignUsersToRole(roleId, userIdList) |
=E7=BB=99=E8=A7=92=E8=89=B2=E5=88=86=E9=85=8D= =E7=94=A8=E6=88=B7=E3=80=82 |
=E6=9B=B4=E5=A4=9A=E5=85=B7=E4=BD=93=E6=96=B9= =E6=B3=95=E4=BB=A5=E5=8F=8A=E5=B8=AE=E5=8A=A9=E8=AF=B7=E5=8F=82=E8=80=83 JAVA API=E6=96=87=E6=A1=A3 |
Java API =E5=B8=AE=E5=8A=A9=E6=96=87=E6=A1=A3= =E3=80=82 |
=E8=AF=B4=E6=98=8E=EF=BC=9A
Smartbi =E6=8F=90=E4=BE=9B=E5=AF=BC=E5=85=A5EXCEL=E4=BF=A1=E6=81=AF=E5= =AE=9E=E7=8E=B0=E7=94=A8=E6=88=B7=E4=BF=A1=E6=81=AF=E5=90=8C=E6=AD=A5=E5=8A= =9F=E8=83=BD=E3=80=82
=E5=AE=9E=E7=8E=B0=E6=AD=A5=E9=AA=A4=EF=BC=9A
1=E3=80=81=E7=99=BB=E5=BD=95Smartbi=EF=BC=8C=E5=8F=82=E8=80=83=E5=AF=BC=E5=85=A5=E7=94=A8=E6= =88=B7=E4=BF=A1=E6=81=AF=E3=80=82
=E4=B8=8B=E9=9D=A2=E5=AF=B9=E6=A8=A1=E7=89=88=E6=96=87=E4=BB=B6=E8=BF=9B= =E8=A1=8C=E8=AF=A6=E7=BB=86=E8=AF=B4=E6=98=8E=EF=BC=9A=E8=AF=A5=E6=96=87=E4= =BB=B6=E6=9C=89=E4=B8=89=E4=B8=AAsheet=E9=A1=B5=EF=BC=8C=E5=88=86=E5=88=AB= =E4=B8=BA=EF=BC=9A=E7=94=A8=E6=88=B7=E3=80=81=E7=BB=84=E3=80=81=E8=A7=92=E8= =89=B2=EF=BC=8C=E4=BB=A5=E4=B8=8B=E5=88=86=E5=88=AB=E4=BB=8E=E7=94=A8=E6=88= =B7=E3=80=81=E7=BB=84=E3=80=81=E8=A7=92=E8=89=B2=E4=B8=89=E6=96=B9=E9=9D=A2= =E4=BB=8B=E7=BB=8D=E5=AF=BC=E5=85=A5=E4=BF=A1=E6=81=AF=E8=AF=A5=E5=A6=82=E4= =BD=95=E5=A1=AB=E5=86=99=E3=80=82
1) =E7=94=A8=E6=88=B7=EF=BC=8C=E6=A0=BC=E5=BC=8F=E5=A6=82=E4=B8=8B=EF=BC= =9A
2) =E7=94=A8=E6=88=B7=E7=BB=84=EF=BC=8C=E6=A0=BC=E5=BC=8F=E5=A6=82=E4=B8= =8B=EF=BC=9A
3) =E8=A7=92=E8=89=B2=EF=BC=8C=E6=A0=BC=E5=BC=8F=E5=A6=82=E4=B8=8B=EF=BC= =9A
=E8=AF=B4=E6=98=8E=EF=BC=9A
=E5=AE=9E=E9=99=85=E9=A1=B9=E7=9B=AE=E4=B8=AD=E5=BE=80=E5=BE=80=E5=AD=98= =E5=9C=A8=E5=A4=9A=E4=B8=AA=E7=B3=BB=E7=BB=9F=E9=9C=80=E8=A6=81=E7=BB=9F=E4= =B8=80=E7=99=BB=E5=BD=95=E8=AE=A4=E8=AF=81=EF=BC=8C=E5=AE=A2=E6=88=B7=E8=A6= =81=E6=B1=82=E5=B0=86=E6=9F=90=E4=B8=AA=E7=B3=BB=E7=BB=9F=E4=BD=9C=E4=B8=BA= =E7=BB=9F=E4=B8=80=E7=99=BB=E5=BD=95=E8=AE=A4=E8=AF=81=E5=B9=B3=E5=8F=B0=EF= =BC=8C=E5=85=B6=E4=BD=99=E7=B3=BB=E7=BB=9F=E8=AE=BF=E9=97=AE=E6=AD=A4=E7=B3= =BB=E7=BB=9F=E6=9D=A5=E8=BF=9B=E8=A1=8C=E7=99=BB=E5=BD=95=E8=AE=A4=E8=AF=81= =E3=80=82=E8=BF=99=E7=A7=8D=E6=83=85=E5=86=B5=E4=B8=8B=EF=BC=8C=E4=B8=8D=E9= =9C=80=E8=A6=81=E5=86=8D=E4=BD=BF=E7=94=A8 Smartbi =E4=BA=A7=E5=93=81=E7=9A= =84=E7=94=A8=E6=88=B7=E7=AE=A1=E7=90=86=E6=A8=A1=E5=9D=97=E6=9D=A5=E7=AE=A1= =E7=90=86=E7=BB=84=E5=92=8C=E7=94=A8=E6=88=B7=EF=BC=8C=E4=BD=86=E8=BF=98=E9= =9C=80=E8=A6=81=E4=BF=9D=E7=95=99=E9=80=9A=E8=BF=87=E8=A7=92=E8=89=B2=E6=9D= =A5=E8=AE=BE=E7=BD=AE=E6=93=8D=E4=BD=9C=E6=9D=83=E9=99=90=E3=80=82Smartbi = =E7=94=A8=E6=88=B7=E7=AE=A1=E7=90=86=E6=A8=A1=E5=9D=97=E4=B8=BA=E4=BA=86=E5= =BA=94=E5=AF=B9=E8=BF=99=E7=A7=8D=E9=9C=80=E6=B1=82=EF=BC=8C=E6=8F=90=E4=BE= =9B=E4=BA=86=E4=B8=80=E4=B8=AA=E5=8F=AF=E4=BB=A5=E6=A0=B9=E6=8D=AE=E9=9C=80= =E8=A6=81=E6=89=A9=E5=85=85=E7=9A=84=E7=94=A8=E6=88=B7=E9=AA=8C=E8=AF=81=E6= =96=B9=E5=BC=8F=EF=BC=8C=E8=AE=A9=E9=A1=B9=E7=9B=AE=E8=83=BD=E6=A0=B9=E6=8D= =AE=E5=AE=9E=E9=99=85=E6=83=85=E5=86=B5=E5=BC=80=E5=8F=91=E4=B8=8D=E5=90=8C= =E7=9A=84=E9=9C=80=E6=B1=82=E3=80=82=E5=A6=82=E4=B8=8B=E5=9B=BE=E6=89=80=E7= =A4=BA=EF=BC=8C=E6=A0=B9=E6=8D=AE=E5=AE=9E=E9=99=85=E6=83=85=E5=86=B5=E6=89= =A9=E5=B1=95=E5=BC=80=E5=8F=91=E5=AE=9E=E7=8E=B0=E6=8E=A5=E5=8F=A3=E7=B1=BB= =EF=BC=8C=E5=8D=B3=E5=8F=AF=E4=BD=BF=E7=94=A8=E5=85=B6=E4=BB=96=E7=B3=BB=E7= =BB=9F=E7=94=A8=E6=88=B7=E9=AA=8C=E8=AF=81=E5=B9=B3=E5=8F=B0=E3=80=82=E5=9C= =A8 Smartbi =E7=94=A8=E6=88=B7=E7=AE=A1=E7=90=86=E6=A8=A1=E5=9D=97=E4=B8=AD= =E6=B7=BB=E5=8A=A0=E8=87=AA=E5=AE=9A=E4=B9=89=E7=9A=84=E8=BA=AB=E4=BB=BD=E9= =AA=8C=E8=AF=81=E7=B1=BB=EF=BC=8C=E5=B9=B6=E5=B0=86=E7=AC=AC=E4=B8=89=E6=96= =B9=E7=B3=BB=E7=BB=9F=E7=94=A8=E6=88=B7=E9=AA=8C=E8=AF=81=E5=B9=B3=E5=8F=B0= =E4=B8=8A=E7=9A=84=E7=94=A8=E6=88=B7=E3=80=81=E7=BB=84=E3=80=81=E8=A7=92=E8= =89=B2=E7=AD=89=E4=BF=A1=E6=81=AF=E5=90=8C=E6=AD=A5=E5=88=B0 Smartbi =E7=94= =A8=E6=88=B7=E7=AE=A1=E7=90=86=E6=A8=A1=E5=9D=97=E4=B8=AD=EF=BC=8C=E5=B9=B6= =E5=AE=9E=E7=8E=B0=E7=99=BB=E5=BD=95=E3=80=82
=E5=AE=9E=E7=8E=B0=E6=AD=A5=E9=AA=A4=EF=BC=9A
=E6=B3=A8=E6=84=8F=E4=BA=8B=E9=A1=B9=EF=BC=9A
=E5=85=B7=E4=BD=93=E6=8E=A5=E5=8F=A3=E6=96=B9=E6=B3=95=E5=92=8C=E7=A4=BA= =E4=BE=8B=E7=B1=BB=E8=AF=B7=E5=8F=82=E8=80=83 =E7=AC= =AC=E4=B8=89=E6=96=B9=E7=94=A8=E6=88=B7=E9=AA=8C=E8=AF=81API=E6=96=87=E6=A1= =A3=E3=80=82
=E8=AF=B4=E6=98=8E=EF=BC=9A
=E5=AE=9E=E9=99=85=E9=A1=
=B9=E7=9B=AE=E4=B8=AD=E5=BE=80=E5=BE=80=E5=AD=98=E5=9C=A8=E5=A4=9A=E4=B8=AA=
=E7=B3=BB=E7=BB=9F=E9=9C=80=E8=A6=81=E7=BB=9F=E4=B8=80=E6=9D=83=E9=99=90=E8=
=AE=A4=E8=AF=81=EF=BC=8C=E5=AE=A2=E6=88=B7=E8=A6=81=E6=B1=82=E5=B0=86=E6=9F=
=90=E4=B8=AA=E7=B3=BB=E7=BB=9F=E4=BD=9C=E4=B8=BA=E7=BB=9F=E4=B8=80=E8=AE=A4=
=E8=AF=81=E5=B9=B3=E5=8F=B0=EF=BC=8C Smartbi =E4=B8=BA=E4=BA=86=E5=BA=94=E5=
=AF=B9=E8=BF=99=E7=A7=8D=E9=9C=80=E6=B1=82=EF=BC=8C=E6=8F=90=E4=BE=9B=E4=BA=
=86=E4=B8=80=E4=B8=AA=E5=8F=AF=E4=BB=A5=E6=A0=B9=E6=8D=AE=E9=9C=80=E8=A6=81=
=E6=89=A9=E5=85=85=E7=9A=84=E6=9D=83=E9=99=90=E9=AA=8C=E8=AF=81=E6=96=B9=E5=
=BC=8F=EF=BC=8C=E8=AE=A9=E9=A1=B9=E7=9B=AE=E8=83=BD=E6=A0=B9=E6=8D=AE=E5=AE=
=9E=E9=99=85=E6=83=85=E5=86=B5=E5=BC=80=E5=8F=91=E4=B8=8D=E5=90=8C=E7=9A=84=
=E9=9C=80=E6=B1=82=E3=80=82
=E5=AE=9E=E7=8E=B0=E6=AD=A5=E9=AA= =A4=EF=BC=9A
=E6=B3=A8=E6=84=8F=E4=BA=8B=E9=A1=B9=EF=BC=9A
=E5=85=B7=E4=BD=93=E6=8E=A5=E5=8F=A3=E6=96=B9=E6=B3=95=E5=92=8C=E7=A4=BA= =E4=BE=8B=E7=B1=BB=E8=AF=B7=E5=8F=82=E8=80=83 =E7=AC=AC=E4=B8=89=E6=96=B9=E6=9D=83=E9=99=90=E9=AA=8C=E8=AF=81API=E6= =96=87=E6=A1=A3=E3=80=82