javascript结合php生成统计图（饼形，折线，柱状）

来源：互联网发布：win10安装外部软件编辑：程序博客网时间：2024/06/15 04:08

<?
require_once("global.php");
$objDb_Sql1=new Db_Sql();
$objDb_Sql1->connect($cfg_mysql_database);
?>
<script language="javascript" type="text/javascript">
<!--

//=============调用方法=====================
function getdata_and_name3(data,name){
var dataArray = data.split(",");
var nameArray = name.split(",");
    var total1= new Array(nameArray,dataArray);
    //table3(total1,100,100,250,250,"A");
    table3(total1,400,590,250,250,"B");
}

//-->
</script>

function getdata_and_name1(data,name){
var dataArray =data.split(",");
var nameArray =name.split(",");
var total =new Array(dataArray,nameArray);
table1(total,70,350,20,30,800,100,"A");
}

switch (table_type)
{
case "A":

var table_space = (all_width-table_width*total_no)/total_no;
document.write("");

for(var i=0;i<=all_height-1;i+= all_height/5)
{
document.write("");
document.write("");
document.write("");
document.write("");
temp4 = temp4-temp3/5;
}
for(var i=0;i<total_no;i++)
{

var temp_space = table_x + left_width + table_space / 2 + table_space * i + table_width * i;
document.write("<v:rect id='_x0000_s1025' alt='' style='position:absolute;left:");
document.write(temp_space);
document.write("px;top:");
document.write(table_y + all_height * (1 - (total[0][i] / temp3)));
document.write("px;width:" + table_width + "px;height:" + all_height * (total[0][i] / temp3) + "px;z-index:1' fillcolor='" + tb_color[1][i] + "'>");
document.write("<v:fill color2='" + tb_color[0][i] + "' rotate='t' type='gradient'/>")
document.write("<o:extrusion v:ext='view' backdepth='" + thickness + "pt' color='" + tb_color[1][i] + "' on='t'/>");
document.write("</v:rect>");
document.write("<v:shape id='_x0000_s1025' type='#_x0000_t202' alt='' style='position:absolute;left:" + temp_space + "px;top:" + (table_y+all_height*(1-(total[0][i]/temp3))-table_width) + "px;width:" + (table_space+15) + "px;height:18px;z-index:1'>");
document.write("<v:textbox inset='0px,0px,0px,0px'><table cellspacing='3' cellpadding='0' width='100%' height='100%'><tr><td align='center'>" + total[0][i] + "</td></tr></table></v:textbox></v:shape>");
document.write("<v:shape id='_x0000_s1025' type='#_x0000_t202' alt='' style='position:absolute;left:" + (temp_space-table_space/2) + "px;top:" + (table_y+all_height+1) + "px;width:" + (table_space+table_width) + "px;height:18px;z-index:1'>");
document.write("<v:textbox inset='0px,0px,0px,0px'><table cellspacing='3' cellpadding='0' width='100%' height='100%'><tr><td align='center'>" + total[1][i] + "</td></tr></table></v:textbox></v:shape>");
}

break;
case "B":
var table_space = (all_height - table_width * total_no) / total_no;
document.write("");
for(var i=0;i<=all_width-1;i +=all_width/5)
{
document.write("");
document.write("");
document.write("");
document.write("");
temp4 = temp4 - temp3 / 5;
}

for(var i=0;i<total_no;i++)
{
var temp_space = table_space/2 + table_space * i + table_width * i;
document.write("<v:rect id='_x0000_s1025' alt='' style='position:absolute;left:");
document.write(table_x + left_width);
document.write("px;top:");
document.write(table_y + temp_space);
document.write("px;width:" + all_width * (total[0][i] / temp3) + "px;height:" + table_width + "px;z-index:1' fillcolor='" + tb_color[1][i] + "'>");
document.write("<v:fill color2='" + tb_color[0][i] + "' rotate='t' angle='-90' focus='100%' type='gradient'/>");
document.write("<o:extrusion v:ext='view' backdepth='" + thickness + "pt' color='" + tb_color[1][i] + "' on='t'/>");
document.write("</v:rect>");
document.write("<v:shape id='_x0000_s1025' type='#_x0000_t202' alt='' style='position:absolute;left:" + (table_x + left_width + all_width * (total[0][i] / temp3) + thickness / 2) + "px;top:" + (table_y + temp_space) + "px;width:" + (table_space + 15) + "px;height:18px;z-index:1'>");
document.write("<v:textbox inset='0px,0px,0px,0px'><table cellspacing='3' cellpadding='0' width='100%' height='100%'><tr><td align='center'>" + total[0][i] + "</td></tr></table></v:textbox></v:shape>");

document.write("<v:shape id='_x0000_s1025' type='#_x0000_t202' alt='' style='position:absolute;left:" + table_x + "px;top:" + (table_y + temp_space) + "px;width:" + left_width + "px;height:18px;z-index:1'>");
document.write("<v:textbox inset='0px,0px,0px,0px'><table cellspacing='3' cellpadding='0' width='100%' height='100%'><tr><td align='right'>" + total[1][i] + "</td></tr></table></v:textbox></v:shape>");
}

}
}
</script>

