Commitb7de0cc

authored

feat: Add filter "Has Actor In Watchlist" (#1657)

1 parentbab4072 commitb7de0ccCopy full SHA for b7de0cc

File tree

-0

lines changed

-0

lines changed

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -387,6 +387,7 @@ func (i SceneResource) getFilters(req restful.Request, resp restful.Response)`
`387`	`387`	`outAttributes=append(outAttributes,"Has AI Generated Script")`
`388`	`388`	`outAttributes=append(outAttributes,"Has Human Generated Script")`
`389`	`389`	`outAttributes=append(outAttributes,"Has Favourite Actor")`
	`390`	`+outAttributes=append(outAttributes,"Has Actor in Watchlist")`
`390`	`391`	`outAttributes=append(outAttributes,"Available from Alternate Sites")`
`391`	`392`	`outAttributes=append(outAttributes,"Available from POVR")`
`392`	`393`	`outAttributes=append(outAttributes,"Available from VRPorn")`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -907,6 +907,8 @@ func queryScenes(db gorm.DB, r RequestSceneList) (gorm.DB, *gorm.DB) {`
`907`	`907`	`}`
`908`	`908`	`case"Has Favourite Actor":`
`909`	`909`	`where="exists (select * from scene_cast join actors on actors.id=scene_cast.actor_id where actors.favourite=1 and scene_cast.scene_id=scenes.id)"`
	`910`	`+case"Has Actor in Watchlist":`
	`911`	`+where="exists (select * from scene_cast join actors on actors.id=scene_cast.actor_id where actors.watchlist=1 and scene_cast.scene_id=scenes.id)"`
`910`	`912`	`case"Available from POVR":`
`911`	`913`	`where="exists (select 1 from external_reference_links where external_source like 'alternate scene %' and external_id like 'povr-%' and internal_db_id = scenes.id)"`
`912`	`914`	`case"Available from VRPorn":`

Comments

(0)