<?php
$tdataMy_Home=array();
	$tdataMy_Home[".NumberOfChars"]=80; 
	$tdataMy_Home[".ShortName"]="My_Home";
	$tdataMy_Home[".OwnerID"]="idemplist";
	$tdataMy_Home[".OriginalTable"]="employee_list";


	
//	field labels
$fieldLabelsMy_Home = array();
if(mlang_getcurrentlang()=="English")
{
	$fieldLabelsMy_Home["English"]=array();
	$fieldToolTipsMy_Home["English"]=array();
	$fieldLabelsMy_Home["English"]["idemplist"] = "Idemplist";
	$fieldToolTipsMy_Home["English"]["idemplist"] = "";
	$fieldLabelsMy_Home["English"]["Full_Name"] = "Full Name";
	$fieldToolTipsMy_Home["English"]["Full Name"] = "";
	$fieldLabelsMy_Home["English"]["Father___Husband_Name"] = "Father / Husband Name";
	$fieldToolTipsMy_Home["English"]["Father / Husband Name"] = "";
	$fieldLabelsMy_Home["English"]["Job_Title"] = "Job Title";
	$fieldToolTipsMy_Home["English"]["Job Title"] = "";
	$fieldLabelsMy_Home["English"]["Address"] = "Address";
	$fieldToolTipsMy_Home["English"]["Address"] = "";
	$fieldLabelsMy_Home["English"]["City"] = "City";
	$fieldToolTipsMy_Home["English"]["City"] = "";
	$fieldLabelsMy_Home["English"]["State"] = "State";
	$fieldToolTipsMy_Home["English"]["State"] = "";
	$fieldLabelsMy_Home["English"]["Country"] = "Country";
	$fieldToolTipsMy_Home["English"]["Country"] = "";
	$fieldLabelsMy_Home["English"]["Postal_Code"] = "Postal Code";
	$fieldToolTipsMy_Home["English"]["Postal Code"] = "";
	$fieldLabelsMy_Home["English"]["Business_Phone"] = "Business Phone";
	$fieldToolTipsMy_Home["English"]["Business Phone"] = "";
	$fieldLabelsMy_Home["English"]["Home_Phone"] = "Home Phone";
	$fieldToolTipsMy_Home["English"]["Home Phone"] = "";
	$fieldLabelsMy_Home["English"]["Mobile_Phone"] = "Mobile Phone";
	$fieldToolTipsMy_Home["English"]["Mobile Phone"] = "";
	$fieldLabelsMy_Home["English"]["E_Mail_Address"] = "E-Mail Address";
	$fieldToolTipsMy_Home["English"]["E-Mail Address"] = "";
	$fieldLabelsMy_Home["English"]["Department"] = "Department";
	$fieldToolTipsMy_Home["English"]["Department"] = "";
	$fieldLabelsMy_Home["English"]["Region"] = "Region";
	$fieldToolTipsMy_Home["English"]["Region"] = "";
	$fieldLabelsMy_Home["English"]["Birth_Date"] = "Birth Date";
	$fieldToolTipsMy_Home["English"]["Birth Date"] = "";
	$fieldLabelsMy_Home["English"]["DOJ"] = "DOJ";
	$fieldToolTipsMy_Home["English"]["DOJ"] = "";
	$fieldLabelsMy_Home["English"]["Reporting_Manager"] = "Reporting Manager";
	$fieldToolTipsMy_Home["English"]["Reporting Manager"] = "";
	$fieldLabelsMy_Home["English"]["username"] = "Username";
	$fieldToolTipsMy_Home["English"]["username"] = "";
	if (count($fieldToolTipsMy_Home["English"])){
		$tdataMy_Home[".isUseToolTips"]=true;
	}
}


	
	$tdataMy_Home[".NCSearch"]=true;

	

$tdataMy_Home[".shortTableName"] = "My_Home";
$tdataMy_Home[".nSecOptions"] = 1;
$tdataMy_Home[".recsPerRowList"] = 1;	
$tdataMy_Home[".tableGroupBy"] = "0";
$tdataMy_Home[".mainTableOwnerID"] = "idemplist";
$tdataMy_Home[".moveNext"] = 1;




$tdataMy_Home[".showAddInPopup"] = false;

$tdataMy_Home[".showEditInPopup"] = false;

$tdataMy_Home[".showViewInPopup"] = false;


$tdataMy_Home[".fieldsForRegister"] = array();

$tdataMy_Home[".listAjax"] = false;

	$tdataMy_Home[".audit"] = false;

	$tdataMy_Home[".locking"] = false;
	
$tdataMy_Home[".listIcons"] = true;
$tdataMy_Home[".edit"] = true;
$tdataMy_Home[".view"] = true;




$tdataMy_Home[".showSimpleSearchOptions"] = false;

$tdataMy_Home[".showSearchPanel"] = true;


$tdataMy_Home[".isUseAjaxSuggest"] = true;

$tdataMy_Home[".rowHighlite"] = true;


// button handlers file names
$tdataMy_Home[".isUsebuttonHandlers"] = true;
$tdataMy_Home[".isUsebuttonHandlers"] = true;
$tdataMy_Home[".isUsebuttonHandlers"] = true;
$tdataMy_Home[".isUsebuttonHandlers"] = true;
$tdataMy_Home[".isUsebuttonHandlers"] = true;

$tdataMy_Home[".addPageEvents"] = false;

$tdataMy_Home[".arrKeyFields"][] = "username";

// use datepicker for search panel
$tdataMy_Home[".isUseCalendarForSearch"] = true;

// use timepicker for search panel
$tdataMy_Home[".isUseTimeForSearch"] = false;

$tdataMy_Home[".isUseiBox"] = false;


$tdataMy_Home[".useDetailsPreview"] = true;	


$tdataMy_Home[".isUseInlineJs"] = $tdataMy_Home[".isUseInlineAdd"] || $tdataMy_Home[".isUseInlineEdit"];

$tdataMy_Home[".allSearchFields"] = array();

