<?php

namespace common\models;

use Yii;
use Solarium;
use app\controllers\DBInterface;


/*
 * This QueryManager handles all SOLR-Queries
 */
class SOLRQueryManager {


        // place here all queries for the field results:
        // use the correct field var names of the index doc (should match with model field)!
        public static function getPartialQuery($field, $value, $filters, $details) {
              //echo "getPartialQuery; field".$field.", value:".$value;
						 	//print_r($field);
							//yii\helpers\VarDumper::dump($field, 10, true);


	    $synonymbox = "";


		if($value!="\(\)" && $value!="coming\ soon"){
			switch ($field) {
				case 'fullScientificName' :
					$synonymbox = true;
					if (strpos($value, 'appears in environmental sample(s) or eDNA') !== false) {
					   $check = explode("'", $value);
					   $value = $check[1]."*";
					   return '(fullScientificName_search' . ':(' . $value . ') OR backboneaccepted:(' . $value . ') OR backboneaccepted:(' . $value . ') OR regnum:(' . $value . ') OR phylum:(' . $value . ') OR classis:(' . $value . ') OR familia:(' . $value . ') OR ordo:(' . $value . ') AND (preparationType:eDNA OR preparationType:eSample))';
					   }
					else {
						$value = $value;
						return '(fullScientificName_search' . ':(' . $value . ') OR backboneaccepted:(' . $value . ') OR regnum:(' . $value . ')  OR phylum:(' . $value . ') OR classis:(' . $value . ') OR familia:(' . $value . ') OR ordo:(' . $value . ') )';
						}
					break;
				case 'ScientificName' :
					return '';
					break;
				case 'kingdom' :
					if ($value == "Not\ assigned")
						return '(regnum:' . $value . ' OR N/A OR null)';
					else
						return 'regnum:' . $value . '';
					break;
				case 'phylumName' :
					if ($value == "Not\ assigned")
						return '(phylum:' . $value . ' OR N/A OR null)';
					else
						return 'phylum:' . $value . '';
					break;
				case 'orderName' :
					if ($value == "Not\ assigned")
						return '(ordo:' . $value . ' OR N/A OR null)';
					else
						return 'ordo:' . $value . '';
					break;
				case 'familyName' :
					if ($value == "Not\ assigned")
						return '(familia:' . $value . ' OR N/A OR null)';
					else
						return 'familia:' . $value . '';
					break;
				case 'genusName' :
					return 'genus:(' . $value . ')';
					break;
				case 'speciesName' :
					return 'species:(' . $value . ')';
					break;
				case 'className' :
					if ($value == "Not\ assigned")
						return '(classis:' . $value . ' OR N/A OR null)';
					else
						return 'classis:' . $value . '';
					break;
				case 'geneticlocus' :
					return $field . ':(' . $value . ')';
					break;
				case 'collectioncode' :
					return $field . ':"' . $value . '"';
					break;
				case 'institutioncode' :
					return $field . ':"' . $value . '"';
					break;
				case 'locality' :
					return $field . ':(' . $value . ')';
					break;
				case 'collectors' :
					return $field . ':(' . $value . ')';
					break;
				case 'collectornumber' :
					return '(' . $field . ':(' . $value . ') OR fieldnumber:(' .$value . '))';
					break;
				case 'cites' :
					if ($value == "include")
						return "citesStatus:*";
					if ($value == "exclude")
						return "NOT citesStatus:*";
					if ($value == "citesOnly")
						return "citesStatus:I*";
					break;
				case 'sampleavailability' :
					if ($value == "only")
						return " NOT blocked:Yes AND NOT blocked:yes AND NOT blockedUntil:2* AND NOT disposition_clean:missing AND NOT disposition_clean:consumed ";
					if ($value == "all")
						return "*:*";
					break;
				case 'accessionStatus' :
					if ($value == "onlyLiving")
						return "accessionStatus:C";
						if ($value == "onlyDead")
							return "accessionStatus:D";
						if ($value == "all")
							return "accessionStatus:*";
						break;
				case 'sequenceaccessionIdentifier' :
					return 'sequenceaccessionIdentifier_search:(' . $value . ') OR boldnumber_search:(' . $value . ')';
					break;
				case 'unitID' :
					return '(' . $field .':(' . $value . ') OR unitaccessionnumber:(' .$value . '))';
					break;
				case 'ipen' :
					return $field .':(' . $value . ')';
					break;
				case 'unitaccessionnumber' :
					return $field .':(' . $value . ')';
					break;
				case 'hasImage' :
					return $field . ":" . $value;
					break;
				case 'hasTypestatus' :
					return $field . ":" . $value;
					break;
				case 'identifiedBy' :
					return $field . ":*";
					break;
				// lists
				// they alway deliver a value so we have to check
				// if it is the "nothing choosen value"
				// then we won't need a query
				case 'country' :
					return $field . "_search:(" . $value . ")";
					break;
				case 'recordbasis' :
					return $field . ":" . $value;
					break;
				case 'isocountrycode' :
					return $field . ":" . $value;
					break;
				case 'continent' :
					return $field . "_search:(" . $value . ")";
					break;
				case 'sea' :
					return $field . "_search:(" . $value . ")";
					break;
				case 'ocean' :
					return $field . "_search:(" . $value .")";
					break;
				case 'sampletype' :
					return $field . ":" . $value;
					break;
				case 'preparationtype' :
					return "preparationType:(" . $value .")";
					break;
				case 'institution' :
					// if ($value == $model->getSelectionListNonChosen () or $value == '0') {
					if ($value == "---" or $value == '0') { // Gabis Version
						return false;
					} else {
						return $field . ":\"" . $value . "\"";
					}
					break;
				// fields with that come as a pair and provide a range for the value
				case 'latitudeFrom' :
					// TODO this has to go to form validation!!!
					return SOLRQueryManager::handleCoordinates ( $filters );
					break;
				case 'latitudeTo' :
					// TODO this has to go to form validation!!!
					return SOLRQueryManager::handleCoordinates ( $filters );
					break;

				case 'longitudeFrom' :
					// TODO this has to go to form validation!!!
					return SOLRQueryManager::handleCoordinates ( $filters );
					break;
				case 'longitudeTo' :
					// TODO this has to go to form validation!!!
					return SOLRQueryManager::handleCoordinates ( $filters );
					break;
				case 'collectionYearFrom' :
					// TODO this has to go to form validation!!!
					return SOLRQueryManager::handleYear ( $filters );
					break;
				// collection year
				case 'collectionYearTo' :
					// TODO this has to go to form validation!!!
					return SOLRQueryManager::handleYear ( $filters );
					break;
				default : // this should never happen
					return $field . ":" . $value;
					break;
			}
		}
		// return $query[$field];


	                // return $query[$field];
        }
        static function handleCoordinates($filters) {
                $latf = NULL;
                $latt = NULL;
                $longf = NULL;
                $longt = NULL;
                if (isset ( $filters ['latitudeTo'] ))
                        $latt = str_replace ( ",", ".", $filters ['latitudeTo'] );
                if (isset ( $filters ['latitudeFrom'] ))
                        $latf = str_replace ( ",", ".", $filters ['latitudeFrom'] );
                if (isset ( $filters ['longitudeFrom'] ))
                        $longf = str_replace ( ",", ".", $filters ['longitudeFrom'] );
                if (isset ( $filters ['longitudeTo'] ))
                        $longt = str_replace ( ",", ".", $filters ['longitudeTo'] );

                if ($latf == NULL && $latt == NULL) {
                        $latf = -90;
                        $latt = 90;
                } elseif ($latf == NULL && $latt != NULL) {
                        $latf = $latt - 0.10;
                      //  $latf = - 90;
                } elseif ($latf != NULL && $latt == NULL) {
                        $latt = $latf + 0.10;
                      //  $latt = 90;
                }

                if ($longf == NULL && $longt == NULL) {
                        $longf = -180;
                        $longt = 180;
                } elseif ($longf == NULL && $longt != NULL) {
                        $longf = $longt - 0.10;
              //          $longf = - 180;
                } elseif ($longf != NULL && $longt == NULL) {
                        $longt = $longf + 0.10;
                //        $longt = 180;
                }

                return "coordinates:[" . $latf . "," . $longf . " TO " . $latt . "," . $longt . "]";
        }
        static function handleYear($filters) {
                $yearf = 0;
                $yeart = date ( 'Y' );
                if (isset ( $filters ['collectionYearFrom'] ))
                        $yearf = str_replace ( ",", ".", $filters ['collectionYearFrom'] );
                if (isset ( $filters ['collectionYearTo'] ))
                        $yeart = str_replace ( ",", ".", $filters ['collectionYearTo'] );

                return "gatheringyear:[" . $yearf . " TO " . $yeart . "]";
        }
        public static $client;
        /**
         * this fun creates an index query for the search request
         *
         * @param unknown $model
         * @param unknown $selectionLists
         * @param number $pageSize
         * @return SolrQuery - if any value in the form was set, else return false
         */
        public static function createSearchQuery($config) {

                // create a client instance
                SOLRQueryManager::$client = new Solarium\Client ( $config );
                // set the adapter to http
                SOLRQueryManager::$client->setAdapter ( 'Solarium\Core\Client\Adapter\Http' );

                SOLRQueryManager::$client->getPlugin('postbigrequest');
                // get a select query instance
                $query = SOLRQueryManager::$client->createSelect ();

                return $query;
        }

