a:4:{i:0;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:35:"fv2_billing_n3case_avail_multi_form";s:4:"nome";s:14:"Select_onClick";s:4:"tipo";s:1:"A";s:5:"parms";s:0:"";s:6:"codigo";s:232:"$invoice=[var_invoice];
$item=[var_item];
if({invoice}<>$invoice OR {it}<>$item)
{	
	$do_change=$invoice;
	$do_change2=$item;
	
}
else
	{
	$do_change='';
	$do_change2='';
		}
{invoice}=$do_change;
{it}=$do_change2;

";}i:1;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:35:"fv2_billing_n3case_avail_multi_form";s:4:"nome";s:13:"onAfterUpdate";s:4:"tipo";s:1:"E";s:5:"parms";s:0:"";s:6:"codigo";s:13:"pickchange();";}i:2;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:35:"fv2_billing_n3case_avail_multi_form";s:4:"nome";s:10:"onNavigate";s:4:"tipo";s:1:"E";s:5:"parms";s:0:"";s:6:"codigo";s:0:"";}i:3;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:35:"fv2_billing_n3case_avail_multi_form";s:4:"nome";s:10:"pickchange";s:4:"tipo";s:1:"M";s:5:"parms";s:0:"";s:6:"codigo";s:706:"$filename='/var/www/veratex.vrtxinc.com/myfile_'.date('m-d-Y_hisa');
	$output_sql = "
select concat(RPAD('.    ',23,' '),LPAD('.    ',10,' '))
union 
select concat(RPAD('.    ',23,' '),LPAD('.    ',10,' '))
union 
select concat(RPAD('ROLL#',23,' '),LPAD('YARDS',10,' '))
union
select concat(RPAD(concat(n3case.case,suffix),21,' '),' ',LPAD(yds,10,' '))
INTO OUTFILE '$filename' 
FROM n3case WHERE n3case.invoice='[var_invoice]' and n3case.it='[var_item]'
";
sc_exec_sql($output_sql);
$save_outfile="	
UPDATE item
SET memo = LOAD_FILE('$filename')
WHERE invoice = '[var_invoice]' and item='[var_item]'
";
sc_exec_sql($save_outfile);	
sc_redir("fv2_billing_item_single_form","","_self");
";}}