Changeset 16868

Timestamp:

2007/12/02 23:54:14 (14 years ago)

Author:

adachi

Message:

インストールログ修正

Location:

branches/feature-module-update/data

Files:

• Smarty/templates/default/admin/ownersstore/log.tpl (modified) (2 diffs)
• Smarty/templates/default/admin/ownersstore/log_detail.tpl (added)
• class/pages/admin/ownersstore/LC_Page_Admin_OwnersStore_Log.php (modified) (2 diffs)

branches/feature-module-update/data/Smarty/templates/default/admin/ownersstore/log.tpl

@@ -47 +47 @@
                                 <td background="<!--{$TPL_DIR}-->img/contents/main_left.jpg"><img src="<!--{$TPL_DIR}-->img/common/_.gif" width="14" height="1" alt=""></td>
                                 <td bgcolor="#cccccc">
-                                
+
                                 <!--コンテンツタイトルここから-->
                                 <table width="678" border="0" cellspacing="0" cellpadding="0" summary=" ">
@@ -66 +66 @@
                                 </table>
                                 <!--コンテンツタイトルここまで-->
-                                
-                                <!--入力項目ここから-->
-                                <table width="678" border="0" cellspacing="1" cellpadding="8" summary=" ">
-                                    <tr>
-                                        <td bgcolor="#f2f1ec" width="160" class="fs12n">
-                                            <p>インストールログ</p>
+                                <table width="678" border="0" cellspacing="1" cellpadding="4" summary=" ">
+                                    <tr bgcolor="#f2f1ec" align="center" class="fs12n">
+                                        <td width="">ﾓｼﾞｭｰﾙ名</td>
+                                        <td width="100">ｽﾃｰﾀｽ</td>
+                                        <td width="100">日時</td>
+                                        <td width="">詳細</td>
+                                        <!--{*<td width="">復元</td>*}-->
+                                    </tr>
+                                <!--{foreach from=$arrInstallLogs item=log name=log_loop}-->
+                                    <tr bgcolor="#ffffff" class="fs12">
+                                        <td align="center"><!--{$log.module_name|escape}--></td>
+                                        <td align="center"><!--{if $log.error_flg}-->失敗<!--{else}-->成功<!--{/if}--></td>
+                                        <td><!--{$log.update_date|sfDispDBDate|escape}--></td>
+                                        <td align="center">
+                                            <a href="<!--{$smarty.const.URL_DIR}-->admin/ownersstore/log.php?mode=detail&log_id=<!--{$log.log_id}-->">
+                                            詳細</a>
                                         </td>
-                                        <td bgcolor="#ffffff" width="518" class="fs10n">
-                                            <textarea name=""
-                                                      cols="60"
-                                                      rows="8"
-                                                      class="area70"
-                                                      maxlength=""
-                                                      style=""><!--{$log|escape}--></textarea>
-                                        </td>
+                                        <!--{*<td align="center"><!--{$log.log_id}--></td>*}-->
                                     </tr>
+                                <!--{/foreach}-->
                                 </table>
-                                <!--入力項目ここまで-->
-                                
                                 </td>
                                 <td background="<!--{$TPL_DIR}-->img/contents/main_right.jpg"><img src="<!--{$TPL_DIR}-->img/common/_.gif" width="14" height="1" alt=""></td>

branches/feature-module-update/data/class/pages/admin/ownersstore/LC_Page_Admin_OwnersStore_Log.php

@@ -62 +62 @@
         SC_Utils::sfIsSuccess(new SC_Session());
 
-        $arrModuleData = $this->getModuleData();
-        $log = '';
-        if (count($arrModuleData)) {
-            foreach($arrModuleData as $module) {
-                $name = $module['module_name'];
-                $update_date = SC_Utils_Ex::sfDispDBDate($module['update_date']);
-
-                $log .= sprintf("[%s] %s モジュール が更新されました。\n", $update_date, $name);
+        $mode = isset($_GET['mode']) ? $_GET['mode'] : '';
+        switch ($mode) {
+        case 'detail':
+            $objForm = $this->initParam();
+            if ($objForm->checkError()) {
+                sfDispError('');
             }
+            $this->arrLogDetail = $this->getLogDetail($objForm->getValue('log_id'));
+            $this->tpl_mainpage = 'ownersstore/log_detail.tpl';
+            break;
+        default:
+            break;
         }
-
-        $this->log = $log;
+        $this->arrInstallLogs = $this->getLogs();
 
         // ページ出力
@@ -90 +92 @@
     }
 
-    function getModuleData() {
+    function getLogs() {
+        $sql =<<<END
+SELECT
+    *
+FROM
+    dtb_module_update_logs JOIN (
+    SELECT
+        module_id,
+        module_name
+    FROM
+        dtb_module
+    ) AS modules USING(module_id)
+ORDER BY update_date DESC
+END;
         $objQuery = new SC_Query;
-        $objQuery->setOrder('update_date desc');
-        $arrRet = $objQuery->select('*', 'dtb_module');
-        return empty($arrRet) ? array() : $arrRet;
+        $arrRet = $objQuery->getAll($sql);
+        return isset($arrRet) ? $arrRet : array();
+    }
+
+    function initParam() {
+        $objForm = new SC_FormParam();
+        $objForm->addParam('log_id', 'log_id', INT_LEN, '', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));
+        $objForm->setParam($_GET);
+        return $objForm;
+    }
+
+    function getLogDetail($log_id) {
+            $sql =<<<END
+SELECT
+    *
+FROM
+    dtb_module_update_logs JOIN (
+    SELECT
+        module_id,
+        module_name
+    FROM
+        dtb_module
+    ) AS modules USING(module_id)
+WHERE
+    log_id = ?
+END;
+        $objQuery = new SC_Query;
+        $arrRet = $objQuery->getAll($sql, array($log_id));
+        return isset($arrRet[0]) ? $arrRet[0] : array();
     }
 }