<?php
namespace App\Http\Controllers\admin;

use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use App\Subscription_packages;
use DB;
use Illuminate\Support\Facades\Input;

class Subscription_packagesController extends Controller
{
    public function __construct(){
        $this->subscription_packages = new \App\admin\Subscription_packages;
    }

    public $v_fields=array('subscription_packages.name', 'subscription_packages.description', 'subscription_packages.no_of_logins', 'subscription_packages.cost', 'subscription_packages.tax', 'subscription_packages.status');
    public $allow_image = array('png', 'jpg', 'jpeg', 'gif');

    public function index(Request $request){
        $sortBy='';
        $order = '';
        $searchBy='';
        $searchValue='';
        $_GET['searchValue']=$_GET['searchValue']??"";
        // order
        if(isset($_GET['sortBy']) && in_array($_GET['sortBy'], $this->v_fields)){
            $sortBy=$_GET['sortBy'];
            $order = isset($_GET['order']) && $_GET['order']=='asc'?'asc':'desc';
            if(isset($_GET['order']) && $_GET['order']!=''){
                $_GET['order']=$_GET['order']=='asc'?'desc':'asc';
            } else{
                $_GET['order']='desc';
            }
        }

        // create links for field
        $get_q = $_GET;
        foreach ($this->v_fields as $key => $value) {
          $get_q['sortBy'] = $value;
          $get_q['page']=1;
          $query_result = http_build_query($get_q);
          $links[$value.'_link'] =url('/').'/admin/subscription_packages?'.$query_result;
        }
        $links['csvlink'] = url('/').'/admin/subscription_packages/export/csv?'.$_SERVER['QUERY_STRING'];
        $links['pdflink'] = url('/').'/admin/subscription_packages/export/pdf?'.$_SERVER['QUERY_STRING'];

        // pagination per page
        $per_page = isset($_GET['per_page'])?$_GET['per_page']:10;

        // search value
        if(isset($_GET['searchBy']) && in_array($_GET['searchBy'], $this->v_fields) && $_GET['searchValue']!=''){
            $searchBy=$_GET['searchBy'];
            $searchValue = $_GET['searchValue'];
        }

        // get by modal
        /*$subscription_packages = new \App\admin\Subscription_packages;*/
        $data = $this->subscription_packages->getSubscription_packagesData($per_page, $searchBy, $searchValue, $sortBy, $order);

        return view('admin/subscription_packages/index', ['data'=>$data->appends(Input::except('page')), 'per_page'=>$per_page, 'links'=>$links]);
    }



    public function getAdd(Request $request){
        /*$subscription_packages = new \App\admin\Subscription_packages;*/
        $data = array();
        
    	return view('admin/subscription_packages/add', $data);
    }

    public function postEdit(Request $request){

        $this->validate($request, [
            
        ]);

        /*$subscription_packages = new \App\admin\Subscription_packages;*/
        if($this->subscription_packages->updateSubscription_packages($request)){
            
            $request->session()->flash('message', 'Subscription_packages Updated successfully!');
            return redirect()->action('admin\Subscription_packagesController@index');
        } else{
            $request->session()->flash('message', 'Error: Invalid record!');
            return redirect()->action('admin\Subscription_packagesController@index');
        }
    }

    public function postAdd(Request $request){

        $this->validate($request, [
            
        ]);

        /*$subscription_packages = new \App\admin\Subscription_packages;*/

        $insert_id = $this->subscription_packages->addSubscription_packages($request);

        
             
       

        $request->session()->flash('message', 'Subscription_packages added successfully!');
        return redirect()->action('admin\Subscription_packagesController@index');
    }

    public function getEdit($id=''){
        
        /*$subscription_packages = new \App\admin\Subscription_packages;*/
        $data = array();

        
        
        $data['data'] = $this->subscription_packages->getSubscription_packages($id);
        if(count($data)){
            return view('admin/subscription_packages/edit', $data);
        } else{
            return view('admin/subscription_packages/edit');
        }
    }

    public function view($id){
        /*$subscription_packages = new \App\admin\Subscription_packages;*/
        $data['data'] = $this->subscription_packages->getSubscription_packagesView($id);
        
        
        if(count($data)){
            return view('admin/subscription_packages/view', $data);
        } else{
            return view('admin/subscription_packages/view');
        }
    }

