function last_updated_travel_agent() { /////////// // Query // /////////// $query[] = ['$match' => ['published_at' => ['$lte' => \Carbon\Carbon::now()->format('Y-m-d')]]]; $query[] = ['$group' => ['_id' => '$travel_agent_id', 'travel_agent_id' => ['$push' => '$travel_agent_id'], 'last_updated_at' => ['$first' => '$created_at']]]; $query[] = ['$sort' => ['last_updated_at' => 1]]; ////////////////////////////// // Get Result // ////////////////////////////// $data = []; $total_tour = Tour::raw(function ($collection) use($query) { return $collection->aggregate($query); }); foreach ($total_tour as $key => $value) { $new = TravelAgent::find($value['_id']); if ($new) { $new['last_updated_at'] = $value['last_updated_at']; $data[] = $new->toArray(); } } return response()->json(JSend::success(['count' => count($data), 'data' => $data])->asArray())->setCallback($this->request->input('callback')); }
function index() { ///////////////// // Load Filter // ///////////////// $filters = $this->request->only('skip', 'take', 'with_count'); $filters['skip'] = max((int) $filters['skip'], 0); $filters['take'] = min((int) $filters['take'], 100); /////////// // Query // /////////// $query[] = ['$unwind' => '$schedules']; $query[] = ['$unwind' => '$schedules.vouchers']; // Sort switch ($filters['mode']) { case 'latest': $query[] = ['$sort' => ['schedules.vouchers.created_at' => -1]]; break; case 'latest-updated': $query[] = ['$sort' => ['schedules.vouchers.updated_at' => -1]]; break; case 'biggest': $query[] = ['$sort' => ['schedules.vouchers.currency' => 1, 'schedules.vouchers.amount' => -1]]; break; default: $query[] = ['$sort' => ['schedules.vouchers.price' => -1]]; break; } if ($filters['skip']) { $query[] = ['$skip' => $filters['skip']]; } if ($filters['take']) { $query[] = ['$limit' => $filters['take']]; } $data = Model::raw(function ($collection) use($query) { return $collection->aggregate($query); }); /////////////////// // Reformat data // /////////////////// foreach ($data['result'] as $k => $v) { $data['result'][$k]['_id'] = $data['result'][$k]['_id'] . ''; $data['result'][$k]['created_at'] = date('Y-m-d H:i:s', $data['result'][$k]['created_at']->sec); $data['result'][$k]['updated_at'] = date('Y-m-d H:i:s', $data['result'][$k]['updated_at']->sec); } ////////////////////// // Load Travel Agent// ////////////////////// foreach ($data['result'] as $k => $v) { $travel_agent_ids[] = $v['travel_agent_id']; } if (count($travel_agent_ids)) { $results = TravelAgent::find(array_unique($travel_agent_ids)); foreach ($results as $x) { $travel_agents[$x->_id] = $x->toArray(); } } ///////////////////////////////////// // Add travel agent to each result // ///////////////////////////////////// foreach ($data['result'] as $k => $v) { $data['result'][$k]['travel_agent'] = $travel_agents[$v['travel_agent_id']]; } ////////////// // Response // ////////////// return response()->json(JSend::success(['count' => $count, 'data' => $data['result']])->asArray())->setCallback($this->request->input('callback')); }
/** * store a resource * @param Request $request http request * @param mixed $id id of the resource for updating * @return jsend jsend with newly stored source */ function store($id = null) { //////////////// // Load Data // //////////////// if ($id) { $data = Model::find($id); if (!$data) { return app()->abort(404); } } else { $data = new Model(); } /////////////////////////////////// // Assign posted data to Data // /////////////////////////////////// $data->fill($this->request->input()); $data->slug = Model::generateSlug($data->name, $data->_id); ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// // REMOVE THIS AFTERWARD // ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// // $data->created_at = $this->request->input('created_at'); /////////////////////////////////////////////////////////////////// // Validate data // /////////////////////////////////////////////////////////////////// # Validate Travel Agent $travel_agent = TravelAgent::find($this->request->input('travel_agent_id')); if (!$travel_agent) { return response()->json(JSend::fail(['travel_agent_id' => ['Travel Agent is not recognized']])->asArray())->setCallback($this->request->input('callback')); } $data->travel_agent_id = $travel_agent->id; /////////////////////// // EMBED IMAGES // /////////////////////// foreach ($this->request->input('images') as $x) { $images[] = new Image($x); } if (!$data->syncImages($images)) { return response()->json(JSend::fail($data->getErrors())->asArray())->setCallback($this->request->input('callback')); } /////////////////////// // EMBED TAGS // /////////////////////// foreach ($this->request->input('tags') as $x) { if ($x['tag'] && $x['type']) { $tags[] = new Tag($x); } } if (!$data->syncTags($tags)) { return response()->json(JSend::fail($data->getErrors())->asArray())->setCallback($this->request->input('callback')); } //////////////////////// // EMBED TourSchedule // //////////////////////// foreach ($this->request->input('schedules') as $x) { if ($x['_id']) { $tour_schedule = $data->schedules->where('_id', $x['_id'])->first(); if (!$tour_schedule) { return app()->abort(404); } $tour_schedule->fill($x); } else { $tour_schedule = new TourSchedule($x); } ////////////////////// // Sync Promo // ////////////////////// $promos = []; foreach ($x['promos'] as $promo_array) { if ($promo_array['_id']) { $promo = $tour_schedule->promos->where('_id', $promo_array['_id']['$id'])->first(); if (!$promo) { return app()->abort(404); } $promo->fill($promo_array); $promos[] = $promo; } else { $promos[] = new Promo($promo_array); } } if (!$tour_schedule->syncPromo($promos)) { return response()->json(JSend::fail($tour_schedule->getErrors())->asArray())->setCallback($this->request->input('callback')); } ////////////////////// // Sync Voucher // ////////////////////// $vouchers = []; foreach ($x['vouchers'] as $voucher_array) { if ($voucher_array['_id']) { $voucher = $tour_schedule->vouchers->where('_id', $voucher_array['_id']['$id'])->first(); if (!$voucher) { return App()->abort(404); } $voucher->fill($voucher_array); $vouchers[] = $voucher; } else { $vouchers[] = new Voucher($voucher_array); } } if (!$tour_schedule->syncVoucher($vouchers)) { return response()->json(JSend::fail($tour_schedule->getErrors())->asArray())->setCallback($this->request->input('callback')); } $tour_schedules[] = $tour_schedule; } if (!$data->syncTourSchedules($tour_schedules)) { return response()->json(JSend::fail($data->getErrors())->asArray())->setCallback($this->request->input('callback')); } /////////////////////// // EMBED PACKAGE // /////////////////////// if (!$data->syncTourPackage(new TourPackage($this->request->input('package')))) { return response()->json(JSend::fail($data->getErrors())->asArray())->setCallback($this->request->input('callback')); } ////////////////// // Check Top Up // ////////////////// if ($data->ads) { $older_data = $data->getOriginal(); } /////////// // Store // /////////// if ($data->save()) { $new_ads = $data->ads; if ($data->ads) { $ids_inc = []; foreach ($data->ads as $key => $value) { //1. Check if new data if (empty($value['ad_id'])) { $new_ad = $data->ads[$key]; $new_ad['ad_id'] = uniqid(); $new_ads[$key] = $new_ad; $attributes['name'] = 'Top Up'; $attributes['ads_id'] = $new_ad['ad_id']; $attributes['transact_at'] = \Carbon\Carbon::now()->format('Y-m-d'); $attributes['travel_agent']['_id'] = $data->travel_agent['_id']; $attributes['travel_agent']['name'] = $data->travel_agent['name']; $attributes['credit']['started_at'] = $data->ads[$key]['started_at']; $attributes['credit']['initial_credit'] = $data->ads[$key]['initial_credit'] * 1; $attributes['credit']['daily_rate'] = $data->ads[$key]['daily_rate'] * 1; $attributes['credit']['today_balance'] = $data->ads[$key]['today_balance'] * 1; $attributes['credit']['credit_balance'] = $data->ads[$key]['credit_balance'] * 1; $attributes['credit']['tags'] = $data->ads[$key]['tags']; $attributes['tour']['_id'] = $data['_id']; $attributes['tour']['name'] = $data['name']; $attributes['tour']['tags'] = $data['tags']->toArray(); $top_up = new TopUpLog(); $top_up->fill($attributes); if (!$top_up->save()) { $error_responses = []; foreach ($top_up->getErrors() as $field => $errors) { $error_responses[$field] = implode(', ', $errors); } return response()->json(JSend::fail($top_up->getErrors())->asArray()); } } elseif ($older_data['ads'][$key]['started_at'] != $data->ads[$key]->started_at || $older_data['ads'][$key]['initial_credit'] != $data->ads[$key]->initial_credit || $older_data['ads'][$key]['daily_rate'] != $data->ads[$key]->daily_rate || $older_data['ads'][$key]['today_balance'] != $data->ads[$key]->today_balance || $older_data['ads'][$key]['credit_balance'] != $data->ads[$key]->credit_balance) { //emptied last balance $last_balance = TopUpLog::where('ads_id', $older_data['ads'][$key]['ad_id'])->orderBy('created_at', 'desc')->first(); if ($last_balance && $last_balance['credit']['today_balance'] > 0) { $attributes['name'] = 'Emptied Top Up'; $attributes['ads_id'] = $older_data['ads'][$key]['ad_id']; $attributes['transact_at'] = \Carbon\Carbon::now()->format('Y-m-d'); $attributes['travel_agent']['_id'] = $data->travel_agent['_id']; $attributes['travel_agent']['name'] = $data->travel_agent['name']; $attributes['credit']['started_at'] = $older_data['ads'][$key]['started_at']; $attributes['credit']['initial_credit'] = $older_data['ads'][$key]['initial_credit'] * 1; $attributes['credit']['daily_rate'] = $older_data['ads'][$key]['daily_rate'] * 1; $attributes['credit']['today_balance'] = 0 * 1; $attributes['credit']['credit_balance'] = (0 - $older_data['ads'][$key]['today_balance']) * 1; $attributes['credit']['tags'] = $older_data['ads'][$key]['tags']; $attributes['tour']['_id'] = $older_data['_id']; $attributes['tour']['name'] = $older_data['name']; $attributes['tour']['tags'] = $older_data['tags']; $top_up = new TopUpLog(); $top_up->fill($attributes); if (!$top_up->save()) { $error_responses = []; foreach ($top_up->getErrors() as $field => $errors) { $error_responses[$field] = implode(', ', $errors); } return response()->json(JSend::fail($top_up->getErrors())->asArray()); } } //create new top up $new_ad = $data->ads[$key]; $new_ads[$key] = $new_ad; $attributes['name'] = 'Edited Top Up'; $attributes['ads_id'] = $new_ad['ad_id']; $attributes['transact_at'] = \Carbon\Carbon::now()->format('Y-m-d'); $attributes['travel_agent']['_id'] = $data->travel_agent['_id']; $attributes['travel_agent']['name'] = $data->travel_agent['name']; $attributes['credit']['started_at'] = $data->ads[$key]['started_at'] * 1; $attributes['credit']['initial_credit'] = $data->ads[$key]['initial_credit'] * 1; $attributes['credit']['daily_rate'] = $data->ads[$key]['daily_rate'] * 1; $attributes['credit']['today_balance'] = $data->ads[$key]['initial_credit'] * 1; $attributes['credit']['credit_balance'] = $data->ads[$key]['initial_credit'] * 1; $attributes['credit']['tags'] = $data->ads[$key]['tags']; $attributes['tour']['_id'] = $data['_id']; $attributes['tour']['name'] = $data['name']; $attributes['tour']['tags'] = $data['tags']->toArray(); $top_up = new TopUpLog(); $top_up->fill($attributes); if (!$top_up->save()) { $error_responses = []; foreach ($top_up->getErrors() as $field => $errors) { $error_responses[$field] = implode(', ', $errors); } return response()->json(JSend::fail($top_up->getErrors())->asArray()); } } if ($new_ad['ad_id']) { $ids_inc[] = $new_ad['ad_id']; } } //3. Check if deleted data foreach ($older_data['ads'] as $key => $value) { if (!in_array($value['ad_id'], $ids_inc)) { $attributes['name'] = 'Deleted Top Up'; $attributes['ads_id'] = $older_data['ads'][$key]['ad_id']; $attributes['transact_at'] = \Carbon\Carbon::now()->format('Y-m-d'); $attributes['travel_agent']['_id'] = $older_data['travel_agent']['_id']; $attributes['travel_agent']['name'] = $older_data['travel_agent']['name']; $attributes['credit']['started_at'] = $older_data['ads'][$key]['started_at'] * 1; $attributes['credit']['initial_credit'] = $older_data['ads'][$key]['initial_credit'] * 1; $attributes['credit']['daily_rate'] = $older_data['ads'][$key]['daily_rate'] * 1; $attributes['credit']['today_balance'] = 0 * 1; $attributes['credit']['credit_balance'] = (0 - $older_data['ads'][$key]['today_balance']) * 1; $attributes['credit']['tags'] = $older_data['ads'][$key]['tags']; $attributes['tour']['_id'] = $older_data['_id']; $attributes['tour']['name'] = $older_data['name']; $attributes['tour']['tags'] = $older_data['tags']; $top_up = new TopUpLog(); $top_up->fill($attributes); if (!$top_up->save()) { $error_responses = []; foreach ($top_up->getErrors() as $field => $errors) { $error_responses[$field] = implode(', ', $errors); } return response()->json(JSend::fail($top_up->getErrors())->asArray()); } } } $data->ads = $new_ads; if (!$data->save()) { return response()->json(JSend::fail($data->getErrors())->asArray()); } } return response()->json(JSend::success(['data' => $data])->asArray()); } else { $error_responses = []; foreach ($data->getErrors() as $field => $errors) { $error_responses[$field] = implode(', ', $errors); } return response()->json(JSend::fail($data->getErrors())->asArray()); } }
/** * delete * @param Request $this->request [description] * @param [type] $id [description] * @return [type] [description] */ public function destroy($id = null) { //////////////// // Load Data // //////////////// if ($id) { $data = Model::find($id); if (!$data) { return app()->abort(404); } } else { $data = new Model(); } /////////// // Store // /////////// if ($data->delete()) { return response()->json(JSend::success(['data' => $data])->asArray()); } else { return response()->json(JSend::fail($data->getErrors())->asArray()); } }