<?php

namespace app\admin\controller;

use think\Exception;
use think\facade\Cache;
use think\facade\Config;
use think\facade\Db;
use think\facade\View;
use think\facade\Request;
use app\admin\model\LanguagePag as LanguagePagModel;
use app\admin\model\Language;

class LanguagePag extends Common {
    private $tableName = 'language_pag';
    private $viewPath = 'languagePag';
    
    /**
     * 货运属性列表
     * @return string
     */
    public function index() {
        ////////
        if (!Request::isPost()) {
            $other['title'] = '多语言包管理';
            View::assign('other', $other);
            View::assign('viewPath', $this->viewPath);
            return View::fetch();
        } else {
            try {
                $platform_type = input('platform_type');
                $lang = input('lang');
                $type = input('type');
                $name = input('name');
                $value = input('value');
                $condition = [];
                if (!empty($platform_type)) {
                    $condition[] = ['platform_type', '=', $platform_type];
                }
                if (!empty($lang)) {
                    $condition[] = ['lang', '=', $lang];
                }
                if (!empty($type)) {
                    $condition[] = ['type', '=', $type];
                }
                if (!empty($name)) {
                    $condition[] = ['name', 'like', "%$name%"];
                }
                if (!empty($value)) {
                    $condition[] = ['value', 'like', "%$value%"];
                }
                
                $p = input('p', 1);
                $other['page_size'] = input('page_size', 20);
                $order = 'id desc';
                $count = LanguagePagModel::where($condition)->count();
                $list = LanguagePagModel::field("id,lang,type,name,value,platform_type")->append(['from_value'])->where($condition)->order($order)->page($p, $other['page_size'])->select()->toArray();
                $other['count'] = $count;
                if (!$list) {
                    $list = [];
                }
                $result['other'] = $other;
                $result['list'] = $list;
                return $this->successResponse($result);
            } catch (Exception $exc) {
                return $this->errorResponse($exc->getMessage());
            }
        }
    }
    
    /*
     * 同步语言包
     */
    public function sync() {
        try {
            if (!Request::isPost()) {
                throw new Exception(lang('request_method_incorrect'));
            }
            $data = Request::post();
            if (!isset($data['from_id']) || !is_numeric($data['from_id']) || $data['from_id'] < 1) {
                throw new Exception('源语言ID错误');
            }
            $from_id = $data['from_id'];
            if (!isset($data['to_id']) || !is_numeric($data['to_id']) || $data['to_id'] < 1) {
                throw new Exception('目标语言ID错误');
            }
            $to_id = $data['to_id'];
            //获取源语言
            $from = Language::find($from_id);
            if ($from->isEmpty()) {
                throw new Exception('源语言不存在');
            }
            $platform_type = $data['platform_type'];//平台类型
            
            //获取目标语言
            $to = Language::find($to_id);
            if ($to->isEmpty()) {
                throw new Exception('目标语言不存在');
            }
            //获取源语言
            $pags = LanguagePagModel::where(['platform_type' => $platform_type, 'lang' => $from['symbol']])
                ->order(['type' => 'asc', 'name' => 'asc'])
                ->select()
                ->toArray();
            
            foreach ($pags as &$pag) {
                //查询是否存在
                $to_pag = LanguagePagModel::where(['platform_type' => $platform_type, 'lang' => $to['symbol'], 'type' => $pag['type'], 'name' => $pag['name']])->findOrEmpty();
                if ($to_pag->isEmpty()) {
                    LanguagePagModel::create([
                        'platform_type' => $platform_type,
                        'lang'          => $to['symbol'],
                        'type'          => $pag['type'],
                        'name'          => $pag['name'],
                    ]);
                }
            }
            Db::commit();
            return $this->successResponse('同步成功！');
        } catch (Exception $exc) {
            return $this->errorResponse($exc->getMessage());
        }
    }
    
    /*
     * 翻译语言包
     */
    public function trans() {
        try {
            if (!Request::isPost()) {
                throw new Exception(lang('request_method_incorrect'));
            }
            $data = Request::post();
            if (!isset($data['from_id']) || !is_numeric($data['from_id']) || $data['from_id'] < 1) {
                throw new Exception('源语言ID错误');
            }
            $from_id = $data['from_id'];
            if (!isset($data['to_id']) || !is_numeric($data['to_id']) || $data['to_id'] < 1) {
                throw new Exception('目标语言ID错误');
            }
            $to_id = $data['to_id'];
            //获取源语言
            $from = Language::find($from_id);
            if ($from->isEmpty()) {
                throw new Exception('源语言不存在');
            }
            //获取目标语言
            $to = Language::find($to_id);
            if ($to->isEmpty()) {
                throw new Exception('目标语言不存在');
            }
            $platform_type = $data['platform_type'];//平台类型
            //获取待翻译目标语言
            $pags = LanguagePagModel::where(['platform_type' => $platform_type, 'lang' => $to['symbol']])
                ->where(" value IS NULL OR value='' ")
                ->order(['type' => 'asc', 'name' => 'asc'])
                ->select()
                ->toArray();
            
            $qArray = array();
            
            $idArray = array();
            foreach ($pags as &$pag) {
                //查询源语言
                $from_pag = LanguagePagModel::where(['platform_type' => $platform_type, 'lang' => $from['symbol'], 'type' => $pag['type'], 'name' => $pag['name']])->where(" value IS NOT NULL  OR value='' ")->findOrEmpty();
                if ($from_pag->isEmpty()) {
                    continue;
                } else {
                    array_push($qArray, $from_pag['value']);
                    array_push($idArray, $pag['id']);
                }
            }
            if (count($qArray) == 0) throw new Exception('不存在待翻译的内容');
            $YDObj = new  \app\common\service\YouDaoTrans();
            $ret = $YDObj->do_translate($qArray, $from['trans_symbol'], $to['trans_symbol']);
            $ret = json_decode($ret, TRUE);
            if ($ret['errorCode'] != 0) {
                throw new Exception('错误代码：' . $ret['errorCode'] . '，请核对错误代码列表');
            }
            foreach ($idArray as $key => $id) {
                LanguagePagModel::update([
                    'id'    => $id,
                    'value' => $ret['translateResults'][$key]['translation'],
                ]);
            }
            Db::commit();
            return $this->successResponse('翻译成功！');
        } catch (Exception $exc) {
            return $this->errorResponse($exc->getMessage());
        }
    }
    
