Skip to content

Instantly share code, notes, and snippets.

@sdfsdhgjkbmnmxc
Last active August 29, 2015 14:19
Show Gist options
  • Save sdfsdhgjkbmnmxc/fbb69ad80595876d014c to your computer and use it in GitHub Desktop.
Save sdfsdhgjkbmnmxc/fbb69ad80595876d014c to your computer and use it in GitHub Desktop.
bezbanka
var PERPAGE=50,
CSV_SEPARATOR=';', // если в Excel криво отображается табличка, то заменить на «,»
getResults = function(page, onDone) {
$.post('http://bezbanka.ru/search/searchresults/', {
'IsShow':1,
'Parameters.IsCreditor':'True',
'Parameters.IsMonth':'True',
'Parameters.MinAmount':'',
'Parameters.MaxAmount':'',
'Parameters.MinDuePeriod':'',
'Parameters.MinDuePeriodDays':'',
'Parameters.MaxDuePeriod':'',
'Parameters.MaxDuePeriodDays':'',
'Parameters.MinDebtorRating':'',
'Parameters.MaxDebtorRating':'',
'Parameters.ShowNegAndDone':'false',
'Parameters.IsAuction':'False',
'Parameters.IsQuickly':'False',
'Parameters.MiddleMode':'False',
'Parameters.Paging.OrderBy':'PublishDate',
'Parameters.Paging.PageCount':'37',
'Parameters.Paging.Count':'1844',
'Parameters.Paging.PageNo':page || '1' ,
'Parameters.Paging.PageSize':PERPAGE,
'Parameters.Paging.IsDescending':'True',
'IsAutoRate':'false',
'RefundAmount':'0',
'IsDeferredAutoRate':'false',
'IsNew':'False',
'IsOffer':'False',
'AssignedId':'0'
}, function(content) {
var $el = $('<div/>');
$el.html(content);
var $cells = $el.find('.searchResultCellMain');
var csvContent = '';
$cells.each(function() {
var $t = $(this);
var name = $t.find('.searchResultNickAndData p a').text();
var sum1 = parseInt($($t.find('.searchResultIndebtedAndReturn p')[0]).text());
var sum2 = parseInt($($t.find('.searchResultIndebtedAndReturn p')[1]).text());
var ndays = parseInt($($t.find('.searchResultPeriod p')[0]).text());
var t = $($t.find('.searchResultPeriod p')[1]).text();
if (t[0] == 'м') {
ndays = ndays * 30;
}
var comission = sum1 * .015 + 20 + 125;
var percent = (sum2-sum1-comission)/sum1/ndays *100;
//console.log(name, sum1, sum2, ndays, percent + '%');
csvContent += [name, sum1, sum2, ndays, percent].join(CSV_SEPARATOR) + '\r\n';
});
if (onDone) {
return onDone(csvContent);
}
getResults(2, function(x) {
csvContent = [ // это названия столбцов в файле. Можно переименовывать по вкусу:
'заёмщик'
,'сумма'
,'возврат'
,'дни'
,'процент в день'
].join(CSV_SEPARATOR) + '\r\n' + csvContent + x;
var download = document.createElement("a");
download.setAttribute('href', 'data:text/csv;charset=utf-8,' + encodeURIComponent(csvContent));
download.setAttribute('download', 'bezbanka-' + (new Date()) + '.csv');
download.click();
});
});
}
getResults();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment