upfile.php 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136
  1. <?php
  2. class upfile_m extends Model
  3. {
  4. var $condition = " WHERE 1=1 ";
  5. var $psize = 20;
  6. function __construct()
  7. {
  8. parent::Model();
  9. $this->psize = defined("SYS_PSIZE") ? SYS_PSIZE : 20;
  10. }
  11. function upfile_m()
  12. {
  13. $this->__construct();
  14. }
  15. function set_psize($psize=20)
  16. {
  17. $this->psize = $psize;
  18. }
  19. function set_condition($string="")
  20. {
  21. if($string)
  22. {
  23. $this->condition .= " AND ".$string." ";
  24. }
  25. return true;
  26. }
  27. //查询文章数
  28. function get_list($pageid=0)
  29. {
  30. $this->db->close_cache();
  31. $offset = $pageid>0 ? ($pageid-1)*$this->psize : 0;
  32. $sql = "SELECT * FROM ".$this->db->prefix."upfiles ".$this->condition." ORDER BY postdate DESC,id DESC LIMIT ".$offset.",".$this->psize;
  33. $rslist = $this->db->get_all($sql);
  34. return $rslist;
  35. }
  36. function get_one($id)
  37. {
  38. $this->db->close_cache();
  39. $sql = "SELECT * FROM ".$this->db->prefix."upfiles WHERE id='".$id."'";
  40. return $this->db->get_one($sql);
  41. }
  42. function get_one_c($condition="")
  43. {
  44. $sql = "SELECT * FROM ".$this->db->prefix."upfiles WHERE 1=1 ";
  45. if($condition)
  46. {
  47. $sql.= " WHERE ".$condition;
  48. }
  49. $sql.= " ORDER BY id ASC";
  50. return $this->db->get_one($sql);
  51. }
  52. //预览扩展图片信息
  53. function get_one_gd($id)
  54. {
  55. $sql = "SELECT * FROM ".$this->db->prefix."upfiles_gd WHERE pid='".$id."' ORDER BY id ASC";
  56. return $this->db->get_all($sql);
  57. }
  58. //查询数量
  59. function get_count()
  60. {
  61. $sql = "SELECT count(id) total FROM ".$this->db->prefix."upfiles ".$this->condition;
  62. $rs = $this->db->count($sql);
  63. return $rs;
  64. }
  65. //save
  66. function save($data,$id=0)
  67. {
  68. if($id)
  69. {
  70. $this->db->update_array($data,"upfiles",array("id"=>$id));
  71. return true;
  72. }
  73. else
  74. {
  75. $insert_id = $this->db->insert_array($data,"upfiles");
  76. return $insert_id;
  77. }
  78. }
  79. function save_gd($data,$id=0)
  80. {
  81. return $this->db->insert_array($data,"upfiles_gd","replace");
  82. }
  83. //通过ID串获取图片信息,这里获取的带有ID的缩略图
  84. function piclist($idstring="")
  85. {
  86. if(!$idstring)
  87. {
  88. return false;
  89. }
  90. $sql = "SELECT id,thumb url FROM ".$this->db->prefix."upfiles WHERE id IN(".$idstring.") ORDER BY substring_index('".$idstring."',id,1)";
  91. return $this->db->get_all($sql);
  92. }
  93. //读取图片的内容信息,这里获取的是图片的直接地址信息
  94. function pic_list($idstring,$gdtype="")
  95. {
  96. if(!$idstring)
  97. {
  98. return false;
  99. }
  100. if($gdtype)
  101. {
  102. $sql = "SELECT filename url FROM ".$this->db->prefix."upfiles_gd WHERE pid IN(".$idstring.") AND gdtype='".$gdtype."' ORDER BY substring_index('".$idstring."',pid,1)";
  103. $rslist = $this->db->get_all($sql);
  104. if(!$rslist)
  105. {
  106. $sql = "SELECT filename url FROM ".$this->db->prefix."upfiles WHERE id IN(".$idstring.") ORDER BY substring_index('".$idstring."',id,1)";
  107. return $this->db->get_all($sql);
  108. }
  109. else
  110. {
  111. return $rslist;
  112. }
  113. }
  114. else
  115. {
  116. $sql = "SELECT filename url FROM ".$this->db->prefix."upfiles WHERE id IN(".$idstring.") ORDER BY substring_index('".$idstring."',id,1)";
  117. return $this->db->get_all($sql);
  118. }
  119. }
  120. }
  121. ?>