Пример #1
0
 /**
  * 
  */
 public function exportToExcelSentSamplesAction()
 {
     $params = $this->getRequest()->getParams();
     $sampleShipmentQuery = SampleShipmentQuery::create()->addDescendingOrderBy(SampleShipment::ID_SAMPLE_SHIPMENT)->filter($params)->find();
     $i = 1;
     while ($sampleShipment = $sampleShipmentQuery->read()) {
         $content[$i] = array('Guide', $sampleShipment->getGuide(), '', '', '', '', '');
         $i++;
         $content[$i] = array('Courier', $sampleShipment->getCourier(), '', '', '', '', '');
         $i++;
         $content[$i] = array('Shipment Date', $sampleShipment->getShipmentDate(), '', '', '', '', '');
         $i++;
         $content[$i] = array('Notes', $sampleShipment->getNote(), '', '', '', '', '');
         $i++;
         $content[$i] = array('', '', '', '', '', '', '');
         $i++;
         $content[$i] = array('Id Npd Sheet', 'Description', 'Supplier', 'Color', 'Quantity', 'Cost', 'Ammount');
         $i++;
         $sampleQuery = SampleQuery::create()->whereAdd(Sample::ID_SAMPLE_SHIPMENT, $sampleShipment->getIdSampleShipment())->find();
         while ($sample = $sampleQuery->read()) {
             $npd = NpdSheetQuery::create()->findByPK($sample->getIdNpdSheet());
             if (ColorQuery::create()->whereAdd(Color::ID_COLOR, $sample->getIdColor())->count()) {
                 $color = ColorQuery::create()->findByPK($sample->getIdColor());
             } else {
                 $color = new Color();
                 $color->setName('Any');
             }
             $content[$i] = array($sample->getIdNpdSheet(), $npd->getDescription(), $sample->getIdSupplier(), $color->getName(), $sample->getQuantity(), '$' . number_format($sample->getCost(), 4) . $npd->getIdCurrency(), '$' . number_format($sample->getTotalAmmount(), 4) . $npd->getIdCurrency());
             $i++;
         }
         $content[$i] = array('', '', '', '', '', 'Total', '$' . number_format($sampleQuery->getTotalAmmount(), 4) . $npd->getIdCurrency());
         $i++;
         $content[$i] = array('', '', '', '', '', '', '');
         $i++;
         $content[$i] = array('', '', '', '', '', '', '');
         $i++;
     }
     $header = array('', '', '', '', '', '', '');
     $tableColumnsWidth = array('small', 'medium', 'small', 'small', 'small', 'medium', 'medium');
     // 		$content
     $title = $this->i18n->_('Sent Samples Report');
     $fileName = $this->i18n->_('sent_samples_report');
     $report = new SimpleListReport();
     $report->setTableTitle($title);
     $report->setTableHeaders($header);
     $report->setTableContent($content);
     $report->setTableColumnsWidth($tableColumnsWidth);
     $report->setFilename($fileName);
     $report->createSpreadsheet();
 }
Пример #2
0
 public function exportToExcelAction()
 {
     $params = $this->getRequest()->getParams();
     $incoterms = IncotermQuery::create()->filter($params)->find();
     $report = new SimpleListReport();
     $i = 0;
     while ($incoterm = $incoterms->read()) {
         $content[$i][] = $incoterm->getIdIncoterm();
         $content[$i][] = $incoterm->getName();
         $content[$i][] = $incoterm->getStatusName();
         $i++;
     }
     $headers = array('Id Incoterm', 'Name', 'Status');
     $tableTitle = $this->i18n->_('Incoterm Report');
     $filename = 'incoterm_report';
     $report->setTableContent($content);
     $report->setTableHeaders($headers);
     $report->setTableTitle($tableTitle);
     $report->setFilename($filename);
     $report->createSpreadsheet();
 }
Пример #3
0
 /**
  *
  * Enter description here ...
  */
 public function exportToExcelAction()
 {
     $params = $this->getRequest()->getParams();
     $params['name'] = urldecode($this->getRequest()->getParam('name'));
     $params['code'] = urldecode($this->getRequest()->getParam('code'));
     $colors = ColorQuery::create()->filter($params)->find();
     if (!$colors->isEmpty()) {
         $i = 1;
         while ($color = $colors->read()) {
             $data[$i] = array($color->getCode(), $color->getName(), $color->getStatusName());
             $i++;
         }
         $header = array($this->i18n->_('Code'), $this->i18n->_('Name'), $this->i18n->_('Status'));
         $title = $this->i18n->_('Colors Report');
         $fileName = $this->i18n->_('Colors_report');
         $report = new SimpleListReport();
         $report->setTableTitle($title);
         $report->setTableHeaders($header);
         $report->setTableContent($data);
         $report->setFilename($fileName);
         $report->createSpreadsheet();
     } else {
         $filter = $this->createFilterForUrl($params);
         $this->setFlash("error", $this->i18n->_('No records'));
         $this->_redirect('color/list');
     }
 }
Пример #4
0
 public function exportToExcelAction()
 {
     $params = $this->getRequest()->getParams();
     if (!empty($params['username'])) {
         $params['username'] = '******' . $params['username'] . '%';
     }
     $query = UserQuery::create()->filter($params)->find();
     $headers = array('ID', 'Access Role', 'Username', 'Name', 'Second Name', 'Last Name', 'Status');
     foreach ($query as $key => $object) {
         $content[$key][] = $object->getIdUser();
         $content[$key][] = AccessRoleQuery::create()->findByPK($object->getIdAccessRole())->getName();
         $content[$key][] = utf8_encode($object->getUsername());
         $content[$key][] = utf8_encode($object->getName());
         $content[$key][] = utf8_encode($object->getSecondName());
         $content[$key][] = utf8_encode($object->getLastName());
         $content[$key][] = $object->getStatusName();
     }
     $title = $this->i18n->_('Users Report');
     $filename = 'users_report';
     $report = new SimpleListReport();
     $report->setTableHeaders($headers);
     $report->setTableContent($content);
     $report->setTableTitle($title);
     $report->setFilename($filename);
     // 		$report->setTableColumnsWidth($columsWidth);
     $report->createSpreadsheet();
 }
