<?php
if (!defined('IN_OAOOA')) {
    exit('Access Denied');
}

class table_pichome_vapp extends dzz_table
{
    public function __construct()
    {

        $this->_table = 'pichome_vapp';
        $this->_pk = 'appid';
        $this->_pre_cache_key = 'pichome_vapp';
        $this->_cache_ttl = 3600;
        parent::__construct();
    }

    public function fetchByAppid($appid,$hasdel=1){
        $appdata = [];
        //不包含删除状态库
        if(!$hasdel){
            $data =  DB::fetch_first('SELECT * FROM %t WHERE appid=%s and isdelete < %d', array($this->_table, $appid,1));
        }else{
            $data = parent::fetch($appid);
        }
        Hook::listen("vappdataFilter",$data,false);
        return $data;
    }
    public function updateByAppid($appid,$setarr){
        $setarr['appid'] = $appid;
        Hook::listen('vappupdateBefore',$setarr);
        parent::update($appid,$setarr);
        return $appid;
    }
    private function code62($x)
    {
        $show = '';
        while ($x > 0) {
            $s = $x % 62;
            if ($s > 35) {
                $s = chr($s + 61);
            } elseif ($s > 9 && $s <= 35) {
                $s = chr($s + 55);
            }
            $show .= $s;
            $x = floor($x / 62);
        }
        return $show;
    }

    public function getSid($url)
    {
        $microtime = microtime();
        list($msec, $sec) = explode(' ', $microtime);
        $msec = $msec * 1000000;
        $url = crc32($url . $sec . random(6) . $msec);
        $result = sprintf("%u", $url);
        $sid = self::code62($result);
        $len = strlen($sid);
        if ($len < 6) {
            $sid .= random(1);
        }
        if (strlen($sid) > 6) {
            $sid = substr($sid, 0, 6);
        }
        if (DB::result_first("select appid from %t where appid = %s", array($this->_table, $sid))) {
            $sid = $this->getSid($url);
        }
        return $sid;
    }

    public function insert_data($setarr)
    {
        //如果为oaooa库时
        $path = $setarr['path'];
        if ($path && $appid = DB::result_first("select appid from %t where path = %s and isdelete = 0", array($this->_table, $setarr['path']))) {
            parent::update($appid, $setarr);
            return $appid;
        }
        //生成appid
        $setarr['appid'] = $this->getSid($path);

        if (parent::insert($setarr)) {
            $indexarr = $setarr;
            Hook::listen('addvappafter', $indexarr);
            return $setarr['appid'];
        }
    }

    public function fetch_by_path($path)
    {
        return DB::fetch_first("select * from %t where path = %s", array($this->_table, $path));
    }

    //获取不重复的应用名称
    public function getNoRepeatName($name)
    {
        static $i = 0;
        if (DB::result_first("select COUNT(appid) from %t where appname=%s ", array($this->_table, $name))) {
            $name = preg_replace("/\(\d+\)/i", '', $name) . '(' . ($i + 1) . ')';
            $i += 1;
            return $this->getNoRepeatName($name);
        } else {
            return $name;
        }
    }

    //删除虚拟应用
    public function delete_vapp_by_appid($appid)
    {
        $appdata = parent::fetch($appid);
        //删除文件表数据
        C::t('pichome_resources')->delete_by_appid($appid);
        //删除目录表数据
        C::t('pichome_folder')->delete_by_appid($appid);
        //删除目录文件关系表数据
        C::t('pichome_folderresources')->delete_by_appid($appid);
        //删除标签分类表数据
        C::t('pichome_taggroup')->delete_by_appid($appid);
        //删除标签关系表数据
        C::t('pichome_tagrelation')->delete_by_appid($appid);
        //删除最近搜索表数据
        C::t('pichome_searchrecent')->delete_by_appid($appid);
        //删除库成员数据
        C::t('pichome_vappmember')->delete_by_appid($appid);
        //删除库标签数据
        C::t('pichome_folder_tag')->delete_by_appid($appid);
        C::t('pichome_resources_tag')->delete_by_appid($appid);
        C::t('pichome_vapp_tag')->delete_by_appid($appid);
        C::t('pichome_route')->delete_by_appid($appid);
        //resources表数据未完成删除前不允许删除vapp表
        if (DB::result_first("select count(rid) from %t where appid = %s", array('pichome_resources', $appid))) {
            return;
        }

        $hookdata = ['appid' => $appid, 'apptype' => $appdata['type']];
        Hook::listen('pichomevappdelete', $hookdata);
        parent::delete($appid);
        return true;


    }

