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(); }