public function getTeamListByUser($userid)
{
$teamlist = TeamMember::find()->where(['user_id' => $userid])->all();
$teamid = [];
foreach ($teamlist as $team) {
$teamid[] = $team->team_id;
}
return $teamid;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = TeamMember::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'team_id' => $this->team_id, 'user_id' => $this->user_id, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]);
return $dataProvider;
}
public function addTeam()
{
$addlist = [];
$dellist = [];
$teamlist = TeamMember::find()->where(['user_id' => $this->id])->all();
foreach ($teamlist as $oldteam) {
$flag = 0;
foreach ($this->team as $i) {
if ($oldteam->team_id == $i) {
$flag = 1;
}
}
if ($flag == 0) {
$dellist[] = $oldteam->team_id;
}
}
foreach ($this->team as $newindex) {
$flag = 0;
foreach ($teamlist as $oldteam) {
if ($oldteam->team_id == $newindex) {
$flag = 1;
}
}
if ($flag == 0) {
$addlist[] = $newindex;
}
}
foreach ($addlist as $addindex) {
$newteam = new TeamMember(['team_id' => $addindex, 'user_id' => $this->id]);
$newteam->save();
}
foreach ($dellist as $delindex) {
$deltarget = TeamMember::getObjectById($delindex, $this->id);
$deltarget->delete();
}
}
