public function postReadServiceOrder() { $serviceOrder = fil_service_order::orderBy('ser_id', 'desc')->get(); if ($serviceOrder == null) { return Response::json(array('success' => false, 'data' => 'Error al leer la ordenes de servicio')); } $today = date('Y-m-d'); $today = date('Y-m-d', strtotime($today)); $activeServiceOrder = []; $historyServiceOrder = []; foreach ($serviceOrder as $value) { $value->customer; if ($value->ser_auth_admin == 2 && $value->ser_auth_production == 2 && $value->ser_auth_sales == 2) { if ($today <= date('Y-m-d', strtotime($value->ser_end_date))) { $activeServiceOrder[] = $value; } else { $historyServiceOrder[] = $value; } } } $response = Response::json(array('success' => true, 'activeServiceOrder' => $activeServiceOrder, 'historyServiceOrder' => $historyServiceOrder)); return $response; }
public function postReadServiceOrderAuth() { $data = fil_service_order::orderBy('ser_id', 'desc')->get(); if ($data == null) { return Response::json(array('success' => false, 'data' => 'Ordenes de servicio no encontradas')); } $rejected = []; $pending = []; $accepted = []; $canceled = []; $history = []; $today = date('Y-m-d'); $today = date('Y-m-d', strtotime($today)); foreach ($data as $value) { $row = []; $row['ser_id'] = $value->ser_id; $row['ser_fk_customer'] = $value->customer->cus_contact_first_name . " " . $value->customer->cus_contact_last_name; $row['created_at'] = date_format(date_create($value->created_at), 'Y-m-d'); if ($today <= date('Y-m-d', strtotime($value->ser_end_date))) { switch (Session::get('type')) { case 'producción': if ($value->ser_auth_admin == 2 && $value->ser_auth_sales == 2) { switch ($value->ser_auth_production) { case '0': $pending[] = $row; break; case '1': $rejected[] = $row; break; case '2': $accepted[] = $row; break; case '3': $canceled[] = $row; break; } } break; case 'administrador': case 'tesoreria': switch ($value->ser_auth_admin) { case '0': $pending[] = $row; break; case '1': $rejected[] = $row; break; case '2': $accepted[] = $row; break; case '3': $canceled[] = $row; break; } break; case 'gerente de ventas': switch ($value->ser_auth_sales) { case '0': $pending[] = $row; break; case '1': $rejected[] = $row; break; case '2': $accepted[] = $row; break; case '3': $canceled[] = $row; break; } break; } } else { $history[] = $row; } } $response = Response::json(array('success' => true, 'rejected' => $rejected, 'pending' => $pending, 'accepted' => $accepted, 'canceled' => $canceled, 'history' => $history)); return $response; }
public function postReadServiceOrder() { $serviceOrders = fil_service_order::orderBy('ser_start_date')->get(); if ($serviceOrders == null) { return Response::json(array('success' => false, 'data' => 'Error al leer las ordenes de servicio')); } $serviceOrdersWithProduction = []; foreach ($serviceOrders as $order) { $add = false; foreach ($order->detailsProducts as $detail) { if ($detail->detailProduction != null) { $add = true; } } if ($add) { $serviceOrdersWithProduction[] = $order; } } $pending = []; $process = []; $full = []; $historial = []; $today = date('Y-m-d'); $today = date('Y-m-d', strtotime($today)); foreach ($serviceOrdersWithProduction as $order) { if ($order->ser_auth_admin == 2 && $order->ser_auth_production == 2 && $order->ser_auth_sales == 2) { if ($today <= date('Y-m-d', strtotime($order->ser_end_date))) { $ArrayToAdd = 'pending'; foreach ($order->detailsProducts as $detail) { if ($detail->detailProduction != null) { switch ($detail->detailProduction->dpr_status) { case 'Pendiente': $ArrayToAdd = 'pending'; break; case 'En Proceso': $ArrayToAdd = 'process'; break; case 'Completa': $ArrayToAdd = 'full'; break; } } } switch ($ArrayToAdd) { case 'pending': $pending[] = array('id' => $order->ser_id, 'customer' => '<b>Contacto:</b> ' . $order->customer->cus_contact_first_name . ' ' . $order->customer->cus_contact_last_name . ', <b>Empresa:</b> ' . $order->customer->cus_commercial_name, 'start_date' => $order->ser_start_date); break; case 'process': $process[] = array('id' => $order->ser_id, 'customer' => '<b>Contacto:</b> ' . $order->customer->cus_contact_first_name . ' ' . $order->customer->cus_contact_last_name . ', <b>Empresa:</b> ' . $order->customer->cus_commercial_name, 'start_date' => $order->ser_start_date); break; case 'full': $full[] = array('id' => $order->ser_id, 'customer' => '<b>Contacto:</b> ' . $order->customer->cus_contact_first_name . ' ' . $order->customer->cus_contact_last_name . ', <b>Empresa:</b> ' . $order->customer->cus_commercial_name, 'start_date' => $order->ser_start_date); break; } } else { $historial[] = array('id' => $order->ser_id, 'customer' => '<b>Contacto:</b> ' . $order->customer->cus_contact_first_name . ' ' . $order->customer->cus_contact_last_name . ', <b>Empresa:</b> ' . $order->customer->cus_commercial_name, 'start_date' => $order->ser_start_date); } } } $response = Response::json(array('success' => true, 'pending' => $pending, 'process' => $process, 'full' => $full, 'historial' => $historial)); return $response; }