"use strict";
var __decorate = (this && this.__decorate) || function (decorators, target, key, desc) {
    var c = arguments.length, r = c < 3 ? target : desc === null ? desc = Object.getOwnPropertyDescriptor(target, key) : desc, d;
    if (typeof Reflect === "object" && typeof Reflect.decorate === "function") r = Reflect.decorate(decorators, target, key, desc);
    else for (var i = decorators.length - 1; i >= 0; i--) if (d = decorators[i]) r = (c < 3 ? d(r) : c > 3 ? d(target, key, r) : d(target, key)) || r;
    return c > 3 && r && Object.defineProperty(target, key, r), r;
};
var __metadata = (this && this.__metadata) || function (k, v) {
    if (typeof Reflect === "object" && typeof Reflect.metadata === "function") return Reflect.metadata(k, v);
};
var __param = (this && this.__param) || function (paramIndex, decorator) {
    return function (target, key) { decorator(target, key, paramIndex); }
};
Object.defineProperty(exports, "__esModule", { value: true });
exports.PersonService = void 0;
const common_1 = require("@nestjs/common");
const typeorm_1 = require("@nestjs/typeorm");
const person_entity_1 = require("./entities/person.entity");
const typeorm_2 = require("typeorm");
let PersonService = class PersonService {
    personRepo;
    constructor(personRepo) {
        this.personRepo = personRepo;
    }
    create(createPersonDto) {
        return 'This action adds a new person';
    }
    findAll() {
        return this.personRepo.query(`
      SELECT p.*, COUNT(distinct pv.id) verseCount, GROUP_CONCAT(distinct pc.cat) cats
      FROM person p
      LEFT JOIN verse_person pv ON pv.person = p.id
      LEFT JOIN person_category pc ON pc.personId = p.id
      WHERE
        p.status = 1
      GROUP BY p.id
    `);
    }
    async findOne(id, loadVerses = false) {
        let relations = loadVerses ? ['verses'] : undefined;
        return await this.personRepo.findOne({ where: { id }, relations });
    }
    async update(id, updatePersonDto) {
        let cats = updatePersonDto.cats;
        delete updatePersonDto.cats;
        if (cats instanceof Array) {
            await this.personRepo.query(`delete from person_category where personId=${id};`);
            if (cats.length) {
                let values = cats.map(cat => `(${id}, ${+cat})`).join(',');
                await this.personRepo.query(`insert into person_category (personId, cat) values ${values};`);
            }
        }
        return this.personRepo.update({ id }, updatePersonDto);
    }
    remove(id) {
        return `This action removes a #${id} person`;
    }
};
exports.PersonService = PersonService;
exports.PersonService = PersonService = __decorate([
    (0, common_1.Injectable)(),
    __param(0, (0, typeorm_1.InjectRepository)(person_entity_1.Person)),
    __metadata("design:paramtypes", [typeorm_2.Repository])
], PersonService);
//# sourceMappingURL=person.service.js.map