X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fgrade_functions.php;h=65ce5c6ed234a413db12f066d86d4bac2b737e26;hb=b7cfbecf4b73cfb05d70af04a31b556ebf7012e8;hp=42c781db2a6825ff12750706831d148d9a4b416c;hpb=155492a5b96cec674846973a8524238b0365a848;p=mailer.git

diff --git a/inc/libs/grade_functions.php b/inc/libs/grade_functions.php
index 42c781db2a..65ce5c6ed2 100644
--- a/inc/libs/grade_functions.php
+++ b/inc/libs/grade_functions.php
@@ -40,6 +40,43 @@ if (!defined('__SECURITY')) {
 	die();
 } // END - if
 
+// Generates a option "list" for all created grade ids
+function generateGradeDataIdOptions ($defaultId = NULL) {
+	// Do we have cache?
+	if (!isset($GLOBALS[__FUNCTION__][$defaultId])) {
+		// Look for all
+		$grades = getArrayFromTable('grade_data', array('grade_id', 'grade_name'), 'grade_id');
+
+		// Init entries arrays
+		$gradeKeys = array();
+		$gradeValues = array();
+
+		// Load all entries
+		foreach ($grades as $grade) {
+			// Add it to arrays
+			array_push($gradeKeys  , $grade['grade_id']);
+			array_push($gradeValues, $grade['grade_name']);
+		} // END - foreach
+
+		// Generate option "list"
+		$GLOBALS[__FUNCTION__][$defaultId] = generateOptions(
+			'/ARRAY/',
+			$gradeKeys,
+			$gradeValues,
+			$defaultId,
+			'',
+			'',
+			array(),
+			'',
+			TRUE,
+			FALSE
+		);
+	} // END - if
+
+	// Return cache
+	return $GLOBALS[__FUNCTION__][$defaultId];
+}
+
 // Generates a option "list" for all created "parent" grade ids
 function generateGradeDataParentIdOptions ($defaultId = NULL) {
 	// Do we have cache?
@@ -50,32 +87,22 @@ function generateGradeDataParentIdOptions ($defaultId = NULL) {
 		// Is default set?
 		if (!is_null($defaultId)) {
 			// Then exlude it
-			$whereStatement = sprintf('WHERE `grade_id`=%s', bigintval($defaultId));
+			$whereStatement = sprintf('WHERE `grade_id` != %s', bigintval($defaultId));
 		} // END - if
 
 		// Look for all
-		$result = sqlQuery('SELECT
-	`grade_id`,
-	`grade_name`
-FROM
-	`{?_MYSQL_PREFIX?}_grade_data`
-' . $whereStatement . '
-ORDER BY
-	`grade_id` ASC', __FUNCTION__, __LINE__);
+		$grades = getArrayFromTable('grade_data', array('grade_id', 'grade_name'), 'grade_id', 'ASC', $whereStatement);
 
 		// Init entries arrays
 		$gradeKeys = array();
 		$gradeValues = array();
 
 		// Are there entries?
-		if (!ifSqlHasZeroNums($result)) {
-			// Load all entries
-			while ($grade = sqlFetchArray($result)) {
-				// Add it to arrays
-				array_push($gradeKeys  , $grade['grade_id']);
-				array_push($gradeValues, $grade['grade_name']);
-			} // END - while
-		} // END - if
+		foreach ($grades as $grade) {
+			// Add it to arrays
+			array_push($gradeKeys  , $grade['grade_id']);
+			array_push($gradeValues, $grade['grade_name']);
+		} // END - foreach
 
 		// Generate option "list"
 		$GLOBALS[__FUNCTION__][$defaultId] = generateOptions(
@@ -84,15 +111,22 @@ ORDER BY
 			$gradeValues,
 			$defaultId
 		);
-
-		// Free result
-		sqlFreeResult($result);
 	} // END - if
 
 	// Return cache
 	return $GLOBALS[__FUNCTION__][$defaultId];
 }
 
+// Generates a selection box for grades
+function generateAdminGradeDataSelectionBox ($gradeId, $defaultId = NULL) {
+	// May only be called as admin
+	assert(isAdmin());
+	assert(isValidId($gradeId));
+
+	// Load template
+	return generateSelectionBoxFromArray(getArrayFromTable('grade_data', array('grade_id', 'grade_name'), 'grade_id'), 'grade_parent_id', $defaultId, '', '', '', $defaultId, '', TRUE, TRUE);
+}
+
 // ----------------------------------------------------------------------------
 //                             XML call-back functions
 // ----------------------------------------------------------------------------