<?php
/**
 * The model file of entry module of ZDOO.
 *
 * @copyright   Copyright 2009-2018 青岛易软天创网络科技有限公司(QingDao Nature Easy Soft Network Technology Co,LTD, www.cnezsoft.com)
 * @license     ZPL (http://zpl.pub/page/zplv12.html)
 * @author      Yidong Wang <yidong@cnezsoft.com>
 * @package     entry
 * @version     $Id: model.php 4205 2016-10-24 08:19:13Z liugang $
 * @link        http://www.zdoo.com
 */
class entryModel extends model
{
    /**
     * Get all entries.
     *
     * @param  string $type         custom | system
     * @param  int    $category
     * @param  string $platform     zdoo| xuanxuan
     * @access public
     * @return array
     */
    public function getEntries($type = 'custom', $category = 0, $platform = 'zdoo')
    {
        $entries = $this->dao->select('*')->from(TABLE_ENTRY)
            ->where(1)
            ->beginIF(!empty($category))->andWhere('category')->eq($category)->fi()
            ->orderBy('`order`, id')
            ->fetchAll();

        $categories = $this->dao->select('distinct t1.id, t1.name, t1.order, t2.platform')->from(TABLE_CATEGORY)->alias('t1')
            ->leftJoin(TABLE_ENTRY)->alias('t2')->on('t1.id=t2.category')
            ->where('t1.type')->eq('entry')
            //->andWhere('t2.visible')->eq(1)
            //->andWhere('t2.category')->ne(0)
            ->orderBy('t1.order')
            ->fetchAll('id');

        foreach($categories as $category)
        {
            $entry = new stdclass();
            $entry->id          = 'category' . $category->id;
            $entry->name        = $category->name;
            $entry->code        = '';
            $entry->abbr        = isset($category->abbr) ? $category->abbr : $category->name;
            $entry->platform    = $category->platform;
            $entry->buildin     = 0;
            $entry->integration = 0;
            $entry->open        = '';
            $entry->key         = '';
            $entry->ip          = '';
            $entry->logo        = '';
            $entry->login       = '';
            $entry->logout      = '';
            $entry->block       = '';
            $entry->control     = '';
            $entry->size        = '';
            $entry->position    = '';
            $entry->visible     = 1;
            $entry->order       = $category->id;
            $entry->zentao      = 0;
            $entry->category    = 0;

            $entries[] = $entry;
        }

        /* Remove entry if no rights and fix logo path. */
        $newEntries = array();
        $this->app->loadLang('install');
        foreach($entries as $index => $entry)
        {
            if($entry->platform && !empty($platform) && strpos(',' . $entry->platform . ',', ',' . $platform . ',') === false)
            {
                unset($entries[$index]);
                continue;
            }

            if($entry->logo != '' && substr($entry->logo, 0, 1) != '/') $entry->logo = $this->config->webRoot . $entry->logo;
            if(commonModel::hasAppPriv($entry->code)) $newEntries[] = $entry;
        }
        $entries = $newEntries;

        if($type == 'mobile')
        {
            $this->app->loadLang('index', 'sys');   // Must pass 'sys' as value of the param app.

            $dashboardEntry = new stdclass();
            $dashboardEntry->id       = 'dashboard';
            $dashboardEntry->buildin  = true;
            $dashboardEntry->code     = 'dashboard';
            $dashboardEntry->name     = $this->lang->index->dashboard;
            $dashboardEntry->abbr     = $this->lang->index->dashboardAbbr;
            $dashboardEntry->icon     = 'icon-home';
            $dashboardEntry->url      = helper::createLink('sys.index');
            $dashboardEntry->order    = 0;
            $dashboardEntry->category = 0;
            $entries[] = $dashboardEntry;

            if($this->app->user->admin == 'super' || commonModel::hasAppPriv('superadmin'))
            {
                $adminEntry = new stdclass();
                $adminEntry->id       = 'superadmin';
                $adminEntry->buildin  = true;
                $adminEntry->code     = 'superadmin';
                $adminEntry->name     = $this->lang->index->superAdmin;
                $adminEntry->abbr     = $this->lang->index->superAdmin;
                $adminEntry->icon     = 'icon-cog';
                $adminEntry->url      = helper::createLink('admin');
                $adminEntry->order    = 999999;
                $adminEntry->category = 0;
                $entries[] = $adminEntry;
            }

            usort($entries, 'commonModel::sortEntryByOrder');
            $newEntries = array();
            foreach($entries as $entry)
            {
                if(empty($entry->url)) $entry->url = helper::createLink('entry', 'visit', "entryID=$entry->id");
                $newEntries[$entry->id] = $entry;
            }
            return $newEntries;
        }
        if($type != 'custom') return $entries;

        /* Add custom settings. */
        $customApp = isset($this->config->personal->common->customApp) ? json_decode($this->config->personal->common->customApp->value) : new stdclass();
        foreach($entries as $entry)
        {
            if(isset($customApp->{$entry->id}))
            {
                if(isset($customApp->{$entry->id}->order))   $entry->order   = $customApp->{$entry->id}->order;
                if(isset($customApp->{$entry->id}->visible)) $entry->visible = $customApp->{$entry->id}->visible;
            }
        }
        usort($entries, 'commonModel::sortEntryByOrder');

        return $entries;
    }

