<?php

$opts['flt']=flt; // controls filtering based on meny selection
$opts['prt']=prt; // changes header for printing or not

$opts['cgi']['persist'] = array(
		'flt' => $flt,
		'prt' => $prt
		);

// this filters data to logged in user in postnuke
@include_once('brd_filter_data.php');

// this selects user default values
$db_object=@mysql_pconnect("localhost","rabway","fskiujVUas");

@mysql_selectdb("rabway_breeding");

$query="select def_palpatate,def_boxs,def_rebreed,def_wean,def_process,flg_nest,flg_cntday,flg_cntweek,flg_cntnow,flg_wgt,flg_wgt_mte,flg_wgt_wean,flg_wgt21,flg_wgt50,flg_wgt56,flg_wgt70,flg_name,flg_palpatate from breeder where rabbitry_id='$origin'";

$cur=@mysql_query($query);
$row=@mysql_fetch_array($cur);
$var_palp="$row[0]";
$var_boxs="$row[1]";
$var_bred="$row[2]";
$var_wean="$row[3]";
$var_proc="$row[4]";
$flg_cntday="$row[5]";
$flg_cntweek="$row[6]";
$flg_cntnow="$row[7]";
$flg_nest="$row[8]";
$flg_wgt="$row[9]";
$flg_wgt_mte="$row[10]";
$flg_wgt_wean="$row[11]";
$flg_wgt21="$row[12]";
$flg_wgt50="$row[13]";
$flg_wgt56="$row[14]";
$flg_wgt70="$row[15]";
$flg_name="$row[16]";
$flg_palp="$row[17]";

// this updates some fields from another table
// update progeny status
$query  = "UPDATE mating, pedigree "; 
$query .= "SET mate_prog_status=pedigree.status,prog_doe_brd=pedigree.prog_breed_desc "; 
$query .= "WHERE pedigree.prog_user=mating.prog_doe AND mating.data_origin='$origin' "; 
$process=@mysql_query($query);
@mysql_close($db_object);

//  MySQL host name, user name, password, database, and table to edit
$opts["hn"] = "localhost";
$opts["un"] = "rabway_rjames";
$opts["pw"] = "merino";
$opts["db"] = "rabway_breeding";
$opts["tb"] = "mating";

//-------------

if ($flt == 1 AND $prt=='N'){

$cfg['page_title'] = 'RW-Kindle'; // passed to the header file
$cfg['page_script']='Current Kindlings for ';
$cfg['page_note']='Update kindling data for current does - status/dates/counts/weights';

@include_once('brd_header.php');

$opts['filters'] ="PMEtable0.data_origin = $origin AND (mate_status='20' OR mate_status='30' OR mate_status='40' OR mate_status='50')";

$opts['sort_field'] = array('calc_list_sort','prog_doe');

$opts['inc'] = 15;
$opts['navigation'] = 'GU';
$opts['triggers']['update']['after']  = 'brd_kdl_tua.inc';
$opts['options'] = 'CVF';

}elseif ($flt == 1 AND $prt=='Y'){

$cfg['page_title'] = 'RW-Kindle'; // passed to the header file
$cfg['page_script']='Current Kindlings for ';
$cfg['page_note']='Update kindling data for current does - status/dates/counts/weights';

@include_once('brd_header_prt.php');

$opts['filters'] ="PMEtable0.data_origin = $origin AND (mate_status='20' OR mate_status='30' OR mate_status='40' OR mate_status='50')";
$opts['sort_field'] = array('calc_list_sort','prog_doe');
$opts['inc'] = 25;
$opts['navigation'] = 'GU';
$opts['options'] = 'F';

}elseif ($flt == 2 AND $prt=='N'){

$cfg['page_title'] = 'RW-Kindle'; // passed to the header file
$cfg['page_script']='All Kindlings for ';
$cfg['page_note']='Kindlings for all does';

@include_once('brd_header.php');

$opts['filters'] ="PMEtable0.data_origin = $origin";
$opts['sort_field'] = array('prog_doe','mate_count');
$opts['inc'] = 20;
$opts['navigation'] = 'GUD';
$opts['triggers']['update']['after']  = 'brd_kdl_tua.inc';
$opts['options'] = 'CVF';

}elseif ($flt == 2 AND $prt=='Y'){

$cfg['page_title'] = 'RW-Kindle'; // passed to the header file
$cfg['page_script']='All Kindlings for ';
$cfg['page_note']='Kindlings for all does';

@include_once('brd_header_prt.php');

$opts['filters'] ="PMEtable0.data_origin = $origin  AND mate_prog_status='10'";
$opts['sort_field'] = array('prog_doe','mate_count');
$opts['inc'] = 30;
$opts['navigation'] = 'GU';
$opts['options'] = '';

}

//-------------


//start of main phpmyedit script

$opts["key"] = "mating_id";
$opts["key_type"] = "int";
$opts['multiple'] = '5';
$opts['display'] = array(
	'query' => true,
	'sort'  => true,
	'tabs'  => true,
	'time'  => false
	);

$opts['url'] = array(
		'images' => 'images/'
		);

$opts['fdd']['mating_id'] = array(
	'name'=>'Ref',
	'select'=>'T',
	'type'=>'int',
	'maxlen'=>10,
	'nowrap'=>false,
	'required'=>true,
	'sort'=>true,
	'options'=>'LR',
	'colattrs|L'=>'align="center"'
);

