<?php

namespace App\Controllers\AdvertisementManager;

use App\Controllers\BaseController;
use App\Libraries\Calc;
use App\Models\Advertiser\AdvFacebookManagerModel;
use App\Models\Advertiser\AdvGoogleManagerModel;
use App\Models\Advertiser\AdvKakaoManagerModel;
use App\Models\Advertiser\AdvManagerModel;
use App\Services\AdvLoggerService;
use CodeIgniter\API\ResponseTrait;
use App\ThirdParty\facebook_api\ZenithFB;
use App\ThirdParty\googleads_api\ZenithGG;
use App\ThirdParty\moment_api\ZenithKM;

class AdvManagerController extends BaseController
{
    use ResponseTrait;
    
    protected $admanager, $facebook, $google, $kakao;
    private $campaign;
    public function __construct() 
    {
        $this->admanager = model(AdvManagerModel::class);
        $this->facebook = model(AdvFacebookManagerModel::class);
        $this->google = model(AdvGoogleManagerModel::class);
        $this->kakao = model(AdvKakaoManagerModel::class);
    }
    
    public function index()
    {
        return view('advertisements/manage');
    }

    public function getData(){
        if(!$this->request->isAJAX() || strtolower($this->request->getMethod()) !== 'get') return $this->fail("잘못된 요청");
        $arg = $this->request->getGet();

        if(getenv('MY_SERVER_NAME') === 'resta' && isset($arg['searchData']['carelabs']) && $arg['searchData']['carelabs'] == 1) {
            $arg['external'] = 'resta';
            return $this->getCareLabsData($arg);
        }
        // print_r($arg['searchData']);
        switch ($arg['searchData']['type']) {
            case 'ads':
                $result = $this->getAds($arg);
                break;
            case 'adsets':
                $result = $this->getAdSets($arg);
                break;
            case 'campaigns':
                $result = $this->getCampaigns($arg);
                break;
            default:
                $result = $this->getCampaigns($arg);
                break;
        }
        if(!isset($result['data'])) return $this->respond([]);
        $orderBy = [];
        if(!empty($arg['order'])) {
            foreach($arg['order'] as $row) {
                if($row['dir'] == 'desc'){
                    $sort = SORT_DESC;
                }else{
                    $sort = SORT_ASC;
                }
                $col = $arg['columns'][$row['column']]['data'];
                if($col) $orderBy[$col] = $sort;
            }
            array_sort_by_multiple_keys($result['data'], $orderBy);
        }

        foreach ($result['data'] as &$value) {
            $value['class'] = [];
            if(!empty($value['status']) || !empty($value['approval_status'])){
                if (isset($value['status']) && $value['status'] != 'ON') {
                    $value['class'][] = 'off';
                }

                $policyTopic = [];
                if(!empty($value['policyTopic'])){
                    $policyTopic = explode(',', $value['policyTopic']);
                }
                if (isset($value['approval_status']) && ($value['approval_status'] == 'DISAPPROVED' || $value['approval_status'] == 'REJECTED' || $value['approval_status'] == 'AREA_OF_INTEREST_ONLY' || ($value['approval_status'] == 'APPROVED_LIMITED' && in_array('YOUTUBE_AD_REQUIREMENTS_AUTOMATED_CONTENT_POLICY_DECISION', $policyTopic)))) {
                    $value['class'][] = 'disapproval';
                } else if (isset($value['approval_status']) && ($value['approval_status'] == 'APPROVED_LIMITED' || ($value['approval_status'] == 'APPROVED' && in_array('HEALTH_IN_PERSONALIZED_ADS', $policyTopic)))) {
                    $value['class'][] = 'approved_limited';
                }
            
                if (isset($value['class'])) {
                    $value['class'] = implode(" ", $value['class']);
                }
            }

            $value['campaign_bidamount'] = number_format($value['campaign_bidamount'] ?? 0);
            $value['bidamount'] = number_format($value['bidamount']);
            $value['budget'] = number_format($value['budget']);
            $value['impressions'] = number_format($value['impressions']);
            $value['click'] = number_format($value['click']);
            $value['spend'] = number_format($value['spend']);
            $value['sales'] = number_format($value['sales']);
            $value['unique_total'] = number_format($value['unique_total']);
            $value['margin'] = number_format($value['margin']);
            $value['margin_ratio'] = number_format($value['margin_ratio']);
            $value['cpa'] = number_format($value['cpa']);
            $value['cpc'] = number_format($value['cpc']);
            if(isset($arg['noLimit'])) {
                return $this->respond($result['data']);
            }
        }
            // $result['report'] = $this->getReport($arg);
            // $result['accounts'] = $this->getAccounts($arg);
            // $result['media_accounts'] = $this->getMediaAccounts($arg);

        return $this->respond($result);
    }

    public function getReportData() {
        if(!$this->request->isAJAX() || strtolower($this->request->getMethod()) !== 'get') return $this->fail("잘못된 요청");
        $arg = $this->request->getGet();
        $result = $this->getReport($arg);
        return $this->respond($result);
    }
    public function getAccountsData() {
        if(!$this->request->isAJAX() || strtolower($this->request->getMethod()) !== 'get') return $this->fail("잘못된 요청");
        $arg = $this->request->getGet();
        $result = $this->getAccounts($arg);
        return $this->respond($result);
    }
    public function getMediaAccountsData() {
        if(!$this->request->isAJAX() || strtolower($this->request->getMethod()) !== 'get') return $this->fail("잘못된 요청");
        $arg = $this->request->getGet();
        $result = $this->getMediaAccounts($arg);
        return $this->respond($result);
    }

    private function getAccounts($arg)
    {  
        $result = $this->admanager->getAccounts($arg);
        return $result;
    }

    private function getMediaAccounts($arg)
    { 
        $result = $this->admanager->getMediaAccounts($arg);
        $accounts = $this->setAccountData($result);
        return $accounts;
    }

    public function getAccountStat()
    {
        $arg = $this->request->getGet();
        $result = $this->admanager->getAccountStat($arg);
        return $this->respond($result);
    }

