function generateHuntDetailsInsertSql($huntDetails)
{
$sql = "INSERT ";
$sql .= "INTO hunt_details_ver ";
$sql .= "(hunt_id, status, hunter_id, hunter_count, hunt_date, hunt_hours, car_count, blind_id, area_id, is_multi_blind, is_jump_shoot, is_bag_checked, created) ";
$sql .= "VALUES (";
$sql .= formatSqlNumericValue($huntDetails->getHuntId(), true);
$sql .= formatSqlStringValue($huntDetails->getStatus(), true);
$sql .= formatSqlNumericValue($huntDetails->getHunterId(), true);
$sql .= formatSqlNumericValue($huntDetails->getHunterCount(), true);
$sql .= formatSqlDateValue($huntDetails->getHuntDate(), true);
$sql .= formatSqlNumericValue($huntDetails->getHuntHours(), true);
$sql .= formatSqlNumericValue($huntDetails->getCarCount(), true);
$sql .= formatSqlNumericValue($huntDetails->getBlindId(), true);
$sql .= formatSqlNumericValue($huntDetails->getAreaId(), true);
$sql .= formatSqlBooleanValue($huntDetails->isMultiBlind(), true);
$sql .= formatSqlBooleanValue($huntDetails->isJumpShoot(), true);
$sql .= formatSqlBooleanValue($huntDetails->isBagChecked(), true);
$sql .= formatSqlDateValue($huntDetails->getCreated(), false);
$sql .= ")";
return $sql;
}
function generateHuntReportIdSql($huntReport)
{
$sql = "SELECT id ";
$sql .= "FROM hunt_report ";
$sql .= " WHERE status = ";
$sql .= formatSqlStringValue($huntReport->getStatus(), false);
$sql .= " AND hunter_id = ";
$sql .= formatSqlNumericValue($huntReport->getHunterId(), false);
$sql .= " AND hunter_count = ";
$sql .= formatSqlNumericValue($huntReport->getHunterCount(), false);
$sql .= " AND hunt_date = ";
$sql .= formatSqlDateValue($huntReport->getHuntDate(), false);
$sql .= " AND hunt_hours = ";
$sql .= formatSqlNumericValue($huntReport->getHuntHours(), false);
$sql .= " AND car_count = ";
$sql .= formatSqlNumericValue($huntReport->getCarCount(), false);
$sql .= " AND blind_id = ";
$sql .= formatSqlNumericValue($huntReport->getBlindId(), false);
$sql .= " AND area_id = ";
$sql .= formatSqlNumericValue($huntReport->getAreaId(), false);
$sql .= " AND is_multi_blind = ";
$sql .= formatSqlBooleanValue($huntReport->isMultiBlind(), false);
$sql .= " AND is_jump_shoot = ";
$sql .= formatSqlBooleanValue($huntReport->isJumpShoot(), false);
$sql .= " AND is_bag_checked = ";
$sql .= formatSqlBooleanValue($huntReport->isBagChecked(), false);
$sql .= " AND created = ";
$sql .= formatSqlDateValue($huntReport->getCreated(), false);
return $sql;
}
