<?php
/**
 * File: install.staffmaster.php
 *
 * Staff Master 0_7_5_5
 *
 * Staff Master - Staff Members and Departments Manager
 *
 * @version 0.7.5.5
 * @package StaffMaster_0_7_5_5
 * @subpackage install
 * @copyright (C) 2007-2008 Travis Hubbard
 * @license http://www.gnu.org/licenses/  GNU/GPL v3
 * @link http://www.systemsunited.net/
 **/

defined( '_JEXEC' ) or die( 'Restricted access' );

   /**
 	* com_install runs when the component installs, it ensures SQL loaded correctly
 	*/
	function com_install()  {

		$version = '0.7.5.5';

		$joom_fish_supported = 'Joom!Fish RC 2.0 Support Enabled!';

		$db = JFactory::getDBO();

		$db->setQuery("CREATE TABLE IF NOT EXISTS #__staff (

							`id` smallint(5) unsigned NOT NULL auto_increment,

  							`name` varchar(255) NOT NULL,

  							`alias` varchar(255) NOT NULL,

  							`dept_id` tinyint(4) unsigned NOT NULL default '0',

  							`title` varchar(255) default NULL,

  							`bio` text,

  							`image_file_name` varchar(255) default NULL,

  							`ordering` tinyint(4) unsigned NOT NULL default '0',

  							`published` tinyint(1) NOT NULL default '1',

  							`phone1` varchar(25) default NULL,

  							`ext1` varchar(10) default NULL,

  							`phone2` varchar(25) default NULL,

  							`ext2` varchar(10) default NULL,

  							`email` varchar(50) default NULL,

  							`address1` varchar(100) default NULL,

  							`address2` varchar(100) default NULL,

  							`address3` varchar(100) default NULL,

  							`address4` varchar(100) default NULL,

  							PRIMARY KEY  (`id`),

  							KEY `department` (`dept_id`),

  							KEY `ordering` (`published`,`ordering`),

  							KEY `staff_alias` (`alias`) );");

		$db->query();
		if ($db->getErrorNum())  {
			echo $db->stderr();
			return false;
		}

		$db->setQuery("CREATE TABLE IF NOT EXISTS #__staff_departments (

  						`id` tinyint(4) unsigned NOT NULL auto_increment,

  						`name` varchar(255) NOT NULL,

  						`alias` varchar(255) NOT NULL,

  						`description` text,

  						`footer_text` text,

  						`ordering` tinyint(4) unsigned NOT NULL default '0',

  						`published` tinyint(1) unsigned NOT NULL default '1',

  						PRIMARY KEY  (`id`),

  						KEY `ordering` (`ordering`),

  						KEY `name` (`name`),

  						KEY `dept_alias` (`alias`)

  						);");

		$db->query();
		if ($db->getErrorNum())  {
			echo $db->stderr();
			return false;
		}

		$db->setQuery("CREATE TABLE IF NOT EXISTS #__staff_settings (

  						`id` tinyint(1) unsigned NOT NULL auto_increment,

  						`page_title` varchar(255) NOT NULL,

  						`staff_image_pos` varchar(10) NOT NULL default 'left',

  						`staff_image_pos_alt` tinyint(1) unsigned NOT NULL default '0',

  						`view_all` varchar(25) NOT NULL default 'default',

  						`view_staff` varchar(25) NOT NULL default 'default',

  						`view_department` varchar(25) NOT NULL default 'default',

  						`view_list` varchar(25) NOT NULL default 'default',

  						`header_text` text,

  						`job_text1` text,

  						`job_text2` text,

  						`job_text3` text,

  						`staff_image_path` varchar(255) default NULL,

  						`staff_image_default` varchar(255) default NULL,

  						`staff_title_default` varchar(255) default NULL,

  						`staff_bio_default` text,

  						`show_dept_footer` tinyint(1) unsigned NOT NULL default '1',

  						`show_dept_footer_text1` tinyint(1) unsigned NOT NULL default '1',

  						`show_dept_footer_text2` tinyint(1) unsigned NOT NULL default '1',

  						`show_dept_footer_text3` tinyint(1) unsigned NOT NULL default '1',

  						`show_com_check` tinyint(1) unsigned NOT NULL default '1',

  						`show_todo` tinyint(1) unsigned NOT NULL default '1',

  						`auto_alias` tinyint(1) unsigned NOT NULL default '1',

  						`use_custom_colors` tinyint(1) unsigned NOT NULL default '0',

  						`custom_colors` text,

  						`list_use_image` tinyint(1) unsigned NOT NULL default '1',

  						`version` varchar(15) default NULL,

  						`last_checked` varchar(10) default NULL,

  						`check_version` tinyint(1) unsigned NOT NULL default '1',

  						`check_version_frequency` tinyint(4) unsigned NOT NULL default '1',

  						`view_admin_bio` smallint(5) unsigned NOT NULL default '250',

  						`cl_phone1` varchar(30) default NULL,

  						`cl_phone2` varchar(30) default NULL,

  						`cl_phone_ext` varchar(30) default NULL,

  						`cl_read_contact` varchar(30) default NULL,

  						`cl_email` varchar(30) default NULL,

  						`cl_address1` varchar(30) default NULL,

  						`cl_address2` varchar(30) default NULL,

  						`cl_address3` varchar(30) default NULL,

  						`cl_address4` varchar(30) default NULL,

  						`linkable_staff_name` tinyint(1) unsigned NOT NULL default '1',

  						`linkable_contact_details` tinyint(1) unsigned NOT NULL default '1',

  						`linkable_department` tinyint(1) unsigned NOT NULL default '1',

  						`th_staff_image` varchar(30) default NULL,

  						`th_staff_name` varchar(30) default NULL,

  						`th_staff_title` varchar(30) default NULL,

  						`th_staff_bio` varchar(30) default NULL,

  						`use_js_contact` tinyint(1) unsigned NOT NULL default '1',

  						`use_js_corners` tinyint(1) unsigned NOT NULL default '1',

  						`use_js_frontend` tinyint(1) unsigned NOT NULL default '1',

  						`title_in_bio` tinyint(1) unsigned NOT NULL default '0',

  						`acl` text COMMENT 'NOT IMPLEMENTED',

  						`use_auto_readmore_bio` tinyint(1) unsigned NOT NULL default '1' COMMENT 'NOT IMPLEMENTED',

  						`auto_readmore_length` varchar(5) NOT NULL COMMENT 'NOT IMPLEMENTED',

  						PRIMARY KEY  (`id`),

  						KEY `auto_alias` (`auto_alias`)

  						);");

		$db->query();
		if ($db->getErrorNum())  {
			echo $db->stderr();
			return false;
		}

		$db->setQuery("UPDATE #__components SET params = 'show_sm_link=1' WHERE name = 'Staff Master' ");

		$db->query();
		if ($db->getErrorNum())  {
			echo $db->stderr();
			return false;
		}

		$db->setQuery("SELECT alias FROM #__staff");

		$test = $db->loadResult();

		if( !$test )  {

			echo '<p>Fresh Install.  Adding a Department and Default Settings.</p>';

			$db->setQuery("SELECT alias FROM #__staff_departments WHERE id = 1 ");

			$test2 = $db->loadResult();

			if( is_null( $test2 ) )  {

				$db->setQuery("INSERT INTO #__staff_departments ( `id` , `name` , `alias` , `description` , `footer_text` , `ordering` , `published` )

					VALUES ( 1 , 'Administration' , 'administration' , '' , '',	1 , 1 );");

				$db->query();
				if ($db->getErrorNum())  {
					echo $db->stderr();
					return false;
				}
			}

			$db->setQuery("SELECT page_title FROM #__staff_settings WHERE id = 1 ");

			$test3 = $db->loadResult();

			if( is_null( $test3 ) )  {

				$db->setQuery("INSERT INTO #__staff_settings ( `id` ,`page_title` , `staff_image_pos` , `view_all` , `view_staff` ,

							`view_department` , `view_list` , `header_text` , `job_text1` , `job_text2` , `job_text3` ,

							`staff_image_path` , `staff_image_default` , `staff_title_default` , `staff_bio_default` ,

							`show_dept_footer` , `show_dept_footer_text1` , `show_dept_footer_text2` , `show_dept_footer_text3` ,

							`show_com_check` , `show_todo` , `use_custom_colors` , `custom_colors` , `list_use_image` , `version` ,

							`last_checked` , `check_version` , `check_version_frequency` , `view_admin_bio` , `cl_phone1` ,

							`cl_phone2` , `cl_phone_ext` , `cl_read_contact` , `cl_email` , `cl_address1` , `cl_address2` ,

							`cl_address3` , `cl_address4` , `linkable_staff_name` , `linkable_contact_details` , `linkable_department` ,

							`th_staff_image` , `th_staff_name` , `th_staff_title` , `th_staff_bio` , `use_js_frontend` , `use_js_contact` ,

							`use_js_corners` , `title_in_bio` , `acl` , `use_auto_readmore_bio` , `auto_readmore_length` )

					VALUES ( 1 , 'Staff Roster' , 'left' , 'default' , 'default' , 'default' , 'default' , '' , '' , '' , '' ,

							'components/com_staffmaster/images/' , 'staff_empty.png' , 'Staff Member' , 'Staff Bio to be submitted.' , 1 , 1  , 1 , 1 , 1 , 1 , 1 ,

							'page_title_color=;dept_name_color=;dept_desc_color=;staff_name_color=;staff_title_color=;staff_bio_color=;dept_unique_foot_color=;dept_general_foot_color=;contact_details=;contact_details_link=' ,

							1 , '{$version}' , '' , 1 , 1 , 250 , 'Phone1' , 'Phone2' , 'Ext.' , 'View contact details...' , 'Email Address' ,

							'Address' , NULL , NULL , NULL , 1 , 1 , 1 , 'Staff Picture' , 'Staff Name' , 'Staff Title' , 'Staff Bio',

							1 , 1 , 1 , 0 , 'global=;\r\nstaff_add=;\r\nstaff_edit=;\r\nstaff_delete=;\r\nstaff_pub=;\r\ndept_add=;\r\ndept_edit=;\r\ndept_delete=;\r\ndept_pub=;\r\ncfg_edit=;\r\nimage_width=;\r\nimage_height=;' ,

							1 , '200' );");

				$db->query();
				if ($db->getErrorNum())  {
					echo $db->stderr();
					return false;
				}
			}
			else {
				$db->setQuery("UPDATE #__staff_settings SET version = '{$version}' WHERE id = 1 ");
				$db->query();
				if ($db->getErrorNum())  {
					echo $db->stderr();
					return false;
				}

			}
		}
		else {

			$db->setQuery("UPDATE #__staff_settings SET version = '{$version}' WHERE id = 1 ");
			$db->query();
			if ($db->getErrorNum())  {
				echo $db->stderr();
				jexit();
				return false;
			}

		}

// ------------------------------------------------------------------------------------------------
// |		Begin Joom!Fish Integration :: -th071008
// ------------------------------------------------------------------------------------------------

		$base_path = JPATH_ROOT;

		$SM_path = $base_path . '/administrator/components/com_staffmaster/contentelements';

		$JF_path = $base_path . '/administrator/components/com_joomfish/contentelements';

		// Check to see if Joom!Fish Exists...
		if( file_exists( $base_path . '/components/com_joomfish/joomfish.php' ) )   {

			// Move Staff Master Joom!Fish support files to the Joom!Fish directory
			@rename( "$SM_path/staff.xml"				, "$JF_path/staff.xml");

			@rename( "$SM_path/staff_departments.xml"	, "$JF_path/staff_departments.xml");

			@rename( "$SM_path/staff_settings.xml"		, "$JF_path/staff_departments.xml");

			// Then remove the Staff Master Directory
			@rmdir ( "$SM_path" );
		}
		else {

			// Joom!Fish is not installed and we should delete the files to save space
			@unlink( "$SM_path/staff.xml" );

			@unlink( "$SM_path/staff_departments.xml" );

			@unlink( "$SM_path/staff_settings.xml" );

			@rmdir ( "$SM_path" );

			$joom_fish_supported = "Joom!Fish not found on site.  Staff Master's Joom!Fish support files have been removed.";
		}
// ------------------------------------------------------------------------------------------------
// |		END Joom!Fish Integration :: -th071008
// ------------------------------------------------------------------------------------------------

?>

	<div class="header">Staff Master Installed Successfully!</div>

		<p>

			Thank you for downloading and installing Systems United's <br />

			Staff Manager component for Joomla 1.5.x.

		</p>

		<p>

			Staff Master v<?php echo $version; ?> is a Joomla! component created to help users, specifically small business owners, <br />

			easily create and manage a public, front-end Staff section using Joomla! CMS.  <br />

			<ul>

				<li>Easily create a Staff Departments and structure, offering an easy way to re-order your Departments.</li>

				<li>Quickly add new Staff Members and modify existing Staff Members</li>

				<li>Many 'default' settings you can pre-configure to keep your staff page uniform and consistent</li>

			</ul>

		</p>

		<p>

			We would love to hear any comments, feature suggestions, constructive criticism, and especially bugs or glitches.<br />

			Your comments are all are greatly appreciated!

		</p>

		<p>

			Please check out our website at <a href="http://www.systemsunited.net" target="_blank" >http://www.systemsunited.net</a><br />

			or email us at <a href="mailto:support@systemsunited.net">support@systemsunited.net</a> if you have any questions or comments.

		</p>

		<p>

			<?php echo $joom_fish_supported ?>

		</p>

<?php

	}

?>