$tdataMy_Home[".globSearchFields"][] = "idemplist";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("idemplist", $tdataMy_Home[".allSearchFields"]))
{
	$tdataMy_Home[".allSearchFields"][] = "idemplist";	
}
$tdataMy_Home[".globSearchFields"][] = "Full Name";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Full Name", $tdataMy_Home[".allSearchFields"]))
{
	$tdataMy_Home[".allSearchFields"][] = "Full Name";	
}
$tdataMy_Home[".globSearchFields"][] = "Job Title";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Job Title", $tdataMy_Home[".allSearchFields"]))
{
	$tdataMy_Home[".allSearchFields"][] = "Job Title";	
}
$tdataMy_Home[".globSearchFields"][] = "Address";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Address", $tdataMy_Home[".allSearchFields"]))
{
	$tdataMy_Home[".allSearchFields"][] = "Address";	
}
$tdataMy_Home[".globSearchFields"][] = "City";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("City", $tdataMy_Home[".allSearchFields"]))
{
	$tdataMy_Home[".allSearchFields"][] = "City";	
}
$tdataMy_Home[".globSearchFields"][] = "State";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("State", $tdataMy_Home[".allSearchFields"]))
{
	$tdataMy_Home[".allSearchFields"][] = "State";	
}
$tdataMy_Home[".globSearchFields"][] = "Country";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Country", $tdataMy_Home[".allSearchFields"]))
{
	$tdataMy_Home[".allSearchFields"][] = "Country";	
}
$tdataMy_Home[".globSearchFields"][] = "Postal Code";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Postal Code", $tdataMy_Home[".allSearchFields"]))
{
	$tdataMy_Home[".allSearchFields"][] = "Postal Code";	
}
$tdataMy_Home[".globSearchFields"][] = "Business Phone";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Business Phone", $tdataMy_Home[".allSearchFields"]))
{
	$tdataMy_Home[".allSearchFields"][] = "Business Phone";	
}
$tdataMy_Home[".globSearchFields"][] = "Home Phone";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Home Phone", $tdataMy_Home[".allSearchFields"]))
{
	$tdataMy_Home[".allSearchFields"][] = "Home Phone";	
}
$tdataMy_Home[".globSearchFields"][] = "Mobile Phone";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Mobile Phone", $tdataMy_Home[".allSearchFields"]))
{
	$tdataMy_Home[".allSearchFields"][] = "Mobile Phone";	
}
$tdataMy_Home[".globSearchFields"][] = "E-Mail Address";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("E-Mail Address", $tdataMy_Home[".allSearchFields"]))
{
	$tdataMy_Home[".allSearchFields"][] = "E-Mail Address";	
}
$tdataMy_Home[".globSearchFields"][] = "Department";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Department", $tdataMy_Home[".allSearchFields"]))
{
	$tdataMy_Home[".allSearchFields"][] = "Department";	
}
$tdataMy_Home[".globSearchFields"][] = "Region";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Region", $tdataMy_Home[".allSearchFields"]))
{
	$tdataMy_Home[".allSearchFields"][] = "Region";	
}
$tdataMy_Home[".globSearchFields"][] = "Birth Date";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Birth Date", $tdataMy_Home[".allSearchFields"]))
{
	$tdataMy_Home[".allSearchFields"][] = "Birth Date";	
}
$tdataMy_Home[".globSearchFields"][] = "DOJ";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("DOJ", $tdataMy_Home[".allSearchFields"]))
{
	$tdataMy_Home[".allSearchFields"][] = "DOJ";	
}
$tdataMy_Home[".globSearchFields"][] = "Reporting Manager";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Reporting Manager", $tdataMy_Home[".allSearchFields"]))
{
	$tdataMy_Home[".allSearchFields"][] = "Reporting Manager";	
}
$tdataMy_Home[".globSearchFields"][] = "Father / Husband Name";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Father / Husband Name", $tdataMy_Home[".allSearchFields"]))
{
	$tdataMy_Home[".allSearchFields"][] = "Father / Husband Name";	
}
$tdataMy_Home[".globSearchFields"][] = "username";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("username", $tdataMy_Home[".allSearchFields"]))
{
	$tdataMy_Home[".allSearchFields"][] = "username";	
}


$tdataMy_Home[".googleLikeFields"][] = "idemplist";
$tdataMy_Home[".googleLikeFields"][] = "Full Name";
$tdataMy_Home[".googleLikeFields"][] = "Job Title";
$tdataMy_Home[".googleLikeFields"][] = "Address";
$tdataMy_Home[".googleLikeFields"][] = "City";
$tdataMy_Home[".googleLikeFields"][] = "State";
$tdataMy_Home[".googleLikeFields"][] = "Country";
$tdataMy_Home[".googleLikeFields"][] = "Postal Code";
$tdataMy_Home[".googleLikeFields"][] = "Business Phone";
$tdataMy_Home[".googleLikeFields"][] = "Home Phone";
$tdataMy_Home[".googleLikeFields"][] = "Mobile Phone";
$tdataMy_Home[".googleLikeFields"][] = "E-Mail Address";
$tdataMy_Home[".googleLikeFields"][] = "Department";
$tdataMy_Home[".googleLikeFields"][] = "Region";
$tdataMy_Home[".googleLikeFields"][] = "Birth Date";
$tdataMy_Home[".googleLikeFields"][] = "DOJ";
$tdataMy_Home[".googleLikeFields"][] = "Reporting Manager";
$tdataMy_Home[".googleLikeFields"][] = "Father / Husband Name";
$tdataMy_Home[".googleLikeFields"][] = "username";



