smartcost/protected/model/Down.php

<?php

Doo::loadCore('db/DooModel');

class Down extends DooModel {

    public $did;
    public $title;
    public $fulltitle;
    public $down_url;
    public $key_number;
    public $size;
    
    public $_table = 'sc_down';
    public $_primarykey = 'did';
    public $_fields = array('did', 'title','fulltitle', 'down_url','key_number','size');

function getDownById($did = 0) {
		
		return $this->find ( array ( 'where' => 'did=' . $did, 'asArray' => TRUE ) );
	}

	function getDownList($data = array(), $condition = "", $limit = ""){
		foreach ( $data as $key => $value ) {
			if (is_numeric ( $value ))
				$condition .= " and " . $key . " = " . $value;
			else
				$condition .= " and " . $key . " like '%" . $value . "%' ";
		}
		
		$condition = ' where 1 ' . $condition . $limit;
		
		$sql = "select * from " . $this->_table . $condition;
		
		$query = Doo::db ()->query ( $sql );
		
		$result = $query->fetchAll ();
		
		return $result;
	}
	
	function getDownByIdList($id){
		//; order by did asc
		$sql = "select * from " . $this->_table . " where did in ( " . $id . " ) order by field(did,".$id.")";
		
		$query = Doo::db ()->query ( $sql );
		
		$result = $query->fetchAll ();
		
		return $result;
	}
	
	function deleteDownByIdList($id){
		
		$id = implode ( ",", $id );
		
		$sql = "delete from " . $this->_table . " where did in ( " . $id . " )";
		
		Doo::db ()->query ( $sql );
	}
    
}

?>