Class Directory
";
// include("../forms/notify_id.php");
$instock = 7;
$backorder =9;
$outofstock =5;
$orders_backordered=27;
$blink="";
$quote1=$instock;
// $sql33 ="SELECT SUM(quantity)AS instock2 FROM $table_name54 WHERE stock_status_id = '$quote1' ";
$quote1=$backorder;
//$quote1=$outofstock;
//$quote1=2;
// $sql33 ="SELECT SUM(quantity)AS instock2 FROM .$table_name54 WHERE stock_status_id = '$quote1' ";
//Number of Ministries
$sql33 ="SELECT * FROM $table_name85 WHERE status > 0 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
$minNum = mysql_num_rows($result33);
$sql33 ="SELECT * FROM $table_name36 WHERE store_id = 9 AND status > 0 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
$minUserNum = mysql_num_rows($result33);
$sql33 ="SELECT * FROM $table_name36 WHERE store_id = 9 AND status > 0 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
$minUserNum = mysql_num_rows($result33);
$sql33 ="SELECT * FROM $table_name36 WHERE store_id = 8 AND status > 0";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
$minApUserNum = mysql_num_rows($result33);
$minApUserNum=$minApUserNum-2; //super User & Gayle
$sql33 ="SELECT * FROM $table_name36 WHERE status > 0 ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
$TminUserNum = mysql_num_rows($result33);
$TminUserNum=$TminUserNum-2;
$sql33 ="SELECT * FROM $table_name81 WHERE status > 0 Order by survey_id ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
$SurveyNums = mysql_num_rows($result33);
while ($row1 = mysql_fetch_array($result33)) {
$survey_id= $row1['survey_id'];
$survey_name= $row1['name'];
$sql331 ="SELECT * FROM $table_name78 WHERE survey_id ='$survey_id' ";
$result331 = @mysql_query($sql331,$connection) or die(mysql_error());
$TSSurveyNums = mysql_num_rows($result331);
$Sstatement .="Survey: $survey_id - $survey_name ----- Surveys Completed: $TSSurveyNums ";
$TSurveyNums=$TSurveyNums+$TSSurveyNums;
$TSSurveyNums='';
}
//$sql33 ="SELECT * FROM $table_name78 ";
//$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
//$TSurveyNums = mysql_num_rows($result33);
//$display_notices1 .="
//$form_name:$num1aa[$form_id]
//";
$display_notices1 .="
Purchase Requests in System:
PR's needing processing:-$num1a11ap
Purchase Orders:
";
// include("GoTool/forms/user_id.php");
$display_notices ="Number of Ministries/Groups: $minNum
Number of Web Users: $TminUserNum
Number of WOF Ministry Module Users: $minUserNum
Number of WOF Apostolic Ministry Module Users: $minApUserNum
Number of Surveys: $SurveyNums
Number of Participants Surveys Recorded: $TSurveyNums
$Sstatement
";
//First get logged
$logged_id=$hi2;
$sql33 ="SELECT * FROM $table_name49 WHERE user_id ='$logged_id' ";
$result33 = @mysql_query($sql33,$connection) or die(mysql_error());
$row22 =mysql_fetch_array($result33,MYSQL_ASSOC);
$log_email= $row22['email'];
$hi="$hi3 User ID: $hi2 - Group:$hi1 ";
$hi4="";
$hi4 .="
Add Stakeholders
Add Stakeholders to Group
Add Group
Edit Group
Leadership Directory
";
// $hi4='';
$display_survey="
Review Survey Reports
Manage Survey Questions & Access
";
$sq112ab="SELECT * FROM $table_name36 ORDER BY lastname";
$result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error());
while ($row112ab = mysql_fetch_array($result112ab)) {
$leader_id1= $row112ab['customer_id'];
$first_id= $row112ab['firstname'];
$last_id= $row112ab['lastname'];
$nameP[$leader_id1]="$first_id $last_id";
$display_listP .= "";
}
$sq112ab="SELECT * FROM $table_name85 ORDER BY name";
$result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error());
while ($row112ab = mysql_fetch_array($result112ab)) {
$leader_id1= $row112ab['survey_id'];
$first_id= $row112ab['name'];
//$last_id= $row112ab['lastname'];
$nameG[$leader_id1]="$first_id";
$display_listG .= "";
}
$heading_title="BMAN Administration";
// $display_block_call=''; //use for special announcements
$display_block_call55 ="
![](\"$loc2/admin/GoTool/image/Bman_logo.png\"){kind=logo}