Navigation

← Previous Changeset
Next Changeset →

Changeset 443

Timestamp:

09/03/08 16:38:19 (3 months ago)

Author:

abdullah

Message:

Added reference to committee directly into decision and status. Would make it easier to search

Files:

trunk/app/config/sql/schema.php (modified) (4 diffs)
trunk/app/controllers/decisions_controller.php (modified) (3 diffs)
trunk/app/controllers/groupstatuses_controller.php (modified) (2 diffs)
trunk/app/controllers/userstatuses_controller.php (modified) (3 diffs)
trunk/app/models/committee.php (modified) (10 diffs)
trunk/app/models/decision.php (modified) (1 diff)
trunk/app/models/groupstatus.php (modified) (2 diffs)
trunk/app/models/userstatus.php (modified) (1 diff)
trunk/sql/mymeeting2008.sql (modified) (41 diffs)
trunk/sql/mymeeting2008data.sql (modified) (20 diffs)
trunk/sql/mymeeting2008tables.sql (modified) (22 diffs)

Legend:

: Unmodified
: Added
: Removed
: Modified
: Copied
: Moved

trunk/app/config/sql/schema.php

r430	r443
1	1	<?php
2	2	/* SVN FILE: $Id$ */
3		/* App schema generated on: 2008-0~~8-12 11:08:50 : 1218511490~~*/
	3	/* App schema generated on: 2008-09-03 16:09:25 : 1220429305*/
