var gaDocType = new Array()
var nSelectedDocTypeIndex = 0;
var searchingWin = null;

function oDocType(){
	this.EntityNum = null
	this.DocName = null
	this.TableName = null
	this.TFields = null
	this.TLabel1 = null
	this.TLabel2 = null
	this.TLabel3 = null
	this.FValue1 = null
	this.FValue2 = null
	this.FValue3 = null
	this.Sql = null
	this.Sql1 = null
	this.Sql2 = null
	this.Sql3 = null
	this.SortBy = null
	this.GetSqlQry = buildSql
	// these members are for spatial search only
	this.bSelected = false;
	this.dblPagePrice = 2.35;	// set this price to -1 if not for sale
	this.nShownInSite = 2;		// shown in which site, 0 - intranet, 1 - internet, 2 - both
	this.nSearchType = 2;		// 0 - by type, 1 - by shape, 2 - both
}

	var oDoc = new oDocType()
	oDoc.EntityNum = "99"; //"10922" //Tract Maps
	oDoc.DocName = "Tract Maps"
	oDoc.TableName = "tract_map"; //"tract_map_record"
	oDoc.TLabel1 = "Tract Number or Name"
	oDoc.TLabel2 = "Book/Page"
	oDoc.FValue1 = "TR "
	oDoc.Sql = "SELECT MSLINK, TRACTNUM, BPNUM FROM "+oDoc.TableName+" "
	oDoc.Sql1 = "TRACTNUM LIKE '%"
	oDoc.Sql2 = "BPNUM LIKE '%"
	oDoc.Sql0 = "SELECT MSLINK, TRACTNUM, BPNUM FROM "+oDoc.TableName+" WHERE TRACTNUM = '' AND BPNUM = ''"
	oDoc.SortBy = " ORDER BY TRACTNUM"
	gaDocType[gaDocType.length] = oDoc
	
	var oDoc = new oDocType()
	oDoc.EntityNum = "97"; //"10939" //Tract Improvement Plans
	oDoc.DocName = "Tract Improvement Plans"
	oDoc.TableName = "tract_impr"; //"tract_imp_record"
	oDoc.TLabel1 = "Tract Number or Name"
	oDoc.TLabel2 = "Developer"
	oDoc.FValue1 = "TR " //TRIMPNUM -> TRACTNUM
	oDoc.Sql = "SELECT MSLINK, TRACTNUM, DEVELOPER FROM "+oDoc.TableName+" "
	oDoc.Sql1 = "TRACTNUM LIKE '%"
	oDoc.Sql2 = "DEVELOPER LIKE '%"
	oDoc.Sql0 = "SELECT MSLINK, TRACTNUM, DEVELOPER FROM "+oDoc.TableName+" WHERE TRACTNUM = '' AND DEVELOPER = ''"
	oDoc.SortBy = " ORDER BY TRACTNUM"
	
	
	gaDocType[gaDocType.length] = oDoc
	
	var oDoc = new oDocType()
	oDoc.EntityNum = "86"; //"10909" //Parcel Maps
	oDoc.DocName = "Parcel Maps"
	oDoc.TableName = "parcel_map" //"parcel_map_record"
	oDoc.TLabel1 = "BPNUM" //"PMB"
	oDoc.TLabel2 = "Parcel Map Number"
	oDoc.FValue1 = "PMB " //"BPNUM"
	oDoc.FValue2 = "PM " 
	oDoc.Sql = "SELECT MSLINK, BPNUM, PMNUM FROM "+oDoc.TableName+" " //PMB
	oDoc.Sql1 = "BPNUM LIKE '%" //PMB
	oDoc.Sql2 = "PMNUM LIKE '%"
	oDoc.Sql0 = "SELECT MSLINK, BPNUM, PMNUM FROM "+oDoc.TableName+" WHERE BPNUM = '' AND PMNUM = ''" //PMB
	oDoc.SortBy = " ORDER BY BPNUM" //PMB
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "76"; //"10899" //Certificates of Compliance
	oDoc.DocName = "Certificates of Compliance"
	oDoc.TableName = "CERT_COMP"; //"ctf_comp_record"
	oDoc.TLabel1 = "Official Number"
	oDoc.TLabel2 = "COC Number"
	oDoc.FValue1 = ""
	oDoc.Sql = "SELECT MSLINK, ORNUM, COCNUM FROM "+oDoc.TableName+" "
	oDoc.Sql1 = "ORNUM LIKE '%"
	oDoc.Sql2 = "COCNUM LIKE '%"
	oDoc.Sql0 = "SELECT MSLINK, ORNUM, COCNUM FROM "+oDoc.TableName+" WHERE ORNUM = '' AND COCNUM = ''"
	oDoc.SortBy = " ORDER BY ORNUM"
	oDoc.dblPagePrice = 0.15
	//gaDocType[gaDocType.length] = oDoc //090911 comment out as per Dennis' request

	var oDoc = new oDocType()
	oDoc.EntityNum = "77"; //"10900" //Certificates of Correction
	oDoc.DocName = "Certificates of Correction"
	oDoc.TableName = "cert_corr"; //"ctf_crt_record"
	oDoc.TLabel1 = "OR Number"
	oDoc.TLabel2 = "Original Document Name"
	oDoc.FValue1 = ""
	oDoc.Sql = "SELECT MSLINK, CCNUM, MAPNUM FROM "+oDoc.TableName+" " //ORIDOCNAME -> MAPNUM
	oDoc.Sql1 = "CCNUM LIKE '%"
	oDoc.Sql2 = "MAPNUM LIKE '%"
	oDoc.Sql0 = "SELECT MSLINK, CCNUM, MAPNUM FROM "+oDoc.TableName+" WHERE CCNUM = '' AND MAPNUM = ''"
	oDoc.SortBy = " ORDER BY CCNUM"
	oDoc.dblPagePrice = 0.15
	oDoc.nSearchType = 0;	// by type only 
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "10895" //Bridge Plans
	oDoc.DocName =  "Bridge Plans"
	oDoc.TableName = "BRIDGE_AND_TUNNEL"; //"bridge_pl_record"
	oDoc.TLabel1 = "Bridge Plan Number"
	oDoc.TLabel2 = "Street Name"
	oDoc.TLabel3 = "Waterway Name"
	oDoc.FValue1 = "BRIDGE "
	oDoc.Sql = "SELECT MSLINK, BPNUM, STREET_NAME, WATERWAY_NAME FROM "+oDoc.TableName+" "
	oDoc.Sql1 = "BPNUM LIKE '%"
	oDoc.Sql2 = "STREET_NAME LIKE '%"
	oDoc.Sql3 = "WATERWAY_NAME LIKE '%"
	oDoc.Sql0 = "SELECT MSLINK, BPNUM, STREET_NAME, WATERWAY_NAME FROM "+oDoc.TableName+" WHERE BPNUM = '' AND STREET_NAME = '' AND WATERWAY_NAME = ''"
	oDoc.SortBy = " ORDER BY BPNUM"
	//090827 //gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "79"; //"10898" //County Surveyor Tie Books
	oDoc.DocName = "County Surveyor Tie Books"
	oDoc.TableName = "CSTB"; //"County_surveyor_tie_books_image_cstb_image"
	oDoc.TLabel1 = "County Surveyor Tie Book/Pages"
	oDoc.FValue1 = "CSTB "
	oDoc.Sql = "SELECT MSLINK, BPNUM FROM "+oDoc.TableName+" " //CSTBB -> BPNUM
	oDoc.Sql1 = "BPNUM LIKE '%"
	oDoc.Sql0 = "SELECT MSLINK, BPNUM FROM "+oDoc.TableName+" WHERE BPNUM = ''"
	oDoc.SortBy = " ORDER BY BPNUM"
	oDoc.dblPagePrice = 0.15
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "81"; //"10902" //G.P.S Monument Records
	oDoc.DocName = "G.P.S Monument Records"
	oDoc.TableName = "gps_monum"; //"gps_monum_record"
	oDoc.TLabel1 = "GPS Number"
	oDoc.FValue1 = "GPS "
	oDoc.Sql = "SELECT MSLINK, GPSNUM FROM "+oDoc.TableName+" "
	oDoc.Sql1 = "GPSNUM LIKE '%"
	oDoc.Sql0 = "SELECT MSLINK, GPSNUM FROM "+oDoc.TableName+" WHERE GPSNUM = ''"
	oDoc.SortBy = " ORDER BY GPSNUM"
	oDoc.dblPagePrice = 0.15
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "82"; //"10905" //Lot Line Adjustments
	oDoc.DocName = "Lot Line Adjustments"
	oDoc.TableName = "ll_adjm"; //"ll_adjm_record"
	oDoc.TLabel1 = "Lotline Number"
	oDoc.TLabel2 = "Official Number"
	oDoc.FValue1 = "LL "
	oDoc.Sql = "SELECT MSLINK, ORNUM, LLNUM FROM "+oDoc.TableName+" "
	oDoc.Sql1 = "LLNUM LIKE '%"
	oDoc.Sql2 = "ORNUM LIKE '%"
	oDoc.Sql0 = "SELECT MSLINK, ORNUM, LLNUM FROM "+oDoc.TableName+" WHERE LLNUM = '' AND ORNUM = ''"
	oDoc.SortBy = " ORDER BY ORNUM"
	oDoc.dblPagePrice = 0.15
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "70"; //"10907" //Alignment Notes
	oDoc.DocName = "Alignment Notes"
	//hw090715
	/*
	oDoc.TableName = "OCS_alignment_notes_image_ocs_alignmn" 
	oDoc.TLabel1 = "Alignment Book/Pages"
	oDoc.TLabel2 = "Tract Number"
	oDoc.FValue1 = "SW-IRV "
	oDoc.Sql = "SELECT MSLINK, ALIGNMENTB, TRACTNUM FROM "+oDoc.TableName+" "
	oDoc.Sql1 = "ALIGNMENTB LIKE '%"
	oDoc.Sql2 = "TRACTNUM LIKE '%"
	oDoc.Sql0 = "SELECT MSLINK, ALIGNMENTB, TRACTNUM FROM "+oDoc.TableName+" WHERE ALIGNMENTB = '' AND TRACTNUM = ''"
	oDoc.SortBy = " ORDER BY ALIGNMENTB"
	*/
	oDoc.TableName = "ALIGNMENT_NOTES"
	oDoc.TLabel1 = "Tract Number"
	oDoc.TLabel2 = "Alignment Book/Pages"
	oDoc.FValue1 = "TR "
	oDoc.Sql = "SELECT MSLINK, MAPNUM, BPNUM FROM "+oDoc.TableName+" "
	oDoc.Sql1 = "MAPNUM LIKE '%"
	oDoc.Sql2 = "BPNUM LIKE '%"
	oDoc.Sql0 = "SELECT MSLINK, MAPNUM, BPNUM FROM "+oDoc.TableName+" WHERE MAPNUM = '' AND BPNUM = ''"
	oDoc.SortBy = " ORDER BY BPNUM"
	//>>
	oDoc.dblPagePrice = 0.15
	gaDocType[gaDocType.length] = oDoc
	

	var oDoc = new oDocType()
	oDoc.EntityNum = "11261" //Official Maps
	oDoc.DocName = "Official Maps"
	oDoc.TableName = "official_Map"; //"official_map_image_om_image"
	oDoc.TLabel1 = "Official Map Book/Pages"
	oDoc.TLabel2 = "City Name"
	oDoc.FValue1 = "OM " //OMBP -> BPNUM
	oDoc.Sql = "SELECT MSLINK, CITYNAME, BPNUM FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT MSLINK, CITYNAME, BPNUM FROM "+oDoc.TableName+" WHERE CITYNAME = '' AND BPNUM = ''"
	oDoc.Sql1 = "BPNUM LIKE '%"
	oDoc.Sql2 = "CITYNAME LIKE '%"
	oDoc.SortBy = " ORDER BY CITYNAME"
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "92"; //"10916" //State Tie Notes
	oDoc.DocName = "State Tie Notes"
	oDoc.TableName = "State_tie_note"; // "State_tie_notes_image_state_tn"
	oDoc.TLabel1 = "State Tie Notes Book/Pages"
	oDoc.FValue1 = "" //STATETNB -> BPNUM
	oDoc.Sql = "SELECT MSLINK, BPNUM FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT MSLINK, BPNUM FROM "+oDoc.TableName+" WHERE BPNUM = ''"
	oDoc.Sql1 = "BPNUM LIKE '%"
	oDoc.SortBy = " ORDER BY BPNUM"
	oDoc.dblPagePrice = 0.15
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "69"; //"10921" //Abandonments, Street Dedications
	oDoc.DocName = "Abandonments, Street Dedications"
	oDoc.TableName = "ABND_STDC"; //"Abandonments_stdc_image_abnd_stdc"
	oDoc.TLabel1 = "File Number"
	oDoc.FValue1 = ""
	oDoc.Sql = "SELECT MSLINK, FILENUM FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT MSLINK, FILENUM FROM "+oDoc.TableName+" WHERE FILENUM = ''"
	oDoc.Sql1 = "FILENUM LIKE '%"
	oDoc.SortBy = " ORDER BY FILENUM"
	oDoc.dblPagePrice = 0.15
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "75"; //"10896" //Caltrans R.O.W. Maps
	oDoc.DocName = "Caltrans R.O.W. Maps"
	oDoc.TableName = "CALTRAN_ROW"; //"Caltran_row_image_caltran_row"
	oDoc.TLabel1 = "Freeway Number"
	oDoc.TLabel2 = "Freeway Name"
	oDoc.FValue1 = ""
	oDoc.Sql = "SELECT MSLINK, FWYNUM, FWYNAME FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT MSLINK, FWYNUM, FWYNAME FROM "+oDoc.TableName+" WHERE FWYNUM = '' AND FWYNAME = ''"
	oDoc.Sql1 = "FWYNUM LIKE '%"
	oDoc.Sql2 = "FWYNAME LIKE '%"
	oDoc.SortBy = " ORDER BY FWYNUM"
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "83"; //"10906" //Flood Control District Notes
	oDoc.DocName = "Flood Control District Notes"
	oDoc.TableName = "OCFCD"; //"OCFCD_image_ocfcd_image"
	oDoc.TLabel1 = "File Number"
	oDoc.TLabel2 = "Channel Name"
	oDoc.FValue1 = ""
	oDoc.Sql = "SELECT MSLINK, FILENUM, CHANNELNAME FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT MSLINK, FILENUM, CHANNELNAME FROM "+oDoc.TableName+" WHERE FILENUM = '' AND CHANNELNAME = ''"
	oDoc.Sql1 = "FILENUM LIKE '%"
	oDoc.Sql2 = "CHANNELNAME LIKE '%"
	oDoc.SortBy = " ORDER BY FILENUM"
	oDoc.dblPagePrice = 0.15
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "88"; //"10911" //Rancho Maps
	oDoc.DocName = "Rancho Maps"
	oDoc.TableName = "Rancho_Map"; //"Rancho_Line_Image_rancho_line"
	oDoc.TLabel1 = "Rancho Name"
	oDoc.TLabel2 = "LA Book/Pages"
	oDoc.FValue1 = ""
	//oDoc.Sql = "SELECT MSLINK, NAME, LABP FROM "+oDoc.TableName+" "
	//oDoc.Sql0 = "SELECT MSLINK, NAME, LABP FROM "+oDoc.TableName+" WHERE NAME = '' AND LABP = ''"
	//oDoc.Sql1 = "NAME LIKE '%"
	//oDoc.Sql2 = "LABP LIKE '%"
	
	oDoc.Sql = "SELECT MSLINK, NAME, LABPNUM FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT MSLINK, NAME, LABPNUM FROM "+oDoc.TableName+" WHERE NAME = '' AND LABPNUM = ''"
	oDoc.Sql1 = "NAME LIKE '%"
	oDoc.Sql2 = "LABPNUM LIKE '%"

	oDoc.SortBy = " ORDER BY NAME"
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "91"; //"10913" //Road Deeds, Offical Records
	oDoc.DocName = "Road Deeds, Offical Records"
	oDoc.TableName = "Road_deed"; //"Road_deeds_image_road_deeds"
	oDoc.TLabel1 = "RD/OR Number"
	oDoc.FValue1 = ""
	oDoc.Sql = "SELECT MSLINK, ORNUM FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT MSLINK, ORNUM FROM "+oDoc.TableName+" WHERE ORNUM = ''"
	oDoc.Sql1 = "ORNUM LIKE '%"
	oDoc.SortBy = " ORDER BY ORNUM"
	oDoc.dblPagePrice = 0.15
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "90"; //"10914" //Record Of Survey Maps
	oDoc.DocName = "Record Of Survey Maps"
	oDoc.TableName = "rs_map"; //"record_of_survey_image_rs_image"
	oDoc.TLabel1 = "Record Of Survey Book/Pages"
	oDoc.TLabel2 = "Record Of Survey Number"
	oDoc.FValue1 = "RSB " //RSB -> BPNUM
	oDoc.Sql = "SELECT MSLINK, BPNUM, RSNUM FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT MSLINK, BPNUM, RSNUM FROM "+oDoc.TableName+" WHERE BPNUM = '' AND RSNUM = ''"
	oDoc.Sql1 = "BPNUM LIKE '%"
	oDoc.Sql2 = "RSNUM LIKE '%"
	oDoc.SortBy = " ORDER BY BPNUM"
	gaDocType[gaDocType.length] = oDoc
	
	var oDoc = new oDocType()
	oDoc.EntityNum = "94"; //"10919" //Survey Maps
	oDoc.DocName = "Survey Maps"
	oDoc.TableName = "Survey_Map"; //"Survey_map_image_survey_map"
	oDoc.TLabel1 = "Survey Map Number"
	oDoc.TLabel2 = "Project Name"
	oDoc.FValue1 = "SM "
	oDoc.Sql = "SELECT MSLINK, SMNUM, PROJECTNAME FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT MSLINK, SMNUM, PROJECTNAME FROM "+oDoc.TableName+" WHERE SMNUM = '' AND PROJECTNAME = ''"
	oDoc.Sql1 = "SMNUM LIKE '%"
	oDoc.Sql2 = "PROJECTNAME LIKE '%"
	oDoc.SortBy = " ORDER BY SMNUM"
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "78" //Corner Records
	oDoc.DocName = "Corner Records"
	oDoc.TableName = "Corner_record"; //"Corner_record_image_corner_rec"
	oDoc.TLabel1 = "Corner Record Number"
	oDoc.FValue1 = "CR "
	oDoc.Sql = "SELECT MSLINK, CRNUM FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT MSLINK, CRNUM FROM "+oDoc.TableName+" WHERE CRNUM = ''"
	oDoc.Sql1 = "CRNUM LIKE '%"
	oDoc.SortBy = " ORDER BY CRNUM"
	oDoc.dblPagePrice = 0.15
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "72"; //"10893" //Annexations - Cities
	oDoc.DocName = "Annexations - Cities"
	oDoc.TableName = "ANNEX_CITY"; //"Annexation_city_circle_image_annx_city_c"
	oDoc.TLabel1 = "City Name"
	oDoc.TLabel2 = "Annex. No. or Name"
	oDoc.TLabel3 = "City Index"
	oDoc.FValue1 = ""
	oDoc.Sql = "SELECT MSLINK, A_NAME, TITLE, A_INDEX FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT MSLINK, A_NAME, TITLE, A_INDEX FROM "+oDoc.TableName+" WHERE A_NAME = '' AND A_INDEX = '' AND TITLE = ''"
	oDoc.Sql1 = "A_NAME LIKE '%" //"CITYNAME LIKE '%"
	oDoc.Sql2 = "TITLE LIKE '%"
	oDoc.Sql3 = "A_INDEX LIKE '%" //"CITYINDEX LIKE '%"
	oDoc.SortBy = " ORDER BY A_NAME" //" ORDER BY CITYNAME"
	oDoc.dblPagePrice = 0.15
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "74"; //"10894" //Annexations - Districts
	oDoc.DocName = "Annexations - Districts"
	oDoc.TableName = "ANNEX_DIST"; //"Annexation_dist_circle_image_annx_dist_c"
	oDoc.TLabel1 = "District Name"
	oDoc.TLabel2 = "District Index"
	oDoc.FValue1 = ""
	oDoc.Sql = "SELECT MSLINK, A_NAME, A_INDEX, TITLE FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT MSLINK, A_NAME, A_INDEX, TITLE FROM "+oDoc.TableName+" WHERE A_NAME = '' AND A_INDEX = ''"
	oDoc.Sql1 = "A_NAME LIKE '%"
	oDoc.Sql2 = "A_INDEX LIKE '%"
	oDoc.SortBy = " ORDER BY A_NAME"
	oDoc.dblPagePrice = 0.15
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "87"; //"10992" //Railroad Maps
	oDoc.DocName = "Railroad Maps"
	oDoc.TableName = "RAILROAD_MAP"; //"Railroad_map_line_image_railrd_map"
	oDoc.TLabel1 = "Railrd Number"
	oDoc.TLabel2 = "Railroad Name"
	oDoc.FValue1 = "RR "
	oDoc.Sql = "SELECT MSLINK, RRNUM, RRNAME FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT MSLINK, RRNUM, RRNAME FROM "+oDoc.TableName+" WHERE RRNUM = '' AND RRNAME = ''"
	oDoc.Sql1 = "RRNUM LIKE '%"
	oDoc.Sql2 = "RRNAME LIKE '%"
	oDoc.SortBy = " ORDER BY RRNUM"
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "10901" //Freeway Plans
	oDoc.DocName = "Freeway Plans"
	oDoc.TableName = "FREEWAY_PLAN"; //"Freeway_plan_image_freeway_pl"
	oDoc.TLabel1 = "Freeway Number"
	oDoc.TLabel2 = "Freeway Name"
	oDoc.FValue1 = "FWY CONST "
	oDoc.Sql = "SELECT MSLINK, FWYNUM, FWYNAME FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT MSLINK, FWYNUM, FWYNAME FROM "+oDoc.TableName+" WHERE FWYNUM = '' AND FWYNAME = ''"
	oDoc.Sql1 = "FWYNUM LIKE '%"
	oDoc.Sql2 = "FWYNAME LIKE '%"
	oDoc.SortBy = " ORDER BY FWYNUM"
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "96"; //"10920" //Township Plats
	oDoc.DocName = "Township Plats"
	oDoc.TableName = "TOWNSHIP_PLAT"; //"Township_plat_image_township_pt"
	oDoc.TLabel1 = "Township & Ranges"
	oDoc.FValue1 = ""
	oDoc.Sql = "SELECT MSLINK, TSRANGE FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT MSLINK, TSRANGE FROM "+oDoc.TableName+" WHERE TSRANGE = ''"
	oDoc.Sql1 = "TSRANGE LIKE '%"
	oDoc.SortBy = " ORDER BY TSRANGE "
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "95"; //"10923" //Township Plat Notes
	oDoc.DocName = "Township Plat Notes" 
	oDoc.TableName = "TS_PLAT_NOTES"; //"ts_platn_record"
	oDoc.TLabel1 = "Township & Ranges"
	oDoc.FValue1 = ""
	oDoc.Sql = "SELECT MSLINK, TSRANGE FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT MSLINK, TSRANGE FROM "+oDoc.TableName+" WHERE TSRANGE = ''"
	oDoc.Sql1 = "TSRANGE LIKE '%"
	oDoc.SortBy = " ORDER BY TSRANGE"
	oDoc.dblPagePrice = 0.15
	gaDocType[gaDocType.length] = oDoc
	
	var oDoc = new oDocType()
	oDoc.EntityNum = "10917" //Street Improvement Plans
	oDoc.DocName = "Street Improvement Plans"
	oDoc.TableName = "Stimp_plan_image_stimp_plan"
	oDoc.TLabel1 = "Street Improvement Plan Number"
	oDoc.TLabel2 = "From Street"
	oDoc.TLabel3 = "To Street"
	oDoc.FValue1 = "ST_IMP "
	oDoc.Sql = "SELECT MSLINK, STIMPNUM, FROM_STREET, TO_STREET FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT MSLINK, STIMPNUM, FROM_STREET, TO_STREET FROM "+oDoc.TableName+" WHERE STIMPNUM = '' AND FROM_STREET = '' AND TO_STREET = ''"
	oDoc.Sql1 = "STIMPNUM LIKE '%"
	oDoc.Sql2 = "FROM_STREET LIKE '%"
	oDoc.Sql3 = "TO_STREET LIKE '%"
	oDoc.SortBy = " ORDER BY STIMPNUM"
	oDoc.nShownInSite = 0
	//gaDocType[gaDocType.length] = oDoc //as per the meeting with Dennis 090825

	var oDoc = new oDocType()
	oDoc.EntityNum = "93"; //"10918" //Survey Field Notes
	oDoc.DocName = "Survey Field Notes"
	oDoc.TableName = "SURVEY_FIELDNOTE" //"Survey_field_notes_image_survey_fldn"
	oDoc.TLabel1 = "File Number"
	oDoc.TLabel2 = "Project Name"
	oDoc.FValue1 = ""
	oDoc.Sql = "SELECT MSLINK, FILENUM, PROJECTNAME FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT MSLINK, FILENUM, PROJECTNAME FROM "+oDoc.TableName+" WHERE FILENUM = '' AND PROJECTNAME = ''"
	oDoc.Sql1 = "FILENUM LIKE '%"
	oDoc.Sql2 = "PROJECTNAME LIKE '%"
	oDoc.SortBy = " ORDER BY FILENUM"
	oDoc.dblPagePrice = 0.15
	gaDocType[gaDocType.length] = oDoc

	var oDoc = new oDocType()
	oDoc.EntityNum = "11263" //HBP Parcels
	oDoc.DocName = "ROWE Docs" //"HBP Parcels"
	oDoc.TableName = "docs" //"hbp_doc_record"
	oDoc.TLabel1 = "Document Number"
	oDoc.TLabel2 = "Document Type"
	oDoc.FValue1 = ""
	oDoc.Sql = "SELECT DISTINCT DOCID, DOCNUM FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT DISTINCT DOCID, DOCNUM FROM "+oDoc.TableName+" WHERE DOCNUM = '' AND DOCTYPE = ''"
	oDoc.Sql1 = "DOCNUM LIKE '%"
	oDoc.Sql2 = "DOCTYPE LIKE '%"
	oDoc.SortBy = " ORDER BY DOCNUM"
	oDoc.dblPagePrice = 0.15
	oDoc.nShownInSite = 0
	//gaDocType[gaDocType.length] = oDoc //090911 remove all HBP related items, per Dennis' request

	var oDoc = new oDocType()
	oDoc.EntityNum = "44444" //Historical Aerial Photos
	oDoc.DocName = "Historical Aerial Photos"
	oDoc.TableName = "Aerial_Photo"
	oDoc.TLabel1 = "Photo Number"
	oDoc.TLabel2 = "TG Page"
	oDoc.TLabel3 = "TG Grid"
	oDoc.FValue1 = ""
	oDoc.Sql = "SELECT DESCRIPTION,YEAR,PHOTO_NUMBER FROM "+oDoc.TableName+" "
	oDoc.Sql0 = "SELECT DESCRIPTION,YEAR,PHOTO_NUMBER FROM "+oDoc.TableName+" WHERE Photo_Number = '' AND TG_Page = '' AND TG_Grid = ''"
	oDoc.Sql1 = "Photo_Number LIKE '%"
	oDoc.Sql2 = "TG_Page LIKE '%"
	oDoc.Sql3 = "TG_Grid LIKE '%"
	oDoc.SortBy = " ORDER BY Photo_Number"
	oDoc.dblPagePrice = -1;
	oDoc.nShownInSite = 2;
	gaDocType[gaDocType.length] = oDoc