$tdataMy_Home[".advSearchFields"][] = "idemplist";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("idemplist", $tdataMy_Home[".allSearchFields"])) 
{
	$tdataMy_Home[".allSearchFields"][] = "idemplist";	
}
$tdataMy_Home[".advSearchFields"][] = "Full Name";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Full Name", $tdataMy_Home[".allSearchFields"])) 
{
	$tdataMy_Home[".allSearchFields"][] = "Full Name";	
}
$tdataMy_Home[".advSearchFields"][] = "Job Title";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Job Title", $tdataMy_Home[".allSearchFields"])) 
{
	$tdataMy_Home[".allSearchFields"][] = "Job Title";	
}
$tdataMy_Home[".advSearchFields"][] = "Address";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Address", $tdataMy_Home[".allSearchFields"])) 
{
	$tdataMy_Home[".allSearchFields"][] = "Address";	
}
$tdataMy_Home[".advSearchFields"][] = "City";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("City", $tdataMy_Home[".allSearchFields"])) 
{
	$tdataMy_Home[".allSearchFields"][] = "City";	
}
$tdataMy_Home[".advSearchFields"][] = "State";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("State", $tdataMy_Home[".allSearchFields"])) 
{
	$tdataMy_Home[".allSearchFields"][] = "State";	
}
$tdataMy_Home[".advSearchFields"][] = "Country";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Country", $tdataMy_Home[".allSearchFields"])) 
{
	$tdataMy_Home[".allSearchFields"][] = "Country";	
}
$tdataMy_Home[".advSearchFields"][] = "Postal Code";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Postal Code", $tdataMy_Home[".allSearchFields"])) 
{
	$tdataMy_Home[".allSearchFields"][] = "Postal Code";	
}
$tdataMy_Home[".advSearchFields"][] = "Business Phone";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Business Phone", $tdataMy_Home[".allSearchFields"])) 
{
	$tdataMy_Home[".allSearchFields"][] = "Business Phone";	
}
$tdataMy_Home[".advSearchFields"][] = "Home Phone";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Home Phone", $tdataMy_Home[".allSearchFields"])) 
{
	$tdataMy_Home[".allSearchFields"][] = "Home Phone";	
}
$tdataMy_Home[".advSearchFields"][] = "Mobile Phone";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Mobile Phone", $tdataMy_Home[".allSearchFields"])) 
{
	$tdataMy_Home[".allSearchFields"][] = "Mobile Phone";	
}
$tdataMy_Home[".advSearchFields"][] = "E-Mail Address";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("E-Mail Address", $tdataMy_Home[".allSearchFields"])) 
{
	$tdataMy_Home[".allSearchFields"][] = "E-Mail Address";	
}
$tdataMy_Home[".advSearchFields"][] = "Department";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Department", $tdataMy_Home[".allSearchFields"])) 
{
	$tdataMy_Home[".allSearchFields"][] = "Department";	
}
$tdataMy_Home[".advSearchFields"][] = "Region";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Region", $tdataMy_Home[".allSearchFields"])) 
{
	$tdataMy_Home[".allSearchFields"][] = "Region";	
}
$tdataMy_Home[".advSearchFields"][] = "Birth Date";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Birth Date", $tdataMy_Home[".allSearchFields"])) 
{
	$tdataMy_Home[".allSearchFields"][] = "Birth Date";	
}
$tdataMy_Home[".advSearchFields"][] = "DOJ";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("DOJ", $tdataMy_Home[".allSearchFields"])) 
{
	$tdataMy_Home[".allSearchFields"][] = "DOJ";	
}
$tdataMy_Home[".advSearchFields"][] = "Reporting Manager";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Reporting Manager", $tdataMy_Home[".allSearchFields"])) 
{
	$tdataMy_Home[".allSearchFields"][] = "Reporting Manager";	
}
$tdataMy_Home[".advSearchFields"][] = "Father / Husband Name";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Father / Husband Name", $tdataMy_Home[".allSearchFields"])) 
{
	$tdataMy_Home[".allSearchFields"][] = "Father / Husband Name";	
}
$tdataMy_Home[".advSearchFields"][] = "username";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("username", $tdataMy_Home[".allSearchFields"])) 
{
	$tdataMy_Home[".allSearchFields"][] = "username";	
}

$tdataMy_Home[".isTableType"] = "list";


	

$tdataMy_Home[".isDisplayLoading"] = true;

$tdataMy_Home[".isResizeColumns"] = false;

	$tdataMy_Home[".subQueriesSupAccess"] = true;




$tdataMy_Home[".pageSize"] = 20;

$gstrOrderBy = "";
if(strlen($gstrOrderBy) && strtolower(substr($gstrOrderBy,0,8))!="order by")
	$gstrOrderBy = "order by ".$gstrOrderBy;
$tdataMy_Home[".strOrderBy"] = $gstrOrderBy;
	
$tdataMy_Home[".orderindexes"] = array();

$tdataMy_Home[".sqlHead"] = "SELECT idemplist,  `Full Name`,  `Job Title`,  Address,  City,  `State`,  Country,  `Postal Code`,  `Business Phone`,  `Home Phone`,  `Mobile Phone`,  `E-Mail Address`,  Department,  Region,  `Birth Date`,  DOJ,  `Reporting Manager`,  `Father / Husband Name`,  username";
$tdataMy_Home[".sqlFrom"] = "FROM employee_list";
$tdataMy_Home[".sqlWhereExpr"] = "";
$tdataMy_Home[".sqlTail"] = "";



//fill array of tabs for view page
$arrViewTabs = array();
	$tabFields = array();
	$tabFields[] = "idemplist";
	$tabFields[] = "Full Name";
	$tabFields[] = "Father / Husband Name";
	$tabFields[] = "Birth Date";
	$tabFields[] = "DOJ";
$arrViewTabs[] = array('tabId'=>'Basic_Details1',
					   'tabName'=>"Basic Details",
					   'nType'=>'0',
					   'nOrder'=>1,
					   'tabGroup'=>1,
					   'arrFields'=> $tabFields,
					   'expandSec'=>0);
	$tabFields = array();
	$tabFields[] = "Address";
	$tabFields[] = "City";
	$tabFields[] = "State";
	$tabFields[] = "Country";
	$tabFields[] = "Postal Code";
$arrViewTabs[] = array('tabId'=>'Address_Details1',
					   'tabName'=>"Address Details",
					   'nType'=>'0',
					   'nOrder'=>7,
					   'tabGroup'=>1,
					   'arrFields'=> $tabFields,
					   'expandSec'=>0);
	$tabFields = array();
	$tabFields[] = "Business Phone";
	$tabFields[] = "Home Phone";
	$tabFields[] = "Mobile Phone";
	$tabFields[] = "E-Mail Address";
$arrViewTabs[] = array('tabId'=>'Contact_Details1',
					   'tabName'=>"Contact Details",
					   'nType'=>'0',
					   'nOrder'=>13,
					   'tabGroup'=>1,
					   'arrFields'=> $tabFields,
					   'expandSec'=>0);
	$tabFields = array();
	$tabFields[] = "Job Title";
	$tabFields[] = "Department";
	$tabFields[] = "Region";
	$tabFields[] = "Reporting Manager";
