<?php

class addblacklist{
	private $db;
	
	function __construct(){
		global $datenbank;
		$this->db = $datenbank;
	}
	
	public function Liste(){
		$aus = '';
		$array = array();
		$query = "SELECT *,COUNT(tan) AS ges FROM ". PREFIX . BLACKLIST ." GROUP BY tan ORDER BY COUNT(tan) ASC";
		if($this->db->num_rows($query) > 0){
			foreach($this->db->get_results($query) AS $res){
				$row = $this->db->get_row("SELECT * FROM ". PREFIX . WERBUNG ." WHERE tan = '$res->tan' ",true);
				if($row->status == 1){ $status = '<div class="alert alert-success">Freigeschaltet</div>';}
				if($row->status == 2){ $status = '<div class="alert alert-danger">Gesperrt</div>';}
				$aus .= '
					<form method="post" action="">
					<input type="hidden" name="tan" value="'. $res->tan .'">
						<div class="card">
							<div class="card-body text-center">
								<div class="row">
									<div class="col">
										<div class="col text-left">
											Status: '. $status .'<br>
											TAN: '. $res->tan .'<br>
											Meldungen: '. $res->ges .'
										</div>
									</div>
									<div class="col text-left">
										<img src="'. $row->banner .'"><br>
										'; 
										if(!empty($row->betreff)){
											$aus .= '
												<u>Betreff:</u> '. $row->betreff .'<br>
												<u>Text:</u> '. $row->text .'
											';
										}
									$aus .= '
									</div>
								</div>
								<hr>
								<div class="row">
									<div class="col">Sponsor: '. $row->sponsor .'</div>
									<div class="col">Verdienst: '. number_format($row->verdienst,2,',','.') .'</div>
									<div class="col">Reload: '. $row->reload .' min</div>
									<div class="col">Menge: '. $row->menge .'</div>
								</div>
								<hr>
								<div class="row">
									<div class="col"><input type="submit" name="run[BannerDelete]" value="Banner Sperren" class="btn btn-danger btn-block"></div>
									<div class="col"><button type="button" class="btn btn-primary btn-block" data-toggle="modal" data-target="#meldung'.$res->tan .'">Meldungen Anzeigen</button></div>
									<div class="col"><input type="submit" name="run[BannerFree]" value="Banner freigeben" class="btn btn-success btn-block"></div>
								</div>
							</div>
						</div>
					</form>
					<div class="modal fade" id="meldung'.$res->tan .'" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
						<div class="modal-dialog" role="document">
							<div class="modal-content">
								<div class="modal-header">
									<h5 class="modal-title" id="exampleModalLabel">Gemeldet von</h5>
									<button type="button" class="close" data-dismiss="modal" aria-label="Close">
										<span aria-hidden="true">&times;</span>
									</button>
								</div>
								<div class="modal-body">
									'. $this->BannerMeldungen($res->tan) .'
								</div>
								<div class="modal-footer">
									<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
								</div>
							</div>
						</div>
					</div>
					<br>
				';
			}
		}else{
			$aus = '<div class="alert alert-info">Es sind momentan keine Meldungen vorhanden</div>';
		}
		return $aus;
	}
	
	private function BannerMeldungen($tan){
		$aus = '<table class="table table-striped">';
		foreach($this->db->get_results("SELECT uid,datum FROM ". PREFIX . BLACKLIST ." WHERE tan = '$tan' ") AS $res){
			$userinfo = userinfo($res->uid);
			$aus .= '
				<tr>
					<td>User</td>
					<td>'. $userinfo->nickname .'</td>
					<td>Meldung am</td>
					<td>'. date("d.m.Y H:i",$res->datum) .'</td>
				</tr>
			';
		}
		$aus .= '</table>';
		return $aus;
	}
	
	public function Delete($post){
		if($this->db->update(PREFIX . WERBUNG, array("status" => 2), array("tan" => $this->db->escape($post['tan'])),1) == true){
			meldung(0,BANNER_DELETE_TRUE);
		}else{
			meldung(1,BANNER_DELETE_FALSE);
		}
	}
	
	public function Free($post){
		if($this->db->update(PREFIX . WERBUNG, array("status" => 1), array("tan" => $this->db->escape($post['tan'])),1) == true){
			meldung(0,BANNER_FREE_TRUE);
		}else{
			meldung(1,BANNER_FREE_FALSE);
		}
	}
}