function compare(a, b)
{
	if (a.DocName > b.DocName)
		return 1;
	else if (a.DocName == b.DocName)
		return 0;
	else
		return -1;
}

	gaDocType.sort(compare);

function buildSql(oDoc){
	var sSql = ""

	if (oDoc.FValue1)
		sSql += oDoc.Sql1 + oDoc.FValue1 +"%'";
	
	if (oDoc.FValue2)
	{
		if (sSql != "")
			sSql += " AND ";

		sSql += oDoc.Sql2 + oDoc.FValue2 +"%'";
	}
	
	if (oDoc.FValue3)
	{
		if (sSql != "")
			sSql += " AND ";

		sSql += oDoc.Sql3 + oDoc.FValue3 +"%'";
	}
	
	if (sSql == "")
		sSql = oDoc.Sql0;
	else {
		sSql = oDoc.Sql + " WHERE " + sSql;
	
		if(oDoc.SortBy) sSql += oDoc.SortBy;
	}

	if(sSql !=""){ return sSql } else { return null }
}

function getDocTypeObj(entnum){
	for(var i=0;i<gaDocType.length;i++){
		if(gaDocType[i].EntityNum == entnum){
			return gaDocType[i]
		}
	}
	return null
}

function ShowInputFields(nIndex)
{
	eval("top.fraLeftFrame.pnlInput" + nSelectedDocTypeIndex + ".style.display='none'");
	eval("top.fraLeftFrame.pnlInput" + nIndex + ".style.display='inline'");
		
	nSelectedDocTypeIndex = nIndex;
}

