PHP Contact::get_name方法代码示例

function export_csv()
{
    if (isset($_GET['report_name']) && $_GET['report_name'] != '') {
        $name = $_GET['report_name'];
    } else {
        return "<b>Sorry invalid report name " . $_GET['report_name'] . "</b>";
    }
    $query = "select accounting_reports.id, accounting_reports.profile_id, accounting_reports.report_name, \n\t\t\taccounting_reports.date1, accounting_reports.date2, \n\t\t\taccounting_reports.avg_in, accounting_reports.avg_out, \n\t\t\taccounting_reports.max_in, accounting_reports.max_out,95_in as in95,\n\t\t\taccounting_reports.95_out as out95 , accounting_reports.tot_in, accounting_reports.tot_out,\n\t\t\taccounting_reports.sample_date1,   accounting_reports.sample_date2, \n\t\t\taccounting_reports.traffic_cap, accounting_profiles.client_id\n\t\t\tfrom \n\t\t\taccounting_reports, accounting_profiles where report_name = '{$name}'\n\t\t\tAND accounting_profiles.profile_id =  accounting_reports.profile_id";
    $result = mysql_query($query);
    if (!$result) {
        return "failed to execute query {$query}<br>";
    }
    $heading = array("Client", "Accounting Profile", "Report Name", "Start date", "End date", "Average In (b/s)", "Average out (b/s)", "Max In (b/s)", "Max out (b/s)", "95% In (b/s)", "95% out (b/s)", "95% Billing (b/s)", "95% Billing (Mb/s)", "Committed Traffic (b/s)", "Commitment Status", "Total In (Bytes)", "Total out (Bytes)", "First Sample date", "Last Sample date");
    $content = implode(",", $heading);
    $content .= "\n";
    while ($obj = mysql_fetch_object($result)) {
        $data = array();
        $pid = $obj->profile_id;
        if ($obj->in95 > $obj->out95) {
            $bill95 = $obj->in95;
        } else {
            $bill95 = $obj->out95;
        }
        // Create Mb/s number
        $bill95_mb = round($bill95 / (1000 * 1000), 2);
        // get client name
        $contact_name = "N/A";
        $client_id = $obj->client_id;
        if (!is_null($client_id)) {
            $contact = new Contact($client_id);
            $contact_name = $contact->get_name();
            if ($contact_name != '') {
            } else {
                $contact_name = "N/A";
            }
        }
        if (!$obj->traffic_cap) {
            $cap_ok = "N/A";
        } elseif ($bill95 > $obj->traffic_cap) {
            $cap_ok = "Over Commitment";
        } else {
            $cap_ok = "Under Commitment";
        }
        $profile_name = get_accounting_profile_name($pid);
        array_push($data, $contact_name, $profile_name, $obj->report_name, $obj->date1, $obj->date2, $obj->avg_in, $obj->avg_out, $obj->max_in, $obj->max_out, $obj->in95, $obj->out95, $bill95, $bill95_mb, $obj->traffic_cap, $cap_ok, $obj->tot_in, $obj->tot_out, $obj->sample_date1, $obj->sample_date2);
        $content .= stripslashes(implode(",", $data));
        $content .= "\n";
    }
    return $content;
}