$opts['fdd']['data_origin'] = array(
	'name'=>'Herd',
	'select'=>'D',
	'options'=>'H',
	'type'=>'string',
	'maxlen'=>5,
	'nowrap'=>false,
	'required'=>true,
	'sort'=>true,
	'default'=>$origin,
	'values'=>array(
	'db'=>'rabway_breeding',
	'table'=>'breeder',
	'orderby'=>'rabbitry',
	'column'=>'rabbitry_id',
	'description'=>'rabbitry')
);


if ($flt==2){
$opts['fdd']['mate_prog_status'] = array(
  'name'     => 'Prg_Sts',
	'options'=>'LVFDR',
	'select'=>'D',
	'sort'=>true,
	'nowrap'=>true,
  'values2' => array(
	'10' => 'Current',
	'20' => 'Current-Other',
	'50' => 'Sold',
	'60' => 'Culled',
	'70' => 'Died',
	'85' => 'Pedigree',
	'90' => 'Default'
		)
);
}

/*
$opts['fdd']['list_batch'] = array(
	'name'=>'Batch',
	'select'=>'M',
	'maxlen'=>5,
	'sort'=>true,
	'options'=>'LF',
	'sql'=>'CONCAT(batch)',
//	'colattrs|L'=>'align="center"',

	'values'=>array(
	'db'=>'rabway_breeding',
	'table'=>'user_options',
	'orderby'=>'list_index',
	'column'=>'list_idn',
	'filters'=>"list_origin = $origin AND list_group='BCH'",
	'description'=>'list_detail')
	
);


$opts['fdd']['list_mate_status'] = array(
	'name'=>'Mat Sts',
	'select|F'=>'M',
	'maxlen'=>3,
	'nowrap'=>true,
	'sort'=>true,
	'options'=>'LF',
	'sql'=>'CONCAT(mate_status)',
  'values2' => array(
	'20'   => 'Dry',
	'30'   => 'Mated',
	'40'   => 'Lactate',
	'50'   => 'Weaned',
	'60'   => 'Missed',
	'70'   => 'Complete'),
	'help'=>'Current status of this mating'
);
*/

$opts['fdd']['batch'] = array(
	'name'=>'Batch',
	'select'=>'D',
	'maxlen'=>10,
	'sort'=>true,
	'nowrap'=>true,
	'options'=>'ACLVDFP',
	'tab'=>'Mating/Kindle',
	'values'=>array(
	'db'=>'rabway_breeding',
	'table'=>'user_options',
	'orderby'=>'list_index',
	'column'=>'list_idn',
	'filters'=>"list_origin = $origin AND list_group='BCH'",
	'description'=>'list_detail')
);


$opts['fdd']['mate_status'] = array(
	'name'=>'Status',
	'select|F'=>'M',
	'maxlen'=>3,
	'nowrap'=>true,
	'sort'=>true,
	'options'=>'ACLVDFP',
  'values2' => array(
	'20'   => 'Dry',
	'30'   => 'Mated',
	'40'   => 'Lactate',
	'50'   => 'Weaned',
	'60'   => 'Missed',
	'70'   => 'Complete'),
	'help'=>'Current status of this mating'
);


$opts['fdd']['prog_doe'] = array(
  'name'     => 'Doe-Pen',
  'select'   => 'D',
  'maxlen'   => 25,
  'sort'     => true,
	'nowrap'=>true,
	'options'=>'LACVDR',
	'values'=>array(
	'db'=>'rabway_breeding',
	'table'=>'pedigree',
	'orderby'=>'prog_name',
	'column'=>'prog_user',
	'filters'=>"data_origin=$origin"),
/*
	'tab'=>array( 
  'name'    => 'Mating/Kindle', 
  'default' => true),
*/	
	);
	
$opts['fdd']['prog_doe']['help'] = 'ID of doe being mated'; 
$opts['fdd']['prog_doe']['colattrs'] = 'bgcolor="lightyellow" style="color: darkblue;font-weight:bold"';

$opts['fdd']['prog_doe']['values']['description']['columns'][0] = 'prog_name'; 
$opts['fdd']['prog_doe']['values']['description']['divs'][0]    = '-'; 
$opts['fdd']['prog_doe']['values']['description']['columns'][2] = 'pen_prog'; 


$opts['fdd']['prog_doe_brd'] = array(
  'name'     => 'Breed',
  'select'   => 'D',
  'maxlen'   => 5,
  'sort'     => true,
	'options'=>'LCVFR',
	);


