inventory/setup.php at master · dotproject/inventory · GitHub

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
<?php
/*
 * Name:      Inventory
 * Directory: inventory
 * Version:   0.1
 * Class:     user
 * UI Name:   Inventory
 * UI Icon:
 */

// MODULE CONFIGURATION DEFINITION
$config = array();
$config['mod_name'] = 'Inventory';
$config['mod_version'] = '0.3';
$config['mod_directory'] = 'inventory';
$config['mod_setup_class'] = 'CSetupInventory';
$config['mod_type'] = 'user';
$config['mod_ui_name'] = 'Inventory';
$config['mod_ui_icon'] = '48_my_computer.png';
$config['mod_description'] = 'A module for tracking designated hardware and software';

if (@$a == 'setup') {
	echo dPshowModuleConfig( $config );
}

class CSetupInventory {

	function remove() {
		db_exec( "DROP TABLE inventory;" );										// v0.1
		db_exec( "DROP TABLE inventory_categories;" );                          // v0.1
		db_exec( "DROP TABLE inventory_brands;" );                              // v0.1
		return null;
	}

	function upgrade( $old_version ) {

		switch ( $old_version )
		{
		case "all":		// upgrade from scratch (called from install)
		case "0.1":
			$sql = "ALTER TABLE inventory " .
				"  ADD COLUMN inventory_purchase_state char(1)" .
				", ADD COLUMN inventory_purchase_company int(11) NOT NULL default '0'" .
				", ADD COLUMN inventory_delivered date NOT NULL default '2007-08-01'" .
				"";
			db_exec( $sql ); db_error();

		case "0.2":
			$sql = "ALTER TABLE inventory " .
				"   ADD COLUMN inventory_quantity int(11) NOT NULL default '1'";
			db_exec( $sql ); db_error();

		case "0.3":
			return true;

		default:
			return false;
		}

		return false;
	}

	function install() {
		$sql = "CREATE TABLE inventory ( " .
			"  inventory_id int(11) unsigned NOT NULL auto_increment" .		// v0.1
			", inventory_user int(11) NOT NULL default '0'" .				// v0.1
			", inventory_company int(11) NOT NULL default '0'" .				// v0.1
			", inventory_department int(11) NOT NULL default '0'" .          // v0.1
			", inventory_project int(11) NOT NULL default '0'" .             // v0.1
			", inventory_category int(11) NOT NULL default '0'" .            // v0.1
			", inventory_brand int(11) NOT NULL default '0'" .               // v0.1
			", inventory_purchased date NOT NULL default '2001-01-01'" .     // v0.1
			", inventory_assign_from date NOT NULL default '2001-01-01'" .   // v0.1
			", inventory_assign_until date NOT NULL default '2001-01-01'" .  // v0.1
			", inventory_cost int(20) NOT NULL default '0'" .                // v0.1
			", inventory_rental_period char NOT NULL default ' '" .          // v0.1
			", inventory_name char(80)" .                                    // v0.1
			", inventory_serial char(40)" .                                  // v0.1
			", inventory_asset_no char(40)" .                                // v0.1
			", inventory_costcode char(40)" .                                // v0.1
			", inventory_description text" .                                 // v0.1
			", inventory_parent int(11) NOT NULL default '0'" .              // v0.1
			", PRIMARY KEY  (inventory_id)" .                                // v0.1
			", UNIQUE KEY inventory_id (inventory_id)" .                      // v0.1
			") TYPE=MyISAM;";

		db_exec( $sql ); db_error();

		$sql = "CREATE TABLE inventory_categories ( " .
			"  inventory_category_id int(11) unsigned NOT NULL auto_increment" .	// v0.1
			", inventory_category_name text" .                                      // v0.1
			", PRIMARY KEY (inventory_category_id)" .                               // v0.1
			", UNIQUE KEY inventory_category_id (inventory_category_id)" .          // v0.1
			") TYPE=MyISAM;";

		db_exec( $sql ); db_error();

		$sql = "CREATE TABLE inventory_brands ( " .								// v0.1
			"  inventory_brand_id int(11) unsigned NOT NULL auto_increment" .    // v0.1
			", inventory_brand_name text" .                                      // v0.1
			", PRIMARY KEY (inventory_brand_id)" .                               // v0.1
			", UNIQUE KEY inventory_brand_id (inventory_brand_id)" .              // v0.1
			") TYPE=MyISAM;";

		db_exec( $sql ); db_error();

		$this->upgrade( "all" );

		return null;
	}

}

?>