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 […]
Below are the list of free bootstrap single page or one page templates and all the templates are responsive and made of bootstrap 3 and are open source, you can use them for your personal and business purpose. Check out below for Free one page bootstrap templates. Enlarge the image for perfect demo. Free Bootstrap […]
Check the Last Day in Month $startDate = “20150624”;$endDate = “20150722”;$startDate = strtotime($startDate);$endDate = strtotime($endDate);$dayLength = 60 * 60 * 24;$checkDateRange = ($endDate – $startDate) / $dayLength;$datesStartMonth = date(‘t’, $startDate);if ($checkDateRange > $datesStartMonth) {echo $error = “Date range should be with in one month”;}
