<?php
namespace App\Controller;

use App\Controller\AppController;
use Cake\ORM\TableRegistry;
use FPDF;

/**
 * Documents Controller
 *
 * @property \App\Model\Table\DocumentsTable $Documents
 * @property \Cake\ORM\Association\BelongsTo $TypeDocuments
 */
class DocumentsController extends AppController
{

	/**
	 * @param $user
	 *
	 * Give authorization for documents
	 *
	 * @return boolean
	 */
	public function isAuthorized($user)
	{
		$configuration = TableRegistry::get('Configurations')->find()->where(['id =' => 1])->first();
		$role = TableRegistry::get('Users')->find()->where(['username' => $user[$configuration->authentificationType_ldap][0]])->first()['role'];
		$action = $this->request->params['action'];
		
		// Super-Admin peut accéder à chaque action
		if($role == 'Super Administrateur') return true;
		
		if (in_array($action, ['admission', 'sortie'])) {
			if ($this->userHasRole('Administration')) {
				return true;
			}
		}
		
		if(in_array($action, ['delete', 'edit'])) {
			if ($this->userHasRole('Administration')) {
				return true;
			}
			$u = TableRegistry::get('Users')->find()->where(['username' => $user[$configuration->authentificationType_ldap][0]])->first();
			
			$doc = $this->Documents->get((int)$this->request->params['pass'][0]);
			
			$id = $doc->get('materiel_id');
			if(empty($id)) {
				$id = $doc->get('suivi_id');
				$suiviTable = TableRegistry::get('Suivis');
				if ($role == 'Responsable') {
					return ($suiviTable->exists(['id' => $id, 'groupes_metier_id' => $u['groupes_metier_id']]) || $suiviTable->exists(['id' => $id, 'groupes_thematique_id' => $u['groupe_thematique_id']]));
				}
				if ($role == 'Utilisateur') {
					return $suiviTable->exists(['id' => $id, 'nom_createur' => $user['givenname'][0].' '.$user['sn'][0]]);
				}
			} else {
				$materielTable = TableRegistry::get('Materiels');
				if ($role == 'Responsable') {
					return ($materielTable->exists(['id' => $id, 'groupes_metier_id' => $u['groupes_metier_id']]) || $materielTable->exists(['id' => $id, 'groupes_thematique_id' => $u['groupe_thematique_id']]));
				}
				if ($role == 'Utilisateur') {
					return ($materielTable->exists(['id' => $id, 'nom_createur' => $user['givenname'][0].' '.$user['sn'][0]]) || $materielTable->exists(['id' => $id, 'nom_responsable' => $user['givenname'][0].' '.$user['sn'][0]]));
				}		
			}	
		}

		//Pour tout le monde
		if (in_array($action, ['view', 'add', 'ficheMateriel'])) return true;
		
		return false;
	}
	
    /**
     * Index method
     *
     * @return \Cake\Network\Response|null
     */
    public function index()
    {
    	$this->paginate = [
    			'contain' => ['TypeDocuments'],
    	];
        $documents = $this->paginate($this->Documents);

        $materiel = $this->Documents->Materiels;
        
        $this->set(compact('documents', 'materiel'));
        $this->set('_serialize', ['documents']);
    }

    /**
     * View method
     *
     * @param string|null $id Document id.
     * @return \Cake\Network\Response|null
     * @throws \Cake\Datasource\Exception\RecordNotFoundException When record not found.
     */
    public function view($id = null)
    {
        $document = $this->Documents->get($id, [
            'contain' => ['TypeDocuments']
        ]);

        $materiel = $this->Documents->Materiels->find()->where(['id =' => $document->materiel_id])->first();

        if($materiel != null) {
        	$this->set('materiel', $materiel);
        }
        else {
        	$suivi = $this->Documents->Suivis->find()->where(['id =' => $document->suivi_id])->first();
        	$this->set('suivi', $suivi);
        }
       
        $this->set('document', $document);
        $this->set('_serialize', ['document']);
    }

