$connection2->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); } catch (PDOException $e) { echo $e->getMessage(); } @session_start(); //Set timezone from session variable date_default_timezone_set($_SESSION[$guid]["timezone"]); $gibbonCourseClassID = $_GET["gibbonCourseClassID"]; $return = $_GET["return"]; $URL = $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/Markbook/{$return}"; if (isActionAccessible($guid, $connection2, "/modules/Markbook/markbook_view.php") == FALSE) { //Fail 0 $URL .= "&exportReturn=fail0"; header("Location: {$URL}"); } else { try { $data = array("gibbonCourseClassID" => $gibbonCourseClassID); $sql = "SELECT * FROM gibbonMarkbookColumn JOIN gibbonCourseClass ON (gibbonMarkbookColumn.gibbonCourseClassID=gibbonCourseClass.gibbonCourseClassID) WHERE gibbonCourseClass.gibbonCourseClassID=:gibbonCourseClassID"; $result = $connection2->prepare($sql); $result->execute($data); } catch (PDOException $e) { //Fail 0 $URL .= "&exportReturn=fail0"; header("Location: {$URL}"); break; } //Proceed! $exp = new ExportToExcel(); $exp = new ExportToExcel(); $exp->exportWithPage($guid, "./markbook_viewExportAllContents.php", "markbookAll.xls", $gibbonCourseClassID); }
header("Location: {$URL}"); } else { if ($emailFail == TRUE) { //Success 1 $URL .= "&bulkReturn=success1"; header("Location: {$URL}"); } else { //Success 0 $URL .= "&bulkReturn=success0"; header("Location: {$URL}"); } } } else { if ($action == "export") { $_SESSION[$guid]["financeInvoiceExportIDs"] = $gibbonFinanceInvoiceIDs; $exp = new ExportToExcel(); $exp->exportWithPage($guid, "./invoices_manage_processBulkExportContents.php", "invoices.xls", "&gibbonSchoolYearID={$gibbonSchoolYearID}"); // THIS CODE HAS BEEN COMMENTED OUT, AS THE EXPORT RETURNS WITHOUT IT...NOT SURE WHY! //Success 0 //$URL.="&bulkReturn=success0" ; //header("Location: {$URL}"); } else { $URL .= "&bulkReturn=fail3"; header("Location: {$URL}"); } } } } } } }
echo $e->getMessage(); } @session_start(); //Module includes include "./moduleFunctions.php"; //Set timezone from session variable date_default_timezone_set($_SESSION[$guid]["timezone"]); $URL = $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . getModuleName($_GET["address"]) . "/report_transport_student.php"; if (isActionAccessible($guid, $connection2, "/modules/Students/report_transport_student.php") == FALSE) { //Fail 0 $URL .= "&exportReturn=fail0"; header("Location: {$URL}"); } else { try { $data = array("gibbonSchoolYearID" => $_SESSION[$guid]["gibbonSchoolYearID"]); $sql = "SELECT gibbonPerson.gibbonPersonID, transport, surname, preferredName, address1, address1District, address1Country, nameShort FROM gibbonPerson JOIN gibbonStudentEnrolment ON (gibbonPerson.gibbonPersonID=gibbonStudentEnrolment.gibbonPersonID) JOIN gibbonRollGroup ON (gibbonStudentEnrolment.gibbonRollGroupID=gibbonRollGroup.gibbonRollGroupID) WHERE gibbonStudentEnrolment.gibbonSchoolYearID=:gibbonSchoolYearID AND status='Full' AND (dateStart IS NULL OR dateStart<='" . date("Y-m-d") . "') AND (dateEnd IS NULL OR dateEnd>='" . date("Y-m-d") . "') ORDER BY transport, surname, preferredName"; $result = $connection2->prepare($sql); $result->execute($data); } catch (PDOException $e) { print "<div class='error'>" . $e->getMessage() . "</div>"; } if ($result->rowCount() < 1) { //Fail 3 $URL .= "&exportReturn=fail3"; header("Location: {$URL}"); } else { //Proceed! $exp = new ExportToExcel(); $exp->exportWithPage($guid, "./report_transport_studentExportContents.php", "studentTransport.xls"); } }
$sqlWhere .= "gibbonLibraryTypeID=:gibbonLibraryTypeID AND "; } if ($gibbonSpaceID != "") { $data["gibbonSpaceID"] = $gibbonSpaceID; $sqlWhere .= "gibbonSpaceID=:gibbonSpaceID AND "; } if ($status != "") { $data["status"] = $status; $sqlWhere .= "status=:status AND "; } if ($sqlWhere == "WHERE ") { $sqlWhere = ""; } else { $sqlWhere = substr($sqlWhere, 0, -5); } $sql = "SELECT * FROM gibbonLibraryItem {$sqlWhere} ORDER BY id"; $result = $connection2->prepare($sql); $result->execute($data); } catch (PDOException $e) { print "<div class='error'>" . $e->getMessage() . "</div>"; } if ($result->rowCount() < 1) { //Fail 3 $URL .= "&exportReturn=fail3"; header("Location: {$URL}"); } else { //Proceed! $exp = new ExportToExcel(); $exp->exportWithPage($guid, "./report_catalogSummaryExportContents.php", "catalogSummary.xls", "ownershipType={$ownershipType}&gibbonLibraryTypeID={$gibbonLibraryTypeID}&gibbonSpaceID={$gibbonSpaceID}&status={$status}"); } }
if ($gibbonFinanceBudgetCycleID == "" or $action == "") { print "Fatal error loading this page!"; } else { $URL = $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . getModuleName($_POST["address"]) . "/expenses_manage.php&gibbonFinanceBudgetCycleID={$gibbonFinanceBudgetCycleID}"; if (isActionAccessible($guid, $connection2, "/modules/Finance/expenses_manage.php") == FALSE) { //Fail 0 $URL .= "&bulkReturn=fail0"; header("Location: {$URL}"); } else { $gibbonFinanceExpenseIDs = $_POST["gibbonFinanceExpenseIDs"]; if (count($gibbonFinanceExpenseIDs) < 1) { $URL .= "&bulkReturn=fail3"; header("Location: {$URL}"); } else { $partialFail = FALSE; //Export if ($action == "export") { $_SESSION[$guid]["financeExpenseExportIDs"] = $gibbonFinanceExpenseIDs; $exp = new ExportToExcel(); $exp->exportWithPage($guid, "./expenses_manage_processBulkExportContents.php", "invoices.xls", "&gibbonFinanceBudgetCycleID={$gibbonFinanceBudgetCycleID}"); // THIS CODE HAS BEEN COMMENTED OUT, AS THE EXPORT RETURNS WITHOUT IT...NOT SURE WHY! //Success 0 //$URL.="&bulkReturn=success0" ; //header("Location: {$URL}"); } else { $URL .= "&bulkReturn=fail3"; header("Location: {$URL}"); } } } }
public function export_xls($date, $thesis) { $table = $this->export_table($date, $thesis); $excel = new ExportToExcel(); switch ($thesis) { case 'D3': $excel->exportWithPage($table, "Rekap-data-yudisium-d3-" . $date . ".xls"); break; case 'Skripsi': $excel->exportWithPage($table, "Rekap-data-yudisium-s1-" . $date . ".xls"); break; default: $excel->exportWithPage($table, "Rekap-data-yudisium-all-" . $date . ".xls"); break; } }
$gibbonMarkbookColumnID = $_GET["gibbonMarkbookColumnID"]; $gibbonCourseClassID = $_GET["gibbonCourseClassID"]; $return = $_GET["return"]; $URL = $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/Markbook/{$return}"; if (isActionAccessible($guid, $connection2, "/modules/Markbook/markbook_view.php") == FALSE) { //Fail 0 $URL .= "&exportReturn=fail0"; header("Location: {$URL}"); } else { try { $data = array("gibbonCourseClassID" => $gibbonCourseClassID, "gibbonMarkbookColumnID" => $gibbonMarkbookColumnID); $sql = "SELECT * FROM gibbonMarkbookColumn JOIN gibbonCourseClass ON (gibbonMarkbookColumn.gibbonCourseClassID=gibbonCourseClass.gibbonCourseClassID) WHERE (gibbonMarkbookColumn.gibbonCourseClassID=:gibbonCourseClassID AND gibbonMarkbookColumnID=:gibbonMarkbookColumnID)"; $result = $connection2->prepare($sql); $result->execute($data); } catch (PDOException $e) { //Fail 0 $URL .= "&exportReturn=fail0"; header("Location: {$URL}"); break; } if ($result->rowCount() != 1) { //Fail 3 $URL .= "&exportReturn=fail3"; header("Location: {$URL}"); } else { //Proceed! $exp = new ExportToExcel(); $exp = new ExportToExcel(); $exp->exportWithPage($guid, "./markbook_viewExportContents.php", "markbookColumn.xls", $gibbonMarkbookColumnID); } }