<?php

namespace AdFuz\Models;

use AdFuz\Database\DB;
if ( ! defined( 'ABSPATH' ) ) {
	exit;
}
class CampaignAd extends AbstractModel {


	public const TABLE = 'adfuz_campaign_ads';


	public static function schema(): array {
		return array(
			'id'            => array(
				'type' => 'bigint',
			),
			'campaign_id'   => array(
				'type'     => 'bigint',
				'required' => true,
			),
			'ad_id'         => array(
				'type'     => 'bigint',
				'required' => true,
			),
			'display_order' => array(
				'type'    => 'int',
				'default' => 0,
			),
			'created_at'    => array(
				'type'     => 'datetime',
				'nullable' => true,
			),
			'updated_at'    => array(
				'type'     => 'datetime',
				'nullable' => true,
			),
		);
	}

	public static function table() {
		return static::TABLE;
	}

	/**
	 * Count how many campaign_ads rows exist for a given ad.
	 * Used before delete to warn the user.
	 */
	public static function countByAd( int $adId ): int {
		return DB::get( static::TABLE )
				->where( 'ad_id', $adId )
				->count();
	}

	/**
	 * Delete all campaign_ads rows for a given ad.
	 * Called after the user confirms deletion.
	 */
	public static function deleteByAd( int $adId ): int|false {
		return DB::get( static::TABLE )
				->where( 'ad_id', $adId )
				->delete();
	}
}