    private function setAccountData($accounts)
    {
        $facebookApprovals = [];
        $googleApprovals = [];
        $kakaoApprovals = [];
        if(array_search('facebook', array_column($accounts, 'media')) !== false){
            $facebookApprovals = $this->facebook->getDisapproval();
        }

        if(array_search('google', array_column($accounts, 'media')) !== false){
            $disapprovalGoogle = $this->google->getDisapproval();   
            foreach ($disapprovalGoogle as $row) {
                $policyTopic = [];
                if(!empty($row['policyTopic'])) $policyTopic = explode(',', $row['policyTopic']);
                if($row['approvalStatus'] == 'APPROVED_LIMITED' && in_array('YOUTUBE_AD_REQUIREMENTS_AUTOMATED_CONTENT_POLICY_DECISION', $policyTopic)) {
                    $row['approvalStatus'] = 'DISAPPROVED';
                } else if($row['approvalStatus'] == 'APPROVED' && in_array('HEALTH_IN_PERSONALIZED_ADS', $policyTopic)) {
                    $row['approvalStatus'] = 'APPROVED_LIMITED';
                }
                if(!isset($googleApprovals[$row['approvalStatus']])) $googleApprovals[$row['approvalStatus']] = [];
                if(!in_array($row['customerId'], $googleApprovals[$row['approvalStatus']]))
                    $googleApprovals[$row['approvalStatus']][] = $row['customerId'];
            }
        }

        if(array_search('kakao', array_column($accounts, 'media')) !== false){
            $kakaoApprovals = $this->kakao->getDisapproval();
        }

        foreach ($accounts as &$account) {
            if($account['media'] == 'facebook'){
                $account['db_ratio'] = 0;
                if ($account['status'] != 1){
                    $account['tag_inactive'] = 'tag_inactive';
                }
                if (in_array($account['media_account_id'], $facebookApprovals)){
                    $account['disapproval'] = 'disapproval';
                } 

                $account['db_count'] = $account['db_count'] * $account['date_count'];
    
                if($account['db_sum'] && $account['db_count']){
                    $account['db_ratio'] = round($account['db_sum'] / $account['db_count'] * 100,1);
                }
    
                if($account['db_ratio'] >= 100) { 
                    $account['db_ratio'] = 100; 
                    $account['over'] = 'over';
                }
    
                if(!$account['db_sum']){
                    $account['db_sum'] = 0;  
                }  

                continue;
            }
            
            if($account['media'] == 'google'){
                $account['db_ratio'] = 0;
                if($account['is_exposed'] === 0){
                    $account['tag_inactive'] = 'tag_inactive';
                }
                
                if((isset($googleApprovals['DISAPPROVED']) && in_array($account['media_account_id'], $googleApprovals['DISAPPROVED'])) ||
                (isset($googleApprovals['AREA_OF_INTEREST_ONLY']) && in_array($account['media_account_id'], $googleApprovals['AREA_OF_INTEREST_ONLY']))) 
                {
                    $account['disapproval'] = 'disapproval';
                }

                if(isset($googleApprovals['APPROVED_LIMITED']) && in_array($account['media_account_id'], $googleApprovals['APPROVED_LIMITED']))
                {
                    $account['approved_limited'] = 'approved_limited';
                }
                
                $account['db_count'] = $account['db_count'] * $account['date_count'];

                if($account['db_sum'] && $account['db_count']){
                    $account['db_ratio'] = round($account['db_sum'] / $account['db_count'] * 100,1);
                }

                if($account['db_ratio'] >= 100) { 
                    $account['db_ratio'] = 100; 
                    $account['over'] = 'over';
                }

                if(!$account['db_sum']){
                    $account['db_sum'] = 0;
                }

                continue;
            }

            if($account['media'] == 'kakao'){
                if($account['status'] == 'OFF' || (isset($account['isAdminStop']) && $account['isAdminStop'] == 1)){
                    $account['tag_inactive'] = 'tag_inactive';
                }
                if(is_array($kakaoApprovals) && in_array($account['media_account_id'], $kakaoApprovals)){
                    $account['disapproval'] = 'disapproval';
                }

                continue;
            }
        }

        return $accounts;
    }
    
    public function getCheckData(){
        if($this->request->isAJAX() && strtolower($this->request->getMethod()) === 'get'){
            $arg = $this->request->getGet();
            $result['report'] = $this->getReport($arg);
            $result['account'] = $this->getAccounts($arg);
            $result['media_accounts'] = $this->getMediaAccounts($arg);

            return $this->respond($result);
        }else{
            return $this->fail("잘못된 요청");
        }
    }

    public function getDiffReport(){
        if($this->request->isAJAX() && strtolower($this->request->getMethod()) === 'get'){
            $arg = $this->request->getGet();
            $currentDate = date("Y-m-d");
            $arg['check'] = true;
            $arg['searchData']['sdate'] = $currentDate;
            $arg['searchData']['edate'] = $currentDate;
            $result['today'] = $this->getReport($arg);

            $arg['searchData']['sdate'] = date("Y-m-d", strtotime("-1 days", strtotime($currentDate)));
            $arg['searchData']['edate'] = date("Y-m-d", strtotime("-1 days", strtotime($currentDate)));

            $result['yesterday'] = $this->getReport($arg);
            
            switch ($arg['searchData']['diff']) {
                case '7days':
                    $arg['searchData']['sdate'] = date("Y-m-d", strtotime("-1 week"));
                    $arg['searchData']['edate'] = $currentDate;
                break;
                case '14days':
                    $arg['searchData']['sdate'] = date("Y-m-d", strtotime("-2 week"));
                    $arg['searchData']['edate'] = $currentDate;
                break;
                case '30days':
                    $arg['searchData']['sdate'] = date("Y-m-d", strtotime("-1 month"));
                    $arg['searchData']['edate'] = $currentDate;
                break;
                case 'prevmonth':
                    $arg['searchData']['sdate'] = date("Y-m-01", strtotime("-1 month", strtotime($currentDate)));
                    $arg['searchData']['edate'] = date("Y-m-t", strtotime("-1 month", strtotime($currentDate)));
                break;
                case 'thismonth':
                    $arg['searchData']['sdate'] = date("Y-m-01", strtotime($currentDate));
                    $arg['searchData']['edate'] = $currentDate;
                break;
                default:
                break;
            }
            
            $result['customDate'] = $this->getReport($arg);
            $result['customDate']['date'] = [
                'sdate' => $arg['searchData']['sdate'],
                'edate' => $arg['searchData']['edate'],
            ];
            return $this->respond($result);
        }else{
            return $this->fail("잘못된 요청");
        }
    }

