function updateDirector($memberId, $regId)
{
$sql = "UPDATE directors SET Post={$this->post} WHERE MemberId={$memberId} AND RegId={$regId}";
if ($result = $this->mysqli->query($sql)) {
$response = BaseClass::createResponse(1, "Director details updated.");
} else {
$response = BaseClass::createResponse(0, $this->mysqli->error);
}
return $response;
}
public function getMembers($regId)
{
$sql = "SELECT Members.MemberId, Members.Name FROM Members LEFT JOIN Spouse ON Spouse.RegId = Members.RegId AND Spouse.MemberId = Members.MemberId WHERE Members.RegId = {$regId};";
if ($result = $this->mysqli->query($sql)) {
$response = BaseClass::createResponse(1, "Successful");
$response["list"] = [];
while ($row = $result->fetch_assoc()) {
$response["list"][] = $row;
}
} else {
$response = BaseClass::createResponse(0, $this->mysqli->error);
}
return $response;
}
if (!$member->isMember($_POST['MemberId'])) {
$response = BaseClass::createResponse(0, "Member ID does not exist.");
}
break;
case 'DC':
//validation
if (empty($_POST['MemberId'])) {
$validate = false;
$response = BaseClass::createResponse(0, "Invalid Request");
}
break;
case 'UC':
//validation
if (empty($_POST['RegId']) || empty($_POST['MemberId']) || empty($_POST['KidId']) || empty($_POST['Name']) || empty($_POST['DOB']) || empty($_POST['Gender'])) {
$validate = false;
$response = BaseClass::createResponse(0, "Invalid Request");
}
break;
}
} while (0);
//Business Logic
if ($validate) {
$children = new Children();
switch ($type) {
case 'AC':
//set mysql safe data
$_POST = $children->escapeData($_POST);
//set variables
$memberId = intval($_POST['MemberId']);
$regId = intval($_POST['RegId']);
$children->name = "'" . $_POST['Name'] . "'";
function updateHasChildrenToInactive($memberId)
{
$sql = "UPDATE Members Set hasChildren=2 WHERE MemberId={$memberId}";
if ($result = $this->mysqli->query($sql)) {
$response = BaseClass::createResponse(1, "Has Children field updated.");
} else {
$response = BaseClass::createResponse(0, $this->mysqli->error);
}
return $response;
}
function generateId()
{
$voucherCode = 1001;
$sql = "SELECT MAX(Id) AS 'voucherCode' FROM Members";
if ($result = $this->mysqli->query($sql)) {
$voucherCode = intval($result->fetch_assoc()['voucherCode']);
$voucherCode = $voucherCode == 0 ? 1001 : $voucherCode + 1;
} else {
$this->response = BaseClass::createResponse(0, $this->mysqli->error);
}
return $voucherCode;
}
function addImage($eventId)
{
//Create folder using BaseClass::createDir($path) function
$path = "images/" . $eventId . "/";
//Save image using ImageUpload class
//Image name = "cover.jpg"
//Update the image path in database.
BaseClass::createDir($path);
$imageUpload = new ImageUpload($this->image);
$imageUpload->dstPath = $path;
$imageUpload->dstName = "cover";
if ($imageUpload->save()) {
//ImageUpload class by default saves all the image to jpg
$imagePath = $path . "cover.jpg";
$sql = "UPDATE Events SET ImagePath = '{$imagePath}' WHERE EventId = {$eventId};";
if ($result = $this->mysqli->query($sql)) {
$response = BaseClass::createResponse(1, "Gallery created..");
} else {
$response = BaseClass::createResponse(0, $this->mysqli->error);
}
} else {
$response = $imageUpload->response;
}
//End
return $response;
}
foreach ($l as $i => $v) {
if (!array_key_exists($i, $files)) {
$files[$i] = array();
}
$files[$i][$k] = $v;
}
}
$index = 0;
foreach ($files as $file) {
if ($index == 1 && intval($_POST['HasPartner']) == 1) {
$index++;
}
if ($index > 2) {
break;
}
$path = ROOT . "images/newUsers/";
$name = $id . "_" . $fileSuffix[$index++];
$response = uploadImage($file, $name, $path);
if ($response["status"] == 1) {
$response = BaseClass::createResponse(1, "Form submitted successfully");
} else {
$response = BaseClass::createResponse(1, $response["message"]);
}
}
}
break;
case 'D':
$response = $settings->deleteUser(intval($_POST['id']));
}
}
echo json_encode($response);
function getGalleryDetails($galleryId)
{
$sql = "SELECT * FROM Gallery where Id={$galleryId}";
if ($result = $this->mysqli->query($sql)) {
$response = BaseClass::createResponse(1, "Success");
$response['result'] = array();
while ($row = $result->fetch_assoc()) {
$response['result'] = $row;
}
} else {
$response = BaseClass::createResponse(0, $this->mysqli->error);
}
return $response;
}
function ActivateRsvp($eventId, $memberId)
{
//for this function to work you have to add (name:"Active", type:"tinyint", NOT NULL DEFAULT 2) field into the RSVP table
//When this function is called you have to update the active field to value 1
//Don't forget to update the query in updateRsvp()..
$this->active = 1;
$sql = "UPDATE Rsvp SET Rsvp.Active={$this->active} WHERE Rsvp.EventId={$eventId} AND Rsvp.MemberId={$memberId}";
if ($result = $this->mysqli->query($sql)) {
$response = BaseClass::createResponse(1, "Active value updated..");
} else {
$response = BaseClass::createResponse(0, "Active value not updated..");
}
return $response;
}
function deleteMember($memberId)
{
$sql = "DELETE FROM Members WHERE MemberId={$memberId}";
if ($this->mysqli->query($sql)) {
$response = BaseClass::createResponse(1, "Member deleted.");
} else {
$response = BaseClass::createResponse(0, $this->mysqli->error);
}
return $response;
}