function displayAllArchived($groupTypes)
{
    //global the tool and make a tool bar for adding a contact
    global $tool, $contactForm;
    if ($_SESSION['access'] >= 50) {
        $toolNames = array("Add New Contacts", "Contacts", "Contact Types", "Person Types");
        $toolIcons = array("add", "contact", "contact", "contact");
        $toolHandlers = array("handleEvent('contacts.php?action=addGroup')", "handleEvent('contacts.php')", "handleEvent('contacts.php?action=showGroupTypes')", "handleEvent('contacts.php?action=showArchivedGroup')");
    } else {
        $toolNames = array("Contacts", "Contact Types", "Person Types");
        $toolIcons = array("contact", "contact", "contact");
        $toolHandlers = array("handleEvent('contacts.php')", "handleEvent('contacts.php?action=showGroupTypes')", "handleEvent('contacts.php?action=showArchivedGroup')");
    }
    echo $tool->createNewTools($toolNames, $toolIcons, $toolHandlers);
    echo $tool->createNewFilters();
    //get all the contact and display them all in the 2 sections: "Contact Name" and "Contact ID".
    //$allGroupTypes = $groupTypes->get_group_types(1);
    $allGroups = Contact::get_groups(1);
    $keyHandlers = array();
    $keyTitle = array();
    $keyData = array();
    if (isset($allGroups)) {
        foreach ($allGroups as $id => $value) {
            $curGroup = new Contact($id);
            array_push($keyHandlers, "handleEvent('contacts.php?action=showGroup&groupID={$id}')");
            array_push($keyTitle, $curGroup->get_name());
            array_push($keyData, $curGroup->get_group_type_name());
            //$curGroupType = new GroupType($id);
            //array_push($keyData, $curGroupType->get_desc());
        }
    } else {
        $contactForm->warning("There are NO group types available");
    }
    $headings = array("Contacts", "Contact Type");
    $contactForm->setTableWidth("1024px");
    $contactForm->setTitles($keyTitle);
    $contactForm->setData($keyData);
    $contactForm->setEventHandler($keyHandlers);
    $contactForm->setHeadings($headings);
    $contactForm->setSortable(true);
    echo $contactForm->showAll();
}

