<?php
$tdataContact_Details=array();
	$tdataContact_Details[".NumberOfChars"]=80; 
	$tdataContact_Details[".ShortName"]="Contact_Details";
	$tdataContact_Details[".OwnerID"]="";
	$tdataContact_Details[".OriginalTable"]="cust_list_contact_person";


	
//	field labels
$fieldLabelsContact_Details = array();
if(mlang_getcurrentlang()=="English")
{
	$fieldLabelsContact_Details["English"]=array();
	$fieldToolTipsContact_Details["English"]=array();
	$fieldLabelsContact_Details["English"]["idCLCP"] = "Id CLCP";
	$fieldToolTipsContact_Details["English"]["idCLCP"] = "";
	$fieldLabelsContact_Details["English"]["Name"] = "Name";
	$fieldToolTipsContact_Details["English"]["Name"] = "";
	$fieldLabelsContact_Details["English"]["Job_Title"] = "Job Title";
	$fieldToolTipsContact_Details["English"]["Job Title"] = "";
	$fieldLabelsContact_Details["English"]["Phone__Direct"] = "Phone- Direct";
	$fieldToolTipsContact_Details["English"]["Phone- Direct"] = "";
	$fieldLabelsContact_Details["English"]["Phone_Extn"] = "Phone Extn";
	$fieldToolTipsContact_Details["English"]["Phone Extn"] = "";
	$fieldLabelsContact_Details["English"]["Mobile"] = "Mobile";
	$fieldToolTipsContact_Details["English"]["Mobile"] = "";
	$fieldLabelsContact_Details["English"]["E_Mail"] = "E-Mail";
	$fieldToolTipsContact_Details["English"]["E-Mail"] = "";
	$fieldLabelsContact_Details["English"]["Notes"] = "Notes";
	$fieldToolTipsContact_Details["English"]["Notes"] = "";
	$fieldLabelsContact_Details["English"]["Company_Name"] = "Company Name";
	$fieldToolTipsContact_Details["English"]["Company Name"] = "";
	if (count($fieldToolTipsContact_Details["English"])){
		$tdataContact_Details[".isUseToolTips"]=true;
	}
}


	
	$tdataContact_Details[".NCSearch"]=true;

	

$tdataContact_Details[".shortTableName"] = "Contact_Details";
$tdataContact_Details[".nSecOptions"] = 0;
$tdataContact_Details[".recsPerRowList"] = 1;	
$tdataContact_Details[".tableGroupBy"] = "0";
$tdataContact_Details[".mainTableOwnerID"] = "";
$tdataContact_Details[".moveNext"] = 1;




$tdataContact_Details[".showAddInPopup"] = false;

$tdataContact_Details[".showEditInPopup"] = false;

$tdataContact_Details[".showViewInPopup"] = false;


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

$tdataContact_Details[".listAjax"] = false;

	$tdataContact_Details[".audit"] = false;

	$tdataContact_Details[".locking"] = false;
	
$tdataContact_Details[".listIcons"] = true;
$tdataContact_Details[".inlineEdit"] = true;
$tdataContact_Details[".view"] = true;




$tdataContact_Details[".showSimpleSearchOptions"] = false;

$tdataContact_Details[".showSearchPanel"] = true;


$tdataContact_Details[".isUseAjaxSuggest"] = true;

$tdataContact_Details[".rowHighlite"] = true;


// button handlers file names

$tdataContact_Details[".addPageEvents"] = false;

$tdataContact_Details[".arrKeyFields"][] = "idCLCP";

// use datepicker for search panel
$tdataContact_Details[".isUseCalendarForSearch"] = false;

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

$tdataContact_Details[".isUseiBox"] = false;



$tdataContact_Details[".isUseInlineAdd"] = true;

$tdataContact_Details[".isUseInlineEdit"] = true;
$tdataContact_Details[".isUseInlineJs"] = $tdataContact_Details[".isUseInlineAdd"] || $tdataContact_Details[".isUseInlineEdit"];

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

