function UpdateCronLike($Param) { global $Today; global $debug; //$debug=true; if ($debug) echo "UpdateCronLike: Determine which tasks fire<BR>\n"; $SQL1="SELECT Cron.id,Cron.Task,Cron.DayOfWeek,Cron.DayOfMonth,Cron.Month,Cron.Prior,". "ToDo.TargetDate,ToDo.Status". " FROM Cron". " LEFT JOIN ToDo ON Cron.Task=ToDo.Task AND ToDo.Status='Open'"; $DB1 = mysql_query($SQL1) or die ("Error in <BR>".$SQL1."<BR>".mysql_error()."<BR>\n"); if ($debug) echo "DEBUG UpdateCronLike SQL1=".$SQL1."<BR>\n"; while ($row1=mysql_fetch_array($DB1,MYSQL_BOTH)) { $TD=TargetDate($row1); $SD=StartDate($TD,$row1['Prior']); $Fire=Fire($TD,$SD,$row1); if ($Fire) InsertTask($TD,$row1['Task']); if ($debug) echo "<HR>\n"; } if ($debug) exit; }
$_SESSION['devID'] = $user; $devID = $user; $g->queryId = $user; } if (isset($proj)) { $_SESSION['projID'] = $proj; $projID = $proj; } } if ($projID != "") { $g->pfilter = true; } if ($devID != "") { $g->ufilter = true; } $dates = StartDate(); $p->mark("Pre Project Walker"); $proj = ProjectWalker($devID, false, $projID); //SaveCSV("c:\ipc1.csv"); $g->projTable = $projTable; $g->projTableAttr = $projTableAttr; $g->name = $_COOKIE['userfullname']; $g->userid = $_COOKIE['username']; $g->colList = $numWeeks * 2 + 2; $g->cellStyle = explode(",", $tdAttr); $g->perf = $p->show('Pre Display'); $tmpl->assign('g', $g); $tmpl->display('matrix.tpl'); } else { header('Location: login.php'); }
function SaveCSV($fname) { global $numWeeks; global $projTable; global $track_errors; global $php_errormsg; ini_set("track_errors", true); $holdWeeks = $numWeeks; $fname = str_replace("\\", "\\\\", $fname); debug($fname); $csvFile = @fopen($fname, "w"); if ($csvFile) { $numWeeks = 16; $dates = StartDate(); ProjectWalker("", true, ""); foreach ($projTable as $projRow) { $str = implode(",", $projRow); fwrite($csvFile, $str . "\n"); } fclose($csvFile); $status = "ok"; } else { if (strpos($php_errormsg, "Permission denied") === false) { // errormessages always say "failed to open stream: " $statArr = explode("stream: ", $php_errormsg); $status = $statArr[1]; } else { $status = "File may be in use (eg by excel)"; } } $numWeeks = $holdWeeks; ini_set("track_errors", false); return $status; }