isAjax()) { $condition[] = [ 'site_id', '=', $this->site_id ]; $order = 'seckill_start_time asc'; $field = '*'; $seckill_model = new SeckillModel(); $res = $seckill_model->getSeckillTimeList($condition, $field, $order, null); foreach ($res[ 'data' ] as $key => $val) { $val = $seckill_model->transformSeckillTime($val); $res[ 'data' ][ $key ][ 'seckill_start_time_show' ] = "{$val['start_hour']}:{$val['start_minute']}:{$val['start_second']}"; $res[ 'data' ][ $key ][ 'seckill_end_time_show' ] = "{$val['end_hour']}:{$val['end_minute']}:{$val['end_second']}"; } return $res; } else { $this->forthMenu(); return $this->fetch("seckill/lists"); } } /** * 添加秒杀时间段 */ public function add() { if (request()->isAjax()) { $start_hour = input('start_hour', 0); $start_minute = input('start_minute', 0); $start_second = input('start_second', 0); $end_hour = input('end_hour', 0); $end_minute = input('end_minute', 0); $end_second = input('end_second', 0); $data = [ 'site_id' => $this->site_id, 'name' => input('name', ''), 'seckill_start_time' => $start_hour * 3600 + $start_minute * 60 + $start_second, 'seckill_end_time' => $end_hour * 3600 + $end_minute * 60 + $end_second, 'create_time' => time(), ]; $seckill_model = new SeckillModel(); return $seckill_model->addSeckillTime($data); } else { return $this->fetch("seckill/add"); } } /** * 编辑秒杀时间段 */ public function edit() { $seckill_model = new SeckillModel(); if (request()->isAjax()) { $start_hour = input('start_hour', 0); $start_minute = input('start_minute', 0); $start_second = input('start_second', 0); $end_hour = input('end_hour', 0); $end_minute = input('end_minute', 0); $end_second = input('end_second', 0); $data = [ 'name' => input('name', ''), 'seckill_start_time' => $start_hour * 3600 + $start_minute * 60 + $start_second, 'seckill_end_time' => $end_hour * 3600 + $end_minute * 60 + $end_second, 'create_time' => time(), 'id' => input('id', 0), ]; return $seckill_model->editSeckillTime($data, $this->site_id); } else { $id = input('id', 0); $this->assign('id', $id); //秒杀详情 $time_info = $seckill_model->getSeckillTimeInfo([ [ 'id', '=', $id ] ]); if (!empty($time_info[ 'data' ])) { $time_info[ 'data' ] = $seckill_model->transformSeckillTime($time_info[ 'data' ]); } $this->assign('time_info', $time_info[ 'data' ]); return $this->fetch("seckill/edit"); } } /** * 删除秒杀时间段 */ public function delete() { if (request()->isAjax()) { $seckill_time_id = input('id', 0); $seckill_model = new SeckillModel(); return $seckill_model->deleteSeckillTime($seckill_time_id); } } /** * 添加秒杀商品 */ public function addGoods() { $seckill_model = new SeckillModel(); if (request()->isAjax()) { $data = [ 'seckill_name' => input('seckill_name', ''), 'remark' => input('remark', ''), 'seckill_time_id' => input('seckill_time_id', ''), 'start_time' => strtotime(input('start_time', '')), 'end_time' => strtotime(input('end_time', '')), 'site_id' => $this->site_id, 'goods_data' => input('goods_data', ''), 'goods_ids' => input('goods_ids', ''), 'sort' => input('sort', '') ]; $res = $seckill_model->addSeckillGoods($data); return $res; } else { $seckill_time_list = $seckill_model->getSeckillTimeList([ [ 'site_id', '=', $this->site_id ] ]); foreach ($seckill_time_list[ 'data' ] as $key => $val) { $val = $seckill_model->transformSeckillTime($val); $seckill_time_list[ 'data' ][ $key ][ 'seckill_start_time_show' ] = "{$val['start_hour']}:{$val['start_minute']}:{$val['start_second']}"; $seckill_time_list[ 'data' ][ $key ][ 'seckill_end_time_show' ] = "{$val['end_hour']}:{$val['end_minute']}:{$val['end_second']}"; } $this->assign('seckill_time_list', $seckill_time_list); return $this->fetch("seckill/addgoods"); } } /** * 更新商品(秒杀价格) */ public function updateGoods() { $seckill_model = new SeckillModel(); if (request()->isAjax()) { $data = [ 'seckill_name' => input('seckill_name', ''), 'remark' => input('remark', ''), 'seckill_time_id' => input('seckill_time_id', ''), 'start_time' => strtotime(input('start_time', '')), 'end_time' => strtotime(input('end_time', '')), 'site_id' => $this->site_id, 'sku_list' => input('sku_list', ''), 'goods_ids' => input('goods_ids', ''), 'id' => input('id', ''), 'sort' => input('sort', '0'), ]; $res = $seckill_model->editSeckillGoods($data); return $res; } else { $seckill_id = input('id', ''); $seckill_info = $seckill_model->getSeckillDetail([ [ 'id', '=', $seckill_id ] ]); $seckill_time_id = trim($seckill_info[ 'data' ][ 'seckill_time_id' ], ','); $time_list = $seckill_model->getSeckillTimeList([ [ 'id', 'in', $seckill_time_id ] ]); $this->assign('seckill_info', $seckill_info[ 'data' ]); $this->assign('time_list', $time_list[ 'data' ]); return $this->fetch("seckill/editgoods"); } } public function seckillSort() { $sort = input('sort', 0); $id = input('id', 0); $seckill_model = new SeckillModel(); return $seckill_model->seckillSort($id, $sort); } /** * 删除商品 */ public function deleteGoods() { if (request()->isAjax()) { $seckill_id = input('id', 0); $site_id = $this->site_id; $seckill_model = new SeckillModel(); return $seckill_model->deleteSeckillGoods($seckill_id, $site_id); } } /** * 秒杀场次 * */ public function sessionList() { if (request()->isAjax()) { } else { $this->forthMenu(); return $this->fetch("seckill/goodslist"); } } /** * 秒杀商品 */ public function goodslist() { $seckill_time_id = input('seckill_time_id', ''); if (request()->isAjax()) { $page = input('page', 1); $page_size = input('page_size', PAGE_LIST_ROWS); $goods_name = input('goods_name', ''); $status = input('status', ''); $condition = []; $condition[] = [ 'site_id', '=', $this->site_id ]; $condition[] = [ 'goods_name', 'like', '%' . $goods_name . '%' ]; if ($status !== '') $condition[] = [ 'status', '=', $status ]; //排序 $link_sort = input('order', 'start_time'); $sort = input('sort', 'desc'); if ($link_sort == 'sort') { $order_by = $link_sort . ' ' . $sort; } else { $order_by = $link_sort . ' ' . $sort . ',sort desc'; } if (!empty($seckill_time_id)) { $condition[] = [ '', 'exp', \think\facade\Db::raw("FIND_IN_SET({$seckill_time_id},seckill_time_id)") ]; } $start_time = input('start_time', ''); $end_time = input('end_time', ''); if ($start_time && !$end_time) { $condition[] = [ 'end_time', '>=', date_to_time($start_time) ]; } elseif (!$start_time && $end_time) { $condition[] = [ 'start_time', '<=', date_to_time($end_time) ]; } elseif ($start_time && $end_time) { $start_timestamp = date_to_time($start_time); $end_timestamp = date_to_time($end_time); $sql = "start_time between {$start_timestamp} and {$end_timestamp}"; $sql .= " or end_time between {$start_timestamp} and {$end_timestamp}"; $sql .= " or (start_time <= {$start_timestamp} and end_time >= {$end_timestamp})"; $condition[] = [ '', 'exp', \think\facade\Db::raw($sql) ]; } $seckill_model = new SeckillModel(); $seckill_list = $seckill_model->getSeckillPageList($condition, $page, $page_size, $order_by); $seckill_condition[] = [ 'site_id', '=', $this->site_id ]; $time_list = $seckill_model->getSeckillTimeList($seckill_condition); foreach ($seckill_list[ 'data' ][ 'list' ] as $k => $v) { $seckill_list[ 'data' ][ 'list' ][ $k ][ 'time_list' ] = []; foreach ($time_list[ 'data' ] as $index => $item) { if (strpos(',' . $v[ 'seckill_time_id' ] . ',', ',' . $item[ 'id' ] . ',') !== false) { $seckill_list[ 'data' ][ 'list' ][ $k ][ 'time_list' ][] = $item; } } } return $seckill_list; } else { $this->forthMenu(); $condition[] = [ 'site_id', '=', $this->site_id ]; $order = 'seckill_start_time asc'; $field = '*'; $seckill_model = new SeckillModel(); $res = $seckill_model->getSeckillTimeList($condition, $field, $order, null); $this->assign('seckill_time_id', $seckill_time_id); $this->assign('res', $res[ 'data' ]); return $this->fetch("seckill/goodslist"); } } /** * 秒杀时段 */ public function seckilltimeselect() { if (request()->isAjax()) { $condition[] = [ 'site_id', '=', $this->site_id ]; $order = 'seckill_start_time asc'; $field = '*'; $seckill_model = new SeckillModel(); $res = $seckill_model->getSeckillTimeList($condition, $field, $order, null); foreach ($res[ 'data' ] as $key => $val) { $val = $seckill_model->transformSeckillTime($val); $res[ 'data' ][ $key ][ 'seckill_start_time_show' ] = "{$val['start_hour']}:{$val['start_minute']}:{$val['start_second']}"; $res[ 'data' ][ $key ][ 'seckill_end_time_show' ] = "{$val['end_hour']}:{$val['end_minute']}:{$val['end_second']}"; } return $res; } else { $this->forthMenu(); return $this->fetch("seckill/seckilltimeselect"); } } /** * 获取商品列表 * @return array */ public function getSkuList() { if (request()->isAjax()) { $seckill_model = new SeckillModel(); $seckill_id = input('seckill_id', ''); $goods_list = $seckill_model->getSeckillGoodsList($seckill_id); return $goods_list; } } /** * 手动关闭秒杀 * @return array */ public function closeSeckill() { if (request()->isAjax()) { $seckill_model = new SeckillModel(); $seckill_id = input('seckill_id', ''); $goods_list = $seckill_model->closeSeckill($seckill_id); return $goods_list; } } /** * 秒杀推广 */ public function seckillUrl() { $seckill_id = input('seckill_id', ''); $seckill_model = new SeckillModel(); // $seckill_info = $seckill_model->getSeckillInfo($seckill_id); // $seckill_info = $seckill_info[ 'data' ]; // $res = $seckill_model->qrcode($seckill_info[ 'id' ], $seckill_info['seckill_name'], $seckill_info[ 'site_id' ]); $res = $seckill_model->urlQrcode('/pages_promotion/seckill/detail', [ 'id' => $seckill_id ], 'seckill', $this->site_id); return $res; } }