Changeset 21514 for branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products_Review.php
- 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/products/LC_Page_Admin_Products_Review.php
r21490 r21514 147 147 switch ($this->getMode()) { 148 148 case 'search': 149 $objErr->doFunc(array( "投稿者", 'search_startyear', 'search_startmonth', 'search_startday'), array('CHECK_DATE'));150 $objErr->doFunc(array( "開始日", 'search_startyear', 'search_startmonth', 'search_startday'), array('CHECK_DATE'));151 $objErr->doFunc(array( "終了日", 'search_endyear', 'search_endmonth', 'search_endday'), array('CHECK_DATE'));152 $objErr->doFunc(array( "開始日", "終了日", 'search_startyear', 'search_startmonth', 'search_startday', 'search_endyear', 'search_endmonth', 'search_endday'), array('CHECK_SET_TERM'));149 $objErr->doFunc(array('投稿者', 'search_startyear', 'search_startmonth', 'search_startday'), array('CHECK_DATE')); 150 $objErr->doFunc(array('開始日', 'search_startyear', 'search_startmonth', 'search_startday'), array('CHECK_DATE')); 151 $objErr->doFunc(array('終了日', 'search_endyear', 'search_endmonth', 'search_endday'), array('CHECK_DATE')); 152 $objErr->doFunc(array('開始日', '終了日', 'search_startyear', 'search_startmonth', 'search_startday', 'search_endyear', 'search_endmonth', 'search_endday'), array('CHECK_SET_TERM')); 153 153 break; 154 154 155 155 case 'complete': 156 $objErr->doFunc(array( "おすすめレベル", 'recommend_level'), array('SELECT_CHECK'));157 $objErr->doFunc(array( "タイトル", 'title', STEXT_LEN), array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK'));158 $objErr->doFunc(array( "コメント", 'comment', LTEXT_LEN), array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK'));156 $objErr->doFunc(array('おすすめレベル', 'recommend_level'), array('SELECT_CHECK')); 157 $objErr->doFunc(array('タイトル', 'title', STEXT_LEN), array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 158 $objErr->doFunc(array('コメント', 'comment', LTEXT_LEN), array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 159 159 break; 160 160 } … … 171 171 $objQuery =& SC_Query_Ex::getSingletonInstance(); 172 172 $sqlval['del_flg'] = 1; 173 $objQuery->update('dtb_review', $sqlval, "review_id = ?", array($review_id));173 $objQuery->update('dtb_review', $sqlval, 'review_id = ?', array($review_id)); 174 174 } 175 175 … … 183 183 $arrHidden = array(); 184 184 foreach ($arrForm AS $key=>$val) { 185 if (preg_match( "/^search_/", $key)) {185 if (preg_match('/^search_/', $key)) { 186 186 switch ($key) { 187 187 case 'search_sex': 188 188 $arrHidden[$key] = SC_Utils_Ex::sfMergeParamCheckBoxes($val); 189 189 if (!is_array($val)) { 190 $arrForm[$key] = explode( "-", $val);190 $arrForm[$key] = explode('-', $val); 191 191 } 192 192 break; … … 207 207 */ 208 208 function lfInitParam(&$objFormParam) { 209 $objFormParam->addParam( "投稿者名", 'search_reviewer_name', STEXT_LEN, 'KVas', array('MAX_LENGTH_CHECK'),"",false);210 $objFormParam->addParam( "投稿者URL", 'search_reviewer_url', STEXT_LEN, 'KVas', array('MAX_LENGTH_CHECK'),"",false);211 $objFormParam->addParam( "商品名", 'search_name', STEXT_LEN, 'KVas', array('MAX_LENGTH_CHECK'),"",false);212 $objFormParam->addParam( "商品コード", 'search_product_code', STEXT_LEN, 'KVas', array('MAX_LENGTH_CHECK'),"",false);213 $objFormParam->addParam( "性別", 'search_sex', INT_LEN, 'n', array('MAX_LENGTH_CHECK'),"",false);214 $objFormParam->addParam( "おすすめレベル", 'search_recommend_level', INT_LEN, 'n', array('MAX_LENGTH_CHECK'),"",false);215 $objFormParam->addParam( "投稿年", 'search_startyear', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'),"",false);216 $objFormParam->addParam( "投稿月", 'search_startmonth', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'),"",false);217 $objFormParam->addParam( "投稿日", 'search_startday', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'),"",false);218 $objFormParam->addParam( "投稿年", 'search_endyear', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'),"",false);219 $objFormParam->addParam( "投稿月", 'search_endmonth', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'),"",false);220 $objFormParam->addParam( "投稿日", 'search_endday', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'),"",false);221 $objFormParam->addParam( "最大表示件数", 'search_page_max', INT_LEN, 'n', array('MAX_LENGTH_CHECK'),"",false);222 $objFormParam->addParam( "ページ番号件数", 'search_pageno', INT_LEN, 'n', array('MAX_LENGTH_CHECK'),"",false);223 $objFormParam->addParam( "レビューID", 'review_id', INT_LEN, 'n', array('MAX_LENGTH_CHECK'),"",false);209 $objFormParam->addParam('投稿者名', 'search_reviewer_name', STEXT_LEN, 'KVas', array('MAX_LENGTH_CHECK'),"",false); 210 $objFormParam->addParam('投稿者URL', 'search_reviewer_url', STEXT_LEN, 'KVas', array('MAX_LENGTH_CHECK'),"",false); 211 $objFormParam->addParam('商品名', 'search_name', STEXT_LEN, 'KVas', array('MAX_LENGTH_CHECK'),"",false); 212 $objFormParam->addParam('商品コード', 'search_product_code', STEXT_LEN, 'KVas', array('MAX_LENGTH_CHECK'),"",false); 213 $objFormParam->addParam('性別', 'search_sex', INT_LEN, 'n', array('MAX_LENGTH_CHECK'),"",false); 214 $objFormParam->addParam('おすすめレベル', 'search_recommend_level', INT_LEN, 'n', array('MAX_LENGTH_CHECK'),"",false); 215 $objFormParam->addParam('投稿年', 'search_startyear', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'),"",false); 216 $objFormParam->addParam('投稿月', 'search_startmonth', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'),"",false); 217 $objFormParam->addParam('投稿日', 'search_startday', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'),"",false); 218 $objFormParam->addParam('投稿年', 'search_endyear', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'),"",false); 219 $objFormParam->addParam('投稿月', 'search_endmonth', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'),"",false); 220 $objFormParam->addParam('投稿日', 'search_endday', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'),"",false); 221 $objFormParam->addParam('最大表示件数', 'search_page_max', INT_LEN, 'n', array('MAX_LENGTH_CHECK'),"",false); 222 $objFormParam->addParam('ページ番号件数', 'search_pageno', INT_LEN, 'n', array('MAX_LENGTH_CHECK'),"",false); 223 $objFormParam->addParam('レビューID', 'review_id', INT_LEN, 'n', array('MAX_LENGTH_CHECK'),"",false); 224 224 } 225 225 … … 233 233 function lfDoOutputCsv($where, $arrVal) { 234 234 $objCSV = new SC_Helper_CSV_Ex(); 235 if ($where != "") {236 $where = "WHERE ". $where;237 } 238 $objCSV->sfDownloadCsv('4', $where, $arrVal, "", true);235 if ($where != '') { 236 $where = 'WHERE ' . $where; 237 } 238 $objCSV->sfDownloadCsv('4', $where, $arrVal, '', true); 239 239 } 240 240 … … 247 247 function lfGetWhere($arrForm) { 248 248 //削除されていない商品を検索 249 $where = "A.del_flg = 0 AND B.del_flg = 0";249 $where = 'A.del_flg = 0 AND B.del_flg = 0'; 250 250 251 251 foreach ($arrForm AS $key=>$val) { … … 254 254 switch ($key) { 255 255 case 'search_reviewer_name': 256 $val = preg_replace( "/ /", "%", $val);257 $where.= " AND reviewer_name LIKE ? ";256 $val = preg_replace('/ /', '%', $val); 257 $where.= ' AND reviewer_name LIKE ? '; 258 258 $arrval[] = "%$val%"; 259 259 break; 260 260 261 261 case 'search_reviewer_url': 262 $val = preg_replace( "/ /", "%", $val);263 $where.= " AND reviewer_url LIKE ? ";262 $val = preg_replace('/ /', '%', $val); 263 $where.= ' AND reviewer_url LIKE ? '; 264 264 $arrval[] = "%$val%"; 265 265 break; 266 266 267 267 case 'search_name': 268 $val = preg_replace( "/ /", "%", $val);269 $where.= " AND name LIKE ? ";268 $val = preg_replace('/ /', '%', $val); 269 $where.= ' AND name LIKE ? '; 270 270 $arrval[] = "%$val%"; 271 271 break; 272 272 273 273 case 'search_product_code': 274 $val = preg_replace( "/ /", "%", $val);275 $where.= " AND A.product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code LIKE ?)";274 $val = preg_replace('/ /', '%', $val); 275 $where.= ' AND A.product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code LIKE ?)'; 276 276 $arrval[] = "%$val%"; 277 277 break; 278 278 279 279 case 'search_sex': 280 $tmp_where = "";280 $tmp_where = ''; 281 281 //$val=配列の中身,$element=各キーの値(1,2) 282 282 if (is_array($val)) { 283 283 foreach ($val as $element) { 284 if ($element != "") {285 if ($tmp_where == "") {286 $tmp_where .= " AND (sex = ?";284 if ($element != '') { 285 if ($tmp_where == '') { 286 $tmp_where .= ' AND (sex = ?'; 287 287 } else { 288 $tmp_where .= " OR sex = ?";288 $tmp_where .= ' OR sex = ?'; 289 289 } 290 290 $arrval[] = $element; 291 291 } 292 292 } 293 if ($tmp_where != "") {294 $tmp_where .= ")";293 if ($tmp_where != '') { 294 $tmp_where .= ')'; 295 295 $where .= " $tmp_where "; 296 296 } … … 300 300 301 301 case 'search_recommend_level': 302 $where.= " AND recommend_level = ? ";302 $where.= ' AND recommend_level = ? '; 303 303 $arrval[] = $val; 304 304 break; … … 307 307 if (isset($_POST['search_startyear']) && isset($_POST['search_startmonth']) && isset($_POST['search_startday'])) { 308 308 $date = SC_Utils_Ex::sfGetTimestamp($_POST['search_startyear'], $_POST['search_startmonth'], $_POST['search_startday']); 309 $where.= " AND A.create_date >= ? ";309 $where.= ' AND A.create_date >= ? '; 310 310 $arrval[] = $date; 311 311 } … … 315 315 if (isset($_POST['search_startyear']) && isset($_POST['search_startmonth']) && isset($_POST['search_startday'])) { 316 316 $date = SC_Utils_Ex::sfGetTimestamp($_POST['search_endyear'], $_POST['search_endmonth'], $_POST['search_endday']); 317 $end_date = date( "Y/m/d",strtotime("1 day",strtotime($date)));317 $end_date = date('Y/m/d',strtotime('1 day' ,strtotime($date))); 318 318 $where.= " AND A.create_date <= cast('$end_date' as date) "; 319 319 } … … 341 341 if (!isset($arrval)) $arrval = array(); 342 342 343 $from = "dtb_review AS A LEFT JOIN dtb_products AS B ON A.product_id = B.product_id ";343 $from = 'dtb_review AS A LEFT JOIN dtb_products AS B ON A.product_id = B.product_id '; 344 344 $linemax = $objQuery->count($from, $where, $arrval); 345 345 $this->tpl_linemax = $linemax; … … 357 357 358 358 // 表示順序 359 $order = "A.create_date DESC";359 $order = 'A.create_date DESC'; 360 360 $objQuery->setOrder($order); 361 361 //検索結果の取得 362 362 //レビュー情報のカラムの取得 363 $col = "review_id, A.product_id, reviewer_name, sex, recommend_level, ";364 $col .= "reviewer_url, title, comment, A.status, A.create_date, A.update_date, name";365 $from = "dtb_review AS A LEFT JOIN dtb_products AS B ON A.product_id = B.product_id ";363 $col = 'review_id, A.product_id, reviewer_name, sex, recommend_level, '; 364 $col .= 'reviewer_url, title, comment, A.status, A.create_date, A.update_date, name'; 365 $from = 'dtb_review AS A LEFT JOIN dtb_products AS B ON A.product_id = B.product_id '; 366 366 $arrReview = $objQuery->select($col, $from, $where, $arrval); 367 367
Note: See TracChangeset
for help on using the changeset viewer.