<?php

class ReportsModel
{
    function __construct($db) {
		$this->db = $db;
    }

    public function get($id)
    {
		$id = $this->db->strip($id);
		$result = $this->db->select("* FROM reports WHERE id='$id'", 'firstrow');

		return $result;
    }

    public function getAll()
    {
		$result = $this->db->select("* FROM reports ORDER BY id DESC");
		
		return $result;
    }

	public function save($record)
	{
		array_walk($record, array($this->db, 'strip_array'));
		$old = $this->get($record['id']);

		if ($old){
			foreach ($record as $field=>$value) {
				if ($field!="id") {
					if ($value=="NULL")
						$set[] = "$field=NULL";
					else
						$set[] = "$field='$value'";
				}
			}
			
			$set = implode(", ", $set);
			
			$result = $this->db->update("reports SET $set WHERE id='".$record['id']."'");
		} else {
			foreach ($record as $field=>$value) {
				$fields[] = $field;
				if ($value=="NULL")
					$values[] = "NULL";
				else
					$values[] = "'$value'";
			}
									
			$fields = implode(", ", $fields);
			$values = implode(", ", $values);
			
			$result = $this->db->insert("INTO reports ($fields) VALUES ($values)");
		}

		return $result;
	}

	public function toggleStatus($id)
	{
		$id = $this->db->strip($id);
		
		$report = $this->get($id);
		$new_status = ($report->status==0?1:0);
		$result = $this->db->update("reports SET status=$new_status WHERE id=$id");
			
		return $result;
	}	
	
	public function delete($id)
	{
		$id = $this->db->strip($id);
		
		$result = $this->db->delete("FROM reports WHERE id=".$id);
			
		return $result;
	}
}