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; }