Difference between revisions of "SI2/1.6"

From CSWiki
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 12: Line 12:
  
 
#  <del>ALTER TABLE `consumables` ADD `active` TINYINT NOT NULL DEFAULT '1' AFTER `active` ;</del> {{red|Fixed in SI2 DB version 11 (si2v11) --[[User:Ank|ank]] 13:09, 6 December 2010 (UTC)}}
 
#  <del>ALTER TABLE `consumables` ADD `active` TINYINT NOT NULL DEFAULT '1' AFTER `active` ;</del> {{red|Fixed in SI2 DB version 11 (si2v11) --[[User:Ank|ank]] 13:09, 6 December 2010 (UTC)}}
#  ALTER TABLE `modules` CHANGE `tender_id` `tender_id` INT( 6 ) NULL DEFAULT '1'
+
<del>ALTER TABLE `modules` CHANGE `tender_id` `tender_id` INT( 6 ) NULL DEFAULT '1'</del> {{red|Checked in SI2 DB version 11 and found to be right --[[User:Ank|ank]] 13:12, 6 December 2010 (UTC) }}
 
#  ALTER TABLE `dropdownfields` CHANGE `dd_values` `dd_values` VARCHAR( 500 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
 
#  ALTER TABLE `dropdownfields` CHANGE `dd_values` `dd_values` VARCHAR( 500 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
#  ALTER TABLE `modules` ADD `module_cost` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL AFTER `module_model` ;
+
<del>ALTER TABLE `modules` ADD `module_cost` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL AFTER `module_model` ;</del>{{red| Added in SI2 DB version 11 as DECIMAl(10,2) --[[User:Ank|ank]] 13:21, 6 December 2010 (UTC)}}
  
 
== SI2/1.6 New Features ==
 
== SI2/1.6 New Features ==

Latest revision as of 15:21, 6 December 2010

What we are planning for v 1.6:

  1. Το μοντέλο κάθε μηχανής και κάθε module πρέπει να συμπεριληφθέι στα reports και στους γενικούς πίνακες (browse)των αντικειμένων (Υπάρχουν ήδη τα στοιχεία αυτά στη βάση και καταγράφονται κάθε φορά. Αφορά δηλαδή μόνο αλλαγή στα queries και στην εμφάνιση των αποτελεσμάτων) Implemented in version 1.6.andrim 11:33, 28 December 2009 (UTC)
  2. Στη κατηγορία των αναλωσίμων πρέπει να εφαρμοστέι κάτι ανάλογο με το Inactive People που εφαρμόστηκε στα People. Σκοπός είναι η μειώση της λίστας των αναλωσίμων με απόκρυψη των αναλωσίμων που δεν χρησιμοποιούνται πλέον. Implemented in version 1.6.andrim 11:00, 28 December 2009 (UTC)
  3. Στο StockControl/BrowseConsumStock.php πρέπει να βλέπουμε και το Part number των αναλωσίμων. (Υπάρχουν ήδη τα στοιχεία αυτά στη βάση) Implemented in version 1.6.andrim 09:50, 28 December 2009 (UTC)
  4. Εισηγούμαι όπως δημιουργηθεί και field για να κρατάμε την αρχική τιμή αγοράς ενός αντικειμένου. --ank 06:59, 13 April 2009 (UTC)Implemented in version 1.6.andrim 12:13, 11 January 2010 (UTC)

Database Change Log

  1. ALTER TABLE `consumables` ADD `active` TINYINT NOT NULL DEFAULT '1' AFTER `active` ; Fixed in SI2 DB version 11 (si2v11) --ank 13:09, 6 December 2010 (UTC)
  2. ALTER TABLE `modules` CHANGE `tender_id` `tender_id` INT( 6 ) NULL DEFAULT '1' Checked in SI2 DB version 11 and found to be right --ank 13:12, 6 December 2010 (UTC)
  3. ALTER TABLE `dropdownfields` CHANGE `dd_values` `dd_values` VARCHAR( 500 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
  4. ALTER TABLE `modules` ADD `module_cost` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL AFTER `module_model` ; Added in SI2 DB version 11 as DECIMAl(10,2) --ank 13:21, 6 December 2010 (UTC)

SI2/1.6 New Features

  1. Quick search option is fixed. Now we can search using cs number or hostname.
  2. When edit or add a new module/machine the page redirect to it so we can review the canges we make. This is also usefull since the system is not slow loading the full list each time.
  3. Model details are included now in reports and full list of equipment
  4. Create option for delete or make consumables inactive. This is usefull in order to reduce the size of the list and remove old consumables, no longer needed in department.
  5. Create option in Custom search to search between two dates for Acceptance and Warranty Expires and search before or after a specific date.
  6. The system is now keeping logs in the $LOGS_PATH specified in config.ini file. There are two types of logs: Authentication logs and transaction logs. You can use /logs/ in the web application folder but this is not recommended.
  7. Si2 is ready to use by academic staff. The can login using their ldap credentials and view reports for the equipment they own.
  8. An new field for initial purchase price is available for every module.