create or replace function SF_CA_ZDQMSC2
(
  PCJBM00  varchar2,                  -- 厂家编码
  PCZY000  varchar2,                  -- 操作员编号
  POPENID  varchar2
)
-- modification history
-- linshu       2022.08.19  Create:推送自动签名授权;  for YF9-20220722-002
return varchar2 is
  LS_JSON00 varchar2(2000);
  LS_CAID00 BM_TYZD00.MC0000%type;
  LS_SECRET BM_TYZD00.MC0000%type;
  LS_OPENID BM_SZZSXX.OPENID%type;

begin
  select nvl(max(mc0000),'0') into LS_SECRET from BM_TYZD00 where BH0000 = 'CA_clientSecret' and ZDMC00='CA认证接口配置';
  select nvl(max(mc0000),'0') into LS_CAID00 from BM_TYZD00 where BH0000 = 'CA_clientId' and ZDMC00='CA认证接口配置';
  --select MAX(OPENID) into LS_OPENID from BM_SZZSXX where YGBH00 = PCZY000;
  if PCJBM00 = 'YWX' then
    LS_JSON00 :=  '{
                    "head": {
                        "clientId": "'||LS_CAID00||'",'
                      ||'"clientSecret": "'||LS_SECRET||'"
                    },
                    "body": {
                      "openId": "'||POPENID||'",'
                  ||' "sysTag": "his"
                    }
                  }';
  end if;
  return LS_JSON00;
end;