Exemplo n.º 1
0
 /**
  * 
  * @param unknown_type $from
  * @param unknown_type $to
  */
 private function _exportBalanceAccountStatus($from, $to)
 {
     $begin_row = $this->_row;
     $active_sheet = $this->getDocument()->getActiveSheet();
     /* ------------------- EXPORTATION OF THE ACCOUNTS STATUS --------------------------*/
     $positive_accounts = Statistics::getPositiveAccounts();
     $negative_accounts = Statistics::getNegativeAccounts();
     $total_accounts['value'] = $positive_accounts['value'] + $negative_accounts['value'];
     $total_accounts['number'] = $positive_accounts['number'] + $negative_accounts['number'];
     /*------------------------------ TITLE -----------------------------*/
     $active_sheet->setCellValueByColumnAndRow(0, $this->_row, $this->_translate('Accounts status'));
     $active_sheet->mergeCells('A' . $this->_row . ':C' . $this->_row);
     $active_sheet->getStyle('A' . $this->_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
     $active_sheet->getStyle('A' . $this->_row)->getFont()->setBold(true);
     $active_sheet->getStyle('A' . $this->_row)->getFill()->applyFromArray(array('type' => PHPExcel_Style_Fill::FILL_SOLID, 'startcolor' => array('rgb' => '808080'), 'endcolor' => array('rgb' => '808080')));
     /*----------------------------- END TITLE ---------------------------*/
     $this->nextLine();
     /*------------------------------ HEADER -----------------------------*/
     $active_sheet->setCellValueByColumnAndRow(0, $this->_row, $this->_translate('Monetary accounts'));
     $active_sheet->setCellValueByColumnAndRow(1, $this->_row, $this->_translate('Value'));
     $active_sheet->setCellValueByColumnAndRow(2, $this->_row, $this->_translate('Number of accounts'));
     $active_sheet->getStyle('A' . $this->_row . ':C' . $this->_row)->getFont()->setBold(true);
     $active_sheet->getStyle('B' . $this->_row . ':C' . $this->_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
     /*----------------------------- END HEADER ---------------------------*/
     $this->nextLine();
     /*------------------------------ BODY -----------------------------*/
     $active_sheet->setCellValueByColumnAndRow(0, $this->_row, $this->_translate('Positives'));
     $active_sheet->setCellValueByColumnAndRow(1, $this->_row, $positive_accounts['value']);
     $active_sheet->setCellValueByColumnAndRow(2, $this->_row, $positive_accounts['number']);
     $active_sheet->getStyle('B' . $this->_row . ':C' . $this->_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
     $this->nextLine();
     $active_sheet->setCellValueByColumnAndRow(0, $this->_row, $this->_translate('Negatives'));
     $active_sheet->setCellValueByColumnAndRow(1, $this->_row, $negative_accounts['value']);
     $active_sheet->setCellValueByColumnAndRow(2, $this->_row, $negative_accounts['number']);
     $active_sheet->getStyle('B' . $this->_row . ':C' . $this->_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
     /*----------------------------- END BODY ---------------------------*/
     $this->nextLine();
     /*------------------------------ FOOTER -----------------------------*/
     $active_sheet->setCellValueByColumnAndRow(0, $this->_row, $this->_translate('Total'));
     $active_sheet->setCellValueByColumnAndRow(1, $this->_row, $total_accounts['value']);
     $active_sheet->setCellValueByColumnAndRow(2, $this->_row, $total_accounts['number']);
     $active_sheet->getStyle('A' . $this->_row . ':C' . $this->_row)->getFont()->setBold(true);
     $active_sheet->getStyle('B' . $this->_row . ':C' . $this->_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
     $active_sheet->getStyle('A' . $this->_row . ':C' . $this->_row)->getFill()->applyFromArray(array('type' => PHPExcel_Style_Fill::FILL_SOLID, 'startcolor' => array('rgb' => 'C0C0C0'), 'endcolor' => array('rgb' => 'C0C0C0')));
     /*----------------------------- END FOOTER ---------------------------*/
     $active_sheet->getStyle('A' . ($begin_row + 1) . ':C' . $this->_row)->applyFromArray(array('borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN, 'color' => array('argb' => PHPExcel_Style_Color::COLOR_BLACK)))));
 }
Exemplo n.º 2
0
 /**
  * 
  * @param sfWebRequest $request
  */
 public function executeBalance(sfWebRequest $request, $xhr = true)
 {
     $this->userCulture = $this->getUser()->getCulture();
     $from = $request->getParameter('from');
     $to = $request->getParameter('to');
     $this->from = $from;
     $this->to = $to;
     $this->xhr = $xhr;
     $this->currency_symbol = ImputationDefaultValues::getDefaultCurrencySymbol();
     $this->positive_accounts = Statistics::getPositiveAccounts();
     $this->negative_accounts = Statistics::getNegativeAccounts();
     $total_accounts['value'] = $this->positive_accounts['value'] + $this->negative_accounts['value'];
     $total_accounts['number'] = $this->positive_accounts['number'] + $this->negative_accounts['number'];
     $this->total_accounts = $total_accounts;
     $this->methods_of_payments_values = Statistics::getTotalValuesByMethodOfPayment($from, $to);
     $this->acts_values = Statistics::getValuesByAct($from, $to);
 }