<?php

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

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

		return $result;
    }

    public function getByName($printer, $type, $color)
    {
		$printer = $this->db->strip($printer);
		$type = $this->db->strip($type);
		$color = $this->db->strip($color);

		$result = $this->db->select("* FROM toners WHERE printer='$printer' AND type='$type' AND color='$color'", 'firstrow');

		return $result;
    }
	
    public function getAll()
    {
		$result = $this->db->select("* FROM toners ORDER BY printer ASC");
		
		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("toners 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 toners ($fields) VALUES ($values)");
		}

		return $result;
	}
	
	public function delete($id)
	{
		$id = $this->db->strip($id);
		
		$result = $this->db->delete("FROM toners WHERE id=".$id);
			
		return $result;
	}
}