Changeset 21514 for branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ReviewEdit.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_ReviewEdit.php
r21481 r21514 120 120 // 検索条件のパラメーターを初期化 121 121 parent::lfInitParam($objFormParam); 122 $objFormParam->addParam( "レビューID", 'review_id', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));123 $objFormParam->addParam( "商品名", 'name', "", "", array(), "", false);124 $objFormParam->addParam( "投稿日", 'create_date', "", "", array(), "", false);122 $objFormParam->addParam('レビューID', 'review_id', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 123 $objFormParam->addParam('商品名', 'name', "", "", array(), "", false); 124 $objFormParam->addParam('投稿日', 'create_date', "", "", array(), "", false); 125 125 126 126 // 登録情報 127 $objFormParam->addParam( "レビュー表示", 'status', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));128 $objFormParam->addParam( "投稿者名", 'reviewer_name', STEXT_LEN, 'KVa', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK'));129 $objFormParam->addParam( "投稿者URL", 'reviewer_url', URL_LEN, 'KVCa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK'));130 $objFormParam->addParam( "性別", 'sex', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));131 $objFormParam->addParam( "おすすめレベル", 'recommend_level', INT_LEN, 'n', array('SELECT_CHECK'));132 $objFormParam->addParam( "タイトル", 'title', STEXT_LEN, 'KVa', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK'));133 $objFormParam->addParam( "コメント", 'comment', LTEXT_LEN, 'KVa', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK'));127 $objFormParam->addParam('レビュー表示', 'status', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 128 $objFormParam->addParam('投稿者名', 'reviewer_name', STEXT_LEN, 'KVa', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 129 $objFormParam->addParam('投稿者URL', 'reviewer_url', URL_LEN, 'KVCa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 130 $objFormParam->addParam('性別', 'sex', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 131 $objFormParam->addParam('おすすめレベル', 'recommend_level', INT_LEN, 'n', array('SELECT_CHECK')); 132 $objFormParam->addParam('タイトル', 'title', STEXT_LEN, 'KVa', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 133 $objFormParam->addParam('コメント', 'comment', LTEXT_LEN, 'KVa', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 134 134 } 135 135 … … 155 155 function lfGetReviewData($review_id) { 156 156 $objQuery =& SC_Query_Ex::getSingletonInstance(); 157 $select= "review_id, A.product_id, reviewer_name, sex, recommend_level, ";158 $select.= "reviewer_url, title, comment, A.status, A.create_date, A.update_date, name";159 $from = "dtb_review AS A LEFT JOIN dtb_products AS B ON A.product_id = B.product_id ";160 $where = "A.del_flg = 0 AND B.del_flg = 0 AND review_id = ? ";157 $select='review_id, A.product_id, reviewer_name, sex, recommend_level, '; 158 $select.='reviewer_url, title, comment, A.status, A.create_date, A.update_date, name'; 159 $from = 'dtb_review AS A LEFT JOIN dtb_products AS B ON A.product_id = B.product_id '; 160 $where = 'A.del_flg = 0 AND B.del_flg = 0 AND review_id = ? '; 161 161 $arrReview = $objQuery->select($select, $from, $where, array($review_id)); 162 162 if (empty($arrReview)) { 163 SC_Utils_Ex::sfDispError( "");163 SC_Utils_Ex::sfDispError(''); 164 164 } 165 165 return $arrReview[0]; … … 177 177 $arrValues = $objFormParam->getDbArray(); 178 178 $arrValues['update_date'] = 'CURRENT_TIMESTAMP'; 179 $objQuery->update('dtb_review', $arrValues, "review_id = ?", array($review_id));179 $objQuery->update('dtb_review', $arrValues, 'review_id = ?', array($review_id)); 180 180 } 181 181 }
Note: See TracChangeset
for help on using the changeset viewer.