<?php
namespace App\Controller;

use App\Controller\AppController;
use Cake\ORM\TableRegistry;
/**
 * EssayTest Controller
 *
 * @property \App\Model\Table\EssayTestTable $EssayTest
 */
class EssayTestController extends AppController
{

    /**
     * Index method
     *
     * @return \Cake\Network\Response|null
     */
    public function index()
    {
        $condition=[];//z['delete'=>0];
        if($this->Auth->user('category') != 0){
            $condition['Freelancers.category_id']=$this->Auth->user('category');
        }
        if ($this->request->query) {
            $filter = 1;
            if (!empty($this->request->query['category'])) {
                $newCondition['Freelancers.category_id '] = $this->request->query['category'];
                $condition['and'] = $newCondition;
            }
            if (!empty($this->request->query['freelancer'] != '')) {
                $newCondition['Freelancers.name like'] = '%' . $this->request->query['freelancer'] . '%';
                $condition['and'] = $newCondition;
            }
            if (!empty($this->request->query['exam_status'])) {
                if($this->request->query['exam_status']== 3){
                    $examStatus=0;
                }
                $examStatus=$this->request->query['exam_status'];
                $newCondition['EssayTest.result'] = $examStatus;
                $condition['and'] = $newCondition;
            }
            if(!empty($this->request->query['datefilter'])){
                $datefilter = explode('-', $this->request->query['datefilter']);
                $startDate = date('Y-m-d',strtotime($datefilter[0]));
                $endDate = date('Y-m-d',strtotime($datefilter[1]));
                $condition['EssayTest.created <='] = $endDate;
                $condition['EssayTest.created >='] = $startDate;
            }          
        }
        $this->paginate = [
            'contain' => ['Freelancers'],
            'conditions'=>$condition,
            'order'=>'EssayTest.id desc'

         ];
         
        // $essayCount = $this->EssayTest->find('all', array(
        //     'fields'=> ['total'=>'count(EssayTest.id)','pending' =>'SUM(CASE WHEN `reg_stage` = 3  THEN 1 ELSE 0 END)','pass' =>'SUM(CASE WHEN `reg_stage` = 4  THEN 1 ELSE 0 END)','fail' =>'SUM(CASE WHEN `reg_stage` = 5  THEN 1 ELSE 0 END)'],
        //     'contain' => ['Freelancers'],
        //     // 'conditions'=>['status'=>1,'email_verify'=>1]
        // ))->first();
        $essayCount = $this->EssayTest->find('all', array(
            'fields'=> ['total'=>'count(EssayTest.id)','pending' =>'SUM(CASE WHEN `result` = 0  THEN 1 ELSE 0 END)','pass' =>'SUM(CASE WHEN `result` = 1  THEN 1 ELSE 0 END)','fail' =>'SUM(CASE WHEN `result` = 2  THEN 1 ELSE 0 END)'],
            'contain' => ['Freelancers'],
            // 'conditions'=>['delete'=>0]
        ))->first();
        // $essayCount = $this->paginate($essayCount)->first();
        $essayTest = $this->paginate($this->EssayTest);
        // dd($this-> EssayTest->find('all')->toArray   ());
        // // $testData= TableRegistry::get('CategoryToFreelancer')->find('all')->where(['category_id'=>$essayTest->category_id,'freelancer_id'=>$essayTest->freelancer->id])->first();

        $this->set(compact('essayTest','essayCount'));
        $this->set('_serialize', ['essayTest']);
    }

    /**
     * View method
     *
     * @param string|null $id Essay Test id.
     * @return \Cake\Network\Response|null
     * @throws \Cake\Datasource\Exception\RecordNotFoundException When record not found.
     */
    public function view($id = null)
    {
        $essayTest = $this->EssayTest->get($id, [
            'contain' => ['Freelancers']
        ]);
        $testData= TableRegistry::get('CategoryToFreelancer')->find('all')->where(['category_id'=>$essayTest->category_id,'freelancer_id'=>$essayTest->freelancer->id])->first();
        // dd($catTest);
        if ($essayTest->view == 0) {
            $fls = TableRegistry::get('EssayTest');
            $fl = $fls->get($essayTest->id);
            $fl->view = 1;
            $fls->save($fl);
        }
        $this->set(compact('essayTest','testData'));
        $this->set('_serialize', ['essayTest']);
    }

    /**
     * Add method
     *
     * @return \Cake\Network\Response|null Redirects on successful add, renders view otherwise.
     */
    public function add()
    {
        $essayTest = $this->EssayTest->newEntity();
        if ($this->request->is('post')) {
            $essayTest = $this->EssayTest->patchEntity($essayTest, $this->request->data);
            if ($this->EssayTest->save($essayTest)) {
                $this->Flash->success(__('The essay test has been saved.'));

                return $this->redirect(['action' => 'index']);
            }
            $this->Flash->error(__('The essay test could not be saved. Please, try again.'));
        }
        $freelancers = $this->EssayTest->Freelancers->find('list', ['limit' => 200]);
        $this->set(compact('essayTest', 'freelancers'));
        $this->set('_serialize', ['essayTest']);
    }

    /**
     * Edit method
     *
     * @param string|null $id Essay Test id.
     * @return \Cake\Network\Response|null Redirects on successful edit, renders view otherwise.
     * @throws \Cake\Network\Exception\NotFoundException When record not found.
     */
    public function edit($id = null)
    {
        $essayTest = $this->EssayTest->get($id, [
            'contain' => []
        ]);
        if ($this->request->is(['patch', 'post', 'put'])) {
            $essayTest = $this->EssayTest->patchEntity($essayTest, $this->request->data);
            if ($this->EssayTest->save($essayTest)) {
                $this->Flash->success(__('The essay test has been saved.'));

                return $this->redirect(['action' => 'index']);
            }
            $this->Flash->error(__('The essay test could not be saved. Please, try again.'));
        }
        $freelancers = $this->EssayTest->Freelancers->find('list', ['limit' => 200]);
        $this->set(compact('essayTest', 'freelancers'));
        $this->set('_serialize', ['essayTest']);
    }

    /**
     * Delete method
     *
     * @param string|null $id Essay Test 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']);
        $essayTest = $this->EssayTest->get($id);
        $essayTest->delete_status = 1;
        $essayTest->delete_by = $this->Auth->user('id');
        // if ($this->EssayTest->delete($essayTest)) {
        if ($this->EssayTest->save($essayTest)) {
            $this->Flash->success(__('The essay test has been deleted.'));
        } else {
            $this->Flash->error(__('The essay test could not be deleted. Please, try again.'));
        }

        return $this->redirect(['action' => 'index']);
    }
}