FedMCP - Federal Parliamentary Information

/** * GraphQL queries and fragments */ import { gql } from '@apollo/client'; // ============================================ // Fragments // ============================================ export const MP_BASIC_FRAGMENT = gql` fragment MPBasic on MP { id name party riding current cabinet_position photo_url photo_url_source } `; export const MP_SEATING_FRAGMENT = gql` fragment MPSeating on MP { id name party riding current cabinet_position parl_mp_id seat_row seat_column bench_section seat_visual_x seat_visual_y } `; export const MP_FULL_FRAGMENT = gql` fragment MPFull on MP { ...MPBasic gender elected_date email phone twitter wikipedia_id constituency_office ourcommons_url memberOf { code name seats } represents { name province } } ${MP_BASIC_FRAGMENT} `; export const BILL_BASIC_FRAGMENT = gql` fragment BillBasic on Bill { number session title title_fr summary summary_fr status status_fr bill_type bill_type_fr is_government_bill originating_chamber originating_chamber_fr introduced_date } `; export const STATEMENT_FRAGMENT = gql` fragment StatementBasic on Statement { id time who_en who_fr content_en content_fr h1_en h1_fr h2_en h2_fr h3_en h3_fr statement_type wordcount procedural thread_id parent_statement_id sequence_in_thread } `; // ============================================ // MP Queries // ============================================ export const GET_MPS = gql` query GetMPs($where: MPWhere, $options: MPOptions) { mps(where: $where, options: $options) { ...MPBasic } } ${MP_BASIC_FRAGMENT} `; export const SEARCH_MPS = gql` query SearchMPs($searchTerm: String, $party: String, $current: Boolean, $cabinetOnly: Boolean, $limit: Int) { searchMPs(searchTerm: $searchTerm, party: $party, current: $current, cabinetOnly: $cabinetOnly, limit: $limit) { ...MPBasic } } ${MP_BASIC_FRAGMENT} `; // Optimized paginated MPs query with offset-based pagination export const PAGINATED_MPS = gql` query PaginatedMPs($parties: [String!], $current: Boolean, $cabinetOnly: Boolean, $searchTerm: String, $limit: Int, $offset: Int) { paginatedMPs(parties: $parties, current: $current, cabinetOnly: $cabinetOnly, searchTerm: $searchTerm, limit: $limit, offset: $offset) { ...MPBasic } } ${MP_BASIC_FRAGMENT} `; // Count MPs matching filters export const COUNT_MPS = gql` query CountMPs($parties: [String!], $current: Boolean, $cabinetOnly: Boolean, $searchTerm: String) { countMPs(parties: $parties, current: $current, cabinetOnly: $cabinetOnly, searchTerm: $searchTerm) { count } } `; export const GET_CHAMBER_SEATING = gql` query GetChamberSeating { mps(where: { current: true, seat_row_NOT: null }) { ...MPSeating } } ${MP_SEATING_FRAGMENT} `; // Optimized: Minimal query for MP page initial load (header + overview only) export const GET_MP_BASIC_INFO = gql` query GetMPBasicInfo($id: ID!) { mps(where: { id: $id }) { ...MPFull votedConnection(first: 5, sort: [{ node: { date: DESC } }]) { edges { properties { position } node { id number date result yeas nays description subjectOf { number title session } } } } } } ${MP_FULL_FRAGMENT} `; // Legacy full query - kept for backward compatibility export const GET_MP = gql` query GetMP($id: ID!) { mps(where: { id: $id }) { ...MPFull sponsored(options: { limit: 100, sort: [{ introduced_date: DESC }] }) { ...BillBasic } expenses(options: { limit: 50, sort: [{ fiscal_year: DESC }, { quarter: DESC }] }) { id fiscal_year quarter amount category description } votedConnection(first: 20, sort: [{ node: { date: DESC } }]) { edges { properties { position } node { id number date result yeas nays description subjectOf { number title session } } } } servedOnConnection { edges { properties { role } node { code name mandate chamber } } } metWithConnection( first: 20 sort: [{ edge: { last_contact: DESC } }] ) { totalCount edges { properties { first_contact last_contact } node { id name firm worksFor { id name industry } } } } } } ${MP_FULL_FRAGMENT} ${BILL_BASIC_FRAGMENT} `; // Lazy-loaded tab-specific queries export const GET_MP_LEGISLATION = gql` query GetMPLegislation($id: ID!) { mps(where: { id: $id }) { id sponsored(options: { limit: 100, sort: [{ introduced_date: DESC }] }) { ...BillBasic } } } ${BILL_BASIC_FRAGMENT} `; export const GET_MP_EXPENSES = gql` query GetMPExpenses($id: ID!) { mps(where: { id: $id }) { id expenses(options: { limit: 50, sort: [{ fiscal_year: DESC }, { quarter: DESC }] }) { id fiscal_year quarter amount category description } } } `; export const GET_MP_VOTES = gql` query GetMPVotes($id: ID!) { mps(where: { id: $id }) { id votedConnection(first: 100, sort: [{ node: { date: DESC } }]) { edges { properties { position } node { id number date result yeas nays description subjectOf { number title session } } } } } } `; export const GET_MP_COMMITTEES = gql` query GetMPCommittees($id: ID!) { mps(where: { id: $id }) { id servedOnConnection { edges { properties { role } node { code name mandate chamber } } } } } `; export const GET_MP_SCORECARD = gql` query GetMPScorecard($mpId: ID!) { mpScorecard(mpId: $mpId) { mp { id name given_name family_name party riding current cabinet_position email phone updated_at } bills_sponsored bills_passed votes_participated petitions_sponsored total_petition_signatures current_year_expenses lobbyist_meetings question_period_interjections voting_participation_rate party_discipline_score legislative_success_rate committee_activity_index } } `; // TODO: Re-enable when GlobalExpenseStats type is implemented in graph-api schema // export const GET_GLOBAL_EXPENSE_STATS = gql` // query GetGlobalExpenseStats { // globalExpenseStats { // average_per_quarter // median_per_quarter // total_quarters // } // } // `; export const GET_MP_NEWS = gql` query GetMPNews($mpName: String!, $limit: Int = 10) { mpNews(mpName: $mpName, limit: $limit) { title url source published_date description image_url last_updated } } `; // ============================================ // Bill Queries // ============================================ export const GET_BILLS = gql` query GetBills($where: BillWhere, $options: BillOptions) { bills(where: $where, options: $options) { ...BillBasic sponsor { id name party } } } ${BILL_BASIC_FRAGMENT} `; export const SEARCH_BILLS = gql` query SearchBills( $searchTerm: String $status: String $session: String $bill_type: String $is_government_bill: Boolean $originating_chamber: String $limit: Int ) { searchBills( searchTerm: $searchTerm status: $status session: $session bill_type: $bill_type is_government_bill: $is_government_bill originating_chamber: $originating_chamber limit: $limit ) { ...BillBasic sponsor { name party } } } ${BILL_BASIC_FRAGMENT} `; export const GET_BILL = gql` query GetBill($number: String!, $session: String!) { bills(where: { number: $number, session: $session }) { ...BillBasic summary summary_fr stage latest_event passed_date royal_assent_date # Reading stage dates passed_house_first_reading passed_house_second_reading passed_house_third_reading passed_senate_first_reading passed_senate_second_reading passed_senate_third_reading # Statute info statute_year statute_chapter # Committees referredTo { code name } sponsor { ...MPBasic } votes(options: { limit: 25, sort: [{ date: DESC }] }) { id date result description yeas nays } } } ${BILL_BASIC_FRAGMENT} ${MP_BASIC_FRAGMENT} `; export const GET_BILL_LOBBYING = gql` query GetBillLobbying($billNumber: String!, $session: String!) { billLobbying(billNumber: $billNumber, session: $session) { bill_number bill_session bill_title bill_status organizations_lobbying total_lobbying_events organizations { name industry lobbying_count } } } `; // Bill structure - hierarchical text export const GET_BILL_STRUCTURE = gql` query GetBillStructure($number: String!, $session: String!) { bills(where: { number: $number, session: $session }) { number session title # Bill versions versions { id version_number stage publication_type_name publication_date has_amendments xml_url pdf_url } # Amendment events amendmentEvents { id event_type description_en description_fr event_date chamber stage committee_code committee_name report_number number_of_amendments } # Bill parts (top-level divisions) parts(options: { sort: [{ sequence: ASC }] }) { id number title_en title_fr anchor_id sequence sections(options: { sort: [{ sequence: ASC }] }) { id number marginal_note_en marginal_note_fr text_en text_fr anchor_id sequence subsections(options: { sort: [{ sequence: ASC }] }) { id number text_en text_fr anchor_id sequence paragraphs(options: { sort: [{ sequence: ASC }] }) { id letter text_en text_fr anchor_id sequence subparagraphs(options: { sort: [{ sequence: ASC }] }) { id numeral text_en text_fr anchor_id sequence } } } } } # Sections not in parts sections(options: { sort: [{ sequence: ASC }] }) { id number marginal_note_en marginal_note_fr text_en text_fr anchor_id sequence subsections(options: { sort: [{ sequence: ASC }] }) { id number text_en text_fr anchor_id sequence paragraphs(options: { sort: [{ sequence: ASC }] }) { id letter text_en text_fr anchor_id sequence subparagraphs(options: { sort: [{ sequence: ASC }] }) { id numeral text_en text_fr anchor_id sequence } } } } } } `; // ============================================ // Dashboard Queries // ============================================ export const GET_DASHBOARD_STATS = gql` query GetDashboardStats { mps(where: { current: true }) { id } bills(options: { limit: 1 }) { number } } `; export const GET_TOP_SPENDERS = gql` query GetTopSpenders($fiscalYear: Int, $limit: Int = 10) { topSpenders(fiscalYear: $fiscalYear, limit: $limit) { mp { ...MPBasic } total_expenses } } ${MP_BASIC_FRAGMENT} `; export const GET_INTERJECTION_LEADERBOARD = gql` query GetInterjectionLeaderboard($party: String, $limit: Int = 100) { mpInterjectionLeaderboard(party: $party, limit: $limit) { mp { ...MPBasic } interjection_count } } ${MP_BASIC_FRAGMENT} `; // Optimized dashboard aggregate queries - avoid over-fetching export const GET_DASHBOARD_COUNTS = gql` query GetDashboardCounts { mpsAggregate(where: { current: true }) { count } billsAggregate { count } } `; // Server-side randomized MPs with party filtering export const GET_RANDOM_MPS = gql` query GetRandomMPs($parties: [String!], $limit: Int = 8) { randomMPs(parties: $parties, limit: $limit) { ...MPBasic } } ${MP_BASIC_FRAGMENT} `; export const GET_CONFLICTS_OF_INTEREST = gql` query GetConflictsOfInterest($limit: Int = 20) { conflictsOfInterest(limit: $limit) { mp { id name party } organization { name industry } bill { number title } suspicion_score } } `; export const SEARCH_LOBBY_REGISTRATIONS = gql` query SearchLobbyRegistrations($searchTerm: String, $active: Boolean, $limit: Int) { searchLobbyRegistrations(searchTerm: $searchTerm, active: $active, limit: $limit) { id reg_number client_org_name registrant_name effective_date active subject_matters } } `; export const GET_PARTY_SPENDING_TRENDS = gql` query GetPartySpendingTrends($fiscalYear: Int) { partySpendingTrends(fiscalYear: $fiscalYear) { quarter period parties { party total_expenses mp_count average_per_mp } total_all_parties } } `; // ============================================ // Committee Queries // ============================================ export const GET_COMMITTEES = gql` query GetCommittees { committees { code name mandate chamber membersAggregate { count } latestMeetingDate latestMeetingNumber totalMeetingsCount } } `; export const GET_COMMITTEE = gql` query GetCommittee($code: ID!) { committees(where: { code: $code }) { code name mandate chamber members { id name party riding cabinet_position servedOnConnection(where: { node: { code: $code } }) { edges { properties { role } } } } bills { number title status session } meetings(options: { limit: 5, sort: [{ date: DESC }] }) { date number has_evidence } } } `; export const GET_COMMITTEE_MEETINGS = gql` query GetCommitteeMeetings($code: ID!) { committees(where: { code: $code }) { meetings(options: { limit: 50, sort: [{ date: DESC }] }) { id date number in_camera has_evidence meeting_url session parliament } } } `; export const GET_COMMITTEE_TESTIMONY = gql` query GetCommitteeTestimony($committeeCode: String!, $limit: Int = 20) { committeeTestimony(committeeCode: $committeeCode, limit: $limit) { ...StatementBasic madeBy { id name party } partOf { id date document_type session_id } } } ${STATEMENT_FRAGMENT} `; export const GET_COMMITTEE_ACTIVITY_METRICS = gql` query GetCommitteeActivityMetrics($committeeCode: String!) { committeeActivityMetrics(committeeCode: $committeeCode) { committee { code name } total_meetings meetings_last_30_days meetings_last_90_days total_evidence_documents active_bills_count member_count avg_statements_per_meeting } } `; // ============================================ // Hansard Queries // ============================================ export const GET_MP_SPEECHES = gql` query GetMPSpeeches($mpId: ID!, $limit: Int = 20, $documentType: String) { mpSpeeches(mpId: $mpId, limit: $limit, documentType: $documentType) { ...StatementBasic } } ${STATEMENT_FRAGMENT} `; export const GET_BILL_DEBATES = gql` query GetBillDebates($billNumber: String!, $session: String!, $limit: Int = 50, $debateStage: String) { billDebates(billNumber: $billNumber, session: $session, limit: $limit, debateStage: $debateStage) { ...StatementBasic madeBy { id name party } mentionsConnection { edges { properties { debate_stage } } } } } ${STATEMENT_FRAGMENT} `; export const SEARCH_HANSARD = gql` query SearchHansard($query: String!, $limit: Int = 50, $language: String = "en") { searchHansard(query: $query, limit: $limit, language: $language) { ...StatementBasic madeBy { id name party } partOf { id date document_type session_id presentedTo { code name chamber } } } } ${STATEMENT_FRAGMENT} `; export const GET_HANSARD_DOCUMENT = gql` query GetHansardDocument { documents(options: { limit: 100, sort: [{ date: DESC }] }) { id date number session_id document_type xml_source_url statements { ...StatementBasic madeBy { id name party } } } } ${STATEMENT_FRAGMENT} `; export const GET_RECENT_DEBATES = gql` query GetRecentDebates( $limit: Int = 20 $documentType: String $questionPeriodOnly: Boolean = false $startDate: String $endDate: String ) { recentDebates( limit: $limit documentType: $documentType questionPeriodOnly: $questionPeriodOnly startDate: $startDate endDate: $endDate ) { document { id date session_id document_type number keywords_en keywords_fr } statement_count speaker_count top_topics } } `; export const GET_RECENT_STATEMENTS = gql` query GetRecentStatements($limit: Int = 10, $offset: Int = 0) { statements( options: { limit: $limit, offset: $offset, sort: [{ time: DESC }] } ) { ...StatementBasic madeBy { id name party } partOf { id date document_type session_id presentedTo { code name chamber } } } } ${STATEMENT_FRAGMENT} `; // ============================================ // Lobbying Fragments // ============================================ export const ORGANIZATION_BASIC_FRAGMENT = gql` fragment OrganizationBasic on Organization { id name industry } `; export const LOBBYIST_BASIC_FRAGMENT = gql` fragment LobbyistBasic on Lobbyist { id name firm } `; // ============================================ // Lobbying Queries // ============================================ export const GET_MP_LOBBYING = gql` query GetMPLobbying($mpId: ID!, $limit: Int = 10, $after: String) { mps(where: { id: $mpId }) { id name metWithConnection( first: $limit after: $after sort: [{ edge: { last_contact: DESC } }, { edge: { first_contact: DESC } }] ) { totalCount pageInfo { hasNextPage hasPreviousPage startCursor endCursor } edges { cursor properties { first_contact last_contact } node { ...LobbyistBasic worksFor { ...OrganizationBasic } } } } } } ${LOBBYIST_BASIC_FRAGMENT} ${ORGANIZATION_BASIC_FRAGMENT} `; export const GET_LOBBYIST = gql` query GetLobbyist($id: ID!) { lobbyists(where: { id: $id }) { id name firm worksFor { ...OrganizationBasic } metWithConnection( first: 50 sort: [{ edge: { last_contact: DESC } }] ) { totalCount edges { properties { first_contact last_contact } node { id name party riding } } } registeredForConnection { totalCount edges { node { id reg_number active effective_date end_date } } } } } ${ORGANIZATION_BASIC_FRAGMENT} `; export const GET_ORGANIZATION = gql` query GetOrganization($id: ID!) { organizations(where: { id: $id }) { id name industry lobbyistsConnection { totalCount edges { node { ...LobbyistBasic } } } lobbiedOnConnection(first: 20) { totalCount edges { properties { date subject } node { number session title title_fr status } } } registrationsConnection(first: 20) { totalCount edges { node { id reg_number registrant_name active effective_date } } } } } ${LOBBYIST_BASIC_FRAGMENT} `; export const GET_DASHBOARD_LOBBYING = gql` query GetDashboardLobbying { lobbyCommunications( options: { limit: 10 sort: [{ date: DESC }] } ) { id date client_org_name registrant_name dpoh_names subject_matters organization { id name } lobbyist { id name } } } `; export const SEARCH_ORGANIZATIONS = gql` query SearchOrganizations($searchTerm: String!, $limit: Int = 20) { searchOrganizations(searchTerm: $searchTerm, limit: $limit) { ...OrganizationBasic lobbyistsConnection { totalCount } registrationsConnection(where: { active: true }) { totalCount } } } ${ORGANIZATION_BASIC_FRAGMENT} `; export const SEARCH_LOBBYISTS = gql` query SearchLobbyists($searchTerm: String!, $limit: Int = 20) { searchLobbyists(searchTerm: $searchTerm, limit: $limit) { ...LobbyistBasic worksFor { ...OrganizationBasic } metWithConnection { totalCount } } } ${LOBBYIST_BASIC_FRAGMENT} ${ORGANIZATION_BASIC_FRAGMENT} `; // Detailed Lobby Communication Queries export const GET_MP_LOBBY_COMMUNICATIONS = gql` query GetMPLobbyCommunications($mpId: ID!, $limit: Int = 10, $offset: Int = 0) { lobbyCommunications( where: { contacted_SOME: { id: $mpId } } options: { limit: $limit offset: $offset sort: [{ date: DESC }] } ) { id date dpoh_names dpoh_titles subject_matters institutions client_org_name registrant_name organization { id name industry } lobbyist { id name firm } } lobbyCommunicationsAggregate( where: { contacted_SOME: { id: $mpId } } ) { count } } `; export const GET_LOBBYIST_COMMUNICATIONS = gql` query GetLobbyistCommunications($lobbyistId: ID!, $limit: Int = 50) { lobbyCommunications( where: { lobbyist: { id: $lobbyistId } } options: { limit: $limit sort: [{ date: DESC }] } ) { id date dpoh_names dpoh_titles subject_matters institutions client_org_name organization { id name industry } contacted { id name party riding } } } `; export const GET_ORGANIZATION_COMMUNICATIONS = gql` query GetOrganizationCommunications($organizationId: ID!, $limit: Int = 50) { lobbyCommunications( where: { organization: { id: $organizationId } } options: { limit: $limit sort: [{ date: DESC }] } ) { id date dpoh_names dpoh_titles subject_matters institutions registrant_name lobbyist { id name firm } contacted { id name party riding } } } `; // ============================================ // Debate/Hansard Document Queries // ============================================ export const GET_QUESTION_PERIOD_DEBATES = gql` query GetQuestionPeriodDebates($limit: Int = 10, $sinceDate: Date) { questionPeriodDebates(limit: $limit, sinceDate: $sinceDate) { document { id date session_id document_type number keywords_en keywords_fr } statement_count speaker_count top_topics is_question_period } } `; export const GET_DEBATE_WITH_STATEMENTS = gql` query GetDebateWithStatements($documentId: ID!, $includeThreading: Boolean = true) { debateWithStatements(documentId: $documentId, includeThreading: $includeThreading) { document { id date session_id document_type number xml_source_url } statements { id time who_en who_fr content_en content_fr h1_en h2_en h3_en h1_fr h2_fr h3_fr statement_type politician_id thread_id parent_statement_id sequence_in_thread wordcount procedural madeBy { id name party photo_url photo_url_source } partOf { id date document_type } } sections statement_count } } `; export const GET_DEBATES_CALENDAR_DATA = gql` query GetDebatesCalendarData($startDate: String!, $endDate: String!) { debatesCalendarData(startDate: $startDate, endDate: $endDate) { date hasHouseDebates hasQuestionPeriod hasCommittee hasScheduledMeeting scheduledMeetings { committee_code committee_name number in_camera } } } `; // ============================================ // Written Questions Queries // ============================================ export const GET_WRITTEN_QUESTIONS = gql` query GetWrittenQuestions($limit: Int, $answered: Boolean, $mpId: ID, $session: String) { writtenQuestions(limit: $limit, answered: $answered, mpId: $mpId, session: $session) { id time who_en who_fr content_en content_fr h1_en h2_en h3_en h1_fr h2_fr h3_fr wordcount answer { id time who_en who_fr content_en content_fr } madeBy { id name party riding photo_url photo_url_source } partOf { id date document_type session_id } } } `; export const GET_MP_WRITTEN_QUESTIONS = gql` query GetMPWrittenQuestions($mpId: ID!, $limit: Int, $session: String) { mpWrittenQuestions(mpId: $mpId, limit: $limit, session: $session) { id time who_en who_fr content_en content_fr h1_en h2_en h3_en h1_fr h2_fr h3_fr wordcount answer { id time who_en who_fr content_en content_fr } madeBy { id name party riding photo_url } partOf { id date document_type session_id } } } `; export const GET_WRITTEN_QUESTION_SESSIONS = gql` query GetWrittenQuestionSessions { writtenQuestionSessions } `; export const GET_MP_ANSWERED_QUESTIONS = gql` query GetMPAnsweredQuestions($mpId: ID!, $limit: Int, $session: String) { mpAnsweredQuestions(mpId: $mpId, limit: $limit, session: $session) { question { id time who_en who_fr content_en content_fr h1_en h2_en h3_en h1_fr h2_fr h3_fr wordcount madeBy { id name party riding photo_url } } answer { id time who_en who_fr content_en content_fr } partOf { id date document_type session_id } } } `; export const SEARCH_WRITTEN_QUESTIONS = gql` query SearchWrittenQuestions($searchTerm: String!, $limit: Int, $language: String) { searchWrittenQuestions(searchTerm: $searchTerm, limit: $limit, language: $language) { id time who_en who_fr content_en content_fr h1_en h2_en h3_en h1_fr h2_fr h3_fr wordcount answer { id time who_en who_fr content_en content_fr } madeBy { id name party riding photo_url photo_url_source } partOf { id date document_type } } } `;