request.php

<?php
include ("dbaccess.php"); 
require 'vendor/autoload.php';

$loader = new Twig_Loader_Filesystem('views');
$twig = new Twig_Environment($loader);
$template = $twig->load('request.html.twig');

if ($_GET['script'] == 'reset-proposed') {
    $request = $fm->newPerformScriptCommand('web', 'Reset proposed');
    $result = $request->execute();

    if (FileMaker::isError($result)) {
        echo "<p>Error: " . $result->getMessage() . "</p>"; exit;
    }

    $msg = 'All proposed items to request have been reset.';

} 

$request = $fm->newFindCommand('web');
//$request->addFindCriterion('Inventory::proposed', '*');
$request->addFindCriterion('Inventory::requested', '*');  
$result = $request->execute();

if (FileMaker::isError($result)) {
//        $ggg = 'foo';
//        echo  "<p>Error: " . $result->getMessage() . "</p>"; exit;
    $msg = $result->getMessage();
} else {
    $records = $result->getRecords();
    $publications = array();
    foreach($records as $record) {
        $publications[] = array(
            'id' => $record->getField('id'),
            'symbol' => $record->getField('publicationCode'),
            'title' => $record->getField('publicationTitle'),
            'proposed' => $record->getField('Inventory::proposed'),
            'requested' => $record->getField('Inventory::requested'),
            'note' => $record->getField('requestNote')
        );
    }
}

echo $template->render(array(
        'publications' => $publications,
        'msg' => $msg,
        )
    );
?>