/**
* Display a listing of the resource.
*
* @return Response
*/
public function index(Request $request)
{
$status = $request->input('status');
switch ($status) {
case 'complete':
$work_orders = WorkOrder::where('completed', 1)->paginate(2);
break;
case 'incomplete':
$work_orders = WorkOrder::where('completed', 0)->paginate(2);
break;
default:
$work_orders = WorkOrder::paginate(2);
}
return view('dashboard.home', compact('work_orders'));
}
public function finalizePurchaseOrder($poId)
{
$returnData = [];
try {
\DB::beginTransaction();
// Mark completed field for all work orders for this PO
WorkOrder::where('purchase_order_id', $poId)->update(['completed' => 1]);
// Get all work orders for this PO
$workOrderIds = WorkOrder::where('purchase_order_id', $poId)->select(['id'])->get();
// Get all WorkOrderTask statuses
$workOrderTaskIds = WorkOrderTask::select(['id'])->where('active', 1)->get();
foreach ($workOrderIds as $woId) {
// Delete all existing progress rows first
WorkOrderProgress::where('work_order_id', $woId)->delete();
}
/*
foreach($workOrderIds as $woId)
{
// Create full set of statuses for this work order
foreach($workOrderTaskIds as $woTaskId)
{
WorkOrderProgress::create([
'work_order_id' => $woId,
'work_order_task_id' => $woTaskId
]);
}
}
*/
// Future PO finalization stuff goes here.
\DB::commit();
//return $returnData;
} catch (\Exception $ex) {
\DB::rollBack();
throw $ex;
}
}
/**
* Bootstrap the application services.
*
* @return void
*/
public function boot()
{
view()->composer('dashboard.sidebar', function ($view) {
$view->with('total_work_orders', WorkOrder::all()->count())->with('todo_work_orders', WorkOrder::where('completed', 0)->count())->with('completed_work_orders', WorkOrder::where('completed', 1)->count());
});
}
public function getFutureWorkOrders()
{
$startOfWeek = Carbon::today('America/Halifax')->startOfWeek();
//$results = WorkOrder::whereDate('start_date', '>=', $startOfWeek)
$results = WorkOrder::where('completed', 0)->with(['product' => function ($query) {
$query->addSelect(array('id', 'name'));
}, 'customer' => function ($query) {
$query->addSelect(array('id', 'first_name', 'last_name'));
}])->select('id', 'customer_id', 'product_id', 'purchase_order_id', 'start_date', 'end_date', 'quantity')->orderBy('start_date', 'asc')->get();
return response()->json($results);
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$workOrder = WorkOrder::where('id', $id)->with('workOrderProgress')->first();
return $workOrder;
}
