prepare($sql_parts); $stmt_parts->execute([$model_id]); $parts = $stmt_parts->fetchAll(PDO::FETCH_ASSOC); if (!$parts) { echo "해당 모델의 부품 정보가 없습니다."; exit; } echo '
'; foreach ($parts as $part) { echo '
'; // 2단계 부품 정보 echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '
중분류 부품명규격단위수량단가비고
' . htmlspecialchars($part['part_name'], ENT_QUOTES, 'UTF-8') . '' . htmlspecialchars($part['spec'], ENT_QUOTES, 'UTF-8') . '' . htmlspecialchars($part['unit'], ENT_QUOTES, 'UTF-8') . '' . htmlspecialchars($part['quantity'], ENT_QUOTES, 'UTF-8') . '' . htmlspecialchars($part['unitprice'], ENT_QUOTES, 'UTF-8') . '' . htmlspecialchars($part['memo'], ENT_QUOTES, 'UTF-8') . '
'; // 3단계 하위 부품 조회 $sql_sub = "SELECT * FROM " . $DB . ".parts_sub WHERE part_id = ? AND is_deleted = 0 ORDER BY subpart_id ASC"; $stmt_sub = $pdo->prepare($sql_sub); $stmt_sub->execute([$part['part_id']]); $subparts = $stmt_sub->fetchAll(PDO::FETCH_ASSOC); if ($subparts) { echo '
'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; foreach ($subparts as $sub) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } echo ''; echo '
부품명재질연신율 합전개도 합연신율 + 전개도면적당 단가단가수량단가합계
'; echo ''; echo ''; echo ''; echo ''; echo '
'; echo '
'; // subparts-section } else { echo '
하위 부품 없음
'; } echo '
'; // part-section } echo '
'; // child-details ?>