function ShowInputFieldsA(nIndex)
{
	eval("top.fraLeftFrame.pnlInputA" + nSelectedDocTypeIndex + ".style.display='none'");
	eval("top.fraLeftFrame.pnlInputA" + nIndex + ".style.display='inline'");
		
	nSelectedDocTypeIndex = nIndex;
}

function ShowInputFieldsB(nIndex)
{
	eval("top.fraLeftFrame.pnlInputB" + nSelectedDocTypeIndex + ".style.display='none'");
	eval("top.fraLeftFrame.pnlInputB" + nIndex + ".style.display='inline'");
		
	nSelectedDocTypeIndex = nIndex;
}

function openSearchingWin()
{
	var nLeft, nTop;
	with (screen)
	{
		nLeft = Math.round((width - 250) / 2);
		nTop = Math.round((height - 130) / 2);
	}
			
	searchingWin = window.open("wait.htm","wait","left=" + nLeft + ",top=" + nTop + ",height=130,width=250");
	top.AddWindow(searchingWin);
}

function closeSearchingWin()
{
	if (searchingWin != null && !searchingWin.closed)
		searchingWin.close();
}

function SearchDocByType(form, nIndex)
{
	var objDoc = gaDocType[nIndex];
	if (objDoc.TLabel1)
	{
		eval("objDoc.FValue1=form.f" + nIndex + "1.value");
		//090911
		// add % if nothing
		if (objDoc.FValue1 == "")
		{
			objDoc.FValue1 = "%";
		}
		objDoc.FValue1 = objDoc.FValue1.replace("'", "''");
		objDoc.FValue1 = objDoc.FValue1.replace("%", "\%");
		objDoc.FValue1 = objDoc.FValue1.replace("_", "\_");
	}
	if (objDoc.TLabel2)
	{
		eval("objDoc.FValue2=form.f" + nIndex + "2.value");
		objDoc.FValue2 = objDoc.FValue2.replace("'", "''");
		objDoc.FValue2 = objDoc.FValue2.replace("%", "\%");
		objDoc.FValue2 = objDoc.FValue2.replace("_", "\_");
	}
	if (objDoc.TLabel3)
	{
		eval("objDoc.FValue3=form.f" + nIndex + "3.value");
		objDoc.FValue3 = objDoc.FValue3.replace("'", "''");
		objDoc.FValue3 = objDoc.FValue3.replace("%", "\%");
		objDoc.FValue3 = objDoc.FValue3.replace("_", "\_");
	}

	openSearchingWin();
	
	var strSQL = buildSql(objDoc);
	//hw091215
	// Replace "MAPNUM LIKE '%%%'" to "1=1"
	var lsMapNum = "MAPNUM LIKE '%%%'";
	if (strSQL.indexOf(lsMapNum) > -1)
	{
		strSQL = strSQL.replace(lsMapNum, "1=1");
	}
	//>>
	if (strSQL)
	{
		var win = window.open("SearchDocByType.aspx?sql=" + escape(strSQL) + "&entnum=" + objDoc.EntityNum, "DocumentSearch", "width=800,height=600,scrollbars=1,resizable=1");
		win.focus(win);
		top.AddWindow(win);
	}
	else
		alert("Can not get search criteria.");
}

