table_index_day_k.class.php 2.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: 王刚涛
  5. * Date: 2020/11/24
  6. * Time: 14:51
  7. */
  8. class Table_index_day_k extends Table {
  9. protected $base = ""; //分表的后缀日期,在进行数据库操作的时候"Table_day_k_".$base
  10. protected $table_name = "index_day_k";//表名,不带前缀,前缀在config中定义
  11. protected $table_id = "index_day_k_id";//指定ID字段名称,必须
  12. protected $table_status = '';//指定状态字段名称,如果有
  13. protected $table_order = '';//指定排序字段名称,如果有
  14. //数据库结构
  15. protected function struct(){
  16. $attr = array();
  17. $attr['id'] = 'index_day_k_id';
  18. $attr['date'] = 'index_day_k_date';
  19. $attr['code'] = 'index_day_k_code';
  20. $attr['name'] = 'index_day_k_name';
  21. $attr['open_price'] = 'index_day_k_open_price';
  22. $attr['close_price'] = 'index_day_k_close_price';
  23. $attr['hightest_price'] = 'index_day_k_hightest_price';
  24. $attr['lowest_price'] = 'index_day_k_lowest_price';
  25. $attr['increase_price'] = 'index_day_k_increase_price';
  26. $attr['increase_value'] = 'index_day_k_increase_value';
  27. $attr['turnover'] = 'index_day_k_turnover';
  28. $attr['amount'] = 'index_day_k_amount';
  29. $attr['value'] = 'index_day_k_value';
  30. return $attr;
  31. }
  32. public function add($attr){
  33. $param = array (
  34. 'index_day_k_date' => array('number', $attr['date']),
  35. 'index_day_k_code' => array('string', $attr['code']),
  36. 'index_day_k_name' => array('string', $attr['name']),
  37. 'index_day_k_open_price' => array('number', $attr['open_price']),
  38. 'index_day_k_close_price' => array('number', $attr['close_price']),
  39. 'index_day_k_hightest_price' => array('number', $attr['hightest_price']),
  40. 'index_day_k_lowest_price' => array('number', $attr['lowest_price']),
  41. 'index_day_k_increase_price' => array('number', $attr['increase_price']),
  42. 'index_day_k_increase_ratio' => array('number', $attr['increase_ratio']),
  43. 'index_day_k_amount' => array('number', $attr['amount']),
  44. 'index_day_k_value' => array('number', $attr['value']), );
  45. return $this->pdo->sqlinsert($this->table_fullname, $param);
  46. }
  47. }
  48. ?>