(
echo "From: Logix <logix@studbook.co.za>
To: t.pieterse.13@gmail.com,marna@familiagame.co.za,evan@familiagame.co.za
CC: 
BCC: 
MIME-Version: 1.0
Content-Type: multipart/related; boundary=\"PAA12121.1212121212/logix.studbook.co.za\"
Subject: Offline Herd Reproduction Report job 6020221 has started processing.

This is a MIME-encapsulated message

--PAA12121.1212121212/logix.studbook.co.za
Content-Type: text/html
<HTML>
<HEAD><BASE HREF=\"/emailfakepage.php\">
<style>
body
{
  background-color: rgb(255,255,255);
  color: rgb(0,0,0);
  font-family: Tahoma;
  font-size: 10pt;
}
a
{
  color: rgb(0,77,129);
}
a:hover
{
  color: rgb(0,31,52)
}
</style>
</HEAD>
<BODY>
<p>Offline Herd Reproduction Report job 6020221 has started processing.</p>
<p>Regards<br><IMG src=\"/images/LogixSm_new.gif\"></p>
</BODY>
</HTML>
--PAA12121.1212121212/logix.studbook.co.za
Content-Type: image/gif; name=\"LogixSm_new.gif\"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename=\"LogixSm_new.gif\"
Content-Location: /images/LogixSm_new.gif

R0lGODdhWAAfAOfiABUQDxYREBYSERcTEhkVFBoWFRsXFhwYFx0aGR4aGR8bGiAcGyAdHCEdHCAe
IiIeHSMfHiQgHyUhICYiIScjIigkIyklJComJSsnJiwoJy8qKSwrLi8rKjAsKzEtLDIuLTMvLjQw
LzUxMDYyMTczMjg0M+oEDjk1NDs3Nj05OOsJGOsKHz87OkA8OuwOIEM+PUM/PkVBQEdDQUhDQklE
Q0tGRUxHRukdH+ofIOogJ+siKOwjKe0lKu0mMFVTV1hTUlpWVewxN11ZV+0zOO40OWJdXGNeXes7
OGVgX+s8P+09QGhjYu4/QWlkY2plZGtmZW1oZ+tGR25paHFta3JubHNvbe1QUXVxb3ZycHdycfBS
U3hzcvFUVHp1dHt2dXl3e314d+9aW355ePBbXH96efFcXYB7eoF8e4J9fIR/fvFjYIWAf/JlZoiD
goqFhO9qbYuGhYyHhoqIjI2Ih/Jtb/Rta46JiJCKifBycZKMi5COkvR1dJaRj/B5e5SSlpeSkPF6
fJiTkZqVk/N9fvOEh/WFgu+Hh5+doZ6gnfKKiqOgpPWMjPaNjaijoqmko6ympfWTkKmnq62npvSZ
mqiusPWhn7eysbizsrazuLm2u/Snory2tb23trq4vPWpqrm7uLu9uvSurcC+wsO+vMXAv8XCx8bD
yPi5tfa5u8bIxcjKx8zKzs3Lz/fBwPbHxPjIxvnJx9nT0tPV0tXX1NbY1dnX29nb1+Da2dvd2vnX
0PfZ197g3fja2Pva0vrb2uHk4Pzd3OPl4f3e3fnh3ubo5eXq7ejq5/3m4urs6evu6vvt7u/x7vzu
7/Dy7+7z9vfx8PHz8PL08fr18/T38/z29ff59vX6/f749/j69//5+Pn7+P/6+fr8+fv9+v/8+v/9
+/z/+/7//P//////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////ywAAAAAWAAfAAAI/gDDCRxI
sKDBgwgTKlzIsKHDhxAjSpxIsaLFixW7YdzIkSEzEypUdBxJspWOkyRHcrqCpSWWK1mwLWQWqgyP
IXg05Tg55KAtIQEqRJhhahorIAKhVWHp8sonOExbXqESztYUl1OKPWwAAUIEMguz0cGx46TZslEM
agPRYMRAbC0OKJBCUI/XCBkGernbwBRBFBCMREzjdcLCbjxOlt3B+GSSgxYiGKhW8EcEugOfJYgA
4Q7BFl0huCFIwXNEOV4lLBxSVscYaQJdqamU7cYegh+6+jl4AbNAzV5ND5zg1YAtgWmKTJTDWXVC
PCdxKDOYDYeOHdwE0uKaYNfBUU4I/gKPIFwgogURIogIpwoCxTjNFd7Y4QIYQkM8BZ7gbAAZQm3i
bUaeQTNw1gAlDcxCEWoQGIaQJtfhkdA1ZmUTTgacBeCQZumVNxAFXTUgSEXMNZgQGzrg4IpCY5xk
4QVdadgQh50dFIkCnNVAYnwItXiDLwoRctIx4cAYgYwM0ejhQD6kt8AjC3Lm4EE+ApmQkDpQU2SG
BPFBwgglkFCCBkv8lkBXSwrkgQdeKWDNRPBB4FxBpSzzRlmeKJSYDhZ20FUByRRUBGcFNJPZmQMa
9MIqiijQFRLLpXaQBtO4Yt1jCFFTYTipNBDBArcUFIhXIQTI2ZJbtCEQDV4dAIpE/qhFMOVAjSgg
0BAnLYIQrjoUMhCGEORR0B/pkRBgcAVhYsFAvxDA2QYSuSEpQaNAgBkqN6TYR0HKWFEWDgRF48CR
zhAkCGclEATNZjUOBM0CtRD0RYhVQGRLCF1FIEgssojyBI5QCjRIDt8q4wojXMyXIpEEGUPCAigQ
M1ANEBzwgrnpQYCCoeF08qklBB2CHgQJSOLQJViQYcbKYmSRRRdmkCFGMAQtkm0SwLhg1nW6ICQJ
EBiEEIMGNqDBirtQgKFyzFVkcgbMZnTxhEBNdEHG0l1skpJAvnAxSSKt7QDI1mRPVEdZmJattkOn
HHFSD7etLbdCrjDxNiRz543QEzC55NKL3oAHLvjghBdu+OEVBQQAOw==
"
) | sendmail -t
echo Starting on `date` >> /var/www/logix/Offline/OFFLINEHRP_EyxP8i.log 2>> /var/www/logix/Offline/OFFLINEHRP_EyxP8i.err
mkdir /var/www/logix/Offline/OFFLINEHRP_EyxP8i
/var/www/logix/ora2xml/createtable.sh "/var/www/logix/Offline/OFFLINEHRP_EyxP8i.xml" "select 'A' printlang,(select faf from logix.lgx_v_a_faf where ani_id=V.ani_id) FIRST_ACCEPTANCE, v.*
		from 
		(select a.sex,a.ani_id, a.animal_number as computer_number,to_char(a.birth_dtm,'DD/MM/YYYY') as birth_dtm,
		a.birth_dtm as bd_sort,
		n.nid as NID,h.breed as breed_code,
		ad.address ,
		Floor((sysdate - a.birth_dtm)/365.2425*12) age,
		i.afb_mm as AFC,k.prog_cnt as CALVINGS, 
		j.alb_mm/12 as ALC,l.ibp_f2b as FST_ICP,
		m.ibp_l2b as LST_ICP,d.ibp_avg as AV_ICP,
		e.dlb as DLC
		,f.ex_emb as EMBRYO_CALVES,null as BREED_AV_ICP,
		g.afb as BREED_AFC,
		g.IBP_F2B as BREED_FST_ICP,
		g.IBP_L2B as BREED_LST_ICP,
		1051477891 as PAR_ID ,
		'F000157000' as PARTICIPANT_CODE
		from irisdata30.animal a
		inner join logix.lgx_v_nid n on a.ani_id = n.ani_id
		inner join logix.lgx_vc_ibp_afb_mm i on i.ani_id= a.ani_id
		inner join logix.lgx_vc_ibp_alb_mm j on j.ani_id= a.ani_id
		inner join logix.LGX_VC_IBP_PROG_CNT k on k.ani_id= a.ani_id
		inner join logix.LGX_VC_IBP_F2B l on l.ani_id= a.ani_id
		inner join logix.LGX_VC_IBP_L2B m on m.ani_id= a.ani_id
		inner join logix.LGX_VC_IBP_AVG d on d.ani_id= a.ani_id
		inner join logix.LGX_VC_IBP_DLB e on e.ani_id= a.ani_id
		inner join logix.LGX_VC_IBP_DAM_INF f on f.ani_id= a.ani_id
		inner join logix.cnt_v_brd_avg g on g.brd in(select breed from logix.lgx_v_a_breed where ani_id=a.ani_id )
		 inner join logix.lgx_v_a_breed h on h.ani_id=a.ani_id
		inner join valerie934.lgx_v_address ad on ad.par_id = 1051478207
		where
		a.ani_id in (select ani.ani_id from animal ani , period kpr
		WHERE kpr.PERIOD_END_DTM IS NULL
		AND kpr.relation_type ='O'
		and kpr.ani_id = ani.ani_id and ani.death_dtm is null
		and (SELECT CHARACTERISTIC_CODE FROM irisdata30.animal_characteristic stat
		WHERE characteristic_end_dtm IS NULL
		AND characteristic_type = 'G01' and stat.ani_id = ANI.ani_id) not in ('CAN','CCN') and sex = 'F' AND KPR.PAR_ID in 1051477891)
		 and h.breed='CWB'
		ORDER BY PAR_ID, bd_sort) v
		" >> /var/www/logix/Offline/OFFLINEHRP_EyxP8i.log 2>> /var/www/logix/Offline/OFFLINEHRP_EyxP8i.err
