public function testSaveDelete()
{
RoyaltyType::truncate();
$rp = new RoyaltyType();
$rp->royalty_type_name = "testname";
$rp->save();
$this->assertTrue($rp->id != 0);
$this->assertTrue($rp->created != null);
$this->assertTrue($rp->updated != null);
// $this->assertTrue($rp["deleted"] == 0);
$rp->delete();
$this->assertTrue($rp->deleted == 1);
RoyaltyType::truncate();
}
public function run()
{
DB::table('royalty_types')->truncate();
foreach (['Mechanical', 'Performance', 'Synchronization', 'Print', 'Digital', 'Audio Home Recording', 'Youtube', 'Google'] as $name) {
RoyaltyType::create(['royalty_type_name' => $name]);
}
}
public static function boot()
{
parent::boot();
RoyaltyType::deleting(function ($royaltyType) {
$royaltyType->deleted = 1;
$royaltyType->update();
});
}
public static function apiProviders($id)
{
$query = self::query();
return $query->select('royalty_provider.id as id', 'royalty_provider.royalty_provider_name as provider', 'royalty_share.royalty_share_name as share', 'royalty_type.royalty_type_name as type')->join(RoyaltyStreamFile::table() . " as royalty_stream_file", 'royalty_stream_file.deal_id', '=', 'deal_id')->join(RoyaltyProvider::table() . " as royalty_provider", 'royalty_provider.id', '=', 'royalty_provider_id')->join(RoyaltyShare::table() . " as royalty_share", 'royalty_share.id', '=', 'royalty_share_id')->join(RoyaltyType::table() . " as royalty_type", 'royalty_type.id', '=', 'royalty_type_id')->groupBy('royalty_provider.royalty_provider_name', 'royalty_share.royalty_share_name', 'royalty_type.royalty_type_name')->where('deal_id', $id)->get();
}
