public function getAdDeactive() { // Get all ad actived $arr_ids = array(); $records = AdActive::where('status', '=', 1)->take(self::$limit_crawl_ad_active)->get(); if ($records->count()) { $now = Carbon::now(); foreach ($records as $record) { $created = new Carbon($record->created_at); if ($created->diff($now)->days >= $record->day) { $arr_ids[] = $record->ad_id; } } if (count($arr_ids)) { DB::beginTransaction(); try { Ad::whereIn('id', $arr_ids)->update(array('status' => 0)); AdActive::whereIn('ad_id', $arr_ids)->update(array('status' => 0)); } catch (Exception $ex) { DB::rollback(); } DB::commit(); } } return Response::json(array('status' => 'success', 'data' => $arr_ids), 200); }