fannie/item/ProdReviewRequest.php
<?php
/*******************************************************************************
Copyright 2017 Whole Foods Community Co-op
This file is part of CORE-POS.
CORE-POS is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
CORE-POS is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
in the file license.txt along with IT CORE; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*********************************************************************************/
require(dirname(__FILE__) . '/../config.php');
if (!class_exists('FannieAPI')) {
include(__DIR__ . '/../classlib2.0/FannieAPI.php');
}
class ProdReviewRequest
{
public static function run()
{
$obj = new ProdReviewRequest();
$obj->updateComment();
return false;
}
private function updateComment()
{
global $FANNIE_OP_DB;
$dbc = FannieDB::get($FANNIE_OP_DB);
$bid = FormLib::get('bid');
$comment = FormLib::get('comment');
$args = array($comment,$bid);
$prep = $dbc->prepare("UPDATE batchReviewLog SET comments = ? WHERE bid = ?");
$dbc->execute($prep,$args);
if ($er = $dbc->error()) {
/*
$json = array();
$json['error'] = "UPDATE ERROR: ".$er;
return json_encode($json);
*/
echo "<div class='alert alert-danger'>$er</div>";
return true;
} else {
echo "<div class='alert alert-success'>Saved!</div>";
return true;
}
}
}
ProdReviewRequest::run();