if($_GET["c"] = "d" && !empty($_GET["s"]) && !empty($_GET["e"]))
{
$strStartYear = substr($_GET["s"],0,4);
$strEndYear = substr($_GET["e"],0,4);
$strStartMonth = substr($_GET["s"],4);
$strEndMonth = substr($_GET["e"],4);
}
if($strStartYear.$strStartMonth > date("Ym") || $strStartYear.$strStartMonth > $strEndYear.$strEndMonth)
{
echo '<div style="color:red;">对不起，您选择的开始年月或结束年月不合理，请重新选择</div>';
$strStartYear = "2006";
$strEndYear = date("Y");
$strStartMonth = "12";
$strEndMonth = date("m");
}
?>
<div style="position:absolute;left:310px;top:180px;font-size:16px;color:red; text-align:center;">
<select size="1" name="drop_year1_start" id="drop_year1_start">
<?
for($year = 2006; $year <= date("Y"); $year++)
{
echo '<option value="'.$year.'"';
if($year == $strStartYear)
{
  echo " selected";
}
echo '>'.$year.'</option>';
}
?>
</select>年
<select size="1" name="drop_month1_start" id="drop_month1_start">
<?
for($month = 1; $month <= 12; $month++)
{
$strMonthValue = $month < 10 ? "0".$month : $month;
echo '<option value="'.$strMonthValue.'"';
if($month == $strStartMonth)
{
  echo " selected";
}
echo '>'.$month.'</option>';
}
?>
</select>月 至 
<select size="1" name="drop_year1_end" id="drop_year1_end">
<?
for($year = 2006; $year <= date("Y"); $year++)
{
echo '<option value="'.$year.'"';
if($year == $strEndYear)
{
  echo " selected";
}
echo '>'.$year.'</option>';
}
?>
</select>年
<select size="1" name="drop_month1_end" id="drop_month1_end">
<?
for($month = 1; $month <= 12; $month++)
{
$strMonthValue = $month < 10 ? "0".$month : $month;
echo '<option value="'.$strMonthValue.'"';
if($month == $strEndMonth)
{
  echo " selected";
}
echo '>'.$month.'</option>';
}
?>
</select>月 服务统计  <input type="button" onclick="viewDepartment()" value="查看" />
</div>
<br />

<div style="font-size:16px;color:red;text-align:center;position:absolute;left:430px;top:930px;">
<select size="1" name="drop_year3" id="drop_year3">
<?
$strViewYear = date("Y");
if(!empty($_GET["y"]))
{
$strViewYear = $_GET["y"];
}
for($year = 2006; $year <= date("Y"); $year++)
{
echo '<option value="'.$year.'"';
if($year == $strViewYear)
{
  echo " selected";
}
echo '>'.$year.'</option>';
}
?>
</select>年年度统计  <input type="button" onclick="viewYear()" value="查看" />
</div>

<?
$dataArray="";
$nameArray="";

