예제 #1
0
    public static function findByUsername($username)
    {
        $where = "username='******'";
        $info = Operator::query()->where($where)->leftJoin('Role', 'Role.rid=Operator.rid')->leftJoin('Department', 'D.did=Operator.did', 'D')->leftJoin('Branch', 'B.bid=Operator.bid', 'B')->columns('Operator.oid, Operator.username, Operator.password,
						Role.rid, Role.name rname,
						D.did, D.name dname,
						B.bid, B.name bname')->limit(1)->execute();
        if (!$info) {
            return null;
        }
        return $info->toArray()[0];
    }