Example #1
0
 function top_up_log()
 {
     /////////////////
     // Load Filter //
     /////////////////
     $filters = $this->request->only('id', 'title', 'slug', 'skip', 'take', 'mode');
     if (!$filters['take']) {
         $filters['take'] = 50;
     } else {
         $filters['take'] = min($filters['take'] * 1, 50);
     }
     $filters['skip'] = $filters['skip'] * 1;
     ///////////
     // Query //
     ///////////
     $q = new Model();
     if ($filters['id']) {
         $count = $q->count();
         $data = $q->where('travel_agent._id', $filters['id'])->skip($filters['skip'])->take($filters['take'])->get();
     } else {
         $count = $q->count();
         switch ($filters['mode']) {
             case 'latest_created':
                 $q = $q->latest('created_at');
                 break;
             case 'latest_published':
                 $q = $q->latest('published_at');
                 break;
         }
         $data = $q->skip($filters['skip'])->take($filters['take'])->get();
     }
     //////////////
     // Response //
     //////////////
     return response()->json(JSend::success(['count' => $count, 'data' => $data->toArray()])->asArray());
 }
Example #2
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());
     }
 }
 /**
  * lock around 20 - next 20
  *
  * @return void
  * @author 
  **/
 public function calculatebalance()
 {
     \Log::info('Re calculate ads` balance @' . date('Y-m-d H:i:s'));
     $tours = Tour::published()->upcomingtour()->adsstarted('now')->with('travel_agent')->get();
     $now = \Carbon\Carbon::now()->format('Y-m-d');
     foreach ($tours as $key => $value) {
         foreach ($value['ads'] as $key2 => $value2) {
             $query = [];
             $query[] = ['$match' => ['ads_id' => ['$eq' => $value2['ad_id']]]];
             $query[] = ['$group' => ['_id' => '$ads_id', 'count' => ['$sum' => '$credit.credit_balance'], 'total' => ['$sum' => 1]]];
             $prev_calc = TopUpLog::raw(function ($collection) use($query, $value2) {
                 return $collection->aggregate($query);
             })->toArray();
             $started = \Carbon\Carbon::parse($value2['started_at']);
             $days = $started->diffInDays(\Carbon\Carbon::parse('today'));
             $today_balance = $value2['initial_credit'] - $days * $value2['daily_rate'];
             if ($value2['started_at'] <= $now && $value2['today_balance'] > 0 && ($prev_calc[0]['count'] > 0 && $prev_calc[0]['count'] != $today_balance || is_null($prev_calc[0]))) {
                 $new_balance = $value['ads'];
                 $new_balance[$key2]['today_balance'] = $value2['initial_credit'] - $days * $value2['daily_rate'];
                 if (is_null($prev_calc[0]['count'])) {
                     $new_balance[$key2]['credit_balance'] = 0 - $new_balance[$key2]['today_balance'];
                 } else {
                     $new_balance[$key2]['credit_balance'] = 0 - ($prev_calc[0]['count'] - $new_balance[$key2]['today_balance']);
                 }
                 $value->ads = $new_balance;
                 $attributes['name'] = 'Auto debit Top Up';
                 $attributes['ads_id'] = $value2['ad_id'];
                 $attributes['transact_at'] = \Carbon\Carbon::now()->format('Y-m-d');
                 $attributes['travel_agent']['_id'] = $value->travel_agent['_id'];
                 $attributes['travel_agent']['name'] = $value->travel_agent['name'];
                 $attributes['credit']['started_at'] = $value2['started_at'];
                 $attributes['credit']['initial_credit'] = $value2['initial_credit'] * 1;
                 $attributes['credit']['daily_rate'] = $value2['daily_rate'] * 1;
                 $attributes['credit']['today_balance'] = $new_balance[$key2]['today_balance'] * 1;
                 $attributes['credit']['credit_balance'] = $new_balance[$key2]['credit_balance'];
                 $attributes['credit']['tags'] = $value2['tags'];
                 $attributes['tour']['_id'] = $value['_id'];
                 $attributes['tour']['name'] = $value['name'];
                 $attributes['tour']['tags'] = $value['tags'];
                 $top_up = new TopUpLog();
                 $top_up->fill($attributes);
                 if (!$top_up->save()) {
                     \Log::error(json_encode($top_up->getError()));
                 }
             }
         }
         if (!$value->save()) {
             \Log::error(json_encode($value->getError()));
         }
     }
     return true;
 }