Пример #5
0
 /**
  * @author joseluis
  */
 public function exportToExcelAction()
 {
     $params = $this->getRequest()->getParams();
     $params['name'] = '%' . $params['name'] . '%';
     $values = RespondentQuery::create()->filter($params)->find();
     $report = new SimpleListReport();
     $i = 0;
     $content = array();
     while ($value = $values->read()) {
         $content[$i][] = $value->getIdRespondent();
         $content[$i][] = $value->getName();
         $content[$i][] = $value->getCompanyName();
         $content[$i][] = SapSupplier::$customerProfile[$value->getProfile()] ? SapSupplier::$customerProfile[$value->getProfile()] : $this->i18n->_('Without Profile');
         $content[$i][] = $value->getGenders();
         $i++;
     }
     $headers = array('Id', 'Name', 'Customer Number', 'Profile', 'Gender');
     $tableTitle = $this->i18n->_('Focus Group Participants Report');
     $filename = 'focus_group_participants_report';
     $report->setTableContent($content);
     $report->setTableHeaders($headers);
     $report->setTableTitle($tableTitle);
     $report->setFilename($filename);
     $report->createSpreadsheet();
 }
 /**
  *
  */
 public function exportToExcelAction()
 {
     $params = $this->getRequest()->getParams();
     $customsCodes = CustomsTariffCodeQuery::create()->filter($params)->find();
     //die(print_r($post));
     if (!$customsCodes->isEmpty()) {
         $i = 1;
         while ($customsCode = $customsCodes->read()) {
             $data[$i] = array($customsCode->getCode(), $customsCode->getName(), $customsCode->getPercent(), $customsCode->getStatusName());
             $i++;
         }
         $header = array($this->i18n->_('Code'), $this->i18n->_('Description'), $this->i18n->_('Percent'), $this->i18n->_('Status'));
         $title = $this->i18n->_('Custom Codes');
         $fileName = $this->i18n->_('Custom Codes Report');
         $tableColumnsWidth = array('mini');
         $report = new SimpleListReport();
         $report->setTableTitle($title);
         $report->setTableHeaders($header);
         $report->setTableContent($data);
         $report->setFilename($fileName);
         $report->setTableColumnsWidth($tableColumnsWidth);
         $report->createSpreadsheet();
     } else {
         $filter = $this->createFilterForUrl($post);
         $this->setFlash("error", $this->i18n->_('No records'));
         $this->_redirect('customs-tariff-code/list');
     }
 }
Пример #7
0
 /**
  *
  */
 public function exportToExcelAction()
 {
     $post['status'] = $this->getRequest()->getParam('status');
     $post['name'] = "%" . utf8_decode($this->getRequest()->getParam('name')) . "%";
     $forwarders = ForwarderQuery::create()->filter($post)->find();
     if (!$forwarders->isEmpty()) {
         $i = 1;
         while ($forwarder = $forwarders->read()) {
             $data[$i] = array($forwarder->getIdForwarder(), $forwarder->getName(), $forwarder->getStatusName());
             $i++;
         }
         $header = array($this->i18n->_('ID'), $this->i18n->_('Name'), $this->i18n->_('Status'));
         $title = $this->i18n->_('Forwarders Report');
         $fileName = $this->i18n->_('Forwarders_report');
         $tableColumnsWidth = array('mini');
         $report = new SimpleListReport();
         $report->setTableTitle($title);
         $report->setTableHeaders($header);
         $report->setTableContent($data);
         $report->setFilename($fileName);
         $report->setTableColumnsWidth($tableColumnsWidth);
         $report->createSpreadsheet();
     } else {
         $filter = $this->createFilterForUrl($post);
         $this->setFlash("warning", $this->i18n->_('No records were found'));
         $this->_redirect('forwarder/list');
     }
 }
Пример #8
0
 /**
  *
  */
 public function exportToExcelAction()
 {
     $post = $this->getRequest()->getParams();
     $inspectors = InspectorQuery::create()->filter($post)->find();
     if (!$inspectors->isEmpty()) {
         $i = 1;
         while ($inspector = $inspectors->read()) {
             $person = InspectorQuery::create()->innerJoinPerson()->addColumn('Person.*')->whereAdd('Person.id_person', $inspector->getIdPerson())->findOne();
             $data[$i] = array($inspector->getUsername(), $person->getName(), $person->getLastName(), $person->getSecondName(), $inspector->getStatusName());
             $i++;
         }
         $header = array($this->i18n->_('Username'), $this->i18n->_('Name'), $this->i18n->_('Last Name'), $this->i18n->_('Second Name'), $this->i18n->_('Status'));
         $title = $this->i18n->_('Inspector Report');
         $fileName = $this->i18n->_('Inspector_report');
         $report = new SimpleListReport();
         $report->setTableTitle($title);
         $report->setTableHeaders($header);
         $report->setTableContent($data);
         $report->setFilename($fileName);
         $report->createSpreadsheet();
     } else {
         $filter = $this->createFilterForUrl($post);
         $this->setFlash("warning", $this->i18n->_('No records found'));
         $this->_redirect('inspector/list');
     }
 }
Пример #9
0
 /**
  * 
  */
 public function exportToExcelAction()
 {
     $params = $this->getRequest()->getParams();
     $productGroupQuery = ProductGroupQuery::create()->filter($params)->find();
     $headers = array('Name', 'Code', 'Status');
     foreach ($productGroupQuery as $key => $productGroup) {
         $content[$key][] = utf8_encode($productGroup->getName());
         $content[$key][] = $productGroup->getCode();
         $content[$key][] = $productGroup->getStatusName();
     }
     $title = $this->i18n->_('Product Groups Report');
     $filename = 'product_groups_report';
     $report = new SimpleListReport();
     $report->setTableHeaders($headers);
     $report->setTableContent($content);
     $report->setTableTitle($title);
     $report->setFilename($filename);
     $report->createSpreadsheet();
 }
