☰

Rupashree Audit

Rupashree Helper helps you to make your work more simple

// ==UserScript==
// @name         Rupashree Audit
// @namespace    http://tampermonkey.net/
// @version      1 (Beta)
// @description  Rupashree Helper helps you to make your work more simple
// @author       Ashis Biswas
// @match 		 https://wbrupashree.gov.in/admin/form_entry/BasicFormEntry/save_groom_photo/
// @match 		 https://wbrupashree.gov.in/admin/form_entry/BasicFormEntry/groomBasicEntry/*
// @match 		 http://wbrupashree.gov.in/admin/form_entry/BasicFormEntry/groomBasicEntry/*
// @match 		 https://wbrupashree.gov.in/admin/beneficiary/Beneficiary_list/beneficiary_details/*
// @match 		 http://wbrupashree.gov.in/admin/beneficiary/Beneficiary_list/beneficiary_details/*
// @match 		 https://wbrupashree.gov.in/admin/beneficiary/Beneficiary_list/*
// @match 		 http://wbrupashree.gov.in/admin/beneficiary/Beneficiary_list/*
// @match 		 https://wbrupashree.gov.in/admin/beneficiary/Beneficiary_list
// @require		 https://code.jquery.com/jquery-3.4.1.min.js
// @grant        none
// ==/UserScript==

