prepare($sql); $st->execute([$assignmentId]); $row = $st->fetch(PDO::FETCH_ASSOC); if(!$row){ echo '

No submission found for this assignment.

'; exit; } $tplRaw = (string)($row['template_json'] ?? ''); $tplDecoded = html_entity_decode($tplRaw, ENT_QUOTES | ENT_HTML5, 'UTF-8'); $tpl = json_decode($tplDecoded, true); if (json_last_error() !== JSON_ERROR_NONE) { echo '

Invalid submission data.

'; exit; } // Normalize to sections array like master-qp-setter-submissions-view.php $sections = []; if (is_array($tpl)) { // Case 1: already an array of sections $isAssoc = fn($arr)=> array_keys($arr)!==range(0,count($arr)-1); if (!empty($tpl) && isset($tpl[0]) && (is_array($tpl[0]) || is_object($tpl[0]))) { $sections = $tpl; } elseif (isset($tpl['sections']) && is_array($tpl['sections'])) { $sections = $tpl['sections']; } } // Load dynamic header details (subject/course/college/exam) $h = null; try { // Preferred: resolve by assignment's exam_subject_id $sqlH = "SELECT e.exam_name, e.academic_year, e.semester, subj.sem_type, subj.subject_code, subj.subject_name, subj.semester AS subject_semester, crs.course_name, col.college_name, col.address, col.location FROM qp_setter_assignments qps LEFT JOIN exam_subjects es ON qps.exam_subject_id = es.exam_subject_id LEFT JOIN subjects subj ON es.subject_id = subj.subject_id LEFT JOIN courses crs ON subj.course_id = crs.course_id LEFT JOIN exams e ON COALESCE(es.exam_id, qps.exam_id) = e.exam_id LEFT JOIN colleges col ON crs.college_id = col.college_id WHERE qps.id = ? LIMIT 1"; $p = $pdo->prepare($sqlH); $p->execute([$assignmentId]); $h = $p->fetch(PDO::FETCH_ASSOC); if (!$h || empty($h['subject_code'])) { // Fallback via pattern -> subject $sqlH = "SELECT e.exam_name, e.academic_year, e.semester, subj.sem_type, subj.subject_code, subj.subject_name, subj.semester AS subject_semester, crs.course_name, col.college_name, col.address, col.location FROM qp_setter_assignments qps LEFT JOIN question_patterns qp ON qps.pattern_id = qp.pattern_id LEFT JOIN subjects subj ON qp.subject_id = subj.subject_id LEFT JOIN courses crs ON subj.course_id = crs.course_id LEFT JOIN colleges col ON crs.college_id = col.college_id LEFT JOIN exams e ON qps.exam_id = e.exam_id WHERE qps.id = ? LIMIT 1"; $p = $pdo->prepare($sqlH); $p->execute([$assignmentId]); $h = $p->fetch(PDO::FETCH_ASSOC); } if (!$h || empty($h['subject_code'])) { // Fallback through question_paper_orders using staff setter $sqlH = "SELECT e.exam_name, e.academic_year, e.semester, subj.sem_type, subj.subject_code, subj.subject_name, subj.semester AS subject_semester, crs.course_name, col.college_name, col.address, col.location FROM qp_setter_assignments qps LEFT JOIN question_paper_orders qpo ON qpo.setter_id = qps.staff_id LEFT JOIN exam_subjects es ON qpo.exam_subject_id = es.exam_subject_id LEFT JOIN subjects subj ON es.subject_id = subj.subject_id LEFT JOIN courses crs ON subj.course_id = crs.course_id LEFT JOIN exams e ON es.exam_id = e.exam_id LEFT JOIN colleges col ON crs.college_id = col.college_id WHERE qps.id = ? LIMIT 1"; $p = $pdo->prepare($sqlH); $p->execute([$assignmentId]); $h = $p->fetch(PDO::FETCH_ASSOC); } } catch (Throwable $e) { $h = null; } function toRomanLocal($num){ $map = ['M'=>1000,'CM'=>900,'D'=>500,'CD'=>400,'C'=>100,'XC'=>90,'L'=>50,'XL'=>40,'X'=>10,'IX'=>9,'V'=>5,'IV'=>4,'I'=>1]; $res=''; foreach($map as $r=>$v){ while($num >= $v){ $res.=$r; $num-=$v; } } return $res?:''; } function toUpperLocal($str){ $s = trim((string)$str); if ($s === '') return ''; return function_exists('mb_strtoupper') ? mb_strtoupper($s, 'UTF-8') : strtoupper($s); } $header = [ 'college_name' => $h['college_name'] ?? 'M.I.E.T. ENGINEERING COLLEGE', 'address' => $h['address'] ?? '', 'location' => $h['location'] ?? '', 'academic_year' => $h['academic_year'] ?? '', 'semester_num' => (int)($h['subject_semester'] ?? ($h['semester'] ?? 0)), 'sem_type' => $h['sem_type'] ?? '', 'course_name' => $h['course_name'] ?? '', 'subject_code' => $h['subject_code'] ?? '', 'subject_name' => $h['subject_name'] ?? '' ]; $header['semester_roman'] = $header['semester_num'] ? toRomanLocal($header['semester_num']) : ''; // Process sections dynamically - use actual section names and question numbers $processedSections = []; $partA = []; $partB = []; foreach ($sections as $sec) { $qs = isset($sec['questions']) && is_array($sec['questions']) ? $sec['questions'] : []; if (empty($qs)) continue; $sectionName = isset($sec['section_name']) ? $sec['section_name'] : 'Section'; $sectionQuestions = []; foreach ($qs as $q) { $qNo = isset($q['question_no']) ? $q['question_no'] : ''; $sectionQuestions[] = $q; // Try to extract numeric part for Part A/B classification if (preg_match('/^(\d+)/', $qNo, $matches)) { $num = (int)$matches[1]; if ($num >= 1 && $num <= 6) { $partA[$qNo] = $q; } elseif ($num >= 7 && $num <= 9) { $partB[$qNo] = $q; } } } if (!empty($sectionQuestions)) { $processedSections[] = [ 'name' => $sectionName, 'questions' => $sectionQuestions ]; } } // If no Part A/B classification worked, use first section as Part A and second as Part B if (empty($partA) && empty($partB) && !empty($processedSections)) { foreach ($processedSections as $idx => $sec) { if ($idx === 0) { // First section as Part A foreach ($sec['questions'] as $i => $q) { $partA[$i+1] = $q; } } elseif ($idx === 1) { // Second section as Part B foreach ($sec['questions'] as $i => $q) { $partB[$i+7] = $q; } } } } // Load marks per question for sections $sectionMarks = []; try { $ps = $pdo->prepare("SELECT ps.section_name, ps.marks_per_question, ps.num_questions, ps.section_total FROM pattern_sections ps JOIN qp_setter_assignments qps ON qps.pattern_id = ps.pattern_id WHERE qps.id = ?"); $ps->execute([$assignmentId]); foreach ($ps->fetchAll(PDO::FETCH_ASSOC) as $r) { $nm = trim((string)($r['section_name'] ?? '')); if ($nm !== '') { $sectionMarks[$nm] = [ 'mpq' => (float)($r['marks_per_question'] ?? 0), 'nq' => (int)($r['num_questions'] ?? 0), 'total' => (float)($r['section_total'] ?? 0) ]; } } } catch (Throwable $e) { $sectionMarks = []; } // Build CO-BTL weightage matrix function norm_btl($v){ $s = strtolower(trim((string)$v)); if ($s==='') return ''; if (strpos($s,'remember')!==false) return 'Remembering'; if (strpos($s,'understand')!==false) return 'Understanding'; if (strpos($s,'apply')!==false) return 'Applying'; if (strpos($s,'analy')!==false) return 'Analyzing'; if (strpos($s,'evaluate')!==false) return 'Evaluating'; if (strpos($s,'creat')!==false) return 'Creating'; if (preg_match('/\bL?1\b/i',$s)) return 'Remembering'; if (preg_match('/\bL?2\b/i',$s)) return 'Understanding'; if (preg_match('/\bL?3\b/i',$s)) return 'Applying'; if (preg_match('/\bL?4\b/i',$s)) return 'Analyzing'; if (preg_match('/\bL?5\b/i',$s)) return 'Evaluating'; if (preg_match('/\bL?6\b/i',$s)) return 'Creating'; return ucfirst($s); } function base_qno($q){ $s=strtolower(trim((string)$q)); $p=explode('-', $s); return $p[0]??$s; } $weight = [ 'Remembering'=>[1=>0,2=>0,3=>0,4=>0,5=>0], 'Understanding'=>[1=>0,2=>0,3=>0,4=>0,5=>0], 'Applying'=>[1=>0,2=>0,3=>0,4=>0,5=>0], 'Analyzing'=>[1=>0,2=>0,3=>0,4=>0,5=>0], 'Evaluating'=>[1=>0,2=>0,3=>0,4=>0,5=>0], 'Creating'=>[1=>0,2=>0,3=>0,4=>0,5=>0], ]; foreach ($processedSections as $sec) { $secName = $sec['name'] ?? ($sec['section_name'] ?? ''); $mpq = isset($sectionMarks[$secName]['mpq']) ? (float)$sectionMarks[$secName]['mpq'] : ( (isset($sectionMarks[$secName]) && is_numeric($sectionMarks[$secName])) ? (float)$sectionMarks[$secName] : 0.0 ); if ($mpq <= 0) $mpq = 1.0; $seen = []; $qs = isset($sec['questions']) && is_array($sec['questions']) ? $sec['questions'] : []; foreach ($qs as $q) { $bq = base_qno($q['question_no'] ?? ''); if (isset($seen[$bq])) continue; // count OR variants once $seen[$bq] = true; $coRaw = $q['co'] ?? ($q['co_codes'] ?? ''); $btlRaw = $q['btl'] ?? ($q['cognitive_level'] ?? ''); $btl = norm_btl($btlRaw); if ($btl === '') continue; $cos = []; if (is_string($coRaw) && preg_match_all('/CO\s*([1-5])|\b([1-5])\b/i', $coRaw, $m)) { foreach ($m[1] as $i=>$g1){ $n = $g1 !== '' ? $g1 : $m[2][$i]; if ($n !== '') $cos[(int)$n]=true; } } if (empty($cos)) $cos[1]=true; foreach (array_keys($cos) as $coNum) { if ($coNum>=1 && $coNum<=5) $weight[$btl][$coNum] += $mpq; } } } // Very simple renderer for print; adjust sections as needed ?> Question Paper
prepare("SELECT col.college_name, col.address, col.location, col.logo, col.seal, c.logo AS staff_logo, c.seal AS staff_seal FROM qp_setter_assignments qps LEFT JOIN question_patterns qp ON qps.pattern_id = qp.pattern_id LEFT JOIN exam_subjects es ON qp.exam_subject_id = es.exam_subject_id LEFT JOIN subjects subj ON es.subject_id = subj.subject_id LEFT JOIN courses crs ON subj.course_id = crs.course_id LEFT JOIN colleges col ON crs.college_id = col.college_id LEFT JOIN staff s ON qps.staff_id = s.staff_id LEFT JOIN colleges c ON s.college_id = c.college_id WHERE qps.id = ? LIMIT 1"); $bq->execute([$assignmentId]); $branding = $bq->fetch(PDO::FETCH_ASSOC); if ($branding) { if (empty($branding['logo']) && !empty($branding['staff_logo'])) { $branding['logo'] = $branding['staff_logo']; } if (empty($branding['seal']) && !empty($branding['staff_seal'])) { $branding['seal'] = $branding['staff_seal']; } } } catch (Throwable $e) { $branding = null; } // Resolve asset PUBLIC URLs using BASE_URL, prefer data/college/, fallback to uploads/ $logoPath = ''; $sealPath = ''; $publicBase = (defined('BASE_URL') ? rtrim(BASE_URL, '/').'/' : '../../'); if (!empty($branding['logo'])) { $cand1 = realpath(__DIR__ . '../../data/college/' . $branding['logo']); $cand2 = realpath(__DIR__ . '/../../uploads/' . $branding['logo']); if ($cand1 && is_file($cand1)) { $logoPath = $publicBase . 'data/college/' . rawurlencode($branding['logo']); } elseif ($cand2 && is_file($cand2)) { $logoPath = $publicBase . 'uploads/' . rawurlencode($branding['logo']); } else { $logoPath = $publicBase . 'data/college/' . rawurlencode($branding['logo']); } } if (!empty($branding['seal'])) { $scand1 = realpath(__DIR__ . '/../../data/college/' . $branding['seal']); $scand2 = realpath(__DIR__ . '/../../uploads/' . $branding['seal']); if ($scand1 && is_file($scand1)) { $sealPath = $publicBase . 'data/college/' . rawurlencode($branding['seal']); } elseif ($scand2 && is_file($scand2)) { $sealPath = $publicBase . 'uploads/' . rawurlencode($branding['seal']); } else { $sealPath = $publicBase . 'data/college/' . rawurlencode($branding['seal']); } } ?>
Logo
LOGO
(AUTONOMOUS)
(Use of Charts/Tables is permitted)
Seal
SEAL
Reg. No.
Date : ________
Session : FN
Time : 2 Hrs.
Maximum Marks: 60
$items): $first = $items[0]; $coCell = (string)($first['co'] ?? ($first['co_codes'] ?? '')); $btlCell = (string)($first['btl'] ?? ($first['cognitive_level'] ?? '')); ?>
Q. No.QuestionsCOBTL
1): ?>
(a)
Or
(b)
Question Paper
No structured sections found in submission.
Weightage of CO
'Remember (L1)', 'Understanding'=>'Understand (L2)', 'Applying'=>'Apply (L3)', 'Analyzing'=>'Analyze (L4)', 'Evaluating'=>'Evaluate (L5)', 'Creating'=>'Create (L6)' ]; $grandTotal = 0; foreach ($btlOrder as $b) { $co1 = $weight[$b][1]; $co2 = $weight[$b][2]; $co3 = $weight[$b][3]; $co4 = $weight[$b][4]; $co5 = $weight[$b][5]; $rowTotal = $co1 + $co2 + $co3 + $co4 + $co5; $grandTotal += $rowTotal; ?> 0,2=>0,3=>0,4=>0,5=>0]; foreach ($weight as $b=>$arr) { foreach ($arr as $co=>$v) { $sum[$co]+=$v; } } $sumTotal = $sum[1]+$sum[2]+$sum[3]+$sum[4]+$sum[5]; ?>
BTLCO1CO2CO3CO4CO5Total MarksTotal Marks (%)
0 ? round(($rowTotal/$grandTotal)*100) . '%' : ''; ?>
Total Marks