File Source for InstallController.php

<?php
/* -------------------------------------------------------------------------- */
/* Module : InstallController */
/* */
/* Version History : */
/* */
/* Date Vsn Author Description */
/* -------------------------------------------------------------------------- */
/* 04/02/09 1.0 S.Lindo Initial version. */
/* -------------------------------------------------------------------------- */
/**
* Handles the actions for installation of the online booking system.
*
* @package Default
*/
class InstallController extends Zend_Controller_Action
{
public function init(){
parent::init();
// Shared behaviour should be placed here.
}
/**
* The default action for all controllers.
*
* This controls all installation activites
*
* @return void
*/
public function indexAction()
{
$tab='    ';
$this->_helper->layout->setLayout('website');
$this->view->pageTitle='Install';
$this->view->pageSkillSet = null;
$this->installReferenceData($tab);
$this->installClients($tab);
}
/**
* Populate the database with all demo clients (and root)
*
* @return void
*/
private function installClients($tab)
{
echo ' -------------------------------------------------------------------';
echo ' Installing CLIENTS ';
$property_id = 0;
$accomm_id = 0;
$clientIdsArray = array();
$clientIdsArray['CLIENT_ROOT'] = array
(
'client_id' => CLIENT_ROOT,
'user_id' => LOGIN_NAME_ROOT,
'perm_id' => PERM_ROOT
);
$clientIdsArray['CLIENT_DEMO_VILLA'] = array
(
'client_id' => CLIENT_DEMO_VILLA,
'user_id' => LOGIN_NAME_DEMO_VILLA,
'perm_id' => PERM_CLIENT_PREMIUM
);
$clientIdsArray['CLIENT_DEMO_BandB'] = array
(
'client_id' => CLIENT_DEMO_BandB,
'user_id' => LOGIN_NAME_DEMO_BandB,
'perm_id' => PERM_CLIENT_PREMIUM
);
$clientTypeArray = array
(
'CLIENT_TYPE_WEBSITE' => CLIENT_TYPE_WEBSITE,
'CLIENT_TYPE_OWNER' => CLIENT_TYPE_OWNER,
'CLIENT_TYPE_ROOT' => CLIENT_TYPE_ROOT
);
$paymentMethodsArray = array
(
'PYT_CARD' => PYT_CARD,
'PYT_CHEQUE' => PYT_CHEQUE,
'PYT_PHONE' => PYT_PHONE
);
$seasonsArray = array
(
'SEASON_DEFAULT' => SEASON_DEFAULT
);
$bookableDetailsArray = array
(
'BOOKABLE_ADULT' => 1,
'BOOKABLE_CHILD' => 2,
'BOOKABLE_INFANT' => 3,
'BOOKABLE_COT' => 4,
'BOOKABLE_PET' => 5,
'BOOKABLE_RQT' => 6
);
$path=APPLICATION_PATH . '/config/install/clients';
if ($handle = opendir($path))
{
$client = new Client ();
$user = new User ();
$contactDetails = new ContactDetails ();
$clientPayment = new ClientPayment ();
$clientDeposit = new ClientDeposit ();
$clientSeason = new ClientSeason ();
$clientProperty = new ClientProperty ();
$property = new Property ();
$propertyOffers = new PropertyOffers ();
$propertyConditions = new PropertyConditions ();
$accommodation = new Accommodation ();
$accommDetails = new AccommDetails ();
$durationPrice = new DurationPrice ();
// Loop over the client configuration files directory
while (false !== ($file = readdir($handle)))
{
if (!is_dir($file))
{
$filenameAsArray = explode('.', $file);
if (count($filenameAsArray) > 1)
{
if ($filenameAsArray[1] == 'xml')
{
$fullPath = $path . '/' . $file;
$config = new Zend_Config_Xml ($fullPath);
echo ' -------------------------------------------------------------------';
// CLIENT
$clientRow = null;
$clientRow = $client->createRow($config->client->toArray());
$constants = $clientIdsArray[$clientRow->client_id];
$clientRow->client_id = $constants['client_id'];
$clientRow->client_type = $clientTypeArray[$config->client->client_type];
if ($clientRow->cheques_to == null)
{
$clientRow->cheques_to = $clientRow->company_name;
}
echo ' Installing client ' . $clientRow->client_id;
$client->delete('client_id=' . $clientRow->client_id);
$client->insert($clientRow->toArray());
// USER
echo ' Installing user ' . $config->client->user->last_name;
$userRow = null;
$userRow = $user->createRow($config->client->user->toArray());
$userRow->client_id = $clientRow->client_id;
$userRow->user_id = $constants['user_id'];
$userRow->perm_id = $constants['perm_id'];
$userRow->create_date = DATE_TODAY;
$user->delete('client_id=' . $clientRow->client_id . " AND user_id='" . $userRow->user_id . "'");
$user->insert($userRow->toArray());
// CONTACT DETAILS
echo ' Installing contact details';
$contactDetailsRow = null;
$contactDetailsRow = $contactDetails->createRow($config->client->user->contact_details->toArray());
$contactDetailsRow->user_id = $userRow->user_id;
$contactDetails->delete("user_id='" . $contactDetailsRow->user_id . "'");
$contactDetails->insert($contactDetailsRow->toArray());
// CLIENT PAYMENTS
if ($config->client->client_payments != null)
{
echo ' Installing client payment methods' . $clientRow->client_id;
$clientPayment->delete('client_id=' . $clientRow->client_id);
foreach ($config->client->client_payments as $paymentDefinition)
{
$clientPaymentRow = null;
$clientPaymentRow = $clientPayment->createRow($paymentDefinition->toArray());
$clientPaymentRow->client_id = $clientRow->client_id;
$clientPaymentRow->method_id = $paymentMethodsArray[$paymentDefinition->method_id];
$clientPayment->insert($clientPaymentRow->toArray());
}
} else {
echo ' ** No client payment methods to install** ';
}
// CLIENT DEPOSIT
if ($config->client->client_deposit != null)
{
echo ' Installing client deposit' . $clientRow->client_id;
$clientDepositRow = null;
$clientDepositRow = $clientDeposit->createRow($config->client->client_deposit->toArray());
$clientDepositRow->client_id = $clientRow->client_id;
$clientDeposit->delete('client_id=' . $clientDepositRow->client_id);
$clientDeposit->insert($clientDepositRow->toArray());
} else {
echo ' ** No client deposit to install** ';
}
// CLIENT SEASONS
if ($config->client->client_seasons != null)
{
$clientSeason->delete('client_id=' . $clientRow->client_id);
foreach ($config->client->client_seasons as $seasonDefinition)
{
echo ' Installing client season' . $clientRow->client_id;
$clientSeasonRow = null;
$clientSeasonRow = $clientSeason->createRow($seasonDefinition->toArray());
$clientSeasonRow->client_id = $clientRow->client_id;
$clientSeasonRow->season_id = $seasonsArray[$seasonDefinition->season_id];
$clientSeason->insert($clientSeasonRow->toArray());
}
} else {
echo ' ** No client seasons to install** ';
}
// 'Root' clients does not have properties
if ($config->client->client_property != null)
{
$clientProperty->delete('client_id=' . $clientRow->client_id);
// PROPERTIES
foreach ($config->client->client_property as $propertyDefinition)
{
// CLIENT_PROPERTY
$property_id++;
$clientPropertyRow = null;
$clientPropertyRow = $clientProperty->createRow();
$clientPropertyRow->client_id = $clientRow->client_id;
$clientPropertyRow->property_id = $property_id;
echo ' Installing client property ' . $clientPropertyRow->property_id;
$clientProperty->insert($clientPropertyRow->toArray());
// PROPERTY
$propertyRow = null;
$propertyRow = $property->createRow();
$propertyRow->property_id = $clientPropertyRow->property_id;
$propertyRow->description = $propertyDefinition->description;
$propertyRow->main = $propertyDefinition->main;
$propertyRow->single_unit = $propertyDefinition->single_unit;
echo ' ' . $tab . 'Installing property ' . $propertyRow->property_id . ' - ' . $propertyDefinition->description;
$property->delete('property_id=' . $propertyRow->property_id);
$property->insert($propertyRow->toArray());
// PROPERTY CONDITIONS
echo ' ' . $tab . $tab . 'Installing booking conditions ';
$propertyConditionsRow = null;
$propertyConditionsRow = $propertyConditions->createRow();
$propertyConditionsRow->property_id = $propertyRow->property_id;
$propertyConditionsRow->description = $propertyDefinition->conditions;
$propertyConditions->delete('property_id=' . $propertyConditionsRow->property_id);
$propertyConditions->insert($propertyConditionsRow->toArray());
// PROPERTY OFFERS
echo ' ' . $tab . $tab . 'Installing special offers ';
$propertyOffersRow = null;
$propertyOffersRow = $propertyOffers->createRow();
$propertyOffersRow->property_id = $propertyRow->property_id;
$propertyOffersRow->description = $propertyDefinition->offers;
$propertyOffers->delete('property_id=' . $propertyConditionsRow->property_id);
$propertyOffers->insert($propertyOffersRow->toArray());
$accommodation->delete('property_id=' . $propertyRow->property_id);
foreach ($propertyDefinition->accommodations as $accommodationDefinition)
{
$accomm_id++;
echo ' ' . $tab . $tab . 'Installing accommodation ' . $accomm_id . ' - ' . $accommodationDefinition->description;
$accommodationRow = null;
$accommodationRow = $accommodation->createRow();
$accommodationRow->accomm_id = $accomm_id;
$accommodationRow->property_id = $propertyRow->property_id;
$accommodationRow->description = $accommodationDefinition->description;
$accommodationRow->max_occupancy = $accommodationDefinition->max_occupancy;
$accommodationRow->full_pyt_deadline = $accommodationDefinition->full_pyt_deadline;
$accommodationRow->url = $accommodationDefinition->url;
$accommodationRow->notes = $accommodationDefinition->notes;
$accommodationRow->live_flag = $accommodationDefinition->live_flag;
$accommodation->insert($accommodationRow->toArray());
// ACCOMMODATION DETAILS
$accommDetails->delete('accomm_id=' . $accommodationRow->accomm_id);
foreach ($accommodationDefinition->accommodation_details as $detailsDefinition)
{
echo ' ' . $tab . $tab . 'Installing detail ' . $detailsDefinition->detail_id;
$accommDetailsRow = null;
$accommDetailsRow = $accommDetails->createRow();
$accommDetailsRow->detail_id = $bookableDetailsArray[$detailsDefinition->detail_id];
$accommDetailsRow->accomm_id = $accommodationRow->accomm_id;
$accommDetailsRow->cost = $detailsDefinition->cost;
$accommDetailsRow->max_no = $detailsDefinition->max_no;
$accommDetailsRow->start_date = DATE_TODAY;
$accommDetailsRow->end_date = null;
$accommDetails->insert($accommDetailsRow->toArray());
}
// DURATION PRICE
$durationPrice->delete('accomm_id=' . $accommodationRow->accomm_id);
foreach ($accommodationDefinition->duration_prices as $pricesDefinition)
{
echo ' ' . $tab . $tab . 'Installing duration_price ' . $pricesDefinition->detail_id;
$durationPriceRow = null;
$durationPriceRow = $durationPrice->createRow();
$durationPriceRow->accomm_id = $accommodationRow->accomm_id;
$durationPriceRow->client_season_id = $pricesDefinition->client_season_id;
$durationPriceRow->duration = $pricesDefinition->duration;
$durationPriceRow->start_date = DATE_TODAY;
$durationPriceRow->end_date = null;
$durationPriceRow->changeover_day = $pricesDefinition->changeover_day;
$durationPriceRow->cost = $pricesDefinition->cost;
$durationPriceRow->daily_rate_flag = $pricesDefinition->daily_rate_flag;
$durationPrice->insert($durationPriceRow->toArray());
}
}
}
} else {
echo ' ' . $tab . '** No property to install** ';
}
}
}
}
}
closedir($handle);
}
/*
$db = Zend_Db_Table::getDefaultAdapter();
// Set up demo CLIENTS;
$clientArray = $this->clients(); //array (
$client = new Client();
$user = new User();
foreach ($clientArray as $clientDetails)
{
// CLIENT
$row = $client->createRow();
$row->setFromArray($clientDetails);
$client->delete('client_id='.$row->client_id);
$row->save();
// USER
$row = $user->createRow();
$row->client_id = $clientDetails['client_id'];
$row->setFromArray($clientDetails['userDetails']);
$user->delete('user_id='.$row->user_id);
$row->save();
}
*/
}
/**
* Populate the database with all reference/lookup data.
*
* @return void
*/
private function installReferenceData($tab)
{
echo ' -------------------------------------------------------------------';
echo ' Installing REFERENCE DATA ';
$path=APPLICATION_PATH . '/config/install/reference_data';
if ($handle = opendir($path))
{
// Loop over the ref data configuration files directory
while (false !== ($file = readdir($handle)))
{
if (!is_dir($file))
{
$filenameAsArray = explode('.', $file);
if (count($filenameAsArray) > 1)
{
if ($filenameAsArray[1] != 'xml')
{
continue;
}
$tableName = $filenameAsArray[0];
echo ' ' . $tab . 'Installing ' . $tableName;
$fullPath = $path . '/' . $file;
$config = new Zend_Config_Xml ($fullPath);
$where = $config->delete_where_clause;
if ($where == '')
{
echo " ** " . $tableName . " FAILED! No 'where' clause supplied for the delete. ** ";
exit;
} else {
$table = new $tableName ();
$table->delete($where);
}
foreach ($config->rows as $dataDefinition)
{
$row = $table->createRow($dataDefinition->toArray());
$table->insert($row->toArray());
}
}
}
}
$this->installCalendar($tab);
}
}
/**
* Populate the calendar table with 5 years worth of dates.
*
* @return void
*/
private function installCalendar($tab)
{
// INSERT 5 years worth of dates.
$db = Zend_Db_Table::getDefaultAdapter();
// Get the start of the current month
$startCurrMonth = date("Y-m-01",strtotime(DATE_TODAY));
// Get start of previous month - final calendar display needs this
$query="SELECT DATE_SUB('" . $startCurrMonth . "', INTERVAL 1 month) as startDate";
$row=$db->fetchRow($query);
$startDate=$row['startDate'];
// Get the date 'n' years on from that.
$years=5;
$query="SELECT DATE_ADD('" . $startDate ."', INTERVAL $years year) as endDate";
$row=$db->fetchRow($query);
$endDate=$row['endDate'];
// HOW MANY DAYS BETWEEN NOW AND THEN?
$query="SELECT DATEDIFF('" . $endDate . "','" . $startDate . "') as days";
$row=$db->fetchRow($query);
$days=$row['days'];
echo ' Inserting ' . $years . ' years worth of dates from ' . $startDate;
$db->delete('Calendar');
for($i=0;$i<$days;$i++)
{
$result = $db->getConnection()->exec("INSERT INTO Calendar (date) VALUES (date_add('". $startDate ."' ,INTERVAL " . $i . " DAY))" );
}
}
}

Documentation generated on Fri, 27 Mar 2009 13:48:37 +0000 by phpDocumentor 1.4.1

Source for file InstallController.php