PHP Admin::fetch_all_objects方法代码示例

/***
 *	Generate XLS file for VLANs
 *********************************/
# include required scripts
require dirname(__FILE__) . '/../../../functions/functions.php';
require dirname(__FILE__) . '/../../../functions/PEAR/Spreadsheet/Excel/Writer.php';
# initialize required objects
$Database = new Database_PDO();
$Result = new Result();
$User = new User($Database);
$Admin = new Admin($Database);
$Tools = new Tools($Database);
# verify that user is logged in
$User->check_user_session();
# fetch all l2 domains
$vlan_domains = $Admin->fetch_all_objects("vlanDomains", "id");
# get all custom fields
$custom_fields = $Tools->fetch_custom_fields('vlans');
# Create a workbook
$today = date("Ymd");
$filename = $today . "_phpipam_VLAN_export.xls";
$workbook = new Spreadsheet_Excel_Writer();
//formatting headers
$format_header =& $workbook->addFormat();
$format_header->setBold();
$format_header->setColor('black');
$format_header->setSize(12);
$format_header->setAlign('left');
//formatting content
$format_text =& $workbook->addFormat();
// Create a worksheet

require dirname(__FILE__) . '/../../../functions/functions.php';
# initialize user object
$Database = new Database_PDO();
$User = new User($Database);
$Admin = new Admin($Database);
$Sections = new Sections($Database);
$Subnets = new Subnets($Database);
$Result = new Result();
# verify that user is logged in
$User->check_user_session();
# ID must be numeric
if (!is_numeric($_POST['subnetId'])) {
    $Result->show("danger", _("Invalid ID"), true, true);
}
# get all groups
$groups = $Admin->fetch_all_objects("userGroups", "g_id");
# get subnet details
$subnet = $Subnets->fetch_subnet(null, $_POST['subnetId']);
?>


