function echoJSServicesArray()
{
global $system_message;
$coordlist_query = "SELECT DISTINCT `agency`, COUNT(`agency`) AS `count` FROM coordination_of_services GROUP BY `agency` ORDER BY `count` DESC LIMIT 200";
$coordlist_result = mysql_query($coordlist_query);
if (!$coordlist_result) {
$error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$coordlist_query}'<BR>";
$system_message = $system_message . $error_message;
IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
} else {
//call the function to create the javascript array...
if (mysql_num_rows($coordlist_result)) {
echo createJavaScript($coordlist_result, "popuplist");
}
}
}
function echoJSServicesArray()
{
global $system_message, $student_id;
//get a list of all available goal categories...
$catlist_query = "SELECT name FROM typical_long_term_goal_category WHERE is_deleted='N' ORDER BY name ASC";
$catlist_result = mysql_query($catlist_query);
if (!$catlist_result) {
$error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$catlist_query}'<BR>";
$system_message = $system_message . $error_message;
IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
return;
} else {
//call the function to create the javascript array...
echo createJavaScript($catlist_result, "popuplist");
}
}
function echoJSServicesArray()
{
global $system_message;
$acclist_query = "SELECT accomodation FROM typical_accomodation WHERE 1 ORDER BY `order` DESC, accomodation ASC LIMIT 400";
$acclist_result = mysql_query($acclist_query);
if (!$acclist_result) {
$error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$acclist_query}'<BR>";
$system_message = $system_message . $error_message;
IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
} else {
//call the function to create the javascript array...
if (mysql_num_rows($acclist_result)) {
echo createJavaScript($acclist_result, "popuplist");
}
}
}
function echoJSServicesArray()
{
global $system_message;
//while($catlist=mysql_fetch_array($catlist_result)) {
if (isset($_GET['goal_area']) && !$_GET['goal_area'] == "") {
$objlist_query = "SELECT typical_long_term_goal.goal FROM typical_long_term_goal WHERE cid=" . mysql_real_escape_string($_GET['goal_area']) . " AND typical_long_term_goal.is_deleted='N'";
$objlist_result = mysql_query($objlist_query);
if (!$objlist_result) {
$error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$objlist_query}'<BR>";
$system_message = $system_message . $error_message;
IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
} else {
//call the function to create the javascript array...
if (mysql_num_rows($objlist_result)) {
echo createJavaScript($objlist_result, "popuplist");
}
}
}
//}
}
function echoJSServicesArray()
{
global $system_message;
//get a list of all available goal categories...
$catlist_query = "SELECT * FROM typical_long_term_goal_category where is_deleted='N'";
$catlist_result = mysql_query($catlist_query);
if (!$catlist_result) {
$error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$catlist_query}'<BR>";
$system_message = $system_message . $error_message;
IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
return;
}
while ($catlist = mysql_fetch_array($catlist_result)) {
$objlist_query = "SELECT typical_long_term_goal.goal FROM typical_long_term_goal WHERE cid=" . $catlist['cid'] . " AND typical_long_term_goal.is_deleted='N'";
$objlist_result = mysql_query($objlist_query);
if (!$objlist_result) {
$error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$objlist_query}'<BR>";
$system_message = $system_message . $error_message;
IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
} else {
//call the function to create the javascript array...
echo createJavaScript($objlist_result, $catlist['name']);
}
}
}
function echoJSServicesArray()
{
global $system_message;
$coordlist_query = "SELECT DISTINCT `name`, COUNT(`name`) AS `count` FROM typical_long_term_goal_category WHERE is_deleted='N' GROUP BY `name` ORDER BY `name` DESC LIMIT 200";
$coordlist_result = mysql_query($coordlist_query);
if (!$coordlist_result) {
$error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$coordlist_query}'<BR>";
$system_message = $system_message . $error_message;
IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
} else {
//call the function to create the javascript array...
echo createJavaScript($coordlist_result, "popuplist");
}
}
function echoJSServicesArray()
{
global $system_message;
$acclist_query = "SELECT DISTINCT egps_username FROM support_list WHERE 1 ORDER BY egps_username ASC";
$acclist_result = mysql_query($acclist_query);
if (!$acclist_result) {
$error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$acclist_query}'<BR>";
$system_message = $system_message . $error_message;
IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
} else {
//call the function to create the javascript array...
echo createJavaScript($acclist_result, "popuplist");
}
}
function echoJSServicesArray()
{
global $system_message;
//get a list of all available goal categories...
$catlist_query = "SELECT typical_short_term_objective.goal FROM long_term_goal RIGHT JOIN typical_long_term_goal ON long_term_goal.goal LIKE typical_long_term_goal.goal RIGHT JOIN typical_short_term_objective ON typical_long_term_goal.ltg_id=typical_short_term_objective.ltg_id WHERE long_term_goal.goal_id=" . mysql_real_escape_string($_GET['goal_id']) . " AND student_id=" . mysql_real_escape_string($_GET['student_id']);
$catlist_result = mysql_query($catlist_query);
if (!$catlist_result) {
$error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$catlist_query}'<BR>";
$system_message = $system_message . $error_message;
IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
return;
} else {
//$system_message = $system_message . "Rows returned=" . mysql_num_rows($catlist_result) . " Query=$catlist_query<BR><BR>";
echo createJavaScript($catlist_result, "popuplist");
}
//This code block was commented out by dev.
//while($catlist=mysql_fetch_array($catlist_result)) {
//$objlist_query="SELECT typical_long_term_goal.goal FROM typical_long_term_goal WHERE cid=" . $catlist['cid'] . " AND typical_long_term_goal.is_deleted='N'";
//$objlist_result = mysql_query($objlist_query);
//if(!$objlist_result) {
// $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '$objlist_query'<BR>";
// $system_message= $system_message . $error_message;
// IPP_LOG($system_message,$_SESSION['egps_username'],'ERROR');
//} else {
//call the function to create the javascript array...
// echo createJavaScript($objlist_result,$catlist['name']);
//}
//}
}
