<?php

namespace App\Console\Commands;

use App\Models\ChatLib;
use App\Models\ChatLog;
use Illuminate\Console\Command;

class ChatlibDatabase extends Command {

	/**
	 * The name and signature of the console command.
	 *
	 * @var string
	 */
	protected $signature = 'chatlib:database';

	/**
	 * The console command description.
	 *
	 * @var string
	 */
	protected $description = 'Updates the ChatLib database';

	/**
	 * Execute the console command.
	 *
	 * @return int
	 */
	public function handle() {
		$count = 0;

		$de = new ChatLib();
		$en = new ChatLib();

		ChatLog::where('type', '=', 'chat')
			->where('banned', '=', false)
			->whereNotNull('evaluated_at')
			->where('created_at', '<', now()->sub(7, 'day'))
			->whereNotIn('classification', ['gg', 'gl', 'number', 'o7'])
			->whereRaw('LENGTH(`text_content`) > 12')
			->chunk(5000, function ($msgs) use (&$count, $de, $en) {
				foreach ($msgs as $msg) {
					if ($msg->detected_language === 'de') {
						$de->addMessage($msg);
					} else if ($msg->detected_language === 'en') {
						$en->addMessage($msg);
					} else if (is_null($msg->detected_language)) {
						$de->addMessage($msg);
						$en->addMessage($msg);
					}
					++$count;
				}
				$this->line($count);
			});

		$de->compile();
		$de->saveAs('de');

		$en->compile();
		$en->saveAs('en');

		return 0;
	}

}

?>