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 }