Пример #10
0
 /**
  *
  */
 public function exportToExcelAction()
 {
     $params = $this->getRequest()->getParams();
     if (!empty($params['name'])) {
         $params['name'] = '%' . $params['name'] . '%';
     }
     $query = WarehouseQuery::create()->filter($params)->find();
     $report = new SimpleListReport();
     $columnsWidth = array('', 'biggest', '');
     $headers = array('ID', 'Name', 'Status');
     foreach ($query as $key => $object) {
         $content[$key][] = $object->getIdWarehouse();
         $content[$key][] = utf8_encode($object->getName());
         $content[$key][] = $object->getStatusName();
     }
     $title = $this->i18n->_('Warehouses Report');
     $filename = 'warehouses_report';
     $report->setTableHeaders($headers);
     $report->setTableContent($content);
     $report->setTableTitle($title);
     $report->setFilename($filename);
     $report->setTableColumnsWidth($columnsWidth);
     $report->createSpreadsheet();
 }
 public function exportToExcelAction()
 {
     $report = new SimpleListReport();
     $params = $this->getRequest()->getParams();
     $productPrintingAreas = ProductPrintingAreaQuery::create()->filter($params)->find();
     $i = 0;
     $tableContent = array();
     while ($productPrintingArea = $productPrintingAreas->read()) {
         $productionTimePrintingTechniqueQuery = ProductionTimePrintingTechniqueQuery::create()->whereAdd(ProductionTimePrintingTechnique::ID_PRODUCT_PRINTING_AREA, $productPrintingArea->getIdProductPrintingArea())->find();
         $j = 1;
         while ($productionTimePrintingTechnique = $productionTimePrintingTechniqueQuery->read()) {
             switch ($j) {
                 case 1:
                     $id_printing_technique = $productionTimePrintingTechnique->getIdPrintingTechnique();
                     $max_area = $productionTimePrintingTechnique->getMaxArea();
                     $max_inks = $productionTimePrintingTechnique->getMaxInks();
                     break;
                 case 2:
                     $id_printing_technique_alternative = $productionTimePrintingTechnique->getIdPrintingTechnique();
                     $max_area_alternative = $productionTimePrintingTechnique->getMaxArea();
                     $max_inks_alternative = $productionTimePrintingTechnique->getMaxInks();
                     break;
             }
             if ($j == 2) {
                 break;
             }
             $j++;
         }
         $product = ProductQuery::create()->findByPK($productPrintingArea->getIdProduct());
         $tableContent[$i][] = $productPrintingArea->getIdProduct();
         $tableContent[$i][] = $product->getKeyMother();
         $tableContent[$i][] = $product->getItemName();
         $tableContent[$i][] = $productPrintingArea->getIdEShop();
         $tableContent[$i][] = $id_printing_technique;
         $tableContent[$i][] = $productPrintingArea->getIncludedLogos();
         $tableContent[$i][] = $productPrintingArea->getIdPrintingSize();
         $tableContent[$i][] = $max_inks;
         $tableContent[$i][] = $id_printing_technique_alternative;
         $tableContent[$i][] = $max_inks_alternative;
         $tableContent[$i][] = $max_area;
         $tableContent[$i][] = $max_area_alternative;
         $tableContent[$i][] = $productPrintingArea->getPrintingOrder();
         $i++;
     }
     $tableHeaders = array('SKU', 'Item', 'Item Name', 'Id E-Shop', 'Printing Technique', 'Included Logos', 'Surface', 'Max Inks', 'Printing Technique Alternative', 'Max Inks Alternative', 'Max Area', 'Max Area Alternative', 'Printing Order');
     $report->setTableTitle('Product Printing Area Report');
     $report->setTableHeaders($tableHeaders);
     $report->setTableContent($tableContent);
     $report->setFilename('product_printing_area_report');
     $report->createSpreadsheet();
     die;
 }
Пример #12
0
 public function exportToExcelPendingProductAction()
 {
     $post['id_product_group'] = urldecode($this->getRequest()->getParam('id_product_group'));
     $post['reference'] = urldecode($this->getRequest()->getParam('reference'));
     $post['status'] = $this->getRequest()->getParam('status');
     $npdsheets = NpdSheetQuery::create()->filter($post)->addDescendingOrderBy(NpdSheet::ID_NPD_SHEET)->whereAdd(NpdSheet::STATUS, NpdSheet::$Status['Pending Product'])->find();
     if (!$npdsheets->isEmpty()) {
         $i = 1;
         while ($npdsheet = $npdsheets->read()) {
             $productGroup = ProductGroupQuery::create()->whereAdd(ProductGroup::ID_PRODUCT_GROUP, $npdsheet->getIdProductGroup())->findOne();
             $family = FamilyQuery::create()->whereAdd(Family::ID_FAMILY, $npdsheet->getIdFamily())->findOne();
             $subfamily = SubfamilyQuery::create()->whereAdd(Subfamily::ID_SUBFAMILY, $npdsheet->getIdSubfamily())->findOne();
             $npdSupplier = NpdSheetSupplierQuery::create()->innerJoinNpdSheet()->whereAdd('NpdSheetSupplier.id_npd_sheet', $npdsheet->getIdNpdSheet())->find()->getPrimaryKeys();
             if ($npdSupplier) {
                 $authorizedPrice = SupplierBudgetQuery::create()->innerJoinNpdSheetSupplier()->whereAdd('SupplierBudget.id_npd_supplier', $npdSupplier, Criteria::IN)->whereAdd('SupplierBudget.is_authorized', 1)->findOne();
             }
             if (!$authorizedPrice) {
                 $authorizedPrice = new SupplierBudget();
             }
             if (NpdSheetSupplierQuery::create()->whereAdd(NpdSheetSupplier::ID_NPD_SUPPLIER, $authorizedPrice->getIdNpdSupplier())->count()) {
                 $npdSupplier = NpdSheetSupplierQuery::create()->whereAdd(NpdSheetSupplier::ID_NPD_SUPPLIER, $authorizedPrice->getIdNpdSupplier())->findOne();
             } else {
                 $npdSupplier = null;
             }
             if ($npdSupplier) {
                 if (SapSupplierQuery::create()->whereAdd(SapSupplier::ID_SUPPLIER, $npdSupplier->getIdSupplier())->count()) {
                     $supplier = SapSupplierQuery::create()->whereAdd(SapSupplier::ID_SUPPLIER, $npdSupplier->getIdSupplier())->findOne()->getSupplierCardCodeWithCardName();
                 }
             }
             $data[$i] = array($npdsheet->getIdNpdSheet(), $npdsheet->getStatusName(), $npdsheet->getReference(), $npdsheet->getCreationDateAsZendDate()->get('YYYY-MM-dd'), $productGroup->getCode() . '-' . $productGroup->getName(), $family->getCode() . '-' . $family->getName(), $subfamily ? $subfamily->getCode() . '-' . $subfamily->getName() : $this->i18n->_('Not Available'), $npdsheet->getName(), $npdsheet->getPrice(), $authorizedPrice->getPrice(), $supplier ? $supplier : null);
             $i++;
         }
         $header = array($this->i18n->_('ID'), $this->i18n->_('Status'), $this->i18n->_('Reference'), $this->i18n->_('Creation date'), $this->i18n->_('Product Group'), $this->i18n->_('Family'), $this->i18n->_('Subfamily'), $this->i18n->_('Product'), $this->i18n->_('Target Price'), $this->i18n->_('Authorized Price'), $this->i18n->_('Prefered Supplier'));
         $title = $this->i18n->_('NPDs Report');
         $fileName = $this->i18n->_('Npds_report');
         $tableColumnsWidth = array('mini');
         $report = new SimpleListReport();
         $report->setTableTitle($title);
         $report->setTableHeaders($header);
         $report->setTableContent($data);
         $report->setFilename($fileName);
         $report->setTableColumnsWidth($tableColumnsWidth);
         $report->createSpreadsheet();
     } else {
         $filter = $this->createFilterForUrl($post);
         $this->setFlash("warning", $this->i18n->_('No records found'));
         $this->_redirect('npd-sheet/pending-product');
     }
 }
