1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 230: 231: 232: 233: 234: 235: 236: 237: 238: 239: 240: 241: 242: 243: 244: 245: 246: 247: 248: 249: 250: 251: 252: 253: 254: 255: 256: 257: 258: 259: 260: 261: 262: 263: 264: 265: 266: 267: 268: 269: 270: 271: 272: 273: 274: 275: 276: 277: 278: 279: 280: 281: 282: 283: 284: 285: 286: 287: 288: 289: 290: 291: 292: 293: 294: 295: 296: 297: 298: 299: 300: 301: 302: 303: 304: 305: 306: 307: 308: 309: 310: 311: 312: 313: 314: 315: 316: 317: 318: 319: 320: 321: 322: 323: 324: 325: 326: 327: 328: 329: 330: 331: 332: 333: 334: 335: 336: 337: 338: 339: 340: 341: 342: 343: 344: 345: 346: 347: 348: 349: 350: 351: 352: 353: 354: 355: 356: 357: 358: 359: 360: 361: 362: 363: 364: 365: 366: 367: 368: 369: 370: 371: 372: 373: 374: 375: 376: 377: 378: 379: 380: 381: 382: 383: 384: 385: 386: 387: 388: 389: 390: 391: 392: 393: 394: 395: 396: 397: 398: 399: 400: 401: 402: 403: 404: 405: 406: 407: 408: 409: 410: 411: 412: 413: 414: 415: 416: 417: 418: 419: 420: 421: 422: 423: 424: 425: 426: 427: 428: 429: 430: 431: 432: 433: 434: 435: 436: 437: 438: 439: 440: 441: 442: 443: 444: 445: 446: 447: 448: 449: 450: 451: 452: 453: 454: 455: 456: 457: 458: 459: 460: 461: 462: 463: 464: 465: 466: 467: 468: 469: 470: 471: 472: 473: 474: 475: 476: 477: 478: 479: 480: 481: 482: 483: 484: 485: 486: 487: 488: 489: 490: 491: 492: 493: 494: 495: 496: 497: 498: 499: 500: 501: 502: 503: 504: 505: 506: 507: 508: 509: 510: 511: 512: 513: 514: 515: 516: 517: 518: 519: 520: 521: 522: 523: 524: 525: 526: 527: 528: 529: 530: 531: 532: 533: 534: 535: 536: 537: 538: 539: 540: 541: 542: 543: 544: 545: 546: 547: 548: 549: 550: 551: 552: 553: 554: 555: 556: 557: 558: 559: 560: 561: 562: 563: 564: 565: 566: 567: 568: 569: 570: 571: 572: 573: 574: 575: 576: 577: 578: 579: 580: 581: 582: 583: 584: 585: 586: 587: 588: 589: 590: 591: 592: 593: 594: 595: 596: 597: 598: 599: 600: 601: 602: 603: 604: 605: 606: 607: 608: 609: 610: 611: 612: 613: 614: 615: 616: 617: 618: 619: 620: 621: 622: 623: 624: 625: 626: 627: 628: 629: 630: 631: 632: 633: 634: 635: 636: 637: 638: 639: 640: 641: 642: 643: 644: 645: 646: 647: 648: 649: 650: 651: 652: 653: 654: 655: 656: 657: 658: 659: 660: 661: 662: 663: 664: 665: 666: 667: 668: 669: 670: 671: 672: 673: 674: 675: 676: 677: 678: 679: 680: 681: 682: 683: 684: 685: 686: 687: 688: 689: 690: 691: 692: 693: 694: 695: 696: 697: 698: 699: 700: 701: 702: 703: 704: 705: 706: 707: 708: 709: 710: 711: 712: 713: 714: 715: 716: 717: 718: 719: 720: 721: 722: 723: 724: 725: 726: 727: 728: 729: 730: 731: 732: 733: 734: 735: 736: 737: 738: 739: 740: 741: 742: 743: 744: 745: 746: 747: 748: 749: 750: 751: 752: 753: 754: 755: 756: 757: 758: 759: 760: 761: 762: 763: 764: 765: 766: 767: 768: 769: 770: 771: 772: 773: 774: 775: 776: 777: 778: 779: 780: 781: 782: 783: 784: 785: 786: 787: 788: 789: 790: 791: 792: 793: 794: 795: 796: 797: 798: 799: 800: 801: 802: 803: 804: 805: 806: 807: 808: 809: 810: 811: 812: 813: 814: 815: 816: 817: 818: 819: 820: 821: 822: 823: 824: 825: 826: 827: 828: 829: 830: 831: 832: 833: 834: 835: 836: 837: 838: 839: 840: 841: 842: 843: 844: 845: 846: 847: 848: 849: 850: 851: 852: 853: 854: 855: 856: 857: 858: 859: 860: 861: 862: 863: 864: 865: 866: 867: 868: 869: 870: 871: 872: 873: 874: 875: 876: 877: 878: 879: 880: 881: 882: 883: 884: 885: 886: 887: 888: 889: 890: 891: 892: 893: 894: 895: 896: 897: 898: 899:
<?php
if (!defined('GLPI_ROOT')) {
die("Sorry. You can't access this file directly");
}
abstract class CommonDBChild extends CommonDBConnexity {
static public $itemtype;
static public $items_id;
static public $checkParentRights = self::HAVE_SAME_RIGHT_ON_ITEM;
static public $mustBeAttached = true;
static public $logs_for_parent = true;
static public $log_history_add = Log::HISTORY_ADD_SUBITEM;
static public $log_history_update = Log::HISTORY_UPDATE_SUBITEM;
static public $log_history_delete = Log::HISTORY_DELETE_SUBITEM;
static public $log_history_lock = Log::HISTORY_LOCK_SUBITEM;
static public $log_history_unlock = Log::HISTORY_UNLOCK_SUBITEM;
static function getSQLRequestToSearchForItem($itemtype, $items_id) {
Toolbox::deprecated('Use getSQLCriteriaToSearchForItem');
$fields = ['`'.static::getIndexName().'`'];
$condition_id = "`".static::$items_id."` = '$items_id'";
$fields[] = "`".static::$items_id."` as items_id";
if (preg_match('/^itemtype/', static::$itemtype)) {
$fields[] = "`".static::$itemtype."` AS itemtype";
$condition = "($condition_id AND `".static::$itemtype."` = '$itemtype')";
} else {
$fields[] = "'".static::$itemtype."' AS itemtype";
if (($itemtype == static::$itemtype)
|| is_subclass_of($itemtype, static::$itemtype)) {
$condition = $condition_id;
}
}
if (isset($condition)) {
return "SELECT ".implode(', ', $fields)."
FROM `".static::getTable()."`
WHERE $condition";
}
return '';
}
static function getSQLCriteriaToSearchForItem($itemtype, $items_id) {
$criteria = [
'SELECT' => [
static::getIndexName(),
static::$items_id . ' AS items_id'
],
'FROM' => static::getTable(),
'WHERE' => [
static::$items_id => $items_id
]
];
$request = false;
if (preg_match('/^itemtype/', static::$itemtype)) {
$criteria['SELECT'][] = static::$itemtype . ' AS itemtype';
$criteria['WHERE'][static::$itemtype] = $itemtype;
$request = true;
} else {
$criteria['SELECT'][] = new \QueryExpression("'" . static::$itemtype . "' AS itemtype");
if (($itemtype == static::$itemtype)
|| is_subclass_of($itemtype, static::$itemtype)) {
$request = true;
}
}
if ($request === true) {
return $criteria;
}
return null;
}
static function canCreate() {
if ((static::$rightname) && (!Session::haveRight(static::$rightname, CREATE))) {
return false;
}
return static::canChild('canUpdate');
}
static function canView() {
if ((static::$rightname) && (!Session::haveRight(static::$rightname, READ))) {
return false;
}
return static::canChild('canView');
}
static function canUpdate() {
if ((static::$rightname) && (!Session::haveRight(static::$rightname, UPDATE))) {
return false;
}
return static::canChild('canUpdate');
}
static function canDelete() {
if ((static::$rightname) && (!Session::haveRight(static::$rightname, DELETE))) {
return false;
}
return static::canChild('canUpdate');
}
static function canPurge() {
if ((static::$rightname) && (!Session::haveRight(static::$rightname, PURGE))) {
return false;
}
return static::canChild('canUpdate');
}
function canCreateItem() {
return $this->canChildItem('canUpdateItem', 'canUpdate');
}
function canViewItem() {
return $this->canChildItem('canViewItem', 'canView');
}
function canUpdateItem() {
return $this->canChildItem('canUpdateItem', 'canUpdate');
}
function canDeleteItem() {
return $this->canChildItem('canUpdateItem', 'canUpdate');
}
static function canChild($method) {
return static::canConnexity($method, static::$checkParentRights, static::$itemtype,
static::$items_id);
}
function canChildItem($methodItem, $methodNotItem) {
try {
return static::canConnexityItem($methodItem, $methodNotItem, static::$checkParentRights,
static::$itemtype, static::$items_id);
} catch (CommonDBConnexityItemNotFound $e) {
return !static::$mustBeAttached;
}
}
function getItem($getFromDB = true, $getEmpty = true) {
return $this->getConnexityItem(static::$itemtype, static::$items_id,
$getFromDB, $getEmpty);
}
static function displayRecursiveItems(array $recursiveItems, $elementToDisplay) {
if ((!is_array($recursiveItems)) || (count($recursiveItems) == 0)) {
echo __('Item not linked to an object');
return;
}
switch ($elementToDisplay) {
case 'Type' :
$masterItem = $recursiveItems[count($recursiveItems) - 1];
echo $masterItem->getTypeName(1);
break;
case 'Name' :
case 'Link' :
$items_elements = [];
foreach ($recursiveItems as $item) {
if ($elementToDisplay == 'Name') {
$items_elements[] = $item->getName();
} else {
$items_elements[] = $item->getLink();
}
}
echo implode(' < ', $items_elements);
break;
}
}
function recursivelyGetItems() {
$item = $this->getItem();
if ($item !== false) {
if ($item instanceof CommonDBChild) {
return array_merge([$item], $item->recursivelyGetItems());
}
return [$item];
}
return [];
}
function getEntityID () {
if (parent::isEntityAssign()) {
return parent::getEntityID();
}
$item = $this->getItem();
if (($item !== false) && ($item->isEntityAssign())) {
return $item->getEntityID();
}
return -1;
}
function isEntityAssign() {
if (parent::isEntityAssign()) {
return true;
}
$item = $this->getItem(false);
if ($item !== false) {
return $item->isEntityAssign();
}
return false;
}
function maybeRecursive() {
if (parent::maybeRecursive()) {
return true;
}
$item = $this->getItem(false);
if ($item !== false) {
return $item->maybeRecursive();
}
return false;
}
function isRecursive () {
if (parent::maybeRecursive()) {
return parent::isRecursive();
}
$item = $this->getItem();
if ($item !== false) {
return $item->isRecursive();
}
return false;
}
function addNeededInfoToInput($input) {
if ($this->tryEntityForwarding() && !isset($input['entities_id'])) {
$completeinput = array_merge($this->fields, $input);
if ($itemToGetEntity = static::getItemFromArray(static::$itemtype, static::$items_id,
$completeinput)) {
if (($itemToGetEntity instanceof CommonDBTM)
&& $itemToGetEntity->isEntityForwardTo(get_called_class())) {
$input['entities_id'] = $itemToGetEntity->getEntityID();
$input['is_recursive'] = intval($itemToGetEntity->isRecursive());
} else {
$input['entities_id'] = 0;
$input['is_recursive'] = 0;
}
}
}
return $input;
}
function prepareInputForAdd($input) {
if (!is_array($input)) {
return false;
}
if (static::$mustBeAttached
&& !$this->getItemFromArray(static::$itemtype, static::$items_id, $input)) {
return false;
}
return $this->addNeededInfoToInput($input);
}
function prepareInputForUpdate($input) {
if (!is_array($input)) {
return false;
}
if (!parent::checkAttachedItemChangesAllowed($input, [static::$itemtype,
static::$items_id])) {
return false;
}
return parent::addNeededInfoToInput($input);
}
function getHistoryNameForItem(CommonDBTM $item, $case) {
return $this->getNameID(['forceid' => true,
'additional' => true]);
}
function post_addItem() {
if ((isset($this->input['_no_history']) && $this->input['_no_history'])
|| !static::$logs_for_parent) {
return;
}
$item = $this->getItem();
if (($item !== false)
&& $item->dohistory) {
$changes = [
'0',
'',
$this->getHistoryNameForItem($item, 'add'),
];
Log::history($item->getID(), $item->getType(), $changes, $this->getType(),
static::$log_history_add);
}
}
function post_updateItem($history = 1) {
if ((isset($this->input['_no_history']) && $this->input['_no_history'])
|| !static::$logs_for_parent) {
return;
}
$items_for_log = $this->getItemsForLog(static::$itemtype, static::$items_id);
$oldvalues = $this->oldvalues;
unset($oldvalues[static::$itemtype]);
unset($oldvalues[static::$items_id]);
$item = $items_for_log['new'];
if (($item !== false)
&& $item->dohistory) {
foreach (array_keys($oldvalues) as $field) {
$changes = $this->getHistoryChangeWhenUpdateField($field);
if ((!is_array($changes)) || (count($changes) != 3)) {
continue;
}
Log::history($item->getID(), $item->getType(), $changes, $this->getType(),
static::$log_history_update);
}
}
if (isset($items_for_log['previous'])) {
$prevItem = $items_for_log['previous'];
$newItem = $items_for_log['new'];
if (($prevItem !== false)
&& $prevItem->dohistory) {
$changes[0] = '0';
$changes[1] = addslashes($this->getHistoryNameForItem($prevItem, 'update item previous'));
$changes[2] = '';
Log::history($prevItem->getID(), $prevItem->getType(), $changes, $this->getType(),
static::$log_history_delete);
}
if (($newItem !== false)
&& $newItem->dohistory) {
$changes[0] = '0';
$changes[1] = '';
$changes[2] = addslashes($this->getHistoryNameForItem($newItem, 'update item next'));
Log::history($newItem->getID(), $newItem->getType(), $changes, $this->getType(),
static::$log_history_add);
}
}
}
function post_deleteFromDB() {
if ((isset($this->input['_no_history']) && $this->input['_no_history'])
|| !static::$logs_for_parent) {
return;
}
$item = $this->getItem();
if (($item !== false)
&& $item->dohistory) {
$changes = [
'0',
];
if (static::$log_history_delete == Log::HISTORY_LOG_SIMPLE_MESSAGE) {
$changes[1] = '';
$changes[2] = addslashes($this->getHistoryNameForItem($item, 'delete'));
} else {
$changes[1] = addslashes($this->getHistoryNameForItem($item, 'delete'));
$changes[2] = '';
}
Log::history($item->getID(), $item->getType(), $changes, $this->getType(),
static::$log_history_delete);
}
}
function cleanDBonMarkDeleted() {
if ((isset($this->input['_no_history']) && $this->input['_no_history'])
|| !static::$logs_for_parent) {
return;
}
if ($this->useDeletedToLockIfDynamic()
&& $this->isDynamic()) {
$item = $this->getItem();
if (($item !== false)
&& $item->dohistory) {
$changes = [
'0',
addslashes($this->getHistoryNameForItem($item, 'lock')),
'',
];
Log::history($item->getID(), $item->getType(), $changes, $this->getType(),
static::$log_history_lock);
}
}
}
function post_restoreItem() {
if ((isset($this->input['_no_history']) && $this->input['_no_history'])
|| !static::$logs_for_parent) {
return;
}
if ($this->useDeletedToLockIfDynamic()
&& $this->isDynamic()) {
$item = $this->getItem();
if (($item !== false)
&& $item->dohistory) {
$changes = [
'0',
'',
addslashes($this->getHistoryNameForItem($item, 'unlock')),
];
Log::history($item->getID(), $item->getType(), $changes, $this->getType(),
static::$log_history_unlock);
}
}
}
static function getJSCodeToAddForItemChild($field_name, $child_count_js_var) {
return "<input type=\'text\' size=\'40\' ". "name=\'" . $field_name .
"[-'+$child_count_js_var+']\'>";
}
function showChildForItemForm($canedit, $field_name, $id) {
if ($this->isNewID($this->getID())) {
$value = '';
} else {
$value = $this->getName();
}
$field_name = $field_name."[$id]";
if ($canedit) {
echo "<input type='text' size='40' name='$field_name' value='$value'>";
} else {
echo "<input type='hidden' name='$field_name' value='$value'>$value";
}
}
static function showAddChildButtonForItemForm(CommonDBTM $item, $field_name, $canedit = null,
$display = true) {
$items_id = $item->getID();
if (is_null($canedit)) {
if ($item->isNewItem()) {
if (!$item->canCreate()) {
return false;
}
$canedit = $item->canUpdate();
} else {
if (!$item->can($items_id, READ)) {
return false;
}
$canedit = $item->can($items_id, UPDATE);
}
}
$result = '';
if ($canedit) {
$lower_name = strtolower(get_called_class());
$child_count_js_var = 'nb'.$lower_name.'s';
$div_id = "add_".$lower_name."_to_".$item->getType()."_".$items_id;
$result = " <script type='text/javascript'>var $child_count_js_var=2; </script>";
$result .= "<span id='add".$lower_name."button' class='fa fa-plus pointer'".
" title=\"".__s('Add')."\"" .
"\" onClick=\"var row = ".Html::jsGetElementByID($div_id).";
row.append('<br>" .
static::getJSCodeToAddForItemChild($field_name, $child_count_js_var)."');
$child_count_js_var++;\"
><span class='sr-only'>" . __s('Add') . "</span></span>";
}
if ($display) {
echo $result;
} else {
return $result;
}
}
static function showChildsForItemForm(CommonDBTM $item, $field_name, $canedit = null) {
global $DB;
$items_id = $item->getID();
if (is_null($canedit)) {
if ($item->isNewItem()) {
if (!$item->canCreate()) {
return false;
}
$canedit = $item->canUpdate();
} else {
if (!$item->can($items_id, READ)) {
return false;
}
$canedit = $item->can($items_id, UPDATE);
}
}
$lower_name = strtolower(get_called_class());
$div_id = "add_".$lower_name."_to_".$item->getType()."_".$items_id;
if ($items_id == 0) {
$items_id = -99;
}
$query = [
'FROM' => static::getTable(),
'WHERE' => [
static::$items_id => $item->getID()
]
];
if (preg_match('/^itemtype/', static::$itemtype)) {
$query['WHERE']['itemtype'] = $item->getType();
}
$current_item = new static();
if ($current_item->maybeDeleted()) {
$query['WHERE']['is_deleted'] = 0;
}
$iterator = $DB->request($query);
$count = 0;
while ($data = $iterator->next()) {
$current_item->fields = $data;
if ($count) {
echo '<br>';
}
$count++;
$current_item->showChildForItemForm($canedit, $field_name, $current_item->getID());
}
if ($canedit) {
echo "<div id='$div_id'>";
if ($count == 0) {
$current_item->getEmpty();
$current_item->showChildForItemForm($canedit, $field_name, -1);
}
echo "</div>";
}
}
function affectChild($id, $items_id = 0, $itemtype = '') {
$input = [static::getIndexName() => $id,
static::$items_id => $items_id];
if (preg_match('/^itemtype/', static::$itemtype)) {
$input[static::$itemtype] = $itemtype;
}
return $this->update($input);
}
}