protected static function _getData() { if (count(self::$_dateRange) === 0) { $toDate = UDate::maxDate(); } else { $toDate = self::$_dateRange['end']; } $return = array(); foreach (AccountingCode::getAll() as $accoutingCode) { $return[] = array('type' => self::_convertType($accoutingCode->getTypeId()), 'code' => $accoutingCode->getCode(), 'description' => $accoutingCode->getDescription()); } return $return; }
protected static function _getData() { if (count(self::$_dateRange) === 0) { $toDate = UDate::maxDate(); } else { $toDate = self::$_dateRange['end']; } $return = array(); $myobCodeType = ProductCodeType::get(ProductCodeType::ID_MYOB); foreach (Product::getAll(true) as $product) { $logs = ProductQtyLog::getAllByCriteria('productId = ? and created <= ?', array($product->getId(), trim($toDate)), true, 1, 1, array('id' => 'desc')); $log = count($logs) > 0 ? $logs[0] : null; $myobCodes = ProductCode::getCodes($product, $myobCodeType, true, 1, 1); $return[] = array('sku' => $product->getSku(), 'name' => $product->getName(), 'short description' => $product->getShortDescription(), 'category' => join(', ', array_map(create_function('$a', 'return $a->getCategory()->getName();'), $product->getCategories())), 'assetAccNo' => $product->getAssetAccNo(), 'revenueAccNo' => $product->getRevenueAccNo(), 'costAccNo' => $product->getCostAccNo(), 'Stock On PO' => $log instanceof ProductQtyLog ? $log->getStockOnPO() : $product->getStockOnPO(), 'Stock On Order' => $log instanceof ProductQtyLog ? $log->getStockOnOrder() : $product->getStockOnOrder(), 'Stock On Hand' => $log instanceof ProductQtyLog ? $log->getStockOnHand() : $product->getStockOnHand(), 'Total On Hand Value' => $log instanceof ProductQtyLog ? $log->getTotalOnHandValue() : $product->getTotalOnHandValue(), 'Stock In Parts' => $log instanceof ProductQtyLog ? $log->getStockInParts() : $product->getStockInParts(), 'Total In Parts Value' => $log instanceof ProductQtyLog ? $log->getTotalInPartsValue() : $product->getTotalInPartsValue(), 'Stock In RMA' => $log instanceof ProductQtyLog ? $log->getStockInRMA() : $product->getStockInRMA(), 'Total RMA Value' => $log instanceof ProductQtyLog ? $log->getTotalRMAValue() : $product->getTotalRMAValue(), 'active' => intval($product->getActive()) === 1 ? 'Y' : 'N', 'MYOB' => count($myobCodes) > 0 ? $myobCodes[0]->getCode() : ''); } return $return; }
/** * (non-PHPdoc) * @see BaseEntity::__loadDaoMap() */ public function __loadDaoMap() { DaoMap::begin($this, 'pro_price'); DaoMap::setManyToOne('product', 'Product', 'pro_price_pro'); DaoMap::setManyToOne('type', 'ProductPriceType', 'pro_price_type'); DaoMap::setIntType('price', 'double', '10,4'); DaoMap::setDateType('start', 'datetime', false, trim(UDate::zeroDate())); DaoMap::setDateType('end', 'datetime', false, trim(UDate::maxDate())); parent::__loadDaoMap(); DaoMap::createIndex('price'); DaoMap::createIndex('start'); DaoMap::createIndex('end'); DaoMap::commit(); }