- Timestamp:
- 2013/06/08 16:35:27 (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_13-dev/data/class/pages/admin/LC_Page_Admin_Home.php
r22567 r22856 23 23 */ 24 24 25 // {{{ requires26 25 require_once CLASS_EX_REALDIR . 'page_extends/admin/LC_Page_Admin_Ex.php'; 27 26 … … 33 32 * @version $Id$ 34 33 */ 35 class LC_Page_Admin_Home extends LC_Page_Admin_Ex 34 class LC_Page_Admin_Home extends LC_Page_Admin_Ex 36 35 { 37 38 // }}}39 // {{{ functions40 41 36 /** 42 37 * Page を初期化する. … … 69 64 function action() 70 65 { 71 72 66 // DBバージョンの取得 73 67 $this->db_version = $this->lfGetDBVersion(); … … 139 133 { 140 134 $dbFactory = SC_DB_DBFactory_Ex::getInstance(); 135 141 136 return $dbFactory->sfGetDBVersion(); 142 137 } … … 153 148 $table = 'dtb_customer'; 154 149 $where = 'del_flg = 0 AND status = 2'; 150 155 151 return $objQuery->get($col, $table, $where); 156 152 } … … 169 165 $dbFactory = SC_DB_DBFactory_Ex::getInstance(); 170 166 $sql = $dbFactory->getOrderYesterdaySql($method); 167 171 168 return $objQuery->getOne($sql); 172 169 } … … 186 183 $dbFactory = SC_DB_DBFactory_Ex::getInstance(); 187 184 $sql = $dbFactory->getOrderMonthSql($method); 185 188 186 return $objQuery->getOne($sql, array($month)); 189 187 } … … 201 199 $where = 'del_flg = 0'; 202 200 $from = 'dtb_customer'; 201 203 202 return $objQuery->get($col, $from, $where); 204 203 } … … 216 215 $dbFactory = SC_DB_DBFactory_Ex::getInstance(); 217 216 $sql = $dbFactory->getReviewYesterdaySql(); 217 218 218 return $objQuery->getOne($sql); 219 219 } … … 230 230 $table = 'dtb_review AS A LEFT JOIN dtb_products AS B ON A.product_id = B.product_id'; 231 231 $where = 'A.del_flg = 0 AND A.status = 2 AND B.del_flg = 0'; 232 232 233 return $objQuery->count($table, $where); 233 234 } … … 248 249 . 'WHERE del_flg = 0 AND stock_unlimited = ? AND stock <= 0)' 249 250 . ' AND del_flg = 0'; 251 250 252 return $objQuery->select($cols, $table, $where, array(UNLIMITED_FLG_LIMITED)); 251 253 } … … 306 308 307 309 } 310 308 311 return $arrNewOrder; 309 312 } … … 348 351 $arrInfo[] = get_object_vars($objData); 349 352 } 353 350 354 return $arrInfo; 351 355 }
Note: See TracChangeset
for help on using the changeset viewer.