public function postReadCustomers() { $finalArray = []; $customers = null; if (Session::get('type') == 'vendedor') { $customers = fil_customer::where('cus_fk_employee', '=', Session::get('id'))->where('cus_status', 'not like', 'eliminado')->get(); } else { $customers = fil_customer::where('cus_status', 'not like', 'eliminado')->get(); } if ($customers == null) { return Response::json(array('success' => false, 'data' => 'Error al leer los clientes')); } foreach ($customers as $value) { $row['cus_id'] = $value->cus_id; $row['cus_commercial_name'] = $value->cus_commercial_name; $row['cus_contact'] = $value->cus_contact_first_name . ' ' . $value->cus_contact_last_name; $row['tax_business_name'] = $value->taxData->tax_business_name; $row['tax_rfc'] = $value->taxData->tax_rfc; $finalArray[] = $row; } $response = Response::json(array('success' => true, 'data' => $finalArray)); return $response; }
public function postReadAllDelete() { $dataCustomer = fil_customer::where('cus_status', 'like', 'eliminado')->get(); $finalArray = []; foreach ($dataCustomer as $value) { $tempRow['cus_id'] = $value->cus_id; $tempRow['cus_name'] = $value->cus_contact_first_name . ' ' . $value->cus_contact_last_name; $tempRow['cus_enterprise'] = 'Nombre Comercial: ' . $value->cus_commercial_name . '<br>Actividad o Giro: ' . $value->cus_business_activity; $tempRow['cus_contact'] = 'Puesto: ' . $value->cus_job . '<br>Teléfono Fijo: ' . $value->cus_phone_number . ' ,Extensión:' . $value->cus_phone_extension . '<br>Teléfono Celular: ' . $value->cus_cellphone_number . '<br>Correo: ' . $value->cus_email . '<br>Dirección: ' . $value->cus_address; $tempRow['cus_status'] = $value->cus_status; $finalArray[] = $tempRow; } $response = null; if ($dataCustomer == null) { $response = Response::json(array('success' => false, 'data' => 'Error al leer los datos de los clientes')); } else { $response = Response::json(array('success' => true, 'data' => $finalArray)); } return $response; }