function formatSqlSetStringValue($columnName, $stringValue, $addComa) { $formattedValue = $columnName; $formattedValue .= "="; $formattedValue .= formatSqlStringValue($stringValue, $addComa); return $formattedValue; }
function generateInsertNoteSql($noteContent) { $insertSql = ""; $insertSql .= "INSERT INTO bc_note (bc_note, bc_created, bc_modified) VALUES("; $insertSql .= formatSqlStringValue($noteContent, true); $insertSql .= formatSqlStringValue(getNow(), true); $insertSql .= formatSqlStringValue(getNow(), false); $insertSql .= ")"; return $insertSql; }
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 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 generateUpdateStringValue($tableName, $year, $blindNumber, $priority, $columnName, $newValue) { $sql = "UPDATE "; $sql .= $tableName; $sql .= " "; $sql .= "SET "; $sql .= $columnName; $sql .= "="; $sql .= formatSqlStringValue($newValue, false); $sql .= " "; $sql .= "WHERE year="; $sql .= $year; $sql .= " "; $sql .= "AND blind_number="; $sql .= $blindNumber; $sql .= " "; $sql .= "AND priority="; $sql .= $priority; 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; }
function generateBCSpeciesInsertSql($oneSpecies, $birdGroupId, $speciesSeq) { $insertSql = ""; $insertSql .= "INSERT INTO bc_species (bird_group_id, bc_species_id, bc_harvest_count, bc_species_seq, bc_created, bc_modified) VALUES("; $insertSql .= formatSqlNumericValue($birdGroupId, true); $insertSql .= formatSqlStringValue($oneSpecies->getSpeciesId(), true); $insertSql .= formatSqlStringValue($oneSpecies->getHarvestCount(), true); $insertSql .= formatSqlNumericValue($speciesSeq, true); $insertSql .= formatSqlStringValue(getNow(), true); $insertSql .= formatSqlStringValue(getNow(), false); $insertSql .= ")"; return $insertSql; }