public function storeSlave(Request $request)
 {
     $name = $request->input('data.name', null);
     if ($name != null) {
         $dominio = Domain::where('name', '=', $name)->first();
         if ($dominio != null) {
             return response()->json(['error' => 'zoneSlave_exists'], 409);
         }
         $slave = new Domain();
         $slave->name = $request->input('data.name');
         $slave->master = $request->input('data.nameserver');
         $slave->type = 'SLAVE';
         $slave->save();
         $id = $slave->id;
         $zones = new Zone();
         $zones->domain_id = $id;
         $zones->owner = '1';
         $zones->comment = '';
         $zones->zone_templ_id = '0';
         $zones->save();
         return response()->json(['success' => 'zoneSlave_created'], 200);
     } else {
         return response()->json(['error' => 'zoneSlave_error'], 400);
     }
 }
 public function destroy($id)
 {
     $domain = Domain::find($id);
     if ($domain = null) {
         return response()->json(['error' => 'domain_does_not_existe'], 400);
     }
     $domain_id = $id;
     $zones = Zone::where('domain_id', '=', $domain_id)->delete();
     $records = Record::where('domain_id', '=', $domain_id)->delete();
     $domain = Domain::where('id', '=', $id)->delete();
     return response()->json(['success'], 200);
 }
 public function storePayBooking(BookingRequest $request)
 {
     $reserve_id = $request->input('reserve_id');
     $ticket = Ticket::where('reserve', $reserve_id)->get()->first();
     if (empty($ticket)) {
         return redirect()->back()->withErrors(['error' => 'no hay reservas para el codigo especificado']);
     }
     $nTickets = $ticket->quantity;
     $ticket->payment_date = new Carbon();
     $ticket->cancelled = false;
     $ticket->salesman_id = \Auth::user()->id;
     $ticket->picked_up = true;
     $ticket->updated_at = new Carbon();
     $ticket->reserve = null;
     $id = $ticket->id;
     $ticket->save();
     $tickets = array();
     $user = Auth::user();
     if ($request['promotion_id'] != "") {
         $promo = Promotions::find($request['promotion_id']);
         if ($promo->desc != null) {
             DB::table('tickets')->where('id', $id)->update(['discount' => $promo->desc]);
             DB::table('tickets')->where('id', $id)->decrement('total_price', $promo->desc / 100 * ($nTickets * $zone->price));
         } else {
             $pu = Zone::find($ticket->zone_id)->price;
             $quantity = $ticket->quantity;
             $pt = $pu * $quantity;
             $discTickets = $quantity / $promo->carry;
             $discTickets = floor($discTickets);
             $pd = $pt - $discTickets * $pu;
             $desc = 100 - $pd / $pt * 100;
             DB::table('tickets')->where('id', $id)->update(['discount' => $desc]);
             DB::table('tickets')->where('id', $id)->update(['total_price' => $pd]);
         }
         DB::table('tickets')->where('id', $id)->update(['promo_id' => $promo->id]);
     }
     $price = $ticket->total_price;
     if ($request['payMode'] == config('constants.credit')) {
         DB::table('tickets')->where('id', $id)->update(['credit_amount' => $price]);
     } else {
         if ($request['payMode'] == config('constants.cash')) {
             DB::table('tickets')->where('id', $id)->update(['cash_amount' => $price]);
             if ($user->role_id == config('constants.salesman')) {
                 DB::table('modules')->where('id', $user->module_id)->increment('actual_cash', $price);
             }
         } else {
             if ($request['payMode'] == config('constants.mix')) {
                 DB::table('tickets')->where('id', $id)->update(['cash_amount' => $request['paymentMix']]);
                 DB::table('tickets')->where('id', $id)->update(['credit_amount' => $price - $request['paymentMix']]);
                 if ($user->role_id == config('constants.salesman')) {
                     DB::table('modules')->where('id', $user->module_id)->increment('actual_cash', $request['paymentMix']);
                 }
             }
         }
     }
     array_push($tickets, $ticket->id);
     DB::table('users')->where('id', $ticket->owner_id)->increment('points', $nTickets);
     DB::table('slot_presentation')->where('sale_id', $ticket->id)->update(['status' => config('constants.seat_taken')]);
     session(['tickets' => $id]);
     return redirect()->route('ticket.success.salesman');
 }
