Relation between Contracts and Items
function cleanDBonPurge()
{
$cs = new Contract_Supplier();
$cs->cleanDBonItemDelete($this->getType(), $this->fields['id']);
$ci = new Contract_Item();
$ci->cleanDBonItemDelete($this->getType(), $this->fields['id']);
}
/**
* Cron action on contracts : alert depending of the config : on notice and expire
*
* @param $task for log, if NULL display (default NULL)
**/
static function cronContract($task = NULL)
{
global $DB, $CFG_GLPI;
if (!$CFG_GLPI["use_mailing"]) {
return 0;
}
$message = array();
$items_notice = array();
$items_end = array();
$cron_status = 0;
$contract_infos[Alert::END] = array();
$contract_infos[Alert::NOTICE] = array();
$contract_messages = array();
foreach (Entity::getEntitiesToNotify('use_contracts_alert') as $entity => $value) {
$before = Entity::getUsedConfig('send_contracts_alert_before_delay', $entity);
$query_notice = "SELECT `glpi_contracts`.*\n FROM `glpi_contracts`\n LEFT JOIN `glpi_alerts`\n ON (`glpi_contracts`.`id` = `glpi_alerts`.`items_id`\n AND `glpi_alerts`.`itemtype` = 'Contract'\n AND `glpi_alerts`.`type`='" . Alert::NOTICE . "')\n WHERE (`glpi_contracts`.`alert` & " . pow(2, Alert::NOTICE) . ") >'0'\n AND `glpi_contracts`.`is_deleted` = '0'\n AND `glpi_contracts`.`begin_date` IS NOT NULL\n AND `glpi_contracts`.`duration` <> '0'\n AND `glpi_contracts`.`notice` <> '0'\n AND DATEDIFF(ADDDATE(`glpi_contracts`.`begin_date`,\n INTERVAL `glpi_contracts`.`duration` MONTH),\n CURDATE()) > '0'\n AND DATEDIFF(ADDDATE(`glpi_contracts`.`begin_date`,\n INTERVAL (`glpi_contracts`.`duration`\n -`glpi_contracts`.`notice`) MONTH),\n CURDATE()) < '{$before}'\n AND `glpi_alerts`.`date` IS NULL\n AND `glpi_contracts`.`entities_id` = '" . $entity . "'";
$query_end = "SELECT `glpi_contracts`.*\n FROM `glpi_contracts`\n LEFT JOIN `glpi_alerts`\n ON (`glpi_contracts`.`id` = `glpi_alerts`.`items_id`\n AND `glpi_alerts`.`itemtype` = 'Contract'\n AND `glpi_alerts`.`type`='" . Alert::END . "')\n WHERE (`glpi_contracts`.`alert` & " . pow(2, Alert::END) . ") > '0'\n AND `glpi_contracts`.`is_deleted` = '0'\n AND `glpi_contracts`.`begin_date` IS NOT NULL\n AND `glpi_contracts`.`duration` <> '0'\n AND DATEDIFF(ADDDATE(`glpi_contracts`.`begin_date`,\n INTERVAL (`glpi_contracts`.`duration`) MONTH),\n CURDATE()) < '{$before}'\n AND `glpi_alerts`.`date` IS NULL\n AND `glpi_contracts`.`entities_id` = '" . $entity . "'";
$querys = array('notice' => $query_notice, 'end' => $query_end);
foreach ($querys as $type => $query) {
foreach ($DB->request($query) as $data) {
$entity = $data['entities_id'];
$message = sprintf(__('%1$s: %2$s') . "<br>\n", $data["name"], Infocom::getWarrantyExpir($data["begin_date"], $data["duration"], $data["notice"]));
$contract_infos[$type][$entity][$data['id']] = $data;
if (!isset($contract_messages[$type][$entity])) {
switch ($type) {
case 'notice':
$contract_messages[$type][$entity] = __('Contract entered in notice time') . "<br>";
break;
case 'end':
$contract_messages[$type][$entity] = __('Contract ended') . "<br>";
break;
}
}
$contract_messages[$type][$entity] .= $message;
}
}
// Get contrats with periodicity alerts
$query_periodicity = "SELECT `glpi_contracts`.*\n FROM `glpi_contracts`\n WHERE `glpi_contracts`.`alert` & " . pow(2, Alert::PERIODICITY) . " > '0'\n AND `glpi_contracts`.`entities_id` = '" . $entity . "' ";
// Foreach ones :
foreach ($DB->request($query_periodicity) as $data) {
$entity = $data['entities_id'];
// Compute end date + 12 month : do not send alerts after
$end_alert = date('Y-m-d', strtotime($data['begin_date'] . " +" . ($data['duration'] + 12) . " month"));
if (!empty($data['begin_date']) && $data['periodicity'] && $end_alert > date('Y-m-d')) {
$todo = array('periodicity' => Alert::PERIODICITY);
if ($data['alert'] & pow(2, Alert::NOTICE)) {
$todo['periodicitynotice'] = Alert::NOTICE;
}
// Get previous alerts
foreach ($todo as $type => $event) {
$previous_alerts[$type] = Alert::getAlertDate(__CLASS__, $data['id'], $event);
}
// compute next alert date based on already send alerts (or not)
foreach ($todo as $type => $event) {
$next_alerts[$type] = date('Y-m-d', strtotime($data['begin_date'] . " -" . $before . " day"));
if ($type == Alert::NOTICE) {
$next_alerts[$type] = date('Y-m-d', strtotime($next_alerts[$type] . " -" . $data['notice'] . " month"));
}
$today_limit = date('Y-m-d', strtotime(date('Y-m-d') . " -" . $data['periodicity'] . " month"));
// Init previous by begin date if not set
if (empty($previous_alerts[$type])) {
$previous_alerts[$type] = $today_limit;
}
while ($next_alerts[$type] < $previous_alerts[$type] && $next_alerts[$type] < $end_alert) {
$next_alerts[$type] = date('Y-m-d', strtotime($next_alerts[$type] . " +" . $data['periodicity'] . " month"));
}
// If this date is passed : clean alerts and send again
if ($next_alerts[$type] <= date('Y-m-d')) {
$alert = new Alert();
$alert->clear(__CLASS__, $data['id'], $event);
$real_alert_date = date('Y-m-d', strtotime($next_alerts[$type] . " +" . $before . " day"));
$message = sprintf(__('%1$s: %2$s') . "<br>\n", $data["name"], Html::convDate($real_alert_date));
$data['alert_date'] = $real_alert_date;
$data['items'] = Contract_Item::getItemsForContract($data['id'], $entity);
$contract_infos[$type][$entity][$data['id']] = $data;
switch ($type) {
case 'periodicitynotice':
$contract_messages[$type][$entity] = __('Contract entered in notice time for period') . "<br>";
break;
case 'periodicity':
$contract_messages[$type][$entity] = __('Contract period ended') . "<br>";
break;
}
$contract_messages[$type][$entity] .= $message;
}
}
}
}
}
foreach (array('notice' => Alert::NOTICE, 'end' => Alert::END, 'periodicity' => Alert::PERIODICITY, 'periodicitynotice' => Alert::NOTICE) as $event => $type) {
if (isset($contract_infos[$event]) && count($contract_infos[$event])) {
foreach ($contract_infos[$event] as $entity => $contracts) {
if (NotificationEvent::raiseEvent($event, new self(), array('entities_id' => $entity, 'items' => $contracts))) {
$message = $contract_messages[$event][$entity];
$cron_status = 1;
$entityname = Dropdown::getDropdownName("glpi_entities", $entity);
if ($task) {
$task->log(sprintf(__('%1$s: %2$s') . "\n", $entityname, $message));
$task->addVolume(1);
} else {
Session::addMessageAfterRedirect(sprintf(__('%1$s: %2$s'), $entityname, $message));
}
$alert = new Alert();
$input["itemtype"] = __CLASS__;
$input["type"] = $type;
foreach ($contracts as $id => $contract) {
$input["items_id"] = $id;
$alert->add($input);
unset($alert->fields['id']);
}
} else {
$entityname = Dropdown::getDropdownName('glpi_entities', $entity);
//TRANS: %1$s is entity name, %2$s is the message
$msg = sprintf(__('%1$s: %2$s'), $entityname, __('send contract alert failed'));
if ($task) {
$task->log($msg);
} else {
Session::addMessageAfterRedirect($msg, false, ERROR);
}
}
}
}
}
return $cron_status;
}
This file is part of GLPI.
GLPI is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
GLPI is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with GLPI. If not, see <http://www.gnu.org/licenses/>.
--------------------------------------------------------------------------
*/
/** @file
* @brief
* @since version 0.84
*/
include '../inc/includes.php';
Session::checkCentralAccess();
$contract_item = new Contract_Item();
if (isset($_POST["add"])) {
$contract_item->check(-1, CREATE, $_POST);
if ($contract_item->add($_POST)) {
Event::log($_POST["contracts_id"], "contracts", 4, "financial", sprintf(__('%s adds a link with an item'), $_SESSION["glpiname"]));
}
Html::back();
}
Html::displayErrorAndDie("lost");
/**
* @param $type
* @param $model_id
* @param $tab_ids
* @param $location
**/
static function replace($type, $model_id, $tab_ids, $location)
{
global $DB, $CFG_GLPI, $PLUGIN_HOOKS;
$model = new PluginUninstallModel();
$model->getConfig($model_id);
$overwrite = $model->fields["overwrite"];
echo "<div class='center'>";
echo "<table class='tab_cadre_fixe'><tr><th>" . __('Replacement', 'uninstall') . "</th></tr>";
echo "<tr class='tab_bg_2'><td>";
$count = 0;
$tot = count($tab_ids);
Html::createProgressBar(__('Please wait, replacement is running...', 'uninstall'));
foreach ($tab_ids as $olditem_id => $newitem_id) {
$count++;
$olditem = new $type();
$olditem->getFromDB($olditem_id);
$newitem = new $type();
$newitem->getFromDB($newitem_id);
//Hook to perform actions before item is being replaced
$olditem->fields['_newid'] = $newitem_id;
$olditem->fields['_uninstall_event'] = $model_id;
$olditem->fields['_action'] = 'replace';
Plugin::doHook("plugin_uninstall_replace_before", $olditem);
// Retrieve informations
//States
if ($model->fields['states_id'] != 0) {
$olditem->update(array('id' => $olditem_id, 'states_id' => $model->fields['states_id']), false);
}
// METHOD REPLACEMENT 1 : Archive
if ($model->fields['replace_method'] == self::METHOD_PURGE) {
$name_out = str_shuffle(Toolbox::getRandomString(5) . time());
$plugin = new Plugin();
if ($plugin->isActivated('PDF')) {
// USE PDF EXPORT
$plugin->load('pdf', true);
include_once GLPI_ROOT . "/lib/ezpdf/class.ezpdf.php";
//Get all item's tabs
$tab = array_keys($olditem->defineTabs());
//Tell PDF to also export item's main tab, and in first position
array_unshift($tab, "_main_");
$itempdf = new $PLUGIN_HOOKS['plugin_pdf'][$type]($olditem);
$out = $itempdf->generatePDF(array($olditem_id), $tab, 1, false);
$name_out .= ".pdf";
} else {
//TODO Which datas ? Add Defaults...
$out = __('Replacement', 'uninstall') . "\r\n";
$datas = $olditem->fields;
unset($datas['comment']);
foreach ($datas as $k => $v) {
$out .= $k . ";";
}
$out .= "\r\n";
foreach ($datas as $k => $v) {
$out .= $v . ";";
}
// USE CSV EXPORT
$name_out .= ".csv";
}
// Write document
$out_file = GLPI_DOC_DIR . "/_uploads/" . $name_out;
$open_file = fopen($out_file, 'a');
fwrite($open_file, $out);
fclose($open_file);
// Compute comment text
$comment = __('This document is the archive of this replaced item', 'uninstall') . " " . self::getCommentsForReplacement($olditem, false, false);
// Create & Attach new document to current item
$doc = new Document();
$input = array('name' => addslashes(__('Archive of old material', 'uninstall')), 'upload_file' => $name_out, 'comment' => addslashes($comment), 'add' => __('Add'), 'entities_id' => $newitem->getEntityID(), 'is_recursive' => $newitem->isRecursive(), 'link' => "", 'documentcategories_id' => 0, 'items_id' => $olditem_id, 'itemtype' => $type);
//Attached the document to the old item, to generate an accurate name
$document_added = $doc->add($input);
//Attach the document to the new item, once the document's name is correct
$docItem = new Document_Item();
$docItemId = $docItem->add(array('documents_id' => $document_added, 'itemtype' => $type, 'items_id' => (int) $newitem_id));
}
// General Informations - NAME
if ($model->fields["replace_name"]) {
if ($overwrite || empty($newitem->fields['name'])) {
$newitem->update(array('id' => $newitem_id, 'name' => $olditem->getField('name')), false);
}
}
$data['id'] = $newitem->getID();
// General Informations - SERIAL
if ($model->fields["replace_serial"]) {
if ($overwrite || empty($newitem->fields['serial'])) {
$newitem->update(array('id' => $newitem_id, 'serial' => $olditem->getField('serial')), false);
}
}
// General Informations - OTHERSERIAL
if ($model->fields["replace_otherserial"]) {
if ($overwrite || empty($newitem->fields['otherserial'])) {
$newitem->update(array('id' => $newitem_id, 'otherserial' => $olditem->getField('otherserial')), false);
}
}
// Documents
if ($model->fields["replace_documents"] && in_array($type, $CFG_GLPI["document_types"])) {
$doc_item = new Document_Item();
foreach (self::getAssociatedDocuments($olditem) as $document) {
$doc_item->update(array('id' => $document['assocID'], 'itemtype' => $type, 'items_id' => $newitem_id), false);
}
}
// Contracts
if ($model->fields["replace_contracts"] && in_array($type, $CFG_GLPI["contract_types"])) {
$contract_item = new Contract_Item();
foreach (self::getAssociatedContracts($olditem) as $contract) {
$contract_item->update(array('id' => $contract['id'], 'itemtype' => $type, 'items_id' => $newitem_id), false);
}
}
// Infocoms
if ($model->fields["replace_infocoms"] && in_array($type, $CFG_GLPI["infocom_types"])) {
$infocom = new Infocom();
if ($overwrite) {
// Delete current Infocoms of new item
if ($infocom->getFromDBforDevice($type, $newitem_id)) {
//Do not log infocom deletion in the new item's history
$infocom->dohistory = false;
$infocom->deleteFromDB(1);
}
}
// Update current Infocoms of old item
if ($infocom->getFromDBforDevice($type, $olditem_id)) {
$infocom->update(array('id' => $infocom->getID(), 'itemtype' => $type, 'items_id' => $newitem_id), false);
}
}
// Reservations
if ($model->fields["replace_reservations"] && in_array($type, $CFG_GLPI["reservation_types"])) {
$resaitem = new ReservationItem();
if ($overwrite) {
// Delete current reservation of new item
$resa_new = new Reservation();
$resa_new->getFromDB($newitem_id);
if ($resa_new->is_reserved()) {
$resa_new = new ReservationItem();
$resa_new->getFromDBbyItem($type, $newitem_id);
if (count($resa_new->fields)) {
$resa_new->deleteFromDB(1);
}
}
}
// Update old reservation for attribute to new item
$resa_old = new Reservation();
$resa_old->getFromDB($olditem_id);
if ($resa_old->is_reserved()) {
$resa_old = new ReservationItem();
$resa_old->getFromDBbyItem($type, $olditem_id);
if (count($resa_old->fields)) {
$resa_old->update(array('id' => $resa_old->getID(), 'itemtype' => $type, 'items_id' => $newitem_id), false);
}
}
}
// User
if ($model->fields["replace_users"] && in_array($type, $CFG_GLPI["linkuser_types"])) {
$data = array();
$data['id'] = $newitem->getID();
if ($newitem->isField('users_id') && ($overwrite || empty($data['users_id']))) {
$data['users_id'] = $olditem->getField('users_id');
}
if ($newitem->isField('contact') && ($overwrite || empty($data['contact']))) {
$data['contact'] = $olditem->getField('contact');
}
if ($newitem->isField('contact_num') && ($overwrite || empty($data['contact_num']))) {
$data['contact_num'] = $olditem->getField('contact_num');
}
$newitem->update($data, false);
}
// Group
if ($model->fields["replace_groups"] && in_array($type, $CFG_GLPI["linkgroup_types"])) {
if ($newitem->isField('groups_id') && ($overwrite || empty($data['groups_id']))) {
$newitem->update(array('id' => $newitem_id, 'groups_id' => $olditem->getField('groups_id')), false);
}
}
// Tickets
if ($model->fields["replace_tickets"] && in_array($type, $CFG_GLPI["ticket_types"])) {
$ticket_item = new Item_Ticket();
foreach (self::getAssociatedTickets($type, $olditem_id) as $ticket) {
$ticket_item->update(array('id' => $ticket['id'], 'items_id' => $newitem_id), false);
}
}
//Array netport_types renamed in networkport_types in GLPI 0.80
if (isset($CFG_GLPI["netport_types"])) {
$netport_types = $CFG_GLPI["netport_types"];
} else {
$netport_types = $CFG_GLPI["networkport_types"];
}
// NetPorts
if ($model->fields["replace_netports"] && in_array($type, $netport_types)) {
$netport_item = new NetworkPort();
foreach (self::getAssociatedNetports($type, $olditem_id) as $netport) {
$netport_item->update(array('id' => $netport['id'], 'itemtype' => $type, 'items_id' => $newitem_id), false);
}
}
// Directs connections
if ($model->fields["replace_direct_connections"] && in_array($type, array('Computer'))) {
$comp_item = new Computer_Item();
foreach (self::getAssociatedItems($olditem) as $itemtype => $connections) {
foreach ($connections as $connection) {
$comp_item->update(array('id' => $connection['id'], 'computers_id' => $newitem_id, 'itemtype' => $itemtype), false);
}
}
}
// Location
if ($location != 0 && $olditem->isField('locations_id')) {
$olditem->getFromDB($olditem_id);
switch ($location) {
case -1:
break;
default:
$olditem->update(array('id' => $olditem_id, 'locations_id' => $location), false);
break;
}
}
$plug = new Plugin();
if ($plug->isActivated('ocsinventoryng')) {
//Delete computer from OCS
if ($model->fields["remove_from_ocs"] == 1) {
PluginUninstallUninstall::deleteComputerInOCSByGlpiID($olditem_id);
}
//Delete link in glpi_ocs_link
if ($model->fields["delete_ocs_link"] || $model->fields["remove_from_ocs"]) {
PluginUninstallUninstall::deleteOcsLink($olditem_id);
}
}
if ($plug->isActivated('fusioninventory')) {
if ($model->fields['raz_fusioninventory']) {
PluginUninstallUninstall::deleteFusionInventoryLink(get_class($olditem), $olditem_id);
}
}
// METHOD REPLACEMENT 1 : Purge
if ($model->fields['replace_method'] == self::METHOD_PURGE) {
// Retrieve, Compute && Update NEW comment field
$comment = self::getCommentsForReplacement($olditem, true);
$comment .= "\n- " . __('See attached document', 'uninstall');
$newitem->update(array('id' => $newitem_id, 'comment' => addslashes($comment)), false);
// If old item is attached in PDF/CSV
// Delete AND Purge it in DB
if ($document_added) {
$olditem->delete(array('id' => $olditem_id), true);
}
}
// METHOD REPLACEMENT 2 : Delete AND Comment
if ($model->fields['replace_method'] == self::METHOD_DELETE_AND_COMMENT) {
//Add comment on the new item first
$comment = self::getCommentsForReplacement($olditem, true);
$newitem->update(array('id' => $newitem_id, 'comment' => Toolbox::addslashes_deep($comment)), false);
// Retrieve, Compute && Update OLD comment field
$comment = self::getCommentsForReplacement($newitem, false);
$olditem->update(array('id' => $olditem_id, 'comment' => Toolbox::addslashes_deep($comment)), false);
// Delete OLD item from DB (not PURGE)
PluginUninstallUninstall::addUninstallLog($type, $olditem_id, 'replaced_by');
$olditem->delete(array('id' => $olditem_id), 0, false);
}
//Plugin hook after replacement
Plugin::doHook("plugin_uninstall_replace_after", $olditem);
//Add history
PluginUninstallUninstall::addUninstallLog($type, $newitem_id, 'replace');
Html::changeProgressBarPosition($count, $tot + 1);
}
Html::changeProgressBarPosition($count, $tot, __('Replacement successful', 'uninstall'));
echo "</td></tr>";
echo "</table></div>";
}
/** Generate bigdump : add contracts to an item
*
* @param $type item type
* @param $ID item ID
**/
function addContracts($type, $ID) {
global $CONTRACT_PER_ITEM, $DB, $FIRST, $LAST;
$nb = mt_rand(0, $CONTRACT_PER_ITEM);
$con = array();
for ($i=0 ; $i<$nb ; $i++) {
$con[] = mt_rand($FIRST["contract"], $LAST["contract"]);
}
$con = array_unique($con);
$ci = new Contract_Item();
foreach ($con as $val) {
$ci->add(array('contracts_id' => $val,
'itemtype' => $type,
'items_id' => $ID));
}
}
This file is part of GLPI.
GLPI is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
GLPI is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with GLPI. If not, see <http://www.gnu.org/licenses/>.
--------------------------------------------------------------------------
*/
/** @file
* @brief
* @since version 0.84
*/
include '../inc/includes.php';
Session::checkCentralAccess();
$contract_item = new Contract_Item();
if (isset($_POST["add"])) {
$contract_item->check(-1, 'w', $_POST);
if ($contract_item->add($_POST)) {
Event::log($_POST["contracts_id"], "contracts", 4, "financial", sprintf(__('%s adds a link with an item'), $_SESSION["glpiname"]));
}
Html::back();
}
Html::displayErrorAndDie("lost");
}
}
break;
case "add_contact":
if ($_POST["itemtype"] == 'Supplier') {
$contactsupplier = new Contact_Supplier();
foreach ($_POST["item"] as $key => $val) {
$input = array('suppliers_id' => $key, 'contacts_id' => $_POST['conID']);
if ($contactsupplier->can(-1, 'w', $input)) {
$contactsupplier->add($input);
}
}
}
break;
case "add_contract":
$contractitem = new Contract_Item();
foreach ($_POST["item"] as $key => $val) {
$input = array('itemtype' => $_POST["itemtype"], 'items_id' => $key, 'contracts_id' => $_POST['contracts_id']);
if ($contractitem->can(-1, 'w', $input)) {
$contractitem->add($input);
}
}
break;
case "add_enterprise":
if ($_POST["itemtype"] == 'Contact') {
$contactsupplier = new Contact_Supplier();
foreach ($_POST["item"] as $key => $val) {
$input = array('suppliers_id' => $_POST['entID'], 'contacts_id' => $key);
if ($contactsupplier->can(-1, 'w', $input)) {
$contactsupplier->add($input);
}
function post_addItem()
{
global $DB, $CFG_GLPI;
// Manage add from template
if (isset($this->input["_oldID"])) {
// ADD Infocoms
// $ic = new Infocom();
// $ic->cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
Infocom::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
//test 0.84.3
Contract_Item::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
// ADD Contract
// $query = "SELECT `contracts_id`
// FROM `glpi_contracts_items`
// WHERE `items_id` = '".$this->input["_oldID"]."'
// AND `itemtype` = '".$this->getType()."'";
// $result = $DB->query($query);
// if ($DB->numrows($result)>0) {
// $contractitem = new Contract_Item();
// while ($data=$DB->fetch_array($result)) {
// $contractitem->add(array('contracts_id' => $data["contracts_id"],
// 'itemtype' => $this->getType(),
// 'items_id' => $this->fields['id']));
// }
//}
// ADD Documents
// $query = "SELECT `documents_id`
// FROM `glpi_documents_items`
// WHERE `items_id` = '".$this->input["_oldID"]."'
// AND `itemtype` = '".$this->getType()."'";
// $result = $DB->query($query);
//
// if ($DB->numrows($result)>0) {
// $docitem = new Document_Item();
//
// while ($data=$DB->fetch_array($result)) {
// $docitem->add(array('documents_id' => $data["documents_id"],
// 'itemtype' => $this->getType(),
// 'items_id' => $this->fields['id']));
Document_Item::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
// }
// }
}
if (isset($this->input['_itemtype']) && isset($this->input['_items_id'])) {
$simcard_item = new PluginSimcardSimcard_Item();
$tmp['plugin_simcard_simcards_id'] = $this->getID();
$tmp['itemtype'] = $this->input['_itemtype'];
$tmp['items_id'] = $this->input['_items_id'];
$simcard_item->add($tmp);
}
}
/**
* Clean the date in the relation tables for the deleted item
* Clear N/N Relation
**/
function cleanRelationTable()
{
global $CFG_GLPI, $DB;
// If this type have INFOCOM, clean one associated to purged item
if (in_array($this->getType(), $CFG_GLPI['infocom_types'])) {
$infocom = new Infocom();
if ($infocom->getFromDBforDevice($this->getType(), $this->fields['id'])) {
$infocom->delete(array('id' => $infocom->fields['id']));
}
}
// If this type have NETPORT, clean one associated to purged item
if (in_array($this->getType(), $CFG_GLPI['networkport_types'])) {
$query = "SELECT `id`\n FROM `glpi_networkports`\n WHERE (`items_id` = '" . $this->fields['id'] . "'\n AND `itemtype` = '" . $this->getType() . "')";
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
$q = "DELETE\n FROM `glpi_networkports_networkports`\n WHERE (`networkports_id_1` = '" . $data["id"] . "'\n OR `networkports_id_2` = '" . $data["id"] . "')";
$result2 = $DB->query($q);
}
$query = "DELETE\n FROM `glpi_networkports`\n WHERE (`items_id` = '" . $this->fields['id'] . "'\n AND `itemtype` = '" . $this->getType() . "')";
$result = $DB->query($query);
}
// If this type is RESERVABLE clean one associated to purged item
if (in_array($this->getType(), $CFG_GLPI['reservation_types'])) {
$rr = new ReservationItem();
if ($rr->getFromDBbyItem($this->getType(), $this->fields['id'])) {
$rr->delete(array('id' => $infocom->fields['id']));
}
}
// If this type have CONTRACT, clean one associated to purged item
if (in_array($this->getType(), $CFG_GLPI['contract_types'])) {
$ci = new Contract_Item();
$ci->cleanDBonItemDelete($this->getType(), $this->fields['id']);
}
// If this type have DOCUMENT, clean one associated to purged item
if (in_array($this->getType(), $CFG_GLPI["document_types"])) {
$di = new Document_Item();
$di->cleanDBonItemDelete($this->getType(), $this->fields['id']);
}
}
function post_addItem()
{
global $DB, $CFG_GLPI;
// Manage add from template
if (isset($this->input["_oldID"])) {
// ADD Infocoms
$ic = new Infocom();
$ic->cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
// ADD Ports
$query = "SELECT `id`\n FROM `glpi_networkports`\n WHERE `items_id` = '" . $this->input["_oldID"] . "'\n AND `itemtype` = '" . $this->getType() . "'";
$result = $DB->query($query);
if ($DB->numrows($result) > 0) {
while ($data = $DB->fetch_array($result)) {
$np = new NetworkPort();
$npv = new NetworkPort_Vlan();
$np->getFromDB($data["id"]);
unset($np->fields["id"]);
unset($np->fields["ip"]);
unset($np->fields["mac"]);
unset($np->fields["netpoints_id"]);
$np->fields["items_id"] = $this->fields['id'];
$portid = $np->addToDB();
foreach ($DB->request('glpi_networkports_vlans', array('networkports_id' => $data["id"])) as $vlan) {
$npv->assignVlan($portid, $vlan['vlans_id']);
}
}
}
// ADD Contract
$query = "SELECT `contracts_id`\n FROM `glpi_contracts_items`\n WHERE `items_id` = '" . $this->input["_oldID"] . "'\n AND `itemtype` = '" . $this->getType() . "'";
$result = $DB->query($query);
if ($DB->numrows($result) > 0) {
$contractitem = new Contract_Item();
while ($data = $DB->fetch_array($result)) {
$contractitem->add(array('contracts_id' => $data["contracts_id"], 'itemtype' => $this->getType(), 'items_id' => $this->fields['id']));
}
}
// ADD Documents
$query = "SELECT `documents_id`\n FROM `glpi_documents_items`\n WHERE `items_id` = '" . $this->input["_oldID"] . "'\n AND `itemtype` = '" . $this->getType() . "'";
$result = $DB->query($query);
if ($DB->numrows($result) > 0) {
$docitem = new Document_Item();
while ($data = $DB->fetch_array($result)) {
$docitem->add(array('documents_id' => $data["documents_id"], 'itemtype' => $this->getType(), 'items_id' => $this->fields['id']));
}
}
}
}
You should have received a copy of the GNU General Public License
along with GLPI; if not, write to the Free Software Foundation, Inc.,
51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
--------------------------------------------------------------------------
*/
// ----------------------------------------------------------------------
// Original Author of file: Julien Dombre
// Purpose of file:
// ----------------------------------------------------------------------
define('GLPI_ROOT', '..');
include GLPI_ROOT . "/inc/includes.php";
if (!isset($_GET["id"])) {
$_GET["id"] = -1;
}
$contract = new Contract();
$contractitem = new Contract_Item();
$contractsupplier = new Contract_Supplier();
if (isset($_POST["add"])) {
$contract->check(-1, 'w', $_POST);
if ($newID = $contract->add($_POST)) {
Event::log($newID, "contracts", 4, "financial", $_SESSION["glpiname"] . " " . $LANG['log'][20] . " " . $_POST["num"] . ".");
}
glpi_header($_SERVER['HTTP_REFERER']);
} else {
if (isset($_POST["delete"])) {
$contract->check($_POST['id'], 'w');
if ($contract->delete($_POST)) {
Event::log($_POST["id"], "contracts", 4, "financial", $_SESSION["glpiname"] . " " . $LANG['log'][22]);
}
$contract->redirectToList();
} else {
/**
* Clean the date in the relation tables for the deleted item
* Clear N/N Relation
**/
function cleanRelationTable()
{
global $CFG_GLPI, $DB;
// If this type have INFOCOM, clean one associated to purged item
if (Infocom::canApplyOn($this)) {
$infocom = new Infocom();
if ($infocom->getFromDBforDevice($this->getType(), $this->fields['id'])) {
$infocom->delete(array('id' => $infocom->fields['id']));
}
}
// If this type have NETPORT, clean one associated to purged item
if (in_array($this->getType(), $CFG_GLPI['networkport_types'])) {
// If we don't use delete, then cleanDBonPurge() is not call and the NetworkPorts are not
// clean properly
$networkPortObject = new NetworkPort();
$networkPortObject->cleanDBonItemDelete($this->getType(), $this->getID());
// Manage networkportmigration if exists
if (TableExists('glpi_networkportmigrations')) {
$networkPortMigObject = new NetworkPortMigration();
$networkPortMigObject->cleanDBonItemDelete($this->getType(), $this->getID());
}
}
// If this type is RESERVABLE clean one associated to purged item
if (in_array($this->getType(), $CFG_GLPI['reservation_types'])) {
$rr = new ReservationItem();
if ($rr->getFromDBbyItem($this->getType(), $this->fields['id'])) {
$rr->delete(array('id' => $infocom->fields['id']));
}
}
// If this type have CONTRACT, clean one associated to purged item
if (in_array($this->getType(), $CFG_GLPI['contract_types'])) {
$ci = new Contract_Item();
$ci->cleanDBonItemDelete($this->getType(), $this->fields['id']);
}
// If this type have DOCUMENT, clean one associated to purged item
if (Document::canApplyOn($this)) {
$di = new Document_Item();
$di->cleanDBonItemDelete($this->getType(), $this->fields['id']);
}
// If this type have NOTEPAD, clean one associated to purged item
if ($this->usenotepad) {
$note = new Notepad();
$note->cleanDBonItemDelete($this->getType(), $this->fields['id']);
}
}
function post_addItem()
{
global $DB, $CFG_GLPI;
// Manage add from template
if (isset($this->input["_oldID"])) {
Infocom::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
Contract_Item::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
Document_Item::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
}
if (isset($this->input['_itemtype']) && isset($this->input['_items_id'])) {
$simcard_item = new PluginSimcardSimcard_Item();
$tmp['plugin_simcard_simcards_id'] = $this->getID();
$tmp['itemtype'] = $this->input['_itemtype'];
$tmp['items_id'] = $this->input['_items_id'];
$simcard_item->add($tmp);
}
}
/**
* Do the standard massive actions
*
* @since version 0.84
*
* This must not be overloaded in Class
* @param $input array of input datas
*
* @return an array of results (ok, ko, noright counts, may include REDIRECT field to set REDIRECT page)
**/
function doMassiveActions($input = array())
{
global $CFG_GLPI;
if (!isset($input["item"]) || count($input["item"]) == 0) {
return false;
}
$res = array('ok' => 0, 'ko' => 0, 'noright' => 0);
switch ($input['action']) {
case 'add_document':
case 'remove_document':
$doc = new Document();
return $doc->doSpecificMassiveActions($input);
case "add_transfer_list":
if (!isset($_SESSION['glpitransfer_list'])) {
$_SESSION['glpitransfer_list'] = array();
}
if (!isset($_SESSION['glpitransfer_list'][$input["itemtype"]])) {
$_SESSION['glpitransfer_list'][$input["itemtype"]] = array();
}
foreach ($input["item"] as $key => $val) {
if ($val == 1) {
$_SESSION['glpitransfer_list'][$input["itemtype"]][$key] = $key;
$res['ok']++;
}
}
$res['REDIRECT'] = $CFG_GLPI['root_doc'] . '/front/transfer.action.php';
break;
case "delete":
foreach ($input["item"] as $key => $val) {
if ($val == 1) {
if ($this->can($key, 'd')) {
if ($this->delete(array("id" => $key))) {
$res['ok']++;
} else {
$res['ko']++;
}
} else {
$res['noright']++;
}
}
}
break;
case "purge":
foreach ($input["item"] as $key => $val) {
if ($val == 1) {
if ($this->can($key, 'd')) {
$force = 1;
// Only mark deletion for
if ($this->maybeDeleted() && $this->useDeletedToLockIfDynamic() && $this->isDynamic()) {
$force = 0;
}
if ($this->delete(array("id" => $key), $force)) {
$res['ok']++;
} else {
$res['ko']++;
}
} else {
$res['noright']++;
}
}
}
break;
case "restore":
foreach ($input["item"] as $key => $val) {
if ($val == 1) {
if ($this->can($key, 'd')) {
if ($this->restore(array("id" => $key))) {
$res['ok']++;
} else {
$res['ko']++;
}
} else {
$res['noright']++;
}
}
}
break;
case "update":
$searchopt = Search::getCleanedOptions($input["itemtype"], 'w');
if (isset($searchopt[$input["id_field"]])) {
/// Infocoms case
if (!isPluginItemType($input["itemtype"]) && Search::isInfocomOption($input["itemtype"], $input["id_field"])) {
$ic = new Infocom();
$link_entity_type = -1;
/// Specific entity item
if ($searchopt[$input["id_field"]]["table"] == "glpi_suppliers") {
$ent = new Supplier();
if ($ent->getFromDB($input[$input["field"]])) {
$link_entity_type = $ent->fields["entities_id"];
}
}
foreach ($input["item"] as $key => $val) {
if ($val == 1) {
if ($this->getFromDB($key)) {
if ($link_entity_type < 0 || $link_entity_type == $this->getEntityID() || $ent->fields["is_recursive"] && in_array($link_entity_type, getAncestorsOf("glpi_entities", $this->getEntityID()))) {
$input2["items_id"] = $key;
$input2["itemtype"] = $input["itemtype"];
if ($ic->can(-1, 'w', $input2)) {
// Add infocom if not exists
if (!$ic->getFromDBforDevice($input["itemtype"], $key)) {
$input2["items_id"] = $key;
$input2["itemtype"] = $input["itemtype"];
unset($ic->fields);
$ic->add($input2);
$ic->getFromDBforDevice($input["itemtype"], $key);
}
$id = $ic->fields["id"];
unset($ic->fields);
if ($ic->update(array('id' => $id, $input["field"] => $input[$input["field"]]))) {
$res['ok']++;
} else {
$res['ko']++;
}
} else {
$res['noright']++;
}
} else {
$res['ko']++;
}
} else {
$res['ko']++;
}
}
}
} else {
/// Not infocoms
$link_entity_type = array();
/// Specific entity item
$itemtable = getTableForItemType($input["itemtype"]);
$itemtype2 = getItemTypeForTable($searchopt[$input["id_field"]]["table"]);
if ($item2 = getItemForItemtype($itemtype2)) {
if ($input["id_field"] != 80 && $searchopt[$input["id_field"]]["table"] != $itemtable && $item2->isEntityAssign() && $this->isEntityAssign()) {
if ($item2->getFromDB($input[$input["field"]])) {
if (isset($item2->fields["entities_id"]) && $item2->fields["entities_id"] >= 0) {
if (isset($item2->fields["is_recursive"]) && $item2->fields["is_recursive"]) {
$link_entity_type = getSonsOf("glpi_entities", $item2->fields["entities_id"]);
} else {
$link_entity_type[] = $item2->fields["entities_id"];
}
}
}
}
}
foreach ($input["item"] as $key => $val) {
if ($val == 1) {
if ($this->can($key, 'w') && $this->canMassiveAction($input['action'], $input['field'], $input[$input["field"]])) {
if (count($link_entity_type) == 0 || in_array($this->fields["entities_id"], $link_entity_type)) {
if ($this->update(array('id' => $key, $input["field"] => $input[$input["field"]]))) {
$res['ok']++;
} else {
$res['ko']++;
}
} else {
$res['ko']++;
}
} else {
$res['noright']++;
}
}
}
}
}
break;
case "activate_infocoms":
$ic = new Infocom();
if ($ic->canCreate()) {
foreach ($input["item"] as $key => $val) {
$input = array('itemtype' => $input['itemtype'], 'items_id' => $key);
if (!$ic->getFromDBforDevice($input['itemtype'], $key)) {
if ($ic->can(-1, 'w', $input)) {
if ($ic->add($input)) {
$res['ok']++;
} else {
$res['ko']++;
}
} else {
$res['noright']++;
}
} else {
$res['ko']++;
}
}
}
break;
case "add_contract_item":
$contractitem = new Contract_Item();
foreach ($input["item"] as $key => $val) {
if (isset($input['items_id'])) {
// Add items to contracts
$input = array('itemtype' => $input["item_itemtype"], 'items_id' => $input["items_id"], 'contracts_id' => $key);
}
if (isset($input['contracts_id'])) {
// Add contract to item
$input = array('itemtype' => $input["itemtype"], 'items_id' => $key, 'contracts_id' => $input['contracts_id']);
} else {
return false;
}
if ($contractitem->can(-1, 'w', $input)) {
if ($contractitem->add($input)) {
$res['ok']++;
} else {
$res['ko']++;
}
} else {
$res['noright']++;
}
}
break;
case "remove_contract_item":
foreach ($input["item"] as $key => $val) {
if (isset($input['items_id'])) {
// Remove item to contracts
$input = array('itemtype' => $input["item_itemtype"], 'items_id' => $input["items_id"], 'contracts_id' => $key);
} else {
// Remove contract to items
$input = array('itemtype' => $input["itemtype"], 'items_id' => $key, 'contracts_id' => $input['contracts_id']);
}
$contractitem = new Contract_Item();
if ($contractitem->can(-1, 'w', $input)) {
if ($item = getItemForItemtype($input["itemtype"])) {
if ($item->getFromDB($input['items_id'])) {
$contract = new Contract();
if ($contract->getFromDB($input['contracts_id'])) {
if ($contractitem->getFromDBForItems($contract, $item)) {
if ($contractitem->delete(array('id' => $contractitem->getID()))) {
$res['ok']++;
} else {
$res['ko']++;
}
} else {
$res['ko']++;
}
} else {
$res['ko']++;
}
} else {
$res['ko']++;
}
} else {
$res['ko']++;
}
} else {
$res['noright']++;
}
}
break;
//Lock management
//Lock management
case 'unlock_Printer':
case 'unlock_Monitor':
case 'unlock_NetworkPort':
case 'unlock_NetworkName':
case 'unlock_IPAddress':
case 'unlock_ComputerDisk':
case 'unlock_ComputerVirtualMachine':
case 'unlock_Peripheral':
case 'unlock_SoftwareVersion':
$itemtype = Lock::getItemTypeForMassiveAction($input["action"]);
if ($itemtype) {
$res = Lock::unlockItems($itemtype, $this->getType(), $input["item"]);
}
break;
case 'unlock_Device':
foreach (Item_Devices::getDeviceTypes() as $itemtype) {
$res = Lock::unlockItems($itemtype, $this->getType(), $input["item"]);
}
break;
default:
// Plugin specific actions
$split = explode('_', $input["action"]);
$res = '';
if ($split[0] == 'plugin' && isset($split[1])) {
// Normalized name plugin_name_action
// Allow hook from any plugin on any (core or plugin) type
$res = Plugin::doOneHook($split[1], 'MassiveActionsProcess', $input);
// } else if ($plug=isPluginItemType($input["itemtype"])) {
// non-normalized name
// hook from the plugin defining the type
// $res = Plugin::doOneHook($plug['plugin'], 'MassiveActionsProcess', $input);
} else {
$res = $this->doSpecificMassiveActions($input);
}
break;
}
return $res;
}
function post_addItem()
{
global $DB, $CFG_GLPI;
// Manage add from template
if (isset($this->input["_oldID"])) {
// ADD Infocoms
$ic = new Infocom();
$ic->cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
// ADD Contract
$query = "SELECT `contracts_id`\n FROM `glpi_contracts_items`\n WHERE `items_id` = '" . $this->input["_oldID"] . "'\n AND `itemtype` = '" . $this->getType() . "'";
$result = $DB->query($query);
if ($DB->numrows($result) > 0) {
$contractitem = new Contract_Item();
while ($data = $DB->fetch_array($result)) {
$contractitem->add(array('contracts_id' => $data["contracts_id"], 'itemtype' => $this->getType(), 'items_id' => $this->fields['id']));
}
}
// ADD Documents
$query = "SELECT `documents_id`\n FROM `glpi_documents_items`\n WHERE `items_id` = '" . $this->input["_oldID"] . "'\n AND `itemtype` = '" . $this->getType() . "'";
$result = $DB->query($query);
if ($DB->numrows($result) > 0) {
$docitem = new Document_Item();
while ($data = $DB->fetch_array($result)) {
$docitem->add(array('documents_id' => $data["documents_id"], 'itemtype' => $this->getType(), 'items_id' => $this->fields['id']));
}
}
}
}
function post_addItem()
{
global $DB;
// Manage add from template
if (isset($this->input["_oldID"])) {
// ADD Devices
Item_devices::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
// ADD Infocoms
Infocom::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
// ADD volumes
ComputerDisk::cloneComputer($this->input["_oldID"], $this->fields['id']);
// ADD software
Computer_SoftwareVersion::cloneComputer($this->input["_oldID"], $this->fields['id']);
Computer_SoftwareLicense::cloneComputer($this->input["_oldID"], $this->fields['id']);
// ADD Contract
Contract_Item::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
// ADD Documents
Document_Item::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
// ADD Ports
NetworkPort::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
// Add connected devices
Computer_Item::cloneComputer($this->input["_oldID"], $this->fields['id']);
}
}
function post_addItem()
{
global $DB, $CFG_GLPI;
// Manage add from template
if (isset($this->input["_oldID"])) {
// ADD Devices
Item_devices::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
// ADD Infocoms
Infocom::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
// ADD Ports
NetworkPort::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
// ADD Contract
Contract_Item::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
// ADD Documents
Document_Item::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
// ADD Computers
Computer_Item::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
}
}
function post_addItem()
{
global $CFG_GLPI;
$projet_projet = new PluginProjetProjet_Projet();
// From interface
if (isset($this->input['_link'])) {
$this->input['_link']['plugin_projet_projets_id_1'] = $this->fields['id'];
// message if projet doesn't exist
if (!empty($this->input['_link']['plugin_projet_projets_id_2'])) {
if ($projet_projet->can(-1, 'w', $this->input['_link'])) {
$projet_projet->add($this->input['_link']);
} else {
Session::addMessageAfterRedirect(__('Unknown project', 'projet'), false, ERROR);
}
}
}
// Manage add from template
if (isset($this->input["_oldID"])) {
//add parent
PluginProjetProjet_Projet::cloneItem($this->input["_oldID"], $this->fields['id']);
// ADD Documents
Document_Item::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
// ADD Contracts
Contract_Item::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
// ADD items
PluginProjetProjet_Item::cloneItem($this->input["_oldID"], $this->fields['id']);
// ADD tasks
PluginProjetTask::cloneItem($this->input["_oldID"], $this->fields['id']);
}
if (isset($this->input['withtemplate']) && $this->input["withtemplate"] != 1 && isset($this->input['send_notification']) && $this->input['send_notification'] == 1) {
if ($CFG_GLPI["use_mailing"]) {
NotificationEvent::raiseEvent("new", $this);
}
}
}