| 123456789101112 |
- async function nodeUnitPage(input,current) {
- const uid = await authorizeRequestedUser(current,input.userId || input.uid); const paging = pageInput(input); const bindingId = String(input.bindingId || '').trim(); let parentId = number(input.pid); let binding = null;
- const bindingRows=await Psql.query('SELECT b.* FROM "CourseBinding" b JOIN "CommonModel" c ON c."company"=b."company" AND c."modelId"=58 AND c."itemId"=b."id" WHERE b."company"=$1 AND b."yhid"::text=$2 AND b."enrollmentStatus"=\'active\' AND c."status"=99 AND (($3<>\'\' AND (b."id"::text=$3 OR b."objectId"=$3)) OR ($3=\'\' AND b."kcid"::text=$4))',[DEFAULT_COMPANY_ID,String(uid),bindingId,String(parentId)]);
- if(bindingRows.length>1)fail(409,'该内容有多个开课分类,请选择具体开课记录');binding=bindingRows[0]||null;
- if (!binding) fail(403,'该课程尚未分配给当前学员'); parentId = number(binding.kcid,parentId);
- if (parentId) {
- const countRow = await Psql.one('SELECT COUNT(*)::int AS total FROM "Node" WHERE "company"=$1 AND CAST("parentId" AS text)=$2',[DEFAULT_COMPANY_ID,String(parentId)]); const total = number(countRow.total);
- if (total) { const rows = await Psql.query('SELECT n.*,COALESCE(w.total,0)::int AS "total",COALESCE(l.learned,0)::int AS "yx_word" FROM "Node" n LEFT JOIN LATERAL (SELECT COUNT(*)::int AS total FROM "CommonModel" c WHERE c."company"=$1 AND CAST(c."modelId" AS text)=\'52\' AND CAST(c."nodeId" AS text)=CAST(n."nodeId" AS text)) w ON TRUE LEFT JOIN LATERAL (SELECT COUNT(DISTINCT CAST(p."scid" AS text))::int AS learned FROM "PracticeRecord" p JOIN "CommonModel" c ON c."company"=$1 AND CAST(c."modelId" AS text)=\'52\' AND CAST(c."generalId" AS text)=CAST(p."scid" AS text) AND CAST(c."nodeId" AS text)=CAST(n."nodeId" AS text) WHERE p."company"=$1 AND CAST(p."yhid" AS text)=$3 AND CASE WHEN CAST(p."xxcs" AS text) ~ \'^[0-9]+(?:\\.[0-9]+)?$\' THEN CAST(p."xxcs" AS numeric) ELSE 0 END>0) l ON TRUE WHERE n."company"=$1 AND CAST(n."parentId" AS text)=$2 ORDER BY CASE WHEN CAST(n."orderId" AS text) ~ \'^-?[0-9]+$\' THEN CAST(n."orderId" AS numeric) ELSE 0 END ASC,CASE WHEN CAST(n."nodeId" AS text) ~ \'^-?[0-9]+$\' THEN CAST(n."nodeId" AS numeric) ELSE 0 END ASC LIMIT $4 OFFSET $5',[DEFAULT_COMPANY_ID,String(parentId),String(uid),paging.size,(paging.index - 1) * paging.size]); return { rows:rows.map((source) => { const row = legacyAliases(source,'Node'); row.total = number(source.total); row.yx_word = number(source.yx_word); row.process = row.total ? Math.round(row.yx_word / row.total * 100) : 0; return row; }),page:{itemCount:total,pageCount:Math.ceil(total / paging.size),pageIndex:paging.index,pageSize:paging.size} }; }
- }
- const assigned = courseAssignedUnits(binding.syjd); const total = assigned.length; if (!total) return {rows:[],page:{itemCount:0,pageCount:0,pageIndex:paging.index,pageSize:paging.size}}; const pageUnits = assigned.slice((paging.index - 1) * paging.size,paging.index * paging.size),unitIds=pageUnits.map((unit)=>unit.id);
- const wordRows = await Psql.query('SELECT CAST(c."nodeId" AS text) AS id,COUNT(*)::int AS total FROM "CommonModel" c WHERE c."company"=$1 AND CAST(c."modelId" AS text)=\'52\' AND CAST(c."nodeId" AS text)=ANY($2::text[]) GROUP BY CAST(c."nodeId" AS text)',[DEFAULT_COMPANY_ID,unitIds]); const learnedRows = await Psql.query('SELECT CAST(c."nodeId" AS text) AS id,COUNT(DISTINCT CAST(p."scid" AS text))::int AS learned FROM "PracticeRecord" p JOIN "CommonModel" c ON c."company"=$1 AND CAST(c."modelId" AS text)=\'52\' AND CAST(c."generalId" AS text)=CAST(p."scid" AS text) WHERE p."company"=$1 AND CAST(p."yhid" AS text)=$2 AND CAST(c."nodeId" AS text)=ANY($3::text[]) AND CASE WHEN CAST(p."xxcs" AS text) ~ \'^[0-9]+(?:\\.[0-9]+)?$\' THEN CAST(p."xxcs" AS numeric) ELSE 0 END>0 GROUP BY CAST(c."nodeId" AS text)',[DEFAULT_COMPANY_ID,String(uid),unitIds]); const totals=new Map(wordRows.map((row)=>[String(row.id),number(row.total)])),learned=new Map(learnedRows.map((row)=>[String(row.id),number(row.learned)])); const rows=pageUnits.map((unit)=>{const count=totals.get(unit.id)||0,done=learned.get(unit.id)||0;return legacyAliases({nodeId:number(unit.id),nodeName:unit.name,parentId,total:count,yx_word:done,process:count?Math.round(done/count*100):0},'Node');}); return {rows,page:{itemCount:total,pageCount:Math.ceil(total/paging.size),pageIndex:paging.index,pageSize:paging.size}};
- }
|