        public static function simpleQuery($query, $queryString, $fq) {
        	$query->setQuery ( $queryString );
        	$query->createFilterQuery ( 'myfilter' )->setQuery ( $fq );
        	$resultset = SOLRQueryManager::$client->select ( $query );
        	return $resultset;
        }

        public static function fillAndExecuteQuery($query, $queryString, $fq, $filters, $details) {
                 Yii::info ( "fillAndExecuteQuery " . $queryString . " and fq: " . $fq);

                // foreach ( $filters as $k => $v )
                // Yii::info ( "fillAndExecuteQuery request param " . $k . ", " . $v );
                $query->setQuery ( $queryString );
                // Note: SOLR starts counting with row 0, page 2 needs to start with row 50 not 51!
                if (isset ( $_GET ['page'] )) {
                        $query->setStart ( Yii::$app->params ['listPerPage'] * ($_GET ['page'] - 1) );
                } else {
                        $query->setStart ( 0 );
                }
                if(Yii::$app->user->isGuest && Yii::$app->params ['maxLinesGuest'])
                $query->setRows ( Yii::$app->params ['maxLinesGuest'] );
                else $query->setRows ( Yii::$app->params ['maxLines'] );

                $filterq = [ ];
                if (isset ( $filters )) {
                        if (sizeof ( $filters ) == 0)
                                $query->createFilterQuery ( 'myfilter' )->setQuery ( $fq );
                        else
                                foreach ( $filters as $key => $value ) {
                                        // Yii::info ( "hop " . $key . "---" . $value );
                                if($key != "locality"  && $key != "collectors"
									&& $key != "collectornumber" && $key != "sequenceaccessionIdentifier" && $key != "fullScientificName" && $key != "country"
                                        && $key != "sea" && $key != "continent" && $key != "ocean" && $key != "geneticlocus") {
                                        $value = str_replace ( " ", "\ ", $value );
                                        $value = str_replace ( "(", "\(", $value );
                                        $value = str_replace ( ")", "\)", $value );
                                        $value = str_replace ( ":", "\:", $value ); }


                                        $filterq [] = SOLRQueryManager::getPartialQuery ( $key, $value, $filters, $details );

                                         Yii::info ( "filterquery " . implode(",",$filterq) );

                                        // }
                                }
                }
                if (isset ( $filterq )) {
                        if (is_array ( $fq )) {
                                $query->createFilterQuery ( 'myfilter_' )->setQuery ( $fq [0] . implode ( " AND ", $filterq ) );
                                if (sizeof ( $fq ) > 1) {
                                        for($i = 1; $i < sizeof ( $fq ); $i ++)
                                                $query->createFilterQuery ( 'myfilter' . $i . '_' )->setQuery ( $fq [$i] );
                                }
                        } else
                                $query->createFilterQuery ( 'myfilter_' )->setQuery ( $fq . implode ( " AND ", $filterq ) );
                }

                // $debug = $query->getDebug ();
                try {
                        $resultset = SOLRQueryManager::$client->select ( $query );
                } catch ( Solarium\Exception\UnexpectedValueException $e ) {
                        $resultset = SOLRQueryManager::$client->select ( $query );
                }
                // $debugResult = $resultset->getDebug ();

                // Yii::info ( 'Querystring: ' . $debugResult->getParsedQuery () );
                // Yii::info ( 'NumFound: ' . $resultset->getNumFound () );
                return $resultset;
        }
        public static function browseQuery($query, $queryString, $fqs, $page, $facetNames) {
                Yii::info ( "browseQuery " . $queryString );

                $query->setQuery ( $queryString );
                // Note: SOLR starts counting with row 0, page 2 needs to start with row 50 not 51!
                if ($page) {
                        $query->setStart ( $page - 1 )->setRows ( Yii::$app->params ['listPerPage'] );
                } else {
                        $query->setStart ( 0 )->setRows ( Yii::$app->params ['listPerPage'] );
                }


                $i = 0;
                if (sizeof ( $fqs ) > 0) {


                        foreach ( $fqs as $fq ) {
                        	$query->addFilterQuery($fq);
                               // $query->createFilterQuery ( 'fq' . $i )->setQuery ( $fq );
                         /*       foreach ( $facetNames as $fname )
                                        if (sizeof ( explode ( $fname, $fq, - 1 ) ) > 0) {
                                                $facetSet->createFacetQuery ( $fname . $i )->setQuery ( $filtering [$i] );
                                        }
                                $i ++; */
                        }
                } else {
                        $fq = "*:*";
                        $query->createFilterQuery ( 'fq' )->setQuery ( $fq );
                }
                $facetSet = $query->getFacetSet ();
                $facetSet->setLimit ( - 1 );
                $facetSet->setMinCount ( 1 );
                $facetSet->setSort ( "false" );
                $filtering = $fqs;
                // create a facet field instance and set options
                foreach ( $facetNames as $fname )

                {  $facetSet->createFacetField ( array('field' => $fname, 'key' => $fname, 'exclude'=>$fname) );


                }
                $request = SOLRQueryManager::$client->createRequest($query);

                // you can now use the request object for getting an uri (ie. to use in you own code)
                // or you could modify the request object
                Yii::info('SOLR Request URI: ' . urldecode($request->getUri()));

                $resultset = SOLRQueryManager::$client->select ( $query );

                return $resultset;
        }

