function loadDepartments($cid, $id)
{
// subdepartments
$departments = array();
if ($id == -1) {
$request = "SELECT * FROM department WHERE cid = {$cid} AND did IS NULL";
} else {
$request = "SELECT * FROM department WHERE cid = {$cid} and did = {$id}";
}
$result = mysql_query($request);
$count = mysql_num_rows($result);
while ($row = mysql_fetch_object($result)) {
$department = new Department();
$department->setId($row->id);
$department->setName($row->name);
$department->setDepartments(loadDepartments($cid, $row->id));
$employees = loadEmployees($cid, $row->id);
$department->setEmployees($employees);
$inconsistent = containsManager($employees);
if ($inconsistent == true) {
$department->setInconsistent(true);
$department->setMessage("No Manager!");
}
$departments[] = $department;
}
return $departments;
}
function installDepartments()
{
global $departmentsData, $departments;
foreach ($departmentsData as $departmenName) {
$department = new Department();
$department->setName($departmenName);
// $em->persist($department);
$departments[$departmenName] = $department;
}
}
function loadDepartment($jsonObject)
{
$id = $jsonObject->id;
// name
$request = "SELECT * FROM department WHERE id = {$id}";
$result = mysql_query($request);
$row = mysql_fetch_object($result);
$name = $row->name;
// departments
$departments = array();
$request = "SELECT * FROM department WHERE did = {$id}";
$result = mysql_query($request);
$count = mysql_num_rows($result);
while ($row = mysql_fetch_object($result)) {
$departments[] = $row->name;
}
// employees
$employees = array();
$request = "SELECT * FROM employee WHERE did = {$id}";
$result = mysql_query($request);
$count = mysql_num_rows($result);
while ($row = mysql_fetch_object($result)) {
if ($row->manager == true) {
$manager = $row->name;
} else {
$employees[] = $row->name;
}
}
// total
$total = totalDepartment($id);
// create department object
$department = new Department();
$department->setDepartments($departments);
$department->setEmployees($employees);
$department->setManager($manager);
$department->setName($name);
$department->setTotal($total);
// return department object
return $department;
}
<?php
/**
* @copyright 2012 City of Bloomington, Indiana
* @license http://www.gnu.org/licenses/agpl.txt GNU/AGPL, see LICENSE.txt
* @author Cliff Ingham <*****@*****.**>
*/
require_once './config.inc';
// Departments, People, and Categories foreign key each other
// We'll need to do an initial pass, then add the foreign keys
// Start with Departments adding only basic information
$result = $mongo->departments->find();
foreach ($result as $r) {
$d = new Department();
$d->setName($r['name']);
if (isset($r['customStatuses'])) {
$d->setCustomStatuses(implode(',', $r['customStatuses']));
}
if (isset($r['actions'])) {
$actions = array();
foreach ($r['actions'] as $a) {
$actions[] = $a['name'];
}
$d->setActions($actions);
}
$d->save();
echo "Department: {$d->getName()}\n";
}
// Load People records from Mongo
$result = $mongo->people->find();
foreach ($result as $row) {
function loadDepartment($id)
{
// name
$request = "SELECT * FROM department WHERE id = " . $id;
$result = mysql_query($request);
$row = mysql_fetch_object($result);
$name = $row->name;
$parent = $row->did;
// departments
$unselectable = unselectable($id);
$departments = array();
$request = "SELECT * FROM department WHERE id NOT IN (" . $unselectable . ")";
$result = mysql_query($request);
while ($row = mysql_fetch_object($result)) {
$department["id"] = $row->id;
$department["name"] = $row->name;
if ($row->id == $parent) {
$department["parent"] = true;
} else {
$department["parent"] = false;
}
$departments[] = $department;
}
// employees
$employees = array();
$request = "SELECT * FROM employee";
$result = mysql_query($request);
while ($row = mysql_fetch_object($result)) {
$employee = array();
$employee["id"] = $row->id;
$employee["name"] = $row->name;
if ($row->manager == true && $row->did == $id) {
$employee["manager"] = true;
} else {
$employee["manager"] = false;
}
$employees[] = $employee;
}
// total
$total = totalDepartment($id);
// create department object
$department = new Department();
$department->setId($id);
$department->setDepartments($departments);
$department->setEmployees($employees);
$department->setName($name);
$department->setTotal($total);
// return department object
return $department;
}
// Grab all the departments
$result = $pdo->query('select * from departments where dept_no!=0');
foreach ($result->fetchAll(PDO::FETCH_ASSOC) as $row) {
unset($user);
// Make sure we have at least one user for the department
$query = $pdo->prepare('select userid from complain_authorized where dept=? order by role desc');
$query->execute(array($row['dept_no']));
$r = $query->fetch(PDO::FETCH_ASSOC);
if ($r) {
$person = new Person($r['userid']);
} 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;
