|
@@ 723-731 (lines=9) @@
|
| 720 |
|
return !Yii::app()->db->createCommand('SELECT COUNT(`id`) FROM `NestedSet` WHERE MOD(`lft`-`level`,2);')->queryScalar(); |
| 721 |
|
} |
| 722 |
|
|
| 723 |
|
private function checkTree4() |
| 724 |
|
{ |
| 725 |
|
$row=Yii::app()->db->createCommand('SELECT MIN(`lft`),MAX(`rgt`),COUNT(`id`) FROM `NestedSet`;')->queryRow(false); |
| 726 |
|
|
| 727 |
|
if($row[0]!=1 || $row[1]!=$row[2]*2) |
| 728 |
|
return false; |
| 729 |
|
|
| 730 |
|
return true; |
| 731 |
|
} |
| 732 |
|
|
| 733 |
|
private function checkArray($array) |
| 734 |
|
{ |
|
@@ 824-835 (lines=12) @@
|
| 821 |
|
return !Yii::app()->db->createCommand('SELECT COUNT(`id`) FROM `NestedSetWithManyRoots` WHERE MOD(`lft`-`level`,2) GROUP BY `root`;')->query()->getRowCount(); |
| 822 |
|
} |
| 823 |
|
|
| 824 |
|
private function checkTreeWithManyRoots4() |
| 825 |
|
{ |
| 826 |
|
$rows=Yii::app()->db->createCommand('SELECT MIN(`lft`),MAX(`rgt`),COUNT(`id`) FROM `NestedSetWithManyRoots` GROUP BY `root`;')->queryAll(false); |
| 827 |
|
|
| 828 |
|
foreach($rows as $row) |
| 829 |
|
{ |
| 830 |
|
if($row[0]!=1 || $row[1]!=$row[2]*2) |
| 831 |
|
return false; |
| 832 |
|
} |
| 833 |
|
|
| 834 |
|
return true; |
| 835 |
|
} |
| 836 |
|
|
| 837 |
|
private function checkArrayWithManyRoots($array) |
| 838 |
|
{ |