if ($flt == '1'){
$opts['fdd']['prog_buck'] = array(
  'name'     => 'Buck',
  'select'   => 'D',
  'maxlen'   => 11,
	'nowrap'=>true,
  'sort'     => true,
	'options'=>'LACVDR',
	'help'=>'ID of buck to which this doe is mated',
	'values'=>array(
	'db'=>'rabway_breeding',
	'table'=>'pedigree',
	'orderby'=>'prog_name',
	'column'=>'prog_user',
	'filters'=>"data_origin = $origin AND prog_sex='1' AND (status='10' OR status='20' OR status='90')",
));

if ($flg_name=='Y'){
$opts['fdd']['prog_buck']['values']['description']['columns'][0] = 'prog_name'; 
$opts['fdd']['prog_buck']['values']['description']['divs'][0]    = '-'; 
$opts['fdd']['prog_buck']['values']['description']['columns'][1] = 'prog_nick'; 
$opts['fdd']['prog_buck']['values']['description']['divs'][1]    = '-'; 
$opts['fdd']['prog_buck']['values']['description']['columns'][2] = 'prog_breed_desc'; 
$opts['fdd']['prog_buck']['values']['description']['divs'][2]    = '-'; 
$opts['fdd']['prog_buck']['values']['description']['columns'][3] = 'pen_prog'; 
}else{
$opts['fdd']['prog_buck']['values']['description']['columns'][0] = 'prog_name'; 
$opts['fdd']['prog_buck']['values']['description']['divs'][0]    = '-'; 
$opts['fdd']['prog_buck']['values']['description']['columns'][1] = 'prog_breed_desc'; 
$opts['fdd']['prog_buck']['values']['description']['divs'][1]    = '-'; 
$opts['fdd']['prog_buck']['values']['description']['columns'][2] = 'pen_prog'; 
}
	
	
}elseif ($flt=='2'){

$opts['fdd']['prog_buck'] = array(
  'name'     => 'Buck',
  'select'   => 'D',
  'maxlen'   => 11,
	'nowrap'=>true,
  'sort'     => true,
	'options'=>'LACVDR',
	'help'=>'ID of buck to which this doe is mated',
	'values'=>array(
	'db'=>'rabway_breeding',
	'table'=>'pedigree',
	'orderby'=>'prog_name',
	'column'=>'prog_user',
	'filters'=>"data_origin = $origin AND prog_sex='1'",
));
if ($flg_name=='Y'){
$opts['fdd']['prog_buck']['values']['description']['columns'][0] = 'prog_name'; 
$opts['fdd']['prog_buck']['values']['description']['divs'][0]    = '-'; 
$opts['fdd']['prog_buck']['values']['description']['columns'][1] = 'prog_nick'; 
$opts['fdd']['prog_buck']['values']['description']['divs'][1]    = '-'; 
$opts['fdd']['prog_buck']['values']['description']['columns'][2] = 'prog_breed_desc'; 
$opts['fdd']['prog_buck']['values']['description']['divs'][2]    = '-'; 
$opts['fdd']['prog_buck']['values']['description']['columns'][3] = 'pen_prog'; 
}else{
$opts['fdd']['prog_buck']['values']['description']['columns'][0] = 'prog_name'; 
$opts['fdd']['prog_buck']['values']['description']['divs'][0]    = '-'; 
$opts['fdd']['prog_buck']['values']['description']['columns'][1] = 'prog_breed_desc'; 
$opts['fdd']['prog_buck']['values']['description']['divs'][1]    = '-'; 
$opts['fdd']['prog_buck']['values']['description']['columns'][2] = 'pen_prog'; 
}
}

$opts['fdd']['mate_count'] = array(
	'name'=>'Mate#',
	'select'=>'N',
	'options'=>'LVD',
	'maxlen'=>2,
	'sort'=>true,
	'values'=>range(1,25)
);
$opts['fdd']['mate_count']['help'] = 'Number of Matings for this doe'; 
$opts['fdd']['mate_count']['colattrs|L'] = 'align="center"';



if ($prt=='N'){
$opts['fdd']['mated'] = array(
	'name'=>'Mated',
	'select'=>'T',
	'type'=>'date',
	'maxlen'=>10,
	'nowrap'=>false,
	'options'=>'ACVDR',
	'datemask'=>'M-d-y',
	'sort'=>true,
	'help'=>'Date this doe was mated year-month-day eg. yyyy-mm-dd',
	'colattrs'=>'bgcolor="lightyellow" style="color: navy;font-weight:normal;text-align:left"'
);
}

$opts['fdd']['palp_days'] = array(
	'name'=>'Days to Palpation',
	'select'=>'D',
	'type'=>'int',
	'maxlen'=>2,
	'nowrap'=>false,
	'default'=>14,
	'sort'=>true,
	'options'=>'H',
	'values'=>range(8,20)
);

$opts['fdd']['calc_palp_date'] = array(
	'name'=>'Palpatate',
	'select'=>'T',
	'type'=>'date',
	'maxlen'=>10,
	'nowrap'=>false,
	'sort'=>true,
	'datemask'=>'M-d-y',
	'sql'=>'DATE_ADD(mated,interval palp_days day)',
	'options'=>'V'
);

$opts['fdd']['boxs_days'] = array(
	'name'=>'Days to Boxes',
	'select'=>'D',
	'type'=>'int',
	'maxlen'=>2,
	'nowrap'=>false,
	'default'=>28,
	'sort'=>true,
	'options'=>'H',
	'values'=>range(25,30)
);

$opts['fdd']['calc_boxs_date'] = array(
	'name'=>'Boxs',
	'select'=>'T',
	'type'=>'date',
	'maxlen'=>10,
	'nowrap'=>false,
	'sort'=>true,
	'datemask'=>'M-d-y',
	'sql'=>'DATE_ADD(mated,interval boxs_days day)',
	'options'=>'V'
);


if ($flt=='1' OR $flt=='2'){

$opts['fdd']['calc_kindle_date'] = array(
	'name'=>'Exp Kindle',
	'select'=>'T',
	'type'=>'date',
	'maxlen'=>10,
	'nowrap'=>false,
	'sort'=>true,
	'datemask'=>'M-d-y',
	'sql'=>'DATE_ADD(mated,interval 31 day)',
	'options'=>'LVCR'
);
$opts['fdd']['calc_kindle_date']['colattrs|L'] = 'bgcolor="lightyellow" style="color: green;font-weight:bold;text-align:right"';
}

$opts['fdd']['calc_list_sort'] = array(
	'name'=>'list-sort',
	'select'=>'T',
	'maxlen'=>10,
	'nowrap'=>false,
	'sort'=>true,
	'sql|LFV'=>'IF(TO_DAYS(kindle_act)>0,TO_DAYS(kindle_act),IF(mate_status="20",999999,	TO_DAYS(DATE_ADD(mated,interval 31 day)) )    )',
	'options'=>'H'
);


