a:15:{i:0;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:22:"fv2_shipping_doit_form";s:4:"nome";s:0:"";s:4:"tipo";s:0:"";s:5:"parms";s:0:"";s:6:"codigo";s:0:"";}i:1;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:22:"fv2_shipping_doit_form";s:4:"nome";s:16:"DYE_LOT_onChange";s:4:"tipo";s:1:"A";s:5:"parms";s:0:"";s:6:"codigo";s:11:"dlchange();";}i:2;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:22:"fv2_shipping_doit_form";s:4:"nome";s:18:"OUR_ORDER_onChange";s:4:"tipo";s:1:"A";s:5:"parms";s:0:"";s:6:"codigo";s:14:"orderchange();";}i:3;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:22:"fv2_shipping_doit_form";s:4:"nome";s:14:"TERMS_onChange";s:4:"tipo";s:1:"A";s:5:"parms";s:0:"";s:6:"codigo";s:14:"termschange();";}i:4;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:22:"fv2_shipping_doit_form";s:4:"nome";s:8:"dlchange";s:4:"tipo";s:1:"M";s:5:"parms";s:0:"";s:6:"codigo";s:277:"$check_sql = "SELECT p_o_number"
   . " FROM fgstock"
   . " WHERE dye_lot = '" . {dye_lot} . "'";
sc_lookup(rs, $check_sql);

if (isset({rs[0][0]}))     // Row found
{
    {p_o_number} = {rs[0][0]};					
}
		else     // No row found
{			
    {p_o_number} = '';
}
";}i:5;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:22:"fv2_shipping_doit_form";s:4:"nome";s:13:"onAfterUpdate";s:4:"tipo";s:1:"E";s:5:"parms";s:0:"";s:6:"codigo";s:0:"";}i:6;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:22:"fv2_shipping_doit_form";s:4:"nome";s:17:"onApplicationInit";s:4:"tipo";s:1:"E";s:5:"parms";s:0:"";s:6:"codigo";s:0:"";}i:7;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:22:"fv2_shipping_doit_form";s:4:"nome";s:14:"onBeforeUpdate";s:4:"tipo";s:1:"E";s:5:"parms";s:0:"";s:6:"codigo";s:0:"";}i:8;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:22:"fv2_shipping_doit_form";s:4:"nome";s:9:"onLoadAll";s:4:"tipo";s:1:"E";s:5:"parms";s:0:"";s:6:"codigo";s:161:"[var_style]={style};
[var_smit]={smit};
[var_bcode]={bcode};
[var_dyelot]={dye_lot};
if({status}=='$')
{
readonlyon();
}
else
{
readonlyoff();
}


";}i:9;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:22:"fv2_shipping_doit_form";s:4:"nome";s:10:"onNavigate";s:4:"tipo";s:1:"E";s:5:"parms";s:0:"";s:6:"codigo";s:0:"";}i:10;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:22:"fv2_shipping_doit_form";s:4:"nome";s:9:"onRefresh";s:4:"tipo";s:1:"E";s:5:"parms";s:0:"";s:6:"codigo";s:0:"";}i:11;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:22:"fv2_shipping_doit_form";s:4:"nome";s:11:"orderchange";s:4:"tipo";s:1:"M";s:5:"parms";s:0:"";s:6:"codigo";s:876:"$check_sql = "SELECT c_o_number,style,color,color_no,width,price,lin_sq"
   . " FROM asst"
   . " WHERE our_order = '" . {our_order} . "'";
sc_lookup(rs, $check_sql);

if (isset({rs[0][0]}))     // Row found
{
    {custno} = {rs[0][0]};		
	{style} = {rs[0][1]};	
	{color} = {rs[0][2]};	
	{color_no} = {rs[0][3]};	
//	{width} = {rs[0][4]};	
	{price} = {rs[0][5]};	
	{unit} = {rs[0][6]};
	
}
		else     // No row found
{			
    {custno} = '';
	{style} = '';	
	{color} = '';	
	{color_no} = '';	
	{width} = '';	
	{price} = '';	
	{unit} = '';
}
$check_sql = "SELECT terms,terms2"
   . " FROM `order`"
   . " WHERE `order` = '" . {our_order} . "'";
