Schools Management

// Helper function for API requests
async function makeApiRequest(endpoint, params) {
  // API credentials - replace with actual values
  const apiUsername = 'your_api_username';
  const apiPassword = 'your_api_password';
  
  // Create form data from params
  const json = {};
  for (const [key, value] of Object.entries(params)) {
    json[key] = value;
  }
  const jsonString = JSON.stringify(json);

  
  
  try {
    const response = await fetch(`https://rcamsapi.spheronomics.com/api/v2/${endpoint}`, {
      method: 'POST',
      headers: {
        'Authorization': 'Basic ' + btoa(`${apiUsername}:${apiPassword}`)
      },
      body: jsonString
    });
    
    return await response.json();
  } catch (error) {
    console.error('API request failed:', error);
    throw error;
  }
}

// Example usage - School Management
async function schoolManagementExample( districtId) {
  try {
    // 1. List all schools in the district
    console.log(`Listing all schools in district ${districtId}...`);
    const listResponse = await makeApiRequest('school.php', {
      action: 'list',
      district_id: districtId
    });
    
    console.log(`Found ${listResponse.total} schools:`, listResponse.school_list);
    
    // 2. Create a new school
    console.log('Creating a new school...');
    const createResponse = await makeApiRequest('school.php', {
      action: 'insert',
      district_id: districtId,
      school_name: 'Example Elementary School',
      school_phone: '(555) 123-4567',
      school_email: 'info@example-school.edu',
      school_address: '789 Learning Lane'
    });
    
    if (createResponse.status === 'OK') {
      const newSchoolId = createResponse.school_id;
      console.log(`Created school with ID: ${newSchoolId}`);
      
      // 3. Get the school details
      console.log('Getting school details...');
      const getResponse = await makeApiRequest('school.php', {
        action: 'get',
        school_id: newSchoolId
      });
      
      console.log('School details:', getResponse);
      
      // 4. Update the school information
      console.log('Updating school information...');
      const updateResponse = await makeApiRequest('school.php', {
        action: 'update',
        school_id: newSchoolId,
        district_id: districtId,
        school_name: 'Updated Elementary School',
        school_phone: '(555) 123-9876',
        school_email: 'updated@example-school.edu',
        school_address: '789 Learning Lane Suite 101'
      });
      
      console.log('Update result:', updateResponse.message);
      
      // 5. Delete the school (commented out for safety)
      // Uncomment to actually delete the school
      /*
      console.log('Deleting school...');
      const deleteResponse = await makeApiRequest('school.php', {
        action: 'remove',
        school_id: newSchoolId
      });
      
      console.log('Delete result:', deleteResponse.message);
      */
    }
  } catch (error) {
    console.error('An error occurred:', error);
  }
}

// Run the example (you would need a valid district ID)
/*
async function runExample() {
  const loginResponse = await makeApiRequest('login.php', {
    user: 'user@example.com',
    pass: 'password123'
  });
  
  if (loginResponse.status === 'OK') {
    await schoolManagementExample( '1'); // Replace '1' with actual district ID
  } else {
    console.error('Login failed:', loginResponse.message);
  }
}

runExample();
*/