$opts['fdd']['kindle_act'] = array(
	'name'=>'Kindle',
	'select'=>'M',
	'type'=>'date',
	'maxlen'=>10,
	'nowrap'=>false,
	'default'=>'0000-00-00',
	'datemask'=>'M-d-y',
	'sort'=>true,
  'calendar' => array(
  'ifFormat'    => '%Y-%m-%d',
	'singleClick' => true,
	'mondayFirst' => true,
	'weekNumbers' => false,
	'showsTime'   => false,
	'label'       => '...',)    
	
);
$opts['fdd']['kindle_act']['help'] = 'Date this doe kindled year-month-day eg. yyyy-mm-dd'; 
$opts['fdd']['kindle_act']['colattrs|L'] = 'style="color: navy;font-weight:normal;text-align:right"';

if ($flt=='1'){
$opts['fdd']['kindle_prev'] = array(
	'name'=>'Kndl Last',
	'select'=>'T',
	'maxlen'=>10,
	'options'=>'H',
	'nowrap'=>false,
	'datemask'=>'M-d-y',
	'sort'=>true,
  'calendar' => array(
  'ifFormat'    => '%Y-%m-%d',
	'singleClick' => true,
	'mondayFirst' => true,
	'weekNumbers' => false,
	'showsTime'   => false,
	'label'       => '...',)    
);

}else{

if ($prt=='N'){
$opts['fdd']['kindle_prev'] = array(
	'name'=>'Knd Last',
	'select'=>'T',
	'maxlen'=>10,
	'nowrap'=>false,
	'datemask'=>'M-d-y',
	'options'=>'LV',
	'sort'=>true,
  'calendar' => array(
  'ifFormat'    => '%Y-%m-%d',
	'singleClick' => true,
	'mondayFirst' => true,
	'weekNumbers' => false,
	'showsTime'   => false,
	'label'       => '...',)
	    
);
}
}

$opts['fdd']['kindle_interval'] = array(
  'name'     => 'Knd Int',
  'select'   => 'N',
  'maxlen'   => 5,
  'default'  => '0.0',
  'sort'     => true,
	'sql'=>'IF(TO_DAYS(kindle_act)=0,NULL,(TO_DAYS(kindle_act) - TO_DAYS(kindle_prev)))' ,
	'options'=>'LVD',
	'mask' => '%01.0f',
	'colattrs|L'=>'align="center"'
);

//***nest
if ($flg_nest == 'Y'){
$opts['fdd']['nest'] = array(
	'name'=>'Nest',
	'select'=>'T',
	'maxlen'=>1,
	'sort'=>true,
  'values2' => array(
	' '   => ' ',
	'0'   => 'NR ',
	'1'   => 'Good',
	'2'   => 'Avg',
	'3'   => 'Bad'
		),
	'help'=>'Quality of nest NR-not recorded/Good/Average/Bad',	
	'colattrs|L'=>'style="text-align:center"',
);
}
$opts['fdd']['calc_kit_age'] = array(
  'name'     => 'Age',
  'select'   => 'N',
  'maxlen'   => 5,
  'default'  => '0.0',
  'sort'     => true,
	'sql'=>'IF(TO_DAYS(kindle_act)=0,NULL,(TO_DAYS(NOW()) - TO_DAYS(PMEtable0.kindle_act)))' ,
	'options'=>'LVD',
//	'mask' => '%01.0f',
	'colattrs|L'=>'align="center"'
);


$opts['fdd']['cnt_born'] = array(
	'name'=>'Born',
	'select'=>'N',
	'type'=>'int',
	'maxlen'=>2,
	'nowrap'=>false,
	'sql|L'=>'IF(cnt_born=0,NULL,cnt_born)',
	'sort'=>true
);
$opts['fdd']['cnt_born']['colattrs|L'] = 'align="center"';
$opts['fdd']['cnt_born']['help'] = 'Count of kits born'; 

$opts['fdd']['cnt_day1'] = array(
	'name'=>'24hrs',
	'select'=>'N',
	'type'=>'int',
	'maxlen'=>2,
	'nowrap'=>false,
	'sql|L'=>'IF(cnt_day1=0,NULL,cnt_day1)',
	'sort'=>true
);
$opts['fdd']['cnt_day1']['colattrs|L'] = 'align="center"';
$opts['fdd']['cnt_day1']['help'] = 'Count of kits at 24 hours'; 

$opts['fdd']['cnt_week'] = array(
	'name'=>'Week',
	'select'=>'N',
	'type'=>'int',
	'maxlen'=>2,
	'nowrap'=>false,
	'sql|L'=>'IF(cnt_week=0,NULL,cnt_week)',
	'sort'=>true
);
$opts['fdd']['cnt_week']['colattrs|L'] = 'align="center"';
$opts['fdd']['cnt_week']['help'] = 'Count of kits at 1 week'; 

$opts['fdd']['cnt_now'] = array(
	'name'=>'Now',
	'select'=>'N',
	'type'=>'int',
	'maxlen'=>2,
	'nowrap'=>false,
	'sql|L'=>'IF(cnt_now=0,NULL,cnt_now)',
	'sort'=>true
);
$opts['fdd']['cnt_now']['colattrs|L'] = 'align="center"';
$opts['fdd']['cnt_now']['help'] = 'Count of kits currently'; 


