<?php
class ProspectTable extends Table
{

	const C_TABLE                       = "PROSPECT";
	const C_ID                          = "PROSPECT_ID";
	const C_PK                 			= "PROSPECT_ID";
	const C_STATUS                      = "PROSPECT_STATUS";
	const C_NAME                        = "PROSPECT_NAME";
	const C_UEN                       	= "PROSPECT_UEN";
	const C_CODE                        = "PROSPECT_CODE";
	const C_WEB                         = "PROSPECT_WEB";
	const C_TELEPHONE                   = "PROSPECT_TELEPHONE";
	const C_TELEPHONE2                  = "PROSPECT_TELEPHONE2";
	const C_FAX                         = "PROSPECT_FAX";
	const C_BILLING              		= "PROSPECT_BILLING";
	const C_ONSITE              		= "PROSPECT_ONSITE";

	const C_LIC_NAME              		= "PROSPECT_LICENSE_NAME";
	const C_LIC_PHONE              		= "PROSPECT_LICENSE_TELEPHONE";
	const C_LIC_EMAIL              		= "PROSPECT_LICENSE_EMAIL";
	const C_LIC_DSG              		= "PROSPECT_LICENSE_DESIGNATED";

	const C_LIC_NAME2              		= "PROSPECT_LICENSE_NAME2";
	const C_LIC_PHONE2             		= "PROSPECT_LICENSE_TELEPHONE2";
	const C_LIC_EMAIL2              	= "PROSPECT_LICENSE_EMAIL2";
	const C_LIC_DSG2              		= "PROSPECT_LICENSE_DESIGNATED2";

	const C_FIN_NAME              		= "PROSPECT_FINANCE_NAME";
	const C_FIN_PHONE              		= "PROSPECT_FINANCE_TELEPHONE";
	const C_FIN_EMAIL              		= "PROSPECT_FINANCE_EMAIL";
	const C_FIN_DSG              		= "PROSPECT_FINANCE_DESIGNATED";

	const C_FIN_NAME2              		= "PROSPECT_FINANCE_NAME2";
	const C_FIN_PHONE2             		= "PROSPECT_FINANCE_TELEPHONE2";
	const C_FIN_EMAIL2              	= "PROSPECT_FINANCE_EMAIL2";
	const C_FIN_DSG2              		= "PROSPECT_FINANCE_DESIGNATED2";

	const C_IT_NAME              		= "PROSPECT_IT_NAME";
	const C_IT_PHONE              		= "PROSPECT_IT_TELEPHONE";
	const C_IT_EMAIL              		= "PROSPECT_IT_EMAIL";
	const C_IT_DSG              		= "PROSPECT_IT_DESIGNATED";

	const C_IT_NAME2              		= "PROSPECT_IT_NAME2";
	const C_IT_PHONE2              		= "PROSPECT_IT_TELEPHONE2";
	const C_IT_EMAIL2              		= "PROSPECT_IT_EMAIL2";
	const C_IT_DSG2              		= "PROSPECT_IT_DESIGNATED2";

	const C_PROJ_NAME              		= "PROSPECT_PROJECT_MANAGER_NAME";
	const C_PROJ_PHONE              	= "PROSPECT_PROJECT_MANAGER_TELEPHONE";
	const C_PROJ_EMAIL              	= "PROSPECT_PROJECT_MANAGER_EMAIL";
	const C_PROJ_DSG              		= "PROSPECT_PROJECT_MANAGER_DESIGNATED";

	const C_PROJ_NAME2              	= "PROSPECT_PROJECT_MANAGER_NAME2";
	const C_PROJ_PHONE2              	= "PROSPECT_PROJECT_MANAGER_TELEPHONE2";
	const C_PROJ_EMAIL2              	= "PROSPECT_PROJECT_MANAGER_EMAIL2";
	const C_PROJ_DSG2              		= "PROSPECT_PROJECT_MANAGER_DESIGNATED2";