    public function getLanguageList() {
        ////////
        try {
            if (!Request::isPost()) {
                throw new Exception(lang('request_method_incorrect'));
            }
            $condition['is_show'] = 1;
            $order = 'order_id asc,id asc';
            $list = Db::name('language')->field("*")->where($condition)->order($order)->select()->toArray();
            if (!$list) {
                $list = [];
            }
            $result['list'] = $list;
            return $this->successResponse($result);
        } catch (Exception $exc) {
            return $this->errorResponse($exc->getMessage());
        }
        
    }
    
    /**
     *保存
     */
    public function save() {
        //开始事务
        Db::startTrans();
        try {
            if (!Request::isPost()) {
                throw new Exception(lang('request_method_incorrect'));
            }
            $data = Request::post();
            $id = input('post.id');
            if (!is_numeric($id) || $id < 1) {
                unset($data['id']);
            }
            $validate = new \app\admin\validate\LanguagePag();
            $check_result = $validate->check($data);
            if (!$check_result) {
                throw new Exception($validate->getError());
            }
            
            if (is_numeric($id) && $id > 0) {
                //更新数据
                $update_result = LanguagePagModel::where('id', $id)->withoutField('id')->update($data);
                if ($update_result === FALSE) {
                    throw new Exception(lang('editing_failed'));
                }
                //提交事务
                Db::commit();
                return $this->successResponse('修改成功！');
            } else {
                //添加数据
                $add_result = LanguagePagModel::insertGetId($data);
                if (!$add_result) {
                    throw new Exception(lang('add_failed'));
                }
                //提交事务
                Db::commit();
                return $this->successResponse('添加成功！');
            }
        } catch (Exception $exc) {
            // 回滚事务
            Db::rollback();
            return $this->errorResponse($exc->getMessage());
        }
    }
    
    /**
     * 删除
     * @return array|int[]
     */
    public function delete() {
        if (!Request::isPost()) {
            return $this->errorResponse(lang('request_method_incorrect'));
        }
        //开始事务
        Db::startTrans();
        try {
            $id = input('id');
            if (!is_numeric($id)) {
                return $this->errorResponse(lang('parameter_error'));
            }
            $condition['id'] = $id;
            $info = Db::name($this->tableName)->field('id')->where($condition)->find();
            if (!$info) {
                return $this->errorResponse(lang('parameter_error'));
            }
            Db::name($this->tableName)->where('id', $id)->delete();
            //提交事务
            Db::commit();
            return $this->successResponse('删除成功！');
        } catch (Exception $exc) {
            // 回滚事务
            Db::rollback();
            return $this->errorResponse($exc->getMessage());
        }
    }
    
    /*
     * 清除值
     */
    public function clearValue() {
        if (!Request::isPost()) {
            return $this->errorResponse(lang('request_method_incorrect'));
        }
        //开始事务
        Db::startTrans();
        try {
            $id = input('id');
            if (!is_numeric($id)) {
                return $this->errorResponse(lang('parameter_error'));
            }
            $condition['id'] = $id;
            $info = Db::name($this->tableName)->field('id')->where($condition)->find();
            if (!$info) {
                return $this->errorResponse(lang('parameter_error'));
            }
            Db::name($this->tableName)->where('id', $id)->update(['value'=>'']);
            //提交事务
            Db::commit();
            return $this->successResponse('值已清空！');
        } catch (Exception $exc) {
            // 回滚事务
            Db::rollback();
            return $this->errorResponse($exc->getMessage());
        }
    }
    /*
     * 生成json包
     */
    public function createJson() {
        try {
            if (!Request::isPost()) {
                throw new Exception(lang('request_method_incorrect'));
            }
            $list = Language::order('order_id asc,id asc')->select()->toArray();
            foreach ($list as $item) {
                $paglist = LanguagePagModel::field("platform_type,lang,type,name,value")
                    ->where(['lang' => $item['symbol']])
                    ->order(['type' => 'asc', 'name' => 'asc', 'value' => 'asc'])
                    ->select()
                    ->toArray();
                if (!$paglist) {
                    continue;
                }
                foreach ($paglist as $pag){
                    $pag_result[$pag['platform_type']][$pag['lang']][$pag['type']][$pag['name']] = $pag['value'];
                }
                //生成json包
                foreach ($pag_result as $pltype => $platformtype){
                    //平台类型
                    foreach ($platformtype as $lang => $paglang){
                        $json = json_encode($paglang, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE);
                        // 保存文件
                        g_mkdir("./static/lang/$pltype");
                        $filePath="./static/lang/$pltype/$lang" . '.json';
                        file_put_contents($filePath, $json);
                    }
                }
            }
            $result='生成成功！';
            return $this->successResponse($result);
        } catch (Exception $exc) {
            return $this->errorResponse($exc->getMessage());
        }
    }
    
    
}