/**
* scan Businesses.
*
* @return void
*/
protected function scanBusinesses()
{
$businesses = Business::all();
foreach ($businesses as $business) {
$this->sendBusinessReport($business);
}
}
public function create($id)
{
$business = Business::all()->first();
$event = Event::find($id);
$presentations = Presentation::where('event_id', $id)->where('cancelled', 0)->where('starts_at', '>', strtotime(Carbon::now()))->get();
foreach ($presentations as $presentation) {
if ($presentation->cancelled == 0 || $presentation->cancelled != null) {
$presentation->starts_at = date("d-m-Y h:i a", $presentation->starts_at);
}
}
$presentations = $presentations->lists('starts_at', 'id');
$zones = Zone::where('event_id', $id)->lists('name', 'id');
$array = ['event' => $event, 'presentations' => $presentations, 'zones' => $zones, 'business' => $business];
return view('external.booking.create', $array);
}
public function createExchangePost(exchangeGift $request)
{
$business = Business::all()->first();
$active = $business->exchange_active;
$modulo = 'La marina y el marino';
if ($active == 0) {
$giftsArr = Gift::all();
$giftsList = Gift::orderBy('id')->get()->lists('name', 'id');
$min = Gift::orderBy('id')->get()->lists('id')->first();
return view('internal.salesman.exchangeGift', ['giftsList' => $giftsList, 'giftArray' => $giftsArr, 'min' => $min, 'active' => $active]);
}
$input = $request->all();
$idGift = $input['gifts'];
$idClient = $input['nombre_de_usuario'];
$quantGift = $input['cantidad_de_regalos'];
$gift = Gift::find($idGift);
$user = User::find($idClient);
if ($gift->points * $quantGift > $user->points) {
return back()->withErrors(['El usuario no posee puntos suficientes.']);
} elseif ($gift->stock == 0) {
return back()->withErrors(['El juguete seleccionado se encuentra agotado.']);
} elseif ($gift->stock < $quantGift) {
return back()->withErrors(['No se cuenta con suficiente stock']);
}
$gift->stock = $gift->stock - $quantGift;
$gift->save();
$user->points = $user->points - $gift->points * $quantGift;
$user->save();
$giftsArr = Gift::all();
$giftsList = Gift::orderBy('id')->get()->lists('name', 'id');
$min = Gift::orderBy('id')->get()->lists('id')->first();
Session::flash('messageSucc', ' Canjeo exitoso ');
return view('internal.salesman.exchangeGift', ['giftsList' => $giftsList, 'giftArray' => $giftsArr, 'min' => $min, 'active' => $active, 'modulo' => $modulo]);
}
/**
* get List.
*
* @return Response Rendered view of all existing Businesses
*/
public function getList()
{
logger()->info(__METHOD__);
$businesses = Business::all();
return view('user.businesses.index', compact('businesses'));
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
//
$moduleassigment = ModuleAssigment::where('module_id', $id)->where('status', 1)->get();
if ($moduleassigment->count() == 0) {
$module = Module::find($id);
$module->delete();
$business = Business::all()->first();
$business->exchange_active = NULL;
$business->save();
} else {
return back()->withErrors(['Debe primero desasociar el vendedor del punto de venta']);
}
return redirect('admin/modules');
}
public function systemUpdate(UpdateSystemRequest $request)
{
$system = Business::all()->first();
$system->business_name = $request['business_name'];
$system->ruc = $request['ruc'];
$system->address = $request['address'];
$system->reserve_time = $request['reserve_time'];
if ($request['gift_module_id'] == 0) {
$system->gift_module_id = null;
} else {
$system->gift_module_id = $request['gift_module_id'];
}
if (isset($request['logo'])) {
$system->logo = $this->file_service->upload($request->file('logo'), 'system');
}
if (isset($request['favicon'])) {
$system->favicon = $this->file_service->upload($request->file('favicon'), 'system');
}
if ($request['exchange_active'] == true) {
$system->exchange_active = true;
} else {
if ($request['exchange_active'] == false) {
$system->exchange_active = false;
}
}
$system->save();
Session::flash('message', 'Se actualizaron los datos!');
Session::flash('alert-class', 'alert-success');
return redirect()->back();
}
public static function getActiveBusinesses()
{
/*
return DB::table('business')->join('branch', 'business.business_id', '=', 'branch.business_id')
->join('service', 'branch.branch_id', '=', 'service.branch_id')
->join('priority_number', 'service.service_id', '=', 'priority_number.service_id')
->join('priority_queue', 'priority_number.track_id', '=', 'priority_queue.track_id')
->join('terminal_transaction', 'priority_queue.transaction_number', '=', 'terminal_transaction.transaction_number')
->where('terminal_transaction.time_queued', '!=', 0)
->select(array('business.business_id', 'business.name', 'business.local_address'))
->get();
*/
$active_businesses = array();
$businesses = Business::all();
foreach ($businesses as $count => $business) {
$branches = Branch::getBranchesByBusinessId($business->business_id);
foreach ($branches as $count2 => $branch) {
$services = Service::getServicesByBranchId($branch->branch_id);
foreach ($services as $count3 => $service) {
$priority_numbers = PriorityNumber::getTrackIdByServiceId($service->service_id);
foreach ($priority_numbers as $count4 => $priority_number) {
$priority_queues = PriorityQueue::getTransactionNumberByTrackId($priority_number->track_id);
foreach ($priority_queues as $count5 => $priority_queue) {
$terminal_transactions = TerminalTransaction::getTimesByTransactionNumber($priority_queue->transaction_number);
foreach ($terminal_transactions as $count6 => $terminal_transaction) {
$grace_period = time() - $terminal_transaction->time_queued;
// issued time must be on the current day to count as active
if ($terminal_transaction->time_queued != 0 && $terminal_transaction->time_completed == 0 && $terminal_transaction->time_removed == 0 && $grace_period < 86400) {
// 1 day; 60secs * 60 min * 24 hours
$active_businesses[$business->business_id] = array('local_address' => $business->local_address, 'name' => $business->name);
break;
}
}
if (array_key_exists($business->business_id, $active_businesses)) {
break;
}
}
if (array_key_exists($business->business_id, $active_businesses)) {
break;
}
}
if (array_key_exists($business->business_id, $active_businesses)) {
break;
}
}
if (array_key_exists($business->business_id, $active_businesses)) {
break;
}
}
}
return $active_businesses;
}
