5-2 /chart.php

<?php
/**
 * Phone Book module
 *
 * You may not change or alter any portion of this comment or credits
 * of supporting developers from this source code or any supporting source code
 * which is considered copyrighted (c) material of the original comment or credit authors.
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 *
 * @copyright  The XOOPS Project http://sourceforge.net/projects/xoops/
 * @license    http://www.fsf.org/copyleft/gpl.html GNU public license
 * @package    Phone Book
 * @since      2.5
 * @author     tad
 * @version    $Id $
 **/

/*-----------引入檔案區--------------*/
include "header.php";
$xoopsOption['template_main'] = set_bootstrap('phone_book_chart_b3.html');
include_once XOOPS_ROOT_PATH . "/header.php";
get_jquery(true);
/*-----------功能函數區--------------*/

//取得派圖資料
function get_pie_data(){
  global $xoopsDB;
  $sql="select b.cate_title, count(*) from `" . $xoopsDB->prefix("phone_book") . "` as a
  join `" . $xoopsDB->prefix("phone_book_cate") . "` as b
  on a.cate_sn=b.cate_sn
  group by a.cate_sn";
  $result = $xoopsDB->query($sql) or web_error($sql);
  while(list($cate_title, $count) = $xoopsDB->fetchRow($result)){
    $data[]="\n['{$cate_title}', {$count}]";
  }
  $all_data=implode(',',$data);
  return $all_data;
}


/*-----------執行動作判斷區----------*/
$pie_data=get_pie_data();
$xoopsTpl->assign('pie_data',$pie_data);

/*-----------秀出結果區--------------*/

$xoopsTpl->assign("toolbar", toolbar_bootstrap($interface_menu));
$xoopsTpl->assign("isAdmin", $isAdmin);
include_once XOOPS_ROOT_PATH . '/footer.php';