xiaoshu-app/scripts/cloud/account-deletion-ops.js

async function opsDeletion(context,input,payload,process=false){
 requireRole(context,['ops-manager']);const co=companyIdOf(context,input);if(!co)fail(400,'缺少帐套');
 if(process)return(await Psql.one('SELECT xs_process_deletion($1,$2,$3,$4,$5,$6) AS result',[co,context.current.id,text(input.targetId),number(payload.version),text(payload.status),reasonOf(input)])).result;
 const page=Math.max(1,number(input.page,1));return{items:await Psql.query('SELECT r.*,u."legacyUserId",COALESCE(u."realName",u.nickname,u.username) AS name FROM "AccountDeletionRequest" r LEFT JOIN "_User" u ON u.company=r.company AND u."objectId"=r."userId" WHERE r.company=$1 ORDER BY r."createdAt" DESC LIMIT 50 OFFSET $2',[co,(page-1)*50])};
}