$tdataContact_Details[".globSearchFields"][] = "idCLCP";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("idCLCP", $tdataContact_Details[".allSearchFields"]))
{
	$tdataContact_Details[".allSearchFields"][] = "idCLCP";	
}
$tdataContact_Details[".globSearchFields"][] = "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("Name", $tdataContact_Details[".allSearchFields"]))
{
	$tdataContact_Details[".allSearchFields"][] = "Name";	
}
$tdataContact_Details[".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", $tdataContact_Details[".allSearchFields"]))
{
	$tdataContact_Details[".allSearchFields"][] = "Job Title";	
}
$tdataContact_Details[".globSearchFields"][] = "Phone- Direct";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Phone- Direct", $tdataContact_Details[".allSearchFields"]))
{
	$tdataContact_Details[".allSearchFields"][] = "Phone- Direct";	
}
$tdataContact_Details[".globSearchFields"][] = "Phone Extn";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Phone Extn", $tdataContact_Details[".allSearchFields"]))
{
	$tdataContact_Details[".allSearchFields"][] = "Phone Extn";	
}
$tdataContact_Details[".globSearchFields"][] = "Mobile";
// 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", $tdataContact_Details[".allSearchFields"]))
{
	$tdataContact_Details[".allSearchFields"][] = "Mobile";	
}
$tdataContact_Details[".globSearchFields"][] = "E-Mail";
// 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", $tdataContact_Details[".allSearchFields"]))
{
	$tdataContact_Details[".allSearchFields"][] = "E-Mail";	
}
$tdataContact_Details[".globSearchFields"][] = "Notes";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Notes", $tdataContact_Details[".allSearchFields"]))
{
	$tdataContact_Details[".allSearchFields"][] = "Notes";	
}
$tdataContact_Details[".globSearchFields"][] = "Company 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("Company Name", $tdataContact_Details[".allSearchFields"]))
{
	$tdataContact_Details[".allSearchFields"][] = "Company Name";	
}


$tdataContact_Details[".googleLikeFields"][] = "idCLCP";
$tdataContact_Details[".googleLikeFields"][] = "Name";
$tdataContact_Details[".googleLikeFields"][] = "Job Title";
$tdataContact_Details[".googleLikeFields"][] = "Phone- Direct";
$tdataContact_Details[".googleLikeFields"][] = "Phone Extn";
$tdataContact_Details[".googleLikeFields"][] = "Mobile";
$tdataContact_Details[".googleLikeFields"][] = "E-Mail";
$tdataContact_Details[".googleLikeFields"][] = "Notes";
$tdataContact_Details[".googleLikeFields"][] = "Company Name";



$tdataContact_Details[".advSearchFields"][] = "idCLCP";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("idCLCP", $tdataContact_Details[".allSearchFields"])) 
{
	$tdataContact_Details[".allSearchFields"][] = "idCLCP";	
}
$tdataContact_Details[".advSearchFields"][] = "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("Name", $tdataContact_Details[".allSearchFields"])) 
{
	$tdataContact_Details[".allSearchFields"][] = "Name";	
}
$tdataContact_Details[".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", $tdataContact_Details[".allSearchFields"])) 
{
	$tdataContact_Details[".allSearchFields"][] = "Job Title";	
}
$tdataContact_Details[".advSearchFields"][] = "Phone- Direct";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Phone- Direct", $tdataContact_Details[".allSearchFields"])) 
{
	$tdataContact_Details[".allSearchFields"][] = "Phone- Direct";	
}
$tdataContact_Details[".advSearchFields"][] = "Phone Extn";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Phone Extn", $tdataContact_Details[".allSearchFields"])) 
{
	$tdataContact_Details[".allSearchFields"][] = "Phone Extn";	
}
$tdataContact_Details[".advSearchFields"][] = "Mobile";
// 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", $tdataContact_Details[".allSearchFields"])) 
{
	$tdataContact_Details[".allSearchFields"][] = "Mobile";	
}
$tdataContact_Details[".advSearchFields"][] = "E-Mail";
// 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", $tdataContact_Details[".allSearchFields"])) 
{
	$tdataContact_Details[".allSearchFields"][] = "E-Mail";	
}
$tdataContact_Details[".advSearchFields"][] = "Notes";
// do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
if (!in_array("Notes", $tdataContact_Details[".allSearchFields"])) 
{
	$tdataContact_Details[".allSearchFields"][] = "Notes";	
}
$tdataContact_Details[".advSearchFields"][] = "Company 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("Company Name", $tdataContact_Details[".allSearchFields"])) 
{
	$tdataContact_Details[".allSearchFields"][] = "Company Name";	
}

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


	

$tdataContact_Details[".isDisplayLoading"] = true;

