<?php

namespace AppHttpControllers;

use IlluminateHttpRequest;

use AppHttpRequests;
use IlluminateSupportFacadesStorage;
use DB;
use File;

class CompanyProfileController extends Controller
{
/**
 * Display a listing of the resource.
 *
 * @return IlluminateHttpResponse
 */
public function index()
{
    $result= DB::table('tblcompany')->get();
    if($result==null)
    {
        DB::table('tblcompany')->insert([
            'companyName' =>' ']
     );
    }
    $pic = DB::table('tblcompany')->select('logoName')->limit(1)->value('logoName');
    if($pic==null)
    {
        DB::table('tblcompany')->update(['logoName' => 'noimage.png',]);
    }
    $data['getAllDetails']= DB::table('tblcompany')->get();

    return view('companyProfile.companyProfile', $data);
}

/**
 * Show the form for creating a new resource.
 *
 * @return IlluminateHttpResponse
 */
public function create()
{
    //
}

/**
 * Store a newly created resource in storage.
 *
 * @param  IlluminateHttpRequest  $request
 * @return IlluminateHttpResponse
 */
public function store(Request $request)
{
    //
}

/**
 * Display the specified resource.
 *
 * @param  int  $id
 * @return IlluminateHttpResponse
 */
public function show($id)
{
    //
}

/**
 * Show the form for editing the specified resource.
 *
 * @param  int  $id
 * @return IlluminateHttpResponse
 */
public function edit($id)
{
    //
}

/**
 * Update the specified resource in storage.
 *
 * @param  IlluminateHttpRequest  $request
 * @param  int  $id
 * @return IlluminateHttpResponse
 */
public function update(Request $request)
{
//dd(asset(''));
    $this->validate($request, [
        'companyname' =>'required',
        'shortCode' =>'required',
        'telnum' =>'required',
        'emailid' =>'required',
        'address' =>'required',

    ]);

    //$file_path =  asset('') . '/profileLogo/';
    //$file_path =  asset("/profileLogo/");

    if($request->hasFIle('logo')){
        $filenameWithExt = $request->file('logo')->getClientOriginalName();
        $filename = pathinfo($filenameWithExt,PATHINFO_FILENAME);
        $extention = $request->file('logo')->getClientOriginalExtension();
        $fileNameToStore = $filename.'_'.time().'.'.$extention;
       $pic = DB::table('tblcompany')->select('logoName')->limit(1)->value('logoName');
       if($pic!='noimage.png')
       {

            //$deletePicPath = $file_path . $pic;
            //die($deletePicPath);
            //File::delete($deletePicPath );
       }



        $path = $request->file('logo')->move(
           asset("/profileLogo/"), $fileNameToStore
        );

        DB::table('tblcompany')->update(['logoPath' => $path,'logoName' => $fileNameToStore,]);

    }


    $companyname= trim($request['companyname']);
    $shortCode= trim($request['shortCode']);
    $telnum= trim($request['telnum']);
    $emailid= trim($request['emailid']);
    $address= trim($request['address']);

    DB::table('tblcompany')->update(
            ['companyName' => $companyname,
            'shortCode' => $shortCode,
            'phoneNo' => $telnum,
            'emailAddress' => $emailid,
            'contactAddress' => $address,]
        );

        return redirect('/company-profile')->with('message','Form Updated');
}

/**
 * Remove the specified resource from storage.
 *
 * @param  int  $id
 * @return IlluminateHttpResponse
 */
public function destroy($id)
{
    //
}