sc_lookup(rs, $check_sql);

if (isset({rs[0][0]}))     // Row found
{
    {terms} = {rs[0][0]};	
	{terms2} = {rs[0][1]};	
}
		else     // No row found
{
		    {terms} = '';
	 {terms2} = '';
}
";}i:12;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:22:"fv2_shipping_doit_form";s:4:"nome";s:11:"readonlyoff";s:4:"tipo";s:1:"M";s:5:"parms";s:0:"";s:6:"codigo";s:895:"sc_field_readonly({our_order},off);
sc_field_readonly({custno},off);
sc_field_readonly({desc},off);
sc_field_readonly({price},off);
sc_field_readonly({unit},off);
sc_field_readonly({dye_lot},off);
sc_field_readonly({p_o_number},off);
sc_field_readonly({style},off);
sc_field_readonly({color},off);
sc_field_readonly({color_no},off);
sc_field_readonly({width},off);
sc_field_readonly({lyards},off);
sc_field_readonly({syards},off);
sc_field_readonly({approx},off);
sc_field_readonly({memo},off);
sc_field_readonly({sdate},off);
sc_field_readonly({bl},off);
sc_field_readonly({terms},off);
sc_field_readonly({terms2},off);
sc_field_readonly({factor},off);
sc_btn_display('lockrecord','on');
sc_btn_display('unlockrecord','off');
sc_btn_display('rollselection','on');
sc_btn_display('updatepackinglist','on');
sc_btn_display('delete','on');
sc_btn_display('update','on');
";}i:13;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:22:"fv2_shipping_doit_form";s:4:"nome";s:10:"readonlyon";s:4:"tipo";s:1:"M";s:5:"parms";s:0:"";s:6:"codigo";s:877:"sc_field_readonly({our_order},on);
sc_field_readonly({custno},on);
sc_field_readonly({desc},on);
sc_field_readonly({price},on);
sc_field_readonly({unit},on);
sc_field_readonly({dye_lot},on);
sc_field_readonly({p_o_number},on);
sc_field_readonly({style},on);
sc_field_readonly({color},on);
sc_field_readonly({color_no},on);
sc_field_readonly({width},on);
sc_field_readonly({lyards},on);
sc_field_readonly({syards},on);
sc_field_readonly({approx},on);
sc_field_readonly({memo},on);
sc_field_readonly({sdate},on);
sc_field_readonly({bl},on);
sc_field_readonly({terms},on);
sc_field_readonly({terms2},on);
sc_field_readonly({factor},on);
sc_btn_display('lockrecord','off');
sc_btn_display('unlockrecord','on');
sc_btn_display('rollselection','off');
sc_btn_display('updatepackinglist','off');
sc_btn_display('delete','off');
sc_btn_display('update','off');";}i:14;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:22:"fv2_shipping_doit_form";s:4:"nome";s:17:"updatepackinglist";s:4:"tipo";s:1:"M";s:5:"parms";s:0:"";s:6:"codigo";s:502:"$filename='/var/www/veratex.vrtxinc.com/myfile_'.date('m-d-Y_hisa');
	$output_sql = "
select concat(RPAD('ROLL#',23,' '),LPAD('YARDS',10,' '))
union 
select concat( RPAD(concat(`case`,suffix),21,' '),' ',LPAD(yds,10,' '))
INTO OUTFILE '$filename' 
FROM n3case where n3case.smit='[var_smit]'
";
sc_exec_sql($output_sql);
$save_outfile="	
UPDATE doit
SET memo = LOAD_FILE('$filename')
WHERE smit = '[var_smit]'
";
sc_exec_sql($save_outfile);	
sc_redir("fv2_shipping_doit_form","","_self");";}}