Mese: Aprile 2008

class Invoices_Manager extends P4A
{
/**
* @var P4A_Menu
*/
public $menu = null;
/**
* @var P4A_DB_Source
*/
public $clienti = null;
 
public function __construct()
 {
  parent::__construct();
  $this->setTitle("Gestione Fatture");
  // Menu
  $this->build("p4a_menu", "menu");
  $this->menu->addItem("anagrafiche", "Anagrafiche");
  $this->menu->items->anagrafiche->addItem("ditta")
   ->implement("onclick", $this, "menuClick");
  $this->menu->items->anagrafiche->addItem("clienti")
   ->implement("onclick", $this, "menuClick");
  $this->menu->addItem("fatture", "Fatture")
   ->implement("onclick", $this, "menuClick");
  $this->menu->addItem("report", "Report");
  $this->menu->items->report->addItem("lista", "Lista fatture")
   ->implement("onclick", $this, "menuClick");
 
  // Data sources
  $this->build("p4a_db_source", "clienti")
   ->setTable("clienti")
   ->addOrder("Ragione_sociale")
   ->setPageLimit(5)
   ->load();
  // Primary action
  $this->openMask("P4A_Default_Mask");
}
 
 public function menuClick()
 {
  $this->openMask($this->active_object->getName());
 }
}

class fatture extends P4A_Base_Mask
{
 public $fs_search = null;
 public $txt_search = null;
 public $cmd_search = null;
 public $toolbar = null;
 public $table = null;
 public $fs_details = null;
 
