//
// GEBOREN NESTJES FUNCTION
//
function addGeborenNest($chkStamboom,$catteryNaam,$erkenningsnummer,$member,$contactpersoon,$land,$website,$email,$telefoon,$mobiel,$rasID,$dob,$infoVader,$infoMoeder,$comments,$catteryVermelding, $adres, $adresVermelding) {
$query = "INSERT INTO tblGeborenNesten (dateGeplaatst, chkStamboom, catteryNaam, erkenningsnummer, member, contactpersoon, land, website, email, telefoon, mobiel, rasID, dobDatum, infoVader, infoMoeder, comments, chkCattery, adres, chkAdres) VALUES ('" . date("Y-m-d") . "', '$chkStamboom', '$catteryNaam', '$erkenningsnummer', '$member', '$contactpersoon', '$land', '$website', '$email', '$telefoon', '$mobiel', $rasID, '$dob', '$infoVader', '$infoMoeder', '$comments', '$catteryVermelding', '$adres', '$adresVermelding');";
$resQuery = mysql_query($query) or die(mysql_error());
Return mysql_insert_id();
}
function addGeborenNest_kittens($id, $beschikbaar, $kleur, $sex) {
$query = "INSERT INTO tblGeborenNesten_kittens (nestID, kleur, geslacht, available) VALUES ($id, '$kleur', '$sex', '$beschikbaar');";
$resQuery = mysql_query($query) or die(mysql_error());
}
function delGeborenNest($id) {
$query = "DELETE FROM tblGeborenNesten WHERE id = $id;";
$resQuery = mysql_query($query) or die(mysql_error());
$query = "DELETE FROM tblFotos WHERE type = 'geboren' AND catID = $id;";
$resQuery = mysql_query($query) or die(mysql_error());
/*
@unlink("/web/kittenpagina/geborenfoto/foto_large_" . $id . "_1.jpg");
@unlink("/web/kittenpagina/geborenfoto/foto_large_" . $id . "_2.jpg");
@unlink("/web/kittenpagina/geborenfoto/foto_small_" . $id . "_1.jpg");
@unlink("/web/kittenpagina/geborenfoto/foto_small_" . $id . "_2.jpg");
*/
@unlink("/web/ourim/kittenpagina.com/www/geborenfoto/foto_large_" . $id . "_1.jpg");
@unlink("/web/ourim/kittenpagina.com/www/geborenfoto/foto_large_" . $id . "_2.jpg");
@unlink("/web/ourim/kittenpagina.com/www/geborenfoto/foto_small_" . $id . "_1.jpg");
@unlink("/web/ourim/kittenpagina.com/www/geborenfoto/foto_small_" . $id . "_2.jpg");
}
function editGeborenNest($id,$catteryNaam,$erkenningsnummer,$member,$contactpersoon,$land,$website,$email,$telefoon,$mobiel,$dob,$infoVader,$infoMoeder,$comments, $adres, $showAdres) {
$query = "UPDATE tblGeborenNesten SET catteryNaam = '$catteryNaam', erkenningsnummer = '$erkenningsnummer', member = '$member', contactpersoon = '$contactpersoon', land = '$land', website = '$website', email = '$email', telefoon = '$telefoon', mobiel = '$mobiel', dobDatum = '$dob', infoVader = '$infoVader', infoMoeder = '$infoMoeder', comments = '$comments', adres = '$adres', chkAdres = '$showAdres' WHERE id = $id;";
$resQuery = mysql_query($query) or die(mysql_error());
}
function editGeborenNest_kittens($number, $beschikbaar, $kleur, $sex) {
$query = "UPDATE tblGeborenNesten_kittens SET kleur = '$kleur', geslacht = '$sex', available = '$beschikbaar' WHERE id = $number;";
$resQuery = mysql_query($query) or die(mysql_error());
}
function getCountGeborenNesten($rasID) {
$query = "SELECT count(id) AS cntRows FROM tblGeborenNesten WHERE rasID = $rasID AND stage = 4 AND (DATEDIFF(CURRENT_DATE(), dateGeplaatst) <= 90);";
$resQuery = mysql_query($query) or die(mysql_error());
Return mysql_fetch_array($resQuery);
}
function getListGeborenNest_ras($ras) {
$query = "SELECT id, catteryNaam, land, dobDatum, date_format(dateGeplaatst, '%d/%m/%Y') AS dateGeplaatst2 FROM tblGeborenNesten WHERE rasID = $ras AND stage = 4 AND (DATEDIFF(CURRENT_DATE(), dateGeplaatst) <= 90) ORDER BY dateGeplaatst DESC;";
$resQuery = mysql_query($query) or die(mysql_error());
for($ii=0; $ii<mysql_num_rows($resQuery); $ii++) {
$arrReturn[] = mysql_fetch_array($resQuery);
}
Return $arrReturn;
}
function getCountAvailableKittens($id) {
$query = "SELECT id FROM tblGeborenNesten_kittens WHERE nestID = $id AND available IN ('Y','O')";
$resQuery = mysql_query($query) or die(mysql_error());
Return mysql_num_rows($resQuery);
}
function getInfo_geborennest($id) {
$query = "SELECT rasID, ras, catteryNaam, erkenningsnummer, land, website, email, telefoon, mobiel, chkAdres, adres, member, contactpersoon, dobDatum, infoVader, infoMoeder, date_format(dateGeplaatst, '%d/%m/%Y') AS dateGeplaatst, comments FROM tblGeborenNesten, tblSoorten WHERE tblGeborenNesten.id = $id AND tblGeborenNesten.rasID = tblSoorten.id;";
$resQuery = mysql_query($query) or die($query);
if(mysql_num_rows($resQuery) == 1) {
$row = mysql_fetch_array($resQuery);
Return $row;
}
else {
Return false;
}
}
function getInfoKatjes_geborennest($nestID) {
$query = "SELECT * FROM tblGeborenNesten_kittens WHERE nestID = $nestID AND available <> '0' ORDER BY geslacht;";
$resQuery = mysql_query($query) or die(mysql_error());
for($ii=0; $ii<mysql_num_rows($resQuery); $ii++) {
$arrReturn[] = mysql_fetch_array($resQuery);
}
Return $arrReturn;
}
function addGeborenNestFoto($catID, $number, $foto) {
/*
if(move_uploaded_file($foto, "/web/kittenpagina/geborenfoto/temp_" . $catID . "_" . $number . ".jpg")) {
$fotoLink = "/web/kittenpagina/geborenfoto/foto_large_" . $catID . "_" . $number . ".jpg";
$newHeight = $this->createFotoGD_525("/web/kittenpagina/geborenfoto/temp_" . $catID . "_" . $number . ".jpg", $fotoLink);
$query = "INSERT INTO tblFotos (type, size, height, catID, foto, link) VALUES ('geboren', 'large', $newHeight, $catID, $number, 'geborenfoto/foto_large_" . $catID . "_" . $number . ".jpg')";
$resQuery = mysql_query($query) or die(mysql_error());
$fotoLink = "/web/kittenpagina/geborenfoto/foto_small_" . $catID . "_" . $number . ".jpg";
$newHeight = $this->createFotoGD_240("/web/kittenpagina/geborenfoto/temp_" . $catID . "_" . $number . ".jpg",$fotoLink);
$query = "INSERT INTO tblFotos (type, size, height, catID, foto, link) VALUES ('geboren', 'small', $newHeight, $catID, $number, 'geborenfoto/foto_small_" . $catID . "_" . $number . ".jpg')";
$resQuery = mysql_query($query) or die(mysql_error());
@unlink("/web/kittenpagina/geborenfoto/temp_" . $catID . "_" . $number . ".jpg");
}
*/
if(move_uploaded_file($foto, "/web/ourim/kittenpagina.com/www/geborenfoto/temp_" . $catID . "_" . $number . ".jpg")) {
$fotoLink = "/web/ourim/kittenpagina.com/www/geborenfoto/foto_large_" . $catID . "_" . $number . ".jpg";
$newHeight = $this->createFotoGD_525("/web/ourim/kittenpagina.com/www/geborenfoto/temp_" . $catID . "_" . $number . ".jpg", $fotoLink);
$query = "INSERT INTO tblFotos (type, size, height, catID, foto, link) VALUES ('geboren', 'large', $newHeight, $catID, $number, 'geborenfoto/foto_large_" . $catID . "_" . $number . ".jpg')";
$resQuery = mysql_query($query) or die(mysql_error());
$fotoLink = "/web/ourim/kittenpagina.com/www/geborenfoto/foto_small_" . $catID . "_" . $number . ".jpg";
$newHeight = $this->createFotoGD_240("/web/ourim/kittenpagina.com/www/geborenfoto/temp_" . $catID . "_" . $number . ".jpg",$fotoLink);
$query = "INSERT INTO tblFotos (type, size, height, catID, foto, link) VALUES ('geboren', 'small', $newHeight, $catID, $number, 'geborenfoto/foto_small_" . $catID . "_" . $number . ".jpg')";
$resQuery = mysql_query($query) or die(mysql_error());
@unlink("/web/ourim/kittenpagina.com/www/geborenfoto/temp_" . $catID . "_" . $number . ".jpg");
}
}
function editGeborenNestFoto($catID, $number, $foto) {
/*
if(move_uploaded_file($foto, "/web/kittenpagina/geborenfoto/temp_" . $catID . "_" . $number . ".jpg")) {
@unlink("/web/kittenpagina/geborenfoto/foto_large_" . $catID . "_" . $number . ".jpg");
@unlink("/web/kittenpagina/geborenfoto/foto_small_" . $catID . "_" . $number . ".jpg");
$query = "DELETE FROM tblFotos WHERE catID = $catID AND foto = $number AND type = 'geboren';";
$resQuery = mysql_query($query) or die(mysql_error());
$fotoLink = "/web/kittenpagina/geborenfoto/foto_large_" . $catID . "_" . $number . ".jpg";
$newHeight = $this->createFotoGD_525("/web/kittenpagina/geborenfoto/temp_" . $catID . "_" . $number . ".jpg", $fotoLink);
$query = "INSERT INTO tblFotos (type, size, height, catID, foto, link) VALUES ('geboren', 'large', $newHeight, $catID, $number, 'geborenfoto/foto_large_" . $catID . "_" . $number . ".jpg')";
$resQuery = mysql_query($query) or die(mysql_error());
$fotoLink = "/web/kittenpagina/geborenfoto/foto_small_" . $catID . "_" . $number . ".jpg";
$newHeight = $this->createFotoGD_240("/web/kittenpagina/geborenfoto/temp_" . $catID . "_" . $number . ".jpg",$fotoLink);
$query = "INSERT INTO tblFotos (type, size, height, catID, foto, link) VALUES ('geboren', 'small', $newHeight, $catID, $number, 'geborenfoto/foto_small_" . $catID . "_" . $number . ".jpg')";
$resQuery = mysql_query($query) or die(mysql_error());
@unlink("/web/kittenpagina/geborenfoto/temp_" . $catID . "_" . $number . ".jpg");
}
*/
if(move_uploaded_file($foto, "/web/ourim/kittenpagina.com/www/geborenfoto/temp_" . $catID . "_" . $number . ".jpg")) {
@unlink("/web/ourim/kittenpagina.com/www/geborenfoto/foto_large_" . $catID . "_" . $number . ".jpg");
@unlink("/web/ourim/kittenpagina.com/www/geborenfoto/foto_small_" . $catID . "_" . $number . ".jpg");
$query = "DELETE FROM tblFotos WHERE catID = $catID AND foto = $number AND type = 'geboren';";
$resQuery = mysql_query($query) or die(mysql_error());
$fotoLink = "/web/ourim/kittenpagina.com/www/geborenfoto/foto_large_" . $catID . "_" . $number . ".jpg";
$newHeight = $this->createFotoGD_525("/web/ourim/kittenpagina.com/www/geborenfoto/temp_" . $catID . "_" . $number . ".jpg", $fotoLink);
$query = "INSERT INTO tblFotos (type, size, height, catID, foto, link) VALUES ('geboren', 'large', $newHeight, $catID, $number, 'geborenfoto/foto_large_" . $catID . "_" . $number . ".jpg')";
$resQuery = mysql_query($query) or die(mysql_error());
$fotoLink = "/web/ourim/kittenpagina.com/www/geborenfoto/foto_small_" . $catID . "_" . $number . ".jpg";
$newHeight = $this->createFotoGD_240("/web/ourim/kittenpagina.com/www/geborenfoto/temp_" . $catID . "_" . $number . ".jpg",$fotoLink);
$query = "INSERT INTO tblFotos (type, size, height, catID, foto, link) VALUES ('geboren', 'small', $newHeight, $catID, $number, 'geborenfoto/foto_small_" . $catID . "_" . $number . ".jpg')";
$resQuery = mysql_query($query) or die(mysql_error());
@unlink("/web/ourim/kittenpagina.com/www/geborenfoto/temp_" . $catID . "_" . $number . ".jpg");
}
}
function getPhotos_geborennest($catID) {
$query = "SELECT * FROM tblFotos WHERE catID = $catID AND type = 'geboren';";
$resQuery = mysql_query($query) or die(mysql_error());
for($ii=0; $ii<mysql_num_rows($resQuery); $ii++) {
$arrReturn[] = mysql_fetch_array($resQuery);
}
Return $arrReturn;
}
function getPhotosGeborenNest_small($catID) {
$query = "SELECT * FROM tblFotos WHERE catID = $catID AND type = 'geboren' AND size = 'small' ORDER BY link ASC;";
$resQuery = mysql_query($query) or die(mysql_error());
for($ii=0; $ii<mysql_num_rows($resQuery); $ii++) {
$arrReturn[] = mysql_fetch_array($resQuery);
}
Return $arrReturn;
}
function getPhotosGeborenNest_large($catID) {
$query = "SELECT * FROM tblFotos WHERE catID = $catID AND type = 'geboren' AND size = 'large' ORDER BY link ASC;";
$resQuery = mysql_query($query) or die(mysql_error());
for($ii=0; $ii<mysql_num_rows($resQuery); $ii++) {
$arrReturn[] = mysql_fetch_array($resQuery);
}
Return $arrReturn;
}
function sendMailGeborenNest($id) {
$query = "SELECT tblGeborenNesten.*, tblSoorten.ras FROM tblGeborenNesten, tblSoorten WHERE tblGeborenNesten.id = $id AND tblGeborenNesten.rasID = tblSoorten.id;";
$resQuery = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($resQuery) == 1) {
$arrMail = mysql_fetch_array($resQuery);
$bevestiging_bericht = "
<font size=\"2\" face=\"Verdana\">
Op " . $arrMail['dateGeplaatst'] . " werd volgende advertentie toegevoegd:
<p>
Soort advertentie: Geboren Nestje<BR>
<br>
Catterynaam: " . $arrMail['catteryNaam'] . "<br>
Erkenningsnummer: " . $arrMail['erkenningsnummer'] . "<br>
<BR>
Contactpersoon: " . $arrMail['contactpersoon'] . "<br>
Adres: " . nl2br($arrMail['adres']) . "<br>
Adres vermelden in advertentie: " . $arrMail['chkAdres'] . "<br>
Land: " . $arrMail['land'] . "<br>
<br>
E-mail: " . $arrMail['email'] . "<br>
Website: " . $arrMail['website'] . "<BR>
Telefoon: " . $arrMail['telefoon'] . "<br>
GSM-nummer: " . $arrMail['mobiel'] . "<br>
<br>
Lid van: " . $arrMail['member'] . "<br>
<BR><BR>
Ras: " . $arrMail['ras'] . "<br>
Geboortedatum: " . $arrMail['dobDatum'] . "<br><br>
Info Vader:<BR>" . nl2br($arrMail['infoVader']) . "<br><br>
Info Moeder:<BR>" . nl2br($arrMail['infoMoeder']) . "<br><br>
Extra Commentaar:<br>" . nl2br($arrMail['comments']) . "<br><br>
Vermelden in cattery-lijst: " . $arrMail['chkCattery'] ."<br>
</font>
";
}
else {
$bevestiging_bericht = "Fout bij het ophalen van de gegevens!!";
}
$this->sendBevestiging($bevestiging_bericht, 'Geboren Nestje');
}
//
// ADMIN GEBOREN NESTJES FUNCTIONS
//
function getGeborenNestje_fase($rasID, $fase) {
$query = "SELECT id, catteryNaam, dobDatum FROM tblGeborenNesten WHERE rasID = $rasID AND stage = $fase AND (DATEDIFF(CURRENT_DATE(), dateGeplaatst) <= 90) ORDER BY dateGeplaatst ASC;";
$resQuery = mysql_query($query) or die(mysql_error());
for($ii=0; $ii<mysql_num_rows($resQuery); $ii++) {
$arrReturn[] = mysql_fetch_array($resQuery);
}
Return $arrReturn;
}
function geborenNestje_upStage($id, $fase) {
$fase++;
$query = "UPDATE tblGeborenNesten SET stage = $fase WHERE id = $id";
mysql_query($query) or die("Error in query: " . $query . "<p>" . mysql_error());
if($fase == 4) {
$vandaag = date("Y-m-d");
$query = "UPDATE tblGeborenNesten SET dateGeplaatst = '$vandaag' WHERE id = $id;";
mysql_query($query) or die("Error in query: " . $query . "<p>" . mysql_error());
}
}
function getGeborenNestje_old($rasID) {
$query = "SELECT id, catteryNaam, dobDatum FROM tblGeborenNesten WHERE rasID = $rasID AND (DATEDIFF(CURRENT_DATE(), dateGeplaatst) > 90) ORDER BY dateGeplaatst ASC;";
$resQuery = mysql_query($query) or die(mysql_error());
for($ii=0; $ii<mysql_num_rows($resQuery); $ii++) {
$arrReturn[] = mysql_fetch_array($resQuery);
}
Return $arrReturn;
}
function addGeborenNest_admin($chkStamboom,$catteryNaam,$erkenningsnummer,$member,$contactpersoon,$land,$website,$email,$telefoon,$mobiel,$rasID,$dob,$infoVader,$infoMoeder,$comments,$catteryVermelding, $adres, $adresVermelding, $datum) {
$query = "INSERT INTO tblGeborenNesten (dateGeplaatst, chkStamboom, catteryNaam, erkenningsnummer, member, contactpersoon, land, website, email, telefoon, mobiel, rasID, dobDatum, infoVader, infoMoeder, comments, chkCattery, adres, chkAdres, stage) VALUES ('$datum', '$chkStamboom', '$catteryNaam', '$erkenningsnummer', '$member', '$contactpersoon', '$land', '$website', '$email', '$telefoon', '$mobiel', $rasID, '$dob', '$infoVader', '$infoMoeder', '$comments', '$catteryVermelding', '$adres', '$adresVermelding', 4);";
$resQuery = mysql_query($query) or die(mysql_error());
Return mysql_insert_id();
}
function addGeborenNest_fromVerwacht($chkStamboom,$catteryNaam,$erkenningsnummer,$member,$contactpersoon,$land,$website,$email,$telefoon,$mobiel,$rasID,$dob,$infoVader,$infoMoeder,$comments, $adres, $adresVermelding) {
$query = "INSERT INTO tblGeborenNesten (dateGeplaatst, chkStamboom, catteryNaam, erkenningsnummer, member, contactpersoon, land, website, email, telefoon, mobiel, rasID, dobDatum, infoVader, infoMoeder, comments, chkCattery, adres, chkAdres, stage) VALUES ('" . date("Y-m-d") . "', '$chkStamboom', '$catteryNaam', '$erkenningsnummer', '$member', '$contactpersoon', '$land', '$website', '$email', '$telefoon', '$mobiel', $rasID, '$dob', '$infoVader', '$infoMoeder', '$comments', 'Y', '$adres', '$adresVermelding', 4);";
$resQuery = mysql_query($query) or die(mysql_error());
Return mysql_insert_id();
}
function getInfoFromVerwacht($id) {
$query = "SELECT * FROM tblVerwachteNesten WHERE id = $id;";
$resQuery = mysql_query($query) or die(mysql_error());
Return mysql_fetch_array($resQuery);
}
//