cp lastquery.sql /var/www/logix/Offline/OFFLINEHRP_EyxP8i/query.sql
/var/www/logix/ora2xml/makexml.sh "/var/www/logix/Offline/OFFLINEHRP_EyxP8i.xml" "select 'A' printlang,(select faf from logix.lgx_v_a_faf where ani_id=V.ani_id) FIRST_ACCEPTANCE, v.*
		from 
		(select a.sex,a.ani_id, a.animal_number as computer_number,to_char(a.birth_dtm,'DD/MM/YYYY') as birth_dtm,
		a.birth_dtm as bd_sort,
		n.nid as NID,h.breed as breed_code,
		ad.address ,
		Floor((sysdate - a.birth_dtm)/365.2425*12) age,
		i.afb_mm as AFC,k.prog_cnt as CALVINGS, 
		j.alb_mm/12 as ALC,l.ibp_f2b as FST_ICP,
		m.ibp_l2b as LST_ICP,d.ibp_avg as AV_ICP,
		e.dlb as DLC
		,f.ex_emb as EMBRYO_CALVES,null as BREED_AV_ICP,
		g.afb as BREED_AFC,
		g.IBP_F2B as BREED_FST_ICP,
		g.IBP_L2B as BREED_LST_ICP,
		1051477891 as PAR_ID ,
		'F000157000' as PARTICIPANT_CODE
		from irisdata30.animal a
		inner join logix.lgx_v_nid n on a.ani_id = n.ani_id
		inner join logix.lgx_vc_ibp_afb_mm i on i.ani_id= a.ani_id
		inner join logix.lgx_vc_ibp_alb_mm j on j.ani_id= a.ani_id
		inner join logix.LGX_VC_IBP_PROG_CNT k on k.ani_id= a.ani_id
		inner join logix.LGX_VC_IBP_F2B l on l.ani_id= a.ani_id
		inner join logix.LGX_VC_IBP_L2B m on m.ani_id= a.ani_id
		inner join logix.LGX_VC_IBP_AVG d on d.ani_id= a.ani_id
		inner join logix.LGX_VC_IBP_DLB e on e.ani_id= a.ani_id
		inner join logix.LGX_VC_IBP_DAM_INF f on f.ani_id= a.ani_id
		inner join logix.cnt_v_brd_avg g on g.brd in(select breed from logix.lgx_v_a_breed where ani_id=a.ani_id )
		 inner join logix.lgx_v_a_breed h on h.ani_id=a.ani_id
		inner join valerie934.lgx_v_address ad on ad.par_id = 1051478207
		where
		a.ani_id in (select ani.ani_id from animal ani , period kpr
		WHERE kpr.PERIOD_END_DTM IS NULL
		AND kpr.relation_type ='O'
		and kpr.ani_id = ani.ani_id and ani.death_dtm is null
		and (SELECT CHARACTERISTIC_CODE FROM irisdata30.animal_characteristic stat
		WHERE characteristic_end_dtm IS NULL
		AND characteristic_type = 'G01' and stat.ani_id = ANI.ani_id) not in ('CAN','CCN') and sex = 'F' AND KPR.PAR_ID in 1051477891)
		 and h.breed='CWB'
		ORDER BY PAR_ID, bd_sort) v
		" >> /var/www/logix/Offline/OFFLINEHRP_EyxP8i.log 2>> /var/www/logix/Offline/OFFLINEHRP_EyxP8i.err
