heitml Source Display
File: /usr/local/httpd/htdocs/mpdata/mps.hei
<include ses.hei>
<include sesform.hei>
<include formfields.hei>
<include extfields.hei>
<include mylib.hei>
<include buttons.hei>
<include loyalty.hei>
<include cointeract.hei>
<include corandom.hei>
<session mode="createcookie">
<html>
<head>
<title>Parliament of Uganda</title>
<script type="text/javascript">
</script>
<link rel="stylesheet" type="text/css" href="http://www.parliament.go.ug/mpdata/mpcss.css"/>
</head>
<body bgcolor="#ffffff">
<let SrvMax=8000>
<if !isdecl(se.p);
se.p = emptytuple;
/if;
if isdecl(ff.upload_btn);
if isdecl(se.p.temp.newphoto);
se.p.addsuccess = update_me(ff);
else;
se.p.addsuccess = upload_me(ff);
/if;
/if;
SrvMax = 1000;
if !isdecl(se.p.current_id);
se.p.current_id = getcurrent();
/if;
// if isdecl(se.p.current_id);
// se.p.current_id = getcurrent();
// /if;
if !isdecl(se.p.sKey);
se.p.sKey = "";
/if;
if !isdecl(se.p.by);
se.p.by = "tblmpname.surname";
/if;
if default(ff.c, "") == "t"; // clear search if necessary
se.p.sKey = "";
// let pff.sKey = "";
se.p.by = "tblmpname.surname";
se.p.current_id = default(se.p.current_id, getcurrent());
/if;
if default(ff.delete, "") == "t"; // delete rec
dbupdate>
DELETE FROM tblmp WHERE mpid=<? ff.id>
</dbupdate;
dbupdate>
DELETE FROM tblmpname WHERE mpno=<? ff.m_id>
</dbupdate;
/if;
if default(ff.p) == "t";
if isdecl(pff.par);
? pff.pal;
/if;
/if;
if !isdecl(ff.n) || !isdecl(se.p.arr);
se.p.arr=array(0); // hit database
se.p.count = 0;
se.p.parl = 0;
dbquery q>
SELECT tblmp.mpid as add_id, tblmpname.mpno as m_id, INITCAP(tblmpname.surname) as sname, INITCAP(tblmpname.othernames) as onames, INITCAP(tblconstituency.constituencyname) as const, tblconstituency.districtno as dist_id, INITCAP(tbldistrict.districtname) as distname,tblparty.partyname,tblparty.description
From ((( tblmpname INNER JOIN TBLmp ON
TBLMPNAME.mpNO = TBLmp.mpNO)
INNER JOIN TBLCONSTITUENCY ON TBLCONSTITUENCY.CONSTITUENCYNO = TBLmp.CONSTITUENCYNO)
INNER JOIN TBLDISTRICT ON TBLCONSTITUENCY.DISTRICTNO = TBLDISTRICT.DISTRICTNO)
INNER JOIN TBLPARTY ON TBLMP.PARTYNO = TBLPARTY.PARTYNO
/*
SELECT tblmp.mpid as add_id, tblmpname.mpno as m_id, INITCAP(tblmpname.surname) as sname, INITCAP(tblmpname.othernames) as onames, INITCAP(tblconstituency.constituencyname) as const, tblconstituency.districtno as dist_id, INITCAP(tbldistrict.districtname) as distname,tblparty.partyname,tblparty.description
From ((( TBLMPNAME INNER JOIN TBLCONSTITUENCY ON
TBLMPNAME.CONSTITUENCYNO = TBLCONSTITUENCY.CONSTITUENCYNO)
INNER JOIN TBLDISTRICT ON TBLCONSTITUENCY.DISTRICTNO = TBLDISTRICT.DISTRICTNO)
INNER JOIN TBLMP ON TBLMPNAME.MPNO = TBLMP.MPNO) INNER JOIN TBLPARTY ON TBLMP.PARTYNO =
TBLPARTY.PARTYNO*/
<if se.p.current_id != 0;
if !isempty(pff.pal);
? " WHERE TBLMP.PARLIAMENTNO = " + pff.pal +" and TBLMP.MPSTATUSNO = 1" ;
se.p.parl = pff.pal;
else;
? " WHERE TBLMP.PARLIAMENTNO=" +se.p.current_id +" and TBLMP.MPSTATUSNO=1" ;
/if;
/if;
if se.p.by == "tblmpname.surname";
? " AND (lower(" + se.p.by + ") like '%" + tolower(se.p.sKey) + "%' OR lower(tblmpname.othernames) like '%" + tolower(se.p.sKey) + "%')";
else;
? " AND lower( " + se.p.by + ") like '%" + tolower(se.p.sKey) + "%'";
/if;
? " ORDER BY tblmpname.surname ASC";
dbrow;
arappend(se.p.arr, copy(q));
se.p.count = se.p.count + 1;
/dbquery;
se.p.i = 0;
/if>
<center>
<font size="+1" color="green"><? default(se.p.addsuccess, "")></font><br>
<let se.p.addsuccess = "">
<if default(ff.details, "") == "t"; // details ...
dbquery q>
SELECT T.titlename,S.sex, M.surname,to_char(M.dob,'dd/mm/yyyy') dob,M.Contact_postal,M.Contact_email,M.Contact_mobile,M.Contact_landline,R.religionname,MS.maritalstatusname,P.partyname,P.description,
M.othernames, M.mpno, initcap(M.profession) profession
FROM tblmpname M,tblparty P,tblmp MP,tbltitle T,tblsex S,tblmaritalstatus MS,tblreligion R
WHERE M.titleid=T.titleid(+) and M.sexid=S.sexno and M.maritalstatusid=MS.maritalstatusno(+) and M.religionid=R.religionid(+) and MP.partyno=P.partyno and MP.PARLIAMENTNO = <? se.p.current_id > and MP.mpno=M.mpno and M.mpno=<? ff.j>
<dbrow>
<font size="+2"><? q.titlename> <? q.surname> <? q.othernames "D"></font><br>
<if ((ff.distname)=="Worker") || ((ff.distname)=="Updf") || ((ff.distname)=="Pwd")|| ((ff.distname)=="Youth") ||((ff.distname)=="Ex-Officio") >
<? toupper(default(ff.distname,""))+ " Representative">
<else>
<if isdecl(ff.const)> (<? default(ff.const,"")> -
<dbquery r>
SELECT INITCAP(districtname) as distname FROM tbldistrict WHERE districtno=<? ff.dist_id;
dbrow;
? r.distname + " District";
// toupper(r.districtname + " district");
/dbquery>)
</if>
</if>
<table width="100%" cellspacing="5" cellpadding="15">
<tr>
<assign url>details.hei?i=<? q.mpno></assign>
<td colspan=2 align="center"> <img src=pics/9parl/<? toupper(q.surname)><? integer(q. mpno)>.jpg></td>
/* <td colspan=2 align="center"><IMG SRC="http://localhost:8080/pass.asp?mpid=<? ff.j>"> </td> */
// <td colspan=2 align="center"> <img src="http://jwabwire.parliament.go.ug:7778/pls/mp/display_image?mp_id=<? ff.j>"> </td>
</tr>
<if !((ff.distname)=="Updf")>
<if !((ff.distname)=="Ex-Officio") >
<tr>
<td align="right"><b>Political Party:</b></td>
<td><? q.partyname> (<? q.description>) </td>
</tr>
</if>
<else>
<tr>
<td>
</td>
</tr>
</if>
<tr>
<td align="right"><b>Gender:</b></td>
<td> <? q.sex> </td>
</tr>
<tr>
<td align="right"><b>Marital Status:</b></td>
<td><? q.maritalstatusname> </td>
</tr>
<tr>
<td align="right"><b>Email address:</b></td>
<td><? q.contact_email> </td>
</tr>
<tr>
<td align="right"><b>Postal Address:</b></td>
<td><? q.contact_postal> </td>
</tr>
<tr>
<td align="right"><b>Mobile Telephone:</b></td>
<td><? q.contact_mobile> </td>
</tr>
<tr>
<td align="right"><b>Landline:</b></td>
<td><? q.contact_landline> </td>
</tr>
<tr>
<td align="right"><b>Profession:</b></td>
<td><? q.profession> </td>
</tr>
<tr>
<td align="right"><b>Religion:</b></td>
<td><? q.religionname> </td>
</tr>
<tr>
<td align="right"><b>Date of birth:</b></td>
<td><? q.dob> </td>
</tr>
<tr>
// <td align="right"><b>Business address:</b></td>
// <td><? q.businessadd> </td>
</tr>
<tr>
<td align="right"><b>Education:</b></td>
</tr>
// <let num=0>
<let countrow = 0>
<dbquery q1>
select E.qualification,E.studyyear,E.awardinstitution from tbleducation E where qualification <> '-' and ongoing = 0 and E.mpid = <? ff.j> order by E.studyyear desc, E.educlevelid
<dbrow>
<let countrow = countrow + 1 >
<tr>
<td align="right"><? countrow >. </td> <td align="left"> <? q1.qualification> , <? q1.awardinstitution> -- <? q1.studyyear> </td>
</tr>
</dbquery>
<tr>
<td align="right"><b>Work History:</b></td>
</tr>
<let countrow1 = 0>
<dbquery q2>
select W.jobtitle,W.fromdate,W.todate from tblwork W where w.jobtitle <> '-' and W.mpid = <? ff.j> order by w.todate desc,W.fromdate desc
<dbrow>
<let countrow1 = countrow1 + 1 >
<tr>
<td align="right"><? countrow1 >. </td> <td align="left"> <? q2.jobtitle> -- <? q2.fromdate> - <? q2.todate> </td>
</tr>
</dbquery;
/*
<tr>
<td align="right"><b>Work:</b></td>
</tr>
<dbquery q2>
select * from tblwork W where W.mpid = <? ff.j>
<dbrow>
<tr>
<td></td> <td align="left"> <? q2.jobtitle> -- <? q2.fromdate> - <? q2.todate> </td>
</tr>
/dbquery;
*/
dbquery q3>
SELECT M.contact_email,S.SEX,MS.Maritalstatusname,M.mpno
FROM tblmpname M, tblsex S,tblmaritalstatus MS,tblmp MP
WHERE MP.mpno=M.mpno and M.sexid=S.sexno and MP.PARLIAMENTNO = <? se.p.current_id > and M.maritalstatusid=MS.maritalstatusno(+) and M.mpno=<? ff.j;
dbrow>
/* <tr>
<td align="right" valign="top"><b> <nobr> Conferences Attended:</nobr></b></td>
// <td> <? splitstring(q.conference,";")> </td>
<if !isnull(q.conference)>
<td>
<let num=0>
<for i=0 i≤len(q.conference) i=i+1;
let num = num + 1;
let x = indexCase(q.conference,";",i);
if !isnull(x);
? num +"."+ substring (q.conference,i,x);
let i=x;
else
? num +"."+ right(q.conference,(len(q.conference)-i));
let i = len(q.conference);
/if;
forsep> <br><
// forsep>,<
/for>
</td>
</if>
</tr> */
<tr>
<td align="right"><b>Special interests:</b></td>
// <td><? q3.interest> </td>
</tr>
<tr>
<td align="right" valign="top">
<b> Other Responsibilities:</b>
</td>
<td colspan ="5">
<dbquery p>
SELECT M.contact_email, MS.Maritalstatusname,M.mpno,
MSP.membershipname,C.committeename,CT.committeetypename
FROM tblmpname M, tblsex S,tblmaritalstatus MS,tblmp MP,tblmpcommittee MC,tblcommittee C, tblcommitteetype CT,tblmpmembership MSP
WHERE MP.mpno=M.mpno and C.committeeno=MC.committeeno and CT.committeetypeno=C.committeetypeno and MC.mpid=MP.mpid and MC.membershipno=MSP.membershipno
and MC.comstatus = 1 and M.sexid=S.sexno and M.maritalstatusid=MS.maritalstatusno(+) and Mp.mpno=<? ff.j;
? " order by MC.membershipno ASC";
dbrow>
<? p.membershipname> : <? p.committeename> <br>
</dbquery>
</td>
</tr>
// view cons profile
/*<tr>
<td align="center" colspan="2">
<dbquery w>
SELECT M.mpno as m_id, M.surname as sname, M.othernames as onames, C.constituencyno, C.constituencyname as const, C.districtno as dist_id,D.districtname as distname
from tblconstituency C,tblmpname M, tbldistrict D,tblmp MP
where C.DISTRICTNO = D.DISTRICTNO and MP.PARLIAMENTNO = <? se.p.current_id > and M.MPNO = MP.MPNO and C.CONSTITUENCYNO = MP.CONSTITUENCYNO and M.mpno=<? ff.j>
<dbrow>
<assign strURL>co.hei?p=<? default(ff.p, "f")>&n=t&details=t&j=<? integer(w.constituencyno)>&const=<? w.const "U">&dist_id=<? integer(w.dist_id); /assign>
<a href=<? strURL>> View Constituency Profile </td>
<dbempty>
</dbquery>
</td>
</tr>*/
<if default(se.p.admin) ==true || default(se.p.admin) =="kob" >
<tr>
<td align="center" colspan=2>
<assign uri>editmember.hei?id=<? integer(q.mpno); /assign>
<a href=<? uri>>Edit</a>
</td>
</tr>
</if>
</table>
</dbquery;
// /dbquery;
/dbquery;
elsif len(se.p.arr) == 0; // heading ...
if se.p.sKey == "">
<font size="+2">No record for current parliament!!!</font>
<else>
<font size="+2">No search results for '<? se.p.sKey>'</font>
</if;
else;
if se.p.sKey == "">
<font size="+2">List of Members of Parliament</font>
<if se.p.current_id != 0;
? "<br>" html; ? "("; ? print_parliament(se.p.current_id); ? ")";
// ? "<br>" html; ? "("; ? print_parliament(2); ? ")";
/if;
else>
<font size="+2">Search results for '<? se.p.sKey>'</font>
</if>
</center>
<let se.p.max = 20; // display
c = "t";
if default(ff.first, "") == "t"; se.p.i = 0; /if;
if default(ff.prev, "") == "t"; se.p.i = Integer(ff.i) - se.p.max; /if;
if default(ff.next, "") == "t"; se.p.i = Integer(ff.i) + se.p.max; /if;
if default(ff.last, "") == "t"; se.p.i = ((se.p.count + se.p.max - 1)/se.p.max)*se.p.max - se.p.max; /if;
if default(ff.number, "") != ""; se.p.i = Integer(ff.number) * se.p.max - se.p.max; /if>
<table align="center" cellspacing="5">
<tr>
<if default(se.p.admin) == true>
<td align = "left"><b>Member's names</b></td> <td align = "center"><b>Political Party</b></td> <td align = "left"><b>Constituency</b> <td align = "left"><b>District</b></td>
<else>
<td align = "left"><b>Member's names</b></td> <td align = "center"><b>Political Party</b></td> <td align = "left"><b>Constituency</b> <td align = "left"><b>District</b></td>
</if>
<td> </td><td> </td><td> </td>
<td> </td>
</tr>
<tr>
// <td colspan=2><b>Member's Photo</b> </td> <td><b>Member's names</b></td> <td><b>Political Party</b></td> <td></td> <td><b>Constituency</b></td>
</tr>
<if default(se.p.scroller, "t") == "t";
for j = integer(default(se.p.i, 0))
((j < (integer(default(se.p.i, 0)) + se.p.max)) && (default(se.p.arr[j].sname, "") != ""))
j = j + 1;
if c == "t";
bg = "#FCFBE2";
c = "f";
else;
bg = "#BDBB71";
c = "t";
/if>
<tr bgcolor=<? bg "Q">>
// <tr>
// <td colspan="2" align="center" > <img src="http://jwabwire.parliament.go.ug:7778/pls/mp/display_image?mp_id=<? se.p.arr[j].m_id>" width="50" height="68"> </td>
<td align = "left">
<assign strURL>mps.hei?p=<? default(ff.p, "f")>&n=t&details=t&j=<? integer(se.p.arr[j].m_id)>&const=<? se.p.arr[j].const "U">&dist_id=<? integer(se.p.arr[j].dist_id)>&distname=<? se.p.arr[j].distname; /assign>
<a href=<? strURL>> <? se.p.arr[j].sname> <? se.p.arr[j].onames> </a>
// <? se.p.arr[j].sname> <? se.p.arr[j].onames>
</td>
<if !((se.p.arr[j].distname)=="Updf")>
<if !((se.p.arr[j].distname)=="Ex-Officio") >
<td align = "left">
<? toupper(se.p.arr[j].partyname)> // (<? toupper(se.p.arr[j].description)> )
</td>
<else>
<td align = "left">
</td>
</if>
<else>
<td align = "left">
</td>
</if>
/*
<if default(se.p.admin) == true || default(se.p.admin)=="kob">
<td>
<assign uri>editmp.hei?mpid=<? integer(se.p.arr[j].m_id)></assign>
<a href=<? uri>>Edit MP</a>
// nn <iamsglink href="editmp.hei" action="modify" receiver="editmp" mpid = (se.p.arr[j].m_id)>Edit MP</iamsglink>
</td>
</if>
*/
/*<td align = "left">
// <assign strURL>mps.hei?p=<? default(ff.p, "f")>&n=t&detailss=t&j=<? se.p.arr[j].m_id>&const=<? se.p.arr[j].const "U">&dist_id=<? se.p.arr[j].dist_id; /assign>
// <a href=<? strURL>> <? se.p.arr[j].const></a>
<? se.p.arr[j].const>
</td>*/
<if ((se.p.arr[j].distname)=="Worker") || ((se.p.arr[j].distname)=="Updf") || ((se.p.arr[j].distname)=="Pwd")|| ((se.p.arr[j].distname)=="Youth") || ((se.p.arr[j].distname)=="Ex-Officio")>
<td align = "left">
<? toupper(se.p.arr[j].distname)>
</td>
<td align = "center">
</td>
<else>
<td align = "left">
<? se.p.arr[j].const>
</td>
<td align = "left">
// <? se.p.arr[j].const> (<? se.p.arr[j].distname> District )
<? se.p.arr[j].distname> District
</td>
</if>
// deleting mp
/*
<if default(se.p.admin) == true>
<td>
<assign strDel>mps.hei?p=<? default(ff.p, "f")>&delete=t&m_id=<? se.p.arr[j].m_id>&id=<? se.p.arr[j].m_id; /assign>
// nn iamsglink href="editmp.hei." action="modify" receiver="editmp" mpid = (se.p.arr[j].m_id)>EDIT MP</iamsglink>
<a href=<? strDel>
onClick="return confirm('You are about to erase this member. Continue?')">
Delete</a>
</td>
</if>*/
// adding mp to committee
<if default(se.p.admin) == true || default(se.p.admin)=="ouma" && existscomm()>
<td>
<assign url>add.hei?add_id=<? integer(se.p.arr[j].add_id); /assign;
assign url2>remove.hei?add_id=<? integer(se.p.arr[j].add_id); /assign>
<a href=<? url>>Add</a> to
<if iscommmember(se.p.arr[j].add_id)>
or <a href=<? url2>>Remove</a> from
</if>
commitee
</td>
</if>
/*<if default(se.p.admin) == true && se.p.arr[j].end_date == null>
<td>
<assign url>end.hei?j=<? se.p.arr[j].id; /assign>
<a href=<? url>>End term</a>
</td>
</if>
<if default(se.p.admin) == true && se.p.arr[j].end_date != null>
<td>
<assign url>start.hei?j=<? se.p.arr[j].m_id; /assign>
<a href=<? url>>Start term</a>
</td>
</if>*/
</tr>
</for;
else;
forin j se.p.arr;
if c == "t";
bg = "#FCFBE2";
c = "f";
else;
bg = "#BDBB71";
c = "t";
/if>
<tr bgcolor=<? bg "Q">>
<td align = "left">
<assign strURL>mps.hei?p=<? default(ff.p, "f")>&n=t&details=t&j=<? integer(se.p.arr[j].m_id)>&const=<? se.p.arr[j].const "U">&dist_id=<? integer(se.p.arr[j].dist_id)>&distname=<? se.p.arr[j].distname; /assign>
<a href=<? strURL>> <? se.p.arr[j].sname> <? se.p.arr[j].onames> </a>
// <? se.p.arr[j].sname> <? se.p.arr[j].onames>
</td>
<if !((se.p.arr[j].distname)=="Updf")>
<if !((se.p.arr[j].distname)=="Ex-Officio") >
<td align = "left">
<? toupper(se.p.arr[j].partyname)> // (<? toupper(se.p.arr[j].description)> )
</td>
<else>
<td align = "left">
</td>
</if>
<else>
<td align = "left">
</td>
</if>
<if ((se.p.arr[j].distname)=="Worker") || ((se.p.arr[j].distname)=="Updf") || ((se.p.arr[j].distname)=="Pwd")|| ((se.p.arr[j].distname)=="Youth") || ((se.p.arr[j].distname)=="Ex-Officio")>
<td align = "left">
<? toupper(se.p.arr[j].distname)>
</td>
<td align = "center">
</td>
<else>
<td align = "left">
<? se.p.arr[j].const>
</td>
<td align = "left">
// <? se.p.arr[j].const> (<? se.p.arr[j].distname> District )
<? se.p.arr[j].distname> District
</td>
</if>
/*
<td>
// <assign strURL>mps.hei?p=<? default(ff.p, "f")>&n=t&details=t&j=<? integer(se.p.arr[j].m_id)>&distname=<? se.p.arr[j].distname; /assign>
<assign strURL>mps.hei?p=<? default(ff.p, "f")>&n=t&details=t&j=<? integer(se.p.arr[j].m_id)>&const=<? se.p.arr[j].const "U">&dist_id=<? integer(se.p.arr[j].dist_id)>&distname=<? se.p.arr[j].distname; /assign>
<a href=<? strURL>><? se.p.arr[j].sname> <? se.p.arr[j].onames></a>
</td>
<td>
/*<assign strURL>mps.hei?p=<? default(ff.p, "f")>&n=t&details=t&j=<? se.p.arr[j].const; /assign>
<a href=<? strURL>><? se.p.arr[j].const> </a>
<? se.p.arr[j].const> (<? se.p.arr[j].distname> )
</td>
*/
<if default(se.p.admin) == true>
<td>
<assign strDel>mps.hei?p=<? default(ff.p, "f")>&delete=t&mpid=<? se.p.arr[j].m_id>&m_id=<? se.p.arr[j].m_id; /assign>
<a href=<? strDel>
onClick="return confirm('You are about to erase this member. Continue?')">
Delete</a>
</td>
</if>
<if default(se.p.admin) == true || default(se.p.admin)=="ouma" && existscomm()>
<td>
<assign url>add.hei?add_id=<? se.p.arr[j].add_id; /assign;
assign url2>remove.hei?add_id=<? se.p.arr[j].add_id; /assign>
<a href=<? url>>Add</a> to
<if iscommmember(se.p.arr[j].add_id)>
or <a href=<? url2>>Remove</a> from
</if>
commitee
</td>
</if>
/*<if default(se.p.admin) == true && se.p.arr[j].end_date == null>
<td>
<assign url>end.hei?j=<? se.p.arr[j].id; /assign>
<a href=<? url>>End term</a>
</td>
</if>
<if default(se.p.admin) == true && se.p.arr[j].end_date != null>
<td>
<assign url>start.hei?j=<? se.p.arr[j].m_id; /assign>
<a href=<? url>>Start term</a>
</td>
</if>*/
</tr>
</forin;
/if>
<tr><td> <b>TOTAL NUMBER:</b> <? se.p.count></td></tr>
</table>
<if se.p.count > se.p.max>
<center>
<if default(se.p.scroller, "t") == "t";
if se.p.i == 0>
<b> First </b> | <b> Previous </b> [
<else;
assign url>mps.hei?p=<? default(ff.p, "f")>&n=t&prev=t&i=<? se.p.i; /assign;
assign furl>mps.hei?p=<? default(ff.p, "f")>&first=t&n=t</assign>
<a href=<? furl>>First</a> | <a href=<? url>>Previous</a> [
</if;
for j = 1, (j - 1) * se.p.max < se.p.count j = j + 1;
if se.p.i != j * se.p.max - se.p.max;
assign url>mps.hei?p=<? default(ff.p, "f")>&n=t&number=<? j; /assign>
<a href=<? url>><? j></a>
<else>
<b> <? j> </b>
</if;
/for;
if se.p.i + se.p.max &ge se.p.count>
] <b> Next </b> | <b> Last </b><br>
<else;
assign url>mps.hei?p=<? default(ff.p, "f")>&n=t&next=t&i=<? se.p.i; /assign;
assign lurl>mps.hei?p=<? default(ff.p, "f")>&n=t&last=t</assign>
] <a href=<? url>>Next</a> | <a href=<? lurl>>Last</a><br>
</if>
<sesform oid="hideScroller" method="post" successuri="">
<hideScroller name="sbmit" type="submit" value="Show all at once"></hideScroller>
</sesform>
<else;
sesform oid="showScroller" method="post" successuri="">
<showScroller name="sbmit" type="submit" value="Show 20 at a time"></showScroller>
</sesform;
/if>
</center>
</if;
/if;
if default(se.p.admin,false) == true>
// add new member
// <center><a href="mp.hei">Add new member</a></center>
<center>.</center>
<elsif default(ff.details, "") == "t">
<center>
<assign url>mps.hei?p=<? default(ff.p, "f"); /assign>
<a href=<? url>>Back to search page</a>
</center>
</if>
<if default(ff.details, "") != "t">
<center>
<hr align="center" size="1" noshade width="100%">
<assign url>mps.hei?p=<? default(ff.p, "f"); /assign>
<a name="search"></a>
<sesform oid="searchForm" method="post" successuri=(url)> // search form
<panelerrors js = "on" html="on" color="red" size="+1">
<table>
<tr>
<td align="right">Search the MP Database -<? ">"></td>
<td><fieldtext name="sKey" size=30 mandatory="True" trim="True" errmsg="No search key!!!"></td>
</tr>
<tr>
<td>by
<fieldselect name="by">
<if se.p.by == "tblmpname.surname">
<option value="tblmpname.surname">Name</option>
<option value="tblconstituency.constituencyname">Constituency</option>
<option value="tbldistrict.districtname">District</option>
<option value="tblmpname.profession">Profession</option>
<option value="tblmpname.interest">Special Interests</option>
<option value="tblparty.partyname">Party</option>
<elsif se.p.by == "tblconstituency.constituencyname">
<option value="tblconstituency.constituencyname">Constituency</option>
<option value="tblmpname.surname">Name</option>
<option value="tbldistrict.districtname">District</option>
<option value="tblmpname.profession">Profession</option>
<option value="tblmpname.interest">Special Interests</option>
<option value="tblparty.partyname">Party</option>
<elsif se.p.by == "tbldistrict.districtname">
<option value="tbldistrict.districtname">District</option>
<option value="tblconstituency.constituencyname">Constituency</option>
<option value="tblmpname.surname">Name</option>
<option value="tblmpname.profession">Profession</option>
<option value="tblmpname.interest">Special Interests</option>
<option value="tblparty.partyname">Party</option>
<elsif se.p.by == "tblmpname.profession">
<option value="tblmpname.profession">Profession</option>
<option value="tbldistrict.districtname">District</option>
<option value="tblconstituency.constituencyname">Constituency</option>
<option value="tblmpname.surname">Name</option>
<option value="tblmpname.interest">Special Interests</option>
<option value="tblparty.partyname">Party</option>
<elsif se.p.by == "tblparty.partyname">
<option value="tblparty.partyname">Party</option>
<option value="tblmpname.profession">Profession</option>
<option value="tbldistrict.districtname">District</option>
<option value="tblconstituency.constituencyname">Constituency</option>
<option value="tblmpname.surname">Name</option>
<option value="tblmpname.interest">Special Interests</option>
<else>
<option value="tblmpname.interest">Special Interests</option>
<option value="tblmpname.surname">Name</option>
<option value="tblconstituency.constituencyname">Constituency</option>
<option value="tbldistrict.districtname">District</option>
<option value="tblmpname.profession">Profession</option>
<option value="tblparty.partyname">Party</option>
</if>
</fieldselect>
</td>
<td>
<if default(ff.p) == "t">from
<fieldselect name="pal">
<if se.p.current_id == 0>
<option value=0>any parliament</option>
<else>
<option value=(se.p.current_id)>Only <? print_parliament(se.p.current_id)></option>
</if>
<dbquery q>
SELECT * FROM tblparliament
<dbrow;
if q.parliamentno != se.p.current_id>
<option value=(q.parliamentno)>Only <? print_parliament(q.parliamentno)></option>
</if;
/dbquery;
if se.p.current_id != 0>
<option value=0>any parliament</option>
</if>
</fieldselect>
<else>
<a href="mps.hei?p=t#search">Search Other Parliaments</a>
</if>
</td>
</tr>
<tr><td colspan=2> </tr>
<tr>
<if default(se.p.sKey, "") == "">
<td align=center colspan=2><btnSearch name="sbmit" type="submit" value="Search Now"></btnSearch></td>
<else>
<td align=center>
<assign url>mps.hei?c=t&p=<? default(ff.p, "f"); /assign>
<a href=<? url>>Show all</a>
</td>
<td align=center><btnSearch name="sbmit" type="submit" value="Search Now"></btnSearch></td>
</if>
</tr>
<if default(ff.p) == "t">
// <if isdecl(se.p.parl)>
// <tr>
// <td colspan=2 align="center"><a href="mps.hei">Back to <? print_parliament(getCurrent())></a></td>
// </tr>
// <else>
<tr>
<td colspan=2 align="center"><a href="mps.hei">Back </a></td>
</tr>
// </if>
</if>
</table>
</sesform>
</center>
</if>
</font></p>
</body>
</html>