$opts['fdd']['rebreed_days'] = array(
	'name'=>'Days to ReBreed',
	'select'=>'D',
	'type'=>'int',
	'maxlen'=>2,
	'nowrap'=>false,
	'default'=>'0',
	'sort'=>true,
	'values'=>range(4,50),
	'options'=>'CV',
);

$opts['fdd']['calc_rebreed_date'] = array(
	'name'=>'ReBreed',
	'select'=>'T',
	'type'=>'date',
	'maxlen'=>10,
	'nowrap'=>false,
	'sort'=>true,
	'datemask'=>'M-d-y',
	'sql'=>'DATE_ADD(mated,interval 31+rebreed_days day)',
	'options'=>'V'
);


if ($flg_wgt21 == 'Y'){ 

$opts['fdd']['doe2'] = array(
	'name'=>'Doe',
	'select'=>'T',
	'type'=>'string',
	'maxlen'=>10,
	'nowrap'=>false,
	'sort'=>true,
	'sql'=>'SUBSTRING(prog_doe,17)',
	'options'=>'CVR'
);
$opts['fdd']['doe2']['tab'] = 'Day21';

$opts['fdd']['cnt_21'] = array(
	'name'=>'21d',
	'select'=>'N',
	'type'=>'int',
	'maxlen'=>2,
	'nowrap'=>false,
	'sort'=>true,
	'options'=>'CVD',
	'default'=>$cnt_week
);
$opts['fdd']['cnt_21']['help'] = 'Count of kits at 21 days'; 


if ($flg_wgt=='M') {

$opts['fdd']['wgt_21_m'] = array(
  'name'     => 'Wgt21m',
  'select'   => 'N',
  'maxlen'   => 6,
  'default'  => '0000',
  'sort'     => true,
	'options'=>'AC',
//	'mask' => '%01.2f'
);

$opts['fdd']['wgt_21'] = array(
  'name'     => 'Wgt21',
  'select'   => 'N',
  'maxlen'   => 6,
  'default'  => '0.00',
  'sort'     => true,
	'options'=>'ACH',
	'mask' => '%01.2f'
);
$opts['cgi']['overwrite']['wgt_21'] = $wgt_21_m/453.59;

$opts['fdd']['calc_wgt21'] = array(
  'name'     => 'Av21',
  'select'   => 'N',
  'maxlen'   => 6,
  'sort'     => true,
	'sql'=>'IF(wgt_21_m>0 AND cnt_21>0, ROUND(wgt_21_m/cnt_21,3),"")',
	'options'=>'LV',
	'colattrs|LV'=>'style="text-align:right"',
);

}elseif ($flg_wgt=='A') {

$opts['fdd']['wgt_21'] = array(
  'name'     => 'Wgt21',
  'maxlen'   => 6,
  'default'  => '0.00',
  'sort'     => true,
	'options'=>'AC',
	'mask' => '%01.2f'
);

$opts['fdd']['wgt_21_m'] = array(
  'name'     => 'Wgt21',
  'select'   => 'N',
  'maxlen'   => 6,
  'default'  => '0.00',
  'sort'     => true,
	'options'=>'ACH',
//	'mask' => '%01.2f'
);
$opts['cgi']['overwrite']['wgt_21_m'] = $wgt_21*453.59;

$opts['fdd']['calc_wgt21'] = array(
  'name'     => 'Av21',
  'select'   => 'N',
	'type'=>'int',
  'maxlen'   => 6,
  'sort'     => true,
	'sql'=>'IF(wgt_21>0 AND cnt_21>0, ROUND(wgt_21/cnt_21,2),"")',
	'options'=>'LV',
	'colattrs|LV'=>'style="text-align:right"',
);

}






/*
$opts['fdd']['cnt_21_adj'] = array(
  'name'     => 'Adj_21',
  'select'   => 'N',
	'type'=>'int',
  'sort'     => true,
//	'sql'=>'cnt_21',
	'options'=>'LV',
	'colattrs|LV'=>'style="text-align:right"',
  'values2' => array(
	'1'   => '.5',
	'2'   => '.6',
	'3'   => .7,
	'4'   => '.8',
	'5'   => 0.9,
	'6'   => '1',
	'7'   => '1.12',
	'8'   => '1.15',
	'9'   => '1.23',
	'10'   => '1.34',
		),
);
*/
/*
$opts['fdd']['adj_21_wgt'] = array(
  'name'     => 'Av21_C',
  'select'   => 'N',
	'type'=>'int',
  'sort'     => true,
	'sql'=>'ROUND(wgt_21_imp/cnt_21 * CASE cnt_21 WHEN 1 THEN 0.5 WHEN 2 THEN 0.75 WHEN 3 THEN 0.85 WHEN 4 THEN 0.9 WHEN 5 THEN 0.95 WHEN 6 THEN 1.0 WHEN 7 THEN 1.12 WHEN 8 THEN 1.15 WHEN 9 THEN 1.20 WHEN 10 THEN 1.35 ELSE 1.0 END,2) ',
	'options'=>'LV',
	'colattrs|LV'=>'style="text-align:right"',
);
*/
}

//*** weaning
$opts['fdd']['doe3'] = array(
	'name'=>'Doe',
	'select'=>'T',
	'type'=>'string',
	'maxlen'=>10,
	'nowrap'=>false,
	'sort'=>true,
	'sql'=>'SUBSTRING(prog_doe,17)',
	'options'=>'CVR'
);
$opts['fdd']['doe3']['tab'] = 'Weaning';


$opts['fdd']['wean_days'] = array(
	'name'=>'Days to Weaning',
	'select'=>'D',
	'type'=>'int',
	'maxlen'=>2,
	'nowrap'=>false,
	'default'=>'0',
	'sort'=>true,
	'values'=>range(20,60),
	'options'=>'CV'
);

