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];
}
