123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128 |
- <?php
- namespace app\common\model;
- use think\facade\Db;
- class Rechargecard extends BaseModel
- {
- public $page_info;
-
- public function getRechargecardList($condition, $pagesize = 20, $limit = 0)
- {
- $order = 'rc_id desc';
- if ($pagesize) {
- $res = Db::name('rechargecard')->where($condition)->order($order)->paginate(['list_rows' => $pagesize, 'query' => request()->param()], false);
- $this->page_info = $res;
- return $res->items();
- } else {
- return Db::name('rechargecard')->where($condition)->order($order)->limit($limit)->select()->toArray();
- }
- }
-
- public function getRechargecardBySN($sn)
- {
- return Db::name('rechargecard')->where(array(
- 'rc_sn' => (string) $sn,
- ))->find();
- }
-
- public function setRechargecardUsedById($id, $memberId, $memberName)
- {
- return Db::name('rechargecard')->where(array('rc_id' => (string) $id,))->update(array('rc_tsused' => TIMESTAMP, 'rc_state' => 1, 'member_id' => $memberId, 'member_name' => $memberName,));
- }
-
- public function delRechargecard($condition)
- {
- return Db::name('rechargecard')->where($condition)->delete();
- }
-
- public function getOccupiedRechargecardSNsBySNs(array $sns)
- {
- $array = Db::name('rechargecard')->field('rc_sn')->where('rc_sn', 'in', $sns)->select()->toArray();
- $data = array();
- foreach ((array) $array as $v) {
- $data[] = $v['rc_sn'];
- }
- return $data;
- }
-
- public function getRechargecardCount($condition)
- {
- return Db::name('rechargecard')->where($condition)->count();
- }
-
- public function addRechargecardAll($data)
- {
- return Db::name('rechargecard')->insertAll($data);
- }
- }
|