X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Felements%2Fcustomer-table.html;h=090623ff90d0844ca5b5dac29280d46cfd05ca46;hb=b6260b4f39cf34b9e0e5b8560ef88c8881ba0766;hp=b49bf0290069fb58afc9754038e69a95b0ab3c3e;hpb=05364e1a107233d35792a76bf6d23d00dd5611cf;p=freeside.git

diff --git a/httemplate/elements/customer-table.html b/httemplate/elements/customer-table.html
index b49bf0290..090623ff9 100644
--- a/httemplate/elements/customer-table.html
+++ b/httemplate/elements/customer-table.html
@@ -41,6 +41,8 @@ Example:
 
 <SCRIPT TYPE="text/javascript">
 
+  var num_open_invoices = new Array;
+
   function clearhint_invnum() {
 
     if ( this.value == 'Not found' || this.value == 'Multiple' ) {
@@ -70,35 +72,39 @@ Example:
 
   function update_customer(searchrow, customerArray) {
       
+      var display_custnum_obj = document.getElementById('display_custnum'+searchrow);
       var custnum_obj = document.getElementById('custnum'+searchrow);
       var customer = document.getElementById('customer'+searchrow);
       var customer_select = document.getElementById('cust_select'+searchrow);
 
-      custnum_obj.disabled = false;
-      custnum_obj.style.backgroundColor = '#ffffff';
+      display_custnum_obj.disabled = false;
+      display_custnum_obj.style.backgroundColor = '#ffffff';
       customer.disabled = false;
       customer.style.backgroundColor = '#ffffff';
 
       if ( customerArray.length == 0 ) {
 
-          custnum_obj.value = 'Not found';
+          custnum_obj.value = '';
+          display_custnum_obj.value = 'Not found';
           customer.value = 'Not found';
-          custnum_obj.style.color = '#ff0000';
+          display_custnum_obj.style.color = '#ff0000';
           customer.style.color = '#ff0000';
 
           customer.style.display = '';
           customer_select.style.display = 'none';
           return false;
 
-      } else if ( customerArray.length == 5 ) {
+      } else if ( customerArray.length >= 6 ) {
 
           custnum_obj.value = customerArray[0];
-          custnum_obj.style.color = '#000000';
+          display_custnum_obj.value = customerArray[6];
+          display_custnum_obj.style.color = '#000000';
           customer.value = customerArray[1];
 
           update_balance_text(searchrow, customerArray[2]);
           update_status_text( searchrow, customerArray[3]);
           update_status_color(searchrow, '#'+customerArray[4]);
+          update_num_open(searchrow, customerArray[5]);
 
           customer.style.display = '';
           customer_select.style.display = 'none';
@@ -122,8 +128,8 @@ Example:
       return;
     }
 
-    if ( ( <% $opt{prefix} %>rownum - searchrow ) == 1 ) {
-      <% $opt{prefix} %>addRow();
+    if ( document.getElementById('row'+searchrow).emptyrow ) {
+      <% $opt{prefix} %>newEmptyRow(searchrow);
     }
     var customer = document.getElementById('customer'+searchrow);
     customer.value = 'searching...';
@@ -136,10 +142,10 @@ Example:
     customer.style.display = '';
     customer_select.style.display = 'none';
     
-    var custnum_obj = document.getElementById('custnum'+searchrow);
     update_balance_text(searchrow, '');
     update_status_text(searchrow, '');
     update_status_color(searchrow, '#000000');
+    update_num_open(searchrow, 0);
 
     function search_invnum_update(customers) {
       
@@ -160,11 +166,12 @@ Example:
 
     this.style.color = '#000000'
 
-    var custnum_obj = this;
+    var display_custnum_obj = this;
     var searchrow = this.getAttribute('rownum');
-    var custnum = this.value;
+    var custnum_obj = document.getElementById('custnum'+searchrow);
+    var display_custnum = this.value;
 
-    if ( custnum == 'searching...' || custnum == 'Not found' || custnum == '' )
+    if ( display_custnum == 'searching...' || display_custnum == 'Not found' || display_custnum == '' )
       return;
 
     if ( this.getAttribute('magic') == 'nosearch' ) {
@@ -172,18 +179,19 @@ Example:
       return;
     }
 
-    if ( ( <% $opt{prefix} %>rownum - searchrow ) == 1 ) {
-      <% $opt{prefix} %>addRow();
+    if ( document.getElementById('row'+searchrow).emptyrow ) {
+      <% $opt{prefix} %>newEmptyRow(searchrow);
     }
-    var customer = document.getElementById('customer'+searchrow);
-    customer.value = 'searching...';
-    customer.disabled = true;
-    customer.style.color = '#000000';
-    customer.style.backgroundColor = '#dddddd';
+
+    var customer_obj = document.getElementById('customer'+searchrow);
+    customer_obj.value = 'searching...';
+    customer_obj.disabled = true;
+    customer_obj.style.color = '#000000';
+    customer_obj.style.backgroundColor = '#dddddd';
 
     var customer_select = document.getElementById('cust_select'+searchrow);
 
-    customer.style.display = '';
+    customer_obj.style.display = '';
     customer_select.style.display = 'none';
 
     var invnum = document.getElementById('invnum'+searchrow);
@@ -192,18 +200,51 @@ Example:
     update_balance_text(searchrow, '');
     update_status_text( searchrow, '');
     update_status_color(searchrow, '#000000');    
+    update_num_open(searchrow, 0);
 
     function search_custnum_update(customers) {
 
-      var customerArray = eval('(' + customers + ')') || [];
-      update_customer(searchrow, customerArray);
+      var customerArrayArray = eval('(' + customers + ')') || [];
 
+      if ( customerArrayArray.length == 0 ) {
+
+        update_customer(searchrow, []);
+
+      } else if ( customerArrayArray.length == 1 ) {
+
+        update_customer(searchrow, customerArrayArray[0]);
 % if ( $opt{custnum_update_callback} ) {
-        <% $opt{custnum_update_callback} %>(searchrow, '<% $opt{prefix} %>')
+          <% $opt{custnum_update_callback} %>(searchrow, '<% $opt{prefix} %>')
 % }
+
+      } else {
+
+        custnum_obj.value = 'Multiple'; // or something
+        custnum_obj.style.color = '#ff0000';
+
+        //blank the current list
+        customer_select.options.length = 0;
+
+        opt(customer_select, '', 'Multiple customers match "' + custnum + '" - select one', '#ff0000');
+        //add the multiple customers
+        for ( var s = 0; s < customerArrayArray.length; s++ ) {
+          opt(customer_select,
+              JSON.stringify(customerArrayArray[s]),
+              customerArrayArray[s][1],
+              '#000000');
+        }
+
+        opt(customer_select, 'cancel', '(Edit search string)', '#000000');
+
+        customer_obj.style.display = 'none';
+
+        customer_select.style.display = '';
+
+      }
+
     }
 
-    custnum_search(custnum, search_custnum_update );
+    custnum_search(display_custnum, search_custnum_update );
 
   }
 
@@ -221,14 +262,14 @@ Example:
       return;
     }
 
-    if ( ( <% $opt{prefix} %>rownum - searchrow ) == 1 ) {
-      <% $opt{prefix} %>addRow();
+    if ( document.getElementById('row'+searchrow).emptyrow ) {
+      <% $opt{prefix} %>newEmptyRow(searchrow);
     }
     
     var invnum = document.getElementById('invnum'+searchrow);
     invnum.value = '';
 
-    var custnum_obj = document.getElementById('custnum'+searchrow);
+    var custnum_obj = document.getElementById('display_custnum'+searchrow);
     custnum_obj.value = 'searching...';
     custnum_obj.disabled = true;
     custnum_obj.style.color = '#000000';
@@ -243,9 +284,13 @@ Example:
       custnum_obj.disabled = false;
       custnum_obj.style.backgroundColor = '#ffffff';
 
-      if ( customerArrayArray.length == 1 ) {
+      if ( customerArrayArray.length == 0 ) {
+
+        update_customer(searchrow, []);
+
+      } else if ( customerArrayArray.length == 1 ) {
 
-        update_customer(customerArrayArray[1]);
+        update_customer(searchrow, customerArrayArray[0]);
 % if ( $opt{custnum_update_callback} ) {
         <% $opt{custnum_update_callback} %>(searchrow, '<% $opt{prefix} %>')
 % }
@@ -287,6 +332,7 @@ Example:
     var customer = this.options[this.selectedIndex].text;
 
     var searchrow = this.getAttribute('rownum');
+    var display_custnum_obj = document.getElementById('display_custnum'+searchrow);
     var custnum_obj = document.getElementById('custnum'+searchrow);
     var customer_obj = document.getElementById('customer'+searchrow);
     var balance_obj = document.getElementById('balance'+searchrow);
@@ -296,6 +342,7 @@ Example:
 
     } else if ( custnum_balance_status == 'cancel' ) {
 
+      display_custnum_obj.value = '';
       custnum_obj.value = '';
       custnum_obj.style.color = '#000000';
 
@@ -337,245 +384,102 @@ Example:
     document.getElementById('balance'+rownum+'_text').innerHTML = newval;
   }
 
+  function update_num_open(rownum, newval) {
+    document.getElementById('num_open'+rownum).value = newval;
+    num_open_invoices[rownum] = newval;
+  }
 
+  function <% $opt{prefix} %>updateTotalRow () {
+    if ( <% $opt{prefix} %>totalrows == 1 ) {
+      <% $opt{prefix} %>total_el.innerHTML =
+        'Total '
+          + <% $opt{prefix} %>totalrows
+          + ' <% $opt{name_singular} || 'customer' %>';
+    } else {
+      <% $opt{prefix} %>total_el.innerHTML =
+        'Total '
+          + <% $opt{prefix} %>totalrows
+          + ' <% PL($opt{name_singular} || 'customer') %>';
+    }
+  }
 
-</SCRIPT>
-
-<TABLE ID="<% $opt{prefix} %>OneTrueTable" BGCOLOR="#cccccc" BORDER=0 CELLSPACING=0>
-
-<TR>
-  <TH>Inv #</TH>
-  <TH>Cust #</TH>
-  <TH>Status</TH>
-  <TH>Customer</TH>
-  <TH>Balance</TH>
-% foreach my $header ( @{$opt{header}} ) {
-    <TH><% $header %></TH>
-% }
-</TR>
-% my $row = 0;
-% for ( $row = 0; exists($param->{"custnum$row"}); $row++ ) { 
-
-    <TR id="row<%$row%>" rownum="<%$row%>">
-      <TD>
-	<INPUT TYPE      = "text"
-               NAME      = "invnum<% $row %>"
-               ID        = "invnum<% $row %>"
-               SIZE      = 8
-               MAXLENGTH = 12
-               STYLE     = "text-align:right;"
-               VALUE     = "<% $param->{"invnum$row"} %>"
-               rownum    = "<% $row %>"
-        >
-        <SCRIPT TYPE="text/javascript">
-          var invnum_input<% $row %> = document.getElementById("invnum<% $row %>");
-          invnum_input<% $row %>.onfocus = clearhint_invnum;
-          invnum_input<% $row %>.onchange = <% $opt{prefix} %>search_invnum;
-        </SCRIPT>
-      </TD>
-
-      <TD>
-        <INPUT TYPE      = "text"
-               NAME      = "custnum<% $row %>"
-               ID        = "custnum<% $row %>"
-               SIZE      = 8
-               MAXLENGTH = 12
-               STYLE     = "text-align:right;"
-               VALUE     = "<% $param->{"custnum$row"} %>"
-               rownum    = "<% $row %>"
-        >
-        <SCRIPT TYPE="text/javascript">
-          var custnum_input<% $row %> = document.getElementById("custnum<% $row %>");
-          custnum_input<% $row %>.onfocus = clearhint_custnum;
-          custnum_input<% $row %>.onchange = <% $opt{prefix} %>search_custnum;
-        </SCRIPT>
-      </TD>
-      
-      <TD STYLE="text-align: center">
-        <SPAN
-               ID        = "status<% $row %>_text"
-               rownum    = "<% $row %>"
-               STYLE     = "font-weight: bold;
-                            color: <%$param->{"statuscolor$row"} || '#000000'%>"
-
-        ><% $param->{"status$row"} %></SPAN>
-        <INPUT TYPE      = "hidden"
-               NAME      = "status<% $row %>"
-               ID        = "status<% $row %>"
-               VALUE     = "<% $param->{"status$row"} %>"
-               rownum    = "<% $row %>"
-        >
-        <INPUT TYPE      = "hidden"
-               NAME      = "statuscolor<% $row %>"
-               ID        = "statuscolor<% $row %>"
-               VALUE     = "<% $param->{"statuscolor$row"} %>"
-               rownum    = "<% $row %>"
-        >
-      </TD>
-
-      <TD>
-        <INPUT TYPE="text" NAME="customer<% $row %>" ID="customer<% $row %>" SIZE=64 VALUE="<% $param->{"customer$row"} %>" rownum="<% $row %>">
-          <SCRIPT TYPE="text/javascript">
-            var customer_input<% $row %> = document.getElementById("customer<% $row %>");
-            customer_input<% $row %>.onfocus = clearhint_customer;
-            customer_input<% $row %>.onclick = clearhint_customer;
-            customer_input<% $row %>.onchange = <% $opt{prefix} %>search_customer;
-          </SCRIPT>
-        <SELECT NAME="cust_select<% $row %>" ID="cust_select<% $row %>" rownum="<% $row %>" STYLE="color:#ff0000; display:none">
-        </SELECT>
-          <SCRIPT TYPE="text/javascript">
-            var customer_select<% $row %> = document.getElementById("cust_select<% $row %>");
-            customer_select<% $row %>.onchange = select_customer;
-          </SCRIPT>
-      </TD>
-
-      <TD STYLE="text-align:right">
-        <% $money_char %>
-        <SPAN 
-               ID        = "balance<% $row %>_text"
-               rownum    = "<% $row %>"
-        ><% $param->{"balance$row"} %></SPAN>
-        &nbsp;
-        <INPUT TYPE      = "hidden"
-               NAME      = "balance<% $row %>"
-               ID        = "balance<% $row %>"
-               VALUE     = "<% $param->{"balance$row"} %>"
-               rownum    = "<% $row %>"
-        >
-      </TD>
+  var <% $opt{prefix} %>total_el, <% $opt{prefix} %>rownum, <% $opt{prefix} %>totalrows, <% $opt{prefix} %>allrows;
+
+  function <% $opt{prefix} %>addDeleteButton (searchrow) {
+    var td_delete = document.getElementById('delete'+searchrow);
+    var button_delete = document.createElement('INPUT');
+    button_delete.setAttribute('rownum', searchrow);
+    button_delete.setAttribute('type', 'button');
+    button_delete.setAttribute('value', 'X');
+    button_delete.onclick = <% $opt{prefix} %>deleteRow;
+    button_delete.style.color = '#ff0000';
+    button_delete.style.fontWeight = 'bold';
+    button_delete.style.paddingLeft = '2px';
+    button_delete.style.paddingRight = '2px';
+    td_delete.appendChild(button_delete);
+  }
 
-%   my $col = 0;
-%   foreach my $field ( @{$opt{fields}} ) {
-%     my $value;
-%     if ( ref($field) eq 'CODE' ) {
-%       $value = &{$field}($row,$param);
-%     } else {
-%       $value = $param->{"$field$row"}; 
-%     }
-%     my $name  = (ref($field) eq 'CODE') ? "column${col}_$row" : "$field$row";
-%     my $align = $align{ $opt{align}->[$col] || 'l' };
-%     my $size  = $sizes->[$col]  || 10;
-%     my $color = $opt{color}->[$col];
-%     my $font = $color ? qq(<FONT COLOR="$color">) : '';
-%     my $onchange = '';
-%     if ( $opt{onchange}->[$col] ) {
-%       $onchange = 'onchange="'.$opt{onchange}->[$col].'"';
-%     }
-%     elsif ( $opt{footer}->[$col] eq '_TOTAL' ) {
-%       $total[$col] += $value;
-%       $onchange = $opt{prefix}. "calc_total$col();";
-%       $onchange = qq(onchange="$onchange" onkeyup="$onchange");
-%     }
-      <TD ALIGN="<% $align %>">
-%     my $type = $types->[$col] || 'text';
-%     if ($type eq 'text' or $type eq 'checkbox') {
-        <INPUT TYPE  = "<% $type %>"
-               NAME  = "<% $name %>"
-               ID    = "<% $name %>"
-               SIZE  = "<% $size %>"
-               STYLE = "text-align: <% $align %>;"
-               VALUE = "<% $value %>"
-               rownum    = "<% $row %>"
-               <% $onchange %>
-        >
-%     } elsif ($types->[$col] eq 'immutable') {
-        <% $font %><% $value %><% $font ? '</FONT>' : '' %>
-        <INPUT TYPE="hidden" ID="<% $name %>" NAME="<% $name %>" VALUE="<% $value %>" >
-%     } else {
-        Cannot represent unknown type: <% $types->[$col] %>
-%     }
-      </TD>
-%     $col++;
-%   }
-    </TR>
-% } 
+  function <% $opt{prefix} %>newEmptyRow (searchrow) {
+    // add delete button to current row
+    <% $opt{prefix} %>addDeleteButton(searchrow);
+    // mark current row as non-empty
+    var oldemptyrow = document.getElementById('row'+searchrow);
+    oldemptyrow.emptyrow = false;
+    // update totalrows
+    <% $opt{prefix} %>totalrows++
+    <% $opt{prefix} %>updateTotalRow();
+    // add a new empty row
+    <% $opt{prefix} %>addRow();
+  }
 
-<TR id="row_total">
-  <TH COLSPAN=5 ID="<% $opt{'prefix'} %>_TOTAL_TOTAL">
-    Total <% $row ? $row-1 : 0 %>
-    <% PL($opt{name_singular} || 'customer', ( $row ? $row-1 : 0 ) ) %>
-  </TH>
-% my $col = 0;
-% foreach my $footer ( @{$opt{footer}} ) {
-%   my $align = $align{ $opt{'footer_align'}->[$col] || 'c' };
-%   if ($footer eq '_TOTAL' ) {
-%     my $id = $opt{'fields'}->[$col];
-%     $id = ref($id) ? "column${col}_TOTAL" : "${id}_TOTAL";
-      <TH ALIGN="<% $align %>" ID="<% $id %>">&nbsp;<% sprintf('%.2f', $total[$col] ) %></TH>
-%   } else {
-      <TH ALIGN="<% $align %>"><% $footer %></TH>
-%   }
-%   $col++;
+  function <% $opt{prefix} %>deleteRow() {
+    var thisrownum = this.getAttribute('rownum');
+% if ( $opt{delete_row_callback} ) {
+    // callback
+    <% $opt{delete_row_callback} %>(thisrownum,'<% $opt{prefix} %>');
 % }
-</TR>
-
-</TABLE>
-
-<SCRIPT TYPE="text/javascript">
+    // remove the actual row
+    var thisrow = document.getElementById('row'+thisrownum);
+    thisrow.parentNode.removeChild(thisrow);
+    // remove row from tally of all rows
+    var newrows = [];
+    for (i = 0; i < allrows.length; i++) {
+      if (allrows[i] == thisrownum) continue;
+      newrows.push(allrows[i]);
+    }
+    allrows = newrows;
+    <% $opt{prefix} %>totalrows--; // should never be deleting empty rows
+    <% $opt{prefix} %>updateTotalRow();
+    // recalculate column totals, if any
 % my $col = 0;
 % foreach my $footer ( @{$opt{footer}} ) {
 %   if ($footer eq '_TOTAL' ) {
-%     my $name = $opt{fields}->[$col];
-%     $name = ref($name) ? "column$col" : $name;
-      var <% $opt{prefix}.$name %>_CACHE = new Array ();
-      var <% $opt{prefix} %>th_el = document.getElementById("<%$name%>_TOTAL");
-      function <% $opt{prefix} %>calc_total<% $col %>() {
-        var row = 0;
-        var total = 0;
-        for ( var row = 0;
-              
-              ( <% $opt{prefix}.$name%>_CACHE[row] =
-                                        <% $opt{prefix}.$name%>_CACHE[row]
-                                     || document.getElementById("<%$name%>"+row)
-              ) != null;
-              
-              row++
-            )
-        {
-          var value = <%$name%>_CACHE[row].value;
-          value = parseFloat(value);
-          if ( ! isNaN(value) ) {
-            total = total + value;
-          }
-        }
-        <% $opt{prefix} %>th_el.innerHTML = '&nbsp;' + total.toFixed(2);
-
-      }
+    <% $opt{prefix} %>calc_total<% $col %>()
 %   }
 %   $col++;
 % }
-</SCRIPT>
-
-<% include('/elements/xmlhttp.html',
-              'url'  => $p. 'misc/xmlhttp-cust_main-search.cgi',
-              'subs' => [qw( custnum_search smart_search invnum_search )],
-           )
-%>
-
-<SCRIPT TYPE="text/javascript">
-
-  var <% $opt{prefix} %>total_el =
-    document.getElementById("<% $opt{'prefix'} %>_TOTAL_TOTAL");
-
-  var <% $opt{prefix} %>rownum = <% $row %>;
+  }
 
-  function <% $opt{prefix} %>addRow() {
+  function <% $opt{prefix} %>addRow(values) {
 
     var table = document.getElementById('<% $opt{prefix} %>OneTrueTable');
     var tablebody = table.getElementsByTagName('tbody').item(0);
 
     var row = table.insertRow(table.rows.length - 1);
-    row.setAttribute('id', 'row'+rownum);
+    var thisrownum = values ? values.rownum : <% $opt{prefix} %>rownum;
+    row.setAttribute('id', 'row'+thisrownum);
+    row.emptyrow = values ? false : true;
     
     var invnum_cell = document.createElement('TD');
 
       var invnum_input = document.createElement('INPUT');
-      invnum_input.setAttribute('name', 'invnum'+<% $opt{prefix} %>rownum);
-      invnum_input.setAttribute('id',   'invnum'+<% $opt{prefix} %>rownum);
+      invnum_input.setAttribute('name', 'invnum'+thisrownum);
+      invnum_input.setAttribute('id',   'invnum'+thisrownum);
       invnum_input.style.textAlign = 'right';
       invnum_input.setAttribute('size', 8);
       invnum_input.setAttribute('maxlength', 12);
-      invnum_input.setAttribute('rownum', <% $opt{prefix} %>rownum);
+      invnum_input.setAttribute('rownum', thisrownum);
+      invnum_input.value = values ? values.invnum : '';
       invnum_input.onfocus = clearhint_invnum;
       invnum_input.onchange = <% $opt{prefix} %>search_invnum;
       invnum_cell.appendChild(invnum_input);
@@ -584,15 +488,24 @@ Example:
 
     var custnum_cell = document.createElement('TD');
 
+      var display_custnum_input = document.createElement('INPUT');
+      display_custnum_input.setAttribute('name', 'display_custnum'+thisrownum);
+      display_custnum_input.setAttribute('id',   'display_custnum'+thisrownum);
+      display_custnum_input.style.textAlign = 'right';
+      display_custnum_input.setAttribute('size', 8);
+      display_custnum_input.setAttribute('maxlength', 12);
+      display_custnum_input.setAttribute('rownum', thisrownum);
+      display_custnum_input.value = values ? values.custnum : '';
+      display_custnum_input.onfocus = clearhint_custnum;
+      display_custnum_input.onchange = <% $opt{prefix} %>search_custnum;
+      custnum_cell.appendChild(display_custnum_input);
+
       var custnum_input = document.createElement('INPUT');
-      custnum_input.setAttribute('name', 'custnum'+<% $opt{prefix} %>rownum);
-      custnum_input.setAttribute('id',   'custnum'+<% $opt{prefix} %>rownum);
-      custnum_input.style.textAlign = 'right';
-      custnum_input.setAttribute('size', 8);
-      custnum_input.setAttribute('maxlength', 12);
-      custnum_input.setAttribute('rownum', <% $opt{prefix} %>rownum);
-      custnum_input.onfocus = clearhint_custnum;
-      custnum_input.onchange = <% $opt{prefix} %>search_custnum;
+      custnum_input.type = 'hidden';
+      custnum_input.setAttribute('name', 'custnum'+thisrownum);
+      custnum_input.setAttribute('id',   'custnum'+thisrownum);
+      custnum_input.setAttribute('rownum', thisrownum);
+      custnum_input.value = values ? values.custnum : '';
       custnum_cell.appendChild(custnum_input);
 
     row.appendChild(custnum_cell);
@@ -601,23 +514,29 @@ Example:
       status_cell.style.textAlign = 'center';
         
       var status_span = document.createElement('SPAN');
-      status_span.setAttribute('id', 'status'+<% $opt{prefix} %>rownum+'_text');
+      status_span.setAttribute('id', 'status'+thisrownum+'_text');
       status_span.style.fontWeight = 'bold';
-      status_span.setAttribute('rownum', <% $opt{prefix} %>rownum);
+      status_span.style.color = values ? values.statuscolor : '';
+      status_span.setAttribute('rownum', thisrownum);
+      status_span.appendChild(
+        document.createTextNode(values ? values.status : '')
+      );
       status_cell.appendChild(status_span);
         
       var status_input = document.createElement('INPUT');
       status_input.setAttribute('type', 'hidden');
-      status_input.setAttribute('name', 'status'+<% $opt{prefix} %>rownum);
-      status_input.setAttribute('id',   'status'+<% $opt{prefix} %>rownum);
-      status_input.setAttribute('rownum', <% $opt{prefix} %>rownum);
+      status_input.setAttribute('name', 'status'+thisrownum);
+      status_input.setAttribute('id',   'status'+thisrownum);
+      status_input.setAttribute('rownum', thisrownum);
+      status_input.value = values ? values.status : '';
       status_cell.appendChild(status_input);
 
       var statuscolor_input = document.createElement('INPUT');
       statuscolor_input.setAttribute('type', 'hidden');
-      statuscolor_input.setAttribute('name', 'statuscolor'+<% $opt{prefix} %>rownum);
-      statuscolor_input.setAttribute('id',   'statuscolor'+<% $opt{prefix} %>rownum);
-      statuscolor_input.setAttribute('rownum', <% $opt{prefix} %>rownum);
+      statuscolor_input.setAttribute('name', 'statuscolor'+thisrownum);
+      statuscolor_input.setAttribute('id',   'statuscolor'+thisrownum);
+      statuscolor_input.setAttribute('rownum', thisrownum);
+      statuscolor_input.value = values ? values.statuscolor : '';
       status_cell.appendChild(statuscolor_input);
 
     row.appendChild(status_cell);
@@ -625,20 +544,21 @@ Example:
     var customer_cell = document.createElement('TD');
 
       var customer_input = document.createElement('INPUT');
-      customer_input.setAttribute('name', 'customer'+<% $opt{prefix} %>rownum);
-      customer_input.setAttribute('id',   'customer'+<% $opt{prefix} %>rownum);
+      customer_input.setAttribute('name', 'customer'+thisrownum);
+      customer_input.setAttribute('id',   'customer'+thisrownum);
       customer_input.setAttribute('size', 64);
       customer_input.setAttribute('value', '(last name or company)' );
-      customer_input.setAttribute('rownum', <% $opt{prefix} %>rownum);
+      customer_input.setAttribute('rownum', thisrownum);
+      customer_input.value = values ? values.customer : '';
       customer_input.onfocus = clearhint_customer;
       customer_input.onclick = clearhint_customer;
       customer_input.onchange = <% $opt{prefix} %>search_customer;
       customer_cell.appendChild(customer_input);
 
       var customer_select = document.createElement('SELECT');
-      customer_select.setAttribute('name', 'cust_select'+<% $opt{prefix} %>rownum);
-      customer_select.setAttribute('id',   'cust_select'+<% $opt{prefix} %>rownum);
-      customer_select.setAttribute('rownum', <% $opt{prefix} %>rownum);
+      customer_select.setAttribute('name', 'cust_select'+thisrownum);
+      customer_select.setAttribute('id',   'cust_select'+thisrownum);
+      customer_select.setAttribute('rownum', thisrownum);
       customer_select.style.color = '#ff0000';
       customer_select.style.display = 'none';
       customer_select.onchange = select_customer;
@@ -652,21 +572,29 @@ Example:
       balance_cell.appendChild(document.createTextNode('<%$money_char%>'));
 
       var balance_span = document.createElement('SPAN');
-      balance_span.setAttribute('id', 'balance'+<% $opt{prefix} %>rownum+'_text');
-      balance_span.setAttribute('rownum', <% $opt{prefix} %>rownum);
+      balance_span.setAttribute('id', 'balance'+thisrownum+'_text');
+      balance_span.setAttribute('rownum', thisrownum);
       balance_cell.appendChild(balance_span);
 
       balance_cell.appendChild(
-        document.createTextNode(String.fromCharCode(160)) //&nbsp;
+        document.createTextNode(String.fromCharCode(160) + (values ? values.balance : '')) //&nbsp;
       );
 
       var balance_input = document.createElement('INPUT');
       balance_input.setAttribute('type', 'hidden');
-      balance_input.setAttribute('name', 'balance'+<% $opt{prefix} %>rownum);
-      balance_input.setAttribute('id',   'balance'+<% $opt{prefix} %>rownum);
-      balance_input.setAttribute('rownum', <% $opt{prefix} %>rownum);
+      balance_input.setAttribute('name', 'balance'+thisrownum);
+      balance_input.setAttribute('id',   'balance'+thisrownum);
+      balance_input.setAttribute('rownum', thisrownum);
+      balance_input.value = values ? values.balance : '';
       balance_cell.appendChild(balance_input);
 
+      var num_open_input = document.createElement('INPUT');
+      num_open_input.setAttribute('type', 'hidden');
+      num_open_input.setAttribute('name', 'num_open'+thisrownum);
+      num_open_input.setAttribute('id',   'num_open'+thisrownum);
+      num_open_input.setAttribute('rownum', thisrownum);
+      balance_cell.appendChild(num_open_input);
+
     row.appendChild(balance_cell);
 
 %   my $col = 0;
@@ -676,29 +604,24 @@ Example:
       my_cell.setAttribute('align', '<% $align{ $opt{align}->[$col] || 'l' } %>');
 
 %     if ($types->[$col] eq 'immutable') {
-%       my $value;
-%       if ( ref($field) eq 'CODE' ) {
-%         $value = &{$field}($row,$param);
-%       } else {
-%         $value = $param->{"$field$row"}; 
-%       }
-        var my_text = document.createTextNode(<% $value |js_string %>);
+        var my_text = document.createTextNode(values ? values.<% $field %> : '');
         my_cell.appendChild(my_text);
 %     }
 
 %     my $name  = (ref($field) eq 'CODE') ? "column${col}_" : $field;
       var my_input = document.createElement('INPUT');
-      my_input.setAttribute('name', '<% $name %>'+<% $opt{prefix} %>rownum);
-      my_input.setAttribute('id',   '<% $name %>'+<% $opt{prefix} %>rownum);
+      my_input.setAttribute('name', '<% $name %>'+thisrownum);
+      my_input.setAttribute('id',   '<% $name %>'+thisrownum);
       my_input.style.textAlign = '<% $align{ $opt{align}->[$col] || 'l' } %>';
       my_input.setAttribute('size', <% $sizes->[$col] || 10 %>);
-      my_input.setAttribute('rownum', <% $opt{prefix} %>rownum);
+      my_input.setAttribute('rownum', thisrownum);
 %     if ( $types->[$col] eq 'immutable' ) {
-        my_input.setAttribute('type', 'hidden');
-%     }
-%     elsif ( $types->[$col] eq 'checkbox' ) {
-        my_input.setAttribute('type', 'checkbox');
+      my_input.setAttribute('type', 'hidden');
+%     } elsif ( $types->[$col] eq 'checkbox' ) {
+      my_input.setAttribute('type', 'checkbox');
+      my_input.checked = (values && values.<% $field %>) ? true : false;
 %     }
+      my_input.value = (values && values.<% $field %>) || '';
 %     if ( $opt{onchange}->[$col] ) {
         my_input.onchange   = <% $opt{onchange}->[$col] %>;
 %     }
@@ -713,38 +636,146 @@ Example:
 %     $col++;
 %   }
 
-    //update the total # of rows display
-    if ( <% $opt{prefix} %>rownum == 1 ) {
-      <% $opt{prefix} %>total_el.innerHTML =
-        'Total '
-          + <% $opt{prefix} %>rownum
-          + ' <% $opt{name_singular} || 'customer' %>';
-    } else {
-      <% $opt{prefix} %>total_el.innerHTML =
-        'Total '
-          + <% $opt{prefix} %>rownum
-          + ' <% PL($opt{name_singular} || 'customer') %>';
+    var td_delete = document.createElement('TD');
+    td_delete.setAttribute('id', 'delete'+thisrownum);
+    row.appendChild(td_delete);
+    if (values) {
+      <% $opt{prefix} %>addDeleteButton(thisrownum);
     }
 
+    update_num_open(thisrownum, (values ? values.num_open : '0'));
+
 % if ( $opt{add_row_callback} ) {
-    <% $opt{add_row_callback} %>(<% $opt{prefix} %>rownum,
-                                 '<% $opt{prefix} %>');
+    <% $opt{add_row_callback} %>(thisrownum,
+                                 '<% $opt{prefix} %>', values);
 % }
 
-    <% $opt{prefix} %>rownum++;
+    // update the total number of rows display
+    allrows.push(thisrownum);
+    if (values) <% $opt{prefix} %>totalrows++;
+    <% $opt{prefix} %>updateTotalRow();
 
-  }
+    // update the next available row number
+    if (thisrownum >= <% $opt{prefix} %>rownum) {
+      <% $opt{prefix} %>rownum = thisrownum + 1;
+    }
+
+  } // end of addRow
+
+
+</SCRIPT>
 
-% unless ($cgi->param('error')) {
-  <% $opt{prefix} %>addRow();
+<TABLE ID="<% $opt{prefix} %>OneTrueTable" BGCOLOR="#cccccc" BORDER=0 CELLSPACING=0>
+
+<TR>
+  <TH>Inv #</TH>
+  <TH>Cust #</TH>
+  <TH>Status</TH>
+  <TH>Customer</TH>
+  <TH>Balance</TH>
+% foreach my $header ( @{$opt{header}} ) {
+    <TH><% $header %></TH>
+% }
+</TR>
+
+% my @rownums = sort { $a <=> $b } map /^custnum(\d+)$/, keys %$param;
+<TR id="row_total">
+  <TH COLSPAN=5 ID="<% $opt{'prefix'} %>_TOTAL_TOTAL">
+    Total <% @rownums || 0 %>
+    <% PL($opt{name_singular} || 'customer', ( @rownums || 0 ) ) %>
+  </TH>
+% my $col = 0;
+% foreach my $footer ( @{$opt{footer}} ) {
+%   my $align = $align{ $opt{'footer_align'}->[$col] || 'c' };
+%   if ($footer eq '_TOTAL' ) {
+%     my $id = $opt{'fields'}->[$col];
+%     $id = ref($id) ? "column${col}_TOTAL" : "${id}_TOTAL";
+      <TH ALIGN="<% $align %>" ID="<% $id %>">&nbsp;<% sprintf('%.2f', $total[$col] ) %></TH>
+%   } else {
+      <TH ALIGN="<% $align %>"><% $footer %></TH>
+%   }
+%   $col++;
+% }
+</TR>
+
+</TABLE>
+
+<SCRIPT TYPE="text/javascript">
+
+<% $opt{prefix} %>total_el =
+  document.getElementById("<% $opt{'prefix'} %>_TOTAL_TOTAL");
+
+<% $opt{prefix} %>rownum = 1; // really more of a "next row", used by addrow
+<% $opt{prefix} %>totalrows = 0; // will not include empty rows
+<% $opt{prefix} %>allrows = []; // will include empty rows
+
+% foreach my $row ( @rownums ) {
+%   if ( grep($param->{$_.$row},qw(invnum display_custnum custnum status statuscolor customer balance),@{$opt{fields}} ) ) {
+
+<% $opt{prefix} %>addRow({
+  rownum:<% $row %>,
+  num_open:<% $param->{"num_open$row"} |js_string %>,
+  invnum:<% $param->{"invnum$row"} |js_string %>,
+  display_custnum:<% $param->{"display_custnum$row"} |js_string %>,
+  custnum:<% $param->{"custnum$row"} |js_string %>,
+  status:<% $param->{"status$row"} |js_string %>,
+  statuscolor:<% $param->{"statuscolor$row"} |js_string %>,
+  customer:<% $param->{"customer$row"} |js_string %>,
+  balance:<% $param->{"balance$row"} |js_string %>,
+%     my $col = 0;
+%     foreach my $field ( @{$opt{fields}} ) {
+%       my $value;
+%       if ( ref($field) eq 'CODE' ) {
+%         $value = &{$field}($row,$param) || '';
+%       } else {
+%         $value = $param->{"$field$row"} || '';
+%       }
+%       my $name  = (ref($field) eq 'CODE') ? "column${col}" : "$field";
+  <% $name %>:<% $value |js_string %>,
+%       $col++;
+%     }
+});
+%   }
+% }
+
+<% $opt{prefix} %>addRow();
+
+% my $col = 0;
+% foreach my $footer ( @{$opt{footer}} ) {
+%   if ($footer eq '_TOTAL' ) {
+%     my $name = $opt{fields}->[$col];
+%     $name = ref($name) ? "column$col" : $name;
+      var <% $opt{prefix} %>th_el = document.getElementById("<%$name%>_TOTAL");
+      function <% $opt{prefix} %>calc_total<% $col %>() {
+        var row = 0;
+        var total = 0;
+        for (i = 0; i < <% $opt{prefix} %>allrows.length; i++) {
+          var value = document.getElementById("<%$name%>"+<% $opt{prefix} %>allrows[i]).value;
+          value = parseFloat(value);
+          if ( ! isNaN(value) ) {
+            total = total + value;
+          }
+        }
+        <% $opt{prefix} %>th_el.innerHTML = '&nbsp;' + total.toFixed(2);
+      }
+      <% $opt{prefix} %>calc_total<% $col %>()
+%   }
+%   $col++;
 % }
 </SCRIPT>
 
+<% include('/elements/xmlhttp.html',
+              'url'  => $p. 'misc/xmlhttp-cust_main-search.cgi',
+              'subs' => [qw( custnum_search smart_search invnum_search )],
+           )
+%>
+
 <%init>
 
 my(%opt) = @_;
 my $conf = new FS::Conf;
 
+## caution when using prefix, it isn't consistently applied to tag id/name
 $opt{prefix} = '' unless defined $opt{prefix};
 $opt{prefix} .= '_' if $opt{prefix};