        public static function apiQuery($query, $queryString, $fqs, $facetNames, $outputfields) {
                Yii::info ( "apiQuery " . $queryString. " ".implode(" -- ",$facetNames) );

                $query->setQuery ( $queryString );
                $query->setStart ( 0 );

                $query->setFields ( [$outputfields      ] );

                $facetSet = $query->getFacetSet ();
                $facetSet->setLimit ( - 1 );
                $facetSet->setMinCount ( 1 );
                $facetSet->setSort ( "false" );

                $filtering = $fqs;
//      MARHCE PAS

//                              foreach ( $facetNames as $fname )
//                                              $facetSet->createFacetField ( $fname )->setField ( $fname );

                        $query->createFilterQuery ( 'myfilter' )->setQuery ( $fqs );


                // create a facet field instance and set options
                foreach ( $facetNames as $fname )
                        $facetSet->createFacetField ( $fname )->setField ( $fname );

                $resultset = SOLRQueryManager::$client->select ( $query );
                return $resultset;
        }

        public static function treeQuery($query, $queryString, $fname) {
                // Yii::info ( "treeQuery " . $queryString );
                $query->setQuery ( $queryString );
                $query->setStart ( 0 )->setRows ( Yii::$app->params ['listPerPage'] );

                $facetSet = $query->getFacetSet ();
                $facetSet->setLimit ( - 1 );
                $facetSet->setMinCount ( 1 );
                $facetSet->setSort ( "false" );

                $fq = "*:*";
                $query->createFilterQuery ( 'myfilter' )->setQuery ( $fq );

                // create a facet field instance and set options
                $facetSet->createFacetField ( $fname )->setField ( $fname );

                $resultset = SOLRQueryManager::$client->select ( $query );

                return $resultset;
        }

