common.php

FP2 CRM code+Mysql DB

<?php
$taskStatus = array (	
						'Not Started'		=>		'Not Started',
						'Inprogress'		=>		'Inprogress',
						'Completed'			=>		'Completed'
						);

$taskComplete = array (	
						'0%'		=>		'0%',
						'10%'		=>		'10%',
						'20%'		=>		'20%',
						'30%'		=>		'30%',
						'40%'		=>		'40%',
						'50%'		=>		'50%',
						'60%'		=>		'60%',
						'70%'		=>		'70%',
						'80%'		=>		'80%',
						'90%'		=>		'90%',
						'100%'		=>		'100%'
					);
$appointmentReminder = array (
							'15m'			=>		'15 Minutes',
							'30m'			=>		'30 Minutes',
							'45m'			=>		'45 Minutes',
							'60m'			=>		'1 Hour',
							'180m'			=>		'3 Hours',
							'1'			    =>		'1 Day',
							'3'			    =>		'3 Days',
							'7'			    =>		'1 Week',
							'21'			=>	    '3 Weeks',
							'30'			=>	    '1 Month',
							'90'			=>	    '3 Months',
							'1180'			=>		'6 Months',
							);

$arrayAmPm = array (	
						'15'				=>		'15',
						'30'				=>		'30',
						'45'				=>		'45',
						'00'				=>		'00'
						);

$appointmentMinutes = array (	
						'15'				=>		'15',
						'30'				=>		'30',
						'45'				=>		'45',
						'00'				=>		'00'
						);
$arrayHours = array (	
						'1'				=>		'1',
						'2'				=>		'2',
						'3'				=>		'3',
						'4'				=>		'4',
						'5'				=>		'5',
						'6'				=>		'6',
						'7'				=>		'7',
						'8'				=>		'8',
						'9'				=>		'9',
						'10'			=>		'10',
						'11'			=>		'11',
						'12'			=>		'12'
						);
$arrayMinutes = array (	
						'1'				=>		'1',
						'2'				=>		'2',
						'3'				=>		'3',
						'4'				=>		'4',
						'5'				=>		'5',
						'6'				=>		'6',
						'7'				=>		'7',
						'8'				=>		'8',
						'9'				=>		'9',
						'10'			=>		'10',
						'11'			=>		'11',
						'12'			=>		'12',
						'13'			=>		'13',
						'14'			=>		'14',
						'15'			=>		'15',
						'16'			=>		'16',
						'17'			=>		'17',
						'18'			=>		'18',
						'19'			=>		'19',
						'20'			=>		'20',
						'21'			=>		'21',
						'22'			=>		'22',
						'23'			=>		'23',
						'24'			=>		'24',
						'25'			=>		'25',
						'26'			=>		'26',
						'27'			=>		'27',
						'28'			=>		'28',
						'29'			=>		'29',
						'30'			=>		'30',
						'31'			=>		'31',
						'32'			=>		'32',
						'33'			=>		'33',
						'34'			=>		'34',
						'35'			=>		'35',
						'36'			=>		'36',
						'37'			=>		'37',
						'38'			=>		'38',
						'39'			=>		'39',
						'40'			=>		'40',
						'41'			=>		'41',
						'42'			=>		'42',
						'43'			=>		'43',
						'44'			=>		'44',
						'45'			=>		'45',
						'46'			=>		'46',
						'47'			=>		'47',
						'48'			=>		'48',
						'49'			=>		'49',
						'50'			=>		'50',
						'51'			=>		'51',
						'52'			=>		'52',
						'53'			=>		'53',
						'54'			=>		'54',
						'55'			=>		'55',
						'56'			=>		'56',
						'57'			=>		'57',
						'58'			=>		'58',
						'59'			=>		'59',
						'00'			=>		'00',
						);

$arLeadStatusArray = array (	
						'New'					=>		'New',
						'InProcess'				=>		'InProcess',
						'Dead'					=>		'Dead');
						
$customerStatusArray = array (
							'1'			=>		'Yes',
							'0'			=>		'No'
							);
$arSourceOfEntry = array(	
							''				=>		' - - - - - - - - - - - - ',
							'PHONE'		 	=>		'PHONE',
							'OFFICE'		=>		'OFFICE'
							);

$arEmployeeType = array(''				=>		'- - - - - - - - - ',
						'PERMANENT'		=>		'PERMANENT',
						'PART-TIME'		=>		'PART-TIME',
						'PROBATION'		=>		'PROBATION',
						'INTERNSHIP'	=>		'INTERNSHIP',
						'CONTRACTOR'	=>		'CONTRACTOR',
);

$arEmployeeHiringStages = array(''						=>		'- - - - - - - - - - - ',
								'INTERVIEW'				=>		'INTERVIEW',
								'CLIENT_INTERVIEW'		=>		'CLIENT_INTERVIEW',
								'OFFER_GIVEN'			=>		'OFFER_GIVEN',
								'OFFER_ACCEPTED'		=>		'OFFER_ACCEPTED',
								'JOINING_SOON'			=>		'JOINING_SOON',
								'JOINED'				=>		'JOINED',
						);