echo Generating PDF on `date` >> /var/www/logix/Offline/OFFLINEHRP_EyxP8i.log 2>> /var/www/logix/Offline/OFFLINEHRP_EyxP8i.err
grep ORA- /var/www/logix/Offline/OFFLINEHRP_EyxP8i.log > /var/www/logix/Offline/OFFLINEHRP_EyxP8i/oracle.err
PDFGenC /var/www/logix/Offline/OFFLINEHRP_EyxP8i.xml /var/www/logix/Reports/Templates/HerdReproduction.rep /var/www/logix/Offline/OFFLINEHRP_EyxP8i.pdf >> /var/www/logix/Offline/OFFLINEHRP_EyxP8i.log 2>> /var/www/logix/Offline/OFFLINEHRP_EyxP8i.err
(
echo "From: Logix <logix@studbook.co.za>
To: t.pieterse.13@gmail.com,marna@familiagame.co.za,evan@familiagame.co.za
CC: 
BCC: 
MIME-Version: 1.0
Content-Type: multipart/related; boundary=\"PAA12121.1212121212/logix.studbook.co.za\"
Subject: Offline Herd Reproduction Report job 6020221 has finished processing.Downlaod the report or data at Historic data left above beneath the login data.!

This is a MIME-encapsulated message

--PAA12121.1212121212/logix.studbook.co.za
Content-Type: text/html
<HTML>
<HEAD><BASE HREF=\"/emailfakepage.php\">
<style>
body
{
  background-color: rgb(255,255,255);
  color: rgb(0,0,0);
  font-family: Tahoma;
  font-size: 10pt;
}
a
{
  color: rgb(0,77,129);
}
a:hover
{
  color: rgb(0,31,52)
}
</style>
</HEAD>
<BODY>
<p>Offline Herd Reproduction Report job 6020221 has finished processing.Downlaod the report or data at Historic data left above beneath the login data.!</p>
<p>Regards<br><IMG src=\"/images/LogixSm_new.gif\"></p>
</BODY>
</HTML>
--PAA12121.1212121212/logix.studbook.co.za
Content-Type: image/gif; name=\"LogixSm_new.gif\"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename=\"LogixSm_new.gif\"
Content-Location: /images/LogixSm_new.gif

R0lGODdhWAAfAOfiABUQDxYREBYSERcTEhkVFBoWFRsXFhwYFx0aGR4aGR8bGiAcGyAdHCEdHCAe
IiIeHSMfHiQgHyUhICYiIScjIigkIyklJComJSsnJiwoJy8qKSwrLi8rKjAsKzEtLDIuLTMvLjQw
LzUxMDYyMTczMjg0M+oEDjk1NDs3Nj05OOsJGOsKHz87OkA8OuwOIEM+PUM/PkVBQEdDQUhDQklE
Q0tGRUxHRukdH+ofIOogJ+siKOwjKe0lKu0mMFVTV1hTUlpWVewxN11ZV+0zOO40OWJdXGNeXes7
OGVgX+s8P+09QGhjYu4/QWlkY2plZGtmZW1oZ+tGR25paHFta3JubHNvbe1QUXVxb3ZycHdycfBS
U3hzcvFUVHp1dHt2dXl3e314d+9aW355ePBbXH96efFcXYB7eoF8e4J9fIR/fvFjYIWAf/JlZoiD
goqFhO9qbYuGhYyHhoqIjI2Ih/Jtb/Rta46JiJCKifBycZKMi5COkvR1dJaRj/B5e5SSlpeSkPF6
fJiTkZqVk/N9fvOEh/WFgu+Hh5+doZ6gnfKKiqOgpPWMjPaNjaijoqmko6ympfWTkKmnq62npvSZ
mqiusPWhn7eysbizsrazuLm2u/Snory2tb23trq4vPWpqrm7uLu9uvSurcC+wsO+vMXAv8XCx8bD
yPi5tfa5u8bIxcjKx8zKzs3Lz/fBwPbHxPjIxvnJx9nT0tPV0tXX1NbY1dnX29nb1+Da2dvd2vnX
0PfZ197g3fja2Pva0vrb2uHk4Pzd3OPl4f3e3fnh3ubo5eXq7ejq5/3m4urs6evu6vvt7u/x7vzu
7/Dy7+7z9vfx8PHz8PL08fr18/T38/z29ff59vX6/f749/j69//5+Pn7+P/6+fr8+fv9+v/8+v/9
+/z/+/7//P//////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////ywAAAAAWAAfAAAI/gDDCRxI
sKDBgwgTKlzIsKHDhxAjSpxIsaLFixW7YdzIkSEzEypUdBxJspWOkyRHcrqCpSWWK1mwLWQWqgyP
IXg05Tg55KAtIQEqRJhhahorIAKhVWHp8sonOExbXqESztYUl1OKPWwAAUIEMguz0cGx46TZslEM
agPRYMRAbC0OKJBCUI/XCBkGernbwBRBFBCMREzjdcLCbjxOlt3B+GSSgxYiGKhW8EcEugOfJYgA
4Q7BFl0huCFIwXNEOV4lLBxSVscYaQJdqamU7cYegh+6+jl4AbNAzV5ND5zg1YAtgWmKTJTDWXVC
PCdxKDOYDYeOHdwE0uKaYNfBUU4I/gKPIFwgogURIogIpwoCxTjNFd7Y4QIYQkM8BZ7gbAAZQm3i
bUaeQTNw1gAlDcxCEWoQGIaQJtfhkdA1ZmUTTgacBeCQZumVNxAFXTUgSEXMNZgQGzrg4IpCY5xk
4QVdadgQh50dFIkCnNVAYnwItXiDLwoRctIx4cAYgYwM0ejhQD6kt8AjC3Lm4EE+ApmQkDpQU2SG
BPFBwgglkFCCBkv8lkBXSwrkgQdeKWDNRPBB4FxBpSzzRlmeKJSYDhZ20FUByRRUBGcFNJPZmQMa
9MIqiijQFRLLpXaQBtO4Yt1jCFFTYTipNBDBArcUFIhXIQTI2ZJbtCEQDV4dAIpE/qhFMOVAjSgg
0BAnLYIQrjoUMhCGEORR0B/pkRBgcAVhYsFAvxDA2QYSuSEpQaNAgBkqN6TYR0HKWFEWDgRF48CR
zhAkCGclEATNZjUOBM0CtRD0RYhVQGRLCF1FIEgssojyBI5QCjRIDt8q4wojXMyXIpEEGUPCAigQ
M1ANEBzwgrnpQYCCoeF08qklBB2CHgQJSOLQJViQYcbKYmSRRRdmkCFGMAQtkm0SwLhg1nW6ICQJ
EBiEEIMGNqDBirtQgKFyzFVkcgbMZnTxhEBNdEHG0l1skpJAvnAxSSKt7QDI1mRPVEdZmJattkOn
HHFSD7etLbdCrjDxNiRz543QEzC55NKL3oAHLvjghBdu+OEVBQQAOw==
"
) | sendmail -t
echo Finished on `date` >> /var/www/logix/Offline/OFFLINEHRP_EyxP8i.log 2>> /var/www/logix/Offline/OFFLINEHRP_EyxP8i.err
mv /var/www/logix/Offline/OFFLINEHRP_EyxP8i.* /var/www/logix/Offline/OFFLINEHRP_EyxP8i/