    private function getReport($arg)
    {
        $result = $this->admanager->getReport($arg);
        $columnIndex = 0;
        $data = [];
        foreach($result as $row) {
            $data[] = $row;
            foreach ($row as $col => $val) {
                if ($val == NULL) $val = "0";
                $total[$col][$columnIndex] = $val;
            }
            $columnIndex++;
        }
        
        $report['impressions_sum'] = $report['clicks_sum'] = $report['click_ratio_sum'] = $report['spend_sum'] = $report['unique_total_sum'] = $report['unique_one_price_sum'] = $report['conversion_ratio_sum'] = $report['profit_sum'] = $report['per_sum'] = $report['price_sum'] = $report['spend_ratio_sum'] =$report['cpc'] = 0;

        if(!empty($result)){
            $report['impressions_sum'] = array_sum($total['impressions']); //총 노출수
            $report['clicks_sum'] = array_sum($total['click']); //총 클릭수
            if ($report['clicks_sum'] != 0 && $report['impressions_sum'] != 0) {
                $report['click_ratio_sum'] = round(($report['clicks_sum'] / $report['impressions_sum']) * 100, 2); //총 클릭률    
            }
            $report['spend_sum'] = array_sum($total['spend']); //총 지출액
            $report['spend_ratio_sum'] = floor(array_sum($total['spend']) * 0.85); //총 매체비
            if ($report['clicks_sum'] != 0) {
                $report['cpc'] = round($report['spend_sum'] / $report['clicks_sum'], 2);
            } else {
                $report['cpc'] = 0;
            }
            $report['unique_total_sum'] = array_sum($total['unique_total']); //총 유효db수
            if ($report['spend_sum'] != 0 && $report['unique_total_sum'] != 0) {
                $report['unique_one_price_sum'] = round($report['spend_sum'] / $report['unique_total_sum'], 0); //총 db당 단가
            }
            if ($report['unique_total_sum'] != 0 && $report['clicks_sum'] != 0) {
                $report['conversion_ratio_sum'] = round(($report['unique_total_sum'] / $report['clicks_sum']) * 100, 2); //총 전환율
            }
            $report['price_sum'] = array_sum($total['price']); //총 매출액
            $report['profit_sum'] = array_sum($total['profit']); //총 수익
            if ($report['profit_sum'] != 0 && $report['price_sum'] != 0) {
                $report['per_sum'] = round(($report['profit_sum'] / $report['price_sum']) * 100, 2); //총 수익률
            }

            $report['impressions_sum'] = number_format($report['impressions_sum']);
            $report['clicks_sum'] = number_format($report['clicks_sum']);
            $report['spend_sum'] = number_format($report['spend_sum']);
            $report['unique_one_price_sum'] = number_format($report['unique_one_price_sum']);
            $report['spend_ratio_sum'] = number_format($report['spend_ratio_sum']);
            $report['price_sum'] = number_format($report['price_sum']);
            $report['profit_sum'] = number_format($report['profit_sum']);
        }

        return $report;
    }

    public function getOnlyAdAccount()
    {
        if($this->request->isAJAX() && strtolower($this->request->getMethod()) === 'get'){
            $param = $this->request->getGet();
            $result = $this->admanager->getOnlyAdAccount($param);
            return $this->respond($result);
        }else{
            return $this->fail("잘못된 요청");
        }
    }

    public function getAdvs()
    {
        if($this->request->isAJAX() && strtolower($this->request->getMethod()) === 'get'){
            $param = $this->request->getGet();
            
            $result = $this->admanager->getAdvs($param);
            foreach ($result as &$row) {
                if(isset($row['status']) && $row['status'] == 1 || $row['status'] == 'ON' || $row['status'] == 'ENABLED' || $row['status'] == 'ACTIVE'){
                    $row['status'] = '활성';
                }else{
                    $row['status'] = '비활성';
                }
            }
            return $this->respond($result);
        }else{
            return $this->fail("잘못된 요청");
        }
    }

    private function getCampaigns($arg)
    {
        $campaigns = $this->admanager->getCampaigns($arg);
		if(!empty($campaigns)){
			$campaigns = $this->setData($campaigns);
            $total = $this->getTotal($campaigns);
        
            $result = [
                'total' => $total,
                'data' => $campaigns,
            ];

            return $result;
		}else{
			return false;
		}
    }

    private function getAdSets($arg)
    {
        $result  = [];    
        $adsets = $this->admanager->getAdSets($arg);
		if(!empty($adsets)){
			$adsets = $this->setData($adsets);
            $result = array_merge($result, $adsets); 

            $total = $this->getTotal($result);
            
            $result = [
                'total' => $total,
                'data' => $result,
            ];

            return $result;
		}else{
			return false;
		}
    }

    private function getAds($arg)
    {
        $result  = [];    
        $ads = $this->admanager->getAds($arg);
		if(!empty($ads)){
			$ads = $this->setData($ads);
            $result = array_merge($result, $ads); 

            $total = $this->getTotal($result);
            $result = [
                'total' => $total,
                'data' => $result,
            ];

            return $result;
		}else{
			return false;
		}
    }

