public static function getInstance()
{
if (self::$_instance == null) {
self::$_instance = new Performance();
}
return self::$_instance;
}
public function process_evaluation()
{
Performance::add_evaluation();
}
public function actionCreate()
{
// check permissions
// if (!Yii::app()->user->checkAccess('manageUser')) {
// Helper::authException();
// }
// models
$UserLogin = new UserLogin();
$UserProfile = new UserProfile();
$criteria3 = new CDbCriteria();
$criteria3->condition = '(companyID = :companyID AND IsActive=1)';
$criteria3->params = array(':companyID' => Yii::app()->user->companyID);
$criteria3->order = 'Email';
$userManagers = UserProfile::model()->with('userLogin')->findAllByAttributes(array(), $criteria3);
$managersArray = array();
$managersArray[0] = "Please Select...";
foreach ($userManagers as $UserManager) {
//if ($UserManager->ManagerEmail == '') {
//$managersArray[$UserManager->Email] = $UserManager->Email;
$managersArray[$UserManager->Email] = $UserManager->Email;
//} elseif (Helper::hasRole('lacekAdministrator')) {
// $rolesArray[$UserRole->UserRoleID] = $UserRole->RoleDesc;
// }
}
// add default (empty value) to front of array
$managerArray = $managersArray;
// role array for select
$userRoles = UserRole::model()->findAll();
$rolesArray = array();
foreach ($userRoles as $UserRole) {
if ($UserRole->RoleType != 'lacekAdministrator') {
$rolesArray[$UserRole->UserRoleID] = $UserRole->RoleDesc;
} elseif (Helper::hasRole('lacekAdministrator')) {
$rolesArray[$UserRole->UserRoleID] = $UserRole->RoleDesc;
}
}
// add default (empty value) to front of array
$rolesArray = $rolesArray;
// form processing
if (isset($_POST['UserLogin'], $_POST['UserProfile'])) {
// redirect to the dashboard if 'Cancel' button clicked
if (isset($_POST['button-cancel'])) {
$this->redirect($this->createUrl('user/dashboard'));
}
// set UserLogin attributes and scenario
$UserLogin->attributes = $_POST['UserLogin'];
$UserLogin->IsPasswordReset = 1;
// force password reset on first login
$UserLogin->IsActive = 1;
$UserLogin->scenario = 'create';
$UserLogin->UserRoleID = 1;
// set UserProfile attributes
$UserProfile->attributes = $_POST['UserProfile'];
$UserProfile->CompanyID = Yii::app()->user->companyID;
$UserProfile->Email = $UserLogin->LoginEmail;
// validate form submission
$valid = $UserLogin->validate();
$valid = $UserProfile->validate() && $valid;
if ($valid) {
// save UserLogin
if (!$UserLogin->save(false)) {
throw new CHttpException(400, 'Error when trying to create user.');
}
// save UserProfile
$UserProfile->UserLoginID = $UserLogin->UserLoginID;
// set newly generated EventID
if (!$UserProfile->save(false)) {
throw new CHttpException(400, 'Error when trying to create user.');
}
if ($UserProfile->ManagerEmail) {
$UserProfilex = UserProfile::model()->findByAttributes(array('Email' => $UserProfile->ManagerEmail));
$candidateModel = new Candidate();
$candidateModel->CompanyID = $UserProfile->CompanyID;
$candidateModel->EmployeeID = $UserProfile->EmployeeID;
$candidateModel->FirstName = $UserProfile->FirstName;
$candidateModel->MiddleName = $UserProfile->MiddleName;
$candidateModel->LastName = $UserProfile->LastName;
$candidateModel->Title = $UserProfile->Title;
$candidateModel->Email = $UserProfile->Email;
$candidateModel->CompanyPositionID = 1;
$candidateModel->HireDate = date("Y-m-d");
$candidateModel->PositionDate = date("Y-m-d");
$candidateModel->IsActive = 1;
$candidateModel->UserProfileID = $UserProfilex->UserProfileID;
//$candidateModel->UserProfileId=2;
//print_r($candidateModel);
// die($UserProfilex->UserProfileID);
// if ($candidateModel->validate()) {
// if ($candidateModel->save()) {
$candidateModel->save();
$performanceModel = new Performance();
$ratingModel = new Rating();
$planningModel = new Planning();
$currentYear = date('Y');
// insert new record
$performanceModel->CandidateID = $candidateModel->CandidateID;
$performanceModel->PerformanceYear = $currentYear;
$ratingModel->CandidateID = $candidateModel->CandidateID;
$ratingModel->RatingYear = $currentYear;
$planningModel->CandidateID = $candidateModel->CandidateID;
$planningModel->PlanningYear = $currentYear;
$planningModel->CurrentPositionLevel = 3;
$planningModel->NextStepPositionLevel = 3;
$planningModel->LongTermPositionLevel = 3;
$performanceModel->save();
$ratingModel->save();
$planningModel->save();
//}
//}
// else
//{
// $errores = $candidateModel->getErrors();
// print_r($errores);
// die();
// }
}
// set success message for user
Yii::app()->user->setFlash('success', 'A new user was successfully created.');
// return to empty create user form if adding another, else go to user dashboard
if (isset($_POST['button-submit-add'])) {
$this->redirect($this->createUrl('user/create'));
} else {
$this->redirect($this->createUrl('user/dashboard'));
}
}
}
// clear password
$UserLogin->UserPassword = null;
// render view
$this->render('create', array('UserLogin' => $UserLogin, 'UserProfile' => $UserProfile, 'rolesArray' => $rolesArray, 'managersArray' => $managerArray));
}
/**
* @before _secure
*/
public function billing()
{
$this->seo(array("title" => "Billing"));
$view = $this->getActionView();
$bills = Bill::all(["org_id = ?" => $this->org->id], [], "created", "desc");
$invoice = RM::get("invoice", "current");
$imp_cost = 0;
$click_cost = 0;
switch ($invoice) {
case 'current':
$start = RM::get('start', date('Y-m-01'));
$end = RM::get('end', date('Y-m-d'));
$dateQuery = Utils::dateQuery(['start' => $start, 'end' => $end]);
// find advertiser performances to get clicks and impressions
$performances = \Performance::overall($dateQuery, User::all(['org_id' => $this->org->_id, 'type' => 'advertiser'], ['_id']));
$clicks = $performances['total_clicks'];
$impressions = $performances['total_impressions'];
break;
default:
$bill = Bill::first(["org_id = ?" => $this->org->id, "id = ?" => $invoice]);
$start = $bill->start;
$end = $bill->end;
$clicks = $bill->clicks;
$impressions = $bill->impressions;
break;
}
if ($clicks > 1000) {
$click_cost = 0.001 * $clicks * $this->org->meta["bill"]["tcc"];
}
if ($impressions > 1000000) {
$imp_cost = 0.001 * 0.001 * $impressions * $this->org->meta["bill"]["mic"];
}
$view->set(['bills' => $bills, 'clicks' => ['total' => $clicks, 'cost' => $click_cost], 'start' => $start, 'end' => $end, 'invoice' => $invoice, 'impressions' => ['total' => $impressions, 'cost' => $imp_cost]]);
}
/**
* Returns a list of performances for the given Program
* @param int id
* @return array Performances
*/
function getPerformances($eventId)
{
global $logger;
$logger->debug(get_class($this) . "::getPerformances({$eventId})");
$result = array();
// this could be refactored as a subselect
$db = $this->getDbo();
$query = 'SELECT distinct a.eoid as oid, a.scope, a.ticketCode' . ' FROM Activity as a, _ez_relation_ as r, Program as e' . ' WHERE r.oid_b = a.eoid and r.class_a="Program" and r.class_b="Performance"' . ' AND r.oid_a=' . $eventId;
$db->setQuery($query);
$perfs = $db->loadAssocList();
// now get the schedules
foreach ($perfs as $perf) {
$performance = new Performance($perf);
$query = 'SELECT DISTINCT s.eoid as oid, s.startTime, s.endTime ' . ' FROM Schedule as s ' . ' WHERE s.eoid IN ' . ' (select r.oid_b ' . ' from _ez_relation_ as r' . ' where r.class_a="Performance" and r.class_b="Schedule"' . ' AND r.oid_a=' . $performance->getOid() . ')';
$db->setQuery($query);
$schedule = new Schedule($db->loadAssoc());
$performance->setSchedule($schedule);
$result[] = $performance;
}
return $result;
}
/**
* A sample detail bean for use in rendering the template.
* If a course is supplied, it will copy thevalues of the
* given bean over the top of the demo bean.
* @return
*/
private function getDemoCourseDetail($crse)
{
require_once WEB_INF . '/beans/Performance.php';
require_once WEB_INF . '/beans/Schedule.php';
require_once WEB_INF . '/beans/Venue.php';
global $logger;
$logger->debug(get_class($this) . "::getDemoCourseDetail({$crse})");
$bean = new Course();
$bean->setTitle("Demo Course Detail Bean");
$desc = "<p>This is a description of the course. Malian Grammy Award nominee Mamadou Diabate is a virtuoso kora player descended from a long line of Manding musician-storytellers. Dolor dignissim exerci feugiat. Lobortis ut, luptatum facilisis. Augue volutpat facilisis at, eum consequat adipiscing accumsan blandit molestie. </p>\n\t\t\t\t <p>Lobortis eros at hendrerit luptatum consequat feugiat ut facilisi commodo esse autem consequat at ex ullamcorper hendrerit wisi, commodo nostrud nisl wisi eum autem eu esse eu iriure. Tation, magna ad nibh at eum, ea praesent eum lorem eu erat enim commodo dolore?</p>\n \t\t\t\t <p>Crisare enim sed ex eros hendrerit blandit illum qui sciurus autem nulla enim luptatum. Quis enim eum feugait elit blandit, hendrerit consequat, velit ut luptatum nostrud wisi ea. Dignissim consequat dolore aliquam eum volutpat, wisi dolore et exerci nisl veniam luptatum ut ullamcorper consequatvel nulla delenit.</p>\n\t\t\t\t";
$bean->setDescription($desc);
$bean->setPrimaryGenre("Music");
// Performances
$perf = new Performance();
$schd = new Schedule();
$schd->setStartTime(time());
$perf->setSchedule($schd);
$logger->debug("Performance time: " . $perf->getSchedule()->getStartTime());
$perf->setTicketCode("21");
$bean->setChildren(array($perf));
$logger->debug("Number of set performaces: " . count($bean->getChildren()));
// Venues
$v1 = new Venue();
$v1->setName('Hurd Gallery');
$bean->setDefaultVenue($v1);
if (get_class($crse) == 'Course') {
$crse->setPerformances(null);
$option = new CopyBeanOption();
$option->setIgnoreNullValues(true);
BeanUtil::copyBean($crse, $bean, $option);
}
return $bean;
}
define('ERROR_EN', 'none');
break;
default:
//No realiza el llamado a funcion de error porque todavia no se cargo el modulo de errores
$head = 'Configuration Erron';
$message = 'The environment is not defined in configuration.json';
require $path_aplication . 'errors/general_error.php';
exit;
}
//Carga la clase Rendimiento
require $path_framework . 'classes/Performance.php';
//Analiza si calcula el tiempo que tarda la aplicacion en ejecutarse
$performance = NULL;
if ($config['calculate_performance'] == 'TRUE' || $config['calculate_performance'] == 'true') {
//Incluye la clase Rendimiento
$performance = new Performance();
$performance->start();
}
//Seteo la codificacion de caracteres, casi siempre es o debe ser UTF-8
ini_set('default_charset', $config['charset']);
// Define las constantes del sistema
// BASE_URL: Base url de la aplicacion - definida por el usuario en el archivo de configuracion
$pos = strlen($config['base_url']) - 1;
if ($config['base_url'][$pos] != '/') {
$config['base_url'] .= '/';
}
define('BASEURL', $config['base_url']);
//INDEX_PAGE: Pagina inicial. En blanco si se utiliza mod_rewrite
define('INDEX_PAGE', $config['index_page']);
//ENVIRONMENT: Indica el ambiente de la aplicacion
define('ENVIRONMENT', $config['environment']);
/**
* Returns data of clicks, impressions, payouts for publishers with custom date range
* @before _secure
*/
public function performance()
{
$this->JSONview();
$view = $this->getActionView();
$start = RM::get("start", date("Y-m-d", strtotime('-7 day')));
$end = RM::get("end", date("Y-m-d", strtotime('now')));
$dateQuery = Utils::dateQuery(['start' => $start, 'end' => $end]);
$find = Performance::overall($dateQuery, $this->user);
$view->set($find);
}
/**
* @before _admin
*/
public function info($id = null)
{
$this->seo(array("title" => "Publisher Edit"));
$view = $this->getActionView();
$publisher = User::first(["_id = ?" => $id, "type = ?" => "publisher", "org_id = ?" => $this->org->id]);
if (!$publisher) {
$this->_404();
}
$platforms = Platform::all(["user_id = ?" => $publisher->id]);
$view->set("platforms", $platforms);
$view->set("errors", []);
if (RM::type() == 'POST') {
$action = RM::post('action', '');
switch ($action) {
case 'account':
$fields = ['name', 'email', 'phone', 'country', 'currency', 'username'];
foreach ($fields as $f) {
$publisher->{$f} = RM::post($f);
}
$publisher->save();
$view->set('message', 'Account Info updated!!');
break;
case 'password':
$old = RM::post('password');
$new = RM::post('npassword');
$view->set($publisher->updatePassword($old, $new));
break;
case 'campaign':
$publisher->getMeta()['campaign'] = ['model' => RM::post('model'), 'rate' => $this->currency(RM::post('rate'))];
$publisher->save();
$view->set('message', 'Payout Info Updated!!');
break;
case 'trackingDomain':
$tdomain = (array) RM::post('tdomain', '');
if ($tdomain && ArrayMethods::inArray($this->org->tdomains, $tdomain)) {
$publisher->getMeta()['tdomain'] = $tdomain;
$publisher->save();
$view->set('message', 'Added Tracking Domain for publisher');
} else {
$view->set('message', 'Invalid Request!!');
}
case 'commadd':
case 'commedit':
$comm_id = RM::post('comm_id');
if ($comm_id) {
$comm = Commission::first(['_id' => $comm_id, 'user_id' => $publisher->_id]);
} else {
$comm = new Commission(['user_id' => $publisher->_id]);
}
$comm->model = RM::post('model');
$comm->description = RM::post('description');
$comm->rate = $this->currency(RM::post('rate'));
$comm->coverage = RM::post('coverage', ['ALL']);
$comm->save();
$view->set('message', "Multi Country Payout Saved!!");
break;
}
}
if (RM::type() === 'DELETE') {
$action = RM::get("action");
switch ($action) {
case 'payoutdel':
unset($publisher->getMeta()['campaign']);
$publisher->save();
$view->set('message', 'Payout Deleted!!');
break;
case 'commDel':
$comm = Commission::first(['_id' => RM::get("comm_id"), 'user_id' => $publisher->_id]);
if ($comm) {
$comm->delete();
$view->set('message', 'Payout Deleted!!');
} else {
$view->set('message', 'Invalid Request!!');
}
break;
case 'afields':
$meta = $publisher->meta;
$publisher->removeFields();
unset($meta['afields']);
Db::updateRaw('users', ['_id' => Db::convertType($publisher->_id, 'id')], ['$set' => ['meta' => $meta]]);
$view->set('message', 'Data Removed!!');
break;
case 'defaultDomain':
unset($publisher->getMeta()['tdomain']);
$publisher->save();
$view->set('message', 'Removed tracking domain!!');
break;
}
}
$afields = Meta::search('customField', $this->org);
$view->set('afields', $afields)->set("publisher", $publisher)->set("commissions", Commission::all(["user_id = ?" => $publisher->id]))->set("start", strftime("%Y-%m-%d", strtotime('-7 day')))->set("end", strftime("%Y-%m-%d", strtotime('now')))->set("d", Performance::total(['start' => $start ?? $publisher->created->format('Y-m-d'), 'end' => $end ?? date('Y-m-d')], $publisher));
}
public function postPerfReports()
{
$filter = "go";
$deptL = Input::get('deptid');
$sem = Input::get('semester');
$year = Input::get('year');
/*if($dept == "*"){
$users = Performance::all();
$deptid = "*";
}else{
$users = User::where('department_id', $dept)->get();
$deptid = Department::where('id', $dept)->get();
}*/
$sampleArray = ['dept_id' => '1', 'semester' => '2015'];
$sample = Performance::where($sampleArray)->get();
$users = 'Performance';
$matchThese = array();
//If user chooses from dropdown
if ($deptL != "*") {
//If true insert this to variable
$matchThese = array_add($matchThese, 'dept_id', $deptL);
/***********Add Array*****************/
//If user chooses from dropdown
if ($sem != "*") {
//If true insert this to variable
$matchThese = array_add($matchThese, 'semester', $sem);
if ($year != "All") {
$matchThese = array_add($matchThese, 'year', $year);
$query = $users::where($matchThese)->orderBy('overall', 'desc')->get();
} else {
$query = $users::where($matchThese)->orderBy('overall', 'desc')->get();
}
} else {
//===========Else of Semester
if ($year != "All") {
$matchThese = array_add($matchThese, 'year', $year);
$query = $users::where($matchThese)->orderBy('overall', 'desc')->get();
} else {
//===========Else of Year
$query = $users::where($matchThese)->orderBy('overall', 'desc')->get();
}
$query = $users::where($matchThese)->orderBy('overall', 'desc')->get();
}
/***********End Add Array*****************/
} else {
//===========Else of Department
/*************Add Array***************/
if ($sem != "*") {
//If true insert this to variable
$matchThese = array_add($matchThese, 'semester', $sem);
if ($year != "All") {
$matchThese = array_add($matchThese, 'year', $year);
$query = $users::where($matchThese)->orderBy('overall', 'desc')->get();
} else {
$query = $users::where($matchThese)->orderBy('overall', 'desc')->get();
}
} else {
//===========Else of Semester
if ($year != "All") {
$matchThese = array_add($matchThese, 'year', $year);
$query = $users::where($matchThese)->orderBy('overall', 'desc')->get();
} else {
//===========Else of Year
$query = $users::all();
}
}
/************End Add Array****************/
}
$count = $query->count();
if (empty($count)) {
return Redirect::route('perf-reports');
}
$out = 0;
$exemP = 0;
$exem = 0;
$noteP = 0;
$note = 0;
$satP = 0;
$sat = 0;
$fair = 0;
$un = 0;
foreach ($query as $perf) {
$u = $perf->utilities;
$qow = $perf->workQuality;
$pffp = $perf->potential;
$overall = number_format(($u + $qow + $pffp) / 3, 2);
$rating = ParRatingsRef::where('upper_limit', '>=', $overall)->where('lower_limit', '<=', $overall)->first();
//============================Conditions=================//
if ($rating->adjectival == 'O') {
$out++;
} elseif ($rating->adjectival == 'E+') {
$exemP++;
} elseif ($rating->adjectival == 'E') {
$exem++;
} elseif ($rating->adjectival == 'N+') {
$noteP++;
} elseif ($rating->adjectival == 'N') {
$note++;
} elseif ($rating->adjectival == 'S+') {
$satP++;
} elseif ($rating->adjectival == 'S') {
$sat++;
} elseif ($rating->adjectival == 'F') {
$fair++;
} elseif ($rating->adjectival == 'U') {
$un++;
}
}
//========================Percentage================//
$percent_out = $out / $count * 100;
$percent_exemP = $exemP / $count * 100;
$percent_exem = $exem / $count * 100;
$percent_satP = $satP / $count * 100;
$percent_sat = $sat / $count * 100;
$percent_noteP = $noteP / $count * 100;
$percent_note = $note / $count * 100;
$percent_fair = $fair / $count * 100;
$percent_un = $un / $count * 100;
//====================================LavaChart==================================//
$lava = new Lavacharts();
// See note below for Laravel
$overall = Lava::DataTable();
$overall->addStringColumn('Reasons')->addNumberColumn('Percent')->addRow(array('Outstanding (' . $out . ')', $percent_out))->addRow(array('Exemplary Plus (' . $exemP . ')', $percent_exemP))->addRow(array('Exemplary (' . $exem . ')', $percent_exem))->addRow(array('Noteworthy Plus(' . $noteP . ')', $percent_noteP))->addRow(array('Noteworthy (' . $note . ')', $percent_note))->addRow(array('Satisfactory Plus (' . $satP . ')', $percent_satP))->addRow(array('Satisfactory (' . $sat . ')', $percent_sat))->addRow(array('Fair (' . $fair . ')', $percent_fair))->addRow(array('Unutilized (' . $un . ')', $percent_un));
$piechart = Lava::PieChart('IMDB')->setOptions(array('datatable' => $overall, 'title' => 'Performance Overall Rating (Total: ' . $count . ')', 'is3D' => true, 'slices' => array(Lava::Slice(array('offset' => 0.2)), Lava::Slice(array('offset' => 0.25)), Lava::Slice(array('offset' => 0.3)))));
/*
$userquery = User::query();
$deptidquery = Department::query();
if($dept == "*"){
$deptidquery = "*";
$users = User::all();
}else{
$userquery = $userquery->where('department_id', $dept);
$deptidquery = $deptidquery->where('id', $dept);
}
$users = $userquery->get();
$deptid = $deptidquery->get();*/
Session::put('deptpdf', $deptL);
if ($deptL == '*') {
$deptL = 'All';
} else {
$deptL = Department::where('id', $deptL)->pluck('name');
}
//------------------------------
if ($sem == '*') {
$sem = 'All';
}
if ($year == '*') {
$year = 'All';
}
Session::put('sempdf', $sem);
Session::put('yearpdf', $year);
$audit = AuditTrail::create(['user_id' => Auth::id(), 'role' => 'Performance System Admin', 'action' => 'filtered the performance reports.']);
return View::make('perf.perf-reports')->with('query', $query)->with('filter', $filter)->with('deptL', $deptL)->with('sem', $sem)->with('year', $year);
/*
if($dept == "*"){
$users = User::all();
$deptid = "*";
}else{
$users = User::where('department_id', $dept)->get();
$deptid = Department::where('id', $dept)->get();
}
return View::make('emp.ems-reports')
->with('users', $users)
->with('deptid', $deptid);*/
}
protected function perf($clicks, $arr, $dq = [])
{
$perf = new Performance();
$commissions = [];
$classify = \Click::classify($clicks, 'adid');
foreach ($classify as $key => $value) {
$countryWise = \Click::classify($value, 'country');
foreach ($countryWise as $country => $records) {
$adClicks = count($records);
$updateData = [];
$extra = array_merge($arr, $dq);
$info = \Commission::campaignRate($key, $commissions, $country, $extra);
$earning = \Ad::earning($info, $adClicks);
\Framework\ArrayMethods::copy($earning, $updateData);
$perf->update($updateData);
}
}
return $perf;
}
public function run()
{
$faker = Faker\Factory::create();
//=================================== For single user and no loop==================//
/* Performance::create([
'user_id' => 2,
'dept_id'=> 1,
'util1' => $faker->numberBetween($min = 1, $max = 5),
'util2' => $faker->numberBetween($min = 1, $max = 5),
'util3' => $faker->numberBetween($min = 1, $max = 5),
'qow1' => $faker->numberBetween($min = 1, $max = 5),
'qow2' => $faker->numberBetween($min = 1, $max = 5),
'qow3' => $faker->numberBetween($min = 1, $max = 5),
'qow4' => $faker->numberBetween($min = 1, $max = 5),
'qow5' => $faker->numberBetween($min = 1, $max = 5),
'qow6' => $faker->numberBetween($min = 1, $max = 5),
'qow7' => $faker->numberBetween($min = 1, $max = 5),
'qow8' => $faker->numberBetween($min = 1, $max = 5),
'pffp1' => $faker->numberBetween($min = 1, $max = 5),
'pffp2' => $faker->numberBetween($min = 1, $max = 5),
'pffp3' => $faker->numberBetween($min = 1, $max = 5),
'pffp4' => $faker->numberBetween($min = 1, $max = 5),
'pffp5' => $faker->numberBetween($min = 1, $max = 5),
'pffp6' => $faker->numberBetween($min = 1, $max = 5),
'pffp7' => $faker->numberBetween($min = 1, $max = 5),
'pffp8' => $faker->numberBetween($min = 1, $max = 5),
'pffp9' => $faker->numberBetween($min = 1, $max = 5),
'pffp10' => $faker->numberBetween($min = 1, $max = 5),
'pffp11' => $faker->numberBetween($min = 1, $max = 5),
'comments' => $faker->text(100),
'status' => 'Finalized',
'semester' => '2nd',
'year' => '2015'
]);
Performance::create([
'user_id' => 2,
'dept_id' => 1,
'util1' => $faker->numberBetween($min = 1, $max = 5),
'util2' => $faker->numberBetween($min = 1, $max = 5),
'util3' => $faker->numberBetween($min = 1, $max = 5),
'qow1' => $faker->numberBetween($min = 1, $max = 5),
'qow2' => $faker->numberBetween($min = 1, $max = 5),
'qow3' => $faker->numberBetween($min = 1, $max = 5),
'qow4' => $faker->numberBetween($min = 1, $max = 5),
'qow5' => $faker->numberBetween($min = 1, $max = 5),
'qow6' => $faker->numberBetween($min = 1, $max = 5),
'qow7' => $faker->numberBetween($min = 1, $max = 5),
'qow8' => $faker->numberBetween($min = 1, $max = 5),
'pffp1' => $faker->numberBetween($min = 1, $max = 5),
'pffp2' => $faker->numberBetween($min = 1, $max = 5),
'pffp3' => $faker->numberBetween($min = 1, $max = 5),
'pffp4' => $faker->numberBetween($min = 1, $max = 5),
'pffp5' => $faker->numberBetween($min = 1, $max = 5),
'pffp6' => $faker->numberBetween($min = 1, $max = 5),
'pffp7' => $faker->numberBetween($min = 1, $max = 5),
'pffp8' => $faker->numberBetween($min = 1, $max = 5),
'pffp9' => $faker->numberBetween($min = 1, $max = 5),
'pffp10' => $faker->numberBetween($min = 1, $max = 5),
'pffp11' => $faker->numberBetween($min = 1, $max = 5),
'comments' => $faker->text(100),
'status' => 'Finalized',
'semester' => '1st',
'year' => '2015'
]);
Performance::create([
'user_id' => 4,
'dept_id' => 2,
'util1' => $faker->numberBetween($min = 1, $max = 5),
'util2' => $faker->numberBetween($min = 1, $max = 5),
'util3' => $faker->numberBetween($min = 1, $max = 5),
'qow1' => $faker->numberBetween($min = 1, $max = 5),
'qow2' => $faker->numberBetween($min = 1, $max = 5),
'qow3' => $faker->numberBetween($min = 1, $max = 5),
'qow4' => $faker->numberBetween($min = 1, $max = 5),
'qow5' => $faker->numberBetween($min = 1, $max = 5),
'qow6' => $faker->numberBetween($min = 1, $max = 5),
'qow7' => $faker->numberBetween($min = 1, $max = 5),
'qow8' => $faker->numberBetween($min = 1, $max = 5),
'pffp1' => $faker->numberBetween($min = 1, $max = 5),
'pffp2' => $faker->numberBetween($min = 1, $max = 5),
'pffp3' => $faker->numberBetween($min = 1, $max = 5),
'pffp4' => $faker->numberBetween($min = 1, $max = 5),
'pffp5' => $faker->numberBetween($min = 1, $max = 5),
'pffp6' => $faker->numberBetween($min = 1, $max = 5),
'pffp7' => $faker->numberBetween($min = 1, $max = 5),
'pffp8' => $faker->numberBetween($min = 1, $max = 5),
'pffp9' => $faker->numberBetween($min = 1, $max = 5),
'pffp10' => $faker->numberBetween($min = 1, $max = 5),
'pffp11' => $faker->numberBetween($min = 1, $max = 5),
'comments' => $faker->text(100),
'status' => 'Finalized',
'semester' => '2nd',
'year' => '2015'
]);
Performance::create([
'user_id' => 4,
'dept_id' => 2,
'util1' => $faker->numberBetween($min = 1, $max = 5),
'util2' => $faker->numberBetween($min = 1, $max = 5),
'util3' => $faker->numberBetween($min = 1, $max = 5),
'qow1' => $faker->numberBetween($min = 1, $max = 5),
'qow2' => $faker->numberBetween($min = 1, $max = 5),
'qow3' => $faker->numberBetween($min = 1, $max = 5),
'qow4' => $faker->numberBetween($min = 1, $max = 5),
'qow5' => $faker->numberBetween($min = 1, $max = 5),
'qow6' => $faker->numberBetween($min = 1, $max = 5),
'qow7' => $faker->numberBetween($min = 1, $max = 5),
'qow8' => $faker->numberBetween($min = 1, $max = 5),
'pffp1' => $faker->numberBetween($min = 1, $max = 5),
'pffp2' => $faker->numberBetween($min = 1, $max = 5),
'pffp3' => $faker->numberBetween($min = 1, $max = 5),
'pffp4' => $faker->numberBetween($min = 1, $max = 5),
'pffp5' => $faker->numberBetween($min = 1, $max = 5),
'pffp6' => $faker->numberBetween($min = 1, $max = 5),
'pffp7' => $faker->numberBetween($min = 1, $max = 5),
'pffp8' => $faker->numberBetween($min = 1, $max = 5),
'pffp9' => $faker->numberBetween($min = 1, $max = 5),
'pffp10' => $faker->numberBetween($min = 1, $max = 5),
'pffp11' => $faker->numberBetween($min = 1, $max = 5),
'comments' => $faker->text(100),
'status' => 'Finalized',
'semester' => '1st',
'year' => '2015'
]);
*/
//================================================================================================//
for ($id = 2; $id < 5; $id++) {
$user = User::find($id);
Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 4, $max = 6), 'util2' => $faker->numberBetween($min = 4, $max = 6), 'util3' => $faker->numberBetween($min = 4, $max = 6), 'qow1' => $faker->numberBetween($min = 4, $max = 6), 'qow2' => $faker->numberBetween($min = 4, $max = 6), 'qow3' => $faker->numberBetween($min = 4, $max = 6), 'qow4' => $faker->numberBetween($min = 4, $max = 6), 'qow5' => $faker->numberBetween($min = 4, $max = 6), 'qow6' => $faker->numberBetween($min = 4, $max = 6), 'qow7' => $faker->numberBetween($min = 4, $max = 6), 'qow8' => $faker->numberBetween($min = 4, $max = 6), 'pffp1' => $faker->numberBetween($min = 4, $max = 6), 'pffp2' => $faker->numberBetween($min = 4, $max = 6), 'pffp3' => $faker->numberBetween($min = 4, $max = 6), 'pffp4' => $faker->numberBetween($min = 4, $max = 6), 'pffp5' => $faker->numberBetween($min = 4, $max = 6), 'pffp6' => $faker->numberBetween($min = 4, $max = 6), 'pffp7' => $faker->numberBetween($min = 4, $max = 6), 'pffp8' => $faker->numberBetween($min = 4, $max = 6), 'pffp9' => $faker->numberBetween($min = 4, $max = 6), 'pffp10' => $faker->numberBetween($min = 4, $max = 6), 'pffp11' => $faker->numberBetween($min = 4, $max = 6), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '1st', 'year' => '2015']);
}
for ($id = 2; $id < 5; $id++) {
$user = User::find($id);
Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 5, $max = 6), 'util2' => $faker->numberBetween($min = 5, $max = 6), 'util3' => $faker->numberBetween($min = 5, $max = 6), 'qow1' => $faker->numberBetween($min = 5, $max = 6), 'qow2' => $faker->numberBetween($min = 5, $max = 6), 'qow3' => $faker->numberBetween($min = 5, $max = 6), 'qow4' => $faker->numberBetween($min = 5, $max = 6), 'qow5' => $faker->numberBetween($min = 5, $max = 6), 'qow6' => $faker->numberBetween($min = 5, $max = 6), 'qow7' => $faker->numberBetween($min = 5, $max = 6), 'qow8' => $faker->numberBetween($min = 5, $max = 6), 'pffp1' => $faker->numberBetween($min = 5, $max = 6), 'pffp2' => $faker->numberBetween($min = 5, $max = 6), 'pffp3' => $faker->numberBetween($min = 5, $max = 6), 'pffp4' => $faker->numberBetween($min = 5, $max = 6), 'pffp5' => $faker->numberBetween($min = 5, $max = 6), 'pffp6' => $faker->numberBetween($min = 5, $max = 6), 'pffp7' => $faker->numberBetween($min = 5, $max = 6), 'pffp8' => $faker->numberBetween($min = 5, $max = 6), 'pffp9' => $faker->numberBetween($min = 5, $max = 6), 'pffp10' => $faker->numberBetween($min = 5, $max = 6), 'pffp11' => $faker->numberBetween($min = 5, $max = 6), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '2nd', 'year' => '2015']);
}
for ($id = 2; $id < 5; $id++) {
$user = User::find($id);
Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 5, $max = 6), 'util2' => $faker->numberBetween($min = 5, $max = 6), 'util3' => $faker->numberBetween($min = 5, $max = 6), 'qow1' => $faker->numberBetween($min = 5, $max = 6), 'qow2' => $faker->numberBetween($min = 5, $max = 6), 'qow3' => $faker->numberBetween($min = 5, $max = 6), 'qow4' => $faker->numberBetween($min = 5, $max = 6), 'qow5' => $faker->numberBetween($min = 5, $max = 6), 'qow6' => $faker->numberBetween($min = 5, $max = 6), 'qow7' => $faker->numberBetween($min = 5, $max = 6), 'qow8' => $faker->numberBetween($min = 5, $max = 6), 'pffp1' => $faker->numberBetween($min = 5, $max = 6), 'pffp2' => $faker->numberBetween($min = 5, $max = 6), 'pffp3' => $faker->numberBetween($min = 5, $max = 6), 'pffp4' => $faker->numberBetween($min = 5, $max = 6), 'pffp5' => $faker->numberBetween($min = 5, $max = 6), 'pffp6' => $faker->numberBetween($min = 5, $max = 6), 'pffp7' => $faker->numberBetween($min = 5, $max = 6), 'pffp8' => $faker->numberBetween($min = 5, $max = 6), 'pffp9' => $faker->numberBetween($min = 5, $max = 6), 'pffp10' => $faker->numberBetween($min = 5, $max = 6), 'pffp11' => $faker->numberBetween($min = 5, $max = 6), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '1st', 'year' => '2015']);
}
for ($id = 2; $id < 5; $id++) {
$user = User::find($id);
Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 5, $max = 6), 'util2' => $faker->numberBetween($min = 5, $max = 6), 'util3' => $faker->numberBetween($min = 5, $max = 6), 'qow1' => $faker->numberBetween($min = 5, $max = 6), 'qow2' => $faker->numberBetween($min = 5, $max = 6), 'qow3' => $faker->numberBetween($min = 5, $max = 6), 'qow4' => $faker->numberBetween($min = 5, $max = 6), 'qow5' => $faker->numberBetween($min = 5, $max = 6), 'qow6' => $faker->numberBetween($min = 5, $max = 6), 'qow7' => $faker->numberBetween($min = 5, $max = 6), 'qow8' => $faker->numberBetween($min = 5, $max = 6), 'pffp1' => $faker->numberBetween($min = 5, $max = 6), 'pffp2' => $faker->numberBetween($min = 5, $max = 6), 'pffp3' => $faker->numberBetween($min = 5, $max = 6), 'pffp4' => $faker->numberBetween($min = 5, $max = 6), 'pffp5' => $faker->numberBetween($min = 5, $max = 6), 'pffp6' => $faker->numberBetween($min = 5, $max = 6), 'pffp7' => $faker->numberBetween($min = 5, $max = 6), 'pffp8' => $faker->numberBetween($min = 5, $max = 6), 'pffp9' => $faker->numberBetween($min = 5, $max = 6), 'pffp10' => $faker->numberBetween($min = 5, $max = 6), 'pffp11' => $faker->numberBetween($min = 5, $max = 6), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '2nd', 'year' => '2015']);
}
for ($id = 5; $id < 19; $id++) {
$user = User::find($id);
Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 1, $max = 6), 'util2' => $faker->numberBetween($min = 1, $max = 6), 'util3' => $faker->numberBetween($min = 1, $max = 6), 'qow1' => $faker->numberBetween($min = 1, $max = 6), 'qow2' => $faker->numberBetween($min = 1, $max = 6), 'qow3' => $faker->numberBetween($min = 1, $max = 4), 'qow4' => $faker->numberBetween($min = 1, $max = 4), 'qow5' => $faker->numberBetween($min = 1, $max = 4), 'qow6' => $faker->numberBetween($min = 1, $max = 4), 'qow7' => $faker->numberBetween($min = 1, $max = 4), 'qow8' => $faker->numberBetween($min = 1, $max = 2), 'pffp1' => $faker->numberBetween($min = 1, $max = 2), 'pffp2' => $faker->numberBetween($min = 1, $max = 2), 'pffp3' => $faker->numberBetween($min = 1, $max = 2), 'pffp4' => $faker->numberBetween($min = 1, $max = 2), 'pffp5' => $faker->numberBetween($min = 1, $max = 3), 'pffp6' => $faker->numberBetween($min = 1, $max = 3), 'pffp7' => $faker->numberBetween($min = 1, $max = 3), 'pffp8' => $faker->numberBetween($min = 1, $max = 3), 'pffp9' => $faker->numberBetween($min = 1, $max = 3), 'pffp10' => $faker->numberBetween($min = 1, $max = 4), 'pffp11' => $faker->numberBetween($min = 1, $max = 4), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '1st', 'year' => '2015']);
}
for ($id = 5; $id < 19; $id++) {
$user = User::find($id);
Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 1, $max = 6), 'util2' => $faker->numberBetween($min = 1, $max = 6), 'util3' => $faker->numberBetween($min = 1, $max = 6), 'qow1' => $faker->numberBetween($min = 1, $max = 6), 'qow2' => $faker->numberBetween($min = 1, $max = 6), 'qow3' => $faker->numberBetween($min = 1, $max = 6), 'qow4' => $faker->numberBetween($min = 1, $max = 6), 'qow5' => $faker->numberBetween($min = 1, $max = 6), 'qow6' => $faker->numberBetween($min = 1, $max = 6), 'qow7' => $faker->numberBetween($min = 1, $max = 6), 'qow8' => $faker->numberBetween($min = 1, $max = 6), 'pffp1' => $faker->numberBetween($min = 1, $max = 6), 'pffp2' => $faker->numberBetween($min = 1, $max = 6), 'pffp3' => $faker->numberBetween($min = 1, $max = 6), 'pffp4' => $faker->numberBetween($min = 1, $max = 6), 'pffp5' => $faker->numberBetween($min = 1, $max = 6), 'pffp6' => $faker->numberBetween($min = 1, $max = 6), 'pffp7' => $faker->numberBetween($min = 1, $max = 6), 'pffp8' => $faker->numberBetween($min = 1, $max = 6), 'pffp9' => $faker->numberBetween($min = 1, $max = 6), 'pffp10' => $faker->numberBetween($min = 1, $max = 6), 'pffp11' => $faker->numberBetween($min = 1, $max = 6), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '2nd', 'year' => '2015']);
}
for ($id = 2; $id < 5; $id++) {
$user = User::find($id);
Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 5, $max = 6), 'util2' => $faker->numberBetween($min = 5, $max = 6), 'util3' => $faker->numberBetween($min = 5, $max = 6), 'qow1' => $faker->numberBetween($min = 5, $max = 6), 'qow2' => $faker->numberBetween($min = 5, $max = 6), 'qow3' => $faker->numberBetween($min = 5, $max = 6), 'qow4' => $faker->numberBetween($min = 5, $max = 6), 'qow5' => $faker->numberBetween($min = 5, $max = 6), 'qow6' => $faker->numberBetween($min = 5, $max = 6), 'qow7' => $faker->numberBetween($min = 5, $max = 6), 'qow8' => $faker->numberBetween($min = 5, $max = 6), 'pffp1' => $faker->numberBetween($min = 5, $max = 6), 'pffp2' => $faker->numberBetween($min = 5, $max = 6), 'pffp3' => $faker->numberBetween($min = 5, $max = 6), 'pffp4' => $faker->numberBetween($min = 5, $max = 6), 'pffp5' => $faker->numberBetween($min = 5, $max = 6), 'pffp6' => $faker->numberBetween($min = 5, $max = 6), 'pffp7' => $faker->numberBetween($min = 5, $max = 6), 'pffp8' => $faker->numberBetween($min = 5, $max = 6), 'pffp9' => $faker->numberBetween($min = 5, $max = 6), 'pffp10' => $faker->numberBetween($min = 5, $max = 6), 'pffp11' => $faker->numberBetween($min = 5, $max = 6), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '1st', 'year' => '2014']);
}
for ($id = 2; $id < 5; $id++) {
$user = User::find($id);
Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 5, $max = 6), 'util2' => $faker->numberBetween($min = 5, $max = 6), 'util3' => $faker->numberBetween($min = 5, $max = 6), 'qow1' => $faker->numberBetween($min = 5, $max = 6), 'qow2' => $faker->numberBetween($min = 5, $max = 6), 'qow3' => $faker->numberBetween($min = 5, $max = 6), 'qow4' => $faker->numberBetween($min = 5, $max = 6), 'qow5' => $faker->numberBetween($min = 5, $max = 6), 'qow6' => $faker->numberBetween($min = 5, $max = 6), 'qow7' => $faker->numberBetween($min = 5, $max = 6), 'qow8' => $faker->numberBetween($min = 5, $max = 6), 'pffp1' => $faker->numberBetween($min = 5, $max = 6), 'pffp2' => $faker->numberBetween($min = 5, $max = 6), 'pffp3' => $faker->numberBetween($min = 5, $max = 6), 'pffp4' => $faker->numberBetween($min = 5, $max = 6), 'pffp5' => $faker->numberBetween($min = 5, $max = 6), 'pffp6' => $faker->numberBetween($min = 5, $max = 6), 'pffp7' => $faker->numberBetween($min = 5, $max = 6), 'pffp8' => $faker->numberBetween($min = 5, $max = 6), 'pffp9' => $faker->numberBetween($min = 5, $max = 6), 'pffp10' => $faker->numberBetween($min = 5, $max = 6), 'pffp11' => $faker->numberBetween($min = 5, $max = 6), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '2nd', 'year' => '2014']);
}
for ($id = 5; $id < 19; $id++) {
$user = User::find($id);
Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 1, $max = 6), 'util2' => $faker->numberBetween($min = 1, $max = 6), 'util3' => $faker->numberBetween($min = 1, $max = 6), 'qow1' => $faker->numberBetween($min = 1, $max = 6), 'qow2' => $faker->numberBetween($min = 1, $max = 6), 'qow3' => $faker->numberBetween($min = 1, $max = 4), 'qow4' => $faker->numberBetween($min = 1, $max = 4), 'qow5' => $faker->numberBetween($min = 1, $max = 4), 'qow6' => $faker->numberBetween($min = 1, $max = 4), 'qow7' => $faker->numberBetween($min = 1, $max = 4), 'qow8' => $faker->numberBetween($min = 1, $max = 2), 'pffp1' => $faker->numberBetween($min = 1, $max = 2), 'pffp2' => $faker->numberBetween($min = 1, $max = 2), 'pffp3' => $faker->numberBetween($min = 1, $max = 2), 'pffp4' => $faker->numberBetween($min = 1, $max = 2), 'pffp5' => $faker->numberBetween($min = 1, $max = 3), 'pffp6' => $faker->numberBetween($min = 1, $max = 3), 'pffp7' => $faker->numberBetween($min = 1, $max = 3), 'pffp8' => $faker->numberBetween($min = 1, $max = 3), 'pffp9' => $faker->numberBetween($min = 1, $max = 3), 'pffp10' => $faker->numberBetween($min = 1, $max = 4), 'pffp11' => $faker->numberBetween($min = 1, $max = 4), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '1st', 'year' => '2014']);
}
for ($id = 5; $id < 19; $id++) {
$user = User::find($id);
Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 1, $max = 6), 'util2' => $faker->numberBetween($min = 1, $max = 6), 'util3' => $faker->numberBetween($min = 1, $max = 6), 'qow1' => $faker->numberBetween($min = 1, $max = 6), 'qow2' => $faker->numberBetween($min = 1, $max = 6), 'qow3' => $faker->numberBetween($min = 1, $max = 4), 'qow4' => $faker->numberBetween($min = 1, $max = 4), 'qow5' => $faker->numberBetween($min = 1, $max = 4), 'qow6' => $faker->numberBetween($min = 1, $max = 4), 'qow7' => $faker->numberBetween($min = 1, $max = 4), 'qow8' => $faker->numberBetween($min = 1, $max = 2), 'pffp1' => $faker->numberBetween($min = 1, $max = 2), 'pffp2' => $faker->numberBetween($min = 1, $max = 2), 'pffp3' => $faker->numberBetween($min = 1, $max = 2), 'pffp4' => $faker->numberBetween($min = 1, $max = 2), 'pffp5' => $faker->numberBetween($min = 1, $max = 3), 'pffp6' => $faker->numberBetween($min = 1, $max = 3), 'pffp7' => $faker->numberBetween($min = 1, $max = 3), 'pffp8' => $faker->numberBetween($min = 1, $max = 3), 'pffp9' => $faker->numberBetween($min = 1, $max = 3), 'pffp10' => $faker->numberBetween($min = 1, $max = 4), 'pffp11' => $faker->numberBetween($min = 1, $max = 4), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '2nd', 'year' => '2014']);
}
for ($id = 5; $id < 19; $id++) {
$user = User::find($id);
Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 1, $max = 6), 'util2' => $faker->numberBetween($min = 1, $max = 6), 'util3' => $faker->numberBetween($min = 1, $max = 6), 'qow1' => $faker->numberBetween($min = 1, $max = 6), 'qow2' => $faker->numberBetween($min = 1, $max = 6), 'qow3' => $faker->numberBetween($min = 1, $max = 4), 'qow4' => $faker->numberBetween($min = 1, $max = 4), 'qow5' => $faker->numberBetween($min = 1, $max = 4), 'qow6' => $faker->numberBetween($min = 1, $max = 4), 'qow7' => $faker->numberBetween($min = 1, $max = 4), 'qow8' => $faker->numberBetween($min = 1, $max = 2), 'pffp1' => $faker->numberBetween($min = 1, $max = 2), 'pffp2' => $faker->numberBetween($min = 1, $max = 2), 'pffp3' => $faker->numberBetween($min = 1, $max = 2), 'pffp4' => $faker->numberBetween($min = 1, $max = 2), 'pffp5' => $faker->numberBetween($min = 1, $max = 3), 'pffp6' => $faker->numberBetween($min = 1, $max = 3), 'pffp7' => $faker->numberBetween($min = 1, $max = 3), 'pffp8' => $faker->numberBetween($min = 1, $max = 3), 'pffp9' => $faker->numberBetween($min = 1, $max = 3), 'pffp10' => $faker->numberBetween($min = 1, $max = 4), 'pffp11' => $faker->numberBetween($min = 1, $max = 4), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '1st', 'year' => '2016']);
}
for ($id = 5; $id < 19; $id++) {
$user = User::find($id);
Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 1, $max = 6), 'util2' => $faker->numberBetween($min = 1, $max = 6), 'util3' => $faker->numberBetween($min = 1, $max = 6), 'qow1' => $faker->numberBetween($min = 1, $max = 6), 'qow2' => $faker->numberBetween($min = 1, $max = 6), 'qow3' => $faker->numberBetween($min = 1, $max = 4), 'qow4' => $faker->numberBetween($min = 1, $max = 4), 'qow5' => $faker->numberBetween($min = 1, $max = 4), 'qow6' => $faker->numberBetween($min = 1, $max = 4), 'qow7' => $faker->numberBetween($min = 1, $max = 4), 'qow8' => $faker->numberBetween($min = 1, $max = 2), 'pffp1' => $faker->numberBetween($min = 1, $max = 2), 'pffp2' => $faker->numberBetween($min = 1, $max = 2), 'pffp3' => $faker->numberBetween($min = 1, $max = 2), 'pffp4' => $faker->numberBetween($min = 1, $max = 2), 'pffp5' => $faker->numberBetween($min = 1, $max = 3), 'pffp6' => $faker->numberBetween($min = 1, $max = 3), 'pffp7' => $faker->numberBetween($min = 1, $max = 3), 'pffp8' => $faker->numberBetween($min = 1, $max = 3), 'pffp9' => $faker->numberBetween($min = 1, $max = 3), 'pffp10' => $faker->numberBetween($min = 1, $max = 4), 'pffp11' => $faker->numberBetween($min = 1, $max = 4), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '2nd', 'year' => '2016']);
}
for ($id = 2; $id < 5; $id++) {
$user = User::find($id);
Performance::create(['user_id' => $id, 'dept_id' => $user->department_id, 'util1' => $faker->numberBetween($min = 6, $max = 6), 'util2' => $faker->numberBetween($min = 6, $max = 6), 'util3' => $faker->numberBetween($min = 5, $max = 6), 'qow1' => $faker->numberBetween($min = 5, $max = 6), 'qow2' => $faker->numberBetween($min = 6, $max = 6), 'qow3' => $faker->numberBetween($min = 6, $max = 6), 'qow4' => $faker->numberBetween($min = 6, $max = 6), 'qow5' => $faker->numberBetween($min = 5, $max = 6), 'qow6' => $faker->numberBetween($min = 5, $max = 6), 'qow7' => $faker->numberBetween($min = 6, $max = 6), 'qow8' => $faker->numberBetween($min = 5, $max = 6), 'pffp1' => $faker->numberBetween($min = 5, $max = 6), 'pffp2' => $faker->numberBetween($min = 5, $max = 6), 'pffp3' => $faker->numberBetween($min = 5, $max = 6), 'pffp4' => $faker->numberBetween($min = 5, $max = 6), 'pffp5' => $faker->numberBetween($min = 5, $max = 6), 'pffp6' => $faker->numberBetween($min = 5, $max = 6), 'pffp7' => $faker->numberBetween($min = 5, $max = 6), 'pffp8' => $faker->numberBetween($min = 6, $max = 6), 'pffp9' => $faker->numberBetween($min = 6, $max = 6), 'pffp10' => $faker->numberBetween($min = 6, $max = 6), 'pffp11' => $faker->numberBetween($min = 6, $max = 6), 'comments' => $faker->text(100), 'status' => 'Finalized', 'semester' => '1st', 'year' => '2016']);
}
$updates = Performance::all();
foreach ($updates as $update) {
$saveUpdate = Performance::find($update->id);
$u = $update->utilities;
$qow = $update->workQuality;
$pffp = $update->potential;
$overall = number_format(($u + $qow + $pffp) / 3, 2);
$saveUpdate->update(['util_overall' => $u, 'qow_overall' => $qow, 'pffp_overall' => $pffp, 'overall' => $overall]);
}
}
public function generateBills()
{
$orgs = Organization::all(["live = ?" => true]);
foreach ($orgs as $org) {
$imp_cost = 0;
$click_cost = 0;
$month_ini = new DateTime("first day of last month");
$month_end = new DateTime("last day of last month");
$start = $month_ini->format('Y-m-d');
$end = $month_end->format('Y-m-d');
$dateQuery = Utils::dateQuery(['start' => $start, 'end' => $end]);
// find advertiser performances to get clicks and impressions
$performances = \Performance::overall($dateQuery, User::all(['org_id' => $org->_id, 'type' => 'advertiser'], ['_id']));
$clicks = $performances['total_clicks'];
if ($clicks > 1000) {
$click_cost = 0.001 * $clicks * $org->meta["bill"]["tcc"];
}
$impressions = $performances['total_impressions'];
if ($impressions > 100000) {
$imp_cost = 0.001 * 0.001 * $impressions * $org->meta["bill"]["mic"];
}
$total = $click_cost + $imp_cost;
$bill = new Bill(["org_id" => $org->id, "impressions" => $impressions, "clicks" => $clicks, "mic" => $org->meta["bill"]["mic"], "tcc" => $org->meta["bill"]["tcc"], "start" => $start, "end" => $end, "amount" => $total, "live" => false, "created" => Db::time('-1 day')]);
if ($total > 1) {
$bill->save();
$user = User::first(["org_id = ?" => $org->id, "type = ?" => "admin"]);
Mail::send(['user' => $user, 'bill' => $bill, 'template' => 'adminBilling', 'subject' => 'Billing at vNative', 'click_cost' => $click_cost, 'imp_cost' => $imp_cost, 'org' => $org]);
}
}
}
public function add_evaluation()
{
$data = array('assessee_id' => $this->input->post('txtEmpID'), 'assessor_id' => $this->session->userdata('employee_id'), 'evaluation_desc' => $this->input->post('txtEvalTitle'));
$eval = count(Evaluation_model::all()) + 1;
// $rate1 = array (
// 'evaluation_id' => $eval,
// 'criteria_id' => 1,
// 'rate' => $this->input->post('txtRate1'),
// );
// $rate2 = array (
// 'evaluation_id' => $eval,
// 'criteria_id' => 2,
// 'rate' => $this->input->post('txtRate2'),
// );
// $rate3 = array (
// 'evaluation_id' => $eval,
// 'criteria_id' => 3,
// 'rate' => $this->input->post('txtRate3'),
// );
// $rate4 = array (
// 'evaluation_id' => $eval,
// 'criteria_id' => 4,
// 'rate' => $this->input->post('txtRate4'),
// );
// $rate5 = array (
// 'evaluation_id' => $eval,
// 'criteria_id' => 5,
// 'rate' => $this->input->post('txtRate5'),
// );
// $rate6 = array (
// 'evaluation_id' => $eval,
// 'criteria_id' => 6,
// 'rate' => $this->input->post('txtRate6'),
// );
// $rate7 = array (
// 'evaluation_id' => $eval,
// 'criteria_id' => 7,
// 'rate' => $this->input->post('txtRate7'),
// );
// $rate8 = array (
// 'evaluation_id' => $eval,
// 'criteria_id' => 8,
// 'rate' => $this->input->post('txtRate8'),
// );
// $rate9 = array (
// 'evaluation_id' => $eval,
// 'criteria_id' => 9,
// 'rate' => $this->input->post('txtRate9'),
// );
// $rate10 = array (
// 'evaluation_id' => $eval,
// 'criteria_id' => 10,
// 'rate' => $this->input->post('txtRate10'),
// );
$rate = array('evaluation_id' => $eval, 'rate1' => $this->input->post('txtRate1'), 'rate2' => $this->input->post('txtRate2'), 'rate3' => $this->input->post('txtRate3'), 'rate4' => $this->input->post('txtRate4'), 'rate5' => $this->input->post('txtRate5'), 'rate6' => $this->input->post('txtRate6'), 'rate7' => $this->input->post('txtRate7'), 'rate8' => $this->input->post('txtRate8'), 'rate9' => $this->input->post('txtRate9'), 'rate10' => $this->input->post('txtRate10'));
if (Performance::create($data)) {
// Evaluation_rate::create($rate1);
// Evaluation_rate::create($rate2);
// Evaluation_rate::create($rate3);
// Evaluation_rate::create($rate4);
// Evaluation_rate::create($rate5);
// Evaluation_rate::create($rate6);
// Evaluation_rate::create($rate7);
// Evaluation_rate::create($rate8);
// Evaluation_rate::create($rate9);
// Evaluation_rate::create($rate10);
Evaluation_rate::create($rate);
$this->session->set_userdata('added', 1);
Audit_trail_model::auditPerformance($data);
if ($this->session->userdata('user_level') == 'Administrator') {
redirect('ems/view_performance');
} else {
$this->session->set_userdata('added', 1);
redirect('ems/emp_dashboard');
}
}
}
/**
* @before _secure
*/
public function raiseinvoice()
{
$this->seo(array("title" => "Create Invoice"));
$view = $this->getActionView();
$perfs = [];
$start = RM::get("start");
$end = RM::get("end");
$user_id = RM::get("user_id", null);
$view->set('user_id', $user_id)->set('start', $start)->set('end', $end);
$dateQuery = Utils::dateQuery($start, $end);
$query['created'] = ['$gte' => $dateQuery['start'], '$lte' => $dateQuery['end']];
$query['user_id'] = $user_id;
if ($user_id) {
$user = \User::first(['type = ?' => 'advertiser', 'org_id = ?' => $this->org->_id, 'id = ?' => $user_id]);
$view->set('advertiser', $user);
$performances = Performance::all($query, ['clicks', 'impressions', 'conversions', 'created', 'revenue'], 'created', 'desc');
foreach ($performances as $p) {
$perfs[] = $p;
}
$view->set('performances', $perfs);
$inv_exist = Invoice::exists($user_id, $start, $end);
if ($inv_exist) {
$view->set("message", "Invoice already exist for Date range from " . Framework\StringMethods::only_date($inv_exist->start) . " to " . Framework\StringMethods::only_date($inv_exist->end));
return;
}
} else {
$advertisers = \User::all(['type = ?' => 'advertiser', 'org_id' => $this->org->_id], ['id', 'name']);
$view->set('advertisers', $advertisers);
}
if (RM::post("action") == "cinvoice" && RM::post("amount") > 0) {
$invoice = new Invoice(["org_id" => $this->org->id, "user_id" => $user->id, "utype" => $user->type, "start" => end($perfs)->created, "end" => $perfs[0]->created, "amount" => RM::post("amount"), "live" => false]);
$invoice->save();
Registry::get("session")->set('$flashMessage', 'Payment Saved!!');
$this->redirect("/billing/advertisers.html");
}
}
/**
* Converts the given exhibition PDO to a bean object.
* This includes the conversion from nested lists
* of PDO objects to usable lists of oids/names to be used
* by the page renderer.
*
* @access private
* @param pdo $pdo Program
* @return bean Program
*/
private function exhibitionPdoToBean($pdo)
{
global $logger;
$logger->debug(get_class($this) . "::exhibitionPdoToBean({$pdo})");
$bean = new Exhibition($pdo->epGetVars());
// pubState to a string
$ps = '';
if ($pdo->getPubState() != null) {
$ps = $pdo->getPubState()->getValue();
}
$bean->setPubState($ps);
// eventStatus to a string
$es = '';
if ($pdo->getEventStatus() != null) {
$es = $pdo->getEventStatus()->getValue();
}
$bean->setEventStatus($es);
// schedule
$schedule = $pdo->getSchedule();
if ($schedule) {
$bean->setSchedule(new Schedule($schedule->epGetVars()));
} else {
$bean->setSchedule(new Schedule());
}
// venues from array of pdos to array of venue bean
$vens = array();
if ($pdo->getVenues() != null) {
foreach ($pdo->getVenues() as $ven) {
$vens[] = new Venue($ven->epGetVars());
}
}
$bean->setVenues($vens);
// categories from array of pdos to keyed array of oids
$cats = array();
if ($pdo->getCategories() != null) {
foreach ($pdo->getCategories() as $cat) {
$scope = $cat->getScope();
$cats[$scope][] = new $scope($cat->epGetVars());
}
}
$bean->setCategories($cats);
// related programs from array of pdos to keyed array of oids
$programs = $pdo->getPrograms();
if ($programs != null) {
$related = array();
foreach ($programs as $event) {
$rp = new Program($event->epGetVars());
$ps = $event->getPubState()->getValue();
$rp->setPubState($ps);
// primary genre
if ($event->getPrimaryGenre()) {
$pg = $event->getPrimaryGenre();
$prpg = new Category(array("oid" => $pg->getOid(), "name" => $pg->getName()));
$rp->setPrimaryGenre($prpg);
}
$acts = array();
foreach ($event->getChildren() as $perf) {
$sch = new Performance($perf->epGetVars());
$sch->setSchedule(new Schedule($perf->schedule->epGetVars()));
$acts[] = $sch;
}
usort($acts, array(&$this, "orderPerformances"));
$rp->setChildren($acts);
// Using "Nextevent" so we can use orderProgramsByNextevent; really is firstEvent
$rp->setNextevent($acts[0]->schedule->getStartTime());
$related[] = $rp;
}
usort($related, array(&$this, "orderProgramsByNextevent"));
$bean->setPrograms($related);
}
// related courses from array of pdos to keyed array of oids
$courses = $pdo->getCourses();
if ($courses != null) {
$related = array();
foreach ($courses as $event) {
$related[] = new Course($event->epGetVars());
}
$bean->setCourses($related);
}
// related artists
$artists = $pdo->getArtists();
if ($artists != null) {
$related = array();
foreach ($artists as $person) {
$related[] = new Artist($person->epGetVars());
}
$bean->setArtists($related);
}
return $bean;
}
public function actionAddcandidate()
{
if (!isset(Yii::app()->user->userProfileID)) {
$this->redirect('/user/login');
}
// renders the view file 'protected/views/site/index.php'
// using the default layout 'protected/views/layouts/main.php'
$candidateModel = new Candidate();
$performanceModel = new Performance();
$ratingModel = new Rating();
$planningModel = new Planning();
if (isset($_POST['Candidate'])) {
$candidateModel->attributes = $_POST['Candidate'];
$candidateModel->IsActive = 1;
//$candidateModel->UserProfileID = Yii::app()->user->userProfileID;
$candidateModel->CompanyID = Yii::app()->user->companyID;
if ($candidateModel->validate()) {
if ($candidateModel->save()) {
$currentYear = date('Y');
// insert new record
$performanceModel->CandidateID = $candidateModel->CandidateID;
$performanceModel->PerformanceYear = $currentYear;
$ratingModel->CandidateID = $candidateModel->CandidateID;
$ratingModel->RatingYear = $currentYear;
$planningModel->CandidateID = $candidateModel->CandidateID;
$planningModel->PlanningYear = $currentYear;
$planningModel->CurrentPositionLevel = $_POST['Candidate']['CompanyPositionID'];
if ($_POST['Candidate']['CompanyPositionID'] == 5) {
$planningModel->NextStepPositionLevel = 5;
$planningModel->LongTermPositionLevel = 5;
} else {
$planningModel->NextStepPositionLevel = $_POST['Candidate']['CompanyPositionID'];
$planningModel->LongTermPositionLevel = $_POST['Candidate']['CompanyPositionID'];
}
$performanceModel->save();
$ratingModel->save();
$planningModel->save();
$this->redirect(Yii::app()->createUrl('company/candidates'));
}
}
}
$criteria3 = new CDbCriteria();
$criteria3->condition = 'companyID = :companyID';
$criteria3->params = array(':companyID' => Yii::app()->user->companyID);
$criteria3->order = 'Email';
$userManagers = UserProfile::model()->findAllByAttributes(array(), $criteria3);
$managersArray = array();
foreach ($userManagers as $UserManager) {
$managersArray[$UserManager->UserProfileID] = $UserManager->Email;
}
$managerArray = $managersArray;
$companyPositions = Helper::getCompanyPositions(Yii::app()->user->companyID);
$this->render('candidate-form', array('candidateModel' => $candidateModel, 'planningModel' => $planningModel, 'companyPositionSelect' => $companyPositions, 'managerArray' => $managerArray));
}
/**
* Populates the Venue object from the request
* @return bean Venue
*/
protected function getBeanFromRequest()
{
global $logger;
$prgm = new Program($_REQUEST);
$genre = new Genre();
$genre->setOid($_REQUEST['primaryGenre']);
$prgm->setPrimaryGenre($genre);
if (isset($_REQUEST['defaultVenue'])) {
$venue = new Venue();
$venue->setOid($_REQUEST['defaultVenue']);
$prgm->setDefaultVenue($venue);
$prgm->setVenues(array($venue));
}
// categories
$cats = array();
if (isset($_REQUEST['audience'])) {
foreach ($_REQUEST['audience'] as $oid) {
$category = new Audience();
$category->setOid($oid);
$cats['audience'][] = $category;
}
}
if (isset($_REQUEST['genre'])) {
foreach ($_REQUEST['genre'] as $oid) {
$category = new Genre();
$category->setOid($oid);
$cats['genre'][] = $category;
}
}
if (isset($_REQUEST['series'])) {
foreach ($_REQUEST['series'] as $oid) {
$category = new Series();
$category->setOid($oid);
$cats['series'][] = $category;
}
}
if (isset($cats['audience'])) {
$logger->debug("Number of audience categories in the form: " . count($cats['audience']));
}
if (isset($cats['genre'])) {
$logger->debug("Number of genre categories in the form: " . count($cats['genre']));
}
if (isset($cats['series'])) {
$logger->debug("Number of series categories in the form: " . count($cats['series']));
}
if (isset($cats['audience']) || isset($cats['genre']) || isset($cats['series'])) {
$prgm->setCategories($cats);
}
// related events
$events = array();
if (isset($_REQUEST['exhibition'])) {
foreach ($_REQUEST['exhibition'] as $oid) {
$exhibition = new Exhibition();
$exhibition->setOid($oid);
$events[] = $exhibition;
}
}
if (isset($events)) {
$logger->debug("Number of related exhibitions in the form: " . count($events));
$prgm->setExhibitions($events);
}
$events = array();
if (isset($_REQUEST['course'])) {
foreach ($_REQUEST['course'] as $oid) {
$course = new Course();
$course->setOid($oid);
$events[] = $course;
}
}
if (isset($events)) {
$logger->debug("Number of related courses in the form: " . count($events));
$prgm->setCourses($events);
}
$activities = array();
if (isset($_REQUEST['activityChanged']) && $_REQUEST['activityChanged']) {
// parse delimited attributes as pipe-delimited '|' string
$startTimes = explode('|', $_REQUEST['activityStartTime']);
$endTimes = explode('|', $_REQUEST['activityEndTime']);
$venues = explode('|', $_REQUEST['activityVenueList']);
$status = explode('|', $_REQUEST['activityStatusList']);
$tickets = explode('|', $_REQUEST['activityTicketList']);
for ($index = 0; $index < count($venues); $index++) {
$schedule = new Schedule();
$stint = strtotime($startTimes[$index]);
$etint = strtotime($endTimes[$index]);
$schedule->setStartTime($stint);
$schedule->setEndTime($etint);
$venue = new Venue();
$venue->setOid($venues[$index]);
$activity = new Performance();
$activity->setSchedule($schedule);
$activity->setVenue($venue);
$activity->setActivityStatus($status[$index]);
$activity->setTicketCode($tickets[$index]);
$activities[] = $activity;
}
}
if (isset($activities)) {
$logger->debug("Number of related performances in the form: " . count($activities));
$prgm->setChildren($activities);
}
return $prgm;
}
public function getViewResultsPdf($id)
{
$result = Performance::find($id);
$perf = Performance::find($id);
$user = Performance::find($id);
$rating = Performance::find($id);
$u = $perf->utilities;
$qow = $perf->workQuality;
$pffp = $perf->potential;
$overall = number_format(($u + $qow + $pffp) / 3, 2);
$rating = ParRatingsRef::where('upper_limit', '>=', $overall)->where('lower_limit', '<=', $overall)->first();
$overpercent = number_format($overall / 6 * 100, 2);
$department = Department::where('id', $perf->dept_id)->first();
Fpdf::AddPage();
Fpdf::PageNo();
Fpdf::AliasNbPages('{nb}');
Fpdf::Image('img/dap.jpg', 40, 0, 150);
Fpdf::Ln(30);
Fpdf::SetFont('Arial', 'B', 11);
Fpdf::SetTextColor(0, 0, 0);
Fpdf::Cell(300, 20, 'Date Generated: ' . date("F j, Y"), 0, 2, 'C', 0);
Fpdf::SetFont('Arial', 'B', 15);
Fpdf::Cell(0, 0, 'Performance Evaluation', 0, 1, 'L', 0);
Fpdf::Ln(8);
Fpdf::SetFont('Arial', 'B', 11);
Fpdf::Cell(0, 0, 'Name: ' . $perf->user->formatName(':ln, :fn :mn'), 0, 1, 'L', 0);
Fpdf::Ln(8);
Fpdf::Cell(0, 0, 'Department: ' . $department->name, 0, 1, 'L', 0);
Fpdf::Ln(8);
Fpdf::Cell(0, 0, 'Semester: ' . $perf->semester, 0, 1, 'L', 0);
Fpdf::Ln(10);
Fpdf::SetFont('Arial', '', 20);
Fpdf::SetDrawColor(224, 224, 224);
Fpdf::SetFillColor(51, 51, 225);
Fpdf::SetTextColor(255, 255, 255);
Fpdf::Cell(110, 10, 'Utilities', 1, 1, 'C', true);
Fpdf::SetFont('Arial', 'B', 7);
Fpdf::SetFillColor(204, 229, 225);
Fpdf::SetTextColor(96, 96, 96);
Fpdf::Cell(50, 10, 'Intra-group Involvements', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->util1, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('util1')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('util1')->description, 1, 1, 'C', 0);
Fpdf::Cell(50, 10, 'Inter-group Involvements', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->util2, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('util2')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('util2')->description, 1, 1, 'C', 0);
Fpdf::Cell(50, 10, 'Committee Work', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->util3, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('util3')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('util3')->description, 1, 1, 'C', 0);
Fpdf::SetTextColor(204, 0, 0);
Fpdf::Cell(50, 10, 'Average Rating', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->util_overall, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('utilities')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('utilities')->description, 1, 1, 'C', 0);
//Quality of work table
Fpdf::Ln(10);
Fpdf::SetFont('Arial', '', 20);
Fpdf::SetDrawColor(224, 224, 224);
Fpdf::SetFillColor(51, 51, 225);
Fpdf::SetTextColor(255, 255, 255);
Fpdf::Cell(110, 10, 'Quality of Work', 1, 2, 'C', true);
Fpdf::SetFont('Arial', 'B', 7);
Fpdf::SetFillColor(204, 229, 225);
Fpdf::SetTextColor(96, 96, 96);
Fpdf::Cell(50, 10, 'Relevance to Project/unit objectives', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->qow1, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('qow1')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('qow1')->description, 1, 1, 'C', 0);
Fpdf::Cell(50, 10, 'Timeliness', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->qow2, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('qow2')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('qow2')->description, 1, 1, 'C', 0);
Fpdf::Cell(50, 10, 'Thoroughness', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->qow3, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('qow3')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('qow3')->description, 1, 1, 'C', 0);
Fpdf::Cell(50, 10, 'High-Rate', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->qow4, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('qow4')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('qow4')->description, 1, 1, 'C', 0);
Fpdf::Cell(50, 10, 'Accuracy', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->qow5, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('qow5')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('qow5')->description, 1, 1, 'C', 0);
Fpdf::Cell(50, 10, 'Foresight', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->qow6, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('qow6')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('qow6')->description, 1, 1, 'C', 0);
Fpdf::Cell(50, 10, 'Neatness and Presentability', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->qow7, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('qow7')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('qow7')->description, 1, 1, 'C', 0);
Fpdf::Cell(50, 10, 'Cost-effectiveness', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->qow8, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('qow8')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('qow8')->description, 1, 1, 'C', 0);
Fpdf::SetTextColor(204, 0, 0);
Fpdf::Cell(50, 10, 'Average Rating', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->qow_overall, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('qow_overall')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('qow_overall')->description, 1, 1, 'C', 0);
//Potential for Future Performance table
Fpdf::Ln(10);
Fpdf::SetFont('Arial', '', 20);
Fpdf::SetDrawColor(224, 224, 224);
Fpdf::SetFillColor(51, 51, 225);
Fpdf::SetTextColor(255, 255, 255);
Fpdf::Cell(110, 10, 'Potential for Future Performance', 1, 2, 'C', true);
Fpdf::SetFont('Arial', 'B', 7);
Fpdf::SetFillColor(204, 229, 225);
Fpdf::SetTextColor(96, 96, 96);
Fpdf::Cell(50, 10, 'Appropriate Expertise', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->pffp1, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp1')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp1')->description, 1, 1, 'C', 0);
Fpdf::Cell(50, 10, 'Professional Interest', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->pffp2, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp2')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp2')->description, 1, 1, 'C', 0);
Fpdf::Cell(50, 10, 'Ability to Learn', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->pffp3, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp3')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp3')->description, 1, 1, 'C', 0);
Fpdf::Cell(50, 10, 'Professional Integrity ', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->pffp4, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp4')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp4')->description, 1, 1, 'C', 0);
Fpdf::Cell(50, 10, 'Work standards ', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->pffp5, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp5')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp5')->description, 1, 1, 'C', 0);
Fpdf::Cell(50, 10, 'Innovativeness ', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->pffp6, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp6')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp6')->description, 1, 1, 'C', 0);
Fpdf::Cell(50, 10, 'Maturity ', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->pffp7, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp7')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp7')->description, 1, 1, 'C', 0);
Fpdf::Cell(50, 10, 'Collaboration ', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->pffp8, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp8')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp8')->description, 1, 1, 'C', 0);
Fpdf::Cell(50, 10, 'Initiative', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->pffp9, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp9')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp9')->description, 1, 1, 'C', 0);
Fpdf::Cell(50, 10, 'Responsiveness', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->pffp10, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp10')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp10')->description, 1, 1, 'C', 0);
Fpdf::Cell(50, 10, 'Adaptability and Consistent track record ', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->pffp11, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp11')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp11')->description, 1, 1, 'C', 0);
Fpdf::SetTextColor(204, 0, 0);
Fpdf::Cell(50, 10, 'Average Rating', 1, 0, 'C', true);
Fpdf::Cell(20, 10, $result->pffp_overall, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp_overall')->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(20, 10, $perf->equivalent('pffp_overall')->description, 1, 1, 'C', 0);
//Overall Rating table
Fpdf::Ln(10);
Fpdf::SetFont('Arial', '', 20);
Fpdf::SetDrawColor(224, 224, 224);
Fpdf::SetFillColor(51, 51, 225);
Fpdf::SetTextColor(255, 255, 255);
Fpdf::Cell(140, 10, 'Overall Rating', 1, 2, 'C', true);
Fpdf::SetFont('Arial', 'B', 7);
Fpdf::SetFillColor(204, 229, 225);
Fpdf::SetTextColor(96, 96, 96);
Fpdf::Cell(30, 10, 'Superior Remarks', 1, 0, 'C', true);
Fpdf::Cell(110, 10, $perf->comments, 1, 1, 'C', 0);
Fpdf::Cell(30, 10, 'Overall rating', 1, 0, 'C', true);
Fpdf::Cell(30, 10, $result->overall, 1, 0, 'C', 0);
Fpdf::Cell(30, 10, $rating->adjectival, 1, 0, 'C', 0);
Fpdf::Cell(50, 10, $rating->description, 1, 0, 'C', 0);
Fpdf::SetY(-35);
Fpdf::AliasNbPages('{nb}');
Fpdf::SetFont('Arial', 'I', 10);
Fpdf::SetTextColor(0, 0, 0);
Fpdf::Cell(0, 10, 'Page ' . Fpdf::PageNo() . '/{nb}', 0, 0, 'C');
Fpdf::Output();
exit;
}
