$db2->runSQL($sqlTime);
while ($row2 = $db2->retrieveRow()) {
$scheduleBlock = $row2['schedule_block'];
// echo $scheduleBlock . " | ";
// create an entry in cim_sch_timeblocks for all the timeblock
$sqlBlock = "INSERT INTO cim_sch_scheduleblocks (schedule_id, scheduleBlocks_timeblock) VALUES ( " . $scheduleID . "," . $scheduleBlock . " )";
$db1->runSQL($sqlBlock);
}
echo "Inserted schedule block for personID[" . $personID . "]<br/>";
}
// while
// echo "<pre>".print_r($_POST, true)."</pre>";
if (isset($_POST['Process'])) {
echo '<p>Your name will be entered in the draw.</p>';
echo 'Name: <b>' . $_POST['name'] . '</b><br/>';
echo 'Email: <b>' . $_POST['email'] . '</b><br/>';
$db = new Database_MySQL();
$db->connectToDB(SPT_DB_NAME, SPT_DB_HOST, SPT_DB_USER, SPT_DB_PWD);
$sql = 'INSERT INTO 08_staff_survey (survey_name, survey_email) VALUES ("' . $_POST['name'] . '", "' . $_POST['email'] . '")';
$db->runSQL($sql);
} else {
echo "<p>Thanks for filling out the C4C Staff Survey. Please enter your name and email to enter the draw for 25,000 Aeroplan miles. Your name and email are in no way connected to your survey response.</p>";
echo '<form name="draw" method="post">';
echo 'Name: <input name="name" type="text" /><br/>';
echo 'Email: <input name="email" type="text" /><br/>';
echo '<br/>';
echo '<input type="submit"/ value="Submit">';
echo '<input name="Process" type="hidden" id="Process" value="T" />';
echo '</form>';
}
echo "<p>If you experience technical difficulties, please contact russ.martin@c4c.ca.</p>";
<?php
require_once '../../../php5/objects/SiteObject.php';
require_once '../../../php5/objects/Database.php';
$db = new Database_MySQL();
$db->connectToDB('ciministry_development', 'localhost', 'spt', 'cIm777');
$WEEK = 3;
// = freq_id
$commaList = '';
$firstDate = '2007-12-30';
$date = $firstDate;
$weekDesc = 'Week 1 of 2008';
$j = 2;
for ($i = 0; $i < 200; $i++) {
// $sql = 'insert into p2c_stats_freqvalue set freqvalue_value ="'.$date.'" and freq_id ='.$WEEK.' and freqvalue_desc="'.$weekDesc.'";';
$sql = 'insert into p2c_stats_freqvalue values ("", ' . $WEEK . ',"' . $date . '","' . $weekDesc . '");';
$time = strtotime($date);
$new_time = mktime(0, 0, 0, date('m', $time), date('d', $time) + 7, date('Y', $time));
$date = date("Y-m-d", $new_time);
if ($j == 53) {
$j = 1;
$new_year = mktime(0, 0, 0, date('m', $time), date('d', $time), date('Y', $time) + 1);
$weekDesc = 'Week ' . $j . ' of ' . date('Y', $new_year);
} else {
$weekDesc = 'Week ' . $j . ' of ' . date('Y', $new_time);
}
echo $sql . '<br/>';
$db->runSQL($sql);
$j++;
}
/**
* function getBasePriceForRegistrant
* <pre>
* Returns registration cost for a particular registration, not including scholarship discounts
* </pre>
* Pre-condition: all variables must be initialized with proper values
*
* @param $regID [INTEGER] registration ID
* @param $eventID [INTEGER] event ID
* @param $campusID [INTEGER] campus ID (precondition: must be associated directly with registration ID)
* @param $eventBasePrice [INTEGER] the cost of the event per registration, before any discounts
* @param $priceRulesArray [ARRAY] an array of the price rules applying to event denoted by $eventID
* @param &$rulesApplied [ARRAY REFERENCE] reference to an array to be filled with applied rules
* @return [INTEGER] $basePriceForThisGuy the new base price for registration $regID (before scholarships)
*/
function getBasePriceForRegistrant($regID, $eventID, $campusID, $eventBasePrice, $priceRulesArray, &$rulesApplied = array())
{
// Need to manually calculate discounts for these exceptions:
$BC_SUMMIT_2007 = 19;
$MB_SUMMIT_2007 = 22;
$LAKESHORE_SUMMIT_2007 = 25;
$EASTERN_WC_2007 = 28;
$AIA_NATIONAL_TRAINING = 33;
$MARITIMES_SUMMIT_2008 = 34;
$basePriceForThisGuy = $eventBasePrice;
// echo "<pre>".print_r($priceRulesArray,true)."</pre>";
// PUT SPECIAL EVENT EXCEPTIONS HERE AS CONDITIONAL STATEMENTS:
/* if ($eventID == $MARITIMES_SUMMIT_2008)
{
$FROSH_DISCOUNT_FIELD = 119;
// first check for Frosh Discount
$fieldValue = new RowManager_FieldValueManager();
// $fieldValue->loadByFieldIDandRegID($rule['fields_id'],$regID);
$fieldValue->setFieldID($FROSH_DISCOUNT_FIELD);
$fieldValue->setRegID($regID);
$valueListManager = $fieldValue->getListIterator();
$fieldValueList = $valueListManager->getDataList();
// echo "<pre>".print_r($fieldValueList,true)."</pre>";
reset($fieldValueList);
$record = current($fieldValueList);
// CHECK TO SEE IF SOME FIELD VALUE HAS BEEN SET FOR GIVEN PARAMETERS
// $userValue = '';
$userValue = $record['fieldvalues_value']; // $fieldValue->getFieldValue();
if ((isset($userValue))&&($userValue != ''))
{
// DETERMINE WHETHER PRICE RULE VALUE IS EQUIVALENT TO CURRENT FIELD VALUE
if ( $userValue == '1')
{
// form criteria is met, apply the discount/penalty
// $basePriceForThisGuy -= 15; // subtract $15 from $65 event base cost
$basePriceForThisGuy = 50; // frosh cost
$rulesApplied[] = $priceRulesArray['45'];
return $basePriceForThisGuy;
}
}
// if no frosh discount, THEN apply early bird discount (if conditions met)
// echo "DATE RULE<BR>";
// get the user's registration date
$registration = new RowManager_RegistrationManager();
$registration->setRegID($regID);
$regListManager = $registration->getListIterator();
$regArray = $regListManager->getDataList();
// echo "<pre>".print_r($registration,true)."</pre>";
// set default date-time
$regTime = '';
// retrieve registration date
reset($regArray);
$record = current($regArray); // should be only 1 record for regID
$regTime = $record['registration_date'];
// $regTime = $registration->getRegistrationDate();
if ($regTime != '')
{
// if the registrant signed up before a deadline, apply the rule
if ( strtotime($regTime) < strtotime( '2008-04-01' ) ) //$rule['pricerules_value']
{
// date criteria is met, apply the discount/penalty
// $basePriceForThisGuy -= 15; // apply early bird discount to $65 event base cost to get $50
$basePriceForThisGuy = 50;
$rulesApplied[] = $priceRulesArray['47'];
return $basePriceForThisGuy;
}
}
return $basePriceForThisGuy; // otherwise return unaltered base event cost ($125)
} */
if ($eventID == $AIA_NATIONAL_TRAINING) {
$FOOD_PASS_REQ_FIELD = 102;
$HOUSING_REQ_FIELD = 103;
// first check for Food Pass Fee
$fieldValue = new RowManager_FieldValueManager();
// $fieldValue->loadByFieldIDandRegID($rule['fields_id'],$regID);
$fieldValue->setFieldID($FOOD_PASS_REQ_FIELD);
$fieldValue->setRegID($regID);
$valueListManager = $fieldValue->getListIterator();
$fieldValueList = $valueListManager->getDataList();
// echo "<pre>".print_r($fieldValueList,true)."</pre>";
reset($fieldValueList);
$record = current($fieldValueList);
// CHECK TO SEE IF SOME FIELD VALUE HAS BEEN SET FOR $FOOD_PASS_REQ_FIELD
// $userValue = '';
$userValue = $record['fieldvalues_value'];
// $fieldValue->getFieldValue();
if (isset($userValue) && $userValue != '') {
/** Get the user's registration date **/
$registration = new RowManager_RegistrationManager();
$registration->setRegID($regID);
$regListManager = $registration->getListIterator();
$regArray = $regListManager->getDataList();
// echo "<pre>".print_r($registration,true)."</pre>";
// set default date-time
$regTime = '';
// retrieve registration date-time
reset($regArray);
$record = current($regArray);
// should be only 1 record for regID
$regTime = $record['registration_date'];
// DETERMINE WHETHER PRICE RULE VALUE IS EQUIVALENT TO CURRENT FIELD VALUE
if ($userValue == '1') {
// form criteria is met, apply the discount/penalty
// $basePriceForThisGuy += 100; // add 150 to base 260 event price
$basePriceForThisGuy += 150;
$rulesApplied[] = $priceRulesArray['39'];
// Apply early-bird discount on this if applicable
if ($regTime != '') {
// if the registrant signed up before a deadline, apply the rule
if (strtotime($regTime) < strtotime('2008-04-16')) {
$basePriceForThisGuy -= 50;
// subtract 50
$rulesApplied[] = $priceRulesArray['42'];
}
}
}
}
// second check for Housing Fee
$fieldValue = new RowManager_FieldValueManager();
// $fieldValue->loadByFieldIDandRegID($rule['fields_id'],$regID);
$fieldValue->setFieldID($HOUSING_REQ_FIELD);
$fieldValue->setRegID($regID);
$valueListManager = $fieldValue->getListIterator();
$fieldValueList = $valueListManager->getDataList();
// echo "<pre>".print_r($fieldValueList,true)."</pre>";
reset($fieldValueList);
$record = current($fieldValueList);
// CHECK TO SEE IF SOME FIELD VALUE HAS BEEN SET FOR $HOUSING_REQ_FIELD
// $userValue = '';
$userValue = $record['fieldvalues_value'];
// $fieldValue->getFieldValue();
if (isset($userValue) && $userValue != '') {
/** Get the user's registration date **/
$registration = new RowManager_RegistrationManager();
$registration->setRegID($regID);
$regListManager = $registration->getListIterator();
$regArray = $regListManager->getDataList();
// echo "<pre>".print_r($registration,true)."</pre>";
// set default date-time
$regTime = '';
// retrieve registration date-time
reset($regArray);
$record = current($regArray);
// should be only 1 record for regID
$regTime = $record['registration_date'];
// DETERMINE WHETHER PRICE RULE VALUE IS EQUIVALENT TO CURRENT FIELD VALUE
if ($userValue == '1') {
// form criteria is met, apply the discount/penalty
// $basePriceForThisGuy += 180; // add 230 to base 260 event price
$basePriceForThisGuy += 230;
$rulesApplied[] = $priceRulesArray['41'];
// Apply early-bird discount on this if applicable
if ($regTime != '') {
// if the registrant signed up before a deadline, apply the rule
if (strtotime($regTime) < strtotime('2008-04-16')) {
$basePriceForThisGuy -= 50;
// subtract 50
$rulesApplied[] = $priceRulesArray['42'];
}
}
return $basePriceForThisGuy;
}
}
return $basePriceForThisGuy;
// otherwise return unaltered base event cost ($125)
}
if ($eventID == $EASTERN_WC_2007) {
$COMMUTER_DISCOUNT_FIELD = 86;
// first check for Frosh Discount
$fieldValue = new RowManager_FieldValueManager();
// $fieldValue->loadByFieldIDandRegID($rule['fields_id'],$regID);
$fieldValue->setFieldID($COMMUTER_DISCOUNT_FIELD);
$fieldValue->setRegID($regID);
$valueListManager = $fieldValue->getListIterator();
$fieldValueList = $valueListManager->getDataList();
// echo "<pre>".print_r($fieldValueList,true)."</pre>";
reset($fieldValueList);
$record = current($fieldValueList);
// CHECK TO SEE IF SOME FIELD VALUE HAS BEEN SET FOR GIVEN PARAMETERS
// $userValue = '';
$userValue = $record['fieldvalues_value'];
// $fieldValue->getFieldValue();
if (isset($userValue) && $userValue != '') {
// DETERMINE WHETHER PRICE RULE VALUE IS EQUIVALENT TO CURRENT FIELD VALUE
if ($userValue == '1') {
// form criteria is met, apply the discount/penalty
// $basePriceForThisGuy -= 80; // subtract $80 from $279 event base cost
$basePriceForThisGuy = 199;
// commuter cost
$rulesApplied[] = $priceRulesArray['38'];
return $basePriceForThisGuy;
}
}
// if no commuter discount, THEN apply early bird discount (if conditions met)
// echo "DATE RULE<BR>";
// get the user's registration date
$registration = new RowManager_RegistrationManager();
$registration->setRegID($regID);
$regListManager = $registration->getListIterator();
$regArray = $regListManager->getDataList();
// echo "<pre>".print_r($registration,true)."</pre>";
// set default date-time
$regTime = '';
// retrieve registration date
reset($regArray);
$record = current($regArray);
// should be only 1 record for regID
$regTime = $record['registration_date'];
// $regTime = $registration->getRegistrationDate();
if ($regTime != '') {
// if the registrant signed up before a deadline, apply the rule
if (strtotime($regTime) < strtotime('2007-12-01')) {
if (strtotime($regTime) < strtotime('2007-10-09')) {
// date criteria is met, apply the discount/penalty
// $basePriceForThisGuy -= 50; // apply early bird discounts to $279 event base cost to get $229
$basePriceForThisGuy = 229;
$rulesApplied[] = $priceRulesArray['37'];
$rulesApplied[] = $priceRulesArray['36'];
return $basePriceForThisGuy;
} else {
// date criteria is met, apply the discount/penalty
// $basePriceForThisGuy -= 50; // apply regular discount to $279 event base cost to get $259
$basePriceForThisGuy = 259;
$rulesApplied[] = $priceRulesArray['36'];
return $basePriceForThisGuy;
}
}
}
return $basePriceForThisGuy;
// otherwise return unaltered base event cost ($125)
}
// PUT SPECIAL EVENT EXCEPTIONS HERE AS CONDITIONAL STATEMENTS:
if ($eventID == $BC_SUMMIT_2007) {
$FROSH_DISCOUNT_FIELD = 54;
// first check for Frosh Discount
$fieldValue = new RowManager_FieldValueManager();
// $fieldValue->loadByFieldIDandRegID($rule['fields_id'],$regID);
$fieldValue->setFieldID($FROSH_DISCOUNT_FIELD);
$fieldValue->setRegID($regID);
$valueListManager = $fieldValue->getListIterator();
$fieldValueList = $valueListManager->getDataList();
// echo "<pre>".print_r($fieldValueList,true)."</pre>";
reset($fieldValueList);
$record = current($fieldValueList);
// CHECK TO SEE IF SOME FIELD VALUE HAS BEEN SET FOR GIVEN PARAMETERS
// $userValue = '';
$userValue = $record['fieldvalues_value'];
// $fieldValue->getFieldValue();
if (isset($userValue) && $userValue != '') {
// DETERMINE WHETHER PRICE RULE VALUE IS EQUIVALENT TO CURRENT FIELD VALUE
if ($userValue == '1') {
// form criteria is met, apply the discount/penalty
// $basePriceForThisGuy -= 46; // subtract $46 from $125 event base cost
$basePriceForThisGuy = 79;
// frosh cost
$rulesApplied[] = $priceRulesArray['14'];
return $basePriceForThisGuy;
}
}
// if no frosh discount, THEN apply early bird discount (if conditions met)
// echo "DATE RULE<BR>";
// get the user's registration date
$registration = new RowManager_RegistrationManager();
$registration->setRegID($regID);
$regListManager = $registration->getListIterator();
$regArray = $regListManager->getDataList();
// echo "<pre>".print_r($registration,true)."</pre>";
// set default date-time
$regTime = '';
// retrieve registration date
reset($regArray);
$record = current($regArray);
// should be only 1 record for regID
$regTime = $record['registration_date'];
// $regTime = $registration->getRegistrationDate();
if ($regTime != '') {
// if the registrant signed up before a deadline, apply the rule
if (strtotime($regTime) < strtotime('2007-09-21')) {
// date criteria is met, apply the discount/penalty
// $basePriceForThisGuy -= 26; // apply early bird discount to $125 event base cost to get $99
$basePriceForThisGuy = 99;
$rulesApplied[] = $priceRulesArray['15'];
return $basePriceForThisGuy;
}
}
return $basePriceForThisGuy;
// otherwise return unaltered base event cost ($125)
}
if ($eventID == $MB_SUMMIT_2007) {
$FROSH_DISCOUNT_FIELD = 60;
$FROSH_VOLUME_THRESHOLD = 20;
$MB_EARLY_FROSH_TABLE = 'temp_mb_early_frosh';
// first check for Frosh Discount
$fieldValue = new RowManager_FieldValueManager();
// $fieldValue->loadByFieldIDandRegID($rule['fields_id'],$regID);
$fieldValue->setFieldID($FROSH_DISCOUNT_FIELD);
$fieldValue->setRegID($regID);
$valueListManager = $fieldValue->getListIterator();
$fieldValueList = $valueListManager->getDataList();
// echo "<pre>".print_r($fieldValueList,true)."</pre>";
reset($fieldValueList);
$record = current($fieldValueList);
// CHECK TO SEE IF SOME FIELD VALUE HAS BEEN SET FOR GIVEN PARAMETERS
// $userValue = '';
$userValue = $record['fieldvalues_value'];
// $fieldValue->getFieldValue();
if (isset($userValue) && $userValue != '') {
// DETERMINE WHETHER PRICE RULE VALUE IS EQUIVALENT TO CURRENT FIELD VALUE
if ($userValue == '1') {
// check if there are 20 or more frosh already stored
$froshValues = new RowManager_FieldValueManager();
$froshValues->setFieldID($FROSH_DISCOUNT_FIELD);
$froshValues->setFieldValue('1');
// 1 = checked checkbox
$fieldsManager = new MultiTableManager();
$fieldsManager->addRowManager($froshValues);
// TODO: sub-query like 'SELECT <ALL FIELD VALUES FOR SPECIFIC FROSH DISCOUNT> WHERE REG_ID IN (SELECT ALL REGISTRATIONS FOR EVENT)'
$regs = new RowManager_RegistrationManager();
$regs->setEventID($eventID);
$regData = new MultiTableManager();
$regData->addRowManager($regs);
$regData->setFieldList('registration_id');
$registered_SQL = $regData->createSQL();
// actually creates the sub-query in order to get an accurate count of discount field values stored
$negateSubQuery = false;
$addSubQuery = true;
$fieldsManager->constructSubQuery('registration_id', $registered_SQL, $negateSubQuery, $addSubQuery);
// $froshValues->setSortOrder('registration_id');
$froshList = $fieldsManager->getListIterator();
$froshArray = array();
$froshArray = $froshList->getDataList();
// echo "COUNT = ".count($froshArray);
if (count($froshArray) <= $FROSH_VOLUME_THRESHOLD) {
// form criteria is met, apply the discount/penalty
// $basePriceForThisGuy -= 25; // subtract $46 from $125 event base cost
$basePriceForThisGuy = 40;
// frosh cost
$rulesApplied[] = $priceRulesArray['25'];
$db = new Database_MySQL();
$db->connectToDB(SITE_DB_NAME, SITE_DB_PATH, SITE_DB_USER, SITE_DB_PWORD);
// precaution that avoids duplicates
$sql = "DELETE FROM " . $MB_EARLY_FROSH_TABLE . " WHERE registration_id = " . $regID;
$db->runSQL($sql);
$sql = "INSERT INTO " . $MB_EARLY_FROSH_TABLE . " (registration_id) VALUES (" . $regID . ")";
$db->runSQL($sql);
} else {
$db = new Database_MySQL();
$db->connectToDB(SITE_DB_NAME, SITE_DB_PATH, SITE_DB_USER, SITE_DB_PWORD);
$sql = "SELECT * FROM " . $MB_EARLY_FROSH_TABLE . " WHERE registration_id = " . $regID;
$db->runSQL($sql);
$temp_regID = '';
if ($row = $db->retrieveRow()) {
$temp_regID = $row['registration_id'];
}
// apply rule despite there being >20 frosh because this registration existed before cut-off
if ($regID == $temp_regID) {
// $basePriceForThisGuy -= 25; // subtract $25 from $85 event base cost
$basePriceForThisGuy = 40;
// frosh cost
$rulesApplied[] = $priceRulesArray['25'];
} else {
$basePriceForThisGuy = 60;
// basic frosh cost
$rulesApplied[] = $priceRulesArray['28'];
}
}
return $basePriceForThisGuy;
}
}
return $basePriceForThisGuy;
// otherwise return unaltered base event cost ($85)
}
if ($eventID == $LAKESHORE_SUMMIT_2007) {
$FROSH_DISCOUNT_FIELD = 64;
// first check for Frosh Discount
$fieldValue = new RowManager_FieldValueManager();
// $fieldValue->loadByFieldIDandRegID($rule['fields_id'],$regID);
$fieldValue->setFieldID($FROSH_DISCOUNT_FIELD);
$fieldValue->setRegID($regID);
$valueListManager = $fieldValue->getListIterator();
$fieldValueList = $valueListManager->getDataList();
// echo "<pre>".print_r($fieldValueList,true)."</pre>";
reset($fieldValueList);
$record = current($fieldValueList);
// CHECK TO SEE IF SOME FIELD VALUE HAS BEEN SET FOR GIVEN PARAMETERS
// $userValue = '';
$userValue = $record['fieldvalues_value'];
// $fieldValue->getFieldValue();
if (isset($userValue) && $userValue != '') {
// DETERMINE WHETHER PRICE RULE VALUE IS EQUIVALENT TO CURRENT FIELD VALUE
if ($userValue == '1') {
// form criteria is met, apply the discount/penalty
// $basePriceForThisGuy -= <varies>; // subtract <varying amount> from $120/$115/$110/$105 to get $75
$basePriceForThisGuy = 75;
// frosh cost
$rulesApplied[] = $priceRulesArray['19'];
return $basePriceForThisGuy;
}
}
// if no frosh discount, THEN apply early bird discount (if conditions met)
// echo "DATE RULE<BR>";
// get the user's registration date
$registration = new RowManager_RegistrationManager();
$registration->setRegID($regID);
$regListManager = $registration->getListIterator();
$regArray = $regListManager->getDataList();
// echo "<pre>".print_r($registration,true)."</pre>";
// set default date-time
$regTime = '';
// retrieve registration date
reset($regArray);
$record = current($regArray);
// should be only 1 record for regID
$regTime = $record['registration_date'];
// $regTime = $registration->getRegistrationDate();
if ($regTime != '') {
// if the registrant signed up before a deadline, apply the rule
if (strtotime($regTime) < strtotime('2007-09-26')) {
// date criteria is met, apply the discount/penalty
// $basePriceForThisGuy -= 15; // apply early bird discount to $115 event base cost to get $105
$basePriceForThisGuy = 105;
$rulesApplied[] = $priceRulesArray['20'];
return $basePriceForThisGuy;
}
}
return $basePriceForThisGuy;
// otherwise return unaltered base event cost ($120)
}
/**** END OF RULE EXCEPTIONS ****/
// apply any price rules
foreach ($priceRulesArray as $key => $rule) {
$ruleType = $rule['priceruletypes_id'];
// form attribute rule: apply price rule based on whether some form field value exists (i.e. frosh discount)
if ($ruleType == RowManager_PriceRuleTypeManager::FORM_ATTRIBUTE_RULE) {
// echo "FORM RULE<BR>";
// get the user's input for this form attribute
$fieldValue = new RowManager_FieldValueManager();
// $fieldValue->loadByFieldIDandRegID($rule['fields_id'],$regID);
$fieldValue->setFieldID($rule['fields_id']);
$fieldValue->setRegID($regID);
$valueListManager = $fieldValue->getListIterator();
$fieldValueList = $valueListManager->getDataList();
// echo "<pre>".print_r($fieldValueList,true)."</pre>";
reset($fieldValueList);
$record = current($fieldValueList);
// CHECK TO SEE IF SOME FIELD VALUE HAS BEEN SET FOR GIVEN PARAMETERS
// $userValue = '';
$userValue = $record['fieldvalues_value'];
// $fieldValue->getFieldValue();
if (isset($userValue) && $userValue != '') {
// DETERMINE WHETHER PRICE RULE VALUE IS EQUIVALENT TO CURRENT FIELD VALUE
if ($rule['pricerules_value'] == $userValue) {
// form criteria is met, apply the discount/penalty
$basePriceForThisGuy += $rule['pricerules_discount'];
$rulesApplied[] = $rule;
}
}
} else {
if ($ruleType == RowManager_PriceRuleTypeManager::DATE_RULE) {
// echo "DATE RULE<BR>";
// get the user's registration date
$registration = new RowManager_RegistrationManager();
$registration->setRegID($regID);
$regListManager = $registration->getListIterator();
$regArray = $regListManager->getDataList();
// echo "<pre>".print_r($registration,true)."</pre>";
// set default date-time
$regTime = '';
// retrieve registration date
reset($regArray);
$record = current($regArray);
// should be only 1 record for regID
$regTime = $record['registration_date'];
// $regTime = $registration->getRegistrationDate();
if ($regTime != '') {
// if the registrant signed up before a deadline, apply the rule
if (strtotime($regTime) < strtotime($rule['pricerules_value'])) {
// date criteria is met, apply the discount/penalty
$basePriceForThisGuy += $rule['pricerules_discount'];
$rulesApplied[] = $rule;
}
}
} else {
if ($ruleType == RowManager_PriceRuleTypeManager::VOLUME_RULE) {
$volumeNeeded = $rule['pricerules_value'];
// $correctCampus = false;
// $pattern = RowManager_PriceRuleTypeManager::CAMPUS_VOLUME_REGEX;
// $numMatches = preg_match($pattern, $rule['pricerules_value']);
// if ($numMatches > 0)
// {
//
// $pricingValues = explode('|',$rule['pricerules_value']);
// // echo '<pre>'.print_r($pricingValues,true).'</pre>';
// // echo 'campus = '.$pricingValues[0].' cut-off = '.$pricingValues[1];
// if ((int)$pricingValues[0] == $campusID)
// {
// $correctCampus = true;
// $volumeNeeded = $pricingValues[1];
//
// /* if ($numRegistrantsMyCampus != '')
// {
// // if the # of registrants >= the bulk discount value...
// if ( $numRegistrantsMyCampus >= $pricingValues[1] )
// {
// // bulk discount criteria is met, apply the discount/penalty
// $basePriceForThisGuy += $rule['pricerules_discount'];
//
// $rulesApplied[] = $rule;
// }
// }
// else // try to calculate the # of registrants on our own
// {
// */
//
// /** }
// **/
// }
// }
//
// // check volume rule if no specific campus associated or current campus is associated with rule
// if (($numMatches == 0)||($correctCampus == true))
// {
if (isset($campusID) && $campusID != '') {
// get total registrations for specific campus and particular event
$total = array();
$summary = new RegSummaryTools();
$total = $summary->getCampusRegistrations($eventID, '', false, $campusID, '', RowManager_RegistrationManager::STATUS_REGISTERED);
if (isset($total[$campusID])) {
$numRegistrantsMyCampus = $total[$campusID];
} else {
$numRegistrantsMyCampus = 0;
}
if (count($total) > 0) {
// if the # of registrants >= the bulk discount value...
if ($numRegistrantsMyCampus >= $volumeNeeded) {
// bulk discount criteria is met, apply the discount/penalty
$basePriceForThisGuy += $rule['pricerules_discount'];
$rulesApplied[] = $rule;
}
}
} else {
// should not occur, this function meant to be used with campusID set
}
} else {
if ($ruleType == RowManager_PriceRuleTypeManager::CAMPUS_RULE) {
// echo "CAMPUS RULE<BR>";
// check the campus ID against the one stored in the price rules table
if ($campusID == $rule['pricerules_value']) {
$basePriceForThisGuy += $rule['pricerules_discount'];
$rulesApplied[] = $rule;
}
} else {
die('unknown ruletype[' . $ruleType . ']');
}
}
}
}
}
// foreach rule
// special hack for Eastern Ontario/Montreal summit 2006
/* if ( $eventID == 4 )
{
$basePriceForThisGuy = getBasePriceEasternSummit2006( $regID, $numRegistrantsMyCampus, $rulesApplied );
}
else if ( $eventID == 11 )
{
$basePriceForThisGuy = getBasePricePrairieSummit2006( $regID, $campusID, $numRegistrantsMyCampus, $rulesApplied );
}
*/
return $basePriceForThisGuy;
}
<?php
require_once '../../../php5/objects/SiteObject.php';
require_once '../../../php5/objects/Database.php';
$db = new Database_MySQL();
$db->connectToDB('site', 'localhost', 'root', 'jimbo111');
$commaList = '';
$firstDate = '2006-06-10';
$date = $firstDate;
for ($i = 0; $i < 200; $i++) {
$sql = 'insert into cim_stats_week set week_endDate="' . $date . '";';
$time = strtotime($date);
$date = date("Y-m-d", mktime(0, 0, 0, date('m', $time), date('d', $time) + 7, date('Y', $time)));
echo $sql . '<br/>';
$db->runSQL($sql);
}
