BODY { background: linear-gradient(top, #888, #eee); background: -moz-linear-gradient(top, #888, #eee); background: -webkit-linear-gradient(top, #888, #eee); } </style> </head> <?php if (isset($_SESSION['username'])) { $company_id = $_GET['id']; $classification = $_GET['class']; // 取所有資料 include 'db_controller_unit.php'; $obj1 = new db_controller_unit(); $dbn = $obj1->connect_DB(); if (isset($company_id)) { $datatem = $dbn->query('SELECT * FROM `company_basic_information` WHERE `company_id` = "' . $company_id . '" '); $data_row = mysqli_fetch_row($datatem); } ?> <script type="text/javascript"> // 讀取Google API結束後執行loadVisual() loadAPI('http://www.google.com/jsapi?callback=loadVisual'); // Google API讀取繪圖所需Packages,並執行loadPage() function loadVisual() { google.load('visualization', '1', {'packages':['corechart'], "callback" : loadPage}); } // 依公司代號及名稱取得資料並開始繪圖
function sortData($datalist, $pageID) { // 不須整理直接回傳 if ($pageID === '興櫃' or $pageID === '公開發行' or $pageID === '中國') { return $datalist; } else { if ($pageID === '下市櫃') { // 下市櫃頁面加上危機發生年月 $obj1 = new db_controller_unit(); $dbn = $obj1->connect_DB(); for ($i = 0; $i < count($datalist); $i++) { $new_index = 0; for ($j = 0; $j < count($datalist[0]); $j++) { if ($i === 0) { if ($j === 1) { $new_datalist[$i][$new_index] = $datalist[$i][$j]; $new_datalist[$i][$new_index + 1] = "危機發生年/月"; $new_index = $new_index + 2; } else { $new_datalist[$i][$new_index] = $datalist[$i][$j]; $new_index = $new_index + 1; } } else { if ($j === 1) { $new_datalist[$i][$new_index] = $datalist[$i][$j]; $crisis_date = $dbn->query('SELECT * FROM `company_financial_crisis` WHERE `company_id` = "' . $datalist[$i][0] . '"'); if (!empty($crisis_date)) { $crisis_date_row = mysqli_fetch_row($crisis_date); if (!empty($crisis_date_row)) { $new_datalist[$i][$new_index + 1] = $crisis_date_row[1]; } else { $new_datalist[$i][$new_index + 1] = "NULL"; } } else { $new_datalist[$i][$new_index + 1] = "NULL"; } $new_index = $new_index + 2; } else { $new_datalist[$i][$new_index] = $datalist[$i][$j]; $new_index = $new_index + 1; } } } } return $new_datalist; } else { // 上市上櫃頁面加上三年預警率 for ($i = 0; $i < count($datalist); $i++) { $new_index = 0; for ($j = 0; $j < count($datalist[0]); $j++) { if ($i === 0) { if ($j === 1) { $new_datalist[$i][$new_index] = $datalist[$i][$j]; $new_datalist[$i][$new_index + 1] = "三年預警率"; $new_index = $new_index + 2; } else { $new_datalist[$i][$new_index] = $datalist[$i][$j]; $new_index = $new_index + 1; } } else { if ($j === 1) { $new_datalist[$i][$new_index] = $datalist[$i][$j]; $highrisk = 0; $value_at_risk_num = 0; for ($k = 1; $k < 13; $k++) { // $tem = explode( "%", $datalist[$i][$j+$k] ); /* * if ( $datalist[$i][$j+$k] != "-" ) * $value_at_risk_num++; */ if (strcasecmp($datalist[$i][$j + $k], "-")) { $value_at_risk_num++; } // if ( $tem[0] > 50.00 ) // $highrisk++; if ($this->checkValueatRisk($datalist[$i][$j + $k]) === 2) { $highrisk++; } } if ($value_at_risk_num) { $warining_rate = $highrisk / $value_at_risk_num * 100; } else { $warining_rate = 0; } $new_datalist[$i][$new_index + 1] = sprintf("%.0f", $warining_rate) . "% (" . $highrisk . '/' . $value_at_risk_num . ')'; $new_index = $new_index + 2; } else { $new_datalist[$i][$new_index] = $datalist[$i][$j]; $new_index = $new_index + 1; } } } } return $new_datalist; } } }