product
category
sale
sale_category
sale_productid
name
type (fixed, percent, formula)
value
start (datetime)
end (datetime)
$sql = "INSERT INTO table (name, text, message, date, rating) VALUES (?,?,?,?)";
$stmt = $link->prepare($sql);
$stmt->bind_param("sssss", $name, $text, $message, $date);
$stmt->execute();$sql = "INSERT INTO table (name, text, message, date, rating) VALUES (?,?,?,?)";
$stmt = $link->prepare($sql);
$stmt->execute([$name, $text, $message, $date]);
<?php
$model = \App\Models\Building::where('id', 1)->with('street.settlement.subregion.region.country')->first();
echo $model->address;<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
class Building extends Model
{
public function street()
{
return $this->belongsTo('App\Models\Street');
}
public function getAddressAttribute()
{
$parts = [
$this->street->settlement->subregion->region->country->title,
$this->street->settlement->subregion->region->title,
$this->street->settlement->subregion->title,
$this->street->settlement->title,
$this->street->title,
$this->title,
];
return join(', ', $parts);
}
}<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
class Street extends Model
{
public function settlement()
{
return $this->belongsTo('App\Models\Settlement');
}
}<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
class Settlement extends Model
{
public function subregion()
{
return $this->belongsTo('App\Models\Subregion');
}
}<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
class Subregion extends Model
{
public function region()
{
return $this->belongsTo('App\Models\Region');
}
}<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
class Region extends Model
{
public function country()
{
return $this->belongsTo('App\Models\Country');
}
}<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
class Country extends Model
{
}DROP TABLE IF EXISTS `buildings`;
CREATE TABLE `buildings` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`street_id` int DEFAULT NULL,
`title` varchar(255) COLLATE utf8mb4_ru_0900_ai_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_ru_0900_ai_ci;
DROP TABLE IF EXISTS `countries`;
CREATE TABLE `countries` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8mb4_ru_0900_ai_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_ru_0900_ai_ci;
DROP TABLE IF EXISTS `regions`;
CREATE TABLE `regions` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`country_id` int DEFAULT NULL,
`title` varchar(255) COLLATE utf8mb4_ru_0900_ai_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_ru_0900_ai_ci;
DROP TABLE IF EXISTS `settlements`;
CREATE TABLE `settlements` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`subregion_id` int DEFAULT NULL,
`title` varchar(255) COLLATE utf8mb4_ru_0900_ai_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_ru_0900_ai_ci;
DROP TABLE IF EXISTS `streets`;
CREATE TABLE `streets` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`settlement_id` int DEFAULT NULL,
`title` varchar(255) COLLATE utf8mb4_ru_0900_ai_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_ru_0900_ai_ci;
DROP TABLE IF EXISTS `subregions`;
CREATE TABLE `subregions` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`region_id` int DEFAULT NULL,
`title` varchar(255) COLLATE utf8mb4_ru_0900_ai_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_ru_0900_ai_ci;
INSERT INTO `buildings` (`id`, `street_id`, `title`) VALUES
('1', '1', '43');
INSERT INTO `countries` (`id`, `title`) VALUES
('1', 'Российская Федерация');
INSERT INTO `regions` (`id`, `country_id`, `title`) VALUES
('1', '1', 'Алтайский край');
INSERT INTO `settlements` (`id`, `subregion_id`, `title`) VALUES
('1', '1', 'г. Барнаул');
INSERT INTO `streets` (`id`, `settlement_id`, `title`) VALUES
('1', '1', 'ул. Пушкина');
INSERT INTO `subregions` (`id`, `region_id`, `title`) VALUES
('1', '1', 'Алтайский район');
$bestProductIds = Order::get()->map->products->flatten()->map->pivot->mapTogroups(function ($pivot) {
return [$pivot->product_id => $pivot->count];
})->map->sum()->sortDesc()->take(3)->keys()->toArray();
$bestProductIdsStr = implode(',', $bestProductIds);
$bestProducts = Product::whereIn('id', $bestProductIds)
->orderByRaw(DB::raw("FIELD(id, $bestProductIdsStr)"))
->get();
<component v-bind="props"></component>computed: {
props () {
const {ненужный_проп, ...props} = this.$props;
return props;
}
}