function showAuditorProjects($info = "")
{
$userId = isLoggedIn();
if (isAdmin()) {
$sql = "select ap.*,w.name,u.username from websites w,users u,auditorprojects ap where ap.website_id=w.id and u.id=w.user_id";
$sql .= empty($info['userid']) ? "" : " and w.user_id=" . $info['userid'];
$sql .= " order by ap.score DESC,ap.id";
$this->set('isAdmin', 1);
$userCtrler = new UserController();
$userList = $userCtrler->__getAllUsers();
$this->set('userList', $userList);
} else {
$sql = "select w.name,ap.* from websites w, auditorprojects ap where ap.website_id=w.id and user_id={$userId} order by ap.id";
}
$this->set('userId', empty($info['userid']) ? 0 : $info['userid']);
# pagination setup
$this->db->query($sql, true);
$this->paging->setDivClass('pagingdiv');
$this->paging->loadPaging($this->db->noRows, SP_PAGINGNO);
$pagingDiv = $this->paging->printPages('siteauditor.php?userid=' . $info['userid']);
$this->set('pagingDiv', $pagingDiv);
$sql .= " limit " . $this->paging->start . "," . $this->paging->per_page;
$projectList = $this->db->select($sql);
foreach ($projectList as $i => $projectInfo) {
$projectList[$i]['total_links'] = $this->getCountcrawledLinks($projectInfo['id']);
$projectList[$i]['crawled_links'] = $this->getCountcrawledLinks($projectInfo['id'], true);
$projectList[$i]['last_updated'] = $this->getProjectLastUpdate($projectInfo['id']);
}
$this->set('pageNo', $info['pageno']);
$this->set('list', $projectList);
$this->render('siteauditor/list');
}
function executeCron($includeList = array())
{
$this->loadCronJobTools($includeList);
$lastGenerated = date('Y-m-d 00:00:00');
$userCtrler = new UserController();
$userList = $userCtrler->__getAllUsers();
foreach ($userList as $userInfo) {
// create report controller
$reportCtrler = new ReportController();
$lastGenerated = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
// check for user report schedule
$repSetInfo = $reportCtrler->isGenerateReportsForUser($userInfo['id']);
if (!empty($repSetInfo['generate_report'])) {
$websiteCtrler = new WebsiteController();
$websiteList = $websiteCtrler->__getAllWebsites($userInfo['id']);
// if websites are available
if (count($websiteList) > 0) {
foreach ($websiteList as $websiteInfo) {
$this->websiteInfo = $websiteInfo;
$this->routeCronJob($websiteInfo['id'], '', true);
}
// save report generated time
$reportCtrler->updateUserReportSetting($userInfo['id'], 'last_generated', $lastGenerated);
// send email notification if enabled
if (SP_REPORT_EMAIL_NOTIFICATION && $repSetInfo['email_notification']) {
$reportCtrler->sentEmailNotificationForReportGen($userInfo, $repSetInfo['last_generated'], $lastGenerated);
}
}
}
}
}
function editWebsite($websiteId, $listInfo = '')
{
$websiteId = intval($websiteId);
if (!empty($websiteId)) {
if (empty($listInfo)) {
$listInfo = $this->__getWebsiteInfo($websiteId);
$listInfo['oldName'] = $listInfo['name'];
}
$listInfo['title'] = stripslashes($listInfo['title']);
$listInfo['description'] = stripslashes($listInfo['description']);
$listInfo['keywords'] = stripslashes($listInfo['keywords']);
$this->set('post', $listInfo);
# get all users
if (isAdmin()) {
$userCtrler = new UserController();
$userList = $userCtrler->__getAllUsers();
$this->set('userList', $userList);
$this->set('isAdmin', 1);
}
$this->render('website/edit');
exit;
}
$this->listWebsites();
}
function showReportsScheduler($success = false, $postInfo = '')
{
$userId = isLoggedIn();
if (isAdmin()) {
$userId = empty($postInfo['user_id']) ? $userId : $postInfo['user_id'];
}
$repSetInfo = $this->getUserReportSettings($userId);
$this->set('repSetInfo', $repSetInfo);
$reportInterval = !isset($postInfo['report_interval']) ? $repSetInfo['report_interval'] : $postInfo['report_interval'];
$this->set('reportInterval', $reportInterval);
if ($reportInterval == 30) {
$nextGenTime = mktime(0, 0, 0, date('m') + 1, 1, date('Y'));
} else {
$nextGenTime = $repSetInfo['last_generated'] + $repSetInfo['report_interval'] * 86400;
}
$this->set('nextReportTime', date('d M Y', $nextGenTime));
$scheduleList = array(1 => $_SESSION['text']['label']['Daily'], 2 => $this->spTextReport['2 Days'], 7 => $_SESSION['text']['label']['Weekly'], 30 => $_SESSION['text']['label']['Monthly']);
$userCtrler = new UserController();
$userList = $userCtrler->__getAllUsers();
$this->set('userList', $userList);
$this->set('success', $success);
$this->set('scheduleList', $scheduleList);
$this->render('report/reportscheduler');
}
function executeCron($includeList = array())
{
$this->loadCronJobTools($includeList);
$userCtrler = new UserController();
$userList = $userCtrler->__getAllUsers();
$websiteCtrler = new WebsiteController();
foreach ($userList as $userInfo) {
$websiteList = $websiteCtrler->__getAllWebsites($userInfo['id']);
foreach ($websiteList as $websiteInfo) {
$this->websiteInfo = $websiteInfo;
$this->routeCronJob($websiteInfo['id'], '', true);
}
}
}