<script type="text/javascript">
$(document).ready(function() {
/* bootstrap switch */
var switch_options = {
	onText: "Yes",
	offText: "No",
    onColor: 'default',
    offColor: 'default',
    size: "mini"
};

require dirname(__FILE__) . '/../../../functions/functions.php';
# initialize user object
$Database = new Database_PDO();
$User = new User($Database);
$Admin = new Admin($Database);
$Result = new Result();
# verify that user is logged in
$User->check_user_session();
//strip AS if provided, to get just the number
if (substr($_POST['as'], 0, 2) == "AS" || substr($_POST['as'], 0, 2) == "as") {
    $_POST['as'] = substr($_POST['as'], 2);
}
# fetch subnets form ripe
$subnet = $Admin->ripe_fetch_subnets($_POST['as']);
# fetch all sections
$sections = $Admin->fetch_all_objects("sections", "id");
$vlans = $Admin->fetch_all_objects("vlans", "vlanId");
$vrfs = $Admin->fetch_all_objects("vrf", "vrfId");
//none found
if (sizeof(@$subnet) == 0) {
    print "<hr>";
    $Result->show("danger alert-absolute", _('No subnets found') . '!', true);
} else {
    //form
    print '<form name="asImport" id="asImport">';
    //table
    print '<table class="asImport table table-striped table-condensed table-top table-auto">';
    //headers
    print '<tr>';
    print '	<th colspan="5">' . _('I found the following routes belonging to AS') . ' ' . $_POST['as'] . ':</th>';
    print '</tr> ';

    $Sections = new Sections($Database);
}
if (!isset($Subnets)) {
    $Subnets = new Subnets($Database);
}
# verify that user is logged in, to guard against direct access of page and possible exploits
$User->check_user_session();
# Get mask check
#automated $cidrformat = isset($_GET['cidrformat']) ? $_GET['cidrformat'] : "off";
#separate option $rebuildmnr = isset($_GET['rebuildmnr']) ? $_GET['rebuildmnr'] : "off";
# read again the custom fields, if any
if (!isset($custom_fields)) {
    $custom_fields = $Tools->fetch_custom_fields("subnets");
}
# fetch all l2 domains
$vlan_domains = $Admin->fetch_all_objects("vlanDomains", "id");
# load VLANs and process for easier later check
$vlan_data = array();
foreach ($vlan_domains as $vlan_domain) {
    //cast
    $vlan_domain = (array) $vlan_domain;
    // read vlans
    $all_vlans = $Admin->fetch_multiple_objects("vlans", "domainId", $vlan_domain['id'], "number");
    $all_vlans = (array) $all_vlans;
    // skip empty domains
    if (sizeof($all_vlans) == 0) {
        # create entry for domain check
        $vlan_data[$vlan_domain['name']] = array();
        continue;
    }
    //write all VLAN entries

print $readonly;
?>
>
		</td>
	</tr>

	<!-- Type -->
	<tr>
		<td><?php 
print _('Device type');
?>
</td>
		<td>
			<select name="type" class="form-control input-sm input-w-auto">
			<?php 
$types = $Admin->fetch_all_objects("deviceTypes", "tid");
foreach ($types as $key => $name) {
    if ($device['type'] == $key) {
        print "<option value='{$key}' selected='selected'>{$name->tname}</option>";
    } else {
        print "<option value='{$key}' >{$name->tname}</option>";
    }
}
?>
			</select>
		</td>
	</tr>

	<!-- Vendor -->
	<tr>
		<td><?php 

$Admin = new Admin($Database);
$Subnets = new Subnets($Database);
$Tools = new Tools($Database);
$Result = new Result();
# verify that user is logged in
$User->check_user_session();
# create csrf token
$csrf = $User->csrf_cookie("create", "user");
# strip tags - XSS
$_POST = $User->strip_input_tags($_POST);
# validate action
$Admin->validate_action($_POST['action'], true);
# fetch custom fields
$custom = $Tools->fetch_custom_fields('users');
# fetch all languages
$langs = $Admin->fetch_all_objects("lang", "l_id");
# fetch all auth types
$auth_types = $Admin->fetch_all_objects("usersAuthMethod", "id");
# fetch all groups
$groups = $Admin->fetch_all_objects("userGroups", "g_id");
# set header parameters and fetch user
if ($_POST['action'] != "add") {
    $user = $Admin->fetch_object("users", "id", $_POST['id']);
    //false
    if ($user === false) {
        $Result->show("danger", _("Invalid ID"), true, true);
    } else {
        $user = (array) $user;
    }
} else {
    $user = array();

/**
 *	Generate XLS file for VRFs
 *********************************/
# include required scripts
require dirname(__FILE__) . '/../../../functions/functions.php';
require dirname(__FILE__) . '/../../../functions/PEAR/Spreadsheet/Excel/Writer.php';
# initialize required objects
$Database = new Database_PDO();
$Result = new Result();
$User = new User($Database);
$Admin = new Admin($Database);
# verify that user is logged in
$User->check_user_session();
# fetch all vrfs
$all_vrfs = $Admin->fetch_all_objects("vrf", "vrfId");
if (!$all_vrfs) {
    $all_vrfs = array();
}
# Create a workbook
$today = date("Ymd");
$filename = $today . "_phpipam_VRF_export.xls";
$workbook = new Spreadsheet_Excel_Writer();
//formatting headers
$format_header =& $workbook->addFormat();
$format_header->setBold();
$format_header->setColor('black');
$format_header->setSize(12);
$format_header->setAlign('left');
//formatting content
$format_text =& $workbook->addFormat();

 /**
  * Fetches nameserver sets to belong to section
  *
  * @access public
  * @param mixed $sectionId
  * @return void
  */
 public function fetch_section_nameserver_sets($sectionId)
 {
     # first fetch all nameserver sets
     $Admin = new Admin($this->Database, false);
     $nameservers = $Admin->fetch_all_objects("nameservers");
     # loop and check
     if ($nameservers !== false) {
         foreach ($nameservers as $n) {
             //default
             if ($n->id == 1) {
                 $permitted[] = $n->id;
             } else {
                 //array
                 if (in_array($sectionId, explode(";", $n->permissions))) {
                     $permitted[] = $n->id;
                 }
             }
         }
         # return permitted
         return $permitted;
     } else {
         return false;
     }
 }

    </script>
    <?php 
    die;
} else {
    # create csrf token
    $csrf = $User->csrf_cookie("create", "rack_devices");
    # fetch rack details
    $rack = $Admin->fetch_object("racks", "id", $_POST['rackid']);
    # check
    if ($rack === false) {
        $Result->show("danger", _("Invalid ID"), true, true);
    }
    # fetch existing devices
    $rack_devices = $Racks->fetch_rack_devices($rack->id);
    # all devices
    $devices = $Admin->fetch_all_objects("devices", "id");
    if ($devices !== false) {
        foreach ($devices as $k => $d) {
            if (strlen($d->rack) != 0) {
                unset($devices[$k]);
            }
        }
    }
    ?>

<script type="text/javascript">
$(document).ready(function(){
     if ($("[rel=tooltip]").length) { $("[rel=tooltip]").tooltip(); }
});
</script>

<?php

/**
 * Script to display usermod result
 *************************************/
/* functions */
require dirname(__FILE__) . '/../../../functions/functions.php';
# initialize user object
$Database = new Database_PDO();
$User = new User($Database);
$Admin = new Admin($Database);
$Result = new Result();
# verify that user is logged in
$User->check_user_session();
# fetch all available LDAP servers
$servers = $Admin->fetch_all_objects("usersAuthMethod");
foreach ($servers as $k => $s) {
    if ($s->type != "AD" && $s->type != "LDAP") {
        unset($servers[$k]);
    }
}
# die if no servers
if (sizeof($servers) == 0) {
    $Result->show("danger", _("No servers available"), true, true);
}
?>


<!-- header -->
<div class="pHeader"><?php 
print _('Search user in AD');

	<!-- Device -->
	<tr>
		<td class="middle"><?php 
print _('Device');
?>
</td>
		<td id="deviceDropdown">
			<select name="device" class="form-control input-sm input-w-auto">
				<option value="0"><?php 
print _('None');
?>
</option>
				<?php 
// fetch all devices
$devices = $Admin->fetch_all_objects("devices", "hostname");
// loop
if ($devices !== false) {
    foreach ($devices as $device) {
        //check if permitted in this section!
        $sections = explode(";", $device->sections);
        if (in_array($_POST['sectionId'], $sections)) {
            //if same
            if ($device->id == @$subnet_old_details['device']) {
                print '<option value="' . $device->id . '" selected>' . $device->hostname . '</option>' . "\n";
            } else {
                print '<option value="' . $device->id . '">' . $device->hostname . '</option>' . "\n";
            }
        }
    }
}

 public function fetch_section_domains($sectionId)
 {
     # first fetch all domains
     $Admin = new Admin($this->Database, false);
     $domains = $Admin->fetch_all_objects("vlanDomains");
     # loop and check
     foreach ($domains as $d) {
         //default
         if ($d->id == 1) {
             $permitted[] = $d->id;
         } else {
             //array
             if (in_array($sectionId, explode(";", $d->permissions))) {
                 $permitted[] = $d->id;
             }
         }
     }
     # return permitted
     return $permitted;
 }

require dirname(__FILE__) . '/../../../functions/functions.php';
require dirname(__FILE__) . '/../../../functions/PEAR/Spreadsheet/Excel/Writer.php';
# initialize user object
$Database = new Database_PDO();
$User = new User($Database);
$Admin = new Admin($Database);
$Result = new Result();
# verify that user is logged in
$User->check_user_session();
// Create a workbook
$filename = "phpipam_logs_export_" . date("Y-m-d") . ".xls";
$workbook = new Spreadsheet_Excel_Writer();
//increase memory size
ini_set('memory_limit', '1024M');
//fetch sections, and for each section write new tab, inside tab write all values!
$logs = $Admin->fetch_all_objects("logs", "id");
//formatting headers
$format_header =& $workbook->addFormat();
$format_header->setBold();
$format_header->setColor('white');
$format_header->setFgColor('black');
//formatting titles
$format_title =& $workbook->addFormat();
$format_title->setColor('black');
$format_title->setFgColor(22);
//light gray
$format_title->setBottom(2);
$format_title->setLeft(1);
$format_title->setRight(1);
$format_title->setTop(1);
$format_title->setAlign('left');