	const C_SUNSYSTEMS_VERSION          = "PROSPECT_SUNSYTEMS_VERSION";
	const C_MSSQL_VERSION              	= "PROSPECT_MSSQL_VERSION";
	const C_QA_VERSION              	= "PROSPECT_QA_VERSION";
	const C_WINSERVER_VERSION           = "PROSPECT_WIN_SERVER_VERSION";
	const C_SUPPORTING_PARTNER          = "PROSPECT_SUPPORT_PARTNER";

	const C_ADDRESS_1          			= "PROSPECT_ADDRESS_1";
	const C_ADDRESS_2          			= "PROSPECT_ADDRESS_2";
	const C_ADDRESS_3          			= "PROSPECT_ADDRESS_3";
	const C_ADDRESS_4          			= "PROSPECT_ADDRESS_4";
	const C_ADDRESS_5          			= "PROSPECT_ADDRESS_5";

	const C_SOFTWARE_INFO     			= "PROSPECT_SOFTWARE_INFO";
	const C_BILLING_CYCLE     			= "PROSPECT_BILLING_CYCLE";
	const C_REMARKS     				= "PROSPECT_REMARKS";

	const C_ACCOUNT     				= "PROSPECT_ACCOUNT";

	//Telemarketing
	const C_SALES_STATUS                = "PROSPECT_SALES_STATUS";
	const C_SALES_STATUS2               = "PROSPECT_SALES_STATUS2";
	const C_COMPANY_STATUS              = "PROSPECT_COMPANY_STATUS";
	const C_WEBSITE                     = "PROSPECT_WEBSITE";
	const C_BUSINESS_DESC               = "PROSPECT_BUSINESS_DESC";
	const C_ACC_SOFTWARE                = "PROSPECT_ACCOUNTING_SOFTWARE";
	const C_ACC_SOFTWARE_C           	= "PROSPECT_ACCOUNTING_SOFTWARE_C";
	const C_ACC_SOFTWARE_N           	= "PROSPECT_ACCOUNTING_SOFTWARE_N";
	const C_ACC_SOFTWARE_USER           = "PROSPECT_ACCOUNTING_SOFTWARE_USER";
	const C_OTHER_SOFTWARE              = "PROSPECT_OTHER_SOFTWARE";
	const C_OTHER_SOFTWARE_C         	= "PROSPECT_OTHER_SOFTWARE_C";
	const C_OTHER_SOFTWARE_N         	= "PROSPECT_OTHER_SOFTWARE_N";
	const C_OTHER_SOFTWARE_USER         = "PROSPECT_OTHER_SOFTWARE_USER";
	const C_SALES_SOFTWARE              = "PROSPECT_SALES_SOFTWARE";
	const C_SALES_SOFTWARE_C         	= "PROSPECT_SALES_SOFTWARE_C"; //concurrent
	const C_SALES_SOFTWARE_N         	= "PROSPECT_SALES_SOFTWARE_N"; //number of users
	const C_SALES_SOFTWARE_USER         = "PROSPECT_SALES_SOFTWARE_USER"; 
	const C_PROPOSAL_1 			        = "PROSPECT_PROPOSAL_1";
	const C_PROPOSAL_2 			        = "PROSPECT_PROPOSAL_2";
	const C_INDUSTRY			        = "PROSPECT_INDUSTRY";
	const C_BUSINESS_SECTOR		        = "PROSPECT_BUSINESS_SECTOR";
	const C_BUSINESS_NATURE		        = "PROSPECT_BUSINESS_NATURE";
	const C_TOTAL_EMPLOYEE		        = "PROSPECT_TOTAL_EMPLOYEE";
	const C_SUBSIDIARY_LOCATION         = "PROSPECT_SUBSIDIARY_LOCATION";
	const C_SUBSIDIARY_ENTITY	        = "PROSPECT_SUBSIDIARY_ENTITY";