$opts['fdd']['calc_weaning_date'] = array(
	'name'=>'Wean',
	'select'=>'T',
	'type'=>'date',
	'maxlen'=>10,
	'nowrap'=>false,
	'sort'=>true,
	'datemask'=>'M-d-y',
	'sql'=>'DATE_ADD(mated,interval 31+wean_days day)',
	'options'=>'V'
);

$opts['fdd']['pen_litter'] = array(
	'name'=>'Pen',
	'select'=>'T',
	'type'=>'string',
	'maxlen'=>5,
	'nowrap'=>false,
	'sort'=>true,
	'colattrs|L'=>'style="text-align:center;background-color:fffacd"',
	'help'=>'Current location of this litter'
);

$opts['fdd']['wean_act'] = array(
	'name'=>'Weaning',
	'select'=>'T',
	'type'=>'date',
	'maxlen'=>10,
	'nowrap'=>false,
	'default'=>'0000-00-00',
	'datemask'=>'M-d-y',
	'sort'=>true,
  'calendar' => array(
  'ifFormat'    => '%Y-%m-%d',
	'singleClick' => true,
	'mondayFirst' => true,
	'weekNumbers' => false,
	'showsTime'   => false,
	'label'       => '...',)    
	
);
$opts['fdd']['wean_act']['help'] = 'Date this does kits were weaned year-month-day eg. yyyy-mm-dd'; 
$opts['fdd']['wean_act']['colattrs'] = 'style="color: navy;font-weight:normal;text-align:right"';


//*** weight weaning
if ($flg_wgt_wean == 'Y'){ 
$opts['fdd']['wgt_mate'] = array(
  'name'     => 'Weight',
  'select'   => 'N',
  'maxlen'   => 6,
  'default'  => '0.00',
  'sort'     => true,
	'options'=>'H',
	'mask' => '%01.1f'
);

$opts['fdd']['wgt_wean'] = array(
  'name'     => 'Does Weight Wean',
  'select'   => 'N',
  'maxlen'   => 6,
  'default'  => '0.00',
  'sort'     => true,
	'options'=>'C'
);
$opts['fdd']['wgt_wean']['help'] = 'Does weight at weaning'; 

$opts['fdd']['calc_wgt_wean'] = array(
  'name'     => 'Doe Wgt',
  'select'   => 'N',
  'maxlen'   => 6,
  'sort'     => true,
	'sql'=>'IF(wgt_mate > 0 AND wgt_wean>0, ROUND(wgt_wean/wgt_mate*100),"")',
	'options'=>'LV',
	'colattrs|L'=>'style="text-align:center"',
);
}

$opts['fdd']['cnt_wean'] = array(
	'name'=>'Wean',
	'select'=>'N',
	'type'=>'int',
	'maxlen'=>2,
	'nowrap'=>false,
	'default'=>'0',
	'sql|L'=>'IF(cnt_wean=0,NULL,cnt_wean)',
	'sort'=>true,

);
$opts['fdd']['cnt_wean']['colattrs|L'] = 'align="center"';
$opts['fdd']['cnt_wean']['help'] = 'Count of kits weaned'; 


$opts['fdd']['doe3a'] = array(
	'name'=>'Doe',
	'select'=>'T',
	'type'=>'string',
	'maxlen'=>10,
	'nowrap'=>false,
	'sort'=>true,
	'sql'=>'SUBSTRING(prog_doe,17)',
	'options'=>'CVR'
);
$opts['fdd']['doe3a']['tab'] = 'Day28';

$opts['fdd']['cnt_28'] = array(
	'name'=>'28d',
	'select'=>'N',
	'type'=>'int',
	'maxlen'=>2,
	'nowrap'=>false,
	'sort'=>true,
	'options'=>'CVD',
	'default'=>$cnt_wean
);
$opts['fdd']['cnt_28']['help'] = 'Count of kits at 28 days'; 

$opts['fdd']['wgt_28'] = array(
  'name'     => 'Wgt28',
  'select'   => 'N',
  'maxlen'   => 6,
  'default'  => '0.00',
  'sort'     => true,
	'options'=>'CVD'
);

$opts['fdd']['calc_wgt28'] = array(
  'name'     => 'Av28',
  'select'   => 'N',
  'maxlen'   => 6,
  'default'  => '0.0',
  'sort'     => true,
	'options'=>'LV',
	'sql'=>'IF(wgt_28>0 AND cnt_28>0, ROUND(wgt_28/cnt_28,2),"")',
	'colattrs|LV'=>'style="text-align:right"',
);


//***weight 50 days
if ($flg_wgt50 == 'Y'){ 

$opts['fdd']['doe4'] = array(
	'name'=>'Doe',
	'select'=>'T',
	'type'=>'string',
	'maxlen'=>10,
	'nowrap'=>false,
	'sort'=>true,
	'sql'=>'SUBSTRING(prog_doe,17)',
	'options'=>'CVR'
);
$opts['fdd']['doe4']['tab'] = 'Day50';


$opts['fdd']['cnt_50'] = array(
	'name'=>'50d',
	'select'=>'T',
	'type'=>'int',
	'maxlen'=>2,
	'nowrap'=>false,
	'sort'=>true,
	'options'=>'CVD',
	'default'=>$cnt_wean
);
$opts['fdd']['cnt_50']['help'] = 'Count of kits at 50 days'; 
$opts['fdd']['cnt_50']['tab'] = '50day';

$opts['fdd']['wgt_50'] = array(
  'name'     => 'Wgt50',
  'select'   => 'T',
  'maxlen'   => 6,
  'default'  => '0.00',
  'sort'     => true,
	'options'=>'C'
);

$opts['fdd']['calc_wgt50'] = array(
  'name'     => 'Av50',
  'select'   => 'T',
  'maxlen'   => 6,
  'default'  => '0.0',
  'sort'     => true,
	'options'=>'LV',
	'sql'=>'IF(wgt_50>0 AND cnt_50>0, ROUND(wgt_50/cnt_50,2),"")',
	'colattrs|V'=>'style="text-align:right"',
);
}