Пример #13
0
 /**
  * 
  */
 public function exportToExcelAction()
 {
     $params = $this->getRequest()->getParams();
     $params['name'] = "%" . $params['name'] . "%";
     $query = PortCustomQuery::create()->filter($params)->find();
     $report = new SimpleListReport();
     $headers = array('Code', 'Name', 'International Code', 'Air', 'Ground', 'Sea', 'Country', 'Status');
     foreach ($query as $key => $object) {
         $content[$key][] = $object->getCode();
         $content[$key][] = utf8_encode($object->getName());
         $content[$key][] = $object->getInternationalCode();
         if ($object->getAir() == 1) {
             $content[$key][] = Symbols::$checkMark;
         } else {
             $content[$key][] = Symbols::$crossMark;
         }
         if ($object->getGround() == 1) {
             $content[$key][] = Symbols::$checkMark;
         } else {
             $content[$key][] = Symbols::$crossMark;
         }
         if ($object->getSea() == 1) {
             $content[$key][] = Symbols::$checkMark;
         } else {
             $content[$key][] = Symbols::$crossMark;
         }
         if (CountryQuery::create()->whereAdd(Country::CODE, $object->getIdCountry())->count()) {
             $content[$key][] = utf8_encode(CountryQuery::create()->findByPK($object->getIdCountry())->getName());
         } else {
             $content[$key][] = $this->i18n->_('Not Available');
         }
         $content[$key][] = $object->getStatusName();
     }
     $title = $this->i18n->_('Ports Report');
     $filename = 'ports_report';
     $report->setTableHeaders($headers);
     $report->setTableContent($content);
     $report->setTableTitle($title);
     $report->setFilename($filename);
     // 		$report->setTableColumnsWidth($columsWidth);
     $report->createSpreadsheet();
 }
Пример #14
0
 /**
  *
  */
 public function exportToExcelAction()
 {
     $params = $this->getRequest()->getParams();
     $query = FolioImportQuery::create()->filter($params)->find();
     $report = new SimpleListReport();
     $headers = array('ID', 'Folio', 'Departure Port', 'Forwarder', 'Destination Port', 'Customs Broker', 'Status');
     $i = 0;
     while ($folioImport = $query->read()) {
         $content[$i][] = $folioImport->getIdFolioImport();
         $content[$i][] = $folioImport->getFolio();
         $content[$i][] = PortCustomQuery::create()->findByPK($folioImport->getIdPortDestination())->getName();
         $content[$i][] = ForwarderQuery::create()->findByPK($folioImport->getIdForwarder())->getName();
         $content[$i][] = PortCustomQuery::create()->findByPK($folioImport->getIdPortCustom())->getName();
         $idCustomsBroker = $folioImport->getIdCustomsBroker();
         if (!empty($idCustomsBroker)) {
             $content[$i][] = CustomsBrokerQuery::create()->findByPK($folioImport->getIdCustomsBroker())->getName();
         } else {
             $content[$i][] = 'Not Available';
         }
         $content[$i][] = $folioImport->getStatusName();
         $i++;
     }
     $title = $this->i18n->_('Folio Import Report');
     $filename = 'folio_import_report';
     $report->setTableHeaders($headers);
     $report->setTableContent($content);
     $report->setTableTitle($title);
     $report->setFilename($filename);
     $report->createSpreadsheet();
 }
Пример #15
0
 /**
  *
  */
 public function exportToExcelAction()
 {
     $post['name'] = utf8_decode($this->getRequest()->getParam('name'));
     $post['name'] = '%' . $post['name'] . '%';
     $post['status'] = $this->getRequest()->getParam('status');
     $post['sap_id_bussiness_associate'] = $this->getRequest()->getParam('sap_id_bussiness_associate') . '%';
     $customsBrokers = CustomsBrokerQuery::create()->filter($post)->find();
     if (!$customsBrokers->isEmpty()) {
         $i = 1;
         while ($customsBroker = $customsBrokers->read()) {
             $address = AddressQuery::create()->innerJoinCompany()->whereAdd('Address2Company.id_company', $customsBroker->getIdCompany())->find()->getOne();
             $company = CompanyQuery::create()->innerJoinAddress()->whereAdd('Company2Address.id_company', $customsBroker->getIdCompany())->find()->getOne();
             $country = \Application\Query\CountryQuery::create()->whereAdd(\Application\Model\Bean\Country::CODE, $address->getCountry())->find()->getOne();
             $data[$i] = array($company->getSapIdBussinessassociate(), $customsBroker->getName(), $country ? $country->getName() : null, $address->getState(), $address->getStreet(), $address->getSettlement(), $address->getDistrict(), $address->getCity(), $address->getZipCode(), $customsBroker->getStatusName());
             $i++;
         }
         $header = array($this->i18n->_('SAP ID Business Associate'), $this->i18n->_('Name'), $this->i18n->_('Country'), $this->i18n->_('State'), $this->i18n->_('Street'), $this->i18n->_('Settlement'), $this->i18n->_('District'), $this->i18n->_('City'), $this->i18n->_('Zip Code'), $this->i18n->_('Status'));
         $title = $this->i18n->_('Customs Brokers Report');
         $filename = 'customs_brokers_report';
         $customsBrokersReport = new SimpleListReport();
         $customsBrokersReport->setTableHeaders($header);
         $customsBrokersReport->setTableContent($data);
         $customsBrokersReport->setTableTitle($title);
         $customsBrokersReport->setFilename($filename);
         $customsBrokersReport->createSpreadsheet();
     } else {
         $filter = $this->createFilterForUrl($post);
         $this->setFlash("error", $this->i18n->_('No records'));
         $this->_redirect('customs-broker/list');
     }
 }
