this.lfMovieER.createQueryBuilder('m')
.setParameter('userID', 82)
.leftJoin(
LfUserDetailEntity,
'uD',
'm.id = uD.movie_id AND uD.user_id = :userID'
)@Module({
controllers: [AppController],
providers: [
Test1Service,
{
provide: 'BLOG',
useValue: new Test2Service('blog'),
},
{
provide: 'ANALYTICS',
useValue: new Test2Service('analytics'),
}
],
})
export class AppModule {}@Injectable()
export class Test1Service {
constructor(
@Inject('BLOG') public testBlog: Test2Service,
@Inject('ANALYTICS') public testAnalytics: Test2Service
) {}
getIndex() {
this.testBlog.getIndex()
this.testAnalytics.getIndex()
}
}const query = getConnection()
.createQueryBuilder()
.select('title')
.addSelect(qb => qb
.select('name')
.from(AuthorsEntity, 'aut')
.leftJoin(ArticlesEntity, 'art1', 'aut.id = art1.author_id')
.where('art1.id = art.id'),
'name'
)
.from(ArticlesEntity, 'art');
return query.getRawMany();<div class="row">
<div class="col-md-12">
<div class="d-flex justify-content-between">
<h4>MicroWallets</h4>
<button class="btn btn-success mt-2"><i class="bi bi-plus"></i></button>
</div>
</div>
</div>scales: {
x: {
ticks: {
callback: function(value, index, values) {
return `<span>${ value.month }</span> ${ value.year }`;
}
}
}
}SELECT t1.priority, t1.today, COALESCE(t2.yesterday, 0) AS yesterday
FROM
(SELECT priority, COUNT(*) AS 'today' FROM ... WHERE time >= '2021-06-03 00:00:00' AND time <= '2021-06-03 23:59:59' GROUP BY priority) t1
LEFT JOIN
(SELECT priority, COUNT(*) AS 'yesterday' FROM ... WHERE time >= '2021-06-03 00:00:00' AND time <= '2021-06-03 23:59:59' GROUP BY priority) t2
ON (t1.priority = t2.priority);@Column({
type: 'date',
name: 'time'
})
time: string;/**
* Force date types (TIMESTAMP, DATETIME, DATE) to be returned as strings rather then inflated into JavaScript Date objects.
* Can be true/false or an array of type names to keep as strings.
*/
readonly dateStrings?: boolean | string[];<template>
<NuxtLink :to="to" class="go-away" to="/">
<BaseIconArrowLeft class="go-away__icon" />
<slot />
</NuxtLink>
</template>
<script>
...
props: {
to: {
type: String,
default: '#'
}
}
...
</script><GoAway to="/timetable">
<BaseH1 class="blue">Расписание</BaseH1>
</GoAway>