"IVeR");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false )
{
echo "Could not connect.\n";
die( print_r( sqlsrv_errors(), true));
}
$data = json_decode(file_get_contents('php://input'), true);
if($data['type'] =='save'){
$nombre = $data['nombre'];
$cuip = $data['cuip'];
$lat = $data['lat'];
$lng = $data['lng'];
$time = new DateTime();
$id = 1;
$estatus = $data['estatus'];
$tsql = "EXEC savePersonal ?,?,?,?,?,?";
$stmt = sqlsrv_prepare($conn, $tsql,array(&$nombre, &$cuip, &$estatus, &$time, &$lat, &$lng));
if( sqlsrv_execute( $stmt ) === false ) {
die( print_r( sqlsrv_errors(), true));
}
$res['status'] = 'Guardado ok';
$res['result'] = '';
print json_encode($res);
}else{
/* Set up the Transact-SQL query. */
$tsql = "SELECT per.*, es.estatus as 'EstatusTexto'
FROM personal per
LEFT JOIN cat_estatusPersonal es on es.id = per.estatus";
/* Execute the query. */
$stmt = sqlsrv_query($conn, $tsql);
$result = array();
do {
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
$result[] = $row;
}
} while (sqlsrv_next_result($stmt));
echo json_encode($result);
}
sqlsrv_free_stmt( $stmt);
sqlsrv_close( $conn);
?>