- Timestamp:
- 2012/02/15 19:56:17 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/pages/admin/LC_Page_Admin_Home.php
r21490 r21514 121 121 */ 122 122 function lfGetPHPVersion() { 123 return "PHP ". phpversion();123 return 'PHP ' . phpversion(); 124 124 } 125 125 … … 141 141 function lfGetCustomerCnt() { 142 142 $objQuery =& SC_Query_Ex::getSingletonInstance(); 143 $col = "COUNT(customer_id)";143 $col = 'COUNT(customer_id)'; 144 144 $table = 'dtb_customer'; 145 $where = "del_flg = 0 AND status = 2";145 $where = 'del_flg = 0 AND status = 2'; 146 146 return $objQuery->get($col, $table, $where); 147 147 } … … 170 170 function lfGetOrderMonth($method) { 171 171 $objQuery =& SC_Query_Ex::getSingletonInstance(); 172 $month = date( "Y/m", mktime());172 $month = date('Y/m', mktime()); 173 173 174 174 // TODO: DBFactory使わないでも共通化できそうな気もしますが … … 186 186 $objQuery =& SC_Query_Ex::getSingletonInstance(); 187 187 188 $col = "SUM(point)";189 $where = "del_flg = 0";188 $col = 'SUM(point)'; 189 $where = 'del_flg = 0'; 190 190 $from = 'dtb_customer'; 191 191 return $objQuery->get($col, $from, $where); … … 214 214 $objQuery =& SC_Query_Ex::getSingletonInstance(); 215 215 216 $table = "dtb_review AS A LEFT JOIN dtb_products AS B ON A.product_id = B.product_id";217 $where = "A.del_flg = 0 AND A.status = 2 AND B.del_flg = 0";216 $table = 'dtb_review AS A LEFT JOIN dtb_products AS B ON A.product_id = B.product_id'; 217 $where = 'A.del_flg = 0 AND A.status = 2 AND B.del_flg = 0'; 218 218 return $objQuery->count($table, $where); 219 219 } … … 227 227 $objQuery =& SC_Query_Ex::getSingletonInstance(); 228 228 229 $cols = "product_id, name";229 $cols = 'product_id, name'; 230 230 $table = 'dtb_products'; 231 $where = "product_id IN ("232 . "SELECT product_id FROM dtb_products_class "233 . "WHERE stock_unlimited = ? AND stock <= 0)";231 $where = 'product_id IN (' 232 . 'SELECT product_id FROM dtb_products_class ' 233 . 'WHERE stock_unlimited = ? AND stock <= 0)'; 234 234 return $objQuery->select($cols, $table, $where, array(UNLIMITED_FLG_LIMITED)); 235 235 } … … 243 243 $objQuery =& SC_Query_Ex::getSingletonInstance(); 244 244 245 $sql = "SELECT 246 ord.order_id, 247 ord.customer_id, 248 ord.order_name01 AS name01, 249 ord.order_name02 AS name02, 250 ord.total, 251 ord.create_date, 252 (SELECT 253 det.product_name 254 FROM 255 dtb_order_detail AS det 256 WHERE 257 ord.order_id = det.order_id 258 ORDER BY det.order_detail_id 259 LIMIT 1 260 ) AS product_name, 261 (SELECT 262 pay.payment_method 263 FROM 264 dtb_payment AS pay 265 WHERE 266 ord.payment_id = pay.payment_id 267 ) AS payment_method 268 FROM ( 269 SELECT 270 order_id, 271 customer_id, 272 order_name01, 273 order_name02, 274 total, 275 create_date, 276 payment_id 277 FROM 278 dtb_order AS ord 279 WHERE 280 del_flg = 0 AND status <> " . ORDER_CANCEL . " 281 ORDER BY 282 create_date DESC LIMIT 10 OFFSET 0 283 ) AS ord"; 284 $arrNewOrder = $objQuery->getAll($sql); 245 $sql = <<< __EOS__ 246 SELECT 247 ord.order_id, 248 ord.customer_id, 249 ord.order_name01 AS name01, 250 ord.order_name02 AS name02, 251 ord.total, 252 ord.create_date, 253 (SELECT 254 det.product_name 255 FROM 256 dtb_order_detail AS det 257 WHERE 258 ord.order_id = det.order_id 259 ORDER BY det.order_detail_id 260 LIMIT 1 261 ) AS product_name, 262 (SELECT 263 pay.payment_method 264 FROM 265 dtb_payment AS pay 266 WHERE 267 ord.payment_id = pay.payment_id 268 ) AS payment_method 269 FROM ( 270 SELECT 271 order_id, 272 customer_id, 273 order_name01, 274 order_name02, 275 total, 276 create_date, 277 payment_id 278 FROM 279 dtb_order AS ord 280 WHERE 281 del_flg = 0 AND status <> ? 282 ORDER BY 283 create_date DESC LIMIT 10 OFFSET 0 284 ) AS ord 285 __EOS__; 286 $arrNewOrder = $objQuery->getAll($sql, ORDER_CANCEL); 285 287 foreach ($arrNewOrder as $key => $val) { 286 $arrNewOrder[$key]['create_date'] = str_replace( "-", "/", substr($val['create_date'], 0,19));288 $arrNewOrder[$key]['create_date'] = str_replace('-', "/", substr($val['create_date'], 0,19)); 287 289 288 290 } … … 321 323 322 324 if (empty($arrTmpData)) { 323 SC_Utils_Ex::sfErrorHeader( ">> 更新情報の取得に失敗しました。");325 SC_Utils_Ex::sfErrorHeader('>> 更新情報の取得に失敗しました。'); 324 326 return array(); 325 327 }
Note: See TracChangeset
for help on using the changeset viewer.