        public static function loanQuery($query, $queryString, $fqs) {
                $query->setQuery ( $queryString );
                // print ($queryString);
                // Note: SOLR starts counting with row 0, page 2 needs to start with row 50 not 51!
                if (isset ( $_GET ['page'] )) {
                        $query->setStart ( Yii::$app->params ['listPerPage'] * ($_GET ['page'] - 1) );
                } else {
                        $query->setStart ( 0 );
                }

                $query->setRows ( Yii::$app->params ['maxLines'] );
                // generate query string:
                $string = 'tripleidstoreid:(' . implode ( $fqs, ' OR ' ) . ')';
                $query->createFilterQuery ( 'filter1' )->setQuery ( 'tripleidstoreid:(' . implode ( $fqs, ' OR ' ) . ')' ); // anf\FChrungszeichen!
                                                                                                           // $debug = $query->getDebug ();
                $resultset = SOLRQueryManager::$client->select ( $query );
                // $debugResult = $resultset->getDebug ();
                // Yii::info ( 'Querystring: ' . $debugResult->getParsedQuery () );
                // Yii::info ( 'NumFound: ' . $resultset->getNumFound () );
                return $resultset;
        }

        /**
         *
         * @param SolrQuery $criteria
         * @return SolrObject
         */
        public static function getConfigDetails() {
                $config = array (
                                'endpoint' => array (
                                                'bgbm-web01' => array (
                                                				'scheme' => Yii::$app->params['solrServerScheme'],
                                                                'host' => Yii::$app->params ['solrhost'],
                                                                'port' => Yii::$app->params['solrServerPort'],
                                                                'path' => Yii::$app->params ['solrdetails']
                                                )
                                )
                );
                return $config;
        }

