protected function joinProductsPriceRevision($id, $idRev)
{
$query = $this->modelsManager->createQuery("SELECT pp.id,ppr.id as revision_id,pp.product_id,pp.price_lists_id,pp.price_list,pp.price_retail,pp.price_ecommerce,ppr.price_lists_revisions_id,ppr.price_list as price_list_revision,ppr.price_retail as price_retail_revision,ppr.price_ecommerce as price_ecommerce_revision\n\t\t\t\tFROM Thunderhawk\\API\\Mvc\\Model\\Products\\ProductPrices AS pp \n\t\t\t\tLEFT JOIN Thunderhawk\\API\\Mvc\\Model\\Products\\ProductPricesRevisions AS ppr ON pp.id = ppr.product_prices_id\n\t\t\t\tAND ppr.price_lists_revisions_id = :idRev: WHERE pp.price_lists_id = :idList:");
$prices = $query->execute(array('idRev' => $idRev, 'idList' => $id));
$data = array();
$i = 0;
foreach ($prices as $price) {
$data[$i] = $price->toArray();
$data[$i]['prodotto'] = Product::findFirstByIdProduct($price->product_id)->getName(1);
if ($data[$i]['price_list_revision'] != null) {
$data[$i]['price_list'] = $data[$i]['price_list_revision'];
}
if ($data[$i]['price_retail_revision'] != null) {
$data[$i]['price_retail'] = $data[$i]['price_retail_revision'];
}
if ($data[$i]['price_ecommerce_revision'] != null) {
$data[$i]['price_ecommerce'] = $data[$i]['price_ecommerce_revision'];
}
$i++;
}
return $this->sendAjax(array('data' => $data));
}
