PHP Department::setName方法代码示例

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 <inghamn@bloomington.in.gov>
 */
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;