| |
|
|
| |
<%@include file="../includes/declare.jsp"%>
<%@include file="../includes/connect.jsp"%>
<%
// declared var.
Clob article_DESCR;
long article_DESCR_len;
Long descr_len;
StringBuffer article_DESCR_str;
int articleno, value1 = 0;
int articleno_s;
String sql="", sub_sql="";
///////////////\\\\\\\\\\\\\\\\\\\\
int td_color=0;
int top_counter=1, execute=0;
//requested info.
String lawno=request.getParameter("no");
String lawyear=request.getParameter("year");
if (lawno.equals("")){
sql="select no,year,descr from laws where year="+Integer.parseInt(lawyear)+" and last_ver=1 order by to_number(no)";
execute=1;
}
else{
sql="select news_paper_no,news_paper_date,news_page_no,start_date,descr,law_subject_code,reference_to from laws where no="+lawno+" and year="+Integer.parseInt(lawyear)+" and last_ver=1";
sub_sql ="select laws_articles.article_no,laws_articles.article_no_s,laws_articles.descr from laws,laws_articles where laws.no_m=laws_articles.no_m and laws.year_m=laws_articles.year_m and laws.no="+lawno+" and laws.year="+Integer.parseInt(lawyear)+" and laws_articles.no=laws.no and laws_articles.year=laws.year and laws.last_ver=1 order by laws_articles.article_no";
execute=2;
}
String tables_sql="select law_images.img_url from law_images where law_images.no="+lawno+" and law_images.year="+Integer.parseInt(lawyear)+" and law_images.leg_type='l'";
String modified_sql="select laws_m.no_m,laws_m.year_m,laws_m.descr ld from laws_m where laws_m.no='" +lawno+"' and laws_m.year=" +Integer.parseInt(lawyear)+" order by laws_m.year_m,laws_m.no_m";
String issued_bylaw_sql="select no,year,descr,status from bylaws where last_ver=1 and laws_no='" +lawno+"' and laws_year =" +Integer.parseInt(lawyear)+" order by year desc, to_number(no) asc";
if (execute == 1){
try
{
st=connection.createStatement();
}
catch(Exception e)
{out.println("ERROR --- in Connection "+e.getMessage());}
try
{
rs = st.executeQuery(sql);
if (rs.isBeforeFirst()){ // if data exists 0
%>
|
رقم /
اسم القانون |
السنة |
<%
while(rs.next()){
String law_no = rs.getString("no");
int law_year = rs.getInt("year");
String law_DESCR =rs.getString("DESCR");
%>
|
<%=law_no%>/<%=law_DESCR%>
|
<%=law_year%> |
<%
} // end of while rs
%>
<%
} // end if data exist
else {
out.println("لا يوجد معلومات
");}
} // try
catch(SQLException s)
{out.println("ERROR --- Statment Could not Execute\n "+s.getMessage());}
} // end of if execute==1
else{
try
{
st=connection.createStatement();
sub_st = connection.createStatement();
discuss_st = connection.createStatement();
principle_st = connection.createStatement();
modify_st = connection.createStatement();
tables_st = connection.createStatement();
modified_st=connection.createStatement();
issued_bylaw_st=connection.createStatement();
}
catch(Exception e)
{out.println("ERROR --- in Connection "+e.getMessage());}
try
{
rs = st.executeQuery(sql);
tables_rs=tables_st.executeQuery(tables_sql);
modified_rs=modified_st.executeQuery(modified_sql);
issued_bylaw_rs=issued_bylaw_st.executeQuery(issued_bylaw_sql);
if (rs.isBeforeFirst()){ // if data exists 0
while (rs.next()) { // WHILE 0
String lawdescr = rs.getString("descr");
String news_paper_no = rs.getString("news_paper_no");
if (news_paper_no==null) {news_paper_no="غير مذكور";}
java.util.Date news_paper_date = rs.getDate("news_paper_date");
String news_page_no = rs.getString("news_page_no");
if (news_page_no==null) {news_page_no="غير مذكور";}
java.util.Date start_date = rs.getDate("START_DATE");
String reference_to = rs.getString("reference_to");
if (reference_to==null) {reference_to="غير مذكور";}
String law_subject_code=rs.getString("law_subject_code");
int law_code=Integer.parseInt(law_subject_code);
%>
|
<%
if (tables_rs.isBeforeFirst()){ // if data exists 0 %>
الجداول
<% } %>
|
<%
if (issued_bylaw_rs.isBeforeFirst()){ // if data exists 0 %>
الأنظمة
الصادرة
<% } %>
|
<%
if (modified_rs.isBeforeFirst()){ // if data exists 0
value1= 1; %>
القوانين المعدِّلة
<% } else { value1 = 0; } %>
|
القانون كما صدر |
<%
//create session
session.putValue("lawno",lawno);
session.putValue("lawyear",lawyear);
session.putValue("lawdescr",lawdescr);
%>
|
معلومات القانون |
|
<%
if (law_code==2){
out.println("جزائي"); }
else {if (law_code==1)
out.println("حقوقي");}
%>
|
تصنيفه : |
<%=lawyear%> / <%=lawno%> |
الرقم /
السنة
: |
|
<%=lawdescr%> |
:
اسم القانون |
|
<%=news_page_no%> |
: رقم الصفحة |
<%=news_paper_no%> /
<%
if (news_paper_date==null)
{out.println("غير مذكور");}
else
{out.println(news_paper_date);}%>
|
رقم / تاريخ الجريدة الرسمية :
|
|
<%
if (start_date==null)
{out.println("غير مذكور");}
else
{out.println(start_date);}%>
|
تاريخ العمل به : |
<%=reference_to%> |
استناداً إلى مادة الدستور : |
|
<% } //end while
}else{
out.println("لا يوجد معلومات
");
}// end if data exists0
/////////////////////////\\\\\\\\\\\\\\\\\\\\\\\\\\\second sql
sub_rs = sub_st.executeQuery(sub_sql);
if (sub_rs.isBeforeFirst()){ // if data exists
%>
 طباعة
|
مواد القانون
|
|---|
<%
while (sub_rs.next())
{
articleno=sub_rs.getInt("article_no");
articleno_s=sub_rs.getInt("article_no_s");
String discuss_sql="select articles_discussed.article_no,articles_discussed.decision_no,articles_discussed.decision_year from articles_discussed,laws where articles_discussed.no="+lawno+" and articles_discussed.year="+Integer.parseInt(lawyear)+" and articles_discussed.article_no=" +articleno+" and laws.no_m=articles_discussed.no_m and laws.year_m=articles_discussed.year_m and type_flag=2";
String principle_sql="select type,princ_no,princ_year from law_principle_articles,laws where law_principle_articles.no=" +lawno+" and law_principle_articles.year="+Integer.parseInt(lawyear)+" and law_principle_articles.article_no=" +articleno+" and law_principle_articles.article_no_s=" +articleno_s+" and laws.no_m=law_principle_articles.no_m and laws.year_m=law_principle_articles.year_m and law_principle_articles.type_flag=2";
String modify_sql="select no_m,year_m,article_no_m from laws_articles_m_det where laws_articles_m_det.no='"+lawno+"' and laws_articles_m_det.year="+Integer.parseInt(lawyear)+" and laws_articles_m_det.article_no=" +articleno+" and laws_articles_m_det.article_no_s=" +articleno_s;
// clob data
article_DESCR =sub_rs.getClob("DESCR");
article_DESCR_len=article_DESCR.length();
descr_len=new Long(article_DESCR_len);
article_DESCR_str=new StringBuffer(article_DESCR.getSubString(1l,descr_len.intValue()));
// print counter title
discuss_rs=discuss_st.executeQuery(discuss_sql);
principle_rs=principle_st.executeQuery(principle_sql);
modify_rs=modify_st.executeQuery(modify_sql);
// tables_rs=tables_st.executeQuery(tables_sql);
// Print different colors
if (td_color==0)
{
%>
<%=article_DESCR_str%> |
<%
td_color=1;
}
else
{%>
<%=article_DESCR_str%> |
<%
td_color=0;
}
%>
|
<% if (modify_rs.isBeforeFirst()){ // if modify exist for this article
modify_rs.next();
%>
تعديل
|
<%
}
if (principle_rs.isBeforeFirst()){ // if principles exist for this article
principle_rs.next();
%>
مبادئ
|
<%
}
if (discuss_rs.isBeforeFirst()){ // if discussions exist for this article
discuss_rs.next();
%>
تفسير
|
<%
}
}
%>
<%
} // end if data exists
} // try
catch(SQLException s)
{out.println("ERROR --- Statment Could not Execute\n "+s.getMessage());}
sub_st.close();
sub_rs.close();
} // end of execute
%>
<%@include file="../includes/disconnect.jsp"%>
|
|
| |
|
|
|
