Related Articles
Get Google Maps API Address based on Address
$url = “http://maps.googleapis.com/maps/api/geocode/json?sensor=false&address=”.urlencode($resident_address); $lat_long = get_object_vars(json_decode(file_get_contents($url)));// pick out what we need (lat,lng)$lat = $lat_long[‘results’][0]->geometry->location->lat;$lng =$lat_long[‘results’][0]->geometry->location->lng; /*echo $lat;echo $lng;*/
Groovy Script SQL Connection Bonitasoft
Below is the SQL Connection for a Groovy Script for a SELECT Command in Bonitasoft BPM import groovy.sql.Sql;def host = “localhost”;def user = “bonita”;def pass = “bpm”;def schema = “bonita_journal”;def query = “SELECT * FROM BN_USER where USER_PRO_EMAIL_=’${email_Address__}’ limit 1”;def list=[];sql = providedscripts.BonitaSql.newInstance(“jdbc:mysql://${host}/${schema}”,user, pass, new com.mysql.jdbc.Driver())sql.eachRow(query,{row-> list.add(row.USER_USERNAME_)}); IdentityAPI api = apiAccessor.getIdentityAPI();User userObj = api.findUserByUserName(list[0]);User manager1 […]