function insertRPTOPRecord($rptop)
{
if (is_array($rptop)) {
$db = new DB_RPTS();
$sql = sprintf("INSERT INTO %s(" . "rptopNumber" . ", rptopDate" . ", taxableYear" . ", cityTreasurer" . ", cityAssessor" . ", landTotalMarketValue" . ", landTotalAssessedValue" . ", plantTotalMarketValue" . ", plantTotalAssessedValue" . ", bldgTotalMarketValue" . ", bldgTotalAssessedValue" . ", machTotalMarketValue" . ", machTotalAssessedValue" . ", totalMarketValue" . ", totalAssessedValue" . ", dateCreated" . ", createdBy" . ", dateModified" . ", modifiedBy" . ") VALUES(" . "'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s'" . ",'%s','%s','%s','%s','%s','%s','%s','%s','%s');", RPTOP_TABLE, fixQuotes($rptop["rptopNumber"]), fixQuotes(date("Y-m-d"), strtotime("now")), fixQuotes($rptop["taxableYear"]), fixQuotes($rptop["cityTreasurer"]), fixQuotes($rptop["cityAssessor"]), fixQuotes($rptop["landTotalMarketValue"]), fixQuotes($rptop["landTotalAssessedValue"]), fixQuotes($rptop["plantTotalMarketValue"]), fixQuotes($rptop["plantTotalAssessedValue"]), fixQuotes($rptop["bldgTotalMarketValue"]), fixQuotes($rptop["bldgTotalAssessedValue"]), fixQuotes($rptop["machTotalMarketValue"]), fixQuotes($rptop["machTotalAssessedValue"]), fixQuotes($rptop["totalMarketValue"]), fixQuotes($rptop["totalAssessedValue"]), fixQuotes(time()), fixQuotes($rptop["createdBy"]), fixQuotes(time()), fixQuotes($rptop["modifiedBy"]));
$db->beginTransaction();
$db->query($sql);
$rptopID = $db->insert_id();
if ($db->Errno != 0) {
$db->rollbackTransaction();
$db->resetErrors();
return false;
} else {
$db->endTransaction();
return $rptopID;
}
} else {
return false;
}
}
