Esempio n. 1
0
 /**
  * Reset the controller so that all data in the input and output
  * buffers are cleared, any compiled template files are removed
  * and (optionally) the user session is destroyed
  * 
  * @param bool $clearSession (default = true)
  */
 protected function Reset($clearSession = true)
 {
     $this->SetUrl('');
     $this->SetRequestBody('');
     $this->ClearOutput();
     $this->ClearVars();
     $this->RemoveCompiledTemplateFiles();
     $re = GlobalConfig::GetInstance()->GetRenderEngine();
     if ($re) {
         $re->clearAll();
         $re->assign("ROOT_URL", GlobalConfig::$ROOT_URL);
         $re->assign("PHREEZE_VERSION", Phreezer::$Version);
         $re->assign("PHREEZE_PHAR", Phreezer::PharPath());
     }
     if ($clearSession) {
         $this->ClearCurrentUser();
     }
 }
 /**
  * Output the Fortunes test template
  */
 public function Fortunes()
 {
     require_once "Model/Fortune.php";
     require_once "verysimple/Phreeze/PHPRenderEngine.php";
     // charset must be set to UTF8 to support multi-byte chars
     $this->Phreezer->DataAdapter->ConnectionSetting->Charset = "utf8";
     // obtain fortunes without using 'order by'
     $fortunes = $this->Phreezer->Query('Fortune')->ToObjectArray();
     // dynamically add a new, non-persisted Fortune object
     $newFortune = new Fortune($this->Phreezer);
     $newFortune->Id = 0;
     $newFortune->Message = 'Additional fortune added at request time.';
     $fortunes[] = $newFortune;
     // sort (will use Fortune->ToString)
     Phreezer::Sort($fortunes);
     // Render using a template
     $this->RenderEngine = new PHPRenderEngine('templates');
     $this->Assign('fortunes', $fortunes);
     $this->Render('TestFortunes.php');
 }
 /**
  * Streams to the browser the provided array of objects as a basic Excel document
  * with headers.  if the objects have an associated Map class, then footers will be
  * added to sum any numeric fields.  otherwise no footers are added
  * 
  * Note that PEAR Spreadsheet_Excel_Writer must be installed
  * @link http://pear.php.net/package/Spreadsheet_Excel_Writer
  * 
  * @param Array an array of Phreezable objects, obtained for example, using DataSet->ToObjectArray
  * @param Phreezer $phreezer is needed to get field maps
  * @param string (optional) The title of the report
  */
 static function OutputAsExcel(array $objects, Phreezer $phreezer, $reportTitle = "Data Export", $fileName = "export.xls")
 {
     require_once 'Spreadsheet/Excel/Writer.php';
     // create the workbook and worksheet
     $workbook = new Spreadsheet_Excel_Writer();
     $worksheet = $workbook->addWorksheet("Export");
     $BOLD_MED =& $workbook->addFormat();
     $BOLD_MED->setSize(16);
     $BOLD_MED->SetBold();
     $BOLD_REG =& $workbook->addFormat();
     $BOLD_REG->setSize(11);
     $BOLD_REG->SetBold();
     $NORMAL =& $workbook->addFormat();
     $NORMAL->setSize(11);
     $CURRENCY =& $workbook->addFormat();
     $CURRENCY->setNumFormat('0.00');
     $CURRENCY->setSize(11);
     $CURRENCY->setAlign('right');
     $worksheet->writeString(0, 0, $reportTitle, $BOLD_MED);
     // default to no columns
     $fields = array();
     $columns = array();
     $is_numeric = array();
     $fieldmap_exists = false;
     // print the headers
     // while we're looping, also parse the fields so we don't have to do
     // it repeatedly when looping through data
     if (isset($objects[0])) {
         try {
             // see if there is a fieldmap for this object
             $fields = $phreezer->GetFieldMaps(get_class($objects[0]));
             $fieldmap_exists = true;
             // these are the columns we'll use for enumeration from here on
             $columns = array_keys($fields);
         } catch (Exception $ex) {
             // no fieldmaps exist, so use the reflection class instead
             $reflect = new ReflectionClass($objects[0]);
             $publicAttributes = $reflect->getProperties(ReflectionProperty::IS_PUBLIC);
             $staticAttributes = $reflect->getStaticProperties();
             // only include non-static public properties
             $props = array_diff($publicAttributes, $staticAttributes);
             foreach ($props as $prop) {
                 $column = $prop->getName();
                 $columns[] = $column;
             }
         }
         $current_column = 0;
         foreach ($columns as $column) {
             // save this so we don't check it every time when looping through data
             $is_numeric[$column] = $fieldmap_exists ? $fields[$column]->IsNumeric() : false;
             $worksheet->writeString(2, $current_column, $column, $BOLD_REG);
             $current_column++;
         }
     }
     $current_row = 3;
     // loop through all of the data
     foreach ($objects as $object) {
         $current_column = 0;
         foreach ($columns as $column) {
             if ($fieldmap_exists == false || $is_numeric[$column] == true) {
                 $worksheet->write($current_row, $current_column, $object->{$column}, $NORMAL);
             } else {
                 $worksheet->writeString($current_row, $current_column, $object->{$column}, $NORMAL);
             }
             $current_column++;
         }
         $current_row++;
     }
     // lastly write to the footer to sum the numeric columns
     $current_column = 0;
     foreach ($columns as $column) {
         if ($is_numeric[$column]) {
             $columnLetter = ExportUtility::GetColumnLetter($current_column);
             $formula = "=SUM(" . $columnLetter . "3:" . $columnLetter . ($current_row - 1) . ")";
             // notice the @ sign in front because this will fire a deprecated warning due to use of "split"
             @$worksheet->write($current_row, $current_column, $formula, $BOLD_REG);
         }
         $current_column++;
     }
     $workbook->send($fileName);
     // this has errors suppressed due to strict mode
     @$workbook->close();
 }
