public function index()
{
$volumes = Volumes::find('list', array("fields" => "name", "order" => "number ASC"));
$pageVolumes = Pages::connection()->connection->command(array('distinct' => 'pages', 'key' => 'volume_number'));
$importedVolumes = array();
$i = 0;
// print_r($pageVolumes['values']);
foreach ($pageVolumes['values'] as $v) {
array_push($importedVolumes, $v);
$i++;
}
$Ivolumes = Volumes::find('all', array('fields' => 'name, number', 'conditions' => array('number' => array('$in' => $importedVolumes)), 'order' => 'number ASC'));
// print_r($Ivolumes);
// print_r($importedVolumes);
return compact('volumes', 'Ivolumes');
}
public function index()
{
$mongodb = Connections::get('default')->connection;
$pages = Pages::connection()->connection->command(array('aggregate' => 'pages', 'pipeline' => array(array('$match' => array('volume_number' => '22')), array('$group' => array('_id' => array('type' => '$type.name', 'volume_number' => '$volume_number', 'type_id' => '$type._id'), 'count' => array('$sum' => 1))), array('$sort' => array('type_id' => 1)))));
return compact('pages');
}
