BdsXRFhn

1staffs
2
3CREATE TABLE IF NOT EXISTS `staffs` (
4  `id` int(11) NOT NULL AUTO_INCREMENT,
5  `name` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
6  `department_id` int(11) DEFAULT NULL,
7  `designation_id` int(11) DEFAULT NULL,
8  `username` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
9  `emailid` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
10  `staffrights` tinyint(2) DEFAULT '0',
11  `staffstatus` tinyint(2) DEFAULT '1',
12  PRIMARY KEY (`id`)
13) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
14designations
15
16CREATE TABLE IF NOT EXISTS `designations` (
17  `id` int(11) NOT NULL AUTO_INCREMENT,
18  `designname` varchar(150) NOT NULL,
19  `designation_group_id` varchar(250) NOT NULL,
20  PRIMARY KEY (`id`)
21) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
22
23
24
25designation_group 
26
27
28CREATE TABLE IF NOT EXISTS `designation_group` (
29  `id` int(11) NOT NULL AUTO_INCREMENT,
30  `group_name` text NOT NULL,
31  PRIMARY KEY (`id`)
32) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
33	
34public function getDesignations() {
35        return $this->hasOne( Designations::className(), ['id' => 'designation_id']);
36    }
37	
38public function getDesgroupstaffs(){
39        return $this->hasOne(Designations::className() , ['id' => 'id'])
40                    ->from(Designationgroup::tableName() ) ;
41}
42	
43public function getDesignation()
44{
45   return $this->hasOne(Designation::className(),['designation_id'=>'id]);
46}
47	
48public function getDesignationGroup()
49{
50   return $this->hasOne(DesignationGroup::className(),['id'=>'designation_group_id]);
51}
52	
53$model->destination->designationGroup->group_name
54	
55contact | contact groups
56-------------------------
57contact #1 | business1, business2, family
58contact #2 | family
59contact #3 | student, partner
60	
61public function getDesignation()
62{
63   return $this->hasOne(Designation::className(),['designation_id'=>'id])->with(['designationgroup']);
64}
65	
66public function getDesignationgroup()
67{
68   return $this->hasOne(DesignationGroup::className(),['id'=>'designation_group_id]);
69}
70	
71$model->destination->designationgroup->group_name