    /**
     * Get entry by id.
     *
     * @param  int    $entryID
     * @access public
     * @return object
     */
    public function getById($entryID)
    {
        return $this->dao->select('*')->from(TABLE_ENTRY)->where('id')->eq($entryID)->fetch();
    }

    /**
     * Get entry by code.
     *
     * @param  string $code
     * @access public
     * @return object
     */
    public function getByCode($code)
    {
        return $this->dao->select('*')->from(TABLE_ENTRY)->where('code')->eq($code)->fetch();
    }

    /**
     * Get entry pairs.
     *
     * @param  string $params
     * @param  bool   $buildin
     * @access public
     * @return array
     */
    public function getPairs($params = '', $buildin = false)
    {
        $entries = $this->dao->select('code, name')->from(TABLE_ENTRY)
            ->where(1)
            ->beginIF($buildin)->andWhere('buildin')->eq(1)->fi()
            ->fetchPairs();
        if(strpos($params, 'noempty') === false) $entries = array('' => '') + $entries;

        return $entries;
    }

    /**
     * Create entry.
     *
     * @access public
     * @return void
     */
    public function create()
    {
        $maxOrder = $this->dao->select('`order`')->from(TABLE_ENTRY)->orderBy('order_desc')->limit(1)->fetch('order');

        $entry = fixer::input('post')
            ->setDefault('ip', '*')
            ->setDefault('visible', 0)
            ->setDefault('buildin', 0)
            ->setDefault('integration', 0)
            ->setDefault('order', $maxOrder + 10)
            ->setDefault('open', 'iframe')
            ->setDefault('control', 'none')
            ->setDefault('size', 'max')
            ->setDefault('width', '700')
            ->setDefault('height', '538')
            ->setDefault('position', 'default')
            ->setDefault('zentao', 0)
            ->join('platform', ',')
            ->setIF($this->post->allip, 'ip', '*')
            ->setIF($this->post->zentao, 'open', 'iframe')
            ->setIF($this->post->zentao, 'integration', 1)
            ->setIF($this->post->zentao, 'control', 'full')
            ->remove('allip,adminAccount,adminPassword,files,labels')
            ->stripTags('login,logout,block', $this->config->allowedTags)
            ->get();

        if($this->post->chanzhi)
        {
            $entry->logout = $entry->login . "?m=zdoo&f=logout";
            $entry->block  = $entry->login . "?m=zdoo&f=block";
            $entry->login .= "?m=zdoo&f=login";
        }

        if($entry->size == 'custom') $entry->size = helper::jsonEncode(array('width' => (int)$entry->width, 'height' => (int)$entry->height));

        $this->dao->insert(TABLE_ENTRY)
            ->data($entry, $skip = 'width,height,files,chanzhi,groups')
            ->autoCheck()
            ->batchCheck($this->config->entry->require->create, 'notempty')
            ->check('code', 'unique')
            ->check('code', 'code')
            ->check('code', 'notInt')
            ->exec();

        if(dao::isError()) return false;

        $entryID = $this->dao->lastInsertID();
        $files = $this->loadModel('file')->saveUpload('entry', $entryID);
        if($files)
        {
            $lastFileID = array_keys($files);
            $this->dao->update(TABLE_ENTRY)->set('package')->eq(end($lastFileID))->where('id')->eq($entryID)->exec();
        }

        /* Insert app privilage. */
        $groups = $this->post->groups;
        if($groups != false && !empty($groups))
        {
            $priv = new stdclass();
            $priv->module = 'apppriv';
            $priv->method = $this->post->code;
            foreach($this->post->groups as $group)
            {
                $priv->group = $group;
                $this->dao->replace(TABLE_GROUPPRIV)->data($priv)->exec();
            }
        }

        return $entryID;
    }