$arrViewTabs[] = array('tabId'=>'Organization_Structure1',
					   'tabName'=>"Organization Structure",
					   'nType'=>'0',
					   'nOrder'=>18,
					   'tabGroup'=>1,
					   'arrFields'=> $tabFields,
					   'expandSec'=>0);
	$tabFields = array();
$arrViewTabs[] = array('tabId'=>'New_section1',
					   'tabName'=>"New section",
					   'nType'=>'1',
					   'nOrder'=>23,
					   'tabGroup'=>0,
					   'arrFields'=> $tabFields,
					   'expandSec'=>0);
$tdataMy_Home[".arrViewTabs"] = $arrViewTabs;

//fill array of records per page for list and report without group fields
$arrRPP = array();
$arrRPP[] = 10;
$arrRPP[] = 20;
$arrRPP[] = 30;
$arrRPP[] = 50;
$arrRPP[] = 100;
$arrRPP[] = 500;
$arrRPP[] = -1;
$tdataMy_Home[".arrRecsPerPage"] = $arrRPP;

//fill array of groups per page for report with group fields
$arrGPP = array();
$arrGPP[] = 1;
$arrGPP[] = 3;
$arrGPP[] = 5;
$arrGPP[] = 10;
$arrGPP[] = 50;
$arrGPP[] = 100;
$arrGPP[] = -1;
$tdataMy_Home[".arrGroupsPerPage"] = $arrGPP;

	$tableKeys = array();
	$tableKeys[] = "username";
	$tdataMy_Home[".Keys"] = $tableKeys;

