public function checkInventory($item, $size) { $checkInventory = \App\Inventory::where('product_id', $item)->pluck($size) - $this->cartInventory($item, $size); if ($checkInventory > 0) { return 1; } }
public function dispense($ic, $name) { $getID = Patient::where('pt_ic', $ic)->first(); //whole row $deID = $getID->id; //get the id from the ic $getcaseID = Record::where('pt_id', $deID)->first(); $caseID = $getcaseID->id; $disData = Dispensary::where('case_ref', $caseID)->first(); //xpe pakai first() sbb setiap case unik, case lain xpakai id ni $arrQty = explode("#", $disData->dispensed_quantity); $arrDrug = explode("#", $disData->dispensed_drug_code); //need declare $prices array x? $prices = array(); for ($x = 0; $x < count($arrDrug) - 1; $x++) { //get price of each drug into an array $hehe = Inventory::where('drug_name', $arrDrug[$x])->first(); $prices[$x] = $hehe->spu; } // $arrOne = count($arrDrug); // arr1 = druglist , arr2= respective qty of drug, arr3= respective price of drug $panel = Panel::all(); return view('staff.dispensary')->with('name', $name)->with('arr2', $arrQty)->with('arr1', $arrDrug)->with('arr3', $prices)->with('panel', $panel)->with('ptid', $deID); }
public function deleteItem($conferenceId, $itemId) { $item = Inventory::where('conferenceID', $conferenceId)->where('id', $itemId); if ($item->delete()) { return response()->json(['message' => 'item_deleted'], 200); } else { return response()->json(['message' => 'item_could_not_be_deleted'], 500); } }
private function modifyQuantity(Request $request, $modifier) { $inventory = new Inventory(); $item = $inventory->where("product_id", "=", $request->product_id)->first(); $item->quantity = $item->quantity + $modifier; if ($item->quantity < 0) { $item->quantity = 0; return false; } $item->save(); return json_encode($item); }
/** * A movie can be returned to any Kiosk so update kiosk and make movie available * * @param $id * @param $kiosk */ private function markReturned($id, $kiosk) { Inventory::where('id', $id)->update(['isRented' => 0, 'kiosk_id' => $kiosk]); }
public function completePayment(Request $request, SlackHandler $slacker) { // Set your secret key: remember to change this to your live secret key in production // See your keys here https://dashboard.stripe.com/account/apikeys Stripe::setApiKey(env('STRIPE_SK')); // Get the credit card details submitted by the form $token = $request->input('stripeToken'); // dd(\Session::get('cart_id')); if (!\Session::get('cart_id')) { return redirect()->route('alreadyPaid'); } if (\App\Shipping::where('cart_id', \Session::get('cart_id'))->pluck('payment_status') == 'Paid') { return redirect()->route('alreadyPaid'); } // $charge = 0; // $cart->checkoutPrice() // Create the charge on Stripe's servers - this will charge the user's card try { $charge = Charge::create(array("amount" => round($this->getCheckoutPrice()), "currency" => "usd", "source" => $token, "description" => \Session::get('cart_id'))); } catch (\Stripe\Error\Card $e) { // The card has been declined } $cart_id = \Session::get('cart_id'); $markPaid = \App\Shipping::where('cart_id', \Session::get('cart_id'))->first(); $markPaid->payment_status = 'Paid'; $markPaid->shipped_status = 'Not Shipped'; $markPaid->save(); $slacker->sendSaleMessage(); \App\Sale::create(array('customer_id' => $markPaid->email, 'cart_id' => \Session::get('cart_id'))); $purge = []; foreach (\App\Cart::where('customer_id', $cart_id)->get() as $purgeCarts) { $purge[] = $purgeCarts; $inventory = \App\Inventory::where('product_id', $purgeCarts->product_id)->pluck($purgeCarts->size); $newsize = $inventory - $purgeCarts->quantity; \DB::table('inventories')->where('product_id', $purgeCarts->product_id)->update(array($purgeCarts->size => $newsize)); } if (env('APP_ENV') == 'local') { \Mail::send('emails.productshipped', array('cart' => \App\Cart::where('customer_id', $cart_id)->get(), 'customer' => \App\Shipping::where('cart_id', $cart_id)->first()), function ($message) { $message->to(\App\Shipping::where('cart_id', \Session::get('cart_id'))->pluck('email'))->subject("Your Eternally Nocturnal Order"); }); } else { \Mail::send('emails.productshipped', array('cart' => \App\Cart::where('customer_id', $cart_id)->get(), 'customer' => \App\Shipping::where('cart_id', $cart_id)->first()), function ($message) { $message->to(\App\Shipping::where('cart_id', \Session::get('cart_id'))->pluck('email'))->subject("Your Eternally Nocturnal Order"); }); } \Session::forget('cart_id'); \Session::forget('checkoutAmt'); return redirect()->route('transSuccess'); }