//*** weight 56 days
if ($flg_wgt56 == 'Y'){ 
$opts['fdd']['doe5'] = array(
	'name'=>'Doe',
	'select'=>'T',
	'type'=>'string',
	'maxlen'=>10,
	'nowrap'=>false,
	'sort'=>true,
	'sql'=>'SUBSTRING(prog_doe,17)',
	'options'=>'CVR'
);
$opts['fdd']['doe5']['tab'] = 'Day56';

$opts['fdd']['cnt_56'] = array(
	'name'=>'56d',
	'select'=>'N',
	'type'=>'int',
	'maxlen'=>2,
	'nowrap'=>false,
	'sort'=>true,
	'options'=>'CVD',
	'default'=>$cnt_wean
);
$opts['fdd']['cnt_56']['help'] = 'Count of kits at 56 days'; 

$opts['fdd']['wgt_56'] = array(
  'name'     => 'Wgt56',
  'select'   => 'N',
  'maxlen'   => 6,
  'default'  => '0.00',
  'sort'     => true,
	'options'=>'C'
);

$opts['fdd']['calc_wgt56'] = array(
  'name'     => 'Av56',
  'select'   => 'N',
  'maxlen'   => 6,
  'default'  => '0.0',
  'sort'     => true,
	'options'=>'LV',
	'sql'=>'IF(wgt_56>0 AND cnt_56>0, ROUND(wgt_56/cnt_56,2),"")',
	'colattrs|L'=>'style="text-align:right"',
);
}

//*** weight 70 days
if ($flg_wgt70 == 'Y'){ 
$opts['fdd']['doe6'] = array(
	'name'=>'Doe',
	'select'=>'T',
	'type'=>'string',
	'maxlen'=>10,
	'nowrap'=>false,
	'sort'=>true,
	'sql'=>'SUBSTRING(prog_doe,17)',
	'options'=>'CVR'
);
$opts['fdd']['doe6']['tab'] = 'Day70';

$opts['fdd']['cnt_70'] = array(
	'name'=>'70d',
	'select'=>'N',
	'type'=>'int',
	'maxlen'=>2,
	'nowrap'=>false,
	'sort'=>true,
	'options'=>'CVD',
	'default'=>$cnt_wean
);
$opts['fdd']['cnt_70']['help'] = 'Count of kits at 70 days'; 

$opts['fdd']['wgt_70'] = array(
  'name'     => 'Wgt70',
  'select'   => 'N',
  'maxlen'   => 6,
  'default'  => '0.00',
  'sort'     => true,
	'options'=>'C'
);

$opts['fdd']['calc_wgt70'] = array(
  'name'     => 'Av70',
  'select'   => 'N',
  'maxlen'   => 6,
  'default'  => '0.0',
  'sort'     => true,
	'options'=>'LV',
	'sql'=>'IF(wgt_70>0 AND cnt_70>0, ROUND(wgt_70/cnt_70,2),"")',
	'colattrs|V'=>'style="text-align:right"',
);
}

if ($prt=='N'){

$opts['fdd']['doe7'] = array(
	'name'=>'Doe',
	'select'=>'T',
	'type'=>'string',
	'maxlen'=>10,
	'nowrap'=>false,
	'sort'=>true,
	'sql'=>'SUBSTRING(prog_doe,17)',
	'options'=>'CVR'
);
$opts['fdd']['doe7']['tab'] = 'Process';

$opts['fdd']['process_days'] = array(
	'name'=>'Days to Process',
	'select'=>'D',
	'type'=>'int',
	'maxlen'=>2,
	'nowrap'=>false,
	'default'=>'0',
	'sort'=>true,
	'values'=>range(40,80),
	'options'=>'CV'
);

$opts['fdd']['calc_process_date'] = array(
	'name'=>'Process',
	'select'=>'T',
	'type'=>'date',
	'maxlen'=>10,
	'nowrap'=>false,
	'sort'=>true,
	'datemask'=>'M-d-y',
	'sql'=>'DATE_ADD(mated,interval 31+process_days day)',
	'options'=>'V'
);

$opts['fdd']['process_act'] = array(
	'name'=>'Proc',
	'select'=>'T',
	'type'=>'date',
	'maxlen'=>10,
	'nowrap'=>false,
	'datemask'=>'M-d-y',
	'default'=>'0000-00-00',
	'options'=>'CV',
	'sort'=>true,
  'calendar' => array(
  'ifFormat'    => '%Y-%m-%d',
	'singleClick' => true,
	'mondayFirst' => true,
	'weekNumbers' => false,
	'showsTime'   => false,
	'label'       => '...',)    
	
);
$opts['fdd']['process_act']['help'] = 'Date this does kits were processed year-month-day eg. yyyy-mm-dd'; 

$opts['fdd']['cnt_prc'] = array(
	'name'=>'Prcd',
	'select'=>'N',
	'type'=>'int',
	'maxlen'=>2,
	'nowrap'=>false,
	'options'=>'CV',
	'default'=>'0',
	'sql|L'=>'IF(cnt_prc=0,NULL,cnt_prc)',
	'sort'=>true
);
$opts['fdd']['cnt_prc']['colattrs|L'] = 'align="center"';


$opts['fdd']['wgt_prc'] = array(
  'name'     => 'WgtPrc',
  'select'   => 'N',
  'maxlen'   => 6,
  'default'  => '0.00',
  'sort'     => true,
	'options'=>'C'
);

$opts['fdd']['calc_wgtprc'] = array(
  'name'     => 'AvPrc',
  'select'   => 'N',
  'maxlen'   => 6,
  'default'  => '0.0',
  'sort'     => true,
	'options'=>'V',
	'sql'=>'IF(wgt_prc>0 AND cnt_prc>0, ROUND(wgt_prc/cnt_prc,2),"")',
	'colattrs|V'=>'style="text-align:right"',
);
}


