<?php

/**
 * 数据库表:管理员组
 *
 * @createtime	2018/03/01
 * @author		空竹
 * @copyright	芝麻开发(http://www.zhimawork.com)
 */

class Table_day_k_qfq extends Table {

	protected $table_name       = 'day_k_qfq';//表名，不带前缀，前缀在config中定义
    protected $table_id         = 'day_k_qfq_id';//指定ID字段名称，必须
    protected $table_status     = '';//指定状态字段名称，如果有
    protected $table_order      = '';//指定排序字段名称，如果有
	//数据库结构
	protected function struct(){
        $attr['id']                 = 'day_k_qfq_id';
        $attr['timestamp']          = 'day_k_qfq_timestamp';
        $attr['date']               = 'day_k_qfq_date';
        $attr['code']               = 'day_k_qfq_code';
        $attr['name']               = 'day_k_qfq_name';
        $attr['open_price']         = 'day_k_qfq_open_price';
        $attr['close_price']        = 'day_k_qfq_close_price';
        $attr['highest_price']     = 'day_k_qfq_highest_price';
        $attr['lowest_price']       = 'day_k_qfq_lowest_price';
        $attr['turnover']           = 'day_k_qfq_turnover';
        $attr['amount']             = 'day_k_qfq_amount';
		return $attr;
	}

    public function add($attr){
        $param = array (
             'day_k_qfq_timestamp'    => array('number', $attr['timestamp']),
             'day_k_qfq_date'         => array('number', $attr['date']),
             'day_k_qfq_code'         => array('string', $attr['code']),
             'day_k_qfq_name'         => array('string', $attr['name']),
            'day_k_qfq_open_price'    => array('number', $attr['open_price']),
            'day_k_qfq_close_price'   => array('number', $attr['close_price']),
            'day_k_qfq_highest_price' => array('number', $attr['highest_price']),
            'day_k_qfq_lowest_price'  => array('number', $attr['lowest_price']),
            'day_k_qfq_turnover'      => array('number', $attr['turnover']),
            'day_k_qfq_amount'        => array('number', $attr['amount'])
        );
        return $this->pdo->sqlinsert($this->table_fullname, $param);
    }


    public function getInfoByCodeAndDate($code,$date){

        //查询语句必须用sql_check_input检查参数
        $code = trim($code);
        $code = $this->pdo->sql_check_input(array('string', $code));
        $date = $this->pdo->sql_check_input(array('number', trim($date)));

        $sql = "select * from ". $this->table_fullname ." where day_k_qfq_code = ".$code." and  day_k_qfq_date=".$date ." limit 1";

        $rs = $this->pdo->sqlQuery($sql);
        $r  = array();
        if($rs){
            foreach($rs as $key => $val){
                $r[$key] = $this->dataToAttr($val);
            }
            return $r[0];
        }else{
            return $r;
        }
    }


}
?>