    private function setData($result)
    {
        foreach ($result as &$row) {
            if($row['media'] == 'google' && isset($row['thumbnail'])){
                if (!empty($row['assets'])){
                    $assets = $this->google->getAsset($row['assets']);
                    $row['thumbnail'] = $assets['url'];
                }
            }
			$row['status'] = $this->setStatus($row['status']);
			
            $row['margin_ratio'] = Calc::margin_ratio($row['margin'], $row['sales']);	// 수익률

			$row['cpc'] = Calc::cpc($row['spend'], $row['click']);	// 클릭당단가 (1회 클릭당 비용)
			$row['ctr'] = Calc::ctr($row['click'], $row['impressions']);	// 클릭율 (노출 대비 클릭한 비율)
			$row['cpa'] = Calc::cpa($row['unique_total'], $row['spend']);	//DB단가(전환당 비용)
			$row['cvr'] = Calc::cvr($row['unique_total'], $row['click']);	//전환율

            if($row['bidamount_type'] == 'cpm' && $row['bidamount'] <= 1){
                $row['bidamount_type'] = '';
                $row['bidamount'] = 0;
            }

            if(!empty($row['biddingStrategyType'])){
                switch($row['biddingStrategyType']) {
                    case 'TARGET_CPA' :
                        $row['biddingStrategyType'] = '타겟 CPA';
                        break;
                    case 'TARGET_ROAS' :
                        $row['biddingStrategyType'] = '타겟 광고 투자수익(ROAS)';
                        break;
                    case 'TARGET_SPEND' :
                        $row['biddingStrategyType'] = '클릭수 최대화';
                        break;
                    case 'MAXIMIZE_CONVERSIONS' :
                        $row['biddingStrategyType'] = '전환수 최대화';
                        break;
                    /* //값이 뭔지 모름ㅠㅠ
                    case '' :
                        $row['biddingStrategyType'] = '검색 결과 위치 타겟';
                        break;
                    case '' :
                        $row['biddingStrategyType'] = '경쟁 광고보다 내 광고가 높은 순위에 게재되는 비율 타겟';
                        break;
                    case '' :
                        $row['biddingStrategyType'] = '타겟 노출 점유율';
                        break;
                    */
                    case 'PAGE_ONE_PROMOTED' :
                        $row['biddingStrategyType'] = '향상된 CPC 입찰기능';
                        break;
                    case 'MANUAL_CPM' :
                        $row['biddingStrategyType'] = '수동 입찰 전략';
                        break;
                    case 'MANUAL_CPC' :
                        $row['biddingStrategyType'] = '수동 CPC';
                        break;
                    case 'UNKNOWN' :
                        $row['biddingStrategyType'] = '알수없음';
                        break;
                    default :
                        break;
                }
            }
        }
        return $result;
    }

    private function setStatus($status)
    {
        /*
        ON = 인정,
        READY = 집행 예정,
        FINISHED = 집행 완료,
        STOPPED = 정지,
        ARCHIVED = 보관,
        DELETED = 삭제
        UNKNOWN = 알수 없음
        UNSPECIFIED = 명시되지 않음
        EXCEED_DAILY_BUDGET = 일 예산 초과
        NO_AVAILABLE_CREATIVE = 집행 가능한 소재가 없음
        CANCELED = 계약 해지
        SYSTEM_CONFIG_EXTERNAL_SERVICE_STOP = 연결 서비스 제한으로 운영불가인 상태
        ADACCOUNT_UNAVAILABLE = 광고계정 운영불가
        CAMPAIGN_UNAVAILABLE = 캠페인 운영불가
        ADGROUP_UNAVAILABLE = 광고 상위단위인 광고그룹이 운영불가인 상태
        SYSTEM_CONFIG_ADMIN_STOP = 관리자 정지
        OPERATING = 운영가능 상태
        UNAPPROVED = 심사승인이 아닌 상태(심사중, 심사보류를 모두 포함)
        INVALID_DATE = 집행기간이 도래하지 않았거나 이미 지난 상태
        MONITORING_REJECTED = 관리자정지 상태
        SYSTEM_CONFIG_VOID = 소재 콘텐츠 오류로 소재 운영불가인 상태
        */
        if(!empty($status)){
            if(in_array($status, ['ENABLED', 'ACTIVE', 'LIVE', 'ON'])){$status = 'ON';}
            else if(in_array($status, ['READY'])){$status = 'READY';}
            else if(in_array($status, ['FINISHED'])){$status = 'FINISHED';}
            else if(in_array($status, ['OFF', 'PAUSED'])){$status = 'OFF';}
            else if(in_array($status, ['ARCHIVED'])){$status = 'ARCHIVED';}
            else if(in_array($status, ['DELETED', 'REMOVED'])){$status = 'DELETED';}
            else if(in_array($status, ['UNKNOWN'])){$status = 'UNKNOWN';}
            else if(in_array($status, ['UNSPECIFIED'])){$status = 'UNSPECIFIED';}
            else if(in_array($status, ['EXCEED_DAILY_BUDGET'])){$status = 'EXCEED_DAILY_BUDGET';}
            else if(in_array($status, ['NO_AVAILABLE_CREATIVE'])){$status = 'NO_AVAILABLE_CREATIVE';}
            else if(in_array($status, ['CANCELED'])){$status = 'CANCELED';}
            else if(in_array($status, ['SYSTEM_CONFIG_EXTERNAL_SERVICE_STOP'])){$status = 'SYSTEM_CONFIG_EXTERNAL_SERVICE_STOP';}
            else if(in_array($status, ['ADACCOUNT_UNAVAILABLE'])){$status = 'ADACCOUNT_UNAVAILABLE';}
            else if(in_array($status, ['CAMPAIGN_UNAVAILABLE'])){$status = 'CAMPAIGN_UNAVAILABLE';}
            else if(in_array($status, ['SYSTEM_CONFIG_ADMIN_STOP'])){$status = 'SYSTEM_CONFIG_ADMIN_STOP';}
            else if(in_array($status, ['OPERATING'])){$status = 'OPERATING';}
            else if(in_array($status, ['UNAPPROVED'])){$status = 'UNAPPROVED';}
            else if(in_array($status, ['INVALID_DATE'])){$status = 'INVALID_DATE';}
            else if(in_array($status, ['MONITORING_REJECTED'])){$status = 'MONITORING_REJECTED';}
            else if(in_array($status, ['ADGROUP_UNAVAILABLE'])){$status = 'ADGROUP_UNAVAILABLE';}
            else if(in_array($status, ['SYSTEM_CONFIG_VOID'])){$status = 'SYSTEM_CONFIG_VOID';}
            else{$status = 'ETC';};
        }else{
            $status = NULL;
        };

        return $status;
    }

