<?
session_start();
header("Cache-control: private"); //IE 6 Fix 

error_reporting(E_ALL ^ E_NOTICE);

// ---- USED FOR THE SEARCH CRITERIA >
// CHECKS THE FIELD TYPE AND MAKES SURE THAT THE OPERATOR MATCHES

function CTB($theCriteria){

	$theCTB = 0;
	if ($theCriteria=="1" || $theCriteria=="true" || $theCriteria=="True" || $theCriteria=="TRUE" || $theCriteria=="Yes" || $theCriteria=="YES" || $theCriteria=="yes"){
		$theCTB=1;
	}
	return $theCTB;
}

function STT($theStringDate){
	$theSTT = "";
	$theSTT=date("m-d-y", strtotime($theStringDate));
	return $theSTT;
}

function GFT($theField){

$FT = "TEXT";

	$DateFields = array("MemberSince", "BirthDate", "Birthdate");
	$BooleanFields = array("Activated","Deleted");
	if (in_array($theField, $DateFields)) {
   		$FT = "DATE";
   	}
	if (in_array($theField, $BooleanFields)) {
   		$FT = "BOOL";
	}
	
	return $FT;
}

function Approp($theSearchField,$theSearchCriteria){
	$A = 0;	
	if (($theSearchField != "Required") && ($theSearchField != "Optional") && !empty($theSearchCriteria)){
		$A = 1;
	}
	return $A;
}

function CrSQL($theSearchString,$theOp,$theSearchType){

	$theNewSQL = "";
	switch ($theOp){
	
	case 1:
		// EQUALS
		$theNewSQL = " = '".$theSearchString."'";
		if ($theSearchType=="BOOL"){
			$theNewSQL = " = ".CTB($theSearchString);
		}		
		if ($theSearchType=="DATE"){	
			$theNewSQL = " > '".$theSearchString."'";
		}			
		break;
		
	case 2:
		// BEGINS WITH
		$theNewSQL = " LIKE '".$theSearchString."%'";
		if ($theSearchType=="DATE"){
			$theNewSQL = " > '".$theSearchString."'";
		}		
		break;		

	case 3:
		// CONTAINS
		$theNewSQL = " LIKE '%".$theSearchString."%'";
		if ($theSearchType=="DATE"){
			$theNewSQL = " > '".$theSearchString."'";
		}				
		break;
		
	case 4:
		// ENDS WITH
		$theNewSQL = " LIKE '%".$theSearchString."'";
		if ($theSearchType=="DATE"){
			$theNewSQL = " > '".$theSearchString."'";
		}		
		break;	
		
	case 5:
		// GREATER THAN
		$theNewSQL = " LIKE '".$theSearchString."%'";
		if ($theSearchType=="DATE"){
			$theNewSQL = " > '".$theSearchString."'";
		}				
		break;	
		
	case 6:
		// GREATER THAN OR EQUAL
		$theNewSQL = " LIKE '".$theSearchString."%'";
		if ($theSearchType=="DATE"){
			$theNewSQL = " >= '".$theSearchString."'";
		}				
		break;		
		
	case 7:
		// LESS THAN
		$theNewSQL = " LIKE '%".$theSearchString."'";
		if ($theSearchType=="DATE"){
			$theNewSQL = " < '".$theSearchString."'";
		}		
		break;	
		
	case 8:
		// LESS THAN OR EQUAL
		$theNewSQL = " LIKE '%".$theSearchString."'";
		if ($theSearchType=="DATE"){
			$theNewSQL = " <= '".$theSearchString."'";
		}		
		break;			
	
	default:
		$theNewSQL = " = ".$theSearchString;
		break;
	}
	
	return $theNewSQL;
}

// ---- USED FOR THE SEARCH CRITERIA >
$SFld1 = $_POST['SearchField1']; 
$SComp1 = $_POST['Comparison1'];
$SCrit1 = $_POST['SearchCriteria1'];
$Op1 = $_POST['AndOr1'];

$SFld2 = $_POST['SearchField2'];
$SComp2 = $_POST['Comparison2'];
$SCrit2 = $_POST['SearchCriteria2'];
$Op2 =  $_POST['AndOr2'];

