[Fmsystem-commits] [10587] property: more on condition survey

[Sigurd Nes]

Revision: 10587
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=10587
Author:   sigurdne
Date:     2012-12-11 14:51:04 +0000 (Tue, 11 Dec 2012)
Log Message:
-----------
property: more on condition survey

Modified Paths:
--------------
    trunk/phpgwapi/js/yahoo/common.js
    trunk/property/inc/class.uicondition_survey.inc.php
    trunk/property/templates/base/condition_survey.xsl

Added Paths:
-----------
    trunk/property/js/portico/condition_survey.js

Modified: trunk/phpgwapi/js/yahoo/common.js
===================================================================
--- trunk/phpgwapi/js/yahoo/common.js   2012-12-11 13:43:51 UTC (rev 10586)
+++ trunk/phpgwapi/js/yahoo/common.js   2012-12-11 14:51:04 UTC (rev 10587)
@@ -207,7 +207,46 @@
        return pag;
 };
 
+YAHOO.portico.getTotalSum = function(name_column,round,paginator,datatable)
+{
+       if(!paginator.getPageRecords())
+       {
+               return '0,00';
+       }
+       begin = end = 0;
+       end = datatable.getRecordSet().getLength();
+       tmp_sum = 0;
+       for(i = begin; i < end; i++)
+       {
+               tmp_sum = tmp_sum + 
parseFloat(datatable.getRecordSet().getRecords(0)[i].getData(name_column));
+       }
 
+       return tmp_sum = YAHOO.util.Number.format(tmp_sum, 
{decimalPlaces:round, decimalSeparator:",", thousandsSeparator:" "});
+}
+
+       YAHOO.portico.td_sum = function(sum)
+       {
+               newTD = document.createElement('td');
+               newTD.colSpan = 1;
+               newTD.style.borderTop="1px solid #000000";
+               newTD.style.fontWeight = 'bolder';
+               newTD.style.textAlign = 'right';
+               newTD.style.paddingRight = '0.8em';
+               newTD.style.whiteSpace = 'nowrap';
+               newTD.appendChild(document.createTextNode(sum));
+               newTR.appendChild(newTD);
+       }
+
+       YAHOO.portico.td_empty = function(colspan)
+       {
+               newTD = document.createElement('td');
+               newTD.colSpan = colspan;
+               newTD.style.borderTop="1px solid #000000";
+               newTD.appendChild(document.createTextNode(''));
+               newTR.appendChild(newTD);
+       }
+
+
 YAHOO.portico.updateinlineTableHelper = function(container, requestUrl)
 {
 

Modified: trunk/property/inc/class.uicondition_survey.inc.php
===================================================================
--- trunk/property/inc/class.uicondition_survey.inc.php 2012-12-11 13:43:51 UTC 
(rev 10586)
+++ trunk/property/inc/class.uicondition_survey.inc.php 2012-12-11 14:51:04 UTC 
(rev 10587)
@@ -426,6 +426,8 @@
                                
$GLOBALS['phpgw']->css->add_external_file('phpgwapi/js/yui3/gallery-formvalidator/validatorCss.css');
                        }
 
+                       self::add_javascript('property', 'portico', 
'condition_survey.js');
+
                        self::add_javascript('phpgwapi', 'tinybox2', 
'packed.js');
                        
$GLOBALS['phpgw']->css->add_external_file('phpgwapi/js/tinybox2/style.css');
 

Added: trunk/property/js/portico/condition_survey.js
===================================================================
--- trunk/property/js/portico/condition_survey.js                               
(rev 0)
+++ trunk/property/js/portico/condition_survey.js       2012-12-11 14:51:04 UTC 
(rev 10587)
@@ -0,0 +1,42 @@
+
+
+/********************************************************************************/
+       addFooterDatatable2 = function(paginator,datatable)
+       {
+               //call YAHOO.portico.getTotalSum(name of column) in property.js
+               tmp_sum1 = 
YAHOO.portico.getTotalSum('period_1',0,paginator,datatable);
+               tmp_sum2 = 
YAHOO.portico.getTotalSum('period_2',0,paginator,datatable);
+               tmp_sum3 = 
YAHOO.portico.getTotalSum('period_3',0,paginator,datatable);
+               tmp_sum4 = 
YAHOO.portico.getTotalSum('period_4',0,paginator,datatable);
+               tmp_sum5 = 
YAHOO.portico.getTotalSum('period_5',0,paginator,datatable);
+               tmp_sum6 = 
YAHOO.portico.getTotalSum('period_6',0,paginator,datatable);
+               tmp_sum7 = 
YAHOO.portico.getTotalSum('sum',0,paginator,datatable);
+
+               if(typeof(tableYUI0)=='undefined')
+               {
+                       tableYUI0 = 
YAHOO.util.Dom.getElementsByClassName("yui-dt-data","tbody")[2].parentNode;
+                       tableYUI0.setAttribute("id","tableYUI0");
+               }
+               else
+               {
+                       tableYUI0.deleteTFoot();
+               }
+
+               //Create ROW
+               newTR = document.createElement('tr');
+
+               YAHOO.portico.td_empty(1);
+               YAHOO.portico.td_sum('Sum');
+               YAHOO.portico.td_sum(tmp_sum1);
+               YAHOO.portico.td_sum(tmp_sum2);
+               YAHOO.portico.td_sum(tmp_sum3);
+               YAHOO.portico.td_sum(tmp_sum4);
+               YAHOO.portico.td_sum(tmp_sum5);
+               YAHOO.portico.td_sum(tmp_sum6);
+               YAHOO.portico.td_sum(tmp_sum7);
+
+               myfoot = tableYUI0.createTFoot();
+               myfoot.setAttribute("id","myfoot");
+               myfoot.appendChild(newTR);
+       }
+

Modified: trunk/property/templates/base/condition_survey.xsl
===================================================================
--- trunk/property/templates/base/condition_survey.xsl  2012-12-11 13:43:51 UTC 
(rev 10586)
+++ trunk/property/templates/base/condition_survey.xsl  2012-12-11 14:51:04 UTC 
(rev 10587)
@@ -382,6 +382,16 @@
                        YAHOO.portico.inlineTableHelper("<xsl:value-of 
select="container"/>", <xsl:value-of select="requestUrl"/>, columnDefs);
                </xsl:for-each>
 
+               var PaginatorName2 = 'paginator_containerdatatable-container_2';
+               var DatatableName2 = 'datatable_containerdatatable-container_2';
+
+               var  myPaginator_2 = YAHOO.portico.Paginator[PaginatorName2];
+               var  myDataTable_2 = YAHOO.portico.DataTable[DatatableName2];
+
+               myDataTable_2.subscribe("renderEvent", function()
+               {
+                       addFooterDatatable2(myPaginator_2,myDataTable_2);
+               });
        });
   </script>