function test_getName()
{
//Arrange
$name = "Biology";
$address = "346 Stupid Avenue";
$test_department = new Department($name, $address);
//Act
$result = $test_department->getName();
//Assert
$this->assertEquals($name, $result);
}
$stmt = $pdo->prepare($query);
$stmt->execute(array(':assigned_id' => $_REQUEST['assigned_id'], ':id' => $_REQUEST['id']));
// Update entries in dept_reviewer
$query = "UPDATE {$GLOBALS['CONFIG']['db_prefix']}dept_reviewer SET dept_id = :assigned_id WHERE dept_id = :id";
$stmt = $pdo->prepare($query);
$stmt->execute(array(':assigned_id' => $_REQUEST['assigned_id'], ':id' => $_REQUEST['id']));
// Delete from department
$query = "DELETE FROM {$GLOBALS['CONFIG']['db_prefix']}department where id = :id";
$stmt = $pdo->prepare($query);
$stmt->execute(array(':id' => $_REQUEST['id']));
// back to main page
$last_message = urlencode(msg('message_all_actions_successfull') . ' id:' . (int) $_REQUEST['id']);
header('Location: admin.php?last_message=' . $last_message);
} elseif (isset($_REQUEST['submit']) && $_REQUEST['submit'] == 'modify') {
$dept_obj = new Department($_REQUEST['item'], $pdo);
draw_header(msg('area_update_department') . ': ' . $dept_obj->getName(), $last_message);
?>
<form action="department.php" id="modifyDeptForm" method="POST" enctype="multipart/form-data">
<table border="0" cellspacing="5" cellpadding="5">
<tr>
<?php
$query = "SELECT id, name FROM {$GLOBALS['CONFIG']['db_prefix']}department where id = :item";
$stmt = $pdo->prepare($query);
$stmt->execute(array(':item' => $_REQUEST['item']));
$result = $stmt->fetchAll();
foreach ($result as $row) {
?>
<td>
<b><?php
/**
* Delete a department from database with the passed ID.
*/
public static function delDepartment($departmentId)
{
$dept = new Department($departmentId);
if ($dept->id == 0) {
// Department wasn't loaded correctly
NQ::simple('intern', INTERN_ERROR, "Error occurred while loading department from database.");
return;
}
$name = $dept->getName();
try {
// Try to delete department.
if (!$dept->delete()) {
// Something bad happend. This should have been caught in the check above...
NQ::simple('intern', INTERN_SUCCESS, "Error occurred deleting department from database.");
return;
}
} catch (Exception $e) {
NQ::simple('intern', INTERN_ERROR, $e->getMessage());
return;
}
// Department deleted successfully.
NQ::simple('intern', INTERN_SUCCESS, "Deleted department <i>{$name}</i>");
}
public static function sendInternshipCancelNotice(Internship $i)
{
$settings = InternSettings::getInstance();
$tpl = array();
$tpl['NAME'] = $i->getFullName();
$tpl['BANNER'] = $i->banner;
$tpl['TERM'] = Term::rawToRead($i->term);
$dept = new Department($i->department_id);
$tpl['DEPARTMENT'] = $dept->getName();
$to = $i->email . '@appstate.edu';
$faculty = $i->getFaculty();
if ($faculty instanceof Faculty) {
$cc = array($faculty->getUsername() . '@' . $settings->getEmailDomain(), $settings->getRegistrarEmail());
} else {
$cc = array();
}
$subject = 'Internship Cancelled ' . Term::rawToRead($i->getTerm()) . '[' . $i->getBannerId() . '] ' . $i->getFullName();
Email::sendTemplateMessage($to, $subject, 'email/StudentCancellationNotice.tpl', $tpl, $cc);
}
}
$c->save();
echo "Category: {$c->getName()}\n";
}
// Now that we've got People and Categories in the database,
// Link the Departments with their Categories and Default Person
$result = $mongo->departments->find();
foreach ($result as $r) {
$d = new Department($r['name']);
if (!empty($r['defaultPerson']['_id'])) {
$id = getPersonIdFromCrosswalk($r['defaultPerson']['_id']);
$d->setDefaultPerson_id($id);
}
if (!empty($r['categories'])) {
$ids = array();
foreach ($r['categories'] as $c) {
try {
$category = new Category($c['name']);
$ids[] = $category->getId();
} catch (Exception $e) {
// Departments may have old categories we have deleted
// Just ignore them
}
}
$d->setCategories($ids);
}
$d->save();
$p = $d->getDefaultPerson();
$p = $p ? $p->getFullname() : '';
echo "Department: {$d->getName()} Person: {$p}\n";
}
function processvariablesAction()
{
$session = SessionWrapper::getInstance();
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(TRUE);
$formvalues = $this->_getAllParams();
// debugMessage($formvalues); // exit;
if (isArrayKeyAnEmptyString('noreload', $formvalues)) {
$hasnoreload = false;
} else {
$hasnoreload = true;
}
$haserror = false;
if (isArrayKeyAnEmptyString('value', $formvalues) && !$hasnoreload) {
$haserror = true;
$session->setVar(ERROR_MESSAGE, 'Error: No value specified for addition');
$session->setVar(FORM_VALUES, $formvalues);
$this->_helper->redirector->gotoUrl($this->view->baseUrl('config/variables/' . $formvalues['lookupid']));
}
$successurl = $this->view->baseUrl('config/variables/type/' . $formvalues['lookupid']);
$type_ext = '';
$alias = '';
if (!isArrayKeyAnEmptyString('alias', $formvalues)) {
$alias = trim($formvalues['alias']);
if ($alias == 'undefined') {
$alias = '';
}
}
if ($formvalues['lookupid'] == 7) {
$alias = decode($formvalues['alias']);
if (isArrayKeyAnEmptyString('id', $formvalues)) {
$alias = $formvalues['alias'];
}
}
// exit;
// debugMessage()
switch ($formvalues['lookupid']) {
case 9:
$formvalues['defaultamount'] = $formvalues['alias'];
if (!isArrayKeyAnEmptyString('id', $formvalues)) {
$formvalues['defaultamount'] = decode($formvalues['alias']);
}
$formvalues['amounttype'] = $formvalues['alias2'];
$formvalues['name'] = decode(trim($formvalues['value']));
if (!isArrayKeyAnEmptyString('id', $formvalues)) {
$formvalues['name'] = $formvalues['name'];
}
$formvalues['companyid'] = getCompanyID();
$benefittype = new BenefitType();
if (!isArrayKeyAnEmptyString('id', $formvalues)) {
$benefittype->populate($formvalues['id']);
$formvalues['lastupdatedby'] = $session->getVar('userid');
} else {
$formvalues['createdby'] = $session->getVar('userid');
}
$benefittype->processPost($formvalues);
/* debugMessage($benefittype->toArray());
debugMessage('errors are '.$benefittype->getErrorStackAsString()); exit(); */
$result = array('id' => '', 'name' => '', 'error' => '');
if ($benefittype->hasError()) {
$session->setVar(ERROR_MESSAGE, $benefittype->getErrorStackAsString());
$session->setVar(FORM_VALUES, $formvalues);
$result['error'] = $benefittype->getErrorStackAsString();
} else {
try {
$benefittype->save();
// debugMessage($benefittype->toArray()); exit;
$result = array('id' => $benefittype->getID(), 'name' => $benefittype->getName(), 'alias' => $benefittype->getdefaultamount(), 'alias2' => $benefittype->getamounttype());
$session->setVar(SUCCESS_MESSAGE, "Successfully saved");
} catch (Exception $e) {
$session->setVar(ERROR_MESSAGE, $e->getMessage() . "<br />" . $benefittype->getErrorStackAsString());
$session->setVar(FORM_VALUES, $formvalues);
$result['error'] = $benefittype->getErrorStackAsString();
}
}
break;
case 11:
$formvalues['name'] = trim($formvalues['value']);
$department = new Department();
if (!isArrayKeyAnEmptyString('id', $formvalues)) {
$department->populate($formvalues['id']);
$formvalues['lastupdatedby'] = $session->getVar('userid');
} else {
$formvalues['createdby'] = $session->getVar('userid');
}
$formvalues['companyid'] = getCompanyID();
$department->processPost($formvalues);
/* debugMessage($department->toArray());
debugMessage('errors are '.$department->getErrorStackAsString()); // exit(); */
$result = array('id' => '', 'name' => '', 'error' => '');
if ($department->hasError()) {
$session->setVar(ERROR_MESSAGE, $department->getErrorStackAsString());
$session->setVar(FORM_VALUES, $formvalues);
$result['error'] = $department->getErrorStackAsString();
} else {
try {
$department->save();
$result = array('id' => $department->getID(), 'name' => $department->getName(), 'error' => '');
$session->setVar(SUCCESS_MESSAGE, "Successfully saved");
} catch (Exception $e) {
$session->setVar(ERROR_MESSAGE, $e->getMessage() . "<br />" . $department->getErrorStackAsString());
$session->setVar(FORM_VALUES, $formvalues);
$result['error'] = $department->getErrorStackAsString();
}
}
break;
default:
$lookupvalue = new LookupTypeValue();
$lookuptype = new LookupType();
$lookuptype->populate($formvalues['lookupid']);
$index = '';
if ($hasnoreload) {
$index = $lookuptype->getNextInsertIndex();
$value = trim($formvalues['value']);
} else {
if (!isArrayKeyAnEmptyString('index', $formvalues)) {
$index = $formvalues['index'];
} else {
$index = $lookuptype->getNextInsertIndex();
}
$value = addslashes(decode(trim($formvalues['value'])));
}
$dataarray = array('id' => $formvalues['id'], 'lookuptypeid' => $formvalues['lookupid'], 'lookuptypevalue' => $index, 'lookupvaluedescription' => $value, 'alias' => $alias, 'createdby' => $session->getVar('userid'), 'companyid' => getCompanyID());
// debugMessage($dataarray);
if (!isArrayKeyAnEmptyString('id', $formvalues)) {
$lookupvalue->populate($formvalues['id']);
$beforesave = $lookupvalue->toArray();
// debugMessage($beforesave);
}
// unset($dataarray['id']);
$lookupvalue->processPost($dataarray);
/* debugMessage($lookupvalue->toArray());
debugMessage('errors are '.$lookupvalue->getErrorStackAsString()); exit(); */
$result = array('id' => '', 'name' => '', 'error' => '');
if ($lookupvalue->hasError()) {
$haserror = true;
$session->setVar(ERROR_MESSAGE, $lookupvalue->getErrorStackAsString());
$session->setVar(FORM_VALUES, $formvalues);
$result['error'] = $lookupvalue->getErrorStackAsString();
} else {
try {
$lookupvalue->save();
if (!$hasnoreload) {
$url = $this->view->serverUrl($this->view->baseUrl("config/variables/lookupid/" . $formvalues['lookupid']));
$module = '0';
if (isArrayKeyAnEmptyString('id', $formvalues)) {
$session->setVar(SUCCESS_MESSAGE, "Successfully saved");
$type = SYSTEM_ADDVARIABLE;
$usecase = '0.1';
$details = 'Variable - <b>' . $lookupvalue->getlookupvaluedescription() . ' </b>(' . $lookupvalue->getLookupType()->getdisplayname() . ') addded';
} else {
$session->setVar(SUCCESS_MESSAGE, "Successfully updated");
$type = SYSTEM_UPDATEVARIABLE;
$usecase = '0.2';
$details = 'Variable - <b>' . $lookupvalue->getlookupvaluedescription() . ' </b>(' . $lookupvalue->getLookupType()->getdisplayname() . ') updated';
$prejson = json_encode($beforesave);
$lookupvalue->clearRelated();
$after = $lookupvalue->toArray();
// debugMessage($after);
$postjson = json_encode($after);
// debugMessage($postjson);
$diff = array_diff($beforesave, $after);
// debugMessage($diff);
$jsondiff = json_encode($diff);
// debugMessage($jsondiff);
}
$browser = new Browser();
$audit_values = $session->getVar('browseraudit');
$audit_values['module'] = $module;
$audit_values['usecase'] = $usecase;
$audit_values['transactiontype'] = $type;
$audit_values['status'] = "Y";
$audit_values['userid'] = $session->getVar('userid');
$audit_values['transactiondetails'] = $details;
$audit_values['url'] = $url;
if (!isArrayKeyAnEmptyString('id', $formvalues)) {
$audit_values['isupdate'] = 1;
$audit_values['prejson'] = $prejson;
$audit_values['postjson'] = $postjson;
$audit_values['jsondiff'] = $jsondiff;
}
// debugMessage($audit_values);
$this->notify(new sfEvent($this, $type, $audit_values));
}
$result = array('id' => $lookupvalue->getlookuptypevalue(), 'name' => $lookupvalue->getlookupvaluedescription(), 'alias' => $lookupvalue->getalias(), 'error' => '');
} catch (Exception $e) {
$session->setVar(ERROR_MESSAGE, $e->getMessage() . "<br />" . $lookupvalue->getErrorStackAsString());
$session->setVar(FORM_VALUES, $formvalues);
}
}
break;
}
// debugMessage($successurl);exit();
if (!$hasnoreload) {
$this->_helper->redirector->gotoUrl($successurl);
} else {
echo json_encode($result);
}
}
} elseif (array_key_exists($row['dept_name'], $lookup)) {
$person = new Person($lookup[$row['dept_name']]);
}
if (isset($person)) {
$department = new Department();
$department->setName($row['dept_name']);
$department->setDefaultPerson($person);
$query->closeCursor();
// Load the Department's commonly used categories
$sql = "select distinct c.comp_desc\n\t\t\t\tfrom ce_eng_comp a,c_types c\n\t\t\t\twhere a.c_type=c.c_type1 and a.dept=?\n\t\t\t\tand a.c_type is not null\n\t\t\t\tand a.c_type!=0\n\t\t\t\torder by c.comp_desc";
$query = $pdo->prepare($sql);
$query->execute(array($row['dept_no']));
$department->setCategories($query->fetchAll(PDO::FETCH_COLUMN));
try {
$department->save();
echo $department->getName() . "\n";
} catch (Exception $e) {
print_r($e);
print_r($department);
print_r($person);
exit;
}
}
}
// Assign all the users to their departments
$sql = "select u.userid,d.dept_name\n\t\tfrom complain_authorized u,departments d\n\t\twhere u.dept=d.dept_no and u.userid=?";
$query = $pdo->prepare($sql);
$people = new PersonList(array('username' => array('$exists' => true)));
foreach ($people as $person) {
$query->execute(array($person->getUsername()));
$row = $query->fetch(PDO::FETCH_ASSOC);