Class Management

$class1

"; $class_product1=" "; // 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']; $cutoff= $row1['cutoff']; $sql331 ="SELECT * FROM $table_name80 WHERE survey_id ='$survey_id' "; $result331 = @mysql_query($sql331,$connection) or die(mysql_error()); $TSSurveyNums = mysql_num_rows($result331); // $home_values_array1[] = array(); $query = "SELECT * FROM $table_name80 WHERE survey_id ='$survey_id'"; $result = mysql_query($query) or die(mysql_error()); // $row = mysql_fetch_array($result) or die(mysql_error()); // echo $row['Ascore']; while($row = mysql_fetch_array($result)){ $bobv=$row['Ascore']; $sumA=$bobv+$sumA; if ($bobv != $blink AND $bobv1 !=$blink){ $bobv1="$bobv1, $bobv "; } if ($bobv != $blink AND $bobv1 ==$blink){ $bobv1="$bobv "; } // echo $row['Ascore']. " - ". $row['survey_id']; // echo "
"; } // echo $bobv1; //echo "
"; $bobv1=trim($bobv1); //$home_values_array = array_map('trim',explode(" ",$bobv1)); $home_values2 = explode(",", $bobv1); // $length=count($home_value2); if ($TSSurveyNums !=0){ $average1 =number_format($sumA/$TSSurveyNums,2); } if ($average1 >=$cutoff){ $averageprint=" $average1 "; }else { $averageprint=" $average1 "; } //$home_values332=print_r($home_values2); $count = $TSSurveyNums; //total numbers in array $middleval = floor(($count-1)/2); // find the middle value, or the lowest middle value if($count % 2) { // odd number, middle is the median $median1 = $home_values2[$middleval]; } else { // even number, calculate avg of 2 medians if ($count>1){ $low = $home_values2[$middleval]; $high = $home_values2[$middleval+1]; $median1 = number_format((($low+$high)/2),2); } } if ($median1 >=$cutoff){ $medianprint=" $median1 "; }else { $medianprint=" $median1 "; } //echo "
AA- $median1 - hh$home_values2[$middleval]
"; //$home_values_array=print_r($home_values2); //echo "
$home_values_array
"; // echo $result_array; // $median1 = calculate_median($home_values_array); //$average1 = calculate_average($bobv1); //$average1 = calculate_average($home_values_array); $bobv1=''; $Sstatement .="

$Service: $survey_id

$survey_name $Service1 Completed: $TSSurveyNums Average Score:$averageprint Median:$medianprint "; $TSurveyNums=$TSurveyNums+$TSSurveyNums; $TSSurveyNums=''; $average1='N/A'; $median1='N/A'; $sumA=''; } //$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 .=" "; // $hi4=''; $display_survey="

Review Survey Reports

Manage Survey Questions & Access

Folder Management

Enter Leader's Name: $display_listP

Enter Group Name: $display_listG

"; $display_marketing1 .="

Marketing Management

"; $display_surveys1="

Survey Management

"; $display_forms1="

Forms Management

"; $display_orders1 .="

Order Management

"; $display_sec1="

$Stakeholders & Group Management

$hi4

"; $display_sec2="

Product Management

$class_product1

"; $display_MIT .="

MIT Applicants

"; $display_sec4="$display_class1"; // $display_sec5="$display_forms1"; $display_sec6="$display_surveys1"; $display_sec7="$display_folders1"; $display_sec8="$display_orders1"; $display_sec9="$display_marketing1"; $display_sec10=" $display_MIT"; $display_sec11=""; $display_sec12=""; $heading_title="$company_admin"; $display_block_call55 ="

$sec_title1

$display_notices

$display_sec1 $display_sec2 $display_sec3 $display_sec4 $display_sec5 $display_sec6 $display_sec7 $display_sec8 $display_sec9 $display_sec10 $display_sec11 $display_sec12 "; $tabby.="

StatisticsLatest Notices Quick Links

"; $tabby=""; $tabby.="

StatisticsLatest SalesLatest Backorders Latest Notices Quick Links

"; $display_sales0.="

$text_latest_10_orders

;" ?>

$column_order	$column_customer	$column_status	$column_date_added	$column_total	$column_action