Changeset 21481 for branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products_Class.php
- Timestamp:
- 2012/02/11 05:48:00 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products_Class.php
r21480 r21481 145 145 function lfInitParam(&$objFormParam) { 146 146 $objFormParam->addParam("規格名", 'name', STEXT_LEN, 'KVa', array('EXIST_CHECK' ,'SPTAB_CHECK' ,'MAX_LENGTH_CHECK')); 147 $objFormParam->addParam("規格ID", "class_id", INT_LEN, 'n', array('NUM_CHECK'));147 $objFormParam->addParam("規格ID", 'class_id', INT_LEN, 'n', array('NUM_CHECK')); 148 148 } 149 149 … … 159 159 $where = "del_flg <> 1"; 160 160 $objQuery->setOrder("rank DESC"); 161 $arrClass = $objQuery->select("name, class_id", "dtb_class", $where);161 $arrClass = $objQuery->select("name, class_id", 'dtb_class', $where); 162 162 return $arrClass; 163 163 } … … 172 172 $objQuery =& SC_Query_Ex::getSingletonInstance(); 173 173 $where = "class_id = ?"; 174 $class_name = $objQuery->get('name', "dtb_class", $where, array($class_id));174 $class_name = $objQuery->get('name', 'dtb_class', $where, array($class_id)); 175 175 return $class_name; 176 176 } … … 187 187 $sqlval['name'] = $arrForm['name']; 188 188 $sqlval['creator_id'] = $_SESSION['member_id']; 189 $sqlval['rank'] = $objQuery->max('rank', "dtb_class") + 1;189 $sqlval['rank'] = $objQuery->max('rank', 'dtb_class') + 1; 190 190 $sqlval['create_date'] = 'CURRENT_TIMESTAMP'; 191 191 $sqlval['update_date'] = 'CURRENT_TIMESTAMP'; 192 192 // INSERTの実行 193 193 $sqlval['class_id'] = $objQuery->nextVal('dtb_class_class_id'); 194 $ret = $objQuery->insert( "dtb_class", $sqlval);194 $ret = $objQuery->insert('dtb_class', $sqlval); 195 195 return $ret; 196 196 } … … 209 209 $where = "class_id = ?"; 210 210 // UPDATEの実行 211 $ret = $objQuery->update( "dtb_class", $sqlval, $where, array($arrForm['class_id']));211 $ret = $objQuery->update('dtb_class', $sqlval, $where, array($arrForm['class_id'])); 212 212 return $ret; 213 213 } … … 224 224 $objQuery =& SC_Query_Ex::getSingletonInstance(); 225 225 226 $objDb->sfDeleteRankRecord( "dtb_class", "class_id", $class_id, "", true);226 $objDb->sfDeleteRankRecord('dtb_class', 'class_id', $class_id, "", true); 227 227 $where= "class_id = ?"; 228 $ret = $objQuery->delete( "dtb_classcategory", $where, array($class_id));228 $ret = $objQuery->delete('dtb_classcategory', $where, array($class_id)); 229 229 return $ret; 230 230 } … … 248 248 249 249 $where = "del_flg = 0 AND name = ?"; 250 $arrClass = $objQuery->select("class_id, name", "dtb_class", $where, array($arrForm['name']));250 $arrClass = $objQuery->select("class_id, name", 'dtb_class', $where, array($arrForm['name'])); 251 251 // 編集中のレコード以外に同じ名称が存在する場合 252 252 if ($arrClass[0]['class_id'] != $arrForm['class_id'] && $arrClass[0]['name'] == $arrForm['name']) { … … 278 278 function lfUpRank($class_id) { 279 279 $objDb = new SC_Helper_DB_Ex(); 280 $objDb->sfRankUp( "dtb_class", "class_id", $class_id);280 $objDb->sfRankUp('dtb_class', 'class_id', $class_id); 281 281 } 282 282 /** … … 288 288 function lfDownRank($class_id) { 289 289 $objDb = new SC_Helper_DB_Ex(); 290 $objDb->sfRankDown( "dtb_class", "class_id", $class_id);290 $objDb->sfRankDown('dtb_class', 'class_id', $class_id); 291 291 } 292 292 }
Note: See TracChangeset
for help on using the changeset viewer.