Date - Time If Then Else Help

[Turnbullca]

Hi All,

Let's see if I can explain what I want.

I am putting to together a Printing Requistion System (Fancy Title) whereby Staff fill in a Grid and Upload the file to the Print Room Operator.

All is going well and is nearly finished but I am stuck on thge Following.

I need to Update the Date Due and Due Time fields but in different ways.

Fields

Submitted Date, Submitted Time - These are set with an Initial Value of =Now() and disabled.
Due Date and Due Time are the fields I need to Update depending on whih of the Services below is Selected.

We Offer 3 Services

1 - Standard Printing which is 2-3 Days - I would want to make this at Least 2 days after the Submitted Date but it will be enabled as the user can change it.

2 - 24 Hour Printing - Just Add 24 Hours after Submission Date to the Due Date

3 - Quick Printing (Same Day) - If before 10:30am the Due Date set to Today and Due Time would be set to 12:30am. If after 10:30am Due Date set to today and Due Time Set to 15:30. If after 12:30 Due Date set to next Day and Due Time Set to 12:30.

I do not really know where to start with the If statement or whether I should be using Javascript or XBasic. Any pointers in the right direction would be greatfully received. I have searched all morning but not really got anywhere.

Thanks in anticipation

Chris

[Charles Hoens]

Re: Date - Time If Then Else Help

Hi Chris,

I'm not sure what you have not gotten a response from the forum folks yet, but I'll try and help you out.

What I would do is handle this in the OnSaveRecord events section of your database.

You could put in some code such as:

t=table.get("yourDbf")
if isblank("standardprinting")
t.change_begin()
t.standardprinting=date()+2
'Note: you can then add other code here...
t.change_end()
end if


Hope this helps get you started.

Charlie

[Turnbullca]

Re: Date - Time If Then Else Help

Hi Charlie or should that be Brad

Thanks for the reply - From what I have seen and read I am looking to populate the text fields with JS Get and Set Values within the Grid.

Chris

[madtowng]

Re: Date - Time If Then Else Help

Hi Chris,

I took the liberty of using case instead of if-then, and created a little function called duewhen().
It needs just 2 pieces of information, a date-time value, and a service code ("a", "b", or "c") as
I set it.

Hope this helps.

Gregg

FUNCTION duewhen AS t (offered AS T,servreq as c)
	
duewhen = case(servreq = "a",offered + (48*3600),servreq = "b",offered + (24*3600),servreq = "c" .and. substr(ctime(offered),9,4) < "1030",ctodt(dtoc(date())+" 12:30"), servreq = "c" .and. substr(ctime(offered),9,4) < "1230",ctodt(dtoc(date())+" 15:30"), servreq = "c" .and. substr(ctime(offered),9,4) >= "1230",ctodt(dtoc(date()+1)+" 12:30"))
	
END FUNCTION

[Davidk]

Re: Date - Time If Then Else Help

If you want to stay in javascript then give this a try. I find working with dates and times in Javascript to be... icky... at best. I put this code on the onChange event of the field where you select the Print Service. You'd need it on the date and time as well, so putting it into a function would be best. Maybe there's a better way of working with dates in Javascript but I haven't seen it yet. Another route would be to do an Ajax Callback and then you get to use an XBasic function with work decently with dates and times and then just send back a Javascript setValue statement.

I believe there's a problem with Alpha with running Javascript code off a Radio Control. When displaying an existing record, before the initial display completes I get an error. And, when the submit button is clicked for an existing record or a new record another error. If I change the control to a dropdown... no errors. I'm using MySQL tables and version 2539-3903.

The date and time formats are really specific here because we have to pull apart the date and time values and then put them back together. So, be aware of dd-mm-yyyy formats... same for time.

var rowNum = {Grid.RowNumber};
var printService = {grid.Object}.getValue('G','PRINTSERVICE',rowNum);
var currDate = {grid.Object}.getValue('G','SUBMITTEDDATE',rowNum);
var currTime = {grid.Object}.getValue('G','SUBMITTEDTIME',rowNum);
var currDay = currDate.substring(0,2);
var currMth = currDate.substring(3,5)-1;
var currYr = currDate.substring(6);
var dueDate = new Date(currYr, currMth, currDay);
var dueTime = currTime;

