public function sendEmail() { //get all items that are low $items = Item::whereRaw('quantity <= email_threshold')->where('active', '=', 1)->get(); //mails to Coordinators $to = implode(', ', DB::table('users')->where('positions_id', '=', 6)->lists('email')); //Declares the subject for the email $subject = "Low Inventory Update"; //"From:"" Header $headers = 'From: Inventory Updater' . "\r\n"; //first two lines of the message $message = "-Automated message from Inventory Control System-\r\nThe following items need to be ordered:\r\n\r\n\r\n"; //for each item, it formats the output and adds it to the message foreach ($items as $item) { $vendorId = Vendor::where('id', '=', $item->vendor_id)->pluck('name'); $message .= $item->name . " | On-Hand: " . $item->quantity . "\r\n"; $message .= "Email Threshold set for order prompt at " . $item->email_threshold . " remaining.\r\n"; $message .= "Order from " . $vendorId . " at " . $item->item_url . "\r\n\r\n"; } //adds the final lines to message. $message .= "\r\nThe inventory site can be reached at: https://loftythoughts.me/caeweb/inventory/ \r\n"; $signature = "\r\n\r\nCAE Center"; $message .= $signature; //sends the email mail($to, $subject, $message, $headers); }
public function getIndex() { //Get the items from the StoreDB $store_items = Item::whereRaw("loadout_slot IN ( 'brillen','hats','pets','skin','snorren','piemol','vogel','jetpack' )")->get(); //Sort them $store_items = $store_items->sortBy(function ($store_item) { return $store_item->loadout_slot; //sort them by loadout slot }); $paymentprovider = DB::table('sd_payment_providers')->orderBy('pos', 'desc')->get(); $user = Sentinel::check(); $sd_items = SDItem::where('visible', '1')->get(); //Build the view return View::make('item.overview', array('items' => $store_items, 'sditems' => $sd_items, 'payment_providers' => $paymentprovider, 'user' => $user)); }
}); }); </script> <div id="page-wrapper"> <div class="row"> <div class="col-md-12" id="div-warning" class="" style='position:fixed;display:none;right:0;z-index:9999;'> <div class="alert alert-danger"> <table class="table table-hover" width=80%> <thead> <th>ID</th> <th>Model_number</th> <th>Total Quantity</th> </thead> <?php $itemWarning = Item::whereRaw('total_quantity <= alert_quantity')->get(); foreach ($itemWarning as $key => $value) { echo '<tr>'; echo '<td>' . $value['id'] . '</td>'; echo '<td>' . $value['model_number'] . '</td>'; echo '<td>' . $value['total_quantity'] . '</td>'; echo '</tr>'; } ?> </table> </div> </div> </div> <div id="page-inner">