ignore-Competencies.js

function giveTripDirector() {
	const meta_key = "competency_overnight_trip_director";
	const meta_value = "Signed Off";
	giveCompetency(meta_key, meta_value);
}

function giveTripDirectorTraining() {
	const meta_key = "competency_overnight_trip_director";
	const meta_value = "In Training";
	giveCompetency(meta_key, meta_value);
}

function giveTripDirectorToLearn() {
	const meta_key = "competency_overnight_trip_director";
	const meta_value = "Keen to Learn";
	giveCompetency(meta_key, meta_value);
}

function giveEveningMealChef() {
	const meta_key = "competency_evening_meal_chef";
	const meta_value = "Signed Off";
	giveCompetency(meta_key, meta_value);
}

function giveEveningMealChefTraining() {
	const meta_key = "competency_evening_meal_chef";
	const meta_value = "In Training";
	giveCompetency(meta_key, meta_value);
}

function giveEveningMealChefToLearn() {
	const meta_key = "competency_evening_meal_chef";
	const meta_value = "Keen to Learn";
	giveCompetency(meta_key, meta_value);
}

function giveBreakfastLunchChef() {
	const meta_key = "competency_breakfast_lunch_chef";
	const meta_value = "Signed Off";
	giveCompetency(meta_key, meta_value);
}

function giveBreakfastLunchChefTraining() {
	const meta_key = "competency_breakfast_lunch_chef";
	const meta_value = "In Training";
	giveCompetency(meta_key, meta_value);
}

function giveBreakfastLunchChefToLearn() {
	const meta_key = "competency_breakfast_lunch_chef";
	const meta_value = "Keen to Learn";
	giveCompetency(meta_key, meta_value);
}

function giveLiftCoordinator() {
	const meta_key = "competency_lift_coordinator";
	const meta_value = "Signed Off";
	giveCompetency(meta_key, meta_value);
}

function giveActivitiesCoord() {
	const meta_key = "competency_activities_coordinator";
	const meta_value = "Signed Off";
	giveCompetency(meta_key, meta_value);
}

function giveCompetency(meta_key, meta_value) {
	const spreadsheet = SpreadsheetApp.getActive();
	const sheet = spreadsheet.getSheetByName("Volunteering");
	const active_range = sheet.getActiveRange();
	const currentRow = active_range.getRowIndex();
	//var currentRow = "18";
	console.log(currentRow);
	//var meta_key = "competency_indoor_trip_director"
	//var meta_value = "Signed Off"

	if (currentRow <= 2) {
		Browser.msgBox("Select an actual signup", Browser.Buttons.OK);
		return;
	}
	if (currentRow >= 100) {
		Browser.msgBox("Select an actual signup", Browser.Buttons.OK);
		return;
	}

	const user_id = sheet.getRange(currentRow, 19, 1, 1).getValue(); /// get submission ID 1 BV ( was 67)
	const first_name = sheet.getRange(currentRow, 1, 1, 1).getValue(); /// get submission ID 1 BV ( was 67)

	//console.log(user_id);

	if (user_id === "" || user_id === "user_id") {
		Browser.msgBox("No User ID Found", Browser.Buttons.OK);
		return;
	}

	if (
		Browser.msgBox(
			`Given a competency to ${first_name}? \n User ${user_id}`,
			Browser.Buttons.OK_CANCEL,
		) === "ok"
	) {
		const cc_attendance_setter = Session.getActiveUser().getEmail();

		//let metakey = "milestones_3_badge"
		//let metavalue = "given"
		const datetime = Date.now();
		//Logger.log(datetime);

		const meta_key_given_at = `${meta_key}_marked_given_at`;
		const meta_key_given_by = `${meta_key}_marked_given_by`;

		const data = {
			meta_data: [
				{ key: meta_key, value: meta_value },
				{ key: meta_key_given_at, value: datetime },
				{ key: meta_key_given_by, value: cc_attendance_setter },
			],
		};

		let returndata = pokeToWooUserMeta(data, user_id); //returns JSON object
		returndata = returndata.getContentText();
		returndata = JSON.parse(returndata);

		//Logger.log("type " + typeof(returndata)); // type object
		//Logger.log(returndata.data); // Logging output too large. Truncating output. {"id":52,"date_created":"2021-08-27T23:24:39","date_created_gmt":"2021-08-27T22:24:39","date_modified":"2022-11-23T11:51:41", etc etc etc
		//Logger.log(returndata[0]); //null
		//Logger.log("type " + typeof(returndata.id)); //type undefined
		//Logger.log(returndata.data.id); //null

		const search = returndata.meta_data.find(
			({ key }) => key === meta_key,
		)?.value;

		//Logger.log(search);

		if (search === meta_value) {
			sheet.getRange(currentRow, 2, 1, 1).setValue("Given"); // paste the blank variables into the cells to delete contents
			sheet.getRange(currentRow, 15, 1, 1).setValue(meta_key);
			sheet.getRange(currentRow, 16, 1, 1).setValue(meta_value); // paste the blank variables into the cells to delete contents

			return meta_value;
		}
	}

	//Logger.log(returnvalue.meta_data);
	//Logger.log(" type " + typeof(returnvalue.meta_data));

	//Logger.log(JSON.parse(returnvalue));
	//Logger.log(JSON.stringify(returnvalue.meta_data));

	//return returndata;
}