function getTabNameForItem(CommonGLPI $item, $withtemplate = 0)
{
if (in_array($item->getType(), self::getTypes(true)) && plugin_manufacturersimports_haveRight('manufacturersimports', 'r') && !isset($withtemplate) || empty($withtemplate)) {
$suppliername = self::checkManufacturerName($item->getType(), $item->getID());
if ($suppliername) {
return PluginManufacturersimportsPreImport::getTypeName(2);
}
}
return '';
}
function plugin_init_manufacturersimports()
{
global $PLUGIN_HOOKS, $CFG_GLPI;
$PLUGIN_HOOKS['csrf_compliant']['manufacturersimports'] = true;
$PLUGIN_HOOKS['change_profile']['manufacturersimports'] = array('PluginManufacturersimportsProfile', 'changeProfile');
//Clean Plugin on Profile delete
$PLUGIN_HOOKS['pre_item_purge']['manufacturersimports'] = array('Profile' => array('PluginManufacturersimportsProfile', 'purgeProfiles'));
if (Session::getLoginUserID()) {
Plugin::registerClass('PluginManufacturersimportsProfile', array('addtabon' => 'Profile'));
if (plugin_manufacturersimports_haveRight("manufacturersimports", "r")) {
$PLUGIN_HOOKS['menu_entry']['manufacturersimports'] = 'front/import.php';
$PLUGIN_HOOKS['submenu_entry']['manufacturersimports']['config'] = 'front/config.php';
$PLUGIN_HOOKS['add_css']['manufacturersimports'] = "manufacturersimports.css";
$PLUGIN_HOOKS['use_massive_action']['manufacturersimports'] = 1;
}
if (plugin_manufacturersimports_haveRight("manufacturersimports", "w") || Session::haveRight("config", "w")) {
$PLUGIN_HOOKS['config_page']['manufacturersimports'] = 'front/config.php';
$PLUGIN_HOOKS['submenu_entry']['manufacturersimports']['options']['config']['links']['search'] = '/plugins/manufacturersimports/front/config.php';
$PLUGIN_HOOKS['submenu_entry']['manufacturersimports']['options']['config']['links']['add'] = '/plugins/manufacturersimports/front/config.form.php';
}
// End init, when all types are registered
$PLUGIN_HOOKS['post_init']['manufacturersimports'] = 'plugin_manufacturersimports_postinit';
}
}
/**
* Prints the model add form (into devices)
*
* @param $device the device ID
* @param $type the device type
* @return nothing (print out a table)
*
*/
static function showForm($itemtype, $items_id)
{
global $DB, $CFG_GLPI;
$canedit = plugin_manufacturersimports_haveRight('manufacturersimports', 'w');
$query = "SELECT *\n FROM `glpi_plugin_manufacturersimports_models`\n WHERE `itemtype` = '" . $itemtype . "'\n AND `items_id` = '" . $items_id . "'";
$result = $DB->query($query);
$number = $DB->numrows($result);
echo "<form method='post' action=\"" . $CFG_GLPI["root_doc"] . "/plugins/manufacturersimports/front/config.form.php\">";
echo "<div align=\"center\"><table class=\"tab_cadre_fixe\" cellspacing=\"2\" cellpadding=\"2\">";
echo "<tr>";
echo "<th>" . PluginManufacturersimportsPreImport::getTypeName(2) . "</th>";
echo "<th>" . __('Model Number', 'manufacturersimports') . "</th>";
echo "</tr>";
if ($number == 1) {
while ($line = $DB->fetch_array($result)) {
$ID = $line["id"];
echo "<tr class='tab_bg_2'>";
echo "<td class='left'>";
echo "<input type='text' name='model_name' size='30' value='" . $line["model_name"] . "'>";
echo "</td>";
if ($canedit) {
echo "<td class='center' class='tab_bg_2'>";
Html::showSimpleForm($CFG_GLPI['root_doc'] . '/plugins/manufacturersimports/front/config.form.php', 'delete_model', _x('button', 'Delete permanently'), array('id' => $ID));
echo "</td>";
} else {
echo "<td>";
echo "</td>";
}
echo "</tr>";
}
} else {
if ($canedit) {
echo "<tr>";
echo "<th colspan='2'>";
echo "<input type='text' name='model_name' size='30'>";
echo "<input type='hidden' name='items_id' value='" . $items_id . "'>";
echo "<input type='hidden' name='itemtype' value='" . $itemtype . "'>";
echo "<input type=\"submit\" name=\"update_model\" class=\"submit\" value='" . _sx('button', 'Save') . "' >";
echo "</th></tr>";
}
}
echo "</table></div>";
Html::closeForm();
}
/**
* Prints display pre import
*
* @param $type the type of device
* @param $configID the ID of the supplier config
* @param $start for pager display
* @param $complete to see all device (already imported and not)
* @return nothing (print out a table)
*
*/
static function seePreImport($params)
{
global $DB, $CFG_GLPI;
// Default values of parameters
$p['link'] = array();
//
$p['field'] = array();
//
$p['contains'] = array();
//
$p['searchtype'] = array();
//*/
$p['sort'] = '1';
//
$p['order'] = 'ASC';
//
$p['start'] = 0;
//
$p['export_all'] = 0;
$p['link2'] = '';
//
$p['contains2'] = '';
//
$p['field2'] = '';
//
$p['itemtype2'] = '';
$p['searchtype2'] = '';
$p['itemtype'] = '';
$p['manufacturers_id'] = '';
$p['imported'] = '';
foreach ($params as $key => $val) {
$p[$key] = $val;
}
$globallinkto = Search::getArrayUrlLink("field", $p['field']) . Search::getArrayUrlLink("link", $p['link']) . Search::getArrayUrlLink("contains", $p['contains']) . Search::getArrayUrlLink("searchtype", $p['searchtype']) . Search::getArrayUrlLink("field2", $p['field2']) . Search::getArrayUrlLink("contains2", $p['contains2']) . Search::getArrayUrlLink("searchtype2", $p['searchtype2']) . Search::getArrayUrlLink("itemtype2", $p['itemtype2']) . Search::getArrayUrlLink("link2", $p['link2']);
$modeltable = "";
$target = $CFG_GLPI["root_doc"] . "/plugins/manufacturersimports/front/import.php";
if ($p['itemtype'] && $p['manufacturers_id']) {
$config = new PluginManufacturersimportsConfig();
$config->GetFromDB($p['manufacturers_id']);
$suppliername = $config->fields["name"];
$supplierclass = "PluginManufacturersimports" . $suppliername;
$supplier = new $supplierclass();
$infocom = new Infocom();
$canedit = plugin_manufacturersimports_haveRight("manufacturersimports", "w") && $infocom->canUpdate();
if (!$p['start']) {
$p['start'] = 0;
}
$modeltable = getTableForItemType($p['itemtype'] . "Model");
$modelfield = getForeignKeyFieldForTable(getTableForItemType($p['itemtype'] . "Model"));
$item = new $p['itemtype']();
$itemtable = getTableForItemType($p['itemtype']);
$query = "SELECT `" . $itemtable . "`.`id`,\n `" . $itemtable . "`.`name`, \n `" . $itemtable . "`.`serial`,\n `" . $itemtable . "`.`entities_id`,\n `glpi_plugin_manufacturersimports_logs`.`import_status`,\n `glpi_plugin_manufacturersimports_logs`.`items_id`,\n `glpi_plugin_manufacturersimports_logs`.`itemtype`, \n `glpi_plugin_manufacturersimports_logs`.`documents_id`,\n `glpi_plugin_manufacturersimports_logs`.`date_import`, \n '" . $p['itemtype'] . "' AS type,\n `{$modeltable}`.`name` AS model_name\n FROM `" . $itemtable . "` ";
//model device left join
$query .= "LEFT JOIN `{$modeltable}` ON (`{$modeltable}`.`id` = `" . $itemtable . "`.`" . $modelfield . "`) ";
$query .= " LEFT JOIN `glpi_entities` ON (`glpi_entities`.`id` = `" . $itemtable . "`.`entities_id`)";
$query .= " LEFT JOIN `glpi_plugin_manufacturersimports_configs` \n ON (`glpi_plugin_manufacturersimports_configs`.`manufacturers_id` = `" . $itemtable . "`.`manufacturers_id`)";
$query .= " LEFT JOIN `glpi_plugin_manufacturersimports_logs` \n ON (`glpi_plugin_manufacturersimports_logs`.`items_id` = `" . $itemtable . "`.`id` \n AND `glpi_plugin_manufacturersimports_logs`.`itemtype` = '" . $p['itemtype'] . "')";
$query .= " LEFT JOIN `glpi_plugin_manufacturersimports_models` \n ON (`glpi_plugin_manufacturersimports_models`.`items_id` = `" . $itemtable . "`.`id` \n AND `glpi_plugin_manufacturersimports_models`.`itemtype` = '" . $p['itemtype'] . "')";
//serial must be not empty
$query .= " WHERE `" . $itemtable . "`.`is_deleted` = '0'\n AND `" . $itemtable . "`.`is_template` = '0'\n AND `glpi_plugin_manufacturersimports_configs`.`id` = '" . $p['manufacturers_id'] . "'\n AND `" . $itemtable . "`.`serial` != '' ";
//already imported
if ($p['imported'] == self::IMPORTED) {
$query .= " AND `import_status` != " . self::IMPORTED . "";
//not imported
} else {
if ($p['imported'] == self::NOT_IMPORTED) {
$query .= " AND (`date_import` IS NULL OR `import_status` = " . self::IMPORTED . " ";
$query .= ") ";
}
}
$entities = "";
if ($config->isRecursive()) {
$entities = getSonsOf('glpi_entities', $config->getEntityID());
} else {
$entities = $config->getEntityID();
}
$query .= "" . getEntitiesRestrictRequest(" AND", $itemtable, '', '', $item->maybeRecursive());
//// 4 - ORDER
$ORDER = " ORDER BY `entities_id`,`" . $itemtable . "`.`name` ";
$toview = array("name" => 1);
foreach ($toview as $key => $val) {
if ($p['sort'] == $val) {
$ORDER = self::addOrderBy($p['itemtype'], $p['sort'], $p['order'], $key);
}
}
$query .= $ORDER;
$result = $DB->query($query);
$numrows = $DB->numrows($result);
if ($p['start'] < $numrows) {
// Set display type for export if define
$output_type = Search::HTML_OUTPUT;
if (isset($_GET["display_type"])) {
$output_type = $_GET["display_type"];
}
$parameters = "itemtype=" . $p['itemtype'] . "&manufacturers_id=" . $p['manufacturers_id'] . "&imported=" . $p['imported'];
$total = 0;
if ($output_type == Search::HTML_OUTPUT) {
self::printPager($p['start'], $numrows, $target, $parameters, $p['itemtype']);
}
// Define begin and end var for loop
// Search case
$begin_display = $p['start'];
$end_display = $p['start'] + $_SESSION["glpilist_limit"];
// Export All case
if (isset($_GET['export_all'])) {
$begin_display = 0;
$end_display = $numrows;
}
if (Session::isMultiEntitiesMode()) {
$colsup = 1;
} else {
$colsup = 0;
}
//////////////////////HEADER///////////////
if ($output_type == Search::HTML_OUTPUT) {
echo "<form method='post' name='massiveaction_form' id='massiveaction_form' action=\"../ajax/massiveaction.php\">";
}
//echo Search::displaySearchHeader($output_type,0); //table + div
if ($canedit) {
$nbcols = 11 + $colsup;
} else {
$nbcols = 10 + $colsup;
}
$LIST_LIMIT = $_SESSION['glpilist_limit'];
$begin_display = $p['start'];
$end_display = $p['start'] + $LIST_LIMIT;
foreach ($toview as $key => $val) {
$linkto = '';
if (!isset($searchopt["PluginManufacturersimportsPreImport"][$val]['nosort']) || !$searchopt["PluginManufacturersimportsPreImport"][$val]['nosort']) {
$linkto = "{$target}?itemtype=" . $p['itemtype'] . "&manufacturers_id=" . $p['manufacturers_id'] . "&imported=" . $p['imported'] . "&sort=" . $val . "&order=" . ($p['order'] == "ASC" ? "DESC" : "ASC") . "&start=" . $p['start'] . $globallinkto;
}
}
echo Search::showHeader($output_type, $end_display - $begin_display + 1, $nbcols);
echo Search::showNewLine($output_type);
$header_num = 1;
echo Search::showHeaderItem($output_type, "", $header_num);
echo Search::showHeaderItem($output_type, __('Name'), $header_num, $linkto, $p['sort'] == $val, $p['order']);
if (Session::isMultiEntitiesMode()) {
echo Search::showHeaderItem($output_type, __('Entity'), $header_num);
}
echo Search::showHeaderItem($output_type, __('Entity'), $header_num);
echo $supplier->showItemTitle($output_type, $header_num);
echo Search::showHeaderItem($output_type, __('Financial and administrative information'), $header_num);
echo Search::showHeaderItem($output_type, __('Supplier attached', 'manufacturersimports'), $header_num);
echo Search::showHeaderItem($output_type, __('New warranty attached', 'manufacturersimports'), $header_num);
echo Search::showHeaderItem($output_type, _n('Link', 'Links', 1), $header_num);
echo Search::showHeaderItem($output_type, _n('Status', 'Statuses', 1), $header_num);
echo $supplier->showDocTitle($output_type, $header_num);
// End Line for column headers
echo Search::showEndLine($output_type);
$i = $p['start'];
if (isset($_GET['export_all'])) {
$i = 0;
}
if ($i > 0) {
$DB->data_seek($result, $i);
}
$row_num = 1;
while ($i < $numrows && $i < $end_display) {
$i++;
$item_num = 1;
$line = $DB->fetch_array($result);
$compSerial = $line['serial'];
$compId = $line['id'];
$model = $line["model_name"];
if (!$line["itemtype"]) {
$line["itemtype"] = $p['itemtype'];
}
self::showImport($row_num, $item_num, $line, $output_type, $p['manufacturers_id'], $line["import_status"], $p['imported']);
//1.show already imported items && import_status not failed
if ($p['imported'] == 1) {
$total += 1;
}
}
echo "<tr class='tab_bg_1'><td colspan='" . ($canedit ? 11 + $colsup : 10 + $colsup) . "'>";
echo sprintf(__('Total number of devices to import %s', 'manufacturersimports'), $total);
echo "</td></tr>";
// Close Table
$title = "";
// Create title
if ($output_type == Search::PDF_OUTPUT_PORTRAIT || $output_type == Search::PDF_OUTPUT_LANDSCAPE) {
$title .= PluginManufacturersimportsPreImport::getTypeName(2) . " " . $suppliername;
}
echo Search::showFooter($output_type, $title);
//massive action
if ($canedit && $output_type == Search::HTML_OUTPUT) {
Html::openArrowMassives("massiveaction_form", false);
self::dropdownMassiveAction($compId, $p['itemtype'], $p['manufacturers_id'], $p['start'], $p['imported']);
Html::closeArrowMassives(array());
Html::closeForm();
} else {
echo "</table>";
echo "</div>";
}
echo "<br>";
if ($output_type == Search::HTML_OUTPUT) {
self::printPager($p['start'], $numrows, $target, $parameters, $p['itemtype']);
}
} else {
echo "<div align='center'><b>" . __('No device finded', 'manufacturersimports') . "</b></div>";
}
}
}
function plugin_manufacturersimports_getAddSearchOptions($itemtype)
{
$sopt = array();
if (in_array($itemtype, PluginManufacturersimportsConfig::getTypes())) {
if (plugin_manufacturersimports_haveRight("manufacturersimports", "r")) {
$sopt[2150]['table'] = 'glpi_plugin_manufacturersimports_models';
$sopt[2150]['field'] = 'model_name';
$sopt[2150]['linkfield'] = '';
$sopt[2150]['name'] = _n('Suppliers import', 'Suppliers imports', 2, 'manufacturersimports') . " - " . __('Model number', 'manufacturersimports');
$sopt[2150]['forcegroupby'] = true;
$sopt[2150]['joinparams'] = array('jointype' => 'itemtype_item');
$sopt[2150]['massiveaction'] = false;
}
}
return $sopt;
}
