Exemplo n.º 1
0
# Connect to the database
pg_connect("") or die("Could not connect to database... " . pg_last_error($db) . "\n");
# Foreach username, lookup their application and try to report it to banner
foreach ($usernames as $username) {
    echo "Looking up application for: {$username}...";
    $result = pg_query("SELECT * from hms_application WHERE hms_student_id ILIKE '{$username}' AND term=" . CURR_TERM);
    if (!$result) {
        echo "\nAn error occured looking up appliction for {$username}: " . pg_last_error($db) . "\n";
        exit;
    }
    if (sizeof($result) > 1) {
        echo "Multiple applications returned, skipping.\n";
        continue;
    }
    if (sizeof($result) <= 0) {
        echo "No application found, skipping.\n";
        continue;
    }
    # Get the application from the database
    $row = pg_fetch_assoc($result);
    # Actually try to report it to Banner
    $plan_meal = HMS_SOAP::get_plan_meal_codes($username, 'BLAH_DORM', $row['meal_option']);
    $banner_result = HMS_SOAP::report_application_received($username, CURR_TERM, $plan_meal['plan'], $plan_meal['meal']);
    if ($banner_result !== 0) {
        print_r($banner_result);
        echo "Banner error: {$banner_result}\n";
    } else {
        echo "Reported.\n";
    }
}
pg_close($db);