//	idemplist
	$fdata = array();
	$fdata["strName"] = "idemplist";
	$fdata["ownerTable"] = "employee_list";
		$fdata["Label"]="Idemplist"; 
	
		
		
	$fdata["FieldType"]= 3;
	
		$fdata["AutoInc"]=true;
	
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "idemplist";
	
		$fdata["FullName"]= "idemplist";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 1;
				$fdata["EditParams"]="";
			
		$fdata["bListPage"]=true; 
	
		
		
		
		
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
				$fdata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");	
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataMy_Home["idemplist"]=$fdata;
//	Full Name
	$fdata = array();
	$fdata["strName"] = "Full Name";
	$fdata["ownerTable"] = "employee_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Full_Name";
	
		$fdata["FullName"]= "`Full Name`";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 2;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=45";
		
		$fdata["bListPage"]=true; 
	
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataMy_Home["Full Name"]=$fdata;
//	Job Title
	$fdata = array();
	$fdata["strName"] = "Job Title";
	$fdata["ownerTable"] = "employee_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Job_Title";
	
		$fdata["FullName"]= "`Job Title`";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 3;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=45";
		
		$fdata["bListPage"]=true; 
	
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataMy_Home["Job Title"]=$fdata;
//	Address
	$fdata = array();
	$fdata["strName"] = "Address";
	$fdata["ownerTable"] = "employee_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text area";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Address";
	
		$fdata["FullName"]= "Address";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 4;
			$fdata["EditParams"] = "";
			$fdata["EditParams"].= " rows=100";
		$fdata["nRows"] = 100;
			$fdata["EditParams"].= " cols=200";
		$fdata["nCols"] = 200;
		
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataMy_Home["Address"]=$fdata;
//	City
	$fdata = array();
	$fdata["strName"] = "City";
	$fdata["ownerTable"] = "employee_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "City";
	
		$fdata["FullName"]= "City";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 5;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=15";
		
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataMy_Home["City"]=$fdata;
//	State
	$fdata = array();
	$fdata["strName"] = "State";
	$fdata["ownerTable"] = "employee_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "State";
	
		$fdata["FullName"]= "`State`";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 6;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=15";
		
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataMy_Home["State"]=$fdata;
//	Country
	$fdata = array();
	$fdata["strName"] = "Country";
	$fdata["ownerTable"] = "employee_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Country";
	
		$fdata["FullName"]= "Country";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 7;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=15";
		
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataMy_Home["Country"]=$fdata;
//	Postal Code
	$fdata = array();
	$fdata["strName"] = "Postal Code";
	$fdata["ownerTable"] = "employee_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Postal_Code";
	
		$fdata["FullName"]= "`Postal Code`";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 8;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=8";
		
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataMy_Home["Postal Code"]=$fdata;
//	Business Phone
	$fdata = array();
	$fdata["strName"] = "Business Phone";
	$fdata["ownerTable"] = "employee_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Business_Phone";
	
		$fdata["FullName"]= "`Business Phone`";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 9;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=15";
		
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataMy_Home["Business Phone"]=$fdata;
//	Home Phone
	$fdata = array();
	$fdata["strName"] = "Home Phone";
	$fdata["ownerTable"] = "employee_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Home_Phone";
	
		$fdata["FullName"]= "`Home Phone`";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 10;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=15";
		
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataMy_Home["Home Phone"]=$fdata;
//	Mobile Phone
	$fdata = array();
	$fdata["strName"] = "Mobile Phone";
	$fdata["ownerTable"] = "employee_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Mobile_Phone";
	
		$fdata["FullName"]= "`Mobile Phone`";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 11;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=15";
		
		$fdata["bListPage"]=true; 
	
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataMy_Home["Mobile Phone"]=$fdata;
//	E-Mail Address
	$fdata = array();
	$fdata["strName"] = "E-Mail Address";
	$fdata["ownerTable"] = "employee_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "Email Hyperlink";
	
		
		
		
		
		
	$fdata["GoodName"]= "E_Mail_Address";
	
		$fdata["FullName"]= "`E-Mail Address`";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 12;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=50";
		
		$fdata["bListPage"]=true; 
	
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
				$fdata["validateAs"]["basicValidate"][] = getJsValidatorName("Email");	
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataMy_Home["E-Mail Address"]=$fdata;
//	Department
	$fdata = array();
	$fdata["strName"] = "Department";
	$fdata["ownerTable"] = "employee_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Lookup wizard";
	$fdata["ViewFormat"]= "";
	
		
		$fdata["LookupType"]=1;
	$fdata["pLookupType"] = 1;
	$fdata["freeInput"] = 0;	
	$fdata["autoCompleteFieldsOnEdit"] = 0;
	$fdata["autoCompleteFields"] = array();
										$fdata["LinkField"]="Department";
	$fdata["LinkFieldType"]=200;
	$fdata["DisplayField"]="Department";
				$fdata["LookupTable"]="department";
	$fdata["LookupOrderBy"]="Department";
																$fdata["AllowToAdd"]=true; 
				
					
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Department";
	
		$fdata["FullName"]= "Department";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 13;
				
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataMy_Home["Department"]=$fdata;
//	Region
	$fdata = array();
	$fdata["strName"] = "Region";
	$fdata["ownerTable"] = "employee_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Lookup wizard";
	$fdata["ViewFormat"]= "";
	
		
		$fdata["LookupType"]=1;
	$fdata["pLookupType"] = 1;
	$fdata["freeInput"] = 0;	
	$fdata["autoCompleteFieldsOnEdit"] = 0;
	$fdata["autoCompleteFields"] = array();
										$fdata["LinkField"]="Region Name";
	$fdata["LinkFieldType"]=200;
	$fdata["DisplayField"]="Region Name";
				$fdata["LookupTable"]="region";
	$fdata["LookupOrderBy"]="Region Name";
																$fdata["AllowToAdd"]=true; 
				$fdata["SimpleAdd"]=true;
	
					
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Region";
	
		$fdata["FullName"]= "Region";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 14;
				
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataMy_Home["Region"]=$fdata;
//	Birth Date
	$fdata = array();
	$fdata["strName"] = "Birth Date";
	$fdata["ownerTable"] = "employee_list";
		
		
		
	$fdata["FieldType"]= 7;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Date";
	$fdata["ViewFormat"]= "Short Date";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Birth_Date";
	
		$fdata["FullName"]= "`Birth Date`";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 15;
		$fdata["DateEditType"] = 13; 
	$fdata["InitialYearFactor"] = 100; 
	$fdata["LastYearFactor"] = 10; 
			
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataMy_Home["Birth Date"]=$fdata;
//	DOJ
	$fdata = array();
	$fdata["strName"] = "DOJ";
	$fdata["ownerTable"] = "employee_list";
		
		
		
	$fdata["FieldType"]= 7;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Date";
	$fdata["ViewFormat"]= "Short Date";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "DOJ";
	
		$fdata["FullName"]= "DOJ";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 16;
		$fdata["DateEditType"] = 13; 
	$fdata["InitialYearFactor"] = 100; 
	$fdata["LastYearFactor"] = 10; 
			
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataMy_Home["DOJ"]=$fdata;
//	Reporting Manager
	$fdata = array();
	$fdata["strName"] = "Reporting Manager";
	$fdata["ownerTable"] = "employee_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Lookup wizard";
	$fdata["ViewFormat"]= "";
	
		
		$fdata["LookupType"]=1;
	$fdata["pLookupType"] = 1;
	$fdata["freeInput"] = 0;	
	$fdata["autoCompleteFieldsOnEdit"] = 0;
	$fdata["autoCompleteFields"] = array();
										$fdata["LinkField"]="username";
	$fdata["LinkFieldType"]=200;
	$fdata["DisplayField"]="Full Name";
				$fdata["LookupTable"]="employee_list";
	$fdata["LookupOrderBy"]="";
																			
					
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Reporting_Manager";
	
		$fdata["FullName"]= "`Reporting Manager`";
	
		
		
		
		
		
				$fdata["Index"]= 17;
				
		
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
		
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataMy_Home["Reporting Manager"]=$fdata;
//	Father / Husband Name
	$fdata = array();
	$fdata["strName"] = "Father / Husband Name";
	$fdata["ownerTable"] = "employee_list";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Father___Husband_Name";
	
		$fdata["FullName"]= "`Father / Husband Name`";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 18;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=45";
		
		$fdata["bListPage"]=true; 
	
		
		
		$fdata["bEditPage"]=true; 
	
		
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataMy_Home["Father / Husband Name"]=$fdata;
//	username
	$fdata = array();
	$fdata["strName"] = "username";
	$fdata["ownerTable"] = "employee_list";
		$fdata["Label"]="Username"; 
	
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "username";
	
		$fdata["FullName"]= "username";
	
		
		
		
		
		
				$fdata["Index"]= 19;
				$fdata["EditParams"]="";
			
		
		
		
		
		
		
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
		
		//End validation
	
				
		
				
		
		
		
			$tdataMy_Home["username"]=$fdata;

	
$tables_data["My Home"]=&$tdataMy_Home;
$field_labels["My_Home"] = &$fieldLabelsMy_Home;
$fieldToolTips["My Home"] = &$fieldToolTipsMy_Home;

// -----------------start  prepare master-details data arrays ------------------------------//
// tables which are detail tables for current table (master)
$detailsTablesData["My Home"] = array();
$dIndex = 1-1;
			$strOriginalDetailsTable="visit_register";
	$detailsTablesData["My Home"][$dIndex] = array(
		  "dDataSourceTable"=>"My Planned Visits"
		, "dOriginalTable"=>$strOriginalDetailsTable
		, "dShortTable"=>"My_Planned_Visits"
		, "masterKeys"=>array()
		, "detailKeys"=>array()
		, "dispChildCount"=> "1"
		, "hideChild"=>"0"
		, "sqlHead"=>"SELECT idvisit_register,  `Customer Name`,  `Contact Person`,  `Purpose Of Visit`,  `Date Of Visit`,  `Visit Status`,  `Employee Name`"	
		, "sqlFrom"=>"FROM visit_register"	
		, "sqlWhere"=>"(`Visit Status` =\"Planned\")"
		, "sqlTail"=>""
		, "groupBy"=>"0"
		, "previewOnList" => 1
		, "previewOnAdd" => 0
		, "previewOnEdit" => 0
		, "previewOnView" => 1
	);	
		$detailsTablesData["My Home"][$dIndex]["masterKeys"][]="username";
		$detailsTablesData["My Home"][$dIndex]["detailKeys"][]="Employee Name";