        public static function getConfigSearch() {
                $config = array (
                                'endpoint' => array (
                                                'bgbm-web01' => array (
                                                				'scheme' => Yii::$app->params['solrServerScheme'],
                                                                'host' => Yii::$app->params ['solrhost'],
                                                                'port' => Yii::$app->params['solrServerPort'],
                                                                'path' => Yii::$app->params ['solrsearch']
                                                )
                                )
                );
                return $config;
        }

        public static function getConfigPreview() {
                $config = array (
                                'endpoint' => array (
                                                'bgbm-web01' => array (
                                                				'scheme' => Yii::$app->params['solrServerScheme'],
                                                                'host' => Yii::$app->params ['solrhost'],
                                                                'port' => Yii::$app->params['solrServerPort'],
                                                                'path' => Yii::$app->params ['solrpreview']
                                                )
                                )
                );
                return $config;
        }

        public static function getConfigBackbone() {
                $config = array (
                                'endpoint' => array (
                                                'bgbm-web01' => array (
                                                				'scheme' => Yii::$app->params['solrServerScheme'],
                                                                'host' => Yii::$app->params ['solrhost'],
                                                                'port' => Yii::$app->params['solrServerPort'],
                                                                'path' => '/solr/backbone'
                                                )
                                )
                );
                return $config;
        }

        public static function getConfigColTree() {
                $config = array (
                                'endpoint' => array (
                                                'bgbm-web01' => array (
                                                				'scheme' => Yii::$app->params['solrColTreeServerScheme'],
                                                               'host' => Yii::$app->params ['solrColTreeHost'],
                                                               'port' => Yii::$app->params['solrColTreeServerPort'],
                                                               'path' => Yii::$app->params['solrColTreePath']
//	                                             				'scheme' => Yii::$app->params['solrServerScheme'],
//                                                               'host' => Yii::$app->params ['solrhost'],
//                                                               'port' => Yii::$app->params['solrServerPort'],
//                                                               'path' => '/solr/colTree'
                                                )
                                )
                );
                return $config;
        }

        public static function getConfigWebsites() {
                $config = array (
                                'endpoint' => array (
                                                'bgbm-web01' => array (
                                                				'scheme' => Yii::$app->params['solrServerScheme'],
                                                                'host' => Yii::$app->params ['solrhost'],
                                                                'port' => Yii::$app->params['solrServerPort'],
                                                                'path' => Yii::$app->params ['solrwebsites']
                                                )
                                )
                );
                return $config;
        }

