140 lines
4.5 KiB
PHP
140 lines
4.5 KiB
PHP
<?php
|
|
|
|
namespace Tests\Trigger\Shop;
|
|
|
|
use UnitTester;
|
|
use Webkul\Category\Models\Category;
|
|
use Faker\Factory;
|
|
use Illuminate\Support\Facades\DB;
|
|
use Webkul\Category\Models\CategoryTranslation;
|
|
use Webkul\Core\Models\Locale;
|
|
|
|
class DatabaseLogicCest
|
|
{
|
|
private $faker;
|
|
|
|
/** @var Locale $localeEn */
|
|
private $localeEn;
|
|
|
|
/** @var Locale $localeDe */
|
|
private $localeDe;
|
|
|
|
public function _before(UnitTester $I)
|
|
{
|
|
$this->faker = Factory::create();
|
|
|
|
$this->localeEn = $I->grabRecord(Locale::class, [
|
|
'code' => 'en',
|
|
]);
|
|
|
|
$this->localeDe = $I->have(Locale::class, [
|
|
'code' => 'de',
|
|
'name' => 'German',
|
|
]);
|
|
|
|
$I->assertNotNull($this->localeDe);
|
|
}
|
|
|
|
public function testGetUrlPathOfCategory(UnitTester $I)
|
|
{
|
|
$rootCategoryTranslation = $I->grabRecord(CategoryTranslation::class, [
|
|
'slug' => 'root',
|
|
'locale' => 'en',
|
|
]);
|
|
|
|
$rootCategory = $I->grabRecord(Category::class, [
|
|
'id' => $rootCategoryTranslation->category_id,
|
|
]);
|
|
|
|
$parentCategoryName = $this->faker->word;
|
|
|
|
$parentCategoryAttributes = [
|
|
'parent_id' => $rootCategory->id,
|
|
'position' => 1,
|
|
'status' => 1,
|
|
$this->localeEn->code => [
|
|
'name' => $parentCategoryName,
|
|
'slug' => strtolower($parentCategoryName),
|
|
'description' => $parentCategoryName,
|
|
'locale_id' => $this->localeEn->id,
|
|
],
|
|
$this->localeDe->code => [
|
|
'name' => $parentCategoryName,
|
|
'slug' => strtolower($parentCategoryName),
|
|
'description' => $parentCategoryName,
|
|
'locale_id' => $this->localeDe->id,
|
|
],
|
|
];
|
|
|
|
$parentCategory = $I->make(Category::class, $parentCategoryAttributes)
|
|
->first();
|
|
$rootCategory->prependNode($parentCategory);
|
|
$I->assertNotNull($parentCategory);
|
|
|
|
$categoryName = $this->faker->word;
|
|
$categoryAttributes = [
|
|
'position' => 1,
|
|
'status' => 1,
|
|
'parent_id' => $parentCategory->id,
|
|
$this->localeEn->code => [
|
|
'name' => $categoryName,
|
|
'slug' => strtolower($categoryName),
|
|
'description' => $categoryName,
|
|
'locale_id' => $this->localeEn->id,
|
|
],
|
|
$this->localeDe->code => [
|
|
'name' => $categoryName,
|
|
'slug' => strtolower($categoryName),
|
|
'description' => $categoryName,
|
|
'locale_id' => $this->localeDe->id,
|
|
],
|
|
];
|
|
|
|
$category = $I->make(Category::class, $categoryAttributes)
|
|
->first();
|
|
$parentCategory->prependNode($category);
|
|
$I->assertNotNull($category);
|
|
|
|
$sqlStoredFunction = 'SELECT get_url_path_of_category(:category_id, :locale_code) AS url_path;';
|
|
|
|
$urlPathQueryResult = DB::selectOne($sqlStoredFunction, [
|
|
'category_id' => $parentCategory->id,
|
|
'locale_code' => $this->localeEn->code,
|
|
]);
|
|
$I->assertNotNull($urlPathQueryResult->url_path);
|
|
$I->assertEquals(strtolower($parentCategoryName), $urlPathQueryResult->url_path);
|
|
|
|
$urlPathQueryResult = DB::selectOne($sqlStoredFunction, [
|
|
'category_id' => $category->id,
|
|
'locale_code' => $this->localeEn->code,
|
|
]);
|
|
$I->assertNotNull($urlPathQueryResult->url_path);
|
|
|
|
$expectedUrlPath = strtolower($parentCategoryName) . '/' . strtolower($categoryName);
|
|
$I->assertEquals($expectedUrlPath, $urlPathQueryResult->url_path);
|
|
|
|
$root2Category = $I->make(Category::class, [
|
|
'position' => 1,
|
|
'status' => 1,
|
|
'parent_id' => null,
|
|
$this->localeEn->code => [
|
|
'name' => $this->faker->word,
|
|
'slug' => strtolower($this->faker->word),
|
|
'description' => $this->faker->word,
|
|
'locale_id' => $this->localeEn->id,
|
|
],
|
|
])
|
|
->first();
|
|
$root2Category->save();
|
|
|
|
$I->assertNull($root2Category->refresh()->parent_id);
|
|
|
|
$urlPathQueryResult = DB::selectOne($sqlStoredFunction, [
|
|
'category_id' => $root2Category->id,
|
|
'locale_code' => $this->localeEn->code,
|
|
]);
|
|
$I->assertNotNull($urlPathQueryResult->url_path);
|
|
$I->assertEquals('', $urlPathQueryResult->url_path);
|
|
}
|
|
}
|