protected function post_newTender_handler()
{
$dbc = $this->connection;
$dbc->selectDB($this->config->get('OP_DB'));
$newID = 1;
$idQ = $dbc->prepare_statement("SELECT MAX(TenderID) FROM tenders");
$idR = $dbc->exec_statement($idQ);
if ($dbc->num_rows($idR) > 0) {
$idW = $dbc->fetch_row($idR);
if (!empty($idW[0])) {
$newID = $idW[0] + 1;
}
}
$model = new TendersModel($dbc);
$model->TenderID($newID);
$model->TenderName('NEW TENDER');
$model->TenderType('CA');
$model->MinAmount(0);
$model->MaxAmount(500);
$model->MaxRefund(0);
$model->save();
echo $this->getTenderTable();
return false;
}
function results_content()
{
global $FANNIE_OP_DB;
$dbc = FannieDB::get($FANNIE_OP_DB);
$id = FormLib::get_form_value('TenderID');
$tender = new TendersModel($dbc);
$tender->TenderID($id);
$tender->delete();
$ret = "<i>Tender deleted</i>";
$ret .= "<br /><br />";
$ret .= '<a href="DeleteTenderPage.php">Delete another</a>';
$ret .= " ";
$ret .= '<a href="index.php">Back to edit tenders</a>';
return $ret;
}