$dIndex = 2-1;
			$strOriginalDetailsTable="lead_table";
	$detailsTablesData["My Home"][$dIndex] = array(
		  "dDataSourceTable"=>"My Leads"
		, "dOriginalTable"=>$strOriginalDetailsTable
		, "dShortTable"=>"My_Leads"
		, "masterKeys"=>array()
		, "detailKeys"=>array()
		, "dispChildCount"=> "1"
		, "hideChild"=>"0"
		, "sqlHead"=>"SELECT Leadid,  `Customer Name`,  `Contact Person`,  `Lead Details`,  `Approx Closure Date`,  `Lead Status`,  `WIN / Lost Analysis`,  `Employee Name`"	
		, "sqlFrom"=>"FROM lead_table"	
		, "sqlWhere"=>"`Lead Status` = \"Suspect\" OR `Lead Status` =\"Prospect\" OR `Lead Status` =\"review\" OR `Lead Status` =\"Hot\" OR `Lead Status` =\"Commit\""
		, "sqlTail"=>""
		, "groupBy"=>"0"
		, "previewOnList" => 1
		, "previewOnAdd" => 0
		, "previewOnEdit" => 0
		, "previewOnView" => 1
	);	
		$detailsTablesData["My Home"][$dIndex]["masterKeys"][]="username";
		$detailsTablesData["My Home"][$dIndex]["detailKeys"][]="Employee Name";

$dIndex = 3-1;
			$strOriginalDetailsTable="calls";
	$detailsTablesData["My Home"][$dIndex] = array(
		  "dDataSourceTable"=>"My Calls Summary"
		, "dOriginalTable"=>$strOriginalDetailsTable
		, "dShortTable"=>"My_Calls_Summary"
		, "masterKeys"=>array()
		, "detailKeys"=>array()
		, "dispChildCount"=> "1"
		, "hideChild"=>"0"
		, "sqlHead"=>"SELECT COUNT(idCalls) AS Nos,  Date(Date) AS `Date`,  `Executive Name`,  Date(Now())-Date(Date) AS Comp"	
		, "sqlFrom"=>"FROM calls"	
		, "sqlWhere"=>"(Date(Now())-Date(Date) <30)"
		, "sqlTail"=>"GROUP BY Date(Date), `Executive Name`"
		, "groupBy"=>"1"
		, "previewOnList" => 1
		, "previewOnAdd" => 0
		, "previewOnEdit" => 0
		, "previewOnView" => 1
	);	
		$detailsTablesData["My Home"][$dIndex]["masterKeys"][]="username";
		$detailsTablesData["My Home"][$dIndex]["detailKeys"][]="Executive Name";

$dIndex = 4-1;
			$strOriginalDetailsTable="visit_register";
	$detailsTablesData["My Home"][$dIndex] = array(
		  "dDataSourceTable"=>"My Visit Summary"
		, "dOriginalTable"=>$strOriginalDetailsTable
		, "dShortTable"=>"My_Visit_Summary"
		, "masterKeys"=>array()
		, "detailKeys"=>array()
		, "dispChildCount"=> "1"
		, "hideChild"=>"0"
		, "sqlHead"=>"SELECT `Employee Name`,  Date(visit_register.`Date Of Visit`) AS `Date`,  COUNT(idvisit_register) AS Nos,  Date(Now())-Date(visit_register.`Date Of Visit`) AS comp"	
		, "sqlFrom"=>"FROM visit_register"	
		, "sqlWhere"=>"(Date(Now())-Date(visit_register.`Date Of Visit`) <30)"
		, "sqlTail"=>"GROUP BY `Employee Name`, Date(visit_register.`Date Of Visit`)"
		, "groupBy"=>"1"
		, "previewOnList" => 1
		, "previewOnAdd" => 0
		, "previewOnEdit" => 0
		, "previewOnView" => 1
	);	
		$detailsTablesData["My Home"][$dIndex]["masterKeys"][]="username";
		$detailsTablesData["My Home"][$dIndex]["detailKeys"][]="Employee Name";

$dIndex = 5-1;
			$strOriginalDetailsTable="area";
	$detailsTablesData["My Home"][$dIndex] = array(
		  "dDataSourceTable"=>"RO-Customer List Summary"
		, "dOriginalTable"=>$strOriginalDetailsTable
		, "dShortTable"=>"RO_Customer_List_Summary"
		, "masterKeys"=>array()
		, "detailKeys"=>array()
		, "dispChildCount"=> "1"
		, "hideChild"=>"0"
		, "sqlHead"=>"SELECT COUNT(idCL) AS Nos,  Region,  `Customer Status`"	
		, "sqlFrom"=>"FROM customer_list"	
		, "sqlWhere"=>""
		, "sqlTail"=>"GROUP BY Region, `Customer Status`"
		, "groupBy"=>"1"
		, "previewOnList" => 1
		, "previewOnAdd" => 0
		, "previewOnEdit" => 0
		, "previewOnView" => 1
	);	
		$detailsTablesData["My Home"][$dIndex]["masterKeys"][]="Region";
		$detailsTablesData["My Home"][$dIndex]["detailKeys"][]="Region";

