Exemplo n.º 1
0
 public function actionPrhead()
 {
     global $urlRequestRoot, $sourceFolder, $templateFolder, $cmsFolder, $moduleFolder;
     $moduleComponentId = $this->moduleComponentId;
     $userId = $this->userId;
     require_once "{$sourceFolder}/{$moduleFolder}/events/events_common.php";
     require_once "{$sourceFolder}/{$moduleFolder}/events/events_forms.php";
     require_once "{$sourceFolder}/{$moduleFolder}/events/events.config.php";
     require_once $sourceFolder . "/" . $moduleFolder . "/qaos1/excel.php";
     require_once $sourceFolder . "/upload.lib.php";
     if (isset($_GET['subaction'])) {
         if ($_GET['subaction'] == 'viewEventList') {
             return displayPr('prhead', $moduleComponentId);
         }
         if ($_GET['subaction'] == "viewEvent") {
             $eventId = trim(escape($_POST['eventId']));
             if (!empty($eventId)) {
                 return viewEventResult('prhead', $moduleComponentId, $eventId);
             }
         } else {
             if ($_GET['subaction'] == "downloadExcel") {
                 //$eventId = escape($_POST['eventId']);
                 //error_log($eventId);
                 //getUserDetailsTable($moduleComponentId,$eventId);
                 return getUserDetailsTable('prhead', $moduleComponentId, escape($_GET['event_id']));
             } else {
                 if ($_GET['subaction'] == 'unlockEvent') {
                     $eventId = trim(escape($_POST['eventId']));
                     if (!empty($eventId)) {
                         return unlockEvent($moduleComponentId, $eventId);
                     }
                 } else {
                     if ($_GET['subaction'] == 'viewWorkshopList') {
                         return getWorkshopsList($moduleComponentId);
                     } else {
                         if ($_GET['subaction'] == 'viewWorkshopDetails') {
                             $workshopId = escape($_POST['workshopId']);
                             return viewWorkshopDetails($workshopId, $moduleComponentId);
                         } else {
                             if ($_GET['subaction'] == "downloadExcel") {
                                 //$eventId = escape($_POST['eventId']);
                                 //error_log($eventId);
                                 //getUserDetailsTable($moduleComponentId,$eventId);
                                 return getWorkshopDetailsTable($moduleComponentId, escape($_GET['workshop_id']));
                             } else {
                                 if ($_GET['subaction'] == "editParticipant") {
                                     $editFormId = escape($_POST['formId']);
                                     $editUserId = escape($_POST['userId']);
                                     $rowValue = escape($_POST['rowValue']);
                                     $teamId = escape($_POST['teamId']);
                                     $rowId = escape($_POST['rowId']);
                                     $workshopId = escape($_POST['eventId']);
                                     if (!empty($userId)) {
                                         //return $rowId;
                                         echo editWorkshopParticipant('prhead', $moduleComponentId, $workshopId, $editFormId, $editUserId, $teamId, $rowValue, $rowId);
                                         die;
                                     }
                                 } else {
                                     if ($_GET['subaction'] == "printCerti") {
                                         if (isset($_POST['eventId'])) {
                                             $eventAction = 'event';
                                             $eventId = trim(escape($_POST['eventId']));
                                         } else {
                                             if (isset($_POST['workshopId'])) {
                                                 $eventAction = 'workshop';
                                                 $eventId = trim(escape($_POST['workshopId']));
                                             }
                                         }
                                         return printCertificates($eventAction, $moduleComponentId, $eventId);
                                     } else {
                                         if ($_GET['subaction'] == "printIndividualCerti") {
                                             if (isset($_POST['eventId'])) {
                                                 $action = 'event';
                                                 $eventId = escape($_POST['eventId']);
                                             } else {
                                                 if (isset($_POST['workshopId'])) {
                                                     if (isset($_POST['workshopId'])) {
                                                         //return "sadasd";
                                                         $eventId = $_POST['workshopId'];
                                                     }
                                                     $action = 'workshop';
                                                 }
                                             }
                                             $userId = escape($_POST['userId']);
                                             //error_log($eventId." ".$userId);
                                             return printIndividualCerti('prhead', $action, $moduleComponentId, $userId, $eventId);
                                         } else {
                                             if ($_GET['subaction'] == "userDetailForm") {
                                                 return searchByUserId('prhead', $moduleComponentId);
                                             } else {
                                                 if ($_GET['subaction'] == "userEventDetails") {
                                                     $userBookletId = escape($_POST['userId']);
                                                     return getUserDetails('prhead', $moduleComponentId, $userBookletId);
                                                 } else {
                                                     if ($_GET['subaction'] == "printUserCerti") {
                                                         $userId = escape($_POST['userId']);
                                                         printUserCerti($moduleComponentId, $userId);
                                                     } else {
                                                         if ($_GET['subaction'] == "viewEventOptions") {
                                                             return getPrHeadOptions($moduleComponentId);
                                                         }
                                                     }
                                                 }
                                             }
                                         }
                                     }
                                 }
                             }
                         }
                     }
                 }
             }
         }
         /*else if($_GET['subaction'] == "viewEvent"){
         					$eventId = trim(escape($_POST['eventId']));
         					if(!empty($eventId)){
         						return viewEventResult($moduleComponentId,$eventId);
         					}
         				}
         				else if($_GET['subaction'] == "printCerti"){
         					$eventId = trim(escape($_POST['eventId']));
         					return printCertificates($moduleComponentId,$eventId);
         				}
         
         				else if($_GET['subaction'] == 'unlockEvent'){
         					$eventId = trim(escape($_POST['eventId']));
         					if(!empty($eventId)){
         						return unlockEvent($moduleComponentId,$eventId);
         					}
         				}*/
     } else {
         return prMain('prhead', $moduleComponentId);
     }
 }
