Changeset 21514 for branches/version-2_12-dev/data/class/db
- Timestamp:
- 2012/02/15 19:56:17 (12 years ago)
- Location:
- branches/version-2_12-dev/data/class/db
- Files:
-
- 4 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/db/SC_DB_DBFactory.php
r21490 r21514 62 62 * @return void|string データソース名 63 63 */ 64 function getDSN($dsn = "") {64 function getDSN($dsn = '') { 65 65 if (empty($dsn)) { 66 66 if (defined('DEFAULT_DSN')) { 67 67 $dsn = DEFAULT_DSN; 68 68 } else { 69 return "";69 return ''; 70 70 } 71 71 } … … 79 79 * @return string データベースのバージョン 80 80 */ 81 function sfGetDBVersion($dsn = "") { return null; }81 function sfGetDBVersion($dsn = '') { return null; } 82 82 83 83 /** … … 143 143 * @return array テーブル名の配列 144 144 */ 145 function findTableNames($expression = "") { return array(); }145 function findTableNames($expression = '') { return array(); } 146 146 147 147 /** -
branches/version-2_12-dev/data/class/db/SC_DB_MasterData.php
r21420 r21514 150 150 foreach ($masterData as $key => $val) { 151 151 $sqlVal = array($columns[1] => $val); 152 $this->objQuery->update($name, $sqlVal, $columns[0] . " = ". SC_Utils_Ex::sfQuoteSmart($key));152 $this->objQuery->update($name, $sqlVal, $columns[0] . ' = ' . SC_Utils_Ex::sfQuoteSmart($key)); 153 153 $i++; 154 154 } … … 226 226 */ 227 227 function clearCache($name) { 228 $masterDataFile = MASTER_DATA_REALDIR . $name . ".php";228 $masterDataFile = MASTER_DATA_REALDIR . $name . '.php'; 229 229 if (is_file($masterDataFile)) { 230 230 unlink($masterDataFile); 231 231 } 232 $masterDataFile = MASTER_DATA_REALDIR . $name . ".serial";232 $masterDataFile = MASTER_DATA_REALDIR . $name . '.serial'; 233 233 if (is_file($masterDataFile)) { 234 234 unlink($masterDataFile); … … 311 311 $this->objQuery->setOrder($columns[2]); 312 312 } 313 $results = $this->objQuery->select($columns[0] . ", ". $columns[1], $name);313 $results = $this->objQuery->select($columns[0] . ', ' . $columns[1], $name); 314 314 315 315 // 結果を key => value 形式に格納 … … 353 353 */ 354 354 function getMasterDataAsDefine($masterData, $comments = array()) { 355 $data = "";355 $data = ''; 356 356 foreach ($masterData as $key => $val) { 357 357 if (!empty($comments[$key])) { 358 $data .= "/** ". $comments[$key] . " */\n";358 $data .= '/** ' . $comments[$key] . " */\n"; 359 359 } 360 360 $data .= "define('" . $key . "', " . $val . ");\n"; -
branches/version-2_12-dev/data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php
r21490 r21514 44 44 * @return string データベースのバージョン 45 45 */ 46 function sfGetDBVersion($dsn = "") {46 function sfGetDBVersion($dsn = '') { 47 47 $objQuery =& SC_Query_Ex::getSingletonInstance($dsn); 48 $val = $objQuery->getOne( "select version()");49 return "MySQL ". $val;48 $val = $objQuery->getOne('select version()'); 49 return 'MySQL ' . $val; 50 50 } 51 51 … … 89 89 */ 90 90 function getOrderYesterdaySql($method) { 91 return "SELECT ".$method."(total) FROM dtb_order "92 . "WHERE del_flg = 0 "93 . "AND cast(create_date as date) = DATE_ADD(current_date, interval -1 day) "94 . "AND status <> ". ORDER_CANCEL;91 return 'SELECT '.$method.'(total) FROM dtb_order ' 92 . 'WHERE del_flg = 0 ' 93 . 'AND cast(create_date as date) = DATE_ADD(current_date, interval -1 day) ' 94 . 'AND status <> ' . ORDER_CANCEL; 95 95 } 96 96 … … 102 102 */ 103 103 function getOrderMonthSql($method) { 104 return "SELECT ".$method."(total) FROM dtb_order "105 . "WHERE del_flg = 0 "104 return 'SELECT '.$method.'(total) FROM dtb_order ' 105 . 'WHERE del_flg = 0 ' 106 106 . "AND date_format(create_date, '%Y/%m') = ? " 107 107 . "AND date_format(create_date, '%Y/%m/%d') <> date_format(CURRENT_TIMESTAMP, '%Y/%m/%d') " 108 . "AND status <> ". ORDER_CANCEL;108 . 'AND status <> ' . ORDER_CANCEL; 109 109 } 110 110 … … 115 115 */ 116 116 function getReviewYesterdaySql() { 117 return "SELECT COUNT(*) FROM dtb_review AS A "118 . "LEFT JOIN dtb_products AS B "119 . "ON A.product_id = B.product_id "120 . "WHERE A.del_flg = 0 "121 . "AND B.del_flg = 0 "122 . "AND cast(A.create_date as date) = DATE_ADD(current_date, interval -1 day) "123 . "AND cast(A.create_date as date) != current_date";117 return 'SELECT COUNT(*) FROM dtb_review AS A ' 118 . 'LEFT JOIN dtb_products AS B ' 119 . 'ON A.product_id = B.product_id ' 120 . 'WHERE A.del_flg = 0 ' 121 . 'AND B.del_flg = 0 ' 122 . 'AND cast(A.create_date as date) = DATE_ADD(current_date, interval -1 day) ' 123 . 'AND cast(A.create_date as date) != current_date'; 124 124 } 125 125 … … 130 130 */ 131 131 function getSendHistoryWhereStartdateSql() { 132 return "start_date BETWEEN date_add(CURRENT_TIMESTAMP,INTERVAL -5 minute) AND date_add(CURRENT_TIMESTAMP,INTERVAL 5 minute)";132 return 'start_date BETWEEN date_add(CURRENT_TIMESTAMP,INTERVAL -5 minute) AND date_add(CURRENT_TIMESTAMP,INTERVAL 5 minute)'; 133 133 } 134 134 … … 140 140 */ 141 141 function getDownloadableDaysWhereSql($dtb_order_alias = 'dtb_order') { 142 return "(SELECT IF((SELECT d1.downloadable_days_unlimited FROM dtb_baseinfo d1)=1, 1, DATE(CURRENT_TIMESTAMP) <= DATE(DATE_ADD(" . $dtb_order_alias . ".payment_date, INTERVAL (SELECT downloadable_days FROM dtb_baseinfo) DAY))))";142 return '(SELECT IF((SELECT d1.downloadable_days_unlimited FROM dtb_baseinfo d1)=1, 1, DATE(CURRENT_TIMESTAMP) <= DATE(DATE_ADD(' . $dtb_order_alias . '.payment_date, INTERVAL (SELECT downloadable_days FROM dtb_baseinfo) DAY))))'; 143 143 } 144 144 … … 196 196 */ 197 197 function concatColumn($columns) { 198 $sql = "concat(";198 $sql = 'concat('; 199 199 $i = 0; 200 200 $total = count($columns); … … 202 202 $sql .= $column; 203 203 if ($i < $total -1) { 204 $sql .= ", ";204 $sql .= ', '; 205 205 } 206 206 $i++; 207 207 } 208 $sql .= ")";208 $sql .= ')'; 209 209 return $sql; 210 210 } … … 218 218 * @return array テーブル名の配列 219 219 */ 220 function findTableNames($expression = "") {220 function findTableNames($expression = '') { 221 221 $objQuery =& SC_Query_Ex::getSingletonInstance(); 222 $sql = "SHOW TABLES LIKE ". $objQuery->quote("%". $expression . "%");222 $sql = 'SHOW TABLES LIKE '. $objQuery->quote('%' . $expression . "%"); 223 223 $arrColList = $objQuery->getAll($sql); 224 224 $arrColList = SC_Utils_Ex::sfSwapArray($arrColList, false); -
branches/version-2_12-dev/data/class/db/dbfactory/SC_DB_DBFactory_PGSQL.php
r21490 r21514 41 41 * @return string データベースのバージョン 42 42 */ 43 function sfGetDBVersion($dsn = "") {43 function sfGetDBVersion($dsn = '') { 44 44 $objQuery =& SC_Query_Ex::getSingletonInstance($dsn); 45 $val = $objQuery->getOne( "select version()");46 $arrLine = explode( " ", $val);47 return $arrLine[0] . " " . str_replace(",", "", $arrLine[1]);45 $val = $objQuery->getOne('select version()'); 46 $arrLine = explode(' ' , $val); 47 return $arrLine[0] . ' ' . str_replace(',', "", $arrLine[1]); 48 48 } 49 49 … … 68 68 */ 69 69 function getOrderYesterdaySql($method) { 70 return "SELECT ".$method."(total) FROM dtb_order "71 . "WHERE del_flg = 0 "70 return 'SELECT '.$method.'(total) FROM dtb_order ' 71 . 'WHERE del_flg = 0 ' 72 72 . "AND to_char(create_date,'YYYY/MM/DD') = to_char(CURRENT_TIMESTAMP - interval '1 days','YYYY/MM/DD') " 73 . "AND status <> ". ORDER_CANCEL;73 . 'AND status <> ' . ORDER_CANCEL; 74 74 } 75 75 … … 81 81 */ 82 82 function getOrderMonthSql($method) { 83 return "SELECT ".$method."(total) FROM dtb_order "84 . "WHERE del_flg = 0 "83 return 'SELECT '.$method.'(total) FROM dtb_order ' 84 . 'WHERE del_flg = 0 ' 85 85 . "AND to_char(create_date,'YYYY/MM') = ? " 86 86 . "AND to_char(create_date,'YYYY/MM/DD') <> to_char(CURRENT_TIMESTAMP,'YYYY/MM/DD') " 87 . "AND status <> ". ORDER_CANCEL;87 . 'AND status <> ' . ORDER_CANCEL; 88 88 } 89 89 … … 94 94 */ 95 95 function getReviewYesterdaySql() { 96 return "SELECT COUNT(*) FROM dtb_review AS A "97 . "LEFT JOIN dtb_products AS B "98 . "ON A.product_id = B.product_id "99 . "WHERE A.del_flg=0 "100 . "AND B.del_flg = 0 "96 return 'SELECT COUNT(*) FROM dtb_review AS A ' 97 . 'LEFT JOIN dtb_products AS B ' 98 . 'ON A.product_id = B.product_id ' 99 . 'WHERE A.del_flg=0 ' 100 . 'AND B.del_flg = 0 ' 101 101 . "AND to_char(A.create_date, 'YYYY/MM/DD') = to_char(CURRENT_TIMESTAMP - interval '1 days','YYYY/MM/DD') " 102 102 . "AND to_char(A.create_date,'YYYY/MM/DD') != to_char(CURRENT_TIMESTAMP,'YYYY/MM/DD')"; … … 122 122 //downloadable_daysにNULLが入っている場合(無期限ダウンロード可能時)もあるので、NULLの場合は0日に補正 123 123 $downloadable_days = $baseinfo['downloadable_days']; 124 if($downloadable_days ==null || $downloadable_days == "")$downloadable_days=0;125 return "(SELECT CASE WHEN (SELECT d1.downloadable_days_unlimited FROM dtb_baseinfo d1) = 1 AND " . $dtb_order_alias . ".payment_date IS NOT NULL THEN 1 WHEN DATE(CURRENT_TIMESTAMP) <= DATE(". $dtb_order_alias . ".payment_date + '". $downloadable_days ." days') THEN 1 ELSE 0 END)";124 if($downloadable_days ==null || $downloadable_days == '')$downloadable_days=0; 125 return '(SELECT CASE WHEN (SELECT d1.downloadable_days_unlimited FROM dtb_baseinfo d1) = 1 AND ' . $dtb_order_alias . '.payment_date IS NOT NULL THEN 1 WHEN DATE(CURRENT_TIMESTAMP) <= DATE(' . $dtb_order_alias . ".payment_date + '". $downloadable_days ." days') THEN 1 ELSE 0 END)"; 126 126 } 127 127 … … 179 179 */ 180 180 function concatColumn($columns) { 181 $sql = "";181 $sql = ''; 182 182 $i = 0; 183 183 $total = count($columns); … … 185 185 $sql .= $column; 186 186 if ($i < $total -1) { 187 $sql .= " || ";187 $sql .= ' || '; 188 188 } 189 189 $i++; … … 201 201 * @return array テーブル名の配列 202 202 */ 203 function findTableNames($expression = "") {203 function findTableNames($expression = '') { 204 204 $objQuery =& SC_Query_Ex::getSingletonInstance(); 205 $sql = " SELECT c.relname AS name, "206 . " CASE c.relkind "205 $sql = ' SELECT c.relname AS name, ' 206 . ' CASE c.relkind ' 207 207 . " WHEN 'r' THEN 'table' " 208 208 . " WHEN 'v' THEN 'view' END AS type " 209 . " FROM pg_catalog.pg_class c "210 . "LEFT JOIN pg_catalog.pg_namespace n "211 . " ON n.oid = c.relnamespace "209 . ' FROM pg_catalog.pg_class c ' 210 . 'LEFT JOIN pg_catalog.pg_namespace n ' 211 . ' ON n.oid = c.relnamespace ' 212 212 . " WHERE c.relkind IN ('r','v') " 213 213 . " AND n.nspname NOT IN ('pg_catalog', 'pg_toast') " 214 . " AND pg_catalog.pg_table_is_visible(c.oid) "215 . " AND c.relname LIKE ?"216 . " ORDER BY 1,2;";217 $arrColList = $objQuery->getAll($sql, array( "%" . $expression . "%"));214 . ' AND pg_catalog.pg_table_is_visible(c.oid) ' 215 . ' AND c.relname LIKE ?' 216 . ' ORDER BY 1,2;'; 217 $arrColList = $objQuery->getAll($sql, array('%' . $expression . '%')); 218 218 $arrColList = SC_Utils_Ex::sfSwapArray($arrColList, false); 219 219 return $arrColList[0];
Note: See TracChangeset
for help on using the changeset viewer.