function doSearch()

in assets/www/scripts/photark_search.js [20:89]
67 lines of code
50 McCabe index (conditional complexity)

function doSearch(){
	
	//initialize search parameters
	var name=$("#searchName").val();
	var startDate=$("#searchStartDate").val();
	var endDate=$("#searchEndDate").val();
	var location=$("#searchLocation").val();
	var temp=$("#searchPeople").val();
	var people=new Array();
	
	if(temp!=undefined && temp!=""){
		people=temp.split(",");
	}
	if(name=="" && startDate=="" && endDate=="" && location=="" && temp==""){
		alert("Fill the information!");
		return;
	}
	if(startDate=="" && endDate=="" && temp==""){
		searchDB('SELECT * FROM MAIN WHERE nickname LIKE "%'+name+'%" AND location LIKE "%'+location+'%";');		
	}else if(name=="" && (startDate!="" || endDate!="") && location=="" && temp==""){
		if(startDate!="" && endDate==""){
			searchDB('SELECT * FROM MAIN WHERE date >= date("'+startDate+'");');
		}else if(startDate=="" && endDate!=""){
			searchDB('SELECT * FROM MAIN WHERE date <= date("'+endDate+'");');
		}else{
			searchDB('SELECT * FROM MAIN WHERE date >= date("'+startDate+'") and date <= date("'+endDate+'");');
		}		
	}else if(temp!=undefined && temp!="" && name=="" && startDate=="" && endDate=="" && location==""){
		var temp2='SELECT * FROM PEOPLE WHERE ';
		for ( var int = 0; int < people.length; int++) {
			if (int != people.length-1) {
				temp2+='name LIKE "%'+people[int]+'%" AND ';
			} else{
				temp2+='name LIKE "%'+people[int]+'%"; ';
			}
		}
		searchDB(temp2);
	}else if(temp=="" && (startDate!="" || endDate!="") && (name!="" || location!="")){
		if(startDate!="" && endDate==""){
			searchDB('SELECT * FROM MAIN WHERE date >= date("'+startDate+'") AND nickname LIKE "%'+name+'%" AND location LIKE "%'+location+'%";');
		}else if(startDate=="" && endDate!=""){
			searchDB('SELECT * FROM MAIN WHERE date <= date("'+endDate+'") AND nickname LIKE "%'+name+'%" AND location LIKE "%'+location+'%";');
		}else{
			searchDB('SELECT * FROM MAIN WHERE date >= date("'+startDate+'") and date <= date("'+endDate+'") AND nickname LIKE "%'+name+'%" AND location LIKE "%'+location+'%";');
		}	
	}else if(temp!="" && (startDate!="" || endDate!="")){
		var temp3='SELECT * FROM MAIN NATURAL JOIN PEOPLE WHERE nickname LIKE "%'+name+'%" AND location LIKE "%'+location+'%" AND';
		for ( var int = 0; int < people.length; int++) {
				temp3+='name LIKE "%'+people[int]+'%" AND ';
		}
		if(startDate!="" && endDate==""){
			temp3+=' date >= date("'+startDate+'");';
		}else if(startDate=="" && endDate!=""){
			temp3+=' date <= date("'+endDate+'");';
		}else{
			temp3+=' date >= date("'+startDate+'") and date <= date("'+endDate+'");';
		}	
		searchDB(temp3);
	}else if(temp!="" && startDate=="" && endDate==""){
		var temp4='SELECT * FROM MAIN NATURAL JOIN PEOPLE WHERE nickname LIKE "%'+name+'%" AND location LIKE "%'+location+'%" AND';
		for ( var int = 0; int < people.length; int++) {
			if (int != people.length-1) {
				temp4+='name LIKE "%'+people[int]+'%" AND ';
			} else{
				temp4+='name LIKE "%'+people[int]+'%"; ';
			}
		}
		searchDB(temp4);
	}
}