6-1 opList
6-2 opShow
一、程式
- 流程
case "opShow": opShow($sn); break;
二、函數
- opShow($sn)
#單筆顯示 function opShow($sn = "") { global $xoopsDB,$xoopsTpl,$module_name; if (!$sn) { redirect_header(XOOPS_URL, 3, "資料錯誤！！"); } #---- 過濾讀出的變數值 ---- $myts = MyTextSanitizer::getInstance(); //sn kind kind_gallery title summary content price amount enable date sort $sql = "select a.*,b.title as kind_title from " . $xoopsDB->prefix("cnu_show_prod") . " as a left join " . $xoopsDB->prefix("cnu_show_kind") . " as b on a.kind=b.sn where a.sn='{$sn}' and a.enable='1' "; //die($sql); $result = $xoopsDB->query($sql) or redirect_header(XOOPS_URL, 3, web_error()); $row = $xoopsDB->fetchArray($result); #----------------------------------------------------- if (!$row) { redirect_header(XOOPS_URL, 3, "資料錯誤！！"); } #計數器+1 InsertCounteAddOne($row['sn'], "cnu_show_prod"); //ugm_tools2/ugmTools.php #----------------------------------------------------- //以下會產生這些變數： a.sn,a.kind,a.title,a.url,a.content,b.file_name,b.sub_dir $row['sn'] = intval($row['sn']); $row['kind'] = intval($row['kind']); #一般文字 $row['title'] = $myts->htmlSpecialChars($row['title']); $row['date'] = intval($row['date']); #日期 $row['date'] = date("Y-m-d", xoops_getUserTimestamp($row['date'])); //從資料庫撈出 $row['counter'] = intval($row['counter']); $row['kind_title'] = $myts->htmlSpecialChars($row['kind_title']); $row['youtube'] = $myts->htmlSpecialChars($row['youtube']);//大類名稱 #大量文字， $html = 0; $br = 1; $row['summary'] = $myts->displayTarea($row['summary'], $html, 1, 0, 1, $br); #大量文字，編輯器 $html = 1; $br = 0; $row['content'] = $myts->displayTarea($row['content'], $html, 1, 0, 1, $br); #----單檔圖片上傳 $subdir = "prod"; //子目錄(前後不要有 / ) $ugmUpFiles = new ugmUpFiles($module_name, $subdir); //實體化 $col_name = "prod"; //資料表關鍵字 $thumb = false ; //顯示縮圖 $col_sn = $row['sn']; //關鍵字流水號 $row['prod'] = $ugmUpFiles->get_rowPicSingleUrl($col_name,$col_sn,$thumb); #----------------------------------------------------- #型錄 #上傳pdf型錄 $multiple = false; $col_name = "prodPdf"; $ugmUpFiles->set_col($col_name, $row['sn']); $row['pdf'] = $ugmUpFiles->get_rowFileSingleUrl($col_name, $row['sn']); #----------------------------------------------------- $xoopsTpl->assign("row", $row); #----------------------------------------------------- }
三、樣板
- templates/cnu_show_index.tpl
<{if $op == "opShow"}> <style type="text/css"> .prod-head { padding: 10px; background-color: #333; color:#fff; } .space-10{ height:10px; } .space-20{ height:20px; } .space-30{ height:30px; } .space-40{ height:40px; } .space-50{ height:50px; } .space-60{ height:60px; } .show{ padding-bottom:50px; letter-spacing: 1.5px; font-family: -apple-system,"PingFang SC","Helvetica Neue","Hiragino Sans GB","Microsoft YaHei","Microsoft JhengHei","Source Han Sans SC","Noto Sans CJK SC","Source Han Sans CN","Noto Sans SC","Source Han Sans TC","Noto Sans CJK TC","WenQuanYi Micro Hei",SimSun,sans-serif; } .mg-post h1{ font-size:24px; color:#000; } .mg-post .mg-post-title { margin-bottom: 15px; } } .mg-post .mg-post-title a { color: #16262e; } .mg-post .mg-post-title a:hover { color: #e7b315; } .mg-post .mg-post-meta { border-bottom: 1px solid #f2f2f2; margin-bottom: 20px; color: #96a3a9; } .mg-post .mg-post-meta span { padding-right: 10px; } .mg-post .mg-post-meta span:after { content: '/'; padding-left: 15px; color: #0f0f0f; } #show .mg-post .mg-post-meta span:last-child:after { content: ''; padding-left: 0; } .mg-post .mg-post-meta a { color: #0f0f0f; } .mg-post .mg-post-meta a:hover { color: #e7b315; } .mg-post .mg-read-more { font-family: "Playfair Display", serif; font-style: italic; font-size: 15px; } .mg-post-title i { display: block; width: 60px; line-height: 60px; background-color: #32c5d2; text-align: center; font-size: 40px; color: #000; border-radius: 50%; float: left; -webkit-transition: background-color 0.3s; transition: background-color 0.3s; } .content{ line-height: 1.7; font-size: 16px; color: #404040; font-family: -apple-system,"PingFang SC","Helvetica Neue","Hiragino Sans GB","Microsoft YaHei","Microsoft JhengHei","Source Han Sans SC","Noto Sans CJK SC","Source Han Sans CN","Noto Sans SC","Source Han Sans TC","Noto Sans CJK TC","WenQuanYi Micro Hei",SimSun,sans-serif; } .show img{ border: 2px solid #fafafa; border-radius: 8px; background-image: -webkit-gradient(linear, center top, center bottom, from(#fcfcfc), to(#bfbfbf), color-stop(3%, #f7f7f7), color-stop(12%, #f2f2f2), color-stop(90%, #d9d9d9)); background-image: -webkit-linear-gradient(top, #fcfcfc, #f7f7f7 3%, #f2f2f2 12%, #d9d9d9 90%, #bfbfbf); background-image: -moz-linear-gradient(top, #fcfcfc, #f7f7f7 3%, #f2f2f2 12%, #d9d9d9 90%, #bfbfbf); background-image: -o-linear-gradient(top, #fcfcfc, #f7f7f7 3%, #f2f2f2 12%, #d9d9d9 90%, #bfbfbf); background-image: -ms-linear-gradient(top, #fcfcfc, #f7f7f7 3%, #f2f2f2 12%, #d9d9d9 90%, #bfbfbf); background-image: linear-gradient(to bottom, #fcfcfc, #f7f7f7 3%, #f2f2f2 12%, #d9d9d9 90%, #bfbfbf); -webkit-box-shadow: 0 1px 1px 1px rgba(58,60,61,0.75), inset 0 1px 0 #f5f5f5; -moz-box-shadow: 0 1px 1px 1px rgba(58,60,61,0.75), inset 0 1px 0 #f5f5f5; box-shadow: 0 1px 1px 1px rgba(58,60,61,0.75), inset 0 1px 0 #f5f5f5; } </style> <div id="show" class="show"> <!--內容--> <div class="row"> <div class="col-sm-4"> <a href="#myModal" data-toggle="modal" > <img src="<{$row.prod}>" class="img-responsive" alt="<{$row.title}>"> </a> </div> <div class="col-sm-8 mg-post"> <h1><{$row.title}></h1> <div class="mg-post-meta"> <span><{$row.date}></span> <span> <a href="<{xoAppUrl modules/cnu_show/index.php?op=showKind&kind=}><{$row.kind}>"><{$row.kind_title}></a> </span> <span><{$row.counter}></span> <{if $isAdmin}> <span> <a href="<{xoAppUrl modules/cnu_show/admin/main.php?op=opForm&sn=}><{$row.sn}>"><{$smarty.const._EDIT}></a> </span> <{/if}> </div> <div style="margin:10px 0;" id="link"> <{if $row.pdf}> <a href="<{$row.pdf}>" title="<{$row.title}>" class="btn btn-info btn-lg" target="_blank" >型錄</a> <{/if}> <{if $row.youtube}> <button type="button" class="btn btn-primary btn-lg" data-toggle="modal" data-target="#Modal-Movie">影片</button> <{/if}> </div> </div> </div> <div class="space-20"></div> <div class="row"> <div class="col-sm-12"> <{$row.content}> </div> </div> </div> <!-- Modal --> <div class="modal fade" id="myModal" role="dialog" style="padding-top:50px;"> <div class="modal-dialog"> <!-- Modal content--> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal">×</button> <h4 class="modal-title text-center" style="color:#000;"><{$row.title}></h4> </div> <div class="modal-body"> <img src="<{$row.prod}>" class="img-responsive " alt="<{$row.title}>"> </div> <div class="modal-footer"> <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button> </div> </div> </div> </div> <{if $row.youtube}> <!-- Modal --> <div class="modal fade" id="Modal-Movie" role="dialog" style="padding-top:50px;"> <div class="modal-dialog"> <!-- Modal content--> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal">×</button> <h4 class="modal-title text-center" style="color:#000;"><{$row.title}></h4> </div> <div class="modal-body"> <div class="video-container"> <iframe width="560" height="315" src="https://www.youtube.com/embed/<{$row.youtube}>" frameborder="0" allowfullscreen></iframe> </div> </div> <div class="modal-footer"> <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button> </div> </div> </div> </div> <{/if}> <{/if}>