	const C_COMPANY_EMAIL				= "PROSPECT_COMPANY_EMAIL";
	const C_STATE						= "PROSPECT_STATE";
	const C_LINKEDIN_WEBSITE			= "PROSPECT_LINKEDIN_WEBSITE";
	const C_SOURCES						= "PROSPECT_SOURCES";

	const C_FLAG						= "PROSPECT_ACCOUNT_FLAG";
}

class ProspectTableDetail extends TableDetail
{
	const C_ID                          = "identity||NO|";
	const C_STATUS                      = "int||NO|(0)";
	const C_NAME                        = "nvarchar|255|NO|''";
	const C_CODE                        = "nvarchar|50|NO|''";
	const C_WEB                         = "nvarchar|255|NO|''";
	const C_TELEPHONE                   = "nvarchar|255|NO|''";
	const C_TELEPHONE2                  = "nvarchar|255|NO|''";
	const C_FAX                         = "nvarchar|255|NO|''";
	const C_BILLING              		= "nvarchar|255|NO|''";
	const C_ONSITE              		= "nvarchar|255|NO|''";
	const C_UEN              			= "nvarchar|255|NO|''";

	const C_LIC_NAME              		= "nvarchar|255|NO|''";
	const C_LIC_PHONE              		= "nvarchar|255|NO|''";
	const C_LIC_EMAIL              		= "nvarchar|255|NO|''";
	const C_LIC_DSG  					= "nvarchar|255|NO|''";

	const C_LIC_NAME2              		= "nvarchar|255|NO|''";
	const C_LIC_PHONE2              	= "nvarchar|255|NO|''";
	const C_LIC_EMAIL2              	= "nvarchar|255|NO|''";
	const C_LIC_DSG2  					= "nvarchar|255|NO|''";

	const C_FIN_NAME              		= "nvarchar|255|NO|''";
	const C_FIN_PHONE              		= "nvarchar|255|NO|''";
	const C_FIN_EMAIL              		= "nvarchar|255|NO|''";
	const C_FIN_DSG              		= "nvarchar|255|NO|''";

	const C_FIN_NAME2              		= "nvarchar|255|NO|''";
	const C_FIN_PHONE2              	= "nvarchar|255|NO|''";
	const C_FIN_EMAIL2              	= "nvarchar|255|NO|''";
	const C_FIN_DSG2              		= "nvarchar|255|NO|''";

	const C_IT_NAME              		= "nvarchar|255|NO|''";
	const C_IT_PHONE              		= "nvarchar|255|NO|''";
	const C_IT_EMAIL              		= "nvarchar|255|NO|''";
	const C_IT_DSG              		= "nvarchar|255|NO|''";

	const C_IT_NAME2              		= "nvarchar|255|NO|''";
	const C_IT_PHONE2              		= "nvarchar|255|NO|''";
	const C_IT_EMAIL2              		= "nvarchar|255|NO|''";
	const C_IT_DSG2              		= "nvarchar|255|NO|''";

	const C_PROJ_NAME              		= "nvarchar|255|NO|''";
	const C_PROJ_PHONE              	= "nvarchar|255|NO|''";
	const C_PROJ_EMAIL              	= "nvarchar|255|NO|''";
	const C_PROJ_DSG              		= "nvarchar|255|NO|''";

	const C_PROJ_NAME2              	= "nvarchar|255|NO|''";
	const C_PROJ_PHONE2              	= "nvarchar|255|NO|''";
	const C_PROJ_EMAIL2              	= "nvarchar|255|NO|''";
	const C_PROJ_DSG2              		= "nvarchar|255|NO|''";

	const C_SUNSYSTEMS_VERSION          = "nvarchar|255|NO|''";
	const C_MSSQL_VERSION              	= "nvarchar|255|NO|''";
	const C_QA_VERSION              	= "nvarchar|255|NO|''";
	const C_WINSERVER_VERSION           = "nvarchar|255|NO|''";
	const C_SUPPORTING_PARTNER          = "nvarchar|255|NO|''";

