13. 類別物件
13-1 ugmKind.php
ugmKind.php
<?php
#---------------------------------
defined('WEB_PATH') || die("WEB_PATH root path not defined");
class ugmKind {
protected $tbl; //資料表
protected $kind; //類別
protected $stopLevel; //層數
protected $ofsn; //父類別
function __construct($tbl, $kind,$stopLevel=1,$ofsn = 0) {
$this->set_tbl($tbl);
$this->set_kind($kind);
$this->set_stopLevel($stopLevel);
$this->set_ofsn($ofsn);
}
#--------- 設定類 --------------------
#設定資料表
public function set_tbl($value) {
$this->tbl = $value;
}
#設定類別
public function set_kind($value) {
$this->kind = $value;
}
#設定層數
public function set_stopLevel($value) {
$this->stopLevel = $value;
}
#設定父類別
public function set_ofsn($value) {
$this->ofsn = $value;
}
//--------- 取得類 ------------*/
#取得資料表
public function get_tbl() {
return $this->tbl;
}
#取得分類
public function get_kind() {
return $this->kind;
}
#取得層數
public function get_stopLevel() {
return $this->stopLevel;
}
#取得父類別
public function get_ofsn() {
return $this->ofsn;
}
#get
################################################################
# 取得外鍵下拉選單 的 選項
# 傳入：($kind_arr, $width = 3)
# 回傳：ForeignKeyForm
################################################################
public function get_foreignOption($foreign, $default="") {
# ----得到Foreign key選單 ----------------------------
$foreignOption = "";
foreach ($foreign as $key => $value) {
$selected = "";
if ($default == $key) {
$selected = " selected";
}
$foreignOption .= "<option value='{$key}'{$selected}>{$value['title']}</option>";
}
return $foreignOption;
}
################################################################
# 取得類別body的陣列
# 有資料表沒有 kind 、ofsn欄位
################################################################
public function get_listArr($ofsn=0,$level=1,$enable=0) {
global $db;
$andKey = $enable ? " and `enable`='{$enable}'":"";
#檢查目前階層是否大於層次
if ($level > $this->stopLevel) {
return;
}
#設定下層
$downLevel = $level + 1;
$sql = "select * from `{$this->tbl}`
where `ofsn`='{$ofsn}' and `kind`='{$this->kind}'{$andKey}
order by sort"; //die($sql);
$result = $db->query($sql) or redirect_header("", 3000, $db->error."\n".$sql,true);
#--------------------------------------------------------------------
$rows = [];
while ($row = $result->fetch_assoc()) {
//以下會產生這些變數： $sn , $ofsn , $title , $enable ,$sort
$row['sn'] = intval($row['sn']);
$row['enable'] = intval($row['enable']);
$row['target'] = intval($row['target']);
$row['title'] = htmlspecialchars($row['title'], ENT_QUOTES);
$row['url'] = htmlspecialchars($row['url'], ENT_QUOTES);
$row['level'] = $level;
#取得底下有幾層
$row['downLevel'] = $this->get_downLevel($row['sn']);
$row['sub'] = $this->get_listArr($row['sn'], $downLevel);
//移動圖示
$icon['move_i'] = ($this->stopLevel == $row['downLevel'])?false:true;
//資料夾圖示(最後一層沒有)
$icon['folder_i'] = $this->stopLevel > $level ? true : false;
//增加類別圖示
$icon['add_downLevel_i'] = $this->stopLevel > $level ? true : false;
//排序圖示
$icon['sort_i'] = true;
$row['icon'] = $icon;
$rows[] = $row;
}
return $rows;
}
#確認底下有幾層
#get_downLevel
public function get_downLevel($sn,$downLevel=0) {
global $db;
if ($downLevel > $this->stopLevel) {
return $downLevel;
}
$level = $downLevel+1;
$sql = "select sn
from `{$this->tbl}`
where ofsn='{$sn}'"; // return $sql;
$result = $db->query($sql) or redirect_header("", 3000, $db->error."\n".$sql,true);
while ($row = $result->fetch_assoc()) {
$downLevel_tmp = $this->get_downLevel($row['sn'], $level);
$downLevel = ($downLevel_tmp > $downLevel) ? $downLevel_tmp : $downLevel;
}
return $downLevel;
}
################################################################
# 取得類別body的html
# data-tt-id 本身
# data-tt-parent-id 父層
################################################################
public function get_listHtml($list, $listBodys) {
$html = "";
foreach ($list as $item => $row) {
$html .= $this->get_rowHtml($listBodys, $row);
if ($row['sub']) {
$html .= $this->get_listHtml($row['sub'], $listBodys);
}
}
return $html;
}
################################################################
# 取得類別body的html
# data-tt-id 本身
# data-tt-parent-id 父層
################################################################
public function get_rowHtml($listBodys, $row) {
#row自己的層數
$level = $this->get_thisLevel($row['sn']);
//style='letter-spacing: 0;'
$html = "
<tr id='tr_{$row['sn']}' data-tt-id='{$row['sn']}' data-tt-parent-id='{$row['ofsn']}' level='{$row['level']}' downLevel='{$row['downLevel']}' sn='{$row['sn']}' class='level{$row['level']}' >\n";
foreach ($listBodys as $k => $format) {
if ($format['valuetype'] == "text") {
#新增子類別
$addLevelButton = ($k == "title" and $this->stopLevel > $level) ? "
<a href='?op=opForm&ofsn={$row['sn']}&kind={$row['kind']}' title='IN ({$row['title']}) 建立子類別' class='btn btn-primary btn-xs'>
<i class='fa fa-plus' aria-hidden='true'></i>
</a>" : "";
#移動
$moveButton = ($k == "title" and $row['icon']['move_i']) ? "
<img src='" . WEB_URL . "/class/treeTable/images/move_s.png' class='folder' alt='用來搬移此分類到其他分類之下，請拖曳之，到目的地分類。' title='用來搬移此分類到其他分類之下，請拖曳之，到目的地分類。'>
" : "";
#資料夾
$folderButton = ($k == "title" and $row['icon']['folder_i']) ? "<span class='folder'></span>" : "";
$width = ($k == "title") ? "width:65%;" : "width:100%;";
#一般input
$html .= " <td class='text-{$format['align']}' style='vertical-align: middle;'>
{$folderButton}{$moveButton}
<input type='text' name='{$k}[{$row['sn']}]' value='{$row[$k]}' id='{$k}_{$row['sn']}' class='{$k}' style='{$width} padding: 2px 6px;'>{$addLevelButton}
</td>";
} elseif ($format['valuetype'] == "yesNo") {
if ($row[$k] == 1) {
#啟用
$title_0 = ($k == "enable") ? "停用" : "啟用";
$html .= " <td class='text-{$format['align']}' style='vertical-align: middle;'><a href='?op=opUpdateEnable&sn={$row['sn']}&{$k}=0&kind=" . $this->get_kind() . "' title='{$title_0}' atl='{$title_0}'><i class='fa fa-check' aria-hidden='true'></i></a></td>";
} else {
#停用
$title_1 = ($k == "enable") ? "啟用" : "停用";
$html .= " <td class='text-{$format['align']}' style='vertical-align: middle;'><a href='?op=opUpdateEnable&sn={$row['sn']}&{$k}=1&kind=" . $this->get_kind() . "' title='{$title_1}' atl='{$title_1}'><i class='fa fa-times' aria-hidden='true'></i></a></td>";
}
} elseif ($format['valuetype'] == "btn") {
$html .= " <td class='text-{$format['align']}' style='vertical-align: middle;'>\n";
$html .= "<i class='fa fa-sort' aria-hidden='true' style='cursor: s-resize;' title='可直接拉動排序'></i> ";
foreach ($format['btn'] as $btnV) {
if ($btnV == "view") {
} elseif ($btnV == "edit") {
$html .= "<a href='?op=opForm&sn={$row['sn']}&kind=" . $this->get_kind() . "' class='btn btn-success btn-xs'>編輯</a> ";
} elseif ($btnV == "del") {
$html .= "<button type='button' class='btn btn-xs btn-danger btnDel'>刪除</button> ";
}
}
$html .= " </td>\n";
}
}
$html .= "</tr>\n";
return $html;
}
###########################################################
# 用流水號 得到自己的層數
###########################################################
public function get_thisLevel($sn, $level = 1) {
global $db;
if ($level > $this->stopLevel) {
return $level;
}
$sql = "select ofsn
from `{$this->tbl}`
where sn='{$sn}'"; // die($sql);
$result = $db->query($sql) or redirect_header("", 3000, $db->error."\n".$sql,true);
list($ofsn) = $result->fetch_row();
if (!$ofsn) {
return $level;
}
return $this->get_thisLevel($ofsn, ++$level);
}
#以流水號取得某筆分類資料
public function get_rowBYsn($sn) {
global $db;
if (empty($sn)) {
return;
}
$sql = "select * from `$this->tbl` where sn='{$sn}'"; //die($sql);
$result = $db->query($sql) or redirect_header("", 3000, $db->error."\n".$sql,true);
$row = $result->fetch_assoc();
return $row;
}
#######################################################
# 取得父類別選單->選項(後台類別表單用)# op_form
#######################################################
public function get_ofsnOption($default, $ofsn = 0, $level = 1, $indent = "", $enable = 0) {
global $db;
if ($level >= $this->stopLevel) {
return;
}
$andKey = $enable ? " and `enable='{$enable}'`":"";
$downLevel = $level + 1;
$indent .= " ";
$sql = "select *
from `{$this->tbl}`
where ofsn='{$ofsn}' and kind='{$this->kind}'{$andKey}
order by sort"; //die($sql);
$result = $db->query($sql) or redirect_header("", 3000, $db->error."\n".$sql,true);
$options = "";
while ($row = $result->fetch_assoc()) {
$selected = ($default == $row['sn']) ? " selected" : "";
$options .= "<option value='{$row['sn']}'{$selected}>{$indent}{$row['title']}</option>\n";
$options .= $this->get_ofsnOption($default, $row['sn'], $downLevel, $indent, $enable);
}
return $options;
}
}