admin
//$logged = substr("abcdef", 0, -1); // returns "abcde"
//$rest = substr("abcdef", 2, -1); // returns "cde"
$sig="../../../../sig";
$logged1=substr($logged , 0,7);
$logged_test="You are";
if ($logged1==$logged_test){
$logged = substr($logged, 27, -7); // returns "abcde"
}
function calculate_string( $mathString ) {
$mathString = trim($mathString); // trim white spaces
$mathString = preg_replace ('[^0-9\+-\*\/\(\) ]', '', $mathString); // remove any non-numbers chars; exception for math operators
$compute = create_function("", "return (" . $mathString . ");" );
return 0 + $compute();
}
//$string = " (1 + 1) * (2 + 2)";
//echo calculate_string($string);
// start the session
include("../cat.inc");
$tok=$_GET['token'];
$bar=$_GET['ean'];
//$tok= session_id();
$Btoday = date("Y-m-d");
$day=date("d");
$dayL=$day-1;
$monL=date("m");
$monL2=$monL+12;
$lastmo= strtotime("last month",$Btoday);
$firstmo= date("Y-m-d",strtotime("-$day day last month")); //the end of the month 2 months out
$lastmo= date("Y-m-d",strtotime("-$dayL day this month")); //first of this month
$mo= date("Y-m-d",strtotime("1 day this month")); //first of this month
$moB= date("Y-m-d",strtotime("-90 day this month")); //first of this month
$moB2= date("Y-m-d",strtotime("-90 day ")); //first of this month
$yester= date("Y-m-d",strtotime("yesterday"));
$tomorr= date("Y-m-d",strtotime("tomorrow"));
$moName= date("Y-m-d",strtotime(" last month"));
$lweek= date("Y-m-d",strtotime(" -7 day"));
$lyear= date("Y-m-d",strtotime(" -366 day"));
$mo30= date("Y-m-d",strtotime("-30 day")); //first of this month
$mo6= date("Y-m-d",strtotime("-6 month this month")); //first of this month
$mo12= date("Y-m-d",strtotime("-12 month this month")); //first of this month
$lastmo2= date("Y-m-d",strtotime("-$dayL day -1 month")); //first of this month
$lastmo3= date("Y-m-d",strtotime("-$dayL day -3 month")); //first of this month
$lastmo6= date("Y-m-d",strtotime("-$dayL day -6 month")); //first of this month
$mo12b= date("Y-m-d",strtotime("-$monL2 month this month")); //first of this month
$mo12a= date("Y-m-d",strtotime("-$monL month this month")); //first of this month
$daysterm[0]='';
$daysterm[15]='';
//last 7 days
// $sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' AND create_date between '$lweek' AND '$tomorr' $caution ";
$daysterm[27]="AND create_date between '$lweek' AND '$tomorr'";
//last month
// $sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' AND create_date between '$lastmo2' AND '$lastmo' $caution ";
$daysterm[28]="AND create_date between '$lastmo2' AND '$lastmo' ";
//last 3 month
// $sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' AND create_date between '$lastmo2' AND '$lastmo' $caution ";
$daysterm[23]="AND create_date between '$lastmo3' AND '$lastmo' ";
//last 6 month
// $sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' AND create_date between '$lastmo2' AND '$lastmo' $caution ";
$daysterm[24]="AND create_date between '$lastmo6' AND '$lastmo' ";
//last 90 days
// $sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' AND create_date between '$moB2' AND '$tomorr' $caution ";
$daysterm[22]="AND create_date between '$moB2' AND '$tomorr' ";
//last year
// $sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' AND create_date between '$mo12b' AND '$mo12a' $caution ";
$daysterm[26]="AND create_date between '$mo12b' AND '$mo12a' ";
//yearly
// $sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' AND create_date between '$mo12b' AND '$mo12a' $caution ";
$daysterm[25]="AND create_date between '$lyear' AND '$tomorr' ";
$table_nameApp=$table_name406;
$goflow2="Report List";
$display_title ="Report Module";
$Record="Metric"; //This is the title for the list - could be Survey, Record, etc.
$Leader="Survey";
$Leader_A="Sum1";
$Leader_B="Sum2";
$Administrator="Operation1";
$Pastor_Support="Sum3";
$Admin_Support="Operation2";
//$Admin_Support2="Graph Directory";
$Additional_Resource="Person Access";
$Additional_Group="Group Access";
$Notes5="Notes";
$errorC=3; //corresponds to 8% error
$bss11C=0; //coresponds to 90% confidence
//$dir="checkout";
//$loc="www.1stchoicesolution.com";
//$prod="Timeshare Services to transfer Timeshare";
//$string ="Wow this works ";
$display_blockFF .= "
";
// echo $string;
$blink="";
//$host="localhost";
//$db_name="nwtrans_gotool2";
//$user="nwtrans_gotool22";
//$password="f*r25Get";
//connect to the server and select the database
$connection = @mysqli_connect($host,$user,$password) or die(mysqli_error($connection));
$db = @mysqli_select_db($connection,$db_name) or die(mysqli_error($connection));
$table_name67="Aprocess2";
$sql33 ="SELECT * FROM $table_name67 WHERE address_id = '11' ";
$result222 = @mysqli_query($connection,$sql33) or die(mysqli_error($connection));
while ($row1 = mysqli_fetch_array($result222)) {
$em55= $row1['bob'];
}
$sql33 ="SELECT * FROM $table_name67 WHERE address_id = '13' ";
$result222 = @mysqli_query($connection,$sql33) or die(mysqli_error($connection));
while ($row1 = mysqli_fetch_array($result222)) {
$authorization= $row1['bob'];
}
$sql33 ="SELECT * FROM $table_name67 WHERE address_id = '14' ";
$result222 = @mysqli_query($connection,$sql33) or die(mysqli_error($connection));
while ($row1 = mysqli_fetch_array($result222)) {
$cutoff=$row1['bob'];
$Low=$row1['Low'];
$High=$row1['High'];
$Medium=$row1['Medium'];
}
//$em55="glink@galliumo.com"; //admin email
//$login=$_POST['author'];
//$pswd=$_POST['pswd'];
//$zip=$_POST['author'];
//$personID=$_POST['numID'];
//$redID=$_POST['redID2'];
//$redID3=$_POST['redID3'];
$jedID2=$_POST['jedID2'];
$gbad=$_POST['gbad'];
$Dbad=$_POST['Dbad'];
$sbad=$_POST['sbad'];
$gbadMod=$_POST['gbadMod'];
$BY =$_POST['year'];
$BM =$_POST['month'];
$BD =$_POST['day'];
$birthday="$BY-$BM-$BD";
$optax="A";
$comp="GalliumGroup";
//$state =$_GET['state'];
//$state=46;
//$sub =$_GET['sub'];
$today = date("Y-m-d h:i:s");
$date2 = date("F j,Y"); //date ("format",$timestamp)
$date3 = date("m/d/Y");
//$cust="cust";
$ip=$_SERVER['REMOTE_ADDR'];
///Get the List
$sq112abx="SELECT * FROM $table_name601 ORDER BY name";
$result112abx = @mysqli_query($connection,$sq112abx) or die(mysqli_error($connection));
while ($row112abx = mysqli_fetch_array($result112abx)) {
$leader_id1= $row112abx['survey_id'];
$first_id= $row112abx['name'];
$nameG[$leader_id1]="$first_id";
$display_listReport2 .= "";
}
include("list_people.php"); ///people
include("../logger.php"); //This checks tokens
//include("internal.php"); Back and Forth Navigation
// $display_title ="Group Module";
//jedID2 == 0 Shows the front landing page.
if ($jedID2 == 3) {
$report=$_POST['survey_id'];
$Searchgbad=$_POST['Searchgbad'];
$SType=$_POST['SType'];
$NonReg=$_POST['NonReg'];
$StakeGroup=$_POST['StakeGroup'];
$RegStake=$_POST['RegStake'];
$report_metric_d="
";
//////////////
//this names the report
$sq112aaE ="SELECT * FROM $table_name601 Where survey_id ='$report' "; //name of the reports
$result333E = @mysqli_query($connection,$sq112aaE) or die(mysqli_error($connection));
// $row1E =mysqli_fetch_array($result333E,MYSQLI_ASSOC);
while ($row1 = mysqli_fetch_array($result333E)) {
$Cname= stripslashes($row1['name']);
$display_title=$Cname;
$Ccomments= stripslashes($row1['comment']);
$Cstatus= stripslashes($row1['status']);
$Ccreate_date= $row1['create_date'];
}
//this defines the metrics on the report
$j=1;
$sq112aaE ="SELECT * FROM $table_name600 Where group_id ='$report' AND group_id !='0' AND status='1' "; //now we pick up all the metrics for the report
$result333E = @mysqli_query($connection,$sq112aaE) or die(mysqli_error($connection));
// $row1E =mysqli_fetch_array($result333E,MYSQLI_ASSOC);
while ($row1E = mysqli_fetch_array($result333E)) {
$leader_match_id= $row1E['leader_match_id'];
$metric_id[$j]= $row1E['leader_id']; //Metric
$time_idA[$j]= $row1E['leader_idA']; //Timeframe 1
$time_idB[$j]= $row1E['leader_idB']; //Timeframe 2
$time_idAdm[$j]= $row1E['leader_idAdm']; //Timeframe 3
$time_idOv[$j]= $row1E['overseer_id']; //Timeframe 4
$condAll[$j]= $row1E['support_id']; //
$column11=$time_idA[$j];
$column12=$time_idB[$j];
$column13=$time_idAdm[$j];
$column14=$time_idOv[$j];
//echo "$j -column11= $column11, column12= $column12, column13= $column13, column14= $column14 " ;
$metric_idSup[$j]= $row1E['support_id']; //NA
$metric_idOth= $row1E['other_id']; //Person
$metric_idCG= $row1E['customer_group_id']; //Group
$Rstatus= ($row1E['status']);
$Rcreate_date= $row1E['create_date'];
$sql361 ="SELECT * FROM $table_name406 WHERE survey_id = '$metric_id[$j]' "; //get name of each metric
$result2261 = @mysqli_query($connection,$sql361) or die(mysqli_error($connection));
$row161 =mysqli_fetch_array($result2261,MYSQLI_ASSOC);
if ($metric_id[$j] == $row161['survey_id'])
{
$metric_name[$j]= $row161['name'];
//$Llast_id= $row161['lastname'];
} //end if
else{
//$Llast_id='';
$metric_name[$j]='';
} //end else
$sql361 ="SELECT * FROM $table_name404 WHERE table_id = '$time_idA[$j]' "; //Get the time frame
$result2261 = @mysqli_query($connection,$sql361) or die(mysqli_error($connection));
$row161 =mysqli_fetch_array($result2261,MYSQLI_ASSOC);
if ($time_idA[$j] == $row161['table_id'])
{
$Time1[$j]= $row161['value'];
//$Llast_id= $row161['lastname'];
}
else{
//$Llast_id='';
$Time1[$j]='';
} //end if
$sql361 ="SELECT * FROM $table_name404 WHERE table_id = '$time_idB[$j]' ";
$result2261 = @mysqli_query($connection,$sql361) or die(mysqli_error($connection));
$row161 =mysqli_fetch_array($result2261,MYSQLI_ASSOC);
if ($time_idB[$j] == $row161['table_id'])
{
$Time2[$j]= $row161['value'];
//$Llast_id= $row161['lastname'];
}
else{
//$Llast_id='';
$Time2[$j]='';
} //end if
$sql361 ="SELECT * FROM $table_name404 WHERE table_id = '$time_idAdm[$j]' ";
$result2261 = @mysqli_query($connection,$sql361) or die(mysqli_error($connection));
$row161 =mysqli_fetch_array($result2261,MYSQLI_ASSOC);
if ($time_idAdm[$j] == $row161['table_id'])
{
$Time3[$j]= $row161['value'];
//$Llast_id= $row161['lastname'];
}
else{
//$Llast_id='';
$Time3[$j]='';
} //end if
$sql361 ="SELECT * FROM $table_name404 WHERE table_id = '$time_idOv[$j]' ";
$result2261 = @mysqli_query($connection,$sql361) or die(mysqli_error($connection));
$row161 =mysqli_fetch_array($result2261,MYSQLI_ASSOC);
if ($time_idOv[$j] == $row161['table_id'])
{
$Time4[$j]= $row161['value'];
//$Llast_id= $row161['lastname'];
}
else{
//$Llast_id='';
$Time4[$j]='';
}
$i=1;
$sq112aaEF ="SELECT * FROM $table_name405 Where group_id ='$metric_id[$j]' AND status='1' "; //get the build of this metric
$result333EF = @mysqli_query($connection,$sq112aaEF) or die(mysqli_error($connection));
// $row1E =mysqli_fetch_array($result333E,MYSQLI_ASSOC);
while ($row1EF = mysqli_fetch_array($result333EF)) {
$searchCheck='';
$searchCheck300='';
$searchP=$row1EF['searchP'];
$NA="N/A";
if ($Searchgbad == 0 AND $Searchgbad != $blink AND $Searchgbad != $NA){
$searchP=$Searchgbad;
}
// echo $searchP;
$searchtalk='';
$searchname='';
include("findStake.php");
$searchP1=$row1EF['leader_idB'];
// $searchP1=$row161d['leader_idB'];
if (($searchP != $blink AND $searchP != $NA)OR $searchP1>0 ){
$searchtalk="Search Limited to Search Term: $searchP";
if ($searchP1>0){
$searchP=$searchP1;
$searchtalk="Search Limited to Answer #: $searchP"; //
}
$searchname1= " OR firstname LIKE '%$searchP%' OR lastname LIKE '%$searchP%'";
$searchCheck="AND (company LIKE '%$searchP%' OR email LIKE '%$searchP%' OR van1 LIKE '%$searchP%' OR van2 LIKE '%$searchP%' OR van3 LIKE '%$searchP%' OR van4 LIKE '%$searchP%' OR van5 LIKE '%$searchP%' OR van6 LIKE '%$searchP%' OR van7 LIKE '%$searchP%' OR van8 LIKE '%$searchP%' OR van9 LIKE '%$searchP%' OR van10 LIKE '%$searchP%' OR van11 LIKE '%$searchP%' OR van12 LIKE '%$searchP%' OR van13 LIKE '%$searchP%' OR van14 LIKE '%$searchP%' OR van15 LIKE '%$searchP%' OR van16 LIKE '%$searchP%' OR van17 LIKE '%$searchP%' OR van18 LIKE '%$searchP%' OR van19 LIKE '%$searchP%' OR van20 LIKE '%$searchP%' OR van21 LIKE '%$searchP%' OR van22 LIKE '%$searchP%' OR van23 LIKE '%$searchP%' OR van24 LIKE '%$searchP%' OR van25 LIKE '%$searchP%' OR van26 LIKE '%$searchP%' OR van27 LIKE '%$searchP%' OR van28 LIKE '%$searchP%' OR van29 LIKE '%$searchP%' OR van30 LIKE '%$searchP%' OR van31 LIKE '%$searchP%' OR van32 LIKE '%$searchP%' OR van33 LIKE '%$searchP%' OR van34 LIKE '%$searchP%' OR van35 LIKE '%$searchP%' OR van36 LIKE '%$searchP%' OR van37 LIKE '%$searchP%' OR van38 LIKE '%$searchP%' OR van39 LIKE '%$searchP%' OR van40 LIKE '%$searchP%' OR van41 LIKE '%$searchP%' OR van42 LIKE '%$searchP%' OR van43 LIKE '%$searchP%' OR van44 LIKE '%$searchP%' OR van45 LIKE '%$searchP%' OR van46 LIKE '%$searchP%' OR van47 LIKE '%$searchP%' OR van48 LIKE '%$searchP%' OR van49 LIKE '%$searchP%' OR van50 LIKE '%$searchP%' OR van51 LIKE '%$searchP%' OR van52 LIKE '%$searchP%' OR van53 LIKE '%$searchP%' OR van54 LIKE '%$searchP%' OR van55 LIKE '%$searchP%' OR van56 LIKE '%$searchP%' $searchname1) ";
if ($searchP >0){
$searchCheck300="AND (van2 = '$searchP')";
}
//echo $searchCheck;
// create_date between '$lyear' AND '$tomorr' ";
}
$sq112ZaAVV="SELECT * FROM $table_name103 WHERE van2 = '$searchP' ";
$result3AVV = @mysqli_query($connection,$sq112ZaAVV) or die(mysqli_error($connection));
$num33AVV = mysqli_num_rows($result3AVV);
if ($searchP >0 AND $num33AVV>0){
$searchtalk="Search Limited to Answer #: $searchP";
$searchCheck='';
//$searchCheck="AND (company LIKE '%$searchP%' OR firstname LIKE '%$searchP%' OR email LIKE '%$searchP%'OR lastname LIKE '%$searchP%' OR van1 LIKE '%$searchP%' OR van2 LIKE '%$searchP%' OR van3 LIKE '%$searchP%' OR van4 LIKE '%$searchP%' OR van5 LIKE '%$searchP%' OR van6 LIKE '%$searchP%' OR van7 LIKE '%$searchP%' OR van8 LIKE '%$searchP%' OR van9 LIKE '%$searchP%' OR van10 LIKE '%$searchP%' OR van11 LIKE '%$searchP%' OR van12 LIKE '%$searchP%' OR van13 LIKE '%$searchP%' OR van14 LIKE '%$searchP%' OR van15 LIKE '%$searchP%' OR van16 LIKE '%$searchP%' OR van17 LIKE '%$searchP%' OR van18 LIKE '%$searchP%' OR van19 LIKE '%$searchP%' OR van20 LIKE '%$searchP%' OR van21 LIKE '%$searchP%' OR van22 LIKE '%$searchP%' OR van23 LIKE '%$searchP%' OR van24 LIKE '%$searchP%' OR van25 LIKE '%$searchP%' OR van26 LIKE '%$searchP%' OR van27 LIKE '%$searchP%' OR van28 LIKE '%$searchP%' OR van29 LIKE '%$searchP%' OR van30 LIKE '%$searchP%' OR van31 LIKE '%$searchP%' OR van32 LIKE '%$searchP%' OR van33 LIKE '%$searchP%' OR van34 LIKE '%$searchP%' OR van35 LIKE '%$searchP%' OR van36 LIKE '%$searchP%' OR van37 LIKE '%$searchP%' OR van38 LIKE '%$searchP%' OR van39 LIKE '%$searchP%' OR van40 LIKE '%$searchP%' OR van41 LIKE '%$searchP%' OR van42 LIKE '%$searchP%' OR van43 LIKE '%$searchP%' OR van44 LIKE '%$searchP%' OR van45 LIKE '%$searchP%' OR van46 LIKE '%$searchP%' OR van47 LIKE '%$searchP%' OR van48 LIKE '%$searchP%' OR van49 LIKE '%$searchP%' OR van50 LIKE '%$searchP%' OR van51 LIKE '%$searchP%' OR van52 LIKE '%$searchP%' OR van53 LIKE '%$searchP%' OR van54 LIKE '%$searchP%' OR van55 LIKE '%$searchP%' OR van56 LIKE '%$searchP%') ";
$searchCheck300="AND (van2 = '$searchP')";
// echo $searchCheck300;
// echo $searchCheck;
}
$display_title1 ="$display_title $searchtalk";
$metric_match_id= $row1EF['leader_match_id'];
$surveys_id= $row1EF['leader_id']; //The surveys
$Open1[$j]= $row1EF['Open1']; //open parenthesis
$gmath[$j]= $row1EF['gmath_id']; //math
$Survey1[$j]= $row1EF['leader_id']; //Survey
$sum1Q[$j]= $row1EF['leader_idA']; //The 1st Q
$SearchP[$j]= $row1EF['searchP']; //search Phrase
$SpecificAns[$j]= $row1EF['leader_idB'];
$StakeReg[$j]= $row1EF['overseer_id'];
$StakeType[$j]= $row1EF['support_id'];
$NonStake[$j]= $row1EF['other_id'];
$Custgroup[$j]= $row1EF['customer_group_id'];
$gtime[$j]= $row1EF['gtime_id'];
$Close1[$j]= $row1EF['Close'];
$Constant[$j]= $row1EF['Constant'];
$Squared[$j]= $row1EF['Squared'];
$sum1Q[$j]= $row1EF['leader_idA']; //The 1st Q
$Q1=$sum1Q[$j];
// echo " $j-- Q$Survey1[$j]:$sum1Q[$j]:$leader_idA $Open1[$j]= $gmath[$j]= $Survey1[$j]= $sum1Q[$j]= $SearchP[$j]= $SpecificAns[$j]= $StakeReg[$j]= $StakeType[$j]= $NonStake[$j]= $Custgroup[$j]= $gtime[$j]= $Close1[$j]= $Constant[$j]= $Squared[$j]=
";
if ($gmath[$j]=="11"){
$gmath1[$j]="-";
}
//Sum
if ($gmath[$j]=="10"){
$gmath1[$j]="+";
}
//Multiply
if ($gmath[$j]=="13"){
$gmath1[$j]="*";
}
//Divisor
if ($gmath[$j]=="12"){
$gmath1[$j]="/";
}
//Count
if ($gmath[$j]=="30"){
$gmath1[$j]="+Count";
}
if ($gmath[$j]=="31"){
$gmath1[$j]="-Count";
}
if ($gmath[$j]=="32"){
$gmath1[$j]="/Count";
}
if ($gmath[$j]=="33"){
$gmath1[$j]="*Count";
}
if ( $Open1[$j]=="1"){
$Open11[$j]='(';
}
if ($Open1[$j]==3){
$Open11[$j]="+(";
}
if ($Open1[$j]==4){
$Open11[$j]="-(";
}
if ($Open1[$j]==5){
$Open11[$j]="*(";
}
if ($Open1[$j]==6){
$Open11[$j]="/(";
}
if ( $Close1[$j]=="2"){
$Close11[$j]=')';
}
if ($Squared[$j] !=1.000){
$Squared1[$j]="^$Squared[$j]";
}
if ($Constant[$j] !=0.000){
$Constant1[$j]="+ $Constant[$j]";
}
// echo "$gmath[$j] ";
// echo "$gmath1[$j] ";
$Agmath[$leader_match_id]="$gmath1[$j]";
// echo "$Agmath[$leader_match_id] ";
// $Formula[$j] .="$Open11[$j] $gmath1[$j] (Q$Survey1[$j]:$sum1Q[$j]:$leader_idA) $Close11[$j] $Squared1[$j] $Constant1[$j] ";
// $Formula1 =((5)+(9)) ;
// echo "$Formula1 - 14 ";
// $gmath1[$j]='';
// $Open11[$j]='';
// $Squared1[$j]='';
// $Constant1[$j]='';
// $Close11[$j]='';
// echo "$j - $Formula[$j] ";
// $Rcreate_date[$i]= $row1EF['create_date'];
$i=$i+1;
$sq112ab="SELECT * FROM $table_name76 Where survey_id='$surveys_id' AND surveyQ_id>1 ORDER BY surveyQQ_id ASC ";
$result112ab = @mysqli_query($connection,$sq112ab) or die(mysqli_error($connection));
while ($row112ab = mysqli_fetch_array($result112ab)) {
$leader_id1= $row112ab['surveyQQ_id'];
$leader_id1N= $row112ab['surveyQ_id'];
$rs= $row112ab['survey_id'];
$countg=$countg+1;
$rss[$countg]=$rs;
if ($leader_id1N==2){
$gi=1;
} //end if
$gi=$gi+1;
${TPA.$rs.$gi}= $leader_id1;
// echo "survey= $rs unit=$gi QQ= ${TPA.$rs.$gi} Question= $leader_id1N ";
$findkey[$leader_id1]=$gi;
$findvan[$leader_id1]="van$gi";
$findsurv[$leader_id1]=$rs;
// echo "survey= $rs unit=$gi QQ= ${TPA.$rs.$gi} Question= $leader_id1N finderkey = $findkey[$leader_id1] findvan= $findvan[$leader_id1] ";
$first_id= $row112ab['question'];
} //end while tablename 76
/// } //end metric[$j] need to move this to end
/// $sql361d ="SELECT * FROM $table_name405 WHERE group_id = '$metric_id[$j]' AND leader_idA != '0' "; //Why is this here
$sq112ZaA1="SELECT * FROM $table_name80 WHERE survey_id = '$findsurv[$Q1]' AND survey_id != '0' $daysterm[$column11] Order by create_date ASC limit 1"; //Summing of Points
$result33ZZA1 = @mysqli_query($connection,$sq112ZaA1) or die(mysqli_error($connection));
while ($row122A1 = mysqli_fetch_array($result33ZZA1)) {
$testbob1= $row122A1['create_date'];
if ( $starttime1[$j] ==''){
$starttime1[$j]=$testbob1;
} //end if
$starttime1a=strtotime($starttime1[$j]);
$testbob1a=strtotime($testbob1);
if ($starttime1a<$testbob1a){
$starttime1[$j]=$starttime1[$j];
}else{
$starttime1[$j]=$testbob1;
} //end else
}
$testbob1='';
$sq112ZaA1="SELECT * FROM $table_name80 WHERE survey_id = '$findsurv[$Q1]' AND survey_id != '0' $daysterm[$column11] Order by create_date DESC limit 1"; //Summing of Points
$result33ZZA1 = @mysqli_query($connection,$sq112ZaA1) or die(mysqli_error($connection));
while ($row122A1 = mysqli_fetch_array($result33ZZA1)) {
//$starttime2[$j]= $row122A1['create_date'];
$testbob1= $row122A1['create_date'];
if ( $starttime2[$j] ==''){
$starttime2[$j]=$testbob1;
} //end if
$starttime1a=strtotime($starttime2[$j]);
$testbob1a=strtotime($testbob1);
if ($starttime1a>$testbob1a){
$starttime2[$j]=$starttime2[$j];
}else{
$starttime2[$j]=$testbob1;
} //end else
}
// echo "$j -st -$starttime1[$j] end -$starttime2[$j] ";
$sq112ZaA="SELECT * FROM $table_name80 WHERE survey_id = '$findsurv[$Q1]' AND survey_id != '0' $daysterm[$column11] $searchCheck $searchname"; //Summing of Points
//echo $sq112ZaA;
$result33ZZA = @mysqli_query($connection,$sq112ZaA) or die(mysqli_error($connection));
while ($row122A = mysqli_fetch_array($result33ZZA)) {
$map_idZAA= $row122A['map_id'];
$sq112Za="SELECT * FROM $table_name79 WHERE map_id = '$map_idZAA' "; //Summing of Points
//echo $sq112Za;
$result33ZZ = @mysqli_query($connection,$sq112Za) or die(mysqli_error($connection));
while ($row122 = mysqli_fetch_array($result33ZZ)) {
//$survey_id122= $row122['survey_id'];
$bobv= stripslashes($row122["$findvan[$Q1]"]);
if ($bobv != $blink ){
$bobv1[$j]="$bobv1[$j], $bobv ";
if ($bobv1[$j]==", $bobv "){
$bobv1[$j]=$bobv;
}
}
//$vanZ[1]=stripslashes($row122['van1']);
$vanZ1[$j]=$vanZ1[$j]+ stripslashes($row122["$findvan[$Q1]"]);
$ZZ1A[$j]=$ZZ1A[$j]+1;
$QR[$Q1]= $vanZ1[$j];
$QQR[$Q1]= $ZZ1A[$j];
// echo "vanz =$vanZ1[$j] -leader_id1=$findkey[$Q1]-$findvan[$Q1] :: $j -$vanZ1[$j] - $ZZ1A[$j] ";
//echo "1Q - $findsurv[$sum1Q]- $map_idZAA ";
}}
// echo " $j - $vanZ1[$j] - $ZZ1A[$j] - $Q1 ";
$tpar=") (";
// $tpar="Count";
$rpar=")*(";
//$rpar="Replace";
$Formula[$j] .="$Open11[$j]$gmath1[$j](QR[$sum1Q[$j]])$Close11[$j]$Squared1[$j]$Constant1[$j]";
// print_r(str_replace($tpar,$rpar,$Formula[$j]));
$Formula[$j]= (strtr($Formula[$j], array(')('=> ')*(')));
$Formula1 =((5)+(9)) ;
// echo "$j - $Formula[$j] ";
// echo "$Formula1 - 14 ";
$gmath1[$j]='';
$Open11[$j]='';
$Squared1[$j]='';
$Constant1[$j]='';
$Close11[$j]='';
// echo "$bobv1[$j] ";
//add the timeframes
if ($column12 !=0 AND $column12 !=$blink){
$XQ1=$Q1;
$Xextra=$daysterm[$column12];
include("timeframe.php");
$secondbobvA[$j]=$Xbobv1[$j];
// echo "sec - $secondbobvA[$j] ";
$secondvanZA[$j]= $XvanZ1[$j];
$secondZZ1A[$j]= $XZZ1A[$j];
$TQR[$Q1]= $XvanZ1[$j];
$TQQR[$Q1]= $XZZ1A[$j];
//echo " $j Hey $secondvanZA[$j] vs $XvanZ1[$j] vs $XZZ1A[$j] ";
}//endtimeframe
if ($condAll[$j] !=0 AND $condAll[$j] !=$blink){
$XQ1=$Q1;
// $Xextra=$daysterm[$column12];
$Xextra='';
include("timeframeAll.php");
$AsecondbobvA[$j]=$AXbobv1[$j];
// echo "sec - $secondbobvA[$j] ";
$AsecondvanZA[$j]= $AXvanZ1[$j];
$AsecondZZ1A[$j]= $AXZZ1A[$j];
$ATQR[$Q1]= $AXvanZ1[$j];
$ATQQR[$Q1]= $AXZZ1A[$j];
//echo " $j Hey $secondvanZA[$j] vs $XvanZ1[$j] vs $XZZ1A[$j] ";
}//endtimeframe
// echo "$j - $column13 ";
if ($column13 !=0 AND $column13 !=$blink){
$XQ1=$Q1;
$Xextra=$daysterm[$column13];
include("timeframe3.php");
$thirdbobvA[$j]=$X3bobv1[$j];
$thirdvanZA[$j]= $X3vanZ1[$j];
// echo "third - $thirdbobvA[$j] ";
$thirdZZ1A[$j]= $X3ZZ1A[$j];
//echo "13- Hey $thirdvanZA[$j] vs $X3vanZ1[$j] vs $X3ZZ1A[$j] ";
$X3QR[$Q1]= $X3vanZ1[$j];
$X3QQR[$Q1]= $X3ZZ1A[$j];
}//endtimeframe
if ($column14 !=0 AND $column14 !=$blink){
$XQ1=$Q1;
$Xextra=$daysterm[$column14];
include("timeframe4.php");
$fourthbobvA[$j]=$X4bobv1[$j];
// echo "four - $fourthbobvA[$j] ";
$fourthvanZA[$j]= $X4vanZ1[$j];
//echo " 14Hey $fourthvanZA[$j] vs $vanZ1[$j] ";
$fourthZZ1A[$j]= $X4ZZ1A[$j];
$X4QR[$Q1]= $X4vanZ1[$j];
$X4QQR[$Q1]= $X4ZZ1A[$j];
}//endtimeframe
// include("operand1.php"); just took out
} //Now lets get the sums
// echo "$j - $Formula[$j] ";
$Formula5[$j]=$Formula[$j];
$Formula2[$j]=$Formula[$j];
$Formula3[$j]=$Formula[$j];
$Formula4[$j]=$Formula[$j];
$Formula[$j]= (strtr($Formula[$j], array('Count(QR'=> '(ZR')));
$Formula[$j]= (strtr($Formula[$j], array('QR'=> '$QR')));
$Formula[$j]= (strtr($Formula[$j], array('ZR'=> '$QQR')));
// echo "$j - $Formula[$j] ";
$ggt=$Formula[$j];
eval("\$ggt = \"$ggt\";");
// $ggt=eval(\"$ggt\";");
// echo $ggt;
if ($QQR[$Q1] !=$blink AND $QR[$Q1] !=$blink){
// echo calculate_string($ggt);
// echo " ";
// $ggt=(-($Q[647])+($Q[675]))^2.0000+ 4.0000+($Q[681])*($QQ[684])^200.0000+ 5.0000;
$answer1[$j]= calculate_string($ggt);
$answer1[$j] = number_format(($answer1[$j]),2);
}else{
$answer1[$j]="N/A";
}
///
if ($TQQR[$Q1] !=$blink AND $TQR[$Q1] !=$blink){
// if ($column12 !=0 AND $column12 !=$blink){
$Formula2[$j]= (strtr($Formula2[$j], array('Count(QR'=> '(ZR')));
$Formula2[$j]= (strtr($Formula2[$j], array('QR'=> '$TQR')));
$Formula2[$j]= (strtr($Formula2[$j], array('ZR'=> '$TQQR')));
// echo "$j - $Formula[$j] ";
$ggt=$Formula2[$j];
eval("\$ggt = \"$ggt\";");
// echo "$ggt ";
$Sanswer1[$j]= calculate_string($ggt);
$Sanswer1[$j] = number_format(($Sanswer1[$j]),2);
} else{
$Sanswer1[$j]="N/A";
}
if ($X3QQR[$Q1] !=$blink AND $X3QR[$Q1] !=$blink){
$Formula3[$j]= (strtr($Formula3[$j], array('Count(QR'=> '(ZR')));
$Formula3[$j]= (strtr($Formula3[$j], array('QR'=> '$X3QR')));
$Formula3[$j]= (strtr($Formula3[$j], array('ZR'=> '$X3QQR')));
// echo "$j - $Formula[$j] ";
$ggt=$Formula3[$j];
eval("\$ggt = \"$ggt\";");
$Tanswer1[$j]= calculate_string($ggt);
$Tanswer1[$j] = number_format(($Tanswer1[$j]),2);
} else{
$Tanswer1[$j]="N/A";
}
if ($X4QQR[$Q1] !=$blink AND $X4QR[$Q1] !=$blink){
$Formula4[$j]= (strtr($Formula4[$j], array('Count(QR'=> '(ZR')));
$Formula4[$j]= (strtr($Formula4[$j], array('QR'=> '$X4QR')));
$Formula4[$j]= (strtr($Formula4[$j], array('ZR'=> '$X4QQR')));
// echo "$j - $Formula[$j] ";
$ggt=$Formula4[$j];
eval("\$ggt = \"$ggt\";");
$Fanswer1[$j]= calculate_string($ggt);
$Fanswer1[$j] = number_format(($Fanswer1[$j]),2);
} else{
$Fanswer1[$j]="N/A";
}
if ($ATQQR[$Q1] !=$blink AND $ATQR[$Q1] !=$blink){
// echo "$j - $Formula5[$j] ";
// if ($column12 !=0 AND $column12 !=$blink){
$Formula5[$j]= (strtr($Formula5[$j], array('Count(QR'=> '(ZR')));
// echo "$j z - $Formula5[$j] ";
$Formula5[$j]= (strtr($Formula5[$j], array('QR'=> '$ATQR')));
$Formula5[$j]= (strtr($Formula5[$j], array('ZR'=> '$ATQQR')));
// echo "$j - $Formula5[$j] ";
$ggt=$Formula5[$j];
// echo "$ggt ";
eval("\$ggt = \"$ggt\";");
// echo "$ggt ";
$Allanswer1[$j]= calculate_string($ggt);
$Allanswer1[$j] = number_format(($Allanswer1[$j]),2);
} else{
$Allanswer1[$j]="N/A";
}
// echo "$answer1[$j] ";
$Xbobv='';
$Xbobv1[$j]='';
$XvanZ1[$j]='';
$XZZ1A[$j]='';
$X3bobv='';
$X3bobv1[$j]='';
$X3vanZ1[$j]='';
$X3ZZ1A[$j]='';
$X4bobv='';
$X4bobv1[$j]='';
$X4vanZ1[$j]='';
$X4ZZ1A[$j]='';
// echo "vanz[$j] =$vanZ1[$j] --count=$ZZ1A[$j]-$findvan[$Q1] ";
require_once("util_calce.php");
$vals = array(3, 4, 5, 7, 8);
//echo $bobv1[$j];
$vals1[$j]=explode(",", $bobv1[$j]);
if (count($vals1[$j])>1){
$std1[$j]=stddev($vals1[$j]);
}
$vals2[$j]=explode(",", $bobv2[$j]);
if (count($vals2[$j])>1){
$std2[$j]=stddev($vals2[$j]);
}
$vals3[$j]=explode(",", $bobv3[$j]);
$toop[$j]=count($vals3[$j]);
if ($toop[$j]>1){
$std3[$j]=stddev($vals3[$j]);
}
$vals4[$j]=explode(",", $bobv4[$j]);
if (count($vals4[$j])>1){
$std4[$j]=stddev($vals4[$j]);
}
$stderr1[$j] = $std1[$j] / sqrt(count($vals1[$j]));
$stderr2[$j] = $std2[$j] / sqrt(count($vals2[$j]));
$stderr3[$j] = $std3[$j] / sqrt(count($vals3[$j]));
$stderr4[$j] = $std4[$j] / sqrt(count($vals4[$j]));
$topzz=count($vals1[$j])-1;
include("confidence.php");
//now get the CI:
$CI95 = $stderr*ttable((count($vals)-1),0.025);
$CI90a[$j] = $stderr1[$j]*ttable($topzz,0.05);
$CI95a[$j] = $stderr1[$j]*ttable($topzz,0.025);
$topzz=count($vals2[$j])-1;
include("confidence.php");
$CI90b[$j] = $stderr2[$j]*ttable($topzz,0.05);
$CI95b[$j] = $stderr2[$j]*ttable($topzz,0.025);
$topzz=count($vals3[$j])-1;
include("confidence.php");
$CI90c[$j] = $stderr3[$j]*ttable($topzz,0.05);
$CI95c[$j] = $stderr3[$j]*ttable($topzz,0.025);
$topzz=count($vals4[$j])-1;
include("confidence.php");
$CI90d[$j] = $stderr4[$j]*ttable($topzz,0.05);
$CI95d[$j] = $stderr4[$j]*ttable($topzz,0.025);
$c1[$j] = explode(",", $bobv1[$j]);
$tB1[$j] = explode(",", $bobv2[$j]);
$tB2[$j] = explode(",", $bobv3[$j]);
$tB3[$j] = explode(",", $bobv4[$j]);
$cc1[$j]= count($c1[$j]);
$ttB1[$j]= count($tB1[$j]);
$ttB2[$j]= count($tB2[$j]);
$ttB3[$j]= count($tB3[$j]);
$avgg[$j]= avg2($c1[$j]);
//echo " 0-$avg[$j] ";
$avgg1[$j]= avg2($tB1[$j]);
//echo "1-$avgg1[$j] ";
$avgg2[$j]= avg2($tB2[$j]);
//echo "2=$avgg2[$j] ";
$avgg3[$j]= avg2($tB3[$j]);
//echo "3-$avgg3[$j] ";
$cCC1 =array($cc1[$j],$avgg[$j]);
$cCC2 =array($ttB1[$j],$avgg1[$j]);
$cCC3 =array($ttB2[$j],$avgg2[$j]);
$cCC4 =array($ttB3[$j],$avgg3[$j]);
//$tA = array(180, 45);
//$tB = array($ttB1, $avgg2[$j]);
$conv0=cr($cCC1);
$conv1=cr($cCC2);
$conv2=cr($cCC3);
$conv3=cr($cCC4);
//$conv=$tB;
$qsamp=$cc1[$j];
$bs = array(.05,0.0625, 0.0225, 0.0025);
$bs11 = array(1.645,1.96, 2.326);
$err11 = array(.05,.06, .07,.08,.09,.1);
$samplesize[$j]=ssize($conv0,$bs[0]);
$samplesize2[$j]=ssize2($std1[$j],$bs11[$bss11C],$err11[$errorC]);
if ($samplesize2[$j]< $samplesize[$j]){
$samplesize[$j]=$samplesize2[$j];
}
if ($qsamp<$samplesize[$j]){
$adviceSample[$j]="Increase your sample to: $samplesize[$j]";
}
$t=$tC;
$zscoreA=zscore($cCC1, $cCC3);
// echo "s-$s , z-$z";
if ($zscoreA >0 ){
$zscoreA=" The second sample is significant. ";
} else{
$zscoreA=" The second sample is not significantly different. ";
}
$avgg[$j]=number_format($avgg[$j],2);
$avgg1[$j]=number_format($avgg1[$j],2);
$avgg2[$j]=number_format($avgg2[$j],2);
$avgg3[$j]=number_format($avgg3[$j],2);
$std1[$j]=number_format($std1[$j],3);
$std2[$j]=number_format($std2[$j],3);
$std3[$j]=number_format($std3[$j],3);
$std4[$j]=number_format($std4[$j],3);
$CI90a[$j]=number_format($CI90a[$j],3);
$CI90b[$j]=number_format($CI90b[$j],3);
$CI90c[$j]=number_format($CI90c[$j],3);
$CI90d[$j]=number_format($CI90d[$j],3);
if ($operand2[$j]==29){
$answer1[$j] = "Population1: $avgg[$j] vs Population1: $avgg1[$j] $zscoreA";
} //compare
//
$not1[$j]="Population 1 Average: $avgg[$j], o1=$std1[$j], Sample size:$cc1[$j] CI90: $CI90a[$j] $adviceSample[$j] ";
if($ttB1[$j]>1){
$not2[$j]= "Population 2 Average: $avgg1[$j], o2=$std2[$j], Sample Size:$ttB1[$j] CI90: $CI90b[$j] ";
}
if($ttB2[$j]>1){
$not3[$j]= "Population 3 Average: $avgg2[$j], o3=$std3[$j], Sample Size:$ttB2[$j] CI90: $CI90c[$j] " ;
}
if($ttB3[$j]>1){
$not4[$j]="Population 4 Average: $avgg3[$j], o4=$std4[$j], Sample Size:$ttB3[$j] CI90: $CI90d[$j] ";
}
$tC = $ttB2[$j];
//${notes.$j} .="Control Average: $avgg[$j] , Sample size:$cc1[$j] Test Average: $avgg1[$j] , Sample Size:$ttB1[$j] , Test Average: $avgg2[$j] , Sample Size:$ttB2[$j] Test Average: $avgg3[$j] , Sample Size:$ttB3[$j] ";
${notes.$j} ="$not1[$j] $not2[$j] $not3[$j] $not4[$j]";
$notes[$j].=" o1=$std1[$j],$std2[$j],$std3[$j],$std4[$j] CI-$CI90a[$j]-$CI90b[$j]-$CI90c[$j]-$CI90d[$j]
$zscoreA $adviceSample[$j] ";
${popnoteE.$j} .="More Information ";
$normT='';
if ($answer1[$j]<0){
$body .="\"$metric_name[$j]\": 0,";
}
if ($answer1[$j]>=0 AND $answer1[$j]<11){
$body .="\"$metric_name[$j]\": $answer1[$j],";
// $normT=": Normalized";
}
if ($answer1[$j]>10 AND $answer1[$j]<101 ){
$bbody=$answer1[$j]/10;
$body .="\"$metric_name[$j]\": $bbody,";
$normT=": Normalized";
}
if ($answer1[$j]>100 AND $answer1[$j]<1001 ){
$bbody=$answer1[$j]/200;
$body .="\"$metric_name[$j]\": $bbody,";
$normT=": Normalized";
}
if ($answer1[$j]>1000 AND $answer1[$j]<10001 ){
$bbody=$answer1[$j]/2000;
$body .="\"$metric_name[$j]\": $bbody,";
$normT=": Normalized";
}
include("tablefix.php");
$radar1[1]="
" ;
$displayZZ .="#boxes #dialog6$j {
background:url(GoTool/risk/images/notice.png) repeat 0 0 transparent;
width:326px;
height:400px;
padding:50px 0 20px 25px;
}";
$displaytop[$j]="
";
$displaybot[$j]= " ";
// echo "$gmath[$j] ";
//Difference
// } //end metric[$j] need to move this to end
$j=$j+1;
} //table 600
$display_block = "
![](\"GoTool/image/add.png\")