$tdataContact_Details[".isResizeColumns"] = false;





$tdataContact_Details[".pageSize"] = 5;

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

$tdataContact_Details[".sqlHead"] = "SELECT idCLCP,  Name,  `Job Title`,  `Phone- Direct`,  `Phone Extn`,  Mobile,  `E-Mail`,  Notes,  `Company Name`";
$tdataContact_Details[".sqlFrom"] = "FROM cust_list_contact_person";
$tdataContact_Details[".sqlWhereExpr"] = "";
$tdataContact_Details[".sqlTail"] = "";




//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;
$tdataContact_Details[".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;
$tdataContact_Details[".arrGroupsPerPage"] = $arrGPP;

	$tableKeys = array();
	$tableKeys[] = "idCLCP";
	$tdataContact_Details[".Keys"] = $tableKeys;

//	idCLCP
	$fdata = array();
	$fdata["strName"] = "idCLCP";
	$fdata["ownerTable"] = "cust_list_contact_person";
		$fdata["Label"]="Id CLCP"; 
	
		
		
	$fdata["FieldType"]= 3;
	
		$fdata["AutoInc"]=true;
	
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "idCLCP";
	
		$fdata["FullName"]= "idCLCP";
	
		$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;
	
		
				
		
		
		
			$tdataContact_Details["idCLCP"]=$fdata;
//	Name
	$fdata = array();
	$fdata["strName"] = "Name";
	$fdata["ownerTable"] = "cust_list_contact_person";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Name";
	
		$fdata["FullName"]= "Name";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 2;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=45";
		
		$fdata["bListPage"]=true; 
	
		$fdata["bAddPage"]=true; 
	
		$fdata["bInlineAdd"]=true; 
	
		
		$fdata["bInlineEdit"]=true; 
	
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataContact_Details["Name"]=$fdata;
//	Job Title
	$fdata = array();
	$fdata["strName"] = "Job Title";
	$fdata["ownerTable"] = "cust_list_contact_person";
		
		
		
	$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["bAddPage"]=true; 
	
		$fdata["bInlineAdd"]=true; 
	
		
		$fdata["bInlineEdit"]=true; 
	
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataContact_Details["Job Title"]=$fdata;
//	Phone- Direct
	$fdata = array();
	$fdata["strName"] = "Phone- Direct";
	$fdata["ownerTable"] = "cust_list_contact_person";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Phone__Direct";
	
		$fdata["FullName"]= "`Phone- Direct`";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 4;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=45";
		
		$fdata["bListPage"]=true; 
	
		$fdata["bAddPage"]=true; 
	
		$fdata["bInlineAdd"]=true; 
	
		
		$fdata["bInlineEdit"]=true; 
	
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataContact_Details["Phone- Direct"]=$fdata;
//	Phone Extn
	$fdata = array();
	$fdata["strName"] = "Phone Extn";
	$fdata["ownerTable"] = "cust_list_contact_person";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Phone_Extn";
	
		$fdata["FullName"]= "`Phone Extn`";
	
		
		
		
		
		
				$fdata["Index"]= 5;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=45";
		
		$fdata["bListPage"]=true; 
	
		$fdata["bAddPage"]=true; 
	
		$fdata["bInlineAdd"]=true; 
	
		
		$fdata["bInlineEdit"]=true; 
	
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
		
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataContact_Details["Phone Extn"]=$fdata;
//	Mobile
	$fdata = array();
	$fdata["strName"] = "Mobile";
	$fdata["ownerTable"] = "cust_list_contact_person";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Mobile";
	
		$fdata["FullName"]= "Mobile";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 6;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=45";
		
		$fdata["bListPage"]=true; 
	
		$fdata["bAddPage"]=true; 
	
		$fdata["bInlineAdd"]=true; 
	
		
		$fdata["bInlineEdit"]=true; 
	
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataContact_Details["Mobile"]=$fdata;
//	E-Mail
	$fdata = array();
	$fdata["strName"] = "E-Mail";
	$fdata["ownerTable"] = "cust_list_contact_person";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "E_Mail";
	
		$fdata["FullName"]= "`E-Mail`";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 7;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=45";
		
		$fdata["bListPage"]=true; 
	
		$fdata["bAddPage"]=true; 
	
		$fdata["bInlineAdd"]=true; 
	
		
		$fdata["bInlineEdit"]=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;
	
		
				
		
		
		
			$tdataContact_Details["E-Mail"]=$fdata;
//	Notes
	$fdata = array();
	$fdata["strName"] = "Notes";
	$fdata["ownerTable"] = "cust_list_contact_person";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text area";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Notes";
	
		$fdata["FullName"]= "Notes";
	
		$fdata["IsRequired"]=true; 
	
		
		
		
		
				$fdata["Index"]= 8;
			$fdata["EditParams"] = "";
			$fdata["EditParams"].= " rows=100";
		$fdata["nRows"] = 100;
			$fdata["EditParams"].= " cols=200";
		$fdata["nCols"] = 200;
		
		$fdata["bListPage"]=true; 
	
		$fdata["bAddPage"]=true; 
	
		$fdata["bInlineAdd"]=true; 
	
		
		$fdata["bInlineEdit"]=true; 
	
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
						$fdata["validateAs"]["basicValidate"][] = "IsRequired";
	
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataContact_Details["Notes"]=$fdata;
//	Company Name
	$fdata = array();
	$fdata["strName"] = "Company Name";
	$fdata["ownerTable"] = "cust_list_contact_person";
		
		
		
	$fdata["FieldType"]= 200;
	
		
			$fdata["UseiBox"] = false;
	
	$fdata["EditFormat"]= "Text field";
	$fdata["ViewFormat"]= "";
	
		
		
		
		
		$fdata["NeedEncode"]=true;
	
	$fdata["GoodName"]= "Company_Name";
	
		$fdata["FullName"]= "`Company Name`";
	
		
		
		
		
		
				$fdata["Index"]= 9;
				$fdata["EditParams"]="";
			$fdata["EditParams"].= " maxlength=100";
		
		$fdata["bListPage"]=true; 
	
		$fdata["bAddPage"]=true; 
	
		$fdata["bInlineAdd"]=true; 
	
		
		$fdata["bInlineEdit"]=true; 
	
		$fdata["bViewPage"]=true; 
	
		$fdata["bAdvancedSearch"]=true; 
	
		
		
	//Begin validation
	$fdata["validateAs"] = array();
		
		//End validation
	
				$fdata["FieldPermissions"]=true;
	
		
				
		
		
		
			$tdataContact_Details["Company Name"]=$fdata;

	
$tables_data["Contact Details"]=&$tdataContact_Details;
$field_labels["Contact_Details"] = &$fieldLabelsContact_Details;
$fieldToolTips["Contact Details"] = &$fieldToolTipsContact_Details;

// -----------------start  prepare master-details data arrays ------------------------------//
// tables which are detail tables for current table (master)
$detailsTablesData["Contact Details"] = array();

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

$mIndex = 1-1;
			$strOriginalDetailsTable="customer_list";
	$masterTablesData["Contact Details"][$mIndex] = array(
		  "mDataSourceTable"=>"Pending Customers"
		, "mOriginalTable" => $strOriginalDetailsTable
		, "mShortTable" => "Pending_Customers"
		, "masterKeys" => array()
		, "detailKeys" => array()
		, "dispChildCount" => "1"
		, "hideChild" => "0"	
		, "dispInfo" => "1"								
		, "previewOnList" => 1
		, "previewOnAdd" => 0
		, "previewOnEdit" => 1
		, "previewOnView" => 1
	);	
		$masterTablesData["Contact Details"][$mIndex]["masterKeys"][]="Customer Name";
		$masterTablesData["Contact Details"][$mIndex]["detailKeys"][]="Company Name";

$mIndex = 2-1;
			$strOriginalDetailsTable="customer_list";
	$masterTablesData["Contact Details"][$mIndex] = array(
		  "mDataSourceTable"=>"List Management"
		, "mOriginalTable" => $strOriginalDetailsTable
		, "mShortTable" => "List_Management"
		, "masterKeys" => array()
		, "detailKeys" => array()
		, "dispChildCount" => "1"
		, "hideChild" => "0"	
		, "dispInfo" => "1"								
		, "previewOnList" => 0
		, "previewOnAdd" => 0
		, "previewOnEdit" => 0
		, "previewOnView" => 1
	);	
		$masterTablesData["Contact Details"][$mIndex]["masterKeys"][]="Customer Name";
		$masterTablesData["Contact Details"][$mIndex]["detailKeys"][]="Company Name";

$mIndex = 3-1;
			$strOriginalDetailsTable="customer_list";
	$masterTablesData["Contact Details"][$mIndex] = array(
		  "mDataSourceTable"=>"Review List"
		, "mOriginalTable" => $strOriginalDetailsTable
		, "mShortTable" => "Review_List"
		, "masterKeys" => array()
		, "detailKeys" => array()
		, "dispChildCount" => "1"
		, "hideChild" => "0"	
		, "dispInfo" => "1"								
		, "previewOnList" => 1
		, "previewOnAdd" => 0
		, "previewOnEdit" => 1
		, "previewOnView" => 1
	);	
		$masterTablesData["Contact Details"][$mIndex]["masterKeys"][]="Customer Name";
		$masterTablesData["Contact Details"][$mIndex]["detailKeys"][]="Company Name";

$mIndex = 4-1;
			$strOriginalDetailsTable="customer_list";
	$masterTablesData["Contact Details"][$mIndex] = array(
		  "mDataSourceTable"=>"Inactive customer_list"
		, "mOriginalTable" => $strOriginalDetailsTable
		, "mShortTable" => "Inactive_customer_list"
		, "masterKeys" => array()
		, "detailKeys" => array()
		, "dispChildCount" => "1"
		, "hideChild" => "0"	
		, "dispInfo" => "1"								
		, "previewOnList" => 0
		, "previewOnAdd" => 0
		, "previewOnEdit" => 0
		, "previewOnView" => 1
	);	
		$masterTablesData["Contact Details"][$mIndex]["masterKeys"][]="Customer Name";
		$masterTablesData["Contact Details"][$mIndex]["detailKeys"][]="Company Name";

$mIndex = 5-1;
			$strOriginalDetailsTable="customer_list";
	$masterTablesData["Contact Details"][$mIndex] = array(
		  "mDataSourceTable"=>"Short-Listed Customers"
		, "mOriginalTable" => $strOriginalDetailsTable
		, "mShortTable" => "Short_Listed_Customers"
		, "masterKeys" => array()
		, "detailKeys" => array()
		, "dispChildCount" => "1"
		, "hideChild" => "0"	
		, "dispInfo" => "1"								
		, "previewOnList" => 0
		, "previewOnAdd" => 0
		, "previewOnEdit" => 1
		, "previewOnView" => 1
	);	
		$masterTablesData["Contact Details"][$mIndex]["masterKeys"][]="Customer Name";
		$masterTablesData["Contact Details"][$mIndex]["detailKeys"][]="Company Name";

$mIndex = 6-1;
			$strOriginalDetailsTable="customer_list";
	$masterTablesData["Contact Details"][$mIndex] = array(
		  "mDataSourceTable"=>"Active Customers"
		, "mOriginalTable" => $strOriginalDetailsTable
		, "mShortTable" => "Active_Customers"
		, "masterKeys" => array()
		, "detailKeys" => array()
		, "dispChildCount" => "1"
		, "hideChild" => "0"	
		, "dispInfo" => "1"								
		, "previewOnList" => 1
		, "previewOnAdd" => 0
		, "previewOnEdit" => 1
		, "previewOnView" => 1
	);	
		$masterTablesData["Contact Details"][$mIndex]["masterKeys"][]="Customer Name";
		$masterTablesData["Contact Details"][$mIndex]["detailKeys"][]="Company Name";

$mIndex = 7-1;
			$strOriginalDetailsTable="customer_list";
	$masterTablesData["Contact Details"][$mIndex] = array(
		  "mDataSourceTable"=>"Potential Customer List"
		, "mOriginalTable" => $strOriginalDetailsTable
		, "mShortTable" => "Potential_Customer_List"
		, "masterKeys" => array()
		, "detailKeys" => array()
		, "dispChildCount" => "1"
		, "hideChild" => "0"	
		, "dispInfo" => "1"								
		, "previewOnList" => 1
		, "previewOnAdd" => 0
		, "previewOnEdit" => 0
		, "previewOnView" => 1
	);	
		$masterTablesData["Contact Details"][$mIndex]["masterKeys"][]="Customer Name";
		$masterTablesData["Contact Details"][$mIndex]["detailKeys"][]="Company Name";

$mIndex = 8-1;
			$strOriginalDetailsTable="vendor_list";
	$masterTablesData["Contact Details"][$mIndex] = array(
		  "mDataSourceTable"=>"Vendor Details"
		, "mOriginalTable" => $strOriginalDetailsTable
		, "mShortTable" => "Vendor_Details"
		, "masterKeys" => array()
		, "detailKeys" => array()
		, "dispChildCount" => "1"
		, "hideChild" => "0"	
		, "dispInfo" => "1"								
		, "previewOnList" => 0
		, "previewOnAdd" => 0
		, "previewOnEdit" => 1
		, "previewOnView" => 1
	);	
		$masterTablesData["Contact Details"][$mIndex]["masterKeys"][]="Vendor Name";
		$masterTablesData["Contact Details"][$mIndex]["detailKeys"][]="Company Name";

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

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










$proto793=array();
$proto793["m_strHead"] = "SELECT";
$proto793["m_strFieldList"] = "idCLCP,  Name,  `Job Title`,  `Phone- Direct`,  `Phone Extn`,  Mobile,  `E-Mail`,  Notes,  `Company Name`";
$proto793["m_strFrom"] = "FROM cust_list_contact_person";
$proto793["m_strWhere"] = "";
$proto793["m_strOrderBy"] = "";
$proto793["m_strTail"] = "";
$proto794=array();
$proto794["m_sql"] = "";
$proto794["m_uniontype"] = "SQLL_UNKNOWN";
	$obj = new SQLNonParsed(array(
	"m_sql" => ""
));

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

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

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

$proto793["m_having"] = $obj;
$proto793["m_fieldlist"] = array();
						$proto798=array();
			$obj = new SQLField(array(
	"m_strName" => "idCLCP",
	"m_strTable" => "cust_list_contact_person"
));

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

$proto793["m_fieldlist"][]=$obj;
						$proto800=array();
			$obj = new SQLField(array(
	"m_strName" => "Name",
	"m_strTable" => "cust_list_contact_person"
));

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

$proto793["m_fieldlist"][]=$obj;
						$proto802=array();
			$obj = new SQLField(array(
	"m_strName" => "Job Title",
	"m_strTable" => "cust_list_contact_person"
));

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

$proto793["m_fieldlist"][]=$obj;
						$proto804=array();
			$obj = new SQLField(array(
	"m_strName" => "Phone- Direct",
	"m_strTable" => "cust_list_contact_person"
));

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

$proto793["m_fieldlist"][]=$obj;
						$proto806=array();
			$obj = new SQLField(array(
	"m_strName" => "Phone Extn",
	"m_strTable" => "cust_list_contact_person"
));

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

$proto793["m_fieldlist"][]=$obj;
						$proto808=array();
			$obj = new SQLField(array(
	"m_strName" => "Mobile",
	"m_strTable" => "cust_list_contact_person"
));

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

$proto793["m_fieldlist"][]=$obj;
						$proto810=array();
			$obj = new SQLField(array(
	"m_strName" => "E-Mail",
	"m_strTable" => "cust_list_contact_person"
));

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

$proto793["m_fieldlist"][]=$obj;
						$proto812=array();
			$obj = new SQLField(array(
	"m_strName" => "Notes",
	"m_strTable" => "cust_list_contact_person"
));

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

$proto793["m_fieldlist"][]=$obj;
						$proto814=array();
			$obj = new SQLField(array(
	"m_strName" => "Company Name",
	"m_strTable" => "cust_list_contact_person"
));

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

$proto793["m_fieldlist"][]=$obj;
$proto793["m_fromlist"] = array();
												$proto816=array();
$proto816["m_link"] = "SQLL_MAIN";
			$proto817=array();
$proto817["m_strName"] = "cust_list_contact_person";
$proto817["m_columns"] = array();
$proto817["m_columns"][] = "idCLCP";
$proto817["m_columns"][] = "Name";
$proto817["m_columns"][] = "Job Title";
$proto817["m_columns"][] = "Phone- Direct";
$proto817["m_columns"][] = "Phone Extn";
$proto817["m_columns"][] = "Mobile";
$proto817["m_columns"][] = "E-Mail";
$proto817["m_columns"][] = "Notes";
$proto817["m_columns"][] = "Company Name";
$obj = new SQLTable($proto817);

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

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

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

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

$queryData_Contact_Details = $obj;
$tdataContact_Details[".sqlquery"] = $queryData_Contact_Details;

$tableEvents["Contact Details"] = new eventsBase;

?>