    public function status(Request $request, $field, $id){
        /*$subscription_packages = new \App\admin\Subscription_packages;*/
        $flag = $this->subscription_packages->changeStatus($field, $id);
        // $redirect = $_GET["redirect"];
        if($flag){
            $request->session()->flash('message', 'Status changed successfully!');
            // return redirect($redirect);
            return redirect()->action('admin\Subscription_packagesController@index');
        } else{
            $request->session()->flash('message', 'Invalid id!');
            return redirect()->action('admin\Subscription_packagesController@index');
        }
    }

    public function delete(Request $request){
    	$id = $request->input('sub_id');
        /*$subscription_packages = new \App\admin\Subscription_packages;*/
        $flag = $this->subscription_packages->deleteOne($id);
        if($flag){
            $request->session()->flash('message', 'Subscription_packages deleted successfully!');
            if($request->input('redirect')!=''){
                return redirect(urldecode($request->input('redirect')));
            } else{
                return redirect()->action('admin\Subscription_packagesController@index');
            }
        } else{
            $request->session()->flash('message', 'Invalid id!');
            return redirect()->action('admin\Subscription_packagesController@index');
        }
    }

    public function deleteAll(Request $request)
    {
        $allIds = $request->input('allIds');
        $flag = false;
        /*$subscription_packages = new \App\admin\Subscription_packages;*/
        for($i=0; $i<count($allIds); $i++)
        {
            if($allIds[$i]!="")
            {
                $id = $allIds[$i];
                $flag = $this->subscription_packages->deleteOne($id);                
            }
        }

        if($flag){
            $request->session()->flash('message', 'Demo deleted successfully!');
        }
    }

    public function getExport($type){
        $sortBy='';
        $order = '';
        $searchBy='';
        $searchValue='';

        // search query
        if(isset($_GET['searchBy']) && in_array($_GET['searchBy'], $this->v_fields) && $_GET['searchValue']!=''){
            $searchBy = $_GET['searchBy'];
            $searchValue = $_GET['searchValue'];
        }

        // sort by
        if(isset($_GET['sortBy']) && in_array($_GET['sortBy'], $this->v_fields)){
            $sortBy=$_GET['sortBy'];
            $order = isset($_GET['order']) && $_GET['order']=='asc'?'asc':'desc';
        }

        /*$subscription_packages = new \App\admin\Subscription_packages;*/
        $data = $this->subscription_packages->getSubscription_packagesExport($searchBy, $searchValue, $sortBy, $order);

        if($type=='csv'){
            header('Content-Type: application/csv');
            header('Content-Disposition: attachment; filename=subscription_packages.csv');
            header('Pragma: no-cache');
            $csv='Sr. No,'.implode(',', $this->v_fields)."\n";
            foreach ($data as $key => $value) {
                $line=($key+1).',';
                foreach ($this->v_fields as $field) {
                    $field = explode('.', $field);
                    $field = end($field);
                    $line.='"'.$value->$field.'"'.',';
                }
                $csv.=ltrim($line,',')."\n";
            }
            echo $csv; exit;
        } elseif($type=='pdf'){
            require_once(app_path().'/libraries/mpdf/mpdf.php');
            $table='
            <html>
            <head><title></title>
            <style>
            table{
                border:1px solid;
            }
            tr:nth-child(even)
            {
                background-color: rgba(158, 158, 158, 0.82);
            }
            </style>
            </head>
            <body>
            <h1 align="center">subscription_packages</h1>
            <table><tr>';
            $table.='<th>Sr. No</th>';
            foreach ($this->v_fields as $value) {
                $table.='<th>'.$value.'</th>';
            }
            $table.='</tr>';
            foreach ($data as $key => $value) {
                $table.='<tr><td>'.($key+1).'</td>';
                foreach ($this->v_fields as $field) {
                    $field = explode('.', $field);
                    $field = end($field);
                    $table.='<td>'.$value->$field.'</td>';
                }
                $table.='</tr>';
            }
            $table.='</table></body></html>';
            $pdf = new \mPDF();
            $pdf->WriteHTML($table);
            $pdf->Output('subscription_packages.pdf', "D");
            exit;
        } else{
            echo 'Invalid option!';
        }
    }
}