    /**
     * Add method
     *
     * @return \Cake\Network\Response|void Redirects on successful add, renders view otherwise.
     */
    public function add()
    {
        $document = $this->Documents->newEntity();
        
        if ($this->request->is('post')) {
            $document = $this->Documents->patchEntity($document, $this->request->data);

            $nomType = $this->Documents->TypeDocuments->find()->where(['id =' => $document->type_document_id])->first()['nom'];      

            if(isset($this->passedArgs[2]) && $this->passedArgs[2] == 'photo') {
            	$document->set('photo', 1);
            }

            if ($this->Documents->save($document)) {
                $this->Flash->success(__('Le fichier a bien été ajouté.'));
                
                $id = $document->materiel_id;
                if(!empty($id)) {
					$materielTable = TableRegistry::get('Materiels');
                	$materiel = $materielTable->get($id);
                }
                
                if(isset($this->passedArgs[2]) && $this->passedArgs[2] == 'photo') {

                	$photoIdOld = $materiel->get('photo_id');
                	if(isset($photoIdOld)) {
                		$docOld = TableRegistry::get('Documents')->get($photoIdOld);
                		$this->Documents->delete($docOld);
                	}
                
                	$materiel->set('photo_id', $document->id);
                	$materielTable->save($materiel);
                }
                
                $userName = $this->LdapAuth->user('sn')[0].' '.$this->LdapAuth->user('givenname')[0];
                $userEmail = $this->LdapAuth->user('mail')[0];

                $id = $document->materiel_id;
                if(empty($id)) {
                	$id = $document->suivi_id;
                	$this->sendEmailToManagementWith('[LabInvent] Ajout d\'un document', $userName.' (email = '.$userEmail.') a ajouté un document de type "'.$nomType.'" au suivi "Suivi '.$document->suivi_id.'".');
                	return $this->redirect(['controller' => 'suivis', 'action' => 'view', $id]);
                } else {
                	$this->sendEmailToManagementWith('[LabInvent] Ajout d\'un document', $userName.' (email = '.$userEmail.') a ajouté un document de type "'.$nomType.'" au matériel "'.$materiel->designation.'" (id = '.$materiel->id.').');
                	return $this->redirect(['controller' => 'materiels', 'action' => 'view', $id]);
                }
                
            } else {
                $this->Flash->error(__('Le fichier n\'a pas pu être ajouté.'));
            }
        }
        
        if(isset($this->passedArgs[1]) && $this->passedArgs[1] == 'mat') {
        	$materiel = $this->Documents->Materiels->find('list', [ 'keyField' => 'id', 'valueField' => 'numero_laboratoire'])->where(['id =' => $this->passedArgs[0]]);
        	$this->set('materiel', $materiel);
        }
        else {
        	$suivi = $this->Documents->Suivis->find('list', [ 'keyField' => 'id', 'valueField' => 'id'])->where(['id =' => $this->passedArgs[0]]);
        	$this->set('suivi', $suivi);
        }
        
        if(isset($this->passedArgs[2]) && $this->passedArgs[2] == 'photo') {
        	$this->set('photo', 1);
        	$typesD = $this->Documents->TypeDocuments->find('list', [ 'keyField' => 'id', 'valueField' => 'nom'])->where(['nom =' => 'Photo']);
        	$idType = $this->Documents->TypeDocuments->find()->where(['nom =' => 'Photo'])->first()['id'];
        	$this->set('idType', $idType);
        } else {
        	$typesD = $this->Documents->TypeDocuments->find('list', [ 'keyField' => 'id', 'valueField' => 'nom', 'order' => 'TypeDocuments.nom']);
        }  
        
        
        $this->set(compact('document', 'typesD'));
        $this->set('_serialize', ['document']);
    }

    /**
     * EDit method
     *
     * @return \Cake\Network\Response|void Redirects on successful edit, renders view otherwise.
     */
    public function edit($id = null)
    {
    	$document = $this->Documents->get($id, [
    			'contain' => []
    	]);
    
    	if ($this->request->is(['patch', 'post', 'put'])) {
    		$document = $this->Documents->patchEntity($document, $this->request->data);
    
    		if ($this->Documents->save($document)) {
    			$this->Flash->success(__('Le fichier a bien été edité.'));
        
    			$id = $document->materiel_id;
    			if(empty($id)) {
    				$id = $document->suivi_id;
    				return $this->redirect(['controller' => 'suivis', 'action' => 'view', $id]);
    			} else {
    				return $this->redirect(['controller' => 'materiels', 'action' => 'view', $id]);
    			}
    
    		} else {
    			$this->Flash->error(__('Le fichier n\'a pas pu être edité.'));
    		}
    	}
    	
    	$id = $document->materiel_id;
    	if(empty($id)) {
    		$id = $document->suivi_id;
    		$suivi = $this->Documents->Suivis->find('list', [ 'keyField' => 'id', 'valueField' => 'id'])->where(['id =' => $id]);
    		$this->set('suivi', $suivi);
    	} else {
    		$materiel = $this->Documents->Materiels->find('list', [ 'keyField' => 'id', 'valueField' => 'numero_laboratoire'])->where(['id =' => $id]);
    		$this->set('materiel', $materiel);
    	}
    
    	if($document->photo) {
    		$this->set('photo', 1);
    	}
    	 
    
    	$typesD = $this->Documents->TypeDocuments->find('list', [ 'keyField' => 'id', 'valueField' => 'nom', 'order' => 'TypeDocuments.nom']);
    
    	$this->set(compact('document', 'typesD'));
    	$this->set('_serialize', ['document']);
    }

