<apex:page id="visitPage" standardController="Visit__c" extensions="submitVisitController" tabStyle="Visit__c">
	<apex:form id="visitForm">
		<script>
			window.load = openSubmitVisitPage();
			function openSubmitVisitPage(){
				if ({!blnAlreadySubmited} == true || '{!blnAlreadySubmited}' == 'true') {
					if (confirm("You have already submitted a sheet for this visit, are you sure you want to submit another one?")){
						window.open("https://cs16.salesforce.com/a1Z/e?CF00ND0000005FbyJ={!Visits__c.Name}&CF00ND0000005FbyJ_lkid={!Visits__c.Id}&retURL={!Visits__c.Site_Contract__c}&CF00ND0000005FcIJ_lkid","_top");
					} else {
						window.open("https://cs16.salesforce.com/a1Z/e?CF00ND0000005FbyJ={!Visits__c.Name}&CF00ND0000005FbyJ_lkid={!Visits__c.Id}&retURL={!Visits__c.Site_Contract__c}&CF00ND0000005FcIJ_lkid","_top");
					}
				}
			}
		</script>
	</apex:form>
</apex:page>

public class submitVisitController {
	
	// Visit object
	public Visit__c objVisit{get;set;}
	
	// Flag for confirmation
	public Boolean blnAlreadySubmited{get;set;}
	
	// Collection Variables
	public List<Engineer_Checklist__c> listEngineerCheckList;
	public List<Service_Sheet_STD__c> listServiceSheetSTD;
	public List<Mechanical_Service_Sheet__c> listMechanicalServiceSheet;
	public List<Small_Works__c> listSmallWorks;
	public List<Project_Sheet__c> listProjectSheet;
	
	///========================================================//
    //Constructor
    //========================================================//
    public avPolicyDetailsController(ApexPages.StandardController objStandardController){
		Visit__c objVisitFromPage = (Visit__c)objStandardController.getRecord();
		if (objVisitFromPage != null && objVisitFromPage.Id != null) {
			objVisit = [SELECT Id, Name, Site_Contract__c FROM Visit__c WHERE Id =: objVisitFromPage.Id LIMIT 1];
			if (objVisit != null) {
				
				listEngineerCheckList = new List<Engineer_Checklist__c>(SELECT Id,Visit__c FROM Engineer_Checklist__c 
											WHERE Visit__r.Id =: objVisit.Id AND Fire_Extinguisher_Service_complete__c = True);
				
				listServiceSheetSTD = new List<Service_Sheet_STD__c>(SELECT Id,Visit__c FROM Service_Sheet_STD__c 
											WHERE Visit__r.Id =: objVisit.Id AND Fire_Extinguisher_Service_complete__c = True);
				
				listMechanicalServiceSheet = new List<Mechanical_Service_Sheet__c>(SELECT Id,Visit__c FROM Mechanical_Service_Sheet__c 
											WHERE Visit__r.Id =: objVisit.Id AND Fire_Extinguisher_Service_complete__c = True);
				
				listSmallWorks = new List<Small_Works__c>(SELECT Id,Visit__c FROM Small_Works__c 
											WHERE Visit__r.Id =: objVisit.Id AND Submit_this_Small_Works_Sheet__c = True);
				
				listProjectSheet = new List<Project_Sheet__c>(SELECT Id,Visit__c FROM Project_Sheet__c 
											WHERE Visit__r.Id =: objVisit.Id AND Fire_Extinguisher_Service_complete__c = True);
				
				if (listEngineerCheckList.size() > 0 || listServiceSheetSTD.size() > 0 || listMechanicalServiceSheet.size() > 0 
					|| listSmallWorks.size() > 0 || listProjectSheet.size() > 0) {
					
					blnAlreadySubmited = true;
				} else {
					blnAlreadySubmited = false;
				}
				
			}
		}
	}
	
}