boniu/lib/table/table_day_k_base.class.php

<?php

/**
 * Created by PhpStorm.
 * User: 王刚涛
 * Date: 2020/11/24
 * Time: 14:51
 */

class Table_day_k_base extends Table {

    protected $base  = "";              //分表的后缀日期,在进行数据库操作的时候"Table_day_k_".$base
    protected $table_name       = "day_k_";//表名，不带前缀，前缀在config中定义
    protected $table_id         = "day_k_id";//指定ID字段名称，必须
    protected $table_status     = '';//指定状态字段名称，如果有
    protected $table_order      = '';//指定排序字段名称，如果有
    protected $table_fullname    = "day_k_";//拼接好后表名  后面拼接日期  day_k_202011

	//数据库结构
	protected function struct(){
		$attr = array();
		$attr['id']                 = 'day_k_id';
		$attr['date']               = 'day_k_date';
		$attr['code']               = 'day_k_code';
        $attr['name']               = 'day_k_name';
        $attr['open_price']         = 'day_k_open_price';
        $attr['close_price']        = 'day_k_close_price';
        $attr['hightest_price']     = 'day_k_hightest_price';
        $attr['lowest_price']       = 'day_k_lowest_price';
        $attr['increase_price']     = 'day_k_increase_price';
        $attr['increase_value']     = 'day_k_increase_value';
        $attr['turnover']           = 'day_k_turnover';
        $attr['amount']             = 'day_k_amount';
        $attr['value']              = 'day_k_value';
        $attr['open_price_qfq']     = 'day_k_open_price_qfq';
        $attr['close_price_qfq']    = 'day_k_close_price_qfq';
        $attr['hightest_price_qfq'] = 'day_k_hightest_price_qfq';
        $attr['lowest_price_qfq']   = 'day_k_lowest_price_qfq';
        $attr['m10']                = 'day_k_m10';
        $attr['m20']                = 'day_k_m20';
        $attr['m60']                = 'day_k_m60';
        $attr['kdj']                = 'day_k_kdj';
        $attr['macd']               = 'day_k_macd';
        $attr['rsi']                = 'day_k_rsi';
		return $attr;
	}

    /***
     * Table_day_k_base constructor.
     * 构造函数，动态获取表的后缀年月
     * 王刚涛
     */
    public function __construct($date) {
        parent::__construct();
        $this->table_name .= $date;//表名不代前缀
        $this->table_fullname .= $date;//表名代前缀
        $this ->createBaseTable();
    }

    /****
     *在构造函数中调用该函数，自动创建表
     * 王刚涛
     */
     public function createBaseTable(){
         global $mypdo;
         $sql = " CREATE TABLE IF NOT EXISTS `". $this->table_fullname."` LIKE  boniu_day_k_base";
         $mypdo->pdo->exec($sql);
     }

    /****
     * @param $attr
     * @return mixed
     * 王刚涛
     */
    public function add($attr){
        $param = array (
             'day_k_date'    => array('number', strtotime($attr['date'])),
             'day_k_code'    => array('number', $attr['code']),
             'day_k_name'    => array('string', $attr['name']),
            'day_k_open_price'    => array('number', $attr['open_price']),
             'day_k_close_price'    => array('number', $attr['close_price']),
            'day_k_hightest_price'    => array('number', $attr['hightest_price']),
             'day_k_lowest_price'    => array('number', $attr['lowest_price']),
             'day_k_amount'    => array('number', $attr['amount']),
             'day_k_value'    => array('number', $attr['value']),
            'day_k_close_price_qfq'    => array('number', $attr['close_price_qfq']),
            'day_k_increase_price'    => array('number', $attr['increase_price']),
            'day_k_increase_value'    => array('number', $attr['increase_value']),
            'day_k_turnover'    => array('number', $attr['turnover']),
        );
        return $this->pdo->sqlinsert($this->table_fullname, $param);
    }


    /****
     * @param $attr
     * @return mixed
     *
     */
    public function insert($attr){
        $param = array (
            'day_k_date'    => array('number', strtotime($attr['date'])),
            'day_k_code'    => array('number', $attr['code']),
            'day_k_name'    => array('string', $attr['name']),
            'day_k_open_price'    => array('number', $attr['open_price']),
            'day_k_hightest_price'    => array('number', $attr['hightest_price']),
            'day_k_lowest_price'    => array('number', $attr['lowest_price']),
            'day_k_value'    => array('number', $attr['value']),
            'day_k_amount'    => array('number', $attr['amount']),
            'day_k_close_price'    => array('number', $attr['close_price']),
            'day_k_close_price_qfq'    => array('number', $attr['close_price_qfq']),
            'day_k_increase_price'    => array('number', $attr['increase_price']),
            'day_k_increase_value'    => array('number', $attr['increase_value']),
            'day_k_turnover'    => array('number', $attr['turnover']),

        );
        $msg=$this->pdo->sqlinsert($this->table_fullname, $param);
        return $msg;
    }

}
?>