Code archive for MyLibrary/Functions.php

Functions-658.php

/*
    public static function leafNode() {
      $allCats = Categories::all()->toArray();
      for ( $i = 0; $i < count($allCats); $i++) {
        $children = DB::table('categoryOrganisations')->where('categoryId', $allCats[$i]['id'])->count();
        if($children === 0) {
          DB::table('categories')->where('id', $allCats[$i]['id'])->update(['leaf' => 1]);
        } else {
          DB::table('categories')->where('id', $allCats[$i]['id'])->update(['leaf' => 0]);
        }
      }
    }
    public static function build_hierarchy() {
      $allCats = Categories::all()->toArray();
      for($i = 0; $i < count($allCats); $i++) {
        $hier = '';
        if ($allCats[$i]['hierarchy'] === NULL && $allCats[$i]['ParentId'] === NULL) {
          DB::table('categories')->where('id', $allCats[$i]['id'])->update(['hierarchy' => $allCats[$i]['title']]);
          $hier = $allCats[$i]['title'];
        } else {
          $hier = $allCats[$i]['hierarchy'];
        }
        $children = DB::table('categoryOrganisations')->where('categoryId', $allCats[$i]['id'])->get();
        for ($h = 0; $h < count($children); $h++) {
          $subCat = DB::table('categories')->where('id', $children[$h]->SubCategoryId)->first();
          DB::table('categories')->where('id', $children[$h]->SubCategoryId)->update(['hierarchy' => $hier .' / '. $subCat->title]);
        }


      }
    }
    */