Greasy Fork

// ==UserScript==
// @name           Virtonomica:Итого в отчете по подразделениям
// @namespace      virtonomica
// @description    Итоговая строка в отчете по подразделениям. Origin By Izumrud_AO, http://userscripts-mirror.org/scripts/show/137698
// @include	   http*://*virtonomic*.*/*/main/company/view/*/finance_report/by_units*
// @include	   http*://*virtonomic*.*/*/main/company/view/*/marketing_report/shops/*
// @include	   http*://*virtonomic*.*/*/main/company/view/*/marketing_report/services
// @include	   http*://*virtonomic*.*/*/main/company/view/*/marketing_report/services/*
// @version        1.9
// ==/UserScript==

var run = function() {
  var win = (typeof(unsafeWindow) != 'undefined' ? unsafeWindow : top.window);
  $ = win.$;
  
  //резделитель разрядов
  function commaSeparateNumber(val, sep){
    var separator = sep || ',';
    while (/(\d+)(\d{3})/.test(val.toString())){
      val = val.toString().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, "$1"+separator);
    }
    return val;
  }
  function edit_summ(pr) {	
    return commaSeparateNumber( parseFloat(pr).toFixed(2), ' ');
  }

	function cleanNumber(spNum) {
		return spNum.replace('$','').replace(/\s+/g,'');
	}
	
  if (/\/main\/company\/view\/\d+\/finance_report\/by_units\//.test(window.location)) {
    var nvInSum = 0;
    var nvOutSum = 0;
    var nvTaxSum = 0;
    var nvProfit = 0;
    var nvProfitPercent = 0;
    var numrow = 0;
    
    $( '#mainContent tr[class]' ).each( function() {
      var cells = $( 'td', this );
      console.log(cleanNumber($( cells[4] ).text()));
      
      nvInSum = nvInSum + parseFloat( cleanNumber($( cells[4] ).text()) );
      nvOutSum = nvOutSum + parseFloat( cleanNumber($( cells[5] ).text()) );
      nvTaxSum = nvTaxSum + parseFloat( cleanNumber($( cells[6] ).text()) );
      nvProfit = nvProfit + parseFloat( cleanNumber($( cells[7] ).text()) );
      nvProfitPercent = nvProfitPercent + parseFloat( cleanNumber($( cells[8] ).text()) );
      numrow = numrow + 1;
    });
    //avg
	nvProfitPercent = (nvProfitPercent / numrow).toFixed(2);
    
    var tclass ="nowrap";
    if (nvProfit < 0) {
      tclass="moneySmallerZero";
    }
    var svQty = "Кол-во: " + numrow + " шт.";

    var text = "<tr style='background: #EEFACA'> <td style='font-size:14px'>"+"Итого :"+"</td> <td> </td> <td> </td> <td>"+ svQty +"</td>";
    text += "<td align=\"right\" class=\"nowrap\">$" + edit_summ(nvInSum) + "</td>";
    text += "<td align=\"right\" class=\"nowrap\">$" + edit_summ(nvOutSum) + "</td>";
    text += "<td align=\"right\" class=\"nowrap\">$" + edit_summ(nvTaxSum) + "</td>";
    text += "<td align=\"right\" class=\"nowrap\"><span class='"+ tclass +"'>$" + edit_summ(nvProfit) + "</span></td>";
    text += "<td align=\"right\" class=\"nowrap\">" + edit_summ(nvProfitPercent) + " %</td>  </tr>";

    $(text).insertBefore($('table.grid > tbody > tr:last'));
  }
  
  if (/\/main\/company\/view\/\d+\/marketing_report\/shops\//.test(window.location)) {
    var nvVolume = 0;
    var nvSum = 0;
    var nvPrc = 0;
    var nvQual = 0;
    var nvBrand = 0;
    var numrow = 0;
    var avVolAndSum=[];
    
    $( 'table[class^="unit-list"] > tbody > tr[class]' ).each( function() {
      var cells = $( 'td', this );
      console.log(cleanNumber($( cells[4] ).text()));
      
	  avVolAndSum = $( cells[4] ).html().split('<br>');
      nvVolume = nvVolume + parseFloat( cleanNumber(avVolAndSum[0]) );
      nvSum = nvSum + parseFloat( cleanNumber(avVolAndSum[1]) );
      nvPrc = nvPrc + parseFloat( cleanNumber($( cells[5] ).text()) );
      nvQual = nvQual + parseFloat( cleanNumber($( cells[6] ).text()) );
      nvBrand = nvBrand + parseFloat( cleanNumber($( cells[7] ).text()) );
      numrow = numrow + 1;
    });
    //avg
	nvPrc = (nvPrc / numrow).toFixed(2);
	nvQual = (nvQual / numrow).toFixed(2);
	nvBrand = (nvBrand / numrow).toFixed(2);
    
    var svQty = "Кол-во: " + numrow + " шт.";

    var text = "<tr style='background: #EEFACA'> <td style='font-size:14px'>"+"Итого :"+"</td> <td> </td> <td> </td> <td>"+ svQty +"</td>";
    text += "<td align=\"right\" class=\"nowrap\">" + edit_summ(nvVolume) + " ед.<br>$" + edit_summ(nvSum) + "</td>";
    text += "<td align=\"right\" class=\"nowrap\">$" + edit_summ(nvPrc) + "</td>";
    text += "<td align=\"right\" class=\"nowrap\">" + edit_summ(nvQual) + "</td>";
    text += "<td align=\"right\" class=\"nowrap\">" + edit_summ(nvBrand) + "</td>  </tr>";
    
    $(text).insertAfter($('table[class^="unit-list"] > tbody > tr:last'));
  }
  
  if (/\/main\/company\/view\/\d+\/marketing_report\/services/.test(window.location)) {
    var nvVolume = 0;
    var nvSum = 0;
    var nvPrc = 0;
    var nvQ1 = 0;
    var nvQ2 = 0;
    var nvQ3 = 0;
    var numrow = 0;
    var avVolAndSum=[];
    
    $( 'table[class^="unit-list"] > tbody > tr[class]' ).each( function() {
      var cells = $( 'td', this );
      console.log(cleanNumber($( cells[4] ).text()));
      
	  avVolAndSum = $( cells[4] ).html().split('<br>');
      nvVolume = nvVolume + parseFloat( cleanNumber(avVolAndSum[0]) );
      nvSum = nvSum + parseFloat( cleanNumber(avVolAndSum[1]) );
      nvPrc = nvPrc + parseFloat( cleanNumber($( cells[5] ).text()) );
      nvQ1 = nvQ1 + parseFloat( cleanNumber($( cells[6] ).text()) );
      nvQ2 = nvQ2 + parseFloat( cleanNumber($( cells[7] ).text()) );
      nvQ3 = nvQ3 + parseFloat( cleanNumber($( cells[8] ).text()) );
      numrow = numrow + 1;
    });
    //avg
	nvPrc = (nvPrc / numrow).toFixed(2);
	nvQ1 = (nvQ1 / numrow).toFixed(2);
	nvQ2 = (nvQ2 / numrow).toFixed(2);
	nvQ3 = (nvQ3 / numrow).toFixed(2);
    
    var svQty = "Кол-во: " + numrow + " шт.";

    var text = "<tr style='background: #EEFACA'> <td style='font-size:14px'>"+"Итого :"+"</td> <td> </td> <td> </td> <td>"+ svQty +"</td>";
    text += "<td align=\"right\" class=\"nowrap\">" + edit_summ(nvVolume) + " ед.<br>$" + edit_summ(nvSum) + "</td>";
    text += "<td align=\"right\" class=\"nowrap\">$" + edit_summ(nvPrc) + "</td>";
    text += "<td align=\"right\" class=\"nowrap\">" + edit_summ(nvQ1) + "</td>";
    text += "<td align=\"right\" class=\"nowrap\">" + edit_summ(nvQ2) + "</td>";
    text += "<td align=\"right\" class=\"nowrap\">" + edit_summ(nvQ3) + "</td>  </tr>";
    
    $(text).insertAfter($('table[class^="unit-list"] > tbody > tr:last'));
  }

}

var script = document.createElement("script");
script.textContent = '(' + run.toString() + ')();';
document.documentElement.appendChild(script);