public function insert()
{
if (!is_null($this->id)) {
trigger_error("User::insert(): Attempt to insert a user object that already has its ID property set to {$this->id}.", E_USER_ERROR);
}
$conn = new PDO(DB_DSN, DB_USERNAME, DB_PASSWORD);
$sql = "INSERT INTO " . TABLENAME_DATEREQUESTS . " ( type, shopId, sentById, sentToGroupId, sentToUserId, status, date ) VALUES ( :type, :shopId, :sentById, :sentToGroupId, :sentToUserId, :status, :date)";
$st = $conn->prepare($sql);
$st->bindValue(":type", $this->type, PDO::PARAM_STR);
$st->bindValue(":shopId", $this->shopId, PDO::PARAM_INT);
$st->bindValue(":sentById", $this->sentById, PDO::PARAM_INT);
$st->bindValue(":sentToGroupId", $this->sentToGroupId, PDO::PARAM_INT);
$st->bindValue(":sentToUserId", $this->sentToUserId, PDO::PARAM_INT);
$st->bindValue(":status", $this->status, PDO::PARAM_STR);
$st->bindValue(":date", $this->date, PDO::PARAM_STR);
// print_r( $st );
$result = $st->execute();
$this->id = $conn->lastInsertId();
$conn = null;
if (!$result) {
self::$errorMessage = "User::insert: Insertion Failed, PDO::errorInfo(): " . $st->errorCode() . ": " . $st->errorInfo()[2];
self::$errorCode = $st->errorCode();
//echo $errorMessage;
return false;
} else {
self::$successMessage = "User::insert: User successfully inserted with id " . $this->id;
return true;
}
}
function acceptDateRequest()
{
$dateRequest = DateRequest::getById($_GET['id']);
$dateRequest->status = "accepted";
$dateRequest->update();
$dateRequests = DateRequest::getOthers($dateRequest->sentById, $dateRequest->type, $dateRequest->sentToGroupId, $dateRequest->sentToUserId);
if ($dateRequests[0]['status'] == "accepted" && $dateRequests[1]['status'] == "accepted" && $dateRequest->status == "accepted") {
$dateRequest->status = "successful";
$dateRequest->update();
}
require TEMPLATE_PATH . "/home.php";
}
function date_req()
{
if (isset($_SESSION['groupId'])) {
echo "date requests for this group:<br>";
// date requests for group which has been selected
$dateRequests = DateRequest::getByUserId($_SESSION['userId'], $_SESSION['groupId']);
$a = sizeof($dateRequests);
for ($i = 0; $i < $a; $i++) {
$group = Group::getById($dateRequests[$i]["sentById"]);
echo "date request from " . $group->name . "<br>";
echo "users: <br>" . User::getById($group->adminId)->name . " , " . User::getById($group->per2Id)->name . "and" . User::getById($group->per3Id)->name . "<br>";
echo "<a href='/backend/main.php?action=acceptDateRequest&id=" . $dateRequests[$i]["id"] . "'>accept</a>    ";
echo "<a href='/backend/main.php?action=declineDateRequest&id=" . $dateRequests[$i]["id"] . "'>decline</a><br>";
}
echo "accepted date requests:<br>";
// date requests accepted for group which has been selected
$dateRequests = DateRequest::getByGroupId($_SESSION['groupId']);
if ($dateRequests['0']['status'] == "successful" or $dateRequests['1']['status'] == "successful" or $dateRequests['2']['status'] == "successful") {
$group = Group::getById($dateRequests['0']["sentToGroupId"]);
echo "your date request was accepted by" . $group->name . "<br>";
echo "users: <br>" . User::getById($group->adminId)->name . " , " . User::getById($group->per2Id)->name . "and" . User::getById($group->per3Id)->name . "<br>";
}
}
}
echo "users: <br>" . User::getById($group->adminId)->name . " , " . User::getById($group->per2Id)->name . "and" . User::getById($group->per3Id)->name . "<br>";
echo "<a href='/dating_website/index.php?action=acceptChatRequest&id=" . $chatRequests[$i]["id"] . "'>accept</a>    ";
echo "<a href='/dating_website/index.php?action=declineChatRequest&id=" . $chatRequests[$i]["id"] . "'>decline</a><br>";
}
echo "date requests for this group:<br>";
$dateRequests = DateRequest::getByUserId($_SESSION['userId'], $_SESSION['groupId']);
$a = sizeof($dateRequests);
for ($i = 0; $i < $a; $i++) {
$group = Group::getById($dateRequests[$i]["sentById"]);
echo "date request from " . $group->name . "<br>";
echo "users: <br>" . User::getById($group->adminId)->name . " , " . User::getById($group->per2Id)->name . "and" . User::getById($group->per3Id)->name . "<br>";
echo "<a href='/dating_website/index.php?action=acceptDateRequest&id=" . $dateRequests[$i]["id"] . "'>accept</a>    ";
echo "<a href='/dating_website/index.php?action=declineDateRequest&id=" . $dateRequests[$i]["id"] . "'>decline</a><br>";
}
echo "accepted date requests:<br>";
$dateRequests = DateRequest::getByGroupId($_SESSION['groupId']);
if ($dateRequests['0']['status'] == "successful" or $dateRequests['1']['status'] == "successful" or $dateRequests['2']['status'] == "successful") {
$group = Group::getById($dateRequests['0']["sentToGroupId"]);
echo "your date request was accepted by" . $group->name . "<br>";
echo "users: <br>" . User::getById($group->adminId)->name . " , " . User::getById($group->per2Id)->name . "and" . User::getById($group->per3Id)->name . "<br>";
}
} else {
echo "select a group to proceed" . "<br>";
}
$groupsPending = Group::getListPendingByAdminId($_SESSION['userId']);
$groupsCreatedOnline = Group::getListOnlineByAdminId($_SESSION['userId']);
$groupsOnline = Group::getListOnline($_SESSION['userId']);
echo "Groups you are admin for <br> ";
for ($i = 0; $i < sizeof($groupsCreatedOnline); $i++) {
echo "Group Name: " . $groupsCreatedOnline[$i]["name"] . "<br>";
echo "group members: <br>";