	const C_ADDRESS_1          			= "nvarchar|255|NO|''";
	const C_ADDRESS_2          			= "nvarchar|255|NO|''";
	const C_ADDRESS_3          			= "nvarchar|255|NO|''";
	const C_ADDRESS_4          			= "nvarchar|255|NO|''";
	const C_ADDRESS_5          			= "nvarchar|255|NO|''";

	const C_SOFTWARE_INFO     			= "nvarchar|255|NO|''";
	const C_BILLING_CYCLE     			= "nvarchar|255|NO|''";
	const C_REMARKS     				= "ntext||NO|''";

	const C_ACCOUNT                     = "int|||null";
	
	//telemarketing
	const C_SALES_STATUS                = "int||NO|(0)";
	const C_SALES_STATUS2               = "int||NO|(0)";
	const C_COMPANY_STATUS              = "int||NO|(0)";
	const C_WEBSITE                     = "nvarchar|255|NO|''";
	const C_BUSINESS_DESC               = "ntext||NO|''";

	const C_ACC_SOFTWARE                = "int||NO|(0)";
	const C_ACC_SOFTWARE_C           	= "nvarchar|255|NO|''";
	const C_ACC_SOFTWARE_N           	= "nvarchar|255|NO|''";
	const C_ACC_SOFTWARE_USER           = "nvarchar|255|NO|''";

	const C_OTHER_SOFTWARE              = "int||NO|(0)";
	const C_OTHER_SOFTWARE_C         	= "nvarchar|255|NO|''";
	const C_OTHER_SOFTWARE_N         	= "nvarchar|255|NO|''";
	const C_OTHER_SOFTWARE_USER         = "nvarchar|255|NO|''";

	const C_SALES_SOFTWARE              = "int||NO|(0)";
	const C_SALES_SOFTWARE_C         	= "nvarchar|255|NO|''";
	const C_SALES_SOFTWARE_N         	= "nvarchar|255|NO|''";
	const C_SALES_SOFTWARE_USER         = "nvarchar|255|NO|''";

	const C_PROPOSAL_1 			        = "nvarchar|255|NO|''";
	const C_PROPOSAL_2 			        = "nvarchar|255|NO|''";

	const C_INDUSTRY			        = "int||NO|(0)";
	const C_BUSINESS_SECTOR		        = "int||NO|(0)";
	const C_BUSINESS_NATURE		        = "int||NO|(0)";
	const C_TOTAL_EMPLOYEE		        = "nvarchar|255|NO|''";

	const C_SUBSIDIARY_LOCATION         = "nvarchar|255|NO|''";
	const C_SUBSIDIARY_ENTITY	        = "nvarchar|255|NO|''";

	const C_COMPANY_EMAIL				= "nvarchar|255|NO|''";
	const C_STATE						= "nvarchar|255|NO|''";
	const C_LINKEDIN_WEBSITE			= "nvarchar|255|NO|''";
	const C_SOURCES						= "nvarchar|255|NO|''";

	const C_FLAG		        		= "nchar|1|NO|''";
}

class ProspectTableDescription extends TableDescription  {

	const C_ID                          = "ID";
	const C_STATUS                      = "Status";
	const C_NAME                        = "Name";
	const C_CODE                        = "Code";
	const C_WEB                         = "Web";
	const C_TELEPHONE                   = "Telephone";
	const C_FAX                         = "Fax";
	const C_BILLING              		= "Billing";
	const C_ONSITE              		= "Onsite";

	const C_ADDRESS_1          			= "Address";

	const C_SOFTWARE_INFO     			= "Software Info";
	const C_BILLING_CYCLE     			= "Billing Cycle";
	const C_REMARKS     				= "Remarks";

	const C_ACCOUNT                     = "Account ID";
}
