Editing a custom table using xpdo

if (empty($scriptProperties['rotaID'])) {

<?php
//begin snippet
$scriptProperties['rotaID'] = !empty($_GET['rotaID']) ? intval($_GET['rotaID']) : '';
if (empty($scriptProperties['rotaID'])) {
    // or you want to echo out any text
    //print_r($_POST);
    return '';
}

/* Get the existing Rota */

$path = MODX_CORE_PATH . 'components/intranet_db_connection/';
$modx->addPackage('intranet_db_connection',$path . 'model/','intranet_');
$dayRota = $modx->getObject('ManagersRota', array('ID' => $scriptProperties['rotaID']));

if (isset($_POST['submit']) && $_POST['submit'] == 'edit') {

//die(print_r($_POST));

    $dayRota->set('Day', $_POST['Day']);
    $dayRota->set('senior_manager', $_POST['senior_manager']);
    $dayRota->set('duty_manager_day', $_POST['duty_manager_day']);
    $dayRota->set('duty_manager_night', $_POST['duty_manager_night']);

    if  ($dayRota->save()) {
        $output = "<p>Quote Created</p>";
        $output .= '<a href="[[~17? &scheme=`full`]]">back</a>';
    } else {
        $output = "<p>Error when trying to save</p>";
        $output .= '<a href="[[~17? &scheme=`full`]]">back</a>';
    }

} else {

    /* Not a repost, just display the form */

    /* The second argument to getChunk() tells MODx to replace
     * the placeholders with the existing values
     */
    $output = $modx->getChunk('RotaTplEdit', $dayRota->toArray());
}
return $output;
?>

[[!rotaSnippet? &property=`value`]]

return '';

print_r($_POST);

<h3>[[+Day]]</h3>
<form method="get" action="[[~[[*id]]]]">
                <input type="hidden" name="rotaID" id="rotaID" value="[[+ID]]" />
                <p>Senior Manager: <input type="text" name="senior_manager" id="senior_manager" value="[[+senior_manager]]" /></p>
                <p>Duty Manager (Day): <input type="text" name="duty_manager_day" id="duty_manager_day" value="[[+duty_manager_day]]" /></p>
                <p>Duty Manager (Night): <input type="text" name="duty_manager_night" id="duty_manager_night" value="[[+duty_manager_night]]" /></p>
</form>

<?php
//begin snippet
$scriptProperties['rotaID'] = !empty($_GET['rotaID']) ? intval($_GET['rotaID']) : '';

$database_server = 'localhost';
$database_type = 'mysql';
$dbase = 'Intranet';
$database_user = '*******';
$database_password = '********';
$table_prefix = 'intranet_';

/* Get the existing Rota */

$path = MODX_CORE_PATH . 'components/intranet_db_connection/';

$xpdo = new xPDO('mysql:host=localhost;dbname=Intranet', $database_user,$database_password,$table_prefix);

$modx->addPackage('intranet_db_connection',$path . 'model/','intranet_');
$dayRota = $modx->getObject('ManagersRota', array('rotaID'=> $scriptProperties['rotaID']));

if (isset($_POST['editDay'])) {

die(print_r($_POST));

    $dayRota->set('rotaID', $_POST['rotaID']);
    $dayRota->set('Day', $_POST['Day']);
    $dayRota->set('security_state', $_POST['security_state']);
    $dayRota->set('senior_manager', $_POST['senior_manager']);
    $dayRota->set('duty_adjudicator', $_POST['duty_adjudicator']);
    $dayRota->set('duty_manager_day', $_POST['duty_manager_day']);
    $dayRota->set('duty_manager_night', $_POST['duty_manager_night']);
    $dayRota->set('on_call_controller', $_POST['on_call_controller']);
    $dayRota->set('unlock_roll', $_POST['unlock_roll']);
    $dayRota->set('duty_chaplain', $_POST['duty_chaplain']);

    if  ($dayRota->save()) {
        $output = "<p>Quote Created</p>";
        $output .= '<a href="[[~5? &scheme=`full`]]">back</a>';
    } else {
        $output = "<p>Error when trying to save</p>";
        $output .= '<a href="[[~5? &scheme=`full`]]">back</a>';
    }

} else {

    /* Not a repost, just display the form */

    /* The second argument to getChunk() tells MODx to replace
     * the placeholders with the existing values
     */
    $output = $modx->getChunk('RotaTplEdit', $dayRota->toArray());
}
return $output;