    public function getpermbypermdata($permdata,$appid, $perm = '')
    {
        global $_G;
        $permdata = ($permdata === '1') ? '1':unserialize($permdata);
        $uid = isset($_G['uid']) ? $_G['uid'] : 0;
        if($_G['amidnid'] == 1 || C::t('pichome_vappmember')->checkuserperm_by_appid($appid)){
            $adminperm = 1;
        }else{
            $adminperm = 0;
        }
        if ($adminperm) return true;

        if ($perm == 'download' && (isset($_G['config']['pichomeclosedownload']) && $_G['config']['pichomeclosedownload'])) {
            return false;
        }

        if ($perm == 'share' && (isset($_G['config']['pichomecloseshare']) && $_G['config']['pichomecloseshare'])) {
            return false;
        }

        if (!$permdata) return false;
        if ($permdata === '1') return true;
        $uorgids = [];
        if ($uid && $_G['adminid'] != 1) {
            //获取用户机构部门数据
            foreach (DB::fetch_all("select ou.orgid,o.pathkey from %t ou left join %t o on o.orgid=ou.orgid 
                where ou.uid = %d", array('organization_user', 'organization', $uid)) as $v) {
                $tmporgids = explode(',', str_replace('-', '', $v['pathkey']));
                $torgids = [];
                foreach ($tmporgids as $ov) {
                    $tmpgid = explode('_', $ov);
                    $torgids = array_merge($torgids, $tmpgid);
                }
                $torgids = array_unique(array_filter($torgids));
                $uorgids = array_merge($uorgids, $torgids);
            }
        }
        $hasother = false;
        //判断是否包含无用户组用户
        if (isset($permdata['groups'])) {
            if (in_array('other', $permdata['groups'])) {
                $otherindex = array_search('other', $permdata['groups']);
                unset($permdata['groups'][$otherindex]);
                $hasother = true;
            }
        }
        //判断有权限用户中是否有当前用户
        if ($permdata['uids'] || $hasother) {
            //查询无组用户
            if ($hasother) {
                foreach (DB::fetch_all("select u.uid from %t u left join %t ou on u.uid=ou.uid where 1", array('user', 'organization_user')) as $u) {
                    $permdata['uids'][] = $u['uid'];
                }
            }
            if (in_array($uid, $permdata['uids'])) return true;
        }
        //判断有权限组中是否有当前用户
        if ($permdata['groups']) {
            $intersectarr = array_intersect($permdata['groups'], $uorgids);
            if (!empty($intersectarr)) return true;
        }
        return false;

    }

    public function fetch_all_sharedownlod($appid = '')
    {
        $downshare = array();
        if ($appid) {
            $downshare = DB::fetch_first("select * from %t where isdelete < 1 and appid = %s", array($this->_table, $appid));
           /* $downshare['download'] =$downshare['download'];
            $downshare['share'] =$downshare['share'];
            $downshare['view'] =$downshare['view'];*/
        } else {

            foreach (DB::fetch_all("select * from %t where isdelete < 1", array($this->_table)) as $v) {

             /*   $v['download'] =$v['download'];
                $v['share'] = $v['share'];
                $v['view'] = $v['view'];*/
                $downshare[$v['appid']] = $v;
            }
        }
        return $downshare;
    }

    public function add_getinfonum_by_appid($appid, $ceof = 1)
    {
        $appdata = C::t('pichome_vapp')->fetch($appid);
        if ($ceof < 0) {
            if ($appdata['getinfonum'] == 0) return true;
            elseif ($appdata['getinfonum'] < abs($ceof)) $ceof = -$appdata['getinfonum'];

        }

        if ($ceof > 0) {
            DB::query("update %t set getinfonum=getinfonum+%d where appid = %s", array($this->_table, $ceof, $appid));
        } else {
            DB::query("update %t set getinfonum=getinfonum-%d where appid = %s", array($this->_table, abs($ceof), $appid));
        }
        $this->clear_cache($appid);
    }


    public function addcopy_by_appid($appids, $ceof = 1)
    {
        if (!is_array($appids)) $appids = array($appids);

        if ($ceof > 0) {
            DB::query("update %t set filenum=filenum+%d where appid IN(%n)", array($this->_table, $ceof, $appids));
        } else {
            DB::query("update %t set filenum=filenum-%d where appid IN(%n)", array($this->_table, abs($ceof), $appids), true);
        }
        $this->clear_cache($appids);
    }

    public function fetch_all_by_type($type = -1, $isdelete = 0)
    {
        $param = array($this->table, $isdelete);
        $sql = "isdelete=%d";
        if ($type > -1) {
            $sql .= " and type=%d";
            $param[] = $type;
        }
        return DB::fetch_all("select * from %t where $sql", $param);
    }

//删除标注中的标签组字段
    public function del_fileds_by_gid($gid)
    {
        if (!$gid) return false;
        foreach (DB::fetch_all("select appid,fileds from %t where isdelete < 1", array('pichome_vapp')) as $v) {
            $appid = $v['appid'];
            $fileds = unserialize($v['fileds']);
            if ($fileds) {
                foreach ($fileds as $k => $val) {
                    if ($val['type'] == 'tabgroup' && $val['flag'] == 'tabgroup_' . $gid) {
                        unset($fileds[$k]);
                        C::t('#pichome#pichome_vapp')->update($appid, ['fileds' => serialize($fileds)]);
                    }

                }
            }
        }
    }

    //改变标注中标签组的状态
    public function update_fileds_by_gid($gid, $status = 0)
    {
        if (!$gid) return false;
        foreach (DB::fetch_all("select appid,fileds from %t where isdelete < 1", array('pichome_vapp')) as $v) {
            $appid = $v['appid'];
            $fileds = unserialize($v['fileds']);
            if ($fileds) {
                foreach ($fileds as $k => $val) {
                    if ($val['type'] == 'tabgroup' && $val['flag'] == 'tabgroup_' . $gid) {
                        $fileds[$k] = ['flag' => $v['flag'], 'type' => 'tabgroup', 'name' => $v['name'], 'checked' => $v['checked'], 'enable' => $status];
                        C::t('pichome_vapp')->update($appid, ['fileds' => serialize($fileds)]);

                    }

                }
            }
        }
    }

    //增加标注字段
    public function add_filed_to_fileds($fileddata)
    {
        if (!$fileddata) return false;
        foreach (DB::fetch_all("select appid,fileds from %t where isdelete < 1", array('pichome_vapp')) as $v) {
            $appid = $v['appid'];
            $fileds = unserialize($v['fileds']);
            if (!$fileds) $fileds = [];
            $fileds[] = $fileddata;
            C::t('pichome_vapp')->update($appid, ['fileds' => serialize($fileds)]);
        }

    }

}