    private function getTotal($datas)
    {
        $total = [];
        $total['impressions'] = 0;
        $total['click'] = 0;
        $total['spend'] = 0;
        $total['margin'] = 0;
        $total['unique_total'] = 0;
        $total['sales'] = 0;
        $total['budget'] = 0;
        $total['bidamount'] = 0;
        $total['cpc'] = 0;
        $total['ctr'] = 0;
        $total['cpa'] = 0;
        $total['cvr'] = 0;
        $total['margin_ratio'] = 0;
        $total['expect_db'] = 0;
        $total['avg_cpc'] = 0;
        $total['avg_cpa'] = 0;
        $total['avg_cvr'] = 0;
        $total['avg_ctr'] = 0;
        foreach($datas as $data){
            $total['impressions'] +=$data['impressions'];
            $total['click'] +=$data['click'];
            $total['spend'] +=$data['spend'];
            $total['margin'] +=$data['margin'];
            $total['unique_total'] +=$data['unique_total'];
            $total['sales'] +=$data['sales'];
            $total['bidamount'] +=$data['bidamount'];
            $total['budget'] +=$data['budget'];
            $total['cpc'] +=$data['cpc'];
            $total['ctr'] +=$data['ctr'];
            $total['cpa'] +=$data['cpa'];
            $total['cvr'] +=$data['cvr'];
            $total['margin_ratio'] +=$data['margin_ratio'];

            //CPC(Cost Per Click: 클릭당단가 (1회 클릭당 비용)) = 지출액/링크클릭
            if($total['click'] > 0){
                $total['avg_cpc'] = $total['spend'] / $total['click'];
            }

            //CTR(Click Through Rate: 클릭율 (노출 대비 클릭한 비율)) = (링크클릭/노출수)*100
            if($total['impressions'] > 0){
                $total['avg_ctr'] = ($total['click'] / $total['impressions']) * 100;
            }
            
            //CPA(Cost Per Action: 현재 DB단가(전환당 비용)) = 지출액/유효db
            if($total['unique_total'] > 0){
                $total['avg_cpa'] = $total['spend'] / $total['unique_total'];
            }

            //CVR(Conversion Rate:전환율 = (유효db / 링크클릭)*100
            if ($total['click'] > 0) {
                $total['avg_cvr'] = ($total['unique_total'] / $total['click']) * 100;
            }

            //수익률 = (수익/매출액)*100
            if ($total['sales'] > 0) {
                $total['avg_margin_ratio'] = ($total['margin'] / $total['sales']) * 100;
            } else {
                $total['avg_margin_ratio'] = 0;
            } 

            if ($data['status'] == 'ON' && $data['unique_total'] && $data['cpa'] != 0){
                $total['expect_db'] += round($data['budget'] / $data['cpa']);
            }
        }

        $total['impressions'] = number_format($total['impressions']);
        $total['bidamount'] = number_format($total['bidamount']);
        $total['budget'] = number_format($total['budget']);
        $total['click'] = number_format($total['click']);
        $total['spend'] = number_format($total['spend']);
        $total['avg_cpa'] = number_format($total['avg_cpa']);
        $total['margin'] = number_format($total['margin']);
        $total['sales'] = number_format($total['sales']);
        $total['avg_cpc'] = number_format($total['avg_cpc']);

        return $total;
    }

    public function setDbCount()
    {
        if($this->request->isAJAX() && strtolower($this->request->getMethod()) === 'put'){
            $param = $this->request->getRawInput();
            $sliceId = explode("_", $param['id']);
            $data = [
                'media' => $sliceId[0],
                'id' => $sliceId[1],
                'db_count' => $param['db_count']
            ];

            switch ($data['media']) {
                case 'facebook':
                    $result = $this->facebook->updateDbCount($data);
                    break;
                case 'google':
                    $result = $this->google->updateDbCount($data);
                    break;
                default:
                    return $this->fail("잘못된 요청");
            }

            return $this->respond($result);
        }else{
            return $this->fail("잘못된 요청");
        }
    }

    public function setExposed()
    {
        if($this->request->isAJAX() && strtolower($this->request->getMethod()) === 'put'){
            $param = $this->request->getRawInput();
            $sliceId = explode("_", $param['id']);
            $data = [
                'media' => $sliceId[0],
                'id' => $sliceId[1],
                'is_exposed' => $param['is_exposed']
            ];

            switch ($data['media']) {
                case 'google':
                    $result = $this->google->updateExposed($data);
                    break;
                default:
                    return $this->fail("잘못된 요청");
            }

            return $this->respond($result);
        }else{
            return $this->fail("잘못된 요청");
        }
    }

