Changeset 17880
- Timestamp:
- 2009/03/06 21:07:35 (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/comu-ver2/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSVCategory.php
r17503 r17880 168 168 169 169 if (!$err) echo $line." / ".$rec_count. "行目 (カテゴリID:".$arrParam['category_id']." / カテゴリ名:".$arrParam['category_name'].")\n<br />"; 170 flush();170 SC_Utils_Ex::sfFlush(); 171 171 } 172 172 fclose($fp); … … 187 187 } 188 188 echo "<br/><a href=\"javascript:window.close()\">→閉じる</a>"; 189 flush();190 189 exit; 191 break;192 190 default: 193 191 break; … … 238 236 239 237 $objDb = new SC_Helper_DB_Ex(); 240 $ arrRet['category_id'] = $arrCSV[0];241 $ arrRet['category_name'] = $arrCSV[1];242 $ arrRet['parent_category_id'] = $arrCSV[2];238 $sqlval['category_id'] = $arrCSV[0]; 239 $sqlval['category_name'] = $arrCSV[1]; 240 $sqlval['parent_category_id'] = strlen($arrCSV[2]) ? $arrCSV[2] : 0; 243 241 244 242 //存在確認 245 $count = $objQuery->count("dtb_category","category_id = ?",array($arrRet['category_id'])); 246 if($count == 0){ 247 $update = false; 248 }else if($count == 1){ 249 $update = true; 250 }else{ 251 echo "ERROR"; 252 return; 253 } 254 $sqlval['category_id'] = $arrRet['category_id']; 255 // カテゴリ名 256 $sqlval['category_name'] = $arrRet['category_name']; 243 $count = $objQuery->count("dtb_category","category_id = ?",array($sqlval['category_id'])); 244 $update = $count != 0; 257 245 258 246 // 親カテゴリID、レベル 259 if ($arrRet['parent_category_id'] == 0) { 260 $sqlval['parent_category_id'] = "0"; 247 if ($sqlval['parent_category_id'] == 0) { 261 248 $sqlval['level'] = 1; 262 249 } else { 263 $sqlval['parent_category_id'] = $arrRet['parent_category_id'];264 250 $parent_level = $objQuery->get("dtb_category", "level", "category_id = ?", array($sqlval['parent_category_id'])); 265 251 $sqlval['level'] = $parent_level + 1; … … 277 263 // 更新 278 264 if ($update) { 279 echo " UPDATE";265 echo "更新 "; 280 266 $where = "category_id = ?"; 281 267 $objQuery->update("dtb_category", $sqlval, $where, array($sqlval['category_id'])); … … 283 269 // 新規登録 284 270 } else { 285 echo " INSERT";271 echo "登録 "; 286 272 $sqlval['create_date'] = $time; 287 // var_dump($sqlval);288 273 // ランク 289 274 if ($sqlval['parent_category_id'] == 0) { … … 296 281 $sqlval['rank'] = $objQuery->get("dtb_category", "rank", $where, array($sqlval['parent_category_id'])); 297 282 // 追加レコードのランク以上のレコードを一つあげる。 298 $sqlup = "UPDATE dtb_category SET rank = (rank + 1)WHERE rank >= ?";283 $sqlup = "UPDATE dtb_category SET rank = rank + 1 WHERE rank >= ?"; 299 284 $objQuery->exec($sqlup, array($sqlval['rank'])); 300 285 301 286 } 302 287 $objQuery->insert("dtb_category", $sqlval); 303 $objQuery->getLastQuery();304 288 } 305 289 }
Note: See TracChangeset
for help on using the changeset viewer.