$SFld3 = $_POST['SearchField3'];
$SComp3 = $_POST['Comparison3'];
$SCrit3 = $_POST['SearchCriteria3'];

$MCID = $_GET['MCID'];
$GFGB = $_GET['GFGB'];

$_SESSION['McMember_MCID'] = "";
$_SESSION['McMember_MCID'] = $MCID;

$theSelectedSort = $_GET['SO'];
$_SESSION['McMember_SONum'] = $theSelectedSort;
$_SESSION['McMember_SO'] = "";

$_SESSION['McMember_NavPage'] = "1";

if ((!empty($SFld1) && ($SFld1 != "Required")) && !empty($SCrit1)){
	// CHECK RULES
	$SStr1 = "mem.".$SFld1.CrSQL($SCrit1,$SComp1,GFT($SFld1));
	// echo $SStr1;
}
if ((!empty($SFld2) && ($SFld2 != "Optional")) && !empty($SCrit2)){
	// CHECK RULES
	$SStr2 = "mem.".$SFld2.CrSQL($SCrit2,$SComp2,GFT($SFld2));
	// echo $SStr2;
}
if ((!empty($SFld3) && ($SFld3 != "Optional")) && !empty($SCrit3)){
	// CHECK RULES
	$SStr3 = "mem.".$SFld3.CrSQL($SCrit3,$SComp3,GFT($SFld3));
	// echo $SStr3;
}

if (Approp($SFld1,$SStr1)){
	$NoSearchCriteriaFound=0;
	$SStringFinal = " AND ".$SStr1;
	if (Approp($SFld2,$SStr2) && Approp($SFld3,$SStr3)){
		$SStringFinal =  " AND ".$SStr1." ".$Op1." ".$SStr2." ".$Op2." ".$SStr3;
	}
	else{
		// String 1 is good
		// either or potentially both strings 2,3 are messed.
		if (Approp($SFld2,$SStr2)){
			$SStringFinal =  " AND ".$SStr1." ".$Op1." ".$SStr2;
		}
		if (Approp($SFld3,$SStr3)){
			$SStringFinal =  " AND ".$SStr1." ".$Op1." ".$SStr3;
		}		
	}
} // END IF APPROPRIATE SEARCH 1
else{
		if ($MCID == 33){
			 
			 if (($GFGB==1) || ($GFGB==0)){
			 	// go forward or go back has been pressed, continue with the query
			 	
				if (isset($GFGB) || isset($theSelectedSort)){
				 	$SStringFinal = $_SESSION['McMember_SS'];
				}
				else{
				 $SStringFinal = " AND mem.LastName ='Goolehommenowskifush'";
				}

			 }
		}
}
$_SESSION['McMember_SS'] = "";
$_SESSION['McMember_SS'] = $SStringFinal;

// ---- USED FOR THE SEARCH CRITERIA >

if (empty($GFGB)){
	// RESET ALL SESSION ITEMS RELATED TO PAGING
	// $_SESSION['McMember_Moffset'] = 15;
	$_SESSION['McMember_Min'] = 0;
	$_SESSION['McMember_Max'] = $_SESSION['McMember_Min']+$_SESSION['McMember_Moffset'];
}
else{
	switch($GFGB){
		case 0:
			// GO BACKWARD
			if (isset($_SESSION['McMember_Min']) && ($_SESSION['McMember_Min'] !=0)){
				$_SESSION['McMember_Min'] = $_SESSION['McMember_Min'] - $_SESSION['McMember_Moffset'];
				$_SESSION['McMember_Max'] = $_SESSION['McMember_Max']-$_SESSION['McMember_Moffset'];
			}
			else{
				$_SESSION['McMember_Min'] = 0;
				$_SESSION['McMember_Max'] = $_SESSION['McMember_Min']+$_SESSION['McMember_Moffset'];			
			}
			break;
		case 1:
			// GO FORWARD
			if (isset($_SESSION['McMember_Min'])){
				$_SESSION['McMember_Min'] = $_SESSION['McMember_Min'] + $_SESSION['McMember_Moffset'];
				$_SESSION['McMember_Max'] = $_SESSION['McMember_Max'] + $_SESSION['McMember_Moffset'];	
			}
			break;
		default:
			break;
	}
}

