PHP ArrayUtils::pluck方法代码示例

 public function buildDashboard()
 {
     $this->setDashboardTitle("Stock Dashboard");
     $this->setActionPath("/static/transfer/build/tour/motherboard_stock_action.php");
     $kpi = new KPIGroupComponent('kpi');
     $kpi->setDimensions(12, 2);
     $kpi->setCaption('Units stock by Category');
     $Units = $this->get_units(true);
     foreach ($Units as $key => $value) {
         $kpi->addKPI($value['id'], array('caption' => $value['CategoryName'], 'value' => $value['Quantity'], 'numberSuffix' => ' units', 'numberHumanize' => true));
     }
     $this->addComponent($kpi);
     $table = new TableComponent('table');
     $table->setCaption("List of Item in Stock");
     $table->setDimensions(6, 5);
     $stock = $this->get_stock();
     $table->addColumn('id', 'Product Id');
     $table->addColumn('name', 'Product Name');
     $table->addColumn('category', 'Category');
     $table->addColumn('price', 'Price', array("numberPrefix" => "\$", "dataType" => "number"));
     $table->addColumn('stock', 'Stock');
     $table->addMultipleRows($this->PolulateData($stock));
     $this->addComponent($table);
     $c12 = new FormComponent('filter');
     $c12->setDimensions(6, 5);
     $c12->setCaption('Filter items in stock');
     $category = $this->get_category();
     $c12->addSelectField('category', 'Select Category', array_merge(['no selection'], ArrayUtils::pluck($category, 'CategoryName')));
     $c12->addTextField('contains', 'Product Name Contains');
     $c12->addNumericRangeField('stock', 'Units In Stock', array(0, 100));
     $this->addComponent($c12);
     $c12->onApplyClick(array($table), 'handleApply', $this);
 }

 public function get_cities($source, $target, $params)
 {
     $cityDataQuery = $this->pdo->prepare("SELECT SUM(amount) as total_amount, city FROM Payments NATURAL JOIN Customers where Customers.state = :paymentState GROUP BY city;");
     $cityDataQuery->execute(array('paymentState' => $params['label']));
     $cityData = $cityDataQuery->fetchAll(PDO::FETCH_ASSOC);
     $source->clearChart();
     $source->setLabels(ArrayUtils::pluck($cityData, 'city'));
     $source->addSeries("sales", "Sales", ArrayUtils::pluck($cityData, "total_amount"), array('numberPrefix' => "\$"));
 }

 public function handleArtistChartClick($source, $target, $params)
 {
     $artistName = $params['label'];
     $topAlbumsChart = $this->getComponentByID("c2");
     $top_albums = $this->getTopAlbums($artistName);
     $topAlbumsChart->setCaption("Top 5 albums by " . $artistName);
     $topAlbumsChart->clearChart();
     $topAlbumsChart->setLabels(ArrayUtils::pluck($top_albums, "Title"));
     $topAlbumsChart->addSeries('top_albums', "Top Albums", ArrayUtils::pluck($top_albums, "total_sales"));
 }

 public function get_daywise($source, $target, $params)
 {
     $month = array_search($params['label'], $this->monthName);
     $daywiseQuery = $this->pdo->prepare("SELECT SUM(UnitPrice * Quantity) as total_amount, strftime('%d', OrderDate) as payment_day FROM 'Order' as o, 'OrderDetail' as od where o.Id = od.OrderId and strftime('%Y', OrderDate)=:paymentYear and strftime('%m', OrderDate)=:paymentMonth GROUP BY payment_day;");
     $daywiseQuery->execute(array('paymentYear' => $params['drillLabelList'][0], 'paymentMonth' => $month));
     $daywise = $daywiseQuery->fetchAll(PDO::FETCH_ASSOC);
     $source->clearChart();
     $source->setLabels(ArrayUtils::pluck($daywise, 'payment_day'));
     $totalSalesArr = ArrayUtils::pluck($daywise, "total_amount");
     $source->addSeries("sales", "Sales", $totalSalesArr, array('numberPrefix' => "\$"));
     $totalSales = 0;
     foreach ($totalSalesArr as $key => $value) {
         $totalSales += $value;
     }
     $source->addComponentKPI("sales", array("caption" => "Total Sales", "value" => $totalSales, "numberPrefix" => "\$", "numberHumanize" => true));
     $source->addComponentKPI("second", array("caption" => "Revenue", "value" => $totalSales, "numberPrefix" => "\$", "numberHumanize" => true));
 }

 public function handleForm($source, $target, $params)
 {
     $Date = $source->getInputValue('datebtw');
     $dateStartArray = date_parse($Date[0]);
     $dateEndArray = date_parse($Date[1]);
     $dailySales = $this->getComponentByID("c1");
     $item = $this->getComponentByID("c3");
     $chart = $this->getComponentByID("pie_chart");
     $hour = $this->getComponentByID("c4");
     $dateStartString = $dateStartArray['year'] . '-' . $dateStartArray['month'] . '-' . $dateStartArray['day'];
     $dateEndString = $dateEndArray['year'] . '-' . $dateEndArray['month'] . '-' . $dateEndArray['day'];
     $dailySalesData = $this->getDailySales($dateStartString, $dateEndString);
     $dailySales->setLabels(ArrayUtils::pluck($dailySalesData, "tarih2"));
     $dailySales->addSeries('food', "Food", ArrayUtils::pluck($dailySalesData, "cikis"), array("numberHumanize" => true));
     $dailySalesFoodData = $this->getDailySalesFood($dateStartString, $dateEndString);
     $dailySales->addSeries('covers', "Covers", ArrayUtils::pluck($dailySalesFoodData, "cikis"), array("numberHumanize" => true, "yAxis" => "covers"));
     $itemCategories = $this->getItemCategories($dateStartString, $dateEndString);
     $item->setLabels(ArrayUtils::pluck($itemCategories, "grupadi"));
     $item->addSeries('items', "Items", ArrayUtils::pluck($itemCategories, "cikis"), array("numberHumanize" => true));
     $clerkData = $this->getClerkSales($dateStartString, $dateEndString);
     $chart->setLabels(ArrayUtils::pluck($clerkData, "garson"));
     $chart->setPieValues(ArrayUtils::pluck($clerkData, "cikis"));
     $hourlySales = $this->getHourlySales($dateStartString, $dateEndString);
     $hour->setLabels(ArrayUtils::pluck($hourlySales, "SAAT"));
     $hour->addSeries('items', "Items", ArrayUtils::pluck($hourlySales, "CIKIS"), array("numberHumanize" => true));
 }