public function executeDelete()
{
$event = EventPeer::retrieveByPK($this->getRequestParameter('event_id'));
$c = new Criteria();
$c->add(RegFormPeer::EVENT_ID, $event->getId());
RegFormPeer::doDelete($c);
return $this->redirect('@show_event?slug=' . $event->getSlug());
}
function remove($sUID)
{
$oConnection = Propel::getConnection(EventPeer::DATABASE_NAME);
try {
$oEvent = EventPeer::retrieveByPK($sUID);
if (!is_null($oEvent)) {
/* with the new feature for events, a event can to relate a existing trigger
or more of one events can be reusing the same trigger
so, in this point we should't to delete the trigger
$oConnection->begin();
$oTrigger = new Triggers();
$oAppEvent = new AppEvent();
$oCriteria = new Criteria('workflow');
$oCriteria->clearSelectColumns();
$oCriteria->addSelectColumn( AppEventPeer::EVN_UID );
$oCriteria->addSelectColumn( EventPeer::TRI_UID );
$oCriteria->addSelectColumn( AppEventPeer::APP_UID );
$oCriteria->addSelectColumn( AppEventPeer::DEL_INDEX );
$oCriteria->add(AppEventPeer::EVN_UID, $sUID );
$oCriteria->addJoin(EventPeer::EVN_UID, AppEventPeer::EVN_UID, Criteria::JOIN);
$oDataset = AppEventPeer::doSelectRs($oCriteria);
$oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC);
$oDataset->next();
while ($row = $oDataset->getRow()) {
$oTrigger->remove($row['TRI_UID']);
$oAppEvent->remove( $row['APP_UID'], $row['DEL_INDEX'], $sUID );
$oDataset->next();
}*/
Content::removeContent('EVN_DESCRIPTION', '', $oEvent->getEvnUid());
$iResult = $oEvent->delete();
$oConnection->commit();
return $iResult;
} else {
throw new Exception('This row doesn\'t exist!');
}
} catch (Exception $oError) {
$oConnection->rollback();
throw $oError;
}
}
public function saveExtddEvents($oData)
{
$oTask = new Task();
$oEvent = new Event();
$sEvn_uid = '';
$aData = array();
$aData['PRO_UID'] = $oData->uid;
$aData['EVN_TYPE'] = $oData->evn_type;
$aData['EVN_POSX'] = $oData->position->x;
$aData['EVN_POSY'] = $oData->position->y;
$aData['EVN_STATUS'] = 'ACTIVE';
$aData['EVN_WHEN'] = '1';
$aData['EVN_ACTION'] = '';
if (preg_match("/Inter/", $aData['EVN_TYPE'])) {
$aData['EVN_RELATED_TO'] = 'MULTIPLE';
}
if (preg_match("/Start/", $aData['EVN_TYPE'])) {
$aData['EVN_RELATED_TO'] = 'MULTIPLE';
}
$sEvn_uid = $oData->evn_uid;
$oEventData = EventPeer::retrieveByPK($sEvn_uid);
if (is_null($oEventData)) {
$sEvn_uid = $oEvent->create($aData);
} else {
$aData['EVN_UID'] = $sEvn_uid;
$oEvent->update($aData);
}
$oEncode->uid = $sEvn_uid;
//$oJSON = new Services_JSON();
return Bootstrap::json_encode($oEncode);
//$oJSON->encode( $oEncode );
}
public function executeEventSignup(sfWebRequest $request)
{
$this->event = EventPeer::retrieveByPK($request->getParameter('id'));
}
public function getEvent($con = null)
{
if ($this->aEvent === null && $this->event_id !== null) {
include_once 'lib/model/om/BaseEventPeer.php';
$this->aEvent = EventPeer::retrieveByPK($this->event_id, $con);
}
return $this->aEvent;
}
/**
* Implementation for 'GET' method for Rest API
*
* @param mixed $evnUid Primary key
*
* @return array $result Returns array within multiple records or a single record depending if
* a single selection was requested passing id(s) as param
*/
protected function get($evnUid = null)
{
$result = array();
try {
$noArguments = true;
$argumentList = func_get_args();
foreach ($argumentList as $arg) {
if (!is_null($arg)) {
$noArguments = false;
}
}
if ($noArguments) {
$criteria = new Criteria('workflow');
$criteria->addSelectColumn(EventPeer::EVN_UID);
$criteria->addSelectColumn(EventPeer::PRO_UID);
$criteria->addSelectColumn(EventPeer::EVN_STATUS);
$criteria->addSelectColumn(EventPeer::EVN_WHEN_OCCURS);
$criteria->addSelectColumn(EventPeer::EVN_RELATED_TO);
$criteria->addSelectColumn(EventPeer::TAS_UID);
$criteria->addSelectColumn(EventPeer::EVN_TAS_UID_FROM);
$criteria->addSelectColumn(EventPeer::EVN_TAS_UID_TO);
$criteria->addSelectColumn(EventPeer::EVN_TAS_ESTIMATED_DURATION);
$criteria->addSelectColumn(EventPeer::EVN_TIME_UNIT);
$criteria->addSelectColumn(EventPeer::EVN_WHEN);
$criteria->addSelectColumn(EventPeer::EVN_MAX_ATTEMPTS);
$criteria->addSelectColumn(EventPeer::EVN_ACTION);
$criteria->addSelectColumn(EventPeer::EVN_CONDITIONS);
$criteria->addSelectColumn(EventPeer::EVN_ACTION_PARAMETERS);
$criteria->addSelectColumn(EventPeer::TRI_UID);
$criteria->addSelectColumn(EventPeer::EVN_POSX);
$criteria->addSelectColumn(EventPeer::EVN_POSY);
$criteria->addSelectColumn(EventPeer::EVN_TYPE);
$criteria->addSelectColumn(EventPeer::TAS_EVN_UID);
$dataset = AppEventPeer::doSelectRS($criteria);
$dataset->setFetchmode(ResultSet::FETCHMODE_ASSOC);
while ($dataset->next()) {
$result[] = $dataset->getRow();
}
} else {
$record = EventPeer::retrieveByPK($evnUid);
if ($record) {
$result = $record->toArray(BasePeer::TYPE_FIELDNAME);
} else {
$paramValues = "";
foreach ($argumentList as $arg) {
$paramValues .= strlen($paramValues) ? ', ' : '';
if (!is_null($arg)) {
$paramValues .= "{$arg}";
} else {
$paramValues .= "NULL";
}
}
throw new RestException(417, "table Event ({$paramValues})");
}
}
} catch (RestException $e) {
throw new RestException($e->getCode(), $e->getMessage());
} catch (Exception $e) {
throw new RestException(412, $e->getMessage());
}
return $result;
}
$aData['TAS_EVN_UID'] = '';
$oTask->update($aData);
break;
case 'deleteStartEvent':
$aData['TAS_UID'] = $oData->tas_uid;
$aData['TAS_START'] = $oData->tas_start;
$aData['TAS_EVN_UID'] = '';
$oTask->update($aData);
if (isset($oData->evn_uid)) {
$oEvent->remove($oData->evn_uid);
}
break;
case 'updateEvent':
$aData['EVN_UID'] = $oData->evn_uid;
$aData['EVN_TYPE'] = $oData->evn_type;
$oEvent = EventPeer::retrieveByPK($aData['EVN_UID']);
if (!is_null($oEvent)) {
$oEvent->update($aData);
}
break;
case 'saveEvents':
$sOutput = $oProcessMap->saveExtEvents($oData);
echo $sOutput;
break;
case 'addEvent':
$sOutput = $oProcessMap->saveExtddEvents($oData);
echo $sOutput;
/*
$aData['PRO_UID'] = $oData->uid;
$aData['EVN_TYPE'] = $oData->tas_type;
$aData['EVN_STATUS'] = 'ACTIVE';
public function executeCheck(sfWebRequest $request)
{
$eventReservation = $this->getUser()->getAttribute('eventReservation');
$event = EventPeer::retrieveByPK($eventReservation['event_id']);
$card_number = $eventReservation['credit_card_no'];
$security_code = $eventReservation['security_code'];
//transection check
$month = $eventReservation['expiration_month'];
$year = $eventReservation['expiration_year'];
$cardnumber = str_replace('-', '', $card_number);
$ccardcode = $security_code;
//find out total amount
$adult_per_cost = $event->getAdultCost();
$child_per_cost = $event->getChildCost();
$adult_guests = $eventReservation['adult_guests'];
$child_guests = $eventReservation['child_guests'];
$total_adult_cost = $adult_per_cost * $adult_guests;
$total_child_cost = $child_per_cost * $child_guests;
$total = $adult_per_cost + $total_adult_cost + $total_child_cost;
//end total
$payment = new afids_paymentGateway();
$payment->gateway_name = "novapointe";
$payment->transaction_type = "sale";
$item_data = "&total=" . $total;
$item_data .= "&tax=" . 0;
$item_data .= "&bill_first_name=" . $eventReservation['first_name'];
$item_data .= "&bill_last_name=" . $eventReservation['last_name'];
$item_data .= "&bill_address1=" . $eventReservation['address'];
$item_data .= "&bill_city=" . $eventReservation['city'];
$item_data .= "&bill_state=" . $eventReservation['state'];
$item_data .= "&bill_zip=" . $eventReservation['zipcode'];
$item_data .= "&bill_country=" . $eventReservation['country'];
$item_data .= "&bill_phone=" . $eventReservation['phone'];
$item_data .= "&ccard=" . $cardnumber;
$item_data .= "&expmonth=" . $month;
$item_data .= "&expyear=" . $year;
$item_data .= "&cvv2=" . $ccardcode;
$payment->item_data = $item_data;
$payment->shipping_code = "USPS";
$data = json_decode($payment->submitPayment());
if ($data->http_result == 'success' && $data->transaction_result == 'success') {
# send email
$this->getComponent('mail', 'EventReservationSuccessMail', array('first_name' => $eventReservation['first_name'], 'email' => $eventReservation['email'], 'event_name' => $event->getEventName(), 'date' => $event->getEventDate(), 'time' => $event->getEventTime(), 'location' => $event->getLocation(), 'Adult_guest' => $eventReservation['adult_guests'], 'child_guest' => $eventReservation['child_guests'], 'total_amount' => $total));
//saving date to event_reservation table
$date = date();
//find out member
$query = "select member.id from member,person where member.person_id=person.id and person.first_name ='" . trim($eventReservation['first_name']) . "' and person.last_name='" . trim($eventReservation['last_name']) . "' and person.city='" . trim($eventReservation['city']) . "' and person.state='" . trim($eventReservation['state']) . "' and person.zipcode='" . trim($eventReservation['zipcode']) . "' and person.email='" . trim($eventReservation['email']) . "' limit 1";
$conn = Propel::getConnection();
$statement = $conn->prepare($query);
$statement->execute();
$row = $statement->fetch(PDO::FETCH_ASSOC);
if (!empty($row)) {
$member_id = $row['id'];
} else {
$member_id = NULL;
}
//end find member
$event_reservaton = new EventReservation();
$event_reservaton->setEventId($eventReservation['event_id']);
$event_reservaton->setMemberId($member_id);
$event_reservaton->setReservationDate($date);
$event_reservaton->setFirstName($eventReservation['first_name']);
$event_reservaton->setLastName($eventReservation['last_name']);
$event_reservaton->setAddress($eventReservation['address']);
$event_reservaton->setCity($eventReservation['city']);
$event_reservaton->setState($eventReservation['state']);
$event_reservaton->setZipcode($eventReservation['zipcode']);
$event_reservaton->setPhone($eventReservation['phone']);
$event_reservaton->setEmail($eventReservation['email']);
$event_reservaton->setAdultGuests($eventReservation['adult_guests']);
$event_reservaton->setChildGuests($eventReservation['child_guests']);
$event_reservaton->setGuestNames($eventReservation['guest_names']);
$event_reservaton->setAmtPaid($total);
$event_reservaton->setPaymentDate($date);
$event_reservaton->setAuthNumber($data->ccard_approval_number);
$event_reservaton->setStatus('success');
$event_reservaton->setNovapointeTransId($data->transaction_id);
$event_reservaton->save();
//decrement max person
$remaning_people = $event->getMaxPersons();
$remaning_people = $remaning_people - 1;
$event->setMaxPersons($remaning_people);
$event->save();
//end
//end of event event_reservation entry
$this->redirect('eventReservation/thankyou');
} else {
$this->getUser()->setFlash('warning', 'Event reservation Transaction failed. Please check your credit card information.');
$this->redirect('eventReservation/step3');
}
//transection check end
}