$opts['fdd']['doe_a'] = array(
	'name'=>'Doe',
	'select'=>'T',
	'type'=>'string',
	'maxlen'=>10,
	'nowrap'=>false,
	'sort'=>true,
	'sql'=>'SUBSTRING(prog_doe,17)',
	'options'=>'CVR'
);
$opts['fdd']['doe_a']['tab'] = 'Valid';

if ($flt=='1'){	

$opts['fdd']['valid_calc'] = array(
	'name'=>'Valid',
	'select'=>'D',
	'type'=>'string',
	'maxlen'=>3,
	'nowrap'=>false,
	'required'=>true,
	'sort'=>true,
	'options'=>'ACVDF',
	'help'=>'Yes/No for data being valid for calculations',
	'colattrs|L'=>'align=center',
  'values2' => array(
	'1'   => 'Yes',
	'2'   => 'No')
);



$opts['fdd']['valid_buck'] = array(
	'name'=>'Valid-Buck',
	'select'=>'D',
	'type'=>'string',
	'maxlen'=>3,
	'nowrap'=>false,
	'required'=>true,
	'sort'=>true,
	'options'=>'ACVDF',
	'help'=>'Yes/No for data being valid for buck calculations',
	'colattrs|L'=>'align=center',
  'values2' => array(
	'1'   => 'Yes',
	'2'   => 'No')
);
$opts['fdd']['valid_doe'] = array(
	'name'=>'Valid-Doe',
	'select'=>'D',
	'type'=>'string',
	'maxlen'=>3,
	'nowrap'=>false,
	'required'=>true,
	'sort'=>true,
	'options'=>'ACVDF',
	'help'=>'Yes/No for data being valid for doe calculations',
	'colattrs|L'=>'align=center',
  'values2' => array(
	'1'   => 'Yes',
	'2'   => 'No')
);

}elseif ($flt=='2'){

$opts['fdd']['valid_calc'] = array(
	'name'=>'Valid',
	'select'=>'D',
	'type'=>'string',
	'maxlen'=>3,
	'nowrap'=>false,
	'required'=>true,
	'sort'=>true,
	'options'=>'LACVDF',
	'help'=>'Yes/No for data being valid for calculations',
	'colattrs|L'=>'align=center',
  'values2' => array(
	'1'   => 'Yes',
	'2'   => 'No')
	
);


$opts['fdd']['valid_buck'] = array(
	'name'=>'Valid-Buck',
	'select'=>'D',
	'type'=>'string',
	'maxlen'=>3,
	'nowrap'=>false,
	'required'=>true,
	'sort'=>true,
	'options'=>'LACVDF',
	'help'=>'Yes/No for data being valid for buck calculations',
	'colattrs|L'=>'align=center',
  'values2' => array(
	'1'   => 'Yes',
	'2'   => 'No')

	
);
$opts['fdd']['valid_doe'] = array(
	'name'=>'Valid-Doe',
	'select'=>'D',
	'type'=>'string',
	'maxlen'=>3,
	'nowrap'=>false,
	'required'=>true,
	'sort'=>true,
	'options'=>'LACVDF',
	'help'=>'Yes/No for data being valid for doe calculations',
	'colattrs|L'=>'align=center',
  'values2' => array(
	'1'   => 'Yes',
	'2'   => 'No')

	
);

}	



$opts['fdd']['doe8'] = array(
	'name'=>'Doe',
	'select'=>'T',
	'type'=>'string',
	'maxlen'=>10,
	'nowrap'=>false,
	'sort'=>true,
	'sql'=>'SUBSTRING(prog_doe,17)',
	'options'=>'CVR'
);
$opts['fdd']['doe8']['tab'] = 'Notes';

$opts['fdd']['note'] = array(
	'name'=>'Note',
	'select'=>'T',
	'type'=>'blob',
	'maxlen'=>65535,
	'nowrap'=>false,
	'textarea'=>array(
		'rows'=>5,
		'cols'=>50,
		'wrap'=>'virtual'
	),
	'sort'=>true,
	'options'=>'ACDV',
);

$opts['language'] = $HTTP_SERVER_VARS['HTTP_ACCEPT_LANGUAGE'];

//require_once 'phpMyEdit.class.php';
//$MyForm = new phpMyEdit($opts);

//require_once 'phpMyEdit.class.php';
//new phpMyEdit($opts);

require_once 'extensions/phpMyEdit-calpopup.class.php';
new phpMyEdit_calpopup($opts);


//this does a simple table stats summary 
if ($flt==1){
	if ($prt=='N'){
		include('brd_kdl_sum.php');
	}
}

?>