// echo $theSelectedSort;

function GetSortOrder($theSelectedColumn){
	
	switch ( $theSelectedColumn ) 
    { 
    case "1": 
    	 // echo "test case 1";
      $MSO = " ORDER BY mem.FirstName"; 
      // echo $MSO;
      break; 

    case "2": 
      $MSO = " ORDER BY mem.LastName"; 
      break; 

    case "3": 
      $MSO = " ORDER BY mem.Phone_Display"; 
      break; 

    case "4": 
      $MSO = " ORDER BY mem.Email"; 
      break; 
      
    case "5": 
      $MSO = " ORDER BY mem.MemType"; 
      break; 
      
    case "6": 
      $MSO = " ORDER BY mem.MemStatus"; 
      break;       
      
    case "7": 
      $MSO = " ORDER BY mem.MemberSince"; 
      break;  
      
    case "8": 
      $MSO = " ORDER BY mem.Birthdate"; 
      break;        

    default: 
      $MSO = " ORDER BY mem.LastName"; 
      break; 
    } 
    return $MSO;
}

if ($theSelectedSort){
	$MSOFinal = GetSortOrder($theSelectedSort);
	$_SESSION['McMember_SO'] = $MSOFinal;
}
else{
	$MSOFinal = " ORDER BY mem.LastName"; 
	$_SESSION['McMember_SO'] = $MSOFinal;
}


if($_SESSION['McMember_OrgId']){ 
	// everything is alright
}else{
	// something has gone wrong, the org id cant be located
	$_SESSION['McMember_FailureReason'] = "UnableToLocateOrgId";
	header("location: Login.php");
}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
	   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
	<title>McMembers Member Administration</title>
	<link rel="stylesheet" href="../Menus/MenuCSS.css" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>
.
<div id="header">
<?include "../Menus/MenuHeader.php";?>
</div>

<div id="nav">
<?include "../Menus/MenuLeft.php";?>
</div>

<div id="content">
<?
if (!empty($_SESSION['ValidateMessage'])){
	$theDisplayMessage = $_SESSION['ValidateMessage'];
	$_SESSION['ValidateMessage'] = "";
	print "<table border='0' bgcolor='#000000' width ='350' align='center'>";
	print "<tr>&nbsp;</tr>";
	print "<tr>";
	print"<td style='font-family: arial, helvetica, geneva, sans-serif; font-size: small' bgcolor='#FFFF00' width='350'>";
	print "<B><font size='4' font color='#000000'>".$theDisplayMessage."</font></B>";	
	print "</td>";
	print "</tr>";
	print "</table>";	
}
Else{

switch($MCID){
	
	case 2 :
		$_SESSION['McMember_SS']="";
		include "EditMembers.php";
		break;
		
	case 3 :
		$_SESSION['McMember_SS']="";
		include "SearchMembers.php";
		break;
		
	case 33 :
		include "EditMembers.php";
		break;
		
	case 4 :
		include "ImageMembers.php";
		break;
		
	case 5 :
		include "PermissionMembers.php";
		break;		
		
	case 6 :
		include "../Unit/EditUnits.php";
		break;			
		
	default:
		include "EditMembers.php";	
		break;
	} // END SWITCH
} // END ELSE
?>
</div>
<div id="footer">
<?include "../Menus/MenuFooter.php";?>
</div>

</a>

<?$_SESSION['ValidateProblem'] = ""; ?>

</font></font>

<style>
<!--

.page

{

	background-color: #FFFFFF;

	color: #000000;

}

.tborder

{

	background-color: #CCCCCC;

	color: #000000;

	border: 1px solid #CCCCCC;

}

td

{

	font: 8pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;

}

.alt1

{

	background-color: #EBEBF5;

	color: #000000;

}

.alt2

{

	background-color: #EBEBF5;

	color: #000000;

}

-->

</style>

</body>