    /**
     * Update entry.
     *
     * @param  int    $code
     * @access public
     * @return void
     */
    public function update($code)
    {
        $oldEntry = $this->getByCode($code);
        $entry = fixer::input('post')->stripTags('login', $this->config->allowedTags)->join('platform', ',')->remove('files,labels')->get();
        if(!isset($entry->visible)) $entry->visible = 0;

        $this->dao->update(TABLE_ENTRY)->data($entry)
            ->autoCheck()
            ->batchCheck($this->config->entry->require->edit, 'notempty')
            ->where('code')->eq($code)
            ->exec();
        $files = $this->loadModel('file')->saveUpload('entry', $oldEntry->id);
        if($files)
        {
            $lastFileID = array_keys($files);
            $this->dao->update(TABLE_ENTRY)->set('package')->eq(end($lastFileID))->where('id')->eq($oldEntry->id)->exec();
        }
        return !dao::isError();
    }

    /**
     * Set style for entry.
     *
     * @param  string    $code
     * @access public
     * @return int
     */
    public function setStyle($code)
    {
        $oldEntry = $this->getByCode($code);

        $entry = fixer::input('post')->get();

        if($entry->size == 'custom') $entry->size = helper::jsonEncode(array('width' => (int)$entry->width, 'height' => (int)$entry->height));
        if($oldEntry->buildin) $entry->open = 'iframe';
        unset($entry->logo);

        $this->dao->update(TABLE_ENTRY)->data($entry, $skip = 'width,height,files')
            ->autoCheck()
            ->where('code')->eq($code)
            ->exec();

        return $oldEntry->id;
    }

    /**
     * Integration entry.
     *
     * @param  string    $code
     * @access public
     * @return void
     */
    public function integration($code)
    {
        $entry = fixer::input('post')
            ->setDefault('ip', '*')
            ->setDefault('integration', 0)
            ->setIF($this->post->allip, 'ip', '*')
            ->stripTags('logout,block', $this->config->allowedTags)
            ->remove('allip')
            ->get();

        $this->dao->update(TABLE_ENTRY)->data($entry)->autoCheck()->where('code')->eq($code)->exec();
        return !dao::isError();
    }

    /**
     * Delete entry.
     *
     * @param  string $code
     * @access public
     * @return void
     */
    public function delete($code, $table = null)
    {
        $entry = $this->getByCode($code);

        $this->deleteLogo($entry->id);
        $this->dao->delete()->from(TABLE_ENTRY)->where('code')->eq($code)->exec();

        return !dao::isError();
    }

    /**
     * Update status for entry.
     *
     * @param $code
     * @return bool
     */
    public function updateStatus($code)
    {
        $entry  = $this->getByCode($code);
        $status = $entry->status == 'online' ? 'offline' : 'online';
        $this->dao->update(TABLE_ENTRY)->set('status')->eq($status)->where('code')->eq($code)->exec();
        return !dao::isError();
    }

    /**
     * Get key of entry.
     *
     * @param  string $entry
     * @access public
     * @return object
     */
    public function getAppKey($entry)
    {
        return $this->config->entry->$entry->key;
    }
    /**
     * Create a key.
     *
     * @access public
     * @return string
     */
    public function createKey()
    {
        return md5(rand());
    }

    /**
     * Get all departments.
     *
     * @access public
     * @return object
     */
    public function getAllDepts()
    {
        return $this->dao->select('*')->from(TABLE_DEPT)->fetchAll();
    }

    /**
     * Get all users.
     *
     * @access public
     * @return object
     */
    public function getAllUsers()
    {
        return $this->dao->select('*')->from(TABLE_USER)
            ->where('deleted')->eq(0)
            ->fetchAll();
    }