var aryPanels;
function InitPanelArray()
{
	aryPanels = new Array();
	aryPanels[top.MENU_DOC_SEARCH] = top.fraLeftFrame.document.all.pnlDocSearch;
	aryPanels[top.MENU_PARCEL_SEARCH] = top.fraLeftFrame.document.all.pnlParcelSearch;
	aryPanels[top.MENU_GEODETIC_VIEW] = top.fraLeftFrame.document.all.pnlGeoView;
	aryPanels[top.MENU_GET_VIEW] = top.fraLeftFrame.document.all.pnlGetView;
	aryPanels[top.MENU_MEASURE] = top.fraLeftFrame.document.all.pnlMeasTools;
	aryPanels[top.MENU_MAP_ARCHIVE] = top.fraLeftFrame.document.all.pnlMapArchive;
	aryPanels[top.MENU_HBP_PARCELS] = top.fraLeftFrame.document.all.pnlHBPParcels;
	aryPanels[top.MENU_SHOPPING_CART] = top.fraLeftFrame.document.all.pnlShoppingCart;
	aryPanels[top.MENU_DOWNLOAD] = top.fraLeftFrame.document.all.pnlDownload;
	aryPanels[top.MENU_HELP] = top.fraLeftFrame.document.all.pnlHelp;
	aryPanels[top.MENU_ECOMMERCE] = top.fraLeftFrame.document.all.pnlECom;
	aryPanels[top.MENU_ROWE_PARCELDOC] = top.fraLeftFrame.document.all.pnlRowe;
}
var nPanelIndex = 0;

