nuBuilder Forum

Code: Select all

//--changing style in a Browse Form

$s = <<<EOSQL

CREATE TABLE #browseTable# SELECT 
customer_id,
cus_code,
cus_phone,
cus_mobile,
cus_fax,

IF(LEFT(cus_name,1)="J", CONCAT('<b>',cus_name,'</b>'),cus_name) AS cus_name

FROM customer


EOSQL;

nuRunQuery($s);

//--running JavaScript on a Browse Form

$j = <<<EOJS

function nuLoadThis(){

   alert('Customer Names Starting with "J" have been highlighted');

}

EOJS;

addJSfunction($j);

Code: Select all

SELECT * FROM #browseTable#

Code: Select all

//--running JavaScript on a Browse Form
$j = "";

addJSfunction($j);

Code: Select all

//--running JavaScript on a Browse Form

$j = <<<EOJS


function hideSell(sell){
    document.getElementById(sell).innerHTML = "";
    document.getElementById(sell).onmouseover = "";
    document.getElementById(sell).onmouseout = "";
    document.getElementById(sell).onclick = "";
    document.getElementById(sell).style.cursor = "default";
}

function rowsHide(){//---hide rows that unactive

   var columeNumber = 6;   //---number with code colum
   var unactiveCode = 20;  //---unactive code

   //---hide colum title
   element = document.getElementById("title"+columeNumber);
   element.parentNode.removeChild(element);
   
   //---for each row in browse form
   for(i = 0 ; i < 5 ; i++){   
      if ( i < 10 ) {
        rw = "rw0" + i;
      } else { 
        rw = "rw" + i;
      }
      
      //---get volume from code colume and hide this colum
      vol = document.getElementById(rw+columeNumber).innerHTML;
      vol = vol.substring(9,11);
      hideSell(rw+columeNumber);
      
      //---if this unactive element hide whole row
      if (vol == unactiveCode) {   
      
        //---for each colom for specific row
        for(j = 0 ; j < 7 ; j++){ 
          hideSell(rw+j);
        };
      }
   };
}

function nuLoadThis(){
   rowsHide();
}

EOJS;

addJSfunction($j);

Code: Select all

$(document).ready(function () {
 //code
});