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">