function SelectMenu(nIndex)
{
	aryPanels[nPanelIndex].style.display = 'none';
	aryPanels[nIndex].style.display = 'inline';

	nPanelIndex = nIndex;

	if (nIndex == top.MENU_SHOPPING_CART) top.ShowShoppingCart();
	else if (nIndex == top.MENU_DOWNLOAD) top.DownloadShopping();
	else if (nIndex == top.MENU_ECOMMERCE) top.GoECommerce();
	else if (nIndex == top.MENU_GEODETIC_VIEW)
	{
		var group = top.FindGroupByName("Horizontal and Vertical Control");
		if (!group.bVisible)
		{
			top.setGroupVisible(group.nGroupIndex, true);
			if (top.vScale > top.g_nMinGPSScale && top.vScale < top.g_nMaxGPSScale)
				top.reloadSVGMap();
		}
	}
	else if (nIndex == top.MENU_HBP_PARCELS)
	{
		var group = top.FindGroupByName("ROWE Parcel Group"); //HBP Parcel Group //090902
		if (!group.bVisible)
		{
			top.setGroupVisible(group.nGroupIndex, true);
			if (top.vScale > 3000 && top.vScale < 100000)
				top.reloadSVGMap();
		}
	}
}

var aryGetViewPanels;
function InitGetViewPanelArray()
{
	aryGetViewPanels = new Array();
	aryGetViewPanels[0] = top.fraLeftFrame.document.all.pnlGetViewByPageAndGrid;
	aryGetViewPanels[1] = top.fraLeftFrame.document.all.pnlGetViewByCity;
	aryGetViewPanels[2] = top.fraLeftFrame.document.all.pnlGetViewByIntersection;
	aryGetViewPanels[3] = top.fraLeftFrame.document.all.pnlGetViewByCoordinate;
}
var nGVPanelIndex = 0;