function displayLocations($location)
{
    //global all variables
    global $locationForm, $tool;
    //make the tool bar for this page
    if ($_SESSION['access'] >= 50) {
        $toolNames = array("Edit Location", "Add New Room", "Remove Location");
        $toolIcons = array("edit", "add", "delete");
        $toolHandlers = array("handleEvent('location.php?action=editLocation&locationID=" . $_GET["locationID"] . "')", "handleEvent('location.php?action=addRoom&locationID=" . $_GET["locationID"] . "')", "handleEvent('location.php?action=removeLocation&locationID=" . $_GET["locationID"] . "')");
        echo $tool->createNewTools($toolNames, $toolIcons, $toolHandlers);
    }
    $contactGroup = $location->get_contact_group_id();
    $thisGroup = new Contact($contactGroup);
    $groupName = $thisGroup->get_name();
    $groupTypeName = $thisGroup->get_group_type_name();
    if (isset($groupName) && isset($groupTypeName)) {
        $groupLoc = "<a href='contacts.php?action=showGroup&groupID=" . $contactGroup . "'>" . $groupName . "</a>";
    } else {
        $groupLoc = "N/A";
    }
    $locationType = new LocationType($location->get_location_type());
    $locationHeader = array($location->get_name());
    $locationTitle = array("Description", "Country", "Province", "City", "Address 1", "Address 2", "Zip Code", "Contacts", "Notes", "Location Type");
    $locationInfo = array($location->get_desc(), $location->get_country(), $location->get_province(), $location->get_city(), $location->get_addr_line1(), $location->get_addr_line2(), $location->get_zip_code(), $groupLoc, $location->get_notes(), $locationType->get_name());
    $allRooms = $location->get_rooms();
    $roomTypes = array();
    foreach ($allRooms as $id => $value) {
        $curRoom = new Room($id);
        if (!in_array($curRoom->get_room_type(), $roomTypes) && $_GET['locationID'] == $curRoom->get_location_id()) {
            array_push($roomTypes, $curRoom->get_room_type());
        }
    }
    //if the user is editting this information, make it all editable
    if ($_GET['action'] == editLocation) {
        $locationInfoKey = array("name", "desc", "country", "province", "city", "address1", "address2", "zip", "group", "notes", "type");
        $fieldType = array(8 => "drop_down", 9 => "text_area", 10 => "drop_down");
        $locationHeader = array("Location Information");
        $locationTitle = array("Name", "Description", "Country", "Province", "City", "Address 1", "Address 2", "Zip Code", "Contact", "Notes", "Location Type");
        $locationInfo = array($location->get_name(), $location->get_desc(), $location->get_country(), $location->get_province(), $location->get_city(), $location->get_addr_line1(), $location->get_addr_line2(), $location->get_zip_code(), $thisGroup->get_name(), $location->get_notes(), $locationType->get_name());
        $allLocationType = LocationType::get_location_types();
        $allGroups = Contact::get_groups();
        $locationForm->setHeadings($locationHeader);
        $locationForm->setTitles($locationTitle);
        $locationForm->setData($locationInfo);
        $locationForm->setSortable(false);
        $locationForm->setDatabase($locationInfoKey);
        $locationForm->setUpdateValue("updateLocation");
        $locationForm->setType($allGroups);
        $locationForm->setType($allLocationType);
        $locationForm->setFieldType($fieldType);
        echo $locationForm->editLocationForm();
    } else {
        if ($_GET['action'] == showLocation) {
            $locationForm->setTableWidth("1024px");
            $locationForm->setTitles($locationTitle);
            $locationForm->setData($locationInfo);
            $locationForm->setHeadings($locationHeader);
            $locationForm->setSortable(false);
            echo $locationForm->showAll();
            echo "<div style='clear:left; width:1024px;'>";
            foreach ($roomTypes as $id => $value) {
                $curRoomType = new RoomType($value);
                $roomHeader = array($curRoomType->get_name());
                $roomTitle = array();
                $roomInfo = array();
                $roomHandler = array();
                foreach ($allRooms as $cID => $cValue) {
                    $curRoom = new Room($cID);
                    if ($curRoom->get_room_type() == $value) {
                        array_push($roomTitle, $curRoom->get_name());
                        array_push($roomInfo, $curRoom->get_desc(), "<a href='location.php?action=removeRoom&locationID=" . $_GET['locationID'] . "&roomTypeID=" . $value . "&roomID=" . $cID . "'>Remove</a>");
                        array_push($roomHandler, "handleEvent('location.php?action=showRooms&locationID=" . $_GET['locationID'] . "&roomTypeID=" . $value . "&roomID=" . $cID . "')");
                    }
                }
                //make the tool bar for this page
                /*if ($_SESSION['access'] >= 50)
                		{
                			$toolNames = array("Add New Room", "Edit Room Type", "Remove Room Type");
                			$toolIcons = array("add", "edit", "delete");
                			$toolHandlers = array("handleEvent('location.php?action=addRoom&locationID=".$_GET['locationID']."&roomTypeID=".$value."')",
                								"handleEvent('location.php?action=editRoomType&locationID=".$_GET['locationID']."&roomTypeID=".$value."')",
                								"handleEvent('location.php?action=removeRoomType&locationID=".$_GET['locationID']."&roomTypeID=".$value."')",);
                			echo $tool->createNewTools($toolNames, $toolIcons, $toolHandlers);
                		}*/
                $locationForm->setTableWidth("300px");
                $locationForm->setCols(3);
                $locationForm->setTitles($roomTitle);
                $locationForm->setData($roomInfo);
                $locationForm->setEventHandler($roomHandler);
                $locationForm->setHeadings($roomHeader);
                $locationForm->setSortable(true);
                $locationForm->setFirst(false);
                echo $locationForm->showAll();
            }
            echo "</div>";
        }
    }
}

 function get_assigned_to_name()
 {
     if ($this->assigned_to === NULL) {
         return "";
     }
     $assigned_to = new Contact($this->assigned_to);
     return $assigned_to->get_name();
 }

