<?php
|
|
namespace app\branch\model\activity;
|
|
use app\common\model\branch\Activity as ActivityModel;
|
use app\common\model\branch\ActivityProductPrice as ActivityProductPriceModel;
|
|
/**
|
* 活动模型
|
*/
|
class Activity extends ActivityModel
|
{
|
/**
|
* 获取列表
|
*/
|
public function getList($params, $branch_id)
|
{
|
return $this->with(['image', 'category'])
|
->where('branch_id', '=', $branch_id)
|
->where('is_delete', '=', 0)
|
->order(['sort' => 'desc', 'create_time' => 'desc'])
|
->paginate($params);
|
|
}
|
|
/**
|
* 新增记录
|
*/
|
public function add($data, $branch_id)
|
{
|
$model = new ActivityModel();
|
$product = new ActivityProductPriceModel();
|
$data['app_id'] = self::$app_id;
|
$data['branch_id'] = $branch_id;
|
//报名时间
|
$data['register_start_time'] = strtotime($data['reg_date'][0]);
|
$data['register_end_time'] = strtotime($data['reg_date'][1]);
|
//活动时间
|
$data['activity_start_time'] = strtotime($data['act_date'][0]);
|
$data['activity_end_time'] = strtotime($data['act_date'][1]);
|
// 格式化坐标信息
|
$coordinate = explode(',', $data['coordinate']);
|
$data['latitude'] = $coordinate[0];
|
$data['longitude'] = $coordinate[1];
|
$product_list = $data['product_list']; // 促销商品
|
$model->startTrans();
|
try {
|
$res = $model->save($data);
|
if(!$res){
|
$this->rollback();
|
$this->error = '活动数据保存出错';
|
return false;
|
}
|
if ($product_list) {
|
$activity_id = $model->activity_id;
|
foreach ($product_list as &$item){
|
$item['app_id'] = $data['app_id'];
|
$item['shop_supplier_id'] = $data['visit_supplier_id'];
|
$item['activity_id'] = $activity_id;
|
}
|
unset($item);
|
$res1 = $product->saveAll($product_list);
|
if(!$res1){
|
$this->rollback();
|
$this->error = '促销商品保存出错';
|
return false;
|
}
|
}
|
// 提交事务
|
$this->commit();
|
return true;
|
} catch (\Exception $e) {
|
// 回滚事务
|
$this->rollback();
|
$this->error = $e->getMessage();
|
return false;
|
}
|
}
|
|
/**
|
* 更新记录
|
*/
|
public function edit($data)
|
{
|
$model = new ActivityModel();
|
$product = new ActivityProductPriceModel();
|
//报名时间
|
$data['register_start_time'] = strtotime($data['reg_date'][0]);
|
$data['register_end_time'] = strtotime($data['reg_date'][1]);
|
//活动时间
|
$data['activity_start_time'] = strtotime($data['act_date'][0]);
|
$data['activity_end_time'] = strtotime($data['act_date'][1]);
|
// 格式化坐标信息
|
$coordinate = explode(',', $data['coordinate']);
|
$data['latitude'] = $coordinate[0];
|
$data['longitude'] = $coordinate[1];
|
$product_list = $data['product_list']; // 促销商品
|
unset($data['create_time'], $data['update_time']);
|
$model->startTrans();
|
try {
|
$res = $model->update($data, ['activity_id' => $data['activity_id']]);
|
if(!$res){
|
$this->rollback();
|
$this->error = '活动数据保存出错';
|
return false;
|
}
|
// 先软删除原有的促销商品
|
$product->where('activity_id', '=', $data['activity_id'])->update(['is_delete' => 1]);
|
if ($product_list) {
|
foreach ($product_list as $key => &$item){
|
$item['app_id'] = $data['app_id'];
|
$item['shop_supplier_id'] = $data['visit_supplier_id'];
|
$item['activity_id'] = $data['activity_id'];
|
$item['is_delete'] = 0;
|
}
|
unset($item);
|
$res1 = $product->saveAll($product_list);
|
if(!$res1){
|
$this->rollback();
|
$this->error = '商品数据保存出错';
|
return false;
|
}
|
}
|
// 提交事务
|
$this->commit();
|
return true;
|
} catch (\Exception $e) {
|
// 回滚事务
|
$this->rollback();
|
$this->error = $e->getMessage();
|
return false;
|
}
|
}
|
|
/**
|
* 软删除
|
*/
|
public function setDelete()
|
{
|
return $this->save(['is_delete' => 1]);
|
}
|
|
/**
|
* 获取活动总数量
|
*/
|
public static function getActivityTotal($where)
|
{
|
$model = new static;
|
return $model->where($where)->where('is_delete', '=', 0)->count();
|
}
|
|
/**
|
* 开启禁止
|
*/
|
public function setStatus($status)
|
{
|
// 开启事务
|
$this->startTrans();
|
try {
|
//更改分会状态
|
$this->save(['status' => $status]);
|
$this->commit();
|
return true;
|
} catch (\Exception $e) {
|
$this->error = $e->getMessage();
|
$this->rollback();
|
return false;
|
}
|
}
|
|
public function activityGroupNum($date, $branch_id)
|
{
|
$field = 'count(*) as total,from_unixtime(create_time,\'%m-%d\') as `day`';
|
if ($date == 'year') {
|
$field = 'count(*) as total,from_unixtime(create_time,\'%m\') as `day`';
|
}
|
$model = $this->field($field)
|
->where('is_delete', '=', 0)
|
->when($date, function ($query, $date) {
|
getModelTime($query, $date, 'create_time');
|
})->when($branch_id, function ($query, $branch_id) {
|
$query->where('branch_id', $branch_id);
|
});
|
return $model->order('create_time ASC')->group('day')->select();
|
}
|
}
|
