protected function createOrUpdate(Event $model)
{
if (isset($_POST['Event'])) {
$model->scenario = 'backend';
$model->attributes = $_POST['Event'];
$categories = EventCategory::model()->findAllByPk($_POST['Event']['categories']);
$links = array();
if (!$model->isNewRecord) {
EventLink::model()->deleteAllByAttributes(array('eventId' => $model->id));
}
if (isset($_POST['EventLink'])) {
foreach ($_POST['EventLink'] as $i => $info) {
$link = new EventLink();
$link->attributes = $info;
if (strlen($link->url) > 0) {
$links[] = $link;
}
}
}
$model->categories = $categories;
$model->links = $links;
$model->validate();
if ($model->save()) {
if ($pictureSmall = CUploadedFile::getInstance($model, 'pictureSmall')) {
$model->pictureSmall = $pictureSmall;
}
if ($pictureBig = CUploadedFile::getInstance($model, 'pictureBig')) {
$model->pictureBig = $pictureBig;
}
$model->setTags($_POST['Event']['tagsString'])->save();
$this->redirect(array('view', 'id' => $model->id));
}
}
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = EventCategory::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
public static function getbyStatus()
{
$check = EventCategory::where('status', 1)->count();
if ($check < 1) {
return false;
} else {
return EventCategory::where('status', 1)->get();
}
}
protected function processForm(sfWebRequest $request, sfForm $form)
{
$form->bind($request->getParameter($form->getName()), $request->getFiles($form->getName()));
if ($form->isValid()) {
$notice = $form->getObject()->isNew() ? 'The item was created successfully.' : 'The item was updated successfully.';
try {
$event = $form->save();
} catch (Doctrine_Validator_Exception $e) {
$errorStack = $form->getObject()->getErrorStack();
$message = get_class($form->getObject()) . ' has ' . count($errorStack) . " field" . (count($errorStack) > 1 ? 's' : null) . " with validation errors: ";
foreach ($errorStack as $field => $errors) {
$message .= "{$field} (" . implode(", ", $errors) . "), ";
}
$message = trim($message, ', ');
$this->getUser()->setFlash('error', $message);
return sfView::SUCCESS;
}
$this->dispatcher->notify(new sfEvent($this, 'admin.save_object', array('object' => $event)));
if ($request->hasParameter('_save_and_add')) {
$this->getUser()->setFlash('notice', $notice . ' You can add another one below.');
$this->redirect('@event_new');
} else {
$this->getUser()->setFlash('notice', $notice);
$params = $request->getParameter('event');
if (isset($params['main_slideshow'])) {
$objEvCat = EventCategoryTable::ExistByEventAndCat($event->get('id'), 2);
if (is_null($objEvCat)) {
$obj = new EventCategory();
$obj->setCategoryId(2);
$obj->setEventId($event->get('id'));
$obj->save();
}
} else {
$objEvCat = EventCategoryTable::ExistByEventAndCat($event->get('id'), 2);
if (!is_null($objEvCat)) {
$objEvCat->delete();
}
}
if ($params['event_cat'] != '') {
$obj = new EventCategory();
$obj->setCategoryId($params['event_cat']);
$obj->setEventId($event->get('id'));
$obj->save();
}
$this->redirect('events/index');
}
} else {
$this->getUser()->setFlash('error', 'The item has not been saved due to some errors.', false);
}
}
$query = "SELECT code, name, (SELECT name FROM event_cats WHERE event_cats.cat_id=events.cat_id) AS cat, shortdesc, longdesc, tags, contacts, prize, validate FROM events WHERE code = '{$eventcode}'";
$result = $db->query($query);
$array = $db->getJSONArray($result);
$event = Event::select($db, $eventcode);
if (!$event) {
die("Funny how curious you are!!...");
}
$eventname = $event->getName();
$shortdesc = $event->getShort_desc();
$longdesc = $event->getLong_desc();
$tags = $event->getTags();
$contacts = $event->getContacts();
$prize = $event->getPrize();
$prtpnt = $event->getPrtpnt();
$timings = $event->getTimings();
$cat = EventCategory::select($db, $event->getCat_id());
$category = $cat->getName();
$locid = $event->getLocation_id();
$loc = Location::select($db, $locid);
$location = isset($loc) ? $loc->getName() : "Not Set";
$m = explode("||@||", $prtpnt);
$max = $min = "Not Set";
if (sizeof($m) == 2) {
$max = $m[1];
$min = $m[0];
}
$sections = explode("||sec||", $longdesc);
foreach ($sections as $section) {
$det = explode("||ttl||", $section);
if (sizeof($det) == 1) {
$details['Introduction'] = $det[0];
protected function processForm(sfWebRequest $request, sfForm $form)
{
//var_dump($request->getParameter('event[start_time]'));
$form->bind($request->getParameter($form->getName()), $request->getFiles($form->getName()));
if ($form->isValid()) {
//$event = $form->save();
$name = $form->getValue('name');
$venue = $form->getValue('venue');
$description = $form->getValue('description');
$price = $form->getValue('price');
$c_ids = $form->getValue('category_ids');
$event_url = $form->getValue('event_url');
$start_time = $form->getValue('start_time');
$end_time = $form->getValue('end_time');
$date = $form->getValue('date');
$o_id = $form->getValue('organizer_id');
$event = null;
if (!$form->getObject()->isNew()) {
$event = $form->getObject();
//Delete previous relations to genres
Doctrine_Core::getTable('EventCategory')->createQuery()->delete()->where('event_id = ?', $event->getId())->execute();
} else {
$event = new Event();
}
if ($event === null) {
$event = new Event();
}
//$event = new Event();
//$event->setCategoryId($c_id);
$event->setName($name);
$event->setDescription($description);
$event->setPrice($price);
$event->setVenue($venue);
$event->setEventUrl($event_url);
$event->setStartTime($start_time);
$event->setEndTime($end_time);
$event->setOrganizerId($o_id);
$sql_date = date("Y-m-d", strtotime($date));
$event->setDate($sql_date);
$event->save();
foreach ($c_ids as $cid) {
$ec = new EventCategory();
$ec->setEventId($event->getId());
$ec->setCategoryId($cid);
$ec->save();
}
$this->getUser()->setAttribute('m', 1);
$this->redirect('organize/edit?id=' . $event->getId() . '&m=1');
}
}
public static function signatures2db($xml_file, $customer_id)
{
// Create XML DOM document and load XML file.
$xml = new DOMDocument();
$xml->load($xml_file);
// Start by parsing all log signatures.
$xml_logs = $xml->getElementsByTagName('log_signature');
// Parse all log signatures.
foreach ($xml_logs as $xml_log) {
// Use existing object from db if community_id exists, else create an new.
$community_ids = $xml_log->getElementsByTagName('community_id');
$community_id = $community_ids->item(0)->nodeValue;
if ($community_id != '') {
// Load the XML data into memory.
// Event details
$publisher_ids = $xml_log->getElementsByTagName('publisher');
$publisher_id = $publisher_ids->item(0)->nodeValue;
$names = $xml_log->getElementsByTagName('name');
$name = self::xml_entity_decode($names->item(0)->nodeValue);
$source_names = $xml_log->getElementsByTagName('source_name');
$source_name = self::xml_entity_decode($source_names->item(0)->nodeValue);
$source_type_ids = $xml_log->getElementsByTagName('source_type_id');
$source_type_id = $source_type_ids->item(0)->nodeValue;
$category_names = $xml_log->getElementsByTagName('category_name');
$category_name = self::xml_entity_decode($category_names->item(0)->nodeValue);
$category_group_ids = $xml_log->getElementsByTagName('category_group_id');
$category_group_id = $category_group_ids->item(0)->nodeValue;
$confidentiality_ids = $xml_log->getElementsByTagName('confidentiality_id');
$confidentiality_id = $confidentiality_ids->item(0)->nodeValue;
$integrity_ids = $xml_log->getElementsByTagName('integrity_id');
$integrity_id = $integrity_ids->item(0)->nodeValue;
$availability_ids = $xml_log->getElementsByTagName('availability_id');
$availability_id = $availability_ids->item(0)->nodeValue;
$comments = $xml_log->getElementsByTagName('comment');
$comment = self::xml_entity_decode($comments->item(0)->nodeValue);
$xrefs = $xml_log->getElementsByTagName('xref');
$xref = self::xml_entity_decode($xrefs->item(0)->nodeValue);
// Log Signature details
$patterns = $xml_log->getElementsByTagName('pattern');
if ($patterns->item(0)) {
$pattern = self::xml_entity_decode($patterns->item(0)->nodeValue);
} else {
$pattern = '';
}
$reporting_ips = $xml_log->getElementsByTagName('reporting_ip');
if ($reporting_ips->item(0)) {
$reporting_ip = self::xml_entity_decode($reporting_ips->item(0)->nodeValue);
} else {
$reporting_ip = '';
}
$attacking_ips = $xml_log->getElementsByTagName('attacking_ip');
if ($attacking_ips->item(0)) {
$attacking_ip = self::xml_entity_decode($attacking_ips->item(0)->nodeValue);
} else {
$attacking_ip = '';
}
$services = $xml_log->getElementsByTagName('service');
if ($services->item(0)) {
$service = self::xml_entity_decode($services->item(0)->nodeValue);
} else {
$service = '';
}
$usernames = $xml_log->getElementsByTagName('username');
if ($usernames->item(0)) {
$username = self::xml_entity_decode($usernames->item(0)->nodeValue);
} else {
$username = '';
}
$messages = $xml_log->getElementsByTagName('message');
if ($messages->item(0)) {
$message = self::xml_entity_decode($messages->item(0)->nodeValue);
} else {
$message = '';
}
$log_samples = $xml_log->getElementsByTagName('log_sample');
if ($log_samples->item(0)) {
$xml_log_sample = self::xml_entity_decode($log_samples->item(0)->nodeValue);
} else {
$xml_log_sample = '';
}
// Skip to next signature, if signature isnt complete.
if (strlen($pattern) < 1 or strlen($name) < 1 or strlen($source_name) < 1) {
continue;
}
// Select the Event with the found CommunityId.
$c = new Criteria();
$c->add(EventInfoPeer::ID, $community_id);
$event = EventInfoPeer::doSelectOne($c);
// If no match, create a new object.
if (!$event) {
$event = new EventInfo();
// We want to assign an id.
$event->setName('');
$event->save();
}
$event->setCustomerId($customer_id);
$event->setApprovedForShare(false);
// Select the Log Signature corresponding to the event.
$c = new Criteria();
$c->add(LogSignaturePeer::EVENT_INFO_ID, $event->getId());
$log = LogSignaturePeer::doSelectOne($c);
// If no match, create a new object.
if (!$log) {
$log = new LogSignature();
// We want to assign an id.
$log->setMPattern('');
$log->save();
}
// Select the Log Sample corresponding to the log signature.
$c = new Criteria();
$c->add(LogSamplePeer::ID, $log->getLogSampleId());
$log_sample = LogSignaturePeer::doSelectOne($c);
// If no match, create a new object.
if (!$log_sample) {
$log_sample = new LogSample();
}
// Save event details.
$event->setVendorId(0);
$event->setPublisherId($publisher_id);
$event->setName($name);
$event->setConfidentialityId($confidentiality_id);
$event->setIntegrityId($integrity_id);
$event->setAvailabilityId($availability_id);
$event->setComment($comment);
$event->setXref($xref);
// Find the source name, else create it.
if ($source_name) {
$c = new Criteria();
$c->add(EventSourceNamePeer::NAME, $source_name);
$db_source_name = EventSourceNamePeer::doSelectOne($c);
if (!$db_source_name) {
$db_source_name = new EventSourceName();
$db_source_name->setName($source_name);
$db_source_name->setSourceTypeId($source_type_id);
$db_source_name->save();
}
$event->setSourceNameId($db_source_name->getId());
}
// Find the event category, else create it.
if ($category_name) {
$c = new Criteria();
$c->add(EventCategoryPeer::NAME, $category_name);
$db_event_category = EventCategoryPeer::doSelectOne($c);
if (!$db_event_category) {
$db_event_category = new EventCategory();
$db_event_category->setName($category_name);
$db_event_category->setPublisherId($publisher_id);
$db_event_category->setGroupId($category_group_id);
$db_event_category->save();
}
$event->setCategoryId($db_event_category->getId());
}
$event->save();
// Save the log sample.
// $log_sample->setMessage($xml_log_sample);
$log_sample->save();
// Save log signature details.
$log->setEventInfoId($event->getId());
$log->setMPattern($pattern);
$log->setAttackingIp($attacking_ip);
$log->setService($service);
$log->setUsername($username);
$log->setDataField($message);
$log->setLogSampleId($log_sample->getId());
$log->save();
//print "Updating (LOG) signature ".$event->getId()." source_name: $source_name\n";
}
// Cleanup scope.
$db_source_name = '';
$db_event_category = '';
$publisher_id = '';
$name = '';
$source_name = '';
$source_names = '';
$category_name = '';
$confidentiality_id = '';
$availability_id = '';
$integrity_id = '';
$comment = '';
$xref = '';
unset($event);
unset($log);
unset($log_sample);
}
// Start by parsing all log firewall signatures.
$xml_logs = $xml->getElementsByTagName('log_fw_signature');
// Parse all log signatures.
foreach ($xml_logs as $xml_log) {
// Use existing object from db if community_id exists, else create an new.
$community_ids = $xml_log->getElementsByTagName('community_id');
$community_id = $community_ids->item(0)->nodeValue;
if ($community_id != '') {
// Load the XML data into memory.
// Event details
$publisher_ids = $xml_log->getElementsByTagName('publisher');
$publisher_id = $publisher_ids->item(0)->nodeValue;
$names = $xml_log->getElementsByTagName('name');
$name = self::xml_entity_decode($names->item(0)->nodeValue);
$source_names = $xml_log->getElementsByTagName('source_name');
$source_name = self::xml_entity_decode($source_names->item(0)->nodeValue);
$source_type_ids = $xml_log->getElementsByTagName('source_type_id');
$source_type_id = $source_type_ids->item(0)->nodeValue;
$comments = $xml_log->getElementsByTagName('comment');
$comment = self::xml_entity_decode($comments->item(0)->nodeValue);
$xrefs = $xml_log->getElementsByTagName('xref');
$xref = self::xml_entity_decode($xrefs->item(0)->nodeValue);
// Log Signature details
$patterns = $xml_log->getElementsByTagName('pattern');
if ($patterns->item(0)) {
$pattern = self::xml_entity_decode($patterns->item(0)->nodeValue);
} else {
$pattern = '';
}
$fw_policies = $xml_log->getElementsByTagName('fw_policy');
if ($fw_policies->item(0)) {
$fw_policy = $fw_policies->item(0)->nodeValue;
} else {
$fw_policy = '';
}
$fw_interfaces = $xml_log->getElementsByTagName('fw_interface');
if ($fw_interfaces->item(0)) {
$fw_interface = self::xml_entity_decode($fw_interfaces->item(0)->nodeValue);
} else {
$fw_interface = '';
}
$fw_source_ips = $xml_log->getElementsByTagName('fw_source_ip');
if ($fw_source_ips->item(0)) {
$fw_source_ip = self::xml_entity_decode($fw_source_ips->item(0)->nodeValue);
} else {
$fw_source_ip = '';
}
$fw_destination_ips = $xml_log->getElementsByTagName('fw_destination_ip');
if ($fw_destination_ips->item(0)) {
$fw_destination_ip = self::xml_entity_decode($fw_destination_ips->item(0)->nodeValue);
} else {
$fw_destination_ip = '';
}
$fw_destination_ports = $xml_log->getElementsByTagName('fw_destination_port');
if ($fw_destination_ports->item(0)) {
$fw_destination_port = self::xml_entity_decode($fw_destination_ports->item(0)->nodeValue);
} else {
$fw_destination_port = '';
}
$fw_ip_protocols = $xml_log->getElementsByTagName('fw_ip_protocol');
if ($fw_ip_protocols->item(0)) {
$fw_ip_protocol = self::xml_entity_decode($fw_ip_protocols->item(0)->nodeValue);
} else {
$fw_ip_protocol = '';
}
$log_samples = $xml_log->getElementsByTagName('log_sample');
if ($log_samples->item(0)) {
$xml_log_sample = self::xml_entity_decode($log_samples->item(0)->nodeValue);
} else {
$xml_log_sample = '';
}
// Skip to next signature, if signature isnt complete.
if (strlen($pattern) < 1 or strlen($name) < 1 or strlen($source_name) < 1) {
continue;
}
// Select the Event with the found CommunityId.
$c = new Criteria();
$c->add(EventInfoPeer::ID, $community_id);
$event = EventInfoPeer::doSelectOne($c);
// If no match, create a new object.
if (!$event) {
$event = new EventInfo();
// We want to assign an id.
$event->setName('');
$event->save();
}
$event->setCustomerId($customer_id);
$event->setApprovedForShare(false);
// Select the Log Firewall Signature corresponding to the event.
$c = new Criteria();
$c->add(LogFirewallSignaturePeer::EVENT_INFO_ID, $event->getId());
$log = LogFirewallSignaturePeer::doSelectOne($c);
// If no match, create a new object.
if (!$log) {
$log = new LogFirewallSignature();
// We want to assign an id.
$log->setMPattern('');
$log->save();
}
// Select the Log Sample corresponding to the log signature.
$c = new Criteria();
$c->add(LogSamplePeer::ID, $log->getLogSampleId());
$log_sample = LogSignaturePeer::doSelectOne($c);
// If no match, create a new object.
if (!$log_sample) {
$log_sample = new LogSample();
}
// Save event details.
// Save event details.
$event->setVendorId(0);
$event->setPublisherId($publisher_id);
$event->setName($name);
$event->setComment($comment);
$event->setXref($xref);
// Find the source name, else create it.
if ($source_name) {
$c = new Criteria();
$c->add(EventSourceNamePeer::NAME, $source_name);
$db_source_name = EventSourceNamePeer::doSelectOne($c);
if (!$db_source_name) {
$db_source_name = new EventSourceName();
$db_source_name->setName($source_name);
$db_source_name->setSourceTypeId($source_type_id);
$db_source_name->save();
}
$event->setSourceNameId($db_source_name->getId());
}
$event->save();
// Save the log sample.
// $log_sample->setMessage($xml_log_sample);
$log_sample->save();
// Save log signature details.
$log->setEventInfoId($event->getId());
$log->setMPattern($pattern);
$log->setFirewallStateId($fw_policy);
$log->setFirewallInterface($fw_interface);
$log->setSourceIp($fw_source_ip);
$log->setDestinationIp($fw_destination_ip);
$log->setDestinationPort($fw_destination_port);
$log->setIpProtocol($fw_ip_protocol);
$log->setLogSampleId($log_sample->getId());
$log->save();
//print "Updating (FW) signature ".$event->getId()." source_name: $source_name and pattern: $pattern\n";
}
// Cleanup scope.
$db_source_name = '';
$publisher_id = '';
$name = '';
$source_name = '';
$source_names = '';
$category_name = '';
$integrity_id = '';
$comment = '';
$xref = '';
unset($event);
unset($log);
unset($log_sample);
}
}
public function update($id)
{
$data = array('menu' => 'Event', 'title' => 'Event', 'description' => '', 'breadcrumb' => array('Event' => route('admin.event')));
if (!Session::has('time') && (!Session::has('validasi') && Session::get('validasi') != 'event')) {
$time = time();
Session::put('time', $time);
}
$event = Events::where('id', $id)->first();
$data['action'] = 'admin.event.update.post';
$data['event'] = $event;
$data['event_category'] = EventCategory::all();
$data['user'] = User::all();
$data['city'] = City::all();
$data['photos'] = Photo::where('type_name', '=', 'events')->where('type_id', '=', $event->id)->orderBy('id', 'desc')->get();
// return $data;
return View::make('admin.pages.event.create')->with($data);
}
require '../classes/EventCategory.php';
require '../classes/Location.php';
$db = new Database(DB_SERVER, DB_USER, DB_PASS, DB_DATABASE);
$out = [];
if (isset($_GET['code'])) {
$code = $_GET['code'];
if (isset($_GET['type']) && $_GET['type'] == 'short') {
$e = Event::selectShort($db, $code, FALSE);
if ($e != NULL) {
$out = $e;
}
} else {
$e = Event::select($db, $code, FALSE);
//print_r($e);
if ($e != NULL) {
$cat = EventCategory::select($db, $e[Event::EVENT_CAT_ID]);
$e["cat_name"] = $category = $cat->getName();
$locid = $e[Event::EVENT_LOCATIONID];
$loc = Location::select($db, $locid);
$location = isset($loc) ? $loc->getName() : "notset";
$loc_type = isset($loc) ? $loc->getType() : "notset";
$loc_lon = isset($loc) ? $loc->getLongitude() : "notset";
$loc_latt = isset($loc) ? $loc->getLattitude() : "notset";
$e['location_name'] = $location;
$e['location_type'] = $loc_type;
$e['location_lattitude'] = $loc_latt;
$e['location_longitude'] = $loc_lon;
$longdesc = $e[Event::EVENT_LONGDESC];
$sections = explode("||sec||", $longdesc);
foreach ($sections as $section) {
$det = explode("||ttl||", $section);
public function create()
{
$data['event_category'] = EventCategory::getbyStatus();
$data['city'] = City::getAll();
return View::make('bagikasih.event.create', $data);
}
/**
* undocumented function
*
* @return void
* @author
**/
protected function deleteValid($id)
{
$exist = EventCategory::isExist($id);
if ($exist) {
return false;
}
return true;
}
<select id="acctype" class="form-control" name="type">
<option value="nu">Regular User</option>
<option value="pr">Proofreader</option>
<option value="mn">Event Manager</option>
</select>
</div>
<div id="mn_opts">
<div class="form-group">
<select name="category" class="form-control" id="eventcat">
<option value="">--Event Category--</option>
<?php
$cats = EventCategory::selectWithParCat($db, -1);
foreach ($cats as $cat) {
$subs = EventCategory::selectWithParCat($db, $cat->getId());
if (sizeof($subs) == 0) {
echo "<option value='{$cat->getId()}'>{$cat->getName()}</option>";
} else {
echo "<optgroup label='{$cat->getName()}'>";
foreach ($subs as $sub) {
echo "<option value='{$sub->getId()}'>{$sub->getName()}</option>";
}
echo "</optgroup>";
}
}
?>
</select>
</div>
<div class="form-group">
