table_index_kc50.class.php 2.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  1. <?php
  2. /**
  3. * 数据库表:管理员组
  4. *
  5. * @createtime 2018/03/01
  6. * @author 空竹
  7. * @copyright 芝麻开发(http://www.zhimawork.com)
  8. */
  9. class Table_index_kc50 extends Table {
  10. protected $table_name = 'index_kc50';//表名,不带前缀,前缀在config中定义
  11. protected $table_id = 'index_kc50_id';//指定ID字段名称,必须
  12. protected $table_status = '';//指定状态字段名称,如果有
  13. protected $table_order = '';//指定排序字段名称,如果有
  14. //数据库结构
  15. protected function struct(){
  16. $attr = array();
  17. $attr['id'] = 'index_kc50_id';
  18. $attr['date'] = 'index_kc50_date';
  19. $attr['open_price'] = 'index_kc50_open_price';
  20. $attr['close_price'] = 'index_kc50_close_price';
  21. $attr['increase_price'] = 'index_kc50_increase_price';
  22. $attr['increase_value'] = 'index_kc50_increase_value';
  23. $attr['amount'] = 'index_kc50_amount';
  24. $attr['value'] = 'index_kc50_value';
  25. return $attr;
  26. }
  27. /***
  28. * @param $attr
  29. * @return mixed
  30. * 插入历史数据
  31. */
  32. public function insert($attr){
  33. $param = array (
  34. 'index_kc50_date' => array('number', $attr['date']),
  35. 'index_kc50_open_price' => array('number', $attr['open_price']),
  36. 'index_kc50_close_price' => array('number', $attr['close_price']),
  37. 'index_kc50_hightest_price' => array('number', $attr['hightest_price']),
  38. 'index_kc50_lowest_price' => array('number', $attr['lowest_price']),
  39. 'index_kc50_increase_value' => array('number', $attr['increase_value']),
  40. 'index_kc50_increase_price' => array('number', $attr['increase_price']),
  41. 'index_kc50_amount' => array('number', $attr['amount']),
  42. 'index_kc50_value' => array('number', $attr['value']),
  43. );
  44. return $this->pdo->sqlinsert($this->table_fullname, $param);
  45. }
  46. public function add($attr){
  47. $param = array (
  48. 'index_kc50_date' => array('number', $attr['date']),
  49. 'index_kc50_open_price' => array('number', $attr['open_price']),
  50. 'index_kc50_close_price' => array('number', $attr['close_price']),
  51. 'index_kc50_hightest_price' => array('number', $attr['hightest_price']),
  52. 'index_kc50_lowest_price' => array('number', $attr['lowest_price']),
  53. 'index_kc50_increase_value' => array('number', $attr['increase_value']),
  54. 'index_kc50_increase_price' => array('number', $attr['increase_price']),
  55. 'index_kc50_amount' => array('number', $attr['amount']),
  56. 'index_kc50_value' => array('number', $attr['value']),
  57. );
  58. return $this->pdo->sqlinsert($this->table_fullname, $param);
  59. }
  60. }
  61. ?>