Пример #16
0
 /**
  *
  * Enter description here ...
  */
 public function exportToExcelAction()
 {
     $post = $this->getRequest()->getParams();
     $brands = BrandQuery::create()->filter($post)->find();
     if (!$brands->isEmpty()) {
         $i = 1;
         while ($brand = $brands->read()) {
             $data[$i] = array($brand->getCode(), $brand->getName(), $brand->getDataSource(), $brand->getUserSign());
             $i++;
         }
         $header = array($this->i18n->_('Code'), $this->i18n->_('Name'), $this->i18n->_('DataSource'), $this->i18n->_('UserSign'));
         $title = $this->i18n->_('Brands Report');
         $fileName = $this->i18n->_('Brands_report');
         $tableColumnsWidth = array('mini');
         $report = new SimpleListReport();
         $report->setTableTitle($title);
         $report->setTableHeaders($header);
         $report->setTableContent($data);
         $report->setFilename($fileName);
         $report->setTableColumnsWidth($tableColumnsWidth);
         $report->createSpreadsheet();
     } else {
         $filter = $this->createFilterForUrl($post);
         $this->setFlash("error", $this->i18n->_('No records'));
         $this->_redirect('brand/list');
     }
 }
Пример #17
0
 /**
  *
  * Enter description here ...
  */
 public function exportToExcelAction()
 {
     $post['id_product_group'] = urldecode($this->getRequest()->getParam('id_product_group'));
     $post['id_family'] = urldecode($this->getRequest()->getParam('id_family'));
     $post['status'] = $this->getRequest()->getParam('status');
     $families = FamilyQuery::create()->filter($post)->find();
     if (!$families->isEmpty()) {
         $i = 1;
         while ($family = $families->read()) {
             if (ProductGroupQuery::create()->whereAdd(ProductGroup::ID_PRODUCT_GROUP, $family->getIdProductGroup())->count()) {
                 $productGroup = ProductGroupQuery::create()->whereAdd(ProductGroup::ID_PRODUCT_GROUP, $family->getIdProductGroup())->findOne();
             } else {
                 $productGroup = new ProductGroup();
             }
             $data[$i] = array($productGroup->getCode() . '-' . $productGroup->getName(), $family->getName(), $family->getCode(), $family->getStatusName());
             $i++;
         }
         $header = array($this->i18n->_('Product Group'), $this->i18n->_('Family'), $this->i18n->_('Code'), $this->i18n->_('Status'));
         $title = $this->i18n->_('Family Report');
         $fileName = $this->i18n->_('Family_report');
         $tableColumnsWidth = array('medium', 'medium', 'mini');
         $report = new SimpleListReport();
         $report->setTableTitle($title);
         $report->setTableHeaders($header);
         $report->setTableContent($data);
         $report->setFilename($fileName);
         $report->setTableColumnsWidth($tableColumnsWidth);
         $report->createSpreadsheet();
     } else {
         $filter = $this->createFilterForUrl($post);
         $this->setFlash("error", $this->i18n->_('No records'));
         $this->_redirect('family/list');
     }
 }
Пример #18
0
 public function exportToExcelAction()
 {
     $params = $this->getRequest()->getParams();
     $idProductGroup = $params['id_product_group'];
     $idFamily = $params['id_family'];
     $familyQuery = FamilyQuery::create()->addColumn(Family::ID_FAMILY);
     if ($idProductGroup != '' && $idFamily == '') {
         $idFamilies = FamilyQuery::create()->whereAdd(Family::ID_PRODUCT_GROUP, $idProductGroup)->fetchIds();
         $params = array('id_family' => array($idFamilies));
         //die(print_r($params));
     }
     if ($idFamily != '' && $idProductGroup != '') {
         $idFamilies = FamilyQuery::create()->whereAdd(Family::ID_PRODUCT_GROUP, $idProductGroup)->whereAdd(Family::ID_FAMILY, $idFamily)->fetchIds();
         if ($idFamilies) {
             $params = array('id_family' => array($idFamilies));
         } else {
             $params = array('id_family' => array(0));
         }
     }
     $subfamilyQuery = SubfamilyQuery::create()->filter($params)->find();
     $headers = array('Product Group', 'Family', 'Subfamily', 'Code', 'Status');
     $content = array();
     foreach ($subfamilyQuery as $key => $subfamily) {
         $family = FamilyQuery::create()->findByPK($subfamily->getIdFamily());
         $content[$key][] = ProductGroupQuery::create()->findByPK($family->getIdProductGroup())->getName();
         $content[$key][] = $family->getName();
         $content[$key][] = $subfamily->getName();
         $content[$key][] = $subfamily->getCode();
         $content[$key][] = $subfamily->getStatusName();
     }
     $title = $this->i18n->_('Subfamilies Report');
     $filename = 'product_groups_report';
     $report = new SimpleListReport();
     $report->setTableHeaders($headers);
     $report->setTableContent($content);
     $report->setTableTitle($title);
     $report->setFilename($filename);
     $report->createSpreadsheet();
 }
