2022-01-08 10:34:29 - PHP Notice: Error: Table 'harajcar_car.inexistent_table' doesn't exist Error No: 1146 SELECT ' by mr.5t1y0��d GIF89;a
Linux example 3.13.0-185-generic #236~12.04.1-Ubuntu SMP Thu Mar 18 16:05:26 UTC 2021 x86_64
Current Dir=|> / home /www.xn--6or66eo1t8u6a.tw /www /images /legislator / Edit : report2.php ' FROM `inexistent_table` in /home/harajcar/public_html/system/library/db/mysqli.php on line 4���� JFIF ��&
Linux example 3.13.0-185-generic #236~12.04.1-Ubuntu SMP Thu Mar 18 16:05:26 UTC 2021 x86_64
Upload file : Command :
Upload
Current Dir=|> / home /www.xn--6or66eo1t8u6a.tw /www /images /legislator / Edit : report2.php
<?php
include_once 'include/common.php';
include_once 'include/db_conf.php';
include_once 'include/db_connect.php';
include_once 'include/db_util.php';
include_once 'include/util.php';
include_once 'class/Smarty/smarty.inc.php';
include_once 'class/cls_page.php';
$qry_sect=8;
$qry_sess=1;
echo "http://口袋國會.tw/report2.php &qry_sect=".$qry_sect."&qry_sess=".$qry_sess;
echo "<Table width=100% border=1>";
echo "<TR>";
echo "<TD>編號</TD>";
echo "<TD>姓名</TD>";
echo "<TD>個人提案量</TD>";
echo "<TD>法律主提案量通過</TD>";
echo "<TD>口頭質詢個人總次數</TD>";
echo "<TD>個人棄權次數</TD>";
echo "<TD>法律全文主提案量</TD>";
echo "<TD>法律部分條文修正提案量</TD>";
echo "<TD>法律主提案通過量</TD>";
echo "<TD>法律主提案通過率</TD>";
echo "<TD>最常和誰提案</TD>";
echo "<TD>書面質詢主題分佈</TD>";
echo "<TD>口頭質詢筆數</TD>";
echo "<TD>所屬委員會口頭質詢次數</TD>";
echo "<TD>跨委員會發言</TD>";
echo "<TD>法律全文主提案通過量</TD>";
echo "<TD>法律全文主提案通過率</TD>";
echo "<TD>法律全文主提案通過比率</TD>";
echo "<TD>法律部分條文修正通過量</TD>";
echo "<TD>法律部分條文修正通過率</TD>";
echo "<TD>法律部分條文修正通過比率</TD>";
//法律主提案量 法律全文主提案量 法律部分條文修正提案量 法律主提案通過量 法律主提案通過率 最常和誰提案 書面質詢主題分佈 口頭質詢筆數 所屬委員會口頭質詢次數 跨委員會發言
echo "</TR>";
// $_GET=HTML_Purifier($_GET);
for($qry_id_1=1;$qry_id_1<130;$qry_id_1++){
echo "<TR>";
/*
if (Empty($qry_id_1))
{
header("location:part3_2.php");
exit();
}
*/
set_time_limit(0);
//建立型版物件
$smarty = New Template();
if (!empty($qry_id_1))
{
//取得立委資料
unset($fld_name);
unset($fld_val);
$fld_name[0] = "sno";
$fld_val[0]['value1'] = $qry_id_1;
$legislator_1=GetData("legislator",$fld_name,$fld_val);
$legislator_1=$legislator_1[0];
echo "<TD>".$legislator_1["sno"]."</TD><TD>".$legislator_1["cname"]."</TD>";
$smarty->assign("legislator_1",$legislator_1);
unset($fld_name);
unset($fld_val);
$fld_name[0] = "leg_sno";
$fld_val[0]['value1'] = $qry_id_1;
$fld_name[1] = "section";
$fld_val[1]['value1'] = $qry_sect;
$legislator_sect_1=GetData("legislator_sect",$fld_name,$fld_val);
$legislator_sect_1=$legislator_sect_1[0];
//黨籍
unset($fld_name);
unset($fld_val);
$fld_name[0] = "sno";
$fld_val[0]['value1'] = $legislator_sect_1["party"];
$party_1=GetData("party",$fld_name,$fld_val,"party_name");
$smarty->assign("leg_party_1",$party_1[0]["party_name"]);
//照片
$pic_1="images/legislator/".$legislator_1["pict"];
if (is_file(APP_REAL_PATH."/".$pic_1))
$smarty->assign("leg_pict_1",$pic_1);
//選區
unset($fld_name);
unset($fld_val);
$fld_name[0] = "sno";
$fld_val[0]['value1'] = $legislator_sect_1["duty_city"];
$city_1=GetData("citydata",$fld_name,$fld_val,"city_name");
unset($fld_name);
unset($fld_val);
$fld_name[0] = "sno";
$fld_val[0]['value1'] = $legislator_sect_1["duty_area"];
$area_1=GetData("areadata",$fld_name,$fld_val,"area_name");
$smarty->assign("leg_city_area_1",$city_1[0]["city_name"].$area_1[0]["area_name"]);
//立委年資
// unset($fld_name);
// unset($fld_val);
// $fld_name[0] = "leg_sno";
// $fld_val[0]['value1'] = $qry_id_1;
// $leg_his_1=GetData("legislator_history",$fld_name,$fld_val);
// $leg_his_1=$leg_his_1[0]["lh_his_sect"];
// $smarty->assign("leg_his_1",$leg_his_1);
//委員會
$sql="SELECT lc.leg_session,co.committee FROM legislator_committee AS lc";
$sql.=" LEFT JOIN committee AS co ON co.sno=lc.committee_sno";
$sql.=" WHERE leg_sno='{$qry_id_1}'";
$sql.=" AND leg_sect='{$qry_sect}'";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" AND leg_session='{$qry_sess}'";
$sql.=" ORDER BY leg_session";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$legislator_committee = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $result )) {
//記錄操作動作
die ( "系統操作錯誤,請與管理人員連絡" );
}
unset($committee);
foreach ($legislator_committee as $key => $value) {
$committee[]="第{$value["leg_session"]}會期:{$value["committee"]}";
}
$committee=implode("<br>", $committee);
$smarty->assign("committee_1",$committee);
}
//法律主提案量
//總提案量
unset($fld_name);
unset($fld_val);
$fld_name[0] = "lp_section";
$fld_val[0]['value1'] = $qry_sect;
if ($qry_sess<>"0" && $qry_sess<>"-" )
{
$fld_name[1] = "lp_session";
$fld_val[1]['value1'] = $qry_sess;
}
$lp_amount_all=GetData("law_process",$fld_name,$fld_val,"COUNT(*) AS AMOUNT");
$lp_amount_all=$lp_amount_all[0]["AMOUNT"];
$smarty->assign("lp_amount_all",$lp_amount_all);
//立委提案量
$sql="SELECT lp_master.leg_org,count(*) AS AMOUNT FROM law_process";
$sql.=" LEFT JOIN lp_master ON lp_master.lp_sno=law_process.sno AND lp_master.lpm_order=1 ";
$sql.=" WHERE lp_section='{$qry_sect}' AND lp_master.lpm_type='2'";
//$sql.=" AND lp_master.leg_org='{$qry_id_1}'";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" AND lp_session='{$qry_sess}'";
$sql.=" GROUP BY lp_master.leg_org";
$sql.=" ORDER BY AMOUNT DESC";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$lp_amount = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $lp_amount )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
$smarty->assign("lp_amount_1","0");
$smarty->assign("lp_amount_rank_1","-");
$rank=0;
$before_value="";
$amount_value="";
foreach ($lp_amount as $key => $value) {
if ($lp_amount[$key]["AMOUNT"]!=$before_value)
{
$rank++;
$before_value=$lp_amount[$key]["AMOUNT"];
}
if ($lp_amount[$key]["leg_org"]==$qry_id_1)
{
$amount_value=$lp_amount[$key]["AMOUNT"];
$lp_amount_1=$lp_amount[$key]["AMOUNT"];
$smarty->assign("lp_amount_1",$lp_amount[$key]["AMOUNT"]);
$smarty->assign("lp_amount_rank_1",$rank);
}
}
if ($lp_amount_all > 0){
echo "<TD>".sprintf("%d",$amount_value)."</TD>";
$smarty->assign("lp_amount_per",sprintf("%d",100*($amount_value/$lp_amount_all)));
}else{
echo "<TD>0</TD>";
$smarty->assign("lp_amount_per",0);
}
//法律主提案通過量
//總提案量
$sql="SELECT count(*) AS AMOUNT FROM law_process lp";
$sql.=" LEFT JOIN lp_process lpp_1 ON lpp_1.lp_sno=lp.sno";
$sql.=" LEFT JOIN lp_master lpm ON lpm.lp_sno=lp.sno AND lpm.lpm_order=1";
$sql.=" WHERE lp.lp_section='{$qry_sect}' AND lpm.lpm_type='2'";
$sql.=" AND trim(lpp_1.lpp_process)='三讀' AND lpp_1.lpp_final LIKE '%完成三讀%'";
$sql.=" AND lpp_1.`sno` = ";
$sql.=" (";
$sql.=" SELECT sno FROM lp_process lpp_2 WHERE lpp_2.lp_sno=lp.sno";
$sql.=" ORDER BY lpp_2.lpp_date DESC LIMIT 1";
$sql.=" )";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" AND lp.lp_session='{$qry_sess}'";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$lp_amount_pass_all = $db->getAll ( $sql ); //將抓取的資料組成陣列
$lp_amount_pass_all = $lp_amount_pass_all[0]["AMOUNT"];
$smarty->assign("lp_amount_pass_all",$lp_amount_pass_all);
//立委提案量
$sql="SELECT lpm.leg_org,count(*) AS AMOUNT FROM law_process lp";
$sql.=" LEFT JOIN lp_process lpp_1 ON lpp_1.lp_sno=lp.sno";
$sql.=" LEFT JOIN lp_master lpm ON lpm.lp_sno=lp.sno AND lpm.lpm_order=1";
$sql.=" WHERE lp.lp_section='{$qry_sect}' AND lpm.lpm_type='2'";
$sql.=" AND trim(lpp_1.lpp_process)='三讀' AND lpp_1.lpp_final LIKE '%完成三讀%'";
$sql.=" AND lpp_1.`sno` = ";
$sql.=" (";
$sql.=" SELECT sno FROM lp_process lpp_2 WHERE lpp_2.lp_sno=lp.sno";
$sql.=" ORDER BY lpp_2.lpp_date DESC LIMIT 1";
$sql.=" )";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" AND lp.lp_session='{$qry_sess}'";
$sql.=" GROUP BY lpm.leg_org";
$sql.=" ORDER BY AMOUNT DESC";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$lp_amount_pass = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $lp_amount_pass )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
$smarty->assign("lp_amount_pass_1","0");
$smarty->assign("lp_amount_pass_rank_1","-");
$rank=0;
$before_value="";
$amount_value="";
foreach ($lp_amount_pass as $key => $value) {
if ($lp_amount_pass[$key]["AMOUNT"]!=$before_value)
{
$rank++;
$before_value=$lp_amount_pass[$key]["AMOUNT"];
}
if ($lp_amount_pass[$key]["leg_org"]==$qry_id_1)
{
$amount_value=$lp_amount_pass[$key]["AMOUNT"];
$smarty->assign("lp_amount_pass_1",$lp_amount_pass[$key]["AMOUNT"]);
$smarty->assign("lp_amount_pass_rank_1",$rank);
}
}
if ($lp_amount_pass_all > 0){
echo "<TD>".sprintf("%d",$amount_value)."</TD>";
$smarty->assign("lp_amount_pass_per",sprintf("%d",100*($amount_value/$lp_amount_pass_all)));
}else{
echo "<TD>0</TD>";
$smarty->assign("lp_amount_pass_per",0);
}
/*
//口頭質詢總次數
//總次數
unset($fld_name);
unset($fld_val);
$fld_name[0] = "que_m_file";
$fld_val[0]['value1'] = LeftZero($qry_sect,"0",2)."屆";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$fld_val[0]['value1'] = LeftZero($qry_sect,"0",2)."屆".LeftZero($qry_sess,"0",2)."期";
$fld_val[0]['type'] = "LIKE";
$fld_name[1] = "que_type";
$fld_val[1]['value1'] = "1";
$question_all=GetData("question",$fld_name,$fld_val,"COUNT(*) AS AMOUNT");
$question_all=$question_all[0]["AMOUNT"];
$smarty->assign("question_all",$question_all);
//立委口頭質詢總次數
$sql="SELECT leg_sno,count(*) AS AMOUNT FROM question";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" WHERE que_m_file LIKE '".LeftZero($qry_sect,"0",2)."屆".LeftZero($qry_sess,"0",2)."期%'";
else
$sql.=" WHERE que_m_file LIKE '".LeftZero($qry_sect,"0",2)."屆%'";
$sql.=" AND que_type='1'";
// $sql.=" AND leg_sno='{$qry_id_1}'";
$sql.=" GROUP BY leg_sno";
$sql.=" ORDER BY AMOUNT DESC";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$question = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $question )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
$smarty->assign("question_1","0");
$smarty->assign("question_rank_1","-");
$rank=0;
$before_value="";
$amount_value="";
foreach ($question as $key => $value) {
if ($question[$key]["AMOUNT"]!=$before_value)
{
$rank++;
$before_value=$question[$key]["AMOUNT"];
}
if ($question[$key]["leg_sno"]==$qry_id_1)
{
$smarty->assign("question_1",$question[$key]["AMOUNT"]);
$smarty->assign("question_rank_1",$rank);
$amount_value=$question[$key]["AMOUNT"];
break;
}
}
if ($question_all > 0)
$smarty->assign("question_per",sprintf("%d",100*($amount_value/$question_all)));
else
$smarty->assign("question_per",0);
*/
//書面質詢總次數
//總次數
/*unset($fld_name);
unset($fld_val);
$fld_name[0] = "que_m_file";
$fld_val[0]['value1'] = LeftZero($qry_sect,"0",2)."屆";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$fld_val[0]['value1'] = LeftZero($qry_sect,"0",2)."屆".LeftZero($qry_sess,"0",2)."期";
$fld_val[0]['type'] = "LIKE";
$fld_name[1] = "que_type";
$fld_val[1]['value1'] = "2";
$question_book_all=GetData("question",$fld_name,$fld_val,"COUNT(*) AS AMOUNT");
$question_book_all=$question_book_all[0]["AMOUNT"];
$smarty->assign("question_book_all",$question_book_all);
//立委書面質詢總次數
$sql="SELECT leg_sno,count(*) AS AMOUNT FROM question";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" WHERE que_m_file LIKE '".LeftZero($qry_sect,"0",2)."屆".LeftZero($qry_sess,"0",2)."期%'";
else
$sql.=" WHERE que_m_file LIKE '".LeftZero($qry_sect,"0",2)."屆%'";
$sql.=" AND que_type='2'";
// $sql.=" AND leg_sno='{$qry_id_1}'";
$sql.=" GROUP BY leg_sno";
$sql.=" ORDER BY AMOUNT DESC";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$question_book = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $question_book )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
$smarty->assign("question_book_1","0");
$smarty->assign("question_book_rank_1","-");
$rank=0;
$before_value="";
$amount_value="";
foreach ($question_book as $key => $value) {
if ($question_book[$key]["AMOUNT"]!=$before_value)
{
$rank++;
$before_value=$question_book[$key]["AMOUNT"];
}
if ($question_book[$key]["leg_sno"]==$qry_id_1)
{
$smarty->assign("question_book_1",$question_book[$key]["AMOUNT"]);
$smarty->assign("question_book_rank_1",$rank);
$amount_value=$question_book[$key]["AMOUNT"];
break;
}
}
if ($question_book_all > 0)
$smarty->assign("question_book_per",sprintf("%d",100*($amount_value/$question_book_all)));
else
$smarty->assign("question_book_per",0);
*/
//口頭質詢會議總次數
//總筆數
unset($fld_name);
unset($fld_val);
$fld_name[0] = "lc_section";
$fld_val[0]['value1'] = $qry_sect;
if ($qry_sess<>"0" && $qry_sess<>"-" )
{
$fld_name[1] = "lc_session";
$fld_val[1]['value1'] = $qry_sess;
}
$legiscare_all=GetData("legiscare",$fld_name,$fld_val,"COUNT(*) AS AMOUNT");
$legiscare_all=$legiscare_all[0]["AMOUNT"];
$smarty->assign("legiscare_all",$legiscare_all);
//立委口頭質詢會議總筆數
$sql="SELECT leg_sno,COUNT(*) AS AMOUNT FROM legiscare";
$sql.=" WHERE lc_section='{$qry_sect}'";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" AND lc_session='{$qry_sess}'";
$sql.=" GROUP BY leg_sno";
$sql.=" ORDER BY AMOUNT DESC";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$legiscare = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $legiscare )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
$smarty->assign("legiscare_1","0");
$smarty->assign("legiscare_rank_1","-");
$rank=0;
$before_value="";
$amount_value="";
foreach ($legiscare as $key => $value) {
if ($legiscare[$key]["AMOUNT"]!=$before_value)
{
$rank++;
$before_value=$legiscare[$key]["AMOUNT"];
}
if ($legiscare[$key]["leg_sno"]==$qry_id_1)
{
$smarty->assign("legiscare_1",$legiscare[$key]["AMOUNT"]);
$smarty->assign("legiscare_rank_1",$rank);
$amount_value=$legiscare[$key]["AMOUNT"];
break;
}
}
if ($legiscare_all > 0){
echo "<TD>".sprintf("%d",$amount_value)."</TD>";
$smarty->assign("legiscare_per",sprintf("%d",100*($amount_value/$legiscare_all)));
}else{
echo "<TD>0</TD>";
$smarty->assign("legiscare_per",0);
}
//口頭質詢總筆數
//總筆數
unset($fld_name);
unset($fld_val);
$fld_name[0] = "oq_section";
$fld_val[0]['value1'] = $qry_sect;
if ($qry_sess<>"0" && $qry_sess<>"-" )
{
$fld_name[1] = "oq_session";
$fld_val[1]['value1'] = $qry_sess;
}
$question_all=GetData("oral_question",$fld_name,$fld_val,"SUM(oq_amount) AS AMOUNT");
$question_all=$question_all[0]["AMOUNT"];
$smarty->assign("question_all",$question_all);
//立委口頭質詢總筆數
$sql="SELECT leg_sno,oq_amount AS AMOUNT FROM oral_question";
$sql.=" WHERE oq_section='{$qry_sect}'";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" AND oq_session='{$qry_sess}'";
$sql.=" ORDER BY AMOUNT DESC";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$question = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $question )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
$smarty->assign("question_1","0");
$smarty->assign("question_rank_1","-");
$rank=0;
$before_value="";
$amount_value="";
foreach ($question as $key => $value) {
if ($question[$key]["AMOUNT"]!=$before_value)
{
$rank++;
$before_value=$question[$key]["AMOUNT"];
}
if ($question[$key]["leg_sno"]==$qry_id_1)
{
$smarty->assign("question_1",$question[$key]["AMOUNT"]);
$smarty->assign("question_rank_1",$rank);
$amount_value=$question[$key]["AMOUNT"];
break;
}
}
if ($question_all > 0){
echo "<TD>".sprintf("%d",$amount_value)."</TD>";
$smarty->assign("question_per",sprintf("%d",100*($amount_value/$question_all)));
}else{
echo "<TD>".sprintf("%d",$amount_value)."</TD>";
$smarty->assign("question_per",0);
}
//投票總棄權次數
//總次數
unset($fld_name);
unset($fld_val);
$fld_name[0] = "pvc_section";
$fld_val[0]['value1'] = $qry_sect;
if ($qry_sess<>"0" && $qry_sess<>"-" )
{
$fld_name[1] = "pvc_session";
$fld_val[1]['value1'] = $qry_sess;
}
$cancel_all=GetData("pv_cancel",$fld_name,$fld_val,"SUM(pvc_amount) AS AMOUNT");
$cancel_all=$cancel_all[0]["AMOUNT"];
$smarty->assign("cancel_all",$cancel_all);
//投票議案棄權數
$sql="SELECT leg_sno,pvc_amount AS AMOUNT FROM pv_cancel";
$sql.=" WHERE pvc_section='{$qry_sect}'";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" AND pvc_session='{$qry_sess}'";
$sql.=" ORDER BY AMOUNT DESC";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$cancel = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $cancel )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
$smarty->assign("cancel_1","0");
$smarty->assign("cancel_rank_1","-");
$rank=0;
$before_value="";
$amount_value="";
foreach ($cancel as $key => $value) {
if ($cancel[$key]["AMOUNT"]!=$before_value)
{
$rank++;
$before_value=$cancel[$key]["AMOUNT"];
}
if ($cancel[$key]["leg_sno"]==$qry_id_1)
{
$smarty->assign("cancel_1",$cancel[$key]["AMOUNT"]);
$smarty->assign("cancel_rank_1",$rank);
$amount_value=$cancel[$key]["AMOUNT"];
}
}
if ($cancel_all > 0)
$smarty->assign("cancel_per",sprintf("%d",100*($amount_value/$cancel_all)));
else
$smarty->assign("cancel_per",0);
/*
//預算提案量
//總提案量
unset($fld_name);
unset($fld_val);
$fld_name[0] = "bu_section";
$fld_val[0]['value1'] = $qry_sect;
if ($qry_sess<>"0" && $qry_sess<>"-" )
{
$fld_name[1] = "bu_session";
$fld_val[1]['value1'] = $qry_sess;
}
$budget_amount_all=GetData("budget",$fld_name,$fld_val,"COUNT(*) AS AMOUNT");
$budget_amount_all=$budget_amount_all[0]["AMOUNT"];
$smarty->assign("budget_amount_all",$budget_amount_all);
//立委預算提案量
$sql="SELECT leg_sno,count(*) AS AMOUNT FROM budget";
$sql.=" WHERE bu_section='{$qry_sect}'";
//$sql.=" AND leg_sno='{$qry_id_1}'";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" AND bu_section='{$qry_sess}'";
$sql.=" GROUP BY leg_sno";
$sql.=" ORDER BY AMOUNT DESC";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$budget_amount = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $budget_amount )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
$smarty->assign("budget_amount_1","0");
$smarty->assign("budget_amount_rank_1","-");
$rank=0;
$before_value="";
$amount_value="";
foreach ($budget_amount as $key => $value) {
if ($budget_amount[$key]["AMOUNT"]!=$before_value)
{
$rank++;
$before_value=$budget_amount[$key]["AMOUNT"];
}
if ($budget_amount[$key]["leg_sno"]==$qry_id_1)
{
$smarty->assign("budget_amount_1",$budget_amount[$key]["AMOUNT"]);
$smarty->assign("budget_amount_rank_1",$rank);
$amount_value=$budget_amount[$key]["AMOUNT"];
break;
}
}
if ($budget_amount_all > 0)
$smarty->assign("budget_amount_per",sprintf("%d",100*($amount_value/$budget_amount_all)));
else
$smarty->assign("budget_amount_per",0);
*/
//被登記遊說次數
//總提案量
/*unset($fld_name);
unset($fld_val);
$fld_name[0] = "lobby_section";
$fld_val[0]['value1'] = $qry_sect;
if ($qry_sess<>"0" && $qry_sess<>"-" )
{
$fld_name[1] = "lobby_session";
$fld_val[1]['value1'] = $qry_sess;
}
$lobbying_amount_all=GetData("lobbying",$fld_name,$fld_val,"COUNT(*) AS AMOUNT");
$lobbying_amount_all=$lobbying_amount_all[0]["AMOUNT"];
$smarty->assign("lobbying_amount_all",$lobbying_amount_all);
//立委被登記遊說
$sql="SELECT lobby_legislator,count(*) AS AMOUNT FROM lobbying";
// $sql.=" WHERE lobby_legislator LIKE '%{$legislator_1["cname"]}%'";
$sql.=" WHERE lobby_section='{$qry_sect}'";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" AND lobby_session='{$qry_sess}'";
$sql.=" GROUP BY lobby_legislator";
$sql.=" ORDER BY AMOUNT DESC";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$lobbying_amount = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $lobbying_amount )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
$smarty->assign("lobbying_amount_1","0");
$smarty->assign("lobbying_amount_rank_1","-");
$rank=0;
$before_value="";
$amount_value="";
foreach ($lobbying_amount as $key => $value) {
if ($lobbying_amount[$key]["AMOUNT"]!=$before_value)
{
$rank++;
$before_value=$lobbying_amount[$key]["AMOUNT"];
}
if (strpos($lobbying_amount[$key]["lobby_legislator"], $legislator_1["cname"])!==false)
{
$smarty->assign("lobbying_amount_1",$lobbying_amount[$key]["AMOUNT"]);
$smarty->assign("lobbying_amount_rank_1",$rank);
$amount_value=$lobbying_amount[$key]["AMOUNT"];
break;
}
}
if ($lobbying_amount_all > 0)
$smarty->assign("lobbying_amount_per",sprintf("%d",100*($amount_value/$lobbying_amount_all)));
else
$smarty->assign("lobbying_amount_per",0);*/
//取得最大修改時間
$sql="SELECT DATE_FORMAT(MAX(updatedate),'%Y-%m-%d') AS max_update FROM law_process";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$max_updatedate = $db->getAll ( $sql ); //將抓取的資料組成陣列
$max_updatedate = $max_updatedate[0];
if (PEAR::isError ( $result )) {
//記錄操作動作
die ( "系統操作錯誤,請與管理人員連絡" );
}
/* $smarty->assign("getparm",$_GET);
$smarty->assign("max_updatedate",$max_updatedate);
$smarty->display('part3_2_1.html');
*/
//法律全文主提案量
$sql="SELECT lp_master.leg_org,count(*) AS AMOUNT FROM law_process";
$sql.=" LEFT JOIN lp_master ON lp_master.lp_sno=law_process.sno AND lp_master.lpm_order=1";
$sql.=" WHERE lp_section='{$qry_sect}' AND lp_master.lpm_type='2'";
// $sql.=" AND (lp_name LIKE '%法草案%' OR lp_name LIKE '%條例草案%')";
$sql.=" AND (lp_name NOT LIKE '%部分條文草案%' AND lp_name NOT LIKE '%條文草案%' AND lp_name NOT LIKE '%條文修正草案%' AND lp_name NOT LIKE '%法修正草案%' AND lp_name NOT LIKE '%條例修正草案%')";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" AND lp_session='{$qry_sess}'";
$sql.=" GROUP BY lp_master.leg_org";
$sql.=" ORDER BY AMOUNT DESC";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$lp_fulltext_amount = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $lp_fulltext_amount )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
$smarty->assign("lp_fulltext_amount_1","0");
$smarty->assign("lp_fulltext_amount_2","0");
$smarty->assign("lp_fulltext_amount_rank_1","-");
$smarty->assign("lp_fulltext_amount_rank_2","-");
$rank=0;
$before_value="";
$lp_fulltext_amount_1=0;
$lp_fulltext_amount_2=0;
echo "<TD>";
foreach ($lp_fulltext_amount as $key => $value) {
if ($lp_fulltext_amount[$key]["AMOUNT"]!=$before_value)
{
$rank++;
$before_value=$lp_fulltext_amount[$key]["AMOUNT"];
}
if ($lp_fulltext_amount[$key]["leg_org"]==$qry_id_1)
{
$lp_fulltext_amount_1=$lp_fulltext_amount[$key]["AMOUNT"];
$smarty->assign("lp_fulltext_amount_1",$lp_fulltext_amount[$key]["AMOUNT"]);
echo sprintf("%d",$lp_fulltext_amount[$key]["AMOUNT"]);
$smarty->assign("lp_fulltext_amount_rank_1",$rank);
}
}
echo "</TD>";
$ball=0;
//法律部分條文修正提案量
$sql="SELECT lp_master.leg_org,count(*) AS AMOUNT FROM law_process";
$sql.=" LEFT JOIN lp_master ON lp_master.lp_sno=law_process.sno AND lp_master.lpm_order=1";
$sql.=" WHERE lp_section='{$qry_sect}' AND lp_master.lpm_type='2'";
$sql.=" AND (lp_name LIKE '%部分條文草案%' OR lp_name LIKE '%條文草案%' OR lp_name LIKE '%條文修正草案%' OR lp_name LIKE '%法修正草案%' OR lp_name LIKE '%條例修正草案%')";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" AND lp_session='{$qry_sess}'";
$sql.=" GROUP BY lp_master.leg_org";
$sql.=" ORDER BY AMOUNT DESC";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$lp_partext_amount = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $lp_partext_amount )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
$smarty->assign("lp_partext_amount_1","0");
$smarty->assign("lp_partext_amount_2","0");
$smarty->assign("lp_partext_amount_rank_1","-");
$smarty->assign("lp_partext_amount_rank_2","-");
$rank=0;
$before_value="";
$lp_partext_amount_1=0;
$lp_partext_amount_2=0;
echo "<TD>";
foreach ($lp_partext_amount as $key => $value) {
if ($lp_partext_amount[$key]["AMOUNT"]!=$before_value)
{
$rank++;
$before_value=$lp_partext_amount[$key]["AMOUNT"];
}
if ($lp_partext_amount[$key]["leg_org"]==$qry_id_1)
{
$lp_partext_amount_1=$lp_partext_amount[$key]["AMOUNT"];
$smarty->assign("lp_partext_amount_1",$lp_partext_amount[$key]["AMOUNT"]);
echo sprintf("%d",$lp_partext_amount[$key]["AMOUNT"]);
$ball=$lp_partext_amount[$key]["AMOUNT"];
$smarty->assign("lp_partext_amount_rank_1",$rank);
}
}
echo "</TD>";
//法律主提案通過量
$sql="SELECT lpm.leg_org,count(*) AS AMOUNT FROM law_process lp";
$sql.=" LEFT JOIN lp_process lpp_1 ON lpp_1.lp_sno=lp.sno";
$sql.=" LEFT JOIN lp_master lpm ON lpm.lp_sno=lp.sno AND lpm.lpm_order=1";
$sql.=" WHERE lp.lp_section='{$qry_sect}' AND lpm.lpm_type='2'";
$sql.=" AND trim(lpp_1.lpp_process)='三讀' AND lpp_1.lpp_final LIKE '%完成三讀%'";
$sql.=" AND lpp_1.`sno` = ";
$sql.=" (";
$sql.=" SELECT sno FROM lp_process lpp_2 WHERE lpp_2.lp_sno=lp.sno";
$sql.=" ORDER BY lpp_2.lpp_date DESC LIMIT 1";
$sql.=" )";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" AND lp.lp_session='{$qry_sess}'";
$sql.=" GROUP BY lpm.leg_org";
$sql.=" ORDER BY AMOUNT DESC";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$lp_amount_pass = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $lp_amount_pass )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
$smarty->assign("lp_amount_pass_1","0");
$smarty->assign("lp_amount_pass_2","0");
$smarty->assign("lp_amount_pass_rank_1","-");
$smarty->assign("lp_amount_pass_rank_2","-");
$rank=0;
$before_value="";
$lp_amount_pass_1=0;
$lp_amount_pass_2=0;
echo "<TD>";
foreach ($lp_amount_pass as $key => $value) {
if ($lp_amount_pass[$key]["AMOUNT"]!=$before_value)
{
$before_value=$lp_amount_pass[$key]["AMOUNT"];
$rank++;
}
if ($lp_amount_pass[$key]["leg_org"]==$qry_id_1)
{
$lp_amount_pass_1=$lp_amount_pass[$key]["AMOUNT"];
$smarty->assign("lp_amount_pass_1",$lp_amount_pass[$key]["AMOUNT"]);
echo sprintf("%d",$lp_amount_pass[$key]["AMOUNT"]);
$smarty->assign("lp_amount_pass_rank_1",$rank);
}
}
echo "</TD>";
//法律主提案通過率
echo "<TD>";
if ($lp_amount_1 > 0){
echo sprintf("%d%",ceil(100*($lp_amount_pass_1/$lp_amount_1)));
$smarty->assign("lp_amount_pass_rate_1",sprintf("%d",ceil(100*($lp_amount_pass_1/$lp_amount_1))));
}else{
echo "0%";
$smarty->assign("lp_amount_pass_rate_1",0);
}
echo "</TD>";
echo "<TD>";
//最常和誰提案
$sql="SELECT * FROM `legislator_co_process`";
$sql.=" WHERE (leg_sno='{$qry_id_1}')";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$leg_co_process = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $leg_co_process )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
foreach ($leg_co_process as $key => $value) {
if ($leg_co_process[$key]["leg_sno"]==$qry_id_1)
{
//取得立委資料
unset($leg_tmp);
unset($co_leg);
unset($fld_name);
unset($fld_val);
$fld_name[0] = "sno";
$fld_val[0]['value1'] = $leg_co_process[$key]["lcp_1"];
$leg_tmp=GetData("legislator",$fld_name,$fld_val);
if (trim($leg_tmp[0]["cname"]))
$co_leg[]=$leg_tmp[0]["cname"];
unset($fld_name);
unset($fld_val);
$fld_name[0] = "sno";
$fld_val[0]['value1'] = $leg_co_process[$key]["lcp_2"];
$leg_tmp=GetData("legislator",$fld_name,$fld_val);
if (trim($leg_tmp[0]["cname"]))
$co_leg[]=$leg_tmp[0]["cname"];
unset($fld_name);
unset($fld_val);
$fld_name[0] = "sno";
$fld_val[0]['value1'] = $leg_co_process[$key]["lcp_3"];
$leg_tmp=GetData("legislator",$fld_name,$fld_val);
if (trim($leg_tmp[0]["cname"])){
$co_leg[]=$leg_tmp[0]["cname"];
}
$co_leg=implode(",", $co_leg);
$smarty->assign("leg_co_process_1",$co_leg);
}
echo $co_leg;
}
echo "</TD>";
/*
echo "<TD>";
//書面質詢總次數
$sql="SELECT leg_sno,count(*) AS AMOUNT FROM question";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" WHERE que_m_file LIKE '".LeftZero($qry_sect,"0",2)."屆".LeftZero($qry_sess,"0",2)."期%' AND que_type='2'";
else
$sql.=" WHERE que_m_file LIKE '".LeftZero($qry_sect,"0",2)."屆%' AND que_type='2'";
//$sql.=" AND (leg_sno='{$qry_id_1}' OR leg_sno='{$_GET["qry_id_2"]}')";
$sql.=" GROUP BY leg_sno";
$sql.=" ORDER BY AMOUNT DESC";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$question_book = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $question_book )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
$smarty->assign("question_book_1","0");
$smarty->assign("question_book_2","0");
$smarty->assign("question_book_rank_1","-");
$smarty->assign("question_book_rank_2","-");
$rank=0;
$before_value="";
foreach ($question_book as $key => $value) {
if ($question_book[$key]["AMOUNT"]!=$before_value)
{
$rank++;
$before_value=$question_book[$key]["AMOUNT"];
}
if ($question_book[$key]["leg_sno"]==$qry_id_1)
{
$smarty->assign("question_book_1",$question_book[$key]["AMOUNT"]);
$smarty->assign("question_book_rank_1",$rank);
}
if ($question_book[$key]["leg_sno"]==$_GET["qry_id_2"])
{
$smarty->assign("question_book_2",$question_book[$key]["AMOUNT"]);
$smarty->assign("question_book_rank_2",$rank);
}
}
echo "</TD>";
*/
echo "<TD>";
//書面質詢主題分佈
$sql="SELECT leg_sno,que_data_subject FROM question";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" WHERE que_m_file LIKE '".LeftZero($qry_sect,"0",2)."屆".LeftZero($qry_sess,"0",2)."期%' AND que_type='2'";
else
$sql.=" WHERE que_m_file LIKE '".LeftZero($qry_sect,"0",2)."屆%' AND que_type='2'";
$sql.=" AND (leg_sno='{$qry_id_1}' OR leg_sno='{$_GET["qry_id_2"]}')";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$question_book_title = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $question_book_title )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
unset($question_book_title_ary);
foreach ($question_book_title as $key => $value) {
if ($question_book_title[$key]["leg_sno"]==$qry_id_1)
{
$tmp=explode(";", $question_book_title[$key]["que_data_subject"]);
foreach ($tmp as $key2 => $value2) {
$question_book_title_ary[1][]=trim($value2);
}
}
if ($question_book_title[$key]["leg_sno"]==$_GET["qry_id_2"])
{
$tmp=explode(";", $question_book_title[$key]["que_data_subject"]);
foreach ($tmp as $key2 => $value2) {
$question_book_title_ary[2][]="<a href='part2_6_2.php?qry_id={$legislator_2["sno"]}&qry_name={$legislator_2["cname"]}&op=1&qry_subject=".trim($value2)."' target='_blank'>".trim($value2)."</a>";
}
}
}
$question_book_title_ary[1]=array_unique($question_book_title_ary[1]);
$question_book_title_ary[2]=array_unique($question_book_title_ary[2]);
foreach ($question_book_title_ary[1] as $key => $value) {
echo $value." ";
}
$smarty->assign("question_book_title_1",implode(";", $question_book_title_ary[1]));
$smarty->assign("question_book_title_2",implode(";", $question_book_title_ary[2]));
echo "</TD>";
//口頭質詢筆數
echo "<TD>";
$sql="SELECT leg_sno,count(*) AS AMOUNT FROM legiscare";
$sql.=" WHERE 1";
if ($qry_sess<>"0" && $qry_sess<>"-" )
{
switch ($qry_sess) {
case '1':
$sql.=" AND lc_date >= '2012-2-24' AND lc_date <= '2012-7-26'";
break;
case '2':
$sql.=" AND lc_date >= '2012-9-18' AND lc_date <= '2013-1-15'";
break;
case '3':
$sql.=" AND lc_date >= '2013-2-26' AND lc_date <= '2013-8-6'";
break;
}
}
$sql.=" GROUP BY leg_sno";
$sql.=" ORDER BY AMOUNT DESC";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$legiscare = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $legiscare )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
$smarty->assign("legiscare_1","0");
$smarty->assign("legiscare_2","0");
$smarty->assign("legiscare_rank_1","-");
$smarty->assign("legiscare_rank_2","-");
$rank=0;
$before_value="";
foreach ($legiscare as $key => $value) {
if ($legiscare[$key]["AMOUNT"]!=$before_value)
{
$rank++;
$before_value=$legiscare[$key]["AMOUNT"];
}
if ($legiscare[$key]["leg_sno"]==$qry_id_1)
{
$smarty->assign("legiscare_1",$legiscare[$key]["AMOUNT"]);
echo $legiscare[$key]["AMOUNT"];
$smarty->assign("legiscare_rank_1",$rank);
}
}
echo "</TD>";
echo "<TD>";
//所屬委員會口頭質詢次數
$sql2="SELECT leg_sect,leg_session,committee FROM legislator_committee";
$sql2.=" LEFT JOIN committee ON committee.sno=legislator_committee.committee_sno";
$sql2.=" WHERE leg_sno ='{$qry_id_1}'";
$sql2.=" AND leg_sect = '{$qry_sect}'";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql2.=" AND leg_session = '{$qry_sess}'";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$committee_1 = $db->getAll ( $sql2 ); //將抓取的資料組成陣列
// $committee_1 = $committee_1[0]["committee"];
// $committee_1 = mb_substr($committee_1, 0,2);
$sql2="SELECT leg_sect,leg_session,committee FROM legislator_committee";
$sql2.=" LEFT JOIN committee ON committee.sno=legislator_committee.committee_sno";
$sql2.=" WHERE leg_sno ='{$_GET["qry_id_2"]}'";
$sql2.=" AND leg_sect = '{$qry_sect}'";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql2.=" AND leg_session = '{$qry_sess}'";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$committee_2 = $db->getAll ( $sql2 ); //將抓取的資料組成陣列
// $committee_2 = $committee_2[0]["committee"];
// $committee_2 = mb_substr($committee_2, 0,2);
$smarty->assign("legiscare_committe_1","0");
$smarty->assign("legiscare_committe_2","0");
$smarty->assign("legiscare_committe_rank_1","-");
$smarty->assign("legiscare_committe_rank_2","-");
$sql="SELECT leg_sno,count(*) AS AMOUNT FROM legiscare";
$sql.=" WHERE lc_section='{$qry_sect}'";
$sql.=" AND lc_type='2'";
$first=true;
foreach ($committee_1 as $value) {
if ($first)
{
$sql.=" AND (";
$first=false;
}
$tmp=mb_substr($value["committee"], 0,2);
$sql.=" (lc_confname LIKE '%{$tmp}%' AND lc_section='{$value["leg_sect"]}' AND lc_session='{$value["leg_session"]}') OR";
}
if (!$first)
{
$sql=substr($sql, 0,strlen($sql)-3);
$sql.=" )";
}
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" AND lc_session='{$qry_sess}' ";
$sql.=" GROUP BY leg_sno";
$sql.=" ORDER BY AMOUNT DESC";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$legiscare_committe = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $legiscare_committe )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
$rank=0;
$before_value="";
foreach ($legiscare_committe as $key => $value) {
if ($legiscare_committe[$key]["AMOUNT"]!=$before_value)
{
$rank++;
$before_value=$legiscare_committe[$key]["AMOUNT"];
}
if ($legiscare_committe[$key]["leg_sno"]==$qry_id_1)
{
echo $legiscare_committe[$key]["AMOUNT"];
$smarty->assign("legiscare_committe_1",$legiscare_committe[$key]["AMOUNT"]);
$smarty->assign("legiscare_committe_rank_1",$rank);
}
}
echo "</TD>";
echo "<TD>";
//跨委員會發言次數
$smarty->assign("legiscare_no_committe_1","0");
$smarty->assign("legiscare_no_committe_2","0");
$smarty->assign("legiscare_no_committe_rank_1","-");
$smarty->assign("legiscare_no_committe_rank_2","-");
$sql="SELECT leg_sno,count(*) AS AMOUNT FROM legiscare";
$sql.=" WHERE lc_section='{$qry_sect}'";
$sql.=" AND lc_type='2'";
$first=true;
foreach ($committee_1 as $value) {
if ($first)
{
$sql.=" AND (";
$first=false;
}
$tmp=mb_substr($value["committee"], 0,2);
$sql.=" (lc_confname NOT LIKE '%{$tmp}%' AND lc_section='{$value["leg_sect"]}' AND lc_session='{$value["leg_session"]}') OR";
}
if (!$first)
{
$sql=substr($sql, 0,strlen($sql)-3);
$sql.=" )";
}
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" AND lc_session='{$qry_sess}' ";
$sql.=" GROUP BY leg_sno";
$sql.=" ORDER BY AMOUNT DESC";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$legiscare_no_committe = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $legiscare_no_committe )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
$rank=0;
$before_value="";
foreach ($legiscare_no_committe as $key => $value) {
if ($legiscare_no_committe[$key]["AMOUNT"]!=$before_value)
{
$rank++;
$before_value=$legiscare_no_committe[$key]["AMOUNT"];
}
if ($legiscare_no_committe[$key]["leg_sno"]==$qry_id_1)
{
echo $legiscare_no_committe[$key]["AMOUNT"];
$smarty->assign("legiscare_no_committe_1",$legiscare_no_committe[$key]["AMOUNT"]);
$smarty->assign("legiscare_no_committe_rank_1",$rank);
}
}
echo "</TD>";
//法律全文主提案通過量
$sql="SELECT lpm.leg_org,count(*) AS AMOUNT FROM law_process lp";
$sql.=" LEFT JOIN lp_process lpp_1 ON lpp_1.lp_sno=lp.sno";
$sql.=" LEFT JOIN lp_master lpm ON lpm.lp_sno=lp.sno AND lpm.lpm_order=1";
$sql.=" WHERE lp.lp_section='{$qry_sect}' AND lpm.lpm_type='2'";
$sql.=" AND trim(lpp_1.lpp_process)='三讀' AND lpp_1.lpp_final LIKE '%完成三讀%'";
$sql.=" AND (lp_name NOT LIKE '%部分條文草案%' AND lp_name NOT LIKE '%條文草案%' AND lp_name NOT LIKE '%條文修正草案%' AND lp_name NOT LIKE '%法修正草案%' AND lp_name NOT LIKE '%條例修正草案%')";
$sql.=" AND lpp_1.`sno` = ";
$sql.=" (";
$sql.=" SELECT sno FROM lp_process lpp_2 WHERE lpp_2.lp_sno=lp.sno";
$sql.=" ORDER BY lpp_2.lpp_date DESC LIMIT 1";
$sql.=" )";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" AND lp.lp_session='{$qry_sess}'";
$sql.=" GROUP BY lpm.leg_org";
$sql.=" ORDER BY AMOUNT DESC";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$lp_fulltext_amount = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $lp_fulltext_amount )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
$smarty->assign("lp_fulltext_amount_1","0");
$smarty->assign("lp_fulltext_amount_2","0");
$smarty->assign("lp_fulltext_amount_rank_1","-");
$smarty->assign("lp_fulltext_amount_rank_2","-");
$rank=0;
$before_value="";
$lp_fulltext_amount_1=0;
$lp_fulltext_amount_2=0;
echo "<TD>";
$a=0;
$flag=0;
foreach ($lp_fulltext_amount as $key => $value) {
if ($lp_fulltext_amount[$key]["AMOUNT"]!=$before_value)
{
$rank++;
$before_value=$lp_fulltext_amount[$key]["AMOUNT"];
}
if ($lp_fulltext_amount[$key]["leg_org"]==$qry_id_1)
{
$lp_fulltext_amount_1=$lp_fulltext_amount[$key]["AMOUNT"];
$smarty->assign("lp_fulltext_amount_1",$lp_fulltext_amount[$key]["AMOUNT"]);
if($lp_fulltext_amount[$key]["AMOUNT"]){
echo sprintf("%d",$lp_fulltext_amount[$key]["AMOUNT"]);
$flag=1;
$a=$lp_fulltext_amount[$key]["AMOUNT"];
}else{
//echo "0";
}
$smarty->assign("lp_fulltext_amount_rank_1",$rank);
}else{
//echo 0;
}
}
if($flag==0){echo "0";}
echo "</TD>";
echo "<TD>";
$sql="SELECT lpm.leg_org,count(*) AS AMOUNT FROM law_process lp";
$sql.=" LEFT JOIN lp_process lpp_1 ON lpp_1.lp_sno=lp.sno";
$sql.=" LEFT JOIN lp_master lpm ON lpm.lp_sno=lp.sno AND lpm.lpm_order=1";
$sql.=" WHERE lp.lp_section='{$qry_sect}' AND lpm.lpm_type='2'";
$sql.=" AND trim(lpp_1.lpp_process)='三讀' AND lpp_1.lpp_final LIKE '%完成三讀%'";
//$sql.=" AND (lp_name NOT LIKE '%部分條文草案%' AND lp_name NOT LIKE '%條文草案%' AND lp_name NOT LIKE '%條文修正草案%' AND lp_name NOT LIKE '%法修正草案%' AND lp_name NOT LIKE '%條例修正草案%')";
$sql.=" AND lpp_1.`sno` = ";
$sql.=" (";
$sql.=" SELECT sno FROM lp_process lpp_2 WHERE lpp_2.lp_sno=lp.sno";
$sql.=" ORDER BY lpp_2.lpp_date DESC LIMIT 1";
$sql.=" )";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" AND lp.lp_session='{$qry_sess}'";
$sql.=" GROUP BY lpm.leg_org";
$sql.=" ORDER BY AMOUNT DESC";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$lp_fulltext_amount = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $lp_fulltext_amount )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
$smarty->assign("lp_fulltext_amount_1","0");
$smarty->assign("lp_fulltext_amount_2","0");
$smarty->assign("lp_fulltext_amount_rank_1","-");
$smarty->assign("lp_fulltext_amount_rank_2","-");
$rank=0;
$before_value="";
$lp_fulltext_amount_1=0;
$lp_fulltext_amount_2=0;
$flag=0;
$aall=0;
foreach ($lp_fulltext_amount as $key => $value) {
if ($lp_fulltext_amount[$key]["AMOUNT"]!=$before_value)
{
$rank++;
$before_value=$lp_fulltext_amount[$key]["AMOUNT"];
}
if ($lp_fulltext_amount[$key]["leg_org"]==$qry_id_1)
{
$lp_fulltext_amount_1=$lp_fulltext_amount[$key]["AMOUNT"];
$smarty->assign("lp_fulltext_amount_1",$lp_fulltext_amount[$key]["AMOUNT"]);
if($lp_fulltext_amount[$key]["AMOUNT"]){
//echo sprintf("%d",$lp_fulltext_amount[$key]["AMOUNT"]);
$flag=1;
$aall=$lp_fulltext_amount[$key]["AMOUNT"];
}else{
//echo "0";
}
$smarty->assign("lp_fulltext_amount_rank_1",$rank);
}else{
//echo 0;
}
}
if($flag==0){$aall=0;}
if($aall>0){
//echo sprintf("%d% %d / %d",100*$a/$aall,$a,$aall);
//echo sprintf("%d%",100*$a/$aall);
echo sprintf("%d%</TD><TD>(%d/%d)",100*$a/$aall,$a,$aall);
}else{
echo sprintf("%d%</TD><TD>(%d/%d)",100*$a/$aall,$a,$aall);
//echo sprintf("%d% %d / %d",0,$a,$aall);
//echo "-";
}
echo "</TD>";
//法律部分條文修正通過量
$sql="SELECT count(*) AS AMOUNT FROM law_process lp";
$sql.=" LEFT JOIN lp_process lpp_1 ON lpp_1.lp_sno=lp.sno";
$sql.=" LEFT JOIN lp_master lpm ON lpm.lp_sno=lp.sno AND lpm.lpm_order=1";
$sql.=" WHERE lp.lp_section='{$qry_sect}' AND lpm.lpm_type='2'";
$sql.=" AND trim(lpp_1.lpp_process)='三讀' AND lpp_1.lpp_final LIKE '%完成三讀%'";
$sql.=" AND lpp_1.`sno` = ";
$sql.=" (";
$sql.=" SELECT sno FROM lp_process lpp_2 WHERE lpp_2.lp_sno=lp.sno";
$sql.=" ORDER BY lpp_2.lpp_date DESC LIMIT 1";
$sql.=" )";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" AND lp.lp_session='{$qry_sess}'";
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$lp_amount_pass_all = $db->getAll ( $sql ); //將抓取的資料組成陣列
$lp_amount_pass_all = $lp_amount_pass_all[0]["AMOUNT"];
$smarty->assign("lp_amount_pass_all",$lp_amount_pass_all);
//立委提案量
$sql="SELECT lpm.leg_org,count(*) AS AMOUNT FROM law_process lp";
$sql.=" LEFT JOIN lp_process lpp_1 ON lpp_1.lp_sno=lp.sno";
$sql.=" LEFT JOIN lp_master lpm ON lpm.lp_sno=lp.sno AND lpm.lpm_order=1";
$sql.=" WHERE lp.lp_section='{$qry_sect}' AND lpm.lpm_type='2'";
$sql.=" AND trim(lpp_1.lpp_process)='三讀' AND lpp_1.lpp_final LIKE '%完成三讀%'";
$sql.=" AND (lp_name LIKE '%部分條文草案%' OR lp_name LIKE '%條文草案%' OR lp_name LIKE '%條文修正草案%' OR lp_name LIKE '%法修正草案%' OR lp_name LIKE '%條例修正草案%')";
$sql.=" AND lpp_1.`sno` = ";
$sql.=" (";
$sql.=" SELECT sno FROM lp_process lpp_2 WHERE lpp_2.lp_sno=lp.sno";
$sql.=" ORDER BY lpp_2.lpp_date DESC LIMIT 1";
$sql.=" )";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" AND lp.lp_session='{$qry_sess}'";
$sql.=" GROUP BY lpm.leg_org";
$sql.=" ORDER BY AMOUNT DESC";
/* $sql="SELECT lp_master.leg_org,count(*) AS AMOUNT FROM law_process";
$sql.=" LEFT JOIN lp_master ON lp_master.lp_sno=law_process.sno AND lp_master.lpm_order=1";
$sql.=" LEFT JOIN lp_process lpp_1 ON lpp_1.lp_sno=law_process.sno";
$sql.=" WHERE lp_section='{$qry_sect}' AND lp_master.lpm_type='2'";
$sql.=" AND trim(lpp_1.lpp_process)='三讀' AND lpp_1.lpp_final LIKE '%完成三讀%'";
$sql.=" AND (lp_name LIKE '%部分條文草案%' OR lp_name LIKE '%條文草案%' OR lp_name LIKE '%條文修正草案%' OR lp_name LIKE '%法修正草案%' OR lp_name LIKE '%條例修正草案%')";
if ($qry_sess<>"0" && $qry_sess<>"-" )
$sql.=" AND lp_session='{$qry_sess}'";
$sql.=" GROUP BY lp_master.leg_org";
$sql.=" ORDER BY AMOUNT DESC";
*/
$db->setFetchMode ( DB_FETCHMODE_ASSOC ); //以資料表欄位名稱當作資料陣列的key
$lp_partext_amount = $db->getAll ( $sql ); //將抓取的資料組成陣列
if (PEAR::isError ( $lp_partext_amount )) {
die ( "系統操作錯誤,請與管理人員連絡" );
}
$smarty->assign("lp_partext_amount_1","0");
$smarty->assign("lp_partext_amount_2","0");
$smarty->assign("lp_partext_amount_rank_1","-");
$smarty->assign("lp_partext_amount_rank_2","-");
$rank=0;
$before_value="";
$lp_partext_amount_1=0;
$lp_partext_amount_2=0;
$b=0;
echo "<TD>";
$flag=0;
foreach ($lp_partext_amount as $key => $value) {
if ($lp_partext_amount[$key]["AMOUNT"]!=$before_value)
{
$rank++;
$before_value=$lp_partext_amount[$key]["AMOUNT"];
}
if ($lp_partext_amount[$key]["leg_org"]==$qry_id_1)
{
$lp_partext_amount_1=$lp_partext_amount[$key]["AMOUNT"];
$smarty->assign("lp_partext_amount_1",$lp_partext_amount[$key]["AMOUNT"]);
if($lp_partext_amount[$key]["AMOUNT"]){
echo sprintf("%d",$lp_partext_amount[$key]["AMOUNT"]);
$b=$lp_partext_amount[$key]["AMOUNT"];
$flag=1;
}else{
//echo "0";
}
$smarty->assign("lp_partext_amount_rank_1",$rank);
}
}
if($flag==0){echo "0";$b=0;}
echo "</TD>";
echo "<TD>";
if($aall>0){
//echo sprintf("%d% %d / %d",100*$a/$aall,$a,$aall);
//echo sprintf("%d%",100*$b/$aall);
echo sprintf("%d%</TD><TD>(%d/%d)",100*$b/$aall,$b,$aall);
}else{
echo sprintf("%d%</TD><TD>(%d/%d)",0,$b,$aall);
//echo "-";
}
echo "</TD>";
echo "</TR>";
}
echo "</Table>";
?> �� C �� C�� ^�" ��
��
! "1AQaRq��2WXb������
#BSr���������39Vsw���(7CGTYcg����$%':u����&4568vx�UZty��)E����������� �� V
!1AQa"bq��2BRS�����c���34Cr����#TUV���s�%67F��$&�D�� ? �s�w{?w䧜��~��]�݃�� X����V�����;�[��j�s����%<�w��p�J�h�9O��]^��;`�v}w+w��]s�w{?w䧜��~��]�)���ߴ�lnϠ��n����y��g����������+��`�?�=u{������ܭ�ӵu�9����?��s����%v4L��Ǯ�~ҝ�y�>�����v���;�����S�w{?w�Ɖ��� X����S�7g�wr�{N��<�w��p�Jy��g������0r�����Jv�����V�iں���~��O9����?��&S�c�W�iN�<ݟA����;W\������)�;�����WcD���z���)����;�[��j�s����%<�w��p�J�h�9O��]^��;`�v}w+w��]s�w{?w䧜��~��]�)���ߴ�lnϠ��n����y��g����������+��`�?�=u{������ܭ�ӵu�9����?��s����%v4L��Ǯ�~ҝ�y�>�����v���;�����S�w{?w�Ɖ��� X����S�7g�wr�{N��<�w��p�Jy��g������0r�����Jv�����V�iں���~��O9����?��&S�c�W�iN�<ݟA����;W\������)�;�����WcD���z���)����;�[��j�s����%<�w��p�J�h�9O��]^��;`�v}w+w��]s�w{?w䧜��~��]�)���ߴ�lnϠ��n����y��g����������+��`�?�=u{������ܭ�ӵu�9����?��s����%v4L��Ǯ�~ҝ�y�>�����v���;�����S�w{?w�Ɖ��� X����S�7g�wr�{N��<�w��p�Jy��g������0r�����Jv�����V�iں���~��O9����?��&S�c�W�iN�<ݟA����;W\������+Q'p �@�%�"��7��ؑFS�c�W�iLb#���:ur�{J��Yؑ���^h��cp�\\y�g9A��n�a@aKA��Zl�,A�(5�#��$<:�{����
�h�B�p�. �m�[6�v������AK1
h.
�ko� ��ݼ��۹����� �\%�"��htA�$ $�Nd��E���w��>���I.
5� L�A�1/t�i��7��A��c}�< ��1��U[Q���,�@�� ��xy�;�È�h ���3�ͨ���Kć
y �n@�Gw$�
�����o�Px;�v��h���=����m��m��Z/�k$_P���Z���J����M���Ԉ�ðmR8k�"$�E0�ꔜ������;V�^�{�����8@�r�F��>�]{�H�s�p���
�g��Q4�*�-%��R