Changeset 21402 for branches/version-2_11-dev/test/createEcCubeData-v25.php
- Timestamp:
- 2012/01/17 16:15:39 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_11-dev/test/createEcCubeData-v25.php
r21385 r21402 300 300 $sqlval['class_id'] = $this->objQuery->nextVal("dtb_class_class_id"); 301 301 $sqlval['name'] = $class_name; 302 $ arrRaw['rank'] = "(SELECT x.rank FROM (SELECT CASE302 $sqlval['rank'] = "~(SELECT x.rank FROM (SELECT CASE 303 303 WHEN max(rank) + 1 IS NULL THEN 1 304 304 ELSE max(rank) + 1 305 305 END as rank 306 306 FROM dtb_class 307 WHERE del_flg = 0) as x) ";307 WHERE del_flg = 0) as x),"; 308 308 $sqlval['creator_id'] = 2; 309 309 $sqlval['create_date'] = 'CURRENT_TIMESTAMP'; 310 310 $sqlval['update_date'] = 'CURRENT_TIMESTAMP'; 311 311 $sqlval['del_flg'] = (string) "0"; 312 $this->objQuery->insert("dtb_class", $sqlval , $arrRaw);312 $this->objQuery->insert("dtb_class", $sqlval); 313 313 314 314 $this->arrclass_id[] = $sqlval['class_id']; … … 326 326 $sqlval['name'] = $classcategory_name; 327 327 $sqlval['class_id'] = $class_id; 328 $ arrRaw['rank'] = sprintf("~(SELECT x.rank FROM (SELECT CASE328 $sqlval['rank'] = sprintf("~(SELECT x.rank FROM (SELECT CASE 329 329 WHEN max(rank) + 1 IS NULL THEN 1 330 330 ELSE max(rank) + 1 … … 332 332 FROM dtb_classcategory 333 333 WHERE del_flg = 0 334 AND class_id = %d) as x) ", $class_id);334 AND class_id = %d) as x),", $class_id); 335 335 $sqlval['creator_id'] = 2; 336 336 $sqlval['create_date'] = 'CURRENT_TIMESTAMP'; … … 338 338 $sqlval['del_flg'] = (string) "0"; 339 339 340 $this->objQuery->insert("dtb_classcategory", $sqlval , $arrRaw);340 $this->objQuery->insert("dtb_classcategory", $sqlval); 341 341 342 342 switch ($class_name) {
Note: See TracChangeset
for help on using the changeset viewer.