HI,
i have start date (date/time) and end date (date/time) and Days as check boxs.
if user choose start date and end date and choose days like monday and wednesday means, it will calculate how many mondays & wednedays and set the value in number of days.
this is the script i written , but i am not able to move the logic
client script
--------------------
var fri = g_form.getValue(' friday');
var sat = g_form.getValue('saturday');
var sun = g_form.getValue('sunday');
var ajax = new GlideAjax('x_892649_medicals.daysCalculation');
ajax.addParam('sysparm_name', 'days');
ajax.addParam('sysparm_sdate', sdate);
ajax.addParam('sysparm_edate', edate);
ajax.addParam('sysparm_mon',mon);
ajax.addParam('sysparm_tue',tue);
ajax.addParam('sysparm_wed',wed);
ajax.addParam('sysparm_thurs',thurs);
ajax.addParam('sysparm_fri',fri);
ajax.addParam('sysparm_sat',sat);
ajax.addParam('sysparm_sun',sun);
ajax.getXMLAnswer(response);
function response(result) {
alert(result);
g_form.setValue('number_of_days',result);
}
script include
--------------
days: function() {
var sdate = this.getParameter('sysparm_sdate');
var edate = this.getParameter('sysparm_edate');
var mon=this.getParameter('sysparm_mon');
var tue=this.getParameter('sysparm_tue');
var wed=this.getParameter('sysparm_wed');
var thurs=this.getParameter('sysparm_thurs');
var fri=this.getParameter('sysparm_fri');
var sat=this.getParameter('sysparm_sat');
var sun=this.getParameter('sysparm_sun');
var startdate = new GlideDateTime(sdate);
var enddate = new GlideDateTime(edate);
if(mon==true){
}
Regards,
Rajesh.
Hi @gillerlaraj
Try the below scripts.
Fields/Variables:
Script include:
var SJ_CatalogUtils = Class.create();
SJ_CatalogUtils.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getDays: function() {
var startDate = new GlideDateTime(this.getParameter('start'));
var endDate = new GlideDateTime(this.getParameter('end'));
var count = {
'monday': 0,
'tuesday': 0,
'wednesday': 0,
'thursday': 0,
'friday': 0,
'saturday': 0,
'sunday': 0
};
while (startDate.compareTo(endDate) <= 0) {
var dayOfWeek = startDate.getDayOfWeek();
if (dayOfWeek === 1) count.monday++;
if (dayOfWeek === 2) count.tuesday++;
if (dayOfWeek === 3) count.wednesday++;
if (dayOfWeek === 4) count.thursday++;
if (dayOfWeek === 5) count.friday++;
if (dayOfWeek === 6) count.saturday++;
if (dayOfWeek === 7) count.sunday++;
startDate.addDays(1); // Move to the next day
}
gs.info("Monday: " + count.monday.toString());
gs.info("Tuesday: " + count.tuesday.toString());
gs.info("Wednesday: " + count.wednesday.toString());
gs.info("Thursday: " + count.thursday.toString());
gs.info("Friday: " + count.friday.toString());
gs.info("Saturday: " + count.saturday.toString());
gs.info("Sunday: " + count.sunday.toString());
return JSON.stringify(count);
},
type: 'SJ_CatalogUtils'
});Client scripts (On change):
Note: You have to create 7 client scripts for each day (7 days). Script logic remains same. So just do insert & stay by selecting the day.
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
var mon = g_form.getValue('mon');
var tue = g_form.getValue('tue');
var wed = g_form.getValue('wed');
var thu = g_form.getValue('thu');
var fri = g_form.getValue('fri');
var sat = g_form.getValue('sat');
var sun = g_form.getValue('sun');
var total = 0;
var script = new GlideAjax('SJ_CatalogUtils');
script.addParam('sysparm_name', 'getDays');
script.addParam('start', g_form.getDisplayValue('start_date'));
script.addParam('end', g_form.getDisplayValue('end_date'));
script.getXMLAnswer(function(response) {
var count1 = JSON.parse(response);
if (mon == 'true')
total += parseInt(count1.monday);
if (tue == 'true')
total += parseInt(count1.tuesday);
if (wed == 'true')
total += parseInt(count1.wednesday);
if (thu == 'true')
total += parseInt(count1.thursday);
if (fri == 'true')
total += parseInt(count1.friday);
if (sat == 'true')
total += parseInt(count1.saturday);
if (sun == 'true')
total += parseInt(count1.sunday);
g_form.setValue('total_days', total.toString());
});
}Result:
Regards,
Siva