function editReportProfile()
{
    //global the tool and make a tool bar for adding a device and display all the archived device, and displaying the IP Report
    global $tool, $form, $report_types;
    include_once 'classes/Contact.php';
    $toolNames = array("Edit Profile", "Delete Profile", "Create Report");
    $toolIcons = array("edit", "delete", "report");
    $toolHandlers = array("handleEvent('" . $_SERVER['PHP_SELF'] . "?action=editReportProfile&profileid=" . $_GET[profileid] . "')", "handleEvent('" . $_SERVER['PHP_SELF'] . "?action=deleteReportProfile&profileid=" . $_GET[profileid] . "')", "handleEvent('" . $_SERVER['PHP_SELF'] . "?action=renderReportProfileReport&profileid=" . $_GET[profileid] . "')");
    echo $tool->createNewTools($toolNames, $toolIcons, $toolHandlers);
    if (is_numeric($_GET[profileid])) {
        $profile = new CheckReportProfile($_GET[profileid]);
    } else {
        $form->warning("Invalid Profile id id");
        return;
    }
    $allGroups[""] = "";
    foreach (Contact::get_groups() as $id => $name) {
        $allGroups[$id] = $name;
    }
    $form->setType($allGroups);
    // Drop down
    $form->setType($report_types);
    // Drop down
    $headings = array("Edit Report Profile Details");
    $postKeys = array("profile_name", "profile_client", "profile_report_type", "profile_notes");
    $keyTitle = array("Name.tip.descriptive name for this profile", "Client.tip.Optionally specify the contact client", "Report Type", "Notes");
    $keyHandlers = array();
    $keyData = array();
    if ($profile->get_contact_id()) {
        $contact = new Contact($profile->get_contact_id());
        $contact_name = $contact->get_name();
    } else {
        $contact_name = "";
    }
    $keyData = array($profile->get_name(), $contact_name, $report_types[$profile->get_report_type()], $profile->get_notes());
    $postKeys = array("profile_name", "profile_client", "profile_report_type", "profile_notes");
    $fieldType[1] = "drop_down";
    $fieldType[2] = "drop_down";
    $fieldType[3] = "text_area";
    $form->setFieldType($fieldType);
    $form->setCols(2);
    $form->setTableWidth("450px");
    $form->setData($keyData);
    $form->setTitles($keyTitle);
    $form->setDatabase($postKeys);
    $form->setHeadings($headings);
    $form->setSortable(false);
    $form->setUpdateValue("updateReportProfile");
    echo $form->editForm();
}

         $search_str .= " Name = " . $_GET['title'] . ", ";
     }
     if ($_GET['tags'] != "") {
         $search_str .= " Tags = " . $_GET['tags'] . ", ";
     }
     if ($_GET['location'] != "") {
         $loc = new Location($_GET['location']);
         $search_str .= " Location = " . $loc->get_name() . ", ";
     }
     if ($_GET['owner'] != "") {
         $own = new Contact($_GET['owner']);
         $search_str .= " Owner = " . $own->get_name() . ", ";
     }
     if ($_GET['assigned'] != "") {
         $assign = new Contact($_GET['assigned']);
         $search_str .= " Assigned To = " . $assign->get_name() . ", ";
     }
     if ($_GET['status'] != "") {
         $search_str .= " Status = " . $_GET['status'] . ", ";
     }
     $search_str = rtrim($search_str, ", ");
     //display what is searched and what is found
     Form::success("Searched for:" . $search_str . " | Results Found: " . $result_c_count . " child network(s), " . $result_p_count . " parent network(s)");
 } else {
     //just search for everything if nothing is searched
     $s_results = $IP_Search->search("", "", "", "", "", "", $family);
 }
 //if there's no result display nothing
 if (count($s_results) == 0) {
     $search_str = "";
 }

 function render_show_accounting_profile()
 {
     if (isset($_GET['pid']) && is_numeric($_GET['pid'])) {
         $pid = $_GET['pid'];
     } else {
         return "<b>Sorry invalid profile id " . $_GET['pid'] . "</b>";
     }
     $content = "";
     $profile_name = $this->get_accounting_profile_name($pid);
     // Menu bar
     $content .= "<div style='font-size:10px; font-weight:100px;'>\n\t\t\t<a href='{$this->url}'>Accounting</a> >> {$profile_name}</div><br>";
     /*
      Get all SCU-DCU sources for this profile
     */
     $query = "SELECT accounting_source from accounting_profiles_files\n\t\t\tWHERE profile_id = '{$pid}'";
     $result = mysql_query($query);
     $sources = '';
     while ($obj = mysql_fetch_object($result)) {
         $sources .= "graph_profile_id[]=" . $obj->accounting_source . "&";
     }
     // Remove last &
     $sources = substr($sources, 0, -1);
     /*
      End Get all SCU-DCU sources for this profile
     */
     // Tools menu
     $tool = new EdittingTools();
     if ($_SESSION['access'] >= 50) {
         $toolNames = array("Edit", "Delete", "Saved Reports", "New Report", "Quick Report");
         $toolIcons = array("edit", "delete", "stat", "line", "graph");
         $toolHandlers = array("window.location.href='{$this->url}&action=edit_accounting_profile&pid={$pid}'", "window.location.href='{$this->url}&action=del_accounting_profile&pid={$pid}'", "window.location.href='{$this->url}&pid={$pid}&action=show_reports'", "window.location.href='{$this->url}&action=create_report&pid={$pid}'", "window.location.href='{$this->url}&action=graph_profiles&{$sources}&pid={$pid}'");
         $content .= $tool->createNewTools($toolNames, $toolIcons, $toolHandlers);
     }
     $content .= "<p>";
     $query = "Select title, client_id, notes, traffic_cap\n\t\t\tFROM accounting_profiles\n\t\t\tWHERE profile_id = '{$pid}'";
     $result = mysql_query($query);
     if (!$result) {
         return "<b>Sorry something went wrong</b>" . mysql_error() . $query;
     }
     $obj = mysql_fetch_object($result);
     $contact = new Contact($obj->client_id);
     $contact_name = $contact->get_name();
     if ($contact_name == '') {
         $contact_name = "n/a";
     }
     $values = array($obj->title, $contact_name, $this->int_to_si($obj->traffic_cap), $obj->notes);
     $form = new Form("auto", 2);
     $heading = array("Edit Accounting Profile");
     $titles = array("Name", "Client", "Traffic Cap.tip.Configured cap or Contracted rate.", "Notes");
     $form->setSortable(false);
     $form->setHeadings($heading);
     $form->setTitles($titles);
     $form->setDatabase($titles);
     $form->setData($values);
     //set the table size
     $form->setTableWidth("1024px");
     $form->setTitleWidth("20%");
     $content .= $form->ShowForm(1);
     $content .= "<div style=\"clear:both;\"></div> </p>";
     $content .= "</p><p><h2>RRD files</h2>";
     $tool2 = new EdittingTools();
     if ($_SESSION['access'] >= 50) {
         $toolNames = array("Add RRD file");
         $toolIcons = array("add");
         #$formType = array("newDialog");
         #$tool2->createNewModal($toolNames, $toolIcons, $formType);
         $toolHandlers = array("window.location.href='{$this->url}&action=show_add_rrd_to_profile&pid={$pid}'");
         $content .= $tool2->createNewTools($toolNames, $toolIcons, $toolHandlers);
     }
     $form = new Form("auto", 3);
     $heading = array("Delete", "Device", "SCU-DCU source");
     $data = array();
     $title = array();
     $handler = array();
     #$content .=  "<table><tr><th>Delete</th><th>Device</th><th>SCU-DCU sources</th>";
     $query = "SELECT accounting_profiles_files.accounting_source,\n\t\t\t\taccounting_sources.title, accounting_sources.device_id,\n\t\t\t\tDevices.name as device_name\n\t\t\tFROM accounting_profiles_files, accounting_sources, Devices\n\t\t\tWHERE profile_id = '{$pid}'\n\t\t\tAND accounting_sources.device_id = Devices.device_id\n\t\t\tAND accounting_profiles_files.accounting_source = accounting_sources.id";
     $result = mysql_query($query);
     if (!$result) {
         $content .= "<b>No Files found</b>";
     }
     while ($obj = mysql_fetch_object($result)) {
         #$content .=  "<tr><td><a href = '$this->url&action=del_accounting_source_from_profile&pid=$pid&asrc=$obj->accounting_source'><img src='icons/Delete.png' height=20></a></td> <td>$obj->device_name</td><td>$obj->title</td></tr>";
         array_push($title, "<a href='{$this->url}&action=del_accounting_source_from_profile&pid={$pid}&asrc={$obj->accounting_source}'><img src='icons/Delete.png' height=20></a>");
         array_push($data, $obj->device_name, $obj->title);
     }
     #$content .=  "</table>";
     $form->setSortable(true);
     // or false for not sortable
     $form->setHeadings($heading);
     $form->setTitles($title);
     $form->setTitleWidth("50px");
     $form->setData($data);
     $form->setTableWidth("500px");
     $content .= $form->showForm();
     // This is to add normal Interface RRD files
     // AT, remove this link as it's not fully implemented
     //$content .= "<a href='$this->url&action=add_device_interface_to_profile&pid=$pid'>Add interface to accounting profile</a>";
     // Done
     return $content;
 }