 public function __construct()
 {
  parent::__construct();
  $p4a = P4A::singleton();
  $this->setTitle('Gestione fatture');
  // DB Source
  $this->build("p4a_db_source", "fatture")
    ->setTable("fatture")
    ->addJoin("clienti", "fatture.ID_cliente = clienti.ID",
      array('Ragione_sociale'=>'cliente'))
    ->addOrder("Num_fattura",P4A_ORDER_DESCENDING)
    ->setPageLimit(5)
    ->load();
  $this->setSource($this->fatture);
  $this->firstRow();
  //Create detail source. Detail table should be in a different class
  $dett_prestazioni = $this->build("prestazioni", "dett_prestazioni");
  $dett_prestazioni->source->addFilter("ID_fattura = ?",
  $this->fatture->fields->ID);
  // Customizing fields properties
  $this->setFieldsProperties();
  // Search Fieldset
  $this->build("p4a_field", "txt_search")
   ->setLabel("Numero fattura")
   ->implement("onreturnpress", $this, "search");
  $this->build("p4a_button", "cmd_search")
   ->setLabel("Cerca")
   ->implement("onClick", $this, "search");
  $this->build("p4a_fieldset", "fs_search")
   ->setLabel("Ricerca per numero fattura")
   ->setWidth(800)
   ->anchor($this->txt_search)
   ->anchorLeft($this->cmd_search);
  // Build Tab pane
  $tab_pane = $this->build("p4a_tab_pane","tab_pane");
  // Toolbar
  $this->build("p4a_simple_toolbar", "toolbar")
   ->setMask($this);
  // Hide original print screen button
  $this->toolbar->buttons->print->setInvisible();
  // Add new button to print pdf
  $this->toolbar->addButton('stampafattura','print');
  // Intercept onClick and override with our own method
  $this->intercept($this->toolbar->buttons->stampafattura,
    'onClick','print_doc');
  // Join toolbar with this mask
  // Table
  $this->build("p4a_table", "table")
   ->setWidth(700)
   ->setSource($this->fatture)
   ->setVisibleCols(array("Num_fattura", "Data_fattura", "cliente",
     "Pagamento", "Pagata"))
   ->showNavigationBar();
  $this->table->cols->Num_fattura->setLabel("N. fattura");
  //Fieldset con l'elenco dei campi
  $this->build("p4a_fieldset", "fs_details")
   ->setLabel("Dati fattura")
   ->setWidth(700)
   ->anchor($this->fields->Num_fattura)
   ->anchorLeft($this->fields->Data_fattura)
   ->anchor($this->fields->ID_cliente)
   ->anchorLeft($this->fields->Pagamento)
   ->anchor($this->fields->Pagata);
   $this
    ->setRequiredField("Num_fattura")
    ->setRequiredField("Data_fattura");
   // events onChange
   // Intercept change page on the tab pane
   $tab_pane->implement("afterSetActivePage",$this,"ChangePage");
   // tabpane settings
   $tab_pane->setWidth(750); 
   $tab1 = $tab_pane->pages->build("p4a_frame","tab1"); 
   $tab2 = $tab_pane->pages->build("p4a_frame","tab2"); 
   $tab1->setLabel("Fatture");
   $tab2->setLabel("Dettaglio fattura");
   // anchor tab pane
   $this->frame->anchor($tab_pane);
   // tab1 - Anchor master table
   $tab1
    ->anchor($this->fs_search)
    ->anchor($this->table)
    ->anchor($this->fs_details)
    ->newRow();
   // tab2 - Anchor detail table
   $tab2
    ->anchor($dett_prestazioni->toolbar)
    ->anchor($dett_prestazioni->table)
    ->anchor($dett_prestazioni->fs_details);
   // Display
   $this
    ->display("menu", P4A::singleton()->menu)
    ->display("top", $this->toolbar)
    ->setFocus($this->fields->Num_fattura);
  }
 private function setFieldsProperties()
 {
  $this->fields->ID_cliente
   ->setType("select")
   ->setSource(P4A::singleton()->clienti)
   ->setSourceDescriptionField("Ragione_sociale")
   ->setLabel("Cliente")
   ->setWidth(200);
  }
 public function search()
 {
  $value = $this->txt_search->getSQLNewValue();
  $this->fatture
   ->setWhere(P4A_DB::singleton()->getCaseInsensitiveLikeSQL("Num_fattura",
    "%{$value}%"))
   ->firstRow();
  if (!$this->fatture->getNumRows()) {
   $this->warning("Nessuna fattura trovata");
   $this->fatture->setWhere(null);
   $this->fatture->firstRow();
  }
 }
 public function ChangePage()
 {
  $newpage = $this->tab_pane->getActivePageName();
  switch ($newpage)
   {
    case "tab1":
     // If display master, enable all toolbar buttons
     $this->toolbar->buttons->new->enable();
     $this->toolbar->buttons->save->enable();
     $this->toolbar->buttons->delete->enable();
     $this->toolbar->buttons->print->enable();
     //  force to redesign toolbar
     $this->toolbar->redesign();
     break;
    case "tab2":
     // If display detail, disable some master table buttons
     $this->toolbar->buttons->new->disable();
     $this->toolbar->buttons->save->disable();
     $this->toolbar->buttons->delete->disable();
     $this->toolbar->buttons->print->disable();
     //  force to redesign toolbar
     $this->toolbar->redesign();
     // Go to first row and fill fieldset
     $this->setFocus($this->dett_prestazioni->fields->Descrizione);
     $this->dett_prestazioni->firstRow();
     break;
   }
 }
 public function print_doc()
 // Function to print selected invoice with ezPdf class
 {
  require("class.ezpdf.php");
  $pdf = new Cezpdf("a4","portrait");
  // Select font family
  $pdf->selectFont($_SERVER["DOCUMENT_ROOT"].P4A_APPLICATION_PATH.
   "/libraries/fonts/Helvetica.afm");
  // Define some usefull styling tags (like html)
  $tmp = array(
    "b"=>"Helvetica-Bold.afm"
    ,"i"=>"Helvetica-Oblique.afm"
    ,"bi"=>"Helvetica-BoldOblique.afm"
    ,"ib"=>"Helvetica-BoldOblique.afm"
    ,"bb"=>"Helvetica-Bold.afm");
  $pdf->setFontFamily("Helvetica.afm",$tmp);
  $db = p4a_db::singleton();
  // Get from db header information
  $headerpdf=$db->getAll("SELECT Ragione_sociale, Indirizzo,
                     CONCAT('Tel: ',Telefono),
                     CONCAT('Fax: ',Fax),
                     CONCAT('Email: ',email),
                     CONCAT('C.F.: ',CF),
                     CONCAT('P.IVA: ',PIVA),
                     CONCAT('Banca: ',Dati_bancari)
                     FROM intestazione");
  // Define xy init set up values
  $x=65;
  $y=820;
  $pdf->ezSetY($y);
  // Cycle through fields and print header
  foreach($headerpdf[0] as $key => $value){
   $pdf->ezSetY($y);
   $pdf->ezText($value,10,array("aleft"=>$x,"justification"=>"left"));
   $y-=10;
  }
  // Retrieve actual customer's id
  $actualIdCliente = $this->fatture->fields->ID_cliente->getNewValue();
  // Get customer's data from db
  $invoiceData = $db->getAll("SELECT Ragione_sociale, indirizzo,
                         CONCAT_WS(' - ', CAP, Citta, Provincia),
                         PIVA, CF
                         FROM clienti
                         WHERE ID = '$actualIdCliente'");
  $y-=20;
  $pdf->ezSetY($y);
  $pdf->ezText("Spett.le ",10,array('aleft'=>'300',
                  'justification'=>'left'));
  $x=350;
  // Cycle through fields and print data
  foreach($invoiceData[0] as $key => $value){
   $pdf->ezSetY($y);
   $pdf->ezText($value,10,array('aleft'=>$x,'justification'=>'left'));
   $y-=10;
  }
  // Print invoice number and date (we have it!)
  $numDateInvoice = "Fattura n. <b>".
                     $this-&gt;fields-&gt;Num_fattura-&gt;getValue().
                     "</b> del <b><i>".
                     $this-&gt;fields-&gt;Data_fattura-&gt;getNewValue().
                     "</i></b>";
  $x=65;
  $y-=20;
  $pdf-&gt;ezSetY($y);
  $pdf-&gt;ezText($numDateInvoice,10,array('aleft'=&gt;$x,
                  'justification'=&gt;'left'));
  // Retrieve actual invoice id
  $actualIdFattura = $this-&gt;fatture-&gt;fields-&gt;ID-&gt;getNewValue();
  // Get invoice detail items from db
  $detInvoiceData = $db-&gt;getAll("SELECT Descrizione, Importo,
                            CONCAT(Aliquota_IVA,'%')
                            FROM prestazioni
                            WHERE ID_Fattura = '$actualIdFattura'");
  // Print header fields name
  $y-=30;
  $pdf-&gt;ezSetY($y);
  $pdf-&gt;ezText("Descrizione",12,array('aleft'=&gt;'65',
           'justification'=&gt;'left'));
  $pdf-&gt;ezSetY($y);
  $pdf-&gt;ezText("Importo",12,array('aleft'=&gt;'415', 'aright'=&gt;'485',
           'justification'=&gt;'right'));
  $pdf-&gt;ezSetY($y);
  $pdf-&gt;ezText("IVA",12,array('aleft'=&gt;'515',
           'justification'=&gt;'left'));
  $y-=15;
  $pdf-&gt;line(65,$y,540,$y);
  $x=65;
  $y-=10;
  // Cycle through records and fields and print data
  foreach($detInvoiceData as $row){
   foreach($row as $key =&gt; $value){
    $pdf-&gt;ezSetY($y);
    if($key=="Importo"){
     //format price with 2 decimals
     $formattedValue = sprintf("%01.2f", $value);
     $pdf-&gt;ezText($formattedValue,10,array('aleft'=&gt;$x,
              'aright'=&gt;$x+70,'justification'=&gt;'right'));
    }
    else{
     $pdf-&gt;ezText($value,10,array('aleft'=&gt;$x,
              'justification'=&gt;'left'));
    }
    if($x==65)
     $x+=350;
    else
     $x+=100;
   }
   $x=65;
   $y-=10;
  }
  // Get total amount price and tax with an aggregation query
  $totPriceInvoice = $db-&gt;getAll( "SELECT fatture.ID,
     SUM( prestazioni.importo) AS TotaleImponibile,
     SUM( prestazioni.importo * (prestazioni.Aliquota_IVA /100)) AS TotaleIVA,
     SUM(prestazioni.importo * (1 + (prestazioni.Aliquota_IVA /100))) AS Totale
     FROM fatture
     RIGHT JOIN prestazioni ON fatture.ID = prestazioni.ID_fattura
     GROUP BY fatture.ID HAVING fatture.ID='$actualIdFattura'");
  $y-=25;
  $pdf-&gt;line(65,$y,540,$y);
  // Print a summary with total price without tax, total tax,
  // and total price including tax.
  $y-=50;
  $pdf-&gt;ezSetY($y);
  $pdf-&gt;ezText('<b>Totale imponibile</b>',
                  10,array('aleft'=&gt;'300',
                  'justification'=&gt;'left'));
  $pdf-&gt;ezSetY($y);
  $formattedValue = sprintf("%01.2f",$totPriceInvoice[0]['TotaleImponibile']);
  $pdf-&gt;ezText("<b>".$formattedValue."</b>",10,
           array('aleft'=&gt;'415','aright'=&gt;'485',
           'justification'=&gt;'right'));
  $y-=12;
  $pdf-&gt;ezSetY($y);
  $pdf-&gt;ezText('<b>Totale IVA</b>',10,array('aleft'=&gt;'300',
           'justification'=&gt;'left'));
  $pdf-&gt;ezSetY($y);
  $formattedValue = sprintf("%01.2f",$totPriceInvoice[0]['TotaleIVA']);
  $pdf-&gt;ezText("<b>".$formattedValue."</b>",10,
           array('aleft'=&gt;'415','aright'=&gt;'485',
           'justification'=&gt;'right'));
  $y-=12;
  $pdf-&gt;ezSetY($y);
  $pdf-&gt;ezText('<b>Totale fattura</b>',10,
           array('aleft'=&gt;'300',
           'justification'=&gt;'left'));
  $pdf-&gt;ezSetY($y);
  $formattedValue = sprintf("%01.2f",$totPriceInvoice[0]['Totale']);
  $pdf-&gt;ezText("<b>".$formattedValue."</b>",10,
           array('aleft'=&gt;'415','aright'=&gt;'485',
           'justification'=&gt;'right'));
  // Send pdf to file
  $filename = 'fattura.pdf';
  $pdfcode = $pdf-&gt;output(1); // data stream without header
  P4A_Output_File($pdfcode,$filename);
 }
}