<?php

namespace App\Http\Controllers;

use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use App\Models\User;
use App\Models\Performance;
use App\Models\PerformanceLineItem;
use App\Models\Product;
use App\Library\SfdbQueryMethod;
use App\Library\SalesforceAdminConsole;
use Illuminate\Support\Facades\Storage;
use DB;

class SalesforceAdminController extends Controller
{
    protected $SfdbQueryMethod;
    protected $SalesforceAdminConsole;
    public function __construct(SfdbQueryMethod $SfdbQueryMethod, SalesforceAdminConsole $SalesforceAdminConsole)
    {
        $this->SfdbQueryMethod = $SfdbQueryMethod;
         $this->SalesforceAdminConsole = $SalesforceAdminConsole;
    }
    // SalesforceAdmin
    public function salesforceAdminPage(Request $request)
    {

        return view('admin.dbadmin');

    }

    public function salesforceAdmin(Request $request)
    {
        $BtType = $request->input('BtType');

        if ($BtType == 'rowCount') {
            $tableOutput = $this->SalesforceAdminConsole->salesforceTableRowCount();
            //return $tableOutput;
            return response()->json([
                'status' => 200,
                'tableOutput' => $tableOutput,
            ]);
           echo $BtType;
        } else if ($BtType == 'dbStatus'){
              $tableOutput = $this->SalesforceAdminConsole->salesforceTableDetail();
            //return $tableOutput;
            return response()->json([
                'status' => 200,
                'tableOutput' => $tableOutput,
            ]);
        }else if ($BtType == 'syncOrderItem'){
              $tableOutput = $this->SfdbQueryMethod->createOrderItem();
              $tableOutput = $this->SfdbQueryMethod->cloneOrderItem();
            //return $tableOutput;
            return response()->json([
                'status' => 200,
                'tableOutput' => $tableOutput,
            ]);
        }


        exit;

         try {
            $fileBasePath=public_path();
            // get data from the SQL file
            $sql_BatchJob = file_get_contents($fileBasePath."/SalesforceHelper/dbCloneFailedRow.sql");
            // execute the SQL
            //$result=DB::connection('pgsql')->unprepared($sql_BatchJob);

        //clone OrderItem
            $this->SfdbQueryMethod->cloneOrderItem();
            // Create Order Item
             $this->SfdbQueryMethod->createOrderItem();
        } catch (Exception $error) {
            return $error;
        }
    }
}