        public static function getConfigAlfresco() {
        	$config = array (
        			'endpoint' => array (
        					'alfresco' => array (
        							'scheme' => Yii::$app->params['solrAlfrescoServerScheme'],
        							'host' => Yii::$app->params ['solrAfrescoHost'],
        							'path' => Yii::$app->params ['solrAlfresco'],
        							'port' => Yii::$app->params ['solrAlfrescoPort'],
        							'username' => Yii::$app->params ['solrAlfrescoUsername'],
        							'password' => Yii::$app->params ['solrAlfrescoPassword'],
        					)
        			)
        	);
        	return $config;
        }


        public function performSearchnew($filters, $model, $primaryObject) {
        	var_dump($filters);
        }


        public function performSearch($filters, $model, $primaryObject) {
        	 //Yii::info ( "actionperformSearch" );

        	// we get all the lists for the drop-down lists in the form -- why??
        	$model->collectDropDownAttributesLists ( $model );

        	$submitURL = $model->createUrl ( [
        			'search/create'
        	], $filters );

        	// validate user input
        	if ($model->validate ()) {

        		$config = SOLRQueryManager::getConfigSearch ();
        		$query = SOLRQueryManager::createSearchQuery ( $config );


        		$fq = "";
        		$q = [ ];
        		$filterInstitution = false;
        		$filterVouchercol = false;
        		foreach ( $filters as $key => $value ) {
        			$value = str_replace ( " ", "\ ", $value );
        			$value = str_replace ( "(", "\(", $value );
        			$value = str_replace ( ")", "\)", $value );
        			$value = str_replace ( ":", "\:", $value );

        			//unklar, was das hier ist
        			if ($key == "institution") {
        				$q [] = SOLRQueryManager::getPartialQuery ( $key, $value, $filters, False );
        				$filterInstitution = true;
        			}
        			if ($key == "voucherCol") {
        				$q [] = SOLRQueryManager::getPartialQuery ( $key, $value, $filters, False );
        				$filterVouchercol = true;
        			}
        		}
        		//if (! $filterInstitution && ! $filterVouchercol)
        		$q = [
        				"*:*".Yii::$app->params['thematicSOLRfilter']
        		];
        		$raw_response = SOLRQueryManager::fillAndExecuteQuery ( $query, implode ( " AND ", $q ), $fq, $filters, False );

        		if(Yii::$app->params['siteName'] == 'evoboga' && Yii::$app->user->isGuest) {

        		$CustomizedFacets = SOLRQueryManager::CustomizedFacetsListView($query, $config, $q, $fq); }
        		else { $CustomizedFacets = ""; }

        		$backboneaccepted = "";
        		$backbonefullname = "";
        		//   foreach($raw_response as $backbonedisplay)
        		//   { $backboneaccepted = $backbonedisplay->backboneaccepted;
        		//       $backbonefullname = $backbonedisplay->backbonefullname; }

        		$q[]="isLowest:1";
        		$query2 = SOLRQueryManager::createSearchQuery ( $config );
        		$raw_responseCounts = SOLRQueryManager::fillAndExecuteQuery ( $query2, implode ( " AND ", $q ), $fq, $filters, False );

        		$tripleidstoreids=[];
        		foreach($raw_response as $document){
        			$tripleidstoreids = array_merge($tripleidstoreids, $document->lowestTripleIDs);
        		}
        		$tripleidstoreids=array_unique($tripleidstoreids);


        		$config = SOLRQueryManager::getConfigPreview();
        		$query = SOLRQueryManager::createSearchQuery ( $config );
        		//$q = "tripleidstoreid:(".implode(" OR ", $tripleidstoreids).")";

        		if(sizeof($tripleidstoreids)>0){
        			$q = "tripleidstoreid:(".implode(" OR ", $tripleidstoreids).")";
        		}
        		else $q="";
        		//echo $q;
        		$raw_response = SOLRQueryManager::fillAndExecuteQuery ( $query, $q , $fq, [], False );
        		$doc = $raw_response->getDocuments ();
        		$numFoundTotal = $raw_responseCounts->getNumFound ();
        		$numFound = $raw_response->getNumFound ();


        		$ids = [ ];
        		foreach ( $raw_response as $id ) {
        			$ids [] = $id->tripleidstoreid;
        		}

        		// Repeat query because Solr won't permit queries with more OR clauses, didn't find a better solution :(
        		// Executed in batches of 200
        		$SOLR_QUERY_CONSTANT = 200;
        		$shoppingArray = [ ];
        		if(! Yii::$app->user->isGuest && Yii::$app->params ['shopping'] = true){
        			for($i = 0; $i < ceil ( count ( $ids ) / $SOLR_QUERY_CONSTANT ); $i ++) {
        				$config = SOLRQueryManager::getConfigDetails ();
        				$query1 = SOLRQueryManager::createSearchQuery ( $config );
        				$loanStatus = SOLRQueryManager::loanQuery ( $query1, "*:*", array_slice ( $ids, $i * $SOLR_QUERY_CONSTANT, $SOLR_QUERY_CONSTANT ) );

        				foreach ( $loanStatus as $l ) {
        					$shoppingArray [$l->tripleidstoreid] = $l;
        				}

        			}
        		}

        		$shopM = new CartForm ();
        		if (Yii::$app->params ['useLogin']  && ! Yii::$app->user->isGuest) {
        			$shoppingCart = sizeof ( DBInterface::getShoppingCart ( Yii::$app->user->identity->id ) );
        		} else {
        			$shoppingCart = '';
        		}
        		$multiUnitsM = new MultiunitsForm ();
        		$multiUnitsCart = Yii::$app->session['listView'];

        		if (Yii::$app->params['logUsageStats']) {   // Logging Usage Statistics

        			$piwikSiteID = Yii::$app->params['piwikSiteID'];
        			$fullUrl = addslashes(str_replace("www.","" , urldecode(Yii::$app->request->HostName.Yii::$app->request->baseUrl."/".Yii::$app->request->pathInfo."?".Yii::$app->request->queryString)));
        			$queryString = addslashes(urldecode(Yii::$app->request->queryString));
        			$serverTime = date('Y-m-d h:i:s');

        			$actionresult = "INSERT INTO log_action_visitor (server_time, url, hash, piwiksiteid, query_terms, hits)
        			VALUES ('$serverTime','$fullUrl', CRC32('$fullUrl'), $piwikSiteID, '$queryString', $numFoundTotal)";
        			Yii::$app->usageStats->createCommand($actionresult)->execute();
        			$idaction = Yii::$app->usageStats->getLastInsertID();

        			foreach ($doc as $actiondetails) {

        				$actionrecords = "INSERT IGNORE INTO log_action_records (unitID, collectionCode, institutionCode, guid, institution)
        				VALUES ('$actiondetails->unitID', '$actiondetails->collectioncode', '$actiondetails->institutioncode', '$actiondetails->guid', '$actiondetails->institution')";
        				Yii::$app->usageStats->createCommand($actionrecords)->execute();
        				$recordids = "SELECT idrecord FROM log_action_records WHERE unitID='$actiondetails->unitID' AND collectionCode = '$actiondetails->collectioncode'";
        				$getRecordIDs = Yii::$app->usageStats->createCommand($recordids)->queryAll();
        				$idrecord = $getRecordIDs[0]['idrecord'];

        				$actiondetail = "INSERT INTO log_actionrecords_visitor (idaction, idrecord)
        				VALUES ($idaction, $idrecord)";
        				Yii::$app->usageStats->createCommand($actiondetail)->execute();
        			}
        		}


        		return array (
        				"model" => $model,
        				'response' => $doc,
        				'backboneaccepted' => $backboneaccepted,
        				'backbonefullname' => $backbonefullname,
        				'keyForLink' => $model->key_link,
        				'recordFilters' => $model->recordFilters,
        				'item_count' => $numFound,
        				'item_count_total' => $numFoundTotal,
        				'selectionLists' => $model->_selectionlists,
        				'submitURL' => $model->submitURL,
        				'filters' => $filters,
        				'shopping' => $shoppingArray,
        				'shopM' => $shopM,
        				'shoppingCart' => $shoppingCart,
        				'multiUnitsCart'=>$multiUnitsCart,
        				'multiUnitsM'=>$multiUnitsM,
        				'facetNumbers'=>$CustomizedFacets,
        				'primaryObject' => $primaryObject
        		) ;


        	} else {
        		$errors = $model->errors;
        		return array (
        				"model" => $model,
        				"filters" => $filters,
        				"errors" => $errors
        		);
        	}
        }