$dIndex = 6-1;
			$strOriginalDetailsTable="lead_table";
	$detailsTablesData["My Home"][$dIndex] = array(
		  "dDataSourceTable"=>"SPC-Pending"
		, "dOriginalTable"=>$strOriginalDetailsTable
		, "dShortTable"=>"SPC_Pending"
		, "masterKeys"=>array()
		, "detailKeys"=>array()
		, "dispChildCount"=> "1"
		, "hideChild"=>"0"
		, "sqlHead"=>"SELECT lead_table.Leadid,  lead_table.Region,  lead_table.`Customer Name`,  lead_table.`Contact Person`,  lead_table.`Lead Details`,  lead_table.`Employee Name`,  lead_table.`Approx Closure Date`,  lead_table.`Lead Status`,  lead_table.`Manager Name`,  lead_table.`Manager Remarks`,  lead_table.`Sales Call Status`,  lead_table.`Lead Level`,  lead_table.`Requirement Details`,  lead_table.`Approx Value`,  lead_table.`First Quote Remarks`,  lead_table.`Proposed Closure Date`,  lead_table.`Projected Closure QTR`,  lead_table.`Proposed Solution Details`,  lead_table.`Quoted Price`,  lead_table.`Final Quote Remarks`,  lead_table.`Discussion Highlights`,  lead_table.`WIN / Lost Analysis`,  lead_table.`Alligned Vendor`,  COUNT(lead_bom.SPC_Status) AS SPC_Item_Count"	
		, "sqlFrom"=>"FROM lead_table  INNER JOIN lead_bom ON lead_table.Leadid = lead_bom.Lead_ID"	
		, "sqlWhere"=>"(lead_bom.SPC_Status =\"Pending\")"
		, "sqlTail"=>"GROUP BY lead_table.Leadid, lead_table.Region, lead_table.`Customer Name`, lead_table.`Contact Person`, lead_table.`Lead Details`, lead_table.`Employee Name`, lead_table.`Approx Closure Date`, lead_table.`Lead Status`, lead_table.`Manager Name`, lead_table.`Manager Remarks`, lead_table.`Sales Call Status`, lead_table.`Lead Level`, lead_table.`Requirement Details`, lead_table.`Approx Value`, lead_table.`First Quote Remarks`, lead_table.`Proposed Closure Date`, lead_table.`Projected Closure QTR`, lead_table.`Proposed Solution Details`, lead_table.`Quoted Price`, lead_table.`Final Quote Remarks`, lead_table.`Discussion Highlights`, lead_table.`WIN / Lost Analysis`, lead_table.`Alligned Vendor`"
		, "groupBy"=>"1"
		, "previewOnList" => 2
		, "previewOnAdd" => 0
		, "previewOnEdit" => 0
		, "previewOnView" => 1
	);	
		$detailsTablesData["My Home"][$dIndex]["masterKeys"][]="Region";
		$detailsTablesData["My Home"][$dIndex]["detailKeys"][]="Region";


	
// tables which are master tables for current table (detail)
$masterTablesData["My Home"] = array();

// -----------------end  prepare master-details data arrays ------------------------------//

require_once(getabspath("classes/sql.php"));










$proto512=array();
$proto512["m_strHead"] = "SELECT";
$proto512["m_strFieldList"] = "idemplist,  `Full Name`,  `Job Title`,  Address,  City,  `State`,  Country,  `Postal Code`,  `Business Phone`,  `Home Phone`,  `Mobile Phone`,  `E-Mail Address`,  Department,  Region,  `Birth Date`,  DOJ,  `Reporting Manager`,  `Father / Husband Name`,  username";
$proto512["m_strFrom"] = "FROM employee_list";
$proto512["m_strWhere"] = "";
$proto512["m_strOrderBy"] = "";
$proto512["m_strTail"] = "";
$proto513=array();
$proto513["m_sql"] = "";
$proto513["m_uniontype"] = "SQLL_UNKNOWN";
	$obj = new SQLNonParsed(array(
	"m_sql" => ""
));

$proto513["m_column"]=$obj;
$proto513["m_contained"] = array();
$proto513["m_strCase"] = "";
$proto513["m_havingmode"] = "0";
$proto513["m_inBrackets"] = "0";
$proto513["m_useAlias"] = "0";
$obj = new SQLLogicalExpr($proto513);

$proto512["m_where"] = $obj;
$proto515=array();
$proto515["m_sql"] = "";
$proto515["m_uniontype"] = "SQLL_UNKNOWN";
	$obj = new SQLNonParsed(array(
	"m_sql" => ""
));

$proto515["m_column"]=$obj;
$proto515["m_contained"] = array();
$proto515["m_strCase"] = "";
$proto515["m_havingmode"] = "0";
$proto515["m_inBrackets"] = "0";
$proto515["m_useAlias"] = "0";
$obj = new SQLLogicalExpr($proto515);

$proto512["m_having"] = $obj;
$proto512["m_fieldlist"] = array();
						$proto517=array();
			$obj = new SQLField(array(
	"m_strName" => "idemplist",
	"m_strTable" => "employee_list"
));

$proto517["m_expr"]=$obj;
$proto517["m_alias"] = "";
$obj = new SQLFieldListItem($proto517);

$proto512["m_fieldlist"][]=$obj;
						$proto519=array();
			$obj = new SQLField(array(
	"m_strName" => "Full Name",
	"m_strTable" => "employee_list"
));

$proto519["m_expr"]=$obj;
$proto519["m_alias"] = "";
$obj = new SQLFieldListItem($proto519);

$proto512["m_fieldlist"][]=$obj;
						$proto521=array();
			$obj = new SQLField(array(
	"m_strName" => "Job Title",
	"m_strTable" => "employee_list"
));

$proto521["m_expr"]=$obj;
$proto521["m_alias"] = "";
$obj = new SQLFieldListItem($proto521);

$proto512["m_fieldlist"][]=$obj;
						$proto523=array();
			$obj = new SQLField(array(
	"m_strName" => "Address",
	"m_strTable" => "employee_list"
));

$proto523["m_expr"]=$obj;
$proto523["m_alias"] = "";
$obj = new SQLFieldListItem($proto523);

$proto512["m_fieldlist"][]=$obj;
						$proto525=array();
			$obj = new SQLField(array(
	"m_strName" => "City",
	"m_strTable" => "employee_list"
));

$proto525["m_expr"]=$obj;
$proto525["m_alias"] = "";
$obj = new SQLFieldListItem($proto525);

$proto512["m_fieldlist"][]=$obj;
						$proto527=array();
			$obj = new SQLField(array(
	"m_strName" => "State",
	"m_strTable" => "employee_list"
));

$proto527["m_expr"]=$obj;
$proto527["m_alias"] = "";
$obj = new SQLFieldListItem($proto527);

$proto512["m_fieldlist"][]=$obj;
						$proto529=array();
			$obj = new SQLField(array(
	"m_strName" => "Country",
	"m_strTable" => "employee_list"
));

$proto529["m_expr"]=$obj;
$proto529["m_alias"] = "";
$obj = new SQLFieldListItem($proto529);

$proto512["m_fieldlist"][]=$obj;
						$proto531=array();
			$obj = new SQLField(array(
	"m_strName" => "Postal Code",
	"m_strTable" => "employee_list"
));

