AppGini Community Forums

Code: Select all

function livestock_movements_after_insert($data, $memberInfo, &$args){
		
		$days_in = (strtotime($data['date_out'])- strtotime($data['date_in']))/86400;

		return TRUE;
	}

Code: Select all

function livestock_movements_after_insert($data, $memberInfo, &$args){
		$date1 = new DateTime($data['date_in']);
		$date2 = new DateTime($data['date_out']);
		$interval = $date1->diff($date2);
		$days=$interval->days;

// assuming you want to set a field in the livestock_movements table for the seleceted ID
		$sql="Update livestock_movements set YOURFIELD = ".$days." where id = ".$data['selectedID'];

		sqlvalue($sql);
		return TRUE;
	}