Esempio n. 4
0
 public function getPromo(request $request)
 {
     $maxDiscount = 0;
     $bestPromo = null;
     if ($request['type_id'] == config('constants.credit')) {
         $promo_disc = Promotions::where('event_id', $request['event_id'])->where('access_id', 2)->where('startday', '<', Carbon::now())->where('endday', '>', Carbon::now())->get();
     } else {
         if ($request['type_id'] == config('constants.cash')) {
             $promo_disc = Promotions::where('event_id', $request['event_id'])->where('access_id', 1)->where('startday', '<', Carbon::now())->where('endday', '>', Carbon::now())->get();
         } else {
             $promos = null;
             return null;
         }
     }
     $promos = Promotions::where('event_id', $request['event_id'])->where('typePromotion', 2)->where('startday', '<', Carbon::now())->where('endday', '>', Carbon::now())->get();
     $promos = $promos->merge($promo_disc);
     if ($promos) {
         foreach ($promos as $promo) {
             if ($promo->typePromotion == config('constants.discount')) {
                 if ($promo->desc > $maxDiscount) {
                     $pu = Zone::find($request['zone_id'])->price;
                     $quantity = $request['quantity'];
                     $pt = $pu * $quantity;
                     $pd = $pt - $pt * $promo->desc / 100;
                     $maxDiscount = $promo->desc;
                     $bestPromo = ['id' => $promo->id, 'amount' => $pd];
                 }
             } else {
                 if ($promo->zone_id == $request['zone_id']) {
                     $pu = Zone::find($request['zone_id'])->price;
                     $quantity = $request['quantity'];
                     $pt = $pu * $quantity;
                     $discTickets = $quantity / $promo->carry;
                     $discTickets = floor($discTickets);
                     $pd = $pt - $discTickets * $pu * ($promo->carry - $promo->pay);
                     $desc = 100 - $pd / $pt * 100;
                     if ($desc >= $maxDiscount) {
                         $maxDiscount = $desc;
                         $promo->desc = $desc;
                         $bestPromo = ['id' => $promo->id, 'amount' => $pd];
                     }
                 }
             }
         }
     }
     return $bestPromo;
     /*
     $maxDiscount = 0;
     $bestPromo = null;
     if($request['type_id']==config('constants.credit')){
         $promo_disc = Promotions::where('event_id',$request['event_id'])->where('access_id',2)->where('startday','<',Carbon::now())->where('endday','>',Carbon::now())->get();
     }else if($request['type_id']==config('constants.cash')){
         $promo_disc = Promotions::where('event_id',$request['event_id'])->where('access_id',1)->where('startday','<',Carbon::now())->where('endday','>',Carbon::now())->get();
     }else{
         $promos = null;
     }
     
     $promos = Promotions::where('event_id',$request['event_id'])->where('typePromotion',2)->where('startday','<',Carbon::now())->where('endday','>',Carbon::now())->get();
     $promos = $promos->merge($promo_disc);
     
     if($promos){
         foreach ($promos as $promo) {
             if ($promo->typePromotion == config('constants.discount')){
                 if ($promo->desc > $maxDiscount){
                     $maxDiscount = $promo->desc;
                     $bestPromo = $promo;
                 }
     
             }else{
             	if($promo->zone_id == $request['zone_id']){
     
     	                	$pu = Zone::find($request['zone_id'])->price;
     	                	$quantity = $request['quantity'];
     	                	$pt = $pu * $quantity;
     	                	$discTickets = $quantity / $promo->carry;
     	                	$discTickets = floor($discTickets);
     	                	$pd = $pt - $discTickets*$pu;
     	                	$desc = 100 - ($pd/$pt)*100;
     	                	if ($desc >= $maxDiscount){
     	                		$maxDiscount = $desc;
     	                		$promo->desc = $desc;
     	                        $bestPromo = $promo;
     
     	                	}
             	}
             }
     
         }
     }
     return $bestPromo;
     */
 }
Esempio n. 5
0
 public function getZoneSeatsIds(Request $request)
 {
     $zona = Zone::find($request['zone_id']);
     $local = $zona->event->place;
     $arreglo = array();
     $slots = $zona->slots;
     foreach ($slots as $slot) {
         $id = $slot->row . "_" . $slot->column;
         array_push($arreglo, $id);
     }
     return $arreglo;
 }
Esempio n. 6
0
 public function ajax($event_id)
 {
     $zones = Zone::where('event_id', $event_id)->lists('name', 'id');
     return json_encode($zones);
 }