Changeset 21441 for branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents_CsvSql.php

Timestamp:

2012/02/06 11:05:15 (12 years ago)

Author:

Seasoft

Message:

#1613 (ソース整形・ソースコメントの改善)

• Zend Framework PHP 標準コーディング規約への準拠を高めた

File:

• branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents_CsvSql.php (modified) (16 diffs)

branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents_CsvSql.php

@@ -76 +76 @@
         $objFormParam->convParam();
         $this->arrForm = $objFormParam->getHashArray();
-        switch($this->getMode()) {
+        switch ($this->getMode()) {
         // データの登録
         case 'confirm':
             $this->arrErr = $this->lfCheckConfirmError($objFormParam);
-            if(SC_Utils_Ex::isBlank($this->arrErr)) {
+            if (SC_Utils_Ex::isBlank($this->arrErr)) {
                 // データの更新
                 $this->arrForm['sql_id'] = $this->lfUpdData($objFormParam->getValue('sql_id'), $objFormParam->getDbArray());
@@ -90 +90 @@
         case 'preview':
             $this->arrErr = $this->lfCheckPreviewError($objFormParam);
-            if(SC_Utils_Ex::isBlank($this->arrErr)) {
+            if (SC_Utils_Ex::isBlank($this->arrErr)) {
                 $this->sqlerr = $this->lfCheckSQL($objFormParam->getValue('csv_sql'));
             }
@@ -104 +104 @@
         case 'delete':
             $this->arrErr = $this->lfCheckDeleteError($objFormParam);
-            if(SC_Utils_Ex::isBlank($this->arrErr)) {
+            if (SC_Utils_Ex::isBlank($this->arrErr)) {
                 $this->lfDelData($objFormParam->getValue('sql_id'));
                 SC_Response_Ex::reload();
@@ -113 +113 @@
         case "csv_output":
             $this->arrErr = $this->lfCheckOutputError($objFormParam);
-            if(SC_Utils_Ex::isBlank($this->arrErr)) {
+            if (SC_Utils_Ex::isBlank($this->arrErr)) {
                 $this->lfDoCsvOutput($objFormParam->getValue('csv_output_id'));
                 exit;
@@ -120 +120 @@
         default:
             $this->arrErr = $objFormParam->checkError();
-            if(SC_Utils_Ex::isBlank($this->arrErr)) {
+            if (SC_Utils_Ex::isBlank($this->arrErr)) {
                 // 設定内容を取得する
                 $this->arrForm = $this->lfGetSqlData($objFormParam);
@@ -163 +163 @@
         $objErr->doFunc( array("SQL文", "csv_sql", "30000"), array("EXIST_CHECK", "MAX_LENGTH_CHECK") );
         $objErr->doFunc( array('SQL文には読み込み関係以外のSQLコマンドおよび";"記号', 'csv_sql', $this->lfGetSqlDenyList()), array("PROHIBITED_STR_CHECK"));
-        if(!SC_Utils_Ex::isBlank($objErr->arrErr)) {
+        if (!SC_Utils_Ex::isBlank($objErr->arrErr)) {
             $arrErr = array_merge($arrErr, $objErr->arrErr);
         }
         // SQL文自体の確認、エラーが無い時のみ実行
-        if(SC_Utils_Ex::isBlank($arrErr)) {
+        if (SC_Utils_Ex::isBlank($arrErr)) {
             $sql_error = $this->lfCheckSQL($objFormParam->getValue('csv_sql'));
-            if(!SC_Utils_Ex::isBlank($sql_error)) {
+            if (!SC_Utils_Ex::isBlank($sql_error)) {
                 $arrErr["csv_sql"] = "※ SQL文が不正です。SQL文を見直してください";
             }
@@ -189 +189 @@
         $objErr->doFunc( array("SQL文", "csv_sql", "30000"), array("EXIST_CHECK", "MAX_LENGTH_CHECK") );
         $objErr->doFunc( array('SQL文には読み込み関係以外のSQLコマンドおよび";"記号', 'csv_sql', $this->lfGetSqlDenyList()), array("PROHIBITED_STR_CHECK"));
-        if(!SC_Utils_Ex::isBlank($objErr->arrErr)) {
+        if (!SC_Utils_Ex::isBlank($objErr->arrErr)) {
             $arrErr = array_merge($arrErr, $objErr->arrErr);
         }
@@ -207 +207 @@
         $objErr = new SC_CheckError_Ex($objFormParam->getHashArray());
         $objErr->doFunc( array("SQL ID", "sql_id"), array("EXIST_CHECK") );
-        if(!SC_Utils_Ex::isBlank($objErr->arrErr)) {
+        if (!SC_Utils_Ex::isBlank($objErr->arrErr)) {
             $arrErr = array_merge($arrErr, $objErr->arrErr);
         }
@@ -225 +225 @@
         $objErr = new SC_CheckError_Ex($objFormParam->getHashArray());
         $objErr->doFunc( array("CSV出力対象SQL ID", "csv_output_id"), array("EXIST_CHECK") );
-        if(!SC_Utils_Ex::isBlank($objErr->arrErr)) {
+        if (!SC_Utils_Ex::isBlank($objErr->arrErr)) {
             $arrErr = array_merge($arrErr, $objErr->arrErr);
         }
@@ -249 +249 @@
         // 実テーブル上のカラム設定を見に行く仕様に変更 ref #476
         $arrTable = $objQuery->listTables();
-        if(SC_Utils_Ex::isBlank($arrTable)) {
+        if (SC_Utils_Ex::isBlank($arrTable)) {
             return array();
         }
         $arrRet = array();
-        foreach($arrTable as $table) {
-            if(substr($table, 0, 4) == 'dtb_') {
+        foreach ($arrTable as $table) {
+            if (substr($table, 0, 4) == 'dtb_') {
                 $arrRet[ $table ] = 'データテーブル: ' . $table;
-            }else if(substr($table, 0, 4) == 'mtb_') {
+            }else if (substr($table, 0, 4) == 'mtb_') {
                 $arrRet[ $table ] = 'マスターテーブル: ' . $table;
-            }else if(substr($table, 0, 3) == 'vw_') {
+            }else if (substr($table, 0, 3) == 'vw_') {
                 $arrRet[ $table ] = 'ビュー: ' . $table;
             }
@@ -272 +272 @@
      */
     function lfGetColList($table){
-        if(SC_Utils_Ex::isBlank($table)) {
+        if (SC_Utils_Ex::isBlank($table)) {
             return array();
         }
@@ -308 +308 @@
         $sql = "SELECT " . $sql . " ";
         $objErrMsg = $objQuery->query($sql);
-        if (PEAR::isError($objErrMsg)){
+        if (PEAR::isError($objErrMsg)) {
             $err = $objErrMsg->message . "\n" . $objErrMsg->userinfo;
         }
@@ -327 +327 @@
         }
         $sql_id = $objFormParam->getValue('sql_id');
-        if(!SC_Utils_Ex::isBlank($sql_id)) {
+        if (!SC_Utils_Ex::isBlank($sql_id)) {
             $arrData = $this->lfGetSqlList('sql_id = ?', array($sql_id));
             return $arrData[0];
@@ -348 +348 @@
 
         $arrHeader = array();
-        if(!preg_match("/ LIMIT /", $sql)) {
+        if (!preg_match("/ LIMIT /", $sql)) {
             $head_sql = $sql . " LIMIT 0";
-        }else{
+        } else {
             $head_sql = $sql;
         }
         $arrData = $objQuery->getQueryDefsFields($head_sql, array(), true);
-        if(!SC_Utils_Ex::isBlank($arrData)) {
-            foreach($arrData as $key => $val) {
+        if (!SC_Utils_Ex::isBlank($arrData)) {
+            foreach ($arrData as $key => $val) {
                 $arrHeader[] = $key;
             }
@@ -380 +380 @@
             $where = "sql_id = ?";
             $objQuery->update($table, $arrSqlVal, $where, array($sql_id));
-        }else{
+        } else {
             //新規作成
             $sql_id = $objQuery->nextVal('dtb_csv_sql_sql_id');
@@ -400 +400 @@
         $table = "dtb_csv_sql";
         $where = "sql_id = ?";
-        if(SC_Utils_Ex::sfIsInt($sql_id)) {
+        if (SC_Utils_Ex::sfIsInt($sql_id)) {
             $objQuery->delete($table, $where, array($sql_id));
             return true;