1.後台界面全面重寫，套入BootStrap界面連動選單
script
//---引入Js //-----------------------------------------------------------
OP
//連動選單
case "get_ugm_search_class_json":
$get_ugm_search_class_json[] = get_ugm_search_class_json($_GET['_value']);
echo json_encode($get_ugm_search_class_json);
exit;
# ------------------------------------------------------------------------
//選項
function get_ugm_search_class_json($kind_sn="0"){
global $xoopsDB;
$sql = "select * from ".$xoopsDB->prefix("ugm_search_class")." where `kind_sn`='{$kind_sn}' order by `sn`";
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());
//$opt[]="請選擇";
while(list($sn,$kind_sn,$title)=$xoopsDB->fetchRow($result)){
$opt[$sn]=$title;
}
return $opt;
}
html
$main=""._MA_UGMSEARCH_KIND_SN." " "._MA_UGMSEARCH_CLASS_SN."
設定寬度
# 設定 A 欄 寬度(一次只能一個欄)
$objPHPExcel->getActiveSheet()->getColumnDimensionByColumn(0)->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension("A")->setWidth(20);
SELECT a1.Name, a1.Sales, COUNT(a2.Sales) Sales_Rank FROM Total_Sales a1, Total_Sales a2 WHERE a1.Sales < a2.Sales OR (a1.Sales=a2.Sales AND a1.Name = a2.Name) GROUP BY a1.Name, a1.Sales ORDER BY a1.Sales DESC, a1.Name DESC;
# -------------------------------------------
$sql="
select a.term_class_student_sn, a.avg1, count(b.avg1) rank
from
(select sn as term_class_student_sn ,avg1
from ".$xoopsDB->prefix("ugm_scroeqry_term_class_student")."
where term_class_sn='{$term_class_sn}' and enable='1') a,
(select sn as term_class_student_sn ,avg1
from ".$xoopsDB->prefix("ugm_scroeqry_term_class_student")."
where term_class_sn='{$term_class_sn}' and enable='1') b
where a.avg1 < b.avg1 or (a.avg1=b.avg1 and a.term_class_student_sn = b.term_class_student_sn)
group by a.term_class_student_sn, a.avg1
order by a.avg1 desc, a.term_class_student_sn desc;
";die($sql);
# ----http://www.1keydata.com/tw/sql/sql-rank.html
function xoops_module_update_ugm_market(&$module, $old_version) {
GLOBAL $xoopsDB;
if(!chk_ugm1()) go_ugm1(); # ---- 更改結構為 `e_last` -> DECIMAL( 10, 2 )
if(!chk_ugm2()) go_ugm2(); # ---- 更改結構為 `e_now` -> DECIMAL( 10, 2 )
return true;
}
# -------------------- ugm --------------------------------------------------*/
# ---- 更改結構 ugm_market_utility_main `e_last` 120->130----
function chk_ugm1(){
global $xoopsDB;
$sql="select `e_last` from ".$xoopsDB->prefix("ugm_market_utility_main")."";
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());
if(mysql_field_type($result,0)=='int')return false ;
return true;
}
function go_ugm1(){
global $xoopsDB;
$sql="ALTER TABLE ".$xoopsDB->prefix("ugm_market_utility_main")." CHANGE `e_last` `e_last` DECIMAL( 10, 2 ) UNSIGNED NOT NULL COMMENT '上期用電度數'";
$xoopsDB->queryF($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());
return true;
}
# -----------------------------------------
# ---- 更改結構 ugm_market_utility_main `e_now` 120->130-----
function chk_ugm2(){
global $xoopsDB;
$sql="select `e_now` from ".$xoopsDB->prefix("ugm_market_utility_main")."";
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());
if(mysql_field_type($result,0)=='int')return false ;
return true;
}
function go_ugm2(){
global $xoopsDB;
$sql="ALTER TABLE ".$xoopsDB->prefix("ugm_market_utility_main")." CHANGE `e_now` `e_now` DECIMAL( 10, 2 ) UNSIGNED NOT NULL COMMENT '本期用電度數'";
$xoopsDB->queryF($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());
return true;
}
# -----------------------------------------
# ---- 引入XOOPS 內建表單物件 -------------------------------
include_once(XOOPS_ROOT_PATH."/class/xoopsformloader.php");
# ---- 預設值 -----------------------------------------------
$group=$xoopsModuleConfig['query_admin'];
# ---- XoopsFormSelectGroup('標題', 'name', 含訪客, '預設值', 高度 ,多選)
$form=new XoopsFormSelectGroup ("", "group", false, $group, 3, true);
# ---- 輸出HTML碼 ------------------------------------------
$main_form = $form->render();
# ----- 輸出驗證碼-----------------------------------------------------
$configs="";
$Captcha=new XoopsFormCaptcha ("請輸入驗證碼", 'xoopscaptcha', false, $configs);
# ---- 輸出HTML碼 ------------------------------------------
$form_Captcha = $Captcha->render();
<div class="accordion" id="menu_block_1">
<div class="accordion-group">
<div class="accordion-heading">
<a class="accordion-toggle collapsed" data-toggle="collapse" data-parent="#menu_block_1" href="#menu_sn_1">伸縮選單1</a>
</div>
<div id="menu_sn_1" class="accordion-body in collapse">
<div class="accordion-inner">
<ul>
<li>第一層21</li>
<li>第一層22</li>
<li>第一層2</li>
</ul>
</div>
</div>
</div>
<div class="accordion-group">
<div class="accordion-heading">
<a class="accordion-toggle" data-toggle="collapse" data-parent="#menu_block_1" href="#menu_sn_2">伸縮選單2</a>
</div>
<div id="menu_sn_2" class="accordion-body in collapse">
<div class="accordion-inner">
<ul>
<li>第一層21</li>
<li>第一層22</li>
<li>第一層2</li>
</ul>
</div>
</div>
</div>
</div>
<?php include_once "header.php"; $market_sn=$_REQUEST['market_sn']; echo get_market_fill($market_sn); ?>這裡直返回「填發人員」
<script>
//開啟表單時
$(document).ready(function(){
//由市場決定填發人員
$.post('ajax_utility.php' , {market_sn:$('#market_sn').val()},
function(data){
$('#fill').val(data);
});
//市場改變，填發人員改變
$('#market_sn').change(function(){
$.post('ajax_utility.php' , {market_sn: $('#market_sn').val()},
function(data){
$('#fill').val(data); //排序
});
});
//自動抓取年度
$('#limit_year').val($('#year').val()); //年度
$('#year').change(function(){
$('#limit_year').val($('#year').val()); //年度
});
//自動抓取月份
$('#limit_month').val($('#month').val()); //月份
$('#month').change(function(){
$('#limit_month').val($('#month').val()); //月份
});
});
</script>
取得值：$('#market_sn').val()
寫入值：$('#fill').val(data);
<select name='market_sn' size=1 id='market_sn'>{$market_select_option}</select>
<input type='text' name='fill' size='5' value='' id='fill' >
$add_button="<a href='{$_SERVER['PHP_SELF']}?op=ugm_market_hire_form' class='Button'><span>按鈕</span></a>";
固定表格<table border='0' cellspacing='3' cellpadding='3' id='ugm_tb' style='word-wrap:break-word; word-break:break-all;table-layout:fixed;'>表單
<td><input type='text' name='hier[{$sn}][userfees]' value='{$userfees}' id='userfees_{$sn}' class='validate[required,custom[integer]]' style='width:60px'></td>
<td><input type='text' name='hier[{$sn}][cleaningfees]' value='{$cleaningfees}' id='cleaningfees_{$sn}' class='validate[required,custom[integer]]' style='width:60px'></td>
<td><input type='text' name='hier[{$sn}][delayfees]' value='{$delayfees}' id='delayfees_{$sn}' class='validate[custom[integer]]' style='width:60px'></td>
<td><input type='text' name='hier[{$sn}][ps]' value='{$ps}' id='ps_{$sn}' style='width:140px'></td>
接收foreach ($_REQUEST['hier'] as $sn => $data){
foreach ($data as $k => $v){
//以下會產生這些變數： $userfees, $cleaningfees,$delayfees,$ps
$$k=$v;
}
echo $sn."<br>";
echo $userfees."<br>";
echo $cleaningfees."<br>";
echo $delayfees."<br>";
echo $ps."<br>";
die();
}
$last_button="上一步";
<div >
<{includeq file="$xoops_rootpath/modules/ugm_page/templates/ugm_page_block_slider.html"}> <!-- 引入ugm_page 自訂頁面第一個圖片輪撥 -->
</div>
<div>
<{includeq file="$xoops_rootpath/modules/ugm_page/templates/ugm_page_block_menu.html"}><!-- 引入ugm_page 自訂頁面第一個下拉選單 -->
<div class="clear"></div>
</div>
3.請建立下拉選單及圖片輪撥的資料