$proto531["m_expr"]=$obj;
$proto531["m_alias"] = "";
$obj = new SQLFieldListItem($proto531);

$proto512["m_fieldlist"][]=$obj;
						$proto533=array();
			$obj = new SQLField(array(
	"m_strName" => "Business Phone",
	"m_strTable" => "employee_list"
));

$proto533["m_expr"]=$obj;
$proto533["m_alias"] = "";
$obj = new SQLFieldListItem($proto533);

$proto512["m_fieldlist"][]=$obj;
						$proto535=array();
			$obj = new SQLField(array(
	"m_strName" => "Home Phone",
	"m_strTable" => "employee_list"
));

$proto535["m_expr"]=$obj;
$proto535["m_alias"] = "";
$obj = new SQLFieldListItem($proto535);

$proto512["m_fieldlist"][]=$obj;
						$proto537=array();
			$obj = new SQLField(array(
	"m_strName" => "Mobile Phone",
	"m_strTable" => "employee_list"
));

$proto537["m_expr"]=$obj;
$proto537["m_alias"] = "";
$obj = new SQLFieldListItem($proto537);

$proto512["m_fieldlist"][]=$obj;
						$proto539=array();
			$obj = new SQLField(array(
	"m_strName" => "E-Mail Address",
	"m_strTable" => "employee_list"
));

$proto539["m_expr"]=$obj;
$proto539["m_alias"] = "";
$obj = new SQLFieldListItem($proto539);

$proto512["m_fieldlist"][]=$obj;
						$proto541=array();
			$obj = new SQLField(array(
	"m_strName" => "Department",
	"m_strTable" => "employee_list"
));

$proto541["m_expr"]=$obj;
$proto541["m_alias"] = "";
$obj = new SQLFieldListItem($proto541);

$proto512["m_fieldlist"][]=$obj;
						$proto543=array();
			$obj = new SQLField(array(
	"m_strName" => "Region",
	"m_strTable" => "employee_list"
));

$proto543["m_expr"]=$obj;
$proto543["m_alias"] = "";
$obj = new SQLFieldListItem($proto543);

$proto512["m_fieldlist"][]=$obj;
						$proto545=array();
			$obj = new SQLField(array(
	"m_strName" => "Birth Date",
	"m_strTable" => "employee_list"
));

$proto545["m_expr"]=$obj;
$proto545["m_alias"] = "";
$obj = new SQLFieldListItem($proto545);

$proto512["m_fieldlist"][]=$obj;
						$proto547=array();
			$obj = new SQLField(array(
	"m_strName" => "DOJ",
	"m_strTable" => "employee_list"
));

$proto547["m_expr"]=$obj;
$proto547["m_alias"] = "";
$obj = new SQLFieldListItem($proto547);

$proto512["m_fieldlist"][]=$obj;
						$proto549=array();
			$obj = new SQLField(array(
	"m_strName" => "Reporting Manager",
	"m_strTable" => "employee_list"
));

$proto549["m_expr"]=$obj;
$proto549["m_alias"] = "";
$obj = new SQLFieldListItem($proto549);

$proto512["m_fieldlist"][]=$obj;
						$proto551=array();
			$obj = new SQLField(array(
	"m_strName" => "Father / Husband Name",
	"m_strTable" => "employee_list"
));

$proto551["m_expr"]=$obj;
$proto551["m_alias"] = "";
$obj = new SQLFieldListItem($proto551);

$proto512["m_fieldlist"][]=$obj;
						$proto553=array();
			$obj = new SQLField(array(
	"m_strName" => "username",
	"m_strTable" => "employee_list"
));

$proto553["m_expr"]=$obj;
$proto553["m_alias"] = "";
$obj = new SQLFieldListItem($proto553);

$proto512["m_fieldlist"][]=$obj;
$proto512["m_fromlist"] = array();
												$proto555=array();
$proto555["m_link"] = "SQLL_MAIN";
			$proto556=array();
$proto556["m_strName"] = "employee_list";
$proto556["m_columns"] = array();
$proto556["m_columns"][] = "idemplist";
$proto556["m_columns"][] = "Full Name";
$proto556["m_columns"][] = "Father / Husband Name";
$proto556["m_columns"][] = "Job Title";
$proto556["m_columns"][] = "Address";
$proto556["m_columns"][] = "City";
$proto556["m_columns"][] = "State";
$proto556["m_columns"][] = "Country";
$proto556["m_columns"][] = "Postal Code";
$proto556["m_columns"][] = "Business Phone";
$proto556["m_columns"][] = "Home Phone";
$proto556["m_columns"][] = "Mobile Phone";
$proto556["m_columns"][] = "E-Mail Address";
$proto556["m_columns"][] = "Notes";
$proto556["m_columns"][] = "Department";
$proto556["m_columns"][] = "Region";
$proto556["m_columns"][] = "Birth Date";
$proto556["m_columns"][] = "DOJ";
$proto556["m_columns"][] = "username";
$proto556["m_columns"][] = "password";
$proto556["m_columns"][] = "Userlevel";
$proto556["m_columns"][] = "Reporting Manager";
$proto556["m_columns"][] = "LOGIN_LOGS";
$obj = new SQLTable($proto556);

$proto555["m_table"] = $obj;
$proto555["m_alias"] = "";
$proto557=array();
$proto557["m_sql"] = "";
$proto557["m_uniontype"] = "SQLL_UNKNOWN";
	$obj = new SQLNonParsed(array(
	"m_sql" => ""
));

$proto557["m_column"]=$obj;
$proto557["m_contained"] = array();
$proto557["m_strCase"] = "";
$proto557["m_havingmode"] = "0";
$proto557["m_inBrackets"] = "0";
$proto557["m_useAlias"] = "0";
$obj = new SQLLogicalExpr($proto557);

$proto555["m_joinon"] = $obj;
$obj = new SQLFromListItem($proto555);

$proto512["m_fromlist"][]=$obj;
$proto512["m_groupby"] = array();
$proto512["m_orderby"] = array();
$obj = new SQLQuery($proto512);

$queryData_My_Home = $obj;
$tdataMy_Home[".sqlquery"] = $queryData_My_Home;

include(getabspath("include/My_Home_events.php"));
$tableEvents["My Home"] = new eventclass_My_Home;

?>
