public static function findByUid($uid)
{
$uid = intval($uid);
$info = LoanSketch::findFirst("uid={$uid}");
if (!$info) {
return false;
}
return Loan::format([$info->toArray()])[0];
}
public static function all($condition = '', $limit = [10, 0], $columns = ['base', 'branch'])
{
$condition = self::formatConditions($condition);
$query = self::query()->leftJoin('User', 'U.uid=Loan.uid', 'U')->leftJoin('Branch', 'B.bid=U.bid', 'B')->columns(self::columns($columns))->where($condition);
$count = $query->execute()->count();
$list = $query->limit($limit[0], $limit[1])->orderBy('Loan.addtime desc')->execute();
$list = $list ? $list->toArray() : [];
return ['list' => Loan::format($list), 'count' => $count];
}
public static function sketchInfo($uid, $level = ['base'])
{
$conditions['uid'] = $uid;
$condition = self::buildConditions($conditions);
$query = User::query();
$result = $query->where($condition)->leftJoin('LoanSketch', 'L.uid = User.uid', 'L')->leftJoin('Operator', 'User.oid=O.oid', 'O')->leftJoin('Branch', 'User.bid=B.bid', 'B')->limit(1)->columns(self::columns($level))->orderBy('User.addtime desc')->execute();
if ($result) {
return Loan::format($result->toArray())[0];
}
return null;
}