        public function CustomizedFacetsListView($query, $config, $q, $fq)
        {

        	$facetnames = [];
        	$facetnames  = ['originalCanonicalName'];
        	$facetnames [] = 'rank';
        	$facetnames [] = 'institution';
        	$facetnames [] = 'ipen';
        	$facetnames [] = 'hasImage';


        	$raw_responseFacet = SOLRQueryManager::apiQuery ( $query, implode ( " AND ", $q ), $fq, $facetnames, "[]" );
        	$facetScientificNames = $raw_responseFacet->getFacetSet ()->getFacet ( "originalCanonicalName" );

        	$content_array = array (
        			"name" => array (),
        			"namerank" => array (),
        			"nbInstitution" => array (),
        			"nbRecords" => array (),
        			"nbIpen" => array (),
        			'nbImage' => array ()
        	);
        	$countScientificName = count($facetScientificNames);

        	//for($i = 0, $count = count($facetScientificNames); $i < 100; $i++) {
        	foreach($facetScientificNames as $name => $count)

        	{
        		$configFacet = SOLRQueryManager::getConfigSearch ();
        		$queryFacet = SOLRQueryManager::createSearchQuery ( $configFacet );
        		$fqFacet = "*:*";

        		$qFacet = 'originalCanonicalName:"'.$name.'" AND accessionStatus:C';


        		$raw_responseFacet2 = SOLRQueryManager::apiQuery ( $queryFacet, $qFacet, $fqFacet, $facetnames, "[]" );

        		$rankValue = "";
        		$nb1 = "";
        		$nb2 = "";
        		$nb3 = "";

        		if(null != ($raw_responseFacet2->getFacetSet ()->getFacet ( "institution" )))
        		{ $f1 = $raw_responseFacet2->getFacetSet ()->getFacet ( "institution" );
        		$nb1 = 0;
        		foreach ( $f1 as $ff ) {
        			$nb1 += 1;
        		}
        		$facetNumbers ['nbInstitution'] = $nb1;
        		} else {$nb1 = ""; }

        		$facetNumbers ['nbRecords'] = $count;


        		$facetNumbers ['name'] = $name;

        		//var_dump($raw_responseFacet2->getFacetSet ()->getFacet ( "hasImage" ))."</br>";

        		if(($raw_responseFacet2->getFacetSet ()->getFacet ( "hasImage" )) != null)
        		{ $f3 = $raw_responseFacet2->getFacetSet ()->getFacet ( "hasImage" );
        		$test[] = $f3;
        			if(array_key_exists('1', $test))
        			{ $nb3 = "Yes"; }

        			else {$nb3 = "No"; }

        			$facetNumbers ['nbImage'] = $nb3;

        		}


        		if(null != ($raw_responseFacet2->getFacetSet ()->getFacet ( "ipen" )))
        		{ $f2 = $raw_responseFacet2->getFacetSet ()->getFacet ( "ipen" );
        		$nb2 = 0;
        		foreach ( $f2 as $ff ) {
        			$nb2 += 1;
        		}
        		$facetNumbers ['nbIpen'] = $nb2;
        		} else { $nb2 = ""; }

        		if(null !== ($raw_responseFacet2->getFacetSet ()->getFacet ( "rank" )))
        		{ $f3 = $raw_responseFacet2->getFacetSet ()->getFacet ( "rank" );

        		foreach ($f3 as $keyRank => $countrank) {
        			$rankValue = $keyRank;
        			$facetNumbers ['rank'] = $rankValue;
        		}


        		} else { $rankValue = ""; }

        		array_push($content_array['name'],$name);
        		array_push($content_array['namerank'],$rankValue);
        		array_push($content_array['nbInstitution'],$nb1);
        		array_push($content_array['nbRecords'],$count);
        		array_push($content_array['nbIpen'],$nb2);
        		array_push($content_array['nbImage'],$nb3);
        	}
				return $content_array;
        }


}
?>