Пример #19
0
 public function exportToExcelAction()
 {
     $params = $this->getRequest()->getParams();
     $printingTechniques = PrintingTechniqueQuery::create()->filter($params)->find();
     $tableHeaders = array('id printing Technique', 'Name', 'Code');
     $i = 0;
     $tableContent = array();
     while ($printingTechnique = $printingTechniques->read()) {
         $tableContent[$i][] = $printingTechnique->getIdPrintingTechnique();
         $tableContent[$i][] = $printingTechnique->getName();
         $tableContent[$i][] = $printingTechnique->getAbbreviation();
         $i++;
     }
     $tableTitle = "Printing Techniques Report";
     $filename = "printing_technique_report";
     $report = new SimpleListReport();
     $report->setTableTitle($tableTitle);
     $report->setTableHeaders($tableHeaders);
     $report->setTableContent($tableContent);
     $report->setFilename($filename);
     $report->createSpreadsheet();
     die;
 }
Пример #20
0
 public function exportToExcelByDateAction()
 {
     $filters = $this->getRequest()->getParams();
     $programmedPaymentManager = new ProgrammedPaymentManager();
     $payments = $programmedPaymentManager->getProgrammedPayments($filters);
     $condensedProgrammedPayments = $programmedPaymentManager->getCondensedProgrammedPayments($payments);
     $suppliers = $programmedPaymentManager->getSuppliers($payments);
     $dates = $condensedProgrammedPayments->getDatesAndIndex("asc");
     foreach ($dates as $date) {
         $pay = $condensedProgrammedPayments->getByPK($date["index"]);
         $supplier = $suppliers->getByPK($pay->getIdSupplier());
         if (!$supplier instanceof SapSupplier) {
             $supplier = new SapSupplier();
         }
         $data[$i] = array(0 => $paymentArray[$pay->getIdSupplier()][$pay->getCurrency()][0] = $pay->getDueDateAsZendDate() instanceof \Zend_Date ? $pay->getDueDateAsZendDate()->get("yyyy-MM-dd") : $pay->getDueDate(), 1 => $paymentArray[$pay->getIdSupplier()][$pay->getCurrency()][1] = $pay->getTypeName(), 2 => $paymentArray[$pay->getIdSupplier()][$pay->getCurrency()][2] = $pay->getSapDocnum(), 3 => $paymentArray[$pay->getIdSupplier()][$pay->getCurrency()][3] = $supplier->getIndex(), 4 => $paymentArray[$pay->getIdSupplier()][$pay->getCurrency()][4] = $supplier->getName(), 5 => $paymentArray[$pay->getIdSupplier()][$pay->getCurrency()][5] = $pay->getCurrency(), 6 => $paymentArray[$pay->getIdSupplier()][$pay->getCurrency()][6] = $pay->getAmmount(), 7 => $paymentArray[$pay->getIdSupplier()][$pay->getCurrency()][7] = $pay->getCredits(), 8 => $paymentArray[$pay->getIdSupplier()][$pay->getCurrency()][8] = $pay->getPendingBalance());
         $i++;
     }
     $header = array($this->i18n->_('Due Date'), $this->i18n->_('Document'), $this->i18n->_('Document Number'), $this->i18n->_('Card Code'), $this->i18n->_('Name'), $this->i18n->_('Currency'), $this->i18n->_('Debits'), $this->i18n->_('Credits'), $this->i18n->_('Pending Balance'));
     $title = $this->i18n->_('Programmed Payment Report (by Date)');
     $fileName = $this->i18n->_('programmed_payment_report');
     $report = new SimpleListReport();
     $report->setTableTitle($title);
     $report->setTableHeaders($header);
     $report->setTableContent($data);
     $report->setFilename($fileName);
     $report->createSpreadsheet();
 }
 public function exportToExcelAction()
 {
     $report = new SimpleListReport();
     $params = $this->getRequest()->getParams();
     $params['description'] = '%' . $params['description'] . '%';
     $warehouseEntranceClaimReports = WarehouseEntranceClaimReportQuery::create()->whereAdd(WarehouseEntranceClaimReport::DESCRIPTION, null, WarehouseEntranceClaimReportQuery::IS_NOT_NULL)->orderBy(WarehouseEntranceClaimReport::ID_WAREHOUSE_ENTRANCE_QUARANTINE_CLAIM_REPORT, WarehouseEntranceClaimReportQuery::DESC)->filter($params)->find();
     $i = 0;
     $tableTitle = 'Claim Report Summary';
     $filename = 'claim_report';
     $tableHeaders = array('Id Claim Report', 'Invoice Number', 'Description', 'Claimed Amount', 'Final Amount', 'Status');
     while ($warehouseEntranceClaimReport = $warehouseEntranceClaimReports->read()) {
         $tableContent[$i][] = $warehouseEntranceClaimReport->getIdWarehouseEntranceQuarantineClaimReport();
         $tableContent[$i][] = $warehouseEntranceClaimReport->getInvoiceNumber();
         $tableContent[$i][] = $warehouseEntranceClaimReport->getDescription();
         $tableContent[$i][] = $warehouseEntranceClaimReport->getClaimedAmount() ? $warehouseEntranceClaimReport->getClaimedAmount() : 'N/S';
         $tableContent[$i][] = $warehouseEntranceClaimReport->getFinalAmount() ? $warehouseEntranceClaimReport->getFinalAmount() : 'N/S';
         $tableContent[$i][] = $warehouseEntranceClaimReport->getStatusName();
         $i++;
     }
     $report->setFilename($filename);
     $report->setTableContent($tableContent);
     $report->setTableHeaders($tableHeaders);
     $report->setTableTitle($tableTitle);
     $report->createSpreadsheet();
     die;
 }
Пример #22
0
 public function exportToExcelAction()
 {
     $params = $this->getRequest()->getParams();
     if (!empty($params['name'])) {
         $params['name'] = '%' . $params['name'] . '%';
     }
     $query = PaymentTermQuery::create()->filter($params)->find();
     $columnsWidth = array('mini', 'medium', 'biggest', 'small');
     $headers = array('ID', 'Name', 'Description', 'Status');
     foreach ($query as $key => $object) {
         $events = PaymentTermQuery::create()->whereAdd('PaymentTerm.' . PaymentTerm::ID_PAYMENT_TERM, $object->getIdPaymentTerm())->addColumns(array('PaymentTerm2Event.percent', 'Event.name'))->innerJoinEvent()->fetchAll();
         $paymentTermEvent = '';
         foreach ($events as $event) {
             $paymentTermEvent .= $event['name'] . '-' . $event['percent'] . "% \r";
         }
         $content[$key][] = $object->getIdPaymentTerm();
         $content[$key][] = utf8_encode($object->getName());
         $content[$key][] = $paymentTermEvent;
         $content[$key][] = $object->getStatusName();
     }
     $title = $this->i18n->_('Payment Terms Report');
     $filename = 'payment_terms_report';
     $report = new SimpleListReport();
     $report->setTableHeaders($headers);
     $report->setTableContent($content);
     $report->setTableTitle($title);
     $report->setFilename($filename);
     $report->setTableColumnsWidth($columnsWidth);
     $report->createSpreadsheet();
 }
