(
echo "From: Logix <logix@studbook.co.za>
To: sampie.smith@yahoo.com,henriettelabuschagne1@gmail.com,hbotes68@gmail.com
CC: 
BCC: 
MIME-Version: 1.0
Content-Type: multipart/related; boundary=\"PAA12121.1212121212/logix.studbook.co.za\"
Subject: Agtergrond Kudde Reproduksieverslag taak 6016662 het begin prosesseer.

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>Agtergrond Kudde Reproduksieverslag taak 6016662 het begin prosesseer.</p>
<p>Groete<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_IJyhxQ.log 2>> /var/www/logix/Offline/OFFLINEHRP_IJyhxQ.err
mkdir /var/www/logix/Offline/OFFLINEHRP_IJyhxQ
/var/www/logix/ora2xml/createtable.sh "/var/www/logix/Offline/OFFLINEHRP_IJyhxQ.xml" "select (
			select langpref from valerie934.lgx_v_langpref where par_id = v.par_id) 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,
			h.ani_grp as GRP,
			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 ,
			(select distinct(participant_code) from logix.lgx_v_a_keepers where par_id=789463586) PARTICIPANT_CODE,
			(select 789463586 from dual) PAR_ID
			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(('DRB')) 
			inner join logix.lgx_v_brd_grp h on h.ani_id=a.ani_id 
			inner join valerie934.lgx_v_address ad on ad.par_id = 789463586
			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 ='K' 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 789463586) 
			and a.ani_id in (select ani_id from logix.lgx_v_brd_grp where 
			ani_grp=(select ani_group from logix.cnt_t_act_members where parid_kpr=789463586)) 
			ORDER BY PAR_ID, bd_sort
			) v" >> /var/www/logix/Offline/OFFLINEHRP_IJyhxQ.log 2>> /var/www/logix/Offline/OFFLINEHRP_IJyhxQ.err
cp lastquery.sql /var/www/logix/Offline/OFFLINEHRP_IJyhxQ/query.sql
/var/www/logix/ora2xml/makexml.sh "/var/www/logix/Offline/OFFLINEHRP_IJyhxQ.xml" "select (
			select langpref from valerie934.lgx_v_langpref where par_id = v.par_id) 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,
			h.ani_grp as GRP,
			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 ,
			(select distinct(participant_code) from logix.lgx_v_a_keepers where par_id=789463586) PARTICIPANT_CODE,
			(select 789463586 from dual) PAR_ID
			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(('DRB')) 
			inner join logix.lgx_v_brd_grp h on h.ani_id=a.ani_id 
			inner join valerie934.lgx_v_address ad on ad.par_id = 789463586
			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 ='K' 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 789463586) 
			and a.ani_id in (select ani_id from logix.lgx_v_brd_grp where 
			ani_grp=(select ani_group from logix.cnt_t_act_members where parid_kpr=789463586)) 
			ORDER BY PAR_ID, bd_sort
			) v" >> /var/www/logix/Offline/OFFLINEHRP_IJyhxQ.log 2>> /var/www/logix/Offline/OFFLINEHRP_IJyhxQ.err
echo Generating PDF on `date` >> /var/www/logix/Offline/OFFLINEHRP_IJyhxQ.log 2>> /var/www/logix/Offline/OFFLINEHRP_IJyhxQ.err
grep ORA- /var/www/logix/Offline/OFFLINEHRP_IJyhxQ.log > /var/www/logix/Offline/OFFLINEHRP_IJyhxQ/oracle.err
PDFGenC /var/www/logix/Offline/OFFLINEHRP_IJyhxQ.xml /var/www/logix/Reports/Templates/HerdReproduction.rep /var/www/logix/Offline/OFFLINEHRP_IJyhxQ.pdf >> /var/www/logix/Offline/OFFLINEHRP_IJyhxQ.log 2>> /var/www/logix/Offline/OFFLINEHRP_IJyhxQ.err
(
echo "From: Logix <logix@studbook.co.za>
To: sampie.smith@yahoo.com,henriettelabuschagne1@gmail.com,hbotes68@gmail.com
CC: 
BCC: 
MIME-Version: 1.0
Content-Type: multipart/related; boundary=\"PAA12121.1212121212/logix.studbook.co.za\"
Subject: Agtergrond Kudde Reproduksieverslag taak 6016662 het voltooi.Laai die verslag/data af by Historiese Data links bo onder die 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>Agtergrond Kudde Reproduksieverslag taak 6016662 het voltooi.Laai die verslag/data af by Historiese Data links bo onder die login data.!</p>
<p>Groete<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_IJyhxQ.log 2>> /var/www/logix/Offline/OFFLINEHRP_IJyhxQ.err
mv /var/www/logix/Offline/OFFLINEHRP_IJyhxQ.* /var/www/logix/Offline/OFFLINEHRP_IJyhxQ/