Example #1
0
 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'));
 }
Example #2
0
 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'));
 }
Example #3
0
 /**
  * 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());
     }
 }
Example #4
0
 /**
  * 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());
     }
 }