/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('shipment_carriers_countries', function (Blueprint $table) {
$table->bigInteger('carrier_id')->unsigned();
$table->bigInteger('country_id')->unsigned();
$table->foreign('carrier_id')->references('id')->on(Carrier::getTableName())->onDelete('cascade');
$table->foreign('country_id')->references('id')->on(Country::getTableName())->onDelete('cascade');
$table->primary(['carrier_id', 'country_id']);
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create(CarrierService::getTableName(), function (Blueprint $table) {
$table->bigIncrements('id');
$table->bigInteger('carrier_id')->unsigned();
$table->string('name');
$table->string('code');
$table->string('description')->nullable();
$table->tinyInteger('delivery_time')->default(1);
$table->tinyInteger('status')->default(1);
$table->timestamps();
$table->index(['name']);
$table->index(['carrier_id', 'code']);
$table->foreign('carrier_id')->references('id')->on(Carrier::getTableName())->onDelete('cascade');
});
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$this->command->info('Start carrier seeder!');
$config = ['url' => 'http://ws.correios.com.br/calculador/CalcPrecoPrazo.asmx?WSDL', 'company' => '', 'password' => '', 'postalCodeOrigin' => '05346000', 'format' => '1', 'ownHands' => '5', 'deliveryNotification' => 'N'];
$carrier = Carrier::create(['name' => 'Correios', 'code' => 'CO', 'model_reference' => '\\App\\Services\\Shipment\\Shippers\\PostOffice', 'config' => json_encode($config)]);
$services = $carrier->hasMany('App\\Models\\CarrierService');
$services->saveMany([new CarrierService(['code' => 40010, 'delivery_time' => 8, 'name' => 'SEDEX', 'description' => '', 'status' => 1]), new CarrierService(['code' => 40045, 'delivery_time' => 1, 'name' => 'SEDEX a Cobrar', 'description' => '', 'status' => 1]), new CarrierService(['code' => 40215, 'delivery_time' => 1, 'name' => 'SEDEX 10, sem contrato', 'description' => '', 'status' => 1]), new CarrierService(['code' => 40290, 'delivery_time' => 1, 'name' => 'SEDEX Hoje, sem contrato', 'description' => '', 'status' => 0]), new CarrierService(['code' => 41068, 'delivery_time' => 1, 'name' => 'PAC', 'description' => '', 'status' => 0]), new CarrierService(['code' => 41106, 'delivery_time' => 1, 'name' => 'PAC, sem contrato', 'description' => '', 'status' => 1]), new CarrierService(['code' => 81019, 'delivery_time' => 5, 'name' => 'e-SEDEX', 'description' => '', 'status' => 0])]);
$country = Country::find(30);
$countries = $carrier->belongsToMany('App\\Models\\Country', 'shipment_carriers_countries', 'carrier_id', 'country_id');
$countries->attach($country->id);
$carrierTest = Carrier::create(['name' => 'Flat Rate Shipping', 'code' => 'FRS', 'model_reference' => '\\App\\Services\\Shipment\\Shippers\\FlatRateShipping']);
$services = $carrierTest->hasMany('App\\Models\\CarrierService');
$services->saveMany([new CarrierService(['code' => 'FRS', 'delivery_time' => 10, 'name' => 'Default', 'description' => '', 'status' => 1])]);
$allCountry = Country::all();
$countries = $carrierTest->belongsToMany('App\\Models\\Country', 'shipment_carriers_countries', 'carrier_id', 'country_id');
foreach ($allCountry as $country) {
$countries->attach($country->id);
}
$this->command->info('Carrier table seeded!');
}
public function __construct(App $app)
{
parent::__construct($app);
$this->tableCarriers = Carrier::getTableName();
$this->tableCountry = $this->getModel()->getTableName();
}
public function allWithCountry(Country $country)
{
$query = $this->getModel()->newQuery()->select(Carrier::getTableName() . '.*')->join('shipment_carriers_countries', 'shipment_carriers_countries.carrier_id', '=', Carrier::getTableName() . '.id')->join(Country::getTableName(), 'shipment_carriers_countries.country_id', '=', Country::getTableName() . '.id')->where(Country::getTableName() . '.id', $country->id);
$key = md5($query->toSql() . $country->id);
return $this->cacheQueryBuilder($key, $query);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
if (Schema::hasTable(Carrier::getTableName())) {
Schema::drop(Carrier::getTableName());
}
}