function generateEventInsertSql($event) { $sql = "INSERT "; $sql .= "INTO event_log "; $sql .= "(create_date, type, message) "; $sql .= "VALUES ("; $sql .= formatSqlDateValue($event->getCreateDate(), true); $sql .= formatSqlStringValue($event->getType(), true); $sql .= formatSqlStringValue($event->getMessage(), false); $sql .= ")"; return $sql; }
function generateHuntCountReportInsertSql($huntReportId, $huntCount) { $sql = "INSERT "; $sql .= "INTO hunt_count_report "; $sql .= "(hunt_id, species_id, species_count, created) "; $sql .= "VALUES ("; $sql .= formatSqlNumericValue($huntReportId, true); $sql .= formatSqlStringValue($huntCount->getSpeciesId(), true); $sql .= formatSqlNumericValue($huntCount->getCount(), true); $sql .= formatSqlDateValue($huntCount->getCreated(), false); $sql .= ")"; return $sql; }
function generateNewHarvestCountSql($huntId, $huntDetailsId, $harvestCount) { $sql = "INSERT"; $sql .= " INTO hunt_count_ver"; $sql .= " (hunt_id, hunt_details_id, species_id, species_count, created)"; $sql .= " VALUES ("; $sql .= formatSqlNumericValue($huntId, true); $sql .= formatSqlNumericValue($huntDetailsId, true); $sql .= formatSqlNumericValue($harvestCount->getSpeciesId(), true); $sql .= formatSqlNumericValue($harvestCount->getCount(), true); $sql .= formatSqlDateValue($harvestCount->getCreated(), false); $sql .= ")"; return $sql; }
function generateFindAllHuntDetailsForASeasonSql($season) { $sql = "SELECT DISTINCT(hunt_id) "; $sql .= "FROM hunt_details_ver "; $sql .= "WHERE hunt_date >= "; $sql .= formatSqlDateValue($season->getStartDate(), false); $sql .= " AND hunt_date <= "; $sql .= formatSqlDateValue($season->getEndDate(), false); return $sql; }
function generateSeasonIdSql($hunt) { $sql = "SELECT id "; $sql .= "FROM hunt_ver "; $sql .= "WHERE hunter_id = "; $sql .= formatSqlNumericValue($hunt->getHunterId(), false); $sql .= " AND created = "; $sql .= formatSqlDateValue($hunt->getCreated(), false); 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; }