<?php
require 'donations.php';
//create the new object
$testDonation = new donations();
echo "1. Donation Object Creation: ";
if ($testDonation != null) {
echo "Passed.<br>\n";
} else {
echo "Failed.<br>\n";
}
//make sure the database is clear
$testDonation->clearIt();
//add a new entry to the database
$testDonation->sqlInsert("AAA", "AAA", "AAA", "AAA", "AAA", 3, 0);
//test to find entries with ISNEW value 1, should return null
echo "2. Database contains 0 entries ISNEW=1, query for rows ISNEW=1 should return no entries: ";
$returnedRows = $testDonation->rowInfo(1);
if (count($returnedRows) == 0) {
echo "Passed.<br>\n";
} else {
echo "Failed.<br>\n";
}
//test to find entries with ISNEW value 0, should return 1 entry
echo "3. Database contains 1 entries ISNEW=1, query for rows ISNEW=1 should return 1 entry: ";
$returnedRows = $testDonation->rowInfo(0);
if (count($returnedRows) == 1) {
echo "Passed.<br>\n";
} else {
echo "Failed.<br>\n";
}
}
if (isset($_POST['produce']) && isset($_POST['perishables'])) {
$donorValue = 4;
}
if (isset($_POST['produce']) && isset($_POST['shelf-stable'])) {
$donorValue = 5;
}
if (isset($_POST['shelf-stable']) && isset($_POST['perishables'])) {
$donorValue = 6;
}
if (isset($_POST['produce']) && isset($_POST['shelf-stable']) && isset($_POST['perishables'])) {
$donorValue = 6;
}
// enter data into database
$dbEntry = new donations();
$dbEntry->sqlInsert($donorName, $donorContact, $donorEmail, $donorPhone, $donorDesc, $donorValue, $vendorName, 1);
// set email subject
$subject = "Scheduled Pickup Requested";
// set donation detais
$donationDetails = "Donation Details:\n" . $donorDesc . "\n\n";
$donationDetails .= "Donation Type:\n" . $donorType . "\n\n";
// set donor and vendor messages
$vendorMessage = "\nTo: " . $vendorEmail . "\nForm: " . $donorEmail . "\n\n";
$vendorMessage .= $donorContact . " from " . $donorName . " has requested to schedule a pickup.\n\n";
$vendorMessage .= "Contact Information:\nDonorEmail: " . $donorEmail . "\n";
$vendorMessage .= "Donor Phone Number: " . $donorPhone . "\n\n" . $donationDetails;
$donorMessage = "\nTo: " . $donorEmail . "\nFrom: " . $vendorEmail . "\n\n";
$donorMessage .= "You have requested to schedule a pickup from " . $vendorName . ".\n\n";
$donorMessage .= "Contact Information:\nDistributor Email: " . $vendorEmail . "\n";
$donorMessage .= "Phone Number: " . $vendorPhone . "\n\n" . $donationDetails;
//set headers
