// 模型文件
public function children() {
return $this->hasMany(get_class($this), 'pid' ,'id');
}
public function allChildren() {
return $this->children()->with( 'allChildren' );
}
').appendTo(Box).find('select').bind('change',function(){obj.change(this)});
}
}
});
},//查询当前盒子中的信息
log:function(){
var BoxName=$(event).attr('pnode'); //获取触发事件者的pnode
var className=$(event).attr('cname');//获取触发事件者的cname
var Box =$("#"+BoxName); //获取所有插入盒子的对象
var eleClass=$("."+className); //获取所有Class所在元素组
console.log("容器名:"+BoxName+"\n 触发的class名:"+className);
},//第一个select框获取信息
getFirstElement:function(){
var main=$('#'+this.main);
$.get("http://127.0.0.1:83/areas",function(data){
var option="";
var list=data.data;
for(var key in list){
option+="";
}
main.html(option);
},'jsonp');
}
}
})(jQuery)
<?php
namespace App\Model;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Collection;
class Category extends Model
{
protected $table = ''category'';
protected $primaryKey=''CategoryID'';
public $timestamps=false;
//使用递归获取分类 （正式函数）
public function getCategory($sourceItems, $targetItems, $pid=0){
foreach ($sourceItems as $k => $v) {
if($v->pid == $pid){
$targetItems[] = $v;
$this->getCategory($sourceItems, $targetItems, $v->CateID);
}
}
}
//使用递归获取分类信息测试函数 （测试正式函数）
public function getCategoryTest($sourceItems, $targetItems, $pid=0, $str=''ㅣ''){
$str .= ''ㅡㅡ'';
foreach ($sourceItems as $k => $v) {
if($v->pid == $pid){
$v->CateName = $str.$v->CateName;
$targetItems[] = $v;
$this->getCategoryTest($sourceItems, $targetItems, $v->CateID, $str);
}
}
}
//使用递归获取分类信息 （正式函数）
public function getCategoryInfo(){
$sourceItems = $this->get();
$targetItems = new Collection;
$this->getCategory($sourceItems, $targetItems, 0);
return $targetItems;
}
//测试函数 （测试正式函数）
public function getCategoryInfoTest(){
$sourceItems = $this->get();
$targetItems = new Collection;
$this->getCategoryTest($sourceItems, $targetItems);
return $targetItems;
}
}
laravel ctroller层实现测试效果
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Http\Requests;
use Illuminate\Support\Facades\Input;
use Illuminate\Support\Facades\Validator;
use App\Model\Category;
use Illuminate\Database\Eloquent\Collection;
use DB;
class CategoryCtroller extends Controller
{
public function index(){
$category = new Category;
$items = $category->getCategoryInfoTest();
foreach ($items as $key => $item) {
dump($item->CateName);
}
}
}
访问相关的控制器就可看见要实现的无限分类的效果
Laravel 框架实现无限极分类
最近开发商品功能，在尝试递归和引用方式后，蓦然回首，突然发现 laravel 框架有更简单高效的实现方式，无限极分类最佳实践，open code 与大家共享！感兴趣的 Mark 一下，谢谢～
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateCategoryTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create(''categorys'', function (Blueprint $table) {
$table->increments(''id'');
$table->integer(''parent_id'');
$table->string(''code'');
$table->string(''name'');
$table->string(''path'');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists(''categorys'');
}
}
php artisan migrate
2、建Model 在app/Category.php
php artisan make: model Category -m
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Category extends Model
{
public function childCategory() {
return $this->hasMany(''App\Category'', ''parent_id'', ''id'');
}
public function allChildrenCategorys()
{
return $this->childCategory()->with(''allChildrenCategorys'');
}
}
