public static function rclist($condition = '', $limit = [10, 0])
{
$baseCondition = 'LoanSketch.status=' . \App\LoanStatus::getStatusRc();
$condition = empty($condition) ? $baseCondition : $baseCondition . ' and ' . $condition;
$columns = ['U.bid, B.name bname, LoanSketch.uid, LoanSketch.loan_type, LoanSketch.use_type,
LoanSketch.amount, LoanSketch.deadline, LoanSketch.deadline_type, LoanSketch.days,
LoanSketch.repay_method, LoanSketch.repay_source, LoanSketch.addtime'];
$condition = self::formatConditions($condition);
$query = self::query()->leftJoin('User', 'U.uid=LoanSketch.uid', 'U')->leftJoin('Branch', 'B.bid=U.bid', 'B')->where($condition)->orderBy('LoanSketch.addtime desc')->columns($columns);
$count = $query->execute()->count();
$list = $query->limit($limit[0], $limit[1])->execute();
$list = $list ? $list->toArray() : [];
return ['list' => Loan::format($list), 'count' => $count];
}
