task/app/Module/Project.php

<?php

namespace App\Module;

use DB;

/**
 * Class Project
 * @package App\Module
 */
class Project
{
    /**
     * 是否在项目里
     * @param int $projectid
     * @param string $username
     * @return array
     */
    public static function inThe($projectid, $username)
    {
        $count = DB::table('project_users')->where([
            'type' => '成员',
            'projectid' => $projectid,
            'username' => $username,
        ])->count();
        if ($count <= 0) {
            return Base::retError('你不在项目成员内！');
        } else {
            return Base::retSuccess('你在项目内');
        }
    }

    /**
     * 更新项目（complete、unfinished）
     * @param int $projectid
     */
    public static function updateNum($projectid)
    {
        DB::table('project_lists')->where('id', $projectid)->update([
            'unfinished' => DB::table('project_task')->where('projectid', $projectid)->where('complete', 0)->count(),
            'complete' => DB::table('project_task')->where('projectid', $projectid)->where('complete', 1)->count(),
        ]);
    }

    /**
     * 任务是否过期
     * @param array $task
     * @return int
     */
    public static function taskIsOverdue($task)
    {
        return $task['complete'] == 0 && $task['enddate'] > 0 && $task['enddate'] <= Base::time() ? 1 : 0;
    }

    /**
     * 过期的排在前
     * @param array $taskLists
     * @return mixed
     */
    public static function sortTask($taskLists)
    {
        $inOrder = [];
        foreach ($taskLists as $key => $oitem) {
            $inOrder[$key] = $oitem['overdue'] ? -1 : $key;
        }
        array_multisort($inOrder, SORT_ASC, $taskLists);
        return $taskLists;
    }
}