    /**
     * Delete method
     *
     * @param string|null $id Document id.
     * @return \Cake\Network\Response|null Redirects to index.
     * @throws \Cake\Datasource\Exception\RecordNotFoundException When record not found.
     */
    public function delete($id = null)
    {
        $this->request->allowMethod(['post', 'delete']);
        $document = $this->Documents->get($id);
        
        if($document->photo) {
        	$materielTable = TableRegistry::get('Materiels');
        	$materiel = $materielTable->get($document->materiel_id);
        	
        	$materiel->set('photo_id', null);
        	$materielTable->save($materiel);
        }
        
        if ($this->Documents->delete($document)) {
            $this->Flash->success(__('Le fichier a bien été supprimé.'));
        } else {
            $this->Flash->error(__('Le fichier n\'a pas pu être supprimé.'));
        }
        
        $id = $document->materiel_id;
        if(empty($id)) {
        	$id = $document->suivi_id;
        	return $this->redirect(['controller' => 'suivis', 'action' => 'view', $id]);
        } else {
        	return $this->redirect(['controller' => 'materiels', 'action' => 'view', $id]);
        }
    }
    
    
    public function sortie($labNumber) {   
    	$this->set('fpdf', new FPDF ( 'P', 'mm', 'A4' ));
    }
    
    public function admission($labNumber) {
    	
    	$this->set ( 'fpdf', new FPDF ( 'P', 'mm', 'A4' ) );
    	// Find the concerned materiel
    	$materiel = TableRegistry::get('Materiels')->find('all', ['conditions' => ['numero_laboratoire' => $labNumber]])->first(); // End find
    	
    	// Get the administration user name
    	$userName = $this->LdapAuth->user('username');
    	$numeroLab = $materiel->numero_laboratoire;
    	$dateAcquisition = $materiel->date_acquisition;
    	$dateAcquisition = $dateAcquisition;
    	$numeroCommande = $materiel->numero_commande;
    	$designation = $materiel->designation;
    	if(isset($materiel->organisme_id) && !empty($materiel->organisme_id)) {
    		$organisme = TableRegistry::get('Organismes')->find('all')->where(['id =' => $materiel->organisme_id])->first()->nom;
    	}
    	else {
    		$organisme = "";
    	}

    	$fournisseur = $materiel->fournisseur;
    	$numeroOrganisme = $materiel->numero_inventaire_organisme;
    	$eotp = $materiel->eotp;
    	$prix = $materiel->prix_ht;
    
    	// Build the data array
    	$TDoc = [
    			'organisme' => $organisme,
    			'numlab' => $numeroLab,
    			'designation' => $designation,
    			'dateAcquis' => $dateAcquisition,
    			'numCde' => $numeroCommande,
    			'fournisseur' => $fournisseur,
    			'eotp' => $eotp,
    			'prix' => $prix,
    			'numOrg' => $numeroOrganisme
    	];
    
    	// set the data for the document (accessible par $data dans le document)
    	$this->set ( 'data', $TDoc );
    
    } // End fct admission
    
    public function ficheMateriel($labNumber) {
    	
    	// Find the concerned materiel
    	$materiel = TableRegistry::get('Materiels')->find('all', ['conditions' => ['numero_laboratoire' => $labNumber]])->first(); // End find
    	
    	if(isset($materiel->sur_categorie_id)) {
    		$surCategorie = TableRegistry::get('SurCategories')->find()->where(['id =' => $materiel->sur_categorie_id])->first()->nom;
    	}
    	else {
    		$surCategorie = ' ';
    	}
    	
    	if(isset($materiel->categorie_id)) {
    		$categorie = TableRegistry::get('Categories')->find()->where(['id =' => $materiel->categorie_id])->first()->nom;
    	}else {
    		$categorie = ' ';
    	}
    	
    	if(isset($materiel->sous_categorie_id)) {
    		$sousCategorie = TableRegistry::get('SousCategories')->find()->where(['id =' => $materiel->sous_categorie_id])->first()->nom;
    	}else {
    		$sousCategorie = ' ';
    	}
    	
    	if(isset($materiel->groupes_thematique_id)) {
    		$groupesThematique = TableRegistry::get('GroupesThematiques')->find()->where(['id =' => $materiel->groupes_thematique_id])->first()->nom;
    	}else {
    		$groupesThematique = ' ';
    	}
    	
    	if(isset($materiel->groupes_metier_id)) {
    		$groupesMetier = TableRegistry::get('GroupesMetiers')->find()->where(['id =' => $materiel->groupes_metier_id])->first()->nom;
    	}else {
    		$groupesMetier = ' ';
    	}
    	
    	if(isset($materiel->organisme_id)) {
    		$organisme = TableRegistry::get('Organismes')->find()->where(['id =' => $materiel->organisme_id])->first()->nom;
    	}else {
    		$organisme = ' ';
    	}
    	
    	if(isset($materiel->site_id)) {
    		$site = TableRegistry::get('Sites')->find()->where(['id =' => $materiel->site_id])->first()->nom;
    	}else {
    		$site = ' ';
    	}

    	 
    	
    	// set the data materiel for the document (accessible par $materiel dans le document)
    	$this->set(compact('materiel', 'surCategorie', 'categorie', 'sousCategorie', 'groupesThematique', 'groupesMetier', 'organisme', 'site'));
    	$this->set ( 'fpdf', new FPDF ( 'P', 'mm', 'A4' ) );
    } 
    
}