public function searchRecentBoard($params, $size)
{
$query = Board::find()->orderBy(['created_at' => SORT_DESC]);
$dataProvider->sort->attributes['id'] = ['asc' => ['id' => SORT_ASC], 'desc' => ['id' => SORT_DESC]];
$dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => SORT_DESC]], 'pagination' => ['pageSize' => $size]]);
$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;
}
return $dataProvider;
}
public function delMember($id)
{
if (!Auth::check()) {
return redirect("/");
}
$memberID = \Input::get('memberID');
$member = Membermanagement::find($memberID);
$member->active = 1;
$member->save();
$board = Board::find($id);
$boardManager = $board->manager_id;
$MemMa = Membermanagement::where('User_id', '=', $boardManager)->where('Board_id', '=', $id)->get();
$cards = Card::where('MemberManagement_id', '=', $member->id)->get();
foreach ($cards as $card) {
$card->MemberManagement_id = $MemMa[0]->id;
$card->save();
}
return redirect("member/{$id}");
}
public function init()
{
parent::init();
$this->user = \Yii::$app->user->identity;
$actionParams = \Yii::$app->urlManager->parseRequest(\Yii::$app->request)[1];
if (!isset($actionParams['name'])) {
return;
}
$name = $actionParams['name'];
$board = Board::find()->where(['name' => $name])->one();
if (!$board) {
return;
}
$this->boardRights = $this->user->getBoardRights($board->id)->one();
if (!isset($actionParams['threadNum'])) {
return;
}
$threadNum = $actionParams['threadNum'];
$thread = $board->getThreads()->where(['number' => $threadNum])->one();
$this->threadChatRights = $this->user->getThreadChatRights($thread->id)->one();
}
public function countBoard()
{
$count = count(Board::find()->all());
return $count;
}
public function removeCard()
{
if (!Auth::check()) {
return redirect("/");
}
$reCard = Card::find($cardId);
$board = Board::find($reCard->Board_id);
if (Auth::user()->id != $Board->manager_id) {
return redirect("/");
}
$cardId = Input::get('card');
$check = Checklist::where('Card_id', '=', $cardId);
$check->delete();
$com = Comment::where('Card_id', '=', $cardId);
$com->delete();
$reCard->delete();
return $cardId;
}
public function boardPostInComplete()
{
if (!Auth::check()) {
return redirect("/");
}
if (Auth::user()->Level_id == 1) {
return redirect('/managementAccount');
}
$board = Board::find(session()->get('Board'));
if (Auth::user()->id != $board->manager_id) {
return redirect("/");
}
$board->status_complete = 0;
$board->end_date = null;
$board->save();
}
/**
* Deletes board
* @param $name
*/
public function actionDelete($name)
{
$board = Board::find()->where(['name' => $name])->limit(1)->one();
if ($board) {
$board->isDeleted = true;
$board->save();
}
\Yii::$app->response->setStatusCode(204);
}