$arrDepartmentIDName = MakeNameValueArray($cfg_mysql_database,$tbl_department,"id","name");
$strQuery = "SELECT * FROM ".$tbl_department." ORDER BY id DESC LIMIT 0,1";
$objDb_Sql1->query($strQuery);
$objDb_Sql1->next_record();
$intMaxDepartmentId = $objDb_Sql1->f("id");
for($intCount = 1; $intCount <= $intMaxDepartmentId; $intCount++)
{
$strQuery = "SELECT COUNT(*) FROM ".$tbl_baoxiu." WHERE request_department_id='".$intCount."' AND add_time>='".$strStartYear."-".$strStartMonth."-01 00:00:00' AND add_time<='".$strEndYear."-".$strEndMonth."-31 23:59:59'";
$objDb_Sql1->query($strQuery);
$objDb_Sql1->next_record();
if($objDb_Sql1->f(0) != 0)
{
$dataArray .= $objDb_Sql1->f(0).",";
$nameArray .= $arrDepartmentIDName[$intCount].",";
}
}
$dataArray = substr($dataArray,0,strlen($dataArray)-1);
$nameArray = substr($nameArray,0,strlen($nameArray)-1);
echo "<script>getdata_and_name1('".$dataArray."','".$nameArray."');</script>";

?>

<?
$dataArray="";
$nameArray="";
$arrTroubleIDName = MakeNameValueArray($cfg_mysql_database,$tbl_trouble,"id","name");
$strQuery = "SELECT * FROM ".$tbl_department." ORDER BY id DESC LIMIT 0,1";
$objDb_Sql1->query($strQuery);
$objDb_Sql1->next_record();
$intMaxTroubleId = $objDb_Sql1->f("id");

for($intCount = 1; $intCount <= $intMaxTroubleId; $intCount++)
{
$strQuery = "SELECT COUNT(*) FROM ".$tbl_baoxiu." WHERE trouble_code like '%".$intCount.",%' AND add_time>='".$strStartYear."-".$strStartMonth."-01 00:00:00' AND add_time<='".$strEndYear."-".$strEndMonth."-31 23:59:59'";
$objDb_Sql1->query($strQuery);
$objDb_Sql1->next_record();
if($objDb_Sql1->f(0) != 0)
{
$dataArray .= $objDb_Sql1->f(0).",";
$nameArray .= $arrTroubleIDName[$intCount].",";
}
}
$strQuery = "SELECT COUNT(*) FROM ".$tbl_baoxiu." WHERE has_other_trouble='1'";
$objDb_Sql1->query($strQuery);
$objDb_Sql1->next_record();

$dataArray .= $objDb_Sql1->f(0).",";
$nameArray .= "其它,";
$dataArray = substr($dataArray,0,strlen($dataArray)-1);
$nameArray = substr($nameArray,0,strlen($nameArray)-1);
echo "<script>getdata_and_name3('".$dataArray."','".$nameArray."');</script>";
?>

<?
$dataArray = "";
$nameArray = "";
for($intCount = 1; $intCount <= 12; $intCount++)
{
$strMonth = $intCount;
if($intCount < 10)
{
  $strMonth = "0".$intCount;
}
$strQuery = "SELECT COUNT(*) FROM ".$tbl_baoxiu." WHERE id like '".$strViewYear.$strMonth."%'";
$objDb_Sql1->query($strQuery);
$objDb_Sql1->next_record();
if($objDb_Sql1->f(0) != 0)
{
  $dataArray .= $objDb_Sql1->f(0).",";
  $nameArray .= $intCount."月,";
}
}
$dataArray =$strViewYear.",".$dataArray;
$dataArray = substr($dataArray,0,strlen($dataArray)-1);
$nameArray = substr($nameArray,0,strlen($nameArray)-1);
$dataArray="2006,12,12,1,5,7,24,40,10,25,45,16,19";
$nameArray="1月,2月,3月,4月,5月,6月,7月,8月,9月,10月,11月,12月";
echo "<script>getdata_and_name2('".$dataArray."','".$nameArray."');</script>";

?>

<div style="position:absolute;left:470px;top:1220px;"><a href="index.php"> 返 回 首 页</a></div>
</body>
</html>