public function indexAction()
{
$view = new MainView();
$modelOrder = new OrderModel();
$model = new PhoneModel();
$phones = $model->getPhones();
return $this->_controller->setPage($view->showMain(['count' => $modelOrder->getCount(), 'phones' => $phones]));
}
/**
* Print the phone form
*
* @param $ID integer ID of the item
* @param $options array
* - target filename : where to go when done.
* - withtemplate boolean : template or basic item
*
* @return boolean item found
**/
function showForm($ID, $options = array())
{
global $CFG_GLPI;
$target = $this->getFormURL();
$withtemplate = $this->initForm($ID, $options);
$this->showFormHeader($options);
echo "<tr class='tab_bg_1'>";
//TRANS: %1$s is a string, %2$s a second one without spaces between them : to change for RTL
echo "<td>" . sprintf(__('%1$s%2$s'), __('Name'), isset($options['withtemplate']) && $options['withtemplate'] ? "*" : "") . "</td>";
echo "<td>";
$objectName = autoName($this->fields["name"], "name", isset($options['withtemplate']) && $options['withtemplate'] == 2, $this->getType(), $this->fields["entities_id"]);
Html::autocompletionTextField($this, 'name', array('value' => $objectName));
echo "</td>";
echo "<td>" . __('Status') . "</td>";
echo "<td>";
State::dropdown(array('value' => $this->fields["states_id"], 'entity' => $this->fields["entities_id"], 'condition' => "`is_visible_phone`='1'"));
echo "</td></tr>\n";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Location') . "</td>";
echo "<td>";
Location::dropdown(array('value' => $this->fields["locations_id"], 'entity' => $this->fields["entities_id"]));
echo "</td>";
echo "<td>" . __('Type') . "</td>";
echo "<td>";
PhoneType::dropdown(array('value' => $this->fields["phonetypes_id"]));
echo "</td></tr>\n";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Technician in charge of the hardware') . "</td>";
echo "<td>";
User::dropdown(array('name' => 'users_id_tech', 'value' => $this->fields["users_id_tech"], 'right' => 'own_ticket', 'entity' => $this->fields["entities_id"]));
echo "</td>";
echo "<td>" . __('Manufacturer') . "</td>";
echo "<td>";
Manufacturer::dropdown(array('value' => $this->fields["manufacturers_id"]));
echo "</td></tr>\n";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Group in charge of the hardware') . "</td>";
echo "<td>";
Group::dropdown(array('name' => 'groups_id_tech', 'value' => $this->fields['groups_id_tech'], 'entity' => $this->fields['entities_id'], 'condition' => '`is_assign`'));
echo "</td>";
echo "<td>" . __('Model') . "</td>";
echo "<td>";
PhoneModel::dropdown(array('value' => $this->fields["phonemodels_id"]));
echo "</td></tr>\n";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Alternate username number') . "</td>";
echo "<td>";
Html::autocompletionTextField($this, "contact_num");
echo "</td>";
echo "<td>" . __('Serial number') . "</td>";
echo "<td>";
Html::autocompletionTextField($this, "serial");
echo "</td></tr>\n";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Alternate username') . "</td><td>";
Html::autocompletionTextField($this, "contact");
echo "</td>";
echo "<td>" . sprintf(__('%1$s%2$s'), __('Inventory number'), isset($options['withtemplate']) && $options['withtemplate'] ? "*" : "") . "</td>";
echo "<td>";
$objectName = autoName($this->fields["otherserial"], "otherserial", isset($options['withtemplate']) && $options['withtemplate'] == 2, $this->getType(), $this->fields["entities_id"]);
Html::autocompletionTextField($this, 'otherserial', array('value' => $objectName));
echo "</td></tr>\n";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('User') . "</td>";
echo "<td>";
User::dropdown(array('value' => $this->fields["users_id"], 'entity' => $this->fields["entities_id"], 'right' => 'all'));
echo "</td>";
echo "<td>" . __('Management type') . "</td>";
echo "<td>";
Dropdown::showGlobalSwitch($this->fields["id"], array('withtemplate' => $withtemplate, 'value' => $this->fields["is_global"], 'management_restrict' => $CFG_GLPI["phones_management_restrict"], 'target' => $target));
echo "</td></tr>\n";
// Display auto inventory informations
$rowspan = 7;
$inventory_show = false;
if (!empty($ID) && $this->fields["is_dynamic"]) {
$inventory_show = true;
$rowspan -= 2;
}
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Group') . "</td>";
echo "<td>";
Group::dropdown(array('value' => $this->fields["groups_id"], 'entity' => $this->fields["entities_id"], 'condition' => '`is_itemgroup`'));
echo "</td>";
echo "<td rowspan='{$rowspan}'>" . __('Comments') . "</td>";
echo "<td rowspan='{$rowspan}'>\n <textarea cols='45' rows='" . ($rowspan + 3) . "' name='comment' class='form-control' >" . $this->fields["comment"];
echo "</textarea></td></tr>\n";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Brand') . "</td>";
echo "<td>";
Html::autocompletionTextField($this, "brand");
echo "</td></tr>\n";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Power supply') . "</td>";
echo "<td>";
PhonePowerSupply::dropdown(array('value' => $this->fields["phonepowersupplies_id"]));
echo "</td></tr>\n";
echo "<tr class='tab_bg_1'>";
echo "<td>" . _n('Firmware', 'Firmwares', 1) . "</td>";
echo "<td>";
Html::autocompletionTextField($this, "firmware");
echo "</td></tr>\n";
echo "<tr class='tab_bg_1'>";
echo "<td>" . _x('quantity', 'Number of lines') . "</td><td>";
Html::autocompletionTextField($this, "number_line");
echo "</td></tr>\n";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Flags') . "</td>";
echo "<td>";
// micro?
echo "\n<table><tr><td>" . __('Headset') . "</td>";
echo "<td> ";
Dropdown::showYesNo("have_headset", $this->fields["have_headset"]);
echo "</td></tr>";
// hp?
echo "<tr><td>" . __('Speaker') . "</td>";
echo "<td> ";
Dropdown::showYesNo("have_hp", $this->fields["have_hp"]);
echo "</td></tr></table>\n";
echo "</td>";
if ($inventory_show) {
echo "<td rowspan='2'>" . __('Automatic inventory') . "</td>";
echo "<td rowspan='2'>";
Plugin::doHook("autoinventory_information", $this);
echo "</td>";
}
echo "</tr>\n";
echo "<tr class='tab_bg_1'>";
echo "<td>";
if ((!isset($options['withtemplate']) || $options['withtemplate'] == 0) && !empty($this->fields['template_name'])) {
echo "<span class='small_space'>";
printf(__('Created from the template %s'), $this->fields['template_name']);
echo "</span>";
} else {
echo " ";
}
echo "</td><td>";
if (isset($options['withtemplate']) && $options['withtemplate']) {
//TRANS: %s is the datetime of insertion
printf(__('Created on %s'), Html::convDateTime($_SESSION["glpi_currenttime"]));
} else {
//TRANS: %s is the datetime of insertion
printf(__('Last update on %s'), Html::convDateTime($this->fields["date_mod"]));
}
echo "</td></tr>\n";
$this->showFormButtons($options);
return true;
}
/** Generate bigdump : generate global dropdowns
**/
function generateGlobalDropdowns() {
global $MAX, $DB;
$items = array("CD", "CD-RW", "DVD-R", "DVD+R", "DVD-RW", "DVD+RW", "ramette papier",
"disk'ette", "ZIP");
$dp = new ConsumableItemType();
for ($i=0 ; $i<$MAX['consumable_type'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "type d' consommable $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment $val")));
}
$items = array("phone d'power");
$dp = new PhonePowerSupply();
for ($i=0 ; $i<$MAX['phone_power'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "power ' $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment $val")));
}
$items = array("Grand", "Moyen", "Mic'ro", "1U", "5U");
$dp = new DeviceCaseType();
for ($i=0 ; $i<$MAX['case_type'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "power ' $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment $val")));
}
$items = array("Laser", "Jet d'Encre", "Encre Solide");
$dp = new CartridgeItemType();
for ($i=0 ; $i<$MAX['cartridge_type'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "type d' cartouche $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment $val")));
}
$items = array("Technicien", "Commercial", "Technico-Commercial", "President", "Secretaire",
"Directeur d'agence");
$dp = new ContactType();
for ($i=0 ; $i<$MAX['contact_type'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "type d' contact $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment $val")));
}
$items = array("Maintenance", "Support", "Location", "Adhesion");
$dp = new ContractType();
for ($i=0 ; $i<$MAX['contract_type'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "type d' crontact $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment $val")));
}
$items = array("Fournisseur", "Transporteur", "SSII", "Revendeur d'", "Assembleur", "SSLL",
"Financeur", "Assureur");
$dp = new SupplierType();
for ($i=0 ; $i<$MAX['enttype'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "type d'entreprise $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment $val")));
}
$items = array("H.07.02", "I.07.56", "P51", "P52", "1.60", "4.06", "43-4071299", "1.0.14",
"3.0.1", "rev 1.0", "rev 1.1", "rev 1.2", "rev 1.2.1", "rev 2.0", "rev 3.0");
$dp = new NetworkEquipmentFirmware();
for ($i=0 ; $i<$MAX['firmware'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "firmware $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment '$val")));
}
$items = array("Fire'wire");
$dp = new InterfaceType();
for ($i=0 ; $i<$MAX['interface'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "type d' disque dur $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment $val")));
}
$items = array("100 Base TX", "100 Base T4", "10 base T", "1000 Base SX", "1000 Base LX",
"1000 Base T", "ATM", "802.3 10 Base 2", "IEEE 803.3 10 Base 5");
$dp = new NetworkInterface();
for ($i=0 ; $i<$MAX['iface'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "type carte reseau $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment '$val")));
}
$items = array("Non", "Oui - generique", "Oui - specifique d'entite");
$dp = new AutoUpdateSystem();
for ($i=0 ; $i<$MAX['auto_update'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "type de mise a jour '$i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment $val")));
}
$items = array("Assemble", "Latitude C600", "Latitude C700", "VAIO FX601", "VAIO FX905P",
"VAIO TR5MP", "L5000C", "A600K", "PowerBook G4");
$dp = new ComputerModel();
for ($i=0 ; $i<$MAX['model'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "Modele $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment' $val")));
}
$items = array("4200 DTN", "4200 DN", "4200 N", "8400 ADP", "7300 ADP", "5550 DN",
"PIXMA iP8500", "Stylus Color 3000", "DeskJet 5950");
$dp = new PrinterModel();
for ($i=0 ; $i<$MAX['model_printers'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "modele imprimante $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment '$val")));
}
$items = array("LS902UTG", "MA203DT", "P97F+SB", "G220F", "10-30-75", "PLE438S-B0S",
"PLE481S-W", "L1740BQ", "L1920P", "SDM-X73H");
$dp = new MonitorModel();
for ($i=0 ; $i<$MAX['model_monitors'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "modele moniteur $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment '$val")));
}
$items = array("HP 4108GL", "HP 2524", "HP 5308", "7600", "Catalyst 4500", "Catalyst 2950",
"Catalyst 3750", "Catalyst 6500");
$dp = new NetworkEquipmentModel();
for ($i=0 ; $i<$MAX['model_networking'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "modele materiel reseau $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment '$val")));
}
$items = array("DCS-2100+", "DCS-2100G", "KD-P35B", "Optical 5000", "Cordless", "ASR 600",
"ASR 375", "CS21", "MX5020", "VS4121", "T3030", "T6060");
$dp = new PeripheralModel();
for ($i=0 ; $i<$MAX['model_peripherals'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "modele peripherique $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment '$val")));
}
$items = array("Alcatel Temporis 22", "Aastra 5370ip", "Alcatel-Lucent 400 DECT Handset",
"BlackBerry Curve 9300");
$dp = new PhoneModel();
for ($i=0 ; $i<$MAX['model_phones'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "modele phone $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment' $val")));
}
$items = array("SIC", "LMS", "LMP", "LEA", "SP2MI", "STIC", "MATH", "ENS-MECA", "POUBELLE",
"WIFI");
$dp = new Network();
for ($i=0 ; $i<$MAX['network'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "reseau $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment '$val")));
}
$items = array("Windows XP Pro SP2", "Linux (Debian)", "Mac OS X", "Linux (Mandriva 2006)",
"Linux (Redhat)", "Windows 98", "Windows 2000", "Windows XP Pro SP1",
"LINUX (Suse)", "Linux (Mandriva 10.2)");
$dp = new OperatingSystem();
for ($i=0 ; $i<$MAX['os'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "os $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment '$val")));
}
$items = array("XP Pro", "XP Home", "10.0", "10.1", "10.2", "2006", "Sarge");
$dp = new operatingSystemVersion();
for ($i=0 ; $i<$MAX['os_version'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "osversion $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment '$val")));
}
$items = array("Service Pack 1", "Service Pack 2", "Service Pack 3", "Service Pack 4");
$dp = new OperatingSystemServicePack();
for ($i=0 ; $i<$MAX['os_sp'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "ossp $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment '$val")));
}
$items = array("DDR2");
$dp = new DeviceMemoryType();
for ($i=0 ; $i<$MAX['ram_type'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "type de ram $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment' $val")));
}
$items = array('Bureautique', 'Calcul', "logiciel d'antivirus", 'Multimédia');
$dp = new SoftwareCategory();
for ($i=0 ; $i<max(1,pow($MAX['softwarecategory'],1/2)) ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "category $i";
}
$newID = $dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment $val")));
for ($j=0 ; $j<mt_rand(0,pow($MAX['softwarecategory'],1/2)) ; $j++) {
$newID2 = $dp->add(toolbox::addslashes_deep(array('name' => "s-category '$j",
'comment' => "comment d' $val s-category $j",
'softwarecategories_id'
=> $newID)));
}
}
$MAX['rubdocs'] = getMaxItem('glpi_softwarecategories');
$dp = new SoftwareLicenseType();
for ($i=0 ; $i<$MAX['licensetype'] ; $i++) {
$val = "type ' $i";
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment '$val")));
}
$items = array("SIC", "LMS", "LMP", "LEA", "SP2MI", "STIC", "MATH", "ENS-MECA", "POUBELLE",
"WIFI");
$dp = new Vlan();
for ($i=0 ; $i<$MAX['vlan'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "VLAN $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment '$val",
'tag' => $i)));
}
$items = array("Portable", "Desktop", "Tour");
$dp = new ComputerType();
for ($i=0 ; $i<$MAX['type_computers'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "type ordinateur $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment '$val")));
}
$items = array("Laser A4", "Jet d'Encre", "Laser A3", "Encre Solide A4", "Encre Solide A3");
$dp = new PrinterType();
for ($i=0 ; $i<$MAX['type_printers'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "type d'imprimante $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment $val")));
}
$items = array("TFT 17", "TFT 19", "TFT 21", "CRT 17", "CRT 19", "CRT 21", "CRT 15");
$dp = new MonitorType();
for ($i=0 ; $i<$MAX['type_monitors'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "type ecran $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment '$val")));
}
$items = array("Switch", "Routeur", "Hub", "Borne Wifi", "borne d'accueil");
$dp = new NetworkEquipmentType();
for ($i=0 ; $i<$MAX['type_networking'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "type de materiel reseau '$i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment $val")));
}
$items = array("Clavier", "Souris", "Webcam", "Enceintes", "Scanner", "Clef USB", "d'autres");
$dp = new PeripheralType();
for ($i=0 ; $i<$MAX['type_peripherals'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "type de peripheriques '$i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment $val")));
}
$items = array("Analogique", "IP", );
$dp = new PhoneType();
for ($i=0 ; $i<$MAX['type_phones'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "type de phone $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment '$val")));
}
$items = array("DELL", "HP", "IIYAMA", "CANON", "EPSON", "LEXMARK", "ASUS", "MSI");
$dp = new Manufacturer();
for ($i=0 ; $i<$MAX['manufacturer'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "manufacturer $i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment '$val")));
}
$items = array("Ingénieur", "Stagiaire", "Secrétaire", "ouvrier d'atelier");
$dp = new UserCategory();
for ($i=0 ; $i<$MAX['user_type'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "user type d'$i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment $val")));
}
$items = array("Président", "Agent Comptable", "Directeur d'agence");
$dp = new UserTitle();
for ($i=0 ; $i<$MAX['user_title'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "user type '$i";
}
$dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment $val")));
}
$items = array("Documentation", "Facture", "Bon Livraison", "Bon commande", "Capture d'Ecran",
"Dossier Technique");
$dp = new DocumentCategory();
for ($i=0 ; $i<max(1,pow($MAX['rubdocs'],1/2)) ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "category $i";
}
$newID = $dp->add(toolbox::addslashes_deep(array('name' => $val,
'comment' => "comment $val")));
for ($j=0 ; $j<mt_rand(0,pow($MAX['rubdocs'],1/2)) ; $j++) {
$newID2 = $dp->add(toolbox::addslashes_deep(
array('name' => "s-category '$j",
'comment' => "comment d' $val s-category $j",
'documentcategories_id' => $newID)));
}
}
$MAX['rubdocs'] = getMaxItem('glpi_documentcategories');
$dp = new ItilCategory();
// GLobal ticket categories : also specific ones by entity
for ($i=0 ; $i<max(1,pow($MAX['tracking_category'],1/3)) ; $i++) {
$newID = $dp->add(toolbox::addslashes_deep(
array('name' => "category '$i",
'comment' => "comment ' category $i",
'is_recursive' => 1,
'tickettemplates_id_incident' => 1,
'tickettemplates_id_demand' => 1)));
for ($j=0 ; $j<mt_rand(0,pow($MAX['tracking_category'],1/2)) ; $j++) {
$newID2 = $dp->add(toolbox::addslashes_deep(
array('name' => "s-category '$j",
'comment' => "comment 'category $i s-category $j",
'is_recursive' => 1,
'tickettemplates_id_incident' => 1,
'tickettemplates_id_demand' => 1,
'itilcategories_id' => $newID)));
for ($k=0 ; $k<mt_rand(0,pow($MAX['tracking_category'],1/2)) ; $k++) {
$newID3 = $dp->add(toolbox::addslashes_deep(
array('name' => "ss-category' $k",
'comment' => "comment ' category $i s-category $j ss-category $k",
'is_recursive' => 1,
'tickettemplates_id_incident' => 1,
'tickettemplates_id_demand' => 1,
'itilcategories_id' => $newID2)));
}
}
}
$query = "OPTIMIZE TABLE `glpi_itilcategories`";
$DB->query($query) or die("PB REQUETE ".$query);
regenerateTreeCompleteName("glpi_itilcategories");
$MAX['tracking_category'] = getMaxItem('glpi_itilcategories');
// DEVICE
$items = array("Textorm 6A19", "ARIA", "SLK3000B-EU", "Sonata II", "TA-212", "TA-551", "TA-581",
"TAC-T01", "CS-512", "Li PC-60891", "STT-TJ02S");
$dp = new DeviceCase();
for ($i=0 ; $i<$MAX['device'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "case $i";
}
$dp->add(toolbox::addslashes_deep(
array('designation' => $val,
'is_recursive' => 1,
'comment' => "comment '$val",
'devicecasetypes_id' => mt_rand(0,$MAX["case_type"]),
'manufacturers_id' => mt_rand(1,$MAX['manufacturer']))));
}
$items = array("Escalade 8006-2LP", "Escalade 8506-4LP", "2810SA", "1210SA", "DuoConnect",
"DU-420", "DUB-A2", "FastTrak SX4100B", "DC-395U", "TFU-H33PI");
$dp = new DeviceControl();
for ($i=0 ; $i<$MAX['device'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "control $i";
}
$dp->add(toolbox::addslashes_deep(
array('designation' => $val,
'is_recursive' => 1,
'comment' => "comment ' $val",
'interfacetypes_id' => mt_rand(0,$MAX["interface"]),
'manufacturers_id' => mt_rand(1,$MAX['manufacturer']))));
}
$items = array("DUW1616", "DRW-1608P", "DW1625", "GSA-4160B", "GSA-4165B", "GSA-4167RBB",
"SHW-16H5S", "SOHW-1673SX", "DVR-110D", "PX-716AL", "PX-755A");
$dp = new DeviceDrive();
for ($i=0 ; $i<$MAX['device'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "drive $i";
}
$dp->add(toolbox::addslashes_deep(
array('designation' => $val,
'is_recursive' => 1,
'comment' => "comment '$val",
'is_writer' => mt_rand(0,1),
'speed' => mt_rand(0,60),
'interfacetypes_id' => mt_rand(0,$MAX["interface"]),
'manufacturers_id' => mt_rand(1,$MAX['manufacturer']))));
}
$items = array("A9250/TD", "AX550/TD", "Extreme N5900", "V9520-X/TD", "All-In-Wonder X800 GT",
"GV-NX66256D", "GV-RX80256DE", "Excalibur 9600XT", "X1300 IceQ",
"WinFast PX6200 TD", "Millenium 750","NX6600GT");
$dp = new DeviceGraphicCard();
for ($i=0 ; $i<$MAX['device'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "gfxcard $i";
}
$dp->add(toolbox::addslashes_deep(
array('designation' => $val,
'is_recursive' => 1,
'comment' => "comment ' $val",
'interfacetypes_id' => mt_rand(0,$MAX["interface"]),
'manufacturers_id' => mt_rand(1,$MAX['manufacturer']),
'memory_default' => 256*mt_rand(0,8))));
}
$items = array("Deskstar 7K500", "Deskstar T7K250", "Atlas 15K II", "DiamondMax Plus",
"SpinPoint P - SP2514N", "Barracuda 7200.9", "WD2500JS", "WD1600JB", "WD1200JD");
$dp = new DeviceHardDrive();
for ($i=0 ; $i<$MAX['device'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "hdd $i";
}
$dp->add(toolbox::addslashes_deep(
array('designation' => $val,
'is_recursive' => 1,
'comment' => "comment' $val",
'interfacetypes_id' => mt_rand(0,$MAX["interface"]),
'manufacturers_id' => mt_rand(1,$MAX['manufacturer']),
'capacity_default' => mt_rand(0,300),
'rpm' => mt_rand(0,15000),
'cache' => 51200*mt_rand(0,10))));
}
$items = array("DFE-530TX", "DFE-538TX", "PWLA8492MF", "PWLA8492MT", "USBVPN1", "GA311", "FA511",
"TEG-PCBUSR", "3C996-SX", "3C996B-T", "3C905C-TX-M");
$dp = new DeviceNetworkCard();
for ($i=0 ; $i<$MAX['device'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "iface $i";
}
$dp->add(toolbox::addslashes_deep(
array('designation' => $val,
'is_recursive' => 1,
'comment' => "comment' $val",
'manufacturers_id' => mt_rand(1,$MAX['manufacturer']),
'bandwidth' => mt_rand(0,1000))));
}
$items = array("AW8-MAX", "NV8", "AK86-L", "P4V88", "A8N-SLI", "A8N-VM", "K8V-MX", "K8N4-E",
"P5LD2", "GA-K8NE", "GA-8I945P Pro", "D945PBLL", "SE7525GP2", "865PE Neo3-F",
"K8N Neo4-F", "Thunder i7520 (S5360G2NR)", "Thunder K8SR - S2881UG2NR",
"Tiger K8QS Pro - S4882UG2NR", "Tomcat i875PF (S5105G2NR)");
$dp = new DeviceMotherBoard();
for ($i=0 ; $i<$MAX['device'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "moboard $i";
}
$dp->add(toolbox::addslashes_deep(
array('designation' => $val,
'is_recursive' => 1,
'comment' => "comment' $val",
'manufacturers_id' => mt_rand(1,$MAX['manufacturer']),
'chipset' => 'chipset '.mt_rand(0,1000))));
}
$items = array("Instant TV Cardbus", "WinTV Express", "WinTV-NOVA-S-Plus", "WinTV-NOVA-T",
"WinTV-PVR-150");
$dp = new DevicePci();
for ($i=0 ; $i<$MAX['device'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "pci $i";
}
$dp->add(toolbox::addslashes_deep(
array('designation' => $val,
'is_recursive' => 1,
'comment' => "comment '$val",
'manufacturers_id' => mt_rand(1,$MAX['manufacturer']))));
}
$items = array("DB-Killer PW335", "DB-Killer PW385", "NeoHE 380", "NeoHE 450", "Phantom 500-PEC",
"TruePower 2.0 550", "Master RS-380", "EG375AX-VE-G-SFMA", "EG495AX");
$dp = new DevicePowerSupply();
for ($i=0 ; $i<$MAX['device'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "power $i";
}
$dp->add(toolbox::addslashes_deep(
array('designation' => $val,
'is_recursive' => 1,
'comment' => "comment '$val",
'manufacturers_id' => mt_rand(1,$MAX['manufacturer']),
'power' => mt_rand(0,500).'W',
'is_atx' => mt_rand(0,1))));
}
$items = array("Athlon 64 FX-57", "Athlon 64 FX-55", "Sempron 2400+", "Sempron 2600+",
"Celeron D 325", "Celeron D 330J", "Pentium 4 530J", "Pentium 4 631",
"Pentium D 830", "Pentium D 920");
$dp = new DeviceProcessor();
for ($i=0 ; $i<$MAX['device'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "processor $i";
}
$dp->add(toolbox::addslashes_deep(
array('designation' => $val,
'is_recursive' => 1,
'comment' => "comment' $val",
'manufacturers_id' => mt_rand(1,$MAX['manufacturer']),
'frequence' => mt_rand(1000,3000),
'frequency_default' => 1000+200*mt_rand(0,10),
'nbcores_default' => mt_rand(1,8),
'nbthreads_default' => mt_rand(1,4),
)));
}
$items = array("CM2X256A-5400C4", "CMX1024-3200C2", "CMXP512-3200XL", "TWIN2X1024-4300C3PRO",
"KTD-DM8400/1G", "KTH8348/1G", "KTD4400/256", "D6464D30A", "KTA-G5400/512",
"KVR667D2N5/1G", "KVR133X64C3/256");
$dp = new DeviceMemory();
for ($i=0 ; $i<$MAX['device'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "ram $i";
}
$dp->add(toolbox::addslashes_deep(
array('designation' => $val,
'is_recursive' => 1,
'comment' => "comment' $val",
'manufacturers_id' => mt_rand(1,$MAX['manufacturer']),
'frequence' => 100*mt_rand(0,10),
'size_default' => 1024*mt_rand(0,6),
'devicememorytypes_id' => mt_rand(1,$MAX['ram_type']))));
}
$items = array("DDTS-100", "Audigy 2 ZS Platinum", "Audigy SE", "DJ Console Mk2",
"Gamesurround Muse Pocket USB", "Phase 22", "X-Fi Platinum", "Live! 24-bit",
"X-Fi Elite Pro");
$dp = new DeviceSoundCard();
for ($i=0 ; $i<$MAX['device'] ; $i++) {
if (isset($items[$i])) {
$val = $items[$i];
} else {
$val = "sndcard $i";
}
$dp->add(toolbox::addslashes_deep(
array('designation' => $val,
'is_recursive' => 1,
'comment' => "comment '$val",
'manufacturers_id' => mt_rand(1,$MAX['manufacturer']),
'type' => 'type '.mt_rand(0,100))));
}
} // Fin generation global dropdowns
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = PhoneModel::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
/**
* @author tannew
* Upload phone numbers to Group
*/
public function actionUpload()
{
$message = "";
$errorList = array();
// list of invalid Vinaphone phone
$dupList = array();
// list of duplicated phone
$subscribeList = array();
// list subscribed phone
$arrayVal = array();
$arr_filter = array();
$id = $_POST['group_id'];
$source_file = $_POST['source_name'];
//ten file excel
$arr_filter['register_phone_filter'] = $_POST['register_phone_filter'];
//checkbox: Kiem tra nhung so DT da dang ki
$arr_filter['exist_group_filter'] = $_POST['exist_group_filter'];
//checkbox: Loai bo nhung so DT da thuoc group khac
$arr_filter['group_list'] = $_POST['group_list'];
// danh sach cac Group muon loai bo cac so DT da thuoc chung
$arr_filter['date_filter'] = $_POST['date_filter'];
// text: Loc theo ngay
$arr_filter['km_filter'] = $_POST['km_filter'];
// chi lay nhung so DT dc huong KM de add vao group
$group_id = $id;
if (isset($source_file, $id)) {
$fileName = _APP_PATH_ . DS . "public/admin/data" . DS . "tmp" . DS . $source_file;
try {
require_once 'excel_reader2.php';
$data = new Spreadsheet_Excel_Reader($fileName, true, "UTF-8");
// khoi tao doi tuong doc file excel
$rowsnum = $data->rowcount($sheet_index = 0);
// lay so hang cua sheet
for ($i = 1; $i <= $rowsnum; $i++) {
// doc tu hang so 2 vi hang 1 la tieu de roi!
$phoneNum = $data->val($i, 1);
// xuat cot so 1 va cot so 2 tren cung 1 hang
try {
$phoneNum = Formatter::formatMSISDN($phoneNum, "84,0", "84");
if (Formatter::isVinaphoneNumber($phoneNum)) {
$created_time = date("Y-m-d H:i:s");
$exist = PhoneModel::model()->exists('group_id = :group_id AND phone= :phone', array(':phone' => $phoneNum, ':group_id' => $id));
if ($exist == false) {
try {
$arrayVal[] = "('{$phoneNum}',{$group_id},0,'{$created_time}')";
} catch (Exception $exc) {
echo $exc->getMessage();
}
} else {
$dupList[] = $phoneNum;
}
} else {
$errorList[] = $phoneNum;
}
} catch (Exception $exc) {
echo $exc->getMessage();
}
}
/**
* Start insert here: split each 200 phone
*/
$arrs = array_chunk($arrayVal, 200);
foreach ($arrs as $arr) {
$vals = implode(",", $arr);
$sql = "INSERT INTO spam_sms_phone (`phone`,`group_id`,`status`,`created_time`) VALUES {$vals}";
$command = Yii::app()->db->createCommand($sql);
$command->execute();
}
} catch (Exception $exc) {
echo $exc->getMessage();
}
}
// delete phone in blacklist
$sql = "DELETE spam_sms_phone.* FROM spam_sms_phone INNER JOIN deleted_phone on deleted_phone.phone = spam_sms_phone.phone WHERE spam_sms_phone.group_id = :gid";
$command = Yii::app()->db->createCommand($sql);
$command->bindParam(":gid", $group_id);
$command->execute();
// Delete phone from spam_sms_reject_phone
$sql = "DELETE spam_sms_phone.* FROM spam_sms_phone INNER JOIN spam_sms_reject_phone t2 on t2.phone = spam_sms_phone.phone WHERE spam_sms_phone.group_id = :gid";
$command = Yii::app()->db->createCommand($sql);
$command->bindParam(":gid", $group_id);
$command->execute();
// C1: delete phone Ko dc huong KM if km_filter = 1
if ($arr_filter['km_filter'] == "1") {
$sql = "DELETE spam_sms_phone.* FROM spam_sms_phone INNER JOIN user_subscribe_km on user_subscribe_km.phone = spam_sms_phone.phone WHERE spam_sms_phone.group_id = :gid and (user_subscribe_km.type = 0 OR (user_subscribe_km.type = 1 AND user_subscribe_km.created_time >= date_sub(NOW(), interval 720 hour)))";
$command = Yii::app()->db->createCommand($sql);
$command->bindParam(":gid", $group_id);
$command->execute();
}
// C3: remove all Phone in selected groups
if ($arr_filter['exist_group_filter'] == "1") {
if (!empty($arr_filter['group_list']) && count($arr_filter['group_list']) > 0) {
$listGroup = implode(',', $arr_filter['group_list']);
$sql = "DELETE s1.* FROM spam_sms_phone s1 INNER JOIN spam_sms_phone s2 ON s1.phone = s2.phone WHERE s1.group_id = :gid and s2.group_id IN (:listId)";
$command = Yii::app()->db->createCommand($sql);
$command->bindParam(":gid", $group_id);
$command->bindParam(":listId", $listGroup);
$command->execute();
}
}
// C4: remove all Phone in groups have Cld which has been sent FROM...TO...
if ($arr_filter['date_filter'] != "") {
// extract Time
$filter_time = "";
if (strrpos($arr_filter['date_filter'], "-")) {
// example 8/13/2012 - 8/20/2012
$arr_filter['date_filter'] = explode("-", $arr_filter['date_filter']);
$fromDate = explode("/", trim($arr_filter['date_filter'][0]));
$fromDate = $fromDate[2] . "-" . str_pad($fromDate[0], 2, '0', STR_PAD_LEFT) . "-" . str_pad($fromDate[1], 2, '0', STR_PAD_LEFT);
$toDate = explode("/", trim($arr_filter['date_filter'][1]));
$toDate = $toDate[2] . "-" . str_pad($toDate[0], 2, '0', STR_PAD_LEFT) . "-" . str_pad($toDate[1], 2, '0', STR_PAD_LEFT);
$filter_time = array('from' => $fromDate . ' 00:00:00', 'to' => $toDate . ' 23:59:59');
} else {
// single day 8/16/2012
$time = explode("/", trim($arr_filter['date_filter']));
$time = $time[2] . "-" . str_pad($time[0], 2, '0', STR_PAD_LEFT) . "-" . str_pad($time[1], 2, '0', STR_PAD_LEFT);
$filter_time = array('from' => $time . ' 00:00:00', 'to' => $time . ' 23:59:59');
}
// Select all groups have Cld which has been sent FROM...TO...
$cri = new CDbCriteria();
$cri->select = "group_id";
$cri->addBetweenCondition('send_time', $filter_time['from'], $filter_time['to']);
$listGroup = SpamSmsCldModel::model()->findAll($cri);
$arrGr = array();
foreach ($listGroup as $group) {
$arrGr[] = $group->group_id;
}
// check if this phone belongs to one of those groups
if (!empty($arrGr)) {
$listGroup = implode(',', $arrGr);
$sql = "DELETE s1.* FROM spam_sms_phone s1 INNER JOIN spam_sms_phone s2 ON s1.phone = s2.phone WHERE s1.group_id = :gid and s2.group_id IN (:listId)";
$command = Yii::app()->db->createCommand($sql);
$command->bindParam(":gid", $group_id);
$command->bindParam(":listId", $listGroup);
$command->execute();
}
}
// C2: remove Registered phone
if ($arr_filter['register_phone_filter'] == "1") {
$sql = "DELETE s1.* FROM spam_sms_phone s1 INNER JOIN user_subscribe u ON s1.phone = u.user_phone WHERE u.expired_time >= '" . date("Y-m-d H:i:s") . "' AND user_phone != '84946760402'";
$command = Yii::app()->db->createCommand($sql);
$command->execute();
}
/* Insert test phones to TEST_GROUP */
$cri = new CDbCriteria();
$cri->select = "phone";
$cri->condition = "group_id = (SELECT id from spam_sms_group WHERE name= 'TEST_GROUP')";
if ($countTestPhone) {
$listPhones = PhoneModel::model()->findAll($cri);
$testPhones = array();
foreach ($listPhones as $phone) {
$phoneNum = $phone->phone;
$created_time = date("Y-m-d H:i:s");
$testPhones[] = "('{$phoneNum}',{$id},0,'{$created_time}')";
}
$vals = implode(",", $testPhones);
$sql = "INSERT INTO spam_sms_phone (`phone`,`group_id`,`status`,`created_time`) VALUES {$vals}";
$command = Yii::app()->db->createCommand($sql);
$command->execute();
}
/* end Insert test phones */
$phoneList = new PhoneModel();
$phoneList->unsetAttributes();
$phoneList->setAttribute('group_id', $id);
Yii::app()->session['phoneList'] = $phoneList;
Yii::app()->session['message'] = $message;
Yii::app()->session['errorList'] = $errorList;
Yii::app()->session['dupList'] = $dupList;
Yii::app()->session['subscribeList'] = $subscribeList;
$this->redirect(array('view', 'id' => $id));
}
