namibia
df0489e1eeeeab5a9bd44e1d84fce49924fe1bac
namibia / module / PriceGuide / src / PriceGuide / Report / PriceGuideGrid.php
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 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 |
<?php namespace PriceGuide\Report; /** * Stock Control Report. * @author andre.fourie */ class PriceGuideGrid extends \Utility\Service\Report { /** * @var string */ protected $_title = 'Price Guide Data Export'; /** * @var string */ protected $_subject = 'Vehicles on price guide.'; /** * @var string */ protected $_description = 'Export of vehicles available on price guide.'; /** * @var array */ protected $_notes = array( 'Confidential information, generated using Bid 4 Cars, for more information visit bid4cars.co.za' ); /** * @var array */ protected $_headers = array( 'Seller', 'Group', 'Division', 'Region', 'Reference Number', 'Registration Number', 'VIN Number', 'Make', 'Model', 'Type', 'Year', 'Main Exterior Colour', 'KM', 'Trade Price', 'Retail Price', 'Number of price guide offers', 'Highest price guide offer', 'My offer', 'Status', 'Created', 'Updated' ); /** * @var array */ protected $_fields = array( 'company_name', 'companyGroup_name', 'groupDivision_name', 'region_name', 'stock_referenceNumber', 'stock_registrationNumber', 'stock_vinNumber', 'make_name', 'model_name', 'type_name', 'vehicleYear_name', 'exteriorColour_name', 'stock_km', 'stock_tradePrice', 'stock_retailPrice', 'stock_listPrice', 'stock_numberOfOffers', 'stock_highestOffer', 'priceGuide_id', 'priceGuide_jobState', 'priceGuide_created', 'priceGuide_updated' ); /** * @var array */ protected $_totals = array( 'stock_tradePrice', 'stock_retailPrice', 'stock_listPrice', 'stock_retailAmountRequired', 'stock_highestOffer', 'priceGuide_id' ); /** * @var array */ protected $_currencyFields = array( 'stock_tradePrice', 'stock_retailPrice', 'stock_listPrice', 'stock_retailAmountRequired', 'stock_highestOffer', 'priceGuide_id' ); /** * Build the dataset, or not. */ public function build() { #-> Data passed by DataBin Grid functionality. $dateTimeFormat = \Utility\Definitions\Locale::getDateTimeFormat(); $auth = \Utility\Registry::getAuthData(); foreach ($this->_data as $rowId => $rowData) { $myOffer = $this->em->getRepository('\PriceGuide\Entity\Offer') ->findOneBy(array( 'priceGuideStock' => $this->_data[$rowId]['priceGuide_id'], 'company' => $auth['company']['id'] )); $this->_data[$rowId]['priceGuide_id'] = is_object($myOffer) ? $myOffer->amount : 0.0; $this->em->clear('\PriceGuide\Entity\Offer'); $this->_data[$rowId]['priceGuide_created'] = $rowData['priceGuide_created']->format($dateTimeFormat); $this->_data[$rowId]['priceGuide_updated'] = !is_null($rowData['priceGuide_updated']) ? $rowData['priceGuide_updated']->format($dateTimeFormat) : ''; if ('Updateable Offers' == $this->_data[$rowId]['priceGuide_jobState'] || 'Open4Offers' == $this->_data[$rowId]['priceGuide_jobState']) { $this->_data[$rowId]['stock_highestOffer'] = 0.0; } } } } |
Commits for namibiamodule/PriceGuide/src/PriceGuide/Report/PriceGuideGrid.php
Revision | Author | Commited | Message |
---|---|---|---|
df0489 ... | Mark | Fri 14 Oct, 2016 10:01:00 +0000 | initial commit |