    public function updateStatus()
    {
        if($this->request->isAJAX() && strtolower($this->request->getMethod()) === 'put'){
            if (auth()->user()->inGroup('test')) {
                return $this->fail("테스트 계정");
            }

            $param = $this->request->getRawInput();
            $sliceId = explode("_", $param['id']);
            $data = [
                'media' => $sliceId[0],
                'id' => $sliceId[1],
                'tab' => $param['tab'],
                'status' => $param['status'],
                'old_status' => $param['old_status'],
                'customerId' => $param['customerId'],
            ];

            switch ($data['tab']) {
                case 'ads':
                    switch ($data['media']) {
                        case 'facebook':
                            if($data['status'] === "ON"){
                                $status = 'ACTIVE';
                            }else{
                                $status = 'PAUSED';
                            }
                            $zenith = new ZenithFB();
                            $result = $zenith->setAdStatus($data['id'], $status);
                            break;
                        case 'kakao':
                            if($data['status'] === "ON"){
                                $status = 'ON';
                            }else{
                                $status = 'OFF';
                            }
                            $zenith = new ZenithKM();
                            $result = $zenith->setCreativeOnOff($data['id'], $data['status']);
                            break;
                        case 'google':
                            if($data['status'] === "ON"){
                                $param = ['status' => 'ENABLED'];
                            }else{
                                $param = ['status' => 'PAUSED'];
                            }
                            $zenith = new ZenithGG();
                            $result = $zenith->updateAdGroupAd($data['customerId'], null, $data['id'], $param);
                            break;
                        default:
                            return $this->fail("지원하지 않는 매체입니다.");
                    }
                    break;
                case 'adsets':
                    switch ($data['media']) {
                        case 'facebook':
                            if($data['status'] === "ON"){
                                $status = 'ACTIVE';
                            }else{
                                $status = 'PAUSED';
                            }
                            $zenith = new ZenithFB();
                            $result = $zenith->setAdsetStatus($data['id'], $status);
                            break;
                        case 'kakao':
                            $zenith = new ZenithKM();
                            $result = $zenith->setAdGroupOnOff($data['id'], $data['status']);
                            break;
                        case 'google':
                            if($data['status'] === "ON"){
                                $param = ['status' => 'ENABLED'];
                            }else{
                                $param = ['status' => 'PAUSED'];
                            }
                            $zenith = new ZenithGG();
                            $result = $zenith->updateAdGroup($data['customerId'], $data['id'], $param);
                            break;
                        default:
                            return $this->fail("지원하지 않는 매체입니다.");
                    }
                    break;
                case 'campaigns':
                    switch ($data['media']) {
                        case 'facebook':
                            if($data['status'] === "ON"){
                                $status = 'ACTIVE';
                            }else{
                                $status = 'PAUSED';
                            }
                            $zenith = new ZenithFB();
                            $result = $zenith->setCampaignStatus($data['id'], $status);
                            break;
                        case 'kakao':
                            $zenith = new ZenithKM();
                            $result = $zenith->setCampaignOnOff($data['id'], $data['status']);
                            break;
                        case 'google':
                            if($data['status'] === "ON"){
                                $param = ['status' => 'ENABLED'];
                            }else{
                                $param = ['status' => 'PAUSED'];
                            }
                            $zenith = new ZenithGG();
                            $result = $zenith->updateCampaign($data['customerId'], $data['id'], $param);
                            break;
                        default:
                            return $this->fail("지원하지 않는 매체입니다.");
                    }
                    break;
                default:
                    return $this->fail("잘못된 요청");
            }

            if(!empty($result)){
                $logData = [
                    'media' => $data['media'] ?? '',
                    'id' => $data['id'] ?? '',
                    'type' => $data['tab'] ?? '',
                    'change_type' => 'status',
                    'old_value' => $data['old_status'] ?? '',
                    'change_value' => $data['status'] ?? '',
                    'nickname' => auth()->user()->username ?? '',
                ];
        
                $logger = new AdvLoggerService();
                $logger->insertLog($logData);

                $result['response'] = true;
                return $this->respond($result);
            }else{
                return $this->fail("잘못된 요청");
            }
        }else{
            return $this->fail("잘못된 요청");
        }
    }

    public function updateName()
    {
        if($this->request->isAJAX() && strtolower($this->request->getMethod()) === 'put'){
            if (auth()->user()->inGroup('test')) {
                return $this->fail("테스트 계정");
            }

            $param = $this->request->getRawInput();
            $sliceId = explode("_", $param['id']);
            $data = [
                'media' => $sliceId[0],
                'id' => $sliceId[1],
                'tab' => $param['tab'],
                'name' => $param['name'],
                'old_name' => $param['old_name'],
                'customerId' => $param['customerId'],
            ];

            $param = [
                'id' => $data['id'],
                'name' => $data['name'],
            ];
            
            switch ($data['tab']) {
                case 'ads':
                    switch ($data['media']) {
                        case 'facebook':
                            $param['type'] = $data['tab'];
                            $zenith = new ZenithFB();
                            $result = $zenith->updateName($param);
                            break;
                        case 'kakao':
                            $zenith = new ZenithKM();
                            $result = $zenith->setCreative($param, $data['customerId']);
                            break;
                        case 'google':
                            return $this->fail("지원하지 않는 매체입니다.");
                            break;
                        default:
                            return $this->fail("지원하지 않는 매체입니다.");
                    }
                    break;
                case 'adsets':
                    switch ($data['media']) {
                        case 'facebook':
                            $param['type'] = $data['tab'];
                            $zenith = new ZenithFB();
                            $result = $zenith->updateName($param);
                            break;
                        case 'kakao':
                            return $this->fail("지원하지 않는 매체입니다.");
                            break;
                        case 'google':
                            $zenith = new ZenithGG();
                            $result = $zenith->updateAdGroup($data['customerId'], $data['id'], $param);
                            break;
                        default:
                            return $this->fail("지원하지 않는 매체입니다.");
                    }
                    break;
                case 'campaigns':
                    switch ($data['media']) {
                        case 'facebook':
                            $param['type'] = $data['tab'];
                            $zenith = new ZenithFB();
                            $result = $zenith->updateName($param);
                            break;
                        case 'kakao':
                            $zenith = new ZenithKM();
                            $result = $zenith->setCampaign($param, $data['customerId']);
                            break;
                        case 'google':
                            $zenith = new ZenithGG();
                            $result = $zenith->updateCampaign($data['customerId'], $data['id'], $param);
                            break;
                        default:
                            return $this->fail("지원하지 않는 매체입니다.");
                    }
                    break;
                default:
                    return $this->fail("잘못된 요청");
            }

            if(!empty($result)){
                $logData = [
                    'media' => $data['media'] ?? '',
                    'id' => $data['id'] ?? '',
                    'type' => $data['tab'] ?? '',
                    'change_type' => 'name',
                    'old_value' => $data['old_name'] ?? '',
                    'change_value' => $data['name'] ?? '',
                    'nickname' => auth()->user()->username ?? '',
                ];
        
                $logger = new AdvLoggerService();
                $logger->insertLog($logData);

                $result['response'] = true;
                return $this->respond($result);
            }else{
                return $this->fail("잘못된 요청");
            }
        }else{
            return $this->fail("잘못된 요청");
        }
    }