    /**
     * Update entry logo.
     *
     * @param  int    $entryID
     * @access public
     * @return void
     */
    public function updateLogo($entryID)
    {
        /* if no files then return. */
        if(empty($_FILES)) return true;

        /* Delete logo img. */
        $this->deleteLogo($entryID);

        /* Save logo img. */
        $fileTitle = $this->file->saveUpload('entryLogo', $entryID);
        if(!dao::isError())
        {
            $file = $this->file->getByID(key($fileTitle));

            $logoPath = $this->file->webPath . $this->file->getRealPathName($file->pathname);
            $this->dao->update(TABLE_ENTRY)->set('logo')->eq($logoPath)->where('id')->eq($entryID)->exec();
        }
    }

    /**
     * Delete entry logo.
     *
     * @param  int    $entryID
     * @access public
     * @return void
     */
    public function deleteLogo($entryID)
    {
        $files = $this->loadModel('file')->getByObject('entryLogo', $entryID);

        foreach($files as $file) $this->file->delete($file->id);
    }

    /**
     * Get blocks by API.
     *
     * @param  object    $entry
     * @access public
     * @return array
     */
    public function getBlocksByAPI($entry)
    {
        if(empty($entry)) return array();
        $parseUrl   = parse_url($entry->block);
        $blockQuery = "mode=getblocklist&hash={$entry->key}&lang=" . str_replace('-', '_', $this->app->getClientLang());
        $parseUrl['query'] = empty($parseUrl['query']) ? $blockQuery : $parseUrl['query'] . '&' . $blockQuery;

        $link = '';
        if(!isset($parseUrl['scheme']))
        {
            $link  = commonModel::getSysURL() . $parseUrl['path'];
            $link .= '?' . $parseUrl['query'];
        }
        else
        {
            $link .= $parseUrl['scheme'] . '://' . $parseUrl['host'];
            if(isset($parseUrl['port'])) $link .= ':' . $parseUrl['port'];
            if(isset($parseUrl['path'])) $link .= $parseUrl['path'];
            $link .= '?' . $parseUrl['query'];
        }

        $blocks = commonModel::http($link);
        return json_decode($blocks, true);
    }

    /**
     * Get block params.
     *
     * @param  object $entry
     * @param  int    $blockID
     * @access public
     * @return json
     */
    public function getBlockParams($entry, $blockID)
    {
        if(empty($entry)) return array();
        $parseUrl  = parse_url($entry->block);
        $formQuery = "mode=getblockform&blockid=$blockID&hash={$entry->key}&lang=" . str_replace('-', '_', $this->app->getClientLang());
        $parseUrl['query'] = empty($parseUrl['query']) ? $formQuery : $parseUrl['query'] . '&' . $formQuery;

        $link = '';
        if(!isset($parseUrl['scheme']))
        {
            $link  = commonModel::getSysURL() . $parseUrl['path'];
            $link .= '?' . $parseUrl['query'];
        }
        else
        {
            $link .= $parseUrl['scheme'] . '://' . $parseUrl['host'];
            if(isset($parseUrl['port'])) $link .= ':' . $parseUrl['port'];
            if(isset($parseUrl['path'])) $link .= $parseUrl['path'];
            $link .= '?' . $parseUrl['query'];
        }

        $params = commonModel::http($link);

        return json_decode($params, true);
    }

    /**
     * Get entries of json.
     *
     * @access public
     * @return void
     */
    public function getJSONEntries()
    {
        $entries    = $this->getEntries();
        $allEntries = array();

        foreach($entries as $entry)
        {
            $sso     = helper::createLink('entry', 'visit', "entryID=$entry->id");
            $logo    = !empty($entry->logo) ? $entry->logo : '';
            $size    = !empty($entry->size) ? ($entry->size != 'max' ? $entry->size : "'$entry->size'") : "'max'";
            $menu    = $entry->visible ? 'all' : 'list';
            $display = $entry->buildin ? 'fixed' : 'sizeable';

            /* add web root if logo not start with /  */
            if($logo != '' && substr($logo, 0, 1) != '/') $logo = $this->config->webRoot . $logo;

            if(!isset($entry->control))  $entry->control = '';
            if(!isset($entry->position)) $entry->position = '';
            unset($tmpEntry);
            $tmpEntry['id']       = $entry->id;
            $tmpEntry['name']     = $entry->name;
            $tmpEntry['code']     = $entry->code;
            $tmpEntry['url']      = $sso;
            $tmpEntry['open']     = $entry->open;
            $tmpEntry['desc']     = $entry->name;
            $tmpEntry['size']     = $size;
            $tmpEntry['icon']     = $logo;
            $tmpEntry['control']  = $entry->control;
            $tmpEntry['position'] = $entry->position;
            $tmpEntry['menu']     = $menu;
            $tmpEntry['display']  = $display;
            $tmpEntry['abbr']     = $entry->abbr;
            $tmpEntry['order']    = $entry->order;
            $tmpEntry['sys']      = $entry->buildin;
            $tmpEntry['category'] = $entry->category;
            $allEntries[] = $tmpEntry;
        }
        return json_encode($allEntries);
    }