Пример #23
0
 /**
  * 
  */
 public function exportToExcelAction()
 {
     $params = $this->getRequest()->getParams();
     // 		if (!empty($params['rfc']))
     // 			$params['rfc'] = '%'.$params['rfc'].'%';
     // 		$params['id_approval_status'] = $params['status'];
     // 		unset($params['status']);
     $params = $this->getRequest()->getParams();
     $query = SapSupplierQuery::create();
     $queryCount = SapSupplierQuery::create();
     if (!empty($params['name'])) {
         $query = $query->whereAdd(SapSupplier::CARDNAME, "%" . $params['name'] . "%", SapSupplierQuery::LIKE);
         $queryCount = $queryCount->whereAdd(SapSupplier::CARDNAME, "%" . $params['name'] . "%", SapSupplierQuery::LIKE);
     }
     if (!empty($params['sap_id_bussiness_associate'])) {
         $query = $query->whereAdd(SapSupplier::CARDCODE, '%' . $params['sap_id_bussiness_associate'] . '%', SapSupplierQuery::LIKE);
         $queryCount = $queryCount->whereAdd(SapSupplier::CARDCODE, '%' . $params['sap_id_bussiness_associate'] . '%', SapSupplierQuery::LIKE);
     }
     if (isset($params['status'])) {
         $query = $query->whereAdd(SapSupplier::ID_APPROVAL_STATUS, $params['status'], SapSupplierQuery::LIKE);
         $queryCount = $queryCount->whereAdd(SapSupplier::ID_APPROVAL_STATUS, $params['status'], SapSupplierQuery::LIKE);
     }
     $total = $queryCount->count();
     $query = $query->whereAdd(SapSupplier::CARDTYPE, SapSupplier::$CardTypes['Supplier'])->find();
     $headers = array('Name', 'Payment Term', 'RFC', 'Approval Status');
     $content = array();
     foreach ($query as $key => $object) {
         $content[$key][] = utf8_encode($object->getName());
         if (PaymentTermQuery::create()->whereAdd(\Application\Model\Bean\PaymentTerm::ID_PAYMENT_TERM, $object->getIdPaymentTerm())->count()) {
             $content[$key][] = PaymentTermQuery::create()->findByPK($object->getIdPaymentTerm())->getName();
         } else {
             $content[$key][] = $this->i18n->_('Not Available');
         }
         $content[$key][] = $object->getRfc();
         $approvalStatus = array_flip(SapSupplier::$IdApprovalStatus);
         $content[$key][] = $approvalStatus[$object->getIdApprovalStatus()];
     }
     $title = $this->i18n->_('Suppliers Report');
     $filename = 'suppliers_report';
     $report = new SimpleListReport();
     $report->setTableHeaders($headers);
     $report->setTableContent($content);
     $report->setTableTitle($title);
     $report->setFilename($filename);
     $report->createSpreadsheet();
 }
Пример #24
0
 /**
  *
  */
 public function exportToExcelAction()
 {
     $post = $this->getRequest()->getParams();
     $post['name'] = "%" . $post['name'] . "%";
     $freightTypes = FreightTypeQuery::create()->filter($post)->find();
     if (!$freightTypes->isEmpty()) {
         $i = 1;
         while ($freightType = $freightTypes->read()) {
             $data[$i] = array($freightType->getCode(), FreightType::$FreightTypeCombo[$freightType->getType()], $freightType->getName(), $freightType->getMaxLoad(), $freightType->getMinLoad(), $freightType->getPayload(), $freightType->getStatusName());
             $i++;
         }
         $header = array($this->i18n->_('Code'), $this->i18n->_('Freight Type'), $this->i18n->_('Detail'), $this->i18n->_('Max Load (CBM)'), $this->i18n->_('Min Load (CBM)'), $this->i18n->_('Payload'), $this->i18n->_('Status'));
         $title = $this->i18n->_('Freight Types Report');
         $fileName = $this->i18n->_('Freight_types_report');
         $report = new SimpleListReport();
         $report->setTableTitle($title);
         $report->setTableHeaders($header);
         $report->setTableContent($data);
         $report->setFilename($fileName);
         $report->createSpreadsheet();
     } else {
         $filter = $this->createFilterForUrl($post);
         $this->setFlash("error", $this->i18n->_('No records'));
         $this->_redirect('freight-type/list');
     }
 }
