<?php
class ModelTooltestcareTable extends Model {

	public function addValue($data) {
		$this->db->query("INSERT INTO " . DB_PREFIX . "test_care SET dropdown_id = '" . $data['dropdown_id'] . "', value = '" . $this->db->escape($data['value']) . "'");
		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "test_care WHERE dropdown_id = '" . (int)$data['dropdown_id'] . "' ORDER BY value");
		return $query->rows;
	}
	
	public function editValue($data) {
		$this->db->query("UPDATE " . DB_PREFIX . "test_care SET value = '" . $this->db->escape($data['value']) . "' WHERE table_id = '" . (int)$data['table_id'] . "'");
		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "test_care WHERE dropdown_id = '" . (int)$data['dropdown_id'] . "' ORDER BY value");
		return $query->rows;
	}
	
	public function deleteValue($data) {
		$this->db->query("DELETE FROM " . DB_PREFIX . "test_care WHERE table_id = '" . (int)$data['table_id'] . "'");
		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "test_care WHERE dropdown_id = '" . (int)$data['dropdown_id'] . "' ORDER BY value");
		return $query->rows;
	}
	
	public function getValues($dropdown_id) {
		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "test_care WHERE dropdown_id = '" . (int)$dropdown_id . "' ORDER BY value");
		return $query->rows;
	}
	
	public function checkDB() {
		$query = $this->db->query("CREATE TABLE IF NOT EXISTS " . DB_PREFIX . "test_care (
				table_id int(11) NOT NULL auto_increment,
				dropdown_id tinyint(1) NOT NULL DEFAULT 0,
				value VARCHAR(366) COLLATE utf8_bin NOT NULL DEFAULT '',
                dvalue TEXT COLLATE utf8_bin NOT NULL DEFAULT '',
				PRIMARY KEY (table_id)
			);");
		return;
	}

}
?>