/** equip_loan_post() Display the form for printing/pdf output. */ public function equip_loan_post() { $Inventory = new Inventory($_REQUEST['user']); // Set title $this->title = _('FOG Equipment Loan Form'); // This gets the download links for which type of file you want. print "\n\t\t\t\t<h2>" . '<a href="export.php?type=pdf&filename=' . $Inventory->get('primaryuser') . 'EquipmentLoanForm" alt="Export PDF" title="Export PDF" target="_blank">' . $this->pdffile . '</a></h2>'; // Report Maker $ReportMaker = new ReportMaker(); // Get the current Inventory based on what was selected. // Title Information $ReportMaker->appendHTML("<!-- " . _("FOOTER CENTER") . " \"" . '$PAGE' . " " . _("of") . " " . '$PAGES' . " - " . _("Printed") . ": " . $this->nice_date()->format("D M j G:i:s T Y") . "\" -->"); $ReportMaker->appendHTML("<center><h2>" . _("[YOUR ORGANIZATION HERE]") . "</h2></center>"); $ReportMaker->appendHTML("<center><h3>" . _("[sub-unit here]") . "</h3></center>"); $ReportMaker->appendHTML("<center><h2><u>" . _("PC Check-Out Agreement") . "</u></h2></center>"); // Personal Information $ReportMaker->appendHTML("<h4><u>" . _("Personal Information") . "</u></h4>"); $ReportMaker->appendHTML("<h4><b>" . _("Name") . ": </b><u>" . $Inventory->get('primaryUser') . "</u></h4>"); $ReportMaker->appendHTML("<h4><b>" . _("Location") . ": </b><u>" . _("Your Location Here") . "</u></h4>"); $ReportMaker->appendHTML("<h4><b>" . _("Home Address") . ": </b>__________________________________________________________________</h4>"); $ReportMaker->appendHTML("<h4><b>" . _("City / State / Zip") . ": </b>__________________________________________________________________</h4>"); $ReportMaker->appendHTML("<h4><b>" . _("Extension") . ":</b>_________________ <b>" . _("Home Phone") . ":</b> (__________)_____________________________</h4>"); // Computer Information $ReportMaker->appendHTML("<h4><u>" . _("Computer Information") . "</u></h4>"); $ReportMaker->appendHTML("<h4><b>" . _("Serial Number / Service Tag") . ": </b><u>" . $Inventory->get('sysserial') . " / " . $Inventory->get('caseasset') . "_____________________</u></h4>"); $ReportMaker->appendHTML("<h4><b>" . _("Barcode Numbers") . ": </b><u>" . $Inventory->get('other1') . " " . $Inventory->get('other2') . "</u>________________________</h4>"); $ReportMaker->appendHTML("<h4><b>" . _("Date of Checkout") . ": </b>____________________________________________</h4>"); $ReportMaker->appendHTML("<h4><b>" . _("Notes / Miscellaneous / Included Items") . ": </b></h4>"); $ReportMaker->appendHTML("<h4><b>_____________________________________________________________________________________________</b></h4>"); $ReportMaker->appendHTML("<h4><b>_____________________________________________________________________________________________</b></h4>"); $ReportMaker->appendHTML("<h4><b>_____________________________________________________________________________________________</b></h4>"); $ReportMaker->appendHTML("<hr />"); $ReportMaker->appendHTML("<h4><b>" . _("Releasing Staff Initials") . ": </b>_____________________ " . _("(To be released only by XXXXXXXXX)") . "</h4>"); $ReportMaker->appendHTML("<h4>" . _("I have read, understood, and agree to all the Terms and Condidtions on the following pages of this document.") . "</h4>"); $ReportMaker->appendHTML("<br />"); $ReportMaker->appendHTML("<h4><b>" . _("Signed") . ": </b>X _____________________________ " . _("Date") . ": _________/_________/20_______</h4>"); $ReportMaker->appendHTML(_("<!-- " . _("NEW PAGE") . " -->")); $ReportMaker->appendHTML("<!-- " . _("FOOTER CENTER") . " \"" . '$PAGE' . " " . _("of") . " " . '$PAGES' . " - " . _("Printed") . ": " . $this->nice_date()->format("D M j G:i:s T Y") . "\" -->"); $ReportMaker->appendHTML("<center><h3>" . _("Terms and Conditions") . "</h3></center>"); $ReportMaker->appendHTML("<hr />"); $ReportMaker->appendHTML("<h4>" . _("Your terms and conditions here") . "</h4>"); $ReportMaker->appendHTML("<h4><b>" . _("Signed") . ": </b>" . _("X") . " _____________________________ " . _("Date") . ": _________/_________/20_______</h4>"); print "\n\t\t\t<p>" . _('Your form is ready.') . '</p>'; $_SESSION['foglastreport'] = serialize($ReportMaker); }
/** export() Exports the hosts from the database. */ public function export() { $this->title = 'Export Hosts'; // Header Data unset($this->headerData); // Attributes $this->attributes = array(array(), array()); // Templates $this->templates = array('${field}', '${input}'); // Fields $fields = array(_('Click the button to download the hosts table backup.') => '<input type="submit" value="' . _('Export') . '" />'); $report = new ReportMaker(); $Hosts = $this->getClass('HostManager')->find(); foreach ((array) $Hosts as $Host) { if ($Host && $Host->isValid()) { $macs[] = $Host->get('mac'); foreach ($Host->get('additionalMACs') as $AddMAC) { if ($AddMAC && $AddMAC->isValid()) { $macs[] = $AddMAC->__toString(); } } $report->addCSVCell(implode('|', (array) $macs)); $report->addCSVCell($Host->get('name')); $report->addCSVCell($Host->get('ip')); $report->addCSVCell('"' . $Host->get('description') . '"'); $report->addCSVCell($Host->get('imageID')); $this->HookManager->processEvent('HOST_EXPORT_REPORT', array('report' => &$report, 'Host' => &$Host)); $report->endCSVLine(); unset($macs); } } $_SESSION['foglastreport'] = serialize($report); print "\n\t\t\t" . '<form method="post" action="export.php?type=host">'; foreach ((array) $fields as $field => $input) { $this->data[] = array('field' => $field, 'input' => $input); } // Hook $this->HookManager->processEvent('HOST_EXPORT', array('headerData' => &$this->headerData, 'data' => &$this->data, 'templates' => &$this->templates, 'attributes' => &$this->attributes)); // Output $this->render(); print "</form>"; }
private function makeReport() { print '<h2>' . _('FOG Hosts and Users Login') . '<a href="export.php?type=csv&filename=HostsandUsers" target="_blank"><img class="noBorder" src="images/csv.png" /></a><a href="export.php?type=pdf&filename=HostsandUsers" target="_blank"><img class="noBorder" src="images/pdf.png" /></a></h2>'; $Hosts = $this->getClass('HostManager')->find(); $report = new ReportMaker(); $report->appendHTML('<table cellpadding="0" cellspacing="0" border="0" width="100%">'); $report->appendHTML('<tr bgcolor="#BDBDBD"><td><b>Hostname</b></td><td><b>MAC</b></td><td><b>Registered</b></td></tr>'); $report->addCSVCell('Hostname'); $report->addCSVCell('MAC'); $report->addCSVCell('Registered'); $report->endCSVLine(); $cnt = 0; foreach ($Hosts as $Host) { $bg = $cnt++ % 2 == 0 ? "#E7E7E7" : ''; $report->appendHTML('<tr bgcolor="' . $bg . '"><td>' . $Host->get('name') . '</td><td>' . $Host->get('mac') . '</td><td>' . $Host->get('createdTime') . '</td></tr>'); $report->addCSVCell($Host->get('name')); $report->addCSVCell($Host->get('mac')); $report->addCSVCell($Host->get('createdTime')); if ($Host->get('users')) { $report->endCSVLine(); $report->appendHTML('<tr bgcolor="#BDBDBD"><td><b>Username</b></td><td><b>Action</b></td><td><b>Date</b></td><td><b>Time</b></td></tr>'); $report->addCSVCell('Username'); $report->addCSVCell('Action'); $report->addCSVCell('Time'); $report->endCSVLine(); $cnt1 = 0; foreach ($Host->get('users') as $User) { $bg1 = $cnt1++ % 2 == 0 ? "#E7E7E7" : ''; $logintext = $User->get('action') == 1 ? 'Login' : (!$User->get('action') ? 'Logout' : ($User->get('action') == 99 ? 'Service Start' : 'N/A')); if ($logintext == 'Login' || $logintext == 'Logout') { $report->appendHTML('<tr bgcolor="' . $bg1 . '"><td>' . $User->get('username') . '</td><td>' . $logintext . '</td><td>' . $User->get('date') . '</td><td>' . $User->get('datetime') . '</td></tr>'); $report->addCSVCell($User->get('username')); $report->addCSVCell($logintext); $report->addCSVCell($User->get('date')); $report->addCSVCell($User->get('datetime')); $report->endCSVLine(); } } $report->appendHTML('<table cellpadding="0" cellspacing="0" border="0" width="100%">'); $report->appendHTML('<tr bgcolor="#BDBDBD"><td><b>Hostname</b></td><td><b>MAC</b></td><td><b>Registered</b></td></tr>'); $report->addCSVCell('Hostname'); $report->addCSVCell('MAC'); $report->addCSVCell('Registered'); $report->endCSVLine(); } else { $report->endCSVLine(); } } $report->appendHTML('</table>'); $report->outputReport(ReportMaker::FOG_REPORT_HTML); $_SESSION['foglastreport'] = serialize($report); }
global $sugar_config; $language = $sugar_config['default_language']; $app_list_strings = return_app_list_strings_language($language); $app_strings = return_application_language($language); $reportSchedule = new ReportSchedule(); // Process Enterprise Schedule reports via CSV $reportsToEmailEnt = $reportSchedule->get_ent_reports_to_email("", "ent"); global $report_modules, $modListHeader, $locale; foreach ($reportsToEmailEnt as $scheduleId => $scheduleInfo) { $user = BeanFactory::getBean('Users', $scheduleInfo['user_id']); $current_user = $user; // should this be the global $current_user? global $current_user isn't referenced $modListHeader = query_module_access_list($current_user); $report_modules = getAllowedReportModules($modListHeader); // Acquire the enterprise report to be sent $reportMaker = new ReportMaker(); $reportMaker->retrieve($scheduleInfo['report_id']); $mod_strings = return_module_language($language, 'Reports'); // Process data sets into CSV files // loop through data sets; $dataSets = $reportMaker->get_data_sets(); $tempFiles = array(); foreach ($dataSets as $key => $dataSet) { $csv = $dataSet->export_csv(); $filenamestamp = "{$dataSet->name}_{$user->user_name}_" . date(translate("LBL_CSV_TIMESTAMP", "Reports"), time()); $filename = str_replace(" ", "_", "{$reportMaker->name}{$filenamestamp}.csv"); $fp = sugar_fopen(sugar_cached("csv/") . $filename, "w"); fwrite($fp, $csv); fclose($fp); $tempFiles[$filename] = $filename; }
$query_object2->name = $mod_strings['LBL_Q'] . "2"; $query_object2->description = $mod_strings['LBL_Q2_DESC']; $query_object2->query_locked = "off"; $query_object2->team_id = 1; if ($query_object2->db->dbType == 'oci8') { } elseif ($query_object1->db->dbType == 'mssql') { $query_object2->custom_query = "SELECT accounts.name AS 'Account Name',\n\tcase MONTH(opportunities.date_closed) when MONTH(GETDATE()) then SUM(opportunities.amount_usdollar) else SUM(0) end '{sc}0{sc}0',\n\tcase MONTH(opportunities.date_closed) when DATEADD(mm,1,GETDATE()) then SUM(opportunities.amount_usdollar) else SUM(0) end '{sc}0{sc}1',\n\tcase MONTH(opportunities.date_closed) when DATEADD(mm,2,GETDATE()) then SUM(opportunities.amount_usdollar) else SUM(0) end '{sc}0{sc}2',\n\tcase MONTH(opportunities.date_closed) when DATEADD(mm,3,GETDATE()) then SUM(opportunities.amount_usdollar) else SUM(0) end '{sc}0{sc}3',\n\tcase MONTH(opportunities.date_closed) when DATEADD(mm,4,GETDATE()) then SUM(opportunities.amount_usdollar) else SUM(0) end '{sc}0{sc}4',\n\tcase MONTH(opportunities.date_closed) when DATEADD(mm,5,GETDATE()) then SUM(opportunities.amount_usdollar) else SUM(0) end '{sc}0{sc}5',\n\tSUM(opportunities.amount_usdollar) AS 'Total Revenue'\n \n\tFROM opportunities\n\tLEFT JOIN accounts_opportunities ON opportunities.id=accounts_opportunities.opportunity_id \n\tLEFT JOIN accounts ON accounts_opportunities.account_id=accounts.id\n\tWHERE opportunities.date_closed <= DATEADD(mm,5,GETDATE()) AND opportunities.date_closed >= GETDATE()\n\tGROUP BY opportunities.date_closed, accounts.id, accounts.name order by accounts.name\n\t"; } elseif ($query_object1->db->dbType == 'mysql') { $query_object2->custom_query = "SELECT accounts.name AS 'Account Name'\n\t,SUM(IF(MONTH(opportunities.date_closed) = MONTH(CURDATE()), opportunities.amount_usdollar,0)) as '{sc}0{sc}0'\n\t,SUM(IF(MONTH(opportunities.date_closed) = MONTH(DATE_ADD(CURDATE(),INTERVAL 1 MONTH)), opportunities.amount_usdollar,0)) as '{sc}0{sc}1'\n\t,SUM(IF(MONTH(opportunities.date_closed) = MONTH(DATE_ADD(CURDATE(),INTERVAL 2 MONTH)), opportunities.amount_usdollar,0)) as '{sc}0{sc}2'\n\t,SUM(IF(MONTH(opportunities.date_closed) = MONTH(DATE_ADD(CURDATE(),INTERVAL 3 MONTH)), opportunities.amount_usdollar,0)) as '{sc}0{sc}3'\n\t,SUM(IF(MONTH(opportunities.date_closed) = MONTH(DATE_ADD(CURDATE(),INTERVAL 4 MONTH)), opportunities.amount_usdollar,0)) as '{sc}0{sc}4'\n\t,SUM(IF(MONTH(opportunities.date_closed) = MONTH(DATE_ADD(CURDATE(),INTERVAL 5 MONTH)), opportunities.amount_usdollar,0)) as '{sc}0{sc}5'\n\t,SUM(opportunities.amount_usdollar) AS 'Total Revenue'\n\t \n\tFROM opportunities\n\t LEFT JOIN accounts_opportunities \n\tON opportunities.id=accounts_opportunities.opportunity_id \n\tLEFT JOIN accounts \n\tON accounts_opportunities.account_id=accounts.id\n\tWHERE opportunities.date_closed <= DATE_ADD(CURDATE(),INTERVAL 5 MONTH)\n\tAND opportunities.date_closed >= CURDATE()\n\tGROUP BY accounts.id ORDER BY accounts.name"; //end if else mysql or oracle } $query_object2->save(); $query_id1 = $query_object1->id; $query_id2 = $query_object2->id; //Create new Report $report_object = new ReportMaker(); $report_object->name = $mod_strings['LBL_R1']; $report_object->title = $mod_strings['LBL_R1']; $report_object->description = $mod_strings['LBL_R1_DESC']; $report_object->report_align = "center"; $report_object->team_id = 1; $report_object->save(); $report_id = $report_object->id; //Create the data sets for the two custom queries $format_object = new DataSet(); $format_object->name = $mod_strings['LBL_OPP'] . "1"; $format_object->description = $mod_strings['LBL_OPP1_DESC']; $format_object->report_id = $report_id; $format_object->query_id = $query_id1; $format_object->list_order_y = 0; $format_object->exportable = "on";
public function index() { $this->title = _('FOG Hosts and Users Login'); print '<center><a href="export.php?type=csv" target="_blank"><i class="fa fa-file-excel-o fa-2x"></i></a><a href="export.php?type=pdf" target="_blank"><i class="fa fa-file-pdf-o fa-2x"></i></a></center><br/>'; $report = new ReportMaker(); $report->appendHTML('<table cellpadding="0" cellspacing="0" border="0" width="100%">'); $report->appendHTML('<tr bgcolor="#BDBDBD"><td><b>Hostname</b></td><td><b>MAC</b></td><td><b>Registered</b></td></tr>'); $report->addCSVCell('Hostname'); $report->addCSVCell('MAC'); $report->addCSVCell('Registered'); $report->endCSVLine(); $Hosts = $this->FOGCore->getClass('HostManager')->find('', '', '', '', '', 'name'); $cnt = 0; foreach ($Hosts as $Host) { $bg = $cnt++ % 2 == 0 ? "#E7E7E7" : ''; $report->appendHTML('<tr bgcolor="' . $bg . '"><td>' . $Host->get('name') . '</td><td>' . $Host->get('mac') . '</td><td>' . $Host->get('createdTime') . '</td></tr>'); $report->addCSVCell($Host->get('name')); $report->addCSVCell($Host->get('mac')); $report->addCSVCell($Host->get('createdTime')); if ($Host->get('users')) { $report->endCSVLine(); $report->appendHTML('<tr bgcolor="#BDBDBD"><td><b>Username</b></td><td><b>Action</b></td><td><b>Date</b></td><td><b>Time</b></td></tr>'); $report->addCSVCell('Username'); $report->addCSVCell('Action'); $report->addCSVCell('Time'); $report->endCSVLine(); $cnt1 = 0; $Users = $this->getClass('UserTrackingManager')->find(array('hostID' => $Host->get('id'), 'action' => array(null, 0, 1)), '', array('username', 'datetime'), 'DESC', '', 'username'); foreach ($Users as $User) { if ($User->get('username') != 'Array') { $bg1 = $cnt1++ % 2 == 0 ? "#E7E7E7" : ''; $logintext = $User->get('action') == 1 ? 'Login' : 'Logout'; $report->appendHTML('<tr bgcolor="' . $bg1 . '"><td>' . $User->get('username') . '</td><td>' . $logintext . '</td><td>' . $User->get('date') . '</td><td>' . $User->get('datetime') . '</td></tr>'); $report->addCSVCell($User->get('username')); $report->addCSVCell($logintext); $report->addCSVCell($User->get('date')); $report->addCSVCell($User->get('datetime')); $report->endCSVLine(); } } $report->appendHTML('<table cellpadding="0" cellspacing="0" border="0" width="100%">'); $report->appendHTML('<tr bgcolor="#BDBDBD"><td><b>Hostname</b></td><td><b>MAC</b></td><td><b>Registered</b></td></tr>'); $report->addCSVCell('Hostname'); $report->addCSVCell('MAC'); $report->addCSVCell('Registered'); $report->endCSVLine(); } } $report->appendHTML('</table>'); $report->outputReport(0); $_SESSION['foglastreport'] = serialize($report); }