$arEmployeeDivision = array(''							=>		'- - - - - - - - - - - ',
							'ADFERNO'					=>		'ADFERNO',
							'V-TEAMS'					=>		'V-TEAMS',
							'NEXTBRIDGE CORPORATE'		=>		'NEXTBRIDGE CORPORATE',
							'NEXTWERK'					=>		'NEXTWERK',
							'CYBERGATE'					=>		'CYBERGATE',
					);

$arEmployeeJobTitle = array(''						=> '- - - - - - - - - - - - - - - - - ',
						'3D ANIMATOR'				=> '3D ANIMATOR',
						'ACCOUNTANT'				=> 'ACCOUNTANT',
						'ADMIN OFFICER'				=> 'ADMIN OFFICER',
						'CONTENT WRITER'			=> 'CONTENT WRITER',
						'DATA ENTRY OPERATOR'		=> 'DATA ENTRY OPERATOR',
						'DEPUTY TEAM-LEAD'			=> 'DEPUTY TEAM-LEAD',
						'DEVELOPER'					=> 'DEVELOPER',
						'GRAPHIC DESIGNER'			=> 'GRAPHIC DESIGNER',
						'INTERNSHIP'				=> 'INTERNSHIP',
						'MANAGER V-TEAM'			=> 'MANAGER V-TEAM',
						'MIS EXECUTIVE'				=> 'MIS EXECUTIVE',
						'PRODUCTION MANAGER'		=> 'PRODUCTION MANAGER',
						'PROGRAMMER'				=> 'PROGRAMMER',
						'PROJECT ASSISTANT'			=> 'PROJECT ASSISTANT',
						'PROJECT MANAGER'			=> 'PROJECT MANAGER',
						'SENIOR SOFTWARE ENGINEER'	=> 'SENIOR SOFTWARE ENGINEER',
						'SOFTWARE ENGINEER'			=> 'SOFTWARE ENGINEER',
						'SQA ENGINEER'				=> 'SQA ENGINEER',
						'TEAM LEAD'					=> 'TEAM LEAD',
						'TECHNICAL TEAM-LEAD'		=> 'TECHNICAL TEAM-LEAD',
						'WEB DESIGNER' 				=> 'WEB DESIGNER',
						'WEB PRODUCER'				=> 'WEB PRODUCER',
						'WEB-DEVELOPER' 			=> 'WEB-DEVELOPER',
							
);

$arVTeamType = array(		''					=>		'- - - - - - - - - - - - - - - - - ',
							'TEMPORARY'			=>		'TEMPORARY',
							'TRIAL ONLY'		=>		'TRIAL ONLY',
							'PERMANENT'			=>		'PERMANENT',
							'PROJECTONLY'		=>		'PROJECTONLY',
);

$arVTeamStatus = array(
						'Active'		=>		'Active',
						'Inactive'		=>		'Inactive',
);

$arEmploymentType = array(''					=>		'- - - - - - - - - - - - - ',
							'FULLTIME'			=>		'FULLTIME',
							'TRIAL'				=>		'TRIAL',
							'FIXED DURATION'	=>		'FIXED DURATION',
);

$arPlopStauts = array(		''							=>		'- - - - - - - - - - - - - ',
							'New'						=>		'New',
							'Waiting For Reployee'		=>		'Waiting For Reployee',
							'Inprocess'					=>		'Inprocess',
							'Not Responding'			=>		'Not Responding',
							'Dead'						=>		'Dead',
);
$arSkillModuls = array(
						''				=>		'- - - - - - - - - - - - -',
						'Language'		=>		'Language',
						'Databases'		=>		'Databases',
						'Designing'		=>		'Designing',
						'PHP Framworks'	=>		'PHP Framworks',
						'3D Amination'	=>		'3D Amination',
						'Tools'			=>		'Tools',
						'Others'		=>		'Others',
						

);

$companyStatusArray = array(
							'Active'	=>		'Active',
							'Inactive'	=>		'Inactive',
);

$gConstantGroupsArray = array(
				''									=>	' - - - - - - - - - - - - ',
				'PLOP STATUS'						=>	'PLOP STATUS',
				'EMPLOYMENT - TYPE'					=>	'EMPLOYMENT - TYPE',
				'EMPLOYEE - HIRING - STAGE'			=>	'EMPLOYEE - HIRING - STAGE'	,
				'EMPLOYEE - DIVISION'				=>	'EMPLOYEE - DIVISION',
				'EMPLOYEE - DESIGNATION'			=>	'EMPLOYEE - DESIGNATION',
				'V-TEAM - STATUS'					=>	'V-TEAM - STATUS',				
				'V-TEAM - TYPE'						=>	'V-TEAM - TYPE',				
				'LEAD - STATUS'						=>	'LEAD - STATUS',				
				'CUSTOMER - STATUS'					=>	'CUSTOMER - STATUS',
				'COMPANY - STATUS'					=>	'COMPANY - STATUS',
				'LEAD - SOURCE - OF - ENTRY'		=> 	'LEAD - SOURCE - OF - ENTRY',
				'EMPLOYEE - TYPE'					=>	'EMPLOYEE - TYPE',
)

/*
asort($arEmployeeJobTitle);
foreach($arEmployeeJobTitle as $key => $value)
	echo "'$key'		=>		'$key',<br />";
	/**/

?>