$(document).ready(function(){
	
	//new column add
    $('<th align="center">Father</th>').insertBefore("#example tr:first-child th:last-child");
	$('<th align="center">Husband</th>').insertBefore("#example tr:first-child th:last-child");
	$('<th align="center">DOB</th>').insertBefore("#example tr:first-child th:last-child");
    $('<th align="center">IFSC</th>').insertBefore("#example tr:first-child th:last-child");
	$('<th align="center">ACC</th>').insertBefore("#example tr:first-child th:last-child");
	$('<th align="center">GP</th>').insertBefore("#example tr:first-child th:last-child");
	$('<th align="center">Block</th>').insertBefore("#example tr:first-child th:last-child");
    
    $('<td align="center"></tr>').insertBefore("#example tr td:last-child");
    $('<td align="center"></tr>').insertBefore("#example tr td:last-child");
	$('<td align="center"></tr>').insertBefore("#example tr td:last-child");
	$('<td align="center"></tr>').insertBefore("#example tr td:last-child");
    $('<td align="center"></tr>').insertBefore("#example tr td:last-child");
	$('<td align="center"></tr>').insertBefore("#example tr td:last-child");
	$('<td align="center"></tr>').insertBefore("#example tr td:last-child");
	
	$('#example tr td:last-child').append('<a class="fetchBtn btn btn-info btn-xs"><span class="glyphicon glyphicon-refresh"></span> Fetch</a>');
	
	$('#example_wrapper>div').prepend('<a class="mrBtn btn btn-info btn-sm"><span class="glyphicon glyphicon-list-alt"></span> Download Excel</a>');
	
	$('#example_wrapper>div').prepend('<a class="fetchAllBtn btn btn-success btn-sm mr-5"><span class="glyphicon glyphicon-list-alt"></span> FetchAll</a>');
	
	
	$('.fetchAllBtn').on( 'click', function(e){
		
		e.preventDefault();
		
		var ajax_request = function(rup_link, el) {
			var deferred = $.Deferred();
			var parentTR = el;
			$.ajax({
				url : rup_link,
				type: "GET",
				dataType: "text",
				success: function(data) {

					//app details
					var uFather = $(data).find("#app_basic_details table tr").eq(4);
					var uFatherTxt = uFather.find('td:eq(1)').text();
					parentTR.find('td:eq(-8)').text(uFatherTxt);
					
					
					var uHusband = $(data).find("#groom_details table tr").eq(1);
					var uHusbandTxt = uHusband.find('td:eq(1)').text();
					parentTR.find('td:eq(-7)').text(uHusbandTxt);
					
					
					var uDob = $(data).find("#app_basic_details table tr").eq(5);
					var uDobTxt = uDob.find('td:eq(1)').text();
					parentTR.find('td:eq(-6)').text(uDobTxt);
					
					
					var uBank = $(data).find("#app_contact_details table tr").eq(24);
					var uBankTxt = uBank.find('td:eq(1)').text();
					parentTR.find('td:eq(-5)').text(uBankTxt);
					
					
					var uAcc = $(data).find("#app_contact_details table tr").eq(22);
					var uAccTxt = uAcc.find('td:eq(1)').text();
					parentTR.find('td:eq(-4)').text(uAccTxt);
					
					
					var uGp = $(data).find("#app_contact_details table tr").eq(5);
					var uGpTxt = uGp.find('td:eq(1)').text();
					parentTR.find('td:eq(-3)').text(uGpTxt);
					
					
					var uBlock = $(data).find("#app_contact_details table tr").eq(7);
					var uBlockTxt = uBlock.find('td:eq(1)').text();
					parentTR.find('td:eq(-2)').text(uBlockTxt);

					deferred.resolve(data);
				},
				error: function(error) {
					deferred.reject(error);
				}
			});

			return deferred.promise();
		};//end of ajax request
		
		var looper = $.Deferred().resolve();

		$.when.apply($, $( "#example tbody tr" ).each(function( index ) {

			var rup_link = $( this ).find('td a.btn-success').attr('href');
			var pTR = $( this );
			
			looper = looper.then(function() {
				return ajax_request( rup_link, pTR );
				//console.log( rup_link );
			});

			return looper;
		})

		).then(function() {
					  
		  // run this after all ajax calls have completed
		  console.log('Done!');

		});
		
		
	});//end of fetch
	
	
	
	
	
	
	
	$('.fetchBtn').on('click', function(e){
        e.preventDefault();

        var parentTD = $(this).parent();
        var parentTR = parentTD.parent();

        var url = parentTD.find('.btn-success').attr('href');

        //Ajax Load data from ajax
        $.ajax({
            url : url,
            type: "GET",
            dataType: "text",
            success: function(data)
            {
				//app details
				var uFather = $(data).find("#app_basic_details table tr").eq(4);
                var uFatherTxt = uFather.find('td:eq(1)').text();
                parentTR.find('td:eq(-8)').text(uFatherTxt);
				
				
				var uHusband = $(data).find("#groom_details table tr").eq(1);
                var uHusbandTxt = uHusband.find('td:eq(1)').text();
                parentTR.find('td:eq(-7)').text(uHusbandTxt);
				
				
				var uDob = $(data).find("#app_basic_details table tr").eq(5);
                var uDobTxt = uDob.find('td:eq(1)').text();
                parentTR.find('td:eq(-6)').text(uDobTxt);
				
				
				var uBank = $(data).find("#app_contact_details table tr").eq(24);
                var uBankTxt = uBank.find('td:eq(1)').text();
                parentTR.find('td:eq(-5)').text(uBankTxt);
				
				
				var uAcc = $(data).find("#app_contact_details table tr").eq(22);
                var uAccTxt = uAcc.find('td:eq(1)').text();
                parentTR.find('td:eq(-4)').text(uAccTxt);
				
				
				var uGp = $(data).find("#app_contact_details table tr").eq(5);
                var uGpTxt = uGp.find('td:eq(1)').text();
                parentTR.find('td:eq(-3)').text(uGpTxt);
				
				
				var uBlock = $(data).find("#app_contact_details table tr").eq(7);
                var uBlockTxt = uBlock.find('td:eq(1)').text();
                parentTR.find('td:eq(-2)').text(uBlockTxt);
				


            },
            error: function (jqXHR, textStatus, errorThrown)
            {
                alert('Error get data from ajax');
            }
        });

    });
	
	
	
	
	$(".mrBtn").on("click", function(){
        mrTable = '<table><tr><th>Applcation Id</th><th>Beneficiary Name</th><th>Status</th><th>Age</th><th>Fathers Name</th>		<th>Proposed Husbands Name</th><th>Amount</th><th>Bank IFSC</th><th>Bank Account NO</th><th>Block/Municipality</th><th>GP/Ward Name</th></tr>';

        $('#example tr').each(function(i, el){
            mrTable += '<tr>';
			mrTable += '<td>' + $(this).find('td:eq(1)').text() + '</td>';
			mrTable += '<td>' + $(this).find('td:eq(2)').text() + '</td>';
			mrTable += '<td>' + $(this).find('td:eq(5)').text() + '</td>';
			mrTable += '<td>' + $(this).find('td:eq(9)').text() + '</td>';
			mrTable += '<td>' + $(this).find('td:eq(7)').text() + '</td>';
			mrTable += '<td>' + $(this).find('td:eq(8)').text() + '</td>';
			mrTable += '<td>25000</td>';
			mrTable += '<td>' + $(this).find('td:eq(10)').text() + '</td>';
			mrTable += '<td>' + $(this).find('td:eq(11)').text() + '</td>';
			mrTable += '<td>' + $(this).find('td:eq(13)').text() + '</td>';
			mrTable += '<td>' + $(this).find('td:eq(12)').text() + '</td>';
			mrTable += '</tr>';
        });
        mrTable += '</table>';
        exportToExcel(mrTable);
    });



    function exportToExcel(table){
        var htmls = "";
        var uri = 'data:application/vnd.ms-excel;base64,';
        var template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>';
        var base64 = function(s) {
            return window.btoa(unescape(encodeURIComponent(s)))
        };

        var format = function(s, c) {
            return s.replace(/{(\w+)}/g, function(m, p) {
                return c[p];
            })
        };

        htmls = table;

        var ctx = {
            worksheet : 'Worksheet',
            table : htmls
        }


        var link = document.createElement("a");
        link.download = "export.xls";
        link.href = uri + base64(format(template, ctx));
        link.click();
    }
	
});