Please help me!! I need it ASAP.

[hanan]

I have this great calendar script, which is almost perfect.
All I want is:

1. "Duration" under the add event. I want it to skip weekends.
   For example: if I put 16 under "Duration". I don't want it to caunt the weekends to.

2. I want to-be able to see a statistics of all the categories per user.
   For example: If I have one cat. Vacation and another one called Working from home. I want to-be able to see a statistics of how many days User 1 was in Vacation and how many days he was working from home.

You can Download the script from her

Thanks a lot

[DoctorWho]

1) Select count(days) as Durations from TABLE where days = M or T or W or Th or F

2) Select count(vacation_days) as VacationDays, count(Home) as Home from TABLEofUsers where user1 = user1

I downloaded your code, too much code. I don't know where too look for the part you are talking about in either question.

[bpat1434]

I think the SQL would work better as:

SELECT count(days) as Duration 
FROM `table` 
WHERE days<>Su 
  AND days<>Sat

[hanan]

DoctorWho wrote:

1) Select count(days) as Durations from TABLE where days = M or T or W or Th or F

2) Select count(vacation_days) as VacationDays, count(Home) as Home from TABLEofUsers where user1 = user1

I downloaded your code, too much code. I don't know where too look for the part you are talking about in either question.

I think the code is under: \themes\default\theme.php

Thanks for the help.

[DoctorWho]

bpat1434 wrote:

I think the SQL would work better as:

SELECT count(days) as Duration 
FROM `table` 
WHERE days<>Su 
  AND days<>Sat

yes, much better.....

[DoctorWho]

for ($i=1-$firstday;$i<=count($results);$i+=7)
    {
			echo $day_cell_header_row;
			if($CONFIG['cal_view_show_week']) {
				$weeknumber_cell_row1 = str_replace('{WEEK_NUMBER}', $results[$i<1?1:$i]['week_number'], $weeknumber_cell_row);
				$week_stamp = mktime(0,0,0,$date['month'],$i + 6,$date['year']);
				$url_week_date = date("Y-m-d", $week_stamp);
				echo str_replace('{URL_WEEK_VIEW}', $ME."?mode=week&date=".$url_week_date, $weeknumber_cell_row1);

		}
    for ($row=0;$row<7;$row++)
    {
			$day_stamp = mktime(0,0,0,$date['month'],$i + $row,$date['year']);
			$url_target_date = date("Y-m-d", $day_stamp);
			if($i+$row<1 || $i+$row> $nr) {
				$date_string = ucwords(strftime($lang_date_format['month_year'], $day_stamp));
				echo str_replace('{CELL_CONTENT}', $date_string,$other_month_cell_row);
			} else {
				$date_string = ucwords(strftime($lang_date_format['day_month_year'], $day_stamp));

for ($i=1-$firstday;$i<=count($results);$i+=7)

That may be the relevant code you are talking about, I am not sure.

This may be stupid, but you could try changing 7 to 5. I really doubt that will work but who knows.

An IF statement might work as well, or a SELECT CASE. But at this point, I just don't know. Someone more advance here might be able to help you.

[hanan]

Hi

Thanks for trying helping me.
I tryed it but it's not changing anything :-(

[bpat1434]

I say this, not to dismay, but to encourage seeking the proper help:
The only person who can truly understand exactly what is going on in any application, is the developer.

Have you tried asking them where to look for the item(s), or how to do what you're wanting to do?

We here can give you shots in the dark, but whether they'll work is no guarantee.

[hanan]

I tried but the forum over there is very very slow.

Thanks anyway for trying to help me.

Have a nice weekend.