Changeset 456

Timestamp:

05/05/08 19:14:49 (8 months ago)

Author:

aarkerio

Message:

PDF support

Location:

trunk/app

Files:

• controllers/vclassrooms_controller.php (modified) (1 diff)
• models/vclassroom.php (modified) (1 diff)
• views/helpers/fpdf.php (modified) (2 diffs)
• views/vclassrooms/admin_export.ctp (modified) (1 diff)

trunk/app/controllers/vclassrooms_controller.php

@@ -144 +144 @@
  public function admin_export($vclassroom_id) 
  {
-   //$this->set('data', $this->Vclassroom->pdfReport($conditions, $fields));
    $this->layout = 'pdf';
-   $this->set('data','hello world!');
+   $this->set('data', $this->Vclassroom->recordClass($vclassroom_id));
  }
 

trunk/app/models/vclassroom.php

@@ -132 +132 @@
      return $record;
  }
+ /**
+ *  Get class (group) record
+ *
+ * @param  integer $vclassroom_id  description
+ * @return array   $record description
+ * @access public
+ * @author author Manuel Montoya 
+ **/
+ public function recordClass($vclassroom_id)
+ {   
+  $users      = array();
+  $records    = array();
+    
+  $data  = $this->UsersVclassroom->findAll(array('UsersVclassroom.vclassroom_id'=>$vclassroom_id), array('user_id'));
+
+  // die(debug($users));   
+  foreach ($data as $u):
+     
+     $user_id = $u['UsersVclassroom']['user_id'];
+     
+     $conditions        = array('Result.vclassroom_id'=>$vclassroom_id, 'Result.user_id'=>$user_id);
+     $fields            = array('Result.percentage', 'Test.title');  //null;
+     $records[$user_id]['tests']   = $this->Test->Result->findAll($conditions, $fields);
+     //die(debug($record['tests']));
+    
+     $conditions = array('ResultTreasure.vclassroom_id'=>$vclassroom_id, 'ResultTreasure.user_id'=>$user_id);
+     $fields     = array('ResultTreasure.points', 'Treasure.title'); //null;
+     $records[$user_id]['treasures']  =  $this->Treasure->ResultTreasure->findAll($conditions, $fields);  
+         
+     $conditions       = array('Topic.vclassroom_id'=>$vclassroom_id, 'Topic.user_id'=>$user_id);
+     $fields           = array('Forum.title', 'Topic.subject'); //null;
+     $records[$user_id]['topics'] = $this->Forum->Topic->findAll($conditions, $fields);
+     
+     $conditions     = array('Participation.vclassroom_id'=>$vclassroom_id, 'Participation.user_id'=>$user_id);
+     $fields         = array('Participation.title', 'Participation.points'); //null;
+     
+     $records[$user_id]['participations'] = $this->Participation->findAll($conditions, $fields);
+
+     $conditions     = array('ResultWebquest.vclassroom_id'=>$vclassroom_id, 'ResultWebquest.user_id'=>$user_id);
+     $fields         = array('Webquest.title', 'ResultWebquest.points'); //null;
+
+     $records[$user_id]['webquests']      = $this->Webquest->ResultWebquest->findAll($conditions, $fields);
+     
+  endforeach;
+  // die(debug($records));
+  return $records;
+ }
+
 /**
  *  Get student evaluation, return integer

trunk/app/views/helpers/fpdf.php

@@ -14 +14 @@
    * @param string $format values: A3, A4, A5, Letter, Legal or a two element array with the width and height in unit given in $unit
    */
-  public function __construct($orientation='P',$unit='mm',$format='A4') 
+  public function __construct($orientation='P',$unit='mm',$format='Letter') 
   { 
     $this->pdf = new myFPDF($orientation, $unit, $format);
-    //$this->pdf->FPDF($orientation, $unit, $format); // method
-    $this->pdf->AddPage();
     $this->pdf->SetFont('Arial','B',14);
   }
@@ -24 +22 @@
   public function setData($data)
   {
-    $this->pdf->Cell(40,10,$data);
+    $this->pdf->Cell(0,10,$data,1,1,'L');
+    $this->pdf->Ln(10);
   }
-   
+
+  public function newPage()
+  {
+     $this->pdf->AddPage();
+  }
   /**
    * Allows you to control how the pdf is returned to the user, most of the time in CakePHP you probably want the string

trunk/app/views/vclassrooms/admin_export.ctp

@@ -1 +1 @@
 <?php
-//();
-//$fpdf->SetFont('Arial','B',16);
-     $fpdf->setData($data);
-     $fpdf->setData('Secind data');
-echo $fpdf->fpdfOutput('class_report.pdf');    
+ //$tmp = null;
+ $position = 40;
+
+ foreach ($data as $u):
+
+    $fpdf->newPage();
+
+    foreach ($u['tests'] as $te):  
+         $fpdf->setData($te['Test']['title'] . ', Percentage '.$te['Result']['percentage'].'%');
+    endforeach;
+ 
+    foreach ($u['treasures'] as $t):
+      $fpdf->setData($t['Treasure']['title'] . ', Points '.$t['ResultTreasure']['points']);
+    endforeach;
+   
+    foreach ($u['participations'] as $p):
+      $fpdf->setData($p['Participation']['title'] . ', Points ' . $p['Participation']['points']);
+    endforeach;
+
+    foreach ($u['webquests'] as $w):
+      $fpdf->setData($w['Webquest']['title'] . ', Points ' . $w['Webquest']['points']);
+    endforeach;
+ 
+ endforeach;    
+
+ echo $fpdf->fpdfOutput('class_report.pdf');    
 ?>