<?php
|
|
namespace app\operations\model\plus\table;
|
|
use app\common\model\plus\table\Record as RecordModel;
|
|
/**
|
* 优惠券模型
|
*/
|
class Record extends RecordModel
|
{
|
/**
|
* 获取优惠券列表
|
*/
|
public function getList($data)
|
{
|
$model = $this;
|
if(isset($data['table_id']) && $data['table_id'] > 0){
|
$model = $model->where('record.table_id', '=', $data['table_id']);
|
}
|
$list = $model->alias('record')->field(['record.*'])->with(['tableM', 'user'])
|
->join('table table', 'table.table_id = record.table_id','left')
|
->where('record.is_delete', '=', 0)
|
->where('table.is_delete', '=', 0)
|
->order(['record.create_time' => 'desc'])
|
->paginate($data);
|
foreach ($list as &$item){
|
$item['tableData'] = json_decode($item['content']);
|
unset($item['content']);
|
}
|
return $list;
|
}
|
|
/**
|
* 删除记录 (软删除)
|
*/
|
public function setDelete()
|
{
|
$this->startTrans();
|
try {
|
$this->save([
|
'is_delete' => 1
|
]);
|
(new Table())->where('table_id', '=', $this['table_id'])->dec('total_count')->update();
|
$this->commit();
|
return true;
|
} catch (\Exception $e) {
|
$this->error = $e->getMessage();
|
$this->rollback();
|
return false;
|
}
|
}
|
|
}
|
