|
模式三打包后点登录没反应,没有跳到首页- 2017-08-21 14:09:45 加载模块:/UI2/portal/base/login ...
- 2017-08-21 14:09:45 加载模块:/UI2/system/service/common ...
- 2017-08-21 14:09:45 加载模块:/UI2/system/resources ...
- 2017-08-21 14:09:45 加载模块:/UI2/system/resources
- 2017-08-21 14:09:45 加载模块:/UI2/system/service/common
- 2017-08-21 14:09:45 加载模块:/UI2/portal/base/login
- 2017-08-21 14:09:45 加载模块:/system/logic/code/interceptor ...
- 2017-08-21 14:09:46 [SQL Time]sql 执行时间:5ms, exec KSQL: select case when UPPER(p.sLoginName)=:name then 1 when UPPER(p.sCode)=:name then 2 else 3 end as odr , mo, mo.sFID, mo.sFName, mo.sFCode, p.* from SA_OPPerson p join SA_OPOrg mo ON p.sMainOrgID = mo where (UPPER(p.sLoginName)=:name or UPPER(p.sCode)=:name) and p.sValidState=1 order by odr
- --> sql:SELECT CASE WHEN UPPER(p.SLOGINNAME) = ? THEN ? WHEN UPPER(p.SCODE) = ? THEN ? ELSE ? END AS odr, mo.sID, mo.sFID AS sFID, mo.sFName AS sFName, mo.SFCODE AS sFCode, p.sID AS p, p.SNAME AS sName, p.SCODE AS sCode, p.SIDCARD AS sIDCard, p.SNUMB AS sNumb, p.SLOGINNAME AS sLoginName, p.SPASSWORD AS sPassword, p.SPASSWORDTIMELIMIT AS sPasswordTimeLimit, p.SPASSWORDMODIFYTIME AS sPasswordModifyTime, p.SMAINORGID AS sMainOrgID, p.SSAFELEVELID AS sSafeLevelID, p.SSEQUENCE AS sSequence, p.SVALIDSTATE AS sValidState, p.SDESCRIPTION AS sDescription, p.SPHOTO AS sPhoto, p.SPHOTOLASTMODIFIED AS sPhotoLastModified, p.SSEX AS sSex, p.SBIRTHDAY AS sBirthday, p.SJOINDATE AS sJoinDate, p.SHOMEPLACE AS sHomePlace, p.SCOUNTRY AS sCountry, p.SPROVINCE AS sProvince, p.SCITY AS sCity, p.SDEGREE AS sDegree, p.SGRADUATESCHOOL AS sGraduateSchool, p.SSPECIALITY AS sSpeciality, p.SSCHOOLLENGTH AS sSchoolLength, p.STITLE AS sTitle, p.SMARRIAGE AS sMarriage, p.SCARDNO AS sCardNO, p.SCARDKIND AS sCardKind, p.SFAMILYADDRESS AS sFamilyAddress, p.SZIP AS sZip, p.SMSN AS sMsn, p.SQQ AS sQQ, p.SMAIL AS sMail, p.SMOBILEPHONE AS sMobilePhone, p.SFAMILYPHONE AS sFamilyPhone, p.SOFFICEPHONE AS sOfficePhone, p.SENGLISHNAME AS sEnglishName, p.VERSION AS version FROM SA_OPPerson p JOIN SA_OPOrg mo ON p.SMAINORGID = mo.sID WHERE ( (UPPER(p.SLOGINNAME) = ? ) OR (UPPER(p.SCODE) = ? ) ) AND (p.SVALIDSTATE = ?) ORDER BY odr ASC
- --> binds:[SYSTEM, 1, SYSTEM, 2, 3, SYSTEM, SYSTEM, 1]
- 2017-08-21 14:09:46 [SQL Time]sql 执行时间:1ms, exec KSQL: SELECT p, p.sName AS pname, p.sCode AS pcode, mo, mo.sFID as m_sfid, mo.sFName as m_sfname, mo.sFCode as m_sfcode , a.sOrgFName as agt_fname, a.sOrgFID as agt_fid, a.sProcess as agt_process FROM SA_OPPerson p JOIN SA_OPOrg mo ON p.sMainOrgID = mo JOIN SA_OPOrg pm ON pm.sValidState = 1 AND pm.sPersonID = p AND pm.sOrgKindID = 'psm' JOIN SA_OPAgent a ON a.sOrgFID = pm.sFID AND a.sAgentID = 'PSN01' AND a.sValidState = 1 AND (:now >= a.sStartTime OR a.sStartTime IS NULL) AND (a.sFinishTime IS NULL OR a.sFinishTime >= :now)
- --> sql:SELECT p.sID, p.SNAME AS pname, p.SCODE AS pcode, mo.sID, mo.sFID AS m_sfid, mo.sFName AS m_sfname, mo.SFCODE AS m_sfcode, a.SORGFNAME AS agt_fname, a.SORGFID AS agt_fid, a.SPROCESS AS agt_process FROM SA_OPPerson p JOIN SA_OPOrg mo ON p.SMAINORGID = mo.sID JOIN SA_OPOrg pm ON (pm.SVALIDSTATE = ?) AND (pm.SPERSONID = p.sID) AND (pm.SORGKINDID = ?) JOIN SA_OPAgent a ON (a.SORGFID = pm.sFID) AND (a.SAGENTID = ?) AND (a.SVALIDSTATE = ?) AND ( ( ? >= a.SSTARTTIME) OR (a.SSTARTTIME IS NULL) ) AND ( (a.SFINISHTIME IS NULL) OR (a.SFINISHTIME >= ? ) )
- --> binds:[1, psm, PSN01, 1, 2017-08-21 14:09:46.063, 2017-08-21 14:09:46.063]
- 2017-08-21 14:09:46 [SQL Time]sql 执行时间:5ms, exec KSQL: select pm.sFID AS pm_fid,pm.sFName AS pm_fname,pm.sFCode AS pm_fcode, r, r.sCode as r_sCode, r.sName as r_sName, perm1.* from SA_OPOrg pm OPTIONAL JOIN SA_OPAuthorize au ON pm.sFID like concat(au.sOrgFID, '%') JOIN SA_OPRole r ON (au.sAuthorizeRoleID=r AND r.sValidState = 1) OPTIONAL JOIN SA_OPPermission perm1 ON (perm1.sPermissionRoleID=r and perm1.sValidState=1) WHERE pm.sValidState=1 and pm.sPersonID=:personId and pm.sOrgKindID=:kind
- --> sql:SELECT pm.sFID AS pm_fid, pm.sFName AS pm_fname, pm.SFCODE AS pm_fcode, r.sID, r.SCODE AS r_sCode, r.SNAME AS r_sName, perm1.sID AS perm1, perm1.sPermissionRoleID AS sPermissionRoleID, perm1.SPROCESS AS sProcess, perm1.SACTIVITYFNAME AS sActivityFName, perm1.SACTIVITY AS sActivity, perm1.SACTIONSNAMES AS sActionsNames, perm1.SACTIONS AS sActions, perm1.SSEMANTICDP AS sSemanticDP, perm1.SPERMISSIONKIND AS sPermissionKind, perm1.SDESCRIPTION AS sDescription, perm1.SSEQUENCE AS sSequence, perm1.SVALIDSTATE AS sValidState, perm1.VERSION AS version FROM SA_OPOrg pm LEFT JOIN SA_OPAuthorize au ON pm.sFID LIKE au.SORGFID + ? JOIN SA_OPRole r ON (au.sAuthorizeRoleID = r.sID) AND (r.SVALIDSTATE = ?) LEFT JOIN SA_OPPermission perm1 ON (perm1.sPermissionRoleID = r.sID) AND (perm1.SVALIDSTATE = ?) WHERE (pm.SVALIDSTATE = ?) AND (pm.SPERSONID = ? ) AND (pm.SORGKINDID = ? )
- --> binds:[%, 1, 1, 1, PSN01, psm]
- 2017-08-21 14:09:46 [SQL Time]sql 执行时间:1ms, exec KSQL: select o.sFID, o.sFName, o.sFCode from SA_OPOrg o where o.sValidState=1 and o.sPersonID=:personId
- --> sql:SELECT o.sFID AS sFID, o.sFName AS sFName, o.SFCODE AS sFCode FROM SA_OPOrg o WHERE (o.SVALIDSTATE = ?) AND (o.SPERSONID = ? )
- --> binds:[1, PSN01]
- 2017-08-21 14:09:46 [SQL Time]sql 执行时间:1ms, exec KSQL: select r, par, par.sCode as p_sCode, par.sName as p_sName, p.* from SA_OPRole par optional join SA_OPPermission p on p.sPermissionRoleID=par and par.sValidState = 1 and p.sValidState=1 join SA_OPRole r on par=r.sParentRole AND r IN ('84696197F4FD4D60ACDFE27ACF9C7B07', 'E9FD20DF69784331A0CE6C401B84D658', 'RL03-demo', '48EB2EAD286044B28EBC03DD29231B50', '29945A90F2414C50B96D88AE1970A8C0', '6DB068CEC83148B3845C8A13663D7879', 'RL-SYSTEM', 'RL-USER')
- --> sql:SELECT r.sID, par.sID, par.SCODE AS p_sCode, par.SNAME AS p_sName, p.sID AS p, p.sPermissionRoleID AS sPermissionRoleID, p.SPROCESS AS sProcess, p.SACTIVITYFNAME AS sActivityFName, p.SACTIVITY AS sActivity, p.SACTIONSNAMES AS sActionsNames, p.SACTIONS AS sActions, p.SSEMANTICDP AS sSemanticDP, p.SPERMISSIONKIND AS sPermissionKind, p.SDESCRIPTION AS sDescription, p.SSEQUENCE AS sSequence, p.SVALIDSTATE AS sValidState, p.VERSION AS version FROM SA_OPRole par LEFT JOIN SA_OPPermission p ON (p.sPermissionRoleID = par.sID) AND (par.SVALIDSTATE = ?) AND (p.SVALIDSTATE = ?) JOIN (SA_OPRole r LEFT JOIN SA_OPParentRole SA_OPParentRole__1 ON r.sID = SA_OPParentRole__1.sRoleID ) ON (par.sID = SA_OPParentRole__1.sParentRoleID) AND ( r.sID IN (?, ?, ?, ?, ?, ?, ?, ?) )
- --> binds:[1, 1, 84696197F4FD4D60ACDFE27ACF9C7B07, E9FD20DF69784331A0CE6C401B84D658, RL03-demo, 48EB2EAD286044B28EBC03DD29231B50, 29945A90F2414C50B96D88AE1970A8C0, 6DB068CEC83148B3845C8A13663D7879, RL-SYSTEM, RL-USER]
- 2017-08-21 14:09:46 [SQL Time]sql 执行时间:0ms, exec KSQL: select m.*,mt.sCode from SA_OPManagement m optional join SA_OPManageType mt on m.sManageTypeID=mt where '/ORG01.ogn/PSN01@ORG01.psm' like concat(m.sOrgFID, '%')
- --> sql:SELECT m.sID AS m, m.SORGID AS sOrgID, m.SORGFID AS sOrgFID, m.SORGNAME AS sOrgName, m.SORGFNAME AS sOrgFName, m.SMANAGEORGID AS sManageOrgID, m.SMANAGEORGNAME AS sManageOrgName, m.SMANAGEORGFID AS sManageOrgFID, m.SMANAGEORGFNAME AS sManageOrgFName, m.SMANAGETYPEID AS sManageTypeID, m.SCREATORFID AS sCreatorFID, m.SCREATORFNAME AS sCreatorFName, m.SCREATETIME AS sCreateTime, m.VERSION AS version, mt.SCODE AS sCode FROM SA_OPManagement m LEFT JOIN SA_OPManageType mt ON m.SMANAGETYPEID = mt.sID WHERE ? LIKE m.SORGFID + ?
- --> binds:[/ORG01.ogn/PSN01@ORG01.psm, %]
- 2017-08-21 14:09:46 [SQL Time]sql 执行时间:5ms, exec KSQL: select SA_OPPerson, SA_OPPerson.sName from SA_OPPerson SA_OPPerson where SA_OPPerson.sValidState=1
- --> sql:SELECT SA_OPPerson.sID, SA_OPPerson.SNAME AS sName FROM SA_OPPerson SA_OPPerson WHERE SA_OPPerson.SVALIDSTATE = ?
- --> binds:[1]
- 2017-08-21 14:09:46 [SQL Time]sql 执行时间:11ms, exec KSQL: select DISTINCT o.sPersonID as SA_OPPerson, o.sName from SA_OPOrg o where o.sValidState=1 and o.sOrgKindID='psm'
- --> sql:SELECT DISTINCT o.SPERSONID AS SA_OPPerson, o.SNAME AS sName FROM SA_OPOrg o WHERE (o.SVALIDSTATE = ?) AND (o.SORGKINDID = ?)
- --> binds:[1, psm]
- 2017-08-21 14:09:46 [SQL Time]sql 执行时间:4ms, exec KSQL: select SA_OPPerson, SA_OPPerson.sName from SA_OPPerson SA_OPPerson where SA_OPPerson.sValidState > 0
- --> sql:SELECT SA_OPPerson.sID, SA_OPPerson.SNAME AS sName FROM SA_OPPerson SA_OPPerson WHERE SA_OPPerson.SVALIDSTATE > ?
- --> binds:[0]
- 2017-08-21 14:09:46 [SQL Time]sql 执行时间:2ms, exec KSQL: select SA_OPOrgVer.* from SA_OPOrgVer SA_OPOrgVer
- --> sql:SELECT SA_OPOrgVer.sID AS SA_OPOrgVer, SA_OPOrgVer.SNAME AS sName, SA_OPOrgVer.VERSION AS version, SA_OPOrgVer.SCODE AS sCode FROM SA_Code SA_OPOrgVer WHERE SA_OPOrgVer.sType = 'orgVersion'
- --> binds:[]
- 2017-08-21 14:09:46 加载模块:/portal2/process/portal ...
- 2017-08-21 14:09:46 加载模块:/portal2/process ...
- 2017-08-21 14:09:46 加载模块:/portal2 ...
- 2017-08-21 14:09:46 加载模块:/portal2/logic/code ...
- 2017-08-21 14:09:46 加载模块:/portal2/logic ...
- 2017-08-21 14:09:46 加载模块:/portal2/data ...
- 2017-08-21 14:09:46 加载模块:/portal2/ontology ...
- 2017-08-21 14:09:46 加载模块:/portal2/logic/action ...
- 2017-08-21 14:09:46 [SQL Time]sql 执行时间:1ms, exec KSQL: SELECT s1.* FROM Portal2Profiles s1 where s1.sPersonID=:personID and s1.sPublishType=:type
- --> sql:SELECT s1.sID AS s1, s1.VERSION AS version, s1.SPERSONID AS sPersonID, s1.STHEMEACTIVITY AS sThemeActivity, s1.SFUNCTREE AS sFunctree, s1.SPORTAL AS sPortal, s1.SOTHER AS sOther, s1.SPUBLISHTYPE AS sPublishType, s1.STHEMENAME AS sThemeName FROM SA_Portal2Profiles s1 WHERE (s1.SPERSONID = ? ) AND (s1.SPUBLISHTYPE = ? )
- --> binds:[PSN01, person4portal3]
复制代码
|
|