boniu/lib/table/table_index.class.php

<?php

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

class Table_index extends Table {

	protected $table_name       = 'index';//表名，不带前缀，前缀在config中定义
    protected $table_id         = 'index_id';//指定ID字段名称，必须
    protected $table_status     = '';//指定状态字段名称，如果有
    protected $table_order      = '';//指定排序字段名称，如果有
	//数据库结构
	protected function struct(){
		$attr = array();
		
		$attr['id']           = 'index_id';
		$attr['code']         = 'index_code';
		$attr['name']         = 'index_name';
		$attr['exchange']        = 'index_exchange';
        $attr['sector']           = 'index_sector';
		return $attr;
	}


    public function add($attr){
        $param = array (
            'index_date'    => array('number', $attr['date']),
            'index_open_price'    => array('number', $attr['open_price']),
            'index_close_price'    => array('number', $attr['close_price']),
            'index_highest_price'    => array('number', $attr['highest_price']),
            'index_lowest_price'    => array('number', $attr['lowest_price']),
            'index_increase_value'    => array('number', $attr['increase_value']),
            'index_increase_price'    => array('number', $attr['increase_price']),
            'index_amount'    => array('number', $attr['amount']),
            'index_value'    => array('number', $attr['value']),
        );
        return $this->pdo->sqlinsert($this->table_fullname, $param);
    }


    /****
     * @return array
     * wanggangtao
     *
     */
    public function getIndexList(){

        $where="where 1=1";
        $sql = "select "."`*`". "from ". $this->table_fullname ." $where order by ".$this->table_id." asc";
        $rs = $this->pdo->sqlQuery($sql);
        $r  = array();
        if($rs){
            foreach($rs as $key => $val){
                $r[$key] = $this->dataToAttr($val);
            }
            return $r;
        }else{
            return $r;
        }
    }

    public function get_index_info($index_type){

        $where=" where 1=1 ";
        $sql = "select "."`*`". "from ". $this->table_fullname . $where ;
        if($index_type==1){
            $stock_code="000001";
            $sql.=" and index_code=".$stock_code ;
        }else if($index_type==2){
            $stock_code="399001";
            $sql.=" and index_code=".$stock_code ;
        }else if($index_type==3){
            $stock_code="000016";
            $sql.=" and index_code=".$stock_code ;
        }else if($index_type==4){
            $stock_code="399300";
            $sql.=" and index_code=".$stock_code ;
        }else if($index_type==5){
            $stock_code="399006";
            $sql.=" and index_code=".$stock_code ;
        }else if($index_type==6){
            $stock_code="000688";
            $sql.=" and index_code=".$stock_code ;
        }
        $rs = $this->pdo->sqlQuery($sql);
        $r  = array();
        if($rs){
            foreach($rs as $key => $val){
                $r[$key] = $this->dataToAttr($val);
            }
            return $r;
        }else{
            return $r;
        }
    }




}
?>