function SelectGVPanel(nIndex)
{
	aryGetViewPanels[nGVPanelIndex].style.display = 'none';
	aryGetViewPanels[nIndex].style.display = 'inline';
	
	nGVPanelIndex = nIndex;
}

var aryHBPPanels;
function InitHBPPanelArray()
{
	aryHBPPanels = new Array();
	aryHBPPanels[0] = top.fraLeftFrame.document.all.pnlHBPParcelSearch;
	aryHBPPanels[1] = top.fraLeftFrame.document.all.pnlHBPParcelReport;
}

var nHBPPanelIndex = 0;
function SelectHBPPanel(nIndex)
{
	aryHBPPanels[nHBPPanelIndex].style.display = 'none';
	aryHBPPanels[nIndex].style.display = 'inline';
	
	nHBPPanelIndex = nIndex;
}

var aryHBPReports;
function InitHBPReportsArray()
{
	aryHBPReports = new Array();
	aryHBPReports[0] = top.fraLeftFrame.document.all.pnlHBPReport0;
	aryHBPReports[1] = top.fraLeftFrame.document.all.pnlHBPReport1;
}

var nHBPReportsIndex = 0;
function SelectHBPReport(nIndex)
{
	aryHBPReports[nHBPReportsIndex].style.display = 'none';
	aryHBPReports[nIndex].style.display = 'inline';
	
	nHBPReportsIndex = nIndex;
}