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;
}
$_POST = $children->escapeData($_POST);
//set variables
$regId = intval($_POST['RegId']);
$memberId = intval($_POST['MemberId']);
$kidId = intval($_POST['KidId']);
$children->name = empty($_POST['Name']) ? 'NULL' : "'" . $_POST['Name'] . "'";
$children->dob = empty($_POST['DOB']) ? 'NULL' : "'" . $_POST['DOB'] . "'";
$children->gender = empty($_POST['Gender']) ? 0 : intval($_POST['Gender']);
$children->email = empty($_POST['Email']) ? 'NULL' : "'" . $_POST['Email'] . "'";
$children->email1 = empty($_POST['Email1']) ? 'NULL' : "'" . $_POST['Email1'] . "'";
$children->mobile = empty($_POST['Mobile']) ? 'NULL' : "'" . $_POST['Mobile'] . "'";
$children->mobile1 = empty($_POST['Mobile1']) ? 'NULL' : "'" . $_POST['Mobile1'] . "'";
$children->mobile2 = empty($_POST['Mobile2']) ? 'NULL' : "'" . $_POST['Mobile2'] . "'";
$children->bloodGroup = empty($_POST['BloodGroup']) ? 'NULL' : "'" . $_POST['BloodGroup'] . "'";
$children->hobbies = empty($_POST['Hobbies']) ? 'NULL' : "'" . $_POST['Hobbies'] . "'";
//Perform action
$response = $children->updateChildren($regId, $memberId, $kidId);
break;
case 'GC':
//Perform action
$regId = intval($_POST['RegId']);
$memberId = intval($_POST['MemberId']);
$kidId = intval($_POST['KidId']);
$response = $children->getChildren($memberId, $regId, $kidId);
break;
case 'LI':
$response = BaseClass::isAdmin();
}
}
header('Content-Type: application/json');
echo json_encode($response);
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;
}
*/
namespace Project\Register;
use Project\Base\BaseClass;
session_start();
define("ROOT", "../");
require ROOT . "autoload.php";
require ROOT . "authenticate.php";
$response = null;
//Do validation if required
do {
if (isset($_GET)) {
$validate = true;
} else {
$validate = false;
$response = BaseClass::createResponse(0, "Invalid Request");
}
} while (0);
//Create mapping based on request
/*
* 1 => get all registered users list
* 2 => get particular user details
* 3 => create csv file and send csv file has response
*
*/
if ($validate) {
$reportType = 1;
if (!empty($_GET['id'])) {
$reportType = 2;
}
if (!empty($_GET['type'])) {
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;
}
function __construct()
{
parent::__construct();
//Initialize variables
$this->users = array("User1", "User2", "User3");
}
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;
}