4	4	class AppSchema extends CakeSchema {
5	5	var $name = 'App';
…	…
102	102	var $decisions = array(
103	103	'id' => array('type'=>'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'),
	104	'committee_id' => array('type'=>'integer', 'null' => false, 'default' => NULL),
104	105	'meeting_id' => array('type'=>'integer', 'null' => false, 'default' => NULL),
105	106	'item_id' => array('type'=>'integer', 'null' => false, 'default' => NULL),
…	…
135	136	var $groupstatuses = array(
136	137	'id' => array('type'=>'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'),
	138	'committee_id' => array('type'=>'integer', 'null' => false, 'default' => NULL),
137	139	'decision_id' => array('type'=>'integer', 'null' => false, 'default' => NULL),
138	140	'user_id' => array('type'=>'integer', 'null' => false, 'default' => NULL),
…	…
283	285	var $userstatuses = array(
284	286	'id' => array('type'=>'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'),
	287	'committee_id' => array('type'=>'integer', 'null' => false, 'default' => NULL),
285	288	'decision_id' => array('type'=>'integer', 'null' => false, 'default' => NULL),
286	289	'user_id' => array('type'=>'integer', 'null' => false, 'default' => NULL),

trunk/app/controllers/decisions_controller.php

r433	r443
177	177	if(isset($ddat['Deadline'])) $decision['Decision']['deadline']=$ddat['Deadline'];
178	178	$decision['Decision']['description']=$ddat['Decision'];
	179	$decision['Decision']['committee_id']=$dcommittee['Committee']['id'];
179	180	$this->Decision->save($decision);
180	181	$stripd=preg_replace('\|^<p>(.*)</p>$\|','\1',$ddat['Decision']);
…	…
339	340	if (!empty($this->data)) {
340	341	$this->Decision->create();
	342	$this->data['Decision']['committee_id']=$dcommittee['Committee']['id'];
341	343	if ($this->Decision->save($this->data)) {
342	344	$this->Session->setFlash(__('The Decision has been saved', true));
…	…
382	384	if (!empty($this->data)) {
383	385	$this->Decision->curUser=$this->Auth->user('id');
	386	$this->data['Decision']['committee_id']=$dcommittee['Committee']['id'];
384	387	if ($this->Decision->save($this->data)) {
385	388	$this->Session->setFlash(__('The Decision has been saved', true));

trunk/app/controllers/groupstatuses_controller.php

r388	r443
60	60	$this->Groupstatus->create();
61	61	$this->data['Groupstatus']['user_id']=$this->Auth->user('id');
	62	$this->data['Groupstatus']['committee_id']=$dcommittee['Committee']['id'];
62	63	if ($this->Groupstatus->save($this->data)) {
63	64	$this->Session->setFlash(__('The Groupstatus has been saved', true));
…	…
94	95	}
95	96	if (!empty($this->data)) {
	97	$this->data['Groupstatus']['committee_id']=$dcommittee['Committee']['id'];
96	98	if ($this->Groupstatus->save($this->data)) {
97	99	$this->Session->setFlash(__('The Groupstatus has been saved', true));

trunk/app/controllers/userstatuses_controller.php

r388	r443
1	1	<?php
	2	/*
	3	* Copyright (c) 2008 Government of Malaysia
	4	* All rights reserved.
	5	*
	6	* Redistribution and use in source and binary forms, with or without
	7	* modification, are permitted provided that the following conditions
	8	* are met:
	9	* 1. Redistributions of source code must retain the above copyright
	10	* notice, this list of conditions and the following disclaimer.
	11	* 2. Redistributions in binary form must reproduce the above copyright
	12	* notice, this list of conditions and the following disclaimer in the
	13	* documentation and/or other materials provided with the distribution.
	14	*
	15	* THIS SOFTWARE IS PROVIDED BY THE REGENTS AND CONTRIBUTORS ``AS IS'' AND
	16	* ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
	17	* IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
	18	* ARE DISCLAIMED. IN NO EVENT SHALL THE REGENTS OR CONTRIBUTORS BE LIABLE
	19	* FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
	20	* DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS
	21	* OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
	22	* HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
	23	* LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY
	24	* OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
	25	* SUCH DAMAGE.
	26	*
	27	* @author: Abdullah Zainul Abidin, Nuhaa All Bakry
	28	* Eavay Javay Barnad, Sarogini Muniyandi
	29	*
	30	*/
	31
2	32	class UserstatusesController extends AppController {
3	33
…	…
62	92	$this->Userstatus->create();
63	93	$this->data['Userstatus']['updater']=$this->Auth->user('id');
	94	$this->data['Userstatus']['committee_id']=$dcommittee['Committee']['id'];
64	95	if ($this->Userstatus->save($this->data)) {
65	96	$this->Session->setFlash(__('The Status has been saved', true));
…	…
95	126	}
96	127	if (!empty($this->data)) {
	128	$this->data['Userstatus']['committee_id']=$dcommittee['Committee']['id'];
97	129	if ($this->Userstatus->save($this->data)) {
98	130	$this->Session->setFlash(__('The Status has been saved', true));

trunk/app/models/committee.php

r434	r443
32	32	class Committee extends AppModel {
33	33
34		/**
35		* Defining the name of model
36		*
37		*/
	34	/**
	35	* Defining the name of model
	36	*
	37	*/
38	38	var $name = 'Committee';
39		/**
40		* Defining the name of the table
41		*
42		*/
	39	/**
	40	* Defining the name of the table
	41	*
	42	*/
43	43	var $useTable = 'committees';
44		/**
45		* Displaying committee short name
46		*
47		*/
	44	/**
	45	* Displaying committee short name
	46	*
	47	*/
48	48	var $displayField = 'short_name';
49	49
50		/**
51		* Validating the fields in committee model
52		*
53		*/
54		var $validate = array(
	50	/**
	51	* Validating the fields in committee model
	52	*
	53	*/
	54	var $validate = array(
55	55	'name' => VALID_NOT_EMPTY,
56	56	'short_name' =>array(
57		'required'=>VALID_NOT_EMPTY,
58		'unique'=>array('rule' => array('checkUnique', 'short_name')
59		)),
	57	'required'=>VALID_NOT_EMPTY,
	58	'unique'=>array('rule' => array('checkUnique', 'short_name')
	59	)),
60	60	'description' => VALID_NOT_EMPTY);
61	61
62		/**
63		* Building assosiations betweeen models (ex : committee hasMany announcement)
64		*
65		*/
	62	/**
	63	* Building assosiations betweeen models (ex : committee hasMany announcement)
	64	*
	65	*/
66	66	var $hasMany = array(
67	67	'Announcement' => array(
…	…
101	101	'finderQuery' => '',
102	102	'counterQuery' => ''),
	103	'Decision' => array(
	104	'className' => 'Decision',
	105	'foreignKey' => 'committee_id',
	106	'dependent' => false,
	107	'conditions' => '',
	108	'fields' => '',
	109	'order' => '',
	110	'limit' => '',
	111	'offset' => '',
	112	'exclusive' => '',
	113	'finderQuery' => '',
	114	'counterQuery' => ''),
	115	'Userstatus' => array(
	116	'className' => 'Userstatus',
	117	'foreignKey' => 'decision_id',
	118	'dependent' => false,
	119	'conditions' => '',
	120	'fields' => '',
	121	'order' => '',
	122	'limit' => '',
	123	'offset' => '',
	124	'exclusive' => '',
	125	'finderQuery' => '',
	126	'counterQuery' => ''),
	127	'Groupstatus' => array(
	128	'className' => 'Groupstatus',
	129	'foreignKey' => 'decision_id',
	130	'dependent' => false,
	131	'conditions' => '',
	132	'fields' => '',
	133	'order' => '',
	134	'limit' => '',
	135	'offset' => '',
	136	'exclusive' => '',
	137	'finderQuery' => '',
	138	'counterQuery' => ''),
103	139	'Workflow' => array(
104	140	'className' => 'Workflow',
…	…
139	175	);
140	176
141		/**
142		* Building assosiations betweeen models
143		*
144		*/
	177	/**
	178	* Building assosiations betweeen models
	179	*
	180	*/
145	181	var $hasAndBelongsToMany = array(
146	182	'User' => array(
…	…
160	196	);
161	197
162		/**
163		* Finding all the related userdata defined by the committee_id and user_id
164		* $param committee_id and user_id finds all the related userdata
165		*/
	198	/**
	199	* Finding all the related userdata defined by the committee_id and user_id
	200	* $param committee_id and user_id finds all the related userdata
	201	*/
166	202	function userData($user_id,$committee_id=null){
167	203	$groups=$this->CommitteesUser->User->UsersGroup->find('all',array(
…	…
184	220	}
185	221
186		/**
187		* Finding all the related committees per user defined by the user_id order by committee name
188		* $param user_id finds all the committees per user
189		*/
	222	/**
	223	* Finding all the related committees per user defined by the user_id order by committee name
	224	* $param user_id finds all the committees per user
	225	*/
190	226	function getCommitteesPerUser($user_id) {
191	227	$committees = $this->CommitteesUser->findAll(
…	…
199	235	}
200	236
201		/**
202		* Finding all the related registered committee defined by the user_id order by committee name
203		* $param user_id finds all the registered committee
204		*/
	237	/**
	238	* Finding all the related registered committee defined by the user_id order by committee name
	239	* $param user_id finds all the registered committee
	240	*/
205	241	function registeredCommittee($user_id){
206	242	return Set::extract($this->CommitteesUser->find('all',array('fields'=>'committee_id','order'=>'Committee.name ASC','conditions'=>array('user_id'=>$user_id))),"{n}.CommitteesUser.committee_id");
207	243	}
208	244
209		/**
210		* Finding all the related list of registered committee defined by the user_id order by committee name
211		* $param user_id finds all the list of registered committee
212		*/
	245	/**
	246	* Finding all the related list of registered committee defined by the user_id order by committee name
	247	* $param user_id finds all the list of registered committee
	248	*/
213	249	function registeredCommitteeList($user_id){
214	250	return $this->find('list',array('order'=>'name ASC','conditions'=>array('id'=>$this->registeredCommittee($user_id))));
215	251	}
216	252
217		/**
218		* Allowing afterSave() callbacks to modify the value of a data field.
219		* @param created modifies the value of a data field.
220		*/
	253	/**
	254	* Allowing afterSave() callbacks to modify the value of a data field.
	255	* @param created modifies the value of a data field.
	256	*/
221	257	function afterSave($created){
222	258	if($created){
…	…
348	384	}
349	385
350		/**
351		* Finding all the decision status which is not taken and on time defined by the committee_id
352		* $param committee_id finds all the decision status which is not taken for the specified user type
353		*/
	386	/**
	387	* Finding all the decision status which is not taken and on time defined by the committee_id
	388	* $param committee_id finds all the decision status which is not taken for the specified user type
	389	*/
354	390	function nottaken($committee_id,$type='User'){
355	391	$all=$this->query($this->statusquery($type,$type.'Status.id is null and Decision.deadline>=now() and Meeting.committee_id='.$committee_id,false));
356	392	return $all;
357		echo "<pre>".print_r($decision_ids,true)."</pre>";
358		}
359
360		/**
361		* Finding all the decision status which is not taken and over due defined by the committee_id
362		* $param committee_id finds all the decision status which is not taken for the specified user type
363		*/
	393	echo "<pre>".print_r($decision_ids,true)."</pre>";
	394	}
	395
	396	/**
	397	* Finding all the decision status which is not taken and over due defined by the committee_id
	398	* $param committee_id finds all the decision status which is not taken for the specified user type
	399	*/
364	400	function nottakenlate($committee_id,$type='User'){
365	401	$all=$this->query($this->statusquery($type,$type.'Status.id is null and Decision.deadline<now() and Meeting.committee_id='.$committee_id,false));
366	402	return $all;
367
368		}
369
370		/**
371		* Finding all the decision status which is taken and on time defined by the committee_id
372		* $param committee_id finds all the decision status which is taken and on time for the specified user type
373		*/
	403
	404	}
	405
	406	/**
	407	* Finding all the decision status which is taken and on time defined by the committee_id
	408	* $param committee_id finds all the decision status which is taken and on time for the specified user type
	409	*/
374	410	function takenontime($committee_id,$type='User'){
375	411	$sql = $this->statusquery($type,$type.'Status.action_date<=Decision.deadline and Meeting.committee_id='.$committee_id);
…	…
378	414	}
379	415
380		/**
381		* Finding all the decision status which is taken and late defined by the committee_id
382		* $param committee_id finds all the decision status which is taken and late for the specified user type
383		*/
	416	/**
	417	* Finding all the decision status which is taken and late defined by the committee_id
	418	* $param committee_id finds all the decision status which is taken and late for the specified user type
	419	*/
384	420	function takenlate($committee_id,$type='User'){
385	421	$all=$this->query($this->statusquery($type,$type.'Status.action_date>Decision.deadline and Meeting.committee_id='.$committee_id));
…	…
387	423	}
388	424
389		/**
390		* Query all the decision status for the specified user type
391		*/
	425	/**
	426	* Query all the decision status for the specified user type
	427	*/
392	428	function statusquery($type='User',$cond,$taken=true){
393	429	$statusjoin='';
…	…
409	445	}
410	446
411		/**
412		* Describe getStatusDeadline
413		*
414		* @param $id
415		* @return null
416		*/
	447	/**
	448	* Describe getStatusDeadline
	449	*
	450	* @param $id
	451	* @return null
	452	*/
417	453	/* function getStatusDeadline($id){
418	454

trunk/app/models/decision.php

r433	r443
54	54	*/
55	55	var $belongsTo = array(
	56	'Committee' => array(
	57	'className' => 'Committee',
	58	'foreignKey' => 'committee_id',
	59	'conditions' => '',
	60	'fields' => '',
	61	'order' => ''),
56	62	'Meeting' => array(
57	63	'className' => 'Meeting',

trunk/app/models/groupstatus.php

r402	r443
2	2	class Groupstatus extends AppModel {
3	3
4		/**
5		* Defining the name of model
6		*
7		*/
8		var $name = 'Groupstatus';
9		/**
10		* Defining the name of the table
11		*
12		*/
	4	/**
	5	* Defining the name of model
	6	*
	7	*/
	8	var $name = 'Groupstatus';
	9	/**
	10	* Defining the name of the table
	11	*
	12	*/
13	13	var $useTable = 'groupstatuses';
14		/**
15		* Defining behavior in the model
16		*
17		*/
	14	/**
	15	* Defining behavior in the model
	16	*
	17	*/
18	18	var $actsAs = array('Comment','Workflow','SoftDeletable','MultiFile');
19	19
20		/**
21		* Validating the fields in group status model
22		*
23		*/
24		var $validate = array(
25		'decision_id' => array('numeric'),
26		'user_id' => array('numeric'),
27		'group_id' => array('numeric'),
28		'deleted' => array('numeric'),
29		'deleted_date' => array('date')
30		);
	20	/**
	21	* Validating the fields in group status model
	22	*
	23	*/
	24	var $validate = array(
	25	'decision_id' => array('numeric'),
	26	'user_id' => array('numeric'),
	27	'group_id' => array('numeric'),
	28	'deleted' => array('numeric'),
	29	'deleted_date' => array('date')
	30	);
31	31
32		//The Associations below have been created with all possible keys, those that are not needed can be removed
33		/**
34		* Building assosiations betweeen models
35		*
36		*/
37		var $belongsTo = array(
38		'Decision' => array('className' => 'Decision',
39		'foreignKey' => 'decision_id',
40		'conditions' => '',
41		'fields' => '',
42		'order' => ''
43		),
44		'User' => array('className' => 'User',
45		'foreignKey' => 'user_id',
46		'conditions' => '',
47		'fields' => '',
48		'order' => ''
49		),
50		'Group' => array('className' => 'Group',
51		'foreignKey' => 'group_id',
52		'conditions' => '',
53		'fields' => '',
54		'order' => ''
55		)
56		);
	32	//The Associations below have been created with all possible keys, those that are not needed can be removed
	33	/**
	34	* Building assosiations betweeen models
	35	*
	36	*/
	37	var $belongsTo = array(
	38	'Committee' => array(
	39	'className' => 'Committee',
	40	'foreignKey' => 'committee_id',
	41	'conditions' => '',
	42	'fields' => '',
	43	'order' => ''),
	44	'Decision' => array(
	45	'className' => 'Decision',
	46	'foreignKey' => 'decision_id',
	47	'conditions' => '',
	48	'fields' => '',
	49	'order' => ''
	50	),
	51	'User' => array(
	52	'className' => 'User',
	53	'foreignKey' => 'user_id',
	54	'conditions' => '',
	55	'fields' => '',
	56	'order' => ''
	57	),
	58	'Group' => array(
	59	'className' => 'Group',
	60	'foreignKey' => 'group_id',
	61	'conditions' => '',
	62	'fields' => '',
	63	'order' => ''
	64	)
	65	);
57	66
58		/**
59		* Getting all the related committee for the decision defined by status_id
60		* $param status_id finds all the related committee for the decision
61		*/
	67	/**
	68	* Getting all the related committee for the decision defined by status_id
	69	* $param status_id finds all the related committee for the decision
	70	*/
62	71	function getCommitteeId($status_id){
63	72	return $this->Decision->getCommitteeId($this->getDecisionId($status_id));
64	73	}
65	74
66		/**
67		* Getting all the related decision defined by the groupstatus id
68		* $param id finds all the related decision
69		*/
	75	/**
	76	* Getting all the related decision defined by the groupstatus id
	77	* $param id finds all the related decision
	78	*/
70	79	function getDecisionId($id){
71	80	$data=$this->getData(array('decision_id'),array('id'=>$id));
…	…
73	82	}
74	83
75		/**
76		* Finding all the related user data defined by the user_id and status_id
77		* $param user_id and status_id finds all the related user data
78		*/
	84	/**
	85	* Finding all the related user data defined by the user_id and status_id
	86	* $param user_id and status_id finds all the related user data
	87	*/
79	88	function userData($user_id,$status_id=null){
80	89	$decision_id=$this->getDecisionId($status_id);

trunk/app/models/userstatus.php

r402	r443
24	24	*/
25	25	var $belongsTo = array(
	26	'Committee' => array(
	27	'className' => 'Committee',
	28	'foreignKey' => 'committee_id',
	29	'conditions' => '',
	30	'fields' => '',
	31	'order' => ''),
26	32	'Decision' => array(
27	33	'className' => 'Decision',

trunk/sql/mymeeting2008.sql

r430	r443
181	181	`updated` datetime default NULL,
182	182	PRIMARY KEY (`id`)
183		) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
	183	) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
184	184	SET character_set_client = @saved_cs_client;
185	185
…	…
190	190	LOCK TABLES `comments` WRITE;
191	191	/!40000 ALTER TABLE `comments` DISABLE KEYS /;
192		INSERT INTO `comments` VALUES (2,'Userstatus',4,'ffffff',11,'2008-06-27 11:26:46','2008-06-27 11:26:46'),(3,'Userstatus',4,'',11,'2008-06-27 11:26:51','2008-06-27 11:26:51'),(4,'Userstatus',4,'',11,'2008-06-27 11:26:58','2008-06-27 11:26:58'),(5,'Meeting',21,'Mesyuarat ini perlu dilakukan dalam bilik yang lebih besar!',11,'2008-08-05 09:20:39','2008-08-05 09:20:39'),(6,'Decision',20,'Mungkin boleh install cabinet di atas untuk lebih save space - hanya cadangan',28,'2008-08-05 10:44:53','2008-08-05 10:44:53'),(7,'Decision',22,'Mungkin boleh convert laporan dalam bentuk pdf untuk kegunaan orang awam di luar yang tiada OpenOffice',11,'2008-08-05 10:52:17','2008-08-05 10:52:17'),(8,'Meeting',21,'dd',11,'2008-08-12 09:24:02','2008-08-12 09:24:02'),(9,'Meeting',21,'tgr',11,'2008-08-12 09:36:50','2008-08-12 09:36:50'),(10,'Meeting',21,'qaz',11,'2008-08-12 09:46:29','2008-08-12 09:46:29'),(11,'Meeting',21,'aswqa',11,'2008-08-12 09:48:20','2008-08-12 09:48:20');
	192	INSERT INTO `comments` VALUES (2,'Userstatus',4,'ffffff',11,'2008-06-27 11:26:46','2008-06-27 11:26:46'),(3,'Userstatus',4,'',11,'2008-06-27 11:26:51','2008-06-27 11:26:51'),(4,'Userstatus',4,'',11,'2008-06-27 11:26:58','2008-06-27 11:26:58'),(5,'Meeting',21,'Mesyuarat ini perlu dilakukan dalam bilik yang lebih besar!',11,'2008-08-05 09:20:39','2008-08-05 09:20:39'),(6,'Decision',20,'Mungkin boleh install cabinet di atas untuk lebih save space - hanya cadangan',28,'2008-08-05 10:44:53','2008-08-05 10:44:53'),(7,'Decision',22,'Mungkin boleh convert laporan dalam bentuk pdf untuk kegunaan orang awam di luar yang tiada OpenOffice',11,'2008-08-05 10:52:17','2008-08-05 10:52:17'),(8,'Meeting',21,'dd',11,'2008-08-12 09:24:02','2008-08-12 09:24:02'),(9,'Meeting',21,'tgr',11,'2008-08-12 09:36:50','2008-08-12 09:36:50'),(10,'Meeting',21,'qaz',11,'2008-08-12 09:46:29','2008-08-12 09:46:29'),(11,'Meeting',21,'aswqa',11,'2008-08-12 09:48:20','2008-08-12 09:48:20'),(12,'Decision',20,'Tak boleh.. tak boleh.. apa ini nak install, install ni??',11,'2008-08-13 09:13:22','2008-08-13 09:13:22');
193	193	/!40000 ALTER TABLE `comments` ENABLE KEYS /;
194	194	UNLOCK TABLES;
…	…
209	209	`deleted_date` datetime default NULL,
210	210	PRIMARY KEY (`id`)
211		) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
	211	) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;
212	212	SET character_set_client = @saved_cs_client;
213	213
…	…
218	218	LOCK TABLES `committees` WRITE;
219	219	/!40000 ALTER TABLE `committees` DISABLE KEYS /;
220		INSERT INTO `committees` VALUES (6,'Sistem pemantauan Keputusan JITIK','JITIK','%xxxx/%yyyy',0,'0000-00-00 00:00:00'),(13,'MESYUARAT PENGURUSAN KANAN MAMPU','MPKM','Bilangan %xxxx Thn %yyyy',0,NULL);
	220	INSERT INTO `committees` VALUES (6,'Sistem pemantauan Keputusan JITIK','JITIK','%xxxx/%yyyy',0,'0000-00-00 00:00:00'),(13,'MESYUARAT PENGURUSAN KANAN MAMPU','MPKM','Bilangan %xxxx Thn %yyyy',0,NULL),(14,'my committee','mycom','%xxxx/%yyyy',0,NULL),(15,'re','re','%xxxx/%yyyy',0,NULL),(16,'bv','bv','%xxxx/%yyyy',0,NULL),(17,'ttt','ttt','%xxxx/%yyyy',0,NULL),(18,'sss','sss','%xxxx/%yyyy',0,NULL),(19,'vvv','vvv','%xxxx/%yyyy',0,NULL),(20,'nnn','nnn','%xxxx/%yyyy',0,NULL),(21,'mmm','mmm','%xxxx/%yyyy',0,NULL),(22,'rrr','rrr','%xxxx/%yyyy',0,NULL);
221	221	/!40000 ALTER TABLE `committees` ENABLE KEYS /;
222	222	UNLOCK TABLES;
…	…
237	237	`deleted_date` datetime default NULL,
238	238	PRIMARY KEY (`id`)
239		) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=latin1;
	239	) ENGINE=MyISAM AUTO_INCREMENT=80 DEFAULT CHARSET=latin1;
240	240	SET character_set_client = @saved_cs_client;
241	241
…	…
246	246	LOCK TABLES `committees_todos` WRITE;
247	247	/!40000 ALTER TABLE `committees_todos` DISABLE KEYS /;
248		INSERT INTO `committees_todos` VALUES (11,6,'Sediakan Nota Perbincangan ',1,0,'0000-00-00 00:00:00'),(12,6,'Sediakan Agenda ',1,0,'0000-00-00 00:00:00'),(13,6,'Sediakan peralatan meeting ',1,0,'0000-00-00 00:00:00'),(14,6,'Sediakan makanan ',1,0,'0000-00-00 00:00:00'),(15,6,'Sediakan Dokumen',1,0,'0000-00-00 00:00:00'),(16,7,'Sediakan Nota Perbincangan',1,0,'0000-00-00 00:00:00'),(17,7,'Sediakan Agenda',1,0,'0000-00-00 00:00:00'),(18,7,'Sediakan peralatan meeting',1,0,'0000-00-00 00:00:00'),(19,7,'Sediakan makanan',1,0,'0000-00-00 00:00:00'),(20,8,'Sediakan Nota Perbincangan',1,0,'0000-00-00 00:00:00'),(21,8,'Sediakan Agenda',1,0,'0000-00-00 00:00:00'),(22,8,'Sediakan peralatan meeting',1,0,'0000-00-00 00:00:00'),(23,8,'Sediakan makanan',1,0,'0000-00-00 00:00:00'),(24,9,'Sediakan Nota Perbincangan',1,0,'0000-00-00 00:00:00'),(25,9,'Sediakan Agenda',1,0,'0000-00-00 00:00:00'),(26,9,'Sediakan peralatan meeting',1,0,'0000-00-00 00:00:00'),(27,9,'Sediakan makanan',1,0,'0000-00-00 00:00:00'),(28,10,'Sediakan Nota Perbincangan',1,0,'0000-00-00 00:00:00'),(29,10,'Sediakan Agenda',1,0,'0000-00-00 00:00:00'),(30,10,'Sediakan peralatan meeting',1,0,'0000-00-00 00:00:00'),(31,10,'Sediakan makanan',1,0,'0000-00-00 00:00:00'),(32,11,'Sediakan Nota Perbincangan',1,0,'0000-00-00 00:00:00'),(33,11,'Sediakan Agenda',1,0,'0000-00-00 00:00:00'),(34,11,'Sediakan peralatan meeting',1,0,'0000-00-00 00:00:00'),(35,11,'Sediakan makanan',1,0,'0000-00-00 00:00:00'),(36,12,'Sediakan Nota Perbincangan',1,0,NULL),(37,12,'Sediakan Agenda',1,0,NULL),(38,12,'Sediakan peralatan meeting',1,0,NULL),(39,12,'Sediakan makanan',1,0,NULL),(40,13,'Sediakan Nota Perbincangan',1,0,NULL),(41,13,'Sediakan Agenda',1,0,NULL),(42,13,'Sediakan peralatan meeting',1,0,NULL),(43,13,'Sediakan makanan',1,0,NULL);
	248	INSERT INTO `committees_todos` VALUES (11,6,'Sediakan Nota Perbincangan ',1,0,'0000-00-00 00:00:00'),(12,6,'Sediakan Agenda ',1,0,'0000-00-00 00:00:00'),(13,6,'Sediakan peralatan meeting ',1,0,'0000-00-00 00:00:00'),(14,6,'Sediakan makanan ',1,0,'0000-00-00 00:00:00'),(15,6,'Sediakan Dokumen',1,0,'0000-00-00 00:00:00'),(16,7,'Sediakan Nota Perbincangan',1,0,'0000-00-00 00:00:00'),(17,7,'Sediakan Agenda',1,0,'0000-00-00 00:00:00'),(18,7,'Sediakan peralatan meeting',1,0,'0000-00-00 00:00:00'),(19,7,'Sediakan makanan',1,0,'0000-00-00 00:00:00'),(20,8,'Sediakan Nota Perbincangan',1,0,'0000-00-00 00:00:00'),(21,8,'Sediakan Agenda',1,0,'0000-00-00 00:00:00'),(22,8,'Sediakan peralatan meeting',1,0,'0000-00-00 00:00:00'),(23,8,'Sediakan makanan',1,0,'0000-00-00 00:00:00'),(24,9,'Sediakan Nota Perbincangan',1,0,'0000-00-00 00:00:00'),(25,9,'Sediakan Agenda',1,0,'0000-00-00 00:00:00'),(26,9,'Sediakan peralatan meeting',1,0,'0000-00-00 00:00:00'),(27,9,'Sediakan makanan',1,0,'0000-00-00 00:00:00'),(28,10,'Sediakan Nota Perbincangan',1,0,'0000-00-00 00:00:00'),(29,10,'Sediakan Agenda',1,0,'0000-00-00 00:00:00'),(30,10,'Sediakan peralatan meeting',1,0,'0000-00-00 00:00:00'),(31,10,'Sediakan makanan',1,0,'0000-00-00 00:00:00'),(32,11,'Sediakan Nota Perbincangan',1,0,'0000-00-00 00:00:00'),(33,11,'Sediakan Agenda',1,0,'0000-00-00 00:00:00'),(34,11,'Sediakan peralatan meeting',1,0,'0000-00-00 00:00:00'),(35,11,'Sediakan makanan',1,0,'0000-00-00 00:00:00'),(36,12,'Sediakan Nota Perbincangan',1,0,NULL),(37,12,'Sediakan Agenda',1,0,NULL),(38,12,'Sediakan peralatan meeting',1,0,NULL),(39,12,'Sediakan makanan',1,0,NULL),(40,13,'Sediakan Nota Perbincangan',1,0,NULL),(41,13,'Sediakan Agenda',1,0,NULL),(42,13,'Sediakan peralatan meeting',1,0,NULL),(43,13,'Sediakan makanan',1,0,NULL),(44,14,'Sediakan Nota Perbincangan',1,0,NULL),(45,14,'Sediakan Agenda',1,0,NULL),(46,14,'Sediakan peralatan meeting',1,0,NULL),(47,14,'Sediakan makanan',1,0,NULL),(48,15,'Sediakan Nota Perbincangan',1,0,NULL),(49,15,'Sediakan Agenda',1,0,NULL),(50,15,'Sediakan peralatan meeting',1,0,NULL),(51,15,'Sediakan makanan',1,0,NULL),(52,16,'Sediakan Nota Perbincangan',1,0,NULL),(53,16,'Sediakan Agenda',1,0,NULL),(54,16,'Sediakan peralatan meeting',1,0,NULL),(55,16,'Sediakan makanan',1,0,NULL),(56,17,'Sediakan Nota Perbincangan',1,0,NULL),(57,17,'Sediakan Agenda',1,0,NULL),(58,17,'Sediakan peralatan meeting',1,0,NULL),(59,17,'Sediakan makanan',1,0,NULL),(60,18,'Sediakan Nota Perbincangan',1,0,NULL),(61,18,'Sediakan Agenda',1,0,NULL),(62,18,'Sediakan peralatan meeting',1,0,NULL),(63,18,'Sediakan makanan',1,0,NULL),(64,19,'Sediakan Nota Perbincangan',1,0,NULL),(65,19,'Sediakan Agenda',1,0,NULL),(66,19,'Sediakan peralatan meeting',1,0,NULL),(67,19,'Sediakan makanan',1,0,NULL),(68,20,'Sediakan Nota Perbincangan',1,0,NULL),(69,20,'Sediakan Agenda',1,0,NULL),(70,20,'Sediakan peralatan meeting',1,0,NULL),(71,20,'Sediakan makanan',1,0,NULL),(72,21,'Sediakan Nota Perbincangan',1,0,NULL),(73,21,'Sediakan Agenda',1,0,NULL),(74,21,'Sediakan peralatan meeting',1,0,NULL),(75,21,'Sediakan makanan',1,0,NULL),(76,22,'Sediakan Nota Perbincangan',1,0,NULL),(77,22,'Sediakan Agenda',1,0,NULL),(78,22,'Sediakan peralatan meeting',1,0,NULL),(79,22,'Sediakan makanan',1,0,NULL);
249	249	/!40000 ALTER TABLE `committees_todos` ENABLE KEYS /;
250	250	UNLOCK TABLES;
…	…
263	263	`role_id` int(11) NOT NULL default '0',
264	264	PRIMARY KEY (`id`)
265		) ENGINE=MyISAM AUTO_INCREMENT=128 DEFAULT CHARSET=latin1;
	265	) ENGINE=MyISAM AUTO_INCREMENT=134 DEFAULT CHARSET=latin1;
266	266	SET character_set_client = @saved_cs_client;
267	267
…	…
272	272	LOCK TABLES `committees_users` WRITE;
273	273	/!40000 ALTER TABLE `committees_users` DISABLE KEYS /;
274		INSERT INTO `committees_users` VALUES (119,27,13,0),(125,14,6,0),(16,12,6,6),(15,13,6,6),(108,16,7,0),(118,26,13,0),(84,11,9,0),(83,11,8,0),(82,11,7,0),(113,21,13,0),(107,16,6,0),(109,16,9,0),(110,11,13,5),(121,29,13,0),(81,11,6,5),(117,25,13,0),(86,11,11,0),(85,11,10,5),(126,14,13,0),(124,10,13,0),(115,23,13,0),(120,28,13,6),(112,22,13,0),(123,10,6,0),(106,11,12,1),(122,30,13,0);
	274	INSERT INTO `committees_users` VALUES (119,27,13,0),(125,14,6,0),(16,12,6,6),(15,13,6,6),(108,16,7,0),(118,26,13,0),(84,11,9,0),(83,11,8,0),(82,11,7,0),(113,21,13,0),(107,16,6,0),(109,16,9,0),(110,11,13,5),(121,29,13,0),(81,11,6,5),(117,25,13,0),(86,11,11,0),(85,11,10,5),(126,14,13,0),(124,10,13,0),(115,23,13,0),(120,28,13,6),(112,22,13,0),(123,10,6,0),(106,11,12,1),(122,30,13,0),(128,11,14,1),(129,11,17,5),(130,11,19,6),(131,11,20,5),(132,11,21,5),(133,11,22,5);
275	275	/!40000 ALTER TABLE `committees_users` ENABLE KEYS /;
276	276	UNLOCK TABLES;
…	…
285	285	CREATE TABLE `decisions` (
286	286	`id` int(11) NOT NULL auto_increment,
	287	`committee_id` int(11) NOT NULL,
287	288	`meeting_id` int(11) NOT NULL,
288	289	`item_id` int(11) NOT NULL,
…	…
295	296	`updated` datetime default NULL,
296	297	PRIMARY KEY (`id`)
297		) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
	298	) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;
298	299	SET character_set_client = @saved_cs_client;
299	300
…	…
304	305	LOCK TABLES `decisions` WRITE;
305	306	/!40000 ALTER TABLE `decisions` DISABLE KEYS /;
306		INSERT INTO `decisions` VALUES (4,14,5,'','<p><span class=\\\"contentdetails\\\">Jabatan Ketua Pengarah Tanah dan Galian (JKPTG) diminta melaporkan status kemajuan projek e-Consent selewat-lewatnya pada 9 Julai 2007 </span></p>','2008-09-26',0,'0000-00-00 00:00:00','2008-06-17 10:32:32','2008-07-31 12:50:05'),(5,16,5,'','<p>Jabatan Ketua Pengarah Tanah dan Galian (JKPTG) memaklumkan kemajuan e-Consent selewat-lewatnya pada 20 September 2007</p>','2008-06-20',0,'0000-00-00 00:00:00','2008-06-17 10:40:19','2008-06-17 10:40:19'),(6,15,7,'','<p><span class=\\\"contentdetails\\\">NRE mengambil kira pandangan Ketua Audit Negara berkaitan perkara-perkara berikut: (a) Kos peluasan e-Tanah yang dicadangkan adalah tinggi; (b) NRE mengelakkan pertindihan/lebihan perkakasan dari keperluan sebenar semasa membuat perolehan; (c) Change management perlu diberi penekanan bagi meningkatkan tahap kesediaan agensi-agensi dari segi penerimaan sistem; dan (d) Tahap kejayaan perintis e-Tanah di Pulau Pinang perlu diambil kira di dalam peluasan e-Tanah.</span></p>','2008-09-26',0,'0000-00-00 00:00:00','2008-06-17 16:24:24','2008-07-31 12:50:41'),(7,15,7,'','<p><span class=\\\"contentdetails\\\">Kementerian Sumber Asli dan Alam Sekitar (NRE) perlu melaksanakan semula rundingan harga bagi peluasan e-Tanah dengan mengambil kira pandangan daripada Kementerian Kewangan untuk mengeluarkan beberapa komponen dari skop projek peluasan e-Tanah selewat-lewatnya pada 12 Oktober 2007;</span></p>','2008-09-26',0,'0000-00-00 00:00:00','2008-06-17 16:24:57','2008-07-31 12:50:52'),(8,15,5,'','<p>Aplikasi e-Consent yang dibangunkan oleh JKPTG berdasarkan model asal di Negeri Terengganu diperluaskan penggunaannya ke pejabat-pejabat tanah di Semenanjung Malaysia. E-Consent akan mula digunakan secara live mulai 21 Mei 2007 secara berperingkat dan dijangka siap pada 31 Mei 2007.</p>','0000-00-00',1,'2008-06-17 16:29:19','2008-06-17 16:28:48','2008-06-17 16:29:19'),(9,15,7,'','<p>Aplikasi e-Consent yang dibangunkan oleh JKPTG berdasarkan model asal di Negeri Terengganu diperluaskan penggunaannya ke pejabat-pejabat tanah di Semenanjung Malaysia. E-Consent akan mula digunakan secara live mulai 21 Mei 2007 secara berperingkat dan dijangka siap pada 31 Mei 2007.</p>','2008-09-26',0,'0000-00-00 00:00:00','2008-06-17 16:29:35','2008-07-31 12:51:04'),(10,17,7,'','<p>Kementerian Sumber Asli dan Alam Sekitar (NRE) mengemukakan pelan dan senarai semak (checklist) tindakan bagi peluasan e-Tanah ke seluruh Pulau Pinang yang lebih terperinci selewat-lewatnya pada 5 April 2007. Pelan dan senarai semak ini perlu mengambil kira arkitektur e-Tanah yang sedia ada.</p>','2008-07-15',0,'0000-00-00 00:00:00','2008-06-17 16:31:02','2008-07-31 12:53:14'),(18,21,0,'','<p>Mesyuarat BERSETUJU :</p>\r\n<ol>\r\n<li> supaya laporan penemuan SSR MAMPU dikemukaka secara rasmi kepada Ketua Pengarah MAMPU untuk tindakan susulan;</li>\r\n<li>supaya kelemahan-kelemahan yang dibangkitkan melalui urusan SSR MAMPU ditangani oleh Bahagian-bahagian:</li>\r\n<li>supaya usaha mengurangkan karenah birokrasi di MAMPU dijadikan sebagai sebahagian agenda tetap semasa Mesyuarat Pengurusan MAMPU; dan</li>\r\n<li>Supaya satu sesi kesedaran mengenai SSR MAMPU diadakan untuk warga MAMPU Cawangan Sabah dan Sarawak.</li>\r\n</ol>','0000-00-00',1,'2008-08-04 16:30:04','2008-08-04 16:27:32','2008-08-04 16:30:04'),(19,21,12,'','<p>Mesyuarat BERSETUJU :</p>\r\n<ol> </ol>\r\n<p>1. supaya laporan penemuan SSR MAMPU dikemukaka secara rasmi kepada Ketua Pengarah MAMPU untuk tindakan susulan;<br />2. supaya kelemahan-kelemahan yang dibangkitkan melalui urusan SSR MAMPU ditangani oleh Bahagian-bahagian:<br />3. supaya usaha mengurangkan karenah birokrasi di MAMPU dijadikan sebagai sebahagian agenda tetap semasa Mesyuarat Pengurusan MAMPU; dan<br />4. Supaya satu sesi kesedaran mengenai SSR MAMPU diadakan untuk warga MAMPU Cawangan Sabah dan Sarawak.</p>\r\n<ul>\r\n</ul>\r\n<ol> </ol>','2008-08-29',0,NULL,'2008-08-04 16:30:44','2008-08-05 12:28:58'),(20,21,13,'','<p>1. Mesyuarat mengambil maklum bahawa satu aktiviti gotong- royong telah diadakan pada 26 April 2008 untuk membersihkan bilik-bilik stor di MAMPU dan melupuskan perabot-perabot serta perkakasan lama. Rak-rak tambahan juga telah disediakan sebagai langkah supaya bilik-bilik stor sentiasa kemas dan tersusun.<br />2. Mesyuarat mengambil perhatian akan keterangan bahawa pelupusan peralatan komputer telah dibuat berdasarkan tatacara pelupusan awam yang diguna pakai. <br />3. Mesyuarat BERSETUJU supaya BKPSM membuat pemantauan berterusan untuk memastikan keadaan bilik stor di setiap Bahagian sentiasa kemas dan tersusun.</p>\r\n<ol> </ol>','2008-08-07',0,NULL,'2008-08-04 16:35:51','2008-08-05 12:28:26'),(21,21,14,'','<p>1. Mesyuarat mengambil maklum bahawa satu  kertas  berhubung perkara ini sedang disediakan untuk pertimbangan Mesyuarat 3P.</p>\r\n<ol> </ol>','2008-08-01',0,NULL,'2008-08-04 16:38:12','2008-08-05 12:29:14'),(22,21,15,'','<p>1. Mesyuarat mengambil maklum bahawa seminar Government of the Future akan diadakan pada 14 dan 15 Jun 2008.</p>\r\n<ol> </ol>\r\n<p style=\\\"\\\\\\\"> </p>','2008-08-22',0,NULL,'2008-08-04 16:40:25','2008-08-05 12:29:32'),(23,22,16,'','<p>1. Y.Bhg Pengerusi memaklumkan bahawa MAMPU perlu mengambil tindakan segera untuk mengeluarkan lebih banyak penerbitan mengenai MAMPU dan Sektor Awam bagi kegunaan program-program dalam negeri dan luar negara.  Oleh   yang   demikian,  Y.Bhg.  Pengerusi menyarankan supaya aktiviti penerbitan MAMPU digiatkan semula bagi menghasilkan lebih banyak bahan penerbitan.</p>\r\n<ol> </ol>\r\n<p> </p>','2008-07-03',0,NULL,'2008-08-04 17:34:07','2008-08-05 12:30:24'),(24,22,15,'','<p>1. Mesyuarat mengambil maklum bahawa   Seminar Government of the Future (GOF) telah diadakan pada 14 dan 15 Jun 2008 di INTAN Bukit Kiara, Kuala Lumpur.</p>\r\n<p>2. Mesyuarat mengambil perhatian akan keterangan:</p>\r\n<ol> </ol>\r\n<p>- bahawa laporan seminar tersebut sedang disediakan oleh pihak INTAN; dan<br />- bahawa Mesyuarat Panel 3P memutuskan supaya siri GOF yang akan datang dikendalikan sepenuhnya oleh INTAN dan MAMPU tanpa melibatkan perunding luar bagi mengurangkan kos yang ditanggung oleh Kerajaan.</p>\r\n<ul>\r\n</ul>\r\n<p>3. Mesyuarat BERSETUJU supaya kertas-kertas kerja seminar tersebut disediakan di Perpustakaan MAMPU untuk rujukan pegawai-pegawai MAMPU.</p>\r\n<ol> </ol>','2008-08-05',0,NULL,'2008-08-04 17:55:21','2008-08-05 12:31:06');
	307	INSERT INTO `decisions` VALUES (4,0,14,5,'','<p><span class=\\\"contentdetails\\\">Jabatan Ketua Pengarah Tanah dan Galian (JKPTG) diminta melaporkan status kemajuan projek e-Consent selewat-lewatnya pada 9 Julai 2007 </span></p>','2008-09-26',0,'0000-00-00 00:00:00','2008-06-17 10:32:32','2008-07-31 12:50:05'),(5,0,16,5,'','<p>Jabatan Ketua Pengarah Tanah dan Galian (JKPTG) memaklumkan kemajuan e-Consent selewat-lewatnya pada 20 September 2007</p>','2008-06-20',0,'0000-00-00 00:00:00','2008-06-17 10:40:19','2008-06-17 10:40:19'),(6,0,15,7,'','<p><span class=\\\"contentdetails\\\">NRE mengambil kira pandangan Ketua Audit Negara berkaitan perkara-perkara berikut: (a) Kos peluasan e-Tanah yang dicadangkan adalah tinggi; (b) NRE mengelakkan pertindihan/lebihan perkakasan dari keperluan sebenar semasa membuat perolehan; (c) Change management perlu diberi penekanan bagi meningkatkan tahap kesediaan agensi-agensi dari segi penerimaan sistem; dan (d) Tahap kejayaan perintis e-Tanah di Pulau Pinang perlu diambil kira di dalam peluasan e-Tanah.</span></p>','2008-09-26',0,'0000-00-00 00:00:00','2008-06-17 16:24:24','2008-07-31 12:50:41'),(7,0,15,7,'','<p><span class=\\\"contentdetails\\\">Kementerian Sumber Asli dan Alam Sekitar (NRE) perlu melaksanakan semula rundingan harga bagi peluasan e-Tanah dengan mengambil kira pandangan daripada Kementerian Kewangan untuk mengeluarkan beberapa komponen dari skop projek peluasan e-Tanah selewat-lewatnya pada 12 Oktober 2007;</span></p>','2008-09-26',0,'0000-00-00 00:00:00','2008-06-17 16:24:57','2008-07-31 12:50:52'),(8,0,15,5,'','<p>Aplikasi e-Consent yang dibangunkan oleh JKPTG berdasarkan model asal di Negeri Terengganu diperluaskan penggunaannya ke pejabat-pejabat tanah di Semenanjung Malaysia. E-Consent akan mula digunakan secara live mulai 21 Mei 2007 secara berperingkat dan dijangka siap pada 31 Mei 2007.</p>','0000-00-00',1,'2008-06-17 16:29:19','2008-06-17 16:28:48','2008-06-17 16:29:19'),(9,0,15,7,'','<p>Aplikasi e-Consent yang dibangunkan oleh JKPTG berdasarkan model asal di Negeri Terengganu diperluaskan penggunaannya ke pejabat-pejabat tanah di Semenanjung Malaysia. E-Consent akan mula digunakan secara live mulai 21 Mei 2007 secara berperingkat dan dijangka siap pada 31 Mei 2007.</p>','2008-09-26',0,'0000-00-00 00:00:00','2008-06-17 16:29:35','2008-07-31 12:51:04'),(10,0,17,7,'','<p>Kementerian Sumber Asli dan Alam Sekitar (NRE) mengemukakan pelan dan senarai semak (checklist) tindakan bagi peluasan e-Tanah ke seluruh Pulau Pinang yang lebih terperinci selewat-lewatnya pada 5 April 2007. Pelan dan senarai semak ini perlu mengambil kira arkitektur e-Tanah yang sedia ada.</p>','2008-07-15',0,'0000-00-00 00:00:00','2008-06-17 16:31:02','2008-07-31 12:53:14'),(18,0,21,0,'','<p>Mesyuarat BERSETUJU :</p>\r\n<ol>\r\n<li> supaya laporan penemuan SSR MAMPU dikemukaka secara rasmi kepada Ketua Pengarah MAMPU untuk tindakan susulan;</li>\r\n<li>supaya kelemahan-kelemahan yang dibangkitkan melalui urusan SSR MAMPU ditangani oleh Bahagian-bahagian:</li>\r\n<li>supaya usaha mengurangkan karenah birokrasi di MAMPU dijadikan sebagai sebahagian agenda tetap semasa Mesyuarat Pengurusan MAMPU; dan</li>\r\n<li>Supaya satu sesi kesedaran mengenai SSR MAMPU diadakan untuk warga MAMPU Cawangan Sabah dan Sarawak.</li>\r\n</ol>','0000-00-00',1,'2008-08-04 16:30:04','2008-08-04 16:27:32','2008-08-04 16:30:04'),(19,0,21,12,'','<p>Mesyuarat BERSETUJU :</p>\r\n<ol> </ol>\r\n<p>1. supaya laporan penemuan SSR MAMPU dikemukaka secara rasmi kepada Ketua Pengarah MAMPU untuk tindakan susulan;<br />2. supaya kelemahan-kelemahan yang dibangkitkan melalui urusan SSR MAMPU ditangani oleh Bahagian-bahagian:<br />3. supaya usaha mengurangkan karenah birokrasi di MAMPU dijadikan sebagai sebahagian agenda tetap semasa Mesyuarat Pengurusan MAMPU; dan<br />4. Supaya satu sesi kesedaran mengenai SSR MAMPU diadakan untuk warga MAMPU Cawangan Sabah dan Sarawak.</p>\r\n<ul>\r\n</ul>\r\n<ol> </ol>','2008-08-29',0,NULL,'2008-08-04 16:30:44','2008-08-05 12:28:58'),(20,0,21,13,'','<p>1. Mesyuarat mengambil maklum bahawa satu aktiviti gotong- royong telah diadakan pada 26 April 2008 untuk membersihkan bilik-bilik stor di MAMPU dan melupuskan perabot-perabot serta perkakasan lama. Rak-rak tambahan juga telah disediakan sebagai langkah supaya bilik-bilik stor sentiasa kemas dan tersusun.<br />2. Mesyuarat mengambil perhatian akan keterangan bahawa pelupusan peralatan komputer telah dibuat berdasarkan tatacara pelupusan awam yang diguna pakai. <br />3. Mesyuarat BERSETUJU supaya BKPSM membuat pemantauan berterusan untuk memastikan keadaan bilik stor di setiap Bahagian sentiasa kemas dan tersusun.</p>\r\n<ol> </ol>','2008-08-07',0,NULL,'2008-08-04 16:35:51','2008-08-13 09:13:22'),(21,0,21,14,'','<p>1. Mesyuarat mengambil maklum bahawa satu  kertas  berhubung perkara ini sedang disediakan untuk pertimbangan Mesyuarat 3P.</p>\r\n<ol> </ol>','2008-08-01',0,NULL,'2008-08-04 16:38:12','2008-08-05 12:29:14'),(22,0,21,15,'','<p>1. Mesyuarat mengambil maklum bahawa seminar Government of the Future akan diadakan pada 14 dan 15 Jun 2008.</p>\r\n<ol> </ol>\r\n<p style=\\\"\\\\\\\"> </p>','2008-08-22',0,NULL,'2008-08-04 16:40:25','2008-08-05 12:29:32'),(23,0,22,16,'','<p>1. Y.Bhg Pengerusi memaklumkan bahawa MAMPU perlu mengambil tindakan segera untuk mengeluarkan lebih banyak penerbitan mengenai MAMPU dan Sektor Awam bagi kegunaan program-program dalam negeri dan luar negara.  Oleh   yang   demikian,  Y.Bhg.  Pengerusi menyarankan supaya aktiviti penerbitan MAMPU digiatkan semula bagi menghasilkan lebih banyak bahan penerbitan.</p>\r\n<ol> </ol>\r\n<p> </p>','2008-07-03',0,NULL,'2008-08-04 17:34:07','2008-08-05 12:30:24'),(24,0,22,15,'','<p>1. Mesyuarat mengambil maklum bahawa   Seminar Government of the Future (GOF) telah diadakan pada 14 dan 15 Jun 2008 di INTAN Bukit Kiara, Kuala Lumpur.</p>\r\n<p>2. Mesyuarat mengambil perhatian akan keterangan:</p>\r\n<ol> </ol>\r\n<p>- bahawa laporan seminar tersebut sedang disediakan oleh pihak INTAN; dan<br />- bahawa Mesyuarat Panel 3P memutuskan supaya siri GOF yang akan datang dikendalikan sepenuhnya oleh INTAN dan MAMPU tanpa melibatkan perunding luar bagi mengurangkan kos yang ditanggung oleh Kerajaan.</p>\r\n<ul>\r\n</ul>\r\n<p>3. Mesyuarat BERSETUJU supaya kertas-kertas kerja seminar tersebut disediakan di Perpustakaan MAMPU untuk rujukan pegawai-pegawai MAMPU.</p>\r\n<ol> </ol>','2008-08-05',0,NULL,'2008-08-04 17:55:21','2008-08-05 12:31:06'),(25,0,14,6,'','<p>Hello there</p>','0000-00-00',0,NULL,'2008-09-03 16:14:24','2008-09-03 16:14:24'),(26,6,14,4,'','<p>gggg</p>','0000-00-00',0,NULL,'2008-09-03 16:27:49','2008-09-03 16:33:06');
307	308	/!40000 ALTER TABLE `decisions` ENABLE KEYS /;
308	309	UNLOCK TABLES;
…	…
320	321	`group_id` int(11) NOT NULL,
321	322	PRIMARY KEY (`id`)
322		) ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=latin1;
	323	) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=latin1;
323	324	SET character_set_client = @saved_cs_client;
324	325
…	…
329	330	LOCK TABLES `decisions_groups` WRITE;
330	331	/!40000 ALTER TABLE `decisions_groups` DISABLE KEYS /;
331		INSERT INTO `decisions_groups` VALUES (8,4,5),(10,7,7),(9,7,6),(11,9,7),(13,10,7),(12,10,6),(53,19,12),(52,19,11),(51,19,10),(50,20,13),(54,21,10),(55,22,15),(56,23,15),(57,24,15);
	332	INSERT INTO `decisions_groups` VALUES (8,4,5),(10,7,7),(9,7,6),(11,9,7),(13,10,7),(12,10,6),(53,19,12),(52,19,11),(51,19,10),(50,20,13),(54,21,10),(55,22,15),(56,23,15),(57,24,15),(58,26,7);
332	333	/!40000 ALTER TABLE `decisions_groups` ENABLE KEYS /;
333	334	UNLOCK TABLES;
…	…
345	346	`user_id` int(11) NOT NULL,
346	347	PRIMARY KEY (`id`)
347		) ENGINE=MyISAM AUTO_INCREMENT=112 DEFAULT CHARSET=latin1;
	348	) ENGINE=MyISAM AUTO_INCREMENT=121 DEFAULT CHARSET=latin1;
348	349	SET character_set_client = @saved_cs_client;
349	350
…	…
354	355	LOCK TABLES `decisions_users` WRITE;
355	356	/!40000 ALTER TABLE `decisions_users` DISABLE KEYS /;
356		INSERT INTO `decisions_users` VALUES (34,4,12),(10,5,12),(11,5,11),(36,6,11),(35,6,13),(38,7,11),(37,7,13),(39,9,13),(40,9,11),(41,10,11),(21,11,11),(22,13,13),(23,14,12),(24,14,14),(25,14,13),(26,14,16),(27,14,11),(28,15,14),(29,15,13),(30,15,16),(31,15,11),(32,16,11),(97,20,14),(98,20,25),(99,19,28),(100,19,10),(101,19,23),(102,19,27),(105,21,27),(104,21,23),(103,21,28),(107,22,21),(106,22,22),(109,23,21),(108,23,22),(110,24,22),(111,24,21);
	357	INSERT INTO `decisions_users` VALUES (34,4,12),(10,5,12),(11,5,11),(36,6,11),(35,6,13),(38,7,11),(37,7,13),(39,9,13),(40,9,11),(41,10,11),(21,11,11),(22,13,13),(23,14,12),(24,14,14),(25,14,13),(26,14,16),(27,14,11),(28,15,14),(29,15,13),(30,15,16),(31,15,11),(32,16,11),(97,20,14),(98,20,25),(99,19,28),(100,19,10),(101,19,23),(102,19,27),(105,21,27),(104,21,23),(103,21,28),(107,22,21),(106,22,22),(109,23,21),(108,23,22),(110,24,22),(111,24,21),(112,25,14),(113,25,13),(114,25,16),(120,26,16),(119,26,13),(118,26,14);
357	358	/!40000 ALTER TABLE `decisions_users` ENABLE KEYS /;
358	359	UNLOCK TABLES;
…	…
394	395	CREATE TABLE `groupstatuses` (
395	396	`id` int(11) NOT NULL auto_increment,
	397	`committee_id` int(11) NOT NULL,
396	398	`decision_id` int(11) NOT NULL,
397	399	`user_id` int(11) NOT NULL,
…	…
406	408	`updated` datetime default NULL,
407	409	PRIMARY KEY (`id`)
408		) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
	410	) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
409	411	SET character_set_client = @saved_cs_client;
410	412
…	…
415	417	LOCK TABLES `groupstatuses` WRITE;
416	418	/!40000 ALTER TABLE `groupstatuses` DISABLE KEYS /;
417		INSERT INTO `groupstatuses` VALUES (3,~~22,11,15,'Laporan seminar seperti disertakan.','2008-08-07',0,'0000-00-00 00:00:00',0,NULL,'2008-08-05 10:50:17','2008-08-05 10:50:17~~');
	419	INSERT INTO `groupstatuses` VALUES (3,0,22,11,15,'Laporan seminar seperti disertakan.','2008-08-07',0,'0000-00-00 00:00:00',0,NULL,'2008-08-05 10:50:17','2008-08-05 10:50:17'),(4,6,26,11,7,'zzzzzz','0000-00-00',0,'0000-00-00 00:00:00',0,NULL,'2008-09-03 16:33:30','2008-09-03 16:33:30');
418	420	/!40000 ALTER TABLE `groupstatuses` ENABLE KEYS /;
419	421	UNLOCK TABLES;
…	…
477	479	`minutes_raw` text,
478	480	PRIMARY KEY (`id`)
479		) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
	481	) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;
480	482	SET character_set_client = @saved_cs_client;
481	483
…	…
486	488	LOCK TABLES `meetings` WRITE;
487	489	/!40000 ALTER TABLE `meetings` DISABLE KEYS /;
488		INSERT INTO `meetings` VALUES (10,0,6,'BIL. 1/2008','BIL. 1/2008','2008-06-02 09:50:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'Bilik Conference, MAMPU','','','0000-00-00',1,'2008-06-17 10:03:55','2008-06-17','2008-06-17',''),(11,0,6,'BIL. 2/2008','BIL. 2/2008','2008-06-03 10:01:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'Bilik diskusi, MAMPU','','','0000-00-00',1,'2008-06-17 10:03:58','2008-06-17','2008-06-17',''),(12,0,6,'BIL. 1/2008','BIL. 1/2008','2008-06-02 10:04:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'Bilik conference, MAMPU','','','0000-00-00',1,'2008-06-17 10:10:04','2008-06-17','2008-06-17',''),(13,0,6,'BIL. 2/2008','BIL. 2/2008','2008-06-05 10:04:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'Bilik Diskusi, MAMPU','','','0000-00-00',1,'2008-06-17 10:10:07','2008-06-17','2008-06-17',''),(14,0,6,'BIL. 1/2008','BIL. 1/2008','2008-08-29 10:10:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'Bilik Conference, MAMPU','','<h1>1. PERUTUSAN PENGERUSI</h1>\r\n<ol>\r\n<li>Y.Brs. Pengerusi mengucapkan terima kasih kepada semua yang hadir pada mesyuarat kali ini dan memaklumkan bahawa Y.Bhg Dato\' Ketua Pengarah tidak dapat mempengerusikan mesyuaratini kerana ada tugas lain yang perlu diutamakan. Seterusnya Y.Bhg Pengerusi memaklumkan perkara-perkara seperti berikut :<ol>\r\n<li>Kemahiran dan kompetensi adalah penting dan bukan sahaja bilangan agensi yang menggunakan OSS sahaja. Peningkatan kepakaran perlu diutamakan seperti modal insan.<br /><br /></li>\r\n</ol></li>\r\n</ol>\r\n<p> </p>\r\n<h1>2. KEPUTUSAN MESYUARAT</h1>\r\n<ol>\r\n<li>Mesyuarat bersetuju terhadap perkara-perkara berikut :<ol>\r\n<li>Buat tindakan suslan dengan agensi yang berminat sebelum {{26/06/2008}} oleh ((ahmad)) bagi project [[MyMeeting]]. <br /></li>\r\n<li>Buat tindakan suslan dengan agensi yang berminat sebelum {{28/06/2008}} oleh ((ggggg)) bagi project [[MyMeeting]]. </li>\r\n</ol></li>\r\n</ol>','0000-00-00',0,'0000-00-00 00:00:00','2008-06-17','2008-07-09','<p>apa niiiiiiiiiiiiiiii</p>'),(15,0,6,'BIL. 2/2008','BIL. 2/2008','2008-06-04 10:10:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'Bilik Diskusi, MAMPU','','','0000-00-00',0,'0000-00-00 00:00:00','2008-06-17','2008-06-17','<h1>hal-hal lain</h1>\r\n<ol>\r\n<li>thgdkjyroyer<ol>\r\n<li>hfhjtuiytiyit</li>\r\n<li>hdjutru</li>\r\n<li>utruitu</li>\r\n</ol></li>\r\n</ol>\r\n<h1>Keputusan Mesyuarat</h1>\r\n<ol>\r\n<li>hjklfjljulyu<ol>\r\n<li>jhljuoutio {{admin}}<br /></li>\r\n</ol></li>\r\n</ol>'),(16,14,6,'BIL. 9/2008','BIL. 9/2008','2008-06-05 10:39:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'bilik Conference, MAMPU','','','0000-00-00',0,'0000-00-00 00:00:00','2008-06-17','2008-06-17',''),(17,15,6,'BIL. 2/2008','BIL. 2/2008','2008-06-11 16:30:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'Bilik Conference','','','0000-00-00',0,'0000-00-00 00:00:00','2008-06-17','2008-06-17',''),(18,0,6,'Bil 1/2008','technical meeting','2008-06-26 15:53:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'re','','<h1>1. PERUTUSAN PENGERUSI</h1>\r\n<ol>\r\n<li>Y.Brs. Pengerusi mengucapkan terima kasih kepada semua yang hadir pada mesyuarat kali ini dan memaklumkan bahawa Y.Bhg Dato\' Ketua Pengarah tidak dapat mempengerusikan mesyuaratini kerana ada tugas lain yang perlu diutamakan. Seterusnya Y.Bhg Pengerusi memaklumkan perkara-perkara seperti berikut :&