public function actionHead() { global $urlRequestRoot, $moduleFolder, $cmsFolder, $templateFolder, $sourceFolder, $STARTSCRIPTS; require_once $sourceFolder . "/" . $moduleFolder . "/qaos1/qaos_common.php"; require_once $sourceFolder . "/upload.lib.php"; require_once $sourceFolder . "/" . $moduleFolder . "/qaos1/excel.php"; $mcid = $this->moduleComponentId; if (isset($_POST['downloadFormatExcel'])) { displayEventFormatExcel(); } if (isset($_FILES['fileUploadField']['name'])) { $date = date_create(); $timeStamp = date_timestamp_get($date); $tempVar = $sourceFolder . "/uploads/temp/" . $timeStamp . $_FILES['fileUploadField']['name'][0]; move_uploaded_file($_FILES["fileUploadField"]["tmp_name"][0], $tempVar); $excelData = readExcelSheet($tempVar); $success = 1; for ($i = 2; $i <= count($excelData); $i++) { if ($excelData[$i][1] == NULL) { continue; } $checkIfExistQuery = "SELECT * FROM `qaos1_events` WHERE `events_name`='{$excelData[$i][1]}' AND `page_modulecomponentid`={$mcid}"; $checkIfExistRes = mysql_query($checkIfExistQuery) or displayerror(mysql_error()); if (mysql_num_rows($checkIfExistRes)) { continue; } $insertIntoEventTableQuery = "INSERT IGNORE INTO `qaos1_events` (events_name,page_modulecomponentid) VALUES ('{$excelData[$i][1]}',{$mcid})"; $res = mysql_query($insertIntoEventTableQuery) or displayerror(mysql_error()); if ($res == "") { $success = 0; } } if (!$success) { displayerror("Datas are not inserted"); } } if (isset($_POST['uploadEventName'])) { } if (isset($_POST['hid'])) { $_POST["hid2"] = addslashes($_POST["hid2"]); $_POST["hid1"] = addslashes($_POST["hid1"]); $_POST["hid"] = addslashes($_POST["hid"]); if ($_POST["hid"] < 3 && $_POST["hid"] >= 0) { if ($_POST["hid"] != 2 || $_POST["hid1"] != "") { $query = "update qaos1_evtproc set evtproc_Status = '{$_POST["hid"]}',evtproc_Desc ='{$_POST["hid1"]}' where evtproc_Id ='{$_POST["hid2"]}' AND modulecomponentid={$this->moduleComponentId}"; $res = mysql_query($query); } } } if (isset($_GET['subaction']) && $_GET['subaction'] == "apFundReq" && isset($_POST['qhid'])) { $_POST["qhid2"] = addslashes($_POST["qhid2"]); $_POST["qhid1"] = addslashes($_POST["qhid1"]); $_POST["qhid"] = addslashes($_POST["qhid"]); if ($_POST["qhid"] < 3 && $_POST["qhid"] >= 0) { if ($_POST["qhid"] != 2 || $_POST["qhid1"] != "") { $query = "update qaos1_fundreq set fundreq_Status = '{$_POST["qhid"]}',fundreq_Desc ='{$_POST["qhid1"]}' where fundreq_Id ='{$_POST["qhid2"]}' AND modulecomponentid={$this->moduleComponentId}"; $res = mysql_query($query); } } } $query = "SELECT * FROM qaos1_evtproc WHERE modulecomponentid={$this->moduleComponentId}"; $res = mysql_query($query); $query1 = "SELECT * FROM qaos1_fundreq WHERE modulecomponentid={$this->moduleComponentId}"; $res1 = mysql_query($query1); $css1 = $urlRequestRoot . "/" . $cmsFolder . "/" . $moduleFolder . "/qaos1/styles/main.css"; $smarttablestuff = smarttable::render(array('table_evtprocrequest', 'table_fundreqform', 'table_eventproc_head', 'table_funreq_head'), null); $STARTSCRIPTS .= "initSmartTable();"; $headaction = <<<AB \t\t {$smarttablestuff} \t\t\t\t<link href="{$css1}" rel="stylesheet"> \t \t \t <script type="text/javascript"> \t \t \t function qaosproc(a) \t\t{ \t\t\t\t\tvar k=document.getElementById("status"+a+"1"); \t\t \t\t\tvar k1=document.getElementById("status"+a+"2"); \t\t \t\t\tif(k.checked) document.getElementById("hid"+a).value=1; \t\t \t\t\telse if(k1.checked) document.getElementById("hid"+a).value=2; \t\t \t\t\telse {alert("select any one of button");return false;} \t\t \t\t\tdocument.getElementById("hi1d"+a).value=document.getElementById("description"+a).value; \t\t\t\t \t\t\t\t\t\$.ajax({ \t\t\t\t\ttype: "POST", \t\t\t\t \turl: "./+head&subaction=apEventProc", \t\t\t\t \tdata: "hid="+\$("#hid"+a).val()+"&hid1="+\$("#hi1d"+a).val()+"&hid2="+\$("#hi2d"+a).val() \t\t\t \t\t}); \t\t\t\t \t\t\t\t\t\$("#tr"+a).css({'display':'none'}); \t \t\t\t\treturn false; \t\t\t\t} \t\t\t function qaosfund(a) \t\t \t\t{ \t\t\t\t\tvar k=document.getElementById("qstatus"+a+"1"); \t\t\t\t\tvar k1=document.getElementById("qstatus"+a+"2"); \t\t\t\t\tif(k.checked) document.getElementById("qhid"+a).value=1; \t\t\t\t\telse if(k1.checked) document.getElementById("qhid"+a).value=2; \t\t\t\t\telse {alert("select any one of button");return false;} \t\t \t\t\tdocument.getElementById("qhi1d"+a).value=document.getElementById("qdescription"+a).value; \t\t\t\t\t \t\t\t\t\t\$.ajax({ \t\t\t\t\ttype: "POST", \t\t\t\t \turl: "./+head&subaction=apFundReq", \t\t\t \t\tdata: "qhid="+\$("#qhid"+a).val()+"&qhid1="+\$("#qhi1d"+a).val()+"&qhid2="+\$("#qhi2d"+a).val() \t\t\t \t\t}); \t\t\t\t\t \t\t\t\t\t\$("#trf"+a).css({'display':'none'}); \t \t\t\t\treturn false; \t\t\t } \t \t </script> \t\t\t <script type="text/javascript"> \t\t \t \t \$(document).ready(function() \t \t\t \t{ \t\t\t\t\t\$(".forms").css({'display':'none'}); \t\t\t\t\t\$(".buttons").css({'display':'block'}); \t\t\t\t\t\$("#dheadfundreq").css({'display':'block'}); \t\t\t\t\t\$("#bhead_evtproc").click(function() \t\t\t\t\t\t{ \t\t\t\t\t\t\tdispevtproc(); \t\t\t\t\t\t}); \t\t\t\t\t\$("#bhead_fundreq").click(function() \t\t\t\t\t\t{ \t\t\t\t\t\t\tdispfundreq(); \t\t\t\t\t\t}); \t\t\t\t\t\t\t\t \t\t\t\t\t\$("#bformevt").click(function(){ \t\t\t\t\t\tdispevtform(); \t\t\t\t\t}); \t \t\t \$("#bformfund").click(function(){ \t\t\t\t\t\tdispfundform(); \t\t\t\t \t\t}); \t \t\t \$("#bhead_evtUpload").click(function(){ \t\t\t\t\t dispEventUploadForm(); \t\t\t\t\t }); \t\t\t\t\tfunction dispevtproc() \t\t \t\t \t { \t\t\t\t\t\t\$(".forms").css({'display':'none'}); \t\t\t\t\t\t\$("#dheadeventproc").css({'display':'block'}); \t\t\t\t\t } \t\t\t\t\tfunction dispfundreq() \t\t \t\t \t { \t\t\t\t\t\t\$(".forms").css({'display':'none'}); \t\t\t\t\t\t\$("#dheadfundreq").css({'display':'block'}); \t\t\t \t\t } \t\t\t\t\tfunction dispevtform() \t\t\t\t \t { \t\t\t\t\t\t\$(".forms").css({'display':'none'}); \t\t\t\t\t\t\$("#formevt").css({'display':'block'}); \t\t\t\t\t } \t\t\t \t function dispfundform() \t\t\t\t \t { \t\t\t\t\t\t\$(".forms").css({'display':'none'}); \t\t\t\t\t\t\$("#formfund").css({'display':'block'}); \t\t\t\t\t } \t\t\t\t\t function dispEventUploadForm() \t\t\t\t\t { \t\t\t\t\t \$(".forms").css({'display':'none'}); \t\t\t\t\t \$("#formEvtName").css({'display':'block'}); \t\t\t\t\t } \t\t\t\t\t\$("#dheadeventproc").css({'width':'100%'}); \t\t\t\t\t\$("#dheadfundreq").css({'width':'100%'}); \t\t\t\t\$(".viewbuttons").css({'height':'25px'}); \t\t\t\t\t});\t \t\t\t</script> \t\t\t<div id="buttonsDiv" class="viewButtonsDiv"> \t \t\t<input type="button" id="bformevt" class="viewbuttons" value="Event procurement "/> \t \t\t<input type="button" id="bformfund" value="Fund" class="viewbuttons" /> \t\t\t<input type="button" id="bhead_evtproc" value="Event procurement details" class="viewbuttons" /> \t\t\t<input type="button" id="bhead_fundreq" value="Fund details" class="viewbuttons" /> \t\t\t<input type="button" id="bhead_evtUpload" value="Upload Event Name" class="viewbuttons" /> \t\t</div> \t\t\t<div id="formevt" class="forms"> \t\t\t\t<h2>Event Procurement Request</h2> \t\t\t<table class="qaostables display" id="table_evtprocrequest" width="100%" border="1"> \t\t\t\t<thead><tr> \t\t\t\t\t<th>EVENT NAME</th> \t\t\t\t\t<th>ITEM</th> \t\t\t\t\t<th>QUANTITY</th> \t\t\t\t\t<th>REASON</th> \t\t\t\t\t<th>STATUS</th> \t\t\t\t\t<th>DEADLINE</th> \t\t\t\t\t<th>ADDED BY</th> \t\t\t\t\t<th>DESCRIPTION</th> \t\t\t\t\t<th>SUBMIT</th> \t\t\t\t</tr></thead> AB; while ($result = mysql_fetch_array($res)) { $event = $result['evtproc_Id']; $userName = getUserName($result['userid']); if ($result['evtproc_Status'] == 0) { $status = 0; } else { $status = 1; } if ($status == 0) { $headaction .= <<<AB \t \t\t\t <tr id="tr{$event}" > \t \t\t\t \t <td>{$result["evtproc_name"]}</td> \t \t\t\t\t\t <td>{$result['evtproc_Request']}</td> \t \t\t\t\t\t <td>{$result['evtproc_Quantity']}</td> \t\t\t\t\t\t <td>{$result['evtproc_reason']}</td> \t\t\t\t\t\t <td> \t\t\t\t\t\t\t<input type="radio" name="status{$event}" id="status{$event}1" value="1">ACCEPT<br/ > \t \t\t\t\t\t \t<input type="radio" name="status{$event}" id="status{$event}2" value="2">Decline<br/> \t\t\t\t\t\t </td> \t\t\t\t\t\t <td>{$result['evtproc_date']}</td> \t\t\t\t\t\t <td>{$userName}</td>\t\t\t\t \t\t\t\t\t\t <td><textarea id="description{$event}"></textarea></td> \t\t\t\t\t\t <td> \t\t\t\t\t\t\t<form action="./+head&subaction=apEventProc" method="post" onsubmit="return qaosproc({$event})"> \t\t\t\t\t\t\t <input type="hidden" value="" id="hid{$event}" name="hid"> \t\t\t\t\t\t\t <input type="hidden" value="{$event}" id="hi2d{$event}" name="hid2"> \t\t\t\t\t\t\t <input type="hidden" value="" id="hi1d{$event}" name="hid1"> \t\t\t\t\t\t\t <input type="submit" value="submit"> \t\t\t\t\t\t\t</form> \t\t\t\t\t\t </td> \t\t\t\t\t </tr> AB; } } $headaction .= <<<AB \t\t \t </table> \t\t\t\t </div> \t\t\t\t <div id="formfund" class="forms"> \t\t \t\t<h2>Fund request</h2> \t\t\t\t \t<table class="qaostables display" id="table_fundreqform" border="1" width="100%"> \t\t\t\t\t <thead> <tr> \t\t\t\t\t\t<th>EVENT NAME</th> \t\t\t\t\t\t<th>ITEM</th> \t\t\t\t\t\t<th>QUANTITY</th> \t\t\t\t\t\t<th>AMOUNT</th> \t\t\t\t\t\t<th>REASON</th> \t\t\t\t\t\t<th>STATUS</th> \t\t\t\t\t\t<th>DEADLINE</th> \t\t <th>ADDED BY</th> \t\t\t\t\t\t<th>DESCRIPTION</th> \t\t <th>SUBMIT</th> \t\t\t\t\t </tr></thead> AB; while ($result1 = mysql_fetch_array($res1)) { $event1 = $result1['fundreq_Id']; $userName = getUserName($result1['userid']); if ($result1['fundreq_Status'] == 0) { $status1 = 0; } else { $status1 = 1; } if ($status1 == 0) { $headaction .= <<<AB \t \t\t\t\t\t <tr id="trf{$event1}"> \t \t\t\t\t\t <td>{$result1["fundreq_name"]}</td> \t \t\t\t\t\t\t <td>{$result1['fundreq_Request']}</td> \t \t\t\t\t\t\t <td>{$result1['fundreq_Quantity']}</td> \t \t\t\t\t\t\t <td>{$result1["fundreq_Amount"]}</td> \t \t\t\t\t\t\t <td>{$result1["fundreq_reason"]}</td> \t \t\t\t\t\t\t <td> \t\t\t\t\t\t\t\t<input type="radio" name="qstatus{$event1}" id="qstatus{$event1}1" value="1">ACCEPT<br/ > \t \t\t\t\t\t\t\t<input type="radio" name="qstatus{$event1}" id="qstatus{$event1}2" value="2">Decline<br/> \t\t\t\t\t\t\t </td> \t\t\t\t\t\t\t\t <td>{$result1["fundreq_date"]}</td> \t\t\t\t\t\t\t <td>{$userName}</td>\t\t \t \t\t\t\t\t\t <td><textarea id="qdescription{$event1}"></textarea></td> \t \t\t\t\t\t\t <td> \t\t\t\t\t\t\t\t<form action="./+head&&subaction=apFundReq" method="post" onsubmit="return qaosfund({$event1})"> \t\t\t\t\t\t\t \t <input type="hidden" value="" id="qhid{$event1}" name="qhid"> \t \t\t\t\t\t\t\t <input type="hidden" value="{$event1}" id="qhi2d{$event1}" name="qhid2"> \t \t\t\t\t\t\t\t <input type="hidden" value="" id="qhi1d{$event1}" name="qhid1"> \t \t\t\t\t\t\t\t <input type="submit" value="submit"> \t\t\t\t\t\t\t \t</form> \t\t\t\t\t\t\t </td> \t\t\t\t\t\t </tr> AB; } } $headaction .= <<<AB \t\t\t\t\t\t</table> \t\t\t\t\t \t</div> \t\t\t\t\t\t<div class="headdisplay" id="headdisplayevt"> AB; $hist1 = "SELECT *FROM qaos1_evtproc WHERE modulecomponentid={$this->moduleComponentId}"; $res = mysql_query($hist1); $headaction .= <<<AB \t \t <div id="dheadeventproc" class="forms"> \t\t\t\t\t<h2>Event Procurement Status</h2>\t \t \t \t \t <table id="table_eventproc_head" class="display"border="1" width="100%" class="qaostables"> \t \t\t <thead><tr> \t\t\t\t\t\t<th>ITEM</th> \t\t\t\t\t\t<th>QUANTITY</th> \t\t\t\t\t\t<th>EVENT NAME</th> \t\t\t\t\t\t<th>REASON</th>\t\t\t\t \t\t \t\t\t\t \t\t<th>STATUS</th> \t\t <th>ADDED BY</th> \t\t\t\t \t\t<th>DEADLINE</th> \t\t\t\t \t\t<th>DESCRIPTION</th> \t\t\t\t\t </tr></thead> AB; while ($result = mysql_fetch_array($res)) { $userName = getUserName($result['userid']); if ($result['evtproc_Status'] == 0) { $status = "Pending"; } else { if ($result['evtproc_Status'] == 1) { $status = "Accepted By QA"; } else { if ($result['evtproc_Status'] == 2) { $status = "Decline"; } else { if ($result['evtproc_Status'] == 3) { $status = "Accepted By OC"; } } } } $headaction .= <<<AB \t\t\t\t <tr class="tr{$result['evtproc_Status']}"> \t\t\t\t <td>{$result['evtproc_Request']}</td> \t\t\t\t <td>{$result['evtproc_Quantity']}</td> \t\t\t\t <td>{$result['evtproc_name']}</td> \t\t\t\t <td>{$result['evtproc_reason']}</td>\t\t\t\t \t\t\t\t <td>{$status}</td> \t\t\t\t\t<td>{$userName}</td>\t\t \t\t\t\t <td>{$result['evtproc_date']}</td> \t\t\t\t <td>{$result['evtproc_Desc']}</td> \t\t\t \t </tr> AB; } $headaction .= <<<AB </table></div> \t\t\t<div class="forms" id="dheadfundreq"> \t\t\t<h2>Fund Request Status</h2> \t\t <table id="table_funreq_head" class="display"border="1" width="100%" class="qaostables"> \t\t\t <thead> \t\t\t <tr> \t\t\t\t <th>ITEM</th> \t\t\t\t <th>QUANTITY</th> \t\t\t\t <th>EVENT NAME</th> \t\t\t\t <th>Reason</th> \t\t\t\t <th>STATUS</th> <th>ADDED BY</th> \t\t\t\t <th>DEADLINE</th> \t\t\t\t <th>DESCRIPTION</th> \t\t\t </tr></thead> AB; $hist2 = "SELECT * FROM qaos1_fundreq WHERE modulecomponentid={$this->moduleComponentId}"; $res1 = mysql_query($hist2); while ($result1 = mysql_fetch_array($res1)) { $userName = getUserName($result1['userid']); if ($result1['fundreq_Status'] == 0) { $status1 = "Pending"; } else { if ($result1['fundreq_Status'] == 1) { $status1 = "Accepted by QA"; } else { if ($result1['fundreq_Status'] == 2) { $status1 = "Decline"; } else { if ($result1['fundreq_Status'] == 3) { $status1 = "collect the amt from treasurer"; } } } } $headaction .= <<<AB \t\t\t\t<tr class="tr{$result1['fundreq_Status']}"> \t\t\t\t<td>{$result1['fundreq_Request']}</td> \t\t\t\t\t<td>{$result1['fundreq_Quantity']}</td> \t\t\t\t\t<td>{$result1['fundreq_name']}</td> \t\t\t\t\t<td>{$result1['fundreq_reason']}</td> \t\t\t\t\t<td>{$status1}</td> \t\t\t\t\t<td>{$userName}</td>\t\t \t\t\t\t\t<td>{$result1['fundreq_date']}</td> \t\t\t\t\t<td>{$result1['fundreq_Desc']}</td> \t\t\t\t</tr> AB; } $uploadEventName = getFileUploadForm($this->moduleComponentId, "qaos1", './+head', UPLOAD_SIZE_LIMIT, 1); $headaction .= <<<AB \t </table></div> \t <div class="forms" id="formEvtName"> \t <h2>Upload Event Details</h2> \t <form action="./+head" method="post"> \t <input type="submit" name="downloadFormatExcel" value="Download Event Sample Format"/> \t </form> \t {$uploadEventName} \t </div> AB; return $headaction; }
function syncExcelFileWorkshop($pmcId, $workshopId, $fileLoc) { $excelData = readExcelSheet($fileLoc); for ($i = 1; $i <= count($excelData); $i++) { for ($j = 1; $j <= count($excelData[$i]); $j++) { $userPid = $excelData[$i][$j]; if ($userPid[0] == 'F' || $userPid[0] == 'f') { $userPid = getUserIdFromBookletId($userPid, $pmcId); } if (!empty($excelData[$i][$j])) { $checkDuplicateQuery = "SELECT `user_id` FROM `events_workshop_participants` WHERE `page_moduleComponentId`='{$pmcId}' AND `workshop_id`='{$workshopId}' AND `user_id`='{$userPid}'"; $checkDuplicateRes = mysql_query($checkDuplicateQuery) or displayerror(mysql_error()); if (mysql_num_rows($checkDuplicateRes) == 0) { $saveUserIdQuery = "INSERT INTO `events_workshop_participants`(`page_moduleComponentId`,`workshop_id`,`user_id`,`user_team_id`) VALUES('{$pmcId}','{$workshopId}','{$userPid}','{$i}')"; $saveUserIdRes = mysql_query($saveUserIdQuery) or displayerror(mysql_error()); } } } } }
public function actionOchead() { global $urlRequestRoot, $moduleFolder, $cmsFolder, $templateFolder, $sourceFolder, $STARTSCRIPTS; require_once $sourceFolder . "/upload.lib.php"; require_once $sourceFolder . "/" . $moduleFolder . "/qaos1/excel.php"; require_once $sourceFolder . "/" . $moduleFolder . "/oc/oc_common.php"; $mcId = $this->moduleComponentId; $userId = $this->userId; if (isset($_POST['downloadFormatExcel'])) { displayOCDownload(); } if (isset($_FILES['fileUploadField']['name'])) { $date = date_create(); $timeStamp = date_timestamp_get($date); $tempVar = $sourceFolder . "/uploads/temp/" . $timeStamp . $_FILES['fileUploadField']['name'][0]; move_uploaded_file($_FILES["fileUploadField"]["tmp_name"][0], $tempVar); $excelData = readExcelSheet($tempVar); $success = 1; for ($i = 2; $i <= count($excelData); $i++) { $email = $excelData[$i][2] . '@nitt.edu'; $query = "INSERT IGNORE INTO `oc_valid_emails` (`page_moduleComponentId`,`oc_name`,`oc_valid_email`) \n VALUES ({$mcId},'{$excelData[$i][1]}','{$email}')"; mysql_query($query) or displayerror($email); } //echo $c." ".$d; } $retOcHead = ""; $uploadValidEmail = getFileUploadForm($mcId, "oc", './+ochead', UPLOAD_SIZE_LIMIT, 1); $retOcHead .= <<<FORM <form action="./+ochead" method="post"> <input type="submit" name="downloadFormatExcel" value="Download Event Sample Format"/> </form> FORM; $retOcHead .= $uploadValidEmail; $displayTags = <<<TAG <table> <tr> <td><a href="./+ochead&subaction=view_whitelist_users"> <div>View Whitelist Registrants</div></a></td> <td><a href="./+ochead&subaction=view_registered_users"><div>Registred Users</div></a></td> <td><a href="./+ochead&subaction=add_whitelist_email"><div>Add Whitelist Email</div></a></td> <td><a href="./+ochead&subaction=availability"><div>Check Availability</div></a></td> <td><a href="./+ochead&subaction=reg_status"><div>Current Registration Status</div></a></td> <td><a href="./+ochead&subaction=reg_status"><div>Current Registration Status</div></a></td> <td><a href="./+ochead&subaction=upload_tshirt_list"><div>Upload TShirt List</div></a></td> <td><a href="./+ochead&subaction=download_black_list"><div>Download Black List</div></a></td> </tr> </table> TAG; if (isset($_GET['subaction']) && $_GET['subaction'] == 'view_registered_users') { return $retOcHead . $displayTags . view_registered_users($mcId); } if (isset($_GET['subaction']) && $_GET['subaction'] == 'view_whitelist_users') { return $retOcHead . $displayTags . view_whitelist_emails($mcId); } if (isset($_GET['subaction']) && $_GET['subaction'] == 'add_whitelist_email') { return $retOcHead . $displayTags . add_whitelist_email($mcId); } if (isset($_GET['subaction']) && $_GET['subaction'] == 'availability') { return $retOcHead . $displayTags . availability($mcId); } if (isset($_GET['subaction']) && $_GET['subaction'] == 'reg_status') { return $retOcHead . $displayTags . reg_status($mcId); } if (isset($_GET['subaction']) && $_GET['subaction'] == 'upload_tshirt_list') { return $retOcHead . $displayTags . upload_tshirt_list($mcId); } if (isset($_GET['subaction']) && $_GET['subaction'] == 'download_black_list') { return $retOcHead . $displayTags . download_black_list($mcId); } return $retOcHead . $displayTags . view_registered_users($mcId); }
public function actionHospihead() { global $urlRequestRoot, $sourceFolder, $templateFolder, $cmsFolder, $moduleFolder; $moduleComponentId = $this->moduleComponentId; $scriptsFolder = "{$urlRequestRoot}/{$cmsFolder}/{$templateFolder}/common/scripts"; $imagesFolder = "{$urlRequestRoot}/{$cmsFolder}/{$templateFolder}/common/images"; require_once "{$sourceFolder}/{$moduleFolder}/prhospi/prhospi_common.php"; require_once "{$sourceFolder}/{$moduleFolder}/prhospi/accommodation.php"; require_once $sourceFolder . "/" . $moduleFolder . "/qaos1/excel.php"; require_once $sourceFolder . "/upload.lib.php"; if (isset($_GET['subaction']) && $_GET['subaction'] == 'getsuggestions' && isset($_GET['forwhat'])) { echo getSuggestionsForIdOrEmail(escape($_GET['forwhat'])); exit; } if (isset($_POST['txtFormUserId']) && $_POST['txtFormUserId'] != '') { $detailsGiven = explode("- ", escape($_POST['txtFormUserId'])); deleteAccomodatedUser($detailsGiven[1], $moduleComponentId); } displayinfo(print_r(assignVars($this->userId, $moduleComponentId), true)); if (isset($_POST['amountDetail'])) { $amt = mysql_real_escape_string($_POST['amountDetail']); $insertQuery = "UPDATE `prhospi_disclaimer` SET `team_cost`={$amt} WHERE `page_modulecomponentid`={$this->moduleComponentId} AND "; $insertQuery .= "`disclaimer_team`='hospihead'"; $updateRes = mysql_query($insertQuery) or displayerror(mysql_error()); if ($updateRes != '') { displayinfo("Amount Updated to Rs. {$amt}"); } } if (isset($_POST['amountDetail1'])) { $amt = mysql_real_escape_string($_POST['amountDetail1']); $insertQuery = "UPDATE `prhospi_disclaimer` SET `team_cost`={$amt} WHERE `page_modulecomponentid`={$this->moduleComponentId} AND "; $insertQuery .= "`disclaimer_team`='hospihead1'"; $updateRes = mysql_query($insertQuery) or displayerror(mysql_error()); if ($updateRes != '') { displayinfo("Amount Updated to Rs. {$amt}"); } } if (isset($_POST['CKEditor1'])) { $editorData = escape($_POST['CKEditor1']); $insertQuery = "UPDATE `prhospi_disclaimer` SET `disclaimer_desc`='{$editorData}' WHERE `page_modulecomponentid`={$this->moduleComponentId} "; $insertQuery .= "AND `disclaimer_team`='hospihead'"; $updateRes = mysql_query($insertQuery) or displayerror(mysql_error()); if ($updateRes != '') { displayinfo("Details Successfully updated !!!"); } } if (isset($_POST['downloadSampleFormat'])) { downloadSampleFormatForRoomUpload(); } if (isset($_FILES['fileUploadField']['name'])) { $excelData = readExcelSheet($_FILES['fileUploadField']['tmp_name'][0]); $success = 1; for ($i = 2; $i <= count($excelData); $i++) { for ($j = $excelData[$i][2]; $j <= $excelData[$i][3]; $j++) { if ($excelData[$i][1] == NULL) { continue; } $checkIfExistQuery = "SELECT * FROM `prhospi_hostel` \n WHERE `hospi_hostel_name`='{$excelData[$i][1]}' AND \n `hospi_room_no`={$j} AND `page_modulecomponentid`={$moduleComponentId}"; $checkIfExistRes = mysql_query($checkIfExistQuery) or displayerror(mysql_error()); if (mysql_num_rows($checkIfExistRes)) { $updateFieldQuery = "UPDATE `prhospi_hostel` \n SET `hospi_room_capacity`={$excelData[$i][4]} , `hospi_floor` = {$excelData[$i][5]}\n WHERE `page_modulecomponentid`={$moduleComponentId} AND \n `hospi_hostel_name`='{$excelData[$i][1]}' AND `hospi_room_no`={$j}"; $updateResult = mysql_query($updateFieldQuery) or displayerror(mysql_error()); continue; } $insertIntoHospiQuery = "INSERT INTO `prhospi_hostel` (page_modulecomponentid,hospi_hostel_name,hospi_room_capacity,\n hospi_room_no,hospi_floor) VALUES ({$moduleComponentId},'{$excelData[$i][1]}',{$excelData[$i][4]},{$j},{$excelData[$i][5]})"; $res = mysql_query($insertIntoHospiQuery) or displayerror(mysql_error()); if ($res == "") { $success = 0; } } } if (!$success) { displayerror("Datas are not inserted"); } } $hospiview = ""; $hospiview .= <<<VIEW \t<table> <a onClick="history.go(-1)">BACK</a><br/> <tr> <td><a href="./+hospihead&subaction=addRoom"> <div>Add Rooms</div></a></td> <td><a href="./+hospihead&subaction=viewStatus"><div>View All Rooms</div></a></td> <td><a href="./+hospihead&subaction=ckEditor"><div>Update Disclaimer</div></a></td> <td><a href="./+hospihead&subaction=deleteUsers"><div>Delete User in Accomodation</div></a></td> <td><a href="./+hospihead&subaction=blockRooms"><div>Block Rooms</div></a></td> </tr> </table> VIEW; if (isset($_GET['subaction'])) { if ($_GET['subaction'] == 'blockRooms') { $hospiview .= blockRoom($this->moduleComponentId); } if ($_GET['subaction'] == 'ckEditor') { $hospiview .= $this->getCkBody("", "hospihead"); } else { if ($_GET['subaction'] == 'addRoom') { $fileUploadableForm = getFileUploadForm($this->moduleComponentId, "prhospi", './+hospihead', UPLOAD_SIZE_LIMIT, 1); $hospiview .= <<<ADDROOMFORM <br/><br/> <form action="./+hospihead" method="post"> <input type="submit" name="downloadSampleFormat" value="Download Sample Form"><br/> </form> {$fileUploadableForm} ADDROOMFORM; } else { if ($_GET['subaction'] == 'viewStatus') { $hospiview .= displayRooms($moduleComponentId); } else { if ($_GET['subaction'] == 'deleteUsers') { $deleteUserForm = displayUsersRegisteredToAccoWithDelete($moduleComponentId); $hospiview .= <<<HOSPI \t {$deleteUserForm} <form method="POST" action="./+hospihead"> \t Enter UserId or Email:<input type="text" name="txtFormUserId" id="txtFormUserId" autocomplete="off" style="width: 256px" /> \t <div id="suggestionsBox" style="background-color: white; width: 260px; border: 1px solid black; position: absolute; overflow-y: scroll; max-height: 180px; display: none"></div> \t <input type="submit" Value="Find User"/> \t <script type="text/javascript" language="javascript" src="{$scriptsFolder}/ajaxsuggestionbox.js"> \t </script> \t <script language="javascript"> \t var userBox = new SuggestionBox(document.getElementById('txtFormUserId'), document.getElementById('suggestionsBox'), "./+hospihead&subaction=getsuggestions&forwhat=%pattern%"); \tuserBox.loadingImageUrl = '{$imagesFolder}/ajaxloading.gif'; \t</script> \t</form> HOSPI; } } } } } return $hospiview; }
function upload_tshirt_list($mcId) { global $sourceFolder, $moduleFolder; require_once $sourceFolder . "/" . $moduleFolder . "/qaos1/excel.php"; if (isset($_FILES['uploadTShirtDetail']['name'][0])) { $date = date_create(); $timeStamp = date_timestamp_get($date); $tempVar = $sourceFolder . "/uploads/temp/" . $timeStamp . $_FILES['uploadTShirtDetail']['name'][0]; move_uploaded_file($_FILES["uploadTShirtDetail"]["tmp_name"][0], $tempVar); $excelData = readExcelSheet($tempVar); $success = 1; for ($i = 2; $i <= count($excelData); $i++) { $name = $excelData[$i][1]; $rollNumber = $excelData[$i][2]; $tsize = $excelData[$i][3]; if ($tsize == '') { $tsize = 'N'; } $query = "INSERT IGNORE INTO `oc_form_reg` (`page_modulecomponentid`,`name`,`amount`,`user_id`,`Tshirt_size`,`updated_time`,`oc_roll_no`) \n VALUES ('{$mcId}','{$name}','700','0','{$tsize}',NOW(),'{$rollNumber}')"; mysql_query($query) or displayerror(mysql_error()); // $query = "UPDATE `oc_form_reg` SET Tshirt_size='{$tsize}' WHERE page_modulecomponentid='{$mcId}' AND oc_roll_no='{$rollNumber}'"; // mysql_query($query) or displayerror(mysql_error()); } } $uploadValidEmail = getFileUploadForm($mcId, "oc", './+ochead&subaction=upload_tshirt_list', false, 1, 'uploadTShirtDetail'); return $uploadValidEmail; }