BaseClass.php 6.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209
  1. <?php
  2. namespace common\base\classes;
  3. use Yii;
  4. use \common\base\models\Base;
  5. class BaseClass
  6. {
  7. public static $baseFile;
  8. //查询全部 ssh 2019.11.27
  9. public static function getAllList($select, $where, $order = '', $with = '')
  10. {
  11. /** @var Base $model */
  12. $model = Yii::createObject(['class' => static::$baseFile]);
  13. $return = $model->getAllList($select, $where, $order, $with);
  14. return $return;
  15. }
  16. //分页查询 ssh 2019.9.21
  17. public static function getList($select, $where, $order = '', $with = '')
  18. {
  19. /** @var Base $model */
  20. $get = Yii::$app->request->get();
  21. $page = isset($get['page']) ? $get['page'] : 1;
  22. Yii::$app->params['page'] = $page;
  23. $pageSize = isset($get['pageSize']) && !empty($get['pageSize']) ? $get['pageSize'] : Yii::$app->params['pageSize'];
  24. $model = Yii::createObject(['class' => static::$baseFile]);
  25. $return = $model->getList($select, $where, $page, $pageSize, $order, $with);
  26. return $return;
  27. }
  28. //查询指定条数 ssh 2019.11.30
  29. public static function getLimitList($select, $where, $limit = 10, $order = '', $with = '')
  30. {
  31. /** @var Base $model */
  32. $model = Yii::createObject(['class' => static::$baseFile]);
  33. $return = $model->getLimitList($select, $where, $limit, $order, $with);
  34. return $return;
  35. }
  36. public static function add($data, $returnObject = false)
  37. {
  38. /** @var Base $model */
  39. $model = Yii::createObject(['class' => static::$baseFile]);
  40. return $model->add($data, $returnObject);
  41. }
  42. /**
  43. * 批量添加
  44. */
  45. public static function batchAdd($data)
  46. {
  47. /** @var Base $model */
  48. $model = Yii::createObject(['class' => static::$baseFile]);
  49. $model->batchAdd($data);
  50. }
  51. /**
  52. * 根据主键ID删除一条记录
  53. */
  54. public static function deleteById($id)
  55. {
  56. /** @var Base $model */
  57. $model = Yii::createObject(['class' => static::$baseFile]);
  58. return $model->deleteById($id);
  59. }
  60. /**
  61. *根据条件删除一条或多条记录
  62. */
  63. public static function deleteByCondition($condition)
  64. {
  65. /** @var Base $model */
  66. $model = Yii::createObject(['class' => static::$baseFile]);
  67. $count = $model->deleteByCondition($condition);
  68. return $count;
  69. }
  70. //根据id批量删 ssh 2019.12.7
  71. public static function deleteByIds($ids)
  72. {
  73. /** @var Base $model */
  74. $model = Yii::createObject(['class' => static::$baseFile]);
  75. return $model->deleteByIds($ids);
  76. }
  77. /**
  78. * 根据主键ID更新一条记录
  79. */
  80. public static function updateById($id, $data)
  81. {
  82. /** @var Base $model */
  83. $model = Yii::createObject(['class' => static::$baseFile]);
  84. return $model->updateById($id, $data);
  85. }
  86. //根据多个主键id更新 ssh 2019.9.3
  87. public static function updateByIds($ids, $data)
  88. {
  89. /** @var Base $model */
  90. $model = Yii::createObject(['class' => static::$baseFile]);
  91. return $model->updateByIds($ids, $data);
  92. }
  93. /**
  94. * 根据条件更新一条或多条记录
  95. */
  96. public static function updateByCondition($condition, $data)
  97. {
  98. /** @var Base $model */
  99. $model = Yii::createObject(['class' => static::$baseFile]);
  100. $count = $model->updateByCondition($condition, $data);
  101. return $count;
  102. }
  103. /**
  104. * 根据主键ID查出一条记录
  105. */
  106. public static function getById($id, $returnObject = false)
  107. {
  108. /** @var Base $model */
  109. $model = Yii::createObject(['class' => static::$baseFile]);
  110. return $model->getById($id, $returnObject);
  111. }
  112. //随机取一个 ssh 2020.2.10
  113. public static function getOne($returnObject = false, $order = false)
  114. {
  115. /** @var Base $model */
  116. $model = Yii::createObject(['class' => static::$baseFile]);
  117. return $model->getOne($returnObject, $order);
  118. }
  119. /**
  120. *根据条件查出一条记录
  121. */
  122. public static function getByCondition($condition, $returnObject = false, $order = false)
  123. {
  124. /** @var Base $model */
  125. $model = Yii::createObject(['class' => static::$baseFile]);
  126. return $model->getByCondition($condition, $returnObject, $order);
  127. }
  128. //是否存在 ssh 2019.8.30
  129. public static function exists($condition)
  130. {
  131. /** @var Base $model */
  132. $model = Yii::createObject(['class' => static::$baseFile]);
  133. return $model->exists($condition);
  134. }
  135. /**
  136. *根据条件查出多条记录
  137. */
  138. public static function getAllByCondition($condition, $order = null, $field, $indexBy = null, $returnObject = false)
  139. {
  140. /** @var Base $model */
  141. $model = Yii::createObject(['class' => static::$baseFile]);
  142. return $model->getAllByCondition($condition, $order, $field, $indexBy, $returnObject);
  143. }
  144. /**
  145. * 根据多个主键ID查询多条记录
  146. */
  147. public static function getByIds($ids, $order = null, $indexBy = null)
  148. {
  149. /** @var Base $model */
  150. $model = Yii::createObject(['class' => static::$baseFile]);
  151. return $model->getByIds($ids, $order, $indexBy);
  152. }
  153. /**
  154. *根据条件查出数量
  155. */
  156. public static function getCount($condition)
  157. {
  158. /** @var Base $model */
  159. $model = Yii::createObject(['class' => static::$baseFile]);
  160. return $model->getCount($condition);
  161. }
  162. //计数器+1-1 shizq 2019-12-05
  163. public static function counters($counters, $condition, $params = [])
  164. {
  165. /** @var Base $model */
  166. $model = Yii::createObject(['class' => static::$baseFile]);
  167. return $model->counters($counters, $condition, $params);
  168. }
  169. //根据主键获取被销的信息 ssh 2021.5.18
  170. public static function getLockById($id)
  171. {
  172. /** @var Base $model */
  173. $model = Yii::createObject(['class' => static::$baseFile]);
  174. return $model->getLockById($id);
  175. }
  176. //求和
  177. public static function sum($condition, $field)
  178. {
  179. /** @var Base $model */
  180. $model = Yii::createObject(['class' => static::$baseFile]);
  181. return $model->sum($condition, $field);
  182. }
  183. }