public function service()
 {
     //todo check if user have access to given company
     $customer = $this->sessionManager->getUser();
     $cId = $customer->getId();
     $companyId = $this->args[0];
     if ($companyId != $cId) {
         return false;
     }
     $companyManager = CompanyManager::getInstance($this->config, $this->args);
     $company = $companyManager->selectByPK($companyId);
     if (!$company) {
         return false;
     }
     $ex = new excel_xml();
     $header_style = array('bold' => 1, 'size' => '12', 'color' => '#FFFFFF', 'bgcolor' => '#4F81BD');
     $ex->add_style('header', $header_style);
     $ex->add_row(array('Serial Number', 'Category', 'Customer', 'Customer Warranty Period', 'Customer Purchase Date', 'Supplier', 'Purchase Date From Supplier', 'Supplier Warranty Period'), 'header');
     $itemWarrantiesManager = ItemWarrantiesManager::getInstance($this->config, $this->args);
     $allItemsWarrantiesDtos = $itemWarrantiesManager->getCompanyAllWarrantyItems($companyId);
     foreach ($allItemsWarrantiesDtos as $key => $itemWarrantyDto) {
         $c1 = $itemWarrantyDto->getSerialNumber();
         $c2 = $itemWarrantyDto->getItemCategory();
         $c3 = $itemWarrantyDto->getBuyer();
         $c4 = $itemWarrantyDto->getCustomerWarrantyPeriod();
         $c5 = $itemWarrantyDto->getCustomerWarrantyStartDate();
         $c6 = $itemWarrantyDto->getSupplier();
         $c7 = $itemWarrantyDto->getSupplierWarrantyStartDate();
         $c8 = $itemWarrantyDto->getSupplierWarrantyPeriod();
         $ex->add_row(array($c1, $c2, $c3, $c4, $c5, $c6, $c7, $c8));
     }
     $ex->create_worksheet('Items Warranties');
     $ex->generate();
     $ex->download($this->args[1]);
 }
Пример #2
0
 public function load()
 {
     $item_warranty_options = array(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 'Lifetime');
     $item_warranty_categories_options = array('Not Specified', 'Laptop', 'HDD', 'DVD/Blu-ray', 'Motherboard', 'Memory (RAM)', 'Processor (CPU)', 'Monitor', 'Graphics Card', 'UPS', 'Printer', 'Network', 'Other');
     $this->addParam('item_warranty_options', $item_warranty_options);
     $this->addParam('item_warranty_categories_options', $item_warranty_categories_options);
     $companyId = $this->sessionManager->getUser()->getId();
     $itemWarrantiesManager = ItemWarrantiesManager::getInstance($this->config, $this->args);
     $search_serial_number = null;
     if (isset($_REQUEST["search_serial_number"])) {
         $search_serial_number = $this->secure($_REQUEST["search_serial_number"]);
     }
     $ItemsWarranties = $itemWarrantiesManager->getCompanyWarrantyItems($companyId, $search_serial_number, 0, 500);
     $this->addParam('ItemsWarranties', $ItemsWarranties);
     $this->addParam('search_serial_number', $search_serial_number);
     if (isset($_REQUEST["warranty_item_id"])) {
         $warranty_item_id = $this->secure($_REQUEST["warranty_item_id"]);
         $itemWarrantyDto = $itemWarrantiesManager->selectByPK($warranty_item_id);
         $itemCategory = $itemWarrantyDto->getItemCategory();
         $serialNumber = $itemWarrantyDto->getSerialNumber();
         $buyer = $itemWarrantyDto->getBuyer();
         $customerWarrantyPeriod = $itemWarrantyDto->getCustomerWarrantyPeriod();
         $customerWarrantyStartDate = $itemWarrantyDto->getCustomerWarrantyStartDate();
         $supplier = $itemWarrantyDto->getSupplier();
         $supplierWarrantyStartDate = $itemWarrantyDto->getSupplierWarrantyStartDate();
         $supplierWarrantyPeriod = $itemWarrantyDto->getSupplierWarrantyPeriod();
         $this->addParam('item_warranty_categories_options_selected', $itemCategory);
         $this->addParam('item_warranty_options_selected', $customerWarrantyPeriod);
         $this->addParam('serial_number', $serialNumber);
         $this->addParam('buyer', $buyer);
         $this->addParam('customer_warranty_start_date', $customerWarrantyStartDate);
         $this->addParam('supplier', $supplier);
         $this->addParam('supplier_warranty_start_date', $supplierWarrantyStartDate);
         $this->addParam('supplier_warranty_period', $supplierWarrantyPeriod);
         $this->addParam('warranty_item_id', $warranty_item_id);
     } else {
         $this->addParam('item_warranty_categories_options_selected', $item_warranty_categories_options[0]);
         $this->addParam('item_warranty_options_selected', $item_warranty_options[12]);
         $this->addParam('supplier_warranty_period', $item_warranty_options[12]);
     }
     $this->addParam('company_id', $companyId);
 }