function delete($id) { $agency = new Agency($id); $agency->delete(); set_notify('success', lang('delete_data_complete')); redirect('agenies/admin/agenies'); }
public static function getRoutes(Agency $agency, $version = 0) { /** * @var DB */ $dbObj = DBPool::getInstance(); $version = $version == 0 ? TableUpdate::getVersion() : $version; $dbObj->bindParams(array($agency->getId(), $version)); $routes = $dbObj->get_results("SELECT * FROM route WHERE agency_id=?\n AND version = ? ORDER BY position"); if ($dbObj->num_rows > 0) { $routeArray = array(); foreach ($routes as $r) { $routeObj = new Route(); $routeObj->setId($r->id); $routeObj->setAgency($agency); $routeObj->setTag($r->tag); $routeObj->setColor($r->color); $routeObj->setTitle($r->title); $routeObj->setShortTitle($r->short_title); $routeObj->setLatMin($r->lat_min); $routeObj->setLatMax($r->lat_max); $routeObj->setLonMin($r->lon_min); $routeObj->setLonMax($r->lon_max); $routeObj->setVehicleType($r->vehicle_type); $routeObj->setPosition($r->position); $routeArray[$r->tag] = $routeObj; } return $routeArray; } else { //TODO: Don't use a generic exception throw new Exception("No data available - Route::getRoutes"); } }
public static function getStops(Agency $agency, $version = 0) { /** * @var DB */ $dbObj = DBPool::getInstance(); $version = $version == 0 ? TableUpdate::getVersion() : $version; $dbObj->bindParams(array($agency->getId(), TableUpdate::getVersion())); $stops = $dbObj->get_results("SELECT * FROM stop WHERE agency_id=?\n AND version = ?"); if ($dbObj->num_rows > 0) { $stopArray = array(); foreach ($stops as $s) { $stopObj = new Stop(); $stopObj->setId($s->id); $stopObj->setAgency($agency); $stopObj->setFlipStopTag($s->flip_stop_tag); $stopObj->setTag($s->tag); $stopObj->setTitle($s->title); $stopObj->setPrettyTitle($s->pretty_title); $stopObj->setLatitude($s->latitude); $stopObj->setLongitude($s->longitude); $stopArray[$s->tag] = $stopObj; } return $stopArray; } else { //TODO: Don't use a generic exception throw new Exception("No data available - Stop::getStops"); } }
public function getDataByAgencyId($agencycode) { $agency_obj = new Agency(); $rs_agency_info = $agency_obj->getAgecyInfoByCode($agencycode); $agencydata_obj = new DataPrivacy(); $rs = $agencydata_obj->getDataByAgencyId($rs_agency_info[0]->id); return View::make('requestdata.ajax_databyagency')->with('all_data', $rs); }
public function checkAgency($code) { $rs = Agency::where('code', '=', $code)->count(); if (isset($rs)) { return $rs >= 1 ? false : true; } }
public function delete() { $id = Input::get('id'); $agency = Agency::find($id); $agency->delete(); return "Agency Deleted."; }
/** * Add the routes to the database * @param array $routes - Array of Route objects */ protected function add(array $routes) { $insertCnt = 0; $version = TableUpdate::getVersion(); foreach ($routes as $r) { //Add the mandatory columns $columns = array('agency_id', 'tag', 'color', 'title', 'short_title', 'vehicle_type', 'version', 'position'); $boundParams = array($this->agency->getId(), $r->getTag(), $r->getColor(), $r->getTitle(), $r->getShortTitle(), $r->getVehicleType(), $version, $r->getPosition()); $columnCnt = count($columns); //Check and add the optional columns if ($r->getLatMin()) { $columns[] = 'lat_min'; $boundParams[] = $r->getLatMin(); $columnCnt++; } if ($r->getLatMax()) { $columns[] = 'lat_max'; $boundParams[] = $r->getLatMax(); $columnCnt++; } if ($r->getLonMin()) { $columns[] = 'lon_min'; $boundParams[] = $r->getLonMin(); $columnCnt++; } if ($r->getLonMax()) { $columns[] = 'lon_max'; $boundParams[] = $r->getLonMax(); $columnCnt++; } $this->dbObj->bindParams($boundParams); //var_dump($boundParams); $query = "INSERT INTO route (" . implode(",", $columns) . ", created_date)\n VALUES (" . implode(",", array_fill(0, $columnCnt, "?")) . ", NOW())"; $this->dbObj->query($query); if ($this->dbObj->rows_affected != 1) { //$this->dbObj->debug();exit; throw new DBException("Addition of route failed [agency:" . $this->agency->getId() . "] [route tag:" . $r->getTag() . "] [route title:" . $r->getTitle() . "]"); } $insertCnt++; } //TODO: Add a log for the total number of rows added //Write the changes to the change log $this->saveChangesToFile(); }
private function getVehicleTypeOverride() { $agencyShortTitle = $this->agency->getShortTitle(); $config = $this->appConfig; $filePath = $config['sfmuni_vehicle_override']; //TODO: Check for exception $xmlObjBuilder = new XmlObjBuilder($filePath); $xml = $xmlObjBuilder->getXmlObj(); $vehicleOverrides = array(); //We only support SF-Muni for now if ($agencyShortTitle == "sf-muni") { foreach ($xml->route as $r) { $routeTag = (string) $r['tag']; $vehicleType = (string) $r['vehicle']; $vehicleOverrides[$routeTag] = $vehicleType; } } return $vehicleOverrides; }
public static function getAgencies() { $dbObj = DBPool::getInstance(); $agencies = $dbObj->get_results("SELECT * FROM agency"); if ($dbObj->num_rows > 0) { $agencyArray = array(); foreach ($agencies as $a) { $agencyObj = new Agency(); $agencyObj->setId($a->id); $agencyObj->setTitle($a->title); $agencyObj->setShortTitle($a->short_title); $agencyObj->setDefaultVehicleType($a->default_vehicle); $agencyArray[$a->short_title] = $agencyObj; } return $agencyArray; } else { throw new Exception("There are no agencies in the database"); } }
protected function add(array $stops) { //var_dump($stops);exit; $insertCnt = 0; $version = TableUpdate::getVersion(); foreach ($stops as $s) { $boundParams = array($this->agency->getId(), $s->getTag(), $s->getLatitude(), $s->getLongitude(), $s->getTitle(), $this->getPrettyTitle($s->getTitle()), $s->getFlipStopTag(), $version); $this->dbObj->bindParams($boundParams); $query = "INSERT INTO stop (agency_id, tag, latitude, longitude, \n title, pretty_title, flip_stop_tag, version, created_date)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, NOW())"; $this->dbObj->query($query); if ($this->dbObj->rows_affected != 1) { //$this->dbObj->debug();exit; throw new DBException("Addition of stop failed [agency:" . $this->agency->getId() . "] [stop tag:" . $s->getTag() . "]"); } $insertCnt++; } //TODO: Add a log for the total number of stops added //Write the changes to the change log $this->saveChangesToFile(); }
function getRoutes(Agency $agency, $version) { $dbObj = DBPool::getInstance(); $routeArray = array(); $finalRouteArray = array(); //Get the routes $dbObj->bindParams(array($version, $agency->getId())); $routes = $dbObj->get_results("SELECT b.tag AS routetag, a.tag AS dirtag\n FROM direction as a, route as b\n WHERE a.route_id=b.id\n AND a.use_for_ui=true\n AND a.version=?\n AND b.agency_id=?\n ORDER BY b.tag;"); if ($dbObj->num_rows > 0) { foreach ($routes as $r) { $routeTag = (string) $r->routetag; $routeArray[$routeTag][] = (string) $r->dirtag; } //Pick only the ones with more than 2 directions foreach ($routeArray as $routeTag => $dirs) { if (count($dirs) > 2) { $finalRouteArray[$routeTag] = $dirs; } } } return $finalRouteArray; }
public function postUpdateagency() { $id = Input::get('id'); $agency = Agency::find($id); $agency->name = Input::get('name'); $agency->email = Input::get('email'); $agency->mobile = Input::get('mobile'); $agency->city = Input::get('city'); $agency->address1 = Input::get('address1'); $agency->address2 = Input::get('address2'); $agency->commission = Input::get('commission'); $agency->save(); return Response::json($agency); }
public function populate() { $id = Input::get('id'); $user = User::find($id); $accountType = DB::table('accounttype')->select('accountTypeName')->where('accountTypeId', '=', $user->accountType)->pluck('accountTypeName'); $user->accountType = $accountType; if ($user->agencyId == null) { $user->agencyId = "No Agency"; } else { $agencyName = Agency::find($user->agencyId); $user->agencyId = $agencyName->agencyName; } return $user->toJson(); }
public function run() { $faker = Faker::create(); $accType = Accounts::all()->lists('accountTypeId'); $agency = Agency::all()->lists('agencyId'); foreach (range(1, 20) as $index) { $atype = $faker->randomElement($accType); Log::info($atype); if ($atype == 3) { $agen = $faker->randomElement($agency); User::create(array('username' => str_replace('.', '_', $faker->unique()->username), 'password' => Hash::make('admin'), 'email' => $faker->email, 'accountType' => $atype, 'updated_at' => new DateTime(), 'created_at' => new DateTime(), 'agencyId' => $agen)); } else { User::create(array('username' => str_replace('.', '_', $faker->unique()->username), 'password' => Hash::make('admin'), 'email' => $faker->email, 'accountType' => $atype, 'updated_at' => new DateTime(), 'created_at' => new DateTime())); } } }
public function getReply() { $id = Request::segment(3); $inbox_id = Request::segment(4); $profiles = Agency::where('staff_id', '=', $id)->get(); $allTeamsMember = array(); foreach ($profiles as $profile) { if ($profile->user_id != Sentry::getUser()->id) { $allTeamsMember[$profile->user_id] = $profile->name; } } // DB::table('inbox') // ->where('to_user', Sentry::getUser()->id) // ->where('id', $inbox_id) // ->update(array('notification' => 0)); return View::make('message.reply')->with('teams', $allTeamsMember); }
private function getDirectionOverrides() { $config = $this->appConfig; $filePath = $config['location_override']; //TODO: Check for exception $xmlObjBuilder = new XmlObjBuilder($filePath); $xml = $xmlObjBuilder->getXmlObj(); $routeArray = array(); foreach ($xml->agency as $a) { $shortTitle = $a['shortTitle']; //We only want the overrides for the current agency if ($this->agency->getShortTitle() == $shortTitle) { foreach ($a->route as $r) { $routeTag = (string) $r['tag']; foreach ($r->direction as $d) { $routeArray[$routeTag][] = (string) $d['tag']; } } } } return $routeArray; }
/** * Read flip stop overrides from a file and return them as an array. * NOTE: This method returns the flip stops only for the agency being processed * * @return Array - stopTag => flipStopTag */ private function getFlipStopOverrides() { $agencyShortTitle = $this->agency->getShortTitle(); $config = $this->appConfig; $filePath = $config['flip_stop_override']; //TODO: Check for exception $xmlObjBuilder = new XmlObjBuilder($filePath); $xml = $xmlObjBuilder->getXmlObj(); $flipStopMap = array(); foreach ($xml->agency as $tempAgency) { if ((string) $tempAgency["shortTitle"] != $agencyShortTitle) { continue; } foreach ($tempAgency->stop as $tempStop) { $stopTag = (string) $tempStop["tag"]; $flipStopTag = (string) $tempStop["reverseStopTag"]; $flipStopMap[$stopTag] = $flipStopTag; if (!empty($flipStopTag)) { $flipStopMap[$flipStopTag] = $stopTag; } } } return $flipStopMap; }
<?php use App\Utils\Hash; use Illuminate\Support\Str; if (\User::check()) { $user = \User::getUser(); $agency = \Agency::getAgency(); } $_hash = new Hash(); $_hash = $_hash->getHasher(); ?> @extends('front.app') @section('title') {{ $job->title }}| Programme Chameleon @stop @section('content') <div id="wrapper"> @include('front.include.header') <div class="container"> <h1 class="page-header"> {{ $job->title }} - <small class="lighten"> Contractors Applied</small> </h1> <div class="row"> <div class="col-md-8"> <div class="panel panel-default"> <div class="panel-heading">Contractors Applied</div> <div class="panel-body"> <?php $contractors = $job->contractors();
<?php echo $form->textFieldRow($model, 'ord_no', array('class' => 'span2', 'value' => '', 'placeholder' => '000 - 0000')); ?> <?php echo $form->textAreaRow($model, 'subj_matter', array('class' => 'span6', 'rows' => 5, 'value' => '')); ?> <?php echo $form->select2Row($model, 'author', array('asDropDownList' => true, 'data' => CHtml::listData(Officials::model()->findAll(array('condition' => 'now() >= start_date')), 'off_id', 'Fullname'), 'multiple' => 'multiple', 'options' => array('width' => '63%', 'placeholder' => ' ------------ Choose Author ------------', 'tokenSeparators' => array(',', ' ')))); ?> <?php echo $form->select2Row($model, 'imp_agency', array('asDropDownList' => true, 'data' => CHtml::listData(Agency::model()->findAll(), 'agency_id', 'agency_name'), 'multiple' => 'multiple', 'options' => array('width' => '63%', 'placeholder' => ' ------------ Choose Agency ------------', 'tokenSeparators' => array(',', ' ')))); ?> <?php echo $form->textFieldRow($model, 'amend', array('class' => 'span2', 'value' => '')); ?> <?php echo $form->datepickerRow($model, 'firstreading', array('prepend' => '<i class="icon-calendar"></i>', 'options' => array('format' => 'yyyy-mm-dd'))); ?> <?php echo $form->datepickerRow($model, 'secondreading', array('prepend' => '<i class="icon-calendar"></i>', 'options' => array('format' => 'yyyy-mm-dd'))); ?> <?php echo $form->datepickerRow($model, 'thirdreading', array('prepend' => '<i class="icon-calendar"></i>', 'options' => array('format' => 'yyyy-mm-dd'))); ?> <?php echo $form->datepickerRow($model, 'date_passed', array('prepend' => '<i class="icon-calendar"></i>', 'options' => array('format' => 'yyyy-mm-dd')));
<?php define("ROOT", "../"); set_time_limit(0); require ROOT . 'www/common.php'; require ROOT . 'nextbus/Require.php'; require ROOT . 'bart/Require.php'; require ROOT . 'www/generate_xml.php'; $mailMessage = ""; $zipFileContents = array(); $logger = Logger::getInstance(); $agencyArray = Agency::getAgencies(); try { foreach ($agencyArray as $agencyTitle => $agencyObj) { //print "<br /><b>$agencyTitle</b><br />"; file_put_contents(Util::getChangeLogFile(), "\n" . strtoupper($agencyTitle) . "\n\n", FILE_APPEND); if ("actransit" == $agencyTitle || "sf-muni" == $agencyTitle || "emery" == $agencyTitle) { /* if ("sf-muni" == $agencyTitle) { $agencyObj->setDataUrl("./files/sf-muni.xml"); } else if ("actransit" == $agencyTitle) { $agencyObj->setDataUrl("./files/actransit.xml"); } */ //Get the XML object $xmlObjBuilder = new NxtbusXmlObjBuilder($agencyObj); $xmlObj = $xmlObjBuilder->getXmlObj(true); //Update the routes $nxtbusRoute = new NxtbusRoute($agencyObj, $xmlObj); $nxtbusRoute->updateRoutes(); //print "Routes updated | ";
<td><strong><?php echo join(', ', $location_list); ?> </strong></td> </tr> <tr> <td><i class="flag icon"></i><strong>Theme</strong></td> <td><strong><?php echo join(', ', $theme_list); ?> </strong></td> </tr> <tr> <th colspan="2"> <?php $mailto = Agency::get_email(); $mailto .= '?subject=Offre:' . get_the_title(); $mailto .= '&body=' . __('I\'m interested in this this offert', 'sage'); ?> <a href="mailto: <?php echo $mailto; ?> " class="fluid ui inverted button"> <i class="shop icon"></i> <?php _e('Contact us', 'sage'); ?> </a> </th> </tr> </table>
/** * Declares an association between this object and a Agency object. * * @param Agency $v * @return Camp The current object (for fluent API support) * @throws PropelException */ public function setAgency(Agency $v = null) { if ($v === null) { $this->setAgencyId(NULL); } else { $this->setAgencyId($v->getId()); } $this->aAgency = $v; // Add binding for other direction of this n:n relationship. // If this object has already been added to the Agency object, it will not be re-added. if ($v !== null) { $v->addCamp($this); } return $this; }
} else { $pdf->SetFont('helvetica', 'B', 17); $pdf->Ln(25); $pdf->Write(0, 'Ordinance No. ' . $model->ord_no, '', 0, 'C', true, 0, false, false, 0); $pdf->Ln(15); $pdf->SetFont('helvetica', 'B', 14); $pdf->Write(0, $model->subj_matter, '', 0, 'C', true, 0, false, false, 0); $pdf->SetFont('helvetica', '', 10); $pdf->Ln(10); // ----------------------------------------------------------------------------- $timezone = new DateTimeZone('Asia/Manila'); $agenda = !empty($model->meeting_ordi_id) ? $model->getAgendaDate($model->meeting_ordi_id) : '0000-00-00'; $origin = !empty($model->meeting_ordi_id) ? $model->getOrigin($model->meeting_ordi_id) : 'Unknown Origin'; $referral = !empty($model->meeting_ordi_id) ? $model->getReferralDate($model->meeting_ordi_id) : '0000-00-00'; $date_report = !empty($model->meeting_ordi_id) ? $model->getReportDate($model->meeting_ordi_id) : '0000-00-00'; $agency = Agency::model()->FindByPK($model->imp_agency)->agency_name; $first = $model->firstreading; $second = $model->secondreading; $third = $model->thirdreading; $datepassed = $model->date_passed; $agenda1 = new DateTime($agenda, $timezone); $refer1 = new DateTime($referral, $timezone); $daterport = new DateTime($date_report, $timezone); $firstread = new DateTime($first, $timezone); $secondread = new DateTime($second, $timezone); $thirdread = new DateTime($third, $timezone); $datepassed1 = new DateTime($datepassed, $timezone); $tbl = '<table style="padding:10; font-size:16px; width:100%; border-bottom-style: 1px solid black;">'; if ($agenda == '0000-00-00') { $tbl .= '<tr nobr="true"> <td style="border-top-style: 1px solid black; font-size:16px; font-weight:bold;">A) Date Agenda</td>
/** * [getDataList list of agency by each type of data] * @param [integer] $type [type id riainfall, water level ,dam ect.] * @return [type] [description] */ public function getDataList($type) { $agency_id = Data::getAgencyByDataType($type); $rs = Agency::getAgency($agency_id); return View::make('rbac.ajax_datalist')->with('result', $rs); }
public function execute() { PHPWS_Core::initModClass('intern', 'Internship.php'); PHPWS_Core::initModClass('intern', 'Agency.php'); PHPWS_Core::initModClass('intern', 'Department.php'); PHPWS_Core::initModClass('intern', 'Faculty.php'); /************** * Sanity Checks */ // Required fields check $missing = self::checkRequest(); if (!is_null($missing) && !empty($missing)) { // checkRequest returned some missing fields. $url = 'index.php?module=intern&action=edit_internship'; $url .= '&missing=' . implode('+', $missing); // Restore the values in the fields the user already entered foreach ($_POST as $key => $val) { $url .= "&{$key}={$val}"; } NQ::simple('intern', INTERN_ERROR, 'Please fill in the highlighted fields.'); NQ::close(); return PHPWS_Core::reroute($url); } // Sanity check the Banner ID if (!preg_match('/^\\d{9}$/', $_REQUEST['banner'])) { $url = 'index.php?module=intern&action=edit_internship&missing=banner'; // Restore the values in the fields the user already entered foreach ($_POST as $key => $val) { $url .= "&{$key}={$val}"; } NQ::simple('intern', INTERN_ERROR, "The Banner ID you entered is not valid. No changes were saved. The student's Banner ID should be nine digits only (no letters, spaces, or punctuation)."); NQ::close(); return PHPWS_Core::reroute($url); } // Sanity check student email if (isset($_REQUEST['student_email']) && preg_match("/@/", $_REQUEST['student_email'])) { $url = 'index.php?module=intern&action=edit_internship&missing=student_email'; // Restore the values in the fields the user already entered foreach ($_POST as $key => $val) { $url .= "&{$key}={$val}"; } NQ::simple('intern', INTERN_ERROR, "The student's email address is invalid. No changes were saved. Enter only the username portion of the student's email address. The '@appstate.edu' portion is not necessary."); NQ::close(); return PHPWS_Core::reroute($url); } // Sanity check student zip if (isset($_REQUEST['student_zip']) && $_REQUEST['student_zip'] != "" && (strlen($_REQUEST['student_zip']) != 5 || !is_numeric($_REQUEST['student_zip']))) { $url = 'index.php?module=intern&action=edit_internship&missing=student_zip'; // Restore the values in the fields the user already entered foreach ($_POST as $key => $val) { $url .= "&{$key}={$val}"; } NQ::simple('intern', INTERN_ERROR, "The student's zip code is invalid. No changes were saved. Zip codes should be 5 digits only (no letters, spaces, or punctuation)."); NQ::close(); return PHPWS_Core::reroute($url); } // Course start date must be before end date if (!empty($_REQUEST['start_date']) && !empty($_REQUEST['end_date'])) { $start = strtotime($_REQUEST['start_date']); $end = strtotime($_REQUEST['end_date']); if ($start > $end) { $url = 'index.php?module=intern&action=edit_internship&missing=start_date+end_date'; // Restore the values in the fields the user already entered unset($_POST['start_date']); unset($_POST['end_date']); foreach ($_POST as $key => $val) { $url .= "&{$key}={$val}"; } NQ::simple('intern', INTERN_WARNING, 'The internship start date must be before the end date.'); NQ::close(); return PHPWS_Core::reroute($url); } } // Sanity check internship location zip if (isset($_REQUEST['loc_zip']) && $_REQUEST['loc_zip'] != "" && (strlen($_REQUEST['loc_zip']) != 5 || !is_numeric($_REQUEST['loc_zip']))) { $url = 'index.php?module=intern&action=edit_internship&missing=loc_zip'; // Restore the values in the fields the user already entered foreach ($_POST as $key => $val) { $url .= "&{$key}={$val}"; } NQ::simple('intern', INTERN_ERROR, "The internship location's zip code is invalid. No changes were saved. Zip codes should be 5 digits only (no letters, spaces, or punctuation)."); NQ::close(); return PHPWS_Core::reroute($url); } // Sanity check agency zip if (isset($_REQUEST['agency_zip']) && $_REQUEST['agency_zip'] != "" && (strlen($_REQUEST['agency_zip']) != 5 || !is_numeric($_REQUEST['agency_zip']))) { $url = 'index.php?module=intern&action=edit_internship&missing=agency_zip'; // Restore the values in the fields the user already entered foreach ($_POST as $key => $val) { $url .= "&{$key}={$val}"; } NQ::simple('intern', INTERN_ERROR, "The agency's zip code is invalid. No changes were saved. Zip codes should be 5 digits only (no letters, spaces, or punctuation)."); NQ::close(); return PHPWS_Core::reroute($url); } // Sanity check supervisor's zip if (isset($_REQUEST['agency_sup_zip']) && $_REQUEST['agency_sup_zip'] != "" && (strlen($_REQUEST['agency_sup_zip']) != 5 || !is_numeric($_REQUEST['agency_sup_zip']))) { $url = 'index.php?module=intern&action=edit_internship&missing=agency_sup_zip'; // Restore the values in the fields the user already entered foreach ($_POST as $key => $val) { $url .= "&{$key}={$val}"; } NQ::simple('intern', INTERN_ERROR, "The agency supervisor's zip code is invalid. No changes were saved. Zip codes should be 5 digits only (no letters, spaces, or punctuation)."); NQ::close(); return PHPWS_Core::reroute($url); } // Sanity check course number if (isset($_REQUEST['course_no']) && $_REQUEST['course_no'] != '' && (strlen($_REQUEST['course_no']) > 20 || !is_numeric($_REQUEST['course_no']))) { $url = 'index.php?module=intern&action=edit_internship&missing=course_no'; // Restore the values in the fields the user already entered foreach ($_POST as $key => $val) { $url .= "&{$key}={$val}"; } NQ::simple('intern', INTERN_ERROR, "The course number provided is invalid. No changes were saved. Course numbers should be less than 20 digits (no letters, spaces, or punctuation)."); NQ::close(); return PHPWS_Core::reroute($url); } PHPWS_DB::begin(); // Create/Save agency $agency = new Agency(); if (isset($_REQUEST['agency_id'])) { // User is editing internship try { $agency = new Agency($_REQUEST['agency_id']); } catch (Exception $e) { // Rollback and re-throw the exception so that admins gets an email PHPWS_DB::rollback(); throw $e; } } $agency->name = $_REQUEST['agency_name']; $agency->address = $_REQUEST['agency_address']; $agency->city = $_REQUEST['agency_city']; $agency->zip = $_REQUEST['agency_zip']; $agency->phone = $_REQUEST['agency_phone']; if ($_REQUEST['location'] == 'internat') { /* Location is INTERNATIONAL. Country is required. Province was typed in. */ $agency->state = $_REQUEST['agency_state']; $agency->province = $_REQUEST['agency_province']; $agency->country = $_REQUEST['agency_country']; $agency->supervisor_state = $_REQUEST['agency_sup_state']; $agency->supervisor_province = $_REQUEST['agency_sup_province']; $agency->supervisor_country = $_REQUEST['agency_sup_country']; } else { /* Location is DOMESTIC. Country is U.S. State was chosen from drop down */ $agency->state = $_REQUEST['agency_state'] == -1 ? null : $_REQUEST['agency_state']; $agency->country = 'United States'; $agency->supervisor_state = $_REQUEST['agency_sup_state'] == -1 ? null : $_REQUEST['agency_sup_state']; $agency->supervisor_country = 'United States'; } $agency->supervisor_first_name = $_REQUEST['agency_sup_first_name']; $agency->supervisor_last_name = $_REQUEST['agency_sup_last_name']; $agency->supervisor_title = $_REQUEST['agency_sup_title']; $agency->supervisor_phone = $_REQUEST['agency_sup_phone']; $agency->supervisor_email = $_REQUEST['agency_sup_email']; $agency->supervisor_fax = $_REQUEST['agency_sup_fax']; $agency->supervisor_address = $_REQUEST['agency_sup_address']; $agency->supervisor_city = $_REQUEST['agency_sup_city']; $agency->supervisor_zip = $_REQUEST['agency_sup_zip']; $agency->address_same_flag = isset($_REQUEST['copy_address']) ? 't' : 'f'; try { $agencyId = $agency->save(); } catch (Exception $e) { // Rollback and re-throw the exception so that admins gets an email PHPWS_DB::rollback(); throw $e; } /********************************** * Create and/or save the Internship */ if (isset($_REQUEST['internship_id']) && $_REQUEST['internship_id'] != '') { // User is editing internship try { PHPWS_Core::initModClass('intern', 'InternshipFactory.php'); $i = InternshipFactory::getInternshipById($_REQUEST['internship_id']); } catch (Exception $e) { // Rollback and re-throw the exception so that admins gets an email PHPWS_DB::rollback(); throw $e; } } else { $i = new Internship(); } $i->term = $_REQUEST['term']; $i->agency_id = $agencyId; $i->faculty_id = $_REQUEST['faculty_id'] > 0 ? $_REQUEST['faculty_id'] : null; $i->department_id = $_REQUEST['department']; $i->start_date = !empty($_REQUEST['start_date']) ? strtotime($_REQUEST['start_date']) : 0; $i->end_date = !empty($_REQUEST['end_date']) ? strtotime($_REQUEST['end_date']) : 0; // Credit hours must be an integer (because of database column type), // so round the credit hours to nearest int if (isset($_REQUEST['credits'])) { $i->credits = round($_REQUEST['credits']); } $avg_hours_week = (int) $_REQUEST['avg_hours_week']; $i->avg_hours_week = $avg_hours_week ? $avg_hours_week : null; $i->paid = $_REQUEST['payment'] == 'paid'; $i->stipend = isset($_REQUEST['stipend']) && $i->paid; $i->unpaid = $_REQUEST['payment'] == 'unpaid'; $i->pay_rate = $_REQUEST['pay_rate']; // Internship experience type if (isset($_REQUEST['experience_type'])) { $i->setExperienceType($_REQUEST['experience_type']); } // Set fields depending on domestic/international if ($_REQUEST['location'] == 'domestic') { // Set Flags $i->domestic = 1; $i->international = 0; // Set state if ($_POST['loc_state'] != '-1') { $i->loc_state = strip_tags($_POST['loc_state']); } else { $i->loc_state = null; } // Clear province, country $i->loc_province = ''; $i->loc_country = ''; } else { if ($_REQUEST['location'] == 'internat') { // Set flags $i->domestic = 0; $i->international = 1; // Set province, country $i->loc_province = $_POST['loc_province']; $i->loc_country = strip_tags($_POST['loc_country']); // Clear state $i->loc_state = null; } } // Address, city, zip are always set (no matter domestic or international) $i->loc_address = strip_tags($_POST['loc_address']); $i->loc_city = strip_tags($_POST['loc_city']); $i->loc_zip = strip_tags($_POST['loc_zip']); if (isset($_POST['course_subj']) && $_POST['course_subj'] != '-1') { $i->course_subj = strip_tags($_POST['course_subj']); } else { $i->course_subj = null; } // Course info $i->course_no = strip_tags($_POST['course_no']); $i->course_sect = strip_tags($_POST['course_sect']); $i->course_title = strip_tags($_POST['course_title']); // Multipart course if (isset($_POST['multipart'])) { $i->multi_part = 1; } else { $i->multi_part = 0; } if (isset($_POST['multipart']) && isset($_POST['secondary_part'])) { $i->secondary_part = 1; } else { $i->secondary_part = 0; } // Corequisite Course Info if (isset($_POST['corequisite_course_num'])) { $i->corequisite_number = $_POST['corequisite_course_num']; } if (isset($_POST['corequisite_course_sect'])) { $i->corequisite_section = $_POST['corequisite_course_sect']; } // Student Information $i->first_name = $_REQUEST['student_first_name']; $i->middle_name = $_REQUEST['student_middle_name']; $i->last_name = $_REQUEST['student_last_name']; $i->setFirstNameMetaphone($_REQUEST['student_first_name']); $i->setLastNameMetaphone($_REQUEST['student_last_name']); $i->banner = $_REQUEST['banner']; $i->phone = $_REQUEST['student_phone']; $i->email = $_REQUEST['student_email']; $i->level = $_REQUEST['student_level']; // Check the level and record the major/program for this level. // Be sure to set/clear the other leve's major/program to null // in case the user is switching levels. if ($i->getLevel() == 'ugrad') { $i->ugrad_major = $_REQUEST['ugrad_major']; $i->grad_prog = null; } else { if ($i->getLevel() == 'grad') { $i->grad_prog = $_REQUEST['grad_prog']; $i->ugrad_major = null; } } $i->gpa = $_REQUEST['student_gpa']; $i->campus = $_REQUEST['campus']; $i->student_address = $_REQUEST['student_address']; $i->student_city = $_REQUEST['student_city']; if ($_REQUEST['student_state'] != '-1') { $i->student_state = $_REQUEST['student_state']; } else { $i->student_state = ""; } $i->student_zip = $_REQUEST['student_zip']; /* $i->emergency_contact_name = $_REQUEST['emergency_contact_name']; $i->emergency_contact_relation = $_REQUEST['emergency_contact_relation']; $i->emergency_contact_phone = $_REQUEST['emergency_contact_phone']; */ /************ * OIED Certification */ // If OIED certification has changed, then double check permissions $cert = $i->oied_certified == 1 ? true : false; $certSubmitted = $_POST['oied_certified_hidden'] == 'true' ? true : false; $certChanged = $cert != $certSubmitted; if ($certChanged && !Current_User::allow('intern', 'oied_certify')) { $url = "index.php?module=intern&action=edit_internship&internship_id={$i->getId()}"; NQ::simple('intern', INTERN_ERROR, "You do not have permission to change the OIED certification checkbox. No changes were saved."); NQ::close(); return PHPWS_Core::reroute($url); } // Check if this has changed from non-certified->certified so we can log it later if ($i->oied_certified == 0 && $_POST['oied_certified_hidden'] == 'true') { // note the change for later $oiedCertified = true; } else { $oiedCertified = false; } if ($_POST['oied_certified_hidden'] == 'true') { $i->oied_certified = 1; } else { if ($_POST['oied_certified_hidden'] == 'false') { $i->oied_certified = 0; } else { $i->oied_certified = 0; } } // If we don't have a state and this is a new internship, // the set an initial state if ($i->id == 0 && is_null($i->state)) { PHPWS_Core::initModClass('intern', 'WorkflowStateFactory.php'); $state = WorkflowStateFactory::getState('CreationState'); $i->setState($state); // Set this initial value } try { $i->save(); } catch (Exception $e) { // Rollback and re-throw the exception so that admins gets an email PHPWS_DB::rollback(); throw $e; } PHPWS_DB::commit(); /*************************** * State/Workflow Handling * ***************************/ PHPWS_Core::initModClass('intern', 'WorkflowController.php'); PHPWS_Core::initModClass('intern', 'WorkflowTransitionFactory.php'); $t = WorkflowTransitionFactory::getTransitionByName($_POST['workflow_action']); $workflow = new WorkflowController($i, $t); try { $workflow->doTransition(isset($_POST['notes']) ? $_POST['notes'] : null); } catch (MissingDataException $e) { NQ::simple('intern', INTERN_ERROR, $e->getMessage()); NQ::close(); return PHPWS_Core::reroute('index.php?module=intern&action=edit_internship&internship_id=' . $i->id); } // Create a ChangeHisotry for the OIED certification. if ($oiedCertified) { $currState = WorkflowStateFactory::getState($i->getStateName()); $ch = new ChangeHistory($i, Current_User::getUserObj(), time(), $currState, $currState, 'Certified by OIED'); $ch->save(); } $workflow->doNotification(isset($_POST['notes']) ? $_POST['notes'] : null); if (isset($_REQUEST['internship_id'])) { // Show message if user edited internship NQ::simple('intern', INTERN_SUCCESS, 'Saved internship for ' . $i->getFullName()); NQ::close(); return PHPWS_Core::reroute('index.php?module=intern&action=edit_internship&internship_id=' . $i->id); } else { NQ::simple('intern', INTERN_SUCCESS, 'Added internship for ' . $i->getFullName()); NQ::close(); return PHPWS_Core::reroute('index.php?module=intern&action=edit_internship&internship_id=' . $i->id); } }
/** * [agencyDel description] * @param [type] $agency_id [description] * @return [type] [description] */ public function agencyDel($agency_id) { Agency::where('id', '=', $agency_id)->delete(); return Redirect::to('agency')->with('success', 'ชื่อข้อมูลหน่วยงานรหัส = ' . $agency_id . ' ลบทิ้งสำเร็จ'); }
public function applyForJob($contractor, $job) { if (!($company = $job->company)) { throw new \Exception("Company for this job not found.", 1); return; } // not efficient, need to change if (!($contractor = $this->findById($contractor->id))) { throw new \Exception("Contractor not found.", 1); return; } if ($contractor->jobs->contains($job->id)) { throw new \Exception("You have already applied for this job.", 1); return; } $contractor->jobs()->sync([$job->id => ['status' => 'request', 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]], false); // TODO: Move to background worker $cUser = $contractor->user; $_hash = new Hash(); $_hash = $_hash->getHasher(); $notificationData = ['company_id' => $company->id, 'title' => 'New Job Application', 'alert_from' => $cUser->first_name . ' ' . $cUser->last_name, 'has_read' => false, 'url' => route('company.job.application') . '?i=' . $_hash->encode($job->id)]; $notification = \Company::addNotification($company, $notificationData); if (!is_null($job->agency_id)) { if ($agency = $job->agency) { $notificationData = ['agency_id' => $job->agency_id, 'title' => 'New Job Application', 'alert_from' => $cUser->first_name . ' ' . $cUser->last_name, 'has_read' => false, 'url' => route('agency.job.application') . '?i=' . $_hash->encode($job->id)]; $notification = \Agency::addNotification($agency, $notificationData); } } // END TODO return $contractor; }
public function postRemoveAffiliate() { $_hash = new Hash(); $_hash = $_hash->getHasher(); $id = $_hash->decode(trim(\Input::get('id'))); if (!($agency = \Agency::findAgencyById($id))) { return \Response::json(['type' => 'danger', 'message' => 'Agency not found.']); } try { $affiliate = \Company::removeAffiliate($agency); return \Response::json(['type' => 'success', 'message' => 'Affiliate "' . $agency->name . '" removed.']); } catch (\Exception $e) { return \Response::json(['type' => 'danger', 'message' => $e->getMessage()]); } }
private function assertEqualAgency(Agency $a, Agency $b) { $this->assertTrue($a->getBank()->getBankID() === $b->getBank()->getBankID()); $this->assertTrue($a->getID() === $b->getID()); $this->assertTrue($a->getPostcode() === $b->getPostcode()); $this->assertTrue($a->getCity() === $b->getCity()); $this->assertTrue($a->getName() === $b->getName()); $this->assertTrue($a->getShortTerm() === $b->getShortTerm()); $this->assertTrue($a->hasPAN() === $b->hasPAN()); $this->assertTrue($a->hasBIC() === $b->hasBIC()); if ($a->hasPAN()) { $this->assertTrue($a->getPAN() === $b->getPAN()); } if ($a->hasBIC()) { $this->assertTrue($a->getBIC() === $b->getBIC()); } }
/** * [peerAgencyFrm description] * @return [type] [description] */ public function peerAgencyFrm() { $agency = Agency::all(); return View::make('peer.agencylist')->with('all_agency', $agency); }