    public function updateBudget()
    {
        if($this->request->isAJAX() && strtolower($this->request->getMethod()) === 'put'){
            if (auth()->user()->inGroup('test')) {
                return $this->fail("테스트 계정");
            }

            $param = $this->request->getRawInput(); 
            $sliceId = explode("_", $param['id']);
            $data = [
                'media' => $sliceId[0],
                'id' => $sliceId[1],
                'customer' => $param['customer'],
                'tab' => $param['tab'],
                'budget' => $param['budget'],
                'old_budget' => $param['old_budget']
            ];

            switch ($data['tab']) {
                case 'ads':
                    return $this->fail("지원하지 않습니다.");
                    break;
                case 'adsets':
                    switch ($data['media']) {
                        case 'facebook':
                            $zenith = new ZenithFB();
                            $result = $zenith->updateAdSetBudget($data);
                            if(!empty($result)){
                                $result = [
                                    'id' => $result,
                                    'media' => 'facebook'
                                ];
                            }
                            break;
                        case 'kakao':
                            $data['type'] = 'adgroup';
                            $zenith = new ZenithKM();
                            $result = $zenith->setDailyBudgetAmount($data);
                            if(!empty($result)){
                                $result = [
                                    'id' => $result,
                                    'media' => 'kakao'
                                ];
                            }
                            break;
                        case 'google':
                            return $this->fail("지원하지 않습니다.");
                            break;
                        default:
                        return $this->fail("지원하지 않습니다.");
                    }
                    break;
                case 'campaigns':
                    switch ($data['media']) {
                        case 'facebook':
                            $zenith = new ZenithFB();
                            $result = $zenith->updateCampaignBudget($data);
                            if(!empty($result)){
                                $result = [
                                    'id' => $result,
                                    'media' => 'facebook'
                                ];
                            }
                            break;
                        case 'kakao':
                            $data['type'] = 'campaign';
                            $zenith = new ZenithKM();
                            $result = $zenith->setDailyBudgetAmount($data);
                            if(!empty($result)){
                                $result = [
                                    'id' => $result,
                                    'media' => 'kakao'
                                ];
                            }
                            break;
                        case 'google':
                            $param = ['budget' => $data['budget']];
                            $zenith = new ZenithGG();
                            $result = $zenith->updateCampaignBudget($data['customer'], $data['id'], $param);
                            if(!empty($result)){
                                $result = [
                                    'id' => $result,
                                    'media' => 'google'
                                ];
                            }
                            break;
                        default:
                            return $this->fail("지원하지 않습니다.");
                    }
                    break;
                default:
                    return $this->fail("잘못된 요청");
            }

            if(!empty($result) && $result['id'] == $data['id']){
                $logData = [
                    'media' => $data['media'] ?? '',
                    'id' => $data['id'] ?? '',
                    'type' => $data['tab'] ?? '',
                    'change_type' => 'budget',
                    'old_value' => $data['old_budget'] ?? '',
                    'change_value' => $data['budget'] ?? '',
                    'nickname' => auth()->user()->username ?? '',
                ];
        
                $logger = new AdvLoggerService();
                $logger->insertLog($logData);

                $result = true;
                return $this->respond($result);
            }else{
                return $this->fail("잘못된 요청");
            }

        }else{
            return $this->fail("잘못된 요청");
        }
    }

    public function updateBidAmount()
    {
        if($this->request->isAJAX() && strtolower($this->request->getMethod()) === 'put'){
            if (auth()->user()->inGroup('test')) {
                return $this->fail("테스트 계정");
            }

            $param = $this->request->getRawInput(); 
            $sliceId = explode("_", $param['id']);
            $data = [
                'media' => $sliceId[0],
                'id' => $sliceId[1],
                'customer' => $param['customer'],
                'tab' => $param['tab'],
                'bidamount' => $param['bidamount'],
                'bidamount_type' => $param['bidamount_type'] ?? null,
                'old_bidamount' => $param['old_bidamount']
            ];

            switch ($data['tab']) {
                case 'ads':
                    return $this->fail("지원하지 않습니다.");
                    break;
                case 'adsets':
                    switch ($data['media']) {
                        case 'kakao':
                            $data['type'] = 'adgroup';
                            $zenith = new ZenithKM();
                            $result = $zenith->setAdgroupBidAmount($data['id'], $data['bidamount']);
                            if(!empty($result)){
                                $result = [
                                    'id' => $result,
                                    'media' => 'kakao'
                                ];
                            }
                            break;
                        case 'google':
                            if(!empty($data['bidamount_type'])){
                                $updateArray = [];
                                if($data['bidamount_type'] == 'cpc'){
                                    $updateArray['cpcBidAmount'] = $data['bidamount'];
                                }else if($data['bidamount_type'] == 'cpm'){
                                    $updateArray['cpmBidAmount'] = $data['bidamount'];
                                }else if($data['bidamount_type'] == 'cpa'){
                                    $updateArray['cpaBidAmount'] = $data['bidamount'];
                                }

                                $zenith = new ZenithGG();
                                $result = $zenith->updateAdGroup($data['customer'], $data['id'], $updateArray);
                                
                                if(!empty($result)){
                                    $result = [
                                        'id' => $result['id'],
                                        'media' => 'google'
                                    ];
                                }
                            };

                            break;
                        default:
                        return $this->fail("지원하지 않습니다.");
                    }
                    break;
                case 'campaigns':
                    switch ($data['media']) {
                        case 'google':
                            $updateArray = ['cpaBidAmount' => $data['bidamount']];
                            $zenith = new ZenithGG();
                            $result = $zenith->updateCampaign($data['customer'], $data['id'], $updateArray);
                            if(!empty($result)){
                                $result = [
                                    'id' => $result['id'],
                                    'media' => 'google'
                                ];
                            }
                            break;
                        default:
                            return $this->fail("지원하지 않습니다.");
                    }
                    break;
                default:
                    return $this->fail("잘못된 요청");
            }

            if(!empty($result) && $result['id'] == $data['id']){
                $logData = [
                    'media' => $data['media'] ?? '',
                    'id' => $data['id'] ?? '',
                    'type' => $data['tab'] ?? '',
                    'change_type' => 'bidamount',
                    'old_value' => $data['old_bidamount'] ?? '',
                    'change_value' => $data['bidamount'] ?? '',
                    'nickname' => auth()->user()->username ?? '',
                ];
        
                $logger = new AdvLoggerService();
                $logger->insertLog($logData);

                $result = true;
                return $this->respond($result);
            }else{
                return $this->fail("잘못된 요청");
            }

        }else{
            return $this->fail("잘못된 요청");
        }
    }