    /**
     * Print entry info.
     *
     * @param  object $entry
     * @param  int    $parent
     * @access public
     * @return void
     */
    public function printInfo($entry, $parent = 0)
    {
        echo "<li data-entryid='{$entry->id}'><div class='text-left row-table'>";
		echo "<div class='col-table w-30px'>";
        if(!$parent) echo "<i class='icon-move sort-handler-1'></i>";
        echo "</div>";
        echo "<div class='col-table w-200px text-ellipsis'>";
        if($parent) echo "<span style='padding:6px 8px'><i class='icon-move sort-handler-2'></i></span>";
        if($entry->logo)
        {
            echo "<div class='avatar avatar-app avatar-sm' data-code='$entry->code'><img src='{$entry->logo}' class='small-icon' /></div> ";
        }
        else
        {
            $name = $entry->abbr ? $entry->abbr : $entry->name;
            $entryName = validater::checkCode(substr($name, 0, 1)) ? strtoupper(substr($name, 0, 1)) : substr($name, 0, 3);
            if(validater::checkCode(substr($name, 0, 1)) and validater::checkCode(substr($name, 1, 1)))   $entryName .= strtoupper(substr($name, 1, 1));
            if(validater::checkCode(substr($name, 0, 1)) and !validater::checkCode(substr($name, 1, 1)))  $entryName .= strtoupper(substr($name, 1, 3));
            if(!validater::checkCode(substr($name, 0, 1)) and validater::checkCode(substr($name, 3, 1)))  $entryName .= strtoupper(substr($name, 3, 1));
            if(!validater::checkCode(substr($name, 0, 1)) and !validater::checkCode(substr($name, 3, 1))) $entryName .= substr($name, 3, 3);
            echo "<div class='avatar avatar-app avatar-sm' data-code='$entry->code' data-id='$entry->id' data-name='$entryName'></div> ";
        }
        echo $entry->name;
        echo "</div>";
        echo "<div class='col-table w-80px'>{$entry->code}</div>";
        echo "<div class='col-table w-80px'>{$entry->version}</div>";
        echo "<div class='col-table w-260px'>" . ($entry->integration ? $entry->key : '') . '</div>';
        echo "<div class='col-table text-center'>{$entry->ip}</div>";
        echo "<div class='col-table w-{$this->lang->entry->actionWidth}px'>";
        echo html::a(helper::createLink('group', 'manageAppPriv', "type=byApp&appCode=$entry->code"), $this->lang->entry->priv);
        echo html::a(helper::createLink('entry', 'style', "code=$entry->code"), $this->lang->entry->style);
        echo html::a(helper::createLink('entry', 'status', "code=$entry->code"), $entry->status == 'online' ? $this->lang->entry->offline : $this->lang->entry->online, 'class="entry-status"');
        if(!$entry->buildin)
        {
            echo html::a(helper::createLink('entry', 'integration', "code=$entry->code"), $this->lang->entry->integration);
            echo html::a(helper::createLink('entry', 'edit', "code=$entry->code"), $this->lang->edit);
            echo html::a(helper::createLink('entry', 'delete', "code=$entry->code"), $this->lang->delete, 'class="entry-deleter"');
        }
        else
        {
            echo html::a('javascript:;', $this->lang->entry->integration, "disabled='disabled'");
            echo html::a(helper::createLink('entry', 'edit', "code=$entry->code"), $this->lang->edit);
            echo html::a('javascript:;', $this->lang->delete, "disabled='disabled'");
        }
        if($entry->zentao) echo html::a(helper::createLink('entry', 'zentaoAdmin', "id={$entry->id}"), $this->lang->entry->bindUser);
        echo '</div></div></li>';
    }
}