Esempio n. 4
0
 /**
  * @return IRenderEngine
  */
 function GetRenderEngine()
 {
     if ($this->render_engine == null) {
         $engine_class = self::$TEMPLATE_ENGINE;
         if (!class_exists($engine_class)) {
             require_once 'verysimple/Phreeze/' . $engine_class . '.php';
         }
         $this->render_engine = new $engine_class(self::$TEMPLATE_PATH, self::$TEMPLATE_CACHE_PATH);
         $this->render_engine->assign("ROOT_URL", self::$ROOT_URL);
         $this->render_engine->assign("PHREEZE_VERSION", Phreezer::$Version);
         $this->render_engine->assign("PHREEZE_PHAR", Phreezer::PharPath());
     }
     return $this->render_engine;
 }
Esempio n. 5
0
 /**
  * Streams to the browser the provided array of objects as a basic Excel document
  * with headers.  if the objects have an associated Map class, then footers will be
  * added to sum any numeric fields.  otherwise no footers are added
  * 
  * Note that PEAR PHPExcel must be installed
  * @link https://phpexcel.codeplex.com/
  * 
  * @param Array an array of Phreezable objects, obtained for example, using DataSet->ToObjectArray
  * @param Phreezer $phreezer is needed to get field maps
  * @param string (optional) The title of the report
  */
 static function OutputAsExcel(array $objects, Phreezer $phreezer, $reportTitle = "Data Export", $fileName = "export.xls", $creator = "Phreeze Library")
 {
     require_once "PEAR/PHPExcel.php";
     // create the workbook and worksheet
     $workbook = new PHPExcel();
     // set workbook properties
     $workbook->getProperties()->setCreator($creator)->setTitle($fileName);
     $workbook->setActiveSheetIndex(0);
     $worksheet = $workbook->getActiveSheet();
     $current_column = "A";
     $current_row = 1;
     $worksheet->setCellValue($current_column . $current_row, $reportTitle);
     $worksheet->getStyle($current_column . $current_row)->getFont()->setBold(true)->setSize(16);
     $worksheet->getStyle($current_column . $current_row)->getFont()->setName('Arial');
     // default to no columns
     $fields = array();
     $columns = array();
     $is_numeric = array();
     $fieldmap_exists = false;
     $current_row = 3;
     // print the headers
     // while we're looping, also parse the fields so we don't have to do
     // it repeatedly when looping through data
     if (isset($objects[0])) {
         try {
             // see if there is a fieldmap for this object
             $fields = $phreezer->GetFieldMaps(get_class($objects[0]));
             $fieldmap_exists = true;
             // these are the columns we'll use for enumeration from here on
             $columns = array_keys($fields);
         } catch (Exception $ex) {
             // no fieldmaps exist, so use the reflection class instead
             $reflect = new ReflectionClass($objects[0]);
             $publicAttributes = $reflect->getProperties(ReflectionProperty::IS_PUBLIC);
             $staticAttributes = $reflect->getStaticProperties();
             // only include non-static public properties
             $props = array_diff($publicAttributes, $staticAttributes);
             foreach ($props as $prop) {
                 $column = $prop->getName();
                 $columns[] = $column;
             }
         }
         foreach ($columns as $column) {
             // save this so we don't check it every time when looping through data
             $is_numeric[$column] = $fieldmap_exists ? $fields[$column]->IsNumeric() : false;
             $worksheet->setCellValue($current_column . $current_row, $column);
             $worksheet->getStyle($current_column . $current_row)->getFont()->setBold(true)->setSize(11);
             $worksheet->getStyle($current_column . $current_row)->getFont()->setName('Arial');
             $current_column++;
         }
     }
     $current_row = 4;
     // loop through all of the data
     foreach ($objects as $object) {
         $current_column = "A";
         foreach ($columns as $column) {
             if ($fieldmap_exists == false || $is_numeric[$column] == true) {
                 $worksheet->setCellValue($current_column . $current_row, $object->{$column});
             } else {
                 $worksheet->setCellValue($current_column . $current_row, $object->{$column});
             }
             $current_column++;
         }
         $current_row++;
     }
     // lastly write to the footer to sum the numeric columns
     $col = 0;
     foreach ($columns as $column) {
         if ($is_numeric[$column]) {
             $columnLetter = ExportUtility::GetColumnLetter($current_column);
             $formula = "=SUM(" . $columnLetter . "3:" . $columnLetter . ($current_row - 1) . ")";
             // notice the @ sign in front because this will fire a deprecated warning due to use of "split"
             @$worksheet->setCellValue($current_row, $current_column, $formula);
             $worksheet->getStyle($current_column . $current_row)->getFont()->setBold(true);
             $worksheet->getStyle($current_column . $current_row)->getFont()->setName('Arial');
         }
         $current_column++;
     }
     $workbook->getDefaultStyle()->getFont()->setName('Arial')->setSize(11);
     $workbook->setActiveSheetIndex(0);
     $writer = PHPExcel_IOFactory::createWriter($workbook, 'Excel5');
     // set headers to excel:
     header('Content-type: application/vnd.ms-excel');
     header('Content-Disposition: attachment; filename="' . $fileName . '"');
     header('Cache-Control: max-age=0');
     $writer->save('php://output');
 }