switch(printService)
{
case '1':
	dueDate.setDate(dueDate.getDate()+2);
	dueTime = currTime;
	break;
case '2':
	dueDate.setDate(dueDate.getDate()+1);
	dueTime = currTime;
	break;
case '3':
	var end = '10:30 AM';
	var timeStart = new Date('1/1/2007 ' + currTime);
	var timeEnd = new Date('1/1/2007 ' + end);
	difference_in_milliseconds = timeEnd - timeStart;
	if (difference_in_milliseconds < 0)
		{
		var end = '12:30 PM';
		var timeStart = new Date('1/1/2007 ' + currTime);
		var timeEnd = new Date('1/1/2007 ' + end);
		difference_in_milliseconds = timeEnd - timeStart;
		if (difference_in_milliseconds < 0)
			{
			dueDate.setDate(dueDate.getDate()+1);	
			dueTime = '12:30 pm';
			}
		else
			{
			dueDate.setDate(dueDate.getDate());							
			dueTime = '15:30 pm';
			}
		}
	else
		{
		dueDate.setDate(dueDate.getDate());							
		dueTime = '12:30 pm';
		}
	break;
default:
	alert('Invalid Printing Service selected');			
}


var currDay = dueDate.getDate();
var currMth = dueDate.getMonth()+1;
var currYr = dueDate.getFullYear();

var newDueDate = currDay + '/' + currMth + '/' + currYr;

{grid.Object}.setValue('G','DUEDATE',rowNum,newDueDate);
{grid.Object}.setValue('G','DUETIME',rowNum,dueTime);

[Davidk]

Re: Date - Time If Then Else Help

Nice function Gregg... I never could write such a nice compact function like that.

[Davidk]

Re: Date - Time If Then Else Help

Would someone mind taking a few minutes to confirm the errors I'm seeing in the project? Included is the full database, 1 dbf table, 1 grid.

The grid's radio control has onChange JS attached to it.

Run this in Live or Working Preview.

When the grid is displayed, empty table, all is fine. Enter some Data and click Submit, an error occurs. Click "No" on the error, get back in Design, then back into Live Preview. As the grid displays (now's there's a record in the table) and error occurs. Click "No" and the grid will display.

If the Radio Control is changed to a Dropdown... no errors. Thanks for trying this.

[Turnbullca]

Re: Date - Time If Then Else Help

Gregg and David,

Thanks so much for the time you have spent with the above.

I have been watching XBasic Videos alll morning so will hopefully be able to understand and put together what I need from that. But for now will use the code above.

Once again thanks very much I really do appreciate it.

OK if I comeback withany questions if I have them?

Chris

[Turnbullca]

Re: Date - Time If Then Else Help

David

I have used a Drpdown for the Service Type but when I tried your example with the Radio Button I get the same error.

[madtowng]

Re: Date - Time If Then Else Help

I'm always willing to answer questions I can.
If you need help adjusting it for your usage, I can certainly do that.
The way I set it up leaves room for the changes and corrections that
always seem to come up (I assumed you meant 1230 pm, unless you have
superman powers to go back in time ).

[Turnbullca]

Re: Date - Time If Then Else Help

David,

var currDay = currDate.substring(0,2);
var currMth = currDate.substring(3,5)-1;
var currYr = currDate.substring(6);


In my quest to understand JS and Dates. Can you let me know what the numbers in brackets and the minus 1 is doing.

At a guess the in brackets mean 0,2 - start at 0 and pickup the next 2 characters, 3,5 start at 3rd character and pickup the next 2 (don't know what the -1 is doing and start 6 and pick whatevers left)

Also, when the month or day is showing as a single character I have tried this to add the 0 but it isnt working.

if (currMth<10)
{
currMth='0'+currMth;
}

if (currDay<10)
{
currDay='0'+currDay;
}


Chris