    public function updateAdv()
    {
        if($this->request->isAJAX() && strtolower($this->request->getMethod()) === 'put'){
            if (auth()->user()->inGroup('test')) {
                return $this->fail("테스트 계정");
            }
            
            $data = $this->request->getRawInput();
            //$data = $this->request->getGet();
            $result = false;
            $facebookArray = [];
            $googleArray = [];
            $kakaoArray = [];
            foreach ($data['check'] as $id) {
                $sliceId = explode("_", $id);
                $media = $sliceId[0];
                $advId = $sliceId[1];
  
                switch ($media) {
                    case 'facebook':
                        $facebookArray[] = $advId;
                        break;
                    case 'kakao':
                        $kakaoArray[] = $advId;
                        break;
                    case 'google':
                        $googleArray[] = $advId;
                        break;
                    default:
                        return $this->fail("지원하지 않는 매체입니다.");
                }
            }

            if (!empty($facebookArray)) {
                $this->facebook->setUpdatingByAds($facebookArray);

                $zenith = new ZenithFB();
                $updated = $zenith->setManualUpdate($facebookArray);

                if(!empty($updated)){
                    $result = true;
                }else{
                    return $this->fail("수동 업데이트 요청에 실패하였습니다.");
                }
            }

            if (!empty($googleArray)) {
                $ids = $this->google->getCustomerByCampaignId($googleArray);
                $this->google->setUpdatingByAds($googleArray);
                $zenith = new ZenithGG();
                $updated = $zenith->setManualUpdate($ids);

                if(!empty($updated)){
                    $result = true;
                }else{
                    return $this->fail("수동 업데이트 요청에 실패하였습니다.");
                }
            }

            if (!empty($kakaoArray)) {
                $ids = $this->kakao->getAccountByCampaignId($kakaoArray);
                $this->kakao->setUpdatingByAds($kakaoArray);
                $zenith = new ZenithKM();
                $updated = $zenith->setManualUpdate($ids);
                
                if(!empty($updated)){
                    $result = true;
                }else{
                    return $this->fail("수동 업데이트 요청에 실패하였습니다.");
                }
            }

            return $this->respond($result);
        }else{
            return $this->fail("잘못된 요청");
        }
    }

    public function updateCode()
    {
        if($this->request->isAJAX() && strtolower($this->request->getMethod()) === 'put'){
            $data = $this->request->getRawInput();

            $sliceId = explode("_", $data['id']);
            $media = $sliceId[0];
            $adId = $sliceId[1];

            if($data['tab'] == 'ads'){
                $data = [
                    'code' => $data['code'] ?? '',
                    'id' => $adId
                ];

                switch ($media) {
                    case 'facebook':
                        $result = $this->facebook->updateCode($data);
                        break;
                    case 'kakao':
                        $result = $this->kakao->updateCode($data);
                        break;
                    case 'google':
                        $result = $this->google->updateCode($data);
                        break;
                    default:
                        return $this->fail("지원하지 않는 매체입니다.");
                }
            }

            if(isset($result['code'])){
                $result['response'] = true;
                return $this->respond($result);
            }else{
                return $this->fail("잘못된 요청");
            }
        }else{
            return $this->fail("잘못된 요청");
        }
    }

    public function getMemo()
    {
        if($this->request->isAJAX() && strtolower($this->request->getMethod()) === 'get'){
            $param = $this->request->getGet();
            $result = $this->admanager->getMemo($param);
            return $this->respond($result);
        }else{
            return $this->fail("잘못된 요청");
        }
    }

    public function addMemo()
    {
        if($this->request->isAJAX() && strtolower($this->request->getMethod()) === 'post'){
            $param = $this->request->getPost();
            $param['nickname'] = auth()->user()->username;
            $param['is_done'] = 0;
            $result = $this->admanager->addMemo($param);
            return $this->respond($result);
        }else{
            return $this->fail("잘못된 요청");
        }
    }

    public function checkMemo()
    {
        if($this->request->isAJAX() && strtolower($this->request->getMethod()) === 'post'){
            $param = $this->request->getPost();
            $param['done_nickname'] = auth()->user()->username;
            $result = $this->admanager->checkMemo($param);
            return $this->respond($result);
        }else{
            return $this->fail("잘못된 요청");
        }
    }

    public function getChangeLogs()
    {
        if($this->request->isAJAX() && strtolower($this->request->getMethod()) === 'get'){
            $id = $this->request->getGet('id');
            $sdate = $this->request->getGet('sdate');
            $edate = $this->request->getGet('edate');
            $dates = [
                'sdate' => $sdate,
                'edate' => $edate
            ];
            if(!empty($id)){
                $sliceId = explode("_", $id);
                $id = $sliceId[1];
                $result = $this->admanager->getChangeLogs($id, $dates);
            }else{
                $result = $this->admanager->getChangeLogs(null, $dates);
            }
            
            return $this->respond($result);
        }else{
            return $this->fail("잘못된 요청");
        }
    }

	private function getCareLabsData($arg)
	{
		$url = "https://carezenith.co.kr/resta/get-adv?".http_build_query($arg);
		$ch = curl_init();
		curl_setopt($ch, CURLOPT_URL, $url);
		curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 3);
		curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
		$response = curl_exec($ch);
		curl_close($ch);

		return $response;
	}
}