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;
}