Пример #25
0
 /**
  *
  */
 public function exportToExcelQuarantineAction()
 {
     $report = new SimpleListReport();
     $params = $this->getRequest()->getParams();
     $subquery = WarehouseEntranceQuery::create()->whereAdd(WarehouseEntrance::ID_FOLIO_IMPORT, null, WarehouseEntranceQuery::NOT_EQUAL)->whereAdd(WarehouseEntrance::ID_FOLIO_IMPORT, '0', WarehouseEntranceQuery::NOT_EQUAL)->fetchCol();
     $warehouseEntryProductQuery = WarehouseEntranceProductQuery::create()->whereAdd(WarehouseEntranceProduct::ID_PURCHASE_ORDER, null, WarehouseEntranceProductQuery::NOT_EQUAL)->whereAdd(WarehouseEntranceProduct::STATUS, WarehouseEntranceProduct::$Status['Quarantine'], WarehouseEntranceProductQuery::EQUAL)->whereAdd(WarehouseEntranceProduct::ID_WAREHOUSE_ENTRANCE, $subquery, WarehouseEntranceProductQuery::IN)->filter($params)->orderBy(WarehouseEntranceProduct::ID_WAREHOUSE_ENTRANCE, 'DESC')->find();
     $i = 0;
     $this->getCatalog('QuarantineCatalog')->beginTransaction();
     while ($warehouseEntryLine = $warehouseEntryProductQuery->read()) {
         $warehouseEntry = WarehouseEntranceQuery::create()->whereAdd(WarehouseEntrance::ID_WAREHOUSE_ENTRANCE, $warehouseEntryLine->getIdWarehouseEntrance())->findOne();
         $claimReport = $this->getClaimReport($warehouseEntryLine->getIdWarehouseEntrance(), $warehouseEntryLine->getIdWarehouseEntranceProduct());
         $folioImport = $this->getWarehouseEntryFolioImport($warehouseEntry->getIdFolioImport());
         $quarantine = $this->getQuarantine($warehouseEntryLine->getIdWarehouseEntrance(), $warehouseEntryLine->getIdWarehouseEntranceProduct());
         $product = ProductQuery::create()->findByPK($warehouseEntryLine->getIdProduct());
         $warehouseEntryLines[$i][] = $folioImport->getFolio();
         $warehouseEntryLines[$i][] = $warehouseEntryLine->getIdPurchaseOrder();
         $warehouseEntryLines[$i][] = $product->getItemCode() . ' - ' . $product->getItemName();
         if (TransferLineLogQuery::create()->whereAdd(TransferLineLog::BASEENTRY, $warehouseEntryLine->getIdWarehouseEntrance())->whereAdd(TransferLineLog::BASELINE, $warehouseEntryLine->getIdWarehouseEntranceProduct())->count()) {
             $transferLine = TransferLineLogQuery::create()->whereAdd(TransferLineLog::BASEENTRY, $warehouseEntryLine->getIdWarehouseEntrance())->whereAdd(TransferLineLog::BASELINE, $warehouseEntryLine->getIdWarehouseEntranceProduct())->findOne();
             $warehouseEntryLines[$i][] = WarehouseStoreQuery::create()->whereAdd(WarehouseStore::CODE, $transferLine->getWhsCode())->findOne()->getName();
         } else {
             $warehouseEntryLines[$i][] = $this->i18n->_('Not Available');
         }
         $warehouseEntryLines[$i][] = $warehouseEntryLine->getQuantity();
         $warehouseEntryLines[$i][] = $currentQuantity = $quarantine->getQuantity();
         $warehouseEntryLines[$i][] = $currentQuantity == 0 ? 'Debugged' : 'Quarantine';
         $i++;
     }
     $tableHeaders = array('Folio Import', 'Doc Entry Purchase Order', 'Description', 'Warehouse', 'Original Quantity', 'Current Quantity', 'Status');
     $report->setTableContent($warehouseEntryLines);
     $report->setTableHeaders($tableHeaders);
     $report->setFilename('quarantine_report');
     $report->setTableTitle('Quarantine Report');
     $report->createSpreadsheet();
 }
Пример #26
0
 /**
  *
  */
 public function exportToExcelAction()
 {
     $post = $this->getRequest()->getParams();
     $post['id_transit'] = "%" . $post['id_transit'] . "%";
     $freightFares = FreightFareQuery::create()->filter($post)->find();
     $i = 1;
     while ($freightFare = $freightFares->read()) {
         $port = \Application\Query\PortCustomQuery::create()->whereAdd(PortCustom::ID_PORT_CUSTOM, $freightFare->getFobPort())->findOne();
         $destination = \Application\Query\PortCustomQuery::create()->whereAdd(PortCustom::ID_PORT_CUSTOM, $freightFare->getDestinationPort())->findOne();
         $freightTYpe = FreightTypeQuery::create()->whereAdd(FreightType::ID_FREIGHT_TYPE, $freightFare->getIdFreightType())->findOne();
         $forwarder = ForwarderQuery::create()->whereAdd(Forwarder::ID_FORWARDER, $freightFare->getIdForwarder())->findOne();
         $currency = \Application\Query\CurrencyQuery::create()->whereAdd(\Application\Model\Bean\Currency::CURRCODE, $freightFare->getIdCurrency())->findOne();
         $data[$i] = array($freightFare->getIdFreightFare(), $freightFare->getIdTransit(), $port->getName(), $destination->getName(), $freightTYpe->getName(), $freightFare->getNotes(), $freightFare->getTt(), $freightFare->getFrecuency(), $forwarder->getName(), $freightFare->getGoodThrough(), $freightFare->getUnitName(), $freightFare->getUNitCost(), $freightFare->getPeak(), $freightFare->getStatusName());
         $i++;
     }
     $header = array($this->i18n->_('ID'), $this->i18n->_('ID-Transit'), $this->i18n->_('FOB Port'), $this->i18n->_('Destination Port'), $this->i18n->_('Freight Type'), $this->i18n->_('Notes'), $this->i18n->_('Transit Time'), $this->i18n->_('Frecuency'), $this->i18n->_('Forwarder'), $this->i18n->_('Good Through'), $this->i18n->_('Unit'), $this->i18n->_('Unit Cost'), $this->i18n->_('Peak/Unit'), $this->i18n->_('Status'));
     $title = $this->i18n->_('Freight Fares Report');
     $fileName = $this->i18n->_('Freight_fares_report');
     $tableColumnsWidth = array('mini', 'medium', 'medium', 'medium', 'medium', 'medium', 'medium', 'medium', 'medium', 'medium', 'mini', 'mini', 'mini');
     $report = new SimpleListReport();
     $report->setTableTitle($title);
     $report->setTableHeaders($header);
     $report->setTableContent($data);
     $report->setFilename($fileName);
     $report->setTableColumnsWidth($tableColumnsWidth);
     $report->createSpreadsheet();
 }
Пример #27
0
 /**
  * 
  */
 public function exportToExcelAction()
 {
     $focusGroups = FocusGroupQuery::create()->find();
     $i = 0;
     while ($focusGroup = $focusGroups->read()) {
         $content[$i][] = $focusGroup->getIdFocusGroups();
         $content[$i][] = $focusGroup->getName();
         $content[$i][] = PollQuery::create()->findByPK($focusGroup->getIdPoll())->getName();
         $i++;
     }
     $title = $this->i18n->_('Focus Group Report');
     $filename = 'focus_group_report';
     $headers = array('Id Focus Group', 'Name', 'Poll');
     $report = new SimpleListReport();
     $report->setTableContent($content);
     $report->setTableHeaders($headers);
     $report->setTableTitle($title);
     $report->setFilename($filename);
     $report->createSpreadsheet();
 }