$cartype->check($_POST["id"], 'w');
if ($cartype->delete($_POST, 1)) {
Event::log($_POST["id"], "cartridges", 4, "inventory", $_SESSION["glpiname"] . " " . $LANG['log'][24]);
}
$cartype->redirectToList();
} else {
if (isset($_POST["update"])) {
$cartype->check($_POST["id"], 'w');
if ($cartype->update($_POST)) {
Event::log($_POST["id"], "cartridges", 4, "inventory", $_SESSION["glpiname"] . " " . $LANG['log'][21]);
}
glpi_header($_SERVER['HTTP_REFERER']);
} else {
if (isset($_POST["addtype"])) {
$cartype->check($_POST["tID"], 'w');
if ($cartype->addCompatibleType($_POST["tID"], $_POST["printermodels_id"])) {
Event::log($_POST["tID"], "cartridges", 4, "inventory", $_SESSION["glpiname"] . " " . $LANG['log'][30]);
}
glpi_header($_SERVER['HTTP_REFERER']);
} else {
if (isset($_GET["deletetype"])) {
$cartype->check($_GET["tID"], 'w');
if ($cartype->deleteCompatibleType($_GET["id"])) {
Event::log($_GET["tID"], "cartridges", 4, "inventory", $_SESSION["glpiname"] . " " . $LANG['log'][31]);
}
glpi_header($_SERVER['HTTP_REFERER']);
} else {
commonHeader($LANG['Menu'][21], $_SERVER['PHP_SELF'], "inventory", "cartridge");
$cartype->showForm($_GET["id"]);
commonFooter();
}
/**
* Transfer compatible printers for a cartridge type
*
* @param $ID original ID of the cartridge type
* @param $newID new ID of the cartridge type
**/
function transferCompatiblePrinters($ID, $newID)
{
global $DB;
if ($ID != $newID) {
$query = "SELECT *\n FROM `glpi_cartridgeitems_printermodels`\n WHERE `cartridgeitems_id` = '{$ID}'";
if ($result = $DB->query($query)) {
if ($DB->numrows($result) != 0) {
$cartitem = new CartridgeItem();
while ($data = $DB->fetch_array($result)) {
$data = addslashes_deep($data);
$cartitem->addCompatibleType($newID, $data["printermodels_id"]);
}
}
}
}
}
/**
* Replay collection rules on an existing DB for model dropdowns
*
* @param $offset offset used to begin (default 0)
* @param $maxtime maximum time of process (reload at the end) (default 0)
*
* @return -1 on completion else current offset
**/
function replayRulesOnExistingDBForModel($offset = 0, $maxtime = 0)
{
global $DB;
if (isCommandLine()) {
printf(__('Replay rules on existing database started on %s') . "\n", date("r"));
}
// Model check : need to check using manufacturer extra data
if (strpos($this->item_table, 'models') === false) {
_e('Error replaying rules');
return false;
}
$model_table = getPlural(str_replace('models', '', $this->item_table));
$model_field = getForeignKeyFieldForTable($this->item_table);
// Need to give manufacturer from item table
$Sql = "SELECT DISTINCT `glpi_manufacturers`.`id` AS idmanu,\n `glpi_manufacturers`.`name` AS manufacturer,\n `" . $this->item_table . "`.`id`,\n `" . $this->item_table . "`.`name` AS name,\n `" . $this->item_table . "`.`comment`\n FROM `" . $this->item_table . "`,\n `{$model_table}`\n LEFT JOIN `glpi_manufacturers`\n ON (`{$model_table}`.`manufacturers_id` = `glpi_manufacturers`.`id`)\n WHERE `{$model_table}`.`{$model_field}` = `" . $this->item_table . "`.`id`";
if ($offset) {
$Sql .= " LIMIT " . intval($offset) . ",999999999";
}
$result = $DB->query($Sql);
$nb = $DB->numrows($result) + $offset;
$i = $offset;
if ($result && $nb > $offset) {
// Step to refresh progressbar
$step = $nb > 20 ? floor($nb / 20) : 1;
$tocheck = array();
while ($data = $DB->fetch_assoc($result)) {
if (!($i % $step)) {
if (isCommandLine()) {
printf(__('Replay rules on existing database: %1$s/%2$s') . "\r", $i, $nb);
} else {
Html::changeProgressBarPosition($i, $nb, "{$i} / {$nb}");
}
}
// Model case
if (isset($data["manufacturer"])) {
$data["manufacturer"] = Manufacturer::processName(addslashes($data["manufacturer"]));
}
//Replay Type dictionnary
$ID = Dropdown::importExternal(getItemTypeForTable($this->item_table), addslashes($data["name"]), -1, $data, addslashes($data["comment"]));
if ($data['id'] != $ID) {
$tocheck[$data["id"]][] = $ID;
$sql = "UPDATE `{$model_table}`\n SET `{$model_field}` = '{$ID}'\n WHERE `{$model_field}` = '" . $data['id'] . "'";
if (empty($data['idmanu'])) {
$sql .= " AND (`manufacturers_id` IS NULL\n OR `manufacturers_id` = '0')";
} else {
$sql .= " AND `manufacturers_id` = '" . $data['idmanu'] . "'";
}
$DB->query($sql);
}
$i++;
if ($maxtime) {
$crt = explode(" ", microtime());
if ($crt[0] + $crt[1] > $maxtime) {
break;
}
}
}
foreach ($tocheck as $ID => $tab) {
$sql = "SELECT COUNT(*)\n FROM `{$model_table}`\n WHERE `{$model_field}` = '{$ID}'";
$result = $DB->query($sql);
$deletecartmodel = false;
// No item left : delete old item
if ($result && $DB->result($result, 0, 0) == 0) {
$Sql = "DELETE\n FROM `" . $this->item_table . "`\n WHERE `id` = '{$ID}'";
$resdel = $DB->query($Sql);
$deletecartmodel = true;
}
// Manage cartridge assoc Update items
if ($this->getRuleClassName() == 'RuleDictionnaryPrinterModel') {
$sql = "SELECT *\n FROM `glpi_cartridgeitems_printermodels`\n WHERE `printermodels_id` = '{$ID}'";
if ($result = $DB->query($sql)) {
if ($DB->numrows($result)) {
// Get compatible cartridge type
$carttype = array();
while ($data = $DB->fetch_assoc($result)) {
$carttype[] = $data['cartridgeitems_id'];
}
// Delete cartrodges_assoc
if ($deletecartmodel) {
$sql = "DELETE\n FROM `glpi_cartridgeitems_printermodels`\n WHERE `printermodels_id` = 'id'";
$DB->query($sql);
}
// Add new assoc
$ct = new CartridgeItem();
foreach ($carttype as $cartID) {
foreach ($tab as $model) {
$ct->addCompatibleType($cartID, $model);
}
}
}
}
}
}
// each tocheck
}
if (isCommandLine()) {
printf(__('Replay rules on existing database ended on %s') . "\n", date("r"));
} else {
Html::changeProgressBarPosition($i, $nb, "{$i} / {$nb}");
}
return $i == $nb ? -1 : $i;
}
