Esempio n. 1
0
 public function getCompanyColl()
 {
     $companyColl = new \crm\CompanyColl($this->db);
     $companyColl->setCompanyId($this->data['partIVA']);
     $companyColl->loadAll();
     return $companyColl;
 }
Esempio n. 2
0
 public function getCompanyColl()
 {
     $companyColl = new \crm\CompanyColl($this->db);
     $companyColl->setExponentId($this->data['codFisc']);
     $companyColl->loadAll();
     return $companyColl;
 }
Esempio n. 3
0
 $objPHPExcel->getProperties()->setLastModifiedBy('Abbrevia');
 $objPHPExcel->getProperties()->setTitle('Dati aziende');
 $objPHPExcel->getProperties()->setSubject('Dati aziende');
 $objPHPExcel->getProperties()->setDescription('Dati aziende');
 $objPHPExcel->setActiveSheetIndex(0);
 $objPHPExcel->getActiveSheet()->setTitle('Dati aziende');
 $request = array();
 foreach ($_REQUEST as $key => $value) {
     if (substr($value, 0, 1) == '{') {
         $request[$key] = json_decode($value, true);
     } else {
         $request[$key] = $value;
     }
 }
 $companyColl = new \crm\CompanyColl($GLOBALS['db']);
 $companyColl->loadAll($request);
 $r = 1;
 foreach ($companyColl->getItems() as $company) {
     $data = $company->getData();
     if ($r == 1) {
         $c = 0;
         foreach ($data as $etichetta => $valore) {
             $objPHPExcel->getActiveSheet()->setCellValueExplicitByColumnAndRow($c++, $r, $etichetta, \PHPExcel_Cell_DataType::TYPE_STRING);
         }
         $objPHPExcel->getActiveSheet()->setCellValueExplicitByColumnAndRow($c++, $r, 'Esponenti', \PHPExcel_Cell_DataType::TYPE_STRING);
         $r++;
     }
     $c = 0;
     foreach ($data as $valore) {
         $objPHPExcel->getActiveSheet()->setCellValueExplicitByColumnAndRow($c++, $r, $valore, \PHPExcel_Cell_DataType::TYPE_STRING);
     }