Exemplo n.º 2
0
function getUserDetails($gotoaction, $pmcId, $userBookletId)
{
    global $STARTSCRIPTS;
    $smarttable = smarttable::render(array('user_table'), null);
    $STARTSCRIPTS .= "initSmartTable();";
    $userEventListTable = "";
    $userBookletId = escape($userBookletId);
    $pmcId = escape($pmcId);
    $userEventListTable .= searchByUserId($gotoaction, $pmcId);
    if ($userBookletId[0] == 'P') {
        $userId = getUserIdFromBookletId($userBookletId, $pmcId);
    } else {
        $userId = $userBookletId;
    }
    $getUserDetailsQuery = "SELECT * FROM `events_participants` WHERE `user_pid`='{$userId}' AND `page_moduleComponentId`='{$pmcId}' AND `event_id` IN(SELECT `event_id` FROM `events_locked` WHERE `page_moduleComponentId`='{$pmcId}')";
    $getUserDetailsRes = mysql_query($getUserDetailsQuery) or displayerror(mysql_error());
    if (mysql_num_rows($getUserDetailsRes) == 0) {
        displayerror("No info found.");
    } else {
        $getUserNameQuery = "SELECT `user_fullname` FROM `" . MYSQL_DATABASE_PREFIX . "users` WHERE `user_id`='{$userId}'";
        $getUserNameRes = mysql_query($getUserNameQuery) or displayerror(mysql_error());
        $userEventListTable .= "<br/><h4>" . mysql_result($getUserNameRes, 0) . "</h4><br/>";
        $userEventListTable .= <<<FORM
\t\t\t<form method='post' action='./+{$gotoaction}&subaction=printUserCerti'>
\t\t\t\t<input type='hidden' value='{$userId}' name='userId'/>
\t\t\t\t<input type='submit' name='submit' value='Print User Certificates'/>
\t\t\t</form>
FORM;
        $userEventListTable .= "{$smarttable}<table id='user_table' class='display' width='100%' border='1'><thead><th>User FID</th><th>Event Name</th><th>User Rank</th></thead>";
        while ($userEvent = mysql_fetch_assoc($getUserDetailsRes)) {
            $eventName = getEventName($pmcId, $userEvent['event_id']);
            $getUserRankQuery = "SELECT `user_rank` FROM `events_result` WHERE `page_moduleComponentId`='{$pmcId}' AND `user_id`='{$userId}' AND `event_id`='{$userEvent['event_id']}'";
            $getUserRankRes = mysql_query($getUserRankQuery) or displayerror(mysql_error());
            $userRank = mysql_result($getUserRankRes, 0);
            $userEventListTable .= "<tr><td>" . $userId . "</td><td>" . $eventName . "</td><td>" . $userRank . "</td></tr>";
        }
        $userEventListTable .= "</table>";
        return $userEventListTable;
    }
}